WCT Users (integrators)

Component : WCT_DEBATE Id : 015

Database Model

Script for database model creation

# phpMyAdmin MySQL-Dump
# http://www.htmlwizard.net/phpMyAdmin/
# --------------------------------------------------------
#
# Web Component DB Storage Model
# Object Name : WCT_DEBATE
# Object SQL : Installation script
# Object ID : 015
# Object Prototype URL : http://www.diml.org/wct/proto/WCT_DEBATE
# --------------------------------------------------------
# Table structure for table 'wct015_debate_posts'
#
DROP TABLE IF EXISTS `wct015_debate_history`;
CREATE TABLE `wct015_debate_history` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `instance` smallint(6) unsigned NOT NULL default '0',
  `topic` varchar(80) default NULL,
  `stamp` date NOT NULL default '0000-00-00',
  `x-disagree` int(11) NOT NULL default '0',
  `disagree` int(11) NOT NULL default '0',
  `neutral` int(11) NOT NULL default '0',
  `agree` int(11) NOT NULL default '0',
  `x-agree` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `instance` (`instance`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
DROP TABLE IF EXISTS `wct015_debate_locations`;
CREATE TABLE `wct015_debate_locations` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `instance` smallint(6) unsigned NOT NULL default '0',
  `topic` varchar(80) default 'unattached',
  `url` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `instance` (`instance`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
DROP TABLE IF EXISTS `wct015_debate_posts`;
CREATE TABLE `wct015_debate_posts` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `instance` smallint(6) unsigned NOT NULL default '0',
  `userId` smallint(6) default NULL,
  `email` varchar(80) NOT NULL default '',
  `topic` varchar(80) default 'unattached',
  `text` text,
  `posted` timestamp(14) NOT NULL,
  `opinion` tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `instance` (`instance`),
  KEY `topic` (`topic`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

Script for database model deletion

# Web Component DB Storage Model
# Object Name : WCT_DEBATE
# Object SQL : Uninstallation script
# Object ID : 015
# Object Prototype URL : http://www.diml.org/wct/proto/WCT_DEBATE
# --------------------------------------------------------
DROP TABLE IF EXISTS wct015_debate_posts;
DROP TABLE IF EXISTS wct015_debate_locations;
DROP TABLE IF EXISTS wct015_debate_history;

Script for database model cleanup

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