diff options
Diffstat (limited to 'maintenance/archives/patch-archive-text_id.sql')
-rw-r--r-- | maintenance/archives/patch-archive-text_id.sql | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/maintenance/archives/patch-archive-text_id.sql b/maintenance/archives/patch-archive-text_id.sql new file mode 100644 index 00000000..f59715ff --- /dev/null +++ b/maintenance/archives/patch-archive-text_id.sql @@ -0,0 +1,14 @@ +-- New field in archive table to preserve text source IDs across undeletion. +-- +-- Older entries containing NULL in this field will contain text in the +-- ar_text and ar_flags fields, and will cause the (re)creation of a new +-- text record upon undeletion. +-- +-- Newer ones will reference a text.old_id with this field, and the existing +-- entries will be used as-is; only a revision record need be created. +-- +-- Added 2005-05-01 + +ALTER TABLE /*$wgDBprefix*/archive + ADD + ar_text_id int(8) unsigned; |