crates.sql

--
-- PostgreSQL database dump
--

-- Dumped from database version 9.6.1
-- Dumped by pg_dump version 9.6.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;

SET search_path = public, pg_catalog;

SET default_tablespace = '';

SET default_with_oids = false;

--
-- Name: crates; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE crates (
    id integer NOT NULL,
    name character varying NOT NULL,
    updated_at timestamp without time zone DEFAULT now() NOT NULL,
    created_at timestamp without time zone DEFAULT now() NOT NULL,
    downloads integer DEFAULT 0 NOT NULL,
    max_version character varying DEFAULT '0.0.0'::character varying,
    description character varying,
    homepage character varying,
    documentation character varying,
    readme character varying,
    textsearchable_index_col tsvector,
    license character varying,
    repository character varying,
    max_upload_size integer
);


ALTER TABLE crates OWNER TO postgres;

--
-- Name: packages_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE packages_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE packages_id_seq OWNER TO postgres;

--
-- Name: packages_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE packages_id_seq OWNED BY crates.id;


--
-- Name: versions; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE versions (
    id integer NOT NULL,
    crate_id integer NOT NULL,
    num character varying NOT NULL,
    updated_at timestamp without time zone DEFAULT now() NOT NULL,
    created_at timestamp without time zone DEFAULT now() NOT NULL,
    downloads integer DEFAULT 0 NOT NULL,
    features character varying,
    yanked boolean DEFAULT false
);


ALTER TABLE versions OWNER TO postgres;

--
-- Name: versions_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE versions_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE versions_id_seq OWNER TO postgres;

--
-- Name: versions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE versions_id_seq OWNED BY versions.id;


--
-- Name: crates id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY crates ALTER COLUMN id SET DEFAULT nextval('packages_id_seq'::regclass);


--
-- Name: versions id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY versions ALTER COLUMN id SET DEFAULT nextval('versions_id_seq'::regclass);


--
-- Data for Name: crates; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY crates (id, name, updated_at, created_at, downloads, max_version, description, homepage, documentation, readme, textsearchable_index_col, license, repository, max_upload_size) FROM stdin;
2	sassers	2017-01-15 16:39:40.523303	2017-01-05 20:59:02.954339	0	0.5.4	sassy sass	\N	\N	[![Build Status](https://travis-ci.org/carols10cents/sassers.svg?branch=master)](https://travis-ci.org/carols10cents/sassers)\n\n# Sassers\n\nSassy sassers sassing sass.\n	'/carols10cents/sassers.svg?branch=master)](https://travis-ci.org/carols10cents/sassers)':8 'build':4 'sass':3C,12,13 'sasser':1A,9,11 'sassi':2C,10 'status':5 'travis-ci.org':7 'travis-ci.org/carols10cents/sassers.svg?branch=master)](https://travis-ci.org/carols10cents/sassers)':6	MIT	\N	\N
6	piston	2017-01-20 21:23:21.99032	2017-01-15 16:42:02.551369	0	0.5.8	The Piston game engine core libraries	\N	\N	[![Build Status](https://travis-ci.org/carols10cents/sassers.svg?branch=master)](https://travis-ci.org/carols10cents/sassers)\n\n# Sassers\n\nSassy sassers sassing sass.\n	'/carols10cents/sassers.svg?branch=master)](https://travis-ci.org/carols10cents/sassers)':18 'api':7B 'build':4B,14 'build-depend':3B 'core':12C 'depend':5B 'engin':11C 'game':6B,10C 'librari':13C 'piston':1A,9C 'sass':22,23 'sasser':19,21 'sassi':20 'status':15 'stuff':2B 'travis-ci.org':17 'travis-ci.org/carols10cents/sassers.svg?branch=master)](https://travis-ci.org/carols10cents/sassers)':16	MIT	\N	\N
3	rustc-serialize	2017-01-08 20:58:49.580741	2017-01-08 20:54:53.967725	0	0.3.23	Generic serialization/deserialization support corresponding to the\n`derive(RustcEncodable, RustcDecodable)` mode in the compiler. Also includes\nsupport for hex, base64, and json encoding and decoding.\n	https://github.com/rust-lang/rustc-serialize	https://doc.rust-lang.org/rustc-serialize	# rustc-serialize\n\nSerialization and deserialization support provided by the compiler in the form\nof `derive(RustcEncodable, RustcDecodable)`.\n\n[![Linux Build Status](https://travis-ci.org/rust-lang-nursery/rustc-serialize.svg?branch=master)](https://travis-ci.org/rust-lang-nursery/rustc-serialize)\n[![Windows Build Status](https://ci.appveyor.com/api/projects/status/ka194de75aapwpft?svg=true)](https://ci.appveyor.com/project/alexcrichton/rustc-serialize)\n\n[Documentation](https://doc.rust-lang.org/rustc-serialize)\n\n## Usage\n\nAdd this to your `Cargo.toml`:\n\n```toml\n[dependencies]\nrustc-serialize = "0.3"\n```\n\nand this to your crate root:\n\n```rust\nextern crate rustc_serialize;\n```\n	'/api/projects/status/ka194de75aapwpft?svg=true)](https://ci.appveyor.com/project/alexcrichton/rustc-serialize)':57 '/rust-lang-nursery/rustc-serialize.svg?branch=master)](https://travis-ci.org/rust-lang-nursery/rustc-serialize)':51 '/rustc-serialize)':61 '0.3':73 'add':63 'also':17C 'base64':22C 'build':47,53 'cargo.toml':67 'ci.appveyor.com':56 'ci.appveyor.com/api/projects/status/ka194de75aapwpft?svg=true)](https://ci.appveyor.com/project/alexcrichton/rustc-serialize)':55 'compil':16C,38 'correspond':7C 'crate':78,82 'decod':27C 'depend':69 'deriv':10C,43 'deseri':33 'doc.rust-lang.org':60 'doc.rust-lang.org/rustc-serialize)':59 'document':58 'encod':25C 'extern':81 'form':41 'generic':4C 'hex':21C 'includ':18C 'json':24C 'linux':46 'mode':13C 'provid':35 'root':79 'rust':80 'rustc':2A,29,71,83 'rustc-seri':1A,28,70 'rustcdecod':12C,45 'rustcencod':11C,44 'serial':3A,30,31,72,84 'serialization/deserialization':5C 'status':48,54 'support':6C,19C,34 'toml':68 'travis-ci.org':50 'travis-ci.org/rust-lang-nursery/rustc-serialize.svg?branch=master)](https://travis-ci.org/rust-lang-nursery/rustc-serialize)':49 'usag':62 'window':52	MIT/Apache-2.0	https://github.com/rust-lang/rustc-serialize	\N
4	gcc	2017-01-08 21:03:03.812855	2017-01-08 21:01:59.684677	0	0.3.42	A build-time dependency for Cargo build scripts to assist in invoking the native\nC compiler to compile native C code into a static archive to be linked into Rust\ncode.\n	\N	http://alexcrichton.com/gcc-rs	\N	'archiv':30C 'assist':15C 'build':3B,7C,12C 'build-depend':2B 'build-tim':6C 'c':20C,25C 'cargo':11C 'code':26C,36C 'compil':21C,23C 'depend':4B,9C 'gcc':1A 'invok':17C 'link':33C 'nativ':19C,24C 'rust':35C 'script':13C 'static':29C 'time':8C	MIT/Apache-2.0	https://github.com/alexcrichton/gcc-rs	\N
5	sxd-xpath	2017-01-15 16:40:29.518007	2017-01-15 16:40:29.518007	0	0.5.5	sassy sass	\N	\N	[![Build Status](https://travis-ci.org/carols10cents/sassers.svg?branch=master)](https://travis-ci.org/carols10cents/sassers)\n\n# Sassers\n\nSassy sassers sassing sass.\n	'/carols10cents/sassers.svg?branch=master)](https://travis-ci.org/carols10cents/sassers)':10 'build':6 'sass':5C,14,15 'sasser':11,13 'sassi':4C,12 'status':7 'sxd':2A 'sxd-xpath':1A 'travis-ci.org':9 'travis-ci.org/carols10cents/sassers.svg?branch=master)](https://travis-ci.org/carols10cents/sassers)':8 'xpath':3A	MIT	\N	\N
\.


--
-- Name: packages_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('packages_id_seq', 6, true);


--
-- Data for Name: versions; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY versions (id, crate_id, num, updated_at, created_at, downloads, features, yanked) FROM stdin;
2	2	0.5.0	2017-01-05 20:59:02.954339	2017-01-05 20:59:02.954339	0	{}	f
3	2	0.5.1	2017-01-05 21:02:47.988208	2017-01-05 21:02:47.988208	0	{}	f
4	2	0.5.2	2017-01-06 15:24:36.67595	2017-01-06 15:24:36.67595	0	{}	f
5	3	0.3.22	2017-01-08 20:54:53.967725	2017-01-08 20:54:53.967725	0	{}	f
6	3	0.3.23	2017-01-08 20:58:49.580741	2017-01-08 20:58:49.580741	0	{}	f
7	4	0.3.41	2017-01-08 21:01:59.684677	2017-01-08 21:01:59.684677	0	{}	f
8	4	0.3.42	2017-01-08 21:03:03.812855	2017-01-08 21:03:03.812855	0	{}	f
9	2	0.5.3	2017-01-15 16:38:20.529096	2017-01-15 16:38:20.529096	0	{}	f
10	2	0.5.4	2017-01-15 16:39:40.523303	2017-01-15 16:39:40.523303	0	{}	f
11	5	0.5.5	2017-01-15 16:40:29.518007	2017-01-15 16:40:29.518007	0	{}	f
12	6	0.5.6	2017-01-15 16:42:02.551369	2017-01-15 16:42:02.551369	0	{}	f
13	6	0.5.7	2017-01-15 16:44:02.683542	2017-01-15 16:44:02.683542	0	{}	f
14	6	0.5.8	2017-01-20 21:23:21.99032	2017-01-20 21:23:21.99032	0	{}	f
\.


--
-- Name: versions_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('versions_id_seq', 14, true);


--
-- Name: crates packages_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY crates
    ADD CONSTRAINT packages_pkey PRIMARY KEY (id);


--
-- Name: versions unique_num; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY versions
    ADD CONSTRAINT unique_num UNIQUE (crate_id, num);


--
-- Name: versions versions_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY versions
    ADD CONSTRAINT versions_pkey PRIMARY KEY (id);


--
-- Name: index_crate_created_at; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX index_crate_created_at ON crates USING btree (created_at);


--
-- Name: index_crate_downloads; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX index_crate_downloads ON crates USING btree (downloads);


--
-- Name: index_crate_updated_at; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX index_crate_updated_at ON crates USING btree (updated_at);


--
-- Name: index_crates_name; Type: INDEX; Schema: public; Owner: postgres
--

CREATE UNIQUE INDEX index_crates_name ON crates USING btree (canon_crate_name((name)::text));


--
-- Name: index_crates_name_search; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX index_crates_name_search ON crates USING gin (textsearchable_index_col);


--
-- Name: index_version_crate_id; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX index_version_crate_id ON versions USING btree (crate_id);


--
-- Name: index_version_num; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX index_version_num ON versions USING btree (num);


--
-- Name: crates trigger_crates_set_updated_at; Type: TRIGGER; Schema: public; Owner: postgres
--

CREATE TRIGGER trigger_crates_set_updated_at BEFORE UPDATE ON crates FOR EACH ROW EXECUTE PROCEDURE set_updated_at_ignore_downloads();


--
-- Name: crates trigger_crates_tsvector_update; Type: TRIGGER; Schema: public; Owner: postgres
--

CREATE TRIGGER trigger_crates_tsvector_update BEFORE INSERT OR UPDATE ON crates FOR EACH ROW EXECUTE PROCEDURE trigger_crates_name_search();


--
-- Name: versions trigger_versions_set_updated_at; Type: TRIGGER; Schema: public; Owner: postgres
--

CREATE TRIGGER trigger_versions_set_updated_at BEFORE UPDATE ON versions FOR EACH ROW EXECUTE PROCEDURE set_updated_at_ignore_downloads();


--
-- Name: versions fk_versions_crate_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY versions
    ADD CONSTRAINT fk_versions_crate_id FOREIGN KEY (crate_id) REFERENCES crates(id);


--
-- PostgreSQL database dump complete
--