summaryrefslogtreecommitdiff
path: root/migrations/1_create_masses/up.sql
diff options
context:
space:
mode:
authortom barrett <spalf0@gmail.com>2019-04-02 04:53:54 -0500
committertom barrett <spalf0@gmail.com>2019-04-02 04:53:54 -0500
commit9e1cc5ab923492570a84ac35fe573d22c051f86b (patch)
tree8a4371560b0051920aef2c74f0d91636377b147f /migrations/1_create_masses/up.sql
parent810c77ba30c65215c2d5e4b6f8a73f3b73e2b152 (diff)
added last_modified to database entry
Diffstat (limited to 'migrations/1_create_masses/up.sql')
-rw-r--r--migrations/1_create_masses/up.sql3
1 files changed, 2 insertions, 1 deletions
diff --git a/migrations/1_create_masses/up.sql b/migrations/1_create_masses/up.sql
index 1f10915..b1db62d 100644
--- a/migrations/1_create_masses/up.sql
+++ b/migrations/1_create_masses/up.sql
@@ -1,5 +1,6 @@
CREATE TABLE masses (
id SERIAL PRIMARY KEY,
name TEXT UNIQUE NOT NULL,
- mass TEXT NOT NULL
+ mass TEXT NOT NULL,
+ last_modified TIMESTAMP NOT NULL
)