[dcm4che-commits] CVS: dcm4jboss-ejb/src/sql create.psql,1.3,1.4

[gunter z. <gun...@us...>]

Update of /cvsroot/dcm4che/dcm4jboss-ejb/src/sql
In directory sc8-pr-cvs1:/tmp/cvs-serv16466/src/sql

Modified Files:
	create.psql 
Log Message:
remove Principal

Index: create.psql
===================================================================
RCS file: /cvsroot/dcm4che/dcm4jboss-ejb/src/sql/create.psql,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -d -r1.3 -r1.4
*** create.psql	21 Jul 2003 22:35:32 -0000	1.3
--- create.psql	28 Jul 2003 07:31:18 -0000	1.4
***************
*** 96,124 ****
  );
  CREATE INDEX retrieve_aet ON file(retrieve_aet);
- 
- CREATE TABLE principal (
- 	pk          	SERIAL PRIMARY KEY,
- 	name         	TEXT
- );
- CREATE UNIQUE INDEX principal_name ON principal(name);
- 
- CREATE TABLE link_principal_patient (
- 	principal_fk	INTEGER NOT NULL,
- 	patient_fk		INTEGER NOT NULL,
- FOREIGN KEY (principal_fk)	REFERENCES principal(pk),
- FOREIGN KEY (patient_fk)	REFERENCES patient(pk)
- );
- 
- CREATE TABLE link_principal_study (
- 	principal_fk	INTEGER NOT NULL,
- 	study_fk		INTEGER NOT NULL,
- FOREIGN KEY (principal_fk)	REFERENCES principal(pk),
- FOREIGN KEY (study_fk) 		REFERENCES study(pk)
- );
- 
- CREATE TABLE link_principal_series (
- 	principal_fk	INTEGER NOT NULL,
- 	series_fk		INTEGER NOT NULL,
- FOREIGN KEY (principal_fk)	REFERENCES principal(pk),
- FOREIGN KEY (series_fk)  	REFERENCES series(pk)
- );
--- 96,97 ----