aboutsummaryrefslogtreecommitdiffstats
path: root/db
diff options
context:
space:
mode:
authorChris Mytton <self@hecticjeff.net>2013-09-10 16:43:43 +0100
committerChris Mytton <self@hecticjeff.net>2013-09-10 18:09:48 +0100
commite462f67cfa42e2e39cb39dbbab93ce05280c31e1 (patch)
tree35dcc483188b9dfba80b0514fc9ad01f60877bb1 /db
parent6d75192471bf910a1e36e0bd2b58e12e6d9a6768 (diff)
[Zurich] Update schema.sql with body.deleted column
Diffstat (limited to 'db')
-rw-r--r--db/schema.sql3
1 files changed, 2 insertions, 1 deletions
diff --git a/db/schema.sql b/db/schema.sql
index 5e4bc4a3e..5c54e2d88 100644
--- a/db/schema.sql
+++ b/db/schema.sql
@@ -64,7 +64,8 @@ create table body (
comment_user_id int references users(id),
suppress_alerts boolean not null default 'f',
can_be_devolved boolean not null default 'f',
- send_extended_statuses boolean not null default 'f'
+ send_extended_statuses boolean not null default 'f',
+ deleted boolean not null default 'f'
);
create table body_areas (