This repository was archived by the owner on Mar 11, 2021. It is now read-only.
-
Notifications
You must be signed in to change notification settings - Fork 157
Expand file tree
/
Copy pathanalytics_structure.sql
More file actions
134 lines (90 loc) · 2.89 KB
/
analytics_structure.sql
File metadata and controls
134 lines (90 loc) · 2.89 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
--
-- PostgreSQL database dump
--
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;
--
-- Name: dcloud_analytics_development; Type: DATABASE; Schema: -; Owner: -
--
CREATE DATABASE dcloud_analytics_development WITH TEMPLATE = template0 ENCODING = 'UTF8' LC_COLLATE = 'en_US.UTF-8' LC_CTYPE = 'en_US.UTF-8';
\connect dcloud_analytics_development
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;
--
-- 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';
SET search_path = public, pg_catalog;
SET default_tablespace = '';
SET default_with_oids = false;
--
-- Name: remote_urls; Type: TABLE; Schema: public; Owner: -; Tablespace:
--
CREATE TABLE remote_urls (
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,
note_id integer,
search_query character varying(255),
page_number integer
);
--
-- Name: remote_urls_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
CREATE SEQUENCE remote_urls_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
--
-- Name: remote_urls_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--
ALTER SEQUENCE remote_urls_id_seq OWNED BY remote_urls.id;
--
-- Name: id; Type: DEFAULT; Schema: public; Owner: -
--
ALTER TABLE ONLY remote_urls ALTER COLUMN id SET DEFAULT nextval('remote_urls_id_seq'::regclass);
--
-- Name: remote_urls_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
--
ALTER TABLE ONLY remote_urls
ADD CONSTRAINT remote_urls_pkey PRIMARY KEY (id);
--
-- Name: remote_urls_indx_document_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
--
CREATE INDEX remote_urls_indx_document_id ON remote_urls USING btree (document_id);
--
-- Name: remote_urls_indx_url; Type: INDEX; Schema: public; Owner: -; Tablespace:
--
CREATE INDEX remote_urls_indx_url ON remote_urls USING btree (url);
--
-- Name: remote_urls_indx_url_date; Type: INDEX; Schema: public; Owner: -; Tablespace:
--
CREATE INDEX remote_urls_indx_url_date ON remote_urls USING btree (url, date_recorded);
--
-- Name: public; Type: ACL; Schema: -; Owner: -
--
REVOKE ALL ON SCHEMA public FROM PUBLIC;
REVOKE ALL ON SCHEMA public FROM postgres;
GRANT ALL ON SCHEMA public TO postgres;
GRANT ALL ON SCHEMA public TO PUBLIC;
--
-- PostgreSQL database dump complete
--