millions/db/schema.sql

-- Adminer 4.7.5 SQLite 3 dump

CREATE TABLE "sites" (
  "id" integer NOT NULL PRIMARY KEY AUTOINCREMENT,
  "host" text COLLATE 'NOCASE' NOT NULL,
  "label" text NULL,
  "stats_public" numeric NOT NULL DEFAULT '0',
  "stats_key" text NULL
);

CREATE UNIQUE INDEX "sites_host" ON "sites" ("host");


CREATE TABLE "visits" (
  "site_id" integer NOT NULL,
  "path" text NOT NULL,
  "ts" numeric NOT NULL,
  "is_unique" numeric NOT NULL DEFAULT '0',
  "is_bot" numeric NOT NULL DEFAULT '0',
  "platform" text NOT NULL DEFAULT '',
  "browser" text NOT NULL DEFAULT '',
  "version" text NOT NULL DEFAULT '',
  "ref" text NOT NULL DEFAULT '',
  "width" integer NOT NULL DEFAULT ''
);

CREATE INDEX "visits_site_id_path" ON "visits" ("site_id", "path");

CREATE TABLE "uas" (
    "ua" text NOT NULL
);

CREATE UNIQUE INDEX "uas_ua" ON "uas" ("ua");

--