CREATE TABLE [Tzdb].[Links]
(
[LinkZoneId] [int] NOT NULL,
[CanonicalZoneId] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [Tzdb].[Links] ADD CONSTRAINT [PK_Links] PRIMARY KEY NONCLUSTERED  ([LinkZoneId]) ON [PRIMARY]
GO
ALTER TABLE [Tzdb].[Links] ADD CONSTRAINT [FK_Links_Zones_2] FOREIGN KEY ([CanonicalZoneId]) REFERENCES [Tzdb].[Zones] ([Id])
GO
ALTER TABLE [Tzdb].[Links] ADD CONSTRAINT [FK_Links_Zones_1] FOREIGN KEY ([LinkZoneId]) REFERENCES [Tzdb].[Zones] ([Id])
GO
GRANT SELECT ON  [Tzdb].[Links] TO [MssExec]
GRANT INSERT ON  [Tzdb].[Links] TO [MssExec]
GRANT DELETE ON  [Tzdb].[Links] TO [MssExec]
GRANT UPDATE ON  [Tzdb].[Links] TO [MssExec]
GO