Skip to content

Instantly share code, notes, and snippets.

@slawo-ch

slawo-ch/re-create-still.sql

Created November 2, 2019 21:23
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save slawo-ch/6a247af8fae5a102c9cf14fb98024f3c to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save slawo-ch/6a247af8fae5a102c9cf14fb98024f3c to your computer and use it in GitHub Desktop.
Download ZIP
Raw
re-create-still.sql
DROP TABLE IF EXISTS still
CREATE TABLE still (
still_id BIGINT GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY,
sample_index BIGINT,
orientation varchar(20),
model varchar(200),
device varchar(200),
arrival_time NUMERIC(32,12),
sensor_time NUMERIC(32,12),
creation_time NUMERIC(32,12),
x NUMERIC(32,20),
y NUMERIC(32,20),
z NUMERIC(32,20)
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment