EmmaSongs HFSQL database structure.md

EmmaSongs

ccievchant_lignes.fic

• Songtekst one record per line (UTF16 little endian) [9-266]
• VerseID [277-278]

ccievchant.fic

Records start with 10 01 00 ?? 1F F2 5D

• ChantID (UInt64LE) [10-18]
  • AD 2E 01 → Hosanna
  • 18 22 01 → Je vous ai choisis
• Song number (UTF8) [18-37]
• Title (UTF16?) [39-553]
• Theme [553-569]
• OrginialID (reference to ChantID) [569-577]
• Language [577]
• Song number repeated? (UTF-8) [585-601]
• Description (UTF-8) [604-1358]
• Copyright (UTF16) [1361-2380]
• website (UTF-8) [2388-end]

ccievchant_stophes.fic

• ChantID [15-16]
• VerseID [23-24]
• Sequence number [13]
• Verse number [12]
• Type [9]
  • 41 → italic?
  • 43 → verse
  • 44 → Doxologie:
  • 4B → Canon?
  • 4C → Italic?
  • 4F → Coda:?
  • 50 → Bridge
  • 52 → Refrain
  • 53 → Solist: *Only if there are no associated lines

ccievchant_typestrophe_ievlangue

• Language [9]
• typeID [17]
• text [25-...]

Language codes

• 01 French
• 02 English
• 03 Spanish
• 04 Italian
• 05 German
• 06 ?
• 07 Latin
• 08 Dutch
• 09 Portugese
• 0A Arabic
• 0B Chinese
• 0C Polish
• 0D Indonesian
• 0E Slovak
• 10 Hungarian
• 11 Czech
• 12 Hebrew
• 13 Vietnamese
• 14 Haitian Creole (HT)
• 16 Kinyarwanda
• 17 Solvenian
• 18 Russian
• 19 Catalan
• 1A Croatian
• 1B Romanian
• 1C PB
• 1D KMB (Kimbundu?)
• 1E Ukrainian
• 1F Malagasy
• 21 CF?
• 22 Thai
• 24 TM?
• 27 XH
• 28 Arabic?

Verder uit te zoeken

ccievchant_ievarticle.fic

• ChantID
• $UnknownB (id 4 bytes) article sequence number, unique per \ChantID

ccievensemblechants 21 records / ensembles

Ensemblechants ievChants

• Start [0-8]
• Padding [8]
• Song ID [9-17]
• Rubrique Language [17-25]
• Rubrique ID [25-33]
• Tag 1 [33-37]
• Tag 2 [37-41]

rubriqueensemble

• starts with 10 01 00 AF 1F F2 5D 00 [0-8]
• padding? [8]
• SongID [9-17]
• Theme [17-119]
• SubTheme [119-219]
• Language sequence number (not language ID) [221-229]
  • 1 -> FR
  • 2 -> EN
  • 3 -> DE
  • 4 -> NL
• ID 2? [229-232]
• Rubrique sequence number (not unique per language) [237]

Hey! Did you built something around this gist, emmasongs, etc ? I used to maintain the emmasongs app.

Hi @nathanael-h I reversed engineered the entire database from the iOS app that I bought on the App Store and I also recovered the password for the encrypted tables (chords etc.) which are not on this public gist.
I used it to build some native iOS apps for private use.