https://utf8server.cafe24.com/mcake_cms/page_ord/page_order_list.php https://msg.purplebook.io/oauth2/login?message=%EB%A1%9C%EA%B7%B8%EC%9D%B8%EC%9D%B4%20%ED%95%84%EC%9A%94%ED%95%A9%EB%8B%88%EB%8B%A4&returnUrl=http%3A%2F%2Fmsg.purplebook.io%2Fdashboard madecake@naver.com moon*10790 https://nitw.ac.in/tlc/elements/font-icons.htm 아이콘 samples display_errors = On ->php.ini ==================================================================== use mysql; SELECT USER, HOST FROM user; delete from mysql.user where user='mcakecms'; delete from mysql.db where user='mcakecms'; flush privileges; CREATE USER 'mcakecms'@'localhost' identified by '0007'; drop database DB_mcakecms; create database if not exists DB_mcakecms; GRANT ALL PRIVILEGES ON DB_mcakecms.* TO mcakecms@localhost; flush privileges; use DB_mcakecms; SHOW VARIABLES LIKE 'secure_file_priv'; SELECT * FROM sabang_net_goods into outfile 'C:/ProgramData/MySQL/MySQL Server 8.0/Uploads/sabang_net_goods.txt' fields terminated by ',' lines terminated by '\n'; select * from mcake_order_list where list_order_no="24120300393"; select * from mcake_cm_cart_ord WHERE order_no="24120300393"; select * from table_sabangnet limit 54,6; select * from table_upche where upche_order_no='24112500235'; insert into table_upche(upche_code,upche_gubn,upche_cu_sequ,upche_name,upche_saupno,upche_daepyo,upche_damdang,upche_addr,upche_tel,upche_email,upche_date,upche_stat,upche_order_no,upche_id,upche_goods_cnt,upche_unsongja) values("0000","2",0,"","",'',"",'','',"","2024-11-27 14","10","24112500235","mcake1",0,''); upche_cu_sequ int(5) NOT NULL COMMENT '3 소속고객의 취급 순번', upche_name text NOT NULL COMMENT '4 회사명/고객고유번호(6)/수취인', upche_saupno char(12) NOT NULL COMMENT '5 사업자번호/상품모델명/주문번호(11)', upche_daepyo text NOT NULL COMMENT '6 대표자이름/소속고객명', upche_damdang text NOT NULL COMMENT '7 담당자이름/업체요청 도착일(10)', upche_addr text NOT NULL COMMENT '8 회사주소/업체요청 도착일 휴일여부 0:평일 1:공휴일/수취주소', upche_tel text NOT NULL COMMENT '9 회사 연락처/실제출고일(10)//연락처', upche_email text NOT NULL COMMENT '10 회사 e-mail/실제출고일 해당 요일', upche_date datetime NOT NULL COMMENT '11 등록일자/시각', upche_stat char(2) NOT NULL COMMENT '12 소속고객 상태 10:접수..40:주문취소', upche_order_no char(11) NOT NULL COMMENT '13 소속고객 주문번호', upche_id text NOT NULL COMMENT '14 등록ID', upche_goods_cnt int(3) NOT NULL COMMENT '15 판매건수', upche_unsongja char(1 update table_upche set upche_gubn='2',upche_name='재단법인인천광역시사회서비스원',upche_saupno='2024-12-05',upche_daepyo='N',upche_email='kyu@incheon.pass.or.kr' where upche_code='0000' and upche_order_no='24112500235'; use DB_mcakecms; drop table mcake_am_user; CREATE TABLE `mcake_am_user` ( `au_id` text COMMENT '사용자아이디', `au_name` text COMMENT '사용자명', `au_lv` char(1) COMMENT '권한 8:관리자 9:개발자', `au_stat` char(1) COMMENT '계좌상태 0:비밀번호 초기등록요망 1:정상', `au_memo` text COMMENT '메모', `au_regtm` datetime COMMENT '최초등록일', `au_chgtm` datetime COMMENT '최종수정일', `au_logtm` datetime COMMENT '최종접속일', `au_corrcnt` int(3) COMMENT '비밀번호오류회수', `au_ipsa` char(8) COMMENT '입사일자-초기등록비밀번호', `au_pass` text COMMENT '사용자비밀번호'); insert into mcake_am_user(au_id,au_lv,au_name,au_pass,au_memo,au_regtm,au_corrcnt,au_stat,au_ipsa)values("관리자","9","박석규","665081ea948418b5b16ff11af55f81e3","개발자", "2024-06-01 05:00:00",0,'1','20240601'); select * from mcake_am_user; use DB_mcakecms; drop table mcake_category; CREATE TABLE `mcake_category` ( `no` int(11) NOT NULL, `cate_code` char(4) NOT NULL COMMENT '카테고리코드', `cate_name` text NOT NULL COMMENT '카테고리이름', `cate_sort` int(5) NOT NULL COMMENT '카테고리 sort 순서', `cate_yn` char(1) NOT NULL COMMENT '사용유무Y/N', `cate_sdtm` datetime NOT NULL COMMENT '등록이라', `cate_edtm` datetime NOT NULL COMMENT '변경일자', `cate_memo` text NOT NULL COMMENT '메모', `member` text NOT NULL COMMENT '등록직원'); ALTER TABLE `mcake_category` ADD PRIMARY KEY (`no`); ALTER TABLE `mcake_category` MODIFY `no` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1; INSERT INTO `mcake_category` (`no`, `cate_code`, `cate_name`, `cate_sort`, `cate_yn`, `cate_sdtm`, `cate_edtm`, `cate_memo`, `member`)VALUES (1, '1001', '4. 크리스마스',4, 'Y', '2021-11-15 08:55:37', '2023-10-17 16:33:36','','관리자계정'), (2, '1002', '10. 초콜릿',10, 'Y', '2021-11-15 08:56:06', '2023-04-07 09:03:56','', '관리자계정'), (3, '1003', '5. DIY',5, 'Y', '2021-11-15 08:56:47', '2023-10-17 16:33:49','', '관리자계정'), (4, '1004', '6. 생일',6, 'Y', '2021-11-15 08:56:53', '2023-10-17 16:33:54','', '관리자계정'), (5, '1005', '7. 어버이날',7, 'Y', '2021-11-15 08:56:59', '2023-10-17 16:33:59','', '관리자계정'), (6, '1006', '15. 구성품',15, 'Y', '2021-11-15 08:57:05', '2023-04-07 09:04:02','', '관리자계정'), (14, '1007', '99. 카테고리없음',99, 'Y', '2021-11-16 09:55:53', '2021-11-16 09:55:53','', '관리자계정'), (8, '1008', '20. 화과자만주',20, 'Y', '2022-01-17 15:40:57', '2023-04-07 09:04:07','', 'made_sr'), (9, '1009', '9. 박스상품(시트)',9, 'Y', '2022-11-30 14:31:24', '2023-04-07 09:03:46','', 'admin'), (10, '1010', '26. V 떡케이크',26, 'Y', '2023-01-02 13:40:33', '2023-04-07 09:04:27','', 'made_sr'), (11, '1011', '25. S 떡케이크',25, 'Y', '2023-01-18 14:15:52', '2023-04-07 09:04:18','', 'made_sr'), (12, '1012', '1. 크리스마스(NEW)',1, 'Y', '2023-10-17 16:01:31', '2023-10-17 16:34:04','', 'made_sr'), (13, '1013', '2. DIY(NEW)',2, 'Y', '2023-10-17 16:01:58', '2023-10-17 16:34:08','', 'made_sr'), (7, '1014', '3. 생일(NEW)',3, 'Y', '2023-10-17 16:02:05', '2023-10-17 16:34:12','', 'made_sr'); select * from mcake_category; use DB_mcakecms; drop table mcake_cm_cart_temp; CREATE TABLE `mcake_cm_cart_temp` ( `no` int(11) NOT NULL, `temp_no` char(23) NOT NULL, `temp_prod_cate` char(4) NOT NULL, `temp_prod_code` char(7) NOT NULL, `temp_prod_name` text NOT NULL, `temp_prod_sv` char(1) NOT NULL, `temp_prod_uh` text NOT NULL, `temp_prod_set` text NOT NULL, `temp_prod_price` int(11) NOT NULL, `temp_unit_cd` int(5) NOT NULL, `temp_au_id` text NOT NULL); ALTER TABLE `mcake_cm_cart_temp` ADD PRIMARY KEY (`no`); ALTER TABLE `mcake_cm_cart_temp` MODIFY `no` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1; select * from mcake_cm_cart_temp; use DB_mcakecms; drop table mcake_dash_temp; CREATE TABLE `mcake_dash_temp` ( `no` int(11) NOT NULL, `dash_prod_code` varchar(20) NOT NULL, `dash_prod_name` varchar(50) NOT NULL, `dash_prod_ea` varchar(10) NOT NULL, `dash_member_id` varchar(20) NOT NULL); ALTER TABLE `mcake_dash_temp` ADD PRIMARY KEY (`no`); ALTER TABLE `mcake_dash_temp` MODIFY `no` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=1; select * from mcake_dash_temp; use DB_mcakecms; drop table mcake_inventory; CREATE TABLE `mcake_inventory` ( `no` int(11) NOT NULL, `inventory_code` char(7) NOT NULL, `inventory_name` text NOT NULL, `inventory_section_1` int(11) NOT NULL COMMENT '대창', `inventory_section_2` int(11) NOT NULL COMMENT '공장', `inventory_section_3` int(11) NOT NULL COMMENT '창고', `inventory_section_4` int(11) NOT NULL COMMENT '관리계획'); ALTER TABLE `mcake_inventory`ADD PRIMARY KEY (`no`); ALTER TABLE `mcake_inventory` MODIFY `no` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=1; select * from mcake_inventory; use DB_mcakecms; drop table mcake_ord_upload_tmp; CREATE TABLE `mcake_ord_upload_tmp` ( `no_tmp` int(11) NOT NULL, `up_time_code` varchar(50) NOT NULL, `up_time_id` varchar(50) NOT NULL, `up_name_tmp` text NOT NULL COMMENT '[2]수취인명', `up_pnum1_tmp` varchar(20) NOT NULL COMMENT '[3]수취인번호1', `up_pnum2_tmp` varchar(20) NOT NULL COMMENT '[4]수취인번호2', `up_ea_tmp` varchar(10) NOT NULL COMMENT '[7]수량', `up_add_tmp` text NOT NULL COMMENT '[8]수취인주소', `up_memo_tmp` text NOT NULL COMMENT '[9]배송메모', `up_shop_tmp` varchar(50) NOT NULL COMMENT '[14]쇼핑몰', `up_mno_tmp` varchar(10) NOT NULL COMMENT '[21]모델NO', `up_doday_tmp` varchar(20) NOT NULL COMMENT '도착일', `up_hpday_tmp` varchar(20) NOT NULL COMMENT '행사일', `up_pay_tmp` varchar(20) NOT NULL COMMENT '결제방법', `up_payok_tmp` varchar(20) NOT NULL COMMENT '결제유무'); ALTER TABLE `mcake_ord_upload_tmp` ADD PRIMARY KEY (`no_tmp`); ALTER TABLE `mcake_ord_upload_tmp` MODIFY `no_tmp` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=1; select * from mcake_ord_upload_tmp; use DB_mcakecms; drop table Table_Consulting; create table if not exists Table_Consulting ( `no` int(11) NOT NULL COMMENT '일련번호', `con_cu_code` varchar(10) NOT NULL COMMENT '고객 고유번호', `con_list_order_no` char(11) NOT NULL COMMENT '판매 고유번호', `con_date` datetime NOT NULL COMMENT '거래일자/시간', `con_id` text NOT NULL COMMENT '상담직원', `con_sequ` int(5) NOT NULL COMMENT '고객별 상담 일련번호', `con_msg` text NOT NULL COMMENT '상담내용'); ALTER TABLE `Table_Consulting` ADD PRIMARY KEY (`no`); ALTER TABLE `Table_Consulting` MODIFY `no` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1; select * from Table_Consulting; use DB_mcakecms; drop table Table_Halil; create table if not exists Table_Halil ( hsequ char(10) COMMENT '일련번호(yyyymmdd+일련번호(2))', hdate char(10) COMMENT '기준일자', hrdat char(10) COMMENT '등록일자', hcdat char(10) COMMENT '처리일자', hdman text COMMENT '담당자', hrman text COMMENT '등록자', hhali text COMMENT '할일', primary key (hsequ)); insert into Table_Halil(hsequ,hdate,hrdat,hcdat,hdman,hrman,hhali)values("2024080100",'0000-00-00','','','','이 레코드 삭제하지 마세요',''); select * from Table_Halil; use DB_mcakecms; drop table Table_Log; create table if not exists Table_Log ( ldatetime datetime NOT NULL COMMENT '거래일자/시간', ltxname text NOT NULL COMMENT '거래명', ltxid text NOT NULL COMMENT '거래 ID', lrelt text NOT NULL COMMENT '거래결과', ltxip text NOT NULL COMMENT '거래 IP', lprog text NOT NULL COMMENT 'Log 프로그램', ldata text NOT NULL COMMENT '거래별 자료'); .자동로그인-.../index.php .로그인-.../proc/login_process.php .로그아웃-.../proc/logout_process.php .비밀번호 초기등록-.../proc/login_password_reg.php(정상처리부분) .(비밀번호)초기등록-log.php(입력오류부분) .사원정보변경-.../page_au/edit.php .사원해지-.../page_au/del.php .사원등록-.../page_au/insert_member.php .체크-일괄완료-.../page_board/check_action.php .요청상태변경-.../page_board/insert.php .배송방법변경-미정-.../page_ord/check_action.php .배송방법변경-택배-.../page_ord/check_action.php .배송방법변경-화물-.../page_ord/check_action.php .배송방법변경-직배-.../page_ord/check_action.php .배송방법변경-그룹지정-.../page_ord/check_action.php .주문상태변경-접수-.../page_ord/check_action.php .주문상태변경-대기-.../page_ord/check_action.php .주문상태변경-송장-.../page_ord/check_action.php .주문상태변경-보류-.../page_ord/check_action.php .주문상태변경-출고-.../page_ord/check_action.php .주문상태변경-주문취소-.../page_ord/check_action.php .체크송장양식 엑셀출력-.../page_ord/check_action.php .전체보고양식 엑셀출력-.../page_ord/check_action.php .입금확인 요청-.../page_ord/insert.php .../page_ord_cs/insert.php .../page_ord_cs2/insert.php .주문요청사항신청-.../page_ord/insert.php .../page_ord_cs/insert.php .../page_ord_cs2/insert.php .사업자정보등록-.../page_ord/insert.php .../page_ord_cs/insert.php .../page_ord_cs2/insert.php .고객정보변경요청-.../page_ord/insert.php .../page_ord_cs/insert.php .../page_ord_cs2/insert.php .상품정보변경요청-.../page_ord/insert.php .../page_ord_cs2/insert.php .명.견.승.계-.../page_ord_cs2/check_action.php .비밀번호변경-.../page_au/edit_proc.php .재고등록용 상품등록-.../page_au/inventory_set_item.php .재고등록-.../page_au/inventory_set_item.php .재고등록상품목록 삭제-.../page_au/inventory_set_item.php .카테고리삭제-.../page_cate/insert.php .카테고리신규-.../page_cate/insert.php .카테고리변경-.../page_cate/insert.php .상품등록-.../page_prod/insert.php .상품변경-.../page_prod/insert.php .상품삭제-.../page_prod/insert.php .카테고리연결-.../page_prod/insert.php .상품목록 엑셀출력-.../page_prod/excel.php .카테고리 엑셀출력-.../page_cate/excel.php .오늘의할일 등록-.../proc/insert_halil.php .오늘의할일 변경-.../proc/today_to_do_del.php .오늘의할일 삭제-.../proc/today_to_do_del.php .오늘의할일 처리일 등록-.../proc/today_to_do_del.php .상담등록-.../common/insert_consult.php .운송장결과업로드-.../page_ord/unsongjang_relt_upload.php .개별판매-.../page_cart_ord/page_cart2.php .고객신규등록-.../page_cu/insert.php .고객삭제-.../page_cu/insert.php .고객정보변경-.../page_cu/insert.php .운송장번호 업로드-.../page_ord/unsongjan_excel_upload.php .개별발송자료업로드-.../page_cart_ord/gaebyul_excel_upload.php select * from sabang_net_goods where scode="" order by sname; select * from sabang_net_goods order by scode; update sabang_net_goods set scode='9000124' where sname='!10호/만주10구화과자20구'; update sabang_net_goods set scode='9000123' where sname='!9호/만주20구화과자10구'; update sabang_net_goods set scode='9000254' where sname='$세트/S/떡케이크D/꽃12'; update sabang_net_goods set scode='9000308' where sname='41.세트/DIY/미니/초코시트'; update sabang_net_goods set scode='9000350' where sname='74.세트/생일/3호/초코시트'; update sabang_net_goods set scode='9000036' where sname='A0.단품/바닐라시트/미니'; update sabang_net_goods set scode='9000037' where sname='A1.단품/바닐라시트/1호'; update sabang_net_goods set scode='9000040' where sname='B0.단품/초코시트/미니'; update sabang_net_goods set scode='9000041' where sname='B1.단품/초코시트/1호'; update sabang_net_goods set scode='9000043' where sname='B3.단품/초코시트/3호'; update sabang_net_goods set scode='9000001' where sname='D-1.단품/생크림/80g'; update sabang_net_goods set scode='9000002' where sname='D-2.단품/생크림/130g'; update sabang_net_goods set scode='9000003' where sname='D-3.단품/딸기생크림/80g'; update sabang_net_goods set scode='9000014' where sname='M-2.단품/초코펜/화이트/20g'; update sabang_net_goods set scode='9000031' where sname='Z-1.단품/아이스박스/소'; update sabang_net_goods set scode='9000033' where sname='Z-3.단품/아이스박스/15kg'; update sabang_net_goods set scode='9000032' where sname='Z-2.단품/아이스박스/중'; update sabang_net_goods set scode='9000125' where sname='!11호/화과자30구'; update sabang_net_goods set scode='9000120' where sname='!6호/만주10구화과자10구'; update sabang_net_goods set scode='9000099' where sname='2.세트/생일/미니'; update sabang_net_goods set scode='9000095' where sname='1.세트/DIY/미니'; update sabang_net_goods set scode='9000251' where sname='$세트/S/떡케이크A/꽃12'; update sabang_net_goods set scode='9000261' where sname='$세트/S/떡케이크C/꽃12/리본거치대'; update sabang_net_goods set scode='9000262' where sname='$세트/S/떡케이크D/꽃12/리본거치대'; update sabang_net_goods set scode='9000020' where sname='L-2.단품/초코펜/화이트/100g'; update sabang_net_goods set scode='9999999' where sname='$세트/V/떡케이크B/꽃12'; update sabang_net_goods set scode='9000328' where sname='113.세트/DIY/3호/레드벨벳시트'; update sabang_net_goods set scode='9000175' where sname='A5.박스/바닐라시트/1호(30EA)'; update sabang_net_goods set scode='9000142' where sname='N-2.단품/초콜릿비닐(소)/30장'; update sabang_net_goods set scode='9000019' where sname='L-1.단품/초코펜/다크/100g'; update sabang_net_goods set scode='9000035' where sname='Z-5.단품/아이스박스/25kg'; update sabang_net_goods set scode='9000279' where sname='17.세트/DIY/2호/다크펜'; update sabang_net_goods set scode='9000023' where sname='L-5.단품/초코펜/딸기/100g'; update sabang_net_goods set scode='9000009' where sname='H-0.단품/미니상자+받침'; update sabang_net_goods set scode='9000010' where sname='H-1.단품/1호상자+받침'; update sabang_net_goods set scode='9000138' where sname='K-4.단품/몰드/알파벳'; update sabang_net_goods set scode='9000345' where sname='67.세트/생일/2호초코데코/다크펜/초코시트'; update sabang_net_goods set scode='9000320' where sname='57.세트/DIY/2호/다크펜/초코시트'; update sabang_net_goods set scode='9000013' where sname='M-1.단품/초코펜/다크/20g'; update sabang_net_goods set scode='9000017' where sname='M-5.단품/초코펜/딸기/20g'; update sabang_net_goods set scode='9000038' where sname='A2.단품/바닐라시트/2호'; update sabang_net_goods set scode='9000116' where sname='!2호/만주10구화과자5구'; update sabang_net_goods set scode='9000078' where sname='J-5.세트/초콜릿/한글'; update sabang_net_goods set scode='9000077' where sname='J-2.세트/초콜릿/과일'; update sabang_net_goods set scode='9000104' where sname='14.세트/생일/1호초코데코'; update sabang_net_goods set scode='9000356' where sname='!1호/만주15구/아이스박스포장'; update sabang_net_goods set scode='9000117' where sname='!3호/만주5구화과자10구'; update sabang_net_goods set scode='9999999' where sname='$세트/V/떡케이크C/꽃20/리본거치대'; update sabang_net_goods set scode='9999999' where sname='모음/12종/단품/바닐라시트'; update sabang_net_goods set scode='9999999' where sname='O-1.단품/초콜릿상자'; update sabang_net_goods set scode='9000265' where sname='$세트/S/떡케이크D/꽃20/리본거치대'; update sabang_net_goods set scode='9999999' where sname='$세트/V/떡케이크A/꽃12/리본거치대'; update sabang_net_goods set scode='9000315' where sname='53.세트/DIY/1호초코데코/초코시트'; update sabang_net_goods set scode='9000105' where sname='27.세트/생일/2호초코데코/다크펜'; update sabang_net_goods set scode='9000195' where sname='C7.박스/레드벨벳시트/3호(16EA)'; update sabang_net_goods set scode='9999999' where sname='81.세트/DIY/미니/레드벨벳시트'; update sabang_net_goods set scode='9000173' where sname='A4.박스/바닐라시트/미니(36EA)'; update sabang_net_goods set scode='9000174' where sname='A4.박스/바닐라시트/미니(45EA)'; update sabang_net_goods set scode='9999999' where sname='89.세트/DIY/1호/레드벨벳시트'; update sabang_net_goods set scode='9000176' where sname='A5.박스/바닐라시트/1호(36EA)'; update sabang_net_goods set scode='9000177' where sname='A6.박스/바닐라시트/2호(20EA)'; update sabang_net_goods set scode='9000178' where sname='A6.박스/바닐라시트/2호(25EA)'; update sabang_net_goods set scode='9000179' where sname='A7.박스/바닐라시트/3호(16EA)'; update sabang_net_goods set scode='9000180' where sname='A7.박스/바닐라시트/3호(20EA)'; update sabang_net_goods set scode='9000332' where sname='42.세트/생일/미니/초코시트'; update sabang_net_goods set scode='9000033' where sname='Z-2.단품/아이스박스/중15kg'; update sabang_net_goods set scode='9000187' where sname='B7.박스/초코시트/3호(16EA)'; update sabang_net_goods set scode='9000185' where sname='B6.박스/초코시트/2호(20EA)'; update sabang_net_goods set scode='9000338' where sname='50.세트/생일/1호/초코시트'; update sabang_net_goods set scode='9999999' where sname='휘핑생크림80g'; update sabang_net_goods set scode='9000034' where sname='Z-4.단품/아이스박스/20kg'; update sabang_net_goods set scode='9000365' where sname='!10호/만주10구화과자20구/아이스박스포장'; update sabang_net_goods set scode='9000366' where sname='!11호/화과자30구/아이스박스'; update sabang_net_goods set scode='9999999' where sname='!단품/아이스박스/HM'; update sabang_net_goods set scode='9000218' where sname='$세트/V/떡케이크A/꽃12/리본거치대/사랑'; update sabang_net_goods set scode='9000118' where sname='!4호/화과자15구'; update sabang_net_goods set scode='9000121' where sname='!7호/화과자20구'; update sabang_net_goods set scode='9000366' where sname='!11호/화과자30구/아이스박스포장'; update sabang_net_goods set scode='9000101' where sname='19.세트/생일/2호/다크펜'; update sabang_net_goods set scode='9999999' where sname='휘핑생크림(130g)'; update sabang_net_goods set scode='9999999' where sname='해피버스데이초(HAPPYBIRTHDAY)'; update sabang_net_goods set scode='9000075' where sname='J-1.세트/초콜릿/동물'; update sabang_net_goods set scode='9000115' where sname='!1호/만주15구'; update sabang_net_goods set scode='9999999' where sname='생일2호초코데코케이크만들기+다크펜20g'; update sabang_net_goods set scode='9000016' where sname='M-4.단품/초코펜/호박/20g'; update sabang_net_goods set scode='9000356' where sname='!1호/만주15구선물세트(아이스박스)'; update sabang_net_goods set scode='9000039' where sname='A3.단품/바닐라시트/3호'; update sabang_net_goods set scode='9000096' where sname='9.세트/DIY/1호'; update sabang_net_goods set scode='9999999' where sname='파스텔스타(8g)'; update sabang_net_goods set scode='9000018' where sname='M-5.단품/초코펜/자색/20g'; update sabang_net_goods set scode='9999999' where sname='$세트/V/떡케이크A/꽃12/리본거치대|팔팔하니팔순이라전해라백살까지가즈아!!!'; update sabang_net_goods set scode='9999999' where sname='$세트/S/떡케이크A/꽃20/리본거치대|꽃다발리본출력문구:생신축하드림니다.'; update sabang_net_goods set scode='9999999' where sname='$세트/V/떡케이크C/꽃12/리본거치대/승진을진심으로축하드립니다'; update sabang_net_goods set scode='9999999' where sname='$세트/V/떡케이크C/꽃20/리본거치대(환갑을축하합니다/항상건강하세요)'; update sabang_net_goods set scode='9999999' where sname='107.세트/생일/2호초코데코/다크펜/레드벨벳시트'; update sabang_net_goods set scode='9000212' where sname='$세트/V/떡케이크C/꽃다발12/리본거치대/사랑'; update sabang_net_goods set scode='9000361' where sname='!6호/만주10구+화과자10구/아이스박스포장'; update sabang_net_goods set scode='9000203' where sname='$세트/V/떡케이크A/꽃20/리본거치대/사랑'; update sabang_net_goods set scode='9000364' where sname='!9호/만주20구화과자10구/아이스박스포장'; update sabang_net_goods set scode='9000361' where sname='!6호/만주10구화과자10구/아이스박스포장'; update sabang_net_goods set scode='9999999' where sname='118.세트/생일/3호초코데코/레드벨벳시트'; update sabang_net_goods set scode='9000357' where sname='!2호/만주10구화과자5구/아이스박스포장'; update sabang_net_goods set scode='9000358' where sname='!3호/만주5구화과자10구/아이스박스포장'; update sabang_net_goods set scode='9999999' where sname='94.세트/생일/1호초코데코/레드벨벳시트'; update sabang_net_goods set scode='9999999' where sname='99.세트/생일/2호/다크펜/레드벨벳시트'; update sabang_net_goods set scode='9000361' where sname='!6호/만주10구화과자10구(아이스박스)'; update sabang_net_goods set scode='9999999' where sname='97.세트/DIY/2호/다크펜/레드벨벳시트'; update sabang_net_goods set scode='9000361' where sname='!6호/만주10구화과자10구/아이스박스'; update sabang_net_goods set scode='9000333' where sname='46.세트/생일/미니초코데코/초코시트'; update sabang_net_goods set scode='9000339' where sname='54.세트/생일/1호초코데코/초코시트'; update sabang_net_goods set scode='9000351' where sname='78.세트/생일/3호초코데코/초코시트'; update sabang_net_goods set scode='9000259' where sname='$세트/S/떡케이크A/꽃12/리본거치대'; update sabang_net_goods set scode='9000265' where sname='$세트/S/떡케이크C/꽃20/리본거치대'; update sabang_net_goods set scode='9000263' where sname='$세트/V/떡케이크A/꽃20/리본거치대'; update sabang_net_goods set scode='9000261' where sname='$세트/V/떡케이크C/꽃12/리본거치대'; update sabang_net_goods set scode='9000359' where sname='!4호/화과자15/아이스박스포장'; update sabang_net_goods set scode='9000359' where sname='!4호/화과자15구/아이스박스포장'; update sabang_net_goods set scode='9000119' where sname='!5호/만주20구'; update sabang_net_goods set scode='9000360' where sname='!5호/만주20구/아이스박스포장'; update sabang_net_goods set scode='9000362' where sname='!7호/화과자20구/아이스박스포장'; update sabang_net_goods set scode='9999999' where sname='114.세트/생일/3호/레드벨벳시트'; update sabang_net_goods set scode='9000122' where sname='!8호/만주30구'; update sabang_net_goods set scode='9000363' where sname='!8호/만주30구/아이스박스포장'; update sabang_net_goods set scode='9000161' where sname='!단품/메세지카드'; update sabang_net_goods set scode='9999999' where sname='@모음/19종/S떡케이크'; update sabang_net_goods set scode='9000197' where sname='케이크돌림판'; update sabang_net_goods set scode='9999999' where sname='아이스박스(15kg)+아이스팩'; update sabang_net_goods set scode='9000332' where sname='세트/생일/미니/초코시트'; update sabang_net_goods set scode='9999999' where sname='세트/생일/2호/레드벨벳시트'; update sabang_net_goods set scode='9000326' where sname='세트/DIY/3호/초코시트'; update sabang_net_goods set scode='9999999' where sname='생일2호초코데코세트/초코시트'; update sabang_net_goods set scode='9999999' where sname='바닐라미니케이크시트'; update sabang_net_goods set scode='9000015' where sname='M-3.단품/초코펜/밀싹/20g'; update sabang_net_goods set scode='9000315' where sname='13.세트/DIY/1호초코데코/초코시트'; update sabang_net_goods set scode='9000327' where sname='13.세트/DIY/3호초코데코/초코시트'; update sabang_net_goods set scode='9000198' where sname='59.세트/생일/2호/다크펜/초코시트'; update sabang_net_goods set scode='9999999' where sname='모음/40종/단품/케이크/종합'; update sabang_net_goods set scode='9000343' where sname='25.세트/생일/2호초코데코/다크펜'; update sabang_net_goods set scode='9000145' where sname='28.세트/생일/2호초코데코/딸기펜'; update sabang_net_goods set scode='9000196' where sname='A15.박스/레드벨벳시트/3호(20EA)'; update sabang_net_goods set scode='9999999' where sname='82.세트/생일/미니/레드벨벳시트'; update sabang_net_goods set scode='9000109' where sname='25.세트/DIY/2호초코데코/다크펜'; update sabang_net_goods set scode='9999999' where sname='90.세트/생일/1호/레드벨벳시트'; update sabang_net_goods set scode='9999999' where sname='$세트/V/떡케이크A/꽃12/축생일'; update sabang_net_goods set scode='9000141' where sname='N-1.단품/초콜릿비닐(대)/12장'; update sabang_net_goods set scode='9999999' where sname='모음/150종/세트/케이크/종합'; update sabang_net_goods set scode='9000181' where sname='B4.박스/초코시트/미니(36EA)'; update sabang_net_goods set scode='9000182' where sname='B4.박스/초코시트/미니(45EA)'; update sabang_net_goods set scode='9999999' where sname='Z-3.단품/아이스박스/15kg소'; update sabang_net_goods set scode='9999999' where sname='$단품/VIP/떡케이크A/축칠순'; update sabang_net_goods set scode='9000257' where sname='$세트/S/떡케이크C/꽃다발20'; update sabang_net_goods set scode='9000183' where sname='B5.박스/초코시트/1호(30EA)'; update sabang_net_goods set scode='9000186' where sname='B6.박스/초코시트/2호(25EA)'; update sabang_net_goods set scode='9999999' where sname='C-6.자색고구마초코펜(100g)'; update sabang_net_goods set scode='9999999' where sname='Z-1.단품/아이스박스/소15kg'; update sabang_net_goods set scode='9999999' where sname='Z-3.단품/아이스박스/15kg중'; update sabang_net_goods set scode='9000021' where sname='L-3.단품/초코펜/밀싹/100g'; update sabang_net_goods set scode='9000022' where sname='L-4.단품/초코펜/호박/100g'; update sabang_net_goods set scode='9000024' where sname='L-6.단품/초코펜/자색/100g'; update sabang_net_goods set scode='9000102' where sname='34.세트/생일/3호'; update sabang_net_goods set scode='9000199' where sname='49.세트/DIY/1호/초코시트'; update sabang_net_goods set scode='9000098' where sname='13.세트/DIY/1호초코데코'; update sabang_net_goods set scode='9000100' where sname='10.세트/생일/1호'; update sabang_net_goods set scode='9000044' where sname='C0.단품/레드벨벳시트/미니'; update sabang_net_goods set scode='9000308' where sname='1.세트/DIY/미니/초코시트'; update sabang_net_goods set scode='9999999' where sname='Z-1.단품/아이스박스/소중'; update sabang_net_goods set scode='9999999' where sname='$세트/V/떡케이크C/꽃12'; update sabang_net_goods set scode='9000045' where sname='C1.단품/레드벨벳시트/1호'; update sabang_net_goods set scode='9000046' where sname='C2.단품/레드벨벳시트/2호'; update sabang_net_goods set scode='9000047' where sname='C3.단품/레드벨벳시트/3호'; update sabang_net_goods set scode='9999999' where sname='모음/12종/단품/초코시트'; update sabang_net_goods set scode='9999999' where sname='$단품/V/떡케이크C/(단품)'; update sabang_net_goods set scode='9000110' where sname='37.세트/DIY/3호초코데코'; update sabang_net_goods set scode='9000106' where sname='38.세트/생일/3호초코데코'; update sabang_net_goods set scode='9000110' where sname='41.세트/DIY/3호초코데코'; update sabang_net_goods set scode='9000277' where sname='5.세트/DIY/미니초코데코'; update sabang_net_goods set scode='9000103' where sname='6.세트/생일/미니초코데코'; update sabang_net_goods set scode='9000326' where sname='73.세트/DIY/3호/초코시트'; update sabang_net_goods set scode='9000028' where sname='G-3.단품/해피버스데이초'; update sabang_net_goods set scode='9000079' where sname='J-4.세트/초콜릿/알파벳'; update sabang_net_goods set scode='9000076' where sname='J-6.세트/초콜릿/타는놀이'; update sabang_net_goods set scode='9999999' where sname='Z-2.단품/아이스박스/중소'; update sabang_net_goods set scode='9999999' where sname='단품/케익상자&받침(미니)'; update sabang_net_goods set scode='9000014' where sname='단품/초코펜/화이트/20g'; update sabang_net_goods set scode='9000135' where sname='K-6.단품/몰드/타는놀이'; update sabang_net_goods set scode='9999999' where sname='@모음/22종/V떡케이크'; update sabang_net_goods set scode='9000255' where sname='$세트/S/떡케이크A/꽃20'; update sabang_net_goods set scode='9000253' where sname='$세트/S/떡케이크C/꽃12'; update sabang_net_goods set scode='9000258' where sname='$세트/S/떡케이크D/꽃20'; update sabang_net_goods set scode='9999999' where sname='@모음/6종/초코펜/100g'; update sabang_net_goods set scode='9000247' where sname='$단품/S/떡케이크A'; update sabang_net_goods set scode='9999999' where sname='$세트/V/떡케이크A/꽃12'; update sabang_net_goods set scode='9000249' where sname='$단품/S/떡케이크C'; update sabang_net_goods set scode='9000250' where sname='$단품/S/떡케이크D'; update sabang_net_goods set scode='9999999' where sname='$단품/V/떡케이크A'; update sabang_net_goods set scode='9999999' where sname='$단품/VIP/떡케이크A'; update sabang_net_goods set scode='9999999' where sname='$단품/VIP/떡케이크B'; update sabang_net_goods set scode='9999999' where sname='$단품/VIP/떡케이크C'; update sabang_net_goods set scode='9999999' where sname='$단품/리본거치대'; update sabang_net_goods set scode='9000161' where sname='$단품/메세지카드'; update sabang_net_goods set scode='9999999' where sname='$세트/V/떡케이크A/꽃20'; update sabang_net_goods set scode='9999999' where sname='$세트/V/떡케이크B/꽃20'; update sabang_net_goods set scode='9999999' where sname='$세트/V/떡케이크C/꽃20'; update sabang_net_goods set scode='9999999' where sname='$세트/V/떡케이크F/꽃12'; update sabang_net_goods set scode='9000143' where sname='18.세트/DIY/2호/딸기펜'; update sabang_net_goods set scode='9000042' where sname='B2.단품/초코시트/2호'; update sabang_net_goods set scode='9999999' where sname='C-2.화이트초코펜(100g)'; update sabang_net_goods set scode='9000021' where sname='C-3.밀싹초코펜(100g)'; update sabang_net_goods set scode='9000022' where sname='C-4.호박초코펜(100g)'; update sabang_net_goods set scode='9000023' where sname='C-5.딸기초코펜(100g)'; update sabang_net_goods set scode='9000005' where sname='F-3.단품/파스텔스타/8g'; update sabang_net_goods set scode='9999999' where sname='I-1.세트/초콜릿/3종/A'; update sabang_net_goods set scode='9000013' where sname='단품/초코펜/다크/20g'; update sabang_net_goods set scode='9000017' where sname='단품/초코펜/딸기/20g'; update sabang_net_goods set scode='9000018' where sname='단품/초코펜/자색/20g'; update sabang_net_goods set scode='9000029' where sname='F-1.단품/칼/소'; update sabang_net_goods set scode='9000030' where sname='F-2.단품/칼/중'; update sabang_net_goods set scode='9000025' where sname='F-7.단품/모양깍지6종'; update sabang_net_goods set scode='9000355' where sname='데코초(색상랜덤)'; update sabang_net_goods set scode='9000134' where sname='K-1.단품/몰드/동물'; update sabang_net_goods set scode='9000136' where sname='K-2.단품/몰드/과일'; update sabang_net_goods set scode='9000139' where sname='K-3.단품/몰드/꽃'; update sabang_net_goods set scode='9000355' where sname='단품/데코초'; update sabang_net_goods set scode='9000161' where sname='단품/메세지카드'; update sabang_net_goods set scode='9000197' where sname='단품/케이크돌림판'; update sabang_net_goods set scode='9000029' where sname='단품/칼(소/미니전용)'; update sabang_net_goods set scode='9000197' where sname='F-8.단품/케이크돌림판'; update sabang_net_goods set scode='9999999' where sname='다크초코펜20g'; update sabang_net_goods set scode='9000027' where sname='G-2.단품/아이러브유초'; update sabang_net_goods set scode='9000137' where sname='K-5.단품/몰드/한글'; update sabang_net_goods set scode='9000080' where sname='J-3.세트/초콜릿/꽃'; update sabang_net_goods set scode='9999999' where sname='I-2.세트/초콜릿/3종/B'; update sabang_net_goods set scode='9000011' where sname='H-2.단품/2호상자+받침'; update sabang_net_goods set scode='9000012' where sname='H-3.단품/3호상자+받침'; update sabang_net_goods set scode='9000103' where sname='세트/생일/미니초코데코'; update sabang_net_goods set scode='9999999' where sname='!7호/화과자10구'; update sabang_net_goods set scode='9000038' where sname='단품/바닐라시트/2호'; update sabang_net_goods set scode='9000099' where sname='세트/생일/미니'; update sabang_net_goods set scode='9999999' where sname='세트/생일/2호초코데코'; update sabang_net_goods set scode='9000033' where sname='단품/아이스박스/15kg'; update sabang_net_goods set scode='9999999' where sname='!모음/11종/화과자만주'; update sabang_net_goods set scode='9999999' where sname='$단품/V/떡케이크C'; update sabang_net_goods set scode='9000269' where sname='$단품/꽃12/리본(문구O)/거치대'; update sabang_net_goods set scode='9000268' where sname='$단품/꽃20(기본리본포장-문구X)'; update sabang_net_goods set scode='9000101' where sname='세트/생일/2호/다크펜'; update sabang_net_goods set scode='9000095' where sname='세트/DIY/미니'; update sabang_net_goods set scode='9000109' where sname='세트/DIY/2호초코데코/다크펜'; update sabang_net_goods set scode='9000279' where sname='세트/DIY/2호/다크펜'; update sabang_net_goods set scode='9000096' where sname='세트/DIY/1호'; update sabang_net_goods set scode='9000183' where sname='박스/초코시트/1호/30EA'; update sabang_net_goods set scode='9999999' where sname='모음/12종/단품/레드벨벳시트'; update sabang_net_goods set scode='9999999' where sname='단품/휘핑생크림/130g'; update sabang_net_goods set scode='9000016' where sname='단품/초코펜/호박/20g'; update sabang_net_goods set scode='9000015' where sname='단품/초코펜/밀싹/20g'; update sabang_net_goods set scode='9000019' where sname='단품/초코펜/다크/100g'; update sabang_net_goods set scode='9000032' where sname='단품/아이스박스중'; update sabang_net_goods set scode='9000031' where sname='단품/아이스박스소'; update sabang_net_goods set scode='9000035' where sname='단품/아이스박스25kg'; update sabang_net_goods set scode='9000027' where sname='단품/아이러브유초'; update sabang_net_goods set scode='9000036' where sname='단품/바닐라시트/미니'; update sabang_net_goods set scode='9000039' where sname='단품/바닐라시트/3호'; update sabang_net_goods set scode='9000196' where sname='C7.박스/레드벨벳시트/3호(20EA)'; update sabang_net_goods set scode='9000192' where sname='C5.박스/레드벨벳시트/1호(36EA)'; update sabang_net_goods set scode='9000366' where sname='C4.박스/레드벨벳시트/미니(36EA)'; update sabang_net_goods set scode='9999999' where sname='$세트/S/떡케이크A/꽃12/리본거치대/어버이날문구'; update sabang_net_goods set scode='9000263' where sname='$세트/S/떡케이크A/꽃20/리본거치대'; update sabang_net_goods set scode='9000257' where sname='$세트/S/떡케이크C/꽃20'; update sabang_net_goods set scode='9000236' where sname='$세트/V/떡케이크A/꽃12/사랑'; update sabang_net_goods set scode='9999999' where sname='$세트/V/떡케이크A/꽃12/어버이날문구'; update sabang_net_goods set scode='9000237' where sname='$세트/V/떡케이크A/꽃12/축하'; update sabang_net_goods set scode='9000229' where sname='$세트/V/떡케이크C/꽃12/감사'; update sabang_net_goods set scode='9000235' where sname='$세트/V/떡케이크A/꽃12/감사'; update sabang_net_goods set scode='9000120' where sname='@6호(진)/우리밀만주10화과자10'; update sabang_net_goods set scode='9000124' where sname='@10호(진)/우리밀만주10화과자20'; update sabang_net_goods set scode='9999999' where sname='86.세트/생일/미니초코데코/레드벨벳시트'; update sabang_net_goods set scode='9999999' where sname='65.세트/DIY/2호초코데코/다크펜/초코시트'; update sabang_net_goods set scode='9999999' where sname='$세트/S/떡케이크D/꽃12/리본거치대/어버이날문구'; update sabang_net_goods set scode='9999999' where sname='$세트/S/떡케이크D/꽃20/리본거치대/어버이날문구'; update sabang_net_goods set scode='9999999' where sname='$세트/V/떡케이크A/꽃12/리본거치대/감사/어버이날문구'; update sabang_net_goods set scode='9999999' where sname='$세트/V/떡케이크A/꽃12/리본거치대/어버이날문구'; update sabang_net_goods set scode='9999999' where sname='$세트/V/떡케이크A/꽃20/리본거치대/감사/어버이날문구'; update sabang_net_goods set scode='9999999' where sname='$세트/V/떡케이크A/꽃20/리본거치대/어버이날문구'; update sabang_net_goods set scode='9999999' where sname='$세트/V/떡케이크A/꽃20/축생일'; update sabang_net_goods set scode='9999999' where sname='$세트/V/떡케이크B/꽃12/리본거치대'; update sabang_net_goods set scode='9999999' where sname='$세트/V/떡케이크B/꽃12/리본거치대/어버이날문구'; update sabang_net_goods set scode='9999999' where sname='$세트/V/떡케이크B/꽃20/리본거치대'; update sabang_net_goods set scode='9999999' where sname='$세트/V/떡케이크C/꽃12/리본거치대/어버이날문구'; update sabang_net_goods set scode='9999999' where sname='$세트/V/떡케이크C/꽃12/어버이날문구'; update sabang_net_goods set scode='9999999' where sname='$세트/V/떡케이크C/꽃20/리본거치대/어버이날문구'; update sabang_net_goods set scode='9999999' where sname='117.세트/DIY/3호초코데코/레드벨벳시트'; update sabang_net_goods set scode='9999999' where sname='201.변경/초코시트'; update sabang_net_goods set scode='9999999' where sname='202.변경/레드벨벳시트'; update sabang_net_goods set scode='9999999' where sname='97.세트/DIY/2호/다크펜/레드벨벳시트'; update sabang_net_goods set scode='9000361' where sname='!6호/만주10구화과자10구/아이스박스'; update sabang_net_goods set scode='9000333' where sname='46.세트/생일/미니초코데코/초코시트'; update sabang_net_goods set scode='9000339' where sname='54.세트/생일/1호초코데코/초코시트'; update sabang_net_goods set scode='9000351' where sname='78.세트/생일/3호초코데코/초코시트'; update sabang_net_goods set scode='9000259' where sname='$세트/S/떡케이크A/꽃12/리본거치대'; update sabang_net_goods set scode='9000265' where sname='$세트/S/떡케이크C/꽃20/리본거치대'; update sabang_net_goods set scode='9000263' where sname='$세트/V/떡케이크A/꽃20/리본거치대'; update sabang_net_goods set scode='9000261' where sname='$세트/V/떡케이크C/꽃12/리본거치대'; update sabang_net_goods set scode='9000359' where sname='!4호/화과자15/아이스박스포장'; update sabang_net_goods set scode='9000359' where sname='!4호/화과자15구/아이스박스포장'; update sabang_net_goods set scode='9000119' where sname='!5호/만주20구'; update sabang_net_goods set scode='9000360' where sname='!5호/만주20구/아이스박스포장'; update sabang_net_goods set scode='9000362' where sname='!7호/화과자20구/아이스박스포장'; update sabang_net_goods set scode='9999999' where sname='114.세트/생일/3호/레드벨벳시트'; update sabang_net_goods set scode='9000122' where sname='!8호/만주30구'; update sabang_net_goods set scode='9000363' where sname='!8호/만주30구/아이스박스포장'; update sabang_net_goods set scode='9000161' where sname='!단품/메세지카드'; update sabang_net_goods set scode='9999999' where sname='@모음/19종/S떡케이크'; update sabang_net_goods set scode='9000197' where sname='케이크돌림판'; update sabang_net_goods set scode='9999999' where sname='아이스박스(15kg)+아이스팩'; update sabang_net_goods set scode='9000332' where sname='세트/생일/미니/초코시트'; update sabang_net_goods set scode='9999999' where sname='세트/생일/2호/레드벨벳시트'; update sabang_net_goods set scode='9000326' where sname='세트/DIY/3호/초코시트'; update sabang_net_goods set scode='9999999' where sname='생일2호초코데코세트/초코시트'; update sabang_net_goods set scode='9999999' where sname='바닐라미니케이크시트'; update sabang_net_goods set scode='9000015' where sname='M-3.단품/초코펜/밀싹/20g'; update sabang_net_goods set scode='9000315' where sname='13.세트/DIY/1호초코데코/초코시트'; update sabang_net_goods set scode='9000327' where sname='13.세트/DIY/3호초코데코/초코시트'; update sabang_net_goods set scode='9000198' where sname='59.세트/생일/2호/다크펜/초코시트'; update sabang_net_goods set scode='9999999' where sname='모음/40종/단품/케이크/종합'; update sabang_net_goods set scode='9000343' where sname='25.세트/생일/2호초코데코/다크펜'; update sabang_net_goods set scode='9000145' where sname='28.세트/생일/2호초코데코/딸기펜'; update sabang_net_goods set scode='9000196' where sname='A15.박스/레드벨벳시트/3호(20EA)'; update sabang_net_goods set scode='9999999' where sname='82.세트/생일/미니/레드벨벳시트'; update sabang_net_goods set scode='9000109' where sname='25.세트/DIY/2호초코데코/다크펜'; update sabang_net_goods set scode='9999999' where sname='90.세트/생일/1호/레드벨벳시트'; update sabang_net_goods set scode='9999999' where sname='$세트/V/떡케이크A/꽃12/축생일'; update sabang_net_goods set scode='9000141' where sname='N-1.단품/초콜릿비닐(대)/12장'; update sabang_net_goods set scode='9999999' where sname='모음/150종/세트/케이크/종합'; update sabang_net_goods set scode='9000181' where sname='B4.박스/초코시트/미니(36EA)'; update sabang_net_goods set scode='9000182' where sname='B4.박스/초코시트/미니(45EA)'; update sabang_net_goods set scode='9999999' where sname='Z-3.단품/아이스박스/15kg소'; update sabang_net_goods set scode='9999999' where sname='$단품/VIP/떡케이크A/축칠순'; update sabang_net_goods set scode='9000257' where sname='$세트/S/떡케이크C/꽃다발20'; update sabang_net_goods set scode='9000183' where sname='B5.박스/초코시트/1호(30EA)'; update sabang_net_goods set scode='9000186' where sname='B6.박스/초코시트/2호(25EA)'; update sabang_net_goods set scode='9999999' where sname='C-6.자색고구마초코펜(100g)'; update sabang_net_goods set scode='9999999' where sname='Z-1.단품/아이스박스/소15kg'; update sabang_net_goods set scode='9999999' where sname='Z-3.단품/아이스박스/15kg중'; update sabang_net_goods set scode='9000021' where sname='L-3.단품/초코펜/밀싹/100g'; update sabang_net_goods set scode='9000022' where sname='L-4.단품/초코펜/호박/100g'; update sabang_net_goods set scode='9000024' where sname='L-6.단품/초코펜/자색/100g'; update sabang_net_goods set scode='9000102' where sname='34.세트/생일/3호'; update sabang_net_goods set scode='9000199' where sname='49.세트/DIY/1호/초코시트'; update sabang_net_goods set scode='9000098' where sname='13.세트/DIY/1호초코데코'; update sabang_net_goods set scode='9000100' where sname='10.세트/생일/1호'; update sabang_net_goods set scode='9000044' where sname='C0.단품/레드벨벳시트/미니'; update sabang_net_goods set scode='9000308' where sname='1.세트/DIY/미니/초코시트'; update sabang_net_goods set scode='9999999' where sname='Z-1.단품/아이스박스/소중'; update sabang_net_goods set scode='9999999' where sname='$세트/V/떡케이크C/꽃12'; update sabang_net_goods set scode='9000045' where sname='C1.단품/레드벨벳시트/1호'; update sabang_net_goods set scode='9000046' where sname='C2.단품/레드벨벳시트/2호'; update sabang_net_goods set scode='9000047' where sname='C3.단품/레드벨벳시트/3호'; update sabang_net_goods set scode='9999999' where sname='모음/12종/단품/초코시트'; update sabang_net_goods set scode='9999999' where sname='$단품/V/떡케이크C/(단품)'; update sabang_net_goods set scode='9000110' where sname='37.세트/DIY/3호초코데코'; update sabang_net_goods set scode='9000106' where sname='38.세트/생일/3호초코데코'; update sabang_net_goods set scode='9000110' where sname='41.세트/DIY/3호초코데코'; update sabang_net_goods set scode='9000277' where sname='5.세트/DIY/미니초코데코'; update sabang_net_goods set scode='9000103' where sname='6.세트/생일/미니초코데코'; update sabang_net_goods set scode='9000326' where sname='73.세트/DIY/3호/초코시트'; update sabang_net_goods set scode='9000028' where sname='G-3.단품/해피버스데이초'; update sabang_net_goods set scode='9000079' where sname='J-4.세트/초콜릿/알파벳'; update sabang_net_goods set scode='9000076' where sname='J-6.세트/초콜릿/타는놀이'; update sabang_net_goods set scode='9999999' where sname='Z-2.단품/아이스박스/중소'; update sabang_net_goods set scode='9999999' where sname='단품/케익상자&받침(미니)'; update sabang_net_goods set scode='9000014' where sname='단품/초코펜/화이트/20g'; update sabang_net_goods set scode='9000135' where sname='K-6.단품/몰드/타는놀이'; update sabang_net_goods set scode='9999999' where sname='@모음/22종/V떡케이크'; use DB_mcakecms; drop table Table_Gaebyul_Juso; create table if not exists Table_Gaebyul_Juso ( gaebyul_order_no char(11) NOT NULL COMMENT '주문번호', gaebyul_order_sequ char(4) NOT NULL COMMENT '주문번호별 일련번호', gaebyul_reg_day datetime NOT NULL COMMENT '등록일자/시각', gaebyul_reg_id text NOT NULL COMMENT '등록 ID', gaebyul_recman text NOT NULL COMMENT '수취인', gaebyul_postno char(5) NOT NULL COMMENT '수취 우편번호', gaebyul_addr text NOT NULL COMMENT '수취 주소'); select * from Table_Gaebyul_Juso; use DB_mcakecms; select * from mcake_am_user; select * from mcake_category; select count(*) from mcake_cm_cart_ord; select * from mcake_cm_cart_temp; select count(*) from mcake_cm_user; select * from mcake_dash_temp; select * from mcake_inventory; select * from mcake_ord_upload_tmp; select count(*) from mcake_order_list; select count(*) from mcake_product; select * from mcake_workboard; select * from Table_Consulting; select * from Table_Halil; select count(*) from table_log; ALTER TABLE mcake_am_user IMPORT TABLESPACE; ALTER TABLE mcake_category IMPORT TABLESPACE; ALTER TABLE mcake_cm_cart_ord IMPORT TABLESPACE; ALTER TABLE mcake_cm_cart_temp IMPORT TABLESPACE; ALTER TABLE mcake_cm_user IMPORT TABLESPACE; ALTER TABLE mcake_dash_temp IMPORT TABLESPACE; ALTER TABLE mcake_inventory IMPORT TABLESPACE; ALTER TABLE mcake_ord_upload_tmp IMPORT TABLESPACE; ALTER TABLE mcake_order_list IMPORT TABLESPACE; ALTER TABLE mcake_product IMPORT TABLESPACE; ALTER TABLE mcake_workboard IMPORT TABLESPACE; ALTER TABLE Table_Consulting IMPORT TABLESPACE; ALTER TABLE Table_Halil IMPORT TABLESPACE; ALTER TABLE table_log IMPORT TABLESPACE; ALTER TABLE mcake_category DISCARD TABLESPACE; ALTER TABLE mcake_cm_cart_ord DISCARD TABLESPACE; ALTER TABLE mcake_cm_cart_temp DISCARD TABLESPACE; ALTER TABLE mcake_cm_user DISCARD TABLESPACE; ALTER TABLE mcake_dash_temp DISCARD TABLESPACE; ALTER TABLE mcake_inventory DISCARD TABLESPACE; ALTER TABLE mcake_ord_upload_tmp DISCARD TABLESPACE; ALTER TABLE mcake_order_list DISCARD TABLESPACE; ALTER TABLE mcake_product DISCARD TABLESPACE; ALTER TABLE mcake_workboard DISCARD TABLESPACE; ALTER TABLE Table_Consulting DISCARD TABLESPACE; ALTER TABLE Table_Halil DISCARD TABLESPACE; ALTER TABLE table_log DISCARD TABLESPACE; use DB_mcakecms; drop table mcake_am_user; CREATE TABLE `mcake_am_user` ( `au_id` text COMMENT '사용자아이디', `au_name` text COMMENT '사용자명', `au_lv` char(1) COMMENT '권한 8:관리자 9:개발자', `au_stat` char(1) COMMENT '계좌상태 0:비밀번호 초기등록요망 1:정상', `au_memo` text COMMENT '메모', `au_regtm` datetime COMMENT '최초등록일', `au_chgtm` datetime COMMENT '최종수정일', `au_logtm` datetime COMMENT '최종접속일', `au_corrcnt` int(3) COMMENT '비밀번호오류회수', `au_ipsa` char(8) COMMENT '입사일자-초기등록비밀번호', `au_pass` text COMMENT '사용자비밀번호'); insert into mcake_am_user(au_id,au_lv,au_name,au_pass,au_memo,au_regtm,au_corrcnt,au_stat,au_ipsa)values("관리자","9","박석규","665081ea948418b5b16ff11af55f81e3","개발자", "2024-06-01 05:00:00",0,'1','20240601'); select * from mcake_am_user; update mcake_am_user set au_corrcnt=0 where au_id="관리자"; select * from mcake_am_user; use DB_mcakecms; drop table mcake_category; CREATE TABLE `mcake_category` ( `no` int(11) NOT NULL, `cate_code` char(4) NOT NULL COMMENT '카테고리코드', `cate_name` text NOT NULL COMMENT '카테고리이름', `cate_sort` int(5) NOT NULL COMMENT '카테고리 sort 순서', `cate_yn` char(1) NOT NULL COMMENT '사용유무Y/N', `cate_sdtm` datetime NOT NULL COMMENT '등록이라', `cate_edtm` datetime NOT NULL COMMENT '변경일자', `cate_memo` text NOT NULL COMMENT '메모', `member` text NOT NULL COMMENT '등록직원'); ALTER TABLE `mcake_category` ADD PRIMARY KEY (`no`); ALTER TABLE `mcake_category` MODIFY `no` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1; select * from mcake_category; INSERT INTO `mcake_category` (`no`, `cate_code`, `cate_name`, `cate_sort`, `cate_yn`, `cate_sdtm`, `cate_edtm`, `cate_memo`, `member`)VALUES (1, '1001', '4. 크리스마스',4, 'Y', '2021-11-15 08:55:37', '2023-10-17 16:33:36','','관리자계정'), (2, '1002', '10. 초콜릿',10, 'Y', '2021-11-15 08:56:06', '2023-04-07 09:03:56','', '관리자계정'), (3, '1003', '5. DIY',5, 'Y', '2021-11-15 08:56:47', '2023-10-17 16:33:49','', '관리자계정'), (4, '1004', '6. 생일',6, 'Y', '2021-11-15 08:56:53', '2023-10-17 16:33:54','', '관리자계정'), (5, '1005', '7. 어버이날',7, 'Y', '2021-11-15 08:56:59', '2023-10-17 16:33:59','', '관리자계정'), (6, '1006', '15. 구성품',15, 'Y', '2021-11-15 08:57:05', '2023-04-07 09:04:02','', '관리자계정'), (14, '1007', '99. 카테고리없음',99, 'Y', '2021-11-16 09:55:53', '2021-11-16 09:55:53','', '관리자계정'), (8, '1008', '20. 화과자만주',20, 'Y', '2022-01-17 15:40:57', '2023-04-07 09:04:07','', 'made_sr'), (9, '1009', '9. 박스상품(시트)',9, 'Y', '2022-11-30 14:31:24', '2023-04-07 09:03:46','', 'admin'), (10, '1010', '26. V 떡케이크',26, 'Y', '2023-01-02 13:40:33', '2023-04-07 09:04:27','', 'made_sr'), (11, '1011', '25. S 떡케이크',25, 'Y', '2023-01-18 14:15:52', '2023-04-07 09:04:18','', 'made_sr'), (12, '1012', '1. 크리스마스(NEW)',1, 'Y', '2023-10-17 16:01:31', '2023-10-17 16:34:04','', 'made_sr'), (13, '1013', '2. DIY(NEW)',2, 'Y', '2023-10-17 16:01:58', '2023-10-17 16:34:08','', 'made_sr'), (7, '1014', '3. 생일(NEW)',3, 'Y', '2023-10-17 16:02:05', '2023-10-17 16:34:12','', 'made_sr'); select * from mcake_category; use DB_mcakecms; drop table mcake_product; CREATE TABLE `mcake_product` ( `no` int(11) NOT NULL, `prod_code` char(7) NOT NULL, `prod_name` text NOT NULL, `prod_img` text NOT NULL, `prod_price` int(11) NOT NULL COMMENT '가격', `prod_memo` text NOT NULL, `cate_code` char(4) NOT NULL, `prod_uh` char(3) NOT NULL, `prod_set` text NOT NULL, `prod_yn` char(1) NOT NULL, `prod_sdtm` datetime NOT NULL, `prod_edtm` datetime NOT NULL, `prod_id_name` text , `prod_mno` text DEFAULT NULL COMMENT '모델no매핑'); ALTER TABLE `mcake_product` ADD PRIMARY KEY (`no`); ALTER TABLE `mcake_product` MODIFY `no` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1; select * from mcake_product; --------------------------------------------------------------------------------------------------- use DB_mcakecms; drop table mcake_cm_cart_temp; CREATE TABLE `mcake_cm_cart_temp` ( `no` int(11) NOT NULL, `temp_no` char(23) NOT NULL, `temp_prod_cate` char(4) NOT NULL, `temp_prod_code` char(7) NOT NULL, `temp_prod_name` text NOT NULL, `temp_prod_sv` char(1) NOT NULL, `temp_prod_uh` text NOT NULL, `temp_prod_set` text NOT NULL, `temp_prod_price` int(11) NOT NULL, `temp_unit_cd` int(5) NOT NULL, `temp_au_id` text NOT NULL); ALTER TABLE `mcake_cm_cart_temp` ADD PRIMARY KEY (`no`); ALTER TABLE `mcake_cm_cart_temp` MODIFY `no` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1; select * from mcake_cm_cart_temp; use DB_mcakecms; drop table mcake_cm_cart_ord; ----------->사용하지 마세요 프로그램 이용 CREATE TABLE `mcake_cm_cart_ord` ( `no` int(11) NOT NULL, `order_no` char(11) NOT NULL, `order_prod_cate` char(4) NOT NULL, `order_prod_code` char(7) NOT NULL, `order_prod_name` text NOT NULL, `order_prod_sv` char(1) NOT NULL, `order_prod_uh` text NOT NULL, `order_prod_set` text NOT NULL, `order_prod_price` int(11) NOT NULL, `order_unit_cd` int(5) NOT NULL, `order_cu_code` char(6) NOT NULL, `order_cc_sdtm` datetime NOT NULL, `order_cc_state` varchar(10) NOT NULL, `order_delivery_state` char(3) NOT NULL DEFAULT 100, `order_au_id` varchar(50) NOT NULL COMMENT '취급자아이디', `order_cart_yn` char(1) NOT NULL, `edit_adminid` varchar(20) NOT NULL); ALTER TABLE `mcake_cm_cart_ord` ADD PRIMARY KEY (`no`), ADD KEY `order_no` (`order_no`); ALTER TABLE `mcake_cm_cart_ord` MODIFY `no` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1; select * from mcake_cm_cart_ord; select count(*) from mcake_cm_cart_ord; use DB_mcakecms; drop table mcake_order_list; ----------->사용하지 마세요 프로그램 이용 CREATE TABLE `mcake_order_list` ( `no` int(11) NOT NULL, `list_order_no` char(11) NOT NULL, `list_order_cu_code` char(6) NOT NULL, `list_order_cu_name` text NOT NULL, `list_order_cu_hp` char(13) NOT NULL, `list_order_cu_tel` varchar(20) NOT NULL, `list_order_cu_postno` char(5) NOT NULL, `list_order_cu_delivery_full_addr` text NOT NULL COMMENT '실제 배송지 Full 주소', `list_order_prod_idxname` text NOT NULL, `list_order_pkg` varchar(10) NOT NULL, `list_prod_idxcode` char(7) NOT NULL, `list_index_unit_cd` varchar(20) NOT NULL, `list_order_prod_t_price` int(11) NOT NULL, `list_order_pay` varchar(20) NOT NULL, `list_order_pay_yn` char(1) NOT NULL, `list_order_pay_day` datetime NOT NULL, `list_order_livepay_day` char(10) NOT NULL, `list_order_pay_admin` varchar(20) NOT NULL, `list_order_dtm` datetime NOT NULL, `list_order_hp_day` date NOT NULL COMMENT '행사일', `list_order_do_day` date NOT NULL COMMENT '도착일', `list_delivery_state` char(3) NOT NULL COMMENT '배송방법코드 100:미정 200:택배...', `list_order_state` char(2) NOT NULL COMMENT '원장상태 10:접수 11:대기 12:송장 13:보류 14:예약 50:출고 40:주문취소', `list_order_state_dtm` datetime NOT NULL COMMENT '원장수정하면 여기에 now() 일자 들어온다', `list_order_memo` text NOT NULL, `list_order_admemo` text NOT NULL, `list_order_member` varchar(50) NOT NULL, `data_busin_detailed` int(3) NOT NULL COMMENT '명세서', `data_busin_estimate` int(3) NOT NULL COMMENT '견적서', `data_busin_consent` int(3) NOT NULL COMMENT '승낙서', `data_busin_bill` int(3) NOT NULL DEFAULT '1' COMMENT '계산서', `list_order_group` varchar(100) DEFAULT NULL, `list_order_email_send` char(1) COMMENT 'email 송신여부', `list_order_email_pdf_name` text COMMENT '견적서 pdf 파일 이름', `list_order_kakao_send` char(1) COMMENT '카카오 알림톡 여부', `list_order_kakao_relt` char(1) COMMENT '카카오 발송 결과 0:정상 1:불능 2:해당없음', `list_order_kakao_bjan` int(11) COMMENT '알림톡 충전 취급전 잔액', `list_order_kakao_ajan` int(11) COMMENT '알림톡 충전 취급후 잔액', `list_order_yeyak_date` char(10) COMMENT '예약발송일자', `list_order_unsongjang` char(14) COMMENT '운송장번호', `list_order_platform` text COMMENT '매출 벙법(당사/플랫폼..'); ALTER TABLE `mcake_order_list` ADD PRIMARY KEY (`no`),ADD KEY `list_order_no` (`list_order_no`); ALTER TABLE `mcake_order_list` MODIFY `no` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10169; select * from mcake_order_list where list_order_no like "240807%"; select * from mcake_order_list; use DB_mcakecms; drop table mcake_workboard; ----------->사용하지 마세요 프로그램 이용 CREATE TABLE `mcake_workboard` ( `no` int(11) NOT NULL, `wb_cate` varchar(30) NOT NULL COMMENT '카테고리명', `wb_order_code` char(11) NOT NULL COMMENT '주문코드', `wb_contents` text NOT NULL COMMENT '요청내용', `wb_state` char(2) NOT NULL COMMENT '요청상태 10:요청 11:확인 20:완료', `wb_user_w` text NOT NULL COMMENT '등록자', `wb_user_ok` text NOT NULL COMMENT '처리자', `wb_sdtm` datetime NOT NULL COMMENT '최초등록일', `wb_edtm` datetime NOT NULL COMMENT '최종수정일 초기값:2024-01-01'); ALTER TABLE `mcake_workboard` ADD PRIMARY KEY (`no`),ADD KEY `wb_order_code` (`wb_order_code`); ALTER TABLE `mcake_workboard` MODIFY `no` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1; select * from mcake_workboard; --------------------------------------------------------------------------------------------------- use DB_mcakecms; drop table mcake_cm_user; ----------->사용하지 마세요 프로그램 이용 CREATE TABLE `mcake_cm_user` ( `no` int(11) NOT NULL COMMENT '일련번호', `cu_code` varchar(10) NOT NULL COMMENT '고유코드', `cu_name` text NOT NULL COMMENT '상호명(성명)', `cu_hp` char(13) NOT NULL COMMENT '휴대폰', `cu_tel` varchar(20) NOT NULL COMMENT '기타번호', `cu_email` varchar(100) NOT NULL COMMENT '이메일', `cu_location` varchar(255) NOT NULL COMMENT '지역', `cu_extraddr` text NOT NULL COMMENT '도로중간주소', `cu_addr` varchar(100) NOT NULL COMMENT '상세주소', `cu_addr_full` text NOT NULL COMMENT '주소(배송지)', `cu_postno` char(5) NOT NULL COMMENT '우편번호', `cu_memo` text NOT NULL COMMENT '메모', `cu_sdtm` datetime NOT NULL COMMENT '최초등록일', `cu_edtm` datetime NOT NULL COMMENT '', `cu_odtm` datetime NOT NULL COMMENT '최종수정일', `member` varchar(50) NOT NULL COMMENT '등록자로그용', `busin_com_nm` varchar(100) NOT NULL COMMENT '사업장이름', `busin_no` varchar(20) NOT NULL COMMENT '사업자번호', `corp_no` varchar(20) NOT NULL COMMENT '법인번호', `repre_nm` varchar(100) NOT NULL COMMENT '대표자명', `plbu_add` varchar(255) NOT NULL COMMENT '사업장주소', `add_hest` varchar(255) NOT NULL COMMENT '본점주소', `busin_state_txt` varchar(100) NOT NULL COMMENT '업태', `busin_tp_txt` varchar(100) NOT NULL COMMENT '업종', `data_busin_image` varchar(255) NOT NULL COMMENT '사업자사본', `xxxxxxxxxxxxmage` char(1) NOT NULL COMMENT '생성원인 1:당사 2:플랫폼', `cu_consulting` char(1) NOT NULL COMMENT '상담여부(Y/N'); ALTER TABLE `mcake_cm_user` ADD PRIMARY KEY (`no`), ADD KEY `cu_code` (`cu_code`); ALTER TABLE `mcake_cm_user` MODIFY `no` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8713; select cu_addr_full from mcake_cm_user where cu_location LIKE "[%"; select cu_postno,cu_addr_full from mcake_cm_user where cu_postno LIKE "xxxx%"; select * from mcake_cm_user where cu_code="103400"; select * from mcake_cm_user where cu_name="박석규"; select * from mcake_cm_user where cu_postno=""; use DB_mcakecms; drop table mcake_inventory; CREATE TABLE `mcake_inventory` ( `no` int(11) NOT NULL, `inventory_code` char(7) NOT NULL, `inventory_name` text NOT NULL, `inventory_section_1` int(11) NOT NULL COMMENT '대창', `inventory_section_2` int(11) NOT NULL COMMENT '공장', `inventory_section_3` int(11) NOT NULL COMMENT '창고', `inventory_section_4` int(11) NOT NULL COMMENT '관리계획'); ALTER TABLE `mcake_inventory`ADD PRIMARY KEY (`no`); ALTER TABLE `mcake_inventory` MODIFY `no` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=122; select * from mcake_inventory; INSERT INTO `mcake_inventory` (`no`, `inventory_code`, `inventory_name`, `inventory_section_1`, `inventory_section_2`, `inventory_section_3`, `inventory_section_4`) VALUES (1, '9000036', '36. 바닐라시트 미니',0,0,0,0), (2, '9000037', '37. 바닐라시트 1호',0,0,0, 0), (3, '9000038', '38. 바닐라시트 2호',0,0,0,0), (4, '9000039', '39. 바닐라시트 3호',0,0,0,0), (5, '9000001', '1. 생크림 80g',0,0,0,0), (6, '9000002', '2. 생크림 130g',0,0,0,0), (89, '9000003', '3. 딸기생크림 80g',0,0,0,0), (90, '9000072', '4. 별쿠키',0,0,0,0), (91, '9000005', '5. 파스텔스타 8g',0,0,0,0), (104, '9000280', '단품/빈5종+곰돌이',0,0,0,0), (105, '9000281', '단품/빈5종+곰돌이+선물',0,0,0,0), (106, '9000006', 'ZAA0060 단품/빈5종+장미',0,0,0,0), (107, '9000007', 'ZAA0061 단품/빈5종+장미+포도',0,0,0,0), (108, '9000013', 'ZAA0046 단품/초코펜 / 다크 / 20g',0,0,0,0), (109, '9000017', 'ZAA0050 단품/초코펜 / 딸기 / 20g',0,0,0,0), (110, '9000040', 'ZAA0029 단품/초코시트 / 미니',0,0,0,0), (111, '9000041', 'ZAA0030 단품/초코시트 / 1호',0,0,0,0), (112, '9000042', 'ZAA0031 단품/초코시트 / 2호', 0,0,0,0), (113, '9000043', 'ZAA0032 단품/초코시트 / 3호',0,0,0, 0), (114, '9000044', 'ZAA0033 단품/레드벨벳시트 / 미니',0,0,0,0), (115, '9000045', 'ZAA0034 단품/레드벨벳시트 / 1호',0,0,0,0), (116, '9000046', 'ZAA0035 단품/레드벨벳시트 / 2호',0,0,0,0), (117, '9000047', 'ZAA0036 단품/레드벨벳시트 / 3호',0,0,0,0), (118, '9000009', 'ZAA0063 단품/미니 상자+받침',0,0,0,0), (119, '9000010', 'ZAA0064 단품/1호 상자+받침',0,0,0,0), (120, '9000011', 'ZAA0065 단품/2호 상자+받침',0,0,0,0), (121, '9000012', 'ZAA0066 단품/3호 상자+받침', 0,0,0,0); select * from mcake_inventory; use DB_mcakecms; drop table mcake_dash_temp; CREATE TABLE `mcake_dash_temp` ( `no` int(11) NOT NULL, `dash_prod_code` varchar(20) NOT NULL, `dash_prod_name` varchar(50) NOT NULL, `dash_prod_ea` varchar(10) NOT NULL, `dash_member_id` varchar(20) NOT NULL); ALTER TABLE `mcake_dash_temp` ADD PRIMARY KEY (`no`); ALTER TABLE `mcake_dash_temp` MODIFY `no` int(11) NOT NULL AUTO_INCREMENT; select * from mcake_dash_temp; use DB_mcakecms; drop table Table_Log; create table if not exists Table_Log ( ldatetime datetime NOT NULL COMMENT '거래일자/시간', ltxname text NOT NULL COMMENT '거래명', ltxid text NOT NULL COMMENT '거래 ID', lrelt text NOT NULL COMMENT '거래결과', ltxip text NOT NULL COMMENT '거래 IP', lprog text NOT NULL COMMENT 'Log 프로그램', ldata text NOT NULL COMMENT '거래별 자료'); .자동로그인-.../index.php .로그인-.../proc/login_process.php .로그아웃-.../proc/logout_process.php .비밀번호 초기등록-.../proc/login_password_reg.php(정상처리부분) .(비밀번호)초기등록-log.php(입력오류부분) .사원정보변경-.../page_au/edit.php .사원해지-.../page_au/del.php .사원등록-.../page_au/insert_member.php .체크-일괄완료-.../page_board/check_action.php .요청상태변경-.../page_board/insert.php .배송방법변경-미정-.../page_ord/check_action.php .배송방법변경-택배-.../page_ord/check_action.php .배송방법변경-화물-.../page_ord/check_action.php .배송방법변경-직배-.../page_ord/check_action.php .배송방법변경-그룹지정-.../page_ord/check_action.php .주문상태변경-접수-.../page_ord/check_action.php .주문상태변경-대기-.../page_ord/check_action.php .주문상태변경-송장-.../page_ord/check_action.php .주문상태변경-보류-.../page_ord/check_action.php .주문상태변경-출고-.../page_ord/check_action.php .주문상태변경-주문취소-.../page_ord/check_action.php .체크송장양식 엑셀출력-.../page_ord/check_action.php .전체보고양식 엑셀출력-.../page_ord/check_action.php .입금확인 요청-.../page_ord/insert.php .../page_ord_cs/insert.php .../page_ord_cs2/insert.php .주문요청사항신청-.../page_ord/insert.php .../page_ord_cs/insert.php .../page_ord_cs2/insert.php .사업자정보등록-.../page_ord/insert.php .../page_ord_cs/insert.php .../page_ord_cs2/insert.php .고객정보변경요청-.../page_ord/insert.php .../page_ord_cs/insert.php .../page_ord_cs2/insert.php .상품정보변경요청-.../page_ord/insert.php .../page_ord_cs2/insert.php .명.견.승.계-.../page_ord_cs2/check_action.php .비밀번호변경-.../page_au/edit_proc.php .재고등록용 상품등록-.../page_au/inventory_set_item.php .재고등록-.../page_au/inventory_set_item.php .재고등록상품목록 삭제-.../page_au/inventory_set_item.php .카테고리삭제-.../page_cate/insert.php .카테고리신규-.../page_cate/insert.php .카테고리변경-.../page_cate/insert.php .상품등록-.../page_prod/insert.php .상품변경-.../page_prod/insert.php .상품삭제-.../page_prod/insert.php .카테고리연결-.../page_prod/insert.php .상품목록 엑셀출력-.../page_prod/excel.php .카테고리 엑셀출력-.../page_cate/excel.php .오늘의할일 등록-.../proc/insert_halil.php .오늘의할일 변경-.../proc/today_to_do_del.php .오늘의할일 삭제-.../proc/today_to_do_del.php .오늘의할일 처리일 등록-.../proc/today_to_do_del.php .상담등록-.../common/insert_consult.php .운송장결과업로드-.../page_ord/unsongjang_relt_upload.php .개별판매-.../page_cart_ord/page_cart2.php .고객신규등록-.../page_cu/insert.php .고객삭제-.../page_cu/insert.php .고객정보변경-.../page_cu/insert.php .운송장번호 업로드-.../page_ord/unsongjan_excel_upload.php .개별발송자료업로드-.../page_cart_ord/gaebyul_excel_upload.php use DB_mcakecms; drop table mcake_ord_upload_tmp; CREATE TABLE `mcake_ord_upload_tmp` ( `no_tmp` int(11) NOT NULL, `up_time_code` varchar(50) NOT NULL, `up_time_id` varchar(50) NOT NULL, `up_name_tmp` varchar(100) NOT NULL COMMENT '[2]수취인명', `up_pnum1_tmp` varchar(20) NOT NULL COMMENT '[3]수취인번호1', `up_pnum2_tmp` varchar(20) NOT NULL COMMENT '[4]수취인번호2', `up_ea_tmp` varchar(10) NOT NULL COMMENT '[7]수량', `up_add_tmp` varchar(255) NOT NULL COMMENT '[8]수취인주소', `up_memo_tmp` varchar(255) NOT NULL COMMENT '[9]배송메모', `up_shop_tmp` varchar(50) NOT NULL COMMENT '[14]쇼핑몰', `up_mno_tmp` varchar(10) NOT NULL COMMENT '[21]모델NO', `up_doday_tmp` varchar(20) NOT NULL COMMENT '도착일', `up_hpday_tmp` varchar(20) NOT NULL COMMENT '행사일', `up_pay_tmp` varchar(20) NOT NULL COMMENT '결제방법', `up_payok_tmp` varchar(20) NOT NULL COMMENT '결제유무'); use DB_mcakecms; drop table Table_Consulting; create table if not exists Table_Consulting ( `no` int(11) NOT NULL COMMENT '일련번호', `con_cu_code` varchar(10) NOT NULL COMMENT '고객 고유번호', `con_list_order_no` char(11) NOT NULL COMMENT '판매 고유번호', `con_date` datetime NOT NULL COMMENT '거래일자/시간', `con_id` text NOT NULL COMMENT '상담직원', `con_sequ` int(5) NOT NULL COMMENT '고객별 상담 일련번호', `con_msg` text NOT NULL COMMENT '상담내용'); ALTER TABLE `Table_Consulting` ADD PRIMARY KEY (`no`); ALTER TABLE `Table_Consulting` MODIFY `no` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1; select * from Table_Consulting; use DB_mcakecms; drop table sabang_net_goods; create table if not exists sabang_net_goods ( `no` int(11) NOT NULL COMMENT '일련번호', `sname` text NOT NULL COMMENT '사방넷 상품약어', `scode` char(7) NOT NULL COMMENT 'cms 상품코드', `model` text NOT NULL COMMENT '사방넷에서 주는 모델명', `pcode` text NOT NULL COMMENT '사방넷에서 주는 모델명에 의한 상품코드'); ALTER TABLE `sabang_net_goods` ADD PRIMARY KEY (`no`); ALTER TABLE `sabang_net_goods` MODIFY `no` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1; select * from sabang_net_goods where scode="" order by sname; select * from sabang_net_goods order by scode; ALTER TABLE sabang_net_goods DROP COLUMN scont; <----컬럼 삭제 ALTER TABLE sabang_net_goods ADD model text AFTER scode; update sabang_net_goods set model=''; ALTER TABLE sabang_net_goods ADD pcode text AFTER model; update sabang_net_goods set pcode=''; update sabang_net_goods set scode='9000124' where sname='!10호/만주10구화과자20구'; update sabang_net_goods set scode='9000123' where sname='!9호/만주20구화과자10구'; update sabang_net_goods set scode='9000254' where sname='$세트/S/떡케이크D/꽃12'; update sabang_net_goods set scode='9000308' where sname='41.세트/DIY/미니/초코시트'; update sabang_net_goods set scode='9000350' where sname='74.세트/생일/3호/초코시트'; update sabang_net_goods set scode='9000036' where sname='A0.단품/바닐라시트/미니'; update sabang_net_goods set scode='9000037' where sname='A1.단품/바닐라시트/1호'; update sabang_net_goods set scode='9000040' where sname='B0.단품/초코시트/미니'; update sabang_net_goods set scode='9000041' where sname='B1.단품/초코시트/1호'; update sabang_net_goods set scode='9000043' where sname='B3.단품/초코시트/3호'; update sabang_net_goods set scode='9000001' where sname='D-1.단품/생크림/80g'; update sabang_net_goods set scode='9000002' where sname='D-2.단품/생크림/130g'; update sabang_net_goods set scode='9000003' where sname='D-3.단품/딸기생크림/80g'; update sabang_net_goods set scode='9000014' where sname='M-2.단품/초코펜/화이트/20g'; update sabang_net_goods set scode='9000031' where sname='Z-1.단품/아이스박스/소'; update sabang_net_goods set scode='9000033' where sname='Z-3.단품/아이스박스/15kg'; update sabang_net_goods set scode='9000032' where sname='Z-2.단품/아이스박스/중'; update sabang_net_goods set scode='9000125' where sname='!11호/화과자30구'; update sabang_net_goods set scode='9000120' where sname='!6호/만주10구화과자10구'; update sabang_net_goods set scode='9000099' where sname='2.세트/생일/미니'; update sabang_net_goods set scode='9000095' where sname='1.세트/DIY/미니'; update sabang_net_goods set scode='9000251' where sname='$세트/S/떡케이크A/꽃12'; update sabang_net_goods set scode='9000261' where sname='$세트/S/떡케이크C/꽃12/리본거치대'; update sabang_net_goods set scode='9000262' where sname='$세트/S/떡케이크D/꽃12/리본거치대'; update sabang_net_goods set scode='9000020' where sname='L-2.단품/초코펜/화이트/100g'; update sabang_net_goods set scode='9000252' where sname='$세트/V/떡케이크B/꽃12'; update sabang_net_goods set scode='9000328' where sname='113.세트/DIY/3호/레드벨벳시트'; update sabang_net_goods set scode='9000175' where sname='A5.박스/바닐라시트/1호(30EA)'; update sabang_net_goods set scode='9000142' where sname='N-2.단품/초콜릿비닐(소)/30장'; update sabang_net_goods set scode='9000019' where sname='L-1.단품/초코펜/다크/100g'; update sabang_net_goods set scode='9000035' where sname='Z-5.단품/아이스박스/25kg'; update sabang_net_goods set scode='9000279' where sname='17.세트/DIY/2호/다크펜'; update sabang_net_goods set scode='9000023' where sname='L-5.단품/초코펜/딸기/100g'; update sabang_net_goods set scode='9000009' where sname='H-0.단품/미니상자+받침'; update sabang_net_goods set scode='9000010' where sname='H-1.단품/1호상자+받침'; update sabang_net_goods set scode='9000138' where sname='K-4.단품/몰드/알파벳'; update sabang_net_goods set scode='9000345' where sname='67.세트/생일/2호초코데코/다크펜/초코시트'; update sabang_net_goods set scode='9000320' where sname='57.세트/DIY/2호/다크펜/초코시트'; update sabang_net_goods set scode='9000013' where sname='M-1.단품/초코펜/다크/20g'; update sabang_net_goods set scode='9000017' where sname='M-5.단품/초코펜/딸기/20g'; update sabang_net_goods set scode='9000038' where sname='A2.단품/바닐라시트/2호'; update sabang_net_goods set scode='9000116' where sname='!2호/만주10구화과자5구'; update sabang_net_goods set scode='9000078' where sname='J-5.세트/초콜릿/한글'; update sabang_net_goods set scode='9000077' where sname='J-2.세트/초콜릿/과일'; update sabang_net_goods set scode='9000104' where sname='14.세트/생일/1호초코데코'; update sabang_net_goods set scode='9000356' where sname='!1호/만주15구/아이스박스포장'; update sabang_net_goods set scode='9000117' where sname='!3호/만주5구화과자10구'; update sabang_net_goods set scode='9999999' where sname='$세트/V/떡케이크C/꽃20/리본거치대'; update sabang_net_goods set scode='9999999' where sname='모음/12종/단품/바닐라시트'; update sabang_net_goods set scode='9999999' where sname='O-1.단품/초콜릿상자'; update sabang_net_goods set scode='9000265' where sname='$세트/S/떡케이크D/꽃20/리본거치대'; update sabang_net_goods set scode='9999999' where sname='$세트/V/떡케이크A/꽃12/리본거치대'; update sabang_net_goods set scode='9000315' where sname='53.세트/DIY/1호초코데코/초코시트'; update sabang_net_goods set scode='9000105' where sname='27.세트/생일/2호초코데코/다크펜'; update sabang_net_goods set scode='9000195' where sname='C7.박스/레드벨벳시트/3호(16EA)'; update sabang_net_goods set scode='9999999' where sname='81.세트/DIY/미니/레드벨벳시트'; update sabang_net_goods set scode='9000173' where sname='A4.박스/바닐라시트/미니(36EA)'; update sabang_net_goods set scode='9000174' where sname='A4.박스/바닐라시트/미니(45EA)'; update sabang_net_goods set scode='9999999' where sname='89.세트/DIY/1호/레드벨벳시트'; update sabang_net_goods set scode='9000176' where sname='A5.박스/바닐라시트/1호(36EA)'; update sabang_net_goods set scode='9000177' where sname='A6.박스/바닐라시트/2호(20EA)'; update sabang_net_goods set scode='9000178' where sname='A6.박스/바닐라시트/2호(25EA)'; update sabang_net_goods set scode='9000179' where sname='A7.박스/바닐라시트/3호(16EA)'; update sabang_net_goods set scode='9000180' where sname='A7.박스/바닐라시트/3호(20EA)'; update sabang_net_goods set scode='9000332' where sname='42.세트/생일/미니/초코시트'; update sabang_net_goods set scode='9000033' where sname='Z-2.단품/아이스박스/중15kg'; update sabang_net_goods set scode='9000187' where sname='B7.박스/초코시트/3호(16EA)'; update sabang_net_goods set scode='9000185' where sname='B6.박스/초코시트/2호(20EA)'; update sabang_net_goods set scode='9000338' where sname='50.세트/생일/1호/초코시트'; update sabang_net_goods set scode='9999999' where sname='휘핑생크림80g'; update sabang_net_goods set scode='9000034' where sname='Z-4.단품/아이스박스/20kg'; update sabang_net_goods set scode='9000365' where sname='!10호/만주10구화과자20구/아이스박스포장'; update sabang_net_goods set scode='9000366' where sname='!11호/화과자30구/아이스박스'; update sabang_net_goods set scode='9999999' where sname='!단품/아이스박스/HM'; update sabang_net_goods set scode='9000218' where sname='$세트/V/떡케이크A/꽃12/리본거치대/사랑'; update sabang_net_goods set scode='9000118' where sname='!4호/화과자15구'; update sabang_net_goods set scode='9000121' where sname='!7호/화과자20구'; update sabang_net_goods set scode='9000366' where sname='!11호/화과자30구/아이스박스포장'; update sabang_net_goods set scode='9000101' where sname='19.세트/생일/2호/다크펜'; update sabang_net_goods set scode='9999999' where sname='휘핑생크림(130g)'; update sabang_net_goods set scode='9999999' where sname='해피버스데이초(HAPPYBIRTHDAY)'; update sabang_net_goods set scode='9000075' where sname='J-1.세트/초콜릿/동물'; update sabang_net_goods set scode='9000115' where sname='!1호/만주15구'; update sabang_net_goods set scode='9999999' where sname='생일2호초코데코케이크만들기+다크펜20g'; update sabang_net_goods set scode='9000016' where sname='M-4.단품/초코펜/호박/20g'; update sabang_net_goods set scode='9000356' where sname='!1호/만주15구선물세트(아이스박스)'; update sabang_net_goods set scode='9000039' where sname='A3.단품/바닐라시트/3호'; update sabang_net_goods set scode='9000096' where sname='9.세트/DIY/1호'; update sabang_net_goods set scode='9999999' where sname='파스텔스타(8g)'; update sabang_net_goods set scode='9000018' where sname='M-5.단품/초코펜/자색/20g'; update sabang_net_goods set scode='9999999' where sname='$세트/V/떡케이크A/꽃12/리본거치대|팔팔하니팔순이라전해라백살까지가즈아!!!'; update sabang_net_goods set scode='9999999' where sname='$세트/S/떡케이크A/꽃20/리본거치대|꽃다발리본출력문구:생신축하드림니다.'; update sabang_net_goods set scode='9999999' where sname='$세트/V/떡케이크C/꽃12/리본거치대/승진을진심으로축하드립니다'; update sabang_net_goods set scode='9999999' where sname='$세트/V/떡케이크C/꽃20/리본거치대(환갑을축하합니다/항상건강하세요)'; update sabang_net_goods set scode='9999999' where sname='107.세트/생일/2호초코데코/다크펜/레드벨벳시트'; update sabang_net_goods set scode='9000212' where sname='$세트/V/떡케이크C/꽃다발12/리본거치대/사랑'; update sabang_net_goods set scode='9000361' where sname='!6호/만주10구+화과자10구/아이스박스포장'; update sabang_net_goods set scode='9000203' where sname='$세트/V/떡케이크A/꽃20/리본거치대/사랑'; update sabang_net_goods set scode='9000364' where sname='!9호/만주20구화과자10구/아이스박스포장'; update sabang_net_goods set scode='9000361' where sname='!6호/만주10구화과자10구/아이스박스포장'; update sabang_net_goods set scode='9999999' where sname='118.세트/생일/3호초코데코/레드벨벳시트'; update sabang_net_goods set scode='9000357' where sname='!2호/만주10구화과자5구/아이스박스포장'; update sabang_net_goods set scode='9000358' where sname='!3호/만주5구화과자10구/아이스박스포장'; update sabang_net_goods set scode='9999999' where sname='94.세트/생일/1호초코데코/레드벨벳시트'; update sabang_net_goods set scode='9999999' where sname='99.세트/생일/2호/다크펜/레드벨벳시트'; update sabang_net_goods set scode='9000361' where sname='!6호/만주10구화과자10구(아이스박스)'; update sabang_net_goods set scode='9999999' where sname='97.세트/DIY/2호/다크펜/레드벨벳시트'; update sabang_net_goods set scode='9000361' where sname='!6호/만주10구화과자10구/아이스박스'; update sabang_net_goods set scode='9000333' where sname='46.세트/생일/미니초코데코/초코시트'; update sabang_net_goods set scode='9000339' where sname='54.세트/생일/1호초코데코/초코시트'; update sabang_net_goods set scode='9000351' where sname='78.세트/생일/3호초코데코/초코시트'; update sabang_net_goods set scode='9000259' where sname='$세트/S/떡케이크A/꽃12/리본거치대'; update sabang_net_goods set scode='9000265' where sname='$세트/S/떡케이크C/꽃20/리본거치대'; update sabang_net_goods set scode='9000263' where sname='$세트/V/떡케이크A/꽃20/리본거치대'; update sabang_net_goods set scode='9000261' where sname='$세트/V/떡케이크C/꽃12/리본거치대'; update sabang_net_goods set scode='9000359' where sname='!4호/화과자15/아이스박스포장'; update sabang_net_goods set scode='9000359' where sname='!4호/화과자15구/아이스박스포장'; update sabang_net_goods set scode='9000119' where sname='!5호/만주20구'; update sabang_net_goods set scode='9000360' where sname='!5호/만주20구/아이스박스포장'; update sabang_net_goods set scode='9000362' where sname='!7호/화과자20구/아이스박스포장'; update sabang_net_goods set scode='9999999' where sname='114.세트/생일/3호/레드벨벳시트'; update sabang_net_goods set scode='9000122' where sname='!8호/만주30구'; update sabang_net_goods set scode='9000363' where sname='!8호/만주30구/아이스박스포장'; update sabang_net_goods set scode='9000161' where sname='!단품/메세지카드'; update sabang_net_goods set scode='9999999' where sname='@모음/19종/S떡케이크'; update sabang_net_goods set scode='9000197' where sname='케이크돌림판'; update sabang_net_goods set scode='9999999' where sname='아이스박스(15kg)+아이스팩'; update sabang_net_goods set scode='9000332' where sname='세트/생일/미니/초코시트'; update sabang_net_goods set scode='9999999' where sname='세트/생일/2호/레드벨벳시트'; update sabang_net_goods set scode='9000326' where sname='세트/DIY/3호/초코시트'; update sabang_net_goods set scode='9999999' where sname='생일2호초코데코세트/초코시트'; update sabang_net_goods set scode='9999999' where sname='바닐라미니케이크시트'; update sabang_net_goods set scode='9000015' where sname='M-3.단품/초코펜/밀싹/20g'; update sabang_net_goods set scode='9000315' where sname='13.세트/DIY/1호초코데코/초코시트'; update sabang_net_goods set scode='9000327' where sname='13.세트/DIY/3호초코데코/초코시트'; update sabang_net_goods set scode='9000198' where sname='59.세트/생일/2호/다크펜/초코시트'; update sabang_net_goods set scode='9999999' where sname='모음/40종/단품/케이크/종합'; update sabang_net_goods set scode='9000343' where sname='25.세트/생일/2호초코데코/다크펜'; update sabang_net_goods set scode='9000145' where sname='28.세트/생일/2호초코데코/딸기펜'; update sabang_net_goods set scode='9000196' where sname='A15.박스/레드벨벳시트/3호(20EA)'; update sabang_net_goods set scode='9999999' where sname='82.세트/생일/미니/레드벨벳시트'; update sabang_net_goods set scode='9000109' where sname='25.세트/DIY/2호초코데코/다크펜'; update sabang_net_goods set scode='9999999' where sname='90.세트/생일/1호/레드벨벳시트'; update sabang_net_goods set scode='9999999' where sname='$세트/V/떡케이크A/꽃12/축생일'; update sabang_net_goods set scode='9000141' where sname='N-1.단품/초콜릿비닐(대)/12장'; update sabang_net_goods set scode='9999999' where sname='모음/150종/세트/케이크/종합'; update sabang_net_goods set scode='9000181' where sname='B4.박스/초코시트/미니(36EA)'; update sabang_net_goods set scode='9000182' where sname='B4.박스/초코시트/미니(45EA)'; update sabang_net_goods set scode='9999999' where sname='Z-3.단품/아이스박스/15kg소'; update sabang_net_goods set scode='9999999' where sname='$단품/VIP/떡케이크A/축칠순'; update sabang_net_goods set scode='9000257' where sname='$세트/S/떡케이크C/꽃다발20'; update sabang_net_goods set scode='9000183' where sname='B5.박스/초코시트/1호(30EA)'; update sabang_net_goods set scode='9000186' where sname='B6.박스/초코시트/2호(25EA)'; update sabang_net_goods set scode='9999999' where sname='C-6.자색고구마초코펜(100g)'; update sabang_net_goods set scode='9999999' where sname='Z-1.단품/아이스박스/소15kg'; update sabang_net_goods set scode='9999999' where sname='Z-3.단품/아이스박스/15kg중'; update sabang_net_goods set scode='9000021' where sname='L-3.단품/초코펜/밀싹/100g'; update sabang_net_goods set scode='9000022' where sname='L-4.단품/초코펜/호박/100g'; update sabang_net_goods set scode='9000024' where sname='L-6.단품/초코펜/자색/100g'; update sabang_net_goods set scode='9000102' where sname='34.세트/생일/3호'; update sabang_net_goods set scode='9000199' where sname='49.세트/DIY/1호/초코시트'; update sabang_net_goods set scode='9000098' where sname='13.세트/DIY/1호초코데코'; update sabang_net_goods set scode='9000100' where sname='10.세트/생일/1호'; update sabang_net_goods set scode='9000044' where sname='C0.단품/레드벨벳시트/미니'; update sabang_net_goods set scode='9000308' where sname='1.세트/DIY/미니/초코시트'; update sabang_net_goods set scode='9999999' where sname='Z-1.단품/아이스박스/소중'; update sabang_net_goods set scode='9999999' where sname='$세트/V/떡케이크C/꽃12'; update sabang_net_goods set scode='9000045' where sname='C1.단품/레드벨벳시트/1호'; update sabang_net_goods set scode='9000046' where sname='C2.단품/레드벨벳시트/2호'; update sabang_net_goods set scode='9000047' where sname='C3.단품/레드벨벳시트/3호'; update sabang_net_goods set scode='9999999' where sname='모음/12종/단품/초코시트'; update sabang_net_goods set scode='9999999' where sname='$단품/V/떡케이크C/(단품)'; update sabang_net_goods set scode='9000110' where sname='37.세트/DIY/3호초코데코'; update sabang_net_goods set scode='9000106' where sname='38.세트/생일/3호초코데코'; update sabang_net_goods set scode='9000110' where sname='41.세트/DIY/3호초코데코'; update sabang_net_goods set scode='9000277' where sname='5.세트/DIY/미니초코데코'; update sabang_net_goods set scode='9000103' where sname='6.세트/생일/미니초코데코'; update sabang_net_goods set scode='9000326' where sname='73.세트/DIY/3호/초코시트'; update sabang_net_goods set scode='9000028' where sname='G-3.단품/해피버스데이초'; update sabang_net_goods set scode='9000079' where sname='J-4.세트/초콜릿/알파벳'; update sabang_net_goods set scode='9000076' where sname='J-6.세트/초콜릿/타는놀이'; update sabang_net_goods set scode='9999999' where sname='Z-2.단품/아이스박스/중소'; update sabang_net_goods set scode='9999999' where sname='단품/케익상자&받침(미니)'; update sabang_net_goods set scode='9000014' where sname='단품/초코펜/화이트/20g'; update sabang_net_goods set scode='9000135' where sname='K-6.단품/몰드/타는놀이'; update sabang_net_goods set scode='9999999' where sname='@모음/22종/V떡케이크'; update sabang_net_goods set scode='9000255' where sname='$세트/S/떡케이크A/꽃20'; update sabang_net_goods set scode='9000253' where sname='$세트/S/떡케이크C/꽃12'; update sabang_net_goods set scode='9000258' where sname='$세트/S/떡케이크D/꽃20'; update sabang_net_goods set scode='9999999' where sname='@모음/6종/초코펜/100g'; update sabang_net_goods set scode='9000247' where sname='$단품/S/떡케이크A'; update sabang_net_goods set scode='9999999' where sname='$세트/V/떡케이크A/꽃12'; update sabang_net_goods set scode='9000249' where sname='$단품/S/떡케이크C'; update sabang_net_goods set scode='9000250' where sname='$단품/S/떡케이크D'; update sabang_net_goods set scode='9999999' where sname='$단품/V/떡케이크A'; update sabang_net_goods set scode='9999999' where sname='$단품/VIP/떡케이크A'; update sabang_net_goods set scode='9999999' where sname='$단품/VIP/떡케이크B'; update sabang_net_goods set scode='9999999' where sname='$단품/VIP/떡케이크C'; update sabang_net_goods set scode='9999999' where sname='$단품/리본거치대'; update sabang_net_goods set scode='9000161' where sname='$단품/메세지카드'; update sabang_net_goods set scode='9999999' where sname='$세트/V/떡케이크A/꽃20'; update sabang_net_goods set scode='9999999' where sname='$세트/V/떡케이크B/꽃20'; update sabang_net_goods set scode='9999999' where sname='$세트/V/떡케이크C/꽃20'; update sabang_net_goods set scode='9999999' where sname='$세트/V/떡케이크F/꽃12'; update sabang_net_goods set scode='9000143' where sname='18.세트/DIY/2호/딸기펜'; update sabang_net_goods set scode='9000042' where sname='B2.단품/초코시트/2호'; update sabang_net_goods set scode='9999999' where sname='C-2.화이트초코펜(100g)'; update sabang_net_goods set scode='9000015' where sname='C-3.밀싹초코펜(100g)'; update sabang_net_goods set scode='9000022' where sname='C-4.호박초코펜(100g)'; update sabang_net_goods set scode='9000023' where sname='C-5.딸기초코펜(100g)'; update sabang_net_goods set scode='9000005' where sname='F-3.단품/파스텔스타/8g'; update sabang_net_goods set scode='9999999' where sname='I-1.세트/초콜릿/3종/A'; update sabang_net_goods set scode='9000013' where sname='단품/초코펜/다크/20g'; update sabang_net_goods set scode='9000017' where sname='단품/초코펜/딸기/20g'; update sabang_net_goods set scode='9000018' where sname='단품/초코펜/자색/20g'; update sabang_net_goods set scode='9000029' where sname='F-1.단품/칼/소'; update sabang_net_goods set scode='9000030' where sname='F-2.단품/칼/중'; update sabang_net_goods set scode='9000025' where sname='F-7.단품/모양깍지6종'; update sabang_net_goods set scode='9000355' where sname='데코초(색상랜덤)'; update sabang_net_goods set scode='9000134' where sname='K-1.단품/몰드/동물'; update sabang_net_goods set scode='9000136' where sname='K-2.단품/몰드/과일'; update sabang_net_goods set scode='9000139' where sname='K-3.단품/몰드/꽃'; update sabang_net_goods set scode='9000355' where sname='단품/데코초'; update sabang_net_goods set scode='9000161' where sname='단품/메세지카드'; update sabang_net_goods set scode='9000197' where sname='단품/케이크돌림판'; update sabang_net_goods set scode='9000029' where sname='단품/칼(소/미니전용)'; update sabang_net_goods set scode='9000197' where sname='F-8.단품/케이크돌림판'; update sabang_net_goods set scode='9999999' where sname='다크초코펜20g'; update sabang_net_goods set scode='9000027' where sname='G-2.단품/아이러브유초'; update sabang_net_goods set scode='9000137' where sname='K-5.단품/몰드/한글'; update sabang_net_goods set scode='9000080' where sname='J-3.세트/초콜릿/꽃'; update sabang_net_goods set scode='9999999' where sname='I-2.세트/초콜릿/3종/B'; update sabang_net_goods set scode='9000011' where sname='H-2.단품/2호상자+받침'; update sabang_net_goods set scode='9000012' where sname='H-3.단품/3호상자+받침'; update sabang_net_goods set scode='9000103' where sname='세트/생일/미니초코데코'; update sabang_net_goods set scode='9999999' where sname='!7호/화과자10구'; update sabang_net_goods set scode='9000038' where sname='단품/바닐라시트/2호'; update sabang_net_goods set scode='9000099' where sname='세트/생일/미니'; update sabang_net_goods set scode='9999999' where sname='세트/생일/2호초코데코'; update sabang_net_goods set scode='9000033' where sname='단품/아이스박스/15kg'; update sabang_net_goods set scode='9000195' where sname='C7.박스/레드벨벳시트/3호(16EA)'; update sabang_net_goods set scode='9999999' where sname='81.세트/DIY/미니/레드벨벳시트'; update sabang_net_goods set scode='9000173' where sname='A4.박스/바닐라시트/미니(36EA)'; update sabang_net_goods set scode='9000174' where sname='A4.박스/바닐라시트/미니(45EA)'; update sabang_net_goods set scode='9999999' where sname='89.세트/DIY/1호/레드벨벳시트'; update sabang_net_goods set scode='9000176' where sname='A5.박스/바닐라시트/1호(36EA)'; update sabang_net_goods set scode='9000177' where sname='A6.박스/바닐라시트/2호(20EA)'; update sabang_net_goods set scode='9000178' where sname='A6.박스/바닐라시트/2호(25EA)'; update sabang_net_goods set scode='9000179' where sname='A7.박스/바닐라시트/3호(16EA)'; update sabang_net_goods set scode='9000180' where sname='A7.박스/바닐라시트/3호(20EA)'; update sabang_net_goods set scode='9000332' where sname='42.세트/생일/미니/초코시트'; update sabang_net_goods set scode='9000033' where sname='Z-2.단품/아이스박스/중15kg'; update sabang_net_goods set scode='9000187' where sname='B7.박스/초코시트/3호(16EA)'; update sabang_net_goods set scode='9000185' where sname='B6.박스/초코시트/2호(20EA)'; update sabang_net_goods set scode='9000338' where sname='50.세트/생일/1호/초코시트'; update sabang_net_goods set scode='9999999' where sname='휘핑생크림80g'; update sabang_net_goods set scode='9000034' where sname='Z-4.단품/아이스박스/20kg'; update sabang_net_goods set scode='9000365' where sname='!10호/만주10구화과자20구/아이스박스포장'; update sabang_net_goods set scode='9000366' where sname='!11호/화과자30구/아이스박스'; update sabang_net_goods set scode='9999999' where sname='!단품/아이스박스/HM'; update sabang_net_goods set scode='9000218' where sname='$세트/V/떡케이크A/꽃12/리본거치대/사랑'; update sabang_net_goods set scode='9000118' where sname='!4호/화과자15구'; update sabang_net_goods set scode='9000121' where sname='!7호/화과자20구'; update sabang_net_goods set scode='9000366' where sname='!11호/화과자30구/아이스박스포장'; update sabang_net_goods set scode='9000101' where sname='19.세트/생일/2호/다크펜'; update sabang_net_goods set scode='9999999' where sname='휘핑생크림(130g)'; update sabang_net_goods set scode='9999999' where sname='해피버스데이초(HAPPYBIRTHDAY)'; update sabang_net_goods set scode='9000075' where sname='J-1.세트/초콜릿/동물'; update sabang_net_goods set scode='9000115' where sname='!1호/만주15구'; update sabang_net_goods set scode='9999999' where sname='생일2호초코데코케이크만들기+다크펜20g'; update sabang_net_goods set scode='9000016' where sname='M-4.단품/초코펜/호박/20g'; update sabang_net_goods set scode='9000356' where sname='!1호/만주15구선물세트(아이스박스)'; update sabang_net_goods set scode='9000039' where sname='A3.단품/바닐라시트/3호'; update sabang_net_goods set scode='9000096' where sname='9.세트/DIY/1호'; update sabang_net_goods set scode='9999999' where sname='파스텔스타(8g)'; update sabang_net_goods set scode='9000018' where sname='M-5.단품/초코펜/자색/20g'; update sabang_net_goods set scode='9999999' where sname='$세트/V/떡케이크A/꽃12/리본거치대|팔팔하니팔순이라전해라백살까지가즈아!!!'; update sabang_net_goods set scode='9999999' where sname='$세트/S/떡케이크A/꽃20/리본거치대|꽃다발리본출력문구:생신축하드림니다.'; update sabang_net_goods set scode='9999999' where sname='$세트/V/떡케이크C/꽃12/리본거치대/승진을진심으로축하드립니다'; update sabang_net_goods set scode='9999999' where sname='$세트/V/떡케이크C/꽃20/리본거치대(환갑을축하합니다/항상건강하세요)'; update sabang_net_goods set scode='9999999' where sname='107.세트/생일/2호초코데코/다크펜/레드벨벳시트'; update sabang_net_goods set scode='9000212' where sname='$세트/V/떡케이크C/꽃다발12/리본거치대/사랑'; update sabang_net_goods set scode='9000361' where sname='!6호/만주10구+화과자10구/아이스박스포장'; update sabang_net_goods set scode='9000203' where sname='$세트/V/떡케이크A/꽃20/리본거치대/사랑'; update sabang_net_goods set scode='9000364' where sname='!9호/만주20구화과자10구/아이스박스포장'; update sabang_net_goods set scode='9000361' where sname='!6호/만주10구화과자10구/아이스박스포장'; update sabang_net_goods set scode='9999999' where sname='118.세트/생일/3호초코데코/레드벨벳시트'; update sabang_net_goods set scode='9000357' where sname='!2호/만주10구화과자5구/아이스박스포장'; update sabang_net_goods set scode='9000358' where sname='!3호/만주5구화과자10구/아이스박스포장'; update sabang_net_goods set scode='9999999' where sname='94.세트/생일/1호초코데코/레드벨벳시트'; update sabang_net_goods set scode='9999999' where sname='99.세트/생일/2호/다크펜/레드벨벳시트'; update sabang_net_goods set scode='9000361' where sname='!6호/만주10구화과자10구(아이스박스)'; update sabang_net_goods set scode='9999999' where sname='97.세트/DIY/2호/다크펜/레드벨벳시트'; update sabang_net_goods set scode='9000361' where sname='!6호/만주10구화과자10구/아이스박스'; update sabang_net_goods set scode='9000333' where sname='46.세트/생일/미니초코데코/초코시트'; update sabang_net_goods set scode='9000339' where sname='54.세트/생일/1호초코데코/초코시트'; update sabang_net_goods set scode='9000351' where sname='78.세트/생일/3호초코데코/초코시트'; update sabang_net_goods set scode='9000259' where sname='$세트/S/떡케이크A/꽃12/리본거치대'; update sabang_net_goods set scode='9000265' where sname='$세트/S/떡케이크C/꽃20/리본거치대'; update sabang_net_goods set scode='9000263' where sname='$세트/V/떡케이크A/꽃20/리본거치대'; update sabang_net_goods set scode='9000261' where sname='$세트/V/떡케이크C/꽃12/리본거치대'; update sabang_net_goods set scode='9000359' where sname='!4호/화과자15/아이스박스포장'; update sabang_net_goods set scode='9000359' where sname='!4호/화과자15구/아이스박스포장'; update sabang_net_goods set scode='9000119' where sname='!5호/만주20구'; update sabang_net_goods set scode='9000360' where sname='!5호/만주20구/아이스박스포장'; update sabang_net_goods set scode='9000362' where sname='!7호/화과자20구/아이스박스포장'; update sabang_net_goods set scode='9999999' where sname='114.세트/생일/3호/레드벨벳시트'; update sabang_net_goods set scode='9000122' where sname='!8호/만주30구'; update sabang_net_goods set scode='9000363' where sname='!8호/만주30구/아이스박스포장'; update sabang_net_goods set scode='9000161' where sname='!단품/메세지카드'; update sabang_net_goods set scode='9999999' where sname='@모음/19종/S떡케이크'; update sabang_net_goods set scode='9000197' where sname='케이크돌림판'; update sabang_net_goods set scode='9999999' where sname='아이스박스(15kg)+아이스팩'; update sabang_net_goods set scode='9000332' where sname='세트/생일/미니/초코시트'; update sabang_net_goods set scode='9999999' where sname='세트/생일/2호/레드벨벳시트'; update sabang_net_goods set scode='9000326' where sname='세트/DIY/3호/초코시트'; update sabang_net_goods set scode='9999999' where sname='생일2호초코데코세트/초코시트'; update sabang_net_goods set scode='9999999' where sname='바닐라미니케이크시트'; update sabang_net_goods set scode='9000015' where sname='M-3.단품/초코펜/밀싹/20g'; update sabang_net_goods set scode='9000315' where sname='13.세트/DIY/1호초코데코/초코시트'; update sabang_net_goods set scode='9000327' where sname='13.세트/DIY/3호초코데코/초코시트'; update sabang_net_goods set scode='9000198' where sname='59.세트/생일/2호/다크펜/초코시트'; update sabang_net_goods set scode='9999999' where sname='모음/40종/단품/케이크/종합'; update sabang_net_goods set scode='9000343' where sname='25.세트/생일/2호초코데코/다크펜'; update sabang_net_goods set scode='9000145' where sname='28.세트/생일/2호초코데코/딸기펜'; update sabang_net_goods set scode='9000196' where sname='A15.박스/레드벨벳시트/3호(20EA)'; update sabang_net_goods set scode='9999999' where sname='82.세트/생일/미니/레드벨벳시트'; update sabang_net_goods set scode='9000109' where sname='25.세트/DIY/2호초코데코/다크펜'; update sabang_net_goods set scode='9999999' where sname='90.세트/생일/1호/레드벨벳시트'; update sabang_net_goods set scode='9999999' where sname='$세트/V/떡케이크A/꽃12/축생일'; update sabang_net_goods set scode='9000141' where sname='N-1.단품/초콜릿비닐(대)/12장'; update sabang_net_goods set scode='9999999' where sname='모음/150종/세트/케이크/종합'; update sabang_net_goods set scode='9000181' where sname='B4.박스/초코시트/미니(36EA)'; update sabang_net_goods set scode='9000182' where sname='B4.박스/초코시트/미니(45EA)'; update sabang_net_goods set scode='9999999' where sname='Z-3.단품/아이스박스/15kg소'; update sabang_net_goods set scode='9999999' where sname='$단품/VIP/떡케이크A/축칠순'; update sabang_net_goods set scode='9000257' where sname='$세트/S/떡케이크C/꽃다발20'; update sabang_net_goods set scode='9000183' where sname='B5.박스/초코시트/1호(30EA)'; update sabang_net_goods set scode='9000186' where sname='B6.박스/초코시트/2호(25EA)'; update sabang_net_goods set scode='9999999' where sname='C-6.자색고구마초코펜(100g)'; update sabang_net_goods set scode='9999999' where sname='Z-1.단품/아이스박스/소15kg'; update sabang_net_goods set scode='9999999' where sname='Z-3.단품/아이스박스/15kg중'; update sabang_net_goods set scode='9000021' where sname='L-3.단품/초코펜/밀싹/100g'; update sabang_net_goods set scode='9000022' where sname='L-4.단품/초코펜/호박/100g'; update sabang_net_goods set scode='9000024' where sname='L-6.단품/초코펜/자색/100g'; update sabang_net_goods set scode='9000102' where sname='34.세트/생일/3호'; update sabang_net_goods set scode='9000199' where sname='49.세트/DIY/1호/초코시트'; update sabang_net_goods set scode='9000098' where sname='13.세트/DIY/1호초코데코'; update sabang_net_goods set scode='9000100' where sname='10.세트/생일/1호'; update sabang_net_goods set scode='9000044' where sname='C0.단품/레드벨벳시트/미니'; update sabang_net_goods set scode='9000308' where sname='1.세트/DIY/미니/초코시트'; update sabang_net_goods set scode='9999999' where sname='Z-1.단품/아이스박스/소중'; update sabang_net_goods set scode='9999999' where sname='$세트/V/떡케이크C/꽃12'; update sabang_net_goods set scode='9000045' where sname='C1.단품/레드벨벳시트/1호'; update sabang_net_goods set scode='9000046' where sname='C2.단품/레드벨벳시트/2호'; update sabang_net_goods set scode='9000047' where sname='C3.단품/레드벨벳시트/3호'; update sabang_net_goods set scode='9999999' where sname='모음/12종/단품/초코시트'; update sabang_net_goods set scode='9999999' where sname='$단품/V/떡케이크C/(단품)'; update sabang_net_goods set scode='9000110' where sname='37.세트/DIY/3호초코데코'; update sabang_net_goods set scode='9000106' where sname='38.세트/생일/3호초코데코'; update sabang_net_goods set scode='9000110' where sname='41.세트/DIY/3호초코데코'; update sabang_net_goods set scode='9000277' where sname='5.세트/DIY/미니초코데코'; update sabang_net_goods set scode='9000103' where sname='6.세트/생일/미니초코데코'; update sabang_net_goods set scode='9000326' where sname='73.세트/DIY/3호/초코시트'; update sabang_net_goods set scode='9000028' where sname='G-3.단품/해피버스데이초'; update sabang_net_goods set scode='9000079' where sname='J-4.세트/초콜릿/알파벳'; update sabang_net_goods set scode='9000076' where sname='J-6.세트/초콜릿/타는놀이'; update sabang_net_goods set scode='9999999' where sname='Z-2.단품/아이스박스/중소'; update sabang_net_goods set scode='9999999' where sname='단품/케익상자&받침(미니)'; update sabang_net_goods set scode='9000014' where sname='단품/초코펜/화이트/20g'; update sabang_net_goods set scode='9000135' where sname='K-6.단품/몰드/타는놀이'; update sabang_net_goods set scode='9999999' where sname='@모음/22종/V떡케이크'; update sabang_net_goods set model='SAC0001' where sname='!1호/만주15구/아이스박스포장'; delete from sabang_net_goods where no=291; select * from sabang_net_goods; use DB_mcakecms; drop table table_sabangnet; create table if not exists table_sabangnet ( `sabang_no` char(12) NOT NULL COMMENT '고유번호(YYYYMMDDnnnn', `sabang_datetime` datetime NOT NULL COMMENT '작업일자/시각', `sabang_order_sequ_no` int(11) NOT NULL COMMENT 'mcake_cm_cart_ord 일련번호', `sabang_order_no` char(11) NOT NULL COMMENT '판매번호', `sabang_recman` text NOT NULL COMMENT 'Excel-수취인명', `sabang_rec_tel1` text NOT NULL COMMENT 'Excel-수취인번호1', `sabang_rec_tel2` text NOT NULL COMMENT 'Excel-수취인번호2', `sabang_goods_name` text NOT NULL COMMENT 'Excel-상품명', `sabang_option` text NOT NULL COMMENT 'Excel-옵션명', `sabang_short_name` text NOT NULL COMMENT 'Excel-상품약어', `sabang_cnt` int(5) NOT NULL COMMENT 'Excel-수량', `sabang_addr` text NOT NULL COMMENT 'Excel-수취인주소', `sabang_memo` text NOT NULL COMMENT 'Excel-배송메모', `sabang_add_msg` text NOT NULL COMMENT 'Excel-추가메세지', `sabang_order_man` text NOT NULL COMMENT 'Excel-주문자명', `sabang_order_tel1` text NOT NULL COMMENT 'Excel-주문자번호1', `sabang_order_tel2` text NOT NULL COMMENT 'Excel-주문자번호2', `sabang_shopping` text NOT NULL COMMENT 'Excel-쇼핑몰', `sabang_delivery` text NOT NULL COMMENT 'Excel-택배사', `sabang_unsongjang_no` char(14) NOT NULL COMMENT 'Excel-송장번호', `sabang_sabang_no` char(10) NOT NULL COMMENT 'Excel-사방넷주문번호', `sabang_model` char(7) NOT NULL COMMENT 'Excel-모델NO', `sabang_goods_code` char(7) NOT NULL COMMENT '상품코드', `sabang_apchuk_name` text NOT NULL COMMENT '압축한 상품약어', `sabang_num` char(1) NOT NULL COMMENT '당일 작업 순번'); select * from table_sabangnet limit 4; select * from mcake_cm_cart_ord; select * from mcake_order_list; select * from mcake_workboard; delete from mcake_cm_user where no>8712; drop table mcake_workboard; CREATE TABLE `mcake_workboard` ( `no` int(11) NOT NULL, `wb_cate` varchar(30) NOT NULL COMMENT '카테고리명', `wb_order_code` char(11) NOT NULL COMMENT '주문코드', `wb_contents` text NOT NULL COMMENT '요청내용', `wb_state` char(2) NOT NULL COMMENT '요청상태 10:요청 11:확인 20:완료', `wb_user_w` text NOT NULL COMMENT '등록자', `wb_user_ok` text NOT NULL COMMENT '처리자', `wb_sdtm` datetime NOT NULL COMMENT '최초등록일', `wb_edtm` datetime NOT NULL COMMENT '최종수정일 초기값:2024-01-01'); ALTER TABLE `mcake_workboard` ADD PRIMARY KEY (`no`),ADD KEY `wb_order_code` (`wb_order_code`); ALTER TABLE `mcake_workboard` MODIFY `no` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1; use Db_ebirthday; drop table Table_customer; create table if not exists Table_customer ( cname text, cphon char(13), cmail text, czcod char(5), cadd1 text, cadd2 text, cadd3 text); select * from Table_customer; use Db_ebirthday; drop table table_kakao_member; create table if not exists table_kakao_member ( msequ char(14), mkaid text, mname text, mphon char(13), msoph char(13), magre char(1), macti char(1), mclos char(10), msaup char(12), mupch text, mjuso text, mtell text, primary key (msequ)); select * from table_kakao_member; 고객일련번호(14):가입일자(10)+일련번호(4) 발송대상 카톡ID(100) 고객명(100) 휴대폰번호(13) 소속휴대폰번호(13) 광고동의유무(1):0->동의 1->비동의 활동유무(1):0->활동 1->탈퇴 탈퇴일자(10) 사업자번호(12) 업체이름 주소 일반전화번호 use Db_ebirthday; drop table table_jikwon; create table if not exists Table_jikwon ( jid varchar(50), jpass text, jname text, jdnew char(10), jdips char(10), jclos char(10), jbirt char(7), jauth char(1), jacti char(1), jcont int(3), jldat char(10), jltim char(8)); insert into table_jikwon(jid,jpass,jname,jdnew,jdips,jclos,jbirt,jauth,jacti,jcont,jldat,jltim)values("관리자","625122love$","관리자","2023-07-01","","","","0","1",0,"",""); insert into table_jikwon(jid,jpass,jname,jdnew,jdips,jclos,jbirt,jauth,jacti,jcont,jldat,jltim)values("admin","196205","문두연","2023-07-01","2022-01-05","","1962-05","0","0",0,"",""); select * from table_jikwon; update Table_Jikwon set jname='관리인' where jid="관리자"; delete from Table_Jikwon where jid="korea"; 직원별 아이디 비밀번호 직원이름 신규일자 입사일자 해지일자 출생연도 아이디권한 0:관리자 1:일반직원 계좌상태 0:비밀번호 등록대상 1:활동 2:해지 비밀번호 오류회수 최종로그일자 최종거래시간 use Db_ebirthday; drop table table_log; create table if not exists Table_Log ( ldate char(10), ltime char(8), lname text, lsequ char(1), ltxid text, lrelt text, ltxip text, ldata text); select * from table_log where ldate="2024-03-11"; ALTER TABLE Table_Log DISCARD TABLESPACE; ALTER TABLE Table_Log IMPORT TABLESPACE; 거래일자 거래시간 거래종류 거래일련번호-같은 거래 1,2,3가지 존재함 거래아이디 거래결과 거래ip 거래별 자료 use Db_ebirthday; drop table Table_Balsong_Name_Key; create table if not exists Table_Balsong_Name_Key ( mdate char(10), mcont int(5), ldate char(10), lcont int(5), bdate char(10), bcont int(5), gdate char(7), gcont int(5)); insert into Table_Balsong_Name_Key(mdate,mcont,ldate,lcont,bdate,bcont,gdate,gcont)values("2023-04-01",0,"2023-04-01",0,"2023-04-01",0,"2023-04",0); select * from Table_Balsong_Name_Key; 멤버엑셀최종거래일 일련번호 카드발송최종거래일 일련번호 점검엑셀최종거래일 일련번호 상품등록최종거래일 일련번호 use Db_ebirthday; drop table Table_Balsong_Kakao_Data; create table if not exists Table_Balsong_Kakao_Data ( ksequ char(12), kpnam text, kjiid text, kgubn char(1), ktitl text, kdata text, kstat char(1), kbals char(1), kbdat char(10), kcont int(5), kjcnt int(3), primary key (ksequ)); use Db_ebirthday; select * from Table_Balsong_Kakao_Data; 고유번호:거래일자(10)+일련번호(2) 발송사진명 작성직원아이디 발송구분:1:문자 2:사진 제목 발송문자 발송유무:1:미발송 2:발송대상자 선정 작업-2 3:완료 4:발송필 발송대상:0:모두/1:소속휴대폰/2:카톡아이디/3:휴대폰번호 발송작업일자 발송 EXCEL 파일 건수 선택자료 디비작성-3 작업회수 use Db_ebirthday; drop table Table_Balsong_Last_Data; create table if not exists Table_Balsong_Last_Data ( lamemgoyuno char(14), lajakupno int(3), lamemid text, labname text, labalgoyuno char(12), laexcelno char(19), ladate char(10), latime char(8), lasdat char(10), lasosokphon char(13)); use Db_ebirthday; select * from Table_Balsong_Last_Data; 회원고유번호 작업회차 회원카톡아이디 발송이름 발송고유번호 작업엑셀번호 작업일자 작업시각 발송작업일 소속휴대폰번호 use Db_ebirthday; drop table Table_Slogan; create table if not exists Table_Slogan ( ssequ int(7) AUTO_INCREMENT, sslog text, sreid text, sdate char(10), sdatu char(10), sstat char(1), primary key (ssequ)); insert into Table_Slogan(sslog,sreid,sdate,sdatu,sstat)values("우리 아가에게 맛있는것을...","관리자","2023-04-01","2023-04-01","1"); select * from Table_Slogan; 슬로건일련번호:1번은 현재운영중인 슬로건 슬로건 등록직원아이디 등록일 사용시작일 현재사용여부:0:등록 1:현재사용 use Db_ebirthday; drop table Table_Munseo; drop table Table_Gongji; create table if not exists Table_Munseo ( msequ int(7) AUTO_INCREMENT, mdate char(10), mdlst char(10), mstat char(1), mtime char(8), mview char(1), mtxid varchar(50), mtxip varchar(20), mrcnt int(5), mtitl text, mmemo text, mname text, primary key (msequ)); create table if not exists Table_Gongji ( gsequ int(7), ggonj text, primary key (gsequ)); select * from Table_Munseo; select * from Table_Gongji; delete from Table_Munseo where msequ='12'; mdlst -> 문서의 유효기한 mview -> 공개/비공개 use Db_ebirthday; drop table Table_Delivery; create table if not exists Table_Delivery ( dsequ char(16), ddate char(10), dtime char(8), dstat char(1), dtxid text, dtxip text, dplaf text, dunsg char(14), dname text, dorde text, primary key (dsequ)); select * from Table_Delivery; dsequ yyyymmdd(판매일자)+일련번호(6)+매출별 일련번호(2) ddate 배송일자 dtime 배송등록시간 dstat 상태 1:배송완료 2:해당플랫폼에 자료 전송 3:반품 dplaf 판매행위 당사,쿠팡,네이버... dunsg 배송운송장번호 dname 배송업체 이름 CS대한통운... dorde 주문자 use Db_ebirthday; drop table Table_Consulting; create table if not exists Table_Consulting ( csequ char(16), cname text, cmsge text, primary key (csequ)); select * from Table_Consulting; csequ yyyymmdd(판매일자)+일련번호(6)+매출별 일련번호(2) cname 이름 cmsge 상담내용 use Db_ebirthday; drop table Table_Goods_Name; create table if not exists Table_Goods_Name ( gsequ char(12), gdate char(10), gtime char(8), gsort char(4), gname text, gonam text, gyagn text, gpath text, gstat char(1), gcond char(1), gpanm char(1), gamot int(7), gdlst char(10), gjaeg int(9), gsale int(9), gdclo char(10), primary key (gsequ)); select * from Table_Goods_Name; ALTER TABLE Table_Goods_Name ADD gdlst char(10) AFTER gamot; <----컬럼 추가 alter table Table_Goods_Name modify gsort char(4); <----필드 크기 변경 update Table_Goods_Name set gdlst='1111-11-11' where gsequ='K01202404052'; delete from Table_Goods_Name where gdate='2024-05-03'; desc Table_Goods_Name; - TABLE 구조 보기 ALTER TABLE Table_Goods_Name DISCARD TABLESPACE; ALTER TABLE Table_Goods_Name IMPORT TABLESPACE; gsequ 상품고유번호(대분류(1)+중분류(2)+YYYYMM(6)+일련번호(3) gdate 작성일자 gsort sort 기준 code gname 상품명 Full Name gonam 옛날 상품명 gyagn 상품명 단축명 gpath 상품 사진명 gstat 활동여부 0:활동 1:종료 2:품절 3:record 없음 gcond 판매조건 등록 0:등록 1:미등록 gpanm 개별판매여부 0:가능 1"불가능(타 제품에 속해 판매가능) gamot 단가 gdlst 최종판매일 gjaeg 재고량 gsale 판매량 gdclo 삭제일자 use Db_ebirthday; drop table Table_Goods_Sales; create table if not exists Table_Goods_Sales ( gsequ char(12), gdate char(10), gubun char(1), gsale int(5)); select * from Table_Goods_Sales; delete from Table_Goods_Sales where gdate='2024-05-10' and gsequ='A02202404033'; gsequ 상품고유번호(대분류(1)+중분류(2)+YYYYMM(6)+일련번호(3) gdate 최종거래일 gubun 0:재고등록 1:판매등록 gdata 판매건수 use Db_ebirthday; drop table Table_Goods_Code; create table if not exists Table_Goods_Code ( gdaeb char(1), gjcod char(2), gjung text); select * from Table_Goods_Code; ------------------------------------------------------------ use Db_ebirthday; drop table Table_Sales; create table if not exists Table_Sales ( ssequ char(16), sdate char(10), stime char(12), sorde text, stel1 text, stel2 text, srecm text, stel3 text, stel4 text, szipc char(5), saddr text, scadd text, ssadd text, sgood text, sgcod text, sopti text, soptc text, ssgoo text, sbmem text, scmsg text, ssury int(7), sdang int(9), samot int(9), sscnt int(3), stxid text, stxip text, splaf text, sjaku char(1), sstat char(1), scons char(1), syeya char(10), sdcan char(10), sdgyl char(10), smgyl text, smesg char(1), ssnet char(10), semse char(1), semai text, ssema text, sjseq char(16), primary key (ssequ)); select * from Table_Sales; select sstat from Table_Sales; select szipc,saddr,scadd,ssadd from Table_Sales; ssequ yyyymmdd(판매일자)+일련번호(6)+매출별 일련번호(2) sdate 입력일자 stime 입력시각 sorde 주문자 saddr 수취주소 scadd 추가주소-거리주소인경우 추가부분(인창동) ssadd 상세주소(101동1508호) sgood 상품명 sgcod 상품코드 sopti 상품옵션 ...+...+... soptc 상품옵션코드 ...(0)+...+(1)... 0:필수 1:선택 ssgoo 상품약어 sbmem 배송메모 scmsg 추가메세지 ssury 수량 sdang 단가 samot 순수매출액 sscnt 동일인 매출건수 stxid 입력 아이디 stxip 입력 아이피 splaf 판매행위 당사,쿠팡,네이버... sjaku 1:개별 2:일괄 sstat 0:초기등록 1:주문 2:제조 3;배송 4;결제 5:반품 6:취소 7:상담만한고객 8:전송 scons 1:상담 내역있음 syeya 배송예약일 sdcan 취소일자 sdgyl 결제예정일 smgyl 결제방법 smesg 메세지유무 1:메세지 있음 ssnet 사방넷 주문번호 semse email 발송유무 semai email번호 ssema 보낸 email 자료명 sjseq Table_Jangbaguni의 일련번호 use Db_ebirthday; drop table Table_Jangbaguni; create table if not exists Table_Jangbaguni ( jsequ char(16), jdate char(10), jtime char(12), jgood text, jgcod text, jopti text, joptc text, jsury int(7), jdang int(9), jamot int(9), jtxid text, jtxip text, jstat char(1), jyeya char(10), jsseq char(16), jmesg char(1), primary key (jsequ)); select * from Table_Jangbaguni; jstat 0:초기등록 1:자료옮김(To Table_Sales) jsseq Table_Sales의 일련번호 use Db_ebirthday; drop table Table_Message; create table if not exists Table_Message ( msequ char(16), mmsgH text, mmsgC text, mmsgL text, mmsgR text, mwhoS text, primary key (msequ)); select * from Table_Message; msequ yyyymmdd(판매일자)+일련번호(6)+매출별 일련번호(2) mmsgH 하트초콜릿 문구 mmsgC 카드메세지 mmsgL 왼쪽리본 메세지 mmsgR 오른쪽리본 메세지 mwhoS 누구로부터 use Db_ebirthday; drop table Table_Halil; create table if not exists Table_Halil ( hsequ char(10), hdate char(10), hrdat char(10), hcdat char(10), hdman text, hhali text, primary key (hsequ)); select * from Table_Halil; hsequ 일련번호(yyyymmdd+일련번호(2)) hdate 기준일자 hrdat 등록일자 hcdat 처리일자 hdman 담당자 hhali 할일 -------------------2024-02-05 부터 사용안함 use Db_ebirthday; drop table Table_Textfile_Name; create table if not exists Table_Textfile_Name ( tsequ char(16), tname text); select * from Table_Textfile_Name; tsequ yyyy-mm-ddHH:MM:SS tname 업체전송용 excel 이름 -------------------2024-02-05 부터 사용안함 drop table Table_Balsong_Name_Key; create table if not exists Table_Balsong_Name_Key ( mdate char(10), mcont int(5), ldate char(10), lcont int(5), bdate char(10), bcont int(5), gdate char(7), gcont int(5)); insert into Table_Balsong_Name_Key(mdate,mcont,ldate,lcont,bdate,bcont,gdate,gcont)values("2023-04-01",0,"2023-04-01",0,"2024-04-01",0,"2023-04",0); select * from Table_Balsong_Name_Key; drop table Table_Goods_Name; create table if not exists Table_Goods_Name ( gsequ char(12), gdate char(10), gtime char(8), gname text, gonam text, gyagn text, gpath text, gstat char(1), gcond char(1), gpanm char(1), gamot int(7), gjaeg int(9), gsale int(9), gdclo char(10), primary key (gsequ)); select * from Table_Goods_Name;