BlogEngine SQL 2000 Scripts

by Andy 22. September 2008 12:55

My host only provides SQL Server 2000 so I modified the setup scripts and thought I'd publish the changes as my first post on my new blog.  Only two general changes where required:

  1.  [nvarchar](max)columns changed to [nText].
  2. Table contrainsts changed - None of the WITH parameters are supported.

Here is a sample of the original script with the changed script below.  I have also attached the file for others to use MSSQL2000Setup1.4.5.0.sql (25.01 kb).

Orinigal:

  1. /****** Object:  Table [dbo].[be_Pages]    Script Date: 12/22/2007 14:15:17 ******/
  2. SET ANSI_NULLS ON
  3. GO
  4. SET QUOTED_IDENTIFIER ON
  5. GO
  6. CREATE TABLE [dbo].[be_Pages](
  7.     [PageID] [uniqueidentifier] ROWGUIDCOL  NOT NULL CONSTRAINT [DF_be_Pages_PageID]  DEFAULT (newid()),
  8.     [Title] [nvarchar](255) NULL,
  9.     [Description] [nvarchar](max) NULL,
  10.     [PageContent] [nvarchar](max) NULL,
  11.     [Keywords] [nvarchar](max) NULL,
  12.     [DateCreated] [datetime] NULL,
  13.     [DateModified] [datetime] NULL,
  14.     [IsPublished] [bit] NULL,
  15.     [IsFrontPage] [bit] NULL,
  16.     [Parent] [uniqueidentifier] NULL,
  17.     [ShowInList] [bit] NULL,
  18.  CONSTRAINT [PK_be_Pages] PRIMARY KEY CLUSTERED
  19. (
  20.     [PageID] ASC
  21. )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  22. ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
  23. GO

Changed:

  1. /****** Object:  Table [dbo].[be_Pages]    Script Date: 12/22/2007 14:15:17 ******/
  2. SET ANSI_NULLS ON
  3. GO
  4. SET QUOTED_IDENTIFIER ON
  5. GO
  6. CREATE TABLE [dbo].[be_Pages](
  7.     [PageID] [uniqueidentifier] ROWGUIDCOL  NOT NULL CONSTRAINT [DF_be_Pages_PageID]  DEFAULT (newid()),
  8.     [Title] [nvarchar](255) NULL,
  9.     [Description] [ntext] NULL,
  10.     [PageContent] [ntext] NULL,
  11.     [Keywords] [ntext] NULL,
  12.     [DateCreated] [datetime] NULL,
  13.     [DateModified] [datetime] NULL,
  14.     [IsPublished] [bit] NULL,
  15.     [IsFrontPage] [bit] NULL,
  16.     [Parent] [uniqueidentifier] NULL,
  17.     [ShowInList] [bit] NULL,
  18.  CONSTRAINT [PK_be_Pages] PRIMARY KEY CLUSTERED
  19. (
  20.     [PageID] ASC
  21. )) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
  22. GO

 

Currently rated 4.0 by 1 people

  • Currently 4/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags: ,

BlogEngine | BlogEngine

E-mail | Kick it! | DZone it! | del.icio.us
Permalink | Comments (613) | Post RSSRSS comment feed

Powered by BlogEngine.NET 1.4.5.0
Theme by Mads Kristensen

About The Author

I am a .Net developer living in New Zealand.  Somehow I manage to find time (with 2 children) to do some coding and play with Robots.  I am using this blog to document my ideas and progress on my personal robot project.

Tag cloud

RecentPosts