웹마스터 팁
제로보드 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
제목 | 글쓴이 | 날짜 |
---|---|---|
첨부 파일 용량 문제 - 이것도 저것도 않될때 [4] | DeJavu346 | 2009.01.22 |
주민등록 입력 폼 1.2.0 [55] | 개돌 | 2009.04.10 |
개인쪽지발송!~ | noirzo | 2009.06.23 |
제로보드 2.3 에서 2.5 변경사항 데이터 테이블 구조 변경사항 체크를 정리해봅니다. [4] | 도토리나무 | 2007.11.09 |
첨부파일 기능에 대한 짧은 정보 [3] | 고라리 | 2007.11.09 |
외부페이지에서 위젯사용하지 않고 로그인 정보 다루기. [5] [1] | 길치객 | 2007.12.12 |
외부프로그램(페이지)에서 zbxe 로그인 정보 연동하기 [33] | 도데군 | 2007.12.23 |
제로보드에서 로그인후 테크노트에서 로그인정보 사용하기 [4] | JinHoHan | 2007.12.26 |
[전면수정]회원가입시 기본 정보공개 여부 체크하기(1) 모듈부분 [5] | 대암지기 | 2008.02.20 |
[정식 버전 1.0.0][완결편]회원가입시 기본 정보공개 여부 체크하기(1) 모듈부분 [4] | 대암지기 | 2008.02.24 |
[정식 버전 1.0.0] 회원 정보에서 ID 변경하기(1) 모듈부분 [1] | 대암지기 | 2008.02.27 |
회원 가입 임시 제한 일자 버그 수정 방법 [2] | 껄껄껄 | 2008.04.13 |
제한된 시간 안에 글을 또 등록할 때 IP 금지 기능(스팸필터) 해제하기 [3] | 비나무 | 2008.05.03 |
[1원짜리팁] 큰 이미지 썸네일 못생성& 확장변수 원하는 곳에 배치하기 ^^ [2] | 파파민 | 2008.06.23 |
각 리스트형 위젯에 페이지 기능을 달자. [10] | 라르게덴 | 2008.09.02 |
제로보드XE가입 -> 트랙자동가입 기능 | 개돌 | 2008.10.14 |
회원 순위 공동순위 표시해서 뽑기(원리만 소개) | 라르게덴 | 2009.02.13 |