diff options
Diffstat (limited to 'db')
| -rw-r--r-- | db/downgrade_0061---0060.sql | 5 | ||||
| -rw-r--r-- | db/schema.sql | 3 | ||||
| -rw-r--r-- | db/schema_0061-add-extra-body.sql | 5 |
3 files changed, 12 insertions, 1 deletions
diff --git a/db/downgrade_0061---0060.sql b/db/downgrade_0061---0060.sql new file mode 100644 index 000000000..d6934b9b0 --- /dev/null +++ b/db/downgrade_0061---0060.sql @@ -0,0 +1,5 @@ +BEGIN; + +ALTER TABLE body DROP extra; + +COMMIT; diff --git a/db/schema.sql b/db/schema.sql index d08ea675d..fa0bd07bd 100644 --- a/db/schema.sql +++ b/db/schema.sql @@ -57,7 +57,8 @@ create table body ( 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' + deleted boolean not null default 'f', + extra text ); create table body_areas ( diff --git a/db/schema_0061-add-extra-body.sql b/db/schema_0061-add-extra-body.sql new file mode 100644 index 000000000..125b171fb --- /dev/null +++ b/db/schema_0061-add-extra-body.sql @@ -0,0 +1,5 @@ +BEGIN; + +ALTER TABLE body ADD extra text; + +COMMIT; |