<?
if (!defined("_GNUBOARD_")) exit; // 개별 페이지 접근 불가

define("_DOCTYPE_", "NONE");

include "./$cfg[shop_dir]/admin/admin.lib.php";
include "./$cfg[shop_dir]/admin/shop.lib.php";

// 1.00 베타 3 -> 정식
$sql = " ALTER TABLE $cfg[table_order] ADD od_card_cancel INT NOT NULL AFTER od_card_quota ";
@mysql_query($sql);
$sql = " ALTER TABLE $cfg[table_shopcfg] ADD sc_member_use TINYINT NOT NULL AFTER sc_addr2 ";
@mysql_query($sql);
$sql = " ALTER TABLE $cfg[table_shopcfg] ADD sc_baesong_hope_use TINYINT NOT NULL AFTER sc_baesongbi ";
@mysql_query($sql);
$sql = " ALTER TABLE $cfg[table_shopcfg] ADD sc_baesong_hope_after TINYINT DEFAULT '2' NOT NULL AFTER sc_baesong_hope_use ";
@mysql_query($sql);
$sql = " ALTER TABLE $cfg[table_shopcfg] ADD sc_vat_use TINYINT NOT NULL AFTER sc_hoogi_baro ";
@mysql_query($sql);
$sql = " ALTER TABLE $cfg[table_order] ADD od_baesong_hope DATE NOT NULL AFTER od_status ";
@mysql_query($sql);
$sql = " ALTER TABLE $cfg[table_order] ADD od_bank_yejeongil DATE NOT NULL AFTER od_bank_ipgumja ";
@mysql_query($sql);
$sql = " ALTER TABLE $cfg[table_order] DROP od_settle ";
@mysql_query($sql);
$sql = " CREATE TABLE $cfg[table_vat] (
  od_id varchar(20) NOT NULL default '',
  mb_id varchar(20) NOT NULL default '',
  vt_saupjano varchar(10) NOT NULL default '',
  vt_sangho varchar(100) NOT NULL default '',
  vt_daepyo varchar(20) NOT NULL default '',
  vt_zip1 char(3) NOT NULL default '',
  vt_zip2 char(3) NOT NULL default '',
  vt_addr1 varchar(100) NOT NULL default '',
  vt_addr2 varchar(100) NOT NULL default '',
  vt_uptae varchar(100) NOT NULL default '',
  vt_jongmok varchar(100) NOT NULL default '',
  vt_datetime datetime NOT NULL default '0000-00-00 00:00:00',
  vt_ip varchar(15) NOT NULL default '',
  vt_confirm datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (od_id),
  KEY mb_id (mb_id)
) TYPE=MyISAM ";
@mysql_query($sql);


// 1.00 베타 2 -> 베타 3
$sql = " ALTER TABLE $cfg[table_item] ADD it_model VARCHAR( 255 ) NOT NULL AFTER it_brand ";
@mysql_query($sql);
$sql = " CREATE TABLE $cfg[table_estimate] (
  es_id int(11) NOT NULL auto_increment,
  es_subject varchar(255) NOT NULL default '',
  es_category text NOT NULL,
  es_include_head varchar(255) NOT NULL default '',
  es_include_tail varchar(255) NOT NULL default '',
  es_content_head text NOT NULL,
  es_content_tail text NOT NULL,
  PRIMARY KEY  (es_id)
) TYPE=MyISAM ";
@mysql_query($sql);

header("location:./?doc=$cfg[shop_dir]/admin/orderlist.php");
?>

이렇게 수정해 주신후

./?doc=shop/admin/index.php 를 실행하여 주십시오.

[이 게시물은 관리자님에 의해 2003-11-25 10:57:53 그샵질답(으)로 부터 이동됨]