SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tblWorkType]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[tblWorkType]( [worktypeid] [int] NULL, [Description] [varchar](100) NULL, [Fixed] [bit] NULL, [Rate] [int] NULL, [isoutwork] [bit] NULL ) ON [PRIMARY] END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[lupOrgCodes]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[lupOrgCodes]( [orgcode] [varchar](100) NULL ) ON [PRIMARY] END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tblCategory]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[tblCategory]( [test] [text] NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tblClient]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[tblClient]( [temp_field_to_be_removed] [text] NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tblhistory]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[tblhistory]( [temp_field_to_be_removed] [text] NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tblTime]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[tblTime]( [temp_field_to_be_removed] [text] NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[lupPriority]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[lupPriority]( [PriorityID] [int] NULL, [Name] [varchar](100) NULL ) ON [PRIMARY] END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[lupStatus]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[lupStatus]( [StatusID] [int] NULL, [Name] [varchar](100) NULL ) ON [PRIMARY] END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tblprojectstaff]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[tblprojectstaff]( [projectstaffid] [smallint] NOT NULL, [staffid] [smallint] NULL, [projectid] [smallint] NULL, [title] [nchar](50) NULL, [expense] [money] NULL, [budget] [money] NULL ) ON [PRIMARY] END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tblTaskResources]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[tblTaskResources]( [taskresourceid] [smallint] NULL, [resourceid] [smallint] NULL, [projectid] [smallint] NULL, [taskid] [smallint] NULL, [hours] [smallint] NULL, [description] [nvarchar](50) NULL ) ON [PRIMARY] END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tblLocked]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[tblLocked]( [tablename] [nchar](30) NOT NULL, [fieldname] [nchar](30) NOT NULL, [fieldid] [smallint] NOT NULL, [expiry] [datetime] NOT NULL, [staffid] [smallint] NOT NULL ) ON [PRIMARY] END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tblIssues1]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[tblIssues1]( [IssueNo] [smallint] NULL, [ProjectID] [smallint] NULL, [Status] [smallint] NULL, [RaisedByID] [smallint] NULL, [Date_Raised] [nchar](15) NULL, [Issue_Description] [nchar](500) NULL, [Impact_Activity] [nchar](500) NULL, [Date_Resolved] [nchar](15) NULL, [Category] [varchar](100) NULL, [Priorityid] [smallint] NULL, [Call_No] [varchar](100) NULL, [UAT_No] [varchar](100) NULL, [Owner] [smallint] NULL, [DateDue] [nchar](15) NULL, [Progress] [smallint] NULL ) ON [PRIMARY] END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tbltasks1]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[tbltasks1]( [description] [varchar](4000) NULL, [projectid] [int] NULL, [startdate] [nchar](15) NULL, [enddate] [nchar](15) NULL, [taskid] [int] NULL, [taskstatus] [int] NULL, [status] [int] NULL, [priorityid] [int] NULL, [category] [varchar](100) NULL ) ON [PRIMARY] END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tblFiles]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[tblFiles]( [filename] [nchar](500) NOT NULL, [projectid] [smallint] NULL ) ON [PRIMARY] END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tblAttach]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[tblAttach]( [filename] [nchar](200) NULL, [projectid] [smallint] NULL, [tablename] [nchar](20) NULL, [field] [nchar](20) NULL, [fieldid] [smallint] NULL ) ON [PRIMARY] END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tblcrs1]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[tblcrs1]( [crid] [int] NULL, [projectid] [int] NULL, [request-date] [nchar](10) NULL, [request-staffid] [int] NULL, [priorityid] [int] NULL, [scope] [bit] NULL, [description] [nchar](200) NULL, [justify] [nchar](200) NULL, [impact-of-not] [nchar](200) NULL, [impactcost] [nchar](200) NULL, [impactschedule] [nchar](200) NULL, [impactconfig] [nchar](200) NULL, [alternatives] [nchar](200) NULL, [recommend] [nchar](200) NULL, [decisionid] [int] NULL, [decisiondate] [nchar](10) NULL, [decision-staffid] [int] NULL, [status] [int] NULL, [category] [varchar](100) NULL ) ON [PRIMARY] END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tblreleases1]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[tblreleases1]( [ReleaseID] [int] NULL, [ProjectID] [int] NULL, [ReleaseName] [nchar](100) NULL, [ReleaseDate] [nchar](100) NULL, [Description] [nchar](100) NULL, [status] [int] NULL, [staffid] [int] NULL, [progress] [int] NULL, [priorityid] [int] NULL, [crid] [int] NULL, [category] [nchar](20) NULL ) ON [PRIMARY] END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tblreleases]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[tblreleases]( [ReleaseID] [int] NULL, [ProjectID] [int] NULL, [ReleaseName] [nchar](100) NULL, [ReleaseDate] [nchar](100) NULL, [Description] [nchar](100) NULL, [status] [int] NULL, [staffid] [int] NULL, [progress] [int] NULL, [priorityid] [int] NULL, [crid] [int] NULL, [category] [nchar](20) NULL ) ON [PRIMARY] END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tblcrs]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[tblcrs]( [crid] [int] NULL, [projectid] [int] NULL, [request-date] [nchar](10) NULL, [request-staffid] [int] NULL, [priorityid] [int] NULL, [scope] [bit] NULL, [description] [nchar](200) NULL, [justify] [nchar](200) NULL, [impact-of-not] [nchar](200) NULL, [impactcost] [nchar](200) NULL, [impactschedule] [nchar](200) NULL, [impactconfig] [nchar](200) NULL, [alternatives] [nchar](200) NULL, [recommend] [nchar](200) NULL, [decisionid] [int] NULL, [decisiondate] [nchar](10) NULL, [decision-staffid] [int] NULL, [status] [int] NULL, [category] [varchar](100) NULL ) ON [PRIMARY] END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tblIssues]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[tblIssues]( [IssueNo] [smallint] NULL, [ProjectID] [smallint] NULL, [Status] [smallint] NULL, [RaisedByID] [smallint] NULL, [Date_Raised] [nchar](15) NULL, [Issue_Description] [nchar](500) NULL, [Impact_Activity] [nchar](500) NULL, [Date_Resolved] [nchar](15) NULL, [Category] [varchar](100) NULL, [Priorityid] [smallint] NULL, [Call_No] [varchar](100) NULL, [UAT_No] [varchar](100) NULL, [Owner] [smallint] NULL, [DateDue] [nchar](15) NULL, [Progress] [smallint] NULL ) ON [PRIMARY] END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tbltasks]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[tbltasks]( [description] [varchar](4000) NULL, [projectid] [int] NULL, [startdate] [nchar](15) NULL, [enddate] [nchar](15) NULL, [taskid] [int] NULL, [taskstatus] [int] NULL, [status] [int] NULL, [priorityid] [int] NULL, [category] [varchar](100) NULL ) ON [PRIMARY] END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tblIssues2]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[tblIssues2]( [IssueNo] [smallint] NULL, [ProjectID] [smallint] NULL, [Status] [smallint] NULL, [RaisedByID] [smallint] NULL, [Date_Raised] [nchar](15) NULL, [Issue_Description] [nchar](500) NULL, [Impact_Activity] [nchar](500) NULL, [Date_Resolved] [nchar](15) NULL, [Category] [varchar](100) NULL, [Priorityid] [smallint] NULL, [Call_No] [varchar](100) NULL, [UAT_No] [varchar](100) NULL, [Owner] [smallint] NULL, [DateDue] [nchar](15) NULL, [Progress] [smallint] NULL ) ON [PRIMARY] END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tblcrs2]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[tblcrs2]( [crid] [int] NULL, [projectid] [int] NULL, [request-date] [nchar](10) NULL, [request-staffid] [int] NULL, [priorityid] [int] NULL, [scope] [bit] NULL, [description] [nchar](200) NULL, [justify] [nchar](200) NULL, [impact-of-not] [nchar](200) NULL, [impactcost] [nchar](200) NULL, [impactschedule] [nchar](200) NULL, [impactconfig] [nchar](200) NULL, [alternatives] [nchar](200) NULL, [recommend] [nchar](200) NULL, [decisionid] [int] NULL, [decisiondate] [nchar](10) NULL, [decision-staffid] [int] NULL, [status] [int] NULL, [category] [varchar](100) NULL ) ON [PRIMARY] END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tblreleases2]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[tblreleases2]( [ReleaseID] [int] NULL, [ProjectID] [int] NULL, [ReleaseName] [nchar](100) NULL, [ReleaseDate] [nchar](100) NULL, [Description] [nchar](100) NULL, [status] [int] NULL, [staffid] [int] NULL, [progress] [int] NULL, [priorityid] [int] NULL, [crid] [int] NULL, [category] [nchar](20) NULL ) ON [PRIMARY] END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tbltasks2]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[tbltasks2]( [description] [varchar](4000) NULL, [projectid] [int] NULL, [startdate] [nchar](15) NULL, [enddate] [nchar](15) NULL, [taskid] [int] NULL, [taskstatus] [int] NULL, [status] [int] NULL, [priorityid] [int] NULL, [category] [varchar](100) NULL ) ON [PRIMARY] END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tblOrg]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[tblOrg]( [orgid] [int] NULL, [Name] [varchar](100) NULL, [Address1] [varchar](100) NULL, [Address2] [varchar](100) NULL, [Address3] [varchar](100) NULL, [City] [varchar](100) NULL, [Country] [varchar](100) NULL, [Email] [varchar](100) NULL, [Phone] [varchar](100) NULL, [Fax] [varchar](100) NULL, [Website] [varchar](100) NULL ) ON [PRIMARY] END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tblProjects]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[tblProjects]( [ProjectID] [int] NULL, [Name] [varchar](100) NULL, [Start] [text] NULL, [Deadline] [text] NULL, [orgid] [int] NULL, [Contact] [varchar](100) NULL, [budget] [text] NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tblReleaseStatus]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[tblReleaseStatus]( [name] [varchar](100) NULL, [description] [text] NULL, [statusid] [int] NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tblStaff]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[tblStaff]( [StaffID] [int] NULL, [Initial] [varchar](100) NULL, [Name] [varchar](100) NULL, [orgid] [int] NULL, [Phone2] [varchar](100) NULL, [Email] [varchar](100) NULL, [username] [varchar](100) NULL, [password] [varchar](100) NULL, [isadmin] [bit] NULL, [isglobaladmin] [bit] NULL, [First] [varchar](100) NULL, [Last] [varchar](100) NULL, [position] [varchar](100) NULL, [department] [varchar](100) NULL, [info] [text] NULL, [address1] [varchar](100) NULL, [address2] [varchar](100) NULL, [address3] [varchar](100) NULL, [town] [varchar](100) NULL, [Ext] [varchar](100) NULL, [Fax] [varchar](100) NULL, [inactive] [bit] NULL, [Phone] [varchar](100) NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] END