답변 1개
채택된 답변
+20 포인트
10년 전
g5_shop_item 테이블에 필드를 추가해야 가능합니다.
</p><p><code class="sql"><span class="syntax"><span class="syntax_alpha syntax_alpha_reservedWord">ALTER</span> <span class="syntax_alpha syntax_alpha_reservedWord">TABLE</span> <span class="syntax_quote syntax_quote_backtick">`g5_shop_item`</span> <span class="syntax_alpha syntax_alpha_reservedWord">ADD</span> <span class="syntax_quote syntax_quote_backtick">`it_img11`</span> <span class="syntax_alpha syntax_alpha_columnType">VARCHAR</span><span class="syntax_punct syntax_punct_bracket_open_round">(</span> <span class="syntax_digit syntax_digit_integer">255</span> <span class="syntax_punct syntax_punct_bracket_close_round">)</span> <span class="syntax_alpha syntax_alpha_reservedWord">CHARACTER</span> <span class="syntax_alpha syntax_alpha_reservedWord">SET</span> <span class="syntax_alpha syntax_alpha_charset">utf8</span> <span class="syntax_alpha syntax_alpha_reservedWord">COLLATE</span> <span class="syntax_alpha syntax_alpha_charset">utf8_general_ci</span> <span class="syntax_alpha syntax_alpha_reservedWord">NOT</span> <span class="syntax_alpha syntax_alpha_reservedWord">NULL</span> <span class="syntax_alpha syntax_alpha_columnAttrib">DEFAULT</span> <span class="syntax_quote syntax_quote_single">''</span> <span class="syntax_alpha syntax_alpha_reservedWord">AFTER</span> <span class="syntax_quote syntax_quote_backtick">`it_img10`</span> <span class="syntax_punct syntax_punct_listsep">,</span>
<span class="syntax_alpha syntax_alpha_reservedWord">ADD</span> <span class="syntax_quote syntax_quote_backtick">`it_img12`</span> <span class="syntax_alpha syntax_alpha_columnType">VARCHAR</span><span class="syntax_punct syntax_punct_bracket_open_round">(</span> <span class="syntax_digit syntax_digit_integer">255</span> <span class="syntax_punct syntax_punct_bracket_close_round">)</span> <span class="syntax_alpha syntax_alpha_reservedWord">CHARACTER</span> <span class="syntax_alpha syntax_alpha_reservedWord">SET</span> <span class="syntax_alpha syntax_alpha_charset">utf8</span> <span class="syntax_alpha syntax_alpha_reservedWord">COLLATE</span> <span class="syntax_alpha syntax_alpha_charset">utf8_general_ci</span> <span class="syntax_alpha syntax_alpha_reservedWord">NOT</span> <span class="syntax_alpha syntax_alpha_reservedWord">NULL</span> <span class="syntax_alpha syntax_alpha_columnAttrib">DEFAULT</span> <span class="syntax_quote syntax_quote_single">''</span> <span class="syntax_alpha syntax_alpha_reservedWord">AFTER</span> <span class="syntax_quote syntax_quote_backtick">`it_img11`</span> <span class="syntax_punct syntax_punct_listsep">,</span>
<span class="syntax_alpha syntax_alpha_reservedWord">ADD</span> <span class="syntax_quote syntax_quote_backtick">`it_img13`</span> <span class="syntax_alpha syntax_alpha_columnType">VARCHAR</span><span class="syntax_punct syntax_punct_bracket_open_round">(</span> <span class="syntax_digit syntax_digit_integer">255</span> <span class="syntax_punct syntax_punct_bracket_close_round">)</span> <span class="syntax_alpha syntax_alpha_reservedWord">CHARACTER</span> <span class="syntax_alpha syntax_alpha_reservedWord">SET</span> <span class="syntax_alpha syntax_alpha_charset">ucs2</span> <span class="syntax_alpha syntax_alpha_reservedWord">COLLATE</span> <span class="syntax_alpha syntax_alpha_charset">ucs2_general_ci</span> <span class="syntax_alpha syntax_alpha_reservedWord">NOT</span> <span class="syntax_alpha syntax_alpha_reservedWord">NULL</span> <span class="syntax_alpha syntax_alpha_columnAttrib">DEFAULT</span> <span class="syntax_quote syntax_quote_single">''</span> <span class="syntax_alpha syntax_alpha_reservedWord">AFTER</span> <span class="syntax_quote syntax_quote_backtick">`it_img12`</span> <span class="syntax_punct syntax_punct_listsep">,</span>
<span class="syntax_alpha syntax_alpha_reservedWord">ADD</span> <span class="syntax_quote syntax_quote_backtick">`it_img14`</span> <span class="syntax_alpha syntax_alpha_columnType">VARCHAR</span><span class="syntax_punct syntax_punct_bracket_open_round">(</span> <span class="syntax_digit syntax_digit_integer">255</span> <span class="syntax_punct syntax_punct_bracket_close_round">)</span> <span class="syntax_alpha syntax_alpha_reservedWord">CHARACTER</span> <span class="syntax_alpha syntax_alpha_reservedWord">SET</span> <span class="syntax_alpha syntax_alpha_charset">utf8</span> <span class="syntax_alpha syntax_alpha_reservedWord">COLLATE</span> <span class="syntax_alpha syntax_alpha_charset">utf8_general_ci</span> <span class="syntax_alpha syntax_alpha_reservedWord">NOT</span> <span class="syntax_alpha syntax_alpha_reservedWord">NULL</span> <span class="syntax_alpha syntax_alpha_columnAttrib">DEFAULT</span> <span class="syntax_quote syntax_quote_single">''</span> <span class="syntax_alpha syntax_alpha_reservedWord">AFTER</span> <span class="syntax_quote syntax_quote_backtick">`it_img13`</span> <span class="syntax_punct syntax_punct_listsep">,</span>
<span class="syntax_alpha syntax_alpha_reservedWord">ADD</span> <span class="syntax_quote syntax_quote_backtick">`it_img15`</span> <span class="syntax_alpha syntax_alpha_columnType">VARCHAR</span><span class="syntax_punct syntax_punct_bracket_open_round">(</span> <span class="syntax_digit syntax_digit_integer">255</span> <span class="syntax_punct syntax_punct_bracket_close_round">)</span> <span class="syntax_alpha syntax_alpha_reservedWord">CHARACTER</span> <span class="syntax_alpha syntax_alpha_reservedWord">SET</span> <span class="syntax_alpha syntax_alpha_charset">utf8</span> <span class="syntax_alpha syntax_alpha_reservedWord">COLLATE</span> <span class="syntax_alpha syntax_alpha_charset">utf8_general_ci</span> <span class="syntax_alpha syntax_alpha_reservedWord">NOT</span> <span class="syntax_alpha syntax_alpha_reservedWord">NULL</span> <span class="syntax_alpha syntax_alpha_columnAttrib">DEFAULT</span> <span class="syntax_quote syntax_quote_single">''</span> <span class="syntax_alpha syntax_alpha_reservedWord">AFTER</span> <span class="syntax_quote syntax_quote_backtick">`it_img14`</span> </span></code></p><p>
관리자단에서도 소스 수정은 해야 할 것 같네요. for문에서 10까지만 가져오게 되어 있네요..
로그인 후 평가할 수 있습니다
댓글을 작성하려면 로그인이 필요합니다.
답변을 작성하려면 로그인이 필요합니다.
로그인