server/migrations/0002_launches.sql

 1-- Upcoming launches, normalized from Launch Library 2.
 2CREATE TABLE launches (
 3  id TEXT PRIMARY KEY,
 4  name TEXT NOT NULL,
 5  net TEXT NOT NULL,
 6  window_start TEXT,
 7  window_end TEXT,
 8  status TEXT NOT NULL,
 9  status_name TEXT NOT NULL,
10  provider TEXT NOT NULL,
11  rocket TEXT NOT NULL,
12  mission TEXT,
13  mission_type TEXT,
14  mission_description TEXT,
15  orbit TEXT,
16  pad TEXT NOT NULL,
17  location TEXT NOT NULL,
18  pad_latitude REAL,
19  pad_longitude REAL,
20  last_updated TEXT NOT NULL
21);
22
23CREATE INDEX launches_net ON launches (net);