From 665c8adc495aef12e16009729385b8054a0b4a7b Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc" Date: Tue, 28 Nov 2023 11:07:19 -0600 Subject: [PATCH] Require COMM_IDS.Name be unique --- db/schemas/Makefile | 2 +- db/schemas/lookup/indexes/Makefile | 28 ++++++++++++++++++++ db/schemas/lookup/indexes/create/comm_ids.m4 | 25 +++++++++++++++++ db/schemas/lookup/indexes/drop/comm_ids.m4 | 24 +++++++++++++++++ doc/src/code_tables.m4 | 2 +- 5 files changed, 79 insertions(+), 2 deletions(-) create mode 100644 db/schemas/lookup/indexes/Makefile create mode 100644 db/schemas/lookup/indexes/create/comm_ids.m4 create mode 100644 db/schemas/lookup/indexes/drop/comm_ids.m4 diff --git a/db/schemas/Makefile b/db/schemas/Makefile index d35364d..c4ad9e7 100644 --- a/db/schemas/Makefile +++ b/db/schemas/Makefile @@ -41,7 +41,7 @@ TABLE_SCHEMAS := lookup sokwedb FUNCTION_SCHEMAS := sokwedb TRIGGER_SCHEMAS := lib VIEW_SCHEMAS := sokwedb -INDEX_SCHEMAS := sokwedb +INDEX_SCHEMAS := lookup sokwedb COMMENT_SCHEMAS := lookup sokwedb ## diff --git a/db/schemas/lookup/indexes/Makefile b/db/schemas/lookup/indexes/Makefile new file mode 100644 index 0000000..959a0ed --- /dev/null +++ b/db/schemas/lookup/indexes/Makefile @@ -0,0 +1,28 @@ +# Copyright (C) 2023 The Meme Factory, Inc. http://www.karlpinc.com/ +# +# This program is free software: you can redistribute it and/or modify +# it under the terms of the GNU Affero General Public License as published by +# the Free Software Foundation, either version 3 of the License, or +# (at your option) any later version. +# +# This program is distributed in the hope that it will be useful, +# but WITHOUT ANY WARRANTY; without even the implied warranty of +# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the +# GNU Affero General Public License for more details. +# +# You should have received a copy of the GNU Affero General Public License +# along with this program. If not, see . +# +# Makefile for tables +# +# Karl O. Pinc + +# 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 := comm_ids + +## +## CAUTION: This Makefile is not designed to be run directly. It is normally +## invoked by another Makefile. + +include ../../../../make_files/things.mk diff --git a/db/schemas/lookup/indexes/create/comm_ids.m4 b/db/schemas/lookup/indexes/create/comm_ids.m4 new file mode 100644 index 0000000..b3d1a77 --- /dev/null +++ b/db/schemas/lookup/indexes/create/comm_ids.m4 @@ -0,0 +1,25 @@ +dnl Copyright (C) 2023 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 UNIQUE INDEX IF NOT EXISTS comm_ids_name ON comm_ids + (name); diff --git a/db/schemas/lookup/indexes/drop/comm_ids.m4 b/db/schemas/lookup/indexes/drop/comm_ids.m4 new file mode 100644 index 0000000..7792ab7 --- /dev/null +++ b/db/schemas/lookup/indexes/drop/comm_ids.m4 @@ -0,0 +1,24 @@ +dnl Copyright (C) 2023 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_ids_name; diff --git a/doc/src/code_tables.m4 b/doc/src/code_tables.m4 index 2bd8015..d827188 100644 --- a/doc/src/code_tables.m4 +++ b/doc/src/code_tables.m4 @@ -72,7 +72,7 @@ Name .. |COMM_IDS.Name_summary| replace:: The name of the community. -|COMM_IDS.Name_summary| |emptytext| |notnull| +|COMM_IDS.Name_summary| |unique| |emptytext| |notnull| .. _COMM_IDS.Notes: -- 2.34.1