sqlpage_files (table) Content
| drh/cgm-data/raw-cgm/uniform_resource_cgm_tracing.sql | SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties; -- not including breadcrumbs from sqlpage_aide_navigation -- not including page title from sqlpage_aide_navigation SELECT 'breadcrumb' as component; WITH RECURSIVE breadcrumbs AS ( SELECT COALESCE(abbreviated_caption, caption) AS title, COALESCE(url, path) AS link, parent_path, 0 AS level, namespace FROM sqlpage_aide_navigation WHERE namespace = 'prime' AND path = 'drh/cgm-data' UNION ALL SELECT COALESCE(nav.abbreviated_caption, nav.caption) AS title, COALESCE(nav.url, nav.path) AS link, nav.parent_path, b.level + 1, nav.namespace FROM sqlpage_aide_navigation nav INNER JOIN breadcrumbs b ON nav.namespace = b.namespace AND nav.path = b.parent_path ) SELECT title, link FROM breadcrumbs ORDER BY level DESC; SELECT 'uniform_resource_cgm_tracing' || ' Table' AS title, '#' AS link; SELECT 'title' AS component, 'uniform_resource_cgm_tracing' AS contents; -- Initialize pagination SET total_rows = (SELECT COUNT(*) FROM 'uniform_resource_cgm_tracing'); SET limit = COALESCE($limit, 50); SET offset = COALESCE($offset, 0); SET total_pages = ($total_rows + $limit - 1) / $limit; SET current_page = ($offset / $limit) + 1; -- Display table with pagination SELECT 'table' AS component, TRUE AS sort, TRUE AS search; SELECT * FROM 'uniform_resource_cgm_tracing' LIMIT $limit OFFSET $offset; SELECT 'text' AS component, (SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE '' END) || ' ' || '(Page ' || $current_page || ' of ' || $total_pages || ')' || ' ' || (SELECT CASE WHEN $current_page < $total_pages THEN '[Next](?limit=' || $limit || '&offset=' || ($offset + $limit) || ')' ELSE '' END) AS contents_md; | 2024-12-24 11:04:36 |
| console/content/table/sqlean_define.auto.sql | SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties; SELECT 'breadcrumb' AS component; SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link; SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link; SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link; SELECT 'sqlean_define table' as title, '#' AS link; SELECT 'title' AS component, 'sqlean_define (table) Content' as contents; SET total_rows = (SELECT COUNT(*) FROM sqlean_define); SET limit = COALESCE($limit, 50); SET offset = COALESCE($offset, 0); SET total_pages = ($total_rows + $limit - 1) / $limit; SET current_page = ($offset / $limit) + 1; SELECT 'text' AS component, '[sqlean_define (table) Schema](console/info-schema/table.sql?name=sqlean_define&stats=yes)' AS contents_md SELECT 'text' AS component, '- Start Row: ' || $offset || ' ' || '- Rows per Page: ' || $limit || ' ' || '- Total Rows: ' || $total_rows || ' ' || '- Current Page: ' || $current_page || ' ' || '- Total Pages: ' || $total_pages as contents_md WHERE $stats IS NOT NULL; -- Display uniform_resource table with pagination SELECT 'table' AS component, TRUE AS sort, TRUE AS search, TRUE AS hover, TRUE AS striped_rows, TRUE AS small; SELECT * FROM sqlean_define LIMIT $limit OFFSET $offset; SELECT 'text' AS component, (SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE '' END) || ' ' || '(Page ' || $current_page || ' of ' || $total_pages || ') ' || (SELECT CASE WHEN $current_page < $total_pages THEN '[Next](?limit=' || $limit || '&offset=' || ($offset + $limit) || ')' ELSE '' END) AS contents_md; | 2024-12-24 11:04:36 |
| console/content/table/assurance_schema.auto.sql | SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties; SELECT 'breadcrumb' AS component; SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link; SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link; SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link; SELECT 'assurance_schema table' as title, '#' AS link; SELECT 'title' AS component, 'assurance_schema (table) Content' as contents; SET total_rows = (SELECT COUNT(*) FROM assurance_schema); SET limit = COALESCE($limit, 50); SET offset = COALESCE($offset, 0); SET total_pages = ($total_rows + $limit - 1) / $limit; SET current_page = ($offset / $limit) + 1; SELECT 'text' AS component, '[assurance_schema (table) Schema](console/info-schema/table.sql?name=assurance_schema&stats=yes)' AS contents_md SELECT 'text' AS component, '- Start Row: ' || $offset || ' ' || '- Rows per Page: ' || $limit || ' ' || '- Total Rows: ' || $total_rows || ' ' || '- Current Page: ' || $current_page || ' ' || '- Total Pages: ' || $total_pages as contents_md WHERE $stats IS NOT NULL; -- Display uniform_resource table with pagination SELECT 'table' AS component, TRUE AS sort, TRUE AS search, TRUE AS hover, TRUE AS striped_rows, TRUE AS small; SELECT * FROM assurance_schema LIMIT $limit OFFSET $offset; SELECT 'text' AS component, (SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE '' END) || ' ' || '(Page ' || $current_page || ' of ' || $total_pages || ') ' || (SELECT CASE WHEN $current_page < $total_pages THEN '[Next](?limit=' || $limit || '&offset=' || ($offset + $limit) || ')' ELSE '' END) AS contents_md; | 2024-12-24 11:04:36 |
| console/content/table/code_notebook_kernel.auto.sql | SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties; SELECT 'breadcrumb' AS component; SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link; SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link; SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link; SELECT 'code_notebook_kernel table' as title, '#' AS link; SELECT 'title' AS component, 'code_notebook_kernel (table) Content' as contents; SET total_rows = (SELECT COUNT(*) FROM code_notebook_kernel); SET limit = COALESCE($limit, 50); SET offset = COALESCE($offset, 0); SET total_pages = ($total_rows + $limit - 1) / $limit; SET current_page = ($offset / $limit) + 1; SELECT 'text' AS component, '[code_notebook_kernel (table) Schema](console/info-schema/table.sql?name=code_notebook_kernel&stats=yes)' AS contents_md SELECT 'text' AS component, '- Start Row: ' || $offset || ' ' || '- Rows per Page: ' || $limit || ' ' || '- Total Rows: ' || $total_rows || ' ' || '- Current Page: ' || $current_page || ' ' || '- Total Pages: ' || $total_pages as contents_md WHERE $stats IS NOT NULL; -- Display uniform_resource table with pagination SELECT 'table' AS component, TRUE AS sort, TRUE AS search, TRUE AS hover, TRUE AS striped_rows, TRUE AS small; SELECT * FROM code_notebook_kernel LIMIT $limit OFFSET $offset; SELECT 'text' AS component, (SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE '' END) || ' ' || '(Page ' || $current_page || ' of ' || $total_pages || ') ' || (SELECT CASE WHEN $current_page < $total_pages THEN '[Next](?limit=' || $limit || '&offset=' || ($offset + $limit) || ')' ELSE '' END) AS contents_md; | 2024-12-24 11:04:36 |
| console/content/table/code_notebook_cell.auto.sql | SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties; SELECT 'breadcrumb' AS component; SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link; SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link; SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link; SELECT 'code_notebook_cell table' as title, '#' AS link; SELECT 'title' AS component, 'code_notebook_cell (table) Content' as contents; SET total_rows = (SELECT COUNT(*) FROM code_notebook_cell); SET limit = COALESCE($limit, 50); SET offset = COALESCE($offset, 0); SET total_pages = ($total_rows + $limit - 1) / $limit; SET current_page = ($offset / $limit) + 1; SELECT 'text' AS component, '[code_notebook_cell (table) Schema](console/info-schema/table.sql?name=code_notebook_cell&stats=yes)' AS contents_md SELECT 'text' AS component, '- Start Row: ' || $offset || ' ' || '- Rows per Page: ' || $limit || ' ' || '- Total Rows: ' || $total_rows || ' ' || '- Current Page: ' || $current_page || ' ' || '- Total Pages: ' || $total_pages as contents_md WHERE $stats IS NOT NULL; -- Display uniform_resource table with pagination SELECT 'table' AS component, TRUE AS sort, TRUE AS search, TRUE AS hover, TRUE AS striped_rows, TRUE AS small; SELECT * FROM code_notebook_cell LIMIT $limit OFFSET $offset; SELECT 'text' AS component, (SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE '' END) || ' ' || '(Page ' || $current_page || ' of ' || $total_pages || ') ' || (SELECT CASE WHEN $current_page < $total_pages THEN '[Next](?limit=' || $limit || '&offset=' || ($offset + $limit) || ')' ELSE '' END) AS contents_md; | 2024-12-24 11:04:36 |
| console/content/table/code_notebook_state.auto.sql | SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties; SELECT 'breadcrumb' AS component; SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link; SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link; SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link; SELECT 'code_notebook_state table' as title, '#' AS link; SELECT 'title' AS component, 'code_notebook_state (table) Content' as contents; SET total_rows = (SELECT COUNT(*) FROM code_notebook_state); SET limit = COALESCE($limit, 50); SET offset = COALESCE($offset, 0); SET total_pages = ($total_rows + $limit - 1) / $limit; SET current_page = ($offset / $limit) + 1; SELECT 'text' AS component, '[code_notebook_state (table) Schema](console/info-schema/table.sql?name=code_notebook_state&stats=yes)' AS contents_md SELECT 'text' AS component, '- Start Row: ' || $offset || ' ' || '- Rows per Page: ' || $limit || ' ' || '- Total Rows: ' || $total_rows || ' ' || '- Current Page: ' || $current_page || ' ' || '- Total Pages: ' || $total_pages as contents_md WHERE $stats IS NOT NULL; -- Display uniform_resource table with pagination SELECT 'table' AS component, TRUE AS sort, TRUE AS search, TRUE AS hover, TRUE AS striped_rows, TRUE AS small; SELECT * FROM code_notebook_state LIMIT $limit OFFSET $offset; SELECT 'text' AS component, (SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE '' END) || ' ' || '(Page ' || $current_page || ' of ' || $total_pages || ') ' || (SELECT CASE WHEN $current_page < $total_pages THEN '[Next](?limit=' || $limit || '&offset=' || ($offset + $limit) || ')' ELSE '' END) AS contents_md; | 2024-12-24 11:04:36 |
| console/content/table/surveilr_function_doc.auto.sql | SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties; SELECT 'breadcrumb' AS component; SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link; SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link; SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link; SELECT 'surveilr_function_doc table' as title, '#' AS link; SELECT 'title' AS component, 'surveilr_function_doc (table) Content' as contents; SET total_rows = (SELECT COUNT(*) FROM surveilr_function_doc); SET limit = COALESCE($limit, 50); SET offset = COALESCE($offset, 0); SET total_pages = ($total_rows + $limit - 1) / $limit; SET current_page = ($offset / $limit) + 1; SELECT 'text' AS component, '[surveilr_function_doc (table) Schema](console/info-schema/table.sql?name=surveilr_function_doc&stats=yes)' AS contents_md SELECT 'text' AS component, '- Start Row: ' || $offset || ' ' || '- Rows per Page: ' || $limit || ' ' || '- Total Rows: ' || $total_rows || ' ' || '- Current Page: ' || $current_page || ' ' || '- Total Pages: ' || $total_pages as contents_md WHERE $stats IS NOT NULL; -- Display uniform_resource table with pagination SELECT 'table' AS component, TRUE AS sort, TRUE AS search, TRUE AS hover, TRUE AS striped_rows, TRUE AS small; SELECT * FROM surveilr_function_doc LIMIT $limit OFFSET $offset; SELECT 'text' AS component, (SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE '' END) || ' ' || '(Page ' || $current_page || ' of ' || $total_pages || ') ' || (SELECT CASE WHEN $current_page < $total_pages THEN '[Next](?limit=' || $limit || '&offset=' || ($offset + $limit) || ')' ELSE '' END) AS contents_md; | 2024-12-24 11:04:36 |
| console/content/table/sqlpage_files.auto.sql | SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties; SELECT 'breadcrumb' AS component; SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link; SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link; SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link; SELECT 'sqlpage_files table' as title, '#' AS link; SELECT 'title' AS component, 'sqlpage_files (table) Content' as contents; SET total_rows = (SELECT COUNT(*) FROM sqlpage_files); SET limit = COALESCE($limit, 50); SET offset = COALESCE($offset, 0); SET total_pages = ($total_rows + $limit - 1) / $limit; SET current_page = ($offset / $limit) + 1; SELECT 'text' AS component, '[sqlpage_files (table) Schema](console/info-schema/table.sql?name=sqlpage_files&stats=yes)' AS contents_md SELECT 'text' AS component, '- Start Row: ' || $offset || ' ' || '- Rows per Page: ' || $limit || ' ' || '- Total Rows: ' || $total_rows || ' ' || '- Current Page: ' || $current_page || ' ' || '- Total Pages: ' || $total_pages as contents_md WHERE $stats IS NOT NULL; -- Display uniform_resource table with pagination SELECT 'table' AS component, TRUE AS sort, TRUE AS search, TRUE AS hover, TRUE AS striped_rows, TRUE AS small; SELECT * FROM sqlpage_files LIMIT $limit OFFSET $offset; SELECT 'text' AS component, (SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE '' END) || ' ' || '(Page ' || $current_page || ' of ' || $total_pages || ') ' || (SELECT CASE WHEN $current_page < $total_pages THEN '[Next](?limit=' || $limit || '&offset=' || ($offset + $limit) || ')' ELSE '' END) AS contents_md; | 2024-12-24 11:04:36 |
| console/content/table/sqlpage_aide_navigation.auto.sql | SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties; SELECT 'breadcrumb' AS component; SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link; SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link; SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link; SELECT 'sqlpage_aide_navigation table' as title, '#' AS link; SELECT 'title' AS component, 'sqlpage_aide_navigation (table) Content' as contents; SET total_rows = (SELECT COUNT(*) FROM sqlpage_aide_navigation); SET limit = COALESCE($limit, 50); SET offset = COALESCE($offset, 0); SET total_pages = ($total_rows + $limit - 1) / $limit; SET current_page = ($offset / $limit) + 1; SELECT 'text' AS component, '[sqlpage_aide_navigation (table) Schema](console/info-schema/table.sql?name=sqlpage_aide_navigation&stats=yes)' AS contents_md SELECT 'text' AS component, '- Start Row: ' || $offset || ' ' || '- Rows per Page: ' || $limit || ' ' || '- Total Rows: ' || $total_rows || ' ' || '- Current Page: ' || $current_page || ' ' || '- Total Pages: ' || $total_pages as contents_md WHERE $stats IS NOT NULL; -- Display uniform_resource table with pagination SELECT 'table' AS component, TRUE AS sort, TRUE AS search, TRUE AS hover, TRUE AS striped_rows, TRUE AS small; SELECT * FROM sqlpage_aide_navigation LIMIT $limit OFFSET $offset; SELECT 'text' AS component, (SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE '' END) || ' ' || '(Page ' || $current_page || ' of ' || $total_pages || ') ' || (SELECT CASE WHEN $current_page < $total_pages THEN '[Next](?limit=' || $limit || '&offset=' || ($offset + $limit) || ')' ELSE '' END) AS contents_md; | 2024-12-24 11:04:36 |
| console/content/table/party_type.auto.sql | SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties; SELECT 'breadcrumb' AS component; SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link; SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link; SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link; SELECT 'party_type table' as title, '#' AS link; SELECT 'title' AS component, 'party_type (table) Content' as contents; SET total_rows = (SELECT COUNT(*) FROM party_type); SET limit = COALESCE($limit, 50); SET offset = COALESCE($offset, 0); SET total_pages = ($total_rows + $limit - 1) / $limit; SET current_page = ($offset / $limit) + 1; SELECT 'text' AS component, '[party_type (table) Schema](console/info-schema/table.sql?name=party_type&stats=yes)' AS contents_md SELECT 'text' AS component, '- Start Row: ' || $offset || ' ' || '- Rows per Page: ' || $limit || ' ' || '- Total Rows: ' || $total_rows || ' ' || '- Current Page: ' || $current_page || ' ' || '- Total Pages: ' || $total_pages as contents_md WHERE $stats IS NOT NULL; -- Display uniform_resource table with pagination SELECT 'table' AS component, TRUE AS sort, TRUE AS search, TRUE AS hover, TRUE AS striped_rows, TRUE AS small; SELECT * FROM party_type LIMIT $limit OFFSET $offset; SELECT 'text' AS component, (SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE '' END) || ' ' || '(Page ' || $current_page || ' of ' || $total_pages || ') ' || (SELECT CASE WHEN $current_page < $total_pages THEN '[Next](?limit=' || $limit || '&offset=' || ($offset + $limit) || ')' ELSE '' END) AS contents_md; | 2024-12-24 11:04:36 |
| console/content/table/party.auto.sql | SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties; SELECT 'breadcrumb' AS component; SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link; SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link; SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link; SELECT 'party table' as title, '#' AS link; SELECT 'title' AS component, 'party (table) Content' as contents; SET total_rows = (SELECT COUNT(*) FROM party); SET limit = COALESCE($limit, 50); SET offset = COALESCE($offset, 0); SET total_pages = ($total_rows + $limit - 1) / $limit; SET current_page = ($offset / $limit) + 1; SELECT 'text' AS component, '[party (table) Schema](console/info-schema/table.sql?name=party&stats=yes)' AS contents_md SELECT 'text' AS component, '- Start Row: ' || $offset || ' ' || '- Rows per Page: ' || $limit || ' ' || '- Total Rows: ' || $total_rows || ' ' || '- Current Page: ' || $current_page || ' ' || '- Total Pages: ' || $total_pages as contents_md WHERE $stats IS NOT NULL; -- Display uniform_resource table with pagination SELECT 'table' AS component, TRUE AS sort, TRUE AS search, TRUE AS hover, TRUE AS striped_rows, TRUE AS small; SELECT * FROM party LIMIT $limit OFFSET $offset; SELECT 'text' AS component, (SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE '' END) || ' ' || '(Page ' || $current_page || ' of ' || $total_pages || ') ' || (SELECT CASE WHEN $current_page < $total_pages THEN '[Next](?limit=' || $limit || '&offset=' || ($offset + $limit) || ')' ELSE '' END) AS contents_md; | 2024-12-24 11:04:36 |
| console/content/table/party_relation_type.auto.sql | SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties; SELECT 'breadcrumb' AS component; SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link; SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link; SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link; SELECT 'party_relation_type table' as title, '#' AS link; SELECT 'title' AS component, 'party_relation_type (table) Content' as contents; SET total_rows = (SELECT COUNT(*) FROM party_relation_type); SET limit = COALESCE($limit, 50); SET offset = COALESCE($offset, 0); SET total_pages = ($total_rows + $limit - 1) / $limit; SET current_page = ($offset / $limit) + 1; SELECT 'text' AS component, '[party_relation_type (table) Schema](console/info-schema/table.sql?name=party_relation_type&stats=yes)' AS contents_md SELECT 'text' AS component, '- Start Row: ' || $offset || ' ' || '- Rows per Page: ' || $limit || ' ' || '- Total Rows: ' || $total_rows || ' ' || '- Current Page: ' || $current_page || ' ' || '- Total Pages: ' || $total_pages as contents_md WHERE $stats IS NOT NULL; -- Display uniform_resource table with pagination SELECT 'table' AS component, TRUE AS sort, TRUE AS search, TRUE AS hover, TRUE AS striped_rows, TRUE AS small; SELECT * FROM party_relation_type LIMIT $limit OFFSET $offset; SELECT 'text' AS component, (SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE '' END) || ' ' || '(Page ' || $current_page || ' of ' || $total_pages || ') ' || (SELECT CASE WHEN $current_page < $total_pages THEN '[Next](?limit=' || $limit || '&offset=' || ($offset + $limit) || ')' ELSE '' END) AS contents_md; | 2024-12-24 11:04:36 |
| console/content/table/party_relation.auto.sql | SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties; SELECT 'breadcrumb' AS component; SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link; SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link; SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link; SELECT 'party_relation table' as title, '#' AS link; SELECT 'title' AS component, 'party_relation (table) Content' as contents; SET total_rows = (SELECT COUNT(*) FROM party_relation); SET limit = COALESCE($limit, 50); SET offset = COALESCE($offset, 0); SET total_pages = ($total_rows + $limit - 1) / $limit; SET current_page = ($offset / $limit) + 1; SELECT 'text' AS component, '[party_relation (table) Schema](console/info-schema/table.sql?name=party_relation&stats=yes)' AS contents_md SELECT 'text' AS component, '- Start Row: ' || $offset || ' ' || '- Rows per Page: ' || $limit || ' ' || '- Total Rows: ' || $total_rows || ' ' || '- Current Page: ' || $current_page || ' ' || '- Total Pages: ' || $total_pages as contents_md WHERE $stats IS NOT NULL; -- Display uniform_resource table with pagination SELECT 'table' AS component, TRUE AS sort, TRUE AS search, TRUE AS hover, TRUE AS striped_rows, TRUE AS small; SELECT * FROM party_relation LIMIT $limit OFFSET $offset; SELECT 'text' AS component, (SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE '' END) || ' ' || '(Page ' || $current_page || ' of ' || $total_pages || ') ' || (SELECT CASE WHEN $current_page < $total_pages THEN '[Next](?limit=' || $limit || '&offset=' || ($offset + $limit) || ')' ELSE '' END) AS contents_md; | 2024-12-24 11:04:36 |
| console/content/table/gender_type.auto.sql | SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties; SELECT 'breadcrumb' AS component; SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link; SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link; SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link; SELECT 'gender_type table' as title, '#' AS link; SELECT 'title' AS component, 'gender_type (table) Content' as contents; SET total_rows = (SELECT COUNT(*) FROM gender_type); SET limit = COALESCE($limit, 50); SET offset = COALESCE($offset, 0); SET total_pages = ($total_rows + $limit - 1) / $limit; SET current_page = ($offset / $limit) + 1; SELECT 'text' AS component, '[gender_type (table) Schema](console/info-schema/table.sql?name=gender_type&stats=yes)' AS contents_md SELECT 'text' AS component, '- Start Row: ' || $offset || ' ' || '- Rows per Page: ' || $limit || ' ' || '- Total Rows: ' || $total_rows || ' ' || '- Current Page: ' || $current_page || ' ' || '- Total Pages: ' || $total_pages as contents_md WHERE $stats IS NOT NULL; -- Display uniform_resource table with pagination SELECT 'table' AS component, TRUE AS sort, TRUE AS search, TRUE AS hover, TRUE AS striped_rows, TRUE AS small; SELECT * FROM gender_type LIMIT $limit OFFSET $offset; SELECT 'text' AS component, (SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE '' END) || ' ' || '(Page ' || $current_page || ' of ' || $total_pages || ') ' || (SELECT CASE WHEN $current_page < $total_pages THEN '[Next](?limit=' || $limit || '&offset=' || ($offset + $limit) || ')' ELSE '' END) AS contents_md; | 2024-12-24 11:04:36 |
| console/content/table/sex_type.auto.sql | SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties; SELECT 'breadcrumb' AS component; SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link; SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link; SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link; SELECT 'sex_type table' as title, '#' AS link; SELECT 'title' AS component, 'sex_type (table) Content' as contents; SET total_rows = (SELECT COUNT(*) FROM sex_type); SET limit = COALESCE($limit, 50); SET offset = COALESCE($offset, 0); SET total_pages = ($total_rows + $limit - 1) / $limit; SET current_page = ($offset / $limit) + 1; SELECT 'text' AS component, '[sex_type (table) Schema](console/info-schema/table.sql?name=sex_type&stats=yes)' AS contents_md SELECT 'text' AS component, '- Start Row: ' || $offset || ' ' || '- Rows per Page: ' || $limit || ' ' || '- Total Rows: ' || $total_rows || ' ' || '- Current Page: ' || $current_page || ' ' || '- Total Pages: ' || $total_pages as contents_md WHERE $stats IS NOT NULL; -- Display uniform_resource table with pagination SELECT 'table' AS component, TRUE AS sort, TRUE AS search, TRUE AS hover, TRUE AS striped_rows, TRUE AS small; SELECT * FROM sex_type LIMIT $limit OFFSET $offset; SELECT 'text' AS component, (SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE '' END) || ' ' || '(Page ' || $current_page || ' of ' || $total_pages || ') ' || (SELECT CASE WHEN $current_page < $total_pages THEN '[Next](?limit=' || $limit || '&offset=' || ($offset + $limit) || ')' ELSE '' END) AS contents_md; | 2024-12-24 11:04:36 |
| console/content/table/person_type.auto.sql | SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties; SELECT 'breadcrumb' AS component; SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link; SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link; SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link; SELECT 'person_type table' as title, '#' AS link; SELECT 'title' AS component, 'person_type (table) Content' as contents; SET total_rows = (SELECT COUNT(*) FROM person_type); SET limit = COALESCE($limit, 50); SET offset = COALESCE($offset, 0); SET total_pages = ($total_rows + $limit - 1) / $limit; SET current_page = ($offset / $limit) + 1; SELECT 'text' AS component, '[person_type (table) Schema](console/info-schema/table.sql?name=person_type&stats=yes)' AS contents_md SELECT 'text' AS component, '- Start Row: ' || $offset || ' ' || '- Rows per Page: ' || $limit || ' ' || '- Total Rows: ' || $total_rows || ' ' || '- Current Page: ' || $current_page || ' ' || '- Total Pages: ' || $total_pages as contents_md WHERE $stats IS NOT NULL; -- Display uniform_resource table with pagination SELECT 'table' AS component, TRUE AS sort, TRUE AS search, TRUE AS hover, TRUE AS striped_rows, TRUE AS small; SELECT * FROM person_type LIMIT $limit OFFSET $offset; SELECT 'text' AS component, (SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE '' END) || ' ' || '(Page ' || $current_page || ' of ' || $total_pages || ') ' || (SELECT CASE WHEN $current_page < $total_pages THEN '[Next](?limit=' || $limit || '&offset=' || ($offset + $limit) || ')' ELSE '' END) AS contents_md; | 2024-12-24 11:04:36 |
| console/content/table/person.auto.sql | SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties; SELECT 'breadcrumb' AS component; SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link; SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link; SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link; SELECT 'person table' as title, '#' AS link; SELECT 'title' AS component, 'person (table) Content' as contents; SET total_rows = (SELECT COUNT(*) FROM person); SET limit = COALESCE($limit, 50); SET offset = COALESCE($offset, 0); SET total_pages = ($total_rows + $limit - 1) / $limit; SET current_page = ($offset / $limit) + 1; SELECT 'text' AS component, '[person (table) Schema](console/info-schema/table.sql?name=person&stats=yes)' AS contents_md SELECT 'text' AS component, '- Start Row: ' || $offset || ' ' || '- Rows per Page: ' || $limit || ' ' || '- Total Rows: ' || $total_rows || ' ' || '- Current Page: ' || $current_page || ' ' || '- Total Pages: ' || $total_pages as contents_md WHERE $stats IS NOT NULL; -- Display uniform_resource table with pagination SELECT 'table' AS component, TRUE AS sort, TRUE AS search, TRUE AS hover, TRUE AS striped_rows, TRUE AS small; SELECT * FROM person LIMIT $limit OFFSET $offset; SELECT 'text' AS component, (SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE '' END) || ' ' || '(Page ' || $current_page || ' of ' || $total_pages || ') ' || (SELECT CASE WHEN $current_page < $total_pages THEN '[Next](?limit=' || $limit || '&offset=' || ($offset + $limit) || ')' ELSE '' END) AS contents_md; | 2024-12-24 11:04:36 |
| console/content/table/organization.auto.sql | SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties; SELECT 'breadcrumb' AS component; SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link; SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link; SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link; SELECT 'organization table' as title, '#' AS link; SELECT 'title' AS component, 'organization (table) Content' as contents; SET total_rows = (SELECT COUNT(*) FROM organization); SET limit = COALESCE($limit, 50); SET offset = COALESCE($offset, 0); SET total_pages = ($total_rows + $limit - 1) / $limit; SET current_page = ($offset / $limit) + 1; SELECT 'text' AS component, '[organization (table) Schema](console/info-schema/table.sql?name=organization&stats=yes)' AS contents_md SELECT 'text' AS component, '- Start Row: ' || $offset || ' ' || '- Rows per Page: ' || $limit || ' ' || '- Total Rows: ' || $total_rows || ' ' || '- Current Page: ' || $current_page || ' ' || '- Total Pages: ' || $total_pages as contents_md WHERE $stats IS NOT NULL; -- Display uniform_resource table with pagination SELECT 'table' AS component, TRUE AS sort, TRUE AS search, TRUE AS hover, TRUE AS striped_rows, TRUE AS small; SELECT * FROM organization LIMIT $limit OFFSET $offset; SELECT 'text' AS component, (SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE '' END) || ' ' || '(Page ' || $current_page || ' of ' || $total_pages || ') ' || (SELECT CASE WHEN $current_page < $total_pages THEN '[Next](?limit=' || $limit || '&offset=' || ($offset + $limit) || ')' ELSE '' END) AS contents_md; | 2024-12-24 11:04:36 |
| console/content/table/organization_role_type.auto.sql | SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties; SELECT 'breadcrumb' AS component; SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link; SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link; SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link; SELECT 'organization_role_type table' as title, '#' AS link; SELECT 'title' AS component, 'organization_role_type (table) Content' as contents; SET total_rows = (SELECT COUNT(*) FROM organization_role_type); SET limit = COALESCE($limit, 50); SET offset = COALESCE($offset, 0); SET total_pages = ($total_rows + $limit - 1) / $limit; SET current_page = ($offset / $limit) + 1; SELECT 'text' AS component, '[organization_role_type (table) Schema](console/info-schema/table.sql?name=organization_role_type&stats=yes)' AS contents_md SELECT 'text' AS component, '- Start Row: ' || $offset || ' ' || '- Rows per Page: ' || $limit || ' ' || '- Total Rows: ' || $total_rows || ' ' || '- Current Page: ' || $current_page || ' ' || '- Total Pages: ' || $total_pages as contents_md WHERE $stats IS NOT NULL; -- Display uniform_resource table with pagination SELECT 'table' AS component, TRUE AS sort, TRUE AS search, TRUE AS hover, TRUE AS striped_rows, TRUE AS small; SELECT * FROM organization_role_type LIMIT $limit OFFSET $offset; SELECT 'text' AS component, (SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE '' END) || ' ' || '(Page ' || $current_page || ' of ' || $total_pages || ') ' || (SELECT CASE WHEN $current_page < $total_pages THEN '[Next](?limit=' || $limit || '&offset=' || ($offset + $limit) || ')' ELSE '' END) AS contents_md; | 2024-12-24 11:04:36 |
| console/content/table/organization_role.auto.sql | SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties; SELECT 'breadcrumb' AS component; SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link; SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link; SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link; SELECT 'organization_role table' as title, '#' AS link; SELECT 'title' AS component, 'organization_role (table) Content' as contents; SET total_rows = (SELECT COUNT(*) FROM organization_role); SET limit = COALESCE($limit, 50); SET offset = COALESCE($offset, 0); SET total_pages = ($total_rows + $limit - 1) / $limit; SET current_page = ($offset / $limit) + 1; SELECT 'text' AS component, '[organization_role (table) Schema](console/info-schema/table.sql?name=organization_role&stats=yes)' AS contents_md SELECT 'text' AS component, '- Start Row: ' || $offset || ' ' || '- Rows per Page: ' || $limit || ' ' || '- Total Rows: ' || $total_rows || ' ' || '- Current Page: ' || $current_page || ' ' || '- Total Pages: ' || $total_pages as contents_md WHERE $stats IS NOT NULL; -- Display uniform_resource table with pagination SELECT 'table' AS component, TRUE AS sort, TRUE AS search, TRUE AS hover, TRUE AS striped_rows, TRUE AS small; SELECT * FROM organization_role LIMIT $limit OFFSET $offset; SELECT 'text' AS component, (SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE '' END) || ' ' || '(Page ' || $current_page || ' of ' || $total_pages || ') ' || (SELECT CASE WHEN $current_page < $total_pages THEN '[Next](?limit=' || $limit || '&offset=' || ($offset + $limit) || ')' ELSE '' END) AS contents_md; | 2024-12-24 11:04:36 |
| console/content/table/device.auto.sql | SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties; SELECT 'breadcrumb' AS component; SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link; SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link; SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link; SELECT 'device table' as title, '#' AS link; SELECT 'title' AS component, 'device (table) Content' as contents; SET total_rows = (SELECT COUNT(*) FROM device); SET limit = COALESCE($limit, 50); SET offset = COALESCE($offset, 0); SET total_pages = ($total_rows + $limit - 1) / $limit; SET current_page = ($offset / $limit) + 1; SELECT 'text' AS component, '[device (table) Schema](console/info-schema/table.sql?name=device&stats=yes)' AS contents_md SELECT 'text' AS component, '- Start Row: ' || $offset || ' ' || '- Rows per Page: ' || $limit || ' ' || '- Total Rows: ' || $total_rows || ' ' || '- Current Page: ' || $current_page || ' ' || '- Total Pages: ' || $total_pages as contents_md WHERE $stats IS NOT NULL; -- Display uniform_resource table with pagination SELECT 'table' AS component, TRUE AS sort, TRUE AS search, TRUE AS hover, TRUE AS striped_rows, TRUE AS small; SELECT * FROM device LIMIT $limit OFFSET $offset; SELECT 'text' AS component, (SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE '' END) || ' ' || '(Page ' || $current_page || ' of ' || $total_pages || ') ' || (SELECT CASE WHEN $current_page < $total_pages THEN '[Next](?limit=' || $limit || '&offset=' || ($offset + $limit) || ')' ELSE '' END) AS contents_md; | 2024-12-24 11:04:36 |
| console/content/table/device_party_relationship.auto.sql | SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties; SELECT 'breadcrumb' AS component; SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link; SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link; SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link; SELECT 'device_party_relationship table' as title, '#' AS link; SELECT 'title' AS component, 'device_party_relationship (table) Content' as contents; SET total_rows = (SELECT COUNT(*) FROM device_party_relationship); SET limit = COALESCE($limit, 50); SET offset = COALESCE($offset, 0); SET total_pages = ($total_rows + $limit - 1) / $limit; SET current_page = ($offset / $limit) + 1; SELECT 'text' AS component, '[device_party_relationship (table) Schema](console/info-schema/table.sql?name=device_party_relationship&stats=yes)' AS contents_md SELECT 'text' AS component, '- Start Row: ' || $offset || ' ' || '- Rows per Page: ' || $limit || ' ' || '- Total Rows: ' || $total_rows || ' ' || '- Current Page: ' || $current_page || ' ' || '- Total Pages: ' || $total_pages as contents_md WHERE $stats IS NOT NULL; -- Display uniform_resource table with pagination SELECT 'table' AS component, TRUE AS sort, TRUE AS search, TRUE AS hover, TRUE AS striped_rows, TRUE AS small; SELECT * FROM device_party_relationship LIMIT $limit OFFSET $offset; SELECT 'text' AS component, (SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE '' END) || ' ' || '(Page ' || $current_page || ' of ' || $total_pages || ') ' || (SELECT CASE WHEN $current_page < $total_pages THEN '[Next](?limit=' || $limit || '&offset=' || ($offset + $limit) || ')' ELSE '' END) AS contents_md; | 2024-12-24 11:04:36 |
| console/content/table/behavior.auto.sql | SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties; SELECT 'breadcrumb' AS component; SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link; SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link; SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link; SELECT 'behavior table' as title, '#' AS link; SELECT 'title' AS component, 'behavior (table) Content' as contents; SET total_rows = (SELECT COUNT(*) FROM behavior); SET limit = COALESCE($limit, 50); SET offset = COALESCE($offset, 0); SET total_pages = ($total_rows + $limit - 1) / $limit; SET current_page = ($offset / $limit) + 1; SELECT 'text' AS component, '[behavior (table) Schema](console/info-schema/table.sql?name=behavior&stats=yes)' AS contents_md SELECT 'text' AS component, '- Start Row: ' || $offset || ' ' || '- Rows per Page: ' || $limit || ' ' || '- Total Rows: ' || $total_rows || ' ' || '- Current Page: ' || $current_page || ' ' || '- Total Pages: ' || $total_pages as contents_md WHERE $stats IS NOT NULL; -- Display uniform_resource table with pagination SELECT 'table' AS component, TRUE AS sort, TRUE AS search, TRUE AS hover, TRUE AS striped_rows, TRUE AS small; SELECT * FROM behavior LIMIT $limit OFFSET $offset; SELECT 'text' AS component, (SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE '' END) || ' ' || '(Page ' || $current_page || ' of ' || $total_pages || ') ' || (SELECT CASE WHEN $current_page < $total_pages THEN '[Next](?limit=' || $limit || '&offset=' || ($offset + $limit) || ')' ELSE '' END) AS contents_md; | 2024-12-24 11:04:36 |
| console/content/table/ur_ingest_resource_path_match_rule.auto.sql | SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties; SELECT 'breadcrumb' AS component; SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link; SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link; SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link; SELECT 'ur_ingest_resource_path_match_rule table' as title, '#' AS link; SELECT 'title' AS component, 'ur_ingest_resource_path_match_rule (table) Content' as contents; SET total_rows = (SELECT COUNT(*) FROM ur_ingest_resource_path_match_rule); SET limit = COALESCE($limit, 50); SET offset = COALESCE($offset, 0); SET total_pages = ($total_rows + $limit - 1) / $limit; SET current_page = ($offset / $limit) + 1; SELECT 'text' AS component, '[ur_ingest_resource_path_match_rule (table) Schema](console/info-schema/table.sql?name=ur_ingest_resource_path_match_rule&stats=yes)' AS contents_md SELECT 'text' AS component, '- Start Row: ' || $offset || ' ' || '- Rows per Page: ' || $limit || ' ' || '- Total Rows: ' || $total_rows || ' ' || '- Current Page: ' || $current_page || ' ' || '- Total Pages: ' || $total_pages as contents_md WHERE $stats IS NOT NULL; -- Display uniform_resource table with pagination SELECT 'table' AS component, TRUE AS sort, TRUE AS search, TRUE AS hover, TRUE AS striped_rows, TRUE AS small; SELECT * FROM ur_ingest_resource_path_match_rule LIMIT $limit OFFSET $offset; SELECT 'text' AS component, (SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE '' END) || ' ' || '(Page ' || $current_page || ' of ' || $total_pages || ') ' || (SELECT CASE WHEN $current_page < $total_pages THEN '[Next](?limit=' || $limit || '&offset=' || ($offset + $limit) || ')' ELSE '' END) AS contents_md; | 2024-12-24 11:04:36 |
| console/content/table/ur_ingest_resource_path_rewrite_rule.auto.sql | SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties; SELECT 'breadcrumb' AS component; SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link; SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link; SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link; SELECT 'ur_ingest_resource_path_rewrite_rule table' as title, '#' AS link; SELECT 'title' AS component, 'ur_ingest_resource_path_rewrite_rule (table) Content' as contents; SET total_rows = (SELECT COUNT(*) FROM ur_ingest_resource_path_rewrite_rule); SET limit = COALESCE($limit, 50); SET offset = COALESCE($offset, 0); SET total_pages = ($total_rows + $limit - 1) / $limit; SET current_page = ($offset / $limit) + 1; SELECT 'text' AS component, '[ur_ingest_resource_path_rewrite_rule (table) Schema](console/info-schema/table.sql?name=ur_ingest_resource_path_rewrite_rule&stats=yes)' AS contents_md SELECT 'text' AS component, '- Start Row: ' || $offset || ' ' || '- Rows per Page: ' || $limit || ' ' || '- Total Rows: ' || $total_rows || ' ' || '- Current Page: ' || $current_page || ' ' || '- Total Pages: ' || $total_pages as contents_md WHERE $stats IS NOT NULL; -- Display uniform_resource table with pagination SELECT 'table' AS component, TRUE AS sort, TRUE AS search, TRUE AS hover, TRUE AS striped_rows, TRUE AS small; SELECT * FROM ur_ingest_resource_path_rewrite_rule LIMIT $limit OFFSET $offset; SELECT 'text' AS component, (SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE '' END) || ' ' || '(Page ' || $current_page || ' of ' || $total_pages || ') ' || (SELECT CASE WHEN $current_page < $total_pages THEN '[Next](?limit=' || $limit || '&offset=' || ($offset + $limit) || ')' ELSE '' END) AS contents_md; | 2024-12-24 11:04:36 |
| console/content/table/ur_ingest_session.auto.sql | SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties; SELECT 'breadcrumb' AS component; SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link; SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link; SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link; SELECT 'ur_ingest_session table' as title, '#' AS link; SELECT 'title' AS component, 'ur_ingest_session (table) Content' as contents; SET total_rows = (SELECT COUNT(*) FROM ur_ingest_session); SET limit = COALESCE($limit, 50); SET offset = COALESCE($offset, 0); SET total_pages = ($total_rows + $limit - 1) / $limit; SET current_page = ($offset / $limit) + 1; SELECT 'text' AS component, '[ur_ingest_session (table) Schema](console/info-schema/table.sql?name=ur_ingest_session&stats=yes)' AS contents_md SELECT 'text' AS component, '- Start Row: ' || $offset || ' ' || '- Rows per Page: ' || $limit || ' ' || '- Total Rows: ' || $total_rows || ' ' || '- Current Page: ' || $current_page || ' ' || '- Total Pages: ' || $total_pages as contents_md WHERE $stats IS NOT NULL; -- Display uniform_resource table with pagination SELECT 'table' AS component, TRUE AS sort, TRUE AS search, TRUE AS hover, TRUE AS striped_rows, TRUE AS small; SELECT * FROM ur_ingest_session LIMIT $limit OFFSET $offset; SELECT 'text' AS component, (SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE '' END) || ' ' || '(Page ' || $current_page || ' of ' || $total_pages || ') ' || (SELECT CASE WHEN $current_page < $total_pages THEN '[Next](?limit=' || $limit || '&offset=' || ($offset + $limit) || ')' ELSE '' END) AS contents_md; | 2024-12-24 11:04:36 |
| console/content/table/ur_ingest_session_fs_path.auto.sql | SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties; SELECT 'breadcrumb' AS component; SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link; SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link; SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link; SELECT 'ur_ingest_session_fs_path table' as title, '#' AS link; SELECT 'title' AS component, 'ur_ingest_session_fs_path (table) Content' as contents; SET total_rows = (SELECT COUNT(*) FROM ur_ingest_session_fs_path); SET limit = COALESCE($limit, 50); SET offset = COALESCE($offset, 0); SET total_pages = ($total_rows + $limit - 1) / $limit; SET current_page = ($offset / $limit) + 1; SELECT 'text' AS component, '[ur_ingest_session_fs_path (table) Schema](console/info-schema/table.sql?name=ur_ingest_session_fs_path&stats=yes)' AS contents_md SELECT 'text' AS component, '- Start Row: ' || $offset || ' ' || '- Rows per Page: ' || $limit || ' ' || '- Total Rows: ' || $total_rows || ' ' || '- Current Page: ' || $current_page || ' ' || '- Total Pages: ' || $total_pages as contents_md WHERE $stats IS NOT NULL; -- Display uniform_resource table with pagination SELECT 'table' AS component, TRUE AS sort, TRUE AS search, TRUE AS hover, TRUE AS striped_rows, TRUE AS small; SELECT * FROM ur_ingest_session_fs_path LIMIT $limit OFFSET $offset; SELECT 'text' AS component, (SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE '' END) || ' ' || '(Page ' || $current_page || ' of ' || $total_pages || ') ' || (SELECT CASE WHEN $current_page < $total_pages THEN '[Next](?limit=' || $limit || '&offset=' || ($offset + $limit) || ')' ELSE '' END) AS contents_md; | 2024-12-24 11:04:36 |
| console/content/table/uniform_resource.auto.sql | SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties; SELECT 'breadcrumb' AS component; SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link; SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link; SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link; SELECT 'uniform_resource table' as title, '#' AS link; SELECT 'title' AS component, 'uniform_resource (table) Content' as contents; SET total_rows = (SELECT COUNT(*) FROM uniform_resource); SET limit = COALESCE($limit, 50); SET offset = COALESCE($offset, 0); SET total_pages = ($total_rows + $limit - 1) / $limit; SET current_page = ($offset / $limit) + 1; SELECT 'text' AS component, '[uniform_resource (table) Schema](console/info-schema/table.sql?name=uniform_resource&stats=yes)' AS contents_md SELECT 'text' AS component, '- Start Row: ' || $offset || ' ' || '- Rows per Page: ' || $limit || ' ' || '- Total Rows: ' || $total_rows || ' ' || '- Current Page: ' || $current_page || ' ' || '- Total Pages: ' || $total_pages as contents_md WHERE $stats IS NOT NULL; -- Display uniform_resource table with pagination SELECT 'table' AS component, TRUE AS sort, TRUE AS search, TRUE AS hover, TRUE AS striped_rows, TRUE AS small; SELECT * FROM uniform_resource LIMIT $limit OFFSET $offset; SELECT 'text' AS component, (SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE '' END) || ' ' || '(Page ' || $current_page || ' of ' || $total_pages || ') ' || (SELECT CASE WHEN $current_page < $total_pages THEN '[Next](?limit=' || $limit || '&offset=' || ($offset + $limit) || ')' ELSE '' END) AS contents_md; | 2024-12-24 11:04:36 |
| console/content/table/uniform_resource_transform.auto.sql | SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties; SELECT 'breadcrumb' AS component; SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link; SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link; SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link; SELECT 'uniform_resource_transform table' as title, '#' AS link; SELECT 'title' AS component, 'uniform_resource_transform (table) Content' as contents; SET total_rows = (SELECT COUNT(*) FROM uniform_resource_transform); SET limit = COALESCE($limit, 50); SET offset = COALESCE($offset, 0); SET total_pages = ($total_rows + $limit - 1) / $limit; SET current_page = ($offset / $limit) + 1; SELECT 'text' AS component, '[uniform_resource_transform (table) Schema](console/info-schema/table.sql?name=uniform_resource_transform&stats=yes)' AS contents_md SELECT 'text' AS component, '- Start Row: ' || $offset || ' ' || '- Rows per Page: ' || $limit || ' ' || '- Total Rows: ' || $total_rows || ' ' || '- Current Page: ' || $current_page || ' ' || '- Total Pages: ' || $total_pages as contents_md WHERE $stats IS NOT NULL; -- Display uniform_resource table with pagination SELECT 'table' AS component, TRUE AS sort, TRUE AS search, TRUE AS hover, TRUE AS striped_rows, TRUE AS small; SELECT * FROM uniform_resource_transform LIMIT $limit OFFSET $offset; SELECT 'text' AS component, (SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE '' END) || ' ' || '(Page ' || $current_page || ' of ' || $total_pages || ') ' || (SELECT CASE WHEN $current_page < $total_pages THEN '[Next](?limit=' || $limit || '&offset=' || ($offset + $limit) || ')' ELSE '' END) AS contents_md; | 2024-12-24 11:04:36 |
| console/content/table/ur_ingest_session_fs_path_entry.auto.sql | SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties; SELECT 'breadcrumb' AS component; SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link; SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link; SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link; SELECT 'ur_ingest_session_fs_path_entry table' as title, '#' AS link; SELECT 'title' AS component, 'ur_ingest_session_fs_path_entry (table) Content' as contents; SET total_rows = (SELECT COUNT(*) FROM ur_ingest_session_fs_path_entry); SET limit = COALESCE($limit, 50); SET offset = COALESCE($offset, 0); SET total_pages = ($total_rows + $limit - 1) / $limit; SET current_page = ($offset / $limit) + 1; SELECT 'text' AS component, '[ur_ingest_session_fs_path_entry (table) Schema](console/info-schema/table.sql?name=ur_ingest_session_fs_path_entry&stats=yes)' AS contents_md SELECT 'text' AS component, '- Start Row: ' || $offset || ' ' || '- Rows per Page: ' || $limit || ' ' || '- Total Rows: ' || $total_rows || ' ' || '- Current Page: ' || $current_page || ' ' || '- Total Pages: ' || $total_pages as contents_md WHERE $stats IS NOT NULL; -- Display uniform_resource table with pagination SELECT 'table' AS component, TRUE AS sort, TRUE AS search, TRUE AS hover, TRUE AS striped_rows, TRUE AS small; SELECT * FROM ur_ingest_session_fs_path_entry LIMIT $limit OFFSET $offset; SELECT 'text' AS component, (SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE '' END) || ' ' || '(Page ' || $current_page || ' of ' || $total_pages || ') ' || (SELECT CASE WHEN $current_page < $total_pages THEN '[Next](?limit=' || $limit || '&offset=' || ($offset + $limit) || ')' ELSE '' END) AS contents_md; | 2024-12-24 11:04:36 |
| console/content/table/ur_ingest_session_task.auto.sql | SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties; SELECT 'breadcrumb' AS component; SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link; SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link; SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link; SELECT 'ur_ingest_session_task table' as title, '#' AS link; SELECT 'title' AS component, 'ur_ingest_session_task (table) Content' as contents; SET total_rows = (SELECT COUNT(*) FROM ur_ingest_session_task); SET limit = COALESCE($limit, 50); SET offset = COALESCE($offset, 0); SET total_pages = ($total_rows + $limit - 1) / $limit; SET current_page = ($offset / $limit) + 1; SELECT 'text' AS component, '[ur_ingest_session_task (table) Schema](console/info-schema/table.sql?name=ur_ingest_session_task&stats=yes)' AS contents_md SELECT 'text' AS component, '- Start Row: ' || $offset || ' ' || '- Rows per Page: ' || $limit || ' ' || '- Total Rows: ' || $total_rows || ' ' || '- Current Page: ' || $current_page || ' ' || '- Total Pages: ' || $total_pages as contents_md WHERE $stats IS NOT NULL; -- Display uniform_resource table with pagination SELECT 'table' AS component, TRUE AS sort, TRUE AS search, TRUE AS hover, TRUE AS striped_rows, TRUE AS small; SELECT * FROM ur_ingest_session_task LIMIT $limit OFFSET $offset; SELECT 'text' AS component, (SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE '' END) || ' ' || '(Page ' || $current_page || ' of ' || $total_pages || ') ' || (SELECT CASE WHEN $current_page < $total_pages THEN '[Next](?limit=' || $limit || '&offset=' || ($offset + $limit) || ')' ELSE '' END) AS contents_md; | 2024-12-24 11:04:36 |
| console/content/table/ur_ingest_session_imap_account.auto.sql | SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties; SELECT 'breadcrumb' AS component; SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link; SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link; SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link; SELECT 'ur_ingest_session_imap_account table' as title, '#' AS link; SELECT 'title' AS component, 'ur_ingest_session_imap_account (table) Content' as contents; SET total_rows = (SELECT COUNT(*) FROM ur_ingest_session_imap_account); SET limit = COALESCE($limit, 50); SET offset = COALESCE($offset, 0); SET total_pages = ($total_rows + $limit - 1) / $limit; SET current_page = ($offset / $limit) + 1; SELECT 'text' AS component, '[ur_ingest_session_imap_account (table) Schema](console/info-schema/table.sql?name=ur_ingest_session_imap_account&stats=yes)' AS contents_md SELECT 'text' AS component, '- Start Row: ' || $offset || ' ' || '- Rows per Page: ' || $limit || ' ' || '- Total Rows: ' || $total_rows || ' ' || '- Current Page: ' || $current_page || ' ' || '- Total Pages: ' || $total_pages as contents_md WHERE $stats IS NOT NULL; -- Display uniform_resource table with pagination SELECT 'table' AS component, TRUE AS sort, TRUE AS search, TRUE AS hover, TRUE AS striped_rows, TRUE AS small; SELECT * FROM ur_ingest_session_imap_account LIMIT $limit OFFSET $offset; SELECT 'text' AS component, (SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE '' END) || ' ' || '(Page ' || $current_page || ' of ' || $total_pages || ') ' || (SELECT CASE WHEN $current_page < $total_pages THEN '[Next](?limit=' || $limit || '&offset=' || ($offset + $limit) || ')' ELSE '' END) AS contents_md; | 2024-12-24 11:04:36 |
| console/content/table/ur_ingest_session_imap_acct_folder.auto.sql | SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties; SELECT 'breadcrumb' AS component; SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link; SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link; SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link; SELECT 'ur_ingest_session_imap_acct_folder table' as title, '#' AS link; SELECT 'title' AS component, 'ur_ingest_session_imap_acct_folder (table) Content' as contents; SET total_rows = (SELECT COUNT(*) FROM ur_ingest_session_imap_acct_folder); SET limit = COALESCE($limit, 50); SET offset = COALESCE($offset, 0); SET total_pages = ($total_rows + $limit - 1) / $limit; SET current_page = ($offset / $limit) + 1; SELECT 'text' AS component, '[ur_ingest_session_imap_acct_folder (table) Schema](console/info-schema/table.sql?name=ur_ingest_session_imap_acct_folder&stats=yes)' AS contents_md SELECT 'text' AS component, '- Start Row: ' || $offset || ' ' || '- Rows per Page: ' || $limit || ' ' || '- Total Rows: ' || $total_rows || ' ' || '- Current Page: ' || $current_page || ' ' || '- Total Pages: ' || $total_pages as contents_md WHERE $stats IS NOT NULL; -- Display uniform_resource table with pagination SELECT 'table' AS component, TRUE AS sort, TRUE AS search, TRUE AS hover, TRUE AS striped_rows, TRUE AS small; SELECT * FROM ur_ingest_session_imap_acct_folder LIMIT $limit OFFSET $offset; SELECT 'text' AS component, (SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE '' END) || ' ' || '(Page ' || $current_page || ' of ' || $total_pages || ') ' || (SELECT CASE WHEN $current_page < $total_pages THEN '[Next](?limit=' || $limit || '&offset=' || ($offset + $limit) || ')' ELSE '' END) AS contents_md; | 2024-12-24 11:04:36 |
| console/content/table/ur_ingest_session_imap_acct_folder_message.auto.sql | SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties; SELECT 'breadcrumb' AS component; SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link; SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link; SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link; SELECT 'ur_ingest_session_imap_acct_folder_message table' as title, '#' AS link; SELECT 'title' AS component, 'ur_ingest_session_imap_acct_folder_message (table) Content' as contents; SET total_rows = (SELECT COUNT(*) FROM ur_ingest_session_imap_acct_folder_message); SET limit = COALESCE($limit, 50); SET offset = COALESCE($offset, 0); SET total_pages = ($total_rows + $limit - 1) / $limit; SET current_page = ($offset / $limit) + 1; SELECT 'text' AS component, '[ur_ingest_session_imap_acct_folder_message (table) Schema](console/info-schema/table.sql?name=ur_ingest_session_imap_acct_folder_message&stats=yes)' AS contents_md SELECT 'text' AS component, '- Start Row: ' || $offset || ' ' || '- Rows per Page: ' || $limit || ' ' || '- Total Rows: ' || $total_rows || ' ' || '- Current Page: ' || $current_page || ' ' || '- Total Pages: ' || $total_pages as contents_md WHERE $stats IS NOT NULL; -- Display uniform_resource table with pagination SELECT 'table' AS component, TRUE AS sort, TRUE AS search, TRUE AS hover, TRUE AS striped_rows, TRUE AS small; SELECT * FROM ur_ingest_session_imap_acct_folder_message LIMIT $limit OFFSET $offset; SELECT 'text' AS component, (SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE '' END) || ' ' || '(Page ' || $current_page || ' of ' || $total_pages || ') ' || (SELECT CASE WHEN $current_page < $total_pages THEN '[Next](?limit=' || $limit || '&offset=' || ($offset + $limit) || ')' ELSE '' END) AS contents_md; | 2024-12-24 11:04:36 |
| console/content/table/ur_ingest_session_plm_account.auto.sql | SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties; SELECT 'breadcrumb' AS component; SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link; SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link; SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link; SELECT 'ur_ingest_session_plm_account table' as title, '#' AS link; SELECT 'title' AS component, 'ur_ingest_session_plm_account (table) Content' as contents; SET total_rows = (SELECT COUNT(*) FROM ur_ingest_session_plm_account); SET limit = COALESCE($limit, 50); SET offset = COALESCE($offset, 0); SET total_pages = ($total_rows + $limit - 1) / $limit; SET current_page = ($offset / $limit) + 1; SELECT 'text' AS component, '[ur_ingest_session_plm_account (table) Schema](console/info-schema/table.sql?name=ur_ingest_session_plm_account&stats=yes)' AS contents_md SELECT 'text' AS component, '- Start Row: ' || $offset || ' ' || '- Rows per Page: ' || $limit || ' ' || '- Total Rows: ' || $total_rows || ' ' || '- Current Page: ' || $current_page || ' ' || '- Total Pages: ' || $total_pages as contents_md WHERE $stats IS NOT NULL; -- Display uniform_resource table with pagination SELECT 'table' AS component, TRUE AS sort, TRUE AS search, TRUE AS hover, TRUE AS striped_rows, TRUE AS small; SELECT * FROM ur_ingest_session_plm_account LIMIT $limit OFFSET $offset; SELECT 'text' AS component, (SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE '' END) || ' ' || '(Page ' || $current_page || ' of ' || $total_pages || ') ' || (SELECT CASE WHEN $current_page < $total_pages THEN '[Next](?limit=' || $limit || '&offset=' || ($offset + $limit) || ')' ELSE '' END) AS contents_md; | 2024-12-24 11:04:36 |
| console/content/table/ur_ingest_session_plm_acct_project.auto.sql | SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties; SELECT 'breadcrumb' AS component; SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link; SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link; SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link; SELECT 'ur_ingest_session_plm_acct_project table' as title, '#' AS link; SELECT 'title' AS component, 'ur_ingest_session_plm_acct_project (table) Content' as contents; SET total_rows = (SELECT COUNT(*) FROM ur_ingest_session_plm_acct_project); SET limit = COALESCE($limit, 50); SET offset = COALESCE($offset, 0); SET total_pages = ($total_rows + $limit - 1) / $limit; SET current_page = ($offset / $limit) + 1; SELECT 'text' AS component, '[ur_ingest_session_plm_acct_project (table) Schema](console/info-schema/table.sql?name=ur_ingest_session_plm_acct_project&stats=yes)' AS contents_md SELECT 'text' AS component, '- Start Row: ' || $offset || ' ' || '- Rows per Page: ' || $limit || ' ' || '- Total Rows: ' || $total_rows || ' ' || '- Current Page: ' || $current_page || ' ' || '- Total Pages: ' || $total_pages as contents_md WHERE $stats IS NOT NULL; -- Display uniform_resource table with pagination SELECT 'table' AS component, TRUE AS sort, TRUE AS search, TRUE AS hover, TRUE AS striped_rows, TRUE AS small; SELECT * FROM ur_ingest_session_plm_acct_project LIMIT $limit OFFSET $offset; SELECT 'text' AS component, (SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE '' END) || ' ' || '(Page ' || $current_page || ' of ' || $total_pages || ') ' || (SELECT CASE WHEN $current_page < $total_pages THEN '[Next](?limit=' || $limit || '&offset=' || ($offset + $limit) || ')' ELSE '' END) AS contents_md; | 2024-12-24 11:04:36 |
| console/content/table/ur_ingest_session_plm_acct_project_issue.auto.sql | SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties; SELECT 'breadcrumb' AS component; SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link; SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link; SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link; SELECT 'ur_ingest_session_plm_acct_project_issue table' as title, '#' AS link; SELECT 'title' AS component, 'ur_ingest_session_plm_acct_project_issue (table) Content' as contents; SET total_rows = (SELECT COUNT(*) FROM ur_ingest_session_plm_acct_project_issue); SET limit = COALESCE($limit, 50); SET offset = COALESCE($offset, 0); SET total_pages = ($total_rows + $limit - 1) / $limit; SET current_page = ($offset / $limit) + 1; SELECT 'text' AS component, '[ur_ingest_session_plm_acct_project_issue (table) Schema](console/info-schema/table.sql?name=ur_ingest_session_plm_acct_project_issue&stats=yes)' AS contents_md SELECT 'text' AS component, '- Start Row: ' || $offset || ' ' || '- Rows per Page: ' || $limit || ' ' || '- Total Rows: ' || $total_rows || ' ' || '- Current Page: ' || $current_page || ' ' || '- Total Pages: ' || $total_pages as contents_md WHERE $stats IS NOT NULL; -- Display uniform_resource table with pagination SELECT 'table' AS component, TRUE AS sort, TRUE AS search, TRUE AS hover, TRUE AS striped_rows, TRUE AS small; SELECT * FROM ur_ingest_session_plm_acct_project_issue LIMIT $limit OFFSET $offset; SELECT 'text' AS component, (SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE '' END) || ' ' || '(Page ' || $current_page || ' of ' || $total_pages || ') ' || (SELECT CASE WHEN $current_page < $total_pages THEN '[Next](?limit=' || $limit || '&offset=' || ($offset + $limit) || ')' ELSE '' END) AS contents_md; | 2024-12-24 11:04:36 |
| console/content/table/ur_ingest_session_plm_acct_label.auto.sql | SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties; SELECT 'breadcrumb' AS component; SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link; SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link; SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link; SELECT 'ur_ingest_session_plm_acct_label table' as title, '#' AS link; SELECT 'title' AS component, 'ur_ingest_session_plm_acct_label (table) Content' as contents; SET total_rows = (SELECT COUNT(*) FROM ur_ingest_session_plm_acct_label); SET limit = COALESCE($limit, 50); SET offset = COALESCE($offset, 0); SET total_pages = ($total_rows + $limit - 1) / $limit; SET current_page = ($offset / $limit) + 1; SELECT 'text' AS component, '[ur_ingest_session_plm_acct_label (table) Schema](console/info-schema/table.sql?name=ur_ingest_session_plm_acct_label&stats=yes)' AS contents_md SELECT 'text' AS component, '- Start Row: ' || $offset || ' ' || '- Rows per Page: ' || $limit || ' ' || '- Total Rows: ' || $total_rows || ' ' || '- Current Page: ' || $current_page || ' ' || '- Total Pages: ' || $total_pages as contents_md WHERE $stats IS NOT NULL; -- Display uniform_resource table with pagination SELECT 'table' AS component, TRUE AS sort, TRUE AS search, TRUE AS hover, TRUE AS striped_rows, TRUE AS small; SELECT * FROM ur_ingest_session_plm_acct_label LIMIT $limit OFFSET $offset; SELECT 'text' AS component, (SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE '' END) || ' ' || '(Page ' || $current_page || ' of ' || $total_pages || ') ' || (SELECT CASE WHEN $current_page < $total_pages THEN '[Next](?limit=' || $limit || '&offset=' || ($offset + $limit) || ')' ELSE '' END) AS contents_md; | 2024-12-24 11:04:36 |
| console/content/table/ur_ingest_session_plm_milestone.auto.sql | SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties; SELECT 'breadcrumb' AS component; SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link; SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link; SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link; SELECT 'ur_ingest_session_plm_milestone table' as title, '#' AS link; SELECT 'title' AS component, 'ur_ingest_session_plm_milestone (table) Content' as contents; SET total_rows = (SELECT COUNT(*) FROM ur_ingest_session_plm_milestone); SET limit = COALESCE($limit, 50); SET offset = COALESCE($offset, 0); SET total_pages = ($total_rows + $limit - 1) / $limit; SET current_page = ($offset / $limit) + 1; SELECT 'text' AS component, '[ur_ingest_session_plm_milestone (table) Schema](console/info-schema/table.sql?name=ur_ingest_session_plm_milestone&stats=yes)' AS contents_md SELECT 'text' AS component, '- Start Row: ' || $offset || ' ' || '- Rows per Page: ' || $limit || ' ' || '- Total Rows: ' || $total_rows || ' ' || '- Current Page: ' || $current_page || ' ' || '- Total Pages: ' || $total_pages as contents_md WHERE $stats IS NOT NULL; -- Display uniform_resource table with pagination SELECT 'table' AS component, TRUE AS sort, TRUE AS search, TRUE AS hover, TRUE AS striped_rows, TRUE AS small; SELECT * FROM ur_ingest_session_plm_milestone LIMIT $limit OFFSET $offset; SELECT 'text' AS component, (SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE '' END) || ' ' || '(Page ' || $current_page || ' of ' || $total_pages || ') ' || (SELECT CASE WHEN $current_page < $total_pages THEN '[Next](?limit=' || $limit || '&offset=' || ($offset + $limit) || ')' ELSE '' END) AS contents_md; | 2024-12-24 11:04:36 |
| console/content/table/ur_ingest_session_plm_acct_relationship.auto.sql | SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties; SELECT 'breadcrumb' AS component; SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link; SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link; SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link; SELECT 'ur_ingest_session_plm_acct_relationship table' as title, '#' AS link; SELECT 'title' AS component, 'ur_ingest_session_plm_acct_relationship (table) Content' as contents; SET total_rows = (SELECT COUNT(*) FROM ur_ingest_session_plm_acct_relationship); SET limit = COALESCE($limit, 50); SET offset = COALESCE($offset, 0); SET total_pages = ($total_rows + $limit - 1) / $limit; SET current_page = ($offset / $limit) + 1; SELECT 'text' AS component, '[ur_ingest_session_plm_acct_relationship (table) Schema](console/info-schema/table.sql?name=ur_ingest_session_plm_acct_relationship&stats=yes)' AS contents_md SELECT 'text' AS component, '- Start Row: ' || $offset || ' ' || '- Rows per Page: ' || $limit || ' ' || '- Total Rows: ' || $total_rows || ' ' || '- Current Page: ' || $current_page || ' ' || '- Total Pages: ' || $total_pages as contents_md WHERE $stats IS NOT NULL; -- Display uniform_resource table with pagination SELECT 'table' AS component, TRUE AS sort, TRUE AS search, TRUE AS hover, TRUE AS striped_rows, TRUE AS small; SELECT * FROM ur_ingest_session_plm_acct_relationship LIMIT $limit OFFSET $offset; SELECT 'text' AS component, (SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE '' END) || ' ' || '(Page ' || $current_page || ' of ' || $total_pages || ') ' || (SELECT CASE WHEN $current_page < $total_pages THEN '[Next](?limit=' || $limit || '&offset=' || ($offset + $limit) || ')' ELSE '' END) AS contents_md; | 2024-12-24 11:04:36 |
| console/content/table/ur_ingest_session_plm_user.auto.sql | SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties; SELECT 'breadcrumb' AS component; SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link; SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link; SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link; SELECT 'ur_ingest_session_plm_user table' as title, '#' AS link; SELECT 'title' AS component, 'ur_ingest_session_plm_user (table) Content' as contents; SET total_rows = (SELECT COUNT(*) FROM ur_ingest_session_plm_user); SET limit = COALESCE($limit, 50); SET offset = COALESCE($offset, 0); SET total_pages = ($total_rows + $limit - 1) / $limit; SET current_page = ($offset / $limit) + 1; SELECT 'text' AS component, '[ur_ingest_session_plm_user (table) Schema](console/info-schema/table.sql?name=ur_ingest_session_plm_user&stats=yes)' AS contents_md SELECT 'text' AS component, '- Start Row: ' || $offset || ' ' || '- Rows per Page: ' || $limit || ' ' || '- Total Rows: ' || $total_rows || ' ' || '- Current Page: ' || $current_page || ' ' || '- Total Pages: ' || $total_pages as contents_md WHERE $stats IS NOT NULL; -- Display uniform_resource table with pagination SELECT 'table' AS component, TRUE AS sort, TRUE AS search, TRUE AS hover, TRUE AS striped_rows, TRUE AS small; SELECT * FROM ur_ingest_session_plm_user LIMIT $limit OFFSET $offset; SELECT 'text' AS component, (SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE '' END) || ' ' || '(Page ' || $current_page || ' of ' || $total_pages || ') ' || (SELECT CASE WHEN $current_page < $total_pages THEN '[Next](?limit=' || $limit || '&offset=' || ($offset + $limit) || ')' ELSE '' END) AS contents_md; | 2024-12-24 11:04:36 |
| console/content/table/ur_ingest_session_plm_comment.auto.sql | SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties; SELECT 'breadcrumb' AS component; SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link; SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link; SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link; SELECT 'ur_ingest_session_plm_comment table' as title, '#' AS link; SELECT 'title' AS component, 'ur_ingest_session_plm_comment (table) Content' as contents; SET total_rows = (SELECT COUNT(*) FROM ur_ingest_session_plm_comment); SET limit = COALESCE($limit, 50); SET offset = COALESCE($offset, 0); SET total_pages = ($total_rows + $limit - 1) / $limit; SET current_page = ($offset / $limit) + 1; SELECT 'text' AS component, '[ur_ingest_session_plm_comment (table) Schema](console/info-schema/table.sql?name=ur_ingest_session_plm_comment&stats=yes)' AS contents_md SELECT 'text' AS component, '- Start Row: ' || $offset || ' ' || '- Rows per Page: ' || $limit || ' ' || '- Total Rows: ' || $total_rows || ' ' || '- Current Page: ' || $current_page || ' ' || '- Total Pages: ' || $total_pages as contents_md WHERE $stats IS NOT NULL; -- Display uniform_resource table with pagination SELECT 'table' AS component, TRUE AS sort, TRUE AS search, TRUE AS hover, TRUE AS striped_rows, TRUE AS small; SELECT * FROM ur_ingest_session_plm_comment LIMIT $limit OFFSET $offset; SELECT 'text' AS component, (SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE '' END) || ' ' || '(Page ' || $current_page || ' of ' || $total_pages || ') ' || (SELECT CASE WHEN $current_page < $total_pages THEN '[Next](?limit=' || $limit || '&offset=' || ($offset + $limit) || ')' ELSE '' END) AS contents_md; | 2024-12-24 11:04:36 |
| console/content/table/ur_ingest_session_plm_reaction.auto.sql | SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties; SELECT 'breadcrumb' AS component; SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link; SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link; SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link; SELECT 'ur_ingest_session_plm_reaction table' as title, '#' AS link; SELECT 'title' AS component, 'ur_ingest_session_plm_reaction (table) Content' as contents; SET total_rows = (SELECT COUNT(*) FROM ur_ingest_session_plm_reaction); SET limit = COALESCE($limit, 50); SET offset = COALESCE($offset, 0); SET total_pages = ($total_rows + $limit - 1) / $limit; SET current_page = ($offset / $limit) + 1; SELECT 'text' AS component, '[ur_ingest_session_plm_reaction (table) Schema](console/info-schema/table.sql?name=ur_ingest_session_plm_reaction&stats=yes)' AS contents_md SELECT 'text' AS component, '- Start Row: ' || $offset || ' ' || '- Rows per Page: ' || $limit || ' ' || '- Total Rows: ' || $total_rows || ' ' || '- Current Page: ' || $current_page || ' ' || '- Total Pages: ' || $total_pages as contents_md WHERE $stats IS NOT NULL; -- Display uniform_resource table with pagination SELECT 'table' AS component, TRUE AS sort, TRUE AS search, TRUE AS hover, TRUE AS striped_rows, TRUE AS small; SELECT * FROM ur_ingest_session_plm_reaction LIMIT $limit OFFSET $offset; SELECT 'text' AS component, (SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE '' END) || ' ' || '(Page ' || $current_page || ' of ' || $total_pages || ') ' || (SELECT CASE WHEN $current_page < $total_pages THEN '[Next](?limit=' || $limit || '&offset=' || ($offset + $limit) || ')' ELSE '' END) AS contents_md; | 2024-12-24 11:04:36 |
| console/content/table/ur_ingest_session_plm_issue_reaction.auto.sql | SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties; SELECT 'breadcrumb' AS component; SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link; SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link; SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link; SELECT 'ur_ingest_session_plm_issue_reaction table' as title, '#' AS link; SELECT 'title' AS component, 'ur_ingest_session_plm_issue_reaction (table) Content' as contents; SET total_rows = (SELECT COUNT(*) FROM ur_ingest_session_plm_issue_reaction); SET limit = COALESCE($limit, 50); SET offset = COALESCE($offset, 0); SET total_pages = ($total_rows + $limit - 1) / $limit; SET current_page = ($offset / $limit) + 1; SELECT 'text' AS component, '[ur_ingest_session_plm_issue_reaction (table) Schema](console/info-schema/table.sql?name=ur_ingest_session_plm_issue_reaction&stats=yes)' AS contents_md SELECT 'text' AS component, '- Start Row: ' || $offset || ' ' || '- Rows per Page: ' || $limit || ' ' || '- Total Rows: ' || $total_rows || ' ' || '- Current Page: ' || $current_page || ' ' || '- Total Pages: ' || $total_pages as contents_md WHERE $stats IS NOT NULL; -- Display uniform_resource table with pagination SELECT 'table' AS component, TRUE AS sort, TRUE AS search, TRUE AS hover, TRUE AS striped_rows, TRUE AS small; SELECT * FROM ur_ingest_session_plm_issue_reaction LIMIT $limit OFFSET $offset; SELECT 'text' AS component, (SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE '' END) || ' ' || '(Page ' || $current_page || ' of ' || $total_pages || ') ' || (SELECT CASE WHEN $current_page < $total_pages THEN '[Next](?limit=' || $limit || '&offset=' || ($offset + $limit) || ')' ELSE '' END) AS contents_md; | 2024-12-24 11:04:36 |
| console/content/table/ur_ingest_session_plm_issue_type.auto.sql | SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties; SELECT 'breadcrumb' AS component; SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link; SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link; SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link; SELECT 'ur_ingest_session_plm_issue_type table' as title, '#' AS link; SELECT 'title' AS component, 'ur_ingest_session_plm_issue_type (table) Content' as contents; SET total_rows = (SELECT COUNT(*) FROM ur_ingest_session_plm_issue_type); SET limit = COALESCE($limit, 50); SET offset = COALESCE($offset, 0); SET total_pages = ($total_rows + $limit - 1) / $limit; SET current_page = ($offset / $limit) + 1; SELECT 'text' AS component, '[ur_ingest_session_plm_issue_type (table) Schema](console/info-schema/table.sql?name=ur_ingest_session_plm_issue_type&stats=yes)' AS contents_md SELECT 'text' AS component, '- Start Row: ' || $offset || ' ' || '- Rows per Page: ' || $limit || ' ' || '- Total Rows: ' || $total_rows || ' ' || '- Current Page: ' || $current_page || ' ' || '- Total Pages: ' || $total_pages as contents_md WHERE $stats IS NOT NULL; -- Display uniform_resource table with pagination SELECT 'table' AS component, TRUE AS sort, TRUE AS search, TRUE AS hover, TRUE AS striped_rows, TRUE AS small; SELECT * FROM ur_ingest_session_plm_issue_type LIMIT $limit OFFSET $offset; SELECT 'text' AS component, (SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE '' END) || ' ' || '(Page ' || $current_page || ' of ' || $total_pages || ') ' || (SELECT CASE WHEN $current_page < $total_pages THEN '[Next](?limit=' || $limit || '&offset=' || ($offset + $limit) || ')' ELSE '' END) AS contents_md; | 2024-12-24 11:04:36 |
| console/content/table/ur_ingest_session_attachment.auto.sql | SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties; SELECT 'breadcrumb' AS component; SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link; SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link; SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link; SELECT 'ur_ingest_session_attachment table' as title, '#' AS link; SELECT 'title' AS component, 'ur_ingest_session_attachment (table) Content' as contents; SET total_rows = (SELECT COUNT(*) FROM ur_ingest_session_attachment); SET limit = COALESCE($limit, 50); SET offset = COALESCE($offset, 0); SET total_pages = ($total_rows + $limit - 1) / $limit; SET current_page = ($offset / $limit) + 1; SELECT 'text' AS component, '[ur_ingest_session_attachment (table) Schema](console/info-schema/table.sql?name=ur_ingest_session_attachment&stats=yes)' AS contents_md SELECT 'text' AS component, '- Start Row: ' || $offset || ' ' || '- Rows per Page: ' || $limit || ' ' || '- Total Rows: ' || $total_rows || ' ' || '- Current Page: ' || $current_page || ' ' || '- Total Pages: ' || $total_pages as contents_md WHERE $stats IS NOT NULL; -- Display uniform_resource table with pagination SELECT 'table' AS component, TRUE AS sort, TRUE AS search, TRUE AS hover, TRUE AS striped_rows, TRUE AS small; SELECT * FROM ur_ingest_session_attachment LIMIT $limit OFFSET $offset; SELECT 'text' AS component, (SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE '' END) || ' ' || '(Page ' || $current_page || ' of ' || $total_pages || ') ' || (SELECT CASE WHEN $current_page < $total_pages THEN '[Next](?limit=' || $limit || '&offset=' || ($offset + $limit) || ')' ELSE '' END) AS contents_md; | 2024-12-24 11:04:36 |
| console/content/table/ur_ingest_session_udi_pgp_sql.auto.sql | SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties; SELECT 'breadcrumb' AS component; SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link; SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link; SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link; SELECT 'ur_ingest_session_udi_pgp_sql table' as title, '#' AS link; SELECT 'title' AS component, 'ur_ingest_session_udi_pgp_sql (table) Content' as contents; SET total_rows = (SELECT COUNT(*) FROM ur_ingest_session_udi_pgp_sql); SET limit = COALESCE($limit, 50); SET offset = COALESCE($offset, 0); SET total_pages = ($total_rows + $limit - 1) / $limit; SET current_page = ($offset / $limit) + 1; SELECT 'text' AS component, '[ur_ingest_session_udi_pgp_sql (table) Schema](console/info-schema/table.sql?name=ur_ingest_session_udi_pgp_sql&stats=yes)' AS contents_md SELECT 'text' AS component, '- Start Row: ' || $offset || ' ' || '- Rows per Page: ' || $limit || ' ' || '- Total Rows: ' || $total_rows || ' ' || '- Current Page: ' || $current_page || ' ' || '- Total Pages: ' || $total_pages as contents_md WHERE $stats IS NOT NULL; -- Display uniform_resource table with pagination SELECT 'table' AS component, TRUE AS sort, TRUE AS search, TRUE AS hover, TRUE AS striped_rows, TRUE AS small; SELECT * FROM ur_ingest_session_udi_pgp_sql LIMIT $limit OFFSET $offset; SELECT 'text' AS component, (SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE '' END) || ' ' || '(Page ' || $current_page || ' of ' || $total_pages || ') ' || (SELECT CASE WHEN $current_page < $total_pages THEN '[Next](?limit=' || $limit || '&offset=' || ($offset + $limit) || ')' ELSE '' END) AS contents_md; | 2024-12-24 11:04:36 |
| console/content/table/orchestration_nature.auto.sql | SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties; SELECT 'breadcrumb' AS component; SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link; SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link; SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link; SELECT 'orchestration_nature table' as title, '#' AS link; SELECT 'title' AS component, 'orchestration_nature (table) Content' as contents; SET total_rows = (SELECT COUNT(*) FROM orchestration_nature); SET limit = COALESCE($limit, 50); SET offset = COALESCE($offset, 0); SET total_pages = ($total_rows + $limit - 1) / $limit; SET current_page = ($offset / $limit) + 1; SELECT 'text' AS component, '[orchestration_nature (table) Schema](console/info-schema/table.sql?name=orchestration_nature&stats=yes)' AS contents_md SELECT 'text' AS component, '- Start Row: ' || $offset || ' ' || '- Rows per Page: ' || $limit || ' ' || '- Total Rows: ' || $total_rows || ' ' || '- Current Page: ' || $current_page || ' ' || '- Total Pages: ' || $total_pages as contents_md WHERE $stats IS NOT NULL; -- Display uniform_resource table with pagination SELECT 'table' AS component, TRUE AS sort, TRUE AS search, TRUE AS hover, TRUE AS striped_rows, TRUE AS small; SELECT * FROM orchestration_nature LIMIT $limit OFFSET $offset; SELECT 'text' AS component, (SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE '' END) || ' ' || '(Page ' || $current_page || ' of ' || $total_pages || ') ' || (SELECT CASE WHEN $current_page < $total_pages THEN '[Next](?limit=' || $limit || '&offset=' || ($offset + $limit) || ')' ELSE '' END) AS contents_md; | 2024-12-24 11:04:36 |
| console/content/table/orchestration_session.auto.sql | SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties; SELECT 'breadcrumb' AS component; SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link; SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link; SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link; SELECT 'orchestration_session table' as title, '#' AS link; SELECT 'title' AS component, 'orchestration_session (table) Content' as contents; SET total_rows = (SELECT COUNT(*) FROM orchestration_session); SET limit = COALESCE($limit, 50); SET offset = COALESCE($offset, 0); SET total_pages = ($total_rows + $limit - 1) / $limit; SET current_page = ($offset / $limit) + 1; SELECT 'text' AS component, '[orchestration_session (table) Schema](console/info-schema/table.sql?name=orchestration_session&stats=yes)' AS contents_md SELECT 'text' AS component, '- Start Row: ' || $offset || ' ' || '- Rows per Page: ' || $limit || ' ' || '- Total Rows: ' || $total_rows || ' ' || '- Current Page: ' || $current_page || ' ' || '- Total Pages: ' || $total_pages as contents_md WHERE $stats IS NOT NULL; -- Display uniform_resource table with pagination SELECT 'table' AS component, TRUE AS sort, TRUE AS search, TRUE AS hover, TRUE AS striped_rows, TRUE AS small; SELECT * FROM orchestration_session LIMIT $limit OFFSET $offset; SELECT 'text' AS component, (SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE '' END) || ' ' || '(Page ' || $current_page || ' of ' || $total_pages || ') ' || (SELECT CASE WHEN $current_page < $total_pages THEN '[Next](?limit=' || $limit || '&offset=' || ($offset + $limit) || ')' ELSE '' END) AS contents_md; | 2024-12-24 11:04:36 |
| console/content/table/orchestration_session_entry.auto.sql | SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties; SELECT 'breadcrumb' AS component; SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link; SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link; SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link; SELECT 'orchestration_session_entry table' as title, '#' AS link; SELECT 'title' AS component, 'orchestration_session_entry (table) Content' as contents; SET total_rows = (SELECT COUNT(*) FROM orchestration_session_entry); SET limit = COALESCE($limit, 50); SET offset = COALESCE($offset, 0); SET total_pages = ($total_rows + $limit - 1) / $limit; SET current_page = ($offset / $limit) + 1; SELECT 'text' AS component, '[orchestration_session_entry (table) Schema](console/info-schema/table.sql?name=orchestration_session_entry&stats=yes)' AS contents_md SELECT 'text' AS component, '- Start Row: ' || $offset || ' ' || '- Rows per Page: ' || $limit || ' ' || '- Total Rows: ' || $total_rows || ' ' || '- Current Page: ' || $current_page || ' ' || '- Total Pages: ' || $total_pages as contents_md WHERE $stats IS NOT NULL; -- Display uniform_resource table with pagination SELECT 'table' AS component, TRUE AS sort, TRUE AS search, TRUE AS hover, TRUE AS striped_rows, TRUE AS small; SELECT * FROM orchestration_session_entry LIMIT $limit OFFSET $offset; SELECT 'text' AS component, (SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE '' END) || ' ' || '(Page ' || $current_page || ' of ' || $total_pages || ') ' || (SELECT CASE WHEN $current_page < $total_pages THEN '[Next](?limit=' || $limit || '&offset=' || ($offset + $limit) || ')' ELSE '' END) AS contents_md; | 2024-12-24 11:04:36 |
(Page 1 of 6) Next