/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;


CREATE DATABASE IF NOT EXISTS `muserver065db`;
USE `muserver065db`;

--
-- Definition of table `accountcharacter`
--

DROP TABLE IF EXISTS `accountcharacter`;
CREATE TABLE `accountcharacter` (
  `Number` int(10) NOT NULL,
  `Id` varchar(10) NOT NULL,
  `GameID1` varchar(10) DEFAULT NULL,
  `GameID2` varchar(10) DEFAULT NULL,
  `GameID3` varchar(10) DEFAULT NULL,
  `GameID4` varchar(10) DEFAULT NULL,
  `GameID5` varchar(10) DEFAULT NULL,
  `GameIDC` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `accountcharacter`
--

/*!40000 ALTER TABLE `accountcharacter` DISABLE KEYS */;
INSERT INTO `accountcharacter` (`Number`,`Id`,`GameID1`,`GameID2`,`GameID3`,`GameID4`,`GameID5`,`GameIDC`) VALUES 
 (4,'admin','LUCIA','','',NULL,NULL,'LUCIA');
/*!40000 ALTER TABLE `accountcharacter` ENABLE KEYS */;


--
-- Definition of table `additemmodify`
--

DROP TABLE IF EXISTS `additemmodify`;
CREATE TABLE `additemmodify` (
  `Number` int(10) NOT NULL,
  `cType` tinyint(3) DEFAULT NULL,
  `IvenPos` tinyint(3) DEFAULT NULL,
  `bfLevel` tinyint(3) DEFAULT NULL,
  `bfOption1` tinyint(3) DEFAULT NULL,
  `bfOption2` tinyint(3) DEFAULT NULL,
  `bfOption3` tinyint(3) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `additemmodify`
--

/*!40000 ALTER TABLE `additemmodify` DISABLE KEYS */;
/*!40000 ALTER TABLE `additemmodify` ENABLE KEYS */;


--
-- Definition of table `admit_info`
--

DROP TABLE IF EXISTS `admit_info`;
CREATE TABLE `admit_info` (
  `Number` int(10) NOT NULL,
  `DemanderID` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
  `AdmiterID` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
  `SupervisorID` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
  `DemanderMemo` varchar(100) CHARACTER SET utf8 DEFAULT NULL,
  `AdmiterMemo` varchar(100) CHARACTER SET utf8 DEFAULT NULL,
  `SupervisorMemo` varchar(100) CHARACTER SET utf8 DEFAULT NULL,
  `MoreInfo` varchar(200) CHARACTER SET utf8 DEFAULT NULL,
  `AccountID` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
  `GameID` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
  `ServerNumber` smallint(5) DEFAULT NULL,
  `LinkTableType` int(10) DEFAULT NULL,
  `AdmitInfo` smallint(5) DEFAULT NULL,
  `SupervisorAdmitInfo` smallint(5) DEFAULT NULL,
  `ModifyDate` datetime DEFAULT NULL,
  `AdmitDate` datetime DEFAULT NULL,
  `SupervisorAdmitDate` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `admit_info`
--

/*!40000 ALTER TABLE `admit_info` DISABLE KEYS */;
/*!40000 ALTER TABLE `admit_info` ENABLE KEYS */;


--
-- Definition of table `blocking`
--

DROP TABLE IF EXISTS `blocking`;
CREATE TABLE `blocking` (
  `block_guid` int(10) NOT NULL,
  `memb_guid` int(10) NOT NULL,
  `serv_guid` int(10) NOT NULL,
  `char_name` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `take_code` varchar(1) CHARACTER SET utf8 NOT NULL,
  `take_cont` longtext NOT NULL,
  `memb_cont` longtext,
  `appl_days` varchar(8) CHARACTER SET utf8 NOT NULL,
  `rels_days` varchar(8) CHARACTER SET utf8 NOT NULL,
  `ctl1_code` varchar(1) CHARACTER SET utf8 NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `blocking`
--

/*!40000 ALTER TABLE `blocking` DISABLE KEYS */;
/*!40000 ALTER TABLE `blocking` ENABLE KEYS */;


--
-- Definition of table `blocking_log`
--

DROP TABLE IF EXISTS `blocking_log`;
CREATE TABLE `blocking_log` (
  `appl_days` datetime NOT NULL,
  `admin_guid` int(10) NOT NULL,
  `block_guid` int(10) NOT NULL,
  `dist_code` varchar(2) CHARACTER SET utf8 NOT NULL,
  `admin_name` varchar(50) CHARACTER SET utf8 NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `blocking_log`
--

/*!40000 ALTER TABLE `blocking_log` DISABLE KEYS */;
/*!40000 ALTER TABLE `blocking_log` ENABLE KEYS */;


--
-- Definition of table `charakter`
--

DROP TABLE IF EXISTS `charakter`;
CREATE TABLE `charakter` (
  `AccountID` varchar(10) NOT NULL,
  `Name` varchar(10) NOT NULL,
  `cLevel` smallint(5) DEFAULT '1',
  `LevelUpPoint` int(10) DEFAULT '0',
  `Class` tinyint(3) DEFAULT NULL,
  `Experience` int(10) DEFAULT '0',
  `Strength` smallint(5) DEFAULT NULL,
  `Dexterity` smallint(5) DEFAULT NULL,
  `Vitality` smallint(5) DEFAULT NULL,
  `Energy` smallint(5) DEFAULT NULL,
  `Inventory` mediumblob,
  `MagicList` varbinary(60) DEFAULT NULL,
  `Money` int(10) DEFAULT '0',
  `Life` float DEFAULT NULL,
  `MaxLife` float DEFAULT NULL,
  `Mana` float DEFAULT NULL,
  `MaxMana` float DEFAULT NULL,
  `MapNumber` smallint(5) DEFAULT NULL,
  `MapPosX` smallint(5) DEFAULT NULL,
  `MapPosY` smallint(5) DEFAULT NULL,
  `MapDir` tinyint(3) DEFAULT '0',
  `PkCount` int(10) DEFAULT '0',
  `PkLevel` int(10) DEFAULT '3',
  `PkTime` int(10) DEFAULT '0',
  `MDate` datetime DEFAULT NULL,
  `LDate` datetime DEFAULT NULL,
  PRIMARY KEY (`Name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `charakter`
--

/*!40000 ALTER TABLE `charakter` DISABLE KEYS */;
INSERT INTO `charakter` (`AccountID`,`Name`,`cLevel`,`LevelUpPoint`,`Class`,`Experience`,`Strength`,`Dexterity`,`Vitality`,`Energy`,`Inventory`,`MagicList`,`Money`,`Life`,`MaxLife`,`Mana`,`MaxMana`,`MapNumber`,`MapPosX`,`MapPosY`,`MapDir`,`PkCount`,`PkLevel`,`PkTime`,`MDate`,`LDate`) VALUES 
 ('admin','LUCIA',200,0,16,1400200,980,1000,250,100,0x0384FF000000000384FF000000007500FF000000008500FF000000009500FF00000000A500FF00000000B5080200000011FF000000000000D1005F00000000DD12320000001CFF000000000000FF000000000000DA00FD00000000DA08FE00000000DA10FF00000000DA18FF00000000DA20FD00000000DA28FC00000000FF000000000000E9000000000000FF0000000000008220020000001DFF000000000000A928FF0000001EFF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000A914020000001FFF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF00000000000068180300000020FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000,0x140000140000FF0000FF0000FF0000FF0000FF0000FF0000FF0000FF0000FF0000FF0000FF0000FF0000FF0000FF0000FF0000FF0000FF0000FF0000,22183976,1183,1183,209.5,209.5,2,220,63,4,0,3,0,'2008-12-31 15:27:00','2008-12-31 15:27:00');
/*!40000 ALTER TABLE `charakter` ENABLE KEYS */;


--
-- Definition of table `charinfomodify`
--

DROP TABLE IF EXISTS `charinfomodify`;
CREATE TABLE `charinfomodify` (
  `Number` int(10) NOT NULL,
  `cLevel` int(10) DEFAULT NULL,
  `LevelUpPoint` int(10) DEFAULT NULL,
  `Experience` int(10) DEFAULT NULL,
  `Strength` smallint(5) DEFAULT NULL,
  `Dexterity` smallint(5) DEFAULT NULL,
  `Vitality` smallint(5) DEFAULT NULL,
  `Energy` smallint(5) DEFAULT NULL,
  `Life` float DEFAULT NULL,
  `MaxLife` float DEFAULT NULL,
  `Mana` float DEFAULT NULL,
  `MaxMana` float DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `charinfomodify`
--

/*!40000 ALTER TABLE `charinfomodify` DISABLE KEYS */;
/*!40000 ALTER TABLE `charinfomodify` ENABLE KEYS */;


--
-- Definition of table `charinfomodifyorigin`
--

DROP TABLE IF EXISTS `charinfomodifyorigin`;
CREATE TABLE `charinfomodifyorigin` (
  `Number` int(10) NOT NULL,
  `cLevel` int(10) DEFAULT NULL,
  `LevelUpPoint` int(10) DEFAULT NULL,
  `Experience` int(10) DEFAULT NULL,
  `Strength` smallint(5) DEFAULT NULL,
  `Dexterity` smallint(5) DEFAULT NULL,
  `Vitality` smallint(5) DEFAULT NULL,
  `Energy` smallint(5) DEFAULT NULL,
  `Life` float DEFAULT NULL,
  `MaxLife` float DEFAULT NULL,
  `Mana` float DEFAULT NULL,
  `MaxMana` float DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `charinfomodifyorigin`
--

/*!40000 ALTER TABLE `charinfomodifyorigin` DISABLE KEYS */;
/*!40000 ALTER TABLE `charinfomodifyorigin` ENABLE KEYS */;


--
-- Definition of table `connblocklist`
--

DROP TABLE IF EXISTS `connblocklist`;
CREATE TABLE `connblocklist` (
  `AccountID` varchar(10) CHARACTER SET utf8 NOT NULL,
  `Memo` varchar(60) CHARACTER SET utf8 DEFAULT NULL,
  `BlockTime` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `connblocklist`
--

/*!40000 ALTER TABLE `connblocklist` DISABLE KEYS */;
/*!40000 ALTER TABLE `connblocklist` ENABLE KEYS */;


--
-- Definition of table `curr_info`
--

DROP TABLE IF EXISTS `curr_info`;
CREATE TABLE `curr_info` (
  `memb_guid` int(10) NOT NULL,
  `chek_code` varchar(1) CHARACTER SET utf8 NOT NULL,
  `ends_days` varchar(8) CHARACTER SET utf8 DEFAULT NULL,
  `used_time` varchar(50) DEFAULT NULL,
  `used___ip` varchar(50) DEFAULT NULL,
  `add___ip` varchar(50) DEFAULT NULL,
  `strt_days` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `comp_guid` char(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `curr_info`
--

/*!40000 ALTER TABLE `curr_info` DISABLE KEYS */;
/*!40000 ALTER TABLE `curr_info` ENABLE KEYS */;


--
-- Definition of table `delitemmodify`
--

DROP TABLE IF EXISTS `delitemmodify`;
CREATE TABLE `delitemmodify` (
  `Number` int(10) NOT NULL,
  `IvenPos` tinyint(3) DEFAULT NULL,
  `ItemIndex` tinyint(3) DEFAULT NULL,
  `cType` tinyint(3) DEFAULT NULL,
  `bfLevel` tinyint(3) DEFAULT NULL,
  `bfOption1` tinyint(3) DEFAULT NULL,
  `bfOption2` tinyint(3) DEFAULT NULL,
  `bfOption3` tinyint(3) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `delitemmodify`
--

/*!40000 ALTER TABLE `delitemmodify` DISABLE KEYS */;
/*!40000 ALTER TABLE `delitemmodify` ENABLE KEYS */;


--
-- Definition of table `depart_tbl`
--

DROP TABLE IF EXISTS `depart_tbl`;
CREATE TABLE `depart_tbl` (
  `dep_code` varchar(4) CHARACTER SET utf8 NOT NULL,
  `dep_name` varchar(60) CHARACTER SET utf8 NOT NULL,
  `dep_admin` varchar(15) CHARACTER SET utf8 NOT NULL,
  `dep_info` longtext
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `depart_tbl`
--

/*!40000 ALTER TABLE `depart_tbl` DISABLE KEYS */;
/*!40000 ALTER TABLE `depart_tbl` ENABLE KEYS */;


--
-- Definition of table `dtproperties`
--

DROP TABLE IF EXISTS `dtproperties`;
CREATE TABLE `dtproperties` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `objectid` int(10) DEFAULT NULL,
  `property` varchar(64) NOT NULL,
  `value` varchar(255) DEFAULT NULL,
  `uvalue` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `lvalue` longblob,
  `version` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`,`property`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `dtproperties`
--

/*!40000 ALTER TABLE `dtproperties` DISABLE KEYS */;
/*!40000 ALTER TABLE `dtproperties` ENABLE KEYS */;


--
-- Definition of table `fqnw_modi`
--

DROP TABLE IF EXISTS `fqnw_modi`;
CREATE TABLE `fqnw_modi` (
  `fanw_guid` int(10) NOT NULL,
  `memb_guid` int(10) NOT NULL,
  `appl_code` varchar(10) CHARACTER SET utf8 NOT NULL,
  `ctrl_text` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `fpas_ques` varchar(50) CHARACTER SET utf8 NOT NULL,
  `fpas_answ` varchar(50) CHARACTER SET utf8 NOT NULL,
  `appl_days` varchar(8) CHARACTER SET utf8 NOT NULL,
  `ctl1_code` varchar(1) CHARACTER SET utf8 NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `fqnw_modi`
--

/*!40000 ALTER TABLE `fqnw_modi` DISABLE KEYS */;
/*!40000 ALTER TABLE `fqnw_modi` ENABLE KEYS */;


--
-- Definition of table `gameserverinfo`
--

DROP TABLE IF EXISTS `gameserverinfo`;
CREATE TABLE `gameserverinfo` (
  `Number` int(10) NOT NULL DEFAULT '0',
  `ItemCount` int(10) DEFAULT '0',
  `ZenCount` int(10) DEFAULT '0',
  PRIMARY KEY (`Number`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `gameserverinfo`
--

/*!40000 ALTER TABLE `gameserverinfo` DISABLE KEYS */;
INSERT INTO `gameserverinfo` (`Number`,`ItemCount`,`ZenCount`) VALUES 
 (0,33,0);
/*!40000 ALTER TABLE `gameserverinfo` ENABLE KEYS */;


--
-- Definition of table `guild`
--

DROP TABLE IF EXISTS `guild`;
CREATE TABLE `guild` (
  `G_Name` varchar(8) NOT NULL,
  `G_Mark` varbinary(32) DEFAULT NULL,
  `G_Score` int(10) DEFAULT NULL,
  `G_Master` varchar(10) DEFAULT NULL,
  `G_Count` int(10) DEFAULT NULL,
  `G_Notice` varchar(60) DEFAULT NULL,
  `Number` int(10) NOT NULL,
  PRIMARY KEY (`G_Name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `guild`
--

/*!40000 ALTER TABLE `guild` DISABLE KEYS */;
/*!40000 ALTER TABLE `guild` ENABLE KEYS */;


--
-- Definition of table `guildmember`
--

DROP TABLE IF EXISTS `guildmember`;
CREATE TABLE `guildmember` (
  `Name` varchar(10) NOT NULL,
  `G_Name` varchar(8) NOT NULL,
  `G_Level` tinyint(3) DEFAULT NULL,
  PRIMARY KEY (`Name`),
  KEY `FK_GuildMember_Guild` (`G_Name`),
  CONSTRAINT `FK_GuildMember_Guild` FOREIGN KEY (`G_Name`) REFERENCES `guild` (`G_Name`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `guildmember`
--

/*!40000 ALTER TABLE `guildmember` DISABLE KEYS */;
/*!40000 ALTER TABLE `guildmember` ENABLE KEYS */;


--
-- Definition of table `ip_info`
--

DROP TABLE IF EXISTS `ip_info`;
CREATE TABLE `ip_info` (
  `ip_address` char(10) DEFAULT NULL,
  `jongyang_guid` char(15) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ip_info`
--

/*!40000 ALTER TABLE `ip_info` DISABLE KEYS */;
/*!40000 ALTER TABLE `ip_info` ENABLE KEYS */;


--
-- Definition of table `joinlog`
--

DROP TABLE IF EXISTS `joinlog`;
CREATE TABLE `joinlog` (
  `servername` char(10) DEFAULT NULL,
  `id` char(10) DEFAULT NULL,
  `state` char(10) DEFAULT NULL,
  `ip` char(10) DEFAULT NULL,
  `sdatetime` char(10) DEFAULT NULL,
  `edatetime` char(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `joinlog`
--

/*!40000 ALTER TABLE `joinlog` DISABLE KEYS */;
/*!40000 ALTER TABLE `joinlog` ENABLE KEYS */;


--
-- Definition of table `leav_memb`
--

DROP TABLE IF EXISTS `leav_memb`;
CREATE TABLE `leav_memb` (
  `leav_guid` int(10) NOT NULL,
  `memb_guid` int(10) NOT NULL,
  `appl_code` varchar(10) CHARACTER SET utf8 NOT NULL,
  `dist_code` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `memb_mail` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `ctrl_text` longtext,
  `cont_text` longtext NOT NULL,
  `prss_name` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `appl_days` varchar(8) CHARACTER SET utf8 NOT NULL,
  `ctl1_code` varchar(1) CHARACTER SET utf8 NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `leav_memb`
--

/*!40000 ALTER TABLE `leav_memb` DISABLE KEYS */;
/*!40000 ALTER TABLE `leav_memb` ENABLE KEYS */;


--
-- Definition of table `loveheart`
--

DROP TABLE IF EXISTS `loveheart`;
CREATE TABLE `loveheart` (
  `number` char(10) DEFAULT NULL,
  `heart_count` char(10) DEFAULT NULL,
  `id` char(10) DEFAULT NULL,
  `server` char(10) DEFAULT NULL,
  `name` char(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `loveheart`
--

/*!40000 ALTER TABLE `loveheart` DISABLE KEYS */;
/*!40000 ALTER TABLE `loveheart` ENABLE KEYS */;


--
-- Definition of table `loveheartall`
--

DROP TABLE IF EXISTS `loveheartall`;
CREATE TABLE `loveheartall` (
  `number` char(10) DEFAULT NULL,
  `id` char(10) DEFAULT NULL,
  `server` char(10) DEFAULT NULL,
  `name` char(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `loveheartall`
--

/*!40000 ALTER TABLE `loveheartall` DISABLE KEYS */;
/*!40000 ALTER TABLE `loveheartall` ENABLE KEYS */;


--
-- Definition of table `mang_info`
--

DROP TABLE IF EXISTS `mang_info`;
CREATE TABLE `mang_info` (
  `mang_guid` int(10) NOT NULL,
  `mang___id` varchar(15) CHARACTER SET utf8 NOT NULL,
  `mang__pwd` varchar(15) CHARACTER SET utf8 NOT NULL,
  `mang_name` varchar(20) CHARACTER SET utf8 NOT NULL,
  `mail_addr` varchar(50) CHARACTER SET utf8 NOT NULL,
  `levl_name` varchar(30) CHARACTER SET utf8 DEFAULT NULL,
  `part_name` varchar(30) CHARACTER SET utf8 DEFAULT NULL,
  `auth_code` varchar(30) CHARACTER SET utf8 DEFAULT NULL,
  `appl_days` varchar(8) CHARACTER SET utf8 NOT NULL,
  `ctl1_code` varchar(1) CHARACTER SET utf8 NOT NULL,
  `Group_code` varchar(2) CHARACTER SET utf8 DEFAULT NULL,
  `dep_code` varchar(4) CHARACTER SET utf8 NOT NULL,
  `perm` int(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `mang_info`
--

/*!40000 ALTER TABLE `mang_info` DISABLE KEYS */;
/*!40000 ALTER TABLE `mang_info` ENABLE KEYS */;


--
-- Definition of table `memb__out`
--

DROP TABLE IF EXISTS `memb__out`;
CREATE TABLE `memb__out` (
  `out__guid` int(10) NOT NULL,
  `memb_guid` int(10) NOT NULL,
  `sno__numb` varchar(7) CHARACTER SET utf8 DEFAULT NULL,
  `memb_name` varchar(15) CHARACTER SET utf8 DEFAULT NULL,
  `appl_days` datetime DEFAULT NULL,
  `ctl1_code` varchar(1) CHARACTER SET utf8 DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `memb__out`
--

/*!40000 ALTER TABLE `memb__out` DISABLE KEYS */;
/*!40000 ALTER TABLE `memb__out` ENABLE KEYS */;


--
-- Definition of table `memb_desc`
--

DROP TABLE IF EXISTS `memb_desc`;
CREATE TABLE `memb_desc` (
  `memb_guid` int(10) NOT NULL,
  `pant_name` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
  `pant_numb` varchar(13) CHARACTER SET utf8 DEFAULT NULL,
  `ptel_numb` varchar(20) CHARACTER SET utf8 DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `memb_desc`
--

/*!40000 ALTER TABLE `memb_desc` DISABLE KEYS */;
/*!40000 ALTER TABLE `memb_desc` ENABLE KEYS */;


--
-- Definition of table `memb_deta`
--

DROP TABLE IF EXISTS `memb_deta`;
CREATE TABLE `memb_deta` (
  `memb_guid` int(10) NOT NULL,
  `desc_text` longtext
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `memb_deta`
--

/*!40000 ALTER TABLE `memb_deta` DISABLE KEYS */;
/*!40000 ALTER TABLE `memb_deta` ENABLE KEYS */;


--
-- Definition of table `memb_info`
--

DROP TABLE IF EXISTS `memb_info`;
CREATE TABLE `memb_info` (
  `memb_guid` int(10) NOT NULL,
  `memb___id` varchar(10) CHARACTER SET utf8 NOT NULL,
  `memb__pwd` varchar(10) CHARACTER SET utf8 NOT NULL,
  `memb_name` varchar(10) CHARACTER SET utf8 NOT NULL,
  `sno__numb` varchar(13) CHARACTER SET utf8 NOT NULL,
  `post_code` varchar(6) CHARACTER SET utf8 DEFAULT NULL,
  `addr_info` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `addr_deta` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `tel__numb` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `phon_numb` varchar(15) CHARACTER SET utf8 DEFAULT NULL,
  `mail_addr` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `fpas_ques` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `fpas_answ` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `job__code` varchar(2) CHARACTER SET utf8 DEFAULT NULL,
  `appl_days` datetime DEFAULT NULL,
  `modi_days` datetime DEFAULT NULL,
  `out__days` datetime DEFAULT NULL,
  `true_days` datetime DEFAULT NULL,
  `mail_chek` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `bloc_code` varchar(1) CHARACTER SET utf8 NOT NULL,
  `ctl1_code` varchar(1) CHARACTER SET utf8 NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `memb_info`
--

/*!40000 ALTER TABLE `memb_info` DISABLE KEYS */;
INSERT INTO `memb_info` (`memb_guid`,`memb___id`,`memb__pwd`,`memb_name`,`sno__numb`,`post_code`,`addr_info`,`addr_deta`,`tel__numb`,`phon_numb`,`mail_addr`,`fpas_ques`,`fpas_answ`,`job__code`,`appl_days`,`modi_days`,`out__days`,`true_days`,`mail_chek`,`bloc_code`,`ctl1_code`) VALUES 
 (1,'admin','admin','Lucia','123456','123','123','123','123','123','luciaaibarblanco@gmail.com','sex','male','1 ','2009-01-01 00:00:00','2009-01-01 00:00:00','2009-01-01 00:00:00','2009-01-01 00:00:00','1','0','0');
/*!40000 ALTER TABLE `memb_info` ENABLE KEYS */;


--
-- Definition of table `memb_notice`
--

DROP TABLE IF EXISTS `memb_notice`;
CREATE TABLE `memb_notice` (
  `notice_guid` int(10) NOT NULL,
  `memb___id` varchar(10) CHARACTER SET utf8 NOT NULL,
  `notice_count` int(10) DEFAULT NULL,
  `notice` varchar(60) CHARACTER SET utf8 DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `memb_notice`
--

/*!40000 ALTER TABLE `memb_notice` DISABLE KEYS */;
/*!40000 ALTER TABLE `memb_notice` ENABLE KEYS */;


--
-- Definition of table `memb_stat`
--

DROP TABLE IF EXISTS `memb_stat`;
CREATE TABLE `memb_stat` (
  `memb___id` varchar(10) CHARACTER SET utf8 NOT NULL,
  `ConnectStat` tinyint(3) DEFAULT NULL,
  `ServerName` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `IP` varchar(15) CHARACTER SET utf8 DEFAULT NULL,
  `ConnectTM` datetime DEFAULT NULL,
  `DisConnectTM` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `memb_stat`
--

/*!40000 ALTER TABLE `memb_stat` DISABLE KEYS */;
/*!40000 ALTER TABLE `memb_stat` ENABLE KEYS */;


--
-- Definition of table `membinfomodify`
--

DROP TABLE IF EXISTS `membinfomodify`;
CREATE TABLE `membinfomodify` (
  `Number` int(10) NOT NULL,
  `memb___id` varchar(10) CHARACTER SET utf8 NOT NULL,
  `memb__pwd` varchar(10) CHARACTER SET utf8 NOT NULL,
  `memb_name` varchar(10) CHARACTER SET utf8 NOT NULL,
  `sno__numb` varchar(13) CHARACTER SET utf8 NOT NULL,
  `tel__numb` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `phon_numb` varchar(15) CHARACTER SET utf8 DEFAULT NULL,
  `mail_addr` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `fpas_ques` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `fpas_answ` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `bloc_code` varchar(1) CHARACTER SET utf8 DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `membinfomodify`
--

/*!40000 ALTER TABLE `membinfomodify` DISABLE KEYS */;
/*!40000 ALTER TABLE `membinfomodify` ENABLE KEYS */;


--
-- Definition of table `membinfomodifyorigin`
--

DROP TABLE IF EXISTS `membinfomodifyorigin`;
CREATE TABLE `membinfomodifyorigin` (
  `Number` int(10) NOT NULL,
  `memb___id` varchar(10) CHARACTER SET utf8 NOT NULL,
  `memb__pwd` varchar(10) CHARACTER SET utf8 NOT NULL,
  `memb_name` varchar(10) CHARACTER SET utf8 NOT NULL,
  `sno__numb` varchar(13) CHARACTER SET utf8 NOT NULL,
  `tel__numb` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `phon_numb` varchar(15) CHARACTER SET utf8 DEFAULT NULL,
  `mail_addr` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `fpas_ques` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `fpas_answ` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `bloc_code` varchar(1) CHARACTER SET utf8 DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `membinfomodifyorigin`
--

/*!40000 ALTER TABLE `membinfomodifyorigin` DISABLE KEYS */;
/*!40000 ALTER TABLE `membinfomodifyorigin` ENABLE KEYS */;


--
-- Definition of table `mids_info`
--

DROP TABLE IF EXISTS `mids_info`;
CREATE TABLE `mids_info` (
  `mids_guid` int(10) NOT NULL,
  `memb_guid` int(10) NOT NULL,
  `chek_code` varchar(1) CHARACTER SET utf8 NOT NULL,
  `prev_info` varchar(50) CHARACTER SET utf8 NOT NULL,
  `modi_info` varchar(10) CHARACTER SET utf8 NOT NULL,
  `cont_text` longtext NOT NULL,
  `admin_name` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
  `appl_days` varchar(8) CHARACTER SET utf8 NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `mids_info`
--

/*!40000 ALTER TABLE `mids_info` DISABLE KEYS */;
/*!40000 ALTER TABLE `mids_info` ENABLE KEYS */;


--
-- Definition of table `mnglog`
--

DROP TABLE IF EXISTS `mnglog`;
CREATE TABLE `mnglog` (
  `Number` int(10) NOT NULL,
  `ID` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
  `IP` varchar(16) CHARACTER SET utf8 DEFAULT NULL,
  `ModifyDate` datetime DEFAULT NULL,
  `LogType` smallint(5) DEFAULT NULL,
  `LogText` varchar(100) CHARACTER SET utf8 DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `mnglog`
--

/*!40000 ALTER TABLE `mnglog` DISABLE KEYS */;
/*!40000 ALTER TABLE `mnglog` ENABLE KEYS */;


--
-- Definition of table `mngmodifylog`
--

DROP TABLE IF EXISTS `mngmodifylog`;
CREATE TABLE `mngmodifylog` (
  `Number` int(10) NOT NULL,
  `ManagerID` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
  `AccountId` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
  `GameID` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
  `servernumber` tinyint(3) DEFAULT NULL,
  `IP` varchar(16) CHARACTER SET utf8 DEFAULT NULL,
  `ModifyDate` datetime DEFAULT NULL,
  `LogType` smallint(5) DEFAULT NULL,
  `LogText` varchar(100) CHARACTER SET utf8 DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `mngmodifylog`
--

/*!40000 ALTER TABLE `mngmodifylog` DISABLE KEYS */;
/*!40000 ALTER TABLE `mngmodifylog` ENABLE KEYS */;


--
-- Definition of table `mumng_auth_skill`
--

DROP TABLE IF EXISTS `mumng_auth_skill`;
CREATE TABLE `mumng_auth_skill` (
  `auth_guid` int(10) NOT NULL,
  `mang_guid` int(10) NOT NULL,
  `auth_code` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `skill_guid` int(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `mumng_auth_skill`
--

/*!40000 ALTER TABLE `mumng_auth_skill` DISABLE KEYS */;
/*!40000 ALTER TABLE `mumng_auth_skill` ENABLE KEYS */;


--
-- Definition of table `mumng_mang_info`
--

DROP TABLE IF EXISTS `mumng_mang_info`;
CREATE TABLE `mumng_mang_info` (
  `mang_guid` int(10) NOT NULL,
  `mng_auth` tinyint(3) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `mumng_mang_info`
--

/*!40000 ALTER TABLE `mumng_mang_info` DISABLE KEYS */;
/*!40000 ALTER TABLE `mumng_mang_info` ENABLE KEYS */;


--
-- Definition of table `mumng_skill_info`
--

DROP TABLE IF EXISTS `mumng_skill_info`;
CREATE TABLE `mumng_skill_info` (
  `skill_guid` int(10) NOT NULL,
  `name` varchar(15) CHARACTER SET utf8 DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `mumng_skill_info`
--

/*!40000 ALTER TABLE `mumng_skill_info` DISABLE KEYS */;
/*!40000 ALTER TABLE `mumng_skill_info` ENABLE KEYS */;


--
-- Definition of table `t_bill_section`
--

DROP TABLE IF EXISTS `t_bill_section`;
CREATE TABLE `t_bill_section` (
  `Bill_Start_Date` char(10) DEFAULT NULL,
  `Bill_End_Date` char(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `t_bill_section`
--

/*!40000 ALTER TABLE `t_bill_section` DISABLE KEYS */;
INSERT INTO `t_bill_section` (`Bill_Start_Date`,`Bill_End_Date`) VALUES 
 ('20021230','20031230');
/*!40000 ALTER TABLE `t_bill_section` ENABLE KEYS */;


--
-- Definition of table `use_time`
--

DROP TABLE IF EXISTS `use_time`;
CREATE TABLE `use_time` (
  `use_minute` char(10) DEFAULT NULL,
  `use_month` char(10) DEFAULT NULL,
  `use_year` char(10) DEFAULT NULL,
  `jongyang_guid` char(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `use_time`
--

/*!40000 ALTER TABLE `use_time` DISABLE KEYS */;
/*!40000 ALTER TABLE `use_time` ENABLE KEYS */;


--
-- Definition of table `uuid_loginname_map`
--

DROP TABLE IF EXISTS `uuid_loginname_map`;
CREATE TABLE `uuid_loginname_map` (
  `uuid` varchar(12) CHARACTER SET utf8 NOT NULL,
  `loginname` varchar(12) CHARACTER SET utf8 NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `uuid_loginname_map`
--

/*!40000 ALTER TABLE `uuid_loginname_map` DISABLE KEYS */;
/*!40000 ALTER TABLE `uuid_loginname_map` ENABLE KEYS */;


--
-- Definition of table `vi_fqnw_info`
--

DROP TABLE IF EXISTS `vi_fqnw_info`;
CREATE TABLE `vi_fqnw_info` (
  `appl_code` varchar(10) CHARACTER SET utf8 NOT NULL,
  `ctrl_text` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `fpas_ques` varchar(50) CHARACTER SET utf8 NOT NULL,
  `fpas_answ` varchar(50) CHARACTER SET utf8 NOT NULL,
  `appl_days` varchar(8) CHARACTER SET utf8 NOT NULL,
  `ctl1_code` varchar(1) CHARACTER SET utf8 NOT NULL,
  `memb_name` varchar(10) CHARACTER SET utf8 NOT NULL,
  `memb_guid` int(10) NOT NULL,
  `fanw_guid` int(10) NOT NULL,
  `memb___id` varchar(10) CHARACTER SET utf8 NOT NULL,
  `sno__numb` varchar(13) CHARACTER SET utf8 NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `vi_fqnw_info`
--

/*!40000 ALTER TABLE `vi_fqnw_info` DISABLE KEYS */;
/*!40000 ALTER TABLE `vi_fqnw_info` ENABLE KEYS */;


--
-- Definition of table `vi_leav_info`
--

DROP TABLE IF EXISTS `vi_leav_info`;
CREATE TABLE `vi_leav_info` (
  `ctl1_code` varchar(1) CHARACTER SET utf8 NOT NULL,
  `appl_days` varchar(8) CHARACTER SET utf8 NOT NULL,
  `cont_text` longtext NOT NULL,
  `ctrl_text` longtext,
  `appl_code` varchar(10) CHARACTER SET utf8 NOT NULL,
  `leav_guid` int(10) NOT NULL,
  `memb_name` varchar(10) CHARACTER SET utf8 NOT NULL,
  `memb_guid` int(10) NOT NULL,
  `memb_mail` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `sno__numb` varchar(13) CHARACTER SET utf8 NOT NULL,
  `dist_code` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `prss_name` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `memb___id` varchar(10) CHARACTER SET utf8 NOT NULL,
  `tel__numb` varchar(20) CHARACTER SET utf8 DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `vi_leav_info`
--

/*!40000 ALTER TABLE `vi_leav_info` DISABLE KEYS */;
/*!40000 ALTER TABLE `vi_leav_info` ENABLE KEYS */;


--
-- Definition of table `vi_mids_info`
--

DROP TABLE IF EXISTS `vi_mids_info`;
CREATE TABLE `vi_mids_info` (
  `memb___id` varchar(10) CHARACTER SET utf8 NOT NULL,
  `memb_name` varchar(10) CHARACTER SET utf8 NOT NULL,
  `sno__numb` varchar(13) CHARACTER SET utf8 NOT NULL,
  `appl_days` varchar(8) CHARACTER SET utf8 NOT NULL,
  `chek_code` varchar(1) CHARACTER SET utf8 NOT NULL,
  `prev_info` varchar(50) CHARACTER SET utf8 NOT NULL,
  `modi_info` varchar(10) CHARACTER SET utf8 NOT NULL,
  `cont_text` longtext NOT NULL,
  `mids_guid` int(10) NOT NULL,
  `admin_name` varchar(10) CHARACTER SET utf8 DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `vi_mids_info`
--

/*!40000 ALTER TABLE `vi_mids_info` DISABLE KEYS */;
/*!40000 ALTER TABLE `vi_mids_info` ENABLE KEYS */;


--
-- Definition of table `warehouse`
--

DROP TABLE IF EXISTS `warehouse`;
CREATE TABLE `warehouse` (
  `AccountID` varchar(10) NOT NULL,
  `Items` mediumblob,
  `Money` int(10) DEFAULT '0',
  `EndUseDate` datetime DEFAULT NULL,
  PRIMARY KEY (`AccountID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `warehouse`
--

/*!40000 ALTER TABLE `warehouse` DISABLE KEYS */;
INSERT INTO `warehouse` (`AccountID`,`Items`,`Money`,`EndUseDate`) VALUES 
 ('admin',0xFF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000FF000000000000,0,'2008-12-31 18:42:00');
/*!40000 ALTER TABLE `warehouse` ENABLE KEYS */;




/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
