# DB
INSERT INTO `qs_DPageItemType` (`id`, `type`, `title`, `sorter`)
VALUES (NULL, 'Blog\\', 'Blog', 130) ;

CREATE TABLE IF NOT EXISTS `qs_PostCategory` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `alias` varchar(255) DEFAULT NULL,
  `title` varchar(255) NOT NULL,
  `sorter` int(11) NOT NULL DEFAULT '0',
  `added` datetime NOT NULL,
  `changed` datetime NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `alias` (`alias`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 ;

CREATE TABLE IF NOT EXISTS `qs_Post2Tag` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idPost` int(11) NOT NULL,
  `idTag` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `idPost` (`idPost`,`idTag`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 ;

CREATE TABLE IF NOT EXISTS `qs_Post` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `date` datetime NOT NULL,
  `title` varchar(255) NOT NULL,
  `alias` varchar(255) DEFAULT NULL,
  `content` mediumtext NOT NULL,
  `rawContent` mediumtext NOT NULL,
  `excerpt` text NOT NULL,
  `authorType` enum('admin','user') DEFAULT NULL,
  `authorId` int(11) DEFAULT NULL,
  `author` varchar(255) DEFAULT NULL,
  `categoryId` int(11) NOT NULL DEFAULT '0',
  `featured` enum('y','n') NOT NULL DEFAULT 'n',
  `password` varchar(255) DEFAULT NULL,
  `allowComment` enum('y','n') NOT NULL DEFAULT 'y',
  `metaKeywords` text,
  `metaDescription` text,
  `added` datetime NOT NULL,
  `changed` datetime NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `alias` (`alias`),
  KEY `date` (`date`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 ;

CREATE TABLE IF NOT EXISTS `qs_PostComment` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idPost` int(11) NOT NULL,
  `date` datetime NOT NULL,
  `title` varchar(255) NOT NULL,
  `author` varchar(255) DEFAULT NULL,
  `authorId` int(11) DEFAULT NULL,
  `authorType` enum('admin','user') DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `content` text NOT NULL,
  `url` varchar(255) DEFAULT NULL,
  `ipAddress` varchar(20) DEFAULT NULL,
  `userAgent` varchar(255) DEFAULT NULL,
  `referer` varchar(255) DEFAULT NULL,
  `status` enum('pending','approved','disapproved','spam') NOT NULL DEFAULT 'pending',
  `added` datetime NOT NULL,
  `changed` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 ;

CREATE TABLE IF NOT EXISTS `qs_PostTag` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `value` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 ;


# sitemap.xml (admin)
...
    <blog showInMenu = "y" title = "Blog">
        <item type = "Redirect_" alias =  "admin/blog/post" />
        <sub>
            <post showInMenu = "y" title = "Blog Posts">
                <item type = "Blog\Admin\" />
            </post>
            <category showInMenu = "y" title = "Blog Categories">
                <item type = "Blog\Category\Admin\" />
            </category>
            <comment showInMenu = "n" title = "Blog Post Comments" final = "y">
                <item type = "Blog\Comment\Admin\" />
            </comment>
            <tag showInMenu = "n" title = "Blog Post Tags" final = "y">
                <item type = "Blog\Tag\Admin\" />
            </tag>
        </sub>
    </blog>
...

# Files
trunk/site/App/Blog/
|   View.php
|   Obj.php
|   install.txt
|   BlogList.php
|   AbstractView.php
|   config.php
|   AbstractObj.php
+---Comment
|   |   View.php
|   |   Obj.php
|   |   CommentList.php
|   |   config.php
|   |   AbstractObj.php
|   +---Admin
|   |   |   View.php
|   |   |   Obj.php
|   |   |   CommentList.php
|   |   \---Form
|   |           NewForm.php
|   |           AbstractForm.php
|   |           EditForm.php
|   |           FilterForm.php
|   \---Form
|           NewForm.php
+---Category
|   |   config.php
|   \---Admin
|       |   View.php
|       |   Obj.php
|       |   CategoryList.php
|       \---Form
|               NewForm.php
|               ReorderForm.php
|               AbstractForm.php
|               EditForm.php
+---Admin
|   |   View.php
|   |   Obj.php
|   |   BlogList.php
|   \---Form
|           NewForm.php
|           AbstractForm.php
|           EditForm.php
|           FilterForm.php
+---Form
|       LoginForm.php
|       ConfigForm.php
\---Tag
    |   config.php
    \---Admin
        |   View.php
        |   TagList.php
        |   Obj.php
        \---Form
                NewForm.php
                AbstractForm.php
                EditForm.php

trunk/site/tpl/Blog/
|   calendar.tpl
|   list.tpl
|   tags-block.tpl
|   view.tpl
|   month.tpl
|   categories-block.tpl
|   featured-list.tpl
+---Comment
|   |   list.tpl
|   |   form.tpl
|   \---Admin
|       |   view.tpl
|       \---cells
|               status.tpl
\---Admin
    \---cells
            category.tpl
            linkComments.tpl
            linkTags.tpl

trunk/www/js/app/
|   admin-blog.js
|   blog.js