~launchpad-pqm/launchpad/devel

1776 by Canonical.com Patch Queue Manager
[trivial] various fixes that didn't merge before (network?) and new db diagrams
1
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
2
<!DOCTYPE svg PUBLIC "-//W3C//DTD SVG 1.0//EN"
3
 "http://www.w3.org/TR/2001/REC-SVG-20010904/DTD/svg10.dtd">
3691.17.2 by Stuart Bishop
Update database diagrams
4
<!-- Generated by fdp version 2.2.1 (Thu Apr  6 00:32:47 UTC 2006)
1776 by Canonical.com Patch Queue Manager
[trivial] various fixes that didn't merge before (network?) and new db diagrams
5
     For user: (stub) Stuart Bishop,,,   Title: g    Pages: 1 -->
3691.17.2 by Stuart Bishop
Update database diagrams
6
<svg width="1097px" height="1122px"
7
 viewBox = "-1 -1 1096 1121"
1776 by Canonical.com Patch Queue Manager
[trivial] various fixes that didn't merge before (network?) and new db diagrams
8
 xmlns="http://www.w3.org/2000/svg">
3322.1.13 by Stuart Bishop
Update database diagrams
9
<g id="graph0" class="graph" style="font-family:Times-Roman;font-size:14.00;">
1776 by Canonical.com Patch Queue Manager
[trivial] various fixes that didn't merge before (network?) and new db diagrams
10
<title>g</title>
3691.17.2 by Stuart Bishop
Update database diagrams
11
<text text-anchor="middle" style="font-size:22.00;" x="547" y="1104">Bounty</text>
1776 by Canonical.com Patch Queue Manager
[trivial] various fixes that didn't merge before (network?) and new db diagrams
12
<g id="node1" class="node"><title>bounty</title>
3691.17.2 by Stuart Bishop
Update database diagrams
13
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="547,495 547,279 737,279 737,495 547,495"/>
14
<polygon style="fill:white;stroke:white;" points="550,296 550,282 734,282 734,296 550,296"/>
15
<text text-anchor="middle" style="font-size:8.00;" x="642" y="292">bounty</text>
16
<polygon style="fill:none;stroke:black;" points="550,296 550,282 734,282 734,296 550,296"/>
17
<text text-anchor="middle" style="font-size:8.00;" x="556" y="307">id</text>
18
<text text-anchor="middle" style="font-size:8.00;" x="609" y="307">serial</text>
19
<text text-anchor="middle" style="font-size:8.00;" x="683" y="307"> PRIMARY KEY </text>
20
<text text-anchor="middle" style="font-size:8.00;" x="562" y="321">name</text>
21
<text text-anchor="middle" style="font-size:8.00;" x="607" y="321">text</text>
22
<text text-anchor="middle" style="font-size:8.00;" x="671" y="321"> UNIQUE </text>
23
<text text-anchor="middle" style="font-size:8.00;" x="559" y="335">title</text>
24
<text text-anchor="middle" style="font-size:8.00;" x="607" y="335">text</text>
25
<text text-anchor="middle" style="font-size:8.00;" x="568" y="349">summary</text>
26
<text text-anchor="middle" style="font-size:8.00;" x="607" y="349">text</text>
27
<text text-anchor="middle" style="font-size:8.00;" x="570" y="363">description</text>
28
<text text-anchor="middle" style="font-size:8.00;" x="607" y="363">text</text>
29
<text text-anchor="middle" style="font-size:8.00;" x="567" y="377">usdvalue</text>
30
<text text-anchor="middle" style="font-size:8.00;" x="624" y="377">numeric(10,2)</text>
31
<text text-anchor="middle" style="font-size:8.00;" x="567" y="391">difficulty</text>
32
<text text-anchor="middle" style="font-size:8.00;" x="612" y="391">integer</text>
33
<text text-anchor="middle" style="font-size:8.00;" x="567" y="405">reviewer</text>
34
<text text-anchor="middle" style="font-size:8.00;" x="612" y="405">integer</text>
35
<text text-anchor="middle" style="font-size:8.00;" x="693" y="405"> REFERENCES person </text>
36
<text text-anchor="middle" style="font-size:8.00;" x="571" y="419">datecreated</text>
37
<text text-anchor="middle" style="font-size:8.00;" x="618" y="419">timestamp</text>
38
<text text-anchor="middle" style="font-size:8.00;" x="563" y="433">owner</text>
39
<text text-anchor="middle" style="font-size:8.00;" x="612" y="433">integer</text>
40
<text text-anchor="middle" style="font-size:8.00;" x="693" y="433"> REFERENCES person </text>
41
<text text-anchor="middle" style="font-size:8.00;" x="566" y="447">deadline</text>
42
<text text-anchor="middle" style="font-size:8.00;" x="618" y="447">timestamp</text>
43
<text text-anchor="middle" style="font-size:8.00;" x="566" y="461">claimant</text>
44
<text text-anchor="middle" style="font-size:8.00;" x="612" y="461">integer</text>
45
<text text-anchor="middle" style="font-size:8.00;" x="693" y="461"> REFERENCES person </text>
46
<text text-anchor="middle" style="font-size:8.00;" x="572" y="475">dateclaimed</text>
47
<text text-anchor="middle" style="font-size:8.00;" x="618" y="475">timestamp</text>
48
<text text-anchor="middle" style="font-size:8.00;" x="573" y="489">bountystatus</text>
49
<text text-anchor="middle" style="font-size:8.00;" x="612" y="489">integer</text>
50
<polygon style="fill:none;stroke:black;" points="547,495 547,279 737,279 737,495 547,495"/>
1776 by Canonical.com Patch Queue Manager
[trivial] various fixes that didn't merge before (network?) and new db diagrams
51
</g>
1681.1.131 by Stuart Bishop
Update diagrams
52
<g id="node5" class="node"><title>person</title>
3691.17.2 by Stuart Bishop
Update database diagrams
53
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="206,943 206,545 464,545 464,943 206,943"/>
54
<polygon style="fill:white;stroke:white;" points="209,562 209,548 461,548 461,562 209,562"/>
55
<text text-anchor="middle" style="font-size:8.00;" x="335" y="558">person</text>
56
<polygon style="fill:none;stroke:black;" points="209,562 209,548 461,548 461,562 209,562"/>
57
<text text-anchor="middle" style="font-size:8.00;" x="215" y="573">id</text>
58
<text text-anchor="middle" style="font-size:8.00;" x="310" y="573">serial</text>
59
<text text-anchor="middle" style="font-size:8.00;" x="372" y="573"> PRIMARY KEY </text>
60
<text text-anchor="middle" style="font-size:8.00;" x="232" y="587">displayname</text>
61
<text text-anchor="middle" style="font-size:8.00;" x="308" y="587">text</text>
62
<text text-anchor="middle" style="font-size:8.00;" x="227" y="601">password</text>
63
<text text-anchor="middle" style="font-size:8.00;" x="308" y="601">text</text>
64
<text text-anchor="middle" style="font-size:8.00;" x="230" y="615">teamowner</text>
65
<text text-anchor="middle" style="font-size:8.00;" x="313" y="615">integer</text>
66
<text text-anchor="middle" style="font-size:8.00;" x="382" y="615"> REFERENCES person </text>
67
<text text-anchor="middle" style="font-size:8.00;" x="238" y="629">teamdescription</text>
68
<text text-anchor="middle" style="font-size:8.00;" x="308" y="629">text</text>
69
<text text-anchor="middle" style="font-size:8.00;" x="221" y="643">name</text>
70
<text text-anchor="middle" style="font-size:8.00;" x="308" y="643">text</text>
71
<text text-anchor="middle" style="font-size:8.00;" x="227" y="657">language</text>
72
<text text-anchor="middle" style="font-size:8.00;" x="313" y="657">integer</text>
73
<text text-anchor="middle" style="font-size:8.00;" x="386" y="657"> REFERENCES language </text>
74
<text text-anchor="middle" style="font-size:8.00;" x="216" y="671">fti</text>
75
<text text-anchor="middle" style="font-size:8.00;" x="315" y="671">tsvector</text>
76
<text text-anchor="middle" style="font-size:8.00;" x="253" y="685">defaultmembershipperiod</text>
77
<text text-anchor="middle" style="font-size:8.00;" x="313" y="685">integer</text>
78
<text text-anchor="middle" style="font-size:8.00;" x="246" y="699">defaultrenewalperiod</text>
79
<text text-anchor="middle" style="font-size:8.00;" x="313" y="699">integer</text>
80
<text text-anchor="middle" style="font-size:8.00;" x="241" y="713">subscriptionpolicy</text>
81
<text text-anchor="middle" style="font-size:8.00;" x="313" y="713">integer</text>
82
<text text-anchor="middle" style="font-size:8.00;" x="224" y="727">merged</text>
83
<text text-anchor="middle" style="font-size:8.00;" x="313" y="727">integer</text>
84
<text text-anchor="middle" style="font-size:8.00;" x="382" y="727"> REFERENCES person </text>
85
<text text-anchor="middle" style="font-size:8.00;" x="230" y="741">datecreated</text>
86
<text text-anchor="middle" style="font-size:8.00;" x="319" y="741">timestamp</text>
87
<text text-anchor="middle" style="font-size:8.00;" x="225" y="755">calendar</text>
88
<text text-anchor="middle" style="font-size:8.00;" x="313" y="755">integer</text>
89
<text text-anchor="middle" style="font-size:8.00;" x="401" y="755"> REFERENCES calendar UNIQUE </text>
90
<text text-anchor="middle" style="font-size:8.00;" x="227" y="769">timezone</text>
91
<text text-anchor="middle" style="font-size:8.00;" x="308" y="769">text</text>
92
<text text-anchor="middle" style="font-size:8.00;" x="232" y="783">addressline1</text>
93
<text text-anchor="middle" style="font-size:8.00;" x="308" y="783">text</text>
94
<text text-anchor="middle" style="font-size:8.00;" x="232" y="797">addressline2</text>
95
<text text-anchor="middle" style="font-size:8.00;" x="308" y="797">text</text>
96
<text text-anchor="middle" style="font-size:8.00;" x="232" y="811">organization</text>
97
<text text-anchor="middle" style="font-size:8.00;" x="308" y="811">text</text>
98
<text text-anchor="middle" style="font-size:8.00;" x="218" y="825">city</text>
99
<text text-anchor="middle" style="font-size:8.00;" x="308" y="825">text</text>
100
<text text-anchor="middle" style="font-size:8.00;" x="226" y="839">province</text>
101
<text text-anchor="middle" style="font-size:8.00;" x="308" y="839">text</text>
102
<text text-anchor="middle" style="font-size:8.00;" x="224" y="853">country</text>
103
<text text-anchor="middle" style="font-size:8.00;" x="313" y="853">integer</text>
104
<text text-anchor="middle" style="font-size:8.00;" x="383" y="853"> REFERENCES country </text>
105
<text text-anchor="middle" style="font-size:8.00;" x="226" y="867">postcode</text>
106
<text text-anchor="middle" style="font-size:8.00;" x="308" y="867">text</text>
107
<text text-anchor="middle" style="font-size:8.00;" x="222" y="881">phone</text>
108
<text text-anchor="middle" style="font-size:8.00;" x="308" y="881">text</text>
109
<text text-anchor="middle" style="font-size:8.00;" x="243" y="895">homepage_content</text>
110
<text text-anchor="middle" style="font-size:8.00;" x="308" y="895">text</text>
111
<text text-anchor="middle" style="font-size:8.00;" x="225" y="909">emblem</text>
112
<text text-anchor="middle" style="font-size:8.00;" x="313" y="909">integer</text>
113
<text text-anchor="middle" style="font-size:8.00;" x="394" y="909"> REFERENCES libraryfilealias </text>
114
<text text-anchor="middle" style="font-size:8.00;" x="233" y="923">hackergotchi</text>
115
<text text-anchor="middle" style="font-size:8.00;" x="313" y="923">integer</text>
116
<text text-anchor="middle" style="font-size:8.00;" x="394" y="923"> REFERENCES libraryfilealias </text>
117
<text text-anchor="middle" style="font-size:8.00;" x="247" y="937">hide_email_addresses</text>
118
<text text-anchor="middle" style="font-size:8.00;" x="315" y="937">boolean</text>
119
<polygon style="fill:none;stroke:black;" points="206,943 206,545 464,545 464,943 206,943"/>
1776 by Canonical.com Patch Queue Manager
[trivial] various fixes that didn't merge before (network?) and new db diagrams
120
</g>
121
<g id="edge2" class="edge"><title>bounty&#45;&gt;person</title>
3691.17.2 by Stuart Bishop
Update database diagrams
122
<path style="fill:none;stroke:black;" d="M539,461C519,477 500,495 483,513 477,520 471,526 465,533"/>
123
<polygon style="fill:black;stroke:black;" points="468,535 459,541 462,531 468,535"/>
1776 by Canonical.com Patch Queue Manager
[trivial] various fixes that didn't merge before (network?) and new db diagrams
124
</g>
125
<g id="edge4" class="edge"><title>bounty&#45;&gt;person</title>
3691.17.2 by Stuart Bishop
Update database diagrams
126
<path style="fill:none;stroke:black;" d="M539,461C519,477 500,495 483,513 477,520 471,526 465,533"/>
127
<polygon style="fill:black;stroke:black;" points="468,535 459,541 462,531 468,535"/>
1776 by Canonical.com Patch Queue Manager
[trivial] various fixes that didn't merge before (network?) and new db diagrams
128
</g>
129
<g id="edge6" class="edge"><title>bounty&#45;&gt;person</title>
3691.17.2 by Stuart Bishop
Update database diagrams
130
<path style="fill:none;stroke:black;" d="M539,461C519,477 500,495 483,513 477,520 471,526 465,533"/>
131
<polygon style="fill:black;stroke:black;" points="468,535 459,541 462,531 468,535"/>
1681.1.131 by Stuart Bishop
Update diagrams
132
</g>
133
<g id="node2" class="node"><title>bountymessage</title>
3691.17.2 by Stuart Bishop
Update database diagrams
134
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="815,566 815,504 1007,504 1007,566 815,566"/>
135
<polygon style="fill:white;stroke:white;" points="818,521 818,507 1004,507 1004,521 818,521"/>
136
<text text-anchor="middle" style="font-size:8.00;" x="911" y="517">bountymessage</text>
137
<polygon style="fill:none;stroke:black;" points="818,521 818,507 1004,507 1004,521 818,521"/>
138
<text text-anchor="middle" style="font-size:8.00;" x="824" y="532">id</text>
139
<text text-anchor="middle" style="font-size:8.00;" x="864" y="532">serial</text>
140
<text text-anchor="middle" style="font-size:8.00;" x="915" y="532"> PRIMARY KEY </text>
141
<text text-anchor="middle" style="font-size:8.00;" x="832" y="546">bounty</text>
142
<text text-anchor="middle" style="font-size:8.00;" x="867" y="546">integer</text>
143
<text text-anchor="middle" style="font-size:8.00;" x="941" y="546"> REFERENCES bounty UNIQUE </text>
144
<text text-anchor="middle" style="font-size:8.00;" x="835" y="560">message</text>
145
<text text-anchor="middle" style="font-size:8.00;" x="867" y="560">integer</text>
146
<text text-anchor="middle" style="font-size:8.00;" x="944" y="560"> UNIQUE REFERENCES message </text>
147
<polygon style="fill:none;stroke:black;" points="815,566 815,504 1007,504 1007,566 815,566"/>
1681.1.131 by Stuart Bishop
Update diagrams
148
</g>
149
<g id="edge8" class="edge"><title>bountymessage&#45;&gt;bounty</title>
3691.17.2 by Stuart Bishop
Update database diagrams
150
<path style="fill:none;stroke:black;" d="M847,500C820,484 785,466 754,449"/>
151
<polygon style="fill:black;stroke:black;" points="752,452 745,444 755,446 752,452"/>
1681.1.131 by Stuart Bishop
Update diagrams
152
</g>
2850.1.2 by Stuart Bishop
Update database diagrams and documentation
153
<g id="node12" class="node"><title>fake_message_15</title>
3691.17.2 by Stuart Bishop
Update database diagrams
154
<ellipse cx="1062" cy="612" rx="27" ry="18" style="fill:none;stroke:red;"/>
155
<text text-anchor="middle" style="font-size:8.00;" x="1062" y="615">message</text>
1681.1.131 by Stuart Bishop
Update diagrams
156
</g>
2850.1.2 by Stuart Bishop
Update database diagrams and documentation
157
<g id="edge10" class="edge"><title>bountymessage&#45;&gt;fake_message_15</title>
3691.17.2 by Stuart Bishop
Update database diagrams
158
<path style="fill:none;stroke:black;" d="M980,570C998,579 1017,589 1032,596"/>
159
<polygon style="fill:black;stroke:black;" points="1034,593 1041,601 1031,599 1034,593"/>
1681.1.131 by Stuart Bishop
Update diagrams
160
</g>
161
<g id="node3" class="node"><title>bountysubscription</title>
3691.17.2 by Stuart Bishop
Update database diagrams
162
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="496,581 496,519 678,519 678,581 496,581"/>
163
<polygon style="fill:white;stroke:white;" points="499,536 499,522 675,522 675,536 499,536"/>
164
<text text-anchor="middle" style="font-size:8.00;" x="587" y="532">bountysubscription</text>
165
<polygon style="fill:none;stroke:black;" points="499,536 499,522 675,522 675,536 499,536"/>
166
<text text-anchor="middle" style="font-size:8.00;" x="505" y="547">id</text>
167
<text text-anchor="middle" style="font-size:8.00;" x="540" y="547">serial</text>
168
<text text-anchor="middle" style="font-size:8.00;" x="591" y="547"> PRIMARY KEY </text>
169
<text text-anchor="middle" style="font-size:8.00;" x="513" y="561">bounty</text>
170
<text text-anchor="middle" style="font-size:8.00;" x="543" y="561">integer</text>
171
<text text-anchor="middle" style="font-size:8.00;" x="617" y="561"> REFERENCES bounty UNIQUE </text>
172
<text text-anchor="middle" style="font-size:8.00;" x="513" y="575">person</text>
173
<text text-anchor="middle" style="font-size:8.00;" x="543" y="575">integer</text>
174
<text text-anchor="middle" style="font-size:8.00;" x="617" y="575"> REFERENCES person UNIQUE </text>
175
<polygon style="fill:none;stroke:black;" points="496,581 496,519 678,519 678,581 496,581"/>
1681.1.131 by Stuart Bishop
Update diagrams
176
</g>
177
<g id="edge12" class="edge"><title>bountysubscription&#45;&gt;bounty</title>
3691.17.2 by Stuart Bishop
Update database diagrams
178
<path style="fill:none;stroke:black;" d="M599,515C600,513 600,511 601,509"/>
179
<polygon style="fill:black;stroke:black;" points="598,508 604,499 604,510 598,508"/>
1681.1.131 by Stuart Bishop
Update diagrams
180
</g>
181
<g id="edge14" class="edge"><title>bountysubscription&#45;&gt;person</title>
3691.17.2 by Stuart Bishop
Update database diagrams
182
<path style="fill:none;stroke:black;" d="M541,585C523,598 502,615 480,632"/>
183
<polygon style="fill:black;stroke:black;" points="482,635 472,638 478,629 482,635"/>
1681.1.131 by Stuart Bishop
Update diagrams
184
</g>
2850.1.2 by Stuart Bishop
Update database diagrams and documentation
185
<g id="node4" class="node"><title>distributionbounty</title>
3691.17.2 by Stuart Bishop
Update database diagrams
186
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="574,252 574,190 786,190 786,252 574,252"/>
187
<polygon style="fill:white;stroke:white;" points="577,207 577,193 783,193 783,207 577,207"/>
188
<text text-anchor="middle" style="font-size:8.00;" x="680" y="203">distributionbounty</text>
189
<polygon style="fill:none;stroke:black;" points="577,207 577,193 783,193 783,207 577,207"/>
190
<text text-anchor="middle" style="font-size:8.00;" x="583" y="218">id</text>
191
<text text-anchor="middle" style="font-size:8.00;" x="633" y="218">serial</text>
192
<text text-anchor="middle" style="font-size:8.00;" x="684" y="218"> PRIMARY KEY </text>
193
<text text-anchor="middle" style="font-size:8.00;" x="591" y="232">bounty</text>
194
<text text-anchor="middle" style="font-size:8.00;" x="636" y="232">integer</text>
195
<text text-anchor="middle" style="font-size:8.00;" x="710" y="232"> UNIQUE REFERENCES bounty </text>
196
<text text-anchor="middle" style="font-size:8.00;" x="598" y="246">distribution</text>
197
<text text-anchor="middle" style="font-size:8.00;" x="636" y="246">integer</text>
198
<text text-anchor="middle" style="font-size:8.00;" x="718" y="246"> UNIQUE REFERENCES distribution </text>
199
<polygon style="fill:none;stroke:black;" points="574,252 574,190 786,190 786,252 574,252"/>
1681.1.131 by Stuart Bishop
Update diagrams
200
</g>
2850.1.2 by Stuart Bishop
Update database diagrams and documentation
201
<g id="edge16" class="edge"><title>distributionbounty&#45;&gt;bounty</title>
3691.17.2 by Stuart Bishop
Update database diagrams
202
<path style="fill:none;stroke:black;" d="M672,256C672,259 671,262 670,265"/>
203
<polygon style="fill:black;stroke:black;" points="673,266 668,275 667,265 673,266"/>
204
</g>
205
<g id="node17" class="node"><title>fake_distribution_111</title>
206
<ellipse cx="718" cy="44" rx="30" ry="18" style="fill:none;stroke:red;"/>
207
<text text-anchor="middle" style="font-size:8.00;" x="718" y="47">distribution</text>
208
</g>
209
<g id="edge18" class="edge"><title>distributionbounty&#45;&gt;fake_distribution_111</title>
210
<path style="fill:none;stroke:black;" d="M688,186C695,152 706,103 712,72"/>
211
<polygon style="fill:black;stroke:black;" points="709,71 714,62 715,72 709,71"/>
1681.1.131 by Stuart Bishop
Update diagrams
212
</g>
213
<g id="edge24" class="edge"><title>person&#45;&gt;person</title>
3691.17.2 by Stuart Bishop
Update database diagrams
214
<path style="fill:none;stroke:black;" d="M472,802C483,789 490,770 490,744 490,723 485,707 478,694"/>
215
<polygon style="fill:black;stroke:black;" points="475,696 472,686 481,692 475,696"/>
1776 by Canonical.com Patch Queue Manager
[trivial] various fixes that didn't merge before (network?) and new db diagrams
216
</g>
217
<g id="edge20" class="edge"><title>person&#45;&gt;person</title>
3691.17.2 by Stuart Bishop
Update database diagrams
218
<path style="fill:none;stroke:black;" d="M472,882C494,862 508,815 508,744 508,681 497,637 479,614"/>
219
<polygon style="fill:black;stroke:black;" points="476,616 472,606 481,611 476,616"/>
3322.1.13 by Stuart Bishop
Update database diagrams
220
</g>
3691.17.2 by Stuart Bishop
Update database diagrams
221
<g id="node20" class="node"><title>fake_language_203</title>
3322.1.14 by Stuart Bishop
Update database diagrams
222
<ellipse cx="33" cy="827" rx="27" ry="18" style="fill:none;stroke:red;"/>
223
<text text-anchor="middle" style="font-size:8.00;" x="33" y="830">language</text>
3322.1.13 by Stuart Bishop
Update database diagrams
224
</g>
3691.17.2 by Stuart Bishop
Update database diagrams
225
<g id="edge22" class="edge"><title>person&#45;&gt;fake_language_203</title>
226
<path style="fill:none;stroke:black;" d="M198,782C150,796 100,809 68,817"/>
3322.1.14 by Stuart Bishop
Update database diagrams
227
<polygon style="fill:black;stroke:black;" points="69,820 58,820 67,814 69,820"/>
3322.1.13 by Stuart Bishop
Update database diagrams
228
</g>
3691.17.2 by Stuart Bishop
Update database diagrams
229
<g id="node23" class="node"><title>fake_calendar_206</title>
230
<ellipse cx="127" cy="978" rx="27" ry="18" style="fill:none;stroke:red;"/>
231
<text text-anchor="middle" style="font-size:8.00;" x="127" y="981">calendar</text>
232
</g>
233
<g id="edge26" class="edge"><title>person&#45;&gt;fake_calendar_206</title>
234
<path style="fill:none;stroke:black;" d="M198,898C179,920 161,940 148,954"/>
235
<polygon style="fill:black;stroke:black;" points="150,957 141,962 145,952 150,957"/>
236
</g>
237
<g id="node25" class="node"><title>fake_country_208</title>
238
<ellipse cx="44" cy="634" rx="27" ry="18" style="fill:none;stroke:red;"/>
239
<text text-anchor="middle" style="font-size:8.00;" x="44" y="637">country</text>
240
</g>
241
<g id="edge28" class="edge"><title>person&#45;&gt;fake_country_208</title>
242
<path style="fill:none;stroke:black;" d="M198,692C153,675 107,658 78,647"/>
243
<polygon style="fill:black;stroke:black;" points="76,650 68,643 79,643 76,650"/>
244
</g>
245
<g id="node27" class="node"><title>fake_libraryfilealias_210</title>
246
<ellipse cx="287" cy="1061" rx="35" ry="18" style="fill:none;stroke:red;"/>
247
<text text-anchor="middle" style="font-size:8.00;" x="287" y="1064">libraryfilealias</text>
248
</g>
249
<g id="edge30" class="edge"><title>person&#45;&gt;fake_libraryfilealias_210</title>
250
<path style="fill:none;stroke:black;" d="M304,947C299,981 294,1012 291,1033"/>
251
<polygon style="fill:black;stroke:black;" points="294,1033 290,1043 288,1033 294,1033"/>
252
</g>
253
<g id="node29" class="node"><title>fake_libraryfilealias_212</title>
254
<ellipse cx="479" cy="1027" rx="35" ry="18" style="fill:none;stroke:red;"/>
255
<text text-anchor="middle" style="font-size:8.00;" x="479" y="1030">libraryfilealias</text>
256
</g>
257
<g id="edge32" class="edge"><title>person&#45;&gt;fake_libraryfilealias_212</title>
258
<path style="fill:none;stroke:black;" d="M438,947C449,967 458,986 465,1000"/>
259
<polygon style="fill:black;stroke:black;" points="468,999 470,1009 462,1002 468,999"/>
1681.1.131 by Stuart Bishop
Update diagrams
260
</g>
261
<g id="node6" class="node"><title>productbounty</title>
3691.17.2 by Stuart Bishop
Update database diagrams
262
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="821,277 821,215 1007,215 1007,277 821,277"/>
263
<polygon style="fill:white;stroke:white;" points="824,232 824,218 1004,218 1004,232 824,232"/>
264
<text text-anchor="middle" style="font-size:8.00;" x="914" y="228">productbounty</text>
265
<polygon style="fill:none;stroke:black;" points="824,232 824,218 1004,218 1004,232 824,232"/>
266
<text text-anchor="middle" style="font-size:8.00;" x="830" y="243">id</text>
267
<text text-anchor="middle" style="font-size:8.00;" x="867" y="243">serial</text>
268
<text text-anchor="middle" style="font-size:8.00;" x="918" y="243"> PRIMARY KEY </text>
269
<text text-anchor="middle" style="font-size:8.00;" x="838" y="257">bounty</text>
270
<text text-anchor="middle" style="font-size:8.00;" x="870" y="257">integer</text>
271
<text text-anchor="middle" style="font-size:8.00;" x="944" y="257"> REFERENCES bounty UNIQUE </text>
272
<text text-anchor="middle" style="font-size:8.00;" x="839" y="271">product</text>
273
<text text-anchor="middle" style="font-size:8.00;" x="870" y="271">integer</text>
274
<text text-anchor="middle" style="font-size:8.00;" x="945" y="271"> UNIQUE REFERENCES product </text>
275
<polygon style="fill:none;stroke:black;" points="821,277 821,215 1007,215 1007,277 821,277"/>
1681.1.131 by Stuart Bishop
Update diagrams
276
</g>
277
<g id="edge34" class="edge"><title>productbounty&#45;&gt;bounty</title>
3691.17.2 by Stuart Bishop
Update database diagrams
278
<path style="fill:none;stroke:black;" d="M846,281C819,296 786,313 754,329"/>
279
<polygon style="fill:black;stroke:black;" points="755,332 745,334 752,326 755,332"/>
280
</g>
281
<g id="node32" class="node"><title>fake_product_278</title>
282
<ellipse cx="1060" cy="164" rx="27" ry="18" style="fill:none;stroke:red;"/>
283
<text text-anchor="middle" style="font-size:8.00;" x="1060" y="167">product</text>
284
</g>
285
<g id="edge36" class="edge"><title>productbounty&#45;&gt;fake_product_278</title>
286
<path style="fill:none;stroke:black;" d="M976,211C995,201 1015,190 1030,181"/>
287
<polygon style="fill:black;stroke:black;" points="1029,178 1039,176 1032,184 1029,178"/>
1681.1.131 by Stuart Bishop
Update diagrams
288
</g>
289
<g id="node7" class="node"><title>projectbounty</title>
3691.17.2 by Stuart Bishop
Update database diagrams
290
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="356,186 356,124 538,124 538,186 356,186"/>
291
<polygon style="fill:white;stroke:white;" points="359,141 359,127 535,127 535,141 359,141"/>
292
<text text-anchor="middle" style="font-size:8.00;" x="447" y="137">projectbounty</text>
293
<polygon style="fill:none;stroke:black;" points="359,141 359,127 535,127 535,141 359,141"/>
294
<text text-anchor="middle" style="font-size:8.00;" x="365" y="152">id</text>
295
<text text-anchor="middle" style="font-size:8.00;" x="400" y="152">serial</text>
296
<text text-anchor="middle" style="font-size:8.00;" x="451" y="152"> PRIMARY KEY </text>
297
<text text-anchor="middle" style="font-size:8.00;" x="373" y="166">bounty</text>
298
<text text-anchor="middle" style="font-size:8.00;" x="403" y="166">integer</text>
299
<text text-anchor="middle" style="font-size:8.00;" x="477" y="166"> REFERENCES bounty UNIQUE </text>
300
<text text-anchor="middle" style="font-size:8.00;" x="373" y="180">project</text>
301
<text text-anchor="middle" style="font-size:8.00;" x="403" y="180">integer</text>
302
<text text-anchor="middle" style="font-size:8.00;" x="477" y="180"> UNIQUE REFERENCES project </text>
303
<polygon style="fill:none;stroke:black;" points="356,186 356,124 538,124 538,186 356,186"/>
1681.1.131 by Stuart Bishop
Update diagrams
304
</g>
305
<g id="edge38" class="edge"><title>projectbounty&#45;&gt;bounty</title>
3691.17.2 by Stuart Bishop
Update database diagrams
306
<path style="fill:none;stroke:black;" d="M477,190C494,211 518,239 541,267"/>
307
<polygon style="fill:black;stroke:black;" points="544,265 548,275 539,270 544,265"/>
3322.1.13 by Stuart Bishop
Update database diagrams
308
</g>
3691.17.2 by Stuart Bishop
Update database diagrams
309
<g id="node35" class="node"><title>fake_project_300</title>
3322.1.14 by Stuart Bishop
Update database diagrams
310
<ellipse cx="349" cy="23" rx="27" ry="18" style="fill:none;stroke:red;"/>
311
<text text-anchor="middle" style="font-size:8.00;" x="349" y="26">project</text>
3322.1.13 by Stuart Bishop
Update database diagrams
312
</g>
3691.17.2 by Stuart Bishop
Update database diagrams
313
<g id="edge40" class="edge"><title>projectbounty&#45;&gt;fake_project_300</title>
314
<path style="fill:none;stroke:black;" d="M421,120C404,97 382,68 367,47"/>
3322.1.14 by Stuart Bishop
Update database diagrams
315
<polygon style="fill:black;stroke:black;" points="364,49 361,39 370,45 364,49"/>
1776 by Canonical.com Patch Queue Manager
[trivial] various fixes that didn't merge before (network?) and new db diagrams
316
</g>
317
</g>
318
</svg>