WCT Users (integrators)

Component : WCT_GLOSSARY Id : 008

Database Model

Script for database model creation

# phpMyAdmin MySQL-Dump
# http://www.htmlwizard.net/phpMyAdmin/
# --------------------------------------------------------
#
# Web Component DB Storage Model
# Object Name : WCT_GLOSSARY
# Object SQL : Installation script
# Object ID : 008
# Object Prototype URL : http://www.diml.org/wct/proto/WCT_GLOSSARY
# --------------------------------------------------------
# Table structure for table 'wct008_glossary'
#
DROP TABLE IF EXISTS `wct008_glossary`;
CREATE TABLE `wct008_glossary` (
  `Id` smallint(6) NOT NULL auto_increment,
  `instance` smallint(6) NOT NULL default '0',
  `dt` varchar(255) NOT NULL default '',
  `dd` text,
  `stamp` timestamp(14) NOT NULL,
  `submitter` varchar(40) default NULL,
  `links` varchar(255) default NULL,
  `published` enum('yes','no') NOT NULL default 'yes',
  PRIMARY KEY  (`Id`),
  UNIQUE KEY `Insert Bounce Trap` (`instance`,`dt`,`submitter`),
  KEY `instance` (`instance`),
  KEY `definition` (`instance`,`dt`)
) TYPE=MyISAM;

Script for database model deletion

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

Script for database model cleanup

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