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);
 
 
 --