home / train

file

15 rows where patch_id = 30941

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ patch_id filename
145659 30941 30941 composer.json
145660 30941 30941 composer.lock
145661 30941 30941 composer/autoload_classmap.php
145662 30941 30941 composer/autoload_psr4.php
145663 30941 30941 composer/autoload_static.php
145664 30941 30941 composer/installed.json
145665 30941 30941 stil/gd-text/.gitignore
145666 30941 30941 stil/gd-text/README.md
145667 30941 30941 stil/gd-text/composer.json
145668 30941 30941 stil/gd-text/examples/alignment.gif
145669 30941 30941 stil/gd-text/examples/debug.png
145670 30941 30941 stil/gd-text/examples/fonts.png
145671 30941 30941 stil/gd-text/examples/lineheight.gif
145672 30941 30941 stil/gd-text/src/Box.php
145673 30941 30941 stil/gd-text/src/Color.php

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE file (
            id INTEGER PRIMARY KEY,
            patch_id INTEGER NOT NULL,
            filename INTEGER NOT NULL,
            FOREIGN KEY(patch_id) REFERENCES patch(id)
        );
CREATE INDEX file_patch_id ON file(patch_id);
Powered by Datasette · Queries took 21.94ms