WCT Users (integrators)
Component : WCT_USERS
Id : 023
|
|
Database Model
Script for database model creation
# phpMyAdmin MySQL-Dump
# http://www.htmlwizard.net/phpMyAdmin/
# --------------------------------------------------------
#
# Web Component DB Storage Model
# Object Name : WCT_PROTO
# Object SQL : Installation script
# Object ID : 003
# Object Prototype URL : http://www.diml.org/wct/proto/WCT_PROTO
# --------------------------------------------------------
# Table structure for table 'wct003_proto'
#
DROP TABLE IF EXISTS wct003_proto;
CREATE TABLE wct003_proto (
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_PROTO
# Object SQL : Uninstallation script
# Object ID : 003
# Object Prototype URL : http://www.diml.org/wct/proto/WCT_PROTO
# --------------------------------------------------------
DROP TABLE IF EXISTS wct003_proto;
Script for database model cleanup
# Web Component DB Storage Model
# Object Name : WCT_PROTO
# Object SQL : Instance cleanup script
# Object ID : 003
# Object Prototype URL : http://www.diml.org/wct/proto/WCT_PROTO
# --------------------------------------------------------
DELETE FROM wct003_proto WHERE instance = <%%WCT_PROTO::ID%%>;
All material is copyleft V.G. FREMAUX (EISTI France) 1999 to 2003 except explicitly mentioned
|