DB_51aspx/family.sql

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

USE [family]
GO
/****** Object:  Table [dbo].[User]    Script Date: 05/08/2020 22:46:31 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[User](
	[userId] [int] IDENTITY(1,1) NOT NULL,
	[userName] [nvarchar](250) NULL,
	[userTrueName] [nvarchar](250) NULL,
	[userPassword] [nvarchar](250) NULL,
	[userRights] [int] NULL,
 CONSTRAINT [PK_User] PRIMARY KEY CLUSTERED 
(
	[userId] 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].[User] ON
INSERT [dbo].[User] ([userId], [userName], [userTrueName], [userPassword], [userRights]) VALUES (1, N'222', N'张婷', N'222', 0)
INSERT [dbo].[User] ([userId], [userName], [userTrueName], [userPassword], [userRights]) VALUES (2, N'admin', N'张三', N'111', 1)
INSERT [dbo].[User] ([userId], [userName], [userTrueName], [userPassword], [userRights]) VALUES (3, N'111', N'张华', N'111', 0)
SET IDENTITY_INSERT [dbo].[User] OFF
/****** Object:  Table [dbo].[Report]    Script Date: 05/08/2020 22:46:31 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Report](
	[username] [nchar](10) NULL,
	[startDate] [nchar](10) NULL,
	[endDate] [nchar](10) NULL,
	[map] [nchar](10) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Items]    Script Date: 05/08/2020 22:46:31 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Items](
	[itemsId] [int] IDENTITY(1,1) NOT NULL,
	[ItemsType] [nvarchar](250) NULL,
	[itemsDetails] [nvarchar](250) NULL,
 CONSTRAINT [PK_Items] PRIMARY KEY CLUSTERED 
(
	[itemsId] 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].[Items] ON
INSERT [dbo].[Items] ([itemsId], [ItemsType], [itemsDetails]) VALUES (1, N'收入', N'工资')
INSERT [dbo].[Items] ([itemsId], [ItemsType], [itemsDetails]) VALUES (2, N'收入', N'兼职')
INSERT [dbo].[Items] ([itemsId], [ItemsType], [itemsDetails]) VALUES (3, N'支出', N'结婚')
SET IDENTITY_INSERT [dbo].[Items] OFF
/****** Object:  Table [dbo].[All]    Script Date: 05/08/2020 22:46:31 ******/
SET ANSI_NULLS ON
GO