union-php/doc/union.sql

CREATE TABLE `eb_security_category` (
                                        `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增ID',
                                        `name` varchar(50) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '类别名称',
                                        `price` decimal(12,2) NOT NULL DEFAULT '0.00' COMMENT '分类商品价格',
                                        `point` int(6) NOT NULL DEFAULT '0' COMMENT '赠送积分',
                                        `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '卡状态：0：冻结；1：激活',
                                        `remark` varchar(100) DEFAULT NULL COMMENT '备注',
                                        `add_time` int(10) NOT NULL DEFAULT '0' COMMENT '添加时间',
                                        `update_time` int(10) NOT NULL DEFAULT '0' COMMENT '更新时间',
                                        PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='防伪码类别';


CREATE TABLE `eb_security_code_record` (
                                           `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增ID',
                                           `category_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '类别id',
                                           `security_code` varchar(30) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '防伪码编码',
                                           `wx_url` varchar(100) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '微信扫码链接地址',
                                           `scan_uid` int(11) DEFAULT NULL COMMENT '扫码使用用户',
                                           `scan_time` int(10) DEFAULT NULL COMMENT '首次扫码时间',
                                           `status` tinyint(1) DEFAULT NULL COMMENT '防伪码状态：0：冻结；1：激活 2：已使用',
                                           `add_time` int(10) NOT NULL DEFAULT '0' COMMENT '添加时间',
                                           `update_time` int(10) NOT NULL DEFAULT '0' COMMENT '更新时间',
                                           PRIMARY KEY (`id`) USING BTREE,
                                           UNIQUE KEY `udx_code` (`security_code`) USING HASH
) ENGINE=InnoDB AUTO_INCREMENT=22009 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='防伪码记录';

alter table eb_user add column

    `city_id` int(11) NOT NULL DEFAULT '0' COMMENT '城市id';

alter table eb_user add column

    `city_name` varchar(100) NOT NULL DEFAULT '' COMMENT '所在市';

alter table eb_user add column

    `store_name` varchar(100) NOT NULL DEFAULT '' COMMENT '门店名称';