tdraier 2005/04/11 12:21:04 CEST
Modified files: (Branch: JAHIA-4-1-BRANCH)
var/db mysql.script
Log:
use innodb tables
Revision Changes Path
1.42.2.1.2.5 +14 -14 jahia/var/db/mysql.script
http://jahia.mine.nu:8080/cgi-bin/cvsweb.cgi/jahia/var/db/mysql.script.diff?r1=1.42.2.1.2.4&r2=1.42.2.1.2.5&f=h
Index: mysql.script
===================================================================
RCS file: /home/cvs/repository/jahia/var/db/Attic/mysql.script,v
retrieving revision 1.42.2.1.2.4
retrieving revision 1.42.2.1.2.5
diff -u -r1.42.2.1.2.4 -r1.42.2.1.2.5
--- mysql.script 7 Apr 2005 16:30:44 -0000 1.42.2.1.2.4
+++ mysql.script 11 Apr 2005 10:21:03 -0000 1.42.2.1.2.5
@@ -78,17 +78,17 @@
CREATE TABLE jahia_locks (name_locks VARCHAR(50) NOT NULL, targetid_locks
mediumint(9) NOT NULL, action_locks VARCHAR(50) NOT NULL, owner_locks
VARCHAR(50), contextid_locks VARCHAR(80), timeout_locks mediumint(9),
stolen_locks VARCHAR(10), PRIMARY KEY(name_locks, targetid_locks, action_locks))
-CREATE TABLE jahia_sl2_uri(uri_id BIGINT NOT NULL,uri_string VARCHAR (255)
NOT NULL,namespace INTEGER,PRIMARY KEY(uri_id),INDEX jahia_sl2_uri_index
(uri_string, namespace));
-CREATE TABLE jahia_sl2_object(uri_id BIGINT NOT NULL,class_name VARCHAR
(255) NOT NULL,PRIMARY KEY(uri_id));
-CREATE TABLE jahia_sl2_binding(uri_id BIGINT NOT NULL,name VARCHAR (255) NOT
NULL,child_uuri_id BIGINT NOT NULL,PRIMARY KEY(uri_id,name,child_uuri_id));
-CREATE TABLE jahia_sl2_parent_binding(uri_id BIGINT NOT NULL,name VARCHAR
(255) NOT NULL,parent_uuri_id BIGINT NOT NULL,PRIMARY
KEY(uri_id,name,parent_uuri_id));
-CREATE TABLE jahia_sl2_links(uri_id BIGINT NOT NULL,link_to_id BIGINT NOT
NULL,PRIMARY KEY(uri_id,link_to_id));
-CREATE TABLE jahia_sl2_locks(lock_id BIGINT NOT NULL,object_id BIGINT NOT
NULL,subject_id BIGINT NOT NULL,type_id BIGINT NOT NULL,expiration_date VARCHAR
(25) NOT NULL,is_inheritable INTEGER NOT NULL,is_exclusive INTEGER NOT
NULL,owner VARCHAR (255),PRIMARY KEY(lock_id));
-CREATE TABLE jahia_sl2_branch(branch_id BIGINT NOT NULL,branch_string
VARCHAR (255),namespace INTEGER,PRIMARY KEY(branch_id));
-CREATE TABLE jahia_sl2_label(label_id BIGINT NOT NULL,label_string VARCHAR
(255),namespace INTEGER,PRIMARY KEY(label_id));
-CREATE TABLE jahia_sl2_version(uri_id BIGINT NOT NULL,is_versioned
INTEGER,PRIMARY KEY(uri_id));
-CREATE TABLE jahia_sl2_version_history(version_id BIGINT NOT NULL,uri_id
BIGINT NOT NULL,branch_id BIGINT NOT NULL,revision_no VARCHAR (20),PRIMARY
KEY(version_id));
-CREATE TABLE jahia_sl2_version_preds(version_id BIGINT NOT
NULL,predecessor_id BIGINT NOT NULL,PRIMARY KEY(version_id,predecessor_id));
-CREATE TABLE jahia_sl2_version_labels(version_id BIGINT NOT NULL,label_id
BIGINT NOT NULL,PRIMARY KEY(version_id,label_id));
-CREATE TABLE jahia_sl2_properties(version_id BIGINT NOT
NULL,property_namespace VARCHAR (50) NOT NULL,property_name VARCHAR (50) NOT
NULL,property_value VARCHAR (255) NOT NULL,property_type VARCHAR (50) NOT
NULL,is_protected INTEGER NOT NULL,PRIMARY
KEY(version_id,property_namespace,property_name));
-CREATE TABLE jahia_sl2_permissions(object_id BIGINT NOT NULL,subject_id
BIGINT NOT NULL,action_id BIGINT NOT NULL,version_no VARCHAR (20) NOT
NULL,is_inheritable INTEGER NOT NULL,is_negative INTEGER NOT NULL,succession
INTEGER NOT NULL,PRIMARY KEY(object_id,subject_id,action_id));
+CREATE TABLE jahia_sl2_uri(uri_id BIGINT NOT NULL,uri_string VARCHAR (255)
NOT NULL,namespace INTEGER,PRIMARY KEY(uri_id),INDEX jahia_sl2_uri_index
(uri_string, namespace)) ENGINE=InnoDB;
+CREATE TABLE jahia_sl2_object(uri_id BIGINT NOT NULL,class_name VARCHAR
(255) NOT NULL,PRIMARY KEY(uri_id)) ENGINE=InnoDB;
+CREATE TABLE jahia_sl2_binding(uri_id BIGINT NOT NULL,name VARCHAR (255) NOT
NULL,child_uuri_id BIGINT NOT NULL,PRIMARY KEY(uri_id,name,child_uuri_id))
ENGINE=InnoDB;
+CREATE TABLE jahia_sl2_parent_binding(uri_id BIGINT NOT NULL,name VARCHAR
(255) NOT NULL,parent_uuri_id BIGINT NOT NULL,PRIMARY
KEY(uri_id,name,parent_uuri_id)) ENGINE=InnoDB;
+CREATE TABLE jahia_sl2_links(uri_id BIGINT NOT NULL,link_to_id BIGINT NOT
NULL,PRIMARY KEY(uri_id,link_to_id)) ENGINE=InnoDB;
+CREATE TABLE jahia_sl2_locks(lock_id BIGINT NOT NULL,object_id BIGINT NOT
NULL,subject_id BIGINT NOT NULL,type_id BIGINT NOT NULL,expiration_date VARCHAR
(25) NOT NULL,is_inheritable INTEGER NOT NULL,is_exclusive INTEGER NOT
NULL,owner VARCHAR (255),PRIMARY KEY(lock_id)) ENGINE=InnoDB;
+CREATE TABLE jahia_sl2_branch(branch_id BIGINT NOT NULL,branch_string
VARCHAR (255),namespace INTEGER,PRIMARY KEY(branch_id)) ENGINE=InnoDB;
+CREATE TABLE jahia_sl2_label(label_id BIGINT NOT NULL,label_string VARCHAR
(255),namespace INTEGER,PRIMARY KEY(label_id)) ENGINE=InnoDB;
+CREATE TABLE jahia_sl2_version(uri_id BIGINT NOT NULL,is_versioned
INTEGER,PRIMARY KEY(uri_id)) ENGINE=InnoDB;
+CREATE TABLE jahia_sl2_version_history(version_id BIGINT NOT NULL,uri_id
BIGINT NOT NULL,branch_id BIGINT NOT NULL,revision_no VARCHAR (20),PRIMARY
KEY(version_id)) ENGINE=InnoDB;
+CREATE TABLE jahia_sl2_version_preds(version_id BIGINT NOT
NULL,predecessor_id BIGINT NOT NULL,PRIMARY KEY(version_id,predecessor_id))
ENGINE=InnoDB;
+CREATE TABLE jahia_sl2_version_labels(version_id BIGINT NOT NULL,label_id
BIGINT NOT NULL,PRIMARY KEY(version_id,label_id)) ENGINE=InnoDB;
+CREATE TABLE jahia_sl2_properties(version_id BIGINT NOT
NULL,property_namespace VARCHAR (50) NOT NULL,property_name VARCHAR (50) NOT
NULL,property_value VARCHAR (255) NOT NULL,property_type VARCHAR (50) NOT
NULL,is_protected INTEGER NOT NULL,PRIMARY
KEY(version_id,property_namespace,property_name)) ENGINE=InnoDB;
+CREATE TABLE jahia_sl2_permissions(object_id BIGINT NOT NULL,subject_id
BIGINT NOT NULL,action_id BIGINT NOT NULL,version_no VARCHAR (20) NOT
NULL,is_inheritable INTEGER NOT NULL,is_negative INTEGER NOT NULL,succession
INTEGER NOT NULL,PRIMARY KEY(object_id,subject_id,action_id)) ENGINE=InnoDB;
