cmailleux 2005/12/20 14:51:51 CET
Modified files:
core/src/webapp/WEB-INF/var/db/sql/schema/oracle
jahia-schema.sql
Log:
Correct schema for oracle
Revision Changes Path
1.18 +3 -12
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.17&r2=1.18&f=h
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.17
retrieving revision 1.18
diff -u -r1.17 -r1.18
--- jahia-schema.sql 19 Dec 2005 12:09:49 -0000 1.17
+++ jahia-schema.sql 20 Dec 2005 13:51:51 -0000 1.18
@@ -85,6 +85,7 @@
drop table jahia_workflow cascade constraints;
drop table jahia_db_test cascade constraints;
drop table jahia_indexjobservers cascade CONSTRAINTS;
+drop table jahia_indexingjob cascade CONSTRAINTS;
create table CLIPPER (
id number(19,0) not null,
@@ -755,13 +756,7 @@
(
testfield VARCHAR2 (255)
);
-CREATE TABLE jahia_indexjobservers
-(
- indexjob_id VARCHAR2(50) NOT NULL,
- server_id VARCHAR2(50) NOT NULL,
- process_date number(19,0) NOT NULL,
- primary_key(indexjob_id,serverid)
-);
+
alter table CLIPPER
add constraint FK5E1C17AD67F313E6
foreign key (refFilter)
@@ -1099,7 +1094,6 @@
-----------------------------------------------------------------------------
-- jahia_indexjobservers
-----------------------------------------------------------------------------
-DROP TABLE jahia_indexjobservers CASCADE CONSTRAINTS;
CREATE TABLE jahia_indexjobservers
(
@@ -1112,8 +1106,6 @@
ADD CONSTRAINT jahia_indexjobservers_PK
PRIMARY KEY (indexjob_id,server_id);
-CREATE INDEX jahia_indexjobservers_index ON jahia_indexjobservers
(indexjob_id, server_id);
-
@@ -1121,7 +1113,7 @@
-----------------------------------------------------------------------------
-- jahia_indexingjob
-----------------------------------------------------------------------------
-DROP TABLE jahia_indexingjob CASCADE CONSTRAINTS;
+
CREATE TABLE jahia_indexingjob
(
@@ -1141,4 +1133,3 @@
ADD CONSTRAINT jahia_indexingjob_PK
PRIMARY KEY (id_indexingjob);
-CREATE INDEX jahia_indexingjob_index ON jahia_indexingjob (id_indexingjob);
