Index: mt-pg.sql ================================================================== --- mt-pg.sql +++ mt-pg.sql @@ -42,10 +42,11 @@ DROP TABLE IF EXISTS sessions; DROP TABLE IF EXISTS tags; DROP TABLE IF EXISTS users; DROP TABLE IF EXISTS webviews; DROP TABLE IF EXISTS area_tags; +DROP TABLE IF EXISTS run_tags; DROP TABLE IF EXISTS users_webviews; DROP TABLE IF EXISTS base_paths; DROP TABLE IF EXISTS area_owners; DROP TABLE IF EXISTS shared_user_views; DROP TABLE IF EXISTS cctrl_info; @@ -80,10 +81,17 @@ CREATE TABLE IF NOT EXISTS area_tags ( id SERIAL PRIMARY KEY, tag_id INTEGER DEFAULT 0, area_id INTEGER DEFAULT 0, CONSTRAINT areatagconstraint UNIQUE (tag_id, area_id)); + +CREATE TABLE IF NOT EXISTS run_tags ( + id SERIAL PRIMARY KEY, + tag_id INTEGER DEFAULT 0, + run_id INTEGER DEFAULT 0, + CONSTRAINT areatagconstraint UNIQUE (tag_id, run_id)); + CREATE VIEW area_tag_view as select a.id as aid, t.id as tid,area_name,tag_name,area_path from areas as a inner join area_tags as at on at.area_id = a.id inner join tags as t on t.id = at.tag_id ;