X-Git-Url: https://git.njae.me.uk/?a=blobdiff_plain;f=db%2Fschema.rb;h=e5e49d93770dc24f0aaa7146efb21c717c1c0822;hb=2e4e591080e228dec676acf40b9e7bc4b044b8bc;hp=53e465e2b86e208f844f364e8118cd42c0451324;hpb=173183d0b7ffc7143d0f0bfe40694cfa2522a95f;p=depot.git diff --git a/db/schema.rb b/db/schema.rb index 53e465e..e5e49d9 100644 --- a/db/schema.rb +++ b/db/schema.rb @@ -1,64 +1,64 @@ -# 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 to check this file into your version control system. - -ActiveRecord::Schema.define(:version => 20090311202750) do - - create_table "line_items", :force => true do |t| - t.integer "product_id", :null => false - t.integer "order_id", :null => false - t.integer "quantity", :null => false - t.decimal "total_price", :precision => 8, :scale => 2, :null => false - t.datetime "created_at" - t.datetime "updated_at" - end - - add_index "line_items", ["order_id"], :name => "fk_line_item_orders" - add_index "line_items", ["product_id"], :name => "fk_line_item_products" - - create_table "orders", :force => true do |t| - t.string "name" - t.text "address" - t.string "email" - t.string "pay_type", :limit => 10 - t.datetime "created_at" - t.datetime "updated_at" - end - - create_table "products", :force => true do |t| - t.string "title" - t.text "description" - t.string "image_url" - t.datetime "created_at" - t.datetime "updated_at" - t.decimal "price", :precision => 8, :scale => 2, :default => 0.0 - t.date "date_available" - t.date "date_available_until" - 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" - add_index "sessions", ["updated_at"], :name => "index_sessions_on_updated_at" - - create_table "users", :force => true do |t| - t.string "name" - t.string "hashed_password" - t.string "salt" - t.datetime "created_at" - t.datetime "updated_at" - end - -end +# 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 to check this file into your version control system. + +ActiveRecord::Schema.define(:version => 20090311202750) do + + create_table "line_items", :force => true do |t| + t.integer "product_id", :null => false + t.integer "order_id", :null => false + t.integer "quantity", :null => false + t.decimal "total_price", :precision => 8, :scale => 2, :null => false + t.datetime "created_at" + t.datetime "updated_at" + end + + add_index "line_items", ["order_id"], :name => "fk_line_item_orders" + add_index "line_items", ["product_id"], :name => "fk_line_item_products" + + create_table "orders", :force => true do |t| + t.string "name" + t.text "address" + t.string "email" + t.string "pay_type", :limit => 10 + t.datetime "created_at" + t.datetime "updated_at" + end + + create_table "products", :force => true do |t| + t.string "title" + t.text "description" + t.string "image_url" + t.datetime "created_at" + t.datetime "updated_at" + t.decimal "price", :precision => 8, :scale => 2, :default => 0.0 + t.date "date_available" + t.date "date_available_until" + end + + create_table "sessions", :force => true do |t| + t.string "session_id", :default => "", :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" + add_index "sessions", ["updated_at"], :name => "index_sessions_on_updated_at" + + create_table "users", :force => true do |t| + t.string "name" + t.string "hashed_password" + t.string "salt" + t.datetime "created_at" + t.datetime "updated_at" + end + +end