vMzYRu0k

1// chay cac query sau theo thu tu tu` tren xuong duoi
2
3CREATE TABLE IF NOT EXISTS `guilds` (
4  `guid` int(11) NOT NULL,
5  `name` tinytext DEFAULT '',
6  `leader` int(11) DEFAULT -1,
7  `lockerCoords0` float DEFAULT 0,
8  `lockerCoords1` float DEFAULT 0,
9  `lockerCoords2` float DEFAULT 0,
10  `lockerInt` int(11) NOT NULL DEFAULT 0,
11  `lockerVW` int(11) NOT NULL DEFAULT 0,
12  `members0` int(11) NOT NULL DEFAULT -1,
13  `members1` int(11) NOT NULL DEFAULT -1,
14  `members2` int(11) NOT NULL DEFAULT -1,
15  `members3` int(11) NOT NULL DEFAULT -1,
16  `members4` int(11) NOT NULL DEFAULT -1,
17  `members5` int(11) NOT NULL DEFAULT -1,
18  `members6` int(11) NOT NULL DEFAULT -1,
19  `members7` int(11) NOT NULL DEFAULT -1,
20  `members8` int(11) NOT NULL DEFAULT -1,
21  `members9` int(11) NOT NULL DEFAULT -1,
22  `members10` int(11) NOT NULL DEFAULT -1,
23  `members11` int(11) NOT NULL DEFAULT -1,
24  `members12` int(11) NOT NULL DEFAULT -1,
25  `members13` int(11) NOT NULL DEFAULT -1,
26  `members14` int(11) NOT NULL DEFAULT -1,
27  `members15` int(11) NOT NULL DEFAULT -1,
28  `members16` int(11) NOT NULL DEFAULT -1,
29  `members17` int(11) NOT NULL DEFAULT -1,
30  `members18` int(11) NOT NULL DEFAULT -1,
31  `members19` int(11) NOT NULL DEFAULT -1,
32  `members20` int(11) NOT NULL DEFAULT -1,
33  `members21` int(11) NOT NULL DEFAULT -1,
34  `members22` int(11) NOT NULL DEFAULT -1,
35  `members23` int(11) NOT NULL DEFAULT -1,
36  `members24` int(11) NOT NULL DEFAULT -1,
37  `members25` int(11) NOT NULL DEFAULT -1,
38  `members26` int(11) NOT NULL DEFAULT -1,
39  `members27` int(11) NOT NULL DEFAULT -1,
40  `members28` int(11) NOT NULL DEFAULT -1,
41  `members29` int(11) NOT NULL DEFAULT -1,
42  `members30` int(11) NOT NULL DEFAULT -1,
43  `members31` int(11) NOT NULL DEFAULT -1,
44  `members32` int(11) NOT NULL DEFAULT -1,
45  `members33` int(11) NOT NULL DEFAULT -1,
46  `members34` int(11) NOT NULL DEFAULT -1,
47  `members35` int(11) NOT NULL DEFAULT -1,
48  `members36` int(11) NOT NULL DEFAULT -1,
49  `members37` int(11) NOT NULL DEFAULT -1,
50  `members38` int(11) NOT NULL DEFAULT -1,
51  `members39` int(11) NOT NULL DEFAULT -1,
52  `members40` int(11) NOT NULL DEFAULT -1,
53  `members41` int(11) NOT NULL DEFAULT -1,
54  `members42` int(11) NOT NULL DEFAULT -1,
55  `members43` int(11) NOT NULL DEFAULT -1,
56  `members44` int(11) NOT NULL DEFAULT -1,
57  `members45` int(11) NOT NULL DEFAULT -1,
58  `members46` int(11) NOT NULL DEFAULT -1,
59  `members47` int(11) NOT NULL DEFAULT -1,
60  `members48` int(11) NOT NULL DEFAULT -1,
61  `members49` int(11) NOT NULL DEFAULT -1,
62  `admissions0` int(11) NOT NULL DEFAULT -1,
63  `admissions1` int(11) NOT NULL DEFAULT -1,
64  `admissions2` int(11) NOT NULL DEFAULT -1,
65  `admissions3` int(11) NOT NULL DEFAULT -1,
66  `admissions4` int(11) NOT NULL DEFAULT -1,
67  `admissions5` int(11) NOT NULL DEFAULT -1,
68  `admissions6` int(11) NOT NULL DEFAULT -1,
69  `admissions7` int(11) NOT NULL DEFAULT -1,
70  `admissions8` int(11) NOT NULL DEFAULT -1,
71  `admissions9` int(11) NOT NULL DEFAULT -1,
72  `admissions10` int(11) NOT NULL DEFAULT -1,
73  `admissions11` int(11) NOT NULL DEFAULT -1,
74  `admissions12` int(11) NOT NULL DEFAULT -1,
75  `admissions13` int(11) NOT NULL DEFAULT -1,
76  `admissions14` int(11) NOT NULL DEFAULT -1,
77  `admissions15` int(11) NOT NULL DEFAULT -1,
78  `admissions16` int(11) NOT NULL DEFAULT -1,
79  `admissions17` int(11) NOT NULL DEFAULT -1,
80  `admissions18` int(11) NOT NULL DEFAULT -1,
81  `admissions19` int(11) NOT NULL DEFAULT -1,
82  `lockerCash` int(11) DEFAULT 0,
83  `lockerMaterials` int(11) DEFAULT 0,
84  `lockerCracks` int(11) DEFAULT 0,
85  `lockerPots` int(11) DEFAULT 0,
86  KEY `guid` (`guid`)
87) ENGINE=InnoDB DEFAULT CHARSET=utf8;
88
89///////////////
90
91INSERT INTO `guilds` (`guid`) VALUES (0);
92INSERT INTO `guilds` (`guid`) VALUES (1);
93INSERT INTO `guilds` (`guid`) VALUES (2);
94INSERT INTO `guilds` (`guid`) VALUES (3);
95INSERT INTO `guilds` (`guid`) VALUES (4);
96INSERT INTO `guilds` (`guid`) VALUES (5);
97INSERT INTO `guilds` (`guid`) VALUES (6);
98INSERT INTO `guilds` (`guid`) VALUES (7);
99INSERT INTO `guilds` (`guid`) VALUES (8);
100INSERT INTO `guilds` (`guid`) VALUES (9);
101INSERT INTO `guilds` (`guid`) VALUES (10);
102INSERT INTO `guilds` (`guid`) VALUES (11);
103INSERT INTO `guilds` (`guid`) VALUES (12);
104INSERT INTO `guilds` (`guid`) VALUES (13);
105INSERT INTO `guilds` (`guid`) VALUES (14);
106INSERT INTO `guilds` (`guid`) VALUES (15);
107INSERT INTO `guilds` (`guid`) VALUES (16);
108INSERT INTO `guilds` (`guid`) VALUES (17);
109INSERT INTO `guilds` (`guid`) VALUES (18);
110INSERT INTO `guilds` (`guid`) VALUES (19);
111INSERT INTO `guilds` (`guid`) VALUES (20);
112INSERT INTO `guilds` (`guid`) VALUES (21);
113INSERT INTO `guilds` (`guid`) VALUES (22);
114INSERT INTO `guilds` (`guid`) VALUES (23);
115INSERT INTO `guilds` (`guid`) VALUES (24);
116INSERT INTO `guilds` (`guid`) VALUES (25);
117INSERT INTO `guilds` (`guid`) VALUES (26);
118INSERT INTO `guilds` (`guid`) VALUES (27);
119INSERT INTO `guilds` (`guid`) VALUES (28);
120INSERT INTO `guilds` (`guid`) VALUES (29);
121INSERT INTO `guilds` (`guid`) VALUES (30);
122INSERT INTO `guilds` (`guid`) VALUES (31);
123INSERT INTO `guilds` (`guid`) VALUES (32);
124INSERT INTO `guilds` (`guid`) VALUES (33);
125INSERT INTO `guilds` (`guid`) VALUES (34);
126INSERT INTO `guilds` (`guid`) VALUES (35);
127INSERT INTO `guilds` (`guid`) VALUES (36);
128INSERT INTO `guilds` (`guid`) VALUES (37);
129INSERT INTO `guilds` (`guid`) VALUES (38);
130INSERT INTO `guilds` (`guid`) VALUES (39);
131INSERT INTO `guilds` (`guid`) VALUES (40);
132INSERT INTO `guilds` (`guid`) VALUES (41);
133INSERT INTO `guilds` (`guid`) VALUES (42);
134INSERT INTO `guilds` (`guid`) VALUES (43);
135INSERT INTO `guilds` (`guid`) VALUES (44);
136INSERT INTO `guilds` (`guid`) VALUES (45);
137INSERT INTO `guilds` (`guid`) VALUES (46);
138INSERT INTO `guilds` (`guid`) VALUES (47);
139INSERT INTO `guilds` (`guid`) VALUES (48);
140INSERT INTO `guilds` (`guid`) VALUES (49);
141INSERT INTO `guilds` (`guid`) VALUES (50);
142INSERT INTO `guilds` (`guid`) VALUES (51);
143INSERT INTO `guilds` (`guid`) VALUES (52);
144INSERT INTO `guilds` (`guid`) VALUES (53);
145INSERT INTO `guilds` (`guid`) VALUES (54);
146INSERT INTO `guilds` (`guid`) VALUES (55);
147INSERT INTO `guilds` (`guid`) VALUES (56);
148INSERT INTO `guilds` (`guid`) VALUES (57);
149INSERT INTO `guilds` (`guid`) VALUES (58);
150INSERT INTO `guilds` (`guid`) VALUES (59);
151INSERT INTO `guilds` (`guid`) VALUES (60);
152INSERT INTO `guilds` (`guid`) VALUES (61);
153INSERT INTO `guilds` (`guid`) VALUES (62);
154INSERT INTO `guilds` (`guid`) VALUES (63);
155INSERT INTO `guilds` (`guid`) VALUES (64);
156INSERT INTO `guilds` (`guid`) VALUES (65);
157INSERT INTO `guilds` (`guid`) VALUES (66);
158INSERT INTO `guilds` (`guid`) VALUES (67);
159INSERT INTO `guilds` (`guid`) VALUES (68);
160INSERT INTO `guilds` (`guid`) VALUES (69);
161INSERT INTO `guilds` (`guid`) VALUES (70);
162INSERT INTO `guilds` (`guid`) VALUES (71);
163INSERT INTO `guilds` (`guid`) VALUES (72);
164INSERT INTO `guilds` (`guid`) VALUES (73);
165INSERT INTO `guilds` (`guid`) VALUES (74);
166INSERT INTO `guilds` (`guid`) VALUES (75);
167INSERT INTO `guilds` (`guid`) VALUES (76);
168INSERT INTO `guilds` (`guid`) VALUES (77);
169INSERT INTO `guilds` (`guid`) VALUES (78);
170INSERT INTO `guilds` (`guid`) VALUES (79);
171INSERT INTO `guilds` (`guid`) VALUES (80);
172INSERT INTO `guilds` (`guid`) VALUES (81);
173INSERT INTO `guilds` (`guid`) VALUES (82);
174INSERT INTO `guilds` (`guid`) VALUES (83);
175INSERT INTO `guilds` (`guid`) VALUES (84);
176INSERT INTO `guilds` (`guid`) VALUES (85);
177INSERT INTO `guilds` (`guid`) VALUES (86);
178INSERT INTO `guilds` (`guid`) VALUES (87);
179INSERT INTO `guilds` (`guid`) VALUES (88);
180INSERT INTO `guilds` (`guid`) VALUES (89);
181INSERT INTO `guilds` (`guid`) VALUES (90);
182INSERT INTO `guilds` (`guid`) VALUES (91);
183INSERT INTO `guilds` (`guid`) VALUES (92);
184INSERT INTO `guilds` (`guid`) VALUES (93);
185INSERT INTO `guilds` (`guid`) VALUES (94);
186INSERT INTO `guilds` (`guid`) VALUES (95);
187INSERT INTO `guilds` (`guid`) VALUES (96);
188INSERT INTO `guilds` (`guid`) VALUES (97);
189INSERT INTO `guilds` (`guid`) VALUES (98);
190INSERT INTO `guilds` (`guid`) VALUES (99);
191
192///////////////
193ALTER TABLE `accounts` ADD COLUMN `guildId` int(11) DEFAULT -1;
194ALTER TABLE `accounts` ADD COLUMN `guildAdmission` int(11) DEFAULT -1;