State Machine Complier And Asp.net

��USE [CarAutomation]

GO

/****** Object:  Table [dbo].[StateAuditLog]    Script Date: 10/20/2008 18:57:26 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[StateAuditLog](

	[Audit_Log_ID] [bigint] IDENTITY(1,1) NOT NULL,

	[Car_ID] [bigint] NOT NULL,

	[State_ID] [bigint] NOT NULL,

	[Remarks] [varchar](max) NOT NULL,

	[Last_Updated_By] [bigint] NOT NULL,

	[Last_Updated_Date] [datetime] NOT NULL,

 CONSTRAINT [PK_StateAuditLog] PRIMARY KEY CLUSTERED 

(

	[Audit_Log_ID] 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 OFF

GO

ALTER TABLE [dbo].[StateAuditLog]  WITH CHECK ADD  CONSTRAINT [FK_StateAuditLog_Car] FOREIGN KEY([Car_ID])

REFERENCES [dbo].[Car] ([Car_ID])

GO

ALTER TABLE [dbo].[StateAuditLog] CHECK CONSTRAINT [FK_StateAuditLog_Car]