Script DB Clase

USE [DATA]
GO
/****** Object:  Table [dbo].[Empleado]    Script Date: 4/10/2014 5:19:00 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Empleado](
    [id] [INT] NOT NULL,
    [nombre] [VARCHAR](50) NULL,
    [sueldo] [INT] NULL,
    [moroso] [INT] NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Empleado_Ingreso]    Script Date: 4/10/2014 5:19:00 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Empleado_Ingreso](
    [id] [INT] IDENTITY(1,1) NOT NULL,
    [FechaIngreso] [DATE] NULL,
 CONSTRAINT [PK_Empleado_Ingreso] PRIMARY KEY CLUSTERED
(
    [id] 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].[Pagos]    Script Date: 4/10/2014 5:19:00 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Pagos](
    [id_pagos] [INT] IDENTITY(1,1) NOT NULL,
    [fecha_pago] [DATE] NULL,
    [id_empleado] [INT] NULL,
    [Concepto] [VARCHAR](50) NULL,
 CONSTRAINT [PK_Pagos] PRIMARY KEY CLUSTERED
(
    [id_pagos] 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
INSERT [dbo].[Empleado] ([id], [nombre], [sueldo], [moroso]) VALUES (1, N'JOSE', 1000, 0)
GO
INSERT [dbo].[Empleado] ([id], [nombre], [sueldo], [moroso]) VALUES (2, N'PEDRO', 1500, 1)
GO
INSERT [dbo].[Empleado] ([id], [nombre], [sueldo], [moroso]) VALUES (3, N'JUAN', 2000, 0)
GO
INSERT [dbo].[Empleado] ([id], [nombre], [sueldo], [moroso]) VALUES (4, N'MARIA', 1500, 1)
GO
INSERT [dbo].[Empleado] ([id], [nombre], [sueldo], [moroso]) VALUES (5, N'JUANA', 1000, 1)
GO
INSERT [dbo].[Empleado] ([id], [nombre], [sueldo], [moroso]) VALUES (5, N'Manuel', 2800, 0)
GO
SET IDENTITY_INSERT [dbo].[Empleado_Ingreso] ON

GO
INSERT [dbo].[Empleado_Ingreso] ([id], [FechaIngreso]) VALUES (1, CAST(0xF1230B00 AS DATE))
GO
INSERT [dbo].[Empleado_Ingreso] ([id], [FechaIngreso]) VALUES (2, CAST(0x50320B00 AS DATE))
GO
INSERT [dbo].[Empleado_Ingreso] ([id], [FechaIngreso]) VALUES (3, CAST(0x822F0B00 AS DATE))
GO
INSERT [dbo].[Empleado_Ingreso] ([id], [FechaIngreso]) VALUES (4, CAST(0x3F2C0B00 AS DATE))
GO
INSERT [dbo].[Empleado_Ingreso] ([id], [FechaIngreso]) VALUES (5, CAST(0xD6280B00 AS DATE))
GO
SET IDENTITY_INSERT [dbo].[Empleado_Ingreso] OFF
GO
SET IDENTITY_INSERT [dbo].[Pagos] ON

GO
INSERT [dbo].[Pagos] ([id_pagos], [fecha_pago], [id_empleado], [Concepto]) VALUES (1, CAST(0x69380B00 AS DATE), 5, N'Sueldo')
GO
INSERT [dbo].[Pagos] ([id_pagos], [fecha_pago], [id_empleado], [Concepto]) VALUES (2, CAST(0x69380B00 AS DATE), 3, N'Avance')
GO
INSERT [dbo].[Pagos] ([id_pagos], [fecha_pago], [id_empleado], [Concepto]) VALUES (3, CAST(0x69380B00 AS DATE), 4, N'Avance')
GO
INSERT [dbo].[Pagos] ([id_pagos], [fecha_pago], [id_empleado], [Concepto]) VALUES (4, CAST(0x69380B00 AS DATE), 1, N'Sueldo')
GO
INSERT [dbo].[Pagos] ([id_pagos], [fecha_pago], [id_empleado], [Concepto]) VALUES (5, CAST(0x69380B00 AS DATE), 2, N'Sueldo')
GO
SET IDENTITY_INSERT [dbo].[Pagos] OFF
GO