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
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
|
<?php
$res = array();
// TODO: serverid NULL, constraint to serverlist on delete set NULL
$res[] = tableCreate('location_info', '
`locationid` INT(11) NOT NULL,
`serverid` INT(11) NOT NULL,
`serverroomid` VARCHAR(2000),
`hidden` BOOLEAN NOT NULL DEFAULT 0,
`openingtime` VARCHAR(2000),
`config` VARCHAR(2000),
`calendar` VARCHAR(2000),
`lastcalendarupdate` INT(11) NOT NULL DEFAULT 0,
PRIMARY KEY (`locationid`)
');
// TODO: KEY `servername` (`servername`)
$res[] = tableCreate('setting_location_info', '
`serverid` int(10) NOT NULL AUTO_INCREMENT,
`servername` VARCHAR(2000) NOT NULL,
`serverurl` VARCHAR(2000) NOT NULL,
`servertype` VARCHAR(100) NOT NULL,
`credentials` VARCHAR(2000),
`error` VARCHAR(2000),
PRIMARY KEY (`serverid`)
');
// Create response for browser
if (!tableHasColumn('setting_location_info', 'credentials')) {
$ret = Database::exec("ALTER TABLE `setting_location_info` ADD `credentials` VARCHAR(2000) AFTER `servertype`");
if ($ret === false) {
finalResponse(UPDATE_FAILED, 'Adding column credentials failed: ' . Database::lastError());
}
$res[] = UPDATE_DONE;
}
if (!tableHasColumn('setting_location_info', 'error')) {
$ret = Database::exec("ALTER TABLE `setting_location_info` ADD `error` VARCHAR(2000) AFTER `credentials`");
if ($ret === false) {
finalResponse(UPDATE_FAILED, 'Adding column error failed: ' . Database::lastError());
}
$res[] = UPDATE_DONE;
}
if (tableHasColumn('setting_location_info', 'login')) {
$ret = Database::exec("ALTER TABLE `setting_location_info` DROP COLUMN login");
if ($ret === false) {
finalResponse(UPDATE_FAILED, 'Dropping column login failed: ' . Database::lastError());
}
$res[] = UPDATE_DONE;
}
if (tableHasColumn('setting_location_info', 'passwd')) {
$ret = Database::exec("ALTER TABLE `setting_location_info` DROP COLUMN passwd");
if ($ret === false) {
finalResponse(UPDATE_FAILED, 'Dropping column passwd failed: ' . Database::lastError());
}
$res[] = UPDATE_DONE;
}
if (tableHasColumn('location_info', 'serverroomid')) {
$ret = Database::exec("ALTER TABLE `location_info` MODIFY serverroomid VARCHAR(2000)");
if ($ret === false) {
finalResponse(UPDATE_FAILED, 'Updateing column serverroomid failed: ' . Database::lastError());
}
$res[] = UPDATE_DONE;
}
if (tableHasColumn('location_info', 'openingtime')) {
$ret = Database::exec("ALTER TABLE `location_info` MODIFY openingtime VARCHAR(2000)");
if ($ret === false) {
finalResponse(UPDATE_FAILED, 'Updateing column openingtime failed: ' . Database::lastError());
}
$res[] = UPDATE_DONE;
}
if (tableHasColumn('location_info', 'config')) {
$ret = Database::exec("ALTER TABLE `location_info` MODIFY config VARCHAR(2000)");
if ($ret === false) {
finalResponse(UPDATE_FAILED, 'Updateing column config failed: ' . Database::lastError());
}
$res[] = UPDATE_DONE;
}
if (tableHasColumn('location_info', 'calendar')) {
$ret = Database::exec("ALTER TABLE `location_info` MODIFY calendar VARCHAR(2000)");
if ($ret === false) {
finalResponse(UPDATE_FAILED, 'Updateing column calendar failed: ' . Database::lastError());
}
$res[] = UPDATE_DONE;
}
if (tableHasColumn('location_info', 'lastcalendarupdate')) {
$ret = Database::exec("ALTER TABLE `location_info` MODIFY lastcalendarupdate INT(11) NOT NULL DEFAULT 0");
if ($ret === false) {
finalResponse(UPDATE_FAILED, 'Updateing column lastcalendarupdate failed: ' . Database::lastError());
}
$res[] = UPDATE_DONE;
}
if (tableExists('locationinfo')) {
$ret = Database::exec("DROP TABLE `locationinfo`");
if ($ret === false) {
finalResponse(UPDATE_FAILED, 'Droping table locationinfo failed: ' . Database::lastError());
}
$res[] = UPDATE_DONE;
}
if (!tableHasColumn('location_info', 'config')) {
$ret = Database::exec("ALTER TABLE `location_info` ADD `config` VARCHAR(2000) NOT NULL DEFAULT '' AFTER `openingtime`");
if ($ret === false) {
finalResponse(UPDATE_FAILED, 'Adding config to location_info failed: ' . Database::lastError());
}
$res[] = UPDATE_DONE;
}
if (!tableHasColumn('location_info', 'calendar')) {
$ret = Database::exec("ALTER TABLE `location_info` ADD `calendar` VARCHAR(2000) NOT NULL DEFAULT '' AFTER `config`");
if ($ret === false) {
finalResponse(UPDATE_FAILED, 'Adding calendar to location_info failed: ' . Database::lastError());
}
$res[] = UPDATE_DONE;
}
if (!tableHasColumn('location_info', 'serverid')) {
$ret = Database::exec("ALTER TABLE `location_info` ADD `serverid` INT(11) NOT NULL AFTER `locationid`");
if ($ret === false) {
finalResponse(UPDATE_FAILED, 'Adding serverid to location_info failed: ' . Database::lastError());
}
$res[] = UPDATE_DONE;
}
if (!tableHasColumn('location_info', 'serverroomid')) {
$ret = Database::exec("ALTER TABLE `location_info` ADD `serverroomid` INT(11) NOT NULL AFTER `serverid`");
if ($ret === false) {
finalResponse(UPDATE_FAILED, 'Adding serverroomid to location_info failed: ' . Database::lastError());
}
$res[] = UPDATE_DONE;
}
if (!tableHasColumn('location_info', 'lastcalendarupdate')) {
$ret = Database::exec("ALTER TABLE `location_info` ADD `lastcalendarupdate` INT(11) NOT NULL AFTER `calendar`");
if ($ret === false) {
finalResponse(UPDATE_FAILED, 'Adding lastcalendarupdate to location_info failed: ' . Database::lastError());
}
$res[] = UPDATE_DONE;
}
if (!tableHasColumn('setting_location_info', 'servername')) {
$ret = Database::exec("ALTER TABLE `setting_location_info` ADD `servername` VARCHAR(2000) NOT NULL AFTER `serverid`");
if ($ret === false) {
finalResponse(UPDATE_FAILED, 'Adding servername to setting_location_info failed: ' . Database::lastError());
}
$res[] = UPDATE_DONE;
}
if (in_array(UPDATE_DONE, $res)) {
finalResponse(UPDATE_DONE, 'Tables created successfully');
}
finalResponse(UPDATE_NOOP, 'Everything already up to date');
|
