Script de base de datos VENTAS

USE [VENTAS]
GO
/****** Object:  Table [dbo].[CATEGORIA]    Script Date: 07/13/2013 10:23:00 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[CATEGORIA](
    [IdCategoria] [INT] IDENTITY(1,1) NOT NULL,
    [NombreCat] [VARCHAR](50) NOT NULL,
 CONSTRAINT [PK_CATEGORIA] PRIMARY KEY CLUSTERED
(
    [IdCategoria] 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
/****** Object:  Table [dbo].[PRODUCTO]    Script Date: 07/13/2013 10:23:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[PRODUCTO](
    [IdProducto] [INT] IDENTITY(1,1) NOT NULL,
    [Nombre] [VARCHAR](50) NOT NULL,
    [Precio] [DECIMAL](10, 4) NOT NULL,
    [IdCategoria] [INT] NOT NULL,
 CONSTRAINT [PK_PRODUCTO] PRIMARY KEY CLUSTERED
(
    [IdProducto] 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
/****** Object:  StoredProcedure [dbo].[SP_PRODUCTO_LISTAR_TODO_POR_CATEGORIA]    Script Date: 07/13/2013 10:22:58 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[SP_PRODUCTO_LISTAR_TODO_POR_CATEGORIA]
    @pIdCategoria INT
AS
BEGIN
    SELECT * FROM PRODUCTO WHERE IdCategoria = @pIdCategoria
END
GO
/****** Object:  StoredProcedure [dbo].[SP_PRODUCTO_LISTAR_TODO]    Script Date: 07/13/2013 10:22:58 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[SP_PRODUCTO_LISTAR_TODO]

AS
BEGIN
    SELECT * FROM PRODUCTO
END
GO
/****** Object:  StoredProcedure [dbo].[SP_PRODUCTO_GRABAR]    Script Date: 07/13/2013 10:22:58 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[SP_PRODUCTO_GRABAR]
    @pNombre VARCHAR(50),
    @pPrecio DECIMAL(10,4),
    @pIdCategoria INT
AS
BEGIN
    INSERT INTO PRODUCTO (Nombre, Precio, IdCategoria) VALUES (@pNombre, @pPrecio, @pIdCategoria)
END
GO
/****** Object:  StoredProcedure [dbo].[SP_PRODUCTO_ACTUALIZAR]    Script Date: 07/13/2013 10:22:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[SP_PRODUCTO_ACTUALIZAR]
    @pIdProducto INT,
    @pNombre VARCHAR(50),
    @pPrecio DECIMAL(10,4),
    @pIdCategoria INT
AS
BEGIN
    UPDATE PRODUCTO SET Nombre = @pNombre, Precio = @pPrecio, IdCategoria = @pIdCategoria WHERE IdProducto = @pIdProducto
END
GO
/****** Object:  StoredProcedure [dbo].[SP_PRODUCTO_BORRAR]    Script Date: 07/13/2013 10:22:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[SP_PRODUCTO_BORRAR]
    @pIdProducto INT
AS
BEGIN
    DELETE FROM Producto WHERE IdProducto = @pIdProducto
END
GO
/****** Object:  StoredProcedure [dbo].[SP_CATEGORIA_LISTAR_TODO]    Script Date: 07/13/2013 10:22:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[SP_CATEGORIA_LISTAR_TODO]

AS
BEGIN
    SELECT * FROM CATEGORIA
END
GO
/****** Object:  ForeignKey [FK_PRODUCTO_CATEGORIA]    Script Date: 07/13/2013 10:23:02 ******/
ALTER TABLE [dbo].[PRODUCTO]  WITH CHECK ADD  CONSTRAINT [FK_PRODUCTO_CATEGORIA] FOREIGN KEY([IdCategoria])
REFERENCES [dbo].[CATEGORIA] ([IdCategoria])
GO
ALTER TABLE [dbo].[PRODUCTO] CHECK CONSTRAINT [FK_PRODUCTO_CATEGORIA]
GO