diff options
author | Andrew Dolgov <[email protected]> | 2012-12-27 19:20:12 +0400 |
---|---|---|
committer | Andrew Dolgov <[email protected]> | 2012-12-27 19:20:36 +0400 |
commit | 5d9abb1e11262b5ef7c6f4695590ce5bdb257b85 (patch) | |
tree | b87b628efa00e479eb37a635827b802a61a26746 /schema/ttrss_schema_mysql.sql | |
parent | d8a1d2a25b2247e5a63f5b0ab7f0bd9423a217e5 (diff) |
add plugin storage table to schema; add ability to clear plugin data
Diffstat (limited to 'schema/ttrss_schema_mysql.sql')
-rw-r--r-- | schema/ttrss_schema_mysql.sql | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/schema/ttrss_schema_mysql.sql b/schema/ttrss_schema_mysql.sql index bb8bd1028..0b0c587b9 100644 --- a/schema/ttrss_schema_mysql.sql +++ b/schema/ttrss_schema_mysql.sql @@ -1,6 +1,7 @@ SET NAMES utf8; SET CHARACTER SET utf8; +drop table if exists ttrss_plugin_storage; drop table if exists ttrss_linked_feeds; drop table if exists ttrss_linked_instances; drop table if exists ttrss_access_keys; @@ -528,4 +529,12 @@ create table ttrss_linked_feeds ( subscribers integer not null, foreign key (instance_id) references ttrss_linked_instances(id) ON DELETE CASCADE) ENGINE=InnoDB DEFAULT CHARSET=UTF8; +create table ttrss_plugin_storage ( + id integer not null auto_increment primary key, + name varchar(100) not null, + owner_uid integer not null, + content longtext not null, + foreign key (owner_uid) references ttrss_users(id) ON DELETE CASCADE) ENGINE=InnoDB DEFAULT CHARSET=UTF8; + + commit; |