diff options
author | Andrew Dolgov <[email protected]> | 2009-01-18 09:28:42 +0100 |
---|---|---|
committer | Andrew Dolgov <[email protected]> | 2009-01-18 09:28:42 +0100 |
commit | ceb30ba49d300d53a0693aba7e1f0e4c523aeedc (patch) | |
tree | f914db574e5d19af48c997eaf26dc5ff69de7a64 /schema/ttrss_schema_pgsql.sql | |
parent | abd9b16507fd517dc56af1be0d11d7043063ddc5 (diff) |
new style labels (bump schema)
Diffstat (limited to 'schema/ttrss_schema_pgsql.sql')
-rw-r--r-- | schema/ttrss_schema_pgsql.sql | 17 |
1 files changed, 16 insertions, 1 deletions
diff --git a/schema/ttrss_schema_pgsql.sql b/schema/ttrss_schema_pgsql.sql index 319e64211..9778a044f 100644 --- a/schema/ttrss_schema_pgsql.sql +++ b/schema/ttrss_schema_pgsql.sql @@ -1,3 +1,5 @@ +drop table ttrss_user_labels2; +drop table ttrss_labels2; drop table ttrss_feedbrowser_cache; drop table ttrss_version; drop table ttrss_labels; @@ -175,6 +177,9 @@ insert into ttrss_filter_actions (id,name,description) values (5, 'publish', insert into ttrss_filter_actions (id,name,description) values (6, 'score', 'Modify score'); +insert into ttrss_filter_actions (id,name,description) values (7, 'label', + 'Assign label'); + create table ttrss_filters (id serial not null primary key, owner_uid integer not null references ttrss_users(id) on delete cascade, feed_id integer references ttrss_feeds(id) on delete cascade default null, @@ -208,7 +213,7 @@ create index ttrss_tags_owner_uid_index on ttrss_tags(owner_uid); create table ttrss_version (schema_version int not null); -insert into ttrss_version values (50); +insert into ttrss_version values (51); create table ttrss_enclosures (id serial not null primary key, content_url text not null, @@ -358,4 +363,14 @@ create table ttrss_feedbrowser_cache ( feed_url text not null primary key, subscribers integer not null); +create table ttrss_labels2 (id serial not null primary key, + owner_uid integer not null references ttrss_users(id) ON DELETE CASCADE, + caption varchar(250) not null +); + +create table ttrss_user_labels2 ( + label_id integer not null references ttrss_labels2(id) ON DELETE CASCADE, + article_id integer not null references ttrss_entries(id) ON DELETE CASCADE +); + commit; |