WCT Users (integrators)

Component : WCT_BUGS Id : 020

Database Model

Script for database model creation

# phpMyAdmin MySQL-Dump
# http://www.htmlwizard.net/phpMyAdmin/
# --------------------------------------------------------
#
# Web Component DB Storage Model
# Object Name : WCT_BUGS
# Object SQL : Installation script
# Object ID : 020
# Object Prototype URL : http://www.diml.org/wct/proto/WCT_BUGS
# --------------------------------------------------------
# Table structure for table 'wct020_bugs'
#
DROP TABLE IF EXISTS `wct020_bugs`;
CREATE TABLE `wct020_bugs` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `instance` tinyint(4) unsigned NOT NULL default '0',
  `author` varchar(32) NOT NULL default '',
  `title` varchar(255) NOT NULL default '',
  `description` text NOT NULL,
  `severity` tinyint(4) NOT NULL default '0',
  `class` tinyint(4) NOT NULL default '0',
  `postdate` datetime default NULL,
  `startdate` datetime default NULL,
  `enddate` datetime default NULL,
  `status` tinyint(4) NOT NULL default '0',
  `assigned` varchar(32) default NULL,
  `resolution` text,
  `referer` varchar(255) NOT NULL default '',
  `userAgent` varchar(80) NOT NULL default '',
  `contextData` text,
  `notifyMeWhenExamined` enum('yes','no') NOT NULL default 'no',
  `notifyMeWhenStarted` enum('yes','no') NOT NULL default 'no',
  `notifyMeWhenFinished` enum('yes','no') NOT NULL default 'no',
  PRIMARY KEY  (`id`),
  KEY `severity` (`severity`),
  KEY `status` (`status`),
  KEY `assigned` (`assigned`)
) TYPE=MyISAM;

Script for database model deletion

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

Script for database model cleanup

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