WIP: subparticipants.

2 files changed, 41 insertions, 1 deletions

diff --git a/db/migrate/20140525164346_create_subparticipants.rb b/db/migrate/20140525164346_create_subparticipants.rb
new file mode 100644
index 0000000..6e2e49d
--- /dev/null
+++ b/db/migrate/20140525164346_create_subparticipants.rb
@@ -0,0 +1,32 @@
+# Copyright (C) 2014 Heiko Bernloehr (FreeIT.de).
+#
+# This file is part of ECS.
+#
+# ECS is free software: you can redistribute it and/or modify it
+# under the terms of the GNU Affero General Public License as
+# published by the Free Software Foundation, either version 3 of
+# the License, or (at your option) any later version.
+#
+# ECS is distributed in the hope that it will be useful, but
+# WITHOUT ANY WARRANTY; without even the implied warranty of
+# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
+# Affero General Public License for more details.
+#
+# You should have received a copy of the GNU Affero General Public
+# License along with ECS. If not, see <http://www.gnu.org/licenses/>.
+
+class CreateSubparticipants < ActiveRecord::Migration
+  def self.up
+    create_table :subparticipants do |t|
+      t.integer :participant_id
+      t.integer :parent_id
+      t.string :realm
+
+      t.timestamps
+    end
+  end
+
+  def self.down
+    drop_table :subparticipants
+  end
+end
diff --git a/db/schema.rb b/db/schema.rb
index 74f16be..254e303 100644
--- a/db/schema.rb
+++ b/db/schema.rb
@@ -9,7 +9,7 @@
 #
 # It's strongly recommended to check this file into your version control system.
 
-ActiveRecord::Schema.define(:version => 20130813144307) do
+ActiveRecord::Schema.define(:version => 20140525164346) do
 
   create_table "auths", :force => true do |t|
     t.string   "one_touch_hash"
@@ -121,4 +121,12 @@ ActiveRecord::Schema.define(:version => 20130813144307) do
   add_index "sessions", ["session_id"], :name => "index_sessions_on_session_id"
   add_index "sessions", ["updated_at"], :name => "index_sessions_on_updated_at"
 
+  create_table "subparticipants", :force => true do |t|
+    t.integer  "participant_id"
+    t.integer  "parent_id"
+    t.string   "realm"
+    t.datetime "created_at"
+    t.datetime "updated_at"
+  end
+
 end