OrcasHub/tonyslist
1
0
Fork 0
Code Issues Pull Requests Actions Packages Releases Activity
tonyslist/db/migrations
History
Tony Grosinger 740605ce86 Add tags and display allowed tags when creating events 
Not yet able to save tags to an event or display them.
2025-05-01 21:45:15 -07:00
..
001_init.down.sql
Update down migration to match up
2022-12-29 18:04:30 +00:00
001_init.up.sql
Continue converting functions to sqlc
2022-12-31 04:18:44 +00:00
002_cron.down.sql
Record when cron jobs last executed
2023-01-21 04:19:19 +00:00
002_cron.up.sql
Update database queries with strftime alias
2023-04-20 15:22:11 +00:00
003_user_settings.down.sql
Add user_settings table
2023-01-22 05:00:44 +00:00
003_user_settings.up.sql
Fix incorrect user_settings constraint
2023-06-04 04:38:55 +00:00
004_email_only.up.sql
Remove passwords and password tokens
2023-01-29 01:01:16 +00:00
005_mailing_lists.down.sql
Create initial db schema for mailing lists
2023-02-10 03:42:40 +00:00
005_mailing_lists.up.sql
Ensure mailing list name and short_name are unique
2023-08-29 17:44:09 -07:00
006_drop_webp.up.sql
Remove unused webp filenames from database
2023-02-18 15:45:03 +00:00
007_events.down.sql
Event creation page and events database model
2023-04-26 15:50:39 +00:00
007_events.up.sql
Refactor the events table
2023-06-29 18:00:37 +00:00
008_stats.down.sql
Store metrics about post creation and actions
2023-05-02 16:18:37 +00:00
008_stats.up.sql
Store metrics about post creation and actions
2023-05-02 16:18:37 +00:00
009_preview_image.down.sql
Improvements to image resizing and storage
2023-05-05 02:05:27 +00:00
009_preview_image.up.sql
Improvements to image resizing and storage
2023-05-05 02:05:27 +00:00
010_anon_email.down.sql
Add AnonymousEmail field to posts_base
2023-05-31 04:13:32 +00:00
010_anon_email.up.sql
Add AnonymousEmail field to posts_base
2023-05-31 04:13:32 +00:00
011_event_times.up.sql
Refactor the events table
2023-06-29 18:00:37 +00:00
012_include_email.up.sql
Remove include_email column
2023-06-30 17:47:51 +00:00
013_shortname_unique.down.sql
Ensure mailing list name and short_name are unique
2023-08-29 17:44:09 -07:00
013_shortname_unique.up.sql
Ensure mailing list name and short_name are unique
2023-08-29 17:44:09 -07:00
014_message_id.down.sql
Mailing Lists: Bidirectional mailing lists via email
2023-08-29 17:44:10 -07:00
014_message_id.up.sql
Building out mailing list email receiving
2023-09-02 20:18:40 -07:00
015_ml_attachments.down.sql
Mailing list attachments schema and storage
2023-10-14 19:02:18 -07:00
015_ml_attachments.up.sql
Mailing list attachments schema and storage
2023-10-14 19:02:18 -07:00
016_ml_leave_notifications.down.sql
Add mailing list leave notifications
2024-02-11 20:29:34 -08:00
016_ml_leave_notifications.up.sql
Add mailing list leave notifications
2024-02-11 20:29:34 -08:00
017_combine_housing.up.sql
Combine housing types into single page
2024-04-10 19:02:26 -07:00
018_stripe_customer.down.sql
Add stripe_customer_id to the users database table
2024-05-05 19:52:10 -07:00
018_stripe_customer.up.sql
Add stripe_customer_id to the users database table
2024-05-05 19:52:10 -07:00
019_photo_data.down.sql
Move photos into database
2024-12-21 14:57:28 -08:00
019_photo_data.up.sql
Move photos into database
2024-12-21 14:57:28 -08:00
020_photo_data_pt2.up.sql
Cleanup unused database fields and tables
2024-12-21 15:47:09 -08:00
021_stats.down.sql
Add metrics for many user and post actions
2024-12-22 16:02:05 -08:00
021_stats.up.sql
Add metrics for many user and post actions
2024-12-22 16:02:05 -08:00
022_event_photo.down.sql
Add single photo to event posts
2024-12-31 22:04:12 -08:00
022_event_photo.up.sql
Add single photo to event posts
2024-12-31 22:04:12 -08:00
023_event_photo_table.up.sql
Move event photos into separate table
2025-01-01 12:28:13 -08:00
024_user_username.down.sql
Ask for name and username before oauth redirect
2025-04-02 21:11:42 -07:00
024_user_username.up.sql
Add missing unique constraint on usernames
2025-04-03 08:17:06 -07:00
025_event-tags.down.sql
Add tags and display allowed tags when creating events
2025-05-01 21:45:15 -07:00
025_event-tags.up.sql
Add tags and display allowed tags when creating events
2025-05-01 21:45:15 -07:00