From Docunext Technology Wiki
-- phpMyAdmin SQL Dump
-- version 2.11.5.1deb1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: May 04, 2008 at 01:54 PM
-- Server version: 5.0.51
-- PHP Version: 5.2.5-3
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
--
-- Database: `bugzilla`
--
-- --------------------------------------------------------
--
-- Table structure for table `attachments`
--
CREATE TABLE IF NOT EXISTS `attachments` (
`attach_id` mediumint(9) NOT NULL auto_increment,
`bug_id` mediumint(9) NOT NULL,
`creation_ts` datetime NOT NULL,
`description` mediumtext NOT NULL,
`mimetype` mediumtext NOT NULL,
`ispatch` tinyint(4) default NULL,
`filename` varchar(100) NOT NULL,
`submitter_id` mediumint(9) NOT NULL,
`isobsolete` tinyint(4) NOT NULL default '0',
`isprivate` tinyint(4) NOT NULL default '0',
`isurl` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`attach_id`),
KEY `attachments_bug_id_idx` (`bug_id`),
KEY `attachments_creation_ts_idx` (`creation_ts`),
KEY `attachments_submitter_id_idx` (`submitter_id`,`bug_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `attach_data`
--
CREATE TABLE IF NOT EXISTS `attach_data` (
`id` mediumint(9) NOT NULL,
`thedata` longblob NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 MAX_ROWS=100000 AVG_ROW_LENGTH=1000000;
-- --------------------------------------------------------
--
-- Table structure for table `bugs`
--
CREATE TABLE IF NOT EXISTS `bugs` (
`bug_id` mediumint(9) NOT NULL auto_increment,
`assigned_to` mediumint(9) NOT NULL,
`bug_file_loc` text,
`bug_severity` varchar(64) NOT NULL,
`bug_status` varchar(64) NOT NULL,
`creation_ts` datetime default NULL,
`delta_ts` datetime NOT NULL,
`short_desc` mediumtext NOT NULL,
`op_sys` varchar(64) NOT NULL,
`priority` varchar(64) NOT NULL,
`product_id` smallint(6) NOT NULL,
`rep_platform` varchar(64) NOT NULL,
`reporter` mediumint(9) NOT NULL,
`version` varchar(64) NOT NULL,
`component_id` smallint(6) NOT NULL,
`resolution` varchar(64) NOT NULL default '',
`target_milestone` varchar(20) NOT NULL default '---',
`qa_contact` mediumint(9) default NULL,
`status_whiteboard` mediumtext NOT NULL,
`votes` mediumint(9) NOT NULL default '0',
`keywords` mediumtext NOT NULL,
`lastdiffed` datetime default NULL,
`everconfirmed` tinyint(4) NOT NULL,
`reporter_accessible` tinyint(4) NOT NULL default '1',
`cclist_accessible` tinyint(4) NOT NULL default '1',
`estimated_time` decimal(5,2) NOT NULL default '0.00',
`remaining_time` decimal(5,2) NOT NULL default '0.00',
`deadline` datetime default NULL,
`alias` varchar(20) default NULL,
PRIMARY KEY (`bug_id`),
UNIQUE KEY `bugs_alias_idx` (`alias`),
KEY `bugs_assigned_to_idx` (`assigned_to`),
KEY `bugs_creation_ts_idx` (`creation_ts`),
KEY `bugs_delta_ts_idx` (`delta_ts`),
KEY `bugs_bug_severity_idx` (`bug_severity`),
KEY `bugs_bug_status_idx` (`bug_status`),
KEY `bugs_op_sys_idx` (`op_sys`),
KEY `bugs_priority_idx` (`priority`),
KEY `bugs_product_id_idx` (`product_id`),
KEY `bugs_reporter_idx` (`reporter`),
KEY `bugs_version_idx` (`version`),
KEY `bugs_component_id_idx` (`component_id`),
KEY `bugs_resolution_idx` (`resolution`),
KEY `bugs_target_milestone_idx` (`target_milestone`),
KEY `bugs_qa_contact_idx` (`qa_contact`),
KEY `bugs_votes_idx` (`votes`),
FULLTEXT KEY `bugs_short_desc_idx` (`short_desc`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `bugs_activity`
--
CREATE TABLE IF NOT EXISTS `bugs_activity` (
`bug_id` mediumint(9) NOT NULL,
`attach_id` mediumint(9) default NULL,
`who` mediumint(9) NOT NULL,
`bug_when` datetime NOT NULL,
`fieldid` mediumint(9) NOT NULL,
`added` tinytext,
`removed` tinytext,
KEY `bugs_activity_bug_id_idx` (`bug_id`),
KEY `bugs_activity_who_idx` (`who`),
KEY `bugs_activity_bug_when_idx` (`bug_when`),
KEY `bugs_activity_fieldid_idx` (`fieldid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `bug_group_map`
--
CREATE TABLE IF NOT EXISTS `bug_group_map` (
`bug_id` mediumint(9) NOT NULL,
`group_id` mediumint(9) NOT NULL,
UNIQUE KEY `bug_group_map_bug_id_idx` (`bug_id`,`group_id`),
KEY `bug_group_map_group_id_idx` (`group_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `bug_severity`
--
CREATE TABLE IF NOT EXISTS `bug_severity` (
`id` smallint(6) NOT NULL auto_increment,
`value` varchar(64) NOT NULL,
`sortkey` smallint(6) NOT NULL default '0',
`isactive` tinyint(4) NOT NULL default '1',
PRIMARY KEY (`id`),
UNIQUE KEY `bug_severity_value_idx` (`value`),
KEY `bug_severity_sortkey_idx` (`sortkey`,`value`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;
-- --------------------------------------------------------
--
-- Table structure for table `bug_status`
--
CREATE TABLE IF NOT EXISTS `bug_status` (
`id` smallint(6) NOT NULL auto_increment,
`value` varchar(64) NOT NULL,
`sortkey` smallint(6) NOT NULL default '0',
`isactive` tinyint(4) NOT NULL default '1',
PRIMARY KEY (`id`),
UNIQUE KEY `bug_status_value_idx` (`value`),
KEY `bug_status_sortkey_idx` (`sortkey`,`value`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;
-- --------------------------------------------------------
--
-- Table structure for table `bz_schema`
--
CREATE TABLE IF NOT EXISTS `bz_schema` (
`schema_data` longblob NOT NULL,
`version` decimal(3,2) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `category_group_map`
--
CREATE TABLE IF NOT EXISTS `category_group_map` (
`category_id` smallint(6) NOT NULL,
`group_id` mediumint(9) NOT NULL,
UNIQUE KEY `category_group_map_category_id_idx` (`category_id`,`group_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `cc`
--
CREATE TABLE IF NOT EXISTS `cc` (
`bug_id` mediumint(9) NOT NULL,
`who` mediumint(9) NOT NULL,
UNIQUE KEY `cc_bug_id_idx` (`bug_id`,`who`),
KEY `cc_who_idx` (`who`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `classifications`
--
CREATE TABLE IF NOT EXISTS `classifications` (
`id` smallint(6) NOT NULL auto_increment,
`name` varchar(64) NOT NULL,
`description` mediumtext,
PRIMARY KEY (`id`),
UNIQUE KEY `classifications_name_idx` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
-- --------------------------------------------------------
--
-- Table structure for table `components`
--
CREATE TABLE IF NOT EXISTS `components` (
`id` smallint(6) NOT NULL auto_increment,
`name` varchar(64) NOT NULL,
`product_id` smallint(6) NOT NULL,
`initialowner` mediumint(9) NOT NULL,
`initialqacontact` mediumint(9) default NULL,
`description` mediumtext NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `components_product_id_idx` (`product_id`,`name`),
KEY `components_name_idx` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
-- --------------------------------------------------------
--
-- Table structure for table `dependencies`
--
CREATE TABLE IF NOT EXISTS `dependencies` (
`blocked` mediumint(9) NOT NULL,
`dependson` mediumint(9) NOT NULL,
KEY `dependencies_blocked_idx` (`blocked`),
KEY `dependencies_dependson_idx` (`dependson`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `duplicates`
--
CREATE TABLE IF NOT EXISTS `duplicates` (
`dupe_of` mediumint(9) NOT NULL,
`dupe` mediumint(9) NOT NULL,
PRIMARY KEY (`dupe`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `email_setting`
--
CREATE TABLE IF NOT EXISTS `email_setting` (
`user_id` mediumint(9) NOT NULL,
`relationship` tinyint(4) NOT NULL,
`event` tinyint(4) NOT NULL,
UNIQUE KEY `email_setting_user_id_idx` (`user_id`,`relationship`,`event`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `fielddefs`
--
CREATE TABLE IF NOT EXISTS `fielddefs` (
`fieldid` mediumint(9) NOT NULL auto_increment,
`name` varchar(64) NOT NULL,
`description` mediumtext NOT NULL,
`mailhead` tinyint(4) NOT NULL default '0',
`sortkey` smallint(6) NOT NULL,
`obsolete` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`fieldid`),
UNIQUE KEY `fielddefs_name_idx` (`name`),
KEY `fielddefs_sortkey_idx` (`sortkey`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=52 ;
-- --------------------------------------------------------
--
-- Table structure for table `flagexclusions`
--
CREATE TABLE IF NOT EXISTS `flagexclusions` (
`type_id` smallint(6) NOT NULL,
`product_id` smallint(6) default NULL,
`component_id` smallint(6) default NULL,
KEY `flagexclusions_type_id_idx` (`type_id`,`product_id`,`component_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `flaginclusions`
--
CREATE TABLE IF NOT EXISTS `flaginclusions` (
`type_id` smallint(6) NOT NULL,
`product_id` smallint(6) default NULL,
`component_id` smallint(6) default NULL,
KEY `flaginclusions_type_id_idx` (`type_id`,`product_id`,`component_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `flags`
--
CREATE TABLE IF NOT EXISTS `flags` (
`id` mediumint(9) NOT NULL,
`type_id` smallint(6) NOT NULL,
`status` char(1) NOT NULL,
`bug_id` mediumint(9) NOT NULL,
`attach_id` mediumint(9) default NULL,
`creation_date` datetime NOT NULL,
`modification_date` datetime default NULL,
`setter_id` mediumint(9) default NULL,
`requestee_id` mediumint(9) default NULL,
`is_active` tinyint(4) NOT NULL default '1',
PRIMARY KEY (`id`),
KEY `flags_bug_id_idx` (`bug_id`,`attach_id`),
KEY `flags_setter_id_idx` (`setter_id`),
KEY `flags_requestee_id_idx` (`requestee_id`),
KEY `flags_type_id_idx` (`type_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `flagtypes`
--
CREATE TABLE IF NOT EXISTS `flagtypes` (
`id` smallint(6) NOT NULL,
`name` varchar(50) NOT NULL,
`description` text,
`cc_list` varchar(200) default NULL,
`target_type` char(1) NOT NULL default 'b',
`is_active` tinyint(4) NOT NULL default '1',
`is_requestable` tinyint(4) NOT NULL default '0',
`is_requesteeble` tinyint(4) NOT NULL default '0',
`is_multiplicable` tinyint(4) NOT NULL default '0',
`sortkey` smallint(6) NOT NULL default '0',
`grant_group_id` mediumint(9) default NULL,
`request_group_id` mediumint(9) default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `groups`
--
CREATE TABLE IF NOT EXISTS `groups` (
`id` mediumint(9) NOT NULL auto_increment,
`name` varchar(255) NOT NULL,
`description` text NOT NULL,
`isbuggroup` tinyint(4) NOT NULL,
`last_changed` datetime NOT NULL,
`userregexp` tinytext NOT NULL,
`isactive` tinyint(4) NOT NULL default '1',
PRIMARY KEY (`id`),
UNIQUE KEY `groups_name_idx` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=14 ;
-- --------------------------------------------------------
--
-- Table structure for table `group_control_map`
--
CREATE TABLE IF NOT EXISTS `group_control_map` (
`group_id` mediumint(9) NOT NULL,
`product_id` mediumint(9) NOT NULL,
`entry` tinyint(4) NOT NULL,
`membercontrol` tinyint(4) NOT NULL,
`othercontrol` tinyint(4) NOT NULL,
`canedit` tinyint(4) NOT NULL,
UNIQUE KEY `group_control_map_product_id_idx` (`product_id`,`group_id`),
KEY `group_control_map_group_id_idx` (`group_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `group_group_map`
--
CREATE TABLE IF NOT EXISTS `group_group_map` (
`member_id` mediumint(9) NOT NULL,
`grantor_id` mediumint(9) NOT NULL,
`grant_type` tinyint(4) NOT NULL default '0',
UNIQUE KEY `group_group_map_member_id_idx` (`member_id`,`grantor_id`,`grant_type`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `keyworddefs`
--
CREATE TABLE IF NOT EXISTS `keyworddefs` (
`id` smallint(6) NOT NULL,
`name` varchar(64) NOT NULL,
`description` mediumtext,
PRIMARY KEY (`id`),
UNIQUE KEY `keyworddefs_name_idx` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `keywords`
--
CREATE TABLE IF NOT EXISTS `keywords` (
`bug_id` mediumint(9) NOT NULL,
`keywordid` smallint(6) NOT NULL,
UNIQUE KEY `keywords_bug_id_idx` (`bug_id`,`keywordid`),
KEY `keywords_keywordid_idx` (`keywordid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `logincookies`
--
CREATE TABLE IF NOT EXISTS `logincookies` (
`cookie` varchar(16) NOT NULL,
`userid` mediumint(9) NOT NULL,
`ipaddr` varchar(40) NOT NULL,
`lastused` datetime NOT NULL,
PRIMARY KEY (`cookie`),
KEY `logincookies_lastused_idx` (`lastused`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `longdescs`
--
CREATE TABLE IF NOT EXISTS `longdescs` (
`bug_id` mediumint(9) NOT NULL,
`who` mediumint(9) NOT NULL,
`bug_when` datetime NOT NULL,
`work_time` decimal(5,2) NOT NULL default '0.00',
`thetext` mediumtext,
`isprivate` tinyint(4) NOT NULL default '0',
`already_wrapped` tinyint(4) NOT NULL default '0',
KEY `longdescs_bug_id_idx` (`bug_id`),
KEY `longdescs_who_idx` (`who`),
KEY `longdescs_bug_when_idx` (`bug_when`),
FULLTEXT KEY `longdescs_thetext_idx` (`thetext`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `milestones`
--
CREATE TABLE IF NOT EXISTS `milestones` (
`product_id` smallint(6) NOT NULL,
`value` varchar(20) NOT NULL,
`sortkey` smallint(6) NOT NULL default '0',
UNIQUE KEY `milestones_product_id_idx` (`product_id`,`value`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `namedqueries`
--
CREATE TABLE IF NOT EXISTS `namedqueries` (
`userid` mediumint(9) NOT NULL,
`name` varchar(64) NOT NULL,
`linkinfooter` tinyint(4) NOT NULL,
`query` mediumtext NOT NULL,
`query_type` tinyint(4) NOT NULL,
UNIQUE KEY `namedqueries_userid_idx` (`userid`,`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `op_sys`
--
CREATE TABLE IF NOT EXISTS `op_sys` (
`id` smallint(6) NOT NULL auto_increment,
`value` varchar(64) NOT NULL,
`sortkey` smallint(6) NOT NULL default '0',
`isactive` tinyint(4) NOT NULL default '1',
PRIMARY KEY (`id`),
UNIQUE KEY `op_sys_value_idx` (`value`),
KEY `op_sys_sortkey_idx` (`sortkey`,`value`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;
-- --------------------------------------------------------
--
-- Table structure for table `priority`
--
CREATE TABLE IF NOT EXISTS `priority` (
`id` smallint(6) NOT NULL auto_increment,
`value` varchar(64) NOT NULL,
`sortkey` smallint(6) NOT NULL default '0',
`isactive` tinyint(4) NOT NULL default '1',
PRIMARY KEY (`id`),
UNIQUE KEY `priority_value_idx` (`value`),
KEY `priority_sortkey_idx` (`sortkey`,`value`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;
-- --------------------------------------------------------
--
-- Table structure for table `products`
--
CREATE TABLE IF NOT EXISTS `products` (
`id` smallint(6) NOT NULL auto_increment,
`name` varchar(64) NOT NULL,
`classification_id` smallint(6) NOT NULL default '1',
`description` mediumtext,
`milestoneurl` tinytext NOT NULL,
`disallownew` tinyint(4) NOT NULL,
`votesperuser` smallint(6) NOT NULL,
`maxvotesperbug` smallint(6) NOT NULL default '10000',
`votestoconfirm` smallint(6) NOT NULL,
`defaultmilestone` varchar(20) NOT NULL default '---',
PRIMARY KEY (`id`),
UNIQUE KEY `products_name_idx` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
-- --------------------------------------------------------
--
-- Table structure for table `profiles`
--
CREATE TABLE IF NOT EXISTS `profiles` (
`userid` mediumint(9) NOT NULL auto_increment,
`login_name` varchar(255) NOT NULL,
`cryptpassword` varchar(128) default NULL,
`realname` varchar(255) default NULL,
`disabledtext` mediumtext NOT NULL,
`mybugslink` tinyint(4) NOT NULL default '1',
`refreshed_when` datetime NOT NULL,
`extern_id` varchar(64) default NULL,
PRIMARY KEY (`userid`),
UNIQUE KEY `profiles_login_name_idx` (`login_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
-- --------------------------------------------------------
--
-- Table structure for table `profiles_activity`
--
CREATE TABLE IF NOT EXISTS `profiles_activity` (
`userid` mediumint(9) NOT NULL,
`who` mediumint(9) NOT NULL,
`profiles_when` datetime NOT NULL,
`fieldid` mediumint(9) NOT NULL,
`oldvalue` tinytext,
`newvalue` tinytext,
KEY `profiles_activity_userid_idx` (`userid`),
KEY `profiles_activity_profiles_when_idx` (`profiles_when`),
KEY `profiles_activity_fieldid_idx` (`fieldid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `profile_setting`
--
CREATE TABLE IF NOT EXISTS `profile_setting` (
`user_id` mediumint(9) NOT NULL,
`setting_name` varchar(32) NOT NULL,
`setting_value` varchar(32) NOT NULL,
UNIQUE KEY `profile_setting_value_unique_idx` (`user_id`,`setting_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `quips`
--
CREATE TABLE IF NOT EXISTS `quips` (
`quipid` mediumint(9) NOT NULL auto_increment,
`userid` mediumint(9) default NULL,
`quip` text NOT NULL,
`approved` tinyint(4) NOT NULL default '1',
PRIMARY KEY (`quipid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
-- --------------------------------------------------------
--
-- Table structure for table `rep_platform`
--
CREATE TABLE IF NOT EXISTS `rep_platform` (
`id` smallint(6) NOT NULL auto_increment,
`value` varchar(64) NOT NULL,
`sortkey` smallint(6) NOT NULL default '0',
`isactive` tinyint(4) NOT NULL default '1',
PRIMARY KEY (`id`),
UNIQUE KEY `rep_platform_value_idx` (`value`),
KEY `rep_platform_sortkey_idx` (`sortkey`,`value`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
-- --------------------------------------------------------
--
-- Table structure for table `resolution`
--
CREATE TABLE IF NOT EXISTS `resolution` (
`id` smallint(6) NOT NULL auto_increment,
`value` varchar(64) NOT NULL,
`sortkey` smallint(6) NOT NULL default '0',
`isactive` tinyint(4) NOT NULL default '1',
PRIMARY KEY (`id`),
UNIQUE KEY `resolution_value_idx` (`value`),
KEY `resolution_sortkey_idx` (`sortkey`,`value`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;
-- --------------------------------------------------------
--
-- Table structure for table `series`
--
CREATE TABLE IF NOT EXISTS `series` (
`series_id` mediumint(9) NOT NULL auto_increment,
`creator` mediumint(9) NOT NULL,
`category` smallint(6) NOT NULL,
`subcategory` smallint(6) NOT NULL,
`name` varchar(64) NOT NULL,
`frequency` smallint(6) NOT NULL,
`last_viewed` datetime default NULL,
`query` mediumtext NOT NULL,
`is_public` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`series_id`),
UNIQUE KEY `series_creator_idx` (`creator`,`category`,`subcategory`,`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=33 ;
-- --------------------------------------------------------
--
-- Table structure for table `series_categories`
--
CREATE TABLE IF NOT EXISTS `series_categories` (
`id` smallint(6) NOT NULL auto_increment,
`name` varchar(64) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `series_categories_name_idx` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
-- --------------------------------------------------------
--
-- Table structure for table `series_data`
--
CREATE TABLE IF NOT EXISTS `series_data` (
`series_id` mediumint(9) NOT NULL,
`series_date` datetime NOT NULL,
`series_value` mediumint(9) NOT NULL,
UNIQUE KEY `series_data_series_id_idx` (`series_id`,`series_date`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `setting`
--
CREATE TABLE IF NOT EXISTS `setting` (
`name` varchar(32) NOT NULL,
`default_value` varchar(32) NOT NULL,
`is_enabled` tinyint(4) NOT NULL default '1',
PRIMARY KEY (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `setting_value`
--
CREATE TABLE IF NOT EXISTS `setting_value` (
`name` varchar(32) NOT NULL,
`value` varchar(32) NOT NULL,
`sortindex` smallint(6) NOT NULL,
UNIQUE KEY `setting_value_nv_unique_idx` (`name`,`value`),
UNIQUE KEY `setting_value_ns_unique_idx` (`name`,`sortindex`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `tokens`
--
CREATE TABLE IF NOT EXISTS `tokens` (
`userid` mediumint(9) NOT NULL,
`issuedate` datetime NOT NULL,
`token` varchar(16) NOT NULL,
`tokentype` varchar(8) NOT NULL,
`eventdata` tinytext,
PRIMARY KEY (`token`),
KEY `tokens_userid_idx` (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `user_group_map`
--
CREATE TABLE IF NOT EXISTS `user_group_map` (
`user_id` mediumint(9) NOT NULL,
`group_id` mediumint(9) NOT NULL,
`isbless` tinyint(4) NOT NULL default '0',
`grant_type` tinyint(4) NOT NULL default '0',
UNIQUE KEY `user_group_map_user_id_idx` (`user_id`,`group_id`,`grant_type`,`isbless`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `versions`
--
CREATE TABLE IF NOT EXISTS `versions` (
`value` varchar(64) NOT NULL,
`product_id` smallint(6) NOT NULL,
UNIQUE KEY `versions_product_id_idx` (`product_id`,`value`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `votes`
--
CREATE TABLE IF NOT EXISTS `votes` (
`who` mediumint(9) NOT NULL,
`bug_id` mediumint(9) NOT NULL,
`vote_count` smallint(6) NOT NULL,
KEY `votes_who_idx` (`who`),
KEY `votes_bug_id_idx` (`bug_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `watch`
--
CREATE TABLE IF NOT EXISTS `watch` (
`watcher` mediumint(9) NOT NULL,
`watched` mediumint(9) NOT NULL,
UNIQUE KEY `watch_watcher_idx` (`watcher`,`watched`),
KEY `watch_watched_idx` (`watched`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `whine_events`
--
CREATE TABLE IF NOT EXISTS `whine_events` (
`id` mediumint(9) NOT NULL auto_increment,
`owner_userid` mediumint(9) NOT NULL,
`subject` varchar(128) default NULL,
`body` mediumtext,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `whine_queries`
--
CREATE TABLE IF NOT EXISTS `whine_queries` (
`id` mediumint(9) NOT NULL auto_increment,
`eventid` mediumint(9) NOT NULL,
`query_name` varchar(64) NOT NULL default '',
`sortkey` smallint(6) NOT NULL default '0',
`onemailperbug` tinyint(4) NOT NULL default '0',
`title` varchar(128) NOT NULL default '',
PRIMARY KEY (`id`),
KEY `whine_queries_eventid_idx` (`eventid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `whine_schedules`
--
CREATE TABLE IF NOT EXISTS `whine_schedules` (
`id` mediumint(9) NOT NULL auto_increment,
`eventid` mediumint(9) NOT NULL,
`run_day` varchar(32) default NULL,
`run_time` varchar(32) default NULL,
`run_next` datetime default NULL,
`mailto` mediumint(9) NOT NULL,
`mailto_type` smallint(6) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `whine_schedules_run_next_idx` (`run_next`),
KEY `whine_schedules_eventid_idx` (`eventid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;