On Tue, 2006-02-14 at 17:10 +0100, Lele Gaifax wrote: > Christopher Lenz ha scritto: > > I'd recommend creating a new table instead of modifying the default > > schema, though. And simply link it 1-to-1 to the node_change/revision > > table. > > What's the rationale behind that? I'd need to intercept intercept other > changes on that table, such as "empty-before-resync"...
In order to keep the upgrade scripts compatible with older versions of SQLite that do not support "ALTER TABLE ADD COLUMN", scripts that need to alter a table typically select the data into a temp table, then drop and recreate the table. Columns added by plugins would be lost in this process. Chris may also have other reasons for suggesting the extra table. -- Matthew Good <[EMAIL PROTECTED]> _______________________________________________ Trac-dev mailing list [email protected] http://lists.edgewall.com/mailman/listinfo/trac-dev
