psVXZBKx

1SET FOREIGN_KEY_CHECKS=0;
2
3-- ----------------------------
4-- Table structure for bonus_code
5-- ----------------------------
6DROP TABLE IF EXISTS `bonus_code`;
7CREATE TABLE `bonus_code` (
8  `id` int(11) NOT NULL AUTO_INCREMENT,
9  `code` varchar(255) COLLATE utf8_polish_ci DEFAULT NULL,
10  `value` int(11) DEFAULT NULL,
11  `use` int(11) NOT NULL DEFAULT '0',
12  PRIMARY KEY (`id`)
13) ENGINE=InnoDB AUTO_INCREMENT=86 DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci;
14
15-- ----------------------------
16-- Table structure for itemshop_items
17-- ----------------------------
18DROP TABLE IF EXISTS `itemshop_items`;
19CREATE TABLE `itemshop_items` (
20  `id` int(11) NOT NULL AUTO_INCREMENT,
21  `name` varchar(255) COLLATE utf8_polish_ci DEFAULT NULL,
22  `price` int(11) DEFAULT NULL,
23  `count` int(11) DEFAULT NULL,
24  `image` varchar(255) COLLATE utf8_polish_ci DEFAULT NULL,
25  `description` varchar(255) COLLATE utf8_polish_ci DEFAULT NULL,
26  `category` int(11) DEFAULT NULL,
27  `item_proto_id` int(11) DEFAULT NULL,
28  PRIMARY KEY (`id`)
29) ENGINE=InnoDB AUTO_INCREMENT=73 DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci;
30
31-- ----------------------------
32-- Table structure for itemshop_package
33-- ----------------------------
34DROP TABLE IF EXISTS `itemshop_package`;
35CREATE TABLE `itemshop_package` (
36  `id` int(11) NOT NULL AUTO_INCREMENT,
37  `name` varchar(255) COLLATE utf8_polish_ci DEFAULT NULL,
38  `image` varchar(255) COLLATE utf8_polish_ci DEFAULT NULL,
39  `description` varchar(255) COLLATE utf8_polish_ci DEFAULT NULL,
40  `bonus` varchar(255) COLLATE utf8_polish_ci DEFAULT NULL,
41  `day` int(11) DEFAULT NULL,
42  `price` int(11) DEFAULT NULL,
43  `type` int(11) DEFAULT '0',
44  PRIMARY KEY (`id`)
45) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci;
46
47
48-- ----------------------------
49-- Table structure for site_code_psc
50-- ----------------------------
51DROP TABLE IF EXISTS `site_code_psc`;
52CREATE TABLE `site_code_psc` (
53  `id` int(11) NOT NULL AUTO_INCREMENT,
54  `account_id` int(11) NOT NULL,
55  `code` varchar(255) COLLATE utf8_polish_ci DEFAULT NULL,
56  `date` datetime DEFAULT NULL,
57  `add` int(11) NOT NULL DEFAULT '0',
58  PRIMARY KEY (`id`)
59) ENGINE=InnoDB AUTO_INCREMENT=117 DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci;
60
61-- ----------------------------
62-- Table structure for site_log
63-- ----------------------------
64DROP TABLE IF EXISTS `site_log`;
65CREATE TABLE `site_log` (
66  `id` int(11) NOT NULL AUTO_INCREMENT,
67  `login` varchar(255) COLLATE utf8_polish_ci DEFAULT NULL,
68  `account_id` int(11) DEFAULT NULL,
69  `action` varchar(255) COLLATE utf8_polish_ci DEFAULT NULL,
70  `time` datetime DEFAULT NULL,
71  `ip` varchar(255) COLLATE utf8_polish_ci DEFAULT NULL,
72  PRIMARY KEY (`id`)
73) ENGINE=InnoDB AUTO_INCREMENT=28250 DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci;
74
75-- ----------------------------
76-- Table structure for site_news
77-- ----------------------------
78DROP TABLE IF EXISTS `site_news`;
79CREATE TABLE `site_news` (
80  `id` int(11) NOT NULL AUTO_INCREMENT,
81  `title` varchar(255) COLLATE utf8_polish_ci DEFAULT NULL,
82  `content` text COLLATE utf8_polish_ci,
83  `author` varchar(255) COLLATE utf8_polish_ci DEFAULT NULL,
84  `data` datetime DEFAULT NULL,
85  PRIMARY KEY (`id`)
86) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci ROW_FORMAT=COMPACT;