From eb36b4eb5526fca5ea05b635d828e290687b4ea3 Mon Sep 17 00:00:00 2001
From: Andrew Dolgov <fox@bah.spb.su>
Date: Fri, 9 Sep 2005 05:52:36 +0100
Subject: start work on support for technorati tags, schema uses cascade
 deletes for pgsql

---
 schema/ttrss_schema_mysql.sql | 5 +++++
 1 file changed, 5 insertions(+)

(limited to 'schema/ttrss_schema_mysql.sql')

diff --git a/schema/ttrss_schema_mysql.sql b/schema/ttrss_schema_mysql.sql
index ae736cb6f..877421920 100644
--- a/schema/ttrss_schema_mysql.sql
+++ b/schema/ttrss_schema_mysql.sql
@@ -1,3 +1,4 @@
+drop table if exists ttrss_tags;
 drop table if exists ttrss_entries;
 drop table if exists ttrss_feeds;
 
@@ -69,3 +70,7 @@ create table ttrss_labels (id integer primary key auto_increment,
 insert into ttrss_labels (sql_exp,description) values ('unread = true', 
 	'Unread articles');
 
+create table ttrss_tags (id integer primary key auto_increment, 
+	tag_name varchar(250) not null,
+	post_id integer references ttrss_entries(id)) TYPE=InnoDB;
+
-- 
cgit v1.2.3-54-g00ecf

