[pLog-svn] dbschemas, deleting columns

Jon Daley plogworld at jon.limedaley.com
Sat Apr 29 20:09:12 GMT 2006


 	I see that the new dbschema thing works quite nicely for updating 
types and adding columns and table..
 	It doesn't appear to remove columns or tables.

This is a little trickier -- and in the case of the removing the 
duplicated config_keys, you have to remove the duplicates before removing 
the column, so I was happy that the dbschema thing didn't try to remove it 
early.  However, I would like to get rid of old columns, so all users of 
1.1 have the same database structure.  What is the best way to do that; 
put in explicit DROP COLUMN x stuff during the update?


**************************************
Jon Daley
http://jon.limedaley.com/

Truth is beautiful, without doubt; but so are lies.
-- Ralph Waldo Emerson


More information about the pLog-svn mailing list