ÿþUSE [SharePoint4ArabDB_BCS]

GO

/****** Object:  Table [dbo].[Employees]    Script Date: 08/10/2011 05:17:41 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[Employees](

	[EmployeeID] [int] IDENTITY(1,1) NOT NULL,

	[FullName] [nvarchar](50) NOT NULL,

	[Email] [varchar](50) NOT NULL,

	[Visible] [bit] NOT 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]

GO

SET ANSI_PADDING OFF

GO

SET IDENTITY_INSERT [dbo].[Employees] ON

INSERT [dbo].[Employees] ([EmployeeID], [FullName], [Email], [Visible]) VALUES (1, N'Ismaeel Enjreny', N'ismaeel.enjreny@gmail.com', 1)

INSERT [dbo].[Employees] ([EmployeeID], [FullName], [Email], [Visible]) VALUES (2, N'Abu Homama', N'vcpp81@hotmail.com', 1)

INSERT [dbo].[Employees] ([EmployeeID], [FullName], [Email], [Visible]) VALUES (3, N'Homam Enjreny', N'myson@gmail.com', 1)

SET IDENTITY_INSERT [dbo].[Employees] OFF

/****** Object:  Table [dbo].[EmployeeTasks]    Script Date: 08/10/2011 05:17:41 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[EmployeeTasks](

	[TaskID] [int] IDENTITY(1,1) NOT NULL,

	[EmployeeID] [int] NOT NULL,

	[TaskTitle] [nvarchar](50) NOT NULL,

 CONSTRAINT [PK_EmployeeTasks] PRIMARY KEY CLUSTERED 

(

	[TaskID] 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

SET IDENTITY_INSERT [dbo].[EmployeeTasks] ON

INSERT [dbo].[EmployeeTasks] ([TaskID], [EmployeeID], [TaskTitle]) VALUES (1, 1, N'Read BCS Book')

INSERT [dbo].[EmployeeTasks] ([TaskID], [EmployeeID], [TaskTitle]) VALUES (2, 2, N'Multi Search Service Application')

SET IDENTITY_INSERT [dbo].[EmployeeTasks] OFF

/****** Object:  ForeignKey [FK_EmployeeTasks_Employees]    Script Date: 08/10/2011 05:17:41 ******/

ALTER TABLE [dbo].[EmployeeTasks]  WITH CHECK ADD  CONSTRAINT [FK_EmployeeTasks_Employees] FOREIGN KEY([EmployeeID])

REFERENCES [dbo].[Employees] ([EmployeeID])

GO

ALTER TABLE [dbo].[EmployeeTasks] CHECK CONSTRAINT [FK_EmployeeTasks_Employees]

GO