| Index: trunk/extensions/Configure/CHANGELOG |
| — | — | @@ -1,6 +1,11 @@ |
| 2 | 2 | This file lists changes on this extension. |
| 3 | 3 | Localisation updates are done on betawiki and aren't listed here. |
| 4 | 4 | |
| | 5 | +0.12.5 - 24 February 2009 |
| | 6 | + Added foreign key constraint in the PostgreSQL's schema. |
| | 7 | + User who used Configure.pg.sql schema in older versions can use the |
| | 8 | + patch-cs_id_fkey.pg.sql patch. |
| | 9 | + |
| 5 | 10 | 0.12.4 - 19 February 2009 |
| 6 | 11 | Groups in $wgGroupPermissions are now sorted alphabetically. |
| 7 | 12 | |
| Index: trunk/extensions/Configure/Configure.php |
| — | — | @@ -17,7 +17,7 @@ |
| 18 | 18 | 'url' => 'http://www.mediawiki.org/wiki/Extension:Configure', |
| 19 | 19 | 'description' => 'Allow authorised users to configure the wiki via a web-based interface', |
| 20 | 20 | 'descriptionmsg' => 'configure-desc', |
| 21 | | - 'version' => '0.12.4', |
| | 21 | + 'version' => '0.12.5', |
| 22 | 22 | ); |
| 23 | 23 | |
| 24 | 24 | # Configuration part |
| Index: trunk/extensions/Configure/configure.pg.sql |
| — | — | @@ -33,7 +33,7 @@ |
| 34 | 34 | CREATE TABLE config_setting ( |
| 35 | 35 | |
| 36 | 36 | -- foreign key to config_version.cv_id, used for joins |
| 37 | | - cs_id INTEGER NOT NULL, |
| | 37 | + cs_id INTEGER NOT NULL REFERENCES config_version( cv_id ) ON DELETE CASCADE, |
| 38 | 38 | |
| 39 | 39 | -- setting's name |
| 40 | 40 | cs_name TEXT NOT NULL, |
| — | — | @@ -42,4 +42,4 @@ |
| 43 | 43 | cs_value TEXT |
| 44 | 44 | ); |
| 45 | 45 | ALTER TABLE config_setting ADD CONSTRAINT cs_id_name PRIMARY KEY ( cs_id, cs_name ); |
| 46 | | -CREATE INDEX cs_id ON config_setting( cs_id ); |
| \ No newline at end of file |
| | 46 | +CREATE INDEX cs_id ON config_setting( cs_id ); |
| Index: trunk/extensions/Configure/patch-cs_id_fkey.pg.sql |
| — | — | @@ -0,0 +1,8 @@ |
| | 2 | +-- |
| | 3 | +-- Postgres' SQL schema update for Configure extension |
| | 4 | +-- for people that applied configure.pg.sql in version < 0.12.5 |
| | 5 | +-- |
| | 6 | + |
| | 7 | +-- Add foreign key constraint |
| | 8 | +ALTER TABLE config_setting ADD CONSTRAINT config_setting_cs_id_fkey |
| | 9 | + FOREIGN KEY ( cs_id ) REFERENCES config_version( cv_id ) ON DELETE CASCADE; |
| Property changes on: trunk/extensions/Configure/patch-cs_id_fkey.pg.sql |
| ___________________________________________________________________ |
| Name: svn:eol-style |
| 1 | 10 | + native |