I wanted to share 2 files with this community, since it appears that this system does not allow files to be uploaded at attached to the forum post I posted to Rapidshare.
the XML file looks like this....
<bible translation="KJV"> <testament name="Old"> <book name="Genesis"> <chapter number="1"> <verse number="1">In the beginning God created the heaven and the earth.</verse> <verse number="2">And the earth was without form, and void; and darkness was upon the face of the deep. And the Spirit of God moved upon the face of the waters.</verse> <!-- THE REST OF THE XML HERE --> </chapter> </book> </testament> </bible>
The sql file was created in MySql version 5.x, and it creates 3 tables.
3 Tables: testaments, king_james_version, books
Books - The 66 books of the Bible
fields: bookId | bookName | testamentId
king_james_version - The verses of the bible
fields: verseId | bookId | chapterNumber | verseNumber | verseText
testaments - simply 2 entries... Old and New, Id's are 1 and 2 respectively
fields: testamentId | testamentName
I have verified that it contains 66 books, 1189 chapters and 31,102 verses. From what I found it is pretty accurate, though I have not verified word for word.
I got the XML file originally from believersresource.com. I fixed a few node issues and imported into database and created sql dump from that.
I hope that some people here can find these useful. If you download them, I would love for you to respond here and say what kind of project you might use them for.
I myself plan on creating an entire web app with it. Verse lookup, read bible in year, verse of the day, RSS feed... etc. Gonna be fun. :)
God Bless and have a Merry Christmas