CREATE TABLE tx_product_domain_model_product (
   title varchar(255) NOT NULL DEFAULT '',
   sorting int(11) unsigned DEFAULT '0' NOT NULL,
   description text DEFAULT '' NULL,
   image int(11) unsigned NOT NULL DEFAULT '0',
   categories int(11) DEFAULT '0' NOT NULL
);

#
# Table structure for table 'tx_product_domain_model_category'
#
CREATE TABLE tx_product_domain_model_category (
    name varchar(255) DEFAULT '' NOT NULL,
    sorting int(11) unsigned DEFAULT '0' NOT NULL,
);

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