<?php
if(!defined('_GNUBOARD_')) exit;

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 '섹션 중분류' AFTER `wr_10` ", false);
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 '섹션 소분류' AFTER `x2_ca2` ", false);
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 '버전' AFTER `x2_ca3` ", false);
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 '태그' AFTER `x2_ver` ", false);
if(!sql_query(" SELECT wr_subject_kor from {$write_table} limit 1 ", false)) sql_query(" ALTER TABLE `{$write_table}` ADD `wr_subject_kor` varchar(255) NOT NULL DEFAULT '' COMMENT '한글명' AFTER `x2_tag` ", false);
if(!sql_query(" SELECT x2_content from {$write_table} limit 1 ", false)) sql_query(" ALTER TABLE `{$write_table}` ADD `x2_content` text NULL COMMENT '추가설명' AFTER `wr_subject_kor` ", false);
if(!sql_query(" SELECT x2_content_2 from {$write_table} limit 1 ", false)) sql_query(" ALTER TABLE `{$write_table}` ADD `x2_content_2` text NULL COMMENT '특이사항' AFTER `x2_content` ", false);
if(!sql_query(" SELECT x2_db_master from {$write_table} limit 1 ", false)) sql_query(" ALTER TABLE `{$write_table}` ADD `x2_db_master` varchar(255) NOT NULL DEFAULT '' COMMENT '원장 테이블' AFTER `x2_content_2` ", false);
if(!sql_query(" SELECT x2_db_table from {$write_table} limit 1 ", false)) sql_query(" ALTER TABLE `{$write_table}` ADD `x2_db_table` varchar(255) NOT NULL DEFAULT '' COMMENT '대장 테이블' AFTER `x2_db_master` ", false);
if(!sql_query(" SELECT x2_db_table_name from {$write_table} limit 1 ", false)) sql_query(" ALTER TABLE `{$write_table}` ADD `x2_db_table_name` varchar(255) NOT NULL DEFAULT '' COMMENT '대장명' AFTER `x2_db_table` ", false);
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 '우선' AFTER `x2_db_table_name` ", false);
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 '라벨' AFTER `x2_top` ", false);
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 '핵심' AFTER `x2_label` ", false);
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 '메모메뉴 열림' AFTER `x2_core` ", false);
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 '메모삭제 옵션' AFTER `x2_memo_button` ", false);
if(!sql_query(" SELECT x2_memo from {$write_table} limit 1 ", false)) sql_query(" ALTER TABLE `{$write_table}` ADD `x2_memo` text NULL COMMENT '메모' AFTER `x2_memo_clean` ", false);
?>