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

// 기존 커스텀 컬럼 생성
if(!sql_query(" SELECT as_mid_cat from {$write_table} limit 1 ", false)) sql_query( "ALTER TABLE {$write_table} ADD as_mid_cat varchar(255) NOT NULL DEFAULT '' COMMENT '중분류' ");
if(!sql_query(" SELECT as_sub_cat from {$write_table} limit 1 ", false)) sql_query( "ALTER TABLE {$write_table} ADD as_sub_cat varchar(255) NOT NULL DEFAULT '' 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 '태그' ");
if(!sql_query(" SELECT as_memo from {$write_table} limit 1 ", false)) sql_query( "ALTER TABLE {$write_table} ADD as_memo text NOT NULL COMMENT '메모 내용' ");
if(!sql_query(" SELECT as_memo_del from {$write_table} limit 1 ", false)) sql_query( "ALTER TABLE {$write_table} ADD as_memo_del tinyint(1) NOT NULL DEFAULT '0' COMMENT '메모 삭제여부' ");
if(!sql_query(" SELECT as_extra_content from {$write_table} limit 1 ", false)) sql_query( "ALTER TABLE {$write_table} ADD as_extra_content text NOT NULL COMMENT '추가내용' ");

// 여분필드 wr_11 ~ wr_20 생성 (기본 varchar 타입으로 설정)
if(!sql_query(" SELECT wr_11 from {$write_table} limit 1 ", false)) sql_query( "ALTER TABLE {$write_table} ADD wr_11 varchar(255) NOT NULL DEFAULT '' COMMENT '여분필드 11' ");
if(!sql_query(" SELECT wr_12 from {$write_table} limit 1 ", false)) sql_query( "ALTER TABLE {$write_table} ADD wr_12 varchar(255) NOT NULL DEFAULT '' COMMENT '여분필드 12' ");
if(!sql_query(" SELECT wr_13 from {$write_table} limit 1 ", false)) sql_query( "ALTER TABLE {$write_table} ADD wr_13 varchar(255) NOT NULL DEFAULT '' COMMENT '여분필드 13' ");
if(!sql_query(" SELECT wr_14 from {$write_table} limit 1 ", false)) sql_query( "ALTER TABLE {$write_table} ADD wr_14 varchar(255) NOT NULL DEFAULT '' COMMENT '여분필드 14' ");
if(!sql_query(" SELECT wr_15 from {$write_table} limit 1 ", false)) sql_query( "ALTER TABLE {$write_table} ADD wr_15 varchar(255) NOT NULL DEFAULT '' COMMENT '여분필드 15' ");
if(!sql_query(" SELECT wr_16 from {$write_table} limit 1 ", false)) sql_query( "ALTER TABLE {$write_table} ADD wr_16 varchar(255) NOT NULL DEFAULT '' COMMENT '여분필드 16' ");
if(!sql_query(" SELECT wr_17 from {$write_table} limit 1 ", false)) sql_query( "ALTER TABLE {$write_table} ADD wr_17 varchar(255) NOT NULL DEFAULT '' COMMENT '여분필드 17' ");
if(!sql_query(" SELECT wr_18 from {$write_table} limit 1 ", false)) sql_query( "ALTER TABLE {$write_table} ADD wr_18 varchar(255) NOT NULL DEFAULT '' COMMENT '여분필드 18' ");
if(!sql_query(" SELECT wr_19 from {$write_table} limit 1 ", false)) sql_query( "ALTER TABLE {$write_table} ADD wr_19 varchar(255) NOT NULL DEFAULT '' COMMENT '여분필드 19' ");
if(!sql_query(" SELECT wr_20 from {$write_table} limit 1 ", false)) sql_query( "ALTER TABLE {$write_table} ADD wr_20 varchar(255) NOT NULL DEFAULT '' COMMENT '여분필드 20' ");

// 게시물 테이블($write_table)에 각 필드의 '제목'을 저장할 컬럼 1~20 생성
if(!sql_query(" SELECT wr_1_subj from {$write_table} limit 1 ", false)) sql_query( "ALTER TABLE {$write_table} ADD wr_1_subj varchar(255) NOT NULL DEFAULT '' COMMENT '1번필드 제목' ");
if(!sql_query(" SELECT wr_2_subj from {$write_table} limit 1 ", false)) sql_query( "ALTER TABLE {$write_table} ADD wr_2_subj varchar(255) NOT NULL DEFAULT '' COMMENT '2번필드 제목' ");
if(!sql_query(" SELECT wr_3_subj from {$write_table} limit 1 ", false)) sql_query( "ALTER TABLE {$write_table} ADD wr_3_subj varchar(255) NOT NULL DEFAULT '' COMMENT '3번필드 제목' ");
if(!sql_query(" SELECT wr_4_subj from {$write_table} limit 1 ", false)) sql_query( "ALTER TABLE {$write_table} ADD wr_4_subj varchar(255) NOT NULL DEFAULT '' COMMENT '4번필드 제목' ");
if(!sql_query(" SELECT wr_5_subj from {$write_table} limit 1 ", false)) sql_query( "ALTER TABLE {$write_table} ADD wr_5_subj varchar(255) NOT NULL DEFAULT '' COMMENT '5번필드 제목' ");
if(!sql_query(" SELECT wr_6_subj from {$write_table} limit 1 ", false)) sql_query( "ALTER TABLE {$write_table} ADD wr_6_subj varchar(255) NOT NULL DEFAULT '' COMMENT '6번필드 제목' ");
if(!sql_query(" SELECT wr_7_subj from {$write_table} limit 1 ", false)) sql_query( "ALTER TABLE {$write_table} ADD wr_7_subj varchar(255) NOT NULL DEFAULT '' COMMENT '7번필드 제목' ");
if(!sql_query(" SELECT wr_8_subj from {$write_table} limit 1 ", false)) sql_query( "ALTER TABLE {$write_table} ADD wr_8_subj varchar(255) NOT NULL DEFAULT '' COMMENT '8번필드 제목' ");
if(!sql_query(" SELECT wr_9_subj from {$write_table} limit 1 ", false)) sql_query( "ALTER TABLE {$write_table} ADD wr_9_subj varchar(255) NOT NULL DEFAULT '' COMMENT '9번필드 제목' ");
if(!sql_query(" SELECT wr_10_subj from {$write_table} limit 1 ", false)) sql_query( "ALTER TABLE {$write_table} ADD wr_10_subj varchar(255) NOT NULL DEFAULT '' COMMENT '10번필드 제목' ");
if(!sql_query(" SELECT wr_11_subj from {$write_table} limit 1 ", false)) sql_query( "ALTER TABLE {$write_table} ADD wr_11_subj varchar(255) NOT NULL DEFAULT '' COMMENT '11번필드 제목' ");
if(!sql_query(" SELECT wr_12_subj from {$write_table} limit 1 ", false)) sql_query( "ALTER TABLE {$write_table} ADD wr_12_subj varchar(255) NOT NULL DEFAULT '' COMMENT '12번필드 제목' ");
if(!sql_query(" SELECT wr_13_subj from {$write_table} limit 1 ", false)) sql_query( "ALTER TABLE {$write_table} ADD wr_13_subj varchar(255) NOT NULL DEFAULT '' COMMENT '13번필드 제목' ");
if(!sql_query(" SELECT wr_14_subj from {$write_table} limit 1 ", false)) sql_query( "ALTER TABLE {$write_table} ADD wr_14_subj varchar(255) NOT NULL DEFAULT '' COMMENT '14번필드 제목' ");
if(!sql_query(" SELECT wr_15_subj from {$write_table} limit 1 ", false)) sql_query( "ALTER TABLE {$write_table} ADD wr_15_subj varchar(255) NOT NULL DEFAULT '' COMMENT '15번필드 제목' ");
if(!sql_query(" SELECT wr_16_subj from {$write_table} limit 1 ", false)) sql_query( "ALTER TABLE {$write_table} ADD wr_16_subj varchar(255) NOT NULL DEFAULT '' COMMENT '16번필드 제목' ");
if(!sql_query(" SELECT wr_17_subj from {$write_table} limit 1 ", false)) sql_query( "ALTER TABLE {$write_table} ADD wr_17_subj varchar(255) NOT NULL DEFAULT '' COMMENT '17번필드 제목' ");
if(!sql_query(" SELECT wr_18_subj from {$write_table} limit 1 ", false)) sql_query( "ALTER TABLE {$write_table} ADD wr_18_subj varchar(255) NOT NULL DEFAULT '' COMMENT '18번필드 제목' ");
if(!sql_query(" SELECT wr_19_subj from {$write_table} limit 1 ", false)) sql_query( "ALTER TABLE {$write_table} ADD wr_19_subj varchar(255) NOT NULL DEFAULT '' COMMENT '19번필드 제목' ");
if(!sql_query(" SELECT wr_20_subj from {$write_table} limit 1 ", false)) sql_query( "ALTER TABLE {$write_table} ADD wr_20_subj varchar(255) NOT NULL DEFAULT '' COMMENT '20번필드 제목' ");
?>