Change: "deleted" flag on all of the main tables
Henry Andrews
In the next major release of the system, currently scheduled to be deployed
around November 15th, all of the tables will have a "deleted" boolean column
(tinyint(1) in MySQL terms). When this column is true, the record should be
considered deleted and not used in active data sets.
We intend to filter deleted rows out of the regular dumps, as they do not
provide useful data (and may in fact be archived out of the main tables at some
point in the future). However, it is quite likely that we will not have time
to
write dump scripts to filter these out before the release must be deployed, as
there are other reasons it must go out by the 15th. Currently we are using a
simple call to mysqldump, which does not give us any way to put WHERE
conditions
on the table dumps as far as I know. We will probably follow up the release
with an update script, but there may be a few dumps with rows having deleted=1
in the meantime.
Please contact the gcd-tech group if you have any concerns. You may also
track this issue at:
http://dev.comics.org/bugs/show_bug.cgi?id=480
thanks,
-henry