Commit Graph

85 Commits

Author SHA1 Message Date
Francis Cao 0aaf2c0b3b update visitId hash and expiration logic 2024-03-25 17:47:53 -07:00
Francis Cao b36d61609d fix migration bug 2024-03-21 09:36:27 -07:00
Francis Cao cbeefe733f add psql migration 2024-03-21 09:30:42 -07:00
Francis Cao bc73410dba remove default deleted_at 2024-02-07 14:01:25 -08:00
Francis Cao e915074c4b populate created_by in migration script 2024-02-05 12:09:57 -08:00
Francis Cao e5e8d0acc8 finalize teams schema 2024-02-05 11:47:12 -08:00
Brian Cao 421d232cce Fix logoUrl 2024-01-26 09:13:01 -08:00
Brian Cao 53c7d86be5 add logo url 2024-01-25 11:15:11 -08:00
Francis Cao 82465f9362 remove direct_url 2024-01-16 12:35:24 -08:00
Francis Cao a6a73db9c4 update schema file and add migrations 2024-01-16 12:32:27 -08:00
Spencer Tweedy 7a77c82ca1
Update schema.prisma
fix pgbouncer to supavisor migration issue
2024-01-15 12:49:12 -06:00
Francis Cao 6dba68c823 add metric performance indexes 2023-08-16 14:33:55 -07:00
Francis Cao 9726d02dcd remove ms from string date value, add mysql migration 2023-07-11 08:55:58 -07:00
Francis Cao 8abeba4c0d squash psql migration. add event_data migration 2023-07-10 23:08:57 -07:00
Brian Cao 0a3ee2277a Fix numeric to number. 2023-07-06 21:02:56 -07:00
Brian Cao b484286523
Feat/um 305 unique session ch (#2065)
* Add session_data / session redis to CH.

* Add mysql migration.
2023-05-31 21:46:49 -07:00
Mike Cao bc37f5124e Update report migration. 2023-05-27 22:36:41 -07:00
Mike Cao 0724201f69 Added indexes. Removed old migration. 2023-05-27 13:29:09 -07:00
Brian Cao 07cb9f621d Funnel Table/Chart hooked up. 2023-05-14 21:38:03 -07:00
Brian Cao 1130bca195 Funnel form. 2023-05-11 16:42:58 -07:00
Brian Cao d01aa5cd52 Add funnel queries 2023-05-08 23:46:58 -07:00
Francis Cao fa3659fcf6 fix user password edit and fix prisma schema for updated_at columns 2023-04-20 10:46:58 -07:00
Francis Cao 672608b2f5 re-add pgcrypto extension 2023-04-16 21:13:51 -07:00
Francis Cao b1074c893a 01_init schema changes 2023-04-16 21:07:36 -07:00
Francis Cao 96d25721da add pgcrypto back 2023-03-29 14:22:14 -07:00
Francis Cao f984d80c42 squash 01_init postgresql 2023-03-29 11:38:08 -07:00
Francis Cao cb79d806e8 update postgres / mysql migrations 2023-03-27 11:36:21 -07:00
Francis Cao 14e4a090bb update schema and queries to implement reset_at 2023-03-27 11:25:16 -07:00
Brian Cao 9979672de5
Feat/um 202 event data new (#1841)
* Add event_data base.

* Add url_path.

* Add eventData back.

* Finish event_data relational.

* resolve comments.
2023-03-23 14:01:15 -07:00
Francis Cao ea39f5b431 add new event data schema 2023-03-22 23:02:37 -07:00
Francis Cao cfa36d1802 clean-up migrations 2023-03-14 17:43:36 -07:00
Francis Cao 9321401297 schema changes to CH, Postgres, MySQL 2023-03-14 17:27:17 -07:00
Brian Cao 8a9532f213
Feat/um 197 hook up teams (#1825)
* Link up teams UI.

* Fix auth order.

* PR touchups.
2023-03-09 12:42:12 -08:00
Francis Cao bb2cd93ad4 undo 01_init change 2023-03-06 11:25:05 -08:00
Brian Cao b41a2a4e56 Rename migration. 2023-03-03 13:15:12 -08:00
Brian Cao 82f0bc3d2b
remove event_data. (#1804) 2023-03-01 16:42:47 -08:00
Francis Cao 6c302a7325 collect pagetitle, update subdivision2 data type 2023-02-28 17:40:18 -08:00
Francis Cao 074fa2c5fc add subdivision2 to schema 2023-02-16 09:52:07 -08:00
Francis Cao b6cc6cb655 update CH, postgres, MySQL schemas 2023-02-15 09:40:49 -08:00
Francis Cao 5fd946cfde add schema changes for TeamWebsite, update deleted logic for team tables 2023-02-01 17:08:16 -08:00
Francis Cao 7c0db0633f update check-db, add pgcrypto extension if not exists on init migration 2023-01-20 14:21:11 -08:00
Francis Cao 8ee7172ea0 drop foreign keys, add missing indexes 2022-12-27 16:26:25 -08:00
Mike Cao aef7326f4c Added access_code column to teams. 2022-12-27 00:00:31 -08:00
Brian Cao 4501951336 Fix admin create. 2022-12-12 12:31:56 -08:00
Brian Cao 8097428a4b Add 01 migration. 2022-12-12 12:04:31 -08:00
Mike Cao 4eb3140e43 Updated schema. 2022-12-05 13:03:02 -08:00
Brian Cao b40630f9d4 Merge remote-tracking branch 'origin/dev' into dev 2022-12-01 22:06:39 -08:00
Brian Cao 4ef48a8f4b Add 02 migration. 2022-12-01 22:06:36 -08:00
Brian Cao 06bebadbb9
Feat/um 114 roles and permissions (#1683)
* Auth checkpoint.

* Merge branch 'dev' into feat/um-114-roles-and-permissions
2022-12-01 20:53:37 -08:00
Brian Cao 77b739870e Add database migration. 2022-11-29 21:56:43 -08:00