-- Names-Edit_NameTable.sql
/*
2014-10-29 Tom Holden ve3meo

This query produces a convenient layout of a subset of the columns from NameTable for use
in SQLite Expert Personal, especially for editing which it supports in the results
panel. SQLiteSpy supports editing only when the whole table is displayed, not 
for a subset of columns.

Requires that the unifuzz.dll fake RMONCASE extension is loaded with the database.

After editing, run RootsMagic Database Tools: Integrity Check, if not OK then:
 Rebuild Indexes, repeat.
*/
SELECT
  OwnerID AS RIN,
  Prefix,  
  Given,  
  Nickname,
  Surname,  
  Suffix,
  BirthYear,  
  DeathYear,  
  NameType,  
  IsPrimary,    
  Sentence,  
  Note  
FROM NameTable
ORDER BY
  RIN, 
  IsPrimary DESC
;