 SET default_with_oids = false;
 
 --
--- Name: remote_urls; Type: TABLE; Schema: public; Owner: documentcloud; Tablespace:
+-- Name: remote_urls; Type: TABLE; Schema: public; Owner: documentcloud; Tablespace: 
 --
 
-DROP TABLE IF EXISTS remote_urls;
 CREATE TABLE remote_urls (
     id integer NOT NULL,
-    document_id integer NOT NULL,
+    document_id integer,
     url character varying(255) NOT NULL,
     hits integer DEFAULT 0 NOT NULL,
     date_recorded date NOT NULL,
     created_at timestamp without time zone,
-    updated_at timestamp without time zone
+    updated_at timestamp without time zone,
+    note_id integer,
+    search_query character varying(255)
 );
 
 



--
-- Name: remote_urls_pkey; Type: CONSTRAINT; Schema: public; Owner: documentcloud; Tablespace:
--

ALTER TABLE ONLY remote_urls



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

