WCT Users (integrators)

Component : WCT_FAQ Id : 010

Database Model

Script for database model creation

# phpMyAdmin MySQL-Dump
# http://www.htmlwizard.net/phpMyAdmin/
#
# Host: localhost Database : authentication
# --------------------------------------------------------
#
# Table structure for table 'wct010_queries'
#
DROP TABLE IF EXISTS wct010_queries;
CREATE TABLE wct010_queries (
   Id bigint(11) DEFAULT '0' NOT NULL auto_increment,
   date timestamp(14),
   status enum('X','Q') DEFAULT 'X' NOT NULL,
   statement varchar(255),
   email varchar(80),
   notifyme enum('Y','N') DEFAULT 'N' NOT NULL,
   instance tinyint(4) DEFAULT '0' NOT NULL,
   answer text,
   PRIMARY KEY (Id),
   KEY instance (instance),
   KEY status (status)
);

Script for database model deletion

# Web Component DB Storage Model
# Object Name : WCT_FAQ
# Object SQL : Uninstallation script
# Object ID : 010
# Object Prototype URL : http://www.diml.org/wct/proto/WCT_FAQ
# --------------------------------------------------------
DROP TABLE IF EXISTS wct010_queries;

Script for database model cleanup

# Web Component DB Storage Model
# Object Name : WCT_FAQ
# Object SQL : Instance cleanup script
# Object ID : 010
# Object Prototype URL : http://www.diml.org/wct/proto/WCT_FAQ
# --------------------------------------------------------
DELETE FROM wct010_queries WHERE instance = <%%WCT_FAQ::ID%%>;