From 4d73637869e2e9d3adf4e7d9dc327a41bd071eb9 Mon Sep 17 00:00:00 2001
From: Andrew Dolgov <fox@bah.spb.su>
Date: Mon, 13 Oct 2008 14:10:31 +0100
Subject: schema: add ttrss_counters_cache

---
 schema/versions/pgsql/44.sql | 6 ++++++
 1 file changed, 6 insertions(+)
 create mode 100644 schema/versions/pgsql/44.sql

(limited to 'schema/versions/pgsql/44.sql')

diff --git a/schema/versions/pgsql/44.sql b/schema/versions/pgsql/44.sql
new file mode 100644
index 000000000..a88bfede6
--- /dev/null
+++ b/schema/versions/pgsql/44.sql
@@ -0,0 +1,6 @@
+create table ttrss_counters_cache (
+	feed_id integer not null references ttrss_feeds(id) ON DELETE CASCADE,
+	owner_uid integer not null references ttrss_users(id) ON DELETE CASCADE,
+	value integer not null default 0);
+
+update ttrss_version set schema_version = 44;
-- 
cgit v1.2.3

