phantomknight287/aero

public

Code Issues0 Pull requests1

aeroapiprismamigrations20251026064917_add_flight_positions_arraymigration.sql

I AM LOVING THIS APP!!!!7244518a year ago57 lines · 2.0 KB

1	-- CreateEnum
2	CREATE TYPE "AltitudeChange" AS ENUM ('
3
4	-- CreateEnum
5	CREATE TYPE "UpdateType" AS ENUM (
6
7	-- AlterTable
8	ALTER TABLE "flight" ADD COLUMN
9	ADD COLUMN "flightaware_payload" JSONB;
10
11	-- AlterTable
12	ALTER TABLE "flights" ADD COLUMN
13
14	-- CreateTable
15	CREATE TABLE "flight_positions" (
16	"id" TEXT NOT NULL
17	"altitude" INTEGER NOT NULL
18	"altitude_change" "AltitudeChange" NOT NULL
19	"ground_speed" INTEGER NOT NULL
20	"heading" INTEGER,
21	"latitude" DECIMAL(65
22	"longitude" DECIMAL(65
23	"timestamp" TIMESTAMP(3
24	"update_type" "UpdateType" NOT NULL
25	"created_at" TIMESTAMP(3
26	"updated_at" TIMESTAMP(3
27	"flight_id" TEXT,
28
29	CONSTRAINT "flight_positions_pkey" PRIMARY KEY
30	);
31
32	-- CreateIndex
33	CREATE UNIQUE INDEX "flight_positions_id_key" ON
34
35	-- CreateIndex
36	CREATE INDEX "flight_positions_timestamp_idx" ON
37
38	-- CreateIndex
39	CREATE INDEX "flight_positions_latitude_longitude_idx" ON
40
41	-- CreateIndex
42	CREATE INDEX "flight_positions_altitude_idx" ON
43
44	-- CreateIndex
45	CREATE INDEX "flight_positions_altitude_change_idx" ON
46
47	-- CreateIndex
48	CREATE INDEX "flight_positions_ground_speed_idx" ON
49
50	-- CreateIndex
51	CREATE INDEX "flight_positions_heading_idx" ON
52
53	-- CreateIndex
54	CREATE INDEX "flight_positions_update_type_idx" ON
55
56	-- AddForeignKey
57	ALTER TABLE "flight_positions" ADD

Climb

'

,

'

Descend

'

,

'

None

'

);

'

Projected

'

,

'

Oceanic

'

,

'

Radar

'

,

'

ADSB

'

,

'

Multilateration

'

,

'

Datalink

'

,

'

Surface_And_Near_Surface

'

,

'

Spaced_Based

'

,

'

Virtual_Event

'

);

"

fa_flight_id

"

TEXT

,

"

fa_flight_id

"

TEXT

;

,

,

DEFAULT

'

None

'

,

,

,

30

)

NOT NULL

,

,

30

)

NOT NULL

,

)

NOT NULL

,

,

)

NOT NULL

DEFAULT

CURRENT_TIMESTAMP,

)

NOT NULL

,

(

"

id

"

)

"

flight_positions

"

(

"

id

"

);

"

flight_positions

"

(

"

timestamp

"

);

"

flight_positions

"

(

"

latitude

"

,

"

longitude

"

);

"

flight_positions

"

(

"

altitude

"

);

"

flight_positions

"

(

"

altitude_change

"

);

"

flight_positions

"

(

"

ground_speed

"

);

"

flight_positions

"

(

"

heading

"

);

"

flight_positions

"

(

"

update_type

"

);

CONSTRAINT

"

flight_positions_flight_id_fkey

"

FOREIGN KEY

(

"

flight_id

"

)

REFERENCES

"

flights

"

(

"

id

"

)

ON DELETE

SET

NULL

ON UPDATE CASCADE

;