18 lines
474 B
SQL
18 lines
474 B
SQL
-- Your SQL goes here
|
|
CREATE TABLE "trackers"
|
|
(
|
|
"id" UUID PRIMARY KEY NOT NULL UNIQUE,
|
|
"name" TEXT,
|
|
"created_at" TIMESTAMP NOT NULL
|
|
);
|
|
|
|
CREATE TABLE "hits"
|
|
(
|
|
"id" UUID PRIMARY KEY NOT NULL UNIQUE,
|
|
"tracker_id" UUID REFERENCES trackers (id) NOT NULL,
|
|
"ip" TEXT NOT NULL,
|
|
"agent" TEXT,
|
|
"language" TEXT,
|
|
"created_at" TIMESTAMP NOT NULL
|
|
);
|