USE [ToolTracDukeOconee1] GO /****** Object: Table [dbo].[ActivityLog] Script Date: 10/20/2021 10:52:14 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[ActivityLog]( [EntryID] [int] IDENTITY(1,1) NOT NULL, [StationID] [nvarchar](50) NOT NULL, [Zone] [nvarchar](50) NOT NULL, [TimeStamp] [datetime] NOT NULL, [ActionCode] [char](1) NOT NULL, [EmployeeID] [nvarchar](50) NULL, [FirstName] [nvarchar](50) NULL, [LastName] [nvarchar](50) NULL, [WorkGroup] [nvarchar](50) NULL, [Disposition] [int] NULL, [ToolID] [nvarchar](50) NOT NULL, [TagID] [nvarchar](50) NOT NULL, [Remarks] [nvarchar](250) NULL, [Inspected] [tinyint] NULL, [Lanyard] [tinyint] NULL, [Quantity] [int] NULL, [DateIn] [datetime] NULL, [DateOut] [datetime] NULL, [Contaminated] [tinyint] NULL, [MonitorID] [nvarchar](50) NULL, [MonitorNameFirst] [nvarchar](50) NULL, [MonitorNameLast] [nvarchar](50) NULL, CONSTRAINT [PK_ActivityLog1] PRIMARY KEY CLUSTERED ( [EntryID] 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 /****** Object: Table [dbo].[Employees] Script Date: 10/20/2021 10:52:14 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Employees]( [EmployeeID] [varchar](250) NOT NULL, [LastName] [nvarchar](50) NOT NULL, [FirstName] [nvarchar](50) NOT NULL, [TagID] [nvarchar](250) NULL, [PhotoBLOB] [varchar](max) NULL, [EmployeeSecurity] [int] NULL, [Passphrase] [nvarchar](250) NULL, CONSTRAINT [PK_Employees] PRIMARY KEY CLUSTERED ( [EmployeeID] 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 /****** Object: Table [dbo].[PhotoInfo] Script Date: 10/20/2021 10:52:14 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[PhotoInfo]( [PhotoID] [int] IDENTITY(1,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 )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[Remarks] Script Date: 10/20/2021 10:52:14 AM ******/ 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].[Tools] Script Date: 10/20/2021 10:52:14 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Tools]( [_ID] [int] IDENTITY(1,1) NOT NULL, [ToolID] [nvarchar](50) NOT NULL, [TagID] [nvarchar](50) NULL, [Description] [nvarchar](50) NOT NULL, [SerialNumber] [nvarchar](50) NULL, [Status] [nvarchar](50) NULL, [CurrentZone] [nvarchar](50) NULL, [CurrentWorkGroup] [nvarchar](50) NULL, [CurrentEmployeeName] [nvarchar](100) NULL, [Quantity] [int] NULL, [CurrentEmployeeID] [nvarchar](50) NULL, [LastActivityDateTime] [datetime] NULL, [Inspected] [tinyint] NULL, [Lanyard] [tinyint] NULL, [CatID] [nvarchar](50) NULL, [MFRName] [nvarchar](50) NULL, [MFRPart] [nvarchar](50) NULL, [LastCalDate] [datetime] NULL, [CalDueDate] [datetime] NULL, [UTCNumber] [nvarchar](50) NULL, [InServiceDate] [datetime] NULL, [OutServiceDate] [datetime] NULL, [MaxComRating] [nvarchar](50) NULL, [MaxComCategory] [nvarchar](50) NULL, [SAMM_ID] [nvarchar](50) NULL, [SAMM_Status] [nvarchar](50) NULL, [ShelfLife] [nvarchar](50) NULL, [RecordLastUpdated] [datetime] NULL, [ExpectedReturnDate] [datetime] NULL, [Disposition] [tinyint] NULL, [Contaminated] [tinyint] NULL, [CurrentFMEMonitorID] [nvarchar](50) NULL, [CurrentFMEMonitorName] [nvarchar](100) NULL, [Remarks] [nvarchar](1000) NULL, CONSTRAINT [PK_Tools] PRIMARY KEY CLUSTERED ( [ToolID] 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 /****** Object: Table [dbo].[UserActivity] Script Date: 10/20/2021 10:52:14 AM ******/ 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](10) NOT NULL, [TimeStamp] [datetime] NOT NULL, [Zone] [varchar](50) NULL, [WorkGroup] [varchar](50) NULL ) ON [PRIMARY] GO /****** Object: Table [dbo].[WorkGroups] Script Date: 10/20/2021 10:52:14 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[WorkGroups]( [WorkGroup] [nvarchar](50) NOT NULL ) ON [PRIMARY] GO /****** Object: Table [dbo].[Zones] Script Date: 10/20/2021 10:52:14 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Zones]( [Zone] [nvarchar](50) NOT NULL ) ON [PRIMARY] GO ALTER TABLE [dbo].[Zones] ADD CONSTRAINT [DF_Zones_Zone] DEFAULT ((1)) FOR [Zone] GO /****** Object: StoredProcedure [dbo].[BackUpDB] Script Date: 10/20/2021 10:52:14 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO -- ============================================= CREATE PROCEDURE [dbo].[BackUpDB] -- Add the parameters for the stored procedure here @FilePath varchar(200) AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; BACKUP DATABASE ToolTrac to disk = @filepath END GO