/* Run this script on SQL Server 2008 or later. There may be flaws if running on earlier versions of SQL Server. */ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[SystemSettings]') AND type in (N'U')) DROP TABLE [dbo].[SystemSettings] GO CREATE TABLE [dbo].[SystemSettings] ( [Id] [uniqueidentifier] NOT NULL, [Type] [int] NOT NULL, [Value] [nvarchar](4000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, CONSTRAINT [PK_SystemSettings] PRIMARY KEY CLUSTERED ([Id]) ) ON [PRIMARY] GO