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