ialex at svn
Feb 24, 2009, 11:28 AM
Post #1 of 1
(130 views)
Permalink
|
|
SVN: [47757] trunk/extensions/Configure
|
|
Revision: 47757
Author: ialex
Date: 2009-02-24 19:28:13 +0000 (Tue, 24 Feb 2009)
Log Message:
-----------
Added foreign key constraint in the PostgreSQL's schema
Modified Paths:
--------------
trunk/extensions/Configure/CHANGELOG
trunk/extensions/Configure/Configure.php
trunk/extensions/Configure/configure.pg.sql
Added Paths:
-----------
trunk/extensions/Configure/patch-cs_id_fkey.pg.sql
Modified: trunk/extensions/Configure/CHANGELOG
===================================================================
--- trunk/extensions/Configure/CHANGELOG 2009-02-24 19:00:42 UTC (rev 47756)
+++ trunk/extensions/Configure/CHANGELOG 2009-02-24 19:28:13 UTC (rev 47757)
@@ -1,6 +1,11 @@
This file lists changes on this extension.
Localisation updates are done on betawiki and aren't listed here.
+0.12.5 - 24 February 2009
+ Added foreign key constraint in the PostgreSQL's schema.
+ User who used Configure.pg.sql schema in older versions can use the
+ patch-cs_id_fkey.pg.sql patch.
+
0.12.4 - 19 February 2009
Groups in $wgGroupPermissions are now sorted alphabetically.
Modified: trunk/extensions/Configure/Configure.php
===================================================================
--- trunk/extensions/Configure/Configure.php 2009-02-24 19:00:42 UTC (rev 47756)
+++ trunk/extensions/Configure/Configure.php 2009-02-24 19:28:13 UTC (rev 47757)
@@ -17,7 +17,7 @@
'url' => 'http://www.mediawiki.org/wiki/Extension:Configure',
'description' => 'Allow authorised users to configure the wiki via a web-based interface',
'descriptionmsg' => 'configure-desc',
- 'version' => '0.12.4',
+ 'version' => '0.12.5',
);
# Configuration part
Modified: trunk/extensions/Configure/configure.pg.sql
===================================================================
--- trunk/extensions/Configure/configure.pg.sql 2009-02-24 19:00:42 UTC (rev 47756)
+++ trunk/extensions/Configure/configure.pg.sql 2009-02-24 19:28:13 UTC (rev 47757)
@@ -33,7 +33,7 @@
CREATE TABLE config_setting (
-- foreign key to config_version.cv_id, used for joins
- cs_id INTEGER NOT NULL,
+ cs_id INTEGER NOT NULL REFERENCES config_version( cv_id ) ON DELETE CASCADE,
-- setting's name
cs_name TEXT NOT NULL,
@@ -42,4 +42,4 @@
cs_value TEXT
);
ALTER TABLE config_setting ADD CONSTRAINT cs_id_name PRIMARY KEY ( cs_id, cs_name );
-CREATE INDEX cs_id ON config_setting( cs_id );
\ No newline at end of file
+CREATE INDEX cs_id ON config_setting( cs_id );
Added: trunk/extensions/Configure/patch-cs_id_fkey.pg.sql
===================================================================
--- trunk/extensions/Configure/patch-cs_id_fkey.pg.sql (rev 0)
+++ trunk/extensions/Configure/patch-cs_id_fkey.pg.sql 2009-02-24 19:28:13 UTC (rev 47757)
@@ -0,0 +1,8 @@
+--
+-- Postgres' SQL schema update for Configure extension
+-- for people that applied configure.pg.sql in version < 0.12.5
+--
+
+-- Add foreign key constraint
+ALTER TABLE config_setting ADD CONSTRAINT config_setting_cs_id_fkey
+ FOREIGN KEY ( cs_id ) REFERENCES config_version( cv_id ) ON DELETE CASCADE;
Property changes on: trunk/extensions/Configure/patch-cs_id_fkey.pg.sql
___________________________________________________________________
Added: svn:eol-style
+ native
_______________________________________________
MediaWiki-CVS mailing list
MediaWiki-CVS [at] lists
https://lists.wikimedia.org/mailman/listinfo/mediawiki-cvs
|
