cms数据库结构

CREATE TABLE wp_posts (
    ID bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    post_author bigint(20) unsigned NOT NULL DEFAULT '0',
    post_date datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
    post_date_gmt datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
    post_content text NOT NULL,
    post_title text NOT NULL,
    post_excerpt text NOT NULL,
    post_status varchar(20) NOT NULL DEFAULT 'publish',
    comment_status varchar(20) NOT NULL DEFAULT 'open',
    ping_status varchar(20) NOT NULL DEFAULT 'open',
    post_password varchar(255) NOT NULL DEFAULT '',
    post_name varchar(200) NOT NULL DEFAULT '',
    to_ping text NOT NULL,
    pinged text NOT NULL,
    post_modified datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
    post_modified_gmt datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
    post_content_filtered text NOT NULL,
    post_parent bigint(20) unsigned NOT NULL DEFAULT '0',
    menu_order int(11) NOT NULL DEFAULT '0',
    post_type varchar(100) NOT NULL DEFAULT 'post',
    post_mime_type varchar(100) NOT NULL DEFAULT '',
    PRIMARY KEY (ID),
    UNIQUE KEY post_name (post_name),
    KEY post_parent (post_parent),
    KEY type_status_date (post_type,post_status,post_date,ID),
    KEY post_parent_status_date (post_parent,post_status,post_date,ID),
    KEY post_author_status_date (post_author,post_status,post_date,ID)
);