CREATE TABLE [dbo].[Tools]
(
[toolID] [int] NOT NULL IDENTITY(-1, 1),
[toolName] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[URL] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[suggestion] [int] NULL CONSTRAINT [DF__Tools__suggestio__33D4B598] DEFAULT ((0)),
[imageName] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[displayURL] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[width] [int] NULL,
[height] [int] NULL,
[toolType] [int] NULL CONSTRAINT [DF__Tools__toolType__34C8D9D1] DEFAULT ((0)),
[useViewport] [int] NULL CONSTRAINT [DF__Tools__useViewpo__35BCFE0A] DEFAULT ((0)),
[agentDefault] [int] NULL CONSTRAINT [DF__Tools__agentDefa__36B12243] DEFAULT ((1)),
[isAdmin] [int] NULL CONSTRAINT [DF__Tools__isAdmin__37A5467C] DEFAULT ((0)),
[isSpecial] [int] NULL CONSTRAINT [DF__Tools__isSpecial__38996AB5] DEFAULT ((0))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Tools] ADD CONSTRAINT [pk_tools] PRIMARY KEY CLUSTERED ([toolID]) ON [PRIMARY]
GO
[dbo].[Tools]
