Intelligent_Wardrobe/database/数据库命令.sql

USE [master]
GO
/****** Object:  Database [Intelligent_wardrobe]    Script Date: 01/23/2018 13:17:27 ******/
CREATE DATABASE [Intelligent_wardrobe] ON  PRIMARY 
( NAME = N'Intelligent_wardrobe', FILENAME = N'D:\Intelligent_wardrobe.MDF' , SIZE = 3072KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
 LOG ON 
( NAME = N'Intelligent_wardrobe.LOG', FILENAME = N'D:\Intelligent_wardrobe_LOG.LDF' , SIZE = 2048KB , MAXSIZE = 20480KB , FILEGROWTH = 10%)
GO
ALTER DATABASE [Intelligent_wardrobe] SET COMPATIBILITY_LEVEL = 100
GO
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [Intelligent_wardrobe].[dbo].[sp_fulltext_database] @action = 'enable'
end
GO
ALTER DATABASE [Intelligent_wardrobe] SET ANSI_NULL_DEFAULT OFF
GO
ALTER DATABASE [Intelligent_wardrobe] SET ANSI_NULLS OFF
GO
ALTER DATABASE [Intelligent_wardrobe] SET ANSI_PADDING OFF
GO
ALTER DATABASE [Intelligent_wardrobe] SET ANSI_WARNINGS OFF
GO
ALTER DATABASE [Intelligent_wardrobe] SET ARITHABORT OFF
GO
ALTER DATABASE [Intelligent_wardrobe] SET AUTO_CLOSE ON
GO
ALTER DATABASE [Intelligent_wardrobe] SET AUTO_CREATE_STATISTICS ON
GO
ALTER DATABASE [Intelligent_wardrobe] SET AUTO_SHRINK OFF
GO
ALTER DATABASE [Intelligent_wardrobe] SET AUTO_UPDATE_STATISTICS ON
GO
ALTER DATABASE [Intelligent_wardrobe] SET CURSOR_CLOSE_ON_COMMIT OFF
GO
ALTER DATABASE [Intelligent_wardrobe] SET CURSOR_DEFAULT  GLOBAL
GO
ALTER DATABASE [Intelligent_wardrobe] SET CONCAT_NULL_YIELDS_NULL OFF
GO
ALTER DATABASE [Intelligent_wardrobe] SET NUMERIC_ROUNDABORT OFF
GO
ALTER DATABASE [Intelligent_wardrobe] SET QUOTED_IDENTIFIER OFF
GO
ALTER DATABASE [Intelligent_wardrobe] SET RECURSIVE_TRIGGERS OFF
GO
ALTER DATABASE [Intelligent_wardrobe] SET  DISABLE_BROKER
GO
ALTER DATABASE [Intelligent_wardrobe] SET AUTO_UPDATE_STATISTICS_ASYNC OFF
GO
ALTER DATABASE [Intelligent_wardrobe] SET DATE_CORRELATION_OPTIMIZATION OFF
GO
ALTER DATABASE [Intelligent_wardrobe] SET TRUSTWORTHY OFF
GO
ALTER DATABASE [Intelligent_wardrobe] SET ALLOW_SNAPSHOT_ISOLATION OFF
GO
ALTER DATABASE [Intelligent_wardrobe] SET PARAMETERIZATION SIMPLE
GO
ALTER DATABASE [Intelligent_wardrobe] SET READ_COMMITTED_SNAPSHOT OFF
GO
ALTER DATABASE [Intelligent_wardrobe] SET HONOR_BROKER_PRIORITY OFF
GO
ALTER DATABASE [Intelligent_wardrobe] SET  READ_WRITE
GO
ALTER DATABASE [Intelligent_wardrobe] SET RECOVERY SIMPLE
GO
ALTER DATABASE [Intelligent_wardrobe] SET  MULTI_USER
GO
ALTER DATABASE [Intelligent_wardrobe] SET PAGE_VERIFY CHECKSUM
GO
ALTER DATABASE [Intelligent_wardrobe] SET DB_CHAINING OFF
GO
USE [Intelligent_wardrobe]
GO
/****** Object:  Table [dbo].[Users]    Script Date: 01/23/2018 13:17:27 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Users](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[Username] [nvarchar](50) NOT NULL,
	[password] [nvarchar](50) NOT NULL,
	[Email] [nvarchar](max) NOT NULL,
	[Name] [nvarchar](50) NOT NULL,
	[gender] [bit] NULL,
	[age] [int] NULL,
	[Headaddress] [nvarchar](max) NULL,
	[Fondstyle] [nvarchar](50) NULL,
	[remark] [nvarchar](50) NULL,
	[Administratorname] [nvarchar](50) NOT NULL,
	[Deleteuser] [bit] NOT NULL,
	[Deletepicture] [bit] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Username] 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 IDENTITY_INSERT [dbo].[Users] ON
INSERT [dbo].[Users] ([ID], [Username], [password], [Email], [Name], [gender], [age], [Headaddress], [Fondstyle], [remark], [Administratorname], [Deleteuser], [Deletepicture]) VALUES (6, N'admin', N'admin', N'2292398921@qq.com', N'', 0, 0, N'', N'', N'', N'普通用户', 0, 0)
SET IDENTITY_INSERT [dbo].[Users] OFF
/****** Object:  Table [dbo].[Quantity]    Script Date: 01/23/2018 13:17:27 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Quantity](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[Username] [nvarchar](50) NOT NULL,
	[num1] [int] NOT NULL,
	[num2] [int] NOT NULL,
	[num3] [int] NOT NULL,
	[num4] [int] NOT NULL,
	[num5] [int] NOT NULL,
	[num6] [int] NOT NULL,
	[num7] [int] NOT NULL,
	[num8] [int] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Username] 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 IDENTITY_INSERT [dbo].[Quantity] ON
INSERT [dbo].[Quantity] ([ID], [Username], [num1], [num2], [num3], [num4], [num5], [num6], [num7], [num8]) VALUES (11, N'admin', 0, 2, 3, 0, 0, 0, 0, 2)
SET IDENTITY_INSERT [dbo].[Quantity] OFF
/****** Object:  Table [dbo].[Community]    Script Date: 01/23/2018 13:17:27 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Community](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[Username] [nvarchar](50) NOT NULL,
	[Headaddress] [nvarchar](max) NULL,
	[Speechcontent] [nvarchar](max) NOT NULL,
	[Presentationtime] [date] NOT NULL,
	[Praisenumber] [int] NOT NULL,
	[address1] [nvarchar](max) NULL,
	[address2] [nvarchar](max) NULL,
	[address3] [nvarchar](max) NULL,
	[date] [datetime] NULL,
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 IDENTITY_INSERT [dbo].[Community] ON
INSERT [dbo].[Community] ([ID], [Username], [Headaddress], [Speechcontent], [Presentationtime], [Praisenumber], [address1], [address2], [address3], [date]) VALUES (12, N'admin', N'', N'智能衣橱分享内容', CAST(0xCB3D0B00 AS Date), 20, N'image/20180122173947.jpg', N'image/20180122173947.jpg', N'image/20180122173947.jpg', CAST(0x0000000000000000 AS DateTime))
INSERT [dbo].[Community] ([ID], [Username], [Headaddress], [Speechcontent], [Presentationtime], [Praisenumber], [address1], [address2], [address3], [date]) VALUES (13, N'admin', N'', N'智能衣橱分享内容', CAST(0xCB3D0B00 AS Date), 20, N'image/20180122174309.jpg', N'image/20180122174309.jpg', N'image/20180122174309.jpg', CAST(0x0000000000000000 AS DateTime))
INSERT [dbo].[Community] ([ID], [Username], [Headaddress], [Speechcontent], [Presentationtime], [Praisenumber], [address1], [address2], [address3], [date]) VALUES (14, N'admin', N'', N'智能衣橱分享内容', CAST(0xCB3D0B00 AS Date), 20, N'image/20180122174527.jpg', N'image/20180122174527.jpg', N'image/20180122174527.jpg', CAST(0x0000000000000000 AS DateTime))
INSERT [dbo].[Community] ([ID], [Username], [Headaddress], [Speechcontent], [Presentationtime], [Praisenumber], [address1], [address2], [address3], [date]) VALUES (15, N'admin', N'', N'智能衣橱分享内容', CAST(0xCB3D0B00 AS Date), 20, N'image/20180122174622.jpg', N'image/20180122174622.jpg', N'image/20180122174622.jpg', CAST(0x0000000000000000 AS DateTime))
INSERT [dbo].[Community] ([ID], [Username], [Headaddress], [Speechcontent], [Presentationtime], [Praisenumber], [address1], [address2], [address3], [date]) VALUES (16, N'admin', N'', N'智能衣橱分享内容', CAST(0xCB3D0B00 AS Date), 20, N'image/20180122174222.jpg', N'image/20180122174222.jpg', N'image/20180122174222.jpg', CAST(0x0000000000000000 AS DateTime))
INSERT [dbo].[Community] ([ID], [Username], [Headaddress], [Speechcontent], [Presentationtime], [Praisenumber], [address1], [address2], [address3], [date]) VALUES (17, N'admin', N'', N'智能衣橱分享内容', CAST(0xCB3D0B00 AS Date), 20, N'image/20180122173947.jpg', N'image/20180122173947.jpg', N'image/20180122173947.jpg', CAST(0x0000000000000000 AS DateTime))
INSERT [dbo].[Community] ([ID], [Username], [Headaddress], [Speechcontent], [Presentationtime], [Praisenumber], [address1], [address2], [address3], [date]) VALUES (18, N'admin', N'', N'智能衣橱分享内容', CAST(0xCB3D0B00 AS Date), 20, N'image/20180122174107.jpg', N'image/20180122174107.jpg', N'image/20180122174107.jpg', CAST(0x0000000000000000 AS DateTime))
SET IDENTITY_INSERT [dbo].[Community] OFF
/****** Object:  Table [dbo].[Clothes]    Script Date: 01/23/2018 13:17:27 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Clothes](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[Username] [nvarchar](50) NOT NULL,
	[type] [nvarchar](50) NULL,
	[color] [nvarchar](50) NULL,
	[size] [nvarchar](50) NULL,
	[heigh] [nvarchar](50) NULL,
	[season] [nvarchar](50) NULL,
	[fabric] [nvarchar](50) NULL,
	[fond] [bit] NULL,
	[Suitableplaces] [nvarchar](50) NULL,
	[Suitableweather] [nvarchar](50) NULL,
	[Pictureaddress] [nvarchar](max) NULL,
	[Storagetime] [datetime] NOT NULL,
	[placed] [nvarchar](50) NULL,
	[remark] [nvarchar](50) NULL,
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 IDENTITY_INSERT [dbo].[Clothes] ON
INSERT [dbo].[Clothes] ([ID], [Username], [type], [color], [size], [heigh], [season], [fabric], [fond], [Suitableplaces], [Suitableweather], [Pictureaddress], [Storagetime], [placed], [remark]) VALUES (30, N'admin', N'上衣', N'黑色', N'XL', N'170cm', N'春季', N'纯棉', 1, N'运动场所', N'晴天', N'image/20180122173947.jpg', CAST(0x0000A87000000000 AS DateTime), N'主卧衣柜一层', N'黑色上衣XL170cm纯棉运动场所主卧衣柜一层晴天,春天春季')
INSERT [dbo].[Clothes] ([ID], [Username], [type], [color], [size], [heigh], [season], [fabric], [fond], [Suitableplaces], [Suitableweather], [Pictureaddress], [Storagetime], [placed], [remark]) VALUES (31, N'admin', N'上衣', N'黄色', N'L', N'160cm', N'春季', N'纯棉', 1, N'运动场所', N'晴天', N'image/20180122174107.jpg', CAST(0x0000A87000000000 AS DateTime), N'侧卧左一抽屉', N'黄色上衣L160cm纯棉运动场所侧卧左一抽屉晴天,春天春季')
INSERT [dbo].[Clothes] ([ID], [Username], [type], [color], [size], [heigh], [season], [fabric], [fond], [Suitableplaces], [Suitableweather], [Pictureaddress], [Storagetime], [placed], [remark]) VALUES (32, N'admin', N'下装', N'蓝色', N'S', N'160cm', N'春季', N'纯棉', 1, N'运动场所', N'晴天', N'image/20180122174222.jpg', CAST(0x0000A87000000000 AS DateTime), N'主卧衣柜抽屉', N'蓝色下装S160cm纯棉运动场所主卧衣柜抽屉晴天,春天春季')
INSERT [dbo].[Clothes] ([ID], [Username], [type], [color], [size], [heigh], [season], [fabric], [fond], [Suitableplaces], [Suitableweather], [Pictureaddress], [Storagetime], [placed], [remark]) VALUES (33, N'admin', N'下装', N'黑色', N'S', N'150cm', N'春季', N'纯棉', 1, N'运动场所', N'晴天', N'image/20180122174309.jpg', CAST(0x0000A87000000000 AS DateTime), N'阳台抽屉', N'黑色下装S150cm纯棉运动场所阳台抽屉晴天,春天春季')
INSERT [dbo].[Clothes] ([ID], [Username], [type], [color], [size], [heigh], [season], [fabric], [fond], [Suitableplaces], [Suitableweather], [Pictureaddress], [Storagetime], [placed], [remark]) VALUES (34, N'admin', N'下装', N'粉色', N'S', N'150cm', N'春季', N'纯棉', 1, N'运动场所', N'晴天', N'image/20180122174527.jpg', CAST(0x0000A87000000000 AS DateTime), N'主卧衣柜二层', N'粉色下装S150cm纯棉运动场所主卧衣柜二层晴天,春天春季')
INSERT [dbo].[Clothes] ([ID], [Username], [type], [color], [size], [heigh], [season], [fabric], [fond], [Suitableplaces], [Suitableweather], [Pictureaddress], [Storagetime], [placed], [remark]) VALUES (35, N'admin', N'配饰', N'白色', N'S', N'150cm', N'春季', N'纯棉', 1, N'所有场所', N'晴天', N'image/20180122174622.jpg', CAST(0x0000A87000000000 AS DateTime), N'侧卧抽屉', N'白色配饰S150cm纯棉所有场所侧卧抽屉晴天,春天春季')
INSERT [dbo].[Clothes] ([ID], [Username], [type], [color], [size], [heigh], [season], [fabric], [fond], [Suitableplaces], [Suitableweather], [Pictureaddress], [Storagetime], [placed], [remark]) VALUES (36, N'admin', N'配饰', N'褐色', N'S', N'150cm', N'春季', N'纯棉', 1, N'所有场所', N'晴天', N'image/20180122174818.jpg', CAST(0x0000A87000000000 AS DateTime), N'阳台抽屉', N'褐色配饰S150cm纯棉所有场所阳台抽屉晴天,春天春季')
SET IDENTITY_INSERT [dbo].[Clothes] OFF
/****** Object:  Default [DF_Users_Administratorname]    Script Date: 01/23/2018 13:17:27 ******/
ALTER TABLE [dbo].[Users] ADD  CONSTRAINT [DF_Users_Administratorname]  DEFAULT ('普通用户') FOR [Administratorname]
GO
/****** Object:  Default [DF_Users_num1]    Script Date: 01/23/2018 13:17:27 ******/
ALTER TABLE [dbo].[Quantity] ADD  CONSTRAINT [DF_Users_num1]  DEFAULT ('0') FOR [num1]
GO
/****** Object:  ForeignKey [FK__Quantity__Userna__1367E606]    Script Date: 01/23/2018 13:17:27 ******/
ALTER TABLE [dbo].[Quantity]  WITH CHECK ADD FOREIGN KEY([Username])
REFERENCES [dbo].[Users] ([Username])
GO
/****** Object:  ForeignKey [FK__Community__Usern__24927208]    Script Date: 01/23/2018 13:17:27 ******/
ALTER TABLE [dbo].[Community]  WITH CHECK ADD FOREIGN KEY([Username])
REFERENCES [dbo].[Users] ([Username])
GO
/****** Object:  ForeignKey [FK__Clothes__Usernam__1FCDBCEB]    Script Date: 01/23/2018 13:17:27 ******/
ALTER TABLE [dbo].[Clothes]  WITH CHECK ADD FOREIGN KEY([Username])
REFERENCES [dbo].[Users] ([Username])
GO