js_rightdata.sql

来自「本系统是一个报表分析查询系统」· SQL 代码 · 共 19 行

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Js_RightData]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Js_RightData]
GO

CREATE TABLE [dbo].[Js_RightData] (
	[FPos] [int] NOT NULL ,
	[FParentID] [int] NOT NULL ,
	[FParKey] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[FNodeType] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[FKey] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[FDesc] [nvarchar] (500) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[FImg] [int] NOT NULL ,
	[FSelImg] [int] NOT NULL ,
	[FDisPose] [int] NOT NULL ,
	[FIndex] [int] NULL 
) ON [PRIMARY]
GO