diff options
| author | mo khan <mo@mokhan.ca> | 2015-05-19 07:55:04 -0700 |
|---|---|---|
| committer | mo khan <mo@mokhan.ca> | 2015-05-21 21:26:10 -0600 |
| commit | e89bc7cb1467063ce65e3e78d77c8f4635132d0f (patch) | |
| tree | 4e7664935ebe396ac0b048e0421e15a034f15b61 /db/schema.rb | |
| parent | b769c085489679d362ccacd4e5d514f663379089 (diff) | |
create a workout record for each recors in the sqlite db.
Diffstat (limited to 'db/schema.rb')
| -rw-r--r-- | db/schema.rb | 47 |
1 files changed, 46 insertions, 1 deletions
diff --git a/db/schema.rb b/db/schema.rb index f0d933e..20dda14 100644 --- a/db/schema.rb +++ b/db/schema.rb @@ -11,16 +11,61 @@ # # It's strongly recommended that you check this file into your version control system. -ActiveRecord::Schema.define(version: 20150124163233) do +ActiveRecord::Schema.define(version: 20150522004907) do # These are extensions that must be enabled in order to support this database enable_extension "plpgsql" enable_extension "uuid-ossp" + create_table "exercise_sessions", id: :uuid, default: "uuid_generate_v4()", force: :cascade do |t| + t.uuid "training_session_id", null: false + t.uuid "exercise_workout_id", null: false + t.datetime "created_at", null: false + t.datetime "updated_at", null: false + t.text "sets", default: [], array: true + end + + create_table "exercise_workouts", id: :uuid, default: "uuid_generate_v4()", force: :cascade do |t| + t.uuid "exercise_id", null: false + t.uuid "workout_id", null: false + t.integer "sets", null: false + t.integer "repetitions", null: false + t.datetime "created_at", null: false + t.datetime "updated_at", null: false + end + + create_table "exercises", id: :uuid, default: "uuid_generate_v4()", force: :cascade do |t| + t.string "name", null: false + t.datetime "created_at", null: false + t.datetime "updated_at", null: false + end + + create_table "programs", id: :uuid, default: "uuid_generate_v4()", force: :cascade do |t| + t.string "name", null: false + t.datetime "created_at", null: false + t.datetime "updated_at", null: false + end + + create_table "training_sessions", id: :uuid, default: "uuid_generate_v4()", force: :cascade do |t| + t.uuid "user_id", null: false + t.datetime "created_at", null: false + t.datetime "updated_at", null: false + t.uuid "workout_id", null: false + end + + add_index "training_sessions", ["user_id"], name: "index_training_sessions_on_user_id", using: :btree + create_table "users", id: :uuid, default: "uuid_generate_v4()", force: :cascade do |t| t.string "username", null: false t.string "email", null: false t.string "password_digest" end + create_table "workouts", id: :uuid, default: "uuid_generate_v4()", force: :cascade do |t| + t.uuid "program_id", null: false + t.string "name", null: false + t.datetime "created_at", null: false + t.datetime "updated_at", null: false + end + end |
