projects
/
sokwedb
/ shortlog
commit
grep
author
committer
pickaxe
?
search:
re
summary
| shortlog |
log
|
commit
|
commitdiff
|
tree
first ⋅ prev ⋅
next
sokwedb
2025-11-10
Karl O. Pinc...
Remove redundant arrivals warnings
commit
|
commitdiff
|
tree
|
snapshot
2025-11-10
Karl O. Pinc...
Add CYCLE_STATES.AsNum column
commit
|
commitdiff
|
tree
|
snapshot
2025-11-10
Karl O. Pinc...
Add a "double precision" replacement text
commit
|
commitdiff
|
tree
|
snapshot
2025-11-01
Karl O. Pinc...
Put a TOC in each table's docs above the column docs
commit
|
commitdiff
|
tree
|
snapshot
2025-11-01
Karl O. Pinc...
Actually use the FOLLOW_STUDIES summary in the docs
commit
|
commitdiff
|
tree
|
snapshot
2025-11-01
Karl O. Pinc...
Add verbage describing code tables; move TOC to below...
commit
|
commitdiff
|
tree
|
snapshot
2025-11-01
Karl O. Pinc...
Document ARRIVALS.Seq
commit
|
commitdiff
|
tree
|
snapshot
2025-11-01
Karl O. Pinc...
Add warnings regarding strange ARRIVALS rows
commit
|
commitdiff
|
tree
|
snapshot
2025-11-01
Karl O. Pinc...
Fix markup
commit
|
commitdiff
|
tree
|
snapshot
2025-10-27
Karl O. Pinc...
Remove trailing spaces from follow_arrival.fa_fol_b_foc...
commit
|
commitdiff
|
tree
|
snapshot
2025-10-24
Karl O. Pinc...
Fix lateral joins
commit
|
commitdiff
|
tree
|
snapshot
2025-10-24
Karl O. Pinc...
Update nesting state in clean during conversion; Proble...
commit
|
commitdiff
|
tree
|
snapshot
2025-10-24
Karl O. Pinc...
Updated community membership rules
commit
|
commitdiff
|
tree
|
snapshot
2025-10-24
Karl O. Pinc...
Adjust conversion for BIOGRAPHY_DATA.DadPrelim -> DadSt...
commit
|
commitdiff
|
tree
|
snapshot
2025-10-24
Karl O. Pinc...
Change BIOGRAPHY_DATA.DadPrelim to DadStatus, update...
commit
|
commitdiff
|
tree
|
snapshot
2025-10-24
Karl O. Pinc...
Create and document the DAD_STATUSES support table
commit
|
commitdiff
|
tree
|
snapshot
2025-10-24
Karl O. Pinc...
Solve conversion problem #51, codes in db are ok to use
commit
|
commitdiff
|
tree
|
snapshot
2025-10-24
Karl O. Pinc...
Solve conversion problem #50; females with n/a cycle...
commit
|
commitdiff
|
tree
|
snapshot
2025-10-23
Stevan Earl
docs(schema): clarify that biography_log.dateofudpate...
commit
|
commitdiff
|
tree
|
snapshot
2025-10-23
Stevan Earl
docs(erd): show nullability and quoted identifiers...
commit
|
commitdiff
|
tree
|
snapshot
2025-10-15
Karl O. Pinc...
Cannot be too old or too young when the cycle code...
commit
|
commitdiff
|
tree
|
snapshot
2025-10-13
Karl O. Pinc...
Support converting a single table using multiple, seria...
commit
|
commitdiff
|
tree
|
snapshot
2025-10-12
Karl O. Pinc...
Add additional conditions to avoid unnecessary queries...
commit
|
commitdiff
|
tree
|
snapshot
2025-10-12
Karl O. Pinc...
Fix code comments describing too-early birth
commit
|
commitdiff
|
tree
|
snapshot
2025-10-12
Karl O. Pinc...
Fix maximum female adolescent swelling (sdb_adolsecent_...
commit
|
commitdiff
|
tree
|
snapshot
2025-10-12
Karl O. Pinc...
Fix test for minimum adolescent U swelling code
commit
|
commitdiff
|
tree
|
snapshot
2025-10-12
Karl O. Pinc...
Adjust female adolescent age limits
commit
|
commitdiff
|
tree
|
snapshot
2025-10-11
Karl O. Pinc...
Cleanup of problem #31 and #32 taken care of in clean...
commit
|
commitdiff
|
tree
|
snapshot
2025-10-11
Karl O. Pinc...
Split load_data.sql into multiple files to support...
commit
|
commitdiff
|
tree
|
snapshot
2025-10-11
Karl O. Pinc...
Standardize error messages in triggers
commit
|
commitdiff
|
tree
|
snapshot
2025-10-10
Karl O. Pinc
Add ARRIVALS.Seq column to diagram
commit
|
commitdiff
|
tree
|
snapshot
2025-10-10
Karl O. Pinc...
Initial converson of follow_arrival table
commit
|
commitdiff
|
tree
|
snapshot
2025-10-09
Karl O. Pinc...
Fix reporting of ROLES.PID in error messages
commit
|
commitdiff
|
tree
|
snapshot
2025-10-09
Karl O. Pinc...
Fix the ARRIVALS trigger to correct Cycle column name
commit
|
commitdiff
|
tree
|
snapshot
2025-10-09
Karl O. Pinc...
Fix problems #31 and #32 by trimming spaces and upper...
commit
|
commitdiff
|
tree
|
snapshot
2025-10-09
Karl O. Pinc...
There can be at most one arrival per event
commit
|
commitdiff
|
tree
|
snapshot
2025-10-09
Karl O. Pinc...
An ARRIVALS row must be related to an event with Behavi...
commit
|
commitdiff
|
tree
|
snapshot
2025-10-09
Karl O. Pinc...
Use mixed-case people where possible; conversion proble...
commit
|
commitdiff
|
tree
|
snapshot
2025-10-09
Karl O. Pinc...
Resolve problem #37
commit
|
commitdiff
|
tree
|
snapshot
2025-10-09
Karl O. Pinc...
Note what solves conversion problem #38
commit
|
commitdiff
|
tree
|
snapshot
2025-10-09
Karl O. Pinc...
Change so sdb_male_swelling cannot be assigned to females
commit
|
commitdiff
|
tree
|
snapshot
2025-10-08
Karl O. Pinc...
Mark PEOPLE with "/" in their name inactive; conversion...
commit
|
commitdiff
|
tree
|
snapshot
2025-10-08
Karl O. Pinc...
Change minimum age of first birth from 8 to 10 years
commit
|
commitdiff
|
tree
|
snapshot
2025-10-08
Karl O. Pinc...
Validate the use of CYCLE_STATES codes
commit
|
commitdiff
|
tree
|
snapshot
2025-10-08
Karl O. Pinc...
Prevent ARRIVALS.ArID from changing
commit
|
commitdiff
|
tree
|
snapshot
2025-10-08
Karl O. Pinc...
Prevent ROLES.Participant from changing
commit
|
commitdiff
|
tree
|
snapshot
2025-10-08
Karl O. Pinc...
ROLES.Participant must be under study
commit
|
commitdiff
|
tree
|
snapshot
2025-10-08
Karl O. Pinc...
Prevent EVENTS.FID from changing
commit
|
commitdiff
|
tree
|
snapshot
2025-10-08
Karl O. Pinc...
Create and document the ARRIVALS table
commit
|
commitdiff
|
tree
|
snapshot
2025-10-08
Karl O. Pinc...
Add substitution reference for "tri-valued logic"
commit
|
commitdiff
|
tree
|
snapshot
2025-10-08
Karl O. Pinc...
Enforce single-ROLE row restrction for arrival events
commit
|
commitdiff
|
tree
|
snapshot
2025-10-08
Karl O. Pinc...
Prevent ROLES.EID from changing
commit
|
commitdiff
|
tree
|
snapshot
2025-10-08
Karl O. Pinc...
Prevent EVENTS.Behavior from changing
commit
|
commitdiff
|
tree
|
snapshot
2025-10-08
Karl O. Pinc...
More documentation of EVENTS.Behavior related rules
commit
|
commitdiff
|
tree
|
snapshot
2025-10-08
Karl O. Pinc...
Implement Start and Stop column constraints on EVENTS
commit
|
commitdiff
|
tree
|
snapshot
2025-10-08
Karl O. Pinc...
Initial trigger on ROLES, prevent PID change
commit
|
commitdiff
|
tree
|
snapshot
2025-10-08
Karl O. Pinc...
Initial trigger on EVENTS, prevent EID change
commit
|
commitdiff
|
tree
|
snapshot
2025-10-08
Karl O. Pinc...
Add ARRIVAL_SOURCES table; codes for arrvial/departure...
commit
|
commitdiff
|
tree
|
snapshot
2025-10-08
Karl O. Pinc...
Index ROLES
commit
|
commitdiff
|
tree
|
snapshot
2025-10-08
Karl O. Pinc...
Index EVENTS
commit
|
commitdiff
|
tree
|
snapshot
2025-10-08
Karl O. Pinc...
Convert FOLLOW_STUDIES
commit
|
commitdiff
|
tree
|
snapshot
2025-10-08
Karl O. Pinc...
Index FOLLOW_STUDIES
commit
|
commitdiff
|
tree
|
snapshot
2025-10-08
Karl O. Pinc...
Index FOLLOW_OBSERVERS
commit
|
commitdiff
|
tree
|
snapshot
2025-10-08
Karl O. Pinc...
Make ROLE_CODES.Role unique when ignoring case
commit
|
commitdiff
|
tree
|
snapshot
2025-10-08
Karl O. Pinc...
Make PEOPLE.Person unique when ignoring case
commit
|
commitdiff
|
tree
|
snapshot
2025-10-08
Karl O. Pinc...
Make OBS_PERIODS.Period unique when ignoring case
commit
|
commitdiff
|
tree
|
snapshot
2025-10-08
Karl O. Pinc...
Make CYCLE_STATES.Code unique when ignoring case
commit
|
commitdiff
|
tree
|
snapshot
2025-10-03
Karl O. Pinc...
Make COMM_MEMBS_SOURCES.CommMembSource unique when...
commit
|
commitdiff
|
tree
|
snapshot
2025-10-03
Karl O. Pinc...
Make COMM_IDS.Name unique when ignoring case
commit
|
commitdiff
|
tree
|
snapshot
2025-10-03
Karl O. Pinc...
Make comm_ids.CommID unique when ignoring case
commit
|
commitdiff
|
tree
|
snapshot
2025-10-03
Karl O. Pinc...
New substitution reference for case-unique key columns
commit
|
commitdiff
|
tree
|
snapshot
2025-10-03
Karl O. Pinc...
Use indexmacros.m4 when creating indexes
commit
|
commitdiff
|
tree
|
snapshot
2025-10-02
Karl O. Pinc...
Add sdb_case_equalivance() macro for use in indexes
commit
|
commitdiff
|
tree
|
snapshot
2025-10-02
Karl O. Pinc...
Convert follow -> follow_observers
commit
|
commitdiff
|
tree
|
snapshot
2025-10-02
Karl O. Pinc...
Enforce rule that a follow must have a related FOLLOW_O...
commit
|
commitdiff
|
tree
|
snapshot
2025-10-02
Karl O. Pinc...
Allow PEOPLE.Person to have embedded spaces
commit
|
commitdiff
|
tree
|
snapshot
2025-10-02
Karl O. Pinc...
Add creation of a NONE person to the conversion
commit
|
commitdiff
|
tree
|
snapshot
2025-10-02
Karl O. Pinc...
Add warning when it looks like there's duplicate FOLLOW...
commit
|
commitdiff
|
tree
|
snapshot
2025-10-02
Karl O. Pinc...
The BIOGRAPHY_LOG.BLID cannot change
commit
|
commitdiff
|
tree
|
snapshot
2025-10-02
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
next