tdraier 2005/04/28 11:33:24 CEST
Modified files: (Branch: JAHIA-4-1-BRANCH)
var/db oracle.script
Log:
fixed oracle schema
Revision Changes Path
1.33.4.6 +7 -7 jahia/var/db/oracle.script
http://jahia.mine.nu:8080/cgi-bin/cvsweb.cgi/jahia/var/db/oracle.script.diff?r1=1.33.4.5&r2=1.33.4.6&f=h
Index: oracle.script
===================================================================
RCS file: /home/cvs/repository/jahia/var/db/Attic/oracle.script,v
retrieving revision 1.33.4.5
retrieving revision 1.33.4.6
diff -u -r1.33.4.5 -r1.33.4.6
--- oracle.script 15 Apr 2005 15:20:25 -0000 1.33.4.5
+++ oracle.script 28 Apr 2005 09:33:24 -0000 1.33.4.6
@@ -79,17 +79,17 @@
CREATE TABLE jahia_locks (name_locks VARCHAR2(50) NULL, targetid_locks
NUMBER(10) NULL, action_locks VARCHAR2(50) NULL, owner_locks VARCHAR2(50) NULL,
contextid_locks VARCHAR2(80) NULL, timeout_locks NUMBER(10) NULL, stolen_locks
VARCHAR2(10) NULL)
-CREATE TABLE jahia_sl2_uri(uri_id NUMBER (20, 0) NOT NULL,uri_string
VARCHAR2 (255) NOT NULL,namespace NUMBER);
+CREATE TABLE jahia_sl2_uri(uri_id NUMBER (20, 0) NOT NULL,uri_string
VARCHAR2 (255) NOT NULL,namespace NUMBER(10));
CREATE TABLE jahia_sl2_object(uri_id NUMBER (20, 0) NOT NULL,class_name
VARCHAR2 (255) NOT NULL);
CREATE TABLE jahia_sl2_binding(uri_id NUMBER (20, 0) NOT NULL,name VARCHAR2
(255) NOT NULL,child_uuri_id NUMBER (20, 0) NOT NULL);
CREATE TABLE jahia_sl2_parent_binding(uri_id NUMBER (20, 0) NOT NULL,name
VARCHAR2 (255) NOT NULL,parent_uuri_id NUMBER (20, 0) NOT NULL);
CREATE TABLE jahia_sl2_links(uri_id NUMBER (20, 0) NOT NULL,link_to_id
NUMBER (20, 0) NOT NULL);
-CREATE TABLE jahia_sl2_locks(lock_id NUMBER (20, 0) NOT NULL,object_id
NUMBER (20, 0) NOT NULL,subject_id NUMBER (20, 0) NOT NULL,type_id NUMBER (20,
0) NOT NULL,expiration_date VARCHAR2 (25) NOT NULL,is_inheritable NUMBER NOT
NULL,is_exclusive NUMBER NOT NULL,owner VARCHAR2 (255));
-CREATE TABLE jahia_sl2_branch(branch_id NUMBER (20, 0) NOT
NULL,branch_string VARCHAR2 (255),namespace NUMBER);
-CREATE TABLE jahia_sl2_label(label_id NUMBER (20, 0) NOT NULL,label_string
VARCHAR2 (255),namespace NUMBER);
-CREATE TABLE jahia_sl2_version(uri_id NUMBER (20, 0) NOT NULL,is_versioned
NUMBER);
+CREATE TABLE jahia_sl2_locks(lock_id NUMBER (20, 0) NOT NULL,object_id
NUMBER (20, 0) NOT NULL,subject_id NUMBER (20, 0) NOT NULL,type_id NUMBER (20,
0) NOT NULL,expiration_date VARCHAR2 (25) NOT NULL,is_inheritable NUMBER(1) NOT
NULL,is_exclusive NUMBER(1) NOT NULL,owner VARCHAR2 (255));
+CREATE TABLE jahia_sl2_branch(branch_id NUMBER (20, 0) NOT
NULL,branch_string VARCHAR2 (255),namespace NUMBER(10));
+CREATE TABLE jahia_sl2_label(label_id NUMBER (20, 0) NOT NULL,label_string
VARCHAR2 (255),namespace NUMBER(10));
+CREATE TABLE jahia_sl2_version(uri_id NUMBER (20, 0) NOT NULL,is_versioned
NUMBER(1));
CREATE TABLE jahia_sl2_version_history(version_id NUMBER (20, 0) NOT
NULL,uri_id NUMBER (20, 0) NOT NULL,branch_id NUMBER (20, 0) NOT
NULL,revision_no VARCHAR2 (20));
CREATE TABLE jahia_sl2_version_preds(version_id NUMBER (20, 0) NOT
NULL,predecessor_id NUMBER (20, 0) NOT NULL);
CREATE TABLE jahia_sl2_version_labels(version_id NUMBER (20, 0) NOT
NULL,label_id NUMBER (20, 0) NOT NULL);
-CREATE TABLE jahia_sl2_properties(version_id NUMBER (20, 0) NOT
NULL,property_namespace VARCHAR2 (50) NOT NULL,property_name VARCHAR2 (50) NOT
NULL,property_value VARCHAR2 (255) NOT NULL,property_type VARCHAR2 (50) NOT
NULL,is_protected NUMBER NOT NULL);
-CREATE TABLE jahia_sl2_permissions(object_id NUMBER (20, 0) NOT
NULL,subject_id NUMBER (20, 0) NOT NULL,action_id NUMBER (20, 0) NOT
NULL,version_no VARCHAR2 (20),is_inheritable NUMBER NOT NULL,is_negative NUMBER
NOT NULL,succession NUMBER NOT NULL);
+CREATE TABLE jahia_sl2_properties(version_id NUMBER (20, 0) NOT
NULL,property_namespace VARCHAR2 (50) NOT NULL,property_name VARCHAR2 (50) NOT
NULL,property_value VARCHAR2 (255) NOT NULL,property_type VARCHAR2 (50) NOT
NULL,is_protected NUMBER(1) NOT NULL);
+CREATE TABLE jahia_sl2_permissions(object_id NUMBER (20, 0) NOT
NULL,subject_id NUMBER (20, 0) NOT NULL,action_id NUMBER (20, 0) NOT
NULL,version_no VARCHAR2 (20),is_inheritable NUMBER(1) NOT NULL,is_negative
NUMBER(1) NOT NULL,succession NUMBER(10) NOT NULL);
