|
From: <os...@us...> - 2012-03-05 10:02:15
|
Revision: 4067
http://oscss.svn.sourceforge.net/oscss/?rev=4067&view=rev
Author: oscim
Date: 2012-03-05 10:02:05 +0000 (Mon, 05 Mar 2012)
Log Message:
-----------
ajustement des colonne de la db pour les extra , oubli?\195?\169 lors des commit precendent
Modified Paths:
--------------
trunk/catalog/install/includes/sql/mysql/tables/osc_products_extra_fields.sql
trunk/catalog/install/includes/sql/mysql/tables/osc_products_extra_fields_labels.sql
Modified: trunk/catalog/install/includes/sql/mysql/tables/osc_products_extra_fields.sql
===================================================================
--- trunk/catalog/install/includes/sql/mysql/tables/osc_products_extra_fields.sql 2012-03-05 09:50:47 UTC (rev 4066)
+++ trunk/catalog/install/includes/sql/mysql/tables/osc_products_extra_fields.sql 2012-03-05 10:02:05 UTC (rev 4067)
@@ -15,6 +15,7 @@
CREATE TABLE osc_products_extra_fields (
epf_id int unsigned NOT NULL auto_increment,
epf_order int NOT NULL default 0,
+ epf_input_type tinyint(1) NOT NULL default 0,
epf_status tinyint(1) NOT NULL default 1,
epf_uses_value_list tinyint(1) not null default 0,
epf_advanced_search tinyint(1) not null default 1,
Modified: trunk/catalog/install/includes/sql/mysql/tables/osc_products_extra_fields_labels.sql
===================================================================
--- trunk/catalog/install/includes/sql/mysql/tables/osc_products_extra_fields_labels.sql 2012-03-05 09:50:47 UTC (rev 4066)
+++ trunk/catalog/install/includes/sql/mysql/tables/osc_products_extra_fields_labels.sql 2012-03-05 10:02:05 UTC (rev 4067)
@@ -17,6 +17,9 @@
languages_id int NOT NULL,
epf_label varchar(64),
epf_label_help varchar(160) default NULL COMMENT 'aide contextuelle',
+ epf_format varchar(64) NOT NULL,
+ epf_unity_type_id int(11) NOT NULL,
+ epf_unity_id int(11) NOT NULL,
PRIMARY KEY (epf_id, languages_id)
) DEFAULT CHARSET=utf8;
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
|
|
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.
|
|
From: <os...@us...> - 2012-05-11 17:02:25
|
Revision: 4422
http://oscss.svn.sourceforge.net/oscss/?rev=4422&view=rev
Author: oscim
Date: 2012-05-11 17:02:19 +0000 (Fri, 11 May 2012)
Log Message:
-----------
suppression des elements dans le core
Removed Paths:
-------------
trunk/catalog/install/includes/sql/mysql/tables/osc_manufacturers.sql
trunk/catalog/install/includes/sql/mysql/tables/osc_manufacturers_info.sql
Deleted: trunk/catalog/install/includes/sql/mysql/tables/osc_manufacturers.sql
===================================================================
--- trunk/catalog/install/includes/sql/mysql/tables/osc_manufacturers.sql 2012-05-11 17:01:29 UTC (rev 4421)
+++ trunk/catalog/install/includes/sql/mysql/tables/osc_manufacturers.sql 2012-05-11 17:02:19 UTC (rev 4422)
@@ -1,25 +0,0 @@
---+######################################################################--+
---| 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/ |
---+######################################################################--+
-
-
-
-drop table if exists osc_manufacturers;
-create table osc_manufacturers (
- manufacturers_id int(11) not null auto_increment,
- manufacturers_name varchar(32) not null ,
- manufacturers_image varchar(64) ,
- date_added datetime ,
- last_modified datetime ,
- PRIMARY KEY (manufacturers_id),
- KEY IDX_MANUFACTURERS_NAME (manufacturers_name)
-) DEFAULT CHARSET=utf8;
Deleted: trunk/catalog/install/includes/sql/mysql/tables/osc_manufacturers_info.sql
===================================================================
--- trunk/catalog/install/includes/sql/mysql/tables/osc_manufacturers_info.sql 2012-05-11 17:01:29 UTC (rev 4421)
+++ trunk/catalog/install/includes/sql/mysql/tables/osc_manufacturers_info.sql 2012-05-11 17:02:19 UTC (rev 4422)
@@ -1,25 +0,0 @@
---+######################################################################--+
---| 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/ |
---+######################################################################--+
-
-
-
-drop table if exists osc_manufacturers_info;
-create table osc_manufacturers_info (
- manufacturers_id int(11) default '0' not null ,
- languages_id int(11) default '0' not null ,
- manufacturers_url varchar(255) not null ,
- url_clicked int(5) default '0' not null ,
- date_last_click datetime ,
- PRIMARY KEY (manufacturers_id, languages_id)
-) DEFAULT CHARSET=utf8;
-
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
|
|
From: <os...@us...> - 2013-12-17 07:16:31
|
Revision: 4954
http://sourceforge.net/p/oscss/svn/4954
Author: oscim
Date: 2013-12-17 07:16:19 +0000 (Tue, 17 Dec 2013)
Log Message:
-----------
Delete olds tables
Removed Paths:
-------------
trunk/catalog/install/includes/sql/mysql/tables/osc_customers_to_extra_fields.key.sql
trunk/catalog/install/includes/sql/mysql/tables/osc_customers_to_extra_fields.sql
Deleted: trunk/catalog/install/includes/sql/mysql/tables/osc_customers_to_extra_fields.key.sql
===================================================================
--- trunk/catalog/install/includes/sql/mysql/tables/osc_customers_to_extra_fields.key.sql 2013-12-16 17:15:15 UTC (rev 4953)
+++ trunk/catalog/install/includes/sql/mysql/tables/osc_customers_to_extra_fields.key.sql 2013-12-17 07:16:19 UTC (rev 4954)
@@ -1,17 +0,0 @@
---+######################################################################--+
---| 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_customers_to_extra_fields ADD INDEX idx_customers_to_extra_fields (customers_id);
-ALTER TABLE osc_customers_to_extra_fields ADD CONSTRAINT fk_customers_to_extra_fields FOREIGN KEY (customers_id) REFERENCES osc_customers (customers_id);
-
Deleted: trunk/catalog/install/includes/sql/mysql/tables/osc_customers_to_extra_fields.sql
===================================================================
--- trunk/catalog/install/includes/sql/mysql/tables/osc_customers_to_extra_fields.sql 2013-12-16 17:15:15 UTC (rev 4953)
+++ trunk/catalog/install/includes/sql/mysql/tables/osc_customers_to_extra_fields.sql 2013-12-17 07:16:19 UTC (rev 4954)
@@ -1,23 +0,0 @@
---+######################################################################--+
---| 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/ |
---+######################################################################--+
-
-
-drop table if exists osc_customers_to_extra_fields;
-CREATE TABLE osc_customers_to_extra_fields (
- customers_id int(11) NOT NULL default '0',
- fields_id int(11) NOT NULL default '0',
- value text,
- PRIMARY KEY (customers_id,fields_id)
-) DEFAULT CHARSET=utf8;
-
-
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
|
|
From: <os...@us...> - 2014-01-25 11:02:26
|
Revision: 5073
http://sourceforge.net/p/oscss/svn/5073
Author: oscim
Date: 2014-01-25 11:02:22 +0000 (Sat, 25 Jan 2014)
Log Message:
-----------
Fix
Added Paths:
-----------
trunk/catalog/install/includes/sql/mysql/tables/osc_extra_fields_values.sql
Removed Paths:
-------------
trunk/catalog/install/includes/sql/mysql/tables/osc_extra_field_values.sql
Deleted: trunk/catalog/install/includes/sql/mysql/tables/osc_extra_field_values.sql
===================================================================
--- trunk/catalog/install/includes/sql/mysql/tables/osc_extra_field_values.sql 2014-01-25 09:53:10 UTC (rev 5072)
+++ trunk/catalog/install/includes/sql/mysql/tables/osc_extra_field_values.sql 2014-01-25 11:02:22 UTC (rev 5073)
@@ -1,27 +0,0 @@
---+######################################################################--+
---| 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/ |
---+######################################################################--+
-
-
-drop table if exists osc_extra_field_values;
-CREATE TABLE osc_extra_field_values (
- value_id int(10) unsigned NOT NULL AUTO_INCREMENT,
- fields_id int(11) NOT NULL,
- languages_id int(11) NOT NULL,
- parent_id int(10) unsigned NOT NULL DEFAULT '0',
- sort_order int(11) NOT NULL DEFAULT '0',
- fields_value varchar(64) DEFAULT NULL,
- PRIMARY KEY (value_id),
- KEY IDX_EPF (fields_id,languages_id)
-) DEFAULT CHARSET=utf8 ;
-
-
Copied: trunk/catalog/install/includes/sql/mysql/tables/osc_extra_fields_values.sql (from rev 5070, trunk/catalog/install/includes/sql/mysql/tables/osc_extra_field_values.sql)
===================================================================
--- trunk/catalog/install/includes/sql/mysql/tables/osc_extra_fields_values.sql (rev 0)
+++ trunk/catalog/install/includes/sql/mysql/tables/osc_extra_fields_values.sql 2014-01-25 11:02:22 UTC (rev 5073)
@@ -0,0 +1,27 @@
+--+######################################################################--+
+--| 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/ |
+--+######################################################################--+
+
+
+drop table if exists osc_extra_field_values;
+CREATE TABLE osc_extra_field_values (
+ value_id int(10) unsigned NOT NULL AUTO_INCREMENT,
+ fields_id int(11) NOT NULL,
+ languages_id int(11) NOT NULL,
+ parent_id int(10) unsigned NOT NULL DEFAULT '0',
+ sort_order int(11) NOT NULL DEFAULT '0',
+ fields_value varchar(64) DEFAULT NULL,
+ PRIMARY KEY (value_id),
+ KEY IDX_EPF (fields_id,languages_id)
+) DEFAULT CHARSET=utf8 ;
+
+
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
|