13 lines
297 B
MySQL
13 lines
297 B
MySQL
|
-- CreateTable
|
||
|
|
CREATE TABLE "tracking" (
|
||
|
|
"id" TEXT NOT NULL PRIMARY KEY,
|
||
|
|
"eventType" TEXT NOT NULL,
|
||
|
|
"path" TEXT NOT NULL,
|
||
|
|
"userAgent" TEXT,
|
||
|
|
"ipAddress" TEXT,
|
||
|
|
"city" TEXT,
|
||
|
|
"country" TEXT,
|
||
|
|
"region" TEXT,
|
||
|
|
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP
|
||
|
|
);
|