sokwedb
2025-01-21 Karl O. PincUse a UTF-8 encoding for the db, with C collation
2025-01-06 Karl O. PincBetter describe timestamp put on doc pages
2025-01-06 Karl O. PincFix indentation of Makefile's in-line docs
2025-01-06 Karl O. PincDelete files generated by cluster code when cleaning
2025-01-04 Karl O. PincProperly clean the generated dropviews.sql file
2025-01-04 Karl O. PincFix to drop all biography_data indexes
2025-01-04 Karl O. PincProperly clean when DROP_EXISTING is used
2025-01-04 Karl O. PincCorrect description
2025-01-04 Karl O. PincFix cleanup of generated scripts
2024-11-25 Karl O. PincFOLLOW_ARRIVALS.Start and End can overlap under some...
2024-11-25 Karl O. PincFix spelling
2024-11-25 Karl O. PincFix diagram: FOLLOW_ARRIVALS.FID links to FOLLOWS.FID
2024-11-06 Karl O. PincChange name of code table, ESTROUS_STATES to CODE_STATES
2024-11-06 Karl O. PincNiether mothers nor fathers are required
2024-10-30 Karl O. PincSeparate metric and unit constants for adolescent age
2024-10-30 Karl O. PincMove demography related constants into limits.m4 file
2024-10-30 Karl O. PincAdd textual documentation of follows related tables
2024-10-30 Karl O. PincFix lables for hyperlinks; normalize the line breaks
2024-10-30 Karl O. PincFOLLOWS must have a related FOLLOW_OBSERVERS row
2024-10-30 Karl O. PincAdd PEOPLE.Name and PEOPLE.Description RST substitutions
2024-10-30 Karl O. PincAdd follows ER diagram
2024-10-28 Karl O. PincUse substitution instead of :ref:
2024-10-28 Karl O. PincStart sentences on a new line for diff readability
2024-10-28 Karl O. PincNote that diagrams use inkscape as their source file...
2024-03-01 Stevanfix biography.animidnum description
2024-02-15 Karl O. Pinc... Mark the UNK, unknown person, inactive to prevent futur...
2024-02-15 Karl O. Pinc... Add KL and KL_KK codes to COMM_IDS
2024-02-15 Karl O. Pinc... Use "UNK" unknown person when person is null
2024-02-02 Karl O. Pinc... Adjust conversion for new COMM_MEMBS_SOURCES table
2024-02-02 Karl O. PincAdd COMM_MEMBS_SOURCES table
2024-01-31 Karl O. PincCache db content install per database
2024-01-31 Karl O. Pinc... Adjust conversion to load BIOGRAPHY_DATA instead of...
2024-01-31 Karl O. PincCreate BIOGRAPHY view
2024-01-31 Karl O. PincAdd _error_immutable_view function to support un-update...
2024-01-31 Karl O. PincNote how the table listing a view's columns should...
2024-01-31 Karl O. PincAdd DROP_EXISTING variable to for when there's no ...
2024-01-31 Karl O. PincFix so "make check" works after recreate-db target
2024-01-31 Karl O. PincAdd caution that remaking triggers or views drop triggers
2024-01-31 Karl O. PincChange name of view dir to avoid name conflict with...
2024-01-31 Karl O. PincUse consistent variable naming conventions
2024-01-31 Karl O. PincRaise an exception if we don't find the view code
2024-01-31 Karl O. PincAutomatically generate statements to drop views
2024-01-30 Karl O. PincRequire that the CREATE VIEW explicitly list column...
2024-01-30 Karl O. PincAutomatically generate statements to drop views
2024-01-30 Karl O. PincFix (typos in) review target
2024-01-29 Karl O. PincChange BIOGRAPHY table name to BIOGRAPHY_DATA
2024-01-29 Karl O. PincReflect change of lookup schema to "codes" in conversio...
2024-01-29 Karl O. PincChange the name of the lookup schema to "codes"
2024-01-29 Karl O. PincImprove code formatting
2024-01-29 Karl O. PincCleanup after moving triggers into db/schemas/lib/
2024-01-29 Karl O. PincFix and imprprove error message
2024-01-29 Karl O. PincImprove docs on clean targets
2024-01-29 Karl O. PincAdd clean-commands target for scripts
2024-01-24 Karl O. Pinc... default_transaction_deferrable=on, backslash_quote=off
2024-01-24 Karl O. Pinc... The php-fpm interpreter is not deprecated
2024-01-24 Karl O. Pinc... Convert BIOGRAPHY_LOG
2024-01-24 Karl O. Pinc... Clean up "biography_update_log.made by" column to remov...
2024-01-24 Karl O. Pinc... Make a PEOPLE table in the "clean" schema to support...
2024-01-24 Karl O. Pinc... Index biography_log and comm_memb_log
2024-01-24 Karl O. Pinc... Add LIMIT to SELECT INTO, and ORDER BY for consistant...
2024-01-24 Karl O. Pinc... Fix AnimID column docs, must not be null, plus other...
2024-01-24 Karl O. Pinc... Create BIOGRAPHY_LOG and update docs with actual constr...
2024-01-24 Karl O. Pinc... Document BIOGRAPHY_LOG
2024-01-24 Karl O. Pinc... Remove empty trailing line
2024-01-24 Karl O. Pinc... Move DadID, DadIDPub, and DadPrelim relationships into...
2024-01-24 Karl O. Pinc... Mention both column names in the iff NULL docs
2024-01-24 Karl O. Pinc... Note what the special quotes are
2024-01-24 Karl O. Pinc... Add BIOGRAPHY.DadPrelim substitution refrence
2024-01-19 Karl O. PincIn diagram, change name BIOGRAPHY->BIOGRAPHY_DATA and...
2024-01-19 Karl O. Pinc... Reduce the HTML sidebar table of contents level to 2
2024-01-19 Karl O. PincBetter docs for DATA_FILE conversion variable
2024-01-19 Karl O. PincRemove more code which worked around invalid primary...
2024-01-19 Karl O. Pinc... New limits ("final" for the ones that exist now) based...
2024-01-19 Karl O. Pinc... Update based on initial data conversion
2024-01-19 Karl O. Pinc... Enforce rule that EntryDate <= DepartDate
2024-01-19 Karl O. Pinc... Align community code max length with that of the code...
2024-01-19 Karl O. Pinc... Testing for contiguous membership requires membership...
2024-01-19 Karl O. Pinc... Fix syntax error
2024-01-19 Karl O. Pinc... Load DadIDPrelim; adjust DadID and DadIDPub accordingly
2024-01-19 Karl O. Pinc... Remove trailing newlines from file
2024-01-19 Karl O. Pinc... Do not limit AnimID length, to match BIOGRAPHY
2024-01-19 Karl O. Pinc... Add missing FROM clauses
2024-01-19 Karl O. Pinc... Fix minimum age of parent at time of birth calculation
2024-01-18 Karl O. Pinc... Cleanup data required to tidy data types, fixes problem #10
2024-01-18 Karl O. Pinc... Improve description of file
2024-01-18 Karl O. Pinc... These cleanups were done in the upstream data
2024-01-18 Karl O. Pinc... Explain why permissions are set only on raw
2024-01-18 Karl O. Pinc... Have BIOGRAPHY.DadIDPub follow the same NULL rules...
2024-01-18 Karl O. Pinc... Add BIOGRAPHY.DadID_Prelim column
2024-01-18 Karl O. Pinc... New macro for if and only if NULL values
2024-01-18 Karl O. Pinc... Better BIOGRAPHY.DadID description
2024-01-18 Karl O. Pinc... Note where BIOGRAPHY.AnimIDs come from
2024-01-18 Karl O. Pinc... Reword the standard "empty text" phrasings
2024-01-17 Karl O. Pinc... Revert all code that changes the FOLLOW_MAP_TIME DDL...
2024-01-17 Karl O. Pinc... Do not change the FOLLOW_MAP_TIME DDL statement at all
2024-01-17 Karl O. Pinc... Properly pick up variables from the environment
2024-01-17 Karl O. Pinc... Improve docs for create-schema target
2023-11-30 Karl O. PincProgress towards moving demography data into a producti...
2023-11-30 Karl O. PincFix max lifespan constraint
2023-11-30 Karl O. PincChange BIOGRAPHY.AnimIDNum to allow NULL, and fix const...
next