Initial database construction
authorKarl O. Pinc <kop@karlpinc.com>
Thu, 7 Sep 2023 21:28:46 +0000 (16:28 -0500)
committerKarl O. Pinc <kop@karlpinc.com>
Thu, 7 Sep 2023 21:28:46 +0000 (16:28 -0500)
commit7b65d077582731b3f52bb0f96fbeb98d67a169c0
tree70bb07689ce81da4b1ad75b1c8a2a34654c8e4a0
parent4703e28188daf3ee335616289d7831e9ab2d4b5f
Initial database construction

This includes creation of a build system as well as tables, triggers, etc.
that create some initial demographic database objects.  Also included
are some changes to the documentation which include additional database
validation rules.
63 files changed:
.gitignore
Makefile
db/README [new file with mode: 0644]
db/creategroups.m4 [new file with mode: 0644]
db/createtypes.m4 [new file with mode: 0644]
db/droptypes.m4 [new file with mode: 0644]
db/include/copyright.m4 [new file with mode: 0644]
db/include/copyright.sql [new file with mode: 0644]
db/include/do_not_edit.sql [new file with mode: 0644]
db/include/functions.m4 [new file with mode: 0644]
db/include/grants.m4 [new file with mode: 0644]
db/include/macros.m4
db/include/tablemacros.m4 [new file with mode: 0644]
db/include/types.m4 [new file with mode: 0644]
db/schemas/Makefile [new file with mode: 0644]
db/schemas/check_target_schema.sh [new file with mode: 0755]
db/schemas/create_sql.sh [new file with mode: 0755]
db/schemas/createschemas.m4 [new file with mode: 0644]
db/schemas/drop_sql.sh [new file with mode: 0755]
db/schemas/dropschemas.m4 [new file with mode: 0644]
db/schemas/lookup/tables/Makefile [new file with mode: 0644]
db/schemas/lookup/tables/create/comm_ids.m4 [new file with mode: 0644]
db/schemas/lookup/tables/create/departtypes.m4 [new file with mode: 0644]
db/schemas/lookup/tables/create/entrytypes.m4 [new file with mode: 0644]
db/schemas/lookup/tables/create/people.m4 [new file with mode: 0644]
db/schemas/lookup/triggers/Makefile [new file with mode: 0644]
db/schemas/lookup/triggers/create/comm_ids.m4 [new file with mode: 0644]
db/schemas/lookup/triggers/create/departtypes.m4 [new file with mode: 0644]
db/schemas/lookup/triggers/drop/comm_ids.m4 [new file with mode: 0644]
db/schemas/lookup/triggers/drop/departtypes.m4 [new file with mode: 0644]
db/schemas/sokwedb/functions/Makefile [new file with mode: 0644]
db/schemas/sokwedb/functions/create/julian.m4 [new file with mode: 0644]
db/schemas/sokwedb/functions/drop/julian.m4 [new file with mode: 0644]
db/schemas/sokwedb/indexes/Makefile [new file with mode: 0644]
db/schemas/sokwedb/indexes/create/biography.m4 [new file with mode: 0644]
db/schemas/sokwedb/indexes/create/comm_membs.m4 [new file with mode: 0644]
db/schemas/sokwedb/indexes/drop/biography.m4 [new file with mode: 0644]
db/schemas/sokwedb/indexes/drop/comm_membs.m4 [new file with mode: 0644]
db/schemas/sokwedb/tables/Makefile [new file with mode: 0644]
db/schemas/sokwedb/tables/create/biography.m4 [new file with mode: 0644]
db/schemas/sokwedb/tables/create/comm_memb_log.m4 [new file with mode: 0644]
db/schemas/sokwedb/tables/create/comm_membs.m4 [new file with mode: 0644]
db/schemas/sokwedb/tables/create/sightings.m4 [new file with mode: 0644]
db/schemas/sokwedb/triggers/Makefile [new file with mode: 0644]
db/schemas/sokwedb/triggers/create/biography.m4 [new file with mode: 0644]
db/schemas/sokwedb/triggers/create/biography.synclines [new file with mode: 0644]
db/schemas/sokwedb/triggers/create/comm_membs.m4 [new file with mode: 0644]
db/schemas/sokwedb/triggers/drop/biography.m4 [new file with mode: 0644]
db/schemas/sokwedb/triggers/drop/comm_membs.m4 [new file with mode: 0644]
db/schemas/sokwedb/views/Makefile [new file with mode: 0644]
doc/include/macros.m4
doc/src/epilog.inc.m4
doc/src/tables/biography.m4
doc/src/tables/comm_memb_log.m4
doc/src/tables/comm_membs.m4
include/global_constants.m4
include/limits.m4 [new file with mode: 0644]
make_files/db_doc_header.mk [new file with mode: 0644]
make_files/defaults.mk [new file with mode: 0644]
make_files/make_db.mk [new file with mode: 0644]
make_files/make_docs.mk
make_files/set_search_path.sh [new file with mode: 0755]
make_files/things.mk [new file with mode: 0644]