diff options
Diffstat (limited to 'database-versioning/sandbox-0001.sql')
| -rw-r--r-- | database-versioning/sandbox-0001.sql | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/database-versioning/sandbox-0001.sql b/database-versioning/sandbox-0001.sql index b6ed53ef..7fa9bbd7 100644 --- a/database-versioning/sandbox-0001.sql +++ b/database-versioning/sandbox-0001.sql @@ -25,6 +25,9 @@ CREATE TABLE IF NOT EXISTS bankaccounts ALTER TABLE bankaccounts ADD CONSTRAINT accountLabelIndex UNIQUE ("label"); +ALTER TABLE + bankaccounts ADD COLUMN balance TEXT DEFAULT ('0'); + CREATE TABLE IF NOT EXISTS bankaccounttransactions (id BIGSERIAL PRIMARY KEY ,"creditorIban" TEXT NOT NULL |