7pM9AByX

1USE [HelpDeskDB]
2GO
3
4IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Calls_Calls]') AND parent_object_id = OBJECT_ID(N'[dbo].[Calls]'))
5ALTER TABLE [dbo].[Calls] DROP CONSTRAINT [FK_Calls_Calls]
6GO
7
8IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Calls_Employees]') AND parent_object_id = OBJECT_ID(N'[dbo].[Calls]'))
9ALTER TABLE [dbo].[Calls] DROP CONSTRAINT [FK_Calls_Employees]
10GO
11
12IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Calls_Employees1]') AND parent_object_id = OBJECT_ID(N'[dbo].[Calls]'))
13ALTER TABLE [dbo].[Calls] DROP CONSTRAINT [FK_Calls_Employees1]
14GO
15
16IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Calls_Problems]') AND parent_object_id = OBJECT_ID(N'[dbo].[Calls]'))
17ALTER TABLE [dbo].[Calls] DROP CONSTRAINT [FK_Calls_Problems]
18GO
19
20USE [HelpDeskDB]
21GO
22
23/****** Object:  Table [dbo].[Calls]    Script Date: 11/01/2011 12:41:15 ******/
24IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Calls]') AND type in (N'U'))
25DROP TABLE [dbo].[Calls]
26GO
27
28USE [HelpDeskDB]
29GO
30
31/****** Object:  Table [dbo].[Calls]    Script Date: 11/01/2011 12:41:16 ******/
32SET ANSI_NULLS ON
33GO
34
35SET QUOTED_IDENTIFIER ON
36GO
37
38CREATE TABLE [dbo].[Calls](
39	[CallID] [int] IDENTITY(1,1) NOT NULL,
40	[EmployeeID] [int] NOT NULL,
41	[ProblemID] [int] NOT NULL,
42	[TechID] [int] NOT NULL,
43	[DateOpened] [smalldatetime] NOT NULL,
44	[DateClosed] [smalldatetime] NULL,
45	[OpenStatus] [bit] NULL,
46	[Notes] [image] NULL,
47 CONSTRAINT [PK_Calls] PRIMARY KEY CLUSTERED 
48(
49	[CallID] ASC
50)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
51) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
52
53GO
54
55ALTER TABLE [dbo].[Calls]  WITH CHECK ADD  CONSTRAINT [FK_Calls_Calls] FOREIGN KEY([CallID])
56REFERENCES [dbo].[Calls] ([CallID])
57GO
58
59ALTER TABLE [dbo].[Calls] CHECK CONSTRAINT [FK_Calls_Calls]
60GO
61
62ALTER TABLE [dbo].[Calls]  WITH CHECK ADD  CONSTRAINT [FK_Calls_Employees] FOREIGN KEY([EmployeeID])
63REFERENCES [dbo].[Employees] ([EmployeeID])
64GO
65
66ALTER TABLE [dbo].[Calls] CHECK CONSTRAINT [FK_Calls_Employees]
67GO
68
69ALTER TABLE [dbo].[Calls]  WITH CHECK ADD  CONSTRAINT [FK_Calls_Employees1] FOREIGN KEY([TechID])
70REFERENCES [dbo].[Employees] ([EmployeeID])
71GO
72
73ALTER TABLE [dbo].[Calls] CHECK CONSTRAINT [FK_Calls_Employees1]
74GO
75
76ALTER TABLE [dbo].[Calls]  WITH CHECK ADD  CONSTRAINT [FK_Calls_Problems] FOREIGN KEY([ProblemID])
77REFERENCES [dbo].[Problems] ([ProblemID])
78GO
79
80ALTER TABLE [dbo].[Calls] CHECK CONSTRAINT [FK_Calls_Problems]
81GO