DB_51aspx/1.mssql table.sql

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

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

CREATE DATABASE [KingNETDB]
GO

USE [KingNETDB]
GO
/****** Object:  Table [dbo].[Adm_User]    Script Date: 07/31/2014 09:22:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING OFF
GO
CREATE TABLE [dbo].[Adm_User](
	[UserID] [int] IDENTITY(1,1) NOT NULL,
	[UserName] [varchar](50) NOT NULL,
	[TrueName] [nvarchar](50) NOT NULL,
	[UserPwd] [varchar](200) NOT NULL,
	[DeptID] [int] NOT NULL,
	[DeptName] [varchar](50) NOT NULL,
	[UserCode] [varchar](50) NOT NULL,
	[CompanyEmail] [varchar](100) NOT NULL,
	[MobileNum] [varchar](50) NOT NULL,
	[StatusFlag] [int] NOT NULL,
	[LastLoginTime] [datetime] NOT NULL,
	[LoginTimes] [int] NOT NULL,
	[LastLoginIp] [varchar](50) NOT NULL,
	[ResetPwdFlag] [bit] NOT NULL,
	[CreateTime] [datetime] NOT NULL,
	[CreateUser] [int] NOT NULL,
	[DeleteFlag] [bit] NOT NULL,
	[DeleteTime] [datetime] NOT NULL,
	[DeleteUser] [int] NOT NULL,
	[UpdateUser] [int] NOT NULL,
	[UpdateTime] [datetime] NOT NULL,
	[Remark] [nvarchar](1000) NOT NULL,
 CONSTRAINT [PK_ADM_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 ANSI_PADDING OFF
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'登录是否需要密码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Adm_User', @level2type=N'COLUMN',@level2name=N'ResetPwdFlag'
GO
/****** Object:  Table [dbo].[Adm_Rights]    Script Date: 07/31/2014 09:22:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING OFF
GO
CREATE TABLE [dbo].[Adm_Rights](
	[RightsID] [int] IDENTITY(1,1) NOT NULL,
	[RightsName] [nvarchar](100) NOT NULL,
	[RightsParentID] [int] NOT NULL,
	[DisplayName] [nvarchar](50) NOT NULL,
	[MenuType] [int] NOT NULL,
	[MenuPath] [varchar](100) NOT NULL,
	[MenuID] [int] NOT NULL,