USE [shouyinxitong]
GO
/* * * * * * Object: a Table [dbo] [t_user] Script Date: 07/08/2016 14:40:36 * * * * * */
The SET ANSI_NULLS ON
GO
The SET QUOTED_IDENTIFIER ON
GO
The SET ANSI_PADDING ON
GO
The CREATE TABLE [dbo] [t_user] (
[yonghuming] [varchar] (10) NOT NULL,
[mima] [varchar] (10) NOT NULL,
[quanxian] [int] NOT NULL,
PRIMARY KEY CONSTRAINT [PK_user] CLUSTERED
(
[yonghuming] ASC
) WITH (PAD_INDEX=OFF, STATISTICS_NORECOMPUTE=OFF, IGNORE_DUP_KEY=OFF, ALLOW_ROW_LOCKS=ON, ALLOW_PAGE_LOCKS=ON) ON (PRIMARY)
) ON the (PRIMARY)
GO
The SET ANSI_PADDING OFF
GO
/* * * * * * Object: a Table [dbo] [shopping] Script Date: 07/08/2016 14:40:36 * * * * * */
The SET ANSI_NULLS ON
GO
The SET QUOTED_IDENTIFIER ON
GO
The SET ANSI_PADDING ON
GO
The CREATE TABLE [dbo] [shopping] (
[bianhao] [varchar] (6) NOT NULL,
[danhao] [int] NOT NULL,
[huiyuanhao] [varchar] (6) NULL,
[shuliang] [int] NULL,
[danjia] [float] NULL,
[riqi] [date] NULL,
[yonghuming] [varchar] (10) NULL,
[leibie] [varchar] (10) NULL,
[master shifu] [float] NULL,
PRIMARY KEY CLUSTERED
(
[bianhao] ASC,
[danhao] ASC
) WITH (PAD_INDEX=OFF, STATISTICS_NORECOMPUTE=OFF, IGNORE_DUP_KEY=OFF, ALLOW_ROW_LOCKS=ON, ALLOW_PAGE_LOCKS=ON) ON (PRIMARY)
) ON the (PRIMARY)
GO
The SET ANSI_PADDING OFF
GO
/* * * * * * Object: a Table [dbo] [necess] Script Date: 07/08/2016 14:40:36 * * * * * */
The SET ANSI_NULLS ON
GO
The SET QUOTED_IDENTIFIER ON
GO
The SET ANSI_PADDING OFF
GO
The CREATE TABLE [dbo] [necess] (
[bianhao] [varchar] (6) NOT NULL,
[mingzi] [varchar] (20) NOT NULL,
[danjia] [float] NOT NULL,
[shuliang] [int] NOT NULL,
[JCRQ] [date] NULL,
[SCRQ] [date] NOT NULL,
[baoziqi] [int] NULL,
PRIMARY KEY CONSTRAINT [PK_necess] CLUSTERED
(
[bianhao] ASC
) WITH (PAD_INDEX=OFF, STATISTICS_NORECOMPUTE=OFF, IGNORE_DUP_KEY=OFF, ALLOW_ROW_LOCKS=ON, ALLOW_PAGE_LOCKS=ON) ON (PRIMARY)
) ON the (PRIMARY)
GO
The SET ANSI_PADDING OFF
GO
/* * * * * * Object: a Table [dbo] [member] Script Date: 07/08/2016 14:40:36 * * * * * */
The SET ANSI_NULLS ON
GO
The SET QUOTED_IDENTIFIER ON
GO
The SET ANSI_PADDING ON
GO
The CREATE TABLE [dbo] [member] (
[huiyuanhao] [varchar] (6) NOT NULL,
[xingming] [varchar] (8) NOT NULL,
[jifen] [int] NULL,
[dianhua] [varchar] (11) NULL,
[zhuzi] [varchar] (20) NULL,
PRIMARY KEY CONSTRAINT [PK_member] CLUSTERED
(
[huiyuanhao] ASC
) WITH (PAD_INDEX=OFF, STATISTICS_NORECOMPUTE=OFF, IGNORE_DUP_KEY=OFF, ALLOW_ROW_LOCKS=ON, ALLOW_PAGE_LOCKS=ON) ON (PRIMARY)
) ON the (PRIMARY)
GO
The SET ANSI_PADDING OFF
GO
/* * * * * * Object: a Table [dbo] [food] Script Date: 07/08/2016 14:40:36 * * * * * */
The SET ANSI_NULLS ON
GO
The SET QUOTED_IDENTIFIER ON
GO
The SET ANSI_PADDING ON
GO
The CREATE TABLE [dbo] [food] (
[bianhao] [varchar] (6) NOT NULL,
[mingzi] [varchar] (20) NOT NULL,
[danjia] [float] NOT NULL,
[shuliang] [int] NOT NULL,
[JCRQ] [date] NULL,
[SCRQ] [date] NOT NULL,
[baoziqi] [int] NULL,
PRIMARY KEY CONSTRAINT [PK_food] CLUSTERED
(
[bianhao] ASC
) WITH (PAD_INDEX=OFF, STATISTICS_NORECOMPUTE=OFF, IGNORE_DUP_KEY=OFF, ALLOW_ROW_LOCKS=ON, ALLOW_PAGE_LOCKS=ON) ON (PRIMARY)
) ON the (PRIMARY)
GO
The SET ANSI_PADDING OFF
GO
/* * * * * * Object: a Table [dbo] [ultimately responds] Script Date: 07/08/2016 14:40:36 * * * * * */
The SET ANSI_NULLS ON
GO
The SET QUOTED_IDENTIFIER ON
GO
The SET ANSI_PADDING OFF
GO
The CREATE TABLE [dbo] [ultimately responds] (
[bianhao] [varchar] (6) NOT NULL,
[mingzi] [varchar] (20) NOT NULL,
[danjia] [float] NOT NULL,
[shuliang] [int] NOT NULL,
[JCRQ] [date] NULL,
[SCRQ] [date] NOT NULL,
[baoziqi] [int] NULL,
PRIMARY KEY CONSTRAINT [PK_drink] CLUSTERED
(
[bianhao] ASC
) WITH (PAD_INDEX=OFF, STATISTICS_NORECOMPUTE=OFF, IGNORE_DUP_KEY=OFF, ALLOW_ROW_LOCKS=ON, ALLOW_PAGE_LOCKS=ON) ON (PRIMARY)
) ON the (PRIMARY)
GO
The SET ANSI_PADDING OFF
GO
/* * * * * * Object: a Table [dbo] [cosmetic] Script Date: 07/08/2016 14:40:36 * * * * * */
The SET ANSI_NULLS ON
GO
The SET QUOTED_IDENTIFIER ON
GO
The SET ANSI_PADDING OFF
GO
The CREATE TABLE [dbo] [cosmetic] (
[bianhao] [varchar] (6) NOT NULL,
[mingzi] [varchar] (20) NOT NULL,
[danjia] [float] NOT NULL,
[shuliang] [int] NOT NULL,
[JCRQ] [date] NULL,
[SCRQ] [date] NOT NULL,
[baoziqi] [int] NULL,
PRIMARY KEY CONSTRAINT [PK_odd] CLUSTERED
(
[bianhao] ASC
) WITH (PAD_INDEX=OFF, STATISTICS_NORECOMPUTE=OFF, IGNORE_DUP_KEY=OFF, ALLOW_ROW_LOCKS=ON, ALLOW_PAGE_LOCKS=ON) ON (PRIMARY)
) ON the (PRIMARY)
GO
nullnullnullnullnullnullnullnullnullnullnullnullnullnull