Index: mt-pg.sql ================================================================== --- mt-pg.sql +++ mt-pg.sql @@ -82,11 +82,11 @@ tag_id INTEGER DEFAULT 0, area_id INTEGER DEFAULT 0, CONSTRAINT areatagconstraint UNIQUE (tag_id, area_id)); CREATE VIEW area_tag_view as -select a.id as aid, t.id as tid,area_name,tag_name from areas as a inner join area_tags as at on at.area_id = a.id +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 ; INSERT INTO areas (id,area_name,area_path) VALUES (0,'local','.'); CREATE TABLE IF NOT EXISTS ttype ( @@ -309,15 +309,16 @@ CREATE TABLE IF NOT EXISTS users_webviews( id SERIAL PRIMARY KEY , - user_id INTEGER NOT NULL, - webview_id INTEGER NOT NULL, - deleted INTEGER default 0, - searchpattern TEXT Default '', - web_page TEXT Default '', + user_id INTEGER NOT NULL, + webview_id INTEGER NOT NULL, + deleted INTEGER default 0, + searchpattern TEXT Default '', + web_page TEXT Default '', + is_default boolean default 'f', other_search_data TEXT Default '' ); CREATE TABLE IF NOT EXISTS cctrl_info( id SERIAL PRIMARY KEY ,