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


