/* Microsoft SQL Server - Scripting			*/
/* Server: ACME65					*/
/* Database: ReportDev					*/
/* Creation Date 4/25/00 11:52:40 AM 			*/

/****** Object:  Table dbo.CompanyCredit    Script Date: 4/25/00 11:52:41 AM ******/
if exists (select * from sysobjects where id = object_id('dbo.CompanyCredit') and sysstat & 0xf = 3)
	drop table dbo.CompanyCredit
GO

/****** Object:  Table dbo.CompanyCredit    Script Date: 4/25/00 11:52:41 AM ******/
CREATE TABLE dbo.CompanyCredit (
	CompanyID int NOT NULL ,
	dwCompanyID decimal(18, 2) NOT NULL ,
	CreditStatus int NOT NULL CONSTRAINT DF_CompanyCre_CreditStatu1__19 DEFAULT (1),
	Date datetime NOT NULL CONSTRAINT DF_CompanyCre_Date_2__19 DEFAULT (getdate()),
	CONSTRAINT PK_CompanyCredit_1__19 PRIMARY KEY  CLUSTERED 
	(
		dwCompanyID
	)
)
GO