diff options
Diffstat (limited to 'db')
-rw-r--r-- | db/downgrade_0057---0056.sql | 5 | ||||
-rw-r--r-- | db/downgrade_0058---0057.sql | 5 | ||||
-rw-r--r-- | db/schema.sql | 2 | ||||
-rw-r--r-- | db/schema_0057-fetch-problems.sql | 5 | ||||
-rw-r--r-- | db/schema_0058-blank-updates-permitted.sql | 5 |
5 files changed, 22 insertions, 0 deletions
diff --git a/db/downgrade_0057---0056.sql b/db/downgrade_0057---0056.sql new file mode 100644 index 000000000..a87488e41 --- /dev/null +++ b/db/downgrade_0057---0056.sql @@ -0,0 +1,5 @@ +BEGIN; + +ALTER TABLE body DROP fetch_problems; + +COMMIT; diff --git a/db/downgrade_0058---0057.sql b/db/downgrade_0058---0057.sql new file mode 100644 index 000000000..1ce8f527c --- /dev/null +++ b/db/downgrade_0058---0057.sql @@ -0,0 +1,5 @@ +BEGIN; + +ALTER TABLE body DROP blank_updates_permitted; + +COMMIT; diff --git a/db/schema.sql b/db/schema.sql index f2197dc52..739090480 100644 --- a/db/schema.sql +++ b/db/schema.sql @@ -54,6 +54,8 @@ create table body ( suppress_alerts boolean not null default 'f', can_be_devolved boolean not null default 'f', send_extended_statuses boolean not null default 'f', + fetch_problems boolean not null default 'f', + blank_updates_permitted boolean not null default 'f', deleted boolean not null default 'f' ); diff --git a/db/schema_0057-fetch-problems.sql b/db/schema_0057-fetch-problems.sql new file mode 100644 index 000000000..7419eb032 --- /dev/null +++ b/db/schema_0057-fetch-problems.sql @@ -0,0 +1,5 @@ +BEGIN; + +ALTER TABLE body ADD fetch_problems boolean default 'f' not null; + +COMMIT; diff --git a/db/schema_0058-blank-updates-permitted.sql b/db/schema_0058-blank-updates-permitted.sql new file mode 100644 index 000000000..8b6710bc0 --- /dev/null +++ b/db/schema_0058-blank-updates-permitted.sql @@ -0,0 +1,5 @@ +BEGIN; + +ALTER TABLE body ADD blank_updates_permitted boolean default 'f' not null; + +COMMIT; |