NXBlog :: #87. VS 2008을 이용한 블로그 프로그래밍

# Commented By :: 꼬기얌얌얌 At 3/6/2009 11:52:22 AM [D]

안녕하세요 강좌는 잘보구 열심히 따라하구 있습니다..^^
근데 처음에 테이블 만들때 쿼리문좀 올려주시면 안될까요?
그림만 보구 따라할려구 하니 조금 벅차서요...ㅠㅠ

# Commented By :: 최지훈 At 3/9/2009 9:12:07 AM [M] [D]

넵...

USE [BlogDataBase]
GO

/****** Object: Table [dbo].[BLOG_ARCHIVES] Script Date: 03/09/2009 09:09:52 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[BLOG_ARCHIVES](
[archivesdate] [varchar](7) NOT NULL,
[archivescount] [int] NOT NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

USE [BlogDataBase]
GO

/****** Object: Table [dbo].[BLOG_CATEGORIES] Script Date: 03/09/2009 09:09:52 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[BLOG_CATEGORIES](
[categoryid] [int] IDENTITY(1,1) NOT NULL,
[categoryname] [nvarchar](50) NOT NULL,
[sortkey] [smallint] NOT NULL,
[createdate] [datetime] NOT NULL,
[deletedate] [datetime] NULL,
CONSTRAINT [PK_BLOG_CATEGORIES] PRIMARY KEY CLUSTERED
(
[categoryid] 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

USE [BlogDataBase]
GO

/****** Object: Table [dbo].[BLOG_COMMENTS] Script Date: 03/09/2009 09:09:52 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[BLOG_COMMENTS](
[commentid] [int] IDENTITY(1,1) NOT NULL,
[postid] [nvarchar](100) NOT NULL,
[name] [nvarchar](100) NOT NULL,
[password] [varchar](50) NOT NULL,
[homepage] [varchar](100) NULL,
[comment] [ntext] NOT NULL,
[createdate] [datetime] NOT NULL,
CONSTRAINT [PK_BLOG_COMMENTS] PRIMARY KEY CLUSTERED
(
[commentid] 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

SET ANSI_PADDING OFF
GO

USE [BlogDataBase]
GO

/****** Object: Table [dbo].[BLOG_COUNTS] Script Date: 03/09/2009 09:09:52 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[BLOG_COUNTS](
[IP] [varchar](30) NOT NULL,
[VisitDate] [datetime] NOT NULL,
CONSTRAINT [PK_BLOG_COUNTS] PRIMARY KEY CLUSTERED
(
[IP] ASC,
[VisitDate] 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

SET ANSI_PADDING OFF
GO

USE [BlogDataBase]
GO

/****** Object: Table [dbo].[BLOG_LINKS] Script Date: 03/09/2009 09:09:52 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[BLOG_LINKS](
[linkid] [int] IDENTITY(1,1) NOT NULL,
[linkname] [nvarchar](50) NOT NULL,
[linkurl] [varchar](100) NOT NULL,
[sortkey] [smallint] NOT NULL,
[createdate] [datetime] NOT NULL,
[deletedate] [datetime] NULL,
CONSTRAINT [PK_BLOG_LINKS] PRIMARY KEY CLUSTERED
(
[linkid] 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

SET ANSI_PADDING OFF
GO

USE [BlogDataBase]
GO

/****** Object: Table [dbo].[BLOG_NOTICES] Script Date: 03/09/2009 09:09:52 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[BLOG_NOTICES](
[noticeid] [int] NOT NULL,
[noticename] [nvarchar](100) NOT NULL,
[noticecontent] [ntext] NOT NULL,
[createdate] [datetime] NOT NULL,
[deletedate] [datetime] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

USE [BlogDataBase]
GO

/****** Object: Table [dbo].[BLOG_POSTS] Script Date: 03/09/2009 09:09:52 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[BLOG_POSTS](
[postid] [nvarchar](100) NOT NULL,
[categoryid] [int] NOT NULL,
[postname] [nvarchar](100) NOT NULL,
[postcontent] [ntext] NOT NULL,
[createdate] [datetime] NOT NULL,
[deletedate] [datetime] NULL,
[viewcount] [int] NOT NULL,
[commentcount] [int] NOT NULL,
[tag] [nvarchar](300) NOT NULL,
CONSTRAINT [PK_BLOG_POSTS] PRIMARY KEY CLUSTERED
(
[postid] 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

USE [BlogDataBase]
GO

/****** Object: Table [dbo].[BLOG_TAGS] Script Date: 03/09/2009 09:09:52 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[BLOG_TAGS](
[tagname] [nvarchar](50) NOT NULL,
[tagcount] [int] NOT NULL
) ON [PRIMARY]

GO

USE [BlogDataBase]
GO

/****** Object: Table [dbo].[BLOG_USERINFO] Script Date: 03/09/2009 09:09:52 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[BLOG_USERINFO](
[AdminID] [varchar](50) NOT NULL,
[AdminPWD] [varchar](30) NOT NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

ALTER TABLE [dbo].[BLOG_CATEGORIES] WITH CHECK ADD CONSTRAINT [FK_BLOG_CATEGORIES_BLOG_CATEGORIES] FOREIGN KEY([categoryid])
REFERENCES [dbo].[BLOG_CATEGORIES] ([categoryid])
GO

ALTER TABLE [dbo].[BLOG_CATEGORIES] CHECK CONSTRAINT [FK_BLOG_CATEGORIES_BLOG_CATEGORIES]
GO

ALTER TABLE [dbo].[BLOG_COMMENTS] WITH CHECK ADD CONSTRAINT [FK_BLOG_COMMENTS_BLOG_POSTS] FOREIGN KEY([postid])
REFERENCES [dbo].[BLOG_POSTS] ([postid])
GO

ALTER TABLE [dbo].[BLOG_COMMENTS] CHECK CONSTRAINT [FK_BLOG_COMMENTS_BLOG_POSTS]
GO

ALTER TABLE [dbo].[BLOG_POSTS] WITH CHECK ADD CONSTRAINT [FK_BLOG_POSTS_BLOG_CATEGORIES] FOREIGN KEY([categoryid])
REFERENCES [dbo].[BLOG_CATEGORIES] ([categoryid])
GO

ALTER TABLE [dbo].[BLOG_POSTS] CHECK CONSTRAINT [FK_BLOG_POSTS_BLOG_CATEGORIES]
GO

# Commented By :: 꼬기얌얌얌 At 3/12/2009 11:08:38 AM [D]

유후 감사합니당...^^

# Commented By :: Woos At 6/9/2009 8:45:23 PM [D]

안녕하세요. 강좌를 잘보고 있습니다.^^
지금까지 별문제 없이 진행을 했는데요..
URL Rewriting에서 자꾸 오류가 나네요..
참조추가도 다하고 web.config파일도 수정을 다했습니다.
서버 2008에서는 동작을 하지 않나요??

# Commented By :: 초보 At 8/7/2010 10:54:53 AM [D]

저도 URL Rewriting 이 안되네요. win7 x64, iis7.5, vs2008인데요.
URL Rewriting이 안되고 404 에러가 나네여.

# Commented By :: 최지훈 At 8/16/2010 5:54:46 PM [M] [D]

IIS 버전이 업그레이드되면서 해당 기능이 제대로 동작하지 않는 듯합니다.
이 부분은 MVC 프레임워크의 URL 라우팅 기능을 이용하시면 제대루 동작합니다.
관련 포스트를 작성해야 하는데..게으른지라...

NAME ::		PASSWORD ::
MAIL ::		HOMEPAGE ::
COMMENT ::