From 52dcb6cff2c2fa60c29ad70d7c96b2340281c0bd Mon Sep 17 00:00:00 2001
From: "Karl O. Pinc kop@karlpinc.com" <kop@karlpinc.com>
Date: Sat, 4 Jul 2026 15:51:49 +0000
Subject: [PATCH] Add GROOMINGS.Others column

---
 .../sokwedb/indexes/create/groomings.m4       |  4 +--
 db/schemas/sokwedb/indexes/drop/groomings.m4  |  2 +-
 db/schemas/sokwedb/tables/create/groomings.m4 |  1 +
 doc/diagrams/events.svg                       | 32 ++++++++++++++++---
 doc/src/epilog.inc.m4                         |  2 ++
 doc/src/tables/groomings.m4                   | 13 ++++++++
 6 files changed, 47 insertions(+), 7 deletions(-)

diff --git a/db/schemas/sokwedb/indexes/create/groomings.m4 b/db/schemas/sokwedb/indexes/create/groomings.m4
index a9342da..572f602 100644
--- a/db/schemas/sokwedb/indexes/create/groomings.m4
+++ b/db/schemas/sokwedb/indexes/create/groomings.m4
@@ -25,7 +25,7 @@ CREATE INDEX IF NOT EXISTS groomings_initiator ON groomings
   (initiator);
 CREATE INDEX IF NOT EXISTS groomings_terminator ON groomings
   (terminator);
-CREATE INDEX IF NOT EXISTS groomings_initiator ON groomings
-  (initiator);
+CREATE INDEX IF NOT EXISTS groomings_others ON groomings
+  (others);
 -- We won't index ExtractedBy because this is not expected to be
 -- frequently searched.
diff --git a/db/schemas/sokwedb/indexes/drop/groomings.m4 b/db/schemas/sokwedb/indexes/drop/groomings.m4
index 0b164e5..88f118f 100644
--- a/db/schemas/sokwedb/indexes/drop/groomings.m4
+++ b/db/schemas/sokwedb/indexes/drop/groomings.m4
@@ -23,4 +23,4 @@ include(`indexmacros.m4')dnl
 
 DROP INDEX IF EXISTS groomings_initiator;
 DROP INDEX IF EXISTS groomings_terminator;
-DROP INDEX IF EXISTS groomings_initiator;
+DROP INDEX IF EXISTS groomings_other;
diff --git a/db/schemas/sokwedb/tables/create/groomings.m4 b/db/schemas/sokwedb/tables/create/groomings.m4
index b6eedf5..fbcae43 100644
--- a/db/schemas/sokwedb/tables/create/groomings.m4
+++ b/db/schemas/sokwedb/tables/create/groomings.m4
@@ -30,6 +30,7 @@ CREATE TABLE groomings (
        REFERENCES roles (pid)
   ,terminator INTEGER
        REFERENCES roles (pid)
+  ,others BOOLEAN NOT NULL
   ,problems TEXT NOT NULL
      notonlyspaces_check(`Problems')
   ,extractedby TEXT NOT NULL
diff --git a/doc/diagrams/events.svg b/doc/diagrams/events.svg
index 9fb4d78..f432c2d 100644
--- a/doc/diagrams/events.svg
+++ b/doc/diagrams/events.svg
@@ -877,8 +877,8 @@
      inkscape:pageopacity="0.0"
      inkscape:pageshadow="2"
      inkscape:zoom="1.8048192"
-     inkscape:cx="567.36985"
-     inkscape:cy="203.6215"
+     inkscape:cx="68.704943"
+     inkscape:cy="825.29042"
      inkscape:document-units="mm"
      inkscape:current-layer="layer3"
      inkscape:document-rotation="0"
@@ -1887,7 +1887,7 @@
          id="tspan2100-9-1-3-1-1-1-86"
          x="29.273668"
          y="227.1633"
-         style="stroke-width:0.265115px">Problems</tspan></text>
+         style="stroke-width:0.265115px">Others</tspan></text>
     <rect
        style="display:inline;fill:#ff2a2a;fill-opacity:0.000380632;stroke:#000000;stroke-width:0.207392;stroke-miterlimit:4;stroke-dasharray:none;stroke-dashoffset:0;stroke-opacity:0.98995"
        id="rect2104-7-6-7-7-7-9-0-2"
@@ -1910,7 +1910,7 @@
            id="tspan2100-9-1-3-1-8-2-4"
            x="79.876198"
            y="103.44704"
-           style="stroke-width:0.264583px">ExtractedBy *</tspan></text>
+           style="stroke-width:0.264583px">Problems</tspan></text>
       <rect
          style="fill:#ff2a2a;fill-opacity:0.000380632;stroke:#000000;stroke-width:0.212704;stroke-miterlimit:4;stroke-dasharray:none;stroke-dashoffset:0;stroke-opacity:0.98995"
          id="rect2104-7-6-7-7-7-10-0-0"
@@ -1919,6 +1919,30 @@
          x="79.216408"
          y="100.81641" />
     </g>
+    <g
+       id="g18174-6-84-3"
+       transform="translate(-50.529767,130.3917)"
+       inkscape:connector-avoid="true"
+       style="display:inline">
+      <text
+         xml:space="preserve"
+         style="font-style:normal;font-variant:normal;font-weight:normal;font-stretch:normal;font-size:2.82223px;line-height:125%;font-family:Sans;-inkscape-font-specification:'Sans, Normal';font-variant-ligatures:normal;font-variant-caps:normal;font-variant-numeric:normal;font-feature-settings:normal;text-align:start;letter-spacing:0px;word-spacing:0px;writing-mode:lr-tb;text-anchor:start;fill:#000000;fill-opacity:1;stroke:none;stroke-width:0.264583px;stroke-linecap:butt;stroke-linejoin:miter;stroke-opacity:1"
+         x="79.876198"
+         y="103.44704"
+         id="text2102-5-2-4-5-80-3-72-6"><tspan
+           sodipodi:role="line"
+           id="tspan2100-9-1-3-1-8-2-4-7"
+           x="79.876198"
+           y="103.44704"
+           style="stroke-width:0.264583px">ExtractedBy *</tspan></text>
+      <rect
+         style="fill:#ff2a2a;fill-opacity:0.000380632;stroke:#000000;stroke-width:0.212704;stroke-miterlimit:4;stroke-dasharray:none;stroke-dashoffset:0;stroke-opacity:0.98995"
+         id="rect2104-7-6-7-7-7-10-0-0-5"
+         width="30.477242"
+         height="3.5671799"
+         x="79.216408"
+         y="100.81641" />
+    </g>
     <text
        xml:space="preserve"
        style="font-style:italic;font-variant:normal;font-weight:normal;font-stretch:normal;font-size:2.82652px;line-height:125%;font-family:Sans;-inkscape-font-specification:'Sans, Italic';font-variant-ligatures:normal;font-variant-caps:normal;font-variant-numeric:normal;text-align:start;letter-spacing:0px;word-spacing:0px;writing-mode:lr-tb;text-anchor:start;fill:#000000;fill-opacity:1;stroke:none;stroke-width:0.264985px;stroke-linecap:butt;stroke-linejoin:miter;stroke-opacity:1;font-variant-east-asian:normal"
diff --git a/doc/src/epilog.inc.m4 b/doc/src/epilog.inc.m4
index 9c2ef36..5ca7259 100644
--- a/doc/src/epilog.inc.m4
+++ b/doc/src/epilog.inc.m4
@@ -483,6 +483,8 @@ sdb_generated_rst()dnl
    :ref:`Initiator <GROOMINGS.Initiator>`
 .. |GROOMINGS.Terminator| replace::
    :ref:`Terminator <GROOMINGS.Terminator>`
+.. |GROOMINGS.Others| replace::
+   :ref:`Others <GROOMINGS.Others>`
 .. |GROOMINGS.Problems| replace::
    :ref:`Problems <GROOMINGS.Problems>`
 .. |GROOMINGS.ExtractedBy| replace::
diff --git a/doc/src/tables/groomings.m4 b/doc/src/tables/groomings.m4
index 60296af..58add9a 100644
--- a/doc/src/tables/groomings.m4
+++ b/doc/src/tables/groomings.m4
@@ -118,6 +118,19 @@ This column may be |null| when there is no record of who terminated the
 grooming.
 
 
+.. _GROOMINGS.Others:
+
+Others
+````````
+
+.. |GROOMINGS.Others_summary| replace::
+   A boolean, |true| when individuals other than the grooming pair are
+   involved in the grooming.
+
+|GROOMINGS.Others_summary|
+|notnull|
+
+
 .. _GROOMINGS.Problems:
 
 Problems
-- 
2.34.1