[pLog-svn] dbschemas, deleting columns

Oscar Renalias oscar at renalias.net
Mon May 1 17:59:28 GMT 2006


Removing columns was never the goal of the database schemas thingie/ 
data dictionary and I think the best way is as you said, add DROP  
COLUMN commands wherever needed.

Oscar

On 29 Apr 2006, at 23:09, Jon Daley wrote:

> 	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
> _______________________________________________
> pLog-svn mailing list
> pLog-svn at devel.lifetype.net
> http://devel.lifetype.net/mailman/listinfo/plog-svn
>



More information about the pLog-svn mailing list