USE [CSVT]
GO
/****** Object:  StoredProcedure [dbo].[lietke]    Script Date: 2/1/2015 4:15:19 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE proc [dbo].[lietke]
@thang INT
AS
SELECT vattu.MAVT,MALVT,NGAYNHAP  FROM vattu,phieunhap
WHERE vattu.MAVT=phieunhap.MAVT
GO
/****** Object:  Table [dbo].[loaiVT]    Script Date: 2/1/2015 4:15:19 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[loaiVT](
    [MALVT] [VARCHAR](10) NOT NULL,
    [TENLVT] [nvarchar](50) NOT NULL,
 CONSTRAINT [PK_loaiVT] PRIMARY KEY CLUSTERED
(
    [MALVT] 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].[phieunhap]    Script Date: 2/1/2015 4:15:19 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[phieunhap](
    [MAVT] [VARCHAR](10) NOT NULL,
    [SOLUONGNHAP] [INT] NOT NULL,
    [DONGIA] [BIGINT] NOT NULL,
    [NGAYNHAP] [datetime] NOT NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[vattu]    Script Date: 2/1/2015 4:15:19 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[vattu](
    [MAVT] [VARCHAR](10) NOT NULL,
    [TENVT] [nvarchar](50) NOT NULL,
    [MALVT] [VARCHAR](10) NOT NULL,
    [SOLUONGTON] [INT] NOT NULL,
 CONSTRAINT [PK_vattu] PRIMARY KEY CLUSTERED
(
    [MAVT] 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
ALTER TABLE [dbo].[vattu] ADD  CONSTRAINT [DF_vattu_SOLUONGTON]  DEFAULT ((1)) FOR [SOLUONGTON]
GO
ALTER TABLE [dbo].[phieunhap]  WITH CHECK ADD  CONSTRAINT [FK_phieunhap_vattu] FOREIGN KEY([MAVT])
REFERENCES [dbo].[vattu] ([MAVT])
ON UPDATE CASCADE
GO
ALTER TABLE [dbo].[phieunhap] CHECK CONSTRAINT [FK_phieunhap_vattu]
GO
ALTER TABLE [dbo].[vattu]  WITH CHECK ADD  CONSTRAINT [FK_vattu_loaiVT] FOREIGN KEY([MALVT])
REFERENCES [dbo].[loaiVT] ([MALVT])
GO
ALTER TABLE [dbo].[vattu] CHECK CONSTRAINT [FK_vattu_loaiVT]
GO
ALTER TABLE [dbo].[phieunhap]  WITH CHECK ADD  CONSTRAINT [CK_phieunhap] CHECK  (([SOLUONGNHAP]>(0)))
GO
ALTER TABLE [dbo].[phieunhap] CHECK CONSTRAINT [CK_phieunhap]
GO