USE [ToolSaver] GO /****** Object: Table [dbo].[PhotoInfo] Script Date: 02/17/2010 11:39:19 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[PhotoInfo]( [PhotoID] [int] IDENTITY(10000,1) NOT NULL, [ToolID] [nvarchar](50) NOT NULL, [PhotoLocation] [nvarchar](200) NOT NULL, [FileName] [nvarchar](50) NOT NULL, CONSTRAINT [PK_PhotoInfo] PRIMARY KEY CLUSTERED ( [PhotoID] ASC ) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[FME_Activity] Script Date: 02/17/2010 11:39:17 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[FME_Activity]( [EntryID] [int] IDENTITY(1,1) NOT NULL, [CartID] [nvarchar](20) NOT NULL, [Zone] [nvarchar](20) NOT NULL, [Timestamp] [datetime] NOT NULL, [ActionCode] [char](1) NOT NULL, [FirstName] [varchar](50) NULL, [WorkGroup] [nvarchar](20) NOT NULL, [Disposition] [int] NOT NULL, [ToolID] [varchar](50) NOT NULL, [Remarks] [nvarchar](250) NULL, [TagID] [nvarchar](128) NOT NULL, [Inspected] [tinyint] NULL CONSTRAINT [DF_FME_Activity_Inspected] DEFAULT ((0)), [Lanyard] [tinyint] NULL CONSTRAINT [DF_FME_Activity_Lanyard] DEFAULT ((0)), [Quantity] [int] NULL CONSTRAINT [DF_FME_Activity_Quantity] DEFAULT ((1)), [DateIN] [datetime] NULL, [DateOUT] [datetime] NULL, [LastName] [varchar](50) NULL, CONSTRAINT [PK_FME_Activity] PRIMARY KEY CLUSTERED ( [EntryID] ASC ) ON [PRIMARY] ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[Remarks] Script Date: 02/17/2010 11:39:20 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Remarks]( [RemarkText] [nvarchar](250) NOT NULL ) ON [PRIMARY] GO /****** Object: Table [dbo].[UserActivity] Script Date: 02/17/2010 11:39:22 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[UserActivity]( [UserName] [nvarchar](100) NOT NULL, [UserID] [nvarchar](50) NULL, [ActionCode] [nvarchar](1) NOT NULL, [TimeStamp] [datetime] NOT NULL ) ON [PRIMARY] GO