ÿþ/****** Object:  Table [dba].[TRUNCATE_AUDIT]    Script Date: 02/22/2010 14:21:57 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dba].[TRUNCATE_AUDIT](

	[Truncate_Audit_Id] [int] IDENTITY(1,1) NOT NULL,

	[HostName] [varchar](30) NOT NULL CONSTRAINT [DF__TRUNCATE___HostN__440B1D61]  DEFAULT (host_name()),

	[UserName] [varchar](30) NOT NULL,

	[DATETIME] [datetime] NOT NULL CONSTRAINT [DF__TRUNCATE___DATET__44FF419A]  DEFAULT (getdate()),

	[TABLE_NAME] [varchar](100) NOT NULL,

	[TABLE_OWNER] [varchar](30) NOT NULL,

	[SUCCESS] [int] NOT NULL CONSTRAINT [DF__TRUNCATE___SUCCE__45F365D3]  DEFAULT ((-1)),

 CONSTRAINT [PK__TRUNCATE_AUDIT__4316F928] PRIMARY KEY CLUSTERED 

(

	[Truncate_Audit_Id] ASC

)WITH (PAD_INDEX  = ON, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 80) ON [PRIMARY]

) ON [PRIMARY]



GO

SET ANSI_PADDING OFF



/****** Object:  Table [dba].[TRUNCATE_FAIL]    Script Date: 02/22/2010 14:22:04 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dba].[TRUNCATE_FAIL](

	[Truncate_Fail_ID] [int] IDENTITY(1,1) NOT NULL,

	[HostName] [varchar](30) NOT NULL CONSTRAINT [DF_TRUNCATE_FAIL_Hostname]  DEFAULT (host_name()),

	[UserName] [varchar](30) NOT NULL,

	[DATETIME] [datetime] NOT NULL CONSTRAINT [DF_TRUNCATE_FAIL_DATETIME]  DEFAULT (getdate()),

	[TABLE_NAME_input] [varchar](100) NOT NULL,

	[table_owner] [varchar](30) NOT NULL,

 CONSTRAINT [PK_TRUNCATE_FAIL] PRIMARY KEY CLUSTERED 

(

	[Truncate_Fail_ID] ASC

)WITH (PAD_INDEX  = ON, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 80) ON [PRIMARY]

) ON [PRIMARY]



GO

SET ANSI_PADDING OFF

/****** Object:  Table [dba].[TRUNCATE_LIST]    Script Date: 02/22/2010 14:22:09 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dba].[TRUNCATE_LIST](

	[List_Id] [int] IDENTITY(1,1) NOT NULL,

	[List_Table_Name] [varchar](256) NOT NULL,

 CONSTRAINT [PK_TRUNCATE_LIST] PRIMARY KEY CLUSTERED 

(

	[List_Table_Name] ASC

)WITH (PAD_INDEX  = ON, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 80) ON [PRIMARY]

) ON [PRIMARY]



GO

SET ANSI_PADDING OFF