Microsoft SQL Script to update BlogCFC 5.92

4 Jan 2009 by Joshua Scott, No Comments »

I just upgraded tonight to the latest release of BlogCFC, (what runs this blog) and realized that there is not an upgrade script for mssql. I edited the one provided for mysql and here it is:

ALTER TABLE tblblogcomments
 ADD killcomment varchar(35) NULL
ALTER TABLE tblblogcomments
 ADD subscribeonly int NULL
ALTER TABLE tblblogentries
 ADD summary varchar(255) NULL
ALTER TABLE tblblogentries
 ADD subtitle varchar(100) NULL
ALTER TABLE tblblogentries
 ADD keywords varchar(100) NULL
ALTER TABLE tblblogentries
 ADD duration varchar(10) NULL

Leave a Reply

Follow Me!

Follow Me! Follow Me! Follow Me! Follow Me!