CREATE TABLE [dbo].[DashboardDevicesAndPages]
(
[AccountID] [int] NOT NULL,
[ManagedDevices] [bigint] NOT NULL CONSTRAINT [DF_DashboardDevicesAndPages_ManagedDevices] DEFAULT ((0)),
[NonManagedDevices] [bigint] NOT NULL CONSTRAINT [DF_DashboardDevicesAndPages_NonManagedDevices] DEFAULT ((0)),
[ManagedPages] [bigint] NOT NULL CONSTRAINT [DF_DashboardDevicesAndPages_ManagedPages] DEFAULT ((0)),
[NonManagedPages] [bigint] NOT NULL CONSTRAINT [DF_DashboardDevicesAndPages_NonManagedPages] DEFAULT ((0)),
[MonoDevices] [bigint] NOT NULL CONSTRAINT [DF_DashboardDevicesAndPages_MonoDevices] DEFAULT ((0)),
[ColorDevices] [bigint] NOT NULL CONSTRAINT [DF_DashboardDevicesAndPages_ColorDevices] DEFAULT ((0)),
[MonoPages] [bigint] NOT NULL CONSTRAINT [DF_DashboardDevicesAndPages_MonoPages] DEFAULT ((0)),
[ColorPages] [bigint] NOT NULL CONSTRAINT [DF_DashboardDevicesAndPages_ColorPages] DEFAULT ((0)),
[NetworkDevices] [bigint] NOT NULL CONSTRAINT [DF_DashboardDevicesAndPages_NetworkDevices] DEFAULT ((0)),
[LocalDevices] [bigint] NOT NULL CONSTRAINT [DF_DashboardDevicesAndPages_LocalDevices] DEFAULT ((0)),
[NetworkPages] [bigint] NOT NULL CONSTRAINT [DF_DashboardDevicesAndPages_NetworkPages] DEFAULT ((0)),
[LocalPages] [bigint] NOT NULL CONSTRAINT [DF_DashboardDevicesAndPages_LocalPages] DEFAULT ((0))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[DashboardDevicesAndPages] ADD CONSTRAINT [PK_DashboardDevicesAndPages_AccountID] PRIMARY KEY CLUSTERED ([AccountID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[DashboardDevicesAndPages] ADD CONSTRAINT [FK_DashboardDevicesAndPages_AccountID_Account_AccountID] FOREIGN KEY ([AccountID]) REFERENCES [dbo].[Account] ([AccountID]) ON DELETE CASCADE ON UPDATE CASCADE
GO