WCT Users (integrators)

Component : WCT_WIKI Id : 021

Database Model

Script for database model creation

# phpMyAdmin MySQL-Dump
# http://www.htmlwizard.net/phpMyAdmin/
# --------------------------------------------------------
#
# Web Component DB Storage Model
# Object Name : WCT_WIKI
# Object SQL : Installation script
# Object ID : 021
# Object Prototype URL : http://www.diml.org/wct/proto/WCT_WIKI
# --------------------------------------------------------
# Table structure for table 'wct021_wiki'
#
DROP TABLE IF EXISTS wct021_wiki;
CREATE TABLE wct021_wiki (
   id smallint(6) DEFAULT '0' NOT NULL auto_increment,
   instance smallint(6) DEFAULT '0' NOT NULL,
   version int(11) DEFAULT '0' NOT NULL,
   name varchar(32),
   title varchar(255),
   content text,
   created timestamp,
   lastmodified timestamp,
   lastmodified timestamp,
   author varchar(32),
   creator varchar(32),
   keywords varchar(255),
   isfreeaccess ENUM('yes','no'),
   isfreeupdate ENUM('yes','no'),
   PRIMARY KEY (id,version),
   KEY instance (instance)
);

Script for database model deletion

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

Script for database model cleanup

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