| Index: trunk/phase3/maintenance/postgres/tables.sql |
| — | — | @@ -288,7 +288,7 @@ |
| 289 | 289 | oi_deleted SMALLINT NOT NULL DEFAULT 0, |
| 290 | 290 | oi_sha1 TEXT NOT NULL DEFAULT '' |
| 291 | 291 | ); |
| 292 | | -ALTER TABLE oldimage ADD CONSTRAINT oldimage_oi_name_fkey_cascade FOREIGN KEY (oi_name) REFERENCES image(img_name) ON DELETE CASCADE; |
| | 292 | +ALTER TABLE oldimage ADD CONSTRAINT oldimage_oi_name_fkey_cascade FOREIGN KEY (oi_name) REFERENCES image(img_name) ON DELETE CASCADE ON UPDATE CASCADE; |
| 293 | 293 | CREATE INDEX oi_name_timestamp ON oldimage (oi_name,oi_timestamp); |
| 294 | 294 | CREATE INDEX oi_name_archive_name ON oldimage (oi_name,oi_archive_name); |
| 295 | 295 | CREATE INDEX oi_sha1 ON oldimage (oi_sha1); |