diff options
author | Heiko Bernloehr <Heiko.Bernloehr@FreeIT.de> | 2017-03-15 00:28:08 +0100 |
---|---|---|
committer | Heiko Bernloehr <Heiko.Bernloehr@FreeIT.de> | 2017-03-15 00:28:08 +0100 |
commit | 2e5767e71d86278517ca4ba313be1bcb85ae1dd4 (patch) | |
tree | 452895f1081121e748b3edb34e9cffe3b102e135 | |
parent | 3f284100ba0b709881c4b6ae80c9c3ec4caa4d3d (diff) | |
download | ecs-2e5767e71d86278517ca4ba313be1bcb85ae1dd4.tar.gz ecs-2e5767e71d86278517ca4ba313be1bcb85ae1dd4.zip |
Initial schema.rb
-rw-r--r-- | db/schema.rb | 146 |
1 files changed, 146 insertions, 0 deletions
diff --git a/db/schema.rb b/db/schema.rb new file mode 100644 index 0000000..bf624dd --- /dev/null +++ b/db/schema.rb @@ -0,0 +1,146 @@ +# encoding: UTF-8 +# This file is auto-generated from the current state of the database. Instead +# 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). +# +# It's strongly recommended that you check this file into your version control system. + +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" + t.integer "message_id" + t.datetime "created_at" + t.datetime "updated_at" + end + + create_table "communities", force: true do |t| + t.string "name" + t.text "description" + t.datetime "created_at" + t.datetime "updated_at" + end + + create_table "community_messages", force: true 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" + t.datetime "created_at" + t.datetime "updated_at" + end + + create_table "events", force: true 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 + end + + create_table "identities", force: true do |t| + t.integer "participant_id" + t.string "name" + t.text "description" + t.datetime "created_at" + t.datetime "updated_at" + end + + create_table "membership_messages", force: true do |t| + t.integer "membership_id" + t.integer "message_id" + t.datetime "created_at" + t.datetime "updated_at" + t.integer "lock_version", default: 0 + end + + create_table "memberships", force: true 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" + t.integer "sender" + t.text "body" + t.integer "ressource_id" + t.datetime "created_at" + t.datetime "updated_at" + t.boolean "removed", default: false + end + + create_table "organizations", force: true do |t| + t.string "name" + t.text "description" + t.string "abrev" + 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" + t.text "description" + t.integer "organization_id" + t.datetime "ttl" + 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" + end + + create_table "ressource_monitors", force: true do |t| + t.integer "lock_version", default: 0 + t.integer "monitor_counter", default: 0 + t.string "name" + 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 + t.datetime "created_at" + t.datetime "updated_at" + t.boolean "events", default: true + end + + create_table "sessions", force: true do |t| + t.string "session_id", null: false + t.text "data" + t.datetime "created_at" + t.datetime "updated_at" + end + + 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| + t.integer "participant_id" + t.integer "parent_id" + t.string "realm" + t.datetime "created_at" + t.datetime "updated_at" + end + +end |