OLDBOY/skin/board/webbot_news/db_update.php
<?php
if(!sql_query(" SELECT x2_run from {$write_table} limit 1 ", false)) sql_query( "ALTER TABLE {$write_table} ADD x2_run tinyint(1) NOT NULL DEFAULT '0' COMMENT '실행/중단' ");
if(!sql_query(" SELECT x2_korean_name from {$write_table} limit 1 ", false)) sql_query( "ALTER TABLE {$write_table} ADD x2_korean_name varchar(255) NOT NULL DEFAULT '' COMMENT '사이트명' ");
if(!sql_query(" SELECT x2_ver from {$write_table} limit 1 ", false)) sql_query( "ALTER TABLE {$write_table} ADD x2_ver varchar(255) NOT NULL DEFAULT '' 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 DEFAULT '' COMMENT '검색어' ");
if(!sql_query(" SELECT x2_ca3 from {$write_table} limit 1 ", false)) sql_query( "ALTER TABLE {$write_table} ADD x2_ca3 varchar(255) NOT NULL DEFAULT '' COMMENT '필터링어' ");
if(!sql_query(" SELECT x2_parsing from {$write_table} limit 1 ", false)) sql_query( "ALTER TABLE {$write_table} ADD x2_parsing varchar(50) NOT NULL DEFAULT '' COMMENT '파싱 종류' ");
if(!sql_query(" SELECT x2_parsing_code from {$write_table} limit 1 ", false)) sql_query( "ALTER TABLE {$write_table} ADD x2_parsing_code varchar(255) NOT NULL DEFAULT '' COMMENT '파싱 코드/규칙' ");
if(!sql_query(" SELECT x2_image from {$write_table} limit 1 ", false)) sql_query( "ALTER TABLE {$write_table} ADD x2_image tinyint(1) NOT NULL DEFAULT '0' COMMENT '이미지 수집' ");
if(!sql_query(" SELECT x2_video from {$write_table} limit 1 ", false)) sql_query( "ALTER TABLE {$write_table} ADD x2_video tinyint(1) NOT NULL DEFAULT '0' COMMENT '동영상 수집' ");
if(!sql_query(" SELECT x2_file from {$write_table} limit 1 ", false)) sql_query( "ALTER TABLE {$write_table} ADD x2_file tinyint(1) NOT NULL DEFAULT '0' COMMENT '파일 수집' ");
if(!sql_query(" SELECT x2_link from {$write_table} limit 1 ", false)) sql_query( "ALTER TABLE {$write_table} ADD x2_link tinyint(1) NOT NULL DEFAULT '0' COMMENT '링크 수집' ");
if(!sql_query(" SELECT x2_link2 from {$write_table} limit 1 ", false)) sql_query( "ALTER TABLE {$write_table} ADD x2_link2 tinyint(1) NOT NULL DEFAULT '0' COMMENT '링크 크롤링' ");
if(!sql_query(" SELECT x2_top from {$write_table} limit 1 ", false)) sql_query( "ALTER TABLE {$write_table} ADD x2_top tinyint(1) NOT NULL DEFAULT '0' COMMENT '우선 옵션' ");
if(!sql_query(" SELECT x2_label from {$write_table} limit 1 ", false)) sql_query( "ALTER TABLE {$write_table} ADD x2_label tinyint(1) NOT NULL DEFAULT '0' COMMENT '라벨 옵션' ");
if(!sql_query(" SELECT x2_core from {$write_table} limit 1 ", false)) sql_query( "ALTER TABLE {$write_table} ADD x2_core tinyint(1) NOT NULL DEFAULT '0' COMMENT '핵심 옵션' ");
if(!sql_query(" SELECT x2_memo_button from {$write_table} limit 1 ", false)) sql_query( "ALTER TABLE {$write_table} ADD x2_memo_button tinyint(1) NOT NULL DEFAULT '0' COMMENT '메모 버튼 토글' ");
if(!sql_query(" SELECT x2_memo_clean from {$write_table} limit 1 ", false)) sql_query( "ALTER TABLE {$write_table} ADD x2_memo_clean tinyint(1) NOT NULL DEFAULT '0' COMMENT '메모 삭제 토글' ");
if(!sql_query(" SELECT x2_memo from {$write_table} limit 1 ", false)) sql_query( "ALTER TABLE {$write_table} ADD x2_memo text 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 DEFAULT '' COMMENT '태그' ");
?>