wihrkp50

1DROP TABLE IF EXISTS `cm_log`;
2CREATE TABLE `cm_log` (
3  `account_id` int(11) unsigned NOT NULL default '0',
4  `charname` varchar(255) NOT NULL default '',
5  `itemname` varchar(255) NOT NULL default '',
6  `nameid` int(11) unsigned NOT NULL default '0',
7  `amount` int(11) unsigned NOT NULL default '0',
8  KEY `account_id` (`account_id`)
9) ENGINE=MyISAM;
10
11DROP TABLE IF EXISTS `cm_db`;
12CREATE TABLE `cm_db` (
13  `account_id` int(11) unsigned NOT NULL default '0',
14  `cash` int(11) unsigned NOT NULL default '0',
15  `mail` int(11) unsigned NOT NULL default '0',
16  `nameid` int(11) unsigned NOT NULL default '0',
17  `amount` int(11) unsigned NOT NULL default '0',
18  KEY `account_id` (`account_id`)
19) TYPE=MyISAM;
20DROP TABLE IF EXISTS `cm_itemdb`;
21CREATE TABLE `cm_itemdb` (
22  `id`int(11) unsigned not null auto_increment,
23  `nameid` int(11) unsigned NOT NULL default '0',
24  `price` int(11) unsigned NOT NULL default '0',
25  `type` int(11) unsigned NOT NULL default '0',
26  KEY `id` (`id`)
27) ENGINE=MyISAM;
28
29alter table login add vipdia int(4) not null default '0';