Page MenuHomePhabricator
Paste P8151

(An Untitled Masterwork)
ActivePublic

Authored by Henwilwal on Mar 4 2019, 5:41 PM.
Tags
None
Referenced Files
F28326228: raw.txt
Mar 4 2019, 9:02 PM
F28325366: raw.txt
Mar 4 2019, 5:41 PM
Subscribers
None
mysql> SELECT argos_revision.*, HEX(rev_sha1) FROM argos_page JOIN argos_revision ON (rev_id = page_latest) WHERE page_namespace=6 AND page_title='ModelServer_documentation.pdf';
+--------+----------+-------------+---------------------------------------------------------------------+----------+---------------+----------------+----------------+-------------+---------+---------------+---------------------------------+--------------------+-------------------+----------------------------------------------------------------+
| rev_id | rev_page | rev_text_id | rev_comment | rev_user | rev_user_text | rev_timestamp | rev_minor_edit | rev_deleted | rev_len | rev_parent_id | rev_sha1 | rev_content_format | rev_content_model | HEX(rev_sha1) |
+--------+----------+-------------+---------------------------------------------------------------------+----------+---------------+----------------+----------------+-------------+---------+---------------+---------------------------------+--------------------+-------------------+----------------------------------------------------------------+
| 6274 | 859 | 3271 | uploaded a new version of "[[Image:ModelServer documentation.pdf]]" | 13 | Jan | 20170621094222 | 0 | 0 | 0 | 4088 | phoiac9h4m842xq45sp7s6u21eteeq1 | NULL | NULL | 70686F6961633968346D383432787134357370377336753231657465657131 |
+--------+----------+-------------+---------------------------------------------------------------------+----------+---------------+----------------+----------------+-------------+---------+---------------+---------------------------------+--------------------+-------------------+----------------------------------------------------------------+
1 row in set (0.02 sec)
mysql> SELECT argos_slots.*, argos_content.*, HEX(content_sha1) FROM argos_slots LEFT JOIN argos_content ON ( content_id = slot_content_id) WHERE slot_revision_id = 6274;
+------------------+--------------+-----------------+-------------+------------+--------------+--------------+---------------+-----------------+-------------------+
| slot_revision_id | slot_role_id | slot_content_id | slot_origin | content_id | content_size | content_sha1 | content_model | content_address | HEX(content_sha1) |
+------------------+--------------+-----------------+-------------+------------+--------------+--------------+---------------+-----------------+-------------------+
| 6274 | 1 | 5712 | 6274 | 5712 | 0 | | 1 | tt:3271 | |
+------------------+--------------+-----------------+-------------+------------+--------------+--------------+---------------+-----------------+-------------------+
1 row in set (0.03 sec)