Andy Jarrett // Code. Develop. Manage.

BlogCFC 3.7, a new design, and upgrade SQL

I've finally gotten around to putting up BlogCFC 3.7 along with a new design again (i get bored of my own work quickly). The install as usual went smoothly with the only annoying bit was having to move my new design from the 3.6.3 code base to the 3.7 days before it was going to go live - cheers ray ;o)For anyone else on MySQL who is just about to do the update the only DB change required i've put into a SQL script below.
# Upgrade from BlogCFC 3.6.3 to 3.7
#
# Disclaimer: This comes "as-is"

# Replace ****** with your database name
USE `andyjarrett`;

# Add `allowcomments`.
# Please note that i have defaulted this to ON ('1') so that all you old posts have comments allowed.
ALTER TABLE `tblblogentries` ADD COLUMN `allowcomments` tinyint(1) NOT NULL DEFAULT '1';

# Add the tblblogsubscribers table
CREATE TABLE `tblblogsubscribers` (
`email` varchar(50) NOT NULL default '',
`token` varchar(35) NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

I’m here, learning and working away. If you liked this content and want to keep me going, consider buying me a coffee.
Your support keeps this site running and the coffee brewing! ☕️