Mercurial > zeropaste
diff db/structure.sql @ 463:4608d12ebe03
Sync database
author | nanaya <me@nanaya.pro> |
---|---|
date | Mon, 10 Dec 2018 02:35:08 +0900 |
parents | b1ef80121c79 |
children | 92929378413e |
line wrap: on
line diff
--- a/db/structure.sql Sun Dec 09 03:15:59 2018 +0900 +++ b/db/structure.sql Mon Dec 10 02:35:08 2018 +0900 @@ -8,34 +8,6 @@ SET client_min_messages = warning; SET row_security = off; --- --- 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'; - - --- --- Name: hstore; Type: EXTENSION; Schema: -; Owner: - --- - -CREATE EXTENSION IF NOT EXISTS hstore WITH SCHEMA public; - - --- --- Name: EXTENSION hstore; Type: COMMENT; Schema: -; Owner: - --- - -COMMENT ON EXTENSION hstore IS 'data type for storing sets of (key, value) pairs'; - - SET default_tablespace = ''; SET default_with_oids = false; @@ -61,8 +33,8 @@ ip character varying(50) NOT NULL, paste text NOT NULL, paste_hash character varying(150) NOT NULL, - created_at timestamp with time zone NOT NULL, - updated_at timestamp with time zone NOT NULL, + created_at timestamp with time zone, + updated_at timestamp with time zone, key character varying(100), secret character varying(100), language character varying(100) @@ -130,10 +102,10 @@ -- --- Name: index_pastes_on_ip_and_hash; Type: INDEX; Schema: public; Owner: - +-- Name: index_pastes_on_ip_and_paste_hash; Type: INDEX; Schema: public; Owner: - -- -CREATE UNIQUE INDEX index_pastes_on_ip_and_hash ON public.pastes USING btree (ip, paste_hash); +CREATE UNIQUE INDEX index_pastes_on_ip_and_paste_hash ON public.pastes USING btree (ip, paste_hash); --