WCT Users (integrators)

Component : WCT_REQS Id : 025

Database Model

Script for database model creation

# phpMyAdmin MySQL-Dump
# http://www.htmlwizard.net/phpMyAdmin/
# --------------------------------------------------------
#
# Web Component DB Storage Model
# Object Name : WCT_REQS
# Object SQL : Installation script
# Object ID : 025
# Object Prototype URL : http://www.diml.org/wct/proto/WCT_REQS
# --------------------------------------------------------
# Table structure for table 'wct025_reqs'
#
DROP TABLE IF EXISTS wct025_reqs;
CREATE TABLE wct003_reqs (
   Id smallint(6) DEFAULT '0' NOT NULL auto_increment,
   instance smallint(6) DEFAULT '0' NOT NULL auto_increment,
   PRIMARY KEY (Id),
   KEY instance (instance)
);

Script for database model deletion

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

Script for database model cleanup

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