diff options
author | Andrew Dolgov <[email protected]> | 2009-01-18 16:42:07 +0100 |
---|---|---|
committer | Andrew Dolgov <[email protected]> | 2009-01-18 16:42:07 +0100 |
commit | f054b5475b2a5eac627c20084f85eedb6936f060 (patch) | |
tree | 0109330c112f3dd49dc5968efb0e97e6e2565d4f /schema/ttrss_schema_pgsql.sql | |
parent | 1c9c602534e9a0aab5426d91f96b07ff31deabc6 (diff) |
schema: remove ttrss_labels
Diffstat (limited to 'schema/ttrss_schema_pgsql.sql')
-rw-r--r-- | schema/ttrss_schema_pgsql.sql | 13 |
1 files changed, 0 insertions, 13 deletions
diff --git a/schema/ttrss_schema_pgsql.sql b/schema/ttrss_schema_pgsql.sql index b2ea2a596..8646632d9 100644 --- a/schema/ttrss_schema_pgsql.sql +++ b/schema/ttrss_schema_pgsql.sql @@ -191,19 +191,6 @@ create table ttrss_filters (id serial not null primary key, action_id integer not null default 1 references ttrss_filter_actions(id) on delete cascade, action_param varchar(250) not null default ''); -create table ttrss_labels (id serial not null primary key, - owner_uid integer not null references ttrss_users(id) on delete cascade, - sql_exp text not null, - description varchar(250) not null); - -create index ttrss_labels_owner_uid_index on ttrss_labels(owner_uid); - -insert into ttrss_labels (owner_uid,sql_exp,description) values (1,'unread = true', - 'Unread articles'); - -insert into ttrss_labels (owner_uid,sql_exp,description) values (1, - 'last_read is null and unread = false', 'Updated articles'); - create table ttrss_tags (id serial not null primary key, tag_name varchar(250) not null, owner_uid integer not null references ttrss_users(id) on delete cascade, |