WCT Users (integrators)

Component : WCT_NEWS Id : 018

Database Model

Script for database model creation

# phpMyAdmin MySQL-Dump
# http://www.htmlwizard.net/phpMyAdmin/
# --------------------------------------------------------
#
# Web Component DB Storage Model
# Object Name : WCT_NEWS
# Object SQL : Installation script
# Object ID : 018
# Object Prototype URL : http://www.diml.org/wct/proto/WCT_NEWS
# --------------------------------------------------------
# Table structure for table 'wct018_news'
#
DROP TABLE IF EXISTS wct018_news;
CREATE TABLE wct018_news (
  id int(11) NOT NULL default '0' PRIMARY KEY auto_increment,
  instance tinyint(4) NOT NULL default '0',
  title varchar(255) NOT NULL default '',
  text text NOT NULL,
  posted datetime NOT NULL default '0000-00-00 00:00:00',
  till datetime NOT NULL default '0000-00-00 00:00:00',
  url varchar(255) NOT NULL default '',
  trigger tinyint(4) NOT NULL default '0',
  author varchar(40) NOT NULL default '',
  published enum('yes','no') NOT NULL default 'yes',
  priority tinyint(4) NOT NULL default '0'
) TYPE=MyISAM;

Script for database model deletion

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

Script for database model cleanup

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