fixtures
This data as json, testall, testnone, testresponse, CSV
| group_concat( "select '" || name || "' as table_name, * from pragma_table_info('" || name || "')" , ' union ') || ' order by table_name, cid' |
|---|
| select 'simple_primary_key' as table_name, * from pragma_table_info('simple_primary_key') union select 'primary_key_multiple_columns' as table_name, * from pragma_table_info('primary_key_multiple_columns') union select 'primary_key_multiple_columns_explicit_label' as table_name, * from pragma_table_info('primary_key_multiple_columns_explicit_label') union select 'compound_primary_key' as table_name, * from pragma_table_info('compound_primary_key') union select 'compound_three_primary_keys' as table_name, * from pragma_table_info('compound_three_primary_keys') union select 'foreign_key_references' as table_name, * from pragma_table_info('foreign_key_references') union select 'sortable' as table_name, * from pragma_table_info('sortable') union select 'no_primary_key' as table_name, * from pragma_table_info('no_primary_key') union select '123_starts_with_digits' as table_name, * from pragma_table_info('123_starts_with_digits') union select 'Table With Space In Name' as table_name, * from pragma_table_info('Table With Space In Name') union select 'table/with/slashes.csv' as table_name, * from pragma_table_info('table/with/slashes.csv') union select 'complex_foreign_keys' as table_name, * from pragma_table_info('complex_foreign_keys') union select 'custom_foreign_key_label' as table_name, * from pragma_table_info('custom_foreign_key_label') union select 'tags' as table_name, * from pragma_table_info('tags') union select 'searchable' as table_name, * from pragma_table_info('searchable') union select 'searchable_tags' as table_name, * from pragma_table_info('searchable_tags') union select 'searchable_fts' as table_name, * from pragma_table_info('searchable_fts') union select 'searchable_fts_segments' as table_name, * from pragma_table_info('searchable_fts_segments') union select 'searchable_fts_segdir' as table_name, * from pragma_table_info('searchable_fts_segdir') union select 'searchable_fts_docsize' as table_name, * from pragma_table_info('searchable_fts_docsize') union select 'searchable_fts_stat' as table_name, * … |