WCT Users (integrators)
Component : WCT_EDITABLE
Id : 024
|
|
Database Model
Script for database model creation
# phpMyAdmin MySQL-Dump
# http://www.htmlwizard.net/phpMyAdmin/
# --------------------------------------------------------
#
# Web Component DB Storage Model
# Object Name : WCT_EDITABLE
# Object SQL : Installation script
# Object ID : 024
# Object Prototype URL : http://www.diml.org/wct/proto/WCT_EDITABLE
# --------------------------------------------------------
# Table structure for table 'wct021_wiki'
#
DROP TABLE IF EXISTS `wct024_editable`;
CREATE TABLE `wct024_editable` (
`id` varchar(32) NOT NULL default '0',
`instance` tinyint(4) NOT NULL default '0',
`content` text,
`authors` varchar(255) NOT NULL default '',
`keywords` varchar(255) NOT NULL default '',
`creationDate` datetime NOT NULL default '0000-00-00 00:00:00',
`versionDate` datetime NOT NULL default '0000-00-00 00:00:00',
`versionBy` varchar(64) NOT NULL default '',
`locked` enum('yes','no') NOT NULL default 'no',
`version` smallint(6) NOT NULL default '0',
`major` smallint(6) NOT NULL default '1',
PRIMARY KEY (`id`,`version`,`instance`)
) TYPE=MyISAM;
#
# Structure de la table `wct024_referers`
#
DROP TABLE IF EXISTS `wct024_referers`;
CREATE TABLE `wct024_referers` (
`id` varchar(32) NOT NULL default '0',
`instance` tinyint(4) NOT NULL default '0',
`baseUrl` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`,`instance`)
) TYPE=MyISAM COMMENT='Stores baseUrl for editable records';
Script for database model deletion
# Web Component DB Storage Model
# Object Name : WCT_EDITABLE
# Object SQL : Uninstallation script
# Object ID : 024
# Object Prototype URL : http://www.diml.org/wct/proto/WCT_EDITABLE
# --------------------------------------------------------
DROP TABLE IF EXISTS wct024_editable;
DROP TABLE IF EXISTS wct024_referers;
Script for database model cleanup
# Web Component DB Storage Model
# Object Name : WCT_EDITABLE
# Object SQL : Instance cleanup script
# Object ID : 024
# Object Prototype URL : http://www.diml.org/wct/proto/WCT_EDITABLE
# --------------------------------------------------------
DELETE FROM wct024_editable WHERE instance = <%%WCT_EDITABLE::ID%%>;
DELETE FROM wct024_referers WHERE instance = <%%WCT_EDITABLE::ID%%>;
All material is copyleft V.G. FREMAUX (EISTI France) 1999 to 2003 except explicitly mentioned
|