### Note: Column names are not prefixed deliberately as they are meant to be generic and to be re-used.
### As an example, ext:news would add the same columns

#
# Table structure for table pages
#
CREATE TABLE pages
(
    css_class         VARCHAR(120)        DEFAULT ''  NOT NULL,
    icon              INT(11) unsigned    DEFAULT '0' NOT NULL,
    media_mobile      INT(11) unsigned    DEFAULT '0' NOT NULL,
    show_submenu      TINYINT(4) unsigned DEFAULT '0' NOT NULL,
    show_sticky_menu  TINYINT(4) unsigned DEFAULT '0' NOT NULL,
    submenu_items     VARCHAR(120)        DEFAULT ''  NOT NULL,
    show_breadcrumbs  TINYINT(4) unsigned DEFAULT '0' NOT NULL,
    sticky_menu_items VARCHAR(120)        DEFAULT ''  NOT NULL
);

#
# Table structure for table sys_category
#
CREATE TABLE sys_category
(
    # These fields originally stem from ext_news and are kept to also  be used by other extensions
    fe_group        VARCHAR(100)     DEFAULT '0' NOT NULL,
    icon            INT(11) unsigned DEFAULT '0',
    images          INT(11) unsigned DEFAULT '0',
    list_pid        int(11) unsigned DEFAULT '0' NOT NULL,
    record_type     INT(11) unsigned DEFAULT '0' NOT NULL,
    seo_title       VARCHAR(255)                 NOT NULL DEFAULT '',
    seo_description TEXT,
    seo_headline    VARCHAR(255)                 NOT NULL DEFAULT '',
    seo_text        TEXT,
    slug            VARCHAR(2048),
    single_pid      int(11) unsigned DEFAULT '0' NOT NULL,
    shortcut        int(11) unsigned DEFAULT '0' NOT NULL,

    import_id       varchar(100)     DEFAULT ''  NOT NULL,
    import_source   varchar(100)     DEFAULT ''  NOT NULL,

    KEY import (import_id, import_source)
);

#
# Table structure for table tt_content
#
CREATE TABLE tt_content
(
    css_class         VARCHAR(120)        DEFAULT ''  NOT NULL,
    nav_header        VARCHAR(35)         DEFAULT ''  NOT NULL,
    header_appearance TINYINT(2) unsigned DEFAULT '2' NOT NULL,
    media_mobile      INT(11) unsigned    DEFAULT '0' NOT NULL
);
