drop table cms;
create table cms
(
    id                int unsigned auto_increment
        primary key,
    shop_id           int                                      null,
    category_id       int                                      null,
    title             varchar(200)                             null,
    short_description varchar(500)                             null,
    description       text                                     null,
    property          text                                     null,
    created_at  timestamp    null,
    updated_at  timestamp    null,
    created_by        int                                      null,
    updated_by        int                                      null,
    state             tinyint(1) default 1                     null,
    is_deleted        tinyint(1) default 0                     null,
    count_view        int        default 0                     null
)
    charset = utf8;