DoAnQuanLyQuanCafe.sql

USE [master]
GO
/****** Object:  Database [DoAnQuanLyQuanCafe]    Script Date: 6/6/2017 9:38:47 PM ******/
CREATE DATABASE [DoAnQuanLyQuanCafe]
 CONTAINMENT = NONE
 ON  PRIMARY 
( NAME = N'DoAnQuanLyQuanCafe', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL11.SQLEXPRESS\MSSQL\DATA\DoAnQuanLyQuanCafe.mdf' , SIZE = 3136KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
 LOG ON 
( NAME = N'DoAnQuanLyQuanCafe_log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL11.SQLEXPRESS\MSSQL\DATA\DoAnQuanLyQuanCafe_log.ldf' , SIZE = 832KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
GO
ALTER DATABASE [DoAnQuanLyQuanCafe] SET COMPATIBILITY_LEVEL = 110
GO
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [DoAnQuanLyQuanCafe].[dbo].[sp_fulltext_database] @action = 'enable'
end
GO
ALTER DATABASE [DoAnQuanLyQuanCafe] SET ANSI_NULL_DEFAULT OFF 
GO
ALTER DATABASE [DoAnQuanLyQuanCafe] SET ANSI_NULLS OFF 
GO
ALTER DATABASE [DoAnQuanLyQuanCafe] SET ANSI_PADDING OFF 
GO
ALTER DATABASE [DoAnQuanLyQuanCafe] SET ANSI_WARNINGS OFF 
GO
ALTER DATABASE [DoAnQuanLyQuanCafe] SET ARITHABORT OFF 
GO
ALTER DATABASE [DoAnQuanLyQuanCafe] SET AUTO_CLOSE ON 
GO
ALTER DATABASE [DoAnQuanLyQuanCafe] SET AUTO_CREATE_STATISTICS ON 
GO
ALTER DATABASE [DoAnQuanLyQuanCafe] SET AUTO_SHRINK OFF 
GO
ALTER DATABASE [DoAnQuanLyQuanCafe] SET AUTO_UPDATE_STATISTICS ON 
GO
ALTER DATABASE [DoAnQuanLyQuanCafe] SET CURSOR_CLOSE_ON_COMMIT OFF 
GO
ALTER DATABASE [DoAnQuanLyQuanCafe] SET CURSOR_DEFAULT  GLOBAL 
GO
ALTER DATABASE [DoAnQuanLyQuanCafe] SET CONCAT_NULL_YIELDS_NULL OFF 
GO
ALTER DATABASE [DoAnQuanLyQuanCafe] SET NUMERIC_ROUNDABORT OFF 
GO
ALTER DATABASE [DoAnQuanLyQuanCafe] SET QUOTED_IDENTIFIER OFF 
GO
ALTER DATABASE [DoAnQuanLyQuanCafe] SET RECURSIVE_TRIGGERS OFF 
GO
ALTER DATABASE [DoAnQuanLyQuanCafe] SET  ENABLE_BROKER 
GO
ALTER DATABASE [DoAnQuanLyQuanCafe] SET AUTO_UPDATE_STATISTICS_ASYNC OFF 
GO
ALTER DATABASE [DoAnQuanLyQuanCafe] SET DATE_CORRELATION_OPTIMIZATION OFF 
GO
ALTER DATABASE [DoAnQuanLyQuanCafe] SET TRUSTWORTHY OFF 
GO
ALTER DATABASE [DoAnQuanLyQuanCafe] SET ALLOW_SNAPSHOT_ISOLATION OFF 
GO
ALTER DATABASE [DoAnQuanLyQuanCafe] SET PARAMETERIZATION SIMPLE 
GO
ALTER DATABASE [DoAnQuanLyQuanCafe] SET READ_COMMITTED_SNAPSHOT OFF 
GO
ALTER DATABASE [DoAnQuanLyQuanCafe] SET HONOR_BROKER_PRIORITY OFF 
GO
ALTER DATABASE [DoAnQuanLyQuanCafe] SET RECOVERY SIMPLE 
GO
ALTER DATABASE [DoAnQuanLyQuanCafe] SET  MULTI_USER 
GO
ALTER DATABASE [DoAnQuanLyQuanCafe] SET PAGE_VERIFY CHECKSUM  
GO
ALTER DATABASE [DoAnQuanLyQuanCafe] SET DB_CHAINING OFF 
GO
ALTER DATABASE [DoAnQuanLyQuanCafe] SET FILESTREAM( NON_TRANSACTED_ACCESS = OFF ) 
GO
ALTER DATABASE [DoAnQuanLyQuanCafe] SET TARGET_RECOVERY_TIME = 0 SECONDS 
GO
USE [DoAnQuanLyQuanCafe]
GO
/****** Object:  StoredProcedure [dbo].[TAIKHOANLIST]    Script Date: 6/6/2017 9:38:47 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create proc [dbo].[TAIKHOANLIST]
@TenTK varchar(100)
as
begin 
     select * from TAIKHOAN WHERE TENTK = @TenTK
end
EXEC dbo.TAIKHOANLIST @TenTK


GO
/****** Object:  StoredProcedure [dbo].[USP_GetKiemKeList]    Script Date: 6/6/2017 9:38:47 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create proc [dbo].[USP_GetKiemKeList]
(
@ngaykk smalldatetime
)
as select  KIEMKE.NgayKiemKe, KIEMKE.TenTK, CT_KIEMKE.MaNL, NGUYENLIEU.TenNL,CT_KIEMKE.SL, CT_KIEMKE.DVT from (dbo.KIEMKE inner join dbo.CT_KIEMKE on KIEMKE.NgayKiemKe = CT_KIEMKE.NgayKiemKe) inner join NGUYENLIEU on CT_KIEMKE.MaNL = NGUYENLIEU.MaNL where KIEMKE.NgayKiemKe = @ngaykk


GO
/****** Object:  StoredProcedure [dbo].[USP_GetLoaiMon]    Script Date: 6/6/2017 9:38:47 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create proc [dbo].[USP_GetLoaiMon]
as select * from LoaiMon


GO
/****** Object:  StoredProcedure [dbo].[USP_GetMonAn]    Script Date: 6/6/2017 9:38:47 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create proc [dbo].[USP_GetMonAn]
as select * from MONAN


GO
/****** Object:  StoredProcedure [dbo].[USP_GetNguyenLieuList]    Script Date: 6/6/2017 9:38:47 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create proc [dbo].[USP_GetNguyenLieuList]
as select * from dbo.NGUYENLIEU


GO
/****** Object:  StoredProcedure [dbo].[USP_InsertCTHD]    Script Date: 6/6/2017 9:38:47 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create proc [dbo].[USP_InsertCTHD]
(
	@mama int ,
	@mahd int,
	@soluong int,
	@dvt nvarchar(100)
)
as 
begin
		insert into CTHD (MAMA, MAHD, Soluong, DVT) values (@mama, @mahd, @soluong, @dvt)
end


GO
/****** Object:  StoredProcedure [dbo].[USP_InsertHoaDon]    Script Date: 6/6/2017 9:38:47 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create proc [dbo].[USP_InsertHoaDon]
(
	@lucvao smalldatetime,
	@lucra smalldatetime ,
	@maban int
)
as
begin
		insert into HOADON (DateCheckIn , DateCheckOut , MABA) values (@lucvao , @lucra , @maban)
end




GO
/****** Object:  StoredProcedure [dbo].[USP_InsertLoaiMon]    Script Date: 6/6/2017 9:38:47 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create proc [dbo].[USP_InsertLoaiMon]
(
@tenloaimon nvarchar(100)
)
as
begin
	insert into dbo.LOAIMON values (@tenloaimon)
end


GO
/****** Object:  StoredProcedure [dbo].[USP_InsertMonAnmoi]    Script Date: 6/6/2017 9:38:47 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create proc [dbo].[USP_InsertMonAnmoi]
(	
	@dongia float,
	@dvt nvarchar(100),
	@tenmonan nvarchar(100),
	@maloai int
)
as
begin 
	insert into dbo.MONAN values (@dongia,@dvt,@tenmonan,@maloai)
end


GO
/****** Object:  StoredProcedure [dbo].[USP_InsertNguyenLieu]    Script Date: 6/6/2017 9:38:47 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create proc [dbo].[USP_InsertNguyenLieu]
(
@manl varchar(100),
@tennl varchar(100),
@ngaynhap smalldatetime,
@nguoinhap varchar(100)
)
as
begin
	insert into dbo.NGUYENLIEU values (@manl,@tennl,@ngaynhap,@nguoinhap)
end


GO
/****** Object:  Table [dbo].[BANAN]    Script Date: 6/6/2017 9:38:47 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[BANAN](
	[MABA] [int] IDENTITY(1,1) NOT NULL,
	[TENBA] [nvarchar](100) NULL,
	[TRANGTHAI] [nvarchar](100) NULL,
	[status] [int] NOT NULL,
	[MAKV] [int] NULL,
PRIMARY KEY CLUSTERED 
(
	[MABA] 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].[CATRUC]    Script Date: 6/6/2017 9:38:47 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[CATRUC](
	[MACT] [int] IDENTITY(1,1) NOT NULL,
	[TENCA] [nvarchar](100) NULL,
	[BATDAU] [nvarchar](100) NULL,
	[KETTHUC] [nvarchar](100) NULL,
	[TIENCHINHTHUC] [int] NULL,
	[TIENTHOIVU] [int] NULL,
PRIMARY KEY CLUSTERED 
(
	[MACT] 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].[CHITIETTINHCONG]    Script Date: 6/6/2017 9:38:47 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[CHITIETTINHCONG](
	[MACHITIET] [int] IDENTITY(1,1) NOT NULL,
	[MADD] [int] NOT NULL,
	[MANV] [int] NOT NULL,
	[MACT] [int] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[MACHITIET] 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].[CHUCVU]    Script Date: 6/6/2017 9:38:47 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[CHUCVU](
	[MACV] [int] IDENTITY(1,1) NOT NULL,
	[TENCV] [nvarchar](100) NULL,
	[HELUONG] [float] NULL,
PRIMARY KEY CLUSTERED 
(
	[MACV] 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].[CT_KIEMKE]    Script Date: 6/6/2017 9:38:47 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[CT_KIEMKE](
	[NgayKiemKe] [smalldatetime] NOT NULL,
	[MaNL] [varchar](10) NOT NULL,
	[SL] [float] NULL,
	[DVT] [varchar](10) NULL,
 CONSTRAINT [PK_CTKK] PRIMARY KEY CLUSTERED 
(
	[NgayKiemKe] ASC,
	[MaNL] 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].[CT_NL]    Script Date: 6/6/2017 9:38:47 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[CT_NL](
	[MAMA] [int] NOT NULL,
	[MaNL] [varchar](10) NOT NULL,
	[SoLuong] [float] NULL,
 CONSTRAINT [PP_DK] PRIMARY KEY CLUSTERED 
(
	[MAMA] ASC,
	[MaNL] 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].[CTDS_NHAPHANG]    Script Date: 6/6/2017 9:38:47 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[CTDS_NHAPHANG](
	[NgayNhapHang] [smalldatetime] NOT NULL,
	[MaNL] [varchar](10) NOT NULL,
	[SL] [int] NULL,
	[DVT] [varchar](10) NULL,
	[XacNhan] [bit] NULL,
 CONSTRAINT [PK_CTNH] PRIMARY KEY CLUSTERED 
(
	[NgayNhapHang] ASC,
	[MaNL] 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].[CTHD]    Script Date: 6/6/2017 9:38:47 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[CTHD](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[MAMA] [int] NULL,
	[MAHD] [int] NULL,
	[Soluong] [int] NULL,
	[DVT] [nvarchar](100) NULL,
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].[DANHSACH_NHAPHANG]    Script Date: 6/6/2017 9:38:47 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[DANHSACH_NHAPHANG](
	[NgayNhapHang] [smalldatetime] NOT NULL,
	[TenTK] [varchar](100) NULL,
PRIMARY KEY CLUSTERED 
(
	[NgayNhapHang] 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].[DIEMDANH]    Script Date: 6/6/2017 9:38:47 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[DIEMDANH](
	[MADD] [int] IDENTITY(1,1) NOT NULL,
	[NGAY] [smalldatetime] NULL,
PRIMARY KEY CLUSTERED 
(
	[MADD] 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].[HOADON]    Script Date: 6/6/2017 9:38:47 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[HOADON](
	[MAHD] [int] IDENTITY(1,1) NOT NULL,
	[DateCheckIn] [smalldatetime] NOT NULL,
	[DateCheckOut] [smalldatetime] NULL,
	[GiamGia] [int] NULL,
	[MABA] [int] NULL,
	[status] [int] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[MAHD] 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].[KHUVUC]    Script Date: 6/6/2017 9:38:47 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[KHUVUC](
	[MAKV] [int] IDENTITY(1,1) NOT NULL,
	[TENKV] [nvarchar](100) NULL,
PRIMARY KEY CLUSTERED 
(
	[MAKV] 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].[KIEMKE]    Script Date: 6/6/2017 9:38:47 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[KIEMKE](
	[NgayKiemKe] [smalldatetime] NOT NULL,
	[TenTK] [varchar](100) NULL,
PRIMARY KEY CLUSTERED 
(
	[NgayKiemKe] 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].[LOAIMON]    Script Date: 6/6/2017 9:38:47 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[LOAIMON](
	[MALOAI] [int] IDENTITY(1,1) NOT NULL,
	[TENLOAI] [nvarchar](100) NULL,
PRIMARY KEY CLUSTERED 
(
	[MALOAI] 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].[MONAN]    Script Date: 6/6/2017 9:38:47 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[MONAN](
	[MAMA] [int] IDENTITY(1,1) NOT NULL,
	[DonGia] [float] NULL,
	[DVT] [nvarchar](100) NULL,
	[TENMA] [nvarchar](100) NULL,
	[MALOAI] [int] NULL,
PRIMARY KEY CLUSTERED 
(
	[MAMA] 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].[NGUYENLIEU]    Script Date: 6/6/2017 9:38:47 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[NGUYENLIEU](
	[MaNL] [varchar](10) NOT NULL,
	[TenNL] [nvarchar](50) NULL,
	[NgayNhap] [smalldatetime] NULL,
	[TenTK] [varchar](100) NULL,
PRIMARY KEY CLUSTERED 
(
	[MaNL] 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].[NHANVIEN]    Script Date: 6/6/2017 9:38:47 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[NHANVIEN](
	[MANV] [int] IDENTITY(1,1) NOT NULL,
	[MACV] [int] NOT NULL,
	[HOTEN] [nvarchar](100) NOT NULL,
	[PHAI] [nvarchar](100) NULL,
	[NGAYSINH] [smalldatetime] NULL,
	[CMND] [nvarchar](100) NULL,
	[DIACHI] [nvarchar](100) NULL,
	[DIENTHOAI] [nvarchar](100) NULL,
	[LOAINV] [nvarchar](100) NULL,
	[TINHTRANG] [int] NOT NULL,
	[TRANGTHAI] [int] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[MANV] 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].[PHIEUCHI]    Script Date: 6/6/2017 9:38:47 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[PHIEUCHI](
	[MAPC] [int] IDENTITY(1,1) NOT NULL,
	[NOIDUNG] [nvarchar](100) NULL,
	[SOTIEN] [int] NULL,
	[NGAYLAP] [smalldatetime] NULL,
	[GHICHU] [nvarchar](100) NULL,
	[NGUOINHAN] [nvarchar](100) NULL,
PRIMARY KEY CLUSTERED 
(
	[MAPC] 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].[TAIKHOAN]    Script Date: 6/6/2017 9:38:47 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[TAIKHOAN](
	[TENTK] [varchar](100) NOT NULL,
	[LOAITK] [nvarchar](100) NULL,
	[MATKHAU] [varchar](100) NULL,
PRIMARY KEY CLUSTERED 
(
	[TENTK] 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].[BANAN] ON 

INSERT [dbo].[BANAN] ([MABA], [TENBA], [TRANGTHAI], [status], [MAKV]) VALUES (1, N'Ban0', NULL, 0, 3)
INSERT [dbo].[BANAN] ([MABA], [TENBA], [TRANGTHAI], [status], [MAKV]) VALUES (2, N'Ban1', NULL, 0, 3)
INSERT [dbo].[BANAN] ([MABA], [TENBA], [TRANGTHAI], [status], [MAKV]) VALUES (3, N'Ban2', NULL, 0, 3)
INSERT [dbo].[BANAN] ([MABA], [TENBA], [TRANGTHAI], [status], [MAKV]) VALUES (4, N'Ban3', NULL, 0, 3)
INSERT [dbo].[BANAN] ([MABA], [TENBA], [TRANGTHAI], [status], [MAKV]) VALUES (5, N'Ban4', NULL, 0, 3)
INSERT [dbo].[BANAN] ([MABA], [TENBA], [TRANGTHAI], [status], [MAKV]) VALUES (6, N'Ban5', NULL, 0, 3)
INSERT [dbo].[BANAN] ([MABA], [TENBA], [TRANGTHAI], [status], [MAKV]) VALUES (7, N'Ban6', NULL, 0, 3)
INSERT [dbo].[BANAN] ([MABA], [TENBA], [TRANGTHAI], [status], [MAKV]) VALUES (8, N'Ban7', NULL, 0, 3)
INSERT [dbo].[BANAN] ([MABA], [TENBA], [TRANGTHAI], [status], [MAKV]) VALUES (9, N'Ban8', NULL, 0, 3)
INSERT [dbo].[BANAN] ([MABA], [TENBA], [TRANGTHAI], [status], [MAKV]) VALUES (10, N'Ban9', NULL, 0, 3)
INSERT [dbo].[BANAN] ([MABA], [TENBA], [TRANGTHAI], [status], [MAKV]) VALUES (11, N'Ban10', NULL, 0, 3)
INSERT [dbo].[BANAN] ([MABA], [TENBA], [TRANGTHAI], [status], [MAKV]) VALUES (12, N'Ban11', NULL, 0, 3)
INSERT [dbo].[BANAN] ([MABA], [TENBA], [TRANGTHAI], [status], [MAKV]) VALUES (13, N'Ban12', NULL, 0, 3)
INSERT [dbo].[BANAN] ([MABA], [TENBA], [TRANGTHAI], [status], [MAKV]) VALUES (14, N'Ban13', NULL, 0, 3)
INSERT [dbo].[BANAN] ([MABA], [TENBA], [TRANGTHAI], [status], [MAKV]) VALUES (15, N'Ban14', NULL, 0, 3)
INSERT [dbo].[BANAN] ([MABA], [TENBA], [TRANGTHAI], [status], [MAKV]) VALUES (16, N'Ban0', NULL, 0, 1)
INSERT [dbo].[BANAN] ([MABA], [TENBA], [TRANGTHAI], [status], [MAKV]) VALUES (17, N'Ban1', NULL, 0, 1)
INSERT [dbo].[BANAN] ([MABA], [TENBA], [TRANGTHAI], [status], [MAKV]) VALUES (18, N'Ban2', NULL, 0, 1)
INSERT [dbo].[BANAN] ([MABA], [TENBA], [TRANGTHAI], [status], [MAKV]) VALUES (19, N'Ban3', NULL, 0, 1)
INSERT [dbo].[BANAN] ([MABA], [TENBA], [TRANGTHAI], [status], [MAKV]) VALUES (20, N'Ban4', NULL, 0, 1)
INSERT [dbo].[BANAN] ([MABA], [TENBA], [TRANGTHAI], [status], [MAKV]) VALUES (21, N'Ban5', NULL, 0, 1)
INSERT [dbo].[BANAN] ([MABA], [TENBA], [TRANGTHAI], [status], [MAKV]) VALUES (22, N'Ban6', NULL, 0, 1)
INSERT [dbo].[BANAN] ([MABA], [TENBA], [TRANGTHAI], [status], [MAKV]) VALUES (23, N'Ban7', NULL, 0, 1)
INSERT [dbo].[BANAN] ([MABA], [TENBA], [TRANGTHAI], [status], [MAKV]) VALUES (24, N'Ban8', NULL, 0, 1)
INSERT [dbo].[BANAN] ([MABA], [TENBA], [TRANGTHAI], [status], [MAKV]) VALUES (25, N'Ban9', NULL, 0, 1)
INSERT [dbo].[BANAN] ([MABA], [TENBA], [TRANGTHAI], [status], [MAKV]) VALUES (26, N'Ban10', NULL, 0, 1)
INSERT [dbo].[BANAN] ([MABA], [TENBA], [TRANGTHAI], [status], [MAKV]) VALUES (27, N'Ban11', NULL, 0, 1)
INSERT [dbo].[BANAN] ([MABA], [TENBA], [TRANGTHAI], [status], [MAKV]) VALUES (28, N'Ban12', NULL, 0, 1)
INSERT [dbo].[BANAN] ([MABA], [TENBA], [TRANGTHAI], [status], [MAKV]) VALUES (29, N'Ban13', NULL, 0, 1)
INSERT [dbo].[BANAN] ([MABA], [TENBA], [TRANGTHAI], [status], [MAKV]) VALUES (30, N'Ban14', NULL, 0, 1)
INSERT [dbo].[BANAN] ([MABA], [TENBA], [TRANGTHAI], [status], [MAKV]) VALUES (31, N'Ban0', NULL, 0, 2)
INSERT [dbo].[BANAN] ([MABA], [TENBA], [TRANGTHAI], [status], [MAKV]) VALUES (32, N'Ban1', NULL, 0, 2)
INSERT [dbo].[BANAN] ([MABA], [TENBA], [TRANGTHAI], [status], [MAKV]) VALUES (33, N'Ban2', NULL, 0, 2)
INSERT [dbo].[BANAN] ([MABA], [TENBA], [TRANGTHAI], [status], [MAKV]) VALUES (34, N'Ban3', NULL, 0, 2)
INSERT [dbo].[BANAN] ([MABA], [TENBA], [TRANGTHAI], [status], [MAKV]) VALUES (35, N'Ban4', NULL, 0, 2)
INSERT [dbo].[BANAN] ([MABA], [TENBA], [TRANGTHAI], [status], [MAKV]) VALUES (36, N'Ban5', NULL, 0, 2)
INSERT [dbo].[BANAN] ([MABA], [TENBA], [TRANGTHAI], [status], [MAKV]) VALUES (37, N'Ban6', NULL, 0, 2)
INSERT [dbo].[BANAN] ([MABA], [TENBA], [TRANGTHAI], [status], [MAKV]) VALUES (38, N'Ban7', NULL, 0, 2)
INSERT [dbo].[BANAN] ([MABA], [TENBA], [TRANGTHAI], [status], [MAKV]) VALUES (39, N'Ban8', NULL, 0, 2)
INSERT [dbo].[BANAN] ([MABA], [TENBA], [TRANGTHAI], [status], [MAKV]) VALUES (40, N'Ban9', NULL, 0, 2)
INSERT [dbo].[BANAN] ([MABA], [TENBA], [TRANGTHAI], [status], [MAKV]) VALUES (41, N'Ban10', NULL, 0, 2)
INSERT [dbo].[BANAN] ([MABA], [TENBA], [TRANGTHAI], [status], [MAKV]) VALUES (42, N'Ban11', NULL, 0, 2)
INSERT [dbo].[BANAN] ([MABA], [TENBA], [TRANGTHAI], [status], [MAKV]) VALUES (43, N'Ban12', NULL, 0, 2)
INSERT [dbo].[BANAN] ([MABA], [TENBA], [TRANGTHAI], [status], [MAKV]) VALUES (44, N'Ban13', NULL, 0, 2)
INSERT [dbo].[BANAN] ([MABA], [TENBA], [TRANGTHAI], [status], [MAKV]) VALUES (45, N'Ban14', NULL, 0, 2)
INSERT [dbo].[BANAN] ([MABA], [TENBA], [TRANGTHAI], [status], [MAKV]) VALUES (46, N'Ban1', N'', 0, 3)
INSERT [dbo].[BANAN] ([MABA], [TENBA], [TRANGTHAI], [status], [MAKV]) VALUES (47, N'Ban0', N'', 0, 3)
INSERT [dbo].[BANAN] ([MABA], [TENBA], [TRANGTHAI], [status], [MAKV]) VALUES (48, N'Ban3', N'', 0, 3)
SET IDENTITY_INSERT [dbo].[BANAN] OFF
SET IDENTITY_INSERT [dbo].[CATRUC] ON 

INSERT [dbo].[CATRUC] ([MACT], [TENCA], [BATDAU], [KETTHUC], [TIENCHINHTHUC], [TIENTHOIVU]) VALUES (1, N'Ca sáng', N'6h00', N'11h00', 100000, 120000)
INSERT [dbo].[CATRUC] ([MACT], [TENCA], [BATDAU], [KETTHUC], [TIENCHINHTHUC], [TIENTHOIVU]) VALUES (2, N'Ca chiều', N'11h00', N'16h00', 100000, 120000)
INSERT [dbo].[CATRUC] ([MACT], [TENCA], [BATDAU], [KETTHUC], [TIENCHINHTHUC], [TIENTHOIVU]) VALUES (3, N'Ca tối', N'16h00', N'22h00', 100000, 120000)
SET IDENTITY_INSERT [dbo].[CATRUC] OFF
SET IDENTITY_INSERT [dbo].[CHITIETTINHCONG] ON 

INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (1, 1, 5, 1)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (2, 1, 1, 1)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (3, 1, 2, 1)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (4, 1, 3, 1)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (5, 1, 4, 1)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (6, 1, 6, 1)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (7, 1, 7, 1)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (8, 1, 8, 1)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (9, 1, 9, 1)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (10, 2, 1, 1)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (11, 2, 2, 1)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (12, 2, 3, 1)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (13, 2, 4, 1)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (14, 2, 5, 1)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (15, 2, 6, 1)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (16, 2, 7, 1)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (17, 2, 8, 1)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (18, 2, 9, 1)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (19, 2, 1, 2)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (20, 2, 2, 2)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (21, 2, 3, 2)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (22, 2, 4, 2)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (23, 2, 5, 2)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (24, 2, 6, 2)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (25, 2, 7, 2)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (26, 2, 8, 2)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (27, 2, 9, 2)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (28, 2, 1, 3)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (29, 2, 2, 3)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (30, 2, 3, 3)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (31, 2, 4, 3)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (32, 2, 5, 3)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (33, 2, 6, 3)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (34, 2, 7, 3)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (35, 2, 8, 3)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (36, 2, 9, 3)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (37, 3, 1, 1)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (38, 3, 2, 1)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (39, 3, 3, 1)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (40, 3, 4, 1)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (41, 3, 5, 1)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (42, 3, 6, 1)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (43, 3, 7, 1)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (44, 3, 8, 1)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (45, 3, 9, 1)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (46, 3, 1, 2)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (47, 3, 2, 2)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (48, 3, 3, 2)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (49, 3, 4, 2)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (50, 3, 5, 2)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (51, 3, 6, 2)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (52, 3, 1, 3)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (53, 3, 2, 3)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (54, 3, 3, 3)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (55, 3, 4, 3)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (56, 3, 5, 3)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (57, 3, 12, 1)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (58, 3, 13, 1)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (59, 3, 14, 1)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (60, 3, 15, 1)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (61, 4, 1, 1)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (62, 4, 2, 1)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (63, 4, 3, 1)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (64, 4, 4, 1)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (65, 4, 5, 1)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (66, 4, 6, 1)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (67, 4, 7, 1)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (68, 4, 8, 1)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (69, 4, 9, 1)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (70, 4, 12, 1)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (71, 4, 13, 1)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (72, 4, 1, 2)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (73, 4, 2, 2)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (74, 4, 3, 2)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (75, 4, 4, 2)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (76, 4, 5, 2)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (77, 4, 6, 2)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (78, 4, 7, 2)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (79, 4, 1, 3)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (80, 4, 2, 3)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (81, 4, 3, 3)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (82, 4, 4, 3)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (83, 4, 5, 3)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (84, 4, 6, 3)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (85, 4, 7, 3)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (86, 4, 8, 3)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (87, 4, 9, 3)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (88, 4, 12, 3)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (89, 4, 13, 3)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (90, 4, 14, 3)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (91, 4, 15, 3)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (92, 5, 1, 1)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (93, 5, 2, 1)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (94, 5, 3, 1)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (95, 5, 4, 1)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (96, 5, 5, 1)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (97, 5, 6, 1)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (98, 5, 7, 1)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (99, 5, 8, 1)
GO
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (100, 5, 9, 1)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (101, 5, 12, 1)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (102, 5, 13, 1)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (103, 5, 14, 1)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (104, 5, 15, 1)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (105, 5, 1, 3)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (106, 5, 2, 3)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (107, 5, 3, 3)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (108, 5, 4, 3)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (109, 5, 5, 3)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (110, 5, 6, 3)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (111, 5, 7, 3)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (112, 5, 8, 3)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (113, 5, 9, 3)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (114, 5, 12, 3)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (115, 5, 13, 3)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (116, 5, 14, 3)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (117, 5, 15, 3)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (118, 5, 1, 2)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (119, 5, 2, 2)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (120, 5, 3, 2)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (121, 5, 4, 2)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (122, 5, 5, 2)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (123, 5, 6, 2)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (124, 5, 7, 2)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (125, 5, 8, 2)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (126, 5, 9, 2)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (127, 5, 12, 2)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (128, 5, 13, 2)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (129, 5, 14, 2)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (130, 5, 15, 2)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (131, 6, 1, 1)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (132, 6, 2, 1)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (133, 6, 3, 1)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (134, 6, 4, 1)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (135, 6, 5, 1)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (136, 6, 6, 1)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (137, 6, 7, 1)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (138, 6, 8, 1)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (139, 6, 9, 1)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (140, 6, 12, 1)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (141, 6, 13, 1)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (142, 6, 14, 1)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (143, 6, 15, 1)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (144, 6, 1, 2)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (145, 6, 2, 2)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (146, 6, 3, 2)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (147, 6, 4, 2)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (148, 6, 5, 2)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (149, 6, 6, 2)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (150, 6, 7, 2)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (151, 6, 8, 2)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (152, 6, 9, 2)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (153, 6, 12, 2)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (154, 6, 13, 2)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (155, 6, 14, 2)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (156, 6, 15, 2)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (157, 7, 1, 1)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (158, 7, 2, 1)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (159, 7, 3, 1)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (160, 7, 4, 1)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (161, 7, 5, 1)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (162, 7, 6, 1)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (163, 7, 7, 1)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (164, 7, 8, 1)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (165, 7, 9, 1)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (166, 7, 12, 1)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (167, 7, 13, 1)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (168, 7, 14, 1)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (169, 7, 15, 1)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (170, 7, 1, 2)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (171, 7, 2, 2)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (172, 7, 3, 2)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (173, 7, 4, 2)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (174, 7, 5, 2)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (175, 7, 6, 2)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (176, 7, 7, 2)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (177, 7, 8, 2)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (178, 7, 15, 2)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (179, 7, 13, 2)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (180, 7, 9, 2)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (181, 7, 12, 2)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (182, 7, 14, 2)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (183, 8, 1, 2)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (184, 8, 2, 2)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (185, 8, 3, 2)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (186, 8, 4, 2)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (187, 8, 5, 2)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (188, 8, 6, 2)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (189, 8, 7, 2)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (190, 8, 8, 2)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (191, 8, 1, 1)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (192, 8, 2, 1)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (193, 8, 3, 1)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (194, 8, 4, 1)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (195, 8, 5, 1)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (196, 8, 6, 1)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (197, 8, 7, 1)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (198, 8, 8, 1)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (199, 8, 9, 1)
GO
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (200, 8, 12, 1)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (201, 8, 13, 1)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (202, 8, 14, 1)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (203, 8, 1, 3)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (204, 8, 2, 3)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (205, 8, 3, 3)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (206, 8, 4, 3)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (207, 8, 5, 3)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (208, 8, 6, 3)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (209, 8, 7, 3)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (210, 8, 8, 3)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (211, 8, 9, 3)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (212, 8, 12, 3)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (213, 8, 13, 3)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (214, 8, 14, 3)
INSERT [dbo].[CHITIETTINHCONG] ([MACHITIET], [MADD], [MANV], [MACT]) VALUES (215, 8, 15, 3)
SET IDENTITY_INSERT [dbo].[CHITIETTINHCONG] OFF
SET IDENTITY_INSERT [dbo].[CHUCVU] ON 

INSERT [dbo].[CHUCVU] ([MACV], [TENCV], [HELUONG]) VALUES (1, N'Nhân viên', 1)
INSERT [dbo].[CHUCVU] ([MACV], [TENCV], [HELUONG]) VALUES (2, N'Thu Ngân', 1.2)
INSERT [dbo].[CHUCVU] ([MACV], [TENCV], [HELUONG]) VALUES (3, N'Pha Chế', 1.2)
INSERT [dbo].[CHUCVU] ([MACV], [TENCV], [HELUONG]) VALUES (4, N'Quản lý', 1.5)
SET IDENTITY_INSERT [dbo].[CHUCVU] OFF
INSERT [dbo].[CT_KIEMKE] ([NgayKiemKe], [MaNL], [SL], [DVT]) VALUES (CAST(0xA76C0000 AS SmallDateTime), N'MK01', 5, N'Kg')
INSERT [dbo].[CT_KIEMKE] ([NgayKiemKe], [MaNL], [SL], [DVT]) VALUES (CAST(0xA76C0000 AS SmallDateTime), N'MK02', 10, N'Chai')
INSERT [dbo].[CT_KIEMKE] ([NgayKiemKe], [MaNL], [SL], [DVT]) VALUES (CAST(0xA76C0000 AS SmallDateTime), N'MK03', 10, N'Kg')
INSERT [dbo].[CT_KIEMKE] ([NgayKiemKe], [MaNL], [SL], [DVT]) VALUES (CAST(0xA76C0000 AS SmallDateTime), N'MK04', 7, N'Kg')
INSERT [dbo].[CT_KIEMKE] ([NgayKiemKe], [MaNL], [SL], [DVT]) VALUES (CAST(0xA76C0000 AS SmallDateTime), N'MK05', 8, N'Kg')
INSERT [dbo].[CT_KIEMKE] ([NgayKiemKe], [MaNL], [SL], [DVT]) VALUES (CAST(0xA76C0000 AS SmallDateTime), N'MK06', 12, N'Kg')
INSERT [dbo].[CT_KIEMKE] ([NgayKiemKe], [MaNL], [SL], [DVT]) VALUES (CAST(0xA76C0000 AS SmallDateTime), N'MK07', 6, N'Kg')
INSERT [dbo].[CT_KIEMKE] ([NgayKiemKe], [MaNL], [SL], [DVT]) VALUES (CAST(0xA76C0000 AS SmallDateTime), N'MK08', 3, N'Kg')
INSERT [dbo].[CT_KIEMKE] ([NgayKiemKe], [MaNL], [SL], [DVT]) VALUES (CAST(0xA76C0000 AS SmallDateTime), N'MK09', 9, N'Kg')
INSERT [dbo].[CT_KIEMKE] ([NgayKiemKe], [MaNL], [SL], [DVT]) VALUES (CAST(0xA76C0000 AS SmallDateTime), N'MK10', 8, N'Lít')
INSERT [dbo].[CT_KIEMKE] ([NgayKiemKe], [MaNL], [SL], [DVT]) VALUES (CAST(0xA76C0000 AS SmallDateTime), N'MK11', 11, N'Lít')
INSERT [dbo].[CT_KIEMKE] ([NgayKiemKe], [MaNL], [SL], [DVT]) VALUES (CAST(0xA76C0000 AS SmallDateTime), N'MK12', 9, N'Kg')
INSERT [dbo].[CT_KIEMKE] ([NgayKiemKe], [MaNL], [SL], [DVT]) VALUES (CAST(0xA76C0000 AS SmallDateTime), N'MK13', 10, N'Kg')
INSERT [dbo].[CT_KIEMKE] ([NgayKiemKe], [MaNL], [SL], [DVT]) VALUES (CAST(0xA76C0000 AS SmallDateTime), N'MK14', 5, N'Kg')
INSERT [dbo].[CT_KIEMKE] ([NgayKiemKe], [MaNL], [SL], [DVT]) VALUES (CAST(0xA76C0000 AS SmallDateTime), N'MK15', 3, N'Kg')
INSERT [dbo].[CT_KIEMKE] ([NgayKiemKe], [MaNL], [SL], [DVT]) VALUES (CAST(0xA76C0000 AS SmallDateTime), N'MK16', 7, N'Kg')
INSERT [dbo].[CT_KIEMKE] ([NgayKiemKe], [MaNL], [SL], [DVT]) VALUES (CAST(0xA76C0000 AS SmallDateTime), N'MK17', 9, N'Kg')
INSERT [dbo].[CT_KIEMKE] ([NgayKiemKe], [MaNL], [SL], [DVT]) VALUES (CAST(0xA76C0000 AS SmallDateTime), N'MK18', 10, N'Kg')
INSERT [dbo].[CT_KIEMKE] ([NgayKiemKe], [MaNL], [SL], [DVT]) VALUES (CAST(0xA76C0000 AS SmallDateTime), N'MK19', 8, N'Kg')
INSERT [dbo].[CT_KIEMKE] ([NgayKiemKe], [MaNL], [SL], [DVT]) VALUES (CAST(0xA7720000 AS SmallDateTime), N'MK01', 5, N'Kg')
INSERT [dbo].[CT_KIEMKE] ([NgayKiemKe], [MaNL], [SL], [DVT]) VALUES (CAST(0xA7720000 AS SmallDateTime), N'MK02', 10, N'Chai')
INSERT [dbo].[CT_KIEMKE] ([NgayKiemKe], [MaNL], [SL], [DVT]) VALUES (CAST(0xA7720000 AS SmallDateTime), N'MK03', 10, N'Kg')
INSERT [dbo].[CT_KIEMKE] ([NgayKiemKe], [MaNL], [SL], [DVT]) VALUES (CAST(0xA7720000 AS SmallDateTime), N'MK04', 7, N'Kg')
INSERT [dbo].[CT_KIEMKE] ([NgayKiemKe], [MaNL], [SL], [DVT]) VALUES (CAST(0xA7720000 AS SmallDateTime), N'MK05', 8, N'Kg')
INSERT [dbo].[CT_KIEMKE] ([NgayKiemKe], [MaNL], [SL], [DVT]) VALUES (CAST(0xA7720000 AS SmallDateTime), N'MK06', 12, N'Kg')
INSERT [dbo].[CT_KIEMKE] ([NgayKiemKe], [MaNL], [SL], [DVT]) VALUES (CAST(0xA7720000 AS SmallDateTime), N'MK07', 6, N'Kg')
INSERT [dbo].[CT_KIEMKE] ([NgayKiemKe], [MaNL], [SL], [DVT]) VALUES (CAST(0xA7720000 AS SmallDateTime), N'MK08', 3, N'Kg')
INSERT [dbo].[CT_KIEMKE] ([NgayKiemKe], [MaNL], [SL], [DVT]) VALUES (CAST(0xA7720000 AS SmallDateTime), N'MK09', 9, N'Kg')
INSERT [dbo].[CT_KIEMKE] ([NgayKiemKe], [MaNL], [SL], [DVT]) VALUES (CAST(0xA7720000 AS SmallDateTime), N'MK10', 8, N'Lít')
INSERT [dbo].[CT_KIEMKE] ([NgayKiemKe], [MaNL], [SL], [DVT]) VALUES (CAST(0xA7720000 AS SmallDateTime), N'MK11', 11, N'Lít')
INSERT [dbo].[CT_KIEMKE] ([NgayKiemKe], [MaNL], [SL], [DVT]) VALUES (CAST(0xA7720000 AS SmallDateTime), N'MK12', 9, N'Kg')
INSERT [dbo].[CT_KIEMKE] ([NgayKiemKe], [MaNL], [SL], [DVT]) VALUES (CAST(0xA7720000 AS SmallDateTime), N'MK13', 10, N'Kg')
INSERT [dbo].[CT_KIEMKE] ([NgayKiemKe], [MaNL], [SL], [DVT]) VALUES (CAST(0xA7720000 AS SmallDateTime), N'MK14', 5, N'Kg')
INSERT [dbo].[CT_KIEMKE] ([NgayKiemKe], [MaNL], [SL], [DVT]) VALUES (CAST(0xA7720000 AS SmallDateTime), N'MK15', 3, N'Kg')
INSERT [dbo].[CT_KIEMKE] ([NgayKiemKe], [MaNL], [SL], [DVT]) VALUES (CAST(0xA7720000 AS SmallDateTime), N'MK16', 7, N'Kg')
INSERT [dbo].[CT_KIEMKE] ([NgayKiemKe], [MaNL], [SL], [DVT]) VALUES (CAST(0xA7720000 AS SmallDateTime), N'MK17', 9, N'Kg')
INSERT [dbo].[CT_KIEMKE] ([NgayKiemKe], [MaNL], [SL], [DVT]) VALUES (CAST(0xA7720000 AS SmallDateTime), N'MK18', 10, N'Kg')
INSERT [dbo].[CT_KIEMKE] ([NgayKiemKe], [MaNL], [SL], [DVT]) VALUES (CAST(0xA7720000 AS SmallDateTime), N'MK19', 8, N'Kg')
INSERT [dbo].[CT_KIEMKE] ([NgayKiemKe], [MaNL], [SL], [DVT]) VALUES (CAST(0xA77A0000 AS SmallDateTime), N'MK01', 5, N'Kg')
INSERT [dbo].[CT_KIEMKE] ([NgayKiemKe], [MaNL], [SL], [DVT]) VALUES (CAST(0xA77A0000 AS SmallDateTime), N'MK02', 10, N'Chai')
INSERT [dbo].[CT_KIEMKE] ([NgayKiemKe], [MaNL], [SL], [DVT]) VALUES (CAST(0xA77A0000 AS SmallDateTime), N'MK03', 10, N'Kg')
INSERT [dbo].[CT_KIEMKE] ([NgayKiemKe], [MaNL], [SL], [DVT]) VALUES (CAST(0xA77A0000 AS SmallDateTime), N'MK04', 7, N'Kg')
INSERT [dbo].[CT_KIEMKE] ([NgayKiemKe], [MaNL], [SL], [DVT]) VALUES (CAST(0xA77A0000 AS SmallDateTime), N'MK05', 8, N'Kg')
INSERT [dbo].[CT_KIEMKE] ([NgayKiemKe], [MaNL], [SL], [DVT]) VALUES (CAST(0xA77A0000 AS SmallDateTime), N'MK06', 12, N'Kg')
INSERT [dbo].[CT_KIEMKE] ([NgayKiemKe], [MaNL], [SL], [DVT]) VALUES (CAST(0xA77A0000 AS SmallDateTime), N'MK07', 6, N'Kg')
INSERT [dbo].[CT_KIEMKE] ([NgayKiemKe], [MaNL], [SL], [DVT]) VALUES (CAST(0xA77A0000 AS SmallDateTime), N'MK08', 3, N'Kg')
INSERT [dbo].[CT_KIEMKE] ([NgayKiemKe], [MaNL], [SL], [DVT]) VALUES (CAST(0xA77A0000 AS SmallDateTime), N'MK09', 9, N'Kg')
INSERT [dbo].[CT_KIEMKE] ([NgayKiemKe], [MaNL], [SL], [DVT]) VALUES (CAST(0xA77A0000 AS SmallDateTime), N'MK10', 8, N'Lít')
INSERT [dbo].[CT_KIEMKE] ([NgayKiemKe], [MaNL], [SL], [DVT]) VALUES (CAST(0xA77A0000 AS SmallDateTime), N'MK11', 11, N'Lít')
INSERT [dbo].[CT_KIEMKE] ([NgayKiemKe], [MaNL], [SL], [DVT]) VALUES (CAST(0xA77A0000 AS SmallDateTime), N'MK12', 9, N'Kg')
INSERT [dbo].[CT_KIEMKE] ([NgayKiemKe], [MaNL], [SL], [DVT]) VALUES (CAST(0xA77A0000 AS SmallDateTime), N'MK13', 10, N'Kg')
INSERT [dbo].[CT_KIEMKE] ([NgayKiemKe], [MaNL], [SL], [DVT]) VALUES (CAST(0xA77A0000 AS SmallDateTime), N'MK14', 5, N'Kg')
INSERT [dbo].[CT_KIEMKE] ([NgayKiemKe], [MaNL], [SL], [DVT]) VALUES (CAST(0xA77A0000 AS SmallDateTime), N'MK15', 3, N'Kg')
INSERT [dbo].[CT_KIEMKE] ([NgayKiemKe], [MaNL], [SL], [DVT]) VALUES (CAST(0xA77A0000 AS SmallDateTime), N'MK16', 7, N'Kg')
INSERT [dbo].[CT_KIEMKE] ([NgayKiemKe], [MaNL], [SL], [DVT]) VALUES (CAST(0xA77A0000 AS SmallDateTime), N'MK17', 9, N'Kg')
INSERT [dbo].[CT_KIEMKE] ([NgayKiemKe], [MaNL], [SL], [DVT]) VALUES (CAST(0xA77A0000 AS SmallDateTime), N'MK18', 10, N'Kg')
INSERT [dbo].[CT_KIEMKE] ([NgayKiemKe], [MaNL], [SL], [DVT]) VALUES (CAST(0xA77A0000 AS SmallDateTime), N'MK19', 8, N'Kg')
INSERT [dbo].[CT_NL] ([MAMA], [MaNL], [SoLuong]) VALUES (1, N'MK01', 0.1)
INSERT [dbo].[CT_NL] ([MAMA], [MaNL], [SoLuong]) VALUES (2, N'MK02', 0.1)
INSERT [dbo].[CT_NL] ([MAMA], [MaNL], [SoLuong]) VALUES (3, N'MK03', 0.1)
INSERT [dbo].[CT_NL] ([MAMA], [MaNL], [SoLuong]) VALUES (4, N'MK04', 0.1)
INSERT [dbo].[CT_NL] ([MAMA], [MaNL], [SoLuong]) VALUES (5, N'MK05', 0.1)
INSERT [dbo].[CT_NL] ([MAMA], [MaNL], [SoLuong]) VALUES (6, N'MK06', 0.1)
INSERT [dbo].[CT_NL] ([MAMA], [MaNL], [SoLuong]) VALUES (7, N'MK07', 0.1)
INSERT [dbo].[CT_NL] ([MAMA], [MaNL], [SoLuong]) VALUES (8, N'MK08', 0.1)
INSERT [dbo].[CT_NL] ([MAMA], [MaNL], [SoLuong]) VALUES (9, N'MK09', 0.1)
INSERT [dbo].[CT_NL] ([MAMA], [MaNL], [SoLuong]) VALUES (10, N'MK10', 0.1)
INSERT [dbo].[CT_NL] ([MAMA], [MaNL], [SoLuong]) VALUES (11, N'MK11', 0.1)
INSERT [dbo].[CT_NL] ([MAMA], [MaNL], [SoLuong]) VALUES (12, N'MK12', 0.1)
INSERT [dbo].[CT_NL] ([MAMA], [MaNL], [SoLuong]) VALUES (13, N'MK13', 0.1)
INSERT [dbo].[CT_NL] ([MAMA], [MaNL], [SoLuong]) VALUES (14, N'MK14', 0.1)
INSERT [dbo].[CT_NL] ([MAMA], [MaNL], [SoLuong]) VALUES (15, N'MK15', 0.1)
INSERT [dbo].[CT_NL] ([MAMA], [MaNL], [SoLuong]) VALUES (16, N'MK16', 0.1)
INSERT [dbo].[CT_NL] ([MAMA], [MaNL], [SoLuong]) VALUES (17, N'MK17', 0.1)
INSERT [dbo].[CT_NL] ([MAMA], [MaNL], [SoLuong]) VALUES (18, N'MK18', 0.1)
INSERT [dbo].[CT_NL] ([MAMA], [MaNL], [SoLuong]) VALUES (19, N'MK19', 0.1)
INSERT [dbo].[CT_NL] ([MAMA], [MaNL], [SoLuong]) VALUES (20, N'MK20', 0.1)
INSERT [dbo].[CT_NL] ([MAMA], [MaNL], [SoLuong]) VALUES (21, N'MK01', 0.1)
INSERT [dbo].[CT_NL] ([MAMA], [MaNL], [SoLuong]) VALUES (22, N'MK02', 0.1)
INSERT [dbo].[CT_NL] ([MAMA], [MaNL], [SoLuong]) VALUES (23, N'MK03', 0.1)
INSERT [dbo].[CT_NL] ([MAMA], [MaNL], [SoLuong]) VALUES (24, N'MK04', 0.1)
INSERT [dbo].[CT_NL] ([MAMA], [MaNL], [SoLuong]) VALUES (32, N'MK12', 0.1)
INSERT [dbo].[CT_NL] ([MAMA], [MaNL], [SoLuong]) VALUES (38, N'MK18', 0.1)
INSERT [dbo].[CTDS_NHAPHANG] ([NgayNhapHang], [MaNL], [SL], [DVT], [XacNhan]) VALUES (CAST(0xA76C0000 AS SmallDateTime), N'MK01', 5, N'kg', 0)
INSERT [dbo].[CTDS_NHAPHANG] ([NgayNhapHang], [MaNL], [SL], [DVT], [XacNhan]) VALUES (CAST(0xA76C0000 AS SmallDateTime), N'MK02', 5, N'chai', 0)
INSERT [dbo].[CTDS_NHAPHANG] ([NgayNhapHang], [MaNL], [SL], [DVT], [XacNhan]) VALUES (CAST(0xA76C0000 AS SmallDateTime), N'MK03', 5, N'kg', 1)
INSERT [dbo].[CTDS_NHAPHANG] ([NgayNhapHang], [MaNL], [SL], [DVT], [XacNhan]) VALUES (CAST(0xA76C0000 AS SmallDateTime), N'MK04', 3, N'chai', 1)
INSERT [dbo].[CTDS_NHAPHANG] ([NgayNhapHang], [MaNL], [SL], [DVT], [XacNhan]) VALUES (CAST(0xA76C0000 AS SmallDateTime), N'MK05', 3, N'kg', 0)
INSERT [dbo].[CTDS_NHAPHANG] ([NgayNhapHang], [MaNL], [SL], [DVT], [XacNhan]) VALUES (CAST(0xA76C0000 AS SmallDateTime), N'MK06', 3, N'chai', 1)
INSERT [dbo].[CTDS_NHAPHANG] ([NgayNhapHang], [MaNL], [SL], [DVT], [XacNhan]) VALUES (CAST(0xA76C0000 AS SmallDateTime), N'MK12', 3, N'kg', 0)
INSERT [dbo].[CTDS_NHAPHANG] ([NgayNhapHang], [MaNL], [SL], [DVT], [XacNhan]) VALUES (CAST(0xA76C0000 AS SmallDateTime), N'MK13', 3, N'kg', 1)
INSERT [dbo].[CTDS_NHAPHANG] ([NgayNhapHang], [MaNL], [SL], [DVT], [XacNhan]) VALUES (CAST(0xA76C0000 AS SmallDateTime), N'MK14', 3, N'kg', 1)
INSERT [dbo].[CTDS_NHAPHANG] ([NgayNhapHang], [MaNL], [SL], [DVT], [XacNhan]) VALUES (CAST(0xA76C0000 AS SmallDateTime), N'MK15', 3, N'lít', 0)
INSERT [dbo].[CTDS_NHAPHANG] ([NgayNhapHang], [MaNL], [SL], [DVT], [XacNhan]) VALUES (CAST(0xA76C0000 AS SmallDateTime), N'MK16', 3, N'kg', 1)
INSERT [dbo].[CTDS_NHAPHANG] ([NgayNhapHang], [MaNL], [SL], [DVT], [XacNhan]) VALUES (CAST(0xA76C0000 AS SmallDateTime), N'MK17', 3, N'kg', 0)
INSERT [dbo].[CTDS_NHAPHANG] ([NgayNhapHang], [MaNL], [SL], [DVT], [XacNhan]) VALUES (CAST(0xA76C0000 AS SmallDateTime), N'MK18', 3, N'kg', 1)
INSERT [dbo].[CTDS_NHAPHANG] ([NgayNhapHang], [MaNL], [SL], [DVT], [XacNhan]) VALUES (CAST(0xA76C0000 AS SmallDateTime), N'MK19', 3, N'kg', 0)
SET IDENTITY_INSERT [dbo].[CTHD] ON 

INSERT [dbo].[CTHD] ([ID], [MAMA], [MAHD], [Soluong], [DVT]) VALUES (1, 1, 1, 3, N'ly')
INSERT [dbo].[CTHD] ([ID], [MAMA], [MAHD], [Soluong], [DVT]) VALUES (2, 2, 1, 2, N'ly')
INSERT [dbo].[CTHD] ([ID], [MAMA], [MAHD], [Soluong], [DVT]) VALUES (3, 3, 1, 3, N'ly')
INSERT [dbo].[CTHD] ([ID], [MAMA], [MAHD], [Soluong], [DVT]) VALUES (4, 4, 2, 1, N'ly')
INSERT [dbo].[CTHD] ([ID], [MAMA], [MAHD], [Soluong], [DVT]) VALUES (5, 1, 2, 2, N'ly')
INSERT [dbo].[CTHD] ([ID], [MAMA], [MAHD], [Soluong], [DVT]) VALUES (6, 3, 2, 1, N'ly')
INSERT [dbo].[CTHD] ([ID], [MAMA], [MAHD], [Soluong], [DVT]) VALUES (7, 4, 3, 2, N'ly')
INSERT [dbo].[CTHD] ([ID], [MAMA], [MAHD], [Soluong], [DVT]) VALUES (8, 2, 3, 2, N'ly')
INSERT [dbo].[CTHD] ([ID], [MAMA], [MAHD], [Soluong], [DVT]) VALUES (9, 1, 4, 3, N'ly')
INSERT [dbo].[CTHD] ([ID], [MAMA], [MAHD], [Soluong], [DVT]) VALUES (10, 2, 4, 3, N'ly')
INSERT [dbo].[CTHD] ([ID], [MAMA], [MAHD], [Soluong], [DVT]) VALUES (11, 1, 5, 3, N'ly')
INSERT [dbo].[CTHD] ([ID], [MAMA], [MAHD], [Soluong], [DVT]) VALUES (12, 2, 5, 3, N'ly')
INSERT [dbo].[CTHD] ([ID], [MAMA], [MAHD], [Soluong], [DVT]) VALUES (13, 2, 6, 3, N'ly')
INSERT [dbo].[CTHD] ([ID], [MAMA], [MAHD], [Soluong], [DVT]) VALUES (14, 3, 6, 3, N'ly')
INSERT [dbo].[CTHD] ([ID], [MAMA], [MAHD], [Soluong], [DVT]) VALUES (15, 1, 6, 3, N'ly')
INSERT [dbo].[CTHD] ([ID], [MAMA], [MAHD], [Soluong], [DVT]) VALUES (16, 2, 7, 3, N'ly')
INSERT [dbo].[CTHD] ([ID], [MAMA], [MAHD], [Soluong], [DVT]) VALUES (17, 3, 7, 3, N'ly')
INSERT [dbo].[CTHD] ([ID], [MAMA], [MAHD], [Soluong], [DVT]) VALUES (18, 1, 7, 3, N'ly')
INSERT [dbo].[CTHD] ([ID], [MAMA], [MAHD], [Soluong], [DVT]) VALUES (19, 1, 10, 1, N'Ly')
INSERT [dbo].[CTHD] ([ID], [MAMA], [MAHD], [Soluong], [DVT]) VALUES (20, 2, 10, 2, N'Ly')
INSERT [dbo].[CTHD] ([ID], [MAMA], [MAHD], [Soluong], [DVT]) VALUES (21, 3, 10, 1, N'Ly')
INSERT [dbo].[CTHD] ([ID], [MAMA], [MAHD], [Soluong], [DVT]) VALUES (22, 1, 11, 1, N'Ly')
INSERT [dbo].[CTHD] ([ID], [MAMA], [MAHD], [Soluong], [DVT]) VALUES (23, 2, 11, 2, N'Ly')
INSERT [dbo].[CTHD] ([ID], [MAMA], [MAHD], [Soluong], [DVT]) VALUES (24, 3, 11, 2, N'Ly')
INSERT [dbo].[CTHD] ([ID], [MAMA], [MAHD], [Soluong], [DVT]) VALUES (25, 4, 11, 1, N'Ly')
INSERT [dbo].[CTHD] ([ID], [MAMA], [MAHD], [Soluong], [DVT]) VALUES (26, 5, 11, 2, N'Ly')
INSERT [dbo].[CTHD] ([ID], [MAMA], [MAHD], [Soluong], [DVT]) VALUES (27, 1, 12, 1, N'Ly')
INSERT [dbo].[CTHD] ([ID], [MAMA], [MAHD], [Soluong], [DVT]) VALUES (28, 2, 12, 2, N'Ly')
INSERT [dbo].[CTHD] ([ID], [MAMA], [MAHD], [Soluong], [DVT]) VALUES (29, 4, 12, 3, N'Ly')
INSERT [dbo].[CTHD] ([ID], [MAMA], [MAHD], [Soluong], [DVT]) VALUES (30, 15, 12, 7, N'Ly')
INSERT [dbo].[CTHD] ([ID], [MAMA], [MAHD], [Soluong], [DVT]) VALUES (31, 16, 13, 1, N'Ly')
INSERT [dbo].[CTHD] ([ID], [MAMA], [MAHD], [Soluong], [DVT]) VALUES (32, 15, 13, 2, N'Ly')
INSERT [dbo].[CTHD] ([ID], [MAMA], [MAHD], [Soluong], [DVT]) VALUES (33, 17, 13, 6, N'Ly')
INSERT [dbo].[CTHD] ([ID], [MAMA], [MAHD], [Soluong], [DVT]) VALUES (34, 15, 14, 1, N'Ly')
INSERT [dbo].[CTHD] ([ID], [MAMA], [MAHD], [Soluong], [DVT]) VALUES (35, 20, 14, 1, N'Ly')
INSERT [dbo].[CTHD] ([ID], [MAMA], [MAHD], [Soluong], [DVT]) VALUES (36, 21, 14, 3, N'Ly')
INSERT [dbo].[CTHD] ([ID], [MAMA], [MAHD], [Soluong], [DVT]) VALUES (37, 19, 14, 3, N'Ly')
INSERT [dbo].[CTHD] ([ID], [MAMA], [MAHD], [Soluong], [DVT]) VALUES (38, 4, 15, 2, N'Ly')
INSERT [dbo].[CTHD] ([ID], [MAMA], [MAHD], [Soluong], [DVT]) VALUES (39, 8, 15, 1, N'Ly')
INSERT [dbo].[CTHD] ([ID], [MAMA], [MAHD], [Soluong], [DVT]) VALUES (40, 17, 15, 1, N'Ly')
INSERT [dbo].[CTHD] ([ID], [MAMA], [MAHD], [Soluong], [DVT]) VALUES (41, 18, 15, 1, N'Ly')
INSERT [dbo].[CTHD] ([ID], [MAMA], [MAHD], [Soluong], [DVT]) VALUES (42, 20, 15, 1, N'Ly')
INSERT [dbo].[CTHD] ([ID], [MAMA], [MAHD], [Soluong], [DVT]) VALUES (43, 13, 15, 1, N'Ly')
INSERT [dbo].[CTHD] ([ID], [MAMA], [MAHD], [Soluong], [DVT]) VALUES (44, 12, 15, 1, N'Ly')
INSERT [dbo].[CTHD] ([ID], [MAMA], [MAHD], [Soluong], [DVT]) VALUES (45, 16, 16, 2, N'Ly')
INSERT [dbo].[CTHD] ([ID], [MAMA], [MAHD], [Soluong], [DVT]) VALUES (46, 12, 16, 1, N'Ly')
INSERT [dbo].[CTHD] ([ID], [MAMA], [MAHD], [Soluong], [DVT]) VALUES (47, 4, 16, 1, N'Ly')
INSERT [dbo].[CTHD] ([ID], [MAMA], [MAHD], [Soluong], [DVT]) VALUES (48, 7, 16, 1, N'Ly')
INSERT [dbo].[CTHD] ([ID], [MAMA], [MAHD], [Soluong], [DVT]) VALUES (49, 11, 16, 3, N'Ly')
INSERT [dbo].[CTHD] ([ID], [MAMA], [MAHD], [Soluong], [DVT]) VALUES (50, 20, 16, 4, N'Ly')
INSERT [dbo].[CTHD] ([ID], [MAMA], [MAHD], [Soluong], [DVT]) VALUES (51, 21, 16, 2, N'Ly')
INSERT [dbo].[CTHD] ([ID], [MAMA], [MAHD], [Soluong], [DVT]) VALUES (52, 24, 16, 1, N'Ly')
INSERT [dbo].[CTHD] ([ID], [MAMA], [MAHD], [Soluong], [DVT]) VALUES (53, 38, 16, 2, N'Ly')
INSERT [dbo].[CTHD] ([ID], [MAMA], [MAHD], [Soluong], [DVT]) VALUES (54, 32, 16, 2, N'ly')
INSERT [dbo].[CTHD] ([ID], [MAMA], [MAHD], [Soluong], [DVT]) VALUES (55, 14, 16, 1, N'Ly')
INSERT [dbo].[CTHD] ([ID], [MAMA], [MAHD], [Soluong], [DVT]) VALUES (56, 15, 16, 1, N'Ly')
INSERT [dbo].[CTHD] ([ID], [MAMA], [MAHD], [Soluong], [DVT]) VALUES (57, 10, 17, 2, N'Ly')
INSERT [dbo].[CTHD] ([ID], [MAMA], [MAHD], [Soluong], [DVT]) VALUES (58, 11, 17, 2, N'Ly')
INSERT [dbo].[CTHD] ([ID], [MAMA], [MAHD], [Soluong], [DVT]) VALUES (59, 12, 17, 2, N'Ly')
INSERT [dbo].[CTHD] ([ID], [MAMA], [MAHD], [Soluong], [DVT]) VALUES (60, 12, 18, 1, N'Ly')
INSERT [dbo].[CTHD] ([ID], [MAMA], [MAHD], [Soluong], [DVT]) VALUES (61, 13, 18, 3, N'Ly')
INSERT [dbo].[CTHD] ([ID], [MAMA], [MAHD], [Soluong], [DVT]) VALUES (62, 14, 18, 3, N'Ly')
INSERT [dbo].[CTHD] ([ID], [MAMA], [MAHD], [Soluong], [DVT]) VALUES (63, 15, 18, 1, N'Ly')
INSERT [dbo].[CTHD] ([ID], [MAMA], [MAHD], [Soluong], [DVT]) VALUES (64, 2, 19, 3, N'Ly')
INSERT [dbo].[CTHD] ([ID], [MAMA], [MAHD], [Soluong], [DVT]) VALUES (65, 1, 19, 1, N'Ly')
INSERT [dbo].[CTHD] ([ID], [MAMA], [MAHD], [Soluong], [DVT]) VALUES (66, 3, 19, 6, N'Ly')
INSERT [dbo].[CTHD] ([ID], [MAMA], [MAHD], [Soluong], [DVT]) VALUES (67, 5, 19, 1, N'Ly')
INSERT [dbo].[CTHD] ([ID], [MAMA], [MAHD], [Soluong], [DVT]) VALUES (68, 4, 19, 1, N'Ly')
INSERT [dbo].[CTHD] ([ID], [MAMA], [MAHD], [Soluong], [DVT]) VALUES (69, 4, 20, 4, N'Ly')
INSERT [dbo].[CTHD] ([ID], [MAMA], [MAHD], [Soluong], [DVT]) VALUES (70, 5, 20, 2, N'Ly')
INSERT [dbo].[CTHD] ([ID], [MAMA], [MAHD], [Soluong], [DVT]) VALUES (71, 1, 20, 1, N'Ly')
INSERT [dbo].[CTHD] ([ID], [MAMA], [MAHD], [Soluong], [DVT]) VALUES (72, 5, 21, 2, N'Ly')
INSERT [dbo].[CTHD] ([ID], [MAMA], [MAHD], [Soluong], [DVT]) VALUES (73, 4, 21, 8, N'Ly')
INSERT [dbo].[CTHD] ([ID], [MAMA], [MAHD], [Soluong], [DVT]) VALUES (74, 15, 21, 2, N'Ly')
INSERT [dbo].[CTHD] ([ID], [MAMA], [MAHD], [Soluong], [DVT]) VALUES (75, 20, 21, 4, N'Ly')
INSERT [dbo].[CTHD] ([ID], [MAMA], [MAHD], [Soluong], [DVT]) VALUES (76, 39, 21, 2, N'tô')
INSERT [dbo].[CTHD] ([ID], [MAMA], [MAHD], [Soluong], [DVT]) VALUES (77, 38, 21, 3, N'Ly')
INSERT [dbo].[CTHD] ([ID], [MAMA], [MAHD], [Soluong], [DVT]) VALUES (78, 32, 21, 2, N'ly')
INSERT [dbo].[CTHD] ([ID], [MAMA], [MAHD], [Soluong], [DVT]) VALUES (79, 24, 21, 3, N'Ly')
INSERT [dbo].[CTHD] ([ID], [MAMA], [MAHD], [Soluong], [DVT]) VALUES (80, 22, 21, 3, N'Ly')
INSERT [dbo].[CTHD] ([ID], [MAMA], [MAHD], [Soluong], [DVT]) VALUES (81, 21, 21, 1, N'Ly')
INSERT [dbo].[CTHD] ([ID], [MAMA], [MAHD], [Soluong], [DVT]) VALUES (82, 19, 21, 3, N'Ly')
SET IDENTITY_INSERT [dbo].[CTHD] OFF
INSERT [dbo].[DANHSACH_NHAPHANG] ([NgayNhapHang], [TenTK]) VALUES (CAST(0xA7690000 AS SmallDateTime), N'admin')
INSERT [dbo].[DANHSACH_NHAPHANG] ([NgayNhapHang], [TenTK]) VALUES (CAST(0xA76A0000 AS SmallDateTime), N'admin')
INSERT [dbo].[DANHSACH_NHAPHANG] ([NgayNhapHang], [TenTK]) VALUES (CAST(0xA76B0000 AS SmallDateTime), N'admin')
INSERT [dbo].[DANHSACH_NHAPHANG] ([NgayNhapHang], [TenTK]) VALUES (CAST(0xA76C0000 AS SmallDateTime), N'admin')
SET IDENTITY_INSERT [dbo].[DIEMDANH] ON 

INSERT [dbo].[DIEMDANH] ([MADD], [NGAY]) VALUES (1, CAST(0xA77F0000 AS SmallDateTime))
INSERT [dbo].[DIEMDANH] ([MADD], [NGAY]) VALUES (2, CAST(0xA78A0000 AS SmallDateTime))
INSERT [dbo].[DIEMDANH] ([MADD], [NGAY]) VALUES (3, CAST(0xA7890000 AS SmallDateTime))
INSERT [dbo].[DIEMDANH] ([MADD], [NGAY]) VALUES (4, CAST(0xA7880000 AS SmallDateTime))
INSERT [dbo].[DIEMDANH] ([MADD], [NGAY]) VALUES (5, CAST(0xA7850000 AS SmallDateTime))
INSERT [dbo].[DIEMDANH] ([MADD], [NGAY]) VALUES (6, CAST(0xA7840000 AS SmallDateTime))
INSERT [dbo].[DIEMDANH] ([MADD], [NGAY]) VALUES (7, CAST(0xA7830000 AS SmallDateTime))
INSERT [dbo].[DIEMDANH] ([MADD], [NGAY]) VALUES (8, CAST(0xA7810000 AS SmallDateTime))
SET IDENTITY_INSERT [dbo].[DIEMDANH] OFF
SET IDENTITY_INSERT [dbo].[HOADON] ON 

INSERT [dbo].[HOADON] ([MAHD], [DateCheckIn], [DateCheckOut], [GiamGia], [MABA], [status]) VALUES (1, CAST(0xA77E04B9 AS SmallDateTime), NULL, NULL, 3, 1)
INSERT [dbo].[HOADON] ([MAHD], [DateCheckIn], [DateCheckOut], [GiamGia], [MABA], [status]) VALUES (2, CAST(0xA77E04B9 AS SmallDateTime), NULL, NULL, 4, 1)
INSERT [dbo].[HOADON] ([MAHD], [DateCheckIn], [DateCheckOut], [GiamGia], [MABA], [status]) VALUES (3, CAST(0xA77E04B9 AS SmallDateTime), CAST(0xA77E04B9 AS SmallDateTime), NULL, 5, 1)
INSERT [dbo].[HOADON] ([MAHD], [DateCheckIn], [DateCheckOut], [GiamGia], [MABA], [status]) VALUES (4, CAST(0xA77E04B9 AS SmallDateTime), NULL, NULL, 1, 1)
INSERT [dbo].[HOADON] ([MAHD], [DateCheckIn], [DateCheckOut], [GiamGia], [MABA], [status]) VALUES (5, CAST(0xA77E04B9 AS SmallDateTime), NULL, NULL, 2, 1)
INSERT [dbo].[HOADON] ([MAHD], [DateCheckIn], [DateCheckOut], [GiamGia], [MABA], [status]) VALUES (6, CAST(0xA77E04B9 AS SmallDateTime), NULL, NULL, 6, 1)
INSERT [dbo].[HOADON] ([MAHD], [DateCheckIn], [DateCheckOut], [GiamGia], [MABA], [status]) VALUES (7, CAST(0xA77E04B9 AS SmallDateTime), NULL, NULL, 7, 1)
INSERT [dbo].[HOADON] ([MAHD], [DateCheckIn], [DateCheckOut], [GiamGia], [MABA], [status]) VALUES (9, CAST(0xA783041C AS SmallDateTime), NULL, NULL, 17, 1)
INSERT [dbo].[HOADON] ([MAHD], [DateCheckIn], [DateCheckOut], [GiamGia], [MABA], [status]) VALUES (10, CAST(0xA7830467 AS SmallDateTime), NULL, NULL, 16, 1)
INSERT [dbo].[HOADON] ([MAHD], [DateCheckIn], [DateCheckOut], [GiamGia], [MABA], [status]) VALUES (11, CAST(0xA78A037C AS SmallDateTime), NULL, NULL, 19, 1)
INSERT [dbo].[HOADON] ([MAHD], [DateCheckIn], [DateCheckOut], [GiamGia], [MABA], [status]) VALUES (12, CAST(0xA78A037C AS SmallDateTime), NULL, NULL, 32, 1)
INSERT [dbo].[HOADON] ([MAHD], [DateCheckIn], [DateCheckOut], [GiamGia], [MABA], [status]) VALUES (13, CAST(0xA78A037C AS SmallDateTime), NULL, NULL, 12, 1)
INSERT [dbo].[HOADON] ([MAHD], [DateCheckIn], [DateCheckOut], [GiamGia], [MABA], [status]) VALUES (14, CAST(0xA78A037D AS SmallDateTime), NULL, NULL, 37, 1)
INSERT [dbo].[HOADON] ([MAHD], [DateCheckIn], [DateCheckOut], [GiamGia], [MABA], [status]) VALUES (15, CAST(0xA78A0394 AS SmallDateTime), NULL, NULL, 24, 1)
INSERT [dbo].[HOADON] ([MAHD], [DateCheckIn], [DateCheckOut], [GiamGia], [MABA], [status]) VALUES (16, CAST(0xA78A0394 AS SmallDateTime), NULL, NULL, 27, 1)
INSERT [dbo].[HOADON] ([MAHD], [DateCheckIn], [DateCheckOut], [GiamGia], [MABA], [status]) VALUES (17, CAST(0xA78A0395 AS SmallDateTime), NULL, NULL, 23, 0)
INSERT [dbo].[HOADON] ([MAHD], [DateCheckIn], [DateCheckOut], [GiamGia], [MABA], [status]) VALUES (18, CAST(0xA78A0395 AS SmallDateTime), NULL, NULL, 18, 0)
INSERT [dbo].[HOADON] ([MAHD], [DateCheckIn], [DateCheckOut], [GiamGia], [MABA], [status]) VALUES (19, CAST(0xA78A0444 AS SmallDateTime), NULL, NULL, 35, 0)
INSERT [dbo].[HOADON] ([MAHD], [DateCheckIn], [DateCheckOut], [GiamGia], [MABA], [status]) VALUES (20, CAST(0xA78A0445 AS SmallDateTime), NULL, NULL, 16, 0)
INSERT [dbo].[HOADON] ([MAHD], [DateCheckIn], [DateCheckOut], [GiamGia], [MABA], [status]) VALUES (21, CAST(0xA78A050F AS SmallDateTime), NULL, NULL, 26, 1)
SET IDENTITY_INSERT [dbo].[HOADON] OFF
SET IDENTITY_INSERT [dbo].[KHUVUC] ON 

INSERT [dbo].[KHUVUC] ([MAKV], [TENKV]) VALUES (1, N'Sân vườn')
INSERT [dbo].[KHUVUC] ([MAKV], [TENKV]) VALUES (2, N'Máy lạnh')
INSERT [dbo].[KHUVUC] ([MAKV], [TENKV]) VALUES (3, N'Sân sau')
SET IDENTITY_INSERT [dbo].[KHUVUC] OFF
INSERT [dbo].[KIEMKE] ([NgayKiemKe], [TenTK]) VALUES (CAST(0xA76C0000 AS SmallDateTime), N'admin')
INSERT [dbo].[KIEMKE] ([NgayKiemKe], [TenTK]) VALUES (CAST(0xA7720000 AS SmallDateTime), N'admin')
INSERT [dbo].[KIEMKE] ([NgayKiemKe], [TenTK]) VALUES (CAST(0xA77A0000 AS SmallDateTime), N'admin')
SET IDENTITY_INSERT [dbo].[LOAIMON] ON 

INSERT [dbo].[LOAIMON] ([MALOAI], [TENLOAI]) VALUES (1, N'Cafe')
INSERT [dbo].[LOAIMON] ([MALOAI], [TENLOAI]) VALUES (2, N'Trà sữa')
INSERT [dbo].[LOAIMON] ([MALOAI], [TENLOAI]) VALUES (3, N'Chè')
INSERT [dbo].[LOAIMON] ([MALOAI], [TENLOAI]) VALUES (4, N'Cacao')
INSERT [dbo].[LOAIMON] ([MALOAI], [TENLOAI]) VALUES (5, N'Nước ép')
INSERT [dbo].[LOAIMON] ([MALOAI], [TENLOAI]) VALUES (6, N'Sinh tố')
INSERT [dbo].[LOAIMON] ([MALOAI], [TENLOAI]) VALUES (9, N'Nước trái cây')
INSERT [dbo].[LOAIMON] ([MALOAI], [TENLOAI]) VALUES (10, N'Yagout')
INSERT [dbo].[LOAIMON] ([MALOAI], [TENLOAI]) VALUES (11, N'Cơm')
INSERT [dbo].[LOAIMON] ([MALOAI], [TENLOAI]) VALUES (12, N'Mì cay')
SET IDENTITY_INSERT [dbo].[LOAIMON] OFF
SET IDENTITY_INSERT [dbo].[MONAN] ON 

INSERT [dbo].[MONAN] ([MAMA], [DonGia], [DVT], [TENMA], [MALOAI]) VALUES (1, 15000, N'Ly', N'Trà sữa chân châu', 2)
INSERT [dbo].[MONAN] ([MAMA], [DonGia], [DVT], [TENMA], [MALOAI]) VALUES (2, 14000, N'Ly', N'Trà sữa socola', 2)
INSERT [dbo].[MONAN] ([MAMA], [DonGia], [DVT], [TENMA], [MALOAI]) VALUES (3, 13000, N'Ly', N'Trà sữa nho', 2)
INSERT [dbo].[MONAN] ([MAMA], [DonGia], [DVT], [TENMA], [MALOAI]) VALUES (4, 12000, N'Ly', N'Trà sữa bạc hà', 2)
INSERT [dbo].[MONAN] ([MAMA], [DonGia], [DVT], [TENMA], [MALOAI]) VALUES (5, 11000, N'Ly', N'Trà sữa quất', 2)
INSERT [dbo].[MONAN] ([MAMA], [DonGia], [DVT], [TENMA], [MALOAI]) VALUES (6, 10000, N'Ly', N'Trà sữa bạc hà', 2)
INSERT [dbo].[MONAN] ([MAMA], [DonGia], [DVT], [TENMA], [MALOAI]) VALUES (7, 12000, N'Ly', N'Cafe đá', 1)
INSERT [dbo].[MONAN] ([MAMA], [DonGia], [DVT], [TENMA], [MALOAI]) VALUES (8, 13000, N'Ly', N'Cafe sữa', 1)
INSERT [dbo].[MONAN] ([MAMA], [DonGia], [DVT], [TENMA], [MALOAI]) VALUES (9, 14000, N'Ly', N'Cafe đen', 1)
INSERT [dbo].[MONAN] ([MAMA], [DonGia], [DVT], [TENMA], [MALOAI]) VALUES (10, 15000, N'Ly', N'Cafe đá xay', 1)
INSERT [dbo].[MONAN] ([MAMA], [DonGia], [DVT], [TENMA], [MALOAI]) VALUES (11, 16000, N'Ly', N'Chè thái', 3)
INSERT [dbo].[MONAN] ([MAMA], [DonGia], [DVT], [TENMA], [MALOAI]) VALUES (12, 17000, N'Ly', N'Chè thập cẩm', 3)
INSERT [dbo].[MONAN] ([MAMA], [DonGia], [DVT], [TENMA], [MALOAI]) VALUES (13, 18000, N'Ly', N'Chè đậu xanh', 3)
INSERT [dbo].[MONAN] ([MAMA], [DonGia], [DVT], [TENMA], [MALOAI]) VALUES (14, 19000, N'Ly', N'Chè đậu đen', 3)
INSERT [dbo].[MONAN] ([MAMA], [DonGia], [DVT], [TENMA], [MALOAI]) VALUES (15, 20000, N'Ly', N'Sinh tố dâu', 6)
INSERT [dbo].[MONAN] ([MAMA], [DonGia], [DVT], [TENMA], [MALOAI]) VALUES (16, 19000, N'Ly', N'Sinh tố bơ', 6)
INSERT [dbo].[MONAN] ([MAMA], [DonGia], [DVT], [TENMA], [MALOAI]) VALUES (17, 18000, N'Ly', N'Sinh tố Na', 6)
INSERT [dbo].[MONAN] ([MAMA], [DonGia], [DVT], [TENMA], [MALOAI]) VALUES (18, 17000, N'Ly', N'Sinh tố dứa', 6)
INSERT [dbo].[MONAN] ([MAMA], [DonGia], [DVT], [TENMA], [MALOAI]) VALUES (19, 16000, N'Ly', N'Sinh tố xoai', 6)
INSERT [dbo].[MONAN] ([MAMA], [DonGia], [DVT], [TENMA], [MALOAI]) VALUES (20, 15000, N'Ly', N'Sinh tố cam', 6)
INSERT [dbo].[MONAN] ([MAMA], [DonGia], [DVT], [TENMA], [MALOAI]) VALUES (21, 14000, N'Ly', N'Cam', 5)
INSERT [dbo].[MONAN] ([MAMA], [DonGia], [DVT], [TENMA], [MALOAI]) VALUES (22, 13000, N'Ly', N'ổi', 5)
INSERT [dbo].[MONAN] ([MAMA], [DonGia], [DVT], [TENMA], [MALOAI]) VALUES (23, 12000, N'Ly', N'Táo ', 5)
INSERT [dbo].[MONAN] ([MAMA], [DonGia], [DVT], [TENMA], [MALOAI]) VALUES (24, 11000, N'Ly', N'Dưa hấu', 5)
INSERT [dbo].[MONAN] ([MAMA], [DonGia], [DVT], [TENMA], [MALOAI]) VALUES (32, 25000, N'ly', N'Cafe capuchino', 1)
INSERT [dbo].[MONAN] ([MAMA], [DonGia], [DVT], [TENMA], [MALOAI]) VALUES (38, 16000, N'Ly', N'Cafe Phin', 1)
INSERT [dbo].[MONAN] ([MAMA], [DonGia], [DVT], [TENMA], [MALOAI]) VALUES (39, 12000, N'tô', N'Mì cay hàn quốc', 12)
SET IDENTITY_INSERT [dbo].[MONAN] OFF
INSERT [dbo].[NGUYENLIEU] ([MaNL], [TenNL], [NgayNhap], [TenTK]) VALUES (N'MK01', N'Duong', CAST(0xA76C0000 AS SmallDateTime), N'admin')
INSERT [dbo].[NGUYENLIEU] ([MaNL], [TenNL], [NgayNhap], [TenTK]) VALUES (N'MK02', N'Dau an', CAST(0xA76C0000 AS SmallDateTime), N'admin')
INSERT [dbo].[NGUYENLIEU] ([MaNL], [TenNL], [NgayNhap], [TenTK]) VALUES (N'MK03', N'Nho', CAST(0xA76C0000 AS SmallDateTime), N'admin')
INSERT [dbo].[NGUYENLIEU] ([MaNL], [TenNL], [NgayNhap], [TenTK]) VALUES (N'MK04', N'Tao', CAST(0xA76C0000 AS SmallDateTime), N'admin')
INSERT [dbo].[NGUYENLIEU] ([MaNL], [TenNL], [NgayNhap], [TenTK]) VALUES (N'MK05', N'Buoi', CAST(0xA76C0000 AS SmallDateTime), N'admin')
INSERT [dbo].[NGUYENLIEU] ([MaNL], [TenNL], [NgayNhap], [TenTK]) VALUES (N'MK06', N'Chuoi', CAST(0xA76C0000 AS SmallDateTime), N'admin')
INSERT [dbo].[NGUYENLIEU] ([MaNL], [TenNL], [NgayNhap], [TenTK]) VALUES (N'MK07', N'Cafe loai 1', CAST(0xA76C0000 AS SmallDateTime), N'admin')
INSERT [dbo].[NGUYENLIEU] ([MaNL], [TenNL], [NgayNhap], [TenTK]) VALUES (N'MK08', N'Cafe loai 2', CAST(0xA76C0000 AS SmallDateTime), N'admin')
INSERT [dbo].[NGUYENLIEU] ([MaNL], [TenNL], [NgayNhap], [TenTK]) VALUES (N'MK09', N'Cafe loai 3', CAST(0xA76C0000 AS SmallDateTime), N'admin')
INSERT [dbo].[NGUYENLIEU] ([MaNL], [TenNL], [NgayNhap], [TenTK]) VALUES (N'MK10', N'Mat ong', CAST(0xA76C0000 AS SmallDateTime), N'admin')
INSERT [dbo].[NGUYENLIEU] ([MaNL], [TenNL], [NgayNhap], [TenTK]) VALUES (N'MK11', N'Sua', CAST(0xA76C0000 AS SmallDateTime), N'admin')
INSERT [dbo].[NGUYENLIEU] ([MaNL], [TenNL], [NgayNhap], [TenTK]) VALUES (N'MK12', N'Kiwi', CAST(0xA76C0000 AS SmallDateTime), N'admin')
INSERT [dbo].[NGUYENLIEU] ([MaNL], [TenNL], [NgayNhap], [TenTK]) VALUES (N'MK13', N'Chanh', CAST(0xA76C0000 AS SmallDateTime), N'admin')
INSERT [dbo].[NGUYENLIEU] ([MaNL], [TenNL], [NgayNhap], [TenTK]) VALUES (N'MK14', N'Dau', CAST(0xA76C0000 AS SmallDateTime), N'admin')
INSERT [dbo].[NGUYENLIEU] ([MaNL], [TenNL], [NgayNhap], [TenTK]) VALUES (N'MK15', N'Du du', CAST(0xA76C0000 AS SmallDateTime), N'admin')
INSERT [dbo].[NGUYENLIEU] ([MaNL], [TenNL], [NgayNhap], [TenTK]) VALUES (N'MK16', N'Dua', CAST(0xA76C0000 AS SmallDateTime), N'admin')
INSERT [dbo].[NGUYENLIEU] ([MaNL], [TenNL], [NgayNhap], [TenTK]) VALUES (N'MK17', N'Ca cao', CAST(0xA76C0000 AS SmallDateTime), N'admin')
INSERT [dbo].[NGUYENLIEU] ([MaNL], [TenNL], [NgayNhap], [TenTK]) VALUES (N'MK18', N'Cam', CAST(0xA76C0000 AS SmallDateTime), N'admin')
INSERT [dbo].[NGUYENLIEU] ([MaNL], [TenNL], [NgayNhap], [TenTK]) VALUES (N'MK19', N'Xoai', CAST(0xA76C0000 AS SmallDateTime), N'admin')
INSERT [dbo].[NGUYENLIEU] ([MaNL], [TenNL], [NgayNhap], [TenTK]) VALUES (N'MK20', N'Mia', CAST(0xA77E0521 AS SmallDateTime), N'admin')
SET IDENTITY_INSERT [dbo].[NHANVIEN] ON 

INSERT [dbo].[NHANVIEN] ([MANV], [MACV], [HOTEN], [PHAI], [NGAYSINH], [CMND], [DIACHI], [DIENTHOAI], [LOAINV], [TINHTRANG], [TRANGTHAI]) VALUES (1, 1, N'Nguyễn Văn A', N'Nam', CAST(0x81790000 AS SmallDateTime), N'390282099', N'Long Bình, Bình Tân , TPHCM', N'099809765', N'Nhân viên thời vụ', 1, 1)
INSERT [dbo].[NHANVIEN] ([MANV], [MACV], [HOTEN], [PHAI], [NGAYSINH], [CMND], [DIACHI], [DIENTHOAI], [LOAINV], [TINHTRANG], [TRANGTHAI]) VALUES (2, 1, N'Nguyễn Thị B', N'Nữ', CAST(0x82480000 AS SmallDateTime), N'390282090', N'Trường Trinh, Bình Tân , TPHCM', N'099809765', N'Nhân viên thời vụ', 1, 1)
INSERT [dbo].[NHANVIEN] ([MANV], [MACV], [HOTEN], [PHAI], [NGAYSINH], [CMND], [DIACHI], [DIENTHOAI], [LOAINV], [TINHTRANG], [TRANGTHAI]) VALUES (3, 1, N'Trần Hải Đông', N'Nam', CAST(0x83FE0000 AS SmallDateTime), N'390002090', N'Bình Chánh, TPHCM', N'099009d999', N'Nhân viên thời vụ', 1, 1)
INSERT [dbo].[NHANVIEN] ([MANV], [MACV], [HOTEN], [PHAI], [NGAYSINH], [CMND], [DIACHI], [DIENTHOAI], [LOAINV], [TINHTRANG], [TRANGTHAI]) VALUES (4, 1, N'Phan Tử Đang', N'Nữ', CAST(0x81D50000 AS SmallDateTime), N'311112090', N'Phạm Ngọc Thạch , TPHCM', N'099556665', N'Nhân viên chính thức', 1, 1)
INSERT [dbo].[NHANVIEN] ([MANV], [MACV], [HOTEN], [PHAI], [NGAYSINH], [CMND], [DIACHI], [DIENTHOAI], [LOAINV], [TINHTRANG], [TRANGTHAI]) VALUES (5, 2, N'Trấn Thành', N'Nam', CAST(0x85470000 AS SmallDateTime), N'311112090', N'Da Liễu, TPHCM', N'0999999123', N'Nhân viên chính thức', 1, 1)
INSERT [dbo].[NHANVIEN] ([MANV], [MACV], [HOTEN], [PHAI], [NGAYSINH], [CMND], [DIACHI], [DIENTHOAI], [LOAINV], [TINHTRANG], [TRANGTHAI]) VALUES (6, 3, N'Phạm Hồng Phước', N'Nam', CAST(0xA7800000 AS SmallDateTime), N'3933332090', N'T? Vu , TPHCM', N'0122342324', N'Nhân viên chính thức', 1, 1)
INSERT [dbo].[NHANVIEN] ([MANV], [MACV], [HOTEN], [PHAI], [NGAYSINH], [CMND], [DIACHI], [DIENTHOAI], [LOAINV], [TINHTRANG], [TRANGTHAI]) VALUES (7, 3, N'Đàm Vĩnh Hưng', N'Nam', CAST(0x87C80000 AS SmallDateTime), N'555552090', N'Nhi?t Ð?i, TPHCM', N'0998555555', N'Nhân viên chính thức', 1, 1)
INSERT [dbo].[NHANVIEN] ([MANV], [MACV], [HOTEN], [PHAI], [NGAYSINH], [CMND], [DIACHI], [DIENTHOAI], [LOAINV], [TINHTRANG], [TRANGTHAI]) VALUES (8, 4, N'Nguyễn Sơn Tùng', N'Nam', CAST(0x73570000 AS SmallDateTime), N'390282090', N'Thái Bình', N'0969696979', N'Nhân viên chính thức', 1, 1)
INSERT [dbo].[NHANVIEN] ([MANV], [MACV], [HOTEN], [PHAI], [NGAYSINH], [CMND], [DIACHI], [DIENTHOAI], [LOAINV], [TINHTRANG], [TRANGTHAI]) VALUES (9, 1, N'Phan Tử Đang', N'Nữ', CAST(0x81D50000 AS SmallDateTime), N'311112090', N'Phạm Ngọc Thạch , TPHCM', N'099556665', N'Nhân Viên Chính Thức', 1, 1)
INSERT [dbo].[NHANVIEN] ([MANV], [MACV], [HOTEN], [PHAI], [NGAYSINH], [CMND], [DIACHI], [DIENTHOAI], [LOAINV], [TINHTRANG], [TRANGTHAI]) VALUES (10, 1, N'Nguyễn Văn A', N'Nam', CAST(0x81790000 AS SmallDateTime), N'390282099', N'Long Bình, Bình Tân , TPHCM', N'099809765', N'Nhân Viên Thời Vụ', 1, 0)
INSERT [dbo].[NHANVIEN] ([MANV], [MACV], [HOTEN], [PHAI], [NGAYSINH], [CMND], [DIACHI], [DIENTHOAI], [LOAINV], [TINHTRANG], [TRANGTHAI]) VALUES (11, 1, N'Nguyễn Văn A', N'Nam', CAST(0x81790000 AS SmallDateTime), N'390282099', N'Long Bình, Bình Tân , TPHCM', N'099809765', N'Nhân viên thời vụ', 1, 0)
INSERT [dbo].[NHANVIEN] ([MANV], [MACV], [HOTEN], [PHAI], [NGAYSINH], [CMND], [DIACHI], [DIENTHOAI], [LOAINV], [TINHTRANG], [TRANGTHAI]) VALUES (12, 1, N'Võ mạc sầu', N'Nam', CAST(0x82300000 AS SmallDateTime), N'390282099', N'Long Bình, Bình Tân , TPHCM', N'099809765', N'Nhân Viên Thời Vụ', 1, 1)
INSERT [dbo].[NHANVIEN] ([MANV], [MACV], [HOTEN], [PHAI], [NGAYSINH], [CMND], [DIACHI], [DIENTHOAI], [LOAINV], [TINHTRANG], [TRANGTHAI]) VALUES (13, 1, N'Trần Công Thuận', N'Nam', CAST(0x819E0000 AS SmallDateTime), N'390282099', N'Bình Định  Bình Tân , TPHCM', N'099809765', N'Nhân viên thời vụ', 1, 1)
INSERT [dbo].[NHANVIEN] ([MANV], [MACV], [HOTEN], [PHAI], [NGAYSINH], [CMND], [DIACHI], [DIENTHOAI], [LOAINV], [TINHTRANG], [TRANGTHAI]) VALUES (14, 1, N'Chầu Nhuận Phát', N'Nam', CAST(0x8CE30000 AS SmallDateTime), N'390282099', N'Long Bình, Bình Tân , TPHCM', N'099809765', N'Nhân viên thời vụ', 1, 1)
INSERT [dbo].[NHANVIEN] ([MANV], [MACV], [HOTEN], [PHAI], [NGAYSINH], [CMND], [DIACHI], [DIENTHOAI], [LOAINV], [TINHTRANG], [TRANGTHAI]) VALUES (15, 1, N'Lưu Đức Hòa', N'Nam', CAST(0x818C0000 AS SmallDateTime), N'390282099', N'Long Khánh, TPHCM', N'099809765', N'Nhân viên thời vụ', 1, 1)
INSERT [dbo].[NHANVIEN] ([MANV], [MACV], [HOTEN], [PHAI], [NGAYSINH], [CMND], [DIACHI], [DIENTHOAI], [LOAINV], [TINHTRANG], [TRANGTHAI]) VALUES (16, 1, N'Trần Thị Xoan', N'Nữ', CAST(0x89EA0000 AS SmallDateTime), N'390282099', N'Long Bình, Bình Tân , TPHCM', N'099854765', N'Nhân Viên Chính Thức', 1, 1)
SET IDENTITY_INSERT [dbo].[NHANVIEN] OFF
SET IDENTITY_INSERT [dbo].[PHIEUCHI] ON 

INSERT [dbo].[PHIEUCHI] ([MAPC], [NOIDUNG], [SOTIEN], [NGAYLAP], [GHICHU], [NGUOINHAN]) VALUES (1, N'Mua bóng đèn', 150000, CAST(0xA7A50000 AS SmallDateTime), N'', N'Trần Thị Bích')
INSERT [dbo].[PHIEUCHI] ([MAPC], [NOIDUNG], [SOTIEN], [NGAYLAP], [GHICHU], [NGUOINHAN]) VALUES (2, N'Mua ghế', 550000, CAST(0xA7C60000 AS SmallDateTime), N'thay mới', N'Trần Thị Nhạn Chanh')
INSERT [dbo].[PHIEUCHI] ([MAPC], [NOIDUNG], [SOTIEN], [NGAYLAP], [GHICHU], [NGUOINHAN]) VALUES (3, N'Đóng tiền điện', 745000, CAST(0xA6F20000 AS SmallDateTime), N'', N'Đàm Vĩnh Hưng')
INSERT [dbo].[PHIEUCHI] ([MAPC], [NOIDUNG], [SOTIEN], [NGAYLAP], [GHICHU], [NGUOINHAN]) VALUES (4, N'Mua than', 250000, CAST(0xA78A037B AS SmallDateTime), N'', N'Nguyễn Thị B')
INSERT [dbo].[PHIEUCHI] ([MAPC], [NOIDUNG], [SOTIEN], [NGAYLAP], [GHICHU], [NGUOINHAN]) VALUES (5, N'Mua đèn cày', 50000, CAST(0xA78A037B AS SmallDateTime), N'', N'Nguyễn Sơn Tùng')
INSERT [dbo].[PHIEUCHI] ([MAPC], [NOIDUNG], [SOTIEN], [NGAYLAP], [GHICHU], [NGUOINHAN]) VALUES (6, N'Mua bàn đá', 130000, CAST(0xA78A037C AS SmallDateTime), N'2 cái', N'Trần Thị Bích')
INSERT [dbo].[PHIEUCHI] ([MAPC], [NOIDUNG], [SOTIEN], [NGAYLAP], [GHICHU], [NGUOINHAN]) VALUES (7, N'Sửa nhà bếp', 1500000, CAST(0xA78A0396 AS SmallDateTime), N'', N'Trấn Thành')
INSERT [dbo].[PHIEUCHI] ([MAPC], [NOIDUNG], [SOTIEN], [NGAYLAP], [GHICHU], [NGUOINHAN]) VALUES (8, N'Sửa toilet', 100000, CAST(0xA78A0396 AS SmallDateTime), N'', N'Phan Tử Đang')
INSERT [dbo].[PHIEUCHI] ([MAPC], [NOIDUNG], [SOTIEN], [NGAYLAP], [GHICHU], [NGUOINHAN]) VALUES (9, N'Mua nhan', 10000, CAST(0xA78A0447 AS SmallDateTime), N'', N'Trần Thị Bích')
INSERT [dbo].[PHIEUCHI] ([MAPC], [NOIDUNG], [SOTIEN], [NGAYLAP], [GHICHU], [NGUOINHAN]) VALUES (10, N'sửa bàn', 450000, CAST(0xA78A0449 AS SmallDateTime), N'', N'Trần Thị Bích')
SET IDENTITY_INSERT [dbo].[PHIEUCHI] OFF
INSERT [dbo].[TAIKHOAN] ([TENTK], [LOAITK], [MATKHAU]) VALUES (N'admin', N'Quan li', N'1')
INSERT [dbo].[TAIKHOAN] ([TENTK], [LOAITK], [MATKHAU]) VALUES (N'admin1', N'Quan li', N'1')
INSERT [dbo].[TAIKHOAN] ([TENTK], [LOAITK], [MATKHAU]) VALUES (N'Nhan vien', N'Nhan vien', N'1')
INSERT [dbo].[TAIKHOAN] ([TENTK], [LOAITK], [MATKHAU]) VALUES (N'nhanvien', N'Nhan vien', N'1')
INSERT [dbo].[TAIKHOAN] ([TENTK], [LOAITK], [MATKHAU]) VALUES (N'Thu ngan', N'Thu ngan', N'1')
INSERT [dbo].[TAIKHOAN] ([TENTK], [LOAITK], [MATKHAU]) VALUES (N'thungan', N'Thu ngan', N'1')
ALTER TABLE [dbo].[BANAN] ADD  DEFAULT ((0)) FOR [status]
GO
ALTER TABLE [dbo].[HOADON] ADD  DEFAULT (getdate()) FOR [DateCheckIn]
GO
ALTER TABLE [dbo].[HOADON] ADD  DEFAULT ((0)) FOR [status]
GO
ALTER TABLE [dbo].[NHANVIEN] ADD  DEFAULT ((1)) FOR [TINHTRANG]
GO
ALTER TABLE [dbo].[NHANVIEN] ADD  DEFAULT ((1)) FOR [TRANGTHAI]
GO
ALTER TABLE [dbo].[BANAN]  WITH CHECK ADD FOREIGN KEY([MAKV])
REFERENCES [dbo].[KHUVUC] ([MAKV])
GO
ALTER TABLE [dbo].[CHITIETTINHCONG]  WITH CHECK ADD FOREIGN KEY([MACT])
REFERENCES [dbo].[CATRUC] ([MACT])
GO
ALTER TABLE [dbo].[CHITIETTINHCONG]  WITH CHECK ADD FOREIGN KEY([MADD])
REFERENCES [dbo].[DIEMDANH] ([MADD])
GO
ALTER TABLE [dbo].[CHITIETTINHCONG]  WITH CHECK ADD FOREIGN KEY([MANV])
REFERENCES [dbo].[NHANVIEN] ([MANV])
GO
ALTER TABLE [dbo].[CT_KIEMKE]  WITH CHECK ADD FOREIGN KEY([MaNL])
REFERENCES [dbo].[NGUYENLIEU] ([MaNL])
GO
ALTER TABLE [dbo].[CT_KIEMKE]  WITH CHECK ADD FOREIGN KEY([NgayKiemKe])
REFERENCES [dbo].[KIEMKE] ([NgayKiemKe])
GO
ALTER TABLE [dbo].[CT_NL]  WITH CHECK ADD FOREIGN KEY([MAMA])
REFERENCES [dbo].[MONAN] ([MAMA])
GO
ALTER TABLE [dbo].[CT_NL]  WITH CHECK ADD FOREIGN KEY([MaNL])
REFERENCES [dbo].[NGUYENLIEU] ([MaNL])
GO
ALTER TABLE [dbo].[CTDS_NHAPHANG]  WITH CHECK ADD FOREIGN KEY([NgayNhapHang])
REFERENCES [dbo].[DANHSACH_NHAPHANG] ([NgayNhapHang])
GO
ALTER TABLE [dbo].[CTDS_NHAPHANG]  WITH CHECK ADD FOREIGN KEY([MaNL])
REFERENCES [dbo].[NGUYENLIEU] ([MaNL])
GO
ALTER TABLE [dbo].[CTHD]  WITH CHECK ADD FOREIGN KEY([MAHD])
REFERENCES [dbo].[HOADON] ([MAHD])
GO
ALTER TABLE [dbo].[CTHD]  WITH CHECK ADD FOREIGN KEY([MAMA])
REFERENCES [dbo].[MONAN] ([MAMA])
GO
ALTER TABLE [dbo].[DANHSACH_NHAPHANG]  WITH CHECK ADD  CONSTRAINT [FK_DSNH] FOREIGN KEY([TenTK])
REFERENCES [dbo].[TAIKHOAN] ([TENTK])
GO
ALTER TABLE [dbo].[DANHSACH_NHAPHANG] CHECK CONSTRAINT [FK_DSNH]
GO
ALTER TABLE [dbo].[HOADON]  WITH CHECK ADD FOREIGN KEY([MABA])
REFERENCES [dbo].[BANAN] ([MABA])
GO
ALTER TABLE [dbo].[KIEMKE]  WITH CHECK ADD FOREIGN KEY([TenTK])
REFERENCES [dbo].[TAIKHOAN] ([TENTK])
GO
ALTER TABLE [dbo].[MONAN]  WITH CHECK ADD FOREIGN KEY([MALOAI])
REFERENCES [dbo].[LOAIMON] ([MALOAI])
GO
ALTER TABLE [dbo].[NGUYENLIEU]  WITH CHECK ADD FOREIGN KEY([TenTK])
REFERENCES [dbo].[TAIKHOAN] ([TENTK])
GO
ALTER TABLE [dbo].[NHANVIEN]  WITH CHECK ADD FOREIGN KEY([MACV])
REFERENCES [dbo].[CHUCVU] ([MACV])
GO
USE [master]
GO
ALTER DATABASE [DoAnQuanLyQuanCafe] SET  READ_WRITE 
GO