## phpTodo - Web based todo lists ## ## Copyright (C) 2005-07 Jason Frisvold <friz@godshell.com> ## ## ## ## This program is free software; you can redistribute it and/or modify ## ## it under the terms of the GNU General Public License as published by ## ## the Free Software Foundation; either version 2 of the License, or ## ## (at your option) any later version. ## ## ## ## This program is distributed in the hope that it will be useful, ## ## but WITHOUT ANY WARRANTY; without even the implied warranty of ## ## MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the ## ## GNU General Public License for more details. ## ## ## ## You should have received a copy of the GNU General Public License ## ## along with this program; if not, write to the Free Software ## ## Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA ## ## $Id: phpTodo-0.2-0.3-update.sql,v 1.5 2007/03/06 17:58:04 xen0phage Exp $ ## # You *should* be able to pipe this through mysql to update your database # mysql -uroot -p phpTodo < phpTodo-0.2-0.3-update.sql # If you have altered the tables, this will probably fail. As always, BACK UP YOUR DATA # before you try this! ALTER TABLE rss_feeds ADD (rss_version CHAR(8) NOT NULL DEFAULT '0.91', category INTEGER UNSIGNED NOT NULL DEFAULT 0, FOREIGN KEY (category) REFERENCES category(id)); ALTER TABLE listentries ADD (category_id INTEGER UNSIGNED NOT NULL DEFAULT 1, FOREIGN KEY (category_id) REFERENCES category(id)); CREATE TABLE category (id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, category CHAR(15) NOT NULL, user_id INTEGER UNSIGNED NOT NULL, PRIMARY KEY (id), INDEX (user_id), FOREIGN KEY (user_id) REFERENCES users(id)); ALTER TABLE user_prefs ADD (category_filter INTEGER UNSIGNED NOT NULL DEFAULT 0, FOREIGN KEY (category_filter) REFERENCES category(id)); INSERT INTO category VALUES (NULL, 'None', 0); INSERT INTO category VALUES (NULL, 'Personal', 0); INSERT INTO category VALUES (NULL, 'Work', 0); INSERT INTO category VALUES (NULL, 'Other', 0);