mRYvLZRa

1ALTER TABLE  `dle_users` 
2					ADD  	`money` INT NOT NULL DEFAULT  '0',
3					ADD		`server_0` varchar(50) NOT NULL,
4					ADD		`server_1` varchar(50) NOT NULL,
5					ADD		`server_2` varchar(50) NOT NULL,
6					ADD		`lk_hdskin` tinyint(1) NOT NULL DEFAULT '0',
7					ADD		`lk_cloak` tinyint(1) NOT NULL DEFAULT '0',
8					ADD		`lk_hdcloak` tinyint(1) NOT NULL DEFAULT '0',
9					ADD		`lk_prefix` tinyint(1) NOT NULL DEFAULT '0',
10					ADD		`lk_warp` tinyint(1) NOT NULL DEFAULT '0';
11				
12				CREATE TABLE `lk_pexrights` ( 
13				  `userId` int(11) NOT NULL, 
14				  `pexRightId` int(11) NOT NULL, 
15				  `rightId` int(11) NOT NULL, 
16				  `time` int(11) NOT NULL 
17				) ENGINE=InnoDB DEFAULT CHARSET=utf8; 
18				
19				CREATE TABLE IF NOT EXISTS `lk_vauchers` (
20				  `id` int(11) NOT NULL AUTO_INCREMENT,
21				  `name` varchar(30) NOT NULL,
22				  `eval` varchar(128) NOT NULL,
23				  `message` varchar(256) NOT NULL,
24				  PRIMARY KEY (`id`)
25				) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;
26				
27				
28				CREATE TABLE IF NOT EXISTS `shop_trans` (
29				  `id` int(11) NOT NULL AUTO_INCREMENT,
30				  `payid` int(11) NOT NULL,
31				  `userid` int(11) NOT NULL,
32				  `sum` int(11) NOT NULL,
33				  `status` varchar(30) NOT NULL,
34				  `cur` varchar(3) NOT NULL,
35				  `date` int(11) NOT NULL,
36				  PRIMARY KEY (`id`)
37				) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;