[Oscarmcmaster-cvscommit] oscar_mcmaster/database/mysql/caisi initcaisi.sql, 1.81, 1.82

[Ted L. <ted...@us...>]

Update of /cvsroot/oscarmcmaster/oscar_mcmaster/database/mysql/caisi
In directory sc8-pr-cvs3.sourceforge.net:/tmp/cvs-serv16948/database/mysql/caisi

Modified Files:
	initcaisi.sql 
Log Message:


Index: initcaisi.sql
===================================================================
RCS file: /cvsroot/oscarmcmaster/oscar_mcmaster/database/mysql/caisi/initcaisi.sql,v
retrieving revision 1.81
retrieving revision 1.82
diff -C2 -d -r1.81 -r1.82
*** initcaisi.sql	27 Jun 2008 18:41:07 -0000	1.81
--- initcaisi.sql	27 Jun 2008 21:04:19 -0000	1.82
***************
*** 15,19 ****
  	integratorPassword varchar(255),
  	integratorLastPushTime datetime,
! 	useQuickConsent tinyint(1) not null
  );
  
--- 15,20 ----
  	integratorPassword varchar(255),
  	integratorLastPushTime datetime,
! 	useQuickConsent tinyint(1) not null,
! 	enableIntegratedReferrals tinyint(1) not null
  );
  
***************
*** 2428,2432 ****
  create table IntegratorConsent
  (
! 	facilityId int not null, foreign key (facilityId) references facility(id),
  	demographicId int not null, foreign key (demographicId) references demographic(demographic_no),
  	primary key (facilityId,demographicId),
--- 2429,2433 ----
  create table IntegratorConsent
  (
! 	facilityId int not null, foreign key (facilityId) references Facility(id),
  	demographicId int not null, foreign key (demographicId) references demographic(demographic_no),
  	primary key (facilityId,demographicId),
***************
*** 2444,2448 ****
  create table IntegratorConsentComplexForm
  (
! 	facilityId int not null, foreign key (facilityId) references facility(id),
  	demographicId int not null, foreign key (demographicId) references demographic(demographic_no),
  	primary key (facilityId,demographicId),
--- 2445,2449 ----
  create table IntegratorConsentComplexForm
  (
! 	facilityId int not null, foreign key (facilityId) references Facility(id),
  	demographicId int not null, foreign key (demographicId) references demographic(demographic_no),
  	primary key (facilityId,demographicId),
***************
*** 2455,2459 ****
  create table IntegratorConsentComplexExitInterview
  (
! 	facilityId int not null, foreign key (facilityId) references facility(id),
  	demographicId int not null, foreign key (demographicId) references demographic(demographic_no),
  	primary key (facilityId,demographicId),
--- 2456,2460 ----
  create table IntegratorConsentComplexExitInterview
  (
! 	facilityId int not null, foreign key (facilityId) references Facility(id),
  	demographicId int not null, foreign key (demographicId) references demographic(demographic_no),
  	primary key (facilityId,demographicId),