웹마스터 팁
제로보드 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
글을 보시는 분들께 죄송합니다.
이 글은 팁이 아니고
제로보드가 업그레이드 되면서 혹시 필요할까 해서
구조가 변경된것을 참고 자료로 사용될 수 있어서
올려놓은 것입니다.
그냥 참고자료로 필요하신 유저님들만 참고자료로 사용해주시면
감사하겠습니다.
^^
| 제목 | 글쓴이 | 날짜 |
|---|---|---|
member 모듈 메일인증을 사용할때 모바일 기본스킨에서 회원가입 후 이메일 발송 안내 띄우기
[2]
 | 후하니 | 2015.08.01 |
| 새로고침 없는 실시간 웹서비스를 위한 기술과 간략한 역사(?) [1] | onTrust | 2015.07.27 |
| [실험팁] XE 고용량/큰사진 썸네일 깨지는 것 해결 | socialskyo | 2015.07.20 |
| 레이아웃 메뉴에서 메뉴옆에 글수 표시하기 | 반걸 | 2015.07.20 |
| DB에서 직접 시퀀스 생성하기 [3] | 기진곰 | 2015.07.18 |
| CloudFlare 사용시 방문자 IP와 SSL 접속여부가 정확하게 파악되지 않는 문제 해결법 [4] | 기진곰 | 2015.07.12 |
| IIS서버 자동 설치 프로그램(PHP, MySQL, phpMyAdmin) [1] | 공처아찌 | 2015.07.12 |
| 모바일에 최적화된 화면으로 보기 문구가 레이아웃을 가리는 문제 | creative8 | 2015.07.11 |
| config 파일을 일반 유저가 쓸 수 없는 문제 해결법 [15] | wkp | 2015.07.09 |
|
문서페이지가 수정이 되지 않는 문제
[2]
| monet | 2015.07.07 |
| 위젯 가운데 정렬 하는법 [3] | 불금 | 2015.07.05 |
| 홈페이지 제작 시 점검사항 15가지 [1] | 유래유거 | 2015.06.29 |
|
사이트 서버 운영체제와 사용하는 웹서버 소프트웨어 알아보는 사이트
| 후하니 | 2015.06.28 |
| 홈페이지 속도가 느린 이유.(팁같지도 않은 팁) [11] | 가브리엘조 | 2015.06.27 |
| cloudflare api 용 curl 기본값 | 마루디자인 | 2015.06.24 |
|
추천검색어,실시간인기순위 소스
| codlllle | 2015.06.21 |
|
실시간 rss 피드글 출력 위젯
| codlllle | 2015.06.20 |
| 다음 위젯 뱅크를 대신할 위젯 베스트! | codlllle | 2015.06.20 |
| 자신이 쓴 글에 특정유저 댓글을 차단 | Ikoo | 2015.06.20 |
|
다음 실시간 검색어 위젯
| codlllle | 2015.06.19 |
그런 테이블이 없는데요..