11 lines
296 B
SQL
11 lines
296 B
SQL
-- Add up migration script here
|
|
CREATE TABLE spots
|
|
(
|
|
id bigserial NOT NULL,
|
|
created_at timestamp without time zone NOT NULL,
|
|
ticker character(3) NOT NULL,
|
|
spot real NOT NULL,
|
|
PRIMARY KEY (id)
|
|
);
|
|
|
|
CREATE INDEX index_spots_ticker_created_at ON spots ( ticker, created_at DESC ); |