#
# Table structure for table 'tx_sutterbeggdistribution_domain_model_event'
#

CREATE TABLE tx_sutterbeggdistribution_domain_model_event (

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

	image varchar(255) DEFAULT '' NOT NULL,
	category tinyint(5) unsigned DEFAULT '0' NOT NULL,
	hidden smallint(5) unsigned DEFAULT '0' NOT NULL,
	start int(11) unsigned DEFAULT '0' NOT NULL,
	end int(11) unsigned DEFAULT '0' NOT NULL,
	group varchar(255) DEFAULT '' NOT NULL,
	title varchar(255) DEFAULT '' NOT NULL,
	path_segment varchar(255) DEFAULT '' NOT NULL,
	detail varchar(255) DEFAULT '' NOT NULL,
	street varchar(255) DEFAULT '' NOT NULL,
	zip varchar(10) NOT NULL,
	place varchar(255) DEFAULT '' NOT NULL,

	location varchar(255) DEFAULT '' NOT NULL,
	ticket varchar(500) DEFAULT '' NOT NULL,
	subscribe_type smallint(5) unsigned DEFAULT '0' NOT NULL,
	latitude DECIMAL(10, 8) NULL,
	longitude DECIMAL(11, 8) NULL,
	description TEXT NOT NULL,

	gallery TEXT DEFAULT '' NULL,

	cp_image varchar(255) DEFAULT '' NOT NULL,
	name varchar(255) DEFAULT '' NOT NULL,
	phone varchar(255) DEFAULT '' NOT NULL,
	email varchar(255) DEFAULT '' NOT NULL,
	contact_times TEXT DEFAULT '' NOT NULL,

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

#
# Table structure for table 'tx_sutterbeggdistribution_domain_model_job'
#

CREATE TABLE tx_sutterbeggdistribution_domain_model_job (

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

	creation_date int(11) unsigned DEFAULT '0' NOT NULL,
	title varchar(255) DEFAULT '' NOT NULL,
	path_segment varchar(255) DEFAULT '' NOT NULL,
	place varchar(255) DEFAULT '' NOT NULL,
	employment varchar(255) DEFAULT '' NOT NULL,
	type varchar(255) DEFAULT '' NOT NULL,
	start varchar(255) DEFAULT '' NOT NULL,
	description TEXT NOT NULL,
	detail TEXT NOT NULL,
	mail varchar(255) DEFAULT '' NOT NULL,
	category tinyint(5) unsigned DEFAULT '0' NOT NULL,
	pdf_name varchar(255) DEFAULT '' NOT NULL,
	pdf varchar(255) NOT NULL,

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


#
# Table structure for table 'tx_sutterbeggdistribution_domain_model_offerformresult'
#

CREATE TABLE tx_sutterbeggdistribution_domain_model_offerformresult (

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

	gender smallint(2) DEFAULT '0' NOT NULL,
	first_name varchar(255) NOT NULL,
	last_name varchar(255) NOT NULL,
	address varchar(255) NOT NULL,
	zip varchar(10) NOT NULL,
	city varchar(255) NOT NULL,
	email varchar(255) NOT NULL,
    phone varchar(255) NULL,
	delivery_date int(11) unsigned DEFAULT '0' NOT NULL,
	shipping varchar(255) DEFAULT '' NOT NULL,
	message TEXT NOT NULL,

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

#
# Table structure for table 'tx_sutterbeggdistribution_domain_model_cakeformresult'
#

CREATE TABLE tx_sutterbeggdistribution_domain_model_cakeformresult (

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

	type smallint(2) DEFAULT '0' NOT NULL,
	count smallint(5) DEFAULT '0' NOT NULL,
	construction smallint(2) DEFAULT '0' NOT NULL,
	color smallint(2) DEFAULT '0' NOT NULL,
	figure smallint(2) DEFAULT '0' NOT NULL,
	marcipane smallint(2) DEFAULT '0' NOT NULL,
	aflower smallint(2) DEFAULT '0' NOT NULL,
	rflower smallint(2) DEFAULT '0' NOT NULL,
	filling smallint(2) DEFAULT '0' NOT NULL,
	other_filling varchar(255) DEFAULT '' NOT NULL,
	image varchar(255) DEFAULT '' NOT NULL,
	delivery_date int(11) unsigned DEFAULT '0' NOT NULL,
	shipping varchar(255) DEFAULT '' NOT NULL,

	gender smallint(2) DEFAULT '0' NOT NULL,
	first_name varchar(255) NOT NULL,
	last_name varchar(255) NOT NULL,
	address varchar(255) NOT NULL,
	zip varchar(10) NOT NULL,
	city varchar(255) NOT NULL,
	email varchar(255) NOT NULL,
    phone varchar(255) NULL,
	message TEXT NOT NULL,

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

#
# Table structure for table 'tx_sutterbeggdistribution_domain_model_cardformresult'
#

CREATE TABLE tx_sutterbeggdistribution_domain_model_cardformresult (

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

	gender smallint(2) DEFAULT '0' NOT NULL,
	first_name varchar(255) NOT NULL,
	last_name varchar(255) NOT NULL,
	address varchar(255) NOT NULL,
	zip varchar(10) NOT NULL,
	city varchar(255) NOT NULL,
	email varchar(255) NOT NULL,
    phone varchar(255) NULL,

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


#
# Table structure for table 'tx_sutterbeggdistribution_domain_model_contactformresult'
#

CREATE TABLE tx_sutterbeggdistribution_domain_model_contactformresult (

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

	gender smallint(2) DEFAULT '0' NOT NULL,
	first_name varchar(255) NOT NULL,
	last_name varchar(255) NOT NULL,
	email varchar(255) NOT NULL,
    phone varchar(255) NULL,
	message TEXT NOT NULL,

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


#
# Table structure for table 'tx_sutterbeggdistribution_domain_model_location'
#

CREATE TABLE tx_sutterbeggdistribution_domain_model_location (

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

	name varchar(255) DEFAULT '' NOT NULL,
	path_segment varchar(255) DEFAULT '' NOT NULL,
	subtitle varchar(255) DEFAULT '' NOT NULL,
	branches varchar(255) DEFAULT NULL,
	street varchar(255) DEFAULT '' NOT NULL,
    zip varchar(255) DEFAULT '' NOT NULL,
	place varchar(255) DEFAULT '' NOT NULL,
	phone varchar(255) DEFAULT '' NOT NULL,
	latitude DECIMAL(10, 8) NOT NULL,
	longitude DECIMAL(11, 8) NOT NULL,
	image varchar(255) DEFAULT '' NOT NULL,
	description text DEFAULT '' NULL,

	gallery TEXT DEFAULT '' NULL,

	opening_times varchar(255) NULL,
	holidays varchar(255) NULL,

	PRIMARY KEY (uid),
	KEY parent (pid)

);

#
# Table structure for table 'tx_sutterbeggdistribution_domain_model_openingtime'
#

CREATE TABLE tx_sutterbeggdistribution_domain_model_openingtime (

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

	location_id int(11) unsigned DEFAULT NULL,
	weekday int(11) unsigned DEFAULT NULL,
    opens INT NOT NULL,
    closes INT NOT NULL,

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

#
# Table structure for table 'tx_sutterbeggdistribution_domain_model_holiday'
#

CREATE TABLE tx_sutterbeggdistribution_domain_model_holiday (

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

	location_id int(11) unsigned DEFAULT NULL,
	name varchar(255) DEFAULT '' NOT NULL,

	start_date int(11) unsigned DEFAULT '0' NOT NULL,
	end_date int(11) unsigned NULL,
	opening_type int(2) unsigned DEFAULT '0' NOT NULL,

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