tdraier 2005/05/03 11:01:46 CEST
Modified files: (Branch: JAHIA-4-1-BRANCH)
var/db oracle.script
Log:
nullable cols in oracle script
Revision Changes Path
1.33.4.8 +14 -14 jahia/var/db/oracle.script
http://jahia.mine.nu:8080/cgi-bin/cvsweb.cgi/jahia/var/db/oracle.script.diff?r1=1.33.4.7&r2=1.33.4.8&f=h
Index: oracle.script
===================================================================
RCS file: /home/cvs/repository/jahia/var/db/Attic/oracle.script,v
retrieving revision 1.33.4.7
retrieving revision 1.33.4.8
diff -u -r1.33.4.7 -r1.33.4.8
--- oracle.script 2 May 2005 13:53:35 -0000 1.33.4.7
+++ oracle.script 3 May 2005 09:01:46 -0000 1.33.4.8
@@ -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(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(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(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)
+CREATE TABLE jahia_sl2_uri(uri_id NUMBER (20, 0) NULL,uri_string VARCHAR2
(255) NULL,namespace NUMBER(10))
+CREATE TABLE jahia_sl2_object(uri_id NUMBER (20, 0) NULL,class_name
VARCHAR2 (255) NULL)
+CREATE TABLE jahia_sl2_binding(uri_id NUMBER (20, 0) NULL,name VARCHAR2
(255) NULL,child_uuri_id NUMBER (20, 0) NULL)
+CREATE TABLE jahia_sl2_parent_binding(uri_id NUMBER (20, 0) NULL,name
VARCHAR2 (255) NULL,parent_uuri_id NUMBER (20, 0) NULL)
+CREATE TABLE jahia_sl2_links(uri_id NUMBER (20, 0) NULL,link_to_id NUMBER
(20, 0) NULL)
+CREATE TABLE jahia_sl2_locks(lock_id NUMBER (20, 0) NULL,object_id NUMBER
(20, 0) NULL,subject_id NUMBER (20, 0) NULL,type_id NUMBER (20, 0)
NULL,expiration_date VARCHAR2 (25) NULL,is_inheritable NUMBER(1)
NULL,is_exclusive NUMBER(1) NULL,owner VARCHAR2 (255))
+CREATE TABLE jahia_sl2_branch(branch_id NUMBER (20, 0) NULL,branch_string
VARCHAR2 (255),namespace NUMBER(10))
+CREATE TABLE jahia_sl2_label(label_id NUMBER (20, 0) NULL,label_string
VARCHAR2 (255),namespace NUMBER(10))
+CREATE TABLE jahia_sl2_version(uri_id NUMBER (20, 0) NULL,is_versioned
NUMBER(1))
+CREATE TABLE jahia_sl2_version_history(version_id NUMBER (20, 0)
NULL,uri_id NUMBER (20, 0) NULL,branch_id NUMBER (20, 0) NULL,revision_no
VARCHAR2 (20))
+CREATE TABLE jahia_sl2_version_preds(version_id NUMBER (20, 0)
NULL,predecessor_id NUMBER (20, 0) NULL)
+CREATE TABLE jahia_sl2_version_labels(version_id NUMBER (20, 0)
NULL,label_id NUMBER (20, 0) NULL)
+CREATE TABLE jahia_sl2_properties(version_id NUMBER (20, 0)
NULL,property_namespace VARCHAR2 (50) NULL,property_name VARCHAR2 (50)
NULL,property_value VARCHAR2 (255) NULL,property_type VARCHAR2 (50)
NULL,is_protected NUMBER(1) NULL)
+CREATE TABLE jahia_sl2_permissions(object_id NUMBER (20, 0) NULL,subject_id
NUMBER (20, 0) NULL,action_id NUMBER (20, 0) NULL,version_no VARCHAR2
(20),is_inheritable NUMBER(1) NULL,is_negative NUMBER(1) NULL,succession
NUMBER(10) NULL)
