USE [BD_REFACCIONARIA]
GO
/****** Object:  Table [dbo].[FAMILIAS]    Script Date: 11/01/2010 11:29:10 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[FAMILIAS](
	[ID_FAMILIA] [smallint] NOT NULL,
	[DESCR_FAMILIA] [nchar](30) NOT NULL,
 CONSTRAINT [PK_FAMILIAS] PRIMARY KEY CLUSTERED 
(
	[ID_FAMILIA] 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
INSERT [dbo].[FAMILIAS] ([ID_FAMILIA], [DESCR_FAMILIA]) VALUES (1, N'TORNILLOS                     ')
INSERT [dbo].[FAMILIAS] ([ID_FAMILIA], [DESCR_FAMILIA]) VALUES (2, N'ACEITES                       ')
INSERT [dbo].[FAMILIAS] ([ID_FAMILIA], [DESCR_FAMILIA]) VALUES (3, N'BALEROS                       ')
INSERT [dbo].[FAMILIAS] ([ID_FAMILIA], [DESCR_FAMILIA]) VALUES (4, N'FILTROS                       ')
INSERT [dbo].[FAMILIAS] ([ID_FAMILIA], [DESCR_FAMILIA]) VALUES (5, N'TUERCA 1                      ')
INSERT [dbo].[FAMILIAS] ([ID_FAMILIA], [DESCR_FAMILIA]) VALUES (6, N'TUERCA 2                      ')
INSERT [dbo].[FAMILIAS] ([ID_FAMILIA], [DESCR_FAMILIA]) VALUES (7, N'LLAVE 1                       ')
INSERT [dbo].[FAMILIAS] ([ID_FAMILIA], [DESCR_FAMILIA]) VALUES (8, N'LLAVE 2                       ')
/****** Object:  Table [dbo].[ENTIDADES]    Script Date: 11/01/2010 11:29:10 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ENTIDADES](
	[ID_ENTIDAD] [smallint] NOT NULL,
	[DESCR_ENTIDAD] [nchar](40) NOT NULL,
 CONSTRAINT [PK_ENTIDADES] PRIMARY KEY CLUSTERED 
(
	[ID_ENTIDAD] 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
INSERT [dbo].[ENTIDADES] ([ID_ENTIDAD], [DESCR_ENTIDAD]) VALUES (1, N'AGUASCALIENTES                          ')
INSERT [dbo].[ENTIDADES] ([ID_ENTIDAD], [DESCR_ENTIDAD]) VALUES (2, N'JALISCO                                 ')
INSERT [dbo].[ENTIDADES] ([ID_ENTIDAD], [DESCR_ENTIDAD]) VALUES (3, N'NAYARIT                                 ')
INSERT [dbo].[ENTIDADES] ([ID_ENTIDAD], [DESCR_ENTIDAD]) VALUES (4, N'BC                                      ')
INSERT [dbo].[ENTIDADES] ([ID_ENTIDAD], [DESCR_ENTIDAD]) VALUES (5, N'BCS                                     ')
INSERT [dbo].[ENTIDADES] ([ID_ENTIDAD], [DESCR_ENTIDAD]) VALUES (6, N'YUCATAN                                 ')
INSERT [dbo].[ENTIDADES] ([ID_ENTIDAD], [DESCR_ENTIDAD]) VALUES (25, N'SINALOA                                 ')
INSERT [dbo].[ENTIDADES] ([ID_ENTIDAD], [DESCR_ENTIDAD]) VALUES (26, N'SONORA                                  ')
INSERT [dbo].[ENTIDADES] ([ID_ENTIDAD], [DESCR_ENTIDAD]) VALUES (32, N'ZACATECAS                               ')
/****** Object:  Table [dbo].[CLIENTES]    Script Date: 11/01/2010 11:29:10 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[CLIENTES](
	[ID_CLIENTE] [int] NOT NULL,
	[NOMBRE_CLIENTE] [nchar](80) NOT NULL,
	[DOMICILIO] [nchar](80) NOT NULL,
	[RFC] [nchar](13) NULL,
	[ID_ENTIDAD] [smallint] NOT NULL,
	[LIM_CREDITO] [money] NOT NULL,
 CONSTRAINT [PK_CLIENTES] PRIMARY KEY CLUSTERED 
(
	[ID_CLIENTE] 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
INSERT [dbo].[CLIENTES] ([ID_CLIENTE], [NOMBRE_CLIENTE], [DOMICILIO], [RFC], [ID_ENTIDAD], [LIM_CREDITO]) VALUES (1, N'PITO PEREZ                                                                      ', N'FUENTES                                                                         ', N'RFSDF23422   ', 1, 1000.0000)
INSERT [dbo].[CLIENTES] ([ID_CLIENTE], [NOMBRE_CLIENTE], [DOMICILIO], [RFC], [ID_ENTIDAD], [LIM_CREDITO]) VALUES (2, N'RAUL ZAMBRANO                                                                   ', N'JARAMILLO                                                                       ', N'SDFAF23423   ', 2, 5000.0000)
INSERT [dbo].[CLIENTES] ([ID_CLIENTE], [NOMBRE_CLIENTE], [DOMICILIO], [RFC], [ID_ENTIDAD], [LIM_CREDITO]) VALUES (3, N'MARIA DEL CARMEN                                                                ', N'ESTRELLA                                                                        ', N'SDFGS45333   ', 3, 8903.0000)
INSERT [dbo].[CLIENTES] ([ID_CLIENTE], [NOMBRE_CLIENTE], [DOMICILIO], [RFC], [ID_ENTIDAD], [LIM_CREDITO]) VALUES (4, N'FERNANDA                                                                        ', N'CEDROS                                                                          ', N'SDFS554      ', 26, 0.0000)
/****** Object:  Table [dbo].[ARTICULOS]    Script Date: 11/01/2010 11:29:10 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ARTICULOS](
	[ID_ARTICULO] [smallint] NOT NULL,
	[ID_FAMILIA] [smallint] NOT NULL,
	[DESCR_ARTICULO] [nchar](30) NOT NULL,
	[COSTO_UNIT] [float] NOT NULL,
	[PRECIO_UNIT] [float] NOT NULL,
	[EXISTENCIA_UNIDAD] [smallint] NOT NULL
) ON [PRIMARY]
GO
INSERT [dbo].[ARTICULOS] ([ID_ARTICULO], [ID_FAMILIA], [DESCR_ARTICULO], [COSTO_UNIT], [PRECIO_UNIT], [EXISTENCIA_UNIDAD]) VALUES (101, 1, N'TORNILLO                      ', 8, 12, 10)
INSERT [dbo].[ARTICULOS] ([ID_ARTICULO], [ID_FAMILIA], [DESCR_ARTICULO], [COSTO_UNIT], [PRECIO_UNIT], [EXISTENCIA_UNIDAD]) VALUES (201, 2, N'ACEITE 1                      ', 40, 80, 10)
INSERT [dbo].[ARTICULOS] ([ID_ARTICULO], [ID_FAMILIA], [DESCR_ARTICULO], [COSTO_UNIT], [PRECIO_UNIT], [EXISTENCIA_UNIDAD]) VALUES (202, 2, N'ACEITE 2                      ', 60, 70, 59)
INSERT [dbo].[ARTICULOS] ([ID_ARTICULO], [ID_FAMILIA], [DESCR_ARTICULO], [COSTO_UNIT], [PRECIO_UNIT], [EXISTENCIA_UNIDAD]) VALUES (301, 3, N'BALERO XYZ                    ', 20, 30, 15)
/****** Object:  View [dbo].[LIM_CRED_CLIENTE]    Script Date: 11/01/2010 11:29:16 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[LIM_CRED_CLIENTE]
AS
SELECT     ID_CLIENTE, NOMBRE_CLIENTE, LIM_CREDITO, DOMICILIO, ID_ENTIDAD
FROM         dbo.CLIENTES
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[40] 4[20] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "CLIENTES"
            Begin Extent = 
               Top = 6
               Left = 38
               Bottom = 125
               Right = 216
            End
            DisplayFlags = 280
            TopColumn = 2
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'LIM_CRED_CLIENTE'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'LIM_CRED_CLIENTE'
GO
/****** Object:  ForeignKey [FK_ARTICULOS_FAMILIAS]    Script Date: 11/01/2010 11:29:10 ******/
ALTER TABLE [dbo].[ARTICULOS]  WITH CHECK ADD  CONSTRAINT [FK_ARTICULOS_FAMILIAS] FOREIGN KEY([ID_FAMILIA])
REFERENCES [dbo].[FAMILIAS] ([ID_FAMILIA])
GO
ALTER TABLE [dbo].[ARTICULOS] CHECK CONSTRAINT [FK_ARTICULOS_FAMILIAS]
GO
/****** Object:  ForeignKey [FK_CLIENTES_ENTIDADES]    Script Date: 11/01/2010 11:29:10 ******/
ALTER TABLE [dbo].[CLIENTES]  WITH CHECK ADD  CONSTRAINT [FK_CLIENTES_ENTIDADES] FOREIGN KEY([ID_ENTIDAD])
REFERENCES [dbo].[ENTIDADES] ([ID_ENTIDAD])
GO
ALTER TABLE [dbo].[CLIENTES] CHECK CONSTRAINT [FK_CLIENTES_ENTIDADES]
GO