MXXS-SQL

mall_commodity_type

ALTER TABLE `rg_bs_mall`.`mall_commodity_type` 
ADD COLUMN `GROUP_ID` int NULL DEFAULT NULL COMMENT '类别组' AFTER `MODIFY_DATE`;

mall_commodity_refs 商品和类别关系

/*
 Navicat Premium Data Transfer

 Source Server         : 42.192.22.252(MXXS)
 Source Server Type    : MySQL
 Source Server Version : 80020
 Source Host           : 42.192.22.252:3306
 Source Schema         : mxxs_bs_mall

 Target Server Type    : MySQL
 Target Server Version : 80020
 File Encoding         : 65001

 Date: 29/04/2022 07:16:45
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for mall_commodity_refs
-- ----------------------------
DROP TABLE IF EXISTS `mall_commodity_refs`;
CREATE TABLE `mall_commodity_refs`  (
  `CT_ID` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键',
  `TYPE_ID` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '商品类别ID',
  `COMM_ID` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '商品ID',
  `GROUP_ID` int NULL DEFAULT NULL COMMENT '类别组ID(便于后期统计)',
  PRIMARY KEY (`CT_ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;

SET FOREIGN_KEY_CHECKS = 1;

地理位置和行政区

ALTER TABLE `rg_bs_mall`.`mall_merchant` 
ADD COLUMN `GEOGRAPHY` geometry NULL COMMENT '地理位置',
ADD COLUMN `AREA_CODE` varchar(50) NULL COMMENT '行政区';

ALTER TABLE `rg_bs_mall`.`mall_business` 
ADD COLUMN `GEOGRAPHY` geometry NULL COMMENT '地理位置',
ADD COLUMN `AREA_CODE` varchar(50) NULL COMMENT '行政区';