shuber 2004/09/23 15:18:02 CEST
Modified files: (Branch: JAHIA-4-0-BRANCH)
var/db mysql.script
Log:
Committed MySQL BINARY patch by Jeremy Torres that enforces case sensitive index
checks on the jahia_fields_def column.
Revision Changes Path
1.42.2.1 +1 -1 jahia/var/db/mysql.script
http://jahia.mine.nu:8080/cgi-bin/cvsweb.cgi/jahia/var/db/mysql.script.diff?r1=1.42&r2=1.42.2.1&f=h
Index: mysql.script
===================================================================
RCS file: /home/cvs/repository/jahia/var/db/Attic/mysql.script,v
retrieving revision 1.42
retrieving revision 1.42.2.1
diff -u -r1.42 -r1.42.2.1
--- mysql.script 14 Jan 2004 16:53:22 -0000 1.42
+++ mysql.script 23 Sep 2004 13:18:01 -0000 1.42.2.1
@@ -30,7 +30,7 @@
CREATE TABLE jahia_ctn_struct (ctnsubdefid_jahia_ctn_struct mediumint(9) NOT
NULL,objtype_jahia_ctn_struct mediumint(9) NOT NULL,objdefid_jahia_ctn_struct
mediumint(9) NOT NULL,rank_jahia_ctn_struct mediumint(9),PRIMARY KEY
(ctnsubdefid_jahia_ctn_struct,objtype_jahia_ctn_struct,objdefid_jahia_ctn_struct));
CREATE TABLE jahia_db_test (testfield varchar(255));
CREATE TABLE jahia_fields_data (id_jahia_fields_data mediumint(9) NOT
NULL,jahiaid_jahia_fields_data mediumint(9),pageid_jahia_fields_data
mediumint(9),ctnid_jahia_fields_data mediumint(9),fielddefid_jahia_fields_data
mediumint(9),type_jahia_fields_data mediumint(9),connecttype_jahia_fields_data
mediumint(9),value_jahia_fields_data varchar(250),rank_jahia_fields_data
mediumint(9),rights_jahia_fields_data mediumint(9),version_id bigint(20) NOT
NULL,workflow_state mediumint(9) NOT NULL,language_code varchar(250) NOT NULL,PRIMARY
KEY (id_jahia_fields_data, version_id, workflow_state,language_code));
-CREATE TABLE jahia_fields_def (id_jahia_fields_def
mediumint(9),jahiaid_jahia_fields_def mediumint(9) NOT NULL,name_jahia_fields_def
varchar(250) NOT NULL, PRIMARY KEY (jahiaid_jahia_fields_def, name_jahia_fields_def));
+CREATE TABLE jahia_fields_def (id_jahia_fields_def
mediumint(9),jahiaid_jahia_fields_def mediumint(9) NOT NULL,name_jahia_fields_def
varchar(250) BINARY NOT NULL, PRIMARY KEY (jahiaid_jahia_fields_def,
name_jahia_fields_def));
CREATE TABLE jahia_fields_def_prop (id_jahia_fields_def_prop mediumint(9) NOT
NULL,flddefid_jahia_fields_def_prop mediumint(9),pdefid_jahia_fields_def_prop
mediumint(9),title_jahia_fields_def_prop varchar(250),type_jahia_fields_def_prop
mediumint(9),default_jahia_fields_def_prop varchar(250),PRIMARY KEY
(id_jahia_fields_def_prop));
CREATE TABLE jahia_fields_def_extprop (id_jahia_fields_def mediumint(9) NOT NULL,
prop_name varchar(200) BINARY NOT NULL, prop_value varchar(255) , PRIMARY KEY
(id_jahia_fields_def, prop_name));
CREATE TABLE jahia_fields_prop (fieldid_jahia_fields_prop mediumint(9) NOT
NULL,propertyname_jahia_fields_prop varchar(250) BINARY NOT
NULL,propvalue_jahia_fields_prop varchar(50),PRIMARY KEY
(fieldid_jahia_fields_prop,propertyname_jahia_fields_prop));
