腾讯云优惠券
呆错后台管理框架info内容表数据库结构升级
人气:352 更新:2022-02-20
DROP INDEX info_id;

ALTER TABLE dc_info RENAME TO dc_info_temp;
         
CREATE TABLE "dc_info" (
    `info_id`    INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
    `info_name`    VARCHAR(255),
    `info_slug`    VARCHAR(255),
    `info_excerpt`    TEXT,
    `info_content`    TEXT,
    `info_password`    VARCHAR(255),
    `info_create_time`    INTEGER DEFAULT '0',
    `info_update_time`    INTEGER DEFAULT '0',
    `info_parent`    INTEGER DEFAULT '0',
    `info_order`    INTEGER DEFAULT '0',
    `info_user_id`    INTEGER DEFAULT '0',
    `info_type`    VARCHAR(100),
    `info_mime_type`    VARCHAR(100),
    `info_status`    VARCHAR(60) DEFAULT 'normal',
    `info_comment_status`    VARCHAR(100) DEFAULT 'open',
    `info_comment_count`    INTEGER DEFAULT '0',
    `info_views`    INTEGER DEFAULT '0',
    `info_hits`    INTEGER DEFAULT '0',
    `info_module`    VARCHAR(100) DEFAULT 'common',
    `info_controll`    VARCHAR(100),
    `info_action`    VARCHAR(100),
    `info_title`    VARCHAR(255),
    `info_keywords`    VARCHAR(255),
    `info_description`    VARCHAR(255)
);

INSERT INTO dc_info SELECT * FROM dc_info_temp;

CREATE INDEX info_id ON [dc_info](info_id);

CREATE INDEX info_id_meta ON [dc_info_meta](info_id);

DROP TABLE dc_info_temp;