SQL
USE [PrintMonitor]
GO
/****** Object:  Table [dbo].[Print Job Paragraphs]    Script Date: 10/15/2008 21:31:28 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Print Job Paragraphs](
	[Printer Id] [numeric](18, 0) NOT NULL,
	[Printer Reboot Count] [int] NOT NULL CONSTRAINT [DF_Print Job Paragraphs_Printer Reboot Count]  DEFAULT ((0)),
	[Job Id] [int] NOT NULL,
	[Submitted] [datetime] NOT NULL,
	[Page Number] [int] NOT NULL,
	[Pararaph Number] [int] NOT NULL,
	[Text] [varchar](2000) NOT NULL,
 CONSTRAINT [PK_Print Job Paragraphs] PRIMARY KEY CLUSTERED 
(
	[Printer Id] ASC,
	[Printer Reboot Count] ASC,
	[Job Id] ASC,
	[Submitted] ASC,
	[Page Number] ASC,
	[Pararaph Number] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING ON

Last edited Oct 15, 2008 at 8:31 PM by Merrion, version 1

Comments

No comments yet.