웹마스터 팁

제로보드 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)
);

태그 연관 글
  1. [2007/11/09] 웹마스터 팁 제로보드 2.3 에서 2.5 업그레이드 방법 by 도토리나무
제목 글쓴이 날짜
SVN 의 사용 방법 [3] preware 2007.11.06
완전 초보도 확장 변수를 이용해 게시판 개조할수잇다!! [4] 쿤. 2007.11.06
(08년 1월2일수정)0.2.3이후 최근글에 공지사항을 제외시키고자할 경우 [11] 포레버 2007.11.07
제로보드4, xe 버전 바이러스에 대한 질문 [1] 투자혁명 2009.04.15
제로보드 2.3 에서 2.5 변경사항 데이터 테이블 구조 변경사항 체크를 정리해봅니다. [4] 도토리나무 2007.11.09
제로보드 2.3 에서 2.5 업그레이드 방법 도토리나무 2007.11.09
첨부파일 기능에 대한 짧은 정보 [3] 고라리 2007.11.09
외부 문서에서 회원 정보 얻는 방법 [11] 소마세월 2007.11.10
통합검색 버그 style 수정 [2] 소마세월 2007.11.11
알바트로스 적용후 검색하는 곳에 댓글과 태그 검색 업션 넣기 [1] 비밀얌 2007.11.13
[수정]업로드된 그림 자동출력 [6] 소마세월 2007.11.13
이미지 갤러리 셀렉트박스 문제 [1] 공작대천사 2007.11.14
<head> 태그안에 임의의 내용을 넣는 방법 [1] 발돋움 2007.11.16
간편해진 페이지 수정법 file coll 2007.11.16
XP 환경에서의 속도 저하 문제 해결 (Apache 2.2.X) [2] Netsblue 2007.11.20
분류(category) 필수로 입력받기 [9] Diver 2007.11.20
제한된 서버에서 ZBXE가 돌아가도록 설정하기 [2] Falls Too Fast 2007.11.22
(글) 첨부 파일 날짜 출력 및 아이콘 표시 [1] file Simulz 2007.11.22
XE treeview [4] file 앙데르센 2007.11.22
배경이미지기능으로 페이지꾸미기 [3] file 팔공산 2007.11.23