IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[podmiot].[ProtokolZbiorczy]') AND name = N'IX__ProtokolZbiorczy_IdPlacowka_IdEgzamin')
CREATE NONCLUSTERED INDEX [IX__ProtokolZbiorczy_IdPlacowka_IdEgzamin] ON [podmiot].[ProtokolZbiorczy]
(
    [IdPlacowka] ASC,
    [IdEgzamin] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [SECONDARY]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[podmiot].[ProtokolZbiorczyDlaObserwatora]') AND name = N'IX__ProtokolZbiorczyDlaObserwatora_IdProtokolZbiorczy')
CREATE NONCLUSTERED INDEX [IX__ProtokolZbiorczyDlaObserwatora_IdProtokolZbiorczy] ON [podmiot].[ProtokolZbiorczyDlaObserwatora]
(
    [IdProtokolZbiorczy] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [SECONDARY]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[podmiot].[ProtokolZbiorczyDlaWadliwegoArkusza]') AND name = N'IX__ProtokolZbiorczyDlaWadliwegoArkusza_IdProtokolZbiorczy')
CREATE NONCLUSTERED INDEX [IX__ProtokolZbiorczyDlaWadliwegoArkusza_IdProtokolZbiorczy] ON [podmiot].[ProtokolZbiorczyDlaWadliwegoArkusza]
(
    [IdProtokolZbiorczy] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [SECONDARY]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[podmiot].[ProtokolZbiorczyNieprzystapieniaZdajacego]') AND name = N'IX__ProtokolZbiorczyNieprzystapieniaZdajacego_IdProtokolZbiorczy')
CREATE NONCLUSTERED INDEX [IX__ProtokolZbiorczyNieprzystapieniaZdajacego_IdProtokolZbiorczy] ON [podmiot].[ProtokolZbiorczyNieprzystapieniaZdajacego]
(
    [IdProtokolZbiorczy] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [SECONDARY]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[podmiot].[ProtokolZbiorczyOtwarciaMaterialuEgzaminacyjnego]') AND name = N'IX__ProtokolZbiorczyOtwarciaMaterialuEgzaminacyjnego_IdProtokolZbiorczy')
CREATE NONCLUSTERED INDEX [IX__ProtokolZbiorczyOtwarciaMaterialuEgzaminacyjnego_IdProtokolZbiorczy] ON [podmiot].[ProtokolZbiorczyOtwarciaMaterialuEgzaminacyjnego]
(
    [IdProtokolZbiorczy] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [SECONDARY]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[podmiot].[ProtokolZbiorczyRozliczeniaArkusza]') AND name = N'IX__ProtokolZbiorczyRozliczeniaArkusza_IdProtokolZbiorczy')
CREATE NONCLUSTERED INDEX [IX__ProtokolZbiorczyRozliczeniaArkusza_IdProtokolZbiorczy] ON [podmiot].[ProtokolZbiorczyRozliczeniaArkusza]
(
    [IdProtokolZbiorczy] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [SECONDARY]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[podmiot].[ProtokolZbiorczyRozliczeniaKopertZwrotnych]') AND name = N'IX__ProtokolZbiorczyRozliczeniaKopertZwrotnych_IdProtokolZbiorczy')
CREATE NONCLUSTERED INDEX [IX__ProtokolZbiorczyRozliczeniaKopertZwrotnych_IdProtokolZbiorczy] ON [podmiot].[ProtokolZbiorczyRozliczeniaKopertZwrotnych]
(
    [IdProtokolZbiorczy] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [SECONDARY]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[podmiot].[ProtokolZbiorczyRozliczeniaSaliEgzaminacyjnej]') AND name = N'IX__ProtokolZbiorczyRozliczeniaSaliEgzaminacyjnej_IdProtokolZbiorczy')
CREATE NONCLUSTERED INDEX [IX__ProtokolZbiorczyRozliczeniaSaliEgzaminacyjnej_IdProtokolZbiorczy] ON [podmiot].[ProtokolZbiorczyRozliczeniaSaliEgzaminacyjnej]
(
    [IdProtokolZbiorczy] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [SECONDARY]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[podmiot].[ProtokolZbiorczyZDostosowaniaTypuArkusza]') AND name = N'IX__ProtokolZbiorczyZDostosowaniaTypuArkusza_IdProtokolZbiorczy')
CREATE NONCLUSTERED INDEX [IX__ProtokolZbiorczyZDostosowaniaTypuArkusza_IdProtokolZbiorczy] ON [podmiot].[ProtokolZbiorczyZDostosowaniaTypuArkusza]
(
    [IdProtokolZbiorczy] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [SECONDARY]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[podmiot].[ProtokolZbiorczyZDostosowaniemDlaZdajacego]') AND name = N'IX__ProtokolZbiorczyZDostosowaniemDlaZdajacego_IdProtokolZbiorczy')
CREATE NONCLUSTERED INDEX [IX__ProtokolZbiorczyZDostosowaniemDlaZdajacego_IdProtokolZbiorczy] ON [podmiot].[ProtokolZbiorczyZDostosowaniemDlaZdajacego]
(
    [IdProtokolZbiorczy] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [SECONDARY]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[podmiot].[ProtokolZbiorczyZwolnieniaZdajacego]') AND name = N'IX__ProtokolZbiorczyZwolnieniaZdajacego_IdProtokolZbiorczy')
CREATE NONCLUSTERED INDEX [IX__ProtokolZbiorczyZwolnieniaZdajacego_IdProtokolZbiorczy] ON [podmiot].[ProtokolZbiorczyZwolnieniaZdajacego]
(
    [IdProtokolZbiorczy] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [SECONDARY]
GO