社区团购小程序+界面diy+分销+附近团长+供应商+拼团+菜谱+秒杀+预售+配送+直播

 V3.0.0 CREATE TABLE `oscshop_lionfish_comshop_member_integral_flow` ( `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '自增id', `member_id` int(10) NOT NULL COMMENT '会员id', `in_out` enum('in','out') NOT NULL COMMENT '增加积分，还是减少积分', `type` enum('goodsbuy','refundorder','system_add','system_del','orderbuy') NOT NULL COMMENT '积分获赠/减少 类型', `order_id` int(10) DEFAULT NULL COMMENT '订单id', `order_goods_id` int(10) DEFAULT NULL COMMENT '订单商品id', `score` float(10,2) DEFAULT '0.00' COMMENT '积分数量', `after_operate_score` float(10,2) DEFAULT '0.00' COMMENT '操作后的积分', `state` tinyint(1) DEFAULT '0' COMMENT '0 还未赠送，1处理成功，', `remark` varchar(255) DEFAULT NULL COMMENT '说明', `addtime` int(10) NOT NULL COMMENT '添加时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='积分流水记录表'; ALTER TABLE `oscshop_lionfish_community_head` ADD `agent_id` INT(10) NULL DEFAULT '0' COMMENT '推荐人id' AFTER `member_id`, ADD INDEX (`agent_id`); CREATE TABLE `oscshop_lionfish_community_head_invite_recod` ( `id` INT(10) NOT NULL AUTO_INCREMENT COMMENT '自增id' , `head_id` INT(10) NOT NULL COMMENT '团长id' , `agent_member_id` INT(10) NOT NULL COMMENT '推荐人id' , `money` FLOAT(10,2) NOT NULL COMMENT '奖励金额' , `addtime` INT(10) NOT NULL COMMENT '添加时间' , PRIMARY KEY (`id`), INDEX (`head_id`), INDEX (`agent_member_id`) ) ENGINE = InnoDB COMMENT = '狮子鱼团长推荐团长记录表'; ALTER TABLE `oscshop_lionfish_community_head_commiss_order` ADD `type` ENUM('orderbuy','commiss','tuijian') NOT NULL DEFAULT 'orderbuy' COMMENT 'orderbuy 团员订单购买 ,commiss 下级的会员订单购买,tuijian 推荐团长的佣金' AFTER `head_id`; ALTER TABLE `oscshop_lionfish_community_head_commiss_order` ADD `child_head_id` INT(10) NULL DEFAULT '0' COMMENT '下级团长id' AFTER `head_id`; ALTER TABLE `oscshop_lionfish_community_head_commiss_order` ADD `level` INT(10) NULL DEFAULT '0' COMMENT '第几层分佣' AFTER `type`; CREATE TABLE IF NOT EXISTS `oscshop_lionfish_comshop_community_head_level` ( `id` int(10) NOT NULL COMMENT '自增id', `levelname` varchar(255) NOT NULL COMMENT '等级名称', `commission1` float(10,2) DEFAULT '0.00' COMMENT '1级分销比例', `commission2` float(10,2) DEFAULT '0.00' COMMENT '2级分销比例', `commission3` float(10,2) DEFAULT '0.00' COMMENT '3级分销比例' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='狮子鱼商城团长等级表'; ALTER TABLE `oscshop_lionfish_comshop_community_head_level` ADD PRIMARY KEY (`id`); ALTER TABLE `oscshop_lionfish_comshop_community_head_level` MODIFY `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '自增id'; ALTER TABLE `oscshop_lionfish_community_head` ADD `level_id` INT(10) NULL DEFAULT '0' COMMENT '团长等级id' AFTER `agent_id`; ALTER TABLE `oscshop_lionfish_comshop_community_head_level` CHANGE `commission1` `commission` FLOAT(10,2) NULL DEFAULT '0.00' COMMENT '分销比例'; ALTER TABLE `oscshop_lionfish_comshop_community_head_level` DROP `commission2`, DROP `commission3`; ALTER TABLE `oscshop_lionfish_comshop_good_common` ADD `is_modify_head_commission` TINYINT(1) NULL DEFAULT '0' COMMENT '是否开启独立配置团长等级分佣' AFTER `community_head_commission`, ADD `community_head_commission_modify` TEXT NULL COMMENT '自定义团长等级分佣配置信息' AFTER `is_modify_head_commission`; ALTER TABLE `oscshop_lionfish_community_head_commiss_order` ADD `bili` FLOAT(10,2) NULL DEFAULT '0' COMMENT '分销分佣比例' AFTER `type`; ALTER TABLE `oscshop_lionfish_comshop_member` CHANGE `score` `score` FLOAT(10,2) NULL DEFAULT '0' COMMENT '积分'; V2.6.0 ALTER TABLE `oscshop_lionfish_comshop_member_charge_flow` ADD `operate_end_yuer` FLOAT(10,2) NULL DEFAULT '0' COMMENT '当前操作结束后余额' AFTER `money`; V2.0 ALTER TABLE `oscshop_lionfish_comshop_supply` ADD `login_name` VARCHAR(50) NULL COMMENT '供应商登录名称' AFTER `apptime`, ADD `login_password` VARCHAR(100) NULL COMMENT '供应商登录密码' AFTER `login_name`, ADD `login_slat` VARCHAR(50) NULL COMMENT '密码盐值' AFTER `login_password`; ALTER TABLE `oscshop_lionfish_comshop_order_goods` ADD `fullreduction_money` FLOAT(10,2) NULL DEFAULT '0' COMMENT '满减金额' AFTER `oldprice`, ADD `voucher_credit` FLOAT(10,2) NULL DEFAULT '0' COMMENT '优惠券优惠金额' AFTER `fullreduction_money`; ALTER TABLE `oscshop_lionfish_comshop_order_goods` ADD `fenbi_li` FLOAT(10,2) NULL DEFAULT '0' COMMENT '订单中金额占比' AFTER `voucher_credit`; ALTER TABLE `oscshop_lionfish_comshop_supply` ADD `type` TINYINT(1) NULL DEFAULT '0' COMMENT '0 平台自营，1入驻' AFTER `state`; ALTER TABLE `oscshop_lionfish_comshop_supply` ADD `commiss_bili` INT(10) NULL DEFAULT '0' COMMENT '供应商提成。百分比' AFTER `type`; CREATE TABLE IF NOT EXISTS `oscshop_lionfish_supply_commiss_order` ( `id` int(10) NOT NULL COMMENT '自增ID', `supply_id` int(10) NOT NULL COMMENT '供应商id', `order_id` int(10) NOT NULL COMMENT '订单ID', `order_goods_id` int(10) DEFAULT '0' COMMENT '商品订单id', `state` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否结算：0，待计算。1，已结算。2，订单取消', `money` float(10,2) NOT NULL DEFAULT '0.00' COMMENT '分佣金额', `addtime` int(10) NOT NULL COMMENT '添加时间' ) ENGINE=MyISAM DEFAULT CHARSET=utf8; ALTER TABLE `oscshop_lionfish_supply_commiss_order` ADD PRIMARY KEY (`id`), ADD KEY `supply_id` (`supply_id`); ALTER TABLE `oscshop_lionfish_supply_commiss_order` MODIFY `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '自增ID'; CREATE TABLE IF NOT EXISTS `oscshop_lionfish_supply_commiss` ( `id` int(10) NOT NULL COMMENT '自增ID', `supply_id` int(10) NOT NULL COMMENT '供应商ID', `money` float(10,2) DEFAULT '0.00' COMMENT '可提现金额', `dongmoney` float(10,2) DEFAULT '0.00' COMMENT '提现中金额', `getmoney` float(10,2) DEFAULT '0.00' COMMENT '已提现金额' ) ENGINE=MyISAM DEFAULT CHARSET=utf8; ALTER TABLE `oscshop_lionfish_supply_commiss` ADD PRIMARY KEY (`id`), ADD KEY `supply_id` (`supply_id`); ALTER TABLE `oscshop_lionfish_supply_commiss` MODIFY `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '自增ID'; CREATE TABLE IF NOT EXISTS `oscshop_lionfish_supply_tixian_order` ( `id` int(10) NOT NULL COMMENT '自增id', `supply_id` int(10) NOT NULL COMMENT '团长id', `money` float(10,2) NOT NULL COMMENT '提现金额', `service_charge` float(10,2) DEFAULT '0.00' COMMENT '手续费', `state` tinyint(1) NOT NULL COMMENT '提现状态，0申请中，1提现成功，2体现失败', `shentime` int(10) NOT NULL COMMENT '审核时间', `is_send_fail` tinyint(1) DEFAULT '0' COMMENT '是否发送是否，1是，0否', `fail_msg` varchar(255) DEFAULT NULL COMMENT '发送失败原因', `addtime` int(10) NOT NULL COMMENT '提交时间' ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='分销佣金提现表'; ALTER TABLE `oscshop_lionfish_supply_tixian_order` ADD PRIMARY KEY (`id`), ADD KEY `supply_id` (`supply_id`); ALTER TABLE `oscshop_lionfish_supply_tixian_order` MODIFY `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '自增id'; ALTER TABLE `oscshop_lionfish_supply_commiss_order` ADD `total_money` FLOAT(10,2) NULL DEFAULT '0' COMMENT '总金额' AFTER `order_goods_id`, ADD `comunity_blili` FLOAT(10,2) NULL DEFAULT '0' COMMENT '服务费比例' AFTER `total_money`; ALTER TABLE `oscshop_lionfish_supply_commiss_order` ADD `head_commiss_money` FLOAT(10,2) NULL DEFAULT '0' COMMENT '团长分佣金额' AFTER `state`; ALTER TABLE `oscshop_lionfish_supply_tixian_order` ADD `bankname` VARCHAR(200) NULL COMMENT '转账类型。微信，支付宝，银行' AFTER `fail_msg`, ADD `ba