#
# Table structure for table 'pages'
#
CREATE TABLE pages (
    tx_wseils_cardBackground tinyint(1) DEFAULT '0' NOT NULL,
    tx_wseils_showtitle tinyint(1) DEFAULT '0' NOT NULL,
    max_tstamp_new int(11) DEFAULT '0' NOT NULL
);

#
# Table structure for table 'fe_users'
#
CREATE TABLE fe_users (
    tx_wseils_customContentId  varchar(255) DEFAULT '' NOT NULL,
    tx_wseils_applications varchar(100) DEFAULT '0,0,0,0,0,0,0,0,0,0,0,0' NOT NULL,
    tx_wseils_links varchar(100) DEFAULT '0,0,0,0,0,0,0,0' NOT NULL,
);
CREATE TABLE tt_content (
	  is_new tinytext,
    notice int(11) DEFAULT '0',
    header_icon tinytext
);
#
# Table structure for table 'tx_wseils_statistics'
#
CREATE TABLE tx_wseils_statistics (
    uid int(11) NOT NULL auto_increment,
	pid int(11) DEFAULT '0' NOT NULL,
	tstamp int(11) DEFAULT '0' NOT NULL,
	crdate int(11) DEFAULT '0' NOT NULL,
	cruser_id int(11) DEFAULT '0' NOT NULL,
	deleted tinyint(4) DEFAULT '0' NOT NULL,
	hidden tinyint(4) DEFAULT '0' NOT NULL,
	sorting int(11) DEFAULT '0' NOT NULL,
	page_id int(11) DEFAULT '0' NOT NULL,
	parent_id int(11) DEFAULT '0' NOT NULL,
	rootline int(11) DEFAULT '0' NOT NULL,
	user tinytext,
	session_id tinytext,


    PRIMARY KEY (uid),
    KEY parent (pid)
);

CREATE TABLE tx_news_domain_model_news (
    uid_local int(11) NULL,
    uid_foreign int(11) NULL,
    sorting_foreign int(11) NULL
);

CREATE TABLE tx_powermail_domain_model_page (
    fe_group int(11) NULL,
    rowDescription tinytext NULL,
    editlock int(11) NULL,
    l10n_source mediumblob,
    perms_userid int(11) NULL,
    perms_groupid int(11) NULL,
    perms_user tinytext NULL,
    perms_group tinytext NULL,
    perms_everybody tinytext NULL,
    slug tinytext NULL,
    doktype int(11) NULL,
    TSconfig int(11) NULL,
    is_siteroot int(4) NULL,
    php_tree_stop tinytext NULL,
    url tinytext NULL,
    shortcut tinytext NULL,
    shortcut_mode tinytext NULL,
    subtitle tinytext NULL,
    layout int(11) NULL,
    target tinytext,
    media int(11) NULL,
    lastUpdated int(11) NULL,
    keywords tinytext NULL,
    cache_timeout tinytext NULL,
     cache_tags tinytext NULL,
     newUntil tinytext NULL,
     description tinytext NULL,
     no_search tinytext NULL,
     SYS_LASTCHANGED tinytext NULL,
     abstract tinytext NULL,
     module tinytext NULL,
     extendToSubpages tinytext NULL,
     author tinytext NULL,
     author_email tinytext NULL,
     nav_title tinytext NULL,
     nav_hide tinytext NULL,
     content_from_pid tinytext NULL,
     mount_pid tinytext NULL,
     mount_pid_ol tinytext NULL,
     alias tinytext NULL,
     l18n_cfg tinytext NULL,
     fe_login_mode tinytext NULL,
     backend_layout tinytext NULL,
     backend_layout_next_level tinytext NULL,
     tsconfig_includes tinytext NULL,
     legacy_overlay_uid tinytext NULL,
     tx_impexp_origuid tinytext NULL,
     seo_title tinytext NULL,
     no_index tinytext NULL,
     no_follow tinytext NULL,
     og_title tinytext NULL,
     og_description tinytext NULL,
     og_image tinytext NULL,
     twitter_title tinytext NULL,
     twitter_description tinytext NULL,
     twitter_image tinytext NULL,
     canonical_link tinytext NULL,
     nav_icon tinytext NULL,
     thumbnail tinytext NULL,
     categories tinytext NULL,
     tx_wseils_cardBackground tinytext NULL,
     tx_kesearch_tags tinytext NULL,
     tx_kesearch_abstract tinytext NULL,
     tx_kesearch_resultimage tinytext NULL,
     max_tstamp_new tinytext NULL
);


ALTER TABLE `tx_wseils_statistics` ADD INDEX `page_id` (`page_id`);
ALTER TABLE `tx_wseils_statistics` ADD INDEX `user` (`user`(100));
ALTER TABLE `tx_wseils_statistics` ADD INDEX `cruser_id` (`cruser_id`);
ALTER TABLE `tx_wseils_statistics` ADD INDEX `stats` (`page_id`, `cruser_id`, `deleted`, `hidden`);

#
# Table structure for table 'tx_wseils_domain_model_notification'
#
CREATE TABLE tx_wseils_domain_model_notification (

    uid int(11) NOT NULL auto_increment,
    pid int(11) DEFAULT '0' NOT NULL,

    title varchar(255) DEFAULT '' NOT NULL,
    description mediumtext,
    color varchar(60) DEFAULT '' NOT NULL,

    tstamp int(11) unsigned DEFAULT '0' NOT NULL,
    crdate int(11) unsigned DEFAULT '0' NOT NULL,
    cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
    deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
    hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
    starttime int(11) unsigned DEFAULT '0' NOT NULL,
    endtime int(11) unsigned DEFAULT '0' NOT NULL,
    sorting int(11) unsigned DEFAULT '0' NOT NULL,

    t3ver_oid int(11) DEFAULT '0' NOT NULL,
    t3ver_id int(11) DEFAULT '0' NOT NULL,
    t3ver_wsid int(11) DEFAULT '0' NOT NULL,
    t3ver_label varchar(255) DEFAULT '' NOT NULL,
    t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
    t3ver_stage int(11) DEFAULT '0' NOT NULL,
    t3ver_count int(11) DEFAULT '0' NOT NULL,
    t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
    t3ver_move_id int(11) DEFAULT '0' NOT NULL,

    sys_language_uid int(11) DEFAULT '0' NOT NULL,
    l10n_parent int(11) DEFAULT '0' NOT NULL,
    l10n_diffsource mediumblob,

    PRIMARY KEY (uid),
    KEY parent (pid),
    KEY t3ver_oid (t3ver_oid,t3ver_wsid),
    KEY language (l10n_parent,sys_language_uid)
);


#
# Table structure for table 'tx_frpformanswers_domain_model_formentry'
#
CREATE TABLE tx_frpformanswers_domain_model_formentry (
	username varchar(255) DEFAULT '' NOT NULL,
);


#
# Table structure for table 'tx_icsbookmarkapplication_applications'
#
CREATE TABLE `tx_icsbookmarkapplication_applications` (
  `uid`  int(11) NOT NULL auto_increment,
  `pid` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `tstamp` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `crdate` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `cruser_id` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `deleted` smallint(5) UNSIGNED NOT NULL DEFAULT 0,
  `hidden` smallint(5) UNSIGNED NOT NULL DEFAULT 0,
  `name` tinytext DEFAULT NULL,
  `link_internal` tinytext DEFAULT NULL,
  `link_external` tinytext DEFAULT NULL,
  `description` text DEFAULT NULL,
  `image` text DEFAULT NULL,
  `type` int(10) UNSIGNED DEFAULT 0,
  `isBusiness` tinyint(4) DEFAULT 0,
  `fe_users` int(10) UNSIGNED DEFAULT 0,
  `azure_id` text DEFAULT NULL,

  PRIMARY KEY (uid)
);

CREATE TABLE fe_groups (
    `azure_id` text DEFAULT NULL
);

#
# Table structure for table 'tx_icsbookmarklinks_links'
#
CREATE TABLE `tx_icsbookmarklinks_links` (
  `uid` int(11) NOT NULL auto_increment,
  `pid` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `tstamp` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `crdate` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `cruser_id` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `deleted` smallint(5) UNSIGNED NOT NULL DEFAULT 0,
  `hidden` smallint(5) UNSIGNED NOT NULL DEFAULT 0,
  `starttime` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `endtime` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `fe_group` varchar(255) NOT NULL DEFAULT '0',
  `title` tinytext DEFAULT NULL,
  `url` tinytext DEFAULT NULL,
  `summary` text DEFAULT NULL,
  `ics_categories` text DEFAULT NULL,
  `shared` tinyint(3) NOT NULL DEFAULT 0,
  `isCustom` tinyint(4) DEFAULT 0,

  PRIMARY KEY (uid)
);

#
# Table structure for table 'sys_category'
#
CREATE TABLE `sys_category` (
  `uid_local` int(10) NOT NULL DEFAULT '0',
  `sorting_foreign` int(10) NOT NULL DEFAULT '0',
  `tablenames` varchar(100) NOT NULL DEFAULT '0',
  `fieldname` varchar(100) NOT NULL DEFAULT '0',
  `uid_foreign` int(10) NOT NULL DEFAULT '0'
);
