darcs - gombemi

2 --

3 -- This file is part of Gombe-MI.

4 --

5 -- Gombe-MI is free software; you can redistribute it and/or modify

6 -- it under the terms of the GNU General Public License as published by

7 -- the Free Software Foundation; either version 3 of the License, or

8 -- (at your option) any later version.

9 --

10 -- This program is distributed in the hope that it will be useful,

11 -- but WITHOUT ANY WARRANTY; without even the implied warranty of

12 -- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the

13 -- GNU General Public License for more details.

14 --

15 -- You should have received a copy of the GNU General Public License

16 -- along with Gombe-MI. If not, see <http://www.gnu.org/licenses/>.

17 --

18 -- SQL to populate the behaviors table.

19 --

20 -- All data appearing in this work are fictitious. Any resemblance to

21 -- actual data, living or archived, is purely coincidental.

22 --

23 -- Karl O. Pinc <kop@meme.com>

24 --

26 -- behaviors

28 INSERT INTO behaviors (behavior

29 , descr

30 , swahili

31 , type

32 , position

33 , both_directions

34 , restricted

35 , exclusive_behavior

36 , mom_restricted

37 , mom_exclusive_behavior

38 , mom_actor

39 , mom_actee

40 , mom_participant

41 , mom_self

42 , mom_w_nf_actor

43 , mom_w_nf_actee

44 , mom_w_nf_participant

45 , sib_actor

46 , sib_actee

47 , sib_participant

48 , sib_self

49 , sib_w_nf_actor

50 , sib_w_nf_actee

51 , sib_w_nf_participant

52 , infant_actor

53 , infant_actee

54 , infant_participant

55 , infant_self

56 , infant_w_nf_actor

57 , infant_w_nf_actee

58 , infant_w_nf_participant

59 , baboon)

60 VALUES ('E' -- behavior

61 , 'Eat' -- descr

62 , 'Kula' -- swahili

63 , 'E' -- type

64 , false -- position

65 , NULL -- both_directions

66 , false -- restricted

67 , true -- exclusive_behavior

68 , false -- mom_restricted

69 , true -- mom_exclusive_behavior

70 , false -- mom_actor

71 , false -- mom_actee

72 , false -- mom_participant

73 , true -- mom_self

74 , NULL -- mom_w_nf_actor

75 , NULL -- mom_w_nf_actee

76 , NULL -- mom_w_nf_participant

77 , false -- sib_actor

78 , false -- sib_actee

79 , false -- sib_participant

80 , true -- sib_self

81 , NULL -- sib_w_nf_actor

82 , NULL -- sib_w_nf_actee

83 , NULL -- sib_w_nf_participant

84 , false -- infant_actor

85 , false -- infant_actee

86 , false -- infant_participant

87 , true -- infant_self

88 , NULL -- infant_w_nf_actor

89 , NULL -- infant_w_nf_actee

90 , NULL -- infant_w_nf_participant

91 , NULL -- baboon

92 )

93 , ('F' -- behavior

94 , 'Fish for insects' -- descr

95 , 'Kuvua' -- swahili

96 , 'F' -- type

97 , false -- position

98 , NULL -- both_directions

99 , false -- restricted

100 , false -- exclusive_behavior

101 , false -- mom_restricted

102 , false -- mom_exclusive_behavior

103 , false -- mom_actor

104 , false -- mom_actee

105 , false -- mom_participant

106 , true -- mom_self

107 , NULL -- mom_w_nf_actor

108 , NULL -- mom_w_nf_actee

109 , NULL -- mom_w_nf_participant

110 , false -- sib_actor

111 , false -- sib_actee

112 , false -- sib_participant

113 , true -- sib_self

114 , NULL -- sib_w_nf_actor

115 , NULL -- sib_w_nf_actee

116 , NULL -- sib_w_nf_participant

117 , false -- infant_actor

118 , false -- infant_actee

119 , false -- infant_participant

120 , true -- infant_self

121 , NULL -- infant_w_nf_actor

122 , NULL -- infant_w_nf_actee

123 , NULL -- infant_w_nf_participant

124 , NULL -- baboon

125 )

126 , ('G' -- behavior

127 , 'Groom' -- descr

128 , 'Kwatua' -- swahili

129 , 'O' -- type

130 , false -- position

131 , true -- both_directions

132 , false -- restricted

133 , true -- exclusive_behavior

134 , false -- mom_restricted

135 , true -- mom_exclusive_behavior

136 , true -- mom_actor

137 , true -- mom_actee

138 , false -- mom_participant

139 , true -- mom_self

140 , true -- mom_w_nf_actor

141 , true -- mom_w_nf_actee

142 , NULL -- mom_w_nf_participant

143 , true -- sib_actor

144 , true -- sib_actee

145 , false -- sib_participant

146 , false -- sib_self

147 , true -- sib_w_nf_actor

148 , true -- sib_w_nf_actee

149 , NULL -- sib_w_nf_participant

150 , true -- infant_actor

151 , true -- infant_actee

152 , false -- infant_participant

153 , true -- infant_self

154 , true -- infant_w_nf_actor

155 , true -- infant_w_nf_actee

156 , NULL -- infant_w_nf_participant

157 , true -- baboon

158 )

159 , ('N' -- behavior

160 , 'Nurse' -- descr

161 , 'Kunyonya' -- swahili

162 , 'O' -- type

163 , false -- position

164 , false -- both_directions

165 , false -- restricted

166 , true -- exclusive_behavior

167 , false -- mom_restricted

168 , true -- mom_exclusive_behavior

169 , false -- mom_actor

170 , true -- mom_actee

171 , false -- mom_participant

172 , false -- mom_self

173 , false -- mom_w_nf_actor

174 , NULL -- mom_w_nf_actee

175 , NULL -- mom_w_nf_participant

176 , true -- sib_actor

177 , false -- sib_actee

178 , false -- sib_participant

179 , false -- sib_self

180 , NULL -- sib_w_nf_actor

181 , false -- sib_w_nf_actee

182 , NULL -- sib_w_nf_participant

183 , true -- infant_actor

184 , false -- infant_actee

185 , false -- infant_participant

186 , false -- infant_self

187 , NULL -- infant_w_nf_actor

188 , false -- infant_w_nf_actee

189 , NULL -- infant_w_nf_participant

190 , NULL -- baboon

191 )

192 , ('O' -- behavior

193 , 'Other' -- descr

194 , NULL -- swahili

195 , 'O' -- type

196 , false -- position

197 , NULL -- both_directions

198 , false -- restricted

199 , false -- exclusive_behavior

200 , false -- mom_restricted

201 , false -- mom_exclusive_behavior

202 , false -- mom_actor

203 , false -- mom_actee

204 , false -- mom_participant

205 , true -- mom_self

206 , NULL -- mom_w_nf_actor

207 , NULL -- mom_w_nf_actee

208 , NULL -- mom_w_nf_participant

209 , false -- sib_actor

210 , false -- sib_actee

211 , false -- sib_participant

212 , true -- sib_self

213 , NULL -- sib_w_nf_actor

214 , NULL -- sib_w_nf_actee

215 , NULL -- sib_w_nf_participant

216 , false -- infant_actor

217 , false -- infant_actee

218 , false -- infant_participant

219 , true -- infant_self

220 , NULL -- infant_w_nf_actor

221 , NULL -- infant_w_nf_actee

222 , NULL -- infant_w_nf_participant

223 , NULL -- baboon

224 )

225 ,('P' -- behavior

226 , 'Play' -- descr

227 , 'Cheza' -- swahili

228 , 'P' -- type

229 , false -- position

230 , false -- both_directions

231 , false -- restricted

232 , true -- exclusive_behavior

233 , false -- mom_restricted

234 , true -- mom_exclusive_behavior

235 , true -- mom_actor

236 , true -- mom_actee

237 , true -- mom_participant

238 , true -- mom_self

239 , false -- mom_w_nf_actor

240 , false -- mom_w_nf_actee

241 , true -- mom_w_nf_participant

242 , false -- sib_actor

243 , false -- sib_actee

244 , true -- sib_participant

245 , true -- sib_self

246 , NULL -- sib_w_nf_actor

247 , NULL -- sib_w_nf_actee

248 , true -- sib_w_nf_participant

249 , true -- infant_actor

250 , true -- infant_actee

251 , true -- infant_participant

252 , true -- infant_self

253 , false -- infant_w_nf_actor

254 , false -- infant_w_nf_actee

255 , true -- infant_w_nf_participant

256 , true -- baboon

257 )

258 , ('R' -- behavior

259 , 'Rest' -- descr

260 , 'Pumzika' -- swahili

261 , 'T' -- type

262 , true -- position

263 , NULL -- both_directions

264 , true -- restricted

265 , true -- exclusive_behavior

266 , true -- mom_restricted

267 , true -- mom_exclusive_behavior

268 , false -- mom_actor

269 , false -- mom_actee

270 , false -- mom_participant

271 , true -- mom_self

272 , NULL -- mom_w_nf_actor

273 , NULL -- mom_w_nf_actee

274 , NULL -- mom_w_nf_participant

275 , false -- sib_actor

276 , false -- sib_actee

277 , false -- sib_participant

278 , true -- sib_self

279 , NULL -- sib_w_nf_actor

280 , NULL -- sib_w_nf_actee

281 , NULL -- sib_w_nf_participant

282 , false -- infant_actor

283 , false -- infant_actee

284 , false -- infant_participant

285 , true -- infant_self

286 , NULL -- infant_w_nf_actor

287 , NULL -- infant_w_nf_actee

288 , NULL -- infant_w_nf_participant

289 , NULL -- baboon

290 )

291 , ('RI' -- behavior

292 , 'Ride' -- descr

293 , 'Beba; bebwa' -- swahili

294 , 'R' -- type

295 , false -- position

296 , false -- both_directions

297 , false -- restricted

298 , true -- exclusive_behavior

299 , false -- mom_restricted

300 , true -- mom_exclusive_behavior

301 , false -- mom_actor

302 , true -- mom_actee

303 , false -- mom_participant

304 , false -- mom_self

305 , false -- mom_w_nf_actor

306 , NULL -- mom_w_nf_actee

307 , NULL -- mom_w_nf_participant

308 , true -- sib_actor

309 , true -- sib_actee

310 , false -- sib_participant

311 , false -- sib_self

312 , true -- sib_w_nf_actor

313 , true -- sib_w_nf_actee

314 , NULL -- sib_w_nf_participant

315 , true -- infant_actor

316 , true -- infant_actee

317 , false -- infant_participant

318 , false -- infant_self

319 , true -- infant_w_nf_actor

320 , true -- infant_w_nf_actee

321 , NULL -- infant_w_nf_participant

322 , false -- baboon

323 )

324 , ('BE' -- behavior

325 , 'Begging' -- descr

326 , 'Omba' -- swahili

327 , 'O' -- type

328 , false -- position

329 , false -- both_directions

330 , false -- restricted

331 , false -- exclusive_behavior

332 , false -- mom_restricted

333 , false -- mom_exclusive_behavior

334 , true -- mom_actor

335 , true -- mom_actee

336 , false -- mom_participant

337 , false -- mom_self

338 , true -- mom_w_nf_actor

339 , true -- mom_w_nf_actee

340 , NULL -- mom_w_nf_participant

341 , false -- sib_actor

342 , true -- sib_actee

343 , false -- sib_participant

344 , false -- sib_self

345 , false -- sib_w_nf_actor

346 , NULL -- sib_w_nf_actee

347 , NULL -- sib_w_nf_participant

348 , true -- infant_actor

349 , true -- infant_actee

350 , false -- infant_participant

351 , false -- infant_self

352 , true -- infant_w_nf_actor

353 , true -- infant_w_nf_actee

354 , NULL -- infant_w_nf_participant

355 , true -- baboon

356 )

357 , ('V' -- behavior

358 , 'Vocalization' -- descr

359 , 'Sauti' -- swahili

360 , 'V' -- type

361 , false -- position

362 , false -- both_directions

363 , false -- restricted

364 , false -- exclusive_behavior

365 , false -- mom_restricted

366 , false -- mom_exclusive_behavior

367 , true -- mom_actor

368 , true -- mom_actee

369 , true -- mom_participant

370 , true -- mom_self

371 , true -- mom_w_nf_actor

372 , true -- mom_w_nf_actee

373 , true -- mom_w_nf_participant

374 , true -- sib_actor

375 , true -- sib_actee

376 , true -- sib_participant

377 , true -- sib_self

378 , true -- sib_w_nf_actor

379 , true -- sib_w_nf_actee

380 , true -- sib_w_nf_participant

381 , true -- infant_actor

382 , true -- infant_actee

383 , true -- infant_participant

384 , true -- infant_self

385 , true -- infant_w_nf_actor

386 , true -- infant_w_nf_actee

387 , true -- infant_w_nf_participant

388 , true -- baboon

389 );

390

391