CREATE TABLE client.ScanTaskAlgorithmRestrictions
	(
	    ID uniqueidentifier NOT NULL,
	    ScanTaskAlgorithm int NOT NULL,
	    RowOrder int NOT NULL,
	    RestrictionName nvarchar(MAX) NOT NULL
	)  ON [PRIMARY]
	   TEXTIMAGE_ON [PRIMARY]
    GO
    ALTER TABLE client.ScanTaskAlgorithmRestrictions ADD CONSTRAINT
	    DF_ScanTaskAlgorithmRestrictions_ID DEFAULT (newid()) FOR ID
    GO
    ALTER TABLE client.ScanTaskAlgorithmRestrictions ADD CONSTRAINT
	    PK_ScanTaskAlgorithmRestrictions PRIMARY KEY CLUSTERED
	    (
	    ScanTaskAlgorithm,
	    RowOrder
	    ) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

    GO
    ALTER TABLE client.ScanTaskAlgorithmRestrictions SET (LOCK_ESCALATION = TABLE)
    GO