제가 쓰는 db가
phpMyAdmin 2.6.4-pl4
이거네요 ㅎㄷㄷ
<?
$sub_menu = "100600";
include_once("./_common.php");

check_demo();

if ($is_admin != "super")
    alert("최고관리자만 접근 가능합니다.", $g4[path]);

$g4[title] = "업그레이드";
include_once("./admin.head.php");

$sql = "
CREATE TABLE `g4_memo_send` (
  `me_id` int(11) NOT NULL,
  `me_recv_mb_id` varchar(255) NOT NULL default '',
  `me_send_mb_id` varchar(255) NOT NULL default '',
  `me_send_datetime` datetime NOT NULL default '0000-00-00 00:00:00',
  `me_read_datetime` datetime NOT NULL default '0000-00-00 00:00:00',
  `me_memo` mediumtext NOT NULL,
  `me_file_local` varchar(255) NOT NULL,
  `me_file_server` varchar(255) NOT NULL,
  `me_subject` varchar(255) NOT NULL,
  `memo_type` varchar(255) NOT NULL,
  `memo_owner` varchar(255) NOT NULL,
  PRIMARY KEY  (`me_id`),
  KEY `me_recv_mb_id_idx` (`me_recv_mb_id`),
  KEY `me_send_mb_id_idx` (`me_send_mb_id`)
) ENGINE=MyISAM;
";
sql_query($sql);

$sql = "
CREATE TABLE `g4_memo_recv` (
  `me_id` int(11) NOT NULL auto_increment,
  `me_recv_mb_id` varchar(255) NOT NULL default '',
  `me_send_mb_id` varchar(255) NOT NULL default '',
  `me_send_datetime` datetime NOT NULL default '0000-00-00 00:00:00',
  `me_read_datetime` datetime NOT NULL default '0000-00-00 00:00:00',
  `me_memo` mediumtext NOT NULL,
  `me_file_local` varchar(255) NOT NULL,
  `me_file_server` varchar(255) NOT NULL,
  `me_subject` varchar(255) NOT NULL,
  `memo_type` varchar(255) NOT NULL,
  `memo_owner` varchar(255) NOT NULL,
  PRIMARY KEY  (`me_id`),
  KEY `me_recv_mb_id_idx` (`me_recv_mb_id`),
  KEY `me_send_mb_id_idx` (`me_send_mb_id`)
) ENGINE=MyISAM;
";
sql_query($sql);

$sql = "
CREATE TABLE `g4_memo_save` (
  `me_id` int(11) NOT NULL default '0',
  `me_recv_mb_id` varchar(255) NOT NULL default '',
  `me_send_mb_id` varchar(255) NOT NULL default '',
  `me_send_datetime` datetime NOT NULL default '0000-00-00 00:00:00',
  `me_read_datetime` datetime NOT NULL default '0000-00-00 00:00:00',
  `me_memo` mediumtext NOT NULL,
  `me_file_local` varchar(255) NOT NULL,
  `me_file_server` varchar(255) NOT NULL,
  `me_subject` varchar(255) NOT NULL,
  `memo_type` varchar(255) NOT NULL,
  `memo_owner` varchar(255) NOT NULL,
  PRIMARY KEY  (`me_id`),
  KEY `me_recv_mb_id_idx` (`me_recv_mb_id`),
  KEY `me_send_mb_id_idx` (`me_send_mb_id`)
) ENGINE=MyISAM;
";
sql_query($sql);

$sql = "
CREATE TABLE `g4_memo_spam` (
  `me_id` int(11) NOT NULL default '0',
  `me_recv_mb_id` varchar(255) NOT NULL default '',
  `me_send_mb_id` varchar(255) NOT NULL default '',
  `me_send_datetime` datetime NOT NULL default '0000-00-00 00:00:00',
  `me_read_datetime` datetime NOT NULL default '0000-00-00 00:00:00',
  `me_memo` mediumtext NOT NULL,
  `me_file_local` varchar(255) NOT NULL,
  `me_file_server` varchar(255) NOT NULL,
  `me_subject` varchar(255) NOT NULL,
  `memo_type` varchar(255) NOT NULL,
  `memo_owner` varchar(255) NOT NULL,
  PRIMARY KEY  (`me_id`),
  KEY `me_recv_mb_id_idx` (`me_recv_mb_id`),
  KEY `me_send_mb_id_idx` (`me_send_mb_id`)
) ENGINE=MyISAM;
";
sql_query($sql);

$sql = "
CREATE TABLE `g4_memo_notice` (
  `me_id` int(11) NOT NULL default '0' auto_increment,
  `me_recv_mb_id` varchar(255) NOT NULL default '',
  `me_send_mb_id` varchar(255) NOT NULL default '',
  `me_send_datetime` datetime NOT NULL default '0000-00-00 00:00:00',
  `me_read_datetime` datetime NOT NULL default '0000-00-00 00:00:00',
  `me_memo` mediumtext NOT NULL,
  `me_file_local` varchar(255) NOT NULL,
  `me_file_server` varchar(255) NOT NULL,
  `me_subject` varchar(255) NOT NULL,
  `memo_type` varchar(255) NOT NULL,
  `memo_owner` varchar(255) NOT NULL,
  PRIMARY KEY  (`me_id`),
  KEY `me_recv_mb_id_idx` (`me_recv_mb_id`),
  KEY `me_send_mb_id_idx` (`me_send_mb_id`)
) ENGINE=MyISAM;
";
sql_query($sql);

$sql = "
CREATE TABLE `g4_friend` (
  `fr_no` int(11) NOT NULL auto_increment,
  `mb_id` varchar(20) NOT NULL,
  `fr_id` varchar(20) NOT NULL,
  `fr_memo` varchar(255) default NULL,
  `fr_type` varchar(20) NOT NULL,
  `fr_datetime` datetime NOT NULL,
  PRIMARY KEY  (`fr_no`),
  UNIQUE KEY `mb_id` (`mb_id`,`fr_id`),
  KEY `fr_datetime` (`fr_datetime`),
  KEY `fr_relation` (`fr_type`)
) ENGINE=MyISAM;
";
sql_query($sql);

$sql = "
CREATE TABLE `g4_memo_group` (
`gr_id` INT( 11 ) NOT NULL ,
`mb_id` VARCHAR( 255 ) NOT NULL ,
`gr_name` VARCHAR( 255 ) NOT NULL ,
`gr_datetime` datetime NOT NULL
) ENGINE = MYISAM ;
";
sql_query($sql);

$sql = "
CREATE TABLE `g4_memo_group_member` (
  `gr_mb_no` int(11) NOT NULL auto_increment,
  `gr_id` int(11) NOT NULL,
  `gr_mb_id` varchar(255) NOT NULL,
  `gr_mb_datetime` datetime NOT NULL,
  PRIMARY KEY  (`gr_mb_no`)
) ENGINE=MyISAM;
";
sql_query($sql);

$sql = "
ALTER TABLE `g4_config` ADD `cf_memo_del_unread` INT( 11 ) NOT NULL AFTER `cf_10` ;
";
sql_query($sql);

$sql = "
ALTER TABLE `g4_config` ADD `cf_memo_delete_datetime` DATETIME NOT NULL AFTER `cf_memo_del` ;
";
sql_query($sql);

echo "UPGRADE 완료.";

include_once("./admin.tail.php");
?>

이걸 어떻게 수정 해야 db인식이 될까요>??
일일이 추가 하기에는 시간이...
그리고... 앞으로는 홈페이지를 만들지 않을거니까.. 마지막을 시도해 보구 싶내요.