【SQL开源代码栏目提醒】:网学会员为需要SQL开源代码的朋友们搜集整理了复件FrameWork.sql相关资料,希望对各位网友有所帮助!
/*==============================================================*/
/* Database name: FrameWork */
/* DBMS name: SQL SERVER 2000(EXTENDED) */
/* Created on: 2007-7-28 16:47:26 */
/*==============================================================*/
if exists (select 1
from sysobjects
where id = object_id('dbo.sys_Applications')
and type = 'U')
drop table dbo.sys_Applications
go
if exists (select 1
from sysobjects
where id = object_id('dbo.sys_Event')
and type = 'U')
drop table dbo.sys_Event
go
if exists (select 1
from sysobjects
where id = object_id('dbo.sys_Field')
and type = 'U')
drop table dbo.sys_Field
go
if exists (select 1
from sysobjects
where id = object_id('dbo.sys_FieldValue')
and type = 'U')
drop table dbo.sys_FieldValue
go
if exists (select 1
from sysobjects
where id = object_id('dbo.sys_Group')
and type = 'U')
drop table dbo.sys_Group
go
if exists (select 1
from sysobjects
where id = object_id('dbo.sys_Module')
and type = 'U')
drop table dbo.sys_Module
go
if exists (select 1
from sysobjects
where id = object_id('dbo.sys_RoleApplication')
and type = 'U')
drop table dbo.sys_RoleApplication
go
if exists (select 1
from sysobjects
where id = object_id('dbo.sys_RolePermission')
and type = 'U')
drop table dbo.sys_RolePer
mission
go
if exists (select 1
from sysobjects
where id = object_id('dbo.sys_Roles')
and type = 'U')
drop table dbo.sys_Roles
go
if exists (select 1
from sysobjects
where id = object_id('dbo.sys_SystemInfo')
and type = 'U')
drop table dbo.sys_SystemInfo
go
if exists (select 1
from sysobjects
where id = object_id('dbo.sys_User')
and type = 'U')
drop table dbo.sys_User
go
if exists (select 1
from sysobjects
where id = object_id('dbo.sys_UserRoles')
and type = 'U')
drop table dbo.sys_UserRoles
go
/*==============================================================*/
/* Table: sys_Applications */
/*==============================================================*/
create table dbo.sys_Applications (
ApplicationID int identity,
A_AppName nvarchar(50) null,
A_AppDescription nvarchar(200) null,
A_AppUrl varchar(50) null,
constraint PK_SYS_APPLICATIONS primary key clustered (ApplicationID)
)
go
EXECUTE sp_addextendedproperty N'MS_Description', N'自动ID 1:为
系统管理应用', N'user', N'dbo', N'table', N'sys_Applications', N'column', N'ApplicationID'
go
EXECUTE sp_addextendedproperty N'MS_Description', N'应用名称', N'user', N'dbo', N'table', N'sys_Applications', N'column', N'A_AppName'
go
EXECUTE sp_addextendedproperty N'MS_Description', N'应用介绍', N'user', N'dbo', N'table', N'sys_Applications', N'column', N'A_AppDescription'
go
EXECUTE sp_addextendedproperty N'MS_Description', N'应用Url地址', N'user', N'dbo', N'table', N'sys_Applications', N'column', N'A_AppUrl'
go
/*==============================================================*/
/* Table: sys_Event */
/*==============================================================*/
create table dbo.sys_Event (
EventID int identity,
E_U_LoginName nvarchar(20) null,
E_UserID int null,
E_DateTime datetime not null default getdate(),
E_ApplicationID int null,
E_A_AppName nvarchar(50) null,
E_M_Name nvarchar(50) null,
E_M_PageCode varchar(6) null,
E_From nvarchar(500) null,
E_Type tinyint not null default 1,
E_IP varchar(15) null,
E_Record nvarchar(500) null,
constraint PK_SYS_EVENT primary key clustered (EventID)
)
go
EXECUTE sp_addextendedproperty N'MS_Description', N'事件ID号', N'user', N'dbo', N'table', N'sys_Event', N'column', N'EventID'
go
EXECUTE sp_addextendedproperty N'MS_Description', N'用户名', N'user', N'dbo', N'table', N'sys_Event', N'column', N'E_U_LoginName'
go
EXECUTE sp_addextendedproperty N'MS_Description', N'操作时用户ID与sys_Users中UserID', N'user', N'dbo', N'table', N'sys_Event', N'column', N'E_UserID'
go
EXECUTE sp_addextendedproperty N'MS_Description', N'事件发生的日期及时间', N'user', N'dbo', N'table', N'sys_Event', N'column', N'E_DateTime'
go
EXECUTE sp_addextendedproperty N'MS_Description', N'所属应用
程序ID与sys_Applicatio', N'user', N'dbo', N'table', N'sys_Event', N'column', N'E_ApplicationID'
go
EXECUTE sp_addextendedproperty N'MS_Description', N'所属应用名称', N'user', N'dbo', N'table', N'sys_Event', N'column', N'E_A_AppName'
go
EXECUTE sp_addextendedproperty N'MS_Desc