답변 3개
채택된 답변
+20 포인트
11년 전
adm 폴더내에
sql_write.sql이란 파일이 있습니다.
</div>
<div><div>CREATE TABLE `__TABLE_NAME__` (</div>
<div> `wr_id` int(11) NOT NULL AUTO_INCREMENT,</div>
<div> `wr_num` int(11) NOT NULL DEFAULT '0',</div>
<div> `wr_reply` varchar(10) NOT NULL,</div>
<div> `wr_parent` int(11) NOT NULL DEFAULT '0',</div>
<div> `wr_is_comment` tinyint(4) NOT NULL DEFAULT '0',</div>
<div> `wr_comment` int(11) NOT NULL DEFAULT '0',</div>
<div> `wr_comment_reply` varchar(5) NOT NULL,</div>
<div> `ca_name` varchar(255) NOT NULL,</div>
<div> `wr_option` set('html1','html2','secret','mail') NOT NULL,</div>
<div> `wr_subject` varchar(255) NOT NULL,</div>
<div> `wr_content` text NOT NULL,</div>
<div> `wr_link1` text NOT NULL,</div>
<div> `wr_link2` text NOT NULL,</div>
<div> `wr_link1_hit` int(11) NOT NULL DEFAULT '0',</div>
<div> `wr_link2_hit` int(11) NOT NULL DEFAULT '0',</div>
<div> `wr_hit` int(11) NOT NULL DEFAULT '0',</div>
<div> `wr_good` int(11) NOT NULL DEFAULT '0',</div>
<div> `wr_nogood` int(11) NOT NULL DEFAULT '0',</div>
<div> `mb_id` varchar(20) NOT NULL,</div>
<div> `wr_password` varchar(255) NOT NULL,</div>
<div> `wr_name` varchar(255) NOT NULL,</div>
<div> `wr_email` varchar(255) NOT NULL,</div>
<div> `wr_homepage` varchar(255) NOT NULL,</div>
<div> `wr_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',</div>
<div> `wr_file` tinyint(4) NOT NULL DEFAULT '0',</div>
<div> `wr_last` varchar(19) NOT NULL,</div>
<div> `wr_ip` varchar(255) NOT NULL,</div>
<div> `wr_facebook_user` varchar(255) NOT NULL,</div>
<div> `wr_twitter_user` varchar(255) NOT NULL,</div>
<div> `wr_1` varchar(255) NOT NULL,</div>
<div> `wr_2` varchar(255) NOT NULL,</div>
<div> `wr_3` varchar(255) NOT NULL,</div>
<div> `wr_4` varchar(255) NOT NULL,</div>
<div> `wr_5` varchar(255) NOT NULL,</div>
<div> `wr_6` varchar(255) NOT NULL,</div>
<div> `wr_7` varchar(255) NOT NULL,</div>
<div> `wr_8` varchar(255) NOT NULL,</div>
<div> `wr_9` varchar(255) NOT NULL,</div>
<div> `wr_10` varchar(255) NOT NULL,</div>
<div> PRIMARY KEY (`wr_id`),</div>
<div> KEY `wr_num_reply_parent` (`wr_num`,`wr_reply`,`wr_parent`),</div>
<div> KEY `wr_is_comment` (`wr_is_comment`,`wr_id`)</div>
<div>) ENGINE=MyISAM DEFAULT CHARSET=utf8;</div></div>
<div>이부분에
wr_10 뒤부터 100까지 추가해 주시면 됩니다.
로그인 후 평가할 수 있습니다
댓글을 작성하려면 로그인이 필요합니다.
답변을 작성하려면 로그인이 필요합니다.
로그인