add from_authority flag to users table for council employees etc

2 files changed, 7 insertions, 0 deletions

diff --git a/db/schema.sql b/db/schema.sql
index bb720077b..984ceb690 100644
--- a/db/schema.sql
+++ b/db/schema.sql
@@ -131,6 +131,7 @@ create table users (
     name            text,
     phone           text,
     password        text    not null default ''
+    from_authority  boolean not null default false -- users is from a council etc
 );
 
 -- Problems reported by users of site
diff --git a/db/schema_0005-add_council_user_flag.sql b/db/schema_0005-add_council_user_flag.sql
new file mode 100644
index 000000000..d8cf1358a
--- /dev/null
+++ b/db/schema_0005-add_council_user_flag.sql
@@ -0,0 +1,6 @@
+begin;
+
+ALTER table users
+    ADD COLUMN from_authority boolean NOT NULL DEFAULT false;
+
+commit;