[dcm4che-commits] CVS: dcm4jboss-ejb/src/etc/psql/sql create.psql,1.7,1.8 update.psql,1.5,1.6

[Umberto C. <umb...@us...>]

Update of /cvsroot/dcm4che/dcm4jboss-ejb/src/etc/psql/sql
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv21382/src/etc/psql/sql

Modified Files:
	create.psql update.psql 
Log Message:


Index: create.psql
===================================================================
RCS file: /cvsroot/dcm4che/dcm4jboss-ejb/src/etc/psql/sql/create.psql,v
retrieving revision 1.7
retrieving revision 1.8
diff -C2 -d -r1.7 -r1.8
*** create.psql	25 Feb 2004 23:49:33 -0000	1.7
--- create.psql	26 Feb 2004 13:09:21 -0000	1.8
***************
*** 1,9 ****
  
  CREATE TABLE ae (
! 	aet          	TEXT PRIMARY KEY,
  	hostname     	TEXT NOT NULL,
  	port			INTEGER NOT NULL,
  	cipher_suites  	TEXT
  );
  
  CREATE TABLE move_order (
--- 1,11 ----
  
  CREATE TABLE ae (
! 	pk          	SERIAL PRIMARY KEY,
! 	aet          	TEXT NOT NULL,
  	hostname     	TEXT NOT NULL,
  	port			INTEGER NOT NULL,
  	cipher_suites  	TEXT
  );
+ CREATE UNIQUE INDEX aet ON ae(aet);
  
  CREATE TABLE move_order (

Index: update.psql
===================================================================
RCS file: /cvsroot/dcm4che/dcm4jboss-ejb/src/etc/psql/sql/update.psql,v
retrieving revision 1.5
retrieving revision 1.6
diff -C2 -d -r1.5 -r1.6
*** update.psql	25 Feb 2004 23:49:33 -0000	1.5
--- update.psql	26 Feb 2004 13:09:21 -0000	1.6
***************
*** 10,13 ****
--- 10,23 ----
  );
  
+ DROP TABLE ae; 
+ CREATE TABLE ae (
+ 	pk          	SERIAL PRIMARY KEY,
+ 	aet          	TEXT NOT NULL,
+ 	hostname     	TEXT NOT NULL,
+ 	port			INTEGER NOT NULL,
+ 	cipher_suites  	TEXT
+ );
+ CREATE UNIQUE INDEX aet ON ae(aet);
+ 
  CREATE TABLE roles(
  	user_id		TEXT,