// Alter table fs00001006_mod_courses.coursereserves_reserves
ALTER TABLE fs00001006_mod_courses.coursereserves_reserves
	ADD COLUMN copyrighttracking_copyrightstatusid uuid NULL
GO

// Alter function fs00001006_mod_courses.update_coursereserves_reserves_references()
CREATE OR REPLACE FUNCTION fs00001006_mod_courses.update_coursereserves_reserves_references () RETURNS trigger AS
$$
    BEGIN
      NEW.courseListingId = (NEW.jsonb->>'courseListingId');
      NEW.processingStatusId = (NEW.jsonb->>'processingStatusId');
      NEW.copyrightTracking_copyrightStatusId = (NEW.jsonb->'copyrightTracking'->>'copyrightStatusId');
      RETURN NEW;
    END;
    $$
LANGUAGE 'plpgsql' COST 100
GO
ALTER FUNCTION fs00001006_mod_courses.update_coursereserves_reserves_references () OWNER TO folio
GO

// Create index fs00001006_mod_courses.coursereserves_reserves_copyrighttracking_copyrightstatusid_idx
CREATE INDEX coursereserves_reserves_copyrighttracking_copyrightstatusid_idx
	ON fs00001006_mod_courses.coursereserves_reserves USING btree (copyrighttracking_copyrightstatusid)
GO

// Create foreign key constraint fs00001006_mod_courses.coursereserves_reserves_copyrighttracking_copyrightstatusi_fkey
ALTER TABLE fs00001006_mod_courses.coursereserves_reserves
	ADD 
	FOREIGN KEY(copyrighttracking_copyrightstatusid)
	REFERENCES fs00001006_mod_courses.coursereserves_copyrightstates(id)
	MATCH SIMPLE
	ON DELETE NO ACTION 
	ON UPDATE NO ACTION 
GO