| Index: trunk/extensions/ConfirmAccount/ConfirmAccount.pg.sql |
| — | — | @@ -18,9 +18,9 @@ |
| 19 | 19 | acr_notes TEXT, |
| 20 | 20 | acr_urls TEXT, |
| 21 | 21 | acr_ip CIDR, |
| 22 | | - acr_deleted BOOL NOT NULL, |
| | 22 | + acr_deleted BOOL NOT NULL DEFAULT 'false', |
| 23 | 23 | acr_rejected TIMESTAMPTZ, |
| 24 | | - acr_user INTEGER REFERENCES mwuser(user_id) ON DELETE SET NULL |
| | 24 | + acr_user INTEGER REFERENCES mwuser(user_id) ON DELETE SET NULL |
| 25 | 25 | ); |
| 26 | 26 | |
| 27 | 27 | CREATE INDEX acr_deleted_reg ON account_requests (acr_deleted,acr_registration); |