| 2026-06-17 |
Karl O. Pinc... | Fix EVENTS -- remove AtID, Certainty has a code table |
commit | commitdiff | tree | snapshot |
| 2026-06-17 |
Karl O. Pinc... | Make numeric columns italic |
commit | commitdiff | tree | snapshot |
| 2026-06-16 |
Karl O. Pinc... | FOOD_EVENTS.EID is not a primary key |
commit | commitdiff | tree | snapshot |
| 2026-06-16 |
Karl O. Pinc... | Add explanitory text before each detailed warning descr... |
commit | commitdiff | tree | snapshot |
| 2026-06-16 |
Karl O. Pinc... | Remove html pages from website when they no longer... |
commit | commitdiff | tree | snapshot |
| 2026-06-16 |
Karl O. Pinc... | Drop LOCATIONS_B, replace it with LOCATIONS_GPS and... |
commit | commitdiff | tree | snapshot |
| 2026-06-16 |
Karl O. Pinc... | Fix so constants include global constants |
commit | commitdiff | tree | snapshot |
| 2026-06-15 |
Karl O. Pinc... | Add LOCATIONS_MAP and LOCATIONS_GPS to events diagram |
commit | commitdiff | tree | snapshot |
| 2026-06-15 |
Karl O. Pinc... | Move tables on right of page upwards to make free space |
commit | commitdiff | tree | snapshot |
| 2026-06-15 |
Karl O. Pinc... | Note that EVENTS.Certainty sometimes has no meaning |
commit | commitdiff | tree | snapshot |
| 2026-06-15 |
Karl O. Pinc... | Note EVENTS records feeding station arrivals and departures |
commit | commitdiff | tree | snapshot |
| 2026-06-15 |
Karl O. Pinc... | Alphabetize |
commit | commitdiff | tree | snapshot |
| 2026-06-15 |
Karl O. Pinc... | Drop the ATTENDANCE table, use a WATCHES.Type of sdb_at... |
commit | commitdiff | tree | snapshot |
| 2026-06-15 |
Karl O. Pinc... | Index EVENTS on date+focal+type |
commit | commitdiff | tree | snapshot |
| 2026-06-15 |
Karl O. Pinc... | Get rid of commented out code |
commit | commitdiff | tree | snapshot |
| 2026-06-15 |
Karl O. Pinc... | Adjust docs and validation for WATCHES.Type = sdb_follow |
commit | commitdiff | tree | snapshot |
| 2026-06-14 |
Karl O. Pinc... | Fix line length |
commit | commitdiff | tree | snapshot |
| 2026-06-14 |
Karl O. Pinc... | Change from just a update trigger to insert or update |
commit | commitdiff | tree | snapshot |
| 2026-06-12 |
Karl O. Pinc... | Create WATCHES.Type column |
commit | commitdiff | tree | snapshot |
| 2026-06-11 |
Karl O. Pinc... | Change names: FOLLOWS -> WATCHES, FOLLOWS.FID -> WATCHE... |
commit | commitdiff | tree | snapshot |
| 2026-06-11 |
Karl O. Pinc... | Fix FID + Time unique index |
commit | commitdiff | tree | snapshot |
| 2026-06-11 |
Karl O. Pinc... | Fix index names |
commit | commitdiff | tree | snapshot |
| 2026-06-11 |
Karl O. Pinc... | Remove commented out Seq column doc |
commit | commitdiff | tree | snapshot |
| 2026-06-11 |
Karl O. Pinc... | Remove spurious leftover text |
commit | commitdiff | tree | snapshot |
| 2026-06-11 |
Karl O. Pinc... | Change diagram file name: follows.svg -> watches.svg |
commit | commitdiff | tree | snapshot |
| 2026-06-11 |
Karl O. Pinc... | Change FOLLOWS name to WATCHES, and FOLLOWS.FID to... |
commit | commitdiff | tree | snapshot |
| 2026-06-10 |
Stevan Earl | fix: change comm_memb_log trigger guard from insert... |
commit | commitdiff | tree | snapshot |
| 2026-06-09 |
Karl O. Pinc... | Validate PANTGRUNS.EnteredBy against PEOPLE.Active |
commit | commitdiff | tree | snapshot |
| 2026-06-09 |
Karl O. Pinc... | Validate LOCATIONS_B.EnteredBy against PEOPLE.Active |
commit | commitdiff | tree | snapshot |
| 2026-06-09 |
Karl O. Pinc... | Validate GROOMINGS.ExtractedBy against PEOPLE.Active |
commit | commitdiff | tree | snapshot |
| 2026-06-09 |
Karl O. Pinc... | Validate GROOM_SCANS_B.ExtractedBy against PEOPLE.Active |
commit | commitdiff | tree | snapshot |
| 2026-06-09 |
Karl O. Pinc... | Validate COMM_MEMB_LOG.MadeBy against PEOPLE.Active |
commit | commitdiff | tree | snapshot |
| 2026-06-09 |
Karl O. Pinc... | Fire comm_memb_log_trigger after INSERT as well as... |
commit | commitdiff | tree | snapshot |
| 2026-06-09 |
Karl O. Pinc... | Validate BIOGRAPHY_LOG.MadeBy against PEOPLE.Active |
commit | commitdiff | tree | snapshot |
| 2026-06-09 |
Karl O. Pinc... | Fire biography_log_trigger after INSERT as well as... |
commit | commitdiff | tree | snapshot |
| 2026-06-09 |
Karl O. Pinc... | Validate ARRIVALS_A.Recorder and Observer2 against... |
commit | commitdiff | tree | snapshot |
| 2026-06-09 |
Karl O. Pinc... | Validate AGGRESSIONS.ExtractedBy against PEOPLE.Active |
commit | commitdiff | tree | snapshot |
| 2026-06-09 |
Karl O. Pinc... | Remove dead code |
commit | commitdiff | tree | snapshot |
| 2026-06-09 |
Karl O. Pinc... | ARRIVALS_A has no column called DataSource |
commit | commitdiff | tree | snapshot |
| 2026-06-09 |
Karl O. Pinc... | Create, document, index, and trigger PANTGRUNTS |
commit | commitdiff | tree | snapshot |
| 2026-06-09 |
Karl O. Pinc... | Add PANTGRUNTS.Source column |
commit | commitdiff | tree | snapshot |
| 2026-06-09 |
Karl O. Pinc... | Create PG_SOURCES code table |
commit | commitdiff | tree | snapshot |
| 2026-06-09 |
Karl O. Pinc... | Get rid of unneeded key columns |
commit | commitdiff | tree | snapshot |
| 2026-06-09 |
Karl O. Pinc... | Produce a consistent error message |
commit | commitdiff | tree | snapshot |
| 2026-06-09 |
Karl O. Pinc... | Fix hyperlink targets |
commit | commitdiff | tree | snapshot |
| 2026-06-09 |
Karl O. Pinc... | Change Community to CommID on PANTGRUNTS diagram |
commit | commitdiff | tree | snapshot |
| 2026-06-09 |
Karl O. Pinc... | Remove PANTGRUNTS.Mutual column |
commit | commitdiff | tree | snapshot |
| 2026-06-09 |
Karl O. Pinc... | Create, document, index, and trigger LOCATIONS_B |
commit | commitdiff | tree | snapshot |
| 2026-06-09 |
Karl O. Pinc... | Fix so null_xor_null() macro can be used on dispariate... |
commit | commitdiff | tree | snapshot |
| 2026-06-09 |
Karl O. Pinc... | Change function and trigger names to reflect that they... |
commit | commitdiff | tree | snapshot |
| 2026-06-09 |
Karl O. Pinc... | Create LOCATION_ORIGINS support table |
commit | commitdiff | tree | snapshot |
| 2026-06-08 |
Karl O. Pinc... | Fix section underlineing |
commit | commitdiff | tree | snapshot |
| 2026-06-07 |
Karl O. Pinc... | New sdb_null_xor_null() macro, when one colum or anothe... |
commit | commitdiff | tree | snapshot |
| 2026-06-07 |
Karl O. Pinc... | Adjust text to read better when incorporated into a... |
commit | commitdiff | tree | snapshot |
| 2026-06-07 |
Karl O. Pinc... | Fix SWELLING_STATES diagram to reflect db |
commit | commitdiff | tree | snapshot |
| 2026-06-07 |
Karl O. Pinc... | Fix SWELLING_SOURCES diagram to reflect db |
commit | commitdiff | tree | snapshot |
| 2026-06-07 |
Karl O. Pinc... | Fix REPRO_STATES diagram to reflect db |
commit | commitdiff | tree | snapshot |
| 2026-06-07 |
Karl O. Pinc... | Create, document, index, and trigger REPRO_STATES |
commit | commitdiff | tree | snapshot |
| 2026-06-07 |
Karl O. Pinc... | Fix animid_column() macro so column cannot be NULL |
commit | commitdiff | tree | snapshot |
| 2026-06-06 |
Karl O. Pinc... | Use eid_primary_key() macro |
commit | commitdiff | tree | snapshot |
| 2026-06-06 |
Karl O. Pinc... | Correctly invoke animid_column() macro |
commit | commitdiff | tree | snapshot |
| 2026-06-06 |
Karl O. Pinc... | Invoke animid_column() macro with parenthesis |
commit | commitdiff | tree | snapshot |
| 2026-06-06 |
Karl O. Pinc... | Alphabetize by table name |
commit | commitdiff | tree | snapshot |
| 2026-06-06 |
Karl O. Pinc... | Create REPRO_STATE_CHANGE_SOURCES code table |
commit | commitdiff | tree | snapshot |
| 2026-06-06 |
Karl O. Pinc... | Create PARITIES code table |
commit | commitdiff | tree | snapshot |
| 2026-06-06 |
Karl O. Pinc... | Create LE_CERTAINTIES code table |
commit | commitdiff | tree | snapshot |
| 2026-06-06 |
Karl O. Pinc... | Create ED_CERTAINTIES code table |
commit | commitdiff | tree | snapshot |
| 2026-06-06 |
Karl O. Pinc... | Correct copyright date |
commit | commitdiff | tree | snapshot |
| 2026-06-06 |
Karl O. Pinc... | Remove the ARRIVALS_A.ArAID column and use EID as the... |
commit | commitdiff | tree | snapshot |
| 2026-06-05 |
Karl O. Pinc... | Index and trigger SPECIES_PRESENT |
commit | commitdiff | tree | snapshot |
| 2026-06-05 |
Karl O. Pinc... | Fix hyperlinks |
commit | commitdiff | tree | snapshot |
| 2026-06-05 |
Karl O. Pinc... | Remove the SPECIES_PRESENT.OSID column and use EID... |
commit | commitdiff | tree | snapshot |
| 2026-06-05 |
Karl O. Pinc... | EVENTS with Behavior = sdb_other_species cannot be... |
commit | commitdiff | tree | snapshot |
| 2026-06-05 |
Karl O. Pinc... | sdb_other_species events must be "certain" |
commit | commitdiff | tree | snapshot |
| 2026-06-05 |
Karl O. Pinc... | sdb_other_species events must have a related FOLLOWS row |
commit | commitdiff | tree | snapshot |
| 2026-06-05 |
Karl O. Pinc... | Write triggers for HUMANS |
commit | commitdiff | tree | snapshot |
| 2026-06-05 |
Karl O. Pinc... | Document the sdb_other_species event type's validation... |
commit | commitdiff | tree | snapshot |
| 2026-06-05 |
Karl O. Pinc... | Fix hyperlink |
commit | commitdiff | tree | snapshot |
| 2026-06-05 |
Karl O. Pinc... | Remove the HUMANS.HuID column and use EID as the primar... |
commit | commitdiff | tree | snapshot |
| 2026-06-05 |
Karl O. Pinc... | Remove the GROOM_SCANS_B.GsID column and use EID as... |
commit | commitdiff | tree | snapshot |
| 2026-06-05 |
Karl O. Pinc... | Remove GROOMINGS.GrID and use EID as the primary key |
commit | commitdiff | tree | snapshot |
| 2026-06-05 |
Karl O. Pinc... | Remove FOOD_EVENTS.FEID and use EID as the primary key |
commit | commitdiff | tree | snapshot |
| 2026-06-05 |
Karl O. Pinc... | Remove AGGRESSIONS.AgID and use EID as the primary key |
commit | commitdiff | tree | snapshot |
| 2026-06-05 |
Karl O. Pinc... | Add triggers for SWELLING_SOURCES |
commit | commitdiff | tree | snapshot |
| 2026-06-05 |
Karl O. Pinc... | Correct "ATTENDANCE after under study" error message |
commit | commitdiff | tree | snapshot |
| 2026-06-05 |
Karl O. Pinc... | Fix inequality that broke ATTENDANCE under-study check |
commit | commitdiff | tree | snapshot |
| 2026-06-05 |
Karl O. Pinc... | Spelling |
commit | commitdiff | tree | snapshot |
| 2026-06-05 |
Karl O. Pinc... | A shorter and more clear error message |
commit | commitdiff | tree | snapshot |
| 2026-06-05 |
Karl O. Pinc... | Index the swelling sources on SWELLING_STATES |
commit | commitdiff | tree | snapshot |
| 2026-06-05 |
Karl O. Pinc... | New build_arrivals_seq() function, in case the auto... |
commit | commitdiff | tree | snapshot |
| 2026-06-05 |
Karl O. Pinc... | Automatically maintain ARRIVALS.Seq |
commit | commitdiff | tree | snapshot |
| 2026-06-05 |
Karl O. Pinc... | Clarify ARRIVALS.Seq ordering in the docs |
commit | commitdiff | tree | snapshot |
| 2026-06-05 |
Karl O. Pinc... | Require an ARRIVALS row have a related ROLES row |
commit | commitdiff | tree | snapshot |
| 2026-06-05 |
Karl O. Pinc... | Remove ARRIVALS.ArID and use EID as the primary key |
commit | commitdiff | tree | snapshot |
| 2026-06-05 |
Karl O. Pinc... | New table macro eid_primary_key() |
commit | commitdiff | tree | snapshot |
| 2026-06-04 |
Karl O. Pinc... | Fix and use correct key column name |
commit | commitdiff | tree | snapshot |
| 2026-06-04 |
Karl O. Pinc... | Remove accidental leftover graphic elements |
commit | commitdiff | tree | snapshot |
| 2026-06-04 |
Karl O. Pinc... | Simplify because events only fire on update |
commit | commitdiff | tree | snapshot |
| 2026-06-01 |
Karl O. Pinc... | Support groom scanning at the feeding station as an... |
commit | commitdiff | tree | snapshot |
| 2026-06-01 |
Karl O. Pinc... | Create, document, index, and trigger ARRIVALS_A |
commit | commitdiff | tree | snapshot |
| next |
projects / sokwedb / shortlog