VKrBNYbV

1CREATE TABLE IF NOT EXISTS `shop_basket` (
2						  `id` int(11) NOT NULL AUTO_INCREMENT,
3						  `type` int(1) NOT NULL,
4						  `user_id` int(11) NOT NULL,
5						  `block_id` int(11) NOT NULL,
6						  `amount` int(11) NOT NULL,
7						  `date` int(11) NOT NULL,
8						  PRIMARY KEY (`id`)
9						) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=0 ;
10
11CREATE TABLE IF NOT EXISTS `shop_trans` (
12						  `id` int(11) NOT NULL AUTO_INCREMENT,
13						  `payid` int(11) NOT NULL,
14						  `userid` int(11) NOT NULL,
15						  `sum` int(11) NOT NULL,
16						  `status` varchar(30) NOT NULL,
17						  `cur` varchar(3) NOT NULL,
18						  `date` int(11) NOT NULL,
19						  PRIMARY KEY (`id`)
20						) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;
21
22CREATE TABLE IF NOT EXISTS `shop_blocks` (
23						  `id` int(11) NOT NULL AUTO_INCREMENT,
24						  `block_id` int(11) NOT NULL,
25						  `block_n` int(11) NOT NULL,
26						  `name` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
27						  `amount` int(11) NOT NULL,
28						  `price` int(11) NOT NULL,
29						  `discount` int(11) NOT NULL,
30						  `server` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
31						  `cat` int(11) NOT NULL,
32						  `time_dis` int(11) NOT NULL,
33						  `enchants` varchar(150) NOT NULL,
34						  PRIMARY KEY (`id`)
35						) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=352 ;
36						
37						INSERT INTO `shop_blocks` (`id`, `block_id`, `block_n`, `name`, `amount`, `price`, `discount`, `server`, `cat`, `time_dis`, `enchants`) VALUES
38							(1, 1, 0, 'Камень', 64, 10, 0, 'all', 1, 0, ''),
39							(96, 2, 0, 'Трава', 1, 10, 0, 'all', 1, 0, ''),
40							(164, 3, 0, 'Земля', 1, 10, 0, 'all', 1, 0, ''),
41							(284, 4, 0, 'Булыжник', 1, 10, 0, 'all', 0, 0, ''),
42							(308, 5, 0, 'Дубовые доски', 1, 10, 0, 'all', 0, 0, ''),
43							(314, 5, 1, 'Еловые доски', 1, 10, 0, 'all', 0, 0, ''),
44							(315, 5, 2, 'Берёзовые доски', 1, 10, 0, 'all', 0, 0, ''),
45							(316, 5, 3, 'Доски из тропического дерева', 1, 10, 0, 'all', 0, 0, ''),
46							(317, 6, 0, 'Саженец дуба', 1, 10, 0, 'all', 6, 0, ''),
47							(323, 6, 1, 'Саженец ели', 1, 10, 0, 'all', 6, 0, ''),
48							(324, 6, 2, 'Саженец берёзы', 1, 10, 0, 'all', 6, 0, ''),
49							(325, 6, 3, 'Саженец тропического дерева', 1, 10, 0, 'all', 6, 0, ''),
50							(326, 7, 0, 'Бедрок', 1, 100, 0, 'all', 0, 0, ''),
51							(15, 12, 0, 'Песок', 1, 10, 0, 'all', 0, 0, ''),
52							(25, 13, 0, 'Гравий', 1, 10, 0, 'all', 0, 0, ''),
53							(35, 14, 0, 'Золотая руда', 1, 10, 0, 'all', 0, 0, ''),
54							(40, 15, 0, 'Железная руда', 1, 10, 0, 'all', 0, 0, ''),
55							(67, 16, 0, 'Уголь', 1, 10, 0, 'all', 0, 0, ''),
56							(68, 17, 0, 'Дуб', 1, 10, 0, 'all', 0, 0, ''),
57							(88, 17, 1, 'Ель', 1, 10, 0, 'all', 0, 0, ''),
58							(89, 17, 2, 'Берёза', 1, 10, 0, 'all', 0, 0, ''),
59							(90, 17, 3, 'Тропическое дерево', 1, 10, 0, 'all', 0, 0, ''),
60							(91, 18, 0, 'Дубовая листва', 1, 10, 0, 'all', 0, 0, ''),
61							(92, 18, 1, 'Хвоя', 1, 10, 0, 'all', 0, 0, ''),
62							(93, 18, 2, 'Берёзовая листва', 1, 10, 0, 'all', 0, 0, ''),
63							(94, 18, 3, 'Тропическая листва', 1, 10, 0, 'all', 0, 0, ''),
64							(95, 19, 0, 'Губка', 1, 10, 0, 'all', 0, 0, ''),
65							(97, 20, 0, 'Стекло', 1, 10, 0, 'all', 0, 0, '');
66
67
68
69CREATE TABLE IF NOT EXISTS `GetItem` (
70						  `id` int(11) NOT NULL AUTO_INCREMENT,
71						  `nickname` varchar(16) NOT NULL,
72						  `server` int(11) NOT NULL,
73						  `item_id` varchar(30) NOT NULL,
74						  `item_amount` int(11) NOT NULL,
75						  `enchants` varchar(150) NOT NULL,
76						  `time` int(11) NOT NULL,
77						  PRIMARY KEY (`id`)
78						) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=115 ;