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