console/content/table/sqlpage_files.sql

SELECT 'breadcrumb' AS component;
    SELECT 'Home' as title, '/' as link;
    SELECT 'Console' as title, '/console/index.sql' as link;
    SELECT 'Content' as title;
    SELECT 'sqlpage_files table' as title;

    SELECT 'title' AS component, 'SQLPage Files Content' as contents;
    SELECT 'table' AS component, 1 AS search, 1 AS sort;
    SELECT path AS "Path",
           caption AS "Caption",
           description AS "Description", 
           LEFT(contents, 100) || '...' AS "Content Preview",
           last_modified AS "Modified"
      FROM sqlpage_files
     ORDER BY last_modified DESC;