Created
June 10, 2014 01:01
-
-
Save benschwarz/84720a43cb0f368c076f to your computer and use it in GitHub Desktop.
Bower registry schema
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 | |
-- | |
-- Dumped from database version 9.3.4 | |
-- Dumped by pg_dump version 9.3.4 | |
-- Started on 2014-06-10 10:42:59 EST | |
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; | |
SET search_path = public, pg_catalog; | |
DROP INDEX public.packages_name_index; | |
DROP INDEX public.migrations_name_index; | |
ALTER TABLE ONLY public.packages DROP CONSTRAINT packages_pkey; | |
ALTER TABLE ONLY public.packages DROP CONSTRAINT packages_name_key; | |
ALTER TABLE ONLY public.migrations DROP CONSTRAINT migrations_pkey; | |
ALTER TABLE public.packages ALTER COLUMN id DROP DEFAULT; | |
ALTER TABLE public.migrations ALTER COLUMN id DROP DEFAULT; | |
DROP SEQUENCE public.packages_id_seq; | |
DROP TABLE public.packages; | |
DROP SEQUENCE public.migrations_id_seq; | |
DROP TABLE public.migrations; | |
DROP EXTENSION plpgsql; | |
DROP SCHEMA public; | |
-- | |
-- TOC entry 6 (class 2615 OID 1152730) | |
-- Name: public; Type: SCHEMA; Schema: -; Owner: - | |
-- | |
CREATE SCHEMA public; | |
-- | |
-- TOC entry 2220 (class 0 OID 0) | |
-- Dependencies: 6 | |
-- Name: SCHEMA public; Type: COMMENT; Schema: -; Owner: - | |
-- | |
COMMENT ON SCHEMA public IS 'standard public schema'; | |
-- | |
-- TOC entry 174 (class 3079 OID 1152731) | |
-- Name: plpgsql; Type: EXTENSION; Schema: -; Owner: - | |
-- | |
CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog; | |
-- | |
-- TOC entry 2221 (class 0 OID 0) | |
-- Dependencies: 174 | |
-- 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; | |
-- | |
-- TOC entry 170 (class 1259 OID 1152736) | |
-- Name: migrations; Type: TABLE; Schema: public; Owner: -; Tablespace: | |
-- | |
CREATE TABLE migrations ( | |
id integer NOT NULL, | |
name text NOT NULL, | |
ran_at timestamp without time zone | |
); | |
-- | |
-- TOC entry 171 (class 1259 OID 1152742) | |
-- Name: migrations_id_seq; Type: SEQUENCE; Schema: public; Owner: - | |
-- | |
CREATE SEQUENCE migrations_id_seq | |
START WITH 1 | |
INCREMENT BY 1 | |
NO MINVALUE | |
NO MAXVALUE | |
CACHE 1; | |
-- | |
-- TOC entry 2222 (class 0 OID 0) | |
-- Dependencies: 171 | |
-- Name: migrations_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - | |
-- | |
ALTER SEQUENCE migrations_id_seq OWNED BY migrations.id; | |
-- | |
-- TOC entry 172 (class 1259 OID 1152744) | |
-- Name: packages; Type: TABLE; Schema: public; Owner: -; Tablespace: | |
-- | |
CREATE TABLE packages ( | |
id integer NOT NULL, | |
name text NOT NULL, | |
url text NOT NULL, | |
created_at timestamp without time zone, | |
hits integer DEFAULT 0 | |
); | |
-- | |
-- TOC entry 173 (class 1259 OID 1152751) | |
-- Name: packages_id_seq; Type: SEQUENCE; Schema: public; Owner: - | |
-- | |
CREATE SEQUENCE packages_id_seq | |
START WITH 1 | |
INCREMENT BY 1 | |
NO MINVALUE | |
NO MAXVALUE | |
CACHE 1; | |
-- | |
-- TOC entry 2223 (class 0 OID 0) | |
-- Dependencies: 173 | |
-- Name: packages_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - | |
-- | |
ALTER SEQUENCE packages_id_seq OWNED BY packages.id; | |
-- | |
-- TOC entry 2097 (class 2604 OID 1152753) | |
-- Name: id; Type: DEFAULT; Schema: public; Owner: - | |
-- | |
ALTER TABLE ONLY migrations ALTER COLUMN id SET DEFAULT nextval('migrations_id_seq'::regclass); | |
-- | |
-- TOC entry 2099 (class 2604 OID 1152754) | |
-- Name: id; Type: DEFAULT; Schema: public; Owner: - | |
-- | |
ALTER TABLE ONLY packages ALTER COLUMN id SET DEFAULT nextval('packages_id_seq'::regclass); | |
-- | |
-- TOC entry 2102 (class 2606 OID 1152756) | |
-- Name: migrations_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
-- | |
ALTER TABLE ONLY migrations | |
ADD CONSTRAINT migrations_pkey PRIMARY KEY (id); | |
-- | |
-- TOC entry 2105 (class 2606 OID 1152758) | |
-- Name: packages_name_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
-- | |
ALTER TABLE ONLY packages | |
ADD CONSTRAINT packages_name_key UNIQUE (name); | |
-- | |
-- TOC entry 2107 (class 2606 OID 1152760) | |
-- Name: packages_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
-- | |
ALTER TABLE ONLY packages | |
ADD CONSTRAINT packages_pkey PRIMARY KEY (id); | |
-- | |
-- TOC entry 2100 (class 1259 OID 1152761) | |
-- Name: migrations_name_index; Type: INDEX; Schema: public; Owner: -; Tablespace: | |
-- | |
CREATE INDEX migrations_name_index ON migrations USING btree (name); | |
-- | |
-- TOC entry 2103 (class 1259 OID 1152762) | |
-- Name: packages_name_index; Type: INDEX; Schema: public; Owner: -; Tablespace: | |
-- | |
CREATE INDEX packages_name_index ON packages USING btree (name); | |
-- Completed on 2014-06-10 10:42:59 EST | |
-- | |
-- PostgreSQL database dump complete | |
-- | |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment