· 8 years ago · Apr 05, 2018, 06:14 PM
1/*
2Navicat MySQL Data Transfer
3
4Source Server : Agora
5Source Server Version : 50505
6Source Host : mysql-agora-server.alwaysdata.net:3306
7Source Database : agora-server_mmfr2_member
8
9Target Server Type : MYSQL
10Target Server Version : 50505
11File Encoding : 65001
12
13Date: 2018-04-02 17:12:02
14*/
15
16SET FOREIGN_KEY_CHECKS=0;
17-- ----------------------------
18-- Table structure for `changepassword`
19-- ----------------------------
20DROP TABLE IF EXISTS `changepassword`;
21CREATE TABLE `changepassword` (
22 `AdminID` varchar(12) NOT NULL DEFAULT '',
23 `id_idx` int(11) DEFAULT NULL,
24 `PlayerID` varchar(12) NOT NULL DEFAULT '',
25 `Passwd` varchar(30) NOT NULL DEFAULT '',
26 `RegDate` datetime NOT NULL,
27 KEY `NewIndex` (`PlayerID`,`AdminID`) USING BTREE
28) ENGINE=MyISAM DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
29
30-- ----------------------------
31-- Records of changepassword
32-- ----------------------------
33
34-- ----------------------------
35-- Table structure for `distraint`
36-- ----------------------------
37DROP TABLE IF EXISTS `distraint`;
38CREATE TABLE `distraint` (
39 `Num` int(10) unsigned NOT NULL AUTO_INCREMENT,
40 `id_idx` int(10) unsigned NOT NULL DEFAULT '0',
41 `PlayerID` varchar(12) NOT NULL DEFAULT '',
42 `CPPlayerID` varchar(20) NOT NULL DEFAULT '',
43 `CPCode` tinyint(3) unsigned NOT NULL DEFAULT '0',
44 `AdminID` varchar(20) NOT NULL DEFAULT '',
45 `BlockType` enum('WEB','GAME','SUM') NOT NULL DEFAULT 'GAME',
46 `Access` enum('ALLOW','DENY') NOT NULL DEFAULT 'ALLOW',
47 `CharName` varchar(20) DEFAULT NULL,
48 `ServerName` varchar(50) DEFAULT NULL,
49 `Subject` varchar(255) NOT NULL DEFAULT '',
50 `Content` text NOT NULL,
51 `StartDate` datetime NOT NULL,
52 `EndDate` datetime NOT NULL,
53 `RegDate` datetime NOT NULL,
54 `B_Flag` enum('Y','N') NOT NULL DEFAULT 'Y',
55 `BlockTypeNum` int(11) DEFAULT '0',
56 PRIMARY KEY (`Num`) USING BTREE,
57 KEY `id_idx` (`id_idx`) USING BTREE,
58 KEY `PlayerID` (`PlayerID`) USING BTREE
59) ENGINE=MyISAM DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
60
61-- ----------------------------
62-- Records of distraint
63-- ----------------------------
64
65-- ----------------------------
66-- Table structure for `management`
67-- ----------------------------
68DROP TABLE IF EXISTS `management`;
69CREATE TABLE `management` (
70 `Num` int(10) unsigned NOT NULL AUTO_INCREMENT,
71 `AdminID` varchar(20) NOT NULL DEFAULT '',
72 `Passwd` varchar(30) NOT NULL DEFAULT '',
73 `Name` varchar(30) NOT NULL DEFAULT '',
74 `Team` varchar(30) NOT NULL DEFAULT '',
75 `Jigham` varchar(30) NOT NULL DEFAULT '',
76 `Email` varchar(30) NOT NULL DEFAULT '',
77 `ZipCode` varchar(7) NOT NULL DEFAULT '',
78 `Address` varchar(255) NOT NULL DEFAULT '',
79 `Tphone` varchar(20) NOT NULL DEFAULT '',
80 `Cphone` varchar(20) NOT NULL DEFAULT '',
81 `StartDate` date NOT NULL,
82 `EndDate` date NOT NULL,
83 `Access` tinyint(4) NOT NULL DEFAULT '10',
84 `Flag` enum('Y','N') NOT NULL DEFAULT 'Y',
85 `nCount` int(10) unsigned NOT NULL DEFAULT '0',
86 `LoginIP` varchar(15) DEFAULT NULL,
87 `LastLoginDate` datetime DEFAULT NULL,
88 `RegDate` datetime NOT NULL,
89 PRIMARY KEY (`Num`) USING BTREE
90) ENGINE=MyISAM DEFAULT CHARSET=euckr ROW_FORMAT=DYNAMIC;
91
92-- ----------------------------
93-- Records of management
94-- ----------------------------
95
96-- ----------------------------
97-- Table structure for `player`
98-- ----------------------------
99DROP TABLE IF EXISTS `player`;
100CREATE TABLE `player` (
101 `id_idx` int(10) unsigned NOT NULL AUTO_INCREMENT,
102 `PlayerID` varchar(20) NOT NULL DEFAULT '',
103 `Passwd` varchar(30) NOT NULL DEFAULT '',
104 `Passwd_Q` char(2) DEFAULT NULL,
105 `Passwd_A` varchar(64) DEFAULT NULL,
106 `Name` varchar(20) NOT NULL DEFAULT '',
107 `JuminNo` varchar(20) NOT NULL DEFAULT '',
108 `nYear` varchar(4) NOT NULL DEFAULT '',
109 `nMonth` char(2) NOT NULL DEFAULT '',
110 `nDay` char(2) DEFAULT NULL,
111 `Sex` enum('1','2') NOT NULL DEFAULT '1',
112 `TelePhone1` varchar(255) DEFAULT NULL,
113 `TelePhone2` varchar(4) NOT NULL DEFAULT '',
114 `TelePhone3` varchar(4) NOT NULL DEFAULT '',
115 `CPhone1` varchar(13) DEFAULT NULL,
116 `CPhone2` varchar(4) NOT NULL DEFAULT '',
117 `CPhone3` varchar(4) NOT NULL DEFAULT '',
118 `ZipCode` varchar(10) NOT NULL DEFAULT '',
119 `AddressDo` varchar(20) DEFAULT NULL,
120 `AddressSi` varchar(30) DEFAULT NULL,
121 `AddressDong` varchar(50) DEFAULT NULL,
122 `AddressEtc` varchar(100) DEFAULT NULL,
123 `Address` varchar(255) DEFAULT NULL,
124 `Email` varchar(64) DEFAULT NULL,
125 `JobType` char(2) DEFAULT NULL,
126 `SchoolName` varchar(100) DEFAULT NULL,
127 `Access` tinyint(4) unsigned NOT NULL DEFAULT '21',
128 `Block` enum('ALLOW','GAME','WEB','SUM','SECEDER','WAIT') DEFAULT 'ALLOW',
129 `LoginIP` varchar(15) DEFAULT NULL,
130 `NewsLetter` enum('0','1') DEFAULT '1',
131 `ParentName` varchar(20) DEFAULT NULL,
132 `ParentJuminNo` varchar(20) DEFAULT NULL,
133 `ParentPhone1` varchar(13) DEFAULT NULL,
134 `ParentPhone2` varchar(4) NOT NULL DEFAULT '',
135 `ParentPhone3` varchar(4) NOT NULL DEFAULT '',
136 `LastLoginDate` datetime DEFAULT NULL,
137 `SecederDate` datetime DEFAULT NULL,
138 `PayPlayDate` datetime DEFAULT NULL,
139 `PayPlayHours` int(11) unsigned DEFAULT '0',
140 `RegDate` datetime NOT NULL,
141 `OldBlock` enum('ALLOW','GAME','WEB','SUM','SECEDER','WAIT') NOT NULL DEFAULT 'ALLOW',
142 `ssoChk` char(1) DEFAULT NULL,
143 `AuthCheck` enum('AUTH_OK','AUTH_WAIT','AUTH_CHECK') NOT NULL DEFAULT 'AUTH_OK',
144 `AuthTimeLimit` datetime NOT NULL,
145 `LoginState` tinyint(1) unsigned NOT NULL DEFAULT '0',
146 `personal_auth` char(1) DEFAULT 'N',
147 `Accesschecktype` int(11) DEFAULT '0',
148 `PlayerNickName` varchar(30) DEFAULT NULL,
149 `PlayerGameServer` varchar(15) DEFAULT NULL,
150 `WpId` int(11) DEFAULT NULL,
151 `FbId` varchar(100) DEFAULT NULL,
152 `EP` int(32) NOT NULL,
153 `EPTotal` varchar(255) DEFAULT NULL,
154 `Parrain` varchar(25) DEFAULT NULL,
155 `avatar` int(1) NOT NULL,
156 `IP` varchar(255) DEFAULT NULL,
157 `token` varchar(255) DEFAULT NULL,
158 `isValidateToken` int(1) NOT NULL,
159 `SuperMark` int(10) NOT NULL,
160 `membre_post` int(11) NOT NULL,
161 `forum_level` int(11) NOT NULL,
162 `actif_forum` int(1) NOT NULL DEFAULT '0',
163 `forum_nickname` varchar(255) NOT NULL DEFAULT '0',
164 PRIMARY KEY (`id_idx`,`RegDate`) USING BTREE,
165 UNIQUE KEY `PlayerID` (`PlayerID`) USING BTREE,
166 KEY `p_index1` (`PlayerID`,`JuminNo`,`Block`,`RegDate`) USING BTREE,
167 KEY `RegDate` (`RegDate`) USING BTREE,
168 KEY `g_JuminNo` (`JuminNo`,`Block`,`id_idx`) USING BTREE,
169 KEY `SchoolName` (`SchoolName`) USING BTREE,
170 KEY `Name` (`Name`) USING BTREE,
171 KEY `WpId` (`WpId`) USING BTREE
172) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
173
174-- ----------------------------
175-- Records of player
176-- ----------------------------
177INSERT INTO `player` VALUES ('1', 'test', 'test', null, null, '', '', '', '', null, '1', null, '', '', null, '', '', '', null, null, null, null, null, null, null, null, '21', 'ALLOW', null, '1', null, null, null, '', '', null, null, null, '0', '0000-00-00 00:00:00', 'ALLOW', null, 'AUTH_OK', '0000-00-00 00:00:00', '0', 'N', '0', null, null, null, null, '200', null, null, '0', null, null, '0', '0', '0', '0', '0', '0');
178
179-- ----------------------------
180-- Table structure for `player_wait`
181-- ----------------------------
182DROP TABLE IF EXISTS `player_wait`;
183CREATE TABLE `player_wait` (
184 `PlayerID` varchar(12) NOT NULL DEFAULT '',
185 `id_idx` int(10) NOT NULL DEFAULT '0',
186 `Block` enum('ALLOW','GAME','WEB','SUM','SECEDER','WAIT') NOT NULL DEFAULT 'ALLOW',
187 `SecederDate` datetime NOT NULL,
188 `HandlingDate` datetime NOT NULL,
189 `OldBlock` enum('ALLOW','GAME','WEB','SUM','SECEDER','WAIT') NOT NULL DEFAULT 'ALLOW',
190 PRIMARY KEY (`PlayerID`) USING BTREE
191) ENGINE=MyISAM DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC COMMENT='Å»Åð´ë±âÀÚ';
192
193-- ----------------------------
194-- Records of player_wait
195-- ----------------------------