USE [meetingroombooking]
GO
/****** Object:  Table [dbo].[Account]    Script Date: 6/9/2017 4:12:49 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Account](
	[Username] [varchar](100) NOT NULL,
	[Password] [varchar](300) NULL,
	[Name] [varchar](100) NOT NULL,
	[Address] [varchar](300) NULL,
	[Email] [varchar](100) NULL,
	[Phone] [varchar](50) NULL,
	[IdentityCard] [varchar](50) NULL,
	[Status] [int] NULL,
	[RoleId] [int] NOT NULL,
 CONSTRAINT [PK_Account_1] PRIMARY KEY CLUSTERED 
(
	[Username] 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].[Floor]    Script Date: 6/9/2017 4:12:49 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Floor](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[Name] [nvarchar](250) NULL,
	[CreatedDate] [datetime] NULL,
	[Status] [int] NULL,
 CONSTRAINT [PK_Floor] 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].[Order]    Script Date: 6/9/2017 4:12:49 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Order](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[Account_Id] [varchar](100) NOT NULL,
	[CreatedDate] [datetime] NOT NULL,
	[Status] [int] NULL,
	[Payment] [varchar](50) NULL,
 CONSTRAINT [PK_Order] 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
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[OrderDetail]    Script Date: 6/9/2017 4:12:49 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[OrderDetail](
	[Order_Id] [int] NOT NULL,
	[Room_Id] [varchar](250) NOT NULL,
	[Price] [float] NULL,
	[CreatedDate] [datetime] NULL,
	[Status] [int] NULL,
	[StartDate] [date] NULL,
	[StartTime] [time](7) NULL,
	[EndDate] [date] NULL,
	[EndTime] [time](7) NULL,
 CONSTRAINT [PK_OrderDetail] PRIMARY KEY CLUSTERED 
(
	[Order_Id] ASC,
	[Room_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
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Role]    Script Date: 6/9/2017 4:12:49 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Role](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[Name] [varchar](100) NOT NULL,
 CONSTRAINT [PK_Role] 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
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Room]    Script Date: 6/9/2017 4:12:49 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Room](
	[IdRoom] [varchar](250) NOT NULL,
	[Capacity] [int] NULL,
	[Status] [int] NULL,
	[CreatedDate] [datetime] NULL,
	[CategoryId] [int] NULL,
	[Image] [varchar](max) NULL,
	[Description] [varchar](max) NULL,
	[Name] [varchar](250) NULL,
	[Price] [float] NULL,
	[FloorId] [int] NULL,
 CONSTRAINT [PK_Room] PRIMARY KEY CLUSTERED 
(
	[IdRoom] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Setting]    Script Date: 6/9/2017 4:12:49 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Setting](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[Key] [varchar](250) NULL,
	[Value] [varchar](250) NULL,
	[Group] [varchar](250) NULL,
 CONSTRAINT [PK_Setting] 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
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Type]    Script Date: 6/9/2017 4:12:49 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Type](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[Name] [varchar](100) NOT NULL,
	[Status] [int] NULL,
 CONSTRAINT [PK_Category] 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
SET ANSI_PADDING OFF
GO
INSERT [dbo].[Account] ([Username], [Password], [Name], [Address], [Email], [Phone], [IdentityCard], [Status], [RoleId]) VALUES (N'admin', N'LcpJ1XqaXmgoL3RdeBT7gYKB6R6trrPFvQzYhQrUmfTRbDICFPDTJXvvzYDEEkPOKg3zXYgh0pEokg01NCYxZnaI1u4=', N'Admin', N'aaaa', N'rogerphan0623@gmail.com', N'01669091806', N'273456661', 1, 1)
INSERT [dbo].[Account] ([Username], [Password], [Name], [Address], [Email], [Phone], [IdentityCard], [Status], [RoleId]) VALUES (N'customer3', N'thb/Qa5kCAGCnta7RwsnUxmgqGtZczOdSxV9ovWE7GyOi+6/bJESfVjmYIq5A5NX9RRdQugvXuVvHUU5ci6iskhbrfZC', N'Customer 3', NULL, N'customer3@gmail.com', N'12345678', N'123456', 1, 2)
INSERT [dbo].[Account] ([Username], [Password], [Name], [Address], [Email], [Phone], [IdentityCard], [Status], [RoleId]) VALUES (N'guest', N'LcpJ1XqaXmgoL3RdeBT7gYKB6R6trrPFvQzYhQrUmfTRbDICFPDTJXvvzYDEEkPOKg3zXYgh0pEokg01NCYxZnaI1u4=', N'cannot delete guest', N'guest', N'guest', N'01642279731', N'159472412154', 1, 2)
INSERT [dbo].[Account] ([Username], [Password], [Name], [Address], [Email], [Phone], [IdentityCard], [Status], [RoleId]) VALUES (N'user1', N'LcpJ1XqaXmgoL3RdeBT7gYKB6R6trrPFvQzYhQrUmfTRbDICFPDTJXvvzYDEEkPOKg3zXYgh0pEokg01NCYxZnaI1u4=', N'Thanh Tam', N'kkkkk', N'rogerphan0623@gmail.com', N'01669091806', N'159472412154', 1, 2)
INSERT [dbo].[Account] ([Username], [Password], [Name], [Address], [Email], [Phone], [IdentityCard], [Status], [RoleId]) VALUES (N'user2', N'LcpJ1XqaXmgoL3RdeBT7gYKB6R6trrPFvQzYhQrUmfTRbDICFPDTJXvvzYDEEkPOKg3zXYgh0pEokg01NCYxZnaI1u4=', N'Huu Tai', N'To 63', N'taitai02021995@gmail.com', N'01642279731', N'159472412154', 1, 2)
INSERT [dbo].[Account] ([Username], [Password], [Name], [Address], [Email], [Phone], [IdentityCard], [Status], [RoleId]) VALUES (N'user3', N'LcpJ1XqaXmgoL3RdeBT7gYKB6R6trrPFvQzYhQrUmfTRbDICFPDTJXvvzYDEEkPOKg3zXYgh0pEokg01NCYxZnaI1u4=', N'John Smith', N'212-214 Nguyen Dinh Chieu
Quan 3', N'taitai02021995@gmail.com', N'01642279731', N'159472412154', 1, 2)
INSERT [dbo].[Account] ([Username], [Password], [Name], [Address], [Email], [Phone], [IdentityCard], [Status], [RoleId]) VALUES (N'user4', N'1hv4p1qWbychNCXaNj0ZhxQQc33jvVoCyRta6V0zofYTWgmZfYkQ+lpgUjcMyCjaLmrXADi2+72pQEGT3kCCfOgCjOtI', N'Tài Nguy?n H?u', NULL, N'taitai02021995@gmail.com', N'01642279731', N'159472412154', 1, 2)
SET IDENTITY_INSERT [dbo].[Floor] ON 

INSERT [dbo].[Floor] ([Id], [Name], [CreatedDate], [Status]) VALUES (1, N'Floor 1', CAST(0x0000A70E00000000 AS DateTime), 1)
INSERT [dbo].[Floor] ([Id], [Name], [CreatedDate], [Status]) VALUES (2, N'Floor 2', CAST(0x0000A70E00000000 AS DateTime), 1)
INSERT [dbo].[Floor] ([Id], [Name], [CreatedDate], [Status]) VALUES (3, N'Floor 3', CAST(0x0000A70E00000000 AS DateTime), 1)
INSERT [dbo].[Floor] ([Id], [Name], [CreatedDate], [Status]) VALUES (4, N'Floor 4', CAST(0x0000A70E00000000 AS DateTime), 1)
INSERT [dbo].[Floor] ([Id], [Name], [CreatedDate], [Status]) VALUES (5, N'Floor 5', CAST(0x0000A78D00F63FD8 AS DateTime), 1)
INSERT [dbo].[Floor] ([Id], [Name], [CreatedDate], [Status]) VALUES (6, N'Floor 6', CAST(0x0000A78D01079059 AS DateTime), 1)
SET IDENTITY_INSERT [dbo].[Floor] OFF
SET IDENTITY_INSERT [dbo].[Order] ON 

INSERT [dbo].[Order] ([Id], [Account_Id], [CreatedDate], [Status], [Payment]) VALUES (1, N'user1', CAST(0x0000A78300000000 AS DateTime), 1, N'Cash')
INSERT [dbo].[Order] ([Id], [Account_Id], [CreatedDate], [Status], [Payment]) VALUES (2, N'user3', CAST(0x0000A78400F9C0AC AS DateTime), 1, N'Cash')
INSERT [dbo].[Order] ([Id], [Account_Id], [CreatedDate], [Status], [Payment]) VALUES (3, N'user3', CAST(0x0000A78B00301FEC AS DateTime), 1, N'Cash')
INSERT [dbo].[Order] ([Id], [Account_Id], [CreatedDate], [Status], [Payment]) VALUES (4, N'user3', CAST(0x0000A78B0031518E AS DateTime), 1, N'Cash')
INSERT [dbo].[Order] ([Id], [Account_Id], [CreatedDate], [Status], [Payment]) VALUES (1003, N'user3', CAST(0x0000A78B00407906 AS DateTime), 1, N'Paypal')
INSERT [dbo].[Order] ([Id], [Account_Id], [CreatedDate], [Status], [Payment]) VALUES (1004, N'user3', CAST(0x0000A78B00431EC4 AS DateTime), 1, N'Paypal')
INSERT [dbo].[Order] ([Id], [Account_Id], [CreatedDate], [Status], [Payment]) VALUES (1005, N'admin', CAST(0x0000A78D00FED76A AS DateTime), 1, N'Paypal')
INSERT [dbo].[Order] ([Id], [Account_Id], [CreatedDate], [Status], [Payment]) VALUES (1006, N'admin', CAST(0x0000A78D00FF92AE AS DateTime), 1, N'Paypal')
INSERT [dbo].[Order] ([Id], [Account_Id], [CreatedDate], [Status], [Payment]) VALUES (1007, N'customer3', CAST(0x0000A78D010775A6 AS DateTime), 1, N'Paypal')
INSERT [dbo].[Order] ([Id], [Account_Id], [CreatedDate], [Status], [Payment]) VALUES (1008, N'customer3', CAST(0x0000A78D010A61AF AS DateTime), 1, N'Paypal')
SET IDENTITY_INSERT [dbo].[Order] OFF
INSERT [dbo].[OrderDetail] ([Order_Id], [Room_Id], [Price], [CreatedDate], [Status], [StartDate], [StartTime], [EndDate], [EndTime]) VALUES (1, N'VM01', 100, CAST(0x0000A78300000000 AS DateTime), 1, CAST(0xEC3C0B00 AS Date), CAST(0x0700D85EAC3A0000 AS Time), CAST(0xED3C0B00 AS Date), CAST(0x070048F9F66C0000 AS Time))
INSERT [dbo].[OrderDetail] ([Order_Id], [Room_Id], [Price], [CreatedDate], [Status], [StartDate], [StartTime], [EndDate], [EndTime]) VALUES (2, N'VDH02', 300, CAST(0x0000A78400F9C0E9 AS DateTime), 3, CAST(0xED3C0B00 AS Date), CAST(0x0700D85EAC3A0000 AS Time), CAST(0xED3C0B00 AS Date), CAST(0x0700E80A7E8E0000 AS Time))
INSERT [dbo].[OrderDetail] ([Order_Id], [Room_Id], [Price], [CreatedDate], [Status], [StartDate], [StartTime], [EndDate], [EndTime]) VALUES (2, N'VM01', 100, CAST(0x0000A78300000000 AS DateTime), 1, CAST(0xEC3C0B00 AS Date), CAST(0x0700D85EAC3A0000 AS Time), CAST(0xED3C0B00 AS Date), CAST(0x070048F9F66C0000 AS Time))
INSERT [dbo].[OrderDetail] ([Order_Id], [Room_Id], [Price], [CreatedDate], [Status], [StartDate], [StartTime], [EndDate], [EndTime]) VALUES (2, N'VM02', 100, CAST(0x0000A78300000000 AS DateTime), 1, CAST(0xE23C0B00 AS Date), CAST(0x0700D85EAC3A0000 AS Time), CAST(0xE23C0B00 AS Date), CAST(0x070048F9F66C0000 AS Time))
INSERT [dbo].[OrderDetail] ([Order_Id], [Room_Id], [Price], [CreatedDate], [Status], [StartDate], [StartTime], [EndDate], [EndTime]) VALUES (3, N'DH01', 200, CAST(0x0000A78B003020E7 AS DateTime), 3, CAST(0xE63C0B00 AS Date), CAST(0x0700A8E76F4B0000 AS Time), CAST(0xE73C0B00 AS Date), CAST(0x0700E03495640000 AS Time))
INSERT [dbo].[OrderDetail] ([Order_Id], [Room_Id], [Price], [CreatedDate], [Status], [StartDate], [StartTime], [EndDate], [EndTime]) VALUES (3, N'VM01', 100, CAST(0x0000A78B003020BC AS DateTime), 3, CAST(0xE63C0B00 AS Date), CAST(0x0700A8E76F4B0000 AS Time), CAST(0xE73C0B00 AS Date), CAST(0x0700E03495640000 AS Time))
INSERT [dbo].[OrderDetail] ([Order_Id], [Room_Id], [Price], [CreatedDate], [Status], [StartDate], [StartTime], [EndDate], [EndTime]) VALUES (4, N'VDH01', 300, CAST(0x0000A78B003151BA AS DateTime), 0, CAST(0xE63C0B00 AS Date), CAST(0x0700A8E76F4B0000 AS Time), CAST(0xE73C0B00 AS Date), CAST(0x0700E03495640000 AS Time))
INSERT [dbo].[OrderDetail] ([Order_Id], [Room_Id], [Price], [CreatedDate], [Status], [StartDate], [StartTime], [EndDate], [EndTime]) VALUES (4, N'VM01', 150, CAST(0x0000A78B0031519F AS DateTime), 3, CAST(0xE63C0B00 AS Date), CAST(0x0700A8E76F4B0000 AS Time), CAST(0xE73C0B00 AS Date), CAST(0x0700E03495640000 AS Time))
INSERT [dbo].[OrderDetail] ([Order_Id], [Room_Id], [Price], [CreatedDate], [Status], [StartDate], [StartTime], [EndDate], [EndTime]) VALUES (1003, N'VDH01', 300, CAST(0x0000A78B00407987 AS DateTime), 1, CAST(0xE63C0B00 AS Date), CAST(0x0700A8E76F4B0000 AS Time), CAST(0xE73C0B00 AS Date), CAST(0x0700E03495640000 AS Time))
INSERT [dbo].[OrderDetail] ([Order_Id], [Room_Id], [Price], [CreatedDate], [Status], [StartDate], [StartTime], [EndDate], [EndTime]) VALUES (1003, N'VM01', 150, CAST(0x0000A78B0040796F AS DateTime), 1, CAST(0xE63C0B00 AS Date), CAST(0x0700A8E76F4B0000 AS Time), CAST(0xE73C0B00 AS Date), CAST(0x0700E03495640000 AS Time))
INSERT [dbo].[OrderDetail] ([Order_Id], [Room_Id], [Price], [CreatedDate], [Status], [StartDate], [StartTime], [EndDate], [EndTime]) VALUES (1004, N'VDH01', 300, CAST(0x0000A78B00431F06 AS DateTime), 1, CAST(0xE73C0B00 AS Date), CAST(0x0700E03495640000 AS Time), CAST(0xE73C0B00 AS Date), CAST(0x070050CFDF960000 AS Time))
INSERT [dbo].[OrderDetail] ([Order_Id], [Room_Id], [Price], [CreatedDate], [Status], [StartDate], [StartTime], [EndDate], [EndTime]) VALUES (1004, N'VM01', 150, CAST(0x0000A78B00431EF9 AS DateTime), 1, CAST(0xE73C0B00 AS Date), CAST(0x0700E03495640000 AS Time), CAST(0xE73C0B00 AS Date), CAST(0x070050CFDF960000 AS Time))
INSERT [dbo].[OrderDetail] ([Order_Id], [Room_Id], [Price], [CreatedDate], [Status], [StartDate], [StartTime], [EndDate], [EndTime]) VALUES (1005, N'aa', 22, CAST(0x0000A78D00FED780 AS DateTime), 1, CAST(0xE83C0B00 AS Date), CAST(0x0700A8E76F4B0000 AS Time), CAST(0xE93C0B00 AS Date), CAST(0x0700E03495640000 AS Time))
INSERT [dbo].[OrderDetail] ([Order_Id], [Room_Id], [Price], [CreatedDate], [Status], [StartDate], [StartTime], [EndDate], [EndTime]) VALUES (1006, N'aa', 22, CAST(0x0000A78D00FF92B2 AS DateTime), 1, CAST(0xEB3C0B00 AS Date), CAST(0x070040230E430000 AS Time), CAST(0xEB3C0B00 AS Date), CAST(0x070010ACD1530000 AS Time))
INSERT [dbo].[OrderDetail] ([Order_Id], [Room_Id], [Price], [CreatedDate], [Status], [StartDate], [StartTime], [EndDate], [EndTime]) VALUES (1007, N'M02', 100, CAST(0x0000A78D010775AC AS DateTime), 1, CAST(0xEF3C0B00 AS Date), CAST(0x0700A8E76F4B0000 AS Time), CAST(0x073D0B00 AS Date), CAST(0x0700E03495640000 AS Time))
INSERT [dbo].[OrderDetail] ([Order_Id], [Room_Id], [Price], [CreatedDate], [Status], [StartDate], [StartTime], [EndDate], [EndTime]) VALUES (1008, N'R01', 30, CAST(0x0000A78D010A61E3 AS DateTime), 1, CAST(0xEC3C0B00 AS Date), CAST(0x0700A8E76F4B0000 AS Time), CAST(0xED3C0B00 AS Date), CAST(0x0700E03495640000 AS Time))
INSERT [dbo].[OrderDetail] ([Order_Id], [Room_Id], [Price], [CreatedDate], [Status], [StartDate], [StartTime], [EndDate], [EndTime]) VALUES (1008, N'VM05', 170, CAST(0x0000A78D010A61E6 AS DateTime), 1, CAST(0xEC3C0B00 AS Date), CAST(0x0700A8E76F4B0000 AS Time), CAST(0xED3C0B00 AS Date), CAST(0x0700E03495640000 AS Time))
SET IDENTITY_INSERT [dbo].[Role] ON 

INSERT [dbo].[Role] ([Id], [Name]) VALUES (1, N'Admin')
INSERT [dbo].[Role] ([Id], [Name]) VALUES (2, N'User')
SET IDENTITY_INSERT [dbo].[Role] OFF
INSERT [dbo].[Room] ([IdRoom], [Capacity], [Status], [CreatedDate], [CategoryId], [Image], [Description], [Name], [Price], [FloorId]) VALUES (N'A01', 128, 1, CAST(0x0000A72A0163ADD8 AS DateTime), 6, N'VM015.jpg;', N'<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud. <br /><br /> Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud.<br /><br /> Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud.</p>', N'Name 1', 200, 1)
INSERT [dbo].[Room] ([IdRoom], [Capacity], [Status], [CreatedDate], [CategoryId], [Image], [Description], [Name], [Price], [FloorId]) VALUES (N'A02', 100, 1, CAST(0x0000A72A0163ADD8 AS DateTime), 6, N'VM015.jpg;', N'<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud. <br /><br /> Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud.<br /><br /> Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud.</p>', N'Name 2', 200, 2)
INSERT [dbo].[Room] ([IdRoom], [Capacity], [Status], [CreatedDate], [CategoryId], [Image], [Description], [Name], [Price], [FloorId]) VALUES (N'aa', 11, 1, CAST(0x0000A78D00FD63F8 AS DateTime), 2, N'aa1.jpg;aa2.jpg;aa3.jpg;aa4.jpg;aa5.jpg;aa6.jpg;', N'<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud. <br /><br /> Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud.<br /><br /> Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud.</p>', N'Room 9', 22, 5)
INSERT [dbo].[Room] ([IdRoom], [Capacity], [Status], [CreatedDate], [CategoryId], [Image], [Description], [Name], [Price], [FloorId]) VALUES (N'DH01', 80, 1, CAST(0x0000A72A0163ADD8 AS DateTime), 5, N'VM014.jpg;VM015.jpg;', N'<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud. <br /><br /> Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud.<br /><br /> Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud.</p>', N'Name 1', 120, 1)
INSERT [dbo].[Room] ([IdRoom], [Capacity], [Status], [CreatedDate], [CategoryId], [Image], [Description], [Name], [Price], [FloorId]) VALUES (N'DH02', 80, 1, CAST(0x0000A72A0163ADD8 AS DateTime), 5, N'VM014.jpg;VM015.jpg;', N'<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud. <br /><br /> Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud.<br /><br /> Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud.</p>', N'Name 2', 120, 2)
INSERT [dbo].[Room] ([IdRoom], [Capacity], [Status], [CreatedDate], [CategoryId], [Image], [Description], [Name], [Price], [FloorId]) VALUES (N'DH03', 90, 1, CAST(0x0000A72A0163ADD8 AS DateTime), 5, N'VM014.jpg;VM015.jpg;', N'<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud. <br /><br /> Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud.<br /><br /> Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud.</p>', N'Name 3', 120, 3)
INSERT [dbo].[Room] ([IdRoom], [Capacity], [Status], [CreatedDate], [CategoryId], [Image], [Description], [Name], [Price], [FloorId]) VALUES (N'M01', 14, 1, CAST(0x0000A72A0163AD84 AS DateTime), 3, N'VM013.jpg;VM014.jpg;VM015.jpg;', N'<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud. <br /><br /> Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud.<br /><br /> Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud.</p>', N'Name 1', 100, 1)
INSERT [dbo].[Room] ([IdRoom], [Capacity], [Status], [CreatedDate], [CategoryId], [Image], [Description], [Name], [Price], [FloorId]) VALUES (N'M02', 14, 1, CAST(0x0000A72A0163ADD8 AS DateTime), 3, N'VM013.jpg;VM014.jpg;VM015.jpg;', N'<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud. <br /><br /> Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud.<br /><br /> Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud.</p>', N'Name 2', 100, 2)
INSERT [dbo].[Room] ([IdRoom], [Capacity], [Status], [CreatedDate], [CategoryId], [Image], [Description], [Name], [Price], [FloorId]) VALUES (N'M03', 10, 1, CAST(0x0000A72A0163ADD8 AS DateTime), 3, N'VM013.jpg;VM014.jpg;VM015.jpg;', N'<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud. <br /><br /> Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud.<br /><br /> Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud.</p>', N'Name 3', 100, 3)
INSERT [dbo].[Room] ([IdRoom], [Capacity], [Status], [CreatedDate], [CategoryId], [Image], [Description], [Name], [Price], [FloorId]) VALUES (N'R01', 20, 1, CAST(0x0000A78D0107FEF3 AS DateTime), 2, N'R011.jpg;R012.jpg;R013.JPG;R014.jpg;', N'<p>Description of Room</p>', N'Room Test', 30, 1)
INSERT [dbo].[Room] ([IdRoom], [Capacity], [Status], [CreatedDate], [CategoryId], [Image], [Description], [Name], [Price], [FloorId]) VALUES (N'VDH01', 120, 1, CAST(0x0000A72A0163AD84 AS DateTime), 4, N'VDH011.jpg;VDH012.jpg;VDH013.jpg;VDH014.JPG;VDH015.jpg;', N'<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud. <br /><br /> Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud.<br /><br /> Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud.</p>', N'Name 1', 300, 1)
INSERT [dbo].[Room] ([IdRoom], [Capacity], [Status], [CreatedDate], [CategoryId], [Image], [Description], [Name], [Price], [FloorId]) VALUES (N'VDH02', 100, 1, CAST(0x0000A72A0163AD84 AS DateTime), 4, N'VDH021.jpg;VDH022.jpg;VDH023.jpg;VDH024.jpg;VDH025.JPG;VDH026.jpg;', N'<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud. <br /><br /> Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud.<br /><br /> Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud.</p>', N'Name 2', 300, 2)
INSERT [dbo].[Room] ([IdRoom], [Capacity], [Status], [CreatedDate], [CategoryId], [Image], [Description], [Name], [Price], [FloorId]) VALUES (N'VM01', 20, 1, CAST(0x0000A72A0163AD84 AS DateTime), 2, N'VM011.jpg;VM012.jpg;VM013.jpg;VM014.jpg;VM015.jpg;VM016.JPG;VM017.jpg;', N'<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud. <br /><br /> Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud.<br /><br /> Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud.</p>', N'Name 1', 150, 1)
INSERT [dbo].[Room] ([IdRoom], [Capacity], [Status], [CreatedDate], [CategoryId], [Image], [Description], [Name], [Price], [FloorId]) VALUES (N'VM02', 18, 1, CAST(0x0000A72A0163AD84 AS DateTime), 2, N'VM021.jpg;VM022.jpg;VM023.JPG;VM024.jpg;', N'<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud. <br /><br /> Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud.<br /><br /> Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud.</p>', N'Name 2', 150, 2)
INSERT [dbo].[Room] ([IdRoom], [Capacity], [Status], [CreatedDate], [CategoryId], [Image], [Description], [Name], [Price], [FloorId]) VALUES (N'VM03', 20, 1, CAST(0x0000A72A0163AD84 AS DateTime), 2, N'VM031.jpg;VM032.jpg;VM033.jpg;VM034.jpg;VM035.jpg;', N'<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud. <br /><br /> Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud.<br /><br /> Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud.</p>', N'Name 3', 150, 3)
INSERT [dbo].[Room] ([IdRoom], [Capacity], [Status], [CreatedDate], [CategoryId], [Image], [Description], [Name], [Price], [FloorId]) VALUES (N'VM04', 20, 1, CAST(0x0000A72A0163AD84 AS DateTime), 2, N'VM041.jpg;VM042.jpg;VM043.jpg;VM044.jpg;VM045.jpg;VM046.jpg;VM047.jpg;VM048.JPG;VM049.jpg;', N'<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud. <br /><br /> Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud.<br /><br /> Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud.</p>', N'Name 4', 150, 4)
INSERT [dbo].[Room] ([IdRoom], [Capacity], [Status], [CreatedDate], [CategoryId], [Image], [Description], [Name], [Price], [FloorId]) VALUES (N'VM05', 30, 1, CAST(0x0000A78B004C3B3C AS DateTime), 2, N'VM051.jpg;VM052.jpg;VM053.jpg;VM054.jpg;VM055.jpg;VM056.jpg;VM057.jpg;VM058.JPG;VM059.jpg;', N'<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud. <br /><br /> Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud.<br /><br /> Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud.</p>', N'Name 5', 170, 1)
SET IDENTITY_INSERT [dbo].[Setting] ON 

INSERT [dbo].[Setting] ([Id], [Key], [Value], [Group]) VALUES (1, N'favicon', N'favicon.ico', N'favicon')
INSERT [dbo].[Setting] ([Id], [Key], [Value], [Group]) VALUES (2, N'logo', N'logo.png', N'logo')
INSERT [dbo].[Setting] ([Id], [Key], [Value], [Group]) VALUES (3, N'PdtToken', N'-LEbGJTDth57Rd22kgAxfn8zM0oJQY1rfbDEphI1bRMvVimCLdJcBSKxHJi', N'paypal')
INSERT [dbo].[Setting] ([Id], [Key], [Value], [Group]) VALUES (4, N'PayPalUsername', N'tai02021995-facilitator@gmail.com', N'paypal')
INSERT [dbo].[Setting] ([Id], [Key], [Value], [Group]) VALUES (5, N'PayPalSubmitUrl', N'https://www.sandbox.paypal.com/cgi-bin/webscr', N'paypal')
INSERT [dbo].[Setting] ([Id], [Key], [Value], [Group]) VALUES (6, N'websiteName', N'Meeting Room Booking', N'websiteName')
INSERT [dbo].[Setting] ([Id], [Key], [Value], [Group]) VALUES (7, N'currency', N'USD', N'currency')
SET IDENTITY_INSERT [dbo].[Setting] OFF
SET IDENTITY_INSERT [dbo].[Type] ON 

INSERT [dbo].[Type] ([Id], [Name], [Status]) VALUES (2, N'VIP Metting Room', 1)
INSERT [dbo].[Type] ([Id], [Name], [Status]) VALUES (3, N'Metting Room', 1)
INSERT [dbo].[Type] ([Id], [Name], [Status]) VALUES (4, N'VIP Dining Halls', 1)
INSERT [dbo].[Type] ([Id], [Name], [Status]) VALUES (5, N'Dining Halls', 1)
INSERT [dbo].[Type] ([Id], [Name], [Status]) VALUES (6, N'Auditorium', 1)
INSERT [dbo].[Type] ([Id], [Name], [Status]) VALUES (7, N'Type ABC', 1)
INSERT [dbo].[Type] ([Id], [Name], [Status]) VALUES (8, N'Type Test', 1)
SET IDENTITY_INSERT [dbo].[Type] OFF
ALTER TABLE [dbo].[Account]  WITH CHECK ADD  CONSTRAINT [FK_Account_Role] FOREIGN KEY([RoleId])
REFERENCES [dbo].[Role] ([Id])
GO
ALTER TABLE [dbo].[Account] CHECK CONSTRAINT [FK_Account_Role]
GO
ALTER TABLE [dbo].[Order]  WITH CHECK ADD  CONSTRAINT [FK_Order_Account1] FOREIGN KEY([Account_Id])
REFERENCES [dbo].[Account] ([Username])
GO
ALTER TABLE [dbo].[Order] CHECK CONSTRAINT [FK_Order_Account1]
GO
ALTER TABLE [dbo].[OrderDetail]  WITH CHECK ADD  CONSTRAINT [FK_OrderDetail_Order] FOREIGN KEY([Order_Id])
REFERENCES [dbo].[Order] ([Id])
GO
ALTER TABLE [dbo].[OrderDetail] CHECK CONSTRAINT [FK_OrderDetail_Order]
GO
ALTER TABLE [dbo].[OrderDetail]  WITH CHECK ADD  CONSTRAINT [FK_OrderDetail_Room] FOREIGN KEY([Room_Id])
REFERENCES [dbo].[Room] ([IdRoom])
GO
ALTER TABLE [dbo].[OrderDetail] CHECK CONSTRAINT [FK_OrderDetail_Room]
GO
ALTER TABLE [dbo].[Room]  WITH CHECK ADD  CONSTRAINT [FK_Room_Category] FOREIGN KEY([CategoryId])
REFERENCES [dbo].[Type] ([Id])
GO
ALTER TABLE [dbo].[Room] CHECK CONSTRAINT [FK_Room_Category]
GO
ALTER TABLE [dbo].[Room]  WITH CHECK ADD  CONSTRAINT [FK_Room_Floor] FOREIGN KEY([FloorId])
REFERENCES [dbo].[Floor] ([Id])
GO
ALTER TABLE [dbo].[Room] CHECK CONSTRAINT [FK_Room_Floor]
GO
USE [master]
GO
ALTER DATABASE [meetingroombooking] SET  READ_WRITE 
GO
