CREATE TABLE [dbo].[Searches] ( [SearchIntID] [nvarchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [SearchID] [nvarchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [Description] [nvarchar] (252) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [Criteria] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [Resources] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [Archived] [bit] NOT NULL , [Categories] [nvarchar] (252) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [Groups] [nvarchar] (252) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [Owners] [nvarchar] (252) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [UserIDs] [nvarchar] (252) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [Private] [bit] NOT NULL , [CreateDate] [datetime] NULL , [EditDate] [datetime] NULL , [MergeDate] [datetime] NULL , [UserField1] [nvarchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [UserField2] [nvarchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [UserField3] [nvarchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [UserField4] [nvarchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [UserField5] [nvarchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [UserField6] [nvarchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [UserField7] [nvarchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [UserField8] [nvarchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [UserField9] [nvarchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [UserField10] [nvarchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [Notes] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [Field1] [nvarchar] (240) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [Field2] [nvarchar] (240) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [Field3] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO CREATE TABLE [dbo].[SearchResults] ( [SResultsIntID] [nvarchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [ConsultantID] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [Title] [nvarchar] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FirstName] [nvarchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [MiddleName] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [LastName] [nvarchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [Suffix] [nvarchar] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [NickName] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [DisplayName] [nvarchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [Available] [bit] NOT NULL , [CompanyName] [nvarchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [AvailabilityDate] [datetime] NULL , [AvailabilityNotice] [nvarchar] (24) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [JobTitle] [nvarchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [PrimarySkills] [nvarchar] (252) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [SecondarySkills] [nvarchar] (252) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [OtherSkills] [nvarchar] (252) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [TotalExp] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [USExp] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [CommSkills] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [Rate] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [Relocation] [nvarchar] (24) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [ResumeDir] [nvarchar] (120) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [ResumeFile] [nvarchar] (120) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [ModifiedResumeDir] [nvarchar] (120) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [ModifiedResumeFile] [nvarchar] (120) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [ResumeWebPath] [nvarchar] (120) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [Summary] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [AdditionalInfo] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [ReferredBy] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [XMLResume] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [SSN] [nvarchar] (11) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [VisaStatus] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [VisaExpiryDate] [datetime] NULL , [Address1] [nvarchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [Address2] [nvarchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [Address3] [nvarchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [City] [nvarchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [State] [nvarchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [ZipCode] [nvarchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [Country] [nvarchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [HomePhone] [nvarchar] (24) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [WorkPhone] [nvarchar] (24) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [MobilePhone] [nvarchar] (24) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [Fax] [nvarchar] (24) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [EMail1] [nvarchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [EMail2] [nvarchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [Salary] [money] NULL , [SalaryReviewDate] [datetime] NULL , [BonusAmount] [money] NULL , [BonusAmountDate] [datetime] NULL , [DOE] [datetime] NULL , [DOT] [datetime] NULL , [DOB] [datetime] NULL , [DOM] [datetime] NULL , [SpouseName] [nvarchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [EmergencyContactName] [nvarchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [EmergencyPhone] [nvarchar] (24) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [Notes] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [Archived] [bit] NOT NULL , [SendInHotList] [bit] NOT NULL , [Employee] [bit] NOT NULL , [JobType] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [Categories] [nvarchar] (252) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [Groups] [nvarchar] (252) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [Owners] [nvarchar] (252) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [EmployeeNumber] [nvarchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [OnHold] [bit] NOT NULL , [OnHoldTill] [datetime] NULL , [VacationDays] [smallint] NULL , [SickDays] [smallint] NULL , [TableHolidays] [bit] NOT NULL , [FloatHolidays] [smallint] NULL , [LinkToIntID] [nvarchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [UserIDs] [nvarchar] (252) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [Private] [bit] NOT NULL , [CreateDate] [datetime] NULL , [EditDate] [datetime] NULL , [MergeDate] [datetime] NULL , [UserField1] [nvarchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [UserField2] [nvarchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [UserField3] [nvarchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [UserField4] [nvarchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [UserField5] [nvarchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [UserField6] [nvarchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [UserField7] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [UserField8] [nvarchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [UserField9] [nvarchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [UserField10] [nvarchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [Field1] [nvarchar] (240) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [Field2] [nvarchar] (240) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [Field3] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [uuResumeText] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [SearchID] [nvarchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [URL] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [ResumeID] [nvarchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [ResourceName] [nvarchar] (240) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [ResourceID] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [QuickParse] [bit] NULL , [Score] [int] NULL , [Status] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [ConsIntID] [nvarchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [uuCurrentCTC] [real] NULL CONSTRAINT [DF_SearchResults_uuCurrentCTC] DEFAULT ((0)), [uuCurrentLocation] [nvarchar](80) NULL CONSTRAINT [DF_SearchResults_uuCurrentLocation] DEFAULT (''), [uuPassport] [nvarchar](40) NULL CONSTRAINT [DF_SearchResults_uuPassport] DEFAULT (''), [uuGender] [nvarchar](10) NULL CONSTRAINT [DF_SearchResults_uuGender] DEFAULT (''), [uuFatherName] [nvarchar](50) NULL CONSTRAINT [DF_SearchResults_uuFatherName] DEFAULT (''), [uuPrevCompanyName1] [nvarchar](80) NULL CONSTRAINT [DF_SearchResults_uuPrevCompanyName1] DEFAULT (''), [uuPrevJobTitle1] [nvarchar](60) NULL CONSTRAINT [DF_SearchResults_uuPrevJobTitle1] DEFAULT (''), [uuPrevStartDate1] [datetime] NULL, [uuPrevEndDate1] [datetime] NULL, [uuPrevCompanyName2] [nvarchar](80) NULL CONSTRAINT [DF_SearchResults_uuPrevCompanyName2] DEFAULT (''), [uuPrevJobTitle2] [nvarchar](60) NULL CONSTRAINT [DF_SearchResults_uuPrevJobTitle2] DEFAULT (''), [uuPrevStartDate2] [datetime] NULL, [uuPrevEndDate2] [datetime] NULL, [uuUGInstitute] [nvarchar](80) NULL CONSTRAINT [DF_SearchResults_uuUGInstitute] DEFAULT (''), [uuPGInstitute] [nvarchar](80) NULL CONSTRAINT [DF_SearchResults_uuPGInstitute] DEFAULT (''), [uuPPGInstitute] [nvarchar](80) NULL CONSTRAINT [DF_SearchResults_uuPPGInstitute] DEFAULT (''), [uuUGCourse] [nvarchar](40) NULL CONSTRAINT [DF_SearchResults_uuUGCourse] DEFAULT (''), [uuPGCourse] [nvarchar](40) NULL CONSTRAINT [DF_SearchResults_uuPGCourse] DEFAULT (''), [uuPPGCourse] [nvarchar](40) NULL CONSTRAINT [DF_SearchResults_uuPPGCourse] DEFAULT (''), [uuUGYearOfPass] [int] NULL, [uuPGYearOfPass] [int] NULL, [uuPPGYearOfPass] [int] NULL, [uuUGSpecialisation] [nvarchar](40) NULL CONSTRAINT [DF_SearchResults_uuUGSpecialisation] DEFAULT (''), [uuPGSpecialisation] [nvarchar](40) NULL CONSTRAINT [DF_SearchResults_uuPGSpecialisation] DEFAULT (''), [uuPPGSpecialisation] [nvarchar](40) NULL CONSTRAINT [DF_SearchResults_uuPPGSpecialisation] DEFAULT (''), [uuUGPercentage] [nvarchar](10) NULL CONSTRAINT [DF_SearchResults_uuUGPercentage] DEFAULT (''), [uuPGPercentage] [nvarchar](10) NULL CONSTRAINT [DF_SearchResults_uuPGPercentage] DEFAULT (''), [uuPPGPercentage] [nvarchar](10) NULL CONSTRAINT [DF_SearchResults_uuPPGPercentage] DEFAULT (''), [uuMartialStatus] [nvarchar](40) NULL CONSTRAINT [DF_SearchResults_uuMartialStatus] DEFAULT ('') ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO ALTER TABLE [dbo].[Searches] WITH NOCHECK ADD CONSTRAINT [PK_SearchIntID] PRIMARY KEY CLUSTERED ( [SearchIntID] ) ON [PRIMARY] GO ALTER TABLE [dbo].[SearchResults] WITH NOCHECK ADD CONSTRAINT [PK_SearchResults] PRIMARY KEY CLUSTERED ( [SResultsIntID] ) ON [PRIMARY] GO ALTER TABLE [dbo].[Searches] WITH NOCHECK ADD CONSTRAINT [DF_Searches_Archived] DEFAULT (0) FOR [Archived], CONSTRAINT [DF_Searches_Private] DEFAULT (0) FOR [Private] GO ALTER TABLE [dbo].[SearchResults] WITH NOCHECK ADD CONSTRAINT [DF_SearchResults_Available] DEFAULT (0) FOR [Available], CONSTRAINT [DF_SearchResults_Archived] DEFAULT (0) FOR [Archived], CONSTRAINT [DF_SearchResults_SendInHotList] DEFAULT (0) FOR [SendInHotList], CONSTRAINT [DF_SearchResults_Employee] DEFAULT (0) FOR [Employee], CONSTRAINT [DF_SearchResults_OnHold] DEFAULT (0) FOR [OnHold], CONSTRAINT [DF_SearchResults_TableHolidays] DEFAULT (0) FOR [TableHolidays], CONSTRAINT [DF_SearchResults_Private] DEFAULT (0) FOR [Private] GO CREATE INDEX [IX_SearchID] ON [dbo].[Searches]([SearchID]) ON [PRIMARY] GO CREATE INDEX [IX_DisplayName] ON [dbo].[SearchResults]([DisplayName]) ON [PRIMARY] GO CREATE INDEX [IX_EMail1] ON [dbo].[SearchResults]([EMail1]) ON [PRIMARY] GO CREATE INDEX [IX_ResumeID] ON [dbo].[SearchResults]([ResumeID]) ON [PRIMARY] GO CREATE INDEX [IX_SearchID] ON [dbo].[SearchResults]([SearchID]) ON [PRIMARY] GO