/
UPGRADING
51 lines (40 loc) · 1.74 KB
/
UPGRADING
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
# -------------------------------------------------------------------------------
# Upgrading
# -------------------------------------------------------------------------------
# Here are the basic steps to upgrade the database tables
# Take a look in db_upgrade.sql as well.
# =================
# 0.10.2 to 0.11.0
# =================
# I've added a profile table and inserted feedback into the main bug table.
# Also modified version to be an enum (edit using the manage section)
# Run these queries:
ALTER TABLE mantis_bug_table CHANGE status status ENUM ('new','fdeedback',
'acknowledged','confirmed','assigned','resolved') DEFAULT 'new' not null;
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)
);
ALTER TABLE mantis_bug_table CHANGE version version ENUM ('none') not null;
CREATE TABLE mantis_user_pref_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)
);
# =================
# 0.9.x to 0.10.x
# =================
# You will need to add a 'protected' field in the mantis_user_table.
# This command will do the trick:
ALTER TABLE mantis_user_table ADD protected VARCHAR (3) not null