[pLog-svn] r2335 - plog/trunk

oscar at devel.plogworld.net oscar at devel.plogworld.net
Thu Jul 14 22:01:16 GMT 2005


Author: oscar
Date: 2005-07-14 22:01:15 +0000 (Thu, 14 Jul 2005)
New Revision: 2335

Modified:
   plog/trunk/wizard.php
Log:
added the table for blog categories and modified the blogs table with the new field


Modified: plog/trunk/wizard.php
===================================================================
--- plog/trunk/wizard.php	2005-07-14 21:45:08 UTC (rev 2334)
+++ plog/trunk/wizard.php	2005-07-14 22:01:15 UTC (rev 2335)
@@ -157,6 +157,7 @@
   id int(10) unsigned NOT NULL auto_increment,
   blog varchar(50) NOT NULL default '',
   owner_id int(10) unsigned NOT NULL default '0',
+  blog_category_id int(10) unsigned NOT NULL default '0',
   about text,
   settings text NOT NULL,
   mangled_blog varchar(50) NOT NULL default '',
@@ -164,7 +165,8 @@
   show_in_summary int(4) not null default '1',
   PRIMARY KEY  (id),
   KEY owner_id (owner_id),
-  KEY mangled_blog (mangled_blog)
+  KEY mangled_blog (mangled_blog),
+  KEY blog_category_id(blog_category_id)
 ) TYPE=MyISAM;";
 
     $Tables[5]["desc"] = "MyLinks";
@@ -448,9 +450,19 @@
    PRIMARY KEY  (id),
    UNIQUE KEY phpbb_id(phpbb_id)
    ) TYPE=MyISAM;";
+   
+   $Tables[26]["desc"] = "Blog categories";
+   $Tables[26]["code"] = "CREATE TABLE {dbprefix}blog_categories (
+   id int(10) unsigned NOT NULL auto_increment,
+   name varchar(255) NOT NULL default '',
+   description varchar(255) NOT NULL default '',
+   mangled_name varchar(255) NOT NULL default '',
+   properties TEXT NOT NULL DEFAULT '',
+   PRIMARY KEY (id),
+   KEY mangled_name(mangled_name)
+   ) TYPE=MyISAM;";
 
 
-
    // ---
    // changes needed to update from 0.3 to 1.0
    $Changes["Articles"] = Array( "ALTER TABLE {dbprefix}articles CHANGE status old_status ENUM('published', 'draft', 'deleted' )",




More information about the pLog-svn mailing list