Skip to content

GitLab

  • Projects
  • Groups
  • Snippets
  • Help
    • Loading...
  • Help
    • Help
    • Support
    • Community forum
    • Submit feedback
    • Contribute to GitLab
    • Switch to GitLab Next
  • Sign in / Register
wiki
wiki
  • Project overview
    • Project overview
    • Details
    • Activity
  • Issues 19
    • Issues 19
    • List
    • Boards
    • Labels
    • Service Desk
    • Milestones
    • Iterations
  • Requirements
    • Requirements
    • List
  • Operations
    • Operations
    • Incidents
  • Analytics
    • Analytics
    • Insights
    • Issue
    • Repository
    • Value Stream
  • Wiki
    • Wiki
  • Members
    • Members
  • Collapse sidebar
  • Activity
  • Create a new issue
  • Issue Boards
  • openlp
  • wikiwiki
  • Wiki
    • Scratchpad
  • Song_Database_Content

Last edited by Raoul Snyman Oct 14, 2019
Page history

Song_Database_Content

Currently available Tables

authors

  • id (Integer)
  • first_name (VarChar(128))
  • last_name (VarChar(128))
  • display_name (VarChar(255))

author_songs

  • author_id (Integer)
  • song_id (Integer)
  • author_type (VarChar(255))

media_files

  • id (Integer)
  • song_id (Integer)
  • file_path (VarChar)
  • type (VarChar(64))
  • weight (Integer)

metadata

  • key (VarChar(64))
  • value (Text)

song_books

  • id (Integer)
  • name (VarChar(128))
  • publisher (VarChar(128))

songs

  • id (Integer)
  • title (VarChar(255))
  • alternative title (VarChar(255))
  • lyrics (Text)
  • verse_order (VarChar(128))
  • copyright (VarChar(255))
  • comments (Text)
  • ccli_number (VarChar(64))
  • theme_name (VarChar(128))
  • search_title (VarChar(255))
  • search_lyrics (Text)
  • create_date (DateTime)
  • last_modified (DateTime)
  • temporary (Boolean)

songs_songbooks

  • songbook_id (Integer)
  • song_id (Integer)
  • entry (VarChar(255))

songs_topics

  • song_id (Integer)
  • topic_id (Integer)

topics

  • id (Integer)
  • name (VarChar(128))

Possible Extensions

Meta Data (identical to OpenLyrics)

  • createdIn
  • modifiedIn

As OpenLyrics requires this, it would be helpfull to have the information in the database.

Multiple Songbooks

To have the ability to add more than one song book to a song will be helpful for the song importers, since a few formats support more than one song book, which means we have to take one of the song book and drop the others.

May as list of songbook id's like in the Verse order.

This would have an impact to the GUI. May we could pass the songbook number and add same gui settings as for authors

State of a Song

This property describes the state of a song. This can be

  • 1 - in progress
  • 2 - Ready
  • 3 - faulty

This could have an Impact to the GUI. May the songs could have different colors in the media Manager List view (black - ready, yellow - in progress, orange - faulty). Also there would be the possible to change the state needed (eg. context menu, button, shortcut, radio button in the song editor or the like).

Clone repository
  • Addendum
  • Brand_Guidelines
  • Classes_Plugin
  • Code Structure
  • Configuring_SSH_Keys_on_Linux_and_Mac_OS_X
  • Configuring_SSH_Keys_on_Windows
  • Creating a Study Bible for OpenLP
  • Custom Stage Views
  • Development of Icons
  • Development
    • Branching_And_Merging_Standards
    • Coding_Standards
    • Convert from Bazaar to Git
    • Core_API_Framework
    • EasySlides_ _Song_Data_Format
    • EasyWorship_ _Song_Data_Format
View All Pages