diff options
Diffstat (limited to 'maintenance/sqlite/archives/patch-log_user_text.sql')
| -rw-r--r-- | maintenance/sqlite/archives/patch-log_user_text.sql | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/maintenance/sqlite/archives/patch-log_user_text.sql b/maintenance/sqlite/archives/patch-log_user_text.sql new file mode 100644 index 00000000..c7fcc75f --- /dev/null +++ b/maintenance/sqlite/archives/patch-log_user_text.sql @@ -0,0 +1,5 @@ +ALTER TABLE /*$wgDBprefix*/logging ADD COLUMN log_user_text TEXT NOT NULL default ''; +ALTER TABLE /*$wgDBprefix*/logging ADD COLUMN log_page INTEGER NULL; + +CREATE INDEX /*i*/log_user_type_time ON /*_*/logging (log_user, log_type, log_timestamp); +CREATE INDEX /*i*/log_page_id_time ON /*_*/logging (log_page,log_timestamp); |