﻿--
CREATE TABLE [Tant_Plugin](
	[Id] [int] IDENTITY(1,1) NOT NULL PRIMARY KEY,
	[Name] [varchar](50) NOT NULL,
	[DefaultPage] [varchar](50) NOT NULL,
	[Path] [varchar](100) NOT NULL,
) ON [PRIMARY]
--
CREATE TABLE [Tant_Menu](
	[ID] [int] IDENTITY(1,1) NOT NULL PRIMARY KEY,
	[Name] [nvarchar](50) NOT NULL,
	[Url] [nvarchar](250) NOT NULL,
	[ParentID] [int] NOT NULL  DEFAULT ((0)),
	[UserID] [uniqueidentifier] NOT NULL  DEFAULT ('00000000-0000-0000-0000-000000000000'),
) ON [PRIMARY]
--
CREATE TABLE [Tant_SimpleArticle_Article](
	[ID] [int] IDENTITY(1,1) NOT NULL PRIMARY KEY,
	[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,
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
--
CREATE TABLE [Tant_SimpleArticle_Category](
	[ID] [int] IDENTITY(1,1) NOT NULL PRIMARY KEY,
	[Path] [nvarchar](50) NOT NULL,
	[Name] [ntext] NOT NULL,
	[ListTemplate] [ntext] NULL,
	[PageTemplate] [ntext] NULL,
 ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
--
CREATE TABLE [dbo].[Tant_Stats](
	[ID] [int] IDENTITY(1,1) NOT NULL PRIMARY KEY,
	[IP] [nvarchar](15) NULL,
	[Page] [nvarchar](250) NULL,
	[UserAgent] [nvarchar](250) NULL,
	[Referer] [nvarchar](250) NULL,
	[LogTime] [smalldatetime] NOT NULL,
) ON [PRIMARY]
--
CREATE TABLE [dbo].[Tant_SimpleArticle_Comment](
	[ID] [int] IDENTITY(1,1) NOT NULL PRIMARY KEY,
	[Name] [nvarchar](50) NOT NULL,
	[Comment] [nvarchar](400) NOT NULL,
	[Aid] [int] NOT NULL
) ON [PRIMARY]
--
INSERT INTO [Tant_Plugin]
           ([Name]
           ,[DefaultPage]
           ,[Path])
     VALUES
           ('简单文章'
           ,'default'
           ,'Tant_SimpleArticle')
INSERT INTO [Tant_Plugin]
           ([Name]
           ,[DefaultPage]
           ,[Path])
     VALUES
           ('文件管理'
           ,'default'
           ,'Tant_Filemanager')

