OLDBOY/skin/board/memo/db_update.php
<?php
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 '타입' AFTER wr_10 ");
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 COMMENT '종류' ");
if(!sql_query(" SELECT x2_ca4 from {$write_table} limit 1 ", false)) sql_query( "ALTER TABLE {$write_table} ADD x2_ca4 varchar(255) NOT NULL 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 COMMENT '버전' ");
if(!sql_query(" SELECT x2_pin from {$write_table} limit 1 ", false)) sql_query( "ALTER TABLE {$write_table} ADD x2_pin 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_point from {$write_table} limit 1 ", false)) sql_query( "ALTER TABLE {$write_table} ADD x2_point tinyint(1) NOT NULL DEFAULT '0' COMMENT '포인트' ");
if(!sql_query(" SELECT x2_end from {$write_table} limit 1 ", false)) sql_query( "ALTER TABLE {$write_table} ADD x2_end tinyint(1) NOT NULL DEFAULT '0' COMMENT '완료' ");
?>