#
# CAROUSEL
#
CREATE TABLE tx_pmucommon_carousel_item (
    uid int(11) unsigned NOT NULL auto_increment,
    pid int(11) DEFAULT '0' NOT NULL,

    tt_content int(11) unsigned DEFAULT '0',
    item_type varchar(255) DEFAULT '' NOT NULL,
    layout varchar(255) DEFAULT '' NOT NULL,
    header varchar(255) DEFAULT '' NOT NULL,
    header_layout tinyint(3) unsigned DEFAULT '1' NOT NULL,
    header_position varchar(255) DEFAULT 'center' NOT NULL,
    header_class varchar(255) DEFAULT '' NOT NULL,
    subheader varchar(255) DEFAULT '' NOT NULL,
    subheader_layout tinyint(3) unsigned DEFAULT '2' NOT NULL,
    subheader_class varchar(255) DEFAULT '' NOT NULL,
    nav_title varchar(255) DEFAULT '' NOT NULL,
    button_text varchar(255) DEFAULT '' NOT NULL,
    bodytext text,
    image int(11) unsigned DEFAULT '0',
    link varchar(1024) DEFAULT '' NOT NULL,
    text_color varchar(255) DEFAULT '' NOT NULL,
    background_color varchar(255) DEFAULT '' NOT NULL,
    background_image int(11) unsigned DEFAULT '0',
    background_image_options mediumtext,

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

#
# TESTIMONIAL
#
CREATE TABLE tx_pmucommon_testimonial_item (
    uid int(11) unsigned NOT NULL auto_increment,
    pid int(11) DEFAULT '0' NOT NULL,

    tt_content int(11) unsigned DEFAULT '0',
    media int(11) unsigned DEFAULT '0',
    fullname tinytext,
    profession varchar(255) DEFAULT '' NOT NULL,
    bodytext text,

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

#
# CTA
#
CREATE TABLE tx_pmucommon_cta_item (
    uid int(11) unsigned NOT NULL auto_increment,
    pid int(11) DEFAULT '0' NOT NULL,

    tt_content int(11) unsigned DEFAULT '0',
    layout varchar(255) DEFAULT '' NOT NULL,
    media int(11) unsigned DEFAULT '0',
    header varchar(255) DEFAULT '' NOT NULL,
    bodytext text,
    link varchar(1024) DEFAULT '' NOT NULL,

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

#
# FEATURED
#
CREATE TABLE tx_pmucommon_featured_item (
    uid int(11) unsigned NOT NULL auto_increment,
    pid int(11) DEFAULT '0' NOT NULL,

    tt_content int(11) unsigned DEFAULT '0',
    media int(11) unsigned DEFAULT '0',
    header varchar(255) DEFAULT '' NOT NULL,
    header_layout tinyint(3) unsigned DEFAULT '4' NOT NULL,
    header_position varchar(255) DEFAULT 'left' NOT NULL,
    bodytext text,

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

#
# SOCIAL MEDIA
#
CREATE TABLE tx_pmucommon_social_media_item (
    uid int(11) unsigned NOT NULL auto_increment,
    pid int(11) DEFAULT '0' NOT NULL,

    tt_content int(11) unsigned DEFAULT '0',
    header varchar(255) DEFAULT '' NOT NULL,
    media int(11) unsigned DEFAULT '0',

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

#
# Content Elements
#
CREATE TABLE tt_content (
    background_color_class varchar(255) DEFAULT '' NOT NULL,
    background_image int(11) unsigned DEFAULT '0',
    background_image_options mediumtext,
    tx_pmucommon_carousel_item int(11) unsigned DEFAULT '0',
    tx_pmucommon_testimonial_item int(11) unsigned DEFAULT '0',
    tx_pmucommon_cta_item int(11) unsigned DEFAULT '0',
    tx_pmucommon_social_media_item int(11) unsigned DEFAULT '0',
    tx_pmucommon_featured_item int(11) unsigned DEFAULT '0',
    tx_pmucommon_media_banner_color tinytext,
    tx_pmucommon_media_banner_opacity double(11,2) DEFAULT '0.00' NOT NULL,
    tx_pmucommon_countdown_datetime datetime,
);

CREATE TABLE pages (
  teaser_text varchar(255) DEFAULT '' NOT NULL
);