[dbo].[ca_cic

[dbo].[ca_cic_patch]

(local) > mdb > Tables > dbo.ca_cic_patch

Properties
Columns
Indexes
SQL Script
Uses

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count	0
Created	4:35:54 PM Wednesday, March 24, 2010
Last Modified	4:35:54 PM Wednesday, March 24, 2010

Columns

Name	Data Type	Max Length (Bytes)
uuid	binary(16)	16
status	tinyint	1
type	tinyint	1
when_scheduled	int	4
when_started	int	4
when_completed	int	4
stored_location	nvarchar(1024)	2048

Indexes

	Name	Columns	Unique
	PK_ca_cic_patch_uuid	uuid

SQL Script

CREATE TABLE [dbo].[ca_cic_patch]
(
[uuid] [binary] (16) NOT NULL,
[status] [tinyint] NULL,
[type] [tinyint] NULL,
[when_scheduled] [int] NULL,
[when_started] [int] NULL,
[when_completed] [int] NULL,
[stored_location] [nvarchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ca_cic_patch] ADD CONSTRAINT [PK_ca_cic_patch_uuid] PRIMARY KEY CLUSTERED ([uuid]) ON [PRIMARY]
GO

Uses