Commit Graph

59 Commits

Author SHA1 Message Date
Francis Cao 91a4cb4487 add mysql column population 2024-03-21 11:33:35 -07:00
Francis Cao af1a118374 update mysql migrations 2024-03-21 11:10:13 -07:00
Maxime-J 5fc3d81c39 Fix MySQL migration 4. 2024-02-15 10:59:11 +00: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
Francis Cao a6a73db9c4 update schema file and add migrations 2024-01-16 12:32:27 -08:00
Floris b5a7e4e1cc
Fix migrations to support mysql 5.7 2023-11-15 18:35:40 +01:00
Francis Cao 6dba68c823 add metric performance indexes 2023-08-16 14:33:55 -07:00
Francis Cao 31a11be1ac fix event data column order to match psql 2023-07-13 10:11:08 -07:00
Francis Cao 9726d02dcd remove ms from string date value, add mysql migration 2023-07-11 08:55:58 -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
Francis Cao 1038a54fe4 add mysql 02 migration 2023-05-31 12:01:16 -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
Sergio a7daae2d20 fix typo prisma mysql schema 2023-04-18 09:07:59 +02:00
Francis Cao b1074c893a 01_init schema changes 2023-04-16 21:07:36 -07:00
Francis Cao 21e48c194e fix system user insert mysql 2023-04-10 09:56:25 -07:00
Francis Cao c38da5bfd7 readd system user insert for mysql 2023-03-27 12:15:22 -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 87545a5648 add system user insert back for MySQL 2023-03-22 23:07:01 -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 82f0bc3d2b
remove event_data. (#1804) 2023-03-01 16:42:47 -08:00
Francis Cao 93650a2f66 add pagetitle to queries 2023-03-01 10:53:57 -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 6457ddfec1 update 01_init to latest 2023-02-02 10:18:06 -08:00
Francis Cao 9078444ca5 update mysql to latest schema 2023-02-02 10:12:25 -08:00
Francis Cao 0b16d06d8c move migrate-db to own repo 2023-02-02 10:04:21 -08:00
Francis Cao 529b7a35c3 add pgcrypto to postgres via extension preview 2023-01-17 10:36:16 -08:00
Francis Cao 65fe29c385 add mysql migration_v2 file, refactor migrate-db 2023-01-13 11:54:22 -08:00
Francis Cao 19166e580e add mysql schema file 2023-01-05 14:40:34 -08:00
Francis Cao f10694d07e create new mysql schema file 2023-01-05 11:13:49 -08:00
Brian Cao ba31f48f1a
Feat/um 49 query builder api (#1573)
* add uuid to event. add indexes

* eventdata api

* add event data

* remove test data

* update list
2022-10-21 21:33:23 -07:00
Brian Cao 78338205a3
Feat/um 62 prisma property names (#1562)
* checkpoint

* fix pg schema

* fix mysql schema

* change property names
2022-10-10 13:42:18 -07:00
Brian Cao 6de634f0b4 add mysql changes 2022-10-02 20:42:32 -07:00
Brian Cao 0c33bb9e2d fix schema file. 2022-09-01 14:54:25 -07:00
Brian Cao d53b4a8895 roll back bigint. add loading 2022-08-30 00:03:22 -07:00
Brian Cao c875096aa7 remove event_old drop 2022-08-23 14:26:44 -07:00
Brian Cao 4924a616f9 cascading deletes mysql 2022-08-22 16:00:26 -07:00
Brian Cao d3f3e610a6 big int 2022-08-16 21:03:02 -07:00
Brian Cao e269ace88f add logic to mysql migration 2022-08-11 11:33:21 -07:00
Brian Cao daf3978970 address PR comments. line up PSQL / MYSQL 2022-08-01 20:50:14 -07:00
Brian Cao 7b0d6af147 refactor table drop 2022-08-01 12:22:17 -07:00
Brian Cao 8f934c7e6c checkpoint 2022-07-29 22:30:09 -07:00
Brian Cao 3e2c098c05 create mysql migration 2022-07-27 23:16:16 -07:00