file
5 rows where patch_id = 2542
This data as json, CSV (advanced)
id ▼ | patch_id | filename |
---|---|---|
12921 | 2542 2542 | includes/OutputPage.php |
12922 | 2542 2542 | includes/api/ApiParse.php |
12923 | 2542 2542 | includes/skins/Skin.php |
12924 | 2542 2542 | tests/phpunit/includes/api/ApiParseTest.php |
12925 | 2542 2542 | tests/phpunit/includes/skins/SkinTest.php |
Advanced export
JSON shape: default, array, newline-delimited, object
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);