-- Tables

-- Alters

ALTER TABLE [AKUZ].[T_FEDERAL_REGISTER_LOAD] ALTER COLUMN [Version] int NOT NULL
GO


if exists(select* from sys.indexes i where i.[object_id] = object_id('AKUZ.T_FR_RECORD', 'U') and i.name = 'IX_T_FR_RECORD_SNILS')
	DROP INDEX IX_T_FR_RECORD_SNILS ON AKUZ.T_FR_RECORD;
GO

ALTER TABLE [AKUZ].T_FR_RECORD ALTER COLUMN [Version] int NOT NULL
GO

CREATE NONCLUSTERED INDEX [IX_T_FR_RECORD_SNILS] ON [AKUZ].[T_FR_RECORD] ([Snils] ASC) INCLUDE([DateBegin],[DateEnd],[NSU],[DateNsuBegin],[DateNsuEnd],[Nsus],[Deleted],[Version]) WITH (FILLFACTOR = 95)
GO