abstraction 2.1: a poem states its object range

- A poem is a container of verse, and stores its range of verse ocn,
  - its verse are the citable units with ocn.

- A note in the last verse of a poem previously was not gathered into
  the endnotes section, this now is fixed

Format 2.0 -> 2.1: the property is an addition, the poem is not a
citable object (but contans a range of objects), its verse are
(individual citable objects), and every reader checks the major version.
A 2.0 database reads as having no ranges.

(assisted by Claude-Code)

1 files changed, 6 insertions, 2 deletions

diff --git a/org/out_ocda_sqlite_db.org b/org/out_ocda_sqlite_db.org
index e8c8490..5424ed8 100644
--- a/org/out_ocda_sqlite_db.org
+++ b/org/out_ocda_sqlite_db.org
@@ -164,6 +164,8 @@ template spineAbstractionDb() {
         parent_ocn            INTEGER DEFAULT 0,
         parent_lev            INTEGER DEFAULT 0,
         last_descendant_ocn   INTEGER DEFAULT 0,
+        ocn_range_first       INTEGER DEFAULT 0,
+        ocn_range_last        INTEGER DEFAULT 0,
         children              TEXT
           CHECK(children IS NULL OR json_valid(children)),
         ancestors             TEXT
@@ -418,7 +420,7 @@ template spineAbstractionDb() {
       "INSERT INTO objects ("
       ~ "doc_id, section, seq, ocn, is_a, is_of_part, is_of_section, is_of_type,"
       ~ "heading_level, heading_lev_collapsed, identifier,"
-      ~ "parent_ocn, parent_lev, last_descendant_ocn,"
+      ~ "parent_ocn, parent_lev, last_descendant_ocn, ocn_range_first, ocn_range_last,"
       ~ "children, ancestors, ancestors_collapsed,"
       ~ "dom_status, dom_status_collapsed,"
       ~ "dummy_heading, object_number_off,"
@@ -433,7 +435,7 @@ template spineAbstractionDb() {
       ~ ") VALUES ("
       ~ ":doc_id, :section, :seq, :ocn, :is_a, :is_of_part, :is_of_section, :is_of_type,"
       ~ ":heading_level, :heading_lev_collapsed, :identifier,"
-      ~ ":parent_ocn, :parent_lev, :last_descendant_ocn,"
+      ~ ":parent_ocn, :parent_lev, :last_descendant_ocn, :ocn_range_first, :ocn_range_last,"
       ~ ":children, :ancestors, :ancestors_collapsed,"
       ~ ":dom_status, :dom_status_collapsed,"
       ~ ":dummy_heading, :object_number_off,"
@@ -542,6 +544,8 @@ template spineAbstractionDb() {
         obj_stmt.bind(":parent_ocn", obj.metainfo.parent_ocn);
         obj_stmt.bind(":parent_lev", obj.metainfo.parent_lev_markup);
         obj_stmt.bind(":last_descendant_ocn", obj.metainfo.last_descendant_ocn);
+        obj_stmt.bind(":ocn_range_first", obj.metainfo.ocn_range_first);
+        obj_stmt.bind(":ocn_range_last", obj.metainfo.ocn_range_last);
 
         bindJsonInts(":children", obj.metainfo.children_headings);
         bindJsonInts(":ancestors", obj.metainfo.markedup_ancestors);