summaryrefslogtreecommitdiff
path: root/sql-files/upgrade_svn_questlog.sql
blob: c7a42960f651189a341739e15ec2ed83a40d9528 (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
--
-- Table structure for table `questlog`
--

CREATE TABLE IF NOT EXISTS `questlog` (
  `char_id` int(11) unsigned NOT NULL default '0',
  `quest_id` int(10) unsigned NOT NULL,
  `state` enum('2','1','0') NOT NULL default '0',
  `time` int(11) unsigned NOT NULL default '0',
  `mob1` mediumint(9) unsigned NOT NULL default '0',
  `count1` mediumint(8) unsigned NOT NULL default '0',
  `mob2` mediumint(9) unsigned NOT NULL default '0',
  `count2` mediumint(8) unsigned NOT NULL default '0',
  `mob3` mediumint(9) unsigned NOT NULL default '0',
  `count3` mediumint(8) unsigned NOT NULL default '0',
  PRIMARY KEY  USING BTREE (`char_id`,`quest_id`)
) ENGINE=MyISAM;

DROP TABLE `quest_objective`;
DROP TABLE `quest`;