Blog

Microsoft SQL Script to update BlogCFC 5.92

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 Comment

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>