Files
2017-10-07 10:23:15 +02:00

32 lines
491 B
SQL

ALTER TABLE `Documents`
ADD COLUMN `HiresStatus` INT NULL DEFAULT 0 AFTER `UploadedDateTime`,
ADD INDEX `Index_HiresStatus` (`HiresStatus` ASC)
#
UPDATE Documents SET Documents.HiresStatus=1 WHERE Documents.HiresStatus=0;
#
DROP PROCEDURE IF EXISTS `SetDocumentHiresStatus`
#
CREATE PROCEDURE `SetDocumentHiresStatus`(
documentId INT,
hiresStatus INT
)
BEGIN
UPDATE Documents
SET Documents.HiresStatus = hiresStatus
WHERE Documents.DocumentId = documentId;
END