205 commits

Author	SHA1	Message	Date
Francis Cao	da7f4cb2d0	create and apply mysql migrations	2025-07-18 10:26:24 -07:00
Francis Cao	2dcb9e21bd	change pagestable to visitors and update clickhouse hostname column to array	2025-07-13 22:44:09 -07:00
Mike Cao	b2a6e3f842	Merge pull request #3505 from eoussama/master ... Added optional website ID for creation	2025-07-07 22:58:16 -07:00
Francis Cao	5ffafc71fc	finish segments, update migration from filters to parameters	2025-06-20 10:27:57 -07:00
Matt Harrington	19ccfa0745	fixing the clickhouse schema file	2025-06-13 12:17:18 -07:00
Francis Cao	f61421b742	segments implementation and migration update. update getRequestFilters to include filter groups.	2025-06-13 07:34:54 -07:00
Francis Cao	49b4948d0f	add revenue table and save	2025-06-09 11:59:39 -07:00
Francis Cao	9a437dcfa2	convert attribution report	2025-06-07 07:43:36 -07:00
Francis Cao	a16846f4ce	add website_revenue table and view. update revenue report to use view	2025-06-06 08:47:52 -07:00
Francis Cao	57acaf9855	remove data conversion	2025-06-04 16:06:11 -07:00
Francis Cao	a9c7938887	add data conversion to report param migration	2025-06-04 09:53:31 -07:00
Francis Cao	76519e0d14	add segment and report param migrations	2025-06-04 09:27:28 -07:00
Mike Cao	e89cf9e930	Removed generated prisma.	2025-04-30 21:28:02 -07:00
Francis Cao	de54290af6	add distinct id to saves and fix schema mapping	2025-04-29 09:31:46 -07:00
Francis Cao	c5efc27c07	distinct_id schema changes and search on sessions page	2025-04-29 08:57:58 -07:00
Mike Cao	5aaff55a70	Use custom path for generated Prisma client.	2025-04-28 16:51:24 -07:00
Francis Cao	12b8ac4272	app and db schema - region rename, hostname move	2025-04-24 22:42:33 -07:00
Francis Cao	e7fc482a30	add mysql/psql migrations for utm/click IDs	2025-04-14 13:12:06 -07:00
Francis Cao	e51ec70093	fix ch migration script	2025-04-13 18:46:53 -07:00
Francis Cao	b9a2145766	ch attribution report, schema changes, and migration	2025-04-13 18:12:03 -07:00
Francis Cao	203e782530	Create attribution report template and parameters	2025-03-18 10:00:23 -07:00
Mike Cao	07330bd930	Upgrade Prisma to v6.1.0. ... (cherry picked from commit c0fd22cbf6)	2025-01-18 17:01:14 -08:00
Mike Cao	662039090e	Downgrade to Prisma 5.22.0	2025-01-16 12:44:25 -08:00
Mike Cao	c0fd22cbf6	Upgrade Prisma to v6.1.0.	2025-01-10 18:58:53 -08:00
Mike Cao	c414c605b4	Revert Prisma changes due to v6 issue.	2025-01-10 16:59:11 -08:00
Mike Cao	6e158be4ac	Removed Prisma fixes from v5.	2025-01-09 21:31:10 -08:00
Mike Cao	e80b4ffcae	Fixed MySQL.	2024-12-14 16:06:26 -08:00
Mike Cao	d43293da72	Fixed Prisma docker error.	2024-12-12 22:07:20 -08:00
Mike Cao	f84d89614a	Merge pull request #3035 from tudormarze/fix/mysql-myisam ... Set engine to InnoDB for MySQL	2024-11-07 22:04:47 -08:00
Tudor Marze	1d4f1a84bb	Set engine to InnoDB for MySQL	2024-11-01 17:02:37 +02:00
Francis Cao	a708e6c350	add tags to ch schema file	2024-10-17 09:53:07 -07:00
Francis Cao	8759ba9916	add tags table and filters logic	2024-10-15 16:46:57 -07:00
Francis Cao	bffb98cd51	add tag migrations and update send / saveEvent	2024-10-15 11:29:27 -07:00
Francis Cao	c79720ae1d	update session data schema	2024-08-15 09:28:39 -07:00
Francis Cao	3207b0ce06	revert AggregatingMergeTree order by	2024-08-01 16:40:48 -07:00
Francis Cao	57a23bab2d	fix hourly order by	2024-08-01 16:16:18 -07:00
Francis Cao	61dfa1391e	add projection code	2024-08-01 15:34:35 -07:00
Francis Cao	cb4368e12c	template multiple queries for filtering	2024-07-31 09:35:29 -07:00
Francis Cao	161da582ba	reorder CH stats index	2024-07-24 16:57:23 -07:00
Francis Cao	174b9e4376	only use hourly table, remove daily table logic, fix updatechart undefined	2024-07-23 22:35:11 -07:00
Francis Cao	038ecdb592	fix pkey for stats tables	2024-07-23 15:34:25 -07:00
Francis Cao	5299e9f579	resolve entry / exit queries	2024-07-22 21:30:06 -07:00
Francis Cao	31b059d7db	fix 06_session_data migration bug	2024-04-08 20:29:16 -07:00
Francis Cao	7381254cc2	add relational migrations. update event_key references to data_key	2024-04-08 20:24:15 -07:00
Francis Cao	cc834083d9	update CH schema/migration to include session_data	2024-04-08 16:36:31 -07:00
Francis Cao	ab58c76b6a	change views back to pageviews	2024-03-27 11:17:00 -07:00
Francis Cao	c033b0582d	create join table and remove subquery from insert	2024-03-25 19:13:54 -07:00
Francis Cao	d36bf4396a	remove order by in insert select	2024-03-25 18:47:02 -07:00
Francis Cao	7c7fd577c3	remove test schema from CH migration script	2024-03-25 18:33:30 -07:00
Francis Cao	0aaf2c0b3b	update visitId hash and expiration logic	2024-03-25 17:47:53 -07:00