Blog CFC 4 MySQL update script

#
# Table structure for table tblblogtrackbacks
#

DROP TABLE IF EXISTS `tblblogtrackbacks`;
CREATE TABLE `tblblogtrackbacks` (
`Id` varchar(35) character set utf8 NOT NULL default '',
`title` varchar(255) character set utf8 NOT NULL default '',
`blogname` varchar(255) character set utf8 NOT NULL default '',
`posturl` varchar(255) character set utf8 NOT NULL default '',
`excerpt` text character set utf8 NOT NULL,
`created` datetime NOT NULL default '0000-00-00 00:00:00',
`entryid` varchar(35) character set utf8 NOT NULL default '',
`blog` varchar(50) character set utf8 NOT NULL default '',
PRIMARY KEY (`Id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

#
# Table structure for table tblblogsearchstats
#

DROP TABLE IF EXISTS `tblblogsearchstats`;
CREATE TABLE `tblblogsearchstats` (
`searchterm` varchar(255) character set utf8 NOT NULL default '',
`searched` datetime NOT NULL default '0000-00-00 00:00:00',
`blog` varchar(50) character set utf8 NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


# Adds new column to the subscribers table
ALTER TABLE `tblblogsubscribers`
ADD COLUMN `blog` varchar(50) CHARACTER SET utf8 NULL;


# Adds new 'website' column to the commentss table
ALTER TABLE `tblblogcomments`
ADD COLUMN `website` varchar(255) CHARACTER SET utf8 NULL AFTER `email`;