From 03bee991ae69d23f56d044ebf806c9b463a9c13c Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc kop@karlpinc.com" Date: Sat, 20 Jan 2024 19:29:00 +0000 Subject: [PATCH] Index biography_log and comm_memb_log --- db/schemas/sokwedb/indexes/Makefile | 2 +- .../sokwedb/indexes/create/biography_log.m4 | 29 +++++++++++++++++++ .../sokwedb/indexes/create/comm_memb_log.m4 | 29 +++++++++++++++++++ .../sokwedb/indexes/drop/biography_log.m4 | 26 +++++++++++++++++ .../sokwedb/indexes/drop/comm_memb_log.m4 | 26 +++++++++++++++++ 5 files changed, 111 insertions(+), 1 deletion(-) create mode 100644 db/schemas/sokwedb/indexes/create/biography_log.m4 create mode 100644 db/schemas/sokwedb/indexes/create/comm_memb_log.m4 create mode 100644 db/schemas/sokwedb/indexes/drop/biography_log.m4 create mode 100644 db/schemas/sokwedb/indexes/drop/comm_memb_log.m4 diff --git a/db/schemas/sokwedb/indexes/Makefile b/db/schemas/sokwedb/indexes/Makefile index c2b8d1a..01acbf6 100644 --- a/db/schemas/sokwedb/indexes/Makefile +++ b/db/schemas/sokwedb/indexes/Makefile @@ -19,7 +19,7 @@ # This determines the order in which the indexes are put into the database. # This is not really important but is needed for other types of db objects. -ORDER := biography comm_membs +ORDER := biography biography_log comm_membs comm_memb_log ## ## CAUTION: This Makefile is not designed to be run directly. It is normally diff --git a/db/schemas/sokwedb/indexes/create/biography_log.m4 b/db/schemas/sokwedb/indexes/create/biography_log.m4 new file mode 100644 index 0000000..304ba5d --- /dev/null +++ b/db/schemas/sokwedb/indexes/create/biography_log.m4 @@ -0,0 +1,29 @@ +dnl Copyright (C) 2024 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 +dnl by the Free Software Foundation, either version 3 of the License, or +dnl (at your option) any later version. +dnl +dnl This program is distributed in the hope that it will be useful, +dnl but WITHOUT ANY WARRANTY; without even the implied warranty of +dnl MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the +dnl GNU Affero General Public License for more details. +dnl +dnl You should have received a copy of the GNU Affero General Public License +dnl along with this program. If not, see . +dnl +dnl Karl O. Pinc +dnl +dnl +dnl m4 includes +include(`copyright.m4')dnl +include(`constants.m4')dnl +include(`macros.m4')dnl + +CREATE INDEX IF NOT EXISTS biography_log_startdate ON biography_log + (dateofupdate); +CREATE INDEX IF NOT EXISTS biography_log_animid ON biography_log + (animid); +CREATE INDEX IF NOT EXISTS biography_log_madeby ON biography_log + (madeby); diff --git a/db/schemas/sokwedb/indexes/create/comm_memb_log.m4 b/db/schemas/sokwedb/indexes/create/comm_memb_log.m4 new file mode 100644 index 0000000..8fe0f6f --- /dev/null +++ b/db/schemas/sokwedb/indexes/create/comm_memb_log.m4 @@ -0,0 +1,29 @@ +dnl Copyright (C) 2024 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 +dnl by the Free Software Foundation, either version 3 of the License, or +dnl (at your option) any later version. +dnl +dnl This program is distributed in the hope that it will be useful, +dnl but WITHOUT ANY WARRANTY; without even the implied warranty of +dnl MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the +dnl GNU Affero General Public License for more details. +dnl +dnl You should have received a copy of the GNU Affero General Public License +dnl along with this program. If not, see . +dnl +dnl Karl O. Pinc +dnl +dnl +dnl m4 includes +include(`copyright.m4')dnl +include(`constants.m4')dnl +include(`macros.m4')dnl + +CREATE INDEX IF NOT EXISTS comm_memb_log_startdate ON comm_memb_log + (dateofupdate); +CREATE INDEX IF NOT EXISTS comm_memb_log_animid ON comm_memb_log + (animid); +CREATE INDEX IF NOT EXISTS comm_memb_log_madeby ON comm_memb_log + (madeby); diff --git a/db/schemas/sokwedb/indexes/drop/biography_log.m4 b/db/schemas/sokwedb/indexes/drop/biography_log.m4 new file mode 100644 index 0000000..8696b33 --- /dev/null +++ b/db/schemas/sokwedb/indexes/drop/biography_log.m4 @@ -0,0 +1,26 @@ +dnl Copyright (C) 2024 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 +dnl by the Free Software Foundation, either version 3 of the License, or +dnl (at your option) any later version. +dnl +dnl This program is distributed in the hope that it will be useful, +dnl but WITHOUT ANY WARRANTY; without even the implied warranty of +dnl MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the +dnl GNU Affero General Public License for more details. +dnl +dnl You should have received a copy of the GNU Affero General Public License +dnl along with this program. If not, see . +dnl +dnl Karl O. Pinc +dnl +dnl +dnl m4 includes +include(`copyright.m4')dnl +include(`constants.m4')dnl +include(`macros.m4')dnl + +DROP INDEX IF EXISTS biography_log_startdate; +DROP INDEX IF EXISTS biography_log_animid; +DROP INDEX IF EXISTS biography_log_madeby; diff --git a/db/schemas/sokwedb/indexes/drop/comm_memb_log.m4 b/db/schemas/sokwedb/indexes/drop/comm_memb_log.m4 new file mode 100644 index 0000000..91fca2a --- /dev/null +++ b/db/schemas/sokwedb/indexes/drop/comm_memb_log.m4 @@ -0,0 +1,26 @@ +dnl Copyright (C) 2024 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 +dnl by the Free Software Foundation, either version 3 of the License, or +dnl (at your option) any later version. +dnl +dnl This program is distributed in the hope that it will be useful, +dnl but WITHOUT ANY WARRANTY; without even the implied warranty of +dnl MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the +dnl GNU Affero General Public License for more details. +dnl +dnl You should have received a copy of the GNU Affero General Public License +dnl along with this program. If not, see . +dnl +dnl Karl O. Pinc +dnl +dnl +dnl m4 includes +include(`copyright.m4')dnl +include(`constants.m4')dnl +include(`macros.m4')dnl + +DROP INDEX IF EXISTS comm_memb_log_startdate; +DROP INDEX IF EXISTS comm_memb_log_animid; +DROP INDEX IF EXISTS comm_memb_log_madeby; -- 2.34.1