## 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.7-0.8-update.sql,v 1.1 2007/03/07 17:42:57 xen0phage Exp $ ## # You *should* be able to pipe this through mysql to update your database # mysql -uroot -p phpTodo < phpTodo-0.7-0.8-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 CHANGE rss_version version CHAR(8) NOT NULL DEFAULT 'RSS0.91'; ALTER TABLE rss_feeds RENAME feeds; UPDATE feeds SET version = 'RSS0.91' WHERE version = '0.91'; UPDATE feeds SET version = 'RSS1.0' WHERE version = '1.0'; UPDATE feeds SET version = 'RSS2.0' WHERE version = '2.0';