scrollmapper / bible_databases

Bible versions and cross-reference databases.
994 stars 347 forks source link

Adding genre, Testament, and abbreviation information #1

Closed thesnarky1 closed 9 years ago

thesnarky1 commented 10 years ago

I added a bit more information about the books in this update. I added two clumns to the key_english (t which says which Testament this book is in and g which maps to a genre ID in key_genre_english and gives the genre). I added key_genre_english which holds the various genres of literature that are found in the Bible. Finally I added key_abbreviations_english which maps the book (b) to an abbreviation (a) and tells if that's what I'd consider the "primary" abbreivation for that book (such as "Gen" for "Genesis").

After adding this information I regenerated the SQL, CSV, XML, and JSON files for each of the affected tables, as well as the overall bible.sql file in the main folder. The one thing that's not updated is the SQLite database.