Author: xlawrence
Date: Thu Jan 17 12:19:41 2008
New Revision: 19533
URL: https://svndev.jahia.net/websvn/listing.php?sc=3D1&rev=3D19533&repname=
=3Djahia
Log:
updated scripts
Modified:
branches/JAHIA-INCLUDE-TAG-BRANCH/core/src/webapp/WEB-INF/var/db/sql/sc=
hema/hypersonic/jahia-schema.sql
branches/JAHIA-INCLUDE-TAG-BRANCH/core/src/webapp/WEB-INF/var/db/sql/sc=
hema/mssql/jahia-schema.sql
branches/JAHIA-INCLUDE-TAG-BRANCH/core/src/webapp/WEB-INF/var/db/sql/sc=
hema/mysql/jahia-schema.sql
branches/JAHIA-INCLUDE-TAG-BRANCH/core/src/webapp/WEB-INF/var/db/sql/sc=
hema/oracle/jahia-schema.sql
branches/JAHIA-INCLUDE-TAG-BRANCH/core/src/webapp/WEB-INF/var/db/sql/sc=
hema/postgresql/jahia-schema.sql
Modified: branches/JAHIA-INCLUDE-TAG-BRANCH/core/src/webapp/WEB-INF/var/db/=
sql/schema/hypersonic/jahia-schema.sql
URL: https://svndev.jahia.net/websvn/diff.php?path=3D/branches/JAHIA-INCLUD=
E-TAG-BRANCH/core/src/webapp/WEB-INF/var/db/sql/schema/hypersonic/jahia-sch=
ema.sql&rev=3D19533&repname=3Djahia
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D
--- branches/JAHIA-INCLUDE-TAG-BRANCH/core/src/webapp/WEB-INF/var/db/sql/sc=
hema/hypersonic/jahia-schema.sql (original)
+++ branches/JAHIA-INCLUDE-TAG-BRANCH/core/src/webapp/WEB-INF/var/db/sql/sc=
hema/hypersonic/jahia-schema.sql Thu Jan 17 12:19:41 2008
@@ -101,6 +101,7 @@
drop table jahia_pages_def if exists;
drop table jahia_pages_def_prop if exists;
drop table jahia_pages_prop if exists;
+drop table jahia_pages_users_prop if exists;
drop table jahia_pwd_policies if exists;
drop table jahia_pwd_policy_rule_params if exists;
drop table jahia_pwd_policy_rules if exists;
@@ -557,6 +558,15 @@
prop_value varchar(255),
primary key (page_id, prop_name, language_code)
);
+create table jahia_pages_users_prop (
+ page_id integer not null,
+ principal_key varchar(150) not null,
+ principal_type varchar(150) not null,
+ prop_type varchar(150) not null,
+ prop_name varchar(150) not null,
+ prop_value varchar(255),
+ primary key (page_id, principal_key, principal_type, prop_type, prop_n=
ame)
+);
create table jahia_pwd_policies (
jahia_pwd_policy_id integer not null,
name varchar(255) not null,
Modified: branches/JAHIA-INCLUDE-TAG-BRANCH/core/src/webapp/WEB-INF/var/db/=
sql/schema/mssql/jahia-schema.sql
URL: https://svndev.jahia.net/websvn/diff.php?path=3D/branches/JAHIA-INCLUD=
E-TAG-BRANCH/core/src/webapp/WEB-INF/var/db/sql/schema/mssql/jahia-schema.s=
ql&rev=3D19533&repname=3Djahia
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D
--- branches/JAHIA-INCLUDE-TAG-BRANCH/core/src/webapp/WEB-INF/var/db/sql/sc=
hema/mssql/jahia-schema.sql (original)
+++ branches/JAHIA-INCLUDE-TAG-BRANCH/core/src/webapp/WEB-INF/var/db/sql/sc=
hema/mssql/jahia-schema.sql Thu Jan 17 12:19:41 2008
@@ -101,6 +101,7 @@
drop table jahia_pages_def;
drop table jahia_pages_def_prop;
drop table jahia_pages_prop;
+drop table jahia_pages_users_prop;
drop table jahia_pwd_policies;
drop table jahia_pwd_policy_rule_params;
drop table jahia_pwd_policy_rules;
@@ -554,6 +555,15 @@
prop_value nvarchar(255) null,
primary key (page_id, prop_name, language_code)
);
+create table jahia_pages_users_prop (
+ page_id int not null,
+ principal_key nvarchar(150) not null,
+ principal_type nvarchar(150) not null,
+ prop_type nvarchar(150) not null,
+ prop_name nvarchar(150) not null,
+ prop_value nvarchar(255) null,
+ primary key (page_id, principal_key, principal_type, prop_type, prop_n=
ame)
+);
create table jahia_pwd_policies (
jahia_pwd_policy_id int not null,
name nvarchar(255) not null,
Modified: branches/JAHIA-INCLUDE-TAG-BRANCH/core/src/webapp/WEB-INF/var/db/=
sql/schema/mysql/jahia-schema.sql
URL: https://svndev.jahia.net/websvn/diff.php?path=3D/branches/JAHIA-INCLUD=
E-TAG-BRANCH/core/src/webapp/WEB-INF/var/db/sql/schema/mysql/jahia-schema.s=
ql&rev=3D19533&repname=3Djahia
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D
--- branches/JAHIA-INCLUDE-TAG-BRANCH/core/src/webapp/WEB-INF/var/db/sql/sc=
hema/mysql/jahia-schema.sql (original)
+++ branches/JAHIA-INCLUDE-TAG-BRANCH/core/src/webapp/WEB-INF/var/db/sql/sc=
hema/mysql/jahia-schema.sql Thu Jan 17 12:19:41 2008
@@ -101,6 +101,7 @@
drop table if exists jahia_pages_def;
drop table if exists jahia_pages_def_prop;
drop table if exists jahia_pages_prop;
+drop table if exists jahia_pages_users_prop;
drop table if exists jahia_pwd_policies;
drop table if exists jahia_pwd_policy_rule_params;
drop table if exists jahia_pwd_policy_rules;
@@ -554,6 +555,15 @@
prop_value varchar(255),
primary key (page_id, prop_name, language_code)
);
+create table jahia_pages_users_prop (
+ page_id integer not null,
+ principal_key varchar(150) not null,
+ principal_type varchar(150) not null,
+ prop_type varchar(150) not null,
+ prop_name varchar(150) not null,
+ prop_value varchar(255),
+ primary key (page_id, principal_key, principal_type, prop_type, prop_n=
ame)
+);
create table jahia_pwd_policies (
jahia_pwd_policy_id integer not null,
name varchar(255) not null,
Modified: branches/JAHIA-INCLUDE-TAG-BRANCH/core/src/webapp/WEB-INF/var/db/=
sql/schema/oracle/jahia-schema.sql
URL: https://svndev.jahia.net/websvn/diff.php?path=3D/branches/JAHIA-INCLUD=
E-TAG-BRANCH/core/src/webapp/WEB-INF/var/db/sql/schema/oracle/jahia-schema.=
sql&rev=3D19533&repname=3Djahia
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D
--- branches/JAHIA-INCLUDE-TAG-BRANCH/core/src/webapp/WEB-INF/var/db/sql/sc=
hema/oracle/jahia-schema.sql (original)
+++ branches/JAHIA-INCLUDE-TAG-BRANCH/core/src/webapp/WEB-INF/var/db/sql/sc=
hema/oracle/jahia-schema.sql Thu Jan 17 12:19:41 2008
@@ -50,6 +50,7 @@
drop table jahia_pages_def cascade constraints;
drop table jahia_pages_def_prop cascade constraints;
drop table jahia_pages_prop cascade constraints;
+drop table jahia_pages_users_prop cascade constraints;
drop table jahia_pwd_policies cascade constraints;
drop table jahia_pwd_policy_rule_params cascade constraints;
drop table jahia_pwd_policy_rules cascade constraints;
@@ -503,6 +504,15 @@
prop_value varchar2(255),
primary key (page_id, prop_name, language_code)
);
+create table jahia_pages_users_prop (
+ page_id number(10,0) not null,
+ principal_key varchar2(150) not null,
+ principal_type varchar2(150) not null,
+ prop_type varchar2(150) not null,
+ prop_name varchar2(150) not null,
+ prop_value varchar2(255),
+ primary key (page_id, principal_key, principal_type, prop_type, prop_n=
ame)
+);
create table jahia_pwd_policies (
jahia_pwd_policy_id number(10,0) not null,
name varchar2(255) not null,
Modified: branches/JAHIA-INCLUDE-TAG-BRANCH/core/src/webapp/WEB-INF/var/db/=
sql/schema/postgresql/jahia-schema.sql
URL: https://svndev.jahia.net/websvn/diff.php?path=3D/branches/JAHIA-INCLUD=
E-TAG-BRANCH/core/src/webapp/WEB-INF/var/db/sql/schema/postgresql/jahia-sch=
ema.sql&rev=3D19533&repname=3Djahia
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D
--- branches/JAHIA-INCLUDE-TAG-BRANCH/core/src/webapp/WEB-INF/var/db/sql/sc=
hema/postgresql/jahia-schema.sql (original)
+++ branches/JAHIA-INCLUDE-TAG-BRANCH/core/src/webapp/WEB-INF/var/db/sql/sc=
hema/postgresql/jahia-schema.sql Thu Jan 17 12:19:41 2008
@@ -101,6 +101,7 @@
drop table jahia_pages_def;
drop table jahia_pages_def_prop;
drop table jahia_pages_prop;
+drop table jahia_pages_users_prop;
drop table jahia_pwd_policies;
drop table jahia_pwd_policy_rule_params;
drop table jahia_pwd_policy_rules;
@@ -554,6 +555,15 @@
prop_value varchar(255),
primary key (page_id, prop_name, language_code)
);
+create table jahia_pages_users_prop (
+ page_id int4 not null,
+ principal_key varchar(150) not null,
+ principal_type varchar(150) not null,
+ prop_type varchar(150) not null,
+ prop_name varchar(150) not null,
+ prop_value varchar(255),
+ primary key (page_id, principal_key, principal_type, prop_type, prop_n=
ame)
+);
create table jahia_pwd_policies (
jahia_pwd_policy_id int4 not null,
name varchar(255) not null,
_______________________________________________
cvs_list mailing list
[email protected]
http://lists.jahia.org/cgi-bin/mailman/listinfo/cvs_list
