diff options
Diffstat (limited to 'db/schema.rb')
-rw-r--r-- | db/schema.rb | 65 |
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" |