1 -- Nuggie

     2 -- Version 0.1

     3 -- Copyright (C) 2007 Dan Fuhry

     4 

     5 -- This program is Free Software; you can redistribute and/or modify it under the terms of the GNU General Public License

     6 -- as published by the Free Software Foundation; either version 2 of the License, or (at your option) any later version.

     7 

     8 -- This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied

     9 -- warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for details.

    10 

    11 CREATE TABLE {{TABLE_PREFIX}}blogs(

    12   blog_id int(12) NOT NULL auto_increment,

    13   blog_name varchar(255) NOT NULL,

    14   blog_subtitle text NOT NULL,

    15   user_id int(12) NOT NULL,

    16   blog_type ENUM('private', 'public') NOT NULL DEFAULT 'public',

    17   allowed_users text,

    18   PRIMARY KEY ( blog_id )

    19 ) ENGINE = MyISAM CHARACTER SET utf8 COLLATE utf8_bin;

    20 

    21 CREATE TABLE {{TABLE_PREFIX}}planets(

    22   planet_id smallint(6) NOT NULL auto_increment,

    23   planet_name varchar(255) NOT NULL,

    24   planet_subtitle text NOT NULL,

    25   planet_creator int(12) NOT NULL DEFAULT 1,

    26   planet_public tinyint(1) NOT NULL DEFAULT 0,

    27   planet_visible tinyint(1) NOT NULL DEFAULT 1,

    28   PRIMARY KEY ( planet_id )

    29 ) ENGINE = MyISAM CHARACTER SET utf8 COLLATE utf8_bin;

    30 

    31 CREATE TABLE {{TABLE_PREFIX}}blog_posts(

    32   post_id int(15) NOT NULL auto_increment,

    33   post_title text NOT NULL,

    34   post_title_clean text NOT NULL,

    35   post_author int(12) NOT NULL DEFAULT 1,

    36   post_text longtext NOT NULL,

    37   post_timestamp int(32) NOT NULL DEFAULT 0,

    38   post_published tinyint(1) NOT NULL DEFAULT 0,

    39   PRIMARY KEY ( post_id )

    40 ) ENGINE = MyISAM CHARACTER SET utf8 COLLATE utf8_bin;

    41