数据库层级设置

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[dt_navigation](
    [id] [int] NOT NULL,
    [nav_type] [nvarchar](50) NULL,
    [name] [nvarchar](50) NULL,
    [title] [nvarchar](100) NULL,
    [sub_title] [nvarchar](100) NULL,
    [link_url] [nvarchar](255) NULL,
    [sort_id] [int] NULL,
    [is_lock] [tinyint] NULL,
    [remark] [nvarchar](max) NULL,
    [parent_id] [int] NULL,
    [class_list] [nvarchar](max) NULL,
    [class_layer] [int] NULL,
    [channel_id] [int] NULL,
    [action_type] [nvarchar](max) NULL,
    [is_sys] [int] NULL
) ON [PRIMARY]

GO
View Code

 

posted @ 2015-05-19 10:07  Coding_Yong  阅读(446)  评论(0编辑  收藏  举报