diff options
| author | Matthew Somerville <matthew-github@dracos.co.uk> | 2019-02-12 14:01:38 +0000 |
|---|---|---|
| committer | Matthew Somerville <matthew-github@dracos.co.uk> | 2019-02-14 16:55:24 +0000 |
| commit | c2089e945132d36468f1d9a3bf08ae4d661cf44a (patch) | |
| tree | 755780edf643ebd8babb910632eb259623fd8a24 /db/schema.sql | |
| parent | 1825a09bbdfee97928a251a84534d859b1a43387 (diff) | |
Allow user to be associated with multiple areas.
Update database to store an array of IDs rather than only one;
consequential changes to the admin and the dashboard to allow
selection.
Diffstat (limited to 'db/schema.sql')
| -rw-r--r-- | db/schema.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/db/schema.sql b/db/schema.sql index c97e8d585..98005028c 100644 --- a/db/schema.sql +++ b/db/schema.sql @@ -35,7 +35,7 @@ create table users ( title text, twitter_id bigint unique, facebook_id bigint unique, - area_id integer, + area_ids integer ARRAY, extra text ); CREATE UNIQUE INDEX users_email_verified_unique ON users (email) WHERE email_verified; |