| |   |
| 0 | | # This file is auto-generated from the current state of the database. Instead of editing this file, |
| 1 | | # please use the migrations feature of ActiveRecord to incrementally modify your database, and |
| 2 | | # then regenerate this schema definition. |
| 3 | | # |
| 4 | | # Note that this schema.rb definition is the authoritative source for your database schema. If you need |
| 5 | | # to create the application database on another system, you should be using db:schema:load, not running |
| 6 | | # all the migrations from scratch. The latter is a flawed and unsustainable approach (the more migrations |
| 7 | | # you'll amass, the slower it'll run and the greater likelihood for issues). |
| 8 | | # |
| 9 | | # It's strongly recommended to check this file into your version control system. |
| 10 | | |
| 11 | | ActiveRecord::Schema.define(:version => 19) do |
| 12 | | |
| 13 | | create_table "comments", :force => true do |t| |
| 14 | | t.integer "user_id", :null => false |
| 15 | | t.integer "repository_id", :null => false |
| 16 | | t.string "sha1", :default => "", :null => false |
| 17 | | t.text "body" |
| 18 | | t.datetime "created_at" |
| 19 | | t.datetime "updated_at" |
| 20 | | end |
| 21 | | |
| 22 | | add_index "comments", ["user_id"], :name => "index_comments_on_user_id" |
| 23 | | add_index "comments", ["repository_id"], :name => "index_comments_on_repository_id" |
| 24 | | add_index "comments", ["sha1"], :name => "index_comments_on_sha1" |
| 25 | | |
| 26 | | create_table "committerships", :force => true do |t| |
| 27 | | t.integer "user_id" |
| 28 | | t.integer "repository_id" |
| 29 | | t.integer "kind", :default => 2 |
| 30 | | t.datetime "created_at" |
| 31 | | t.datetime "updated_at" |
| 32 | | end |
| 33 | | |
| 34 | | add_index "committerships", ["user_id"], :name => "index_permissions_on_user_id" |
| 35 | | add_index "committerships", ["repository_id"], :name => "index_permissions_on_repository_id" |
| 36 | | |
| 37 | | create_table "projects", :force => true do |t| |
| 38 | | t.string "title" |
| 39 | | t.text "description" |
| 40 | | t.integer "user_id" |
| 41 | | t.datetime "created_at" |
| 42 | | t.datetime "updated_at" |
| 43 | | t.string "slug" |
| 44 | | t.string "license" |
| 45 | | t.string "home_url" |
| 46 | | t.string "mailinglist_url" |
| 47 | | t.string "bugtracker_url" |
| 48 | | end |
| 49 | | |
| 50 | | add_index "projects", ["slug"], :name => "index_projects_on_slug", :unique => true |
| 51 | | add_index "projects", ["title"], :name => "index_projects_on_name" |
| 52 | | add_index "projects", ["user_id"], :name => "index_projects_on_user_id" |
| 53 | | |
| 54 | | create_table "repositories", :force => true do |t| |
| 55 | | t.string "name" |
| 56 | | t.integer "project_id" |
| 57 | | t.integer "user_id" |
| 58 | | t.datetime "created_at" |
| 59 | | t.datetime "updated_at" |
| 60 | | t.boolean "mainline", :default => false |
| 61 | | t.integer "parent_id" |
| 62 | | t.boolean "ready", :default => false |
| 63 | | end |
| 64 | | |
| 65 | | add_index "repositories", ["name"], :name => "index_repositories_on_name" |
| 66 | | add_index "repositories", ["project_id"], :name => "index_repositories_on_project_id" |
| 67 | | add_index "repositories", ["user_id"], :name => "index_repositories_on_user_id" |
| 68 | | add_index "repositories", ["parent_id"], :name => "index_repositories_on_parent_id" |
| 69 | | add_index "repositories", ["ready"], :name => "index_repositories_on_ready" |
| 70 | | |
| 71 | | create_table "ssh_keys", :force => true do |t| |
| 72 | | t.integer "user_id" |
| 73 | | t.text "key" |
| 74 | | t.datetime "created_at" |
| 75 | | t.datetime "updated_at" |
| 76 | | t.boolean "ready", :default => false |
| 77 | | end |
| 78 | | |
| 79 | | add_index "ssh_keys", ["user_id"], :name => "index_ssh_keys_on_user_id" |
| 80 | | |
| 81 | | create_table "taggings", :force => true do |t| |
| 82 | | t.integer "tag_id" |
| 83 | | t.integer "taggable_id" |
| 84 | | t.string "taggable_type" |
| 85 | | t.datetime "created_at" |
| 86 | | end |
| 87 | | |
| 88 | | add_index "taggings", ["tag_id"], :name => "index_taggings_on_tag_id" |
| 89 | | add_index "taggings", ["taggable_id", "taggable_type"], :name => "index_taggings_on_taggable_id_and_taggable_type" |
| 90 | | |
| 91 | | create_table "tags", :force => true do |t| |
| 92 | | t.string "name" |
| 93 | | end |
| 94 | | |
| 95 | | add_index "tags", ["name"], :name => "index_tags_on_name", :unique => true |
| 96 | | |
| 97 | | create_table "tasks", :force => true do |t| |
| 98 | | t.string "target_class" |
| 99 | | t.string "command" |
| 100 | | t.text "arguments" |
| 101 | | t.boolean "performed", :default => false |
| 102 | | t.datetime "performed_at" |
| 103 | | t.datetime "created_at" |
| 104 | | t.datetime "updated_at" |
| 105 | | t.integer "target_id" |
| 106 | | end |
| 107 | | |
| 108 | | add_index "tasks", ["performed"], :name => "index_tasks_on_performed" |
| 109 | | |
| 110 | | create_table "users", :force => true do |t| |
| 111 | | t.string "login" |
| 112 | | t.string "email" |
| 113 | | t.string "crypted_password", :limit => 40 |
| 114 | | t.string "salt", :limit => 40 |
| 115 | | t.datetime "created_at" |
| 116 | | t.datetime "updated_at" |
| 117 | | t.string "remember_token" |
| 118 | | t.datetime "remember_token_expires_at" |
| 119 | | t.string "activation_code", :limit => 40 |
| 120 | | t.datetime "activated_at" |
| 121 | | t.integer "ssh_key_id" |
| 122 | | t.string "fullname" |
| 123 | | t.text "url" |
| 124 | | end |
| 125 | | |
| 126 | | add_index "users", ["login"], :name => "index_users_on_login" |
| 127 | | add_index "users", ["email"], :name => "index_users_on_email" |
| 128 | | add_index "users", ["ssh_key_id"], :name => "index_users_on_ssh_key_id" |
| 129 | | |
| 130 | | end |
| toggle raw diff |
--- a/db/schema.rb
+++ /dev/null
@@ -1,131 +0,0 @@
-# This file is auto-generated from the current state of the database. Instead of editing this file,
-# please use the migrations feature of ActiveRecord 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 => 19) do
-
- create_table "comments", :force => true do |t|
- t.integer "user_id", :null => false
- t.integer "repository_id", :null => false
- t.string "sha1", :default => "", :null => false
- t.text "body"
- t.datetime "created_at"
- t.datetime "updated_at"
- end
-
- add_index "comments", ["user_id"], :name => "index_comments_on_user_id"
- add_index "comments", ["repository_id"], :name => "index_comments_on_repository_id"
- add_index "comments", ["sha1"], :name => "index_comments_on_sha1"
-
- create_table "committerships", :force => true do |t|
- t.integer "user_id"
- t.integer "repository_id"
- t.integer "kind", :default => 2
- t.datetime "created_at"
- t.datetime "updated_at"
- end
-
- add_index "committerships", ["user_id"], :name => "index_permissions_on_user_id"
- add_index "committerships", ["repository_id"], :name => "index_permissions_on_repository_id"
-
- create_table "projects", :force => true do |t|
- t.string "title"
- t.text "description"
- t.integer "user_id"
- t.datetime "created_at"
- t.datetime "updated_at"
- t.string "slug"
- t.string "license"
- t.string "home_url"
- t.string "mailinglist_url"
- t.string "bugtracker_url"
- end
-
- add_index "projects", ["slug"], :name => "index_projects_on_slug", :unique => true
- add_index "projects", ["title"], :name => "index_projects_on_name"
- add_index "projects", ["user_id"], :name => "index_projects_on_user_id"
-
- create_table "repositories", :force => true do |t|
- t.string "name"
- t.integer "project_id"
- t.integer "user_id"
- t.datetime "created_at"
- t.datetime "updated_at"
- t.boolean "mainline", :default => false
- t.integer "parent_id"
- t.boolean "ready", :default => false
- end
-
- add_index "repositories", ["name"], :name => "index_repositories_on_name"
- add_index "repositories", ["project_id"], :name => "index_repositories_on_project_id"
- add_index "repositories", ["user_id"], :name => "index_repositories_on_user_id"
- add_index "repositories", ["parent_id"], :name => "index_repositories_on_parent_id"
- add_index "repositories", ["ready"], :name => "index_repositories_on_ready"
-
- create_table "ssh_keys", :force => true do |t|
- t.integer "user_id"
- t.text "key"
- t.datetime "created_at"
- t.datetime "updated_at"
- t.boolean "ready", :default => false
- end
-
- add_index "ssh_keys", ["user_id"], :name => "index_ssh_keys_on_user_id"
-
- create_table "taggings", :force => true do |t|
- t.integer "tag_id"
- t.integer "taggable_id"
- t.string "taggable_type"
- t.datetime "created_at"
- end
-
- add_index "taggings", ["tag_id"], :name => "index_taggings_on_tag_id"
- add_index "taggings", ["taggable_id", "taggable_type"], :name => "index_taggings_on_taggable_id_and_taggable_type"
-
- create_table "tags", :force => true do |t|
- t.string "name"
- end
-
- add_index "tags", ["name"], :name => "index_tags_on_name", :unique => true
-
- create_table "tasks", :force => true do |t|
- t.string "target_class"
- t.string "command"
- t.text "arguments"
- t.boolean "performed", :default => false
- t.datetime "performed_at"
- t.datetime "created_at"
- t.datetime "updated_at"
- t.integer "target_id"
- end
-
- add_index "tasks", ["performed"], :name => "index_tasks_on_performed"
-
- create_table "users", :force => true do |t|
- t.string "login"
- t.string "email"
- t.string "crypted_password", :limit => 40
- t.string "salt", :limit => 40
- t.datetime "created_at"
- t.datetime "updated_at"
- t.string "remember_token"
- t.datetime "remember_token_expires_at"
- t.string "activation_code", :limit => 40
- t.datetime "activated_at"
- t.integer "ssh_key_id"
- t.string "fullname"
- t.text "url"
- end
-
- add_index "users", ["login"], :name => "index_users_on_login"
- add_index "users", ["email"], :name => "index_users_on_email"
- add_index "users", ["ssh_key_id"], :name => "index_users_on_ssh_key_id"
-
-end |