diff options
| author | Inkfish <Inkfish@54d463be-8e91-2dee-dedb-b68131a5f0ec> | 2009-07-26 09:52:08 +0000 |
|---|---|---|
| committer | Inkfish <Inkfish@54d463be-8e91-2dee-dedb-b68131a5f0ec> | 2009-07-26 09:52:08 +0000 |
| commit | 53ba0c7362dffa576c58f7dc2decbeab0269d67b (patch) | |
| tree | 4c5848b6868fc5c3427d8f4f168e4383f20a6897 /sql-files/upgrade_svn13960_questlog.sql | |
| parent | e9a090774cb956ebb122698374be2a5360dd8b00 (diff) | |
| download | hercules-53ba0c7362dffa576c58f7dc2decbeab0269d67b.tar.gz hercules-53ba0c7362dffa576c58f7dc2decbeab0269d67b.tar.bz2 hercules-53ba0c7362dffa576c58f7dc2decbeab0269d67b.tar.xz hercules-53ba0c7362dffa576c58f7dc2decbeab0269d67b.zip | |
Fixed mob counts and quest states are not saved properly sometimes
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@13964 54d463be-8e91-2dee-dedb-b68131a5f0ec
Diffstat (limited to 'sql-files/upgrade_svn13960_questlog.sql')
| -rw-r--r-- | sql-files/upgrade_svn13960_questlog.sql | 20 |
1 files changed, 20 insertions, 0 deletions
diff --git a/sql-files/upgrade_svn13960_questlog.sql b/sql-files/upgrade_svn13960_questlog.sql new file mode 100644 index 000000000..c7a42960f --- /dev/null +++ b/sql-files/upgrade_svn13960_questlog.sql @@ -0,0 +1,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`;
\ No newline at end of file |