file
20 rows where patch_id = 59394
This data as json, CSV (advanced)
| id ▼ | patch_id | filename |
|---|---|---|
| 272643 | 59394 59394 | .svgo.config.js |
| 272644 | 59394 59394 | Gruntfile.js |
| 272645 | 59394 59394 | package-lock.json |
| 272646 | 59394 59394 | package.json |
| 272647 | 59394 59394 | resources/src/jquery.tablesorter.styles/images/sort_both.svg |
| 272648 | 59394 59394 | resources/src/jquery.tablesorter.styles/images/sort_down.svg |
| 272649 | 59394 59394 | resources/src/jquery.tablesorter.styles/images/sort_up.svg |
| 272650 | 59394 59394 | resources/src/mediawiki.action/images/check-success.svg |
| 272651 | 59394 59394 | resources/src/mediawiki.action/images/checker.svg |
| 272652 | 59394 59394 | resources/src/mediawiki.action/images/close.svg |
| 272653 | 59394 59394 | resources/src/mediawiki.action/images/nextredirect-ltr.svg |
| 272654 | 59394 59394 | resources/src/mediawiki.action/images/nextredirect-rtl.svg |
| 272655 | 59394 59394 | resources/src/mediawiki.action/images/redirect-ltr.svg |
| 272656 | 59394 59394 | resources/src/mediawiki.action/images/redirect-rtl.svg |
| 272657 | 59394 59394 | resources/src/mediawiki.skinning/images/audio-ltr.svg |
| 272658 | 59394 59394 | resources/src/mediawiki.skinning/images/audio-rtl.svg |
| 272659 | 59394 59394 | resources/src/mediawiki.skinning/images/chat-ltr.svg |
| 272660 | 59394 59394 | resources/src/mediawiki.skinning/images/chat-rtl.svg |
| 272661 | 59394 59394 | resources/src/mediawiki.skinning/images/mail.svg |
| 272662 | 59394 59394 | resources/src/mediawiki.ui/components/images/checkbox-checked.svg |
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);