-
Notifications
You must be signed in to change notification settings - Fork 9
/
Copy pathdb.sql
151 lines (107 loc) · 2.46 KB
/
db.sql
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
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
--
-- PostgreSQL database dump
--
-- Dumped from database version 9.6.6
-- Dumped by pg_dump version 10.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;
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';
SET search_path = public, pg_catalog;
SET default_tablespace = '';
SET default_with_oids = false;
--
-- Name: accounts; Type: TABLE; Schema: public; Owner: schedutron
--
CREATE TABLE accounts (
id bigint
);
ALTER TABLE accounts OWNER TO schedutron;
--
-- Name: admins; Type: TABLE; Schema: public; Owner: schedutron
--
CREATE TABLE admins (
id integer
);
ALTER TABLE admins OWNER TO schedutron;
--
-- Name: keywords; Type: TABLE; Schema: public; Owner: schedutron
--
CREATE TABLE keywords (
word character varying
);
ALTER TABLE keywords OWNER TO schedutron;
--
-- Name: messages; Type: TABLE; Schema: public; Owner: schedutron
--
CREATE TABLE messages (
message character varying
);
ALTER TABLE messages OWNER TO schedutron;
--
-- Data for Name: accounts; Type: TABLE DATA; Schema: public; Owner: schedutron
--
COPY accounts (id) FROM stdin;
44196397
50393960
1636590253
\.
--
-- Data for Name: admins; Type: TABLE DATA; Schema: public; Owner: schedutron
--
COPY admins (id) FROM stdin;
257842996
\.
--
-- Data for Name: keywords; Type: TABLE DATA; Schema: public; Owner: schedutron
--
COPY keywords (word) FROM stdin;
feynman
python
pygame
machine learning
apache framework
watson framework
special relativity
general relativity
tensorflow
multithreading
raspberrypi
matplotlib
scala
artificial intelligence
einstein
tkinter
sql
ramanujan
distributed computing
peloton
\.
--
-- Data for Name: messages; Type: TABLE DATA; Schema: public; Owner: schedutron
--
COPY messages (message) FROM stdin;
Do you employ spaced repetition when you're learning something new?
\.
--
-- Name: public; Type: ACL; Schema: -; Owner: schedutron
--
REVOKE ALL ON SCHEMA public FROM rdsadmin;
REVOKE ALL ON SCHEMA public FROM PUBLIC;
GRANT ALL ON SCHEMA public TO schedutron;
GRANT ALL ON SCHEMA public TO PUBLIC;
--
-- PostgreSQL database dump complete
--