/
db_generate.sql
144 lines (126 loc) · 5.05 KB
/
db_generate.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
# phpMyAdmin MySQL-Dump
# http://phpwizard.net/phpMyAdmin/
#
# --------------------------------------------------------
#
# Table structure for table 'mantis_bug_table'
#
CREATE TABLE mantis_bug_table (
id int(7) unsigned zerofill DEFAULT '0000000' NOT NULL auto_increment,
reporter_id int(7) unsigned zerofill DEFAULT '0000000' NOT NULL,
handler_id int(7) unsigned zerofill DEFAULT '0000000' NOT NULL,
duplicate_id int(7) unsigned zerofill DEFAULT '0000000' NOT NULL,
priority enum('immediate','urgent','high','normal','low','none') DEFAULT 'normal' NOT NULL,
severity enum('block','crash','major','minor','tweak','text','trivial','feature') DEFAULT 'minor' NOT NULL,
reproducibility enum('always','sometimes','random','have not tried','unable to duplicate') DEFAULT 'always' NOT NULL,
status enum('new','feedback','acknowledged','confirmed','assigned','resolved') DEFAULT 'new' NOT NULL,
resolution enum('open','fixed','reopened','unable to duplicate','not fixable','duplicate','not a bug','suspended') DEFAULT 'open' NOT NULL,
projection enum('redesign','major rework','minor fix','tweak') DEFAULT 'minor fix' NOT NULL,
category enum('bugtracker','other') DEFAULT 'other' NOT NULL,
date_submitted timestamp(14),
last_updated timestamp(14),
eta enum('none','< 1 day','2-3 days','< 1 week','< 1 month','> 1 month') DEFAULT 'none' NOT NULL,
bug_text_id mediumint(7) unsigned zerofill DEFAULT '0000000' NOT NULL,
os varchar(32) NOT NULL,
os_build varchar(16) NOT NULL,
platform varchar(32) NOT NULL,
version enum ('none') NOT NULL,
build tinyint(4) DEFAULT '0' NOT NULL,
votes tinyint(4) DEFAULT '0' NOT NULL,
summary varchar(128) NOT NULL,
PRIMARY KEY (id)
);
# --------------------------------------------------------
#
# Table structure for table 'mantis_bug_text_table'
#
CREATE TABLE mantis_bug_text_table (
id int(7) unsigned zerofill DEFAULT '0000000' NOT NULL auto_increment,
description text NOT NULL,
steps_to_reproduce text NOT NULL,
additional_information text NOT NULL,
PRIMARY KEY (id)
);
# --------------------------------------------------------
#
# Table structure for table 'mantis_bugnote_table'
#
CREATE TABLE mantis_bugnote_table (
id int(7) unsigned zerofill DEFAULT '0000000' NOT NULL auto_increment,
bug_id int(7) unsigned zerofill DEFAULT '0000000' NOT NULL,
reporter_id int(7) unsigned zerofill DEFAULT '0000000' NOT NULL,
bugnote_text_id int(7) unsigned zerofill DEFAULT '0000000' NOT NULL,
date_submitted timestamp(14),
last_modified timestamp(14),
PRIMARY KEY (id)
);
# --------------------------------------------------------
#
# Table structure for table 'mantis_bugnote_text_table'
#
CREATE TABLE mantis_bugnote_text_table (
id int(7) unsigned zerofill DEFAULT '0000000' NOT NULL auto_increment,
note text NOT NULL,
PRIMARY KEY (id)
);
# --------------------------------------------------------
#
# Table structure for table 'mantis_news_table'
#
CREATE TABLE mantis_news_table (
id int(7) unsigned zerofill DEFAULT '0000000' NOT NULL auto_increment,
poster_id int(7) unsigned zerofill DEFAULT '0000000' NOT NULL,
date_posted timestamp(14),
last_modified timestamp(14),
headline varchar(64) NOT NULL,
body text NOT NULL,
PRIMARY KEY (id),
KEY id (id)
);
# --------------------------------------------------------
#
# Table structure for table 'mantis_user_table'
#
CREATE TABLE mantis_user_table (
id int(7) unsigned zerofill DEFAULT '0000000' NOT NULL auto_increment,
username varchar(32) NOT NULL,
email varchar(64) NOT NULL,
password varchar(32) NOT NULL,
date_created timestamp(14),
last_visit timestamp(14),
enabled char(3) DEFAULT 'on' NOT NULL,
protected char(3) DEFAULT '' NOT NULL,
access_level enum('viewer','reporter','updater','developer','administrator') DEFAULT 'viewer' NOT NULL,
cookie_string varchar(128) NOT NULL,
PRIMARY KEY (id)
);
#
# Dumping data for table 'mantis_user_table'
#
INSERT INTO mantis_user_table VALUES( '0000001', 'administrator', 'admin', 'MNYm8SfoJlvIY', '20001121161430', '20001121161430', 'on', 'on', 'administrator', 'MN91uSF/JIhos8bcda8acc2ead8d60749ad019e56b54fadkPGTyoBgNBQf91563adc2f7337f566cc3d2c792bc3c-10728595');
#
# Table structure for table 'mantis_user_profile_table'
#
CREATE TABLE mantis_user_profile_table (
id int(10) unsigned zerofill DEFAULT '0000000000' NOT NULL auto_increment,
user_id int(10) unsigned zerofill DEFAULT '0000000000' NOT NULL,
platform varchar(32) NOT NULL,
os varchar(32) NOT NULL,
os_build varchar(16) NOT NULL,
description text NOT NULL,
default_profile char(3) NOT NULL,
PRIMARY KEY (id)
);
#
# Table structure for table 'mantis_user_defaults_table'
#
CREATE TABLE mantis_user_defaults_table (
id int(10) unsigned zerofill DEFAULT '0000000000' NOT NULL auto_increment,
user_id int(10) unsigned zerofill DEFAULT '0000000000' NOT NULL,
hide_resolved char(3) NOT NULL,
limit_view int(11) DEFAULT '0' NOT NULL,
show_last char(3) NOT NULL,
advanced_report char(3) NOT NULL,
advanced_view char(3) NOT NULL,
PRIMARY KEY (id)
);