summaryrefslogtreecommitdiff
path: root/migrations/1_create_masses/up.sql
diff options
context:
space:
mode:
authortom barrett <spalf0@gmail.com>2019-04-01 10:54:28 -0500
committertom barrett <spalf0@gmail.com>2019-04-01 10:54:28 -0500
commit810c77ba30c65215c2d5e4b6f8a73f3b73e2b152 (patch)
tree3666053d51c598f701733231244104f536a4d24a /migrations/1_create_masses/up.sql
parent95b3508d2397b64c7c63bd3586e524998f194e36 (diff)
database backup and restore
Diffstat (limited to 'migrations/1_create_masses/up.sql')
-rw-r--r--migrations/1_create_masses/up.sql4
1 files changed, 2 insertions, 2 deletions
diff --git a/migrations/1_create_masses/up.sql b/migrations/1_create_masses/up.sql
index f666e09..1f10915 100644
--- a/migrations/1_create_masses/up.sql
+++ b/migrations/1_create_masses/up.sql
@@ -1,5 +1,5 @@
CREATE TABLE masses (
id SERIAL PRIMARY KEY,
- name VARCHAR NOT NULL,
- mass VARCHAR NOT NULL
+ name TEXT UNIQUE NOT NULL,
+ mass TEXT NOT NULL
)