 
 
 --
--- Name: remote_urls_id_seq; Type: SEQUENCE SET; Schema: public; Owner: documentcloud
---
-
-SELECT pg_catalog.setval('remote_urls_id_seq', 1, false);
-
-
---
 -- Name: id; Type: DEFAULT; Schema: public; Owner: documentcloud
 --
 

SET default_with_oids = false;

--
-- 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,
    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
);





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

ALTER TABLE ONLY remote_urls
