PageRenderTime 41ms CodeModel.GetById 9ms app.highlight 29ms RepoModel.GetById 1ms app.codeStats 0ms

/Script/init_player.sql

http://awoe.googlecode.com/
SQL | 179 lines | 164 code | 15 blank | 0 comment | 0 complexity | 82c9e7113d18fe54f6d6a08c1b6848dc MD5 | raw file
  1delete from player;
  2INSERT INTO `player` (`pid`, `aid`, `name`, `gender`, `features`, `money_g`, `money_s`, `prop_vit`, `prop_str`, `prop_agi`, `prop_int`, `prop_left`, ftype) VALUES
  3(1, 1, 'Eric', 0, 0, 0000000100, 0000000100, 00001, 00002, 00003, 00000, 00000, 1),
  4(2, 1, 'Stormreach', 1, 3, 0000000433, 0000000321, 00002, 00003, 00004, 00005, 00001, 2),
  5(3, 2, 'Wizard', 0, 0, 0000000000, 0000000000, 00000, 00000, 00000, 00000, 00000, 3),
  6(4, 2, 'Shisan', 2, 5, 0000000000, 0000000000, 00000, 00000, 00000, 00000, 00000, 2),
  7(5, 3, 'Vincent', 5, 7, 0000001888, 0000000000, 00000, 00000, 00000, 00000, 00000, 2),
  8(6, 3, 'SLang', 5, 7, 0000001888, 0000000000, 00000, 00000, 00000, 00000, 00000, 2),
  9(7, 4, 'Google', 5, 7, 0000001888, 0000000000, 00000, 00000, 00000, 00000, 00000, 2),
 10(8, 5, 'Baidu', 5, 7, 0000001888, 0000000000, 00000, 00000, 00000, 00000, 00000, 2),
 11(9, 6, 'Ubisoft', 5, 7, 0000001888, 0000000000, 00000, 00000, 00000, 00000, 00000, 2),
 12(10, 7, 'Waking', 5, 7, 0000001888, 0000000000, 00000, 00000, 00000, 00000, 00000, 2);
 13
 14delete from role;
 15insert into role (pid, rid, hid, lvl, exp, hp, mp, eslot1, eslot2, eslot3, eslot4, eslot5, eslot6, eslot7, datax, datay, dataz)
 16values (1, 1, 101, 10, 0, 100, 110, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
 17insert into role (pid, rid, hid, lvl, exp, hp, mp, eslot1, eslot2, eslot3, eslot4, eslot5, eslot6, eslot7, datax, datay, dataz)
 18values (1, 2, 201, 11, 0, 101, 111, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
 19
 20insert into role (pid, rid, hid, lvl, exp, hp, mp, eslot1, eslot2, eslot3, eslot4, eslot5, eslot6, eslot7, datax, datay, dataz)
 21values (2, 1, 202, 20, 0, 100, 110, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
 22insert into role (pid, rid, hid, lvl, exp, hp, mp, eslot1, eslot2, eslot3, eslot4, eslot5, eslot6, eslot7, datax, datay, dataz)
 23values (2, 2, 303, 21, 0, 101, 111, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
 24
 25insert into role (pid, rid, hid, lvl, exp, hp, mp, eslot1, eslot2, eslot3, eslot4, eslot5, eslot6, eslot7, datax, datay, dataz)
 26values (3, 1, 301, 10, 0, 100, 110, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
 27insert into role (pid, rid, hid, lvl, exp, hp, mp, eslot1, eslot2, eslot3, eslot4, eslot5, eslot6, eslot7, datax, datay, dataz)
 28values (3, 2, 203, 11, 0, 101, 111, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
 29
 30insert into role (pid, rid, hid, lvl, exp, hp, mp, eslot1, eslot2, eslot3, eslot4, eslot5, eslot6, eslot7, datax, datay, dataz)
 31values (4, 1, 201, 20, 0, 100, 110, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
 32insert into role (pid, rid, hid, lvl, exp, hp, mp, eslot1, eslot2, eslot3, eslot4, eslot5, eslot6, eslot7, datax, datay, dataz)
 33values (4, 2, 103, 21, 0, 101, 111, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
 34
 35insert into role (pid, rid, hid, lvl, exp, hp, mp, eslot1, eslot2, eslot3, eslot4, eslot5, eslot6, eslot7, datax, datay, dataz)
 36values (5, 1, 102, 10, 0, 100, 110, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
 37insert into role (pid, rid, hid, lvl, exp, hp, mp, eslot1, eslot2, eslot3, eslot4, eslot5, eslot6, eslot7, datax, datay, dataz)
 38values (5, 2, 201, 11, 0, 101, 111, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
 39insert into role (pid, rid, hid, lvl, exp, hp, mp, eslot1, eslot2, eslot3, eslot4, eslot5, eslot6, eslot7, datax, datay, dataz)
 40values (5, 3, 301, 12, 0, 100, 110, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
 41insert into role (pid, rid, hid, lvl, exp, hp, mp, eslot1, eslot2, eslot3, eslot4, eslot5, eslot6, eslot7, datax, datay, dataz)
 42values (5, 4, 302, 13, 0, 101, 111, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
 43
 44delete from progress;
 45insert into progress (pid, cid, did, sid, data) values
 46(1, 2, 1, 1, 2),
 47(1, 2, 1, 2, 2),
 48(1, 2, 2, 1, 1),
 49(1, 2, 2, 2, 1),
 50(1, 2, 3, 1, 2),
 51(1, 2, 3, 2, 2);
 52insert into progress (pid, cid, did, sid, data) values
 53(1, 3, 1, 1, 2),
 54(1, 3, 1, 2, 2),
 55(1, 3, 2, 1, 1),
 56(1, 3, 2, 2, 1),
 57(1, 3, 3, 1, 2),
 58(1, 3, 3, 2, 2);
 59insert into progress (pid, cid, did, sid, data) values
 60(1, 6, 1, 1, 2),
 61(1, 6, 1, 2, 2),
 62(1, 6, 2, 1, 1),
 63(1, 6, 2, 2, 1),
 64(1, 6, 3, 1, 2),
 65(1, 6, 3, 2, 2);
 66
 67insert into progress (pid, cid, did, sid, data) values
 68(2, 2, 1, 1, 2),
 69(2, 2, 1, 2, 2),
 70(2, 2, 2, 1, 1),
 71(2, 2, 2, 2, 1),
 72(2, 2, 3, 1, 2),
 73(2, 2, 3, 2, 2);
 74insert into progress (pid, cid, did, sid, data) values 
 75(2, 3, 1, 1, 2),
 76(2, 3, 1, 2, 2),
 77(2, 3, 2, 1, 1),
 78(2, 3, 2, 2, 1),
 79(2, 3, 3, 1, 2),
 80(2, 3, 3, 2, 2);
 81insert into progress (pid, cid, did, sid, data)values 
 82(2, 6, 1, 1, 2),
 83(2, 6, 1, 2, 2),
 84(2, 6, 2, 1, 1),
 85(2, 6, 2, 2, 1),
 86(2, 6, 3, 1, 2),
 87(2, 6, 3, 2, 2);
 88
 89insert into progress (pid, cid, did, sid, data) values 
 90(3, 2, 1, 1, 2),
 91(3, 2, 1, 2, 2),
 92(3, 2, 2, 1, 1),
 93(3, 2, 2, 2, 1),
 94(3, 2, 3, 1, 2),
 95(3, 2, 3, 2, 2);
 96insert into progress (pid, cid, did, sid, data) values 
 97(3, 3, 1, 1, 2),
 98(3, 3, 1, 2, 2),
 99(3, 3, 2, 1, 1),
100(3, 3, 2, 2, 1),
101(3, 3, 3, 1, 2),
102(3, 3, 3, 2, 2);
103insert into progress (pid, cid, did, sid, data) values 
104(3, 6, 1, 1, 2),
105(3, 6, 1, 2, 2),
106(3, 6, 2, 1, 1),
107(3, 6, 2, 2, 1),
108(3, 6, 3, 1, 2),
109(3, 6, 3, 2, 2);
110
111insert into progress (pid, cid, did, sid, data) values 
112(4, 2, 1, 1, 2),
113(4, 2, 1, 2, 2),
114(4, 2, 2, 1, 1),
115(4, 2, 2, 2, 1),
116(4, 2, 3, 1, 2),
117(4, 2, 3, 2, 2);
118insert into progress (pid, cid, did, sid, data) values 
119(4, 3, 1, 1, 2),
120(4, 3, 1, 2, 2),
121(4, 3, 2, 1, 1),
122(4, 3, 2, 2, 1),
123(4, 3, 3, 1, 2),
124(4, 3, 3, 2, 2);
125insert into progress (pid, cid, did, sid, data) values 
126(4, 6, 1, 1, 2),
127(4, 6, 1, 2, 2),
128(4, 6, 2, 1, 1),
129(4, 6, 2, 2, 1),
130(4, 6, 3, 1, 2),
131(4, 6, 3, 2, 2);
132
133insert into progress (pid, cid, did, sid, data) values 
134(5, 2, 1, 1, 2),
135(5, 2, 1, 2, 2),
136(5, 2, 2, 1, 1),
137(5, 2, 2, 2, 1),
138(5, 2, 3, 1, 2),
139(5, 2, 3, 2, 2);
140insert into progress (pid, cid, did, sid, data) values 
141(5, 3, 1, 1, 2),
142(5, 3, 1, 2, 2),
143(5, 3, 2, 1, 1),
144(5, 3, 2, 2, 1),
145(5, 3, 3, 1, 2),
146(5, 3, 3, 2, 2);
147insert into progress (pid, cid, did, sid, data) values 
148(5, 6, 1, 1, 2),
149(5, 6, 1, 2, 2),
150(5, 6, 2, 1, 1),
151(5, 6, 2, 2, 1),
152(5, 6, 3, 1, 2),
153(5, 6, 3, 2, 2);
154
155delete from form;
156insert into form (pid, type, lvl, fslot1, fslot2, fslot3, fslot4, fslot5) values
157(1, 1, 3, 1, 2, 0, 0, 0),
158(1, 2, 5, 0, 1, 2, 0, 0),
159(1, 3, 4, 2, 1, 0, 0, 0);
160
161insert into form (pid, type, lvl, fslot1, fslot2, fslot3, fslot4, fslot5) values
162(2, 1, 3, 1, 2, 0, 0, 0),
163(2, 2, 5, 0, 1, 2, 0, 0),
164(2, 3, 4, 2, 1, 0, 0, 0);
165
166insert into form (pid, type, lvl, fslot1, fslot2, fslot3, fslot4, fslot5) values
167(3, 1, 3, 1, 2, 0, 0, 0),
168(3, 2, 5, 0, 1, 2, 0, 0),
169(3, 3, 4, 2, 1, 0, 0, 0);
170
171insert into form (pid, type, lvl, fslot1, fslot2, fslot3, fslot4, fslot5) values
172(4, 1, 3, 1, 2, 0, 0, 0),
173(4, 2, 5, 0, 1, 2, 0, 0),
174(4, 3, 4, 2, 1, 0, 0, 0);
175
176insert into form (pid, type, lvl, fslot1, fslot2, fslot3, fslot4, fslot5) values
177(5, 1, 3, 1, 2, 0, 0, 0),
178(5, 2, 5, 0, 1, 2, 0, 0),
179(5, 3, 4, 2, 1, 0, 0, 0);