[ openjms-Bugs-947723 ] syntax errors in create_sybase.sql

Bugs item #947723, was opened at 2004-05-04 10:38
Message generated for change (Tracker Item Submitted) made by Item Submitter
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=474136&aid=947723&group_id=54559

Category: persistence
Group: v0.7.6
Status: Open
Resolution: None
Priority: 5
Submitted By: Robert T. Brown (dashrb)
Assigned to: Jim Alateras (jalateras)
Summary: syntax errors in create_sybase.sql

Initial Comment:
In 0.7.6, the create_sybase.sql script contains 2
syntax errors.
1. It attempts to create an index on a non-existent
table message_id.
2. It contains a semicolon in an invalid location.


Patch shown:
[email protected]{42}cvs -z3
-d:pserver:[email protected]:/cvsroot/openjms
diff -u -w create_sybase.sql
Index: create_sybase.sql
===================================================================
RCS file:
/cvsroot/openjms/openjms/src/config/db/create_sybase.sql,v
retrieving revision 1.2
diff -u -w -r1.2 create_sybase.sql
--- create_sybase.sql   3 Jan 2004 03:31:57 -0000       1.2
+++ create_sybase.sql   4 May 2004 13:44:49 -0000
@@ -11,11 +11,6 @@
 alter table system_data lock datarows
 go
 
-create unique index message_id_pk on message_id(id)
-go
-alter table message_id lock datarows
-go
-
 drop table seeds
 go
 create table seeds (
@@ -95,7 +90,7 @@
 create table users (
   username             varchar(50) not null,
   password             varchar(50) not null
-);
+)
 go
 create unique index users_pk on users(username)
 go

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=474136&aid=947723&group_id=54559


-------------------------------------------------------
This SF.Net email is sponsored by: Oracle 10g
Get certified on the hottest thing ever to hit the market... Oracle 10g. 
Take an Oracle 10g class now, and we'll give you the exam FREE.
http://ads.osdn.com/?ad_id=3149&alloc_id=8166&op=click