Initial Patch of Auction House bot rev. 135
[auctionmangos.git] / sql / updates / 0.11 / 6265_mangos_pet_name_generation.sql
blob3325792eca39a00bd7dcb9a519987adc59b95495
1 DROP TABLE IF EXISTS `pet_name_generation`;
2 CREATE TABLE `pet_name_generation` (
3   `id` mediumint(8) unsigned NOT NULL auto_increment,
4   `word` tinytext NOT NULL,
5   `entry` mediumint(8) unsigned NOT NULL default '0',
6   `half` tinyint(4) NOT NULL default '0',
7   PRIMARY KEY  (`id`)
8 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
10 INSERT INTO `pet_name_generation` (`word`,`entry`,`half`) VALUES
11 ('Aba',416,0),
12 ('Az',416,0),
13 ('Bel',416,0),
14 ('Biz',416,0),
15 ('Cho',416,0),
16 ('Dag',416,0),
17 ('Gak',416,0),
18 ('Gar',416,0),
19 ('Gel',416,0),
20 ('Gho',416,0),
21 ('Gob',416,0),
22 ('Gra',416,0),
23 ('Jak',416,0),
24 ('Jub',416,0),
25 ('Kar',416,0),
26 ('Kup',416,0),
27 ('Laz',416,0),
28 ('Nal',416,0),
29 ('Nok',416,0),
30 ('Pag',416,0),
31 ('Pig',416,0),
32 ('Pip',416,0),
33 ('Piz',416,0),
34 ('Quz',416,0),
35 ('Rui',416,0),
36 ('Rul',416,0),
37 ('Rup',416,0),
38 ('Tar',416,0),
39 ('Vol',416,0),
40 ('Yaz',416,0),
41 ('Zep',416,0),
42 ('Zig',416,0),
43 ('Zil',416,0),
44 ('Zor',416,0),
45 ('bis',416,1),
46 ('fip',416,1),
47 ('gup',416,1),
48 ('ham',416,1),
49 ('jub',416,1),
50 ('kin',416,1),
51 ('kol',416,1),
52 ('lop',416,1),
53 ('loz',416,1),
54 ('mat',416,1),
55 ('mir',416,1),
56 ('nam',416,1),
57 ('nar',416,1),
58 ('nik',416,1),
59 ('nip',416,1),
60 ('pad',416,1),
61 ('pep',416,1),
62 ('pit',416,1),
63 ('qua',416,1),
64 ('rai',416,1),
65 ('rin',416,1),
66 ('rot',416,1),
67 ('tai',416,1),
68 ('tal',416,1),
69 ('tik',416,1),
70 ('tip',416,1),
71 ('tog',416,1),
72 ('tuk',416,1),
73 ('uri',416,1),
74 ('yal',416,1),
75 ('yap',416,1),
76 ('Bhee',417,0),
77 ('Bruu',417,0),
78 ('Czaa',417,0),
79 ('Droo',417,0),
80 ('Flaa',417,0),
81 ('Fzuu',417,0),
82 ('Ghaa',417,0),
83 ('Gree',417,0),
84 ('Gzaa',417,0),
85 ('Haa',417,0),
86 ('Haad',417,0),
87 ('Haag',417,0),
88 ('Haap',417,0),
89 ('Jhaa',417,0),
90 ('Jhuu',417,0),
91 ('Khaa',417,0),
92 ('Khii',417,0),
93 ('Khuu',417,0),
94 ('Kree',417,0),
95 ('Luu',417,0),
96 ('Maa',417,0),
97 ('Nhee',417,0),
98 ('Phuu',417,0),
99 ('Pryy',417,0),
100 ('Rhuu',417,0),
101 ('Shaa',417,0),
102 ('Sloo',417,0),
103 ('Sruu',417,0),
104 ('Thoo',417,0),
105 ('Traa',417,0),
106 ('Wraa',417,0),
107 ('Zhaa',417,0),
108 ('dhon',417,1),
109 ('dhum',417,1),
110 ('dhun',417,1),
111 ('dom',417,1),
112 ('don',417,1),
113 ('drom',417,1),
114 ('dym',417,1),
115 ('fenn',417,1),
116 ('fum',417,1),
117 ('fun',417,1),
118 ('ghon',417,1),
119 ('ghun',417,1),
120 ('grom',417,1),
121 ('grym',417,1),
122 ('hom',417,1),
123 ('hon',417,1),
124 ('hun',417,1),
125 ('jhom',417,1),
126 ('kun',417,1),
127 ('lum',417,1),
128 ('mmon',417,1),
129 ('mon',417,1),
130 ('myn',417,1),
131 ('nam',417,1),
132 ('nem',417,1),
133 ('nhym',417,1),
134 ('nom',417,1),
135 ('num',417,1),
136 ('phom',417,1),
137 ('roon',417,1),
138 ('rym',417,1),
139 ('shon',417,1),
140 ('thun',417,1),
141 ('tom',417,1),
142 ('zhem',417,1),
143 ('zhum',417,1),
144 ('zun',417,1),
145 ('Bar',1860,0),
146 ('Bel',1860,0),
147 ('Char',1860,0),
148 ('Grak\'',1860,0),
149 ('Graz\'',1860,0),
150 ('Grim',1860,0),
151 ('Hath',1860,0),
152 ('Hel',1860,0),
153 ('Hok',1860,0),
154 ('Huk',1860,0),
155 ('Jhaz',1860,0),
156 ('Jhom',1860,0),
157 ('Juk\'',1860,0),
158 ('Kal\'',1860,0),
159 ('Klath',1860,0),
160 ('Kon',1860,0),
161 ('Krag',1860,0),
162 ('Krak',1860,0),
163 ('Mak',1860,0),
164 ('Mezz',1860,0),
165 ('Orm',1860,0),
166 ('Phan',1860,0),
167 ('Sar',1860,0),
168 ('Tang',1860,0),
169 ('Than',1860,0),
170 ('Thog',1860,0),
171 ('Thok',1860,0),
172 ('Thul',1860,0),
173 ('Zag\'',1860,0),
174 ('Zang',1860,0),
175 ('Zhar\'',1860,0),
176 ('kath',1860,1),
177 ('doc',1860,1),
178 ('dok',1860,1),
179 ('gak',1860,1),
180 ('garth',1860,1),
181 ('gore',1860,1),
182 ('gorg',1860,1),
183 ('grave',1860,1),
184 ('gron',1860,1),
185 ('juk',1860,1),
186 ('krast',1860,1),
187 ('kresh',1860,1),
188 ('krit',1860,1),
189 ('los',1860,1),
190 ('mon',1860,1),
191 ('mos',1860,1),
192 ('moth',1860,1),
193 ('nagma',1860,1),
194 ('nak',1860,1),
195 ('nar',1860,1),
196 ('nos',1860,1),
197 ('nuz',1860,1),
198 ('phog',1860,1),
199 ('rath',1860,1),
200 ('tast',1860,1),
201 ('taz',1860,1),
202 ('thak',1860,1),
203 ('thang',1860,1),
204 ('thyk',1860,1),
205 ('vhug',1860,1),
206 ('zazt',1860,1),
207 ('Ael',1863,0),
208 ('Aez',1863,0),
209 ('Ang',1863,0),
210 ('Ban',1863,0),
211 ('Bet',1863,0),
212 ('Bro',1863,0),
213 ('Bry',1863,0),
214 ('Cat',1863,0),
215 ('Dir',1863,0),
216 ('Dis',1863,0),
217 ('Dom',1863,0),
218 ('Drus',1863,0),
219 ('Fie',1863,0),
220 ('Fier',1863,0),
221 ('Gly',1863,0),
222 ('Hel',1863,0),
223 ('Hes',1863,0),
224 ('Kal',1863,0),
225 ('Lyn',1863,0),
226 ('Mir',1863,0),
227 ('Nim',1863,0),
228 ('Sar',1863,0),
229 ('Sel',1863,0),
230 ('Vil',1863,0),
231 ('Zah',1863,0),
232 ('aith',1863,1),
233 ('anda',1863,1),
234 ('antia',1863,1),
235 ('evere',1863,1),
236 ('lia',1863,1),
237 ('lissa',1863,1),
238 ('neri',1863,1),
239 ('neth',1863,1),
240 ('nia',1863,1),
241 ('nlissa',1863,1),
242 ('nora',1863,1),
243 ('nva',1863,1),
244 ('nys',1863,1),
245 ('ola',1863,1),
246 ('ona',1863,1),
247 ('ora',1863,1),
248 ('rah',1863,1),
249 ('riana',1863,1),
250 ('riel',1863,1),
251 ('rona',1863,1),
252 ('tai',1863,1),
253 ('tevere',1863,1),
254 ('thea',1863,1),
255 ('vina',1863,1),
256 ('wena',1863,1),
257 ('wyn',1863,1),
258 ('xia',1863,1),
259 ('yla',1863,1),
260 ('yssa',1863,1),
261 ('Flaa',17252,0),
262 ('Haa',17252,0),
263 ('Jhuu',17252,0),
264 ('Shaa',17252,0),
265 ('Thoo',17252,0),
266 ('dhun',17252,1),
267 ('ghun',17252,1),
268 ('roon',17252,1),
269 ('thun',17252,1),
270 ('tom',17252,1);