Baloo/Schema: Difference between revisions

(Created page with "The Blackhole database contains two tables: the contributions, and the entrypoints. == Contributions == All contribution data follows this schema: <ul> <li><code>email</code...")
 
Line 5: Line 5:
All contribution data follows this schema:
All contribution data follows this schema:
<ul>
<ul>
<li><code>guid</code>: Globally Unique Identifier of the contribution (string)</li>
<li><code>email</code>: email address of contributor (string)</li>
<li><code>email</code>: email address of contributor (string)</li>
<li><code>datetime</code>: date and time of contribution (datetime)</li>
<li><code>datetime</code>: date and time of contribution (datetime)</li>
<li><code>canonical</code>: permanent URL to contribution (string)</li>
<li><code>canonical</code>: permanent URL to contribution (string)</li>
<li><code>type</code>: a codified string that describes the contribution (string)
<li><code>source</code>: source of contribution, one of the following: (string)
<li><code>source</code>: source of contribution, one of the following: (string)
<ul><li>bugzilla</li><li>hg</li><li>sumo</li>
<ul><li>bugzilla</li><li>hg</li><li>sumo</li>
canmove, Confirmed users, Bureaucrats and Sysops emeriti
1,783

edits