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;