DDL
CREATE TABLE `shuGuo_cats` (
`catld` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增ID',
`catName` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '数据分类名称',
`dataFlag` tinyint(4) NULL DEFAULT 1 COMMENT '有效标志(1:有效 -1:删除)',
`catCode` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '分类表标记字母',
PRIMARY KEY (`catld`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
DDL
CREATE TABLE `shuGuo_datas` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增ID',
`catld` int(11) NOT NULL DEFAULT 0 COMMENT '分类ID',
`dataName` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '数据名称',
`dataVal` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '数据值',
`dataSort` int(11) NOT NULL DEFAULT 0 COMMENT '排序号',
`dataFlag` varchar(4) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '1' COMMENT '有效标记(1:有效 -1:删除)',
`subCatld` int(11) NULL DEFAULT 0 COMMENT '子分类ID',
`subDateVal` int(11) NULL DEFAULT 0 COMMENT '子分类数据内容',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
DDL
CREATE TABLE `shuGuo_express` (
`expressld` int(11) NOT NULL COMMENT '自增ID',
`expressName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '快递名称',
`dataFlag` tinyint(4) NOT NULL DEFAULT 1 COMMENT '删除标志(1:有效 -1:删除)',
`expressCode` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '快递代码(主要用于物流插件)',
`isShow` tinyint(4) NULL DEFAULT 1 COMMENT '是否启用(1:是 0:否)',
PRIMARY KEY (`expressld`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
DDL
CREATE TABLE `shuGuo_facorites` (
`facoriteld` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增ID',
`userld` int(11) NOT NULL DEFAULT 0 COMMENT '用户ID',
`createTime` datetime(0) NOT NULL COMMENT '创建时间',
`goodsld` int(11) NULL DEFAULT NULL COMMENT '商品ID',
`currShopPrice` decimal(11, 2) NOT NULL COMMENT '关注时的价格',
PRIMARY KEY (`facoriteld`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
DDL
CREATE TABLE `shuGuo_items` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增ID',
`chargeMoney` int(11) NULL DEFAULT 0 COMMENT '充值金额',
`giveMoney` decimal(11, 1) NULL DEFAULT NULL COMMENT '赠送金额',
`itemSort` int(11) NULL DEFAULT 0 COMMENT '排序号',
`dataFlag` tinyint(4) NULL DEFAULT 1 COMMENT '是否有效(1:有效 -1:删除)',
`createTime` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
DDL
CREATE TABLE `shuGuo_shops` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增ID',
`shopld` int(11) NOT NULL DEFAULT 0 COMMENT '店铺ID',
`catld` int(11) NOT NULL DEFAULT 0 COMMENT '所属分类ID',
`commissionRate` decimal(11, 2) NULL DEFAULT NULL COMMENT '商家店铺分类佣金比例',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;