diff options
| author | Kevin <Kevin@54d463be-8e91-2dee-dedb-b68131a5f0ec> | 2008-04-11 07:24:03 +0000 |
|---|---|---|
| committer | Kevin <Kevin@54d463be-8e91-2dee-dedb-b68131a5f0ec> | 2008-04-11 07:24:03 +0000 |
| commit | 50d90e80f9f70a2dd6939adc39f2eca29ae0a45f (patch) | |
| tree | a0b1530df0e0534e894675e097dbec92d6308185 /sql-files/upgrade_svn12559.sql | |
| parent | 3e2be49541f4f9e464fb7cac1c4bd6eff4df5572 (diff) | |
| download | hercules-50d90e80f9f70a2dd6939adc39f2eca29ae0a45f.tar.gz hercules-50d90e80f9f70a2dd6939adc39f2eca29ae0a45f.tar.bz2 hercules-50d90e80f9f70a2dd6939adc39f2eca29ae0a45f.tar.xz hercules-50d90e80f9f70a2dd6939adc39f2eca29ae0a45f.zip | |
New sql definitions for the quest code.
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@12559 54d463be-8e91-2dee-dedb-b68131a5f0ec
Diffstat (limited to 'sql-files/upgrade_svn12559.sql')
| -rw-r--r-- | sql-files/upgrade_svn12559.sql | 24 |
1 files changed, 24 insertions, 0 deletions
diff --git a/sql-files/upgrade_svn12559.sql b/sql-files/upgrade_svn12559.sql new file mode 100644 index 000000000..66f36a468 --- /dev/null +++ b/sql-files/upgrade_svn12559.sql @@ -0,0 +1,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;
|