diff options
| author | CiaranG <ciaran@ciarang.com> | 2008-09-29 02:02:27 -0400 |
|---|---|---|
| committer | CiaranG <ciaran@ciarang.com> | 2008-09-29 02:02:27 -0400 |
| commit | 0d4d0c791195b4990f663997dc1ecdce7bc2e679 (patch) | |
| tree | c7dd371f4aa1233ce7b80d0fead7adf86692f56f /db | |
| parent | 245a75f141081747239269b2270f71288cca806f (diff) | |
PostgreSQL: Put a default on confirm_address.address_extra to mimic mysql's behaviour when a not-null field is not set in a new record
darcs-hash:20080929060227-f6e2c-5996ad74cb5c89052417e36634a22b6e219bd92d.gz
Diffstat (limited to 'db')
| -rw-r--r-- | db/laconica_pg.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/db/laconica_pg.sql b/db/laconica_pg.sql index 24ba0a99a..8d0db9a80 100644 --- a/db/laconica_pg.sql +++ b/db/laconica_pg.sql @@ -218,7 +218,7 @@ create table confirm_address ( code varchar(32) not null primary key /* comment 'good random code' */,
user_id integer not null /* comment 'user who requested confirmation' */ references "user" (id),
address varchar(255) not null /* comment 'address (email, Jabber, SMS, etc.)' */,
- address_extra varchar(255) not null /* comment 'carrier ID, for SMS' */,
+ address_extra varchar(255) not null default '' /* comment 'carrier ID, for SMS' */,
address_type varchar(8) not null /* comment 'address type ("email", "jabber", "sms")' */,
claimed timestamp /* comment 'date this was claimed for queueing' */,
sent timestamp /* comment 'date this was sent for queueing' */,
|