[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