[dcm4che-commits] CVS: dcm4jboss-ejb/src/etc/hsql/sql create.hsql, 1.100, 1.101

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

Update of /cvsroot/dcm4che/dcm4jboss-ejb/src/etc/hsql/sql
In directory sc8-pr-cvs12.sourceforge.net:/tmp/cvs-serv1843/src/etc/hsql/sql

Modified Files:
	create.hsql 
Log Message:
[#DCMEE-452] Add StudyPermission entity 

Index: create.hsql
===================================================================
RCS file: /cvsroot/dcm4che/dcm4jboss-ejb/src/etc/hsql/sql/create.hsql,v
retrieving revision 1.100
retrieving revision 1.101
diff -C2 -d -r1.100 -r1.101
*** create.hsql	29 Jun 2007 08:07:45 -0000	1.100
--- create.hsql	29 Jun 2007 10:41:39 -0000	1.101
***************
*** 121,124 ****
--- 121,138 ----
  CREATE INDEX study_pcode_fk ON rel_study_pcode(pcode_fk);
  
+ CREATE TABLE study_permission (
+ 	pk              IDENTITY PRIMARY KEY,
+ 	study_fk        INTEGER,
+ 	action          VARCHAR(256) NOT NULL,
+ 	roles           VARCHAR(256) NOT NULL,
+ 	valid_from      TIMESTAMP NOT NULL,
+ 	valid_until     TIMESTAMP NOT NULL,
+ FOREIGN KEY (study_fk) REFERENCES study(pk)
+ );
+ CREATE INDEX sty_perm_study_fk ON study_permission(study_fk);
+ CREATE INDEX sty_perm_action ON study_permission(action);
+ CREATE INDEX sty_perm_roles ON study_permission(roles);
+ CREATE INDEX sty_perm_from ON study_permission(valid_from);
+ CREATE INDEX sty_perm_until ON study_permission(valid_until);
  
  CREATE TABLE mpps (