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);