ngds/sql/upgrade/1962.sql

CREATE TABLE `AR_BA_APPROACH_ORDER_GOODS` (
  `ID` varchar(32) COLLATE utf8mb4_bin NOT NULL,
  `ORDER_SN` varchar(32) COLLATE utf8mb4_bin NOT NULL,
  `GOODS_ID` varchar(32) COLLATE utf8mb4_bin NOT NULL,
  `GOODS_TITLE` varchar(255) COLLATE utf8mb4_bin NOT NULL,
  `PRICE` decimal(16,2) NOT NULL DEFAULT 0.00,
  `REAL_PRICE` decimal(16,2) NOT NULL DEFAULT 0.00,
  `PV` decimal(16,2) NOT NULL DEFAULT 0.00,
  `REAL_PV` decimal(16,2) NOT NULL DEFAULT 0.00,
  `STANDARD_PRICE` float(16,2) NOT NULL DEFAULT 0.00 COMMENT '标准价格',
  `REAL_STANDARD_PRICE` float(16,2) NOT NULL DEFAULT 0.00 COMMENT '支付标准价格',
  `EXCHANGE_RATE` float(10,4) NOT NULL DEFAULT 0.0000 COMMENT '汇率',
  `TAX_RATE` float(16,2) NOT NULL DEFAULT 0.00 COMMENT '税率',
  `SKU_CODE` varchar(16) COLLATE utf8mb4_bin NOT NULL,
  `BUY_NUMS` int(10) NOT NULL DEFAULT 0,
  `P_CALC_MONTH` date NOT NULL,
  `POINT` smallint(5) unsigned NOT NULL DEFAULT 0,
  `CATEGORY_TYPE` tinyint(1) unsigned NOT NULL DEFAULT 1 COMMENT '商品分类：1普通商品',
  `PAY_TYPE` varchar(30) COLLATE utf8mb4_bin NOT NULL DEFAULT 'cash' COMMENT '支付方式：7-pay_stack',
  `EMAIL` varchar(32) COLLATE utf8mb4_bin DEFAULT '' COMMENT '邮箱',
  PRIMARY KEY (`ID`) USING BTREE,
  KEY `GOODS_ID` (`GOODS_ID`) USING BTREE,
  KEY `ORDER_SN` (`ORDER_SN`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC COMMENT='BA会员订单中包含的商品';


CREATE TABLE `AR_BA_APPROACH_ORDER` (
  `ID` varchar(32) COLLATE utf8mb4_bin NOT NULL,
  `SN` varchar(32) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  `DEC_SN` varchar(32) COLLATE utf8mb4_bin DEFAULT '',
  `USER_ID` varchar(32) COLLATE utf8mb4_bin NOT NULL,
  `USER_NAME` varchar(16) COLLATE utf8mb4_bin NOT NULL,
  `ORDER_TYPE` varchar(12) COLLATE utf8mb4_bin NOT NULL,
  `ORDER_AMOUNT` decimal(16,2) NOT NULL DEFAULT 0.00,
  `PV` decimal(16,2) NOT NULL DEFAULT 0.00,
  `PAY_AMOUNT` decimal(16,2) NOT NULL DEFAULT 0.00,
  `PAY_PV` decimal(16,2) NOT NULL DEFAULT 0.00,
  `ORDER_AMOUNT_STANDARD` float(16,2) NOT NULL DEFAULT 0.00 COMMENT '订单价格-标准价格',
  `PAY_AMOUNT_STANDARD` float(16,2) NOT NULL DEFAULT 0.00 COMMENT '标准价格',
  `EXCHANGE_RATE` float(10,4) NOT NULL DEFAULT 0.0000 COMMENT '汇率',
  `PAY_AT` int(10) NOT NULL DEFAULT 0,
  `FREIGHT` float(10,2) NOT NULL DEFAULT 0.00,
  `PAY_FREIGHT` float(10,2) NOT NULL DEFAULT 0.00,
  `DELIVERY_STATUS` tinyint(2) NOT NULL DEFAULT 0,
  `DELIVERY_PERIOD` int(10) NOT NULL DEFAULT 0,
  `DELIVERY_AT` int(10) NOT NULL DEFAULT 0,
  `EXPRESS_COMPANY` varchar(128) COLLATE utf8mb4_bin DEFAULT '',
  `ORDER_TRACK_NO` varchar(32) COLLATE utf8mb4_bin DEFAULT '',
  `EXPRESS_TYPE` tinyint(1) NOT NULL DEFAULT 0,
  `FRONT_REMARK` varchar(1000) COLLATE utf8mb4_bin DEFAULT '',
  `REMARK` text COLLATE utf8mb4_bin DEFAULT NULL,
  `NOTE` text COLLATE utf8mb4_bin DEFAULT NULL COMMENT '备注内容',
  `PERIOD_NUM` int(10) NOT NULL DEFAULT 0,
  `STATUS` int(3) NOT NULL DEFAULT 0,
  `CONSIGNEE` varchar(120) COLLATE utf8mb4_bin DEFAULT '',
  `MOBILE` varchar(11) COLLATE utf8mb4_bin DEFAULT '',
  `TEL` varchar(16) COLLATE utf8mb4_bin DEFAULT '',
  `PROVINCE` int(6) NOT NULL DEFAULT 0,
  `CITY` int(6) DEFAULT 0,
  `COUNTY` int(9) DEFAULT 0,
  `LGA_NAME` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
  `CITY_NAME` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
  `ADDRESS` varchar(255) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  `P_CALC_MONTH` date NOT NULL,
  `CREATED_AT` int(10) NOT NULL DEFAULT 0,
  `CREATE_USER` varchar(16) COLLATE utf8mb4_bin NOT NULL,
  `UPDATED_AT` int(10) NOT NULL DEFAULT 0,
  `UPDATER` varchar(16) COLLATE utf8mb4_bin DEFAULT '',
  `IS_DELETE` int(10) NOT NULL DEFAULT 0,
  `DELETED_AT` int(10) NOT NULL DEFAULT 0,
  `PAY_TYPE` varchar(32) COLLATE utf8mb4_bin NOT NULL DEFAULT 'cash',
  `WAREHOUSE` varchar(16) COLLATE utf8mb4_bin NOT NULL DEFAULT '01',
  `EMAIL` varchar(32) COLLATE utf8mb4_bin DEFAULT '' COMMENT '邮箱',
  `REMAIN_PV` decimal(16,2) NOT NULL DEFAULT 0.00 COMMENT '当期未计入的剩余PV',
  `IS_AUTO` int(11) NOT NULL DEFAULT 0 COMMENT '假订单标志',
  PRIMARY KEY (`ID`) USING BTREE,
  KEY `SN` (`SN`) USING BTREE,
  KEY `USER_ID` (`USER_ID`) USING BTREE,
  KEY `USER_NAME` (`USER_NAME`) USING BTREE,
  KEY `PERIOD_NUM` (`PERIOD_NUM`) USING BTREE,
  KEY `IS_DELETE` (`IS_DELETE`) USING BTREE,
  KEY `ORDER_TYPE` (`ORDER_TYPE`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC COMMENT='BA会员商品中间订单';

CREATE TABLE `AR_BA_ORDER` (
  `ID` varchar(32) COLLATE utf8mb4_bin NOT NULL,
  `SN` varchar(32) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  `DEC_SN` varchar(32) COLLATE utf8mb4_bin DEFAULT '',
  `USER_ID` varchar(32) COLLATE utf8mb4_bin NOT NULL,
  `USER_NAME` varchar(16) COLLATE utf8mb4_bin NOT NULL,
  `ORDER_TYPE` varchar(12) COLLATE utf8mb4_bin NOT NULL,
  `ORDER_AMOUNT` decimal(16,2) NOT NULL DEFAULT 0.00,
  `PV` decimal(16,2) NOT NULL DEFAULT 0.00,
  `PAY_AMOUNT` decimal(16,2) NOT NULL DEFAULT 0.00,
  `PAY_PV` decimal(16,2) NOT NULL DEFAULT 0.00,
  `ORDER_AMOUNT_STANDARD` float(16,2) NOT NULL DEFAULT 0.00 COMMENT '订单价格-标准价格',
  `PAY_AMOUNT_STANDARD` float(16,2) NOT NULL DEFAULT 0.00 COMMENT '支付金额-标准价格',
  `EXCHANGE_RATE` float(10,4) NOT NULL DEFAULT 0.0000 COMMENT '汇率',
  `PAY_AT` int(10) NOT NULL DEFAULT 0,
  `FREIGHT` float(10,2) NOT NULL DEFAULT 0.00,
  `PAY_FREIGHT` float(10,2) NOT NULL DEFAULT 0.00,
  `DELIVERY_STATUS` tinyint(2) NOT NULL DEFAULT 0,
  `DELIVERY_PERIOD` int(10) NOT NULL DEFAULT 0,
  `DELIVERY_AT` int(10) NOT NULL DEFAULT 0,
  `EXPRESS_COMPANY` varchar(128) COLLATE utf8mb4_bin DEFAULT '',
  `ORDER_TRACK_NO` varchar(32) COLLATE utf8mb4_bin DEFAULT '',
  `EXPRESS_TYPE` tinyint(1) NOT NULL DEFAULT 0,
  `FRONT_REMARK` varchar(1000) COLLATE utf8mb4_bin DEFAULT '',
  `REMARK` text COLLATE utf8mb4_bin DEFAULT NULL,
  `NOTE` text COLLATE utf8mb4_bin DEFAULT NULL COMMENT '备注内容',
  `PERIOD_NUM` int(10) NOT NULL DEFAULT 0,
  `STATUS` int(3) NOT NULL DEFAULT 0,
  `CONSIGNEE` varchar(120) COLLATE utf8mb4_bin DEFAULT '',
  `MOBILE` varchar(11) COLLATE utf8mb4_bin DEFAULT '',
  `TEL` varchar(16) COLLATE utf8mb4_bin DEFAULT '',
  `PROVINCE` int(6) NOT NULL DEFAULT 0,
  `CITY` int(6) DEFAULT NULL,
  `COUNTY` int(6) DEFAULT NULL,
  `CITY_NAME` varchar(50) COLLATE utf8mb4_bin DEFAULT '' COMMENT '城市名(NG)',
  `LGA_NAME` varchar(50) COLLATE utf8mb4_bin DEFAULT '' COMMENT 'Local Gov Area(NG)',
  `ADDRESS` varchar(255) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  `P_CALC_MONTH` date NOT NULL,
  `CREATED_AT` int(10) NOT NULL DEFAULT 0,
  `CREATE_USER` varchar(16) COLLATE utf8mb4_bin NOT NULL,
  `UPDATED_AT` int(10) NOT NULL DEFAULT 0,
  `UPDATER` varchar(16) COLLATE utf8mb4_bin DEFAULT '',
  `IS_DELETE` int(10) NOT NULL DEFAULT 0,
  `DELETED_AT` int(10) NOT NULL DEFAULT 0,
  `PAY_TYPE` varchar(32) COLLATE utf8mb4_bin NOT NULL DEFAULT 'cash',
  `WAREHOUSE` varchar(16) COLLATE utf8mb4_bin NOT NULL DEFAULT '01',
  `EMAIL` varchar(32) COLLATE utf8mb4_bin DEFAULT '' COMMENT '邮箱',
  `REMAIN_PV` decimal(16,2) NOT NULL DEFAULT 0.00 COMMENT '当期未计入的剩余PV',
  `IS_AUTO` int(11) NOT NULL DEFAULT 0 COMMENT '假订单标志',
  PRIMARY KEY (`ID`) USING BTREE,
  KEY `SN` (`SN`) USING BTREE,
  KEY `USER_ID` (`USER_ID`) USING BTREE,
  KEY `USER_NAME` (`USER_NAME`) USING BTREE,
  KEY `PERIOD_NUM` (`PERIOD_NUM`) USING BTREE,
  KEY `IS_DELETE` (`IS_DELETE`) USING BTREE,
  KEY `ORDER_TYPE` (`ORDER_TYPE`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC COMMENT='BA会员商品订单';


CREATE TABLE `AR_BA_ORDER_GOODS` (
  `ID` varchar(32) COLLATE utf8mb4_bin NOT NULL,
  `ORDER_SN` varchar(32) COLLATE utf8mb4_bin NOT NULL,
  `GOODS_ID` varchar(32) COLLATE utf8mb4_bin NOT NULL,
  `GOODS_TITLE` varchar(255) COLLATE utf8mb4_bin NOT NULL,
  `PRICE` decimal(16,2) NOT NULL DEFAULT 0.00,
  `REAL_PRICE` decimal(16,2) NOT NULL DEFAULT 0.00,
  `PV` decimal(16,2) NOT NULL DEFAULT 0.00,
  `REAL_PV` decimal(16,2) NOT NULL DEFAULT 0.00,
  `STANDARD_PRICE` float(16,2) NOT NULL DEFAULT 0.00 COMMENT '标准价格',
  `EXCHANGE_RATE` float(10,4) NOT NULL DEFAULT 0.0000 COMMENT '汇率',
  `TAX_RATE` float(16,2) NOT NULL DEFAULT 0.00 COMMENT '税率',
  `REAL_STANDARD_PRICE` float(16,2) NOT NULL DEFAULT 0.00 COMMENT '支付标准价格',
  `SKU_CODE` varchar(16) COLLATE utf8mb4_bin NOT NULL,
  `BUY_NUMS` int(10) NOT NULL DEFAULT 0,
  `P_CALC_MONTH` date NOT NULL,
  `POINT` smallint(5) unsigned NOT NULL DEFAULT 0,
  `EMAIL` varchar(32) COLLATE utf8mb4_bin DEFAULT '' COMMENT '邮箱',
  `CATEGORY_TYPE` tinyint(1) NOT NULL DEFAULT 1,
  `PAY_TYPE` varchar(30) COLLATE utf8mb4_bin DEFAULT 'cash',
  `REMAIN_PV` decimal(16,2) NOT NULL DEFAULT 0.00 COMMENT '当期未计入的剩余PV',
  PRIMARY KEY (`ID`) USING BTREE,
  KEY `GOODS_ID` (`GOODS_ID`) USING BTREE,
  KEY `ORDER_SN` (`ORDER_SN`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC COMMENT='BA会员订单中包含的商品';

CREATE TABLE `AR_BA_APPROACH_DEC_ORDER` (
  `ID` varchar(32) COLLATE utf8mb4_bin NOT NULL,
  `DEC_SN` varchar(32) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  `ORDER_SN` varchar(32) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  `USER_ID` varchar(32) COLLATE utf8mb4_bin NOT NULL,
  `TO_USER_ID` varchar(32) COLLATE utf8mb4_bin NOT NULL,
  `TYPE` varchar(32) COLLATE utf8mb4_bin NOT NULL,
  `IS_ADMIN` tinyint(1) NOT NULL DEFAULT 0,
  `DEC_AMOUNT` decimal(16,3) NOT NULL DEFAULT 0.000,
  `DEC_PV` decimal(16,3) NOT NULL DEFAULT 0.000,
  `PAID_WALLET` varchar(48) COLLATE utf8mb4_bin NOT NULL,
  `IS_BATCH` tinyint(1) NOT NULL DEFAULT 0,
  `REMARK` text COLLATE utf8mb4_bin DEFAULT NULL,
  `REC_USER_ID` varchar(32) COLLATE utf8mb4_bin DEFAULT '',
  `CON_USER_ID` varchar(32) COLLATE utf8mb4_bin DEFAULT '',
  `PERIOD_NUM` int(10) NOT NULL,
  `P_CALC_MONTH` date NOT NULL,
  `CALC_MONTH` int(8) NOT NULL DEFAULT 0,
  `CREATED_AT` int(10) NOT NULL,
  `UPDATER` varchar(32) COLLATE utf8mb4_bin DEFAULT '',
  `UPDATED_AT` varchar(32) COLLATE utf8mb4_bin NOT NULL DEFAULT '0',
  `IS_DEL` tinyint(1) NOT NULL DEFAULT 0,
  `DELETED_AT` int(10) NOT NULL DEFAULT 0,
  `DEC_ID` varchar(32) COLLATE utf8mb4_bin DEFAULT '',
  `DETAIL_TYPE` tinyint(1) NOT NULL DEFAULT 1 COMMENT '默认为1注册 2为升级',
  `UPGRADE_TYPE` tinyint(1) NOT NULL DEFAULT 0 COMMENT '1 补差额升级 2全额升级',
  `ORI_LV` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '升级前的级别',
  `UPGRADE_LV` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '升级后的级别',
  PRIMARY KEY (`ID`) USING BTREE,
  UNIQUE KEY `DEC_SN` (`DEC_SN`) USING BTREE,
  KEY `USER_ID` (`USER_ID`) USING BTREE,
  KEY `TYPE` (`TYPE`) USING BTREE,
  KEY `PERIOD_NUM` (`PERIOD_NUM`) USING BTREE,
  KEY `IS_DEL` (`IS_DEL`) USING BTREE,
  KEY `ORDER_SN` (`ORDER_SN`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC COMMENT='报单中间表';

CREATE TABLE `AR_BA_RECEIVE_ADDRESS` (
  `ID` varchar(32) COLLATE utf8mb4_bin NOT NULL,
  `USER_ID` varchar(32) COLLATE utf8mb4_bin NOT NULL,
  `USER_NAME` varchar(16) COLLATE utf8mb4_bin NOT NULL,
  `CONSIGNEE` varchar(120) COLLATE utf8mb4_bin NOT NULL,
  `MOBILE` varchar(11) COLLATE utf8mb4_bin NOT NULL,
  `PROVINCE` int(6) NOT NULL,
  `CITY` int(6) DEFAULT NULL,
  `COUNTY` int(6) DEFAULT NULL,
  `CITY_NAME` varchar(50) COLLATE utf8mb4_bin DEFAULT '' COMMENT '城市名(NG)',
  `LGA_NAME` varchar(50) COLLATE utf8mb4_bin DEFAULT '' COMMENT 'Local Gov Area(NG)',
  `ADDRESS` varchar(255) COLLATE utf8mb4_bin NOT NULL,
  `IS_DEFAULT` tinyint(1) NOT NULL DEFAULT 0,
  `CREATED_AT` int(10) NOT NULL DEFAULT 0,
  `UPDATER` varchar(10) COLLATE utf8mb4_bin DEFAULT '',
  `UPDATED_AT` int(10) NOT NULL DEFAULT 0,
  PRIMARY KEY (`ID`) USING BTREE,
  KEY `USER_ID` (`USER_ID`) USING BTREE,
  KEY `USER_NAME` (`USER_NAME`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC COMMENT='BA会员收货地址';

INSERT INTO `AR_BA_RECEIVE_ADDRESS` (`ID`, `USER_ID`, `USER_NAME`, `CONSIGNEE`, `MOBILE`, `PROVINCE`, `CITY`, `COUNTY`, `CITY_NAME`, `LGA_NAME`, `ADDRESS`, `IS_DEFAULT`, `CREATED_AT`, `UPDATER`, `UPDATED_AT`) VALUES ('100000000000000000', '300000000000000000', 'D', 'DCONSIGNEE_NAME', '18888888888', 1, 1, 1, '', '', '狮驼岭', 0, 1589064762, '', 0);