text: 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
  