Thread: [Openpacket-devel] db schema and use cases
Brought to you by:
crazy_j,
taosecurity
Menu
▾
▴
openpacket-devel
|
From: Tim F. <fu...@cc...> - 2006-07-29 00:53:18
Attachments:
openpacket.sql
|
Ci0gbmV3IHVzZXIgcmVnaXN0cmF0aW9uCiAgLSB1c2VyIGNsaWNrcyAnY3JlYXRlIGFjY291bnQn CiAgLSB3ZWJzaXRlIG9idGFpbnMgdXNlciBpbmZvcm1hdGlvbgogIC0gd2Vic2lkZSBlbnRlcnMg dXNlciBpbmZvcm1hdGlvbiBpbiBEQiAoY29uZmlybWVkPSdOJykgYW5kIHNlbmRzIGNvbmZpcm1h dGlvbiBlLW1haWwgdG8KICAgIGFkZHJlc3MgcHJvdmlkZWQKICAtIHVzZXIgY2xpY2tzIG9uIGxp bmsgaW4gZS1tYWlsIC8gcmVwbGllcyB0byBlLW1haWwKICAtIHdlYnNpdGUvcHJvY21haWwtaW52 b2tlZCBzY3JpcHQgY29uZmlybXMgaWRlbnRpdHkgYW5kIHNldHMgY29uZmlybWVkPSdZJwoKLSAo c2luZ2xlKSB0cmFjZSBzdWJtaXNzaW9uCiAgLSB1c2VyIGNsaWNrcyAnc3VibWl0IHRyYWNlJwog IC0gd2Vic2l0ZSBwcmVzZW50cyBmb3JtIGZvciB0cmFjZSBtZXRhLWluZm8sIHRhZ3MsIGFuZCB1 cGxvYWQgbGluawogIC0gdXNlciBlbnRlcnMgbWV0YS1pbmZvIGFuZCBwcmVwYXJlcyB1cGxvYWQg CiAgLSB3ZWJzaXRlIHJlLXByZXNlbnRzIG1ldGEtaW5mbyAoYW5kIHBvc3NpYmx5IHRyYWNlIGhh c2gpIGFuZCBpc3N1ZXMgY2hhbGxlbmdlIHRvIHVzZXIgdG8KICAgIGNvbmZpcm0gYXV0aG9yaXph dGlvbgogIC0gdXNlciBjb25maXJtcyBhdXRob3JpemF0aW9uIChlbHNlIGJhaWwpCiAgLSB0cmFj ZSBpcyBzdG9yZWQgYW5kIG1hZGUgYWNjZXNzaWJsZSB0byBtb2RlcmF0b3JzIChhcHByb3ZlZD0n TicpCiAgLSBwb3NzaWJseSBzb21lIGF1dG9tYXRlZCBwcm9jZXNzIGlzIHJ1biB0byBhbmFseXpl IGFuZCBzdW1tYXJpemUgdGhlIHRyYWNlCiAgICAtIGUuZy4gaWRlbnRpZnkgZmlsZSBmb3JtYXQs IHJ1biBjYXBpbmZvcywgcnVuIHRjcHRyYWNlL2FyZ3VzIGFuZCBzdW1tYXJpemUgdGhlIG91dHB1 dCwgcnVuCiAgICAgIHAwZiB0byBwcm9maWxlIHRoZSBkb21pbmFudCBPU2VzLCBjaGVjayBmb3Ig Z2xvYmFsbHkgYWRkcmVzc2FibGUgSVBzLCBldGMuCgotIG1vZGVyYXRvciByZXZpZXdzIGFuIHVu YXBwcm92ZWQgdHJhY2UKICAtIHdlYnNpdGUgYWxsb3dzIGEgbW9kZXJhdG9yIHVzZXIgdG8gdmll dyBsaXN0IG9mIHRyYWNlcyBwZW5kaW5nIGFwcHJvdmFsIChhcHByb3ZlZD0nTicpIGFuZCB0bwog ICAgYWNjZXNzIHRoZWlyIG1ldGEtaW5mbyBhbmQgcmV2aWV3cyAobWF5IG9yIG1heSBub3Qgd2Fu dCB0byBhbGxvdyB2aWV3aW5nIG9mIHZvdGVzIGNhc3QpCiAgLSBtb2RlcmF0b3Igc2VsZWN0cyBh bmQgZG93bmxvYWRzIGEgdHJhY2UKICAtIG1vZGVyYXRvciByZXZpZXdzIHRoZSB0cmFjZQogIC0g d2Vic2l0ZSBhbGxvd3MgbW9kZXJhdG9yIHRvIGVpdGhlciByZXZpZXcgKHN1Ym1pdCByZXZpZXcg dG8gdHJhY2VfcmV2aWV3cyBwbHVzIHZvdGUgdG8KICAgIHRyYWNlX3ZvdGVzKSBvciBzaW1wbHkg dm90ZSBvbiAoanVzdCB0cmFjZV92b3RlKSB0aGUgdHJhY2UKICAgIC0gY291bGQgc3VnZ2VzdCB0 YWdzIHRvIGJlIGFkZGVkL3JlbW92ZWQgaW4gcmV2aWV3cwogIAotIGV4ZWN1dGl2ZSB1c2VyIGFw cHJvdmVzIGEgdHJhY2UKICAtIHdlYnNpdGUgYWxsb3dzIGFuIGV4ZWN1dGl2ZSB1c2VyIHRvIHZp ZXcgbGlzdCBvZiB0cmFjZXMgYXdhaXRpbmcgYXBwcm92YWwgKHRob3NlIHdpdGgKICAgIGFwcHJv dmVkPSdOJywgd2l0aCBtb3JlIHBvc2l0aXZlIHZvdGVzIHRoYW4gYSBnaXZlbiB0aHJlc2hvbGQs IGFuZCB3aXRoIGEgc2ltcGxlIG1ham9yaXR5IG9mCiAgICBwb3NpdGl2ZSB2b3RlcywgY29tcGFy ZWQgdG8gdG90YWwgdm90ZXMgZm9yIHRoZSB0cmFjZSkgCiAgICAtIGFsc28gYWxsb3dzIHRoZW0g dG8gYWNjZXNzIGFueSB0cmFjZSdzIG1ldGEtaW5mbywgcmV2aWV3cywgYW5kIHZvdGVzCiAgLSBl eGVjdXRpdmUgbWFrZXMgdGhlIGRlY2lzaW9uIHRvIGFwcHJvdmUgYSB0cmFjZSwgYW5kIGRvZXMg c28gKGFwcHJvdmVkPSdZJywgYXBwcm92ZWRfYnk9dXNlcikKICAtIGV4ZWN1dGl2ZSBjYW4gYWRk IG9yIHJlbW92ZSB0YWdzIGFzIGFwcHJvcHJpYXRlCiAgLSB3ZWJzaXRlIGNyZWRpdHMgdXNlciB3 aG8gc3VibWl0dGVkIHRoZSB0cmFjZQoKLSB1c2VyIHNlYXJjaGVzIGZvciB0cmFjZXMgdXNpbmcg YSA8Zm9vOiB0YWd8bWV0YS1pbmZvIHZhbHVlfGRlc2NyaXB0aW9uIGtleXdvcmQ+CiAgLSB1c2Vy IHNlbGVjdHMgYSA8Zm9vPgogIC0gd2Vic2l0ZSBwcmVzZW50cyB0cmFjZXMgd2l0aCB0aGF0IDxm b28+LCBzb3J0ZWQgYnkga2FybWEKCi0gdXNlciByZXZpZXdzL2FuYWx5emVzIGEgdHJhY2UgKGFs c28gYXBwbGllcyB0byBtb2RlcmF0b3IgcmV2aWV3cyBvZiB0cmFjZXMgcGVuZGluZyBhcHByb3Zh bCkKICAtIHdlYnNpdGUgYWxsb3dzIHVzZXIgdG8gc3VibWl0OgogICAgLSBhIHJhdGluZyBmb3Ig dGhlIHRyYWNlIChwZXJoYXBzIGJldHdlZW4gLTMgYW5kIDMsIG9yIC01IGFuZCA1LCBvciAwIHRv IDEwLCBldGMuKQogICAgICAtIGJhc2VkIG9uIHRoZSB1dGlsaXR5IG9mIHRoZSB0cmFjZSBvdmVy YWxsCiAgICAtIGEgdGV4dCByZXZpZXcvYW5hbHlzaXMKICAgIC0gYSBsaXN0IG9mIHRvb2xzIHVz ZWQgaW4gdGhlIGFuYWx5c2lzCiAgICAtIHRhZ3M/ICBlaXRoZXIgZm9yIHRoZSByZXZpZXcgb3Ig Zm9yIHRoZSB0cmFjZQogIC0gcmV2aWV3IGlzIHN1Ym1pdHRlZCBhbmQgdGhlIHRyYWNlJ3Mga2Fy bWEgaXMgdXBkYXRlZCAKICAgIC0gZS5nLiBtb2RpZmllZCBieSAoIHJhdGluZyAqIHVzZXIua2Fy bWEgKSAvIG1heF9yYXRpbmcKICAgIC0ga2FybWEgd2lsbCBwcm9iYWJseSBoYXZlIHRvIGJlIHJl Y2FsY3VsYXRlZCBwZXJpb2RpY2FsbHkgYXMgdXNlcnMnIGthcm1hIGNoYW5nZXMKICAtIHVzZXIg d2hvIHN1Ym1pdHRlZCB0aGUgdHJhY2UgaGFzIHRoZWlyIGthcm1hIHVwZGF0ZWQKICAgIC0gbGVz cyBkcmFtYXRpY2FsbHkgdGhhbiB0aGUgdHJhY2UsIHByb2JhYmx5IGFsc28gbW9kaWZpZWQgYnkg aG93IHJlY2VudGx5IHRoZSB0cmFjZSB3YXMKICAgICAgc3VibWl0dGVkIGFuZCBwb3NzaWJseSBi eSBob3cgbWFueSB0cmFjZXMgdGhleSBoYXZlIHN1Ym1pdHRlZAoKLSB1c2VyICdtb2RzJyBhIHRy YWNlL3JldmlldwogIC0gKnB1bnQqCgo= |
|
From: Richard B. <tao...@gm...> - 2006-07-29 02:26:21
|
On 7/28/06, Tim Furlong <fu...@cc...> wrote: > Hi folks, > > I realize that this may have been overtaken by events, but thought I'd toss > these out for discussion anyway. Hi Tim, We are definitely still in the early days. David's work is excellent, but I am sure he would also like the best possible schema as we go forward. Thank you, Richard |
|
From: David A. Belle-I. <ml...@im...> - 2006-07-29 04:19:58
|
Hi, I also have a DB schema. I'll convert it to PDF and send it as soon as I can. Thanks, David Richard Bejtlich wrote: > On 7/28/06, Tim Furlong <fu...@cc...> wrote: >> Hi folks, >> >> I realize that this may have been overtaken by events, but thought I'd toss >> these out for discussion anyway. > > Hi Tim, > > We are definitely still in the early days. David's work is excellent, > but I am sure he would also like the best possible schema as we go > forward. > > Thank you, > > Richard > > ------------------------------------------------------------------------- > Take Surveys. Earn Cash. Influence the Future of IT > Join SourceForge.net's Techsay panel and you'll get the chance to share your > opinions on IT & business topics through brief surveys -- and earn cash > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV > _______________________________________________ > Openpacket-devel mailing list > Ope...@li... > https://lists.sourceforge.net/lists/listinfo/openpacket-devel > |
|
From: Tim F. <fu...@cc...> - 2006-07-29 04:30:56
|
Hi David, Ok great, that should help us get a feel for what you've already got in the works. :-) Thanks, -Tim On 7/29/06, David A. Belle-Isle <ml...@im...> wrote: > > Hi, > > I also have a DB schema. I'll convert it to PDF and send it as soon as I > can. > > Thanks, > > David > > > > Richard Bejtlich wrote: > > On 7/28/06, Tim Furlong <fu...@cc...> wrote: > >> Hi folks, > >> > >> I realize that this may have been overtaken by events, but thought I'd > toss > >> these out for discussion anyway. > > > > Hi Tim, > > > > We are definitely still in the early days. David's work is excellent, > > but I am sure he would also like the best possible schema as we go > > forward. > > > > Thank you, > > > > Richard > > > > > ------------------------------------------------------------------------- > > Take Surveys. Earn Cash. Influence the Future of IT > > Join SourceForge.net's Techsay panel and you'll get the chance to share > your > > opinions on IT & business topics through brief surveys -- and earn cash > > > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV > > _______________________________________________ > > Openpacket-devel mailing list > > Ope...@li... > > https://lists.sourceforge.net/lists/listinfo/openpacket-devel > > > > > > ------------------------------------------------------------------------- > Take Surveys. Earn Cash. Influence the Future of IT > Join SourceForge.net's Techsay panel and you'll get the chance to share > your > opinions on IT & business topics through brief surveys -- and earn cash > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV > _______________________________________________ > Openpacket-devel mailing list > Ope...@li... > https://lists.sourceforge.net/lists/listinfo/openpacket-devel > -- Tim Furlong tim...@gm... |
Thanks for helping keep SourceForge clean.
X