웹마스터 팁

제로보드 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_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_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_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_login_check (
     member_srl bigint(11) NOT NULL DEFAULT '',
     login_time varchar(14),
     PRIMARY KEY (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_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_menu_layout (
     menu_srl bigint(12) NOT NULL DEFAULT '',
     layout_srl bigint(12) NOT NULL DEFAULT '',
     PRIMARY KEY (menu_srl)
);

create table xe_module_config (
     module varchar(250) NOT NULL DEFAULT '',
     config text,
     regdate varchar(14),
     PRIMARY KEY (module)
);

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_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_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 업그레이드 방법 by 도토리나무

테이블구조, 2.5, 변경사항, 이 게시물을

흐음

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
레벨 아이콘이 제대로(찌그러지는 등) 출력되지 않을 때 수정방법	必得力	2007.11.07
메뉴에 마우스 갖다대면 뜨는 메뉴 만드는 방법 [25]	소마세월	2007.11.07
"이 게시물을..." 추천/비추천/신고 메뉴를 버튼으로 [28]	xe촙5	2007.11.08
제로보드 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
확장변수에서 본문 입력 빼기 [10]	Diver	2007.11.12
회원에게 만기일 주기(1원짜리 팁) [17]	까오천사	2007.11.12
쪽지 수신 음성 알림 [19]	Simulz	2007.11.13
알바트로스 적용후 검색하는 곳에 댓글과 태그 검색 업션 넣기 [1]	비밀얌	2007.11.13
[수정]업로드된 그림 자동출력 [6]	소마세월	2007.11.13
이미지 갤러리 셀렉트박스 문제 [1]	공작대천사	2007.11.14
<head> 태그안에 임의의 내용을 넣는 방법 [1]	발돋움	2007.11.16
간편해진 페이지 수정법	coll	2007.11.16
(포인트) 레벨별 포인트 계산 기능 추가 [4]	Simulz	2007.11.19

태그 쓰기

웹마스터 팁

제로보드 2.3 에서 2.5 변경사항 데이터 테이블 구조 변경사항 체크를 정리해봅니다.

댓글 4

흐음

도토리나무

xe촙5

도토리나무

About

Get involved

Blog

Download

Support

Showcase