[prev] [thread] [next] [lurker] [Date index for 2003/05/29]
On Wed, May 28, 2003 at 05:43:22AM +0100, Richard Clamp wrote: > Already the code much cleaner, but I'm currently having trouble > warping my mind to the tao of Class::DBI so I'm checking into a > branch. If all goes well that should be merged back in and become the > mainline over the next few days. Assuming everything went well this is the first message under the newly messed around code. There are still a couple of things to do, mostly with making Plugins properly get stored in a DB, rather than using a mapper function, but that I think should be fairly simple. For those with existing installs from svn here's the SQL to go with the upgrade (created with the help of Alzabo) DROP INDEX deferred___id ON deferred ; ALTER TABLE deferred CHANGE COLUMN id id INTEGER NOT NULL AUTO_INCREMENT ; ALTER TABLE list_plugins CHANGE COLUMN list_id list INTEGER NULL ; ALTER TABLE list_plugins CHANGE COLUMN personal personal TINYINT(1) NULL ; ALTER TABLE list_users CHANGE COLUMN list_id list INTEGER NULL ; ALTER TABLE list_users CHANGE COLUMN user_id user INTEGER NULL ; ALTER TABLE prefs CHANGE COLUMN list_id list INTEGER NULL ; ALTER TABLE prefs CHANGE COLUMN user_id user INTEGER NULL ; -- Richard Clamp <richardc@xxxxxxxxx.xxx>
Generated at 13:56 on 01 Jul 2004 by mariachi 0.52