blob: c0b689003a81ea1dcbd1944e04c8d374f8251d76 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
|
-- Your SQL goes here
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
)
|