WCT Users (integrators)

Component : WCT_FORUM Id : 011

Database Model

Script for database model creation

# phpMyAdmin MySQL-Dump
#
# Host: dbi_model_host Database : dbi_model_db
# --------------------------------------------------------
#
# Table structure for table 'wct011_messages'
#
DROP TABLE IF EXISTS wct011_messages;
CREATE TABLE wct011_messages (
   Id smallint(6) DEFAULT '0' NOT NULL auto_increment,
   instance tinyint(4) DEFAULT '0' NOT NULL,
   message text,
   email varchar(80),
   link smallint(6),
   date datetime,
   visa enum('Y','N'),
   abstract varchar(40),
   subtopic varchar(80) NOT NULL,
   notifyme enum('Y','N') DEFAULT 'N' NOT NULL,
   PRIMARY KEY (Id),
   KEY subtopic (subtopic),
   KEY instance (instance)
);

Script for database model deletion

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

Script for database model cleanup

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