lachang/数据库修改记录.txt

//门店列表
CREATE TABLE `yoshop_shops`  (
  `shop_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `shop_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '门店名称',
  `addr` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '门店地址',
  `boss_user_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '店老板',
  `manager_user_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '店长',
  `contact` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '店面联系人',
  `contact_mobile` varchar(18) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '联系人电话',
  `is_delete` tinyint(3) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否删除',
  `create_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '创建时间',
  `update_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '更新时间',
  PRIMARY KEY (`shop_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '门店列表' ROW_FORMAT = Dynamic;

//用户表加角色
alter table yoshop_user add role tinyint(4) DEFAULT '1' COMMENT '用户角色1:普通用户,2:店老板,3:店长,4:店员';
//用户表加门店id
alter table yoshop_user add shop_id int(11) DEFAULT '0' COMMENT '门店id';
//商品加入门店id
alter table yoshop_goods add shop_id int(11) DEFAULT '0' COMMENT '门店id';

//配置佣金百分比表
CREATE TABLE `yoshop_config_percent`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `staff_percent` int(4) UNSIGNED NOT NULL DEFAULT 0 COMMENT '店员佣金',
  `manager_percent` int(4) NOT NULL COMMENT '店长佣金',
  `boss_percent` int(4) NOT NULL COMMENT '店老板佣金',
  `create_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '创建时间',
  `update_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;