From 242a48aa7ca1a2b88a9be232fd6077b8c6797ffa Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc kop@karlpinc.com" Date: Wed, 13 May 2026 19:37:45 +0000 Subject: [PATCH] Add the AGGRESSIONS.FullAccount column --- conversion/load_aggressions.m4 | 2 ++ db/schemas/sokwedb/tables/create/aggressions.m4 | 2 ++ doc/src/epilog.inc.m4 | 2 ++ doc/src/tables/aggressions.m4 | 13 +++++++++++++ 4 files changed, 19 insertions(+) diff --git a/conversion/load_aggressions.m4 b/conversion/load_aggressions.m4 index c4096f2..5cb75fa 100644 --- a/conversion/load_aggressions.m4 +++ b/conversion/load_aggressions.m4 @@ -106,6 +106,7 @@ BEGIN ,contact ,vocal ,severity + ,fullaccount ,community ,extractedby) SELECT @@ -196,6 +197,7 @@ BEGIN ELSE this_ae.ae_fight_category_flag END + , this_ae.ae_full_description , this_ae.ae_cl_community_id , this_ae.ae_comments; diff --git a/db/schemas/sokwedb/tables/create/aggressions.m4 b/db/schemas/sokwedb/tables/create/aggressions.m4 index 698cd1c..23055ec 100644 --- a/db/schemas/sokwedb/tables/create/aggressions.m4 +++ b/db/schemas/sokwedb/tables/create/aggressions.m4 @@ -40,6 +40,8 @@ CREATE TABLE aggressions ( CONSTRAINT "Severity must an AGG_SEVERITIES.Severity value" REFERENCES agg_severities + ,fullaccount TEXT NOT NULL + notonlyspaces_check(`FullAccount') ,community TEXT NOT NULL REFERENCES comm_ids ,extractedby TEXT NOT NULL diff --git a/doc/src/epilog.inc.m4 b/doc/src/epilog.inc.m4 index 988c327..de19656 100644 --- a/doc/src/epilog.inc.m4 +++ b/doc/src/epilog.inc.m4 @@ -111,6 +111,8 @@ sdb_generated_rst()dnl replace:: :ref:`Vocal ` .. |AGGRESSIONS.Severity| replace:: :ref:`Severity ` +.. |AGGRESSIONS.FullAccount| + replace:: :ref:`FullAccount ` .. |AGGRESSIONS.Community| replace:: :ref:`Community ` .. |AGGRESSIONS.ExtractedBy| diff --git a/doc/src/tables/aggressions.m4 b/doc/src/tables/aggressions.m4 index 144c9d1..3897543 100644 --- a/doc/src/tables/aggressions.m4 +++ b/doc/src/tables/aggressions.m4 @@ -253,6 +253,19 @@ Severity |notnull| +.. _AGGRESSIONS.FullAccount: + +FullAccount +``````````` + +.. |AGGRESSIONS.FullAccount_summary| replace:: + Text providing an account of the aggression event. + +|AGGRESSIONS.FullAccount_summary| + +|notnull| + + .. _AGGRESSIONS.Community: Community -- 2.34.1