diff options
Diffstat (limited to 'db/schema.rb')
-rw-r--r-- | db/schema.rb | 74 |
1 files changed, 37 insertions, 37 deletions
diff --git a/db/schema.rb b/db/schema.rb index bf624dd..3712855 100644 --- a/db/schema.rb +++ b/db/schema.rb @@ -16,34 +16,34 @@ ActiveRecord::Schema.define(version: 20150420210728) do # These are extensions that must be enabled in order to support this database enable_extension "plpgsql" - create_table "auths", force: true do |t| - t.string "one_touch_hash" + create_table "auths", force: :cascade do |t| + t.string "one_touch_hash", limit: 255 t.integer "message_id" t.datetime "created_at" t.datetime "updated_at" end - create_table "communities", force: true do |t| - t.string "name" + create_table "communities", force: :cascade do |t| + t.string "name", limit: 255 t.text "description" t.datetime "created_at" t.datetime "updated_at" end - create_table "community_messages", force: true 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", force: true do |t| - t.string "name" + create_table "ev_types", force: :cascade do |t| + t.string "name", limit: 255 t.datetime "created_at" t.datetime "updated_at" end - create_table "events", force: true do |t| + create_table "events", force: :cascade do |t| t.integer "participant_id" t.integer "message_id" t.integer "ev_type_id" @@ -52,15 +52,15 @@ ActiveRecord::Schema.define(version: 20150420210728) do t.integer "lock_version", default: 0 end - create_table "identities", force: true do |t| + create_table "identities", force: :cascade do |t| t.integer "participant_id" - t.string "name" + t.string "name", limit: 255 t.text "description" t.datetime "created_at" t.datetime "updated_at" end - create_table "membership_messages", force: true do |t| + create_table "membership_messages", force: :cascade do |t| t.integer "membership_id" t.integer "message_id" t.datetime "created_at" @@ -68,65 +68,65 @@ ActiveRecord::Schema.define(version: 20150420210728) do t.integer "lock_version", default: 0 end - create_table "memberships", force: true 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", force: true do |t| - t.string "content_type" + create_table "messages", force: :cascade do |t| + t.string "content_type", limit: 255 t.integer "sender" t.text "body" t.integer "ressource_id" t.datetime "created_at" t.datetime "updated_at" - t.boolean "removed", default: false + t.boolean "removed", default: false end - create_table "organizations", force: true do |t| - t.string "name" + create_table "organizations", force: :cascade do |t| + t.string "name", limit: 255 t.text "description" - t.string "abrev" + t.string "abrev", limit: 255 t.datetime "created_at" t.datetime "updated_at" end - create_table "participants", force: true do |t| - t.string "name" - t.string "dns" - t.string "email" + create_table "participants", force: :cascade do |t| + t.string "name", limit: 255 + t.string "dns", limit: 255 + t.string "email", limit: 255 t.text "description" t.integer "organization_id" t.datetime "ttl" - t.boolean "anonymous", default: false, null: false + t.boolean "anonymous", default: false, null: false t.datetime "created_at" t.datetime "updated_at" - t.boolean "community_selfrouting", default: false - t.boolean "events_", default: true + t.boolean "community_selfrouting", default: false + t.boolean "events_", default: true t.string "ptype" end - create_table "ressource_monitors", force: true do |t| - t.integer "lock_version", default: 0 - t.integer "monitor_counter", default: 0 - t.string "name" + create_table "ressource_monitors", 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", force: true do |t| - t.string "namespace" - t.string "ressource" - t.boolean "postroute", default: false + create_table "ressources", force: :cascade do |t| + t.string "namespace", limit: 255 + t.string "ressource", limit: 255 + t.boolean "postroute", default: false t.datetime "created_at" t.datetime "updated_at" - t.boolean "events", default: true + t.boolean "events", default: true end - create_table "sessions", force: true do |t| - t.string "session_id", null: false + create_table "sessions", force: :cascade do |t| + t.string "session_id", limit: 255, null: false t.text "data" t.datetime "created_at" t.datetime "updated_at" @@ -135,7 +135,7 @@ ActiveRecord::Schema.define(version: 20150420210728) do add_index "sessions", ["session_id"], name: "index_sessions_on_session_id", using: :btree add_index "sessions", ["updated_at"], name: "index_sessions_on_updated_at", using: :btree - create_table "subparticipants", force: true do |t| + create_table "subparticipants", force: :cascade do |t| t.integer "participant_id" t.integer "parent_id" t.string "realm" |