1 DROP TABLE IF EXISTS `quest_end_scripts`;
2 CREATE TABLE `quest_end_scripts` (
3 `id` int(11) unsigned NOT NULL default '0',
4 `delay` int(11) unsigned NOT NULL default '0',
5 `command` int(11) unsigned NOT NULL default '0',
6 `datalong` int(11) unsigned NOT NULL default '0',
7 `datalong2` int(11) unsigned NOT NULL default '0',
8 `datatext` text NOT NULL,
9 `x` float NOT NULL default '0',
10 `y` float NOT NULL default '0',
11 `z` float NOT NULL default '0',
12 `o` float NOT NULL default '0'
13 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
15 DROP TABLE IF EXISTS `quest_start_scripts`;
16 CREATE TABLE `quest_start_scripts` (
17 `id` int(11) unsigned NOT NULL default '0',
18 `delay` int(11) unsigned NOT NULL default '0',
19 `command` int(11) unsigned NOT NULL default '0',
20 `datalong` int(11) unsigned NOT NULL default '0',
21 `datalong2` int(11) unsigned NOT NULL default '0',
22 `datatext` text NOT NULL,
23 `x` float NOT NULL default '0',
24 `y` float NOT NULL default '0',
25 `z` float NOT NULL default '0',
26 `o` float NOT NULL default '0'
27 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
30 INSERT INTO `quest_end_scripts`
31 SELECT `id`,`delay`,`command`,`datalong`,`datalong2`,`datatext`,`x`,`y`,`z`,`o`
32 FROM `scripts` WHERE `StartOrFinish` = 0;
34 INSERT INTO `quest_start_scripts`
35 SELECT `id`,`delay`,`command`,`datalong`,`datalong2`,`datatext`,`x`,`y`,`z`,`o`
36 FROM `scripts` WHERE `StartOrFinish` = 1;
38 DROP TABLE IF EXISTS `scripts`;