Good evening friends, in advance sorry I did not find the topic I am interested in

 

1) how to raise the experience for the mission

2) how to raise rates the on HS (stone gods) to do the above?

3) how to increase the points for a fraction?

 

advance thank you for helping push (thanks)

Hi guys is that possible to convert the ep2 connector of linux to ep1 connector for windows 7?

It will be very good for ep1 . + cuz it can support all maps and many people some one now?

Hi, as part of my study the Last Chaos database, i want to put here how to add items to put the LacaBall functioning.

So open your database and find t_lcball and if its empty start filling like the example i put next.

Ok, click Insert and for example, lets make an Hp Stealer prize.

 

a_item_order - Value: 1

a_tocken_index - Value: 5123

a_course_code - Value: 0

a_order - Value: 0

a_item_index - Value: 2357

a_item_count - Value: 1

a_item_max - Value: 500

a_item_remain - Value: 500

 

Click Go and go to the game and click the lacaball icon, you will see, with a normal token, you can get hp stealer, the quantity is set to 500, but this is just an example, is not for you to copy XD.

 

I hope this helps those who doesnt have LcBall working and dont have any idea how to edit the DB.

Just a small thing, in a_item_remain, if you set 500, in the game the value will not decrease, it will always remain the value you set. As im still trying to figure it out, i cant tell you guys how to make it subtract. If anyone knows, please feel free to post it, and i edit this post and give credits to him/her.

 

thanks

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

2

2

 

hi all .

Tht's my problem , when I click on siege request (merac or dratan happen the same thing) or join as defender , nothing happen , no error message , no confirmation , nothing , like I've not clicked .

 

guild is lvl60

got 20 members

got hero's necklage and got money .

I spaw the siege npc with command because they aren't on spaw zone , maybe I've to register them somewere ?

pls help and ty

GameServer1/run2...

 

 

StartService.sh...

 

 

Help me pls... Server for vps...

As title says im looking for tool which edit set options. If someone has it I'd be grateful if you share.

ok i see i need open the port for not get error at the login ok i make that

 

screnn of iptables -> 2

 

later save and close

 

later restart here -> 2

 

and later put the port 4001 to the newstormBin LoginServer and same in the sl.dta of client

 

try login with account hashed and still can't login i get

 

"Failed To Connect to Login Server

 

but if i don't put any password i don't get error -> i get please enter password

 

i think because the port 4001 are not open but you can see on the scrennshoot i have make all right

 

to open port and close save and restart with the terminal and go to user run all GameServer ect

 

and don't work any soluce please

 

will be good

Hi all... I have searched the answer but without result... I have the cannot connect to game server problem... when i connect using my PC all is ok but when i use my laptop with another ip i have cannot connect to game server ;/ i'm using centos 6.3 I hope that you can help me...

Here is a little on how to make a potion to make it heal more.

 

Step 1:

Check the "skill ID" that the potion have (use Item All Editor by Wizatek)

 

Step 2:

Use the Skill Editor to search for the "ID" of the potion

 

Step 3:

Copy the "Magic ID" that this potion ID have

 

Step 4:

Go to "t_magiclevel" in "newproject_data" and add more "power" to the potion

 

Step 5:

Go in game and try your new potion

 

 

Hope it works!

 

Credits to DrGenius