From 50946acd6d17fb6603e23fe020bce4f8372c78f1 Mon Sep 17 00:00:00 2001 From: Zachary Vance Date: Tue, 4 Aug 2015 19:40:22 -0700 Subject: [PATCH] Format stylish --- db.css | 3 +++ stylish.db | 9 ++++++++- 2 files changed, 11 insertions(+), 1 deletion(-) create mode 100644 db.css diff --git a/db.css b/db.css new file mode 100644 index 0000000..b1ab9a1 --- /dev/null +++ b/db.css @@ -0,0 +1,3 @@ +tr > td[2] { + whitespace: pre; +} diff --git a/stylish.db b/stylish.db index 4acefc8..efa3054 100644 --- a/stylish.db +++ b/stylish.db @@ -1 +1,8 @@ -SELECT style, code, GROUP_CONCAT(section_meta.value) as 'website(s)' FROM (SELECT styles.name AS style,sections.code AS code,sections.id AS sections_id FROM styles INNER JOIN sections ON sections.style_id = styles.id) LEFT JOIN section_meta ON section_meta.section_id = sections_id GROUP BY style; +-- stylish.db +SELECT style, code, GROUP_CONCAT(section_meta.value) as 'website(s)' FROM + (SELECT styles.name AS style, + sections.code AS code,sections.id AS sections_id + FROM styles INNER JOIN sections ON sections.style_id = styles.id) +LEFT JOIN section_meta + ON section_meta.section_id = sections_id +GROUP BY style; -- 2.47.3