summaryrefslogtreecommitdiff
path: root/maintenance/archives/patch-log_id.sql
diff options
context:
space:
mode:
Diffstat (limited to 'maintenance/archives/patch-log_id.sql')
-rw-r--r--maintenance/archives/patch-log_id.sql8
1 files changed, 8 insertions, 0 deletions
diff --git a/maintenance/archives/patch-log_id.sql b/maintenance/archives/patch-log_id.sql
new file mode 100644
index 00000000..bd69ddb6
--- /dev/null
+++ b/maintenance/archives/patch-log_id.sql
@@ -0,0 +1,8 @@
+-- Log_id field that means one log entry can be referred to with a single number,
+-- rather than a dirty great big mess of features.
+-- This might be useful for single-log-entry deletion, et cetera.
+-- Andrew Garrett, February 2007.
+
+ALTER TABLE /*$wgDBprefix*/logging
+ ADD COLUMN log_id int unsigned not null auto_increment,
+ ADD PRIMARY KEY log_id (log_id);