DROP TABLE IF EXISTS `eiinquirecondition${supplyCode}`; CREATE TABLE `eiinquirecondition${supplyCode}` ( `id` bigint(20) NOT NULL DEFAULT 0, `idInquire` bigint(20) NULL DEFAULT 0, `conditionName` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `conditionField` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `dataType` int(11) NULL DEFAULT 0, `defaultValue` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `visible` int(11) NULL DEFAULT 0, `selectDicType` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `sortAsc` int(11) NULL DEFAULT 0, `createBy` bigint(20) NULL DEFAULT 0, `createTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `updateBy` bigint(20) NULL DEFAULT 0, `updateTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `eiinquiremaininfo${supplyCode}`; CREATE TABLE `eiinquiremaininfo${supplyCode}` ( `id` bigint(20) NOT NULL DEFAULT 0, `inquireName` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `inquireFuncName` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `inquireType` int(11) NULL DEFAULT 0, `voidFlag` int(11) NULL DEFAULT 0, `createBy` bigint(20) NULL DEFAULT 0, `createTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `updateBy` bigint(20) NULL DEFAULT 0, `updateTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `canExport` int(11) NULL DEFAULT 0, `queryInPage` int(11) NULL DEFAULT 0, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `eiinquireresultcolumn${supplyCode}`; CREATE TABLE `eiinquireresultcolumn${supplyCode}` ( `id` bigint(20) NOT NULL DEFAULT 0, `idInquire` bigint(20) NULL DEFAULT 0, `columnName` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `columnField` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `columnWidth` int(11) NULL DEFAULT 0, `visible` int(11) NULL DEFAULT 0, `hasStatistics` int(11) NULL DEFAULT 0, `statisticsFormat` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `sortAsc` int(11) NULL DEFAULT 0, `createBy` bigint(20) NULL DEFAULT 0, `createTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `updateBy` bigint(20) NULL DEFAULT 0, `updateTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `linkUrl` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `idParentColumn` bigint(20) NULL DEFAULT 0, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `eopaymentordergroup${supplyCode}_current`; CREATE TABLE `eopaymentordergroup${supplyCode}_current` ( `id` bigint(20) NOT NULL DEFAULT 0, `billYear` int(11) NULL DEFAULT 0, `idUser` bigint(20) NULL DEFAULT 0, `userName` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `tradeCode` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `payableMoney` bigint(20) NULL DEFAULT 0, `paiedMoney` bigint(20) NULL DEFAULT 0, `payTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `payTimeLong` bigint(20) NULL DEFAULT 0, `paymentChannel` int(11) NULL DEFAULT 0, `orderCount` int(11) NULL DEFAULT 0, `billStatus` int(11) NULL DEFAULT 0, `startTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `startTimeLong` bigint(20) NULL DEFAULT 0, `expireTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `expireTimeLong` bigint(20) NULL DEFAULT 0, `payTimeOutExpress` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `dataSourceId` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `actPayMode` int(11) NULL DEFAULT 0, `actTransactionId` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `actTradeType` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `actBankType` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `actOpenId` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `actBuyerLogonId` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `createBy` bigint(20) NULL DEFAULT 0, `createTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `createTimeLong` bigint(20) NULL DEFAULT 0, `updateBy` bigint(20) NULL DEFAULT 0, `updateTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `updateTimeLong` bigint(20) NULL DEFAULT 0, `tradeKind` int(11) NULL DEFAULT 0, `actOutTransactionId` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '在线支付单据' ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `eopaymentordergroupitem${supplyCode}_current`; CREATE TABLE `eopaymentordergroupitem${supplyCode}_current` ( `idItem` bigint(20) NOT NULL DEFAULT 0, `idOrderGroup` bigint(20) NULL DEFAULT 0, `idOrderReceivable` bigint(20) NULL DEFAULT 0, `idOrder` bigint(20) NULL DEFAULT 0, `financeCode` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `orderCode` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `itemMoney` bigint(20) NULL DEFAULT 0, `createBy` bigint(20) NULL DEFAULT 0, `createTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `createTimeLong` bigint(20) NULL DEFAULT 0, `updateBy` bigint(20) NULL DEFAULT 0, `updateTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `updateTimeLong` bigint(20) NULL DEFAULT 0, `idPaymentGroup` bigint(20) NULL DEFAULT NULL, `orderName` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', PRIMARY KEY (`idItem`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '在线支付单据明细' ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `maMallUser{supplyCode}`; CREATE TABLE `maMallUser{supplyCode}` ( `id` bigint(20) NOT NULL DEFAULT '0', `userName` varchar(200) DEFAULT '', `loginName` varchar(100) DEFAULT NULL, `loginAccount` varchar(100) DEFAULT '', `password` varchar(500) DEFAULT '', `qqCode` varchar(100) DEFAULT '', `voidFlag` int(11) DEFAULT '0', `balanceFlag` int(11) DEFAULT '0', `idLevel` bigint(20) DEFAULT '0', `createBy` bigint(20) DEFAULT '0', `createTime` datetime NULL DEFAULT CURRENT_TIMESTAMP(0), `updateBy` bigint(20) DEFAULT '0', `updateTime` datetime DEFAULT CURRENT_TIMESTAMP, `levelExpireDate` datetime DEFAULT NULL, `levelExpireDateLong` bigint(20) DEFAULT '0', `verifyFlag` int(11) DEFAULT '0', `idVerifyUser` bigint(20) DEFAULT '0', `verifyUser` varchar(100) DEFAULT '', `verifyDate` datetime DEFAULT CURRENT_TIMESTAMP, `verifyDateLong` bigint(20) DEFAULT '0', PRIMARY KEY (`id`), KEY `idx_userName` (`userName`) USING BTREE, KEY `idx_loginName` (`loginName`) USING BTREE, KEY `idx_password` (`password`) USING BTREE, KEY `idx_loginAccount` (`loginAccount`) USING BTREE, ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `mamalluseraddress${supplyCode}`; CREATE TABLE `mamalluseraddress${supplyCode}` ( `id` bigint(20) NOT NULL DEFAULT 0, `userId` bigint(20) NULL DEFAULT 0, `receiveMan` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `receivePhone` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `province` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `city` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `area` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `address` varchar(800) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `defaultFlag` int(11) NULL DEFAULT 0, `createBy` bigint(20) NULL DEFAULT 0, `createTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `updateBy` bigint(20) NULL DEFAULT 0, `updateTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), PRIMARY KEY (`id`) USING BTREE, INDEX `idx_userId`(`userId`) USING BTREE, INDEX `idx_receiveMan`(`receiveMan`) USING BTREE, INDEX `idx_receivePhone`(`receivePhone`) USING BTREE, INDEX `idx_province`(`province`) USING BTREE, INDEX `idx_city`(`city`) USING BTREE, INDEX `idx_area`(`area`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `mamalluserlevel${supplyCode}`; CREATE TABLE `mamalluserlevel${supplyCode}` ( `id` bigint(20) NOT NULL DEFAULT 0, `levelName` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `levelValue` decimal(18, 4) NULL, `voidFlag` int(11) NULL DEFAULT 0, `checkFileFlag` int(11) NULL DEFAULT 0, `viewPriceDetailFlag` int(11) NULL DEFAULT 0, `expireDays` int(11) NULL DEFAULT 0, `idDowngradeLevel` bigint(20) NULL DEFAULT 0, `createBy` bigint(20) NULL DEFAULT 0, `createTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `createTimeLong` bigint(20) NULL DEFAULT 0, `updateBy` bigint(20) NULL DEFAULT 0, `updateTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `updateTimeLong` bigint(20) NULL DEFAULT 0, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; INSERT INTO `mamalluserlevel${supplyCode}` VALUES (1, '默认级别', 1, 0, 0, 0, 0, 0, 2, '2024-05-11 14:18:53', 1715408332932, 2, '2024-05-11 14:23:12', 1715408592404); DROP TABLE IF EXISTS `maposterlocation${supplyCode}`; CREATE TABLE `maposterlocation${supplyCode}` ( `id` bigint(20) NOT NULL DEFAULT 0, `posterName` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `posterLocationImage` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `posterLocation` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `clickLinkUrl` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `sortIndex` int(11) NULL DEFAULT 0, `createBy` bigint(20) NULL DEFAULT 0, `createTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `createTimeLong` bigint(20) NULL DEFAULT 0, `updateBy` bigint(20) NULL DEFAULT 0, `updateTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `updateTimeLong` bigint(20) NULL DEFAULT 0, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `moordercancelrequest${supplyCode}_current`; CREATE TABLE `moordercancelrequest${supplyCode}_current` ( `id` bigint(20) NOT NULL DEFAULT 0, `idOrder` bigint(20) NULL DEFAULT 0, `status` int(11) NULL DEFAULT 0, `idRequester` bigint(20) NULL DEFAULT 0, `requesterName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `idVerify` bigint(20) NULL DEFAULT 0, `verifyName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `orderName` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `orderCode` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `orderQty` int(11) NULL DEFAULT 0, `payableMoney` bigint(20) NULL DEFAULT 0, `userName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `userCode` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `productName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `createBy` bigint(20) NULL DEFAULT 0, `createTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `createTimeLong` bigint(20) NULL DEFAULT 0, `updateBy` bigint(20) NULL DEFAULT 0, `updateTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `updateTimeLong` bigint(20) NULL DEFAULT 0, `requestReason` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `moorderchargedata${supplyCode}_current`; CREATE TABLE `moorderchargedata${supplyCode}_current` ( `id` bigint(20) NOT NULL DEFAULT 0, `idReceivable` bigint(20) NULL DEFAULT 0, `chargeCode` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `lockFlag` int(11) NULL DEFAULT 0, `lockMan` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `financeCode` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `idClient` bigint(20) NULL DEFAULT 0, `clientCode` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `clientName` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `orderName` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `receivableMoney` decimal(18, 4) NULL DEFAULT NULL, `agioMoney` decimal(18, 4) NULL DEFAULT NULL, `agioMemo` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `idAccount` bigint(20) NULL DEFAULT 0, `accountName` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `voucherCode` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `payMan` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `dataKind` int(11) NULL DEFAULT 0, `chargeKind` int(11) NULL DEFAULT 0, `chargeMan` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `orderCreateTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `orderCreateTimeLong` bigint(20) NULL DEFAULT 0, `orderCreateMan` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `voidFlag` int(11) NULL DEFAULT 0, `billYear` int(11) NULL DEFAULT 0, `idOrder` bigint(20) NULL DEFAULT 0, `receiveCode` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `chargeDate` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `chargeDateLong` bigint(20) NULL DEFAULT 0, `createBy` bigint(20) NULL DEFAULT 0, `createTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `createTimeLong` bigint(20) NULL DEFAULT 0, `updateBy` bigint(20) NULL DEFAULT 0, `updateTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `updateTimeLong` bigint(20) NULL DEFAULT 0, `orderCode` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `idPaymentOrderGroup` bigint(20) NULL DEFAULT NULL, `chargeMemo` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `redState` int(11) NULL DEFAULT 0, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `moorderdeliverinform${supplyCode}_current`; CREATE TABLE `moorderdeliverinform${supplyCode}_current` ( `id` bigint(20) NOT NULL DEFAULT 0, `idOrder` bigint(20) NULL DEFAULT 0, `linkMan` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `linkPhone` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `sendProvince` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `sendCity` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `sendDistrict` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `sendAddress` varchar(800) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `needDeliverQty` decimal(18, 4) NULL, `deliveredQty` decimal(18, 4) NULL, `sendState` int(11) NULL DEFAULT 0, `sendKind` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `idLogistics` bigint(20) NULL DEFAULT 0, `logisticsName` varchar(300) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `customerLogisticsName` varchar(300) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `payOnDeliveryFlag` int(11) NULL DEFAULT 0, `longitude` decimal(18, 4) NULL, `latitude` decimal(18, 4) NULL, `idClient` bigint(20) NULL DEFAULT 0, `voidFlag` int(11) NULL DEFAULT 0, `acDeliverDate` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `acDeliverDateLong` bigint(20) NULL DEFAULT 0, `deliverMan` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `createMan` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `packDetail` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `packageCount` int(11) NULL DEFAULT 0, `createBy` bigint(20) NULL DEFAULT 0, `createTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `updateBy` bigint(20) NULL DEFAULT 0, `updateTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `updateTimeLong` bigint(20) NULL DEFAULT 0, `createTimeLong` bigint(20) NULL DEFAULT 0, `calcMallWeight` decimal(18, 8) NULL, `calcMallBoxCount` decimal(18, 8) NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `moorderfile${supplyCode}_current`; CREATE TABLE `moorderfile${supplyCode}_current` ( `id` bigint(20) NOT NULL DEFAULT 0, `idOrder` bigint(20) NULL DEFAULT 0, `fileDescription` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '', `fileDescription2` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '', `qiniuFileURL` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '', `qiniuFileKey` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '', `originFileLink` varchar(800) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `originFileLink2` varchar(800) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `attachFile` varchar(300) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `attachFileLink` varchar(800) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `proofFile` varchar(300) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `proofFileLink` varchar(800) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `fileDescriptionSave` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `createBy` bigint(20) NULL DEFAULT 0, `createTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `createTimeLong` bigint(20) NULL DEFAULT 0, `updateBy` bigint(20) NULL DEFAULT 0, `updateTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `updateTimeLong` bigint(20) NULL DEFAULT 0, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `moorderpart${supplyCode}_current`; CREATE TABLE `moorderpart${supplyCode}_current` ( `id` bigint(20) NOT NULL DEFAULT 0, `idOrder` bigint(20) NULL DEFAULT 0, `idPart` bigint(20) NULL DEFAULT 0, `partName` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `partSize` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `partSizeDesc` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `partSizeWidth` decimal(18, 4) NULL, `partSizeHeight` decimal(18, 4) NULL, `partSizeLength` decimal(18, 4) NULL, `bloodValue` decimal(18, 4) NULL, `idPaperType` bigint(20) NULL DEFAULT 0, `paperTypeName` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `idPaperQuoteInfo` bigint(20) NULL DEFAULT 0, `quotePaperName` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `faceCount` int(11) NULL DEFAULT 0, `pageQty` int(11) NULL DEFAULT 0, `partQty` decimal(18, 4) NULL, `paperGram` int(11) NULL DEFAULT 0, `originFile` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `finalFile` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `pasteUpFileObverse` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `pasteUpFileObversePageIndex` int(11) NULL DEFAULT 0, `pasteUpFileReverse` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `pasteUpFileReversePageIndex` int(11) NULL DEFAULT 0, `thumbFileObverse` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `thumbFileReverse` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `previewFileObverse` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `previewFileReverse` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `partIndex` int(11) NULL DEFAULT 0, `partColorObverse` bigint(20) NULL DEFAULT 0, `partColorReverse` bigint(20) NULL DEFAULT 0, `fileType` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `allProcessStr` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `fuMoFlag` int(11) NULL DEFAULT 0, `moQieFlag` int(11) NULL DEFAULT 0, `moduleCount` int(11) NULL DEFAULT 0, `partSaleQty` decimal(18, 4) NULL, `specialPaperFlag` int(11) NULL DEFAULT 0, `qtyEnoughFlag` int(11) NULL DEFAULT 0, `partDesc` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `mainFlag` int(11) NULL DEFAULT 0, `partColour` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `holdSize` int(11) NULL DEFAULT 0, `bookStyle` int(11) NULL DEFAULT 0, `cupSize` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `createBy` bigint(20) NULL DEFAULT 0, `createTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `updateBy` bigint(20) NULL DEFAULT 0, `updateTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `createTimeLong` bigint(20) NULL DEFAULT 0, `updateTimeLong` bigint(20) NULL DEFAULT 0, `paperName` varchar(150) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `moorderpartparamvalue${supplyCode}_current`; CREATE TABLE `moorderpartparamvalue${supplyCode}_current` ( `id` bigint(20) NOT NULL DEFAULT 0, `idOrder` bigint(20) NULL DEFAULT 0, `idOrderPart` bigint(20) NULL DEFAULT 0, `idParameter` bigint(20) NULL DEFAULT 0, `paramValue` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `paramDisplay` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `fieldType` int(11) NULL DEFAULT 0, `createBy` bigint(20) NULL DEFAULT 0, `createTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `updateBy` bigint(20) NULL DEFAULT 0, `updateTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `updateTimeLong` bigint(20) NULL DEFAULT 0, `createTimeLong` bigint(20) NULL DEFAULT 0, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `moorderreceivable${supplyCode}_current`; CREATE TABLE `moorderreceivable${supplyCode}_current` ( `id` bigint(20) NOT NULL DEFAULT 0, `idOrder` bigint(20) NULL DEFAULT 0, `idClient` bigint(20) NULL DEFAULT 0, `clientName` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `billMoney` decimal(18, 4) NULL DEFAULT NULL, `chargeMoney` decimal(18, 4) NULL DEFAULT NULL, `payMoney` decimal(18, 4) NULL DEFAULT NULL, `createMan` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `dataKind` int(11) NULL DEFAULT 0, `chargeState` int(11) NULL DEFAULT 0, `chargeTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `chargeMan` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `financeCode` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `orderYear` int(11) NULL DEFAULT 0, `printBillCode` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `sendDate` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `orderCreateMan` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `orderCreateTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `orderCode` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `maYunCode` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `orderName` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `createBy` bigint(20) NULL DEFAULT 0, `createTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `updateBy` bigint(20) NULL DEFAULT 0, `updateTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `billMemo` varchar(3000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `onlinePayState` int(11) NULL DEFAULT 0, `idPaymentGroup` bigint(20) NULL DEFAULT NULL, `receivableMemo` varchar(${supplyCode}) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `idMemoMan` bigint(20) NULL DEFAULT 0, `memoMan` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `memoDate` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `moorderstep${supplyCode}_current`; CREATE TABLE `moorderstep${supplyCode}_current` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `idOrder` bigint(20) NULL DEFAULT 0, `idWorkMan` bigint(20) NULL DEFAULT 0, `workMan` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `workTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `workTimeLong` bigint(20) NULL DEFAULT 0, `workMemo` varchar(${supplyCode}) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `workExplain` varchar(5000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `moprintorder${supplyCode}_current`; CREATE TABLE `moprintorder${supplyCode}_current` ( `id` bigint(20) NOT NULL DEFAULT 0, `orderCode` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `orderName` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `idProduct` bigint(20) NULL DEFAULT 0, `idClient` bigint(20) NULL DEFAULT 0, `clientName` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `clientCode` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `orderFrom` int(11) NULL DEFAULT 0, `platformOrderID` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `orderMoneyProcess` decimal(18, 4) NULL, `orderMoneyPrint` decimal(18, 4) NULL, `orderMoneyTotal` decimal(18, 4) NULL, `orderMoneySend` decimal(18, 4) NULL, `orderMoneyPre` decimal(18, 4) NULL, `kindCount` int(11) NULL DEFAULT 0, `orderQty` decimal(18, 4) NULL, `payKind` varchar(300) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `orderMemo` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `sendMemo` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `deliverDate` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `voidFlag` int(11) NULL DEFAULT 0, `cutKind` int(11) NULL DEFAULT 0, `printRequire` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `prePrintCode` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `businessKind` int(11) NULL DEFAULT 0, `referenceCode` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `idSale` bigint(20) NULL DEFAULT 0, `saleMan` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `idSaleWorkTeam` bigint(20) NULL DEFAULT 0, `orderMessage` varchar(1500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `fileDescription` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `originFileLink` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `createMan` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `orderType` int(11) NULL DEFAULT 0, `allProcessStr` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `packRequire` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `packKind` int(11) NULL DEFAULT 0, `boxRequire` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `pageQty` int(11) NULL DEFAULT 0, `attachFile` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `attachFileLink` varchar(3000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `proofFile` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `proofFileLink` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `webProofFileLink` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `paperRequireFlag` int(11) NULL DEFAULT 0, `idProductType` bigint(20) NULL DEFAULT 0, `originOrderId` bigint(20) NULL DEFAULT 0, `rePrintIndex` int(11) NULL DEFAULT 0, `rePrintNeedImageProcess` int(11) NULL DEFAULT 0, `firstOrderFlag` int(11) NULL DEFAULT 0, `usePreStore` int(11) NULL DEFAULT 0, `traceFlag` int(11) NULL DEFAULT 0, `dutyMan` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `idClientLevel` bigint(20) NULL DEFAULT 0, `idPaymentGroup` bigint(20) NULL DEFAULT 0, `outSourceProcessStr` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `partCount` int(11) NULL DEFAULT 0, `createBy` bigint(20) NULL DEFAULT 0, `createTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `updateBy` bigint(20) NULL DEFAULT 0, `updateTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `mallOrderStatus` int(11) NULL DEFAULT 0, `createTimeLong` bigint(20) NULL DEFAULT 0, `updateTimeLong` bigint(20) NULL DEFAULT 0, `mallOrderMoneyPay` decimal(18, 4) NULL, `mallOrderMoneyCharge` decimal(18, 4) NULL, `quotememo` varchar(5000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `mallIdPaymentBill` bigint(20) NULL DEFAULT 0, `uploadFileMan` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `uploadFileManPhone` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `checkDateLong` bigint(20) NULL DEFAULT 0, `productSize` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `mallVerifyMan` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', PRIMARY KEY (`id`) USING BTREE, KEY `moPrintOrder_IdClient` (`idClient`) USING BTREE, KEY `moPrintOrder_OrderFrom` (`orderFrom`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `moquoteorder${supplyCode}_current`; CREATE TABLE `moquoteorder${supplyCode}_current` ( `id` bigint(20) NOT NULL DEFAULT 0, `orderCode` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `orderName` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `idProduct` bigint(20) NULL DEFAULT 0, `idClient` bigint(20) NULL DEFAULT 0, `clientName` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `clientCode` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `orderFrom` int(11) NULL DEFAULT 0, `platformOrderID` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `orderMoneyProcess` decimal(18, 4) NULL, `orderMoneyPrint` decimal(18, 4) NULL, `orderMoneyTotal` decimal(18, 4) NULL, `orderMoneySend` decimal(18, 4) NULL, `orderMoneyPre` decimal(18, 4) NULL, `kindCount` int(11) NULL DEFAULT 0, `orderQty` decimal(18, 4) NULL, `payKind` varchar(300) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `orderMemo` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `sendMemo` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `deliverDate` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `voidFlag` int(11) NULL DEFAULT 0, `cutKind` int(11) NULL DEFAULT 0, `printRequire` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `prePrintCode` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `businessKind` int(11) NULL DEFAULT 0, `referenceCode` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `idSale` bigint(20) NULL DEFAULT 0, `saleMan` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `idSaleWorkTeam` bigint(20) NULL DEFAULT 0, `orderMessage` varchar(1500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `fileDescription` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `originFileLink` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `createMan` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `orderType` int(11) NULL DEFAULT 0, `allProcessStr` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `packRequire` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `packKind` int(11) NULL DEFAULT 0, `boxRequire` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `pageQty` int(11) NULL DEFAULT 0, `attachFile` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `attachFileLink` varchar(3000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `proofFile` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `proofFileLink` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `webProofFileLink` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `paperRequireFlag` int(11) NULL DEFAULT 0, `idProductType` bigint(20) NULL DEFAULT 0, `originOrderId` bigint(20) NULL DEFAULT 0, `rePrintIndex` int(11) NULL DEFAULT 0, `rePrintNeedImageProcess` int(11) NULL DEFAULT 0, `firstOrderFlag` int(11) NULL DEFAULT 0, `usePreStore` int(11) NULL DEFAULT 0, `traceFlag` int(11) NULL DEFAULT 0, `dutyMan` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `idClientLevel` bigint(20) NULL DEFAULT 0, `idPaymentGroup` bigint(20) NULL DEFAULT 0, `outSourceProcessStr` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `createBy` bigint(20) NULL DEFAULT 0, `createTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `updateBy` bigint(20) NULL DEFAULT 0, `updateTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `mallOrderStatus` int(11) NULL DEFAULT 0, `createTimeLong` bigint(20) NULL DEFAULT 0, `updateTimeLong` bigint(20) NULL DEFAULT 0, `mallOrderMoneyPay` decimal(18, 4) NULL, `mallOrderMoneyCharge` decimal(18, 4) NULL, `quotememo` varchar(5000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `mallVerifyMan` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', PRIMARY KEY (`id`) USING BTREE, KEY `moQuoteOrder_IdClient` (`idClient`) USING BTREE, KEY `moQuoteOrder_OrderFrom` (`orderFrom`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `tbaccountbalance${supplyCode}`; CREATE TABLE `tbaccountbalance${supplyCode}` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `idAccount` bigint(20) NULL DEFAULT 0, `balanceNum` bigint(20) NULL DEFAULT 0, `qtyPrecise` int(11) NULL DEFAULT 0, `createBy` bigint(20) NULL DEFAULT 0, `createTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `createTimeLong` bigint(20) NULL DEFAULT 0, `updateBy` bigint(20) NULL DEFAULT 0, `updateTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `updateTimeLong` bigint(20) NULL DEFAULT 0, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '科目余额表' ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `tbaccountinfo${supplyCode}`; CREATE TABLE `tbaccountinfo${supplyCode}` ( `id` bigint(20) NOT NULL DEFAULT 0, `accName` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `receiptsFollowFlag` int(11) NULL DEFAULT 0, `voidFlag` int(11) NULL DEFAULT 0, `createBy` bigint(20) NULL DEFAULT 0, `createTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `updateBy` bigint(20) NULL DEFAULT 0, `updateTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `tbaccountperioddata${supplyCode}`; CREATE TABLE `tbaccountperioddata${supplyCode}` ( `id` bigint(20) NOT NULL DEFAULT 0, `beginTime` bigint(20) NULL DEFAULT 0, `endTime` bigint(20) NULL DEFAULT 0, `periodName` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `createBy` bigint(20) NULL DEFAULT 0, `createTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `createTimeLong` bigint(20) NULL DEFAULT 0, `updateBy` bigint(20) NULL DEFAULT 0, `updateTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `updateTimeLong` bigint(20) NULL DEFAULT 0, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; INSERT INTO `tbaccountperioddata${supplyCode}` VALUES (2, 0, 1655450044000, '2022年06月17日', 0, NULL, 0, 0, NULL, 0); DROP TABLE IF EXISTS `tbaccounttradebill${supplyCode}_current`; CREATE TABLE `tbaccounttradebill${supplyCode}_current` ( `id` bigint(20) NOT NULL DEFAULT 0, `billYear` int(11) NULL DEFAULT 0, `idAccount` bigint(20) NULL DEFAULT 0, `idFromAccount` bigint(20) NULL DEFAULT 0, `idToAccount` bigint(20) NULL DEFAULT 0, `qtyPrecise` int(11) NULL DEFAULT 0, `borrowFlag` int(11) NULL DEFAULT 0, `inputNum` bigint(20) NULL DEFAULT 0, `beforeNum` bigint(20) NULL DEFAULT 0, `afterNum` bigint(20) NULL DEFAULT 0, `inputMoney` decimal(18, 4) NULL, `beforeMoney` decimal(18, 4) NULL, `afterMoney` decimal(18, 4) NULL, `verifyDate` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `verifyTime` bigint(20) NULL DEFAULT 0, `idVerifyUser` bigint(20) NULL DEFAULT 0, `verifyUser` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `billMemo` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `createBy` bigint(20) NULL DEFAULT 0, `createTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `createTimeLong` bigint(20) NULL DEFAULT 0, `updateBy` bigint(20) NULL DEFAULT 0, `updateTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `updateTimeLong` bigint(20) NULL DEFAULT 0, `internalFlag` int(11) NULL DEFAULT 0, `billMonth` int(11) NULL DEFAULT 0, `billDay` int(11) NULL DEFAULT 0, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '科目账单表' ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `tbaccountworkbill${supplyCode}_current`; CREATE TABLE `tbaccountworkbill${supplyCode}_current` ( `id` bigint(20) NOT NULL DEFAULT 0, `billKind` bigint(20) NULL DEFAULT 0, `internalFlag` int(11) NULL DEFAULT 0, `billCode` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `srcBillCode` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `idSrcBill` bigint(20) NULL DEFAULT 0, `idSrcBillItem` bigint(20) NULL DEFAULT 0, `idCompany` bigint(20) NULL DEFAULT 0, `companyName` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `companyCode` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `billDate` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `billTimeLong` bigint(20) NULL DEFAULT 0, `billMoney` decimal(18, 4) NULL, `idAccount` bigint(20) NULL DEFAULT 0, `accountName` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `accountBankFlag` int(11) NULL DEFAULT 0, `billMemo` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `voidFlag` int(11) NULL DEFAULT 0, `createBy` bigint(20) NULL DEFAULT 0, `createTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `createTimeLong` bigint(20) NULL DEFAULT 0, `updateBy` bigint(20) NULL DEFAULT 0, `updateTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `updateTimeLong` bigint(20) NULL DEFAULT 0, `voucherCode` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `searchCompanyCode` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `tbannouncement${supplyCode}`; CREATE TABLE `tbannouncement${supplyCode}` ( `id` bigint(20) NOT NULL DEFAULT 0, `idAnnouncementType` bigint(20) NULL DEFAULT 0, `announcementType` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `announcementTitle` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `announcementState` int(11) NULL DEFAULT 0, `voidFlag` int(11) NULL DEFAULT 0, `idReleaseMan` bigint(20) NULL DEFAULT 0, `releaseMan` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `releaseDate` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `createMan` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `createBy` bigint(20) NULL DEFAULT 0, `createTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `updateBy` bigint(20) NULL DEFAULT 0, `updateTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `tbannouncementattachment${supplyCode}`; CREATE TABLE `tbannouncementattachment${supplyCode}` ( `id` bigint(20) NOT NULL DEFAULT 0, `idAnnouncement` bigint(20) NULL DEFAULT 0, `idUser` bigint(20) NULL DEFAULT 0, `userName` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `originName` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `srcFileName` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `fileDescription` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `attachmentUrl` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `downloadUrl` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `sortNum` int(11) NULL DEFAULT 0, `createBy` bigint(20) NULL DEFAULT 0, `createTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `updateBy` bigint(20) NULL DEFAULT 0, `updateTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `tbbusinessbookperiod${supplyCode}`; CREATE TABLE `tbbusinessbookperiod${supplyCode}` ( `id` bigint(20) NOT NULL DEFAULT 0, `bookName` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `beginTimeLong` bigint(20) NULL DEFAULT 0, `endTimeLong` bigint(20) NULL DEFAULT 0, `bookKey` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `bookMemo` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `createMan` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `createBy` bigint(20) NULL DEFAULT 0, `createTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `updateBy` bigint(20) NULL DEFAULT 0, `updateTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; INSERT INTO `tbbusinessbookperiod${supplyCode}` VALUES (2, '2016-01-01 00:00:00->2022-04-18 17:36:02', 1451577600000, 1650274562000, 'eoPrintOrder${supplyCode}_Current+2', '哈哈哈', '系统管理员', 2, '2023-03-31 14:09:06', 2, '2023-03-31 14:09:06'); DROP TABLE IF EXISTS `tbbusinessscript${supplyCode}`; CREATE TABLE `tbbusinessscript${supplyCode}` ( `id` bigint(20) NOT NULL, `businessName` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `businessCode` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `voidFlag` int(11) NULL DEFAULT NULL, `createBy` bigint(20) NULL DEFAULT NULL, `createTime` datetime(0) NULL DEFAULT NULL, `updateBy` bigint(20) NULL DEFAULT NULL, `updateTime` datetime(0) NULL DEFAULT NULL, `businessModule` int(4) NULL DEFAULT 0, `systemFlag` int(4) NULL DEFAULT 0, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `tbclientbalance${supplyCode}`; CREATE TABLE `tbclientbalance${supplyCode}` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `idClient` bigint(20) NULL DEFAULT 0, `balanceNum` bigint(20) NULL DEFAULT 0, `createBy` bigint(20) NULL DEFAULT 0, `createTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `createTimeLong` bigint(20) NULL DEFAULT 0, `updateBy` bigint(20) NULL DEFAULT 0, `updateTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `updateTimeLong` bigint(20) NULL DEFAULT 0, `userKind` int(11) NULL DEFAULT 0, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 132 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '客户余额表' ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `tbclientsavemoney${supplyCode}`; CREATE TABLE `tbclientsavemoney${supplyCode}` ( `id` bigint(20) NOT NULL, `idClient` bigint(20) NULL DEFAULT 0, `clientName` varchar(300) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `idAccount` bigint(20) NULL DEFAULT 0, `accountName` varchar(300) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `saveMoney` decimal(18, 4) NULL, `voucherCode` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `saveMemo` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `borrowFlag` int(11) NULL DEFAULT 0, `receiveCode` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `createBy` bigint(20) NULL DEFAULT 0, `createTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `createTimeLong` bigint(20) NULL DEFAULT 0, `updateBy` bigint(20) NULL DEFAULT 0, `updateTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `updateTimeLong` bigint(20) NULL DEFAULT 0, `userKind` int(11) NULL DEFAULT 0, `moneyFrom` int(11) NULL DEFAULT 0, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '客户充值记录表' ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `tbcompanyinfo${supplyCode}`; CREATE TABLE `tbcompanyinfo${supplyCode}` ( `id` bigint(20) NOT NULL, `companyName` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `address` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `linkMan` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `linkPhone` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `voidFlag` int(11) NULL DEFAULT NULL, `createBy` bigint(20) NULL DEFAULT NULL, `createTime` datetime(0) NULL DEFAULT NULL, `createTimeLong` bigint(20) NULL DEFAULT NULL, `updateBy` bigint(20) NULL DEFAULT NULL, `updateTime` datetime(0) NULL DEFAULT NULL, `updateTimeLong` bigint(20) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '分厂信息' ROW_FORMAT = Dynamic; INSERT INTO `tbcompanyinfo${supplyCode}` VALUES (2, '工厂', 'ZZ', '张', '138', 0, 2, '2021-07-09 15:02:16', 1625814135525, 2, '2021-07-09 15:02:16', 1625814135525); DROP TABLE IF EXISTS `tbconfigvalue${supplyCode}`; CREATE TABLE `tbconfigvalue${supplyCode}` ( `configKey` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `configName` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `configValue1` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '', `configValue2` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `configValue3` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `configType` smallint(6) NULL DEFAULT NULL, `configModule` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `remark` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL, PRIMARY KEY (`configKey`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; INSERT INTO `tbconfigvalue${supplyCode}` VALUES ('generalWorkProcess', '常规工艺：拼版、打版、白料、印刷', '2,3,4,5', NULL, NULL, 1, NULL, '拼版2、打版3、白料4、印刷5'); INSERT INTO `tbconfigvalue${supplyCode}` VALUES ('OrderDownloadServer', '内网外网下载配置', 'https://images.yinjieai.com/', 'https://images.yinjieai.com/', NULL, 1, NULL, NULL); INSERT INTO `tbconfigvalue${supplyCode}` VALUES ('pdfErrorRange', '单页 PDF文件与订单部件允许的误差范围', '5', NULL, NULL, 1, NULL, NULL); INSERT INTO `tbconfigvalue${supplyCode}` VALUES ('PrintProcessId', '印刷工序id', '7', NULL, NULL, 1, NULL, '印刷工序id'); INSERT INTO `tbconfigvalue${supplyCode}` VALUES ('productCenterCallClientInfo', '产品中心客户信息', '', '', '', 1, '', ''); INSERT INTO `tbconfigvalue${supplyCode}` VALUES ('SiteAddress', '', '', '', '', 0, NULL, NULL); INSERT INTO `tbconfigvalue${supplyCode}` VALUES ('SiteCopyRight', '', '', '', '', 0, NULL, NULL); INSERT INTO `tbconfigvalue${supplyCode}` VALUES ('SiteICP', '', '', '', '', 0, NULL, NULL); INSERT INTO `tbconfigvalue${supplyCode}` VALUES ('SiteName', '', '', '', '', 0, NULL, NULL); INSERT INTO `tbconfigvalue${supplyCode}` VALUES ('SitePhone', '', '', '', '', 0, NULL, NULL); INSERT INTO `tbconfigvalue${supplyCode}` VALUES ('SiteTime', '', '', '', '', 0, NULL, NULL); INSERT INTO `tbconfigvalue${supplyCode}` VALUES ('SYSTEM_VERSION', '版本区分配置', 'xx', NULL, NULL, 0, NULL, NULL); INSERT INTO `tbconfigvalue${supplyCode}` VALUES ('WebSocketServer', '网页通信WebSocket服务地址', 'ws://demo.admin.yinjieai.com/wsapp/ws/aws', NULL, NULL, 1, NULL, '网页通信WebSocket服务地址'); DROP TABLE IF EXISTS `tbdatapurview${supplyCode}`; CREATE TABLE `tbdatapurview${supplyCode}` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `idUser` bigint(20) NULL DEFAULT 0, `userName` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `idCreateUser` bigint(20) NULL DEFAULT 0, `createUserName` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `idData` bigint(20) NULL DEFAULT 0, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '数据权限表' ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `tbdept${supplyCode}`; CREATE TABLE `tbdept${supplyCode}` ( `id` bigint(20) NOT NULL, `parentId` bigint(20) NULL DEFAULT NULL, `deptName` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `deptCode` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `sortNum` bigint(20) NULL DEFAULT NULL, `leader` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `phone` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `email` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `status` int(11) NULL DEFAULT NULL, `parentName` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `createBy` bigint(20) NULL DEFAULT NULL, `createTime` datetime(0) NULL DEFAULT NULL, `createTimeLong` bigint(20) NULL DEFAULT NULL, `updateBy` bigint(20) NULL DEFAULT NULL, `updateTime` datetime(0) NULL DEFAULT NULL, `updateTimeLong` bigint(20) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; INSERT INTO `tbdept${supplyCode}` VALUES (2, 0, '技术支持部', NULL, 999, 'tt', NULL, NULL, 0, NULL, -999, '2021-07-09 10:47:27', 1625798847304, -999, '2021-07-09 13:24:01', 1625808240649); DROP TABLE IF EXISTS `tbdictdata${supplyCode}`; CREATE TABLE `tbdictdata${supplyCode}` ( `id` bigint(20) NOT NULL, `idType` bigint(20) NULL DEFAULT NULL, `dictLabel` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `dictValue` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `sortNum` int(11) NULL DEFAULT NULL, `cssClass` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `listClass` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `voidFlag` int(11) NULL DEFAULT NULL, `remark` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL, `createBy` bigint(20) NULL DEFAULT NULL, `createTime` datetime(0) NULL DEFAULT NULL, `updateBy` bigint(20) NULL DEFAULT NULL, `updateTime` datetime(0) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `tbdicttype${supplyCode}`; CREATE TABLE `tbdicttype${supplyCode}` ( `id` bigint(20) NOT NULL, `dictName` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `dictType` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `voidFlag` int(11) NULL DEFAULT NULL, `remark` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL, `createBy` bigint(20) NULL DEFAULT NULL, `createTime` datetime(0) NULL DEFAULT NULL, `updateBy` bigint(20) NULL DEFAULT NULL, `updateTime` datetime(0) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `tberpuploadfile${supplyCode}`; CREATE TABLE `tberpuploadfile${supplyCode}` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `idUser` bigint(20) NULL DEFAULT NULL, `userName` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `fileKind` int(11) NULL DEFAULT NULL, `srcFileName` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `fileDescription` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `downloadUrl` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `createBy` bigint(20) NULL DEFAULT NULL, `createTime` datetime(0) NULL DEFAULT NULL, `createTimeLong` bigint(20) NULL DEFAULT NULL, `updateBy` bigint(20) NULL DEFAULT NULL, `updateTime` datetime(0) NULL DEFAULT NULL, `updateTimeLong` bigint(20) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `tbfinanceaccount${supplyCode}`; CREATE TABLE `tbfinanceaccount${supplyCode}` ( `id` bigint(20) NOT NULL DEFAULT 0, `idCompany` bigint(20) NULL DEFAULT 0, `accountName` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `accountCode` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `accountKind` int(11) NULL DEFAULT 0, `receiptsFollowFlag` int(11) NULL DEFAULT 0, `systemFlag` int(11) NULL DEFAULT 0, `voidFlag` int(11) NULL DEFAULT 0, `createBy` bigint(20) NULL DEFAULT 0, `createTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `createTimeLong` bigint(20) NULL DEFAULT 0, `updateBy` bigint(20) NULL DEFAULT 0, `updateTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `updateTimeLong` bigint(20) NULL DEFAULT 0, `bankFlag` int(11) NULL DEFAULT 0, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '科目档案' ROW_FORMAT = Dynamic; INSERT INTO `tbfinanceaccount${supplyCode}` VALUES (2, 0, '预存冲抵', '9999', 0, 0, 0, 0, 2, '2021-07-09 14:46:21', 1625813180557, 2, '2021-07-09 14:50:07', 1625813406797, 0); INSERT INTO `tbfinanceaccount${supplyCode}` VALUES (4, 0, '在线银联-电商管家', '1001', 0, 1, 0, 0, 2, '2021-10-06 15:37:09', 1633505829459, 2, '2021-11-17 14:54:38', 1637132078256, 1); INSERT INTO `tbfinanceaccount${supplyCode}` VALUES (5, 0, '在线支付宝', '1002', 0, 1, 0, 0, 2, '2021-10-06 15:37:39', 1633505859498, 2, '2021-11-17 14:54:36', 1637132075912, 1); INSERT INTO `tbfinanceaccount${supplyCode}` VALUES (6, 0, '在线微信', '1003', 0, 1, 0, 0, 2, '2021-10-06 15:37:49', 1633505869084, 2, '2021-11-17 14:54:34', 1637132073600, 1); INSERT INTO `tbfinanceaccount${supplyCode}` VALUES (7, 0, '客户预存款', '1008', 0, 0, 0, 0, 366, '2021-10-17 14:54:54', 1634453693760, 366, '2021-10-17 14:59:29', 1634453968741, 0); INSERT INTO `tbfinanceaccount${supplyCode}` VALUES (8, 0, '订单优惠', '1009', 0, 0, 0, 0, 366, '2021-10-17 14:55:51', 1634453750603, 366, '2021-10-17 15:00:44', 1634454043733, 0); INSERT INTO `tbfinanceaccount${supplyCode}` VALUES (9, 0, '物流代收', '1010', 0, 0, 0, 0, 366, '2021-10-17 14:56:04', 1634453763768, 366, '2021-10-17 15:00:52', 1634454051700, 0); INSERT INTO `tbfinanceaccount${supplyCode}` VALUES (10, 0, '客户预存A收据', '1012', 0, 0, 0, 0, 44, '2021-10-25 10:50:05', 1635130204936, 44, '2021-10-25 10:50:05', 1635130204936, 0); INSERT INTO `tbfinanceaccount${supplyCode}` VALUES (11, 0, '网站对接', '1004', 0, 0, 0, 0, 2, '2022-09-20 12:02:03', 1663646523322, 2, '2022-09-20 12:02:03', 1663646523322, 0); DROP TABLE IF EXISTS `tblogisticsinfo${supplyCode}`; CREATE TABLE `tblogisticsinfo${supplyCode}` ( `id` bigint(20) NOT NULL, `idLogisticType` bigint(20) NULL DEFAULT 0, `logisticTypeName` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '', `idShipArea` bigint(20) NULL DEFAULT 0, `shipArea` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '', `logisticCode` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '', `logisticName` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '', `contactMan` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '', `contactPhone` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '', `carNumber` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '', `voidFlag` int(11) NULL DEFAULT 0, `quoteScriptUrl` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '', `createBy` bigint(20) NULL DEFAULT 0, `createTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `updateBy` bigint(20) NULL DEFAULT 0, `updateTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `idProductRoom` bigint(20) NULL DEFAULT 0, `quotePriceFlag` int(11) NULL DEFAULT 0, `expressInvokeCode` varchar(50) NULL DEFAULT '', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `tbmenu${supplyCode}`; CREATE TABLE `tbmenu${supplyCode}` ( `id` bigint(20) NOT NULL, `menuName` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `parentId` bigint(20) NULL DEFAULT NULL, `sortNum` int(11) NULL DEFAULT NULL, `url` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `menuType` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `visible` smallint(6) NULL DEFAULT NULL, `perms` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `icon` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `createBy` bigint(20) NULL DEFAULT NULL, `createTime` datetime(0) NULL DEFAULT NULL, `updateBy` bigint(20) NULL DEFAULT NULL, `updateTime` datetime(0) NULL DEFAULT NULL, `remark` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL, `route` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '', `runKind` int(11) NULL DEFAULT 0, `delphiPackage` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '', `delphiParams` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '', `delphiRunKind` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '', `delphiRunForm` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '', `delphiFormShow` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '', `cacheFlag` int(11) NULL DEFAULT 0, `pathName` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; INSERT INTO `tbmenu${supplyCode}` VALUES (2, '系统管理', 0, 1, NULL, 'M', 1, 'siteInfo', 'system', 2, '2024-01-20 11:38:17', 2, '2024-01-22 09:40:53', NULL, '/system', 0, NULL, NULL, NULL, NULL, NULL, 0, ''); INSERT INTO `tbmenu${supplyCode}` VALUES (3, '菜单管理', 2, 1, 'system/menu/index', 'C', 1, NULL, '', 2, '2024-01-20 11:55:14', 2, '2024-01-24 10:41:54', NULL, 'menu', 0, NULL, NULL, NULL, NULL, NULL, 1, 'Menu'); INSERT INTO `tbmenu${supplyCode}` VALUES (4, '增加', 3, 2, 'system/role/index', 'F', 1, 'add', '', 2, '2024-01-20 17:14:07', 2, '2024-01-20 18:17:45', NULL, 'add', 0, NULL, NULL, NULL, NULL, NULL, 0, ''); INSERT INTO `tbmenu${supplyCode}` VALUES (5, '角色管理', 2, 2, 'system/role/index', 'C', 1, NULL, '', 2, '2024-01-20 17:15:10', 2, '2024-01-23 16:25:57', NULL, 'role', 0, NULL, NULL, NULL, NULL, NULL, 1, 'Role'); INSERT INTO `tbmenu${supplyCode}` VALUES (6, '部门管理', 2, 3, 'system/dept/index', 'C', 1, '', '', 2, '2024-01-20 17:20:08', 2, '2024-01-20 17:20:08', NULL, 'dept', 0, '', '', NULL, NULL, NULL, 0, ''); INSERT INTO `tbmenu${supplyCode}` VALUES (7, '用户管理', 2, 4, 'system/user/index', 'C', 1, NULL, '', 2, '2024-01-20 17:20:51', 2, '2024-01-20 17:29:05', NULL, 'user', 0, NULL, NULL, NULL, NULL, NULL, 0, ''); INSERT INTO `tbmenu${supplyCode}` VALUES (8, '编辑', 3, 1, NULL, 'F', 1, '#', '', 2, '2024-01-20 18:10:49', 2, '2024-01-20 18:18:03', NULL, '#', 0, NULL, NULL, NULL, NULL, NULL, 0, ''); INSERT INTO `tbmenu${supplyCode}` VALUES (9, '基础档案管理', 0, 2, '', 'M', 1, '', 'redis', 2, '2024-01-21 12:56:31', 2, '2024-01-21 12:56:31', NULL, '/baseInfo', 0, '', '', NULL, NULL, NULL, 0, ''); INSERT INTO `tbmenu${supplyCode}` VALUES (11, '产品档案', 0, 3, NULL, 'M', 1, NULL, 'menu', 2, '2024-01-21 13:05:34', 2, '2024-02-29 10:16:37', NULL, '/product', 0, NULL, NULL, NULL, NULL, NULL, 0, ''); INSERT INTO `tbmenu${supplyCode}` VALUES (12, '产品列表', 11, 1, 'product/productList/index', 'C', 1, NULL, '', 2, '2024-01-21 13:06:51', 2, '2024-05-06 17:02:38', NULL, 'productList', 0, NULL, NULL, NULL, NULL, NULL, 1, 'ProductList'); INSERT INTO `tbmenu${supplyCode}` VALUES (13, '订单管理', 0, 4, NULL, 'M', 1, NULL, 'table', 2, '2024-01-21 13:15:56', 2, '2024-01-22 09:40:58', NULL, '/order', 0, NULL, NULL, NULL, NULL, NULL, 0, ''); INSERT INTO `tbmenu${supplyCode}` VALUES (14, '订单列表', 13, 1, 'order/orderList/index', 'C', 1, NULL, '', 2, '2024-01-21 13:16:32', 2, '2024-01-21 13:24:13', NULL, 'orderList', 0, NULL, NULL, NULL, NULL, NULL, 0, ''); INSERT INTO `tbmenu${supplyCode}` VALUES (15, '系统设置', 2, 5, 'system/config/index', 'C', 1, '', '', 2, '2024-01-21 13:37:29', 2, '2024-01-21 13:37:29', NULL, 'config', 0, '', '', NULL, NULL, NULL, 0, ''); INSERT INTO `tbmenu${supplyCode}` VALUES (16, '产品脚本报价', 12, 9, 'product/priceScript/index', 'C', 0, NULL, '', 2, '2024-01-22 10:20:06', 2, '2024-01-22 13:19:59', NULL, 'priceScript/:id', 0, NULL, NULL, NULL, NULL, NULL, 1, ''); INSERT INTO `tbmenu${supplyCode}` VALUES (17, '部件列表', 12, 99, 'product/partInfo/index', 'C', 0, NULL, '', 2, '2024-01-22 16:11:11', 2, '2024-01-22 16:56:32', NULL, 'partInfo/:id', 0, NULL, NULL, NULL, NULL, NULL, 1, ''); INSERT INTO `tbmenu${supplyCode}` VALUES (18, '报价参数', 12, 99, 'product/parseInfo/index', 'C', 0, NULL, '', 2, '2024-01-22 16:44:50', 2, '2024-01-22 16:56:38', NULL, 'parseInfo/:id', 0, NULL, NULL, NULL, NULL, NULL, 1, ''); INSERT INTO `tbmenu${supplyCode}` VALUES (19, '部件参数列表', 12, 99, 'product/partInfo/parameterList/index', 'C', 0, NULL, '', 2, '2024-01-24 10:02:24', 2, '2024-01-24 10:53:31', NULL, 'parameterList/:id', 0, NULL, NULL, NULL, NULL, NULL, 1, 'ParameterList'); INSERT INTO `tbmenu${supplyCode}` VALUES (20, '部件工序列表', 12, 99, 'product/partInfo/processList/index', 'C', 0, NULL, '', 2, '2024-01-24 10:06:28', 2, '2024-01-24 10:53:36', NULL, 'processList/:id', 0, NULL, NULL, NULL, NULL, NULL, 1, 'ProcessList'); INSERT INTO `tbmenu${supplyCode}` VALUES (21, '部件参数值', 12, 99, 'product/partInfo/parameterChild/index', 'C', 0, NULL, '', 2, '2024-01-24 11:03:29', 2, '2024-01-24 11:59:57', NULL, 'parameterChild/:id', 0, NULL, NULL, NULL, NULL, NULL, 1, 'ParameterChild'); INSERT INTO `tbmenu${supplyCode}` VALUES (22, '产品报价', 11, 99, 'product/productDetail/index', 'C', 0, NULL, '', 2, '2024-01-25 08:53:46', 2, '2024-01-25 09:01:58', NULL, 'productDetail/:id', 0, NULL, NULL, NULL, NULL, NULL, 0, 'ProductDetail'); INSERT INTO `tbmenu${supplyCode}` VALUES (23, '产品分类档案', 11, 2, 'product/productType/index', 'C', 1, '', '', 2, '2024-01-26 08:44:25', 2, '2024-01-26 08:44:25', NULL, 'productType', 0, '', '', NULL, NULL, NULL, 0, 'ProductType'); INSERT INTO `tbmenu${supplyCode}` VALUES (24, '工序档案', 11, 3, 'product/workProcess/index', 'C', 1, '', '', 2, '2024-01-26 08:45:30', 2, '2024-01-26 08:45:30', NULL, 'workProcess', 0, '', '', NULL, NULL, NULL, 0, 'WorkProcess'); INSERT INTO `tbmenu${supplyCode}` VALUES (25, '产品参数档案', 11, 4, 'product/productParameter/index', 'C', 1, '', '', 2, '2024-01-26 08:47:19', 2, '2024-01-26 08:47:19', NULL, 'productParameter', 0, '', '', NULL, NULL, NULL, 0, 'ProductParameter'); INSERT INTO `tbmenu${supplyCode}` VALUES (27, '加载脚本管理', 2, 51, 'system/loadScript/index', 'C', 1, NULL, '', 2, '2024-01-26 11:14:53', 2, '2024-01-26 11:16:23', NULL, 'loadScript', 0, NULL, NULL, NULL, NULL, NULL, 0, 'LoadScript'); INSERT INTO `tbmenu${supplyCode}` VALUES (28, '业务脚本管理', 2, 52, 'system/businessScript/index', 'C', 1, '', '', 2, '2024-01-26 11:15:56', 2, '2024-01-26 11:15:56', NULL, 'businessScript', 0, '', '', NULL, NULL, NULL, 0, 'BusinessScript'); INSERT INTO `tbmenu${supplyCode}` VALUES (29, '管理员权限:执行脚本', 27, 1, '', 'F', 0, 'admin:exec:script', '', 2, '2024-01-26 11:29:37', 2, '2024-01-26 11:31:29', NULL, '', 0, '', '', NULL, NULL, NULL, 0, ''); INSERT INTO `tbmenu${supplyCode}` VALUES (30, '管理员权限:加载脚本', 27, 2, '', 'F', 0, 'admin:query:loadscripts', '', 2, '2024-01-26 11:32:09', 2, '2024-01-26 11:32:32', NULL, '', 0, '', '', NULL, NULL, NULL, 0, ''); INSERT INTO `tbmenu${supplyCode}` VALUES (31, '业务脚本内容', 28, 53, 'system/scriptCode/index', 'C', 0, NULL, '', 2, '2024-01-26 14:44:12', 2, '2024-01-26 16:20:39', NULL, 'scriptCode/:id', 0, NULL, NULL, NULL, NULL, NULL, 0, 'ScriptCode'); INSERT INTO `tbmenu${supplyCode}` VALUES (46, '单据定义列表', 9, 15, 'baseInfo/defineList/index', 'C', 1, NULL, '', 2, '2024-01-27 09:12:48', 2, '2024-02-29 10:13:43', NULL, 'defineList', 0, NULL, NULL, NULL, NULL, NULL, 0, 'DefineList'); INSERT INTO `tbmenu${supplyCode}` VALUES (47, '查询统计列表', 9, 16, 'baseInfo/inquireMainInfo/index', 'C', 1, '', '', 2, '2024-01-27 09:15:18', 2, '2024-02-29 10:13:50', NULL, 'inquireMainInfo', 0, '', '', NULL, NULL, NULL, 0, ''); INSERT INTO `tbmenu${supplyCode}` VALUES (53, '字典管理', 2, 6, 'system/dictType/index', 'C', 1, '', '', 2, '2024-02-27 17:16:15', 2, '2024-02-28 10:49:01', NULL, 'dictType', 0, '', '', NULL, NULL, NULL, 0, 'DictType'); INSERT INTO `tbmenu${supplyCode}` VALUES (54, '字典数据', 2, 99, 'system/dictData/index', 'C', 0, '', '', 2, '2024-02-28 10:11:09', 2, '2024-02-28 10:49:08', NULL, 'dictData/:id', 0, '', '', NULL, NULL, NULL, 0, 'DictData'); INSERT INTO `tbmenu${supplyCode}` VALUES (55, '日志管理', 2, 7, '', 'C', 1, '', '', 2, '2024-02-28 16:15:32', 2, '2024-02-28 16:15:32', NULL, 'log', 0, '', '', NULL, NULL, NULL, 0, 'Log'); INSERT INTO `tbmenu${supplyCode}` VALUES (56, '操作日志', 55, 1, 'system/log/operlog/index', 'C', 1, '', '', 2, '2024-02-28 16:22:54', 2, '2024-02-28 16:22:54', NULL, 'operlog', 0, '', '', NULL, NULL, NULL, 0, 'Operlog'); INSERT INTO `tbmenu${supplyCode}` VALUES (57, '登录日志', 55, 2, 'system/log/loginLog/index', 'C', 0, NULL, '', 2, '2024-02-28 16:25:00', 2, '2024-02-29 10:23:51', NULL, 'loginLog', 0, NULL, NULL, NULL, NULL, NULL, 0, 'LoginLog'); INSERT INTO `tbmenu${supplyCode}` VALUES (58, '客户管理', 0, 5, NULL, 'M', 1, NULL, 'peoples', 2, '2024-02-29 16:13:16', 2, '2024-02-29 16:13:35', NULL, '/client', 0, NULL, NULL, NULL, NULL, NULL, 0, NULL); INSERT INTO `tbmenu${supplyCode}` VALUES (59, '客户列表', 58, 1, 'client/clientList/index', 'C', 1, NULL, '', 2, '2024-02-29 16:15:02', 2, '2024-03-22 14:58:50', NULL, 'clientList', 0, NULL, NULL, NULL, NULL, NULL, 0, 'ClientList'); INSERT INTO `tbmenu${supplyCode}` VALUES (61, '客户等级列表', 58, 3, 'client/level/index', 'C', 1, '', '', 2, '2024-02-29 16:19:53', 2, '2024-02-29 16:19:53', NULL, 'level', 0, '', '', NULL, NULL, NULL, 0, ''); INSERT INTO `tbmenu${supplyCode}` VALUES (64, '物流档案', 9, 6, 'client/logistics/index', 'C', 1, '', '', 2, '2024-02-29 16:25:14', 2, '2024-02-29 16:25:14', NULL, 'logistics', 0, '', '', NULL, NULL, NULL, 0, ''); INSERT INTO `tbmenu${supplyCode}` VALUES (65, '产品报价下单', 11, 1, 'product/productPricing/index', 'C', 1, NULL, '', 2, '2024-03-13 09:55:51', 2, '2024-03-25 15:51:08', NULL, 'productPricing/:id', 0, NULL, NULL, NULL, NULL, NULL, 0, NULL); INSERT INTO `tbmenu${supplyCode}` VALUES (67, '同步产品档案', 12, 99, 'product/productDownload/index', 'C', 0, NULL, '', 2, '2024-03-25 17:41:15', 2, '2024-03-25 18:31:09', NULL, 'productDownload', 0, NULL, NULL, NULL, NULL, NULL, 0, NULL); INSERT INTO `tbmenu${supplyCode}` VALUES (68, '同步产品参数', 12, 99, 'product/parameterDownload/index', 'C', 0, NULL, '', 2, '2024-03-25 17:45:01', 2, '2024-03-25 18:31:25', NULL, 'parameterDownload', 0, NULL, NULL, NULL, NULL, NULL, 0, NULL); INSERT INTO `tbmenu${supplyCode}` VALUES (69, '产品图片', 11, 99, 'product/productImg/index', 'C', 1, NULL, '', 2, '2024-03-29 09:35:38', 2, '2024-03-29 09:35:56', NULL, 'productImg/:id', 0, NULL, NULL, NULL, NULL, NULL, 0, 'productImg'); INSERT INTO `tbmenu${supplyCode}` VALUES (70, '网站资料设置', 2, 5, 'system/webInfo/index', 'C', 1, '', '', 2, '2024-03-29 13:49:14', 2, '2024-03-29 13:49:14', NULL, 'webInfo', 0, '', '', NULL, NULL, NULL, 0, 'webInfo'); INSERT INTO `tbmenu${supplyCode}` VALUES (71, '广告位图片管理', 2, 5, 'system/adimg/index', 'C', 1, '', '', 2, '2024-04-03 08:09:19', 2, '2024-04-03 08:09:19', NULL, 'adimg', 0, '', '', NULL, NULL, NULL, 0, 'adimg'); INSERT INTO `tbmenu${supplyCode}` VALUES (72, '商城纸张档案管理', 2, 5, 'system/paperList/index', 'C', 1, '', '', 2, '2024-04-09 13:23:12', 2, '2024-04-09 13:23:12', NULL, 'paperList', 0, '', '', NULL, NULL, NULL, 0, 'paperList'); INSERT INTO `tbmenu${supplyCode}` VALUES (73, '产品介绍', 12, 99, 'product/productInfo/index', 'C', 0, NULL, '', 2, '2024-04-09 13:56:20', 2, '2024-04-09 14:02:59', NULL, 'productInfo/:id', 0, NULL, NULL, NULL, NULL, NULL, 0, 'productInfo'); INSERT INTO `tbmenu${supplyCode}` VALUES (95, '产品介绍列表', 12, 99, 'product/infoList/index', 'C', 0, NULL, '', 2, '2024-04-09 13:56:20', 2, '2024-04-09 14:02:59', NULL, 'infoList/:id', 0, NULL, NULL, NULL, NULL, NULL, 0, ''); INSERT INTO `tbmenu${supplyCode}` VALUES (94, '参数示例图片', 12, 99, 'product/exampleList/index', 'C', 0, NULL, '', 2, '2024-04-09 13:56:20', 2, '2024-04-09 14:02:59', NULL, 'exampleList/:id', 0, NULL, NULL, NULL, NULL, NULL, 0, 'productInfo'); INSERT INTO `tbmenu${supplyCode}` VALUES (74, '物流档案', 9, 5, 'system/logistics/index', 'C', 1, '', '', 2, '2024-04-16 10:44:54', 2, '2024-04-16 10:44:54', NULL, 'logistics', 0, '', '', NULL, NULL, NULL, 0, 'logistics'); INSERT INTO `tbmenu${supplyCode}` VALUES (96, '自提地址管理', 9, 5, 'baseInfo/selfAddress/index', 'C', 1, '', '', 2, '2024-04-16 10:44:54', 2, '2024-04-16 10:44:54', NULL, 'selfAddress', 0, '', '', NULL, NULL, NULL, 0, ''); INSERT INTO `tbmenu${supplyCode}` VALUES (91, '物流报价脚本', 74, 54, 'system/logisticsScript/index', 'C', 0, NULL, '', 2, '2024-01-22 16:44:50', 2, '2024-01-22 16:56:38', NULL, 'logisticsScript/:id', 0, NULL, NULL, NULL, NULL, NULL, 0, ''); INSERT INTO `tbmenu${supplyCode}` VALUES (92, '物流报价参数', 74, 55, 'system/logisticsInfo/index', 'C', 0, NULL, '', 2, '2024-01-22 16:44:50', 2, '2024-01-22 16:56:38', NULL, 'logisticsInfo/:id', 0, NULL, NULL, NULL, NULL, NULL, 0, ''); INSERT INTO `tbmenu${supplyCode}` VALUES (75, '网站内容管理', 2, 5, 'system/contentList/index', 'C', 1, '', '', 2, '2024-04-16 11:42:52', 2, '2024-04-16 11:42:52', NULL, 'contentList', 0, '', '', NULL, NULL, NULL, 0, 'contentList'); INSERT INTO `tbmenu${supplyCode}` VALUES (76, '内容详情', 2, 99, 'system/contentList/compt/contentDetail', 'C', 1, '', '', 2, '2024-04-16 11:53:51', 2, '2024-04-16 11:53:51', NULL, 'contentDetail/:id', 0, '', '', NULL, NULL, NULL, 0, 'contentDetail'); INSERT INTO `tbmenu${supplyCode}` VALUES (77, '待支付', 13, 2, 'order/paidList/index', 'C', 1, '', '', 2, '2024-04-17 10:54:41', 2, '2024-04-17 10:54:41', NULL, 'paidList', 0, '', '', NULL, NULL, NULL, 0, 'paidList'); INSERT INTO `tbmenu${supplyCode}` VALUES (78, '待发货', 13, 3, 'order/sendList/index', 'C', 1, '', '', 2, '2024-04-17 10:56:03', 2, '2024-04-17 10:56:03', NULL, 'sendList', 0, '', '', NULL, NULL, NULL, 0, 'sendList'); INSERT INTO `tbmenu${supplyCode}` VALUES (79, '已发货', 13, 4, 'order/sendfinishList/index', 'C', 1, '', '', 2, '2024-04-17 10:57:31', 2, '2024-04-17 10:57:31', NULL, 'sendfinishList', 0, '', '', NULL, NULL, NULL, 0, 'sendfinishList'); INSERT INTO `tbmenu${supplyCode}` VALUES (80, '已取消', 13, 5, 'order/canceledList/index', 'C', 1, '', '', 2, '2024-04-17 10:58:40', 2, '2024-04-17 10:58:40', NULL, 'canceledList', 0, '', '', NULL, NULL, NULL, 0, 'canceledList'); INSERT INTO `tbmenu${supplyCode}` VALUES (81, '增加后台人员权限', 7, 99, '', 'F', 1, 'system:user:add', '', 2, '2024-04-28 10:58:10', 2, '2024-04-28 13:59:00', NULL, '', 0, '', '', NULL, NULL, NULL, 0, ''); INSERT INTO `tbmenu${supplyCode}` VALUES (82, '修改后台管理人员权限', 7, 99, '', 'F', 1, 'system:user:edit', '', 2, '2024-04-28 11:05:35', 2, '2024-04-28 13:59:15', NULL, '', 0, '', '', NULL, NULL, NULL, 0, ''); INSERT INTO `tbmenu${supplyCode}` VALUES (83, '重置管理人员密码权限', 7, 99, '', 'F', 1, 'system:user:resetPwd', '', 2, '2024-04-28 11:08:11', 2, '2024-04-28 13:59:49', NULL, '', 0, '', '', NULL, NULL, NULL, 0, ''); INSERT INTO `tbmenu${supplyCode}` VALUES (84, '禁用后台管理人员权限', 7, 99, '', 'F', 1, 'system:user:remove', '', 2, '2024-04-28 11:10:03', 2, '2024-04-28 14:00:16', NULL, '', 0, '', '', NULL, NULL, NULL, 0, ''); INSERT INTO `tbmenu${supplyCode}` VALUES (85, '退款管理', 0, 6, '', 'M', 1, '', 'close_left', 2, '2024-04-30 09:07:08', 2, '2024-04-30 09:11:06', NULL, '/refund', 0, '', '', NULL, NULL, NULL, 0, ''); INSERT INTO `tbmenu${supplyCode}` VALUES (86, '退款订单管理', 85, 1, 'refund/refundOrder/index', 'C', 1, '', '', 2, '2024-04-30 09:09:36', 2, '2024-04-30 09:09:36', NULL, 'refundOrder', 0, '', '', NULL, NULL, NULL, 0, 'refundOrder'); INSERT INTO `tbmenu${supplyCode}` VALUES (87, '代客充值权限', 58, 99, '', 'F', 1, 'mallUser:money:Recharge', '', 2, '2024-04-30 10:08:06', 2, '2024-04-30 10:08:06', NULL, '', 0, '', '', NULL, NULL, NULL, 0, ''); INSERT INTO `tbmenu${supplyCode}` VALUES (88, '报价记录', 13, 6, 'order/quoteList/index', 'C', 1, '', '', 2, '2024-04-30 11:44:42', 2, '2024-04-30 11:44:42', NULL, 'quoteList', 0, '', '', NULL, NULL, NULL, 0, 'quoteList'); INSERT INTO `tbmenu${supplyCode}` VALUES (89, '充值记录', 58, 7, 'client/rechargeList/index', 'C', 1, '', '', 2, '2024-04-30 11:50:24', 2, '2024-04-30 11:59:28', NULL, 'rechargeList', 0, '', '', NULL, NULL, NULL, 0, 'rechargeList'); INSERT INTO `tbmenu${supplyCode}` VALUES (90, '修改密码', 2, 5, 'system/changePassword/index', 'C', 1, '', '', 2, '2024-04-30 18:43:23', 2, '2024-04-30 18:43:23', NULL, 'changePassword', 0, '', '', NULL, NULL, NULL, 0, 'changePassword'); DROP TABLE IF EXISTS `tbnoticemessage${supplyCode}`; CREATE TABLE `tbnoticemessage${supplyCode}` ( `id` bigint(20) NOT NULL DEFAULT 0, `messageCode` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `messageName` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `messageKind` int(11) NULL DEFAULT 0, `voidFlag` int(11) NULL DEFAULT 0, `createBy` bigint(20) NULL DEFAULT 0, `createTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `createTimeLong` bigint(20) NULL DEFAULT 0, `updateBy` bigint(20) NULL DEFAULT 0, `updateTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `updateTimeLong` bigint(20) NULL DEFAULT 0, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `tbpagetablecolumn${supplyCode}`; CREATE TABLE `tbpagetablecolumn${supplyCode}` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `idUser` bigint(20) NULL DEFAULT 0, `pageName` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `columnName` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `columnTitle` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `columnWidth` int(11) NULL DEFAULT 0, `columnIndex` int(11) NULL DEFAULT 0, `createBy` bigint(20) NULL DEFAULT 0, `createTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `createTimeLong` bigint(20) NULL DEFAULT 0, `updateBy` bigint(20) NULL DEFAULT 0, `updateTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `updateTimeLong` bigint(20) NULL DEFAULT 0, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 18316 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `tbpaperquoteinfo${supplyCode}`; CREATE TABLE `tbpaperquoteinfo${supplyCode}` ( `id` bigint(20) NOT NULL DEFAULT 0, `idPaperBaseInfo` bigint(20) NULL DEFAULT 0, `paperBaseName` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `idPaperBrand` bigint(20) NULL DEFAULT 0, `paperBrandName` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `paperQuoteName` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `priceType` int(11) NULL DEFAULT 0, `paperPrice` decimal(18, 4) NULL, `paperGram` int(11) NULL DEFAULT 0, `paperType` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `voidFlag` int(11) NULL DEFAULT 0, `createBy` bigint(20) NULL DEFAULT 0, `createTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `createTimeLong` bigint(20) NULL DEFAULT 0, `updateBy` bigint(20) NULL DEFAULT 0, `updateTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `updateTimeLong` bigint(20) NULL DEFAULT 0, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `tbpartinfo${supplyCode}`; CREATE TABLE `tbpartinfo${supplyCode}` ( `id` bigint(20) NOT NULL, `idProduct` bigint(20) NULL DEFAULT NULL, `partName` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `defaultBasePaper` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '', `partBlood` decimal(18, 4) NULL DEFAULT NULL, `sortNum` int(11) NULL DEFAULT NULL, `voidFlag` int(11) NULL DEFAULT NULL, `createBy` bigint(20) NULL DEFAULT NULL, `createTime` datetime(0) NULL DEFAULT NULL, `createTimeLong` bigint(20) NULL DEFAULT NULL, `updateBy` bigint(20) NULL DEFAULT NULL, `updateTime` datetime(0) NULL DEFAULT NULL, `updateTimeLong` bigint(20) NULL DEFAULT NULL, `printUnit` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `saleUnit` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `partFace` int(5) NULL DEFAULT NULL, `idPaperType` bigint(20) NULL DEFAULT NULL, `transformCoefficient` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `mainFlag` int(11) NULL DEFAULT 0, `partDesc` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '', `priceViewFlag` int(11) NULL DEFAULT 0, `priceAddFlag` int(11) NULL DEFAULT 1, `pdfMakeKind` int(11) NULL DEFAULT 0, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `tbpartparameter${supplyCode}`; CREATE TABLE `tbpartparameter${supplyCode}` ( `id` bigint(20) NOT NULL, `idParameter` bigint(20) NULL DEFAULT NULL, `parameterName` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `idProduct` bigint(20) NULL DEFAULT NULL, `productName` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `idPartInfo` bigint(20) NULL DEFAULT NULL, `partName` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `defaultValue` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `sortNum` int(11) NULL DEFAULT NULL, `orderIndex` bigint(20) NULL DEFAULT NULL, `parameterHint` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `selectKind` int(11) NULL DEFAULT NULL, `workProcessId` bigint(20) NULL DEFAULT NULL, `createBy` bigint(20) NULL DEFAULT NULL, `createTime` datetime(0) NULL DEFAULT NULL, `createTimeLong` bigint(20) NULL DEFAULT NULL, `updateBy` bigint(20) NULL DEFAULT NULL, `updateTime` datetime(0) NULL DEFAULT NULL, `updateTimeLong` bigint(20) NULL DEFAULT NULL, `relatedAttribute` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `itemValue` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `cssType` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `parentId` bigint(20) NULL DEFAULT NULL, `enterType` int(5) NULL DEFAULT NULL, `isDefaultValue` int(5) NULL DEFAULT NULL, `placeHolder` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `valueKind` int(11) NULL DEFAULT 0, `quoteTitleFlag` int(11) NULL DEFAULT 0, `columnWidth` int(11) NULL DEFAULT 0, `mallQuoteViewFlag` int(11) NULL DEFAULT 0, `orderViewFlag` int(11) NULL DEFAULT 0, `specialProcessFlag` int(11) NULL DEFAULT 0, `idSpecialWorkProcess` bigint(20) NULL DEFAULT 0, `orderCalcFlag` int(11) NULL DEFAULT 0, `viewParentOrderFlag` int(11) NULL DEFAULT 0, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `tbpartparameteritem${supplyCode}`; CREATE TABLE `tbpartparameteritem${supplyCode}` ( `id` bigint(20) NOT NULL, `idProduct` bigint(20) NULL DEFAULT NULL, `idPartInfo` bigint(20) NULL DEFAULT NULL, `idParameter` bigint(20) NULL DEFAULT NULL, `itemName` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `itemValue` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `itemControl` varchar(${supplyCode}) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `sortNum` int(11) NULL DEFAULT NULL, `createBy` bigint(20) NULL DEFAULT NULL, `createTime` datetime(0) NULL DEFAULT NULL, `createTimeLong` bigint(20) NULL DEFAULT NULL, `updateBy` bigint(20) NULL DEFAULT NULL, `updateTime` datetime(0) NULL DEFAULT NULL, `updateTimeLong` bigint(20) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `tbpartworkprocess${supplyCode}`; CREATE TABLE `tbpartworkprocess${supplyCode}` ( `id` bigint(20) NOT NULL, `idProduct` bigint(20) NULL DEFAULT NULL, `productName` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `idPartInfo` bigint(20) NULL DEFAULT NULL, `partinfoName` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `idWorkProcess` bigint(20) NULL DEFAULT NULL, `sortNum` int(11) NULL DEFAULT NULL, `workProcessName` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `isRequired` int(11) NULL DEFAULT NULL, `cssType` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `createBy` bigint(20) NULL DEFAULT NULL, `createTime` datetime(0) NULL DEFAULT NULL, `createTimeLong` bigint(20) NULL DEFAULT NULL, `updateBy` bigint(20) NULL DEFAULT NULL, `updateTime` datetime(0) NULL DEFAULT NULL, `updateTimeLong` bigint(20) NULL DEFAULT NULL, `isDefault` int(5) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `tbpersonconfigvalue${supplyCode}`; CREATE TABLE `tbpersonconfigvalue${supplyCode}` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `idUser` bigint(20) NULL DEFAULT 0, `configKey` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `configName` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `configValue1` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `configValue2` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `configValue3` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `createBy` bigint(20) NULL DEFAULT 0, `createTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `createTimeLong` bigint(20) NULL DEFAULT 0, `updateBy` bigint(20) NULL DEFAULT 0, `updateTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `updateTimeLong` bigint(20) NULL DEFAULT 0, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 72 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `tbpoststation${supplyCode}`; CREATE TABLE `tbpoststation${supplyCode}` ( `id` bigint(20) NOT NULL, `postCode` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `postName` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `sortNum` int(11) NULL DEFAULT NULL, `status` int(11) NULL DEFAULT NULL, `remark` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `createBy` bigint(20) NULL DEFAULT NULL, `createTime` datetime(0) NULL DEFAULT NULL, `updateBy` bigint(20) NULL DEFAULT NULL, `updateTime` datetime(0) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `tbproduct${supplyCode}`; CREATE TABLE `tbproduct${supplyCode}` ( `id` bigint(20) NOT NULL, `idType` bigint(20) NULL DEFAULT NULL, `productTypeName` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `productName` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `productUnit` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `makeUpType` int(11) NULL DEFAULT NULL, `billPrefix` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `orderPrefix` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `isSelfHelp` int(11) NULL DEFAULT NULL, `idSkuCategory` bigint(20) NULL DEFAULT NULL, `categoryName` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `priceFlag` int(11) NULL DEFAULT NULL, `photoFixFlag` int(11) NULL DEFAULT NULL, `voidFlag` int(11) NULL DEFAULT NULL, `saleFlag` int(11) NULL DEFAULT NULL, `idPartner` bigint(20) NULL DEFAULT NULL, `createBy` bigint(20) NULL DEFAULT NULL, `createTime` datetime(0) NULL DEFAULT NULL, `createTimeLong` bigint(20) NULL DEFAULT NULL, `updateBy` bigint(20) NULL DEFAULT NULL, `updateTime` datetime(0) NULL DEFAULT NULL, `updateTimeLong` bigint(20) NULL DEFAULT NULL, `productImage` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `compageVisibleFlag` int(5) NULL DEFAULT NULL, `idProductPriceInfo` bigint(20) NULL DEFAULT 0, `minDeliveryDay` int(11) NULL DEFAULT 0, `billCodeTimeKind` int(11) NULL DEFAULT 0, `systemType` int(11) NULL DEFAULT 0, `runMode` int(11) NULL DEFAULT 0, `viewFlag` int(11) NULL DEFAULT 0, `kindCountFlag` int(11) NULL DEFAULT 0, `priceQtyContent` varchar(800) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '', `orderPrintFile` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '', `orderCalcScriptFile` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '', `sortNum` int(11) NULL DEFAULT 0, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `tbproductexampleimage${supplyCode}`; CREATE TABLE `tbproductexampleimage${supplyCode}` ( `id` bigint(20) NOT NULL DEFAULT 0, `idProduct` bigint(20) NULL DEFAULT 0, `imageName` varchar(800) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `imagePlace` int(11) NULL DEFAULT 0, `placeIdPartParameterItem` bigint(20) NULL DEFAULT 0, `createBy` bigint(20) NULL DEFAULT 0, `createTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `createTimeLong` bigint(20) NULL DEFAULT 0, `updateBy` bigint(20) NULL DEFAULT 0, `updateTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `updateTimeLong` bigint(20) NULL DEFAULT 0, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `tbproductimage${supplyCode}`; CREATE TABLE `tbproductimage${supplyCode}` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `idProduct` bigint(20) NULL DEFAULT NULL, `idUser` bigint(20) NULL DEFAULT NULL, `userName` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `srcFileName` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `fileDescription` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `downloadUrl` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `viewImageUrl` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `createBy` bigint(20) NULL DEFAULT NULL, `createTime` datetime(0) NULL DEFAULT NULL, `createTimeLong` bigint(20) NULL DEFAULT NULL, `updateBy` bigint(20) NULL DEFAULT NULL, `updateTime` datetime(0) NULL DEFAULT NULL, `updateTimeLong` bigint(20) NULL DEFAULT NULL, `sortNum` int(5) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `tbproductpagepriceinfo${supplyCode}`; CREATE TABLE `tbproductpagepriceinfo${supplyCode}` ( `id` bigint(20) NOT NULL DEFAULT 0, `priceName` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `price` decimal(18, 4) NULL, `voidFlag` int(11) NULL DEFAULT 0, `createBy` bigint(20) NULL DEFAULT 0, `createTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `createTimeLong` bigint(20) NULL DEFAULT 0, `updateBy` bigint(20) NULL DEFAULT 0, `updateTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `updateTimeLong` bigint(20) NULL DEFAULT 0, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '产品P数计价规则' ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `tbproductparameter${supplyCode}`; CREATE TABLE `tbproductparameter${supplyCode}` ( `id` bigint(20) NOT NULL, `parameterName` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `parameterFieldPart` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `parameterFieldOrder` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `fieldType` int(11) NULL DEFAULT NULL, `fieldTypeName` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `selectKind` int(11) NULL DEFAULT NULL, `idDictType` bigint(20) NULL DEFAULT NULL, `dictTypeName` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `dictTypeText` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `parameterUnit` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `defaultValue` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `voidFlag` int(11) NULL DEFAULT NULL, `selectType` int(11) NULL DEFAULT NULL, `selectParameter` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `selectSQL` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `paramUnit` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `corelSelectFlag` int(11) NULL DEFAULT NULL, `createBy` bigint(20) NULL DEFAULT NULL, `createTime` datetime(0) NULL DEFAULT NULL, `createTimeLong` bigint(20) NULL DEFAULT NULL, `updateBy` bigint(20) NULL DEFAULT NULL, `updateTime` datetime(0) NULL DEFAULT NULL, `updateTimeLong` bigint(20) NULL DEFAULT NULL, `parentId` bigint(20) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `tbproductroom${supplyCode}`; CREATE TABLE `tbproductroom${supplyCode}` ( `id` bigint(20) NOT NULL DEFAULT 0, `roomName` varchar(300) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `sortIndex` int(11) NULL DEFAULT 0, `maxVolume` decimal(18, 4) NULL, `volumeRatio` decimal(18, 4) NULL, `memos` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `voidFlag` int(11) NULL DEFAULT 0, `createBy` bigint(20) NULL DEFAULT 0, `createTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `createTimeLong` bigint(20) NULL DEFAULT 0, `updateBy` bigint(20) NULL DEFAULT 0, `updateTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `updateTimeLong` bigint(20) NULL DEFAULT 0, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `tbproducttype${supplyCode}`; CREATE TABLE `tbproducttype${supplyCode}` ( `id` bigint(20) NOT NULL, `productTypeName` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `parentId` bigint(20) NULL DEFAULT NULL, `voidFlag` int(11) NULL DEFAULT NULL, `createBy` bigint(20) NULL DEFAULT NULL, `createTime` datetime(0) NULL DEFAULT NULL, `createTimeLong` bigint(20) NULL DEFAULT NULL, `updateBy` bigint(20) NULL DEFAULT NULL, `updateTime` datetime(0) NULL DEFAULT NULL, `updateTimeLong` bigint(20) NULL DEFAULT NULL, `sortNum` int(11) NULL DEFAULT 0, `viewImageIndex` int(11) NULL DEFAULT 0, `composeGroupScript` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; INSERT INTO `tbproducttype${supplyCode}` VALUES (2, '合版类', 0, 0, 2, '2021-07-09 15:22:22', 1625815342458, 2, '2024-05-09 16:52:48', 1715244767951, 0); INSERT INTO `tbproducttype${supplyCode}` VALUES (3, '单张类', 0, 0, 2, '2021-07-09 15:28:34', 1625815713685, 2, '2024-01-26 10:14:25', 1625815713685, 0); INSERT INTO `tbproducttype${supplyCode}` VALUES (4, '画册类', 0, 0, 2, '2021-07-09 15:28:39', 1625815718630, 2, '2021-07-09 15:28:39', 1625815718630, 0); INSERT INTO `tbproducttype${supplyCode}` VALUES (5, '袋子类', 0, 0, 3, '2021-11-05 10:41:40', 1636080100112, 3, '2021-11-05 10:41:40', 1636080100112, 0); INSERT INTO `tbproducttype${supplyCode}` VALUES (6, '食品卡类', 0, 0, 3, '2021-11-25 10:44:02', 1637808242339, 3, '2021-11-25 10:44:02', 1637808242339, 0); INSERT INTO `tbproducttype${supplyCode}` VALUES (7, '数码类', 0, 0, 2, '2024-01-26 09:54:57', 1706234096708, 2, '2024-04-19 09:54:59', 1713491699293, 0); INSERT INTO `tbproducttype${supplyCode}` VALUES (8, '纸抽类', 0, 0, 2, '2024-01-26 10:04:37', 1706234676703, 2, '2024-04-19 17:10:03', 1713517802501, 0); INSERT INTO `tbproducttype${supplyCode}` VALUES (9, '联单票据类', 0, 0, 2, '2024-01-26 10:06:26', 1706234785953, 2, '2024-03-27 15:33:10', 1711524790136, 0); INSERT INTO `tbproducttype${supplyCode}` VALUES (10, 'PVC类', 0, 0, 2, '2024-04-19 17:35:56', 1713519356138, 2, '2024-04-19 17:35:56', 1713519356138, 0); INSERT INTO `tbproducttype${supplyCode}` VALUES (11, '笔记本类', 0, 0, 2, '2024-04-19 18:26:43', 1713522403006, 2, '2024-04-19 18:26:43', 1713522403006, 0); DROP TABLE IF EXISTS `tbrole${supplyCode}`; CREATE TABLE `tbrole${supplyCode}` ( `id` bigint(20) NOT NULL, `roleName` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `roleKey` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `sortNum` int(11) NOT NULL, `status` smallint(6) NOT NULL, `createBy` bigint(20) NULL DEFAULT NULL, `createTime` datetime(0) NULL DEFAULT NULL, `updateBy` bigint(20) NULL DEFAULT NULL, `updateTime` datetime(0) NULL DEFAULT NULL, `remark` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL, `systemFlag` int(11) NULL DEFAULT 0, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; INSERT INTO `tbrole${supplyCode}` VALUES (1, '权限管理员', NULL, 109, 0, -999, '2021-07-09 10:53:07', 2, '2024-05-09 11:28:02', NULL, 0); INSERT INTO `tbrole${supplyCode}` VALUES (2, '系统管理', NULL, 99, 0, -999, '2021-07-09 13:59:43', 2, '2024-05-09 11:03:08', NULL, 0); DROP TABLE IF EXISTS `tbrolemenu${supplyCode}`; CREATE TABLE `tbrolemenu${supplyCode}` ( `roleId` bigint(20) NOT NULL, `menuId` bigint(20) NOT NULL, PRIMARY KEY (`roleId`, `menuId`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; INSERT INTO `tbrolemenu${supplyCode}` VALUES (1, 2); INSERT INTO `tbrolemenu${supplyCode}` VALUES (1, 3); INSERT INTO `tbrolemenu${supplyCode}` VALUES (1, 4); INSERT INTO `tbrolemenu${supplyCode}` VALUES (1, 5); INSERT INTO `tbrolemenu${supplyCode}` VALUES (1, 6); INSERT INTO `tbrolemenu${supplyCode}` VALUES (1, 7); INSERT INTO `tbrolemenu${supplyCode}` VALUES (1, 81); INSERT INTO `tbrolemenu${supplyCode}` VALUES (1, 82); INSERT INTO `tbrolemenu${supplyCode}` VALUES (1, 83); INSERT INTO `tbrolemenu${supplyCode}` VALUES (1, 84); INSERT INTO `tbrolemenu${supplyCode}` VALUES (2, 2); INSERT INTO `tbrolemenu${supplyCode}` VALUES (2, 3); INSERT INTO `tbrolemenu${supplyCode}` VALUES (2, 5); INSERT INTO `tbrolemenu${supplyCode}` VALUES (2, 6); INSERT INTO `tbrolemenu${supplyCode}` VALUES (2, 7); INSERT INTO `tbrolemenu${supplyCode}` VALUES (2, 10); INSERT INTO `tbrolemenu${supplyCode}` VALUES (2, 11); INSERT INTO `tbrolemenu${supplyCode}` VALUES (2, 12); INSERT INTO `tbrolemenu${supplyCode}` VALUES (2, 13); INSERT INTO `tbrolemenu${supplyCode}` VALUES (2, 14); INSERT INTO `tbrolemenu${supplyCode}` VALUES (2, 15); INSERT INTO `tbrolemenu${supplyCode}` VALUES (2, 16); INSERT INTO `tbrolemenu${supplyCode}` VALUES (2, 17); INSERT INTO `tbrolemenu${supplyCode}` VALUES (2, 18); INSERT INTO `tbrolemenu${supplyCode}` VALUES (2, 19); INSERT INTO `tbrolemenu${supplyCode}` VALUES (2, 20); INSERT INTO `tbrolemenu${supplyCode}` VALUES (2, 21); INSERT INTO `tbrolemenu${supplyCode}` VALUES (2, 22); INSERT INTO `tbrolemenu${supplyCode}` VALUES (2, 23); INSERT INTO `tbrolemenu${supplyCode}` VALUES (2, 24); INSERT INTO `tbrolemenu${supplyCode}` VALUES (2, 25); INSERT INTO `tbrolemenu${supplyCode}` VALUES (2, 26); INSERT INTO `tbrolemenu${supplyCode}` VALUES (2, 27); INSERT INTO `tbrolemenu${supplyCode}` VALUES (2, 28); INSERT INTO `tbrolemenu${supplyCode}` VALUES (2, 29); INSERT INTO `tbrolemenu${supplyCode}` VALUES (2, 30); INSERT INTO `tbrolemenu${supplyCode}` VALUES (2, 31); INSERT INTO `tbrolemenu${supplyCode}` VALUES (2, 32); INSERT INTO `tbrolemenu${supplyCode}` VALUES (2, 33); INSERT INTO `tbrolemenu${supplyCode}` VALUES (2, 34); INSERT INTO `tbrolemenu${supplyCode}` VALUES (2, 35); INSERT INTO `tbrolemenu${supplyCode}` VALUES (2, 36); INSERT INTO `tbrolemenu${supplyCode}` VALUES (2, 37); INSERT INTO `tbrolemenu${supplyCode}` VALUES (2, 38); INSERT INTO `tbrolemenu${supplyCode}` VALUES (2, 39); INSERT INTO `tbrolemenu${supplyCode}` VALUES (2, 40); INSERT INTO `tbrolemenu${supplyCode}` VALUES (2, 41); INSERT INTO `tbrolemenu${supplyCode}` VALUES (2, 42); INSERT INTO `tbrolemenu${supplyCode}` VALUES (2, 43); INSERT INTO `tbrolemenu${supplyCode}` VALUES (2, 44); INSERT INTO `tbrolemenu${supplyCode}` VALUES (2, 45); INSERT INTO `tbrolemenu${supplyCode}` VALUES (2, 46); INSERT INTO `tbrolemenu${supplyCode}` VALUES (2, 47); INSERT INTO `tbrolemenu${supplyCode}` VALUES (2, 48); INSERT INTO `tbrolemenu${supplyCode}` VALUES (2, 49); INSERT INTO `tbrolemenu${supplyCode}` VALUES (2, 50); INSERT INTO `tbrolemenu${supplyCode}` VALUES (2, 52); INSERT INTO `tbrolemenu${supplyCode}` VALUES (2, 53); INSERT INTO `tbrolemenu${supplyCode}` VALUES (2, 54); INSERT INTO `tbrolemenu${supplyCode}` VALUES (2, 55); INSERT INTO `tbrolemenu${supplyCode}` VALUES (2, 56); INSERT INTO `tbrolemenu${supplyCode}` VALUES (2, 57); INSERT INTO `tbrolemenu${supplyCode}` VALUES (2, 58); INSERT INTO `tbrolemenu${supplyCode}` VALUES (2, 59); INSERT INTO `tbrolemenu${supplyCode}` VALUES (2, 65); INSERT INTO `tbrolemenu${supplyCode}` VALUES (2, 66); INSERT INTO `tbrolemenu${supplyCode}` VALUES (2, 67); INSERT INTO `tbrolemenu${supplyCode}` VALUES (2, 68); INSERT INTO `tbrolemenu${supplyCode}` VALUES (2, 70); INSERT INTO `tbrolemenu${supplyCode}` VALUES (2, 71); INSERT INTO `tbrolemenu${supplyCode}` VALUES (2, 72); INSERT INTO `tbrolemenu${supplyCode}` VALUES (2, 73); INSERT INTO `tbrolemenu${supplyCode}` VALUES (2, 74); INSERT INTO `tbrolemenu${supplyCode}` VALUES (2, 75); INSERT INTO `tbrolemenu${supplyCode}` VALUES (2, 76); INSERT INTO `tbrolemenu${supplyCode}` VALUES (2, 77); INSERT INTO `tbrolemenu${supplyCode}` VALUES (2, 78); INSERT INTO `tbrolemenu${supplyCode}` VALUES (2, 79); INSERT INTO `tbrolemenu${supplyCode}` VALUES (2, 80); INSERT INTO `tbrolemenu${supplyCode}` VALUES (2, 81); INSERT INTO `tbrolemenu${supplyCode}` VALUES (2, 82); INSERT INTO `tbrolemenu${supplyCode}` VALUES (2, 83); INSERT INTO `tbrolemenu${supplyCode}` VALUES (2, 84); INSERT INTO `tbrolemenu${supplyCode}` VALUES (2, 85); INSERT INTO `tbrolemenu${supplyCode}` VALUES (2, 86); INSERT INTO `tbrolemenu${supplyCode}` VALUES (2, 87); INSERT INTO `tbrolemenu${supplyCode}` VALUES (2, 88); INSERT INTO `tbrolemenu${supplyCode}` VALUES (2, 89); INSERT INTO `tbrolemenu${supplyCode}` VALUES (2, 90); DROP TABLE IF EXISTS `tbsitecontent${supplyCode}`; CREATE TABLE `tbsitecontent${supplyCode}` ( `id` bigint(20) NOT NULL DEFAULT 0, `groupName` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `caption` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `contentUrl` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `sortIndex` int(11) NULL DEFAULT 0, `createBy` bigint(20) NULL DEFAULT 0, `createTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `createTimeLong` bigint(20) NULL DEFAULT 0, `updateBy` bigint(20) NULL DEFAULT 0, `updateTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `updateTimeLong` bigint(20) NULL DEFAULT 0, `siteLabel` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `tbtaskqueue${supplyCode}`; CREATE TABLE `tbtaskqueue${supplyCode}` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `userId` bigint(20) NULL DEFAULT 0, `taskName` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `queryBeginDate` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `queryEndDate` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `queryContent` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `errorMsg` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `fileName` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `fileURL` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `createBy` bigint(20) NULL DEFAULT 0, `createTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `createTimeLong` bigint(20) NULL DEFAULT 0, `updateBy` bigint(20) NULL DEFAULT 0, `updateTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `updateTimeLong` bigint(20) NULL DEFAULT 0, `webFileURL` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 58 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '导出任务表' ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `tbuser${supplyCode}`; CREATE TABLE `tbuser${supplyCode}` ( `id` bigint(20) NOT NULL, `companyId` bigint(20) NULL DEFAULT NULL, `deptId` bigint(20) NULL DEFAULT NULL, `loginName` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `userName` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `userType` smallint(6) NULL DEFAULT NULL, `email` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `phonenumber` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `sex` smallint(6) NULL DEFAULT NULL, `avatar` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `password` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `salt` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `status` smallint(6) NULL DEFAULT NULL, `delFlag` smallint(6) NULL DEFAULT NULL, `createBy` bigint(20) NULL DEFAULT NULL, `createTime` datetime(0) NULL DEFAULT NULL, `updateBy` bigint(20) NULL DEFAULT NULL, `updateTime` datetime(0) NULL DEFAULT NULL, `remark` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL, `postIds` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL, `workCode` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `userCode` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `shareCode` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; INSERT INTO `tbuser${supplyCode}` VALUES (2, 0, 2, 'admin', '系统管理员', 0, '', '', 0, '', 'F7E93F7D138BC577064079DF54056FE7', '', 0, NULL, -999, '2021-07-09 14:04:36', 2, '2022-02-16 18:07:36', NULL, NULL, NULL, NULL, ''); DROP TABLE IF EXISTS `tbusernoticemessage${supplyCode}`; CREATE TABLE `tbusernoticemessage${supplyCode}` ( `id` bigint(20) NOT NULL DEFAULT 0, `idUser` bigint(20) NULL DEFAULT 0, `idNoticeMessage` bigint(20) NULL DEFAULT 0, `createBy` bigint(20) NULL DEFAULT 0, `createTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `createTimeLong` bigint(20) NULL DEFAULT 0, `updateBy` bigint(20) NULL DEFAULT 0, `updateTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `updateTimeLong` bigint(20) NULL DEFAULT 0, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `tbuserrole${supplyCode}`; CREATE TABLE `tbuserrole${supplyCode}` ( `userId` bigint(20) NOT NULL, `roleId` bigint(20) NOT NULL, PRIMARY KEY (`userId`, `roleId`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; INSERT INTO `tbuserrole${supplyCode}` VALUES (2, 2); INSERT INTO `tbuserrole${supplyCode}` VALUES (75219, 3); DROP TABLE IF EXISTS `tbusersubscribeorder${supplyCode}`; CREATE TABLE `tbusersubscribeorder${supplyCode}` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `idUser` bigint(20) NULL DEFAULT 0, `idOrder` bigint(20) NULL DEFAULT 0, `subscribeKind` int(11) NULL DEFAULT 0, `createBy` bigint(20) NULL DEFAULT 0, `createTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `createTimeLong` bigint(20) NULL DEFAULT 0, `updateBy` bigint(20) NULL DEFAULT 0, `updateTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `updateTimeLong` bigint(20) NULL DEFAULT 0, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `tbworkprocess${supplyCode}`; CREATE TABLE `tbworkprocess${supplyCode}` ( `id` bigint(20) NOT NULL, `processName` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `specialFlag` bigint(20) NULL DEFAULT NULL, `plateFlag` int(11) NULL DEFAULT NULL, `platePDFIndex` int(11) NULL DEFAULT NULL, `workProcessScript` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `selectFlag` bigint(11) NULL DEFAULT NULL, `queueFlag` int(11) NULL DEFAULT NULL, `feedBackFlag` int(11) NULL DEFAULT NULL, `isFeedBack` int(11) NULL DEFAULT NULL, `feedBackContent` int(5) NULL DEFAULT NULL, `voidFlag` int(11) NULL DEFAULT NULL, `sortNum` int(11) NULL DEFAULT 0, `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `createBy` bigint(20) NULL DEFAULT NULL, `createTime` datetime(0) NULL DEFAULT NULL, `createTimeLong` bigint(20) NULL DEFAULT NULL, `updateBy` bigint(20) NULL DEFAULT NULL, `updateTime` datetime(0) NULL DEFAULT NULL, `updateTimeLong` bigint(20) NULL DEFAULT NULL, `workProcessIds` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `materialTypeIds` varchar(300) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '', `baseMoney` decimal(18, 4) NULL DEFAULT NULL, `price` decimal(18, 4) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; INSERT INTO `tbworkprocess${supplyCode}` VALUES (2, '拼版', 0, 0, 0, NULL, 0, 0, 3, 1, 1, 0, 1, NULL, 2, '2021-07-09 14:51:39', 1625813498861, 2, '2023-06-12 15:42:00', 1686555720401, '', '', 0.0000, 0.0000); INSERT INTO `tbworkprocess${supplyCode}` VALUES (3, '打版', 0, 0, 0, NULL, 0, 0, 1, 1, 2, 0, 2, NULL, 2, '2021-07-09 14:52:00', 1625813520193, 2, '2022-02-17 10:19:47', 1645064386996, '', '', NULL, NULL); INSERT INTO `tbworkprocess${supplyCode}` VALUES (4, '白料', 0, 0, 0, NULL, 0, 0, 1, 1, 0, 0, 3, NULL, 2, '2021-07-09 14:52:26', 1625813545894, 2, '2022-02-17 10:19:49', 1645064389356, '', '', NULL, NULL); INSERT INTO `tbworkprocess${supplyCode}` VALUES (5, '印刷', 0, 0, 0, NULL, 0, 1, 1, 1, 2, 0, 4, NULL, 2, '2021-07-09 14:52:42', 1625813562040, 2, '2022-02-17 10:19:52', 1645064391653, '', '', NULL, NULL); DROP TABLE IF EXISTS `tbworkteam${supplyCode}`; CREATE TABLE `tbworkteam${supplyCode}` ( `id` bigint(20) NOT NULL DEFAULT 0, `teamKind` int(11) NULL DEFAULT 0, `teamName` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `idManagerUser` bigint(20) NULL DEFAULT 0, `managerUserName` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `voidFlag` int(11) NULL DEFAULT 0, `createBy` bigint(20) NULL DEFAULT 0, `createTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `createTimeLong` bigint(20) NULL DEFAULT 0, `updateBy` bigint(20) NULL DEFAULT 0, `updateTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `updateTimeLong` bigint(20) NULL DEFAULT 0, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `tbworkteamperson${supplyCode}`; CREATE TABLE `tbworkteamperson${supplyCode}` ( `id` bigint(20) NOT NULL, `idTeam` bigint(20) NULL DEFAULT 0, `idLoginUser` bigint(20) NULL DEFAULT 0, `userName` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `processOrderCount` int(11) NULL DEFAULT 0, `processImagePCount` int(11) NULL DEFAULT 0, `processWorkTeamIds` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `processProductIds` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `voidFlag` int(11) NULL DEFAULT 0, `createBy` bigint(20) NULL DEFAULT 0, `createTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `createTimeLong` bigint(20) NULL DEFAULT 0, `updateBy` bigint(20) NULL DEFAULT 0, `updateTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `updateTimeLong` bigint(20) NULL DEFAULT 0, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; DROP VIEW IF EXISTS `v_eopaymentordergroupid${supplyCode}`; CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `v_eopaymentordergroupid${supplyCode}` AS select `eopaymentordergroup${supplyCode}_current`.`id` AS `id` from `eopaymentordergroup${supplyCode}_current`; DROP VIEW IF EXISTS `v_eopaymentordergroupitemid${supplyCode}`; CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `v_eopaymentordergroupitemid${supplyCode}` AS select `eopaymentordergroupitem${supplyCode}_current`.`idItem` AS `id` from `eopaymentordergroupitem${supplyCode}_current`; DROP VIEW IF EXISTS `v_moordercancelrequestid${supplyCode}`; CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `v_moordercancelrequestid${supplyCode}` AS select `moordercancelrequest${supplyCode}_current`.`id` AS `id` from `moordercancelrequest${supplyCode}_current`; DROP VIEW IF EXISTS `v_moorderdeliverinformid${supplyCode}`; CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `v_moorderdeliverinformid${supplyCode}` AS select `moorderdeliverinform${supplyCode}_current`.`id` AS `id` from `moorderdeliverinform${supplyCode}_current`; DROP VIEW IF EXISTS `v_moorderpartid${supplyCode}`; CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `v_moorderpartid${supplyCode}` AS select `moorderpart${supplyCode}_current`.`id` AS `id` from `moorderpart${supplyCode}_current`; DROP VIEW IF EXISTS `v_moorderpartparamvalueid${supplyCode}`; CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `v_moorderpartparamvalueid${supplyCode}` AS select `moorderpartparamvalue${supplyCode}_current`.`id` AS `id` from `moorderpartparamvalue${supplyCode}_current`; DROP VIEW IF EXISTS `v_moprintordercode${supplyCode}`; CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `v_moprintordercode${supplyCode}` AS select `moprintorder${supplyCode}_current`.`orderCode` AS `Ordercode` from `moprintorder${supplyCode}_current`; DROP VIEW IF EXISTS `v_moprintorderid${supplyCode}`; CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `v_moprintorderid${supplyCode}` AS select `moprintorder${supplyCode}_current`.`id` AS `id` from `moprintorder${supplyCode}_current`; DROP TABLE IF EXISTS `maSelfTakeAddress${supplyCode}`; CREATE TABLE `maSelfTakeAddress${supplyCode}` ( `id` bigint(20) NOT NULL DEFAULT 0, `province` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `city` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `area` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `address` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `defaultFlag` int(11) NULL DEFAULT 0, `createBy` bigint(20) NULL DEFAULT 0, `createTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `createTimeLong` bigint(20) NULL DEFAULT 0, `updateBy` bigint(20) NULL DEFAULT 0, `updateTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `updateTimeLong` bigint(20) NULL DEFAULT 0, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `esorderstockitem${supplyCode}_current`; CREATE TABLE `esorderstockitem${supplyCode}_current` ( `id` bigint(20) NOT NULL DEFAULT 0, `idOrder` bigint(20) NULL DEFAULT 0, `orderCode` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `printBillCode` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `idClient` bigint(20) NULL DEFAULT 0, `clientName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `orderQty` decimal(18, 4) NULL, `totalBoxCount` int(11) NULL DEFAULT 0, `stockCount` int(11) NULL DEFAULT 0, `boxCount` int(11) NULL DEFAULT 0, `boxDesc` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `itemPrint` int(11) NULL DEFAULT 0, `idPrintBoxMan` bigint(20) NULL DEFAULT 0, `printBoxMan` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `printBoxDate` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `idInStockMan` bigint(20) NULL DEFAULT 0, `inStockMan` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `inStockDate` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `inStockCode` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `idStockPlace` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `stockPlace` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `itemState` bigint(20) NULL DEFAULT 0, `voidFlag` int(11) NULL DEFAULT 0, `createBy` bigint(20) NULL DEFAULT 0, `createTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `createTimeLong` bigint(20) NULL DEFAULT 0, `updateBy` bigint(20) NULL DEFAULT 0, `updateTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `updateTimeLong` bigint(20) NULL DEFAULT 0, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `esorderstocklabel${supplyCode}_current`; CREATE TABLE `esorderstocklabel${supplyCode}_current` ( `id` bigint(20) NOT NULL DEFAULT 0, `idOrderStockItem` bigint(20) NULL DEFAULT 0, `idOrder` bigint(20) NULL DEFAULT 0, `labelState` int(11) NULL DEFAULT 0, `labelQty` decimal(18, 4) NULL, `labelCount` int(11) NULL DEFAULT 0, `labelNum` int(11) NULL DEFAULT 0, `idStockPlace` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `stockPlace` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `idSendBillItemLabel` bigint(20) NULL DEFAULT 0, `idSendBillItem` bigint(20) NULL DEFAULT 0, `idSendBill` bigint(20) NULL DEFAULT 0, `sendBillCode` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `idLogistic` bigint(20) NULL DEFAULT 0, `logisticName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `logisticCode` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `sendDate` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `sendDateLong` bigint(20) NULL DEFAULT 0, `createBy` bigint(20) NULL DEFAULT 0, `createTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `createTimeLong` bigint(20) NULL DEFAULT 0, `updateBy` bigint(20) NULL DEFAULT 0, `updateTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `updateTimeLong` bigint(20) NULL DEFAULT 0, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `essendbill${supplyCode}_current`; CREATE TABLE `essendbill${supplyCode}_current` ( `id` bigint(20) NOT NULL DEFAULT 0, `billCode` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `billState` int(11) NULL DEFAULT 0, `createMan` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `sendMemo` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `sendDate` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `sendDateLong` bigint(20) NULL DEFAULT 0, `voidFlag` int(11) NULL DEFAULT 0, `createBy` bigint(20) NULL DEFAULT 0, `createTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `createTimeLong` bigint(20) NULL DEFAULT 0, `updateBy` bigint(20) NULL DEFAULT 0, `updateTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `updateTimeLong` bigint(20) NULL DEFAULT 0, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `essendbillitem${supplyCode}_current`; CREATE TABLE `essendbillitem${supplyCode}_current` ( `id` bigint(20) NOT NULL DEFAULT 0, `idSendBill` bigint(20) NULL DEFAULT 0, `idDeliverInfo` bigint(20) NULL DEFAULT 0, `sendBillCode` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `orderCode` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `idOrder` bigint(20) NULL DEFAULT 0, `sendBoxCount` decimal(18, 4) NULL, `sendBoxDesc` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `sendPrintQty` decimal(18, 4) NULL, `idOrderStockItem` bigint(20) NULL DEFAULT 0, `voidFlag` int(11) NULL DEFAULT 0, `idLogistics` bigint(20) NULL DEFAULT 0, `logisticsName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `payOnDeliveryFlag` int(11) NULL DEFAULT NULL, `logisticsCode` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `parentMailNo` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `arrivedOrgSimpleName` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `itemState` bigint(20) NULL DEFAULT 0, `idFeedBackMan` bigint(20) NULL DEFAULT 0, `feedBackMan` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `feedBackDate` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `deliverBackMemo` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `deliverBackDate` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `logisticsBillDate` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `stockPlace` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `idClient` bigint(20) NULL DEFAULT 0, `clientName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `sendDate` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `sendDateLong` bigint(20) NULL DEFAULT 0, `productName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `orderName` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `createBy` bigint(20) NULL DEFAULT 0, `createTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `createTimeLong` bigint(20) NULL DEFAULT 0, `updateBy` bigint(20) NULL DEFAULT 0, `updateTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `updateTimeLong` bigint(20) NULL DEFAULT 0, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `essendbillitemlabel${supplyCode}_current`; CREATE TABLE `essendbillitemlabel${supplyCode}_current` ( `id` bigint(20) NOT NULL DEFAULT 0, `idStockLabel` bigint(20) NULL DEFAULT 0, `idBillItem` bigint(20) NULL DEFAULT 0, `idSendBill` bigint(20) NULL DEFAULT 0, `voidFlag` int(11) NULL DEFAULT 0, `idOrder` bigint(20) NULL DEFAULT 0, `idLogistic` bigint(20) NULL DEFAULT 0, `logisticName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `logisticCode` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `sendMailNo` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `shortAddress` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `createBy` bigint(20) NULL DEFAULT 0, `createTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `createTimeLong` bigint(20) NULL DEFAULT 0, `updateBy` bigint(20) NULL DEFAULT 0, `updateTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `updateTimeLong` bigint(20) NULL DEFAULT 0, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `moordermachinebill${supplyCode}_current`; CREATE TABLE `moordermachinebill${supplyCode}_current` ( `id` bigint(20) NOT NULL DEFAULT '0', `billCode` varchar(100) DEFAULT '', `billName` varchar(500) DEFAULT '', `billFrom` int(11) DEFAULT '0', `billState` int(11) DEFAULT '0', `billMemo` varchar(2000) DEFAULT '', `billMoneyPlate` decimal(18,4) DEFAULT '0.0000', `billMoneyPaper` decimal(18,4) DEFAULT '0.0000', `billMoneyPrint` decimal(18,4) DEFAULT '0.0000', `billMoneyProcess` decimal(18,4) DEFAULT '0.0000', `billMoneyTotal` decimal(18,4) DEFAULT '0.0000', `createManName` varchar(50) DEFAULT '', `voidFlag` int(11) DEFAULT '0', `createBy` bigint(20) DEFAULT '0', `createTime` datetime DEFAULT CURRENT_TIMESTAMP, `createTimeLong` bigint(20) DEFAULT '0', `updateBy` bigint(20) DEFAULT '0', `updateTime` datetime DEFAULT CURRENT_TIMESTAMP, `updateTimeLong` bigint(20) DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `moordermachinetask${supplyCode}_current`; CREATE TABLE `moordermachinetask${supplyCode}_current` ( `id` bigint(20) NOT NULL DEFAULT 0, `idBill` bigint(20) DEFAULT '0', `taskCode` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `taskName` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `idWorkProcess` bigint(20) NULL DEFAULT 0, `workProcessName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `idMachine` bigint(20) NULL DEFAULT 0, `machineName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `taskStatus` int(11) NULL DEFAULT 0, `dispatchTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `dispatchTimeLong` bigint(20) NULL DEFAULT 0, `dispatchTimeYear` int(11) NULL DEFAULT 0, `dispatchTimeMonth` int(11) NULL DEFAULT 0, `dispatchTimeDay` int(11) NULL DEFAULT 0, `idDispatchUser` bigint(20) NULL DEFAULT 0, `dispatchUserName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `processTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `processTimeLong` bigint(20) NULL DEFAULT 0, `processTimeYear` int(11) NULL DEFAULT 0, `processTimeMonth` int(11) NULL DEFAULT 0, `processTimeDay` int(11) NULL DEFAULT 0, `idProcessUser` bigint(20) NULL DEFAULT 0, `processUserName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `processMemo` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `processQty` decimal(18, 4) NULL, `createBy` bigint(20) NULL DEFAULT 0, `createTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `createTimeLong` bigint(20) NULL DEFAULT 0, `updateBy` bigint(20) NULL DEFAULT 0, `updateTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `updateTimeLong` bigint(20) NULL DEFAULT 0, `idParentTask` bigint(20) NULL DEFAULT 0, `expectStartTimeLong` bigint(20) NULL DEFAULT 0, `expectCostTime` bigint(20) NULL DEFAULT 0, `taskFullIndex` bigint(20) NULL DEFAULT 0, `taskGroupIndex` int(11) NULL DEFAULT 0, `pdfMakeStatus` int(11) NULL DEFAULT 0, `pdfMakeKind` int(11) NULL DEFAULT 0, `idPrintTask` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `idAssembleBreedTask` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `idCutPaperTask` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `idMadeBreedTask` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `breedFlipType` int(11) NULL DEFAULT 0, `pageBlankTop` decimal(18, 4) NULL, `pageBlankLeft` decimal(18, 4) NULL, `pageBlankBottom` decimal(18, 4) NULL, `pageBlankRight` decimal(18, 4) NULL, `breedSize` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `holdPlace` int(11) NULL DEFAULT 0, `exchangeHoldPlace` int(11) NULL DEFAULT 0, `printCount` int(11) NULL DEFAULT 0, `idPaperQuoteInfo` bigint(20) NULL DEFAULT 0, `paperName` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `processPageCount` int(11) NULL DEFAULT 0, `reversePages` int(11) NULL DEFAULT 0, `pdfPlateKind` int(11) NULL DEFAULT 0, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `moordermachinetaskbookpage${supplyCode}_current`; CREATE TABLE `moordermachinetaskbookpage${supplyCode}_current` ( `id` bigint(20) NOT NULL DEFAULT 0, `idBill` bigint(20) DEFAULT '0', `idTask` bigint(20) NULL DEFAULT 0, `idTaskItem` bigint(20) NULL DEFAULT 0, `idOrder` bigint(20) NULL DEFAULT 0, `idOrderPart` bigint(20) NULL DEFAULT 0, `cropRect` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `pdfPageNoPos` int(11) NULL DEFAULT 0, `pdfNoteCol` int(11) NULL DEFAULT 0, `pdfNoteRow` int(11) NULL DEFAULT 0, `subLeft` decimal(18, 4) NULL, `subTop` decimal(18, 4) NULL, `pdfPageIndexDesc` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `pdfPageIndex` int(11) NULL DEFAULT 0, `createBy` bigint(20) NULL DEFAULT 0, `createTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `createTimeLong` bigint(20) NULL DEFAULT 0, `updateBy` bigint(20) NULL DEFAULT 0, `updateTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `updateTimeLong` bigint(20) NULL DEFAULT 0, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `moordermachinetaskitem${supplyCode}_current`; CREATE TABLE `moordermachinetaskitem${supplyCode}_current` ( `id` bigint(20) NOT NULL DEFAULT 0, `idBill` bigint(20) DEFAULT '0', `idTask` bigint(20) NULL DEFAULT 0, `idOrder` bigint(20) NULL DEFAULT 0, `idOrderPart` bigint(20) NULL DEFAULT 0, `orderCode` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `orderName` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `clientName` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `productSize` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `orderMemo` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `orderDeliverDate` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `orderDeliverDateLong` bigint(20) NULL DEFAULT 0, `orderAllProcessStr` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `orderQty` decimal(18, 4) NULL, `idProduct` bigint(20) NULL DEFAULT 0, `idPartInfo` bigint(20) NULL DEFAULT 0, `productName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `partName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `partIdPaperQuoteInfo` bigint(20) NULL DEFAULT 0, `partQuotePaperName` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `partHeight` decimal(18, 4) NULL, `partWidth` decimal(18, 4) NULL, `locationX` decimal(18, 4) NULL, `locationY` decimal(18, 4) NULL, `rotationAngle` int(11) NULL DEFAULT 0, `bloodValue` decimal(18, 4) NULL, `faceCount` int(11) NULL DEFAULT 0, `partQty` decimal(18, 4) NULL, `paperSuttle` int(11) NULL DEFAULT 0, `originFile` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `pDFFileObverse` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `pDFFileObversePageIndex` int(11) NULL DEFAULT 0, `pDFFileReverse` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `pDFFileReversePageIndex` int(11) NULL DEFAULT 0, `moduleCount` int(11) NULL DEFAULT 0, `createBy` bigint(20) NULL DEFAULT 0, `createTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `createTimeLong` bigint(20) NULL DEFAULT 0, `updateBy` bigint(20) NULL DEFAULT 0, `updateTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `updateTimeLong` bigint(20) NULL DEFAULT 0, `partPdfStartPageIndex` int(11) NULL DEFAULT 0, `partPdfEndPageIndex` int(11) NULL DEFAULT 0, `partDraftCount` int(11) NULL DEFAULT 0, `partJointQty` int(11) NULL DEFAULT 0, `partJointPageSort` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `partPageQty` int(11) NULL DEFAULT 0, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `moorderpartprocess${supplyCode}_current`; CREATE TABLE `moorderpartprocess${supplyCode}_current` ( `id` bigint(20) NOT NULL DEFAULT 0, `idOrder` bigint(20) NULL DEFAULT 0, `idOrderPart` bigint(20) NULL DEFAULT 0, `idProcess` bigint(20) NULL DEFAULT 0, `processMemo` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `obvRevId` int(11) NULL DEFAULT 0, `orderIndex` int(11) NULL DEFAULT 0, `pasteUpFileName` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `pasteUpFilePageIndex` int(11) NULL DEFAULT 0, `processPrice` decimal(18, 4) NULL, `processQty` decimal(18, 4) NULL, `processMoney` decimal(18, 4) NULL, `processRule` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `idMaterial` bigint(20) NULL DEFAULT 0, `isOutAssisted` int(11) NULL DEFAULT 0, `idOutAssistBill` bigint(20) NULL DEFAULT 0, `outAssistBillCode` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `materialQty` decimal(18, 4) NULL, `materialPreOutFlag` int(11) NULL DEFAULT 0, `idActualMaterialInfo` bigint(20) NULL DEFAULT 0, `actualMaterialInfoName` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `preOutStockLockIdRoom` bigint(20) NULL DEFAULT 0, `preOutStockLockQty` int(11) NULL DEFAULT 0, `preOutLockState` int(11) NULL DEFAULT 0, `preOutLockManId` bigint(20) NULL DEFAULT 0, `preOutLockManName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `preOutStockUnlocked` int(11) NULL DEFAULT 0, `materialPreRequestFlag` int(11) NULL DEFAULT 0, `materialStockInFlag` int(11) NULL DEFAULT 0, `materialPickingFlag` int(11) NULL DEFAULT 0, `materialStockOutFlag` int(11) NULL DEFAULT 0, `createBy` bigint(20) NULL DEFAULT 0, `createTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `createTimeLong` bigint(20) NULL DEFAULT 0, `updateBy` bigint(20) NULL DEFAULT 0, `updateTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0), `updateTimeLong` bigint(20) NULL DEFAULT 0, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; drop table if exists maMallSocialUser${supplyCode}; create table maMallSocialUser${supplyCode}( id bigint default 0, idUser bigint default 0, fromKind int default 0, userOpenId varchar(100) default '', userNickName varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci default '', userLinkPhone varchar(100) default '', avatarUrl varchar(100) default '', userIdentity int default 0, voidFlag int default 0, createBy bigint default 0, createTime datetime default NOW(), createTimeLong bigint default 0, updateBy bigint default 0, updateTime datetime default NOW(), updateTimeLong bigint default 0, primary key (id) ) ENGINE = INNODB AUTO_INCREMENT = 1 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic COMMENT = ''; DROP TABLE IF EXISTS `moorderpartkeyvalue${supplyCode}_current`; CREATE TABLE `moorderpartkeyvalue${supplyCode}_current` ( `id` bigint(20) NOT NULL DEFAULT 0, `idPrintOrder` bigint(20) NULL DEFAULT 0, `idMallOrder` bigint(20) NULL DEFAULT 0, `idPrintOrderPart` bigint(20) NULL DEFAULT 0, `idMallOrderPart` bigint(20) NULL DEFAULT 0, `partName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `dataType` int(11) NULL DEFAULT 0, `keyStr` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `valueStr` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `createBy` bigint(20) NULL DEFAULT 0, `createTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP, `createTimeLong` bigint(20) NULL DEFAULT 0, `updateBy` bigint(20) NULL DEFAULT 0, `updateTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP, `updateTimeLong` bigint(20) NULL DEFAULT 0, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; DROP VIEW IF EXISTS `v_esorderstockitemid${supplyCode}`; CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `v_esorderstockitemid${supplyCode}` AS select `esorderstockitem${supplyCode}_current`.`id` AS `id` from `esorderstockitem${supplyCode}_current`; DROP VIEW IF EXISTS `v_esorderstocklabelid${supplyCode}`; CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `v_esorderstocklabelid${supplyCode}` AS select `esorderstocklabel${supplyCode}_current`.`id` AS `id` from `esorderstocklabel${supplyCode}_current`; DROP VIEW IF EXISTS `v_essendbillcode${supplyCode}`; CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `v_essendbillcode${supplyCode}` AS select `essendbill${supplyCode}_current`.`billCode` AS `billCode` from `essendbill${supplyCode}_current`; DROP VIEW IF EXISTS `v_essendbillid${supplyCode}`; CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `v_essendbillid${supplyCode}` AS select `essendbill${supplyCode}_current`.`id` AS `id` from `essendbill${supplyCode}_current`; DROP VIEW IF EXISTS `v_essendbillitemid${supplyCode}`; CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `v_essendbillitemid${supplyCode}` AS select `essendbillitem${supplyCode}_current`.`id` AS `id` from `essendbillitem${supplyCode}_current`; DROP VIEW IF EXISTS `v_essendbillitemlabelid${supplyCode}`; CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `v_essendbillitemlabelid${supplyCode}` AS select `essendbillitemlabel${supplyCode}_current`.`id` AS `id` from `essendbillitemlabel${supplyCode}_current`; DROP VIEW IF EXISTS `v_moordermachinetaskbookpageid${supplyCode}`; CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `v_moordermachinetaskbookpageid${supplyCode}` AS select `moordermachinetaskbookpage${supplyCode}_current`.`id` AS `id` from `moordermachinetaskbookpage${supplyCode}_current`; DROP VIEW IF EXISTS `v_moordermachinetaskid${supplyCode}`; CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `v_moordermachinetaskid${supplyCode}` AS select `moordermachinetask${supplyCode}_current`.`id` AS `id`,`moordermachinetask${supplyCode}_current`.`taskCode` AS `taskCode` from `moordermachinetask${supplyCode}_current`; DROP VIEW IF EXISTS `v_moordermachinetaskitemid${supplyCode}`; CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `v_moordermachinetaskitemid${supplyCode}` AS select `moordermachinetaskitem${supplyCode}_current`.`id` AS `id` from `moordermachinetaskitem${supplyCode}_current`; DROP VIEW IF EXISTS `v_moorderpartprocessid${supplyCode}`; CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `v_moorderpartprocessid${supplyCode}` AS select `moorderpartprocess${supplyCode}_current`.`id` AS `id` from `moorderpartprocess${supplyCode}_current`; DROP VIEW IF EXISTS `v_moorderpartkeyvalueid${supplyCode}`; CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `v_moorderpartkeyvalueid${supplyCode}` AS select `moOrderPartKeyValue${supplyCode}_current`.`id` AS `id` from `moOrderPartKeyValue${supplyCode}_current`; DROP VIEW IF EXISTS `v_moOrderMachineBillId${supplyCode}`; CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `v_moOrderMachineBillId${supplyCode}` AS select `moordermachinebill${supplyCode}_current`.`id` AS `id`,`moordermachinebill${supplyCode}_current`.`billCode` AS `billCode` from `moordermachinebill${supplyCode}_current`;