| ur_ingest_session_tasks_stats_latest |
max_file_size_bytes |
|
/console/info-schema/view.sql?name=ur_ingest_session_tasks_stats_latest&stats=yes |
[Content](console/info-schema/view.sql?name=ur_ingest_session_tasks_stats_latest&stats=yes) |
[ur_ingest_session_tasks_stats_latest (view) Schema](console/info-schema/view.sql?name=ur_ingest_session_tasks_stats_latest&stats=yes) |
/console/content/view/ur_ingest_session_tasks_stats_latest.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/ur_ingest_session_tasks_stats_latest.sql?stats=yes) |
[ur_ingest_session_tasks_stats_latest (view) Content](console/content/view/ur_ingest_session_tasks_stats_latest.sql?stats=yes) |
CREATE VIEW "ur_ingest_session_tasks_stats_latest" AS
SELECT iss.*
FROM ur_ingest_session_tasks_stats AS iss
JOIN ( SELECT ur_ingest_session.ur_ingest_session_id AS latest_session_id
FROM ur_ingest_session
ORDER BY ur_ingest_session.ingest_finished_at DESC
LIMIT 1) AS latest
ON iss.ingest_session_id = latest.latest_session_id |
| ur_ingest_session_tasks_stats_latest |
oldest_file_last_modified_datetime |
|
/console/info-schema/view.sql?name=ur_ingest_session_tasks_stats_latest&stats=yes |
[Content](console/info-schema/view.sql?name=ur_ingest_session_tasks_stats_latest&stats=yes) |
[ur_ingest_session_tasks_stats_latest (view) Schema](console/info-schema/view.sql?name=ur_ingest_session_tasks_stats_latest&stats=yes) |
/console/content/view/ur_ingest_session_tasks_stats_latest.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/ur_ingest_session_tasks_stats_latest.sql?stats=yes) |
[ur_ingest_session_tasks_stats_latest (view) Content](console/content/view/ur_ingest_session_tasks_stats_latest.sql?stats=yes) |
CREATE VIEW "ur_ingest_session_tasks_stats_latest" AS
SELECT iss.*
FROM ur_ingest_session_tasks_stats AS iss
JOIN ( SELECT ur_ingest_session.ur_ingest_session_id AS latest_session_id
FROM ur_ingest_session
ORDER BY ur_ingest_session.ingest_finished_at DESC
LIMIT 1) AS latest
ON iss.ingest_session_id = latest.latest_session_id |
| ur_ingest_session_tasks_stats_latest |
youngest_file_last_modified_datetime |
|
/console/info-schema/view.sql?name=ur_ingest_session_tasks_stats_latest&stats=yes |
[Content](console/info-schema/view.sql?name=ur_ingest_session_tasks_stats_latest&stats=yes) |
[ur_ingest_session_tasks_stats_latest (view) Schema](console/info-schema/view.sql?name=ur_ingest_session_tasks_stats_latest&stats=yes) |
/console/content/view/ur_ingest_session_tasks_stats_latest.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/ur_ingest_session_tasks_stats_latest.sql?stats=yes) |
[ur_ingest_session_tasks_stats_latest (view) Content](console/content/view/ur_ingest_session_tasks_stats_latest.sql?stats=yes) |
CREATE VIEW "ur_ingest_session_tasks_stats_latest" AS
SELECT iss.*
FROM ur_ingest_session_tasks_stats AS iss
JOIN ( SELECT ur_ingest_session.ur_ingest_session_id AS latest_session_id
FROM ur_ingest_session
ORDER BY ur_ingest_session.ingest_finished_at DESC
LIMIT 1) AS latest
ON iss.ingest_session_id = latest.latest_session_id |
| ur_ingest_session_file_issue |
device_id |
VARCHAR |
/console/info-schema/view.sql?name=ur_ingest_session_file_issue&stats=yes |
[Content](console/info-schema/view.sql?name=ur_ingest_session_file_issue&stats=yes) |
[ur_ingest_session_file_issue (view) Schema](console/info-schema/view.sql?name=ur_ingest_session_file_issue&stats=yes) |
/console/content/view/ur_ingest_session_file_issue.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/ur_ingest_session_file_issue.sql?stats=yes) |
[ur_ingest_session_file_issue (view) Content](console/content/view/ur_ingest_session_file_issue.sql?stats=yes) |
CREATE VIEW "ur_ingest_session_file_issue" AS
SELECT us.device_id,
us.ur_ingest_session_id,
usp.ur_ingest_session_fs_path_id,
usp.root_path,
ufs.ur_ingest_session_fs_path_entry_id,
ufs.file_path_abs,
ufs.ur_status,
ufs.ur_diagnostics
FROM ur_ingest_session_fs_path_entry ufs
JOIN ur_ingest_session_fs_path usp ON ufs.ingest_fs_path_id = usp.ur_ingest_session_fs_path_id
JOIN ur_ingest_session us ON usp.ingest_session_id = us.ur_ingest_session_id
WHERE ufs.ur_status IS NOT NULL
GROUP BY us.device_id,
us.ur_ingest_session_id,
usp.ur_ingest_session_fs_path_id,
usp.root_path,
ufs.ur_ingest_session_fs_path_entry_id,
ufs.file_path_abs,
ufs.ur_status,
ufs.ur_diagnostics |
| ur_ingest_session_file_issue |
ur_ingest_session_id |
VARCHAR |
/console/info-schema/view.sql?name=ur_ingest_session_file_issue&stats=yes |
[Content](console/info-schema/view.sql?name=ur_ingest_session_file_issue&stats=yes) |
[ur_ingest_session_file_issue (view) Schema](console/info-schema/view.sql?name=ur_ingest_session_file_issue&stats=yes) |
/console/content/view/ur_ingest_session_file_issue.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/ur_ingest_session_file_issue.sql?stats=yes) |
[ur_ingest_session_file_issue (view) Content](console/content/view/ur_ingest_session_file_issue.sql?stats=yes) |
CREATE VIEW "ur_ingest_session_file_issue" AS
SELECT us.device_id,
us.ur_ingest_session_id,
usp.ur_ingest_session_fs_path_id,
usp.root_path,
ufs.ur_ingest_session_fs_path_entry_id,
ufs.file_path_abs,
ufs.ur_status,
ufs.ur_diagnostics
FROM ur_ingest_session_fs_path_entry ufs
JOIN ur_ingest_session_fs_path usp ON ufs.ingest_fs_path_id = usp.ur_ingest_session_fs_path_id
JOIN ur_ingest_session us ON usp.ingest_session_id = us.ur_ingest_session_id
WHERE ufs.ur_status IS NOT NULL
GROUP BY us.device_id,
us.ur_ingest_session_id,
usp.ur_ingest_session_fs_path_id,
usp.root_path,
ufs.ur_ingest_session_fs_path_entry_id,
ufs.file_path_abs,
ufs.ur_status,
ufs.ur_diagnostics |
| ur_ingest_session_file_issue |
ur_ingest_session_fs_path_id |
VARCHAR |
/console/info-schema/view.sql?name=ur_ingest_session_file_issue&stats=yes |
[Content](console/info-schema/view.sql?name=ur_ingest_session_file_issue&stats=yes) |
[ur_ingest_session_file_issue (view) Schema](console/info-schema/view.sql?name=ur_ingest_session_file_issue&stats=yes) |
/console/content/view/ur_ingest_session_file_issue.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/ur_ingest_session_file_issue.sql?stats=yes) |
[ur_ingest_session_file_issue (view) Content](console/content/view/ur_ingest_session_file_issue.sql?stats=yes) |
CREATE VIEW "ur_ingest_session_file_issue" AS
SELECT us.device_id,
us.ur_ingest_session_id,
usp.ur_ingest_session_fs_path_id,
usp.root_path,
ufs.ur_ingest_session_fs_path_entry_id,
ufs.file_path_abs,
ufs.ur_status,
ufs.ur_diagnostics
FROM ur_ingest_session_fs_path_entry ufs
JOIN ur_ingest_session_fs_path usp ON ufs.ingest_fs_path_id = usp.ur_ingest_session_fs_path_id
JOIN ur_ingest_session us ON usp.ingest_session_id = us.ur_ingest_session_id
WHERE ufs.ur_status IS NOT NULL
GROUP BY us.device_id,
us.ur_ingest_session_id,
usp.ur_ingest_session_fs_path_id,
usp.root_path,
ufs.ur_ingest_session_fs_path_entry_id,
ufs.file_path_abs,
ufs.ur_status,
ufs.ur_diagnostics |
| ur_ingest_session_file_issue |
root_path |
TEXT |
/console/info-schema/view.sql?name=ur_ingest_session_file_issue&stats=yes |
[Content](console/info-schema/view.sql?name=ur_ingest_session_file_issue&stats=yes) |
[ur_ingest_session_file_issue (view) Schema](console/info-schema/view.sql?name=ur_ingest_session_file_issue&stats=yes) |
/console/content/view/ur_ingest_session_file_issue.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/ur_ingest_session_file_issue.sql?stats=yes) |
[ur_ingest_session_file_issue (view) Content](console/content/view/ur_ingest_session_file_issue.sql?stats=yes) |
CREATE VIEW "ur_ingest_session_file_issue" AS
SELECT us.device_id,
us.ur_ingest_session_id,
usp.ur_ingest_session_fs_path_id,
usp.root_path,
ufs.ur_ingest_session_fs_path_entry_id,
ufs.file_path_abs,
ufs.ur_status,
ufs.ur_diagnostics
FROM ur_ingest_session_fs_path_entry ufs
JOIN ur_ingest_session_fs_path usp ON ufs.ingest_fs_path_id = usp.ur_ingest_session_fs_path_id
JOIN ur_ingest_session us ON usp.ingest_session_id = us.ur_ingest_session_id
WHERE ufs.ur_status IS NOT NULL
GROUP BY us.device_id,
us.ur_ingest_session_id,
usp.ur_ingest_session_fs_path_id,
usp.root_path,
ufs.ur_ingest_session_fs_path_entry_id,
ufs.file_path_abs,
ufs.ur_status,
ufs.ur_diagnostics |
| ur_ingest_session_file_issue |
ur_ingest_session_fs_path_entry_id |
VARCHAR |
/console/info-schema/view.sql?name=ur_ingest_session_file_issue&stats=yes |
[Content](console/info-schema/view.sql?name=ur_ingest_session_file_issue&stats=yes) |
[ur_ingest_session_file_issue (view) Schema](console/info-schema/view.sql?name=ur_ingest_session_file_issue&stats=yes) |
/console/content/view/ur_ingest_session_file_issue.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/ur_ingest_session_file_issue.sql?stats=yes) |
[ur_ingest_session_file_issue (view) Content](console/content/view/ur_ingest_session_file_issue.sql?stats=yes) |
CREATE VIEW "ur_ingest_session_file_issue" AS
SELECT us.device_id,
us.ur_ingest_session_id,
usp.ur_ingest_session_fs_path_id,
usp.root_path,
ufs.ur_ingest_session_fs_path_entry_id,
ufs.file_path_abs,
ufs.ur_status,
ufs.ur_diagnostics
FROM ur_ingest_session_fs_path_entry ufs
JOIN ur_ingest_session_fs_path usp ON ufs.ingest_fs_path_id = usp.ur_ingest_session_fs_path_id
JOIN ur_ingest_session us ON usp.ingest_session_id = us.ur_ingest_session_id
WHERE ufs.ur_status IS NOT NULL
GROUP BY us.device_id,
us.ur_ingest_session_id,
usp.ur_ingest_session_fs_path_id,
usp.root_path,
ufs.ur_ingest_session_fs_path_entry_id,
ufs.file_path_abs,
ufs.ur_status,
ufs.ur_diagnostics |
| ur_ingest_session_file_issue |
file_path_abs |
TEXT |
/console/info-schema/view.sql?name=ur_ingest_session_file_issue&stats=yes |
[Content](console/info-schema/view.sql?name=ur_ingest_session_file_issue&stats=yes) |
[ur_ingest_session_file_issue (view) Schema](console/info-schema/view.sql?name=ur_ingest_session_file_issue&stats=yes) |
/console/content/view/ur_ingest_session_file_issue.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/ur_ingest_session_file_issue.sql?stats=yes) |
[ur_ingest_session_file_issue (view) Content](console/content/view/ur_ingest_session_file_issue.sql?stats=yes) |
CREATE VIEW "ur_ingest_session_file_issue" AS
SELECT us.device_id,
us.ur_ingest_session_id,
usp.ur_ingest_session_fs_path_id,
usp.root_path,
ufs.ur_ingest_session_fs_path_entry_id,
ufs.file_path_abs,
ufs.ur_status,
ufs.ur_diagnostics
FROM ur_ingest_session_fs_path_entry ufs
JOIN ur_ingest_session_fs_path usp ON ufs.ingest_fs_path_id = usp.ur_ingest_session_fs_path_id
JOIN ur_ingest_session us ON usp.ingest_session_id = us.ur_ingest_session_id
WHERE ufs.ur_status IS NOT NULL
GROUP BY us.device_id,
us.ur_ingest_session_id,
usp.ur_ingest_session_fs_path_id,
usp.root_path,
ufs.ur_ingest_session_fs_path_entry_id,
ufs.file_path_abs,
ufs.ur_status,
ufs.ur_diagnostics |
| ur_ingest_session_file_issue |
ur_status |
TEXT |
/console/info-schema/view.sql?name=ur_ingest_session_file_issue&stats=yes |
[Content](console/info-schema/view.sql?name=ur_ingest_session_file_issue&stats=yes) |
[ur_ingest_session_file_issue (view) Schema](console/info-schema/view.sql?name=ur_ingest_session_file_issue&stats=yes) |
/console/content/view/ur_ingest_session_file_issue.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/ur_ingest_session_file_issue.sql?stats=yes) |
[ur_ingest_session_file_issue (view) Content](console/content/view/ur_ingest_session_file_issue.sql?stats=yes) |
CREATE VIEW "ur_ingest_session_file_issue" AS
SELECT us.device_id,
us.ur_ingest_session_id,
usp.ur_ingest_session_fs_path_id,
usp.root_path,
ufs.ur_ingest_session_fs_path_entry_id,
ufs.file_path_abs,
ufs.ur_status,
ufs.ur_diagnostics
FROM ur_ingest_session_fs_path_entry ufs
JOIN ur_ingest_session_fs_path usp ON ufs.ingest_fs_path_id = usp.ur_ingest_session_fs_path_id
JOIN ur_ingest_session us ON usp.ingest_session_id = us.ur_ingest_session_id
WHERE ufs.ur_status IS NOT NULL
GROUP BY us.device_id,
us.ur_ingest_session_id,
usp.ur_ingest_session_fs_path_id,
usp.root_path,
ufs.ur_ingest_session_fs_path_entry_id,
ufs.file_path_abs,
ufs.ur_status,
ufs.ur_diagnostics |
| ur_ingest_session_file_issue |
ur_diagnostics |
TEXT |
/console/info-schema/view.sql?name=ur_ingest_session_file_issue&stats=yes |
[Content](console/info-schema/view.sql?name=ur_ingest_session_file_issue&stats=yes) |
[ur_ingest_session_file_issue (view) Schema](console/info-schema/view.sql?name=ur_ingest_session_file_issue&stats=yes) |
/console/content/view/ur_ingest_session_file_issue.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/ur_ingest_session_file_issue.sql?stats=yes) |
[ur_ingest_session_file_issue (view) Content](console/content/view/ur_ingest_session_file_issue.sql?stats=yes) |
CREATE VIEW "ur_ingest_session_file_issue" AS
SELECT us.device_id,
us.ur_ingest_session_id,
usp.ur_ingest_session_fs_path_id,
usp.root_path,
ufs.ur_ingest_session_fs_path_entry_id,
ufs.file_path_abs,
ufs.ur_status,
ufs.ur_diagnostics
FROM ur_ingest_session_fs_path_entry ufs
JOIN ur_ingest_session_fs_path usp ON ufs.ingest_fs_path_id = usp.ur_ingest_session_fs_path_id
JOIN ur_ingest_session us ON usp.ingest_session_id = us.ur_ingest_session_id
WHERE ufs.ur_status IS NOT NULL
GROUP BY us.device_id,
us.ur_ingest_session_id,
usp.ur_ingest_session_fs_path_id,
usp.root_path,
ufs.ur_ingest_session_fs_path_entry_id,
ufs.file_path_abs,
ufs.ur_status,
ufs.ur_diagnostics |
| console_information_schema_table |
table_name |
TEXT |
/console/info-schema/view.sql?name=console_information_schema_table&stats=yes |
[Content](console/info-schema/view.sql?name=console_information_schema_table&stats=yes) |
[console_information_schema_table (view) Schema](console/info-schema/view.sql?name=console_information_schema_table&stats=yes) |
/console/content/view/console_information_schema_table.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/console_information_schema_table.sql?stats=yes) |
[console_information_schema_table (view) Content](console/content/view/console_information_schema_table.sql?stats=yes) |
CREATE VIEW console_information_schema_table AS
SELECT
tbl.name AS table_name,
col.name AS column_name,
col.type AS data_type,
CASE WHEN col.pk = 1 THEN 'Yes' ELSE 'No' END AS is_primary_key,
CASE WHEN col."notnull" = 1 THEN 'Yes' ELSE 'No' END AS is_not_null,
col.dflt_value AS default_value,
'console/info-schema/table.sql?name=' || tbl.name || '&stats=yes' as info_schema_web_ui_path,
'[Content](console/info-schema/table.sql?name=' || tbl.name || '&stats=yes)' as info_schema_link_abbrev_md,
'[' || tbl.name || ' (table) Schema](console/info-schema/table.sql?name=' || tbl.name || '&stats=yes)' as info_schema_link_full_md,
'console/content/table/' || tbl.name || '.sql?stats=yes' as content_web_ui_path,
'[Content]($SITE_PREFIX_URL/console/content/table/' || tbl.name || '.sql?stats=yes)' as content_web_ui_link_abbrev_md,
'[' || tbl.name || ' (table) Content](console/content/table/' || tbl.name || '.sql?stats=yes)' as content_web_ui_link_full_md,
tbl.sql as sql_ddl
FROM sqlite_master tbl
JOIN pragma_table_info(tbl.name) col
WHERE tbl.type = 'table' AND tbl.name NOT LIKE 'sqlite_%' |
| console_information_schema_table |
column_name |
BLOB |
/console/info-schema/view.sql?name=console_information_schema_table&stats=yes |
[Content](console/info-schema/view.sql?name=console_information_schema_table&stats=yes) |
[console_information_schema_table (view) Schema](console/info-schema/view.sql?name=console_information_schema_table&stats=yes) |
/console/content/view/console_information_schema_table.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/console_information_schema_table.sql?stats=yes) |
[console_information_schema_table (view) Content](console/content/view/console_information_schema_table.sql?stats=yes) |
CREATE VIEW console_information_schema_table AS
SELECT
tbl.name AS table_name,
col.name AS column_name,
col.type AS data_type,
CASE WHEN col.pk = 1 THEN 'Yes' ELSE 'No' END AS is_primary_key,
CASE WHEN col."notnull" = 1 THEN 'Yes' ELSE 'No' END AS is_not_null,
col.dflt_value AS default_value,
'console/info-schema/table.sql?name=' || tbl.name || '&stats=yes' as info_schema_web_ui_path,
'[Content](console/info-schema/table.sql?name=' || tbl.name || '&stats=yes)' as info_schema_link_abbrev_md,
'[' || tbl.name || ' (table) Schema](console/info-schema/table.sql?name=' || tbl.name || '&stats=yes)' as info_schema_link_full_md,
'console/content/table/' || tbl.name || '.sql?stats=yes' as content_web_ui_path,
'[Content]($SITE_PREFIX_URL/console/content/table/' || tbl.name || '.sql?stats=yes)' as content_web_ui_link_abbrev_md,
'[' || tbl.name || ' (table) Content](console/content/table/' || tbl.name || '.sql?stats=yes)' as content_web_ui_link_full_md,
tbl.sql as sql_ddl
FROM sqlite_master tbl
JOIN pragma_table_info(tbl.name) col
WHERE tbl.type = 'table' AND tbl.name NOT LIKE 'sqlite_%' |
| console_information_schema_table |
data_type |
BLOB |
/console/info-schema/view.sql?name=console_information_schema_table&stats=yes |
[Content](console/info-schema/view.sql?name=console_information_schema_table&stats=yes) |
[console_information_schema_table (view) Schema](console/info-schema/view.sql?name=console_information_schema_table&stats=yes) |
/console/content/view/console_information_schema_table.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/console_information_schema_table.sql?stats=yes) |
[console_information_schema_table (view) Content](console/content/view/console_information_schema_table.sql?stats=yes) |
CREATE VIEW console_information_schema_table AS
SELECT
tbl.name AS table_name,
col.name AS column_name,
col.type AS data_type,
CASE WHEN col.pk = 1 THEN 'Yes' ELSE 'No' END AS is_primary_key,
CASE WHEN col."notnull" = 1 THEN 'Yes' ELSE 'No' END AS is_not_null,
col.dflt_value AS default_value,
'console/info-schema/table.sql?name=' || tbl.name || '&stats=yes' as info_schema_web_ui_path,
'[Content](console/info-schema/table.sql?name=' || tbl.name || '&stats=yes)' as info_schema_link_abbrev_md,
'[' || tbl.name || ' (table) Schema](console/info-schema/table.sql?name=' || tbl.name || '&stats=yes)' as info_schema_link_full_md,
'console/content/table/' || tbl.name || '.sql?stats=yes' as content_web_ui_path,
'[Content]($SITE_PREFIX_URL/console/content/table/' || tbl.name || '.sql?stats=yes)' as content_web_ui_link_abbrev_md,
'[' || tbl.name || ' (table) Content](console/content/table/' || tbl.name || '.sql?stats=yes)' as content_web_ui_link_full_md,
tbl.sql as sql_ddl
FROM sqlite_master tbl
JOIN pragma_table_info(tbl.name) col
WHERE tbl.type = 'table' AND tbl.name NOT LIKE 'sqlite_%' |
| console_information_schema_table |
is_primary_key |
|
/console/info-schema/view.sql?name=console_information_schema_table&stats=yes |
[Content](console/info-schema/view.sql?name=console_information_schema_table&stats=yes) |
[console_information_schema_table (view) Schema](console/info-schema/view.sql?name=console_information_schema_table&stats=yes) |
/console/content/view/console_information_schema_table.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/console_information_schema_table.sql?stats=yes) |
[console_information_schema_table (view) Content](console/content/view/console_information_schema_table.sql?stats=yes) |
CREATE VIEW console_information_schema_table AS
SELECT
tbl.name AS table_name,
col.name AS column_name,
col.type AS data_type,
CASE WHEN col.pk = 1 THEN 'Yes' ELSE 'No' END AS is_primary_key,
CASE WHEN col."notnull" = 1 THEN 'Yes' ELSE 'No' END AS is_not_null,
col.dflt_value AS default_value,
'console/info-schema/table.sql?name=' || tbl.name || '&stats=yes' as info_schema_web_ui_path,
'[Content](console/info-schema/table.sql?name=' || tbl.name || '&stats=yes)' as info_schema_link_abbrev_md,
'[' || tbl.name || ' (table) Schema](console/info-schema/table.sql?name=' || tbl.name || '&stats=yes)' as info_schema_link_full_md,
'console/content/table/' || tbl.name || '.sql?stats=yes' as content_web_ui_path,
'[Content]($SITE_PREFIX_URL/console/content/table/' || tbl.name || '.sql?stats=yes)' as content_web_ui_link_abbrev_md,
'[' || tbl.name || ' (table) Content](console/content/table/' || tbl.name || '.sql?stats=yes)' as content_web_ui_link_full_md,
tbl.sql as sql_ddl
FROM sqlite_master tbl
JOIN pragma_table_info(tbl.name) col
WHERE tbl.type = 'table' AND tbl.name NOT LIKE 'sqlite_%' |
| console_information_schema_table |
is_not_null |
|
/console/info-schema/view.sql?name=console_information_schema_table&stats=yes |
[Content](console/info-schema/view.sql?name=console_information_schema_table&stats=yes) |
[console_information_schema_table (view) Schema](console/info-schema/view.sql?name=console_information_schema_table&stats=yes) |
/console/content/view/console_information_schema_table.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/console_information_schema_table.sql?stats=yes) |
[console_information_schema_table (view) Content](console/content/view/console_information_schema_table.sql?stats=yes) |
CREATE VIEW console_information_schema_table AS
SELECT
tbl.name AS table_name,
col.name AS column_name,
col.type AS data_type,
CASE WHEN col.pk = 1 THEN 'Yes' ELSE 'No' END AS is_primary_key,
CASE WHEN col."notnull" = 1 THEN 'Yes' ELSE 'No' END AS is_not_null,
col.dflt_value AS default_value,
'console/info-schema/table.sql?name=' || tbl.name || '&stats=yes' as info_schema_web_ui_path,
'[Content](console/info-schema/table.sql?name=' || tbl.name || '&stats=yes)' as info_schema_link_abbrev_md,
'[' || tbl.name || ' (table) Schema](console/info-schema/table.sql?name=' || tbl.name || '&stats=yes)' as info_schema_link_full_md,
'console/content/table/' || tbl.name || '.sql?stats=yes' as content_web_ui_path,
'[Content]($SITE_PREFIX_URL/console/content/table/' || tbl.name || '.sql?stats=yes)' as content_web_ui_link_abbrev_md,
'[' || tbl.name || ' (table) Content](console/content/table/' || tbl.name || '.sql?stats=yes)' as content_web_ui_link_full_md,
tbl.sql as sql_ddl
FROM sqlite_master tbl
JOIN pragma_table_info(tbl.name) col
WHERE tbl.type = 'table' AND tbl.name NOT LIKE 'sqlite_%' |
| console_information_schema_table |
default_value |
BLOB |
/console/info-schema/view.sql?name=console_information_schema_table&stats=yes |
[Content](console/info-schema/view.sql?name=console_information_schema_table&stats=yes) |
[console_information_schema_table (view) Schema](console/info-schema/view.sql?name=console_information_schema_table&stats=yes) |
/console/content/view/console_information_schema_table.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/console_information_schema_table.sql?stats=yes) |
[console_information_schema_table (view) Content](console/content/view/console_information_schema_table.sql?stats=yes) |
CREATE VIEW console_information_schema_table AS
SELECT
tbl.name AS table_name,
col.name AS column_name,
col.type AS data_type,
CASE WHEN col.pk = 1 THEN 'Yes' ELSE 'No' END AS is_primary_key,
CASE WHEN col."notnull" = 1 THEN 'Yes' ELSE 'No' END AS is_not_null,
col.dflt_value AS default_value,
'console/info-schema/table.sql?name=' || tbl.name || '&stats=yes' as info_schema_web_ui_path,
'[Content](console/info-schema/table.sql?name=' || tbl.name || '&stats=yes)' as info_schema_link_abbrev_md,
'[' || tbl.name || ' (table) Schema](console/info-schema/table.sql?name=' || tbl.name || '&stats=yes)' as info_schema_link_full_md,
'console/content/table/' || tbl.name || '.sql?stats=yes' as content_web_ui_path,
'[Content]($SITE_PREFIX_URL/console/content/table/' || tbl.name || '.sql?stats=yes)' as content_web_ui_link_abbrev_md,
'[' || tbl.name || ' (table) Content](console/content/table/' || tbl.name || '.sql?stats=yes)' as content_web_ui_link_full_md,
tbl.sql as sql_ddl
FROM sqlite_master tbl
JOIN pragma_table_info(tbl.name) col
WHERE tbl.type = 'table' AND tbl.name NOT LIKE 'sqlite_%' |
| console_information_schema_table |
info_schema_web_ui_path |
|
/console/info-schema/view.sql?name=console_information_schema_table&stats=yes |
[Content](console/info-schema/view.sql?name=console_information_schema_table&stats=yes) |
[console_information_schema_table (view) Schema](console/info-schema/view.sql?name=console_information_schema_table&stats=yes) |
/console/content/view/console_information_schema_table.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/console_information_schema_table.sql?stats=yes) |
[console_information_schema_table (view) Content](console/content/view/console_information_schema_table.sql?stats=yes) |
CREATE VIEW console_information_schema_table AS
SELECT
tbl.name AS table_name,
col.name AS column_name,
col.type AS data_type,
CASE WHEN col.pk = 1 THEN 'Yes' ELSE 'No' END AS is_primary_key,
CASE WHEN col."notnull" = 1 THEN 'Yes' ELSE 'No' END AS is_not_null,
col.dflt_value AS default_value,
'console/info-schema/table.sql?name=' || tbl.name || '&stats=yes' as info_schema_web_ui_path,
'[Content](console/info-schema/table.sql?name=' || tbl.name || '&stats=yes)' as info_schema_link_abbrev_md,
'[' || tbl.name || ' (table) Schema](console/info-schema/table.sql?name=' || tbl.name || '&stats=yes)' as info_schema_link_full_md,
'console/content/table/' || tbl.name || '.sql?stats=yes' as content_web_ui_path,
'[Content]($SITE_PREFIX_URL/console/content/table/' || tbl.name || '.sql?stats=yes)' as content_web_ui_link_abbrev_md,
'[' || tbl.name || ' (table) Content](console/content/table/' || tbl.name || '.sql?stats=yes)' as content_web_ui_link_full_md,
tbl.sql as sql_ddl
FROM sqlite_master tbl
JOIN pragma_table_info(tbl.name) col
WHERE tbl.type = 'table' AND tbl.name NOT LIKE 'sqlite_%' |
| console_information_schema_table |
info_schema_link_abbrev_md |
|
/console/info-schema/view.sql?name=console_information_schema_table&stats=yes |
[Content](console/info-schema/view.sql?name=console_information_schema_table&stats=yes) |
[console_information_schema_table (view) Schema](console/info-schema/view.sql?name=console_information_schema_table&stats=yes) |
/console/content/view/console_information_schema_table.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/console_information_schema_table.sql?stats=yes) |
[console_information_schema_table (view) Content](console/content/view/console_information_schema_table.sql?stats=yes) |
CREATE VIEW console_information_schema_table AS
SELECT
tbl.name AS table_name,
col.name AS column_name,
col.type AS data_type,
CASE WHEN col.pk = 1 THEN 'Yes' ELSE 'No' END AS is_primary_key,
CASE WHEN col."notnull" = 1 THEN 'Yes' ELSE 'No' END AS is_not_null,
col.dflt_value AS default_value,
'console/info-schema/table.sql?name=' || tbl.name || '&stats=yes' as info_schema_web_ui_path,
'[Content](console/info-schema/table.sql?name=' || tbl.name || '&stats=yes)' as info_schema_link_abbrev_md,
'[' || tbl.name || ' (table) Schema](console/info-schema/table.sql?name=' || tbl.name || '&stats=yes)' as info_schema_link_full_md,
'console/content/table/' || tbl.name || '.sql?stats=yes' as content_web_ui_path,
'[Content]($SITE_PREFIX_URL/console/content/table/' || tbl.name || '.sql?stats=yes)' as content_web_ui_link_abbrev_md,
'[' || tbl.name || ' (table) Content](console/content/table/' || tbl.name || '.sql?stats=yes)' as content_web_ui_link_full_md,
tbl.sql as sql_ddl
FROM sqlite_master tbl
JOIN pragma_table_info(tbl.name) col
WHERE tbl.type = 'table' AND tbl.name NOT LIKE 'sqlite_%' |
| console_information_schema_table |
info_schema_link_full_md |
|
/console/info-schema/view.sql?name=console_information_schema_table&stats=yes |
[Content](console/info-schema/view.sql?name=console_information_schema_table&stats=yes) |
[console_information_schema_table (view) Schema](console/info-schema/view.sql?name=console_information_schema_table&stats=yes) |
/console/content/view/console_information_schema_table.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/console_information_schema_table.sql?stats=yes) |
[console_information_schema_table (view) Content](console/content/view/console_information_schema_table.sql?stats=yes) |
CREATE VIEW console_information_schema_table AS
SELECT
tbl.name AS table_name,
col.name AS column_name,
col.type AS data_type,
CASE WHEN col.pk = 1 THEN 'Yes' ELSE 'No' END AS is_primary_key,
CASE WHEN col."notnull" = 1 THEN 'Yes' ELSE 'No' END AS is_not_null,
col.dflt_value AS default_value,
'console/info-schema/table.sql?name=' || tbl.name || '&stats=yes' as info_schema_web_ui_path,
'[Content](console/info-schema/table.sql?name=' || tbl.name || '&stats=yes)' as info_schema_link_abbrev_md,
'[' || tbl.name || ' (table) Schema](console/info-schema/table.sql?name=' || tbl.name || '&stats=yes)' as info_schema_link_full_md,
'console/content/table/' || tbl.name || '.sql?stats=yes' as content_web_ui_path,
'[Content]($SITE_PREFIX_URL/console/content/table/' || tbl.name || '.sql?stats=yes)' as content_web_ui_link_abbrev_md,
'[' || tbl.name || ' (table) Content](console/content/table/' || tbl.name || '.sql?stats=yes)' as content_web_ui_link_full_md,
tbl.sql as sql_ddl
FROM sqlite_master tbl
JOIN pragma_table_info(tbl.name) col
WHERE tbl.type = 'table' AND tbl.name NOT LIKE 'sqlite_%' |
| console_information_schema_table |
content_web_ui_path |
|
/console/info-schema/view.sql?name=console_information_schema_table&stats=yes |
[Content](console/info-schema/view.sql?name=console_information_schema_table&stats=yes) |
[console_information_schema_table (view) Schema](console/info-schema/view.sql?name=console_information_schema_table&stats=yes) |
/console/content/view/console_information_schema_table.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/console_information_schema_table.sql?stats=yes) |
[console_information_schema_table (view) Content](console/content/view/console_information_schema_table.sql?stats=yes) |
CREATE VIEW console_information_schema_table AS
SELECT
tbl.name AS table_name,
col.name AS column_name,
col.type AS data_type,
CASE WHEN col.pk = 1 THEN 'Yes' ELSE 'No' END AS is_primary_key,
CASE WHEN col."notnull" = 1 THEN 'Yes' ELSE 'No' END AS is_not_null,
col.dflt_value AS default_value,
'console/info-schema/table.sql?name=' || tbl.name || '&stats=yes' as info_schema_web_ui_path,
'[Content](console/info-schema/table.sql?name=' || tbl.name || '&stats=yes)' as info_schema_link_abbrev_md,
'[' || tbl.name || ' (table) Schema](console/info-schema/table.sql?name=' || tbl.name || '&stats=yes)' as info_schema_link_full_md,
'console/content/table/' || tbl.name || '.sql?stats=yes' as content_web_ui_path,
'[Content]($SITE_PREFIX_URL/console/content/table/' || tbl.name || '.sql?stats=yes)' as content_web_ui_link_abbrev_md,
'[' || tbl.name || ' (table) Content](console/content/table/' || tbl.name || '.sql?stats=yes)' as content_web_ui_link_full_md,
tbl.sql as sql_ddl
FROM sqlite_master tbl
JOIN pragma_table_info(tbl.name) col
WHERE tbl.type = 'table' AND tbl.name NOT LIKE 'sqlite_%' |
| console_information_schema_table |
content_web_ui_link_abbrev_md |
|
/console/info-schema/view.sql?name=console_information_schema_table&stats=yes |
[Content](console/info-schema/view.sql?name=console_information_schema_table&stats=yes) |
[console_information_schema_table (view) Schema](console/info-schema/view.sql?name=console_information_schema_table&stats=yes) |
/console/content/view/console_information_schema_table.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/console_information_schema_table.sql?stats=yes) |
[console_information_schema_table (view) Content](console/content/view/console_information_schema_table.sql?stats=yes) |
CREATE VIEW console_information_schema_table AS
SELECT
tbl.name AS table_name,
col.name AS column_name,
col.type AS data_type,
CASE WHEN col.pk = 1 THEN 'Yes' ELSE 'No' END AS is_primary_key,
CASE WHEN col."notnull" = 1 THEN 'Yes' ELSE 'No' END AS is_not_null,
col.dflt_value AS default_value,
'console/info-schema/table.sql?name=' || tbl.name || '&stats=yes' as info_schema_web_ui_path,
'[Content](console/info-schema/table.sql?name=' || tbl.name || '&stats=yes)' as info_schema_link_abbrev_md,
'[' || tbl.name || ' (table) Schema](console/info-schema/table.sql?name=' || tbl.name || '&stats=yes)' as info_schema_link_full_md,
'console/content/table/' || tbl.name || '.sql?stats=yes' as content_web_ui_path,
'[Content]($SITE_PREFIX_URL/console/content/table/' || tbl.name || '.sql?stats=yes)' as content_web_ui_link_abbrev_md,
'[' || tbl.name || ' (table) Content](console/content/table/' || tbl.name || '.sql?stats=yes)' as content_web_ui_link_full_md,
tbl.sql as sql_ddl
FROM sqlite_master tbl
JOIN pragma_table_info(tbl.name) col
WHERE tbl.type = 'table' AND tbl.name NOT LIKE 'sqlite_%' |
| console_information_schema_table |
content_web_ui_link_full_md |
|
/console/info-schema/view.sql?name=console_information_schema_table&stats=yes |
[Content](console/info-schema/view.sql?name=console_information_schema_table&stats=yes) |
[console_information_schema_table (view) Schema](console/info-schema/view.sql?name=console_information_schema_table&stats=yes) |
/console/content/view/console_information_schema_table.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/console_information_schema_table.sql?stats=yes) |
[console_information_schema_table (view) Content](console/content/view/console_information_schema_table.sql?stats=yes) |
CREATE VIEW console_information_schema_table AS
SELECT
tbl.name AS table_name,
col.name AS column_name,
col.type AS data_type,
CASE WHEN col.pk = 1 THEN 'Yes' ELSE 'No' END AS is_primary_key,
CASE WHEN col."notnull" = 1 THEN 'Yes' ELSE 'No' END AS is_not_null,
col.dflt_value AS default_value,
'console/info-schema/table.sql?name=' || tbl.name || '&stats=yes' as info_schema_web_ui_path,
'[Content](console/info-schema/table.sql?name=' || tbl.name || '&stats=yes)' as info_schema_link_abbrev_md,
'[' || tbl.name || ' (table) Schema](console/info-schema/table.sql?name=' || tbl.name || '&stats=yes)' as info_schema_link_full_md,
'console/content/table/' || tbl.name || '.sql?stats=yes' as content_web_ui_path,
'[Content]($SITE_PREFIX_URL/console/content/table/' || tbl.name || '.sql?stats=yes)' as content_web_ui_link_abbrev_md,
'[' || tbl.name || ' (table) Content](console/content/table/' || tbl.name || '.sql?stats=yes)' as content_web_ui_link_full_md,
tbl.sql as sql_ddl
FROM sqlite_master tbl
JOIN pragma_table_info(tbl.name) col
WHERE tbl.type = 'table' AND tbl.name NOT LIKE 'sqlite_%' |
| console_information_schema_table |
sql_ddl |
TEXT |
/console/info-schema/view.sql?name=console_information_schema_table&stats=yes |
[Content](console/info-schema/view.sql?name=console_information_schema_table&stats=yes) |
[console_information_schema_table (view) Schema](console/info-schema/view.sql?name=console_information_schema_table&stats=yes) |
/console/content/view/console_information_schema_table.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/console_information_schema_table.sql?stats=yes) |
[console_information_schema_table (view) Content](console/content/view/console_information_schema_table.sql?stats=yes) |
CREATE VIEW console_information_schema_table AS
SELECT
tbl.name AS table_name,
col.name AS column_name,
col.type AS data_type,
CASE WHEN col.pk = 1 THEN 'Yes' ELSE 'No' END AS is_primary_key,
CASE WHEN col."notnull" = 1 THEN 'Yes' ELSE 'No' END AS is_not_null,
col.dflt_value AS default_value,
'console/info-schema/table.sql?name=' || tbl.name || '&stats=yes' as info_schema_web_ui_path,
'[Content](console/info-schema/table.sql?name=' || tbl.name || '&stats=yes)' as info_schema_link_abbrev_md,
'[' || tbl.name || ' (table) Schema](console/info-schema/table.sql?name=' || tbl.name || '&stats=yes)' as info_schema_link_full_md,
'console/content/table/' || tbl.name || '.sql?stats=yes' as content_web_ui_path,
'[Content]($SITE_PREFIX_URL/console/content/table/' || tbl.name || '.sql?stats=yes)' as content_web_ui_link_abbrev_md,
'[' || tbl.name || ' (table) Content](console/content/table/' || tbl.name || '.sql?stats=yes)' as content_web_ui_link_full_md,
tbl.sql as sql_ddl
FROM sqlite_master tbl
JOIN pragma_table_info(tbl.name) col
WHERE tbl.type = 'table' AND tbl.name NOT LIKE 'sqlite_%' |
| console_information_schema_view |
view_name |
TEXT |
/console/info-schema/view.sql?name=console_information_schema_view&stats=yes |
[Content](console/info-schema/view.sql?name=console_information_schema_view&stats=yes) |
[console_information_schema_view (view) Schema](console/info-schema/view.sql?name=console_information_schema_view&stats=yes) |
/console/content/view/console_information_schema_view.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/console_information_schema_view.sql?stats=yes) |
[console_information_schema_view (view) Content](console/content/view/console_information_schema_view.sql?stats=yes) |
CREATE VIEW console_information_schema_view AS
SELECT
vw.name AS view_name,
col.name AS column_name,
col.type AS data_type,
'/console/info-schema/view.sql?name=' || vw.name || '&stats=yes' as info_schema_web_ui_path,
'[Content](console/info-schema/view.sql?name=' || vw.name || '&stats=yes)' as info_schema_link_abbrev_md,
'[' || vw.name || ' (view) Schema](console/info-schema/view.sql?name=' || vw.name || '&stats=yes)' as info_schema_link_full_md,
'/console/content/view/' || vw.name || '.sql?stats=yes' as content_web_ui_path,
'[Content]($SITE_PREFIX_URL/console/content/view/' || vw.name || '.sql?stats=yes)' as content_web_ui_link_abbrev_md,
'[' || vw.name || ' (view) Content](console/content/view/' || vw.name || '.sql?stats=yes)' as content_web_ui_link_full_md,
vw.sql as sql_ddl
FROM sqlite_master vw
JOIN pragma_table_info(vw.name) col
WHERE vw.type = 'view' AND vw.name NOT LIKE 'sqlite_%' |
| console_information_schema_view |
column_name |
BLOB |
/console/info-schema/view.sql?name=console_information_schema_view&stats=yes |
[Content](console/info-schema/view.sql?name=console_information_schema_view&stats=yes) |
[console_information_schema_view (view) Schema](console/info-schema/view.sql?name=console_information_schema_view&stats=yes) |
/console/content/view/console_information_schema_view.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/console_information_schema_view.sql?stats=yes) |
[console_information_schema_view (view) Content](console/content/view/console_information_schema_view.sql?stats=yes) |
CREATE VIEW console_information_schema_view AS
SELECT
vw.name AS view_name,
col.name AS column_name,
col.type AS data_type,
'/console/info-schema/view.sql?name=' || vw.name || '&stats=yes' as info_schema_web_ui_path,
'[Content](console/info-schema/view.sql?name=' || vw.name || '&stats=yes)' as info_schema_link_abbrev_md,
'[' || vw.name || ' (view) Schema](console/info-schema/view.sql?name=' || vw.name || '&stats=yes)' as info_schema_link_full_md,
'/console/content/view/' || vw.name || '.sql?stats=yes' as content_web_ui_path,
'[Content]($SITE_PREFIX_URL/console/content/view/' || vw.name || '.sql?stats=yes)' as content_web_ui_link_abbrev_md,
'[' || vw.name || ' (view) Content](console/content/view/' || vw.name || '.sql?stats=yes)' as content_web_ui_link_full_md,
vw.sql as sql_ddl
FROM sqlite_master vw
JOIN pragma_table_info(vw.name) col
WHERE vw.type = 'view' AND vw.name NOT LIKE 'sqlite_%' |
| console_information_schema_view |
data_type |
BLOB |
/console/info-schema/view.sql?name=console_information_schema_view&stats=yes |
[Content](console/info-schema/view.sql?name=console_information_schema_view&stats=yes) |
[console_information_schema_view (view) Schema](console/info-schema/view.sql?name=console_information_schema_view&stats=yes) |
/console/content/view/console_information_schema_view.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/console_information_schema_view.sql?stats=yes) |
[console_information_schema_view (view) Content](console/content/view/console_information_schema_view.sql?stats=yes) |
CREATE VIEW console_information_schema_view AS
SELECT
vw.name AS view_name,
col.name AS column_name,
col.type AS data_type,
'/console/info-schema/view.sql?name=' || vw.name || '&stats=yes' as info_schema_web_ui_path,
'[Content](console/info-schema/view.sql?name=' || vw.name || '&stats=yes)' as info_schema_link_abbrev_md,
'[' || vw.name || ' (view) Schema](console/info-schema/view.sql?name=' || vw.name || '&stats=yes)' as info_schema_link_full_md,
'/console/content/view/' || vw.name || '.sql?stats=yes' as content_web_ui_path,
'[Content]($SITE_PREFIX_URL/console/content/view/' || vw.name || '.sql?stats=yes)' as content_web_ui_link_abbrev_md,
'[' || vw.name || ' (view) Content](console/content/view/' || vw.name || '.sql?stats=yes)' as content_web_ui_link_full_md,
vw.sql as sql_ddl
FROM sqlite_master vw
JOIN pragma_table_info(vw.name) col
WHERE vw.type = 'view' AND vw.name NOT LIKE 'sqlite_%' |
| console_information_schema_view |
info_schema_web_ui_path |
|
/console/info-schema/view.sql?name=console_information_schema_view&stats=yes |
[Content](console/info-schema/view.sql?name=console_information_schema_view&stats=yes) |
[console_information_schema_view (view) Schema](console/info-schema/view.sql?name=console_information_schema_view&stats=yes) |
/console/content/view/console_information_schema_view.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/console_information_schema_view.sql?stats=yes) |
[console_information_schema_view (view) Content](console/content/view/console_information_schema_view.sql?stats=yes) |
CREATE VIEW console_information_schema_view AS
SELECT
vw.name AS view_name,
col.name AS column_name,
col.type AS data_type,
'/console/info-schema/view.sql?name=' || vw.name || '&stats=yes' as info_schema_web_ui_path,
'[Content](console/info-schema/view.sql?name=' || vw.name || '&stats=yes)' as info_schema_link_abbrev_md,
'[' || vw.name || ' (view) Schema](console/info-schema/view.sql?name=' || vw.name || '&stats=yes)' as info_schema_link_full_md,
'/console/content/view/' || vw.name || '.sql?stats=yes' as content_web_ui_path,
'[Content]($SITE_PREFIX_URL/console/content/view/' || vw.name || '.sql?stats=yes)' as content_web_ui_link_abbrev_md,
'[' || vw.name || ' (view) Content](console/content/view/' || vw.name || '.sql?stats=yes)' as content_web_ui_link_full_md,
vw.sql as sql_ddl
FROM sqlite_master vw
JOIN pragma_table_info(vw.name) col
WHERE vw.type = 'view' AND vw.name NOT LIKE 'sqlite_%' |
| console_information_schema_view |
info_schema_link_abbrev_md |
|
/console/info-schema/view.sql?name=console_information_schema_view&stats=yes |
[Content](console/info-schema/view.sql?name=console_information_schema_view&stats=yes) |
[console_information_schema_view (view) Schema](console/info-schema/view.sql?name=console_information_schema_view&stats=yes) |
/console/content/view/console_information_schema_view.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/console_information_schema_view.sql?stats=yes) |
[console_information_schema_view (view) Content](console/content/view/console_information_schema_view.sql?stats=yes) |
CREATE VIEW console_information_schema_view AS
SELECT
vw.name AS view_name,
col.name AS column_name,
col.type AS data_type,
'/console/info-schema/view.sql?name=' || vw.name || '&stats=yes' as info_schema_web_ui_path,
'[Content](console/info-schema/view.sql?name=' || vw.name || '&stats=yes)' as info_schema_link_abbrev_md,
'[' || vw.name || ' (view) Schema](console/info-schema/view.sql?name=' || vw.name || '&stats=yes)' as info_schema_link_full_md,
'/console/content/view/' || vw.name || '.sql?stats=yes' as content_web_ui_path,
'[Content]($SITE_PREFIX_URL/console/content/view/' || vw.name || '.sql?stats=yes)' as content_web_ui_link_abbrev_md,
'[' || vw.name || ' (view) Content](console/content/view/' || vw.name || '.sql?stats=yes)' as content_web_ui_link_full_md,
vw.sql as sql_ddl
FROM sqlite_master vw
JOIN pragma_table_info(vw.name) col
WHERE vw.type = 'view' AND vw.name NOT LIKE 'sqlite_%' |
| console_information_schema_view |
info_schema_link_full_md |
|
/console/info-schema/view.sql?name=console_information_schema_view&stats=yes |
[Content](console/info-schema/view.sql?name=console_information_schema_view&stats=yes) |
[console_information_schema_view (view) Schema](console/info-schema/view.sql?name=console_information_schema_view&stats=yes) |
/console/content/view/console_information_schema_view.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/console_information_schema_view.sql?stats=yes) |
[console_information_schema_view (view) Content](console/content/view/console_information_schema_view.sql?stats=yes) |
CREATE VIEW console_information_schema_view AS
SELECT
vw.name AS view_name,
col.name AS column_name,
col.type AS data_type,
'/console/info-schema/view.sql?name=' || vw.name || '&stats=yes' as info_schema_web_ui_path,
'[Content](console/info-schema/view.sql?name=' || vw.name || '&stats=yes)' as info_schema_link_abbrev_md,
'[' || vw.name || ' (view) Schema](console/info-schema/view.sql?name=' || vw.name || '&stats=yes)' as info_schema_link_full_md,
'/console/content/view/' || vw.name || '.sql?stats=yes' as content_web_ui_path,
'[Content]($SITE_PREFIX_URL/console/content/view/' || vw.name || '.sql?stats=yes)' as content_web_ui_link_abbrev_md,
'[' || vw.name || ' (view) Content](console/content/view/' || vw.name || '.sql?stats=yes)' as content_web_ui_link_full_md,
vw.sql as sql_ddl
FROM sqlite_master vw
JOIN pragma_table_info(vw.name) col
WHERE vw.type = 'view' AND vw.name NOT LIKE 'sqlite_%' |
| console_information_schema_view |
content_web_ui_path |
|
/console/info-schema/view.sql?name=console_information_schema_view&stats=yes |
[Content](console/info-schema/view.sql?name=console_information_schema_view&stats=yes) |
[console_information_schema_view (view) Schema](console/info-schema/view.sql?name=console_information_schema_view&stats=yes) |
/console/content/view/console_information_schema_view.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/console_information_schema_view.sql?stats=yes) |
[console_information_schema_view (view) Content](console/content/view/console_information_schema_view.sql?stats=yes) |
CREATE VIEW console_information_schema_view AS
SELECT
vw.name AS view_name,
col.name AS column_name,
col.type AS data_type,
'/console/info-schema/view.sql?name=' || vw.name || '&stats=yes' as info_schema_web_ui_path,
'[Content](console/info-schema/view.sql?name=' || vw.name || '&stats=yes)' as info_schema_link_abbrev_md,
'[' || vw.name || ' (view) Schema](console/info-schema/view.sql?name=' || vw.name || '&stats=yes)' as info_schema_link_full_md,
'/console/content/view/' || vw.name || '.sql?stats=yes' as content_web_ui_path,
'[Content]($SITE_PREFIX_URL/console/content/view/' || vw.name || '.sql?stats=yes)' as content_web_ui_link_abbrev_md,
'[' || vw.name || ' (view) Content](console/content/view/' || vw.name || '.sql?stats=yes)' as content_web_ui_link_full_md,
vw.sql as sql_ddl
FROM sqlite_master vw
JOIN pragma_table_info(vw.name) col
WHERE vw.type = 'view' AND vw.name NOT LIKE 'sqlite_%' |
| console_information_schema_view |
content_web_ui_link_abbrev_md |
|
/console/info-schema/view.sql?name=console_information_schema_view&stats=yes |
[Content](console/info-schema/view.sql?name=console_information_schema_view&stats=yes) |
[console_information_schema_view (view) Schema](console/info-schema/view.sql?name=console_information_schema_view&stats=yes) |
/console/content/view/console_information_schema_view.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/console_information_schema_view.sql?stats=yes) |
[console_information_schema_view (view) Content](console/content/view/console_information_schema_view.sql?stats=yes) |
CREATE VIEW console_information_schema_view AS
SELECT
vw.name AS view_name,
col.name AS column_name,
col.type AS data_type,
'/console/info-schema/view.sql?name=' || vw.name || '&stats=yes' as info_schema_web_ui_path,
'[Content](console/info-schema/view.sql?name=' || vw.name || '&stats=yes)' as info_schema_link_abbrev_md,
'[' || vw.name || ' (view) Schema](console/info-schema/view.sql?name=' || vw.name || '&stats=yes)' as info_schema_link_full_md,
'/console/content/view/' || vw.name || '.sql?stats=yes' as content_web_ui_path,
'[Content]($SITE_PREFIX_URL/console/content/view/' || vw.name || '.sql?stats=yes)' as content_web_ui_link_abbrev_md,
'[' || vw.name || ' (view) Content](console/content/view/' || vw.name || '.sql?stats=yes)' as content_web_ui_link_full_md,
vw.sql as sql_ddl
FROM sqlite_master vw
JOIN pragma_table_info(vw.name) col
WHERE vw.type = 'view' AND vw.name NOT LIKE 'sqlite_%' |
| console_information_schema_view |
content_web_ui_link_full_md |
|
/console/info-schema/view.sql?name=console_information_schema_view&stats=yes |
[Content](console/info-schema/view.sql?name=console_information_schema_view&stats=yes) |
[console_information_schema_view (view) Schema](console/info-schema/view.sql?name=console_information_schema_view&stats=yes) |
/console/content/view/console_information_schema_view.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/console_information_schema_view.sql?stats=yes) |
[console_information_schema_view (view) Content](console/content/view/console_information_schema_view.sql?stats=yes) |
CREATE VIEW console_information_schema_view AS
SELECT
vw.name AS view_name,
col.name AS column_name,
col.type AS data_type,
'/console/info-schema/view.sql?name=' || vw.name || '&stats=yes' as info_schema_web_ui_path,
'[Content](console/info-schema/view.sql?name=' || vw.name || '&stats=yes)' as info_schema_link_abbrev_md,
'[' || vw.name || ' (view) Schema](console/info-schema/view.sql?name=' || vw.name || '&stats=yes)' as info_schema_link_full_md,
'/console/content/view/' || vw.name || '.sql?stats=yes' as content_web_ui_path,
'[Content]($SITE_PREFIX_URL/console/content/view/' || vw.name || '.sql?stats=yes)' as content_web_ui_link_abbrev_md,
'[' || vw.name || ' (view) Content](console/content/view/' || vw.name || '.sql?stats=yes)' as content_web_ui_link_full_md,
vw.sql as sql_ddl
FROM sqlite_master vw
JOIN pragma_table_info(vw.name) col
WHERE vw.type = 'view' AND vw.name NOT LIKE 'sqlite_%' |
| console_information_schema_view |
sql_ddl |
TEXT |
/console/info-schema/view.sql?name=console_information_schema_view&stats=yes |
[Content](console/info-schema/view.sql?name=console_information_schema_view&stats=yes) |
[console_information_schema_view (view) Schema](console/info-schema/view.sql?name=console_information_schema_view&stats=yes) |
/console/content/view/console_information_schema_view.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/console_information_schema_view.sql?stats=yes) |
[console_information_schema_view (view) Content](console/content/view/console_information_schema_view.sql?stats=yes) |
CREATE VIEW console_information_schema_view AS
SELECT
vw.name AS view_name,
col.name AS column_name,
col.type AS data_type,
'/console/info-schema/view.sql?name=' || vw.name || '&stats=yes' as info_schema_web_ui_path,
'[Content](console/info-schema/view.sql?name=' || vw.name || '&stats=yes)' as info_schema_link_abbrev_md,
'[' || vw.name || ' (view) Schema](console/info-schema/view.sql?name=' || vw.name || '&stats=yes)' as info_schema_link_full_md,
'/console/content/view/' || vw.name || '.sql?stats=yes' as content_web_ui_path,
'[Content]($SITE_PREFIX_URL/console/content/view/' || vw.name || '.sql?stats=yes)' as content_web_ui_link_abbrev_md,
'[' || vw.name || ' (view) Content](console/content/view/' || vw.name || '.sql?stats=yes)' as content_web_ui_link_full_md,
vw.sql as sql_ddl
FROM sqlite_master vw
JOIN pragma_table_info(vw.name) col
WHERE vw.type = 'view' AND vw.name NOT LIKE 'sqlite_%' |
| console_content_tabular |
tabular_nature |
|
/console/info-schema/view.sql?name=console_content_tabular&stats=yes |
[Content](console/info-schema/view.sql?name=console_content_tabular&stats=yes) |
[console_content_tabular (view) Schema](console/info-schema/view.sql?name=console_content_tabular&stats=yes) |
/console/content/view/console_content_tabular.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/console_content_tabular.sql?stats=yes) |
[console_content_tabular (view) Content](console/content/view/console_content_tabular.sql?stats=yes) |
CREATE VIEW console_content_tabular AS
SELECT 'table' as tabular_nature,
table_name as tabular_name,
info_schema_web_ui_path,
info_schema_link_abbrev_md,
info_schema_link_full_md,
content_web_ui_path,
content_web_ui_link_abbrev_md,
content_web_ui_link_full_md
FROM console_information_schema_table
UNION ALL
SELECT 'view' as tabular_nature,
view_name as tabular_name,
info_schema_web_ui_path,
info_schema_link_abbrev_md,
info_schema_link_full_md,
content_web_ui_path,
content_web_ui_link_abbrev_md,
content_web_ui_link_full_md
FROM console_information_schema_view |
| console_content_tabular |
tabular_name |
TEXT |
/console/info-schema/view.sql?name=console_content_tabular&stats=yes |
[Content](console/info-schema/view.sql?name=console_content_tabular&stats=yes) |
[console_content_tabular (view) Schema](console/info-schema/view.sql?name=console_content_tabular&stats=yes) |
/console/content/view/console_content_tabular.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/console_content_tabular.sql?stats=yes) |
[console_content_tabular (view) Content](console/content/view/console_content_tabular.sql?stats=yes) |
CREATE VIEW console_content_tabular AS
SELECT 'table' as tabular_nature,
table_name as tabular_name,
info_schema_web_ui_path,
info_schema_link_abbrev_md,
info_schema_link_full_md,
content_web_ui_path,
content_web_ui_link_abbrev_md,
content_web_ui_link_full_md
FROM console_information_schema_table
UNION ALL
SELECT 'view' as tabular_nature,
view_name as tabular_name,
info_schema_web_ui_path,
info_schema_link_abbrev_md,
info_schema_link_full_md,
content_web_ui_path,
content_web_ui_link_abbrev_md,
content_web_ui_link_full_md
FROM console_information_schema_view |
| console_content_tabular |
info_schema_web_ui_path |
|
/console/info-schema/view.sql?name=console_content_tabular&stats=yes |
[Content](console/info-schema/view.sql?name=console_content_tabular&stats=yes) |
[console_content_tabular (view) Schema](console/info-schema/view.sql?name=console_content_tabular&stats=yes) |
/console/content/view/console_content_tabular.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/console_content_tabular.sql?stats=yes) |
[console_content_tabular (view) Content](console/content/view/console_content_tabular.sql?stats=yes) |
CREATE VIEW console_content_tabular AS
SELECT 'table' as tabular_nature,
table_name as tabular_name,
info_schema_web_ui_path,
info_schema_link_abbrev_md,
info_schema_link_full_md,
content_web_ui_path,
content_web_ui_link_abbrev_md,
content_web_ui_link_full_md
FROM console_information_schema_table
UNION ALL
SELECT 'view' as tabular_nature,
view_name as tabular_name,
info_schema_web_ui_path,
info_schema_link_abbrev_md,
info_schema_link_full_md,
content_web_ui_path,
content_web_ui_link_abbrev_md,
content_web_ui_link_full_md
FROM console_information_schema_view |
| console_content_tabular |
info_schema_link_abbrev_md |
|
/console/info-schema/view.sql?name=console_content_tabular&stats=yes |
[Content](console/info-schema/view.sql?name=console_content_tabular&stats=yes) |
[console_content_tabular (view) Schema](console/info-schema/view.sql?name=console_content_tabular&stats=yes) |
/console/content/view/console_content_tabular.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/console_content_tabular.sql?stats=yes) |
[console_content_tabular (view) Content](console/content/view/console_content_tabular.sql?stats=yes) |
CREATE VIEW console_content_tabular AS
SELECT 'table' as tabular_nature,
table_name as tabular_name,
info_schema_web_ui_path,
info_schema_link_abbrev_md,
info_schema_link_full_md,
content_web_ui_path,
content_web_ui_link_abbrev_md,
content_web_ui_link_full_md
FROM console_information_schema_table
UNION ALL
SELECT 'view' as tabular_nature,
view_name as tabular_name,
info_schema_web_ui_path,
info_schema_link_abbrev_md,
info_schema_link_full_md,
content_web_ui_path,
content_web_ui_link_abbrev_md,
content_web_ui_link_full_md
FROM console_information_schema_view |
| console_content_tabular |
info_schema_link_full_md |
|
/console/info-schema/view.sql?name=console_content_tabular&stats=yes |
[Content](console/info-schema/view.sql?name=console_content_tabular&stats=yes) |
[console_content_tabular (view) Schema](console/info-schema/view.sql?name=console_content_tabular&stats=yes) |
/console/content/view/console_content_tabular.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/console_content_tabular.sql?stats=yes) |
[console_content_tabular (view) Content](console/content/view/console_content_tabular.sql?stats=yes) |
CREATE VIEW console_content_tabular AS
SELECT 'table' as tabular_nature,
table_name as tabular_name,
info_schema_web_ui_path,
info_schema_link_abbrev_md,
info_schema_link_full_md,
content_web_ui_path,
content_web_ui_link_abbrev_md,
content_web_ui_link_full_md
FROM console_information_schema_table
UNION ALL
SELECT 'view' as tabular_nature,
view_name as tabular_name,
info_schema_web_ui_path,
info_schema_link_abbrev_md,
info_schema_link_full_md,
content_web_ui_path,
content_web_ui_link_abbrev_md,
content_web_ui_link_full_md
FROM console_information_schema_view |
| console_content_tabular |
content_web_ui_path |
|
/console/info-schema/view.sql?name=console_content_tabular&stats=yes |
[Content](console/info-schema/view.sql?name=console_content_tabular&stats=yes) |
[console_content_tabular (view) Schema](console/info-schema/view.sql?name=console_content_tabular&stats=yes) |
/console/content/view/console_content_tabular.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/console_content_tabular.sql?stats=yes) |
[console_content_tabular (view) Content](console/content/view/console_content_tabular.sql?stats=yes) |
CREATE VIEW console_content_tabular AS
SELECT 'table' as tabular_nature,
table_name as tabular_name,
info_schema_web_ui_path,
info_schema_link_abbrev_md,
info_schema_link_full_md,
content_web_ui_path,
content_web_ui_link_abbrev_md,
content_web_ui_link_full_md
FROM console_information_schema_table
UNION ALL
SELECT 'view' as tabular_nature,
view_name as tabular_name,
info_schema_web_ui_path,
info_schema_link_abbrev_md,
info_schema_link_full_md,
content_web_ui_path,
content_web_ui_link_abbrev_md,
content_web_ui_link_full_md
FROM console_information_schema_view |
| console_content_tabular |
content_web_ui_link_abbrev_md |
|
/console/info-schema/view.sql?name=console_content_tabular&stats=yes |
[Content](console/info-schema/view.sql?name=console_content_tabular&stats=yes) |
[console_content_tabular (view) Schema](console/info-schema/view.sql?name=console_content_tabular&stats=yes) |
/console/content/view/console_content_tabular.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/console_content_tabular.sql?stats=yes) |
[console_content_tabular (view) Content](console/content/view/console_content_tabular.sql?stats=yes) |
CREATE VIEW console_content_tabular AS
SELECT 'table' as tabular_nature,
table_name as tabular_name,
info_schema_web_ui_path,
info_schema_link_abbrev_md,
info_schema_link_full_md,
content_web_ui_path,
content_web_ui_link_abbrev_md,
content_web_ui_link_full_md
FROM console_information_schema_table
UNION ALL
SELECT 'view' as tabular_nature,
view_name as tabular_name,
info_schema_web_ui_path,
info_schema_link_abbrev_md,
info_schema_link_full_md,
content_web_ui_path,
content_web_ui_link_abbrev_md,
content_web_ui_link_full_md
FROM console_information_schema_view |
| console_content_tabular |
content_web_ui_link_full_md |
|
/console/info-schema/view.sql?name=console_content_tabular&stats=yes |
[Content](console/info-schema/view.sql?name=console_content_tabular&stats=yes) |
[console_content_tabular (view) Schema](console/info-schema/view.sql?name=console_content_tabular&stats=yes) |
/console/content/view/console_content_tabular.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/console_content_tabular.sql?stats=yes) |
[console_content_tabular (view) Content](console/content/view/console_content_tabular.sql?stats=yes) |
CREATE VIEW console_content_tabular AS
SELECT 'table' as tabular_nature,
table_name as tabular_name,
info_schema_web_ui_path,
info_schema_link_abbrev_md,
info_schema_link_full_md,
content_web_ui_path,
content_web_ui_link_abbrev_md,
content_web_ui_link_full_md
FROM console_information_schema_table
UNION ALL
SELECT 'view' as tabular_nature,
view_name as tabular_name,
info_schema_web_ui_path,
info_schema_link_abbrev_md,
info_schema_link_full_md,
content_web_ui_path,
content_web_ui_link_abbrev_md,
content_web_ui_link_full_md
FROM console_information_schema_view |
| console_information_schema_table_col_fkey |
table_name |
TEXT |
/console/info-schema/view.sql?name=console_information_schema_table_col_fkey&stats=yes |
[Content](console/info-schema/view.sql?name=console_information_schema_table_col_fkey&stats=yes) |
[console_information_schema_table_col_fkey (view) Schema](console/info-schema/view.sql?name=console_information_schema_table_col_fkey&stats=yes) |
/console/content/view/console_information_schema_table_col_fkey.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/console_information_schema_table_col_fkey.sql?stats=yes) |
[console_information_schema_table_col_fkey (view) Content](console/content/view/console_information_schema_table_col_fkey.sql?stats=yes) |
CREATE VIEW console_information_schema_table_col_fkey AS
SELECT
tbl.name AS table_name,
f."from" AS column_name,
f."from" || ' references ' || f."table" || '.' || f."to" AS foreign_key
FROM sqlite_master tbl
JOIN pragma_foreign_key_list(tbl.name) f
WHERE tbl.type = 'table' AND tbl.name NOT LIKE 'sqlite_%' |
| console_information_schema_table_col_fkey |
column_name |
BLOB |
/console/info-schema/view.sql?name=console_information_schema_table_col_fkey&stats=yes |
[Content](console/info-schema/view.sql?name=console_information_schema_table_col_fkey&stats=yes) |
[console_information_schema_table_col_fkey (view) Schema](console/info-schema/view.sql?name=console_information_schema_table_col_fkey&stats=yes) |
/console/content/view/console_information_schema_table_col_fkey.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/console_information_schema_table_col_fkey.sql?stats=yes) |
[console_information_schema_table_col_fkey (view) Content](console/content/view/console_information_schema_table_col_fkey.sql?stats=yes) |
CREATE VIEW console_information_schema_table_col_fkey AS
SELECT
tbl.name AS table_name,
f."from" AS column_name,
f."from" || ' references ' || f."table" || '.' || f."to" AS foreign_key
FROM sqlite_master tbl
JOIN pragma_foreign_key_list(tbl.name) f
WHERE tbl.type = 'table' AND tbl.name NOT LIKE 'sqlite_%' |
| console_information_schema_table_col_fkey |
foreign_key |
|
/console/info-schema/view.sql?name=console_information_schema_table_col_fkey&stats=yes |
[Content](console/info-schema/view.sql?name=console_information_schema_table_col_fkey&stats=yes) |
[console_information_schema_table_col_fkey (view) Schema](console/info-schema/view.sql?name=console_information_schema_table_col_fkey&stats=yes) |
/console/content/view/console_information_schema_table_col_fkey.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/console_information_schema_table_col_fkey.sql?stats=yes) |
[console_information_schema_table_col_fkey (view) Content](console/content/view/console_information_schema_table_col_fkey.sql?stats=yes) |
CREATE VIEW console_information_schema_table_col_fkey AS
SELECT
tbl.name AS table_name,
f."from" AS column_name,
f."from" || ' references ' || f."table" || '.' || f."to" AS foreign_key
FROM sqlite_master tbl
JOIN pragma_foreign_key_list(tbl.name) f
WHERE tbl.type = 'table' AND tbl.name NOT LIKE 'sqlite_%' |
| console_information_schema_table_col_index |
table_name |
TEXT |
/console/info-schema/view.sql?name=console_information_schema_table_col_index&stats=yes |
[Content](console/info-schema/view.sql?name=console_information_schema_table_col_index&stats=yes) |
[console_information_schema_table_col_index (view) Schema](console/info-schema/view.sql?name=console_information_schema_table_col_index&stats=yes) |
/console/content/view/console_information_schema_table_col_index.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/console_information_schema_table_col_index.sql?stats=yes) |
[console_information_schema_table_col_index (view) Content](console/content/view/console_information_schema_table_col_index.sql?stats=yes) |
CREATE VIEW console_information_schema_table_col_index AS
SELECT
tbl.name AS table_name,
pi.name AS column_name,
idx.name AS index_name
FROM sqlite_master tbl
JOIN pragma_index_list(tbl.name) idx
JOIN pragma_index_info(idx.name) pi
WHERE tbl.type = 'table' AND tbl.name NOT LIKE 'sqlite_%' |
| console_information_schema_table_col_index |
column_name |
BLOB |
/console/info-schema/view.sql?name=console_information_schema_table_col_index&stats=yes |
[Content](console/info-schema/view.sql?name=console_information_schema_table_col_index&stats=yes) |
[console_information_schema_table_col_index (view) Schema](console/info-schema/view.sql?name=console_information_schema_table_col_index&stats=yes) |
/console/content/view/console_information_schema_table_col_index.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/console_information_schema_table_col_index.sql?stats=yes) |
[console_information_schema_table_col_index (view) Content](console/content/view/console_information_schema_table_col_index.sql?stats=yes) |
CREATE VIEW console_information_schema_table_col_index AS
SELECT
tbl.name AS table_name,
pi.name AS column_name,
idx.name AS index_name
FROM sqlite_master tbl
JOIN pragma_index_list(tbl.name) idx
JOIN pragma_index_info(idx.name) pi
WHERE tbl.type = 'table' AND tbl.name NOT LIKE 'sqlite_%' |
| console_information_schema_table_col_index |
index_name |
BLOB |
/console/info-schema/view.sql?name=console_information_schema_table_col_index&stats=yes |
[Content](console/info-schema/view.sql?name=console_information_schema_table_col_index&stats=yes) |
[console_information_schema_table_col_index (view) Schema](console/info-schema/view.sql?name=console_information_schema_table_col_index&stats=yes) |
/console/content/view/console_information_schema_table_col_index.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/console_information_schema_table_col_index.sql?stats=yes) |
[console_information_schema_table_col_index (view) Content](console/content/view/console_information_schema_table_col_index.sql?stats=yes) |
CREATE VIEW console_information_schema_table_col_index AS
SELECT
tbl.name AS table_name,
pi.name AS column_name,
idx.name AS index_name
FROM sqlite_master tbl
JOIN pragma_index_list(tbl.name) idx
JOIN pragma_index_info(idx.name) pi
WHERE tbl.type = 'table' AND tbl.name NOT LIKE 'sqlite_%' |
| rssd_statistics_overview |
db_size_mb |
|
/console/info-schema/view.sql?name=rssd_statistics_overview&stats=yes |
[Content](console/info-schema/view.sql?name=rssd_statistics_overview&stats=yes) |
[rssd_statistics_overview (view) Schema](console/info-schema/view.sql?name=rssd_statistics_overview&stats=yes) |
/console/content/view/rssd_statistics_overview.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/rssd_statistics_overview.sql?stats=yes) |
[rssd_statistics_overview (view) Content](console/content/view/rssd_statistics_overview.sql?stats=yes) |
CREATE VIEW rssd_statistics_overview AS
SELECT
(SELECT ROUND(page_count * page_size / (1024.0 * 1024), 2) FROM pragma_page_count(), pragma_page_size()) AS db_size_mb,
(SELECT ROUND(page_count * page_size / (1024.0 * 1024 * 1024), 4) FROM pragma_page_count(), pragma_page_size()) AS db_size_gb,
(SELECT COUNT(*) FROM sqlite_master WHERE type = 'table') AS total_tables,
(SELECT COUNT(*) FROM sqlite_master WHERE type = 'index') AS total_indexes,
(SELECT SUM(tbl_rows) FROM (
SELECT name,
(SELECT COUNT(*) FROM sqlite_master sm WHERE sm.type='table' AND sm.name=t.name) AS tbl_rows
FROM sqlite_master t WHERE type='table'
)) AS total_rows,
(SELECT page_size FROM pragma_page_size()) AS page_size,
(SELECT page_count FROM pragma_page_count()) AS total_pages |
| rssd_statistics_overview |
db_size_gb |
|
/console/info-schema/view.sql?name=rssd_statistics_overview&stats=yes |
[Content](console/info-schema/view.sql?name=rssd_statistics_overview&stats=yes) |
[rssd_statistics_overview (view) Schema](console/info-schema/view.sql?name=rssd_statistics_overview&stats=yes) |
/console/content/view/rssd_statistics_overview.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/rssd_statistics_overview.sql?stats=yes) |
[rssd_statistics_overview (view) Content](console/content/view/rssd_statistics_overview.sql?stats=yes) |
CREATE VIEW rssd_statistics_overview AS
SELECT
(SELECT ROUND(page_count * page_size / (1024.0 * 1024), 2) FROM pragma_page_count(), pragma_page_size()) AS db_size_mb,
(SELECT ROUND(page_count * page_size / (1024.0 * 1024 * 1024), 4) FROM pragma_page_count(), pragma_page_size()) AS db_size_gb,
(SELECT COUNT(*) FROM sqlite_master WHERE type = 'table') AS total_tables,
(SELECT COUNT(*) FROM sqlite_master WHERE type = 'index') AS total_indexes,
(SELECT SUM(tbl_rows) FROM (
SELECT name,
(SELECT COUNT(*) FROM sqlite_master sm WHERE sm.type='table' AND sm.name=t.name) AS tbl_rows
FROM sqlite_master t WHERE type='table'
)) AS total_rows,
(SELECT page_size FROM pragma_page_size()) AS page_size,
(SELECT page_count FROM pragma_page_count()) AS total_pages |