## 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.3-0.4-update.sql,v 1.4 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 users ADD (INDEX (username), INDEX (password)); ALTER TABLE sessions ADD (INDEX (last)); ALTER TABLE listentries ADD (INDEX (category_id), INDEX (priority_id), INDEX (status_id)); ALTER TABLE rss_feeds ADD (INDEX (user_id), INDEX (secret), INDEX (name)); ALTER TABLE rss_feeds MODIFY secret CHAR(15) NOT NULL;