CREATE TABLE tx_wabsattractions_domain_model_attraction (
	title varchar(255) NOT NULL DEFAULT '',
	subtitle varchar(255) NOT NULL DEFAULT '',
	slug varchar(255) NOT NULL DEFAULT '',
	introduction_title varchar(255) DEFAULT '',
	introduction_description text,
	teaser text NOT NULL DEFAULT '',
	description text,
	link varchar(255) NOT NULL DEFAULT '',
	instagramlink text,
	facebooklink text,
	socialiconcolor varchar(255) NOT NULL DEFAULT '',
	socialiconbgcolor varchar(255) NOT NULL DEFAULT '',
	seconddesctitle text,
	seconddescription text,
	knowtext text,
	buttontitle varchar(255) DEFAULT '',
	buttondesc text,
	buttontext varchar(255) DEFAULT '',
	buttonlink varchar(255) NOT NULL DEFAULT '',
	attraction_status int(11) NOT NULL DEFAULT '0',
	gallerytitle varchar(255) NOT NULL DEFAULT '',
	icon int(11) unsigned NOT NULL DEFAULT '0',
	thumbnail int(11) unsigned NOT NULL DEFAULT '0',
	banner int(11) unsigned NOT NULL DEFAULT '0',
	image_position text,
	banner_title varchar(255) NOT NULL DEFAULT '',
	banner_subtitle varchar(255) NOT NULL DEFAULT '',
	mobile_video_fallback_image int(11) unsigned NOT NULL DEFAULT '0',
	images int(11) unsigned NOT NULL DEFAULT '0',
	map_title varchar(255) NOT NULL DEFAULT '',
	map_image int(11) unsigned NOT NULL DEFAULT '0',
	descimages int(11) unsigned NOT NULL DEFAULT '0',
	knowpic int(11) unsigned NOT NULL DEFAULT '0',
	gallerypictures int(11) unsigned NOT NULL DEFAULT '0',
	type int(11) unsigned DEFAULT '0',
	features int(11) unsigned NOT NULL DEFAULT '0',
	relatedtitle varchar(255) NOT NULL DEFAULT '',
	related int(11) unsigned NOT NULL DEFAULT '0',
	status int(11) unsigned DEFAULT '0',
	categories int(11) unsigned NOT NULL DEFAULT '0',
	seals int(11) unsigned NOT NULL DEFAULT '0',
	localities int(11) unsigned NOT NULL DEFAULT '0',
	knowledges int(11) unsigned NOT NULL DEFAULT '0',

	name_box varchar(255) NOT NULL DEFAULT '',
	seo_title varchar(255) NOT NULL DEFAULT '',
	seo_description varchar(255) NOT NULL DEFAULT '',
);

CREATE TABLE tx_wabsattractions_domain_model_status (
	titel varchar(255) NOT NULL DEFAULT '',
	bodytext text
);

CREATE TABLE tx_wabsattractions_domain_model_type (
	title varchar(255) NOT NULL DEFAULT ''
);

CREATE TABLE tx_wabsattractions_domain_model_category (
	title varchar(255) NOT NULL DEFAULT '',
	icon int(11) unsigned NOT NULL DEFAULT '0',
	image int(11) unsigned NOT NULL DEFAULT '0',
	parent int(11) unsigned DEFAULT '0'
);

CREATE TABLE tx_wabsattractions_domain_model_featuregroup (
	title varchar(255) NOT NULL DEFAULT '',
	icon int(11) unsigned NOT NULL DEFAULT '0'
);

CREATE TABLE tx_wabsattractions_domain_model_feature (
	value varchar(255) NOT NULL DEFAULT '',
	feature_group int(11) unsigned DEFAULT '0',
	feature_available tinyint(1) DEFAULT '0' NOT NULL
);

CREATE TABLE tx_wabsattractions_domain_model_locality (
	title varchar(255) NOT NULL DEFAULT '',
	image int(11) unsigned NOT NULL DEFAULT '0'
);

CREATE TABLE tx_wabsattractions_domain_model_seal (
	title varchar(255) NOT NULL DEFAULT '',
	subtitle varchar(255) NOT NULL DEFAULT '',
	icon int(11) unsigned NOT NULL DEFAULT '0'
);

CREATE TABLE tx_wabsattractions_domain_model_knowledge (
	attraction int(11) unsigned DEFAULT '0' NOT NULL,
	title varchar(255) NOT NULL DEFAULT '',
	bodytext text,
	image int(11) unsigned NOT NULL DEFAULT '0'
);

CREATE TABLE tx_wabsattractions_attraction_feature_mm (
	uid_local int(11) unsigned DEFAULT '0' NOT NULL,
	uid_foreign int(11) unsigned DEFAULT '0' NOT NULL,
	sorting int(11) unsigned DEFAULT '0' NOT NULL,
	sorting_foreign int(11) unsigned DEFAULT '0' NOT NULL,

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

CREATE TABLE tx_wabsattractions_attraction_attraction_mm (
	uid_local int(11) unsigned DEFAULT '0' NOT NULL,
	uid_foreign int(11) unsigned DEFAULT '0' NOT NULL,
	sorting int(11) unsigned DEFAULT '0' NOT NULL,
	sorting_foreign int(11) unsigned DEFAULT '0' NOT NULL,

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

CREATE TABLE tx_wabsattractions_attraction_category_mm (
	uid_local int(11) unsigned DEFAULT '0' NOT NULL,
	uid_foreign int(11) unsigned DEFAULT '0' NOT NULL,
	sorting int(11) unsigned DEFAULT '0' NOT NULL,
	sorting_foreign int(11) unsigned DEFAULT '0' NOT NULL,

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

CREATE TABLE tx_wabsattractions_attraction_seal_mm (
	uid_local int(11) unsigned DEFAULT '0' NOT NULL,
	uid_foreign int(11) unsigned DEFAULT '0' NOT NULL,
	sorting int(11) unsigned DEFAULT '0' NOT NULL,
	sorting_foreign int(11) unsigned DEFAULT '0' NOT NULL,

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

CREATE TABLE tx_wabsattractions_attraction_locality_mm (
	uid_local int(11) unsigned DEFAULT '0' NOT NULL,
	uid_foreign int(11) unsigned DEFAULT '0' NOT NULL,
	sorting int(11) unsigned DEFAULT '0' NOT NULL,
	sorting_foreign int(11) unsigned DEFAULT '0' NOT NULL,

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