thelia.sql :
# This is a fix for InnoDB in MySQL >= 4.1.x
# It "suspends judgement" for fkey relationships until are tables are set.
SET FOREIGN_KEY_CHECKS = 0;
-- ---------------------------------------------------------------------
-- product_rel
-- ---------------------------------------------------------------------
DROP TABLE IF EXISTS `product_rel`;
CREATE TABLE `product_rel`
(
`id` INTEGER NOT NULL AUTO_INCREMENT,
`visible` TINYINT DEFAULT 0 NOT NULL,
`position` INTEGER DEFAULT 0 NOT NULL,
`product_id` INTEGER(11),
`created_at` DATETIME,
`updated_at` DATETIME,
`version` INTEGER DEFAULT 0,
`version_created_at` DATETIME,
`version_created_by` VARCHAR(100),
PRIMARY KEY (`id`),
INDEX `FI_product_id` (`product_id`),
CONSTRAINT `fk_product_id`
FOREIGN KEY (`product_id`)
REFERENCES `product` (`id`)
ON UPDATE RESTRICT
ON DELETE CASCADE
) ENGINE=InnoDB;
-- ---------------------------------------------------------------------
-- product_rel_i18n
-- ---------------------------------------------------------------------
DROP TABLE IF EXISTS `product_rel_i18n`;
CREATE TABLE `product_rel_i18n`
(
`id` INTEGER NOT NULL,
`locale` VARCHAR(5) DEFAULT 'en_US' NOT NULL,
`title` VARCHAR(255),
`description` LONGTEXT,
`chapo` TEXT,
`postscriptum` TEXT,
PRIMARY KEY (`id`,`locale`),
CONSTRAINT `product_rel_i18n_FK_1`
FOREIGN KEY (`id`)
REFERENCES `product_rel` (`id`)
ON DELETE CASCADE
) ENGINE=InnoDB;
-- ---------------------------------------------------------------------
-- product_rel_version
-- ---------------------------------------------------------------------
DROP TABLE IF EXISTS `product_rel_version`;
CREATE TABLE `product_rel_version`
(
`id` INTEGER NOT NULL,
`visible` TINYINT DEFAULT 0 NOT NULL,
`position` INTEGER DEFAULT 0 NOT NULL,
`product_id` INTEGER(11),
`created_at` DATETIME,
`updated_at` DATETIME,
`version` INTEGER DEFAULT 0 NOT NULL,
`version_created_at` DATETIME,
`version_created_by` VARCHAR(100),
`product_id_version` INTEGER DEFAULT 0,
PRIMARY KEY (`id`,`version`),
CONSTRAINT `product_rel_version_FK_1`
FOREIGN KEY (`id`)
REFERENCES `product_rel` (`id`)
ON DELETE CASCADE
) ENGINE=InnoDB;
# This restores the fkey checks, after having unset them earlier
SET FOREIGN_KEY_CHECKS = 1;
C'est en gros l'exemple généré en ligne de commande...
Je viens de remarquer qu'il il avait un ligne vide au début... Est-ce un problème ?
J'ai délclaré le postaction dans :
C:\wamp64\www\thelia-test\thelia1\local\modules\ArtabanMPTTest1SellerShop\ArtabanMPTTest1SellerShop.php
Merci de ton aide ;-)