웹마스터 팁
제로보드 2.3 에서 2.5 변경사항 데이터 테이블 구조 변경사항 체크를 정리해봅니다.
2007.11.09 07:42
제로보드 2.3 에서 2.5 변경사항 데이터 테이블 구조 변경사항 체크를 정리해봅니다.
참고자료로 사용해주세요..
^^
기존 zbxe 2.3 테이블 리스트
--------------------------------------------------------------------------------
xe_action_forward
xe_addons
xe_admin_shortcut
xe_blog_category
xe_comments
xe_counter_log
xe_counter_status
xe_document_categories
xe_document_readed_log
xe_document_voted_log
xe_documents
xe_editor_autosave
xe_editor_components
xe_files
xe_layouts
xe_member
xe_member_denied_user_id
xe_member_friend
xe_member_friend_group
xe_member_group
xe_member_group_member
xe_member_join_form
xe_member_message
xe_member_scrap
xe_menu
xe_menu_item
xe_menu_layout
xe_module_categories
xe_module_config
xe_modules
xe_point
xe_poll
xe_poll_item
xe_poll_log
xe_poll_title
xe_sequence
xe_spamfilter_denied_ip
xe_spamfilter_denied_word
xe_spamfilter_log
xe_tags
xe_trackbacks
새로운 zbxe 2.5 테이블 리스트
--------------------------------------------------------------------------------
xe_action_forward
xe_addons
xe_admin_shortcut
xe_blog_category
xe_comments
xe_counter_log
xe_counter_status
xe_document_categories
xe_document_readed_log
xe_document_voted_log
xe_documents
xe_editor_autosave
xe_editor_components
xe_files
xe_layouts
xe_login_check
xe_member
xe_member_denied_user_id
xe_member_friend
xe_member_friend_group
xe_member_group
xe_member_group_member
xe_member_join_form
xe_member_message
xe_member_scrap
xe_menu
xe_menu_item
xe_menu_layout
xe_module_categories
xe_module_config
xe_modules
xe_point
xe_poll
xe_poll_item
xe_poll_log
xe_poll_title
xe_sequence
xe_spamfilter_denied_ip
xe_spamfilter_denied_word
xe_spamfilter_log
xe_tags
xe_trackbacks
--------------------------------------------------------------------------------
새로생긴 테이블은 xe_login_check 이네요.
기존 zbxe 2.3 의 테이블 구조를 보겠습니다.
--------------------------------------------------------------------------------
create table xe_action_forward (
act varchar(80) NOT NULL DEFAULT '',
module varchar(60) NOT NULL DEFAULT '',
type varchar(15) NOT NULL DEFAULT '',
UNIQUE idx_foward (act)
);
create table xe_addons (
addon varchar(250) NOT NULL DEFAULT '',
is_used char(1) NOT NULL DEFAULT 'Y',
extra_vars text,
regdate varchar(14),
PRIMARY KEY (addon),
KEY idx_regdate (regdate)
);
create table xe_admin_shortcut (
shortcut_srl bigint(11) NOT NULL DEFAULT '',
module varchar(250) NOT NULL DEFAULT '',
title varchar(250) NOT NULL DEFAULT '',
default_act varchar(250) NOT NULL DEFAULT '',
list_order bigint(11) NOT NULL DEFAULT '',
regdate varchar(14),
PRIMARY KEY (shortcut_srl),
UNIQUE uni_module (module),
KEY idx_list_order (list_order)
);
create table xe_blog_category (
category_srl bigint(12) NOT NULL DEFAULT '',
parent_srl bigint(12) NOT NULL DEFAULT '',
module_srl bigint(12) NOT NULL DEFAULT '',
name varchar(250),
expand char(1),
group_srls text,
listorder bigint(11),
regdate varchar(14),
PRIMARY KEY (category_srl),
KEY idx_module_srl (module_srl),
KEY idx_regdate (regdate)
);
create table xe_comments (
comment_srl bigint(11) NOT NULL DEFAULT '',
module_srl bigint(11) NOT NULL DEFAULT '',
document_srl bigint(11) NOT NULL DEFAULT '',
parent_srl bigint(11) NOT NULL DEFAULT '',
is_secret char(1) NOT NULL DEFAULT 'N',
content longtext NOT NULL DEFAULT '',
password varchar(60),
user_id varchar(80),
user_name varchar(80) NOT NULL DEFAULT '',
nick_name varchar(80) NOT NULL DEFAULT '',
member_srl bigint(11) NOT NULL DEFAULT '',
email_address varchar(250) NOT NULL DEFAULT '',
homepage varchar(250) NOT NULL DEFAULT '',
uploaded_count bigint(11) NOT NULL DEFAULT '',
regdate varchar(14),
last_update varchar(14),
ipaddress varchar(128) NOT NULL DEFAULT '',
list_order bigint(11) NOT NULL DEFAULT '',
PRIMARY KEY (comment_srl),
KEY idx_module_srl (module_srl),
KEY idx_document_srl (document_srl),
KEY idx_member_srl (member_srl),
KEY idx_uploaded_count (uploaded_count),
KEY idx_regdate (regdate),
KEY idx_last_update (last_update),
KEY idx_ipaddress (ipaddress),
KEY idx_list_order (list_order)
);
create table xe_counter_log (
ipaddress varchar(250) NOT NULL DEFAULT '',
regdate varchar(14),
user_agent varchar(250),
KEY idx_counter_log (ipaddress, regdate)
);
create table xe_counter_status (
regdate bigint(11) NOT NULL DEFAULT '',
unique_visitor bigint(11),
pageview bigint(11),
PRIMARY KEY (regdate)
);
create table xe_document_categories (
category_srl bigint(11) NOT NULL DEFAULT '',
module_srl bigint(11) NOT NULL DEFAULT '',
title varchar(250),
document_count bigint(11) NOT NULL DEFAULT '',
regdate varchar(14),
last_update varchar(14),
list_order bigint(11) NOT NULL DEFAULT '',
PRIMARY KEY (category_srl),
KEY idx_module_srl (module_srl),
KEY idx_regdate (regdate)
);
create table xe_document_readed_log (
document_srl bigint(11) NOT NULL DEFAULT '',
member_srl bigint(11) NOT NULL DEFAULT '',
ipaddress varchar(128) NOT NULL DEFAULT '',
regdate varchar(14),
KEY idx_document_srl (document_srl),
KEY idx_member_srl (member_srl),
KEY idx_ipaddress (ipaddress),
KEY idx_regdate (regdate)
);
create table xe_document_voted_log (
document_srl bigint(11) NOT NULL DEFAULT '',
member_srl bigint(11) NOT NULL DEFAULT '',
ipaddress varchar(128) NOT NULL DEFAULT '',
regdate varchar(14),
KEY idx_document_srl (document_srl),
KEY idx_member_srl (member_srl),
KEY idx_ipaddress (ipaddress),
KEY idx_regdate (regdate)
);
create table xe_documents (
document_srl bigint(11) NOT NULL DEFAULT '',
module_srl bigint(11) NOT NULL DEFAULT '+
'+
'',
category_srl bigint(11) NOT NULL DEFAULT '',
is_notice char(1) NOT NULL DEFAULT 'N',
is_secret char(1) NOT NULL DEFAULT 'N',
title varchar(250),
title_bold char(1) NOT NULL DEFAULT 'N',
title_color char(7),
content longtext NOT NULL DEFAULT '',
readed_count bigint(11) NOT NULL DEFAULT '',
voted_count bigint(11) NOT NULL DEFAULT '',
comment_count bigint(11) NOT NULL DEFAULT '',
trackback_count bigint(11) NOT NULL DEFAULT '',
uploaded_count bigint(11) NOT NULL DEFAULT '',
password varchar(60),
user_id varchar(80),
user_name varchar(80) NOT NULL DEFAULT '',
nick_name varchar(80) NOT NULL DEFAULT '',
member_srl bigint(11) NOT NULL DEFAULT '',
email_address varchar(250) NOT NULL DEFAULT '',
homepage varchar(250) NOT NULL DEFAULT '',
tags text,
extra_vars text,
regdate varchar(14),
last_update varchar(14),
last_updater varchar(80),
ipaddress varchar(128) NOT NULL DEFAULT '',
list_order bigint(11) NOT NULL DEFAULT '',
update_order bigint(11) NOT NULL DEFAULT '',
allow_comment char(1) NOT NULL DEFAULT 'Y',
lock_comment char(1) NOT NULL DEFAULT 'N',
allow_trackback char(1) NOT NULL DEFAULT 'Y',
notify_message char(1) NOT NULL DEFAULT 'N',
extra_vars1 text,
extra_vars2 text,
extra_vars3 text,
extra_vars4 text,
extra_vars5 text,
extra_vars6 text,
extra_vars7 text,
extra_vars8 text,
extra_vars9 text,
extra_vars10 text,
extra_vars11 text,
extra_vars12 text,
extra_vars13 text,
extra_vars14 text,
extra_vars15 text,
extra_vars16 text,
extra_vars17 text,
extra_vars18 text,
extra_vars19 text,
extra_vars20 text,
PRIMARY KEY (document_srl),
KEY idx_module_srl (module_srl),
KEY idx_category_srl (category_srl),
KEY idx_is_notice (is_notice),
KEY idx_is_secret (is_secret),
KEY idx_readed_count (readed_count),
KEY idx_voted_count (voted_count),
KEY idx_comment_count (comment_count),
KEY idx_trackback_count (trackback_count),
KEY idx_uploaded_count (uploaded_count),
KEY idx_member_srl (member_srl),
KEY idx_regdate (regdate),
KEY idx_last_update (last_update),
KEY idx_ipaddress (ipaddress),
KEY idx_list_order (list_order),
KEY idx_update_order (update_order),
KEY idx_module_list_order (module_srl, list_order),
KEY idx_module_update_order (module_srl, update_order),
KEY idx_module_readed_count (module_srl, readed_count),
KEY idx_module_voted_count (module_srl, voted_count)
);
create table xe_editor_autosave (
member_srl bigint(11),
ipaddress varchar(128),
document_srl bigint(11) NOT NULL DEFAULT '+
'',
title varchar(250),
content longtext NOT NULL DEFAULT '',
regdate varchar(14),
KEY idx_member_srl (member_srl),
KEY idx_ipaddress (ipaddress),
KEY idx_regdate (regdate)
);
create table xe_editor_components (
component_name varchar(250) NOT NULL DEFAULT '',
enabled char(1) NOT NULL DEFAULT 'N',
extra_vars text,
list_order bigint(11) NOT NULL DEFAULT '',
PRIMARY KEY (component_name),
KEY idx_list_order (list_order)
);
create table xe_files (
file_srl bigint(11) NOT NULL DEFAULT '',
upload_target_srl bigint(11) NOT NULL DEFAULT '',
sid varchar(60),
module_srl bigint(11) NOT NULL DEFAULT '',
member_srl bigint(11) NOT NULL DEFAULT '',
download_count bigint(11) NOT NULL DEFAULT '',
direct_download char(1) NOT NULL DEFAULT 'N',
source_filename varchar(250),
uploaded_filename varchar(250),
file_size bigint(11) NOT NULL DEFAULT '',
comment varchar(250),
isvalid char(1),
regdate varchar(14),
ipaddress varchar(128) NOT NULL DEFAULT '',
PRIMARY KEY (file_srl),
KEY idx_upload_target_srl (upload_target_srl),
KEY idx_module_srl (module_srl),
KEY idx_member_srl (member_srl),
KEY idx_download_count (download_count),
KEY idx_file_size (file_size),
KEY idx_is_valid (isvalid),
KEY idx_regdate (regdate),
KEY idx_ipaddress (ipaddress)
);
create table xe_layouts (
layout_srl bigint(12) NOT NULL DEFAULT '',
layout varchar(250),
title varchar(250),
extra_vars text,
layout_path varchar(250),
module_srl bigint(12),
regdate varchar(14),
PRIMARY KEY (layout_srl),
KEY idx_module_srl (module_srl),
KEY idx_regdate (regdate)
);
create table xe_member (
member_srl bigint(11) NOT NULL DEFAULT '',
user_id varchar(80) NOT NULL DEFAULT '',
email_address varchar(250) NOT NULL DEFAULT '',
password varchar(60) NOT NULL DEFAULT '',
email_id varchar(80) NOT NULL DEFAULT '',
email_host varchar(160),
user_name varchar(40) NOT NULL DEFAULT '',
nick_name varchar(40) NOT NULL DEFAULT '',
homepage varchar(250),
blog varchar(250),
birthday char(8),
allow_mailing char(1) NOT NULL DEFAULT 'Y',
allow_message char(1) NOT NULL DEFAULT 'Y',
denied char(1),
limit_date varchar(14),
regdate varchar(14),
last_login varchar(14),
is_admin char(1),
description text,
extra_vars text,
PRIMARY KEY (member_srl),
UNIQUE unique_user_id (user_id),
UNIQUE unique_email_address (email_address),
UNIQUE unique_nick_name (nick_name),
KEY idx_email_host (email_host),
KEY idx_allow_mailing (allow_mailing),
KEY idx_is_denied (denied),
KEY idx_regdate (regdate),
KEY idx_last_login (last_login),
KEY idx_is_admin (is_admin)
);
create table xe_member_denied_user_id (
user_id varchar(80) NOT NULL DEFAULT '',
regdate varchar(14),
description text,
list_order bigint(11) NOT NULL DEFAULT '',
PRIMARY KEY (user_id),
KEY idx_list_order (list_order)
);
create table xe_member_friend (
friend_srl bigint(11) NOT NULL DEFAULT '',
friend_group_srl bigint(11) NOT NULL DEFAULT '',
member_srl bigint(11) NOT NULL DEFAULT '',
target_srl bigint(11) NOT NULL DEFAULT '',
list_order bigint(11) NOT NULL DEFAULT '',
regdate varchar(14),
PRIMARY KEY (friend_srl),
KEY idx_friend_group_srl (friend_group_srl),
KEY idx_member_srl (member_srl),
KEY idx_target_srl (target_srl),
KEY idx_list_order (list_order)
);
create table xe_member_friend_group (
friend_group_srl bigint(11) NOT NULL DEFAULT '',
member_srl bigint(11) NOT NULL DEFAULT '',
title varchar(250) NOT NULL DEFAULT '',
regdate varchar(14),
PRIMARY KEY (friend_group_srl),
KEY index_owner_member_srl (member_srl)
);
create table xe_member_group (
group_srl bigint(11) NOT NULL DEFAULT '',
title varchar(80) NOT NULL DEFAULT '',
regdate varchar(14),
is_default char(1),
is_admin char(1),
description text,
PRIMARY KEY (group_srl),
UNIQUE uni_member_group_title (title)
);
create table xe_member_group_member (
group_srl bigint(11) NOT NULL DEFAULT '',
member_srl bigint(11) NOT NULL DEFAULT '',
regdate varchar(14),
KEY idx_group_member (group_srl, member_srl)
);
create table xe_member_join_form (
member_join_form_srl bigint(11) NOT NULL DEFAULT '',
column_type varchar(60) NOT NULL DEFAULT '',
column_name varchar(60) NOT NULL DEFAULT '',
column_title varchar(60) NOT NULL DEFAULT '',
required char(1) NOT NULL DEFAULT 'N',
default_value text,
is_active char(1),
description text,
list_order bigint(11) NOT NULL DEFAULT '1',
regdate varchar(14),
PRIMARY KEY (member_join_form_srl),
KEY idx_list_order (list_order)
);
create table xe_member_message (
message_srl bigint(11) NOT NULL DEFAULT '',
related_srl bigint(11) NOT NULL DEFAULT '+
'',
sender_srl bigint(11) NOT NULL DEFAULT '',
receiver_srl bigint(11) NOT NULL DEFAULT ''+
',
message_type char(1) NOT NULL DEFAULT '+
'S',
title varchar(250) NOT NULL DEFAULT '',
content text NOT NULL DEFAULT '',
readed char(1) NOT NULL DEFAULT 'N',
list_order bigint(11) NOT NULL DEFAULT '',
regdate varchar(14),
readed_date varchar(14),
PRIMARY KEY (message_srl),
KEY idx_related_srl (related_srl),
KEY idx_sender_srl (sender_srl),
KEY idx_receiver_srl (receiver_srl),
KEY idx_list_order (list_order)
);
create table xe_member_scrap (
member_srl bigint(11) NOT NULL DEFAULT '',
document_srl bigint(11) NOT NULL DEFAULT '',
title varchar(250),
user_id varchar(80),
user_name varchar(80) NOT NULL DEFAULT '',
nick_name varchar(80) NOT NULL DEFAULT '',
target_member_srl bigint(11) NOT NULL DEFAULT '',
regdate varchar(14),
list_order bigint(11) NOT NULL DEFAULT '',
UNIQUE unique_scrap (member_srl, document_srl),
KEY idx_regdate (regdate),
KEY idx_list_order (list_order)
);
create table xe_menu (
menu_srl bigint(12) NOT NULL DEFAULT '',
title varchar(250),
listorder bigint(11),
regdate varchar(14),
PRIMARY KEY (menu_srl),
KEY idx_regdate (regdate)
);
create table xe_menu_item (
menu_item_srl bigint(12) NOT NULL DEFAULT '',
parent_srl bigint(12) NOT NULL DEFAULT '',
menu_srl bigint(12) NOT NULL DEFAULT '',
name varchar(250),
url varchar(250),
open_window char(1),
expand char(1),
normal_btn varchar(255),
hover_btn varchar(255),
active_btn varchar(255),
group_srls text,
listorder bigint(11),
regdate varchar(14),
PRIMARY KEY (menu_item_srl),
KEY idx_menu_srl (menu_srl),
KEY idx_regdate (regdate)
);
create table xe_menu_layout (
menu_srl bigint(12) NOT NULL DEFAULT '',
layout_srl bigint(12) NOT NULL DEFAULT '',
PRIMARY KEY (menu_srl)
);
create table xe_module_categories (
module_category_srl bigint(11) NOT NULL DEFAULT '',
title varchar(250),
regdate varchar(14),
PRIMARY KEY (module_category_srl),
KEY idx_regdate (regdate)
);
create table xe_module_config (
module varchar(250) NOT NULL DEFAULT '',
config text,
regdate varchar(14),
PRIMARY KEY (module)
);
create table xe_modules (
module_srl bigint(11) NOT NULL DEFAULT '',
module varchar(80) NOT NULL DEFAULT '',
module_category_srl bigint(11),
layout_srl bigint(11),
menu_srl bigint(11),
mid varchar(40) NOT NULL DEFAULT '',
skin varchar(250),
browser_title varchar(250) NOT NULL DEFAULT '',
description text,
is_default char(1) NOT NULL DEFAULT 'N',
extra_vars text,
skin_vars text,
content longtext,
grants text,
admin_id text,
open_rss char(1) NOT NULL DEFAULT 'Y',
header_text text,
footer_text text,
regdate varchar(14),
PRIMARY KEY (module_srl),
UNIQUE unique_mid (mid),
KEY idx_module (module),
KEY idx_module_category (module_category_srl)
);
create table xe_point (
member_srl bigint(11) NOT NULL DEFAULT '',
point bigint(11) NOT NULL DEFAULT '',
PRIMARY KEY (member_srl),
KEY idx_point (point)
);
create table xe_poll (
poll_srl bigint(11) NOT NULL DEFAULT '',
stop_date varchar(14),
upload_target_srl bigint(11) NOT NULL DEFAULT '',
poll_count bigint(11) NOT NULL DEFAULT ''+
',
member_srl bigint(11) NOT NULL DEFAULT '',
ipaddress varchar(128) NOT NULL DEFAULT '',
regdate varchar(14),
list_order bigint(11) NOT NULL DEFAULT '',
PRIMARY KEY (poll_srl),
KEY idx_upload_target_srl (upload_target_srl),
KEY idx_member_srl (member_srl),
KEY idx_ipaddress (ipaddress),
KEY idx_regdate (regdate),
KEY idx_list_order (list_order)
);
create table xe_poll_item (
poll_item_srl bigint(11) NOT NULL DEFAULT '',
poll_srl bigint(11) NOT NULL DEFAULT '',
poll_index_srl bigint(11) NOT NULL DEFAULT '',
upload_target_srl bigint(11) NOT NULL DEFAULT '',
title varchar(250) NOT NULL DEFAULT '',
poll_count bigint(11) NOT NULL DEFAULT ''+
',
PRIMARY KEY (poll_item_srl),
KEY index_poll_srl (poll_srl),
KEY idx_poll_index_srl (poll_index_srl),
KEY idx_upload_target_srl (upload_target_srl)
);
create table xe_poll_log (
poll_srl bigint(11) NOT NULL DEFAULT '',
member_srl bigint(11) NOT NULL DEFAULT '',
ipaddress varchar(128) NOT NULL DEFAULT '',
regdate varchar(14),
KEY idx_poll_srl (poll_srl),
KEY idx_member_srl (member_srl),
KEY idx_ipaddress (ipaddress),
KEY idx_regdate (regdate)
);
create table xe_poll_title (
poll_srl bigint(11) NOT NULL DEFAULT '+
'',
poll_index_srl bigint(11) NOT NULL DEFAULT '',
title varchar(250) NOT NULL DEFAULT '',
checkcount bigint(11) NOT NULL DEFAULT '1',
poll_count bigint(11) NOT NULL DEFAULT '',
upload_target_srl bigint(11) NOT NULL DEFAULT '',
member_srl bigint(11) NOT NULL DEFAULT '',
ipaddress varchar(128) NOT NULL DEFAULT '',
regdate varchar(14),
list_order bigint(11) NOT NULL DEFAULT '',
KEY idx_poll_srl (poll_srl, poll_index_srl),
KEY idx_upload_target_srl (upload_target_srl),
KEY idx_member_srl (member_srl),
KEY idx_ipaddress (ipaddress),
KEY idx_regdate (regdate),
KEY idx_list_order (list_order)
);
create table xe_sequence (
seq bigint(64) auto_increment,
PRIMARY KEY (seq)
);
create table xe_spamfilter_denied_ip (
ipaddress varchar(250) NOT NULL DEFAULT '',
regdate varchar(14),
PRIMARY KEY (ipaddress),
KEY idx_regdate (regdate)
);
create table xe_spamfilter_denied_word (
word varchar(250) NOT NULL DEFAULT '',
regdate varchar(14),
PRIMARY KEY (word),
KEY idx_regdate (regdate)
);
create table xe_spamfilter_log (
spamfilter_log_srl bigint(11) NOT NULL DEFAULT '',
ipaddress varchar(250) NOT NULL DEFAULT '',
regdate varchar(14),
PRIMARY KEY (spamfilter_log_srl),
KEY idx_ipaddress (ipaddress),
KEY idx_regdate (regdate)
);
create table xe_tags (
tag_srl bigint(11) NOT NULL DEFAULT '',
module_srl bigint(11) NOT NULL DEFAULT '',
document_srl bigint(11) NOT NULL DEFAULT '',
tag varchar(240) NOT NULL DEFAULT '',
regdate varchar(14),
PRIMARY KEY (tag_srl),
KEY idx_module_srl (module_srl),
KEY idx_document_srl (document_srl),
KEY idx_regdate (regdate)
);
create table xe_trackbacks (
trackback_srl bigint(11) NOT NULL DEFAULT '',
module_srl bigint(11) NOT NULL DEFAULT '',
document_srl bigint(11) NOT NULL DEFAULT '',
url varchar(250) NOT NULL DEFAULT '',
title varchar(250) NOT NULL DEFAULT '',
blog_name varchar(250) NOT NULL DEFAULT '',
excerpt text NOT NULL DEFAULT '',
regdate varchar(14),
ipaddress varchar(128) NOT NULL DEFAULT '',
list_order bigint(11) NOT NULL DEFAULT ''+
',
PRIMARY KEY (trackback_srl),
KEY idx_module_srl (module_srl),
KEY idx_document_srl (document_srl),
KEY idx_regdate (regdate),
KEY idx_ipaddress (ipaddress),
KEY idx_list_order (list_order)
);
새로운 zbxe 2.5 의 테이블 구조를 보겠습니다.
--------------------------------------------------------------------------------
create table xe_action_forward (
act varchar(80) NOT NULL DEFAULT '',
module varchar(60) NOT NULL DEFAULT '',
type varchar(15) NOT NULL DEFAULT '',
UNIQUE idx_foward (act)
);
create table xe_addons (
addon varchar(250) NOT NULL DEFAULT '',
is_used char(1) NOT NULL DEFAULT 'Y',
extra_vars text,
regdate varchar(14),
PRIMARY KEY (addon),
KEY idx_regdate (regdate)
);
create table xe_admin_shortcut (
shortcut_srl bigint(11) NOT NULL DEFAULT '',
module varchar(250) NOT NULL DEFAULT '',
title varchar(250) NOT NULL DEFAULT '',
default_act varchar(250) NOT NULL DEFAULT '',
list_order bigint(11) NOT NULL DEFAULT '',
regdate varchar(14),
PRIMARY KEY (shortcut_srl),
UNIQUE uni_module (module),
KEY idx_list_order (list_order)
);
create table xe_blog_category (
category_srl bigint(12) NOT NULL DEFAULT '',
parent_srl bigint(12) NOT NULL DEFAULT '',
module_srl bigint(12) NOT NULL DEFAULT '',
name varchar(250),
expand char(1),
group_srls text,
listorder bigint(11),
regdate varchar(14),
PRIMARY KEY (category_srl),
KEY idx_module_srl (module_srl),
KEY idx_regdate (regdate)
);
create table xe_comments (
comment_srl bigint(11) NOT NULL DEFAULT '',
module_srl bigint(11) NOT NULL DEFAULT '',
document_srl bigint(11) NOT NULL DEFAULT '',
parent_srl bigint(11) NOT NULL DEFAULT '',
is_secret char(1) NOT NULL DEFAULT 'N',
content longtext NOT NULL DEFAULT '',
password varchar(60),
user_id varchar(80),
user_name varchar(80) NOT NULL DEFAULT '',
nick_name varchar(80) NOT NULL DEFAULT '',
member_srl bigint(11) NOT NULL DEFAULT '',
email_address varchar(250) NOT NULL DEFAULT '',
homepage varchar(250) NOT NULL DEFAULT '',
uploaded_count bigint(11) NOT NULL DEFAULT '',
regdate varchar(14),
last_update varchar(14),
ipaddress varchar(128) NOT NULL DEFAULT '',
list_order bigint(11) NOT NULL DEFAULT '',
PRIMARY KEY (comment_srl),
KEY idx_module_srl (module_srl),
KEY idx_document_srl (document_srl),
KEY idx_member_srl (member_srl),
KEY idx_uploaded_count (uploaded_count),
KEY idx_regdate (regdate),
KEY idx_last_update (last_update),
KEY idx_ipaddress (ipaddress),
KEY idx_list_order (list_order)
);
create table xe_counter_log (
ipaddress varchar(250) NOT NULL DEFAULT '',
regdate varchar(14),
user_agent varchar(250),
KEY idx_counter_log (ipaddress, regdate)
);
create table xe_counter_status (
regdate bigint(11) NOT NULL DEFAULT '',
unique_visitor bigint(11),
pageview bigint(11),
PRIMARY KEY (regdate)
);
create table xe_document_categories (
category_srl bigint(11) NOT NULL DEFAULT '',
module_srl bigint(11) NOT NULL DEFAULT '',
title varchar(250),
document_count bigint(11) NOT NULL DEFAULT '',
regdate varchar(14),
last_update varchar(14),
list_order bigint(11) NOT NULL DEFAULT '',
PRIMARY KEY (category_srl),
KEY idx_module_srl (module_srl),
KEY idx_regdate (regdate)
);
create table xe_document_readed_log (
document_srl bigint(11) NOT NULL DEFAULT '',
member_srl bigint(11) NOT NULL DEFAULT '',
ipaddress varchar(128) NOT NULL DEFAULT '',
regdate varchar(14),
KEY idx_document_srl (document_srl),
KEY idx_member_srl (member_srl),
KEY idx_ipaddress (ipaddress),
KEY idx_regdate (regdate)
);
create table xe_document_voted_log (
document_srl bigint(11) NOT NULL DEFAULT '',
member_srl bigint(11) NOT NULL DEFAULT '',
ipaddress varchar(128) NOT NULL DEFAULT '',
regdate varchar(14),
KEY idx_document_srl (document_srl),
KEY idx_member_srl (member_srl),
KEY idx_ipaddress (ipaddress),
KEY idx_regdate (regdate)
);
create table xe_documents (
document_srl bigint(11) NOT NULL DEFAULT '',
module_srl bigint(11) NOT NULL DEFAULT '',
category_srl bigint(11) NOT NULL DEFAULT '',
is_notice char(1) NOT NULL DEFAULT 'N',
is_secret char(1) NOT NULL DEFAULT 'N',
title varchar(250),
title_bold char(1) NOT NULL DEFAULT 'N',
title_color char(7),
content longtext NOT NULL DEFAULT '',
readed_count bigint(11) NOT NULL DEFAULT '',
voted_count bigint(11) NOT NULL DEFAULT '',
comment_count bigint(11) NOT NULL DEFAULT '+
'',
trackback_count bigint(11) NOT NULL DEFAULT '',
uploaded_count bigint(11) NOT NULL DEFAULT '',
password varchar(60),
user_id varchar(80),
user_name varchar(80) NOT NULL DEFAULT '',
nick_name varchar(80) NOT NULL DEFAULT '',
member_srl bigint(11) NOT NULL DEFAULT '',
email_address varchar(250) NOT NULL DEFAULT '',
homepage varchar(250) NOT NULL DEFAULT '',
tags text,
extra_vars text,
regdate varchar(14),
last_update varchar(14),
last_updater varchar(80),
ipaddress varchar(128) NOT NULL DEFAULT '',
list_order bigint(11) NOT NULL DEFAULT '',
update_order bigint(11) NOT NULL DEFAULT '',
allow_comment char(1) NOT NULL DEFAULT 'Y',
lock_comment char(1) NOT NULL DEFAULT 'N',
allow_trackback char(1) NOT NULL DEFAULT 'Y',
notify_message char(1) NOT NULL DEFAULT 'N',
extra_vars1 text,
extra_vars2 text,
extra_vars3 text,
extra_vars4 text,
extra_vars5 text,
extra_vars6 text,
extra_vars7 text,
extra_vars8 text,
extra_vars9 text,
extra_vars10 text,
extra_vars11 text,
extra_vars12 text,
extra_vars13 text,
extra_vars14 text,
extra_vars15 text,
extra_vars16 text,
extra_vars17 text,
extra_vars18 text,
extra_vars19 text,
extra_vars20 text,
PRIMARY KEY (document_srl),
KEY idx_module_srl (module_srl),
KEY idx_category_srl (category_srl),
KEY idx_is_notice (is_notice),
KEY idx_is_secret (is_secret),
KEY idx_readed_count (readed_count),
KEY idx_voted_count (voted_count),
KEY idx_comment_count (comment_count),
KEY idx_trackback_count (trackback_count),
KEY idx_uploaded_count (uploaded_count),
KEY idx_member_srl (member_srl),
KEY idx_regdate (regdate),
KEY idx_last_update (last_update),
KEY idx_ipaddress (ipaddress),
KEY idx_list_order (list_order),
KEY idx_update_order (update_order),
KEY idx_module_list_order (module_srl, list_order),
KEY idx_module_update_order (module_srl, update_order),
KEY idx_module_readed_count (module_srl, readed_count),
KEY idx_module_voted_count (module_srl, voted_count)
);
create table xe_editor_autosave (
member_srl bigint(11),
ipaddress varchar(128),
document_srl bigint(11) NOT NULL DEFAULT '',
title varchar(250),
content longtext NOT NULL DEFAULT '',
regdate varchar(14),
KEY idx_member_srl (member_srl),
KEY idx_ipaddress (ipaddress),
KEY idx_regdate (regdate)
);
create table xe_editor_components (
component_name varchar(250) NOT NULL DEFAULT '',
enabled char(1) NOT NULL DEFAULT 'N',
extra_vars text,
list_order bigint(11) NOT NULL DEFAULT '',
PRIMARY KEY (component_name),
KEY idx_list_order (list_order)
);
create table xe_files (
file_srl bigint(11) NOT NULL DEFAULT '',
upload_target_srl bigint(11) NOT NULL DEFAULT '+
'',
sid varchar(60),
module_srl bigint(11) NOT NULL DEFAULT '',
member_srl bigint(11) NOT NULL DEFAULT '',
download_count bigint(11) NOT NULL DEFAULT '',
direct_download char(1) NOT NULL DEFAULT 'N',
source_filename varchar(250),
uploaded_filename varchar(250),
file_size bigint(11) NOT NULL DEFAULT '',
comment varchar(250),
isvalid char(1),
regdate varchar(14),
ipaddress varchar(128) NOT NULL DEFAULT '',
PRIMARY KEY (file_srl),
KEY idx_upload_target_srl (upload_target_srl),
KEY idx_module_srl (module_srl),
KEY idx_member_srl (member_srl),
KEY idx_download_count (download_count),
KEY idx_file_size (file_size),
KEY idx_is_valid (isvalid),
KEY idx_regdate (regdate),
KEY idx_ipaddress (ipaddress)
);
create table xe_layouts (
layout_srl bigint(12) NOT NULL DEFAULT '',
layout varchar(250),
title varchar(250),
extra_vars text,
layout_path varchar(250),
module_srl bigint(12),
regdate varchar(14),
PRIMARY KEY (layout_srl),
KEY idx_module_srl (module_srl),
KEY idx_regdate (regdate)
);
create table xe_login_check (
member_srl bigint(11) NOT NULL DEFAULT '',
login_time varchar(14),
PRIMARY KEY (member_srl)
);
create table xe_member (
member_srl bigint(11) NOT NULL DEFAULT '',
user_id varchar(80) NOT NULL DEFAULT '',
email_address varchar(250) NOT NULL DEFAULT '',
password varchar(60) NOT NULL DEFAULT '',
email_id varchar(80) NOT NULL DEFAULT '',
email_host varchar(160),
user_name varchar(40) NOT NULL DEFAULT '',
nick_name varchar(40) NOT NULL DEFAULT '',
homepage varchar(250),
blog varchar(250),
birthday char(8),
allow_mailing char(1) NOT NULL DEFAULT 'Y',
allow_message char(1) NOT NULL DEFAULT 'Y',
denied char(1),
limit_date varchar(14),
regdate varchar(14),
last_login varchar(14),
is_admin char(1),
description text,
extra_vars text,
PRIMARY KEY (member_srl),
UNIQUE unique_user_id (user_id),
UNIQUE unique_email_address (email_address),
UNIQUE unique_nick_name (nick_name),
KEY idx_email_host (email_host),
KEY idx_allow_mailing (allow_mailing),
KEY idx_is_denied (denied),
KEY idx_regdate (regdate),
KEY idx_last_login (last_login),
KEY idx_is_admin (is_admin)
);
create table xe_member_denied_user_id (
user_id varchar(80) NOT NULL DEFAULT '',
regdate varchar(14),
description text,
list_order bigint(11) NOT NULL DEFAULT '',
PRIMARY KEY (user_id),
KEY idx_list_order (list_order)
);
create table xe_member_friend (
friend_srl bigint(11) NOT NULL DEFAULT '',
friend_group_srl bigint(11) NOT NULL DEFAULT '',
member_srl bigint(11) NOT NULL DEFAULT '',
target_srl bigint(11) NOT NULL DEFAULT '',
list_order bigint(11) NOT NULL DEFAULT '',
regdate varchar(14),
PRIMARY KEY (friend_srl),
KEY idx_friend_group_srl (friend_group_srl),
KEY idx_member_srl (member_srl),
KEY idx_target_srl (target_srl),
KEY idx_list_order (list_order)
);
create table xe_member_friend_group (
friend_group_srl bigint(11) NOT NULL DEFAULT '',
member_srl bigint(11) NOT NULL DEFAULT '',
title varchar(250) NOT NULL DEFAULT '',
regdate varchar(14),
PRIMARY KEY (friend_group_srl),
KEY index_owner_member_srl (member_srl)
);
create table xe_member_group (
group_srl bigint(11) NOT NULL DEFAULT '+
'',
title varchar(80) NOT NULL DEFAULT '',
regdate varchar(14),
is_default char(1),
is_admin char(1),
description text,
PRIMARY KEY (group_srl),
UNIQUE uni_member_group_title (title)
);
create table xe_member_group_member (
group_srl bigint(11) NOT NULL DEFAULT '',
member_srl bigint(11) NOT NULL DEFAULT '',
regdate varchar(14),
KEY idx_group_member (group_srl, member_srl)
);
create table xe_member_join_form (
member_join_form_srl bigint(11) NOT NULL DEFAULT '',
column_type varchar(60) NOT NULL DEFAULT '',
column_name varchar(60) NOT NULL DEFAULT '',
column_title varchar(60) NOT NULL DEFAULT ''+
',
required char(1) NOT NULL DEFAULT 'N',
default_value text,
is_active char(1),
description text,
list_order bigint(11) NOT NULL DEFAULT '1',
regdate varchar(14),
PRIMARY KEY (member_join_form_srl),
KEY idx_list_order (list_order)
);
create table xe_member_message (
message_srl bigint(11) NOT NULL DEFAULT '',
related_srl bigint(11) NOT NULL DEFAULT '',
sender_srl bigint(11) NOT NULL DEFAULT '',
receiver_srl bigint(11) NOT NULL DEFAULT '',
message_type char(1) NOT NULL DEFAULT 'S',
title varchar(250) NOT NULL DEFAULT '',
content text NOT NULL DEFAULT '',
readed char(1) NOT NULL DEFAULT 'N',
list_order bigint(11) NOT NULL DEFAULT '',
regdate varchar(14),
readed_date varchar(14),
PRIMARY KEY (message_srl),
KEY idx_related_srl (related_srl),
KEY idx_sender_srl (sender_srl),
KEY idx_receiver_srl (receiver_srl),
KEY idx_list_order (list_order)
);
create table xe_member_scrap (
member_srl bigint(11) NOT NULL DEFAULT '',
document_srl bigint(11) NOT NULL DEFAULT '',
title varchar(250),
user_id varchar(80),
user_name varchar(80) NOT NULL DEFAULT '',
nick_name varchar(80) NOT NULL DEFAULT '',
target_member_srl bigint(11) NOT NULL DEFAULT '',
regdate varchar(14),
list_order bigint(11) NOT NULL DEFAULT '',
UNIQUE unique_scrap (member_srl, document_srl),
KEY idx_regdate (regdate),
KEY idx_list_order (list_order)
);
create table xe_menu (
menu_srl bigint(12) NOT NULL DEFAULT '',
title varchar(250),
listorder bigint(11),
regdate varchar(14),
PRIMARY KEY (menu_srl),
KEY idx_regdate (regdate)
);
create table xe_menu_item (
menu_item_srl bigint(12) NOT NULL DEFAULT '',
parent_srl bigint(12) NOT NULL DEFAULT '',
menu_srl bigint(12) NOT NULL DEFAULT '',
name varchar(250),
url varchar(250),
open_window char(1),
expand char(1),
normal_btn varchar(255),
hover_btn varchar(255),
active_btn varchar(255),
group_srls text,
listorder bigint(11),
regdate varchar(14),
PRIMARY KEY (menu_item_srl),
KEY idx_menu_srl (menu_srl),
KEY idx_regdate (regdate)
);
create table xe_menu_layout (
menu_srl bigint(12) NOT NULL DEFAULT '',
layout_srl bigint(12) NOT NULL DEFAULT '',
PRIMARY KEY (menu_srl)
);
create table xe_module_categories (
module_category_srl bigint(11) NOT NULL DEFAULT '',
title varchar(250),
regdate varchar(14),
PRIMARY KEY (module_category_srl),
KEY idx_regdate (regdate)
);
create table xe_module_config (
module varchar(250) NOT NULL DEFAULT '',
config text,
regdate varchar(14),
PRIMARY KEY (module)
);
create table xe_modules (
module_srl bigint(11) NOT NULL DEFAULT '',
module varchar(80) NOT NULL DEFAULT '',
module_category_srl bigint(11),
layout_srl bigint(11),
menu_srl bigint(11),
mid varchar(40) NOT NULL DEFAULT '',
skin varchar(250),
browser_title varchar(250) NOT NULL DEFAULT '',
description text,
is_default char(1) NOT NULL DEFAULT 'N',
extra_vars text,
skin_vars text,
content longtext,
grants text,
admin_id text,
open_rss char(1) NOT NULL DEFAULT 'Y',
header_text text,
footer_text text,
regdate varchar(14),
PRIMARY KEY (module_srl),
UNIQUE unique_mid (mid),
KEY idx_module (module),
KEY idx_module_category (module_category_srl)
);
create table xe_point (
member_srl bigint(11) NOT NULL DEFAULT '',
point bigint(11) NOT NULL DEFAULT '',
PRIMARY KEY (member_srl),
KEY idx_point (point)
);
create table xe_poll (
poll_srl bigint(11) NOT NULL DEFAULT '',
stop_date varchar(14),
upload_target_srl bigint(11) NOT NULL DEFAULT '',
poll_count bigint(11) NOT NULL DEFAULT '',
member_srl bigint(11) NOT NULL DEFAULT '',
ipaddress varchar(128) NOT NULL DEFAULT '',
regdate varchar(14),
list_order bigint(11) NOT NULL DEFAULT '',
PRIMARY KEY (poll_srl),
KEY idx_upload_target_srl (upload_target_srl),
KEY idx_member_srl (member_srl),
KEY idx_ipaddress (ipaddress),
KEY idx_regdate (regdate),
KEY idx_list_order (list_order)
);
create table xe_poll_item (
poll_item_srl bigint(11) NOT NULL DEFAULT '',
poll_srl bigint(11) NOT NULL DEFAULT '',
poll_index_srl bigint(11) NOT NULL DEFAULT '',
upload_target_srl bigint(11) NOT NULL DEFAULT '',
title varchar(250) NOT NULL DEFAULT '',
poll_count bigint(11) NOT NULL DEFAULT '',
PRIMARY KEY (poll_item_srl),
KEY index_poll_srl (poll_srl),
KEY idx_poll_index_srl (poll_index_srl),
KEY idx_upload_target_srl (upload_target_srl)
);
create table xe_poll_log (
poll_srl bigint(11) NOT NULL DEFAULT '',
member_srl bigint(11) NOT NULL DEFAULT '',
ipaddress varchar(128) NOT NULL DEFAULT '',
regdate varchar(14),
KEY idx_poll_srl (poll_srl),
KEY idx_member_srl (member_srl),
KEY idx_ipaddress (ipaddress),
KEY idx_regdate (regdate)
);
create table xe_poll_title (
poll_srl bigint(11) NOT NULL DEFAULT '',
poll_index_srl bigint(11) NOT NULL DEFAULT '',
title varchar(250) NOT NULL DEFAULT '',
checkcount bigint(11) NOT NULL DEFAULT '+
'1',
poll_count bigint(11) NOT NULL DEFAULT '',
upload_target_srl bigint(11) NOT NULL DEFAULT '',
member_srl bigint(11) NOT NULL DEFAULT '',
ipaddress varchar(128) NOT NULL DEFAULT '',
regdate varchar(14),
list_order bigint(11) NOT NULL DEFAULT '',
KEY idx_poll_srl (poll_srl, poll_index_srl),
KEY idx_upload_target_srl (upload_target_srl),
KEY idx_member_srl (member_srl),
KEY idx_ipaddress (ipaddress),
KEY idx_regdate (regdate),
KEY idx_list_order (list_order)
);
create table xe_sequence (
seq bigint(64) auto_increment,
PRIMARY KEY (seq)
);
create table xe_spamfilter_denied_ip (
ipaddress varchar(250) NOT NULL DEFAULT '',
regdate varchar(14),
PRIMARY KEY (ipaddress),
KEY idx_regdate (regdate)
);
create table xe_spamfilter_denied_word (
word varchar(250) NOT NULL DEFAULT '',
regdate varchar(14),
PRIMARY KEY (word),
KEY idx_regdate (regdate)
);
create table xe_spamfilter_log (
spamfilter_log_srl bigint(11) NOT NULL DEFAULT '',
ipaddress varchar(250) NOT NULL DEFAULT '',
regdate varchar(14),
PRIMARY KEY (spamfilter_log_srl),
KEY idx_ipaddress (ipaddress),
KEY idx_regdate (regdate)
);
create table xe_tags (
tag_srl bigint(11) NOT NULL DEFAULT '',
module_srl bigint(11) NOT NULL DEFAULT '',
document_srl bigint(11) NOT NULL DEFAULT '',
tag varchar(240) NOT NULL DEFAULT '',
regdate varchar(14),
PRIMARY KEY (tag_srl),
KEY idx_module_srl (module_srl),
KEY idx_document_srl (document_srl),
KEY idx_regdate (regdate)
);
create table xe_trackbacks (
trackback_srl bigint(11) NOT NULL DEFAULT ''+
',
module_srl bigint(11) NOT NULL DEFAULT '',
document_srl bigint(11) NOT NULL DEFAULT '',
url varchar(250) NOT NULL DEFAULT '',
title varchar(250) NOT NULL DEFAULT '',
blog_name varchar(250) NOT NULL DEFAULT '',
excerpt text NOT NULL DEFAULT '',
regdate varchar(14),
ipaddress varchar(128) NOT NULL DEFAULT '',
list_order bigint(11) NOT NULL DEFAULT '',
PRIMARY KEY (trackback_srl),
KEY idx_module_srl (module_srl),
KEY idx_document_srl (document_srl),
KEY idx_regdate (regdate),
KEY idx_ipaddress (ipaddress),
KEY idx_list_order (list_order)
);
- [2007/11/09] 웹마스터 팁 제로보드 2.3 에서 2.5 업그레이드 방법
댓글 4
-
흐음
2007.11.09 11:47
-
도토리나무
2007.11.09 13:30
네 이내용은 mysql 에 접속했을 때 보이는 것입니다.
^^ -
xe촙5
2007.11.09 17:34
우와~ 추천 한방!
뭔지 모르지만 감복했습니다.
--------------
한가지 궁금한 점.
제가 extra_vars10 에 'Y'라는 문자를 집어 넣었는데
Y가 있는 문서들만 골라서 쿼리해 낼려면 어떻게 해야 하나요?
질답에 올렸었는데 답이 없네요
도토리님에게 쪽지 보낼께요 -
도토리나무
2007.11.10 10:38
글을 보시는 분들께 죄송합니다.
이 글은 팁이 아니고
제로보드가 업그레이드 되면서 혹시 필요할까 해서
구조가 변경된것을 참고 자료로 사용될 수 있어서
올려놓은 것입니다.
그냥 참고자료로 필요하신 유저님들만 참고자료로 사용해주시면
감사하겠습니다.
^^
| 제목 | 글쓴이 | 날짜 |
|---|---|---|
| SVN 의 사용 방법 [3] | preware | 2007.11.06 |
| 완전 초보도 확장 변수를 이용해 게시판 개조할수잇다!! [4] | 쿤． | 2007.11.06 |
| (08년 1월2일수정)0.2.3이후 최근글에 공지사항을 제외시키고자할 경우 [11] | 포레버 | 2007.11.07 |
| 제로보드4, xe 버전 바이러스에 대한 질문 [1] | 투자혁명 | 2009.04.15 |
| 제로보드 2.3 에서 2.5 변경사항 데이터 테이블 구조 변경사항 체크를 정리해봅니다. [4] | 도토리나무 | 2007.11.09 |
| 제로보드 2.3 에서 2.5 업그레이드 방법 | 도토리나무 | 2007.11.09 |
| 첨부파일 기능에 대한 짧은 정보 [3] | 고라리 | 2007.11.09 |
| 외부 문서에서 회원 정보 얻는 방법 [11] | 소마세월 | 2007.11.10 |
| 통합검색 버그 style 수정 [2] | 소마세월 | 2007.11.11 |
| 알바트로스 적용후 검색하는 곳에 댓글과 태그 검색 업션 넣기 [1] | 비밀얌 | 2007.11.13 |
| [수정]업로드된 그림 자동출력 [6] | 소마세월 | 2007.11.13 |
| 이미지 갤러리 셀렉트박스 문제 [1] | 공작대천사 | 2007.11.14 |
| <head> 태그안에 임의의 내용을 넣는 방법 [1] | 발돋움 | 2007.11.16 |
간편해진 페이지 수정법
 | coll | 2007.11.16 |
| XP 환경에서의 속도 저하 문제 해결 (Apache 2.2.X) [2] | Netsblue | 2007.11.20 |
| 분류(category) 필수로 입력받기 [9] | Diver | 2007.11.20 |
| 제한된 서버에서 ZBXE가 돌아가도록 설정하기 [2] | Falls Too Fast | 2007.11.22 |
|
(글) 첨부 파일 날짜 출력 및 아이콘 표시
[1]
| Simulz | 2007.11.22 |
|
XE treeview
[4]
| 앙데르센 | 2007.11.22 |
|
배경이미지기능으로 페이지꾸미기
[3]
| 팔공산 | 2007.11.23 |
그런 테이블이 없는데요..