From 84f811edfd2e5b2811f438bb64368ec85d8891a1 Mon Sep 17 00:00:00 2001 From: Kevin Date: Thu, 10 Apr 2008 05:35:04 +0000 Subject: Char server now loads/saves quest information. Included table definitions for quests and quest objectives. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@12545 54d463be-8e91-2dee-dedb-b68131a5f0ec --- sql-files/main.sql | 28 ++++++++++++++++++++++++++++ 1 file changed, 28 insertions(+) (limited to 'sql-files/main.sql') diff --git a/sql-files/main.sql b/sql-files/main.sql index 0b8c9b32c..dc733686b 100644 --- a/sql-files/main.sql +++ b/sql-files/main.sql @@ -565,6 +565,34 @@ CREATE TABLE `pet` ( PRIMARY KEY (`pet_id`) ) ENGINE=MyISAM; +-- +-- Table structure for table `quest` +-- + +DROP TABLE IF EXISTS `quest`; +CREATE TABLE `quest` ( + `id` int(11) unsigned NOT NULL auto_increment, + `name` varchar(255) NOT NULL default '', + `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 (`id`) +) ENGINE=MyISAM; + +-- +-- Table structure for table `quest_mob` +-- + +DROP TABLE IF EXISTS `quest_objective`; +CREATE TABLE `quest_objective` ( + `id` int(11) unsigned NOT NULL auto_increment, + `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 (`id`) +) ENGINE=MyISAM; + -- -- Table structure for table `ragsrvinfo` -- -- cgit v1.2.3-60-g2f50