From eb3177b0d8de10f316ac595dff3b8165cf828796 Mon Sep 17 00:00:00 2001
From: Christopher Baines <mail@cbaines.net>
Date: Sat, 27 Jan 2018 23:23:05 +0000
Subject: Initial commit

---
 .../20180127201423_create_mini_environments.rb     |  9 ++++
 db/migrate/20180127201504_create_users.rb          | 14 +++++
 db/migrate/20180127220312_add_que.rb               | 13 +++++
 ...0180127222948_create_finished_terraform_jobs.rb | 10 ++++
 db/schema.rb                                       | 59 ++++++++++++++++++++++
 5 files changed, 105 insertions(+)
 create mode 100644 db/migrate/20180127201423_create_mini_environments.rb
 create mode 100644 db/migrate/20180127201504_create_users.rb
 create mode 100644 db/migrate/20180127220312_add_que.rb
 create mode 100644 db/migrate/20180127222948_create_finished_terraform_jobs.rb
 create mode 100644 db/schema.rb

(limited to 'db')

diff --git a/db/migrate/20180127201423_create_mini_environments.rb b/db/migrate/20180127201423_create_mini_environments.rb
new file mode 100644
index 0000000..3ad95e7
--- /dev/null
+++ b/db/migrate/20180127201423_create_mini_environments.rb
@@ -0,0 +1,9 @@
+class CreateMiniEnvironments < ActiveRecord::Migration[5.1]
+  def change
+    create_table :mini_environments do |t|
+      t.string :name
+
+      t.timestamps
+    end
+  end
+end
diff --git a/db/migrate/20180127201504_create_users.rb b/db/migrate/20180127201504_create_users.rb
new file mode 100644
index 0000000..23c109e
--- /dev/null
+++ b/db/migrate/20180127201504_create_users.rb
@@ -0,0 +1,14 @@
+class CreateUsers < ActiveRecord::Migration[5.1]
+  def change
+    create_table :users do |t|
+      t.string   :name
+      t.string   :email
+      t.string   :uid
+      t.string   :organisation_slug
+      t.string   :organisation_content_id
+      t.text     :permissions
+      t.boolean  :remotely_signed_out, :default => false
+      t.boolean  :disabled, :default => false
+    end
+  end
+end
diff --git a/db/migrate/20180127220312_add_que.rb b/db/migrate/20180127220312_add_que.rb
new file mode 100644
index 0000000..55cfd21
--- /dev/null
+++ b/db/migrate/20180127220312_add_que.rb
@@ -0,0 +1,13 @@
+# frozen_string_literal: true
+
+class AddQue < ActiveRecord::Migration[4.2]
+  def self.up
+    # The current version as of this migration's creation.
+    Que.migrate! :version => 3
+  end
+
+  def self.down
+    # Completely removes Que's job queue.
+    Que.migrate! :version => 0
+  end
+end
diff --git a/db/migrate/20180127222948_create_finished_terraform_jobs.rb b/db/migrate/20180127222948_create_finished_terraform_jobs.rb
new file mode 100644
index 0000000..e88ebe4
--- /dev/null
+++ b/db/migrate/20180127222948_create_finished_terraform_jobs.rb
@@ -0,0 +1,10 @@
+class CreateFinishedTerraformJobs < ActiveRecord::Migration[5.1]
+  def change
+    create_table :finished_terraform_jobs do |t|
+      t.integer :mini_environment_id
+      t.string :job_class
+
+      t.timestamps
+    end
+  end
+end
diff --git a/db/schema.rb b/db/schema.rb
new file mode 100644
index 0000000..70325bb
--- /dev/null
+++ b/db/schema.rb
@@ -0,0 +1,59 @@
+# This file is auto-generated from the current state of the database. Instead
+# of editing this file, please use the migrations feature of Active Record to
+# incrementally modify your database, and then regenerate this schema definition.
+#
+# Note that this schema.rb definition is the authoritative source for your
+# database schema. If you need to create the application database on another
+# system, you should be using db:schema:load, not running all the migrations
+# from scratch. The latter is a flawed and unsustainable approach (the more migrations
+# you'll amass, the slower it'll run and the greater likelihood for issues).
+#
+# It's strongly recommended that you check this file into your version control system.
+
+ActiveRecord::Schema.define(version: 20180127222948) do
+
+  # These are extensions that must be enabled in order to support this database
+  enable_extension "plpgsql"
+
+  create_table "finished_terraform_jobs", force: :cascade do |t|
+    t.integer "mini_environment_id"
+    t.string "job_class"
+    t.datetime "created_at", null: false
+    t.datetime "updated_at", null: false
+  end
+
+  create_table "mini_environments", force: :cascade do |t|
+    t.string "name"
+    t.datetime "created_at", null: false
+    t.datetime "updated_at", null: false
+  end
+
+  create_table "minienvironments", force: :cascade do |t|
+    t.string "name"
+    t.datetime "created_at", null: false
+    t.datetime "updated_at", null: false
+  end
+
+  create_table "que_jobs", primary_key: ["queue", "priority", "run_at", "job_id"], force: :cascade, comment: "3" do |t|
+    t.integer "priority", limit: 2, default: 100, null: false
+    t.datetime "run_at", default: -> { "now()" }, null: false
+    t.bigserial "job_id", null: false
+    t.text "job_class", null: false
+    t.json "args", default: [], null: false
+    t.integer "error_count", default: 0, null: false
+    t.text "last_error"
+    t.text "queue", default: "", null: false
+  end
+
+  create_table "users", force: :cascade do |t|
+    t.string "name"
+    t.string "email"
+    t.string "uid"
+    t.string "organisation_slug"
+    t.string "organisation_content_id"
+    t.text "permissions"
+    t.boolean "remotely_signed_out", default: false
+    t.boolean "disabled", default: false
+  end
+
+end
-- 
cgit v1.2.3