[pLog-svn] dbschemas, deleting columns

[Jon Daley]

 	Ok, I will implement a bunch of this soon.

On Mon, 1 May 2006, Oscar Renalias wrote:

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

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

It is now proved beyond doubt that smoking
is one of the leading causes of statistics.
-- Fletcher Knebel