테이블을 실수로 삭제를 했습니다. 정보
테이블을 실수로 삭제를 했습니다.본문
오류 주소 : http://dvstory.co.kr/bbs/bbs/board.php?bo_table=draw
제가 phpmyadmin을 설치하고 거기로 들어가서 실수로 "g4_board"의 테이블을 삭제를 했습니다.
이거 어떻게 살리거나 되돌릴수 있는 방법이 없을까요?
알려주시면 넘 감사드리겠습니다.
제가 phpmyadmin을 설치하고 거기로 들어가서 실수로 "g4_board"의 테이블을 삭제를 했습니다.
이거 어떻게 살리거나 되돌릴수 있는 방법이 없을까요?
알려주시면 넘 감사드리겠습니다.
댓글 전체
DROP TABLE IF EXISTS `$g4[board_table]`;
CREATE TABLE `$g4[board_table]` (
`bo_table` varchar(20) NOT NULL default '',
`gr_id` varchar(255) NOT NULL default '',
`bo_subject` varchar(255) NOT NULL default '',
`bo_admin` varchar(255) NOT NULL default '',
`bo_list_level` tinyint(4) NOT NULL default '0',
`bo_read_level` tinyint(4) NOT NULL default '0',
`bo_write_level` tinyint(4) NOT NULL default '0',
`bo_reply_level` tinyint(4) NOT NULL default '0',
`bo_comment_level` tinyint(4) NOT NULL default '0',
`bo_upload_level` tinyint(4) NOT NULL default '0',
`bo_download_level` tinyint(4) NOT NULL default '0',
`bo_html_level` tinyint(4) NOT NULL default '0',
`bo_link_level` tinyint(4) NOT NULL default '0',
`bo_trackback_level` tinyint(4) NOT NULL default '0',
`bo_count_delete` tinyint(4) NOT NULL default '0',
`bo_count_modify` tinyint(4) NOT NULL default '0',
`bo_read_point` int(11) NOT NULL default '0',
`bo_write_point` int(11) NOT NULL default '0',
`bo_comment_point` int(11) NOT NULL default '0',
`bo_download_point` int(11) NOT NULL default '0',
`bo_use_category` tinyint(4) NOT NULL default '0',
`bo_category_list` text NOT NULL,
`bo_disable_tags` text NOT NULL,
`bo_use_sideview` tinyint(4) NOT NULL default '0',
`bo_use_file_content` tinyint(4) NOT NULL default '0',
`bo_use_secret` tinyint(4) NOT NULL default '0',
`bo_use_dhtml_editor` tinyint(4) NOT NULL default '0',
`bo_use_rss_view` tinyint(4) NOT NULL default '0',
`bo_use_comment` tinyint(4) NOT NULL default '0',
`bo_use_good` tinyint(4) NOT NULL default '0',
`bo_use_nogood` tinyint(4) NOT NULL default '0',
`bo_use_name` tinyint(4) NOT NULL default '0',
`bo_use_signature` tinyint(4) NOT NULL default '0',
`bo_use_ip_view` tinyint(4) NOT NULL default '0',
`bo_use_trackback` tinyint(4) NOT NULL default '0',
`bo_use_list_view` tinyint(4) NOT NULL default '0',
`bo_use_list_content` tinyint(4) NOT NULL default '0',
`bo_table_width` int(11) NOT NULL default '0',
`bo_subject_len` int(11) NOT NULL default '0',
`bo_page_rows` int(11) NOT NULL default '0',
`bo_new` int(11) NOT NULL default '0',
`bo_hot` int(11) NOT NULL default '0',
`bo_image_width` int(11) NOT NULL default '0',
`bo_skin` varchar(255) NOT NULL default '',
`bo_image_head` varchar(255) NOT NULL default '',
`bo_image_tail` varchar(255) NOT NULL default '',
`bo_include_head` varchar(255) NOT NULL default '',
`bo_include_tail` varchar(255) NOT NULL default '',
`bo_content_head` text NOT NULL,
`bo_content_tail` text NOT NULL,
`bo_insert_content` text NOT NULL,
`bo_gallery_cols` int(11) NOT NULL default '0',
`bo_upload_size` int(11) NOT NULL default '0',
`bo_reply_order` tinyint(4) NOT NULL default '0',
`bo_use_search` tinyint(4) NOT NULL default '0',
`bo_order_search` int(11) NOT NULL default '0',
`bo_count_write` int(11) NOT NULL default '0',
`bo_count_comment` int(11) NOT NULL default '0',
`bo_write_min` int(11) NOT NULL default '0',
`bo_write_max` int(11) NOT NULL default '0',
`bo_comment_min` int(11) NOT NULL default '0',
`bo_comment_max` int(11) NOT NULL default '0',
`bo_notice` text NOT NULL,
`bo_upload_count` tinyint(4) NOT NULL default '0',
`bo_use_email` tinyint(4) NOT NULL default '0',
`bo_sort_field` varchar(255) NOT NULL default '',
`bo_1_subj` varchar(255) NOT NULL default '',
`bo_2_subj` varchar(255) NOT NULL default '',
`bo_3_subj` varchar(255) NOT NULL default '',
`bo_4_subj` varchar(255) NOT NULL default '',
`bo_5_subj` varchar(255) NOT NULL default '',
`bo_6_subj` varchar(255) NOT NULL default '',
`bo_7_subj` varchar(255) NOT NULL default '',
`bo_8_subj` varchar(255) NOT NULL default '',
`bo_9_subj` varchar(255) NOT NULL default '',
`bo_10_subj` varchar(255) NOT NULL default '',
`bo_1` varchar(255) NOT NULL default '',
`bo_2` varchar(255) NOT NULL default '',
`bo_3` varchar(255) NOT NULL default '',
`bo_4` varchar(255) NOT NULL default '',
`bo_5` varchar(255) NOT NULL default '',
`bo_6` varchar(255) NOT NULL default '',
`bo_7` varchar(255) NOT NULL default '',
`bo_8` varchar(255) NOT NULL default '',
`bo_9` varchar(255) NOT NULL default '',
`bo_10` varchar(255) NOT NULL default '',
PRIMARY KEY (`bo_table`)
);
CREATE TABLE `$g4[board_table]` (
`bo_table` varchar(20) NOT NULL default '',
`gr_id` varchar(255) NOT NULL default '',
`bo_subject` varchar(255) NOT NULL default '',
`bo_admin` varchar(255) NOT NULL default '',
`bo_list_level` tinyint(4) NOT NULL default '0',
`bo_read_level` tinyint(4) NOT NULL default '0',
`bo_write_level` tinyint(4) NOT NULL default '0',
`bo_reply_level` tinyint(4) NOT NULL default '0',
`bo_comment_level` tinyint(4) NOT NULL default '0',
`bo_upload_level` tinyint(4) NOT NULL default '0',
`bo_download_level` tinyint(4) NOT NULL default '0',
`bo_html_level` tinyint(4) NOT NULL default '0',
`bo_link_level` tinyint(4) NOT NULL default '0',
`bo_trackback_level` tinyint(4) NOT NULL default '0',
`bo_count_delete` tinyint(4) NOT NULL default '0',
`bo_count_modify` tinyint(4) NOT NULL default '0',
`bo_read_point` int(11) NOT NULL default '0',
`bo_write_point` int(11) NOT NULL default '0',
`bo_comment_point` int(11) NOT NULL default '0',
`bo_download_point` int(11) NOT NULL default '0',
`bo_use_category` tinyint(4) NOT NULL default '0',
`bo_category_list` text NOT NULL,
`bo_disable_tags` text NOT NULL,
`bo_use_sideview` tinyint(4) NOT NULL default '0',
`bo_use_file_content` tinyint(4) NOT NULL default '0',
`bo_use_secret` tinyint(4) NOT NULL default '0',
`bo_use_dhtml_editor` tinyint(4) NOT NULL default '0',
`bo_use_rss_view` tinyint(4) NOT NULL default '0',
`bo_use_comment` tinyint(4) NOT NULL default '0',
`bo_use_good` tinyint(4) NOT NULL default '0',
`bo_use_nogood` tinyint(4) NOT NULL default '0',
`bo_use_name` tinyint(4) NOT NULL default '0',
`bo_use_signature` tinyint(4) NOT NULL default '0',
`bo_use_ip_view` tinyint(4) NOT NULL default '0',
`bo_use_trackback` tinyint(4) NOT NULL default '0',
`bo_use_list_view` tinyint(4) NOT NULL default '0',
`bo_use_list_content` tinyint(4) NOT NULL default '0',
`bo_table_width` int(11) NOT NULL default '0',
`bo_subject_len` int(11) NOT NULL default '0',
`bo_page_rows` int(11) NOT NULL default '0',
`bo_new` int(11) NOT NULL default '0',
`bo_hot` int(11) NOT NULL default '0',
`bo_image_width` int(11) NOT NULL default '0',
`bo_skin` varchar(255) NOT NULL default '',
`bo_image_head` varchar(255) NOT NULL default '',
`bo_image_tail` varchar(255) NOT NULL default '',
`bo_include_head` varchar(255) NOT NULL default '',
`bo_include_tail` varchar(255) NOT NULL default '',
`bo_content_head` text NOT NULL,
`bo_content_tail` text NOT NULL,
`bo_insert_content` text NOT NULL,
`bo_gallery_cols` int(11) NOT NULL default '0',
`bo_upload_size` int(11) NOT NULL default '0',
`bo_reply_order` tinyint(4) NOT NULL default '0',
`bo_use_search` tinyint(4) NOT NULL default '0',
`bo_order_search` int(11) NOT NULL default '0',
`bo_count_write` int(11) NOT NULL default '0',
`bo_count_comment` int(11) NOT NULL default '0',
`bo_write_min` int(11) NOT NULL default '0',
`bo_write_max` int(11) NOT NULL default '0',
`bo_comment_min` int(11) NOT NULL default '0',
`bo_comment_max` int(11) NOT NULL default '0',
`bo_notice` text NOT NULL,
`bo_upload_count` tinyint(4) NOT NULL default '0',
`bo_use_email` tinyint(4) NOT NULL default '0',
`bo_sort_field` varchar(255) NOT NULL default '',
`bo_1_subj` varchar(255) NOT NULL default '',
`bo_2_subj` varchar(255) NOT NULL default '',
`bo_3_subj` varchar(255) NOT NULL default '',
`bo_4_subj` varchar(255) NOT NULL default '',
`bo_5_subj` varchar(255) NOT NULL default '',
`bo_6_subj` varchar(255) NOT NULL default '',
`bo_7_subj` varchar(255) NOT NULL default '',
`bo_8_subj` varchar(255) NOT NULL default '',
`bo_9_subj` varchar(255) NOT NULL default '',
`bo_10_subj` varchar(255) NOT NULL default '',
`bo_1` varchar(255) NOT NULL default '',
`bo_2` varchar(255) NOT NULL default '',
`bo_3` varchar(255) NOT NULL default '',
`bo_4` varchar(255) NOT NULL default '',
`bo_5` varchar(255) NOT NULL default '',
`bo_6` varchar(255) NOT NULL default '',
`bo_7` varchar(255) NOT NULL default '',
`bo_8` varchar(255) NOT NULL default '',
`bo_9` varchar(255) NOT NULL default '',
`bo_10` varchar(255) NOT NULL default '',
PRIMARY KEY (`bo_table`)
);
