[Catalyst] Newbie DB Schema/Moose Problem
Scott Simpson2
scott at simpzoid.com
Fri Mar 16 13:57:39 GMT 2012
SGksCsKgCkkgYW0gdHJ5aW5nIHRvIGRldmVsb3AgbXkgb3duIGFwcGxpY2F0aW9uIGJhc2VkIG9u
IHRoZSB0dXRvcmlhbAooQ2F0YWx5c3Q6Ok1hbnVhbDo6VHV0b3JpYWw6OjAzX01vcmVDYXRhbHlz
dEJhc2ljcykuIEkgaGF2ZSBjcmVhdGVkIGEgbXlzcWwKZGF0YWJhc2UgYW5kIHJ1bjoKwqAKc2Ny
aXB0L2Vhc3lhY19jcmVhdGUucGwgbW9kZWwgREIgREJJQzo6U2NoZW1hIEVhc3lBQzo6U2NoZW1h
IGNyZWF0ZT1zdGF0aWMKZGJpOm15c3FsOmFlOmxvY2FsaG9zdCB1c2VyIHBhc3N3b3JkCsKgCmZy
b20gd2hpY2ggSSBnZXQgdGhlIGZvbGxvd2luZyBpbiwgRWFzeUFDXGxpYlxFYXN5QUNcU2NoZW1h
XFJlc3VsdFxUU2l0ZS5wbQrCoAp1c2UgdXRmODsKcGFja2FnZSBlYXN5YWM6OnNjaGVtYTo6cmVz
dWx0Ojp0c2l0ZTsKIyBjcmVhdGVkIGJ5IGRiaXg6OmNsYXNzOjpzY2hlbWE6OmxvYWRlcgojIGRv
IG5vdCBtb2RpZnkgdGhlIGZpcnN0IHBhcnQgb2YgdGhpcyBmaWxlCj1oZWFkMSBuYW1lCmVhc3lh
Yzo6c2NoZW1hOjpyZXN1bHQ6OnRzaXRlCj1jdXQKdXNlIHN0cmljdDsKdXNlIHdhcm5pbmdzOwp1
c2UgbW9vc2U7CnVzZSBtb29zZXg6Om5vbm1vb3NlOwp1c2UgbW9vc2V4OjptYXJrYXNtZXRob2Rz
IGF1dG9jbGVhbiA9PiAxOwpleHRlbmRzICdkYml4OjpjbGFzczo6Y29yZSc7Cj1oZWFkMSBjb21w
b25lbnRzIGxvYWRlZAo9b3ZlciA0Cj1pdGVtICogbDxkYml4OjpjbGFzczo6aW5mbGF0ZWNvbHVt
bjo6ZGF0ZXRpbWU+Cj1iYWNrCj1jdXQKX19wYWNrYWdlX18tPmxvYWRfY29tcG9uZW50cygiaW5m
bGF0ZWNvbHVtbjo6ZGF0ZXRpbWUiKTsKPWhlYWQxIHRhYmxlOiBjPHRfc2l0ZXM+Cj1jdXQKX19w
YWNrYWdlX18tPnRhYmxlKCJ0X3NpdGVzIik7Cj1oZWFkMSBhY2Nlc3NvcnMKPWhlYWQyIGZfaWQK
ZGF0YV90eXBlOiAnaW50ZWdlcicKaXNfYXV0b19pbmNyZW1lbnQ6IDEKaXNfbnVsbGFibGU6IDAK
PWhlYWQyIGZfc2l0ZV9uYW1lCmRhdGFfdHlwZTogJ3ZhcmNoYXInCmlzX251bGxhYmxlOiAxCnNp
emU6IDMwCj1oZWFkMiBmX3N0YXJ0X2RhdGUKZGF0YV90eXBlOiAnZGF0ZScKZGF0ZXRpbWVfdW5k
ZWZfaWZfaW52YWxpZDogMQppc19udWxsYWJsZTogMQo9aGVhZDIgZl9taWxlYWdlCmRhdGFfdHlw
ZTogJ3NtYWxsaW50Jwppc19udWxsYWJsZTogMQo9aGVhZDIgZl9tYWluX2VtcGxveWVyCmRhdGFf
dHlwZTogJ3RpbnlpbnQnCmlzX251bGxhYmxlOiAxCj1jdXQKX19wYWNrYWdlX18tPmFkZF9jb2x1
bW5zKAoiZl9pZCIsCnsgZGF0YV90eXBlID0+ICJpbnRlZ2VyIiwgaXNfYXV0b19pbmNyZW1lbnQg
PT4gMSwgaXNfbnVsbGFibGUgPT4gMCB9LAoiZl9zaXRlX25hbWUiLAp7IGRhdGFfdHlwZSA9PiAi
dmFyY2hhciIsIGlzX251bGxhYmxlID0+IDEsIHNpemUgPT4gMzAgfSwKImZfc3RhcnRfZGF0ZSIs
CnsgZGF0YV90eXBlID0+ICJkYXRlIiwgImRhdGV0aW1lX3VuZGVmX2lmX2ludmFsaWQiID0+IDEs
IGlzX251bGxhYmxlID0+IDEgfSwKImZfbWlsZWFnZSIsCnsgZGF0YV90eXBlID0+ICJzbWFsbGlu
dCIsIGlzX251bGxhYmxlID0+IDEgfSwKImZfbWFpbl9lbXBsb3llciIsCnsgZGF0YV90eXBlID0+
ICJ0aW55aW50IiwgaXNfbnVsbGFibGUgPT4gMSB9LAopOwo9aGVhZDEgcHJpbWFyeSBrZXkKPW92
ZXIgNAo9aXRlbSAqIGw8L2ZfaWQ+Cj1iYWNrCj1jdXQKX19wYWNrYWdlX18tPnNldF9wcmltYXJ5
X2tleSgiZl9pZCIpOwoKIyBjcmVhdGVkIGJ5IGRiaXg6OmNsYXNzOjpzY2hlbWE6OmxvYWRlciB2
MC4wNzAxNyBAIDIwMTItMDMtMTYgMTI6MjQ6MDYKIyBkbyBub3QgbW9kaWZ5IHRoaXMgb3IgYW55
dGhpbmcgYWJvdmUhIG1kNXN1bTp0aHJndXgxZ2YxcGxkaG9jankxNWZxCgojIHlvdSBjYW4gcmVw
bGFjZSB0aGlzIHRleHQgd2l0aCBjdXN0b20gY29kZSBvciBjb21tZW50cywgYW5kIGl0IHdpbGwg
YmUKcHJlc2VydmVkIG9uIHJlZ2VuZXJhdGlvbgpfX3BhY2thZ2VfXy0+bWV0YS0+bWFrZV9pbW11
dGFibGU7CjE7CgoKV2hlbiBJIHRyeSB0byBzdGFydCB0aGUgZGV2ZWxvcG1lbnQgc2VydmVyIEkg
Z2V0OgrCoApEdWUgdG8gYSBtZXRob2QgbmFtZSBjb25mbGljdCBpbiByb2xlcyAnQ2F0YWx5c3RY
OjpDb21wb25lbnQ6OlRyYWl0cycgYW5kCidNb29zZVg6OlRyYWl0czo6UGx1Z2dhYmxlJywgdGhl
IG1ldGhvZCAnX2ZpbmRfdHJhaXQnIG11c3QgYmUgaW1wbGVtZW50ZWQgb3IKZXhjbHVkZWQgYnkg
J0NhdGFseXN0OjpNb2RlbDo6REJJQzo6U2NoZW1hJyBhdAovdXNyL2xvY2FsL2xpYi9wZXJsLzUu
MTAuMS9Nb29zZS9NZXRhL1JvbGUvQXBwbGljYXRpb24vVG9DbGFzcy5wbSBsaW5lIDEzNApNb29z
ZTo6TWV0YTo6Um9sZTo6QXBwbGljYXRpb246OlRvQ2xhc3M6OmNoZWNrX3JlcXVpcmVkX21ldGhv
ZHMoJ01vb3NlOjpNZXRhOjpSb2xlOjpBcHBsaWNhdGlvbjo6VG9DbGFzcz1IQVNIKDB4YTczMzM4
OCknLAonTW9vc2U6Ok1ldGE6OlJvbGU9SEFTSCgweGE3MzA4MzApJywgJ01vb3NlOjpNZXRhOjpD
bGFzcz1IQVNIKDB4YTY4OTExMCknKQpjYWxsZWQgYXQgL3Vzci9sb2NhbC9saWIvcGVybC81LjEw
LjEvTW9vc2UvTWV0YS9Sb2xlL0FwcGxpY2F0aW9uLnBtIGxpbmUgNTUKTW9vc2U6Ok1ldGE6OlJv
bGU6OkFwcGxpY2F0aW9uOjphcHBseSgnTW9vc2U6Ok1ldGE6OlJvbGU6OkFwcGxpY2F0aW9uOjpU
b0NsYXNzPUhBU0goMHhhNzMzMzg4KScsCidNb29zZTo6TWV0YTo6Um9sZT1IQVNIKDB4YTczMDgz
MCknLCAnTW9vc2U6Ok1ldGE6OkNsYXNzPUhBU0goMHhhNjg5MTEwKScpCmNhbGxlZCBhdCAvdXNy
L2xvY2FsL2xpYi9wZXJsLzUuMTAuMS9Nb29zZS9NZXRhL1JvbGUvQXBwbGljYXRpb24vVG9DbGFz
cy5wbSBsaW5lCjM2Ck1vb3NlOjpNZXRhOjpSb2xlOjpBcHBsaWNhdGlvbjo6VG9DbGFzczo6YXBw
bHkoJ01vb3NlOjpNZXRhOjpSb2xlOjpBcHBsaWNhdGlvbjo6VG9DbGFzcz1IQVNIKDB4YTczMzM4
OCknLAonTW9vc2U6Ok1ldGE6OlJvbGU9SEFTSCgweGE3MzA4MzApJywgJ01vb3NlOjpNZXRhOjpD
bGFzcz1IQVNIKDB4YTY4OTExMCknLAonSEFTSCgweGE3NTc3ZjgpJykgY2FsbGVkIGF0IC91c3Iv
bG9jYWwvbGliL3BlcmwvNS4xMC4xL01vb3NlL01ldGEvUm9sZS5wbSBsaW5lCjQ3MApNb29zZTo6
TWV0YTo6Um9sZTo6YXBwbHkoJ01vb3NlOjpNZXRhOjpSb2xlPUhBU0goMHhhNzMwODMwKScsCidN
b29zZTo6TWV0YTo6Q2xhc3M9SEFTSCgweGE2ODkxMTApJykgY2FsbGVkIGF0Ci91c3IvbG9jYWwv
bGliL3BlcmwvNS4xMC4xL01vb3NlL1V0aWwucG0gbGluZSAxNjAKTW9vc2U6OlV0aWw6Ol9hcHBs
eV9hbGxfcm9sZXMoJ01vb3NlOjpNZXRhOjpDbGFzcz1IQVNIKDB4YTY4OTExMCknLCB1bmRlZiwK
J0NhdGFseXN0WDo6Q29tcG9uZW50OjpUcmFpdHMnKSBjYWxsZWQgYXQKL3Vzci9sb2NhbC9saWIv
cGVybC81LjEwLjEvTW9vc2UvVXRpbC5wbSBsaW5lIDk5Ck1vb3NlOjpVdGlsOjphcHBseV9hbGxf
cm9sZXMoJ01vb3NlOjpNZXRhOjpDbGFzcz1IQVNIKDB4YTY4OTExMCknLAonQ2F0YWx5c3RYOjpD
b21wb25lbnQ6OlRyYWl0cycpIGNhbGxlZCBhdCAvdXNyL2xvY2FsL2xpYi9wZXJsLzUuMTAuMS9N
b29zZS5wbQpsaW5lIDY3Ck1vb3NlOjp3aXRoKCdNb29zZTo6TWV0YTo6Q2xhc3M9SEFTSCgweGE2
ODkxMTApJywKJ0NhdGFseXN0WDo6Q29tcG9uZW50OjpUcmFpdHMnKSBjYWxsZWQgYXQKL3Vzci9s
b2NhbC9saWIvcGVybC81LjEwLjEvTW9vc2UvRXhwb3J0ZXIucG0gbGluZSAzNzAKTW9vc2U6Ondp
dGgoJ0NhdGFseXN0WDo6Q29tcG9uZW50OjpUcmFpdHMnKSBjYWxsZWQgYXQKL3Vzci9sb2NhbC9z
aGFyZS9wZXJsLzUuMTAuMS9DYXRhbHlzdC9Nb2RlbC9EQklDL1NjaGVtYS5wbSBsaW5lIDYKcmVx
dWlyZSBDYXRhbHlzdC9Nb2RlbC9EQklDL1NjaGVtYS5wbSBjYWxsZWQgYXQgKGV2YWwgNjY0KSBs
aW5lIDMKZXZhbCAncmVxdWlyZSBDYXRhbHlzdDo6TW9kZWw6OkRCSUM6OlNjaGVtYQo7JyBjYWxs
ZWQgYXQgL3Vzci9zaGFyZS9wZXJsLzUuMTAvYmFzZS5wbSBsaW5lIDkwCmJhc2U6OmltcG9ydCgn
YmFzZScsICdDYXRhbHlzdDo6TW9kZWw6OkRCSUM6OlNjaGVtYScpIGNhbGxlZCBhdAovaG9tZS9z
Y290dC9DYXRhbHlzdC9FYXN5QUMvbGliL0Vhc3lBQy9Nb2RlbC9EQi5wbSBsaW5lIDQKRWFzeUFD
OjpNb2RlbDo6REI6OkJFR0lOKCkgY2FsbGVkIGF0Ci91c3IvbG9jYWwvc2hhcmUvcGVybC81LjEw
LjEvQ2F0YWx5c3QvTW9kZWwvREJJQy9TY2hlbWEucG0gbGluZSAwCmV2YWwgey4uLn0gY2FsbGVk
IGF0IC91c3IvbG9jYWwvc2hhcmUvcGVybC81LjEwLjEvQ2F0YWx5c3QvTW9kZWwvREJJQy9TY2hl
bWEucG0KbGluZSAwCnJlcXVpcmUgRWFzeUFDL01vZGVsL0RCLnBtIGNhbGxlZCBhdAovdXNyL2xv
Y2FsL3NoYXJlL3BlcmwvNS4xMC4xL0NhdGFseXN0L1V0aWxzLnBtIGxpbmUgMzE3CmV2YWwgey4u
Ln0gY2FsbGVkIGF0IC91c3IvbG9jYWwvc2hhcmUvcGVybC81LjEwLjEvQ2F0YWx5c3QvVXRpbHMu
cG0gbGluZSAzMTcKQ2F0YWx5c3Q6OlV0aWxzOjplbnN1cmVfY2xhc3NfbG9hZGVkKCdFYXN5QUM6
Ok1vZGVsOjpEQicsICdIQVNIKDB4YTYxZWIxMCknKQpjYWxsZWQgYXQgL3Vzci9sb2NhbC9zaGFy
ZS9wZXJsLzUuMTAuMS9DYXRhbHlzdC5wbSBsaW5lIDI1MDQKQ2F0YWx5c3Q6OnNldHVwX2NvbXBv
bmVudHMoJ0Vhc3lBQycpIGNhbGxlZCBhdAovdXNyL2xvY2FsL3NoYXJlL3BlcmwvNS4xMC4xL0Nh
dGFseXN0LnBtIGxpbmUgMTE2MgpDYXRhbHlzdDo6c2V0dXAoJ0Vhc3lBQycpIGNhbGxlZCBhdCAv
aG9tZS9zY290dC9DYXRhbHlzdC9FYXN5QUMvbGliL0Vhc3lBQy5wbQpsaW5lIDU3CnJlcXVpcmUg
RWFzeUFDLnBtIGNhbGxlZCBhdCAvdXNyL2xvY2FsL3NoYXJlL3BlcmwvNS4xMC4xL01vZHVsZS9S
dW50aW1lLnBtIGxpbmUKMzE3Ck1vZHVsZTo6UnVudGltZTo6cmVxdWlyZV9tb2R1bGUoJ0Vhc3lB
QycpIGNhbGxlZCBhdAovdXNyL2xvY2FsL3NoYXJlL3BlcmwvNS4xMC4xL0NsYXNzL0xvYWQucG0g
bGluZSAxNzcKQ2xhc3M6OkxvYWQ6Ol9fQU5PTl9fKCkgY2FsbGVkIGF0IC91c3IvbG9jYWwvc2hh
cmUvcGVybC81LjEwLjEvVHJ5L1RpbnkucG0gbGluZQo3MQpldmFsIHsuLi59IGNhbGxlZCBhdCAv
dXNyL2xvY2FsL3NoYXJlL3BlcmwvNS4xMC4xL1RyeS9UaW55LnBtIGxpbmUgNjcKVHJ5OjpUaW55
Ojp0cnkoJ0NPREUoMHg5ZWIyYWQ4KScsICdUcnk6OlRpbnk6OkNhdGNoPVJFRigweDlhMjQ2NDgp
JykgY2FsbGVkIGF0Ci91c3IvbG9jYWwvc2hhcmUvcGVybC81LjEwLjEvQ2xhc3MvTG9hZC5wbSBs
aW5lIDE4MwpDbGFzczo6TG9hZDo6dHJ5X2xvYWRfY2xhc3MoJ0Vhc3lBQycsIHVuZGVmKSBjYWxs
ZWQgYXQKL3Vzci9sb2NhbC9zaGFyZS9wZXJsLzUuMTAuMS9DbGFzcy9Mb2FkLnBtIGxpbmUgMzgK
Q2xhc3M6OkxvYWQ6OmxvYWRfY2xhc3MoJ0Vhc3lBQycpIGNhbGxlZCBhdAovdXNyL2xvY2FsL3No
YXJlL3BlcmwvNS4xMC4xL0NhdGFseXN0L1NjcmlwdFJvbGUucG0gbGluZSA4MwpDYXRhbHlzdDo6
U2NyaXB0Um9sZTo6X3J1bl9hcHBsaWNhdGlvbignQ2F0YWx5c3Q6OlNjcmlwdDo6U2VydmVyPUhB
U0goMHg5ZWIyYmU4KScpCmNhbGxlZCBhdCAvdXNyL2xvY2FsL3NoYXJlL3BlcmwvNS4xMC4xL0Nh
dGFseXN0L1NjcmlwdC9TZXJ2ZXIucG0gbGluZSAyMzkKQ2F0YWx5c3Q6OlNjcmlwdDo6U2VydmVy
OjpydW4oJ0NhdGFseXN0OjpTY3JpcHQ6OlNlcnZlcj1IQVNIKDB4OWViMmJlOCknKSBjYWxsZWQK
YXQgL3Vzci9sb2NhbC9zaGFyZS9wZXJsLzUuMTAuMS9DYXRhbHlzdC9TY3JpcHRSdW5uZXIucG0g
bGluZSA1MApDYXRhbHlzdDo6U2NyaXB0UnVubmVyOjpydW4oJ0NhdGFseXN0OjpTY3JpcHRSdW5u
ZXInLCAnRWFzeUFDJywgJ1NlcnZlcicpIGNhbGxlZAphdCBzY3JpcHQvZWFzeWFjX3NlcnZlci5w
bCBsaW5lIDgKQ29tcGlsYXRpb24gZmFpbGVkIGluIHJlcXVpcmUgYXQgKGV2YWwgNjY0KSBsaW5l
IDMuCi4uLnByb3BhZ2F0ZWQgYXQgL3Vzci9zaGFyZS9wZXJsLzUuMTAvYmFzZS5wbSBsaW5lIDkz
LgpCRUdJTiBmYWlsZWQtLWNvbXBpbGF0aW9uIGFib3J0ZWQgYXQKL2hvbWUvc2NvdHQvQ2F0YWx5
c3QvRWFzeUFDL2xpYi9FYXN5QUMvTW9kZWwvREIucG0gbGluZSA0LgpDb21waWxhdGlvbiBmYWls
ZWQgaW4gcmVxdWlyZSBhdCAvdXNyL2xvY2FsL3NoYXJlL3BlcmwvNS4xMC4xL0NhdGFseXN0L1V0
aWxzLnBtCmxpbmUgMzE3LgpDb21waWxhdGlvbiBmYWlsZWQgaW4gcmVxdWlyZSBhdCAvdXNyL2xv
Y2FsL3NoYXJlL3BlcmwvNS4xMC4xL01vZHVsZS9SdW50aW1lLnBtCmxpbmUgMzE3LgphdCAvdXNy
L2xvY2FsL3NoYXJlL3BlcmwvNS4xMC4xL0NhdGFseXN0L1NjcmlwdC9TZXJ2ZXIucG0gbGluZSAy
MzkKwqAKQ2FuIHNvbWVvbmUgdGVsbCBtZSBob3cgdG8gZml4IHRoaXM/Ci0tLS0tLS0tLS0tLS0t
IG5leHQgcGFydCAtLS0tLS0tLS0tLS0tLQpBbiBIVE1MIGF0dGFjaG1lbnQgd2FzIHNjcnViYmVk
Li4uClVSTDogaHR0cDovL2xpc3RzLnNjc3lzLmNvLnVrL3BpcGVybWFpbC9jYXRhbHlzdC9hdHRh
Y2htZW50cy8yMDEyMDMxNi8wMDY4MDRiNC9hdHRhY2htZW50Lmh0bQo=
More information about the Catalyst
mailing list