From 693b954a679605f3c1ba87d2d68bcd626640a29e Mon Sep 17 00:00:00 2001 From: Robert Sesek Date: Wed, 4 May 2005 06:48:29 +0000 Subject: [PATCH] r70: Start tracking SQL table schema --- docs/bugtrack.sql | 167 ++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 167 insertions(+) create mode 100644 docs/bugtrack.sql diff --git a/docs/bugtrack.sql b/docs/bugtrack.sql new file mode 100644 index 0000000..1c1e4e4 --- /dev/null +++ b/docs/bugtrack.sql @@ -0,0 +1,167 @@ +## SVN $Id$ + +CREATE TABLE `bug` ( + `bugid` int(10) unsigned NOT NULL auto_increment, + `userid` int(10) unsigned NOT NULL default '0', + `dateline` int(20) unsigned NOT NULL default '0', + `productid` int(10) unsigned NOT NULL default '0', + `componentid` int(10) unsigned NOT NULL default '0', + `versionid` int(10) unsigned NOT NULL default '0', + `summary` varchar(255) NOT NULL default '', + `priority` int(10) unsigned NOT NULL default '0', + `severity` int(10) unsigned NOT NULL default '0', + `status` int(10) unsigned NOT NULL default '0', + `resolution` int(10) unsigned NOT NULL default '0', + `assignedto` int(10) unsigned NOT NULL default '0', + `initialreport` int(10) unsigned NOT NULL default '0', + `lastposttime` int(20) unsigned NOT NULL default '0', + `lastpostby` int(10) unsigned NOT NULL default '0', + PRIMARY KEY (`bugid`), + FULLTEXT KEY `summary` (`summary`) +) ENGINE=MyISAM; + +CREATE TABLE `comment` ( + `commentid` int(10) unsigned NOT NULL auto_increment, + `bugid` int(10) unsigned NOT NULL default '0', + `userid` int(10) unsigned NOT NULL default '0', + `dateline` int(20) unsigned NOT NULL default '0', + `comment` mediumtext NOT NULL, + `comment_parsed` mediumtext NOT NULL, + PRIMARY KEY (`commentid`), + FULLTEXT KEY `comment` (`comment`) +) ENGINE=MyISAM; + +CREATE TABLE `datastore` ( + `title` varchar(255) NOT NULL default '', + `data` mediumtext NOT NULL, + PRIMARY KEY (`title`) +) ENGINE=MyISAM; + +CREATE TABLE `dependency` ( + `dependencyid` int(10) unsigned NOT NULL auto_increment, + `bugid` int(10) unsigned NOT NULL default '0', + `dependson` int(10) unsigned NOT NULL default '0', + PRIMARY KEY (`dependencyid`) +) ENGINE=MyISAM; + +CREATE TABLE `language` ( + `languageid` int(10) unsigned NOT NULL auto_increment, + `title` varchar(255) NOT NULL default '', + `languagecode` varchar(5) NOT NULL default '', + `charset` varchar(15) NOT NULL default '', + `direction` char(3) NOT NULL default '', + `default` int(2) unsigned NOT NULL default '0', + `userselect` int(2) unsigned NOT NULL default '0', + `filename` varchar(30) NOT NULL default '', + PRIMARY KEY (`languageid`), + UNIQUE KEY `languagecode` (`languagecode`), + UNIQUE KEY `filename` (`filename`) +) ENGINE=MyISAM; + +CREATE TABLE `locale` ( + `languageid` int(10) unsigned NOT NULL default '0', + `varname` varchar(255) NOT NULL default '', + `phrasetext` mediumtext NOT NULL, + KEY `languageid` (`languageid`) +) ENGINE=MyISAM; + +CREATE TABLE `phrase` ( + `varname` varchar(255) NOT NULL default '', + `phrasetext` mediumtext NOT NULL, + `imported` int(20) unsigned NOT NULL default '0', + UNIQUE KEY `varname` (`varname`) +) ENGINE=MyISAM; + +CREATE TABLE `priority` ( + `priorityid` int(10) unsigned NOT NULL auto_increment, + `priority` varchar(255) NOT NULL default '', + `displayorder` int(10) unsigned NOT NULL default '0', + PRIMARY KEY (`priorityid`) +) ENGINE=MyISAM; + +CREATE TABLE `product` ( + `productid` int(10) unsigned NOT NULL auto_increment, + `componentmother` int(10) unsigned NOT NULL default '0', + `shortname` varchar(255) NOT NULL default '', + `displayorder` int(10) unsigned NOT NULL default '0', + `title` varchar(255) NOT NULL default '', + `description` mediumtext NOT NULL, + PRIMARY KEY (`productid`) +) ENGINE=MyISAM; + +CREATE TABLE `resolution` ( + `resolutionid` int(10) unsigned NOT NULL auto_increment, + `resolution` varchar(255) NOT NULL default '', + `displayorder` int(10) unsigned NOT NULL default '0', + PRIMARY KEY (`resolutionid`) +) ENGINE=MyISAM; + +CREATE TABLE `setting` ( + `varname` varchar(255) NOT NULL default '', + `value` mediumtext NOT NULL, + PRIMARY KEY (`varname`) +) ENGINE=MyISAM; + +CREATE TABLE `severity` ( + `severityid` int(10) unsigned NOT NULL auto_increment, + `severity` varchar(255) NOT NULL default '', + `displayorder` int(10) unsigned NOT NULL default '0', + PRIMARY KEY (`severityid`) +) ENGINE=MyISAM; + +CREATE TABLE `status` ( + `statusid` int(10) unsigned NOT NULL auto_increment, + `status` varchar(255) NOT NULL default '', + `displayorder` int(10) unsigned NOT NULL default '0', + PRIMARY KEY (`statusid`) +) ENGINE=MyISAM; + +CREATE TABLE `templateset` ( + `templatesetid` int(10) unsigned NOT NULL auto_increment, + `title` varchar(255) NOT NULL default '', + `shortname` varchar(50) NOT NULL default '', + `default` int(2) unsigned NOT NULL default '0', + `userselect` int(2) unsigned NOT NULL default '0', + PRIMARY KEY (`templatesetid`), + UNIQUE KEY `title` (`title`) +) ENGINE=MyISAM; + +CREATE TABLE `user` ( + `userid` int(10) unsigned NOT NULL auto_increment, + `email` varchar(255) NOT NULL default '', + `displayname` varchar(255) NOT NULL default '', + `usergroupid` int(10) unsigned NOT NULL default '0', + `password` varchar(32) NOT NULL default '', + `salt` varchar(15) NOT NULL default '', + `authkey` varchar(65) NOT NULL default '', + `showemail` int(2) unsigned NOT NULL default '0', + `languageid` int(10) unsigned NOT NULL default '0', + `timezone` int(4) NOT NULL default '0', + PRIMARY KEY (`userid`) +) ENGINE=MyISAM; + +CREATE TABLE `useractivation` ( + `activator` varchar(25) NOT NULL default '', + `userid` int(10) unsigned NOT NULL default '0', + `dateline` int(10) unsigned NOT NULL default '0', + `usergroupid` int(10) unsigned NOT NULL default '0', + PRIMARY KEY (`activator`) +) ENGINE=MyISAM; + +CREATE TABLE `usergroup` ( + `usergroupid` int(10) unsigned NOT NULL auto_increment, + `title` varchar(255) NOT NULL default '', + `displaytitle` varchar(255) NOT NULL default '', + `opentag` varchar(255) NOT NULL default '', + `closetag` varchar(255) NOT NULL default '', + `permissions` int(10) unsigned NOT NULL default '0', + PRIMARY KEY (`usergroupid`) +) ENGINE=MyISAM DEFAULT PACK_KEYS=0; + +CREATE TABLE `version` ( + `versionid` int(10) unsigned NOT NULL auto_increment, + `productid` int(10) unsigned NOT NULL default '0', + `version` varchar(255) NOT NULL default '', + `displayorder` int(10) unsigned NOT NULL default '0', + PRIMARY KEY (`versionid`) +) ENGINE=MyISAM; \ No newline at end of file -- 2.22.5