[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