GNU/skin/board/stock_schedule_dividend/db_update.php



<title>GNU/skin/board/stock_schedule_dividend/db_update.php</title>


<div class="header">GNU/skin/board/stock_schedule_dividend/db_update.php</div>
<pre>&lt;?php
if(!sql_query(&quot; SELECT x2_ca2           from {$write_table} limit 1 &quot;, false)) sql_query( &quot;ALTER TABLE {$write_table} ADD x2_ca2         varchar(255)   NOT NULL COMMENT &#039;섹션 중분류&#039; AFTER wr_10 &quot;);
if(!sql_query(&quot; SELECT x2_ca3           from {$write_table} limit 1 &quot;, false)) sql_query( &quot;ALTER TABLE {$write_table} ADD x2_ca3         varchar(255)   NOT NULL COMMENT &#039;섹션 소분류&#039; &quot;);
if(!sql_query(&quot; SELECT x2_ver           from {$write_table} limit 1 &quot;, false)) sql_query( &quot;ALTER TABLE {$write_table} ADD x2_ver         varchar(20)    NOT NULL COMMENT &#039;버전&#039; &quot;);
if(!sql_query(&quot; SELECT wr_subject_krw   from {$write_table} limit 1 &quot;, false)) sql_query( &quot;ALTER TABLE {$write_table} ADD wr_subject_krw varchar(50)    NOT NULL COMMENT &#039;종목 한글명&#039; &quot;);
if(!sql_query(&quot; SELECT x2_cycle         from {$write_table} limit 1 &quot;, false)) sql_query( &quot;ALTER TABLE {$write_table} ADD x2_cycle       varchar(10)    NOT NULL COMMENT &#039;갱신주기&#039; &quot;);
if(!sql_query(&quot; SELECT x2_tag           from {$write_table} limit 1 &quot;, false)) sql_query( &quot;ALTER TABLE {$write_table} ADD x2_tag         varchar(255)   NOT NULL COMMENT &#039;태그&#039; &quot;);
if(!sql_query(&quot; SELECT x2_force_button  from {$write_table} limit 1 &quot;, false)) sql_query( &quot;ALTER TABLE {$write_table} ADD x2_force_button tinyint(1)    NOT NULL DEFAULT &#039;0&#039; COMMENT &#039;작전 세력 버튼 토글&#039; &quot;);
if(!sql_query(&quot; SELECT x2_top           from {$write_table} limit 1 &quot;, false)) sql_query( &quot;ALTER TABLE {$write_table} ADD x2_top         tinyint(1)     NOT NULL DEFAULT &#039;0&#039; COMMENT &#039;우선 옵션&#039; &quot;);
if(!sql_query(&quot; SELECT x2_label         from {$write_table} limit 1 &quot;, false)) sql_query( &quot;ALTER TABLE {$write_table} ADD x2_label       tinyint(1)     NOT NULL DEFAULT &#039;0&#039; COMMENT &#039;라벨 옵션&#039; &quot;);
if(!sql_query(&quot; SELECT x2_core          from {$write_table} limit 1 &quot;, false)) sql_query( &quot;ALTER TABLE {$write_table} ADD x2_core        tinyint(1)     NOT NULL DEFAULT &#039;0&#039; COMMENT &#039;핵심 옵션&#039; &quot;);
if(!sql_query(&quot; SELECT x2_memo_button   from {$write_table} limit 1 &quot;, false)) sql_query( &quot;ALTER TABLE {$write_table} ADD x2_memo_button tinyint(1)     NOT NULL DEFAULT &#039;0&#039; COMMENT &#039;메모 버튼 토글&#039; &quot;);
if(!sql_query(&quot; SELECT x2_memo_clean    from {$write_table} limit 1 &quot;, false)) sql_query( &quot;ALTER TABLE {$write_table} ADD x2_memo_clean  tinyint(1)     NOT NULL DEFAULT &#039;0&#039; COMMENT &#039;메모 삭제 토글&#039; &quot;);
if(!sql_query(&quot; SELECT x2_memo          from {$write_table} limit 1 &quot;, false)) sql_query( &quot;ALTER TABLE {$write_table} ADD x2_memo        text NULL                           COMMENT &#039;메모 내용&#039; &quot;);
?&gt;</pre>