?? 菜單相關sql語名.sql
字號:
--創建表
CREATE TABLE [dbo].[SysBaseData](
[BaseDataID] [int] NOT NULL,
[BaseDataCode] [char](10) NOT NULL,
[BaseDataName] [varchar](30) NOT NULL,
[ParentCode] [char](10) NOT NULL,
[Description] [varchar](100) NULL,
[LevelType] [int] NOT NULL,
[VaildType] [char](1) NOT NULL,
[PathCode] [varchar](100) NULL,
[SerialNumberID] [int] NOT NULL,
CONSTRAINT [PK_SysBaseData] PRIMARY KEY NONCLUSTERED
(
[BaseDataID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
-- 插入數據
if exists (select * from sysobjects where id = OBJECT_ID('[SysBaseData]') and OBJECTPROPERTY(id, 'IsUserTable') = 1) DROP TABLE [SysBaseData]
CREATE TABLE [SysBaseData] ( [BaseDataID] [int] NOT NULL , [BaseDataCode] [char] (10) NOT NULL , [BaseDataName] [varchar] (30) NOT NULL , [ParentCode] [char] (10) NOT NULL , [Description] [varchar] (100) NULL , [LevelType] [int] NOT NULL , [VaildType] [char] (1) NOT NULL , [PathCode] [varchar] (100) NULL , [SerialNumberID] [int] NOT NULL )
ALTER TABLE [SysBaseData] WITH NOCHECK ADD CONSTRAINT [PK_SysBaseData] PRIMARY KEY NONCLUSTERED ( [BaseDataID] )
INSERT [SysBaseData] ( [BaseDataID] , [BaseDataCode] , [BaseDataName] , [ParentCode] , [LevelType] , [VaildType] , [SerialNumberID] ) VALUES ( 1 , '0 ' , '基礎數據' , '-1 ' , 1 , '0' , 0 )
INSERT [SysBaseData] ( [BaseDataID] , [BaseDataCode] , [BaseDataName] , [ParentCode] , [LevelType] , [VaildType] , [SerialNumberID] ) VALUES ( 2 , 'ZD ' , '總隊機關' , '0 ' , 2 , '0' , 0 )
INSERT [SysBaseData] ( [BaseDataID] , [BaseDataCode] , [BaseDataName] , [ParentCode] , [LevelType] , [VaildType] , [SerialNumberID] ) VALUES ( 3 , 'ZD01 ' , '司令部' , 'ZD ' , 3 , '0' , 0 )
INSERT [SysBaseData] ( [BaseDataID] , [BaseDataCode] , [BaseDataName] , [ParentCode] , [LevelType] , [VaildType] , [SerialNumberID] ) VALUES ( 4 , 'ZD02 ' , '政治部' , 'ZD ' , 3 , '0' , 0 )
INSERT [SysBaseData] ( [BaseDataID] , [BaseDataCode] , [BaseDataName] , [ParentCode] , [LevelType] , [VaildType] , [SerialNumberID] ) VALUES ( 5 , 'ZD03 ' , '后勤部' , 'ZD ' , 3 , '0' , 0 )
INSERT [SysBaseData] ( [BaseDataID] , [BaseDataCode] , [BaseDataName] , [ParentCode] , [LevelType] , [VaildType] , [SerialNumberID] ) VALUES ( 6 , 'ZD04 ' , '防火部' , 'ZD ' , 3 , '0' , 0 )
INSERT [SysBaseData] ( [BaseDataID] , [BaseDataCode] , [BaseDataName] , [ParentCode] , [LevelType] , [VaildType] , [SerialNumberID] ) VALUES ( 7 , 'SZZD ' , '市州支隊' , '0 ' , 2 , '0' , 0 )
INSERT [SysBaseData] ( [BaseDataID] , [BaseDataCode] , [BaseDataName] , [ParentCode] , [LevelType] , [VaildType] , [SerialNumberID] ) VALUES ( 8 , 'SZZD01 ' , '長沙市消防支隊' , 'SZZD ' , 3 , '0' , 0 )
INSERT [SysBaseData] ( [BaseDataID] , [BaseDataCode] , [BaseDataName] , [ParentCode] , [LevelType] , [VaildType] , [SerialNumberID] ) VALUES ( 9 , 'SZZD02 ' , '湘潭市消防支隊' , 'SZZD ' , 3 , '0' , 0 )
INSERT [SysBaseData] ( [BaseDataID] , [BaseDataCode] , [BaseDataName] , [ParentCode] , [LevelType] , [VaildType] , [SerialNumberID] ) VALUES ( 10 , 'SZZD03 ' , '株州市消防支隊' , 'SZZD ' , 3 , '0' , 0 )
INSERT [SysBaseData] ( [BaseDataID] , [BaseDataCode] , [BaseDataName] , [ParentCode] , [LevelType] , [VaildType] , [SerialNumberID] ) VALUES ( 11 , 'WZLM ' , '網站欄目(包含專題)' , '0 ' , 2 , '0' , 0 )
INSERT [SysBaseData] ( [BaseDataID] , [BaseDataCode] , [BaseDataName] , [ParentCode] , [LevelType] , [VaildType] , [SerialNumberID] ) VALUES ( 12 , 'WZLM01 ' , '消防新聞' , 'WZLM ' , 3 , '0' , 0 )
INSERT [SysBaseData] ( [BaseDataID] , [BaseDataCode] , [BaseDataName] , [ParentCode] , [LevelType] , [VaildType] , [SerialNumberID] ) VALUES ( 13 , 'WZLM02 ' , '通知通告' , 'WZLM ' , 3 , '0' , 0 )
INSERT [SysBaseData] ( [BaseDataID] , [BaseDataCode] , [BaseDataName] , [ParentCode] , [LevelType] , [VaildType] , [SerialNumberID] ) VALUES ( 14 , 'WZLM0101 ' , '總隊消聞' , 'WZLM01 ' , 4 , '0' , 0 )
INSERT [SysBaseData] ( [BaseDataID] , [BaseDataCode] , [BaseDataName] , [ParentCode] , [LevelType] , [VaildType] , [SerialNumberID] ) VALUES ( 15 , 'WZLM0102 ' , '支隊新聞' , 'WZLM01 ' , 4 , '0' , 0 )
INSERT [SysBaseData] ( [BaseDataID] , [BaseDataCode] , [BaseDataName] , [ParentCode] , [LevelType] , [VaildType] , [SerialNumberID] ) VALUES ( 16 , 'WZQX ' , '網站權限' , '0 ' , 2 , '0' , 0 )
INSERT [SysBaseData] ( [BaseDataID] , [BaseDataCode] , [BaseDataName] , [ParentCode] , [LevelType] , [VaildType] , [SerialNumberID] ) VALUES ( 17 , 'WZQX01 ' , '基礎數據管理' , 'WZQX ' , 3 , '0' , 0 )
INSERT [SysBaseData] ( [BaseDataID] , [BaseDataCode] , [BaseDataName] , [ParentCode] , [LevelType] , [VaildType] , [SerialNumberID] ) VALUES ( 18 , 'WZQX02 ' , '用戶管理' , 'WZQX ' , 3 , '0' , 0 )
INSERT [SysBaseData] ( [BaseDataID] , [BaseDataCode] , [BaseDataName] , [ParentCode] , [LevelType] , [VaildType] , [SerialNumberID] ) VALUES ( 19 , 'WZQX03 ' , '數據維護管理' , 'WZQX ' , 3 , '0' , 0 )
INSERT [SysBaseData] ( [BaseDataID] , [BaseDataCode] , [BaseDataName] , [ParentCode] , [LevelType] , [VaildType] , [SerialNumberID] ) VALUES ( 20 , 'WZQX04 ' , '軟件下載管理' , 'WZQX ' , 3 , '0' , 0 )
INSERT [SysBaseData] ( [BaseDataID] , [BaseDataCode] , [BaseDataName] , [ParentCode] , [LevelType] , [VaildType] , [SerialNumberID] ) VALUES ( 21 , 'WZQX05 ' , '首頁管理' , 'WZQX ' , 3 , '0' , 0 )
INSERT [SysBaseData] ( [BaseDataID] , [BaseDataCode] , [BaseDataName] , [ParentCode] , [LevelType] , [VaildType] , [SerialNumberID] ) VALUES ( 22 , 'RJLB ' , '軟件類別' , '0 ' , 2 , '0' , 0 )
INSERT [SysBaseData] ( [BaseDataID] , [BaseDataCode] , [BaseDataName] , [ParentCode] , [LevelType] , [VaildType] , [SerialNumberID] ) VALUES ( 23 , 'RJLB01 ' , '系統軟件' , 'RJLB ' , 3 , '0' , 0 )
INSERT [SysBaseData] ( [BaseDataID] , [BaseDataCode] , [BaseDataName] , [ParentCode] , [LevelType] , [VaildType] , [SerialNumberID] ) VALUES ( 24 , 'RJLB02 ' , '應用軟件' , 'RJLB ' , 3 , '0' , 0 )
INSERT [SysBaseData] ( [BaseDataID] , [BaseDataCode] , [BaseDataName] , [ParentCode] , [LevelType] , [VaildType] , [SerialNumberID] ) VALUES ( 25 , 'RJLB03 ' , '業務軟件' , 'RJLB ' , 3 , '0' , 0 )
INSERT [SysBaseData] ( [BaseDataID] , [BaseDataCode] , [BaseDataName] , [ParentCode] , [LevelType] , [VaildType] , [SerialNumberID] ) VALUES ( 26 , 'DCCK ' , '彈出窗口模式' , '0 ' , 2 , '0' , 0 )
INSERT [SysBaseData] ( [BaseDataID] , [BaseDataCode] , [BaseDataName] , [ParentCode] , [LevelType] , [VaildType] , [SerialNumberID] ) VALUES ( 27 , 'DCCK01 ' , '春節' , 'DCCK ' , 3 , '0' , 0 )
INSERT [SysBaseData] ( [BaseDataID] , [BaseDataCode] , [BaseDataName] , [ParentCode] , [LevelType] , [VaildType] , [SerialNumberID] ) VALUES ( 28 , 'DCCK02 ' , '端午節' , 'DCCK ' , 3 , '0' , 0 )
INSERT [SysBaseData] ( [BaseDataID] , [BaseDataCode] , [BaseDataName] , [ParentCode] , [LevelType] , [VaildType] , [SerialNumberID] ) VALUES ( 29 , 'DCCK02 ' , '中秋節' , 'DCCK ' , 3 , '0' , 0 )
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -