delete FROM WORKMGRMASTER WHERE workgrp < DATE_FORMAT(NOW() - INTERVAL 1 DAY,'%Y%m%d'); delete FROM WORKMGRDETAIL WHERE workgrp < DATE_FORMAT(NOW() - INTERVAL 1 DAY,'%Y%m%d'); delete FROM SHOPPRODIN WHERE compno=4 AND SHOPSENDSTATUS=4000 and shopprodno=''; delete FROM SHOPPRODIN WHERE compno=4 AND SHOPSENDSTATUS=3000 and shopprodno=''; delete FROM SHOPPRODIN WHERE compno=4 AND SHOPSENDSTATUS=2000 and shopprodno=''; DELETE from SHOPPRODIN WHERE compno=4 AND shopprodno=''; CREATE TABLE SCHEDUSYNCSITE ( `COMPNO` int NOT NULL, `JOBCD` int NOT NULL, `SHOPCD` varchar(10) NOT NULL, `SHOPSEQ` int NOT NULL, `SYNCDAY` varchar(3) DEFAULT NULL, `SYNCHOUR` varchar(2) DEFAULT NULL, `SYNCMIN` varchar(2) DEFAULT NULL, PRIMARY KEY (`COMPNO`,`JOBCD`,`SHOPCD`,`SHOPSEQ`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; ALTER TABLE SYSTEMCONF ADD PRODCPY_LOC varchar(10) DEFAULT 'right' NULL COMMENT '복사 상품 코드 사용 시 위치'; ALTER TABLE SHOPTOSSSHOPPINGADDDTL ADD REMOVEIMGTEXTYN char(1) DEFAULT 'N' NULL COMMENT '이미지 텍스트 제거 여부'; ALTER TABLE SHOPADDRNAVERSTOREDTL ADD REMOVEIMGTEXTYN char(1) DEFAULT 'N' NULL COMMENT '이미지 텍스트 제거 여부'; ALTER TABLE SCHEDUINFO ADD COLUMN `AUTOPRODREGCHK` CHAR(1) NULL DEFAULT NULL AFTER `CLEARMIN`; ALTER TABLE SCHEDUSITE ADD COLUMN `EXCLUDE_DATE` VARCHAR(10) NULL DEFAULT NULL AFTER `PRODQTY`, ADD COLUMN `REG_TARGET` VARCHAR(10) NULL DEFAULT NULL AFTER `EXCLUDE_DATE`, ADD COLUMN `ADDITION_SEQ` INT NULL AFTER `REG_TARGET`, ADD COLUMN `REGQTY` INT NULL AFTER `ADDITION_SEQ`; ALTER TABLE SHOPADDRNAVERSTOREDTL ADD MIRRORIMGYN char(1) DEFAULT 'N' NULL; ALTER TABLE SCHEDUSITE ADD WORKSEQ INT NULL; ALTER TABLE SHOPADDRNAVERSTOREDTL ADD MIRRORIMGYN char(1) DEFAULT 'N' NULL COMMENT '대표사진 좌우반전 사용 여부'; ALTER TABLE SHOPGMARKET2ADDDTL ADD MIRRORIMGYN char(1) DEFAULT 'N' NULL COMMENT '대표사진 좌우반전 사용 여부'; ALTER TABLE SHOPAUCTION2ADDDTL ADD MIRRORIMGYN char(1) DEFAULT 'N' NULL COMMENT '대표사진 좌우반전 사용 여부'; ALTER TABLE SHOPTMONADDIDTL ADD MIRRORIMGYN char(1) DEFAULT 'N' NULL COMMENT '대표사진 좌우반전 사용 여부'; ALTER TABLE SHOPWEMARKETADDDTL ADD MIRRORIMGYN char(1) DEFAULT 'N' NULL COMMENT '대표사진 좌우반전 사용 여부'; ALTER TABLE SHOPLOTTEONADDDTL ADD MIRRORIMGYN char(1) DEFAULT 'N' NULL COMMENT '대표사진 좌우반전 사용 여부'; ALTER TABLE SHOPALWAYZADDDTL ADD MIRRORIMGYN char(1) DEFAULT 'N' NULL COMMENT '대표사진 좌우반전 사용 여부'; ALTER TABLE SHOPTOSSSHOPPINGADDDTL ADD MIRRORIMGYN char(1) DEFAULT 'N' NULL COMMENT '대표사진 좌우반전 사용 여부'; ALTER TABLE SHOPCOUPANGADDIDTL ADD MIRRORIMGYN char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT 'N' NULL COMMENT '대표사진 좌우반전 사용 여부'; ALTER TABLE SHOPMELCHIADDIDTL ADD MIRRORIMGYN char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT 'N' NULL COMMENT '대표사진 좌우반전 사용 여부'; ALTER TABLE SHOP11STADDIDTL ADD MIRRORIMGYN char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT 'N' NULL COMMENT '대표사진 좌우반전 사용 여부'; ALTER TABLE SHOPINTERPARKADDIDTL ADD MIRRORIMGYN char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT 'N' NULL COMMENT '대표사진 좌우반전 사용 여부'; ALTER TABLE SHOPADDRKAKAODTL ADD MIRRORIMGYN char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT 'N' NULL COMMENT '대표사진 좌우반전 사용 여부'; ALTER TABLE SCHEDUINFO ADD COLUMN `TOSSPRODCHK` CHAR(1) NULL AFTER `COUPPRODCHK`; ALTER TABLE SCHEDUINFO ADD COLUMN `COUPPRODCHK2` CHAR(1) NULL AFTER `COUPPRODCHK`; ALTER TABLE SCHEDUINFO ADD COLUMN `MELPRODCHK` CHAR(1) NULL AFTER `NAVERPRODCHK`; CREATE TABLE SCH_PRODINFO ( PRODSEQ varchar(100) NOT NULL, CONSTRAINT SCH_PRODINFO_pk PRIMARY KEY (PRODSEQ) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; ALTER TABLE SCHEDUINFO ADD JOBEXE51 char(1) NULL COMMENT '월~목 도매주문'; ALTER TABLE SCHEDUINFO ADD JOBEXE61 char(1) NULL COMMENT '월~목 도매수집'; ALTER TABLE SCHEDUINFO ADD JOBEXE52 char(1) NULL COMMENT '금 도매주문'; ALTER TABLE SCHEDUINFO ADD JOBEXE62 char(1) NULL COMMENT '금 도매수집'; ALTER TABLE SCHEDUINFO ADD JOBEXE53 char(1) NULL COMMENT '토 도매주문'; ALTER TABLE SCHEDUINFO ADD JOBEXE63 char(1) NULL COMMENT '토 도매수집'; ALTER TABLE SCHEDUINFO ADD JOBEXE54 char(1) NULL COMMENT '일 도매주문'; ALTER TABLE SCHEDUINFO ADD JOBEXE64 char(1) NULL COMMENT '일 도매수집'; UPDATE PRODATTRNM SET ATTRNM='크기, 형태 (실외기 포함)', FUNNSEQ=NULL, WTRADINGSEQ=NULL, TOBIZONSEQ=NULL, DOMEGGOOKSEQ='8', OWNERCLANSEQ='7', HUBSELLSEQ=NULL, DOSINSEQ='14', NOTICETYPE='891019', ITEMCODE='469867148', INTERCODE='크기, 형태 (실외기 포함)', INTERAPICODE='0907', INTERAPITYPE='I' WHERE ATTRCD='009' AND COLSEQ=8; INSERT INTO PRODATTRNM(ATTRCD, COLSEQ, ATTRNM, FUNNSEQ, WTRADINGSEQ, TOBIZONSEQ, DOMEGGOOKSEQ, OWNERCLANSEQ, HUBSELLSEQ, DOSINSEQ, NOTICETYPE, ITEMCODE, INTERCODE, INTERAPICODE, INTERAPITYPE) VALUES('008', 16, '추가설치비용', NULL, '', NULL, '', '', NULL, '', '891018', '23759905', '추가설치비용', '0810', 'I'); INSERT INTO PRODATTRNM(ATTRCD, COLSEQ, ATTRNM, FUNNSEQ, WTRADINGSEQ, TOBIZONSEQ, DOMEGGOOKSEQ, OWNERCLANSEQ, HUBSELLSEQ, DOSINSEQ, NOTICETYPE, ITEMCODE, INTERCODE, INTERAPICODE, INTERAPITYPE) VALUES('020', 29, '축산물 - 축산법에 따른 등급 표시', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '891030', '471785749', '축산물 - 축산법에 따른 등급 표시', '2015', 'I'); INSERT INTO PRODATTRNM(ATTRCD, COLSEQ, ATTRNM, FUNNSEQ, WTRADINGSEQ, TOBIZONSEQ, DOMEGGOOKSEQ, OWNERCLANSEQ, HUBSELLSEQ, DOSINSEQ, NOTICETYPE, ITEMCODE, INTERCODE, INTERAPICODE, INTERAPITYPE) VALUES('020', 28, '농수산물 - 농수산물 품질관리법에 따른 유전자변형농수산물 표시, 지리적 표시', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '891030', '471785504', '농수산물 - 농수산물 품질관리법에 따른 유전자변형농수산물 표시, 지리적 표시', '2014', 'I'); INSERT INTO PRODATTRNM(ATTRCD, COLSEQ, ATTRNM, FUNNSEQ, WTRADINGSEQ, TOBIZONSEQ, DOMEGGOOKSEQ, OWNERCLANSEQ, HUBSELLSEQ, DOSINSEQ, NOTICETYPE, ITEMCODE, INTERCODE, INTERAPICODE, INTERAPITYPE) VALUES('020', 27, '수입 농수축산물 수입식품안전관리특별법에 따른 수입신고를 필함의 문구', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '891030', '471785842', '수입 농수축산물 수입식품안전관리특별법에 따른 수입신고를 필함의 문구', '2013', 'I'); INSERT INTO PRODATTRNM(ATTRCD, COLSEQ, ATTRNM, FUNNSEQ, WTRADINGSEQ, TOBIZONSEQ, DOMEGGOOKSEQ, OWNERCLANSEQ, HUBSELLSEQ, DOSINSEQ, NOTICETYPE, ITEMCODE, INTERCODE, INTERAPICODE, INTERAPITYPE) VALUES('023', 28, '크기,체중의 한계', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '891033', '469867873', '크기,체중의 한계', '2313', NULL); INSERT INTO PRODATTRNM(ATTRCD, COLSEQ, ATTRNM, FUNNSEQ, WTRADINGSEQ, TOBIZONSEQ, DOMEGGOOKSEQ, OWNERCLANSEQ, HUBSELLSEQ, DOSINSEQ, NOTICETYPE, ITEMCODE, INTERCODE, INTERAPICODE, INTERAPITYPE) VALUES('025', 18, 'KC 인증정보', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '891035', '23760454', 'KC 인증정보', '2512', NULL); INSERT INTO PRODATTRNM(ATTRCD, COLSEQ, ATTRNM, FUNNSEQ, WTRADINGSEQ, TOBIZONSEQ, DOMEGGOOKSEQ, OWNERCLANSEQ, HUBSELLSEQ, DOSINSEQ, NOTICETYPE, ITEMCODE, INTERCODE, INTERAPICODE, INTERAPITYPE) VALUES('028', 12, '가이드 팁', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '891038', '469868440', '', NULL, NULL); INSERT INTO PRODATTRNM(ATTRCD, COLSEQ, ATTRNM, FUNNSEQ, WTRADINGSEQ, TOBIZONSEQ, DOMEGGOOKSEQ, OWNERCLANSEQ, HUBSELLSEQ, DOSINSEQ, NOTICETYPE, ITEMCODE, INTERCODE, INTERAPICODE, INTERAPITYPE) VALUES('028', 13, '선택관광 및 대체일정', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '891038', '469868346', '', NULL, NULL); INSERT INTO PRODATTRNM(ATTRCD, COLSEQ, ATTRNM, FUNNSEQ, WTRADINGSEQ, TOBIZONSEQ, DOMEGGOOKSEQ, OWNERCLANSEQ, HUBSELLSEQ, DOSINSEQ, NOTICETYPE, ITEMCODE, INTERCODE, INTERAPICODE, INTERAPITYPE) VALUES('042', 22, '유통기한', NULL, NULL, NULL, NULL, NULL, NULL, '22', '1149546', '469870656', '유통기한', NULL, NULL); INSERT INTO SHOPATTRINFO(SHOPCD, GOSICODE, GOSINUM, GOSIVAL) VALUES('shop0372', '10', '1640', '효율등급'); INSERT INTO SHOPATTRINFO(SHOPCD, GOSICODE, GOSINUM, GOSIVAL) VALUES('shop0372', '06', '0200', 'KC 인증정보'); INSERT INTO SHOPATTRINFO(SHOPCD, GOSICODE, GOSINUM, GOSIVAL) VALUES('shop0372', '06', '1840', '재공급(리퍼브) 가구의 경우 재공급 사유 및 하자 부위에 관한 정보'); INSERT INTO SHOPATTRINFO(SHOPCD, GOSICODE, GOSINUM, GOSIVAL) VALUES('shop0372', '07', '0290', '추가설치비용'); INSERT INTO SHOPATTRINFO(SHOPCD, GOSICODE, GOSINUM, GOSIVAL) VALUES('shop0372', '07', '1640', '에너지소비효율등급'); INSERT INTO SHOPATTRINFO(SHOPCD, GOSICODE, GOSINUM, GOSIVAL) VALUES('shop0372', '08', '0290', '추가설치비용'); INSERT INTO SHOPATTRINFO(SHOPCD, GOSICODE, GOSINUM, GOSIVAL) VALUES('shop0372', '08', '1640', '에너지소비효율등급'); INSERT INTO SHOPATTRINFO(SHOPCD, GOSICODE, GOSINUM, GOSIVAL) VALUES('shop0372', '09', '1640', '에너지소비효율등급'); DELETE FROM SHOPATTRINFO WHERE SHOPCD='shop0372' AND GOSICODE='11' AND GOSINUM='0330'; DELETE FROM SHOPATTRINFO WHERE SHOPCD='shop0372' AND GOSICODE='13' AND GOSINUM='0340'; INSERT INTO SHOPATTRINFO(SHOPCD, GOSICODE, GOSINUM, GOSIVAL) VALUES('shop0372', '13', '1780', '이동통신사'); INSERT INTO SHOPATTRINFO(SHOPCD, GOSICODE, GOSINUM, GOSIVAL) VALUES('shop0372', '13', '1740', '가입절차'); INSERT INTO SHOPATTRINFO(SHOPCD, GOSICODE, GOSINUM, GOSIVAL) VALUES('shop0372', '13', '1820', '소비자의 추가적인 부담사항'); INSERT INTO SHOPATTRINFO(SHOPCD, GOSICODE, GOSINUM, GOSIVAL) VALUES('shop0372', '15', '1450', ' 검사합격증 번호(대기환경보전법에 따른 첨가제ㆍ촉매제에 한암)'); DELETE FROM SHOPATTRINFO WHERE SHOPCD='shop0372' AND GOSICODE='16' AND GOSINUM='0200'; DELETE FROM SHOPATTRINFO WHERE SHOPCD='shop0372' AND GOSICODE='17' AND GOSINUM='0200'; DELETE FROM SHOPATTRINFO WHERE SHOPCD='shop0372' AND GOSICODE='19' AND GOSINUM='0060'; DELETE FROM SHOPATTRINFO WHERE SHOPCD='shop0372' AND GOSICODE='19' AND GOSINUM='0310'; INSERT INTO SHOPATTRINFO(SHOPCD, GOSICODE, GOSINUM, GOSIVAL) VALUES('shop0372', '19', '1750', '제조국 (원산지와 가공지 등이 다를 경우 함께 표기)'); INSERT INTO SHOPATTRINFO(SHOPCD, GOSICODE, GOSINUM, GOSIVAL) VALUES('shop0372', '19', '1800', '귀금속, 보석류 - 등급'); INSERT INTO SHOPATTRINFO(SHOPCD, GOSICODE, GOSINUM, GOSIVAL) VALUES('shop0372', '19', '1850', '시계 - 기능, 방수 등'); DELETE FROM SHOPATTRINFO WHERE SHOPCD='shop0372' AND GOSICODE='20' AND GOSINUM='0580'; DELETE FROM SHOPATTRINFO WHERE SHOPCD='shop0372' AND GOSICODE='20' AND GOSINUM='0600'; DELETE FROM SHOPATTRINFO WHERE SHOPCD='shop0372' AND GOSICODE='20' AND GOSINUM='0620'; INSERT INTO SHOPATTRINFO(SHOPCD, GOSICODE, GOSINUM, GOSIVAL) VALUES('shop0372', '20', '1460', '품목 또는 명칭'); INSERT INTO SHOPATTRINFO(SHOPCD, GOSICODE, GOSINUM, GOSIVAL) VALUES('shop0372', '20', '1730', '｢농수산물의 원산지 표시 등에 관한 법률｣에 따른 원산지'); INSERT INTO SHOPATTRINFO(SHOPCD, GOSICODE, GOSINUM, GOSIVAL) VALUES('shop0372', '20', '1760', '제조연월일, 소비기한 또는 품질유지기한'); INSERT INTO SHOPATTRINFO(SHOPCD, GOSICODE, GOSINUM, GOSIVAL) VALUES('shop0372', '20', '1680', '농수산물 – ｢농수산물 품질관리법｣에 따른 유전자변형농수산물 표시, 지리적 표시'); INSERT INTO SHOPATTRINFO(SHOPCD, GOSICODE, GOSINUM, GOSIVAL) VALUES('shop0372', '20', '1690', '축산물 - ｢축산법｣에 따른 등급 표시'); INSERT INTO SHOPATTRINFO(SHOPCD, GOSICODE, GOSINUM, GOSIVAL) VALUES('shop0372', '20', '1700', '수입 농수축산물 - “수입식품안전관리 특별법에 따른 수입신고를 필함”의 문구'); INSERT INTO SHOPATTRINFO(SHOPCD, GOSICODE, GOSINUM, GOSIVAL) VALUES('shop0372', '20', '1470', '소비자 안전을 위한 주의사항'); DELETE FROM SHOPATTRINFO WHERE SHOPCD='shop0372' AND GOSICODE='21' AND GOSINUM='0060'; DELETE FROM SHOPATTRINFO WHERE SHOPCD='shop0372' AND GOSICODE='21' AND GOSINUM='0660'; INSERT INTO SHOPATTRINFO(SHOPCD, GOSICODE, GOSINUM, GOSIVAL) VALUES('shop0372', '21', '1480', '제품명'); INSERT INTO SHOPATTRINFO(SHOPCD, GOSICODE, GOSINUM, GOSIVAL) VALUES('shop0372', '21', '1490', '소비자 안전을 위한 주의사항'); DELETE FROM SHOPATTRINFO WHERE SHOPCD='shop0372' AND GOSICODE='22' AND GOSINUM='0580'; DELETE FROM SHOPATTRINFO WHERE SHOPCD='shop0372' AND GOSICODE='22' AND GOSINUM='0630'; DELETE FROM SHOPATTRINFO WHERE SHOPCD='shop0372' AND GOSICODE='22' AND GOSINUM='0650'; DELETE FROM SHOPATTRINFO WHERE SHOPCD='shop0372' AND GOSICODE='22' AND GOSINUM='0680'; DELETE FROM SHOPATTRINFO WHERE SHOPCD='shop0372' AND GOSICODE='22' AND GOSINUM='0700'; DELETE FROM SHOPATTRINFO WHERE SHOPCD='shop0372' AND GOSICODE='22' AND GOSINUM='0770'; INSERT INTO SHOPATTRINFO(SHOPCD, GOSICODE, GOSINUM, GOSIVAL) VALUES('shop0372', '22', '1480', '제품명'); INSERT INTO SHOPATTRINFO(SHOPCD, GOSICODE, GOSINUM, GOSIVAL) VALUES('shop0372', '22', '1660', '소비기한 및 보관방법'); INSERT INTO SHOPATTRINFO(SHOPCD, GOSICODE, GOSINUM, GOSIVAL) VALUES('shop0372', '22', '1490', '소비자 안전을 위한 주의사항'); INSERT INTO SHOPATTRINFO(SHOPCD, GOSICODE, GOSINUM, GOSIVAL) VALUES('shop0372', '22', '1710', '｢건강기능식품에 관한 법률｣에 따른 유전자변형건강기능식품 표시'); INSERT INTO SHOPATTRINFO(SHOPCD, GOSICODE, GOSINUM, GOSIVAL) VALUES('shop0372', '22', '1720', '수입 건강기능식품의 경우 “수입식품안전관리특별법에 따른 수입신고를 필함”의 문구'); INSERT INTO SHOPATTRINFO(SHOPCD, GOSICODE, GOSINUM, GOSIVAL) VALUES('shop0372', '23', '1830', '크기ㆍ체중의 한계'); INSERT INTO SHOPATTRINFO(SHOPCD, GOSICODE, GOSINUM, GOSIVAL) VALUES('shop0372', '25', '0200', 'KC 인증정보'); DELETE FROM SHOPATTRINFO WHERE SHOPCD='shop0372' AND GOSICODE='28' AND GOSINUM='1030'; INSERT INTO SHOPATTRINFO(SHOPCD, GOSICODE, GOSINUM, GOSIVAL) VALUES('shop0372', '28', '1770', '선택경비 유무 등'); INSERT INTO SHOPATTRINFO(SHOPCD, GOSICODE, GOSINUM, GOSIVAL) VALUES('shop0372', '28', '1790', '선택관광 및 대체일정'); INSERT INTO SHOPATTRINFO(SHOPCD, GOSICODE, GOSINUM, GOSIVAL) VALUES('shop0372', '28', '1810', '가이드 팁'); DELETE FROM SHOPATTRINFO WHERE SHOPCD='shop0372' AND GOSICODE='32' AND GOSINUM='0160'; DELETE FROM SHOPATTRINFO WHERE SHOPCD='shop0372' AND GOSICODE='32' AND GOSINUM='1170'; INSERT INTO SHOPATTRINFO(SHOPCD, GOSICODE, GOSINUM, GOSIVAL) VALUES('shop0372', '32', '0210', '품명 및 모델명'); DELETE FROM SHOPATTRINFO WHERE SHOPCD='shop0372' AND GOSICODE='38' AND GOSINUM='0200'; INSERT INTO SHOPNAVERATTR (TYPE_SEQ, TYPE_ENAME, TYPE_KNAME, COL_SEQ, COL_ENAME, COL_KNAME, COL_VALUE) VALUES (20, 'GENERAL_FOOD', '가공식품', 19, 'vm.content.consumptionDateText', '', '상세페이지 참조'); ALTER TABLE SCHEDUINFO ADD EXECKEY varchar(50) NULL COMMENT '실행 고유키'; ALTER TABLE SCHEDUINFO MODIFY COLUMN EXECKEY varchar(50) AFTER EXECID; ALTER TABLE SHOPTOSSSHOPPINGADDDTL ADD PRICEADDDELIVERYCOSTYN CHAR(1) DEFAULT 'Y' NULL COMMENT '무료배송일때 상품가격에 배송비 추가 사용여부'; ALTER TABLE SHOPTOSSSHOPPINGADDDTL ADD EXPPRC VARCHAR(10) DEFAULT '9999' NULL COMMENT '추가할 배송비 ''9999''이면 상품정보에 있는거 없으면 환경설정 배송비'; ALTER TABLE SHOPALWAYZADDDTL ADD PRICEADDDELIVERYCOSTYN CHAR(1) DEFAULT 'Y' NULL COMMENT '무료배송일때 상품가격에 배송비 추가 사용여부'; ALTER TABLE SHOPALWAYZADDDTL ADD EXPPRC VARCHAR(10) DEFAULT '9999' NULL COMMENT '추가할 배송비 ''9999''이면 상품정보에 있는거 없으면 환경설정 배송비'; ALTER TABLE SHOPTOSSSHOPPINGADDDTL ADD USERSALEYN CHAR(1) DEFAULT 'N' NULL COMMENT '사용자 할인율 적용 사용여부'; ALTER TABLE SHOPTOSSSHOPPINGADDDTL ADD USERSALEPERCENT INT NULL COMMENT '사용자 할인율'; ALTER TABLE SYSTEMCONF ADD SAVEPRODUCTLOGYN CHAR(1) DEFAULT 'N' NULL COMMENT '상품 등록 시 통계정보에 로그 남길건지 사용여부'; CREATE TABLE WORKMGRLOG ( `WORKGRP` VARCHAR(50) NOT NULL COMMENT '작업관리 ID', `SHOPCD` VARCHAR(10) CHARACTER SET UTF8MB4 COLLATE UTF8MB4_0900_AI_CI NOT NULL COMMENT '쇼핑몰코드', `SHOPNM` VARCHAR(20) DEFAULT NULL COMMENT '쇼핑몰이름', `SHOPSEQ` INT DEFAULT NULL COMMENT '쇼핑몰 순번', `SHOPPINGID` VARCHAR(50) DEFAULT NULL COMMENT '로그인 ID', `NICKNM1` VARCHAR(50) CHARACTER SET UTF8MB4 COLLATE UTF8MB4_0900_AI_CI DEFAULT NULL COMMENT '닉네임', `SEQ` INT DEFAULT NULL COMMENT 'WORKGRP에 있는 순서', `PRODSEQ` VARCHAR(30) CHARACTER SET UTF8MB4 COLLATE UTF8MB4_0900_AI_CI DEFAULT NULL COMMENT '자체상품코드', `STATUS` VARCHAR(100) DEFAULT NULL COMMENT '판매상태', `MESSAGE` VARCHAR(150) DEFAULT NULL COMMENT '작업 관련 메세지', `ADDITIONALSEQ` INT DEFAULT NULL COMMENT '부가정보 순서', `ADDITIONALTITLE` VARCHAR(100) DEFAULT NULL COMMENT '부가정보 제목', `IMGONEONONE` VARCHAR(10) CHARACTER SET UTF8MB4 COLLATE UTF8MB4_0900_AI_CI DEFAULT NULL COMMENT '이미지 리사이징 사용여부', `DSCAMTPERCENT` VARCHAR(50) CHARACTER SET UTF8MB4 COLLATE UTF8MB4_0900_AI_CI DEFAULT NULL COMMENT '할인율', `MARGINDC` FLOAT DEFAULT NULL COMMENT '마진율', `COMMDC` FLOAT DEFAULT NULL COMMENT '수수료율', `CHANGESIZEX` VARCHAR(50) CHARACTER SET UTF8MB4 COLLATE UTF8MB4_0900_AI_CI DEFAULT NULL COMMENT '대표사진사이즈변경 X', `CHANGESIZEY` VARCHAR(50) DEFAULT NULL COMMENT '대표사진사이즈변경 Y', `CHANGESIZEW` VARCHAR(50) DEFAULT NULL COMMENT '대표사진사이즈변경 W', `CHANGESIZEH` VARCHAR(50) DEFAULT NULL COMMENT '대표사진사이즈변경 H', `IMG_ANGLE` DOUBLE DEFAULT NULL COMMENT '이미지 회전 각도', `IMG_SCALE_PERCENT` DOUBLE DEFAULT NULL COMMENT '이미지 확대율', `MIRRORIMGYN` CHAR(1) DEFAULT NULL COMMENT '반전사용여부', `GOODS_KEYWORD` VARCHAR(30) DEFAULT NULL COMMENT '도매몰', `CLASS_CD3` VARCHAR(50) DEFAULT NULL COMMENT '소분류코드', `FULL_NAME` TEXT COMMENT '카테고리 풀이름', `INSERTDT` VARCHAR(50) DEFAULT NULL COMMENT '입력/등록 일자', `GOODS_COST` INT DEFAULT NULL COMMENT '원가', `DELV_COST` INT DEFAULT NULL COMMENT '배송비', `GOODS_SEARCH` TEXT COMMENT '키워드', `SALE_CNT` INT DEFAULT NULL COMMENT '주문수량' ) ENGINE=INNODB DEFAULT CHARSET=UTF8MB4 COLLATE=UTF8MB4_0900_AI_CI COMMENT='상품등록하면서 쌓이는 기록 [ 환경설정에 체크 시 ]'; ALTER TABLE SHOPADDRNAVERSTOREDTL ADD PRICECOMPARISON_ENURI varchar(2) NULL COMMENT '에누리 가격비교여부 01 등록함 02 등록안함'; ALTER TABLE SHOPADDRNAVERSTOREDTL ADD PRICECOMPARISON_DANAWA varchar(2) NULL COMMENT '다나와 가격비교여부 01 등록함 02 등록안함'; ALTER TABLE WORKMGRLOG ADD INDEX SHOPCD_SHOPPINGID_PRODSEQ (SHOPCD, SHOPPINGID, PRODSEQ); ALTER TABLE SHOPTOSSSHOPPINGADDDTL ADD USEADDITIONALDELIVERYTYPEYN CHAR(1) DEFAULT 'Y' NULL COMMENT '배송유형 부가정보사용 : Y , 상품정보사용 : N'; ALTER TABLE SHOPTOSSSHOPPINGADDDTL ADD DELIVERYTYPE CHAR(1) DEFAULT 'F' NULL COMMENT '배송비 유형 무료 : F(FREE), 유료 : P(PAID), 조건부 : C(CONDITIONAL)'; ALTER TABLE SHOPTOSSSHOPPINGADDDTL ADD BASEFEE INT DEFAULT 0 NULL COMMENT '부가정보사용 유료일때 기본 배송비'; ALTER TABLE SHOPTOSSSHOPPINGADDDTL ADD FREEAMTCOND INT DEFAULT 0 NULL COMMENT '조건부무료 하기위한 최소금액'; ALTER TABLE SYSTEMCONF ADD COLUMN SLACKYN CHAR(1) NULL DEFAULT 'N' AFTER SAVEPRODUCTLOGYN, ADD COLUMN SLACKKEY VARCHAR(500) NULL DEFAULT NULL AFTER SLACKYN, ADD COLUMN SLACKURL VARCHAR(500) NULL DEFAULT NULL AFTER SLACKKEY, ADD COLUMN SLACKID VARCHAR(50) NULL DEFAULT NULL AFTER SLACKURL; ALTER TABLE SHOPPRODFOLDERS DROP INDEX COMPNO_FOLDER; ALTER TABLE SHOPPRODFOLDERS DROP INDEX COMPNO_FOLDER_COMPAYNY_GOODS_CD; ALTER TABLE SHOPPRODFOLDERS ADD CONSTRAINT SHOPPRODFOLDERS_pk PRIMARY KEY (COMPNO,FOLDER,COMPAYNY_GOODS_CD); ALTER TABLE SCHEDUSITE ADD SEARCH_OPTION_SEQ INT NULL; ALTER TABLE SCHEDUSITE ADD CONSTRAINT schedusite_FK FOREIGN KEY (SEARCH_OPTION_SEQ) REFERENCES SCH_SEARCH_OPTION(SEARCH_OPTION_SEQ); CREATE TABLE `SCH_SEARCH_OPTION` ( `SEARCH_OPTION_SEQ` int NOT NULL AUTO_INCREMENT, `SHOPCD` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '쇼핑몰 코드', `SHOPSEQ` int DEFAULT '0' COMMENT '쇼핑몰 순번', `SHOPSENDSTATUS` int DEFAULT NULL COMMENT '전송대기 = 9000,판매중 = 8000 ,수정대기 = 7000,자체수정 = 6000,종료대기 = 5000,품절 = 4000,판매종료 = 3000,삭제 = 2000,전송대기_전송실패 -9000,수정대기_전송실패 -7000', `OPTION_NAME` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '검색조건 이름', `CATEGORY` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '카테고리', `DOMEMALL` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '도매몰', `FOLDER` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '폴더', `DATE_FROM` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '시작일자', `DATE_TO` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '종료일자', `SEARCH_GUBUN` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '검색조건', `SEARCH_TEXT` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '검색어', PRIMARY KEY (`SEARCH_OPTION_SEQ`) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; CREATE TABLE `SET_SCHE_MST` ( `SET_SEQ` int NOT NULL AUTO_INCREMENT, `SET_NAME` varchar(100) DEFAULT NULL, PRIMARY KEY (`SET_SEQ`) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; CREATE TABLE `SET_SCHEDUINFO` ( `SET_SEQ` int NOT NULL, `COMPNO` int NOT NULL, `JOBCD` int NOT NULL COMMENT '1:상품, 2:주문, 3:문의', `JOBSTAT` char(1) DEFAULT NULL COMMENT '동작상태', `EXECID` varchar(10) DEFAULT NULL COMMENT '동작시작아이디', `EXECKEY` varchar(50) DEFAULT NULL, `EXECDT` varchar(20) DEFAULT NULL COMMENT '동작시작일시', `WEEKCHK1` char(1) DEFAULT NULL COMMENT '평일', `FEWMINU1` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, `JOBEXE11` char(1) DEFAULT NULL COMMENT '발주확인', `JOBEXE21` char(1) DEFAULT NULL COMMENT '주문수집', `JOBEXE31` char(1) DEFAULT NULL COMMENT '주문동기화', `JOBEXE41` char(1) DEFAULT NULL COMMENT '송장전송', `WEEKCHK2` char(1) DEFAULT NULL, `JOBEXE12` char(1) DEFAULT NULL, `FEWMINU2` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, `JOBEXE22` char(1) DEFAULT NULL, `JOBEXE32` char(1) DEFAULT NULL, `JOBEXE42` char(1) DEFAULT NULL, `WEEKCHK3` char(1) DEFAULT NULL, `FEWMINU3` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, `JOBEXE13` char(1) DEFAULT NULL, `JOBEXE23` char(1) DEFAULT NULL, `JOBEXE33` char(1) DEFAULT NULL, `JOBEXE43` char(1) DEFAULT NULL, `WEEKCHK4` char(1) DEFAULT NULL, `FEWMINU4` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, `JOBEXE14` char(1) DEFAULT NULL, `JOBEXE24` char(1) DEFAULT NULL, `JOBEXE34` char(1) DEFAULT NULL, `JOBEXE44` char(1) DEFAULT NULL, `SITECHK` char(1) DEFAULT NULL COMMENT '특정사이트실행여부', `TYPECHK` char(1) DEFAULT NULL COMMENT '사용자분류사용여부', `MAXCHK` char(1) DEFAULT NULL COMMENT '1회최대건수제한사용여부', `MAXCNT` int DEFAULT NULL COMMENT '1회최대건수', `EXCEPCHK1` char(1) DEFAULT NULL COMMENT '예외설정여부1', `EXCEPS1` varchar(5) DEFAULT NULL COMMENT '예외설정시작시간1', `EXCEPE1` varchar(5) DEFAULT NULL COMMENT '예외설정종료시간1', `EXCEPCHK2` char(1) DEFAULT NULL, `EXCEPS2` varchar(5) DEFAULT NULL, `EXCEPE2` varchar(5) DEFAULT NULL, `EXCEPCHK3` char(1) DEFAULT NULL, `EXCEPS3` varchar(5) DEFAULT NULL, `EXCEPE3` varchar(5) DEFAULT NULL, `OUTOFEXE` varchar(1000) DEFAULT NULL COMMENT '실행제외일자', `SMSCHK` char(1) DEFAULT NULL COMMENT 'sms결과받기여부', `SMSNO` varchar(20) DEFAULT NULL COMMENT 'sms번호', `DONTCHK` char(1) DEFAULT NULL COMMENT 'sms발송금지시간사용여부', `DONTSTR` varchar(5) DEFAULT NULL COMMENT 'sms발송금지시작시간', `DONTEND` varchar(5) DEFAULT NULL COMMENT 'sms발송금지 종료시간', `EMAILCHK` char(1) DEFAULT NULL COMMENT '이메일결과받기여부', `EMAILADDR` varchar(100) DEFAULT NULL COMMENT '이메일주소', `WEEKCHK5` char(1) DEFAULT NULL, `FEWMINU5` varchar(10) DEFAULT NULL, `WEEKCHK6` char(1) DEFAULT NULL, `FEWMINU6` varchar(10) DEFAULT NULL, `WEEKCHK7` char(1) DEFAULT NULL, `FEWMINU7` varchar(10) DEFAULT NULL, `COUPPRODCHK` char(1) DEFAULT NULL COMMENT '쿠팡 아이템위너 상품 삭제여부', `COUPPRODCHK2` char(1) DEFAULT NULL, `TOSSPRODCHK` char(1) DEFAULT NULL, `NAVERPRODCHK` char(1) DEFAULT NULL COMMENT '네이버 카탈로그 상품 삭제여부', `MELPRODCHK` char(1) DEFAULT NULL, `SYNCCHK` char(1) DEFAULT NULL, `CLEARCHK` char(1) DEFAULT NULL, `CLEARDAY` varchar(3) DEFAULT NULL, `CLEARHOUR` varchar(2) DEFAULT NULL, `CLEARMIN` varchar(2) DEFAULT NULL, `AUTOPRODREGCHK` char(1) DEFAULT NULL, `JOBEXE51` char(1) DEFAULT NULL COMMENT '월~목 도매주문', `JOBEXE61` char(1) DEFAULT NULL COMMENT '월~목 도매수집', `JOBEXE52` char(1) DEFAULT NULL COMMENT '금 도매주문', `JOBEXE62` char(1) DEFAULT NULL COMMENT '금 도매수집', `JOBEXE53` char(1) DEFAULT NULL COMMENT '토 도매주문', `JOBEXE63` char(1) DEFAULT NULL COMMENT '토 도매수집', `JOBEXE54` char(1) DEFAULT NULL COMMENT '일 도매주문', `JOBEXE64` char(1) DEFAULT NULL COMMENT '일 도매수집', PRIMARY KEY (`SET_SEQ`,`COMPNO`,`JOBCD`), UNIQUE KEY `set_scheduinfo_un` (`SET_SEQ`,`COMPNO`,`JOBCD`), CONSTRAINT `set_scheduinfo_FK` FOREIGN KEY (`SET_SEQ`) REFERENCES `set_sche_mst` (`SET_SEQ`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; CREATE TABLE `SET_SCHEDUSITE` ( `SET_SEQ` int NOT NULL, `COMPNO` int NOT NULL, `JOBCD` int NOT NULL COMMENT '1: 상품, 2:주문 ,3:문의, 4:도매[주문,수집]', `SHOPCD` varchar(10) NOT NULL, `SHOPSEQ` int NOT NULL, `PRODQTY` int DEFAULT '0', `EXCLUDE_DATE` varchar(10) DEFAULT NULL, `REG_TARGET` varchar(10) DEFAULT NULL, `ADDITION_SEQ` int DEFAULT NULL, `REGQTY` int DEFAULT NULL, `WORKSEQ` int DEFAULT NULL, `SEARCH_OPTION_SEQ` int DEFAULT NULL, PRIMARY KEY (`SET_SEQ`,`COMPNO`,`JOBCD`,`SHOPCD`,`SHOPSEQ`), UNIQUE KEY `set_schedusite_un` (`SET_SEQ`,`COMPNO`,`JOBCD`,`SHOPCD`,`SHOPSEQ`), KEY `schedusite_FK` (`SEARCH_OPTION_SEQ`), CONSTRAINT `set_schedusite_FK` FOREIGN KEY (`SET_SEQ`) REFERENCES `set_sche_mst` (`SET_SEQ`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; CREATE TABLE `SET_SCHEDUSYNCSITE` ( `SET_SEQ` int NOT NULL, `COMPNO` int NOT NULL, `JOBCD` int NOT NULL, `SHOPCD` varchar(10) NOT NULL, `SHOPSEQ` int NOT NULL, `SYNCDAY` varchar(3) DEFAULT NULL, `SYNCHOUR` varchar(2) DEFAULT NULL, `SYNCMIN` varchar(2) DEFAULT NULL, PRIMARY KEY (`SET_SEQ`,`COMPNO`,`JOBCD`,`SHOPCD`,`SHOPSEQ`), CONSTRAINT `set_schedusyncsite_FK` FOREIGN KEY (`SET_SEQ`) REFERENCES `set_sche_mst` (`SET_SEQ`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; ALTER TABLE SCHEDUSITE ADD PARAM TEXT NULL COMMENT '상품수신관련 JSON'; CREATE TABLE `NAVERCATEAPIINFO` ( `COMPNO` int NOT NULL, `CLIENTID` varchar(100) NOT NULL, `CLIENTSECRET` varchar(100) NOT NULL, PRIMARY KEY (`COMPNO`,`CLIENTID`,`CLIENTSECRET`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='네이버 상품명 검색 하기 위한 api 정보'; ALTER TABLE SCHEDUINFO ADD USESETCHK char(1) NULL COMMENT '세트정보 사용 여부'; ALTER TABLE SET_SCHE_MST ADD USESETDAY varchar(3) NULL; ALTER TABLE SET_SCHE_MST ADD USESETHOUR varchar(2) NULL; ALTER TABLE SET_SCHE_MST ADD USESETMIN varchar(2) NULL; ALTER TABLE SCHEDUINFO ADD COUPPRODCHK3 CHAR(1) NULL COMMENT '쿠팡 노출제한 상품삭제여부'; ALTER TABLE SET_SCHEDUINFO ADD COUPPRODCHK3 CHAR(1) NULL COMMENT '쿠팡 노출제한 상품삭제여부'; ALTER TABLE PRODRECEIVESET ADD SETDAY varchar(3) NULL; ALTER TABLE PRODRECEIVESET ADD SETHOUR varchar(2) NULL; ALTER TABLE PRODRECEIVESET ADD SETMIN varchar(2) NULL; ALTER TABLE PRODRECEIVESET ADD PRODQTY int NULL; ALTER TABLE PRODRECEIVESET ADD EXCLUDE_DATE varchar(10) NULL; ALTER TABLE PRODRECEIVESET ADD REG_TARGET varchar(10) NULL; ALTER TABLE PRODRECEIVESET ADD PARAM2 text NULL; ALTER TABLE SCHEDUINFO ADD CYCLEINFO VARCHAR(20) NULL; CREATE TABLE CLOUDINARYAPIINFO ( `SEQ` INT(10) NOT NULL, `COMPNO` INT(10) NOT NULL, `CLOUDNAME` VARCHAR(100) NOT NULL COLLATE 'utf8mb4_0900_ai_ci', `APIKEY` VARCHAR(100) NOT NULL COLLATE 'utf8mb4_0900_ai_ci', `APISECRET` VARCHAR(100) NOT NULL COLLATE 'utf8mb4_0900_ai_ci', `USE_LIMIT` INT(10) NULL DEFAULT '100', `USE_YN` CHAR(50) NULL DEFAULT 'Y' COLLATE 'utf8mb4_0900_ai_ci', PRIMARY KEY (`SEQ`, `COMPNO`, `CLOUDNAME`) USING BTREE )COLLATE='utf8mb4_0900_ai_ci' ENGINE=InnoDB; ALTER TABLE userinf DROP INDEX `USERID`, DROP PRIMARY KEY; ALTER TABLE SHOPADDRNAVERSTOREDTL DROP INDEX SEQ; ALTER TABLE SHOP11STADDIDTL DROP INDEX SEQ; ALTER TABLE SHOPADDRKAKAODTL DROP INDEX SEQ; ALTER TABLE SHOPALWAYZADDDTL DROP INDEX SEQ; ALTER TABLE SHOPAUCTION2ADDDTL DROP INDEX SEQ; ALTER TABLE SHOPAUCTIONADDDTL DROP INDEX SEQ; ALTER TABLE SHOPCAFE24ADDDTL DROP INDEX SEQ; ALTER TABLE SHOPCOUPANGADDIDTL DROP INDEX SEQ; ALTER TABLE SHOPINTERPARKADDIDTL DROP INDEX SEQ; ALTER TABLE SHOPLOTTEONADDDTL DROP INDEX SEQ; ALTER TABLE SHOPMELCHIADDIDTL DROP INDEX SEQ; ALTER TABLE SHOPTMONADDIDTL DROP INDEX SEQ; ALTER TABLE SHOPSSGADDIDTL DROP INDEX SEQ; ALTER TABLE SHOPWEMARKETADDDTL DROP INDEX SEQ; ALTER TABLE SHOPADDRAUCTIONDTL DROP INDEX SEQ; ALTER TABLE SHOPADDRCAFE24DTL DROP INDEX SEQ; ALTER TABLE SHOPADDRCOUPANGDTL DROP INDEX SEQ; ALTER TABLE SHOPADDRGMARKETDTL DROP INDEX SEQ; ALTER TABLE SHOPADDRINTERPARKDTL DROP INDEX SEQ; ALTER TABLE SHOPADDRTMONDTL DROP INDEX SEQ; ALTER TABLE SHOPTOSSSHOPPINGADDDTL ADD CONSTRAINT shoptossshoppingadddtl_pk PRIMARY KEY (SEQ); ALTER TABLE SHOPGMARKET2ADDDTL ADD CONSTRAINT shopgmarket2adddtl_pk PRIMARY KEY (SEQ); ALTER TABLE SHOPGMARKETADDDTL ADD CONSTRAINT shopgmarketadddtl_pk PRIMARY KEY (SEQ); CREATE TABLE `OWNERCLAN_MY_ITEMS` ( `SHOPCD` VARCHAR(10) NOT NULL, `SHOPSEQ` INT NOT NULL, `SHOPPINGID` VARCHAR(50) NOT NULL, `COMPANY_GOODS_CD` VARCHAR(50) NOT NULL, PRIMARY KEY (`SHOPCD`,`SHOPSEQ`,`SHOPPINGID`,`COMPANY_GOODS_CD`) ) ENGINE=INNODB DEFAULT CHARSET=UTF8MB4 COLLATE=UTF8MB4_0900_AI_CI; ALTER TABLE SYSTEMCONF ADD STARTMENU varchar(10) DEFAULT 'N' NULL COMMENT '시작메뉴 설정 - 엠링크'; ALTER TABLE SYSTEMCONF ADD Y_STARTMENU varchar(10) DEFAULT 'N' NULL COMMENT '시작메뉴 설정 - 옐림'; CREATE TABLE `SHOPMALLMAPPING` ( `SHOPCD` VARCHAR(10) NOT NULL, `SHOPSEQ` INT NOT NULL, `SHOPPINGID` VARCHAR(50) NOT NULL, `MAPPINGKEY` VARCHAR(70) CHARACTER SET UTF8MB4 COLLATE UTF8MB4_0900_AI_CI NOT NULL, PRIMARY KEY (`SHOPCD`,`SHOPSEQ`,`SHOPPINGID`,`MAPPINGKEY`) ) ENGINE=INNODB DEFAULT CHARSET=UTF8MB4 COLLATE=UTF8MB4_0900_AI_CI; INSERT INTO CLOUDINARYAPIINFO (SEQ, COMPNO, CLOUDNAME, APIKEY, APISECRET, USE_LIMIT, USE_YN) VALUES ('0', '0', 'dw.kdjsystem.com', '1', '1', '700', 'Y'); INSERT INTO CLOUDINARYAPIINFO (SEQ, COMPNO, CLOUDNAME, APIKEY, APISECRET, USE_LIMIT, USE_YN) VALUES ('1', '0', 'itsm.kdjsystem.com', '1', '1', '900', 'Y'); INSERT INTO CLOUDINARYAPIINFO (SEQ, COMPNO, CLOUDNAME, APIKEY, APISECRET, USE_LIMIT, USE_YN) VALUES ('1', '0', 'mlink.kdjsystem.com', '1', '0', '900', 'Y'); INSERT INTO CLOUDINARYAPIINFO (SEQ, COMPNO, CLOUDNAME, APIKEY, APISECRET, USE_LIMIT, USE_YN) VALUES ('1', '0', 'itsm2.kdjsystem.com', '1', '0', '900', 'Y'); INSERT INTO CLOUDINARYAPIINFO (SEQ, COMPNO, CLOUDNAME, APIKEY, APISECRET, USE_LIMIT, USE_YN) VALUES ('1', '0', 'itsm3.kdjsystem.com', '1', '0', '900', 'Y'); SET GLOBAL wait_timeout = 345600; SET GLOBAL interactive_timeout = 345600; SET GLOBAL mysqlx_wait_timeout = 345600; DROP TABLE sch_prodinfo; CREATE TABLE sch_prodinfo ( `RUNID` VARCHAR(36) NOT NULL COLLATE 'utf8mb4_0900_ai_ci', `PRODSEQ` VARCHAR(100) NOT NULL COLLATE 'utf8mb4_0900_ai_ci', PRIMARY KEY (`RUNID`, `PRODSEQ`) USING HASH, INDEX `RUNID` (`RUNID`) USING HASH ) COLLATE='utf8mb4_0900_ai_ci' ENGINE=MEMORY; INSERT INTO SHOPDELIVERYS(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ) VALUES('SHOP0110', '0002', '건영택배', 0, '건영택배', NULL, NULL); INSERT INTO SHOPDELIVERYS(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ) VALUES('SHOP0110', '0005', 'GS25편의점택배', 0, 'GS25편의점택배', NULL, NULL); INSERT INTO SHOPDELIVERYS(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ) VALUES('SHOP0110', '0006', 'CJ대한통운', 0, 'CJ 대한통운', NULL, NULL); INSERT INTO SHOPDELIVERYS(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ) VALUES('SHOP0110', '0007', '아주택배', 0, '아주택배', NULL, NULL); INSERT INTO SHOPDELIVERYS(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ) VALUES('SHOP0110', '0009', '오렌지택배', 0, '오렌지택배', NULL, NULL); INSERT INTO SHOPDELIVERYS(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ) VALUES('SHOP0110', '0010', '오세기고구려', 0, '오세기고구려', NULL, NULL); INSERT INTO SHOPDELIVERYS(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ) VALUES('SHOP0110', '0011', '용마로지스', 0, '용마로지스', NULL, NULL); INSERT INTO SHOPDELIVERYS(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ) VALUES('SHOP0110', '0012', '우체국택배', 0, '우체국택배', NULL, NULL); INSERT INTO SHOPDELIVERYS(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ) VALUES('SHOP0110', '0013', '우체국(등기,소포 우편)', 0, '우체국(등기,소포 우편)', NULL, NULL); INSERT INTO SHOPDELIVERYS(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ) VALUES('SHOP0110', '0014', '이젠택배', 0, '이젠택배', NULL, NULL); INSERT INTO SHOPDELIVERYS(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ) VALUES('SHOP0110', '0015', '이클라인', 0, '이클라인', NULL, NULL); INSERT INTO SHOPDELIVERYS(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ) VALUES('SHOP0110', '0016', '일양택배', 0, '일양택배', NULL, NULL); INSERT INTO SHOPDELIVERYS(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ) VALUES('SHOP0110', '0017', '트라넷', 0, '트라넷', NULL, NULL); INSERT INTO SHOPDELIVERYS(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ) VALUES('SHOP0110', '0018', '한진택배', 0, '한진택배', NULL, NULL); INSERT INTO SHOPDELIVERYS(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ) VALUES('SHOP0110', '0019', '롯데택배', 0, '롯데택배', NULL, NULL); INSERT INTO SHOPDELIVERYS(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ) VALUES('SHOP0110', '0021', 'KGB특급택배', 0, 'KGB특급택배', NULL, NULL); INSERT INTO SHOPDELIVERYS(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ) VALUES('SHOP0110', '0022', 'KGB택배', 0, 'KGB택배', NULL, NULL); INSERT INTO SHOPDELIVERYS(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ) VALUES('SHOP0110', '0037', '우리택배', 0, '우리택배', NULL, NULL); INSERT INTO SHOPDELIVERYS(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ) VALUES('SHOP0110', '0038', '코덱스택배', 0, '코덱스택배', NULL, NULL); INSERT INTO SHOPDELIVERYS(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ) VALUES('SHOP0110', '0039', '경동택배', 0, '경동택배', NULL, NULL); INSERT INTO SHOPDELIVERYS(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ) VALUES('SHOP0110', '0040', '스피디익스프레스', 0, '스피디익스프레스', NULL, NULL); INSERT INTO SHOPDELIVERYS(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ) VALUES('SHOP0110', '0041', '고구려택배', 0, '고구려택배', NULL, NULL); INSERT INTO SHOPDELIVERYS(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ) VALUES('SHOP0110', '0042', '양양택배', 0, '양양택배', NULL, NULL); INSERT INTO SHOPDELIVERYS(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ) VALUES('SHOP0110', '0043', '대신택배', 0, '대신택배', NULL, NULL); INSERT INTO SHOPDELIVERYS(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ) VALUES('SHOP0110', '0044', '천일택배', 0, '천일택배', NULL, NULL); INSERT INTO SHOPDELIVERYS(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ) VALUES('SHOP0110', '0045', '하이브랜로지스', 0, '하이브랜로지스', NULL, NULL); INSERT INTO SHOPDELIVERYS(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ) VALUES('SHOP0110', '0046', '호남택배', 0, '호남택배', NULL, NULL); INSERT INTO SHOPDELIVERYS(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ) VALUES('SHOP0110', '0047', '동서택배', 0, '동서택배', NULL, NULL); INSERT INTO SHOPDELIVERYS(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ) VALUES('SHOP0110', '0048', '한국택배', 0, '한국택배', NULL, NULL); INSERT INTO SHOPDELIVERYS(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ) VALUES('SHOP0110', '0049', '이트랜스택배', 0, '이트랜스택배', NULL, NULL); INSERT INTO SHOPDELIVERYS(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ) VALUES('SHOP0110', '0050', '이패밀리', 0, '이패밀리', NULL, NULL); INSERT INTO SHOPDELIVERYS(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ) VALUES('SHOP0110', '0051', '하나로택배', 0, '하나로택배', NULL, NULL); INSERT INTO SHOPDELIVERYS(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ) VALUES('SHOP0110', '0077', '합동택배', 0, '합동택배', NULL, NULL); INSERT INTO SHOPDELIVERYS(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ) VALUES('SHOP0110', '0220', '성원글로벌', 0, '성원글로벌', NULL, NULL); INSERT INTO SHOPDELIVERYS(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ) VALUES('SHOP0110', '1075', '세방택배', 0, '세방택배', NULL, NULL); INSERT INTO SHOPDELIVERYS(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ) VALUES('SHOP0110', '1076', '농협택배', 0, '농협택배', NULL, NULL); INSERT INTO SHOPDELIVERYS(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ) VALUES('SHOP0110', '1078', 'CU편의점택배', 0, 'CU편의점택배', NULL, NULL); ALTER TABLE SCHEDUINFO ADD JOBEXE71 char(1) NULL COMMENT '월~목 도매 동기화'; ALTER TABLE SCHEDUINFO ADD JOBEXE72 char(1) NULL COMMENT '금 도매 동기화'; ALTER TABLE SCHEDUINFO ADD JOBEXE73 char(1) NULL COMMENT '토 도매 동기화'; ALTER TABLE SCHEDUINFO ADD JOBEXE74 char(1) NULL COMMENT '일 도매 동기화'; UPDATE SHOPDELIVERYS SET DLVNM='롯데택배', EXPRESS_URL_ID=0, DOSIN_CODE='롯데택배(구 현대택배)', SERVICE_YN='Y', EXP_SEQ=3 WHERE SHOPCD='SHOP0110' AND DLVID='0019'; UPDATE SHOPDELIVERYS SET DLVNM='롯데택배', EXPRESS_URL_ID=0, DOSIN_CODE='롯데택배(구 현대택배)', SERVICE_YN=NULL, EXP_SEQ=NULL WHERE SHOPCD='SHOP9982' AND DLVID='20026'; ALTER TABLE SHOPTOSSSHOPPINGADDDTL ADD IMGTEXTEXCLUDEYN char(1) DEFAULT 'N' NULL COMMENT '텍스트 포함 이미지 등록 제외 여부 - 등록 : Y, 제외 : N'; ALTER TABLE SCHEDUINFO ADD NAVERPRODCHK2 CHAR(1) NULL COMMENT '네이버 판매종료 상품 삭제여부'; ALTER TABLE SET_SCHEDUINFO ADD NAVERPRODCHK2 CHAR(1) NULL COMMENT '네이버 판매종료 상품 삭제여부'; ALTER TABLE CLOUDINARYAPIINFO ADD ID varchar(100) NULL COMMENT '아이디'; ALTER TABLE CLOUDINARYAPIINFO ADD PW varchar(100) NULL COMMENT '비밀번호'; UPDATE SHOPINFO SET SHOPNM='바이즐',CUSTNM='(주)인터파크커머스',SHOPURL='https://seller.buyzle.co.kr/login' WHERE SHOPCD='shop0004'; ALTER TABLE SHOPAUCTION2ADDDTL ADD USEADDITIONALDELIVERYTYPEYN CHAR(1) DEFAULT 'Y' NULL; ALTER TABLE SHOPGMARKET2ADDDTL ADD USEADDITIONALDELIVERYTYPEYN CHAR(1) DEFAULT 'Y' NULL; INSERT INTO COM_CODE_DETAIL (CODE_MNG, CODE, NAME, USE_YN) VALUES('PRODUCT_SEND', '9100', '전송오류', 'Y'); ALTER TABLE SYSTEMCONF ADD COLUMN SELFCHANGEYN CHAR(1) NULL DEFAULT 'N' AFTER Y_STARTMENU, ADD COLUMN SELFMOD_NO VARCHAR(19) NULL DEFAULT '' AFTER SELFCHANGEYN; ALTER TABLE shopcategorys DROP KEY SHOPCD_CODE_ESMCODE; ALTER TABLE category DROP KEY ID; ALTER TABLE SHOPADDRNAVERSTOREDTL ADD REVIEWUNEXPOSEREASON varchar(100) DEFAULT NULL NULL COMMENT '리뷰노출 - 노출안함 사유'; CREATE TABLE `AUTO_STOP_SEARCH_SET` ( `SEQ` INT NOT NULL AUTO_INCREMENT, `NAME` VARCHAR(300) NOT NULL, `CONTENT` TEXT, PRIMARY KEY (`NAME`), UNIQUE KEY `AUTO_STOP_SEARCH_SET_UNIQUE` (`SEQ`) ) ENGINE=INNODB AUTO_INCREMENT=11 DEFAULT CHARSET=UTF8MB4 COLLATE=UTF8MB4_0900_AI_CI COMMENT='옐림 자동 선택 세트 테이블'; ALTER TABLE SHOPGMARKET2ADDDTL ADD BUNDLEDSHIPPINGCONDITION varchar(50) NULL COMMENT '조건부 무료 배송 - 무료 배송 조건 금액'; ALTER TABLE SHOPAUCTION2ADDDTL ADD BUNDLEDSHIPPINGCONDITION varchar(50) NULL COMMENT '조건부 무료 배송 - 무료 배송 조건 금액'; ALTER TABLE qnatemp ADD MAPPINGUSE char(1) NULL; ALTER TABLE qnatemp ADD MAPPINGKEYWORD varchar(1000) NULL; ALTER TABLE qnatemp ADD MAPPINGSHOP varchar(500) NULL; ALTER TABLE SET_SCHE_MST MODIFY COLUMN USESETDAY VARCHAR(40) CHARACTER SET UTF8MB4 COLLATE UTF8MB4_0900_AI_CI NULL; CREATE TABLE INDEX_DISTRIBUTION ( `ID` int NOT NULL AUTO_INCREMENT, `VERSION` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL , `TARGET_TABLE` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL , `SQL_TEXT` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci , `EXECUTE_AFTER` datetime DEFAULT NULL , `EXECUTED_FLAG` tinyint(1) DEFAULT NULL , `RESULT_MSG` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL , `executed_at` datetime DEFAULT NULL , PRIMARY KEY (`ID`) ) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; INSERT INTO mlink.index_distribution (ID, VERSION, TARGET_TABLE, SQL_TEXT, EXECUTE_AFTER, EXECUTED_FLAG, RESULT_MSG, executed_at) VALUES(1, '2025-08-21-01', 'SHOPPRODINFO', 'ALTER TABLE SHOPPRODINFO ADD INDEX idx_shopprodinfo_GOODS_NM (COMPNO,GOODS_NM(50)),ALGORITHM=INPLACE, LOCK=NONE', '2025-08-22 02:00:00.0', 0, 'Duplicate key name ''idx_shopprodinfo_GOODS_NM''', '2025-08-22 12:12:14.0'); INSERT INTO mlink.index_distribution (ID, VERSION, TARGET_TABLE, SQL_TEXT, EXECUTE_AFTER, EXECUTED_FLAG, RESULT_MSG, executed_at) VALUES(2, '2025-08-21-01', 'SHOPPRODINFO', 'ALTER TABLE SHOPPRODINFO ADD INDEX idx_shopprodinfo_PARTNER_ID (COMPNO,PARTNER_ID),ALGORITHM=INPLACE, LOCK=NONE ', '2025-08-22 02:00:00.0', 0, 'Duplicate key name ''idx_shopprodinfo_PARTNER_ID''', '2025-08-22 12:12:14.0'); INSERT INTO mlink.index_distribution (ID, VERSION, TARGET_TABLE, SQL_TEXT, EXECUTE_AFTER, EXECUTED_FLAG, RESULT_MSG, executed_at) VALUES(3, '2025-08-21-01', 'SHOPPRODINFO', 'ALTER TABLE SHOPPRODINFO ADD INDEX idx_shopprodinfo_GOODS_SEARCH (COMPNO,GOODS_SEARCH(50)),ALGORITHM=INPLACE, LOCK=NONE ', '2025-08-22 02:00:00.0', 0, 'Duplicate key name ''idx_shopprodinfo_GOODS_SEARCH''', '2025-08-22 12:12:14.0'); INSERT INTO mlink.index_distribution (ID, VERSION, TARGET_TABLE, SQL_TEXT, EXECUTE_AFTER, EXECUTED_FLAG, RESULT_MSG, executed_at) VALUES(4, '2025-08-21-01', 'SHOPPRODINFO', 'ALTER TABLE SHOPPRODINFO ADD INDEX idx_shopprodinfo_GMCATEGNM (COMPNO,GMCATEGNM(50)),ALGORITHM=INPLACE, LOCK=NONE ', '2025-08-22 02:00:00.0', 0, 'Duplicate key name ''idx_shopprodinfo_GMCATEGNM''', '2025-08-22 12:12:14.0'); INSERT INTO mlink.index_distribution (ID, VERSION, TARGET_TABLE, SQL_TEXT, EXECUTE_AFTER, EXECUTED_FLAG, RESULT_MSG, executed_at) VALUES(5, '2025-08-21-01', 'SHOPPRODINFO', 'ALTER TABLE SHOPPRODINFO ADD INDEX idx_shopprodinfo_DELV_TYPE (COMPNO,DELV_TYPE),ALGORITHM=INPLACE, LOCK=NONE', '2025-08-22 02:00:00.0', 0, 'Duplicate key name ''idx_shopprodinfo_DELV_TYPE''', '2025-08-22 12:12:14.0'); INSERT INTO mlink.index_distribution (ID, VERSION, TARGET_TABLE, SQL_TEXT, EXECUTE_AFTER, EXECUTED_FLAG, RESULT_MSG, executed_at) VALUES(6, '2025-08-21-01', 'SHOPPRODINFO', 'ALTER TABLE SHOPPRODINFO ADD INDEX idx_shopprodinfo_IS_OVERSEAS (COMPNO,IS_OVERSEAS),ALGORITHM=INPLACE, LOCK=NONE ', '2025-08-22 02:00:00.0', 0, 'Duplicate key name ''idx_shopprodinfo_IS_OVERSEAS''', '2025-08-22 12:12:14.0'); INSERT INTO mlink.index_distribution (ID, VERSION, TARGET_TABLE, SQL_TEXT, EXECUTE_AFTER, EXECUTED_FLAG, RESULT_MSG, executed_at) VALUES(7, '2025-08-21-01', 'SHOPPRODINFO', 'ALTER TABLE SHOPPRODINFO ADD INDEX idx_shopprodinfo_ADULT (COMPNO,ADULT),ALGORITHM=INPLACE, LOCK=NONE', '2025-08-22 02:00:00.0', 0, 'Duplicate key name ''idx_shopprodinfo_ADULT''', '2025-08-22 12:12:14.0'); INSERT INTO mlink.index_distribution (ID, VERSION, TARGET_TABLE, SQL_TEXT, EXECUTE_AFTER, EXECUTED_FLAG, RESULT_MSG, executed_at) VALUES(8, '2025-08-21-01', 'SHOPPRODINFO', 'ALTER TABLE SHOPPRODINFO ADD INDEX idx_shopprodinfo_GOODS_COST (COMPNO,SHOPSENDSTATUS,GOODS_COST,CLASS_CD3,COMPAYNY_GOODS_CD),ALGORITHM=INPLACE, LOCK=NONE', '2025-08-22 02:00:00.0', 0, 'Duplicate key name ''idx_shopprodinfo_GOODS_COST''', '2025-08-22 12:12:14.0'); INSERT INTO mlink.index_distribution (ID, VERSION, TARGET_TABLE, SQL_TEXT, EXECUTE_AFTER, EXECUTED_FLAG, RESULT_MSG, executed_at) VALUES(9, '2025-08-21-01', 'SHOPPRODINFO', 'ALTER TABLE SHOPPRODINFO ADD INDEX idx_shopprodinfo_DESCRITION (COMPNO,SHOPSENDSTATUS,DESCRITION,CLASS_CD3,COMPAYNY_GOODS_CD),ALGORITHM=INPLACE, LOCK=NONE', '2025-08-22 02:00:00.0', 0, 'Duplicate key name ''idx_shopprodinfo_DESCRITION''', '2025-08-22 12:12:14.0'); INSERT INTO mlink.index_distribution (ID, VERSION, TARGET_TABLE, SQL_TEXT, EXECUTE_AFTER, EXECUTED_FLAG, RESULT_MSG, executed_at) VALUES(10, '2025-08-21-01', 'SHOPPRODINFO', 'ALTER TABLE SHOPPRODINFO ADD INDEX idx_shopprodinfo_IMG_PATH22 (COMPNO,IMG_PATH22(30)),ALGORITHM=INPLACE, LOCK=NONE', '2025-08-22 02:00:00.0', 0, 'Duplicate key name ''idx_shopprodinfo_IMG_PATH22''', '2025-08-22 12:12:14.0'); INSERT INTO mlink.index_distribution (ID, VERSION, TARGET_TABLE, SQL_TEXT, EXECUTE_AFTER, EXECUTED_FLAG, RESULT_MSG, executed_at) VALUES(11, '2025-08-21-01', 'SHOPPRODINFO', 'ALTER TABLE SHOPPRODINFO ADD INDEX idx_shopprodinfo_CHAR_1_NM (COMPNO,CHAR_1_NM),ALGORITHM=INPLACE, LOCK=NONE', '2025-08-22 02:00:00.0', 0, 'Duplicate key name ''idx_shopprodinfo_CHAR_1_NM''', '2025-08-22 12:12:14.0'); INSERT INTO mlink.index_distribution (ID, VERSION, TARGET_TABLE, SQL_TEXT, EXECUTE_AFTER, EXECUTED_FLAG, RESULT_MSG, executed_at) VALUES(12, '2025-08-21-01', 'SHOPPRODINFO', 'ALTER TABLE SHOPPRODINFO ADD INDEX idx_shopprodinfo_DELV_COST (COMPNO,SHOPSENDSTATUS,DELV_COST,CLASS_CD3,COMPAYNY_GOODS_CD),ALGORITHM=INPLACE, LOCK=NONE', '2025-08-22 02:00:00.0', 0, 'Duplicate key name ''idx_shopprodinfo_DELV_COST''', '2025-08-22 12:12:14.0'); INSERT INTO mlink.index_distribution (ID, VERSION, TARGET_TABLE, SQL_TEXT, EXECUTE_AFTER, EXECUTED_FLAG, RESULT_MSG, executed_at) VALUES(13, '2025-08-21-01', 'SHOPPRODINFO', 'ALTER TABLE SHOPPRODINFO ADD INDEX idx_shopprodinfo_RETURN_DELV_COST (COMPNO,SHOPSENDSTATUS,RETURN_DELV_COST,CLASS_CD3,COMPAYNY_GOODS_CD),ALGORITHM=INPLACE, LOCK=NONE', '2025-08-22 02:00:00.0', 0, 'Duplicate key name ''idx_shopprodinfo_RETURN_DELV_COST''', '2025-08-22 12:12:14.0'); INSERT INTO mlink.index_distribution (ID, VERSION, TARGET_TABLE, SQL_TEXT, EXECUTE_AFTER, EXECUTED_FLAG, RESULT_MSG, executed_at) VALUES(14, '2025-08-21-01', 'SHOPPRODINFO', 'ALTER TABLE SHOPPRODINFO ADD INDEX idx_shopprodinfo_STATUS (COMPNO,STATUS),ALGORITHM=INPLACE, LOCK=NONE', '2025-08-22 02:00:00.0', 0, 'Duplicate key name ''idx_shopprodinfo_STATUS''', '2025-08-22 12:12:14.0'); INSERT INTO mlink.index_distribution (ID, VERSION, TARGET_TABLE, SQL_TEXT, EXECUTE_AFTER, EXECUTED_FLAG, RESULT_MSG, executed_at) VALUES(15, '2025-08-21-01', 'SHOPPRODINFO', 'ALTER TABLE SHOPPRODINFO ADD INDEX idx_shopprodinfo_INSERTDT (COMPNO,INSERTDT),ALGORITHM=INPLACE, LOCK=NONE', '2025-08-22 02:00:00.0', 0, 'Duplicate key name ''idx_shopprodinfo_INSERTDT''', '2025-08-22 12:12:14.0'); INSERT INTO mlink.index_distribution (ID, VERSION, TARGET_TABLE, SQL_TEXT, EXECUTE_AFTER, EXECUTED_FLAG, RESULT_MSG, executed_at) VALUES(16, '2025-08-21-01', 'SHOPPRODINFO', 'ALTER TABLE SHOPPRODINFO ADD INDEX idx_shopprodinfo_MODIFYDT (COMPNO,MODIFYDT),ALGORITHM=INPLACE, LOCK=NONE', '2025-08-22 02:00:00.0', 0, 'Duplicate key name ''idx_shopprodinfo_MODIFYDT''', '2025-08-22 12:12:15.0'); INSERT INTO mlink.index_distribution (ID, VERSION, TARGET_TABLE, SQL_TEXT, EXECUTE_AFTER, EXECUTED_FLAG, RESULT_MSG, executed_at) VALUES(17, '2025-08-21-01', 'SHOPPRODINFO', 'ALTER TABLE SHOPPRODINFO ADD FULLTEXT INDEX idx_shopprodinfo_SHOPMODIFYCONTENT (SHOPMODIFYCONTENT), ALGORITHM=INPLACE, LOCK=SHARED', '2025-08-22 02:00:00.0', 0, 'Duplicate key name ''idx_shopprodinfo_SHOPMODIFYCONTENT''', '2025-08-22 12:12:15.0'); INSERT INTO mlink.index_distribution (ID, VERSION, TARGET_TABLE, SQL_TEXT, EXECUTE_AFTER, EXECUTED_FLAG, RESULT_MSG, executed_at) VALUES(18, '2025-08-21-01', 'SHOPPRODIN', 'ALTER TABLE SHOPPRODIN ADD INDEX idx_shopprodin_GOODS_NM (COMPNO,GOODS_NM(50)),ALGORITHM=INPLACE, LOCK=NONE ', '2025-08-22 02:00:00.0', 0, 'Duplicate key name ''idx_shopprodin_GOODS_NM''', '2025-08-22 12:12:15.0'); INSERT INTO mlink.index_distribution (ID, VERSION, TARGET_TABLE, SQL_TEXT, EXECUTE_AFTER, EXECUTED_FLAG, RESULT_MSG, executed_at) VALUES(19, '2025-08-21-01', 'SHOPPRODIN', 'ALTER TABLE SHOPPRODIN ADD INDEX idx_shopprodin_PARTNER_ID (COMPNO,PARTNER_ID),ALGORITHM=INPLACE, LOCK=NONE', '2025-08-22 02:00:00.0', 0, 'Duplicate key name ''idx_shopprodin_PARTNER_ID''', '2025-08-22 12:12:15.0'); INSERT INTO mlink.index_distribution (ID, VERSION, TARGET_TABLE, SQL_TEXT, EXECUTE_AFTER, EXECUTED_FLAG, RESULT_MSG, executed_at) VALUES(20, '2025-08-21-01', 'SHOPPRODIN', 'ALTER TABLE SHOPPRODIN ADD INDEX idx_shopprodin_GOODS_SEARCH (COMPNO,GOODS_SEARCH(50)),ALGORITHM=INPLACE, LOCK=NONE ', '2025-08-22 02:00:00.0', 0, 'Duplicate key name ''idx_shopprodin_GOODS_SEARCH''', '2025-08-22 12:12:15.0'); INSERT INTO mlink.index_distribution (ID, VERSION, TARGET_TABLE, SQL_TEXT, EXECUTE_AFTER, EXECUTED_FLAG, RESULT_MSG, executed_at) VALUES(21, '2025-08-21-01', 'SHOPPRODIN', 'ALTER TABLE SHOPPRODIN ADD INDEX idx_shopprodin_GMCATEGNM (COMPNO,GMCATEGNM(50)),ALGORITHM=INPLACE, LOCK=NONE', '2025-08-22 02:00:00.0', 0, 'Duplicate key name ''idx_shopprodin_GMCATEGNM''', '2025-08-22 12:12:15.0'); INSERT INTO mlink.index_distribution (ID, VERSION, TARGET_TABLE, SQL_TEXT, EXECUTE_AFTER, EXECUTED_FLAG, RESULT_MSG, executed_at) VALUES(22, '2025-08-21-01', 'SHOPPRODIN', 'ALTER TABLE SHOPPRODIN ADD INDEX idx_shopprodin_DELV_TYPE (COMPNO,DELV_TYPE),ALGORITHM=INPLACE, LOCK=NONE', '2025-08-22 02:00:00.0', 0, 'Duplicate key name ''idx_shopprodin_DELV_TYPE''', '2025-08-22 12:12:15.0'); INSERT INTO mlink.index_distribution (ID, VERSION, TARGET_TABLE, SQL_TEXT, EXECUTE_AFTER, EXECUTED_FLAG, RESULT_MSG, executed_at) VALUES(23, '2025-08-21-01', 'SHOPPRODIN', 'ALTER TABLE SHOPPRODIN ADD INDEX idx_shopprodin_IS_OVERSEAS (COMPNO,IS_OVERSEAS),ALGORITHM=INPLACE, LOCK=NONE ', '2025-08-22 02:00:00.0', 0, 'Duplicate key name ''idx_shopprodin_IS_OVERSEAS''', '2025-08-22 12:12:15.0'); INSERT INTO mlink.index_distribution (ID, VERSION, TARGET_TABLE, SQL_TEXT, EXECUTE_AFTER, EXECUTED_FLAG, RESULT_MSG, executed_at) VALUES(24, '2025-08-21-01', 'SHOPPRODIN', 'ALTER TABLE SHOPPRODIN ADD INDEX idx_shopprodin_ADULT (COMPNO,ADULT),ALGORITHM=INPLACE, LOCK=NONE', '2025-08-22 02:00:00.0', 0, 'Duplicate key name ''idx_shopprodin_ADULT''', '2025-08-22 12:12:15.0'); INSERT INTO mlink.index_distribution (ID, VERSION, TARGET_TABLE, SQL_TEXT, EXECUTE_AFTER, EXECUTED_FLAG, RESULT_MSG, executed_at) VALUES(25, '2025-08-21-01', 'SHOPPRODIN', 'ALTER TABLE SHOPPRODIN ADD INDEX idx_shopprodin_GOODS_COST (COMPNO,GOODS_COST),ALGORITHM=INPLACE, LOCK=NONE ', '2025-08-22 02:00:00.0', 0, 'Duplicate key name ''idx_shopprodin_GOODS_COST''', '2025-08-22 12:12:15.0'); INSERT INTO mlink.index_distribution (ID, VERSION, TARGET_TABLE, SQL_TEXT, EXECUTE_AFTER, EXECUTED_FLAG, RESULT_MSG, executed_at) VALUES(26, '2025-08-21-01', 'SHOPPRODIN', 'ALTER TABLE SHOPPRODIN ADD INDEX idx_shopprodin_DESCRITION (COMPNO,DESCRITION),ALGORITHM=INPLACE, LOCK=NONE ', '2025-08-22 02:00:00.0', 0, 'Duplicate key name ''idx_shopprodin_DESCRITION''', '2025-08-22 12:12:15.0'); INSERT INTO mlink.index_distribution (ID, VERSION, TARGET_TABLE, SQL_TEXT, EXECUTE_AFTER, EXECUTED_FLAG, RESULT_MSG, executed_at) VALUES(27, '2025-08-21-01', 'SHOPPRODIN', 'ALTER TABLE SHOPPRODIN ADD INDEX idx_shopprodin_IMG_PATH22 (COMPNO,IMG_PATH22(30)),ALGORITHM=INPLACE, LOCK=NONE', '2025-08-22 02:00:00.0', 0, 'Duplicate key name ''idx_shopprodin_IMG_PATH22''', '2025-08-22 12:12:15.0'); INSERT INTO mlink.index_distribution (ID, VERSION, TARGET_TABLE, SQL_TEXT, EXECUTE_AFTER, EXECUTED_FLAG, RESULT_MSG, executed_at) VALUES(28, '2025-08-21-01', 'SHOPPRODIN', 'ALTER TABLE SHOPPRODIN ADD INDEX idx_shopprodin_CHAR_1_NM (COMPNO,CHAR_1_NM),ALGORITHM=INPLACE, LOCK=NONE', '2025-08-22 02:00:00.0', 0, 'Duplicate key name ''idx_shopprodin_CHAR_1_NM''', '2025-08-22 12:12:15.0'); INSERT INTO mlink.index_distribution (ID, VERSION, TARGET_TABLE, SQL_TEXT, EXECUTE_AFTER, EXECUTED_FLAG, RESULT_MSG, executed_at) VALUES(29, '2025-08-21-01', 'SHOPPRODIN', 'ALTER TABLE SHOPPRODIN ADD INDEX idx_shopprodin_DELV_COST (COMPNO,DELV_COST),ALGORITHM=INPLACE, LOCK=NONE', '2025-08-22 02:00:00.0', 0, 'Duplicate key name ''idx_shopprodin_DELV_COST''', '2025-08-22 12:12:15.0'); INSERT INTO mlink.index_distribution (ID, VERSION, TARGET_TABLE, SQL_TEXT, EXECUTE_AFTER, EXECUTED_FLAG, RESULT_MSG, executed_at) VALUES(30, '2025-08-21-01', 'SHOPPRODIN', 'ALTER TABLE SHOPPRODIN ADD INDEX idx_shopprodin_RETURN_DELV_COST (COMPNO,RETURN_DELV_COST),ALGORITHM=INPLACE, LOCK=NONE ', '2025-08-22 02:00:00.0', 0, 'Duplicate key name ''idx_shopprodin_RETURN_DELV_COST''', '2025-08-22 12:12:15.0'); INSERT INTO mlink.index_distribution (ID, VERSION, TARGET_TABLE, SQL_TEXT, EXECUTE_AFTER, EXECUTED_FLAG, RESULT_MSG, executed_at) VALUES(31, '2025-08-21-01', 'SHOPPRODIN', 'ALTER TABLE SHOPPRODIN ADD INDEX idx_shopprodin_STATUS (COMPNO,STATUS),ALGORITHM=INPLACE, LOCK=NONE', '2025-08-22 02:00:00.0', 0, 'Duplicate key name ''idx_shopprodin_STATUS''', '2025-08-22 12:12:15.0'); INSERT INTO mlink.index_distribution (ID, VERSION, TARGET_TABLE, SQL_TEXT, EXECUTE_AFTER, EXECUTED_FLAG, RESULT_MSG, executed_at) VALUES(32, '2025-08-21-01', 'SHOPPRODIN', 'ALTER TABLE SHOPPRODIN ADD INDEX idx_shopprodin_INSERTDT (COMPNO,INSERTDT),ALGORITHM=INPLACE, LOCK=NONE', '2025-08-22 02:00:00.0', 0, 'Duplicate key name ''idx_shopprodin_INSERTDT''', '2025-08-22 12:12:15.0'); INSERT INTO mlink.index_distribution (ID, VERSION, TARGET_TABLE, SQL_TEXT, EXECUTE_AFTER, EXECUTED_FLAG, RESULT_MSG, executed_at) VALUES(33, '2025-08-21-01', 'SHOPPRODIN', 'ALTER TABLE SHOPPRODIN ADD INDEX idx_shopprodin_MODIFYDT (COMPNO,MODIFYDT),ALGORITHM=INPLACE, LOCK=NONE', '2025-08-22 02:00:00.0', 0, 'Duplicate key name ''idx_shopprodin_MODIFYDT''', '2025-08-22 12:12:15.0'); INSERT INTO mlink.index_distribution (ID, VERSION, TARGET_TABLE, SQL_TEXT, EXECUTE_AFTER, EXECUTED_FLAG, RESULT_MSG, executed_at) VALUES(34, '2025-08-21-01', 'SHOPPRODIN', 'ALTER TABLE SHOPPRODIN ADD INDEX idx_shopprodin_GOODS_KEYWORD (COMPNO,GOODS_KEYWORD),ALGORITHM=INPLACE, LOCK=NONE', '2025-08-22 02:00:00.0', 0, 'Duplicate key name ''idx_shopprodin_GOODS_KEYWORD''', '2025-08-22 12:12:15.0'); INSERT INTO mlink.index_distribution (ID, VERSION, TARGET_TABLE, SQL_TEXT, EXECUTE_AFTER, EXECUTED_FLAG, RESULT_MSG, executed_at) VALUES(35, '2025-08-21-01', 'SHOPPRODIN', 'ALTER TABLE SHOPPRODIN ADD FULLTEXT INDEX idx_shopprodin_SHOPMODIFYCONTENT (SHOPMODIFYCONTENT),ALGORITHM=INPLACE,LOCK=SHARED', '2025-08-22 02:00:00.0', 0, 'Duplicate key name ''idx_shopprodin_SHOPMODIFYCONTENT''', '2025-08-22 12:12:15.0'); INSERT INTO mlink.index_distribution (ID, VERSION, TARGET_TABLE, SQL_TEXT, EXECUTE_AFTER, EXECUTED_FLAG, RESULT_MSG, executed_at) VALUES(36, '2025-08-21-01', 'SHOPPRODINFO', 'ALTER TABLE SHOPPRODINFO ADD INDEX idx_shopprodinfo_shopsendstat_class_prodseq_desc(COMPNO,SHOPSENDSTATUS,CLASS_CD3,COMPAYNY_GOODS_CD,PRODSEQ DESC),ALGORITHM=INPLACE, LOCK=NONE ', '2025-08-22 02:00:00.0', 0, 'Duplicate key name ''idx_shopprodinfo_shopsendstat_class_prodseq_desc''', '2025-08-22 12:12:15.0'); INSERT INTO mlink.index_distribution (ID, VERSION, TARGET_TABLE, SQL_TEXT, EXECUTE_AFTER, EXECUTED_FLAG, RESULT_MSG, executed_at) VALUES(37, '2025-08-21-01', 'SHOPPRODINFO', 'ALTER TABLE shopprodinfo RENAME INDEX COMPNO_GOODS_KEYWORD_STATUS TO idx_shopprodinfo_goods_keyword_status', '2025-08-22 02:00:00.0', 0, 'Key ''COMPNO_GOODS_KEYWORD_STATUS'' doesn''t exist in table ''shopprodinfo''', '2025-08-22 12:12:15.0'); INSERT INTO mlink.index_distribution (ID, VERSION, TARGET_TABLE, SQL_TEXT, EXECUTE_AFTER, EXECUTED_FLAG, RESULT_MSG, executed_at) VALUES(38, '2025-08-21-01', 'SHOPPRODINFO', 'ALTER TABLE shopprodinfo RENAME INDEX COMPNO_COMPAYNY_GOODS_CD TO idx_shopprodinfo_COMPAYNY_GOODS_CD', '2025-08-22 02:00:00.0', 0, 'Key ''COMPNO_COMPAYNY_GOODS_CD'' doesn''t exist in table ''shopprodinfo''', '2025-08-22 12:12:15.0'); INSERT INTO mlink.index_distribution (ID, VERSION, TARGET_TABLE, SQL_TEXT, EXECUTE_AFTER, EXECUTED_FLAG, RESULT_MSG, executed_at) VALUES(39, '2025-08-21-01', 'SHOPPRODIN', 'ALTER TABLE shopprodin RENAME INDEX COMPNO_SHOPSENDSTATUS TO idx_shopprodin_SHOPSENDSTATUS', '2025-08-22 02:00:00.0', 0, 'Key ''COMPNO_SHOPSENDSTATUS'' doesn''t exist in table ''shopprodin''', '2025-08-22 12:12:15.0'); INSERT INTO mlink.index_distribution (ID, VERSION, TARGET_TABLE, SQL_TEXT, EXECUTE_AFTER, EXECUTED_FLAG, RESULT_MSG, executed_at) VALUES(40, '2025-08-21-01', 'SHOPPRODIN', 'ALTER TABLE shopprodin RENAME INDEX COMPNO_SHOPPRODNO TO idx_shopprodin_SHOPPRODNO', '2025-08-22 02:00:00.0', 0, 'Key ''COMPNO_SHOPPRODNO'' doesn''t exist in table ''shopprodin''', '2025-08-22 12:12:15.0'); INSERT INTO mlink.index_distribution (ID, VERSION, TARGET_TABLE, SQL_TEXT, EXECUTE_AFTER, EXECUTED_FLAG, RESULT_MSG, executed_at) VALUES(41, '2025-08-21-01', 'SHOPPRODIN', 'ALTER TABLE shopprodin RENAME INDEX COMPNO_PRODSEQ TO idx_shopprodin_PRODSEQ', '2025-08-22 02:00:00.0', 0, 'Key ''COMPNO_PRODSEQ'' doesn''t exist in table ''shopprodin''', '2025-08-22 12:12:15.0'); INSERT INTO mlink.index_distribution (ID, VERSION, TARGET_TABLE, SQL_TEXT, EXECUTE_AFTER, EXECUTED_FLAG, RESULT_MSG, executed_at) VALUES(42, '2025-08-21-01', 'SHOPPRODIN', 'ALTER TABLE shopprodin RENAME INDEX COMPNO_COMPAYNY_GOODS_CD TO idx_shopprodin_COMPAYNY_GOODS_CD', '2025-08-22 02:00:00.0', 0, 'Key ''COMPNO_COMPAYNY_GOODS_CD'' doesn''t exist in table ''shopprodin''', '2025-08-22 12:12:15.0'); INSERT INTO mlink.index_distribution (ID, VERSION, TARGET_TABLE, SQL_TEXT, EXECUTE_AFTER, EXECUTED_FLAG, RESULT_MSG, executed_at) VALUES(43, '2025-08-21-01', 'SHOPPRODINFO', 'ALTER TABLE shopprodinfo RENAME INDEX COMPNO_STATUS TO idx_shopprodinfo_STATUS', '2025-08-22 02:00:00.0', 0, 'Key ''COMPNO_STATUS'' doesn''t exist in table ''shopprodinfo''', '2025-08-22 12:12:15.0'); INSERT INTO mlink.index_distribution (ID, VERSION, TARGET_TABLE, SQL_TEXT, EXECUTE_AFTER, EXECUTED_FLAG, RESULT_MSG, executed_at) VALUES(44, '2025-08-21-01', 'SHOPPRODIN', 'ALTER TABLE SHOPPRODIN ADD INDEX idx_shopprodin_class_shopcd_shopuserid_shopseq(`COMPNO`,`CLASS_CD3`,`SHOPCD`,`SHOP_USERID`,`SHOPSEQ`,`SHOPSENDSTATUS`),ALGORITHM=INPLACE, LOCK=NONE', '2025-08-22 02:00:00.0', 0, 'Duplicate key name ''idx_shopprodin_class_shopcd_shopuserid_shopseq''', '2025-08-22 12:12:15.0'); INSERT INTO mlink.index_distribution (ID, VERSION, TARGET_TABLE, SQL_TEXT, EXECUTE_AFTER, EXECUTED_FLAG, RESULT_MSG, executed_at) VALUES(45, '2025-08-21-01', 'SHOPPRODINFO', 'CREATE INDEX idx_shopprodinfo_compno_classcd3_goods ON SHOPPRODINFO(COMPNO, CLASS_CD3, COMPAYNY_GOODS_CD),ALGORITHM=INPLACE, LOCK=NONE', '2025-08-23 02:00:00', 0, '0', NULL); INSERT INTO mlink.index_distribution (ID, VERSION, TARGET_TABLE, SQL_TEXT, EXECUTE_AFTER, EXECUTED_FLAG, RESULT_MSG, executed_at) VALUES(46, '2025-08-21-01', 'SHOPPRODINFO', 'CREATE INDEX idx_shopprodinfo_compno_cost_status_goods_prodseq ON SHOPPRODINFO (COMPNO, GOODS_COST, SHOPSENDSTATUS, COMPAYNY_GOODS_CD, PRODSEQ),ALGORITHM=INPLACE, LOCK=NONE', '2025-08-23 02:00:00', 0, NULL, NULL); INSERT INTO mlink.index_distribution (ID, VERSION, TARGET_TABLE, SQL_TEXT, EXECUTE_AFTER, EXECUTED_FLAG, RESULT_MSG, executed_at) VALUES(47, '2025-08-21-01', 'SHOPPRODIN', 'ALTER TABLE SHOPPRODIN ADD INDEX idx_comno_prodseq_shopcd_shopseq_status (COMPNO, PRODSEQ, SHOPCD, SHOPSEQ, SHOPSENDSTATUS),ALGORITHM=INPLACE, LOCK=NONE', '2025-08-23 02:00:00', 0, NULL, NULL); INSERT INTO mlink.index_distribution (ID, VERSION, TARGET_TABLE, SQL_TEXT, EXECUTE_AFTER, EXECUTED_FLAG, RESULT_MSG, executed_at) VALUES(48, '2025-08-21-01', 'SHOPPRODINFO', 'CREATE INDEX idx_shopprodinfo_class_cd3_shopsendstat ON SHOPPRODINFO(COMPNO, CLASS_CD3, SHOPSENDSTATUS, COMPAYNY_GOODS_CD, PRODSEQ),ALGORITHM=INPLACE, LOCK=NONE', '2025-08-23 02:00:00', 0, NULL, NULL); UPDATE mlink.index_distribution SET VERSION='2025-08-21-01', TARGET_TABLE='SHOPPRODINFO', SQL_TEXT='ALTER TABLE SHOPPRODINFO ADD INDEX idx_shopprodinfo_GOODS_NM (COMPNO,GOODS_NM(50)),ALGORITHM=INPLACE, LOCK=NONE', EXECUTE_AFTER='2025-08-22 02:00:00.0', EXECUTED_FLAG=0, RESULT_MSG='Duplicate key name ''idx_shopprodinfo_GOODS_NM''', executed_at='2025-08-22 12:12:14.0' WHERE ID=1; UPDATE mlink.index_distribution SET VERSION='2025-08-21-01', TARGET_TABLE='SHOPPRODINFO', SQL_TEXT='ALTER TABLE SHOPPRODINFO ADD INDEX idx_shopprodinfo_PARTNER_ID (COMPNO,PARTNER_ID),ALGORITHM=INPLACE, LOCK=NONE ', EXECUTE_AFTER='2025-08-22 02:00:00.0', EXECUTED_FLAG=0, RESULT_MSG='Duplicate key name ''idx_shopprodinfo_PARTNER_ID''', executed_at='2025-08-22 12:12:14.0' WHERE ID=2; UPDATE mlink.index_distribution SET VERSION='2025-08-21-01', TARGET_TABLE='SHOPPRODINFO', SQL_TEXT='ALTER TABLE SHOPPRODINFO ADD INDEX idx_shopprodinfo_GOODS_SEARCH (COMPNO,GOODS_SEARCH(50)),ALGORITHM=INPLACE, LOCK=NONE ', EXECUTE_AFTER='2025-08-22 02:00:00.0', EXECUTED_FLAG=0, RESULT_MSG='Duplicate key name ''idx_shopprodinfo_GOODS_SEARCH''', executed_at='2025-08-22 12:12:14.0' WHERE ID=3; UPDATE mlink.index_distribution SET VERSION='2025-08-21-01', TARGET_TABLE='SHOPPRODINFO', SQL_TEXT='ALTER TABLE SHOPPRODINFO ADD INDEX idx_shopprodinfo_GMCATEGNM (COMPNO,GMCATEGNM(50)),ALGORITHM=INPLACE, LOCK=NONE ', EXECUTE_AFTER='2025-08-22 02:00:00.0', EXECUTED_FLAG=0, RESULT_MSG='Duplicate key name ''idx_shopprodinfo_GMCATEGNM''', executed_at='2025-08-22 12:12:14.0' WHERE ID=4; UPDATE mlink.index_distribution SET VERSION='2025-08-21-01', TARGET_TABLE='SHOPPRODINFO', SQL_TEXT='ALTER TABLE SHOPPRODINFO ADD INDEX idx_shopprodinfo_DELV_TYPE (COMPNO,DELV_TYPE),ALGORITHM=INPLACE, LOCK=NONE', EXECUTE_AFTER='2025-08-22 02:00:00.0', EXECUTED_FLAG=0, RESULT_MSG='Duplicate key name ''idx_shopprodinfo_DELV_TYPE''', executed_at='2025-08-22 12:12:14.0' WHERE ID=5; UPDATE mlink.index_distribution SET VERSION='2025-08-21-01', TARGET_TABLE='SHOPPRODINFO', SQL_TEXT='ALTER TABLE SHOPPRODINFO ADD INDEX idx_shopprodinfo_IS_OVERSEAS (COMPNO,IS_OVERSEAS),ALGORITHM=INPLACE, LOCK=NONE ', EXECUTE_AFTER='2025-08-22 02:00:00.0', EXECUTED_FLAG=0, RESULT_MSG='Duplicate key name ''idx_shopprodinfo_IS_OVERSEAS''', executed_at='2025-08-22 12:12:14.0' WHERE ID=6; UPDATE mlink.index_distribution SET VERSION='2025-08-21-01', TARGET_TABLE='SHOPPRODINFO', SQL_TEXT='ALTER TABLE SHOPPRODINFO ADD INDEX idx_shopprodinfo_ADULT (COMPNO,ADULT),ALGORITHM=INPLACE, LOCK=NONE', EXECUTE_AFTER='2025-08-22 02:00:00.0', EXECUTED_FLAG=0, RESULT_MSG='Duplicate key name ''idx_shopprodinfo_ADULT''', executed_at='2025-08-22 12:12:14.0' WHERE ID=7; UPDATE mlink.index_distribution SET VERSION='2025-08-21-01', TARGET_TABLE='SHOPPRODINFO', SQL_TEXT='ALTER TABLE SHOPPRODINFO ADD INDEX idx_shopprodinfo_GOODS_COST (COMPNO,SHOPSENDSTATUS,GOODS_COST,CLASS_CD3,COMPAYNY_GOODS_CD),ALGORITHM=INPLACE, LOCK=NONE', EXECUTE_AFTER='2025-08-22 02:00:00.0', EXECUTED_FLAG=0, RESULT_MSG='Duplicate key name ''idx_shopprodinfo_GOODS_COST''', executed_at='2025-08-22 12:12:14.0' WHERE ID=8; UPDATE mlink.index_distribution SET VERSION='2025-08-21-01', TARGET_TABLE='SHOPPRODINFO', SQL_TEXT='ALTER TABLE SHOPPRODINFO ADD INDEX idx_shopprodinfo_DESCRITION (COMPNO,SHOPSENDSTATUS,DESCRITION,CLASS_CD3,COMPAYNY_GOODS_CD),ALGORITHM=INPLACE, LOCK=NONE', EXECUTE_AFTER='2025-08-22 02:00:00.0', EXECUTED_FLAG=0, RESULT_MSG='Duplicate key name ''idx_shopprodinfo_DESCRITION''', executed_at='2025-08-22 12:12:14.0' WHERE ID=9; UPDATE mlink.index_distribution SET VERSION='2025-08-21-01', TARGET_TABLE='SHOPPRODINFO', SQL_TEXT='ALTER TABLE SHOPPRODINFO ADD INDEX idx_shopprodinfo_IMG_PATH22 (COMPNO,IMG_PATH22(30)),ALGORITHM=INPLACE, LOCK=NONE', EXECUTE_AFTER='2025-08-22 02:00:00.0', EXECUTED_FLAG=0, RESULT_MSG='Duplicate key name ''idx_shopprodinfo_IMG_PATH22''', executed_at='2025-08-22 12:12:14.0' WHERE ID=10; UPDATE mlink.index_distribution SET VERSION='2025-08-21-01', TARGET_TABLE='SHOPPRODINFO', SQL_TEXT='ALTER TABLE SHOPPRODINFO ADD INDEX idx_shopprodinfo_CHAR_1_NM (COMPNO,CHAR_1_NM),ALGORITHM=INPLACE, LOCK=NONE', EXECUTE_AFTER='2025-08-22 02:00:00.0', EXECUTED_FLAG=0, RESULT_MSG='Duplicate key name ''idx_shopprodinfo_CHAR_1_NM''', executed_at='2025-08-22 12:12:14.0' WHERE ID=11; UPDATE mlink.index_distribution SET VERSION='2025-08-21-01', TARGET_TABLE='SHOPPRODINFO', SQL_TEXT='ALTER TABLE SHOPPRODINFO ADD INDEX idx_shopprodinfo_DELV_COST (COMPNO,SHOPSENDSTATUS,DELV_COST,CLASS_CD3,COMPAYNY_GOODS_CD),ALGORITHM=INPLACE, LOCK=NONE', EXECUTE_AFTER='2025-08-22 02:00:00.0', EXECUTED_FLAG=0, RESULT_MSG='Duplicate key name ''idx_shopprodinfo_DELV_COST''', executed_at='2025-08-22 12:12:14.0' WHERE ID=12; UPDATE mlink.index_distribution SET VERSION='2025-08-21-01', TARGET_TABLE='SHOPPRODINFO', SQL_TEXT='ALTER TABLE SHOPPRODINFO ADD INDEX idx_shopprodinfo_RETURN_DELV_COST (COMPNO,SHOPSENDSTATUS,RETURN_DELV_COST,CLASS_CD3,COMPAYNY_GOODS_CD),ALGORITHM=INPLACE, LOCK=NONE', EXECUTE_AFTER='2025-08-22 02:00:00.0', EXECUTED_FLAG=0, RESULT_MSG='Duplicate key name ''idx_shopprodinfo_RETURN_DELV_COST''', executed_at='2025-08-22 12:12:14.0' WHERE ID=13; UPDATE mlink.index_distribution SET VERSION='2025-08-21-01', TARGET_TABLE='SHOPPRODINFO', SQL_TEXT='ALTER TABLE SHOPPRODINFO ADD INDEX idx_shopprodinfo_STATUS (COMPNO,STATUS),ALGORITHM=INPLACE, LOCK=NONE', EXECUTE_AFTER='2025-08-22 02:00:00.0', EXECUTED_FLAG=0, RESULT_MSG='Duplicate key name ''idx_shopprodinfo_STATUS''', executed_at='2025-08-22 12:12:14.0' WHERE ID=14; UPDATE mlink.index_distribution SET VERSION='2025-08-21-01', TARGET_TABLE='SHOPPRODINFO', SQL_TEXT='ALTER TABLE SHOPPRODINFO ADD INDEX idx_shopprodinfo_INSERTDT (COMPNO,INSERTDT),ALGORITHM=INPLACE, LOCK=NONE', EXECUTE_AFTER='2025-08-22 02:00:00.0', EXECUTED_FLAG=0, RESULT_MSG='Duplicate key name ''idx_shopprodinfo_INSERTDT''', executed_at='2025-08-22 12:12:14.0' WHERE ID=15; UPDATE mlink.index_distribution SET VERSION='2025-08-21-01', TARGET_TABLE='SHOPPRODINFO', SQL_TEXT='ALTER TABLE SHOPPRODINFO ADD INDEX idx_shopprodinfo_MODIFYDT (COMPNO,MODIFYDT),ALGORITHM=INPLACE, LOCK=NONE', EXECUTE_AFTER='2025-08-22 02:00:00.0', EXECUTED_FLAG=0, RESULT_MSG='Duplicate key name ''idx_shopprodinfo_MODIFYDT''', executed_at='2025-08-22 12:12:15.0' WHERE ID=16; UPDATE mlink.index_distribution SET VERSION='2025-08-21-01', TARGET_TABLE='SHOPPRODINFO', SQL_TEXT='ALTER TABLE SHOPPRODINFO ADD FULLTEXT INDEX idx_shopprodinfo_SHOPMODIFYCONTENT (SHOPMODIFYCONTENT), ALGORITHM=INPLACE, LOCK=SHARED', EXECUTE_AFTER='2025-08-22 02:00:00.0', EXECUTED_FLAG=0, RESULT_MSG='Duplicate key name ''idx_shopprodinfo_SHOPMODIFYCONTENT''', executed_at='2025-08-22 12:12:15.0' WHERE ID=17; UPDATE mlink.index_distribution SET VERSION='2025-08-21-01', TARGET_TABLE='SHOPPRODIN', SQL_TEXT='ALTER TABLE SHOPPRODIN ADD INDEX idx_shopprodin_GOODS_NM (COMPNO,GOODS_NM(50)),ALGORITHM=INPLACE, LOCK=NONE ', EXECUTE_AFTER='2025-08-22 02:00:00.0', EXECUTED_FLAG=0, RESULT_MSG='Duplicate key name ''idx_shopprodin_GOODS_NM''', executed_at='2025-08-22 12:12:15.0' WHERE ID=18; UPDATE mlink.index_distribution SET VERSION='2025-08-21-01', TARGET_TABLE='SHOPPRODIN', SQL_TEXT='ALTER TABLE SHOPPRODIN ADD INDEX idx_shopprodin_PARTNER_ID (COMPNO,PARTNER_ID),ALGORITHM=INPLACE, LOCK=NONE', EXECUTE_AFTER='2025-08-22 02:00:00.0', EXECUTED_FLAG=0, RESULT_MSG='Duplicate key name ''idx_shopprodin_PARTNER_ID''', executed_at='2025-08-22 12:12:15.0' WHERE ID=19; UPDATE mlink.index_distribution SET VERSION='2025-08-21-01', TARGET_TABLE='SHOPPRODIN', SQL_TEXT='ALTER TABLE SHOPPRODIN ADD INDEX idx_shopprodin_GOODS_SEARCH (COMPNO,GOODS_SEARCH(50)),ALGORITHM=INPLACE, LOCK=NONE ', EXECUTE_AFTER='2025-08-22 02:00:00.0', EXECUTED_FLAG=0, RESULT_MSG='Duplicate key name ''idx_shopprodin_GOODS_SEARCH''', executed_at='2025-08-22 12:12:15.0' WHERE ID=20; UPDATE mlink.index_distribution SET VERSION='2025-08-21-01', TARGET_TABLE='SHOPPRODIN', SQL_TEXT='ALTER TABLE SHOPPRODIN ADD INDEX idx_shopprodin_GMCATEGNM (COMPNO,GMCATEGNM(50)),ALGORITHM=INPLACE, LOCK=NONE', EXECUTE_AFTER='2025-08-22 02:00:00.0', EXECUTED_FLAG=0, RESULT_MSG='Duplicate key name ''idx_shopprodin_GMCATEGNM''', executed_at='2025-08-22 12:12:15.0' WHERE ID=21; UPDATE mlink.index_distribution SET VERSION='2025-08-21-01', TARGET_TABLE='SHOPPRODIN', SQL_TEXT='ALTER TABLE SHOPPRODIN ADD INDEX idx_shopprodin_DELV_TYPE (COMPNO,DELV_TYPE),ALGORITHM=INPLACE, LOCK=NONE', EXECUTE_AFTER='2025-08-22 02:00:00.0', EXECUTED_FLAG=0, RESULT_MSG='Duplicate key name ''idx_shopprodin_DELV_TYPE''', executed_at='2025-08-22 12:12:15.0' WHERE ID=22; UPDATE mlink.index_distribution SET VERSION='2025-08-21-01', TARGET_TABLE='SHOPPRODIN', SQL_TEXT='ALTER TABLE SHOPPRODIN ADD INDEX idx_shopprodin_IS_OVERSEAS (COMPNO,IS_OVERSEAS),ALGORITHM=INPLACE, LOCK=NONE ', EXECUTE_AFTER='2025-08-22 02:00:00.0', EXECUTED_FLAG=0, RESULT_MSG='Duplicate key name ''idx_shopprodin_IS_OVERSEAS''', executed_at='2025-08-22 12:12:15.0' WHERE ID=23; UPDATE mlink.index_distribution SET VERSION='2025-08-21-01', TARGET_TABLE='SHOPPRODIN', SQL_TEXT='ALTER TABLE SHOPPRODIN ADD INDEX idx_shopprodin_ADULT (COMPNO,ADULT),ALGORITHM=INPLACE, LOCK=NONE', EXECUTE_AFTER='2025-08-22 02:00:00.0', EXECUTED_FLAG=0, RESULT_MSG='Duplicate key name ''idx_shopprodin_ADULT''', executed_at='2025-08-22 12:12:15.0' WHERE ID=24; UPDATE mlink.index_distribution SET VERSION='2025-08-21-01', TARGET_TABLE='SHOPPRODIN', SQL_TEXT='ALTER TABLE SHOPPRODIN ADD INDEX idx_shopprodin_GOODS_COST (COMPNO,GOODS_COST),ALGORITHM=INPLACE, LOCK=NONE ', EXECUTE_AFTER='2025-08-22 02:00:00.0', EXECUTED_FLAG=0, RESULT_MSG='Duplicate key name ''idx_shopprodin_GOODS_COST''', executed_at='2025-08-22 12:12:15.0' WHERE ID=25; UPDATE mlink.index_distribution SET VERSION='2025-08-21-01', TARGET_TABLE='SHOPPRODIN', SQL_TEXT='ALTER TABLE SHOPPRODIN ADD INDEX idx_shopprodin_DESCRITION (COMPNO,DESCRITION),ALGORITHM=INPLACE, LOCK=NONE ', EXECUTE_AFTER='2025-08-22 02:00:00.0', EXECUTED_FLAG=0, RESULT_MSG='Duplicate key name ''idx_shopprodin_DESCRITION''', executed_at='2025-08-22 12:12:15.0' WHERE ID=26; UPDATE mlink.index_distribution SET VERSION='2025-08-21-01', TARGET_TABLE='SHOPPRODIN', SQL_TEXT='ALTER TABLE SHOPPRODIN ADD INDEX idx_shopprodin_IMG_PATH22 (COMPNO,IMG_PATH22(30)),ALGORITHM=INPLACE, LOCK=NONE', EXECUTE_AFTER='2025-08-22 02:00:00.0', EXECUTED_FLAG=0, RESULT_MSG='Duplicate key name ''idx_shopprodin_IMG_PATH22''', executed_at='2025-08-22 12:12:15.0' WHERE ID=27; UPDATE mlink.index_distribution SET VERSION='2025-08-21-01', TARGET_TABLE='SHOPPRODIN', SQL_TEXT='ALTER TABLE SHOPPRODIN ADD INDEX idx_shopprodin_CHAR_1_NM (COMPNO,CHAR_1_NM),ALGORITHM=INPLACE, LOCK=NONE', EXECUTE_AFTER='2025-08-22 02:00:00.0', EXECUTED_FLAG=0, RESULT_MSG='Duplicate key name ''idx_shopprodin_CHAR_1_NM''', executed_at='2025-08-22 12:12:15.0' WHERE ID=28; UPDATE mlink.index_distribution SET VERSION='2025-08-21-01', TARGET_TABLE='SHOPPRODIN', SQL_TEXT='ALTER TABLE SHOPPRODIN ADD INDEX idx_shopprodin_DELV_COST (COMPNO,DELV_COST),ALGORITHM=INPLACE, LOCK=NONE', EXECUTE_AFTER='2025-08-22 02:00:00.0', EXECUTED_FLAG=0, RESULT_MSG='Duplicate key name ''idx_shopprodin_DELV_COST''', executed_at='2025-08-22 12:12:15.0' WHERE ID=29; UPDATE mlink.index_distribution SET VERSION='2025-08-21-01', TARGET_TABLE='SHOPPRODIN', SQL_TEXT='ALTER TABLE SHOPPRODIN ADD INDEX idx_shopprodin_RETURN_DELV_COST (COMPNO,RETURN_DELV_COST),ALGORITHM=INPLACE, LOCK=NONE ', EXECUTE_AFTER='2025-08-22 02:00:00.0', EXECUTED_FLAG=0, RESULT_MSG='Duplicate key name ''idx_shopprodin_RETURN_DELV_COST''', executed_at='2025-08-22 12:12:15.0' WHERE ID=30; UPDATE mlink.index_distribution SET VERSION='2025-08-21-01', TARGET_TABLE='SHOPPRODIN', SQL_TEXT='ALTER TABLE SHOPPRODIN ADD INDEX idx_shopprodin_STATUS (COMPNO,STATUS),ALGORITHM=INPLACE, LOCK=NONE', EXECUTE_AFTER='2025-08-22 02:00:00.0', EXECUTED_FLAG=0, RESULT_MSG='Duplicate key name ''idx_shopprodin_STATUS''', executed_at='2025-08-22 12:12:15.0' WHERE ID=31; UPDATE mlink.index_distribution SET VERSION='2025-08-21-01', TARGET_TABLE='SHOPPRODIN', SQL_TEXT='ALTER TABLE SHOPPRODIN ADD INDEX idx_shopprodin_INSERTDT (COMPNO,INSERTDT),ALGORITHM=INPLACE, LOCK=NONE', EXECUTE_AFTER='2025-08-22 02:00:00.0', EXECUTED_FLAG=0, RESULT_MSG='Duplicate key name ''idx_shopprodin_INSERTDT''', executed_at='2025-08-22 12:12:15.0' WHERE ID=32; UPDATE mlink.index_distribution SET VERSION='2025-08-21-01', TARGET_TABLE='SHOPPRODIN', SQL_TEXT='ALTER TABLE SHOPPRODIN ADD INDEX idx_shopprodin_MODIFYDT (COMPNO,MODIFYDT),ALGORITHM=INPLACE, LOCK=NONE', EXECUTE_AFTER='2025-08-22 02:00:00.0', EXECUTED_FLAG=0, RESULT_MSG='Duplicate key name ''idx_shopprodin_MODIFYDT''', executed_at='2025-08-22 12:12:15.0' WHERE ID=33; UPDATE mlink.index_distribution SET VERSION='2025-08-21-01', TARGET_TABLE='SHOPPRODIN', SQL_TEXT='ALTER TABLE SHOPPRODIN ADD INDEX idx_shopprodin_GOODS_KEYWORD (COMPNO,GOODS_KEYWORD),ALGORITHM=INPLACE, LOCK=NONE', EXECUTE_AFTER='2025-08-22 02:00:00.0', EXECUTED_FLAG=0, RESULT_MSG='Duplicate key name ''idx_shopprodin_GOODS_KEYWORD''', executed_at='2025-08-22 12:12:15.0' WHERE ID=34; UPDATE mlink.index_distribution SET VERSION='2025-08-21-01', TARGET_TABLE='SHOPPRODIN', SQL_TEXT='ALTER TABLE SHOPPRODIN ADD FULLTEXT INDEX idx_shopprodin_SHOPMODIFYCONTENT (SHOPMODIFYCONTENT),ALGORITHM=INPLACE,LOCK=SHARED', EXECUTE_AFTER='2025-08-22 02:00:00.0', EXECUTED_FLAG=0, RESULT_MSG='Duplicate key name ''idx_shopprodin_SHOPMODIFYCONTENT''', executed_at='2025-08-22 12:12:15.0' WHERE ID=35; UPDATE mlink.index_distribution SET VERSION='2025-08-21-01', TARGET_TABLE='SHOPPRODINFO', SQL_TEXT='ALTER TABLE SHOPPRODINFO ADD INDEX idx_shopprodinfo_shopsendstat_class_prodseq_desc(COMPNO,SHOPSENDSTATUS,CLASS_CD3,COMPAYNY_GOODS_CD,PRODSEQ DESC),ALGORITHM=INPLACE, LOCK=NONE ', EXECUTE_AFTER='2025-08-22 02:00:00.0', EXECUTED_FLAG=0, RESULT_MSG='Duplicate key name ''idx_shopprodinfo_shopsendstat_class_prodseq_desc''', executed_at='2025-08-22 12:12:15.0' WHERE ID=36; UPDATE mlink.index_distribution SET VERSION='2025-08-21-01', TARGET_TABLE='SHOPPRODINFO', SQL_TEXT='ALTER TABLE shopprodinfo RENAME INDEX COMPNO_GOODS_KEYWORD_STATUS TO idx_shopprodinfo_goods_keyword_status', EXECUTE_AFTER='2025-08-22 02:00:00.0', EXECUTED_FLAG=0, RESULT_MSG='Key ''COMPNO_GOODS_KEYWORD_STATUS'' doesn''t exist in table ''shopprodinfo''', executed_at='2025-08-22 12:12:15.0' WHERE ID=37; UPDATE mlink.index_distribution SET VERSION='2025-08-21-01', TARGET_TABLE='SHOPPRODINFO', SQL_TEXT='ALTER TABLE shopprodinfo RENAME INDEX COMPNO_COMPAYNY_GOODS_CD TO idx_shopprodinfo_COMPAYNY_GOODS_CD', EXECUTE_AFTER='2025-08-22 02:00:00.0', EXECUTED_FLAG=0, RESULT_MSG='Key ''COMPNO_COMPAYNY_GOODS_CD'' doesn''t exist in table ''shopprodinfo''', executed_at='2025-08-22 12:12:15.0' WHERE ID=38; UPDATE mlink.index_distribution SET VERSION='2025-08-21-01', TARGET_TABLE='SHOPPRODIN', SQL_TEXT='ALTER TABLE shopprodin RENAME INDEX COMPNO_SHOPSENDSTATUS TO idx_shopprodin_SHOPSENDSTATUS', EXECUTE_AFTER='2025-08-22 02:00:00.0', EXECUTED_FLAG=0, RESULT_MSG='Key ''COMPNO_SHOPSENDSTATUS'' doesn''t exist in table ''shopprodin''', executed_at='2025-08-22 12:12:15.0' WHERE ID=39; UPDATE mlink.index_distribution SET VERSION='2025-08-21-01', TARGET_TABLE='SHOPPRODIN', SQL_TEXT='ALTER TABLE shopprodin RENAME INDEX COMPNO_SHOPPRODNO TO idx_shopprodin_SHOPPRODNO', EXECUTE_AFTER='2025-08-22 02:00:00.0', EXECUTED_FLAG=0, RESULT_MSG='Key ''COMPNO_SHOPPRODNO'' doesn''t exist in table ''shopprodin''', executed_at='2025-08-22 12:12:15.0' WHERE ID=40; UPDATE mlink.index_distribution SET VERSION='2025-08-21-01', TARGET_TABLE='SHOPPRODIN', SQL_TEXT='ALTER TABLE shopprodin RENAME INDEX COMPNO_PRODSEQ TO idx_shopprodin_PRODSEQ', EXECUTE_AFTER='2025-08-22 02:00:00.0', EXECUTED_FLAG=0, RESULT_MSG='Key ''COMPNO_PRODSEQ'' doesn''t exist in table ''shopprodin''', executed_at='2025-08-22 12:12:15.0' WHERE ID=41; UPDATE mlink.index_distribution SET VERSION='2025-08-21-01', TARGET_TABLE='SHOPPRODIN', SQL_TEXT='ALTER TABLE shopprodin RENAME INDEX COMPNO_COMPAYNY_GOODS_CD TO idx_shopprodin_COMPAYNY_GOODS_CD', EXECUTE_AFTER='2025-08-22 02:00:00.0', EXECUTED_FLAG=0, RESULT_MSG='Key ''COMPNO_COMPAYNY_GOODS_CD'' doesn''t exist in table ''shopprodin''', executed_at='2025-08-22 12:12:15.0' WHERE ID=42; UPDATE mlink.index_distribution SET VERSION='2025-08-21-01', TARGET_TABLE='SHOPPRODINFO', SQL_TEXT='ALTER TABLE shopprodinfo RENAME INDEX COMPNO_STATUS TO idx_shopprodinfo_STATUS', EXECUTE_AFTER='2025-08-22 02:00:00.0', EXECUTED_FLAG=0, RESULT_MSG='Key ''COMPNO_STATUS'' doesn''t exist in table ''shopprodinfo''', executed_at='2025-08-22 12:12:15.0' WHERE ID=43; UPDATE mlink.index_distribution SET VERSION='2025-08-21-01', TARGET_TABLE='SHOPPRODIN', SQL_TEXT='ALTER TABLE SHOPPRODIN ADD INDEX idx_shopprodin_class_shopcd_shopuserid_shopseq(`COMPNO`,`CLASS_CD3`,`SHOPCD`,`SHOP_USERID`,`SHOPSEQ`,`SHOPSENDSTATUS`),ALGORITHM=INPLACE, LOCK=NONE', EXECUTE_AFTER='2025-08-22 02:00:00.0', EXECUTED_FLAG=0, RESULT_MSG='Duplicate key name ''idx_shopprodin_class_shopcd_shopuserid_shopseq''', executed_at='2025-08-22 12:12:15.0' WHERE ID=44; UPDATE mlink.index_distribution SET VERSION='2025-08-21-01', TARGET_TABLE='SHOPPRODINFO', SQL_TEXT='ALTER TABLE SHOPPRODINFO ADD INDEX idx_shopprodinfo_compno_classcd3_goods(COMPNO, CLASS_CD3, COMPAYNY_GOODS_CD),ALGORITHM=INPLACE, LOCK=NONE', EXECUTE_AFTER='2025-08-23 02:00:00', EXECUTED_FLAG=0, RESULT_MSG='0', executed_at=NULL WHERE ID=45; UPDATE mlink.index_distribution SET VERSION='2025-08-21-01', TARGET_TABLE='SHOPPRODINFO', SQL_TEXT='ALTER TABLE SHOPPRODINFO ADD INDEX idx_shopprodinfo_compno_cost_status_goods_prodseq (COMPNO, GOODS_COST, SHOPSENDSTATUS, COMPAYNY_GOODS_CD, PRODSEQ),ALGORITHM=INPLACE, LOCK=NONE', EXECUTE_AFTER='2025-08-23 02:00:00', EXECUTED_FLAG=0, RESULT_MSG=NULL, executed_at=NULL WHERE ID=46; UPDATE mlink.index_distribution SET VERSION='2025-08-21-01', TARGET_TABLE='SHOPPRODIN', SQL_TEXT='ALTER TABLE SHOPPRODIN ADD INDEX idx_comno_prodseq_shopcd_shopseq_status (COMPNO, PRODSEQ, SHOPCD, SHOPSEQ, SHOPSENDSTATUS),ALGORITHM=INPLACE, LOCK=NONE', EXECUTE_AFTER='2025-08-23 02:00:00', EXECUTED_FLAG=0, RESULT_MSG=NULL, executed_at=NULL WHERE ID=47; UPDATE mlink.index_distribution SET VERSION='2025-08-21-01', TARGET_TABLE='SHOPPRODINFO', SQL_TEXT='ALTER TABLE SHOPPRODINFO ADD INDEX idx_shopprodinfo_class_cd3_shopsendstat(COMPNO, CLASS_CD3, SHOPSENDSTATUS, COMPAYNY_GOODS_CD, PRODSEQ),ALGORITHM=INPLACE, LOCK=NONE', EXECUTE_AFTER='2025-08-23 02:00:00', EXECUTED_FLAG=0, RESULT_MSG=NULL, executed_at=NULL WHERE ID=48; update mlink.index_distribution set EXECUTE_AFTER = '2025-08-23 02:00:00.0'; ALTER TABLE SCHEDUINFO ADD ELEVENSTPRODCHK1 CHAR(1) NULL; ALTER TABLE SCHEDUINFO ADD ELEVENSTPRODCHK2 CHAR(1) NULL; ALTER TABLE SCHEDUINFO ADD KAKAOSTORECHK1 CHAR(1) NULL; ALTER TABLE SET_SCHEDUINFO ADD ELEVENSTPRODCHK1 CHAR(1) NULL; ALTER TABLE SET_SCHEDUINFO ADD ELEVENSTPRODCHK2 CHAR(1) NULL; ALTER TABLE SET_SCHEDUINFO ADD KAKAOSTORECHK1 CHAR(1) NULL; ALTER TABLE SCHEDUINFO ADD NAVERSTOPSELLINGPRODCHK CHAR(1) NULL COMMENT '네이버 판매중지 상품 삭제여부'; ALTER TABLE SCHEDUINFO ADD ELEVENSTSTOPSELLINGPRODCHK CHAR(1) NULL COMMENT '11번가 판매중지 상품 삭제여부'; ALTER TABLE SET_SCHEDUINFO ADD NAVERSTOPSELLINGPRODCHK CHAR(1) NULL COMMENT '네이버 판매중지 상품 삭제여부'; ALTER TABLE SET_SCHEDUINFO ADD ELEVENSTSTOPSELLINGPRODCHK CHAR(1) NULL COMMENT '11번가 판매중지 상품 삭제여부'; ALTER TABLE SHOPALWAYZADDDTL MODIFY COLUMN SHOPCATSITENM VARCHAR(100) CHARACTER SET UTF8MB4 COLLATE UTF8MB4_0900_AI_CI NULL; ALTER TABLE SHOPTOSSSHOPPINGADDDTL MODIFY COLUMN SHOPCATSITENM VARCHAR(100) CHARACTER SET UTF8MB4 COLLATE UTF8MB4_0900_AI_CI NULL; ALTER TABLE SYSTEMCONF MODIFY COLUMN SELFMOD_NO VARCHAR(30) CHARACTER SET UTF8MB4 COLLATE UTF8MB4_0900_AI_CI DEFAULT '' NULL; CREATE TABLE `JOBLOG` ( `SEQ` int NOT NULL AUTO_INCREMENT, `JOBDATE` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, `JOBTYPE` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, `JOBMAIN` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, `JOBSUB` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, `JOBDETAIL` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, `PRODCD` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, `SHOPPRODNO` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, `SHOPCD` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, `SHOPUSERID` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, `NICKNAME` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, `SHOPSEQ` int DEFAULT NULL, `ORDID` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, `PRODUCTNAME` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, `OPTIONNAME` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, `SALECNT` int DEFAULT NULL, `SALECOST` int DEFAULT NULL, `RECEIVE_NAME` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, `JOBRESULT` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, `LOGMESSAGE` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci, PRIMARY KEY (`SEQ`) ) ENGINE=InnoDB AUTO_INCREMENT=1143952 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; CREATE TABLE `DISPLAY_COLUMN_SETTING` ( `CLASS_NM` VARCHAR(100) NOT NULL, `ITEM_NM` VARCHAR(100) NOT NULL, `MAP_FIELD` VARCHAR(100) DEFAULT NULL, `DEFAULT_USE_STATE` CHAR(1) DEFAULT NULL, `DEFAULT_SEQ` INT DEFAULT NULL, `DEFAULT_WIDTH` INT DEFAULT NULL, `USER_USE_STATE` CHAR(1) DEFAULT NULL, `USER_SEQ` INT DEFAULT NULL, `USER_WIDTH` INT DEFAULT NULL, `USER_NM` VARCHAR(100) DEFAULT NULL, `BASE_NM` VARCHAR(100) DEFAULT NULL, `BASE_SEQ` INT DEFAULT NULL, `BASE_POSITION` CHAR(1) DEFAULT NULL, PRIMARY KEY (`CLASS_NM`,`ITEM_NM`) ) ENGINE=INNODB DEFAULT CHARSET=UTF8MB4 COLLATE=UTF8MB4_0900_AI_CI; CREATE TABLE `USER_EXCEL_FORM_DETAIL` ( `DETAIL_SEQ` INT NOT NULL AUTO_INCREMENT, `MASTER_SEQ` INT NOT NULL, `COL_INDEX` VARCHAR(5) NOT NULL, `COL_NAME` VARCHAR(200) DEFAULT NULL, `COL_VALUE` VARCHAR(200) DEFAULT NULL, `COL_MEMO` VARCHAR(500) DEFAULT NULL, `CREATE_DT` DATETIME DEFAULT CURRENT_TIMESTAMP, `MODIFY_DT` DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`DETAIL_SEQ`), KEY `FK_EXCEL_FORM_MASTER` (`MASTER_SEQ`), CONSTRAINT `FK_EXCEL_FORM_MASTER` FOREIGN KEY (`MASTER_SEQ`) REFERENCES `USER_EXCEL_FORM_MASTER` (`SEQ`) ON DELETE CASCADE ) ENGINE=INNODB AUTO_INCREMENT=2040 DEFAULT CHARSET=UTF8MB4 COLLATE=UTF8MB4_0900_AI_CI; CREATE TABLE `USER_EXCEL_FORM_MASTER` ( `SEQ` INT NOT NULL AUTO_INCREMENT, `NAME` VARCHAR(100) NOT NULL, `USE_YN` CHAR(1) DEFAULT 'Y', `TOP_INSERT_ROW` INT DEFAULT '0', `CREATE_DT` DATETIME DEFAULT CURRENT_TIMESTAMP, `CREATE_USER` VARCHAR(100) DEFAULT NULL, `MODIFY_DT` DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `MODIFY_USER` VARCHAR(100) DEFAULT NULL, `GUBUN1` VARCHAR(100) DEFAULT NULL, `GUBUN2` VARCHAR(100) DEFAULT NULL, `GUBUN3` VARCHAR(100) DEFAULT NULL, `GUBUN4` VARCHAR(100) DEFAULT NULL, PRIMARY KEY (`SEQ`) ) ENGINE=INNODB AUTO_INCREMENT=54 DEFAULT CHARSET=UTF8MB4 COLLATE=UTF8MB4_0900_AI_CI; ALTER TABLE JOBLOG ADD INTERFACE_FLAG char(1) DEFAULT 'N' NULL; ALTER TABLE SYSTEMCONF ADD MODIFY_YES_SALE_ACTION char(1) DEFAULT 'K' NULL; ALTER TABLE SYSTEMCONF ADD MODIFY_NO_SALE_ACTION char(1) DEFAULT 'D' NULL; ALTER TABLE SYSTEMCONF ADD SOLDOUT_YES_SALE_ACTION char(1) DEFAULT 'D' NULL; ALTER TABLE SYSTEMCONF ADD SOLDOUT_NO_SALE_ACTION char(1) DEFAULT 'D' NULL;