Fix SQLite patch-(page|template)links-fix-pk.sql column order

[lhc/web/wiklou.git] / maintenance / sqlite / archives / patch-profiling.sql

diff --git a/maintenance/sqlite/archives/patch-profiling.sql b/maintenance/sqlite/archives/patch-profiling.sql
index a711dd7..4a07283 100644 (file)
--- a/maintenance/sqlite/archives/patch-profiling.sql
+++ b/maintenance/sqlite/archives/patch-profiling.sql
@@ -1,11 +1,12 @@
--- profiling table for SQLite
+-- profiling table
 -- This is optional
 
-CREATE TABLE /*$wgDBprefix*/profiling (
+CREATE TABLE /*_*/profiling (
   pf_count int NOT NULL default 0,
   pf_time float NOT NULL default 0,
   pf_memory float NOT NULL default 0,
   pf_name varchar(255) NOT NULL default '',
-  pf_server varchar(30) NOT NULL default '',
-  PRIMARY KEY (pf_name, pf_server)
+  pf_server varchar(30) NOT NULL default ''
 );
+
+CREATE UNIQUE INDEX /*i*/pf_name_server ON /*_*/profiling (pf_name, pf_server);