-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathccdb.sql
More file actions
157 lines (139 loc) · 19.9 KB
/
ccdb.sql
File metadata and controls
157 lines (139 loc) · 19.9 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
/*
Navicat Premium Data Transfer
Source Server : localhost
Source Server Type : MySQL
Source Server Version : 50715
Source Host : localhost
Source Database : ccdb
Target Server Type : MySQL
Target Server Version : 50715
File Encoding : utf-8
Date: 09/23/2017 12:38:51 PM
*/
SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for `cc_desk`
-- ----------------------------
DROP TABLE IF EXISTS `cc_desk`;
CREATE TABLE `cc_desk` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增ID',
`name` varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '桌面名字',
`status` int(11) DEFAULT NULL COMMENT '状态码，1正常，0作废，2使用中',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='饭店桌子';
-- ----------------------------
-- Records of `cc_desk`
-- ----------------------------
BEGIN;
INSERT INTO `cc_desk` VALUES ('2', '加快速度金坷垃', '1'), ('3', 'Java教程', '1'), ('4', 'asdasd', '0'), ('5', 'asda5489498', '1'), ('6', '绝对牛逼的餐桌001', '1');
COMMIT;
-- ----------------------------
-- Table structure for `cc_food`
-- ----------------------------
DROP TABLE IF EXISTS `cc_food`;
CREATE TABLE `cc_food` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '菜品自增主键',
`name` text COLLATE utf8_bin NOT NULL COMMENT '菜品名字',
`avatar` text COLLATE utf8_bin COMMENT '封面图片',
`content` text COLLATE utf8_bin COMMENT '菜品详细介绍',
`type` text COLLATE utf8_bin COMMENT '所属菜系',
`style` text COLLATE utf8_bin COMMENT '菜品特色',
`status` int(11) DEFAULT '1' COMMENT '0弃用，1可用',
`cost` float DEFAULT '0' COMMENT '单价',
`cost_vip` float DEFAULT '0' COMMENT '会员价',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='菜品表';
-- ----------------------------
-- Records of `cc_food`
-- ----------------------------
BEGIN;
INSERT INTO `cc_food` VALUES ('1', 0xe99d92e6a492e88289e4b89d, null, 0xe99d92e6a492e88289e4b89defbc8ce5bd93e784b6e698afe5b79de88f9ce595a6e38082e6af8be5bab8e7bdaee79691, 0xe5b79de88f9c, 0xe5beaee8bea3, '1', '0', '0'), ('2', 0xe8a5bfe7baa2e69fbfe78292e89b8b, '', 0x3c703ee5b79de88f9ce4b8ade79a84e69e81e59381e7be8ee9a39f3c2f703e, 0xe5b79de88f9c, 0xe5be88e5a5bde59083e5958a, '1', '12', '12'), ('3', 0xe985b8e8bea3e59c9fe8b186e4b89d, 0xe69a82e697a0, 0xe985b8e8bea3e59c9fe8b186e4b89defbc8ce5b0b1e698afe98097e4bda0e78ea9, 0xe7ae97e595a6, 0xe5b79de88f9c, '1', '0', '0'), ('4', 0xe59c9fe8b186e783a7e9b8a1, 0xe783a7e9b8a1e4b99fe4b88de5a5bd, 0xe6b2a1e79a84e8afb4e4ba86efbc8ce4b88de5a5bde59083, 0xe982a3e5b0b1e698afe9aa9ae9b8a1, 0xe7b2a4e88f9c, '1', '0', '0'), ('5', 0xe59c9fe8b186e783a7e9b8a1, 0xe783a7e9b8a1e4b99fe4b88de5a5bd, 0xe6b2a1e79a84e8afb4e4ba86efbc8ce4b88de5a5bde59083, 0xe982a3e5b0b1e698afe9aa9ae9b8a1, 0xe7b2a4e88f9c, '1', '0', '0'), ('6', 0xe59c9fe8b186e783a7e9b8a1313131, 0xe783a7e9b8a1e4b99fe4b88de5a5bd313131, 0xe6b2a1e79a84e8afb4e4ba86efbc8ce4b88de5a5bde59083313131, 0xe982a3e5b0b1e698afe9aa9ae9b8a1313131, 0xe7b2a4e88f9c, '0', '0', '0'), ('7', 0xe59c9fe8b186e783a7e9b8a1313131323232, 0xe783a7e9b8a1e4b99fe4b88de5a5bd313131, 0xe6b2a1e79a84e8afb4e4ba86efbc8ce4b88de5a5bde59083313131, 0xe982a3e5b0b1e698afe9aa9ae9b8a1313131, 0xe7b2a4e88f9c, '1', '0', '0'), ('8', 0xe59c9fe8b186e783a7e9b8a1313131323232, 0xe783a7e9b8a1e4b99fe4b88de5a5bd313131, 0xe6b2a1e79a84e8afb4e4ba86efbc8ce4b88de5a5bde59083313131, 0xe7b2a4e88f9c, 0xe982a3e5b0b1e698afe9aa9ae9b8a1313131, '0', '0', '0'), ('9', 0xe59c9fe8b186e783a7e9b8a1313131323232e5939fe5939fe5939f, 0xe783a7e9b8a1e4b99fe4b88de5a5bd313131, 0xe6b2a1e79a84e8afb4e4ba86efbc8ce4b88de5a5bde59083313131, 0xe58c97e696b9e88f9c, 0xe982a3e5b0b1e698afe9aa9ae9b8a1313131, '0', '0', '0'), ('10', 0xe4bd9be8b7b3e5a299, '', 0xe5b0b1e982a3e6a0b7, 0xe5b79de88f9c, 0xe58f98e68081e8bea3, '1', '0', '0'), ('11', 0xe6adaae69e9ce4bb81e58f91e6988ee79a84e4babae88f9c, 0xe69a82e697a0, 0xe6adaae69e9ce4bb81e88f9ce7b3bbe79a84e88f9cefbc8ce4bda0e79c8be79c8be5b0b1e5a5bde4ba86, 0xe6adaae69e9ce4bb81e88f9ce7b3bb, 0xe6adaae69e9ce4bb81e58fa3e591b3, '1', '0', '0'), ('12', 0xe68891e79a84e88f9ce59381e6b58be8af95, null, null, 0xe5b79de88f9c, 0xe6b58be8af95, '1', '0', '0'), ('13', 0xe6b58be8af95e88f9ce59381e59bbee78987303031, 0xe4bd9ce4b89a312e6a7067, null, 0xe5b79de88f9c, 0xe6b58be8af95303031, '1', '0', '0'), ('14', 0xe6b58be8af95e88f9ce593812de59bbee78987303032, 0xe4bd9ce4b89a312e6a7067, null, 0xe5b79de88f9c, 0xe783a4e591b3e78e8b, '1', '0', '0'), ('15', 0xe6b58be8af95e88f9ce593812de59bbee78987303032, '', null, 0xe5b79de88f9c, '', '0', '0', '0'), ('16', 0xe68891e883bde8afb4e4bb80e4b988efbc9fe7bba7e7bbade6b58be8af95, '', 0x3c646976207374796c653d226261636b67726f756e642d636f6c6f723a236631663166313b20626f726465723a31707820736f6c696420236363633b2220636c6173733d22772d652d746f6f6c626172223e3c64697620636c6173733d22772d652d6d656e7522207374796c653d227a2d696e6465783a31303030313b223e3c6920636c6173733d22772d652d69636f6e2d686561646572223e3c693e3c2f693e3c2f693e3c2f6469763e3c64697620636c6173733d22772d652d6d656e7522207374796c653d227a2d696e6465783a31303030313b223e0a2020202020202020202020203c6920636c6173733d22772d652d69636f6e2d626f6c64223e3c693e0a20202020202020203c2f693e3c2f693e3c2f6469763e3c64697620636c6173733d22772d652d6d656e7522207374796c653d227a2d696e6465783a31303030313b223e0a2020202020202020202020203c6920636c6173733d22772d652d69636f6e2d6974616c6963223e3c693e0a20202020202020203c2f693e3c2f693e3c2f6469763e3c64697620636c6173733d22772d652d6d656e7522207374796c653d227a2d696e6465783a31303030313b223e0a2020202020202020202020203c6920636c6173733d22772d652d69636f6e2d756e6465726c696e65223e3c693e0a20202020202020203c2f693e3c2f693e3c2f6469763e3c64697620636c6173733d22772d652d6d656e7522207374796c653d227a2d696e6465783a31303030313b223e0a2020202020202020202020203c6920636c6173733d22772d652d69636f6e2d737472696b657468726f756768223e3c693e0a20202020202020203c2f693e3c2f693e3c2f6469763e3c64697620636c6173733d22772d652d6d656e7522207374796c653d227a2d696e6465783a31303030313b223e3c6920636c6173733d22772d652d69636f6e2d70656e63696c32223e3c693e3c2f693e3c2f693e3c2f6469763e3c64697620636c6173733d22772d652d6d656e7522207374796c653d227a2d696e6465783a31303030313b223e3c6920636c6173733d22772d652d69636f6e2d7061696e742d6272757368223e3c693e3c2f693e3c2f693e3c64697620636c6173733d22772d652d64726f706c69737422207374796c653d226d617267696e2d746f703a323970783b2077696474683a31323070783b20646973706c61793a6e6f6e653b223e3c7020636c6173733d22772d652d64702d7469746c65223ee8838ce699afe889b23c2f703e3c756c20636c6173733d22772d652d626c6f636b223e3c6c6920636c6173733d22772d652d6974656d223e3c69207374796c653d22636f6c6f723a233030303030303b2220636c6173733d22772d652d69636f6e2d7061696e742d6272757368223e3c2f693e3c2f6c693e3c6c6920636c6173733d22772d652d6974656d223e3c69207374796c653d22636f6c6f723a236565656365303b2220636c6173733d22772d652d69636f6e2d7061696e742d6272757368223e3c2f693e3c2f6c693e3c6c6920636c6173733d22772d652d6974656d223e3c69207374796c653d22636f6c6f723a233163343837663b2220636c6173733d22772d652d69636f6e2d7061696e742d6272757368223e3c2f693e3c2f6c693e3c6c6920636c6173733d22772d652d6974656d223e3c69207374796c653d22636f6c6f723a233464383062663b2220636c6173733d22772d652d69636f6e2d7061696e742d6272757368223e3c2f693e3c2f6c693e3c6c6920636c6173733d22772d652d6974656d223e3c69207374796c653d22636f6c6f723a236332346634613b2220636c6173733d22772d652d69636f6e2d7061696e742d6272757368223e3c2f693e3c2f6c693e3c6c6920636c6173733d22772d652d6974656d223e3c69207374796c653d22636f6c6f723a233862616134613b2220636c6173733d22772d652d69636f6e2d7061696e742d6272757368223e3c2f693e3c2f6c693e3c6c6920636c6173733d22772d652d6974656d223e3c69207374796c653d22636f6c6f723a233762356261313b2220636c6173733d22772d652d69636f6e2d7061696e742d6272757368223e3c2f693e3c2f6c693e3c6c6920636c6173733d22772d652d6974656d223e3c69207374796c653d22636f6c6f723a233436616363383b2220636c6173733d22772d652d69636f6e2d7061696e742d6272757368223e3c2f693e3c2f6c693e3c6c6920636c6173733d22772d652d6974656d223e3c69207374796c653d22636f6c6f723a236639393633623b2220636c6173733d22772d652d69636f6e2d7061696e742d6272757368223e3c2f693e3c2f6c693e3c6c6920636c6173733d22772d652d6974656d223e3c69207374796c653d22636f6c6f723a236666666666663b2220636c6173733d22772d652d69636f6e2d7061696e742d6272757368223e3c2f693e3c2f6c693e3c2f756c3e3c2f6469763e3c2f6469763e3c64697620636c6173733d22772d652d6d656e7522207374796c653d227a2d696e6465783a31303030313b223e3c6920636c6173733d22772d652d69636f6e2d6c696e6b223e3c693e3c2f693e3c2f693e3c2f6469763e3c64697620636c6173733d22772d652d6d656e7522207374796c653d227a2d696e6465783a31303030313b223e3c6920636c6173733d22772d652d69636f6e2d6c69737432223e3c693e3c2f693e3c2f693e3c2f6469763e3c64697620636c6173733d22772d652d6d656e7522207374796c653d227a2d696e6465783a31303030313b223e3c6920636c6173733d22772d652d69636f6e2d7061726167726170682d6c656674223e3c693e3c2f693e3c2f693e3c2f6469763e3c64697620636c6173733d22772d652d6d656e7522207374796c653d227a2d696e6465783a31303030313b223e0a2020202020202020202020203c6920636c6173733d22772d652d69636f6e2d71756f7465732d6c656674223e3c693e0a20202020202020203c2f693e3c2f693e3c2f6469763e3c64697620636c6173733d22772d652d6d656e7522207374796c653d227a2d696e6465783a31303030313b223e0a2020202020202020202020203c6920636c6173733d22772d652d69636f6e2d6861707079223e3c693e0a20202020202020203c2f693e3c2f693e3c2f6469763e3c64697620636c6173733d22772d652d6d656e7522207374796c653d227a2d696e6465783a31303030313b223e3c6920636c6173733d22772d652d69636f6e2d696d616765223e3c693e3c2f693e3c2f693e3c2f6469763e3c64697620636c6173733d22772d652d6d656e7522207374796c653d227a2d696e6465783a31303030313b223e3c6920636c6173733d22772d652d69636f6e2d7461626c6532223e3c693e3c2f693e3c2f693e3c2f6469763e3c64697620636c6173733d22772d652d6d656e7522207374796c653d227a2d696e6465783a31303030313b223e3c6920636c6173733d22772d652d69636f6e2d706c6179223e3c693e3c2f693e3c2f693e3c2f6469763e3c64697620636c6173733d22772d652d6d656e7522207374796c653d227a2d696e6465783a31303030313b223e0a2020202020202020202020203c6920636c6173733d22772d652d69636f6e2d7465726d696e616c223e3c693e0a20202020202020203c2f693e3c2f693e3c2f6469763e3c64697620636c6173733d22772d652d6d656e7522207374796c653d227a2d696e6465783a31303030313b223e0a2020202020202020202020203c6920636c6173733d22772d652d69636f6e2d756e646f223e3c693e0a20202020202020203c2f693e3c2f693e3c2f6469763e3c64697620636c6173733d22772d652d6d656e7522207374796c653d227a2d696e6465783a31303030313b223e0a2020202020202020202020203c6920636c6173733d22772d652d69636f6e2d7265646f223e3c693e0a20202020202020203c2f693e3c2f693e3c2f6469763e3c2f6469763e3c646976207374796c653d22626f726465723a31707820736f6c696420236363633b20626f726465722d746f703a6e6f6e653b206865696768743a33303070783b207a2d696e6465783a31303030303b2220636c6173733d22772d652d746578742d636f6e7461696e6572223e3c64697620636f6e74656e746564697461626c653d227472756522207374796c653d2277696474683a313030253b206865696768743a313030253b2220636c6173733d22772d652d74657874223e3c696d67207372633d22687474703a2f2f6c6f63616c686f73743a383138312f6363537072696e67426f6f742f75706c6f616446696c65732f32303137303931342f63323066623136323239626534333261393233376566376231353064343266392e706e6722207374796c653d226d61782d77696474683a313030253b223e3c2f6469763e3c64697620636f6e74656e746564697461626c653d227472756522207374796c653d2277696474683a313030253b206865696768743a313030253b2220636c6173733d22772d652d74657874223e6173646173646173646173646173646173643c2f6469763e3c64697620636f6e74656e746564697461626c653d227472756522207374796c653d2277696474683a313030253b206865696768743a313030253b2220636c6173733d22772d652d74657874223e6173646164733c2f6469763e3c64697620636f6e74656e746564697461626c653d227472756522207374796c653d2277696474683a313030253b206865696768743a313030253b2220636c6173733d22772d652d74657874223e6173646164733c2f6469763e3c64697620636f6e74656e746564697461626c653d227472756522207374796c653d2277696474683a313030253b206865696768743a313030253b2220636c6173733d22772d652d74657874223e3c62723e3c7461626c6520626f726465723d2230222077696474683d2231303025222063656c6c70616464696e673d2230222063656c6c73706163696e673d2230223e3c74626f64793e3c74723e3c74683e266e6273703b3c2f74683e3c74683e266e6273703b3c2f74683e3c74683e266e6273703b3c2f74683e3c74683e266e6273703b3c2f74683e3c74683e266e6273703b3c2f74683e3c2f74723e3c74723e3c74643e266e6273703b3c2f74643e3c74643e266e6273703b3c2f74643e3c74643e266e6273703b3c2f74643e3c74643e266e6273703b3c2f74643e3c74643e266e6273703b3c2f74643e3c2f74723e3c74723e3c74643e266e6273703b3c2f74643e3c74643e266e6273703b3c2f74643e3c74643e266e6273703b3c2f74643e3c74643e266e6273703b3c2f74643e3c74643e266e6273703b3c2f74643e3c2f74723e3c74723e3c74643e266e6273703b3c2f74643e3c74643e266e6273703b3c2f74643e3c74643e266e6273703b3c2f74643e3c74643e266e6273703b3c2f74643e3c74643e266e6273703b3c2f74643e3c2f74723e3c74723e3c74643e266e6273703b3c2f74643e3c74643e266e6273703b3c2f74643e3c74643e266e6273703b3c2f74643e3c74643e266e6273703b3c2f74643e3c74643e3c62723e3c2f74643e3c2f74723e3c2f74626f64793e3c2f7461626c653e3c2f6469763e3c2f6469763e3c703e3c62723e3c2f703e, 0xe5b79de88f9c, 0x313131, '1', '0', '0'), ('17', 0xe6b58be8af95e6b7bbe58aa0e88f9ce59381, null, 0x3c703ee68891e8a789e5be97e58fafe4bba5e6ba9ce4b880e59c883c2f703e, 0xe5b79de88f9c, 0xe5889ae8b5b7e69da5, '0', '0', '0'), ('18', 0xe59b9be5b79de58880e5898ae99da2, null, 0x3c703ee6b885e9a699e38081e88081e5aeb6e79a84e591b3e98193e38081e8888ce5b096e4b88ae79a84e58880e5898ae99da23c2f703e, 0xe5b79de88f9c, 0xe6b885e9a699e38081e88081e5aeb6e79a84e591b3e98193e38081e8888ce5b096e4b88ae79a84e58880e5898ae99da2, '1', '0', '0'), ('19', 0xe68b85e68b85e99da2414141, null, 0xe8bf99e698afe68b85e68b85e99da2, 0xe5b79de88f9c, 0xe5beaee8bea3, '1', '15.5', '15.5');
COMMIT;
-- ----------------------------
-- Table structure for `cc_food_type`
-- ----------------------------
DROP TABLE IF EXISTS `cc_food_type`;
CREATE TABLE `cc_food_type` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '菜系id',
`name` text COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '菜系名称',
`description` text COLLATE utf8mb4_unicode_ci COMMENT '菜系描述',
`other` text COLLATE utf8mb4_unicode_ci COMMENT '备注',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- ----------------------------
-- Records of `cc_food_type`
-- ----------------------------
BEGIN;
INSERT INTO `cc_food_type` VALUES ('1', '川菜', '川菜', '川菜'), ('2', '湘菜', '湘菜', '湘菜'), ('3', '粤菜', '粤菜', '据说广东人喜欢吃胡建人'), ('5', '海南菜', '海南人吃的菜', '我这个四川人不喜欢吃海南菜'), ('6', '北方菜', '北方菜味道还是不错的！', '北方菜，你爱吃吗？'), ('9', '歪果仁菜系', '歪果仁吃的菜', '反正不怎么好吃');
COMMIT;
-- ----------------------------
-- Table structure for `cc_res`
-- ----------------------------
DROP TABLE IF EXISTS `cc_res`;
CREATE TABLE `cc_res` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '物品ID',
`name` text COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '物品名称',
`code` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '物品编码，唯一编码',
`position` text COLLATE utf8mb4_unicode_ci COMMENT '物品位置，可为空',
`cost` float DEFAULT '0' COMMENT '物品单价',
`sum` int(11) DEFAULT NULL COMMENT '总数',
`type` text COLLATE utf8mb4_unicode_ci COMMENT '物品类型',
PRIMARY KEY (`id`),
UNIQUE KEY `cc_res_code_uindex` (`code`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='物品记录表';
-- ----------------------------
-- Records of `cc_res`
-- ----------------------------
BEGIN;
INSERT INTO `cc_res` VALUES ('1', '2018年计算机组成原理考研复习指导', 'B区13库房131货架A11', '489498', '48', '50000', '书籍-考研-计算机-王道论坛'), ('3', '2018年计算机组成原理考研复习指导', '9787121309762', 'B区13库房131货架A11', '48', '50000', '书籍-考研-计算机-王道论坛'), ('4', '考研政治马原专项突破', '9787121309789', null, null, null, null), ('5', '考研政治早知道——马原专项突破', '9787502278595', null, null, null, null), ('6', '考研政治早知道——西瓜皮', '9787502278595999', '', null, null, ''), ('7', '考研政治早知道——茄子', '9787502299999999', '', null, null, ''), ('8', '考研政治早知道——西瓜皮999', '9787502299999999999', '', null, null, ''), ('9', '考研政治早知道——西瓜皮888', '9787502299999999888', '没有位置不给吗？', null, null, ''), ('10', '就是要发发发', '888888', '', null, null, ''), ('11', '1111222', '9787502278595111', '男生宿舍1A216', '999', null, 'AAA');
COMMIT;
-- ----------------------------
-- Table structure for `cc_res_in`
-- ----------------------------
DROP TABLE IF EXISTS `cc_res_in`;
CREATE TABLE `cc_res_in` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '入库表自增主键',
`code` text COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '入库表单编号',
`content` text COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '入库表单内容',
`date` int(11) NOT NULL COMMENT '入库时间',
`total_cost` decimal(10,0) NOT NULL COMMENT '入库总价',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- ----------------------------
-- Table structure for `cc_site`
-- ----------------------------
DROP TABLE IF EXISTS `cc_site`;
CREATE TABLE `cc_site` (
`value` text COLLATE utf8_bin COMMENT 'value',
`key` varchar(256) COLLATE utf8_bin NOT NULL COMMENT 'key',
UNIQUE KEY `cc_site_key_uindex` (`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='站点信息存储';
-- ----------------------------
-- Records of `cc_site`
-- ----------------------------
BEGIN;
INSERT INTO `cc_site` VALUES (0x736974655f6e616d65, '智能无线点餐系统'), (0x736974655f636f6465, '琼ICP备15002637号-1');
COMMIT;
-- ----------------------------
-- Table structure for `cc_user`
-- ----------------------------
DROP TABLE IF EXISTS `cc_user`;
CREATE TABLE `cc_user` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '用户昵称',
`login_name` varchar(25) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '-1' COMMENT '用户登录名称',
`password` varchar(256) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '-1' COMMENT '用户密码，建议算法：sha256(MD5(明文)+salt)',
`duty` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '用户职位',
`create_date` int(11) NOT NULL COMMENT '创建时间',
`used` tinyint(1) NOT NULL DEFAULT '1' COMMENT '账户是否可用',
PRIMARY KEY (`id`),
UNIQUE KEY `login_name` (`login_name`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='用户表';
-- ----------------------------
-- Records of `cc_user`
-- ----------------------------
BEGIN;
INSERT INTO `cc_user` VALUES ('2', '糍粑', '228568859', 'aasdasdzxkclzklxckl', 'c测试张哈', '1703864036', '0'), ('3', '程', 'pc85', '623c3218d81612bc5b327339e25eeed21347f9e96c588babf352c27e3161515b', '炒鸡admin', '1502870091', '0'), ('4', '程', 'pc8599', 'ec3434245bad39ccb5d1bbc313a68e6cca26bd3fcbffd5ff160ef33422d099db', '炒鸡admin', '1502871057', '0'), ('5', '程', 'pc8599110', 'a70d700f0430bde923a25c0d6a1d09dde271345b23c07e239b94f204ac28d795', '炒鸡admin', '1502871222', '0'), ('6', '程', 'pc859922', '4eefba35cdfbc69a6d073d865ddbf33c40711da4bd1bc05b1489bc5a4867329c', '炒鸡admin', '1502871269', '0'), ('8', 'qqq', '228596321', '725a289793d69321bd786166ad7a8bc4fa0660573460d34b2f5e87e111d947e7', 'zxczxcz', '1502871659', '0'), ('9', 'qqq', '9564564', 'a2225de081c1da76160dd04d99de4a9439c9e1f31843ffd2f0bfbceda714b712', 'zxczxcz', '1502871724', '1'), ('10', 'qqq', '9564564120', 'c30d43afeba75f98af26cae7bfb628ca4e9dcc34a385127019dda28a352d885e', 'zxczxcz', '1502871826', '1'), ('11', 'qqq', '9564564110', '5c06478ca9ae9a61ead0bf921e3406bd4d2ce6fe7a8953cda58b6a131265c004', 'zxczxcz', '1502872562', '0'), ('14', '程打野', 'pc859107393', '1b4d2f7c7438009f6bb8154b96e3c75f6a161912fc7ca8b6eb095776499363f7', 'admin', '1503347744', '1'), ('15', '加快速度金坷垃', '123456789', '500f48637f4f3e081bd6a107eb8793dc9a556faeb60ce66a5c82a93321f68884', null, '1505153276', '0');
COMMIT;
SET FOREIGN_KEY_CHECKS = 1;