CREATE TABLE tx_mskatalogbestellung_domain_model_catalog
(
    name  varchar(255) NOT NULL DEFAULT '',
    price double(11, 2) NOT NULL DEFAULT '0.00',
    slug varchar(255) DEFAULT '' NOT NULL,
	description text NOT NULL DEFAULT '',
	image int(11) NOT NULL DEFAULT '0',
	showimage int(11) NOT NULL DEFAULT '0',
    dont_use_crop int(11) NOT NULL DEFAULT '0',
	soldout int(11) NOT NULL DEFAULT '0',
	category_link varchar(255) NOT NULL DEFAULT '',
    catalog_amount int(3) NOT NULL DEFAULT '0',
	category int(11) NOT NULL DEFAULT '0',
    content int(11) DEFAULT '0' NOT NULL
);

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

    name  varchar(255) NOT NULL DEFAULT '',
    email  varchar(255) NOT NULL DEFAULT '',
    totalprice double(11, 2) NOT NULL DEFAULT '0.00',
	logdata text NOT NULL DEFAULT '',

	tstamp int(11) unsigned DEFAULT '0' NOT NULL,

	PRIMARY KEY (uid),
	KEY parent (pid)

);

CREATE TABLE tx_mskatalogbestellung_domain_model_category
(
    name         varchar(255) NOT NULL DEFAULT '',
    catalog      int(11) NOT NULL DEFAULT '0',
    catalog_link int(11) NOT NULL DEFAULT '0'
);


CREATE TABLE tt_content(
    katalog_content int(11) NOT NULL DEFAULT '0'
);