sibu_integralmall_base.sql
24.3 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
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
/*
Navicat MySQL Data Transfer
Source Server : 思埠新微商1（主）-测试
Source Server Version : 50630
Source Host : 120.76.137.184:3306
Source Database : sibu_integralmall_base
Target Server Type : MYSQL
Target Server Version : 50630
File Encoding : 65001
Date: 2016-06-16 13:41:21
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for im_advert
-- ----------------------------
DROP TABLE IF EXISTS `im_advert`;
CREATE TABLE `im_advert` (
`im_advert_id` varchar(36) NOT NULL COMMENT '积分商城广告ID',
`type_id` tinyint(4) NOT NULL COMMENT '类型ID',
`im_product_id` varchar(36) DEFAULT NULL COMMENT '关联的产品ID',
`name` varchar(254) NOT NULL COMMENT '广告名称',
`image_url` varchar(254) NOT NULL COMMENT '广告图片',
`is_show` tinyint(4) NOT NULL DEFAULT '1' COMMENT '是否显示在首页',
`sort_index` int(11) NOT NULL COMMENT '排序号',
`create_member_id` varchar(36) NOT NULL COMMENT '创建人',
`create_dt` datetime NOT NULL COMMENT '创建时间',
`update_dt` datetime DEFAULT NULL COMMENT '结束时间',
`delete_flag` tinyint(4) NOT NULL DEFAULT '1' COMMENT '删除标识',
`link_url` varchar(255) DEFAULT NULL,
PRIMARY KEY (`im_advert_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of im_advert
-- ----------------------------
-- ----------------------------
-- Table structure for im_category
-- ----------------------------
DROP TABLE IF EXISTS `im_category`;
CREATE TABLE `im_category` (
`im_category_id` varchar(36) NOT NULL COMMENT '积分商城分类ID',
`type_id` tinyint(4) NOT NULL DEFAULT '0' COMMENT '类型ID',
`name` varchar(254) NOT NULL COMMENT '分类名称',
`image_url` varchar(254) NOT NULL COMMENT '分类图片',
`sort_index` int(11) NOT NULL COMMENT '排序号',
`remark` text COMMENT '备注',
`create_member_id` varchar(36) NOT NULL COMMENT '创建人',
`create_dt` datetime NOT NULL COMMENT '创建时间',
`update_dt` datetime DEFAULT NULL COMMENT '结束时间',
`delete_flag` tinyint(4) NOT NULL DEFAULT '1' COMMENT '删除标识',
`child_category_id` varchar(36) DEFAULT NULL,
`category_type` tinyint(4) unsigned zerofill DEFAULT '0000' COMMENT '0为积分商品分类，1为现金商品分类',
PRIMARY KEY (`im_category_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of im_category
-- ----------------------------
-- ----------------------------
-- Table structure for im_product
-- ----------------------------
DROP TABLE IF EXISTS `im_product`;
CREATE TABLE `im_product` (
`im_product_id` varchar(36) NOT NULL COMMENT '产品ID',
`im_category_id` varchar(36) NOT NULL COMMENT '分类ID',
`name` varchar(255) NOT NULL COMMENT '产品名称',
`short_name` varchar(255) DEFAULT NULL COMMENT '产品简称',
`details` text COMMENT '详细信息',
`stock_num` int(11) NOT NULL COMMENT '库存',
`exchange_integral` int(11) DEFAULT NULL COMMENT '兑换积分数',
`xws_exchange_integral` int(11) DEFAULT NULL COMMENT '新微商系统兑换积分数',
`sibukg_exchange_integral` int(11) DEFAULT NULL COMMENT '思埠快购系统兑换积分数',
`onther1_exchange_integral` int(11) DEFAULT NULL COMMENT '其他1兑换积分数',
`onther2_exchange_integral` int(11) DEFAULT NULL COMMENT '其他2兑换积分数',
`onther3_exchange_integral` int(11) DEFAULT NULL COMMENT '其他3兑换积分数',
`freight` decimal(19,6) DEFAULT NULL COMMENT '运费',
`sort_index` int(11) NOT NULL COMMENT '排序号',
`thumb_img` varchar(255) DEFAULT NULL COMMENT '产品缩略图',
`bannel_img1` varchar(255) DEFAULT NULL COMMENT '产品详情banner图',
`bannel_img2` varchar(255) DEFAULT NULL COMMENT '产品详情banner图',
`bannel_img3` varchar(255) DEFAULT NULL COMMENT '产品详情banner图',
`bannel_img4` varchar(255) DEFAULT NULL COMMENT '产品详情banner图',
`bannel_img5` varchar(255) DEFAULT NULL COMMENT '产品详情banner图',
`is_new` int(11) NOT NULL DEFAULT '0' COMMENT '是否新品',
`is_hot` int(11) NOT NULL DEFAULT '0' COMMENT '是否热销',
`is_reco` int(11) NOT NULL DEFAULT '0' COMMENT '是否推荐',
`limit_exchange_number` int(11) NOT NULL DEFAULT '0' COMMENT '每人限购次数',
`is_prom` tinyint(1) DEFAULT '0' COMMENT '是否促销',
`prom_exchange_integral` int(11) DEFAULT NULL COMMENT '促销兑换积分数',
`cost` int(11) DEFAULT '0' COMMENT '总销量',
`attention` int(11) DEFAULT '100' COMMENT '关注度',
`total_comment_score` int(11) DEFAULT '0' COMMENT '总评论分数',
`total_comment_number` int(11) DEFAULT '0' COMMENT '总评论人数',
`create_date` datetime NOT NULL COMMENT '创建时间',
`update_date` datetime DEFAULT NULL COMMENT '结束时间',
`delete_flag` tinyint(4) DEFAULT '1' COMMENT '删除标识',
`retail_price` decimal(18,2) DEFAULT NULL,
`market_price` decimal(18,2) DEFAULT NULL,
`product_type` tinyint(4) NOT NULL DEFAULT '0',
`is_show` tinyint(4) NOT NULL DEFAULT '1',
`erp_code` varchar(32) DEFAULT NULL,
`is_open_spec` tinyint(4) DEFAULT '0' COMMENT '默认为1，打开规格购买',
`spec` int(11) DEFAULT '0' COMMENT '规格',
`mini_purchase_number` int(11) DEFAULT '1' COMMENT '最小起订数量',
PRIMARY KEY (`im_product_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='产品表';
-- ----------------------------
-- Records of im_product
-- ----------------------------
-- ----------------------------
-- Table structure for im_product_entry
-- ----------------------------
DROP TABLE IF EXISTS `im_product_entry`;
CREATE TABLE `im_product_entry` (
`entry_id` varchar(36) NOT NULL COMMENT '产品入库单ID',
`entry_username` varchar(32) NOT NULL COMMENT '产品入库人用户名',
`entry_phone` varchar(18) NOT NULL COMMENT '产品入库人联系电话',
`entry_wechat` varchar(32) DEFAULT NULL COMMENT '产品入库人微信号',
`entry_product_id` varchar(36) NOT NULL COMMENT '入库产品ID',
`entry_product_stock` int(11) NOT NULL COMMENT '入库产品库存',
`create_dt` datetime NOT NULL COMMENT '创建时间',
PRIMARY KEY (`entry_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of im_product_entry
-- ----------------------------
-- ----------------------------
-- Table structure for im_product_prop
-- ----------------------------
DROP TABLE IF EXISTS `im_product_prop`;
CREATE TABLE `im_product_prop` (
`im_prop_id` varchar(32) NOT NULL COMMENT '属性ID',
`im_product_id` varchar(32) NOT NULL COMMENT '产品ID',
`prop_name` varchar(100) DEFAULT NULL COMMENT '属性标题',
`prop_value_name` varchar(100) DEFAULT NULL COMMENT '属性说明',
`create_date` datetime NOT NULL COMMENT '创建时间',
`update_date` datetime DEFAULT NULL COMMENT '结束时间',
`delete_flag` tinyint(4) DEFAULT '1' COMMENT '删除标识',
PRIMARY KEY (`im_prop_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='产品属性表';
-- ----------------------------
-- Records of im_product_prop
-- ----------------------------
-- ----------------------------
-- Table structure for server_config
-- ----------------------------
DROP TABLE IF EXISTS `server_config`;
CREATE TABLE `server_config` (
`database_id` varchar(36) NOT NULL,
`database_type` int(4) NOT NULL DEFAULT '0',
`modules` int(4) NOT NULL,
`database_driver` varchar(255) NOT NULL,
`database_url` varchar(255) NOT NULL,
`database_username` varchar(255) NOT NULL,
`database_password` varchar(255) NOT NULL,
PRIMARY KEY (`database_id`),
KEY `database_type_index` (`database_type`) USING BTREE,
KEY `modules_index` (`modules`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='系统连接字符串配置';
-- ----------------------------
-- Records of server_config
-- ----------------------------
INSERT INTO `server_config` VALUES ('0425775a19ae400492278e9dd08e1b2a', '6', '5', 'com.mysql.jdbc.Driver', 'jdbc:mysql://10.24.208.147/sibu_integralmall_comment_05?useUnicode=true&characterEncoding=utf8', 'sibu_integralmall', '09NWaUZUNjjr0IRCYzm3');
INSERT INTO `server_config` VALUES ('057686cf07674c2abb73d09788553b63', '0', '3', 'com.mysql.jdbc.Driver', 'jdbc:mysql://10.170.4.106/sibu_wesale_base?useUnicode=true&characterEncoding=utf8', 'sibu_integralmall', '09NWaUZUNjjr0IRCYzm3');
INSERT INTO `server_config` VALUES ('0a82ca30cca8472f9abff55d7214db76', '2', '1', 'com.mysql.jdbc.Driver', 'jdbc:mysql://10.170.4.106/sibu_wesale_buyer_order_01?useUnicode=true&characterEncoding=utf8', 'sibu_integralmall', '09NWaUZUNjjr0IRCYzm3');
INSERT INTO `server_config` VALUES ('110a0755635244df8b3ae10dd5aacb45', '5', '6', 'com.mysql.jdbc.Driver', 'jdbc:mysql://10.24.208.147/sibu_integralmall_order_06?useUnicode=true&characterEncoding=utf8', 'sibu_integralmall', '09NWaUZUNjjr0IRCYzm3');
INSERT INTO `server_config` VALUES ('1f18c70887644d5ba0a5372495e32a08', '6', '4', 'com.mysql.jdbc.Driver', 'jdbc:mysql://10.24.208.147/sibu_integralmall_comment_04?useUnicode=true&characterEncoding=utf8', 'sibu_integralmall', '09NWaUZUNjjr0IRCYzm3');
INSERT INTO `server_config` VALUES ('2169f5dd47e84fbbb3410d945423fffc', '0', '6', 'com.mysql.jdbc.Driver', 'jdbc:mysql://10.24.208.147/sibu_wesale_base?useUnicode=true&characterEncoding=utf8', 'sibu_integralmall', '09NWaUZUNjjr0IRCYzm3');
INSERT INTO `server_config` VALUES ('2531a2bac98b499d8e29cd090f305c7c', '0', '4', 'com.mysql.jdbc.Driver', 'jdbc:mysql://10.24.208.147/sibu_wesale_base?useUnicode=true&characterEncoding=utf8', 'sibu_integralmall', '09NWaUZUNjjr0IRCYzm3');
INSERT INTO `server_config` VALUES ('2f75bea584644858955549fd1f71d131', '6', '3', 'com.mysql.jdbc.Driver', 'jdbc:mysql://10.170.4.106/sibu_integralmall_comment_03?useUnicode=true&characterEncoding=utf8', 'sibu_integralmall', '09NWaUZUNjjr0IRCYzm3');
INSERT INTO `server_config` VALUES ('305bb8542510406dba7497d82f1d7417', '1', '4', 'com.mysql.jdbc.Driver', 'jdbc:mysql://10.24.208.147/sibu_wesale_member_04?useUnicode=true&characterEncoding=utf8', 'sibu_integralmall', '09NWaUZUNjjr0IRCYzm3');
INSERT INTO `server_config` VALUES ('31bb282d59f84ba38da1d06db1144401', '1', '0', 'com.mysql.jdbc.Driver', 'jdbc:mysql://10.170.4.106/sibu_wesale_member_00?useUnicode=true&characterEncoding=utf8', 'sibu_integralmall', '09NWaUZUNjjr0IRCYzm3');
INSERT INTO `server_config` VALUES ('35050b175cd544fabe3c5a01dccf95f7', '3', '6', 'com.mysql.jdbc.Driver', 'jdbc:mysql://10.24.208.147/sibu_wesale_seller_order_06?useUnicode=true&characterEncoding=utf8', 'sibu_integralmall', '09NWaUZUNjjr0IRCYzm3');
INSERT INTO `server_config` VALUES ('3536cd4124ae4594a6335ae277b04445', '0', '5', 'com.mysql.jdbc.Driver', 'jdbc:mysql://10.24.208.147/sibu_wesale_base?useUnicode=true&characterEncoding=utf8', 'sibu_integralmall', '09NWaUZUNjjr0IRCYzm3');
INSERT INTO `server_config` VALUES ('35d7adf9d899417aa51f19cca6544dc7', '3', '2', 'com.mysql.jdbc.Driver', 'jdbc:mysql://10.170.4.106/sibu_wesale_seller_order_02?useUnicode=true&characterEncoding=utf8', 'sibu_integralmall', '09NWaUZUNjjr0IRCYzm3');
INSERT INTO `server_config` VALUES ('3b2677046e434c848274c72070a11533', '4', '7', 'com.mysql.jdbc.Driver', 'jdbc:mysql://10.24.208.147/sibu_integralmall_base?useUnicode=true&characterEncoding=utf8', 'sibu_integralmall', '09NWaUZUNjjr0IRCYzm3');
INSERT INTO `server_config` VALUES ('53f71814acd24167b69c78151021e0d4', '6', '1', 'com.mysql.jdbc.Driver', 'jdbc:mysql://10.170.4.106/sibu_integralmall_comment_01?useUnicode=true&characterEncoding=utf8', 'sibu_integralmall', '09NWaUZUNjjr0IRCYzm3');
INSERT INTO `server_config` VALUES ('578159b921494216b3c8df93aa54becc', '6', '2', 'com.mysql.jdbc.Driver', 'jdbc:mysql://10.170.4.106/sibu_integralmall_comment_02?useUnicode=true&characterEncoding=utf8', 'sibu_integralmall', '09NWaUZUNjjr0IRCYzm3');
INSERT INTO `server_config` VALUES ('57a9c070bf644f8b943fa5b518512e99', '4', '0', 'com.mysql.jdbc.Driver', 'jdbc:mysql://10.170.4.106/sibu_integralmall_base?useUnicode=true&characterEncoding=utf8', 'sibu_integralmall', '09NWaUZUNjjr0IRCYzm3');
INSERT INTO `server_config` VALUES ('626f9973ecfa4798a79cb311a3ba0b9c', '1', '1', 'com.mysql.jdbc.Driver', 'jdbc:mysql://10.170.4.106/sibu_wesale_member_01?useUnicode=true&characterEncoding=utf8', 'sibu_integralmall', '09NWaUZUNjjr0IRCYzm3');
INSERT INTO `server_config` VALUES ('66bc67511e834474b2195cd13cda10a9', '0', '0', 'com.mysql.jdbc.Driver', 'jdbc:mysql://10.170.4.106/sibu_wesale_base?useUnicode=true&characterEncoding=utf8', 'sibu_integralmall', '09NWaUZUNjjr0IRCYzm3');
INSERT INTO `server_config` VALUES ('67cab075e3c4414cb88a07891760fd80', '6', '0', 'com.mysql.jdbc.Driver', 'jdbc:mysql://10.170.4.106/sibu_integralmall_comment_00?useUnicode=true&characterEncoding=utf8', 'sibu_integralmall', '09NWaUZUNjjr0IRCYzm3');
INSERT INTO `server_config` VALUES ('6d3dc02be1c145bfac5430000507dced', '0', '1', 'com.mysql.jdbc.Driver', 'jdbc:mysql://10.170.4.106/sibu_wesale_base?useUnicode=true&characterEncoding=utf8', 'sibu_integralmall', '09NWaUZUNjjr0IRCYzm3');
INSERT INTO `server_config` VALUES ('6e3fc5e85cdd49e6bbb3ec7510ea5bdc', '4', '6', 'com.mysql.jdbc.Driver', 'jdbc:mysql://10.24.208.147/sibu_integralmall_base?useUnicode=true&characterEncoding=utf8', 'sibu_integralmall', '09NWaUZUNjjr0IRCYzm3');
INSERT INTO `server_config` VALUES ('722e529b95a9466a85e5d7230b39f473', '0', '2', 'com.mysql.jdbc.Driver', 'jdbc:mysql://10.170.4.106/sibu_wesale_base?useUnicode=true&characterEncoding=utf8', 'sibu_integralmall', '09NWaUZUNjjr0IRCYzm3');
INSERT INTO `server_config` VALUES ('749b2afd991044268a07f9e181404d73', '3', '5', 'com.mysql.jdbc.Driver', 'jdbc:mysql://10.24.208.147/sibu_wesale_seller_order_05?useUnicode=true&characterEncoding=utf8', 'sibu_integralmall', '09NWaUZUNjjr0IRCYzm3');
INSERT INTO `server_config` VALUES ('7dd50a4345784dd29bfb08bd44b870d1', '2', '3', 'com.mysql.jdbc.Driver', 'jdbc:mysql://10.170.4.106/sibu_wesale_buyer_order_03?useUnicode=true&characterEncoding=utf8', 'sibu_integralmall', '09NWaUZUNjjr0IRCYzm3');
INSERT INTO `server_config` VALUES ('81721c3c252d411f90016c82654d5681', '3', '3', 'com.mysql.jdbc.Driver', 'jdbc:mysql://10.170.4.106/sibu_wesale_seller_order_03?useUnicode=true&characterEncoding=utf8', 'sibu_integralmall', '09NWaUZUNjjr0IRCYzm3');
INSERT INTO `server_config` VALUES ('819176c6c0654b1ebec0b6d926aa2e97', '3', '7', 'com.mysql.jdbc.Driver', 'jdbc:mysql://10.24.208.147/sibu_wesale_seller_order_07?useUnicode=true&characterEncoding=utf8', 'sibu_integralmall', '09NWaUZUNjjr0IRCYzm3');
INSERT INTO `server_config` VALUES ('8fc93a9fc9aa48f29e63a0b0fa202866', '3', '0', 'com.mysql.jdbc.Driver', 'jdbc:mysql://10.170.4.106/sibu_wesale_seller_order_00?useUnicode=true&characterEncoding=utf8', 'sibu_integralmall', '09NWaUZUNjjr0IRCYzm3');
INSERT INTO `server_config` VALUES ('912b187203ca4cafb9bda7c2f3a62335', '4', '3', 'com.mysql.jdbc.Driver', 'jdbc:mysql://10.170.4.106/sibu_integralmall_base?useUnicode=true&characterEncoding=utf8', 'sibu_integralmall', '09NWaUZUNjjr0IRCYzm3');
INSERT INTO `server_config` VALUES ('9695619948574d72a15193d8bb84aec6', '5', '5', 'com.mysql.jdbc.Driver', 'jdbc:mysql://10.24.208.147/sibu_integralmall_order_05?useUnicode=true&characterEncoding=utf8', 'sibu_integralmall', '09NWaUZUNjjr0IRCYzm3');
INSERT INTO `server_config` VALUES ('9ad4e1f3d8824c0fa26a66baef4a76f9', '2', '5', 'com.mysql.jdbc.Driver', 'jdbc:mysql://10.24.208.147/sibu_wesale_buyer_order_05?useUnicode=true&characterEncoding=utf8', 'sibu_integralmall', '09NWaUZUNjjr0IRCYzm3');
INSERT INTO `server_config` VALUES ('9b1cb4dc4b204c63afe9188630f58c56', '5', '7', 'com.mysql.jdbc.Driver', 'jdbc:mysql://10.24.208.147/sibu_integralmall_order_07?useUnicode=true&characterEncoding=utf8', 'sibu_integralmall', '09NWaUZUNjjr0IRCYzm3');
INSERT INTO `server_config` VALUES ('a17d03b415be474e88ce1a6bbf37464d', '4', '1', 'com.mysql.jdbc.Driver', 'jdbc:mysql://10.170.4.106/sibu_integralmall_base?useUnicode=true&characterEncoding=utf8', 'sibu_integralmall', '09NWaUZUNjjr0IRCYzm3');
INSERT INTO `server_config` VALUES ('a2fd6927d43e413d89011fcbbe098857', '1', '7', 'com.mysql.jdbc.Driver', 'jdbc:mysql://10.24.208.147/sibu_wesale_member_07?useUnicode=true&characterEncoding=utf8', 'sibu_integralmall', '09NWaUZUNjjr0IRCYzm3');
INSERT INTO `server_config` VALUES ('a4eaa8393620451f9d2754f45579af36', '5', '0', 'com.mysql.jdbc.Driver', 'jdbc:mysql://10.170.4.106/sibu_integralmall_order_00?useUnicode=true&characterEncoding=utf8', 'sibu_integralmall', '09NWaUZUNjjr0IRCYzm3');
INSERT INTO `server_config` VALUES ('aebcf39294714ffca217c9fd31afe74b', '1', '6', 'com.mysql.jdbc.Driver', 'jdbc:mysql://10.24.208.147/sibu_wesale_member_06?useUnicode=true&characterEncoding=utf8', 'sibu_integralmall', '09NWaUZUNjjr0IRCYzm3');
INSERT INTO `server_config` VALUES ('aec43b91d1004e91a3bde78c49c5f565', '2', '2', 'com.mysql.jdbc.Driver', 'jdbc:mysql://10.170.4.106/sibu_wesale_buyer_order_02?useUnicode=true&characterEncoding=utf8', 'sibu_integralmall', '09NWaUZUNjjr0IRCYzm3');
INSERT INTO `server_config` VALUES ('b04b1c99c2e0465291bab063305f4ed7', '4', '5', 'com.mysql.jdbc.Driver', 'jdbc:mysql://10.24.208.147/sibu_integralmall_base?useUnicode=true&characterEncoding=utf8', 'sibu_integralmall', '09NWaUZUNjjr0IRCYzm3');
INSERT INTO `server_config` VALUES ('baf1b25b87d34b739f8923053d7e73d4', '0', '7', 'com.mysql.jdbc.Driver', 'jdbc:mysql://10.24.208.147/sibu_wesale_base?useUnicode=true&characterEncoding=utf8', 'sibu_integralmall', '09NWaUZUNjjr0IRCYzm3');
INSERT INTO `server_config` VALUES ('bb34da757582421cbbf392d3aede3402', '3', '4', 'com.mysql.jdbc.Driver', 'jdbc:mysql://10.24.208.147/sibu_wesale_seller_order_04?useUnicode=true&characterEncoding=utf8', 'sibu_integralmall', '09NWaUZUNjjr0IRCYzm3');
INSERT INTO `server_config` VALUES ('bbadbf473f674b4ab2b92cc6f5bc0aed', '3', '1', 'com.mysql.jdbc.Driver', 'jdbc:mysql://10.170.4.106/sibu_wesale_seller_order_01?useUnicode=true&characterEncoding=utf8', 'sibu_integralmall', '09NWaUZUNjjr0IRCYzm3');
INSERT INTO `server_config` VALUES ('bd0c08d98948479eae286302ce0c4026', '6', '6', 'com.mysql.jdbc.Driver', 'jdbc:mysql://10.24.208.147/sibu_integralmall_comment_06?useUnicode=true&characterEncoding=utf8', 'sibu_integralmall', '09NWaUZUNjjr0IRCYzm3');
INSERT INTO `server_config` VALUES ('c0a833861a3b47e19f07620b8d2e2749', '4', '2', 'com.mysql.jdbc.Driver', 'jdbc:mysql://10.170.4.106/sibu_integralmall_base?useUnicode=true&characterEncoding=utf8', 'sibu_integralmall', '09NWaUZUNjjr0IRCYzm3');
INSERT INTO `server_config` VALUES ('c9f39018401d4067a22d229d5443e01a', '4', '4', 'com.mysql.jdbc.Driver', 'jdbc:mysql://10.24.208.147/sibu_integralmall_base?useUnicode=true&characterEncoding=utf8', 'sibu_integralmall', '09NWaUZUNjjr0IRCYzm3');
INSERT INTO `server_config` VALUES ('d0e515ef40a44514999be5c265231757', '1', '3', 'com.mysql.jdbc.Driver', 'jdbc:mysql://10.170.4.106/sibu_wesale_member_03?useUnicode=true&characterEncoding=utf8', 'sibu_integralmall', '09NWaUZUNjjr0IRCYzm3');
INSERT INTO `server_config` VALUES ('d37a74b4a1cd4cffa441595b85edfa7e', '2', '4', 'com.mysql.jdbc.Driver', 'jdbc:mysql://10.24.208.147/sibu_wesale_buyer_order_04?useUnicode=true&characterEncoding=utf8', 'sibu_integralmall', '09NWaUZUNjjr0IRCYzm3');
INSERT INTO `server_config` VALUES ('d44b57afd3064811b14b5019ac89f91c', '1', '5', 'com.mysql.jdbc.Driver', 'jdbc:mysql://10.24.208.147/sibu_wesale_member_05?useUnicode=true&characterEncoding=utf8', 'sibu_integralmall', '09NWaUZUNjjr0IRCYzm3');
INSERT INTO `server_config` VALUES ('dbf9404727304c548803106591e79146', '5', '2', 'com.mysql.jdbc.Driver', 'jdbc:mysql://10.170.4.106/sibu_integralmall_order_02?useUnicode=true&characterEncoding=utf8', 'sibu_integralmall', '09NWaUZUNjjr0IRCYzm3');
INSERT INTO `server_config` VALUES ('e1a1e6ad76154cc59a4f78fbf0c366dd', '1', '2', 'com.mysql.jdbc.Driver', 'jdbc:mysql://10.170.4.106/sibu_wesale_member_02?useUnicode=true&characterEncoding=utf8', 'sibu_integralmall', '09NWaUZUNjjr0IRCYzm3');
INSERT INTO `server_config` VALUES ('e6a9b55e67ed445592acd43d894f587e', '5', '3', 'com.mysql.jdbc.Driver', 'jdbc:mysql://10.170.4.106/sibu_integralmall_order_03?useUnicode=true&characterEncoding=utf8', 'sibu_integralmall', '09NWaUZUNjjr0IRCYzm3');
INSERT INTO `server_config` VALUES ('e7af93f773a949b4848fb6cb0850da5f', '5', '4', 'com.mysql.jdbc.Driver', 'jdbc:mysql://10.24.208.147/sibu_integralmall_order_04?useUnicode=true&characterEncoding=utf8', 'sibu_integralmall', '09NWaUZUNjjr0IRCYzm3');
INSERT INTO `server_config` VALUES ('e8266e84c6ac4a5dbfae49e85e8aec43', '6', '7', 'com.mysql.jdbc.Driver', 'jdbc:mysql://10.24.208.147/sibu_integralmall_comment_07?useUnicode=true&characterEncoding=utf8', 'sibu_integralmall', '09NWaUZUNjjr0IRCYzm3');
INSERT INTO `server_config` VALUES ('eb34b72f22684917a2d176f80f7b8b00', '2', '0', 'com.mysql.jdbc.Driver', 'jdbc:mysql://10.170.4.106/sibu_wesale_buyer_order_00?useUnicode=true&characterEncoding=utf8', 'sibu_integralmall', '09NWaUZUNjjr0IRCYzm3');
INSERT INTO `server_config` VALUES ('f52a7b7bb9bf46a3bd0d0c9ef1eb65ee', '2', '7', 'com.mysql.jdbc.Driver', 'jdbc:mysql://10.24.208.147/sibu_wesale_buyer_order_07?useUnicode=true&characterEncoding=utf8', 'sibu_integralmall', '09NWaUZUNjjr0IRCYzm3');
INSERT INTO `server_config` VALUES ('f59251f1892d408bb0de42d21f6b38d4', '2', '6', 'com.mysql.jdbc.Driver', 'jdbc:mysql://10.24.208.147/sibu_wesale_buyer_order_06?useUnicode=true&characterEncoding=utf8', 'sibu_integralmall', '09NWaUZUNjjr0IRCYzm3');
INSERT INTO `server_config` VALUES ('f735286abf1146fb8560a8880294af00', '7', '0', 'com.mysql.jdbc.Driver', 'jdbc:mysql://10.170.4.106/sibu_wesale_trade_log_00?useUnicode=true&characterEncoding=utf8', 'sibu_integralmall', '09NWaUZUNjjr0IRCYzm3');
INSERT INTO `server_config` VALUES ('f735286abf1146fb8560a8880294af01', '7', '1', 'com.mysql.jdbc.Driver', 'jdbc:mysql://10.170.4.106/sibu_wesale_trade_log_01?useUnicode=true&characterEncoding=utf8', 'sibu_integralmall', '09NWaUZUNjjr0IRCYzm3');
INSERT INTO `server_config` VALUES ('f735286abf1146fb8560a8880294af02', '7', '2', 'com.mysql.jdbc.Driver', 'jdbc:mysql://10.170.4.106/sibu_wesale_trade_log_02?useUnicode=true&characterEncoding=utf8', 'sibu_integralmall', '09NWaUZUNjjr0IRCYzm3');
INSERT INTO `server_config` VALUES ('f735286abf1146fb8560a8880294af03', '7', '3', 'com.mysql.jdbc.Driver', 'jdbc:mysql://10.170.4.106/sibu_wesale_trade_log_03?useUnicode=true&characterEncoding=utf8', 'sibu_integralmall', '09NWaUZUNjjr0IRCYzm3');
INSERT INTO `server_config` VALUES ('f735286abf1146fb8560a8880294af04', '7', '4', 'com.mysql.jdbc.Driver', 'jdbc:mysql://10.24.208.147/sibu_wesale_trade_log_04?useUnicode=true&characterEncoding=utf8', 'sibu_integralmall', '09NWaUZUNjjr0IRCYzm3');
INSERT INTO `server_config` VALUES ('f735286abf1146fb8560a8880294af05', '7', '5', 'com.mysql.jdbc.Driver', 'jdbc:mysql://10.24.208.147/sibu_wesale_trade_log_05?useUnicode=true&characterEncoding=utf8', 'sibu_integralmall', '09NWaUZUNjjr0IRCYzm3');
INSERT INTO `server_config` VALUES ('f735286abf1146fb8560a8880294af06', '7', '6', 'com.mysql.jdbc.Driver', 'jdbc:mysql://10.24.208.147/sibu_wesale_trade_log_06?useUnicode=true&characterEncoding=utf8', 'sibu_integralmall', '09NWaUZUNjjr0IRCYzm3');
INSERT INTO `server_config` VALUES ('f735286abf1146fb8560a8880294af07', '7', '7', 'com.mysql.jdbc.Driver', 'jdbc:mysql://10.24.208.147/sibu_wesale_trade_log_07?useUnicode=true&characterEncoding=utf8', 'sibu_integralmall', '09NWaUZUNjjr0IRCYzm3');
INSERT INTO `server_config` VALUES ('f735286abf1146fb8560a8880294afe8', '5', '1', 'com.mysql.jdbc.Driver', 'jdbc:mysql://10.170.4.106/sibu_integralmall_order_01?useUnicode=true&characterEncoding=utf8', 'sibu_integralmall', '09NWaUZUNjjr0IRCYzm3');
-- ----------------------------
-- Table structure for system_admin
-- ----------------------------
DROP TABLE IF EXISTS `system_admin`;
CREATE TABLE `system_admin` (
`admin_id` varchar(36) NOT NULL COMMENT '管理员ID',
`username` varchar(32) NOT NULL COMMENT '用户名',
`password` varchar(36) NOT NULL COMMENT '密码',
`phone` varchar(18) NOT NULL COMMENT '联系电话',
`wechat` varchar(32) DEFAULT NULL COMMENT '微信号',
`type_id` tinyint(4) NOT NULL DEFAULT '1' COMMENT '管理员类型',
`create_dt` datetime NOT NULL COMMENT '创建时间',
`login_dt` datetime DEFAULT NULL COMMENT '最后登录时间',
`delete_flag` tinyint(4) NOT NULL DEFAULT '1' COMMENT '删除标识',
PRIMARY KEY (`admin_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of system_admin
-- ----------------------------
INSERT INTO `system_admin` VALUES ('21B89E77C32F48CDA12A24208EC21AA3', 'admin', 'e10adc3949ba59abbe56e057f20f883e', '13700137000', '123', '1', '2016-05-05 11:15:39', null, '1');
SibuCaiwu201601
INSERT INTO `system_admin` VALUES ('2f3d23b8-0d41-4bbb-b2f1-9073a293a83f', 'caiwu01', 'db9e4c2a697d5f7456ab0b9abb503d4c', 'caiwu01', '123', '2', '2016-07-14 11:15:39', null, '1');