ALARM/豪恩LHB9000管理软件/Navicat sql/User.sql

/*
Navicat SQL Server Data Transfer

Source Server         : 9000
Source Server Version : 105000
Source Host           : .\sqlexpress:1433
Source Database       : LHBMS
Source Schema         : dbo

Target Server Type    : SQL Server
Target Server Version : 105000
File Encoding         : 65001

Date: 2021-05-11 15:34:24
*/


-- ----------------------------
-- Table structure for User
-- ----------------------------
DROP TABLE [dbo].[User]
GO
CREATE TABLE [dbo].[User] (
[ID] uniqueidentifier NOT NULL DEFAULT (newid()) ROWGUIDCOL ,
[Name] varchar(50) NOT NULL ,
[Pwd] varchar(50) NULL ,
[UserNo] nvarchar(50) NULL ,
[RealName] varchar(50) NULL ,
[RoleNo] int NULL DEFAULT ((0)) ,
[IsValid] tinyint NULL ,
[IsOnline] tinyint NULL ,
[CreateDate] datetime NULL DEFAULT (getdate()) ,
[RoleID] uniqueidentifier NULL 
)


GO
IF ((SELECT COUNT(*) from fn_listextendedproperty('MS_Description', 
'SCHEMA', N'dbo', 
'TABLE', N'User', 
'COLUMN', N'UserNo')) > 0) 
EXEC sp_updateextendedproperty @name = N'MS_Description', @value = N'编码'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'User'
, @level2type = 'COLUMN', @level2name = N'UserNo'
ELSE
EXEC sp_addextendedproperty @name = N'MS_Description', @value = N'编码'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'User'
, @level2type = 'COLUMN', @level2name = N'UserNo'
GO

-- ----------------------------
-- Records of User
-- ----------------------------
INSERT INTO [dbo].[User] ([ID], [Name], [Pwd], [UserNo], [RealName], [RoleNo], [IsValid], [IsOnline], [CreateDate], [RoleID]) VALUES (N'545AA13A-2647-4AA4-BCAB-05DD0D57A7A9', N'user', N'E10ADC3949BA59ABBE56E057F20F883E', null, N'user', null, N'1', N'0', N'2016-02-29 16:14:18.710', N'14B06CC9-B5A4-46AB-9769-7F405B618677')
GO
GO
INSERT INTO [dbo].[User] ([ID], [Name], [Pwd], [UserNo], [RealName], [RoleNo], [IsValid], [IsOnline], [CreateDate], [RoleID]) VALUES (N'35B2CDE1-CC67-49C4-A040-366AE4EDB2DF', N'admin', N'21232F297A57A5A743894A0E4A801FC3', null, N'administrator', N'100001', N'1', N'0', N'2015-07-20 00:00:00.000', N'374B45EE-4406-498D-8BB3-1B5248A362CF')
GO
GO
INSERT INTO [dbo].[User] ([ID], [Name], [Pwd], [UserNo], [RealName], [RoleNo], [IsValid], [IsOnline], [CreateDate], [RoleID]) VALUES (N'65F86ADD-99E3-40B0-A67F-513B3A3A241C', N'install', N'E10ADC3949BA59ABBE56E057F20F883E', null, N'install', null, N'1', N'0', N'2016-02-29 16:15:09.937', N'98538F59-2064-4AB9-9F33-59CE3EF84B78')
GO
GO
INSERT INTO [dbo].[User] ([ID], [Name], [Pwd], [UserNo], [RealName], [RoleNo], [IsValid], [IsOnline], [CreateDate], [RoleID]) VALUES (N'5580BD00-FBD0-4CC3-9D80-807FEC4B90A2', N'work', N'E10ADC3949BA59ABBE56E057F20F883E', null, N'work', null, N'1', N'0', N'2016-02-29 16:14:18.687', N'E176DE4C-EBF3-4DBA-9B48-B38F7522B7C1')
GO
GO

-- ----------------------------
-- Indexes structure for table User
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table User
-- ----------------------------
ALTER TABLE [dbo].[User] ADD PRIMARY KEY ([ID])
GO