-- ----------------------------
-- Table structure for questdata
-- ----------------------------
CREATE TABLE `questdata` (
  `UserIndex` bigint(20) NOT NULL,
  `DoQuest` tinyint(4) NOT NULL,
  `QuestIndex` int(11) NOT NULL,
  `WorkCount` varchar(255) NOT NULL,
  `EnableQuestPerNPC` varchar(255) NOT NULL,
  `CountMob` varchar(255) NOT NULL,
  PRIMARY KEY (`UserIndex`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for mail
-- ----------------------------
CREATE TABLE `mail` (
  `UserIndex` bigint(20) DEFAULT NULL,
  `id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for adminuser
-- ----------------------------
CREATE TABLE `adminuser` (
  `UserIndex` varchar(30) NOT NULL,
  `UserPassword` varchar(50) NOT NULL,
  `CreateDate` datetime NOT NULL,
  `Notice` int(11) NOT NULL,
  `Startcastlewar` int(11) NOT NULL DEFAULT '0',
  `Stopcastlewar` int(11) NOT NULL DEFAULT '0',
  `Fillcard` int(11) NOT NULL DEFAULT '0',
  `Fillupcard` int(11) NOT NULL,
  `Fillawakecard` int(11) NOT NULL,
  `Fillfurycard` int(11) NOT NULL,
  `Giveitem` int(11) NOT NULL,
  `Grandarenastart` int(11) NOT NULL,
  `Incmoney` int(11) NOT NULL,
  `Setexp` int(11) NOT NULL,
  `Dropuser` int(11) NOT NULL,
  `Blockuser` int(11) NOT NULL,
  `NickName` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;