| Index: trunk/phase3/maintenance/postgres/archives/patch-user_properties.sql |
| — | — | @@ -1,5 +1,5 @@ |
| 2 | 2 | CREATE TABLE user_properties( |
| 3 | | - up_user BIGINT NOT NULL, |
| | 3 | + up_user INTEGER NULL REFERENCES mwuser(user_id) ON DELETE CASCADE, |
| 4 | 4 | up_property TEXT NOT NULL, |
| 5 | 5 | up_value TEXT |
| 6 | 6 | ); |
| Index: trunk/phase3/maintenance/postgres/tables.sql |
| — | — | @@ -581,7 +581,7 @@ |
| 582 | 582 | ); |
| 583 | 583 | |
| 584 | 584 | CREATE TABLE user_properties( |
| 585 | | - up_user BIGINT NOT NULL, |
| | 585 | + up_user INTEGER NULL REFERENCES mwuser(user_id) ON DELETE CASCADE, |
| 586 | 586 | up_property TEXT NOT NULL, |
| 587 | 587 | up_value TEXT |
| 588 | 588 | ); |