-- Copyright (C) 2013 The Meme Factory, Inc., http://www.meme.com/
--
-- This file is part of Gombe-MI.
--
-- Gombe-MI is free software; you can redistribute it and/or modify
-- it under the terms of the GNU General Public License as published by
-- the Free Software Foundation; either version 3 of the License, or
-- (at your option) any later version.
--
-- This program is distributed in the hope that it will be useful,
-- but WITHOUT ANY WARRANTY; without even the implied warranty of
-- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
-- GNU General Public License for more details.
--
-- You should have received a copy of the GNU General Public License
-- along with Gombe-MI. If not, see .
--
-- SQL to populate the behaviors table.
--
-- All data appearing in this work are fictitious. Any resemblance to
-- actual data, living or archived, is purely coincidental.
--
-- Karl O. Pinc
--
-- behaviors
INSERT INTO behaviors (behavior
, descr
, swahili
, type
, position
, both_directions
, restricted
, exclusive_behavior
, mom_restricted
, mom_exclusive_behavior
, mom_actor
, mom_actee
, mom_participant
, mom_self
, mom_w_nf_actor
, mom_w_nf_actee
, mom_w_nf_participant
, sib_actor
, sib_actee
, sib_participant
, sib_self
, sib_w_nf_actor
, sib_w_nf_actee
, sib_w_nf_participant
, infant_actor
, infant_actee
, infant_participant
, infant_self
, infant_w_nf_actor
, infant_w_nf_actee
, infant_w_nf_participant
, baboon)
VALUES ('E' -- behavior
, 'Eat' -- descr
, 'Kula' -- swahili
, 'E' -- type
, false -- position
, NULL -- both_directions
, false -- restricted
, true -- exclusive_behavior
, false -- mom_restricted
, true -- mom_exclusive_behavior
, false -- mom_actor
, false -- mom_actee
, false -- mom_participant
, true -- mom_self
, NULL -- mom_w_nf_actor
, NULL -- mom_w_nf_actee
, NULL -- mom_w_nf_participant
, false -- sib_actor
, false -- sib_actee
, false -- sib_participant
, true -- sib_self
, NULL -- sib_w_nf_actor
, NULL -- sib_w_nf_actee
, NULL -- sib_w_nf_participant
, false -- infant_actor
, false -- infant_actee
, false -- infant_participant
, true -- infant_self
, NULL -- infant_w_nf_actor
, NULL -- infant_w_nf_actee
, NULL -- infant_w_nf_participant
, NULL -- baboon
)
, ('F' -- behavior
, 'Fish for insects' -- descr
, 'Kuvua' -- swahili
, 'F' -- type
, false -- position
, NULL -- both_directions
, false -- restricted
, false -- exclusive_behavior
, false -- mom_restricted
, false -- mom_exclusive_behavior
, false -- mom_actor
, false -- mom_actee
, false -- mom_participant
, true -- mom_self
, NULL -- mom_w_nf_actor
, NULL -- mom_w_nf_actee
, NULL -- mom_w_nf_participant
, false -- sib_actor
, false -- sib_actee
, false -- sib_participant
, true -- sib_self
, NULL -- sib_w_nf_actor
, NULL -- sib_w_nf_actee
, NULL -- sib_w_nf_participant
, false -- infant_actor
, false -- infant_actee
, false -- infant_participant
, true -- infant_self
, NULL -- infant_w_nf_actor
, NULL -- infant_w_nf_actee
, NULL -- infant_w_nf_participant
, NULL -- baboon
)
, ('G' -- behavior
, 'Groom' -- descr
, 'Kwatua' -- swahili
, 'O' -- type
, false -- position
, true -- both_directions
, false -- restricted
, true -- exclusive_behavior
, false -- mom_restricted
, true -- mom_exclusive_behavior
, true -- mom_actor
, true -- mom_actee
, false -- mom_participant
, true -- mom_self
, true -- mom_w_nf_actor
, true -- mom_w_nf_actee
, NULL -- mom_w_nf_participant
, true -- sib_actor
, true -- sib_actee
, false -- sib_participant
, false -- sib_self
, true -- sib_w_nf_actor
, true -- sib_w_nf_actee
, NULL -- sib_w_nf_participant
, true -- infant_actor
, true -- infant_actee
, false -- infant_participant
, true -- infant_self
, true -- infant_w_nf_actor
, true -- infant_w_nf_actee
, NULL -- infant_w_nf_participant
, true -- baboon
)
, ('N' -- behavior
, 'Nurse' -- descr
, 'Kunyonya' -- swahili
, 'O' -- type
, false -- position
, false -- both_directions
, false -- restricted
, true -- exclusive_behavior
, false -- mom_restricted
, true -- mom_exclusive_behavior
, false -- mom_actor
, true -- mom_actee
, false -- mom_participant
, false -- mom_self
, false -- mom_w_nf_actor
, NULL -- mom_w_nf_actee
, NULL -- mom_w_nf_participant
, true -- sib_actor
, false -- sib_actee
, false -- sib_participant
, false -- sib_self
, NULL -- sib_w_nf_actor
, false -- sib_w_nf_actee
, NULL -- sib_w_nf_participant
, true -- infant_actor
, false -- infant_actee
, false -- infant_participant
, false -- infant_self
, NULL -- infant_w_nf_actor
, false -- infant_w_nf_actee
, NULL -- infant_w_nf_participant
, NULL -- baboon
)
, ('O' -- behavior
, 'Other' -- descr
, NULL -- swahili
, 'O' -- type
, false -- position
, NULL -- both_directions
, false -- restricted
, false -- exclusive_behavior
, false -- mom_restricted
, false -- mom_exclusive_behavior
, false -- mom_actor
, false -- mom_actee
, false -- mom_participant
, true -- mom_self
, NULL -- mom_w_nf_actor
, NULL -- mom_w_nf_actee
, NULL -- mom_w_nf_participant
, false -- sib_actor
, false -- sib_actee
, false -- sib_participant
, true -- sib_self
, NULL -- sib_w_nf_actor
, NULL -- sib_w_nf_actee
, NULL -- sib_w_nf_participant
, false -- infant_actor
, false -- infant_actee
, false -- infant_participant
, true -- infant_self
, NULL -- infant_w_nf_actor
, NULL -- infant_w_nf_actee
, NULL -- infant_w_nf_participant
, NULL -- baboon
)
,('P' -- behavior
, 'Play' -- descr
, 'Cheza' -- swahili
, 'P' -- type
, false -- position
, false -- both_directions
, false -- restricted
, true -- exclusive_behavior
, false -- mom_restricted
, true -- mom_exclusive_behavior
, true -- mom_actor
, true -- mom_actee
, true -- mom_participant
, true -- mom_self
, false -- mom_w_nf_actor
, false -- mom_w_nf_actee
, true -- mom_w_nf_participant
, false -- sib_actor
, false -- sib_actee
, true -- sib_participant
, true -- sib_self
, NULL -- sib_w_nf_actor
, NULL -- sib_w_nf_actee
, true -- sib_w_nf_participant
, true -- infant_actor
, true -- infant_actee
, true -- infant_participant
, true -- infant_self
, false -- infant_w_nf_actor
, false -- infant_w_nf_actee
, true -- infant_w_nf_participant
, true -- baboon
)
, ('R' -- behavior
, 'Rest' -- descr
, 'Pumzika' -- swahili
, 'T' -- type
, true -- position
, NULL -- both_directions
, true -- restricted
, true -- exclusive_behavior
, true -- mom_restricted
, true -- mom_exclusive_behavior
, false -- mom_actor
, false -- mom_actee
, false -- mom_participant
, true -- mom_self
, NULL -- mom_w_nf_actor
, NULL -- mom_w_nf_actee
, NULL -- mom_w_nf_participant
, false -- sib_actor
, false -- sib_actee
, false -- sib_participant
, true -- sib_self
, NULL -- sib_w_nf_actor
, NULL -- sib_w_nf_actee
, NULL -- sib_w_nf_participant
, false -- infant_actor
, false -- infant_actee
, false -- infant_participant
, true -- infant_self
, NULL -- infant_w_nf_actor
, NULL -- infant_w_nf_actee
, NULL -- infant_w_nf_participant
, NULL -- baboon
)
, ('RI' -- behavior
, 'Ride' -- descr
, 'Beba; bebwa' -- swahili
, 'R' -- type
, false -- position
, false -- both_directions
, false -- restricted
, true -- exclusive_behavior
, false -- mom_restricted
, true -- mom_exclusive_behavior
, false -- mom_actor
, true -- mom_actee
, false -- mom_participant
, false -- mom_self
, false -- mom_w_nf_actor
, NULL -- mom_w_nf_actee
, NULL -- mom_w_nf_participant
, true -- sib_actor
, true -- sib_actee
, false -- sib_participant
, false -- sib_self
, true -- sib_w_nf_actor
, true -- sib_w_nf_actee
, NULL -- sib_w_nf_participant
, true -- infant_actor
, true -- infant_actee
, false -- infant_participant
, false -- infant_self
, true -- infant_w_nf_actor
, true -- infant_w_nf_actee
, NULL -- infant_w_nf_participant
, false -- baboon
)
, ('BE' -- behavior
, 'Begging' -- descr
, 'Omba' -- swahili
, 'O' -- type
, false -- position
, false -- both_directions
, false -- restricted
, false -- exclusive_behavior
, false -- mom_restricted
, false -- mom_exclusive_behavior
, true -- mom_actor
, true -- mom_actee
, false -- mom_participant
, false -- mom_self
, true -- mom_w_nf_actor
, true -- mom_w_nf_actee
, NULL -- mom_w_nf_participant
, false -- sib_actor
, true -- sib_actee
, false -- sib_participant
, false -- sib_self
, false -- sib_w_nf_actor
, NULL -- sib_w_nf_actee
, NULL -- sib_w_nf_participant
, true -- infant_actor
, true -- infant_actee
, false -- infant_participant
, false -- infant_self
, true -- infant_w_nf_actor
, true -- infant_w_nf_actee
, NULL -- infant_w_nf_participant
, true -- baboon
)
, ('V' -- behavior
, 'Vocalization' -- descr
, 'Sauti' -- swahili
, 'V' -- type
, false -- position
, false -- both_directions
, false -- restricted
, false -- exclusive_behavior
, false -- mom_restricted
, false -- mom_exclusive_behavior
, true -- mom_actor
, true -- mom_actee
, true -- mom_participant
, true -- mom_self
, true -- mom_w_nf_actor
, true -- mom_w_nf_actee
, true -- mom_w_nf_participant
, true -- sib_actor
, true -- sib_actee
, true -- sib_participant
, true -- sib_self
, true -- sib_w_nf_actor
, true -- sib_w_nf_actee
, true -- sib_w_nf_participant
, true -- infant_actor
, true -- infant_actee
, true -- infant_participant
, true -- infant_self
, true -- infant_w_nf_actor
, true -- infant_w_nf_actee
, true -- infant_w_nf_participant
, true -- baboon
);