[PATCH] DDL of oracle changed to primary keys, added some indexe s

Index: create_oracle.sql
===================================================================
RCS file: /cvsroot/openjms/openjms/src/config/db/create_oracle.sql,v
retrieving revision 1.3
diff -u -r1.3 create_oracle.sql
--- create_oracle.sql	3 Jan 2004 03:31:57 -0000	1.3
+++ create_oracle.sql	14 Apr 2004 17:41:38 -0000
@@ -4,14 +4,23 @@
   version                varchar2(20) not null,
   creationDate           date not null
 );
-create unique index system_data_pk on system_data(id);
+alter table system_data
+	add constraint system_data_pk
+	primary key ( id )
+	using index;
+
+
 
 drop table seeds;
 create table seeds (
   name                   varchar2(20) not null,
   seed                   NUMBER(28) not null
 );
-create unique index seeds_pk on seeds(name);
+alter table seeds
+	add constraint seeds_pk
+	primary key ( name )
+	using index;
+
 
 drop table destinations;
 create table destinations (
@@ -19,7 +28,10 @@
   isQueue                NUMBER(3) not null,
   destinationId          NUMBER(28) not null
 );
-create unique index destinations_pk on destinations(name);
+alter table destinations
+	add constraint destinations_pk
+	primary key ( name )
+	using index;
 
 drop table messages;
 create table messages (
@@ -29,9 +41,21 @@
   createTime            NUMBER(28) not null,
   expiryTime            NUMBER(28),
   processed             NUMBER(3),
-  messageBlob           LONG raw not null
+  messageBlob           BLOB not null
+);
+
+alter table messages
+	add constraint messages_pk
+	primary key ( messageid )
+	using index;
+
+create index messages_x1 on messages(
+	EXPIRYTIME
+);
+
+create index messages_x2 on messages(
+	DESTINATIONID
 );
-create index messages_pk on messages(messageId);
 
 DROP TABLE message_handles;
 CREATE TABLE message_handles (
@@ -44,7 +68,16 @@
    expiryTime           NUMBER(28),
    delivered            NUMBER(3)
 );
-CREATE INDEX message_handles_pk ON message_handles(destinationId,
consumerId, messageId);
+
+alter table message_handles
+	add constraint message_handles_pk
+	primary key ( destinationId, consumerId, messageId )
+	using index;
+create index message_handles_x1 on message_handles(expirytime);
+create index message_handles_x2 on message_handles(messageid);
+create index message_handles_x3 on message_handles(destinationid);
+create index message_handles_x4 on
message_handles(consumerid,acceptedtime);
+
 
 drop table consumers;
 create table consumers (
@@ -53,11 +86,18 @@
   consumerId           NUMBER(28) not NULL,
   created              NUMBER(28) NOT NULL
 );
-create unique index consumers_pk on consumers(name, destinationId);
+alter table consumers
+	add constraint consumers_pk
+	primary key ( name, destinationid )
+	using index;
+
 
 drop table users;
 create table users (
   username             varchar2(50) not null,
   password             varchar2(50) not null
 );
-create unique index users_pk on users(username);
\ No newline at end of file
+alter table users
+	add constraint users_pk
+	primary key ( username )
+	using index;
Index: src/config/db/create_oracle.patch
===================================================================
RCS file: src/config/db/create_oracle.patch
diff -N src/config/db/create_oracle.patch
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ src/config/db/create_oracle.patch	1 Jan 1970 00:00:00 -0000
@@ -0,0 +1,18 @@
+Index: create_oracle.sql
+===================================================================
+RCS file: /cvsroot/openjms/openjms/src/config/db/create_oracle.sql,v
+retrieving revision 1.2
+diff -u -w -i -b -r1.2 create_oracle.sql
+--- create_oracle.sql	23 Oct 2003 13:42:47 -0000	1.2
++++ create_oracle.sql	5 Jan 2004 09:22:54 -0000
+@@ -32,6 +32,10 @@
+   messageBlob           LONG raw not null
+ );
+ create index messages_pk on messages(messageId);
++create index messages_x1 on messages(
++	EXPIRYTIME,
++	DESTINATIONID
++);
+ 
+ DROP TABLE message_handles;
+ CREATE TABLE message_handles (


-------------------------------------------------------
This SF.Net email is sponsored by: IBM Linux Tutorials
Free Linux tutorial presented by Daniel Robbins, President and CEO of
GenToo technologies. Learn everything from fundamentals to system
administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click