11-18-2012, 08:24 PM
Its a wrong DB from Koko and its dont have all full infos and have wrong infos...................... and the his IP insite lol
/*
Navicat MySQL Data Transfer
Source Host : 192.168.56.3:3306
Source Database : newproject_post
Target Host : 192.168.56.3:3306
Target Database : newproject_post
Date: 2012-11-18 21:06:37
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for postoffice
-- ----------------------------
DROP TABLE IF EXISTS `postoffice`;
CREATE TABLE `postoffice` (
`slot_number` int(11) DEFAULT NULL,
`subject` varchar(20) NOT NULL,
`characteridx` int(11) NOT NULL,
`msgcategory` int(11) DEFAULT NULL,
`contents` varchar(255) NOT NULL,
`money` int(11) DEFAULT NULL,
`msgtype` int(11) DEFAULT NULL,
`billreqflag` int(11) DEFAULT NULL,
`timeresult` time DEFAULT NULL,
`viewicon` int(11) DEFAULT NULL,
`sendName` varchar(20) DEFAULT NULL,
`recvName` varchar(20) DEFAULT NULL,
`limittime` int(11) DEFAULT NULL,
`itemserial` int(11) DEFAULT NULL,
`itemidx` int(11) NOT NULL,
`option1` int(11) DEFAULT NULL,
`option2` int(11) DEFAULT NULL,
`option3` int(11) DEFAULT NULL,
`option4` int(11) DEFAULT NULL,
`option5` int(11) DEFAULT NULL,
`optionlevel1` int(11) DEFAULT NULL,
`optionlevel2` int(11) DEFAULT NULL,
`optionlevel3` int(11) DEFAULT NULL,
`optionlevel4` int(11) DEFAULT NULL,
`optionlevel5` int(11) DEFAULT NULL,
`socket` int(11) DEFAULT NULL,
`timelimite1` int(11) DEFAULT NULL,
`timelimite2` int(11) DEFAULT NULL,
`plus` int(11) DEFAULT NULL,
`flag` int(11) DEFAULT NULL,
`itemcount` int(11) DEFAULT NULL,
`preslot` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of postoffice
-- ----------------------------
INSERT INTO `postoffice` VALUES ('1', 'test', '1', '1', 'test test', '1', '1', '1', '-00:00:01', '1', 'test', 'test', '-1', null, '0', '-1', '-1', '-1', '-1', '-1', '-1', '-1', '-1', '-1', '-1', '-1', '-1', '-1', '0', '-1', '0', '0');
-- ----------------------------
-- Table structure for usermailbox
-- ----------------------------
DROP TABLE IF EXISTS `usermailbox`;
CREATE TABLE `usermailbox` (
`slot_number` int(11) DEFAULT NULL,
`subject` varchar(20) NOT NULL,
`characteridx` int(11) NOT NULL,
`msgcategory` int(11) DEFAULT NULL,
`contents` varchar(255) NOT NULL,
`money` int(11) DEFAULT NULL,
`msgtype` int(11) DEFAULT NULL,
`billreqflag` int(11) DEFAULT NULL,
`timeresult` time DEFAULT NULL,
`viewicon` int(11) DEFAULT NULL,
`sendName` varchar(20) DEFAULT NULL,
`recvName` varchar(20) DEFAULT NULL,
`limittime` int(11) DEFAULT NULL,
`itemserial` int(11) DEFAULT NULL,
`itemidx` int(11) NOT NULL,
`option1` int(11) DEFAULT NULL,
`option2` int(11) DEFAULT NULL,
`option3` int(11) DEFAULT NULL,
`option4` int(11) DEFAULT NULL,
`option5` int(11) DEFAULT NULL,
`optionlevel1` int(11) DEFAULT NULL,
`optionlevel2` int(11) DEFAULT NULL,
`optionlevel3` int(11) DEFAULT NULL,
`optionlevel4` int(11) DEFAULT NULL,
`optionlevel5` int(11) DEFAULT NULL,
`socket` int(11) DEFAULT NULL,
`timelimite1` int(11) DEFAULT NULL,
`timelimite2` int(11) DEFAULT NULL,
`plus` int(11) DEFAULT NULL,
`flag` int(11) DEFAULT NULL,
`itemcount` int(11) DEFAULT NULL,
`preslot` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of usermailbox
-- ----------------------------
The Right usermailbox (I have delet strings)
-- ----------------------------
-- Table structure for `usermailbox`
-- ----------------------------
DROP TABLE IF EXISTS `usermailbox`;
CREATE TABLE `usermailbox` (
`characteridx` int(11) NOT NULL,
`msgcategory` smallint(6) NOT NULL DEFAULT '-1',
`*************************************************,
`msgtype` smallint(6) NOT NULL DEFAULT '-1',
`**************************************************,
`contents` varchar(255) DEFAULT '',
`******************************,
`billreqflag` smallint(6) NOT NULL DEFAULT '0',
`limittime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`viewicon` int(11) DEFAULT '-1',
`sendcharacteridx` int(11) NOT NULL,
`********************************************'',
`recvName` varchar(20) NOT NULL DEFAULT '',
PRIMARY KEY (`characteridx`,`msgcategory`,`slot_number`,`msgtype`),
KEY `slotnumberusermailbox` (`slot_number`),
KEY `msgcategoryusermailbox` (`msgcategory`),
KEY `msgtypeusermailbox` (`msgtype`),
CONSTRAINT `usermailbox_ibfk_1` FOREIGN KEY (`slot_number`) REFERENCES `slotidx` (`slot_number`),
CONSTRAINT `usermailbox_ibfk_2` FOREIGN KEY (`msgcategory`) REFERENCES `premiumtype` (`msgcategory`),
CONSTRAINT `usermailbox_ibfk_3` FOREIGN KEY (`msgtype`) REFERENCES `msgtype` (`msgtype`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of usermailbox
-- ----------------------------