[mxbb-commits] mx_blogs db_install.php,1.1,1.2

[mhewitson <mhe...@us...>]

Update of /cvsroot/mxbb/mx_blogs
In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv622

Modified Files:
	db_install.php 
Log Message:
- updated db schema for category and category box Mod.


Index: db_install.php
===================================================================
RCS file: /cvsroot/mxbb/mx_blogs/db_install.php,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -d -r1.1 -r1.2
*** db_install.php	7 Jun 2007 22:01:31 -0000	1.1
--- db_install.php	20 Jun 2007 13:19:57 -0000	1.2
***************
*** 250,253 ****
--- 250,258 ----
  	KEY (mood_set)
  )";
+ 
+ $sql[] = "ALTER TABLE " . $mx_table_prefix . "weblog_entries ADD `category` VARCHAR( 60 ) NOT NULL DEFAULT ''";
+ 
+ $sql[] = "ALTER TABLE " . $mx_table_prefix . "weblogs ADD `show_categorybox` TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT 1";
+ 
  $sql[] = "INSERT INTO " . $mx_table_prefix . "weblog_actions (action_id, action_text, action_url) VALUES (1, 'Eating', 'action_eat.gif')";
  $sql[] = "INSERT INTO " . $mx_table_prefix . "weblog_actions (action_id, action_text, action_url) VALUES (2, 'Listening to', 'action_listen.gif')";