diff options
author | Andrew Dolgov <[email protected]> | 2009-01-16 14:11:19 +0100 |
---|---|---|
committer | Andrew Dolgov <[email protected]> | 2009-01-16 14:11:19 +0100 |
commit | 8a4c759ea3ea4c70b059d1403ddea6a06bc81780 (patch) | |
tree | e7e8a7f7d36dda81e7b06c23b81521988ef435d2 /schema/versions/mysql/50.sql | |
parent | 2627f2d0456364235ba842f996b65954c5ac5d01 (diff) |
a variety of ccache work
Diffstat (limited to 'schema/versions/mysql/50.sql')
-rw-r--r-- | schema/versions/mysql/50.sql | 19 |
1 files changed, 19 insertions, 0 deletions
diff --git a/schema/versions/mysql/50.sql b/schema/versions/mysql/50.sql new file mode 100644 index 000000000..6f49742f4 --- /dev/null +++ b/schema/versions/mysql/50.sql @@ -0,0 +1,19 @@ +drop table if exists ttrss_counters_cache; + +create table ttrss_counters_cache ( + feed_id integer not null, + owner_uid integer not null, + value integer not null default 0, + updated datetime not null, + foreign key (owner_uid) references ttrss_users(id) ON DELETE CASCADE +); + +create table ttrss_cat_counters_cache ( + feed_id integer not null, + owner_uid integer not null, + value integer not null default 0, + updated datetime not null, + foreign key (owner_uid) references ttrss_users(id) ON DELETE CASCADE +); + +update ttrss_version set schema_version = 50; |