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

    title varchar(255) DEFAULT '' NOT NULL,
    tags varchar(255) DEFAULT '' NOT NULL,
    write_date datetime DEFAULT NULL,
    page int(11) DEFAULT '0' NOT NULL,
    title_image int(11) unsigned NOT NULL default '0',
    footer_images int(11) unsigned DEFAULT '0' NOT NULL,
    short_description text

);

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

    title varchar(255) DEFAULT '' NOT NULL,
    parentid int(11) DEFAULT '0' NOT NULL,
    tag varchar(255) DEFAULT '' NOT NULL,
    tags varchar(255) DEFAULT '' NOT NULL


);


CREATE TABLE tx_blog_relation_mm (
    uid int(11) NOT NULL auto_increment,
    uid_local int(11) DEFAULT '0' NOT NULL,
    uid_foreign int(11) DEFAULT '0' NOT NULL,
    tablenames varchar(30) DEFAULT '' NOT NULL,
    sorting int(11) DEFAULT '0' NOT NULL,
    sorting_foreign int(11) DEFAULT '0' NOT NULL,
    ident varchar(30) DEFAULT '' NOT NULL,

    KEY uid_local (uid_local),
    KEY uid_foreign (uid_foreign),
    PRIMARY KEY (uid)
);