Followup to r65104, PG updater/table def

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

diff --git a/maintenance/postgres/tables.sql b/maintenance/postgres/tables.sql
index a310aad..456a57c 100644 (file)
--- a/maintenance/postgres/tables.sql
+++ b/maintenance/postgres/tables.sql
@@ -636,3 +636,11 @@ CREATE TABLE l10n_cache (
   lc_value    TEXT    NOT NULL
 );
 CREATE INDEX l10n_cache_lc_lang_key ON l10n_cache (lc_lang, lc_key);
+
+CREATE TABLE iwlinks (
+        iwl_from INTEGER NOT NULL DEFAULT 0,
+        iwl_prefix TEXT NOT NULL DEFAULT '',
+        iwl_title TEXT NOT NULL DEFAULT ''
+);
+CREATE UNIQUE INDEX iwl_from ON iwlinks (iwl_from, iwl_prefix, iwl_title);
+CREATE INDEX iwl_prefix ON iwlinks (iwl_prefix, iwl_title);