WCT Users (integrators)

Component : WCT_AGENDA Id : 012

Database Model

Script for database model creation

# phpMyAdmin MySQL-Dump
#
# Host: localhost Database : agenda
# --------------------------------------------------------
#
# Table structure for table 'wct012_events'
#
DROP TABLE IF EXISTS wct012_events;
CREATE TABLE wct012_events (
   Id smallint(5) unsigned DEFAULT '0' NOT NULL auto_increment,
   instance tinyint(4) DEFAULT '0' NOT NULL,
   stamp timestamp(14),
   contact varchar(40),
   date date DEFAULT '0000-00-00' NOT NULL,
   time time DEFAULT '00:00:00' NOT NULL,
   location varchar(128) NOT NULL,
   title varchar(128) NOT NULL,
   abstract text,
   thumbnail char(3) DEFAULT 'no',
   thumbnailImage varchar(128),
   memoUrl varchar(128),
   memo text,
   memoDate date DEFAULT '0000-00-00' NOT NULL,
   author varchar(40),
   memoImage varchar(128),
   PRIMARY KEY (Id),
   KEY instance (instance, date, time)
);

Script for database model deletion

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

Script for database model cleanup

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