Add new recentchanges field rc_source to replace rc_type

[lhc/web/wiklou.git] / maintenance / tables.sql

diff --git a/maintenance/tables.sql b/maintenance/tables.sql
index 7fc6bb8..b315091 100644 (file)
--- a/maintenance/tables.sql
+++ b/maintenance/tables.sql
@@ -761,7 +761,7 @@ CREATE TABLE /*_*/ipblocks (
   -- Start and end of an address range, in hexadecimal
   -- Size chosen to allow IPv6
   -- FIXME: these fields were originally blank for single-IP blocks,
-  -- but now they are populated. No migration was ever done. They 
+  -- but now they are populated. No migration was ever done. They
   -- should be fixed to be blank again for such blocks (bug 49504).
   ipb_range_start tinyblob NOT NULL,
   ipb_range_end tinyblob NOT NULL,
@@ -1058,6 +1058,10 @@ CREATE TABLE /*_*/recentchanges (
   -- The type of change entry (RC_EDIT,RC_NEW,RC_LOG,RC_EXTERNAL)
   rc_type tinyint unsigned NOT NULL default 0,
 
+  -- The source of the change entry (replaces rc_type)
+  -- default of '' is temporary, needed for initial migration
+  rc_source varchar(16) binary not null default '',
+
   -- If the Recent Changes Patrol option is enabled,
   -- users may mark edits as having been reviewed to
   -- remove a warning flag on the RC list.