changeset 463:4608d12ebe03

Sync database
author nanaya <me@nanaya.pro>
date Mon, 10 Dec 2018 02:35:08 +0900
parents e8d6c631a55b
children f11862e58af4
files db/migrate/20120826180414_create_pastes.rb db/migrate/20120826182012_change_column_name_to_conform_ar.rb db/migrate/20120905072325_set_limit_on_paste.rb db/migrate/20120905074204_return_not_null_to_paste.rb db/migrate/20130201150322_add_key_to_paste.rb db/migrate/20130511133450_add_secret_to_pastes.rb db/migrate/20130512032335_add_index_to_pastes_secret.rb db/migrate/20150914054154_add_language_to_paste.rb db/migrate/20150916161622_strict_character_lengths.rb db/structure.sql
diffstat 10 files changed, 13 insertions(+), 41 deletions(-) [+]
line wrap: on
line diff
--- a/db/migrate/20120826180414_create_pastes.rb	Sun Dec 09 03:15:59 2018 +0900
+++ b/db/migrate/20120826180414_create_pastes.rb	Mon Dec 10 02:35:08 2018 +0900
@@ -1,5 +1,5 @@
 # Create basic table.
-class CreatePastes < ActiveRecord::Migration
+class CreatePastes < ActiveRecord::Migration[4.2]
   def change
     create_table :pastes do |t|
       t.string :ip, :null => false
--- a/db/migrate/20120826182012_change_column_name_to_conform_ar.rb	Sun Dec 09 03:15:59 2018 +0900
+++ b/db/migrate/20120826182012_change_column_name_to_conform_ar.rb	Mon Dec 10 02:35:08 2018 +0900
@@ -1,5 +1,5 @@
 # Hash shouldn't be used as column name.
-class ChangeColumnNameToConformAr < ActiveRecord::Migration
+class ChangeColumnNameToConformAr < ActiveRecord::Migration[4.2]
   def change
     rename_column :pastes, :hash, :paste_hash
   end
--- a/db/migrate/20120905072325_set_limit_on_paste.rb	Sun Dec 09 03:15:59 2018 +0900
+++ b/db/migrate/20120905072325_set_limit_on_paste.rb	Mon Dec 10 02:35:08 2018 +0900
@@ -1,5 +1,5 @@
 # Reduced size as needed.
-class SetLimitOnPaste < ActiveRecord::Migration
+class SetLimitOnPaste < ActiveRecord::Migration[4.2]
   def change
     change_table :pastes do |t|
       t.change :ip, :string, :limit => 50
--- a/db/migrate/20120905074204_return_not_null_to_paste.rb	Sun Dec 09 03:15:59 2018 +0900
+++ b/db/migrate/20120905074204_return_not_null_to_paste.rb	Mon Dec 10 02:35:08 2018 +0900
@@ -1,5 +1,5 @@
 # Add constraints.
-class ReturnNotNullToPaste < ActiveRecord::Migration
+class ReturnNotNullToPaste < ActiveRecord::Migration[4.2]
   def change
     change_table :pastes do |t|
       t.change :ip, :string, :limit => 50, :null => false
--- a/db/migrate/20130201150322_add_key_to_paste.rb	Sun Dec 09 03:15:59 2018 +0900
+++ b/db/migrate/20130201150322_add_key_to_paste.rb	Mon Dec 10 02:35:08 2018 +0900
@@ -1,5 +1,5 @@
 # For deletion.
-class AddKeyToPaste < ActiveRecord::Migration
+class AddKeyToPaste < ActiveRecord::Migration[4.2]
   def change
     add_column :pastes, :key, :string
   end
--- a/db/migrate/20130511133450_add_secret_to_pastes.rb	Sun Dec 09 03:15:59 2018 +0900
+++ b/db/migrate/20130511133450_add_secret_to_pastes.rb	Mon Dec 10 02:35:08 2018 +0900
@@ -1,5 +1,5 @@
 # Private paste column.
-class AddSecretToPastes < ActiveRecord::Migration
+class AddSecretToPastes < ActiveRecord::Migration[4.2]
   def change
     add_column :pastes, :secret, :string
   end
--- a/db/migrate/20130512032335_add_index_to_pastes_secret.rb	Sun Dec 09 03:15:59 2018 +0900
+++ b/db/migrate/20130512032335_add_index_to_pastes_secret.rb	Mon Dec 10 02:35:08 2018 +0900
@@ -1,5 +1,5 @@
 # Speed up lookup.
-class AddIndexToPastesSecret < ActiveRecord::Migration
+class AddIndexToPastesSecret < ActiveRecord::Migration[4.2]
   def change
     add_index :pastes, :secret
   end
--- a/db/migrate/20150914054154_add_language_to_paste.rb	Sun Dec 09 03:15:59 2018 +0900
+++ b/db/migrate/20150914054154_add_language_to_paste.rb	Mon Dec 10 02:35:08 2018 +0900
@@ -1,4 +1,4 @@
-class AddLanguageToPaste < ActiveRecord::Migration
+class AddLanguageToPaste < ActiveRecord::Migration[4.2]
   def change
     add_column :pastes, :language, :string
   end
--- a/db/migrate/20150916161622_strict_character_lengths.rb	Sun Dec 09 03:15:59 2018 +0900
+++ b/db/migrate/20150916161622_strict_character_lengths.rb	Mon Dec 10 02:35:08 2018 +0900
@@ -1,4 +1,4 @@
-class StrictCharacterLengths < ActiveRecord::Migration
+class StrictCharacterLengths < ActiveRecord::Migration[4.2]
   def change
     change_table :pastes do |t|
       t.change :key, :string, :limit => 100
--- 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);
 
 
 --