summaryrefslogtreecommitdiff
path: root/db/schema.rb
diff options
context:
space:
mode:
Diffstat (limited to 'db/schema.rb')
-rw-r--r--db/schema.rb148
1 files changed, 74 insertions, 74 deletions
diff --git a/db/schema.rb b/db/schema.rb
index 589638c..86185a7 100644
--- a/db/schema.rb
+++ b/db/schema.rb
@@ -2,144 +2,144 @@
# of editing this file, please use the migrations feature of Active Record to
# incrementally modify your database, and then regenerate this schema definition.
#
-# Note that this schema.rb definition is the authoritative source for your
-# database schema. If you need to create the application database on another
-# system, you should be using db:schema:load, not running all the migrations
-# from scratch. The latter is a flawed and unsustainable approach (the more migrations
-# you'll amass, the slower it'll run and the greater likelihood for issues).
+# This file is the source Rails uses to define your schema when running `rails
+# db:schema:load`. When creating a new database, `rails db:schema:load` tends to
+# be faster and is potentially less error prone than running all of your
+# migrations from scratch. Old migrations may fail to apply correctly if those
+# migrations use external dependencies or application code.
#
# It's strongly recommended that you check this file into your version control system.
-ActiveRecord::Schema.define(version: 20180228115911) do
+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", force: :cascade do |t|
- t.string "one_touch_hash", limit: 255
- t.integer "message_id"
+ create_table "auths", id: :serial, 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: :cascade do |t|
- t.string "name", limit: 255
- t.text "description"
+ create_table "communities", id: :serial, 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: :cascade do |t|
- t.integer "community_id"
- t.integer "message_id"
+ create_table "community_messages", id: :serial, 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: :cascade do |t|
- t.string "name", limit: 255
+ create_table "ev_types", id: :serial, force: :cascade do |t|
+ t.string "name", limit: 255
t.datetime "created_at"
t.datetime "updated_at"
end
- create_table "events", force: :cascade do |t|
- t.integer "participant_id"
- t.integer "message_id"
- t.integer "ev_type_id"
+ create_table "events", id: :serial, force: :cascade do |t|
+ t.integer "participant_id"
+ t.integer "message_id"
+ t.integer "ev_type_id"
t.datetime "created_at"
t.datetime "updated_at"
- t.integer "lock_version", default: 0
- t.index ["message_id"], name: "index_events_on_message_id", using: :btree
- t.index ["participant_id"], name: "index_events_on_participant_id", using: :btree
+ t.integer "lock_version", default: 0
+ t.index ["message_id"], name: "index_events_on_message_id"
+ t.index ["participant_id"], name: "index_events_on_participant_id"
end
- create_table "identities", force: :cascade do |t|
- t.integer "participant_id"
- t.string "name", limit: 255
- t.text "description"
+ create_table "identities", id: :serial, force: :cascade do |t|
+ t.integer "participant_id"
+ t.string "name", limit: 255
+ t.text "description"
t.datetime "created_at"
t.datetime "updated_at"
end
- create_table "membership_messages", force: :cascade do |t|
- t.integer "membership_id"
- t.integer "message_id"
+ create_table "membership_messages", id: :serial, force: :cascade do |t|
+ t.integer "membership_id"
+ t.integer "message_id"
t.datetime "created_at"
t.datetime "updated_at"
- t.integer "lock_version", default: 0
- t.index ["message_id"], name: "index_membership_messages_on_message_id", using: :btree
+ t.integer "lock_version", default: 0
+ t.index ["message_id"], name: "index_membership_messages_on_message_id"
end
- create_table "memberships", force: :cascade do |t|
- t.integer "participant_id"
- t.integer "community_id"
+ create_table "memberships", id: :serial, 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: :cascade do |t|
- t.string "content_type", limit: 255
- t.integer "sender"
- t.text "body"
- t.integer "ressource_id"
+ create_table "messages", id: :serial, 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: :cascade do |t|
- t.string "name", limit: 255
- t.text "description"
- t.string "abrev", limit: 255
+ create_table "organizations", id: :serial, force: :cascade do |t|
+ t.string "name", limit: 255
+ t.text "description"
+ t.string "abrev", limit: 255
t.datetime "created_at"
t.datetime "updated_at"
end
- 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"
+ create_table "participants", id: :serial, 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.string "ptype"
+ t.boolean "community_selfrouting", default: false
+ t.boolean "events_", default: true
+ t.string "ptype"
end
- 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
+ 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", force: :cascade do |t|
- t.string "namespace", limit: 255
- t.string "ressource", limit: 255
- t.boolean "postroute", default: false
+ create_table "ressources", id: :serial, 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: :cascade do |t|
- t.string "session_id", limit: 255, null: false
- t.text "data"
+ create_table "sessions", id: :serial, force: :cascade do |t|
+ t.string "session_id", limit: 255, null: false
+ t.text "data"
t.datetime "created_at"
t.datetime "updated_at"
- t.index ["session_id"], name: "index_sessions_on_session_id", using: :btree
- t.index ["updated_at"], name: "index_sessions_on_updated_at", using: :btree
+ t.index ["session_id"], name: "index_sessions_on_session_id"
+ t.index ["updated_at"], name: "index_sessions_on_updated_at"
end
- create_table "subparticipants", force: :cascade do |t|
- t.integer "participant_id"
- t.integer "parent_id"
- t.string "realm"
+ create_table "subparticipants", id: :serial, force: :cascade do |t|
+ t.integer "participant_id"
+ t.integer "parent_id"
+ t.string "realm"
t.datetime "created_at"
t.datetime "updated_at"
end
FreeIT.de    Technologie-Beratung • Systemsoftware • Schulung    Dipl.-Ing. Heiko Bernlöhr