Created
March 21, 2016 01:33
-
-
Save profh/a243685482ac0d8f3244 to your computer and use it in GitHub Desktop.
pg_dump for superhero_transact database
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- 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; | |
CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog; | |
COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language'; | |
SET search_path = public, pg_catalog; | |
SET default_tablespace = ''; | |
SET default_with_oids = false; | |
-- Name: dc; Type: TABLE; Schema: public; Owner: profh; Tablespace: | |
-- | |
CREATE TABLE dc ( | |
hero_id integer NOT NULL, | |
name character varying(50), | |
power character varying(255), | |
active boolean DEFAULT true | |
); | |
ALTER TABLE dc OWNER TO profh; | |
-- Name: dc_hero_id_seq; Type: SEQUENCE; Schema: public; Owner: profh | |
-- | |
CREATE SEQUENCE dc_hero_id_seq | |
START WITH 1 | |
INCREMENT BY 1 | |
NO MINVALUE | |
NO MAXVALUE | |
CACHE 1; | |
ALTER TABLE dc_hero_id_seq OWNER TO profh; | |
ALTER SEQUENCE dc_hero_id_seq OWNED BY dc.hero_id; | |
-- Name: heroes; Type: TABLE; Schema: public; Owner: profh; Tablespace: | |
-- | |
CREATE TABLE heroes ( | |
hero_id integer NOT NULL, | |
name character varying(50), | |
power character varying(255), | |
active boolean DEFAULT true, | |
age integer | |
); | |
ALTER TABLE heroes OWNER TO profh; | |
-- Name: heroes_hero_id_seq; Type: SEQUENCE; Schema: public; Owner: profh | |
-- | |
CREATE SEQUENCE heroes_hero_id_seq | |
START WITH 1 | |
INCREMENT BY 1 | |
NO MINVALUE | |
NO MAXVALUE | |
CACHE 1; | |
ALTER TABLE heroes_hero_id_seq OWNER TO profh; | |
ALTER SEQUENCE heroes_hero_id_seq OWNED BY heroes.hero_id; | |
-- | |
-- Name: identities; Type: TABLE; Schema: public; Owner: profh; Tablespace: | |
-- | |
CREATE TABLE identities ( | |
hero_id integer NOT NULL, | |
person_id integer NOT NULL | |
); | |
ALTER TABLE identities OWNER TO profh; | |
-- Name: marvel; Type: TABLE; Schema: public; Owner: profh; Tablespace: | |
-- | |
CREATE TABLE marvel ( | |
hero_id integer NOT NULL, | |
name character varying(50), | |
power character varying(255), | |
active boolean DEFAULT true | |
); | |
ALTER TABLE marvel OWNER TO profh; | |
-- Name: marvel_hero_id_seq; Type: SEQUENCE; Schema: public; Owner: profh | |
-- | |
CREATE SEQUENCE marvel_hero_id_seq | |
START WITH 1 | |
INCREMENT BY 1 | |
NO MINVALUE | |
NO MAXVALUE | |
CACHE 1; | |
ALTER TABLE marvel_hero_id_seq OWNER TO profh; | |
ALTER SEQUENCE marvel_hero_id_seq OWNED BY marvel.hero_id; | |
-- Name: people; Type: TABLE; Schema: public; Owner: profh; Tablespace: | |
-- | |
CREATE TABLE people ( | |
person_id integer NOT NULL, | |
first_name character varying(50), | |
last_name character varying(50), | |
height integer, | |
weight integer, | |
is_male boolean, | |
active boolean DEFAULT true, | |
email character varying(50) | |
); | |
ALTER TABLE people OWNER TO profh; | |
-- Name: people_person_id_seq; Type: SEQUENCE; Schema: public; Owner: profh | |
-- | |
CREATE SEQUENCE people_person_id_seq | |
START WITH 1 | |
INCREMENT BY 1 | |
NO MINVALUE | |
NO MAXVALUE | |
CACHE 1; | |
ALTER TABLE people_person_id_seq OWNER TO profh; | |
ALTER SEQUENCE people_person_id_seq OWNED BY people.person_id; | |
-- Name: victories; Type: TABLE; Schema: public; Owner: profh; Tablespace: | |
-- | |
CREATE TABLE victories ( | |
id integer NOT NULL, | |
hero_id integer NOT NULL, | |
major integer DEFAULT 0, | |
minor integer DEFAULT 0, | |
for_month date NOT NULL | |
); | |
ALTER TABLE victories OWNER TO profh; | |
-- Name: victories_id_seq; Type: SEQUENCE; Schema: public; Owner: profh | |
-- | |
CREATE SEQUENCE victories_id_seq | |
START WITH 1 | |
INCREMENT BY 1 | |
NO MINVALUE | |
NO MAXVALUE | |
CACHE 1; | |
ALTER TABLE victories_id_seq OWNER TO profh; | |
ALTER SEQUENCE victories_id_seq OWNED BY victories.id; | |
ALTER TABLE ONLY dc ALTER COLUMN hero_id SET DEFAULT nextval('dc_hero_id_seq'::regclass); | |
ALTER TABLE ONLY heroes ALTER COLUMN hero_id SET DEFAULT nextval('heroes_hero_id_seq'::regclass); | |
ALTER TABLE ONLY marvel ALTER COLUMN hero_id SET DEFAULT nextval('marvel_hero_id_seq'::regclass); | |
ALTER TABLE ONLY people ALTER COLUMN person_id SET DEFAULT nextval('people_person_id_seq'::regclass); | |
ALTER TABLE ONLY victories ALTER COLUMN id SET DEFAULT nextval('victories_id_seq'::regclass); | |
-- Data for Name: dc; Type: TABLE DATA; Schema: public; Owner: profh | |
-- | |
COPY dc (hero_id, name, power, active) FROM stdin; | |
1 Batman None - just totally awesome t | |
2 Superman Flies; great strength; xray vision t | |
3 Green Lantern Power ring creates solid constructs based on will; flies t | |
4 Hawkeye None, but exceptional archer; keen eyesight t | |
5 Wonder Woman Enhanced strength; various weapons t | |
6 Angel Teleportation; mind control t | |
7 Aquaman Breathes underwater; communicates with marine life t | |
\. | |
SELECT pg_catalog.setval('dc_hero_id_seq', 7, true); | |
-- Data for Name: heroes; Type: TABLE DATA; Schema: public; Owner: profh | |
-- | |
COPY heroes (hero_id, name, power, active, age) FROM stdin; | |
2 Superman flys; great strength; xray vision t \N | |
3 Green Lantern Power ring creates solid constructs based on will t \N | |
4 Wolverine Healing factor; adamantium skelton; retractable claws t \N | |
7 Wonder Woman Enhanced strength; various weapons t \N | |
8 Storm Control of weather; flys t \N | |
9 Shadowcat Can phase between solid objects t \N | |
10 Angel Has wings; flys t \N | |
11 Archangel Has wings; flys; shoots projectiles from wings t \N | |
12 Colossus Superhuman strength; body can turn into solid metal t \N | |
13 Aquaman Breathes underwater; communicates with marine life t \N | |
14 The Tickerina nigh-invulnerable t 48 | |
6 Nightcrawler Teleportation; superhuman agility t 37 | |
5 Spiderman Spider senses; web-slinging t 23 | |
1 Batman None - just totally awesome t 52 | |
\. | |
SELECT pg_catalog.setval('heroes_hero_id_seq', 14, true); | |
-- Data for Name: identities; Type: TABLE DATA; Schema: public; Owner: profh | |
-- | |
COPY identities (hero_id, person_id) FROM stdin; | |
2 1 | |
3 2 | |
3 3 | |
3 4 | |
1 6 | |
4 7 | |
6 8 | |
11 15 | |
8 10 | |
9 13 | |
10 15 | |
5 11 | |
14 9 | |
\. | |
-- Data for Name: marvel; Type: TABLE DATA; Schema: public; Owner: profh | |
-- | |
COPY marvel (hero_id, name, power, active) FROM stdin; | |
1 Spiderman Spider senses; web-slinging t | |
2 Wolverine Healing factor; adamantium skelton; retractable claws t | |
3 Nightcrawler Teleportation; superhuman agility t | |
4 Storm Control of weather; flies t | |
5 Shadowcat Can phase through solid objects t | |
6 Angel Has wings; flies t | |
7 Archangel Has wings; flies; shoots projectiles from wings t | |
8 Colossus Superhuman strength; body can turn into solid metal t | |
9 Hawkeye None, but exceptional archer; keen eyesight t | |
\. | |
SELECT pg_catalog.setval('marvel_hero_id_seq', 10, true); | |
-- Data for Name: people; Type: TABLE DATA; Schema: public; Owner: profh | |
-- | |
COPY people (person_id, first_name, last_name, height, weight, is_male, active, email) FROM stdin; | |
3 Guy Gardner 72 194 t t \N | |
4 Kyle Rayner 73 209 t t \N | |
7 Logan \N 68 195 t t \N | |
8 Kurt Wagner 68 165 t t \N | |
14 Elizabeth Braddock 68 165 f t \N | |
9 Larry Heimann 76 230 t t profh@cmu.edu | |
6 Bruce Wayne 75 230 t t bruce@wayne.net | |
11 Peter Parker 70 180 t t ppaker@gmail.com | |
1 Clark Kent 76 225 t t clarkk@yahoo.com | |
15 Warren Worthington 72 190 t t flyboy@gmail.com | |
12 Anna Marie \N 67 160 f t rogue99@gmail.com | |
2 Hal Jordan 71 189 t t glearth@yahoo.com | |
10 Ororo Munroe 71 180 f t stormy@gmail.com | |
13 Kitty Pryde 66 155 f t kpryde@yahoo.com | |
5 Dick Greyson 69 168 t t dgreyson@wayne.net | |
\. | |
SELECT pg_catalog.setval('people_person_id_seq', 15, true); | |
-- Data for Name: victories; Type: TABLE DATA; Schema: public; Owner: profh | |
-- | |
COPY victories (id, hero_id, major, minor, for_month) FROM stdin; | |
1 1 1 23 2012-01-01 | |
2 1 2 16 2012-02-01 | |
3 1 1 35 2012-03-01 | |
4 1 0 17 2012-04-01 | |
5 1 1 24 2012-05-01 | |
6 1 0 12 2012-06-01 | |
7 1 3 42 2012-07-01 | |
8 1 1 19 2012-08-01 | |
9 2 0 2 2012-01-01 | |
10 2 1 1 2012-02-01 | |
12 2 0 0 2012-04-01 | |
13 2 1 3 2012-05-01 | |
14 2 0 0 2012-06-01 | |
15 2 0 0 2012-07-01 | |
16 2 1 4 2012-08-01 | |
11 2 0 3 2012-03-01 | |
17 5 1 12 2012-01-01 | |
19 5 0 29 2012-03-01 | |
20 5 2 8 2012-04-01 | |
21 5 1 17 2012-05-01 | |
22 5 0 26 2012-06-01 | |
23 5 1 20 2012-07-01 | |
24 5 1 16 2012-08-01 | |
18 5 1 18 2012-02-01 | |
\. | |
SELECT pg_catalog.setval('victories_id_seq', 28, true); | |
ALTER TABLE ONLY dc | |
ADD CONSTRAINT dc_pkey PRIMARY KEY (hero_id); | |
ALTER TABLE ONLY heroes | |
ADD CONSTRAINT heroes_pkey PRIMARY KEY (hero_id); | |
ALTER TABLE ONLY identities | |
ADD CONSTRAINT identities_pkey PRIMARY KEY (hero_id, person_id); | |
ALTER TABLE ONLY marvel | |
ADD CONSTRAINT marvel_pkey PRIMARY KEY (hero_id); | |
ALTER TABLE ONLY people | |
ADD CONSTRAINT people_pkey PRIMARY KEY (person_id); | |
ALTER TABLE ONLY victories | |
ADD CONSTRAINT victories_pkey PRIMARY KEY (id); | |
ALTER TABLE ONLY victories | |
ADD CONSTRAINT hero_fk FOREIGN KEY (hero_id) REFERENCES heroes(hero_id); | |
REVOKE ALL ON SCHEMA public FROM PUBLIC; | |
REVOKE ALL ON SCHEMA public FROM profh; | |
GRANT ALL ON SCHEMA public TO profh; | |
GRANT ALL ON SCHEMA public TO PUBLIC; | |
-- PostgreSQL database dump complete |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment