/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;

/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='SYSTEM' */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE */;
/*!40101 SET SQL_MODE='' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES */;
/*!40103 SET SQL_NOTES='ON' */;


/*!40101 SET NAMES utf8 */;
CREATE TABLE `tblblogcategories` (
  `categoryid` varchar(35) character set utf8 NOT NULL default '',
  `categoryname` varchar(50) character set utf8 NOT NULL default '',
  `categoryalias` varchar(50) default NULL,
  `blog` varchar(50) character set utf8 NOT NULL default '',
  PRIMARY KEY  (`categoryid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE `tblblogcomments` (
  `id` varchar(35) character set utf8 NOT NULL default '',
  `entryidfk` varchar(35) character set utf8 default NULL,
  `name` varchar(50) character set utf8 default NULL,
  `email` varchar(50) character set utf8 default NULL,
  `comment` text character set utf8,
  `posted` datetime default NULL,
  `subscribe` tinyint(1) default NULL,
  `website` varchar(255) default NULL,
   `moderated` tinyint(1) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE `tblblogentries` (
  `id` varchar(35) character set utf8 NOT NULL default '',
  `title` varchar(100) character set utf8 NOT NULL default '',
  `body` text character set utf8 NOT NULL,
  `posted` datetime NOT NULL default '0000-00-00 00:00:00',
  `morebody` text character set utf8,
  `alias` varchar(100) character set utf8 default NULL,
  `username` varchar(50) character set utf8 default NULL,
  `blog` varchar(50) character set utf8 NOT NULL default '',
  `allowcomments` tinyint(1) NOT NULL default '0',
  `enclosure` varchar(255) character set utf8 default NULL,
  `filesize` int(11) unsigned default '0',
  `mimetype` varchar(255) character set utf8 default NULL,
  `views` int(11) default NULL,
  `released` tinyint(1) default '0',
  `mailed` tinyint(1) default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE `tblblogentriescategories` (
  `categoryidfk` varchar(35) character set utf8 default NULL,
  `entryidfk` varchar(35) character set utf8 default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE `tblblogentriesrelated` (
  `id` int(11) default NULL,
  `entryid` varchar(35) NOT NULL default '',
  `relatedid` varchar(35) default ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE `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 DEFAULT CHARSET=utf8;

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;

CREATE TABLE `tblblogsubscribers` (
  `email` varchar(50) character set utf8 NOT NULL default '',
  `token` varchar(35) character set utf8 NOT NULL default '',
  `blog` varchar(50) character set utf8 default NULL,
  `verified` tinyint(1) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE `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 DEFAULT CHARSET=utf8;

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;

CREATE TABLE `tblusers` (
  `username` varchar(50) character set utf8 default NULL,
  `password` varchar(50) character set utf8 default NULL,
  `name` varchar(50) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


/*!40101 SET NAMES utf8 */;

/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;


insert into tblusers(username,password,name) values('admin','admin','Admin');


CREATE INDEX blogComments_entryid ON tblblogcomments(entryidfk);
CREATE INDEX blogComments_posted ON tblblogcomments(posted);
CREATE INDEX blogCategories_blog ON tblblogcategories(blog);
CREATE INDEX blogEntries_blog ON tblblogentries(blog);
CREATE INDEX blogEntries_released ON tblblogentries(released);
CREATE INDEX blogEntriesCategories_entryid ON
tblblogentriescategories(entryidfk, categoryidfk);
CREATE INDEX blogEntriesRelated_entryid ON
tblblogentriesrelated(entryid,relatedid);
CREATE INDEX blogEntriesRelated_relatedid ON
tblblogentriesrelated(relatedid,entryid);
CREATE INDEX blogTrackBacks_entryid ON tblblogtrackbacks(entryid);

/*!40101 SET NAMES utf8 */;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;