﻿--
CREATE TABLE [Tant_Plugin](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[Name] [varchar](50) NOT NULL,
	[DefaultPage] [varchar](50) NOT NULL,
	[Path] [varchar](100) NOT NULL,
 CONSTRAINT [PK_Tant_Plugin] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
--
CREATE TABLE [Tant_Menu](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[Name] [nvarchar](50) NOT NULL,
	[Url] [nvarchar](250) NOT NULL,
	[ParentID] [int] NOT NULL CONSTRAINT [DF_Tant_Menu_ParentID]  DEFAULT ((0)),
	[UserID] [uniqueidentifier] NOT NULL CONSTRAINT [DF_Tant_Menu_UserID]  DEFAULT ('00000000-0000-0000-0000-000000000000'),
 CONSTRAINT [PK_Tant_Menu] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
CREATE TABLE [Tant_SimpleArticle_Article](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[Path] [nvarchar](50) NOT NULL,
	[Title] [nvarchar](250) NOT NULL,
	[Keywords] [nvarchar](250) NOT NULL,
	[Description] [nvarchar](500) NOT NULL,
	[Content] [ntext] NOT NULL,
	[Date] [smalldatetime] NOT NULL,
	[Source] [nvarchar](50) NOT NULL,
 CONSTRAINT [PK_Table_1] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
--
CREATE TABLE [Tant_SimpleArticle_Category](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[Path] [nvarchar](50) NOT NULL,
	[Name] [ntext] NOT NULL,
	[ListTemplate] [ntext] NULL,
	[PageTemplate] [ntext] NULL,
 CONSTRAINT [PK_Tant_SimpleArticle_Category] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
--
INSERT INTO [Tant_Plugin]
           ([Name]
           ,[DefaultPage]
           ,[Path])
     VALUES
           ('简单文章'
           ,'default'
           ,'Tant_SimpleArticle')

