mromy 2005/03/17 11:44:46 CET
Modified files: (Branch: JAHIA-4-0-BRANCH)
var/db intersystems_cache.script
jsqlconnect.script mysql.script
oracle.script postgresql.script
sqlserver_jtds.script
sqlserver_tds.script
Log:
- changed length of left_oid, right_oid and type fields in jahia_link table
Revision Changes Path
1.19.2.1 +1 -1 jahia/var/db/intersystems_cache.script
http://jahia.mine.nu:8080/cgi-bin/cvsweb.cgi/jahia/var/db/intersystems_cache.script.diff?r1=1.19&r2=1.19.2.1&f=h
1.17.2.1 +1 -1 jahia/var/db/jsqlconnect.script
http://jahia.mine.nu:8080/cgi-bin/cvsweb.cgi/jahia/var/db/jsqlconnect.script.diff?r1=1.17&r2=1.17.2.1&f=h
1.42.2.3 +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.2.2&r2=1.42.2.3&f=h
1.33.2.1 +1 -1 jahia/var/db/oracle.script
http://jahia.mine.nu:8080/cgi-bin/cvsweb.cgi/jahia/var/db/oracle.script.diff?r1=1.33&r2=1.33.2.1&f=h
1.38.2.2 +1 -1 jahia/var/db/postgresql.script
http://jahia.mine.nu:8080/cgi-bin/cvsweb.cgi/jahia/var/db/postgresql.script.diff?r1=1.38.2.1&r2=1.38.2.2&f=h
1.16.2.1 +1 -1 jahia/var/db/sqlserver_jtds.script
http://jahia.mine.nu:8080/cgi-bin/cvsweb.cgi/jahia/var/db/sqlserver_jtds.script.diff?r1=1.16&r2=1.16.2.1&f=h
1.27.2.1 +1 -1 jahia/var/db/sqlserver_tds.script
http://jahia.mine.nu:8080/cgi-bin/cvsweb.cgi/jahia/var/db/sqlserver_tds.script.diff?r1=1.27&r2=1.27.2.1&f=h
Index: intersystems_cache.script
===================================================================
RCS file: /cvs/jahia/var/db/Attic/intersystems_cache.script,v
retrieving revision 1.19
retrieving revision 1.19.2.1
diff -u -r1.19 -r1.19.2.1
--- intersystems_cache.script 14 Jan 2004 16:53:22 -0000 1.19
+++ intersystems_cache.script 17 Mar 2005 10:44:45 -0000 1.19.2.1
@@ -68,7 +68,7 @@
CREATE TABLE jahia_pages_prop (page_id int, prop_name varchar(255),
prop_value varchar(255), language_code varchar(255),PRIMARY KEY (page_id,
prop_name, language_code))
-CREATE TABLE jahia_link (id int, left_oid varchar(255), right_oid
varchar(255), type varchar(255), status int, creation_date timestamp,
creation_user varchar(255), lastmodif_date timestamp, lastmodif_user
varchar(255), PRIMARY KEY (id))
+CREATE TABLE jahia_link (id int, left_oid varchar(100), right_oid
varchar(100), type varchar(100), status int, creation_date timestamp,
creation_user varchar(255), lastmodif_date timestamp, lastmodif_user
varchar(255), PRIMARY KEY (id))
CREATE TABLE jahia_link_metadata (link_id int, link_position varchar(20) ,
property_name varchar(255), property_value varchar(255), PRIMARY KEY (link_id,
link_position, property_name) )
CREATE TABLE jahia_resources (name_resource varchar(200), value_resource
varchar(255), languagecode_resource varchar(10), PRIMARY KEY (name_resource,
languagecode_resource))
Index: jsqlconnect.script
===================================================================
RCS file: /cvs/jahia/var/db/Attic/jsqlconnect.script,v
retrieving revision 1.17
retrieving revision 1.17.2.1
diff -u -r1.17 -r1.17.2.1
--- jsqlconnect.script 14 Jan 2004 16:53:22 -0000 1.17
+++ jsqlconnect.script 17 Mar 2005 10:44:45 -0000 1.17.2.1
@@ -65,7 +65,7 @@
CREATE TABLE jahia_site_lang_maps (id int NULL, site_id int NULL,
from_lang_code nvarchar(255) NULL, to_lang_code nvarchar(255) NULL)
CREATE TABLE jahia_pages_prop (page_id int NULL, prop_name nvarchar (255)
NULL, prop_value nvarchar (255) NULL, language_code nvarchar (255) NULL)
-CREATE TABLE jahia_link (id int NULL, left_oid nvarchar(255) NULL, right_oid
nvarchar(255) NULL, type nvarchar(255) NULL, status int NULL, creation_date
datetime NULL, creation_user nvarchar(255) NULL, lastmodif_date datetime NULL,
lastmodif_user nvarchar(255) NULL)
+CREATE TABLE jahia_link (id int NULL, left_oid nvarchar(100) NULL, right_oid
nvarchar(100) NULL, type nvarchar(100) NULL, status int NULL, creation_date
datetime NULL, creation_user nvarchar(255) NULL, lastmodif_date datetime NULL,
lastmodif_user nvarchar(255) NULL)
CREATE TABLE jahia_link_metadata (link_id int NULL, link_position
nvarchar(20) NULL, property_name nvarchar(255) NULL, property_value
nvarchar(255) NULL )
CREATE TABLE jahia_resources (name_resource nvarchar(200) NULL,
value_resource nvarchar(255) NULL, languagecode_resource nvarchar(10) NULL)
Index: mysql.script
===================================================================
RCS file: /cvs/jahia/var/db/Attic/mysql.script,v
retrieving revision 1.42.2.2
retrieving revision 1.42.2.3
diff -u -r1.42.2.2 -r1.42.2.3
--- mysql.script 3 Mar 2005 14:41:06 -0000 1.42.2.2
+++ mysql.script 17 Mar 2005 10:44:45 -0000 1.42.2.3
@@ -64,7 +64,7 @@
CREATE TABLE jahia_site_lang_maps (id mediumint(9) NOT NULL, site_id
mediumint(9), from_lang_code varchar(255), to_lang_code varchar(255),PRIMARY
KEY (id));
CREATE TABLE jahia_pages_prop (page_id mediumint(9) NOT NULL, prop_name
varchar(150) BINARY NOT NULL, prop_value varchar(255), language_code
varchar(20) NOT NULL,PRIMARY KEY (page_id, prop_name, language_code));
-CREATE TABLE jahia_link (id mediumint(9) NOT NULL, left_oid varchar(255),
right_oid varchar(255), type varchar(255), status mediumint(9), creation_date
timestamp, creation_user varchar(255), lastmodif_date timestamp, lastmodif_user
varchar(255), PRIMARY KEY (id));
+CREATE TABLE jahia_link (id mediumint(9) NOT NULL, left_oid varchar(100),
right_oid varchar(100), type varchar(100), status mediumint(9), creation_date
timestamp, creation_user varchar(255), lastmodif_date timestamp, lastmodif_user
varchar(255), PRIMARY KEY (id));
CREATE TABLE jahia_link_metadata (link_id mediumint(9) NOT NULL,
link_position varchar(20) NOT NULL, property_name varchar(255) BINARY NOT NULL,
property_value varchar(255), PRIMARY KEY (link_id, link_position,
property_name) );
CREATE TABLE jahia_resources (name_resource varchar(200) BINARY NOT NULL,
value_resource varchar(255), languagecode_resource varchar(10) NOT NULL,
PRIMARY KEY (name_resource, languagecode_resource));
Index: oracle.script
===================================================================
RCS file: /cvs/jahia/var/db/Attic/oracle.script,v
retrieving revision 1.33
retrieving revision 1.33.2.1
diff -u -r1.33 -r1.33.2.1
--- oracle.script 14 Jan 2004 16:53:22 -0000 1.33
+++ oracle.script 17 Mar 2005 10:44:45 -0000 1.33.2.1
@@ -65,7 +65,7 @@
CREATE TABLE jahia_pages_prop (page_id NUMBER(10) NULL, prop_name VARCHAR2
(255) NULL, prop_value VARCHAR2 (255) NULL, language_code VARCHAR2 (255) NULL)
-CREATE TABLE jahia_link (id NUMBER(10) NULL, left_oid VARCHAR2 (255) NULL,
right_oid VARCHAR2 (255) NULL, type VARCHAR2 (255) NULL, status NUMBER(10)
NULL, creation_date DATE NULL, creation_user VARCHAR2 (255) NULL,
lastmodif_date DATE NULL, lastmodif_user VARCHAR2 (255) NULL)
+CREATE TABLE jahia_link (id NUMBER(10) NULL, left_oid VARCHAR2 (100) NULL,
right_oid VARCHAR2 (100) NULL, type VARCHAR2 (100) NULL, status NUMBER(10)
NULL, creation_date DATE NULL, creation_user VARCHAR2 (255) NULL,
lastmodif_date DATE NULL, lastmodif_user VARCHAR2 (255) NULL)
CREATE TABLE jahia_link_metadata (link_id NUMBER(10) NULL, link_position
VARCHAR2(20) NULL, property_name VARCHAR2(255) NULL, property_value
VARCHAR2(255) NULL)
CREATE TABLE jahia_resources (name_resource VARCHAR2(200) NULL,
value_resource VARCHAR2(255) NULL, languagecode_resource VARCHAR2(10) NULL)
Index: postgresql.script
===================================================================
RCS file: /cvs/jahia/var/db/Attic/postgresql.script,v
retrieving revision 1.38.2.1
retrieving revision 1.38.2.2
diff -u -r1.38.2.1 -r1.38.2.2
--- postgresql.script 24 Sep 2004 12:02:09 -0000 1.38.2.1
+++ postgresql.script 17 Mar 2005 10:44:45 -0000 1.38.2.2
@@ -66,7 +66,7 @@
CREATE TABLE jahia_pages_prop (page_id int, prop_name varchar(255),
prop_value varchar(255), language_code varchar(255),PRIMARY KEY (page_id,
prop_name, language_code));
-CREATE TABLE jahia_link (id int, left_oid varchar(255), right_oid
varchar(255), type varchar(255), status int, creation_date timestamp,
creation_user varchar(255), lastmodif_date timestamp, lastmodif_user
varchar(255), PRIMARY KEY (id))
+CREATE TABLE jahia_link (id int, left_oid varchar(100), right_oid
varchar(100), type varchar(100), status int, creation_date timestamp,
creation_user varchar(255), lastmodif_date timestamp, lastmodif_user
varchar(255), PRIMARY KEY (id))
CREATE TABLE jahia_link_metadata (link_id int, link_position varchar(20),
property_name varchar(255), property_value varchar(255), PRIMARY KEY (link_id,
link_position, property_name) )
CREATE TABLE jahia_resources (name_resource varchar(200), value_resource
varchar(255), languagecode_resource varchar(10), PRIMARY KEY (name_resource,
languagecode_resource))
Index: sqlserver_jtds.script
===================================================================
RCS file: /cvs/jahia/var/db/Attic/sqlserver_jtds.script,v
retrieving revision 1.16
retrieving revision 1.16.2.1
diff -u -r1.16 -r1.16.2.1
--- sqlserver_jtds.script 14 Jan 2004 16:53:22 -0000 1.16
+++ sqlserver_jtds.script 17 Mar 2005 10:44:45 -0000 1.16.2.1
@@ -65,7 +65,7 @@
CREATE TABLE jahia_site_lang_maps (id int NULL, site_id int NULL,
from_lang_code nvarchar(255) NULL, to_lang_code nvarchar(255) NULL)
CREATE TABLE jahia_pages_prop (page_id int NULL, prop_name nvarchar (255)
NULL, prop_value nvarchar (255) NULL, language_code nvarchar (255) NULL)
-CREATE TABLE jahia_link (id int NULL, left_oid nvarchar(255) NULL, right_oid
nvarchar(255) NULL, type nvarchar(255) NULL, status int NULL, creation_date
datetime NULL, creation_user nvarchar(255) NULL, lastmodif_date datetime NULL,
lastmodif_user nvarchar(255) NULL)
+CREATE TABLE jahia_link (id int NULL, left_oid nvarchar(100) NULL, right_oid
nvarchar(100) NULL, type nvarchar(100) NULL, status int NULL, creation_date
datetime NULL, creation_user nvarchar(255) NULL, lastmodif_date datetime NULL,
lastmodif_user nvarchar(255) NULL)
CREATE TABLE jahia_link_metadata (link_id int NULL, link_position
nvarchar(20) NULL, property_name nvarchar(255) NULL, property_value
nvarchar(255) NULL )
CREATE TABLE jahia_resources (name_resource nvarchar(200) NULL,
value_resource nvarchar(255) NULL, languagecode_resource nvarchar(10) NULL)
Index: sqlserver_tds.script
===================================================================
RCS file: /cvs/jahia/var/db/Attic/sqlserver_tds.script,v
retrieving revision 1.27
retrieving revision 1.27.2.1
diff -u -r1.27 -r1.27.2.1
--- sqlserver_tds.script 14 Jan 2004 16:53:22 -0000 1.27
+++ sqlserver_tds.script 17 Mar 2005 10:44:45 -0000 1.27.2.1
@@ -64,7 +64,7 @@
CREATE TABLE jahia_site_lang_maps (id int NULL, site_id int NULL,
from_lang_code nvarchar(255) NULL, to_lang_code nvarchar(255) NULL)
CREATE TABLE jahia_pages_prop (page_id int NULL, prop_name nvarchar (255)
NULL, prop_value nvarchar (255) NULL, language_code nvarchar (255) NULL)
-CREATE TABLE jahia_link (id int NULL, left_oid nvarchar(255) NULL, right_oid
nvarchar(255) NULL, type nvarchar(255) NULL, status int NULL, creation_date
datetime NULL, creation_user nvarchar(255) NULL, lastmodif_date datetime NULL,
lastmodif_user nvarchar(255) NULL)
+CREATE TABLE jahia_link (id int NULL, left_oid nvarchar(100) NULL, right_oid
nvarchar(100) NULL, type nvarchar(100) NULL, status int NULL, creation_date
datetime NULL, creation_user nvarchar(255) NULL, lastmodif_date datetime NULL,
lastmodif_user nvarchar(255) NULL)
CREATE TABLE jahia_link_metadata (link_id int NULL, link_position
nvarchar(20) NULL, property_name nvarchar(255) NULL, property_value
nvarchar(255) NULL )
CREATE TABLE jahia_resources (name_resource nvarchar(200) NULL,
value_resource nvarchar(255) NULL, languagecode_resource nvarchar(10) NULL)
