diff options
Diffstat (limited to 'db')
| -rw-r--r-- | db/downgrade_0060---0059.sql | 5 | ||||
| -rw-r--r-- | db/schema.sql | 1 | ||||
| -rw-r--r-- | db/schema_0060-add-convert_latlong.sql | 5 |
3 files changed, 11 insertions, 0 deletions
diff --git a/db/downgrade_0060---0059.sql b/db/downgrade_0060---0059.sql new file mode 100644 index 000000000..67ba29eb1 --- /dev/null +++ b/db/downgrade_0060---0059.sql @@ -0,0 +1,5 @@ +BEGIN; + +ALTER TABLE body DROP convert_latlong; + +COMMIT; diff --git a/db/schema.sql b/db/schema.sql index 7d4b90d3d..d08ea675d 100644 --- a/db/schema.sql +++ b/db/schema.sql @@ -56,6 +56,7 @@ create table body ( send_extended_statuses boolean not null default 'f', fetch_problems boolean not null default 'f', blank_updates_permitted boolean not null default 'f', + convert_latlong boolean not null default 'f', deleted boolean not null default 'f' ); diff --git a/db/schema_0060-add-convert_latlong.sql b/db/schema_0060-add-convert_latlong.sql new file mode 100644 index 000000000..50c617e2c --- /dev/null +++ b/db/schema_0060-add-convert_latlong.sql @@ -0,0 +1,5 @@ +BEGIN; + +ALTER TABLE body ADD convert_latlong boolean default 'f' not null; + +COMMIT; |