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;
#
# 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;
| Tweet |
Comments (0) | 
Print |
Send |
1601 Views
| If you like what you see on the website and/or this post has helped you out in some way please consider donating to help keep me in beer vodka. The donations are made through Paypal, which accepts almost any credit card or eCheck. |