[Openpacket-devel] db schema and use cases
Brought to you by:
crazy_j,
taosecurity
|
From: Tim F. <fu...@cc...> - 2006-07-29 00:53:18
|
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= |