yindo/stash-box
1
0
Fork 0
mirror of https://github.com/BillyOutlast/stash-box.git synced 2026-02-04 11:01:17 +01:00
Code Issues Packages Projects Releases Wiki Activity
Files
master
stash-box/pkg/database/migrations/postgres
History
InfiniteStash 8ce44a1bbc Fix case sensitivity of performer/scene url search (#913)
2025-01-24 14:03:12 +01:00
..
1_initial.down.sql
Align backend and frontend (#10)
2019-12-21 20:35:18 +11:00
1_initial.up.sql
Add User management (#13)
2020-01-23 07:22:30 +11:00
2_create_search.down.sql
Omnibus stashdb changes (#19)
2020-06-25 13:40:09 +10:00
2_create_search.up.sql
Move CI pipeline to Github actions (#70)
2021-05-17 13:50:32 +02:00
3_misc.up.sql
Omnibus stashdb changes (#19)
2020-06-25 13:40:09 +10:00
4_image_tables.up.sql
Omnibus stashdb changes (#19)
2020-06-25 13:40:09 +10:00
5_edits.up.sql
Add voting on edits (#129)
2021-10-29 21:17:05 +02:00
6_deletion_and_redirects.up.sql
Add editing support for tags (#21)
2020-08-20 15:31:03 +10:00
7_optimization_indexes.up.sql
Query optimizations (#27)
2020-08-23 11:34:34 +10:00
8_user_invite.up.sql
User registration (#31)
2020-11-12 10:48:56 +11:00
9_image_data.up.sql
Image local storage and editing (#33)
2021-01-12 18:31:52 +01:00
10_tag_categories.up.sql
Add Tag Categories (#28)
2021-01-29 22:27:59 +01:00
11_image_constraints.up.sql
UI update (#45)
2021-02-24 18:38:27 +01:00
12_fix_performer_trigger.up.sql
Fix roundup (#66)
2021-05-09 13:38:38 +02:00
13_sort_indexes.up.sql
Fix performer ordering and add index to scene_search (#68)
2021-05-11 21:54:01 +02:00
14_phash_distance_search.up.sql
Add distance matching for phashes (#81)
2021-05-21 16:04:41 +02:00
15_scene_fingerprint_submissions.up.sql
Add submissions count/time tracking to fingerprints (#72)
2021-05-21 16:22:00 +02:00
16_fix_scene_update_trigger.up.sql
Fix studio name not being updated in search table for scene updates (#96)
2021-06-10 23:11:49 +02:00
17_edit_votes.up.sql
Replace all IMMEDIATE_REJECTED with CANCELED (#227)
2021-12-30 17:27:48 +01:00
18_fingerprint_user.up.sql
Fix fingerprint user migration (#165)
2021-11-15 09:09:52 +01:00
19_scene_created_index.up.sql
Optimize landing page query performance (#169)
2021-11-17 10:18:41 +01:00
20_edit_constraints.up.sql
Alter edit_* foreign keys to cascade on delete (#174)
2021-11-23 22:20:10 +01:00
21_site_urls.up.sql
Add customizable URL targets (#140)
2021-12-18 11:22:09 +01:00
22_performer_search_indexes.up.sql
Improve performer search (#241)
2022-01-17 14:12:04 +01:00
23_favorites.up.sql
Favorite studios and performers (#242)
2022-01-18 15:15:45 +01:00
24_drafts.up.sql
Add scene/performer draft submissions (#240)
2022-01-18 23:26:31 +01:00
25_scene_codes.up.sql
Add scene code field (#295)
2022-02-06 21:40:23 +01:00
26_scene_partial_date.down.sql
Partial scene date (#314)
2022-04-14 23:12:47 +02:00
26_scene_partial_date.up.sql
Partial scene date (#314)
2022-04-14 23:12:47 +02:00
27_edit_closed_at.up.sql
Update closed_at/updated_at values in edit updating migration (#374)
2022-05-18 08:20:01 +02:00
28_studio_favorite_index.up.sql
Add index for studio favorite subquery (#371)
2022-05-12 07:59:08 +02:00
29_scene_edit_fingerprint_index.up.sql
Add proper dupe validation for scene draft submissions (#502)
2022-09-21 12:46:10 +02:00
30_edit_bot.up.sql
Add bot edit submission support (#529)
2022-11-07 22:14:12 +01:00
31_scenes_deleted_idx.up.sql
Add additional scene indexes (#695)
2024-02-16 10:27:04 +01:00
32_edit_indexes.up.sql
Optimize edit queries (#758)
2024-02-17 11:39:07 +01:00
33_invite_key_uses.up.sql
Expand invite key generation (#634)
2024-02-25 12:43:30 +01:00
34_fingerprints.up.sql
Normalize fingerprint table (#752)
2024-02-25 15:02:56 +01:00
35_websearch.up.sql
Allow web style and JAV title searching (#711)
2024-02-26 22:39:31 +01:00
36_drop_unique_invite.up.sql
Drop unique index on pending invites and fix invite key list (#765)
2024-02-28 23:01:16 +01:00
37_tokens.up.sql
Add user email changing, and refactor activation token system (#831)
2024-11-18 23:36:48 +01:00
38_scenes_studio_id_index.up.sql
Add studio_id index on scenes table (#835)
2024-11-19 11:24:37 +01:00
39_edits_updates.up.sql
Fix edit update migration to set revision of old edits (#877)
2024-12-29 23:39:57 +01:00
40_fingerprint_vote.up.sql
Add report fingerprint functionality (#705)
2024-11-24 23:34:34 +01:00
41_notifications.up.sql
Add scene production_date (#857)
2024-12-11 19:12:57 +01:00
42_date_columns.up.sql
Refactor database date formats (#810)
2024-12-07 23:15:20 +01:00
43_studio_aliases.up.sql
Add aliases for Studios (#826)
2024-12-10 10:10:26 +01:00
44_performer_death_date.up.sql
Add performer deathdate (#856)
2024-12-10 22:52:52 +01:00
45_scene_production_date.up.sql
Add scene production_date (#857)
2024-12-11 19:12:57 +01:00
46_update_default_notifications.up.sql
Finish notifications (#872)
2024-12-29 17:46:28 +01:00
47_favorite_unique.up.sql
Make favorites unique, and add timestamp (#902)
2025-01-10 20:33:31 +01:00
48_fingerprinted_scene_edit_notification.up.sql
Add FingerprintedSceneEdit notification type (#905)
2025-01-11 13:31:49 +01:00
49_entity_search_lower_idx.up.sql
Fix case sensitivity of performer/scene url search (#913)
2025-01-24 14:03:12 +01:00