r47032 MediaWiki - Code Review archive

Repository:MediaWiki
Revision:r47031‎ | r47032 | r47033 >
Date:11:55, 9 February 2009
Author:ialex
Status:deferred
Tags:
Comment:
Change config_setting unique index to primary key, as in MySQL schema
Modified paths:
  • /trunk/extensions/Configure/configure.pg.sql (modified) (history)

Diff [purge]

Index: trunk/extensions/Configure/configure.pg.sql
@@ -12,7 +12,7 @@
1313 -- wiki concerned by this version
1414 cv_wiki TEXT NOT NULL,
1515
16 - -- TS_MV timestamp of the version
 16+ -- TS_POSTGRES timestamp of the version
1717 cv_timestamp TIMESTAMPTZ NOT NULL,
1818
1919 -- Whether this is the latest version for cv_wiki, will be used to get
@@ -41,5 +41,5 @@
4242 -- setting's value, in php serialized format
4343 cs_value TEXT
4444 );
45 -CREATE UNIQUE INDEX cs_id_name ON config_setting( cs_id, cs_name );
 45+ALTER TABLE config_setting ADD CONSTRAINT cs_id_name PRIMARY KEY ( cs_id, cs_name );
4646 CREATE INDEX cs_id ON config_setting( cs_id );
\ No newline at end of file

Status & tagging log