#
# Add SQL definition of database tables
#

#
# Modifying pages table
#
CREATE TABLE pages (
   tx_navigation_pagelink int(11) unsigned DEFAULT '0',
   tx_content_pagelink int(11) unsigned DEFAULT '0',
   tx_tsbasetemplate_excludesubmenu int(11) unsigned DEFAULT '0',
);


#
# Modifying tt_content table
#
CREATE TABLE tt_content (
    tx_sg_sitepackage_headline varchar(255) DEFAULT '' NOT NULL,
    tx_sg_sitepackage_content text DEFAULT '' NULL,
    tx_sg_sitepackage_images varchar(255) DEFAULT '' NOT NULL,
    tx_sg_sitepackage_relation_slide_text int(11) unsigned DEFAULT '0' NOT NULL,
    tx_sg_sitepackage_relation_counter_text int(11) unsigned DEFAULT '0' NOT NULL,
    tx_sg_sitepackage_relation_teaser int(11) unsigned DEFAULT '0' NOT NULL,
    tx_sg_sitepackage_relation_tab int(11) unsigned DEFAULT '0' NOT NULL,
    tx_sg_sitepackage_video varchar(255) DEFAULT '' NOT NULL,
    tx_sg_sitepackage_relation_slide_logo int(11) unsigned DEFAULT '0' NOT NULL,
    tx_sg_sitepackage_relation_comments int(11) unsigned DEFAULT '0' NOT NULL,
    tx_sg_sitepackage_content1 text DEFAULT '' NULL,
    tx_sg_sitepackage_image1 varchar(255) DEFAULT '' NOT NULL,
    tx_sg_sitepackage_content2 text DEFAULT '' NULL,
    tx_sg_sitepackage_image2 varchar(255) DEFAULT '' NOT NULL,
    tx_sg_sitepackage_cta varchar(255) DEFAULT '' NOT NULL,
    tx_sg_sitepackage_cta_caption varchar(255) DEFAULT '' NOT NULL,
    tx_sg_sitepackage_relation_product_solution_teaser int(11) unsigned DEFAULT '0' NOT NULL,
    tx_sg_sitepackage_relation_management_team int(11) unsigned DEFAULT '0' NOT NULL,
);

CREATE TABLE tx_navigation_pagelink (
    uid INT AUTO_INCREMENT PRIMARY KEY,
    pid INT DEFAULT 0 NOT NULL,
    tstamp INT DEFAULT 0 NOT NULL,
    crdate INT DEFAULT 0 NOT NULL,
    cruser_id INT DEFAULT 0 NOT NULL,
    sorting INT DEFAULT 0 NOT NULL,
    deleted TINYINT(1) DEFAULT 0 NOT NULL,
    hidden TINYINT(1) DEFAULT 0 NOT NULL,

    pages_parent INT DEFAULT 0 NOT NULL,
    title VARCHAR(255) DEFAULT '' NOT NULL,
    link VARCHAR(1024) DEFAULT '' NOT NULL
);

CREATE TABLE tx_slide_text (
    uid INT AUTO_INCREMENT PRIMARY KEY,
    pid INT DEFAULT 0 NOT NULL,
    tstamp INT DEFAULT 0 NOT NULL,
    crdate INT DEFAULT 0 NOT NULL,
    cruser_id INT DEFAULT 0 NOT NULL,
    sorting INT DEFAULT 0 NOT NULL,
    deleted TINYINT(1) DEFAULT 0 NOT NULL,
    hidden TINYINT(1) DEFAULT 0 NOT NULL,

    pages_parent INT DEFAULT 0 NOT NULL,
    title VARCHAR(255) DEFAULT '' NOT NULL,
    tt_content int(11) unsigned DEFAULT '0',

);

CREATE TABLE tx_content_pagelink (
     uid INT AUTO_INCREMENT PRIMARY KEY,
     pid INT DEFAULT 0 NOT NULL,
     tstamp INT DEFAULT 0 NOT NULL,
     crdate INT DEFAULT 0 NOT NULL,
     cruser_id INT DEFAULT 0 NOT NULL,
     sorting INT DEFAULT 0 NOT NULL,
     deleted TINYINT(1) DEFAULT 0 NOT NULL,
     hidden TINYINT(1) DEFAULT 0 NOT NULL,

     pages_parent INT DEFAULT 0 NOT NULL,
     title VARCHAR(255) DEFAULT '' NOT NULL,
     ce_selector int(11) DEFAULT 0 NOT NULL
);

CREATE TABLE tx_counter_box (
   uid INT AUTO_INCREMENT PRIMARY KEY,
   pid INT DEFAULT 0 NOT NULL,
   tstamp INT DEFAULT 0 NOT NULL,
   crdate INT DEFAULT 0 NOT NULL,
   cruser_id INT DEFAULT 0 NOT NULL,
   sorting INT DEFAULT 0 NOT NULL,
   deleted TINYINT(1) DEFAULT 0 NOT NULL,
   hidden TINYINT(1) DEFAULT 0 NOT NULL,

   pages_parent INT DEFAULT 0 NOT NULL,
   title VARCHAR(255) DEFAULT '' NOT NULL,
   caption varchar(255) DEFAULT '' NOT NULL,
   images varchar(255) DEFAULT '' NOT NULL,
   tt_content int(11) unsigned DEFAULT '0',

);

CREATE TABLE tx_teaser (
    uid INT AUTO_INCREMENT PRIMARY KEY,
    pid INT DEFAULT 0 NOT NULL,
    tstamp INT DEFAULT 0 NOT NULL,
    crdate INT DEFAULT 0 NOT NULL,
    cruser_id INT DEFAULT 0 NOT NULL,
    sorting INT DEFAULT 0 NOT NULL,
    deleted TINYINT(1) DEFAULT 0 NOT NULL,
    hidden TINYINT(1) DEFAULT 0 NOT NULL,

    pages_parent INT DEFAULT 0 NOT NULL,
    title VARCHAR(255) DEFAULT '' NOT NULL,
    content text DEFAULT '' NULL,
    tt_content int(11) unsigned DEFAULT '0',

);

CREATE TABLE tx_slide_logo (
   uid INT AUTO_INCREMENT PRIMARY KEY,
   pid INT DEFAULT 0 NOT NULL,
   tstamp INT DEFAULT 0 NOT NULL,
   crdate INT DEFAULT 0 NOT NULL,
   cruser_id INT DEFAULT 0 NOT NULL,
   sorting INT DEFAULT 0 NOT NULL,
   deleted TINYINT(1) DEFAULT 0 NOT NULL,
   hidden TINYINT(1) DEFAULT 0 NOT NULL,

   pages_parent INT DEFAULT 0 NOT NULL,
   images varchar(255) DEFAULT '' NOT NULL,
   tt_content int(11) unsigned DEFAULT '0',

);

CREATE TABLE tx_comments (
   uid INT AUTO_INCREMENT PRIMARY KEY,
   pid INT DEFAULT 0 NOT NULL,
   tstamp INT DEFAULT 0 NOT NULL,
   crdate INT DEFAULT 0 NOT NULL,
   cruser_id INT DEFAULT 0 NOT NULL,
   sorting INT DEFAULT 0 NOT NULL,
   deleted TINYINT(1) DEFAULT 0 NOT NULL,
   hidden TINYINT(1) DEFAULT 0 NOT NULL,

   pages_parent INT DEFAULT 0 NOT NULL,
   content text DEFAULT '' NULL,
   tt_content int(11) unsigned DEFAULT '0',

);

CREATE TABLE tx_product_solution_teaser (
   uid INT AUTO_INCREMENT PRIMARY KEY,
   pid INT DEFAULT 0 NOT NULL,
   tstamp INT DEFAULT 0 NOT NULL,
   crdate INT DEFAULT 0 NOT NULL,
   cruser_id INT DEFAULT 0 NOT NULL,
   sorting INT DEFAULT 0 NOT NULL,
   deleted TINYINT(1) DEFAULT 0 NOT NULL,
   hidden TINYINT(1) DEFAULT 0 NOT NULL,

   pages_parent INT DEFAULT 0 NOT NULL,
   title VARCHAR(255) DEFAULT '' NOT NULL,
   content text DEFAULT '' NULL,
   images varchar(255) DEFAULT '' NOT NULL,
   tt_content int(11) unsigned DEFAULT '0',

);

CREATE TABLE tx_tab (
   uid INT AUTO_INCREMENT PRIMARY KEY,
   pid INT DEFAULT 0 NOT NULL,
   tstamp INT DEFAULT 0 NOT NULL,
   crdate INT DEFAULT 0 NOT NULL,
   cruser_id INT DEFAULT 0 NOT NULL,
   sorting INT DEFAULT 0 NOT NULL,
   deleted TINYINT(1) DEFAULT 0 NOT NULL,
   hidden TINYINT(1) DEFAULT 0 NOT NULL,

   pages_parent INT DEFAULT 0 NOT NULL,
   title VARCHAR(255) DEFAULT '' NOT NULL,
   content text DEFAULT '' NULL,
   tt_content int(11) unsigned DEFAULT '0',

);

CREATE TABLE tx_management_team (
    uid INT AUTO_INCREMENT PRIMARY KEY,
    pid INT DEFAULT 0 NOT NULL,
    tstamp INT DEFAULT 0 NOT NULL,
    crdate INT DEFAULT 0 NOT NULL,
    cruser_id INT DEFAULT 0 NOT NULL,
    sorting INT DEFAULT 0 NOT NULL,
    deleted TINYINT(1) DEFAULT 0 NOT NULL,
    hidden TINYINT(1) DEFAULT 0 NOT NULL,

    pages_parent INT DEFAULT 0 NOT NULL,
    name VARCHAR(255) DEFAULT '' NOT NULL,
    status VARCHAR(255) DEFAULT '' NOT NULL,
    content text DEFAULT '' NULL,
    link VARCHAR(1024) DEFAULT '' NOT NULL,
    tt_content int(11) unsigned DEFAULT '0',
    image varchar(255) DEFAULT '' NOT NULL,

);