delete FROM WORKMGRDETAIL 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 workmgrdetail 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 SHOPPRODINFO ADD INDEX `CLASS_CD3` (`CLASS_CD3`); ALTER TABLE SHOPPRODIN ADD INDEX `CLASS_CD3` (`CLASS_CD3`); ALTER TABLE QNALIST ADD COLUMN `ANSNO` VARCHAR(50) NULL DEFAULT NULL AFTER `INSNM2`; UPDATE SHOPINFODOME SET ORDERCOLLECT='서비스', `INVOICSEND`='서비스' WHERE `SHOPCD`='shop0319'; ALTER TABLE SHOPADDRKAKAODTL ADD COLUMN `ORIGINYN` VARCHAR(20) NULL DEFAULT NULL COMMENT '상품원산지 사용여부' AFTER `PRODDETAILOUTPUT`; UPDATE SHOPINFODOME` SET `INVOICSEND`='서비스' WHERE `SHOPCD`='shop9992'; UPDATE SHOPINFODOME` SET `INVOICSEND`='서비스' WHERE `SHOPCD`='shop9995'; UPDATE SHOPINFO SET `CLAIMCOLLECT`='서비스', `QUESTION`='서비스' WHERE `SHOPCD`='shop0273'; UPDATE SHOPINFO SET `CLAIMCOLLECT`='서비스', `QUESTION`='서비스' WHERE `SHOPCD`='shop0287'; UPDATE SHOPDELIVERYS SET `DOSIN_CODE`='롯데택배' WHERE `SHOPCD`='shop0273' AND `DLVID`='9'; ALTER TABLE SHOP_OPTPRODINFO ADD INDEX `COMPNO_PRODCD` (`COMPNO`, `PRODCD`); UPDATE SHOPINFODOME` SET `ORDERCOLLECT`='서비스' WHERE `SHOPCD`='shop9992'; UPDATE SHOPINFODOME` SET `ORDERCOLLECT`='서비스' WHERE `SHOPCD`='shop9994'; UPDATE SHOPINFODOME` SET `ORDERCOLLECT`='서비스' WHERE `SHOPCD`='shop9995'; UPDATE SHOPINFODOME` SET `SHOPNM`='W트레이딩' WHERE `SHOPCD`='shop9992'; ALTER TABLE PRODATTRNM ADD COLUMN `FUNNSEQ` VARCHAR(50) NULL DEFAULT NULL AFTER `ATTRNM`; ALTER TABLE PRODATTRNM ADD COLUMN `WTRADINGSEQ` VARCHAR(50) NULL DEFAULT NULL AFTER `FUNNSEQ`; ALTER TABLE PRODATTRNM ADD COLUMN `TOBIZONSEQ` VARCHAR(50) NULL DEFAULT NULL AFTER `WTRADINGSEQ`; ALTER TABLE PRODATTRNM ADD COLUMN `DOMEGGOOKSEQ` VARCHAR(50) NULL DEFAULT NULL AFTER `TOBIZONSEQ`; ALTER TABLE PRODATTRNM ADD COLUMN `OWNERCLANSEQ` VARCHAR(50) NULL DEFAULT NULL AFTER `DOMEGGOOKSEQ`; ALTER TABLE PRODATTRNM ADD COLUMN `HUBSELLSEQ` VARCHAR(50) NULL DEFAULT NULL AFTER `OWNERCLANSEQ`; ALTER TABLE PRODATTR ADD COLUMN `LOTTECD` VARCHAR(50) NULL DEFAULT NULL AFTER `FLAGDEFT`; ALTER TABLE PRODATTR ADD COLUMN `MELCHICD` VARCHAR(50) NULL DEFAULT NULL AFTER `KAKAOCD`; drop table SHOPLOTTEONATTR; DROP TABLE SHOPMELCHIATTR; insert into SHOPDELIVERYS(SHOPCD, DLVID, DLVNM, EXPRESS_URL_ID, DOSIN_CODE) values ('shop0372','0050','호남택배',11,'호남택배'), ('shop0372','0049','합동택배',0,'합동택배'), ('shop0372','0006','한진택배',9,'한진택배'), ('shop0372','0044','편의점택배',13,'편의점택배'), ('shop0372','0043','천일택배',7,'천일택배'), ('shop0372','0041','일양로지스',6,'일양택배'), ('shop0372','0004','우체국택배',5,'우체국택배'), ('shop0372','0039','우체국등기',0,'우체국등기'), ('shop0372','9000','자체배송',0,'업체직배송'), ('shop0372','0300','삼성전자 로지택',0,'삼성전자물류'), ('shop0372','0001','롯데택배',10,'롯데택배'), ('shop0372','0005','로젠택배',3,'로젠택배'), ('shop0372','0028','대신택배',0,'대신택배'), ('shop0372','0024','경동택배',1,'경동택배'), ('shop0372','0023','건영택배',0,'건영택배'), ('shop0372','0016','KGB택배',0,'KGB특급택배'), ('shop0372','0010','EMS',15,'EMS국제우편'), ('shop0372','0008','DHL',14,'DHL'), ('shop0372','0002','CJ대한통운',12,'CJ 대한통운'), ('shop0372','0051','KT로지스',0,''), ('shop0372','0052','사가와',0,''), ('shop0372','0053','우리택배',0,''), ('shop0372','0054','제니엘',0,''), ('shop0372','0055','롯데택배 해외특송',0,''), ('shop0372','0048','한의사랑택배',8,''), ('shop0372','0058','큐런택배',0,''), ('shop0372','0047','한덱스',0,''), ('shop0372','0046','하나로택배',0,''), ('shop0372','0045','포시즌익스프레스',0,''), ('shop0372','0059','SBGLS',0,''), ('shop0372','0060','롯데칠성',0,''), ('shop0372','0150','VALEX',0,''), ('shop0372','0040','이노지스택배',0,''), ('shop0372','9999','기타택배',0,''), ('shop0372','0021','TPL',0,''), ('shop0372','0007','APEX(ECMS Express)',0,''), ('shop0372','0009','DHL Global Mail',0,''), ('shop0372','0011','Fedex',0,''), ('shop0372','0012','GSI Express',0,''), ('shop0372','0013','GSMNtoN(인로스)',0,''), ('shop0372','0014','GTX 로지스 택배',0,''), ('shop0372','0015','i-Parcel',0,''), ('shop0372','0017','KGL네트웍스',0,''), ('shop0372','0018','KG로지스',0,''), ('shop0372','0019','SEDEX',0,''), ('shop0372','0020','TNT Express',0,''), ('shop0372','0038','우체국',0,''), ('shop0372','0022','USPS',0,''), ('shop0372','0025','고려택배',0,''), ('shop0372','0026','굿투럭',0,''), ('shop0372','0030','동부익스프레스',0,''), ('shop0372','0031','드림택배',0,''), ('shop0372','0032','무지개오토특송',0,''), ('shop0372','0033','범한판토스',0,''), ('shop0372','0034','삼성HTH',0,''), ('shop0372','0035','애니트랙',0,''), ('shop0372','0036','에어보이익스프레스',0,''), ('shop0372','0037','엘로우캡택배',0,''); ALTER TABLE SHOP11STADDIDTL ADD COLUMN `ISCATEGORY` VARCHAR(50) NULL DEFAULT NULL AFTER `TITLE`, ADD COLUMN `LAGCATCD` VARCHAR(50) NULL DEFAULT NULL AFTER `ISCATEGORY`, ADD COLUMN `MIDCATCD` VARCHAR(50) NULL DEFAULT NULL AFTER `LAGCATCD`, ADD COLUMN `SMLCATCD` VARCHAR(50) NULL DEFAULT NULL AFTER `MIDCATCD`, ADD COLUMN `DETCATCD` VARCHAR(50) NULL DEFAULT NULL AFTER `SMLCATCD`, ADD COLUMN `SHOPCATNO` VARCHAR(50) NULL DEFAULT NULL AFTER `DETCATCD`, ADD COLUMN `SHOPCATSITENM` VARCHAR(50) NULL DEFAULT NULL AFTER `SHOPCATNO`; ALTER TABLE SHOPINTERPARKADDIDTL ADD COLUMN `ISCATEGORY` VARCHAR(50) NULL DEFAULT NULL AFTER `TITLE`, ADD COLUMN `LAGCATCD` VARCHAR(50) NULL DEFAULT NULL AFTER `ISCATEGORY`, ADD COLUMN `MIDCATCD` VARCHAR(50) NULL DEFAULT NULL AFTER `LAGCATCD`, ADD COLUMN `SMLCATCD` VARCHAR(50) NULL DEFAULT NULL AFTER `MIDCATCD`, ADD COLUMN `DETCATCD` VARCHAR(50) NULL DEFAULT NULL AFTER `SMLCATCD`, ADD COLUMN `SHOPCATNO` VARCHAR(50) NULL DEFAULT NULL AFTER `DETCATCD`, ADD COLUMN `SHOPCATSITENM` VARCHAR(50) NULL DEFAULT NULL AFTER `SHOPCATNO`; ALTER TABLE SHOPCOUPANGADDIDTL ADD COLUMN `ISCATEGORY` VARCHAR(50) NULL DEFAULT NULL AFTER `TITLE`, ADD COLUMN `LAGCATCD` VARCHAR(50) NULL DEFAULT NULL AFTER `ISCATEGORY`, ADD COLUMN `MIDCATCD` VARCHAR(50) NULL DEFAULT NULL AFTER `LAGCATCD`, ADD COLUMN `SMLCATCD` VARCHAR(50) NULL DEFAULT NULL AFTER `MIDCATCD`, ADD COLUMN `DETCATCD` VARCHAR(50) NULL DEFAULT NULL AFTER `SMLCATCD`, ADD COLUMN `SHOPCATNO` VARCHAR(50) NULL DEFAULT NULL AFTER `DETCATCD`, ADD COLUMN `SHOPCATSITENM` VARCHAR(50) NULL DEFAULT NULL AFTER `SHOPCATNO`; ALTER TABLE SHOPADDRNAVERSTOREDTL ADD COLUMN `ISCATEGORY` VARCHAR(50) NULL DEFAULT NULL AFTER `TITLE`, ADD COLUMN `LAGCATCD` VARCHAR(50) NULL DEFAULT NULL AFTER `ISCATEGORY`, ADD COLUMN `MIDCATCD` VARCHAR(50) NULL DEFAULT NULL AFTER `LAGCATCD`, ADD COLUMN `SMLCATCD` VARCHAR(50) NULL DEFAULT NULL AFTER `MIDCATCD`, ADD COLUMN `DETCATCD` VARCHAR(50) NULL DEFAULT NULL AFTER `SMLCATCD`, ADD COLUMN `SHOPCATNO` VARCHAR(50) NULL DEFAULT NULL AFTER `DETCATCD`, ADD COLUMN `SHOPCATSITENM` VARCHAR(50) NULL DEFAULT NULL AFTER `SHOPCATNO`; ALTER TABLE SHOPADDRKAKAODTL ADD COLUMN `ISCATEGORY` VARCHAR(50) NULL DEFAULT NULL AFTER `TITLE`, ADD COLUMN `LAGCATCD` VARCHAR(50) NULL DEFAULT NULL AFTER `ISCATEGORY`, ADD COLUMN `MIDCATCD` VARCHAR(50) NULL DEFAULT NULL AFTER `LAGCATCD`, ADD COLUMN `SMLCATCD` VARCHAR(50) NULL DEFAULT NULL AFTER `MIDCATCD`, ADD COLUMN `DETCATCD` VARCHAR(50) NULL DEFAULT NULL AFTER `SMLCATCD`, ADD COLUMN `SHOPCATNO` VARCHAR(50) NULL DEFAULT NULL AFTER `DETCATCD`, ADD COLUMN `SHOPCATSITENM` VARCHAR(50) NULL DEFAULT NULL AFTER `SHOPCATNO`; ALTER TABLE SHOPAUCTION2ADDDTL ADD COLUMN `ISCATEGORY` VARCHAR(50) NULL DEFAULT NULL AFTER `TITLE`, ADD COLUMN `LAGCATCD` VARCHAR(50) NULL DEFAULT NULL AFTER `ISCATEGORY`, ADD COLUMN `MIDCATCD` VARCHAR(50) NULL DEFAULT NULL AFTER `LAGCATCD`, ADD COLUMN `SMLCATCD` VARCHAR(50) NULL DEFAULT NULL AFTER `MIDCATCD`, ADD COLUMN `DETCATCD` VARCHAR(50) NULL DEFAULT NULL AFTER `SMLCATCD`, ADD COLUMN `SHOPCATNO` VARCHAR(50) NULL DEFAULT NULL AFTER `DETCATCD`, ADD COLUMN `SHOPCATSITENM` VARCHAR(50) NULL DEFAULT NULL AFTER `SHOPCATNO`; ALTER TABLE SHOPAUCTIONADDDTL ADD COLUMN `ISCATEGORY` VARCHAR(50) NULL DEFAULT NULL AFTER `TITLE`, ADD COLUMN `LAGCATCD` VARCHAR(50) NULL DEFAULT NULL AFTER `ISCATEGORY`, ADD COLUMN `MIDCATCD` VARCHAR(50) NULL DEFAULT NULL AFTER `LAGCATCD`, ADD COLUMN `SMLCATCD` VARCHAR(50) NULL DEFAULT NULL AFTER `MIDCATCD`, ADD COLUMN `DETCATCD` VARCHAR(50) NULL DEFAULT NULL AFTER `SMLCATCD`, ADD COLUMN `SHOPCATNO` VARCHAR(50) NULL DEFAULT NULL AFTER `DETCATCD`, ADD COLUMN `SHOPCATSITENM` VARCHAR(50) NULL DEFAULT NULL AFTER `SHOPCATNO`; ALTER TABLE SHOPGMARKET2ADDDTL ADD COLUMN `ISCATEGORY` VARCHAR(50) NULL DEFAULT NULL AFTER `TITLE`, ADD COLUMN `LAGCATCD` VARCHAR(50) NULL DEFAULT NULL AFTER `ISCATEGORY`, ADD COLUMN `MIDCATCD` VARCHAR(50) NULL DEFAULT NULL AFTER `LAGCATCD`, ADD COLUMN `SMLCATCD` VARCHAR(50) NULL DEFAULT NULL AFTER `MIDCATCD`, ADD COLUMN `DETCATCD` VARCHAR(50) NULL DEFAULT NULL AFTER `SMLCATCD`, ADD COLUMN `SHOPCATNO` VARCHAR(50) NULL DEFAULT NULL AFTER `DETCATCD`, ADD COLUMN `SHOPCATSITENM` VARCHAR(50) NULL DEFAULT NULL AFTER `SHOPCATNO`; ALTER TABLE SHOPGMARKETADDDTL ADD COLUMN `ISCATEGORY` VARCHAR(50) NULL DEFAULT NULL AFTER `TITLE`, ADD COLUMN `LAGCATCD` VARCHAR(50) NULL DEFAULT NULL AFTER `ISCATEGORY`, ADD COLUMN `MIDCATCD` VARCHAR(50) NULL DEFAULT NULL AFTER `LAGCATCD`, ADD COLUMN `SMLCATCD` VARCHAR(50) NULL DEFAULT NULL AFTER `MIDCATCD`, ADD COLUMN `DETCATCD` VARCHAR(50) NULL DEFAULT NULL AFTER `SMLCATCD`, ADD COLUMN `SHOPCATNO` VARCHAR(50) NULL DEFAULT NULL AFTER `DETCATCD`, ADD COLUMN `SHOPCATSITENM` VARCHAR(50) NULL DEFAULT NULL AFTER `SHOPCATNO`; ALTER TABLE SHOPSSGADDIDTL ADD COLUMN `ISCATEGORY` VARCHAR(50) NULL DEFAULT NULL AFTER `TITLE`, ADD COLUMN `LAGCATCD` VARCHAR(50) NULL DEFAULT NULL AFTER `ISCATEGORY`, ADD COLUMN `MIDCATCD` VARCHAR(50) NULL DEFAULT NULL AFTER `LAGCATCD`, ADD COLUMN `SMLCATCD` VARCHAR(50) NULL DEFAULT NULL AFTER `MIDCATCD`, ADD COLUMN `DETCATCD` VARCHAR(50) NULL DEFAULT NULL AFTER `SMLCATCD`, ADD COLUMN `SHOPCATNO` VARCHAR(50) NULL DEFAULT NULL AFTER `DETCATCD`, ADD COLUMN `SHOPCATSITENM` VARCHAR(50) NULL DEFAULT NULL AFTER `SHOPCATNO`; ALTER TABLE SHOPTMONADDIDTL ADD COLUMN `ISCATEGORY` VARCHAR(50) NULL DEFAULT NULL AFTER `TITLE`, ADD COLUMN `LAGCATCD` VARCHAR(50) NULL DEFAULT NULL AFTER `ISCATEGORY`, ADD COLUMN `MIDCATCD` VARCHAR(50) NULL DEFAULT NULL AFTER `LAGCATCD`, ADD COLUMN `SMLCATCD` VARCHAR(50) NULL DEFAULT NULL AFTER `MIDCATCD`, ADD COLUMN `DETCATCD` VARCHAR(50) NULL DEFAULT NULL AFTER `SMLCATCD`, ADD COLUMN `SHOPCATNO` VARCHAR(50) NULL DEFAULT NULL AFTER `DETCATCD`, ADD COLUMN `SHOPCATSITENM` VARCHAR(50) NULL DEFAULT NULL AFTER `SHOPCATNO`; ALTER TABLE SHOPWEMARKETADDDTL ADD COLUMN `ISCATEGORY` VARCHAR(50) NULL DEFAULT NULL AFTER `TITLE`, ADD COLUMN `LAGCATCD` VARCHAR(50) NULL DEFAULT NULL AFTER `ISCATEGORY`, ADD COLUMN `MIDCATCD` VARCHAR(50) NULL DEFAULT NULL AFTER `LAGCATCD`, ADD COLUMN `SMLCATCD` VARCHAR(50) NULL DEFAULT NULL AFTER `MIDCATCD`, ADD COLUMN `DETCATCD` VARCHAR(50) NULL DEFAULT NULL AFTER `SMLCATCD`, ADD COLUMN `SHOPCATNO` VARCHAR(50) NULL DEFAULT NULL AFTER `DETCATCD`, ADD COLUMN `SHOPCATSITENM` VARCHAR(50) NULL DEFAULT NULL AFTER `SHOPCATNO`; ALTER TABLE SHOP11STADDIDTL ADD COLUMN `CHANGESIZE` VARCHAR(50) NULL DEFAULT NULL COMMENT '대표사진사이즈변경 버튼' AFTER `STFPRDYN`, ADD COLUMN `CHANGESIZEX` VARCHAR(50) NULL DEFAULT NULL COMMENT '대표사진사이즈변경 X' AFTER `CHANGESIZE`, ADD COLUMN `CHANGESIZEY` VARCHAR(50) NULL DEFAULT NULL COMMENT '대표사진사이즈변경 Y' AFTER `CHANGESIZEX`, ADD COLUMN `CHANGESIZEW` VARCHAR(50) NULL DEFAULT NULL COMMENT '대표사진사이즈변경 W' AFTER `CHANGESIZEY`, ADD COLUMN `CHANGESIZEH` VARCHAR(50) NULL DEFAULT NULL COMMENT '대표사진사이즈변경 H' AFTER `CHANGESIZEW`, ADD COLUMN `DETAILKEYWORDB` VARCHAR(50) NULL DEFAULT NULL COMMENT '상세페이지 상단 (키워드) 버튼' AFTER `CHANGESIZEH`, ADD COLUMN `DETAILKEYWORDL` TEXT NULL COMMENT '상세페이지 상단 (키워드)' AFTER `DETAILKEYWORDB`, ADD COLUMN `DETAILKEYWORDR` TEXT NULL AFTER `DETAILKEYWORDL`, ADD COLUMN `DETAILPRODUCTCODEB` VARCHAR(50) NULL DEFAULT NULL COMMENT '상세페이지 상단 (상품코드) 버튼' AFTER `DETAILKEYWORDR`, ADD COLUMN `DETAILPRODUCTCODEL` TEXT NULL COMMENT '상세페이지 상단 (상품코드)' AFTER `DETAILPRODUCTCODEB`, ADD COLUMN `DETAILPRODUCTCODER` TEXT NULL AFTER `DETAILPRODUCTCODEL`, ADD COLUMN `DETAILPRODUCTNAMEB` VARCHAR(50) NULL DEFAULT NULL COMMENT '상세페이지 상단 (상품명) 버튼' AFTER `DETAILPRODUCTCODER`, ADD COLUMN `DETAILPRODUCTNAMEL` TEXT NULL COMMENT '상세페이지 상단 (상품명)' AFTER `DETAILPRODUCTNAMEB`, ADD COLUMN `DETAILPRODUCTNAMER` TEXT NULL AFTER `DETAILPRODUCTNAMEL`, ADD COLUMN `ADDOPTIONLB` VARCHAR(50) NULL DEFAULT NULL COMMENT '옵션추가 왼쪽 버튼' AFTER `DETAILPRODUCTNAMER`; ALTER TABLE SHOP11STADDIDTL ADD COLUMN `ADDOPTIONL` VARCHAR(50) NULL DEFAULT NULL COMMENT '옵션추가 왼쪽' COLLATE 'utf8mb4_0900_ai_ci' AFTER `ADDOPTIONLB`, ADD COLUMN `ADDOPTIONRB` VARCHAR(50) NULL DEFAULT NULL COMMENT '옵션추가 오른쪽 버튼' COLLATE 'utf8mb4_0900_ai_ci' AFTER `ADDOPTIONL`, ADD COLUMN `ADDOPTIONR` VARCHAR(50) NULL DEFAULT NULL COMMENT '옵션추가 오른쪽' COLLATE 'utf8mb4_0900_ai_ci' AFTER `ADDOPTIONRB`; ALTER TABLE SHOPINTERPARKADDIDTL ADD COLUMN `CHANGESIZE` VARCHAR(50) NULL DEFAULT NULL COMMENT '대표사진사이즈변경 버튼' AFTER `PACKAGEPERIOD`, ADD COLUMN `CHANGESIZEX` VARCHAR(50) NULL DEFAULT NULL COMMENT '대표사진사이즈변경 X' AFTER `CHANGESIZE`, ADD COLUMN `CHANGESIZEY` VARCHAR(50) NULL DEFAULT NULL COMMENT '대표사진사이즈변경 Y' AFTER `CHANGESIZEX`, ADD COLUMN `CHANGESIZEW` VARCHAR(50) NULL DEFAULT NULL COMMENT '대표사진사이즈변경 W' AFTER `CHANGESIZEY`, ADD COLUMN `CHANGESIZEH` VARCHAR(50) NULL DEFAULT NULL COMMENT '대표사진사이즈변경 H' AFTER `CHANGESIZEW`, ADD COLUMN `DETAILKEYWORDB` VARCHAR(50) NULL DEFAULT NULL COMMENT '상세페이지 상단 (키워드) 버튼' AFTER `CHANGESIZEH`, ADD COLUMN `DETAILKEYWORDL` TEXT NULL COMMENT '상세페이지 상단 (키워드)' AFTER `DETAILKEYWORDB`, ADD COLUMN `DETAILKEYWORDR` TEXT NULL AFTER `DETAILKEYWORDL`, ADD COLUMN `DETAILPRODUCTCODEB` VARCHAR(50) NULL DEFAULT NULL COMMENT '상세페이지 상단 (상품코드) 버튼' AFTER `DETAILKEYWORDR`, ADD COLUMN `DETAILPRODUCTCODEL` TEXT NULL COMMENT '상세페이지 상단 (상품코드)' AFTER `DETAILPRODUCTCODEB`, ADD COLUMN `DETAILPRODUCTCODER` TEXT NULL AFTER `DETAILPRODUCTCODEL`, ADD COLUMN `DETAILPRODUCTNAMEB` VARCHAR(50) NULL DEFAULT NULL COMMENT '상세페이지 상단 (상품명) 버튼' AFTER `DETAILPRODUCTCODER`, ADD COLUMN `DETAILPRODUCTNAMEL` TEXT NULL COMMENT '상세페이지 상단 (상품명)' AFTER `DETAILPRODUCTNAMEB`, ADD COLUMN `DETAILPRODUCTNAMER` TEXT NULL AFTER `DETAILPRODUCTNAMEL`, ADD COLUMN `ADDOPTIONLB` VARCHAR(50) NULL DEFAULT NULL COMMENT '옵션추가 왼쪽 버튼' AFTER `DETAILPRODUCTNAMER`; ALTER TABLE SHOPINTERPARKADDIDTL ADD COLUMN `ADDOPTIONL` VARCHAR(50) NULL DEFAULT NULL COMMENT '옵션추가 왼쪽' COLLATE 'utf8mb4_0900_ai_ci' AFTER `ADDOPTIONLB`, ADD COLUMN `ADDOPTIONRB` VARCHAR(50) NULL DEFAULT NULL COMMENT '옵션추가 오른쪽 버튼' COLLATE 'utf8mb4_0900_ai_ci' AFTER `ADDOPTIONL`, ADD COLUMN `ADDOPTIONR` VARCHAR(50) NULL DEFAULT NULL COMMENT '옵션추가 오른쪽' COLLATE 'utf8mb4_0900_ai_ci' AFTER `ADDOPTIONRB`; ALTER TABLE SHOPCOUPANGADDIDTL ADD COLUMN `CHANGESIZE` VARCHAR(50) NULL DEFAULT NULL COMMENT '대표사진사이즈변경 버튼' AFTER `UESYN`, ADD COLUMN `CHANGESIZEX` VARCHAR(50) NULL DEFAULT NULL COMMENT '대표사진사이즈변경 X' AFTER `CHANGESIZE`, ADD COLUMN `CHANGESIZEY` VARCHAR(50) NULL DEFAULT NULL COMMENT '대표사진사이즈변경 Y' AFTER `CHANGESIZEX`, ADD COLUMN `CHANGESIZEW` VARCHAR(50) NULL DEFAULT NULL COMMENT '대표사진사이즈변경 W' AFTER `CHANGESIZEY`, ADD COLUMN `CHANGESIZEH` VARCHAR(50) NULL DEFAULT NULL COMMENT '대표사진사이즈변경 H' AFTER `CHANGESIZEW`, ADD COLUMN `DETAILKEYWORDB` VARCHAR(50) NULL DEFAULT NULL COMMENT '상세페이지 상단 (키워드) 버튼' AFTER `CHANGESIZEH`, ADD COLUMN `DETAILKEYWORDL` TEXT NULL COMMENT '상세페이지 상단 (키워드)' AFTER `DETAILKEYWORDB`, ADD COLUMN `DETAILKEYWORDR` TEXT NULL AFTER `DETAILKEYWORDL`, ADD COLUMN `DETAILPRODUCTCODEB` VARCHAR(50) NULL DEFAULT NULL COMMENT '상세페이지 상단 (상품코드) 버튼' AFTER `DETAILKEYWORDR`, ADD COLUMN `DETAILPRODUCTCODEL` TEXT NULL COMMENT '상세페이지 상단 (상품코드)' AFTER `DETAILPRODUCTCODEB`, ADD COLUMN `DETAILPRODUCTCODER` TEXT NULL AFTER `DETAILPRODUCTCODEL`, ADD COLUMN `DETAILPRODUCTNAMEB` VARCHAR(50) NULL DEFAULT NULL COMMENT '상세페이지 상단 (상품명) 버튼' AFTER `DETAILPRODUCTCODER`, ADD COLUMN `DETAILPRODUCTNAMEL` TEXT NULL COMMENT '상세페이지 상단 (상품명)' AFTER `DETAILPRODUCTNAMEB`, ADD COLUMN `DETAILPRODUCTNAMER` TEXT NULL AFTER `DETAILPRODUCTNAMEL`, ADD COLUMN `ADDOPTIONLB` VARCHAR(50) NULL DEFAULT NULL COMMENT '옵션추가 왼쪽 버튼' AFTER `DETAILPRODUCTNAMER`; ALTER TABLE SHOPCOUPANGADDIDTL ADD COLUMN `ADDOPTIONL` VARCHAR(50) NULL DEFAULT NULL COMMENT '옵션추가 왼쪽' COLLATE 'utf8mb4_0900_ai_ci' AFTER `ADDOPTIONLB`, ADD COLUMN `ADDOPTIONRB` VARCHAR(50) NULL DEFAULT NULL COMMENT '옵션추가 오른쪽 버튼' COLLATE 'utf8mb4_0900_ai_ci' AFTER `ADDOPTIONL`, ADD COLUMN `ADDOPTIONR` VARCHAR(50) NULL DEFAULT NULL COMMENT '옵션추가 오른쪽' COLLATE 'utf8mb4_0900_ai_ci' AFTER `ADDOPTIONRB`; ALTER TABLE SHOPADDRNAVERSTOREDTL ADD COLUMN `CHANGESIZE` VARCHAR(50) NULL DEFAULT NULL COMMENT '대표사진사이즈변경 버튼' AFTER `BUNDLEREGDATE`, ADD COLUMN `CHANGESIZEX` VARCHAR(50) NULL DEFAULT NULL COMMENT '대표사진사이즈변경 X' AFTER `CHANGESIZE`, ADD COLUMN `CHANGESIZEY` VARCHAR(50) NULL DEFAULT NULL COMMENT '대표사진사이즈변경 Y' AFTER `CHANGESIZEX`, ADD COLUMN `CHANGESIZEW` VARCHAR(50) NULL DEFAULT NULL COMMENT '대표사진사이즈변경 W' AFTER `CHANGESIZEY`, ADD COLUMN `CHANGESIZEH` VARCHAR(50) NULL DEFAULT NULL COMMENT '대표사진사이즈변경 H' AFTER `CHANGESIZEW`, ADD COLUMN `DETAILKEYWORDB` VARCHAR(50) NULL DEFAULT NULL COMMENT '상세페이지 상단 (키워드) 버튼' AFTER `CHANGESIZEH`, ADD COLUMN `DETAILKEYWORDL` TEXT NULL COMMENT '상세페이지 상단 (키워드)' AFTER `DETAILKEYWORDB`, ADD COLUMN `DETAILKEYWORDR` TEXT NULL AFTER `DETAILKEYWORDL`, ADD COLUMN `DETAILPRODUCTCODEB` VARCHAR(50) NULL DEFAULT NULL COMMENT '상세페이지 상단 (상품코드) 버튼' AFTER `DETAILKEYWORDR`, ADD COLUMN `DETAILPRODUCTCODEL` TEXT NULL COMMENT '상세페이지 상단 (상품코드)' AFTER `DETAILPRODUCTCODEB`, ADD COLUMN `DETAILPRODUCTCODER` TEXT NULL AFTER `DETAILPRODUCTCODEL`, ADD COLUMN `DETAILPRODUCTNAMEB` VARCHAR(50) NULL DEFAULT NULL COMMENT '상세페이지 상단 (상품명) 버튼' AFTER `DETAILPRODUCTCODER`, ADD COLUMN `DETAILPRODUCTNAMEL` TEXT NULL COMMENT '상세페이지 상단 (상품명)' AFTER `DETAILPRODUCTNAMEB`, ADD COLUMN `DETAILPRODUCTNAMER` TEXT NULL AFTER `DETAILPRODUCTNAMEL`, ADD COLUMN `ADDOPTIONLB` VARCHAR(50) NULL DEFAULT NULL COMMENT '옵션추가 왼쪽 버튼' AFTER `DETAILPRODUCTNAMER`; ALTER TABLE SHOPADDRNAVERSTOREDTL ADD COLUMN `ADDOPTIONL` VARCHAR(50) NULL DEFAULT NULL COMMENT '옵션추가 왼쪽' COLLATE 'utf8mb4_0900_ai_ci' AFTER `ADDOPTIONLB`, ADD COLUMN `ADDOPTIONRB` VARCHAR(50) NULL DEFAULT NULL COMMENT '옵션추가 오른쪽 버튼' COLLATE 'utf8mb4_0900_ai_ci' AFTER `ADDOPTIONL`, ADD COLUMN `ADDOPTIONR` VARCHAR(50) NULL DEFAULT NULL COMMENT '옵션추가 오른쪽' COLLATE 'utf8mb4_0900_ai_ci' AFTER `ADDOPTIONRB`; ALTER TABLE SHOPADDRKAKAODTL ADD COLUMN `CHANGESIZE` VARCHAR(50) NULL DEFAULT NULL COMMENT '대표사진사이즈변경 버튼' AFTER `ORIGINYN`, ADD COLUMN `CHANGESIZEX` VARCHAR(50) NULL DEFAULT NULL COMMENT '대표사진사이즈변경 X' AFTER `CHANGESIZE`, ADD COLUMN `CHANGESIZEY` VARCHAR(50) NULL DEFAULT NULL COMMENT '대표사진사이즈변경 Y' AFTER `CHANGESIZEX`, ADD COLUMN `CHANGESIZEW` VARCHAR(50) NULL DEFAULT NULL COMMENT '대표사진사이즈변경 W' AFTER `CHANGESIZEY`, ADD COLUMN `CHANGESIZEH` VARCHAR(50) NULL DEFAULT NULL COMMENT '대표사진사이즈변경 H' AFTER `CHANGESIZEW`, ADD COLUMN `DETAILKEYWORDB` VARCHAR(50) NULL DEFAULT NULL COMMENT '상세페이지 상단 (키워드) 버튼' AFTER `CHANGESIZEH`, ADD COLUMN `DETAILKEYWORDL` TEXT NULL COMMENT '상세페이지 상단 (키워드)' AFTER `DETAILKEYWORDB`, ADD COLUMN `DETAILKEYWORDR` TEXT NULL AFTER `DETAILKEYWORDL`, ADD COLUMN `DETAILPRODUCTCODEB` VARCHAR(50) NULL DEFAULT NULL COMMENT '상세페이지 상단 (상품코드) 버튼' AFTER `DETAILKEYWORDR`, ADD COLUMN `DETAILPRODUCTCODEL` TEXT NULL COMMENT '상세페이지 상단 (상품코드)' AFTER `DETAILPRODUCTCODEB`, ADD COLUMN `DETAILPRODUCTCODER` TEXT NULL AFTER `DETAILPRODUCTCODEL`, ADD COLUMN `DETAILPRODUCTNAMEB` VARCHAR(50) NULL DEFAULT NULL COMMENT '상세페이지 상단 (상품명) 버튼' AFTER `DETAILPRODUCTCODER`, ADD COLUMN `DETAILPRODUCTNAMEL` TEXT NULL COMMENT '상세페이지 상단 (상품명)' AFTER `DETAILPRODUCTNAMEB`, ADD COLUMN `DETAILPRODUCTNAMER` TEXT NULL AFTER `DETAILPRODUCTNAMEL`, ADD COLUMN `ADDOPTIONLB` VARCHAR(50) NULL DEFAULT NULL COMMENT '옵션추가 왼쪽 버튼' AFTER `DETAILPRODUCTNAMER`, ADD COLUMN `ADDOPTIONL` VARCHAR(50) NULL DEFAULT NULL COMMENT '옵션추가 왼쪽' COLLATE 'utf8mb4_0900_ai_ci' AFTER `ADDOPTIONLB`, ADD COLUMN `ADDOPTIONRB` VARCHAR(50) NULL DEFAULT NULL COMMENT '옵션추가 오른쪽 버튼' COLLATE 'utf8mb4_0900_ai_ci' AFTER `ADDOPTIONL`, ADD COLUMN `ADDOPTIONR` VARCHAR(50) NULL DEFAULT NULL COMMENT '옵션추가 오른쪽' COLLATE 'utf8mb4_0900_ai_ci' AFTER `ADDOPTIONRB`; ALTER TABLE SHOPAUCTION2ADDDTL ADD COLUMN `CHANGESIZE` VARCHAR(50) NULL DEFAULT NULL COMMENT '대표사진사이즈변경 버튼' AFTER `PRODNMVOLD1`, ADD COLUMN `CHANGESIZEX` VARCHAR(50) NULL DEFAULT NULL COMMENT '대표사진사이즈변경 X' AFTER `CHANGESIZE`, ADD COLUMN `CHANGESIZEY` VARCHAR(50) NULL DEFAULT NULL COMMENT '대표사진사이즈변경 Y' AFTER `CHANGESIZEX`, ADD COLUMN `CHANGESIZEW` VARCHAR(50) NULL DEFAULT NULL COMMENT '대표사진사이즈변경 W' AFTER `CHANGESIZEY`, ADD COLUMN `CHANGESIZEH` VARCHAR(50) NULL DEFAULT NULL COMMENT '대표사진사이즈변경 H' AFTER `CHANGESIZEW`, ADD COLUMN `DETAILKEYWORDB` VARCHAR(50) NULL DEFAULT NULL COMMENT '상세페이지 상단 (키워드) 버튼' AFTER `CHANGESIZEH`, ADD COLUMN `DETAILKEYWORDL` TEXT NULL COMMENT '상세페이지 상단 (키워드)' AFTER `DETAILKEYWORDB`, ADD COLUMN `DETAILKEYWORDR` TEXT NULL AFTER `DETAILKEYWORDL`, ADD COLUMN `DETAILPRODUCTCODEB` VARCHAR(50) NULL DEFAULT NULL COMMENT '상세페이지 상단 (상품코드) 버튼' AFTER `DETAILKEYWORDR`, ADD COLUMN `DETAILPRODUCTCODEL` TEXT NULL COMMENT '상세페이지 상단 (상품코드)' AFTER `DETAILPRODUCTCODEB`, ADD COLUMN `DETAILPRODUCTCODER` TEXT NULL AFTER `DETAILPRODUCTCODEL`, ADD COLUMN `DETAILPRODUCTNAMEB` VARCHAR(50) NULL DEFAULT NULL COMMENT '상세페이지 상단 (상품명) 버튼' AFTER `DETAILPRODUCTCODER`, ADD COLUMN `DETAILPRODUCTNAMEL` TEXT NULL COMMENT '상세페이지 상단 (상품명)' AFTER `DETAILPRODUCTNAMEB`, ADD COLUMN `DETAILPRODUCTNAMER` TEXT NULL AFTER `DETAILPRODUCTNAMEL`, ADD COLUMN `ADDOPTIONLB` VARCHAR(50) NULL DEFAULT NULL COMMENT '옵션추가 왼쪽 버튼' AFTER `DETAILPRODUCTNAMER`, ADD COLUMN `ADDOPTIONL` VARCHAR(50) NULL DEFAULT NULL COMMENT '옵션추가 왼쪽' COLLATE 'utf8mb4_0900_ai_ci' AFTER `ADDOPTIONLB`, ADD COLUMN `ADDOPTIONRB` VARCHAR(50) NULL DEFAULT NULL COMMENT '옵션추가 오른쪽 버튼' COLLATE 'utf8mb4_0900_ai_ci' AFTER `ADDOPTIONL`, ADD COLUMN `ADDOPTIONR` VARCHAR(50) NULL DEFAULT NULL COMMENT '옵션추가 오른쪽' COLLATE 'utf8mb4_0900_ai_ci' AFTER `ADDOPTIONRB`; ALTER TABLE SHOPAUCTIONADDDTL ADD COLUMN `CHANGESIZE` VARCHAR(50) NULL DEFAULT NULL COMMENT '대표사진사이즈변경 버튼' AFTER `PRODNMVOLD1`, ADD COLUMN `CHANGESIZEX` VARCHAR(50) NULL DEFAULT NULL COMMENT '대표사진사이즈변경 X' AFTER `CHANGESIZE`, ADD COLUMN `CHANGESIZEY` VARCHAR(50) NULL DEFAULT NULL COMMENT '대표사진사이즈변경 Y' AFTER `CHANGESIZEX`, ADD COLUMN `CHANGESIZEW` VARCHAR(50) NULL DEFAULT NULL COMMENT '대표사진사이즈변경 W' AFTER `CHANGESIZEY`, ADD COLUMN `CHANGESIZEH` VARCHAR(50) NULL DEFAULT NULL COMMENT '대표사진사이즈변경 H' AFTER `CHANGESIZEW`, ADD COLUMN `DETAILKEYWORDB` VARCHAR(50) NULL DEFAULT NULL COMMENT '상세페이지 상단 (키워드) 버튼' AFTER `CHANGESIZEH`, ADD COLUMN `DETAILKEYWORDL` TEXT NULL COMMENT '상세페이지 상단 (키워드)' AFTER `DETAILKEYWORDB`, ADD COLUMN `DETAILKEYWORDR` TEXT NULL AFTER `DETAILKEYWORDL`, ADD COLUMN `DETAILPRODUCTCODEB` VARCHAR(50) NULL DEFAULT NULL COMMENT '상세페이지 상단 (상품코드) 버튼' AFTER `DETAILKEYWORDR`, ADD COLUMN `DETAILPRODUCTCODEL` TEXT NULL COMMENT '상세페이지 상단 (상품코드)' AFTER `DETAILPRODUCTCODEB`, ADD COLUMN `DETAILPRODUCTCODER` TEXT NULL AFTER `DETAILPRODUCTCODEL`, ADD COLUMN `DETAILPRODUCTNAMEB` VARCHAR(50) NULL DEFAULT NULL COMMENT '상세페이지 상단 (상품명) 버튼' AFTER `DETAILPRODUCTCODER`, ADD COLUMN `DETAILPRODUCTNAMEL` TEXT NULL COMMENT '상세페이지 상단 (상품명)' AFTER `DETAILPRODUCTNAMEB`, ADD COLUMN `DETAILPRODUCTNAMER` TEXT NULL AFTER `DETAILPRODUCTNAMEL`, ADD COLUMN `ADDOPTIONLB` VARCHAR(50) NULL DEFAULT NULL COMMENT '옵션추가 왼쪽 버튼' AFTER `DETAILPRODUCTNAMER`, ADD COLUMN `ADDOPTIONL` VARCHAR(50) NULL DEFAULT NULL COMMENT '옵션추가 왼쪽' COLLATE 'utf8mb4_0900_ai_ci' AFTER `ADDOPTIONLB`, ADD COLUMN `ADDOPTIONRB` VARCHAR(50) NULL DEFAULT NULL COMMENT '옵션추가 오른쪽 버튼' COLLATE 'utf8mb4_0900_ai_ci' AFTER `ADDOPTIONL`, ADD COLUMN `ADDOPTIONR` VARCHAR(50) NULL DEFAULT NULL COMMENT '옵션추가 오른쪽' COLLATE 'utf8mb4_0900_ai_ci' AFTER `ADDOPTIONRB`; ALTER TABLE SHOPGMARKET2ADDDTL ADD COLUMN `CHANGESIZE` VARCHAR(50) NULL DEFAULT NULL COMMENT '대표사진사이즈변경 버튼' AFTER `FOCUSPLUS1`, ADD COLUMN `CHANGESIZEX` VARCHAR(50) NULL DEFAULT NULL COMMENT '대표사진사이즈변경 X' AFTER `CHANGESIZE`, ADD COLUMN `CHANGESIZEY` VARCHAR(50) NULL DEFAULT NULL COMMENT '대표사진사이즈변경 Y' AFTER `CHANGESIZEX`, ADD COLUMN `CHANGESIZEW` VARCHAR(50) NULL DEFAULT NULL COMMENT '대표사진사이즈변경 W' AFTER `CHANGESIZEY`, ADD COLUMN `CHANGESIZEH` VARCHAR(50) NULL DEFAULT NULL COMMENT '대표사진사이즈변경 H' AFTER `CHANGESIZEW`, ADD COLUMN `DETAILKEYWORDB` VARCHAR(50) NULL DEFAULT NULL COMMENT '상세페이지 상단 (키워드) 버튼' AFTER `CHANGESIZEH`, ADD COLUMN `DETAILKEYWORDL` TEXT NULL COMMENT '상세페이지 상단 (키워드)' AFTER `DETAILKEYWORDB`, ADD COLUMN `DETAILKEYWORDR` TEXT NULL AFTER `DETAILKEYWORDL`, ADD COLUMN `DETAILPRODUCTCODEB` VARCHAR(50) NULL DEFAULT NULL COMMENT '상세페이지 상단 (상품코드) 버튼' AFTER `DETAILKEYWORDR`, ADD COLUMN `DETAILPRODUCTCODEL` TEXT NULL COMMENT '상세페이지 상단 (상품코드)' AFTER `DETAILPRODUCTCODEB`, ADD COLUMN `DETAILPRODUCTCODER` TEXT NULL AFTER `DETAILPRODUCTCODEL`, ADD COLUMN `DETAILPRODUCTNAMEB` VARCHAR(50) NULL DEFAULT NULL COMMENT '상세페이지 상단 (상품명) 버튼' AFTER `DETAILPRODUCTCODER`, ADD COLUMN `DETAILPRODUCTNAMEL` TEXT NULL COMMENT '상세페이지 상단 (상품명)' AFTER `DETAILPRODUCTNAMEB`, ADD COLUMN `DETAILPRODUCTNAMER` TEXT NULL AFTER `DETAILPRODUCTNAMEL`, ADD COLUMN `ADDOPTIONLB` VARCHAR(50) NULL DEFAULT NULL COMMENT '옵션추가 왼쪽 버튼' AFTER `DETAILPRODUCTNAMER`, ADD COLUMN `ADDOPTIONL` VARCHAR(50) NULL DEFAULT NULL COMMENT '옵션추가 왼쪽' COLLATE 'utf8mb4_0900_ai_ci' AFTER `ADDOPTIONLB`, ADD COLUMN `ADDOPTIONRB` VARCHAR(50) NULL DEFAULT NULL COMMENT '옵션추가 오른쪽 버튼' COLLATE 'utf8mb4_0900_ai_ci' AFTER `ADDOPTIONL`, ADD COLUMN `ADDOPTIONR` VARCHAR(50) NULL DEFAULT NULL COMMENT '옵션추가 오른쪽' COLLATE 'utf8mb4_0900_ai_ci' AFTER `ADDOPTIONRB`; ALTER TABLE SHOPGMARKETADDDTL ADD COLUMN `CHANGESIZE` VARCHAR(50) NULL DEFAULT NULL COMMENT '대표사진사이즈변경 버튼' AFTER `FOCUSPLUS1`, ADD COLUMN `CHANGESIZEX` VARCHAR(50) NULL DEFAULT NULL COMMENT '대표사진사이즈변경 X' AFTER `CHANGESIZE`, ADD COLUMN `CHANGESIZEY` VARCHAR(50) NULL DEFAULT NULL COMMENT '대표사진사이즈변경 Y' AFTER `CHANGESIZEX`, ADD COLUMN `CHANGESIZEW` VARCHAR(50) NULL DEFAULT NULL COMMENT '대표사진사이즈변경 W' AFTER `CHANGESIZEY`, ADD COLUMN `CHANGESIZEH` VARCHAR(50) NULL DEFAULT NULL COMMENT '대표사진사이즈변경 H' AFTER `CHANGESIZEW`, ADD COLUMN `DETAILKEYWORDB` VARCHAR(50) NULL DEFAULT NULL COMMENT '상세페이지 상단 (키워드) 버튼' AFTER `CHANGESIZEH`, ADD COLUMN `DETAILKEYWORDL` TEXT NULL COMMENT '상세페이지 상단 (키워드)' AFTER `DETAILKEYWORDB`, ADD COLUMN `DETAILKEYWORDR` TEXT NULL AFTER `DETAILKEYWORDL`, ADD COLUMN `DETAILPRODUCTCODEB` VARCHAR(50) NULL DEFAULT NULL COMMENT '상세페이지 상단 (상품코드) 버튼' AFTER `DETAILKEYWORDR`, ADD COLUMN `DETAILPRODUCTCODEL` TEXT NULL COMMENT '상세페이지 상단 (상품코드)' AFTER `DETAILPRODUCTCODEB`, ADD COLUMN `DETAILPRODUCTCODER` TEXT NULL AFTER `DETAILPRODUCTCODEL`, ADD COLUMN `DETAILPRODUCTNAMEB` VARCHAR(50) NULL DEFAULT NULL COMMENT '상세페이지 상단 (상품명) 버튼' AFTER `DETAILPRODUCTCODER`, ADD COLUMN `DETAILPRODUCTNAMEL` TEXT NULL COMMENT '상세페이지 상단 (상품명)' AFTER `DETAILPRODUCTNAMEB`, ADD COLUMN `DETAILPRODUCTNAMER` TEXT NULL AFTER `DETAILPRODUCTNAMEL`, ADD COLUMN `ADDOPTIONLB` VARCHAR(50) NULL DEFAULT NULL COMMENT '옵션추가 왼쪽 버튼' AFTER `DETAILPRODUCTNAMER`, ADD COLUMN `ADDOPTIONL` VARCHAR(50) NULL DEFAULT NULL COMMENT '옵션추가 왼쪽' COLLATE 'utf8mb4_0900_ai_ci' AFTER `ADDOPTIONLB`, ADD COLUMN `ADDOPTIONRB` VARCHAR(50) NULL DEFAULT NULL COMMENT '옵션추가 오른쪽 버튼' COLLATE 'utf8mb4_0900_ai_ci' AFTER `ADDOPTIONL`, ADD COLUMN `ADDOPTIONR` VARCHAR(50) NULL DEFAULT NULL COMMENT '옵션추가 오른쪽' COLLATE 'utf8mb4_0900_ai_ci' AFTER `ADDOPTIONRB`; ALTER TABLE SHOPSSGADDIDTL ADD COLUMN `CHANGESIZE` VARCHAR(50) NULL DEFAULT NULL COMMENT '대표사진사이즈변경 버튼' AFTER `REMARKOUTPUT`, ADD COLUMN `CHANGESIZEX` VARCHAR(50) NULL DEFAULT NULL COMMENT '대표사진사이즈변경 X' AFTER `CHANGESIZE`, ADD COLUMN `CHANGESIZEY` VARCHAR(50) NULL DEFAULT NULL COMMENT '대표사진사이즈변경 Y' AFTER `CHANGESIZEX`, ADD COLUMN `CHANGESIZEW` VARCHAR(50) NULL DEFAULT NULL COMMENT '대표사진사이즈변경 W' AFTER `CHANGESIZEY`, ADD COLUMN `CHANGESIZEH` VARCHAR(50) NULL DEFAULT NULL COMMENT '대표사진사이즈변경 H' AFTER `CHANGESIZEW`, ADD COLUMN `DETAILKEYWORDB` VARCHAR(50) NULL DEFAULT NULL COMMENT '상세페이지 상단 (키워드) 버튼' AFTER `CHANGESIZEH`, ADD COLUMN `DETAILKEYWORDL` TEXT NULL COMMENT '상세페이지 상단 (키워드)' AFTER `DETAILKEYWORDB`, ADD COLUMN `DETAILKEYWORDR` TEXT NULL AFTER `DETAILKEYWORDL`, ADD COLUMN `DETAILPRODUCTCODEB` VARCHAR(50) NULL DEFAULT NULL COMMENT '상세페이지 상단 (상품코드) 버튼' AFTER `DETAILKEYWORDR`, ADD COLUMN `DETAILPRODUCTCODEL` TEXT NULL COMMENT '상세페이지 상단 (상품코드)' AFTER `DETAILPRODUCTCODEB`, ADD COLUMN `DETAILPRODUCTCODER` TEXT NULL AFTER `DETAILPRODUCTCODEL`, ADD COLUMN `DETAILPRODUCTNAMEB` VARCHAR(50) NULL DEFAULT NULL COMMENT '상세페이지 상단 (상품명) 버튼' AFTER `DETAILPRODUCTCODER`, ADD COLUMN `DETAILPRODUCTNAMEL` TEXT NULL COMMENT '상세페이지 상단 (상품명)' AFTER `DETAILPRODUCTNAMEB`, ADD COLUMN `DETAILPRODUCTNAMER` TEXT NULL AFTER `DETAILPRODUCTNAMEL`, ADD COLUMN `ADDOPTIONLB` VARCHAR(50) NULL DEFAULT NULL COMMENT '옵션추가 왼쪽 버튼' AFTER `DETAILPRODUCTNAMER`, ADD COLUMN `ADDOPTIONL` VARCHAR(50) NULL DEFAULT NULL COMMENT '옵션추가 왼쪽' COLLATE 'utf8mb4_0900_ai_ci' AFTER `ADDOPTIONLB`, ADD COLUMN `ADDOPTIONRB` VARCHAR(50) NULL DEFAULT NULL COMMENT '옵션추가 오른쪽 버튼' COLLATE 'utf8mb4_0900_ai_ci' AFTER `ADDOPTIONL`, ADD COLUMN `ADDOPTIONR` VARCHAR(50) NULL DEFAULT NULL COMMENT '옵션추가 오른쪽' COLLATE 'utf8mb4_0900_ai_ci' AFTER `ADDOPTIONRB`; ALTER TABLE SHOPTMONADDIDTL ADD COLUMN `CHANGESIZE` VARCHAR(50) NULL DEFAULT NULL COMMENT '대표사진사이즈변경 버튼' AFTER `REMARKOUTPUT`, ADD COLUMN `CHANGESIZEX` VARCHAR(50) NULL DEFAULT NULL COMMENT '대표사진사이즈변경 X' AFTER `CHANGESIZE`, ADD COLUMN `CHANGESIZEY` VARCHAR(50) NULL DEFAULT NULL COMMENT '대표사진사이즈변경 Y' AFTER `CHANGESIZEX`, ADD COLUMN `CHANGESIZEW` VARCHAR(50) NULL DEFAULT NULL COMMENT '대표사진사이즈변경 W' AFTER `CHANGESIZEY`, ADD COLUMN `CHANGESIZEH` VARCHAR(50) NULL DEFAULT NULL COMMENT '대표사진사이즈변경 H' AFTER `CHANGESIZEW`, ADD COLUMN `DETAILKEYWORDB` VARCHAR(50) NULL DEFAULT NULL COMMENT '상세페이지 상단 (키워드) 버튼' AFTER `CHANGESIZEH`, ADD COLUMN `DETAILKEYWORDL` TEXT NULL COMMENT '상세페이지 상단 (키워드)' AFTER `DETAILKEYWORDB`, ADD COLUMN `DETAILKEYWORDR` TEXT NULL AFTER `DETAILKEYWORDL`, ADD COLUMN `DETAILPRODUCTCODEB` VARCHAR(50) NULL DEFAULT NULL COMMENT '상세페이지 상단 (상품코드) 버튼' AFTER `DETAILKEYWORDR`, ADD COLUMN `DETAILPRODUCTCODEL` TEXT NULL COMMENT '상세페이지 상단 (상품코드)' AFTER `DETAILPRODUCTCODEB`, ADD COLUMN `DETAILPRODUCTCODER` TEXT NULL AFTER `DETAILPRODUCTCODEL`, ADD COLUMN `DETAILPRODUCTNAMEB` VARCHAR(50) NULL DEFAULT NULL COMMENT '상세페이지 상단 (상품명) 버튼' AFTER `DETAILPRODUCTCODER`, ADD COLUMN `DETAILPRODUCTNAMEL` TEXT NULL COMMENT '상세페이지 상단 (상품명)' AFTER `DETAILPRODUCTNAMEB`, ADD COLUMN `DETAILPRODUCTNAMER` TEXT NULL AFTER `DETAILPRODUCTNAMEL`, ADD COLUMN `ADDOPTIONLB` VARCHAR(50) NULL DEFAULT NULL COMMENT '옵션추가 왼쪽 버튼' AFTER `DETAILPRODUCTNAMER`, ADD COLUMN `ADDOPTIONL` VARCHAR(50) NULL DEFAULT NULL COMMENT '옵션추가 왼쪽' COLLATE 'utf8mb4_0900_ai_ci' AFTER `ADDOPTIONLB`, ADD COLUMN `ADDOPTIONRB` VARCHAR(50) NULL DEFAULT NULL COMMENT '옵션추가 오른쪽 버튼' COLLATE 'utf8mb4_0900_ai_ci' AFTER `ADDOPTIONL`, ADD COLUMN `ADDOPTIONR` VARCHAR(50) NULL DEFAULT NULL COMMENT '옵션추가 오른쪽' COLLATE 'utf8mb4_0900_ai_ci' AFTER `ADDOPTIONRB`; ALTER TABLE SHOPWEMARKETADDDTL ADD COLUMN `CHANGESIZE` VARCHAR(50) NULL DEFAULT NULL COMMENT '대표사진사이즈변경 버튼' AFTER `REMARKOUTPUT`, ADD COLUMN `CHANGESIZEX` VARCHAR(50) NULL DEFAULT NULL COMMENT '대표사진사이즈변경 X' AFTER `CHANGESIZE`, ADD COLUMN `CHANGESIZEY` VARCHAR(50) NULL DEFAULT NULL COMMENT '대표사진사이즈변경 Y' AFTER `CHANGESIZEX`, ADD COLUMN `CHANGESIZEW` VARCHAR(50) NULL DEFAULT NULL COMMENT '대표사진사이즈변경 W' AFTER `CHANGESIZEY`, ADD COLUMN `CHANGESIZEH` VARCHAR(50) NULL DEFAULT NULL COMMENT '대표사진사이즈변경 H' AFTER `CHANGESIZEW`, ADD COLUMN `DETAILKEYWORDB` VARCHAR(50) NULL DEFAULT NULL COMMENT '상세페이지 상단 (키워드) 버튼' AFTER `CHANGESIZEH`, ADD COLUMN `DETAILKEYWORDL` TEXT NULL COMMENT '상세페이지 상단 (키워드)' AFTER `DETAILKEYWORDB`, ADD COLUMN `DETAILKEYWORDR` TEXT NULL AFTER `DETAILKEYWORDL`, ADD COLUMN `DETAILPRODUCTCODEB` VARCHAR(50) NULL DEFAULT NULL COMMENT '상세페이지 상단 (상품코드) 버튼' AFTER `DETAILKEYWORDR`, ADD COLUMN `DETAILPRODUCTCODEL` TEXT NULL COMMENT '상세페이지 상단 (상품코드)' AFTER `DETAILPRODUCTCODEB`, ADD COLUMN `DETAILPRODUCTCODER` TEXT NULL AFTER `DETAILPRODUCTCODEL`, ADD COLUMN `DETAILPRODUCTNAMEB` VARCHAR(50) NULL DEFAULT NULL COMMENT '상세페이지 상단 (상품명) 버튼' AFTER `DETAILPRODUCTCODER`, ADD COLUMN `DETAILPRODUCTNAMEL` TEXT NULL COMMENT '상세페이지 상단 (상품명)' AFTER `DETAILPRODUCTNAMEB`, ADD COLUMN `DETAILPRODUCTNAMER` TEXT NULL AFTER `DETAILPRODUCTNAMEL`, ADD COLUMN `ADDOPTIONLB` VARCHAR(50) NULL DEFAULT NULL COMMENT '옵션추가 왼쪽 버튼' AFTER `DETAILPRODUCTNAMER`, ADD COLUMN `ADDOPTIONL` VARCHAR(50) NULL DEFAULT NULL COMMENT '옵션추가 왼쪽' COLLATE 'utf8mb4_0900_ai_ci' AFTER `ADDOPTIONLB`, ADD COLUMN `ADDOPTIONRB` VARCHAR(50) NULL DEFAULT NULL COMMENT '옵션추가 오른쪽 버튼' COLLATE 'utf8mb4_0900_ai_ci' AFTER `ADDOPTIONL`, ADD COLUMN `ADDOPTIONR` VARCHAR(50) NULL DEFAULT NULL COMMENT '옵션추가 오른쪽' COLLATE 'utf8mb4_0900_ai_ci' AFTER `ADDOPTIONRB`; UPDATE SHOPDELIVERYS SET `DOSIN_CODE`='CU편의점택배,편의점택배,GS편의점택배' WHERE `SHOPCD`='shop0075' AND `DLVID`='CVS'; UPDATE SHOPDELIVERYS SET `DOSIN_CODE`='롯데택배(구 현대택배)' WHERE `SHOPCD`='shop0076' AND `DLVID`='롯데택배'; UPDATE SHOPDELIVERYS SET `DLVID`='KGB' WHERE `SHOPCD`='shop0273' AND `DLVID`='4'; UPDATE SHOPDELIVERYS SET `DLVID`='EPOST' WHERE `SHOPCD`='shop0273' AND `DLVID`='6'; UPDATE SHOPDELIVERYS SET `DLVID`='REGISTPOST' WHERE `SHOPCD`='shop0273' AND `DLVID`='7'; UPDATE SHOPDELIVERYS SET `DLVID`='HANJIN' WHERE `SHOPCD`='shop0273' AND `DLVID`='8'; UPDATE SHOPDELIVERYS SET `DLVID`='HYUNDAI' WHERE `SHOPCD`='shop0273' AND `DLVID`='9'; INSERT INTO SHOPDELIVERYS (`SHOPCD`, `DLVID`, `DLVNM`, `EXPRESS_URL_ID`) VALUES ('shop0273', 'LOTTE', '롯데택배', '0'); UPDATE SHOPDELIVERYS SET `DLVID`='DAESIN' WHERE `SHOPCD`='shop0273' AND `DLVID`='12'; UPDATE SHOPDELIVERYS SET `DLVID`='ILYANG' WHERE `SHOPCD`='shop0273' AND `DLVID`='13'; UPDATE SHOPDELIVERYS SET `DLVID`='KDEXP' WHERE `SHOPCD`='shop0273' AND `DLVID`='14'; UPDATE SHOPDELIVERYS SET `DLVID`='HDEXP' WHERE `SHOPCD`='shop0273' AND `DLVID`='15'; UPDATE SHOPDELIVERYS SET `DLVID`='CHUNIL' WHERE `SHOPCD`='shop0273' AND `DLVID`='16'; UPDATE SHOPDELIVERYS SET `DLVID`='CVSNET' WHERE `SHOPCD`='shop0273' AND `DLVID`='17'; UPDATE SHOPDELIVERYS SET `DLVID`='KUNYOUNG' WHERE `SHOPCD`='shop0273' AND `DLVID`='18'; UPDATE SHOPDELIVERYS SET `DLVID`='HONAM' WHERE `SHOPCD`='shop0273' AND `DLVID`='19'; UPDATE SHOPDELIVERYS SET `DLVID`='YONGMA' WHERE `SHOPCD`='shop0273' AND `DLVID`='20'; UPDATE SHOPDELIVERYS SET `DLVID`='HILOGIS' WHERE `SHOPCD`='shop0273' AND `DLVID`='23'; UPDATE SHOPDELIVERYS SET `DLVID`='SLX' WHERE `SHOPCD`='shop0273' AND `DLVID`='24'; UPDATE SHOPDELIVERYS SET `DLVID`='HPL' WHERE `SHOPCD`='shop0273' AND `DLVID`='25'; UPDATE SHOPDELIVERYS SET `DLVID`='SEBANG' WHERE `SHOPCD`='shop0273' AND `DLVID`='26'; UPDATE SHOPDELIVERYS SET `DLVID`='WONDERS', `DLVNM`='원더스퀵' WHERE `SHOPCD`='shop0273' AND `DLVID`='27'; UPDATE SHOPDELIVERYS SET `DLVID`='NHLOGIS' WHERE `SHOPCD`='shop0273' AND `DLVID`='28'; UPDATE SHOPDELIVERYS SET `DLVID`='HOMEPICK' WHERE `SHOPCD`='shop0273' AND `DLVID`='29'; UPDATE SHOPDELIVERYS SET `DLVID`='HOMEINNOV' WHERE `SHOPCD`='shop0273' AND `DLVID`='30'; UPDATE SHOPDELIVERYS SET `DLVID`='GNETWORK' WHERE `SHOPCD`='shop0273' AND `DLVID`='31'; UPDATE SHOPDELIVERYS SET `DLVID`='WEVILL' WHERE `SHOPCD`='shop0273' AND `DLVID`='32'; UPDATE SHOPDELIVERYS SET `DLVID`='FOREVERPS' WHERE `SHOPCD`='shop0273' AND `DLVID`='33'; UPDATE SHOPDELIVERYS SET `DLVID`='LSERVICE' WHERE `SHOPCD`='shop0273' AND `DLVID`='34'; INSERT INTO SHOPDELIVERYS (`SHOPCD`, `DLVID`, `DLVNM`, `EXPRESS_URL_ID`) VALUES ('shop0273', 'TPMLOGIS', '로지스밸리택배', '0'); UPDATE SHOPDELIVERYS SET `DLVID`='ZENIELSYSTEM' WHERE `SHOPCD`='shop0273' AND `DLVID`='36'; UPDATE SHOPDELIVERYS SET `DLVID`='ANYTRACK' WHERE `SHOPCD`='shop0273' AND `DLVID`='37'; UPDATE SHOPDELIVERYS SET `DLVID`='JLOGIST' WHERE `SHOPCD`='shop0273' AND `DLVID`='39'; INSERT INTO SHOPDELIVERYS (`SHOPCD`, `DLVID`, `DLVNM`) VALUES ('shop0273', 'HIVECITY', '하이브시티'); INSERT INTO SHOPDELIVERYS (`SHOPCD`, `DLVID`, `DLVNM`, `EXPRESS_URL_ID`) VALUES ('shop0273', 'HANSSEM', '한샘', '0'); UPDATE SHOPDELIVERYS SET `EXPRESS_URL_ID`='0' WHERE `SHOPCD`='shop0273' AND `DLVID`='HIVECITY'; INSERT INTO SHOPDELIVERYS (`SHOPCD`, `DLVID`, `DLVNM`, `EXPRESS_URL_ID`) VALUES ('shop0273', 'LTL', 'LTL', '0'); INSERT INTO SHOPDELIVERYS (`SHOPCD`, `DLVID`, `DLVNM`, `EXPRESS_URL_ID`) VALUES ('shop0273', 'DADASMART', '스마트로지스/다다스마트', '0'); INSERT INTO SHOPDELIVERYS (`SHOPCD`, `DLVID`, `DLVNM`, `EXPRESS_URL_ID`) VALUES ('shop0273', 'LOGISPOT', '로지스팟', '0'); INSERT INTO SHOPDELIVERYS (`SHOPCD`, `DLVID`, `DLVNM`, `EXPRESS_URL_ID`) VALUES ('shop0273', 'FRESHMATES', '프레시메이트', '0'); INSERT INTO SHOPDELIVERYS (`SHOPCD`, `DLVID`, `DLVNM`, `EXPRESS_URL_ID`) VALUES ('shop0273', 'VROONG', '부릉', '0'); INSERT INTO SHOPDELIVERYS (`SHOPCD`, `DLVID`, `DLVNM`) VALUES ('shop0273', 'NKLS', 'NK로지솔루션'); UPDATE SHOPDELIVERYS SET `EXPRESS_URL_ID`='0' WHERE `SHOPCD`='shop0273' AND `DLVID`='NKLS'; INSERT INTO SHOPDELIVERYS (`SHOPCD`, `DLVID`, `DLVNM`, `EXPRESS_URL_ID`) VALUES ('shop0273', 'DODOFLEX', '도도플렉스', '0'); INSERT INTO SHOPDELIVERYS (`SHOPCD`, `DLVID`, `DLVNM`, `EXPRESS_URL_ID`) VALUES ('shop0273', 'ETOMARS', '이투마스', '0'); INSERT INTO SHOPDELIVERYS (`SHOPCD`, `DLVID`, `DLVNM`, `EXPRESS_URL_ID`) VALUES ('shop0273', 'SHIPNERGY', '배송하기좋은날', '0'); INSERT INTO SHOPDELIVERYS (`SHOPCD`, `DLVID`, `DLVNM`, `EXPRESS_URL_ID`) VALUES ('shop0273', 'VENDORPIA', '에이스물류', '0'); INSERT INTO SHOPDELIVERYS (`SHOPCD`, `DLVID`, `DLVNM`, `EXPRESS_URL_ID`) VALUES ('shop0273', 'COSHIP', '캐나다쉬핑', '0'); INSERT INTO SHOPDELIVERYS (`SHOPCD`, `DLVID`, `DLVNM`, `EXPRESS_URL_ID`) VALUES ('shop0273', 'GDAKOREA', '지디에이코리아', '0'); INSERT INTO SHOPDELIVERYS (`SHOPCD`, `DLVID`, `DLVNM`, `EXPRESS_URL_ID`) VALUES ('shop0273', 'BABABA', '바바바로지스', '0'); INSERT INTO SHOPDELIVERYS (`SHOPCD`, `DLVID`, `DLVNM`, `EXPRESS_URL_ID`) VALUES ('shop0273', 'GOODSTOLUCK', '굿투럭', '0'); INSERT INTO SHOPDELIVERYS (`SHOPCD`, `DLVID`, `DLVNM`, `EXPRESS_URL_ID`) VALUES ('shop0273', "GENIEGO", "지니고", '0'); INSERT INTO SHOPDELIVERYS (`SHOPCD`, `DLVID`, `DLVNM`, `EXPRESS_URL_ID`) VALUES ('shop0273', "TODAYPICKUP", "오늘의픽업", '0'); INSERT INTO SHOPDELIVERYS (`SHOPCD`, `DLVID`, `DLVNM`, `EXPRESS_URL_ID`) VALUES ('shop0273', "NOGOK", "노곡물류", '0'); INSERT INTO SHOPDELIVERYS (`SHOPCD`, `DLVID`, `DLVNM`, `EXPRESS_URL_ID`) VALUES ('shop0273', "SPASYS1", "스페이시스원", '0'); INSERT INTO SHOPDELIVERYS (`SHOPCD`, `DLVID`, `DLVNM`, `EXPRESS_URL_ID`) VALUES ('shop0273', "KOKUSAI", "국제익스플레스", '0'); INSERT INTO SHOPDELIVERYS (`SHOPCD`, `DLVID`, `DLVNM`, `EXPRESS_URL_ID`) VALUES ('shop0273', "XINPATEK", "윈핸드해운상공", '0'); INSERT INTO SHOPDELIVERYS (`SHOPCD`, `DLVID`, `DLVNM`, `EXPRESS_URL_ID`) VALUES ('shop0273', "HEREWEGO", "탱고앤고", '0'); INSERT INTO SHOPDELIVERYS (`SHOPCD`, `DLVID`, `DLVNM`, `EXPRESS_URL_ID`) VALUES ('shop0273', "FRESHSOLUTIONS", "프레시솔루션", '0'); INSERT INTO SHOPDELIVERYS (`SHOPCD`, `DLVID`, `DLVNM`, `EXPRESS_URL_ID`) VALUES ('shop0273', "WOONGJI", "웅지익스프레스", '0'); INSERT INTO SHOPDELIVERYS (`SHOPCD`, `DLVID`, `DLVNM`, `EXPRESS_URL_ID`) VALUES ('shop0273', "SBGLS", "sbgls", '0'); INSERT INTO SHOPDELIVERYS (`SHOPCD`, `DLVID`, `DLVNM`, `EXPRESS_URL_ID`) VALUES ('shop0273', "YUNDA", "yunda express", '0'); INSERT INTO SHOPDELIVERYS (`SHOPCD`, `DLVID`, `DLVNM`, `EXPRESS_URL_ID`) VALUES ('shop0273', "ALLTAKOREA", "올타코리아", '0'); INSERT INTO SHOPDELIVERYS (`SHOPCD`, `DLVID`, `DLVNM`, `EXPRESS_URL_ID`) VALUES ('shop0273', "LOTTECHILSUNG", "롯데칠성", '0'); INSERT INTO SHOPDELIVERYS (`SHOPCD`, `DLVID`, `DLVNM`, `EXPRESS_URL_ID`) VALUES ('shop0273', "VALEX", "발렉스", '0'); INSERT INTO SHOPDELIVERYS (`SHOPCD`, `DLVID`, `DLVNM`, `EXPRESS_URL_ID`) VALUES ('shop0273', "PINGPONG", "핑퐁", '0'); INSERT INTO SHOPDELIVERYS (`SHOPCD`, `DLVID`, `DLVNM`, `EXPRESS_URL_ID`) VALUES ('shop0273', "YDH", "YDH", '0'); INSERT INTO SHOPDELIVERYS (`SHOPCD`, `DLVID`, `DLVNM`, `EXPRESS_URL_ID`) VALUES ('shop0273', "CARGOPLEASE", "화물을부탁해", '0'); INSERT INTO SHOPDELIVERYS (`SHOPCD`, `DLVID`, `DLVNM`, `EXPRESS_URL_ID`) VALUES ('shop0273', "GTSLOGIS", "GTS로지스", '0'); INSERT INTO SHOPDELIVERYS (`SHOPCD`, `DLVID`, `DLVNM`, `EXPRESS_URL_ID`) VALUES ('shop0273', "EKDP", "삼다수가정배송", '0'); UPDATE SHOPDELIVERYS SET `DLVID`='CJGLS' WHERE `SHOPCD`='shop0273' AND `DLVID`='2'; DELETE FROM SHOPDELIVERYS WHERE `SHOPCD`='shop0273' AND `DLVID`='22'; DELETE FROM SHOPDELIVERYS WHERE `SHOPCD`='shop0273' AND `DLVID`='35'; DELETE FROM SHOPDELIVERYS WHERE `SHOPCD`='shop0273' AND `DLVID`='38'; ALTER TABLE SHOPGMARKETADDDTL ADD COLUMN `JEJUFEE` VARCHAR(50) NULL DEFAULT NULL AFTER `OUTADDRESS`, ADD COLUMN `DTCFEE` VARCHAR(50) NULL DEFAULT NULL AFTER `JEJUFEE`; INSERT INTO SHOPINFO (`SHOPCD`, `SHOPNM`, `CUSTNM`, `PRODREGIS`, `PRODMODIFY`, `PRODSOLDOUT`, `STOCKSEND`, `ORDERCOLLECT`, `INVOICSEND`, `CLAIMCOLLECT`, `QUESTION`, `MARKETCATEG`, `SHOPURL`) VALUES ('shop0372', '롯데ON', '롯데쇼핑(주)', '서비스', '서비스', '서비스', '서비스', '서비스', '서비스', '서비스', '서비스', '오픈마켓', 'https://store.lotteon.com/cm/main/index_SO.wsp'); INSERT INTO shopmst` (COMPNO, SHOPCD, DEALTRADE, IDNUM) VALUES ('4', 'shop0372','거래중','0'); UPDATE SHOPINFO SET `PRODREGIS`='서비스', `PRODMODIFY`='서비스', `PRODSOLDOUT`='서비스', `STOCKSEND`='서비스', `ORDERCOLLECT`='서비스', `INVOICSEND`='서비스', `CLAIMCOLLECT`='서비스', `QUESTION`='서비스' WHERE `SHOPCD`='shop0106'; UPDATE shopmst` SET `DEALTRADE`='거래중' WHERE `COMPNO`=4 AND `SHOPCD`='shop0106'; ALTER TABLE SHOPADDRKAKAODTL ADD COLUMN `IMGONEONONE` VARCHAR(50) NULL DEFAULT NULL COMMENT '이미지 1:1비율 노출' AFTER `SHOPID`, ADD COLUMN `IMGTHREEONFOUR` VARCHAR(50) NULL DEFAULT NULL COMMENT '이미지 3:4비율 노출' AFTER `IMGONEONONE`; UPDATE SHOPDELIVERYS SET `DOSIN_CODE`='롯데택배(구 현대택배)' WHERE `SHOPCD`='shop0067' AND `DLVID`='10008'; ALTER TABLE SHOP11STADDIDTL ADD COLUMN `IMGONEONONE` VARCHAR(50) NULL DEFAULT NULL COMMENT '이미지 1:1비율 노출' AFTER `SHOPCATSITENM`, ADD COLUMN `IMGTHREEONFOUR` VARCHAR(50) NULL DEFAULT NULL COMMENT '이미지 3:4비율 노출' AFTER `IMGONEONONE`; ALTER TABLE SHOPINTERPARKADDIDTL ADD COLUMN `IMGONEONONE` VARCHAR(50) NULL DEFAULT NULL COMMENT '이미지 1:1비율 노출' AFTER `TITLE`, CHANGE COLUMN `ISCATEGORY` `IMGTHREEONFOUR` VARCHAR(50) NULL DEFAULT NULL COMMENT '이미지 3:4비율 노출' COLLATE 'utf8mb4_0900_ai_ci' AFTER `IMGONEONONE`; ALTER TABLE SHOPINTERPARKADDIDTL ADD COLUMN `ISCATEGORY` VARCHAR(50) NULL DEFAULT NULL AFTER `IMGTHREEONFOUR`; UPDATE SHOPDELIVERYS SET `DOSIN_CODE`='롯데택배(구 현대택배)' WHERE `DOSIN_CODE`='롯데택배' ; ALTER TABLE SHOPAUCTION2ADDDTL ADD COLUMN `IMGONEONONE` VARCHAR(50) NULL DEFAULT NULL COMMENT '이미지 1:1비율 노출' AFTER `TITLE`, ADD COLUMN `IMGTHREEONFOUR` VARCHAR(50) NULL DEFAULT NULL COMMENT '이미지 3:4비율 노출' AFTER `IMGONEONONE`; ALTER TABLE SHOPGMARKET2ADDDTL ADD COLUMN `IMGONEONONE` VARCHAR(50) NULL DEFAULT NULL COMMENT '이미지 1:1비율 노출' AFTER `TITLE`, ADD COLUMN `IMGTHREEONFOUR` VARCHAR(50) NULL DEFAULT NULL COMMENT '이미지 3:4비율 노출' AFTER `IMGONEONONE`; ALTER TABLE SHOPCOUPANGADDIDTL ADD COLUMN `IMGONEONONE` VARCHAR(200) NULL DEFAULT NULL COMMENT '이미지 1:1비율 노출' AFTER `TITLE`, ADD COLUMN `IMGTHREEONFOUR` VARCHAR(50) NULL DEFAULT NULL COMMENT '이미지 3:4비율 노출' AFTER `IMGONEONONE`; ALTER TABLE SHOPWEMARKETADDDTL ADD COLUMN `IMGONEONONE` VARCHAR(200) NULL DEFAULT NULL COMMENT '이미지 1:1비율 노출' AFTER `TITLE`, ADD COLUMN `IMGTHREEONFOUR` VARCHAR(50) NULL DEFAULT NULL COMMENT '이미지 3:4비율 노출' AFTER `IMGONEONONE`; ALTER TABLE SHOPLOTTEONADDDTL ADD COLUMN `IMGONEONONE` VARCHAR(200) NULL DEFAULT NULL COMMENT '이미지 1:1비율 노출' AFTER `SHOPCATSITENM`, ADD COLUMN `IMGTHREEONFOUR` VARCHAR(200) NULL DEFAULT NULL COMMENT '이미지 3:4비율 노출' AFTER `IMGONEONONE`; ALTER TABLE SHOPSSGADDIDTL ADD COLUMN `IMGONEONONE` VARCHAR(200) NULL DEFAULT NULL COMMENT '이미지 1:1비율 노출' AFTER `TITLE`, ADD COLUMN `IMGTHREEONFOUR` VARCHAR(200) NULL DEFAULT NULL COMMENT '이미지 3:4비율 노출' AFTER `IMGONEONONE`; ALTER TABLE SHOPADDRNAVERSTOREDTL ADD COLUMN `IMGONEONONE` VARCHAR(50) NULL DEFAULT NULL COMMENT '이미지 1:1비율 노출' AFTER `TITLE`, ADD COLUMN `IMGTHREEONFOUR` VARCHAR(50) NULL DEFAULT NULL COMMENT '이미지 3:4비율 노출' AFTER `IMGONEONONE`; ALTER TABLE SHOPAUCTIONADDDTL ADD COLUMN `IMGONEONONE` VARCHAR(50) NULL DEFAULT NULL COMMENT '이미지 1:1비율 노출' AFTER `TITLE`, ADD COLUMN `IMGTHREEONFOUR` VARCHAR(50) NULL DEFAULT NULL COMMENT '이미지 3:4비율 노출' AFTER `IMGONEONONE`; ALTER TABLE SHOPGMARKETADDDTL ADD COLUMN `IMGONEONONE` VARCHAR(50) NULL DEFAULT NULL COMMENT '이미지 1:1비율 노출' AFTER `TITLE`, ADD COLUMN `IMGTHREEONFOUR` VARCHAR(50) NULL DEFAULT NULL COMMENT '이미지 3:4비율 노출' AFTER `IMGONEONONE`; ALTER TABLE SYSTEMCONF ADD COLUMN `PRODCPYYN` CHAR(1) NULL DEFAULT NULL COMMENT '복사 상품코드 사용여부 ' AFTER `PRODDUP2`; INSERT INTO SHOPDELIVERYS (`SHOPCD`, `DLVID`, `DLVNM`, `EXPRESS_URL_ID`) VALUES ('shop0273', 'DIRECT', '자체배송', '0'); insert into SHOPDELIVERYS values('shop0106','1','CJ대한통운',12,'CJ 대한통운'); insert into SHOPDELIVERYS values('shop0106','10','천일택배',7,'천일택배'); insert into SHOPDELIVERYS values('shop0106','11','대신택배',0,'대신택배'); insert into SHOPDELIVERYS values('shop0106','13','일양로지스',6,'일양택배'); insert into SHOPDELIVERYS values('shop0106','14','한의사랑택배',8,''); insert into SHOPDELIVERYS values('shop0106','15','CVSnet편의점택배',13,'편의점택배'); insert into SHOPDELIVERYS values('shop0106','16','건영택배',0,'건영택배'); insert into SHOPDELIVERYS values('shop0106','17','경동택배',1,'경동택배'); insert into SHOPDELIVERYS values('shop0106','22','합동택배',0,'합동택배'); insert into SHOPDELIVERYS values('shop0106','23','EMS국제배송',15,'EMS국제우편'); insert into SHOPDELIVERYS values('shop0106','24','롯데택배',10,'롯데택배(구 현대택배)'); insert into SHOPDELIVERYS values('shop0106','25','DHL국제배송',14,'DHL'); insert into SHOPDELIVERYS values('shop0106','27','범한판토스',0,''); insert into SHOPDELIVERYS values('shop0106','28','FedEx(페덱스)',16,'FEDEX'); insert into SHOPDELIVERYS values('shop0106','29','호남택배',11,'호남택배'); insert into SHOPDELIVERYS values('shop0106','3','로젠택배',3,'로젠택배'); insert into SHOPDELIVERYS values('shop0106','30','sf-express(위메프연동불가)',0,''); insert into SHOPDELIVERYS values('shop0106','31','SLX택배',20,''); insert into SHOPDELIVERYS values('shop0106','32','홈픽택배',24,''); insert into SHOPDELIVERYS values('shop0106','33','농협택배',0,''); insert into SHOPDELIVERYS values('shop0106','4','우체국 택배',5,'우체국택배'); insert into SHOPDELIVERYS values('shop0106','6','한진택배',9,'한진택배'); insert into SHOPDELIVERYS values('shop0106','8','KGB 택배',0,'KGB특급택배'); UPDATE SHOPINFODOME SET `ORDERCOLLECT`='서비스' WHERE `SHOPCD`='shop9996'; UPDATE SHOPINFODOME SET `ORDERCOLLECT`='서비스' WHERE `SHOPCD`='shop0203'; CREATE TABLE SHOPMELCHIADDIDTL ( `SEQ` INT NOT NULL AUTO_INCREMENT COMMENT '일련번호', `COMPNO` INT NULL DEFAULT NULL COMMENT '회사코드', `SHOPCD` VARCHAR(50) NULL DEFAULT NULL COMMENT '쇼핑몰코드' COLLATE 'utf8mb4_0900_ai_ci', `SHOPSEQ` INT NULL DEFAULT NULL COMMENT '쇼핑몰', `SHOPID` VARCHAR(50) NULL DEFAULT NULL COMMENT '아이디' COLLATE 'utf8mb4_0900_ai_ci', `TITLE` VARCHAR(50) NULL DEFAULT NULL COMMENT '세트이름' COLLATE 'utf8mb4_0900_ai_ci', `ISCATEGORY` VARCHAR(50) NULL DEFAULT NULL COMMENT '카테고리사용여부', `LAGCATCD` VARCHAR(50) NULL DEFAULT NULL COMMENT '카테고리 대분류', `MIDCATCD` VARCHAR(50) NULL DEFAULT NULL COMMENT '카테고리 중분류', `SMLCATCD` VARCHAR(50) NULL DEFAULT NULL COMMENT '카테고리 소분류', `DETCATCD` VARCHAR(50) NULL DEFAULT NULL COMMENT '카테고리 세분류', `SHOPCATNO` VARCHAR(50) NULL DEFAULT NULL COMMENT '카테고리 최종번호', `SHOPCATSITENM` VARCHAR(200) NULL DEFAULT NULL COMMENT '카테고리 full 이름 ', `ISTAXEDYN` VARCHAR(50) NULL DEFAULT NULL COMMENT '과세여부' COLLATE 'utf8mb4_0900_ai_ci', `SALEDISPLAYTYPEYN` VARCHAR(50) NULL DEFAULT NULL COMMENT '판매방식설정' COLLATE 'utf8mb4_0900_ai_ci', `ISADULTAUTHYN` VARCHAR(50) NULL DEFAULT NULL COMMENT '성인인증유무' COLLATE 'utf8mb4_0900_ai_ci', `ISUSEDPRODUCTOPTIONYN` VARCHAR(50) NULL DEFAULT NULL COMMENT '필수옵션수정여부' COLLATE 'utf8mb4_0900_ai_ci', `OVERSEAS_GOODS_SALES_YN` VARCHAR(50) NULL DEFAULT NULL COMMENT '해외배송상품판매' COLLATE 'utf8mb4_0900_ai_ci', `RELEASETERM` VARCHAR(50) NULL DEFAULT NULL COMMENT '출고소요일' COLLATE 'utf8mb4_0900_ai_ci', `SHIPPINGMETHODYN` VARCHAR(50) NULL DEFAULT NULL COMMENT '배송방법' COLLATE 'utf8mb4_0900_ai_ci', `ISADDITIONALSHIPPINGFEE` VARCHAR(50) NULL DEFAULT NULL COMMENT '도서산간추가배송비 버튼값', `ADDITIONALSHIPPINGFEE` VARCHAR(50) NULL DEFAULT NULL COMMENT '도서/산간추가배송비' COLLATE 'utf8mb4_0900_ai_ci', `RETURNSHIPPINGFEE` VARCHAR(50) NULL DEFAULT NULL COMMENT '반품/교환추가배송비(반품)' COLLATE 'utf8mb4_0900_ai_ci', `CHANGESHIPPINGFEE` VARCHAR(50) NULL DEFAULT NULL COMMENT '반품/교환추가배송비(교환)' COLLATE 'utf8mb4_0900_ai_ci', `ISRETURNEDADDRESSYN` VARCHAR(50) NULL DEFAULT NULL COMMENT '반품주소지설정' COLLATE 'utf8mb4_0900_ai_ci', `TITLEUSEYN` VARCHAR(50) NULL DEFAULT NULL COMMENT '타이틀사용여부' COLLATE 'utf8mb4_0900_ai_ci', `TOTALAPPLICATIONYN` VARCHAR(50) NULL DEFAULT NULL COMMENT '일괄적용설정' COLLATE 'utf8mb4_0900_ai_ci', `PRODUCTDIREGMETHODYN` VARCHAR(50) NULL DEFAULT NULL COMMENT '거래정보' COLLATE 'utf8mb4_0900_ai_ci', `PRODNMOUT` VARCHAR(50) NULL DEFAULT NULL COMMENT '상품명출력방법' COLLATE 'utf8mb4_0900_ai_ci', `PRODNMSTART` VARCHAR(50) NULL DEFAULT NULL COMMENT '상품명추가앞' COLLATE 'utf8mb4_0900_ai_ci', `PRODNMEND` VARCHAR(50) NULL DEFAULT NULL COMMENT '상품명추가뒤' COLLATE 'utf8mb4_0900_ai_ci', `REMARKSTART` LONGTEXT NULL COMMENT '상세설명추가앞' COLLATE 'utf8mb4_0900_ai_ci', `REMARKEND` LONGTEXT NULL COMMENT '상세설명추가뒤' COLLATE 'utf8mb4_0900_ai_ci', `REMARKENDOUT` VARCHAR(50) NULL DEFAULT NULL COMMENT '상세설명뒤부분출력위치' COLLATE 'utf8mb4_0900_ai_ci', `SHIPPINGFEETYPE` VARCHAR(50) NULL DEFAULT NULL COMMENT '배송비종류(01:무료배송, 02:유료배송, 03:유료배송(예외), 04:유료배송(조건부무료)', `SHIPPINGFEEPAYTYPETMP2` VARCHAR(50) NULL DEFAULT NULL COMMENT '유료배송[콤보]' COLLATE 'utf8mb4_0900_ai_ci', `SHIPPINGFEETYPETMP3` VARCHAR(50) NULL DEFAULT NULL COMMENT '유료배송(예외)[콤보]' COLLATE 'utf8mb4_0900_ai_ci', `SHIPPINGFEEPAYTYPETMP4` VARCHAR(50) NULL DEFAULT NULL COMMENT '유료배송(조건부무료)[콤보]' COLLATE 'utf8mb4_0900_ai_ci', `SHIPPINGFEETMP2` VARCHAR(50) NULL DEFAULT NULL COMMENT '유료배송텍스트' COLLATE 'utf8mb4_0900_ai_ci', `SHIPPINGFEETMP4` VARCHAR(50) NULL DEFAULT NULL COMMENT '유료배송(조건부무료)텍스트1' COLLATE 'utf8mb4_0900_ai_ci', `FREESHIPPINGAMOUNT` VARCHAR(50) NULL DEFAULT NULL COMMENT '유료배송(조건부무료)텍스트2' COLLATE 'utf8mb4_0900_ai_ci', `UI_LIMITCNTUSEYN` VARCHAR(50) NULL DEFAULT NULL COMMENT '판매수량제한사용' COLLATE 'utf8mb4_0900_ai_ci', `UI_QUANTITYCNTUSEYN` VARCHAR(50) NULL DEFAULT NULL COMMENT '수량별 배송비' COLLATE 'utf8mb4_0900_ai_ci', `UI_LIMITCNT` VARCHAR(50) NULL DEFAULT NULL COMMENT '수량별배송비 텍스트' COLLATE 'utf8mb4_0900_ai_ci', `SELLERDC` FLOAT NULL DEFAULT NULL COMMENT '판매자즉시할인', `DC` FLOAT NULL DEFAULT NULL COMMENT '할인율', `FLATDC` FLOAT NOT NULL COMMENT '정액할인', `MARGIN` FLOAT NULL DEFAULT NULL COMMENT '마진율', `COMMISSION` FLOAT NULL DEFAULT NULL COMMENT '수수료율', `FREEDELIVERY` VARCHAR(2) NULL DEFAULT NULL COMMENT '상품가격에* 체크박스 값(T사용함, F사용안함)', `EXPPRC` VARCHAR(50) NULL DEFAULT NULL COMMENT '상품가격에추가' COLLATE 'utf8mb4_0900_ai_ci', `CHANGESIZE` VARCHAR(50) NULL DEFAULT NULL COMMENT '대표사진사이즈변경 버튼' COLLATE 'utf8mb4_0900_ai_ci', `CHANGESIZEX` VARCHAR(50) NULL DEFAULT NULL COMMENT '대표사진사이즈변경 X' COLLATE 'utf8mb4_0900_ai_ci', `CHANGESIZEY` VARCHAR(50) NULL DEFAULT NULL COMMENT '대표사진사이즈변경 Y' COLLATE 'utf8mb4_0900_ai_ci', `CHANGESIZEW` VARCHAR(50) NULL DEFAULT NULL COMMENT '대표사진사이즈변경 W' COLLATE 'utf8mb4_0900_ai_ci', `CHANGESIZEH` VARCHAR(50) NULL DEFAULT NULL COMMENT '대표사진사이즈변경 H' COLLATE 'utf8mb4_0900_ai_ci', `DETAILKEYWORDB` VARCHAR(50) NULL DEFAULT NULL COMMENT '상세페이지 상단 (키워드) 버튼' COLLATE 'utf8mb4_0900_ai_ci', `DETAILKEYWORDL` TEXT NULL COMMENT '상세페이지 상단 (키워드)' COLLATE 'utf8mb4_0900_ai_ci', `DETAILKEYWORDR` TEXT NULL COLLATE 'utf8mb4_0900_ai_ci', `DETAILPRODUCTCODEB` VARCHAR(50) NULL DEFAULT NULL COMMENT '상세페이지 상단 (상품코드) 버튼' COLLATE 'utf8mb4_0900_ai_ci', `DETAILPRODUCTCODEL` TEXT NULL COMMENT '상세페이지 상단 (상품코드)' COLLATE 'utf8mb4_0900_ai_ci', `DETAILPRODUCTCODER` TEXT NULL COLLATE 'utf8mb4_0900_ai_ci', `DETAILPRODUCTNAMEB` VARCHAR(50) NULL DEFAULT NULL COMMENT '상세페이지 상단 (상품명) 버튼' COLLATE 'utf8mb4_0900_ai_ci', `DETAILPRODUCTNAMEL` TEXT NULL COMMENT '상세페이지 상단 (상품명)' COLLATE 'utf8mb4_0900_ai_ci', `DETAILPRODUCTNAMER` TEXT NULL COLLATE 'utf8mb4_0900_ai_ci', `ADDOPTIONLB` VARCHAR(50) NULL DEFAULT NULL COMMENT '옵션추가 왼쪽 버튼' COLLATE 'utf8mb4_0900_ai_ci', `ADDOPTIONL` VARCHAR(50) NULL DEFAULT NULL COMMENT '옵션추가 왼쪽' COLLATE 'utf8mb4_0900_ai_ci', `ADDOPTIONRB` VARCHAR(50) NULL DEFAULT NULL COMMENT '옵션추가 오른쪽 버튼' COLLATE 'utf8mb4_0900_ai_ci', `ADDOPTIONR` VARCHAR(50) NULL DEFAULT NULL COMMENT '옵션추가 오른쪽' COLLATE 'utf8mb4_0900_ai_ci', PRIMARY KEY (`SEQ`), UNIQUE INDEX `SEQ` (`SEQ`) ) COLLATE='utf8mb4_0900_ai_ci' ENGINE=InnoDB AUTO_INCREMENT=254; CREATE TABLE SHOPLOTTEONADDDTL ( `SEQ` INT NOT NULL COMMENT '일련번호', `COMPNO` INT NULL DEFAULT NULL COMMENT '회사코드', `SHOPCD` VARCHAR(50) NULL DEFAULT NULL COMMENT '쇼핑몰코드' COLLATE 'utf8mb4_0900_ai_ci', `SHOPSEQ` INT NULL DEFAULT NULL COMMENT '쇼핑몰', `SHOPID` VARCHAR(50) NULL DEFAULT NULL COMMENT '쇼핑몰아이디' COLLATE 'utf8mb4_0900_ai_ci', `TITLE` VARCHAR(50) NULL DEFAULT NULL COMMENT '부가정보이름' COLLATE 'utf8mb4_0900_ai_ci', `ISCATEGORY` VARCHAR(50) NULL DEFAULT NULL COMMENT '카테고리 사용여부' COLLATE 'utf8mb4_0900_ai_ci', `LAGCATCD` VARCHAR(50) NULL DEFAULT NULL COMMENT '카테고리 대분류' COLLATE 'utf8mb4_0900_ai_ci', `MIDCATCD` VARCHAR(50) NULL DEFAULT NULL COMMENT '카테고리 중분류' COLLATE 'utf8mb4_0900_ai_ci', `SMLCATCD` VARCHAR(50) NULL DEFAULT NULL COMMENT '카테고리 소분류' COLLATE 'utf8mb4_0900_ai_ci', `DETCATCD` VARCHAR(50) NULL DEFAULT NULL COMMENT '카테고리 세분류' COLLATE 'utf8mb4_0900_ai_ci', `SHOPCATNO` VARCHAR(50) NULL DEFAULT NULL, `SHOPCATSITENM` VARCHAR(200) NULL DEFAULT NULL, `IMGONEONONE` VARCHAR(200) NULL DEFAULT NULL COMMENT '이미지 1:1비율 노출', `IMGTHREEONFOUR` VARCHAR(200) NULL DEFAULT NULL COMMENT '이미지 3:4비율 노출', `SHOPUSERID` VARCHAR(50) NULL DEFAULT NULL, `CTRTTYPCD` VARCHAR(50) NULL DEFAULT NULL COMMENT '계약유형코드 A 중개 B 위탁' COLLATE 'utf8mb4_0900_ai_ci', `CSHBLTYPDYN` VARCHAR(50) NULL DEFAULT NULL COMMENT '환금성상품여부 Y 적용 N 미적용' COLLATE 'utf8mb4_0900_ai_ci', `AGELMTCD` VARCHAR(50) NULL DEFAULT NULL COMMENT '연령제한코드 0 전연령구매가능 15 15세이상구매가능 19 19세이상구매가능' COLLATE 'utf8mb4_0900_as_ci', `BOOKCULTCSTDDCTYN` VARCHAR(50) NULL DEFAULT NULL COMMENT '도서문화비공제여부 Y 적용 M 미적용' COLLATE 'utf8mb4_0900_ai_ci', `SLTYPCD` VARCHAR(50) NULL DEFAULT NULL COMMENT '판매유형코드 GNRL 일반판매상품 CNSL 상담판매상품', `PDTYPCD` VARCHAR(50) NULL DEFAULT NULL COMMENT '상품유형코드 GNRL_GNRL 일반판매_일반상품 GNRL_ECPN 일반판매_e쿠폰상품 GNRL_GFTV 일반판매_상품권 GNRL_ZRWON 일반판매_0원상품 CNSL_CNSL 상담판매_상담상품', `BRDREGYN` VARCHAR(50) NULL DEFAULT NULL COMMENT '브랜드등록여부 Y 브랜드등록안함 N 등록' COLLATE 'utf8mb4_0900_ai_ci', `BRDPDINFOYN` VARCHAR(50) NULL DEFAULT NULL COMMENT '브랜드정보종류여부 Y 상품정보사용 N 세트정보사용', `BRDPDREGPRCYN` VARCHAR(50) NULL DEFAULT NULL COMMENT '브랜드미조회시처리여부 Y 실패처리 N 브랜드없이등록' COLLATE 'utf8mb4_0900_ai_ci', `BRDPDRST` VARCHAR(50) NULL DEFAULT NULL COMMENT '브랜드등록결과' COLLATE 'utf8mb4_0900_ai_ci', `BRND_ID` VARCHAR(50) NULL DEFAULT NULL COMMENT '브랜드아이디', `TDFDVSCD` VARCHAR(50) NULL DEFAULT NULL COMMENT '과세구분 ' COLLATE 'utf8mb4_0900_ai_ci', `OPLCCD` VARCHAR(50) NULL DEFAULT NULL COMMENT '원산지코드 Y 세트사용 N 상품기본정보사용' COLLATE 'utf8mb4_0900_ai_ci', `IMPCONM` VARCHAR(50) NULL DEFAULT NULL COMMENT '수입사명' COLLATE 'utf8mb4_0900_ai_ci', `IMPDVSCD` VARCHAR(50) NULL DEFAULT NULL COMMENT '수입구분코드 DRC_IMP 직수입 PRL_IMP 병행수입 NONE 해당없음' COLLATE 'utf8mb4_0900_ai_ci', `PDSTATCD` VARCHAR(50) NULL DEFAULT NULL COMMENT '상품상태코드 NEW 새상품 DP 전시상품 RFRBSH 리퍼상품 SCRTC 스크레치상품 RTRN_NRML 반품(정상)상품 RTRN_DMG 반품(박스훼손)상품 USD 중고상품' COLLATE 'utf8mb4_0900_ai_ci', `SLSTRTDTTM` VARCHAR(50) NULL DEFAULT NULL COMMENT '판매기간_판매시작일시 ', `SLENDDTTM` VARCHAR(50) NULL DEFAULT NULL COMMENT '판매기간_판매종료일시', `PRCCMPREPSRYN` VARCHAR(50) NULL DEFAULT NULL COMMENT '가격비교노출여부 Y 노출 N 노출안함', `CNCLPSBYN` VARCHAR(50) NULL DEFAULT NULL COMMENT '취소가능여부 Y 가능 N 불가능', `IMMDCNCLPSBYN` VARCHAR(50) NULL DEFAULT NULL COMMENT '즉시취소가능여부 Y 가능 N 불가능', `BRKHMAPPKCPPSBYN` VARCHAR(50) NULL DEFAULT NULL COMMENT '폐가전수거여부 Y 사용 N 사용안함', `PRSTPSBYN` VARCHAR(50) NULL DEFAULT NULL COMMENT '선물가능여부 Y 사용 N 사용안함', `ITMBYMINPURYN` VARCHAR(50) NULL DEFAULT NULL COMMENT '단품별최소구매여부 Y 사용 N 사용안함', `ITMBYMAXPURPSBQTYYN` VARCHAR(50) NULL DEFAULT NULL COMMENT '단품별최대구매가능수량여부 Y 사용 N 사용안함' COLLATE 'utf8mb4_0900_ai_ci', `ASGUIDE` LONGTEXT NULL COMMENT 'A/S안내' COLLATE 'utf8mb4_0900_ai_ci', `STKMGTYN` VARCHAR(50) NULL DEFAULT NULL COMMENT '재고관리여부 Y 사용 N 사용안함' COLLATE 'utf8mb4_0900_ai_ci', `PDOPTMODIFYYN` VARCHAR(50) NULL DEFAULT NULL COMMENT '상품옵션수정여부 Y 수정함 Y 수정안함' COLLATE 'utf8mb4_0900_ai_ci', `SELSALEOPTSETYN` VARCHAR(50) NULL DEFAULT NULL COMMENT '선택형판매옵션설정여부 Y 설정함 N 설정안함' COLLATE 'utf8mb4_0900_ai_ci', `PDPRTWAY` VARCHAR(50) NULL DEFAULT NULL COMMENT '상품명출력방법' COLLATE 'utf8mb4_0900_ai_ci', `PDNMADDFRTTXT` VARCHAR(50) NULL DEFAULT NULL COMMENT '상품명추가글귀(앞)' COLLATE 'utf8mb4_0900_ai_ci', `PDNMADDBACKTXT` VARCHAR(50) NULL DEFAULT NULL COMMENT '상품명추가글귀(뒤)' COLLATE 'utf8mb4_0900_ai_ci', `PDDTLFRTDEC` LONGTEXT NULL COMMENT '상품상세설명(앞부분추가내용)' COLLATE 'utf8mb4_0900_ai_ci', `PDDTLBACKDEC` LONGTEXT NULL COMMENT '상품상세설명(뒷부분추가내용)' COLLATE 'utf8mb4_0900_ai_ci', `PDDTLBACKDECPRTLOC` VARCHAR(50) NULL DEFAULT NULL COMMENT '상품상세설명 뒷부분 출력위치' COLLATE 'utf8mb4_0900_ai_ci', `DMSTOVSDVDVSCD` VARCHAR(50) NULL DEFAULT NULL COMMENT '국내해외배송구분코드 DMST 국내배송 OVS 해외발송 RVRS_DPUR 역직구 ', `PSTKYN` VARCHAR(50) NULL DEFAULT NULL COMMENT '선재고여부 Y 사용 N 사용안함', `DVPROCTYPCD` VARCHAR(50) NULL DEFAULT NULL COMMENT '배송처리유형코드 LO_CNTR e커머스 센터배송 LO_ENTP e커머스 업체배송', `DVPDTYPCD` VARCHAR(50) NULL DEFAULT NULL COMMENT '배송상품유형코드 TDY_SND 오늘발송 0 GNRL 일반상품 3 OD_MFG 주문제작상품 15 FREE_INST 무료설치상품 3 CHRG_INST 유료설치상품 3 PRMM_INST 프리미엄설치상품 365 ECPN e쿠폰 0 GFTV 상품권 3 OVS 해외배송 15', `NLDYSNDCLOSETM` VARCHAR(50) NULL DEFAULT NULL COMMENT '평일발송마감시간' COLLATE 'utf8mb4_0900_ai_ci', `SATSNDPSBYN` VARCHAR(50) NULL DEFAULT NULL COMMENT '토요일발송가능여부 Y 발송가능 N 발송불가', `SATSNDCLOSETM` VARCHAR(50) NULL DEFAULT NULL COMMENT '토요일발송마감시간', `DVRGSPRGRPCD` VARCHAR(50) NULL DEFAULT NULL COMMENT '배송권역그룹코드', `DVMNSCD` VARCHAR(50) NULL DEFAULT NULL COMMENT '배송수단코드 DGNN_DV 전담배송(직접배송) DPCL 택배 NONE_DV 무배송 REG_MAIL 등기 ZIP 우편', `OWHPNO` VARCHAR(50) NULL DEFAULT NULL COMMENT '출고지번호', `HDCCD` VARCHAR(50) NULL DEFAULT NULL COMMENT '택배사코드 0001 롯데택배 0003 현대택배 0004 우체국택배 0005 로젠택배 0006 한진택배 0014 GTX 로지스 택배 0016 KGB택배 0023 건영택배 0024 경동택배 0025 고려택배 0027 대신정기화물택배 0028 대신택배 0031 드림택배 0037 엘로우캡택배 0040 이노지스택배 0042 일양택배 0043 천일택배 0044 편의점택배 0046 하나로택배 0048 한의사랑택배 0049 합동택배 0050 호남택배 9999 기타택배', `DVCSTPOLNO` VARCHAR(50) NULL DEFAULT NULL COMMENT '배송비정책번호', `ADTNDVCSTPOLNO` VARCHAR(50) NULL DEFAULT NULL COMMENT '추가배송비정책번호', `CMDNDVPSBYN` VARCHAR(50) NULL DEFAULT NULL COMMENT '합배송가능여부 Y 합배송가능 N 합배송불가', `DVCSTSTDQTY` VARCHAR(50) NULL DEFAULT NULL COMMENT '수량별배송비부과기준' COLLATE 'utf8mb4_0900_ai_ci', `QCKDVUSEYN` VARCHAR(50) NULL DEFAULT NULL COMMENT '퀵배송사용여부 Y 퀵배송가능 N 퀵배송불가', `CRDAYDVPSBYN` VARCHAR(50) NULL DEFAULT NULL COMMENT '당일배송가능여부 Y 당일배송가능 N 당일배송불가', `ODCLOSETM` VARCHAR(50) NULL DEFAULT NULL COMMENT '주문마감시간', `HPDDDVPSBYN` VARCHAR(50) NULL DEFAULT NULL COMMENT '희망일배송가능여부 Y 가능 N 불가', `SAVETYPCD` VARCHAR(50) NULL DEFAULT NULL COMMENT '저장유형코드 RFRG 냉장 FRZN 냉동 FRSH 신선 NONE 해당없음', `RTNGPSBYN` VARCHAR(50) NULL DEFAULT NULL COMMENT '반품가능여부 Y 가능 N 불가', `XCHGPSBYN` VARCHAR(50) NULL DEFAULT NULL COMMENT '교환가능여부 Y 가능 N 불가', `ECHGPSBYN` VARCHAR(50) NULL DEFAULT NULL COMMENT '맞교환가능여부 Y 가능 N 불가', `CMBNRTNGPSBYN` VARCHAR(50) NULL DEFAULT NULL COMMENT '합반품가능여부 Y 가능 N 불가', `RTNGHDCCD` VARCHAR(50) NULL DEFAULT NULL COMMENT '반품택배사코드 0001 롯데택배 0003 현대택배 0004 우체국택배 0005 로젠택배 0006 한진택배 0014 GTX 로지스 택배 0016 KGB택배 0023 건영택배 0024 경동택배 0025 고려택배 0027 대신정기화물택배 0028 대신택배 0031 드림택배 0037 엘로우캡택배 0040 이노지스택배 0042 일양택배 0043 천일택배 0044 편의점택배 0046 하나로택배 0048 한의사랑택배 0049 합동택배 0050 호남택배 9999 기타택배', `RTNGRTRVPSBYN` VARCHAR(50) NULL DEFAULT NULL COMMENT '반품회수가능여부 Y 가능 N 불가', `RTRPNO` VARCHAR(50) NULL DEFAULT NULL COMMENT '회수지번호', `SBJPSTTITUSEYN` VARCHAR(50) NULL DEFAULT NULL COMMENT '품목고시타이틀사용여부 Y 타이틀 사용 함 N 타이틀 사용 안함', `BTCAPPSETYN` VARCHAR(50) NULL DEFAULT NULL COMMENT '일괄적용설정여부 Y [상세정보 별도표기]적용 안함 N [상세정보 별도표기] 적용 함', `PDPSTDIVS` VARCHAR(50) NULL DEFAULT NULL COMMENT '상품고시분류', `FREEDELIVERY` VARCHAR(2) NULL DEFAULT NULL, `EXPPRC` VARCHAR(50) NULL DEFAULT NULL, `CHANGESIZE` VARCHAR(50) NULL DEFAULT NULL COMMENT '대표사진사이즈변경 버튼' COLLATE 'utf8mb4_0900_ai_ci', `CHANGESIZEX` VARCHAR(50) NULL DEFAULT NULL COMMENT '대표사진사이즈변경 X', `CHANGESIZEY` VARCHAR(50) NULL DEFAULT NULL COMMENT '대표사진사이즈변경 Y', `CHANGESIZEW` VARCHAR(50) NULL DEFAULT NULL COMMENT '대표사진사이즈변경 W', `CHANGESIZEH` VARCHAR(50) NULL DEFAULT NULL COMMENT '대표사진사이즈변경 H', `DETAILKEYWORDB` VARCHAR(50) NULL DEFAULT NULL COMMENT '상세페이지 상단 (키워드) 버튼' COLLATE 'utf8mb4_0900_ai_ci', `DETAILKEYWORDL` TEXT NULL COMMENT '상세페이지 상단 (키워드)' COLLATE 'utf8mb4_0900_ai_ci', `DETAILKEYWORDR` TEXT NULL COLLATE 'utf8mb4_0900_ai_ci', `DETAILPRODUCTCODEB` VARCHAR(50) NULL DEFAULT NULL COMMENT '상세페이지 상단 (상품코드) 버튼' COLLATE 'utf8mb4_0900_ai_ci', `DETAILPRODUCTCODEL` TEXT NULL COMMENT '상세페이지 상단 (상품코드)' COLLATE 'utf8mb4_0900_ai_ci', `DETAILPRODUCTCODER` TEXT NULL COLLATE 'utf8mb4_0900_ai_ci', `DETAILPRODUCTNAMEB` VARCHAR(50) NULL DEFAULT NULL COMMENT '상세페이지 상단 (상품명) 버튼' COLLATE 'utf8mb4_0900_ai_ci', `DETAILPRODUCTNAMEL` TEXT NULL COMMENT '상세페이지 상단 (상품명)' COLLATE 'utf8mb4_0900_ai_ci', `DETAILPRODUCTNAMER` TEXT NULL COLLATE 'utf8mb4_0900_ai_ci', `ADDOPTIONLB` VARCHAR(50) NULL DEFAULT NULL COMMENT '옵션추가 왼쪽 버튼' COLLATE 'utf8mb4_0900_ai_ci', `ADDOPTIONL` VARCHAR(50) NULL DEFAULT NULL COMMENT '옵션추가 왼쪽', `ADDOPTIONRB` VARCHAR(50) NULL DEFAULT NULL COMMENT '옵션추가 오른쪽 버튼' COLLATE 'utf8mb4_0900_ai_ci', `ADDOPTIONR` VARCHAR(50) NULL DEFAULT NULL COMMENT '옵션추가 오른쪽', `SELLERDC` FLOAT NULL DEFAULT NULL COMMENT '판매자즉시할인', `DCRATE` FLOAT NULL DEFAULT NULL COMMENT '할인율', `CUMDC` FLOAT NULL DEFAULT NULL COMMENT '정액할인', `MARGINDC` FLOAT NULL DEFAULT NULL COMMENT '마진율', `COMMDC` FLOAT NULL DEFAULT NULL COMMENT '수수료율', PRIMARY KEY (`SEQ`), UNIQUE INDEX `SEQ` (`SEQ`) ) COLLATE='utf8mb4_0900_ai_ci' ENGINE=InnoDB; ALTER TABLE SHOPPRODIN CHANGE COLUMN `GOODS_REMARKS` `GOODS_REMARKS` LONGTEXT NULL DEFAULT NULL COMMENT '상품상세설명' COLLATE 'utf8mb4_0900_ai_ci' AFTER `IMG_PATH24`; UPDATE SHOPINFODOME SET `PRODREGIS`='서비스', `PRODMODIFY`='서비스', `PRODSOLDOUT`='서비스' WHERE `SHOPCD`='shop0203'; ALTER TABLE ORDDTL ADD COLUMN `CLMDT` VARCHAR(8) NULL DEFAULT NULL AFTER `ASIGNHSEQ`, ADD COLUMN `CLMSEQ` INT(10) NULL DEFAULT NULL AFTER `CLMDT`; insert into shopdeliverys (DLVNM, DLVID, SHOPCD, EXPRESS_URL_ID, DOSIN_CODE) values ('건영택배','25','shop0233','0','건영택배'), ('경동택배','69','shop0233','1','경동택배'), ('굿투럭','88','shop0233','0',''), ('대신택배','19','shop0233','0','대신택배'), ('대운글로벌','50','shop0233','0',''), ('로드썬익스프레스','44','shop0233','0',''), ('로젝스','45','shop0233','0',''), ('로젠택배','8','shop0233','3','로젠택배'), ('롯데글로벌로지스(국제택배)','57','shop0233','10','롯데택배(구 현대택배)'), ('롯데택배','64','shop0233','10','롯데택배(구 현대택배)'), ('성원글로벌','49','shop0233','0',''), ('아주택배','11','shop0233','0','아주택배'), ('우체국택배','12','shop0233','5','우체국택배'), ('우편등기','30','shop0233','0','우체국등기'), ('유로택배','60','shop0233','0',''), ('이노지스택배','18','shop0233','0','이노지스택배'), ('일양로지스','20','shop0233','6','일양택배'), ('자체배송','17','shop0233','0','자체배송'), ('천일택배','21','shop0233','7','천일택배'), ('트라넷','6','shop0233','0',''), ('편의점택배','32','shop0233','13','편의점택배'), ('하나로택배','13','shop0233','0',''), ('한덱스','75','shop0233','0',''), ('한의사랑택배','76','shop0233','0',''), ('한진택배','63','shop0233','9','한진택배'), ('합동택배','26','shop0233','0','합동택배'), ('호남택배','29','shop0233','11','호남택배'), ('홈픽택배','66','shop0233','0',''), ('훼미리택배','3','shop0233','0',''), ('ACI','53','shop0233','0',''), ('ADC항운택배','40','shop0233','0',''), ('AIRWAY익스프레스','46','shop0233','0',''), ('APEX','36','shop0233','0',''), ('CJ대한통운','7','shop0233','12','CJ 대한통운'), ('CJ대한통운(국제택배)','58','shop0233','0','CJ국제특송'), ('CU 편의점택배','68','shop0233','13','CU편의점택배'), ('CVSnet 편의점택배(GS25)','67','shop0233','13','편의점택배,CU편의점택배'), ('CwayExpress','37','shop0233','0',''), ('DHL','23','shop0233','14','DHL'), ('DHL Global Mail','84','shop0233','14','DHL'), ('DHLGlobalMail','42','shop0233','14','DHL'), ('DPD','39','shop0233','0',''), ('EMS','77','shop0233','15','EMS국제우편'), ('EMS우체국','22','shop0233','15','EMS국제우편'), ('EuroParcel','38','shop0233','0',''), ('EZUSA','52','shop0233','0',''), ('FEDEX','34','shop0233','16','FEDEX'), ('GSI Express','90','shop0233','0',''), ('GSI익스프레스','59','shop0233','0',''), ('GSMNTON','56','shop0233','0',''), ('GTX로지스','27','shop0233','0','GTX택배'), ('HI택배','43','shop0233','0',''), ('i-parcel','51','shop0233','0',''), ('KGB택배','14','shop0233','0','KGB특급택배'), ('KGL네트웍스','87','shop0233','0',''), ('KT로지스','5','shop0233','0',''), ('LX판토스','85','shop0233','0',''), ('SFexpress','41','shop0233','0',''), ('SLX택배','33','shop0233','0',''), ('TNT','35','shop0233','0',''), ('TNT Express','79','shop0233','0',''), ('UPS','80','shop0233','0',''), ('USPS','47','shop0233','0','USPS'), ('WarpEx','55','shop0233','0',''), ('WIZWA','54','shop0233','0',''); ALTER TABLE `systemconf` ADD COLUMN `AUTOSTAT` TINYINT NULL DEFAULT '0' AFTER `PRODCPYYN`; UPDATE `shopdeliverys` SET `DOSIN_CODE`='CJ 대한통운' WHERE `SHOPCD`='shop0068' AND `DLVID`='10013'; CREATE TABLE `shopaddprodinfo` ( `PRODSEQ` INT(10) NOT NULL DEFAULT '0', `PROD_CD` VARCHAR(50) NOT NULL COMMENT '추가상품코드' COLLATE 'utf8mb4_0900_ai_ci', `COMPAYNY_GOODS_CD` VARCHAR(50) NOT NULL COMMENT '부모상품코드' COLLATE 'utf8mb4_0900_ai_ci', `PROD_NM` VARCHAR(200) NULL DEFAULT NULL COMMENT '추가상품명' COLLATE 'utf8mb4_0900_ai_ci', `PROD_VAL` VARCHAR(200) NULL DEFAULT NULL COMMENT '추가상품값' COLLATE 'utf8mb4_0900_ai_ci', `PROD_AMT` INT(10) NULL DEFAULT NULL COMMENT '추가상품금액', `PROD_CNT` INT(10) NULL DEFAULT NULL COMMENT '추가상품수량', `PROD_STATUS` INT(10) NULL DEFAULT NULL COMMENT '추가상품판매상태', PRIMARY KEY (`PRODSEQ`, `PROD_CD`) USING BTREE ) COMMENT='추가상품정보 테이블' COLLATE='utf8mb4_0900_ai_ci' ENGINE=InnoDB ; CREATE TABLE `productcd_sequence` ( `seq_name` VARCHAR(4) NOT NULL COMMENT '시퀀스에 사용될 명칭' COLLATE 'utf8mb4_0900_ai_ci', `seq_no` INT(10) NOT NULL COMMENT '시퀀스 no', PRIMARY KEY (`seq_name`) USING BTREE ) COMMENT='상품코드 시퀀스테이블' COLLATE='utf8_general_ci' ENGINE=InnoDB ; CREATE TABLE `shopprodinremarks` ( `COMPNO` INT(10) NOT NULL COMMENT '회사코드', `SHOPCD` VARCHAR(20) NOT NULL COMMENT '쇼핑몰 코드' COLLATE 'utf8mb4_0900_ai_ci', `SHOPSEQ` INT(10) NOT NULL COMMENT '쇼핑몰 별 SEQ', `PRODSEQ` INT(10) NOT NULL DEFAULT '0' COMMENT '판매자 상품코드', `HTML_DESC` LONGTEXT NULL DEFAULT NULL COMMENT 'HTML 상세설명' COLLATE 'utf8mb4_0900_ai_ci', `ADD_DESC` LONGTEXT NULL DEFAULT NULL COMMENT '추가 상세설명' COLLATE 'utf8mb4_0900_ai_ci', `PRMT_DESC` LONGTEXT NULL DEFAULT NULL COMMENT '광고/홍보 상세설명' COLLATE 'utf8mb4_0900_ai_ci', `ENG_DESC` LONGTEXT NULL DEFAULT NULL COMMENT '영어 상세설명' COLLATE 'utf8mb4_0900_ai_ci', `CHI_DESC` LONGTEXT NULL DEFAULT NULL COMMENT '중국어 상세설명' COLLATE 'utf8mb4_0900_ai_ci', `JAP_DESC` LONGTEXT NULL DEFAULT NULL COMMENT '일본어 상세설명' COLLATE 'utf8mb4_0900_ai_ci', PRIMARY KEY (`COMPNO`, `SHOPCD`, `PRODSEQ`, `SHOPSEQ`) USING BTREE ) COMMENT='상세설명 템플릿 테이블' COLLATE='utf8mb4_0900_ai_ci' ENGINE=InnoDB ;