text: alter table facility add column useQuickConsent tinyint(1) not null;
  update facility set useQuickConsent=1;
  
  update bed set facility_id=1 where facility_id=0;
  update room set facility_id=1 where facility_id=0;
  update intake set facility_id=1 where facility_id is NULL;
  update room set occupancy=20 where occupancy=0;
  update custom_filter set end_date='8888-12-30' where end_date='0000-00-00';
  
  insert into provider_facility select provider_no, "1" from provider;
  insert into room_demographic select b.room_id,bd.demographic_no,bd.provider_no,reservation_start,reservation_end,'' from bed_demographic bd, bed b where bd.bed_id=b.bed_id; 
  
  
  -- insert into access_type (name,type) values ("read RPN ticklers","access");
  update facility set useQuickConsent=1;
  
  update bed set facility_id=1 where facility_id=0;
  update room set facility_id=1 where facility_id=0;
  update intake set facility_id=1 where facility_id is NULL;
  update room set occupancy=20 where occupancy=0;
  update custom_filter set end_date='8888-12-30' where end_date='0000-00-00';
  
  insert into provider_facility select provider_no, "1" from provider;
  insert into room_demographic select b.room_id,bd.demographic_no,bd.provider_no,reservation_start,reservation_end,'' from bed_demographic bd, bed b where bd.bed_id=b.bed_id; 
  
  insert into `secObjectName` (`objectName`,`description`,`orgapplicable`) values ('_pmm.eidtor','Caisi Intake Editor',0);
  insert into `secObjPrivilege` values('admin','_pmm.editor','x',0,999998);
  
  
  -- The following lines are only used for seaton house
  -- insert into access_type (name,type) values ("read RPN ticklers","access");
  -- insert into access_type (name,type) values ("read RN ticklers","access");
  -- insert into access_type (name,type) values ("read Reception Staff ticklers","access");
  -- insert into access_type (name,type) values ("read Program Supervisor ticklers","access");
  -- insert into access_type (name,type) values ("read Shift Leader ticklers","access");
  -- insert into access_type (name,type) values ("read Housing Worker ticklers","access");
  -- insert into access_type (name,type) values ("read Program Coordinator ticklers","access");
  -- insert into access_type (name,type) values ("read Nurse Practitioner ticklers","access");
  -- insert into access_type (name,type) values ("read Health Care Aide ticklers","access");
  -- insert into access_type (name,type) values ("read Withdrawal Management Worker ticklers","access");
  -- insert into access_type (name,type) values ("read Social Worker ticklers","access");