Mercurial > gemma
diff schema/gemma.sql @ 2147:b66cfcde8ff7
Print templates: Stubbed endpoints under /api/templates/print/{name}
author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
---|---|
date | Fri, 08 Feb 2019 11:02:05 +0100 |
parents | 3f58809d2beb |
children | 5fdeb41f3ed4 |
line wrap: on
line diff
--- a/schema/gemma.sql Thu Feb 07 17:45:00 2019 +0100 +++ b/schema/gemma.sql Fri Feb 08 11:02:05 2019 +0100 @@ -188,13 +188,13 @@ CREATE TRIGGER templates_date_info BEFORE UPDATE ON templates FOR EACH ROW EXECUTE PROCEDURE update_date_info() - CREATE TABLE user_templates ( - username varchar NOT NULL - REFERENCES internal.user_profiles - ON DELETE CASCADE ON UPDATE CASCADE, - template_name varchar NOT NULL REFERENCES templates ON DELETE CASCADE, - PRIMARY KEY (username, template_name) - ) + -- CREATE TABLE user_templates ( + -- username varchar NOT NULL + -- REFERENCES internal.user_profiles + -- ON DELETE CASCADE ON UPDATE CASCADE, + -- template_name varchar NOT NULL REFERENCES templates ON DELETE CASCADE, + -- PRIMARY KEY (username, template_name) + --) ; ALTER TABLE internal.user_profiles ADD country char(2) NOT NULL REFERENCES users.responsibility_areas;