WCT Users (integrators)

Component : WCT_QDESK Id : 014

Database Model

Script for database model creation

# phpMyAdmin MySQL-Dump
# http://www.htmlwizard.net/phpMyAdmin/
# --------------------------------------------------------
#
# Web Component DB Storage Model
# Object Name : WCT_QDESK
# Object SQL : Installation script
# Object ID : 014
# Object Prototype URL : http://www.diml.org/wct/proto/WCT_QDESK
# --------------------------------------------------------
# Table structure for table 'wct014_queries'
#
DROP TABLE IF EXISTS wct014_queries;
CREATE TABLE `wct014_queries` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `instance` smallint(6) NOT NULL default '0',
  `gender` enum('M','F','L') default NULL,
  `firstname` varchar(32) NOT NULL default '',
  `lastname` varchar(32) NOT NULL default '',
  `function` varchar(255) default NULL,
  `company` varchar(255) default NULL,
  `address` varchar(255) default NULL,
  `zipcode` varchar(10) default NULL,
  `city` varchar(64) default NULL,
  `country` varchar(8) default NULL,
  `email` varchar(80) NOT NULL default '',
  `fax` varchar(13) default NULL,
  `phone` varchar(13) default NULL,
  `topic` smallint(6) default NULL,
  `options` smallint(6) default NULL,
  `text` text,
  `posted` timestamp(14) NOT NULL,
  `picked` timestamp(14) NOT NULL,
  `resolved` timestamp(14) NOT NULL,
  `status` enum('POSTED','RESOLVED','FORWARDED') NOT NULL default 'POSTED',
  PRIMARY KEY  (`id`),
  KEY `instance` (`instance`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

Script for database model deletion

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

Script for database model cleanup

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