schema/ttrss_schema_mysql.sql

   1 SET NAMES utf8;
   2 SET CHARACTER SET utf8;
   3
   4 drop table if exists ttrss_error_log;
   5 drop table if exists ttrss_plugin_storage;
   6 drop table if exists ttrss_linked_feeds;
   7 drop table if exists ttrss_linked_instances;
   8 drop table if exists ttrss_access_keys;
   9 drop table if exists ttrss_user_labels2;
  10 drop table if exists ttrss_labels2;
  11 drop table if exists ttrss_feedbrowser_cache;
  12 drop table if exists ttrss_version;
  13 drop table if exists ttrss_labels;
  14 drop table if exists ttrss_filters2_actions;
  15 drop table if exists ttrss_filters2_rules;
  16 drop table if exists ttrss_filters2;
  17 drop table if exists ttrss_filters;
  18 drop table if exists ttrss_filter_types;
  19 drop table if exists ttrss_filter_actions;
  20 drop table if exists ttrss_user_prefs;
  21 drop table if exists ttrss_prefs;
  22 drop table if exists ttrss_prefs_types;
  23 drop table if exists ttrss_prefs_sections;
  24 drop table if exists ttrss_tags;
  25 drop table if exists ttrss_enclosures;
  26 drop table if exists ttrss_settings_profiles;
  27 drop table if exists ttrss_entry_comments;
  28 drop table if exists ttrss_user_entries;
  29 drop table if exists ttrss_entries;
  30 drop table if exists ttrss_scheduled_updates;
  31 drop table if exists ttrss_counters_cache;
  32 drop table if exists ttrss_cat_counters_cache;
  33 drop table if exists ttrss_feeds;
  34 drop table if exists ttrss_archived_feeds;
  35 drop table if exists ttrss_feed_categories;
  36 drop table if exists ttrss_users;
  37 drop table if exists ttrss_themes;
  38 drop table if exists ttrss_sessions;
  39
  40 begin;
  41
  42 create table ttrss_users (id integer primary key not null auto_increment,
  43         login varchar(120) not null unique,
  44         pwd_hash varchar(250) not null,
  45         last_login datetime default null,
  46         access_level integer not null default 0,
  47         email varchar(250) not null default '',
  48         full_name varchar(250) not null default '',
  49         email_digest bool not null default false,
  50         last_digest_sent datetime default null,
  51         salt varchar(250) not null default '',
  52         created datetime default null,
  53         twitter_oauth longtext default null,
  54         otp_enabled boolean not null default false,
  55         resetpass_token varchar(250) default null) ENGINE=InnoDB DEFAULT CHARSET=UTF8;
  56
  57 insert into ttrss_users (login,pwd_hash,access_level) values ('admin',
  58         'SHA1:5baa61e4c9b93f3f0682250b6cf8331b7ee68fd8', 10);
  59
  60 create table ttrss_feed_categories(id integer not null primary key auto_increment,
  61         owner_uid integer not null,
  62         title varchar(200) not null,
  63         collapsed bool not null default false,
  64         order_id integer not null default 0,
  65         parent_cat integer,
  66         view_settings varchar(250) not null default '',
  67         foreign key (parent_cat) references ttrss_feed_categories(id) ON DELETE SET NULL,
  68         foreign key (owner_uid) references ttrss_users(id) ON DELETE CASCADE) ENGINE=InnoDB DEFAULT CHARSET=UTF8;
  69
  70 create table ttrss_archived_feeds (id integer not null primary key,
  71         owner_uid integer not null,
  72         title varchar(200) not null,
  73         feed_url text not null,
  74         site_url varchar(250) not null default '',
  75         foreign key (owner_uid) references ttrss_users(id) ON DELETE CASCADE) ENGINE=InnoDB DEFAULT CHARSET=UTF8;
  76
  77 create table ttrss_counters_cache (
  78         feed_id integer not null,
  79         owner_uid integer not null,
  80         value integer not null default 0,
  81         updated datetime not null,
  82         foreign key (owner_uid) references ttrss_users(id) ON DELETE CASCADE
  83 ) ENGINE=InnoDB DEFAULT CHARSET=UTF8;
  84
  85 create index ttrss_counters_cache_feed_id_idx on ttrss_counters_cache(feed_id);
  86 create index ttrss_counters_cache_value_idx on ttrss_counters_cache(value);
  87
  88 create table ttrss_cat_counters_cache (
  89         feed_id integer not null,
  90         owner_uid integer not null,
  91         value integer not null default 0,
  92         updated datetime not null,
  93         foreign key (owner_uid) references ttrss_users(id) ON DELETE CASCADE
  94 ) ENGINE=InnoDB DEFAULT CHARSET=UTF8;
  95
  96 create table ttrss_feeds (id integer not null auto_increment primary key,
  97         owner_uid integer not null,
  98         title varchar(200) not null,
  99         cat_id integer default null,
 100         feed_url text not null,
 101         icon_url varchar(250) not null default '',
 102         update_interval integer not null default 0,
 103         purge_interval integer not null default 0,
 104         last_updated datetime default null,
 105         last_error varchar(250) not null default '',
 106         favicon_avg_color varchar(11) default null,
 107         site_url varchar(250) not null default '',
 108         auth_login varchar(250) not null default '',
 109         auth_pass varchar(250) not null default '',
 110         parent_feed integer default null,
 111         private bool not null default false,
 112         rtl_content bool not null default false,
 113         hidden bool not null default false,
 114         include_in_digest boolean not null default true,
 115         cache_images boolean not null default false,
 116         hide_images boolean not null default false,
 117         cache_content boolean not null default false,
 118         auth_pass_encrypted boolean not null default false,
 119         last_viewed datetime default null,
 120         last_update_started datetime default null,
 121         always_display_enclosures boolean not null default false,
 122         update_method integer not null default 0,
 123         order_id integer not null default 0,
 124         mark_unread_on_update boolean not null default false,
 125         update_on_checksum_change boolean not null default false,
 126         strip_images boolean not null default false,
 127         view_settings varchar(250) not null default '',
 128         pubsub_state integer not null default 0,
 129         favicon_last_checked datetime default null,
 130         feed_language varchar(100) not null default '',
 131         foreign key (owner_uid) references ttrss_users(id) ON DELETE CASCADE,
 132         foreign key (cat_id) references ttrss_feed_categories(id) ON DELETE SET NULL,
 133         foreign key (parent_feed) references ttrss_feeds(id) ON DELETE SET NULL) ENGINE=InnoDB DEFAULT CHARSET=UTF8;
 134
 135 insert into ttrss_feeds (owner_uid, title, feed_url) values
 136         (1, 'Tiny Tiny RSS: Forum', 'http://tt-rss.org/forum/rss.php');
 137
 138 create table ttrss_entries (id integer not null primary key auto_increment,
 139         title text not null,
 140         guid varchar(255) not null unique,
 141         link text not null,
 142         updated datetime not null,
 143         content longtext not null,
 144         content_hash varchar(250) not null,
 145         cached_content longtext,
 146         no_orig_date bool not null default 0,
 147         date_entered datetime not null,
 148         date_updated datetime not null,
 149         num_comments integer not null default 0,
 150         plugin_data longtext,
 151         lang varchar(2),
 152         comments varchar(250) not null default '',
 153         author varchar(250) not null default '') ENGINE=InnoDB DEFAULT CHARSET=UTF8;
 154
 155 create index ttrss_entries_date_entered_index on ttrss_entries(date_entered);
 156 create index ttrss_entries_updated_idx on ttrss_entries(updated);
 157
 158 create table ttrss_user_entries (
 159         int_id integer not null primary key auto_increment,
 160         ref_id integer not null,
 161         uuid varchar(200) not null,
 162         feed_id int,
 163         orig_feed_id int,
 164         owner_uid integer not null,
 165         marked bool not null default 0,
 166         published bool not null default 0,
 167         tag_cache text not null,
 168         label_cache text not null,
 169         last_read datetime,
 170         score int not null default 0,
 171         note longtext,
 172         last_marked datetime,
 173         last_published datetime,
 174         unread bool not null default 1,
 175         foreign key (ref_id) references ttrss_entries(id) ON DELETE CASCADE,
 176         foreign key (feed_id) references ttrss_feeds(id) ON DELETE CASCADE,
 177         foreign key (orig_feed_id) references ttrss_archived_feeds(id) ON DELETE SET NULL,
 178         foreign key (owner_uid) references ttrss_users(id) ON DELETE CASCADE) ENGINE=InnoDB DEFAULT CHARSET=UTF8;
 179
 180 create index ttrss_user_entries_unread_idx on ttrss_user_entries(unread);
 181
 182 create table ttrss_entry_comments (id integer not null primary key,
 183         ref_id integer not null,
 184         owner_uid integer not null,
 185         private bool not null default 0,
 186         date_entered datetime not null,
 187         index (ref_id),
 188         foreign key (ref_id) references ttrss_entries(id) ON DELETE CASCADE,
 189         index (owner_uid),
 190         foreign key (owner_uid) references ttrss_users(id) ON DELETE CASCADE) ENGINE=InnoDB DEFAULT CHARSET=UTF8;
 191
 192 create table ttrss_filter_types (id integer primary key,
 193         name varchar(120) unique not null,
 194         description varchar(250) not null unique) ENGINE=InnoDB DEFAULT CHARSET=UTF8;
 195
 196 insert into ttrss_filter_types (id,name,description) values (1, 'title', 'Title');
 197 insert into ttrss_filter_types (id,name,description) values (2, 'content', 'Content');
 198 insert into ttrss_filter_types (id,name,description) values (3, 'both',
 199         'Title or Content');
 200 insert into ttrss_filter_types (id,name,description) values (4, 'link',
 201         'Link');
 202 insert into ttrss_filter_types (id,name,description) values (5, 'date',
 203         'Article Date');
 204 insert into ttrss_filter_types (id,name,description) values (6, 'author', 'Author');
 205 insert into ttrss_filter_types (id,name,description) values (7, 'tag', 'Article Tags');
 206
 207 create table ttrss_filter_actions (id integer not null primary key,
 208         name varchar(120) unique not null,
 209         description varchar(250) not null unique) ENGINE=InnoDB DEFAULT CHARSET=UTF8;
 210
 211 insert into ttrss_filter_actions (id,name,description) values (1, 'filter',
 212         'Delete article');
 213
 214 insert into ttrss_filter_actions (id,name,description) values (2, 'catchup',
 215         'Mark as read');
 216
 217 insert into ttrss_filter_actions (id,name,description) values (3, 'mark',
 218         'Set starred');
 219
 220 insert into ttrss_filter_actions (id,name,description) values (4, 'tag',
 221         'Assign tags');
 222
 223 insert into ttrss_filter_actions (id,name,description) values (5, 'publish',
 224         'Publish article');
 225
 226 insert into ttrss_filter_actions (id,name,description) values (6, 'score',
 227         'Modify score');
 228
 229 insert into ttrss_filter_actions (id,name,description) values (7, 'label',
 230         'Assign label');
 231
 232 insert into ttrss_filter_actions (id,name,description) values (8, 'stop',
 233         'Stop / Do nothing');
 234
 235 insert into ttrss_filter_actions (id,name,description) values (9, 'plugin',
 236         'Invoke plugin');
 237
 238 create table ttrss_filters2(id integer primary key auto_increment,
 239         owner_uid integer not null,
 240         match_any_rule boolean not null default false,
 241         enabled boolean not null default true,
 242         inverse bool not null default false,
 243         title varchar(250) not null default '',
 244         order_id integer not null default 0,
 245         foreign key (owner_uid) references ttrss_users(id) ON DELETE CASCADE) ENGINE=InnoDB DEFAULT CHARSET=UTF8;
 246
 247 create table ttrss_filters2_rules(id integer primary key auto_increment,
 248         filter_id integer not null references ttrss_filters2(id) on delete cascade,
 249         reg_exp varchar(250) not null,
 250         inverse bool not null default false,
 251         filter_type integer not null,
 252         feed_id integer default null,
 253         cat_id integer default null,
 254         cat_filter boolean not null default false,
 255         match_on text,
 256         index (filter_id),
 257         foreign key (filter_id) references ttrss_filters2(id) on delete cascade,
 258         index (filter_type),
 259         foreign key (filter_type) references ttrss_filter_types(id) ON DELETE CASCADE,
 260         index (feed_id),
 261         foreign key (feed_id) references ttrss_feeds(id) ON DELETE CASCADE,
 262         index (cat_id),
 263         foreign key (cat_id) references ttrss_feed_categories(id) ON DELETE CASCADE) ENGINE=InnoDB DEFAULT CHARSET=UTF8;
 264
 265 create table ttrss_filters2_actions(id integer primary key auto_increment,
 266         filter_id integer not null,
 267         action_id integer not null default 1 references ttrss_filter_actions(id) on delete cascade,
 268         action_param varchar(250) not null default '',
 269         index (filter_id),
 270         foreign key (filter_id) references ttrss_filters2(id) on delete cascade,
 271         index (action_id),
 272         foreign key (action_id) references ttrss_filter_actions(id) ON DELETE CASCADE) ENGINE=InnoDB DEFAULT CHARSET=UTF8;
 273
 274 create table ttrss_tags (id integer primary key auto_increment,
 275         owner_uid integer not null,
 276         tag_name varchar(250) not null,
 277         post_int_id integer not null,
 278         index (post_int_id),
 279         foreign key (post_int_id) references ttrss_user_entries(int_id) ON DELETE CASCADE,
 280         index (owner_uid),
 281         foreign key (owner_uid) references ttrss_users(id) ON DELETE CASCADE) ENGINE=InnoDB DEFAULT CHARSET=UTF8;
 282
 283 create table ttrss_version (schema_version int not null) ENGINE=InnoDB DEFAULT CHARSET=UTF8;
 284
 285 insert into ttrss_version values (131);
 286
 287 create table ttrss_enclosures (id integer primary key auto_increment,
 288         content_url text not null,
 289         content_type varchar(250) not null,
 290         post_id integer not null,
 291         title text not null,
 292         duration text not null,
 293         width integer not null default 0,
 294         height integer not null default 0,
 295         foreign key (post_id) references ttrss_entries(id) ON DELETE cascade) ENGINE=InnoDB DEFAULT CHARSET=UTF8;
 296
 297 create table ttrss_settings_profiles(id integer primary key auto_increment,
 298         title varchar(250) not null,
 299         owner_uid integer not null,
 300         index (owner_uid),
 301         foreign key (owner_uid) references ttrss_users(id) ON DELETE CASCADE) ENGINE=InnoDB DEFAULT CHARSET=UTF8;
 302
 303 create table ttrss_prefs_types (id integer not null primary key,
 304         type_name varchar(100) not null) ENGINE=InnoDB DEFAULT CHARSET=UTF8;
 305
 306 insert into ttrss_prefs_types (id, type_name) values (1, 'bool');
 307 insert into ttrss_prefs_types (id, type_name) values (2, 'string');
 308 insert into ttrss_prefs_types (id, type_name) values (3, 'integer');
 309
 310 create table ttrss_prefs_sections (id integer not null primary key,
 311         order_id integer not null) ENGINE=InnoDB DEFAULT CHARSET=UTF8;
 312
 313 insert into ttrss_prefs_sections (id, order_id) values (1, 0);
 314 insert into ttrss_prefs_sections (id, order_id) values (2, 1);
 315 insert into ttrss_prefs_sections (id, order_id) values (3, 3);
 316 insert into ttrss_prefs_sections (id, order_id) values (4, 2);
 317
 318 create table ttrss_prefs (pref_name varchar(250) not null primary key,
 319         type_id integer not null,
 320         section_id integer not null default 1,
 321         access_level integer not null default 0,
 322         def_value text not null,
 323         foreign key (type_id) references ttrss_prefs_types(id),
 324         foreign key (section_id) references ttrss_prefs_sections(id)) ENGINE=InnoDB DEFAULT CHARSET=UTF8;
 325
 326 insert into ttrss_prefs (pref_name,type_id,def_value,section_id) values('PURGE_OLD_DAYS', 3, '60', 1);
 327 insert into ttrss_prefs (pref_name,type_id,def_value,section_id) values('DEFAULT_UPDATE_INTERVAL', 3, '30', 1);
 328 insert into ttrss_prefs (pref_name,type_id,def_value,section_id) values('DEFAULT_ARTICLE_LIMIT', 3, '30', 2);
 329 insert into ttrss_prefs (pref_name,type_id,def_value,section_id) values('ALLOW_DUPLICATE_POSTS', 1, 'false', 1);
 330 insert into ttrss_prefs (pref_name,type_id,def_value,section_id) values('ENABLE_FEED_CATS', 1, 'true', 2);
 331 insert into ttrss_prefs (pref_name,type_id,def_value,section_id) values('SHOW_CONTENT_PREVIEW', 1, 'true', 2);
 332 insert into ttrss_prefs (pref_name,type_id,def_value,section_id) values('SHORT_DATE_FORMAT', 2, 'M d, G:i', 3);
 333 insert into ttrss_prefs (pref_name,type_id,def_value,section_id) values('LONG_DATE_FORMAT', 2, 'D, M d Y - G:i', 3);
 334 insert into ttrss_prefs (pref_name,type_id,def_value,section_id) values('COMBINED_DISPLAY_MODE', 1, 'true', 2);
 335 insert into ttrss_prefs (pref_name,type_id,def_value,section_id) values('HIDE_READ_FEEDS', 1, 'false', 2);
 336 insert into ttrss_prefs (pref_name,type_id,def_value,section_id) values('ON_CATCHUP_SHOW_NEXT_FEED', 1, 'false', 2);
 337 insert into ttrss_prefs (pref_name,type_id,def_value,section_id) values('FEEDS_SORT_BY_UNREAD', 1, 'false', 2);
 338 insert into ttrss_prefs (pref_name,type_id,def_value,section_id) values('REVERSE_HEADLINES', 1, 'false', 2);
 339 insert into ttrss_prefs (pref_name,type_id,def_value,section_id) values('DIGEST_ENABLE', 1, 'false', 4);
 340 insert into ttrss_prefs (pref_name,type_id,def_value,section_id) values('CONFIRM_FEED_CATCHUP', 1, 'true', 2);
 341 insert into ttrss_prefs (pref_name,type_id,def_value,section_id) values('CDM_AUTO_CATCHUP', 1, 'false', 2);
 342 insert into ttrss_prefs (pref_name,type_id,def_value,section_id) values('_DEFAULT_VIEW_MODE', 2, 'adaptive', 1);
 343 insert into ttrss_prefs (pref_name,type_id,def_value,section_id) values('_DEFAULT_VIEW_LIMIT', 3, '30', 1);
 344 insert into ttrss_prefs (pref_name,type_id,def_value,section_id) values('_PREFS_ACTIVE_TAB', 2, '', 1);
 345 insert into ttrss_prefs (pref_name,type_id,def_value,section_id) values('STRIP_UNSAFE_TAGS', 1, 'true', 3);
 346 insert into ttrss_prefs (pref_name,type_id,def_value,section_id) values('BLACKLISTED_TAGS', 2, 'main, generic, misc, uncategorized, blog, blogroll, general, news', 3);
 347 insert into ttrss_prefs (pref_name,type_id,def_value,section_id) values('FRESH_ARTICLE_MAX_AGE', 3, '24', 2);
 348 insert into ttrss_prefs (pref_name,type_id,def_value,section_id) values('DIGEST_CATCHUP', 1, 'false', 4);
 349 insert into ttrss_prefs (pref_name,type_id,def_value,section_id) values('CDM_EXPANDED', 1, 'true', 2);
 350 insert into ttrss_prefs (pref_name,type_id,def_value,section_id) values('PURGE_UNREAD_ARTICLES', 1, 'true', 3);
 351 insert into ttrss_prefs (pref_name,type_id,def_value,section_id) values('HIDE_READ_SHOWS_SPECIAL', 1, 'true', 2);
 352 insert into ttrss_prefs (pref_name,type_id,def_value,section_id) values('VFEED_GROUP_BY_FEED', 1, 'false', 2);
 353 insert into ttrss_prefs (pref_name,type_id,def_value,section_id) values('STRIP_IMAGES', 1, 'false', 2);
 354 insert into ttrss_prefs (pref_name,type_id,def_value,section_id) values('_DEFAULT_VIEW_ORDER_BY', 2, 'default', 1);
 355 insert into ttrss_prefs (pref_name,type_id,def_value,section_id) values('ENABLE_API_ACCESS', 1, 'false', 1);
 356 insert into ttrss_prefs (pref_name,type_id,def_value,section_id) values('_COLLAPSED_SPECIAL', 1, 'false', 1);
 357 insert into ttrss_prefs (pref_name,type_id,def_value,section_id) values('_COLLAPSED_LABELS', 1, 'false', 1);
 358 insert into ttrss_prefs (pref_name,type_id,def_value,section_id) values('_COLLAPSED_UNCAT', 1, 'false', 1);
 359 insert into ttrss_prefs (pref_name,type_id,def_value,section_id) values('_COLLAPSED_FEEDLIST', 1, 'false', 1);
 360 insert into ttrss_prefs (pref_name,type_id,def_value,section_id) values('_MOBILE_ENABLE_CATS', 1, 'false', 1);
 361 insert into ttrss_prefs (pref_name,type_id,def_value,section_id) values('_MOBILE_SHOW_IMAGES', 1, 'false', 1);
 362 insert into ttrss_prefs (pref_name,type_id,def_value,section_id) values('_MOBILE_HIDE_READ', 1, 'false', 1);
 363 insert into ttrss_prefs (pref_name,type_id,def_value,section_id) values('_MOBILE_SORT_FEEDS_UNREAD', 1, 'false', 1);
 364 insert into ttrss_prefs (pref_name,type_id,def_value,section_id) values('_THEME_ID', 2, '0', 1);
 365 insert into ttrss_prefs (pref_name,type_id,def_value,section_id) values('USER_TIMEZONE', 2, 'Automatic', 1);
 366 insert into ttrss_prefs (pref_name,type_id,def_value,section_id) values('USER_STYLESHEET', 2, '', 2);
 367 insert into ttrss_prefs (pref_name,type_id,def_value,section_id) values('SORT_HEADLINES_BY_FEED_DATE', 1, 'false', 2);
 368 insert into ttrss_prefs (pref_name,type_id,def_value,section_id) values('_MOBILE_BROWSE_CATS', 1, 'true', 1);
 369 insert into ttrss_prefs (pref_name,type_id,def_value,section_id) values('SSL_CERT_SERIAL', 2, '', 3);
 370 insert into ttrss_prefs (pref_name,type_id,def_value,section_id) values('DIGEST_PREFERRED_TIME', 2, '00:00', 4);
 371 insert into ttrss_prefs (pref_name,type_id,def_value,section_id) values('_PREFS_SHOW_EMPTY_CATS', 1, 'false', 1);
 372 insert into ttrss_prefs (pref_name,type_id,def_value,section_id) values('_DEFAULT_INCLUDE_CHILDREN', 1, 'false', 1);
 373 insert into ttrss_prefs (pref_name,type_id,def_value,section_id) values('AUTO_ASSIGN_LABELS', 1, 'false', 3);
 374 insert into ttrss_prefs (pref_name,type_id,def_value,section_id) values('_ENABLED_PLUGINS', 2, '', 1);
 375 insert into ttrss_prefs (pref_name,type_id,def_value,section_id) values('_MOBILE_REVERSE_HEADLINES', 1, 'false', 1);
 376 insert into ttrss_prefs (pref_name,type_id,def_value,section_id) values('USER_CSS_THEME', 2, '', 2);
 377 insert into ttrss_prefs (pref_name,type_id,def_value,section_id) values('USER_LANGUAGE', 2, '', 2);
 378
 379 update ttrss_prefs set access_level = 1 where pref_name in ('ON_CATCHUP_SHOW_NEXT_FEED',
 380         'SORT_HEADLINES_BY_FEED_DATE',
 381         'VFEED_GROUP_BY_FEED',
 382         'FRESH_ARTICLE_MAX_AGE',
 383         'CDM_EXPANDED',
 384         'SHOW_CONTENT_PREVIEW',
 385         'AUTO_ASSIGN_LABELS',
 386         'HIDE_READ_SHOWS_SPECIAL');
 387
 388 create table ttrss_user_prefs (
 389    owner_uid integer not null,
 390    pref_name varchar(250),
 391    value longtext not null,
 392         profile integer,
 393         index (profile),
 394         foreign key (profile) references ttrss_settings_profiles(id) ON DELETE CASCADE,
 395         foreign key (owner_uid) references ttrss_users(id) ON DELETE CASCADE,
 396         foreign key (pref_name) references ttrss_prefs(pref_name) ON DELETE CASCADE) ENGINE=InnoDB DEFAULT CHARSET=UTF8;
 397
 398 create table ttrss_sessions (id varchar(250) not null primary key,
 399         data text,
 400         expire integer not null,
 401         index (expire)) ENGINE=InnoDB DEFAULT CHARSET=UTF8;
 402
 403 create table ttrss_feedbrowser_cache (
 404         feed_url text not null,
 405         site_url text not null,
 406         title text not null,
 407         subscribers integer not null) ENGINE=InnoDB DEFAULT CHARSET=UTF8;
 408
 409 create table ttrss_labels2 (id integer not null primary key auto_increment,
 410         owner_uid integer not null,
 411         caption varchar(250) not null,
 412         fg_color varchar(15) not null default '',
 413         bg_color varchar(15) not null default '',
 414         foreign key (owner_uid) references ttrss_users(id) ON DELETE CASCADE
 415 ) ENGINE=InnoDB DEFAULT CHARSET=UTF8;
 416
 417 create table ttrss_user_labels2 (label_id integer not null,
 418         article_id integer not null,
 419         foreign key (label_id) references ttrss_labels2(id) ON DELETE CASCADE,
 420         foreign key (article_id) references ttrss_entries(id) ON DELETE CASCADE
 421 ) ENGINE=InnoDB DEFAULT CHARSET=UTF8;
 422
 423 create table ttrss_access_keys (id integer not null primary key auto_increment,
 424         access_key varchar(250) not null,
 425         feed_id varchar(250) not null,
 426         is_cat bool not null default false,
 427         owner_uid integer not null,
 428         foreign key (owner_uid) references ttrss_users(id) ON DELETE CASCADE) ENGINE=InnoDB DEFAULT CHARSET=UTF8;
 429
 430 create table ttrss_linked_instances (id integer not null primary key auto_increment,
 431         last_connected datetime not null,
 432         last_status_in integer not null,
 433         last_status_out integer not null,
 434         access_key varchar(250) not null unique,
 435         access_url text not null) ENGINE=InnoDB DEFAULT CHARSET=UTF8;
 436
 437 create table ttrss_linked_feeds (
 438         feed_url text not null,
 439         site_url text not null,
 440         title text not null,
 441         created datetime not null,
 442         updated datetime not null,
 443         instance_id integer not null,
 444         subscribers integer not null,
 445         foreign key (instance_id) references ttrss_linked_instances(id) ON DELETE CASCADE) ENGINE=InnoDB DEFAULT CHARSET=UTF8;
 446
 447 create table ttrss_plugin_storage (
 448         id integer not null auto_increment primary key,
 449         name varchar(100) not null,
 450         owner_uid integer not null,
 451         content longtext not null,
 452         foreign key (owner_uid) references ttrss_users(id) ON DELETE CASCADE) ENGINE=InnoDB DEFAULT CHARSET=UTF8;
 453
 454 create table ttrss_error_log(
 455         id integer not null auto_increment primary key,
 456         owner_uid integer,
 457         errno integer not null,
 458         errstr text not null,
 459         filename text not null,
 460         lineno integer not null,
 461         context text not null,
 462         created_at datetime not null,
 463         foreign key (owner_uid) references ttrss_users(id) ON DELETE SET NULL) ENGINE=InnoDB DEFAULT CHARSET=UTF8;
 464
 465 commit;