diff options
author | Wu Cheng-Han | 2015-05-08 11:47:41 +0800 |
---|---|---|
committer | Wu Cheng-Han | 2015-05-08 11:47:41 +0800 |
commit | d1e0b1e9ed32a998983e69b5c58aeab530b10573 (patch) | |
tree | 8aa2fa3e402e03cfb055f1bf4602d184d1db97e9 | |
parent | 4b0ca55eb79e963523eb6c8197825e9e8ae904e2 (diff) |
Added database schema from pg_dump
-rw-r--r-- | hackmd_schema.sql | 77 |
1 files changed, 77 insertions, 0 deletions
diff --git a/hackmd_schema.sql b/hackmd_schema.sql new file mode 100644 index 00000000..139ce15b --- /dev/null +++ b/hackmd_schema.sql @@ -0,0 +1,77 @@ +-- +-- 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; + +-- +-- Name: plpgsql; Type: EXTENSION; Schema: -; Owner: +-- + +CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog; + + +-- +-- 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; + +-- +-- Name: notes; Type: TABLE; Schema: public; Owner: postgres; Tablespace: +-- + +CREATE TABLE notes ( + id character varying(256) NOT NULL, + owner character varying(256) NOT NULL, + content text, + title character varying(256), + create_time timestamp without time zone DEFAULT now() NOT NULL, + update_time timestamp without time zone DEFAULT now() NOT NULL +); + + +ALTER TABLE notes OWNER TO "postgres"; + +-- +-- Name: notes_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: +-- + +ALTER TABLE ONLY notes + ADD CONSTRAINT notes_pkey PRIMARY KEY (id); + + +-- +-- Name: unique_notes; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: +-- + +ALTER TABLE ONLY notes + ADD CONSTRAINT unique_notes UNIQUE (id); + + +-- +-- Name: public; Type: ACL; Schema: -; Owner: postgres +-- + +REVOKE ALL ON SCHEMA public FROM PUBLIC; +REVOKE ALL ON SCHEMA public FROM "postgres"; +GRANT ALL ON SCHEMA public TO "postgres"; +GRANT ALL ON SCHEMA public TO PUBLIC; + + +-- +-- PostgreSQL database dump complete +-- + |