[Oscss-commit] SF.net SVN: oscss:[4221] trunk/catalog/install/includes/sql/mysql/tables

[<os...@us...>]

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.