iC14bs4U

1-- MySQL dump 10.13  Distrib 5.7.21, for Linux (x86_64)
2--
3-- Host: localhost    Database: bugs
4-- ------------------------------------------------------
5-- Server version	5.7.21-0ubuntu0.16.04.1
6
7/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10/*!40101 SET NAMES utf8 */;
11/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12/*!40103 SET TIME_ZONE='+00:00' */;
13/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17
18--
19-- Table structure for table `attach_data`
20--
21
22DROP TABLE IF EXISTS `attach_data`;
23/*!40101 SET @saved_cs_client     = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `attach_data` (
26  `id` mediumint(9) NOT NULL,
27  `thedata` longblob NOT NULL,
28  PRIMARY KEY (`id`),
29  CONSTRAINT `fk_attach_data_id_attachments_attach_id` FOREIGN KEY (`id`) REFERENCES `attachments` (`attach_id`) ON DELETE CASCADE ON UPDATE CASCADE
30) ENGINE=InnoDB DEFAULT CHARSET=utf8 MAX_ROWS=100000 AVG_ROW_LENGTH=1000000;
31/*!40101 SET character_set_client = @saved_cs_client */;
32
33--
34-- Dumping data for table `attach_data`
35--
36
37LOCK TABLES `attach_data` WRITE;
38/*!40000 ALTER TABLE `attach_data` DISABLE KEYS */;
39/*!40000 ALTER TABLE `attach_data` ENABLE KEYS */;
40UNLOCK TABLES;
41
42--
43-- Table structure for table `attachments`
44--
45
46DROP TABLE IF EXISTS `attachments`;
47/*!40101 SET @saved_cs_client     = @@character_set_client */;
48/*!40101 SET character_set_client = utf8 */;
49CREATE TABLE `attachments` (
50  `attach_id` mediumint(9) NOT NULL AUTO_INCREMENT,
51  `bug_id` mediumint(9) NOT NULL,
52  `creation_ts` datetime NOT NULL,
53  `modification_time` datetime NOT NULL,
54  `description` tinytext NOT NULL,
55  `mimetype` tinytext NOT NULL,
56  `ispatch` tinyint(4) NOT NULL DEFAULT '0',
57  `filename` varchar(255) NOT NULL,
58  `submitter_id` mediumint(9) NOT NULL,
59  `isobsolete` tinyint(4) NOT NULL DEFAULT '0',
60  `isprivate` tinyint(4) NOT NULL DEFAULT '0',
61  PRIMARY KEY (`attach_id`),
62  KEY `attachments_bug_id_idx` (`bug_id`),
63  KEY `attachments_creation_ts_idx` (`creation_ts`),
64  KEY `attachments_modification_time_idx` (`modification_time`),
65  KEY `attachments_submitter_id_idx` (`submitter_id`,`bug_id`),
66  CONSTRAINT `fk_attachments_bug_id_bugs_bug_id` FOREIGN KEY (`bug_id`) REFERENCES `bugs` (`bug_id`) ON DELETE CASCADE ON UPDATE CASCADE,
67  CONSTRAINT `fk_attachments_submitter_id_profiles_userid` FOREIGN KEY (`submitter_id`) REFERENCES `profiles` (`userid`) ON UPDATE CASCADE
68) ENGINE=InnoDB DEFAULT CHARSET=utf8;
69/*!40101 SET character_set_client = @saved_cs_client */;
70
71--
72-- Dumping data for table `attachments`
73--
74
75LOCK TABLES `attachments` WRITE;
76/*!40000 ALTER TABLE `attachments` DISABLE KEYS */;
77/*!40000 ALTER TABLE `attachments` ENABLE KEYS */;
78UNLOCK TABLES;
79
80--
81-- Table structure for table `audit_log`
82--
83
84DROP TABLE IF EXISTS `audit_log`;
85/*!40101 SET @saved_cs_client     = @@character_set_client */;
86/*!40101 SET character_set_client = utf8 */;
87CREATE TABLE `audit_log` (
88  `user_id` mediumint(9) DEFAULT NULL,
89  `class` varchar(255) NOT NULL,
90  `object_id` int(11) NOT NULL,
91  `field` varchar(64) NOT NULL,
92  `removed` mediumtext,
93  `added` mediumtext,
94  `at_time` datetime NOT NULL,
95  KEY `audit_log_class_idx` (`class`,`at_time`),
96  KEY `fk_audit_log_user_id_profiles_userid` (`user_id`),
97  CONSTRAINT `fk_audit_log_user_id_profiles_userid` FOREIGN KEY (`user_id`) REFERENCES `profiles` (`userid`) ON DELETE SET NULL ON UPDATE CASCADE
98) ENGINE=InnoDB DEFAULT CHARSET=utf8;
99/*!40101 SET character_set_client = @saved_cs_client */;
100
101--
102-- Dumping data for table `audit_log`
103--
104
105LOCK TABLES `audit_log` WRITE;
106/*!40000 ALTER TABLE `audit_log` DISABLE KEYS */;
107INSERT INTO `audit_log` VALUES (NULL,'Bugzilla::Field',1,'__create__',NULL,'bug_id','2018-04-10 16:31:32'),(NULL,'Bugzilla::Field',2,'__create__',NULL,'short_desc','2018-04-10 16:31:32'),(NULL,'Bugzilla::Field',3,'__create__',NULL,'classification','2018-04-10 16:31:33'),(NULL,'Bugzilla::Field',4,'__create__',NULL,'product','2018-04-10 16:31:33'),(NULL,'Bugzilla::Field',5,'__create__',NULL,'version','2018-04-10 16:31:33'),(NULL,'Bugzilla::Field',6,'__create__',NULL,'rep_platform','2018-04-10 16:31:33'),(NULL,'Bugzilla::Field',7,'__create__',NULL,'bug_file_loc','2018-04-10 16:31:33'),(NULL,'Bugzilla::Field',8,'__create__',NULL,'op_sys','2018-04-10 16:31:33'),(NULL,'Bugzilla::Field',9,'__create__',NULL,'bug_status','2018-04-10 16:31:33'),(NULL,'Bugzilla::Field',10,'__create__',NULL,'status_whiteboard','2018-04-10 16:31:33'),(NULL,'Bugzilla::Field',11,'__create__',NULL,'keywords','2018-04-10 16:31:33'),(NULL,'Bugzilla::Field',12,'__create__',NULL,'resolution','2018-04-10 16:31:33'),(NULL,'Bugzilla::Field',13,'__create__',NULL,'bug_severity','2018-04-10 16:31:33'),(NULL,'Bugzilla::Field',14,'__create__',NULL,'priority','2018-04-10 16:31:33'),(NULL,'Bugzilla::Field',15,'__create__',NULL,'component','2018-04-10 16:31:33'),(NULL,'Bugzilla::Field',16,'__create__',NULL,'assigned_to','2018-04-10 16:31:33'),(NULL,'Bugzilla::Field',17,'__create__',NULL,'reporter','2018-04-10 16:31:33'),(NULL,'Bugzilla::Field',18,'__create__',NULL,'qa_contact','2018-04-10 16:31:33'),(NULL,'Bugzilla::Field',19,'__create__',NULL,'assigned_to_realname','2018-04-10 16:31:33'),(NULL,'Bugzilla::Field',20,'__create__',NULL,'reporter_realname','2018-04-10 16:31:33'),(NULL,'Bugzilla::Field',21,'__create__',NULL,'qa_contact_realname','2018-04-10 16:31:33'),(NULL,'Bugzilla::Field',22,'__create__',NULL,'cc','2018-04-10 16:31:33'),(NULL,'Bugzilla::Field',23,'__create__',NULL,'dependson','2018-04-10 16:31:33'),(NULL,'Bugzilla::Field',24,'__create__',NULL,'blocked','2018-04-10 16:31:33'),(NULL,'Bugzilla::Field',25,'__create__',NULL,'attachments.description','2018-04-10 16:31:33'),(NULL,'Bugzilla::Field',26,'__create__',NULL,'attachments.filename','2018-04-10 16:31:33'),(NULL,'Bugzilla::Field',27,'__create__',NULL,'attachments.mimetype','2018-04-10 16:31:33'),(NULL,'Bugzilla::Field',28,'__create__',NULL,'attachments.ispatch','2018-04-10 16:31:33'),(NULL,'Bugzilla::Field',29,'__create__',NULL,'attachments.isobsolete','2018-04-10 16:31:33'),(NULL,'Bugzilla::Field',30,'__create__',NULL,'attachments.isprivate','2018-04-10 16:31:33'),(NULL,'Bugzilla::Field',31,'__create__',NULL,'attachments.submitter','2018-04-10 16:31:33'),(NULL,'Bugzilla::Field',32,'__create__',NULL,'target_milestone','2018-04-10 16:31:33'),(NULL,'Bugzilla::Field',33,'__create__',NULL,'creation_ts','2018-04-10 16:31:33'),(NULL,'Bugzilla::Field',34,'__create__',NULL,'delta_ts','2018-04-10 16:31:33'),(NULL,'Bugzilla::Field',35,'__create__',NULL,'longdesc','2018-04-10 16:31:33'),(NULL,'Bugzilla::Field',36,'__create__',NULL,'longdescs.isprivate','2018-04-10 16:31:33'),(NULL,'Bugzilla::Field',37,'__create__',NULL,'longdescs.count','2018-04-10 16:31:33'),(NULL,'Bugzilla::Field',38,'__create__',NULL,'alias','2018-04-10 16:31:33'),(NULL,'Bugzilla::Field',39,'__create__',NULL,'everconfirmed','2018-04-10 16:31:33'),(NULL,'Bugzilla::Field',40,'__create__',NULL,'reporter_accessible','2018-04-10 16:31:33'),(NULL,'Bugzilla::Field',41,'__create__',NULL,'cclist_accessible','2018-04-10 16:31:33'),(NULL,'Bugzilla::Field',42,'__create__',NULL,'bug_group','2018-04-10 16:31:33'),(NULL,'Bugzilla::Field',43,'__create__',NULL,'estimated_time','2018-04-10 16:31:33'),(NULL,'Bugzilla::Field',44,'__create__',NULL,'remaining_time','2018-04-10 16:31:33'),(NULL,'Bugzilla::Field',45,'__create__',NULL,'deadline','2018-04-10 16:31:33'),(NULL,'Bugzilla::Field',46,'__create__',NULL,'commenter','2018-04-10 16:31:33'),(NULL,'Bugzilla::Field',47,'__create__',NULL,'flagtypes.name','2018-04-10 16:31:33'),(NULL,'Bugzilla::Field',48,'__create__',NULL,'requestees.login_name','2018-04-10 16:31:33'),(NULL,'Bugzilla::Field',49,'__create__',NULL,'setters.login_name','2018-04-10 16:31:33'),(NULL,'Bugzilla::Field',50,'__create__',NULL,'work_time','2018-04-10 16:31:33'),(NULL,'Bugzilla::Field',51,'__create__',NULL,'percentage_complete','2018-04-10 16:31:33'),(NULL,'Bugzilla::Field',52,'__create__',NULL,'content','2018-04-10 16:31:33'),(NULL,'Bugzilla::Field',53,'__create__',NULL,'attach_data.thedata','2018-04-10 16:31:33'),(NULL,'Bugzilla::Field',54,'__create__',NULL,'owner_idle_time','2018-04-10 16:31:33'),(NULL,'Bugzilla::Field',55,'__create__',NULL,'see_also','2018-04-10 16:31:33'),(NULL,'Bugzilla::Field',56,'__create__',NULL,'tag','2018-04-10 16:31:33'),(NULL,'Bugzilla::Field',57,'__create__',NULL,'last_visit_ts','2018-04-10 16:31:33'),(NULL,'Bugzilla::Field',58,'__create__',NULL,'comment_tag','2018-04-10 16:31:33'),(NULL,'Bugzilla::Field',59,'__create__',NULL,'days_elapsed','2018-04-10 16:31:33'),(NULL,'Bugzilla::Classification',1,'__create__',NULL,'Unclassified','2018-04-10 16:31:33'),(NULL,'Bugzilla::Group',1,'__create__',NULL,'admin','2018-04-10 16:31:36'),(NULL,'Bugzilla::Group',2,'__create__',NULL,'tweakparams','2018-04-10 16:31:36'),(NULL,'Bugzilla::Group',3,'__create__',NULL,'editusers','2018-04-10 16:31:36'),(NULL,'Bugzilla::Group',4,'__create__',NULL,'creategroups','2018-04-10 16:31:36'),(NULL,'Bugzilla::Group',5,'__create__',NULL,'editclassifications','2018-04-10 16:31:36'),(NULL,'Bugzilla::Group',6,'__create__',NULL,'editcomponents','2018-04-10 16:31:36'),(NULL,'Bugzilla::Group',7,'__create__',NULL,'editkeywords','2018-04-10 16:31:36'),(NULL,'Bugzilla::Group',8,'__create__',NULL,'editbugs','2018-04-10 16:31:36'),(NULL,'Bugzilla::Group',9,'__create__',NULL,'canconfirm','2018-04-10 16:31:36'),(NULL,'Bugzilla::Group',10,'__create__',NULL,'bz_canusewhineatothers','2018-04-10 16:31:36'),(NULL,'Bugzilla::Group',11,'__create__',NULL,'bz_canusewhines','2018-04-10 16:31:36'),(NULL,'Bugzilla::Group',12,'__create__',NULL,'bz_sudoers','2018-04-10 16:31:36'),(NULL,'Bugzilla::Group',13,'__create__',NULL,'bz_sudo_protect','2018-04-10 16:31:36'),(NULL,'Bugzilla::Group',14,'__create__',NULL,'bz_quip_moderators','2018-04-10 16:31:36'),(NULL,'Bugzilla::User',1,'__create__',NULL,'ivandermenji97@gmail.com','2018-04-10 16:32:11'),(NULL,'Bugzilla::Product',1,'__create__',NULL,'TestProduct','2018-04-10 16:32:11'),(NULL,'Bugzilla::Version',1,'__create__',NULL,'unspecified','2018-04-10 16:32:11'),(NULL,'Bugzilla::Milestone',1,'__create__',NULL,'---','2018-04-10 16:32:11'),(NULL,'Bugzilla::Component',1,'__create__',NULL,'TestComponent','2018-04-10 16:32:11');
108/*!40000 ALTER TABLE `audit_log` ENABLE KEYS */;
109UNLOCK TABLES;
110
111--
112-- Table structure for table `bug_group_map`
113--
114
115DROP TABLE IF EXISTS `bug_group_map`;
116/*!40101 SET @saved_cs_client     = @@character_set_client */;
117/*!40101 SET character_set_client = utf8 */;
118CREATE TABLE `bug_group_map` (
119  `bug_id` mediumint(9) NOT NULL,
120  `group_id` mediumint(9) NOT NULL,
121  UNIQUE KEY `bug_group_map_bug_id_idx` (`bug_id`,`group_id`),
122  KEY `bug_group_map_group_id_idx` (`group_id`),
123  CONSTRAINT `fk_bug_group_map_bug_id_bugs_bug_id` FOREIGN KEY (`bug_id`) REFERENCES `bugs` (`bug_id`) ON DELETE CASCADE ON UPDATE CASCADE,
124  CONSTRAINT `fk_bug_group_map_group_id_groups_id` FOREIGN KEY (`group_id`) REFERENCES `groups` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
125) ENGINE=InnoDB DEFAULT CHARSET=utf8;
126/*!40101 SET character_set_client = @saved_cs_client */;
127
128--
129-- Dumping data for table `bug_group_map`
130--
131
132LOCK TABLES `bug_group_map` WRITE;
133/*!40000 ALTER TABLE `bug_group_map` DISABLE KEYS */;
134/*!40000 ALTER TABLE `bug_group_map` ENABLE KEYS */;
135UNLOCK TABLES;
136
137--
138-- Table structure for table `bug_see_also`
139--
140
141DROP TABLE IF EXISTS `bug_see_also`;
142/*!40101 SET @saved_cs_client     = @@character_set_client */;
143/*!40101 SET character_set_client = utf8 */;
144CREATE TABLE `bug_see_also` (
145  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
146  `bug_id` mediumint(9) NOT NULL,
147  `value` varchar(255) NOT NULL,
148  `class` varchar(255) NOT NULL DEFAULT '',
149  PRIMARY KEY (`id`),
150  UNIQUE KEY `bug_see_also_bug_id_idx` (`bug_id`,`value`),
151  CONSTRAINT `fk_bug_see_also_bug_id_bugs_bug_id` FOREIGN KEY (`bug_id`) REFERENCES `bugs` (`bug_id`) ON DELETE CASCADE ON UPDATE CASCADE
152) ENGINE=InnoDB DEFAULT CHARSET=utf8;
153/*!40101 SET character_set_client = @saved_cs_client */;
154
155--
156-- Dumping data for table `bug_see_also`
157--
158
159LOCK TABLES `bug_see_also` WRITE;
160/*!40000 ALTER TABLE `bug_see_also` DISABLE KEYS */;
161/*!40000 ALTER TABLE `bug_see_also` ENABLE KEYS */;
162UNLOCK TABLES;
163
164--
165-- Table structure for table `bug_severity`
166--
167
168DROP TABLE IF EXISTS `bug_severity`;
169/*!40101 SET @saved_cs_client     = @@character_set_client */;
170/*!40101 SET character_set_client = utf8 */;
171CREATE TABLE `bug_severity` (
172  `id` smallint(6) NOT NULL AUTO_INCREMENT,
173  `value` varchar(64) NOT NULL,
174  `sortkey` smallint(6) NOT NULL DEFAULT '0',
175  `isactive` tinyint(4) NOT NULL DEFAULT '1',
176  `visibility_value_id` smallint(6) DEFAULT NULL,
177  PRIMARY KEY (`id`),
178  UNIQUE KEY `bug_severity_value_idx` (`value`),
179  KEY `bug_severity_sortkey_idx` (`sortkey`,`value`),
180  KEY `bug_severity_visibility_value_id_idx` (`visibility_value_id`)
181) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
182/*!40101 SET character_set_client = @saved_cs_client */;
183
184--
185-- Dumping data for table `bug_severity`
186--
187
188LOCK TABLES `bug_severity` WRITE;
189/*!40000 ALTER TABLE `bug_severity` DISABLE KEYS */;
190INSERT INTO `bug_severity` VALUES (1,'blocker',100,1,NULL),(2,'critical',200,1,NULL),(3,'major',300,1,NULL),(4,'normal',400,1,NULL),(5,'minor',500,1,NULL),(6,'trivial',600,1,NULL),(7,'enhancement',700,1,NULL);
191/*!40000 ALTER TABLE `bug_severity` ENABLE KEYS */;
192UNLOCK TABLES;
193
194--
195-- Table structure for table `bug_status`
196--
197
198DROP TABLE IF EXISTS `bug_status`;
199/*!40101 SET @saved_cs_client     = @@character_set_client */;
200/*!40101 SET character_set_client = utf8 */;
201CREATE TABLE `bug_status` (
202  `id` smallint(6) NOT NULL AUTO_INCREMENT,
203  `value` varchar(64) NOT NULL,
204  `sortkey` smallint(6) NOT NULL DEFAULT '0',
205  `isactive` tinyint(4) NOT NULL DEFAULT '1',
206  `visibility_value_id` smallint(6) DEFAULT NULL,
207  `is_open` tinyint(4) NOT NULL DEFAULT '1',
208  PRIMARY KEY (`id`),
209  UNIQUE KEY `bug_status_value_idx` (`value`),
210  KEY `bug_status_sortkey_idx` (`sortkey`,`value`),
211  KEY `bug_status_visibility_value_id_idx` (`visibility_value_id`)
212) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
213/*!40101 SET character_set_client = @saved_cs_client */;
214
215--
216-- Dumping data for table `bug_status`
217--
218
219LOCK TABLES `bug_status` WRITE;
220/*!40000 ALTER TABLE `bug_status` DISABLE KEYS */;
221INSERT INTO `bug_status` VALUES (1,'UNCONFIRMED',100,1,NULL,1),(2,'CONFIRMED',200,1,NULL,1),(3,'IN_PROGRESS',300,1,NULL,1),(4,'RESOLVED',400,1,NULL,0),(5,'VERIFIED',500,1,NULL,0);
222/*!40000 ALTER TABLE `bug_status` ENABLE KEYS */;
223UNLOCK TABLES;
224
225--
226-- Table structure for table `bug_tag`
227--
228
229DROP TABLE IF EXISTS `bug_tag`;
230/*!40101 SET @saved_cs_client     = @@character_set_client */;
231/*!40101 SET character_set_client = utf8 */;
232CREATE TABLE `bug_tag` (
233  `bug_id` mediumint(9) NOT NULL,
234  `tag_id` mediumint(9) NOT NULL,
235  UNIQUE KEY `bug_tag_bug_id_idx` (`bug_id`,`tag_id`),
236  KEY `fk_bug_tag_tag_id_tag_id` (`tag_id`),
237  CONSTRAINT `fk_bug_tag_bug_id_bugs_bug_id` FOREIGN KEY (`bug_id`) REFERENCES `bugs` (`bug_id`) ON DELETE CASCADE ON UPDATE CASCADE,
238  CONSTRAINT `fk_bug_tag_tag_id_tag_id` FOREIGN KEY (`tag_id`) REFERENCES `tag` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
239) ENGINE=InnoDB DEFAULT CHARSET=utf8;
240/*!40101 SET character_set_client = @saved_cs_client */;
241
242--
243-- Dumping data for table `bug_tag`
244--
245
246LOCK TABLES `bug_tag` WRITE;
247/*!40000 ALTER TABLE `bug_tag` DISABLE KEYS */;
248/*!40000 ALTER TABLE `bug_tag` ENABLE KEYS */;
249UNLOCK TABLES;
250
251--
252-- Table structure for table `bug_user_last_visit`
253--
254
255DROP TABLE IF EXISTS `bug_user_last_visit`;
256/*!40101 SET @saved_cs_client     = @@character_set_client */;
257/*!40101 SET character_set_client = utf8 */;
258CREATE TABLE `bug_user_last_visit` (
259  `id` int(11) NOT NULL AUTO_INCREMENT,
260  `user_id` mediumint(9) NOT NULL,
261  `bug_id` mediumint(9) NOT NULL,
262  `last_visit_ts` datetime NOT NULL,
263  PRIMARY KEY (`id`),
264  UNIQUE KEY `bug_user_last_visit_idx` (`user_id`,`bug_id`),
265  KEY `bug_user_last_visit_last_visit_ts_idx` (`last_visit_ts`),
266  KEY `fk_bug_user_last_visit_bug_id_bugs_bug_id` (`bug_id`),
267  CONSTRAINT `fk_bug_user_last_visit_bug_id_bugs_bug_id` FOREIGN KEY (`bug_id`) REFERENCES `bugs` (`bug_id`) ON DELETE CASCADE ON UPDATE CASCADE,
268  CONSTRAINT `fk_bug_user_last_visit_user_id_profiles_userid` FOREIGN KEY (`user_id`) REFERENCES `profiles` (`userid`) ON DELETE CASCADE ON UPDATE CASCADE
269) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;
270/*!40101 SET character_set_client = @saved_cs_client */;
271
272--
273-- Dumping data for table `bug_user_last_visit`
274--
275
276LOCK TABLES `bug_user_last_visit` WRITE;
277/*!40000 ALTER TABLE `bug_user_last_visit` DISABLE KEYS */;
278INSERT INTO `bug_user_last_visit` VALUES (1,1,1,'2018-05-02 08:29:49'),(2,1,2,'2018-05-02 10:21:16'),(3,1,3,'2018-05-02 08:29:48'),(4,1,4,'2018-05-02 08:29:49'),(5,1,5,'2018-05-02 08:29:48'),(6,1,6,'2018-04-11 10:08:10'),(7,1,7,'2018-05-02 08:29:48'),(8,1,8,'2018-05-02 08:29:48'),(9,1,9,'2018-05-02 08:29:48'),(10,1,10,'2018-05-02 08:29:49');
279/*!40000 ALTER TABLE `bug_user_last_visit` ENABLE KEYS */;
280UNLOCK TABLES;
281
282--
283-- Table structure for table `bugs`
284--
285
286DROP TABLE IF EXISTS `bugs`;
287/*!40101 SET @saved_cs_client     = @@character_set_client */;
288/*!40101 SET character_set_client = utf8 */;
289CREATE TABLE `bugs` (
290  `bug_id` mediumint(9) NOT NULL AUTO_INCREMENT,
291  `assigned_to` mediumint(9) NOT NULL,
292  `bug_file_loc` mediumtext NOT NULL,
293  `bug_severity` varchar(64) NOT NULL,
294  `bug_status` varchar(64) NOT NULL,
295  `creation_ts` datetime DEFAULT NULL,
296  `delta_ts` datetime NOT NULL,
297  `short_desc` varchar(255) NOT NULL,
298  `op_sys` varchar(64) NOT NULL,
299  `priority` varchar(64) NOT NULL,
300  `product_id` smallint(6) NOT NULL,
301  `rep_platform` varchar(64) NOT NULL,
302  `reporter` mediumint(9) NOT NULL,
303  `version` varchar(64) NOT NULL,
304  `component_id` mediumint(9) NOT NULL,
305  `resolution` varchar(64) NOT NULL DEFAULT '',
306  `target_milestone` varchar(64) NOT NULL DEFAULT '---',
307  `qa_contact` mediumint(9) DEFAULT NULL,
308  `status_whiteboard` mediumtext NOT NULL,
309  `lastdiffed` datetime DEFAULT NULL,
310  `everconfirmed` tinyint(4) NOT NULL,
311  `reporter_accessible` tinyint(4) NOT NULL DEFAULT '1',
312  `cclist_accessible` tinyint(4) NOT NULL DEFAULT '1',
313  `estimated_time` decimal(7,2) NOT NULL DEFAULT '0.00',
314  `remaining_time` decimal(7,2) NOT NULL DEFAULT '0.00',
315  `deadline` datetime DEFAULT NULL,
316  PRIMARY KEY (`bug_id`),
317  KEY `bugs_assigned_to_idx` (`assigned_to`),
318  KEY `bugs_creation_ts_idx` (`creation_ts`),
319  KEY `bugs_delta_ts_idx` (`delta_ts`),
320  KEY `bugs_bug_severity_idx` (`bug_severity`),
321  KEY `bugs_bug_status_idx` (`bug_status`),
322  KEY `bugs_op_sys_idx` (`op_sys`),
323  KEY `bugs_priority_idx` (`priority`),
324  KEY `bugs_product_id_idx` (`product_id`),
325  KEY `bugs_reporter_idx` (`reporter`),
326  KEY `bugs_version_idx` (`version`),
327  KEY `bugs_component_id_idx` (`component_id`),
328  KEY `bugs_resolution_idx` (`resolution`),
329  KEY `bugs_target_milestone_idx` (`target_milestone`),
330  KEY `bugs_qa_contact_idx` (`qa_contact`),
331  CONSTRAINT `fk_bugs_assigned_to_profiles_userid` FOREIGN KEY (`assigned_to`) REFERENCES `profiles` (`userid`) ON UPDATE CASCADE,
332  CONSTRAINT `fk_bugs_component_id_components_id` FOREIGN KEY (`component_id`) REFERENCES `components` (`id`) ON UPDATE CASCADE,
333  CONSTRAINT `fk_bugs_product_id_products_id` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON UPDATE CASCADE,
334  CONSTRAINT `fk_bugs_qa_contact_profiles_userid` FOREIGN KEY (`qa_contact`) REFERENCES `profiles` (`userid`) ON UPDATE CASCADE,
335  CONSTRAINT `fk_bugs_reporter_profiles_userid` FOREIGN KEY (`reporter`) REFERENCES `profiles` (`userid`) ON UPDATE CASCADE
336) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;
337/*!40101 SET character_set_client = @saved_cs_client */;
338
339--
340-- Dumping data for table `bugs`
341--
342
343LOCK TABLES `bugs` WRITE;
344/*!40000 ALTER TABLE `bugs` DISABLE KEYS */;
345INSERT INTO `bugs` VALUES (1,1,'','major','CONFIRMED','2018-04-10 16:34:54','2018-04-11 10:01:45','Cancel installation error','Windows','High',1,'PC',1,'unspecified',1,'','---',NULL,'','2018-04-11 10:01:45',1,1,1,0.00,0.00,NULL),(2,1,'','minor','CONFIRMED','2018-04-10 19:29:21','2018-04-11 10:03:06','Incorrect label \"Edjit\"','Windows','Low',1,'PC',1,'unspecified',1,'','---',NULL,'','2018-04-11 10:03:06',1,1,1,0.00,0.00,NULL),(3,1,'','normal','CONFIRMED','2018-04-10 19:35:28','2018-04-11 10:03:54','Erroneously displays the presence of one record while list is empty','Windows','Normal',1,'PC',1,'unspecified',1,'','---',NULL,'','2018-04-11 10:03:54',1,1,1,0.00,0.00,NULL),(4,1,'','major','CONFIRMED','2018-04-10 19:38:03','2018-04-11 10:05:52','Button \"Clear all\" is not available when number of records equal 1','Windows','Normal',1,'PC',1,'unspecified',1,'','---',NULL,'','2018-04-11 10:05:52',1,1,1,0.00,0.00,NULL),(5,1,'','major','CONFIRMED','2018-04-10 19:41:05','2018-04-11 10:07:31','Attempt to open item \"about program\" leads to an error','Windows','High',1,'PC',1,'unspecified',1,'','---',NULL,'','2018-04-11 10:07:31',1,1,1,0.00,0.00,NULL),(6,1,'','normal','CONFIRMED','2018-04-10 19:43:06','2018-04-11 10:08:10','Symbol \"$\" is available in alphabetic layout','Windows','Low',1,'PC',1,'unspecified',1,'','---',NULL,'','2018-04-11 10:08:10',1,1,1,0.00,0.00,NULL),(7,1,'','trivial','CONFIRMED','2018-04-10 19:45:42','2018-04-11 10:08:54','Incorrect label in the paragraph \"Help\"','Windows','Lowest',1,'PC',1,'unspecified',1,'','---',NULL,'','2018-04-11 10:08:54',1,1,1,0.00,0.00,NULL),(8,1,'','normal','CONFIRMED','2018-04-10 19:46:52','2018-04-11 10:09:19','Element \"Cut\" is unavailable','Windows','Normal',1,'PC',1,'unspecified',1,'','---',NULL,'','2018-04-11 10:09:20',1,1,1,0.00,0.00,NULL),(9,1,'','normal','CONFIRMED','2018-04-10 19:48:33','2018-04-11 10:09:43','Element \"Copy\" is unavailable','Linux','Normal',1,'PC',1,'unspecified',1,'','---',NULL,'','2018-04-11 10:09:43',1,1,1,0.00,0.00,NULL),(10,1,'','normal','CONFIRMED','2018-04-10 19:49:18','2018-04-11 10:10:09','Element \"Paste\" is unavailable','Windows','Normal',1,'PC',1,'unspecified',1,'','---',NULL,'','2018-04-11 10:10:09',1,1,1,0.00,0.00,NULL);
346/*!40000 ALTER TABLE `bugs` ENABLE KEYS */;
347UNLOCK TABLES;
348
349--
350-- Table structure for table `bugs_activity`
351--
352
353DROP TABLE IF EXISTS `bugs_activity`;
354/*!40101 SET @saved_cs_client     = @@character_set_client */;
355/*!40101 SET character_set_client = utf8 */;
356CREATE TABLE `bugs_activity` (
357  `id` int(11) NOT NULL AUTO_INCREMENT,
358  `bug_id` mediumint(9) NOT NULL,
359  `attach_id` mediumint(9) DEFAULT NULL,
360  `who` mediumint(9) NOT NULL,
361  `bug_when` datetime NOT NULL,
362  `fieldid` mediumint(9) NOT NULL,
363  `added` varchar(255) DEFAULT NULL,
364  `removed` varchar(255) DEFAULT NULL,
365  `comment_id` int(11) DEFAULT NULL,
366  PRIMARY KEY (`id`),
367  KEY `bugs_activity_bug_id_idx` (`bug_id`),
368  KEY `bugs_activity_who_idx` (`who`),
369  KEY `bugs_activity_bug_when_idx` (`bug_when`),
370  KEY `bugs_activity_fieldid_idx` (`fieldid`),
371  KEY `bugs_activity_added_idx` (`added`),
372  KEY `bugs_activity_removed_idx` (`removed`),
373  KEY `fk_bugs_activity_comment_id_longdescs_comment_id` (`comment_id`),
374  KEY `fk_bugs_activity_attach_id_attachments_attach_id` (`attach_id`),
375  CONSTRAINT `fk_bugs_activity_attach_id_attachments_attach_id` FOREIGN KEY (`attach_id`) REFERENCES `attachments` (`attach_id`) ON DELETE CASCADE ON UPDATE CASCADE,
376  CONSTRAINT `fk_bugs_activity_bug_id_bugs_bug_id` FOREIGN KEY (`bug_id`) REFERENCES `bugs` (`bug_id`) ON DELETE CASCADE ON UPDATE CASCADE,
377  CONSTRAINT `fk_bugs_activity_comment_id_longdescs_comment_id` FOREIGN KEY (`comment_id`) REFERENCES `longdescs` (`comment_id`) ON DELETE CASCADE ON UPDATE CASCADE,
378  CONSTRAINT `fk_bugs_activity_fieldid_fielddefs_id` FOREIGN KEY (`fieldid`) REFERENCES `fielddefs` (`id`) ON UPDATE CASCADE,
379  CONSTRAINT `fk_bugs_activity_who_profiles_userid` FOREIGN KEY (`who`) REFERENCES `profiles` (`userid`) ON UPDATE CASCADE
380) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8;
381/*!40101 SET character_set_client = @saved_cs_client */;
382
383--
384-- Dumping data for table `bugs_activity`
385--
386
387LOCK TABLES `bugs_activity` WRITE;
388/*!40000 ALTER TABLE `bugs_activity` DISABLE KEYS */;
389INSERT INTO `bugs_activity` VALUES (1,1,NULL,1,'2018-04-10 19:13:57',2,'Cancel installation error','test12345',NULL),(2,1,NULL,1,'2018-04-10 19:13:57',8,'Windows','Linux',NULL),(3,1,NULL,1,'2018-04-10 19:13:57',13,'normal','enhancement',NULL),(4,1,NULL,1,'2018-04-10 19:13:57',14,'High','---',NULL),(5,7,NULL,1,'2018-04-10 19:47:25',8,'Windows','Linux',NULL),(6,6,NULL,1,'2018-04-10 19:47:32',8,'Windows','Linux',NULL),(7,4,NULL,1,'2018-04-10 19:47:42',8,'Windows','Linux',NULL),(8,9,NULL,1,'2018-04-10 19:50:39',24,'10','',NULL),(9,8,NULL,1,'2018-04-10 19:50:39',24,'10','',NULL),(10,10,NULL,1,'2018-04-10 19:50:39',23,'9, 8','',NULL),(11,1,NULL,1,'2018-04-11 10:01:45',13,'major','normal',NULL),(12,2,NULL,1,'2018-04-11 10:03:06',13,'minor','enhancement',NULL),(13,2,NULL,1,'2018-04-11 10:03:06',14,'Low','---',NULL),(14,3,NULL,1,'2018-04-11 10:03:54',13,'normal','enhancement',NULL),(15,3,NULL,1,'2018-04-11 10:03:54',14,'Normal','---',NULL),(16,4,NULL,1,'2018-04-11 10:05:52',14,'Normal','---',NULL),(17,4,NULL,1,'2018-04-11 10:05:52',13,'major','enhancement',NULL),(18,5,NULL,1,'2018-04-11 10:07:31',13,'major','enhancement',NULL),(19,5,NULL,1,'2018-04-11 10:07:31',14,'High','---',NULL),(20,6,NULL,1,'2018-04-11 10:08:10',14,'Low','---',NULL),(21,6,NULL,1,'2018-04-11 10:08:10',13,'normal','enhancement',NULL),(22,7,NULL,1,'2018-04-11 10:08:54',14,'Lowest','---',NULL),(23,7,NULL,1,'2018-04-11 10:08:54',13,'trivial','enhancement',NULL),(24,8,NULL,1,'2018-04-11 10:09:19',13,'normal','enhancement',NULL),(25,8,NULL,1,'2018-04-11 10:09:19',14,'Normal','---',NULL),(26,9,NULL,1,'2018-04-11 10:09:43',14,'Normal','---',NULL),(27,9,NULL,1,'2018-04-11 10:09:43',13,'normal','enhancement',NULL),(28,10,NULL,1,'2018-04-11 10:10:09',13,'normal','enhancement',NULL),(29,10,NULL,1,'2018-04-11 10:10:09',14,'Normal','---',NULL);
390/*!40000 ALTER TABLE `bugs_activity` ENABLE KEYS */;
391UNLOCK TABLES;
392
393--
394-- Table structure for table `bugs_aliases`
395--
396
397DROP TABLE IF EXISTS `bugs_aliases`;
398/*!40101 SET @saved_cs_client     = @@character_set_client */;
399/*!40101 SET character_set_client = utf8 */;
400CREATE TABLE `bugs_aliases` (
401  `alias` varchar(40) NOT NULL,
402  `bug_id` mediumint(9) DEFAULT NULL,
403  UNIQUE KEY `bugs_aliases_alias_idx` (`alias`),
404  KEY `bugs_aliases_bug_id_idx` (`bug_id`),
405  CONSTRAINT `fk_bugs_aliases_bug_id_bugs_bug_id` FOREIGN KEY (`bug_id`) REFERENCES `bugs` (`bug_id`) ON DELETE CASCADE ON UPDATE CASCADE
406) ENGINE=InnoDB DEFAULT CHARSET=utf8;
407/*!40101 SET character_set_client = @saved_cs_client */;
408
409--
410-- Dumping data for table `bugs_aliases`
411--
412
413LOCK TABLES `bugs_aliases` WRITE;
414/*!40000 ALTER TABLE `bugs_aliases` DISABLE KEYS */;
415/*!40000 ALTER TABLE `bugs_aliases` ENABLE KEYS */;
416UNLOCK TABLES;
417
418--
419-- Table structure for table `bugs_fulltext`
420--
421
422DROP TABLE IF EXISTS `bugs_fulltext`;
423/*!40101 SET @saved_cs_client     = @@character_set_client */;
424/*!40101 SET character_set_client = utf8 */;
425CREATE TABLE `bugs_fulltext` (
426  `bug_id` mediumint(9) NOT NULL,
427  `short_desc` varchar(255) NOT NULL,
428  `comments` mediumtext,
429  `comments_noprivate` mediumtext,
430  PRIMARY KEY (`bug_id`),
431  FULLTEXT KEY `bugs_fulltext_short_desc_idx` (`short_desc`),
432  FULLTEXT KEY `bugs_fulltext_comments_idx` (`comments`),
433  FULLTEXT KEY `bugs_fulltext_comments_noprivate_idx` (`comments_noprivate`)
434) ENGINE=MyISAM DEFAULT CHARSET=utf8;
435/*!40101 SET character_set_client = @saved_cs_client */;
436
437--
438-- Dumping data for table `bugs_fulltext`
439--
440
441LOCK TABLES `bugs_fulltext` WRITE;
442/*!40000 ALTER TABLE `bugs_fulltext` DISABLE KEYS */;
443INSERT INTO `bugs_fulltext` VALUES (1,'Cancel installation error','\n1. Download installation file .exe.\n2. Double click on installation file.\n3. Press \"Ok\" button in opened window.\n4. \"Cancel\" button is missing.','\n1. Download installation file .exe.\n2. Double click on installation file.\n3. Press \"Ok\" button in opened window.\n4. \"Cancel\" button is missing.'),(2,'Incorrect label \"Edjit\"','1. After installation run programm.\n2. Item \"Edjit\" has wrong spelling','1. After installation run programm.\n2. Item \"Edjit\" has wrong spelling'),(3,'Erroneously displays the presence of one record while list is empty','1. Run ListBoxer\n2. Take a look at right-corner where shows the number of records','1. Run ListBoxer\n2. Take a look at right-corner where shows the number of records'),(4,'Button \"Clear all\" is not available when number of records equal 1','1. Run ListBoxer\n2. Add any one record\n3. Button \"Clear all\" is inactive','1. Run ListBoxer\n2. Add any one record\n3. Button \"Clear all\" is inactive'),(5,'Attempt to open item \"about program\" leads to an error','1. Run ListBoxer\n2. Click on item \"About program\"\n3. See error page instead of reference','1. Run ListBoxer\n2. Click on item \"About program\"\n3. See error page instead of reference'),(6,'Symbol \"$\" is available in alphabetic layout','1. Run ListBoxer\n2. Choose alphabetic layout\n3. Type symbol \"$\" and add record with it\n4. Record will be added','1. Run ListBoxer\n2. Choose alphabetic layout\n3. Type symbol \"$\" and add record with it\n4. Record will be added'),(7,'Incorrect label in the paragraph \"Help\"','Version is printed with using coma instead dot.\n1. Run ListBoxer\n2. Click item Help\n3. See incorrect spelling of paragraph \"Version x.x\" (where x.x - number of version)','Version is printed with using coma instead dot.\n1. Run ListBoxer\n2. Click item Help\n3. See incorrect spelling of paragraph \"Version x.x\" (where x.x - number of version)'),(8,'Element \"Cut\" is unavailable','1. Run ListBoxer\n2. See that element \"Cut\" is unavailable','1. Run ListBoxer\n2. See that element \"Cut\" is unavailable'),(9,'Element \"Copy\" is unavailable','1. Run ListBoxer\n2. See that element \"Copy\" is unavailable','1. Run ListBoxer\n2. See that element \"Copy\" is unavailable'),(10,'Element \"Paste\" is unavailable','1. Run ListBoxer\n2. See that element \"Paste\" is unavailable','1. Run ListBoxer\n2. See that element \"Paste\" is unavailable');
444/*!40000 ALTER TABLE `bugs_fulltext` ENABLE KEYS */;
445UNLOCK TABLES;
446
447--
448-- Table structure for table `bz_schema`
449--
450
451DROP TABLE IF EXISTS `bz_schema`;
452/*!40101 SET @saved_cs_client     = @@character_set_client */;
453/*!40101 SET character_set_client = utf8 */;
454CREATE TABLE `bz_schema` (
455  `schema_data` longblob NOT NULL,
456  `version` decimal(3,2) NOT NULL
457) ENGINE=InnoDB DEFAULT CHARSET=utf8;
458/*!40101 SET character_set_client = @saved_cs_client */;
459
460--
461-- Dumping data for table `bz_schema`
462--
463
464LOCK TABLES `bz_schema` WRITE;
465/*!40000 ALTER TABLE `bz_schema` DISABLE KEYS */;
466INSERT INTO `bz_schema` VALUES ('$VAR1 = {\n          \'attach_data\' => {\n                             \'FIELDS\' => [\n                                           \'id\',\n                                           {\n                                             \'NOTNULL\' => 1,\n                                             \'PRIMARYKEY\' => 1,\n                                             \'REFERENCES\' => {\n                                                               \'COLUMN\' => \'attach_id\',\n                                                               \'DELETE\' => \'CASCADE\',\n                                                               \'TABLE\' => \'attachments\',\n                                                               \'created\' => 1\n                                                             },\n                                             \'TYPE\' => \'INT3\'\n                                           },\n                                           \'thedata\',\n                                           {\n                                             \'NOTNULL\' => 1,\n                                             \'TYPE\' => \'LONGBLOB\'\n                                           }\n                                         ]\n                           },\n          \'attachments\' => {\n                             \'FIELDS\' => [\n                                           \'attach_id\',\n                                           {\n                                             \'NOTNULL\' => 1,\n                                             \'PRIMARYKEY\' => 1,\n                                             \'TYPE\' => \'MEDIUMSERIAL\'\n                                           },\n                                           \'bug_id\',\n                                           {\n                                             \'NOTNULL\' => 1,\n                                             \'REFERENCES\' => {\n                                                               \'COLUMN\' => \'bug_id\',\n                                                               \'DELETE\' => \'CASCADE\',\n                                                               \'TABLE\' => \'bugs\',\n                                                               \'created\' => 1\n                                                             },\n                                             \'TYPE\' => \'INT3\'\n                                           },\n                                           \'creation_ts\',\n                                           {\n                                             \'NOTNULL\' => 1,\n                                             \'TYPE\' => \'DATETIME\'\n                                           },\n                                           \'modification_time\',\n                                           {\n                                             \'NOTNULL\' => 1,\n                                             \'TYPE\' => \'DATETIME\'\n                                           },\n                                           \'description\',\n                                           {\n                                             \'NOTNULL\' => 1,\n                                             \'TYPE\' => \'TINYTEXT\'\n                                           },\n                                           \'mimetype\',\n                                           {\n                                             \'NOTNULL\' => 1,\n                                             \'TYPE\' => \'TINYTEXT\'\n                                           },\n                                           \'ispatch\',\n                                           {\n                                             \'DEFAULT\' => \'FALSE\',\n                                             \'NOTNULL\' => 1,\n                                             \'TYPE\' => \'BOOLEAN\'\n                                           },\n                                           \'filename\',\n                                           {\n                                             \'NOTNULL\' => 1,\n                                             \'TYPE\' => \'varchar(255)\'\n                                           },\n                                           \'submitter_id\',\n                                           {\n                                             \'NOTNULL\' => 1,\n                                             \'REFERENCES\' => {\n                                                               \'COLUMN\' => \'userid\',\n                                                               \'TABLE\' => \'profiles\',\n                                                               \'created\' => 1\n                                                             },\n                                             \'TYPE\' => \'INT3\'\n                                           },\n                                           \'isobsolete\',\n                                           {\n                                             \'DEFAULT\' => \'FALSE\',\n                                             \'NOTNULL\' => 1,\n                                             \'TYPE\' => \'BOOLEAN\'\n                                           },\n                                           \'isprivate\',\n                                           {\n                                             \'DEFAULT\' => \'FALSE\',\n                                             \'NOTNULL\' => 1,\n                                             \'TYPE\' => \'BOOLEAN\'\n                                           }\n                                         ],\n                             \'INDEXES\' => [\n                                            \'attachments_bug_id_idx\',\n                                            [\n                                              \'bug_id\'\n                                            ],\n                                            \'attachments_creation_ts_idx\',\n                                            [\n                                              \'creation_ts\'\n                                            ],\n                                            \'attachments_modification_time_idx\',\n                                            [\n                                              \'modification_time\'\n                                            ],\n                                            \'attachments_submitter_id_idx\',\n                                            [\n                                              \'submitter_id\',\n                                              \'bug_id\'\n                                            ]\n                                          ]\n                           },\n          \'audit_log\' => {\n                           \'FIELDS\' => [\n                                         \'user_id\',\n                                         {\n                                           \'REFERENCES\' => {\n                                                             \'COLUMN\' => \'userid\',\n                                                             \'DELETE\' => \'SET NULL\',\n                                                             \'TABLE\' => \'profiles\',\n                                                             \'created\' => 1\n                                                           },\n                                           \'TYPE\' => \'INT3\'\n                                         },\n                                         \'class\',\n                                         {\n                                           \'NOTNULL\' => 1,\n                                           \'TYPE\' => \'varchar(255)\'\n                                         },\n                                         \'object_id\',\n                                         {\n                                           \'NOTNULL\' => 1,\n                                           \'TYPE\' => \'INT4\'\n                                         },\n                                         \'field\',\n                                         {\n                                           \'NOTNULL\' => 1,\n                                           \'TYPE\' => \'varchar(64)\'\n                                         },\n                                         \'removed\',\n                                         {\n                                           \'TYPE\' => \'MEDIUMTEXT\'\n                                         },\n                                         \'added\',\n                                         {\n                                           \'TYPE\' => \'MEDIUMTEXT\'\n                                         },\n                                         \'at_time\',\n                                         {\n                                           \'NOTNULL\' => 1,\n                                           \'TYPE\' => \'DATETIME\'\n                                         }\n                                       ],\n                           \'INDEXES\' => [\n                                          \'audit_log_class_idx\',\n                                          [\n                                            \'class\',\n                                            \'at_time\'\n                                          ]\n                                        ]\n                         },\n          \'bug_group_map\' => {\n                               \'FIELDS\' => [\n                                             \'bug_id\',\n                                             {\n                                               \'NOTNULL\' => 1,\n                                               \'REFERENCES\' => {\n                                                                 \'COLUMN\' => \'bug_id\',\n                                                                 \'DELETE\' => \'CASCADE\',\n                                                                 \'TABLE\' => \'bugs\',\n                                                                 \'created\' => 1\n                                                               },\n                                               \'TYPE\' => \'INT3\'\n                                             },\n                                             \'group_id\',\n                                             {\n                                               \'NOTNULL\' => 1,\n                                               \'REFERENCES\' => {\n                                                                 \'COLUMN\' => \'id\',\n                                                                 \'DELETE\' => \'CASCADE\',\n                                                                 \'TABLE\' => \'groups\',\n                                                                 \'created\' => 1\n                                                               },\n                                               \'TYPE\' => \'INT3\'\n                                             }\n                                           ],\n                               \'INDEXES\' => [\n                                              \'bug_group_map_bug_id_idx\',\n                                              {\n                                                \'FIELDS\' => [\n                                                              \'bug_id\',\n                                                              \'group_id\'\n                                                            ],\n                                                \'TYPE\' => \'UNIQUE\'\n                                              },\n                                              \'bug_group_map_group_id_idx\',\n                                              [\n                                                \'group_id\'\n                                              ]\n                                            ]\n                             },\n          \'bug_see_also\' => {\n                              \'FIELDS\' => [\n                                            \'id\',\n                                            {\n                                              \'NOTNULL\' => 1,\n                                              \'PRIMARYKEY\' => 1,\n                                              \'TYPE\' => \'MEDIUMSERIAL\'\n                                            },\n                                            \'bug_id\',\n                                            {\n                                              \'NOTNULL\' => 1,\n                                              \'REFERENCES\' => {\n                                                                \'COLUMN\' => \'bug_id\',\n                                                                \'DELETE\' => \'CASCADE\',\n                                                                \'TABLE\' => \'bugs\',\n                                                                \'created\' => 1\n                                                              },\n                                              \'TYPE\' => \'INT3\'\n                                            },\n                                            \'value\',\n                                            {\n                                              \'NOTNULL\' => 1,\n                                              \'TYPE\' => \'varchar(255)\'\n                                            },\n                                            \'class\',\n                                            {\n                                              \'DEFAULT\' => \'\\\'\\\'\',\n                                              \'NOTNULL\' => 1,\n                                              \'TYPE\' => \'varchar(255)\'\n                                            }\n                                          ],\n                              \'INDEXES\' => [\n                                             \'bug_see_also_bug_id_idx\',\n                                             {\n                                               \'FIELDS\' => [\n                                                             \'bug_id\',\n                                                             \'value\'\n                                                           ],\n                                               \'TYPE\' => \'UNIQUE\'\n                                             }\n                                           ]\n                            },\n          \'bug_severity\' => {\n                              \'FIELDS\' => [\n                                            \'id\',\n                                            {\n                                              \'NOTNULL\' => 1,\n                                              \'PRIMARYKEY\' => 1,\n                                              \'TYPE\' => \'SMALLSERIAL\'\n                                            },\n                                            \'value\',\n                                            {\n                                              \'NOTNULL\' => 1,\n                                              \'TYPE\' => \'varchar(64)\'\n                                            },\n                                            \'sortkey\',\n                                            {\n                                              \'DEFAULT\' => 0,\n                                              \'NOTNULL\' => 1,\n                                              \'TYPE\' => \'INT2\'\n                                            },\n                                            \'isactive\',\n                                            {\n                                              \'DEFAULT\' => \'TRUE\',\n                                              \'NOTNULL\' => 1,\n                                              \'TYPE\' => \'BOOLEAN\'\n                                            },\n                                            \'visibility_value_id\',\n                                            {\n                                              \'TYPE\' => \'INT2\'\n                                            }\n                                          ],\n                              \'INDEXES\' => [\n                                             \'bug_severity_value_idx\',\n                                             {\n                                               \'FIELDS\' => [\n                                                             \'value\'\n                                                           ],\n                                               \'TYPE\' => \'UNIQUE\'\n                                             },\n                                             \'bug_severity_sortkey_idx\',\n                                             [\n                                               \'sortkey\',\n                                               \'value\'\n                                             ],\n                                             \'bug_severity_visibility_value_id_idx\',\n                                             [\n                                               \'visibility_value_id\'\n                                             ]\n                                           ]\n                            },\n          \'bug_status\' => {\n                            \'FIELDS\' => [\n                                          \'id\',\n                                          {\n                                            \'NOTNULL\' => 1,\n                                            \'PRIMARYKEY\' => 1,\n                                            \'TYPE\' => \'SMALLSERIAL\'\n                                          },\n                                          \'value\',\n                                          {\n                                            \'NOTNULL\' => 1,\n                                            \'TYPE\' => \'varchar(64)\'\n                                          },\n                                          \'sortkey\',\n                                          {\n                                            \'DEFAULT\' => 0,\n                                            \'NOTNULL\' => 1,\n                                            \'TYPE\' => \'INT2\'\n                                          },\n                                          \'isactive\',\n                                          {\n                                            \'DEFAULT\' => \'TRUE\',\n                                            \'NOTNULL\' => 1,\n                                            \'TYPE\' => \'BOOLEAN\'\n                                          },\n                                          \'visibility_value_id\',\n                                          {\n                                            \'TYPE\' => \'INT2\'\n                                          },\n                                          \'is_open\',\n                                          {\n                                            \'DEFAULT\' => \'TRUE\',\n                                            \'NOTNULL\' => 1,\n                                            \'TYPE\' => \'BOOLEAN\'\n                                          }\n                                        ],\n                            \'INDEXES\' => [\n                                           \'bug_status_value_idx\',\n                                           {\n                                             \'FIELDS\' => [\n                                                           \'value\'\n                                                         ],\n                                             \'TYPE\' => \'UNIQUE\'\n                                           },\n                                           \'bug_status_sortkey_idx\',\n                                           [\n                                             \'sortkey\',\n                                             \'value\'\n                                           ],\n                                           \'bug_status_visibility_value_id_idx\',\n                                           [\n                                             \'visibility_value_id\'\n                                           ]\n                                         ]\n                          },\n          \'bug_tag\' => {\n                         \'FIELDS\' => [\n                                       \'bug_id\',\n                                       {\n                                         \'NOTNULL\' => 1,\n                                         \'REFERENCES\' => {\n                                                           \'COLUMN\' => \'bug_id\',\n                                                           \'DELETE\' => \'CASCADE\',\n                                                           \'TABLE\' => \'bugs\',\n                                                           \'created\' => 1\n                                                         },\n                                         \'TYPE\' => \'INT3\'\n                                       },\n                                       \'tag_id\',\n                                       {\n                                         \'NOTNULL\' => 1,\n                                         \'REFERENCES\' => {\n                                                           \'COLUMN\' => \'id\',\n                                                           \'DELETE\' => \'CASCADE\',\n                                                           \'TABLE\' => \'tag\',\n                                                           \'created\' => 1\n                                                         },\n                                         \'TYPE\' => \'INT3\'\n                                       }\n                                     ],\n                         \'INDEXES\' => [\n                                        \'bug_tag_bug_id_idx\',\n                                        {\n                                          \'FIELDS\' => [\n                                                        \'bug_id\',\n                                                        \'tag_id\'\n                                                      ],\n                                          \'TYPE\' => \'UNIQUE\'\n                                        }\n                                      ]\n                       },\n          \'bug_user_last_visit\' => {\n                                     \'FIELDS\' => [\n                                                   \'id\',\n                                                   {\n                                                     \'NOTNULL\' => 1,\n                                                     \'PRIMARYKEY\' => 1,\n                                                     \'TYPE\' => \'INTSERIAL\'\n                                                   },\n                                                   \'user_id\',\n                                                   {\n                                                     \'NOTNULL\' => 1,\n                                                     \'REFERENCES\' => {\n                                                                       \'COLUMN\' => \'userid\',\n                                                                       \'DELETE\' => \'CASCADE\',\n                                                                       \'TABLE\' => \'profiles\',\n                                                                       \'created\' => 1\n                                                                     },\n                                                     \'TYPE\' => \'INT3\'\n                                                   },\n                                                   \'bug_id\',\n                                                   {\n                                                     \'NOTNULL\' => 1,\n                                                     \'REFERENCES\' => {\n                                                                       \'COLUMN\' => \'bug_id\',\n                                                                       \'DELETE\' => \'CASCADE\',\n                                                                       \'TABLE\' => \'bugs\',\n                                                                       \'created\' => 1\n                                                                     },\n                                                     \'TYPE\' => \'INT3\'\n                                                   },\n                                                   \'last_visit_ts\',\n                                                   {\n                                                     \'NOTNULL\' => 1,\n                                                     \'TYPE\' => \'DATETIME\'\n                                                   }\n                                                 ],\n                                     \'INDEXES\' => [\n                                                    \'bug_user_last_visit_idx\',\n                                                    {\n                                                      \'FIELDS\' => [\n                                                                    \'user_id\',\n                                                                    \'bug_id\'\n                                                                  ],\n                                                      \'TYPE\' => \'UNIQUE\'\n                                                    },\n                                                    \'bug_user_last_visit_last_visit_ts_idx\',\n                                                    [\n                                                      \'last_visit_ts\'\n                                                    ]\n                                                  ]\n                                   },\n          \'bugs\' => {\n                      \'FIELDS\' => [\n                                    \'bug_id\',\n                                    {\n                                      \'NOTNULL\' => 1,\n                                      \'PRIMARYKEY\' => 1,\n                                      \'TYPE\' => \'MEDIUMSERIAL\'\n                                    },\n                                    \'assigned_to\',\n                                    {\n                                      \'NOTNULL\' => 1,\n                                      \'REFERENCES\' => {\n                                                        \'COLUMN\' => \'userid\',\n                                                        \'TABLE\' => \'profiles\',\n                                                        \'created\' => 1\n                                                      },\n                                      \'TYPE\' => \'INT3\'\n                                    },\n                                    \'bug_file_loc\',\n                                    {\n                                      \'DEFAULT\' => \'\\\'\\\'\',\n                                      \'NOTNULL\' => 1,\n                                      \'TYPE\' => \'MEDIUMTEXT\'\n                                    },\n                                    \'bug_severity\',\n                                    {\n                                      \'NOTNULL\' => 1,\n                                      \'TYPE\' => \'varchar(64)\'\n                                    },\n                                    \'bug_status\',\n                                    {\n                                      \'NOTNULL\' => 1,\n                                      \'TYPE\' => \'varchar(64)\'\n                                    },\n                                    \'creation_ts\',\n                                    {\n                                      \'TYPE\' => \'DATETIME\'\n                                    },\n                                    \'delta_ts\',\n                                    {\n                                      \'NOTNULL\' => 1,\n                                      \'TYPE\' => \'DATETIME\'\n                                    },\n                                    \'short_desc\',\n                                    {\n                                      \'NOTNULL\' => 1,\n                                      \'TYPE\' => \'varchar(255)\'\n                                    },\n                                    \'op_sys\',\n                                    {\n                                      \'NOTNULL\' => 1,\n                                      \'TYPE\' => \'varchar(64)\'\n                                    },\n                                    \'priority\',\n                                    {\n                                      \'NOTNULL\' => 1,\n                                      \'TYPE\' => \'varchar(64)\'\n                                    },\n                                    \'product_id\',\n                                    {\n                                      \'NOTNULL\' => 1,\n                                      \'REFERENCES\' => {\n                                                        \'COLUMN\' => \'id\',\n                                                        \'TABLE\' => \'products\',\n                                                        \'created\' => 1\n                                                      },\n                                      \'TYPE\' => \'INT2\'\n                                    },\n                                    \'rep_platform\',\n                                    {\n                                      \'NOTNULL\' => 1,\n                                      \'TYPE\' => \'varchar(64)\'\n                                    },\n                                    \'reporter\',\n                                    {\n                                      \'NOTNULL\' => 1,\n                                      \'REFERENCES\' => {\n                                                        \'COLUMN\' => \'userid\',\n                                                        \'TABLE\' => \'profiles\',\n                                                        \'created\' => 1\n                                                      },\n                                      \'TYPE\' => \'INT3\'\n                                    },\n                                    \'version\',\n                                    {\n                                      \'NOTNULL\' => 1,\n                                      \'TYPE\' => \'varchar(64)\'\n                                    },\n                                    \'component_id\',\n                                    {\n                                      \'NOTNULL\' => 1,\n                                      \'REFERENCES\' => {\n                                                        \'COLUMN\' => \'id\',\n                                                        \'TABLE\' => \'components\',\n                                                        \'created\' => 1\n                                                      },\n                                      \'TYPE\' => \'INT3\'\n                                    },\n                                    \'resolution\',\n                                    {\n                                      \'DEFAULT\' => \'\\\'\\\'\',\n                                      \'NOTNULL\' => 1,\n                                      \'TYPE\' => \'varchar(64)\'\n                                    },\n                                    \'target_milestone\',\n                                    {\n                                      \'DEFAULT\' => \'\\\'---\\\'\',\n                                      \'NOTNULL\' => 1,\n                                      \'TYPE\' => \'varchar(64)\'\n                                    },\n                                    \'qa_contact\',\n                                    {\n                                      \'REFERENCES\' => {\n                                                        \'COLUMN\' => \'userid\',\n                                                        \'TABLE\' => \'profiles\',\n                                                        \'created\' => 1\n                                                      },\n                                      \'TYPE\' => \'INT3\'\n                                    },\n                                    \'status_whiteboard\',\n                                    {\n                                      \'DEFAULT\' => \'\\\'\\\'\',\n                                      \'NOTNULL\' => 1,\n                                      \'TYPE\' => \'MEDIUMTEXT\'\n                                    },\n                                    \'lastdiffed\',\n                                    {\n                                      \'TYPE\' => \'DATETIME\'\n                                    },\n                                    \'everconfirmed\',\n                                    {\n                                      \'NOTNULL\' => 1,\n                                      \'TYPE\' => \'BOOLEAN\'\n                                    },\n                                    \'reporter_accessible\',\n                                    {\n                                      \'DEFAULT\' => \'TRUE\',\n                                      \'NOTNULL\' => 1,\n                                      \'TYPE\' => \'BOOLEAN\'\n                                    },\n                                    \'cclist_accessible\',\n                                    {\n                                      \'DEFAULT\' => \'TRUE\',\n                                      \'NOTNULL\' => 1,\n                                      \'TYPE\' => \'BOOLEAN\'\n                                    },\n                                    \'estimated_time\',\n                                    {\n                                      \'DEFAULT\' => \'0\',\n                                      \'NOTNULL\' => 1,\n                                      \'TYPE\' => \'decimal(7,2)\'\n                                    },\n                                    \'remaining_time\',\n                                    {\n                                      \'DEFAULT\' => \'0\',\n                                      \'NOTNULL\' => 1,\n                                      \'TYPE\' => \'decimal(7,2)\'\n                                    },\n                                    \'deadline\',\n                                    {\n                                      \'TYPE\' => \'DATETIME\'\n                                    }\n                                  ],\n                      \'INDEXES\' => [\n                                     \'bugs_assigned_to_idx\',\n                                     [\n                                       \'assigned_to\'\n                                     ],\n                                     \'bugs_creation_ts_idx\',\n                                     [\n                                       \'creation_ts\'\n                                     ],\n                                     \'bugs_delta_ts_idx\',\n                                     [\n                                       \'delta_ts\'\n                                     ],\n                                     \'bugs_bug_severity_idx\',\n                                     [\n                                       \'bug_severity\'\n                                     ],\n                                     \'bugs_bug_status_idx\',\n                                     [\n                                       \'bug_status\'\n                                     ],\n                                     \'bugs_op_sys_idx\',\n                                     [\n                                       \'op_sys\'\n                                     ],\n                                     \'bugs_priority_idx\',\n                                     [\n                                       \'priority\'\n                                     ],\n                                     \'bugs_product_id_idx\',\n                                     [\n                                       \'product_id\'\n                                     ],\n                                     \'bugs_reporter_idx\',\n                                     [\n                                       \'reporter\'\n                                     ],\n                                     \'bugs_version_idx\',\n                                     [\n                                       \'version\'\n                                     ],\n                                     \'bugs_component_id_idx\',\n                                     [\n                                       \'component_id\'\n                                     ],\n                                     \'bugs_resolution_idx\',\n                                     [\n                                       \'resolution\'\n                                     ],\n                                     \'bugs_target_milestone_idx\',\n                                     [\n                                       \'target_milestone\'\n                                     ],\n                                     \'bugs_qa_contact_idx\',\n                                     [\n                                       \'qa_contact\'\n                                     ]\n                                   ]\n                    },\n          \'bugs_activity\' => {\n                               \'FIELDS\' => [\n                                             \'id\',\n                                             {\n                                               \'NOTNULL\' => 1,\n                                               \'PRIMARYKEY\' => 1,\n                                               \'TYPE\' => \'INTSERIAL\'\n                                             },\n                                             \'bug_id\',\n                                             {\n                                               \'NOTNULL\' => 1,\n                                               \'REFERENCES\' => {\n                                                                 \'COLUMN\' => \'bug_id\',\n                                                                 \'DELETE\' => \'CASCADE\',\n                                                                 \'TABLE\' => \'bugs\',\n                                                                 \'created\' => 1\n                                                               },\n                                               \'TYPE\' => \'INT3\'\n                                             },\n                                             \'attach_id\',\n                                             {\n                                               \'REFERENCES\' => {\n                                                                 \'COLUMN\' => \'attach_id\',\n                                                                 \'DELETE\' => \'CASCADE\',\n                                                                 \'TABLE\' => \'attachments\',\n                                                                 \'created\' => 1\n                                                               },\n                                               \'TYPE\' => \'INT3\'\n                                             },\n                                             \'who\',\n                                             {\n                                               \'NOTNULL\' => 1,\n                                               \'REFERENCES\' => {\n                                                                 \'COLUMN\' => \'userid\',\n                                                                 \'TABLE\' => \'profiles\',\n                                                                 \'created\' => 1\n                                                               },\n                                               \'TYPE\' => \'INT3\'\n                                             },\n                                             \'bug_when\',\n                                             {\n                                               \'NOTNULL\' => 1,\n                                               \'TYPE\' => \'DATETIME\'\n                                             },\n                                             \'fieldid\',\n                                             {\n                                               \'NOTNULL\' => 1,\n                                               \'REFERENCES\' => {\n                                                                 \'COLUMN\' => \'id\',\n                                                                 \'TABLE\' => \'fielddefs\',\n                                                                 \'created\' => 1\n                                                               },\n                                               \'TYPE\' => \'INT3\'\n                                             },\n                                             \'added\',\n                                             {\n                                               \'TYPE\' => \'varchar(255)\'\n                                             },\n                                             \'removed\',\n                                             {\n                                               \'TYPE\' => \'varchar(255)\'\n                                             },\n                                             \'comment_id\',\n                                             {\n                                               \'REFERENCES\' => {\n                                                                 \'COLUMN\' => \'comment_id\',\n                                                                 \'DELETE\' => \'CASCADE\',\n                                                                 \'TABLE\' => \'longdescs\',\n                                                                 \'created\' => 1\n                                                               },\n                                               \'TYPE\' => \'INT4\'\n                                             }\n                                           ],\n                               \'INDEXES\' => [\n                                              \'bugs_activity_bug_id_idx\',\n                                              [\n                                                \'bug_id\'\n                                              ],\n                                              \'bugs_activity_who_idx\',\n                                              [\n                                                \'who\'\n                                              ],\n                                              \'bugs_activity_bug_when_idx\',\n                                              [\n                                                \'bug_when\'\n                                              ],\n                                              \'bugs_activity_fieldid_idx\',\n                                              [\n                                                \'fieldid\'\n                                              ],\n                                              \'bugs_activity_added_idx\',\n                                              [\n                                                \'added\'\n                                              ],\n                                              \'bugs_activity_removed_idx\',\n                                              [\n                                                \'removed\'\n                                              ]\n                                            ]\n                             },\n          \'bugs_aliases\' => {\n                              \'FIELDS\' => [\n                                            \'alias\',\n                                            {\n                                              \'NOTNULL\' => 1,\n                                              \'TYPE\' => \'varchar(40)\'\n                                            },\n                                            \'bug_id\',\n                                            {\n                                              \'REFERENCES\' => {\n                                                                \'COLUMN\' => \'bug_id\',\n                                                                \'DELETE\' => \'CASCADE\',\n                                                                \'TABLE\' => \'bugs\',\n                                                                \'created\' => 1\n                                                              },\n                                              \'TYPE\' => \'INT3\'\n                                            }\n                                          ],\n                              \'INDEXES\' => [\n                                             \'bugs_aliases_bug_id_idx\',\n                                             [\n                                               \'bug_id\'\n                                             ],\n                                             \'bugs_aliases_alias_idx\',\n                                             {\n                                               \'FIELDS\' => [\n                                                             \'alias\'\n                                                           ],\n                                               \'TYPE\' => \'UNIQUE\'\n                                             }\n                                           ]\n                            },\n          \'bugs_fulltext\' => {\n                               \'FIELDS\' => [\n                                             \'bug_id\',\n                                             {\n                                               \'NOTNULL\' => 1,\n                                               \'PRIMARYKEY\' => 1,\n                                               \'REFERENCES\' => {\n                                                                 \'COLUMN\' => \'bug_id\',\n                                                                 \'DELETE\' => \'CASCADE\',\n                                                                 \'TABLE\' => \'bugs\',\n                                                                 \'created\' => 1\n                                                               },\n                                               \'TYPE\' => \'INT3\'\n                                             },\n                                             \'short_desc\',\n                                             {\n                                               \'NOTNULL\' => 1,\n                                               \'TYPE\' => \'varchar(255)\'\n                                             },\n                                             \'comments\',\n                                             {\n                                               \'TYPE\' => \'LONGTEXT\'\n                                             },\n                                             \'comments_noprivate\',\n                                             {\n                                               \'TYPE\' => \'LONGTEXT\'\n                                             }\n                                           ],\n                               \'INDEXES\' => [\n                                              \'bugs_fulltext_short_desc_idx\',\n                                              {\n                                                \'FIELDS\' => [\n                                                              \'short_desc\'\n                                                            ],\n                                                \'TYPE\' => \'FULLTEXT\'\n                                              },\n                                              \'bugs_fulltext_comments_idx\',\n                                              {\n                                                \'FIELDS\' => [\n                                                              \'comments\'\n                                                            ],\n                                                \'TYPE\' => \'FULLTEXT\'\n                                              },\n                                              \'bugs_fulltext_comments_noprivate_idx\',\n                                              {\n                                                \'FIELDS\' => [\n                                                              \'comments_noprivate\'\n                                                            ],\n                                                \'TYPE\' => \'FULLTEXT\'\n                                              }\n                                            ]\n                             },\n          \'bz_schema\' => {\n                           \'FIELDS\' => [\n                                         \'schema_data\',\n                                         {\n                                           \'NOTNULL\' => 1,\n                                           \'TYPE\' => \'LONGBLOB\'\n                                         },\n                                         \'version\',\n                                         {\n                                           \'NOTNULL\' => 1,\n                                           \'TYPE\' => \'decimal(3,2)\'\n                                         }\n                                       ]\n                         },\n          \'category_group_map\' => {\n                                    \'FIELDS\' => [\n                                                  \'category_id\',\n                                                  {\n                                                    \'NOTNULL\' => 1,\n                                                    \'REFERENCES\' => {\n                                                                      \'COLUMN\' => \'id\',\n                                                                      \'DELETE\' => \'CASCADE\',\n                                                                      \'TABLE\' => \'series_categories\',\n                                                                      \'created\' => 1\n                                                                    },\n                                                    \'TYPE\' => \'INT2\'\n                                                  },\n                                                  \'group_id\',\n                                                  {\n                                                    \'NOTNULL\' => 1,\n                                                    \'REFERENCES\' => {\n                                                                      \'COLUMN\' => \'id\',\n                                                                      \'DELETE\' => \'CASCADE\',\n                                                                      \'TABLE\' => \'groups\',\n                                                                      \'created\' => 1\n                                                                    },\n                                                    \'TYPE\' => \'INT3\'\n                                                  }\n                                                ],\n                                    \'INDEXES\' => [\n                                                   \'category_group_map_category_id_idx\',\n                                                   {\n                                                     \'FIELDS\' => [\n                                                                   \'category_id\',\n                                                                   \'group_id\'\n                                                                 ],\n                                                     \'TYPE\' => \'UNIQUE\'\n                                                   }\n                                                 ]\n                                  },\n          \'cc\' => {\n                    \'FIELDS\' => [\n                                  \'bug_id\',\n                                  {\n                                    \'NOTNULL\' => 1,\n                                    \'REFERENCES\' => {\n                                                      \'COLUMN\' => \'bug_id\',\n                                                      \'DELETE\' => \'CASCADE\',\n                                                      \'TABLE\' => \'bugs\',\n                                                      \'created\' => 1\n                                                    },\n                                    \'TYPE\' => \'INT3\'\n                                  },\n                                  \'who\',\n                                  {\n                                    \'NOTNULL\' => 1,\n                                    \'REFERENCES\' => {\n                                                      \'COLUMN\' => \'userid\',\n                                                      \'DELETE\' => \'CASCADE\',\n                                                      \'TABLE\' => \'profiles\',\n                                                      \'created\' => 1\n                                                    },\n                                    \'TYPE\' => \'INT3\'\n                                  }\n                                ],\n                    \'INDEXES\' => [\n                                   \'cc_bug_id_idx\',\n                                   {\n                                     \'FIELDS\' => [\n                                                   \'bug_id\',\n                                                   \'who\'\n                                                 ],\n                                     \'TYPE\' => \'UNIQUE\'\n                                   },\n                                   \'cc_who_idx\',\n                                   [\n                                     \'who\'\n                                   ]\n                                 ]\n                  },\n          \'classifications\' => {\n                                 \'FIELDS\' => [\n                                               \'id\',\n                                               {\n                                                 \'NOTNULL\' => 1,\n                                                 \'PRIMARYKEY\' => 1,\n                                                 \'TYPE\' => \'SMALLSERIAL\'\n                                               },\n                                               \'name\',\n                                               {\n                                                 \'NOTNULL\' => 1,\n                                                 \'TYPE\' => \'varchar(64)\'\n                                               },\n                                               \'description\',\n                                               {\n                                                 \'TYPE\' => \'MEDIUMTEXT\'\n                                               },\n                                               \'sortkey\',\n                                               {\n                                                 \'DEFAULT\' => \'0\',\n                                                 \'NOTNULL\' => 1,\n                                                 \'TYPE\' => \'INT2\'\n                                               }\n                                             ],\n                                 \'INDEXES\' => [\n                                                \'classifications_name_idx\',\n                                                {\n                                                  \'FIELDS\' => [\n                                                                \'name\'\n                                                              ],\n                                                  \'TYPE\' => \'UNIQUE\'\n                                                }\n                                              ]\n                               },\n          \'component_cc\' => {\n                              \'FIELDS\' => [\n                                            \'user_id\',\n                                            {\n                                              \'NOTNULL\' => 1,\n                                              \'REFERENCES\' => {\n                                                                \'COLUMN\' => \'userid\',\n                                                                \'DELETE\' => \'CASCADE\',\n                                                                \'TABLE\' => \'profiles\',\n                                                                \'created\' => 1\n                                                              },\n                                              \'TYPE\' => \'INT3\'\n                                            },\n                                            \'component_id\',\n                                            {\n                                              \'NOTNULL\' => 1,\n                                              \'REFERENCES\' => {\n                                                                \'COLUMN\' => \'id\',\n                                                                \'DELETE\' => \'CASCADE\',\n                                                                \'TABLE\' => \'components\',\n                                                                \'created\' => 1\n                                                              },\n                                              \'TYPE\' => \'INT3\'\n                                            }\n                                          ],\n                              \'INDEXES\' => [\n                                             \'component_cc_user_id_idx\',\n                                             {\n                                               \'FIELDS\' => [\n                                                             \'component_id\',\n                                                             \'user_id\'\n                                                           ],\n                                               \'TYPE\' => \'UNIQUE\'\n                                             }\n                                           ]\n                            },\n          \'components\' => {\n                            \'FIELDS\' => [\n                                          \'id\',\n                                          {\n                                            \'NOTNULL\' => 1,\n                                            \'PRIMARYKEY\' => 1,\n                                            \'TYPE\' => \'MEDIUMSERIAL\'\n                                          },\n                                          \'name\',\n                                          {\n                                            \'NOTNULL\' => 1,\n                                            \'TYPE\' => \'varchar(64)\'\n                                          },\n                                          \'product_id\',\n                                          {\n                                            \'NOTNULL\' => 1,\n                                            \'REFERENCES\' => {\n                                                              \'COLUMN\' => \'id\',\n                                                              \'DELETE\' => \'CASCADE\',\n                                                              \'TABLE\' => \'products\',\n                                                              \'created\' => 1\n                                                            },\n                                            \'TYPE\' => \'INT2\'\n                                          },\n                                          \'initialowner\',\n                                          {\n                                            \'NOTNULL\' => 1,\n                                            \'REFERENCES\' => {\n                                                              \'COLUMN\' => \'userid\',\n                                                              \'TABLE\' => \'profiles\',\n                                                              \'created\' => 1\n                                                            },\n                                            \'TYPE\' => \'INT3\'\n                                          },\n                                          \'initialqacontact\',\n                                          {\n                                            \'REFERENCES\' => {\n                                                              \'COLUMN\' => \'userid\',\n                                                              \'DELETE\' => \'SET NULL\',\n                                                              \'TABLE\' => \'profiles\',\n                                                              \'created\' => 1\n                                                            },\n                                            \'TYPE\' => \'INT3\'\n                                          },\n                                          \'description\',\n                                          {\n                                            \'NOTNULL\' => 1,\n                                            \'TYPE\' => \'MEDIUMTEXT\'\n                                          },\n                                          \'isactive\',\n                                          {\n                                            \'DEFAULT\' => \'TRUE\',\n                                            \'NOTNULL\' => 1,\n                                            \'TYPE\' => \'BOOLEAN\'\n                                          }\n                                        ],\n                            \'INDEXES\' => [\n                                           \'components_product_id_idx\',\n                                           {\n                                             \'FIELDS\' => [\n                                                           \'product_id\',\n                                                           \'name\'\n                                                         ],\n                                             \'TYPE\' => \'UNIQUE\'\n                                           },\n                                           \'components_name_idx\',\n                                           [\n                                             \'name\'\n                                           ]\n                                         ]\n                          },\n          \'dependencies\' => {\n                              \'FIELDS\' => [\n                                            \'blocked\',\n                                            {\n                                              \'NOTNULL\' => 1,\n                                              \'REFERENCES\' => {\n                                                                \'COLUMN\' => \'bug_id\',\n                                                                \'DELETE\' => \'CASCADE\',\n                                                                \'TABLE\' => \'bugs\',\n                                                                \'created\' => 1\n                                                              },\n                                              \'TYPE\' => \'INT3\'\n                                            },\n                                            \'dependson\',\n                                            {\n                                              \'NOTNULL\' => 1,\n                                              \'REFERENCES\' => {\n                                                                \'COLUMN\' => \'bug_id\',\n                                                                \'DELETE\' => \'CASCADE\',\n                                                                \'TABLE\' => \'bugs\',\n                                                                \'created\' => 1\n                                                              },\n                                              \'TYPE\' => \'INT3\'\n                                            }\n                                          ],\n                              \'INDEXES\' => [\n                                             \'dependencies_blocked_idx\',\n                                             {\n                                               \'FIELDS\' => [\n                                                             \'blocked\',\n                                                             \'dependson\'\n                                                           ],\n                                               \'TYPE\' => \'UNIQUE\'\n                                             },\n                                             \'dependencies_dependson_idx\',\n                                             [\n                                               \'dependson\'\n                                             ]\n                                           ]\n                            },\n          \'duplicates\' => {\n                            \'FIELDS\' => [\n                                          \'dupe_of\',\n                                          {\n                                            \'NOTNULL\' => 1,\n                                            \'REFERENCES\' => {\n                                                              \'COLUMN\' => \'bug_id\',\n                                                              \'DELETE\' => \'CASCADE\',\n                                                              \'TABLE\' => \'bugs\',\n                                                              \'created\' => 1\n                                                            },\n                                            \'TYPE\' => \'INT3\'\n                                          },\n                                          \'dupe\',\n                                          {\n                                            \'NOTNULL\' => 1,\n                                            \'PRIMARYKEY\' => 1,\n                                            \'REFERENCES\' => {\n                                                              \'COLUMN\' => \'bug_id\',\n                                                              \'DELETE\' => \'CASCADE\',\n                                                              \'TABLE\' => \'bugs\',\n                                                              \'created\' => 1\n                                                            },\n                                            \'TYPE\' => \'INT3\'\n                                          }\n                                        ]\n                          },\n          \'email_bug_ignore\' => {\n                                  \'FIELDS\' => [\n                                                \'user_id\',\n                                                {\n                                                  \'NOTNULL\' => 1,\n                                                  \'REFERENCES\' => {\n                                                                    \'COLUMN\' => \'userid\',\n                                                                    \'DELETE\' => \'CASCADE\',\n                                                                    \'TABLE\' => \'profiles\',\n                                                                    \'created\' => 1\n                                                                  },\n                                                  \'TYPE\' => \'INT3\'\n                                                },\n                                                \'bug_id\',\n                                                {\n                                                  \'NOTNULL\' => 1,\n                                                  \'REFERENCES\' => {\n                                                                    \'COLUMN\' => \'bug_id\',\n                                                                    \'DELETE\' => \'CASCADE\',\n                                                                    \'TABLE\' => \'bugs\',\n                                                                    \'created\' => 1\n                                                                  },\n                                                  \'TYPE\' => \'INT3\'\n                                                }\n                                              ],\n                                  \'INDEXES\' => [\n                                                 \'email_bug_ignore_user_id_idx\',\n                                                 {\n                                                   \'FIELDS\' => [\n                                                                 \'user_id\',\n                                                                 \'bug_id\'\n                                                               ],\n                                                   \'TYPE\' => \'UNIQUE\'\n                                                 }\n                                               ]\n                                },\n          \'email_setting\' => {\n                               \'FIELDS\' => [\n                                             \'user_id\',\n                                             {\n                                               \'NOTNULL\' => 1,\n                                               \'REFERENCES\' => {\n                                                                 \'COLUMN\' => \'userid\',\n                                                                 \'DELETE\' => \'CASCADE\',\n                                                                 \'TABLE\' => \'profiles\',\n                                                                 \'created\' => 1\n                                                               },\n                                               \'TYPE\' => \'INT3\'\n                                             },\n                                             \'relationship\',\n                                             {\n                                               \'NOTNULL\' => 1,\n                                               \'TYPE\' => \'INT1\'\n                                             },\n                                             \'event\',\n                                             {\n                                               \'NOTNULL\' => 1,\n                                               \'TYPE\' => \'INT1\'\n                                             }\n                                           ],\n                               \'INDEXES\' => [\n                                              \'email_setting_user_id_idx\',\n                                              {\n                                                \'FIELDS\' => [\n                                                              \'user_id\',\n                                                              \'relationship\',\n                                                              \'event\'\n                                                            ],\n                                                \'TYPE\' => \'UNIQUE\'\n                                              }\n                                            ]\n                             },\n          \'field_visibility\' => {\n                                  \'FIELDS\' => [\n                                                \'field_id\',\n                                                {\n                                                  \'REFERENCES\' => {\n                                                                    \'COLUMN\' => \'id\',\n                                                                    \'DELETE\' => \'CASCADE\',\n                                                                    \'TABLE\' => \'fielddefs\',\n                                                                    \'created\' => 1\n                                                                  },\n                                                  \'TYPE\' => \'INT3\'\n                                                },\n                                                \'value_id\',\n                                                {\n                                                  \'NOTNULL\' => 1,\n                                                  \'TYPE\' => \'INT2\'\n                                                }\n                                              ],\n                                  \'INDEXES\' => [\n                                                 \'field_visibility_field_id_idx\',\n                                                 {\n                                                   \'FIELDS\' => [\n                                                                 \'field_id\',\n                                                                 \'value_id\'\n                                                               ],\n                                                   \'TYPE\' => \'UNIQUE\'\n                                                 }\n                                               ]\n                                },\n          \'fielddefs\' => {\n                           \'FIELDS\' => [\n                                         \'id\',\n                                         {\n                                           \'NOTNULL\' => 1,\n                                           \'PRIMARYKEY\' => 1,\n                                           \'TYPE\' => \'MEDIUMSERIAL\'\n                                         },\n                                         \'name\',\n                                         {\n                                           \'NOTNULL\' => 1,\n                                           \'TYPE\' => \'varchar(64)\'\n                                         },\n                                         \'type\',\n                                         {\n                                           \'DEFAULT\' => 0,\n                                           \'NOTNULL\' => 1,\n                                           \'TYPE\' => \'INT2\'\n                                         },\n                                         \'custom\',\n                                         {\n                                           \'DEFAULT\' => \'FALSE\',\n                                           \'NOTNULL\' => 1,\n                                           \'TYPE\' => \'BOOLEAN\'\n                                         },\n                                         \'description\',\n                                         {\n                                           \'NOTNULL\' => 1,\n                                           \'TYPE\' => \'TINYTEXT\'\n                                         },\n                                         \'long_desc\',\n                                         {\n                                           \'DEFAULT\' => \'\\\'\\\'\',\n                                           \'NOTNULL\' => 1,\n                                           \'TYPE\' => \'varchar(255)\'\n                                         },\n                                         \'mailhead\',\n                                         {\n                                           \'DEFAULT\' => \'FALSE\',\n                                           \'NOTNULL\' => 1,\n                                           \'TYPE\' => \'BOOLEAN\'\n                                         },\n                                         \'sortkey\',\n                                         {\n                                           \'NOTNULL\' => 1,\n                                           \'TYPE\' => \'INT2\'\n                                         },\n                                         \'obsolete\',\n                                         {\n                                           \'DEFAULT\' => \'FALSE\',\n                                           \'NOTNULL\' => 1,\n                                           \'TYPE\' => \'BOOLEAN\'\n                                         },\n                                         \'enter_bug\',\n                                         {\n                                           \'DEFAULT\' => \'FALSE\',\n                                           \'NOTNULL\' => 1,\n                                           \'TYPE\' => \'BOOLEAN\'\n                                         },\n                                         \'buglist\',\n                                         {\n                                           \'DEFAULT\' => \'FALSE\',\n                                           \'NOTNULL\' => 1,\n                                           \'TYPE\' => \'BOOLEAN\'\n                                         },\n                                         \'visibility_field_id\',\n                                         {\n                                           \'REFERENCES\' => {\n                                                             \'COLUMN\' => \'id\',\n                                                             \'TABLE\' => \'fielddefs\',\n                                                             \'created\' => 1\n                                                           },\n                                           \'TYPE\' => \'INT3\'\n                                         },\n                                         \'value_field_id\',\n                                         {\n                                           \'REFERENCES\' => {\n                                                             \'COLUMN\' => \'id\',\n                                                             \'TABLE\' => \'fielddefs\',\n                                                             \'created\' => 1\n                                                           },\n                                           \'TYPE\' => \'INT3\'\n                                         },\n                                         \'reverse_desc\',\n                                         {\n                                           \'TYPE\' => \'TINYTEXT\'\n                                         },\n                                         \'is_mandatory\',\n                                         {\n                                           \'DEFAULT\' => \'FALSE\',\n                                           \'NOTNULL\' => 1,\n                                           \'TYPE\' => \'BOOLEAN\'\n                                         },\n                                         \'is_numeric\',\n                                         {\n                                           \'DEFAULT\' => \'FALSE\',\n                                           \'NOTNULL\' => 1,\n                                           \'TYPE\' => \'BOOLEAN\'\n                                         }\n                                       ],\n                           \'INDEXES\' => [\n                                          \'fielddefs_name_idx\',\n                                          {\n                                            \'FIELDS\' => [\n                                                          \'name\'\n                                                        ],\n                                            \'TYPE\' => \'UNIQUE\'\n                                          },\n                                          \'fielddefs_sortkey_idx\',\n                                          [\n                                            \'sortkey\'\n                                          ],\n                                          \'fielddefs_value_field_id_idx\',\n                                          [\n                                            \'value_field_id\'\n                                          ],\n                                          \'fielddefs_is_mandatory_idx\',\n                                          [\n                                            \'is_mandatory\'\n                                          ]\n                                        ]\n                         },\n          \'flagexclusions\' => {\n                                \'FIELDS\' => [\n                                              \'type_id\',\n                                              {\n                                                \'NOTNULL\' => 1,\n                                                \'REFERENCES\' => {\n                                                                  \'COLUMN\' => \'id\',\n                                                                  \'DELETE\' => \'CASCADE\',\n                                                                  \'TABLE\' => \'flagtypes\',\n                                                                  \'created\' => 1\n                                                                },\n                                                \'TYPE\' => \'INT2\'\n                                              },\n                                              \'product_id\',\n                                              {\n                                                \'REFERENCES\' => {\n                                                                  \'COLUMN\' => \'id\',\n                                                                  \'DELETE\' => \'CASCADE\',\n                                                                  \'TABLE\' => \'products\',\n                                                                  \'created\' => 1\n                                                                },\n                                                \'TYPE\' => \'INT2\'\n                                              },\n                                              \'component_id\',\n                                              {\n                                                \'REFERENCES\' => {\n                                                                  \'COLUMN\' => \'id\',\n                                                                  \'DELETE\' => \'CASCADE\',\n                                                                  \'TABLE\' => \'components\',\n                                                                  \'created\' => 1\n                                                                },\n                                                \'TYPE\' => \'INT3\'\n                                              }\n                                            ],\n                                \'INDEXES\' => [\n                                               \'flagexclusions_type_id_idx\',\n                                               {\n                                                 \'FIELDS\' => [\n                                                               \'type_id\',\n                                                               \'product_id\',\n                                                               \'component_id\'\n                                                             ],\n                                                 \'TYPE\' => \'UNIQUE\'\n                                               }\n                                             ]\n                              },\n          \'flaginclusions\' => {\n                                \'FIELDS\' => [\n                                              \'type_id\',\n                                              {\n                                                \'NOTNULL\' => 1,\n                                                \'REFERENCES\' => {\n                                                                  \'COLUMN\' => \'id\',\n                                                                  \'DELETE\' => \'CASCADE\',\n                                                                  \'TABLE\' => \'flagtypes\',\n                                                                  \'created\' => 1\n                                                                },\n                                                \'TYPE\' => \'INT2\'\n                                              },\n                                              \'product_id\',\n                                              {\n                                                \'REFERENCES\' => {\n                                                                  \'COLUMN\' => \'id\',\n                                                                  \'DELETE\' => \'CASCADE\',\n                                                                  \'TABLE\' => \'products\',\n                                                                  \'created\' => 1\n                                                                },\n                                                \'TYPE\' => \'INT2\'\n                                              },\n                                              \'component_id\',\n                                              {\n                                                \'REFERENCES\' => {\n                                                                  \'COLUMN\' => \'id\',\n                                                                  \'DELETE\' => \'CASCADE\',\n                                                                  \'TABLE\' => \'components\',\n                                                                  \'created\' => 1\n                                                                },\n                                                \'TYPE\' => \'INT3\'\n                                              }\n                                            ],\n                                \'INDEXES\' => [\n                                               \'flaginclusions_type_id_idx\',\n                                               {\n                                                 \'FIELDS\' => [\n                                                               \'type_id\',\n                                                               \'product_id\',\n                                                               \'component_id\'\n                                                             ],\n                                                 \'TYPE\' => \'UNIQUE\'\n                                               }\n                                             ]\n                              },\n          \'flags\' => {\n                       \'FIELDS\' => [\n                                     \'id\',\n                                     {\n                                       \'NOTNULL\' => 1,\n                                       \'PRIMARYKEY\' => 1,\n                                       \'TYPE\' => \'MEDIUMSERIAL\'\n                                     },\n                                     \'type_id\',\n                                     {\n                                       \'NOTNULL\' => 1,\n                                       \'REFERENCES\' => {\n                                                         \'COLUMN\' => \'id\',\n                                                         \'DELETE\' => \'CASCADE\',\n                                                         \'TABLE\' => \'flagtypes\',\n                                                         \'created\' => 1\n                                                       },\n                                       \'TYPE\' => \'INT2\'\n                                     },\n                                     \'status\',\n                                     {\n                                       \'NOTNULL\' => 1,\n                                       \'TYPE\' => \'char(1)\'\n                                     },\n                                     \'bug_id\',\n                                     {\n                                       \'NOTNULL\' => 1,\n                                       \'REFERENCES\' => {\n                                                         \'COLUMN\' => \'bug_id\',\n                                                         \'DELETE\' => \'CASCADE\',\n                                                         \'TABLE\' => \'bugs\',\n                                                         \'created\' => 1\n                                                       },\n                                       \'TYPE\' => \'INT3\'\n                                     },\n                                     \'attach_id\',\n                                     {\n                                       \'REFERENCES\' => {\n                                                         \'COLUMN\' => \'attach_id\',\n                                                         \'DELETE\' => \'CASCADE\',\n                                                         \'TABLE\' => \'attachments\',\n                                                         \'created\' => 1\n                                                       },\n                                       \'TYPE\' => \'INT3\'\n                                     },\n                                     \'creation_date\',\n                                     {\n                                       \'NOTNULL\' => 1,\n                                       \'TYPE\' => \'DATETIME\'\n                                     },\n                                     \'modification_date\',\n                                     {\n                                       \'TYPE\' => \'DATETIME\'\n                                     },\n                                     \'setter_id\',\n                                     {\n                                       \'NOTNULL\' => 1,\n                                       \'REFERENCES\' => {\n                                                         \'COLUMN\' => \'userid\',\n                                                         \'TABLE\' => \'profiles\',\n                                                         \'created\' => 1\n                                                       },\n                                       \'TYPE\' => \'INT3\'\n                                     },\n                                     \'requestee_id\',\n                                     {\n                                       \'REFERENCES\' => {\n                                                         \'COLUMN\' => \'userid\',\n                                                         \'TABLE\' => \'profiles\',\n                                                         \'created\' => 1\n                                                       },\n                                       \'TYPE\' => \'INT3\'\n                                     }\n                                   ],\n                       \'INDEXES\' => [\n                                      \'flags_bug_id_idx\',\n                                      [\n                                        \'bug_id\',\n                                        \'attach_id\'\n                                      ],\n                                      \'flags_setter_id_idx\',\n                                      [\n                                        \'setter_id\'\n                                      ],\n                                      \'flags_requestee_id_idx\',\n                                      [\n                                        \'requestee_id\'\n                                      ],\n                                      \'flags_type_id_idx\',\n                                      [\n                                        \'type_id\'\n                                      ]\n                                    ]\n                     },\n          \'flagtypes\' => {\n                           \'FIELDS\' => [\n                                         \'id\',\n                                         {\n                                           \'NOTNULL\' => 1,\n                                           \'PRIMARYKEY\' => 1,\n                                           \'TYPE\' => \'SMALLSERIAL\'\n                                         },\n                                         \'name\',\n                                         {\n                                           \'NOTNULL\' => 1,\n                                           \'TYPE\' => \'varchar(50)\'\n                                         },\n                                         \'description\',\n                                         {\n                                           \'NOTNULL\' => 1,\n                                           \'TYPE\' => \'MEDIUMTEXT\'\n                                         },\n                                         \'cc_list\',\n                                         {\n                                           \'TYPE\' => \'varchar(200)\'\n                                         },\n                                         \'target_type\',\n                                         {\n                                           \'DEFAULT\' => \'\\\'b\\\'\',\n                                           \'NOTNULL\' => 1,\n                                           \'TYPE\' => \'char(1)\'\n                                         },\n                                         \'is_active\',\n                                         {\n                                           \'DEFAULT\' => \'TRUE\',\n                                           \'NOTNULL\' => 1,\n                                           \'TYPE\' => \'BOOLEAN\'\n                                         },\n                                         \'is_requestable\',\n                                         {\n                                           \'DEFAULT\' => \'FALSE\',\n                                           \'NOTNULL\' => 1,\n                                           \'TYPE\' => \'BOOLEAN\'\n                                         },\n                                         \'is_requesteeble\',\n                                         {\n                                           \'DEFAULT\' => \'FALSE\',\n                                           \'NOTNULL\' => 1,\n                                           \'TYPE\' => \'BOOLEAN\'\n                                         },\n                                         \'is_multiplicable\',\n                                         {\n                                           \'DEFAULT\' => \'FALSE\',\n                                           \'NOTNULL\' => 1,\n                                           \'TYPE\' => \'BOOLEAN\'\n                                         },\n                                         \'sortkey\',\n                                         {\n                                           \'DEFAULT\' => \'0\',\n                                           \'NOTNULL\' => 1,\n                                           \'TYPE\' => \'INT2\'\n                                         },\n                                         \'grant_group_id\',\n                                         {\n                                           \'REFERENCES\' => {\n                                                             \'COLUMN\' => \'id\',\n                                                             \'DELETE\' => \'SET NULL\',\n                                                             \'TABLE\' => \'groups\',\n                                                             \'created\' => 1\n                                                           },\n                                           \'TYPE\' => \'INT3\'\n                                         },\n                                         \'request_group_id\',\n                                         {\n                                           \'REFERENCES\' => {\n                                                             \'COLUMN\' => \'id\',\n                                                             \'DELETE\' => \'SET NULL\',\n                                                             \'TABLE\' => \'groups\',\n                                                             \'created\' => 1\n                                                           },\n                                           \'TYPE\' => \'INT3\'\n                                         }\n                                       ]\n                         },\n          \'group_control_map\' => {\n                                   \'FIELDS\' => [\n                                                 \'group_id\',\n                                                 {\n                                                   \'NOTNULL\' => 1,\n                                                   \'REFERENCES\' => {\n                                                                     \'COLUMN\' => \'id\',\n                                                                     \'DELETE\' => \'CASCADE\',\n                                                                     \'TABLE\' => \'groups\',\n                                                                     \'created\' => 1\n                                                                   },\n                                                   \'TYPE\' => \'INT3\'\n                                                 },\n                                                 \'product_id\',\n                                                 {\n                                                   \'NOTNULL\' => 1,\n                                                   \'REFERENCES\' => {\n                                                                     \'COLUMN\' => \'id\',\n                                                                     \'DELETE\' => \'CASCADE\',\n                                                                     \'TABLE\' => \'products\',\n                                                                     \'created\' => 1\n                                                                   },\n                                                   \'TYPE\' => \'INT2\'\n                                                 },\n                                                 \'entry\',\n                                                 {\n                                                   \'DEFAULT\' => \'FALSE\',\n                                                   \'NOTNULL\' => 1,\n                                                   \'TYPE\' => \'BOOLEAN\'\n                                                 },\n                                                 \'membercontrol\',\n                                                 {\n                                                   \'DEFAULT\' => \'0\',\n                                                   \'NOTNULL\' => 1,\n                                                   \'TYPE\' => \'INT1\'\n                                                 },\n                                                 \'othercontrol\',\n                                                 {\n                                                   \'DEFAULT\' => \'0\',\n                                                   \'NOTNULL\' => 1,\n                                                   \'TYPE\' => \'INT1\'\n                                                 },\n                                                 \'canedit\',\n                                                 {\n                                                   \'DEFAULT\' => \'FALSE\',\n                                                   \'NOTNULL\' => 1,\n                                                   \'TYPE\' => \'BOOLEAN\'\n                                                 },\n                                                 \'editcomponents\',\n                                                 {\n                                                   \'DEFAULT\' => \'FALSE\',\n                                                   \'NOTNULL\' => 1,\n                                                   \'TYPE\' => \'BOOLEAN\'\n                                                 },\n                                                 \'editbugs\',\n                                                 {\n                                                   \'DEFAULT\' => \'FALSE\',\n                                                   \'NOTNULL\' => 1,\n                                                   \'TYPE\' => \'BOOLEAN\'\n                                                 },\n                                                 \'canconfirm\',\n                                                 {\n                                                   \'DEFAULT\' => \'FALSE\',\n                                                   \'NOTNULL\' => 1,\n                                                   \'TYPE\' => \'BOOLEAN\'\n                                                 }\n                                               ],\n                                   \'INDEXES\' => [\n                                                  \'group_control_map_product_id_idx\',\n                                                  {\n                                                    \'FIELDS\' => [\n                                                                  \'product_id\',\n                                                                  \'group_id\'\n                                                                ],\n                                                    \'TYPE\' => \'UNIQUE\'\n                                                  },\n                                                  \'group_control_map_group_id_idx\',\n                                                  [\n                                                    \'group_id\'\n                                                  ]\n                                                ]\n                                 },\n          \'group_group_map\' => {\n                                 \'FIELDS\' => [\n                                               \'member_id\',\n                                               {\n                                                 \'NOTNULL\' => 1,\n                                                 \'REFERENCES\' => {\n                                                                   \'COLUMN\' => \'id\',\n                                                                   \'DELETE\' => \'CASCADE\',\n                                                                   \'TABLE\' => \'groups\',\n                                                                   \'created\' => 1\n                                                                 },\n                                                 \'TYPE\' => \'INT3\'\n                                               },\n                                               \'grantor_id\',\n                                               {\n                                                 \'NOTNULL\' => 1,\n                                                 \'REFERENCES\' => {\n                                                                   \'COLUMN\' => \'id\',\n                                                                   \'DELETE\' => \'CASCADE\',\n                                                                   \'TABLE\' => \'groups\',\n                                                                   \'created\' => 1\n                                                                 },\n                                                 \'TYPE\' => \'INT3\'\n                                               },\n                                               \'grant_type\',\n                                               {\n                                                 \'DEFAULT\' => \'0\',\n                                                 \'NOTNULL\' => 1,\n                                                 \'TYPE\' => \'INT1\'\n                                               }\n                                             ],\n                                 \'INDEXES\' => [\n                                                \'group_group_map_member_id_idx\',\n                                                {\n                                                  \'FIELDS\' => [\n                                                                \'member_id\',\n                                                                \'grantor_id\',\n                                                                \'grant_type\'\n                                                              ],\n                                                  \'TYPE\' => \'UNIQUE\'\n                                                }\n                                              ]\n                               },\n          \'groups\' => {\n                        \'FIELDS\' => [\n                                      \'id\',\n                                      {\n                                        \'NOTNULL\' => 1,\n                                        \'PRIMARYKEY\' => 1,\n                                        \'TYPE\' => \'MEDIUMSERIAL\'\n                                      },\n                                      \'name\',\n                                      {\n                                        \'NOTNULL\' => 1,\n                                        \'TYPE\' => \'varchar(255)\'\n                                      },\n                                      \'description\',\n                                      {\n                                        \'NOTNULL\' => 1,\n                                        \'TYPE\' => \'MEDIUMTEXT\'\n                                      },\n                                      \'isbuggroup\',\n                                      {\n                                        \'NOTNULL\' => 1,\n                                        \'TYPE\' => \'BOOLEAN\'\n                                      },\n                                      \'userregexp\',\n                                      {\n                                        \'DEFAULT\' => \'\\\'\\\'\',\n                                        \'NOTNULL\' => 1,\n                                        \'TYPE\' => \'TINYTEXT\'\n                                      },\n                                      \'isactive\',\n                                      {\n                                        \'DEFAULT\' => \'TRUE\',\n                                        \'NOTNULL\' => 1,\n                                        \'TYPE\' => \'BOOLEAN\'\n                                      },\n                                      \'icon_url\',\n                                      {\n                                        \'TYPE\' => \'TINYTEXT\'\n                                      }\n                                    ],\n                        \'INDEXES\' => [\n                                       \'groups_name_idx\',\n                                       {\n                                         \'FIELDS\' => [\n                                                       \'name\'\n                                                     ],\n                                         \'TYPE\' => \'UNIQUE\'\n                                       }\n                                     ]\n                      },\n          \'keyworddefs\' => {\n                             \'FIELDS\' => [\n                                           \'id\',\n                                           {\n                                             \'NOTNULL\' => 1,\n                                             \'PRIMARYKEY\' => 1,\n                                             \'TYPE\' => \'SMALLSERIAL\'\n                                           },\n                                           \'name\',\n                                           {\n                                             \'NOTNULL\' => 1,\n                                             \'TYPE\' => \'varchar(64)\'\n                                           },\n                                           \'description\',\n                                           {\n                                             \'NOTNULL\' => 1,\n                                             \'TYPE\' => \'MEDIUMTEXT\'\n                                           }\n                                         ],\n                             \'INDEXES\' => [\n                                            \'keyworddefs_name_idx\',\n                                            {\n                                              \'FIELDS\' => [\n                                                            \'name\'\n                                                          ],\n                                              \'TYPE\' => \'UNIQUE\'\n                                            }\n                                          ]\n                           },\n          \'keywords\' => {\n                          \'FIELDS\' => [\n                                        \'bug_id\',\n                                        {\n                                          \'NOTNULL\' => 1,\n                                          \'REFERENCES\' => {\n                                                            \'COLUMN\' => \'bug_id\',\n                                                            \'DELETE\' => \'CASCADE\',\n                                                            \'TABLE\' => \'bugs\',\n                                                            \'created\' => 1\n                                                          },\n                                          \'TYPE\' => \'INT3\'\n                                        },\n                                        \'keywordid\',\n                                        {\n                                          \'NOTNULL\' => 1,\n                                          \'REFERENCES\' => {\n                                                            \'COLUMN\' => \'id\',\n                                                            \'DELETE\' => \'CASCADE\',\n                                                            \'TABLE\' => \'keyworddefs\',\n                                                            \'created\' => 1\n                                                          },\n                                          \'TYPE\' => \'INT2\'\n                                        }\n                                      ],\n                          \'INDEXES\' => [\n                                         \'keywords_bug_id_idx\',\n                                         {\n                                           \'FIELDS\' => [\n                                                         \'bug_id\',\n                                                         \'keywordid\'\n                                                       ],\n                                           \'TYPE\' => \'UNIQUE\'\n                                         },\n                                         \'keywords_keywordid_idx\',\n                                         [\n                                           \'keywordid\'\n                                         ]\n                                       ]\n                        },\n          \'login_failure\' => {\n                               \'FIELDS\' => [\n                                             \'user_id\',\n                                             {\n                                               \'NOTNULL\' => 1,\n                                               \'REFERENCES\' => {\n                                                                 \'COLUMN\' => \'userid\',\n                                                                 \'DELETE\' => \'CASCADE\',\n                                                                 \'TABLE\' => \'profiles\',\n                                                                 \'created\' => 1\n                                                               },\n                                               \'TYPE\' => \'INT3\'\n                                             },\n                                             \'login_time\',\n                                             {\n                                               \'NOTNULL\' => 1,\n                                               \'TYPE\' => \'DATETIME\'\n                                             },\n                                             \'ip_addr\',\n                                             {\n                                               \'NOTNULL\' => 1,\n                                               \'TYPE\' => \'varchar(40)\'\n                                             }\n                                           ],\n                               \'INDEXES\' => [\n                                              \'login_failure_user_id_idx\',\n                                              [\n                                                \'user_id\'\n                                              ]\n                                            ]\n                             },\n          \'logincookies\' => {\n                              \'FIELDS\' => [\n                                            \'cookie\',\n                                            {\n                                              \'NOTNULL\' => 1,\n                                              \'PRIMARYKEY\' => 1,\n                                              \'TYPE\' => \'varchar(16)\'\n                                            },\n                                            \'userid\',\n                                            {\n                                              \'NOTNULL\' => 1,\n                                              \'REFERENCES\' => {\n                                                                \'COLUMN\' => \'userid\',\n                                                                \'DELETE\' => \'CASCADE\',\n                                                                \'TABLE\' => \'profiles\',\n                                                                \'created\' => 1\n                                                              },\n                                              \'TYPE\' => \'INT3\'\n                                            },\n                                            \'ipaddr\',\n                                            {\n                                              \'TYPE\' => \'varchar(40)\'\n                                            },\n                                            \'lastused\',\n                                            {\n                                              \'NOTNULL\' => 1,\n                                              \'TYPE\' => \'DATETIME\'\n                                            }\n                                          ],\n                              \'INDEXES\' => [\n                                             \'logincookies_lastused_idx\',\n                                             [\n                                               \'lastused\'\n                                             ]\n                                           ]\n                            },\n          \'longdescs\' => {\n                           \'FIELDS\' => [\n                                         \'comment_id\',\n                                         {\n                                           \'NOTNULL\' => 1,\n                                           \'PRIMARYKEY\' => 1,\n                                           \'TYPE\' => \'INTSERIAL\'\n                                         },\n                                         \'bug_id\',\n                                         {\n                                           \'NOTNULL\' => 1,\n                                           \'REFERENCES\' => {\n                                                             \'COLUMN\' => \'bug_id\',\n                                                             \'DELETE\' => \'CASCADE\',\n                                                             \'TABLE\' => \'bugs\',\n                                                             \'created\' => 1\n                                                           },\n                                           \'TYPE\' => \'INT3\'\n                                         },\n                                         \'who\',\n                                         {\n                                           \'NOTNULL\' => 1,\n                                           \'REFERENCES\' => {\n                                                             \'COLUMN\' => \'userid\',\n                                                             \'TABLE\' => \'profiles\',\n                                                             \'created\' => 1\n                                                           },\n                                           \'TYPE\' => \'INT3\'\n                                         },\n                                         \'bug_when\',\n                                         {\n                                           \'NOTNULL\' => 1,\n                                           \'TYPE\' => \'DATETIME\'\n                                         },\n                                         \'work_time\',\n                                         {\n                                           \'DEFAULT\' => \'0\',\n                                           \'NOTNULL\' => 1,\n                                           \'TYPE\' => \'decimal(7,2)\'\n                                         },\n                                         \'thetext\',\n                                         {\n                                           \'NOTNULL\' => 1,\n                                           \'TYPE\' => \'LONGTEXT\'\n                                         },\n                                         \'isprivate\',\n                                         {\n                                           \'DEFAULT\' => \'FALSE\',\n                                           \'NOTNULL\' => 1,\n                                           \'TYPE\' => \'BOOLEAN\'\n                                         },\n                                         \'already_wrapped\',\n                                         {\n                                           \'DEFAULT\' => \'FALSE\',\n                                           \'NOTNULL\' => 1,\n                                           \'TYPE\' => \'BOOLEAN\'\n                                         },\n                                         \'type\',\n                                         {\n                                           \'DEFAULT\' => \'0\',\n                                           \'NOTNULL\' => 1,\n                                           \'TYPE\' => \'INT2\'\n                                         },\n                                         \'extra_data\',\n                                         {\n                                           \'TYPE\' => \'varchar(255)\'\n                                         }\n                                       ],\n                           \'INDEXES\' => [\n                                          \'longdescs_bug_id_idx\',\n                                          [\n                                            \'bug_id\',\n                                            \'work_time\'\n                                          ],\n                                          \'longdescs_who_idx\',\n                                          [\n                                            \'who\',\n                                            \'bug_id\'\n                                          ],\n                                          \'longdescs_bug_when_idx\',\n                                          [\n                                            \'bug_when\'\n                                          ]\n                                        ]\n                         },\n          \'longdescs_tags\' => {\n                                \'FIELDS\' => [\n                                              \'id\',\n                                              {\n                                                \'NOTNULL\' => 1,\n                                                \'PRIMARYKEY\' => 1,\n                                                \'TYPE\' => \'MEDIUMSERIAL\'\n                                              },\n                                              \'comment_id\',\n                                              {\n                                                \'REFERENCES\' => {\n                                                                  \'COLUMN\' => \'comment_id\',\n                                                                  \'DELETE\' => \'CASCADE\',\n                                                                  \'TABLE\' => \'longdescs\',\n                                                                  \'created\' => 1\n                                                                },\n                                                \'TYPE\' => \'INT4\'\n                                              },\n                                              \'tag\',\n                                              {\n                                                \'NOTNULL\' => 1,\n                                                \'TYPE\' => \'varchar(24)\'\n                                              }\n                                            ],\n                                \'INDEXES\' => [\n                                               \'longdescs_tags_idx\',\n                                               {\n                                                 \'FIELDS\' => [\n                                                               \'comment_id\',\n                                                               \'tag\'\n                                                             ],\n                                                 \'TYPE\' => \'UNIQUE\'\n                                               }\n                                             ]\n                              },\n          \'longdescs_tags_activity\' => {\n                                         \'FIELDS\' => [\n                                                       \'id\',\n                                                       {\n                                                         \'NOTNULL\' => 1,\n                                                         \'PRIMARYKEY\' => 1,\n                                                         \'TYPE\' => \'MEDIUMSERIAL\'\n                                                       },\n                                                       \'bug_id\',\n                                                       {\n                                                         \'NOTNULL\' => 1,\n                                                         \'REFERENCES\' => {\n                                                                           \'COLUMN\' => \'bug_id\',\n                                                                           \'DELETE\' => \'CASCADE\',\n                                                                           \'TABLE\' => \'bugs\',\n                                                                           \'created\' => 1\n                                                                         },\n                                                         \'TYPE\' => \'INT3\'\n                                                       },\n                                                       \'comment_id\',\n                                                       {\n                                                         \'REFERENCES\' => {\n                                                                           \'COLUMN\' => \'comment_id\',\n                                                                           \'DELETE\' => \'CASCADE\',\n                                                                           \'TABLE\' => \'longdescs\',\n                                                                           \'created\' => 1\n                                                                         },\n                                                         \'TYPE\' => \'INT4\'\n                                                       },\n                                                       \'who\',\n                                                       {\n                                                         \'NOTNULL\' => 1,\n                                                         \'REFERENCES\' => {\n                                                                           \'COLUMN\' => \'userid\',\n                                                                           \'TABLE\' => \'profiles\',\n                                                                           \'created\' => 1\n                                                                         },\n                                                         \'TYPE\' => \'INT3\'\n                                                       },\n                                                       \'bug_when\',\n                                                       {\n                                                         \'NOTNULL\' => 1,\n                                                         \'TYPE\' => \'DATETIME\'\n                                                       },\n                                                       \'added\',\n                                                       {\n                                                         \'TYPE\' => \'varchar(24)\'\n                                                       },\n                                                       \'removed\',\n                                                       {\n                                                         \'TYPE\' => \'varchar(24)\'\n                                                       }\n                                                     ],\n                                         \'INDEXES\' => [\n                                                        \'longdescs_tags_activity_bug_id_idx\',\n                                                        [\n                                                          \'bug_id\'\n                                                        ]\n                                                      ]\n                                       },\n          \'longdescs_tags_weights\' => {\n                                        \'FIELDS\' => [\n                                                      \'id\',\n                                                      {\n                                                        \'NOTNULL\' => 1,\n                                                        \'PRIMARYKEY\' => 1,\n                                                        \'TYPE\' => \'MEDIUMSERIAL\'\n                                                      },\n                                                      \'tag\',\n                                                      {\n                                                        \'NOTNULL\' => 1,\n                                                        \'TYPE\' => \'varchar(24)\'\n                                                      },\n                                                      \'weight\',\n                                                      {\n                                                        \'NOTNULL\' => 1,\n                                                        \'TYPE\' => \'INT3\'\n                                                      }\n                                                    ],\n                                        \'INDEXES\' => [\n                                                       \'longdescs_tags_weights_tag_idx\',\n                                                       {\n                                                         \'FIELDS\' => [\n                                                                       \'tag\'\n                                                                     ],\n                                                         \'TYPE\' => \'UNIQUE\'\n                                                       }\n                                                     ]\n                                      },\n          \'mail_staging\' => {\n                              \'FIELDS\' => [\n                                            \'id\',\n                                            {\n                                              \'NOTNULL\' => 1,\n                                              \'PRIMARYKEY\' => 1,\n                                              \'TYPE\' => \'INTSERIAL\'\n                                            },\n                                            \'message\',\n                                            {\n                                              \'NOTNULL\' => 1,\n                                              \'TYPE\' => \'LONGBLOB\'\n                                            }\n                                          ]\n                            },\n          \'milestones\' => {\n                            \'FIELDS\' => [\n                                          \'id\',\n                                          {\n                                            \'NOTNULL\' => 1,\n                                            \'PRIMARYKEY\' => 1,\n                                            \'TYPE\' => \'MEDIUMSERIAL\'\n                                          },\n                                          \'product_id\',\n                                          {\n                                            \'NOTNULL\' => 1,\n                                            \'REFERENCES\' => {\n                                                              \'COLUMN\' => \'id\',\n                                                              \'DELETE\' => \'CASCADE\',\n                                                              \'TABLE\' => \'products\',\n                                                              \'created\' => 1\n                                                            },\n                                            \'TYPE\' => \'INT2\'\n                                          },\n                                          \'value\',\n                                          {\n                                            \'NOTNULL\' => 1,\n                                            \'TYPE\' => \'varchar(64)\'\n                                          },\n                                          \'sortkey\',\n                                          {\n                                            \'DEFAULT\' => 0,\n                                            \'NOTNULL\' => 1,\n                                            \'TYPE\' => \'INT2\'\n                                          },\n                                          \'isactive\',\n                                          {\n                                            \'DEFAULT\' => \'TRUE\',\n                                            \'NOTNULL\' => 1,\n                                            \'TYPE\' => \'BOOLEAN\'\n                                          }\n                                        ],\n                            \'INDEXES\' => [\n                                           \'milestones_product_id_idx\',\n                                           {\n                                             \'FIELDS\' => [\n                                                           \'product_id\',\n                                                           \'value\'\n                                                         ],\n                                             \'TYPE\' => \'UNIQUE\'\n                                           }\n                                         ]\n                          },\n          \'namedqueries\' => {\n                              \'FIELDS\' => [\n                                            \'id\',\n                                            {\n                                              \'NOTNULL\' => 1,\n                                              \'PRIMARYKEY\' => 1,\n                                              \'TYPE\' => \'MEDIUMSERIAL\'\n                                            },\n                                            \'userid\',\n                                            {\n                                              \'NOTNULL\' => 1,\n                                              \'REFERENCES\' => {\n                                                                \'COLUMN\' => \'userid\',\n                                                                \'DELETE\' => \'CASCADE\',\n                                                                \'TABLE\' => \'profiles\',\n                                                                \'created\' => 1\n                                                              },\n                                              \'TYPE\' => \'INT3\'\n                                            },\n                                            \'name\',\n                                            {\n                                              \'NOTNULL\' => 1,\n                                              \'TYPE\' => \'varchar(64)\'\n                                            },\n                                            \'query\',\n                                            {\n                                              \'NOTNULL\' => 1,\n                                              \'TYPE\' => \'LONGTEXT\'\n                                            }\n                                          ],\n                              \'INDEXES\' => [\n                                             \'namedqueries_userid_idx\',\n                                             {\n                                               \'FIELDS\' => [\n                                                             \'userid\',\n                                                             \'name\'\n                                                           ],\n                                               \'TYPE\' => \'UNIQUE\'\n                                             }\n                                           ]\n                            },\n          \'namedqueries_link_in_footer\' => {\n                                             \'FIELDS\' => [\n                                                           \'namedquery_id\',\n                                                           {\n                                                             \'NOTNULL\' => 1,\n                                                             \'REFERENCES\' => {\n                                                                               \'COLUMN\' => \'id\',\n                                                                               \'DELETE\' => \'CASCADE\',\n                                                                               \'TABLE\' => \'namedqueries\',\n                                                                               \'created\' => 1\n                                                                             },\n                                                             \'TYPE\' => \'INT3\'\n                                                           },\n                                                           \'user_id\',\n                                                           {\n                                                             \'NOTNULL\' => 1,\n                                                             \'REFERENCES\' => {\n                                                                               \'COLUMN\' => \'userid\',\n                                                                               \'DELETE\' => \'CASCADE\',\n                                                                               \'TABLE\' => \'profiles\',\n                                                                               \'created\' => 1\n                                                                             },\n                                                             \'TYPE\' => \'INT3\'\n                                                           }\n                                                         ],\n                                             \'INDEXES\' => [\n                                                            \'namedqueries_link_in_footer_id_idx\',\n                                                            {\n                                                              \'FIELDS\' => [\n                                                                            \'namedquery_id\',\n                                                                            \'user_id\'\n                                                                          ],\n                                                              \'TYPE\' => \'UNIQUE\'\n                                                            },\n                                                            \'namedqueries_link_in_footer_userid_idx\',\n                                                            [\n                                                              \'user_id\'\n                                                            ]\n                                                          ]\n                                           },\n          \'namedquery_group_map\' => {\n                                      \'FIELDS\' => [\n                                                    \'namedquery_id\',\n                                                    {\n                                                      \'NOTNULL\' => 1,\n                                                      \'REFERENCES\' => {\n                                                                        \'COLUMN\' => \'id\',\n                                                                        \'DELETE\' => \'CASCADE\',\n                                                                        \'TABLE\' => \'namedqueries\',\n                                                                        \'created\' => 1\n                                                                      },\n                                                      \'TYPE\' => \'INT3\'\n                                                    },\n                                                    \'group_id\',\n                                                    {\n                                                      \'NOTNULL\' => 1,\n                                                      \'REFERENCES\' => {\n                                                                        \'COLUMN\' => \'id\',\n                                                                        \'DELETE\' => \'CASCADE\',\n                                                                        \'TABLE\' => \'groups\',\n                                                                        \'created\' => 1\n                                                                      },\n                                                      \'TYPE\' => \'INT3\'\n                                                    }\n                                                  ],\n                                      \'INDEXES\' => [\n                                                     \'namedquery_group_map_namedquery_id_idx\',\n                                                     {\n                                                       \'FIELDS\' => [\n                                                                     \'namedquery_id\'\n                                                                   ],\n                                                       \'TYPE\' => \'UNIQUE\'\n                                                     },\n                                                     \'namedquery_group_map_group_id_idx\',\n                                                     [\n                                                       \'group_id\'\n                                                     ]\n                                                   ]\n                                    },\n          \'op_sys\' => {\n                        \'FIELDS\' => [\n                                      \'id\',\n                                      {\n                                        \'NOTNULL\' => 1,\n                                        \'PRIMARYKEY\' => 1,\n                                        \'TYPE\' => \'SMALLSERIAL\'\n                                      },\n                                      \'value\',\n                                      {\n                                        \'NOTNULL\' => 1,\n                                        \'TYPE\' => \'varchar(64)\'\n                                      },\n                                      \'sortkey\',\n                                      {\n                                        \'DEFAULT\' => 0,\n                                        \'NOTNULL\' => 1,\n                                        \'TYPE\' => \'INT2\'\n                                      },\n                                      \'isactive\',\n                                      {\n                                        \'DEFAULT\' => \'TRUE\',\n                                        \'NOTNULL\' => 1,\n                                        \'TYPE\' => \'BOOLEAN\'\n                                      },\n                                      \'visibility_value_id\',\n                                      {\n                                        \'TYPE\' => \'INT2\'\n                                      }\n                                    ],\n                        \'INDEXES\' => [\n                                       \'op_sys_value_idx\',\n                                       {\n                                         \'FIELDS\' => [\n                                                       \'value\'\n                                                     ],\n                                         \'TYPE\' => \'UNIQUE\'\n                                       },\n                                       \'op_sys_sortkey_idx\',\n                                       [\n                                         \'sortkey\',\n                                         \'value\'\n                                       ],\n                                       \'op_sys_visibility_value_id_idx\',\n                                       [\n                                         \'visibility_value_id\'\n                                       ]\n                                     ]\n                      },\n          \'priority\' => {\n                          \'FIELDS\' => [\n                                        \'id\',\n                                        {\n                                          \'NOTNULL\' => 1,\n                                          \'PRIMARYKEY\' => 1,\n                                          \'TYPE\' => \'SMALLSERIAL\'\n                                        },\n                                        \'value\',\n                                        {\n                                          \'NOTNULL\' => 1,\n                                          \'TYPE\' => \'varchar(64)\'\n                                        },\n                                        \'sortkey\',\n                                        {\n                                          \'DEFAULT\' => 0,\n                                          \'NOTNULL\' => 1,\n                                          \'TYPE\' => \'INT2\'\n                                        },\n                                        \'isactive\',\n                                        {\n                                          \'DEFAULT\' => \'TRUE\',\n                                          \'NOTNULL\' => 1,\n                                          \'TYPE\' => \'BOOLEAN\'\n                                        },\n                                        \'visibility_value_id\',\n                                        {\n                                          \'TYPE\' => \'INT2\'\n                                        }\n                                      ],\n                          \'INDEXES\' => [\n                                         \'priority_value_idx\',\n                                         {\n                                           \'FIELDS\' => [\n                                                         \'value\'\n                                                       ],\n                                           \'TYPE\' => \'UNIQUE\'\n                                         },\n                                         \'priority_sortkey_idx\',\n                                         [\n                                           \'sortkey\',\n                                           \'value\'\n                                         ],\n                                         \'priority_visibility_value_id_idx\',\n                                         [\n                                           \'visibility_value_id\'\n                                         ]\n                                       ]\n                        },\n          \'products\' => {\n                          \'FIELDS\' => [\n                                        \'id\',\n                                        {\n                                          \'NOTNULL\' => 1,\n                                          \'PRIMARYKEY\' => 1,\n                                          \'TYPE\' => \'SMALLSERIAL\'\n                                        },\n                                        \'name\',\n                                        {\n                                          \'NOTNULL\' => 1,\n                                          \'TYPE\' => \'varchar(64)\'\n                                        },\n                                        \'classification_id\',\n                                        {\n                                          \'DEFAULT\' => \'1\',\n                                          \'NOTNULL\' => 1,\n                                          \'REFERENCES\' => {\n                                                            \'COLUMN\' => \'id\',\n                                                            \'DELETE\' => \'CASCADE\',\n                                                            \'TABLE\' => \'classifications\',\n                                                            \'created\' => 1\n                                                          },\n                                          \'TYPE\' => \'INT2\'\n                                        },\n                                        \'description\',\n                                        {\n                                          \'NOTNULL\' => 1,\n                                          \'TYPE\' => \'MEDIUMTEXT\'\n                                        },\n                                        \'isactive\',\n                                        {\n                                          \'DEFAULT\' => 1,\n                                          \'NOTNULL\' => 1,\n                                          \'TYPE\' => \'BOOLEAN\'\n                                        },\n                                        \'defaultmilestone\',\n                                        {\n                                          \'DEFAULT\' => \'\\\'---\\\'\',\n                                          \'NOTNULL\' => 1,\n                                          \'TYPE\' => \'varchar(64)\'\n                                        },\n                                        \'allows_unconfirmed\',\n                                        {\n                                          \'DEFAULT\' => \'TRUE\',\n                                          \'NOTNULL\' => 1,\n                                          \'TYPE\' => \'BOOLEAN\'\n                                        }\n                                      ],\n                          \'INDEXES\' => [\n                                         \'products_name_idx\',\n                                         {\n                                           \'FIELDS\' => [\n                                                         \'name\'\n                                                       ],\n                                           \'TYPE\' => \'UNIQUE\'\n                                         }\n                                       ]\n                        },\n          \'profile_search\' => {\n                                \'FIELDS\' => [\n                                              \'id\',\n                                              {\n                                                \'NOTNULL\' => 1,\n                                                \'PRIMARYKEY\' => 1,\n                                                \'TYPE\' => \'INTSERIAL\'\n                                              },\n                                              \'user_id\',\n                                              {\n                                                \'NOTNULL\' => 1,\n                                                \'REFERENCES\' => {\n                                                                  \'COLUMN\' => \'userid\',\n                                                                  \'DELETE\' => \'CASCADE\',\n                                                                  \'TABLE\' => \'profiles\',\n                                                                  \'created\' => 1\n                                                                },\n                                                \'TYPE\' => \'INT3\'\n                                              },\n                                              \'bug_list\',\n                                              {\n                                                \'NOTNULL\' => 1,\n                                                \'TYPE\' => \'MEDIUMTEXT\'\n                                              },\n                                              \'list_order\',\n                                              {\n                                                \'TYPE\' => \'MEDIUMTEXT\'\n                                              }\n                                            ],\n                                \'INDEXES\' => [\n                                               \'profile_search_user_id_idx\',\n                                               [\n                                                 \'user_id\'\n                                               ]\n                                             ]\n                              },\n          \'profile_setting\' => {\n                                 \'FIELDS\' => [\n                                               \'user_id\',\n                                               {\n                                                 \'NOTNULL\' => 1,\n                                                 \'REFERENCES\' => {\n                                                                   \'COLUMN\' => \'userid\',\n                                                                   \'DELETE\' => \'CASCADE\',\n                                                                   \'TABLE\' => \'profiles\',\n                                                                   \'created\' => 1\n                                                                 },\n                                                 \'TYPE\' => \'INT3\'\n                                               },\n                                               \'setting_name\',\n                                               {\n                                                 \'NOTNULL\' => 1,\n                                                 \'REFERENCES\' => {\n                                                                   \'COLUMN\' => \'name\',\n                                                                   \'DELETE\' => \'CASCADE\',\n                                                                   \'TABLE\' => \'setting\',\n                                                                   \'created\' => 1\n                                                                 },\n                                                 \'TYPE\' => \'varchar(32)\'\n                                               },\n                                               \'setting_value\',\n                                               {\n                                                 \'NOTNULL\' => 1,\n                                                 \'TYPE\' => \'varchar(32)\'\n                                               }\n                                             ],\n                                 \'INDEXES\' => [\n                                                \'profile_setting_value_unique_idx\',\n                                                {\n                                                  \'FIELDS\' => [\n                                                                \'user_id\',\n                                                                \'setting_name\'\n                                                              ],\n                                                  \'TYPE\' => \'UNIQUE\'\n                                                }\n                                              ]\n                               },\n          \'profiles\' => {\n                          \'FIELDS\' => [\n                                        \'userid\',\n                                        {\n                                          \'NOTNULL\' => 1,\n                                          \'PRIMARYKEY\' => 1,\n                                          \'TYPE\' => \'MEDIUMSERIAL\'\n                                        },\n                                        \'login_name\',\n                                        {\n                                          \'NOTNULL\' => 1,\n                                          \'TYPE\' => \'varchar(255)\'\n                                        },\n                                        \'cryptpassword\',\n                                        {\n                                          \'TYPE\' => \'varchar(128)\'\n                                        },\n                                        \'realname\',\n                                        {\n                                          \'DEFAULT\' => \'\\\'\\\'\',\n                                          \'NOTNULL\' => 1,\n                                          \'TYPE\' => \'varchar(255)\'\n                                        },\n                                        \'disabledtext\',\n                                        {\n                                          \'DEFAULT\' => \'\\\'\\\'\',\n                                          \'NOTNULL\' => 1,\n                                          \'TYPE\' => \'MEDIUMTEXT\'\n                                        },\n                                        \'disable_mail\',\n                                        {\n                                          \'DEFAULT\' => \'FALSE\',\n                                          \'NOTNULL\' => 1,\n                                          \'TYPE\' => \'BOOLEAN\'\n                                        },\n                                        \'mybugslink\',\n                                        {\n                                          \'DEFAULT\' => \'TRUE\',\n                                          \'NOTNULL\' => 1,\n                                          \'TYPE\' => \'BOOLEAN\'\n                                        },\n                                        \'extern_id\',\n                                        {\n                                          \'TYPE\' => \'varchar(64)\'\n                                        },\n                                        \'is_enabled\',\n                                        {\n                                          \'DEFAULT\' => \'TRUE\',\n                                          \'NOTNULL\' => 1,\n                                          \'TYPE\' => \'BOOLEAN\'\n                                        },\n                                        \'last_seen_date\',\n                                        {\n                                          \'TYPE\' => \'DATETIME\'\n                                        }\n                                      ],\n                          \'INDEXES\' => [\n                                         \'profiles_login_name_idx\',\n                                         {\n                                           \'FIELDS\' => [\n                                                         \'login_name\'\n                                                       ],\n                                           \'TYPE\' => \'UNIQUE\'\n                                         },\n                                         \'profiles_extern_id_idx\',\n                                         {\n                                           \'FIELDS\' => [\n                                                         \'extern_id\'\n                                                       ],\n                                           \'TYPE\' => \'UNIQUE\'\n                                         }\n                                       ]\n                        },\n          \'profiles_activity\' => {\n                                   \'FIELDS\' => [\n                                                 \'id\',\n                                                 {\n                                                   \'NOTNULL\' => 1,\n                                                   \'PRIMARYKEY\' => 1,\n                                                   \'TYPE\' => \'MEDIUMSERIAL\'\n                                                 },\n                                                 \'userid\',\n                                                 {\n                                                   \'NOTNULL\' => 1,\n                                                   \'REFERENCES\' => {\n                                                                     \'COLUMN\' => \'userid\',\n                                                                     \'DELETE\' => \'CASCADE\',\n                                                                     \'TABLE\' => \'profiles\',\n                                                                     \'created\' => 1\n                                                                   },\n                                                   \'TYPE\' => \'INT3\'\n                                                 },\n                                                 \'who\',\n                                                 {\n                                                   \'NOTNULL\' => 1,\n                                                   \'REFERENCES\' => {\n                                                                     \'COLUMN\' => \'userid\',\n                                                                     \'TABLE\' => \'profiles\',\n                                                                     \'created\' => 1\n                                                                   },\n                                                   \'TYPE\' => \'INT3\'\n                                                 },\n                                                 \'profiles_when\',\n                                                 {\n                                                   \'NOTNULL\' => 1,\n                                                   \'TYPE\' => \'DATETIME\'\n                                                 },\n                                                 \'fieldid\',\n                                                 {\n                                                   \'NOTNULL\' => 1,\n                                                   \'REFERENCES\' => {\n                                                                     \'COLUMN\' => \'id\',\n                                                                     \'TABLE\' => \'fielddefs\',\n                                                                     \'created\' => 1\n                                                                   },\n                                                   \'TYPE\' => \'INT3\'\n                                                 },\n                                                 \'oldvalue\',\n                                                 {\n                                                   \'TYPE\' => \'TINYTEXT\'\n                                                 },\n                                                 \'newvalue\',\n                                                 {\n                                                   \'TYPE\' => \'TINYTEXT\'\n                                                 }\n                                               ],\n                                   \'INDEXES\' => [\n                                                  \'profiles_activity_userid_idx\',\n                                                  [\n                                                    \'userid\'\n                                                  ],\n                                                  \'profiles_activity_profiles_when_idx\',\n                                                  [\n                                                    \'profiles_when\'\n                                                  ],\n                                                  \'profiles_activity_fieldid_idx\',\n                                                  [\n                                                    \'fieldid\'\n                                                  ]\n                                                ]\n                                 },\n          \'quips\' => {\n                       \'FIELDS\' => [\n                                     \'quipid\',\n                                     {\n                                       \'NOTNULL\' => 1,\n                                       \'PRIMARYKEY\' => 1,\n                                       \'TYPE\' => \'MEDIUMSERIAL\'\n                                     },\n                                     \'userid\',\n                                     {\n                                       \'REFERENCES\' => {\n                                                         \'COLUMN\' => \'userid\',\n                                                         \'DELETE\' => \'SET NULL\',\n                                                         \'TABLE\' => \'profiles\',\n                                                         \'created\' => 1\n                                                       },\n                                       \'TYPE\' => \'INT3\'\n                                     },\n                                     \'quip\',\n                                     {\n                                       \'NOTNULL\' => 1,\n                                       \'TYPE\' => \'varchar(512)\'\n                                     },\n                                     \'approved\',\n                                     {\n                                       \'DEFAULT\' => \'TRUE\',\n                                       \'NOTNULL\' => 1,\n                                       \'TYPE\' => \'BOOLEAN\'\n                                     }\n                                   ]\n                     },\n          \'rep_platform\' => {\n                              \'FIELDS\' => [\n                                            \'id\',\n                                            {\n                                              \'NOTNULL\' => 1,\n                                              \'PRIMARYKEY\' => 1,\n                                              \'TYPE\' => \'SMALLSERIAL\'\n                                            },\n                                            \'value\',\n                                            {\n                                              \'NOTNULL\' => 1,\n                                              \'TYPE\' => \'varchar(64)\'\n                                            },\n                                            \'sortkey\',\n                                            {\n                                              \'DEFAULT\' => 0,\n                                              \'NOTNULL\' => 1,\n                                              \'TYPE\' => \'INT2\'\n                                            },\n                                            \'isactive\',\n                                            {\n                                              \'DEFAULT\' => \'TRUE\',\n                                              \'NOTNULL\' => 1,\n                                              \'TYPE\' => \'BOOLEAN\'\n                                            },\n                                            \'visibility_value_id\',\n                                            {\n                                              \'TYPE\' => \'INT2\'\n                                            }\n                                          ],\n                              \'INDEXES\' => [\n                                             \'rep_platform_value_idx\',\n                                             {\n                                               \'FIELDS\' => [\n                                                             \'value\'\n                                                           ],\n                                               \'TYPE\' => \'UNIQUE\'\n                                             },\n                                             \'rep_platform_sortkey_idx\',\n                                             [\n                                               \'sortkey\',\n                                               \'value\'\n                                             ],\n                                             \'rep_platform_visibility_value_id_idx\',\n                                             [\n                                               \'visibility_value_id\'\n                                             ]\n                                           ]\n                            },\n          \'reports\' => {\n                         \'FIELDS\' => [\n                                       \'id\',\n                                       {\n                                         \'NOTNULL\' => 1,\n                                         \'PRIMARYKEY\' => 1,\n                                         \'TYPE\' => \'MEDIUMSERIAL\'\n                                       },\n                                       \'user_id\',\n                                       {\n                                         \'NOTNULL\' => 1,\n                                         \'REFERENCES\' => {\n                                                           \'COLUMN\' => \'userid\',\n                                                           \'DELETE\' => \'CASCADE\',\n                                                           \'TABLE\' => \'profiles\',\n                                                           \'created\' => 1\n                                                         },\n                                         \'TYPE\' => \'INT3\'\n                                       },\n                                       \'name\',\n                                       {\n                                         \'NOTNULL\' => 1,\n                                         \'TYPE\' => \'varchar(64)\'\n                                       },\n                                       \'query\',\n                                       {\n                                         \'NOTNULL\' => 1,\n                                         \'TYPE\' => \'LONGTEXT\'\n                                       }\n                                     ],\n                         \'INDEXES\' => [\n                                        \'reports_user_id_idx\',\n                                        {\n                                          \'FIELDS\' => [\n                                                        \'user_id\',\n                                                        \'name\'\n                                                      ],\n                                          \'TYPE\' => \'UNIQUE\'\n                                        }\n                                      ]\n                       },\n          \'resolution\' => {\n                            \'FIELDS\' => [\n                                          \'id\',\n                                          {\n                                            \'NOTNULL\' => 1,\n                                            \'PRIMARYKEY\' => 1,\n                                            \'TYPE\' => \'SMALLSERIAL\'\n                                          },\n                                          \'value\',\n                                          {\n                                            \'NOTNULL\' => 1,\n                                            \'TYPE\' => \'varchar(64)\'\n                                          },\n                                          \'sortkey\',\n                                          {\n                                            \'DEFAULT\' => 0,\n                                            \'NOTNULL\' => 1,\n                                            \'TYPE\' => \'INT2\'\n                                          },\n                                          \'isactive\',\n                                          {\n                                            \'DEFAULT\' => \'TRUE\',\n                                            \'NOTNULL\' => 1,\n                                            \'TYPE\' => \'BOOLEAN\'\n                                          },\n                                          \'visibility_value_id\',\n                                          {\n                                            \'TYPE\' => \'INT2\'\n                                          }\n                                        ],\n                            \'INDEXES\' => [\n                                           \'resolution_value_idx\',\n                                           {\n                                             \'FIELDS\' => [\n                                                           \'value\'\n                                                         ],\n                                             \'TYPE\' => \'UNIQUE\'\n                                           },\n                                           \'resolution_sortkey_idx\',\n                                           [\n                                             \'sortkey\',\n                                             \'value\'\n                                           ],\n                                           \'resolution_visibility_value_id_idx\',\n                                           [\n                                             \'visibility_value_id\'\n                                           ]\n                                         ]\n                          },\n          \'series\' => {\n                        \'FIELDS\' => [\n                                      \'series_id\',\n                                      {\n                                        \'NOTNULL\' => 1,\n                                        \'PRIMARYKEY\' => 1,\n                                        \'TYPE\' => \'MEDIUMSERIAL\'\n                                      },\n                                      \'creator\',\n                                      {\n                                        \'REFERENCES\' => {\n                                                          \'COLUMN\' => \'userid\',\n                                                          \'DELETE\' => \'CASCADE\',\n                                                          \'TABLE\' => \'profiles\',\n                                                          \'created\' => 1\n                                                        },\n                                        \'TYPE\' => \'INT3\'\n                                      },\n                                      \'category\',\n                                      {\n                                        \'NOTNULL\' => 1,\n                                        \'REFERENCES\' => {\n                                                          \'COLUMN\' => \'id\',\n                                                          \'DELETE\' => \'CASCADE\',\n                                                          \'TABLE\' => \'series_categories\',\n                                                          \'created\' => 1\n                                                        },\n                                        \'TYPE\' => \'INT2\'\n                                      },\n                                      \'subcategory\',\n                                      {\n                                        \'NOTNULL\' => 1,\n                                        \'REFERENCES\' => {\n                                                          \'COLUMN\' => \'id\',\n                                                          \'DELETE\' => \'CASCADE\',\n                                                          \'TABLE\' => \'series_categories\',\n                                                          \'created\' => 1\n                                                        },\n                                        \'TYPE\' => \'INT2\'\n                                      },\n                                      \'name\',\n                                      {\n                                        \'NOTNULL\' => 1,\n                                        \'TYPE\' => \'varchar(64)\'\n                                      },\n                                      \'frequency\',\n                                      {\n                                        \'NOTNULL\' => 1,\n                                        \'TYPE\' => \'INT2\'\n                                      },\n                                      \'query\',\n                                      {\n                                        \'NOTNULL\' => 1,\n                                        \'TYPE\' => \'MEDIUMTEXT\'\n                                      },\n                                      \'is_public\',\n                                      {\n                                        \'DEFAULT\' => \'FALSE\',\n                                        \'NOTNULL\' => 1,\n                                        \'TYPE\' => \'BOOLEAN\'\n                                      }\n                                    ],\n                        \'INDEXES\' => [\n                                       \'series_creator_idx\',\n                                       [\n                                         \'creator\'\n                                       ],\n                                       \'series_category_idx\',\n                                       {\n                                         \'FIELDS\' => [\n                                                       \'category\',\n                                                       \'subcategory\',\n                                                       \'name\'\n                                                     ],\n                                         \'TYPE\' => \'UNIQUE\'\n                                       }\n                                     ]\n                      },\n          \'series_categories\' => {\n                                   \'FIELDS\' => [\n                                                 \'id\',\n                                                 {\n                                                   \'NOTNULL\' => 1,\n                                                   \'PRIMARYKEY\' => 1,\n                                                   \'TYPE\' => \'SMALLSERIAL\'\n                                                 },\n                                                 \'name\',\n                                                 {\n                                                   \'NOTNULL\' => 1,\n                                                   \'TYPE\' => \'varchar(64)\'\n                                                 }\n                                               ],\n                                   \'INDEXES\' => [\n                                                  \'series_categories_name_idx\',\n                                                  {\n                                                    \'FIELDS\' => [\n                                                                  \'name\'\n                                                                ],\n                                                    \'TYPE\' => \'UNIQUE\'\n                                                  }\n                                                ]\n                                 },\n          \'series_data\' => {\n                             \'FIELDS\' => [\n                                           \'series_id\',\n                                           {\n                                             \'NOTNULL\' => 1,\n                                             \'REFERENCES\' => {\n                                                               \'COLUMN\' => \'series_id\',\n                                                               \'DELETE\' => \'CASCADE\',\n                                                               \'TABLE\' => \'series\',\n                                                               \'created\' => 1\n                                                             },\n                                             \'TYPE\' => \'INT3\'\n                                           },\n                                           \'series_date\',\n                                           {\n                                             \'NOTNULL\' => 1,\n                                             \'TYPE\' => \'DATETIME\'\n                                           },\n                                           \'series_value\',\n                                           {\n                                             \'NOTNULL\' => 1,\n                                             \'TYPE\' => \'INT3\'\n                                           }\n                                         ],\n                             \'INDEXES\' => [\n                                            \'series_data_series_id_idx\',\n                                            {\n                                              \'FIELDS\' => [\n                                                            \'series_id\',\n                                                            \'series_date\'\n                                                          ],\n                                              \'TYPE\' => \'UNIQUE\'\n                                            }\n                                          ]\n                           },\n          \'setting\' => {\n                         \'FIELDS\' => [\n                                       \'name\',\n                                       {\n                                         \'NOTNULL\' => 1,\n                                         \'PRIMARYKEY\' => 1,\n                                         \'TYPE\' => \'varchar(32)\'\n                                       },\n                                       \'default_value\',\n                                       {\n                                         \'NOTNULL\' => 1,\n                                         \'TYPE\' => \'varchar(32)\'\n                                       },\n                                       \'is_enabled\',\n                                       {\n                                         \'DEFAULT\' => \'TRUE\',\n                                         \'NOTNULL\' => 1,\n                                         \'TYPE\' => \'BOOLEAN\'\n                                       },\n                                       \'subclass\',\n                                       {\n                                         \'TYPE\' => \'varchar(32)\'\n                                       }\n                                     ]\n                       },\n          \'setting_value\' => {\n                               \'FIELDS\' => [\n                                             \'name\',\n                                             {\n                                               \'NOTNULL\' => 1,\n                                               \'REFERENCES\' => {\n                                                                 \'COLUMN\' => \'name\',\n                                                                 \'DELETE\' => \'CASCADE\',\n                                                                 \'TABLE\' => \'setting\',\n                                                                 \'created\' => 1\n                                                               },\n                                               \'TYPE\' => \'varchar(32)\'\n                                             },\n                                             \'value\',\n                                             {\n                                               \'NOTNULL\' => 1,\n                                               \'TYPE\' => \'varchar(32)\'\n                                             },\n                                             \'sortindex\',\n                                             {\n                                               \'NOTNULL\' => 1,\n                                               \'TYPE\' => \'INT2\'\n                                             }\n                                           ],\n                               \'INDEXES\' => [\n                                              \'setting_value_nv_unique_idx\',\n                                              {\n                                                \'FIELDS\' => [\n                                                              \'name\',\n                                                              \'value\'\n                                                            ],\n                                                \'TYPE\' => \'UNIQUE\'\n                                              },\n                                              \'setting_value_ns_unique_idx\',\n                                              {\n                                                \'FIELDS\' => [\n                                                              \'name\',\n                                                              \'sortindex\'\n                                                            ],\n                                                \'TYPE\' => \'UNIQUE\'\n                                              }\n                                            ]\n                             },\n          \'status_workflow\' => {\n                                 \'FIELDS\' => [\n                                               \'old_status\',\n                                               {\n                                                 \'REFERENCES\' => {\n                                                                   \'COLUMN\' => \'id\',\n                                                                   \'DELETE\' => \'CASCADE\',\n                                                                   \'TABLE\' => \'bug_status\',\n                                                                   \'created\' => 1\n                                                                 },\n                                                 \'TYPE\' => \'INT2\'\n                                               },\n                                               \'new_status\',\n                                               {\n                                                 \'NOTNULL\' => 1,\n                                                 \'REFERENCES\' => {\n                                                                   \'COLUMN\' => \'id\',\n                                                                   \'DELETE\' => \'CASCADE\',\n                                                                   \'TABLE\' => \'bug_status\',\n                                                                   \'created\' => 1\n                                                                 },\n                                                 \'TYPE\' => \'INT2\'\n                                               },\n                                               \'require_comment\',\n                                               {\n                                                 \'DEFAULT\' => 0,\n                                                 \'NOTNULL\' => 1,\n                                                 \'TYPE\' => \'INT1\'\n                                               }\n                                             ],\n                                 \'INDEXES\' => [\n                                                \'status_workflow_idx\',\n                                                {\n                                                  \'FIELDS\' => [\n                                                                \'old_status\',\n                                                                \'new_status\'\n                                                              ],\n                                                  \'TYPE\' => \'UNIQUE\'\n                                                }\n                                              ]\n                               },\n          \'tag\' => {\n                     \'FIELDS\' => [\n                                   \'id\',\n                                   {\n                                     \'NOTNULL\' => 1,\n                                     \'PRIMARYKEY\' => 1,\n                                     \'TYPE\' => \'MEDIUMSERIAL\'\n                                   },\n                                   \'name\',\n                                   {\n                                     \'NOTNULL\' => 1,\n                                     \'TYPE\' => \'varchar(64)\'\n                                   },\n                                   \'user_id\',\n                                   {\n                                     \'NOTNULL\' => 1,\n                                     \'REFERENCES\' => {\n                                                       \'COLUMN\' => \'userid\',\n                                                       \'DELETE\' => \'CASCADE\',\n                                                       \'TABLE\' => \'profiles\',\n                                                       \'created\' => 1\n                                                     },\n                                     \'TYPE\' => \'INT3\'\n                                   }\n                                 ],\n                     \'INDEXES\' => [\n                                    \'tag_user_id_idx\',\n                                    {\n                                      \'FIELDS\' => [\n                                                    \'user_id\',\n                                                    \'name\'\n                                                  ],\n                                      \'TYPE\' => \'UNIQUE\'\n                                    }\n                                  ]\n                   },\n          \'tokens\' => {\n                        \'FIELDS\' => [\n                                      \'userid\',\n                                      {\n                                        \'REFERENCES\' => {\n                                                          \'COLUMN\' => \'userid\',\n                                                          \'DELETE\' => \'CASCADE\',\n                                                          \'TABLE\' => \'profiles\',\n                                                          \'created\' => 1\n                                                        },\n                                        \'TYPE\' => \'INT3\'\n                                      },\n                                      \'issuedate\',\n                                      {\n                                        \'NOTNULL\' => 1,\n                                        \'TYPE\' => \'DATETIME\'\n                                      },\n                                      \'token\',\n                                      {\n                                        \'NOTNULL\' => 1,\n                                        \'PRIMARYKEY\' => 1,\n                                        \'TYPE\' => \'varchar(16)\'\n                                      },\n                                      \'tokentype\',\n                                      {\n                                        \'NOTNULL\' => 1,\n                                        \'TYPE\' => \'varchar(16)\'\n                                      },\n                                      \'eventdata\',\n                                      {\n                                        \'TYPE\' => \'TINYTEXT\'\n                                      }\n                                    ],\n                        \'INDEXES\' => [\n                                       \'tokens_userid_idx\',\n                                       [\n                                         \'userid\'\n                                       ]\n                                     ]\n                      },\n          \'ts_error\' => {\n                          \'FIELDS\' => [\n                                        \'error_time\',\n                                        {\n                                          \'NOTNULL\' => 1,\n                                          \'TYPE\' => \'INT4\'\n                                        },\n                                        \'jobid\',\n                                        {\n                                          \'NOTNULL\' => 1,\n                                          \'TYPE\' => \'INT4\'\n                                        },\n                                        \'message\',\n                                        {\n                                          \'NOTNULL\' => 1,\n                                          \'TYPE\' => \'varchar(255)\'\n                                        },\n                                        \'funcid\',\n                                        {\n                                          \'DEFAULT\' => 0,\n                                          \'NOTNULL\' => 1,\n                                          \'TYPE\' => \'INT4\'\n                                        }\n                                      ],\n                          \'INDEXES\' => [\n                                         \'ts_error_funcid_idx\',\n                                         [\n                                           \'funcid\',\n                                           \'error_time\'\n                                         ],\n                                         \'ts_error_error_time_idx\',\n                                         [\n                                           \'error_time\'\n                                         ],\n                                         \'ts_error_jobid_idx\',\n                                         [\n                                           \'jobid\'\n                                         ]\n                                       ]\n                        },\n          \'ts_exitstatus\' => {\n                               \'FIELDS\' => [\n                                             \'jobid\',\n                                             {\n                                               \'NOTNULL\' => 1,\n                                               \'PRIMARYKEY\' => 1,\n                                               \'TYPE\' => \'INTSERIAL\'\n                                             },\n                                             \'funcid\',\n                                             {\n                                               \'DEFAULT\' => 0,\n                                               \'NOTNULL\' => 1,\n                                               \'TYPE\' => \'INT4\'\n                                             },\n                                             \'status\',\n                                             {\n                                               \'TYPE\' => \'INT2\'\n                                             },\n                                             \'completion_time\',\n                                             {\n                                               \'TYPE\' => \'INT4\'\n                                             },\n                                             \'delete_after\',\n                                             {\n                                               \'TYPE\' => \'INT4\'\n                                             }\n                                           ],\n                               \'INDEXES\' => [\n                                              \'ts_exitstatus_funcid_idx\',\n                                              [\n                                                \'funcid\'\n                                              ],\n                                              \'ts_exitstatus_delete_after_idx\',\n                                              [\n                                                \'delete_after\'\n                                              ]\n                                            ]\n                             },\n          \'ts_funcmap\' => {\n                            \'FIELDS\' => [\n                                          \'funcid\',\n                                          {\n                                            \'NOTNULL\' => 1,\n                                            \'PRIMARYKEY\' => 1,\n                                            \'TYPE\' => \'INTSERIAL\'\n                                          },\n                                          \'funcname\',\n                                          {\n                                            \'NOTNULL\' => 1,\n                                            \'TYPE\' => \'varchar(255)\'\n                                          }\n                                        ],\n                            \'INDEXES\' => [\n                                           \'ts_funcmap_funcname_idx\',\n                                           {\n                                             \'FIELDS\' => [\n                                                           \'funcname\'\n                                                         ],\n                                             \'TYPE\' => \'UNIQUE\'\n                                           }\n                                         ]\n                          },\n          \'ts_job\' => {\n                        \'FIELDS\' => [\n                                      \'jobid\',\n                                      {\n                                        \'NOTNULL\' => 1,\n                                        \'PRIMARYKEY\' => 1,\n                                        \'TYPE\' => \'INTSERIAL\'\n                                      },\n                                      \'funcid\',\n                                      {\n                                        \'NOTNULL\' => 1,\n                                        \'TYPE\' => \'INT4\'\n                                      },\n                                      \'arg\',\n                                      {\n                                        \'TYPE\' => \'LONGBLOB\'\n                                      },\n                                      \'uniqkey\',\n                                      {\n                                        \'TYPE\' => \'varchar(255)\'\n                                      },\n                                      \'insert_time\',\n                                      {\n                                        \'TYPE\' => \'INT4\'\n                                      },\n                                      \'run_after\',\n                                      {\n                                        \'NOTNULL\' => 1,\n                                        \'TYPE\' => \'INT4\'\n                                      },\n                                      \'grabbed_until\',\n                                      {\n                                        \'NOTNULL\' => 1,\n                                        \'TYPE\' => \'INT4\'\n                                      },\n                                      \'priority\',\n                                      {\n                                        \'TYPE\' => \'INT2\'\n                                      },\n                                      \'coalesce\',\n                                      {\n                                        \'TYPE\' => \'varchar(255)\'\n                                      }\n                                    ],\n                        \'INDEXES\' => [\n                                       \'ts_job_funcid_idx\',\n                                       {\n                                         \'FIELDS\' => [\n                                                       \'funcid\',\n                                                       \'uniqkey\'\n                                                     ],\n                                         \'TYPE\' => \'UNIQUE\'\n                                       },\n                                       \'ts_job_run_after_idx\',\n                                       [\n                                         \'run_after\',\n                                         \'funcid\'\n                                       ],\n                                       \'ts_job_coalesce_idx\',\n                                       [\n                                         \'coalesce\',\n                                         \'funcid\'\n                                       ]\n                                     ]\n                      },\n          \'ts_note\' => {\n                         \'FIELDS\' => [\n                                       \'jobid\',\n                                       {\n                                         \'NOTNULL\' => 1,\n                                         \'TYPE\' => \'INT4\'\n                                       },\n                                       \'notekey\',\n                                       {\n                                         \'TYPE\' => \'varchar(255)\'\n                                       },\n                                       \'value\',\n                                       {\n                                         \'TYPE\' => \'LONGBLOB\'\n                                       }\n                                     ],\n                         \'INDEXES\' => [\n                                        \'ts_note_jobid_idx\',\n                                        {\n                                          \'FIELDS\' => [\n                                                        \'jobid\',\n                                                        \'notekey\'\n                                                      ],\n                                          \'TYPE\' => \'UNIQUE\'\n                                        }\n                                      ]\n                       },\n          \'user_api_keys\' => {\n                               \'FIELDS\' => [\n                                             \'id\',\n                                             {\n                                               \'NOTNULL\' => 1,\n                                               \'PRIMARYKEY\' => 1,\n                                               \'TYPE\' => \'INTSERIAL\'\n                                             },\n                                             \'user_id\',\n                                             {\n                                               \'NOTNULL\' => 1,\n                                               \'REFERENCES\' => {\n                                                                 \'COLUMN\' => \'userid\',\n                                                                 \'DELETE\' => \'CASCADE\',\n                                                                 \'TABLE\' => \'profiles\',\n                                                                 \'created\' => 1\n                                                               },\n                                               \'TYPE\' => \'INT3\'\n                                             },\n                                             \'api_key\',\n                                             {\n                                               \'NOTNULL\' => 1,\n                                               \'TYPE\' => \'VARCHAR(40)\'\n                                             },\n                                             \'description\',\n                                             {\n                                               \'TYPE\' => \'VARCHAR(255)\'\n                                             },\n                                             \'revoked\',\n                                             {\n                                               \'DEFAULT\' => \'FALSE\',\n                                               \'NOTNULL\' => 1,\n                                               \'TYPE\' => \'BOOLEAN\'\n                                             },\n                                             \'last_used\',\n                                             {\n                                               \'TYPE\' => \'DATETIME\'\n                                             }\n                                           ],\n                               \'INDEXES\' => [\n                                              \'user_api_keys_api_key_idx\',\n                                              {\n                                                \'FIELDS\' => [\n                                                              \'api_key\'\n                                                            ],\n                                                \'TYPE\' => \'UNIQUE\'\n                                              },\n                                              \'user_api_keys_user_id_idx\',\n                                              [\n                                                \'user_id\'\n                                              ]\n                                            ]\n                             },\n          \'user_group_map\' => {\n                                \'FIELDS\' => [\n                                              \'user_id\',\n                                              {\n                                                \'NOTNULL\' => 1,\n                                                \'REFERENCES\' => {\n                                                                  \'COLUMN\' => \'userid\',\n                                                                  \'DELETE\' => \'CASCADE\',\n                                                                  \'TABLE\' => \'profiles\',\n                                                                  \'created\' => 1\n                                                                },\n                                                \'TYPE\' => \'INT3\'\n                                              },\n                                              \'group_id\',\n                                              {\n                                                \'NOTNULL\' => 1,\n                                                \'REFERENCES\' => {\n                                                                  \'COLUMN\' => \'id\',\n                                                                  \'DELETE\' => \'CASCADE\',\n                                                                  \'TABLE\' => \'groups\',\n                                                                  \'created\' => 1\n                                                                },\n                                                \'TYPE\' => \'INT3\'\n                                              },\n                                              \'isbless\',\n                                              {\n                                                \'DEFAULT\' => \'FALSE\',\n                                                \'NOTNULL\' => 1,\n                                                \'TYPE\' => \'BOOLEAN\'\n                                              },\n                                              \'grant_type\',\n                                              {\n                                                \'DEFAULT\' => 0,\n                                                \'NOTNULL\' => 1,\n                                                \'TYPE\' => \'INT1\'\n                                              }\n                                            ],\n                                \'INDEXES\' => [\n                                               \'user_group_map_user_id_idx\',\n                                               {\n                                                 \'FIELDS\' => [\n                                                               \'user_id\',\n                                                               \'group_id\',\n                                                               \'grant_type\',\n                                                               \'isbless\'\n                                                             ],\n                                                 \'TYPE\' => \'UNIQUE\'\n                                               }\n                                             ]\n                              },\n          \'versions\' => {\n                          \'FIELDS\' => [\n                                        \'id\',\n                                        {\n                                          \'NOTNULL\' => 1,\n                                          \'PRIMARYKEY\' => 1,\n                                          \'TYPE\' => \'MEDIUMSERIAL\'\n                                        },\n                                        \'value\',\n                                        {\n                                          \'NOTNULL\' => 1,\n                                          \'TYPE\' => \'varchar(64)\'\n                                        },\n                                        \'product_id\',\n                                        {\n                                          \'NOTNULL\' => 1,\n                                          \'REFERENCES\' => {\n                                                            \'COLUMN\' => \'id\',\n                                                            \'DELETE\' => \'CASCADE\',\n                                                            \'TABLE\' => \'products\',\n                                                            \'created\' => 1\n                                                          },\n                                          \'TYPE\' => \'INT2\'\n                                        },\n                                        \'isactive\',\n                                        {\n                                          \'DEFAULT\' => \'TRUE\',\n                                          \'NOTNULL\' => 1,\n                                          \'TYPE\' => \'BOOLEAN\'\n                                        }\n                                      ],\n                          \'INDEXES\' => [\n                                         \'versions_product_id_idx\',\n                                         {\n                                           \'FIELDS\' => [\n                                                         \'product_id\',\n                                                         \'value\'\n                                                       ],\n                                           \'TYPE\' => \'UNIQUE\'\n                                         }\n                                       ]\n                        },\n          \'watch\' => {\n                       \'FIELDS\' => [\n                                     \'watcher\',\n                                     {\n                                       \'NOTNULL\' => 1,\n                                       \'REFERENCES\' => {\n                                                         \'COLUMN\' => \'userid\',\n                                                         \'DELETE\' => \'CASCADE\',\n                                                         \'TABLE\' => \'profiles\',\n                                                         \'created\' => 1\n                                                       },\n                                       \'TYPE\' => \'INT3\'\n                                     },\n                                     \'watched\',\n                                     {\n                                       \'NOTNULL\' => 1,\n                                       \'REFERENCES\' => {\n                                                         \'COLUMN\' => \'userid\',\n                                                         \'DELETE\' => \'CASCADE\',\n                                                         \'TABLE\' => \'profiles\',\n                                                         \'created\' => 1\n                                                       },\n                                       \'TYPE\' => \'INT3\'\n                                     }\n                                   ],\n                       \'INDEXES\' => [\n                                      \'watch_watcher_idx\',\n                                      {\n                                        \'FIELDS\' => [\n                                                      \'watcher\',\n                                                      \'watched\'\n                                                    ],\n                                        \'TYPE\' => \'UNIQUE\'\n                                      },\n                                      \'watch_watched_idx\',\n                                      [\n                                        \'watched\'\n                                      ]\n                                    ]\n                     },\n          \'whine_events\' => {\n                              \'FIELDS\' => [\n                                            \'id\',\n                                            {\n                                              \'NOTNULL\' => 1,\n                                              \'PRIMARYKEY\' => 1,\n                                              \'TYPE\' => \'MEDIUMSERIAL\'\n                                            },\n                                            \'owner_userid\',\n                                            {\n                                              \'NOTNULL\' => 1,\n                                              \'REFERENCES\' => {\n                                                                \'COLUMN\' => \'userid\',\n                                                                \'DELETE\' => \'CASCADE\',\n                                                                \'TABLE\' => \'profiles\',\n                                                                \'created\' => 1\n                                                              },\n                                              \'TYPE\' => \'INT3\'\n                                            },\n                                            \'subject\',\n                                            {\n                                              \'TYPE\' => \'varchar(128)\'\n                                            },\n                                            \'body\',\n                                            {\n                                              \'TYPE\' => \'MEDIUMTEXT\'\n                                            },\n                                            \'mailifnobugs\',\n                                            {\n                                              \'DEFAULT\' => \'FALSE\',\n                                              \'NOTNULL\' => 1,\n                                              \'TYPE\' => \'BOOLEAN\'\n                                            }\n                                          ]\n                            },\n          \'whine_queries\' => {\n                               \'FIELDS\' => [\n                                             \'id\',\n                                             {\n                                               \'NOTNULL\' => 1,\n                                               \'PRIMARYKEY\' => 1,\n                                               \'TYPE\' => \'MEDIUMSERIAL\'\n                                             },\n                                             \'eventid\',\n                                             {\n                                               \'NOTNULL\' => 1,\n                                               \'REFERENCES\' => {\n                                                                 \'COLUMN\' => \'id\',\n                                                                 \'DELETE\' => \'CASCADE\',\n                                                                 \'TABLE\' => \'whine_events\',\n                                                                 \'created\' => 1\n                                                               },\n                                               \'TYPE\' => \'INT3\'\n                                             },\n                                             \'query_name\',\n                                             {\n                                               \'DEFAULT\' => \'\\\'\\\'\',\n                                               \'NOTNULL\' => 1,\n                                               \'TYPE\' => \'varchar(64)\'\n                                             },\n                                             \'sortkey\',\n                                             {\n                                               \'DEFAULT\' => \'0\',\n                                               \'NOTNULL\' => 1,\n                                               \'TYPE\' => \'INT2\'\n                                             },\n                                             \'onemailperbug\',\n                                             {\n                                               \'DEFAULT\' => \'FALSE\',\n                                               \'NOTNULL\' => 1,\n                                               \'TYPE\' => \'BOOLEAN\'\n                                             },\n                                             \'title\',\n                                             {\n                                               \'DEFAULT\' => \'\\\'\\\'\',\n                                               \'NOTNULL\' => 1,\n                                               \'TYPE\' => \'varchar(128)\'\n                                             }\n                                           ],\n                               \'INDEXES\' => [\n                                              \'whine_queries_eventid_idx\',\n                                              [\n                                                \'eventid\'\n                                              ]\n                                            ]\n                             },\n          \'whine_schedules\' => {\n                                 \'FIELDS\' => [\n                                               \'id\',\n                                               {\n                                                 \'NOTNULL\' => 1,\n                                                 \'PRIMARYKEY\' => 1,\n                                                 \'TYPE\' => \'MEDIUMSERIAL\'\n                                               },\n                                               \'eventid\',\n                                               {\n                                                 \'NOTNULL\' => 1,\n                                                 \'REFERENCES\' => {\n                                                                   \'COLUMN\' => \'id\',\n                                                                   \'DELETE\' => \'CASCADE\',\n                                                                   \'TABLE\' => \'whine_events\',\n                                                                   \'created\' => 1\n                                                                 },\n                                                 \'TYPE\' => \'INT3\'\n                                               },\n                                               \'run_day\',\n                                               {\n                                                 \'TYPE\' => \'varchar(32)\'\n                                               },\n                                               \'run_time\',\n                                               {\n                                                 \'TYPE\' => \'varchar(32)\'\n                                               },\n                                               \'run_next\',\n                                               {\n                                                 \'TYPE\' => \'DATETIME\'\n                                               },\n                                               \'mailto\',\n                                               {\n                                                 \'NOTNULL\' => 1,\n                                                 \'TYPE\' => \'INT3\'\n                                               },\n                                               \'mailto_type\',\n                                               {\n                                                 \'DEFAULT\' => \'0\',\n                                                 \'NOTNULL\' => 1,\n                                                 \'TYPE\' => \'INT2\'\n                                               }\n                                             ],\n                                 \'INDEXES\' => [\n                                                \'whine_schedules_run_next_idx\',\n                                                [\n                                                  \'run_next\'\n                                                ],\n                                                \'whine_schedules_eventid_idx\',\n                                                [\n                                                  \'eventid\'\n                                                ]\n                                              ]\n                               }\n        };\n',3.00);
467/*!40000 ALTER TABLE `bz_schema` ENABLE KEYS */;
468UNLOCK TABLES;
469
470--
471-- Table structure for table `category_group_map`
472--
473
474DROP TABLE IF EXISTS `category_group_map`;
475/*!40101 SET @saved_cs_client     = @@character_set_client */;
476/*!40101 SET character_set_client = utf8 */;
477CREATE TABLE `category_group_map` (
478  `category_id` smallint(6) NOT NULL,
479  `group_id` mediumint(9) NOT NULL,
480  UNIQUE KEY `category_group_map_category_id_idx` (`category_id`,`group_id`),
481  KEY `fk_category_group_map_group_id_groups_id` (`group_id`),
482  CONSTRAINT `fk_category_group_map_category_id_series_categories_id` FOREIGN KEY (`category_id`) REFERENCES `series_categories` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
483  CONSTRAINT `fk_category_group_map_group_id_groups_id` FOREIGN KEY (`group_id`) REFERENCES `groups` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
484) ENGINE=InnoDB DEFAULT CHARSET=utf8;
485/*!40101 SET character_set_client = @saved_cs_client */;
486
487--
488-- Dumping data for table `category_group_map`
489--
490
491LOCK TABLES `category_group_map` WRITE;
492/*!40000 ALTER TABLE `category_group_map` DISABLE KEYS */;
493/*!40000 ALTER TABLE `category_group_map` ENABLE KEYS */;
494UNLOCK TABLES;
495
496--
497-- Table structure for table `cc`
498--
499
500DROP TABLE IF EXISTS `cc`;
501/*!40101 SET @saved_cs_client     = @@character_set_client */;
502/*!40101 SET character_set_client = utf8 */;
503CREATE TABLE `cc` (
504  `bug_id` mediumint(9) NOT NULL,
505  `who` mediumint(9) NOT NULL,
506  UNIQUE KEY `cc_bug_id_idx` (`bug_id`,`who`),
507  KEY `cc_who_idx` (`who`),
508  CONSTRAINT `fk_cc_bug_id_bugs_bug_id` FOREIGN KEY (`bug_id`) REFERENCES `bugs` (`bug_id`) ON DELETE CASCADE ON UPDATE CASCADE,
509  CONSTRAINT `fk_cc_who_profiles_userid` FOREIGN KEY (`who`) REFERENCES `profiles` (`userid`) ON DELETE CASCADE ON UPDATE CASCADE
510) ENGINE=InnoDB DEFAULT CHARSET=utf8;
511/*!40101 SET character_set_client = @saved_cs_client */;
512
513--
514-- Dumping data for table `cc`
515--
516
517LOCK TABLES `cc` WRITE;
518/*!40000 ALTER TABLE `cc` DISABLE KEYS */;
519/*!40000 ALTER TABLE `cc` ENABLE KEYS */;
520UNLOCK TABLES;
521
522--
523-- Table structure for table `classifications`
524--
525
526DROP TABLE IF EXISTS `classifications`;
527/*!40101 SET @saved_cs_client     = @@character_set_client */;
528/*!40101 SET character_set_client = utf8 */;
529CREATE TABLE `classifications` (
530  `id` smallint(6) NOT NULL AUTO_INCREMENT,
531  `name` varchar(64) NOT NULL,
532  `description` mediumtext,
533  `sortkey` smallint(6) NOT NULL DEFAULT '0',
534  PRIMARY KEY (`id`),
535  UNIQUE KEY `classifications_name_idx` (`name`)
536) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
537/*!40101 SET character_set_client = @saved_cs_client */;
538
539--
540-- Dumping data for table `classifications`
541--
542
543LOCK TABLES `classifications` WRITE;
544/*!40000 ALTER TABLE `classifications` DISABLE KEYS */;
545INSERT INTO `classifications` VALUES (1,'Unclassified','Not assigned to any classification',0);
546/*!40000 ALTER TABLE `classifications` ENABLE KEYS */;
547UNLOCK TABLES;
548
549--
550-- Table structure for table `component_cc`
551--
552
553DROP TABLE IF EXISTS `component_cc`;
554/*!40101 SET @saved_cs_client     = @@character_set_client */;
555/*!40101 SET character_set_client = utf8 */;
556CREATE TABLE `component_cc` (
557  `user_id` mediumint(9) NOT NULL,
558  `component_id` mediumint(9) NOT NULL,
559  UNIQUE KEY `component_cc_user_id_idx` (`component_id`,`user_id`),
560  KEY `fk_component_cc_user_id_profiles_userid` (`user_id`),
561  CONSTRAINT `fk_component_cc_component_id_components_id` FOREIGN KEY (`component_id`) REFERENCES `components` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
562  CONSTRAINT `fk_component_cc_user_id_profiles_userid` FOREIGN KEY (`user_id`) REFERENCES `profiles` (`userid`) ON DELETE CASCADE ON UPDATE CASCADE
563) ENGINE=InnoDB DEFAULT CHARSET=utf8;
564/*!40101 SET character_set_client = @saved_cs_client */;
565
566--
567-- Dumping data for table `component_cc`
568--
569
570LOCK TABLES `component_cc` WRITE;
571/*!40000 ALTER TABLE `component_cc` DISABLE KEYS */;
572/*!40000 ALTER TABLE `component_cc` ENABLE KEYS */;
573UNLOCK TABLES;
574
575--
576-- Table structure for table `components`
577--
578
579DROP TABLE IF EXISTS `components`;
580/*!40101 SET @saved_cs_client     = @@character_set_client */;
581/*!40101 SET character_set_client = utf8 */;
582CREATE TABLE `components` (
583  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
584  `name` varchar(64) NOT NULL,
585  `product_id` smallint(6) NOT NULL,
586  `initialowner` mediumint(9) NOT NULL,
587  `initialqacontact` mediumint(9) DEFAULT NULL,
588  `description` mediumtext NOT NULL,
589  `isactive` tinyint(4) NOT NULL DEFAULT '1',
590  PRIMARY KEY (`id`),
591  UNIQUE KEY `components_product_id_idx` (`product_id`,`name`),
592  KEY `components_name_idx` (`name`),
593  KEY `fk_components_initialqacontact_profiles_userid` (`initialqacontact`),
594  KEY `fk_components_initialowner_profiles_userid` (`initialowner`),
595  CONSTRAINT `fk_components_initialowner_profiles_userid` FOREIGN KEY (`initialowner`) REFERENCES `profiles` (`userid`) ON UPDATE CASCADE,
596  CONSTRAINT `fk_components_initialqacontact_profiles_userid` FOREIGN KEY (`initialqacontact`) REFERENCES `profiles` (`userid`) ON DELETE SET NULL ON UPDATE CASCADE,
597  CONSTRAINT `fk_components_product_id_products_id` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
598) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
599/*!40101 SET character_set_client = @saved_cs_client */;
600
601--
602-- Dumping data for table `components`
603--
604
605LOCK TABLES `components` WRITE;
606/*!40000 ALTER TABLE `components` DISABLE KEYS */;
607INSERT INTO `components` VALUES (1,'TestComponent',1,1,NULL,'This is a test component in the test product database. This ought to be blown away and replaced with real stuff in a finished installation of Bugzilla.',1);
608/*!40000 ALTER TABLE `components` ENABLE KEYS */;
609UNLOCK TABLES;
610
611--
612-- Table structure for table `dependencies`
613--
614
615DROP TABLE IF EXISTS `dependencies`;
616/*!40101 SET @saved_cs_client     = @@character_set_client */;
617/*!40101 SET character_set_client = utf8 */;
618CREATE TABLE `dependencies` (
619  `blocked` mediumint(9) NOT NULL,
620  `dependson` mediumint(9) NOT NULL,
621  UNIQUE KEY `dependencies_blocked_idx` (`blocked`,`dependson`),
622  KEY `dependencies_dependson_idx` (`dependson`),
623  CONSTRAINT `fk_dependencies_blocked_bugs_bug_id` FOREIGN KEY (`blocked`) REFERENCES `bugs` (`bug_id`) ON DELETE CASCADE ON UPDATE CASCADE,
624  CONSTRAINT `fk_dependencies_dependson_bugs_bug_id` FOREIGN KEY (`dependson`) REFERENCES `bugs` (`bug_id`) ON DELETE CASCADE ON UPDATE CASCADE
625) ENGINE=InnoDB DEFAULT CHARSET=utf8;
626/*!40101 SET character_set_client = @saved_cs_client */;
627
628--
629-- Dumping data for table `dependencies`
630--
631
632LOCK TABLES `dependencies` WRITE;
633/*!40000 ALTER TABLE `dependencies` DISABLE KEYS */;
634INSERT INTO `dependencies` VALUES (10,8),(10,9);
635/*!40000 ALTER TABLE `dependencies` ENABLE KEYS */;
636UNLOCK TABLES;
637
638--
639-- Table structure for table `duplicates`
640--
641
642DROP TABLE IF EXISTS `duplicates`;
643/*!40101 SET @saved_cs_client     = @@character_set_client */;
644/*!40101 SET character_set_client = utf8 */;
645CREATE TABLE `duplicates` (
646  `dupe_of` mediumint(9) NOT NULL,
647  `dupe` mediumint(9) NOT NULL,
648  PRIMARY KEY (`dupe`),
649  KEY `fk_duplicates_dupe_of_bugs_bug_id` (`dupe_of`),
650  CONSTRAINT `fk_duplicates_dupe_bugs_bug_id` FOREIGN KEY (`dupe`) REFERENCES `bugs` (`bug_id`) ON DELETE CASCADE ON UPDATE CASCADE,
651  CONSTRAINT `fk_duplicates_dupe_of_bugs_bug_id` FOREIGN KEY (`dupe_of`) REFERENCES `bugs` (`bug_id`) ON DELETE CASCADE ON UPDATE CASCADE
652) ENGINE=InnoDB DEFAULT CHARSET=utf8;
653/*!40101 SET character_set_client = @saved_cs_client */;
654
655--
656-- Dumping data for table `duplicates`
657--
658
659LOCK TABLES `duplicates` WRITE;
660/*!40000 ALTER TABLE `duplicates` DISABLE KEYS */;
661/*!40000 ALTER TABLE `duplicates` ENABLE KEYS */;
662UNLOCK TABLES;
663
664--
665-- Table structure for table `email_bug_ignore`
666--
667
668DROP TABLE IF EXISTS `email_bug_ignore`;
669/*!40101 SET @saved_cs_client     = @@character_set_client */;
670/*!40101 SET character_set_client = utf8 */;
671CREATE TABLE `email_bug_ignore` (
672  `user_id` mediumint(9) NOT NULL,
673  `bug_id` mediumint(9) NOT NULL,
674  UNIQUE KEY `email_bug_ignore_user_id_idx` (`user_id`,`bug_id`),
675  KEY `fk_email_bug_ignore_bug_id_bugs_bug_id` (`bug_id`),
676  CONSTRAINT `fk_email_bug_ignore_bug_id_bugs_bug_id` FOREIGN KEY (`bug_id`) REFERENCES `bugs` (`bug_id`) ON DELETE CASCADE ON UPDATE CASCADE,
677  CONSTRAINT `fk_email_bug_ignore_user_id_profiles_userid` FOREIGN KEY (`user_id`) REFERENCES `profiles` (`userid`) ON DELETE CASCADE ON UPDATE CASCADE
678) ENGINE=InnoDB DEFAULT CHARSET=utf8;
679/*!40101 SET character_set_client = @saved_cs_client */;
680
681--
682-- Dumping data for table `email_bug_ignore`
683--
684
685LOCK TABLES `email_bug_ignore` WRITE;
686/*!40000 ALTER TABLE `email_bug_ignore` DISABLE KEYS */;
687/*!40000 ALTER TABLE `email_bug_ignore` ENABLE KEYS */;
688UNLOCK TABLES;
689
690--
691-- Table structure for table `email_setting`
692--
693
694DROP TABLE IF EXISTS `email_setting`;
695/*!40101 SET @saved_cs_client     = @@character_set_client */;
696/*!40101 SET character_set_client = utf8 */;
697CREATE TABLE `email_setting` (
698  `user_id` mediumint(9) NOT NULL,
699  `relationship` tinyint(4) NOT NULL,
700  `event` tinyint(4) NOT NULL,
701  UNIQUE KEY `email_setting_user_id_idx` (`user_id`,`relationship`,`event`),
702  CONSTRAINT `fk_email_setting_user_id_profiles_userid` FOREIGN KEY (`user_id`) REFERENCES `profiles` (`userid`) ON DELETE CASCADE ON UPDATE CASCADE
703) ENGINE=InnoDB DEFAULT CHARSET=utf8;
704/*!40101 SET character_set_client = @saved_cs_client */;
705
706--
707-- Dumping data for table `email_setting`
708--
709
710LOCK TABLES `email_setting` WRITE;
711/*!40000 ALTER TABLE `email_setting` DISABLE KEYS */;
712INSERT INTO `email_setting` VALUES (1,0,0),(1,0,1),(1,0,2),(1,0,3),(1,0,4),(1,0,5),(1,0,6),(1,0,7),(1,0,9),(1,0,10),(1,0,11),(1,0,50),(1,1,0),(1,1,1),(1,1,2),(1,1,3),(1,1,4),(1,1,5),(1,1,6),(1,1,7),(1,1,9),(1,1,10),(1,1,11),(1,1,50),(1,2,0),(1,2,1),(1,2,2),(1,2,3),(1,2,4),(1,2,5),(1,2,6),(1,2,7),(1,2,8),(1,2,9),(1,2,10),(1,2,11),(1,2,50),(1,3,0),(1,3,1),(1,3,2),(1,3,3),(1,3,4),(1,3,5),(1,3,6),(1,3,7),(1,3,9),(1,3,10),(1,3,11),(1,3,50),(1,5,0),(1,5,1),(1,5,2),(1,5,3),(1,5,4),(1,5,5),(1,5,6),(1,5,7),(1,5,9),(1,5,10),(1,5,11),(1,5,50),(1,100,100),(1,100,101);
713/*!40000 ALTER TABLE `email_setting` ENABLE KEYS */;
714UNLOCK TABLES;
715
716--
717-- Table structure for table `field_visibility`
718--
719
720DROP TABLE IF EXISTS `field_visibility`;
721/*!40101 SET @saved_cs_client     = @@character_set_client */;
722/*!40101 SET character_set_client = utf8 */;
723CREATE TABLE `field_visibility` (
724  `field_id` mediumint(9) DEFAULT NULL,
725  `value_id` smallint(6) NOT NULL,
726  UNIQUE KEY `field_visibility_field_id_idx` (`field_id`,`value_id`),
727  CONSTRAINT `fk_field_visibility_field_id_fielddefs_id` FOREIGN KEY (`field_id`) REFERENCES `fielddefs` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
728) ENGINE=InnoDB DEFAULT CHARSET=utf8;
729/*!40101 SET character_set_client = @saved_cs_client */;
730
731--
732-- Dumping data for table `field_visibility`
733--
734
735LOCK TABLES `field_visibility` WRITE;
736/*!40000 ALTER TABLE `field_visibility` DISABLE KEYS */;
737/*!40000 ALTER TABLE `field_visibility` ENABLE KEYS */;
738UNLOCK TABLES;
739
740--
741-- Table structure for table `fielddefs`
742--
743
744DROP TABLE IF EXISTS `fielddefs`;
745/*!40101 SET @saved_cs_client     = @@character_set_client */;
746/*!40101 SET character_set_client = utf8 */;
747CREATE TABLE `fielddefs` (
748  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
749  `name` varchar(64) NOT NULL,
750  `type` smallint(6) NOT NULL DEFAULT '0',
751  `custom` tinyint(4) NOT NULL DEFAULT '0',
752  `description` tinytext NOT NULL,
753  `long_desc` varchar(255) NOT NULL DEFAULT '',
754  `mailhead` tinyint(4) NOT NULL DEFAULT '0',
755  `sortkey` smallint(6) NOT NULL,
756  `obsolete` tinyint(4) NOT NULL DEFAULT '0',
757  `enter_bug` tinyint(4) NOT NULL DEFAULT '0',
758  `buglist` tinyint(4) NOT NULL DEFAULT '0',
759  `visibility_field_id` mediumint(9) DEFAULT NULL,
760  `value_field_id` mediumint(9) DEFAULT NULL,
761  `reverse_desc` tinytext,
762  `is_mandatory` tinyint(4) NOT NULL DEFAULT '0',
763  `is_numeric` tinyint(4) NOT NULL DEFAULT '0',
764  PRIMARY KEY (`id`),
765  UNIQUE KEY `fielddefs_name_idx` (`name`),
766  KEY `fielddefs_sortkey_idx` (`sortkey`),
767  KEY `fielddefs_value_field_id_idx` (`value_field_id`),
768  KEY `fielddefs_is_mandatory_idx` (`is_mandatory`),
769  KEY `fk_fielddefs_visibility_field_id_fielddefs_id` (`visibility_field_id`),
770  CONSTRAINT `fk_fielddefs_value_field_id_fielddefs_id` FOREIGN KEY (`value_field_id`) REFERENCES `fielddefs` (`id`) ON UPDATE CASCADE,
771  CONSTRAINT `fk_fielddefs_visibility_field_id_fielddefs_id` FOREIGN KEY (`visibility_field_id`) REFERENCES `fielddefs` (`id`) ON UPDATE CASCADE
772) ENGINE=InnoDB AUTO_INCREMENT=60 DEFAULT CHARSET=utf8;
773/*!40101 SET character_set_client = @saved_cs_client */;
774
775--
776-- Dumping data for table `fielddefs`
777--
778
779LOCK TABLES `fielddefs` WRITE;
780/*!40000 ALTER TABLE `fielddefs` DISABLE KEYS */;
781INSERT INTO `fielddefs` VALUES (1,'bug_id',0,0,'Bug #','',1,100,0,0,1,NULL,NULL,NULL,0,1),(2,'short_desc',0,0,'Summary','',1,200,0,0,1,NULL,NULL,NULL,1,0),(3,'classification',2,0,'Classification','',1,300,0,0,1,NULL,NULL,NULL,0,0),(4,'product',2,0,'Product','',1,400,0,0,1,NULL,NULL,NULL,1,0),(5,'version',0,0,'Version','',1,500,0,0,1,NULL,NULL,NULL,1,0),(6,'rep_platform',2,0,'Platform','',1,600,0,0,1,NULL,NULL,NULL,0,0),(7,'bug_file_loc',0,0,'URL','',1,700,0,0,1,NULL,NULL,NULL,0,0),(8,'op_sys',2,0,'OS/Version','',1,800,0,0,1,NULL,NULL,NULL,0,0),(9,'bug_status',2,0,'Status','',1,900,0,0,1,NULL,NULL,NULL,0,0),(10,'status_whiteboard',0,0,'Status Whiteboard','',1,1000,0,0,1,NULL,NULL,NULL,0,0),(11,'keywords',8,0,'Keywords','',1,1100,0,0,1,NULL,NULL,NULL,0,0),(12,'resolution',2,0,'Resolution','',0,1200,0,0,1,NULL,NULL,NULL,0,0),(13,'bug_severity',2,0,'Severity','',1,1300,0,0,1,NULL,NULL,NULL,0,0),(14,'priority',2,0,'Priority','',1,1400,0,0,1,NULL,NULL,NULL,0,0),(15,'component',2,0,'Component','',1,1500,0,0,1,NULL,NULL,NULL,1,0),(16,'assigned_to',0,0,'AssignedTo','',1,1600,0,0,1,NULL,NULL,NULL,0,0),(17,'reporter',0,0,'ReportedBy','',1,1700,0,0,1,NULL,NULL,NULL,0,0),(18,'qa_contact',0,0,'QAContact','',1,1800,0,0,1,NULL,NULL,NULL,0,0),(19,'assigned_to_realname',0,0,'AssignedToName','',0,1900,0,0,1,NULL,NULL,NULL,0,0),(20,'reporter_realname',0,0,'ReportedByName','',0,2000,0,0,1,NULL,NULL,NULL,0,0),(21,'qa_contact_realname',0,0,'QAContactName','',0,2100,0,0,1,NULL,NULL,NULL,0,0),(22,'cc',0,0,'CC','',1,2200,0,0,0,NULL,NULL,NULL,0,0),(23,'dependson',0,0,'Depends on','',1,2300,0,0,1,NULL,NULL,NULL,0,1),(24,'blocked',0,0,'Blocks','',1,2400,0,0,1,NULL,NULL,NULL,0,1),(25,'attachments.description',0,0,'Attachment description','',0,2500,0,0,0,NULL,NULL,NULL,0,0),(26,'attachments.filename',0,0,'Attachment filename','',0,2600,0,0,0,NULL,NULL,NULL,0,0),(27,'attachments.mimetype',0,0,'Attachment mime type','',0,2700,0,0,0,NULL,NULL,NULL,0,0),(28,'attachments.ispatch',0,0,'Attachment is patch','',0,2800,0,0,0,NULL,NULL,NULL,0,1),(29,'attachments.isobsolete',0,0,'Attachment is obsolete','',0,2900,0,0,0,NULL,NULL,NULL,0,1),(30,'attachments.isprivate',0,0,'Attachment is private','',0,3000,0,0,0,NULL,NULL,NULL,0,1),(31,'attachments.submitter',0,0,'Attachment creator','',0,3100,0,0,0,NULL,NULL,NULL,0,0),(32,'target_milestone',0,0,'Target Milestone','',1,3200,0,0,1,NULL,NULL,NULL,0,0),(33,'creation_ts',0,0,'Creation date','',0,3300,0,0,1,NULL,NULL,NULL,0,0),(34,'delta_ts',0,0,'Last changed date','',0,3400,0,0,1,NULL,NULL,NULL,0,0),(35,'longdesc',0,0,'Comment','',0,3500,0,0,0,NULL,NULL,NULL,0,0),(36,'longdescs.isprivate',0,0,'Comment is private','',0,3600,0,0,0,NULL,NULL,NULL,0,1),(37,'longdescs.count',0,0,'Number of Comments','',0,3700,0,0,1,NULL,NULL,NULL,0,1),(38,'alias',0,0,'Alias','',0,3800,0,0,1,NULL,NULL,NULL,0,0),(39,'everconfirmed',0,0,'Ever Confirmed','',0,3900,0,0,0,NULL,NULL,NULL,0,1),(40,'reporter_accessible',0,0,'Reporter Accessible','',0,4000,0,0,0,NULL,NULL,NULL,0,1),(41,'cclist_accessible',0,0,'CC Accessible','',0,4100,0,0,0,NULL,NULL,NULL,0,1),(42,'bug_group',0,0,'Group','',1,4200,0,0,0,NULL,NULL,NULL,0,0),(43,'estimated_time',0,0,'Estimated Hours','',1,4300,0,0,1,NULL,NULL,NULL,0,1),(44,'remaining_time',0,0,'Remaining Hours','',0,4400,0,0,1,NULL,NULL,NULL,0,1),(45,'deadline',5,0,'Deadline','',1,4500,0,0,1,NULL,NULL,NULL,0,0),(46,'commenter',0,0,'Commenter','',0,4600,0,0,0,NULL,NULL,NULL,0,0),(47,'flagtypes.name',0,0,'Flags','',0,4700,0,0,1,NULL,NULL,NULL,0,0),(48,'requestees.login_name',0,0,'Flag Requestee','',0,4800,0,0,0,NULL,NULL,NULL,0,0),(49,'setters.login_name',0,0,'Flag Setter','',0,4900,0,0,0,NULL,NULL,NULL,0,0),(50,'work_time',0,0,'Hours Worked','',0,5000,0,0,1,NULL,NULL,NULL,0,1),(51,'percentage_complete',0,0,'Percentage Complete','',0,5100,0,0,1,NULL,NULL,NULL,0,1),(52,'content',0,0,'Content','',0,5200,0,0,0,NULL,NULL,NULL,0,0),(53,'attach_data.thedata',0,0,'Attachment data','',0,5300,0,0,0,NULL,NULL,NULL,0,0),(54,'owner_idle_time',0,0,'Time Since Assignee Touched','',0,5400,0,0,0,NULL,NULL,NULL,0,0),(55,'see_also',7,0,'See Also','',0,5500,0,0,0,NULL,NULL,NULL,0,0),(56,'tag',8,0,'Personal Tags','',0,5600,0,0,1,NULL,NULL,NULL,0,0),(57,'last_visit_ts',5,0,'Last Visit','',0,5700,0,0,1,NULL,NULL,NULL,0,0),(58,'comment_tag',0,0,'Comment Tag','',0,5800,0,0,0,NULL,NULL,NULL,0,0),(59,'days_elapsed',0,0,'Days since bug changed','',0,5900,0,0,0,NULL,NULL,NULL,0,0);
782/*!40000 ALTER TABLE `fielddefs` ENABLE KEYS */;
783UNLOCK TABLES;
784
785--
786-- Table structure for table `flagexclusions`
787--
788
789DROP TABLE IF EXISTS `flagexclusions`;
790/*!40101 SET @saved_cs_client     = @@character_set_client */;
791/*!40101 SET character_set_client = utf8 */;
792CREATE TABLE `flagexclusions` (
793  `type_id` smallint(6) NOT NULL,
794  `product_id` smallint(6) DEFAULT NULL,
795  `component_id` mediumint(9) DEFAULT NULL,
796  UNIQUE KEY `flagexclusions_type_id_idx` (`type_id`,`product_id`,`component_id`),
797  KEY `fk_flagexclusions_component_id_components_id` (`component_id`),
798  KEY `fk_flagexclusions_product_id_products_id` (`product_id`),
799  CONSTRAINT `fk_flagexclusions_component_id_components_id` FOREIGN KEY (`component_id`) REFERENCES `components` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
800  CONSTRAINT `fk_flagexclusions_product_id_products_id` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
801  CONSTRAINT `fk_flagexclusions_type_id_flagtypes_id` FOREIGN KEY (`type_id`) REFERENCES `flagtypes` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
802) ENGINE=InnoDB DEFAULT CHARSET=utf8;
803/*!40101 SET character_set_client = @saved_cs_client */;
804
805--
806-- Dumping data for table `flagexclusions`
807--
808
809LOCK TABLES `flagexclusions` WRITE;
810/*!40000 ALTER TABLE `flagexclusions` DISABLE KEYS */;
811/*!40000 ALTER TABLE `flagexclusions` ENABLE KEYS */;
812UNLOCK TABLES;
813
814--
815-- Table structure for table `flaginclusions`
816--
817
818DROP TABLE IF EXISTS `flaginclusions`;
819/*!40101 SET @saved_cs_client     = @@character_set_client */;
820/*!40101 SET character_set_client = utf8 */;
821CREATE TABLE `flaginclusions` (
822  `type_id` smallint(6) NOT NULL,
823  `product_id` smallint(6) DEFAULT NULL,
824  `component_id` mediumint(9) DEFAULT NULL,
825  UNIQUE KEY `flaginclusions_type_id_idx` (`type_id`,`product_id`,`component_id`),
826  KEY `fk_flaginclusions_product_id_products_id` (`product_id`),
827  KEY `fk_flaginclusions_component_id_components_id` (`component_id`),
828  CONSTRAINT `fk_flaginclusions_component_id_components_id` FOREIGN KEY (`component_id`) REFERENCES `components` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
829  CONSTRAINT `fk_flaginclusions_product_id_products_id` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
830  CONSTRAINT `fk_flaginclusions_type_id_flagtypes_id` FOREIGN KEY (`type_id`) REFERENCES `flagtypes` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
831) ENGINE=InnoDB DEFAULT CHARSET=utf8;
832/*!40101 SET character_set_client = @saved_cs_client */;
833
834--
835-- Dumping data for table `flaginclusions`
836--
837
838LOCK TABLES `flaginclusions` WRITE;
839/*!40000 ALTER TABLE `flaginclusions` DISABLE KEYS */;
840/*!40000 ALTER TABLE `flaginclusions` ENABLE KEYS */;
841UNLOCK TABLES;
842
843--
844-- Table structure for table `flags`
845--
846
847DROP TABLE IF EXISTS `flags`;
848/*!40101 SET @saved_cs_client     = @@character_set_client */;
849/*!40101 SET character_set_client = utf8 */;
850CREATE TABLE `flags` (
851  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
852  `type_id` smallint(6) NOT NULL,
853  `status` char(1) NOT NULL,
854  `bug_id` mediumint(9) NOT NULL,
855  `attach_id` mediumint(9) DEFAULT NULL,
856  `creation_date` datetime NOT NULL,
857  `modification_date` datetime DEFAULT NULL,
858  `setter_id` mediumint(9) NOT NULL,
859  `requestee_id` mediumint(9) DEFAULT NULL,
860  PRIMARY KEY (`id`),
861  KEY `flags_bug_id_idx` (`bug_id`,`attach_id`),
862  KEY `flags_setter_id_idx` (`setter_id`),
863  KEY `flags_requestee_id_idx` (`requestee_id`),
864  KEY `flags_type_id_idx` (`type_id`),
865  KEY `fk_flags_attach_id_attachments_attach_id` (`attach_id`),
866  CONSTRAINT `fk_flags_attach_id_attachments_attach_id` FOREIGN KEY (`attach_id`) REFERENCES `attachments` (`attach_id`) ON DELETE CASCADE ON UPDATE CASCADE,
867  CONSTRAINT `fk_flags_bug_id_bugs_bug_id` FOREIGN KEY (`bug_id`) REFERENCES `bugs` (`bug_id`) ON DELETE CASCADE ON UPDATE CASCADE,
868  CONSTRAINT `fk_flags_requestee_id_profiles_userid` FOREIGN KEY (`requestee_id`) REFERENCES `profiles` (`userid`) ON UPDATE CASCADE,
869  CONSTRAINT `fk_flags_setter_id_profiles_userid` FOREIGN KEY (`setter_id`) REFERENCES `profiles` (`userid`) ON UPDATE CASCADE,
870  CONSTRAINT `fk_flags_type_id_flagtypes_id` FOREIGN KEY (`type_id`) REFERENCES `flagtypes` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
871) ENGINE=InnoDB DEFAULT CHARSET=utf8;
872/*!40101 SET character_set_client = @saved_cs_client */;
873
874--
875-- Dumping data for table `flags`
876--
877
878LOCK TABLES `flags` WRITE;
879/*!40000 ALTER TABLE `flags` DISABLE KEYS */;
880/*!40000 ALTER TABLE `flags` ENABLE KEYS */;
881UNLOCK TABLES;
882
883--
884-- Table structure for table `flagtypes`
885--
886
887DROP TABLE IF EXISTS `flagtypes`;
888/*!40101 SET @saved_cs_client     = @@character_set_client */;
889/*!40101 SET character_set_client = utf8 */;
890CREATE TABLE `flagtypes` (
891  `id` smallint(6) NOT NULL AUTO_INCREMENT,
892  `name` varchar(50) NOT NULL,
893  `description` mediumtext NOT NULL,
894  `cc_list` varchar(200) DEFAULT NULL,
895  `target_type` char(1) NOT NULL DEFAULT 'b',
896  `is_active` tinyint(4) NOT NULL DEFAULT '1',
897  `is_requestable` tinyint(4) NOT NULL DEFAULT '0',
898  `is_requesteeble` tinyint(4) NOT NULL DEFAULT '0',
899  `is_multiplicable` tinyint(4) NOT NULL DEFAULT '0',
900  `sortkey` smallint(6) NOT NULL DEFAULT '0',
901  `grant_group_id` mediumint(9) DEFAULT NULL,
902  `request_group_id` mediumint(9) DEFAULT NULL,
903  PRIMARY KEY (`id`),
904  KEY `fk_flagtypes_request_group_id_groups_id` (`request_group_id`),
905  KEY `fk_flagtypes_grant_group_id_groups_id` (`grant_group_id`),
906  CONSTRAINT `fk_flagtypes_grant_group_id_groups_id` FOREIGN KEY (`grant_group_id`) REFERENCES `groups` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
907  CONSTRAINT `fk_flagtypes_request_group_id_groups_id` FOREIGN KEY (`request_group_id`) REFERENCES `groups` (`id`) ON DELETE SET NULL ON UPDATE CASCADE
908) ENGINE=InnoDB DEFAULT CHARSET=utf8;
909/*!40101 SET character_set_client = @saved_cs_client */;
910
911--
912-- Dumping data for table `flagtypes`
913--
914
915LOCK TABLES `flagtypes` WRITE;
916/*!40000 ALTER TABLE `flagtypes` DISABLE KEYS */;
917/*!40000 ALTER TABLE `flagtypes` ENABLE KEYS */;
918UNLOCK TABLES;
919
920--
921-- Table structure for table `group_control_map`
922--
923
924DROP TABLE IF EXISTS `group_control_map`;
925/*!40101 SET @saved_cs_client     = @@character_set_client */;
926/*!40101 SET character_set_client = utf8 */;
927CREATE TABLE `group_control_map` (
928  `group_id` mediumint(9) NOT NULL,
929  `product_id` smallint(6) NOT NULL,
930  `entry` tinyint(4) NOT NULL DEFAULT '0',
931  `membercontrol` tinyint(4) NOT NULL DEFAULT '0',
932  `othercontrol` tinyint(4) NOT NULL DEFAULT '0',
933  `canedit` tinyint(4) NOT NULL DEFAULT '0',
934  `editcomponents` tinyint(4) NOT NULL DEFAULT '0',
935  `editbugs` tinyint(4) NOT NULL DEFAULT '0',
936  `canconfirm` tinyint(4) NOT NULL DEFAULT '0',
937  UNIQUE KEY `group_control_map_product_id_idx` (`product_id`,`group_id`),
938  KEY `group_control_map_group_id_idx` (`group_id`),
939  CONSTRAINT `fk_group_control_map_group_id_groups_id` FOREIGN KEY (`group_id`) REFERENCES `groups` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
940  CONSTRAINT `fk_group_control_map_product_id_products_id` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
941) ENGINE=InnoDB DEFAULT CHARSET=utf8;
942/*!40101 SET character_set_client = @saved_cs_client */;
943
944--
945-- Dumping data for table `group_control_map`
946--
947
948LOCK TABLES `group_control_map` WRITE;
949/*!40000 ALTER TABLE `group_control_map` DISABLE KEYS */;
950/*!40000 ALTER TABLE `group_control_map` ENABLE KEYS */;
951UNLOCK TABLES;
952
953--
954-- Table structure for table `group_group_map`
955--
956
957DROP TABLE IF EXISTS `group_group_map`;
958/*!40101 SET @saved_cs_client     = @@character_set_client */;
959/*!40101 SET character_set_client = utf8 */;
960CREATE TABLE `group_group_map` (
961  `member_id` mediumint(9) NOT NULL,
962  `grantor_id` mediumint(9) NOT NULL,
963  `grant_type` tinyint(4) NOT NULL DEFAULT '0',
964  UNIQUE KEY `group_group_map_member_id_idx` (`member_id`,`grantor_id`,`grant_type`),
965  KEY `fk_group_group_map_grantor_id_groups_id` (`grantor_id`),
966  CONSTRAINT `fk_group_group_map_grantor_id_groups_id` FOREIGN KEY (`grantor_id`) REFERENCES `groups` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
967  CONSTRAINT `fk_group_group_map_member_id_groups_id` FOREIGN KEY (`member_id`) REFERENCES `groups` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
968) ENGINE=InnoDB DEFAULT CHARSET=utf8;
969/*!40101 SET character_set_client = @saved_cs_client */;
970
971--
972-- Dumping data for table `group_group_map`
973--
974
975LOCK TABLES `group_group_map` WRITE;
976/*!40000 ALTER TABLE `group_group_map` DISABLE KEYS */;
977INSERT INTO `group_group_map` VALUES (1,1,0),(1,1,1),(1,1,2),(1,2,0),(1,2,1),(1,2,2),(1,3,0),(1,3,1),(1,3,2),(1,4,0),(1,4,1),(1,4,2),(1,5,0),(1,5,1),(1,5,2),(1,6,0),(1,6,1),(1,6,2),(1,7,0),(1,7,1),(1,7,2),(1,8,0),(1,8,1),(1,8,2),(1,9,0),(1,9,1),(1,9,2),(1,10,0),(1,10,1),(1,10,2),(1,11,0),(1,11,1),(1,11,2),(8,11,0),(10,11,0),(1,12,0),(1,12,1),(1,12,2),(1,13,0),(1,13,1),(1,13,2),(12,13,0),(1,14,0),(1,14,1),(1,14,2);
978/*!40000 ALTER TABLE `group_group_map` ENABLE KEYS */;
979UNLOCK TABLES;
980
981--
982-- Table structure for table `groups`
983--
984
985DROP TABLE IF EXISTS `groups`;
986/*!40101 SET @saved_cs_client     = @@character_set_client */;
987/*!40101 SET character_set_client = utf8 */;
988CREATE TABLE `groups` (
989  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
990  `name` varchar(255) NOT NULL,
991  `description` mediumtext NOT NULL,
992  `isbuggroup` tinyint(4) NOT NULL,
993  `userregexp` tinytext NOT NULL,
994  `isactive` tinyint(4) NOT NULL DEFAULT '1',
995  `icon_url` tinytext,
996  PRIMARY KEY (`id`),
997  UNIQUE KEY `groups_name_idx` (`name`)
998) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;
999/*!40101 SET character_set_client = @saved_cs_client */;
1000
1001--
1002-- Dumping data for table `groups`
1003--
1004
1005LOCK TABLES `groups` WRITE;
1006/*!40000 ALTER TABLE `groups` DISABLE KEYS */;
1007INSERT INTO `groups` VALUES (1,'admin','Administrators',0,'',1,NULL),(2,'tweakparams','Can change Parameters',0,'',1,NULL),(3,'editusers','Can edit or disable users',0,'',1,NULL),(4,'creategroups','Can create and destroy groups',0,'',1,NULL),(5,'editclassifications','Can create, destroy, and edit classifications',0,'',1,NULL),(6,'editcomponents','Can create, destroy, and edit components',0,'',1,NULL),(7,'editkeywords','Can create, destroy, and edit keywords',0,'',1,NULL),(8,'editbugs','Can edit all bug fields',0,'.*',1,NULL),(9,'canconfirm','Can confirm a bug or mark it a duplicate',0,'',1,NULL),(10,'bz_canusewhineatothers','Can configure whine reports for other users',0,'',1,NULL),(11,'bz_canusewhines','User can configure whine reports for self',0,'',1,NULL),(12,'bz_sudoers','Can perform actions as other users',0,'',1,NULL),(13,'bz_sudo_protect','Can not be impersonated by other users',0,'',1,NULL),(14,'bz_quip_moderators','Can moderate quips',0,'',1,NULL);
1008/*!40000 ALTER TABLE `groups` ENABLE KEYS */;
1009UNLOCK TABLES;
1010
1011--
1012-- Table structure for table `keyworddefs`
1013--
1014
1015DROP TABLE IF EXISTS `keyworddefs`;
1016/*!40101 SET @saved_cs_client     = @@character_set_client */;
1017/*!40101 SET character_set_client = utf8 */;
1018CREATE TABLE `keyworddefs` (
1019  `id` smallint(6) NOT NULL AUTO_INCREMENT,
1020  `name` varchar(64) NOT NULL,
1021  `description` mediumtext NOT NULL,
1022  PRIMARY KEY (`id`),
1023  UNIQUE KEY `keyworddefs_name_idx` (`name`)
1024) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1025/*!40101 SET character_set_client = @saved_cs_client */;
1026
1027--
1028-- Dumping data for table `keyworddefs`
1029--
1030
1031LOCK TABLES `keyworddefs` WRITE;
1032/*!40000 ALTER TABLE `keyworddefs` DISABLE KEYS */;
1033/*!40000 ALTER TABLE `keyworddefs` ENABLE KEYS */;
1034UNLOCK TABLES;
1035
1036--
1037-- Table structure for table `keywords`
1038--
1039
1040DROP TABLE IF EXISTS `keywords`;
1041/*!40101 SET @saved_cs_client     = @@character_set_client */;
1042/*!40101 SET character_set_client = utf8 */;
1043CREATE TABLE `keywords` (
1044  `bug_id` mediumint(9) NOT NULL,
1045  `keywordid` smallint(6) NOT NULL,
1046  UNIQUE KEY `keywords_bug_id_idx` (`bug_id`,`keywordid`),
1047  KEY `keywords_keywordid_idx` (`keywordid`),
1048  CONSTRAINT `fk_keywords_bug_id_bugs_bug_id` FOREIGN KEY (`bug_id`) REFERENCES `bugs` (`bug_id`) ON DELETE CASCADE ON UPDATE CASCADE,
1049  CONSTRAINT `fk_keywords_keywordid_keyworddefs_id` FOREIGN KEY (`keywordid`) REFERENCES `keyworddefs` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
1050) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1051/*!40101 SET character_set_client = @saved_cs_client */;
1052
1053--
1054-- Dumping data for table `keywords`
1055--
1056
1057LOCK TABLES `keywords` WRITE;
1058/*!40000 ALTER TABLE `keywords` DISABLE KEYS */;
1059/*!40000 ALTER TABLE `keywords` ENABLE KEYS */;
1060UNLOCK TABLES;
1061
1062--
1063-- Table structure for table `login_failure`
1064--
1065
1066DROP TABLE IF EXISTS `login_failure`;
1067/*!40101 SET @saved_cs_client     = @@character_set_client */;
1068/*!40101 SET character_set_client = utf8 */;
1069CREATE TABLE `login_failure` (
1070  `user_id` mediumint(9) NOT NULL,
1071  `login_time` datetime NOT NULL,
1072  `ip_addr` varchar(40) NOT NULL,
1073  KEY `login_failure_user_id_idx` (`user_id`),
1074  CONSTRAINT `fk_login_failure_user_id_profiles_userid` FOREIGN KEY (`user_id`) REFERENCES `profiles` (`userid`) ON DELETE CASCADE ON UPDATE CASCADE
1075) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1076/*!40101 SET character_set_client = @saved_cs_client */;
1077
1078--
1079-- Dumping data for table `login_failure`
1080--
1081
1082LOCK TABLES `login_failure` WRITE;
1083/*!40000 ALTER TABLE `login_failure` DISABLE KEYS */;
1084/*!40000 ALTER TABLE `login_failure` ENABLE KEYS */;
1085UNLOCK TABLES;
1086
1087--
1088-- Table structure for table `logincookies`
1089--
1090
1091DROP TABLE IF EXISTS `logincookies`;
1092/*!40101 SET @saved_cs_client     = @@character_set_client */;
1093/*!40101 SET character_set_client = utf8 */;
1094CREATE TABLE `logincookies` (
1095  `cookie` varchar(16) NOT NULL,
1096  `userid` mediumint(9) NOT NULL,
1097  `ipaddr` varchar(40) DEFAULT NULL,
1098  `lastused` datetime NOT NULL,
1099  PRIMARY KEY (`cookie`),
1100  KEY `logincookies_lastused_idx` (`lastused`),
1101  KEY `fk_logincookies_userid_profiles_userid` (`userid`),
1102  CONSTRAINT `fk_logincookies_userid_profiles_userid` FOREIGN KEY (`userid`) REFERENCES `profiles` (`userid`) ON DELETE CASCADE ON UPDATE CASCADE
1103) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1104/*!40101 SET character_set_client = @saved_cs_client */;
1105
1106--
1107-- Dumping data for table `logincookies`
1108--
1109
1110LOCK TABLES `logincookies` WRITE;
1111/*!40000 ALTER TABLE `logincookies` DISABLE KEYS */;
1112INSERT INTO `logincookies` VALUES ('omiXmHNYUO',1,'127.0.0.1','2018-05-02 10:21:16');
1113/*!40000 ALTER TABLE `logincookies` ENABLE KEYS */;
1114UNLOCK TABLES;
1115
1116--
1117-- Table structure for table `longdescs`
1118--
1119
1120DROP TABLE IF EXISTS `longdescs`;
1121/*!40101 SET @saved_cs_client     = @@character_set_client */;
1122/*!40101 SET character_set_client = utf8 */;
1123CREATE TABLE `longdescs` (
1124  `comment_id` int(11) NOT NULL AUTO_INCREMENT,
1125  `bug_id` mediumint(9) NOT NULL,
1126  `who` mediumint(9) NOT NULL,
1127  `bug_when` datetime NOT NULL,
1128  `work_time` decimal(7,2) NOT NULL DEFAULT '0.00',
1129  `thetext` mediumtext NOT NULL,
1130  `isprivate` tinyint(4) NOT NULL DEFAULT '0',
1131  `already_wrapped` tinyint(4) NOT NULL DEFAULT '0',
1132  `type` smallint(6) NOT NULL DEFAULT '0',
1133  `extra_data` varchar(255) DEFAULT NULL,
1134  PRIMARY KEY (`comment_id`),
1135  KEY `longdescs_bug_id_idx` (`bug_id`,`work_time`),
1136  KEY `longdescs_who_idx` (`who`,`bug_id`),
1137  KEY `longdescs_bug_when_idx` (`bug_when`),
1138  CONSTRAINT `fk_longdescs_bug_id_bugs_bug_id` FOREIGN KEY (`bug_id`) REFERENCES `bugs` (`bug_id`) ON DELETE CASCADE ON UPDATE CASCADE,
1139  CONSTRAINT `fk_longdescs_who_profiles_userid` FOREIGN KEY (`who`) REFERENCES `profiles` (`userid`) ON UPDATE CASCADE
1140) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;
1141/*!40101 SET character_set_client = @saved_cs_client */;
1142
1143--
1144-- Dumping data for table `longdescs`
1145--
1146
1147LOCK TABLES `longdescs` WRITE;
1148/*!40000 ALTER TABLE `longdescs` DISABLE KEYS */;
1149INSERT INTO `longdescs` VALUES (1,1,1,'2018-04-10 16:34:54',0.00,'',0,0,0,NULL),(2,2,1,'2018-04-10 19:29:21',0.00,'1. After installation run programm.\n2. Item \"Edjit\" has wrong spelling',0,0,0,NULL),(3,1,1,'2018-04-10 19:31:11',0.00,'1. Download installation file .exe.\n2. Double click on installation file.\n3. Press \"Ok\" button in opened window.\n4. \"Cancel\" button is missing.',0,0,0,NULL),(4,3,1,'2018-04-10 19:35:28',0.00,'1. Run ListBoxer\n2. Take a look at right-corner where shows the number of records',0,0,0,NULL),(5,4,1,'2018-04-10 19:38:03',0.00,'1. Run ListBoxer\n2. Add any one record\n3. Button \"Clear all\" is inactive',0,0,0,NULL),(6,5,1,'2018-04-10 19:41:05',0.00,'1. Run ListBoxer\n2. Click on item \"About program\"\n3. See error page instead of reference',0,0,0,NULL),(7,6,1,'2018-04-10 19:43:06',0.00,'1. Run ListBoxer\n2. Choose alphabetic layout\n3. Type symbol \"$\" and add record with it\n4. Record will be added',0,0,0,NULL),(8,7,1,'2018-04-10 19:45:42',0.00,'Version is printed with using coma instead dot.\n1. Run ListBoxer\n2. Click item Help\n3. See incorrect spelling of paragraph \"Version x.x\" (where x.x - number of version)',0,0,0,NULL),(9,8,1,'2018-04-10 19:46:52',0.00,'1. Run ListBoxer\n2. See that element \"Cut\" is unavailable',0,0,0,NULL),(10,9,1,'2018-04-10 19:48:33',0.00,'1. Run ListBoxer\n2. See that element \"Copy\" is unavailable',0,0,0,NULL),(11,10,1,'2018-04-10 19:49:18',0.00,'1. Run ListBoxer\n2. See that element \"Paste\" is unavailable',0,0,0,NULL);
1150/*!40000 ALTER TABLE `longdescs` ENABLE KEYS */;
1151UNLOCK TABLES;
1152
1153--
1154-- Table structure for table `longdescs_tags`
1155--
1156
1157DROP TABLE IF EXISTS `longdescs_tags`;
1158/*!40101 SET @saved_cs_client     = @@character_set_client */;
1159/*!40101 SET character_set_client = utf8 */;
1160CREATE TABLE `longdescs_tags` (
1161  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
1162  `comment_id` int(11) DEFAULT NULL,
1163  `tag` varchar(24) NOT NULL,
1164  PRIMARY KEY (`id`),
1165  UNIQUE KEY `longdescs_tags_idx` (`comment_id`,`tag`),
1166  CONSTRAINT `fk_longdescs_tags_comment_id_longdescs_comment_id` FOREIGN KEY (`comment_id`) REFERENCES `longdescs` (`comment_id`) ON DELETE CASCADE ON UPDATE CASCADE
1167) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1168/*!40101 SET character_set_client = @saved_cs_client */;
1169
1170--
1171-- Dumping data for table `longdescs_tags`
1172--
1173
1174LOCK TABLES `longdescs_tags` WRITE;
1175/*!40000 ALTER TABLE `longdescs_tags` DISABLE KEYS */;
1176/*!40000 ALTER TABLE `longdescs_tags` ENABLE KEYS */;
1177UNLOCK TABLES;
1178
1179--
1180-- Table structure for table `longdescs_tags_activity`
1181--
1182
1183DROP TABLE IF EXISTS `longdescs_tags_activity`;
1184/*!40101 SET @saved_cs_client     = @@character_set_client */;
1185/*!40101 SET character_set_client = utf8 */;
1186CREATE TABLE `longdescs_tags_activity` (
1187  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
1188  `bug_id` mediumint(9) NOT NULL,
1189  `comment_id` int(11) DEFAULT NULL,
1190  `who` mediumint(9) NOT NULL,
1191  `bug_when` datetime NOT NULL,
1192  `added` varchar(24) DEFAULT NULL,
1193  `removed` varchar(24) DEFAULT NULL,
1194  PRIMARY KEY (`id`),
1195  KEY `longdescs_tags_activity_bug_id_idx` (`bug_id`),
1196  KEY `fk_longdescs_tags_activity_who_profiles_userid` (`who`),
1197  KEY `fk_longdescs_tags_activity_comment_id_longdescs_comment_id` (`comment_id`),
1198  CONSTRAINT `fk_longdescs_tags_activity_bug_id_bugs_bug_id` FOREIGN KEY (`bug_id`) REFERENCES `bugs` (`bug_id`) ON DELETE CASCADE ON UPDATE CASCADE,
1199  CONSTRAINT `fk_longdescs_tags_activity_comment_id_longdescs_comment_id` FOREIGN KEY (`comment_id`) REFERENCES `longdescs` (`comment_id`) ON DELETE CASCADE ON UPDATE CASCADE,
1200  CONSTRAINT `fk_longdescs_tags_activity_who_profiles_userid` FOREIGN KEY (`who`) REFERENCES `profiles` (`userid`) ON UPDATE CASCADE
1201) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1202/*!40101 SET character_set_client = @saved_cs_client */;
1203
1204--
1205-- Dumping data for table `longdescs_tags_activity`
1206--
1207
1208LOCK TABLES `longdescs_tags_activity` WRITE;
1209/*!40000 ALTER TABLE `longdescs_tags_activity` DISABLE KEYS */;
1210/*!40000 ALTER TABLE `longdescs_tags_activity` ENABLE KEYS */;
1211UNLOCK TABLES;
1212
1213--
1214-- Table structure for table `longdescs_tags_weights`
1215--
1216
1217DROP TABLE IF EXISTS `longdescs_tags_weights`;
1218/*!40101 SET @saved_cs_client     = @@character_set_client */;
1219/*!40101 SET character_set_client = utf8 */;
1220CREATE TABLE `longdescs_tags_weights` (
1221  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
1222  `tag` varchar(24) NOT NULL,
1223  `weight` mediumint(9) NOT NULL,
1224  PRIMARY KEY (`id`),
1225  UNIQUE KEY `longdescs_tags_weights_tag_idx` (`tag`)
1226) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1227/*!40101 SET character_set_client = @saved_cs_client */;
1228
1229--
1230-- Dumping data for table `longdescs_tags_weights`
1231--
1232
1233LOCK TABLES `longdescs_tags_weights` WRITE;
1234/*!40000 ALTER TABLE `longdescs_tags_weights` DISABLE KEYS */;
1235/*!40000 ALTER TABLE `longdescs_tags_weights` ENABLE KEYS */;
1236UNLOCK TABLES;
1237
1238--
1239-- Table structure for table `mail_staging`
1240--
1241
1242DROP TABLE IF EXISTS `mail_staging`;
1243/*!40101 SET @saved_cs_client     = @@character_set_client */;
1244/*!40101 SET character_set_client = utf8 */;
1245CREATE TABLE `mail_staging` (
1246  `id` int(11) NOT NULL AUTO_INCREMENT,
1247  `message` longblob NOT NULL,
1248  PRIMARY KEY (`id`)
1249) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1250/*!40101 SET character_set_client = @saved_cs_client */;
1251
1252--
1253-- Dumping data for table `mail_staging`
1254--
1255
1256LOCK TABLES `mail_staging` WRITE;
1257/*!40000 ALTER TABLE `mail_staging` DISABLE KEYS */;
1258/*!40000 ALTER TABLE `mail_staging` ENABLE KEYS */;
1259UNLOCK TABLES;
1260
1261--
1262-- Table structure for table `milestones`
1263--
1264
1265DROP TABLE IF EXISTS `milestones`;
1266/*!40101 SET @saved_cs_client     = @@character_set_client */;
1267/*!40101 SET character_set_client = utf8 */;
1268CREATE TABLE `milestones` (
1269  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
1270  `product_id` smallint(6) NOT NULL,
1271  `value` varchar(64) NOT NULL,
1272  `sortkey` smallint(6) NOT NULL DEFAULT '0',
1273  `isactive` tinyint(4) NOT NULL DEFAULT '1',
1274  PRIMARY KEY (`id`),
1275  UNIQUE KEY `milestones_product_id_idx` (`product_id`,`value`),
1276  CONSTRAINT `fk_milestones_product_id_products_id` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
1277) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
1278/*!40101 SET character_set_client = @saved_cs_client */;
1279
1280--
1281-- Dumping data for table `milestones`
1282--
1283
1284LOCK TABLES `milestones` WRITE;
1285/*!40000 ALTER TABLE `milestones` DISABLE KEYS */;
1286INSERT INTO `milestones` VALUES (1,1,'---',0,1);
1287/*!40000 ALTER TABLE `milestones` ENABLE KEYS */;
1288UNLOCK TABLES;
1289
1290--
1291-- Table structure for table `namedqueries`
1292--
1293
1294DROP TABLE IF EXISTS `namedqueries`;
1295/*!40101 SET @saved_cs_client     = @@character_set_client */;
1296/*!40101 SET character_set_client = utf8 */;
1297CREATE TABLE `namedqueries` (
1298  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
1299  `userid` mediumint(9) NOT NULL,
1300  `name` varchar(64) NOT NULL,
1301  `query` mediumtext NOT NULL,
1302  PRIMARY KEY (`id`),
1303  UNIQUE KEY `namedqueries_userid_idx` (`userid`,`name`),
1304  CONSTRAINT `fk_namedqueries_userid_profiles_userid` FOREIGN KEY (`userid`) REFERENCES `profiles` (`userid`) ON DELETE CASCADE ON UPDATE CASCADE
1305) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1306/*!40101 SET character_set_client = @saved_cs_client */;
1307
1308--
1309-- Dumping data for table `namedqueries`
1310--
1311
1312LOCK TABLES `namedqueries` WRITE;
1313/*!40000 ALTER TABLE `namedqueries` DISABLE KEYS */;
1314/*!40000 ALTER TABLE `namedqueries` ENABLE KEYS */;
1315UNLOCK TABLES;
1316
1317--
1318-- Table structure for table `namedqueries_link_in_footer`
1319--
1320
1321DROP TABLE IF EXISTS `namedqueries_link_in_footer`;
1322/*!40101 SET @saved_cs_client     = @@character_set_client */;
1323/*!40101 SET character_set_client = utf8 */;
1324CREATE TABLE `namedqueries_link_in_footer` (
1325  `namedquery_id` mediumint(9) NOT NULL,
1326  `user_id` mediumint(9) NOT NULL,
1327  UNIQUE KEY `namedqueries_link_in_footer_id_idx` (`namedquery_id`,`user_id`),
1328  KEY `namedqueries_link_in_footer_userid_idx` (`user_id`),
1329  CONSTRAINT `fk_namedqueries_link_in_footer_namedquery_id_namedqueries_id` FOREIGN KEY (`namedquery_id`) REFERENCES `namedqueries` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
1330  CONSTRAINT `fk_namedqueries_link_in_footer_user_id_profiles_userid` FOREIGN KEY (`user_id`) REFERENCES `profiles` (`userid`) ON DELETE CASCADE ON UPDATE CASCADE
1331) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1332/*!40101 SET character_set_client = @saved_cs_client */;
1333
1334--
1335-- Dumping data for table `namedqueries_link_in_footer`
1336--
1337
1338LOCK TABLES `namedqueries_link_in_footer` WRITE;
1339/*!40000 ALTER TABLE `namedqueries_link_in_footer` DISABLE KEYS */;
1340/*!40000 ALTER TABLE `namedqueries_link_in_footer` ENABLE KEYS */;
1341UNLOCK TABLES;
1342
1343--
1344-- Table structure for table `namedquery_group_map`
1345--
1346
1347DROP TABLE IF EXISTS `namedquery_group_map`;
1348/*!40101 SET @saved_cs_client     = @@character_set_client */;
1349/*!40101 SET character_set_client = utf8 */;
1350CREATE TABLE `namedquery_group_map` (
1351  `namedquery_id` mediumint(9) NOT NULL,
1352  `group_id` mediumint(9) NOT NULL,
1353  UNIQUE KEY `namedquery_group_map_namedquery_id_idx` (`namedquery_id`),
1354  KEY `namedquery_group_map_group_id_idx` (`group_id`),
1355  CONSTRAINT `fk_namedquery_group_map_group_id_groups_id` FOREIGN KEY (`group_id`) REFERENCES `groups` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
1356  CONSTRAINT `fk_namedquery_group_map_namedquery_id_namedqueries_id` FOREIGN KEY (`namedquery_id`) REFERENCES `namedqueries` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
1357) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1358/*!40101 SET character_set_client = @saved_cs_client */;
1359
1360--
1361-- Dumping data for table `namedquery_group_map`
1362--
1363
1364LOCK TABLES `namedquery_group_map` WRITE;
1365/*!40000 ALTER TABLE `namedquery_group_map` DISABLE KEYS */;
1366/*!40000 ALTER TABLE `namedquery_group_map` ENABLE KEYS */;
1367UNLOCK TABLES;
1368
1369--
1370-- Table structure for table `op_sys`
1371--
1372
1373DROP TABLE IF EXISTS `op_sys`;
1374/*!40101 SET @saved_cs_client     = @@character_set_client */;
1375/*!40101 SET character_set_client = utf8 */;
1376CREATE TABLE `op_sys` (
1377  `id` smallint(6) NOT NULL AUTO_INCREMENT,
1378  `value` varchar(64) NOT NULL,
1379  `sortkey` smallint(6) NOT NULL DEFAULT '0',
1380  `isactive` tinyint(4) NOT NULL DEFAULT '1',
1381  `visibility_value_id` smallint(6) DEFAULT NULL,
1382  PRIMARY KEY (`id`),
1383  UNIQUE KEY `op_sys_value_idx` (`value`),
1384  KEY `op_sys_sortkey_idx` (`sortkey`,`value`),
1385  KEY `op_sys_visibility_value_id_idx` (`visibility_value_id`)
1386) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
1387/*!40101 SET character_set_client = @saved_cs_client */;
1388
1389--
1390-- Dumping data for table `op_sys`
1391--
1392
1393LOCK TABLES `op_sys` WRITE;
1394/*!40000 ALTER TABLE `op_sys` DISABLE KEYS */;
1395INSERT INTO `op_sys` VALUES (1,'All',100,1,NULL),(2,'Windows',200,1,NULL),(3,'Mac OS',300,1,NULL),(4,'Linux',400,1,NULL),(5,'Other',500,1,NULL);
1396/*!40000 ALTER TABLE `op_sys` ENABLE KEYS */;
1397UNLOCK TABLES;
1398
1399--
1400-- Table structure for table `priority`
1401--
1402
1403DROP TABLE IF EXISTS `priority`;
1404/*!40101 SET @saved_cs_client     = @@character_set_client */;
1405/*!40101 SET character_set_client = utf8 */;
1406CREATE TABLE `priority` (
1407  `id` smallint(6) NOT NULL AUTO_INCREMENT,
1408  `value` varchar(64) NOT NULL,
1409  `sortkey` smallint(6) NOT NULL DEFAULT '0',
1410  `isactive` tinyint(4) NOT NULL DEFAULT '1',
1411  `visibility_value_id` smallint(6) DEFAULT NULL,
1412  PRIMARY KEY (`id`),
1413  UNIQUE KEY `priority_value_idx` (`value`),
1414  KEY `priority_sortkey_idx` (`sortkey`,`value`),
1415  KEY `priority_visibility_value_id_idx` (`visibility_value_id`)
1416) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
1417/*!40101 SET character_set_client = @saved_cs_client */;
1418
1419--
1420-- Dumping data for table `priority`
1421--
1422
1423LOCK TABLES `priority` WRITE;
1424/*!40000 ALTER TABLE `priority` DISABLE KEYS */;
1425INSERT INTO `priority` VALUES (1,'Highest',100,1,NULL),(2,'High',200,1,NULL),(3,'Normal',300,1,NULL),(4,'Low',400,1,NULL),(5,'Lowest',500,1,NULL),(6,'---',600,1,NULL);
1426/*!40000 ALTER TABLE `priority` ENABLE KEYS */;
1427UNLOCK TABLES;
1428
1429--
1430-- Table structure for table `products`
1431--
1432
1433DROP TABLE IF EXISTS `products`;
1434/*!40101 SET @saved_cs_client     = @@character_set_client */;
1435/*!40101 SET character_set_client = utf8 */;
1436CREATE TABLE `products` (
1437  `id` smallint(6) NOT NULL AUTO_INCREMENT,
1438  `name` varchar(64) NOT NULL,
1439  `classification_id` smallint(6) NOT NULL DEFAULT '1',
1440  `description` mediumtext NOT NULL,
1441  `isactive` tinyint(4) NOT NULL DEFAULT '1',
1442  `defaultmilestone` varchar(64) NOT NULL DEFAULT '---',
1443  `allows_unconfirmed` tinyint(4) NOT NULL DEFAULT '1',
1444  PRIMARY KEY (`id`),
1445  UNIQUE KEY `products_name_idx` (`name`),
1446  KEY `fk_products_classification_id_classifications_id` (`classification_id`),
1447  CONSTRAINT `fk_products_classification_id_classifications_id` FOREIGN KEY (`classification_id`) REFERENCES `classifications` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
1448) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
1449/*!40101 SET character_set_client = @saved_cs_client */;
1450
1451--
1452-- Dumping data for table `products`
1453--
1454
1455LOCK TABLES `products` WRITE;
1456/*!40000 ALTER TABLE `products` DISABLE KEYS */;
1457INSERT INTO `products` VALUES (1,'TestProduct',1,'This is a test product. This ought to be blown away and replaced with real stuff in a finished installation of bugzilla.',1,'---',1);
1458/*!40000 ALTER TABLE `products` ENABLE KEYS */;
1459UNLOCK TABLES;
1460
1461--
1462-- Table structure for table `profile_search`
1463--
1464
1465DROP TABLE IF EXISTS `profile_search`;
1466/*!40101 SET @saved_cs_client     = @@character_set_client */;
1467/*!40101 SET character_set_client = utf8 */;
1468CREATE TABLE `profile_search` (
1469  `id` int(11) NOT NULL AUTO_INCREMENT,
1470  `user_id` mediumint(9) NOT NULL,
1471  `bug_list` mediumtext NOT NULL,
1472  `list_order` mediumtext,
1473  PRIMARY KEY (`id`),
1474  KEY `profile_search_user_id_idx` (`user_id`),
1475  CONSTRAINT `fk_profile_search_user_id_profiles_userid` FOREIGN KEY (`user_id`) REFERENCES `profiles` (`userid`) ON DELETE CASCADE ON UPDATE CASCADE
1476) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8;
1477/*!40101 SET character_set_client = @saved_cs_client */;
1478
1479--
1480-- Dumping data for table `profile_search`
1481--
1482
1483LOCK TABLES `profile_search` WRITE;
1484/*!40000 ALTER TABLE `profile_search` DISABLE KEYS */;
1485INSERT INTO `profile_search` VALUES (13,1,'8','bug_status,priority,assigned_to,bug_id'),(14,1,'',NULL),(15,1,'',NULL),(16,1,'8,9,10','bug_status,priority,assigned_to,bug_id'),(17,1,'',NULL),(18,1,'1,3,4,8,9,2,6,7','bug_status,priority,assigned_to,bug_id'),(19,1,'8','bug_status,priority,assigned_to,bug_id'),(20,1,'5,4,8,6','bug_status,priority,assigned_to,bug_id'),(21,1,'',NULL),(22,1,'1,5,3,4,8,9,10,2,6,7','bug_status,priority,assigned_to,bug_id');
1486/*!40000 ALTER TABLE `profile_search` ENABLE KEYS */;
1487UNLOCK TABLES;
1488
1489--
1490-- Table structure for table `profile_setting`
1491--
1492
1493DROP TABLE IF EXISTS `profile_setting`;
1494/*!40101 SET @saved_cs_client     = @@character_set_client */;
1495/*!40101 SET character_set_client = utf8 */;
1496CREATE TABLE `profile_setting` (
1497  `user_id` mediumint(9) NOT NULL,
1498  `setting_name` varchar(32) NOT NULL,
1499  `setting_value` varchar(32) NOT NULL,
1500  UNIQUE KEY `profile_setting_value_unique_idx` (`user_id`,`setting_name`),
1501  KEY `fk_profile_setting_setting_name_setting_name` (`setting_name`),
1502  CONSTRAINT `fk_profile_setting_setting_name_setting_name` FOREIGN KEY (`setting_name`) REFERENCES `setting` (`name`) ON DELETE CASCADE ON UPDATE CASCADE,
1503  CONSTRAINT `fk_profile_setting_user_id_profiles_userid` FOREIGN KEY (`user_id`) REFERENCES `profiles` (`userid`) ON DELETE CASCADE ON UPDATE CASCADE
1504) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1505/*!40101 SET character_set_client = @saved_cs_client */;
1506
1507--
1508-- Dumping data for table `profile_setting`
1509--
1510
1511LOCK TABLES `profile_setting` WRITE;
1512/*!40000 ALTER TABLE `profile_setting` DISABLE KEYS */;
1513/*!40000 ALTER TABLE `profile_setting` ENABLE KEYS */;
1514UNLOCK TABLES;
1515
1516--
1517-- Table structure for table `profiles`
1518--
1519
1520DROP TABLE IF EXISTS `profiles`;
1521/*!40101 SET @saved_cs_client     = @@character_set_client */;
1522/*!40101 SET character_set_client = utf8 */;
1523CREATE TABLE `profiles` (
1524  `userid` mediumint(9) NOT NULL AUTO_INCREMENT,
1525  `login_name` varchar(255) NOT NULL,
1526  `cryptpassword` varchar(128) DEFAULT NULL,
1527  `realname` varchar(255) NOT NULL DEFAULT '',
1528  `disabledtext` mediumtext NOT NULL,
1529  `disable_mail` tinyint(4) NOT NULL DEFAULT '0',
1530  `mybugslink` tinyint(4) NOT NULL DEFAULT '1',
1531  `extern_id` varchar(64) DEFAULT NULL,
1532  `is_enabled` tinyint(4) NOT NULL DEFAULT '1',
1533  `last_seen_date` datetime DEFAULT NULL,
1534  PRIMARY KEY (`userid`),
1535  UNIQUE KEY `profiles_login_name_idx` (`login_name`),
1536  UNIQUE KEY `profiles_extern_id_idx` (`extern_id`)
1537) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
1538/*!40101 SET character_set_client = @saved_cs_client */;
1539
1540--
1541-- Dumping data for table `profiles`
1542--
1543
1544LOCK TABLES `profiles` WRITE;
1545/*!40000 ALTER TABLE `profiles` DISABLE KEYS */;
1546INSERT INTO `profiles` VALUES (1,'ivandermenji97@gmail.com','WEhZ5WV3,cylZhx5AZ/fzNI2b4bUIPt2Xg/S1mUseTgiWCfnYNkU{SHA-256}','Ivan','',0,1,NULL,1,'2018-05-02 00:00:00');
1547/*!40000 ALTER TABLE `profiles` ENABLE KEYS */;
1548UNLOCK TABLES;
1549
1550--
1551-- Table structure for table `profiles_activity`
1552--
1553
1554DROP TABLE IF EXISTS `profiles_activity`;
1555/*!40101 SET @saved_cs_client     = @@character_set_client */;
1556/*!40101 SET character_set_client = utf8 */;
1557CREATE TABLE `profiles_activity` (
1558  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
1559  `userid` mediumint(9) NOT NULL,
1560  `who` mediumint(9) NOT NULL,
1561  `profiles_when` datetime NOT NULL,
1562  `fieldid` mediumint(9) NOT NULL,
1563  `oldvalue` tinytext,
1564  `newvalue` tinytext,
1565  PRIMARY KEY (`id`),
1566  KEY `profiles_activity_userid_idx` (`userid`),
1567  KEY `profiles_activity_profiles_when_idx` (`profiles_when`),
1568  KEY `profiles_activity_fieldid_idx` (`fieldid`),
1569  KEY `fk_profiles_activity_who_profiles_userid` (`who`),
1570  CONSTRAINT `fk_profiles_activity_fieldid_fielddefs_id` FOREIGN KEY (`fieldid`) REFERENCES `fielddefs` (`id`) ON UPDATE CASCADE,
1571  CONSTRAINT `fk_profiles_activity_userid_profiles_userid` FOREIGN KEY (`userid`) REFERENCES `profiles` (`userid`) ON DELETE CASCADE ON UPDATE CASCADE,
1572  CONSTRAINT `fk_profiles_activity_who_profiles_userid` FOREIGN KEY (`who`) REFERENCES `profiles` (`userid`) ON UPDATE CASCADE
1573) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
1574/*!40101 SET character_set_client = @saved_cs_client */;
1575
1576--
1577-- Dumping data for table `profiles_activity`
1578--
1579
1580LOCK TABLES `profiles_activity` WRITE;
1581/*!40000 ALTER TABLE `profiles_activity` DISABLE KEYS */;
1582INSERT INTO `profiles_activity` VALUES (1,1,1,'2018-04-10 16:32:11',33,NULL,'2018-04-10 16:32:11');
1583/*!40000 ALTER TABLE `profiles_activity` ENABLE KEYS */;
1584UNLOCK TABLES;
1585
1586--
1587-- Table structure for table `quips`
1588--
1589
1590DROP TABLE IF EXISTS `quips`;
1591/*!40101 SET @saved_cs_client     = @@character_set_client */;
1592/*!40101 SET character_set_client = utf8 */;
1593CREATE TABLE `quips` (
1594  `quipid` mediumint(9) NOT NULL AUTO_INCREMENT,
1595  `userid` mediumint(9) DEFAULT NULL,
1596  `quip` varchar(512) NOT NULL,
1597  `approved` tinyint(4) NOT NULL DEFAULT '1',
1598  PRIMARY KEY (`quipid`),
1599  KEY `fk_quips_userid_profiles_userid` (`userid`),
1600  CONSTRAINT `fk_quips_userid_profiles_userid` FOREIGN KEY (`userid`) REFERENCES `profiles` (`userid`) ON DELETE SET NULL ON UPDATE CASCADE
1601) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1602/*!40101 SET character_set_client = @saved_cs_client */;
1603
1604--
1605-- Dumping data for table `quips`
1606--
1607
1608LOCK TABLES `quips` WRITE;
1609/*!40000 ALTER TABLE `quips` DISABLE KEYS */;
1610/*!40000 ALTER TABLE `quips` ENABLE KEYS */;
1611UNLOCK TABLES;
1612
1613--
1614-- Table structure for table `rep_platform`
1615--
1616
1617DROP TABLE IF EXISTS `rep_platform`;
1618/*!40101 SET @saved_cs_client     = @@character_set_client */;
1619/*!40101 SET character_set_client = utf8 */;
1620CREATE TABLE `rep_platform` (
1621  `id` smallint(6) NOT NULL AUTO_INCREMENT,
1622  `value` varchar(64) NOT NULL,
1623  `sortkey` smallint(6) NOT NULL DEFAULT '0',
1624  `isactive` tinyint(4) NOT NULL DEFAULT '1',
1625  `visibility_value_id` smallint(6) DEFAULT NULL,
1626  PRIMARY KEY (`id`),
1627  UNIQUE KEY `rep_platform_value_idx` (`value`),
1628  KEY `rep_platform_sortkey_idx` (`sortkey`,`value`),
1629  KEY `rep_platform_visibility_value_id_idx` (`visibility_value_id`)
1630) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
1631/*!40101 SET character_set_client = @saved_cs_client */;
1632
1633--
1634-- Dumping data for table `rep_platform`
1635--
1636
1637LOCK TABLES `rep_platform` WRITE;
1638/*!40000 ALTER TABLE `rep_platform` DISABLE KEYS */;
1639INSERT INTO `rep_platform` VALUES (1,'All',100,1,NULL),(2,'PC',200,1,NULL),(3,'Macintosh',300,1,NULL),(4,'Other',400,1,NULL);
1640/*!40000 ALTER TABLE `rep_platform` ENABLE KEYS */;
1641UNLOCK TABLES;
1642
1643--
1644-- Table structure for table `reports`
1645--
1646
1647DROP TABLE IF EXISTS `reports`;
1648/*!40101 SET @saved_cs_client     = @@character_set_client */;
1649/*!40101 SET character_set_client = utf8 */;
1650CREATE TABLE `reports` (
1651  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
1652  `user_id` mediumint(9) NOT NULL,
1653  `name` varchar(64) NOT NULL,
1654  `query` mediumtext NOT NULL,
1655  PRIMARY KEY (`id`),
1656  UNIQUE KEY `reports_user_id_idx` (`user_id`,`name`),
1657  CONSTRAINT `fk_reports_user_id_profiles_userid` FOREIGN KEY (`user_id`) REFERENCES `profiles` (`userid`) ON DELETE CASCADE ON UPDATE CASCADE
1658) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1659/*!40101 SET character_set_client = @saved_cs_client */;
1660
1661--
1662-- Dumping data for table `reports`
1663--
1664
1665LOCK TABLES `reports` WRITE;
1666/*!40000 ALTER TABLE `reports` DISABLE KEYS */;
1667/*!40000 ALTER TABLE `reports` ENABLE KEYS */;
1668UNLOCK TABLES;
1669
1670--
1671-- Table structure for table `resolution`
1672--
1673
1674DROP TABLE IF EXISTS `resolution`;
1675/*!40101 SET @saved_cs_client     = @@character_set_client */;
1676/*!40101 SET character_set_client = utf8 */;
1677CREATE TABLE `resolution` (
1678  `id` smallint(6) NOT NULL AUTO_INCREMENT,
1679  `value` varchar(64) NOT NULL,
1680  `sortkey` smallint(6) NOT NULL DEFAULT '0',
1681  `isactive` tinyint(4) NOT NULL DEFAULT '1',
1682  `visibility_value_id` smallint(6) DEFAULT NULL,
1683  PRIMARY KEY (`id`),
1684  UNIQUE KEY `resolution_value_idx` (`value`),
1685  KEY `resolution_sortkey_idx` (`sortkey`,`value`),
1686  KEY `resolution_visibility_value_id_idx` (`visibility_value_id`)
1687) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
1688/*!40101 SET character_set_client = @saved_cs_client */;
1689
1690--
1691-- Dumping data for table `resolution`
1692--
1693
1694LOCK TABLES `resolution` WRITE;
1695/*!40000 ALTER TABLE `resolution` DISABLE KEYS */;
1696INSERT INTO `resolution` VALUES (1,'',100,1,NULL),(2,'FIXED',200,1,NULL),(3,'INVALID',300,1,NULL),(4,'WONTFIX',400,1,NULL),(5,'DUPLICATE',500,1,NULL),(6,'WORKSFORME',600,1,NULL);
1697/*!40000 ALTER TABLE `resolution` ENABLE KEYS */;
1698UNLOCK TABLES;
1699
1700--
1701-- Table structure for table `series`
1702--
1703
1704DROP TABLE IF EXISTS `series`;
1705/*!40101 SET @saved_cs_client     = @@character_set_client */;
1706/*!40101 SET character_set_client = utf8 */;
1707CREATE TABLE `series` (
1708  `series_id` mediumint(9) NOT NULL AUTO_INCREMENT,
1709  `creator` mediumint(9) DEFAULT NULL,
1710  `category` smallint(6) NOT NULL,
1711  `subcategory` smallint(6) NOT NULL,
1712  `name` varchar(64) NOT NULL,
1713  `frequency` smallint(6) NOT NULL,
1714  `query` mediumtext NOT NULL,
1715  `is_public` tinyint(4) NOT NULL DEFAULT '0',
1716  PRIMARY KEY (`series_id`),
1717  UNIQUE KEY `series_category_idx` (`category`,`subcategory`,`name`),
1718  KEY `series_creator_idx` (`creator`),
1719  KEY `fk_series_subcategory_series_categories_id` (`subcategory`),
1720  CONSTRAINT `fk_series_category_series_categories_id` FOREIGN KEY (`category`) REFERENCES `series_categories` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
1721  CONSTRAINT `fk_series_creator_profiles_userid` FOREIGN KEY (`creator`) REFERENCES `profiles` (`userid`) ON DELETE CASCADE ON UPDATE CASCADE,
1722  CONSTRAINT `fk_series_subcategory_series_categories_id` FOREIGN KEY (`subcategory`) REFERENCES `series_categories` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
1723) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1724/*!40101 SET character_set_client = @saved_cs_client */;
1725
1726--
1727-- Dumping data for table `series`
1728--
1729
1730LOCK TABLES `series` WRITE;
1731/*!40000 ALTER TABLE `series` DISABLE KEYS */;
1732/*!40000 ALTER TABLE `series` ENABLE KEYS */;
1733UNLOCK TABLES;
1734
1735--
1736-- Table structure for table `series_categories`
1737--
1738
1739DROP TABLE IF EXISTS `series_categories`;
1740/*!40101 SET @saved_cs_client     = @@character_set_client */;
1741/*!40101 SET character_set_client = utf8 */;
1742CREATE TABLE `series_categories` (
1743  `id` smallint(6) NOT NULL AUTO_INCREMENT,
1744  `name` varchar(64) NOT NULL,
1745  PRIMARY KEY (`id`),
1746  UNIQUE KEY `series_categories_name_idx` (`name`)
1747) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1748/*!40101 SET character_set_client = @saved_cs_client */;
1749
1750--
1751-- Dumping data for table `series_categories`
1752--
1753
1754LOCK TABLES `series_categories` WRITE;
1755/*!40000 ALTER TABLE `series_categories` DISABLE KEYS */;
1756/*!40000 ALTER TABLE `series_categories` ENABLE KEYS */;
1757UNLOCK TABLES;
1758
1759--
1760-- Table structure for table `series_data`
1761--
1762
1763DROP TABLE IF EXISTS `series_data`;
1764/*!40101 SET @saved_cs_client     = @@character_set_client */;
1765/*!40101 SET character_set_client = utf8 */;
1766CREATE TABLE `series_data` (
1767  `series_id` mediumint(9) NOT NULL,
1768  `series_date` datetime NOT NULL,
1769  `series_value` mediumint(9) NOT NULL,
1770  UNIQUE KEY `series_data_series_id_idx` (`series_id`,`series_date`),
1771  CONSTRAINT `fk_series_data_series_id_series_series_id` FOREIGN KEY (`series_id`) REFERENCES `series` (`series_id`) ON DELETE CASCADE ON UPDATE CASCADE
1772) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1773/*!40101 SET character_set_client = @saved_cs_client */;
1774
1775--
1776-- Dumping data for table `series_data`
1777--
1778
1779LOCK TABLES `series_data` WRITE;
1780/*!40000 ALTER TABLE `series_data` DISABLE KEYS */;
1781/*!40000 ALTER TABLE `series_data` ENABLE KEYS */;
1782UNLOCK TABLES;
1783
1784--
1785-- Table structure for table `setting`
1786--
1787
1788DROP TABLE IF EXISTS `setting`;
1789/*!40101 SET @saved_cs_client     = @@character_set_client */;
1790/*!40101 SET character_set_client = utf8 */;
1791CREATE TABLE `setting` (
1792  `name` varchar(32) NOT NULL,
1793  `default_value` varchar(32) NOT NULL,
1794  `is_enabled` tinyint(4) NOT NULL DEFAULT '1',
1795  `subclass` varchar(32) DEFAULT NULL,
1796  PRIMARY KEY (`name`)
1797) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1798/*!40101 SET character_set_client = @saved_cs_client */;
1799
1800--
1801-- Dumping data for table `setting`
1802--
1803
1804LOCK TABLES `setting` WRITE;
1805/*!40000 ALTER TABLE `setting` DISABLE KEYS */;
1806INSERT INTO `setting` VALUES ('bugmail_new_prefix','on',1,NULL),('comment_box_position','before_comments',1,NULL),('comment_sort_order','oldest_to_newest',1,NULL),('csv_colsepchar',',',1,NULL),('display_quips','on',1,NULL),('email_format','html',1,NULL),('lang','en',1,'Lang'),('possible_duplicates','on',1,NULL),('post_bug_submit_action','next_bug',1,NULL),('quicksearch_fulltext','on',1,NULL),('quote_replies','quoted_reply',1,NULL),('requestee_cc','on',1,NULL),('skin','Dusk',1,'Skin'),('state_addselfcc','cc_unless_role',1,NULL),('timezone','local',1,'Timezone'),('zoom_textareas','on',1,NULL);
1807/*!40000 ALTER TABLE `setting` ENABLE KEYS */;
1808UNLOCK TABLES;
1809
1810--
1811-- Table structure for table `setting_value`
1812--
1813
1814DROP TABLE IF EXISTS `setting_value`;
1815/*!40101 SET @saved_cs_client     = @@character_set_client */;
1816/*!40101 SET character_set_client = utf8 */;
1817CREATE TABLE `setting_value` (
1818  `name` varchar(32) NOT NULL,
1819  `value` varchar(32) NOT NULL,
1820  `sortindex` smallint(6) NOT NULL,
1821  UNIQUE KEY `setting_value_nv_unique_idx` (`name`,`value`),
1822  UNIQUE KEY `setting_value_ns_unique_idx` (`name`,`sortindex`),
1823  CONSTRAINT `fk_setting_value_name_setting_name` FOREIGN KEY (`name`) REFERENCES `setting` (`name`) ON DELETE CASCADE ON UPDATE CASCADE
1824) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1825/*!40101 SET character_set_client = @saved_cs_client */;
1826
1827--
1828-- Dumping data for table `setting_value`
1829--
1830
1831LOCK TABLES `setting_value` WRITE;
1832/*!40000 ALTER TABLE `setting_value` DISABLE KEYS */;
1833INSERT INTO `setting_value` VALUES ('bugmail_new_prefix','on',5),('bugmail_new_prefix','off',10),('comment_box_position','before_comments',5),('comment_box_position','after_comments',10),('comment_sort_order','oldest_to_newest',5),('comment_sort_order','newest_to_oldest',10),('comment_sort_order','newest_to_oldest_desc_first',15),('csv_colsepchar',',',5),('csv_colsepchar',';',10),('display_quips','on',5),('display_quips','off',10),('email_format','html',5),('email_format','text_only',10),('possible_duplicates','on',5),('possible_duplicates','off',10),('post_bug_submit_action','next_bug',5),('post_bug_submit_action','same_bug',10),('post_bug_submit_action','nothing',15),('quicksearch_fulltext','on',5),('quicksearch_fulltext','off',10),('quote_replies','quoted_reply',5),('quote_replies','simple_reply',10),('quote_replies','off',15),('requestee_cc','on',5),('requestee_cc','off',10),('state_addselfcc','always',5),('state_addselfcc','never',10),('state_addselfcc','cc_unless_role',15),('zoom_textareas','on',5),('zoom_textareas','off',10);
1834/*!40000 ALTER TABLE `setting_value` ENABLE KEYS */;
1835UNLOCK TABLES;
1836
1837--
1838-- Table structure for table `status_workflow`
1839--
1840
1841DROP TABLE IF EXISTS `status_workflow`;
1842/*!40101 SET @saved_cs_client     = @@character_set_client */;
1843/*!40101 SET character_set_client = utf8 */;
1844CREATE TABLE `status_workflow` (
1845  `old_status` smallint(6) DEFAULT NULL,
1846  `new_status` smallint(6) NOT NULL,
1847  `require_comment` tinyint(4) NOT NULL DEFAULT '0',
1848  UNIQUE KEY `status_workflow_idx` (`old_status`,`new_status`),
1849  KEY `fk_status_workflow_new_status_bug_status_id` (`new_status`),
1850  CONSTRAINT `fk_status_workflow_new_status_bug_status_id` FOREIGN KEY (`new_status`) REFERENCES `bug_status` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
1851  CONSTRAINT `fk_status_workflow_old_status_bug_status_id` FOREIGN KEY (`old_status`) REFERENCES `bug_status` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
1852) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1853/*!40101 SET character_set_client = @saved_cs_client */;
1854
1855--
1856-- Dumping data for table `status_workflow`
1857--
1858
1859LOCK TABLES `status_workflow` WRITE;
1860/*!40000 ALTER TABLE `status_workflow` DISABLE KEYS */;
1861INSERT INTO `status_workflow` VALUES (NULL,1,0),(NULL,2,0),(NULL,3,0),(1,2,0),(1,3,0),(1,4,0),(2,3,0),(2,4,0),(3,2,0),(3,4,0),(4,1,0),(4,2,0),(4,5,0),(5,1,0),(5,2,0);
1862/*!40000 ALTER TABLE `status_workflow` ENABLE KEYS */;
1863UNLOCK TABLES;
1864
1865--
1866-- Table structure for table `tag`
1867--
1868
1869DROP TABLE IF EXISTS `tag`;
1870/*!40101 SET @saved_cs_client     = @@character_set_client */;
1871/*!40101 SET character_set_client = utf8 */;
1872CREATE TABLE `tag` (
1873  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
1874  `name` varchar(64) NOT NULL,
1875  `user_id` mediumint(9) NOT NULL,
1876  PRIMARY KEY (`id`),
1877  UNIQUE KEY `tag_user_id_idx` (`user_id`,`name`),
1878  CONSTRAINT `fk_tag_user_id_profiles_userid` FOREIGN KEY (`user_id`) REFERENCES `profiles` (`userid`) ON DELETE CASCADE ON UPDATE CASCADE
1879) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1880/*!40101 SET character_set_client = @saved_cs_client */;
1881
1882--
1883-- Dumping data for table `tag`
1884--
1885
1886LOCK TABLES `tag` WRITE;
1887/*!40000 ALTER TABLE `tag` DISABLE KEYS */;
1888/*!40000 ALTER TABLE `tag` ENABLE KEYS */;
1889UNLOCK TABLES;
1890
1891--
1892-- Table structure for table `tokens`
1893--
1894
1895DROP TABLE IF EXISTS `tokens`;
1896/*!40101 SET @saved_cs_client     = @@character_set_client */;
1897/*!40101 SET character_set_client = utf8 */;
1898CREATE TABLE `tokens` (
1899  `userid` mediumint(9) DEFAULT NULL,
1900  `issuedate` datetime NOT NULL,
1901  `token` varchar(16) NOT NULL,
1902  `tokentype` varchar(16) NOT NULL,
1903  `eventdata` tinytext,
1904  PRIMARY KEY (`token`),
1905  KEY `tokens_userid_idx` (`userid`),
1906  CONSTRAINT `fk_tokens_userid_profiles_userid` FOREIGN KEY (`userid`) REFERENCES `profiles` (`userid`) ON DELETE CASCADE ON UPDATE CASCADE
1907) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1908/*!40101 SET character_set_client = @saved_cs_client */;
1909
1910--
1911-- Dumping data for table `tokens`
1912--
1913
1914LOCK TABLES `tokens` WRITE;
1915/*!40000 ALTER TABLE `tokens` DISABLE KEYS */;
1916INSERT INTO `tokens` VALUES (1,'2018-04-10 19:19:45','8MIfLqIOhs','session','edit_parameters'),(1,'2018-04-10 19:14:06','jLdp6dIxM3','session','create_bug'),(1,'2018-05-02 08:29:13','mxuLPhFo2X','api_token',''),(1,'2018-05-02 08:29:13','PCO16lYC1d','api_token',''),(1,'2018-04-10 16:34:21','PQITtkUnRn','api_token',''),(1,'2018-04-10 19:20:57','rG5qI0l6zk','session','edit_parameters'),(1,'2018-04-10 19:09:36','tqHVFkokaR','session','create_bug');
1917/*!40000 ALTER TABLE `tokens` ENABLE KEYS */;
1918UNLOCK TABLES;
1919
1920--
1921-- Table structure for table `ts_error`
1922--
1923
1924DROP TABLE IF EXISTS `ts_error`;
1925/*!40101 SET @saved_cs_client     = @@character_set_client */;
1926/*!40101 SET character_set_client = utf8 */;
1927CREATE TABLE `ts_error` (
1928  `error_time` int(11) NOT NULL,
1929  `jobid` int(11) NOT NULL,
1930  `message` varchar(255) NOT NULL,
1931  `funcid` int(11) NOT NULL DEFAULT '0',
1932  KEY `ts_error_funcid_idx` (`funcid`,`error_time`),
1933  KEY `ts_error_error_time_idx` (`error_time`),
1934  KEY `ts_error_jobid_idx` (`jobid`)
1935) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1936/*!40101 SET character_set_client = @saved_cs_client */;
1937
1938--
1939-- Dumping data for table `ts_error`
1940--
1941
1942LOCK TABLES `ts_error` WRITE;
1943/*!40000 ALTER TABLE `ts_error` DISABLE KEYS */;
1944/*!40000 ALTER TABLE `ts_error` ENABLE KEYS */;
1945UNLOCK TABLES;
1946
1947--
1948-- Table structure for table `ts_exitstatus`
1949--
1950
1951DROP TABLE IF EXISTS `ts_exitstatus`;
1952/*!40101 SET @saved_cs_client     = @@character_set_client */;
1953/*!40101 SET character_set_client = utf8 */;
1954CREATE TABLE `ts_exitstatus` (
1955  `jobid` int(11) NOT NULL AUTO_INCREMENT,
1956  `funcid` int(11) NOT NULL DEFAULT '0',
1957  `status` smallint(6) DEFAULT NULL,
1958  `completion_time` int(11) DEFAULT NULL,
1959  `delete_after` int(11) DEFAULT NULL,
1960  PRIMARY KEY (`jobid`),
1961  KEY `ts_exitstatus_funcid_idx` (`funcid`),
1962  KEY `ts_exitstatus_delete_after_idx` (`delete_after`)
1963) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1964/*!40101 SET character_set_client = @saved_cs_client */;
1965
1966--
1967-- Dumping data for table `ts_exitstatus`
1968--
1969
1970LOCK TABLES `ts_exitstatus` WRITE;
1971/*!40000 ALTER TABLE `ts_exitstatus` DISABLE KEYS */;
1972/*!40000 ALTER TABLE `ts_exitstatus` ENABLE KEYS */;
1973UNLOCK TABLES;
1974
1975--
1976-- Table structure for table `ts_funcmap`
1977--
1978
1979DROP TABLE IF EXISTS `ts_funcmap`;
1980/*!40101 SET @saved_cs_client     = @@character_set_client */;
1981/*!40101 SET character_set_client = utf8 */;
1982CREATE TABLE `ts_funcmap` (
1983  `funcid` int(11) NOT NULL AUTO_INCREMENT,
1984  `funcname` varchar(255) NOT NULL,
1985  PRIMARY KEY (`funcid`),
1986  UNIQUE KEY `ts_funcmap_funcname_idx` (`funcname`)
1987) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1988/*!40101 SET character_set_client = @saved_cs_client */;
1989
1990--
1991-- Dumping data for table `ts_funcmap`
1992--
1993
1994LOCK TABLES `ts_funcmap` WRITE;
1995/*!40000 ALTER TABLE `ts_funcmap` DISABLE KEYS */;
1996/*!40000 ALTER TABLE `ts_funcmap` ENABLE KEYS */;
1997UNLOCK TABLES;
1998
1999--
2000-- Table structure for table `ts_job`
2001--
2002
2003DROP TABLE IF EXISTS `ts_job`;
2004/*!40101 SET @saved_cs_client     = @@character_set_client */;
2005/*!40101 SET character_set_client = utf8 */;
2006CREATE TABLE `ts_job` (
2007  `jobid` int(11) NOT NULL AUTO_INCREMENT,
2008  `funcid` int(11) NOT NULL,
2009  `arg` longblob,
2010  `uniqkey` varchar(255) DEFAULT NULL,
2011  `insert_time` int(11) DEFAULT NULL,
2012  `run_after` int(11) NOT NULL,
2013  `grabbed_until` int(11) NOT NULL,
2014  `priority` smallint(6) DEFAULT NULL,
2015  `coalesce` varchar(255) DEFAULT NULL,
2016  PRIMARY KEY (`jobid`),
2017  UNIQUE KEY `ts_job_funcid_idx` (`funcid`,`uniqkey`),
2018  KEY `ts_job_run_after_idx` (`run_after`,`funcid`),
2019  KEY `ts_job_coalesce_idx` (`coalesce`,`funcid`)
2020) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2021/*!40101 SET character_set_client = @saved_cs_client */;
2022
2023--
2024-- Dumping data for table `ts_job`
2025--
2026
2027LOCK TABLES `ts_job` WRITE;
2028/*!40000 ALTER TABLE `ts_job` DISABLE KEYS */;
2029/*!40000 ALTER TABLE `ts_job` ENABLE KEYS */;
2030UNLOCK TABLES;
2031
2032--
2033-- Table structure for table `ts_note`
2034--
2035
2036DROP TABLE IF EXISTS `ts_note`;
2037/*!40101 SET @saved_cs_client     = @@character_set_client */;
2038/*!40101 SET character_set_client = utf8 */;
2039CREATE TABLE `ts_note` (
2040  `jobid` int(11) NOT NULL,
2041  `notekey` varchar(255) DEFAULT NULL,
2042  `value` longblob,
2043  UNIQUE KEY `ts_note_jobid_idx` (`jobid`,`notekey`)
2044) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2045/*!40101 SET character_set_client = @saved_cs_client */;
2046
2047--
2048-- Dumping data for table `ts_note`
2049--
2050
2051LOCK TABLES `ts_note` WRITE;
2052/*!40000 ALTER TABLE `ts_note` DISABLE KEYS */;
2053/*!40000 ALTER TABLE `ts_note` ENABLE KEYS */;
2054UNLOCK TABLES;
2055
2056--
2057-- Table structure for table `user_api_keys`
2058--
2059
2060DROP TABLE IF EXISTS `user_api_keys`;
2061/*!40101 SET @saved_cs_client     = @@character_set_client */;
2062/*!40101 SET character_set_client = utf8 */;
2063CREATE TABLE `user_api_keys` (
2064  `id` int(11) NOT NULL AUTO_INCREMENT,
2065  `user_id` mediumint(9) NOT NULL,
2066  `api_key` varchar(40) NOT NULL,
2067  `description` varchar(255) DEFAULT NULL,
2068  `revoked` tinyint(4) NOT NULL DEFAULT '0',
2069  `last_used` datetime DEFAULT NULL,
2070  PRIMARY KEY (`id`),
2071  UNIQUE KEY `user_api_keys_api_key_idx` (`api_key`),
2072  KEY `user_api_keys_user_id_idx` (`user_id`),
2073  CONSTRAINT `fk_user_api_keys_user_id_profiles_userid` FOREIGN KEY (`user_id`) REFERENCES `profiles` (`userid`) ON DELETE CASCADE ON UPDATE CASCADE
2074) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2075/*!40101 SET character_set_client = @saved_cs_client */;
2076
2077--
2078-- Dumping data for table `user_api_keys`
2079--
2080
2081LOCK TABLES `user_api_keys` WRITE;
2082/*!40000 ALTER TABLE `user_api_keys` DISABLE KEYS */;
2083/*!40000 ALTER TABLE `user_api_keys` ENABLE KEYS */;
2084UNLOCK TABLES;
2085
2086--
2087-- Table structure for table `user_group_map`
2088--
2089
2090DROP TABLE IF EXISTS `user_group_map`;
2091/*!40101 SET @saved_cs_client     = @@character_set_client */;
2092/*!40101 SET character_set_client = utf8 */;
2093CREATE TABLE `user_group_map` (
2094  `user_id` mediumint(9) NOT NULL,
2095  `group_id` mediumint(9) NOT NULL,
2096  `isbless` tinyint(4) NOT NULL DEFAULT '0',
2097  `grant_type` tinyint(4) NOT NULL DEFAULT '0',
2098  UNIQUE KEY `user_group_map_user_id_idx` (`user_id`,`group_id`,`grant_type`,`isbless`),
2099  KEY `fk_user_group_map_group_id_groups_id` (`group_id`),
2100  CONSTRAINT `fk_user_group_map_group_id_groups_id` FOREIGN KEY (`group_id`) REFERENCES `groups` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
2101  CONSTRAINT `fk_user_group_map_user_id_profiles_userid` FOREIGN KEY (`user_id`) REFERENCES `profiles` (`userid`) ON DELETE CASCADE ON UPDATE CASCADE
2102) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2103/*!40101 SET character_set_client = @saved_cs_client */;
2104
2105--
2106-- Dumping data for table `user_group_map`
2107--
2108
2109LOCK TABLES `user_group_map` WRITE;
2110/*!40000 ALTER TABLE `user_group_map` DISABLE KEYS */;
2111INSERT INTO `user_group_map` VALUES (1,1,0,0),(1,1,1,0),(1,3,0,0),(1,8,0,2);
2112/*!40000 ALTER TABLE `user_group_map` ENABLE KEYS */;
2113UNLOCK TABLES;
2114
2115--
2116-- Table structure for table `versions`
2117--
2118
2119DROP TABLE IF EXISTS `versions`;
2120/*!40101 SET @saved_cs_client     = @@character_set_client */;
2121/*!40101 SET character_set_client = utf8 */;
2122CREATE TABLE `versions` (
2123  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
2124  `value` varchar(64) NOT NULL,
2125  `product_id` smallint(6) NOT NULL,
2126  `isactive` tinyint(4) NOT NULL DEFAULT '1',
2127  PRIMARY KEY (`id`),
2128  UNIQUE KEY `versions_product_id_idx` (`product_id`,`value`),
2129  CONSTRAINT `fk_versions_product_id_products_id` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
2130) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
2131/*!40101 SET character_set_client = @saved_cs_client */;
2132
2133--
2134-- Dumping data for table `versions`
2135--
2136
2137LOCK TABLES `versions` WRITE;
2138/*!40000 ALTER TABLE `versions` DISABLE KEYS */;
2139INSERT INTO `versions` VALUES (1,'unspecified',1,1);
2140/*!40000 ALTER TABLE `versions` ENABLE KEYS */;
2141UNLOCK TABLES;
2142
2143--
2144-- Table structure for table `watch`
2145--
2146
2147DROP TABLE IF EXISTS `watch`;
2148/*!40101 SET @saved_cs_client     = @@character_set_client */;
2149/*!40101 SET character_set_client = utf8 */;
2150CREATE TABLE `watch` (
2151  `watcher` mediumint(9) NOT NULL,
2152  `watched` mediumint(9) NOT NULL,
2153  UNIQUE KEY `watch_watcher_idx` (`watcher`,`watched`),
2154  KEY `watch_watched_idx` (`watched`),
2155  CONSTRAINT `fk_watch_watched_profiles_userid` FOREIGN KEY (`watched`) REFERENCES `profiles` (`userid`) ON DELETE CASCADE ON UPDATE CASCADE,
2156  CONSTRAINT `fk_watch_watcher_profiles_userid` FOREIGN KEY (`watcher`) REFERENCES `profiles` (`userid`) ON DELETE CASCADE ON UPDATE CASCADE
2157) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2158/*!40101 SET character_set_client = @saved_cs_client */;
2159
2160--
2161-- Dumping data for table `watch`
2162--
2163
2164LOCK TABLES `watch` WRITE;
2165/*!40000 ALTER TABLE `watch` DISABLE KEYS */;
2166/*!40000 ALTER TABLE `watch` ENABLE KEYS */;
2167UNLOCK TABLES;
2168
2169--
2170-- Table structure for table `whine_events`
2171--
2172
2173DROP TABLE IF EXISTS `whine_events`;
2174/*!40101 SET @saved_cs_client     = @@character_set_client */;
2175/*!40101 SET character_set_client = utf8 */;
2176CREATE TABLE `whine_events` (
2177  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
2178  `owner_userid` mediumint(9) NOT NULL,
2179  `subject` varchar(128) DEFAULT NULL,
2180  `body` mediumtext,
2181  `mailifnobugs` tinyint(4) NOT NULL DEFAULT '0',
2182  PRIMARY KEY (`id`),
2183  KEY `fk_whine_events_owner_userid_profiles_userid` (`owner_userid`),
2184  CONSTRAINT `fk_whine_events_owner_userid_profiles_userid` FOREIGN KEY (`owner_userid`) REFERENCES `profiles` (`userid`) ON DELETE CASCADE ON UPDATE CASCADE
2185) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2186/*!40101 SET character_set_client = @saved_cs_client */;
2187
2188--
2189-- Dumping data for table `whine_events`
2190--
2191
2192LOCK TABLES `whine_events` WRITE;
2193/*!40000 ALTER TABLE `whine_events` DISABLE KEYS */;
2194/*!40000 ALTER TABLE `whine_events` ENABLE KEYS */;
2195UNLOCK TABLES;
2196
2197--
2198-- Table structure for table `whine_queries`
2199--
2200
2201DROP TABLE IF EXISTS `whine_queries`;
2202/*!40101 SET @saved_cs_client     = @@character_set_client */;
2203/*!40101 SET character_set_client = utf8 */;
2204CREATE TABLE `whine_queries` (
2205  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
2206  `eventid` mediumint(9) NOT NULL,
2207  `query_name` varchar(64) NOT NULL DEFAULT '',
2208  `sortkey` smallint(6) NOT NULL DEFAULT '0',
2209  `onemailperbug` tinyint(4) NOT NULL DEFAULT '0',
2210  `title` varchar(128) NOT NULL DEFAULT '',
2211  PRIMARY KEY (`id`),
2212  KEY `whine_queries_eventid_idx` (`eventid`),
2213  CONSTRAINT `fk_whine_queries_eventid_whine_events_id` FOREIGN KEY (`eventid`) REFERENCES `whine_events` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
2214) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2215/*!40101 SET character_set_client = @saved_cs_client */;
2216
2217--
2218-- Dumping data for table `whine_queries`
2219--
2220
2221LOCK TABLES `whine_queries` WRITE;
2222/*!40000 ALTER TABLE `whine_queries` DISABLE KEYS */;
2223/*!40000 ALTER TABLE `whine_queries` ENABLE KEYS */;
2224UNLOCK TABLES;
2225
2226--
2227-- Table structure for table `whine_schedules`
2228--
2229
2230DROP TABLE IF EXISTS `whine_schedules`;
2231/*!40101 SET @saved_cs_client     = @@character_set_client */;
2232/*!40101 SET character_set_client = utf8 */;
2233CREATE TABLE `whine_schedules` (
2234  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
2235  `eventid` mediumint(9) NOT NULL,
2236  `run_day` varchar(32) DEFAULT NULL,
2237  `run_time` varchar(32) DEFAULT NULL,
2238  `run_next` datetime DEFAULT NULL,
2239  `mailto` mediumint(9) NOT NULL,
2240  `mailto_type` smallint(6) NOT NULL DEFAULT '0',
2241  PRIMARY KEY (`id`),
2242  KEY `whine_schedules_run_next_idx` (`run_next`),
2243  KEY `whine_schedules_eventid_idx` (`eventid`),
2244  CONSTRAINT `fk_whine_schedules_eventid_whine_events_id` FOREIGN KEY (`eventid`) REFERENCES `whine_events` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
2245) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2246/*!40101 SET character_set_client = @saved_cs_client */;
2247
2248--
2249-- Dumping data for table `whine_schedules`
2250--
2251
2252LOCK TABLES `whine_schedules` WRITE;
2253/*!40000 ALTER TABLE `whine_schedules` DISABLE KEYS */;
2254/*!40000 ALTER TABLE `whine_schedules` ENABLE KEYS */;
2255UNLOCK TABLES;
2256/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
2257
2258/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
2259/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
2260/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
2261/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
2262/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
2263/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
2264/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
2265
2266-- Dump completed on 2018-05-02 10:35:22