bjTjwMn4

1DROP TABLE IF EXISTS `cms_badges`;
2CREATE TABLE `cms_badges`  (
3  `id` int(7) NOT NULL AUTO_INCREMENT,
4  `code` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
5  `title` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
6  `desc` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
7  `news_id` int(77) NOT NULL DEFAULT 0,
8  PRIMARY KEY (`id`) USING BTREE
9) ENGINE = MyISAM AUTO_INCREMENT = 6 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
10
11-- ----------------------------
12-- Table structure for cms_clothing
13-- ----------------------------
14DROP TABLE IF EXISTS `cms_clothing`;
15CREATE TABLE `cms_clothing`  (
16  `id` int(7) NOT NULL AUTO_INCREMENT,
17  `title` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
18  `name` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
19  PRIMARY KEY (`id`) USING BTREE
20) ENGINE = MyISAM AUTO_INCREMENT = 2 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
21
22-- ----------------------------
23-- Table structure for cms_furniture
24-- ----------------------------
25DROP TABLE IF EXISTS `cms_furniture`;
26CREATE TABLE `cms_furniture`  (
27  `id` int(7) NOT NULL AUTO_INCREMENT,
28  `title` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
29  `name` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
30  PRIMARY KEY (`id`) USING BTREE
31) ENGINE = MyISAM AUTO_INCREMENT = 2 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
32
33-- ----------------------------
34-- Table structure for cms_news
35-- ----------------------------
36DROP TABLE IF EXISTS `cms_news`;
37CREATE TABLE `cms_news`  (
38  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
39  `caption` varchar(250) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
40  `desc` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
41  `body` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
42  `image` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
43  `author` int(11) NOT NULL,
44  `date` varchar(30) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
45  `category` int(7) NOT NULL DEFAULT 1,
46  `main` int(11) NOT NULL DEFAULT 0,
47  PRIMARY KEY (`id`) USING BTREE
48) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
49
50