USE [shujuku_db]
GO
/****** Object:  Table [dbo].[t_User]    Script Date: 06/05/2017 20:41:07 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[t_User](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[username] [varchar](255) NULL,
	[password] [varchar](255) NULL,
	[xingming] [varchar](255) NULL,
	[role] [int] NULL,
	[dianhua] [varchar](255) NULL,
	[dizhi] [varchar](255) NULL,
 CONSTRAINT [PK_t_User] 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
SET IDENTITY_INSERT [dbo].[t_User] ON
INSERT [dbo].[t_User] ([id], [username], [password], [xingming], [role], [dianhua], [dizhi]) VALUES (1, N'admin', N'111111', N'admin', 1, NULL, NULL)
INSERT [dbo].[t_User] ([id], [username], [password], [xingming], [role], [dianhua], [dizhi]) VALUES (8, N'111111', N'111111', N'张三', 0, N'13011111211', N'山西省太原市太原理工大学')
INSERT [dbo].[t_User] ([id], [username], [password], [xingming], [role], [dianhua], [dizhi]) VALUES (9, N'222222', N'222222', N'李四', 0, N'13812121111', N'太原')
SET IDENTITY_INSERT [dbo].[t_User] OFF
/****** Object:  Table [dbo].[t_Product]    Script Date: 06/05/2017 20:41:07 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[t_Product](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[pname] [varchar](255) NULL,
	[imgpath] [varchar](255) NULL,
	[createtime] [varchar](255) NULL,
	[fenleiid] [varchar](255) NULL,
	[fname] [varchar](255) NULL,
	[jiage] [float] NULL,
	[tuijian] [varchar](255) NULL,
	[dianjishu] [int] NULL,
	[xiaoliang] [int] NULL,
	[miaoshu] [text] NULL,
 CONSTRAINT [PK_t_Product] 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] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
SET IDENTITY_INSERT [dbo].[t_Product] ON
INSERT [dbo].[t_Product] ([id], [pname], [imgpath], [createtime], [fenleiid], [fname], [jiage], [tuijian], [dianjishu], [xiaoliang], [miaoshu]) VALUES (4, N'玫瑰花', N'20170502221745.jpg', N'2017-05-02 22:14:27', N'4', N'爱情类', 99, N'未推荐', 9, 5, N'玫瑰原产中国，栽培历史悠久，玫瑰在植物分类学上是一种蔷薇科蔷薇属灌木(Rosa rugosa)，在日常生活中是蔷薇属一系列花大艳丽的栽培品种的统称，这些栽培品种亦可称做月季或蔷薇。
花语:爱情、爱与美、容光焕发，勇敢。')
INSERT [dbo].[t_Product] ([id], [pname], [imgpath], [createtime], [fenleiid], [fname], [jiage], [tuijian], [dianjishu], [xiaoliang], [miaoshu]) VALUES (5, N'郁金香', N'20170502223117.jpg', N'2017-05-02 22:21:46', N'5', N'友情类', 66, N'未推荐', 25, 23, N'郁金香在植物分类学上，是一类属于百合科郁金香属(学名：Tulipa)的具鳞茎草本植物，又称洋荷花、旱荷花。
郁金香花语：博爱、体贴、善良
')
SET IDENTITY_INSERT [dbo].[t_Product] OFF
/****** Object:  Table [dbo].[t_Gouwuche]    Script Date: 06/05/2017 20:41:07 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[t_Gouwuche](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[userid] [int] NULL,
	[pid] [int] NULL,
	[pname] [varchar](255) NULL,
	[jiage] [float] NULL,
	[shuliang] [int] NULL,
 CONSTRAINT [PK_t_Gouwuche] 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
SET IDENTITY_INSERT [dbo].[t_Gouwuche] ON
INSERT [dbo].[t_Gouwuche] ([id], [userid], [pid], [pname], [jiage], [shuliang]) VALUES (8, 3, 7, N'百合花', 99, 3)
SET IDENTITY_INSERT [dbo].[t_Gouwuche] OFF
/****** Object:  Table [dbo].[t_Gonggao]    Script Date: 06/05/2017 20:41:07 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[t_Gonggao](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[biaoti] [varchar](255) NULL,
	[neirong] [text] NULL,
	[shijian] [varchar](255) NULL,
 CONSTRAINT [PK_t_Gonggao] 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] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
SET IDENTITY_INSERT [dbo].[t_Gonggao] ON
INSERT [dbo].[t_Gonggao] ([id], [biaoti], [neirong], [shijian]) VALUES (2, N'毕业季', N'毕业季也是离别季，买束鲜花送给老师和同学，感恩一路陪伴！', N'2017-05-02 22:33:03')
INSERT [dbo].[t_Gonggao] ([id], [biaoti], [neirong], [shijian]) VALUES (3, N'入店须知', N'本店所有产品均为货到付款，收到产品后请检查好！', N'2017-05-02 22:42:13')
SET IDENTITY_INSERT [dbo].[t_Gonggao] OFF
/****** Object:  Table [dbo].[t_Fenlei]    Script Date: 06/05/2017 20:41:07 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[t_Fenlei](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[fname] [varchar](255) NULL,
 CONSTRAINT [PK_t_Fenlei] 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
SET IDENTITY_INSERT [dbo].[t_Fenlei] ON
INSERT [dbo].[t_Fenlei] ([id], [fname]) VALUES (4, N'爱情类')
INSERT [dbo].[t_Fenlei] ([id], [fname]) VALUES (5, N'友情类')
SET IDENTITY_INSERT [dbo].[t_Fenlei] OFF
/****** Object:  Table [dbo].[t_Dingdan]    Script Date: 06/05/2017 20:41:07 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[t_Dingdan](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[status] [varchar](255) NULL,
	[userid] [int] NULL,
	[xingming] [varchar](255) NULL,
	[dianhua] [varchar](255) NULL,
	[dizhi] [varchar](255) NULL,
	[xiangqing] [text] NULL,
	[orderid] [varchar](255) NULL,
	[beizhu] [text] NULL,
	[shijian] [varchar](255) NULL,
	[zongjia] [float] NULL,
 CONSTRAINT [PK_t_Dingdan] 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] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
SET IDENTITY_INSERT [dbo].[t_Dingdan] ON
INSERT [dbo].[t_Dingdan] ([id], [status], [userid], [xingming], [dianhua], [dizhi], [xiangqing], [orderid], [beizhu], [shijian], [zongjia]) VALUES (2, N'已处理', 3, N'张三', N'13011111212', N'山西省太原市太原理工大学', N'商品名：郁金香,单价:66.0,购买数量：2,小计：132.0<br/>', N'20170502223651', N'包装好', N'2017-05-02 22:36:51', 132)
INSERT [dbo].[t_Dingdan] ([id], [status], [userid], [xingming], [dianhua], [dizhi], [xiangqing], [orderid], [beizhu], [shijian], [zongjia]) VALUES (3, N'未处理', 3, N'张三', N'13011111212', N'山西省太原市太原理工大学', N'商品名：郁金香,单价:66.0,购买数量：4,小计：264.0<br/>商品名：玫瑰花,单价:99.0,购买数量：4,小计：396.0<br/>', N'20170511113034', N'', N'2017-05-11 11:30:34', 660)
INSERT [dbo].[t_Dingdan] ([id], [status], [userid], [xingming], [dianhua], [dizhi], [xiangqing], [orderid], [beizhu], [shijian], [zongjia]) VALUES (4, N'未处理', 3, N'张三', N'13011111212', N'山西省太原市太原理工大学', N'商品名：郁金香,单价:66.0,购买数量：1,小计：66.0<br/>', N'20170511134257', N'', N'2017-05-11 13:42:57', 66)
INSERT [dbo].[t_Dingdan] ([id], [status], [userid], [xingming], [dianhua], [dizhi], [xiangqing], [orderid], [beizhu], [shijian], [zongjia]) VALUES (5, N'已处理', 3, N'张三', N'13011111212', N'山西省太原市太原理工大学', N'商品名：郁金香,单价:66.0,购买数量：1,小计：66.0<br/>', N'20170511163001', N'', N'2017-05-11 16:30:01', 66)
INSERT [dbo].[t_Dingdan] ([id], [status], [userid], [xingming], [dianhua], [dizhi], [xiangqing], [orderid], [beizhu], [shijian], [zongjia]) VALUES (6, N'未处理', 7, N'222222', N'13834341212', N'2222', N'商品名：郁金香,单价:66.0,购买数量：1,小计：66.0<br/>', N'20170605122020', N'', N'2017-06-05 12:20:20', 66)
INSERT [dbo].[t_Dingdan] ([id], [status], [userid], [xingming], [dianhua], [dizhi], [xiangqing], [orderid], [beizhu], [shijian], [zongjia]) VALUES (7, N'未处理', 8, N'张三', N'13011111211', N'山西省太原市太原理工大学', N'商品名：郁金香,单价:66.0,购买数量：1,小计：66.0<br/>', N'20170605122519', N'', N'2017-06-05 12:25:19', 66)
INSERT [dbo].[t_Dingdan] ([id], [status], [userid], [xingming], [dianhua], [dizhi], [xiangqing], [orderid], [beizhu], [shijian], [zongjia]) VALUES (8, N'未处理', 8, N'张三', N'13011111211', N'山西省太原市太原理工大学', N'商品名：玫瑰花,单价:99.0,购买数量：1,小计：99.0<br/>', N'20170605123015', N'', N'2017-06-05 12:30:15', 99)
INSERT [dbo].[t_Dingdan] ([id], [status], [userid], [xingming], [dianhua], [dizhi], [xiangqing], [orderid], [beizhu], [shijian], [zongjia]) VALUES (9, N'未处理', 8, N'张三', N'13011111211', N'山西省太原市太原理工大学', N'商品名：郁金香,单价:66.0,购买数量：1,小计：66.0<br/>', N'20170605123331', N'', N'2017-06-05 12:33:31', 66)
INSERT [dbo].[t_Dingdan] ([id], [status], [userid], [xingming], [dianhua], [dizhi], [xiangqing], [orderid], [beizhu], [shijian], [zongjia]) VALUES (10, N'未处理', 9, N'李四', N'13812121111', N'太原', N'商品名：郁金香,单价:66.0,购买数量：10,小计：660.0<br/>', N'20170605160527', N'', N'2017-06-05 16:05:27', 660)
SET IDENTITY_INSERT [dbo].[t_Dingdan] OFF