Ls5bvASt

1DROP TABLE IF EXISTS `logs`.`cashshop_log`;
2CREATE TABLE  `logs`.`cashshop_log` (
3  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
4  `characterid` int(10) unsigned NOT NULL,
5  `itemid` int(10) unsigned NOT NULL,
6  `quantity` int(10) unsigned NOT NULL,
7  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
8  `price` int(10) unsigned NOT NULL,
9  `cashtype` int(10) unsigned NOT NULL,
10  `obs` text,
11  PRIMARY KEY (`id`)
12) ENGINE=InnoDB AUTO_INCREMENT=36147 DEFAULT CHARSET=latin1;
13
14DROP TABLE IF EXISTS `logs`.`chat_log`;
15CREATE TABLE  `logs`.`chat_log` (
16  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
17  `mapid` int(10) unsigned NOT NULL,
18  `characterid` int(10) unsigned NOT NULL,
19  `text` longtext NOT NULL,
20  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
21  PRIMARY KEY (`id`)
22) ENGINE=InnoDB AUTO_INCREMENT=7389995 DEFAULT CHARSET=latin1;
23
24DROP TABLE IF EXISTS `logs`.`ip_log`;
25CREATE TABLE  `logs`.`ip_log` (
26  `iplogid` int(10) unsigned NOT NULL AUTO_INCREMENT,
27  `accountid` int(11) NOT NULL DEFAULT '0',
28  `ip` varchar(30) NOT NULL DEFAULT '',
29  `login` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
30  PRIMARY KEY (`iplogid`),
31  KEY `accountid` (`accountid`,`ip`),
32  KEY `ip` (`ip`)
33) ENGINE=InnoDB AUTO_INCREMENT=2321433 DEFAULT CHARSET=latin1;
34
35DROP TABLE IF EXISTS `logs`.`merchant_log`;
36CREATE TABLE  `logs`.`merchant_log` (
37  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
38  `itemid` int(10) unsigned NOT NULL,
39  `meso` int(10) unsigned NOT NULL,
40  `characterid` int(10) unsigned NOT NULL,
41  `sellerid` int(10) unsigned NOT NULL,
42  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
43  PRIMARY KEY (`id`)
44) ENGINE=InnoDB AUTO_INCREMENT=56656 DEFAULT CHARSET=latin1;
45
46DROP TABLE IF EXISTS `logs`.`meso_log`;
47CREATE TABLE  `logs`.`meso_log` (
48  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
49  `meso` int(10) unsigned NOT NULL,
50  `charid` int(10) unsigned NOT NULL,
51  `monsterid` int(10) unsigned NOT NULL,
52  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
53  PRIMARY KEY (`id`)
54) ENGINE=InnoDB AUTO_INCREMENT=55046498 DEFAULT CHARSET=latin1;
55
56DROP TABLE IF EXISTS `logs`.`shop_log`;
57CREATE TABLE  `logs`.`shop_log` (
58  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
59  `itemid` int(10) unsigned NOT NULL,
60  `meso` int(10) unsigned NOT NULL,
61  `characterid` int(10) unsigned NOT NULL,
62  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
63  PRIMARY KEY (`id`)
64) ENGINE=InnoDB AUTO_INCREMENT=2882381 DEFAULT CHARSET=latin1;
65
66DROP TABLE IF EXISTS `logs`.`whisper_log`;
67CREATE TABLE  `logs`.`whisper_log` (
68  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
69  `from` int(10) unsigned NOT NULL,
70  `to` int(10) unsigned NOT NULL,
71  `text` longtext NOT NULL,
72  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
73  PRIMARY KEY (`id`)
74) ENGINE=InnoDB AUTO_INCREMENT=1371480 DEFAULT CHARSET=latin1;