summaryrefslogtreecommitdiff
path: root/db/schema.rb
diff options
context:
space:
mode:
Diffstat (limited to 'db/schema.rb')
-rw-r--r--db/schema.rb65
1 files changed, 27 insertions, 38 deletions
diff --git a/db/schema.rb b/db/schema.rb
index f841251..dac26a6 100644
--- a/db/schema.rb
+++ b/db/schema.rb
@@ -12,37 +12,34 @@
ActiveRecord::Schema.define(version: 2018_02_28_115911) do
- # These are extensions that must be enabled in order to support this database
- enable_extension "plpgsql"
-
- create_table "auths", id: :serial, force: :cascade do |t|
- t.string "one_touch_hash", limit: 255
+ create_table "auths", force: :cascade do |t|
+ t.string "one_touch_hash"
t.integer "message_id"
t.datetime "created_at"
t.datetime "updated_at"
end
- create_table "communities", id: :serial, force: :cascade do |t|
- t.string "name", limit: 255
+ create_table "communities", force: :cascade do |t|
+ t.string "name"
t.text "description"
t.datetime "created_at"
t.datetime "updated_at"
end
- create_table "community_messages", id: :serial, force: :cascade do |t|
+ create_table "community_messages", force: :cascade do |t|
t.integer "community_id"
t.integer "message_id"
t.datetime "created_at"
t.datetime "updated_at"
end
- create_table "ev_types", id: :serial, force: :cascade do |t|
- t.string "name", limit: 255
+ create_table "ev_types", force: :cascade do |t|
+ t.string "name"
t.datetime "created_at"
t.datetime "updated_at"
end
- create_table "events", id: :serial, force: :cascade do |t|
+ create_table "events", force: :cascade do |t|
t.integer "participant_id"
t.integer "message_id"
t.integer "ev_type_id"
@@ -53,15 +50,15 @@ ActiveRecord::Schema.define(version: 2018_02_28_115911) do
t.index ["participant_id"], name: "index_events_on_participant_id"
end
- create_table "identities", id: :serial, force: :cascade do |t|
+ create_table "identities", force: :cascade do |t|
t.integer "participant_id"
- t.string "name", limit: 255
+ t.string "name"
t.text "description"
t.datetime "created_at"
t.datetime "updated_at"
end
- create_table "membership_messages", id: :serial, force: :cascade do |t|
+ create_table "membership_messages", force: :cascade do |t|
t.integer "membership_id"
t.integer "message_id"
t.datetime "created_at"
@@ -70,15 +67,15 @@ ActiveRecord::Schema.define(version: 2018_02_28_115911) do
t.index ["message_id"], name: "index_membership_messages_on_message_id"
end
- create_table "memberships", id: :serial, force: :cascade do |t|
+ create_table "memberships", force: :cascade do |t|
t.integer "participant_id"
t.integer "community_id"
t.datetime "created_at"
t.datetime "updated_at"
end
- create_table "messages", id: :serial, force: :cascade do |t|
- t.string "content_type", limit: 255
+ create_table "messages", force: :cascade do |t|
+ t.string "content_type"
t.integer "sender"
t.text "body"
t.integer "ressource_id"
@@ -87,18 +84,18 @@ ActiveRecord::Schema.define(version: 2018_02_28_115911) do
t.boolean "removed", default: false
end
- create_table "organizations", id: :serial, force: :cascade do |t|
- t.string "name", limit: 255
+ create_table "organizations", force: :cascade do |t|
+ t.string "name"
t.text "description"
- t.string "abrev", limit: 255
+ t.string "abrev"
t.datetime "created_at"
t.datetime "updated_at"
end
- create_table "participants", id: :serial, force: :cascade do |t|
- t.string "name", limit: 255
- t.string "dns", limit: 255
- t.string "email", limit: 255
+ create_table "participants", force: :cascade do |t|
+ t.string "name"
+ t.string "dns"
+ t.string "email"
t.text "description"
t.integer "organization_id"
t.datetime "ttl"
@@ -110,25 +107,17 @@ ActiveRecord::Schema.define(version: 2018_02_28_115911) do
t.string "ptype"
end
- create_table "ressource_monitors", id: :serial, force: :cascade do |t|
- t.integer "lock_version", default: 0
- t.integer "monitor_counter", default: 0
- t.string "name", limit: 255
- t.datetime "created_at"
- t.datetime "updated_at"
- end
-
- create_table "ressources", id: :serial, force: :cascade do |t|
- t.string "namespace", limit: 255
- t.string "ressource", limit: 255
+ create_table "ressources", force: :cascade do |t|
+ t.string "namespace"
+ t.string "ressource"
t.boolean "postroute", default: false
t.datetime "created_at"
t.datetime "updated_at"
t.boolean "events", default: true
end
- create_table "sessions", id: :serial, force: :cascade do |t|
- t.string "session_id", limit: 255, null: false
+ create_table "sessions", force: :cascade do |t|
+ t.string "session_id", null: false
t.text "data"
t.datetime "created_at"
t.datetime "updated_at"
@@ -136,7 +125,7 @@ ActiveRecord::Schema.define(version: 2018_02_28_115911) do
t.index ["updated_at"], name: "index_sessions_on_updated_at"
end
- create_table "subparticipants", id: :serial, force: :cascade do |t|
+ create_table "subparticipants", force: :cascade do |t|
t.integer "participant_id"
t.integer "parent_id"
t.string "realm"