From 7789e2138fc0479846c20bc68d68973636a4a760 Mon Sep 17 00:00:00 2001
From: Kelly Rauchenberger <fefferburbia@gmail.com>
Date: Tue, 12 Mar 2019 21:50:00 -0400
Subject: Started game tracker

---
 db/migrate/20190312193025_install_audited.rb | 30 ++++++++++++++++++++++++++++
 db/migrate/20190312193154_create_games.rb    | 13 ++++++++++++
 2 files changed, 43 insertions(+)
 create mode 100644 db/migrate/20190312193025_install_audited.rb
 create mode 100644 db/migrate/20190312193154_create_games.rb

(limited to 'db/migrate')

diff --git a/db/migrate/20190312193025_install_audited.rb b/db/migrate/20190312193025_install_audited.rb
new file mode 100644
index 0000000..ef5487e
--- /dev/null
+++ b/db/migrate/20190312193025_install_audited.rb
@@ -0,0 +1,30 @@
+class InstallAudited < ActiveRecord::Migration[5.2]
+  def self.up
+    create_table :audits, :force => true do |t|
+      t.column :auditable_id, :integer
+      t.column :auditable_type, :string
+      t.column :associated_id, :integer
+      t.column :associated_type, :string
+      t.column :user_id, :integer
+      t.column :user_type, :string
+      t.column :username, :string
+      t.column :action, :string
+      t.column :audited_changes, :text
+      t.column :version, :integer, :default => 0
+      t.column :comment, :string
+      t.column :remote_address, :string
+      t.column :request_uuid, :string
+      t.column :created_at, :datetime
+    end
+
+    add_index :audits, [:auditable_type, :auditable_id, :version], :name => 'auditable_index'
+    add_index :audits, [:associated_type, :associated_id], :name => 'associated_index'
+    add_index :audits, [:user_id, :user_type], :name => 'user_index'
+    add_index :audits, :request_uuid
+    add_index :audits, :created_at
+  end
+
+  def self.down
+    drop_table :audits
+  end
+end
diff --git a/db/migrate/20190312193154_create_games.rb b/db/migrate/20190312193154_create_games.rb
new file mode 100644
index 0000000..de30492
--- /dev/null
+++ b/db/migrate/20190312193154_create_games.rb
@@ -0,0 +1,13 @@
+class CreateGames < ActiveRecord::Migration[5.2]
+  def change
+    create_table :games do |t|
+      t.string :title
+      t.string :status
+      t.text :progress
+      t.text :description
+      t.integer :score
+
+      t.timestamps
+    end
+  end
+end
-- 
cgit 1.4.1