111,098
社区成员




select count('Allproject') into @MonitorExists from sp_databases
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER procedure [dbo].[CheckExistMonitor]
as
BEGIN
if NOT EXISTS(SELECT 1 FROM master.dbo.sysdatabases WHERE NAME='Allproject')
BEGIN
execute (' create database Allproject')
EXECUTE ('
create table Allproject.dbo.ProjectInfo --项目信息表
(
ProjectName varchar(50) primary key,
ProjectNote varchar(150) null,
CreateTime datetime not null,
CreatePlace varchar(50) null,
CreatePerson varchar(25) not null,
ApplyMachine varchar(25) null
)
create table Allproject.dbo.UserInfo --用户信息表
(
UserName varchar(25) primary key,
UserPwd varchar(25) not null,
UserRole varchar(10) not null check(UserRole in(''管理人员'',''普通人员'')) default ''普通人员'',
UserPermission varchar(400) not null,
CreateTime datetime not null,
CreatePlace varchar(50) null
)
create table Allproject.dbo.UserLog --用户日志表
(
UserName varchar(25) primary key,
LoginTime datetime not null,
ExitTime datetime null,
)
')
end
end