|
From: mhewitson <mhe...@us...> - 2007-06-20 13:20:04
|
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')"; |