|
|
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
|
