Revision history for Data Dumps

UserDateBody
Rainbow Dash <div class="walloftext"> <p> To meet the requests of archivers, statisticians, and data analysts alike, Derpibooru provides data dumps on a nightly basis. These data consist only of publicly accessible database contents. These dumps are provided in <code>pg_dump</code>&apos;s custom format, and are created using PostgreSQL 13.3. </p> <p> To load an entire dump (requires 29 GB of free storage): </p> <pre> dropdb --if-exists derpibooru createdb derpibooru pg_restore -O -d derpibooru derpibooru_public_dump_2021_09_23.pgdump </pre> <p> This will create the database <code>derpibooru</code> with the following table layout: </p> <h3>public.artist_links</h3> <table class="table"> <thead> <tr> <th>Name</th> <th>Type</th> <th>Nullable?</th> </tr> </thead> <tbody> <tr> <td>id</td> <td>bigint</td> <td></td> </tr> <tr> <td>user_id</td> <td>bigint</td> <td></td> </tr> <tr> <td>tag_id</td> <td>bigint</td> <td></td> </tr> <tr> <td>url</td> <td>text</td> <td></td> </tr> </tbody> </table> <h3>public.badge_awards</h3> <table class="table"> <thead> <tr> <th>Name</th> <th>Type</th> <th>Nullable?</th> </tr> </thead> <tbody> <tr> <td>id</td> <td>bigint</td> <td></td> </tr> <tr> <td>user_id</td> <td>bigint</td> <td></td> </tr> <tr> <td>badge_id</td> <td>bigint</td> <td></td> </tr> <tr> <td>created_at</td> <td>timestamp</td> <td></td> </tr> <tr> <td>label</td> <td>text</td> <td>&#x2714;</td> </tr> </tbody> </table> <h3>public.badges</h3> <table class="table"> <thead> <tr> <th>Name</th> <th>Type</th> <th>Nullable?</th> </tr> </thead> <tbody> <tr> <td>id</td> <td>bigint</td> <td></td> </tr> <tr> <td>title</td> <td>text</td> <td></td> </tr> <tr> <td>description</td> <td>text</td> <td></td> </tr> <tr> <td>image_url</td> <td>text</td> <td></td> </tr> </tbody> </table> <h3>public.comments</h3> <table class="table"> <thead> <tr> <th>Name</th> <th>Type</th> <th>Nullable?</th> </tr> </thead> <tbody> <tr> <td>id</td> <td>bigint</td> <td></td> </tr> <tr> <td>image_id</td> <td>bigint</td> <td></td> </tr> <tr> <td>created_at</td> <td>timestamp</td> <td></td> </tr> <tr> <td>updated_at</td> <td>timestamp</td> <td></td> </tr> <tr> <td>user_id</td> <td>bigint</td> <td>&#x2714;</td> </tr> <tr> <td>body</td> <td>text</td> <td></td> </tr> </tbody> </table> <h3>public.duplicate_reports</h3> <table class="table"> <thead> <tr> <th>Name</th> <th>Type</th> <th>Nullable?</th> </tr> </thead> <tbody> <tr> <td>id</td> <td>bigint</td> <td></td> </tr> <tr> <td>image_id</td> <td>bigint</td> <td></td> </tr> <tr> <td>duplicate_of_image_id</td> <td>bigint</td> <td></td> </tr> <tr> <td>created_at</td> <td>timestamp</td> <td></td> </tr> <tr> <td>updated_at</td> <td>timestamp</td> <td></td> </tr> <tr> <td>user_id</td> <td>bigint</td> <td>&#x2714;</td> </tr> <tr> <td>state</td> <td>text</td> <td></td> </tr> <tr> <td>reason</td> <td>text</td> <td>&#x2714;</td> </tr> </tbody> </table> <h3>public.forums</h3> <table class="table"> <thead> <tr> <th>Name</th> <th>Type</th> <th>Nullable?</th> </tr> </thead> <tbody> <tr> <td>id</td> <td>bigint</td> <td></td> </tr> <tr> <td>topic_count</td> <td>bigint</td> <td></td> </tr> <tr> <td>post_count</td> <td>bigint</td> <td></td> </tr> <tr> <td>created_at</td> <td>timestamp</td> <td></td> </tr> <tr> <td>updated_at</td> <td>timestamp</td> <td></td> </tr> <tr> <td>name</td> <td>text</td> <td></td> </tr> <tr> <td>short_name</td> <td>text</td> <td></td> </tr> <tr> <td>description</td> <td>text</td> <td></td> </tr> </tbody> </table> <h3>public.galleries</h3> <table class="table"> <thead> <tr> <th>Name</th> <th>Type</th> <th>Nullable?</th> </tr> </thead> <tbody> <tr> <td>id</td> <td>bigint</td> <td></td> </tr> <tr> <td>thumbnail_id</td> <td>bigint</td> <td></td> </tr> <tr> <td>user_id</td> <td>bigint</td> <td></td> </tr> <tr> <td>image_count</td> <td>bigint</td> <td></td> </tr> <tr> <td>created_at</td> <td>timestamp</td> <td></td> </tr> <tr> <td>updated_at</td> <td>timestamp</td> <td></td> </tr> <tr> <td>title</td> <td>text</td> <td></td> </tr> <tr> <td>spoiler_warning</td> <td>text</td> <td></td> </tr> <tr> <td>description</td> <td>text</td> <td></td> </tr> </tbody> </table> <h3>public.gallery_interactions</h3> <table class="table"> <thead> <tr> <th>Name</th> <th>Type</th> <th>Nullable?</th> </tr> </thead> <tbody> <tr> <td>image_id</td> <td>bigint</td> <td></td> </tr> <tr> <td>gallery_id</td> <td>bigint</td> <td></td> </tr> <tr> <td>position</td> <td>integer</td> <td></td> </tr> </tbody> </table> <h3>public.image_duplicates</h3> <table class="table"> <thead> <tr> <th>Name</th> <th>Type</th> <th>Nullable?</th> </tr> </thead> <tbody> <tr> <td>image_id</td> <td>bigint</td> <td></td> </tr> <tr> <td>target_id</td> <td>bigint</td> <td></td> </tr> </tbody> </table> <h3>public.image_faves</h3> <table class="table"> <thead> <tr> <th>Name</th> <th>Type</th> <th>Nullable?</th> </tr> </thead> <tbody> <tr> <td>image_id</td> <td>bigint</td> <td></td> </tr> <tr> <td>user_id</td> <td>bigint</td> <td></td> </tr> <tr> <td>created_at</td> <td>timestamp</td> <td></td> </tr> </tbody> </table> <h3>public.image_features</h3> <table class="table"> <thead> <tr> <th>Name</th> <th>Type</th> <th>Nullable?</th> </tr> </thead> <tbody> <tr> <td>image_id</td> <td>bigint</td> <td></td> </tr> <tr> <td>created_at</td> <td>timestamp</td> <td></td> </tr> </tbody> </table> <h3>public.image_intensities</h3> <table class="table"> <thead> <tr> <th>Name</th> <th>Type</th> <th>Nullable?</th> </tr> </thead> <tbody> <tr> <td>image_id</td> <td>bigint</td> <td></td> </tr> <tr> <td>nw_intensity</td> <td>double precision</td> <td></td> </tr> <tr> <td>ne_intensity</td> <td>double precision</td> <td></td> </tr> <tr> <td>sw_intensity</td> <td>double precision</td> <td></td> </tr> <tr> <td>se_intensity</td> <td>double precision</td> <td></td> </tr> <tr> <td>avg_intensity</td> <td>double precision</td> <td></td> </tr> </tbody> </table> <h3>public.image_sources</h3> <table class="table"> <thead> <tr> <th>Name</th> <th>Type</th> <th>Nullable?</th> </tr> </thead> <tbody> <tr> <td>image_id</td> <td>bigint</td> <td></td> </tr> <tr> <td>source</td> <td>text</td> <td></td> </tr> </tbody> </table> <h3>public.image_taggings</h3> <table class="table"> <thead> <tr> <th>Name</th> <th>Type</th> <th>Nullable?</th> </tr> </thead> <tbody> <tr> <td>image_id</td> <td>bigint</td> <td></td> </tr> <tr> <td>tag_id</td> <td>bigint</td> <td></td> </tr> </tbody> </table> <h3>public.images</h3> <table class="table"> <thead> <tr> <th>Name</th> <th>Type</th> <th>Nullable?</th> </tr> </thead> <tbody> <tr> <td>id</td> <td>bigint</td> <td></td> </tr> <tr> <td>created_at</td> <td>timestamp</td> <td></td> </tr> <tr> <td>updated_at</td> <td>timestamp</td> <td></td> </tr> <tr> <td>image_width</td> <td>integer</td> <td></td> </tr> <tr> <td>image_height</td> <td>integer</td> <td></td> </tr> <tr> <td>image_size</td> <td>integer</td> <td></td> </tr> <tr> <td>comment_count</td> <td>integer</td> <td></td> </tr> <tr> <td>score</td> <td>integer</td> <td></td> </tr> <tr> <td>favorites</td> <td>integer</td> <td></td> </tr> <tr> <td>upvotes</td> <td>integer</td> <td></td> </tr> <tr> <td>downvotes</td> <td>integer</td> <td></td> </tr> <tr> <td>hides</td> <td>integer</td> <td></td> </tr> <tr> <td>image_aspect_ratio</td> <td>double precision</td> <td></td> </tr> <tr> <td>user_id</td> <td>bigint</td> <td>&#x2714;</td> </tr> <tr> <td>image_mime_type</td> <td>text</td> <td></td> </tr> <tr> <td>image_format</td> <td>text</td> <td></td> </tr> <tr> <td>image_name</td> <td>text</td> <td></td> </tr> <tr> <td>version_path</td> <td>text</td> <td></td> </tr> <tr> <td>image_sha512_hash</td> <td>text</td> <td>&#x2714;</td> </tr> <tr> <td>image_orig_sha512_hash</td> <td>text</td> <td>&#x2714;</td> </tr> </tbody> </table> <h3>public.posts</h3> <table class="table"> <thead> <tr> <th>Name</th> <th>Type</th> <th>Nullable?</th> </tr> </thead> <tbody> <tr> <td>id</td> <td>bigint</td> <td></td> </tr> <tr> <td>topic_id</td> <td>bigint</td> <td></td> </tr> <tr> <td>created_at</td> <td>timestamp</td> <td></td> </tr> <tr> <td>updated_at</td> <td>timestamp</td> <td></td> </tr> <tr> <td>user_id</td> <td>bigint</td> <td>&#x2714;</td> </tr> <tr> <td>body</td> <td>text</td> <td></td> </tr> </tbody> </table> <h3>public.source_changes</h3> <table class="table"> <thead> <tr> <th>Name</th> <th>Type</th> <th>Nullable?</th> </tr> </thead> <tbody> <tr> <td>id</td> <td>bigint</td> <td></td> </tr> <tr> <td>image_id</td> <td>bigint</td> <td></td> </tr> <tr> <td>created_at</td> <td>timestamp</td> <td></td> </tr> <tr> <td>updated_at</td> <td>timestamp</td> <td></td> </tr> <tr> <td>user_id</td> <td>bigint</td> <td>&#x2714;</td> </tr> <tr> <td>new_value</td> <td>text</td> <td></td> </tr> </tbody> </table> <h3>public.tag_aliases</h3> <table class="table"> <thead> <tr> <th>Name</th> <th>Type</th> <th>Nullable?</th> </tr> </thead> <tbody> <tr> <td>tag_id</td> <td>bigint</td> <td></td> </tr> <tr> <td>target_tag_id</td> <td>bigint</td> <td></td> </tr> </tbody> </table> <h3>public.tag_changes</h3> <table class="table"> <thead> <tr> <th>Name</th> <th>Type</th> <th>Nullable?</th> </tr> </thead> <tbody> <tr> <td>id</td> <td>bigint</td> <td></td> </tr> <tr> <td>image_id</td> <td>bigint</td> <td></td> </tr> <tr> <td>created_at</td> <td>timestamp</td> <td></td> </tr> <tr> <td>updated_at</td> <td>timestamp</td> <td></td> </tr> <tr> <td>user_id</td> <td>bigint</td> <td>&#x2714;</td> </tr> <tr> <td>tag_id</td> <td>bigint</td> <td>&#x2714;</td> </tr> <tr> <td>added</td> <td>boolean</td> <td></td> </tr> <tr> <td>tag_name_cache</td> <td>text</td> <td></td> </tr> </tbody> </table> <h3>public.tag_implications</h3> <table class="table"> <thead> <tr> <th>Name</th> <th>Type</th> <th>Nullable?</th> </tr> </thead> <tbody> <tr> <td>tag_id</td> <td>bigint</td> <td></td> </tr> <tr> <td>target_tag_id</td> <td>bigint</td> <td></td> </tr> </tbody> </table> <h3>public.tags</h3> <table class="table"> <thead> <tr> <th>Name</th> <th>Type</th> <th>Nullable?</th> </tr> </thead> <tbody> <tr> <td>id</td> <td>bigint</td> <td></td> </tr> <tr> <td>image_count</td> <td>bigint</td> <td></td> </tr> <tr> <td>name</td> <td>text</td> <td></td> </tr> <tr> <td>slug</td> <td>text</td> <td></td> </tr> <tr> <td>category</td> <td>text</td> <td>&#x2714;</td> </tr> <tr> <td>description</td> <td>text</td> <td>&#x2714;</td> </tr> <tr> <td>short_description</td> <td>text</td> <td>&#x2714;</td> </tr> </tbody> </table> <h3>public.topics</h3> <table class="table"> <thead> <tr> <th>Name</th> <th>Type</th> <th>Nullable?</th> </tr> </thead> <tbody> <tr> <td>id</td> <td>bigint</td> <td></td> </tr> <tr> <td>forum_id</td> <td>bigint</td> <td></td> </tr> <tr> <td>post_count</td> <td>bigint</td> <td></td> </tr> <tr> <td>view_count</td> <td>bigint</td> <td></td> </tr> <tr> <td>created_at</td> <td>timestamp</td> <td></td> </tr> <tr> <td>updated_at</td> <td>timestamp</td> <td></td> </tr> <tr> <td>sticky</td> <td>boolean</td> <td></td> </tr> <tr> <td>locked</td> <td>boolean</td> <td></td> </tr> <tr> <td>title</td> <td>text</td> <td></td> </tr> <tr> <td>slug</td> <td>text</td> <td></td> </tr> </tbody> </table> <h3>public.users</h3> <table class="table"> <thead> <tr> <th>Name</th> <th>Type</th> <th>Nullable?</th> </tr> </thead> <tbody> <tr> <td>id</td> <td>bigint</td> <td></td> </tr> <tr> <td>name</td> <td>text</td> <td></td> </tr> </tbody> </table> <p> Finer granularity over the imported data can be controlled with <code>pg_restore</code> flags; see <a href="https://www.postgresql.org/docs/current/app-pgrestore.html">the documentation</a> for more detail. </p> <h3>Download</h3> <table class="table"> <thead> <tr> <th>Size</th> <th>Link</th> <th>SHA-256</th> </tr> </thead> <tbody> <tr> <td>3.5G</td> <td><a href="https://data.derpicdn.net/file/derpibooru-data/derpibooru_public_dump_2021_09_23.pgdump">derpibooru_public_dump_2021_09_23.pgdump</a></td> <td>ce09ef855d390114d5d8db42a1f1b69099d44b9475512f19bfa8c5da9b1f8cc9</td> </tr> </tbody> </table> <p> Note: these dumps do not include images. </p> </div> <div class="walloftext"> <p> To meet the requests of archivers, statisticians, and data analysts alike, Derpibooru provides data dumps on a nightly basis. These data consist only of publicly accessible database contents. These dumps are provided in <code>pg_dump</code>&apos;s custom format, and are created using latest PostgreSQL 15.x. </p> <p> To load an entire dump (requires 39 GB of free storage): </p> <pre> dropdb --if-exists derpibooru createdb derpibooru pg_restore -O -d derpibooru derpibooru_public_dump_2024_06_22.pgdump </pre> <p> This will create the database <code>derpibooru</code> with the following table layout: </p> <h3>public.artist_links</h3> <table class="table"> <thead> <tr> <th>Name</th> <th>Type</th> <th>Nullable?</th> </tr> </thead> <tbody> <tr> <td>id</td> <td>bigint</td> <td></td> </tr> <tr> <td>user_id</td> <td>bigint</td> <td></td> </tr> <tr> <td>tag_id</td> <td>bigint</td> <td></td> </tr> <tr> <td>url</td> <td>text</td> <td></td> </tr> </tbody> </table> <h3>public.badge_awards</h3> <table class="table"> <thead> <tr> <th>Name</th> <th>Type</th> <th>Nullable?</th> </tr> </thead> <tbody> <tr> <td>id</td> <td>bigint</td> <td></td> </tr> <tr> <td>user_id</td> <td>bigint</td> <td></td> </tr> <tr> <td>badge_id</td> <td>bigint</td> <td></td> </tr> <tr> <td>created_at</td> <td>timestamp</td> <td></td> </tr> <tr> <td>label</td> <td>text</td> <td>&#x2714;</td> </tr> </tbody> </table> <h3>public.badges</h3> <table class="table"> <thead> <tr> <th>Name</th> <th>Type</th> <th>Nullable?</th> </tr> </thead> <tbody> <tr> <td>id</td> <td>bigint</td> <td></td> </tr> <tr> <td>title</td> <td>text</td> <td></td> </tr> <tr> <td>description</td> <td>text</td> <td></td> </tr> <tr> <td>image_url</td> <td>text</td> <td></td> </tr> </tbody> </table> <h3>public.comments</h3> <table class="table"> <thead> <tr> <th>Name</th> <th>Type</th> <th>Nullable?</th> </tr> </thead> <tbody> <tr> <td>id</td> <td>bigint</td> <td></td> </tr> <tr> <td>image_id</td> <td>bigint</td> <td></td> </tr> <tr> <td>created_at</td> <td>timestamp</td> <td></td> </tr> <tr> <td>updated_at</td> <td>timestamp</td> <td></td> </tr> <tr> <td>user_id</td> <td>bigint</td> <td>&#x2714;</td> </tr> <tr> <td>body</td> <td>text</td> <td></td> </tr> </tbody> </table> <h3>public.duplicate_reports</h3> <table class="table"> <thead> <tr> <th>Name</th> <th>Type</th> <th>Nullable?</th> </tr> </thead> <tbody> <tr> <td>id</td> <td>bigint</td> <td></td> </tr> <tr> <td>image_id</td> <td>bigint</td> <td></td> </tr> <tr> <td>duplicate_of_image_id</td> <td>bigint</td> <td></td> </tr> <tr> <td>created_at</td> <td>timestamp</td> <td></td> </tr> <tr> <td>updated_at</td> <td>timestamp</td> <td></td> </tr> <tr> <td>user_id</td> <td>bigint</td> <td>&#x2714;</td> </tr> <tr> <td>state</td> <td>text</td> <td></td> </tr> <tr> <td>reason</td> <td>text</td> <td>&#x2714;</td> </tr> </tbody> </table> <h3>public.forums</h3> <table class="table"> <thead> <tr> <th>Name</th> <th>Type</th> <th>Nullable?</th> </tr> </thead> <tbody> <tr> <td>id</td> <td>bigint</td> <td></td> </tr> <tr> <td>topic_count</td> <td>bigint</td> <td></td> </tr> <tr> <td>post_count</td> <td>bigint</td> <td></td> </tr> <tr> <td>created_at</td> <td>timestamp</td> <td></td> </tr> <tr> <td>updated_at</td> <td>timestamp</td> <td></td> </tr> <tr> <td>name</td> <td>text</td> <td></td> </tr> <tr> <td>short_name</td> <td>text</td> <td></td> </tr> <tr> <td>description</td> <td>text</td> <td></td> </tr> </tbody> </table> <h3>public.galleries</h3> <table class="table"> <thead> <tr> <th>Name</th> <th>Type</th> <th>Nullable?</th> </tr> </thead> <tbody> <tr> <td>id</td> <td>bigint</td> <td></td> </tr> <tr> <td>thumbnail_id</td> <td>bigint</td> <td></td> </tr> <tr> <td>user_id</td> <td>bigint</td> <td></td> </tr> <tr> <td>image_count</td> <td>bigint</td> <td></td> </tr> <tr> <td>created_at</td> <td>timestamp</td> <td></td> </tr> <tr> <td>updated_at</td> <td>timestamp</td> <td></td> </tr> <tr> <td>title</td> <td>text</td> <td></td> </tr> <tr> <td>spoiler_warning</td> <td>text</td> <td></td> </tr> <tr> <td>description</td> <td>text</td> <td></td> </tr> </tbody> </table> <h3>public.gallery_interactions</h3> <table class="table"> <thead> <tr> <th>Name</th> <th>Type</th> <th>Nullable?</th> </tr> </thead> <tbody> <tr> <td>image_id</td> <td>bigint</td> <td></td> </tr> <tr> <td>gallery_id</td> <td>bigint</td> <td></td> </tr> <tr> <td>position</td> <td>integer</td> <td></td> </tr> </tbody> </table> <h3>public.image_duplicates</h3> <table class="table"> <thead> <tr> <th>Name</th> <th>Type</th> <th>Nullable?</th> </tr> </thead> <tbody> <tr> <td>image_id</td> <td>bigint</td> <td></td> </tr> <tr> <td>target_id</td> <td>bigint</td> <td></td> </tr> </tbody> </table> <h3>public.image_faves</h3> <table class="table"> <thead> <tr> <th>Name</th> <th>Type</th> <th>Nullable?</th> </tr> </thead> <tbody> <tr> <td>image_id</td> <td>bigint</td> <td></td> </tr> <tr> <td>user_id</td> <td>bigint</td> <td></td> </tr> <tr> <td>created_at</td> <td>timestamp</td> <td></td> </tr> </tbody> </table> <h3>public.image_features</h3> <table class="table"> <thead> <tr> <th>Name</th> <th>Type</th> <th>Nullable?</th> </tr> </thead> <tbody> <tr> <td>image_id</td> <td>bigint</td> <td></td> </tr> <tr> <td>created_at</td> <td>timestamp</td> <td></td> </tr> </tbody> </table> <h3>public.image_intensities</h3> <table class="table"> <thead> <tr> <th>Name</th> <th>Type</th> <th>Nullable?</th> </tr> </thead> <tbody> <tr> <td>image_id</td> <td>bigint</td> <td></td> </tr> <tr> <td>nw_intensity</td> <td>double precision</td> <td></td> </tr> <tr> <td>ne_intensity</td> <td>double precision</td> <td></td> </tr> <tr> <td>sw_intensity</td> <td>double precision</td> <td></td> </tr> <tr> <td>se_intensity</td> <td>double precision</td> <td></td> </tr> <tr> <td>avg_intensity</td> <td>double precision</td> <td></td> </tr> </tbody> </table> <h3>public.image_sources</h3> <table class="table"> <thead> <tr> <th>Name</th> <th>Type</th> <th>Nullable?</th> </tr> </thead> <tbody> <tr> <td>image_id</td> <td>bigint</td> <td></td> </tr> <tr> <td>source</td> <td>text</td> <td></td> </tr> </tbody> </table> <h3>public.image_taggings</h3> <table class="table"> <thead> <tr> <th>Name</th> <th>Type</th> <th>Nullable?</th> </tr> </thead> <tbody> <tr> <td>image_id</td> <td>bigint</td> <td></td> </tr> <tr> <td>tag_id</td> <td>bigint</td> <td></td> </tr> </tbody> </table> <h3>public.images</h3> <table class="table"> <thead> <tr> <th>Name</th> <th>Type</th> <th>Nullable?</th> </tr> </thead> <tbody> <tr> <td>id</td> <td>bigint</td> <td></td> </tr> <tr> <td>created_at</td> <td>timestamp</td> <td></td> </tr> <tr> <td>updated_at</td> <td>timestamp</td> <td></td> </tr> <tr> <td>image_width</td> <td>integer</td> <td></td> </tr> <tr> <td>image_height</td> <td>integer</td> <td></td> </tr> <tr> <td>image_size</td> <td>integer</td> <td></td> </tr> <tr> <td>comment_count</td> <td>integer</td> <td></td> </tr> <tr> <td>score</td> <td>integer</td> <td></td> </tr> <tr> <td>favorites</td> <td>integer</td> <td></td> </tr> <tr> <td>upvotes</td> <td>integer</td> <td></td> </tr> <tr> <td>downvotes</td> <td>integer</td> <td></td> </tr> <tr> <td>hides</td> <td>integer</td> <td></td> </tr> <tr> <td>image_aspect_ratio</td> <td>double precision</td> <td></td> </tr> <tr> <td>user_id</td> <td>bigint</td> <td>&#x2714;</td> </tr> <tr> <td>image_mime_type</td> <td>text</td> <td></td> </tr> <tr> <td>image_format</td> <td>text</td> <td></td> </tr> <tr> <td>image_name</td> <td>text</td> <td></td> </tr> <tr> <td>version_path</td> <td>text</td> <td></td> </tr> <tr> <td>image_sha512_hash</td> <td>text</td> <td>&#x2714;</td> </tr> <tr> <td>image_orig_sha512_hash</td> <td>text</td> <td>&#x2714;</td> </tr> </tbody> </table> <h3>public.posts</h3> <table class="table"> <thead> <tr> <th>Name</th> <th>Type</th> <th>Nullable?</th> </tr> </thead> <tbody> <tr> <td>id</td> <td>bigint</td> <td></td> </tr> <tr> <td>topic_id</td> <td>bigint</td> <td></td> </tr> <tr> <td>created_at</td> <td>timestamp</td> <td></td> </tr> <tr> <td>updated_at</td> <td>timestamp</td> <td></td> </tr> <tr> <td>user_id</td> <td>bigint</td> <td>&#x2714;</td> </tr> <tr> <td>body</td> <td>text</td> <td></td> </tr> </tbody> </table> <h3>public.source_changes</h3> <table class="table"> <thead> <tr> <th>Name</th> <th>Type</th> <th>Nullable?</th> </tr> </thead> <tbody> <tr> <td>id</td> <td>bigint</td> <td></td> </tr> <tr> <td>image_id</td> <td>bigint</td> <td></td> </tr> <tr> <td>created_at</td> <td>timestamp</td> <td></td> </tr> <tr> <td>updated_at</td> <td>timestamp</td> <td></td> </tr> <tr> <td>user_id</td> <td>bigint</td> <td>&#x2714;</td> </tr> <tr> <td>new_value</td> <td>text</td> <td></td> </tr> </tbody> </table> <h3>public.tag_aliases</h3> <table class="table"> <thead> <tr> <th>Name</th> <th>Type</th> <th>Nullable?</th> </tr> </thead> <tbody> <tr> <td>tag_id</td> <td>bigint</td> <td></td> </tr> <tr> <td>target_tag_id</td> <td>bigint</td> <td></td> </tr> </tbody> </table> <h3>public.tag_changes</h3> <table class="table"> <thead> <tr> <th>Name</th> <th>Type</th> <th>Nullable?</th> </tr> </thead> <tbody> <tr> <td>id</td> <td>bigint</td> <td></td> </tr> <tr> <td>image_id</td> <td>bigint</td> <td></td> </tr> <tr> <td>created_at</td> <td>timestamp</td> <td></td> </tr> <tr> <td>updated_at</td> <td>timestamp</td> <td></td> </tr> <tr> <td>user_id</td> <td>bigint</td> <td>&#x2714;</td> </tr> <tr> <td>tag_id</td> <td>bigint</td> <td>&#x2714;</td> </tr> <tr> <td>added</td> <td>boolean</td> <td></td> </tr> <tr> <td>tag_name_cache</td> <td>text</td> <td></td> </tr> </tbody> </table> <h3>public.tag_implications</h3> <table class="table"> <thead> <tr> <th>Name</th> <th>Type</th> <th>Nullable?</th> </tr> </thead> <tbody> <tr> <td>tag_id</td> <td>bigint</td> <td></td> </tr> <tr> <td>target_tag_id</td> <td>bigint</td> <td></td> </tr> </tbody> </table> <h3>public.tags</h3> <table class="table"> <thead> <tr> <th>Name</th> <th>Type</th> <th>Nullable?</th> </tr> </thead> <tbody> <tr> <td>id</td> <td>bigint</td> <td></td> </tr> <tr> <td>image_count</td> <td>bigint</td> <td></td> </tr> <tr> <td>name</td> <td>text</td> <td></td> </tr> <tr> <td>slug</td> <td>text</td> <td></td> </tr> <tr> <td>category</td> <td>text</td> <td>&#x2714;</td> </tr> <tr> <td>description</td> <td>text</td> <td>&#x2714;</td> </tr> <tr> <td>short_description</td> <td>text</td> <td>&#x2714;</td> </tr> </tbody> </table> <h3>public.topics</h3> <table class="table"> <thead> <tr> <th>Name</th> <th>Type</th> <th>Nullable?</th> </tr> </thead> <tbody> <tr> <td>id</td> <td>bigint</td> <td></td> </tr> <tr> <td>forum_id</td> <td>bigint</td> <td></td> </tr> <tr> <td>post_count</td> <td>bigint</td> <td></td> </tr> <tr> <td>view_count</td> <td>bigint</td> <td></td> </tr> <tr> <td>created_at</td> <td>timestamp</td> <td></td> </tr> <tr> <td>updated_at</td> <td>timestamp</td> <td></td> </tr> <tr> <td>sticky</td> <td>boolean</td> <td></td> </tr> <tr> <td>locked</td> <td>boolean</td> <td></td> </tr> <tr> <td>title</td> <td>text</td> <td></td> </tr> <tr> <td>slug</td> <td>text</td> <td></td> </tr> </tbody> </table> <h3>public.users</h3> <table class="table"> <thead> <tr> <th>Name</th> <th>Type</th> <th>Nullable?</th> </tr> </thead> <tbody> <tr> <td>id</td> <td>bigint</td> <td></td> </tr> <tr> <td>name</td> <td>text</td> <td></td> </tr> </tbody> </table> <p> Finer granularity over the imported data can be controlled with <code>pg_restore</code> flags; see <a href="https://www.postgresql.org/docs/current/app-pgrestore.html">the documentation</a> for more detail. </p> <h3>Download</h3> <table class="table"> <thead> <tr> <th>Size</th> <th>Link</th> <th>SHA-256</th> </tr> </thead> <tbody> <tr> <td>4.6G</td> <td><a href="https://files.derpicdn.net/derpibooru_public_dump_2024_06_22.pgdump">derpibooru_public_dump_2024_06_22.pgdump</a></td> <td>3fddec841ccb7a449609fe2c884cb0df9170b58aca79178608159399363c3004</td> </tr> </tbody> </table> <p> Note: these dumps do not include images. </p> </div>