|
From: <os...@us...> - 2012-04-13 13:37:36
|
Revision: 4221
http://oscss.svn.sourceforge.net/oscss/?rev=4221&view=rev
Author: oscim
Date: 2012-04-13 13:37:27 +0000 (Fri, 13 Apr 2012)
Log Message:
-----------
Ajout de fichiers d'install de contraintes et jointure externe.
Ces fichiers de liason sont indispensable, m?\195?\170me sans utilisation d'innodb
Added Paths:
-----------
trunk/catalog/install/includes/sql/mysql/tables/osc_products_description.key.sql
trunk/catalog/install/includes/sql/mysql/tables/osc_products_extra_fields_labels.key.sql
trunk/catalog/install/includes/sql/mysql/tables/osc_products_extra_fields_values.key.sql
Added: trunk/catalog/install/includes/sql/mysql/tables/osc_products_description.key.sql
===================================================================
--- trunk/catalog/install/includes/sql/mysql/tables/osc_products_description.key.sql (rev 0)
+++ trunk/catalog/install/includes/sql/mysql/tables/osc_products_description.key.sql 2012-04-13 13:37:27 UTC (rev 4221)
@@ -0,0 +1,20 @@
+--+######################################################################--+
+--| osCSS Open Source E-commerce |
+--+######################################################################--+
+--| Copyright (c) 2005-2011 The osCSS developers |
+--| |
+--| http://www.oscss.org |
+--| Portions Copyright (c) 2003 osCommerce |
+--+######################################################################--+
+--| This source file is subject to version 2.0 of the GPL license, |
+--| available at the following url: |
+--| http://www.oscss.org/ |
+--+######################################################################--+
+
+
+ALTER TABLE osc_products_description ADD INDEX idx_products_description_lgid (language_id);
+ALTER TABLE osc_products_description ADD INDEX idx_products_id (products_id);
+
+
+ALTER TABLE osc_products_description ADD CONSTRAINT fk_products_description_lgid FOREIGN KEY (language_id) REFERENCES osc_languages (languages_id);
+ALTER TABLE osc_products_description ADD CONSTRAINT fk_products_id FOREIGN KEY (products_id) REFERENCES osc_products (products_id);
Added: trunk/catalog/install/includes/sql/mysql/tables/osc_products_extra_fields_labels.key.sql
===================================================================
--- trunk/catalog/install/includes/sql/mysql/tables/osc_products_extra_fields_labels.key.sql (rev 0)
+++ trunk/catalog/install/includes/sql/mysql/tables/osc_products_extra_fields_labels.key.sql 2012-04-13 13:37:27 UTC (rev 4221)
@@ -0,0 +1,21 @@
+--+######################################################################--+
+--| osCSS Open Source E-commerce |
+--+######################################################################--+
+--| Copyright (c) 2005-2011 The osCSS developers |
+--| |
+--| http://www.oscss.org |
+--| Portions Copyright (c) 2003 osCommerce |
+--+######################################################################--+
+--| This source file is subject to version 2.0 of the GPL license, |
+--| available at the following url: |
+--| http://www.oscss.org/ |
+--+######################################################################--+
+
+
+
+ALTER TABLE osc_products_extra_fields_labels ADD INDEX idx_products_extra_fields_labels_lgid (languages_id);
+ALTER TABLE osc_products_extra_fields_labels ADD INDEX idx_epf_id (epf_id);
+
+
+ALTER TABLE osc_products_extra_fields_labels ADD CONSTRAINT fk_osc_products_extra_fields_labels_lgid FOREIGN KEY (languages_id) REFERENCES osc_languages (languages_id);
+ALTER TABLE osc_products_extra_fields_labels ADD CONSTRAINT fk_osc_products_extra_fields_labels_id FOREIGN KEY (epf_id) REFERENCES osc_products_extra_fields (epf_id);
\ No newline at end of file
Added: trunk/catalog/install/includes/sql/mysql/tables/osc_products_extra_fields_values.key.sql
===================================================================
--- trunk/catalog/install/includes/sql/mysql/tables/osc_products_extra_fields_values.key.sql (rev 0)
+++ trunk/catalog/install/includes/sql/mysql/tables/osc_products_extra_fields_values.key.sql 2012-04-13 13:37:27 UTC (rev 4221)
@@ -0,0 +1,21 @@
+--+######################################################################--+
+--| osCSS Open Source E-commerce |
+--+######################################################################--+
+--| Copyright (c) 2005-2011 The osCSS developers |
+--| |
+--| http://www.oscss.org |
+--| Portions Copyright (c) 2003 osCommerce |
+--+######################################################################--+
+--| This source file is subject to version 2.0 of the GPL license, |
+--| available at the following url: |
+--| http://www.oscss.org/ |
+--+######################################################################--+
+
+
+ALTER TABLE osc_products_extra_fields_values ADD INDEX idx_products_extra_fields_labels_lgid (languages_id);
+ALTER TABLE osc_products_extra_fields_values ADD INDEX idx_epf_id (epf_id);
+ALTER TABLE osc_products_extra_fields_values ADD INDEX idx_value_id (value_id);
+
+
+ALTER TABLE osc_products_extra_fields_values ADD CONSTRAINT fk_osc_products_extra_fields_values_lgid FOREIGN KEY (languages_id) REFERENCES osc_languages (languages_id);
+ALTER TABLE osc_products_extra_fields_values ADD CONSTRAINT fk_osc_products_extra_fields_values_epf_id FOREIGN KEY (epf_id) REFERENCES osc_products_extra_fields (epf_id);
\ No newline at end of file
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
|