3 -- http://www.phpmyadmin.net
6 -- Generation Time: Sep 10, 2005 at 12:27 PM
7 -- Server version: 4.1.12
13 -- --------------------------------------------------------
16 -- Table structure for table `queststatus`
18 -- Creation: Sep 10, 2005 at 12:02 PM
19 -- Last update: Sep 10, 2005 at 12:02 PM
22 DROP TABLE IF EXISTS `queststatus`;
23 CREATE TABLE `queststatus` (
24 `playerId` bigint(20) unsigned NOT NULL default '0',
25 `questId` bigint(22) unsigned NOT NULL default '0',
26 `status` bigint(20) unsigned NOT NULL default '0',
27 `rewarded` bigint(20) unsigned NOT NULL default '0',
28 `questMobCount1` bigint(20) unsigned NOT NULL default '0',
29 `questMobCount2` bigint(20) unsigned NOT NULL default '0',
30 `questMobCount3` bigint(20) unsigned NOT NULL default '0',
31 `questMobCount4` bigint(20) unsigned NOT NULL default '0',
32 `questItemCount1` bigint(20) unsigned NOT NULL default '0',
33 `questItemCount2` bigint(20) unsigned NOT NULL default '0',
34 `questItemCount3` bigint(20) unsigned NOT NULL default '0',
35 `questItemCount4` bigint(20) unsigned NOT NULL default '0',
36 `timer` bigint(20) unsigned NOT NULL default '0',
37 `explored` bigint(20) unsigned NOT NULL default '0',
38 `id` int(11) NOT NULL auto_increment,