From 2dd3a24d39e35cfe398685c4abdfd9bb85dc2a0c Mon Sep 17 00:00:00 2001
From: Dennis Eriksen <d@ennis.no>
Date: Fri, 1 Nov 2019 13:31:38 +0100
Subject: Initial commit

---
 schema.sql | 131 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 131 insertions(+)
 create mode 100644 schema.sql

(limited to 'schema.sql')

diff --git a/schema.sql b/schema.sql
new file mode 100644
index 0000000..ca1a0be
--- /dev/null
+++ b/schema.sql
@@ -0,0 +1,131 @@
+--
+-- PostgreSQL database dump
+--
+
+-- Dumped from database version 11.5 (Ubuntu 11.5-1)
+-- Dumped by pg_dump version 11.5 (Ubuntu 11.5-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;
+SELECT pg_catalog.set_config('search_path', '', false);
+SET check_function_bodies = false;
+SET xmloption = content;
+SET client_min_messages = warning;
+SET row_security = off;
+
+--
+-- Name: purl; Type: DATABASE; Schema: -; Owner: postgres
+--
+
+CREATE DATABASE purl WITH TEMPLATE = template0 ENCODING = 'UTF8' LC_COLLATE = 'en_IE.UTF-8' LC_CTYPE = 'en_IE.UTF-8';
+
+
+ALTER DATABASE purl OWNER TO postgres;
+
+\connect purl
+
+SET statement_timeout = 0;
+SET lock_timeout = 0;
+SET idle_in_transaction_session_timeout = 0;
+SET client_encoding = 'UTF8';
+SET standard_conforming_strings = on;
+SELECT pg_catalog.set_config('search_path', '', false);
+SET check_function_bodies = false;
+SET xmloption = content;
+SET client_min_messages = warning;
+SET row_security = off;
+
+SET default_tablespace = '';
+
+SET default_with_oids = false;
+
+--
+-- Name: shorts; Type: TABLE; Schema: public; Owner: postgres
+--
+
+CREATE TABLE public.shorts (
+    id integer NOT NULL,
+    url text NOT NULL,
+    short character varying NOT NULL,
+    created timestamp with time zone DEFAULT now() NOT NULL,
+    created_by character varying,
+    count integer DEFAULT 0,
+    last_visited timestamp with time zone
+);
+
+
+ALTER TABLE public.shorts OWNER TO postgres;
+
+--
+-- Name: shorts_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
+--
+
+CREATE SEQUENCE public.shorts_id_seq
+    AS integer
+    START WITH 1
+    INCREMENT BY 1
+    NO MINVALUE
+    NO MAXVALUE
+    CACHE 1;
+
+
+ALTER TABLE public.shorts_id_seq OWNER TO postgres;
+
+--
+-- Name: shorts_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
+--
+
+ALTER SEQUENCE public.shorts_id_seq OWNED BY public.shorts.id;
+
+
+--
+-- Name: shorts id; Type: DEFAULT; Schema: public; Owner: postgres
+--
+
+ALTER TABLE ONLY public.shorts ALTER COLUMN id SET DEFAULT nextval('public.shorts_id_seq'::regclass);
+
+
+--
+-- Name: shorts shorts_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
+--
+
+ALTER TABLE ONLY public.shorts
+    ADD CONSTRAINT shorts_pkey PRIMARY KEY (id);
+
+
+--
+-- Name: shorts shorts_short_key; Type: CONSTRAINT; Schema: public; Owner: postgres
+--
+
+ALTER TABLE ONLY public.shorts
+    ADD CONSTRAINT shorts_short_key UNIQUE (short);
+
+
+--
+-- Name: DATABASE purl; Type: ACL; Schema: -; Owner: postgres
+--
+
+GRANT CONNECT ON DATABASE purl TO "www-data";
+
+
+--
+-- Name: TABLE shorts; Type: ACL; Schema: public; Owner: postgres
+--
+
+GRANT SELECT,INSERT,UPDATE ON TABLE public.shorts TO "www-data";
+
+
+--
+-- Name: SEQUENCE shorts_id_seq; Type: ACL; Schema: public; Owner: postgres
+--
+
+GRANT SELECT,USAGE ON SEQUENCE public.shorts_id_seq TO "www-data";
+
+
+--
+-- PostgreSQL database dump complete
+--
+
-- 
cgit v1.2.3