Skip to content

Instantly share code, notes, and snippets.

@Dev1an

Dev1an/EmmaSongs HFSQL database structure.md

Created March 5, 2021 14:17
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save Dev1an/2e63058a82c17cb59f00ddd911f17053 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save Dev1an/2e63058a82c17cb59f00ddd911f17053 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
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]
@nathanael-h
Copy link

nathanael-h commented Dec 5, 2021

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

@Dev1an
Copy link
Author

Dev1an commented Dec 5, 2021 •
edited
Loading

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.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment