OAT » TS Jueces

INSERT INTO catalogTypes (catalogTypeCode, catalogTypeDescription)
VALUES (76, 'noteVisibilityType')

INSERT INTO catalogValues (catalogValueCode, catalogValueDescription, catalogTypeCode, catalogTypeDescription, isLocked)
VALUES 
	(883, 'Pública', 76, 'noteVisibilityType', 1),
	(884, 'Oficina', 76, 'noteVisibilityType', 1),
	(885, 'Sala', 76, 'noteVisibilityType', 1)
	
ALTER TABLE recourseNoteDetails 
ADD 
	visibilityTypeCode int,
	visibilityTypeDescription varchar(250) 
	
ALTER TABLE	recourseNoteDetails 
ALTER COLUMN 
	visibilityTypeCode int NOT NULL
	visibilityTypeDescription varchar(250) NOT NULL
	
ALTER TABLE recourseNoteDetails 
ADD CONSTRAINT FKrecourse_note_details_visibilityType FOREIGN KEY (visibilityTypeCode) REFERENCES SUMAC_SC.dbo.catalogValues(catalogValueCode)

ALTER TABLE filingNoteDetails 
ADD 
	visibilityTypeCode int,
	visibilityTypeDescription varchar(250) 

UPDATE filingNoteDetails
SET visibilityTypeCode = 883, visibilityTypeDescription = 'Pública'

	
ALTER TABLE	filingNoteDetails 
ALTER COLUMN 
	visibilityTypeCode int NOT NULL
	
ALTER TABLE	filingNoteDetails 
ALTER COLUMN
	visibilityTypeDescription varchar(250) NOT NULL
	
ALTER TABLE filingNoteDetails 
ADD CONSTRAINT FKfiling_note_details_visibilityType FOREIGN KEY (visibilityTypeCode) REFERENCES SUMAC_SC.dbo.catalogValues(catalogValueCode)

INSERT INTO catalogValues (catalogValueCode, catalogValueDescription, catalogTypeCode, catalogTypeDescription, isLocked)
VALUES (886, 'Privada', 76, 'noteVisibilityType', 1)

UPDATE recourseNoteDetails 
SET visibilityTypeCode = 886, visibilityTypeDescription = 'Privada'
WHERE isPrivate = 1

UPDATE filingNoteDetails 
SET visibilityTypeCode = 886, visibilityTypeDescription = 'Privada'
WHERE isPrivate = 1