Rooba
/
stash
mirror of https://github.com/stashapp/stash.git
1
1
Fork 0
Code Issues Packages Projects Releases Wiki Activity
stash/pkg/sqlite/migrations
History
MinasukiHikimuna 0d40056f8c
Markers can have end time (#5311) 
* Markers can have end time

Other metadata sources such as ThePornDB and timestamp.trade support end times for markers but Stash did not yet support saving those. This is a first step which only allows end time to be set either via API or via UI. Other aspects of Stash such as video player timeline are not yet updated to take end time into account.

- User can set end time when creating or editing markers in the UI or in the API.
- End time cannot be before start time. This is validated in the backend and for better UX also in the frontend.
- End time is shown in scene details view or markers wall view if present.
- GraphQL API does not require end_seconds.
---------
Co-authored-by: WithoutPants <53250216+WithoutPants@users.noreply.github.com>
 		2024-11-02 11:55:48 +11:00
..
1_initial.down.sql Restructure data layer (#2532) 2022-09-06 07:03:40 +00:00
1_initial.up.sql Restructure data layer (#2532) 2022-09-06 07:03:40 +00:00
2_cover_image.up.sql Restructure data layer (#2532) 2022-09-06 07:03:40 +00:00
3_o_counter.up.sql Restructure data layer (#2532) 2022-09-06 07:03:40 +00:00
4_movie.up.sql Restructure data layer (#2532) 2022-09-06 07:03:40 +00:00
5_performer_gender.down.sql Restructure data layer (#2532) 2022-09-06 07:03:40 +00:00
5_performer_gender.up.sql Restructure data layer (#2532) 2022-09-06 07:03:40 +00:00
6_scenes_format.up.sql Restructure data layer (#2532) 2022-09-06 07:03:40 +00:00
7_performer_optimization.up.sql Restructure data layer (#2532) 2022-09-06 07:03:40 +00:00
8_movie_fix.up.sql Restructure data layer (#2532) 2022-09-06 07:03:40 +00:00
9_studios_parent_studio.up.sql Restructure data layer (#2532) 2022-09-06 07:03:40 +00:00
10_image_tables.up.sql Restructure data layer (#2532) 2022-09-06 07:03:40 +00:00
11_tag_image.up.sql Restructure data layer (#2532) 2022-09-06 07:03:40 +00:00
12_oshash.up.sql Restructure data layer (#2532) 2022-09-06 07:03:40 +00:00
12_postmigrate.go Only set video algorithm after migration 12 (#2946) 2022-09-26 11:27:53 +10:00
13_images.up.sql Restructure data layer (#2532) 2022-09-06 07:03:40 +00:00
14_stash_box_ids.up.sql Restructure data layer (#2532) 2022-09-06 07:03:40 +00:00
15_file_mod_time.up.sql Restructure data layer (#2532) 2022-09-06 07:03:40 +00:00
16_organized_flag.up.sql Restructure data layer (#2532) 2022-09-06 07:03:40 +00:00
17_reset_scene_size.up.sql Restructure data layer (#2532) 2022-09-06 07:03:40 +00:00
18_scene_galleries.up.sql Restructure data layer (#2532) 2022-09-06 07:03:40 +00:00
19_performer_tags.up.sql Restructure data layer (#2532) 2022-09-06 07:03:40 +00:00
20_phash.up.sql Restructure data layer (#2532) 2022-09-06 07:03:40 +00:00
21_performers_studios_details.up.sql Restructure data layer (#2532) 2022-09-06 07:03:40 +00:00
22_performers_studios_rating.up.sql Restructure data layer (#2532) 2022-09-06 07:03:40 +00:00
23_scenes_interactive.up.sql Restructure data layer (#2532) 2022-09-06 07:03:40 +00:00
24_tag_aliases.up.sql Restructure data layer (#2532) 2022-09-06 07:03:40 +00:00
25_saved_filters.up.sql Restructure data layer (#2532) 2022-09-06 07:03:40 +00:00
26_tag_hierarchy.up.sql Restructure data layer (#2532) 2022-09-06 07:03:40 +00:00
27_studio_aliases.up.sql Restructure data layer (#2532) 2022-09-06 07:03:40 +00:00
28_images_indexes.up.sql Restructure data layer (#2532) 2022-09-06 07:03:40 +00:00
29_interactive_speed.up.sql Restructure data layer (#2532) 2022-09-06 07:03:40 +00:00
30_ignore_autotag.up..sql Restructure data layer (#2532) 2022-09-06 07:03:40 +00:00
31_scenes_captions.up.sql Restructure data layer (#2532) 2022-09-06 07:03:40 +00:00
32_files.up.sql Handle null video durations in migration (#3021) 2022-10-20 10:58:42 +11:00
32_postmigrate.go Fix migrations not using tx (#5282) 2024-09-22 14:03:54 +10:00
32_premigrate.go Fix migrations not using tx (#5282) 2024-09-22 14:03:54 +10:00
33_noop.up.sql More timestamp corrections (#2933) 2022-09-20 13:52:37 +10:00
34_indexes.up.sql More timestamp corrections (#2933) 2022-09-20 13:52:37 +10:00
34_postmigrate.go Fix migrations not using tx (#5282) 2024-09-22 14:03:54 +10:00
35_assoc_tables.up.sql Ignore NULL values during migration 2022-10-20 01:01:18 +00:00
36_tags_description.up.sql Add descriptions to tags and display tag cards on hover (#2708) 2022-10-06 10:01:06 +11:00
37_iso_country_names.up.sql Change performer country value to be ISO code (#1922) 2022-10-28 16:37:57 +11:00
38_scenes_director_code.up.sql [Feature] Add fields `director` and (studio) `code` to scenes (#3051) 2022-11-07 18:16:52 +11:00
39_performer_height.up.sql Change performer height to be numeric (#3060) 2022-11-08 14:09:03 +11:00
40_newratings.up.sql Stash rating system (#2830) 2022-11-16 09:31:44 +11:00
41_scene_activity.up.sql Track watch activity for scenes. (#3055) 2022-11-21 12:55:15 +11:00
42_performer_disambig_aliases.up.sql Fix performer migration (#3285) 2022-12-19 11:24:42 +11:00
42_postmigrate.go Fix migrations not using tx (#5282) 2024-09-22 14:03:54 +10:00
43_image_date_url.up.sql [Feature] Images new fields : URL & Date (#3015) 2022-12-20 11:13:41 +11:00
44_gallery_chapters.up.sql Add Chapters for Galleries (#3289) 2023-03-16 15:04:54 +11:00
45_blobs.up.sql Add filesystem based blob storage (#3187) 2023-03-17 10:52:49 +11:00
45_postmigrate.go Fix migrations not using tx (#5282) 2024-09-22 14:03:54 +10:00
46_penis_stats.up.sql Add penis length and circumcision stats to performers. (#3627) 2023-05-24 13:19:35 +10:00
47_scene_urls.up.sql Multiple scene URLs (#3852) 2023-07-12 11:51:52 +10:00
48_cleanup.up.sql SQLite model refactoring, part 2 (#3839) 2023-07-13 12:15:02 +10:00
48_premigrate.go Database connection pool refactor (#5274) 2024-09-20 12:56:26 +10:00
49_postmigrate.go Fix migrations not using tx (#5282) 2024-09-22 14:03:54 +10:00
49_saved_filter_refactor.up.sql Saved filter refactor (#4054) 2023-09-01 10:04:56 +10:00
50_image_urls.up.sql Multiple image URLs (#4000) 2023-09-12 13:31:53 +10:00
51_gallery_urls.up.sql Gallery URLs (#4114) 2023-09-25 12:27:20 +10:00
52_postmigrate.go Fix migrations not using tx (#5282) 2024-09-22 14:03:54 +10:00
52_zip_folder_data_correct.up.sql Fix data corruption when moving folders (#4169) 2023-10-03 17:05:08 +11:00
53_gallery_photographer_code.up.sql Add Studio Code and Photographer to Galleries. (#4195) 2023-11-28 15:05:33 +11:00
54_image_code_details_photographer.up.sql Add Details, Studio Code, and Photographer to Images (#4217) 2023-11-28 15:45:07 +11:00
55_manual_history.up.sql Scene play and o-counter history view and editing (#4532) 2024-02-22 11:28:18 +11:00
55_postmigrate.go Fix migrations not using tx (#5282) 2024-09-22 14:03:54 +10:00
56_studio_favorite.up.sql Add support for favorite Studios (#4675) 2024-03-14 11:17:44 +11:00
57_tag_favorite.up.sql Tag Favoriting (#4728) 2024-05-09 12:04:58 +10:00
58_config_correct.up.sql Replace viper with koanf (#4845) 2024-05-21 11:24:47 +10:00
58_postmigrate.go Rename movies to groups in menu items in 65 post-migration (#5247) 2024-09-11 13:39:46 +10:00
59_movie_urls.up.sql Movie URLs (#4900) 2024-06-11 13:08:49 +10:00
60_default_filter_move.up.sql Default view filters (#4962) 2024-06-18 10:51:52 +10:00
60_postmigrate.go Database connection pool refactor (#5274) 2024-09-20 12:56:26 +10:00
61_movie_tags.up.sql Movie/Group tags (#4969) 2024-06-18 11:24:15 +10:00
62_performer_urls.up.sql adding exists check before dropping constraints (#5363) 2024-10-15 13:10:47 +11:00
63_studio_tags.up.sql Add tags to studios (#4858) 2024-06-18 15:55:20 +10:00
64_fixes.up.sql Add schema migration to fix view_date format (#4992) 2024-06-24 13:15:54 +10:00
64_postmigrate.go Fix migrations not using tx (#5282) 2024-09-22 14:03:54 +10:00
65_movie_group_rename.up.sql Rename movie tables to groups in database schema (#5082) 2024-07-30 14:14:16 +10:00
65_postmigrate.go Rename movies to groups in menu items in 65 post-migration (#5247) 2024-09-11 13:39:46 +10:00
66_gallery_cover.up.sql Support for assigning any image from a gallery as the cover (#5053) 2024-08-29 11:24:52 +10:00
67_group_relationships.up.sql Containing Group/Sub-Group relationships (#5105) 2024-08-30 11:43:44 +10:00
68_image_studio_index.up.sql Exclude null values from image studio id index (#5335) 2024-10-03 11:53:29 +10:00
69_stash_id_updated_at.up.sql Add updated_at field to stash_id's (#5259) 2024-10-31 15:56:16 +11:00
70_markers_end.up.sql Markers can have end time (#5311) 2024-11-02 11:55:48 +11:00
custom_migration.go Performer disambiguation and aliases (#3113) 2022-12-01 13:54:08 +11:00