aboutsummaryrefslogtreecommitdiff
path: root/src/migrations/2.sql
diff options
context:
space:
mode:
authorJoris2017-11-08 23:47:26 +0100
committerJoris2017-11-08 23:47:26 +0100
commit27e11b20b06f2f2dbfb56c0998a63169b4b8abc4 (patch)
tree845f54d7fe876c9a3078036975ba85ec21d224a1 /src/migrations/2.sql
parenta3601b5e6f5a3e41fa31752a2c704ccd3632790e (diff)
downloadbudget-27e11b20b06f2f2dbfb56c0998a63169b4b8abc4.tar.gz
budget-27e11b20b06f2f2dbfb56c0998a63169b4b8abc4.tar.bz2
budget-27e11b20b06f2f2dbfb56c0998a63169b4b8abc4.zip
Use a better project structure
Diffstat (limited to 'src/migrations/2.sql')
-rw-r--r--src/migrations/2.sql23
1 files changed, 0 insertions, 23 deletions
diff --git a/src/migrations/2.sql b/src/migrations/2.sql
deleted file mode 100644
index ec0d1b0..0000000
--- a/src/migrations/2.sql
+++ /dev/null
@@ -1,23 +0,0 @@
-BEGIN TRANSACTION;
-
-ALTER TABLE payment RENAME TO tmp_payment;
-
-CREATE TABLE IF NOT EXISTS "payment"(
- "id" INTEGER PRIMARY KEY,
- "user" INTEGER NOT NULL REFERENCES "user",
- "name" VARCHAR NOT NULL,
- "cost" INTEGER NOT NULL,
- "date" DATE NOT NULL,
- "frequency" VARCHAR NOT NULL,
- "created_at" TIMESTAMP NOT NULL,
- "edited_at" TIMESTAMP NULL,
- "deleted_at" TIMESTAMP NULL
-);
-
-INSERT INTO payment(id, user, name, cost, date, frequency, created_at, edited_at, deleted_at)
-SELECT id, user_id, name, cost, date, frequency, created_at, edited_at, deleted_at
-FROM tmp_payment;
-
-DROP TABLE tmp_payment;
-
-COMMIT;