 -- Name: url_entries; Type: TABLE; Schema: public; Owner: -
 --
 
-CREATE TABLE url_entries (
+CREATE TABLE public.url_entries (
     id bigint NOT NULL,
     note_id integer NOT NULL,
     text text NOT NULL,

SET statement_timeout = 0;
SET lock_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SET check_function_bodies = false;
SET client_min_messages = warning;
SET row_security = off;

-- Name: url_entries_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.url_entries_id_seq OWNED BY public.url_entries.id;


--
-- Name: notes id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.notes ALTER COLUMN id SET DEFAULT nextval('public.notes_id_seq'::regclass);


--
-- Name: shows id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.shows ALTER COLUMN id SET DEFAULT nextval('public.shows_id_seq'::regclass);


--
-- Name: url_entries id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.url_entries ALTER COLUMN id SET DEFAULT nextval('public.url_entries_id_seq'::regclass);


--
-- Name: ar_internal_metadata ar_internal_metadata_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.ar_internal_metadata
    ADD CONSTRAINT ar_internal_metadata_pkey PRIMARY KEY (key);


--
-- Name: notes notes_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.notes
    ADD CONSTRAINT notes_pkey PRIMARY KEY (id);


--
-- Name: schema_migrations schema_migrations_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.schema_migrations
    ADD CONSTRAINT schema_migrations_pkey PRIMARY KEY (version);


--
-- Name: shows shows_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.shows
    ADD CONSTRAINT shows_pkey PRIMARY KEY (id);


--
-- Name: url_entries url_entries_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.url_entries
    ADD CONSTRAINT url_entries_pkey PRIMARY KEY (id);


--
-- Name: notes_document_gin; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX notes_document_gin ON public.notes USING gin (to_tsvector('english'::regconfig, document));


--
-- Name: notes_text_gin; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX notes_text_gin ON public.notes USING gin (to_tsvector('english'::regconfig, text));


--
-- Name: notes_title_gin; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX notes_title_gin ON public.notes USING gin (to_tsvector('english'::regconfig, title));


--
-- Name: url_entries_url; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX url_entries_url ON public.url_entries USING gin (lower(url) public.gin_trgm_ops);


--
