dsn:#dsn# tablePrefix:#tablePrefix# database:#database# safe:#safe#

Click to drop the tables or database for a clean install.
Or view source.

Drop...
DROP DATABASE IF EXISTS #database# Drop database if exists #database# done
#cfcatch.message# #cfcatch.detail#

Drop...
DROP TABLE IF EXISTS #database#.#tablePrefix##i# Drop table if exists #database#.#tablePrefix##i# done
#cfcatch.message# #cfcatch.detail#

Create...
CREATE DATABASE IF NOT EXISTS #database# Create database if not exists #database# done
#cfcatch.message# #cfcatch.detail#
CREATE TABLE IF NOT EXISTS #database#.#tablePrefix#tblblogcategories ( categoryid varchar(35) NOT NULL default '', categoryname varchar(50) NOT NULL default '', categoryalias varchar(50) default NULL, blog varchar(50) NOT NULL default '', PRIMARY KEY (categoryid) ) ENGINE=MyISAM CREATE TABLE IF NOT EXISTS #database#.#tablePrefix#tblblogcomments ( `id` varchar(35) character set latin1 NOT NULL default '', `entryidfk` varchar(35) character set latin1 default NULL, `name` varchar(50) character set latin1 default NULL, `email` varchar(50) character set latin1 default NULL, `comment` text, `posted` datetime default NULL, `subscribe` tinyint(1) default NULL, `website` varchar(255) default NULL, `moderated` tinyint(1) default NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM CREATE TABLE IF NOT EXISTS #database#.#tablePrefix#tblblogentries ( `id` varchar(35) character set latin1 NOT NULL default '', `title` varchar(100) character set latin1 NOT NULL default '', `body` text NOT NULL, `posted` datetime NOT NULL default '0000-00-00 00:00:00', `morebody` text, `alias` varchar(100) character set latin1 default NULL, `username` varchar(50) character set latin1 default NULL, `blog` varchar(50) character set latin1 NOT NULL default '', `allowcomments` tinyint(1) NOT NULL default '0', `enclosure` varchar(255) character set latin1 default NULL, `filesize` int(11) unsigned default '0', `mimetype` varchar(255) character set latin1 default NULL, `views` int(11) default NULL, `released` tinyint(1) default '0', `mailed` tinyint(1) default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM CREATE TABLE IF NOT EXISTS #database#.#tablePrefix#tblblogentriescategories ( `categoryidfk` varchar(35) character set latin1 default NULL, `entryidfk` varchar(35) character set latin1 default NULL ) ENGINE=MyISAM CREATE TABLE IF NOT EXISTS #database#.#tablePrefix#tblblogentriesrelated ( `id` int(11) default NULL, `entryid` varchar(35) NOT NULL default '', `relatedid` varchar(35) default '' ) ENGINE=MyISAM CREATE TABLE IF NOT EXISTS #database#.#tablePrefix#tblblogpages ( `id` varchar(35) NOT NULL default '', `title` varchar(255) NOT NULL default '', `alias` varchar(100) NOT NULL default '', `body` text NOT NULL, `blog` varchar(50) default NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM CREATE TABLE IF NOT EXISTS #database#.#tablePrefix#tblblogsearchstats ( `searchterm` varchar(255) character set latin1 NOT NULL default '', `searched` datetime NOT NULL default '0000-00-00 00:00:00', `blog` varchar(50) character set latin1 NOT NULL default '' ) ENGINE=MyISAM CREATE TABLE IF NOT EXISTS #database#.#tablePrefix#tblblogsubscribers ( `email` varchar(50) character set latin1 NOT NULL default '', `token` varchar(35) character set latin1 NOT NULL default '', `blog` varchar(50) character set latin1 default NULL, `verified` tinyint(1) NOT NULL default '0' ) ENGINE=MyISAM CREATE TABLE IF NOT EXISTS #database#.#tablePrefix#tblblogtextblocks ( `id` varchar(35) NOT NULL default '', `label` varchar(255) NOT NULL default '', `body` text NOT NULL, `blog` varchar(50) default NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM CREATE TABLE IF NOT EXISTS #database#.#tablePrefix#tblblogtrackbacks ( `Id` varchar(35) character set latin1 NOT NULL default '', `title` varchar(255) character set latin1 NOT NULL default '', `blogname` varchar(255) character set latin1 NOT NULL default '', `posturl` varchar(255) character set latin1 NOT NULL default '', `excerpt` text NOT NULL, `created` datetime NOT NULL default '0000-00-00 00:00:00', `entryid` varchar(35) character set latin1 NOT NULL default '', `blog` varchar(50) character set latin1 NOT NULL default '', PRIMARY KEY (`Id`) ) ENGINE=MyISAM CREATE TABLE IF NOT EXISTS #database#.#tablePrefix#tblusers ( `username` varchar(50) character set latin1 default NULL, `password` varchar(50) character set latin1 default NULL, `name` varchar(50) default NULL ) ENGINE=MyISAM Create table(s) if not exists done
Create tables rolled back.
#cfcatch.message# #cfcatch.detail#
insert into #database#.#tablePrefix#tblusers(username,password,name) values('admin','admin','Admin'); Insert data done
#cfcatch.message# #cfcatch.detail#

Upgrade...
select * from #database#.#tablePrefix#tblusers Update 1 done

select * from #database#.#tablePrefix##i#
* end *