USE [FixedAsset]
GO

/****** Object:  Table [dbo].[tblrequester]    Script Date: 09/05/2012 17:13:12 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[tblrequester](
	[fld_TicketNumber] [int] NOT NULL,
	[fld_DateTimeRequest] [varchar](50) NULL,
	[fld_Department] [varchar](50) NULL,
	[fld_RequestNeeded] [text] NULL,
	[fld_RequestedBy] [varchar](50) NULL,
	[fld_AssignedTo] [varchar](255) NULL,
	[fld_PriorityLevel] [varchar](50) NULL,
	[fld_DateTimeStart] [varchar](50) NULL,
	[fld_DateTimeEnd] [varchar](50) NULL,
	[fld_RepairStatus] [varchar](50) NULL,
	[fld_Cost] [float] NULL,
	[fld_RequestTo] [varchar](50) NULL,
	[fld_BudgetingHead] [varchar](50) NULL,
	[fld_Repairman] [varchar](50) NULL,
	[fld_NotedBy] [varchar](50) NULL,
	[fld_CheckedBy] [varchar](50) NULL,
	[fld_WorkDone] [text] NULL,
	[fld_RushReason] [text] NULL,
 CONSTRAINT [PK_tblrequester] PRIMARY KEY CLUSTERED 
(
	[fld_TicketNumber] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO



USE [FixedAsset]
GO

/****** Object:  Table [dbo].[tblcomments]    Script Date: 09/05/2012 17:14:00 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[tblcomments](
	[fld_TicketNumber] [int] NULL,
	[fld_User] [varchar](50) NULL,
	[fld_Comments] [text] NULL,
	[fld_Date] [varchar](50) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO


USE [Password]
GO

/****** Object:  Table [dbo].[tbPasswordWoms]    Script Date: 09/05/2012 17:14:33 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[tbPasswordWoms](
	[EmployeeID] [varchar](50) NULL,
	[Department] [varchar](50) NULL,
	[UserRights] [varchar](50) NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO