bxv0WqsJ

1DROP TABLE IF EXISTS `characters`;
2CREATE TABLE `characters`(
3  `id` int(11) NOT NULL AUTO_INCREMENT,
4  `accId` int(11) NOT NULL,
5  `charId` int(11) NOT NULL,
6  `charType` int(11) NOT NULL,
7  `level` int(11) NOT NULL,
8  `exp` int(11) NOT NULL,
9  `fame` int(11) NOT NULL,
10  `items` varchar(128) NOT NULL,
11  `hp` int(11) NOT NULL,
12  `mp` int(11) NOT NULL,
13  `stats` varchar(64) NOT NULL DEFAULT '"1,2,3,4,5,6,7,8"',
14  `dead` tinyint(1) NOT NULL DEFAULT '0',
15  `tex1` int(11) NOT NULL DEFAULT '0',
16  `tex2` int(11) NOT NULL DEFAULT '0',
17  `pet` int(11) NOT NULL DEFAULT '0',
18  `fameStats` varchar(128) NOT NULL DEFAULT 'eNoVytkRgCAMRdGH4IIbgmsPdmNVNmZf5n7kzM0kksLjJN2V4b30vcHK1YYam9hCxxqh5zpQI0wwQ4IFMhRYYeNjpw444YIfA3kDIA',
19  `createTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
20  `deathTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
21  `totalFame` int(11) NOT NULL DEFAULT '0',
22  PRIMARY KEY (`id`)
23) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=utf8;
24	
25`createTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
26  `deathTime`  timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
27	
28`createTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
29  `deathTime`  timestamp NOT NULL,