11-17-2012, 11:44 AM
Here i give u all Usefull Sql Codes, that you maybe need on Ep2!
Please give me a thanks if you like this !
How to use this Codes?
1. Open Navicat (2 )
2. Open Connection + your Database (for example i choose newproject_data) ( 2)
3. Right click on newproject_data -> Console (2)
4. Now Copy and Paste the Code in this Box and klick Enter. (For Example it should show like this (2)
5. Done Have Fun!
Exp- / Skillpoint- / Gold- / Drop Rate
Exp Rate:
UPDATE t_npc SET a_exp = a_exp * 1;
Replace 1 with the Rate that you would have. (thanks Gothic) (newproject_data)
Skillpoint Rate:
UPDATE t_npc SET a_skill_point = a_skill_point * 1;
Replace 1 with the Rate that you would have. (thanks Gothic) (newproject_data)
Gold Drop Rate
UPDATE t_npc SET a_prize = a_prize * 1;
Replace 1 with the Rate that you would have. (thanks Gothic) (newproject_data)
Item Drop Rate
UPDATE t_npc SET a_item_percent_0 = a_item_percent_0 * 1;
UPDATE t_npc SET a_item_percent_1 = a_item_percent_1 * 1;
UPDATE t_npc SET a_item_percent_2 = a_item_percent_2 * 1;
UPDATE t_npc SET a_item_percent_3 = a_item_percent_3 * 1;
UPDATE t_npc SET a_item_percent_4 = a_item_percent_4 * 1;
UPDATE t_npc SET a_item_percent_5 = a_item_percent_5 * 1;
UPDATE t_npc SET a_item_percent_6 = a_item_percent_6 * 1;
UPDATE t_npc SET a_item_percent_7 = a_item_percent_7 * 1;
UPDATE t_npc SET a_item_percent_8 = a_item_percent_8 * 1;
UPDATE t_npc SET a_item_percent_9 = a_item_percent_9 * 1;
UPDATE t_npc SET a_item_percent_10 = a_item_percent_10 * 1;
UPDATE t_npc SET a_item_percent_11 = a_item_percent_11 * 1;
UPDATE t_npc SET a_item_percent_12 = a_item_percent_12 * 1;
UPDATE t_npc SET a_item_percent_13 = a_item_percent_13 * 1;
UPDATE t_npc SET a_item_percent_14 = a_item_percent_14 * 1;
UPDATE t_npc SET a_item_percent_15 = a_item_percent_15 * 1
UPDATE t_npc SET a_item_percent_16 = a_item_percent_16 * 1;
UPDATE t_npc SET a_item_percent_17 = a_item_percent_17 * 1;
UPDATE t_npc SET a_item_percent_18 = a_item_percent_18 * 1;
UPDATE t_npc SET a_item_percent_19 = a_item_percent_19 * 1;
Replace 1 with the Rate that you would have. (thanks Gothic) (newproject_data)
Enable some Special Features of your Database:
Enable all Npc & Monster:
UPDATE t_npc SET a_enable = 1;
This Code Enable all Monster and Npc in your Database. (newproject_data)
Enable all Events:
UPDATE t_eventsettings SET a_enable = 1;
This Code Enable all Events in your Database. (newproject_data)
Enable all Pet Quest:
UPDATE t_quest_pet SET a_enable = 1;
This Code Enable all Pet Quest in your Database. (newproject_data)
Enable all P2-Pet:
UPDATE t_bigpet SET a_enable = 1;
This Code Enable all P2-Pet in your Database. (newproject_data)
Enable all Quest:
UPDATE t_quest SET a_enable = 1;
This Code Enable all Quest in your Database. (newproject_data)
Enable all Item:
UPDATE t_item SET a_enable = 1;
This Code Enable all Item in your Database. (newproject_data)
Enable all Affinity System:
UPDATE t_affinity SET a_enable = 1;
UPDATE t_affinity_work SET a_enable = 1;
UPDATE t_affinity_npc SET a_enable = 1;
This Code Enable all Affinity System in your Database. (newproject_data)
Some other usefull Codes:
Min/Max + on Dropps:
UPDATE t_npc SET a_minplus = a_minplus +1;
UPDATE t_npc SET a_maxplus = a_maxplus +1;
UPDATE t_npc SET a_probplus = 10000;
This Code let manage your minimal and maximal + on drops (newproject_data)
Drop by every Monster Heaven Stone:
UPDATE t_npc SET a_item_1 = 85;
This Code set drop Number 1 to Heaven Stone (newproject_data)
Drop by every Monster Chaos Smelting Stone:
UPDATE t_npc SET a_item_1 = 2844;
This Code set drop Number 1 to Chaos Smelting Stone (newproject_data)
Exp Guild Bug Fixx:
Dont have the Code yet, if you have it post it here!
This code fix the Guild Exp Bug!
(newproject_db)
Set Quest Experience:
UPDATE t_quest SET a_prize_data0 = a_prize_data0*1 WHERE a_prize_index0 = 0 and a_prize_type0 = 2 ;
UPDATE t_quest SET a_prize_data1 = a_prize_data1*1 WHERE a_prize_index1 = 0 and a_prize_type1 = 2 ;
UPDATE t_quest SET a_prize_data2 = a_prize_data2*1 WHERE a_prize_index2 = 0 and a_prize_type2 = 2 ;
This Code let manage you the Quest Experience Replace 1 with the number of Exp Rate that you would to have (thanks for code filix_93 )
(newproject_data)
All player max Skillpoint:
UPDATE t_characters SET a_skill_point = 200000000;
This code give all Players maximal Skillpoint![/b]
(newproject_db)
Fix the Lacaball bug:
INSERT INTO `t_lcball` (`a_item_order`, `a_tocken_index`, `a_course_code`, `a_order`, `a_item_index`, `a_item_count`, `a_item_max`, `a_item_remain`) VALUES
(1, 5124, 0, 0, 1416, 10, 1, 1),
(1, 5124, 0, 1, 2357, 5, 100, 97),
(1, 5124, 0, 2, 2356, 5, 200, 198),
(1, 5124, 0, 3, 2394, 1, 300, 293),
(1, 5124, 0, 4, 972, 1, 700, 683),
(1, 5124, 1, 0, 2844, 10, 1, 1),
(1, 5124, 1, 1, 2395, 5, 10, 10),
(1, 5124, 1, 2, 2845, 2, 20, 19),
(1, 5124, 1, 3, 2853, 1, 50, 50),
(1, 5124, 1, 4, 1284, 3, 500, 493),
(1, 5124, 2, 0, 6421, 1, 5, 5),
(1, 5124, 2, 1, 6227, 3, 100, 98),
(1, 5124, 2, 2, 2453, 2, 300, 298),
(1, 5124, 2, 3, 852, 10, 500, 500),
(1, 5124, 2, 4, 2858, 1, 700, 696),
(2, 6653, 0, 0, 5293, 1, 1, 1),
(2, 6653, 0, 1, 5292, 1, 5, 5),
(2, 6653, 0, 2, 5291, 1, 10, 10),
(2, 6653, 0, 3, 5290, 1, 300, 300),
(2, 6653, 0, 4, 5289, 1, 3000, 3000),
(2, 6653, 1, 0, 5268, 1, 1, 1),
(2, 6653, 1, 1, 5267, 1, 5, 5),
(2, 6653, 1, 2, 5266, 1, 10, 10),
(2, 6653, 1, 3, 5265, 1, 300, 300),
(2, 6653, 1, 4, 5264, 1, 3000, 3000),
(2, 6653, 2, 0, 5298, 1, 1, 1),
(2, 6653, 2, 1, 5297, 1, 5, 5),
(2, 6653, 2, 2, 5296, 1, 10, 10),
(2, 6653, 2, 3, 5295, 1, 300, 300),
(2, 6653, 2, 4, 5294, 1, 3000, 3000),
(0, 5123, 0, 0, 5124, 15, 3, 3),
(0, 5123, 0, 1, 6921, 3, 10, 10),
(0, 5123, 0, 2, 882, 15, 30, 30),
(0, 5123, 0, 3, 85, 5, 50, 48),
(0, 5123, 0, 4, 19, 50000, 500, 497),
(0, 5123, 1, 0, 1416, 3, 1, 1),
(0, 5123, 1, 1, 2889, 3, 100, 94),
(0, 5123, 1, 2, 883, 5, 350, 347),
(0, 5123, 1, 3, 85, 5, 500, 492),
(0, 5123, 1, 4, 723, 5, 1000, 978),
(0, 5123, 2, 0, 974, 5, 1, 1),
(0, 5123, 2, 1, 2888, 3, 100, 99),
(0, 5123, 2, 2, 882, 5, 300, 297),
(0, 5123, 2, 3, 85, 5, 500, 496),
(0, 5123, 2, 4, 724, 10, 1000, 990),
(3, 6939, 0, 0, 5124, 15, 1, 1),
(3, 6939, 0, 1, 2848, 10, 50, 50),
(3, 6939, 0, 2, 1419, 6, 100, 100),
(3, 6939, 0, 3, 1299, 1, 400, 399),
(3, 6939, 0, 4, 19, 500000, 1000, 996),
(3, 6939, 1, 0, 2968, 3, 1, 1),
(3, 6939, 1, 1, 4923, 1, 50, 49),
(3, 6939, 1, 2, 4924, 1, 50, 49),
(3, 6939, 1, 3, 5124, 1, 500, 488),
(3, 6939, 1, 4, 5123, 2, 1000, 971),
(3, 6939, 2, 0, 19, 5000000, 1, 1),
(3, 6939, 2, 1, 19, 500000, 1000, 1000),
(3, 6939, 2, 2, 19, 250000, 2000, 2000),
(3, 6939, 2, 3, 19, 100000, 3000, 3000),
(3, 6939, 2, 4, 19, 50000, 5000, 4999);
This code enable the Lacaball and put some items in it with 4 pages.[/b]
(newproject_db) credits Havelok
Newproject_post:
/*
Navicat MySQL Data Transfer
Source Server : XXXXXXXXXXX
Source Server Version : XXXXXXXXXXX
Source Host : XXXXXXXXXXX
Source Database : newproject_post
Target Server Type : XXXXXXXXXXX
Target Server Version : XXXXXXXXXXX
File Encoding : XXXXXXXXXXX
Date: 2012-11-13 14:27:41
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `eventquest`
-- ----------------------------
DROP TABLE IF EXISTS `eventquest`;
CREATE TABLE `eventquest` (
`questitem` INT(11) NOT NULL,
PRIMARY KEY (`questitem`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of eventquest
-- ----------------------------
-- ----------------------------
-- Table structure for `mailaccount`
-- ----------------------------
DROP TABLE IF EXISTS `mailaccount`;
CREATE TABLE `mailaccount` (
`sendcharacteridx` INT(11) NOT NULL,
PRIMARY KEY (`sendcharacteridx`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of mailaccount
-- ----------------------------
-- ----------------------------
-- Table structure for `msgtype`
-- ----------------------------
DROP TABLE IF EXISTS `msgtype`;
CREATE TABLE `msgtype` (
`msgtype` SMALLINT(6) NOT NULL DEFAULT '-1',
PRIMARY KEY (`msgtype`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of msgtype
-- ----------------------------
-- ----------------------------
-- Table structure for `postoffice`
-- ----------------------------
DROP TABLE IF EXISTS `postoffice`;
CREATE TABLE `postoffice` (
`recvdate` VARCHAR(50) NOT NULL,
`sendcharacteridx` INT(11) NOT NULL,
`msgcategory` SMALLINT(6) NOT NULL DEFAULT '-1',
`msgtype` SMALLINT(6) NOT NULL DEFAULT '-1',
`recvcharacteridx` INT(11) NOT NULL DEFAULT '0',
`subject` VARCHAR(41) DEFAULT '',
`contents` VARCHAR(255) DEFAULT '',
`money` BIGINT(20) DEFAULT '0',
`billreqflag` SMALLINT(6) DEFAULT '0',
`viewicon` INT(11) NOT NULL DEFAULT '0',
`sendName` VARCHAR(20) NOT NULL DEFAULT '',
`recvName` VARCHAR(20) NOT NULL DEFAULT '',
PRIMARY KEY (`recvdate`,`sendcharacteridx`,`msgcategory`,`msgtype`),
KEY `msgcategorypostoffice` (`msgcategory`),
KEY `msgtypepostoffice` (`msgtype`),
KEY `sendcharacteridxpostoffice` (`sendcharacteridx`),
CONSTRAINT `postoffice_ibfk_1` FOREIGN KEY (`msgcategory`) REFERENCES `premiumtype` (`msgcategory`),
CONSTRAINT `postoffice_ibfk_2` FOREIGN KEY (`msgtype`) REFERENCES `msgtype` (`msgtype`),
CONSTRAINT `postoffice_ibfk_3` FOREIGN KEY (`sendcharacteridx`) REFERENCES `mailaccount` (`sendcharacteridx`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of postoffice
-- ----------------------------
-- ----------------------------
-- Table structure for `postoffice_att0`
-- ----------------------------
DROP TABLE IF EXISTS `postoffice_att0`;
CREATE TABLE `postoffice_att0` (
`recvcharacteridx` INT(11) NOT NULL,
`sendcharacteridx` INT(11) NOT NULL,
`recvdate` VARCHAR(50) NOT NULL,
`msgcategory` SMALLINT(6) NOT NULL,
`preslot` SMALLINT(6) NOT NULL,
`msgtype` SMALLINT(6) NOT NULL,
`itemserial` VARCHAR(255) NOT NULL DEFAULT '',
`itemidx` INT(11) NOT NULL DEFAULT '-1',
`option1` SMALLINT(6) NOT NULL DEFAULT '0',
`option2` SMALLINT(6) NOT NULL DEFAULT '0',
`option3` SMALLINT(6) NOT NULL DEFAULT '0',
`option4` SMALLINT(6) NOT NULL DEFAULT '0',
`option5` SMALLINT(6) NOT NULL DEFAULT '0',
`optionlevel1` SMALLINT(6) NOT NULL DEFAULT '0',
`optionlevel2` SMALLINT(6) NOT NULL DEFAULT '0',
`optionlevel3` SMALLINT(6) NOT NULL DEFAULT '0',
`optionlevel4` SMALLINT(6) NOT NULL DEFAULT '0',
`optionlevel5` SMALLINT(6) NOT NULL DEFAULT '0',
`socket` VARCHAR(50) NOT NULL DEFAULT '',
`timelimite1` INT(11) NOT NULL DEFAULT '-1',
`timelimite2` INT(11) NOT NULL DEFAULT '-1',
`plus` INT(11) NOT NULL DEFAULT '0',
`flag` INT(11) NOT NULL DEFAULT '0',
`itemcount` BIGINT(20) NOT NULL DEFAULT '0',
PRIMARY KEY (`recvcharacteridx`,`sendcharacteridx`,`recvdate`,`msgcategory`,`preslot`,`msgtype`),
KEY `postofficepostoffice_att0` (`recvdate`,`sendcharacteridx`,`msgcategory`,`msgtype`),
KEY `preslotpostoffice_att0` (`preslot`),
CONSTRAINT `postoffice_att0_ibfk_1` FOREIGN KEY (`recvdate`, `sendcharacteridx`, `msgcategory`, `msgtype`) REFERENCES `postoffice` (`recvdate`, `sendcharacteridx`, `msgcategory`, `msgtype`),
CONSTRAINT `postoffice_att0_ibfk_2` FOREIGN KEY (`preslot`) REFERENCES `preslot` (`preslot`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of postoffice_att0
-- ----------------------------
-- ----------------------------
-- Table structure for `postoffice_att1`
-- ----------------------------
DROP TABLE IF EXISTS `postoffice_att1`;
CREATE TABLE `postoffice_att1` (
`recvcharacteridx` INT(11) NOT NULL,
`sendcharacteridx` INT(11) NOT NULL,
`recvdate` VARCHAR(50) NOT NULL,
`msgcategory` SMALLINT(6) NOT NULL,
`preslot` SMALLINT(6) NOT NULL,
`msgtype` SMALLINT(6) NOT NULL,
`itemserial` VARCHAR(255) NOT NULL DEFAULT '',
`itemidx` INT(11) NOT NULL DEFAULT '-1',
`option1` SMALLINT(6) NOT NULL DEFAULT '0',
`option2` SMALLINT(6) NOT NULL DEFAULT '0',
`option3` SMALLINT(6) NOT NULL DEFAULT '0',
`option4` SMALLINT(6) NOT NULL DEFAULT '0',
`option5` SMALLINT(6) NOT NULL DEFAULT '0',
`optionlevel1` SMALLINT(6) NOT NULL DEFAULT '0',
`optionlevel2` SMALLINT(6) NOT NULL DEFAULT '0',
`optionlevel3` SMALLINT(6) NOT NULL DEFAULT '0',
`optionlevel4` SMALLINT(6) NOT NULL DEFAULT '0',
`optionlevel5` SMALLINT(6) NOT NULL DEFAULT '0',
`socket` VARCHAR(50) NOT NULL DEFAULT '',
`timelimite1` INT(11) NOT NULL DEFAULT '-1',
`timelimite2` INT(11) NOT NULL DEFAULT '-1',
`plus` INT(11) NOT NULL DEFAULT '0',
`flag` INT(11) NOT NULL DEFAULT '0',
`itemcount` BIGINT(20) NOT NULL DEFAULT '0',
PRIMARY KEY (`recvcharacteridx`,`sendcharacteridx`,`recvdate`,`msgcategory`,`preslot`,`msgtype`),
KEY `storage_postofficestorage_postoffice_att1` (`recvdate`,`sendcharacteridx`,`msgcategory`,`msgtype`),
KEY `preslotstorage_postoffice_att1` (`preslot`),
CONSTRAINT `postoffice_att1_ibfk_1` FOREIGN KEY (`recvdate`, `sendcharacteridx`, `msgcategory`, `msgtype`) REFERENCES `postoffice` (`recvdate`, `sendcharacteridx`, `msgcategory`, `msgtype`),
CONSTRAINT `postoffice_att1_ibfk_2` FOREIGN KEY (`preslot`) REFERENCES `preslot` (`preslot`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of postoffice_att1
-- ----------------------------
-- ----------------------------
-- Table structure for `postoffice_att2`
-- ----------------------------
DROP TABLE IF EXISTS `postoffice_att2`;
CREATE TABLE `postoffice_att2` (
`recvcharacteridx` INT(11) NOT NULL,
`sendcharacteridx` INT(11) NOT NULL,
`recvdate` VARCHAR(50) NOT NULL,
`msgcategory` SMALLINT(6) NOT NULL,
`preslot` SMALLINT(6) NOT NULL,
`msgtype` SMALLINT(6) NOT NULL,
`itemserial` VARCHAR(255) NOT NULL DEFAULT '',
`itemidx` INT(11) NOT NULL DEFAULT '-1',
`option1` SMALLINT(6) NOT NULL DEFAULT '0',
`option2` SMALLINT(6) NOT NULL DEFAULT '0',
`option3` SMALLINT(6) NOT NULL DEFAULT '0',
`option4` SMALLINT(6) NOT NULL DEFAULT '0',
`option5` SMALLINT(6) NOT NULL DEFAULT '0',
`optionlevel1` SMALLINT(6) NOT NULL DEFAULT '0',
`optionlevel2` SMALLINT(6) NOT NULL DEFAULT '0',
`optionlevel3` SMALLINT(6) NOT NULL DEFAULT '0',
`optionlevel4` SMALLINT(6) NOT NULL DEFAULT '0',
`optionlevel5` SMALLINT(6) NOT NULL DEFAULT '0',
`socket` VARCHAR(50) NOT NULL DEFAULT '',
`timelimite1` INT(11) NOT NULL DEFAULT '-1',
`timelimite2` INT(11) NOT NULL DEFAULT '-1',
`plus` INT(11) NOT NULL DEFAULT '0',
`flag` INT(11) NOT NULL DEFAULT '0',
`itemcount` BIGINT(20) NOT NULL DEFAULT '0',
PRIMARY KEY (`recvcharacteridx`,`sendcharacteridx`,`recvdate`,`msgcategory`,`preslot`,`msgtype`),
KEY `postofficepostoffice_att2` (`recvdate`,`sendcharacteridx`,`msgcategory`,`msgtype`),
KEY `preslotpostoffice_att2` (`preslot`),
CONSTRAINT `postoffice_att2_ibfk_1` FOREIGN KEY (`recvdate`, `sendcharacteridx`, `msgcategory`, `msgtype`) REFERENCES `postoffice` (`recvdate`, `sendcharacteridx`, `msgcategory`, `msgtype`),
CONSTRAINT `postoffice_att2_ibfk_2` FOREIGN KEY (`preslot`) REFERENCES `preslot` (`preslot`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of postoffice_att2
-- ----------------------------
-- ----------------------------
-- Table structure for `postoffice_att3`
-- ----------------------------
DROP TABLE IF EXISTS `postoffice_att3`;
CREATE TABLE `postoffice_att3` (
`recvcharacteridx` INT(11) NOT NULL,
`sendcharacteridx` INT(11) NOT NULL,
`recvdate` VARCHAR(50) NOT NULL,
`msgcategory` SMALLINT(6) NOT NULL,
`preslot` SMALLINT(6) NOT NULL,
`msgtype` SMALLINT(6) NOT NULL,
`itemserial` VARCHAR(255) NOT NULL DEFAULT '',
`itemidx` INT(11) NOT NULL DEFAULT '-1',
`option1` SMALLINT(6) NOT NULL DEFAULT '0',
`option2` SMALLINT(6) NOT NULL DEFAULT '0',
`option3` SMALLINT(6) NOT NULL DEFAULT '0',
`option4` SMALLINT(6) NOT NULL DEFAULT '0',
`option5` SMALLINT(6) NOT NULL DEFAULT '0',
`optionlevel1` SMALLINT(6) NOT NULL DEFAULT '0',
`optionlevel2` SMALLINT(6) NOT NULL DEFAULT '0',
`optionlevel3` SMALLINT(6) NOT NULL DEFAULT '0',
`optionlevel4` SMALLINT(6) NOT NULL DEFAULT '0',
`optionlevel5` SMALLINT(6) NOT NULL DEFAULT '0',
`socket` VARCHAR(50) NOT NULL DEFAULT '',
`timelimite1` INT(11) NOT NULL DEFAULT '-1',
`timelimite2` INT(11) NOT NULL DEFAULT '-1',
`plus` INT(11) NOT NULL DEFAULT '0',
`flag` INT(11) NOT NULL DEFAULT '0',
`itemcount` BIGINT(20) NOT NULL DEFAULT '0',
PRIMARY KEY (`recvcharacteridx`,`sendcharacteridx`,`recvdate`,`msgcategory`,`preslot`,`msgtype`),
KEY `storage_postofficestorage_postoffice_att3` (`recvdate`,`sendcharacteridx`,`msgcategory`,`msgtype`),
KEY `preslotstorage_postoffice_att3` (`preslot`),
CONSTRAINT `postoffice_att3_ibfk_1` FOREIGN KEY (`recvdate`, `sendcharacteridx`, `msgcategory`, `msgtype`) REFERENCES `postoffice` (`recvdate`, `sendcharacteridx`, `msgcategory`, `msgtype`),
CONSTRAINT `postoffice_att3_ibfk_2` FOREIGN KEY (`preslot`) REFERENCES `preslot` (`preslot`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of postoffice_att3
-- ----------------------------
-- ----------------------------
-- Table structure for `postoffice_att4`
-- ----------------------------
DROP TABLE IF EXISTS `postoffice_att4`;
CREATE TABLE `postoffice_att4` (
`recvcharacteridx` INT(11) NOT NULL,
`sendcharacteridx` INT(11) NOT NULL,
`recvdate` VARCHAR(50) NOT NULL,
`msgcategory` SMALLINT(6) NOT NULL,
`preslot` SMALLINT(6) NOT NULL,
`msgtype` SMALLINT(6) NOT NULL,
`itemserial` VARCHAR(255) NOT NULL DEFAULT '',
`itemidx` INT(11) NOT NULL DEFAULT '-1',
`option1` SMALLINT(6) NOT NULL DEFAULT '0',
`option2` SMALLINT(6) NOT NULL DEFAULT '0',
`option3` SMALLINT(6) NOT NULL DEFAULT '0',
`option4` SMALLINT(6) NOT NULL DEFAULT '0',
`option5` SMALLINT(6) NOT NULL DEFAULT '0',
`optionlevel1` SMALLINT(6) NOT NULL DEFAULT '0',
`optionlevel2` SMALLINT(6) NOT NULL DEFAULT '0',
`optionlevel3` SMALLINT(6) NOT NULL DEFAULT '0',
`optionlevel4` SMALLINT(6) NOT NULL DEFAULT '0',
`optionlevel5` SMALLINT(6) NOT NULL DEFAULT '0',
`socket` VARCHAR(50) NOT NULL DEFAULT '',
`timelimite1` INT(11) NOT NULL DEFAULT '-1',
`timelimite2` INT(11) NOT NULL DEFAULT '-1',
`plus` INT(11) NOT NULL DEFAULT '0',
`flag` INT(11) NOT NULL DEFAULT '0',
`itemcount` BIGINT(20) NOT NULL DEFAULT '0',
PRIMARY KEY (`recvcharacteridx`,`sendcharacteridx`,`recvdate`,`msgcategory`,`preslot`,`msgtype`),
KEY `postofficepostoffice_att4` (`recvdate`,`sendcharacteridx`,`msgcategory`,`msgtype`),
KEY `preslotpostoffice_att4` (`preslot`),
CONSTRAINT `postoffice_att4_ibfk_1` FOREIGN KEY (`recvdate`, `sendcharacteridx`, `msgcategory`, `msgtype`) REFERENCES `postoffice` (`recvdate`, `sendcharacteridx`, `msgcategory`, `msgtype`),
CONSTRAINT `postoffice_att4_ibfk_2` FOREIGN KEY (`preslot`) REFERENCES `preslot` (`preslot`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of postoffice_att4
-- ----------------------------
-- ----------------------------
-- Table structure for `postoffice_att5`
-- ----------------------------
DROP TABLE IF EXISTS `postoffice_att5`;
CREATE TABLE `postoffice_att5` (
`recvcharacteridx` INT(11) NOT NULL,
`sendcharacteridx` INT(11) NOT NULL,
`recvdate` VARCHAR(50) NOT NULL,
`msgcategory` SMALLINT(6) NOT NULL,
`preslot` SMALLINT(6) NOT NULL,
`msgtype` SMALLINT(6) NOT NULL,
`itemserial` VARCHAR(255) NOT NULL DEFAULT '',
`itemidx` INT(11) NOT NULL DEFAULT '-1',
`option1` SMALLINT(6) NOT NULL DEFAULT '0',
`option2` SMALLINT(6) NOT NULL DEFAULT '0',
`option3` SMALLINT(6) NOT NULL DEFAULT '0',
`option4` SMALLINT(6) NOT NULL DEFAULT '0',
`option5` SMALLINT(6) NOT NULL DEFAULT '0',
`optionlevel1` SMALLINT(6) NOT NULL DEFAULT '0',
`optionlevel2` SMALLINT(6) NOT NULL DEFAULT '0',
`optionlevel3` SMALLINT(6) NOT NULL DEFAULT '0',
`optionlevel4` SMALLINT(6) NOT NULL DEFAULT '0',
`optionlevel5` SMALLINT(6) NOT NULL DEFAULT '0',
`socket` VARCHAR(50) NOT NULL DEFAULT '',
`timelimite1` INT(11) NOT NULL DEFAULT '-1',
`timelimite2` INT(11) NOT NULL DEFAULT '-1',
`plus` INT(11) NOT NULL DEFAULT '0',
`flag` INT(11) NOT NULL DEFAULT '0',
`itemcount` BIGINT(20) NOT NULL DEFAULT '0',
PRIMARY KEY (`recvcharacteridx`,`sendcharacteridx`,`recvdate`,`msgcategory`,`preslot`,`msgtype`),
KEY `postofficepostoffice_att5` (`recvdate`,`sendcharacteridx`,`msgcategory`,`msgtype`),
KEY `preslotpostoffice_att5` (`preslot`),
CONSTRAINT `postoffice_att5_ibfk_1` FOREIGN KEY (`recvdate`, `sendcharacteridx`, `msgcategory`, `msgtype`) REFERENCES `postoffice` (`recvdate`, `sendcharacteridx`, `msgcategory`, `msgtype`),
CONSTRAINT `postoffice_att5_ibfk_2` FOREIGN KEY (`preslot`) REFERENCES `preslot` (`preslot`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of postoffice_att5
-- ----------------------------
-- ----------------------------
-- Table structure for `postoffice_att6`
-- ----------------------------
DROP TABLE IF EXISTS `postoffice_att6`;
CREATE TABLE `postoffice_att6` (
`recvcharacteridx` INT(11) NOT NULL,
`sendcharacteridx` INT(11) NOT NULL,
`recvdate` VARCHAR(50) NOT NULL,
`msgcategory` SMALLINT(6) NOT NULL,
`preslot` SMALLINT(6) NOT NULL,
`msgtype` SMALLINT(6) NOT NULL,
`itemserial` VARCHAR(255) NOT NULL DEFAULT '',
`itemidx` INT(11) NOT NULL DEFAULT '-1',
`option1` SMALLINT(6) NOT NULL DEFAULT '0',
`option2` SMALLINT(6) NOT NULL DEFAULT '0',
`option3` SMALLINT(6) NOT NULL DEFAULT '0',
`option4` SMALLINT(6) NOT NULL DEFAULT '0',
`option5` SMALLINT(6) NOT NULL DEFAULT '0',
`optionlevel1` SMALLINT(6) NOT NULL DEFAULT '0',
`optionlevel2` SMALLINT(6) NOT NULL DEFAULT '0',
`optionlevel3` SMALLINT(6) NOT NULL DEFAULT '0',
`optionlevel4` SMALLINT(6) NOT NULL DEFAULT '0',
`optionlevel5` SMALLINT(6) NOT NULL DEFAULT '0',
`socket` VARCHAR(50) NOT NULL DEFAULT '',
`timelimite1` INT(11) NOT NULL DEFAULT '-1',
`timelimite2` INT(11) NOT NULL DEFAULT '-1',
`plus` INT(11) NOT NULL DEFAULT '0',
`flag` INT(11) NOT NULL DEFAULT '0',
`itemcount` BIGINT(20) NOT NULL DEFAULT '0',
PRIMARY KEY (`recvcharacteridx`,`sendcharacteridx`,`recvdate`,`msgcategory`,`preslot`,`msgtype`),
KEY `postofficepostoffice_att6` (`recvdate`,`sendcharacteridx`,`msgcategory`,`msgtype`),
KEY `preslotpostoffice_att6` (`preslot`),
CONSTRAINT `postoffice_att6_ibfk_1` FOREIGN KEY (`recvdate`, `sendcharacteridx`, `msgcategory`, `msgtype`) REFERENCES `postoffice` (`recvdate`, `sendcharacteridx`, `msgcategory`, `msgtype`),
CONSTRAINT `postoffice_att6_ibfk_2` FOREIGN KEY (`preslot`) REFERENCES `preslot` (`preslot`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of postoffice_att6
-- ----------------------------
-- ----------------------------
-- Table structure for `postoffice_att7`
-- ----------------------------
DROP TABLE IF EXISTS `postoffice_att7`;
CREATE TABLE `postoffice_att7` (
`recvcharacteridx` INT(11) NOT NULL,
`sendcharacteridx` INT(11) NOT NULL,
`recvdate` VARCHAR(50) NOT NULL,
`msgcategory` SMALLINT(6) NOT NULL,
`preslot` SMALLINT(6) NOT NULL,
`msgtype` SMALLINT(6) NOT NULL,
`itemserial` VARCHAR(255) NOT NULL DEFAULT '',
`itemidx` INT(11) NOT NULL DEFAULT '-1',
`option1` SMALLINT(6) NOT NULL DEFAULT '0',
`option2` SMALLINT(6) NOT NULL DEFAULT '0',
`option3` SMALLINT(6) NOT NULL DEFAULT '0',
`option4` SMALLINT(6) NOT NULL DEFAULT '0',
`option5` SMALLINT(6) NOT NULL DEFAULT '0',
`optionlevel1` SMALLINT(6) NOT NULL DEFAULT '0',
`optionlevel2` SMALLINT(6) NOT NULL DEFAULT '0',
`optionlevel3` SMALLINT(6) NOT NULL DEFAULT '0',
`optionlevel4` SMALLINT(6) NOT NULL DEFAULT '0',
`optionlevel5` SMALLINT(6) NOT NULL DEFAULT '0',
`socket` VARCHAR(50) NOT NULL DEFAULT '',
`timelimite1` INT(11) NOT NULL DEFAULT '-1',
`timelimite2` INT(11) NOT NULL DEFAULT '-1',
`plus` INT(11) NOT NULL DEFAULT '0',
`flag` INT(11) NOT NULL DEFAULT '0',
`itemcount` BIGINT(20) NOT NULL DEFAULT '0',
PRIMARY KEY (`recvcharacteridx`,`sendcharacteridx`,`recvdate`,`msgcategory`,`preslot`,`msgtype`),
KEY `postofficepostoffice_att7` (`recvdate`,`sendcharacteridx`,`msgcategory`,`msgtype`),
KEY `preslotpostoffice_att7` (`preslot`),
CONSTRAINT `postoffice_att7_ibfk_1` FOREIGN KEY (`recvdate`, `sendcharacteridx`, `msgcategory`, `msgtype`) REFERENCES `postoffice` (`recvdate`, `sendcharacteridx`, `msgcategory`, `msgtype`),
CONSTRAINT `postoffice_att7_ibfk_2` FOREIGN KEY (`preslot`) REFERENCES `preslot` (`preslot`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of postoffice_att7
-- ----------------------------
-- ----------------------------
-- Table structure for `postoffice_att8`
-- ----------------------------
DROP TABLE IF EXISTS `postoffice_att8`;
CREATE TABLE `postoffice_att8` (
`recvcharacteridx` INT(11) NOT NULL,
`sendcharacteridx` INT(11) NOT NULL,
`recvdate` VARCHAR(50) NOT NULL,
`msgcategory` SMALLINT(6) NOT NULL,
`preslot` SMALLINT(6) NOT NULL,
`msgtype` SMALLINT(6) NOT NULL,
`itemserial` VARCHAR(255) NOT NULL DEFAULT '',
`itemidx` INT(11) NOT NULL DEFAULT '-1',
`option1` SMALLINT(6) NOT NULL DEFAULT '0',
`option2` SMALLINT(6) NOT NULL DEFAULT '0',
`option3` SMALLINT(6) NOT NULL DEFAULT '0',
`option4` SMALLINT(6) NOT NULL DEFAULT '0',
`option5` SMALLINT(6) NOT NULL DEFAULT '0',
`optionlevel1` SMALLINT(6) NOT NULL DEFAULT '0',
`optionlevel2` SMALLINT(6) NOT NULL DEFAULT '0',
`optionlevel3` SMALLINT(6) NOT NULL DEFAULT '0',
`optionlevel4` SMALLINT(6) NOT NULL DEFAULT '0',
`optionlevel5` SMALLINT(6) NOT NULL DEFAULT '0',
`socket` VARCHAR(50) NOT NULL DEFAULT '',
`timelimite1` INT(11) NOT NULL DEFAULT '-1',
`timelimite2` INT(11) NOT NULL DEFAULT '-1',
`plus` INT(11) NOT NULL DEFAULT '0',
`flag` INT(11) NOT NULL DEFAULT '0',
`itemcount` BIGINT(20) NOT NULL DEFAULT '0',
PRIMARY KEY (`recvcharacteridx`,`sendcharacteridx`,`recvdate`,`msgcategory`,`preslot`,`msgtype`),
KEY `postofficepostoffice_att8` (`recvdate`,`sendcharacteridx`,`msgcategory`,`msgtype`),
KEY `preslotpostoffice_att8` (`preslot`),
CONSTRAINT `postoffice_att8_ibfk_1` FOREIGN KEY (`recvdate`, `sendcharacteridx`, `msgcategory`, `msgtype`) REFERENCES `postoffice` (`recvdate`, `sendcharacteridx`, `msgcategory`, `msgtype`),
CONSTRAINT `postoffice_att8_ibfk_2` FOREIGN KEY (`preslot`) REFERENCES `preslot` (`preslot`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of postoffice_att8
-- ----------------------------
-- ----------------------------
-- Table structure for `postoffice_att9`
-- ----------------------------
DROP TABLE IF EXISTS `postoffice_att9`;
CREATE TABLE `postoffice_att9` (
`recvcharacteridx` INT(11) NOT NULL,
`sendcharacteridx` INT(11) NOT NULL,
`recvdate` VARCHAR(50) NOT NULL,
`msgcategory` SMALLINT(6) NOT NULL,
`preslot` SMALLINT(6) NOT NULL,
`msgtype` SMALLINT(6) NOT NULL,
`itemserial` VARCHAR(255) NOT NULL DEFAULT '',
`itemidx` INT(11) NOT NULL DEFAULT '-1',
`option1` SMALLINT(6) NOT NULL DEFAULT '0',
`option2` SMALLINT(6) NOT NULL DEFAULT '0',
`option3` SMALLINT(6) NOT NULL DEFAULT '0',
`option4` SMALLINT(6) NOT NULL DEFAULT '0',
`option5` SMALLINT(6) NOT NULL DEFAULT '0',
`optionlevel1` SMALLINT(6) NOT NULL DEFAULT '0',
`optionlevel2` SMALLINT(6) NOT NULL DEFAULT '0',
`optionlevel3` SMALLINT(6) NOT NULL DEFAULT '0',
`optionlevel4` SMALLINT(6) NOT NULL DEFAULT '0',
`optionlevel5` SMALLINT(6) NOT NULL DEFAULT '0',
`socket` VARCHAR(50) NOT NULL DEFAULT '',
`timelimite1` INT(11) NOT NULL DEFAULT '-1',
`timelimite2` INT(11) NOT NULL DEFAULT '-1',
`plus` INT(11) NOT NULL DEFAULT '0',
`flag` INT(11) NOT NULL DEFAULT '0',
`itemcount` BIGINT(20) NOT NULL DEFAULT '0',
PRIMARY KEY (`recvcharacteridx`,`sendcharacteridx`,`recvdate`,`msgcategory`,`preslot`,`msgtype`),
KEY `postofficepostoffice_att9` (`recvdate`,`sendcharacteridx`,`msgcategory`,`msgtype`),
KEY `preslotpostoffice_att9` (`preslot`),
CONSTRAINT `postoffice_att9_ibfk_1` FOREIGN KEY (`recvdate`, `sendcharacteridx`, `msgcategory`, `msgtype`) REFERENCES `postoffice` (`recvdate`, `sendcharacteridx`, `msgcategory`, `msgtype`),
CONSTRAINT `postoffice_att9_ibfk_2` FOREIGN KEY (`preslot`) REFERENCES `preslot` (`preslot`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of postoffice_att9
-- ----------------------------
-- ----------------------------
-- Table structure for `premiumtype`
-- ----------------------------
DROP TABLE IF EXISTS `premiumtype`;
CREATE TABLE `premiumtype` (
`msgcategory` SMALLINT(6) NOT NULL DEFAULT '-1',
PRIMARY KEY (`msgcategory`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of premiumtype
-- ----------------------------
-- ----------------------------
-- Table structure for `preslot`
-- ----------------------------
DROP TABLE IF EXISTS `preslot`;
CREATE TABLE `preslot` (
`preslot` SMALLINT(6) NOT NULL,
PRIMARY KEY (`preslot`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of preslot
-- ----------------------------
-- ----------------------------
-- Table structure for `preuserattachment0`
-- ----------------------------
DROP TABLE IF EXISTS `preuserattachment0`;
CREATE TABLE `preuserattachment0` (
`characteridx` INT(11) NOT NULL,
`slot_number` INT(11) NOT NULL,
`preslot` SMALLINT(6) NOT NULL,
`itemserial` VARCHAR(255) NOT NULL DEFAULT '',
`itemidx` INT(11) NOT NULL DEFAULT '-1',
`option1` SMALLINT(6) NOT NULL DEFAULT '0',
`option2` SMALLINT(6) NOT NULL DEFAULT '0',
`option3` SMALLINT(6) NOT NULL DEFAULT '0',
`option4` SMALLINT(6) NOT NULL DEFAULT '0',
`option5` SMALLINT(6) NOT NULL DEFAULT '0',
`optionlevel1` SMALLINT(6) NOT NULL DEFAULT '0',
`optionlevel2` SMALLINT(6) NOT NULL DEFAULT '0',
`optionlevel3` SMALLINT(6) NOT NULL DEFAULT '0',
`optionlevel4` SMALLINT(6) NOT NULL DEFAULT '0',
`optionlevel5` SMALLINT(6) NOT NULL DEFAULT '0',
`socket` VARCHAR(50) NOT NULL DEFAULT '',
`timelimite1` INT(11) NOT NULL DEFAULT '-1',
`timelimite2` INT(11) NOT NULL DEFAULT '-1',
`plus` INT(11) NOT NULL DEFAULT '0',
`flag` INT(11) NOT NULL DEFAULT '0',
`itemcount` BIGINT(20) NOT NULL DEFAULT '0',
PRIMARY KEY (`characteridx`,`slot_number`,`preslot`),
KEY `slotNumberpreuserattachment0` (`slot_number`),
KEY `preslotpreuserattachment0` (`preslot`),
CONSTRAINT `preuserattachment0_ibfk_1` FOREIGN KEY (`slot_number`) REFERENCES `slotidx` (`slot_number`),
CONSTRAINT `preuserattachment0_ibfk_2` FOREIGN KEY (`preslot`) REFERENCES `preslot` (`preslot`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of preuserattachment0
-- ----------------------------
-- ----------------------------
-- Table structure for `preuserattachment1`
-- ----------------------------
DROP TABLE IF EXISTS `preuserattachment1`;
CREATE TABLE `preuserattachment1` (
`characteridx` INT(11) NOT NULL,
`slot_number` INT(11) NOT NULL,
`preslot` SMALLINT(6) NOT NULL,
`itemserial` VARCHAR(255) DEFAULT '',
`itemidx` INT(11) DEFAULT '-1',
`option1` SMALLINT(6) DEFAULT '0',
`option2` SMALLINT(6) DEFAULT '0',
`option3` SMALLINT(6) DEFAULT '0',
`option4` SMALLINT(6) DEFAULT '0',
`option5` SMALLINT(6) DEFAULT '0',
`optionlevel1` SMALLINT(6) DEFAULT '0',
`optionlevel2` SMALLINT(6) DEFAULT '0',
`optionlevel3` SMALLINT(6) DEFAULT '0',
`optionlevel4` SMALLINT(6) DEFAULT '0',
`optionlevel5` SMALLINT(6) DEFAULT '0',
`socket` VARCHAR(50) DEFAULT '',
`timelimite1` INT(11) DEFAULT '-1',
`timelimite2` INT(11) DEFAULT '-1',
`plus` INT(11) DEFAULT '0',
`flag` INT(11) DEFAULT '0',
`itemcount` BIGINT(20) DEFAULT '0',
PRIMARY KEY (`characteridx`,`slot_number`,`preslot`),
KEY `slotNumberpreuserattachment1` (`slot_number`),
KEY `preslotpreuserattachment1` (`preslot`),
CONSTRAINT `preuserattachment1_ibfk_1` FOREIGN KEY (`slot_number`) REFERENCES `slotidx` (`slot_number`),
CONSTRAINT `preuserattachment1_ibfk_2` FOREIGN KEY (`preslot`) REFERENCES `preslot` (`preslot`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of preuserattachment1
-- ----------------------------
-- ----------------------------
-- Table structure for `preuserattachment2`
-- ----------------------------
DROP TABLE IF EXISTS `preuserattachment2`;
CREATE TABLE `preuserattachment2` (
`characteridx` INT(11) NOT NULL DEFAULT '0',
`slot_number` INT(11) NOT NULL,
`preslot` SMALLINT(6) NOT NULL,
`itemserial` VARCHAR(255) NOT NULL DEFAULT '',
`itemidx` INT(11) NOT NULL DEFAULT '-1',
`option1` SMALLINT(6) NOT NULL DEFAULT '0',
`option2` SMALLINT(6) NOT NULL DEFAULT '0',
`option3` SMALLINT(6) NOT NULL DEFAULT '0',
`option4` SMALLINT(6) NOT NULL DEFAULT '0',
`option5` SMALLINT(6) NOT NULL DEFAULT '0',
`optionlevel1` SMALLINT(6) NOT NULL DEFAULT '0',
`optionlevel2` SMALLINT(6) NOT NULL DEFAULT '0',
`optionlevel3` SMALLINT(6) NOT NULL DEFAULT '0',
`optionlevel4` SMALLINT(6) NOT NULL DEFAULT '0',
`optionlevel5` SMALLINT(6) NOT NULL DEFAULT '0',
`socket` VARCHAR(50) NOT NULL DEFAULT '',
`timelimite1` INT(11) NOT NULL DEFAULT '-1',
`timelimite2` INT(11) NOT NULL DEFAULT '-1',
`plus` INT(11) NOT NULL DEFAULT '0',
`flag` INT(11) NOT NULL DEFAULT '0',
`itemcount` BIGINT(20) NOT NULL DEFAULT '0',
PRIMARY KEY (`characteridx`,`slot_number`,`preslot`),
KEY `slotNumberpreuserattachment2` (`slot_number`),
KEY `preslotpreuserattachment2` (`preslot`),
CONSTRAINT `preuserattachment2_ibfk_1` FOREIGN KEY (`slot_number`) REFERENCES `slotidx` (`slot_number`),
CONSTRAINT `preuserattachment2_ibfk_2` FOREIGN KEY (`preslot`) REFERENCES `preslot` (`preslot`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of preuserattachment2
-- ----------------------------
-- ----------------------------
-- Table structure for `preuserattachment3`
-- ----------------------------
DROP TABLE IF EXISTS `preuserattachment3`;
CREATE TABLE `preuserattachment3` (
`characteridx` INT(11) NOT NULL DEFAULT '0',
`slot_number` INT(11) NOT NULL,
`preslot` SMALLINT(6) NOT NULL,
`itemserial` VARCHAR(255) NOT NULL DEFAULT '',
`itemidx` INT(11) NOT NULL DEFAULT '-1',
`option1` SMALLINT(6) NOT NULL DEFAULT '0',
`option2` SMALLINT(6) NOT NULL DEFAULT '0',
`option3` SMALLINT(6) NOT NULL DEFAULT '0',
`option4` SMALLINT(6) NOT NULL DEFAULT '0',
`option5` SMALLINT(6) NOT NULL DEFAULT '0',
`optionlevel1` SMALLINT(6) NOT NULL DEFAULT '0',
`optionlevel2` SMALLINT(6) NOT NULL DEFAULT '0',
`optionlevel3` SMALLINT(6) NOT NULL DEFAULT '0',
`optionlevel4` SMALLINT(6) NOT NULL DEFAULT '0',
`optionlevel5` SMALLINT(6) NOT NULL DEFAULT '0',
`socket` VARCHAR(50) NOT NULL DEFAULT '',
`timelimite1` INT(11) NOT NULL DEFAULT '-1',
`timelimite2` INT(11) NOT NULL DEFAULT '-1',
`plus` INT(11) NOT NULL DEFAULT '0',
`flag` INT(11) NOT NULL DEFAULT '0',
`itemcount` BIGINT(20) NOT NULL DEFAULT '0',
PRIMARY KEY (`characteridx`,`slot_number`,`preslot`),
KEY `slotNumberpreuserattachment3` (`slot_number`),
KEY `preslotpreuserattachment3` (`preslot`),
CONSTRAINT `preuserattachment3_ibfk_1` FOREIGN KEY (`slot_number`) REFERENCES `slotidx` (`slot_number`),
CONSTRAINT `preuserattachment3_ibfk_2` FOREIGN KEY (`preslot`) REFERENCES `preslot` (`preslot`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of preuserattachment3
-- ----------------------------
-- ----------------------------
-- Table structure for `preuserattachment4`
-- ----------------------------
DROP TABLE IF EXISTS `preuserattachment4`;
CREATE TABLE `preuserattachment4` (
`characteridx` INT(11) NOT NULL DEFAULT '0',
`slot_number` INT(11) NOT NULL,
`preslot` SMALLINT(6) NOT NULL,
`itemserial` VARCHAR(255) NOT NULL DEFAULT '',
`itemidx` INT(11) NOT NULL DEFAULT '-1',
`option1` SMALLINT(6) NOT NULL DEFAULT '0',
`option2` SMALLINT(6) NOT NULL DEFAULT '0',
`option3` SMALLINT(6) NOT NULL DEFAULT '0',
`option4` SMALLINT(6) NOT NULL DEFAULT '0',
`option5` SMALLINT(6) NOT NULL DEFAULT '0',
`optionlevel1` SMALLINT(6) NOT NULL DEFAULT '0',
`optionlevel2` SMALLINT(6) NOT NULL DEFAULT '0',
`optionlevel3` SMALLINT(6) NOT NULL DEFAULT '0',
`optionlevel4` SMALLINT(6) NOT NULL DEFAULT '0',
`optionlevel5` SMALLINT(6) NOT NULL DEFAULT '0',
`socket` VARCHAR(50) NOT NULL DEFAULT '',
`timelimite1` INT(11) NOT NULL DEFAULT '-1',
`timelimite2` INT(11) NOT NULL DEFAULT '-1',
`plus` INT(11) NOT NULL DEFAULT '0',
`flag` INT(11) NOT NULL DEFAULT '0',
`itemcount` BIGINT(20) NOT NULL DEFAULT '0',
PRIMARY KEY (`characteridx`,`slot_number`,`preslot`),
KEY `slotNumberpreuserattachment4` (`slot_number`),
KEY `preslotpreuserattachment4` (`preslot`),
CONSTRAINT `preuserattachment4_ibfk_1` FOREIGN KEY (`slot_number`) REFERENCES `slotidx` (`slot_number`),
CONSTRAINT `preuserattachment4_ibfk_2` FOREIGN KEY (`preslot`) REFERENCES `preslot` (`preslot`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of preuserattachment4
-- ----------------------------
-- ----------------------------
-- Table structure for `preuserattachment5`
-- ----------------------------
DROP TABLE IF EXISTS `preuserattachment5`;
CREATE TABLE `preuserattachment5` (
`characteridx` INT(11) NOT NULL DEFAULT '0',
`slot_number` INT(11) NOT NULL,
`preslot` SMALLINT(6) NOT NULL,
`itemserial` VARCHAR(255) NOT NULL DEFAULT '',
`itemidx` INT(11) NOT NULL DEFAULT '-1',
`option1` SMALLINT(6) NOT NULL DEFAULT '0',
`option2` SMALLINT(6) NOT NULL DEFAULT '0',
`option3` SMALLINT(6) NOT NULL DEFAULT '0',
`option4` SMALLINT(6) NOT NULL DEFAULT '0',
`option5` SMALLINT(6) NOT NULL DEFAULT '0',
`optionlevel1` SMALLINT(6) NOT NULL DEFAULT '0',
`optionlevel2` SMALLINT(6) NOT NULL DEFAULT '0',
`optionlevel3` SMALLINT(6) NOT NULL DEFAULT '0',
`optionlevel4` SMALLINT(6) NOT NULL DEFAULT '0',
`optionlevel5` SMALLINT(6) NOT NULL DEFAULT '0',
`socket` VARCHAR(50) NOT NULL DEFAULT '',
`timelimite1` INT(11) NOT NULL DEFAULT '-1',
`timelimite2` INT(11) NOT NULL DEFAULT '-1',
`plus` INT(11) NOT NULL DEFAULT '0',
`flag` INT(11) NOT NULL DEFAULT '0',
`itemcount` BIGINT(20) NOT NULL DEFAULT '0',
PRIMARY KEY (`characteridx`,`slot_number`,`preslot`),
KEY `slotNumberpreuserattachment5` (`slot_number`),
KEY `preslotpreuserattachment5` (`preslot`),
CONSTRAINT `preuserattachment5_ibfk_1` FOREIGN KEY (`slot_number`) REFERENCES `slotidx` (`slot_number`),
CONSTRAINT `preuserattachment5_ibfk_2` FOREIGN KEY (`preslot`) REFERENCES `preslot` (`preslot`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of preuserattachment5
-- ----------------------------
-- ----------------------------
-- Table structure for `preuserattachment6`
-- ----------------------------
DROP TABLE IF EXISTS `preuserattachment6`;
CREATE TABLE `preuserattachment6` (
`characteridx` INT(11) NOT NULL,
`slot_number` INT(11) NOT NULL,
`preslot` SMALLINT(6) NOT NULL,
`itemserial` VARCHAR(255) NOT NULL,
`itemidx` INT(11) NOT NULL,
`option1` SMALLINT(6) NOT NULL,
`option2` SMALLINT(6) NOT NULL,
`option3` SMALLINT(6) NOT NULL,
`option4` SMALLINT(6) NOT NULL,
`option5` SMALLINT(6) NOT NULL,
`optionlevel1` SMALLINT(6) NOT NULL,
`optionlevel2` SMALLINT(6) NOT NULL,
`optionlevel3` SMALLINT(6) NOT NULL,
`optionlevel4` SMALLINT(6) NOT NULL,
`optionlevel5` SMALLINT(6) NOT NULL,
`socket` VARCHAR(50) NOT NULL,
`timelimite1` INT(11) NOT NULL,
`timelimite2` INT(11) NOT NULL,
`plus` INT(11) NOT NULL,
`flag` INT(11) NOT NULL,
`itemcount` BIGINT(20) NOT NULL,
PRIMARY KEY (`characteridx`,`slot_number`,`preslot`),
KEY `slotNumberpreuserattachment6` (`slot_number`),
KEY `preslotpreuserattachment6` (`preslot`),
CONSTRAINT `preuserattachment6_ibfk_1` FOREIGN KEY (`slot_number`) REFERENCES `slotidx` (`slot_number`),
CONSTRAINT `preuserattachment6_ibfk_2` FOREIGN KEY (`preslot`) REFERENCES `preslot` (`preslot`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of preuserattachment6
-- ----------------------------
-- ----------------------------
-- Table structure for `preuserattachment7`
-- ----------------------------
DROP TABLE IF EXISTS `preuserattachment7`;
CREATE TABLE `preuserattachment7` (
`characteridx` INT(11) NOT NULL,
`slot_number` INT(11) NOT NULL,
`preslot` SMALLINT(6) NOT NULL,
`itemserial` VARCHAR(255) NOT NULL,
`itemidx` INT(11) NOT NULL,
`option1` SMALLINT(6) NOT NULL,
`option2` SMALLINT(6) NOT NULL,
`option3` SMALLINT(6) NOT NULL,
`option4` SMALLINT(6) NOT NULL,
`option5` SMALLINT(6) NOT NULL,
`optionlevel1` SMALLINT(6) NOT NULL,
`optionlevel2` SMALLINT(6) NOT NULL,
`optionlevel3` SMALLINT(6) NOT NULL,
`optionlevel4` SMALLINT(6) NOT NULL,
`optionlevel5` SMALLINT(6) NOT NULL,
`socket` VARCHAR(50) NOT NULL,
`timelimite1` INT(11) NOT NULL,
`timelimite2` INT(11) NOT NULL,
`plus` INT(11) NOT NULL,
`flag` INT(11) NOT NULL,
`itemcount` BIGINT(20) NOT NULL,
PRIMARY KEY (`characteridx`,`slot_number`,`preslot`),
KEY `slotNumberpreuserattachment7` (`slot_number`),
KEY `preslotpreuserattachment7` (`preslot`),
CONSTRAINT `preuserattachment7_ibfk_1` FOREIGN KEY (`slot_number`) REFERENCES `slotidx` (`slot_number`),
CONSTRAINT `preuserattachment7_ibfk_2` FOREIGN KEY (`preslot`) REFERENCES `preslot` (`preslot`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of preuserattachment7
-- ----------------------------
-- ----------------------------
-- Table structure for `preuserattachment8`
-- ----------------------------
DROP TABLE IF EXISTS `preuserattachment8`;
CREATE TABLE `preuserattachment8` (
`characteridx` INT(11) NOT NULL,
`slot_number` INT(11) NOT NULL,
`preslot` SMALLINT(6) NOT NULL,
`itemserial` VARCHAR(255) NOT NULL,
`itemidx` INT(11) NOT NULL,
`option1` SMALLINT(6) NOT NULL,
`option2` SMALLINT(6) NOT NULL,
`option3` SMALLINT(6) NOT NULL,
`option4` SMALLINT(6) NOT NULL,
`option5` SMALLINT(6) NOT NULL,
`optionlevel1` SMALLINT(6) NOT NULL,
`optionlevel2` SMALLINT(6) NOT NULL,
`optionlevel3` SMALLINT(6) NOT NULL,
`optionlevel4` SMALLINT(6) NOT NULL,
`optionlevel5` SMALLINT(6) NOT NULL,
`socket` VARCHAR(50) NOT NULL,
`timelimite1` INT(11) NOT NULL,
`timelimite2` INT(11) NOT NULL,
`plus` INT(11) NOT NULL,
`flag` INT(11) NOT NULL,
`itemcount` BIGINT(20) NOT NULL,
PRIMARY KEY (`characteridx`,`slot_number`,`preslot`),
KEY `slotNumberpreuserattachment8` (`slot_number`),
KEY `preslotpreuserattachment8` (`preslot`),
CONSTRAINT `preuserattachment8_ibfk_1` FOREIGN KEY (`slot_number`) REFERENCES `slotidx` (`slot_number`),
CONSTRAINT `preuserattachment8_ibfk_2` FOREIGN KEY (`preslot`) REFERENCES `preslot` (`preslot`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of preuserattachment8
-- ----------------------------
-- ----------------------------
-- Table structure for `preuserattachment9`
-- ----------------------------
DROP TABLE IF EXISTS `preuserattachment9`;
CREATE TABLE `preuserattachment9` (
`characteridx` INT(11) NOT NULL,
`slot_number` INT(11) NOT NULL,
`preslot` SMALLINT(6) NOT NULL,
`itemserial` VARCHAR(255) NOT NULL,
`itemidx` INT(11) NOT NULL,
`option1` SMALLINT(6) NOT NULL,
`option2` SMALLINT(6) NOT NULL,
`option3` SMALLINT(6) NOT NULL,
`option4` SMALLINT(6) NOT NULL,
`option5` SMALLINT(6) NOT NULL,
`optionlevel1` SMALLINT(6) NOT NULL,
`optionlevel2` SMALLINT(6) NOT NULL,
`optionlevel3` SMALLINT(6) NOT NULL,
`optionlevel4` SMALLINT(6) NOT NULL,
`optionlevel5` SMALLINT(6) NOT NULL,
`socket` VARCHAR(50) NOT NULL,
`timelimite1` INT(11) NOT NULL,
`timelimite2` INT(11) NOT NULL,
`plus` INT(11) NOT NULL,
`flag` INT(11) NOT NULL,
`itemcount` BIGINT(20) NOT NULL,
PRIMARY KEY (`characteridx`,`slot_number`,`preslot`),
KEY `slotNumberpreuserattachment9` (`slot_number`),
KEY `preslotpreuserattachment9` (`preslot`),
CONSTRAINT `preuserattachment9_ibfk_1` FOREIGN KEY (`slot_number`) REFERENCES `slotidx` (`slot_number`),
CONSTRAINT `preuserattachment9_ibfk_2` FOREIGN KEY (`preslot`) REFERENCES `preslot` (`preslot`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of preuserattachment9
-- ----------------------------
-- ----------------------------
-- Table structure for `slotidx`
-- ----------------------------
DROP TABLE IF EXISTS `slotidx`;
CREATE TABLE `slotidx` (
`slot_number` INT(11) NOT NULL,
PRIMARY KEY (`slot_number`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of slotidx
-- ----------------------------
-- ----------------------------
-- Table structure for `storage_postoffice`
-- ----------------------------
DROP TABLE IF EXISTS `storage_postoffice`;
CREATE TABLE `storage_postoffice` (
`recvdate` VARCHAR(50) NOT NULL,
`sendcharacteridx` INT(11) NOT NULL,
`msgcategory` SMALLINT(6) NOT NULL DEFAULT '-1',
`msgtype` SMALLINT(6) NOT NULL DEFAULT '-1',
`recvcharacteridx` INT(11) NOT NULL DEFAULT '0',
`subject` VARCHAR(41) DEFAULT '',
`contents` VARCHAR(255) DEFAULT '',
`money` BIGINT(20) DEFAULT '0',
`billreqflag` SMALLINT(6) NOT NULL DEFAULT '0',
`viewicon` INT(11) NOT NULL DEFAULT '0',
`sendName` VARCHAR(20) NOT NULL DEFAULT '',
`recvName` VARCHAR(20) NOT NULL DEFAULT '',
PRIMARY KEY (`recvdate`,`sendcharacteridx`,`msgcategory`,`msgtype`),
KEY `msgcategorystorage_postoffice` (`msgcategory`),
KEY `msgtypestorage_postoffice` (`msgtype`),
KEY `sendcharacteridxstorage_postoffice` (`sendcharacteridx`),
CONSTRAINT `storage_postoffice_ibfk_1` FOREIGN KEY (`msgcategory`) REFERENCES `premiumtype` (`msgcategory`),
CONSTRAINT `storage_postoffice_ibfk_2` FOREIGN KEY (`msgtype`) REFERENCES `msgtype` (`msgtype`),
CONSTRAINT `storage_postoffice_ibfk_3` FOREIGN KEY (`sendcharacteridx`) REFERENCES `mailaccount` (`sendcharacteridx`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of storage_postoffice
-- ----------------------------
-- ----------------------------
-- Table structure for `storage_postoffice_att0`
-- ----------------------------
DROP TABLE IF EXISTS `storage_postoffice_att0`;
CREATE TABLE `storage_postoffice_att0` (
`sendcharacteridx` INT(11) NOT NULL,
`recvcharacteridx` INT(11) NOT NULL,
`recvdate` VARCHAR(50) NOT NULL,
`msgcategory` SMALLINT(6) NOT NULL,
`preslot` SMALLINT(6) NOT NULL,
`msgtype` SMALLINT(6) NOT NULL,
`itemserial` VARCHAR(255) NOT NULL DEFAULT '',
`itemidx` INT(11) NOT NULL DEFAULT '-1',
`option1` SMALLINT(6) NOT NULL DEFAULT '0',
`option2` SMALLINT(6) NOT NULL DEFAULT '0',
`option3` SMALLINT(6) NOT NULL DEFAULT '0',
`option4` SMALLINT(6) NOT NULL DEFAULT '0',
`option5` SMALLINT(6) NOT NULL DEFAULT '0',
`optionlevel1` SMALLINT(6) NOT NULL DEFAULT '0',
`optionlevel2` SMALLINT(6) NOT NULL DEFAULT '0',
`optionlevel3` SMALLINT(6) NOT NULL DEFAULT '0',
`optionlevel4` SMALLINT(6) NOT NULL DEFAULT '0',
`optionlevel5` SMALLINT(6) NOT NULL DEFAULT '0',
`socket` VARCHAR(50) NOT NULL DEFAULT '',
`timelimite1` INT(11) NOT NULL DEFAULT '-1',
`timelimite2` INT(11) NOT NULL DEFAULT '-1',
`plus` INT(11) NOT NULL DEFAULT '0',
`flag` INT(11) NOT NULL DEFAULT '0',
`itemcount` BIGINT(20) NOT NULL DEFAULT '0',
PRIMARY KEY (`sendcharacteridx`,`recvcharacteridx`,`recvdate`,`msgcategory`,`preslot`,`msgtype`),
KEY `storage_postofficestorage_postoffice_att0` (`recvdate`,`sendcharacteridx`,`msgcategory`,`msgtype`),
KEY `preslotstorage_postoffice_att0` (`preslot`),
CONSTRAINT `storage_postoffice_att0_ibfk_1` FOREIGN KEY (`recvdate`, `sendcharacteridx`, `msgcategory`, `msgtype`) REFERENCES `storage_postoffice` (`recvdate`, `sendcharacteridx`, `msgcategory`, `msgtype`),
CONSTRAINT `storage_postoffice_att0_ibfk_2` FOREIGN KEY (`preslot`) REFERENCES `preslot` (`preslot`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of storage_postoffice_att0
-- ----------------------------
-- ----------------------------
-- Table structure for `storage_postoffice_att1`
-- ----------------------------
DROP TABLE IF EXISTS `storage_postoffice_att1`;
CREATE TABLE `storage_postoffice_att1` (
`recvcharacteridx` INT(11) NOT NULL,
`sendcharacteridx` INT(11) NOT NULL,
`recvdate` VARCHAR(50) NOT NULL,
`msgcategory` SMALLINT(6) NOT NULL,
`preslot` SMALLINT(6) NOT NULL,
`msgtype` SMALLINT(6) NOT NULL,
`itemserial` VARCHAR(255) NOT NULL DEFAULT '',
`itemidx` INT(11) NOT NULL DEFAULT '-1',
`option1` SMALLINT(6) NOT NULL DEFAULT '0',
`option2` SMALLINT(6) NOT NULL DEFAULT '0',
`option3` SMALLINT(6) NOT NULL DEFAULT '0',
`option4` SMALLINT(6) NOT NULL DEFAULT '0',
`option5` SMALLINT(6) NOT NULL DEFAULT '0',
`optionlevel1` SMALLINT(6) NOT NULL DEFAULT '0',
`optionlevel2` SMALLINT(6) NOT NULL DEFAULT '0',
`optionlevel3` SMALLINT(6) NOT NULL DEFAULT '0',
`optionlevel4` SMALLINT(6) NOT NULL DEFAULT '0',
`optionlevel5` SMALLINT(6) NOT NULL DEFAULT '0',
`socket` VARCHAR(50) NOT NULL DEFAULT '',
`timelimite1` INT(11) NOT NULL DEFAULT '-1',
`timelimite2` INT(11) NOT NULL DEFAULT '-1',
`plus` INT(11) NOT NULL DEFAULT '0',
`flag` INT(11) NOT NULL DEFAULT '0',
`itemcount` BIGINT(20) NOT NULL DEFAULT '0',
PRIMARY KEY (`recvcharacteridx`,`sendcharacteridx`,`recvdate`,`msgcategory`,`preslot`,`msgtype`),
KEY `storage_postofficestorage_postoffice_att1` (`recvdate`,`sendcharacteridx`,`msgcategory`,`msgtype`),
KEY `preslotstorage_postoffice_att1` (`preslot`),
CONSTRAINT `storage_postoffice_att1_ibfk_1` FOREIGN KEY (`recvdate`, `sendcharacteridx`, `msgcategory`, `msgtype`) REFERENCES `storage_postoffice` (`recvdate`, `sendcharacteridx`, `msgcategory`, `msgtype`),
CONSTRAINT `storage_postoffice_att1_ibfk_2` FOREIGN KEY (`preslot`) REFERENCES `preslot` (`preslot`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of storage_postoffice_att1
-- ----------------------------
-- ----------------------------
-- Table structure for `storage_postoffice_att2`
-- ----------------------------
DROP TABLE IF EXISTS `storage_postoffice_att2`;
CREATE TABLE `storage_postoffice_att2` (
`recvcharacteridx` INT(11) NOT NULL,
`sendcharacteridx` INT(11) NOT NULL,
`recvdate` VARCHAR(50) NOT NULL,
`msgcategory` SMALLINT(6) NOT NULL,
`preslot` SMALLINT(6) NOT NULL,
`msgtype` SMALLINT(6) NOT NULL,
`itemserial` VARCHAR(255) NOT NULL DEFAULT '',
`itemidx` INT(11) NOT NULL DEFAULT '-1',
`option1` SMALLINT(6) NOT NULL DEFAULT '0',
`option2` SMALLINT(6) NOT NULL DEFAULT '0',
`option3` SMALLINT(6) NOT NULL DEFAULT '0',
`option4` SMALLINT(6) NOT NULL DEFAULT '0',
`option5` SMALLINT(6) NOT NULL DEFAULT '0',
`optionlevel1` SMALLINT(6) NOT NULL DEFAULT '0',
`optionlevel2` SMALLINT(6) NOT NULL DEFAULT '0',
`optionlevel3` SMALLINT(6) NOT NULL DEFAULT '0',
`optionlevel4` SMALLINT(6) NOT NULL DEFAULT '0',
`optionlevel5` SMALLINT(6) NOT NULL DEFAULT '0',
`socket` VARCHAR(50) NOT NULL DEFAULT '',
`timelimite1` INT(11) NOT NULL DEFAULT '-1',
`timelimite2` INT(11) NOT NULL DEFAULT '-1',
`plus` INT(11) NOT NULL DEFAULT '0',
`flag` INT(11) NOT NULL DEFAULT '0',
`itemcount` BIGINT(20) NOT NULL DEFAULT '0',
PRIMARY KEY (`recvcharacteridx`,`sendcharacteridx`,`recvdate`,`msgcategory`,`preslot`,`msgtype`),
KEY `storage_postofficestorage_postoffice_att2` (`recvdate`,`sendcharacteridx`,`msgcategory`,`msgtype`),
KEY `preslotstorage_postoffice_att2` (`preslot`),
CONSTRAINT `storage_postoffice_att2_ibfk_1` FOREIGN KEY (`recvdate`, `sendcharacteridx`, `msgcategory`, `msgtype`) REFERENCES `storage_postoffice` (`recvdate`, `sendcharacteridx`, `msgcategory`, `msgtype`),
CONSTRAINT `storage_postoffice_att2_ibfk_2` FOREIGN KEY (`preslot`) REFERENCES `preslot` (`preslot`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of storage_postoffice_att2
-- ----------------------------
-- ----------------------------
-- Table structure for `storage_postoffice_att3`
-- ----------------------------
DROP TABLE IF EXISTS `storage_postoffice_att3`;
CREATE TABLE `storage_postoffice_att3` (
`recvcharacteridx` INT(11) NOT NULL,
`sendcharacteridx` INT(11) NOT NULL,
`recvdate` VARCHAR(50) NOT NULL,
`msgcategory` SMALLINT(6) NOT NULL,
`preslot` SMALLINT(6) NOT NULL,
`msgtype` SMALLINT(6) NOT NULL,
`itemserial` VARCHAR(255) NOT NULL DEFAULT '',
`itemidx` INT(11) NOT NULL DEFAULT '-1',
`option1` SMALLINT(6) NOT NULL DEFAULT '0',
`option2` SMALLINT(6) NOT NULL DEFAULT '0',
`option3` SMALLINT(6) NOT NULL DEFAULT '0',
`option4` SMALLINT(6) NOT NULL DEFAULT '0',
`option5` SMALLINT(6) NOT NULL DEFAULT '0',
`optionlevel1` SMALLINT(6) NOT NULL DEFAULT '0',
`optionlevel2` SMALLINT(6) NOT NULL DEFAULT '0',
`optionlevel3` SMALLINT(6) NOT NULL DEFAULT '0',
`optionlevel4` SMALLINT(6) NOT NULL DEFAULT '0',
`optionlevel5` SMALLINT(6) NOT NULL DEFAULT '0',
`socket` VARCHAR(50) NOT NULL DEFAULT '',
`timelimite1` INT(11) NOT NULL DEFAULT '-1',
`timelimite2` INT(11) NOT NULL DEFAULT '-1',
`plus` INT(11) NOT NULL DEFAULT '0',
`flag` INT(11) NOT NULL DEFAULT '0',
`itemcount` BIGINT(20) NOT NULL DEFAULT '0',
PRIMARY KEY (`recvcharacteridx`,`sendcharacteridx`,`recvdate`,`msgcategory`,`preslot`,`msgtype`),
KEY `storage_postofficestorage_postoffice_att3` (`recvdate`,`sendcharacteridx`,`msgcategory`,`msgtype`),
KEY `preslotstorage_postoffice_att3` (`preslot`),
CONSTRAINT `storage_postoffice_att3_ibfk_1` FOREIGN KEY (`recvdate`, `sendcharacteridx`, `msgcategory`, `msgtype`) REFERENCES `storage_postoffice` (`recvdate`, `sendcharacteridx`, `msgcategory`, `msgtype`),
CONSTRAINT `storage_postoffice_att3_ibfk_2` FOREIGN KEY (`preslot`) REFERENCES `preslot` (`preslot`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of storage_postoffice_att3
-- ----------------------------
-- ----------------------------
-- Table structure for `storage_postoffice_att4`
-- ----------------------------
DROP TABLE IF EXISTS `storage_postoffice_att4`;
CREATE TABLE `storage_postoffice_att4` (
`recvcharacteridx` INT(11) NOT NULL,
`sendcharacteridx` INT(11) NOT NULL,
`recvdate` VARCHAR(50) NOT NULL,
`msgcategory` SMALLINT(6) NOT NULL,
`preslot` SMALLINT(6) NOT NULL,
`msgtype` SMALLINT(6) NOT NULL,
`itemserial` VARCHAR(255) NOT NULL DEFAULT '',
`itemidx` INT(11) NOT NULL DEFAULT '-1',
`option1` SMALLINT(6) NOT NULL DEFAULT '0',
`option2` SMALLINT(6) NOT NULL DEFAULT '0',
`option3` SMALLINT(6) NOT NULL DEFAULT '0',
`option4` SMALLINT(6) NOT NULL DEFAULT '0',
`option5` SMALLINT(6) NOT NULL DEFA