123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548154915501551155215531554155515561557155815591560156115621563156415651566156715681569157015711572157315741575157615771578157915801581158215831584158515861587158815891590159115921593159415951596159715981599160016011602160316041605160616071608160916101611161216131614161516161617161816191620162116221623162416251626162716281629163016311632163316341635163616371638163916401641164216431644164516461647164816491650165116521653165416551656165716581659166016611662166316641665166616671668166916701671167216731674167516761677167816791680168116821683168416851686168716881689169016911692169316941695169616971698169917001701170217031704170517061707170817091710171117121713171417151716171717181719172017211722172317241725172617271728172917301731173217331734173517361737173817391740174117421743174417451746174717481749175017511752175317541755175617571758175917601761176217631764176517661767176817691770177117721773177417751776177717781779178017811782178317841785178617871788178917901791179217931794179517961797179817991800180118021803180418051806180718081809181018111812181318141815181618171818181918201821182218231824182518261827182818291830183118321833183418351836183718381839184018411842184318441845184618471848184918501851185218531854185518561857185818591860186118621863186418651866186718681869187018711872187318741875187618771878187918801881188218831884188518861887188818891890189118921893189418951896189718981899190019011902190319041905190619071908190919101911191219131914191519161917191819191920192119221923192419251926192719281929193019311932193319341935193619371938193919401941194219431944194519461947194819491950195119521953195419551956195719581959196019611962196319641965196619671968196919701971197219731974197519761977197819791980198119821983198419851986198719881989199019911992199319941995199619971998199920002001200220032004200520062007200820092010201120122013201420152016201720182019202020212022202320242025202620272028202920302031203220332034203520362037203820392040204120422043204420452046204720482049205020512052205320542055205620572058205920602061206220632064206520662067206820692070207120722073207420752076207720782079208020812082208320842085208620872088208920902091209220932094209520962097209820992100210121022103210421052106210721082109211021112112211321142115211621172118211921202121212221232124212521262127212821292130213121322133213421352136213721382139214021412142214321442145214621472148214921502151215221532154215521562157215821592160216121622163216421652166216721682169217021712172217321742175217621772178217921802181218221832184218521862187218821892190219121922193219421952196219721982199 |
- --
- -- PostgreSQL database dump
- --
- -- Dumped from database version 10.4 (Debian 10.4-2.pgdg90+1)
- -- Dumped by pg_dump version 10.4 (Debian 10.4-2.pgdg90+1)
- SET statement_timeout = 0;
- SET lock_timeout = 0;
- SET idle_in_transaction_session_timeout = 0;
- SET client_encoding = 'UTF8';
- SET standard_conforming_strings = on;
- SELECT pg_catalog.set_config('search_path', '', false);
- SET check_function_bodies = false;
- SET client_min_messages = warning;
- SET row_security = off;
- --
- -- Name: plpgsql; Type: EXTENSION; Schema: -; Owner:
- --
- CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;
- --
- -- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner:
- --
- COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';
- --
- -- Name: substring_for_date(timestamp without time zone, integer, integer); Type: FUNCTION; Schema: public; Owner: ttrss
- --
- CREATE FUNCTION public.substring_for_date(timestamp without time zone, integer, integer) RETURNS text
- LANGUAGE sql
- AS $_$SELECT SUBSTRING(CAST($1 AS text), $2, $3)$_$;
- ALTER FUNCTION public.substring_for_date(timestamp without time zone, integer, integer) OWNER TO ttrss;
- SET default_tablespace = '';
- SET default_with_oids = false;
- --
- -- Name: ttrss_access_keys; Type: TABLE; Schema: public; Owner: ttrss
- --
- CREATE TABLE public.ttrss_access_keys (
- id integer NOT NULL,
- access_key character varying(250) NOT NULL,
- feed_id character varying(250) NOT NULL,
- is_cat boolean DEFAULT false NOT NULL,
- owner_uid integer NOT NULL
- );
- ALTER TABLE public.ttrss_access_keys OWNER TO ttrss;
- --
- -- Name: ttrss_access_keys_id_seq; Type: SEQUENCE; Schema: public; Owner: ttrss
- --
- CREATE SEQUENCE public.ttrss_access_keys_id_seq
- AS integer
- START WITH 1
- INCREMENT BY 1
- NO MINVALUE
- NO MAXVALUE
- CACHE 1;
- ALTER TABLE public.ttrss_access_keys_id_seq OWNER TO ttrss;
- --
- -- Name: ttrss_access_keys_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ttrss
- --
- ALTER SEQUENCE public.ttrss_access_keys_id_seq OWNED BY public.ttrss_access_keys.id;
- --
- -- Name: ttrss_archived_feeds; Type: TABLE; Schema: public; Owner: ttrss
- --
- CREATE TABLE public.ttrss_archived_feeds (
- id integer NOT NULL,
- owner_uid integer NOT NULL,
- title character varying(200) NOT NULL,
- feed_url text NOT NULL,
- site_url character varying(250) DEFAULT ''::character varying NOT NULL
- );
- ALTER TABLE public.ttrss_archived_feeds OWNER TO ttrss;
- --
- -- Name: ttrss_cat_counters_cache; Type: TABLE; Schema: public; Owner: ttrss
- --
- CREATE TABLE public.ttrss_cat_counters_cache (
- feed_id integer NOT NULL,
- owner_uid integer NOT NULL,
- updated timestamp without time zone NOT NULL,
- value integer DEFAULT 0 NOT NULL
- );
- ALTER TABLE public.ttrss_cat_counters_cache OWNER TO ttrss;
- --
- -- Name: ttrss_counters_cache; Type: TABLE; Schema: public; Owner: ttrss
- --
- CREATE TABLE public.ttrss_counters_cache (
- feed_id integer NOT NULL,
- owner_uid integer NOT NULL,
- updated timestamp without time zone NOT NULL,
- value integer DEFAULT 0 NOT NULL
- );
- ALTER TABLE public.ttrss_counters_cache OWNER TO ttrss;
- --
- -- Name: ttrss_enclosures; Type: TABLE; Schema: public; Owner: ttrss
- --
- CREATE TABLE public.ttrss_enclosures (
- id integer NOT NULL,
- content_url text NOT NULL,
- content_type character varying(250) NOT NULL,
- title text NOT NULL,
- duration text NOT NULL,
- width integer DEFAULT 0 NOT NULL,
- height integer DEFAULT 0 NOT NULL,
- post_id integer NOT NULL
- );
- ALTER TABLE public.ttrss_enclosures OWNER TO ttrss;
- --
- -- Name: ttrss_enclosures_id_seq; Type: SEQUENCE; Schema: public; Owner: ttrss
- --
- CREATE SEQUENCE public.ttrss_enclosures_id_seq
- AS integer
- START WITH 1
- INCREMENT BY 1
- NO MINVALUE
- NO MAXVALUE
- CACHE 1;
- ALTER TABLE public.ttrss_enclosures_id_seq OWNER TO ttrss;
- --
- -- Name: ttrss_enclosures_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ttrss
- --
- ALTER SEQUENCE public.ttrss_enclosures_id_seq OWNED BY public.ttrss_enclosures.id;
- --
- -- Name: ttrss_entries; Type: TABLE; Schema: public; Owner: ttrss
- --
- CREATE TABLE public.ttrss_entries (
- id integer NOT NULL,
- title text NOT NULL,
- guid text NOT NULL,
- link text NOT NULL,
- updated timestamp without time zone NOT NULL,
- content text NOT NULL,
- content_hash character varying(250) NOT NULL,
- cached_content text,
- no_orig_date boolean DEFAULT false NOT NULL,
- date_entered timestamp without time zone NOT NULL,
- date_updated timestamp without time zone NOT NULL,
- num_comments integer DEFAULT 0 NOT NULL,
- comments character varying(250) DEFAULT ''::character varying NOT NULL,
- plugin_data text,
- tsvector_combined tsvector,
- lang character varying(2),
- author character varying(250) DEFAULT ''::character varying NOT NULL
- );
- ALTER TABLE public.ttrss_entries OWNER TO ttrss;
- --
- -- Name: ttrss_entries_id_seq; Type: SEQUENCE; Schema: public; Owner: ttrss
- --
- CREATE SEQUENCE public.ttrss_entries_id_seq
- AS integer
- START WITH 1
- INCREMENT BY 1
- NO MINVALUE
- NO MAXVALUE
- CACHE 1;
- ALTER TABLE public.ttrss_entries_id_seq OWNER TO ttrss;
- --
- -- Name: ttrss_entries_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ttrss
- --
- ALTER SEQUENCE public.ttrss_entries_id_seq OWNED BY public.ttrss_entries.id;
- --
- -- Name: ttrss_entry_comments; Type: TABLE; Schema: public; Owner: ttrss
- --
- CREATE TABLE public.ttrss_entry_comments (
- id integer NOT NULL,
- ref_id integer NOT NULL,
- owner_uid integer NOT NULL,
- private boolean DEFAULT false NOT NULL,
- date_entered timestamp without time zone NOT NULL
- );
- ALTER TABLE public.ttrss_entry_comments OWNER TO ttrss;
- --
- -- Name: ttrss_entry_comments_id_seq; Type: SEQUENCE; Schema: public; Owner: ttrss
- --
- CREATE SEQUENCE public.ttrss_entry_comments_id_seq
- AS integer
- START WITH 1
- INCREMENT BY 1
- NO MINVALUE
- NO MAXVALUE
- CACHE 1;
- ALTER TABLE public.ttrss_entry_comments_id_seq OWNER TO ttrss;
- --
- -- Name: ttrss_entry_comments_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ttrss
- --
- ALTER SEQUENCE public.ttrss_entry_comments_id_seq OWNED BY public.ttrss_entry_comments.id;
- --
- -- Name: ttrss_error_log; Type: TABLE; Schema: public; Owner: ttrss
- --
- CREATE TABLE public.ttrss_error_log (
- id integer NOT NULL,
- owner_uid integer,
- errno integer NOT NULL,
- errstr text NOT NULL,
- filename text NOT NULL,
- lineno integer NOT NULL,
- context text NOT NULL,
- created_at timestamp without time zone NOT NULL
- );
- ALTER TABLE public.ttrss_error_log OWNER TO ttrss;
- --
- -- Name: ttrss_error_log_id_seq; Type: SEQUENCE; Schema: public; Owner: ttrss
- --
- CREATE SEQUENCE public.ttrss_error_log_id_seq
- AS integer
- START WITH 1
- INCREMENT BY 1
- NO MINVALUE
- NO MAXVALUE
- CACHE 1;
- ALTER TABLE public.ttrss_error_log_id_seq OWNER TO ttrss;
- --
- -- Name: ttrss_error_log_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ttrss
- --
- ALTER SEQUENCE public.ttrss_error_log_id_seq OWNED BY public.ttrss_error_log.id;
- --
- -- Name: ttrss_feed_categories; Type: TABLE; Schema: public; Owner: ttrss
- --
- CREATE TABLE public.ttrss_feed_categories (
- id integer NOT NULL,
- owner_uid integer NOT NULL,
- collapsed boolean DEFAULT false NOT NULL,
- order_id integer DEFAULT 0 NOT NULL,
- view_settings character varying(250) DEFAULT ''::character varying NOT NULL,
- parent_cat integer,
- title character varying(200) NOT NULL
- );
- ALTER TABLE public.ttrss_feed_categories OWNER TO ttrss;
- --
- -- Name: ttrss_feed_categories_id_seq; Type: SEQUENCE; Schema: public; Owner: ttrss
- --
- CREATE SEQUENCE public.ttrss_feed_categories_id_seq
- AS integer
- START WITH 1
- INCREMENT BY 1
- NO MINVALUE
- NO MAXVALUE
- CACHE 1;
- ALTER TABLE public.ttrss_feed_categories_id_seq OWNER TO ttrss;
- --
- -- Name: ttrss_feed_categories_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ttrss
- --
- ALTER SEQUENCE public.ttrss_feed_categories_id_seq OWNED BY public.ttrss_feed_categories.id;
- --
- -- Name: ttrss_feedbrowser_cache; Type: TABLE; Schema: public; Owner: ttrss
- --
- CREATE TABLE public.ttrss_feedbrowser_cache (
- feed_url text NOT NULL,
- title text NOT NULL,
- site_url text NOT NULL,
- subscribers integer NOT NULL
- );
- ALTER TABLE public.ttrss_feedbrowser_cache OWNER TO ttrss;
- --
- -- Name: ttrss_feeds; Type: TABLE; Schema: public; Owner: ttrss
- --
- CREATE TABLE public.ttrss_feeds (
- id integer NOT NULL,
- owner_uid integer NOT NULL,
- title character varying(200) NOT NULL,
- cat_id integer,
- feed_url text NOT NULL,
- icon_url character varying(250) DEFAULT ''::character varying NOT NULL,
- update_interval integer DEFAULT 0 NOT NULL,
- purge_interval integer DEFAULT 0 NOT NULL,
- last_updated timestamp without time zone,
- last_unconditional timestamp without time zone,
- last_error text DEFAULT ''::text NOT NULL,
- last_modified text DEFAULT ''::text NOT NULL,
- favicon_avg_color character varying(11) DEFAULT NULL::character varying,
- site_url character varying(250) DEFAULT ''::character varying NOT NULL,
- auth_login character varying(250) DEFAULT ''::character varying NOT NULL,
- parent_feed integer,
- private boolean DEFAULT false NOT NULL,
- auth_pass character varying(250) DEFAULT ''::character varying NOT NULL,
- hidden boolean DEFAULT false NOT NULL,
- include_in_digest boolean DEFAULT true NOT NULL,
- rtl_content boolean DEFAULT false NOT NULL,
- cache_images boolean DEFAULT false NOT NULL,
- hide_images boolean DEFAULT false NOT NULL,
- cache_content boolean DEFAULT false NOT NULL,
- last_viewed timestamp without time zone,
- last_update_started timestamp without time zone,
- update_method integer DEFAULT 0 NOT NULL,
- always_display_enclosures boolean DEFAULT false NOT NULL,
- order_id integer DEFAULT 0 NOT NULL,
- mark_unread_on_update boolean DEFAULT false NOT NULL,
- update_on_checksum_change boolean DEFAULT false NOT NULL,
- strip_images boolean DEFAULT false NOT NULL,
- view_settings character varying(250) DEFAULT ''::character varying NOT NULL,
- pubsub_state integer DEFAULT 0 NOT NULL,
- favicon_last_checked timestamp without time zone,
- feed_language character varying(100) DEFAULT ''::character varying NOT NULL,
- auth_pass_encrypted boolean DEFAULT false NOT NULL
- );
- ALTER TABLE public.ttrss_feeds OWNER TO ttrss;
- --
- -- Name: ttrss_feeds_id_seq; Type: SEQUENCE; Schema: public; Owner: ttrss
- --
- CREATE SEQUENCE public.ttrss_feeds_id_seq
- AS integer
- START WITH 1
- INCREMENT BY 1
- NO MINVALUE
- NO MAXVALUE
- CACHE 1;
- ALTER TABLE public.ttrss_feeds_id_seq OWNER TO ttrss;
- --
- -- Name: ttrss_feeds_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ttrss
- --
- ALTER SEQUENCE public.ttrss_feeds_id_seq OWNED BY public.ttrss_feeds.id;
- --
- -- Name: ttrss_filter_actions; Type: TABLE; Schema: public; Owner: ttrss
- --
- CREATE TABLE public.ttrss_filter_actions (
- id integer NOT NULL,
- name character varying(120) NOT NULL,
- description character varying(250) NOT NULL
- );
- ALTER TABLE public.ttrss_filter_actions OWNER TO ttrss;
- --
- -- Name: ttrss_filter_types; Type: TABLE; Schema: public; Owner: ttrss
- --
- CREATE TABLE public.ttrss_filter_types (
- id integer NOT NULL,
- name character varying(120) NOT NULL,
- description character varying(250) NOT NULL
- );
- ALTER TABLE public.ttrss_filter_types OWNER TO ttrss;
- --
- -- Name: ttrss_filters2; Type: TABLE; Schema: public; Owner: ttrss
- --
- CREATE TABLE public.ttrss_filters2 (
- id integer NOT NULL,
- owner_uid integer NOT NULL,
- match_any_rule boolean DEFAULT false NOT NULL,
- inverse boolean DEFAULT false NOT NULL,
- title character varying(250) DEFAULT ''::character varying NOT NULL,
- order_id integer DEFAULT 0 NOT NULL,
- enabled boolean DEFAULT true NOT NULL
- );
- ALTER TABLE public.ttrss_filters2 OWNER TO ttrss;
- --
- -- Name: ttrss_filters2_actions; Type: TABLE; Schema: public; Owner: ttrss
- --
- CREATE TABLE public.ttrss_filters2_actions (
- id integer NOT NULL,
- filter_id integer NOT NULL,
- action_id integer DEFAULT 1 NOT NULL,
- action_param character varying(250) DEFAULT ''::character varying NOT NULL
- );
- ALTER TABLE public.ttrss_filters2_actions OWNER TO ttrss;
- --
- -- Name: ttrss_filters2_actions_id_seq; Type: SEQUENCE; Schema: public; Owner: ttrss
- --
- CREATE SEQUENCE public.ttrss_filters2_actions_id_seq
- AS integer
- START WITH 1
- INCREMENT BY 1
- NO MINVALUE
- NO MAXVALUE
- CACHE 1;
- ALTER TABLE public.ttrss_filters2_actions_id_seq OWNER TO ttrss;
- --
- -- Name: ttrss_filters2_actions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ttrss
- --
- ALTER SEQUENCE public.ttrss_filters2_actions_id_seq OWNED BY public.ttrss_filters2_actions.id;
- --
- -- Name: ttrss_filters2_id_seq; Type: SEQUENCE; Schema: public; Owner: ttrss
- --
- CREATE SEQUENCE public.ttrss_filters2_id_seq
- AS integer
- START WITH 1
- INCREMENT BY 1
- NO MINVALUE
- NO MAXVALUE
- CACHE 1;
- ALTER TABLE public.ttrss_filters2_id_seq OWNER TO ttrss;
- --
- -- Name: ttrss_filters2_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ttrss
- --
- ALTER SEQUENCE public.ttrss_filters2_id_seq OWNED BY public.ttrss_filters2.id;
- --
- -- Name: ttrss_filters2_rules; Type: TABLE; Schema: public; Owner: ttrss
- --
- CREATE TABLE public.ttrss_filters2_rules (
- id integer NOT NULL,
- filter_id integer NOT NULL,
- reg_exp text NOT NULL,
- inverse boolean DEFAULT false NOT NULL,
- filter_type integer NOT NULL,
- feed_id integer,
- cat_id integer,
- match_on text,
- cat_filter boolean DEFAULT false NOT NULL
- );
- ALTER TABLE public.ttrss_filters2_rules OWNER TO ttrss;
- --
- -- Name: ttrss_filters2_rules_id_seq; Type: SEQUENCE; Schema: public; Owner: ttrss
- --
- CREATE SEQUENCE public.ttrss_filters2_rules_id_seq
- AS integer
- START WITH 1
- INCREMENT BY 1
- NO MINVALUE
- NO MAXVALUE
- CACHE 1;
- ALTER TABLE public.ttrss_filters2_rules_id_seq OWNER TO ttrss;
- --
- -- Name: ttrss_filters2_rules_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ttrss
- --
- ALTER SEQUENCE public.ttrss_filters2_rules_id_seq OWNED BY public.ttrss_filters2_rules.id;
- --
- -- Name: ttrss_labels2; Type: TABLE; Schema: public; Owner: ttrss
- --
- CREATE TABLE public.ttrss_labels2 (
- id integer NOT NULL,
- owner_uid integer NOT NULL,
- fg_color character varying(15) DEFAULT ''::character varying NOT NULL,
- bg_color character varying(15) DEFAULT ''::character varying NOT NULL,
- caption character varying(250) NOT NULL
- );
- ALTER TABLE public.ttrss_labels2 OWNER TO ttrss;
- --
- -- Name: ttrss_labels2_id_seq; Type: SEQUENCE; Schema: public; Owner: ttrss
- --
- CREATE SEQUENCE public.ttrss_labels2_id_seq
- AS integer
- START WITH 1
- INCREMENT BY 1
- NO MINVALUE
- NO MAXVALUE
- CACHE 1;
- ALTER TABLE public.ttrss_labels2_id_seq OWNER TO ttrss;
- --
- -- Name: ttrss_labels2_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ttrss
- --
- ALTER SEQUENCE public.ttrss_labels2_id_seq OWNED BY public.ttrss_labels2.id;
- --
- -- Name: ttrss_linked_feeds; Type: TABLE; Schema: public; Owner: ttrss
- --
- CREATE TABLE public.ttrss_linked_feeds (
- feed_url text NOT NULL,
- site_url text NOT NULL,
- title text NOT NULL,
- created timestamp without time zone NOT NULL,
- updated timestamp without time zone NOT NULL,
- instance_id integer NOT NULL,
- subscribers integer NOT NULL
- );
- ALTER TABLE public.ttrss_linked_feeds OWNER TO ttrss;
- --
- -- Name: ttrss_linked_instances; Type: TABLE; Schema: public; Owner: ttrss
- --
- CREATE TABLE public.ttrss_linked_instances (
- id integer NOT NULL,
- last_connected timestamp without time zone NOT NULL,
- last_status_in integer NOT NULL,
- last_status_out integer NOT NULL,
- access_key character varying(250) NOT NULL,
- access_url text NOT NULL
- );
- ALTER TABLE public.ttrss_linked_instances OWNER TO ttrss;
- --
- -- Name: ttrss_linked_instances_id_seq; Type: SEQUENCE; Schema: public; Owner: ttrss
- --
- CREATE SEQUENCE public.ttrss_linked_instances_id_seq
- AS integer
- START WITH 1
- INCREMENT BY 1
- NO MINVALUE
- NO MAXVALUE
- CACHE 1;
- ALTER TABLE public.ttrss_linked_instances_id_seq OWNER TO ttrss;
- --
- -- Name: ttrss_linked_instances_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ttrss
- --
- ALTER SEQUENCE public.ttrss_linked_instances_id_seq OWNED BY public.ttrss_linked_instances.id;
- --
- -- Name: ttrss_plugin_storage; Type: TABLE; Schema: public; Owner: ttrss
- --
- CREATE TABLE public.ttrss_plugin_storage (
- id integer NOT NULL,
- name character varying(100) NOT NULL,
- owner_uid integer NOT NULL,
- content text NOT NULL
- );
- ALTER TABLE public.ttrss_plugin_storage OWNER TO ttrss;
- --
- -- Name: ttrss_plugin_storage_id_seq; Type: SEQUENCE; Schema: public; Owner: ttrss
- --
- CREATE SEQUENCE public.ttrss_plugin_storage_id_seq
- AS integer
- START WITH 1
- INCREMENT BY 1
- NO MINVALUE
- NO MAXVALUE
- CACHE 1;
- ALTER TABLE public.ttrss_plugin_storage_id_seq OWNER TO ttrss;
- --
- -- Name: ttrss_plugin_storage_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ttrss
- --
- ALTER SEQUENCE public.ttrss_plugin_storage_id_seq OWNED BY public.ttrss_plugin_storage.id;
- --
- -- Name: ttrss_prefs; Type: TABLE; Schema: public; Owner: ttrss
- --
- CREATE TABLE public.ttrss_prefs (
- pref_name character varying(250) NOT NULL,
- type_id integer NOT NULL,
- section_id integer DEFAULT 1 NOT NULL,
- access_level integer DEFAULT 0 NOT NULL,
- def_value text NOT NULL
- );
- ALTER TABLE public.ttrss_prefs OWNER TO ttrss;
- --
- -- Name: ttrss_prefs_sections; Type: TABLE; Schema: public; Owner: ttrss
- --
- CREATE TABLE public.ttrss_prefs_sections (
- id integer NOT NULL,
- order_id integer NOT NULL,
- section_name character varying(100) NOT NULL
- );
- ALTER TABLE public.ttrss_prefs_sections OWNER TO ttrss;
- --
- -- Name: ttrss_prefs_types; Type: TABLE; Schema: public; Owner: ttrss
- --
- CREATE TABLE public.ttrss_prefs_types (
- id integer NOT NULL,
- type_name character varying(100) NOT NULL
- );
- ALTER TABLE public.ttrss_prefs_types OWNER TO ttrss;
- --
- -- Name: ttrss_sessions; Type: TABLE; Schema: public; Owner: ttrss
- --
- CREATE TABLE public.ttrss_sessions (
- id character varying(250) NOT NULL,
- data text,
- expire integer NOT NULL
- );
- ALTER TABLE public.ttrss_sessions OWNER TO ttrss;
- --
- -- Name: ttrss_settings_profiles; Type: TABLE; Schema: public; Owner: ttrss
- --
- CREATE TABLE public.ttrss_settings_profiles (
- id integer NOT NULL,
- title character varying(250) NOT NULL,
- owner_uid integer NOT NULL
- );
- ALTER TABLE public.ttrss_settings_profiles OWNER TO ttrss;
- --
- -- Name: ttrss_settings_profiles_id_seq; Type: SEQUENCE; Schema: public; Owner: ttrss
- --
- CREATE SEQUENCE public.ttrss_settings_profiles_id_seq
- AS integer
- START WITH 1
- INCREMENT BY 1
- NO MINVALUE
- NO MAXVALUE
- CACHE 1;
- ALTER TABLE public.ttrss_settings_profiles_id_seq OWNER TO ttrss;
- --
- -- Name: ttrss_settings_profiles_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ttrss
- --
- ALTER SEQUENCE public.ttrss_settings_profiles_id_seq OWNED BY public.ttrss_settings_profiles.id;
- --
- -- Name: ttrss_tags; Type: TABLE; Schema: public; Owner: ttrss
- --
- CREATE TABLE public.ttrss_tags (
- id integer NOT NULL,
- tag_name character varying(250) NOT NULL,
- owner_uid integer NOT NULL,
- post_int_id integer NOT NULL
- );
- ALTER TABLE public.ttrss_tags OWNER TO ttrss;
- --
- -- Name: ttrss_tags_id_seq; Type: SEQUENCE; Schema: public; Owner: ttrss
- --
- CREATE SEQUENCE public.ttrss_tags_id_seq
- AS integer
- START WITH 1
- INCREMENT BY 1
- NO MINVALUE
- NO MAXVALUE
- CACHE 1;
- ALTER TABLE public.ttrss_tags_id_seq OWNER TO ttrss;
- --
- -- Name: ttrss_tags_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ttrss
- --
- ALTER SEQUENCE public.ttrss_tags_id_seq OWNED BY public.ttrss_tags.id;
- --
- -- Name: ttrss_user_entries; Type: TABLE; Schema: public; Owner: ttrss
- --
- CREATE TABLE public.ttrss_user_entries (
- int_id integer NOT NULL,
- ref_id integer NOT NULL,
- uuid character varying(200) NOT NULL,
- feed_id integer,
- orig_feed_id integer,
- owner_uid integer NOT NULL,
- marked boolean DEFAULT false NOT NULL,
- published boolean DEFAULT false NOT NULL,
- tag_cache text NOT NULL,
- label_cache text NOT NULL,
- last_read timestamp without time zone,
- score integer DEFAULT 0 NOT NULL,
- last_marked timestamp without time zone,
- last_published timestamp without time zone,
- note text,
- unread boolean DEFAULT true NOT NULL
- );
- ALTER TABLE public.ttrss_user_entries OWNER TO ttrss;
- --
- -- Name: ttrss_user_entries_int_id_seq; Type: SEQUENCE; Schema: public; Owner: ttrss
- --
- CREATE SEQUENCE public.ttrss_user_entries_int_id_seq
- AS integer
- START WITH 1
- INCREMENT BY 1
- NO MINVALUE
- NO MAXVALUE
- CACHE 1;
- ALTER TABLE public.ttrss_user_entries_int_id_seq OWNER TO ttrss;
- --
- -- Name: ttrss_user_entries_int_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ttrss
- --
- ALTER SEQUENCE public.ttrss_user_entries_int_id_seq OWNED BY public.ttrss_user_entries.int_id;
- --
- -- Name: ttrss_user_labels2; Type: TABLE; Schema: public; Owner: ttrss
- --
- CREATE TABLE public.ttrss_user_labels2 (
- label_id integer NOT NULL,
- article_id integer NOT NULL
- );
- ALTER TABLE public.ttrss_user_labels2 OWNER TO ttrss;
- --
- -- Name: ttrss_user_prefs; Type: TABLE; Schema: public; Owner: ttrss
- --
- CREATE TABLE public.ttrss_user_prefs (
- owner_uid integer NOT NULL,
- pref_name character varying(250) NOT NULL,
- profile integer,
- value text NOT NULL
- );
- ALTER TABLE public.ttrss_user_prefs OWNER TO ttrss;
- --
- -- Name: ttrss_users; Type: TABLE; Schema: public; Owner: ttrss
- --
- CREATE TABLE public.ttrss_users (
- id integer NOT NULL,
- login character varying(120) NOT NULL,
- pwd_hash character varying(250) NOT NULL,
- last_login timestamp without time zone,
- access_level integer DEFAULT 0 NOT NULL,
- email character varying(250) DEFAULT ''::character varying NOT NULL,
- full_name character varying(250) DEFAULT ''::character varying NOT NULL,
- email_digest boolean DEFAULT false NOT NULL,
- last_digest_sent timestamp without time zone,
- salt character varying(250) DEFAULT ''::character varying NOT NULL,
- twitter_oauth text,
- otp_enabled boolean DEFAULT false NOT NULL,
- resetpass_token character varying(250) DEFAULT NULL::character varying,
- created timestamp without time zone
- );
- ALTER TABLE public.ttrss_users OWNER TO ttrss;
- --
- -- Name: ttrss_users_id_seq; Type: SEQUENCE; Schema: public; Owner: ttrss
- --
- CREATE SEQUENCE public.ttrss_users_id_seq
- AS integer
- START WITH 1
- INCREMENT BY 1
- NO MINVALUE
- NO MAXVALUE
- CACHE 1;
- ALTER TABLE public.ttrss_users_id_seq OWNER TO ttrss;
- --
- -- Name: ttrss_users_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ttrss
- --
- ALTER SEQUENCE public.ttrss_users_id_seq OWNED BY public.ttrss_users.id;
- --
- -- Name: ttrss_version; Type: TABLE; Schema: public; Owner: ttrss
- --
- CREATE TABLE public.ttrss_version (
- schema_version integer NOT NULL
- );
- ALTER TABLE public.ttrss_version OWNER TO ttrss;
- --
- -- Name: ttrss_access_keys id; Type: DEFAULT; Schema: public; Owner: ttrss
- --
- ALTER TABLE ONLY public.ttrss_access_keys ALTER COLUMN id SET DEFAULT nextval('public.ttrss_access_keys_id_seq'::regclass);
- --
- -- Name: ttrss_enclosures id; Type: DEFAULT; Schema: public; Owner: ttrss
- --
- ALTER TABLE ONLY public.ttrss_enclosures ALTER COLUMN id SET DEFAULT nextval('public.ttrss_enclosures_id_seq'::regclass);
- --
- -- Name: ttrss_entries id; Type: DEFAULT; Schema: public; Owner: ttrss
- --
- ALTER TABLE ONLY public.ttrss_entries ALTER COLUMN id SET DEFAULT nextval('public.ttrss_entries_id_seq'::regclass);
- --
- -- Name: ttrss_entry_comments id; Type: DEFAULT; Schema: public; Owner: ttrss
- --
- ALTER TABLE ONLY public.ttrss_entry_comments ALTER COLUMN id SET DEFAULT nextval('public.ttrss_entry_comments_id_seq'::regclass);
- --
- -- Name: ttrss_error_log id; Type: DEFAULT; Schema: public; Owner: ttrss
- --
- ALTER TABLE ONLY public.ttrss_error_log ALTER COLUMN id SET DEFAULT nextval('public.ttrss_error_log_id_seq'::regclass);
- --
- -- Name: ttrss_feed_categories id; Type: DEFAULT; Schema: public; Owner: ttrss
- --
- ALTER TABLE ONLY public.ttrss_feed_categories ALTER COLUMN id SET DEFAULT nextval('public.ttrss_feed_categories_id_seq'::regclass);
- --
- -- Name: ttrss_feeds id; Type: DEFAULT; Schema: public; Owner: ttrss
- --
- ALTER TABLE ONLY public.ttrss_feeds ALTER COLUMN id SET DEFAULT nextval('public.ttrss_feeds_id_seq'::regclass);
- --
- -- Name: ttrss_filters2 id; Type: DEFAULT; Schema: public; Owner: ttrss
- --
- ALTER TABLE ONLY public.ttrss_filters2 ALTER COLUMN id SET DEFAULT nextval('public.ttrss_filters2_id_seq'::regclass);
- --
- -- Name: ttrss_filters2_actions id; Type: DEFAULT; Schema: public; Owner: ttrss
- --
- ALTER TABLE ONLY public.ttrss_filters2_actions ALTER COLUMN id SET DEFAULT nextval('public.ttrss_filters2_actions_id_seq'::regclass);
- --
- -- Name: ttrss_filters2_rules id; Type: DEFAULT; Schema: public; Owner: ttrss
- --
- ALTER TABLE ONLY public.ttrss_filters2_rules ALTER COLUMN id SET DEFAULT nextval('public.ttrss_filters2_rules_id_seq'::regclass);
- --
- -- Name: ttrss_labels2 id; Type: DEFAULT; Schema: public; Owner: ttrss
- --
- ALTER TABLE ONLY public.ttrss_labels2 ALTER COLUMN id SET DEFAULT nextval('public.ttrss_labels2_id_seq'::regclass);
- --
- -- Name: ttrss_linked_instances id; Type: DEFAULT; Schema: public; Owner: ttrss
- --
- ALTER TABLE ONLY public.ttrss_linked_instances ALTER COLUMN id SET DEFAULT nextval('public.ttrss_linked_instances_id_seq'::regclass);
- --
- -- Name: ttrss_plugin_storage id; Type: DEFAULT; Schema: public; Owner: ttrss
- --
- ALTER TABLE ONLY public.ttrss_plugin_storage ALTER COLUMN id SET DEFAULT nextval('public.ttrss_plugin_storage_id_seq'::regclass);
- --
- -- Name: ttrss_settings_profiles id; Type: DEFAULT; Schema: public; Owner: ttrss
- --
- ALTER TABLE ONLY public.ttrss_settings_profiles ALTER COLUMN id SET DEFAULT nextval('public.ttrss_settings_profiles_id_seq'::regclass);
- --
- -- Name: ttrss_tags id; Type: DEFAULT; Schema: public; Owner: ttrss
- --
- ALTER TABLE ONLY public.ttrss_tags ALTER COLUMN id SET DEFAULT nextval('public.ttrss_tags_id_seq'::regclass);
- --
- -- Name: ttrss_user_entries int_id; Type: DEFAULT; Schema: public; Owner: ttrss
- --
- ALTER TABLE ONLY public.ttrss_user_entries ALTER COLUMN int_id SET DEFAULT nextval('public.ttrss_user_entries_int_id_seq'::regclass);
- --
- -- Name: ttrss_users id; Type: DEFAULT; Schema: public; Owner: ttrss
- --
- ALTER TABLE ONLY public.ttrss_users ALTER COLUMN id SET DEFAULT nextval('public.ttrss_users_id_seq'::regclass);
- --
- -- Data for Name: ttrss_access_keys; Type: TABLE DATA; Schema: public; Owner: ttrss
- --
- COPY public.ttrss_access_keys (id, access_key, feed_id, is_cat, owner_uid) FROM stdin;
- \.
- --
- -- Data for Name: ttrss_archived_feeds; Type: TABLE DATA; Schema: public; Owner: ttrss
- --
- COPY public.ttrss_archived_feeds (id, owner_uid, title, feed_url, site_url) FROM stdin;
- \.
- --
- -- Data for Name: ttrss_cat_counters_cache; Type: TABLE DATA; Schema: public; Owner: ttrss
- --
- COPY public.ttrss_cat_counters_cache (feed_id, owner_uid, updated, value) FROM stdin;
- \.
- --
- -- Data for Name: ttrss_counters_cache; Type: TABLE DATA; Schema: public; Owner: ttrss
- --
- COPY public.ttrss_counters_cache (feed_id, owner_uid, updated, value) FROM stdin;
- \.
- --
- -- Data for Name: ttrss_enclosures; Type: TABLE DATA; Schema: public; Owner: ttrss
- --
- COPY public.ttrss_enclosures (id, content_url, content_type, title, duration, width, height, post_id) FROM stdin;
- \.
- --
- -- Data for Name: ttrss_entries; Type: TABLE DATA; Schema: public; Owner: ttrss
- --
- COPY public.ttrss_entries (id, title, guid, link, updated, content, content_hash, cached_content, no_orig_date, date_entered, date_updated, num_comments, comments, plugin_data, tsvector_combined, lang, author) FROM stdin;
- \.
- --
- -- Data for Name: ttrss_entry_comments; Type: TABLE DATA; Schema: public; Owner: ttrss
- --
- COPY public.ttrss_entry_comments (id, ref_id, owner_uid, private, date_entered) FROM stdin;
- \.
- --
- -- Data for Name: ttrss_error_log; Type: TABLE DATA; Schema: public; Owner: ttrss
- --
- COPY public.ttrss_error_log (id, owner_uid, errno, errstr, filename, lineno, context, created_at) FROM stdin;
- \.
- --
- -- Data for Name: ttrss_feed_categories; Type: TABLE DATA; Schema: public; Owner: ttrss
- --
- COPY public.ttrss_feed_categories (id, owner_uid, collapsed, order_id, view_settings, parent_cat, title) FROM stdin;
- \.
- --
- -- Data for Name: ttrss_feedbrowser_cache; Type: TABLE DATA; Schema: public; Owner: ttrss
- --
- COPY public.ttrss_feedbrowser_cache (feed_url, title, site_url, subscribers) FROM stdin;
- \.
- --
- -- Data for Name: ttrss_feeds; Type: TABLE DATA; Schema: public; Owner: ttrss
- --
- COPY public.ttrss_feeds (id, owner_uid, title, cat_id, feed_url, icon_url, update_interval, purge_interval, last_updated, last_unconditional, last_error, last_modified, favicon_avg_color, site_url, auth_login, parent_feed, private, auth_pass, hidden, include_in_digest, rtl_content, cache_images, hide_images, cache_content, last_viewed, last_update_started, update_method, always_display_enclosures, order_id, mark_unread_on_update, update_on_checksum_change, strip_images, view_settings, pubsub_state, favicon_last_checked, feed_language, auth_pass_encrypted) FROM stdin;
- 1 1 Tiny Tiny RSS: Forum \N http://tt-rss.org/forum/rss.php 0 0 \N \N \N \N f f t f f f f \N \N 0 f 0 f f f 0 \N f
- \.
- --
- -- Data for Name: ttrss_filter_actions; Type: TABLE DATA; Schema: public; Owner: ttrss
- --
- COPY public.ttrss_filter_actions (id, name, description) FROM stdin;
- 1 filter Delete article
- 2 catchup Mark as read
- 3 mark Set starred
- 4 tag Assign tags
- 5 publish Publish article
- 6 score Modify score
- 7 label Assign label
- 8 stop Stop / Do nothing
- 9 plugin Invoke plugin
- \.
- --
- -- Data for Name: ttrss_filter_types; Type: TABLE DATA; Schema: public; Owner: ttrss
- --
- COPY public.ttrss_filter_types (id, name, description) FROM stdin;
- 1 title Title
- 2 content Content
- 3 both Title or Content
- 4 link Link
- 5 date Article Date
- 6 author Author
- 7 tag Article Tags
- \.
- --
- -- Data for Name: ttrss_filters2; Type: TABLE DATA; Schema: public; Owner: ttrss
- --
- COPY public.ttrss_filters2 (id, owner_uid, match_any_rule, inverse, title, order_id, enabled) FROM stdin;
- \.
- --
- -- Data for Name: ttrss_filters2_actions; Type: TABLE DATA; Schema: public; Owner: ttrss
- --
- COPY public.ttrss_filters2_actions (id, filter_id, action_id, action_param) FROM stdin;
- \.
- --
- -- Data for Name: ttrss_filters2_rules; Type: TABLE DATA; Schema: public; Owner: ttrss
- --
- COPY public.ttrss_filters2_rules (id, filter_id, reg_exp, inverse, filter_type, feed_id, cat_id, match_on, cat_filter) FROM stdin;
- \.
- --
- -- Data for Name: ttrss_labels2; Type: TABLE DATA; Schema: public; Owner: ttrss
- --
- COPY public.ttrss_labels2 (id, owner_uid, fg_color, bg_color, caption) FROM stdin;
- \.
- --
- -- Data for Name: ttrss_linked_feeds; Type: TABLE DATA; Schema: public; Owner: ttrss
- --
- COPY public.ttrss_linked_feeds (feed_url, site_url, title, created, updated, instance_id, subscribers) FROM stdin;
- \.
- --
- -- Data for Name: ttrss_linked_instances; Type: TABLE DATA; Schema: public; Owner: ttrss
- --
- COPY public.ttrss_linked_instances (id, last_connected, last_status_in, last_status_out, access_key, access_url) FROM stdin;
- \.
- --
- -- Data for Name: ttrss_plugin_storage; Type: TABLE DATA; Schema: public; Owner: ttrss
- --
- COPY public.ttrss_plugin_storage (id, name, owner_uid, content) FROM stdin;
- \.
- --
- -- Data for Name: ttrss_prefs; Type: TABLE DATA; Schema: public; Owner: ttrss
- --
- COPY public.ttrss_prefs (pref_name, type_id, section_id, access_level, def_value) FROM stdin;
- PURGE_OLD_DAYS 3 1 0 60
- DEFAULT_UPDATE_INTERVAL 3 1 0 30
- DEFAULT_ARTICLE_LIMIT 3 2 0 30
- ALLOW_DUPLICATE_POSTS 1 1 0 false
- ENABLE_FEED_CATS 1 2 0 true
- SHORT_DATE_FORMAT 2 3 0 M d, G:i
- LONG_DATE_FORMAT 2 3 0 D, M d Y - G:i
- COMBINED_DISPLAY_MODE 1 2 0 true
- HIDE_READ_FEEDS 1 2 0 false
- FEEDS_SORT_BY_UNREAD 1 2 0 false
- REVERSE_HEADLINES 1 2 0 false
- DIGEST_ENABLE 1 4 0 false
- CONFIRM_FEED_CATCHUP 1 2 0 true
- CDM_AUTO_CATCHUP 1 2 0 false
- _DEFAULT_VIEW_MODE 2 1 0 adaptive
- _DEFAULT_VIEW_LIMIT 3 1 0 30
- _PREFS_ACTIVE_TAB 2 1 0
- STRIP_UNSAFE_TAGS 1 3 0 true
- BLACKLISTED_TAGS 2 3 0 main, generic, misc, uncategorized, blog, blogroll, general, news
- DIGEST_CATCHUP 1 4 0 false
- PURGE_UNREAD_ARTICLES 1 3 0 true
- STRIP_IMAGES 1 2 0 false
- _DEFAULT_VIEW_ORDER_BY 2 1 0 default
- ENABLE_API_ACCESS 1 1 0 false
- _COLLAPSED_SPECIAL 1 1 0 false
- _COLLAPSED_LABELS 1 1 0 false
- _COLLAPSED_UNCAT 1 1 0 false
- _COLLAPSED_FEEDLIST 1 1 0 false
- _MOBILE_ENABLE_CATS 1 1 0 false
- _MOBILE_SHOW_IMAGES 1 1 0 false
- _MOBILE_HIDE_READ 1 1 0 false
- _MOBILE_SORT_FEEDS_UNREAD 1 1 0 false
- _THEME_ID 2 1 0 0
- USER_TIMEZONE 2 1 0 Automatic
- USER_STYLESHEET 2 2 0
- _MOBILE_BROWSE_CATS 1 1 0 true
- SSL_CERT_SERIAL 2 3 0
- DIGEST_PREFERRED_TIME 2 4 0 00:00
- _PREFS_SHOW_EMPTY_CATS 1 1 0 false
- _DEFAULT_INCLUDE_CHILDREN 1 1 0 false
- _ENABLED_PLUGINS 2 1 0
- _MOBILE_REVERSE_HEADLINES 1 1 0 false
- USER_CSS_THEME 2 2 0
- USER_LANGUAGE 2 2 0
- SHOW_CONTENT_PREVIEW 1 2 1 true
- ON_CATCHUP_SHOW_NEXT_FEED 1 2 1 false
- FRESH_ARTICLE_MAX_AGE 3 2 1 24
- CDM_EXPANDED 1 2 1 true
- HIDE_READ_SHOWS_SPECIAL 1 2 1 true
- VFEED_GROUP_BY_FEED 1 2 1 false
- SORT_HEADLINES_BY_FEED_DATE 1 2 1 false
- AUTO_ASSIGN_LABELS 1 3 1 false
- \.
- --
- -- Data for Name: ttrss_prefs_sections; Type: TABLE DATA; Schema: public; Owner: ttrss
- --
- COPY public.ttrss_prefs_sections (id, order_id, section_name) FROM stdin;
- 1 0 General
- 2 1 Interface
- 3 3 Advanced
- 4 2 Digest
- \.
- --
- -- Data for Name: ttrss_prefs_types; Type: TABLE DATA; Schema: public; Owner: ttrss
- --
- COPY public.ttrss_prefs_types (id, type_name) FROM stdin;
- 1 bool
- 2 string
- 3 integer
- \.
- --
- -- Data for Name: ttrss_sessions; Type: TABLE DATA; Schema: public; Owner: ttrss
- --
- COPY public.ttrss_sessions (id, data, expire) FROM stdin;
- \.
- --
- -- Data for Name: ttrss_settings_profiles; Type: TABLE DATA; Schema: public; Owner: ttrss
- --
- COPY public.ttrss_settings_profiles (id, title, owner_uid) FROM stdin;
- \.
- --
- -- Data for Name: ttrss_tags; Type: TABLE DATA; Schema: public; Owner: ttrss
- --
- COPY public.ttrss_tags (id, tag_name, owner_uid, post_int_id) FROM stdin;
- \.
- --
- -- Data for Name: ttrss_user_entries; Type: TABLE DATA; Schema: public; Owner: ttrss
- --
- COPY public.ttrss_user_entries (int_id, ref_id, uuid, feed_id, orig_feed_id, owner_uid, marked, published, tag_cache, label_cache, last_read, score, last_marked, last_published, note, unread) FROM stdin;
- \.
- --
- -- Data for Name: ttrss_user_labels2; Type: TABLE DATA; Schema: public; Owner: ttrss
- --
- COPY public.ttrss_user_labels2 (label_id, article_id) FROM stdin;
- \.
- --
- -- Data for Name: ttrss_user_prefs; Type: TABLE DATA; Schema: public; Owner: ttrss
- --
- COPY public.ttrss_user_prefs (owner_uid, pref_name, profile, value) FROM stdin;
- \.
- --
- -- Data for Name: ttrss_users; Type: TABLE DATA; Schema: public; Owner: ttrss
- --
- COPY public.ttrss_users (id, login, pwd_hash, last_login, access_level, email, full_name, email_digest, last_digest_sent, salt, twitter_oauth, otp_enabled, resetpass_token, created) FROM stdin;
- 1 admin SHA1:5baa61e4c9b93f3f0682250b6cf8331b7ee68fd8 \N 10 f \N \N f \N \N
- \.
- --
- -- Data for Name: ttrss_version; Type: TABLE DATA; Schema: public; Owner: ttrss
- --
- COPY public.ttrss_version (schema_version) FROM stdin;
- 134
- \.
- --
- -- Name: ttrss_access_keys_id_seq; Type: SEQUENCE SET; Schema: public; Owner: ttrss
- --
- SELECT pg_catalog.setval('public.ttrss_access_keys_id_seq', 1, false);
- --
- -- Name: ttrss_enclosures_id_seq; Type: SEQUENCE SET; Schema: public; Owner: ttrss
- --
- SELECT pg_catalog.setval('public.ttrss_enclosures_id_seq', 1, false);
- --
- -- Name: ttrss_entries_id_seq; Type: SEQUENCE SET; Schema: public; Owner: ttrss
- --
- SELECT pg_catalog.setval('public.ttrss_entries_id_seq', 1, false);
- --
- -- Name: ttrss_entry_comments_id_seq; Type: SEQUENCE SET; Schema: public; Owner: ttrss
- --
- SELECT pg_catalog.setval('public.ttrss_entry_comments_id_seq', 1, false);
- --
- -- Name: ttrss_error_log_id_seq; Type: SEQUENCE SET; Schema: public; Owner: ttrss
- --
- SELECT pg_catalog.setval('public.ttrss_error_log_id_seq', 1, false);
- --
- -- Name: ttrss_feed_categories_id_seq; Type: SEQUENCE SET; Schema: public; Owner: ttrss
- --
- SELECT pg_catalog.setval('public.ttrss_feed_categories_id_seq', 1, false);
- --
- -- Name: ttrss_feeds_id_seq; Type: SEQUENCE SET; Schema: public; Owner: ttrss
- --
- SELECT pg_catalog.setval('public.ttrss_feeds_id_seq', 1, true);
- --
- -- Name: ttrss_filters2_actions_id_seq; Type: SEQUENCE SET; Schema: public; Owner: ttrss
- --
- SELECT pg_catalog.setval('public.ttrss_filters2_actions_id_seq', 1, false);
- --
- -- Name: ttrss_filters2_id_seq; Type: SEQUENCE SET; Schema: public; Owner: ttrss
- --
- SELECT pg_catalog.setval('public.ttrss_filters2_id_seq', 1, false);
- --
- -- Name: ttrss_filters2_rules_id_seq; Type: SEQUENCE SET; Schema: public; Owner: ttrss
- --
- SELECT pg_catalog.setval('public.ttrss_filters2_rules_id_seq', 1, false);
- --
- -- Name: ttrss_labels2_id_seq; Type: SEQUENCE SET; Schema: public; Owner: ttrss
- --
- SELECT pg_catalog.setval('public.ttrss_labels2_id_seq', 1, false);
- --
- -- Name: ttrss_linked_instances_id_seq; Type: SEQUENCE SET; Schema: public; Owner: ttrss
- --
- SELECT pg_catalog.setval('public.ttrss_linked_instances_id_seq', 1, false);
- --
- -- Name: ttrss_plugin_storage_id_seq; Type: SEQUENCE SET; Schema: public; Owner: ttrss
- --
- SELECT pg_catalog.setval('public.ttrss_plugin_storage_id_seq', 1, false);
- --
- -- Name: ttrss_settings_profiles_id_seq; Type: SEQUENCE SET; Schema: public; Owner: ttrss
- --
- SELECT pg_catalog.setval('public.ttrss_settings_profiles_id_seq', 1, false);
- --
- -- Name: ttrss_tags_id_seq; Type: SEQUENCE SET; Schema: public; Owner: ttrss
- --
- SELECT pg_catalog.setval('public.ttrss_tags_id_seq', 1, false);
- --
- -- Name: ttrss_user_entries_int_id_seq; Type: SEQUENCE SET; Schema: public; Owner: ttrss
- --
- SELECT pg_catalog.setval('public.ttrss_user_entries_int_id_seq', 1, false);
- --
- -- Name: ttrss_users_id_seq; Type: SEQUENCE SET; Schema: public; Owner: ttrss
- --
- SELECT pg_catalog.setval('public.ttrss_users_id_seq', 1, true);
- --
- -- Name: ttrss_access_keys ttrss_access_keys_pkey; Type: CONSTRAINT; Schema: public; Owner: ttrss
- --
- ALTER TABLE ONLY public.ttrss_access_keys
- ADD CONSTRAINT ttrss_access_keys_pkey PRIMARY KEY (id);
- --
- -- Name: ttrss_archived_feeds ttrss_archived_feeds_pkey; Type: CONSTRAINT; Schema: public; Owner: ttrss
- --
- ALTER TABLE ONLY public.ttrss_archived_feeds
- ADD CONSTRAINT ttrss_archived_feeds_pkey PRIMARY KEY (id);
- --
- -- Name: ttrss_enclosures ttrss_enclosures_pkey; Type: CONSTRAINT; Schema: public; Owner: ttrss
- --
- ALTER TABLE ONLY public.ttrss_enclosures
- ADD CONSTRAINT ttrss_enclosures_pkey PRIMARY KEY (id);
- --
- -- Name: ttrss_entries ttrss_entries_guid_key; Type: CONSTRAINT; Schema: public; Owner: ttrss
- --
- ALTER TABLE ONLY public.ttrss_entries
- ADD CONSTRAINT ttrss_entries_guid_key UNIQUE (guid);
- --
- -- Name: ttrss_entries ttrss_entries_pkey; Type: CONSTRAINT; Schema: public; Owner: ttrss
- --
- ALTER TABLE ONLY public.ttrss_entries
- ADD CONSTRAINT ttrss_entries_pkey PRIMARY KEY (id);
- --
- -- Name: ttrss_entry_comments ttrss_entry_comments_pkey; Type: CONSTRAINT; Schema: public; Owner: ttrss
- --
- ALTER TABLE ONLY public.ttrss_entry_comments
- ADD CONSTRAINT ttrss_entry_comments_pkey PRIMARY KEY (id);
- --
- -- Name: ttrss_error_log ttrss_error_log_pkey; Type: CONSTRAINT; Schema: public; Owner: ttrss
- --
- ALTER TABLE ONLY public.ttrss_error_log
- ADD CONSTRAINT ttrss_error_log_pkey PRIMARY KEY (id);
- --
- -- Name: ttrss_feed_categories ttrss_feed_categories_pkey; Type: CONSTRAINT; Schema: public; Owner: ttrss
- --
- ALTER TABLE ONLY public.ttrss_feed_categories
- ADD CONSTRAINT ttrss_feed_categories_pkey PRIMARY KEY (id);
- --
- -- Name: ttrss_feedbrowser_cache ttrss_feedbrowser_cache_pkey; Type: CONSTRAINT; Schema: public; Owner: ttrss
- --
- ALTER TABLE ONLY public.ttrss_feedbrowser_cache
- ADD CONSTRAINT ttrss_feedbrowser_cache_pkey PRIMARY KEY (feed_url);
- --
- -- Name: ttrss_feeds ttrss_feeds_pkey; Type: CONSTRAINT; Schema: public; Owner: ttrss
- --
- ALTER TABLE ONLY public.ttrss_feeds
- ADD CONSTRAINT ttrss_feeds_pkey PRIMARY KEY (id);
- --
- -- Name: ttrss_filter_actions ttrss_filter_actions_description_key; Type: CONSTRAINT; Schema: public; Owner: ttrss
- --
- ALTER TABLE ONLY public.ttrss_filter_actions
- ADD CONSTRAINT ttrss_filter_actions_description_key UNIQUE (description);
- --
- -- Name: ttrss_filter_actions ttrss_filter_actions_name_key; Type: CONSTRAINT; Schema: public; Owner: ttrss
- --
- ALTER TABLE ONLY public.ttrss_filter_actions
- ADD CONSTRAINT ttrss_filter_actions_name_key UNIQUE (name);
- --
- -- Name: ttrss_filter_actions ttrss_filter_actions_pkey; Type: CONSTRAINT; Schema: public; Owner: ttrss
- --
- ALTER TABLE ONLY public.ttrss_filter_actions
- ADD CONSTRAINT ttrss_filter_actions_pkey PRIMARY KEY (id);
- --
- -- Name: ttrss_filter_types ttrss_filter_types_description_key; Type: CONSTRAINT; Schema: public; Owner: ttrss
- --
- ALTER TABLE ONLY public.ttrss_filter_types
- ADD CONSTRAINT ttrss_filter_types_description_key UNIQUE (description);
- --
- -- Name: ttrss_filter_types ttrss_filter_types_name_key; Type: CONSTRAINT; Schema: public; Owner: ttrss
- --
- ALTER TABLE ONLY public.ttrss_filter_types
- ADD CONSTRAINT ttrss_filter_types_name_key UNIQUE (name);
- --
- -- Name: ttrss_filter_types ttrss_filter_types_pkey; Type: CONSTRAINT; Schema: public; Owner: ttrss
- --
- ALTER TABLE ONLY public.ttrss_filter_types
- ADD CONSTRAINT ttrss_filter_types_pkey PRIMARY KEY (id);
- --
- -- Name: ttrss_filters2_actions ttrss_filters2_actions_pkey; Type: CONSTRAINT; Schema: public; Owner: ttrss
- --
- ALTER TABLE ONLY public.ttrss_filters2_actions
- ADD CONSTRAINT ttrss_filters2_actions_pkey PRIMARY KEY (id);
- --
- -- Name: ttrss_filters2 ttrss_filters2_pkey; Type: CONSTRAINT; Schema: public; Owner: ttrss
- --
- ALTER TABLE ONLY public.ttrss_filters2
- ADD CONSTRAINT ttrss_filters2_pkey PRIMARY KEY (id);
- --
- -- Name: ttrss_filters2_rules ttrss_filters2_rules_pkey; Type: CONSTRAINT; Schema: public; Owner: ttrss
- --
- ALTER TABLE ONLY public.ttrss_filters2_rules
- ADD CONSTRAINT ttrss_filters2_rules_pkey PRIMARY KEY (id);
- --
- -- Name: ttrss_labels2 ttrss_labels2_pkey; Type: CONSTRAINT; Schema: public; Owner: ttrss
- --
- ALTER TABLE ONLY public.ttrss_labels2
- ADD CONSTRAINT ttrss_labels2_pkey PRIMARY KEY (id);
- --
- -- Name: ttrss_linked_instances ttrss_linked_instances_access_key_key; Type: CONSTRAINT; Schema: public; Owner: ttrss
- --
- ALTER TABLE ONLY public.ttrss_linked_instances
- ADD CONSTRAINT ttrss_linked_instances_access_key_key UNIQUE (access_key);
- --
- -- Name: ttrss_linked_instances ttrss_linked_instances_pkey; Type: CONSTRAINT; Schema: public; Owner: ttrss
- --
- ALTER TABLE ONLY public.ttrss_linked_instances
- ADD CONSTRAINT ttrss_linked_instances_pkey PRIMARY KEY (id);
- --
- -- Name: ttrss_plugin_storage ttrss_plugin_storage_pkey; Type: CONSTRAINT; Schema: public; Owner: ttrss
- --
- ALTER TABLE ONLY public.ttrss_plugin_storage
- ADD CONSTRAINT ttrss_plugin_storage_pkey PRIMARY KEY (id);
- --
- -- Name: ttrss_prefs ttrss_prefs_pkey; Type: CONSTRAINT; Schema: public; Owner: ttrss
- --
- ALTER TABLE ONLY public.ttrss_prefs
- ADD CONSTRAINT ttrss_prefs_pkey PRIMARY KEY (pref_name);
- --
- -- Name: ttrss_prefs_sections ttrss_prefs_sections_pkey; Type: CONSTRAINT; Schema: public; Owner: ttrss
- --
- ALTER TABLE ONLY public.ttrss_prefs_sections
- ADD CONSTRAINT ttrss_prefs_sections_pkey PRIMARY KEY (id);
- --
- -- Name: ttrss_prefs_types ttrss_prefs_types_pkey; Type: CONSTRAINT; Schema: public; Owner: ttrss
- --
- ALTER TABLE ONLY public.ttrss_prefs_types
- ADD CONSTRAINT ttrss_prefs_types_pkey PRIMARY KEY (id);
- --
- -- Name: ttrss_sessions ttrss_sessions_pkey; Type: CONSTRAINT; Schema: public; Owner: ttrss
- --
- ALTER TABLE ONLY public.ttrss_sessions
- ADD CONSTRAINT ttrss_sessions_pkey PRIMARY KEY (id);
- --
- -- Name: ttrss_settings_profiles ttrss_settings_profiles_pkey; Type: CONSTRAINT; Schema: public; Owner: ttrss
- --
- ALTER TABLE ONLY public.ttrss_settings_profiles
- ADD CONSTRAINT ttrss_settings_profiles_pkey PRIMARY KEY (id);
- --
- -- Name: ttrss_tags ttrss_tags_pkey; Type: CONSTRAINT; Schema: public; Owner: ttrss
- --
- ALTER TABLE ONLY public.ttrss_tags
- ADD CONSTRAINT ttrss_tags_pkey PRIMARY KEY (id);
- --
- -- Name: ttrss_user_entries ttrss_user_entries_pkey; Type: CONSTRAINT; Schema: public; Owner: ttrss
- --
- ALTER TABLE ONLY public.ttrss_user_entries
- ADD CONSTRAINT ttrss_user_entries_pkey PRIMARY KEY (int_id);
- --
- -- Name: ttrss_users ttrss_users_login_key; Type: CONSTRAINT; Schema: public; Owner: ttrss
- --
- ALTER TABLE ONLY public.ttrss_users
- ADD CONSTRAINT ttrss_users_login_key UNIQUE (login);
- --
- -- Name: ttrss_users ttrss_users_pkey; Type: CONSTRAINT; Schema: public; Owner: ttrss
- --
- ALTER TABLE ONLY public.ttrss_users
- ADD CONSTRAINT ttrss_users_pkey PRIMARY KEY (id);
- --
- -- Name: ttrss_cat_counters_cache_owner_uid_idx; Type: INDEX; Schema: public; Owner: ttrss
- --
- CREATE INDEX ttrss_cat_counters_cache_owner_uid_idx ON public.ttrss_cat_counters_cache USING btree (owner_uid);
- --
- -- Name: ttrss_counters_cache_feed_id_idx; Type: INDEX; Schema: public; Owner: ttrss
- --
- CREATE INDEX ttrss_counters_cache_feed_id_idx ON public.ttrss_counters_cache USING btree (feed_id);
- --
- -- Name: ttrss_counters_cache_owner_uid_idx; Type: INDEX; Schema: public; Owner: ttrss
- --
- CREATE INDEX ttrss_counters_cache_owner_uid_idx ON public.ttrss_counters_cache USING btree (owner_uid);
- --
- -- Name: ttrss_counters_cache_value_idx; Type: INDEX; Schema: public; Owner: ttrss
- --
- CREATE INDEX ttrss_counters_cache_value_idx ON public.ttrss_counters_cache USING btree (value);
- --
- -- Name: ttrss_enclosures_post_id_idx; Type: INDEX; Schema: public; Owner: ttrss
- --
- CREATE INDEX ttrss_enclosures_post_id_idx ON public.ttrss_enclosures USING btree (post_id);
- --
- -- Name: ttrss_entries_date_entered_index; Type: INDEX; Schema: public; Owner: ttrss
- --
- CREATE INDEX ttrss_entries_date_entered_index ON public.ttrss_entries USING btree (date_entered);
- --
- -- Name: ttrss_entries_tsvector_combined_idx; Type: INDEX; Schema: public; Owner: ttrss
- --
- CREATE INDEX ttrss_entries_tsvector_combined_idx ON public.ttrss_entries USING gin (tsvector_combined);
- --
- -- Name: ttrss_entries_updated_idx; Type: INDEX; Schema: public; Owner: ttrss
- --
- CREATE INDEX ttrss_entries_updated_idx ON public.ttrss_entries USING btree (updated);
- --
- -- Name: ttrss_entry_comments_ref_id_index; Type: INDEX; Schema: public; Owner: ttrss
- --
- CREATE INDEX ttrss_entry_comments_ref_id_index ON public.ttrss_entry_comments USING btree (ref_id);
- --
- -- Name: ttrss_feeds_cat_id_idx; Type: INDEX; Schema: public; Owner: ttrss
- --
- CREATE INDEX ttrss_feeds_cat_id_idx ON public.ttrss_feeds USING btree (cat_id);
- --
- -- Name: ttrss_feeds_owner_uid_index; Type: INDEX; Schema: public; Owner: ttrss
- --
- CREATE INDEX ttrss_feeds_owner_uid_index ON public.ttrss_feeds USING btree (owner_uid);
- --
- -- Name: ttrss_sessions_expire_index; Type: INDEX; Schema: public; Owner: ttrss
- --
- CREATE INDEX ttrss_sessions_expire_index ON public.ttrss_sessions USING btree (expire);
- --
- -- Name: ttrss_tags_owner_uid_index; Type: INDEX; Schema: public; Owner: ttrss
- --
- CREATE INDEX ttrss_tags_owner_uid_index ON public.ttrss_tags USING btree (owner_uid);
- --
- -- Name: ttrss_tags_post_int_id_idx; Type: INDEX; Schema: public; Owner: ttrss
- --
- CREATE INDEX ttrss_tags_post_int_id_idx ON public.ttrss_tags USING btree (post_int_id);
- --
- -- Name: ttrss_user_entries_feed_id; Type: INDEX; Schema: public; Owner: ttrss
- --
- CREATE INDEX ttrss_user_entries_feed_id ON public.ttrss_user_entries USING btree (feed_id);
- --
- -- Name: ttrss_user_entries_owner_uid_index; Type: INDEX; Schema: public; Owner: ttrss
- --
- CREATE INDEX ttrss_user_entries_owner_uid_index ON public.ttrss_user_entries USING btree (owner_uid);
- --
- -- Name: ttrss_user_entries_ref_id_index; Type: INDEX; Schema: public; Owner: ttrss
- --
- CREATE INDEX ttrss_user_entries_ref_id_index ON public.ttrss_user_entries USING btree (ref_id);
- --
- -- Name: ttrss_user_entries_unread_idx; Type: INDEX; Schema: public; Owner: ttrss
- --
- CREATE INDEX ttrss_user_entries_unread_idx ON public.ttrss_user_entries USING btree (unread);
- --
- -- Name: ttrss_user_prefs_owner_uid_index; Type: INDEX; Schema: public; Owner: ttrss
- --
- CREATE INDEX ttrss_user_prefs_owner_uid_index ON public.ttrss_user_prefs USING btree (owner_uid);
- --
- -- Name: ttrss_user_prefs_pref_name_idx; Type: INDEX; Schema: public; Owner: ttrss
- --
- CREATE INDEX ttrss_user_prefs_pref_name_idx ON public.ttrss_user_prefs USING btree (pref_name);
- --
- -- Name: ttrss_access_keys ttrss_access_keys_owner_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ttrss
- --
- ALTER TABLE ONLY public.ttrss_access_keys
- ADD CONSTRAINT ttrss_access_keys_owner_uid_fkey FOREIGN KEY (owner_uid) REFERENCES public.ttrss_users(id) ON DELETE CASCADE;
- --
- -- Name: ttrss_archived_feeds ttrss_archived_feeds_owner_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ttrss
- --
- ALTER TABLE ONLY public.ttrss_archived_feeds
- ADD CONSTRAINT ttrss_archived_feeds_owner_uid_fkey FOREIGN KEY (owner_uid) REFERENCES public.ttrss_users(id) ON DELETE CASCADE;
- --
- -- Name: ttrss_cat_counters_cache ttrss_cat_counters_cache_owner_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ttrss
- --
- ALTER TABLE ONLY public.ttrss_cat_counters_cache
- ADD CONSTRAINT ttrss_cat_counters_cache_owner_uid_fkey FOREIGN KEY (owner_uid) REFERENCES public.ttrss_users(id) ON DELETE CASCADE;
- --
- -- Name: ttrss_counters_cache ttrss_counters_cache_owner_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ttrss
- --
- ALTER TABLE ONLY public.ttrss_counters_cache
- ADD CONSTRAINT ttrss_counters_cache_owner_uid_fkey FOREIGN KEY (owner_uid) REFERENCES public.ttrss_users(id) ON DELETE CASCADE;
- --
- -- Name: ttrss_enclosures ttrss_enclosures_post_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ttrss
- --
- ALTER TABLE ONLY public.ttrss_enclosures
- ADD CONSTRAINT ttrss_enclosures_post_id_fkey FOREIGN KEY (post_id) REFERENCES public.ttrss_entries(id) ON DELETE CASCADE;
- --
- -- Name: ttrss_entry_comments ttrss_entry_comments_owner_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ttrss
- --
- ALTER TABLE ONLY public.ttrss_entry_comments
- ADD CONSTRAINT ttrss_entry_comments_owner_uid_fkey FOREIGN KEY (owner_uid) REFERENCES public.ttrss_users(id) ON DELETE CASCADE;
- --
- -- Name: ttrss_entry_comments ttrss_entry_comments_ref_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ttrss
- --
- ALTER TABLE ONLY public.ttrss_entry_comments
- ADD CONSTRAINT ttrss_entry_comments_ref_id_fkey FOREIGN KEY (ref_id) REFERENCES public.ttrss_entries(id) ON DELETE CASCADE;
- --
- -- Name: ttrss_error_log ttrss_error_log_owner_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ttrss
- --
- ALTER TABLE ONLY public.ttrss_error_log
- ADD CONSTRAINT ttrss_error_log_owner_uid_fkey FOREIGN KEY (owner_uid) REFERENCES public.ttrss_users(id) ON DELETE SET NULL;
- --
- -- Name: ttrss_feed_categories ttrss_feed_categories_owner_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ttrss
- --
- ALTER TABLE ONLY public.ttrss_feed_categories
- ADD CONSTRAINT ttrss_feed_categories_owner_uid_fkey FOREIGN KEY (owner_uid) REFERENCES public.ttrss_users(id) ON DELETE CASCADE;
- --
- -- Name: ttrss_feed_categories ttrss_feed_categories_parent_cat_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ttrss
- --
- ALTER TABLE ONLY public.ttrss_feed_categories
- ADD CONSTRAINT ttrss_feed_categories_parent_cat_fkey FOREIGN KEY (parent_cat) REFERENCES public.ttrss_feed_categories(id) ON DELETE SET NULL;
- --
- -- Name: ttrss_feeds ttrss_feeds_cat_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ttrss
- --
- ALTER TABLE ONLY public.ttrss_feeds
- ADD CONSTRAINT ttrss_feeds_cat_id_fkey FOREIGN KEY (cat_id) REFERENCES public.ttrss_feed_categories(id) ON DELETE SET NULL;
- --
- -- Name: ttrss_feeds ttrss_feeds_owner_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ttrss
- --
- ALTER TABLE ONLY public.ttrss_feeds
- ADD CONSTRAINT ttrss_feeds_owner_uid_fkey FOREIGN KEY (owner_uid) REFERENCES public.ttrss_users(id) ON DELETE CASCADE;
- --
- -- Name: ttrss_feeds ttrss_feeds_parent_feed_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ttrss
- --
- ALTER TABLE ONLY public.ttrss_feeds
- ADD CONSTRAINT ttrss_feeds_parent_feed_fkey FOREIGN KEY (parent_feed) REFERENCES public.ttrss_feeds(id) ON DELETE SET NULL;
- --
- -- Name: ttrss_filters2_actions ttrss_filters2_actions_action_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ttrss
- --
- ALTER TABLE ONLY public.ttrss_filters2_actions
- ADD CONSTRAINT ttrss_filters2_actions_action_id_fkey FOREIGN KEY (action_id) REFERENCES public.ttrss_filter_actions(id) ON DELETE CASCADE;
- --
- -- Name: ttrss_filters2_actions ttrss_filters2_actions_filter_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ttrss
- --
- ALTER TABLE ONLY public.ttrss_filters2_actions
- ADD CONSTRAINT ttrss_filters2_actions_filter_id_fkey FOREIGN KEY (filter_id) REFERENCES public.ttrss_filters2(id) ON DELETE CASCADE;
- --
- -- Name: ttrss_filters2 ttrss_filters2_owner_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ttrss
- --
- ALTER TABLE ONLY public.ttrss_filters2
- ADD CONSTRAINT ttrss_filters2_owner_uid_fkey FOREIGN KEY (owner_uid) REFERENCES public.ttrss_users(id) ON DELETE CASCADE;
- --
- -- Name: ttrss_filters2_rules ttrss_filters2_rules_cat_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ttrss
- --
- ALTER TABLE ONLY public.ttrss_filters2_rules
- ADD CONSTRAINT ttrss_filters2_rules_cat_id_fkey FOREIGN KEY (cat_id) REFERENCES public.ttrss_feed_categories(id) ON DELETE CASCADE;
- --
- -- Name: ttrss_filters2_rules ttrss_filters2_rules_feed_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ttrss
- --
- ALTER TABLE ONLY public.ttrss_filters2_rules
- ADD CONSTRAINT ttrss_filters2_rules_feed_id_fkey FOREIGN KEY (feed_id) REFERENCES public.ttrss_feeds(id) ON DELETE CASCADE;
- --
- -- Name: ttrss_filters2_rules ttrss_filters2_rules_filter_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ttrss
- --
- ALTER TABLE ONLY public.ttrss_filters2_rules
- ADD CONSTRAINT ttrss_filters2_rules_filter_id_fkey FOREIGN KEY (filter_id) REFERENCES public.ttrss_filters2(id) ON DELETE CASCADE;
- --
- -- Name: ttrss_filters2_rules ttrss_filters2_rules_filter_type_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ttrss
- --
- ALTER TABLE ONLY public.ttrss_filters2_rules
- ADD CONSTRAINT ttrss_filters2_rules_filter_type_fkey FOREIGN KEY (filter_type) REFERENCES public.ttrss_filter_types(id);
- --
- -- Name: ttrss_labels2 ttrss_labels2_owner_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ttrss
- --
- ALTER TABLE ONLY public.ttrss_labels2
- ADD CONSTRAINT ttrss_labels2_owner_uid_fkey FOREIGN KEY (owner_uid) REFERENCES public.ttrss_users(id) ON DELETE CASCADE;
- --
- -- Name: ttrss_linked_feeds ttrss_linked_feeds_instance_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ttrss
- --
- ALTER TABLE ONLY public.ttrss_linked_feeds
- ADD CONSTRAINT ttrss_linked_feeds_instance_id_fkey FOREIGN KEY (instance_id) REFERENCES public.ttrss_linked_instances(id) ON DELETE CASCADE;
- --
- -- Name: ttrss_plugin_storage ttrss_plugin_storage_owner_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ttrss
- --
- ALTER TABLE ONLY public.ttrss_plugin_storage
- ADD CONSTRAINT ttrss_plugin_storage_owner_uid_fkey FOREIGN KEY (owner_uid) REFERENCES public.ttrss_users(id) ON DELETE CASCADE;
- --
- -- Name: ttrss_prefs ttrss_prefs_section_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ttrss
- --
- ALTER TABLE ONLY public.ttrss_prefs
- ADD CONSTRAINT ttrss_prefs_section_id_fkey FOREIGN KEY (section_id) REFERENCES public.ttrss_prefs_sections(id);
- --
- -- Name: ttrss_prefs ttrss_prefs_type_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ttrss
- --
- ALTER TABLE ONLY public.ttrss_prefs
- ADD CONSTRAINT ttrss_prefs_type_id_fkey FOREIGN KEY (type_id) REFERENCES public.ttrss_prefs_types(id);
- --
- -- Name: ttrss_settings_profiles ttrss_settings_profiles_owner_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ttrss
- --
- ALTER TABLE ONLY public.ttrss_settings_profiles
- ADD CONSTRAINT ttrss_settings_profiles_owner_uid_fkey FOREIGN KEY (owner_uid) REFERENCES public.ttrss_users(id) ON DELETE CASCADE;
- --
- -- Name: ttrss_tags ttrss_tags_owner_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ttrss
- --
- ALTER TABLE ONLY public.ttrss_tags
- ADD CONSTRAINT ttrss_tags_owner_uid_fkey FOREIGN KEY (owner_uid) REFERENCES public.ttrss_users(id) ON DELETE CASCADE;
- --
- -- Name: ttrss_tags ttrss_tags_post_int_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ttrss
- --
- ALTER TABLE ONLY public.ttrss_tags
- ADD CONSTRAINT ttrss_tags_post_int_id_fkey FOREIGN KEY (post_int_id) REFERENCES public.ttrss_user_entries(int_id) ON DELETE CASCADE;
- --
- -- Name: ttrss_user_entries ttrss_user_entries_feed_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ttrss
- --
- ALTER TABLE ONLY public.ttrss_user_entries
- ADD CONSTRAINT ttrss_user_entries_feed_id_fkey FOREIGN KEY (feed_id) REFERENCES public.ttrss_feeds(id) ON DELETE CASCADE;
- --
- -- Name: ttrss_user_entries ttrss_user_entries_orig_feed_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ttrss
- --
- ALTER TABLE ONLY public.ttrss_user_entries
- ADD CONSTRAINT ttrss_user_entries_orig_feed_id_fkey FOREIGN KEY (orig_feed_id) REFERENCES public.ttrss_archived_feeds(id) ON DELETE SET NULL;
- --
- -- Name: ttrss_user_entries ttrss_user_entries_owner_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ttrss
- --
- ALTER TABLE ONLY public.ttrss_user_entries
- ADD CONSTRAINT ttrss_user_entries_owner_uid_fkey FOREIGN KEY (owner_uid) REFERENCES public.ttrss_users(id) ON DELETE CASCADE;
- --
- -- Name: ttrss_user_entries ttrss_user_entries_ref_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ttrss
- --
- ALTER TABLE ONLY public.ttrss_user_entries
- ADD CONSTRAINT ttrss_user_entries_ref_id_fkey FOREIGN KEY (ref_id) REFERENCES public.ttrss_entries(id) ON DELETE CASCADE;
- --
- -- Name: ttrss_user_labels2 ttrss_user_labels2_article_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ttrss
- --
- ALTER TABLE ONLY public.ttrss_user_labels2
- ADD CONSTRAINT ttrss_user_labels2_article_id_fkey FOREIGN KEY (article_id) REFERENCES public.ttrss_entries(id) ON DELETE CASCADE;
- --
- -- Name: ttrss_user_labels2 ttrss_user_labels2_label_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ttrss
- --
- ALTER TABLE ONLY public.ttrss_user_labels2
- ADD CONSTRAINT ttrss_user_labels2_label_id_fkey FOREIGN KEY (label_id) REFERENCES public.ttrss_labels2(id) ON DELETE CASCADE;
- --
- -- Name: ttrss_user_prefs ttrss_user_prefs_owner_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ttrss
- --
- ALTER TABLE ONLY public.ttrss_user_prefs
- ADD CONSTRAINT ttrss_user_prefs_owner_uid_fkey FOREIGN KEY (owner_uid) REFERENCES public.ttrss_users(id) ON DELETE CASCADE;
- --
- -- Name: ttrss_user_prefs ttrss_user_prefs_pref_name_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ttrss
- --
- ALTER TABLE ONLY public.ttrss_user_prefs
- ADD CONSTRAINT ttrss_user_prefs_pref_name_fkey FOREIGN KEY (pref_name) REFERENCES public.ttrss_prefs(pref_name) ON DELETE CASCADE;
- --
- -- Name: ttrss_user_prefs ttrss_user_prefs_profile_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ttrss
- --
- ALTER TABLE ONLY public.ttrss_user_prefs
- ADD CONSTRAINT ttrss_user_prefs_profile_fkey FOREIGN KEY (profile) REFERENCES public.ttrss_settings_profiles(id) ON DELETE CASCADE;
- --
- -- PostgreSQL database dump complete
- --
|