X-Git-Url: http://git.shiar.net/minimedit.git/blobdiff_plain/8f05d49e133e9ca27d20bfc3835fc08812a683cb..10356b51f95050d0aec0cd1807d5ba1ec46d475a:/widget/comments.sql?ds=sidebyside diff --git a/widget/comments.sql b/widget/comments.sql index 8a06558..2a4993b 100644 --- a/widget/comments.sql +++ b/widget/comments.sql @@ -18,3 +18,12 @@ CREATE TABLE comments ( author text, id serial NOT NULL PRIMARY KEY ); + +CREATE TABLE journal ( + comment_id integer NOT NULL REFERENCES comments (id), + property text NOT NULL DEFAULT 'attr', + col text NOT NULL, + old_value text, + value text, + id serial NOT NULL PRIMARY KEY +);