You cannot select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
This file contains invisible Unicode characters that may be processed differently from what appears below. If your use case is intentional and legitimate, you can safely ignore this warning. Use the Escape button to reveal hidden characters.
if exists ( select * from dbo . sysobjects where id = object_id ( N ' [dbo].[t_sys_code_emp_back] ' ) and OBJECTPROPERTY ( id , N ' IsUserTable ' ) = 1 )
drop table [ dbo ] . [ t_sys_code_emp_back ]
GO
CREATE TABLE [ dbo ] . [ t_sys_code_emp_back ] (
[ 权限代码 ] [ varchar ] ( 4 ) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[ 一级模块 ] [ varchar ] ( 30 ) COLLATE Chinese_PRC_CI_AS NULL ,
[ 二级模块 ] [ varchar ] ( 30 ) COLLATE Chinese_PRC_CI_AS NULL ,
[ 权限名称 ] [ varchar ] ( 30 ) COLLATE Chinese_PRC_CI_AS NULL ,
[ 人员 ] [ varchar ] ( 10 ) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[ 是否可操作 ] [ bit ] NOT NULL ,
[ 授权人 ] [ varchar ] ( 10 ) COLLATE Chinese_PRC_CI_AS NULL ,
[ 授权日期 ] [ smalldatetime ] NULL ,
[ 取消日期 ] [ smalldatetime ] NULL
) ON [ PRIMARY ]
GO
ALTER TABLE [ dbo ] . [ t_sys_code_emp_back ] WITH NOCHECK ADD
CONSTRAINT [ PK_t_sys_code_emp_back ] PRIMARY KEY CLUSTERED
(
[ 权限代码 ] ,
[ 人员 ]
) ON [ PRIMARY ]
GO