file

14 rows where patch_id = 87159

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ patch_id filename
411624 87159 87159 autoload.php
411625 87159 87159 includes/AutoLoader.php
411626 87159 87159 includes/libs/rdbms/database/DatabaseMysqlBase.php
411627 87159 87159 includes/libs/rdbms/database/DatabasePostgres.php
411628 87159 87159 includes/libs/rdbms/database/DatabaseSqlite.php
411629 87159 87159 includes/libs/rdbms/database/IDatabase.php
411630 87159 87159 includes/libs/rdbms/exception/DBLanguageError.php
411631 87159 87159 includes/libs/rdbms/platform/ISQLPlatform.php
411632 87159 87159 includes/libs/rdbms/platform/MySQLPlatform.php
411633 87159 87159 includes/libs/rdbms/platform/PostgresPlatform.php
411634 87159 87159 includes/libs/rdbms/platform/SQLPlatform.php
411635 87159 87159 includes/libs/rdbms/platform/SqlitePlatform.php
411636 87159 87159 tests/phpunit/unit/includes/libs/rdbms/database/DatabaseMysqlBaseTest.php
411637 87159 87159 tests/phpunit/unit/includes/libs/rdbms/platform/MySQLPlatformTest.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);