CREATE TABLE tx_msrockarchive_domain_model_interpret (
	name varchar(255) NOT NULL DEFAULT '',
	list_name varchar(255) NOT NULL DEFAULT '',
	subtitle varchar(255) NOT NULL DEFAULT '',
	teasert_short text,
    rockarchive_parent_entry varchar(255) ,
	teaser_long text,
	sujet_image int(11) unsigned NOT NULL DEFAULT '0',
	scene varchar(255) NOT NULL DEFAULT '',
	year date DEFAULT NULL,
	year_to date DEFAULT NULL,
	about text,
	content_link int(11) NOT NULL DEFAULT '0',
    slug                           varchar(255)        DEFAULT ''  NOT NULL,
	district_relation int(11) unsigned NOT NULL DEFAULT '0',
	scene_relation int(11) unsigned NOT NULL DEFAULT '0',

    KEY ms_tx_msrockarchive_domain_model_interpret_name (name)
);

CREATE TABLE tx_msrockarchive_domain_model_district (
	district_name varchar(255) NOT NULL DEFAULT ''
);

CREATE TABLE tx_msrockarchive_domain_model_sceneenvironment (
	name varchar(255) NOT NULL DEFAULT ''
);

CREATE TABLE tt_content
(
    rockarchive INT(11) unsigned DEFAULT '0' NOT NULL,
    KEY ms_rockarchive (rockarchive, sorting)
);
