From ceb30ba49d300d53a0693aba7e1f0e4c523aeedc Mon Sep 17 00:00:00 2001
From: Andrew Dolgov <fox@bah.spb.su>
Date: Sun, 18 Jan 2009 09:28:42 +0100
Subject: new style labels (bump schema)

---
 schema/ttrss_schema_mysql.sql | 17 ++++++++++++++++-
 1 file changed, 16 insertions(+), 1 deletion(-)

(limited to 'schema/ttrss_schema_mysql.sql')

diff --git a/schema/ttrss_schema_mysql.sql b/schema/ttrss_schema_mysql.sql
index 4d081db0f..9bfb0a075 100644
--- a/schema/ttrss_schema_mysql.sql
+++ b/schema/ttrss_schema_mysql.sql
@@ -189,6 +189,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 integer not null primary key auto_increment,
 	owner_uid integer not null, 
 	feed_id integer default null,
@@ -232,7 +235,7 @@ create table ttrss_tags (id integer primary key auto_increment,
 
 create table ttrss_version (schema_version int not null) TYPE=InnoDB;
 
-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,
@@ -389,4 +392,16 @@ create table ttrss_feedbrowser_cache (
 	feed_url text not null,
 	subscribers integer not null);	
 
+create table ttrss_labels2 (id integer not null primary key auto_increment, 
+	owner_uid integer not null,
+	caption varchar(250) not null,
+	foreign key (owner_uid) references ttrss_users(id) ON DELETE CASCADE
+) TYPE=InnoDB;
+
+create table ttrss_user_labels2 (label_id integer not null,
+	article_id integer not null,
+	foreign key (label_id) references ttrss_labels2(id) ON DELETE CASCADE,
+	foreign key (article_id) references ttrss_entries(id) ON DELETE CASCADE
+) TYPE=InnoDB;
+
 commit;
-- 
cgit v1.2.3

