From 31bbb982c27ab1f2bd5a9b56886d6dfb57a4dab1 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 ++-- 5 files changed, 11 insertions(+), 10 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); -- 2.34.1