/*
SQLyog Community Edition- MySQL GUI v5.22a
Host - 4.1.9-max : Database - quests
*********************************************************************
Server version : 4.1.9-max
*/





/*Table structure for table `ajquests` */


CREATE TABLE `ajquests` (
  `entry` int(11) NOT NULL default '0',
  `Title` text NOT NULL,
  `Details` text NOT NULL,
  `Objectives` text NOT NULL,
  `OfferRewardText` text NOT NULL,
  `RequestItemsText` text NOT NULL,
  `State` int(11) NOT NULL default '0',
  `User` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*Table structure for table `czquests` */


CREATE TABLE `czquests` (
  `entry` int(11) NOT NULL default '0',
  `Title` text NOT NULL,
  `Details` text NOT NULL,
  `Objectives` text NOT NULL,
  `OfferRewardText` text NOT NULL,
  `RequestItemsText` text NOT NULL,
  `State` int(11) NOT NULL default '0',
  `User` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*Table structure for table `user` */


CREATE TABLE `user` (
  `user` text NOT NULL,
  `pass` text NOT NULL,
  `gm` int(11) NOT NULL default '0',
  `LastIP` text NOT NULL,
  `LastLogin` datetime NOT NULL default '0000-00-00 00:00:00',
  `NumberTranslateQuests` int(11) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*Data for the table `user` */

insert  into `user`(`user`,`pass`,`gm`,`LastIP`,`LastLogin`,`NumberTranslateQuests`) values ('maron','games',0,'192.168.1.25','2007-06-06 18:10:43',5);
insert  into `user`(`user`,`pass`,`gm`,`LastIP`,`LastLogin`,`NumberTranslateQuests`) values ('chronos','fobia',0,'147.229.213.244','2007-06-06 18:52:24',0);

/*Table structure for table `var` */


CREATE TABLE `var` (
  `Name` text NOT NULL,
  `Value` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*Data for the table `var` */

insert  into `var`(`Name`,`Value`) values ('NumberQuests','5832');
insert  into `var`(`Name`,`Value`) values ('UpdateStatistic','0');


