网上订餐系统代码

/****** Object: View [dbo].[V_明细] Script Date: 11/15/2015 15:08:04 ******/ IF EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[V_明细]')) DROP VIEW [dbo].[V_明细] GO /****** Object: View [dbo].[V_菜品] Script Date: 11/15/2015 15:08:04 ******/ IF EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[V_菜品]')) DROP VIEW [dbo].[V_菜品] GO /****** Object: Table [dbo].[订单] Script Date: 11/15/2015 15:08:04 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[订单]') AND type in (N'U')) DROP TABLE [dbo].[订单] GO /****** Object: Table [dbo].[订单信息] Script Date: 11/15/2015 15:08:04 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[订单信息]') AND type in (N'U')) DROP TABLE [dbo].[订单信息] GO /****** Object: Table [dbo].[购物车] Script Date: 11/15/2015 15:08:04 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[购物车]') AND type in (N'U')) DROP TABLE [dbo].[购物车] GO /****** Object: Table [dbo].[管理员] Script Date: 11/15/2015 15:08:04 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[管理员]') AND type in (N'U')) DROP TABLE [dbo].[管理员] GO /****** Object: Table [dbo].[会员] Script Date: 11/15/2015 15:08:04 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[会员]') AND type in (N'U')) DROP TABLE [dbo].[会员] GO /****** Object: Table [dbo].[菜品类别] Script Date: 11/15/2015 15:08:04 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[菜品类别]') AND type in (N'U')) DROP TABLE [dbo].[菜品类别] GO /****** Object: Table [dbo].[菜品信息] Script Date: 11/15/2015 15:08:04 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[菜品信息]') AND type in (N'U')) DROP TABLE [dbo].[菜品信息] GO /****** Object: Table [dbo].[菜品信息] Script Date: 11/15/2015 15:08:04 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[菜品信息]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[菜品信息]( [代码] [int] IDENTITY(1,1) NOT NULL, [菜品名称] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL, [规格] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL, [计量单位] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL, [描述] [nvarchar](250) COLLATE Chinese_PRC_CI_AS NULL, [类别代码] [int] NULL, [图片] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL, [价格] [int] NULL, [人气] [int] NULL, [剩余量] [int] NULL ) END GO SET IDENTITY_INSERT [dbo].[菜品信息] ON INSERT [dbo].[菜品信息] ([代码], [菜品名称], [规格], [计量单位], [描述], [类别代码], [图片], [价格], [人气], [剩余量]) VALUES (1, N'三鲜菌菇面', N'', N'盘', N'暂无介绍 ', 27, N'a8ff533b-2bbe-4da4-9151-c2131224fa8e.png', 20, 55, 6) INSERT [dbo].[菜品信息] ([代码], [菜品名称], [规格], [计量单位], [描述], [类别代码], [图片], [价格], [人气], [剩余量]) VALUES (2, N'刀豆土豆条', N'', N'盘', N'', 26, N'12c14aaa-baf0-49c2-99f6-444a4c37614e.png', 20, 15, 11) INSERT [dbo].[菜品信息] ([代码], [菜品名称], [规格], [计量单位], [描述], [类别代码], [图片], [价格], [人气], [剩余量]) VALUES (3, N'芹菜肉丝', N'', N'盘', N'', 26, N'43b4a0c3-a758-4114-ade4-7c1b57cd6843.png', 12, 2, 30) INSERT [dbo].[菜品信息] ([代码], [菜品名称], [规格], [计量单位], [描述], [类别代码], [图片], [价格], [人气], [剩余量]) VALUES (4, N'木耳炒蛋', N'', N'', N'', 25, N'99ab199c-b4ab-4f8b-8a57-b709f4c60447.png', 18, 15, 25) INSERT [dbo].[菜品信息] ([代码], [菜品名称], [规格], [计量单位], [描述], [类别代码], [图片], [价格], [人气], [剩余量]) VALUES (5, N'招牌牛肉面', N'', N'盘', N'', 27, N'f7452c81-00fb-44c0-b073-3b7c9e76f5db.png', 16, 13, 7) INSERT [dbo].[菜品信息] ([代码], [菜品名称], [规格], [计量单位], [描述], [类别代码], [图片], [价格], [人气], [剩余量]) VALUES (6, N'红烧大排套餐', N'', N'盘', N'又快又好吃的盖浇饭、套餐 ', 25, N'11e26065-3b21-4118-be09-508f463e36bf.png', 14, 11, 11) INSERT [dbo].[菜品信息] ([代码], [菜品名称], [规格], [计量单位], [描述], [类别代码], [图片], [价格], [人气], [剩余量]) VALUES (9, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 28) SET IDENTITY_INSERT [dbo].[菜品信息] OFF /****** Object: Table [dbo].[菜品类别] Script Date: 11/15/2015 15:08:04 ******/ SET A�