GNU/skin/board/A950_jy_today/db_update.php
<?php
//sql_query( "ALTER TABLE {$write_table} DROP jy_day ");
//sql_query( "ALTER TABLE {$write_table} DROP jy_week ");
//sql_query( "ALTER TABLE {$write_table} DROP jy_month ");



if(!sql_query(" SELECT x2_ver from {$write_table} limit 1 ", false)) sql_query( "ALTER TABLE {$write_table} ADD x2_ver varchar(10) NOT NULL COMMENT '버전' AFTER wr_10 ");
if(!sql_query(" SELECT x2_car2 from {$write_table} limit 1 ", false)) sql_query( "ALTER TABLE {$write_table} ADD x2_car2 varchar(255) NOT NULL COMMENT '시즌' ");
if(!sql_query(" SELECT x2_tag from {$write_table} limit 1 ", false)) sql_query( "ALTER TABLE {$write_table} ADD x2_tag varchar(255) NOT NULL COMMENT '태그' ");
if(!sql_query(" SELECT x2_ca2 from {$write_table} limit 1 ", false)) sql_query( "ALTER TABLE {$write_table} ADD x2_ca2 varchar(255) NOT NULL COMMENT '2차 분류' ");
if(!sql_query(" SELECT x2_datetime from {$write_table} limit 1 ", false)) sql_query( "ALTER TABLE {$write_table} ADD x2_datetime varchar(255) NOT NULL COMMENT '종료 날짜' ");
if(!sql_query(" SELECT jy_1 from {$write_table} limit 1 ", false)) sql_query( "ALTER TABLE {$write_table} ADD jy_1 varchar(10) NOT NULL COMMENT '약' ");
if(!sql_query(" SELECT jy_2 from {$write_table} limit 1 ", false)) sql_query( "ALTER TABLE {$write_table} ADD jy_2 varchar(10) NOT NULL COMMENT '건강' ");
if(!sql_query(" SELECT jy_3 from {$write_table} limit 1 ", false)) sql_query( "ALTER TABLE {$write_table} ADD jy_3 varchar(10) NOT NULL COMMENT '며역력' ");
if(!sql_query(" SELECT jy_4 from {$write_table} limit 1 ", false)) sql_query( "ALTER TABLE {$write_table} ADD jy_4 varchar(10) NOT NULL COMMENT '청결' ");
if(!sql_query(" SELECT jy_5 from {$write_table} limit 1 ", false)) sql_query( "ALTER TABLE {$write_table} ADD jy_5 varchar(10) NOT NULL COMMENT '산책' ");
if(!sql_query(" SELECT jy_6 from {$write_table} limit 1 ", false)) sql_query( "ALTER TABLE {$write_table} ADD jy_6 varchar(10) NOT NULL COMMENT '명상' ");
if(!sql_query(" SELECT jy_7 from {$write_table} limit 1 ", false)) sql_query( "ALTER TABLE {$write_table} ADD jy_7 varchar(10) NOT NULL COMMENT '청소' ");
if(!sql_query(" SELECT jy_8 from {$write_table} limit 1 ", false)) sql_query( "ALTER TABLE {$write_table} ADD jy_8 varchar(10) NOT NULL COMMENT '정리' ");
if(!sql_query(" SELECT jy_9 from {$write_table} limit 1 ", false)) sql_query( "ALTER TABLE {$write_table} ADD jy_9 varchar(10) NOT NULL COMMENT '고양이' ");
if(!sql_query(" SELECT jy_10 from {$write_table} limit 1 ", false)) sql_query( "ALTER TABLE {$write_table} ADD jy_10 varchar(10) NOT NULL COMMENT '자산' ");
if(!sql_query(" SELECT jy_11 from {$write_table} limit 1 ", false)) sql_query( "ALTER TABLE {$write_table} ADD jy_11 varchar(10) NOT NULL COMMENT '쇼핑' ");
if(!sql_query(" SELECT jy_12 from {$write_table} limit 1 ", false)) sql_query( "ALTER TABLE {$write_table} ADD jy_12 varchar(10) NOT NULL COMMENT '학습' ");
if(!sql_query(" SELECT jy_13 from {$write_table} limit 1 ", false)) sql_query( "ALTER TABLE {$write_table} ADD jy_13 varchar(10) NOT NULL COMMENT '드라이브' ");
if(!sql_query(" SELECT jy_14 from {$write_table} limit 1 ", false)) sql_query( "ALTER TABLE {$write_table} ADD jy_14 varchar(10) NOT NULL COMMENT '여행' ");
if(!sql_query(" SELECT jy_15 from {$write_table} limit 1 ", false)) sql_query( "ALTER TABLE {$write_table} ADD jy_15 varchar(10) NOT NULL COMMENT '투자' ");
if(!sql_query(" SELECT jy_16 from {$write_table} limit 1 ", false)) sql_query( "ALTER TABLE {$write_table} ADD jy_16 varchar(10) NOT NULL COMMENT '미디어' ");
if(!sql_query(" SELECT jy_17 from {$write_table} limit 1 ", false)) sql_query( "ALTER TABLE {$write_table} ADD jy_17 varchar(10) NOT NULL COMMENT '미용' ");
if(!sql_query(" SELECT jy_18 from {$write_table} limit 1 ", false)) sql_query( "ALTER TABLE {$write_table} ADD jy_18 varchar(10) NOT NULL COMMENT '자전거' ");
if(!sql_query(" SELECT jy_19 from {$write_table} limit 1 ", false)) sql_query( "ALTER TABLE {$write_table} ADD jy_19 varchar(10) NOT NULL COMMENT '편의점' ");
if(!sql_query(" SELECT jy_20 from {$write_table} limit 1 ", false)) sql_query( "ALTER TABLE {$write_table} ADD jy_20 varchar(10) NOT NULL COMMENT '빼뽀' ");
if(!sql_query(" SELECT jy_21 from {$write_table} limit 1 ", false)) sql_query( "ALTER TABLE {$write_table} ADD jy_21 varchar(10) NOT NULL COMMENT '홍동' ");
if(!sql_query(" SELECT jy_22 from {$write_table} limit 1 ", false)) sql_query( "ALTER TABLE {$write_table} ADD jy_22 varchar(10) NOT NULL COMMENT '하나로마트' ");
if(!sql_query(" SELECT jy_23 from {$write_table} limit 1 ", false)) sql_query( "ALTER TABLE {$write_table} ADD jy_23 varchar(10) NOT NULL COMMENT '장곡' ");
if(!sql_query(" SELECT jy_day from {$write_table} limit 1 ", false)) sql_query( "ALTER TABLE {$write_table} ADD jy_day varchar(255) NOT NULL COMMENT '일 일 작업' ");
if(!sql_query(" SELECT jy_week from {$write_table} limit 1 ", false)) sql_query( "ALTER TABLE {$write_table} ADD jy_week varchar(255) NOT NULL COMMENT '요일 작업' ");
if(!sql_query(" SELECT jy_month from {$write_table} limit 1 ", false)) sql_query( "ALTER TABLE {$write_table} ADD jy_month varchar(255) NOT NULL COMMENT '월 작업' ");
if(!sql_query(" SELECT jy_target from {$write_table} limit 1 ", false)) sql_query( "ALTER TABLE {$write_table} ADD jy_target varchar(255) NOT NULL COMMENT '목표' ");
if(!sql_query(" SELECT jy_code from {$write_table} limit 1 ", false))   sql_query( "ALTER TABLE {$write_table} ADD jy_code MEDIUMTEXT NOT NULL COMMENT '핵심'  ");
if(!sql_query(" SELECT jy_plan from {$write_table} limit 1 ", false))   sql_query( "ALTER TABLE {$write_table} ADD jy_plan MEDIUMTEXT NOT NULL COMMENT '계획'  ");
if(!sql_query(" SELECT jy_btc from {$write_table} limit 1 ", false)) sql_query( "ALTER TABLE {$write_table} ADD jy_btc varchar(255) NOT NULL COMMENT '비트코인 시세' ");
if(!sql_query(" SELECT btc_datetime from {$write_table} limit 1 ", false)) sql_query( "ALTER TABLE {$write_table} ADD btc_datetime varchar(255) NOT NULL COMMENT '비트코인 시세 집계 날짜' ");
if(!sql_query(" SELECT x2_end from {$write_table} limit 1 ", false)) sql_query( "ALTER TABLE {$write_table} ADD x2_end varchar(255) NOT NULL COMMENT '하루 끝 체크' ");
if(!sql_query(" SELECT x2_datetime from {$write_table} limit 1 ", false)) sql_query( "ALTER TABLE {$write_table} ADD x2_datetime varchar(255) NOT NULL COMMENT '하루 끝 날짜' ");
if(!sql_query(" SELECT jy_required_b from {$write_table} limit 1 ", false)) sql_query( "ALTER TABLE {$write_table} ADD jy_required_b varchar(255) NOT NULL COMMENT '기본형 셀렉트' ");
if(!sql_query(" SELECT jy_required_s from {$write_table} limit 1 ", false)) sql_query( "ALTER TABLE {$write_table} ADD jy_required_s varchar(255) NOT NULL COMMENT '선택형 타이틀' ");
if(!sql_query(" SELECT jy_required_u from {$write_table} limit 1 ", false)) sql_query( "ALTER TABLE {$write_table} ADD jy_required_u varchar(255) NOT NULL COMMENT '선택형 URL' ");
?>