Context Navigation

262_world_runthisonlyonce.sql

Revision 263, 1.0 kB (checked in by yumileroy, 17 years ago)

Some missing changes. This should fix the bug that loading char causes crash.
Please do not commit to the other tip (I do not know how to delete it).

Original author: megamage
Date: 2008-11-20 17:40:13-06:00

Line
1	ALTER TABLE event_scripts
2	DROP datatext,
3	ADD COLUMN dataint int(11) NOT NULL default '0' AFTER datalong2;
4
5	ALTER TABLE gameobject_scripts
6	DROP datatext,
7	ADD COLUMN dataint int(11) NOT NULL default '0' AFTER datalong2;
8
9	ALTER TABLE quest_end_scripts
10	DROP datatext,
11	ADD COLUMN dataint int(11) NOT NULL default '0' AFTER datalong2;
12
13	ALTER TABLE quest_start_scripts
14	DROP datatext,
15	ADD COLUMN dataint int(11) NOT NULL default '0' AFTER datalong2;
16
17	ALTER TABLE spell_scripts
18	DROP datatext,
19	ADD COLUMN dataint int(11) NOT NULL default '0' AFTER datalong2;
20
21	ALTER TABLE creature_movement
22	DROP `text1`,
23	DROP `text2`,
24	DROP `text3`,
25	DROP `text4`,
26	DROP `text5`,
27	ADD COLUMN textid1 int(11) NOT NULL default '0' AFTER waittime,
28	ADD COLUMN textid2 int(11) NOT NULL default '0' AFTER textid1,
29	ADD COLUMN textid3 int(11) NOT NULL default '0' AFTER textid2,
30	ADD COLUMN textid4 int(11) NOT NULL default '0' AFTER textid3,
31	ADD COLUMN textid5 int(11) NOT NULL default '0' AFTER textid4;

Note: See TracBrowser for help on using the browser.