Skip to content

📈 Open source, privacy-first web analytics — a cookie-less Google Analytics alternative with built-in error tracking and performance monitoring. Self-host it or use our cloud. Get started for free!

1.5 KB
Raw Blame
CREATE TABLE `projects_views` (
  `id` varchar(36) NOT NULL,
  `projectId` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `type` enum('traffic','performance') NOT NULL,
  `pg` varchar(255) NOT NULL,
  `ev` varchar(255) NOT NULL,
  `dv` varchar(255) DEFAULT NULL,
  `br` varchar(255) DEFAULT NULL,
  `os` varchar(255) DEFAULT NULL,
  `lc` varchar(255) DEFAULT NULL,
  `ref` varchar(255) DEFAULT NULL,
  `so` varchar(255) DEFAULT NULL,
  `me` varchar(255) DEFAULT NULL,
  `ca` varchar(255) DEFAULT NULL,
  `cc` varchar(2) DEFAULT NULL,
  `rg` varchar(255) DEFAULT NULL,
  `ct` varchar(255) DEFAULT NULL,
  `createdAt` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `updatedAt` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
  PRIMARY KEY (`id`),
  FOREIGN KEY (`projectId`) REFERENCES `project` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE `projects_views_custom_events` (
  `id` varchar(36) NOT NULL,
  `viewId` varchar(255) NOT NULL,
  `customEventName` varchar(255) NOT NULL,
  `metaKey` varchar(255) NOT NULL,
  `metaValue` varchar(255) NOT NULL,
  `metaValueType` enum('string','integer','float') NOT NULL DEFAULT 'string',
  `createdAt` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `updatedAt` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
  PRIMARY KEY (`id`),
FOREIGN KEY (`viewId`) REFERENCES `projects_views` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;