| 3 days ago |
Karl O. Pinc... | Adjustments to avoid outstanding conversion issues... pre_adolescent_adjust |
commit | commitdiff | tree | snapshot |
| 4 days ago |
Karl O. Pinc... | Cleanup of problem #31 and #32 taken care of in clean... |
commit | commitdiff | tree | snapshot |
| 4 days ago |
Karl O. Pinc... | Split load_data.sql into multiple files to support... |
commit | commitdiff | tree | snapshot |
| 4 days ago |
Karl O. Pinc... | Standardize error messages in triggers |
commit | commitdiff | tree | snapshot |
| 5 days ago |
Karl O. Pinc | Add ARRIVALS.Seq column to diagram |
commit | commitdiff | tree | snapshot |
| 5 days ago |
Karl O. Pinc... | Initial converson of follow_arrival table |
commit | commitdiff | tree | snapshot |
| 7 days ago |
Karl O. Pinc... | Fix reporting of ROLES.PID in error messages |
commit | commitdiff | tree | snapshot |
| 7 days ago |
Karl O. Pinc... | Fix the ARRIVALS trigger to correct Cycle column name |
commit | commitdiff | tree | snapshot |
| 7 days ago |
Karl O. Pinc... | Fix problems #31 and #32 by trimming spaces and upper... |
commit | commitdiff | tree | snapshot |
| 7 days ago |
Karl O. Pinc... | There can be at most one arrival per event |
commit | commitdiff | tree | snapshot |
| 7 days ago |
Karl O. Pinc... | An ARRIVALS row must be related to an event with Behavi... |
commit | commitdiff | tree | snapshot |
| 7 days ago |
Karl O. Pinc... | Use mixed-case people where possible; conversion proble... |
commit | commitdiff | tree | snapshot |
| 7 days ago |
Karl O. Pinc... | Resolve problem #37 |
commit | commitdiff | tree | snapshot |
| 7 days ago |
Karl O. Pinc... | Note what solves conversion problem #38 |
commit | commitdiff | tree | snapshot |
| 7 days ago |
Karl O. Pinc... | Change so sdb_male_swelling cannot be assigned to females |
commit | commitdiff | tree | snapshot |
| 7 days ago |
Karl O. Pinc... | Mark PEOPLE with "/" in their name inactive; conversion... |
commit | commitdiff | tree | snapshot |
| 7 days ago |
Karl O. Pinc... | Change minimum age of first birth from 8 to 10 years |
commit | commitdiff | tree | snapshot |
| 7 days ago |
Karl O. Pinc... | Validate the use of CYCLE_STATES codes |
commit | commitdiff | tree | snapshot |
| 7 days ago |
Karl O. Pinc... | Prevent ARRIVALS.ArID from changing |
commit | commitdiff | tree | snapshot |
| 7 days ago |
Karl O. Pinc... | Prevent ROLES.Participant from changing |
commit | commitdiff | tree | snapshot |
| 7 days ago |
Karl O. Pinc... | ROLES.Participant must be under study |
commit | commitdiff | tree | snapshot |
| 7 days ago |
Karl O. Pinc... | Prevent EVENTS.FID from changing |
commit | commitdiff | tree | snapshot |
| 7 days ago |
Karl O. Pinc... | Create and document the ARRIVALS table |
commit | commitdiff | tree | snapshot |
| 7 days ago |
Karl O. Pinc... | Add substitution reference for "tri-valued logic" |
commit | commitdiff | tree | snapshot |
| 7 days ago |
Karl O. Pinc... | Enforce single-ROLE row restrction for arrival events |
commit | commitdiff | tree | snapshot |
| 7 days ago |
Karl O. Pinc... | Prevent ROLES.EID from changing |
commit | commitdiff | tree | snapshot |
| 7 days ago |
Karl O. Pinc... | Prevent EVENTS.Behavior from changing |
commit | commitdiff | tree | snapshot |
| 7 days ago |
Karl O. Pinc... | More documentation of EVENTS.Behavior related rules |
commit | commitdiff | tree | snapshot |
| 7 days ago |
Karl O. Pinc... | Implement Start and Stop column constraints on EVENTS |
commit | commitdiff | tree | snapshot |
| 7 days ago |
Karl O. Pinc... | Initial trigger on ROLES, prevent PID change |
commit | commitdiff | tree | snapshot |
| 7 days ago |
Karl O. Pinc... | Initial trigger on EVENTS, prevent EID change |
commit | commitdiff | tree | snapshot |
| 7 days ago |
Karl O. Pinc... | Add ARRIVAL_SOURCES table; codes for arrvial/departure... |
commit | commitdiff | tree | snapshot |
| 7 days ago |
Karl O. Pinc... | Index ROLES |
commit | commitdiff | tree | snapshot |
| 7 days ago |
Karl O. Pinc... | Index EVENTS |
commit | commitdiff | tree | snapshot |
| 7 days ago |
Karl O. Pinc... | Convert FOLLOW_STUDIES |
commit | commitdiff | tree | snapshot |
| 7 days ago |
Karl O. Pinc... | Index FOLLOW_STUDIES |
commit | commitdiff | tree | snapshot |
| 7 days ago |
Karl O. Pinc... | Index FOLLOW_OBSERVERS |
commit | commitdiff | tree | snapshot |
| 7 days ago |
Karl O. Pinc... | Make ROLE_CODES.Role unique when ignoring case |
commit | commitdiff | tree | snapshot |
| 7 days ago |
Karl O. Pinc... | Make PEOPLE.Person unique when ignoring case |
commit | commitdiff | tree | snapshot |
| 7 days ago |
Karl O. Pinc... | Make OBS_PERIODS.Period unique when ignoring case |
commit | commitdiff | tree | snapshot |
| 7 days ago |
Karl O. Pinc... | Make CYCLE_STATES.Code unique when ignoring case |
commit | commitdiff | tree | snapshot |
| 12 days ago |
Karl O. Pinc... | Make COMM_MEMBS_SOURCES.CommMembSource unique when... |
commit | commitdiff | tree | snapshot |
| 12 days ago |
Karl O. Pinc... | Make COMM_IDS.Name unique when ignoring case |
commit | commitdiff | tree | snapshot |
| 12 days ago |
Karl O. Pinc... | Make comm_ids.CommID unique when ignoring case |
commit | commitdiff | tree | snapshot |
| 12 days ago |
Karl O. Pinc... | New substitution reference for case-unique key columns |
commit | commitdiff | tree | snapshot |
| 12 days ago |
Karl O. Pinc... | Use indexmacros.m4 when creating indexes |
commit | commitdiff | tree | snapshot |
| 13 days ago |
Karl O. Pinc... | Add sdb_case_equalivance() macro for use in indexes |
commit | commitdiff | tree | snapshot |
| 13 days ago |
Karl O. Pinc... | Convert follow -> follow_observers |
commit | commitdiff | tree | snapshot |
| 13 days ago |
Karl O. Pinc... | Enforce rule that a follow must have a related FOLLOW_O... |
commit | commitdiff | tree | snapshot |
| 13 days ago |
Karl O. Pinc... | Allow PEOPLE.Person to have embedded spaces |
commit | commitdiff | tree | snapshot |
| 13 days ago |
Karl O. Pinc... | Add creation of a NONE person to the conversion |
commit | commitdiff | tree | snapshot |
| 13 days ago |
Karl O. Pinc... | Add warning when it looks like there's duplicate FOLLOW... |
commit | commitdiff | tree | snapshot |
| 13 days ago |
Karl O. Pinc... | The BIOGRAPHY_LOG.BLID cannot change |
commit | commitdiff | tree | snapshot |
| 13 days ago |
Karl O. Pinc... | The COMM_MEMB_LOG.CommMLID cannot change |
commit | commitdiff | tree | snapshot |
| 2025-10-01 |
Karl O. Pinc... | The COMM_MEMBS.CommMID cannot change |
commit | commitdiff | tree | snapshot |
| 2025-10-01 |
Karl O. Pinc... | The FOLLOW_OBSERVERS.FOID cannot change |
commit | commitdiff | tree | snapshot |
| 2025-10-01 |
Karl O. Pinc... | The FOLLOWS.FID cannot change |
commit | commitdiff | tree | snapshot |
| 2025-10-01 |
Karl O. Pinc... | Convert into the FOLLOWS table |
commit | commitdiff | tree | snapshot |
| 2025-10-01 |
Karl O. Pinc... | Check that a follow happens only when the individual... |
commit | commitdiff | tree | snapshot |
| 2025-10-01 |
Karl O. Pinc... | Index the FOLLOWS table |
commit | commitdiff | tree | snapshot |
| 2025-09-29 |
Karl O. Pinc... | Use constraint allowing empty text for FOLLOWS.Notes |
commit | commitdiff | tree | snapshot |
| 2025-09-22 |
Karl O. Pinc... | Add ROLES table |
commit | commitdiff | tree | snapshot |
| 2025-09-21 |
Karl O. Pinc... | Merge branch 'master' of /srv/repos/kop_sokwedb |
commit | commitdiff | tree | snapshot |
| 2025-09-21 |
Karl O. Pinc | Modify diagram: An EVENTS row need not always have... |
commit | commitdiff | tree | snapshot |
| 2025-09-21 |
Karl O. Pinc... | Add ROLE_CODES table |
commit | commitdiff | tree | snapshot |
| 2025-09-21 |
Karl O. Pinc... | Add CYCLE_STATES table to db |
commit | commitdiff | tree | snapshot |
| 2025-09-21 |
Karl O. Pinc... | Add SPECIES_PRESENT table |
commit | commitdiff | tree | snapshot |
| 2025-09-21 |
Karl O. Pinc... | Enforce PEOPLE.Active on FOLLOW_OBSERVERS |
commit | commitdiff | tree | snapshot |
| 2025-09-21 |
Karl O. Pinc... | New macro for checking that PEOPLE.Active is TRUE befor... |
commit | commitdiff | tree | snapshot |
| 2025-09-21 |
Karl O. Pinc... | Add SPECIES table |
commit | commitdiff | tree | snapshot |
| 2025-09-21 |
Karl O. Pinc... | Add HUMANS table |
commit | commitdiff | tree | snapshot |
| 2025-09-08 |
Karl O. Pinc... | Add nonnegative macros/substitution |
commit | commitdiff | tree | snapshot |
| 2025-09-08 |
Karl O. Pinc... | Initial list of event codes, without hyperlinking to... |
commit | commitdiff | tree | snapshot |
| 2025-09-08 |
Karl O. Pinc... | Support converting MGM, MGF, MGF2, MGF3 |
commit | commitdiff | tree | snapshot |
| 2025-09-08 |
Karl O. Pinc... | Make system aware of MGM, MGF, MGF2, and MGF3 unknown... |
commit | commitdiff | tree | snapshot |
| 2025-09-08 |
Karl O. Pinc... | Add CERTAINTIES table |
commit | commitdiff | tree | snapshot |
| 2025-09-08 |
Karl O. Pinc... | Merge branch 'master' of /srv/repos/kop_sokwedb |
commit | commitdiff | tree | snapshot |
| 2025-09-08 |
Karl O. Pinc | Remove EVENTS.Seq column from diagram |
commit | commitdiff | tree | snapshot |
| 2025-09-08 |
Karl O. Pinc | Change EVENTS.End to EVENTS.Stop in diagrams |
commit | commitdiff | tree | snapshot |
| 2025-09-08 |
Karl O. Pinc... | Add EVENTS table |
commit | commitdiff | tree | snapshot |
| 2025-09-08 |
Karl O. Pinc | Remove EVENTS.Seq column from diagram |
commit | commitdiff | tree | snapshot |
| 2025-09-08 |
Karl O. Pinc | Change EVENTS.End to EVENTS.Stop in diagrams |
commit | commitdiff | tree | snapshot |
| 2025-09-08 |
Karl O. Pinc... | Remove FOLLOW_ARRIVALS table in favor of the EVENTS... |
commit | commitdiff | tree | snapshot |
| 2025-09-08 |
Karl O. Pinc... | Seconds are 0 in times unless otherwise noted |
commit | commitdiff | tree | snapshot |
| 2025-09-07 |
Karl O. Pinc... | Give the unknown individuals a bccertainty and a sex |
commit | commitdiff | tree | snapshot |
| 2025-09-07 |
Karl O. Pinc... | Adjust to allow conversion to take a connection string |
commit | commitdiff | tree | snapshot |
| 2025-09-07 |
Karl O. Pinc... | Add FOLLOW_STUDIES table |
commit | commitdiff | tree | snapshot |
| 2025-09-07 |
Karl O. Pinc... | Add STUDIES code table |
commit | commitdiff | tree | snapshot |
| 2025-09-07 |
Karl O. Pinc... | Add FOLLOW_OBSERVERS table |
commit | commitdiff | tree | snapshot |
| 2025-09-07 |
Karl O. Pinc... | Add OBS_PERIODS code table |
commit | commitdiff | tree | snapshot |
| 2025-06-25 |
Karl O. Pinc | Fix so all :ref:s are removed, and other fixes |
commit | commitdiff | tree | snapshot |
| 2025-04-12 |
Karl O. Pinc... | Use a connection string with PSQL |
commit | commitdiff | tree | snapshot |
| 2025-04-12 |
Karl O. Pinc... | Fully qualify table name |
commit | commitdiff | tree | snapshot |
| 2025-04-12 |
Karl O. Pinc... | COMM_MEMB_LOG.AnimID does not have to reference BIOGRAP... |
commit | commitdiff | tree | snapshot |
| 2025-04-12 |
Karl O. Pinc... | BIOGRAPHY_LOG.AnimID does not have to reference BIOGRAP... |
commit | commitdiff | tree | snapshot |
| 2025-04-12 |
Karl O. Pinc... | New macro for columns named AnimID but are not required... |
commit | commitdiff | tree | snapshot |
| 2025-04-11 |
Karl O. Pinc... | Adjust conversion for tables dropped in the upstream... |
commit | commitdiff | tree | snapshot |
| 2025-04-11 |
Karl O. Pinc... | Add after_* targets for completing the conversion after... |
commit | commitdiff | tree | snapshot |
| 2025-04-10 |
Karl O. Pinc | Make clear that tables are not entities |
commit | commitdiff | tree | snapshot |
| 2025-04-01 |
Karl O. Pinc | GROOMINGS.Certainty -> GROOMINGS.TimeCertainty |
commit | commitdiff | tree | snapshot |
| next |
projects / sokwedb / shortlog