**********************************************************

    blogger.txt
    
    $Id$
    
    @author gERD Schaufelberger <gerd@exit0.net>
    @link http://wombat.exit0.net
    @package wombat
    @subpackage manual

**********************************************************

Blogger
=======


Setup A New Blog
================



Database:
---------
CREATE TABLE `wombatblog` (
  `blogid` int(11) NOT NULL default '0',
  `catid` int(11) NOT NULL default '0',
  `uid` int(11) NOT NULL default '0',
  `created` datetime NOT NULL default '0000-00-00 00:00:00',
  `changed` datetime NOT NULL default '0000-00-00 00:00:00',
  `title` varchar(350) character set utf8 NOT NULL,
  `body` blob NOT NULL,
  PRIMARY KEY  (`blogid`),
  KEY `uid` (`uid`),
  KEY `title` (`title`(333)),
  KEY `catid` (`catid`),
  KEY `created` (`created`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Wombat Blog entries'


CREATE TABLE `wombatblogcategory` (
`catid` INT( 11 ) NOT NULL ,
`title` VARCHAR( 250 ) NOT NULL ,
`blurb` TEXT NOT NULL ,
`created` DATETIME NOT NULL ,
`chnaged` DATETIME NOT NULL ,
PRIMARY KEY ( `catid` ) ,
INDEX ( `title` )
) TYPE = MYISAM CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'Wombat Blog Categories';


CREATE TABLE `wombatblogcomment` (
  `blogcid` int(11) NOT NULL,
  `blogid` int(11) NOT NULL,
  `uid` int(11) default NULL,
  `flags` set('new','approved','deleted') NOT NULL default 'new',
  `created` datetime NOT NULL,
  `changed` datetime default NULL,
  `commentbody` text NOT NULL,
  PRIMARY KEY  (`blogcid`),
  KEY `blogid` (`blogid`),
  KEY `uid` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Wombat blog comments';


/**
 * OLDSCHOOL table layout!
 */

Minimal table definition for a blog (MySQL)
-----------------8<-----------------8<-----------------8<-----------------
CREATE TABLE IF NOT EXISTS webblog (
  _my_id int(11) NOT NULL default '0',
  blogid int(11) NOT NULL default '0',
  uid int(11) NOT NULL default '0',
  created datetime NOT NULL default '0000-00-00 00:00:00',
  changed datetime NOT NULL default '0000-00-00 00:00:00',
  title varchar(100) NOT NULL default '',
; add more fields
) TYPE=MyISAM DEFAULT CHARSET=utf8 COMMENT='wbBlogger - _myBlog_';

CREATE TABLE `wbblogcomment` (
  `blogcid` int(11) NOT NULL,
  `blog` varchar(100) NOT NULL,
  `blogid` int(11) NOT NULL,
  `uid` int(11) default NULL,
  `flags` set('new','approved','deleted') NOT NULL default 'new',
  `created` datetime NOT NULL,
  `changed` datetime default NULL,
  `commentbody` text NOT NULL,
  PRIMARY KEY  (`blogcid`),
  KEY `blog` (`blog`),
  KEY `blogid` (`blogid`),
  KEY `uid` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Blog comments'

-----------------8<-----------------8<-----------------8<-----------------

Usually, you want to add one ore more client specific fields. e.g. 'body', 
'intro'.


Table definition in tables.xml
------------------------------

-----------------8<-----------------8<-----------------8<-----------------
	<tables>
		<!-- 
			more tables...
		-->

		<!-- Blogger tables -->
        <table name="myBlog" table="_myBlogTable_" primary="_my_id">
            <foreign>user</foreign>
            <order>created</order>
            <orderdir>DESC</orderdir>
            <limit>5</limit>
            <callback>getentries,getentry,save</callback>
        </table>
		
	</tables>
</configuration>
-----------------8<-----------------8<-----------------8<-----------------

  
Blogger Config blogger.xml
-----------------8<-----------------8<-----------------8<-----------------
<configuration>
	<xinc href="/defines.xml" once="yes" />
	
        <blog:blog name="my_first_blog" table="myBlog">
            <blog:title>My Blog</blog:title>
            <blog:brief>My first web blog!</blog:brief>
            <!-- a field named "title" is predefined -->
            <blog:fields>
				<!-- Define client specific field -->
                <blog:field type="Text" name="body">
                    <blog:attributes>
                        <blog:att name="title">Text</blog:att>
                        <blog:att name="label">Text</blog:att>
                        <blog:att name="description">Main text</blog:att>
                        <blog:att name="minlength">10</blog:att>
                        <blog:att name="rows">10</blog:att>
                    </blog:attributes>
                </blog:field>
                <blog:field type="String" name="intro">
                    <blog:attributes>
                        <blog:att name="title">Brief</blog:att>
                        <blog:att name="label">Brief</blog:att>
                        <blog:att name="description">Brief introduction</blog:att>
                        <blog:att name="minlength">10</blog:att>
                        <blog:att name="maxlength">200</blog:att>
                    </blog:attributes>
                </blog:field>
                
            </blog:fields>
        </blog:blog>

		<!--Describe more blogs... -->
        <blog:blog name="another_blog" table="another_blog_table">
            <blog:title>YAB</blog:title>
            <blog:brief>Yet another blog</blog:brief>
        </blog:blog>
	
</configuration>
-----------------8<-----------------8<-----------------8<-----------------