Change from global to parameter.

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

diff --git a/maintenance/ibm_db2/tables.sql b/maintenance/ibm_db2/tables.sql
index c203104..bf5a949 100644 (file)
--- a/maintenance/ibm_db2/tables.sql
+++ b/maintenance/ibm_db2/tables.sql
@@ -248,16 +248,16 @@ CREATE INDEX externallinks_index   ON externallinks (el_index);
 --
 CREATE TABLE external_user (
   -- Foreign key to user_id
-  eu_wiki_id                   BIGINT NOT NULL PRIMARY KEY,
+  eu_local_id                  BIGINT NOT NULL PRIMARY KEY,
 
   -- Some opaque identifier provided by the external database
   eu_external_id               VARCHAR(255) NOT NULL
 );
 CREATE UNIQUE INDEX eu_external_id_idx
        ON external_user (eu_external_id)
-       INCLUDE (eu_wiki_id);
-CREATE UNIQUE INDEX eu_wiki_id_idx
-       ON external_user (eu_wiki_id)
+       INCLUDE (eu_local_id);
+CREATE UNIQUE INDEX eu_local_id_idx
+       ON external_user (eu_local_id)
        INCLUDE (eu_external_id);
 
 
@@ -721,27 +721,6 @@ CREATE TABLE log_search (
 CREATE UNIQUE INDEX ls_field_val ON log_search (ls_field,ls_value,ls_log_id);
 CREATE INDEX ls_log_id ON log_search (ls_log_id);
 
-CREATE TABLE mediawiki_version (
-  type         VARCHAR(1024)         NOT NULL,
-  mw_version   VARCHAR(1024)         NOT NULL,
-  notes        VARCHAR(1024)         ,
-
-  pg_version   VARCHAR(1024)         ,
-  pg_dbname    VARCHAR(1024)         ,
-  pg_user      VARCHAR(1024)         ,
-  pg_port      VARCHAR(1024)         ,
-  mw_schema    VARCHAR(1024)         ,
-  ts2_schema   VARCHAR(1024)         ,
-  ctype        VARCHAR(1024)         ,
-
-  sql_version  VARCHAR(1024)         ,
-  sql_date     VARCHAR(1024)         ,
-  cdate        TIMESTAMP(3)  NOT NULL DEFAULT CURRENT TIMESTAMP
-);
-
-INSERT INTO mediawiki_version (type,mw_version,sql_version,sql_date)
-  VALUES ('Creation','??','$LastChangedRevision: 34049 $','$LastChangedDate: 2008-04-30 10:20:36 -0400 (Wed, 30 Apr 2008) $');
-
 -- Table for storing localisation data
 CREATE TABLE l10n_cache (
   -- Language code