sql-files/upgrade_svn12559.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24

--
-- Table structure for table `quest`
--

DROP TABLE IF EXISTS `quest`;
CREATE TABLE `quest` (
  `char_id` int(11) unsigned NOT NULL default '0',
  `quest_id` int(10) unsigned NOT NULL,
  `state` enum('1','0') NOT NULL default '0',
  PRIMARY KEY  USING BTREE (`char_id`,`quest_id`)
) ENGINE=MyISAM;

--
-- Table structure for table `quest_mob`
--

DROP TABLE IF EXISTS `quest_objective`;
CREATE TABLE `quest_objective` (
  `quest_id` int(11) unsigned NOT NULL,
  `count` mediumint(8) unsigned NOT NULL default '0',
  `name` varchar(255) NOT NULL default '',
  `num` tinyint(3) unsigned NOT NULL,
  PRIMARY KEY  USING BTREE (`quest_id`,`num`)
) ENGINE=MyISAM;