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='';

ALTER TABLE SHOPADDRKAKAODTL
	ADD COLUMN `JJMT_DELV_YN` VARCHAR(10) NULL DEFAULT NULL AFTER `ASGUIDEWORDS`,
	ADD COLUMN `JEJUMOUNTYN` VARCHAR(10) NULL DEFAULT NULL AFTER `JJMT_DELV_YN`,
	ADD COLUMN `JEJUDELIVERYFEE` VARCHAR(200) NULL DEFAULT NULL AFTER `JEJUMOUNTYN`,
	ADD COLUMN `MOUNTDELIVERYFEE` VARCHAR(200) NULL DEFAULT NULL AFTER `JEJUDELIVERYFEE`; 

ALTER TABLE SYSTEMCONF
	ADD COLUMN `URL_PRODRECV` VARCHAR(50) NULL DEFAULT NULL AFTER `AUTOSTAT`;

ALTER TABLE SYSTEMCONF
	CHANGE COLUMN `PRODSEARCHYN` `PRODSEARCHYN` CHAR(1) NULL DEFAULT NULL COMMENT 'backjob실행시 수정대기' COLLATE 'utf8mb4_0900_ai_ci' AFTER `DELIVERYNM`,
	ADD COLUMN `PRODSEARCHYN2` CHAR(1) NULL DEFAULT NULL COMMENT 'backjob실행시 자체수정' AFTER `PRODSEARCHYN`;
	
ALTER TABLE DELIVERYS
	ADD COLUMN `USERID` VARCHAR(50) NULL DEFAULT NULL AFTER `EXPCD_LOTT`,
	ADD COLUMN `USERPW` VARCHAR(50) NULL DEFAULT NULL AFTER `USERID`,
	ADD COLUMN `SERVICE_YN` VARCHAR(1) NULL DEFAULT NULL AFTER `USERPW`;	

ALTER TABLE SHOPADDRNAVERSTOREDTL
	ADD COLUMN `DELIVERYCOMPANYID` VARCHAR(50) NULL DEFAULT NULL COMMENT '택배사 이름' AFTER `ADDOPTIONR`,
	ADD COLUMN `DELIVERYCOMPANYCODE` VARCHAR(50) NULL DEFAULT NULL COMMENT '택배사 코드' AFTER `DELIVERYCOMPANYID`;
	
ALTER TABLE QNALIST
	ADD COLUMN `SNO` VARCHAR(50) NULL DEFAULT NULL COMMENT '고도몰 sno 고유 번호' AFTER `ANSNO`,
	ADD COLUMN `SECRET` VARCHAR(50) NULL DEFAULT NULL COMMENT '고도몰 비밀글 여부' AFTER `SNO`;	
	
ALTER TABLE SHOPPRODINFO MODIFY COLUMN DESCRITION varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT 0 NULL COMMENT '관리자메모(판매량)';	
ALTER TABLE SHOPPRODINFO CHANGE COLUMN `CERT_TYPE` `CERT_TYPE` INT(10) NULL DEFAULT '0' COMMENT '상품인증타입  0:인증대상아님, 1:인증대상, 2:상세설명에 표기' AFTER `GOODS_REMARKS`;

ALTER TABLE SHOPINTERPARKADDIDTL ADD COLUMN  IMG_ANGLE DOUBLE DEFAULT 0 COMMENT '이미지 회전 각도';
ALTER TABLE SHOPINTERPARKADDIDTL ADD COLUMN  IMG_SCALE_PERCENT DOUBLE DEFAULT 0 COMMENT '확대율';	
ALTER TABLE SHOP11STADDIDTL ADD COLUMN  IMG_ANGLE DOUBLE DEFAULT 0 COMMENT '이미지 회전 각도';
ALTER TABLE SHOP11STADDIDTL ADD COLUMN  IMG_SCALE_PERCENT DOUBLE DEFAULT 0 COMMENT '확대율';	
ALTER TABLE SHOPCOUPANGADDIDTL ADD COLUMN  IMG_ANGLE DOUBLE DEFAULT 0 COMMENT '이미지 회전 각도';
ALTER TABLE SHOPCOUPANGADDIDTL ADD COLUMN  IMG_SCALE_PERCENT DOUBLE DEFAULT 0 COMMENT '확대율';	
ALTER TABLE SHOPAUCTION2ADDDTL ADD COLUMN  IMG_ANGLE DOUBLE DEFAULT 0 COMMENT '이미지 회전 각도';
ALTER TABLE SHOPAUCTION2ADDDTL ADD COLUMN  IMG_SCALE_PERCENT DOUBLE DEFAULT 0 COMMENT '확대율';	
ALTER TABLE SHOPAUCTIONADDDTL ADD COLUMN  IMG_ANGLE DOUBLE DEFAULT 0 COMMENT '이미지 회전 각도';
ALTER TABLE SHOPAUCTIONADDDTL ADD COLUMN  IMG_SCALE_PERCENT DOUBLE DEFAULT 0 COMMENT '확대율';	
ALTER TABLE SHOPGMARKETADDDTL ADD COLUMN  IMG_ANGLE DOUBLE DEFAULT 0 COMMENT '이미지 회전 각도';
ALTER TABLE SHOPGMARKETADDDTL ADD COLUMN  IMG_SCALE_PERCENT DOUBLE DEFAULT 0 COMMENT '확대율';	
ALTER TABLE SHOPGMARKET2ADDDTL ADD COLUMN  IMG_ANGLE DOUBLE DEFAULT 0 COMMENT '이미지 회전 각도';
ALTER TABLE SHOPGMARKET2ADDDTL ADD COLUMN  IMG_SCALE_PERCENT DOUBLE DEFAULT 0 COMMENT '확대율';	
ALTER TABLE SHOPADDRNAVERSTOREDTL ADD COLUMN  IMG_ANGLE DOUBLE DEFAULT 0 COMMENT '이미지 회전 각도';
ALTER TABLE SHOPADDRNAVERSTOREDTL ADD COLUMN  IMG_SCALE_PERCENT DOUBLE DEFAULT 0 COMMENT '확대율';	
ALTER TABLE SHOPTMONADDIDTL ADD COLUMN  IMG_ANGLE DOUBLE DEFAULT 0 COMMENT '이미지 회전 각도';
ALTER TABLE SHOPTMONADDIDTL ADD COLUMN  IMG_SCALE_PERCENT DOUBLE DEFAULT 0 COMMENT '확대율';	
ALTER TABLE SHOPADDRKAKAODTL ADD COLUMN  IMG_ANGLE DOUBLE DEFAULT 0 COMMENT '이미지 회전 각도';
ALTER TABLE SHOPADDRKAKAODTL ADD COLUMN  IMG_SCALE_PERCENT DOUBLE DEFAULT 0 COMMENT '확대율';	
ALTER TABLE SHOPWEMARKETADDDTL ADD COLUMN  IMG_ANGLE DOUBLE DEFAULT 0 COMMENT '이미지 회전 각도';
ALTER TABLE SHOPWEMARKETADDDTL ADD COLUMN  IMG_SCALE_PERCENT DOUBLE DEFAULT 0 COMMENT '확대율';	
ALTER TABLE SHOPLOTTEONADDDTL ADD COLUMN  IMG_ANGLE DOUBLE DEFAULT 0 COMMENT '이미지 회전 각도';
ALTER TABLE SHOPLOTTEONADDDTL ADD COLUMN  IMG_SCALE_PERCENT DOUBLE DEFAULT 0 COMMENT '확대율';
ALTER TABLE SHOPSSGADDIDTL ADD COLUMN  IMG_ANGLE DOUBLE DEFAULT 0 COMMENT '이미지 회전 각도';
ALTER TABLE SHOPSSGADDIDTL ADD COLUMN  IMG_SCALE_PERCENT DOUBLE DEFAULT 0 COMMENT '확대율';
ALTER TABLE SHOPMELCHIADDIDTL ADD COLUMN  IMG_ANGLE DOUBLE DEFAULT 0 COMMENT '이미지 회전 각도';
ALTER TABLE SHOPMELCHIADDIDTl ADD COLUMN  IMG_SCALE_PERCENT DOUBLE DEFAULT 0 COMMENT '확대율';

UPDATE SHOPINFODOME SET shopurl='https://3mro.co.kr/shop/' WHERE shopcd='shop9994';

DELETE FROM SHOPDTLDOME WHERE COMPNO=4 and SHOPCD='shop9991' and SHOPSEQ=1 and SHOPPINGID='kdjsystem';

INSERT INTO SHOPINFODOME
(SHOPCD, SHOPNM, CUSTNM, PRODREGIS, PRODMODIFY, PRODSOLDOUT, STOCKSEND, ORDERCOLLECT, INVOICSEND, CLAIMCOLLECT, QUESTION, MARKETCATEG, SHOPURL, LOGININF, ORDERINF, INVOICEINF, PRODININF, PRODMODINF, QUESTINF)
VALUES('shop9991', '도매아토즈', '주식회사 아토즈', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'https://www.domeatoz.com/', NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO SHOPMSTDOME(COMPNO, SHOPCD, DEALTRADE, IDNUM)VALUES(4, 'shop9991', '거래중', '2');

ALTER TABLE SHOPDELIVERYS
ADD COLUMN SERVICE_YN varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
ADD COLUMN EXP_SEQ int DEFAULT NULL;

UPDATE SHOPMST SET DEALTRADE=NULL, IDNUM='0'  WHERE COMPNO=4 AND SHOPCD='shop0411';  
UPDATE SHOPINFO SET PRODREGIS=NULL, PRODMODIFY=NULL, PRODSOLDOUT=NULL, STOCKSEND=NULL, ORDERCOLLECT=NULL, INVOICSEND=NULL, CLAIMCOLLECT=NULL, QUESTION=NULL WHERE SHOPCD='shop0411';

UPDATE SHOPMSTDOME SET DEALTRADE=NULL, IDNUM='0' WHERE COMPNO=4 AND SHOPCD='shop9992'; 
UPDATE SHOPINFODOME SET PRODREGIS=NULL, PRODMODIFY=NULL, PRODSOLDOUT=NULL, ORDERCOLLECT=NULL, INVOICSEND=NULL WHERE SHOPCD='shop9992';

INSERT INTO SHOPINFODOME
(SHOPCD, SHOPNM, CUSTNM, PRODREGIS, PRODMODIFY, PRODSOLDOUT, STOCKSEND, ORDERCOLLECT, INVOICSEND, CLAIMCOLLECT, QUESTION, MARKETCATEG, SHOPURL, LOGININF, ORDERINF, INVOICEINF, PRODININF, PRODMODINF, QUESTINF)
VALUES('shop9987', '온미', '예뿌', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'https://onnme.com/', NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO SHOPMSTDOME(COMPNO, SHOPCD, DEALTRADE, IDNUM) VALUES(4, 'shop9987', '거래중', '0');

ALTER TABLE SHOP11STADDIDTL ADD DLVCST3_2 varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '배송비 수량별 차등 2';
ALTER TABLE SHOP11STADDIDTL ADD DLVCNT3 varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '수량별 차등기준 ~이상 수량 2';
ALTER TABLE SHOP11STADDIDTL ADD DLVCNT4 varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '수량별 차등기준 ~이하수량 2';

ALTER TABLE SHOP11STADDIDTL ADD DLVCST3_3 varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '배송비 수량별 차등 3';
ALTER TABLE SHOP11STADDIDTL ADD DLVCNT5 varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '수량별 차등기준 ~이상 수량 3';
ALTER TABLE SHOP11STADDIDTL ADD DLVCNT6 varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '수량별 차등기준 ~이하수량 3';

ALTER TABLE SHOP11STADDIDTL ADD DLVCST3_4 varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '배송비 수량별 차등 4';
ALTER TABLE SHOP11STADDIDTL ADD DLVCNT7 varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '수량별 차등기준 ~이상 수량 4';
ALTER TABLE SHOP11STADDIDTL ADD DLVCNT8 varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '수량별 차등기준 ~이하수량 4';

ALTER TABLE SHOP11STADDIDTL ADD DLVCST3_5 varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '배송비 수량별 차등 5';
ALTER TABLE SHOP11STADDIDTL ADD DLVCNT9 varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '수량별 차등기준 ~이상 수량 5';
ALTER TABLE SHOP11STADDIDTL ADD DLVCNT10 varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '수량별 차등기준 ~이하수량 5';

ALTER TABLE SHOP11STADDIDTL ADD DLVCST3_6 varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '배송비 수량별 차등 6';
ALTER TABLE SHOP11STADDIDTL ADD DLVCNT11 varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '수량별 차등기준 ~이상 수량 6';
ALTER TABLE SHOP11STADDIDTL ADD DLVCNT12 varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '수량별 차등기준 ~이하수량 6';

ALTER TABLE SHOP11STADDIDTL ADD DLVCST3_7 varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '배송비 수량별 차등 7';
ALTER TABLE SHOP11STADDIDTL ADD DLVCNT13 varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '수량별 차등기준 ~이상 수량 7';
ALTER TABLE SHOP11STADDIDTL ADD DLVCNT14 varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '수량별 차등기준 ~이하수량 7';

ALTER TABLE SHOP11STADDIDTL ADD DLVCST3_8 varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '배송비 수량별 차등 8';
ALTER TABLE SHOP11STADDIDTL ADD DLVCNT15 varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '수량별 차등기준 ~이상 수량 8';
ALTER TABLE SHOP11STADDIDTL ADD DLVCNT16 varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '수량별 차등기준 ~이하수량 8';

ALTER TABLE SHOP11STADDIDTL ADD DLVCST3_9 varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '배송비 수량별 차등 9';
ALTER TABLE SHOP11STADDIDTL ADD DLVCNT17 varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '수량별 차등기준 ~이상 수량 9';
ALTER TABLE SHOP11STADDIDTL ADD DLVCNT18 varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '수량별 차등기준 ~이하수량 9';

ALTER TABLE SHOP11STADDIDTL ADD DLVCST3_10 varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '배송비 수량별 차등 10';
ALTER TABLE SHOP11STADDIDTL ADD DLVCNT19 varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '수량별 차등기준 ~이상 수량 10';

ALTER TABLE SHOPPRODINFO ADD NOTICE text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '배송 정책 등 특이사항, 구간별, 수량별 배송비 추가 등';

ALTER TABLE SHOPPRODIN ADD NOTICE text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '배송 정책 관련/ 구간별 수량별 특이사항 있을 때 내용';
ALTER TABLE SHOP_OPTPRODIN ADD STATUS varchar(1) NULL COMMENT '사용자 정상품절 관리상태 0:정상, 1:품절';
ALTER TABLE SHOP_OPTPRODINFO ADD STATUS varchar(1) NULL COMMENT '사용자 정상품절 관리상태 0:정상, 1:품절';

CREATE TABLE SHOPADDPRODINFO_USER (
  `PRODSEQ` int NOT NULL COMMENT '기본 상품정보 SEQ',
  `SKUSEQ` int NOT NULL COMMENT '기본 상품별 SEQ',
  `USER_CODE` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '유저관리코드',
  `PROD_TYPE1` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '추가상품타입1(추가상품명)',
  `PROD_VAL1` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '추가상품값1',
  `PROD_TYPE2` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '추가상품타입2',
  `PROD_VAL2` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '추가상품값2',
  `PROD_AMT` int DEFAULT NULL COMMENT '추가상품금액',
  `PROD_CNT` int DEFAULT NULL COMMENT '추가상품수량',
  `INSERTDT` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '입력일자',
  `INSERTID` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '입력ID',
  `MODIFYDT` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '수정일자',
  `MODIFYID` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '수정ID',
  PRIMARY KEY (`PRODSEQ`,`SKUSEQ`),
  UNIQUE KEY `PRODSEQ_SKUSEQ` (`PRODSEQ`,`SKUSEQ`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='도매상품가공 유저 추가상품 테이블';

CREATE TABLE SHOPPRODINFO_USER_OPTION (
  `ID` int NOT NULL,
  `SKUSEQ` int NOT NULL,
  `PRODCD` varchar(20) NOT NULL,
  `OPTPRODCD` varchar(20) DEFAULT NULL,
  `OPTPRODNM` varchar(200) DEFAULT NULL,
  `OPTSPECDES` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `OPTEA` int DEFAULT NULL,
  `OPTSALE` char(1) DEFAULT NULL,
  `OPTSALEOUT` char(1) DEFAULT NULL,
  `OPTNOTUSE` char(1) DEFAULT NULL,
  `OPTSAFESTOCK` int DEFAULT NULL,
  `OPTVERTSTOCK` int DEFAULT NULL,
  `OPTADDAMT` int DEFAULT NULL,
  `LIMIT_PRICE` int DEFAULT '0' COMMENT '준수가격 추가',
  `OPTDELYN` char(1) DEFAULT NULL,
  `BARCODE` varchar(20) DEFAULT NULL,
  `INSERTDT` varchar(20) DEFAULT NULL,
  `INSERTID` varchar(50) DEFAULT NULL,
  `MODIFYDT` varchar(20) DEFAULT NULL,
  `MODIFYID` varchar(50) DEFAULT NULL,
  `STATUS` varchar(1) DEFAULT NULL COMMENT '사용자 정상품절 관리상태 0:정상, 1:품절',
  PRIMARY KEY (`ID`,`SKUSEQ`),
  UNIQUE KEY `SHOPPRODINFO_user_option_un` (`ID`,`SKUSEQ`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

CREATE TABLE SHOPPRODINFO_USER (
  `id` int NOT NULL AUTO_INCREMENT,
  `userid` varchar(10) NOT NULL,
  `dome_code` varchar(10) NOT NULL,
  `icode` varchar(20) NOT NULL,
  `iname` text,
  `cid` varchar(20) DEFAULT NULL,
  `es_code` varchar(50) DEFAULT NULL,
  `shop_cid_info` text,
  `cate_fullname` varchar(1000) DEFAULT NULL,
  `icountry` varchar(200) DEFAULT NULL,
  `cate_dept` varchar(10) DEFAULT NULL,
  `maker` varchar(200) DEFAULT NULL,
  `brand` varchar(200) DEFAULT NULL,
  `tax` char(1) DEFAULT NULL,
  `vender_code` varchar(200) DEFAULT NULL,
  `delivery_type` char(1) DEFAULT NULL,
  `delivery_amount` decimal(10,0) DEFAULT NULL,
  `r_delivery_amount` decimal(10,0) DEFAULT NULL,
  `delivery_qty` varchar(200) DEFAULT NULL,
  `search` varchar(200) DEFAULT NULL,
  `keyword` text,
  `price` int DEFAULT NULL,
  `price_consumer` int DEFAULT NULL,
  `islimit` char(1) DEFAULT NULL,
  `limit_price` int DEFAULT NULL,
  `content` text,
  `img` text,
  `select_option` text,
  `text_option` varchar(200) DEFAULT NULL,
  `option_use` char(1) DEFAULT NULL,
  `notice` text,
  `itype` char(1) DEFAULT NULL,
  `status` char(1) DEFAULT NULL,
  `adult` char(1) DEFAULT NULL,
  `reg_datetime` varchar(50) DEFAULT NULL,
  `up_datetime` varchar(50) DEFAULT NULL,
  `isreturn` char(1) DEFAULT NULL,
  `cert_type` char(1) DEFAULT NULL,
  `cert` varchar(100) DEFAULT NULL,
  `cert_no` varchar(100) DEFAULT NULL,
  `gosi_code` varchar(20) DEFAULT NULL,
  `gosi_info` text,
  `is_overseas` varchar(10) DEFAULT NULL,
  `is_medical` varchar(10) DEFAULT NULL,
  `is_h_food` varchar(10) DEFAULT NULL,
  `a_vender_code` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `a_status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `SHOPPRODINFO_user_unique` (`userid`,`dome_code`,`icode`)
) ENGINE=InnoDB AUTO_INCREMENT=4226 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

ALTER TABLE SHOPPRODINFO_USER MODIFY COLUMN cid varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL;

INSERT INTO SHOPMSTDOME (COMPNO, SHOPCD, DEALTRADE, IDNUM) VALUES(4, 'shop9986', '거래중', '0');
INSERT INTO SHOPMSTDOME (COMPNO, SHOPCD, DEALTRADE, IDNUM) VALUES(4, 'shop9985', '거래중', '0');

INSERT INTO SHOPINFODOME
(SHOPCD, SHOPNM, CUSTNM, PRODREGIS, PRODMODIFY, PRODSOLDOUT, STOCKSEND, ORDERCOLLECT, INVOICSEND, CLAIMCOLLECT, QUESTION, MARKETCATEG, SHOPURL, LOGININF, ORDERINF, INVOICEINF, PRODININF, PRODMODINF, QUESTINF)
VALUES('shop9985', '도매마트', '(주)이상테크윈', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'https://www.domaemart.com/shop/', NULL, NULL, NULL, NULL, NULL, NULL);

UPDATE SHOPINFODOME
SET SHOPNM='도매마트', CUSTNM='(주)이상테크윈', PRODREGIS=NULL, PRODMODIFY=NULL, PRODSOLDOUT=NULL, STOCKSEND=NULL, ORDERCOLLECT=NULL, INVOICSEND=NULL, CLAIMCOLLECT=NULL, QUESTION=NULL, MARKETCATEG=NULL, SHOPURL='https://www.domaemart.com/shop/', LOGININF=NULL, ORDERINF=NULL, INVOICEINF=NULL, PRODININF=NULL, PRODMODINF=NULL, QUESTINF=NULL
WHERE SHOPCD='shop9985';

INSERT INTO SHOPINFODOME
(SHOPCD, SHOPNM, CUSTNM, PRODREGIS, PRODMODIFY, PRODSOLDOUT, STOCKSEND, ORDERCOLLECT, INVOICSEND, CLAIMCOLLECT, QUESTION, MARKETCATEG, SHOPURL, LOGININF, ORDERINF, INVOICEINF, PRODININF, PRODMODINF, QUESTINF)
VALUES('shop9986', '룸앤오피스', '주식회사 와이디', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'https://ydinc.cafe24.com/', NULL, NULL, NULL, NULL, NULL, NULL);

ALTER TABLE SHOPDTLDOME ADD CODE_DIVISION varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '도매몰 별 상품코드 구분자';

INSERT INTO PRODATTRNM
(ATTRCD, COLSEQ, ATTRNM, FUNNSEQ, WTRADINGSEQ, TOBIZONSEQ, DOMEGGOOKSEQ, OWNERCLANSEQ, HUBSELLSEQ, DOSINSEQ, NOTICETYPE, ITEMCODE, INTERCODE, INTERAPICODE, INTERAPITYPE)
VALUES('006', 23, '재공급 사유/하자 부위',  NULL, NULL, NULL, NULL, NULL, NULL, '16', '891016', '469865457', '재공급(리퍼브) 가구의 경우 재공급 사유 및 하자 부위에 관한 정보', '0612', 'I');

ALTER TABLE SHOPPRODINFO_USER ADD img_text_detected varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '0: 텍스트 없음, 1: 텍스트 있음';

ALTER TABLE SHOPDTL ADD FORBIDDENKEYWORDS varchar(200) NULL COMMENT '금지 키워드';
ALTER TABLE SHOPDTLDOME ADD FORBIDDENKEYWORDS varchar(200) NULL;

UPDATE SHOPMST SET DEALTRADE=NULL, IDNUM='0' WHERE SHOPCD='shop0003';
UPDATE SHOPMST SET DEALTRADE=NULL, IDNUM='0' WHERE SHOPCD='shop0067';
UPDATE SHOPMST SET DEALTRADE=NULL, IDNUM='0' WHERE SHOPCD='shop0068';

ALTER TABLE SHOPDTL MODIFY COLUMN FORBIDDENKEYWORDS TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '금지 키워드';

ALTER TABLE SYSTEMCONF ADD SECONDAUTH11STYN char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '11번가 2차인증 사용여부';


INSERT INTO SHOPMST (COMPNO, SHOPCD, DEALTRADE, IDNUM) VALUES(4, 'shop9984', '거래중', '0');
UPDATE SHOPMST SET DEALTRADE='거래중' WHERE COMPNO=4 AND SHOPCD='shop9984';

INSERT INTO SHOPINFO(SHOPCD, SHOPNM, CUSTNM, PRODREGIS, PRODMODIFY, PRODSOLDOUT, STOCKSEND, ORDERCOLLECT, INVOICSEND, CLAIMCOLLECT, QUESTION, MARKETCATEG, SHOPURL)
VALUES('shop9984', '올웨이즈', '올웨이즈', '서비스', '서비스', '서비스', '서비스', '서비스', '서비스', '서비스', '서비스', '전문몰', 'https://alwayzseller.ilevit.com/');

UPDATE SHOPINFO
SET PRODREGIS='서비스', PRODMODIFY='서비스', PRODSOLDOUT='서비스', STOCKSEND='서비스', ORDERCOLLECT='서비스', INVOICSEND='서비스', CLAIMCOLLECT='서비스', QUESTION='서비스'
WHERE SHOPCD='shop9984';

CREATE TABLE SHOPALWAYZADDDTL (
  `SEQ` int NOT NULL COMMENT '일련번호',
  `COMPNO` int DEFAULT NULL COMMENT '회사코드',
  `SHOPCD` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '쇼핑몰코드',
  `SHOPSEQ` int DEFAULT NULL,
  `SHOPID` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '아이디',
  `TITLE` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '부가정보이름',
  `ISCATEGORY` varchar(50) DEFAULT NULL,
  `LAGCATCD` varchar(50) DEFAULT NULL,
  `MIDCATCD` varchar(50) DEFAULT NULL,
  `SMLCATCD` varchar(50) DEFAULT NULL,
  `DETCATCD` varchar(50) DEFAULT NULL,
  `SHOPCATNO` varchar(50) DEFAULT NULL,
  `SHOPCATSITENM` varchar(50) DEFAULT NULL,
  `TEAMPURCHASEPRICE` int DEFAULT NULL COMMENT '팀 구매가',
  `TEAMPURCHASEPRICEUNIT` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '팀 구매가 단위',
  `PURCHASELIMITS` int DEFAULT NULL COMMENT '1인 최대 구매 제한 개수',
  `TEAMDEALTHRESHOLD` int DEFAULT NULL COMMENT '팀 구매 인원',
  `IMAGERESIZEYN` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '이미지리사이징 "적용함" "적용안함"',
  `IMAGERESIZE` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '이미지리사이징 적용함 선택 시 사이즈 값',
  `IMGONEONONE` varchar(50) DEFAULT NULL COMMENT '이미지 1:1비율 노출',
  `IMGTHREEONFOUR` varchar(50) DEFAULT NULL COMMENT '이미지 3:4비율 노출',
  `SELLERDC` float DEFAULT NULL COMMENT '판매자즉시할인',
  `COMMDC` float DEFAULT NULL COMMENT '수수료율',
  `DCRATE` float DEFAULT NULL COMMENT '할인율',
  `CUMDC` float DEFAULT NULL COMMENT '정액할인',
  `MARGINDC` float DEFAULT NULL COMMENT '마진율',
  `SHIPPINGCOMPANY` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '택배사',
  `SHIPPINGDAYS` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '배송소요시일',
  `SHIPPINGFEEINFO` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '배송비용 안내 문구',
  `ADDOPTIONR` varchar(50) DEFAULT NULL,
  `RETURNFEE` int DEFAULT NULL COMMENT '단순 변심 시 반품 비용',
  `RETURNFEEINFO` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '반품 비용 안내 문구',
  `COLLECTAPPLICATIONYN` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '일괄적용 설정',
  `COLLECTAPPLICATION` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '일괄적용설정 적용함 설정 시 상품고시 선택 값',
  `TITLEYN` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '타이틀 사용여부',
  `PRODNMOUTPUT` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '상품명출력방법 ',
  `PRODNMADDFRONT` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '상품명추가글귀(앞)',
  `PRODNMADDBACK` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '상품명추가글귀(뒤)',
  `ANGLE` double DEFAULT '0' COMMENT '이미지 회전 각도',
  `SCALEPERCENT` double DEFAULT '0' COMMENT '확대율',
  `CHANGESIZE` varchar(50) DEFAULT NULL COMMENT '대표사진사이즈변경 버튼',
  `CHANGESIZEX` varchar(50) 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',
  `DETAILKEYWORDB` varchar(50) DEFAULT NULL COMMENT '상세페이지 상단 (키워드) 버튼',
  `DETAILKEYWORDL` text COMMENT '상세페이지 상단 (키워드)',
  `DETAILKEYWORDR` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `DETAILPRODUCTCODEB` varchar(50) DEFAULT NULL COMMENT '상세페이지 상단 (상품코드) 버튼',
  `DETAILPRODUCTCODEL` text COMMENT '상세페이지 상단 (상품코드)',
  `DETAILPRODUCTCODER` text,
  `DETAILPRODUCTNAMEB` varchar(50) DEFAULT NULL COMMENT '상세페이지 상단 (상품명) 버튼',
  `DETAILPRODUCTNAMEL` text COMMENT '상세페이지 상단 (상품명)',
  `DETAILPRODUCTNAMER` text,
  `PRODDETAILFRONT` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '상품상세설명앞부분추가내용',
  `PRODDETAILBACK` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '상품상세설명뒷부분추가내용',
  `PRODDETAILOUTPUT` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '상품상세설명뒷부분출력위치',
  `ADDOPTIONLB` varchar(50) DEFAULT NULL COMMENT '옵션추가 왼쪽 버튼',
  `ADDOPTIONL` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '옵션추가 왼쪽',
  `ADDOPTIONRB` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '옵션추가 오른쪽 버튼',
  PRIMARY KEY (`SEQ`),
  UNIQUE KEY `SEQ` (`SEQ`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

ALTER TABLE SYSTEMCONF	ADD COLUMN `DISPLAYHOME` CHAR(1) NULL DEFAULT 'Y' COMMENT 'home표시여부' AFTER `SECONDAUTH11STYN`;
	
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '01', '우체국택배', 0, '60fa5eb6d28d5e1c65152c7a', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '04', 'CJ대한통운', 0, '60fa5eb6d28d5e1c65152c77', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '05', '한진택배', 0, '60fa5eb6d28d5e1c65152c78', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '06', '로젠택배', 0, '60fa5eb6d28d5e1c65152c7b', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '08', '롯데택배', 0, '60fa5eb6d28d5e1c65152c79', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '100', '나은물류', 0, '60fa5eb6d28d5e1c65152ccb', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '101', '한샘서비스원 택배', 0, '60fa5eb6d28d5e1c65152c9c', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '102', '배송하기좋은날(SHIPNERGY)', 0, '60fa5eb6d28d5e1c65152ccc', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '103', 'NDEX KOREA', 0, '60fa5eb6d28d5e1c65152c9d', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '104', '도도플렉스(dodoflex)', 0, '60fa5eb6d28d5e1c65152c9e', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '105', 'BRIDGE LOGIS', 0, '60fa5eb6d28d5e1c65152ccd', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '106', '허브넷로지스틱스', 0, '60fa5eb6d28d5e1c65152cce', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '107', 'LG전자(판토스)', 0, '60fa5eb6d28d5e1c65152c9f', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '108', 'MEXGLOBAL', 0, '60fa5eb6d28d5e1c65152ccf', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '109', '파테크해운항공', 0, '60fa5eb6d28d5e1c65152cd0', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '11', '일양로지스', 0, '60fa5eb6d28d5e1c65152c7c', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '110', '부릉', 0, '65e17fd50ce329cfbfdbfc34', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '111', 'SBGLS', 0, '65e182e70ce329cfbfdbfc56', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '112', '1004홈', 0, '65e17fee0ce329cfbfdbfc35', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '113', '썬더히어로', 0, '65e17fff0ce329cfbfdbfc36', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '114', '캐나다쉬핑', 0, '65e182f50ce329cfbfdbfc57', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '116', '(주)팀프레시', 0, '65e180120ce329cfbfdbfc37', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '117', 'YUNDA EXPRESS', 0, '65e183050ce329cfbfdbfc58', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '118', '롯데칠성', 0, '65e180260ce329cfbfdbfc38', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '119', '핑퐁', 0, '65e180550ce329cfbfdbfc39', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '12', 'EMS', 0, '60fa5eb6d28d5e1c65152ca0', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '120', '발렉스 특수물류', 0, '65e180680ce329cfbfdbfc3a', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '121', '바바바(bababa)', 0, '65e183160ce329cfbfdbfc59', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '122', 'BAIMA EXPRESS', 0, '65e183250ce329cfbfdbfc5a', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '123', '엔티엘피스', 0, '65e1807e0ce329cfbfdbfc3b', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '124', 'LTL', 0, '65e183330ce329cfbfdbfc5b', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '125', 'GTS로지스', 0, '65e180940ce329cfbfdbfc3c', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '126', '㈜올타코리아', 0, '65e183450ce329cfbfdbfc5c', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '127', '로지스팟', 0, '65e180a80ce329cfbfdbfc3d', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '128', '판월드로지스틱㈜', 0, '65e183570ce329cfbfdbfc5d', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '129', '홈픽 오늘도착', 0, '65e180bb0ce329cfbfdbfc3e', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '13', 'DHL', 0, '60fa5eb6d28d5e1c65152ca1', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '130', '로지스파트너', 0, '65e180ce0ce329cfbfdbfc3f', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '131', '딜리래빗', 0, '65e180e10ce329cfbfdbfc40', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '132', '지오피', 0, '65e180f10ce329cfbfdbfc41', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '134', '에이치케이홀딩스', 0, '65e181040ce329cfbfdbfc42', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '135', 'HTNS', 0, '65e181160ce329cfbfdbfc43', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '136', '케이제이티', 0, '65e181270ce329cfbfdbfc44', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '137', '더바오', 0, '65e181380ce329cfbfdbfc45', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '138', '라스트마일', 0, '65e1814a0ce329cfbfdbfc46', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '14', 'UPS', 0, '60fa5eb6d28d5e1c65152ca3', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '140', '직구문', 0, '65e183690ce329cfbfdbfc5e', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '141', '인터로지스', 0, '65e183770ce329cfbfdbfc5f', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '142', '탱고앤고', 0, '65e1815f0ce329cfbfdbfc47', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '143', '투데이', 0, '65e181710ce329cfbfdbfc48', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '144', '큐브플로우(CUBEFLOW)', 0, '65e183840ce329cfbfdbfc60', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '145', '현대글로비스', 0, '65e181810ce329cfbfdbfc49', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '146', '국제로지스틱(KSE)', 0, '65e183940ce329cfbfdbfc61', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '147', '에스더쉬핑', 0, '65e183b50ce329cfbfdbfc62', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '148', 'ARGO', 0, '65e181910ce329cfbfdbfc4a', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '149', '골드스넵스', 0, '65e183c00ce329cfbfdbfc63', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '151', '자이언트', 0, '65e181a40ce329cfbfdbfc4b', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '152', '(주)엠티인터내셔널', 0, '65e183d00ce329cfbfdbfc64', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '153', '(주)이지로지스틱', 0, '65e183df0ce329cfbfdbfc65', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '154', 'KT EXPRESS(케이티익스프레스)', 0, '65e183ef0ce329cfbfdbfc66', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '155', 'HY', 0, '65e181b40ce329cfbfdbfc4c', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '156', '유피로지스', 0, '65e181c40ce329cfbfdbfc4d', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '157', '우진인터로지스', 0, '65e181d30ce329cfbfdbfc4e', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '158', 'Auspost', 0, '65e183fd0ce329cfbfdbfc67', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '159', '삼다수 가정배송', 0, '65e181e40ce329cfbfdbfc4f', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '16', '한의사랑택배', 0, '60fa5eb6d28d5e1c65152c83', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '160', '와이드테크', 0, '65e181f90ce329cfbfdbfc50', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '161', 'SBP', 0, '65e1840b0ce329cfbfdbfc68', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '162', 'SAP EXPRESS', 0, '65e1841a0ce329cfbfdbfc69', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '163', '위니온로지스', 0, '65e182060ce329cfbfdbfc51', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '164', 'ICS LOGISTICS(아이씨에스 로지스틱스)', 0, '65e184290ce329cfbfdbfc6a', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '165', '서림특송', 0, '65e184370ce329cfbfdbfc6b', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '166', 'Rincos', 0, '65e184430ce329cfbfdbfc6c', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '167', '딜리박스', 0, '65e182150ce329cfbfdbfc52', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '168', '이스트라', 0, '65e182230ce329cfbfdbfc53', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '169', 'JNT', 0, '65e1844e0ce329cfbfdbfc6d', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '17', '천일택배', 0, '60fa5eb6d28d5e1c65152c84', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '170', '유피로지스', 0, '65e182330ce329cfbfdbfc54', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '171', '올인닷컴', 0, '65e182410ce329cfbfdbfc55', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '178', '든든택배', 0, '6653e78926b80696888cfd02', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '18', '건영택배', 0, '60fa5eb6d28d5e1c65152c85', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '20', '한덱스', 0, '60fa5eb6d28d5e1c65152c7d', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '21', 'FedEx', 0, '60fa5eb6d28d5e1c65152ca2', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '22', '대신택배', 0, '60fa5eb6d28d5e1c65152c7e', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '23', '경동택배', 0, '60fa5eb6d28d5e1c65152c7f', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '24', 'GS Postbox 택배', 0, '60fa5eb6d28d5e1c65152c82', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '25', 'TNT Express', 0, '60fa5eb6d28d5e1c65152ca5', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '26', 'USPS', 0, '60fa5eb6d28d5e1c65152ca4', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '28', 'GSMNtoN', 0, '60fa5eb6d28d5e1c65152ca6', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '29', '에어보이익스프레스', 0, '60fa5eb6d28d5e1c65152ca7', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '30', 'KGL네트웍스', 0, '60fa5eb6d28d5e1c65152ca8', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '32', '합동택배', 0, '60fa5eb6d28d5e1c65152c80', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '33', 'DHL Global Mail', 0, '60fa5eb6d28d5e1c65152ca9', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '34', 'i-Parcel', 0, '60fa5eb6d28d5e1c65152caa', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '37', 'LX판토스', 0, '60fa5eb6d28d5e1c65152cab', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '38', 'ECMS Express', 0, '60fa5eb6d28d5e1c65152cac', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '40', '굿투럭', 0, '60fa5eb6d28d5e1c65152c86', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '41', 'GSI Express', 0, '60fa5eb6d28d5e1c65152cad', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '42', 'CJ대한통운 국제특송', 0, '60fa5eb6d28d5e1c65152cae', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '43', '애니트랙', 0, '60fa5eb6d28d5e1c65152c87', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '44', 'SLX택배', 0, '60fa5eb6d28d5e1c65152c88', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '45', '우리택배(구호남택배)', 0, '60fa5eb6d28d5e1c65152c89', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '46', 'CU 편의점택배', 0, '60fa5eb6d28d5e1c65152c81', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '47', '우리한방택배', 0, '60fa5eb6d28d5e1c65152c8a', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '48', 'ACI Express', 0, '60fa5eb6d28d5e1c65152caf', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '49', 'A.C.E EXPRESS INC', 0, '60fa5eb6d28d5e1c65152cb0', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '50', 'GPS Logix', 0, '60fa5eb6d28d5e1c65152cb1', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '51', '성원글로벌카고', 0, '60fa5eb6d28d5e1c65152cb2', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '52', '세방', 0, '60fa5eb6d28d5e1c65152cb3', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '53', '농협택배', 0, '60fa5eb6d28d5e1c65152c8b', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '54', '홈픽택배', 0, '60fa5eb6d28d5e1c65152c8c', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '55', 'EuroParcel', 0, '60fa5eb6d28d5e1c65152cb4', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '57', 'Cway Express', 0, '60fa5eb6d28d5e1c65152cb5', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '60', 'YJS글로벌(영국)', 0, '60fa5eb6d28d5e1c65152cb6', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '61', '워펙스코리아', 0, '60fa5eb6d28d5e1c65152cb7', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '62', '(주)홈이노베이션로지스', 0, '60fa5eb6d28d5e1c65152c8d', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '63', '은하쉬핑', 0, '60fa5eb6d28d5e1c65152cb8', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '65', 'YJS글로벌(월드)', 0, '60fa5eb6d28d5e1c65152cb9', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '66', 'Giant Network Group', 0, '60fa5eb6d28d5e1c65152cba', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '67', '디디로지스', 0, '60fa5eb6d28d5e1c65152cbb', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '69', '대림통운', 0, '60fa5eb6d28d5e1c65152cbc', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '70', 'LOTOS CORPORATION', 0, '60fa5eb6d28d5e1c65152cbd', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '71', 'IK물류', 0, '60fa5eb6d28d5e1c65152c8e', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '72', '성훈물류', 0, '60fa5eb6d28d5e1c65152c8f', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '73', 'CR로지텍', 0, '60fa5eb6d28d5e1c65152cbe', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '74', '용마로지스', 0, '60fa5eb6d28d5e1c65152c90', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '75', '원더스퀵', 0, '60fa5eb6d28d5e1c65152c91', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '76', '대운글로벌', 0, '60fa5eb6d28d5e1c65152cbf', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '77', 'LineExpress', 0, '60fa5eb6d28d5e1c65152cc0', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '78', '2FastExpress', 0, '60fa5eb6d28d5e1c65152cc1', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '79', '로지스밸리택배', 0, '60fa5eb6d28d5e1c65152c92', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '80', '엘서비스', 0, '60fa5eb6d28d5e1c65152cc2', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '81', '제니엘시스템', 0, '60fa5eb6d28d5e1c65152cc3', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '82', '컬리넥스트마일', 0, '60fa5eb6d28d5e1c65152c93', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '84', '스마트로지스', 0, '60fa5eb6d28d5e1c65152cc4', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '85', '풀앳홈', 0, '60fa5eb6d28d5e1c65152c94', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '86', '삼성전자물류', 0, '60fa5eb6d28d5e1c65152c95', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '87', '이투마스(ETOMARS)', 0, '60fa5eb6d28d5e1c65152cc5', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '88', '큐런택배', 0, '60fa5eb6d28d5e1c65152c96', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '89', '두발히어로', 0, '60fa5eb6d28d5e1c65152c97', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '90', '위니아딤채', 0, '60fa5eb6d28d5e1c65152c98', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '91', '하이브시티', 0, '60fa5eb6d28d5e1c65152cc6', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '92', '지니고 당일배송', 0, '60fa5eb6d28d5e1c65152c99', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '93', '팬스타국제특송(PIEX)', 0, '60fa5eb6d28d5e1c65152cc7', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '94', '카카오 T 당일배송', 0, '60fa5eb6d28d5e1c65152c9a', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '95', '큐익스프레스', 0, '60fa5eb6d28d5e1c65152cc8', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '96', '로지스밸리', 0, '60fa5eb6d28d5e1c65152c9b', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '97', '에이씨티앤코아물류', 0, '60fa5eb6d28d5e1c65152cc9', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9984', '99', '롯데택배 해외특송', 0, '60fa5eb6d28d5e1c65152cca', NULL, NULL);

INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9982', '20001', 'CJ대한통운', 0, 'CJ 대한통운', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9982', '20002', 'CU편의점택배', 0, 'CU편의점택배', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9982', '20003', 'GS25편의점택배', 0, 'GS25편의점택배', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9982', '20004', 'GTS로지스', 0, 'GTS로지스', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9982', '20005', 'HTNS', 0, 'HTNS', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9982', '20006', 'IK물류', 0, 'IK물류', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9982', '20007', 'LG전자', 0, 'LG전자', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9982', '20008', 'NDEXKOREA', 0, 'NDEXKOREA', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9982', '20009', 'SLX택배', 0, 'SLX택배', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9982', '20010', 'UFO로지스', 0, 'UFO로지스', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9982', '20011', '건영택배', 0, '건영택배', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9982', '20012', '경동택배', 0, '경동택배', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9982', '20013', '굿투럭', 0, '굿투럭', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9982', '20014', '농협택배', 0, '농협택배', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9982', '20015', '대신택배', 0, '대신택배', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9982', '20016', '더바오', 0, '더바오', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9982', '20017', '도도플렉스', 0, '도도플렉스', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9982', '20018', '두발히어로', 0, '두발히어로', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9982', '20019', '딜리래빗', 0, '딜리래빗', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9982', '20020', '라스트마일', 0, '라스트마일', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9982', '20021', '로젠택배', 0, '로젠택배', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9982', '20022', '로지스밸리', 0, '로지스밸리', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9982', '20023', '로지스밸리택배', 0, '로지스밸리택배', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9982', '20024', '로지스팟', 0, '로지스팟', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9982', '20025', '롯데칠성', 0, '롯데칠성', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9982', '20026', '롯데택배', 0, '롯데택배', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9982', '20027', '발렉스', 0, '발렉스', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9982', '20028', '부릉', 0, '부릉', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9982', '20029', '삼성전자물류', 0, '삼성전자물류', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9982', '20030', '성훈물류', 0, '성훈물류', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9982', '20031', '썬더히어로', 0, '썬더히어로', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9982', '20032', '애니트랙', 0, '애니트랙', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9982', '20033', '에이치케이홀딩스', 0, '에이치케이홀딩스', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9982', '20034', '엔티엘피스', 0, '엔티엘피스', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9982', '20035', '오늘의픽업', 0, '오늘의픽업', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9982', '20036', '오늘회러쉬', 0, '오늘회러쉬', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9982', '20037', '용마로지스', 0, '용마로지스', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9982', '20038', '우리택배', 0, '우리택배', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9982', '20039', '우리한방택배', 0, '우리한방택배', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9982', '20040', '우체국택배', 0, '우체국택배', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9982', '20041', '원더스퀵', 0, '원더스퀵', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9982', '20042', '위니아딤채', 0, '위니아딤채', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9982', '20043', '위니온로지스', 0, '위니온로지스', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9982', '20044', '일양로지스', 0, '일양로지스', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9982', '20045', '자이언트', 0, '자이언트', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9982', '20046', '지니고', 0, '지니고', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9982', '20047', '지오피', 0, '지오피', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9982', '20048', '천일택배', 0, '천일택배', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9982', '20049', '컬리로지스', 0, '컬리로지스', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9982', '20050', '케이제이티', 0, '케이제이티', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9982', '20051', '큐런택배', 0, '큐런택배', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9982', '20052', '탱고앤고', 0, '탱고앤고', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9982', '20053', '투데이', 0, '투데이', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9982', '20054', '팀프레시', 0, '팀프레시', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9982', '20055', '풀앳홈', 0, '풀앳홈', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9982', '20056', '핑퐁', 0, '핑퐁', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9982', '20057', '한덱스', 0, '한덱스', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9982', '20058', '한샘서비스원', 0, '한샘서비스원', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9982', '20059', '한의사랑택배', 0, '한의사랑택배', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9982', '20060', '한진택배', 0, '한진택배', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9982', '20061', '합동택배', 0, '합동택배', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9982', '20062', '현대글로비스', 0, '현대글로비스', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9982', '20063', '홈픽', 0, '홈픽', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9982', '20064', '홈픽택배', 0, '홈픽택배', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9982', '20065', '1004홈', 0, '1004홈', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9982', '20066', 'ARGO', 0, 'ARGO', NULL, NULL);
INSERT INTO SHOPDELIVERYS
(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE, SERVICE_YN, EXP_SEQ)
VALUES('shop9982', '20067', 'hy', 0, 'hy', NULL, NULL);

ALTER TABLE QNALIST MODIFY COLUMN MPRODID varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '상품코드(쇼핑몰)';
ALTER TABLE QNALIST MODIFY COLUMN ORDID varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '주문번호(쇼핑몰)';

ALTER TABLE SHOP_OPTPRODINFO MODIFY COLUMN PRODCD varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL;
ALTER TABLE SHOP_OPTPRODINFO MODIFY COLUMN OPTPRODCD varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL; ALTER TABLE mlink.shop_optprodin MODIFY COLUMN OPTPRODCD varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL;

ALTER TABLE SHOPALWAYZADDDTL ADD DELIVERYFEEEXJEJU int NULL COMMENT '도서산간 배송비(제주 외)';
ALTER TABLE SHOPALWAYZADDDTL CHANGE DELIVERYFEEEXJEJU DELIVERYFEEEXJEJU int NULL COMMENT '도서산간 배송비(제주 외)' AFTER ADDOPTIONR;
ALTER TABLE SHOPALWAYZADDDTL ADD DELIVERYFEEINJEJU int NULL COMMENT '도서산간 배송비(제주)';
ALTER TABLE SHOPALWAYZADDDTL CHANGE DELIVERYFEEINJEJU DELIVERYFEEINJEJU int NULL COMMENT '도서산간 배송비(제주)' AFTER DELIVERYFEEEXJEJU;
ALTER TABLE SHOPALWAYZADDDTL CHANGE CUMDC FLATDC float NULL COMMENT '정액할인';


INSERT INTO SHOPMST(COMPNO, SHOPCD, DEALTRADE, IDNUM) VALUES(4, 'shop9982', '거래중', '0');

INSERT INTO SHOPINFO
(SHOPCD, SHOPNM, CUSTNM, PRODREGIS, PRODMODIFY, PRODSOLDOUT, STOCKSEND, ORDERCOLLECT, INVOICSEND, CLAIMCOLLECT, QUESTION, MARKETCATEG, SHOPURL)
VALUES('shop9982', '토스쇼핑', '토스쇼핑', '서비스', '서비스', '서비스', '서비스', '서비스', '서비스', '서비스', '서비스', '전문몰', 'https://shopping-seller.toss.im/');

UPDATE SHOPINFO
SET PRODREGIS='서비스', PRODMODIFY='서비스', PRODSOLDOUT='서비스', STOCKSEND='서비스', ORDERCOLLECT='서비스', INVOICSEND='서비스', CLAIMCOLLECT='서비스', QUESTION='서비스'
WHERE SHOPCD='shop9982';


CREATE TABLE `SHOPTOSSSHOPPINGADDDTL` (
  `SEQ` int NOT NULL COMMENT '일련번호',
  `COMPNO` int DEFAULT NULL COMMENT '회사코드',
  `SHOPCD` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '쇼핑몰코드',
  `SHOPSEQ` int DEFAULT NULL,
  `SHOPID` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '아이디',
  `TITLE` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '부가정보이름',
  `ISCATEGORY` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `LAGCATCD` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `MIDCATCD` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `SMLCATCD` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `DETCATCD` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `SHOPCATNO` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `SHOPCATSITENM` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `USEADIMGYN` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '광고 이미지',
  `RESIZETHUMBNAILYN` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '섬네일 이미지리사이징',
  `RESIZEADYN` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '광고 이미지리사이징',
  `DELIVERY_TEMP_ID` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '배송템플릿',
  `EXCHANGEORRETURN_TEMP_ID` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '교환 · 반품 템플릿',
  `MINDELIVERYELAPSEDDAY` int DEFAULT NULL COMMENT '최소배송일수',
  `MAXDELIVERYELAPSEDDAY` int DEFAULT NULL COMMENT '최대배송일수',
  `DELIVERYAVAILABLEREGION` varchar(200) DEFAULT NULL COMMENT '배송가능지역',
  `CANBEDELIVEREDLONGDISTANCE` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '제주/도서산간 배송 가능 여부',
  `LONGDISTANCEDELIVERYCOST` int DEFAULT NULL COMMENT '제주/도서산간 추가 배송비',
  `BOTHWAYSDELIVERYCOST` int DEFAULT NULL COMMENT '교환/반품 시 왕복 배송비',
  `APPLICATIONMETHODDESCRIPTION` text COMMENT '교환/반품 신청 방법',
  `APPLICATIONTERMDESCRIPTION` varchar(200) DEFAULT NULL COMMENT '교환/반품 신청 가능 기간',
  `APPLICATIONIMPOSSIBLECASEDESCRIPTION` text COMMENT '교환/반품 불가 조건',
  `DELIVERYCOST` int DEFAULT '0' COMMENT '배송비',
  `COLLECTIVEAPPLICATION` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '일괄적용설정',
  `COLLECTIVEAPPVALUE1` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '일괄적용설정 값',
  `TITLEYN` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '타이틀사용여부',
  `PRODNMOUTPUT` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '상품명출력방법 ',
  `PRODNMADDFRONT` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '상품명추가글귀(앞)',
  `PRODNMADDBACK` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '상품명추가글귀(뒤)',
  `ANGLE` double DEFAULT '0' COMMENT '이미지 회전 각도',
  `SCALEPERCENT` double DEFAULT '0' COMMENT '확대율',
  `CHANGESIZE` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '대표사진사이즈변경 버튼',
  `CHANGESIZEX` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '대표사진사이즈변경 X',
  `CHANGESIZEY` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '대표사진사이즈변경 Y',
  `CHANGESIZEW` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '대표사진사이즈변경 W',
  `CHANGESIZEH` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '대표사진사이즈변경 H',
  `DETAILKEYWORDB` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '상세페이지 상단 (키워드) 버튼',
  `DETAILKEYWORDL` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '상세페이지 상단 (키워드)',
  `DETAILKEYWORDR` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `DETAILPRODUCTCODEB` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '상세페이지 상단 (상품코드) 버튼',
  `DETAILPRODUCTCODEL` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '상세페이지 상단 (상품코드)',
  `DETAILPRODUCTCODER` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `DETAILPRODUCTNAMEB` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '상세페이지 상단 (상품명) 버튼',
  `DETAILPRODUCTNAMEL` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '상세페이지 상단 (상품명)',
  `DETAILPRODUCTNAMER` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `PRODDETAILFRONT` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '상품상세설명앞부분추가내용',
  `PRODDETAILBACK` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '상품상세설명뒷부분추가내용',
  `PRODDETAILOUTPUT` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '상품상세설명뒷부분출력위치',
  `ADDOPTIONLB` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '옵션추가 왼쪽 버튼',
  `ADDOPTIONL` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '옵션추가 왼쪽',
  `ADDOPTIONRB` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '옵션추가 오른쪽 버튼',
  `SELLERDC` float DEFAULT NULL COMMENT '판매자즉시할인',
  `COMMDC` float DEFAULT NULL COMMENT '수수료율',
  `DCRATE` float DEFAULT NULL COMMENT '할인율',
  `FLATDC` float DEFAULT NULL COMMENT '정액할인',
  `MARGINDC` float DEFAULT NULL COMMENT '마진율',
  `IMGONEONONE` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '이미지 1:1비율 노출',
  `IMGTHREEONFOUR` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '이미지 3:4비율 노출',
  `ADDOPTIONR` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;



ALTER TABLE SHOPAUCTION2ADDDTL ADD SALEPERIODYN varchar(50) NULL COMMENT '판매기간 사용여부';
ALTER TABLE SHOPGMARKET2ADDDTL ADD SALEPERIODYN varchar(50) NULL COMMENT '판매기간 사용여부';
	
ALTER TABLE SYSTEMCONF ADD COLUMN `OUTOFPRODINFO` CHAR(1) NULL DEFAULT 'N' COMMENT '상품관리 전체상품에 쇼핑몰정보 포함여부' AFTER `DISPLAYHOME`;
	
ALTER TABLE SHOPAUCTION2ADDDTL ADD BUNDLEDSHIPPINGYN varchar(50) NULL COMMENT '묶음배송 사용여부';
ALTER TABLE SHOPAUCTION2ADDDTL ADD BUNDLEDSHIPPINGPAYYN varchar(50) NULL COMMENT '개별배송비 유료 무료';
ALTER TABLE SHOPAUCTION2ADDDTL ADD BUNDLEDSHIPPINGPAY varchar(50) NULL COMMENT '개별배송비';

ALTER TABLE SHOPGMARKET2ADDDTL ADD BUNDLEDSHIPPINGYN varchar(50) NULL COMMENT '묶음배송 사용여부';
ALTER TABLE SHOPGMARKET2ADDDTL ADD BUNDLEDSHIPPINGPAYYN varchar(50) NULL COMMENT '개별배송비 유료 무료';
ALTER TABLE SHOPGMARKET2ADDDTL ADD BUNDLEDSHIPPINGPAY varchar(50) NULL COMMENT '개별배송비';

DROP TABLE SHOPADDPRODINFO;

CREATE TABLE `SHOPADDPRODINFO` (
  `PRODSEQ` int NOT NULL COMMENT '기본 상품정보 SEQ',
  `SKUSEQ` int NOT NULL COMMENT '기본 상품별 SEQ',
  `COMPNO` int NOT NULL COMMENT '회사 코드',
  `COMPAYNY_GOODS_CD` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '부모상품코드',
  `USER_CODE` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '유저관리코드',
  `PROD_TYPE1` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '추가상품타입1(추가상품명)',
  `PROD_VAL1` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '추가상품값1',
  `PROD_TYPE2` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '추가상품타입2',
  `PROD_VAL2` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '추가상품값2',
  `PROD_AMT` int DEFAULT NULL COMMENT '추가상품금액',
  `PROD_CNT` int DEFAULT NULL COMMENT '추가상품수량',
  `INSERTDT` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '입력일자',
  `INSERTID` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '입력ID',
  `MODIFYDT` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '수정일자',
  `MODIFYID` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '수정ID',
  PRIMARY KEY (`PRODSEQ`,`SKUSEQ`,`COMPNO`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='추가상품 정보테이블';

ALTER TABLE SHOPPRODIN MODIFY COLUMN CHAR_1_NM varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '옵션제목(1)';
ALTER TABLE SHOPPRODIN MODIFY COLUMN CHAR_2_NM varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '옵션제목(2)';

ALTER TABLE SHOPPRODINFO MODIFY COLUMN CHAR_1_NM varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '옵션제목(1)';
ALTER TABLE SHOPPRODINFO MODIFY COLUMN CHAR_2_NM varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '옵션제목(2)';

ALTER TABLE SHOPTOSSSHOPPINGADDDTL ADD DELIVERYMETHOD varchar(200) NULL COMMENT '배송 방식';
ALTER TABLE SHOPTOSSSHOPPINGADDDTL ADD ISGROUPDELIVERY varchar(2) NULL COMMENT '묶음배송 여부';
ALTER TABLE SHOPTOSSSHOPPINGADDDTL ADD LOCATIONID varchar(200) NULL COMMENT '묶음배송 로케이션아이디';
ALTER TABLE SHOPTOSSSHOPPINGADDDTL ADD DELIVERYFEETYPE varchar(200) NULL COMMENT '배송비 유형';
ALTER TABLE SHOPTOSSSHOPPINGADDDTL ADD JEJUDELIVERYFEE INT NULL COMMENT '제주도 추가 배송비';
ALTER TABLE SHOPTOSSSHOPPINGADDDTL ADD EXCHANGEROUNDTRIPDELIVERYFEE INT NULL COMMENT '교환 왕복 배송비';
ALTER TABLE SHOPTOSSSHOPPINGADDDTL ADD GROUPDELIVERYNAME varchar(200) NULL COMMENT '묶음그룹명';
ALTER TABLE SHOPTOSSSHOPPINGADDDTL ADD REFUNDEXCHANGENAME varchar(200) NULL COMMENT '교환반품지명';
ALTER TABLE SHOPTOSSSHOPPINGADDDTL ADD REFUNDEXCHANGELOCATIONID varchar(200) NULL COMMENT '교환반품 로케이션 아이디';

ALTER TABLE SCHEDUSITE ADD PRODQTY INT NULL DEFAULT 0 COMMENT '교환반품 로케이션 아이디';
ALTER TABLE SCHEDUINFO MODIFY COLUMN FEWMINU1 varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL;
ALTER TABLE SCHEDUINFO MODIFY COLUMN FEWMINU2 varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL;
ALTER TABLE SCHEDUINFO MODIFY COLUMN FEWMINU3 varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL;
ALTER TABLE SCHEDUINFO MODIFY COLUMN FEWMINU4 varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL;

ALTER TABLE SCHEDUINFO ADD WEEKCHK5 char(1) NULL;
ALTER TABLE SCHEDUINFO ADD FEWMINU5 varchar(10) NULL;
ALTER TABLE SCHEDUINFO ADD WEEKCHK6 char(1) NULL;
ALTER TABLE SCHEDUINFO ADD FEWMINU6 varchar(10) NULL;
ALTER TABLE SCHEDUINFO ADD WEEKCHK7 char(1) NULL;
ALTER TABLE SCHEDUINFO ADD FEWMINU7 varchar(10) NULL;
ALTER TABLE SCHEDUINFO ADD COUPPRODCHK char(1) NULL COMMENT '쿠팡 아이템위너 상품 삭제여부';
ALTER TABLE SCHEDUINFO ADD NAVERPRODCHK char(1) NULL COMMENT '네이버 카탈로그 상품 삭제여부';

ALTER TABLE SCHEDUSITE ADD EXCLUDE_DATE varchar(10) NULL COMMENT '삭제 제외기간(30:현재일로부터 30일 이내 제외)';