Skip to content

GitLab

  • Projects
  • Groups
  • Snippets
  • Help
    • Loading...
  • Help
    • Help
    • Support
    • Community forum
    • Submit feedback
  • Sign in / Register
M
medialibrary
  • Project overview
    • Project overview
    • Details
    • Activity
    • Releases
  • Repository
    • Repository
    • Files
    • Commits
    • Branches
    • Tags
    • Contributors
    • Graph
    • Compare
  • Issues 63
    • Issues 63
    • List
    • Boards
    • Labels
    • Service Desk
    • Milestones
  • Merge Requests 7
    • Merge Requests 7
  • CI / CD
    • CI / CD
    • Pipelines
    • Jobs
    • Schedules
  • Operations
    • Operations
    • Incidents
    • Environments
  • Analytics
    • Analytics
    • CI / CD
    • Repository
    • Value Stream
  • Wiki
    • Wiki
  • Members
    • Members
  • Activity
  • Graph
  • Create a new issue
  • Jobs
  • Commits
  • Issue Boards
Collapse sidebar
  • VideoLAN
  • medialibrary
  • Wiki
    • Database
  • Model v26

Model v26 · Changes

Page history
Update Model v26 authored May 12, 2020 by Hugo Beauzée-Luyssen's avatar Hugo Beauzée-Luyssen
Hide whitespace changes
Inline Side-by-side
Showing with 11 additions and 4 deletions
+11 -4
  • database/Model-v26.md database/Model-v26.md +11 -4
  • No files found.
database/Model-v26.md
View page @ 919bd1d1
...@@ -4,12 +4,19 @@ v26 ...@@ -4,12 +4,19 @@ v26
### List of changes ### List of changes
### Show Table ### Show Table
* Flush & re-insert all entries to work around the FTS table diverging from the actual table (#242) * Flush & re-insert all entries to work around the FTS table diverging from the actual table (#242) (ce423a6ad5e199e7d0a6543eb9b5db1ffa70814b)
#### MediaGroup table #### MediaGroup table
* Drop `media_group_increment_nb_media` trigger * Drop `media_group_increment_nb_media` trigger (#247 - e12a0c6eb30aff1decf8b6952b82e4c08835ac62)
* Drop `media_group_decrement_nb_media` trigger * Drop `media_group_decrement_nb_media` trigger (#247 - e12a0c6eb30aff1decf8b6952b82e4c08835ac62)
* Add `media_group_update_nb_media` trigger * Add `media_group_update_nb_media_types` trigger (#247 & #251 - e12a0c6eb30aff1decf8b6952b82e4c08835ac62 & f462cc04291495b5463bd0df652f6b260b9ef675 - bf9dd2dbf6ad1dfcefcb4252e13ca3a0bf24f4cf)
* Add a `nb_media` column (#251 - a9a9c3cb77017aa4bf288c18012c4c4fdb43a4cb)
* Update `media_group_update_total_nb_media` trigger to update `nb_media` (#251 - 8f081f2245314f0b8887f27283c7586c967857a7)
* Update `media_group_delete_empty_group` trigger to use `nb_media` field (#251 - 9a323042c228bf25604d821bf5ced6af0eabc03f)
* Add `media_group_update_nb_media_types_presence` trigger to update media count based on their presence (#251 - 26cbf3ddadb9326b383b773c98df35671dcdd9bb)
### Task table
* Ensure all restore tasks have their `file_type` specified (#244 - b18490b1381419976ea581112c979cb46eb4dcfe)
### Rescan required: ### Rescan required:
* No * No
......
Clone repository
  • Album selection
  • CI configurations
  • database
    • Model v14
    • Model v15
    • Model v16
    • Model v17
    • Model v18
    • Model v19
    • Model v20
    • Model v21
    • Model v22
    • Model v23
    • Model v24
    • Model v25
    • Model v26
View All Pages