/****** Object: Table [dbo].[Author] Script Date: 11/16/2016 2:49:20 PM
******/
SET ANSI_NULLS
ON
GO
SET QUOTED_IDENTIFIER
ON
GO
CREATE TABLE
[dbo].[Author](
[Id]
[int] IDENTITY(1,1) NOT NULL,
[author_id]
[int] NULL,
[author_login]
[nvarchar](250)
NULL,
[author_email]
[nvarchar](100)
NULL,
[author_display_name]
[nvarchar](500)
NULL,
[author_first_name]
[nvarchar](100)
NULL,
[author_last_name]
[nvarchar](100)
NULL,
[blogId]
[int] NULL,
CONSTRAINT
[PK_Author_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]
GO
/****** Object: Table [dbo].[Category] Script Date: 11/16/2016 2:49:20 PM
******/
SET ANSI_NULLS
ON
GO
SET QUOTED_IDENTIFIER
ON
GO
CREATE TABLE
[dbo].[Category](
[Id]
[int] IDENTITY(1,1) NOT NULL,
[term_id]
[int] NULL,
[category_nicename]
[nvarchar](200)
NULL,
[category_parent]
[nvarchar](200)
NULL,
[cat_name]
[nvarchar](200)
NULL,
[blogId]
[int] NULL,
CONSTRAINT
[PK_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]
GO
/****** Object: Table [dbo].[Item_Author] Script Date: 11/16/2016 2:49:20 PM
******/
SET ANSI_NULLS
ON
GO
SET QUOTED_IDENTIFIER
ON
GO
CREATE TABLE
[dbo].[Item_Author](
[Id]
[int] IDENTITY(1,1) NOT NULL,
[post_id]
[int] NULL,
[author_id]
[int] NULL,
[niceName]
[nvarchar](200)
NULL,
[blogId]
[int] NULL,
CONSTRAINT
[PK_Item_Author] 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]
GO
/****** Object: Table [dbo].[Item_Category] Script Date: 11/16/2016 2:49:20 PM
******/
SET ANSI_NULLS
ON
GO
SET QUOTED_IDENTIFIER
ON
GO
CREATE TABLE
[dbo].[Item_Category](
[Id]
[int] IDENTITY(1,1) NOT NULL,
[post_id]
[int] NULL,
[category_id]
[int] NULL,
[nicename]
[nvarchar](200)
NULL,
[blogId]
[int] NULL,
CONSTRAINT
[PK_Item_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]
GO
/****** Object: Table [dbo].[Item_Tag] Script Date: 11/16/2016 2:49:20 PM
******/
SET ANSI_NULLS
ON
GO
SET QUOTED_IDENTIFIER
ON
GO
CREATE TABLE
[dbo].[Item_Tag](
[Id]
[int] IDENTITY(1,1) NOT NULL,
[post_id]
[int] NULL,
[tag_id]
[int] NULL,
[nicename]
[nvarchar](200)
NULL,
[blogId]
[int] NULL,
CONSTRAINT
[PK_Item_Tag] 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]
GO
/****** Object: Table [dbo].[MainItem] Script Date: 11/16/2016 2:49:20 PM
******/
SET ANSI_NULLS
ON
GO
SET QUOTED_IDENTIFIER
ON
GO
CREATE TABLE
[dbo].[MainItem](
[Id]
[int] IDENTITY(1,1) NOT NULL,
[title]
[nvarchar](200)
NULL,
[post_id]
[int] NULL,
[post_date]
[datetime] NULL,
[main_content]
[nvarchar](max) NULL,
[blogId]
[int] NULL,
[post_status]
[nvarchar](200)
NULL,
[post_link]
[nvarchar](400)
NULL,
[post_name]
[nvarchar](200)
NULL,
CONSTRAINT
[PK_MainItem] 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]
GO
/****** Object: Table [dbo].[Tag] Script Date: 11/16/2016 2:49:20 PM
******/
SET ANSI_NULLS
ON
GO
SET QUOTED_IDENTIFIER
ON
GO
CREATE TABLE
[dbo].[Tag](
[Id]
[int] IDENTITY(1,1) NOT NULL,
[term_id]
[int] NULL,
[tag_slug]
[nvarchar](200)
NULL,
[tag_name]
[nvarchar](200)
NULL,
[blogId]
[int] NULL,
CONSTRAINT
[PK_Tag] 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]
GO
/****** Object: Table [dbo].[Title_Description] Script Date: 11/16/2016 2:49:20 PM
******/
SET ANSI_NULLS
ON
GO
SET QUOTED_IDENTIFIER
ON
GO
CREATE TABLE
[dbo].[Title_Description](
[Id]
[int] IDENTITY(1,1) NOT NULL,
[title]
[nvarchar](200)
NULL,
[description]
[nvarchar](500)
NULL,
CONSTRAINT
[PK_Title_Description] 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]
GO
|