From 1bf23dbd87a5aca13b0c50ed9326a544cc7d798f Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc kop@karlpinc.com" Date: Fri, 28 Feb 2025 23:26:54 +0000 Subject: [PATCH] Use macro for key column generation --- db/schemas/sokwedb/tables/create/biography_log.m4 | 4 ++-- db/schemas/sokwedb/tables/create/comm_memb_log.m4 | 4 ++-- db/schemas/sokwedb/tables/create/comm_membs.m4 | 4 ++-- 3 files changed, 6 insertions(+), 6 deletions(-) diff --git a/db/schemas/sokwedb/tables/create/biography_log.m4 b/db/schemas/sokwedb/tables/create/biography_log.m4 index 0bb3b5a..782f388 100644 --- a/db/schemas/sokwedb/tables/create/biography_log.m4 +++ b/db/schemas/sokwedb/tables/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 @@ -24,7 +24,7 @@ include(`grants.m4')dnl dnl CREATE TABLE biography_log ( - blid INT GENERATED ALWAYS AS IDENTITY + key_column(`BIOGRAPHY_LOG', `BLID', INTEGER) ,dateofupdate DATE NOT NULL CONSTRAINT "DateOfUpdate may not be before sdb_first_biography_log_date" CHECK ('sdb_first_biography_log_date'::DATE <= dateofupdate) diff --git a/db/schemas/sokwedb/tables/create/comm_memb_log.m4 b/db/schemas/sokwedb/tables/create/comm_memb_log.m4 index 7bdca58..3340479 100644 --- a/db/schemas/sokwedb/tables/create/comm_memb_log.m4 +++ b/db/schemas/sokwedb/tables/create/comm_memb_log.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 @@ -24,7 +24,7 @@ include(`grants.m4')dnl dnl CREATE TABLE comm_memb_log ( - commmlid INT GENERATED ALWAYS AS IDENTITY + key_column(`COMM_MEMB_LOG', `CommMLID', INTEGER) ,dateofupdate DATE NOT NULL CONSTRAINT "DateOfUpdate may not be before sdb_first_memb_log_date" CHECK ('sdb_first_memb_log_date'::DATE <= dateofupdate) diff --git a/db/schemas/sokwedb/tables/create/comm_membs.m4 b/db/schemas/sokwedb/tables/create/comm_membs.m4 index d5b2f36..b5fa7e5 100644 --- a/db/schemas/sokwedb/tables/create/comm_membs.m4 +++ b/db/schemas/sokwedb/tables/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 @@ -24,7 +24,7 @@ include(`grants.m4')dnl dnl CREATE TABLE comm_membs ( - commmid INT GENERATED ALWAYS AS IDENTITY + key_column(`COMM_MEMBS', `CommMID', INTEGER) ,animid_column(`animid', `AnimID', `NOT NULL') ,startdate DATE NOT NULL ,enddate DATE NOT NULL -- 2.34.1