<?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_run from {$write_table} limit 1 ", false)) sql_query(" ALTER TABLE `{$write_table}` ADD `x2_run` tinyint(1) NOT NULL DEFAULT '0' COMMENT '실행/중단' AFTER `x2_ca3` ", 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_run` ", false);
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 '한글명' AFTER `x2_ver` ", 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_korean_name` ", 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_tag` ", 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);

if(!sql_query(" SELECT x2_base_amount from {$write_table} limit 1 ", false)) sql_query(" ALTER TABLE `{$write_table}` ADD `x2_base_amount` varchar(255) NOT NULL DEFAULT '' COMMENT '기본금액' AFTER `x2_memo` ", false);
if(!sql_query(" SELECT x2_target_amount from {$write_table} limit 1 ", false)) sql_query(" ALTER TABLE `{$write_table}` ADD `x2_target_amount` varchar(255) NOT NULL DEFAULT '' COMMENT '목표금액' AFTER `x2_base_amount` ", false);
if(!sql_query(" SELECT x2_datetime from {$write_table} limit 1 ", false)) sql_query(" ALTER TABLE `{$write_table}` ADD `x2_datetime` datetime NULL COMMENT '완료일' AFTER `x2_target_amount` ", false);
if(!sql_query(" SELECT x2_current_asset from {$write_table} limit 1 ", false)) sql_query(" ALTER TABLE `{$write_table}` ADD `x2_current_asset` varchar(255) NOT NULL DEFAULT '' COMMENT '현재자산' AFTER `x2_datetime` ", false);
if(!sql_query(" SELECT x2_profit_amount from {$write_table} limit 1 ", false)) sql_query(" ALTER TABLE `{$write_table}` ADD `x2_profit_amount` varchar(255) NOT NULL DEFAULT '' COMMENT '수익금' AFTER `x2_current_asset` ", false);
if(!sql_query(" SELECT x2_profit_rate from {$write_table} limit 1 ", false)) sql_query(" ALTER TABLE `{$write_table}` ADD `x2_profit_rate` varchar(255) NOT NULL DEFAULT '' COMMENT '수익률' AFTER `x2_profit_amount` ", false);
if(!sql_query(" SELECT x2_reach_rate from {$write_table} limit 1 ", false)) sql_query(" ALTER TABLE `{$write_table}` ADD `x2_reach_rate` varchar(255) NOT NULL DEFAULT '' COMMENT '도달률' AFTER `x2_profit_rate` ", false);
if(!sql_query(" SELECT x2_target_type from {$write_table} limit 1 ", false)) sql_query(" ALTER TABLE `{$write_table}` ADD `x2_target_type` varchar(255) NOT NULL DEFAULT '' COMMENT '목표형태' AFTER `x2_target_amount` ", false);
if(!sql_query(" SELECT x2_unit_base from {$write_table} limit 1 ", false)) sql_query(" ALTER TABLE `{$write_table}` ADD `x2_unit_base` varchar(255) NOT NULL DEFAULT '' COMMENT '기본단위' AFTER `x2_target_type` ", false);
if(!sql_query(" SELECT x2_unit_add from {$write_table} limit 1 ", false)) sql_query(" ALTER TABLE `{$write_table}` ADD `x2_unit_add` varchar(255) NOT NULL DEFAULT '' COMMENT '추가단위' AFTER `x2_unit_base` ", false);
if(!sql_query(" SELECT x2_unit_max from {$write_table} limit 1 ", false)) sql_query(" ALTER TABLE `{$write_table}` ADD `x2_unit_max` varchar(255) NOT NULL DEFAULT '' COMMENT '최대단위' AFTER `x2_unit_add` ", false);
if(!sql_query(" SELECT x2_base_increase_rate from {$write_table} limit 1 ", false)) sql_query(" ALTER TABLE `{$write_table}` ADD `x2_base_increase_rate` varchar(255) NOT NULL DEFAULT '' COMMENT '기본증가율' AFTER `x2_unit_max` ", false);
if(!sql_query(" SELECT x2_max_increase_rate from {$write_table} limit 1 ", false)) sql_query(" ALTER TABLE `{$write_table}` ADD `x2_max_increase_rate` varchar(255) NOT NULL DEFAULT '' COMMENT '최대증가율' AFTER `x2_base_increase_rate` ", false);
if(!sql_query(" SELECT x2_trade_item from {$write_table} limit 1 ", false)) sql_query(" ALTER TABLE `{$write_table}` ADD `x2_trade_item` varchar(255) NOT NULL DEFAULT '' COMMENT '매매 종목' AFTER `x2_max_increase_rate` ", false);
if(!sql_query(" SELECT x2_text from {$write_table} limit 1 ", false)) sql_query(" ALTER TABLE `{$write_table}` ADD `x2_text` text NULL COMMENT '추가 설명' AFTER `x2_trade_item` ", false);
?>