X-Git-Url: https://git.wh0rd.org/?a=blobdiff_plain;f=schema%2Fttrss_schema_mysql.sql;h=a1b45efbbddca58a966c100dc4d5317bc7568c44;hb=07fd4f8d9d4f301f5ad88ff9e80f042fc3eb0c36;hp=1ec40966112f0370459b2e22edacf26a5c7d4b39;hpb=10a1f28f7c532455a17a15b158f965fd1fea9d51;p=tt-rss.git diff --git a/schema/ttrss_schema_mysql.sql b/schema/ttrss_schema_mysql.sql index 1ec40966..a1b45efb 100644 --- a/schema/ttrss_schema_mysql.sql +++ b/schema/ttrss_schema_mysql.sql @@ -102,7 +102,9 @@ create table ttrss_feeds (id integer not null auto_increment primary key, update_interval integer not null default 0, purge_interval integer not null default 0, last_updated datetime default null, + last_unconditional datetime default null, last_error varchar(250) not null default '', + last_modified varchar(250) not null default '', favicon_avg_color varchar(11) default null, site_url varchar(250) not null default '', auth_login varchar(250) not null default '', @@ -246,7 +248,7 @@ create table ttrss_filters2(id integer primary key auto_increment, create table ttrss_filters2_rules(id integer primary key auto_increment, filter_id integer not null references ttrss_filters2(id) on delete cascade, - reg_exp varchar(250) not null, + reg_exp text not null, inverse bool not null default false, filter_type integer not null, feed_id integer default null, @@ -282,7 +284,7 @@ create table ttrss_tags (id integer primary key auto_increment, create table ttrss_version (schema_version int not null) ENGINE=InnoDB DEFAULT CHARSET=UTF8; -insert into ttrss_version values (131); +insert into ttrss_version values (134); create table ttrss_enclosures (id integer primary key auto_increment, content_url text not null,