-- ============================================================
--  MSSQL — add the landing-page flag to the links table.
--  is_default = 1 marks the ONE menu item shown first when the
--  system loads. Additive and idempotent; run once on StudentInfo.
-- ============================================================

USE [StudentInfo];
GO

IF COL_LENGTH('dbo.links', 'is_default') IS NULL
    ALTER TABLE dbo.links ADD [is_default] INT NOT NULL CONSTRAINT DF_links_is_default DEFAULT 0;
GO
