The files in this folder are supplied "as is", and may be of some use.

SQL-related files
=================
These SQL files may be of some use if you wish to use ScionPC database information (exported using
the ScionPC "export CSV files" option) in conventional SQL-aware databases.

CreateEmptyScionDatabase.sql - SQL code to create an empty SQL database configured to receive data
                               from a ScionPC database (exported as CSV files).
CREATE_VU_FamilyGroup.sql    - SQL code to generate an SQL View listing all the children in
                               family groups together with their parents' names and IDs.
CREATE_VU_FullName.sql       - SQL code to generate an SQL View of the names of people in their
                               preferred display format, incorporating also their familiar names,
                               titles and suffices.
NamedFactsAndSources.sql     - SQL code to generate a list of personal facts for each person, along
                               with related fact source information.
NamedFactsAndSources.png     - An example of the result of executing "NamedFactsAndSources.sql" in
                               the SQLiteSpy programme.

NOTE: The "CREATE_VU_FullName.sql" SQL code uses the "||" string concatenation operator.
      Other SQL implementations may use different concatenation operators.


Web-related files
=================
These files are copies of the default ScionPC web-page templates used to generate web-pages
(subject to change). You might like to use these as the foundation for your own custom web-page
templates.

DefaultPersPageTemplate.htm      - Template for the main "Personal" web-page
DefaultPersAlbumTemplate.htm     - Template for the "Personal Album" web-page
DefaultFamAlbumTemplate.htm      - Template for the "Family Album" web-page
DefaultAlbumsIndexTemplate.htm   - Template for the "Albums Index" web-page
DefaultEvidenceIndexTemplate.htm - Template for the "Evidence Index" web-page
DefaultNotePageTemplate.htm      - Template for each "Note" web-page
DefaultSourcePageTemplate.htm    - Template for each "Source" web-page
DefaultSurnameIndexTemplate.htm  - Template for the main "Surnames Index" web-page
DefaultLetterIndexTemplate.htm   - Template for the individual "Surnames by first letter" web-pages

Additional
----------
sample_home_page.htm             - a sample "home page" that could form the basis of a personal
                                   web-site. NOTE: Uses the "scion.css" style sheet that can be
                                   generated by ScionPC when it creates web pages.
\gfx directory                   - graphics files supporting the sample "home page"
