[dcm4che-commits] CVS: dcm4jboss-ejb/src/etc/db2/sql update.db2sql,1.2,1.3 create.db2sql,1.8,1.9

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

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

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


Index: update.db2sql
===================================================================
RCS file: /cvsroot/dcm4che/dcm4jboss-ejb/src/etc/db2/sql/update.db2sql,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** update.db2sql	25 Feb 2004 23:49:32 -0000	1.2
--- update.db2sql	26 Feb 2004 13:09:16 -0000	1.3
***************
*** 7,10 ****
--- 7,21 ----
  CREATE INDEX pat_merge_fk ON patient(merge_fk);
  
+ DROP TABLE ae ;
+ CREATE SEQUENCE ae_pk_seq;
+ CREATE TABLE ae (
+ 	pk          	INTEGER PRIMARY KEY NOT NULL,
+ 	aet          	VARCHAR(254) NOT NULL,
+ 	hostname     	VARCHAR(254) NOT NULL,
+ 	port			INTEGER NOT NULL,
+ 	cipher_suites  	VARCHAR(254)
+ );
+ CREATE UNIQUE INDEX aet ON ae(aet);
+ 
  CREATE TABLE users(
  	user_id		VARCHAR(254) PRIMARY KEY,
***************
*** 21,24 ****
--- 32,37 ----
  INSERT INTO roles VALUES('admin','WebAdmin');
  
+ GRANT ALL PRIVILEGES ON TABLE ae TO USER tiani;
+ GRANT USAGE ON SEQUENCE tiani.ae_pk_seq TO USER tiani;
  GRANT ALL PRIVILEGES ON TABLE users TO USER tiani;
  GRANT ALL PRIVILEGES ON TABLE roles TO USER tiani;

Index: create.db2sql
===================================================================
RCS file: /cvsroot/dcm4che/dcm4jboss-ejb/src/etc/db2/sql/create.db2sql,v
retrieving revision 1.8
retrieving revision 1.9
diff -C2 -d -r1.8 -r1.9
*** create.db2sql	25 Feb 2004 23:49:32 -0000	1.8
--- create.db2sql	26 Feb 2004 13:09:17 -0000	1.9
***************
*** 4,13 ****
  SET CURRENT SCHEMA TIANI;
  
  CREATE TABLE ae (
! 	aet          	VARCHAR(254) PRIMARY KEY NOT NULL,
  	hostname     	VARCHAR(254) NOT NULL,
  	port			INTEGER NOT NULL,
  	cipher_suites  	VARCHAR(254)
  );
  
  CREATE SEQUENCE move_order_pk_seq;
--- 4,16 ----
  SET CURRENT SCHEMA TIANI;
  
+ CREATE SEQUENCE ae_pk_seq;
  CREATE TABLE ae (
! 	pk          	INTEGER PRIMARY KEY NOT NULL,
! 	aet          	VARCHAR(254) NOT NULL,
  	hostname     	VARCHAR(254) NOT NULL,
  	port			INTEGER NOT NULL,
  	cipher_suites  	VARCHAR(254)
  );
+ CREATE UNIQUE INDEX aet ON ae(aet);
  
  CREATE SEQUENCE move_order_pk_seq;
***************
*** 189,192 ****
--- 192,196 ----
  GRANT ALL PRIVILEGES ON TABLE roles TO USER tiani;
  
+ GRANT USAGE ON SEQUENCE tiani.ae_pk_seq TO USER tiani;
  GRANT USAGE ON SEQUENCE tiani.move_order_pk_seq TO USER tiani;
  GRANT USAGE ON SEQUENCE tiani.code_pk_seq TO USER tiani;