用户权限管理模块【表结构及SQL语句】

tb_user:用户帐户信息表

列名数据类型允许空说明
UserNamenvarchar(128)N用户ID
Passwordnvarchar(128)N登录名,用户Email
Emailnvarchar(100)Y密码
Questionnvarchar(100)Y重置密码的问题
Answernvarchar(100)Y重置密码的答案
RoleIDintN角色
UserGroupintN用户组
CreateTimedatetimeN帐户创建时间
LastLoginTimedatetimeY上一次登录的时间
StatusintN用户状态
IsOnlinebitN是否在线
IsLimitbitN是否受权限限制,0为受限制
    
  1. /*20120611BYFMX用户表*/
  2. USE[SH_Cloud]
  3. GO
  4. SETANSI_NULLSON
  5. GO
  6. SETQUOTED_IDENTIFIERON
  7. GO
  8. CREATETABLE[dbo].[tb_User](
  9. [UserID][int]IDENTITY(1,1)NOTNULL,
  10. [UserName][nvarchar](128)COLLATEChinese_PRC_CI_ASNOTNULL,
  11. [Password][nvarchar](128)COLLATEChinese_PRC_CI_ASNOTNULL,
  12. [Email][nvarchar](100)COLLATEChinese_PRC_CI_ASNULL,
  13. [Question][nvarchar](100)COLLATEChinese_PRC_CI_ASNULL,
  14. [Answer][nvarchar](100)COLLATEChinese_PRC_CI_ASNULL,
  15. [RoleID][int]NOTNULLCONSTRAINT[DF_Users_RoleID]DEFAULT((0)),
  16. [UserGroup][int]NOTNULLCONSTRAINT[DF_Users_UserGroup]DEFAULT((0)),
  17. [CreateTime][datetime]NOTNULL,
  18. [LastLoginTime][datetime]NULL,
  19. [Status][int]NOTNULLCONSTRAINT[DF_Users_Status]DEFAULT((1)),
  20. [IsOnline][bit]NOTNULLCONSTRAINT[DF_Users_IsOnline]DEFAULT((0)),
  21. [IsLimit][bit]NOTNULLCONSTRAINT[DF_Users_IsLimit]DEFAULT((0)),
  22. CONSTRAINT[PK_User_ID]PRIMARYKEYCLUSTERED
  23. (
  24. [UserID]ASC
  25. )WITH(IGNORE_DUP_KEY=OFF)ON[PRIMARY]
  26. )ON[PRIMARY]
  27. GO
  28. EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'用户ID',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_User',@level2type=N'COLUMN',@level2name=N'UserID'
  29. GO
  30. EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'登录名,用户Email',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_User',@level2type=N'COLUMN',@level2name=N'UserName'
  31. GO
  32. EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'密码',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_User',@level2type=N'COLUMN',@level2name=N'Password'
  33. GO
  34. EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'重置密码的问题',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_User',@level2type=N'COLUMN',@level2name=N'Question'
  35. GO
  36. EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'重置密码的答案',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_User',@level2type=N'COLUMN',@level2name=N'Answer'
  37. GO
  38. EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'角色',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_User',@level2type=N'COLUMN',@level2name=N'RoleID'
  39. GO
  40. EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'用户组',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_User',@level2type=N'COLUMN',@level2name=N'UserGroup'
  41. GO
  42. EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'帐户创建时间',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_User',@level2type=N'COLUMN',@level2name=N'CreateTime'
  43. GO
  44. EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'上一次登录的时间',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_User',@level2type=N'COLUMN',@level2name=N'LastLoginTime'
  45. GO
  46. EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'用户状态',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_User',@level2type=N'COLUMN',@level2name=N'Status'
  47. GO
  48. EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'是否在线',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_User',@level2type=N'COLUMN',@level2name=N'IsOnline'
  49. GO
  50. EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'是否受权限限制,0为受限制',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_User',@level2type=N'COLUMN',@level2name=N'IsLimit'
  51. GO
  52. EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'用户帐户信息表',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_User'

tb_Role:角色信息表
列名数据类型允许空说明
RoleIDintN角色ID
RoleGroupIDintN分组ID
RoleNamenvarchar(30)N角色名称
RoleDescriptionnvarchar(50)Y说明
RoleOrderintN排序
    
  1. /*20120611BYFMX*/
  2. USE[SH_Cloud]
  3. GO
  4. SETANSI_NULLSON
  5. GO
  6. SETQUOTED_IDENTIFIERON
  7. GO
  8. CREATETABLE[dbo].[tb_Role](
  9. [RoleID][int]IDENTITY(1,1)NOTNULL,
  10. [RoleGroupID][int]NOTNULL,
  11. [RoleName][nvarchar](30)COLLATEChinese_PRC_CI_ASNOTNULL,
  12. [RoleDescription][nvarchar](50)COLLATEChinese_PRC_CI_ASNULL,
  13. [RoleOrder][int]NOTNULLCONSTRAINT[DF_tb_Role_RoleOrder]DEFAULT((0)),
  14. CONSTRAINT[PK_tb_Role_1]PRIMARYKEYCLUSTERED
  15. (
  16. [RoleID]ASC
  17. )WITH(IGNORE_DUP_KEY=OFF)ON[PRIMARY]
  18. )ON[PRIMARY]
  19. GO
  20. EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'角色ID',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_Role',@level2type=N'COLUMN',@level2name=N'RoleID'
  21. GO
  22. EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'分组ID',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_Role',@level2type=N'COLUMN',@level2name=N'RoleGroupID'
  23. GO
  24. EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'角色名称',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_Role',@level2type=N'COLUMN',@level2name=N'RoleName'
  25. GO
  26. EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'说明',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_Role',@level2type=N'COLUMN',@level2name=N'RoleDescription'

tb_Action:权限信息表
列名数据类型允许空说明
ActionIDintN权限ID
ActionNamenvarchar(30)N权限名称
ActionTagnvarchar(50)N权限标识
ActionDescriptionnvarchar(50)Y说明
ActionOrderintN排序
  1. /*20120611BYFMX权限表*/
  2. USE[SH_Cloud]
  3. GO
  4. SETANSI_NULLSON
  5. GO
  6. SETQUOTED_IDENTIFIERON
  7. GO
  8. CREATETABLE[dbo].[tb_Action](
  9. [ActionID][int]IDENTITY(1,1)NOTNULL,
  10. [ActionName][nvarchar](30)COLLATEChinese_PRC_CI_ASNOTNULL,
  11. [ActionTag][nvarchar](50)COLLATEChinese_PRC_CI_ASNOTNULL,
  12. [ActionDescription][nvarchar](50)COLLATEChinese_PRC_CI_ASNULL,
  13. [ActionOrder][int]NOTNULLCONSTRAINT[DF_ActionDir_ActionOrder]DEFAULT((0)),
  14. CONSTRAINT[PK_tb_Action_1]PRIMARYKEYCLUSTERED
  15. (
  16. [ActionID]ASC
  17. )WITH(IGNORE_DUP_KEY=OFF)ON[PRIMARY]
  18. )ON[PRIMARY]
  19. GO
  20. EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'权限ID',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_Action',@level2type=N'COLUMN',@level2name=N'ActionID'
  21. GO
  22. EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'权限名称',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_Action',@level2type=N'COLUMN',@level2name=N'ActionName'
  23. GO
  24. EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'权限标识',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_Action',@level2type=N'COLUMN',@level2name=N'ActionTag'
  25. GO
  26. EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'说明',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_Action',@level2type=N'COLUMN',@level2name=N'ActionDescription'
  27. GO
  28. EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'排序',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_Action',@level2type=N'COLUMN',@level2name=N'ActionOrder'

tb_Group:分组信息表
列名数据类型允许空说明
GroupIDintN分组ID
GroupNamenvarchar(30)N组名称
GroupOrderintN排序
GroupDescriptionnvarchar(50)Y说明
GroupTypeintN分组类型 用户组0,角色组1
  1. /*20120611BYFMX分组表*/
  2. USE[SH_Cloud]
  3. GO
  4. SETANSI_NULLSON
  5. GO
  6. SETQUOTED_IDENTIFIERON
  7. GO
  8. CREATETABLE[dbo].[tb_Group](
  9. [GroupID][int]IDENTITY(1,1)NOTNULL,
  10. [GroupName][nvarchar](30)COLLATEChinese_PRC_CI_ASNOTNULL,
  11. [GroupOrder][int]NOTNULLCONSTRAINT[DF_RGP_UserGroup_UserGroupOrder]DEFAULT((0)),
  12. [GroupDescription][nvarchar](50)COLLATEChinese_PRC_CI_ASNULL,
  13. [GroupType][int]NOTNULLCONSTRAINT[DF_tb_Group_GroupType]DEFAULT((0)),
  14. CONSTRAINT[PK_tb_Group]PRIMARYKEYCLUSTERED
  15. (
  16. [GroupID]ASC
  17. )WITH(IGNORE_DUP_KEY=OFF)ON[PRIMARY]
  18. )ON[PRIMARY]
  19. GO
  20. EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'分组ID',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_Group',@level2type=N'COLUMN',@level2name=N'GroupID'
  21. GO
  22. EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'组名称',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_Group',@level2type=N'COLUMN',@level2name=N'GroupName'
  23. GO
  24. EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'排序',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_Group',@level2type=N'COLUMN',@level2name=N'GroupOrder'
  25. GO
  26. EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'说明',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_Group',@level2type=N'COLUMN',@level2name=N'GroupDescription'
  27. GO
  28. EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'分组类型用户组0,角色组1',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_Group',@level2type=N'COLUMN',@level2name=N'GroupType'

tb_UserRole:用户角色信息表
列名数据类型允许空说明
UR_IDintN用户角色ID
UserIDintN用户ID
RoleIDintN角色ID
  1. /*20120611BYFMX用户角色表*/
  2. USE[SH_Cloud]
  3. GO
  4. SETANSI_NULLSON
  5. GO
  6. SETQUOTED_IDENTIFIERON
  7. GO
  8. CREATETABLE[dbo].[tb_UserRole](
  9. [UR_ID][int]IDENTITY(1,1)NOTNULL,
  10. [UserID][int]NOTNULL,
  11. [RoleID][int]NOTNULL,
  12. CONSTRAINT[PK_tb_UserRole]PRIMARYKEYCLUSTERED
  13. (
  14. [UR_ID]ASC
  15. )WITH(IGNORE_DUP_KEY=OFF)ON[PRIMARY]
  16. )ON[PRIMARY]

tb_UserGroup:用户分组信息表
列名数据类型允许空说明
UG_IDintN用户组ID
UG_Namenvarchar(30)N用户分组名称
UG_OrderintN用户分组排序
UG_Descriptionnvarchar(50)N用户分组描述
UG_DepthintN用户分组深度
UG_SuperiorIDintN用户分组上级
UG_CountintN用户分组下级数
  1. /*20120611BYFMX用户分组信息表*/
  2. USE[SH_Cloud]
  3. GO
  4. SETANSI_NULLSON
  5. GO
  6. SETQUOTED_IDENTIFIERON
  7. GO
  8. CREATETABLE[dbo].[tb_UserGroup](
  9. [UG_ID][int]IDENTITY(1,1)NOTNULL,
  10. [UG_Name][nvarchar](30)COLLATEChinese_PRC_CI_ASNOTNULL,
  11. [UG_Order][int]NOTNULL,
  12. [UG_Description][nvarchar](50)COLLATEChinese_PRC_CI_ASNOTNULL,
  13. [UG_Depth][int]NOTNULLCONSTRAINT[DF_tb_UserGroup_UG_Depth]DEFAULT((0)),
  14. [UG_SuperiorID][int]NOTNULLCONSTRAINT[DF_tb_UserGroup_UG_SuperiorID]DEFAULT((0)),
  15. [UG_Count][int]NOTNULLCONSTRAINT[DF_tb_UserGroup_UG_Count]DEFAULT((0)),
  16. CONSTRAINT[PK_tb_UserGroup]PRIMARYKEYCLUSTERED
  17. (
  18. [UG_ID]ASC
  19. )WITH(IGNORE_DUP_KEY=OFF)ON[PRIMARY]
  20. )ON[PRIMARY]
  21. GO
  22. EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'用户组ID',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_UserGroup',@level2type=N'COLUMN',@level2name=N'UG_ID'
  23. GO
  24. EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'用户分组名称',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_UserGroup',@level2type=N'COLUMN',@level2name=N'UG_Name'
  25. GO
  26. EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'用户分组排序',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_UserGroup',@level2type=N'COLUMN',@level2name=N'UG_Order'
  27. GO
  28. EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'用户分组描述',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_UserGroup',@level2type=N'COLUMN',@level2name=N'UG_Description'
  29. GO
  30. EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'用户分组深度',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_UserGroup',@level2type=N'COLUMN',@level2name=N'UG_Depth'
  31. GO
  32. EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'用户分组上级',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_UserGroup',@level2type=N'COLUMN',@level2name=N'UG_SuperiorID'
  33. GO
  34. EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'用户分组下级数',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_UserGroup',@level2type=N'COLUMN',@level2name=N'UG_Count'

tb_MenuType:菜单类型信息表
列名数据类型允许空说明
MenuTypeIDintN菜单分类ID
MenuTypeNamenvarchar(30)N菜单类型名称
MenuTypeOrderintN排序
MenuTypeDescriptionnvarchar(50)Y说明
MenuTypeDepthintN深度
MenuTypeSuperiorIDintN上级ID
MenuTypeCountintN下阶个数
  1. /*20120611BYFMX目录类型表*/
  2. USE[SH_Cloud]
  3. GO
  4. SETANSI_NULLSON
  5. GO
  6. SETQUOTED_IDENTIFIERON
  7. GO
  8. CREATETABLE[dbo].[tb_MenuType](
  9. [MenuTypeID][int]IDENTITY(1,1)NOTNULL,
  10. [MenuTypeName][nvarchar](30)COLLATEChinese_PRC_CI_ASNOTNULL,
  11. [MenuTypeOrder][int]NOTNULLCONSTRAINT[DF_ModuleGroup_ModuleGroupOrder]DEFAULT((0)),
  12. [MenuTypeDescription][nvarchar](50)COLLATEChinese_PRC_CI_ASNULL,
  13. [MenuTypeDepth][int]NOTNULLCONSTRAINT[DF_tb_MenuType_MenuTypeDepth]DEFAULT((0)),
  14. [MenuTypeSuperiorID][int]NOTNULLCONSTRAINT[DF_tb_MenuType_MenuTypeSuperiorID]DEFAULT((0)),
  15. [MenuTypeCount][int]NOTNULLCONSTRAINT[DF_tb_MenuType_MenuTypeCount]DEFAULT((0)),
  16. CONSTRAINT[PK_tb_MenuType_1]PRIMARYKEYCLUSTERED
  17. (
  18. [MenuTypeID]ASC
  19. )WITH(IGNORE_DUP_KEY=OFF)ON[PRIMARY]
  20. )ON[PRIMARY]
  21. GO
  22. EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'模块分类ID',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_MenuType',@level2type=N'COLUMN',@level2name=N'MenuTypeID'
  23. GO
  24. EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'模块类型名称',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_MenuType',@level2type=N'COLUMN',@level2name=N'MenuTypeName'
  25. GO
  26. EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'排序',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_MenuType',@level2type=N'COLUMN',@level2name=N'MenuTypeOrder'
  27. GO
  28. EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'说明',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_MenuType',@level2type=N'COLUMN',@level2name=N'MenuTypeDescription'
  29. GO
  30. EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'深度',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_MenuType',@level2type=N'COLUMN',@level2name=N'MenuTypeDepth'
  31. GO
  32. EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'上级ID',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_MenuType',@level2type=N'COLUMN',@level2name=N'MenuTypeSuperiorID'
  33. GO
  34. EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'下级个数',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_MenuType',@level2type=N'COLUMN',@level2name=N'MenuTypeCount'

tb_Menu:菜单信息表
列名数据类型允许空说明
MenuIDintN菜单ID
MenuTypeIDintN菜单类型
MenuNamenvarchar(30)N菜单名称
MenuTagnvarchar(50)N菜单标识
MenuURLnvarchar(500)Y菜单地址
MenuDisabledbitN是否禁用
MenuOrderintN排序
MenuDescriptionnvarchar(50)Y说明
IsMenubitN是否显示在导航菜单中
  1. /*20120611BYFMX菜单表*/
  2. USE[SH_Cloud]
  3. GO
  4. SETANSI_NULLSON
  5. GO
  6. SETQUOTED_IDENTIFIERON
  7. GO
  8. CREATETABLE[dbo].[tb_Menu](
  9. [MenuID][int]IDENTITY(1,1)NOTNULL,
  10. [MenuTypeID][int]NOTNULL,
  11. [MenuName][nvarchar](30)COLLATEChinese_PRC_CI_ASNOTNULL,
  12. [MenuTag][nvarchar](50)COLLATEChinese_PRC_CI_ASNOTNULL,
  13. [MenuURL][nvarchar](500)COLLATEChinese_PRC_CI_ASNULL,
  14. [MenuDisabled][bit]NOTNULLCONSTRAINT[DF_tb_Menu_MenuDisabled]DEFAULT((1)),
  15. [MenuOrder][int]NOTNULLCONSTRAINT[DF_tb_Menu_MenuOrder]DEFAULT((0)),
  16. [MenuDescription][nvarchar](50)COLLATEChinese_PRC_CI_ASNULL,
  17. [IsMenu][bit]NOTNULLCONSTRAINT[DF_tb_Menu_IsMenu]DEFAULT((1)),
  18. CONSTRAINT[PK_tb_Menu]PRIMARYKEYCLUSTERED
  19. (
  20. [MenuID]ASC
  21. )WITH(IGNORE_DUP_KEY=OFF)ON[PRIMARY]
  22. )ON[PRIMARY]
  23. GO
  24. EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'模块ID',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_Menu',@level2type=N'COLUMN',@level2name=N'MenuID'
  25. GO
  26. EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'模块类型',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_Menu',@level2type=N'COLUMN',@level2name=N'MenuTypeID'
  27. GO
  28. EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'模块名称',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_Menu',@level2type=N'COLUMN',@level2name=N'MenuName'
  29. GO
  30. EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'模块标识',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_Menu',@level2type=N'COLUMN',@level2name=N'MenuTag'
  31. GO
  32. EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'模块地址',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_Menu',@level2type=N'COLUMN',@level2name=N'MenuURL'
  33. GO
  34. EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'是否禁用',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_Menu',@level2type=N'COLUMN',@level2name=N'MenuDisabled'
  35. GO
  36. EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'排序',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_Menu',@level2type=N'COLUMN',@level2name=N'MenuOrder'
  37. GO
  38. EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'说明',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_Menu',@level2type=N'COLUMN',@level2name=N'MenuDescription'
  39. GO
  40. EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'是否显示在导航菜单中',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_Menu',@level2type=N'COLUMN',@level2name=N'IsMenu'

tb_MenuAction:菜单权限信息表
列名数据类型允许空说明
IDintN菜单权限ID
MenuIDintN菜单ID
ActionTagnvarchar(50)N权限标识
  1. /*20120611BYFMX模块权限表*/
  2. USE[SH_Cloud]
  3. GO
  4. SETANSI_NULLSON
  5. GO
  6. SETQUOTED_IDENTIFIERON
  7. GO
  8. CREATETABLE[dbo].[tb_MenuAction](
  9. [ID][int]IDENTITY(1,1)NOTNULL,
  10. [MenuID][int]NOTNULL,
  11. [ActionTag][nvarchar](50)COLLATEChinese_PRC_CI_ASNOTNULL,
  12. CONSTRAINT[PK_tb_MenuAction]PRIMARYKEYCLUSTERED
  13. (
  14. [ID]ASC
  15. )WITH(IGNORE_DUP_KEY=OFF)ON[PRIMARY]
  16. )ON[PRIMARY]
  17. GO
  18. EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'模块权限ID',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_MenuAction',@level2type=N'COLUMN',@level2name=N'ID'
  19. GO
  20. EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'模块ID',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_MenuAction',@level2type=N'COLUMN',@level2name=N'MenuID'
  21. GO
  22. EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'权限标识',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_MenuAction',@level2type=N'COLUMN',@level2name=N'ActionTag'

tb_RoleAction:角色权限信息表
列名数据类型允许空说明
IDintN编号
UserIDintN用户ID
RoleIDintN角色ID
GroupIDintN分组ID
MenuIDintN菜单ID
ActionTagnvarchar(50)N权限标识
FlagbitN1为允许,0为不禁止
  1. /*20120611BYFMX角色权限表*/
  2. USE[SH_Cloud]
  3. GO
  4. SETANSI_NULLSON
  5. GO
  6. SETQUOTED_IDENTIFIERON
  7. GO
  8. CREATETABLE[dbo].[tb_RoleAction](
  9. [ID][int]IDENTITY(1,1)NOTNULL,
  10. [UserID][int]NOTNULLCONSTRAINT[DF_tb_RoleAction_UserID]DEFAULT((0)),
  11. [RoleID][int]NOTNULLCONSTRAINT[DF_tb_RoleAction_RoleID]DEFAULT((0)),
  12. [GroupID][int]NOTNULLCONSTRAINT[DF_tb_RoleAction_GroupID]DEFAULT((0)),
  13. [MenuID][int]NOTNULL,
  14. [ActionTag][nvarchar](50)COLLATEChinese_PRC_CI_ASNOTNULL,
  15. [Flag][bit]NOTNULLCONSTRAINT[DF_tb_RoleAction_Flag]DEFAULT((1)),
  16. CONSTRAINT[PK_tb_RoleAction]PRIMARYKEYCLUSTERED
  17. (
  18. [ID]ASC
  19. )WITH(IGNORE_DUP_KEY=OFF)ON[PRIMARY]
  20. )ON[PRIMARY]
  21. GO
  22. EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'编号',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_RoleAction',@level2type=N'COLUMN',@level2name=N'ID'
  23. GO
  24. EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'用户ID',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_RoleAction',@level2type=N'COLUMN',@level2name=N'UserID'
  25. GO
  26. EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'角色ID',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_RoleAction',@level2type=N'COLUMN',@level2name=N'RoleID'
  27. GO
  28. EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'分组ID',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_RoleAction',@level2type=N'COLUMN',@level2name=N'GroupID'
  29. GO
  30. EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'模块ID',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_RoleAction',@level2type=N'COLUMN',@level2name=N'MenuID'
  31. GO
  32. EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'权限标识',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_RoleAction',@level2type=N'COLUMN',@level2name=N'ActionTag'
  33. GO
  34. EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'1为允许,0为不禁止',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_RoleAction',@level2type=N'COLUMN',@l
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值