t_RolePermission 建表语句（编号：20110622A0745 ）

最新推荐文章于 2021-01-11 16:42:05 发布

原创最新推荐文章于 2021-01-11 16:42:05 发布 · 711 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#null #statistics #table #脚本

本文介绍了一个用于创建角色权限表的SQL脚本。该表包括角色ID、权限ID、创建时间、最后修改时间及备注等字段，并设置了主键及默认值。

USE [db_NLMRPII] GO /****** 对象: Table [dbo].[t_RolePermission] 脚本日期: 06/22/2011 07:43:25 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[t_RolePermission]( [f_intRolePermissionId] [int] IDENTITY(1,1) NOT NULL, [f_intRoleId] [int] NOT NULL, [f_intPermissionId] [int] NOT NULL, [f_dtmCreated] [datetime] NOT NULL CONSTRAINT [DF_t_RoleRight_f_dtmCreated] DEFAULT (getdate()), [f_dtmLastModified] [datetime] NOT NULL CONSTRAINT [DF_t_RoleRight_f_dtmLastModified] DEFAULT (getdate()), [f_strNote] [varchar](50) NOT NULL, CONSTRAINT [PK_t_RoleRight] PRIMARY KEY CLUSTERED ( [f_intRolePermissionId] 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