tdraier 2005/04/18 12:48:42 CEST
Modified files:
core/src/webapp/WEB-INF/var/db/sql/schema/mssql
jahia-schema.sql
core/src/webapp/WEB-INF/var/db/sql/schema/mysql
jahia-schema.sql
core/src/webapp/WEB-INF/var/db/sql/schema/oracle
jahia-schema.sql
core/src/webapp/WEB-INF/var/db/sql/schema/postgresql
jahia-schema.sql
core/src/webapp/WEB-INF/var/db
default_corporate_portal_templates.values
default_corporate_portal_templates_zh.values
Log:
db updates for new slide tables
Revision Changes Path
1.3 +115 -0
jahia/core/src/webapp/WEB-INF/var/db/default_corporate_portal_templates.values
http://jahia.mine.nu:8080/cgi-bin/cvsweb.cgi/jahia/core/src/webapp/WEB-INF/var/db/default_corporate_portal_templates.values.diff?r1=1.2&r2=1.3&f=h
1.2 +115 -0
jahia/core/src/webapp/WEB-INF/var/db/default_corporate_portal_templates_zh.values
http://jahia.mine.nu:8080/cgi-bin/cvsweb.cgi/jahia/core/src/webapp/WEB-INF/var/db/default_corporate_portal_templates_zh.values.diff?r1=1.1&r2=1.2&f=h
1.4 +1 -1
jahia/core/src/webapp/WEB-INF/var/db/sql/schema/mssql/jahia-schema.sql
http://jahia.mine.nu:8080/cgi-bin/cvsweb.cgi/jahia/core/src/webapp/WEB-INF/var/db/sql/schema/mssql/jahia-schema.sql.diff?r1=1.3&r2=1.4&f=h
1.5 +1 -1
jahia/core/src/webapp/WEB-INF/var/db/sql/schema/mysql/jahia-schema.sql
http://jahia.mine.nu:8080/cgi-bin/cvsweb.cgi/jahia/core/src/webapp/WEB-INF/var/db/sql/schema/mysql/jahia-schema.sql.diff?r1=1.4&r2=1.5&f=h
1.4 +1 -1
jahia/core/src/webapp/WEB-INF/var/db/sql/schema/oracle/jahia-schema.sql
http://jahia.mine.nu:8080/cgi-bin/cvsweb.cgi/jahia/core/src/webapp/WEB-INF/var/db/sql/schema/oracle/jahia-schema.sql.diff?r1=1.3&r2=1.4&f=h
1.4 +1 -1
jahia/core/src/webapp/WEB-INF/var/db/sql/schema/postgresql/jahia-schema.sql
http://jahia.mine.nu:8080/cgi-bin/cvsweb.cgi/jahia/core/src/webapp/WEB-INF/var/db/sql/schema/postgresql/jahia-schema.sql.diff?r1=1.3&r2=1.4&f=h
Index: jahia-schema.sql
===================================================================
RCS file:
/home/cvs/repository/jahia/core/src/webapp/WEB-INF/var/db/sql/schema/mssql/jahia-schema.sql,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -r1.3 -r1.4
--- jahia-schema.sql 12 Apr 2005 12:36:40 -0000 1.3
+++ jahia-schema.sql 18 Apr 2005 10:48:40 -0000 1.4
@@ -2994,7 +2994,7 @@
object_id BIGINT NOT NULL,
subject_id BIGINT NOT NULL,
action_id BIGINT NOT NULL,
- version_no VARCHAR (20) NOT NULL,
+ version_no VARCHAR (20),
is_inheritable INT NOT NULL,
is_negative INT NOT NULL,
succession INT NOT NULL,
Index: jahia-schema.sql
===================================================================
RCS file:
/home/cvs/repository/jahia/core/src/webapp/WEB-INF/var/db/sql/schema/mysql/jahia-schema.sql,v
retrieving revision 1.4
retrieving revision 1.5
diff -u -r1.4 -r1.5
--- jahia-schema.sql 12 Apr 2005 12:36:41 -0000 1.4
+++ jahia-schema.sql 18 Apr 2005 10:48:41 -0000 1.5
@@ -1026,7 +1026,7 @@
object_id BIGINT NOT NULL,
subject_id BIGINT NOT NULL,
action_id BIGINT NOT NULL,
- version_no VARCHAR (20) NOT NULL,
+ version_no VARCHAR (20),
is_inheritable INTEGER NOT NULL,
is_negative INTEGER NOT NULL,
succession INTEGER NOT NULL,
Index: jahia-schema.sql
===================================================================
RCS file:
/home/cvs/repository/jahia/core/src/webapp/WEB-INF/var/db/sql/schema/oracle/jahia-schema.sql,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -r1.3 -r1.4
--- jahia-schema.sql 12 Apr 2005 12:36:41 -0000 1.3
+++ jahia-schema.sql 18 Apr 2005 10:48:41 -0000 1.4
@@ -1355,7 +1355,7 @@
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) NOT NULL,
+ version_no VARCHAR2 (20),
is_inheritable NUMBER NOT NULL,
is_negative NUMBER NOT NULL,
succession NUMBER NOT NULL
Index: jahia-schema.sql
===================================================================
RCS file:
/home/cvs/repository/jahia/core/src/webapp/WEB-INF/var/db/sql/schema/postgresql/jahia-schema.sql,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -r1.3 -r1.4
--- jahia-schema.sql 12 Apr 2005 12:36:41 -0000 1.3
+++ jahia-schema.sql 18 Apr 2005 10:48:42 -0000 1.4
@@ -1161,7 +1161,7 @@
object_id int8 NOT NULL,
subject_id int8 NOT NULL,
action_id int8 NOT NULL,
- version_no varchar (20) NOT NULL,
+ version_no varchar (20),
is_inheritable integer NOT NULL,
is_negative integer NOT NULL,
succession integer NOT NULL,
Index: default_corporate_portal_templates.values
===================================================================
RCS file:
/home/cvs/repository/jahia/core/src/webapp/WEB-INF/var/db/default_corporate_portal_templates.values,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -r1.2 -r1.3
--- default_corporate_portal_templates.values 17 Sep 2004 10:14:53 -0000
1.2
+++ default_corporate_portal_templates.values 18 Apr 2005 10:48:42 -0000
1.3
@@ -65,6 +65,9 @@
INSERT INTO jahia_acl_entries (id_jahia_acl, type_jahia_acl_entries,
target_jahia_acl_entries, entry_state_jahia_acl_entries,
entry_trist_jahia_acl_entries) VALUES (38,2,'guest:1',1,0);
INSERT INTO jahia_app_def (id_jahia_app_def, jahiaid_jahia_app_def,
name_jahia_app_def, context_jahia_app_def, visible_jahia_app_def,
shared_jahia_app_def, rights_jahia_app_def, filename_jahia_app_def,
desc_jahia_app_def, type_jahia_app_def) VALUES
(27,1,'InfoNews','/InfoNews_myjahiasite',1,0,54,'InfoNews.war','', 'servlet');
INSERT INTO jahia_audit_log (id_jahia_audit_log, time_jahia_audit_log,
username_jahia_audit_log, objecttype_jahia_audit_log, objectid_jahia_audit_log,
parenttype_jahia_audit_log, parentid_jahia_audit_log,
operation_jahia_audit_log, site_jahia_audit_log, content_jahia_audit_log)
VALUES (107,'001052504320062','siteadmin',7,0,0,0,'flushed all logs','','');
+INSERT INTO JAHIA_AUTOIDS (jahia_autoids_tablename,
jahia_autoids_currentindex) VALUES ('JAHIA_SL2_BRANCH',5)
+INSERT INTO JAHIA_AUTOIDS (jahia_autoids_tablename,
jahia_autoids_currentindex) VALUES ('JAHIA_SL2_URI',13)
+INSERT INTO JAHIA_AUTOIDS (jahia_autoids_tablename,
jahia_autoids_currentindex) VALUES ('JAHIA_SL2_VERSION_HISTORY',5)
INSERT INTO jahia_autoids (jahia_autoids_tablename,
jahia_autoids_currentindex) VALUES ('jahia_users',3);
INSERT INTO jahia_autoids (jahia_autoids_tablename,
jahia_autoids_currentindex) VALUES ('jahia_grps',4);
INSERT INTO jahia_autoids (jahia_autoids_tablename,
jahia_autoids_currentindex) VALUES ('jahia_sites',1);
@@ -514,3 +517,115 @@
INSERT INTO jahia_user_prop (id_jahia_users, name_jahia_user_prop,
value_jahia_user_prop, provider_jahia_user_prop, userkey_jahia_user_prop)
VALUES (3,'firstname','','jahia','siteadmin:1');
INSERT INTO jahia_users (id_jahia_users, name_jahia_users,
password_jahia_users, key_jahia_users, siteid_jahia_users) VALUES
(2,'guest','NWdeaPS1r3uZXZIFrQ/EOELxZFA=','guest:1',1);
INSERT INTO jahia_users (id_jahia_users, name_jahia_users,
password_jahia_users, key_jahia_users, siteid_jahia_users) VALUES
(3,'siteadmin','500j4dyBpJQDk8Ipc3Y89925Xwg=','siteadmin:1',1);
+INSERT INTO JAHIA_SL2_URI VALUES(1,'/',1)
+INSERT INTO JAHIA_SL2_URI VALUES(2,'/actions',1)
+INSERT INTO JAHIA_SL2_URI VALUES(3,'/actions/manage',1)
+INSERT INTO JAHIA_SL2_URI VALUES(4,'/actions/read',1)
+INSERT INTO JAHIA_SL2_URI VALUES(5,'/actions/write',1)
+INSERT INTO JAHIA_SL2_URI VALUES(6,'/shared',1)
+INSERT INTO JAHIA_SL2_URI VALUES(7,'/shared/import',1)
+INSERT INTO JAHIA_SL2_URI VALUES(8,'/shared/import/Home',1)
+INSERT INTO JAHIA_SL2_URI VALUES(9,'/shared/import/Home/banner_home.gif',1)
+INSERT INTO JAHIA_SL2_URI VALUES(10,'/shared/import/Home/portal.gif',1)
+INSERT INTO JAHIA_SL2_URI VALUES(11,'nobody',1)
+INSERT INTO JAHIA_SL2_URI VALUES(12,'user',1)
+INSERT INTO JAHIA_SL2_OBJECT
VALUES(1,'org.apache.slide.structure.SubjectNode')
+INSERT INTO JAHIA_SL2_OBJECT
VALUES(2,'org.apache.slide.structure.ActionNode')
+INSERT INTO JAHIA_SL2_OBJECT
VALUES(3,'org.apache.slide.structure.ActionNode')
+INSERT INTO JAHIA_SL2_OBJECT
VALUES(4,'org.apache.slide.structure.ActionNode')
+INSERT INTO JAHIA_SL2_OBJECT
VALUES(5,'org.apache.slide.structure.ActionNode')
+INSERT INTO JAHIA_SL2_OBJECT
VALUES(6,'org.apache.slide.structure.SubjectNode')
+INSERT INTO JAHIA_SL2_OBJECT
VALUES(7,'org.apache.slide.structure.SubjectNode')
+INSERT INTO JAHIA_SL2_OBJECT
VALUES(8,'org.apache.slide.structure.SubjectNode')
+INSERT INTO JAHIA_SL2_OBJECT
VALUES(9,'org.apache.slide.structure.SubjectNode')
+INSERT INTO JAHIA_SL2_OBJECT
VALUES(10,'org.apache.slide.structure.SubjectNode')
+INSERT INTO JAHIA_SL2_BINDING VALUES(1,'actions',2)
+INSERT INTO JAHIA_SL2_BINDING VALUES(1,'shared',6)
+INSERT INTO JAHIA_SL2_BINDING VALUES(2,'manage',3)
+INSERT INTO JAHIA_SL2_BINDING VALUES(2,'read',4)
+INSERT INTO JAHIA_SL2_BINDING VALUES(2,'write',5)
+INSERT INTO JAHIA_SL2_BINDING VALUES(6,'import',7)
+INSERT INTO JAHIA_SL2_BINDING VALUES(7,'Home',8)
+INSERT INTO JAHIA_SL2_BINDING VALUES(8,'banner_home.gif',9)
+INSERT INTO JAHIA_SL2_BINDING VALUES(8,'portal.gif',10)
+INSERT INTO JAHIA_SL2_PARENT_BINDING VALUES(2,'actions',1)
+INSERT INTO JAHIA_SL2_PARENT_BINDING VALUES(3,'manage',2)
+INSERT INTO JAHIA_SL2_PARENT_BINDING VALUES(4,'read',2)
+INSERT INTO JAHIA_SL2_PARENT_BINDING VALUES(5,'write',2)
+INSERT INTO JAHIA_SL2_PARENT_BINDING VALUES(6,'shared',1)
+INSERT INTO JAHIA_SL2_PARENT_BINDING VALUES(7,'import',6)
+INSERT INTO JAHIA_SL2_PARENT_BINDING VALUES(8,'Home',7)
+INSERT INTO JAHIA_SL2_PARENT_BINDING VALUES(9,'banner_home.gif',8)
+INSERT INTO JAHIA_SL2_PARENT_BINDING VALUES(10,'portal.gif',8)
+INSERT INTO JAHIA_SL2_BRANCH VALUES(1,'main',1)
+INSERT INTO JAHIA_SL2_BRANCH VALUES(2,'main',1)
+INSERT INTO JAHIA_SL2_BRANCH VALUES(3,'main',1)
+INSERT INTO JAHIA_SL2_BRANCH VALUES(4,'main',1)
+INSERT INTO JAHIA_SL2_VERSION VALUES(7,0)
+INSERT INTO JAHIA_SL2_VERSION VALUES(8,0)
+INSERT INTO JAHIA_SL2_VERSION VALUES(9,0)
+INSERT INTO JAHIA_SL2_VERSION VALUES(10,0)
+INSERT INTO JAHIA_SL2_VERSION_HISTORY VALUES(1,7,1,'1.0')
+INSERT INTO JAHIA_SL2_VERSION_HISTORY VALUES(2,8,2,'1.0')
+INSERT INTO JAHIA_SL2_VERSION_HISTORY VALUES(3,10,3,'1.0')
+INSERT INTO JAHIA_SL2_VERSION_HISTORY VALUES(4,9,4,'1.0')
+INSERT INTO JAHIA_SL2_PROPERTIES
VALUES(1,'DAV:','creationdate','2003-10-23T10:25:37Z','',1)
+INSERT INTO JAHIA_SL2_PROPERTIES VALUES(1,'DAV:','displayname','import','',1)
+INSERT INTO JAHIA_SL2_PROPERTIES VALUES(1,'DAV:','getcontentlength','0','',1)
+INSERT INTO JAHIA_SL2_PROPERTIES VALUES(1,'DAV:','getlastmodified','Thu, 23
Oct 2003 10:25:37 GMT','',1)
+INSERT INTO JAHIA_SL2_PROPERTIES VALUES(1,'DAV:','owner','siteadmin','',1)
+INSERT INTO JAHIA_SL2_PROPERTIES
VALUES(1,'DAV:','resourcetype','<collection/>','',1)
+INSERT INTO JAHIA_SL2_PROPERTIES VALUES(1,'DAV:','source','','',1)
+INSERT INTO JAHIA_SL2_PROPERTIES
VALUES(2,'DAV:','creationdate','2003-10-23T10:25:37Z','',1)
+INSERT INTO JAHIA_SL2_PROPERTIES VALUES(2,'DAV:','displayname','Home','',1)
+INSERT INTO JAHIA_SL2_PROPERTIES VALUES(2,'DAV:','getcontentlength','0','',1)
+INSERT INTO JAHIA_SL2_PROPERTIES VALUES(2,'DAV:','getlastmodified','Thu, 23
Oct 2003 10:25:37 GMT','',1)
+INSERT INTO JAHIA_SL2_PROPERTIES VALUES(2,'DAV:','owner','siteadmin','',1)
+INSERT INTO JAHIA_SL2_PROPERTIES
VALUES(2,'DAV:','resourcetype','<collection/>','',1)
+INSERT INTO JAHIA_SL2_PROPERTIES VALUES(2,'DAV:','source','','',1)
+INSERT INTO JAHIA_SL2_PROPERTIES
VALUES(3,'DAV:','creationdate','2003-10-23T10:25:37Z','',1)
+INSERT INTO JAHIA_SL2_PROPERTIES VALUES(3,'DAV:','displayname','Portal','',1)
+INSERT INTO JAHIA_SL2_PROPERTIES
VALUES(3,'DAV:','getcontentlanguage','en','',1)
+INSERT INTO JAHIA_SL2_PROPERTIES
VALUES(3,'DAV:','getcontentlength','22021','',1)
+INSERT INTO JAHIA_SL2_PROPERTIES
VALUES(3,'DAV:','getcontenttype','image/gif','',1)
+INSERT INTO JAHIA_SL2_PROPERTIES
VALUES(3,'DAV:','getetag','64432899_48563_22021','',1)
+INSERT INTO JAHIA_SL2_PROPERTIES VALUES(3,'DAV:','getlastmodified','Thu, 23
Oct 2003 10:25:37 GMT','',1)
+INSERT INTO JAHIA_SL2_PROPERTIES VALUES(3,'DAV:','owner','','',1)
+INSERT INTO JAHIA_SL2_PROPERTIES VALUES(3,'DAV:','resourcetype','','',1)
+INSERT INTO JAHIA_SL2_PROPERTIES VALUES(3,'DAV:','source','','',1)
+INSERT INTO JAHIA_SL2_PROPERTIES
VALUES(3,'http://www.jahia.org/','description','','',0)
+INSERT INTO JAHIA_SL2_PROPERTIES
VALUES(4,'DAV:','creationdate','2003-10-23T10:25:37Z','',1)
+INSERT INTO JAHIA_SL2_PROPERTIES VALUES(4,'DAV:','displayname','Banner','',1)
+INSERT INTO JAHIA_SL2_PROPERTIES
VALUES(4,'DAV:','getcontentlanguage','en','',1)
+INSERT INTO JAHIA_SL2_PROPERTIES
VALUES(4,'DAV:','getcontentlength','41166','',1)
+INSERT INTO JAHIA_SL2_PROPERTIES
VALUES(4,'DAV:','getcontenttype','image/gif','',1)
+INSERT INTO JAHIA_SL2_PROPERTIES
VALUES(4,'DAV:','getetag','687233735_48563_41166','',1)
+INSERT INTO JAHIA_SL2_PROPERTIES VALUES(4,'DAV:','getlastmodified','Thu, 23
Oct 2003 10:25:37 GMT','',1)
+INSERT INTO JAHIA_SL2_PROPERTIES VALUES(4,'DAV:','owner','','',1)
+INSERT INTO JAHIA_SL2_PROPERTIES VALUES(4,'DAV:','resourcetype','','',1)
+INSERT INTO JAHIA_SL2_PROPERTIES VALUES(4,'DAV:','source','','',1)
+INSERT INTO JAHIA_SL2_PROPERTIES
VALUES(4,'http://www.jahia.org/','description','','',0)
+INSERT INTO JAHIA_SL2_PERMISSIONS VALUES(1,11,3,NULL,1,1,3)
+INSERT INTO JAHIA_SL2_PERMISSIONS VALUES(1,11,4,NULL,1,0,2)
+INSERT INTO JAHIA_SL2_PERMISSIONS VALUES(1,11,5,NULL,1,1,1)
+INSERT INTO JAHIA_SL2_PERMISSIONS VALUES(2,11,3,NULL,1,1,3)
+INSERT INTO JAHIA_SL2_PERMISSIONS VALUES(2,11,4,NULL,1,1,2)
+INSERT INTO JAHIA_SL2_PERMISSIONS VALUES(2,11,5,NULL,1,1,1)
+INSERT INTO JAHIA_SL2_PERMISSIONS VALUES(6,11,3,NULL,1,1,6)
+INSERT INTO JAHIA_SL2_PERMISSIONS VALUES(6,11,4,NULL,1,0,5)
+INSERT INTO JAHIA_SL2_PERMISSIONS VALUES(6,11,5,NULL,1,1,1)
+INSERT INTO JAHIA_SL2_PERMISSIONS VALUES(6,12,3,NULL,1,1,2)
+INSERT INTO JAHIA_SL2_PERMISSIONS VALUES(6,12,4,NULL,1,0,4)
+INSERT INTO JAHIA_SL2_PERMISSIONS VALUES(6,12,5,NULL,1,0,3)
+INSERT INTO JAHIA_SL2_PERMISSIONS VALUES(9,11,3,NULL,1,1,1)
+INSERT INTO JAHIA_SL2_PERMISSIONS VALUES(9,11,4,NULL,1,0,2)
+INSERT INTO JAHIA_SL2_PERMISSIONS VALUES(9,11,5,NULL,1,1,3)
+INSERT INTO JAHIA_SL2_PERMISSIONS VALUES(9,12,3,NULL,1,1,4)
+INSERT INTO JAHIA_SL2_PERMISSIONS VALUES(9,12,4,NULL,1,1,5)
+INSERT INTO JAHIA_SL2_PERMISSIONS VALUES(9,12,5,NULL,1,1,6)
+INSERT INTO JAHIA_SL2_PERMISSIONS VALUES(10,11,3,NULL,1,1,1)
+INSERT INTO JAHIA_SL2_PERMISSIONS VALUES(10,11,4,NULL,1,1,3)
+INSERT INTO JAHIA_SL2_PERMISSIONS VALUES(10,11,5,NULL,1,1,2)
+INSERT INTO JAHIA_SL2_PERMISSIONS VALUES(10,12,3,NULL,1,1,4)
+INSERT INTO JAHIA_SL2_PERMISSIONS VALUES(10,12,4,NULL,1,1,6)
+INSERT INTO JAHIA_SL2_PERMISSIONS VALUES(10,12,5,NULL,1,1,5)
Index: default_corporate_portal_templates_zh.values
===================================================================
RCS file:
/home/cvs/repository/jahia/core/src/webapp/WEB-INF/var/db/default_corporate_portal_templates_zh.values,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -r1.1 -r1.2
--- default_corporate_portal_templates_zh.values 30 Mar 2004 14:13:18
-0000 1.1
+++ default_corporate_portal_templates_zh.values 18 Apr 2005 10:48:42
-0000 1.2
@@ -45,6 +45,9 @@
INSERT INTO jahia_acl_entries (id_jahia_acl, type_jahia_acl_entries,
target_jahia_acl_entries, entry_state_jahia_acl_entries,
entry_trist_jahia_acl_entries) VALUES (22, 2, 'guest:1', 1, 0);
INSERT INTO jahia_app_def (id_jahia_app_def, jahiaid_jahia_app_def,
name_jahia_app_def, context_jahia_app_def, visible_jahia_app_def,
shared_jahia_app_def, rights_jahia_app_def, filename_jahia_app_def,
desc_jahia_app_def, type_jahia_app_def) VALUES
(14,1,'InfoNews','/InfoNews_myjahiasite',1,0,1,'InfoNews.war','', 'servlet');
INSERT INTO jahia_audit_log (id_jahia_audit_log, time_jahia_audit_log,
username_jahia_audit_log, objecttype_jahia_audit_log, objectid_jahia_audit_log,
parenttype_jahia_audit_log, parentid_jahia_audit_log,
operation_jahia_audit_log, site_jahia_audit_log, content_jahia_audit_log)
VALUES (107,'001052504320062','siteadmin',7,0,0,0,'flushed all logs','','');
+INSERT INTO JAHIA_AUTOIDS (jahia_autoids_tablename,
jahia_autoids_currentindex) VALUES ('JAHIA_SL2_BRANCH',5)
+INSERT INTO JAHIA_AUTOIDS (jahia_autoids_tablename,
jahia_autoids_currentindex) VALUES ('JAHIA_SL2_URI',13)
+INSERT INTO JAHIA_AUTOIDS (jahia_autoids_tablename,
jahia_autoids_currentindex) VALUES ('JAHIA_SL2_VERSION_HISTORY',5)
INSERT INTO jahia_autoids (jahia_autoids_tablename,
jahia_autoids_currentindex) VALUES ('jahia_users',3);
INSERT INTO jahia_autoids (jahia_autoids_tablename,
jahia_autoids_currentindex) VALUES ('jahia_grps',4);
INSERT INTO jahia_autoids (jahia_autoids_tablename,
jahia_autoids_currentindex) VALUES ('jahia_sites',1);
@@ -449,3 +452,115 @@
INSERT INTO jahia_user_prop (id_jahia_users, name_jahia_user_prop,
value_jahia_user_prop) VALUES (3,'firstname','');
INSERT INTO jahia_users (id_jahia_users, name_jahia_users,
password_jahia_users, key_jahia_users, siteid_jahia_users) VALUES
(2,'guest','NWdeaPS1r3uZXZIFrQ/EOELxZFA=','guest:1',1);
INSERT INTO jahia_users (id_jahia_users, name_jahia_users,
password_jahia_users, key_jahia_users, siteid_jahia_users) VALUES
(3,'siteadmin','500j4dyBpJQDk8Ipc3Y89925Xwg=','siteadmin:1',1);
+INSERT INTO JAHIA_SL2_URI VALUES(1,'/',1)
+INSERT INTO JAHIA_SL2_URI VALUES(2,'/actions',1)
+INSERT INTO JAHIA_SL2_URI VALUES(3,'/actions/manage',1)
+INSERT INTO JAHIA_SL2_URI VALUES(4,'/actions/read',1)
+INSERT INTO JAHIA_SL2_URI VALUES(5,'/actions/write',1)
+INSERT INTO JAHIA_SL2_URI VALUES(6,'/shared',1)
+INSERT INTO JAHIA_SL2_URI VALUES(7,'/shared/import',1)
+INSERT INTO JAHIA_SL2_URI VALUES(8,'/shared/import/Home',1)
+INSERT INTO JAHIA_SL2_URI VALUES(9,'/shared/import/Home/banner_home.gif',1)
+INSERT INTO JAHIA_SL2_URI VALUES(10,'/shared/import/Home/portal.gif',1)
+INSERT INTO JAHIA_SL2_URI VALUES(11,'nobody',1)
+INSERT INTO JAHIA_SL2_URI VALUES(12,'user',1)
+INSERT INTO JAHIA_SL2_OBJECT
VALUES(1,'org.apache.slide.structure.SubjectNode')
+INSERT INTO JAHIA_SL2_OBJECT
VALUES(2,'org.apache.slide.structure.ActionNode')
+INSERT INTO JAHIA_SL2_OBJECT
VALUES(3,'org.apache.slide.structure.ActionNode')
+INSERT INTO JAHIA_SL2_OBJECT
VALUES(4,'org.apache.slide.structure.ActionNode')
+INSERT INTO JAHIA_SL2_OBJECT
VALUES(5,'org.apache.slide.structure.ActionNode')
+INSERT INTO JAHIA_SL2_OBJECT
VALUES(6,'org.apache.slide.structure.SubjectNode')
+INSERT INTO JAHIA_SL2_OBJECT
VALUES(7,'org.apache.slide.structure.SubjectNode')
+INSERT INTO JAHIA_SL2_OBJECT
VALUES(8,'org.apache.slide.structure.SubjectNode')
+INSERT INTO JAHIA_SL2_OBJECT
VALUES(9,'org.apache.slide.structure.SubjectNode')
+INSERT INTO JAHIA_SL2_OBJECT
VALUES(10,'org.apache.slide.structure.SubjectNode')
+INSERT INTO JAHIA_SL2_BINDING VALUES(1,'actions',2)
+INSERT INTO JAHIA_SL2_BINDING VALUES(1,'shared',6)
+INSERT INTO JAHIA_SL2_BINDING VALUES(2,'manage',3)
+INSERT INTO JAHIA_SL2_BINDING VALUES(2,'read',4)
+INSERT INTO JAHIA_SL2_BINDING VALUES(2,'write',5)
+INSERT INTO JAHIA_SL2_BINDING VALUES(6,'import',7)
+INSERT INTO JAHIA_SL2_BINDING VALUES(7,'Home',8)
+INSERT INTO JAHIA_SL2_BINDING VALUES(8,'banner_home.gif',9)
+INSERT INTO JAHIA_SL2_BINDING VALUES(8,'portal.gif',10)
+INSERT INTO JAHIA_SL2_PARENT_BINDING VALUES(2,'actions',1)
+INSERT INTO JAHIA_SL2_PARENT_BINDING VALUES(3,'manage',2)
+INSERT INTO JAHIA_SL2_PARENT_BINDING VALUES(4,'read',2)
+INSERT INTO JAHIA_SL2_PARENT_BINDING VALUES(5,'write',2)
+INSERT INTO JAHIA_SL2_PARENT_BINDING VALUES(6,'shared',1)
+INSERT INTO JAHIA_SL2_PARENT_BINDING VALUES(7,'import',6)
+INSERT INTO JAHIA_SL2_PARENT_BINDING VALUES(8,'Home',7)
+INSERT INTO JAHIA_SL2_PARENT_BINDING VALUES(9,'banner_home.gif',8)
+INSERT INTO JAHIA_SL2_PARENT_BINDING VALUES(10,'portal.gif',8)
+INSERT INTO JAHIA_SL2_BRANCH VALUES(1,'main',1)
+INSERT INTO JAHIA_SL2_BRANCH VALUES(2,'main',1)
+INSERT INTO JAHIA_SL2_BRANCH VALUES(3,'main',1)
+INSERT INTO JAHIA_SL2_BRANCH VALUES(4,'main',1)
+INSERT INTO JAHIA_SL2_VERSION VALUES(7,0)
+INSERT INTO JAHIA_SL2_VERSION VALUES(8,0)
+INSERT INTO JAHIA_SL2_VERSION VALUES(9,0)
+INSERT INTO JAHIA_SL2_VERSION VALUES(10,0)
+INSERT INTO JAHIA_SL2_VERSION_HISTORY VALUES(1,7,1,'1.0')
+INSERT INTO JAHIA_SL2_VERSION_HISTORY VALUES(2,8,2,'1.0')
+INSERT INTO JAHIA_SL2_VERSION_HISTORY VALUES(3,10,3,'1.0')
+INSERT INTO JAHIA_SL2_VERSION_HISTORY VALUES(4,9,4,'1.0')
+INSERT INTO JAHIA_SL2_PROPERTIES
VALUES(1,'DAV:','creationdate','2003-10-23T10:25:37Z','',1)
+INSERT INTO JAHIA_SL2_PROPERTIES VALUES(1,'DAV:','displayname','import','',1)
+INSERT INTO JAHIA_SL2_PROPERTIES VALUES(1,'DAV:','getcontentlength','0','',1)
+INSERT INTO JAHIA_SL2_PROPERTIES VALUES(1,'DAV:','getlastmodified','Thu, 23
Oct 2003 10:25:37 GMT','',1)
+INSERT INTO JAHIA_SL2_PROPERTIES VALUES(1,'DAV:','owner','siteadmin','',1)
+INSERT INTO JAHIA_SL2_PROPERTIES
VALUES(1,'DAV:','resourcetype','<collection/>','',1)
+INSERT INTO JAHIA_SL2_PROPERTIES VALUES(1,'DAV:','source','','',1)
+INSERT INTO JAHIA_SL2_PROPERTIES
VALUES(2,'DAV:','creationdate','2003-10-23T10:25:37Z','',1)
+INSERT INTO JAHIA_SL2_PROPERTIES VALUES(2,'DAV:','displayname','Home','',1)
+INSERT INTO JAHIA_SL2_PROPERTIES VALUES(2,'DAV:','getcontentlength','0','',1)
+INSERT INTO JAHIA_SL2_PROPERTIES VALUES(2,'DAV:','getlastmodified','Thu, 23
Oct 2003 10:25:37 GMT','',1)
+INSERT INTO JAHIA_SL2_PROPERTIES VALUES(2,'DAV:','owner','siteadmin','',1)
+INSERT INTO JAHIA_SL2_PROPERTIES
VALUES(2,'DAV:','resourcetype','<collection/>','',1)
+INSERT INTO JAHIA_SL2_PROPERTIES VALUES(2,'DAV:','source','','',1)
+INSERT INTO JAHIA_SL2_PROPERTIES
VALUES(3,'DAV:','creationdate','2003-10-23T10:25:37Z','',1)
+INSERT INTO JAHIA_SL2_PROPERTIES VALUES(3,'DAV:','displayname','Portal','',1)
+INSERT INTO JAHIA_SL2_PROPERTIES
VALUES(3,'DAV:','getcontentlanguage','en','',1)
+INSERT INTO JAHIA_SL2_PROPERTIES
VALUES(3,'DAV:','getcontentlength','22021','',1)
+INSERT INTO JAHIA_SL2_PROPERTIES
VALUES(3,'DAV:','getcontenttype','image/gif','',1)
+INSERT INTO JAHIA_SL2_PROPERTIES
VALUES(3,'DAV:','getetag','64432899_48563_22021','',1)
+INSERT INTO JAHIA_SL2_PROPERTIES VALUES(3,'DAV:','getlastmodified','Thu, 23
Oct 2003 10:25:37 GMT','',1)
+INSERT INTO JAHIA_SL2_PROPERTIES VALUES(3,'DAV:','owner','','',1)
+INSERT INTO JAHIA_SL2_PROPERTIES VALUES(3,'DAV:','resourcetype','','',1)
+INSERT INTO JAHIA_SL2_PROPERTIES VALUES(3,'DAV:','source','','',1)
+INSERT INTO JAHIA_SL2_PROPERTIES
VALUES(3,'http://www.jahia.org/','description','','',0)
+INSERT INTO JAHIA_SL2_PROPERTIES
VALUES(4,'DAV:','creationdate','2003-10-23T10:25:37Z','',1)
+INSERT INTO JAHIA_SL2_PROPERTIES VALUES(4,'DAV:','displayname','Banner','',1)
+INSERT INTO JAHIA_SL2_PROPERTIES
VALUES(4,'DAV:','getcontentlanguage','en','',1)
+INSERT INTO JAHIA_SL2_PROPERTIES
VALUES(4,'DAV:','getcontentlength','41166','',1)
+INSERT INTO JAHIA_SL2_PROPERTIES
VALUES(4,'DAV:','getcontenttype','image/gif','',1)
+INSERT INTO JAHIA_SL2_PROPERTIES
VALUES(4,'DAV:','getetag','687233735_48563_41166','',1)
+INSERT INTO JAHIA_SL2_PROPERTIES VALUES(4,'DAV:','getlastmodified','Thu, 23
Oct 2003 10:25:37 GMT','',1)
+INSERT INTO JAHIA_SL2_PROPERTIES VALUES(4,'DAV:','owner','','',1)
+INSERT INTO JAHIA_SL2_PROPERTIES VALUES(4,'DAV:','resourcetype','','',1)
+INSERT INTO JAHIA_SL2_PROPERTIES VALUES(4,'DAV:','source','','',1)
+INSERT INTO JAHIA_SL2_PROPERTIES
VALUES(4,'http://www.jahia.org/','description','','',0)
+INSERT INTO JAHIA_SL2_PERMISSIONS VALUES(1,11,3,NULL,1,1,3)
+INSERT INTO JAHIA_SL2_PERMISSIONS VALUES(1,11,4,NULL,1,0,2)
+INSERT INTO JAHIA_SL2_PERMISSIONS VALUES(1,11,5,NULL,1,1,1)
+INSERT INTO JAHIA_SL2_PERMISSIONS VALUES(2,11,3,NULL,1,1,3)
+INSERT INTO JAHIA_SL2_PERMISSIONS VALUES(2,11,4,NULL,1,1,2)
+INSERT INTO JAHIA_SL2_PERMISSIONS VALUES(2,11,5,NULL,1,1,1)
+INSERT INTO JAHIA_SL2_PERMISSIONS VALUES(6,11,3,NULL,1,1,6)
+INSERT INTO JAHIA_SL2_PERMISSIONS VALUES(6,11,4,NULL,1,0,5)
+INSERT INTO JAHIA_SL2_PERMISSIONS VALUES(6,11,5,NULL,1,1,1)
+INSERT INTO JAHIA_SL2_PERMISSIONS VALUES(6,12,3,NULL,1,1,2)
+INSERT INTO JAHIA_SL2_PERMISSIONS VALUES(6,12,4,NULL,1,0,4)
+INSERT INTO JAHIA_SL2_PERMISSIONS VALUES(6,12,5,NULL,1,0,3)
+INSERT INTO JAHIA_SL2_PERMISSIONS VALUES(9,11,3,NULL,1,1,1)
+INSERT INTO JAHIA_SL2_PERMISSIONS VALUES(9,11,4,NULL,1,0,2)
+INSERT INTO JAHIA_SL2_PERMISSIONS VALUES(9,11,5,NULL,1,1,3)
+INSERT INTO JAHIA_SL2_PERMISSIONS VALUES(9,12,3,NULL,1,1,4)
+INSERT INTO JAHIA_SL2_PERMISSIONS VALUES(9,12,4,NULL,1,1,5)
+INSERT INTO JAHIA_SL2_PERMISSIONS VALUES(9,12,5,NULL,1,1,6)
+INSERT INTO JAHIA_SL2_PERMISSIONS VALUES(10,11,3,NULL,1,1,1)
+INSERT INTO JAHIA_SL2_PERMISSIONS VALUES(10,11,4,NULL,1,1,3)
+INSERT INTO JAHIA_SL2_PERMISSIONS VALUES(10,11,5,NULL,1,1,2)
+INSERT INTO JAHIA_SL2_PERMISSIONS VALUES(10,12,3,NULL,1,1,4)
+INSERT INTO JAHIA_SL2_PERMISSIONS VALUES(10,12,4,NULL,1,1,6)
+INSERT INTO JAHIA_SL2_PERMISSIONS VALUES(10,12,5,NULL,1,1,5)
