BlogCFC 3.7, a new design, and upgrade SQL
# 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;