summaryrefslogtreecommitdiff
path: root/migrations
diff options
context:
space:
mode:
Diffstat (limited to 'migrations')
-rw-r--r--migrations/1_create_masses/up.sql8
1 files changed, 1 insertions, 7 deletions
diff --git a/migrations/1_create_masses/up.sql b/migrations/1_create_masses/up.sql
index 67c3b3d..f666e09 100644
--- a/migrations/1_create_masses/up.sql
+++ b/migrations/1_create_masses/up.sql
@@ -1,11 +1,5 @@
CREATE TABLE masses (
id SERIAL PRIMARY KEY,
name VARCHAR NOT NULL,
- pos_x FLOAT NOT NULL,
- pos_y DOUBLE PRECISION NOT NULL,
- pos_z DOUBLE PRECISION NOT NULL,
- vel_x DOUBLE PRECISION NOT NULL,
- vel_y DOUBLE PRECISION NOT NULL,
- vel_z DOUBLE PRECISION NOT NULL,
- type_data JSONB NOT NULL
+ mass VARCHAR NOT NULL
)