From 0561ca4fe3ab1e6ecc3abdbd6e9819e5384b9764 Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc kop@karlpinc.com" Date: Thu, 2 Oct 2025 22:53:20 +0000 Subject: [PATCH] Use indexmacros.m4 when creating indexes --- db/schemas/codes/indexes/create/comm_ids.m4 | 4 ++-- db/schemas/sokwedb/indexes/create/biography_data.m4 | 5 +++-- db/schemas/sokwedb/indexes/create/biography_log.m4 | 4 ++-- db/schemas/sokwedb/indexes/create/comm_memb_log.m4 | 4 ++-- db/schemas/sokwedb/indexes/create/comm_membs.m4 | 4 ++-- db/schemas/sokwedb/indexes/create/follows.m4 | 2 +- db/schemas/sokwedb/indexes/drop/biography_data.m4 | 2 +- db/schemas/sokwedb/indexes/drop/biography_log.m4 | 4 ++-- db/schemas/sokwedb/indexes/drop/comm_memb_log.m4 | 4 ++-- db/schemas/sokwedb/indexes/drop/comm_membs.m4 | 4 ++-- db/schemas/sokwedb/indexes/drop/follows.m4 | 2 +- 11 files changed, 20 insertions(+), 19 deletions(-) diff --git a/db/schemas/codes/indexes/create/comm_ids.m4 b/db/schemas/codes/indexes/create/comm_ids.m4 index b3d1a77..bb3a23a 100644 --- a/db/schemas/codes/indexes/create/comm_ids.m4 +++ b/db/schemas/codes/indexes/create/comm_ids.m4 @@ -1,4 +1,4 @@ -dnl Copyright (C) 2023 The Meme Factory, Inc., http://www.karlpinc.com/ +dnl Copyright (C) 2023, 2025 The Meme Factory, Inc., http://www.karlpinc.com/ dnl dnl This program is free software: you can redistribute it and/or modify dnl it under the terms of the GNU Affero General Public License as published @@ -19,7 +19,7 @@ dnl dnl m4 includes include(`copyright.m4')dnl include(`constants.m4')dnl -include(`macros.m4')dnl +include(`indexmacros.m4')dnl CREATE UNIQUE INDEX IF NOT EXISTS comm_ids_name ON comm_ids (name); diff --git a/db/schemas/sokwedb/indexes/create/biography_data.m4 b/db/schemas/sokwedb/indexes/create/biography_data.m4 index d7a51fc..2ebdc9d 100644 --- a/db/schemas/sokwedb/indexes/create/biography_data.m4 +++ b/db/schemas/sokwedb/indexes/create/biography_data.m4 @@ -1,4 +1,5 @@ -dnl Copyright (C) 2023, 2024 The Meme Factory, Inc., http://www.karlpinc.com/ +dnl Copyright (C) 2023, 2024, 2025 The Meme Factory, Inc., +dnl http://www.karlpinc.com/ dnl dnl This program is free software: you can redistribute it and/or modify dnl it under the terms of the GNU Affero General Public License as published @@ -19,7 +20,7 @@ dnl dnl m4 includes include(`copyright.m4')dnl include(`constants.m4')dnl -include(`macros.m4')dnl +include(`indexmacros.m4')dnl CREATE UNIQUE INDEX IF NOT EXISTS biography_data_animidnum ON biography_data (animidnum); diff --git a/db/schemas/sokwedb/indexes/create/biography_log.m4 b/db/schemas/sokwedb/indexes/create/biography_log.m4 index 304ba5d..66b999f 100644 --- a/db/schemas/sokwedb/indexes/create/biography_log.m4 +++ b/db/schemas/sokwedb/indexes/create/biography_log.m4 @@ -1,4 +1,4 @@ -dnl Copyright (C) 2024 The Meme Factory, Inc., http://www.karlpinc.com/ +dnl Copyright (C) 2024, 2025 The Meme Factory, Inc., http://www.karlpinc.com/ dnl dnl This program is free software: you can redistribute it and/or modify dnl it under the terms of the GNU Affero General Public License as published @@ -19,7 +19,7 @@ dnl dnl m4 includes include(`copyright.m4')dnl include(`constants.m4')dnl -include(`macros.m4')dnl +include(`indexmacros.m4')dnl CREATE INDEX IF NOT EXISTS biography_log_startdate ON biography_log (dateofupdate); diff --git a/db/schemas/sokwedb/indexes/create/comm_memb_log.m4 b/db/schemas/sokwedb/indexes/create/comm_memb_log.m4 index 8fe0f6f..aa5f2c7 100644 --- a/db/schemas/sokwedb/indexes/create/comm_memb_log.m4 +++ b/db/schemas/sokwedb/indexes/create/comm_memb_log.m4 @@ -1,4 +1,4 @@ -dnl Copyright (C) 2024 The Meme Factory, Inc., http://www.karlpinc.com/ +dnl Copyright (C) 2024, 2025 The Meme Factory, Inc., http://www.karlpinc.com/ dnl dnl This program is free software: you can redistribute it and/or modify dnl it under the terms of the GNU Affero General Public License as published @@ -19,7 +19,7 @@ dnl dnl m4 includes include(`copyright.m4')dnl include(`constants.m4')dnl -include(`macros.m4')dnl +include(`indexmacros.m4')dnl CREATE INDEX IF NOT EXISTS comm_memb_log_startdate ON comm_memb_log (dateofupdate); diff --git a/db/schemas/sokwedb/indexes/create/comm_membs.m4 b/db/schemas/sokwedb/indexes/create/comm_membs.m4 index ed5212a..ba0ffdb 100644 --- a/db/schemas/sokwedb/indexes/create/comm_membs.m4 +++ b/db/schemas/sokwedb/indexes/create/comm_membs.m4 @@ -1,4 +1,4 @@ -dnl Copyright (C) 2023 The Meme Factory, Inc., http://www.karlpinc.com/ +dnl Copyright (C) 2023, 2025 The Meme Factory, Inc., http://www.karlpinc.com/ dnl dnl This program is free software: you can redistribute it and/or modify dnl it under the terms of the GNU Affero General Public License as published @@ -19,7 +19,7 @@ dnl dnl m4 includes include(`copyright.m4')dnl include(`constants.m4')dnl -include(`macros.m4')dnl +include(`indexmacros.m4')dnl CREATE INDEX IF NOT EXISTS comm_membs_animid ON comm_membs (animid); diff --git a/db/schemas/sokwedb/indexes/create/follows.m4 b/db/schemas/sokwedb/indexes/create/follows.m4 index 7602998..3e06632 100644 --- a/db/schemas/sokwedb/indexes/create/follows.m4 +++ b/db/schemas/sokwedb/indexes/create/follows.m4 @@ -19,7 +19,7 @@ dnl dnl m4 includes include(`copyright.m4')dnl include(`constants.m4')dnl -include(`macros.m4')dnl +include(`indexmacros.m4')dnl CREATE UNIQUE INDEX IF NOT EXISTS follows_date_focal ON follows (date, focal); diff --git a/db/schemas/sokwedb/indexes/drop/biography_data.m4 b/db/schemas/sokwedb/indexes/drop/biography_data.m4 index bb9fa05..e4c7a8f 100644 --- a/db/schemas/sokwedb/indexes/drop/biography_data.m4 +++ b/db/schemas/sokwedb/indexes/drop/biography_data.m4 @@ -20,7 +20,7 @@ dnl dnl m4 includes include(`copyright.m4')dnl include(`constants.m4')dnl -include(`macros.m4')dnl +include(`indexmacros.m4')dnl DROP INDEX IF EXISTS biography_data_animidnum; DROP INDEX IF EXISTS biography_data_animname; diff --git a/db/schemas/sokwedb/indexes/drop/biography_log.m4 b/db/schemas/sokwedb/indexes/drop/biography_log.m4 index 8696b33..76f4325 100644 --- a/db/schemas/sokwedb/indexes/drop/biography_log.m4 +++ b/db/schemas/sokwedb/indexes/drop/biography_log.m4 @@ -1,4 +1,4 @@ -dnl Copyright (C) 2024 The Meme Factory, Inc., http://www.karlpinc.com/ +dnl Copyright (C) 2024, 2025 The Meme Factory, Inc., http://www.karlpinc.com/ dnl dnl This program is free software: you can redistribute it and/or modify dnl it under the terms of the GNU Affero General Public License as published @@ -19,7 +19,7 @@ dnl dnl m4 includes include(`copyright.m4')dnl include(`constants.m4')dnl -include(`macros.m4')dnl +include(`indexmacros.m4')dnl DROP INDEX IF EXISTS biography_log_startdate; DROP INDEX IF EXISTS biography_log_animid; diff --git a/db/schemas/sokwedb/indexes/drop/comm_memb_log.m4 b/db/schemas/sokwedb/indexes/drop/comm_memb_log.m4 index 91fca2a..7573a94 100644 --- a/db/schemas/sokwedb/indexes/drop/comm_memb_log.m4 +++ b/db/schemas/sokwedb/indexes/drop/comm_memb_log.m4 @@ -1,4 +1,4 @@ -dnl Copyright (C) 2024 The Meme Factory, Inc., http://www.karlpinc.com/ +dnl Copyright (C) 2024, 2025 The Meme Factory, Inc., http://www.karlpinc.com/ dnl dnl This program is free software: you can redistribute it and/or modify dnl it under the terms of the GNU Affero General Public License as published @@ -19,7 +19,7 @@ dnl dnl m4 includes include(`copyright.m4')dnl include(`constants.m4')dnl -include(`macros.m4')dnl +include(`indexmacros.m4')dnl DROP INDEX IF EXISTS comm_memb_log_startdate; DROP INDEX IF EXISTS comm_memb_log_animid; diff --git a/db/schemas/sokwedb/indexes/drop/comm_membs.m4 b/db/schemas/sokwedb/indexes/drop/comm_membs.m4 index e0b839d..f1079ed 100644 --- a/db/schemas/sokwedb/indexes/drop/comm_membs.m4 +++ b/db/schemas/sokwedb/indexes/drop/comm_membs.m4 @@ -1,4 +1,4 @@ -dnl Copyright (C) 2023 The Meme Factory, Inc., http://www.karlpinc.com/ +dnl Copyright (C) 2023, 2025 The Meme Factory, Inc., http://www.karlpinc.com/ dnl dnl This program is free software: you can redistribute it and/or modify dnl it under the terms of the GNU Affero General Public License as published @@ -19,7 +19,7 @@ dnl dnl m4 includes include(`copyright.m4')dnl include(`constants.m4')dnl -include(`macros.m4')dnl +include(`indexmacros.m4')dnl DROP INDEX IF EXISTS comm_membs_animid; DROP INDEX IF EXISTS comm_membs_startdate; diff --git a/db/schemas/sokwedb/indexes/drop/follows.m4 b/db/schemas/sokwedb/indexes/drop/follows.m4 index 235b0c8..658976b 100644 --- a/db/schemas/sokwedb/indexes/drop/follows.m4 +++ b/db/schemas/sokwedb/indexes/drop/follows.m4 @@ -19,7 +19,7 @@ dnl dnl m4 includes include(`copyright.m4')dnl include(`constants.m4')dnl -include(`macros.m4')dnl +include(`indexmacros.m4')dnl DROP INDEX IF EXISTS follows_date_focal; -- 2.34.1