USE [shouyinxitong]
GO
/****** Object: Table [dbo].[t_user] Script Date: 07/08/2016 14:40:36 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[t_user](
[yonghuming] [varchar](10) NOT NULL,
[mima] [varchar](10) NOT NULL,
[quanxian] [int] NOT NULL,
CONSTRAINT [PK_user] PRIMARY KEY 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 [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[shopping] Script Date: 07/08/2016 14:40:36 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
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,
[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 [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[necess] Script Date: 07/08/2016 14:40:36 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING OFF
GO
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,
CONSTRAINT [PK_necess] PRIMARY KEY 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 [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[member] Script Date: 07/08/2016 14:40:36 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
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,
CONSTRAINT [PK_member] PRIMARY KEY 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 [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[food] Script Date: 07/08/2016 14:40:36 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
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,
CONSTRAINT [PK_food] PRIMARY KEY 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 [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[drink] Script Date: 07/08/2016 14:40:36 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING OFF
GO
CREATE TABLE [dbo].[drink](
[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,
CONSTRAINT [PK_drink] PRIMARY KEY 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 [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[cosmetic] Script Date: 07/08/2016 14:40:36 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING OFF
GO
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,
CONSTRAINT [PK_odd] PRIMARY KEY 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 [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
uj5u.com熱心網友回復：
當然可以，我看表也不多，手工改改就行uj5u.com熱心網友回復：
能幫我改改嗎，在線急等
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/104672.html
標籤：疑難問題