OAT » TPI Jueces

INSERT INTO SUMACCatalogValueType (Code, DescriptionES, CreatedBy, CreatedDate, ModifiedBy, ModifiedDate)
VALUES (26, 'Tipo de estampa', 'BA188E4A-E2B5-45F3-9835-32C94121C00E', GETDATE(), 'BA188E4A-E2B5-45F3-9835-32C94121C00E', GETDATE())

INSERT INTO SUMACCatalogValue (Code, DescriptionES, CatalogTypeCode, IsLocked, CreatedBy, CreatedDate, ModifiedBy, ModifiedDate)
VALUES 
	(388, 'Firma', 26, 1, 'BA188E4A-E2B5-45F3-9835-32C94121C00E', GETDATE(), 'BA188E4A-E2B5-45F3-9835-32C94121C00E', GETDATE()),
	(389, 'Iniciales', 26, 1, 'BA188E4A-E2B5-45F3-9835-32C94121C00E', GETDATE(), 'BA188E4A-E2B5-45F3-9835-32C94121C00E', GETDATE()),
	(390, 'Sello', 26, 1, 'BA188E4A-E2B5-45F3-9835-32C94121C00E', GETDATE(), 'BA188E4A-E2B5-45F3-9835-32C94121C00E', GETDATE())
	
CREATE TABLE SUMACMunicipalQA.dbo.SUMACSignature (
    SignatureId int IDENTITY(1,1) NOT NULL,
    FileId int NOT NULL,
    Location varchar(100) NULL,
   	Width decimal(20, 10) NOT NULL,
   	Height decimal(20, 10) NOT NULL,
   	xAxisCoordinates decimal(20, 10) NOT NULL, 
   	yAxisCoordinates decimal(20, 10) NOT NULL,
   	PageNumber int NOT NULL,
   	TypeCode int NOT NULL,
    IsHidden bit DEFAULT 0 NOT NULL,
    HiddenReason varchar(100) NULL,
    CreatedDate datetime NOT NULL,
    CreatedBy uniqueidentifier NOT NULL,
    ModifiedDate datetime NOT NULL,
    ModifiedBy uniqueidentifier NOT NULL,
    UpdateVersion timestamp NOT NULL,
    CONSTRAINT PK__SignatureId PRIMARY KEY (SignatureId),
    CONSTRAINT fk_fromSUMACSignatureToSUMACFileBase FOREIGN KEY (FileId) REFERENCES SUMACMunicipalQA.dbo.SUMACFileBase(FileId),
    CONSTRAINT fk_fromSUMACSignatureToSUMACCatalogValue FOREIGN KEY (TypeCode) REFERENCES SUMACMunicipalQA.dbo.SUMACCatalogValue(Code),
)

ALTER TABLE SUMACMunicipalQA.dbo.SUMACSignature ALTER COLUMN xAxisCoordinates decimal(20,10) NULL;
ALTER TABLE SUMACMunicipalQA.dbo.SUMACSignature ALTER COLUMN yAxisCoordinates decimal(20,10) NULL;
ALTER TABLE SUMACMunicipalQA.dbo.SUMACSignature ALTER COLUMN PageNumber int NULL;

INSERT INTO SUMACCatalogValue (Code, DescriptionES, CatalogTypeCode, IsLocked, CreatedBy, CreatedDate, ModifiedBy, ModifiedDate)
VALUES 
	(391, 'Firma por defecto', 26, 1, 'BA188E4A-E2B5-45F3-9835-32C94121C00E', GETDATE(), 'BA188E4A-E2B5-45F3-9835-32C94121C00E', GETDATE())

PR ready for review: YRN-Seedbury — Task 20278: Notificaciones: Corregir antes de notificar → status: Pending Review