X-Git-Url: http://git.shiar.nl/minimedit.git/blobdiff_plain/aee71926fef0a65076c0c40b4c3280506dec5aba..HEAD:/widget/comments.sql diff --git a/widget/comments.sql b/widget/comments.sql index 3a5fcfc..fc261f8 100644 --- a/widget/comments.sql +++ b/widget/comments.sql @@ -2,7 +2,6 @@ CREATE TABLE issues ( page text NOT NULL DEFAULT 'issue', link text, subject text, - body text, created timestamptz DEFAULT now(), closed timestamptz, updated timestamptz NOT NULL DEFAULT now(), @@ -13,7 +12,9 @@ CREATE TABLE issues ( CREATE TABLE comments ( page text, + raw text, message text, + announced boolean NOT NULL DEFAULT TRUE, created timestamptz DEFAULT now(), author text, id serial NOT NULL PRIMARY KEY @@ -30,6 +31,4 @@ CREATE TABLE journal ( CREATE OR REPLACE VIEW messages AS ( SELECT *, regexp_replace(page, '.*/', '')::int issue FROM comments - UNION ALL - SELECT concat(page,'/',id), body, created, author, NULL, id FROM issues );