IF NOT EXISTS
(
    SELECT name
    FROM sysobjects
    WHERE name = 'SupplementaryInsurance'
)
BEGIN
    CREATE TABLE [dbo].[SupplementaryInsurance]
    (
        [Code] [VARCHAR](3) NOT NULL,
        [Name] [NVARCHAR](50) NULL,
        [TransactionId] [SMALLINT] NULL,
        [GeneralCeiling] [MONEY] NULL,
        [SpecialistCeiling] [MONEY] NULL,
        [PHDCeiling] [MONEY] NULL,
        [Message] [NVARCHAR](MAX) NULL,
        [Percent] [SMALLINT] NULL,
        [IsActive] [BIT] NULL
            DEFAULT (1),
        CONSTRAINT [PK_SupplementaryInsurance]
            PRIMARY KEY CLUSTERED ([Code] ASC)
            WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON,
                  ALLOW_PAGE_LOCKS = ON
                 ) ON [PRIMARY],
        CONSTRAINT [IX_SupplementaryInsurance]
            UNIQUE NONCLUSTERED ([Name] ASC)
    ) ON [PRIMARY];

END;