WCT Users (integrators)

Component : WCT_SYSTEM Id : 000

Database Model

Script for database model creation

# phpMyAdmin MySQL-Dump
#
# Host: dbi_model_host Database : dbi_model_db
# --------------------------------------------------------
#
# Table structure for table 'wct000_components'
#
DROP TABLE IF EXISTS wct000_components;
CREATE TABLE wct000_components (
   Id smallint(6) DEFAULT '0' NOT NULL auto_increment,
   code char(3) NOT NULL,
   name varchar(32) NOT NULL,
   registratorName varchar(80),
   registratorMail varchar(80),
   description text,
   date datetime,
   lastupdate datetime,
   version VARCHAR(10),
   devel enum('WORK','ALPHA','BETA','RELEASE','VARIANT','EXTENSION'),
   property enum('PUBLIC','PRIVATE','COPYRIGHT','COMMERCIAL'),
   ranking float(10,2),
   PRIMARY KEY (Id),
   UNIQUE code (code),
   UNIQUE name (name)
);

Script for database model deletion

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

Script for database model cleanup

# Web Component DB Storage Model
# Object Name : WCT_SYSTEM
# Object SQL : Instance cleanup script
# Object ID : 000
# Object Prototype URL : http://www.diml.org/wct/proto/WCT_SYSTEM
# --------------------------------------------------------
DELETE FROM wct000_components;