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

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

	subline varchar(255) DEFAULT '' NOT NULL,
	title varchar(255) DEFAULT '' NOT NULL,
	german_name varchar(255) DEFAULT '' NOT NULL,
	image int(11) unsigned NOT NULL default '0',
	description text,
	variant int(11) unsigned DEFAULT '0' NOT NULL,
	similar int(11) unsigned DEFAULT '0' NOT NULL,
	categories int(11) unsigned DEFAULT '0' NOT NULL,

	tstamp int(11) unsigned DEFAULT '0' NOT NULL,
	crdate int(11) unsigned DEFAULT '0' NOT NULL,
	cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
	deleted smallint(5) unsigned DEFAULT '0' NOT NULL,
	hidden smallint(5) unsigned DEFAULT '0' NOT NULL,
	starttime int(11) unsigned DEFAULT '0' NOT NULL,
	endtime int(11) unsigned DEFAULT '0' NOT NULL,

	t3ver_oid int(11) DEFAULT '0' NOT NULL,
	t3ver_id int(11) DEFAULT '0' NOT NULL,
	t3ver_wsid int(11) DEFAULT '0' NOT NULL,
	t3ver_label varchar(255) DEFAULT '' NOT NULL,
	t3ver_state smallint(6) DEFAULT '0' NOT NULL,
	t3ver_stage int(11) DEFAULT '0' NOT NULL,
	t3ver_count int(11) DEFAULT '0' NOT NULL,
	t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
	t3ver_move_id int(11) DEFAULT '0' NOT NULL,

	sys_language_uid int(11) DEFAULT '0' NOT NULL,
	l10n_parent int(11) DEFAULT '0' NOT NULL,
	l10n_diffsource mediumblob,
	l10n_state text,

	PRIMARY KEY (uid),
	KEY parent (pid),
	KEY t3ver_oid (t3ver_oid,t3ver_wsid),
	KEY language (l10n_parent,sys_language_uid)

);

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

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

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

	title varchar(255) DEFAULT '' NOT NULL,
	replanted int(11) DEFAULT '0' NOT NULL,
	with_wire_balling smallint(5) unsigned DEFAULT '0' NOT NULL,
	width_from varchar(255) DEFAULT '' NOT NULL,
	width_to varchar(255) DEFAULT '' NOT NULL,
	-- part of width
	length varchar(255) DEFAULT '' NOT NULL,
	depth varchar(255) DEFAULT '' NOT NULL,
	diameter_bottom varchar(255) DEFAULT '' NOT NULL,
	diameter_from varchar(255) DEFAULT '' NOT NULL,
	diameter_to varchar(255) DEFAULT '' NOT NULL,
	ball_diameter_from varchar(255) DEFAULT '' NOT NULL,
	ball_diameter_to varchar(255) DEFAULT '' NOT NULL,
	box_size varchar(255) DEFAULT '' NOT NULL,
	diagonal_length varchar(255) DEFAULT '' NOT NULL,
	base_length varchar(255) DEFAULT '' NOT NULL,
	trellis_size varchar(255) DEFAULT '' NOT NULL,
	-- end part of width
	height_from varchar(255) DEFAULT '' NOT NULL,
	height_to varchar(255) DEFAULT '' NOT NULL,
	trunk_height varchar(255) DEFAULT '' NOT NULL,
	trunk_size_from varchar(255) DEFAULT '' NOT NULL,
	trunk_size_to varchar(255) DEFAULT '' NOT NULL,
	trunk_circumference_from varchar(255) DEFAULT '' NOT NULL,
	trunk_circumference_to varchar(255) DEFAULT '' NOT NULL,
	bale_diameter varchar(255) DEFAULT '' NOT NULL,
	weight varchar(255) DEFAULT '' NOT NULL,
	age_from varchar(255) DEFAULT '' NOT NULL,
	age_to varchar(255) DEFAULT '' NOT NULL,

	tstamp int(11) unsigned DEFAULT '0' NOT NULL,
	crdate int(11) unsigned DEFAULT '0' NOT NULL,
	cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
	deleted smallint(5) unsigned DEFAULT '0' NOT NULL,
	hidden smallint(5) unsigned DEFAULT '0' NOT NULL,
	starttime int(11) unsigned DEFAULT '0' NOT NULL,
	endtime int(11) unsigned DEFAULT '0' NOT NULL,

	t3ver_oid int(11) DEFAULT '0' NOT NULL,
	t3ver_id int(11) DEFAULT '0' NOT NULL,
	t3ver_wsid int(11) DEFAULT '0' NOT NULL,
	t3ver_label varchar(255) DEFAULT '' NOT NULL,
	t3ver_state smallint(6) DEFAULT '0' NOT NULL,
	t3ver_stage int(11) DEFAULT '0' NOT NULL,
	t3ver_count int(11) DEFAULT '0' NOT NULL,
	t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
	t3ver_move_id int(11) DEFAULT '0' NOT NULL,

	sys_language_uid int(11) DEFAULT '0' NOT NULL,
	l10n_parent int(11) DEFAULT '0' NOT NULL,
	l10n_diffsource mediumblob,
	l10n_state text,

	PRIMARY KEY (uid),
	KEY parent (pid),
	KEY t3ver_oid (t3ver_oid,t3ver_wsid),
	KEY language (l10n_parent,sys_language_uid)

);

#
# Table structure for table 'tx_h2products_product_product_mm'
#
CREATE TABLE tx_h2products_product_product_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)
);