API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Oct 10th, 2015
178
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 30.37 KB | None | 0 0
raw download clone embed print report
  1. --
  2. -- PostgreSQL database dump
  3. --
  4.  
  5. SET statement_timeout = 0;
  6. SET lock_timeout = 0;
  7. SET client_encoding = 'UTF8';
  8. SET standard_conforming_strings = on;
  9. SET check_function_bodies = false;
  10. SET client_min_messages = warning;
  11.  
  12. --
  13. -- Name: plpgsql; Type: EXTENSION; Schema: -; Owner:
  14. --
  15.  
  16. CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;
  17.  
  18.  
  19. --
  20. -- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner:
  21. --
  22.  
  23. COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';
  24.  
  25.  
  26. SET search_path = public, pg_catalog;
  27.  
  28. SET default_tablespace = '';
  29.  
  30. SET default_with_oids = false;
  31.  
  32. --
  33. -- Name: animals; Type: TABLE; Schema: public; Owner: jon; Tablespace:
  34. --
  35.  
  36. CREATE TABLE animals (
  37. id integer NOT NULL,
  38. breeder_id integer,
  39. owner_id integer,
  40. sire_id integer,
  41. dam_id integer,
  42. birth_date date NOT NULL,
  43. gender character varying NOT NULL,
  44. birth_type integer NOT NULL,
  45. artificial_insemination boolean NOT NULL,
  46. embryo_transfer character varying NOT NULL,
  47. percentage integer NOT NULL,
  48. created_at timestamp without time zone NOT NULL,
  49. updated_at timestamp without time zone NOT NULL,
  50. registration_type character varying,
  51. breed integer NOT NULL
  52. );
  53.  
  54.  
  55. ALTER TABLE animals OWNER TO jon;
  56.  
  57. --
  58. -- Name: animals_id_seq; Type: SEQUENCE; Schema: public; Owner: jon
  59. --
  60.  
  61. CREATE SEQUENCE animals_id_seq
  62. START WITH 1
  63. INCREMENT BY 1
  64. NO MINVALUE
  65. NO MAXVALUE
  66. CACHE 1;
  67.  
  68.  
  69. ALTER TABLE animals_id_seq OWNER TO jon;
  70.  
  71. --
  72. -- Name: animals_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: jon
  73. --
  74.  
  75. ALTER SEQUENCE animals_id_seq OWNED BY animals.id;
  76.  
  77.  
  78. --
  79. -- Name: schema_migrations; Type: TABLE; Schema: public; Owner: jon; Tablespace:
  80. --
  81.  
  82. CREATE TABLE schema_migrations (
  83. version character varying NOT NULL
  84. );
  85.  
  86.  
  87. ALTER TABLE schema_migrations OWNER TO jon;
  88.  
  89. --
  90. -- Name: users; Type: TABLE; Schema: public; Owner: jon; Tablespace:
  91. --
  92.  
  93. CREATE TABLE users (
  94. id integer NOT NULL,
  95. name character varying,
  96. address1 character varying,
  97. address2 character varying,
  98. city character varying,
  99. state character varying,
  100. zip character varying,
  101. flock_name character varying,
  102. email character varying DEFAULT ''::character varying NOT NULL,
  103. phone character varying,
  104. fax character varying,
  105. created_at timestamp without time zone NOT NULL,
  106. updated_at timestamp without time zone NOT NULL,
  107. encrypted_password character varying DEFAULT ''::character varying NOT NULL,
  108. reset_password_token character varying,
  109. reset_password_sent_at timestamp without time zone,
  110. remember_created_at timestamp without time zone,
  111. sign_in_count integer DEFAULT 0 NOT NULL,
  112. current_sign_in_at timestamp without time zone,
  113. last_sign_in_at timestamp without time zone,
  114. current_sign_in_ip inet,
  115. last_sign_in_ip inet,
  116. confirmation_token character varying,
  117. confirmed_at timestamp without time zone,
  118. confirmation_sent_at timestamp without time zone,
  119. unconfirmed_email character varying
  120. );
  121.  
  122.  
  123. ALTER TABLE users OWNER TO jon;
  124.  
  125. --
  126. -- Name: users_id_seq; Type: SEQUENCE; Schema: public; Owner: jon
  127. --
  128.  
  129. CREATE SEQUENCE users_id_seq
  130. START WITH 1
  131. INCREMENT BY 1
  132. NO MINVALUE
  133. NO MAXVALUE
  134. CACHE 1;
  135.  
  136.  
  137. ALTER TABLE users_id_seq OWNER TO jon;
  138.  
  139. --
  140. -- Name: users_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: jon
  141. --
  142.  
  143. ALTER SEQUENCE users_id_seq OWNED BY users.id;
  144.  
  145.  
  146. --
  147. -- Name: id; Type: DEFAULT; Schema: public; Owner: jon
  148. --
  149.  
  150. ALTER TABLE ONLY animals ALTER COLUMN id SET DEFAULT nextval('animals_id_seq'::regclass);
  151.  
  152.  
  153. --
  154. -- Name: id; Type: DEFAULT; Schema: public; Owner: jon
  155. --
  156.  
  157. ALTER TABLE ONLY users ALTER COLUMN id SET DEFAULT nextval('users_id_seq'::regclass);
  158.  
  159.  
  160. --
  161. -- Data for Name: animals; Type: TABLE DATA; Schema: public; Owner: jon
  162. --
  163.  
  164. COPY animals (id, breeder_id, owner_id, sire_id, dam_id, birth_date, gender, birth_type, artificial_insemination, embryo_transfer, percentage, created_at, updated_at, registration_type, breed) FROM stdin;
  165. 488 186 186 \N \N 1995-10-10 M 3 f N 100 2015-10-10 21:57:56.427794 2015-10-10 21:57:56.427794 X 0
  166. 489 186 186 \N \N 1995-10-10 M 4 f N 100 2015-10-10 21:57:56.434652 2015-10-10 21:57:56.434652 X 0
  167. 490 186 186 \N \N 1995-10-10 M 5 f N 100 2015-10-10 21:57:56.4404 2015-10-10 21:57:56.4404 F 1
  168. 491 186 186 \N \N 1995-10-10 M 3 f N 100 2015-10-10 21:57:56.446144 2015-10-10 21:57:56.446144 F 0
  169. 492 186 186 \N \N 1995-10-10 M 2 f N 100 2015-10-10 21:57:56.451782 2015-10-10 21:57:56.451782 F 0
  170. 493 186 186 \N \N 1995-10-10 F 5 f N 100 2015-10-10 21:57:56.458007 2015-10-10 21:57:56.458007 X 0
  171. 494 186 186 \N \N 1995-10-10 F 5 f N 100 2015-10-10 21:57:56.464011 2015-10-10 21:57:56.464011 F 1
  172. 495 186 186 \N \N 1995-10-10 F 0 f N 100 2015-10-10 21:57:56.469025 2015-10-10 21:57:56.469025 P 0
  173. 496 186 186 \N \N 1995-10-10 F 5 f N 100 2015-10-10 21:57:56.473342 2015-10-10 21:57:56.473342 X 1
  174. 497 186 186 \N \N 1995-10-10 F 4 f N 100 2015-10-10 21:57:56.477595 2015-10-10 21:57:56.477595 F 1
  175. 498 186 194 492 494 1997-03-10 M 2 f N 100 2015-10-10 21:57:56.489673 2015-10-10 21:57:56.489673 F 1
  176. 499 186 193 491 494 1997-03-10 M 1 f N 100 2015-10-10 21:57:56.497528 2015-10-10 21:57:56.497528 X 0
  177. 500 186 188 499 493 1998-08-10 F 3 f N 100 2015-10-10 21:57:56.505248 2015-10-10 21:57:56.505248 F 1
  178. 501 186 194 499 495 1998-08-10 M 5 f N 100 2015-10-10 21:57:56.512852 2015-10-10 21:57:56.512852 X 0
  179. 502 186 193 489 495 1997-03-10 F 2 f N 100 2015-10-10 21:57:56.52021 2015-10-10 21:57:56.52021 P 0
  180. 503 186 186 498 497 1998-08-10 M 0 f N 100 2015-10-10 21:57:56.527522 2015-10-10 21:57:56.527522 F 1
  181. 504 186 188 490 495 1997-03-10 M 1 f N 100 2015-10-10 21:57:56.53515 2015-10-10 21:57:56.53515 F 1
  182. 505 186 186 499 497 1998-08-10 F 2 f N 100 2015-10-10 21:57:56.542233 2015-10-10 21:57:56.542233 F 0
  183. 506 186 193 492 493 1997-03-10 F 3 f N 100 2015-10-10 21:57:56.549357 2015-10-10 21:57:56.549357 X 0
  184. 507 193 189 501 506 2000-01-10 F 4 f N 100 2015-10-10 21:57:56.556283 2015-10-10 21:57:56.556283 F 0
  185. 508 188 186 488 500 2000-01-10 F 3 f N 100 2015-10-10 21:57:56.562919 2015-10-10 21:57:56.562919 X 1
  186. 509 186 195 498 505 2000-01-10 M 5 f N 100 2015-10-10 21:57:56.582071 2015-10-10 21:57:56.582071 X 1
  187. 510 186 189 504 494 1998-08-10 F 5 f N 100 2015-10-10 21:57:56.589009 2015-10-10 21:57:56.589009 X 1
  188. 511 186 195 509 497 2001-06-10 F 2 f N 100 2015-10-10 21:57:56.595331 2015-10-10 21:57:56.595331 F 0
  189. 512 186 187 504 493 1998-08-10 F 4 f N 100 2015-10-10 21:57:56.602259 2015-10-10 21:57:56.602259 F 0
  190. 513 187 189 504 512 2000-01-10 F 5 f N 100 2015-10-10 21:57:56.608559 2015-10-10 21:57:56.608559 X 0
  191. 514 186 186 503 497 2000-01-10 F 1 f N 100 2015-10-10 21:57:56.615798 2015-10-10 21:57:56.615798 X 1
  192. 515 189 189 504 513 2001-06-10 M 2 f N 100 2015-10-10 21:57:56.623456 2015-10-10 21:57:56.623456 P 1
  193. 516 189 188 489 507 2001-06-10 M 2 f N 100 2015-10-10 21:57:56.630041 2015-10-10 21:57:56.630041 F 0
  194. 517 193 188 503 506 2000-01-10 F 3 f N 100 2015-10-10 21:57:56.6365 2015-10-10 21:57:56.6365 X 0
  195. 518 186 195 488 505 2000-01-10 F 4 f N 100 2015-10-10 21:57:56.643609 2015-10-10 21:57:56.643609 X 1
  196. 519 186 189 490 494 1997-03-10 F 0 f N 100 2015-10-10 21:57:56.650562 2015-10-10 21:57:56.650562 P 0
  197. 520 186 195 503 496 2000-01-10 M 1 f N 100 2015-10-10 21:57:56.656958 2015-10-10 21:57:56.656958 P 1
  198. 521 186 195 501 514 2001-06-10 M 4 f N 100 2015-10-10 21:57:56.663158 2015-10-10 21:57:56.663158 X 1
  199. 522 186 195 499 508 2001-06-10 M 0 f N 100 2015-10-10 21:57:56.669217 2015-10-10 21:57:56.669217 F 0
  200. 523 195 187 515 518 2002-11-10 M 1 f N 100 2015-10-10 21:57:56.675097 2015-10-10 21:57:56.675097 P 1
  201. 524 189 186 522 510 2002-11-10 F 2 f N 100 2015-10-10 21:57:56.681541 2015-10-10 21:57:56.681541 F 1
  202. 525 189 195 488 507 2001-06-10 M 2 f N 100 2015-10-10 21:57:56.687931 2015-10-10 21:57:56.687931 X 0
  203. 526 189 192 515 507 2002-11-10 F 2 f N 100 2015-10-10 21:57:56.694588 2015-10-10 21:57:56.694588 F 0
  204. 527 189 190 491 507 2001-06-10 M 2 f N 100 2015-10-10 21:57:56.701709 2015-10-10 21:57:56.701709 F 0
  205. 528 189 192 522 507 2002-11-10 M 4 f N 100 2015-10-10 21:57:56.70802 2015-10-10 21:57:56.70802 F 1
  206. 529 186 192 509 514 2001-06-10 F 1 f N 100 2015-10-10 21:57:56.714143 2015-10-10 21:57:56.714143 X 0
  207. 530 189 192 527 510 2002-11-10 M 2 f N 100 2015-10-10 21:57:56.720439 2015-10-10 21:57:56.720439 P 0
  208. 531 192 190 489 529 2002-11-10 F 1 f N 100 2015-10-10 21:57:56.726369 2015-10-10 21:57:56.726369 P 0
  209. 532 188 193 530 517 2004-04-10 F 0 f N 100 2015-10-10 21:57:56.732291 2015-10-10 21:57:56.732291 P 0
  210. 533 192 192 523 529 2004-04-10 F 2 f N 100 2015-10-10 21:57:56.73859 2015-10-10 21:57:56.73859 F 1
  211. 534 193 194 521 532 2005-09-10 F 4 f N 100 2015-10-10 21:57:56.744781 2015-10-10 21:57:56.744781 F 1
  212. 535 193 194 516 532 2005-09-10 F 1 f N 100 2015-10-10 21:57:56.755822 2015-10-10 21:57:56.755822 P 0
  213. 536 188 186 530 517 2004-04-10 M 1 f N 100 2015-10-10 21:57:56.764672 2015-10-10 21:57:56.764672 X 0
  214. 537 189 186 523 507 2004-04-10 M 1 f N 100 2015-10-10 21:57:56.772515 2015-10-10 21:57:56.772515 X 1
  215. 538 186 193 492 524 2004-04-10 M 2 f N 100 2015-10-10 21:57:56.77962 2015-10-10 21:57:56.77962 P 1
  216. 539 189 187 509 513 2001-06-10 M 5 f N 100 2015-10-10 21:57:56.786757 2015-10-10 21:57:56.786757 X 1
  217. 540 194 195 521 534 2007-02-10 M 5 f N 100 2015-10-10 21:57:56.79355 2015-10-10 21:57:56.79355 F 1
  218. 541 192 194 492 529 2002-11-10 M 3 f N 100 2015-10-10 21:57:56.800285 2015-10-10 21:57:56.800285 F 1
  219. 542 189 195 501 519 2000-01-10 F 2 f N 100 2015-10-10 21:57:56.806655 2015-10-10 21:57:56.806655 X 1
  220. 543 192 189 520 533 2005-09-10 M 3 f N 100 2015-10-10 21:57:56.813312 2015-10-10 21:57:56.813312 X 1
  221. 544 186 191 539 505 2002-11-10 F 3 f N 100 2015-10-10 21:57:56.820088 2015-10-10 21:57:56.820088 P 0
  222. 545 186 188 541 524 2004-04-10 M 1 f N 100 2015-10-10 21:57:56.827139 2015-10-10 21:57:56.827139 X 1
  223. 546 193 187 516 502 2002-11-10 M 3 f N 100 2015-10-10 21:57:56.833761 2015-10-10 21:57:56.833761 F 1
  224. 547 186 186 538 495 2005-09-10 F 3 f N 100 2015-10-10 21:57:56.840064 2015-10-10 21:57:56.840064 X 1
  225. 548 188 195 503 517 2001-06-10 F 0 f N 100 2015-10-10 21:57:56.846718 2015-10-10 21:57:56.846718 P 1
  226. 549 186 190 509 494 2001-06-10 F 1 f N 100 2015-10-10 21:57:56.853172 2015-10-10 21:57:56.853172 F 0
  227. 550 191 190 539 544 2004-04-10 M 4 f N 100 2015-10-10 21:57:56.859725 2015-10-10 21:57:56.859725 P 1
  228. 551 195 189 492 511 2002-11-10 M 3 f N 100 2015-10-10 21:57:56.866194 2015-10-10 21:57:56.866194 X 1
  229. 552 191 192 509 544 2004-04-10 M 2 f N 100 2015-10-10 21:57:56.872703 2015-10-10 21:57:56.872703 X 1
  230. 553 186 195 489 524 2004-04-10 M 0 f N 100 2015-10-10 21:57:56.879053 2015-10-10 21:57:56.879053 X 1
  231. 554 191 193 515 544 2004-04-10 F 2 f N 100 2015-10-10 21:57:56.889169 2015-10-10 21:57:56.889169 X 1
  232. 555 186 187 527 505 2002-11-10 M 3 f N 100 2015-10-10 21:57:56.895607 2015-10-10 21:57:56.895607 X 1
  233. 556 186 188 525 524 2004-04-10 M 4 f N 100 2015-10-10 21:57:56.901839 2015-10-10 21:57:56.901839 P 1
  234. 557 189 188 539 507 2002-11-10 M 4 f N 100 2015-10-10 21:57:56.908073 2015-10-10 21:57:56.908073 P 1
  235. 558 187 194 515 512 2002-11-10 M 1 f N 100 2015-10-10 21:57:56.914187 2015-10-10 21:57:56.914187 P 0
  236. 559 189 190 557 510 2004-04-10 F 5 f N 100 2015-10-10 21:57:56.921062 2015-10-10 21:57:56.921062 X 0
  237. 560 192 188 521 533 2005-09-10 F 1 f N 100 2015-10-10 21:57:56.928037 2015-10-10 21:57:56.928037 P 1
  238. 561 193 195 499 506 1998-08-10 M 3 f N 100 2015-10-10 21:57:56.935206 2015-10-10 21:57:56.935206 F 1
  239. 562 193 192 490 506 1998-08-10 M 2 f N 100 2015-10-10 21:57:56.942548 2015-10-10 21:57:56.942548 P 1
  240. 563 194 189 523 535 2007-02-10 F 5 f N 100 2015-10-10 21:57:56.949966 2015-10-10 21:57:56.949966 F 0
  241. 564 189 194 543 563 2008-07-10 M 3 f N 100 2015-10-10 21:57:56.956716 2015-10-10 21:57:56.956716 F 0
  242. 565 186 193 515 494 2002-11-10 F 2 f N 100 2015-10-10 21:57:56.963368 2015-10-10 21:57:56.963368 X 0
  243. 566 188 188 558 517 2004-04-10 F 5 f N 100 2015-10-10 21:57:56.969798 2015-10-10 21:57:56.969798 X 1
  244. 567 190 195 552 531 2005-09-10 M 3 f N 100 2015-10-10 21:57:56.976197 2015-10-10 21:57:56.976197 X 0
  245. 568 189 186 521 563 2008-07-10 F 3 f N 100 2015-10-10 21:57:56.982723 2015-10-10 21:57:56.982723 P 1
  246. 569 187 190 520 512 2001-06-10 F 0 f N 100 2015-10-10 21:57:56.989121 2015-10-10 21:57:56.989121 X 0
  247. 570 193 186 553 532 2005-09-10 F 4 f N 100 2015-10-10 21:57:56.995841 2015-10-10 21:57:56.995841 P 0
  248. 571 186 188 530 508 2004-04-10 M 4 f N 100 2015-10-10 21:57:57.002891 2015-10-10 21:57:57.002891 P 0
  249. 572 187 189 536 512 2005-09-10 F 3 f N 100 2015-10-10 21:57:57.009913 2015-10-10 21:57:57.009913 P 1
  250. 573 193 191 523 554 2005-09-10 M 4 f N 100 2015-10-10 21:57:57.016618 2015-10-10 21:57:57.016618 F 0
  251. 574 186 190 551 508 2004-04-10 F 1 f N 100 2015-10-10 21:57:57.023353 2015-10-10 21:57:57.023353 X 1
  252. 575 190 192 571 559 2005-09-10 M 0 f N 100 2015-10-10 21:57:57.030395 2015-10-10 21:57:57.030395 P 0
  253. 576 186 190 501 505 2000-01-10 F 0 f N 100 2015-10-10 21:57:57.037717 2015-10-10 21:57:57.037717 X 0
  254. 577 188 190 536 560 2007-02-10 F 2 f N 100 2015-10-10 21:57:57.044584 2015-10-10 21:57:57.044584 P 1
  255. 578 189 194 516 519 2002-11-10 F 0 f N 100 2015-10-10 21:57:57.051731 2015-10-10 21:57:57.051731 P 0
  256. 579 192 190 491 526 2004-04-10 M 5 f N 100 2015-10-10 21:57:57.059542 2015-10-10 21:57:57.059542 P 0
  257. 580 195 195 523 518 2004-04-10 M 3 f N 100 2015-10-10 21:57:57.066557 2015-10-10 21:57:57.066557 F 0
  258. 581 190 192 528 531 2004-04-10 F 0 f N 100 2015-10-10 21:57:57.073351 2015-10-10 21:57:57.073351 F 0
  259. 582 189 193 520 510 2001-06-10 F 1 f N 100 2015-10-10 21:57:57.080348 2015-10-10 21:57:57.080348 P 1
  260. 583 186 194 492 493 1997-03-10 M 1 f N 100 2015-10-10 21:57:57.087782 2015-10-10 21:57:57.087782 P 1
  261. 584 189 188 579 510 2005-09-10 F 4 f N 100 2015-10-10 21:57:57.094669 2015-10-10 21:57:57.094669 P 1
  262. 585 192 189 523 533 2005-09-10 F 3 f N 100 2015-10-10 21:57:57.101802 2015-10-10 21:57:57.101802 P 0
  263. 586 189 192 545 563 2008-07-10 F 5 f N 100 2015-10-10 21:57:57.108575 2015-10-10 21:57:57.108575 F 0
  264. 587 190 189 536 559 2005-09-10 F 2 f N 100 2015-10-10 21:57:57.115363 2015-10-10 21:57:57.115363 F 0
  265. 588 190 186 488 549 2002-11-10 F 5 f N 100 2015-10-10 21:57:57.122197 2015-10-10 21:57:57.122197 F 0
  266. 589 186 187 573 495 2007-02-10 M 3 f N 100 2015-10-10 21:57:57.129062 2015-10-10 21:57:57.129062 F 0
  267. 590 191 186 521 544 2004-04-10 F 2 f N 100 2015-10-10 21:57:57.136177 2015-10-10 21:57:57.136177 P 0
  268. 591 193 188 538 554 2005-09-10 F 4 f N 100 2015-10-10 21:57:57.143405 2015-10-10 21:57:57.143405 F 0
  269. 592 193 188 503 554 2005-09-10 M 0 f N 100 2015-10-10 21:57:57.150248 2015-10-10 21:57:57.150248 F 0
  270. 593 186 194 523 524 2004-04-10 M 2 f N 100 2015-10-10 21:57:57.157314 2015-10-10 21:57:57.157314 X 1
  271. 594 189 187 540 510 2008-07-10 F 5 f N 100 2015-10-10 21:57:57.163874 2015-10-10 21:57:57.163874 P 0
  272. 595 188 194 571 500 2005-09-10 F 0 f N 100 2015-10-10 21:57:57.170332 2015-10-10 21:57:57.170332 P 0
  273. 596 189 195 593 563 2008-07-10 F 5 f N 100 2015-10-10 21:57:57.177083 2015-10-10 21:57:57.177083 F 0
  274. 597 186 192 573 494 2007-02-10 M 2 f N 100 2015-10-10 21:57:57.183293 2015-10-10 21:57:57.183293 F 1
  275. 598 186 187 556 514 2005-09-10 F 0 f N 100 2015-10-10 21:57:57.19431 2015-10-10 21:57:57.19431 P 1
  276. 599 190 189 527 549 2002-11-10 M 0 f N 100 2015-10-10 21:57:57.201608 2015-10-10 21:57:57.201608 P 1
  277. 600 194 189 490 535 2007-02-10 M 3 f N 100 2015-10-10 21:57:57.208391 2015-10-10 21:57:57.208391 F 1
  278. 601 190 186 562 559 2005-09-10 M 2 f N 100 2015-10-10 21:57:57.21482 2015-10-10 21:57:57.21482 F 1
  279. 602 194 186 539 535 2007-02-10 M 1 f N 100 2015-10-10 21:57:57.221367 2015-10-10 21:57:57.221367 X 1
  280. 603 189 194 556 563 2008-07-10 F 3 f N 100 2015-10-10 21:57:57.22783 2015-10-10 21:57:57.22783 F 1
  281. 604 189 189 540 585 2008-07-10 M 2 f N 100 2015-10-10 21:57:57.234034 2015-10-10 21:57:57.234034 X 1
  282. 605 194 195 564 534 2009-12-10 M 3 f N 100 2015-10-10 21:57:57.240434 2015-10-10 21:57:57.240434 F 1
  283. 606 191 187 604 544 2009-12-10 M 3 f N 100 2015-10-10 21:57:57.24694 2015-10-10 21:57:57.24694 F 1
  284. 607 195 193 604 518 2009-12-10 F 3 f N 100 2015-10-10 21:57:57.253523 2015-10-10 21:57:57.253523 P 1
  285. 608 195 190 605 511 2011-05-10 F 1 f N 100 2015-10-10 21:57:57.260249 2015-10-10 21:57:57.260249 X 1
  286. 609 195 194 564 542 2009-12-10 F 2 f N 100 2015-10-10 21:57:57.26686 2015-10-10 21:57:57.26686 X 1
  287. 610 193 187 556 554 2005-09-10 M 2 f N 100 2015-10-10 21:57:57.273655 2015-10-10 21:57:57.273655 F 1
  288. 611 195 192 553 518 2005-09-10 M 5 f N 100 2015-10-10 21:57:57.280165 2015-10-10 21:57:57.280165 F 1
  289. 612 190 190 555 577 2008-07-10 F 3 f N 100 2015-10-10 21:57:57.286756 2015-10-10 21:57:57.286756 F 1
  290. 613 188 192 546 517 2004-04-10 F 3 f N 100 2015-10-10 21:57:57.293163 2015-10-10 21:57:57.293163 X 1
  291. 614 195 188 562 548 2002-11-10 M 3 f N 100 2015-10-10 21:57:57.299939 2015-10-10 21:57:57.299939 X 0
  292. 615 193 186 564 532 2009-12-10 M 2 f N 100 2015-10-10 21:57:57.306513 2015-10-10 21:57:57.306513 P 0
  293. 616 188 187 571 500 2005-09-10 F 0 f N 100 2015-10-10 21:57:57.313166 2015-10-10 21:57:57.313166 F 0
  294. 617 190 195 492 531 2004-04-10 M 1 f N 100 2015-10-10 21:57:57.319734 2015-10-10 21:57:57.319734 X 1
  295. 618 186 192 515 514 2002-11-10 F 0 f N 100 2015-10-10 21:57:57.326413 2015-10-10 21:57:57.326413 P 0
  296. 619 194 192 562 609 2011-05-10 M 2 f N 100 2015-10-10 21:57:57.333815 2015-10-10 21:57:57.333815 P 1
  297. 620 186 193 610 495 2007-02-10 F 5 f N 100 2015-10-10 21:57:57.341398 2015-10-10 21:57:57.341398 P 0
  298. 621 186 188 601 588 2007-02-10 F 1 f N 100 2015-10-10 21:57:57.34879 2015-10-10 21:57:57.34879 X 0
  299. 622 189 187 573 563 2008-07-10 F 4 f N 100 2015-10-10 21:57:57.35609 2015-10-10 21:57:57.35609 F 1
  300. 623 189 187 575 563 2008-07-10 F 3 f N 100 2015-10-10 21:57:57.363526 2015-10-10 21:57:57.363526 X 0
  301. 624 193 195 571 532 2005-09-10 M 4 f N 100 2015-10-10 21:57:57.370873 2015-10-10 21:57:57.370873 P 1
  302. 625 186 191 527 590 2005-09-10 M 0 f N 100 2015-10-10 21:57:57.377541 2015-10-10 21:57:57.377541 F 0
  303. 626 186 186 604 496 2009-12-10 F 5 f N 100 2015-10-10 21:57:57.38415 2015-10-10 21:57:57.38415 X 0
  304. 627 190 193 561 549 2002-11-10 M 3 f N 100 2015-10-10 21:57:57.390674 2015-10-10 21:57:57.390674 P 0
  305. 628 188 195 617 517 2005-09-10 F 4 f N 100 2015-10-10 21:57:57.397334 2015-10-10 21:57:57.397334 X 1
  306. 629 190 191 489 612 2009-12-10 F 2 f N 100 2015-10-10 21:57:57.403949 2015-10-10 21:57:57.403949 F 1
  307. 630 186 192 515 505 2002-11-10 F 2 f N 100 2015-10-10 21:57:57.410926 2015-10-10 21:57:57.410926 P 0
  308. 631 186 195 606 494 2011-05-10 F 2 f N 100 2015-10-10 21:57:57.41778 2015-10-10 21:57:57.41778 X 1
  309. 632 194 194 592 534 2007-02-10 F 1 f N 100 2015-10-10 21:57:57.42468 2015-10-10 21:57:57.42468 F 1
  310. 633 195 195 501 628 2007-02-10 M 2 f N 100 2015-10-10 21:57:57.431407 2015-10-10 21:57:57.431407 P 0
  311. 634 186 191 573 494 2007-02-10 M 2 f N 100 2015-10-10 21:57:57.438169 2015-10-10 21:57:57.438169 X 1
  312. 635 191 192 525 544 2004-04-10 F 0 f N 100 2015-10-10 21:57:57.444934 2015-10-10 21:57:57.444934 F 0
  313. 636 188 195 501 591 2007-02-10 M 2 f N 100 2015-10-10 21:57:57.451754 2015-10-10 21:57:57.451754 P 0
  314. 637 189 190 599 587 2007-02-10 M 5 f N 100 2015-10-10 21:57:57.458857 2015-10-10 21:57:57.458857 P 0
  315. 638 195 189 602 542 2008-07-10 F 1 f N 100 2015-10-10 21:57:57.465954 2015-10-10 21:57:57.465954 F 0
  316. 639 195 192 589 596 2009-12-10 F 1 f N 100 2015-10-10 21:57:57.47283 2015-10-10 21:57:57.47283 X 1
  317. 640 189 188 597 507 2008-07-10 F 1 f N 100 2015-10-10 21:57:57.479377 2015-10-10 21:57:57.479377 F 0
  318. 641 190 189 604 608 2012-10-10 F 4 f N 100 2015-10-10 21:57:57.485938 2015-10-10 21:57:57.485938 P 0
  319. 642 190 187 527 608 2012-10-10 F 5 f N 100 2015-10-10 21:57:57.492522 2015-10-10 21:57:57.492522 F 0
  320. 643 187 187 592 622 2009-12-10 M 3 f N 100 2015-10-10 21:57:57.503473 2015-10-10 21:57:57.503473 F 0
  321. 644 186 195 561 588 2004-04-10 F 0 f N 100 2015-10-10 21:57:57.510435 2015-10-10 21:57:57.510435 F 0
  322. 645 192 189 601 630 2007-02-10 F 3 f N 100 2015-10-10 21:57:57.517537 2015-10-10 21:57:57.517537 X 1
  323. 646 190 195 627 559 2005-09-10 F 0 f N 100 2015-10-10 21:57:57.524222 2015-10-10 21:57:57.524222 P 1
  324. 647 195 194 617 631 2012-10-10 F 1 f N 100 2015-10-10 21:57:57.530733 2015-10-10 21:57:57.530733 X 0
  325. 648 195 189 619 628 2012-10-10 M 1 f N 100 2015-10-10 21:57:57.537178 2015-10-10 21:57:57.537178 F 0
  326. 649 186 189 521 497 2002-11-10 F 2 f N 100 2015-10-10 21:57:57.543514 2015-10-10 21:57:57.543514 X 0
  327. 650 187 195 509 616 2007-02-10 F 3 f N 100 2015-10-10 21:57:57.549868 2015-10-10 21:57:57.549868 F 0
  328. 651 194 193 606 609 2011-05-10 M 3 f N 100 2015-10-10 21:57:57.556416 2015-10-10 21:57:57.556416 F 0
  329. 652 192 191 617 618 2005-09-10 F 0 f N 100 2015-10-10 21:57:57.562737 2015-10-10 21:57:57.562737 F 1
  330. 653 193 190 522 620 2008-07-10 M 1 f N 100 2015-10-10 21:57:57.569305 2015-10-10 21:57:57.569305 P 0
  331. 654 190 190 589 608 2012-10-10 F 0 f N 100 2015-10-10 21:57:57.575682 2015-10-10 21:57:57.575682 F 1
  332. 655 193 190 504 502 1998-08-10 F 4 f N 100 2015-10-10 21:57:57.582046 2015-10-10 21:57:57.582046 P 0
  333. 656 186 186 600 495 2008-07-10 M 4 f N 100 2015-10-10 21:57:57.58829 2015-10-10 21:57:57.58829 X 1
  334. 657 195 192 601 596 2009-12-10 M 5 f N 100 2015-10-10 21:57:57.594762 2015-10-10 21:57:57.594762 P 1
  335. 658 189 190 627 587 2007-02-10 F 0 f N 100 2015-10-10 21:57:57.601352 2015-10-10 21:57:57.601352 F 0
  336. 659 189 192 615 519 2011-05-10 M 2 f N 100 2015-10-10 21:57:57.608611 2015-10-10 21:57:57.608611 F 1
  337. 660 187 193 659 623 2012-10-10 F 5 f N 100 2015-10-10 21:57:57.616025 2015-10-10 21:57:57.616025 F 1
  338. 661 195 195 521 511 2002-11-10 F 4 f N 100 2015-10-10 21:57:57.623484 2015-10-10 21:57:57.623484 F 0
  339. 662 186 187 614 494 2004-04-10 F 5 f N 100 2015-10-10 21:57:57.630245 2015-10-10 21:57:57.630245 P 0
  340. 663 192 188 657 618 2011-05-10 M 2 f N 100 2015-10-10 21:57:57.636984 2015-10-10 21:57:57.636984 P 0
  341. 664 194 192 537 632 2008-07-10 M 1 f N 100 2015-10-10 21:57:57.643566 2015-10-10 21:57:57.643566 P 1
  342. 665 194 191 663 632 2012-10-10 F 3 f N 100 2015-10-10 21:57:57.650319 2015-10-10 21:57:57.650319 P 0
  343. 666 195 189 637 596 2009-12-10 F 0 f N 100 2015-10-10 21:57:57.656858 2015-10-10 21:57:57.656858 F 0
  344. 667 189 195 611 572 2007-02-10 F 1 f N 100 2015-10-10 21:57:57.66326 2015-10-10 21:57:57.66326 F 0
  345. 668 190 193 602 569 2008-07-10 F 0 f N 100 2015-10-10 21:57:57.669717 2015-10-10 21:57:57.669717 F 1
  346. 669 192 192 553 533 2005-09-10 M 0 f N 100 2015-10-10 21:57:57.676032 2015-10-10 21:57:57.676032 X 1
  347. 670 193 194 521 554 2005-09-10 F 2 f N 100 2015-10-10 21:57:57.682623 2015-10-10 21:57:57.682623 X 1
  348. 671 187 195 546 594 2009-12-10 M 0 f N 100 2015-10-10 21:57:57.689735 2015-10-10 21:57:57.689735 P 1
  349. 672 186 194 579 493 2005-09-10 F 2 f N 100 2015-10-10 21:57:57.696751 2015-10-10 21:57:57.696751 X 1
  350. 673 195 190 604 667 2009-12-10 F 3 f N 100 2015-10-10 21:57:57.703776 2015-10-10 21:57:57.703776 F 0
  351. 674 191 190 521 629 2011-05-10 F 1 f N 100 2015-10-10 21:57:57.711111 2015-10-10 21:57:57.711111 P 0
  352. 675 193 194 573 607 2011-05-10 M 5 f N 100 2015-10-10 21:57:57.717784 2015-10-10 21:57:57.717784 F 1
  353. 676 189 187 499 641 2014-03-10 F 5 f N 100 2015-10-10 21:57:57.72415 2015-10-10 21:57:57.72415 X 0
  354. 677 192 189 653 526 2009-12-10 M 5 f N 100 2015-10-10 21:57:57.730515 2015-10-10 21:57:57.730515 F 1
  355. 678 195 194 627 548 2004-04-10 F 3 f N 100 2015-10-10 21:57:57.736699 2015-10-10 21:57:57.736699 X 1
  356. 679 186 190 516 570 2007-02-10 M 2 f N 100 2015-10-10 21:57:57.742867 2015-10-10 21:57:57.742867 F 1
  357. 680 193 187 579 502 2005-09-10 F 1 f N 100 2015-10-10 21:57:57.749094 2015-10-10 21:57:57.749094 P 0
  358. 681 190 192 556 569 2005-09-10 M 4 f N 100 2015-10-10 21:57:57.75655 2015-10-10 21:57:57.75655 P 1
  359. 682 195 189 555 518 2004-04-10 F 4 f N 100 2015-10-10 21:57:57.769494 2015-10-10 21:57:57.769494 P 0
  360. 683 188 186 657 591 2011-05-10 F 0 f N 100 2015-10-10 21:57:57.777356 2015-10-10 21:57:57.777356 F 0
  361. 684 189 193 491 666 2011-05-10 M 3 f N 100 2015-10-10 21:57:57.78491 2015-10-10 21:57:57.78491 F 0
  362. 685 194 191 593 534 2007-02-10 M 0 f N 100 2015-10-10 21:57:57.792838 2015-10-10 21:57:57.792838 X 0
  363. 686 195 193 504 548 2002-11-10 F 4 f N 100 2015-10-10 21:57:57.800997 2015-10-10 21:57:57.800997 P 0
  364. 687 186 190 490 568 2009-12-10 F 1 f N 100 2015-10-10 21:57:57.812538 2015-10-10 21:57:57.812538 X 0
  365. 688 195 186 633 542 2008-07-10 M 2 f N 100 2015-10-10 21:57:57.820305 2015-10-10 21:57:57.820305 F 0
  366. 689 195 189 619 548 2012-10-10 F 0 f N 100 2015-10-10 21:57:57.82814 2015-10-10 21:57:57.82814 X 0
  367. 690 192 194 536 581 2005-09-10 F 5 f N 100 2015-10-10 21:57:57.835589 2015-10-10 21:57:57.835589 F 1
  368. 691 186 192 583 547 2007-02-10 M 3 f N 100 2015-10-10 21:57:57.843288 2015-10-10 21:57:57.843288 F 0
  369. 692 194 192 575 603 2009-12-10 M 4 f N 100 2015-10-10 21:57:57.851111 2015-10-10 21:57:57.851111 F 1
  370. 693 195 193 575 542 2007-02-10 F 5 f N 100 2015-10-10 21:57:57.858375 2015-10-10 21:57:57.858375 X 1
  371. 694 187 189 691 598 2008-07-10 M 4 f N 100 2015-10-10 21:57:57.865319 2015-10-10 21:57:57.865319 P 0
  372. 695 194 190 492 535 2007-02-10 M 3 f N 100 2015-10-10 21:57:57.871777 2015-10-10 21:57:57.871777 P 1
  373. 696 192 192 653 529 2009-12-10 M 3 f N 100 2015-10-10 21:57:57.878437 2015-10-10 21:57:57.878437 X 0
  374. 697 193 191 664 532 2009-12-10 M 0 f N 100 2015-10-10 21:57:57.884577 2015-10-10 21:57:57.884577 F 0
  375. \.
  376.  
  377.  
  378. --
  379. -- Name: animals_id_seq; Type: SEQUENCE SET; Schema: public; Owner: jon
  380. --
  381.  
  382. SELECT pg_catalog.setval('animals_id_seq', 697, true);
  383.  
  384.  
  385. --
  386. -- Data for Name: schema_migrations; Type: TABLE DATA; Schema: public; Owner: jon
  387. --
  388.  
  389. COPY schema_migrations (version) FROM stdin;
  390. 20150930152639
  391. 20150922164932
  392. 20150924181116
  393. 20150922174814
  394. 20150916175056
  395. 20150922183837
  396. \.
  397.  
  398.  
  399. --
  400. -- Data for Name: users; Type: TABLE DATA; Schema: public; Owner: jon
  401. --
  402.  
  403. COPY users (id, name, address1, address2, city, state, zip, flock_name, email, phone, fax, created_at, updated_at, encrypted_password, reset_password_token, reset_password_sent_at, remember_created_at, sign_in_count, current_sign_in_at, last_sign_in_at, current_sign_in_ip, last_sign_in_ip, confirmation_token, confirmed_at, confirmation_sent_at, unconfirmed_email) FROM stdin;
  404. 186 Liza Bechtelar III 18472 Wisozk Trail \N New Keyshawn MS 65055 Sequi Farm brad@heidenreich.net 1-563-202-9411 \N 2015-10-10 21:57:56.353723 2015-10-10 21:57:56.353723 $2a$10$ddWfRHK5IfxE1jqFp5P7/.3/yCTuWi.wwNyf9tmgIfZ8rPBJWPyf. \N \N \N 0 \N \N \N \N \N 2015-10-10 21:57:56.345912 \N \N
  405. 187 Mr. George Greenholt 9826 Lebsack Route \N North Sidneychester OK 30252-9404 In Ranch waylon.nitzsche@hills.biz (909) 527-5514 x41563 \N 2015-10-10 21:57:56.364061 2015-10-10 21:57:56.364061 $2a$10$E1Ds6QiY38n65AebLAeMG.ONlT.zW8qP1B/KmbKOgpUCOsaAe4BUa \N \N \N 0 \N \N \N \N \N 2015-10-10 21:57:56.361515 \N \N
  406. 188 Alphonso Hagenes 33492 Yost Valley \N Lake Rachaelview WY 66953-7550 Consectetur Farm madie@davislarkin.name (806) 840-5439 \N 2015-10-10 21:57:56.371216 2015-10-10 21:57:56.371216 $2a$10$srIepzfnASQyjFz2XFn5sumv..qQXgRUhNOP8S7LiPTb6RIxSS9OS \N \N \N 0 \N \N \N \N \N 2015-10-10 21:57:56.368927 \N \N
  407. 189 Shanel Anderson 72550 Lindgren Flats \N Nedstad UT 15164 Nostrum Ranch salvatore@wyman.name 878-447-3332 x9191 \N 2015-10-10 21:57:56.377967 2015-10-10 21:57:56.377967 $2a$10$xoE.0BlSs34AN.cFWk4IAuUABJFxTJGRW5K5tvAe6As6bM1/WE6um \N \N \N 0 \N \N \N \N \N 2015-10-10 21:57:56.376085 \N \N
  408. 190 Reta Skiles 7077 Arlie Causeway \N Mossieborough HI 55945-6554 Ut Farm else.lowe@walsh.co 415.153.6713 x01806 \N 2015-10-10 21:57:56.384118 2015-10-10 21:57:56.384118 $2a$10$ivRd0bRcmDKrbC.fzFmepu4dV05LtbT/LsjPuxDzYlQim0/QY2282 \N \N \N 0 \N \N \N \N \N 2015-10-10 21:57:56.382226 \N \N
  409. 191 Simone Fay MD 2879 Randi Haven \N Stehrville WY 13884-0162 Hic Farm rupert@casper.org 1-829-174-4761 x33340 \N 2015-10-10 21:57:56.390608 2015-10-10 21:57:56.390608 $2a$10$zF2DnFn6nOH2Kylj2MsADuv1eLro3Ju9s87nfEypEOV7xMpbe/ctC \N \N \N 0 \N \N \N \N \N 2015-10-10 21:57:56.388701 \N \N
  410. 192 Jessie Cormier 43890 Domenick Square \N Lake Leathamouth TN 85360-1876 Facilis Farm ethyl@dubuque.net 851.425.4164 \N 2015-10-10 21:57:56.396728 2015-10-10 21:57:56.396728 $2a$10$4GOeYZHgrGvUANSmqUBc7eh/T1eiDR68FMbzFNs8Sa873gD2smZsC \N \N \N 0 \N \N \N \N \N 2015-10-10 21:57:56.39486 \N \N
  411. 193 Cecile Schneider V 40255 Little Causeway \N Schneiderview LA 96694-4671 Perspiciatis Ranch chris@abshire.co 1-848-506-6336 \N 2015-10-10 21:57:56.402694 2015-10-10 21:57:56.402694 $2a$10$ZPhTbyziO99gcX1cXXH07e/1EGo7tObWu3GruAIOU9q1tsco4tvKe \N \N \N 0 \N \N \N \N \N 2015-10-10 21:57:56.400878 \N \N
  412. 194 Rocky Streich 6906 Amya Spur \N South Cliffordburgh KS 94376 Totam Ranch gino@bartoletti.name 1-419-853-9145 \N 2015-10-10 21:57:56.408228 2015-10-10 21:57:56.408228 $2a$10$A08GGw/nPP11SQR92Aj8ke4k/z/qMw41EieXUHyB8nbRwvPHaG0i2 \N \N \N 0 \N \N \N \N \N 2015-10-10 21:57:56.406578 \N \N
  413. 195 Mr. Isabelle Fahey 63944 Nayeli Loaf \N New Efrain LA 24165-8974 Ea Ranch alejandrin@koepp.io 613-509-0300 x446 \N 2015-10-10 21:57:56.413532 2015-10-10 21:57:56.413532 $2a$10$1EHWLOZdjnW7fuUSh5ZarO1HLapyJ9EZmR42ZlxeXDr5tiM5pUpya \N \N \N 0 \N \N \N \N \N 2015-10-10 21:57:56.411875 \N \N
  414. \.
  415.  
  416.  
  417. --
  418. -- Name: users_id_seq; Type: SEQUENCE SET; Schema: public; Owner: jon
  419. --
  420.  
  421. SELECT pg_catalog.setval('users_id_seq', 195, true);
  422.  
  423.  
  424. --
  425. -- Name: animals_pkey; Type: CONSTRAINT; Schema: public; Owner: jon; Tablespace:
  426. --
  427.  
  428. ALTER TABLE ONLY animals
  429. ADD CONSTRAINT animals_pkey PRIMARY KEY (id);
  430.  
  431.  
  432. --
  433. -- Name: users_pkey; Type: CONSTRAINT; Schema: public; Owner: jon; Tablespace:
  434. --
  435.  
  436. ALTER TABLE ONLY users
  437. ADD CONSTRAINT users_pkey PRIMARY KEY (id);
  438.  
  439.  
  440. --
  441. -- Name: index_animals_on_breeder_id; Type: INDEX; Schema: public; Owner: jon; Tablespace:
  442. --
  443.  
  444. CREATE INDEX index_animals_on_breeder_id ON animals USING btree (breeder_id);
  445.  
  446.  
  447. --
  448. -- Name: index_animals_on_dam_id; Type: INDEX; Schema: public; Owner: jon; Tablespace:
  449. --
  450.  
  451. CREATE INDEX index_animals_on_dam_id ON animals USING btree (dam_id);
  452.  
  453.  
  454. --
  455. -- Name: index_animals_on_owner_id; Type: INDEX; Schema: public; Owner: jon; Tablespace:
  456. --
  457.  
  458. CREATE INDEX index_animals_on_owner_id ON animals USING btree (owner_id);
  459.  
  460.  
  461. --
  462. -- Name: index_animals_on_sire_id; Type: INDEX; Schema: public; Owner: jon; Tablespace:
  463. --
  464.  
  465. CREATE INDEX index_animals_on_sire_id ON animals USING btree (sire_id);
  466.  
  467.  
  468. --
  469. -- Name: index_users_on_confirmation_token; Type: INDEX; Schema: public; Owner: jon; Tablespace:
  470. --
  471.  
  472. CREATE UNIQUE INDEX index_users_on_confirmation_token ON users USING btree (confirmation_token);
  473.  
  474.  
  475. --
  476. -- Name: index_users_on_email; Type: INDEX; Schema: public; Owner: jon; Tablespace:
  477. --
  478.  
  479. CREATE UNIQUE INDEX index_users_on_email ON users USING btree (email);
  480.  
  481.  
  482. --
  483. -- Name: index_users_on_reset_password_token; Type: INDEX; Schema: public; Owner: jon; Tablespace:
  484. --
  485.  
  486. CREATE UNIQUE INDEX index_users_on_reset_password_token ON users USING btree (reset_password_token);
  487.  
  488.  
  489. --
  490. -- Name: unique_schema_migrations; Type: INDEX; Schema: public; Owner: jon; Tablespace:
  491. --
  492.  
  493. CREATE UNIQUE INDEX unique_schema_migrations ON schema_migrations USING btree (version);
  494.  
  495.  
  496. --
  497. -- Name: public; Type: ACL; Schema: -; Owner: postgres
  498. --
  499.  
  500. REVOKE ALL ON SCHEMA public FROM PUBLIC;
  501. REVOKE ALL ON SCHEMA public FROM postgres;
  502. GRANT ALL ON SCHEMA public TO postgres;
  503. GRANT ALL ON SCHEMA public TO PUBLIC;
  504.  
  505.  
  506. --
  507. -- PostgreSQL database dump complete
  508. --
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!