[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