## 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.5-0.6-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.5-0.6-update.sql # If you have altered the tables, this will probably fail. As always, BACK UP # YOUR DATA before you try this! ALTER TABLE listentries ADD (create_date DATETIME, last_modified TIMESTAMP); ALTER TABLE user_prefs ADD (sort_stabilizer CHAR(15) NOT NULL DEFAULT 'taskid', sort_order CHAR(3) NOT NULL DEFAULT 'asc'); # Note : This changes status entries for ALL completed items. If you've changed # the status codes, understand what is being done here before you do it! UPDATE listentries SET status_id = 50 WHERE status_id = 3; UPDATE status SET status = 'Waiting on Someone' WHERE id = 3; INSERT INTO status VALUES (50, 'In Progress'); INSERT INTO status VALUES (98, 'Cancelled');