BigW Consortium Gitlab

20121220064453_init_schema.rb 12.7 KB
Newer Older
1
# rubocop:disable all
2 3
class InitSchema < ActiveRecord::Migration
  def up
4

5 6 7 8 9 10 11 12 13 14 15
    create_table "events", force: true do |t|
      t.string   "target_type"
      t.integer  "target_id"
      t.string   "title"
      t.text     "data"
      t.integer  "project_id"
      t.datetime "created_at"
      t.datetime "updated_at"
      t.integer  "action"
      t.integer  "author_id"
    end
16

17 18 19 20 21 22
    add_index "events", ["action"], name: "index_events_on_action", using: :btree
    add_index "events", ["author_id"], name: "index_events_on_author_id", using: :btree
    add_index "events", ["created_at"], name: "index_events_on_created_at", using: :btree
    add_index "events", ["project_id"], name: "index_events_on_project_id", using: :btree
    add_index "events", ["target_id"], name: "index_events_on_target_id", using: :btree
    add_index "events", ["target_type"], name: "index_events_on_target_type", using: :btree
23

24 25 26 27 28 29 30 31 32 33 34 35 36
    create_table "issues", force: true do |t|
      t.string   "title"
      t.integer  "assignee_id"
      t.integer  "author_id"
      t.integer  "project_id"
      t.datetime "created_at"
      t.datetime "updated_at"
      t.boolean  "closed",       default: false, null: false
      t.integer  "position",     default: 0
      t.string   "branch_name"
      t.text     "description"
      t.integer  "milestone_id"
    end
37

38 39 40 41 42 43 44
    add_index "issues", ["assignee_id"], name: "index_issues_on_assignee_id", using: :btree
    add_index "issues", ["author_id"], name: "index_issues_on_author_id", using: :btree
    add_index "issues", ["closed"], name: "index_issues_on_closed", using: :btree
    add_index "issues", ["created_at"], name: "index_issues_on_created_at", using: :btree
    add_index "issues", ["milestone_id"], name: "index_issues_on_milestone_id", using: :btree
    add_index "issues", ["project_id"], name: "index_issues_on_project_id", using: :btree
    add_index "issues", ["title"], name: "index_issues_on_title", using: :btree
45

46 47 48 49 50 51 52 53 54
    create_table "keys", force: true do |t|
      t.integer  "user_id"
      t.datetime "created_at"
      t.datetime "updated_at"
      t.text     "key"
      t.string   "title"
      t.string   "identifier"
      t.integer  "project_id"
    end
55

56 57 58
    add_index "keys", ["identifier"], name: "index_keys_on_identifier", using: :btree
    add_index "keys", ["project_id"], name: "index_keys_on_project_id", using: :btree
    add_index "keys", ["user_id"], name: "index_keys_on_user_id", using: :btree
59

60 61 62 63 64 65 66 67 68 69
    create_table "merge_requests", force: true do |t|
      t.string   "target_branch",                                    null: false
      t.string   "source_branch",                                    null: false
      t.integer  "project_id",                                       null: false
      t.integer  "author_id"
      t.integer  "assignee_id"
      t.string   "title"
      t.boolean  "closed",                           default: false, null: false
      t.datetime "created_at"
      t.datetime "updated_at"
70 71
      t.text     "st_commits"
      t.text     "st_diffs"
72 73 74 75
      t.boolean  "merged",                           default: false, null: false
      t.integer  "state",                            default: 1,     null: false
      t.integer  "milestone_id"
    end
76

77 78 79 80 81 82 83 84 85
    add_index "merge_requests", ["assignee_id"], name: "index_merge_requests_on_assignee_id", using: :btree
    add_index "merge_requests", ["author_id"], name: "index_merge_requests_on_author_id", using: :btree
    add_index "merge_requests", ["closed"], name: "index_merge_requests_on_closed", using: :btree
    add_index "merge_requests", ["created_at"], name: "index_merge_requests_on_created_at", using: :btree
    add_index "merge_requests", ["milestone_id"], name: "index_merge_requests_on_milestone_id", using: :btree
    add_index "merge_requests", ["project_id"], name: "index_merge_requests_on_project_id", using: :btree
    add_index "merge_requests", ["source_branch"], name: "index_merge_requests_on_source_branch", using: :btree
    add_index "merge_requests", ["target_branch"], name: "index_merge_requests_on_target_branch", using: :btree
    add_index "merge_requests", ["title"], name: "index_merge_requests_on_title", using: :btree
86

87 88 89 90 91 92 93 94 95
    create_table "milestones", force: true do |t|
      t.string   "title",                       null: false
      t.integer  "project_id",                  null: false
      t.text     "description"
      t.date     "due_date"
      t.boolean  "closed",      default: false, null: false
      t.datetime "created_at"
      t.datetime "updated_at"
    end
96

97 98
    add_index "milestones", ["due_date"], name: "index_milestones_on_due_date", using: :btree
    add_index "milestones", ["project_id"], name: "index_milestones_on_project_id", using: :btree
99

100 101 102 103 104 105 106 107
    create_table "namespaces", force: true do |t|
      t.string   "name",       null: false
      t.string   "path",       null: false
      t.integer  "owner_id",   null: false
      t.datetime "created_at"
      t.datetime "updated_at"
      t.string   "type"
    end
108

109 110 111 112
    add_index "namespaces", ["name"], name: "index_namespaces_on_name", using: :btree
    add_index "namespaces", ["owner_id"], name: "index_namespaces_on_owner_id", using: :btree
    add_index "namespaces", ["path"], name: "index_namespaces_on_path", using: :btree
    add_index "namespaces", ["type"], name: "index_namespaces_on_type", using: :btree
113

114 115 116 117 118 119 120 121 122 123 124 125
    create_table "notes", force: true do |t|
      t.text     "note"
      t.string   "noteable_type"
      t.integer  "author_id"
      t.datetime "created_at"
      t.datetime "updated_at"
      t.integer  "project_id"
      t.string   "attachment"
      t.string   "line_code"
      t.string   "commit_id"
      t.integer  "noteable_id"
    end
126

127 128 129 130 131
    add_index "notes", ["commit_id"], name: "index_notes_on_commit_id", using: :btree
    add_index "notes", ["created_at"], name: "index_notes_on_created_at", using: :btree
    add_index "notes", ["noteable_type"], name: "index_notes_on_noteable_type", using: :btree
    add_index "notes", ["project_id", "noteable_type"], name: "index_notes_on_project_id_and_noteable_type", using: :btree
    add_index "notes", ["project_id"], name: "index_notes_on_project_id", using: :btree
132

133 134 135 136 137 138 139 140 141 142 143 144 145 146 147
    create_table "projects", force: true do |t|
      t.string   "name"
      t.string   "path"
      t.text     "description"
      t.datetime "created_at"
      t.datetime "updated_at"
      t.boolean  "private_flag",           default: true, null: false
      t.integer  "owner_id"
      t.string   "default_branch"
      t.boolean  "issues_enabled",         default: true, null: false
      t.boolean  "wall_enabled",           default: true, null: false
      t.boolean  "merge_requests_enabled", default: true, null: false
      t.boolean  "wiki_enabled",           default: true, null: false
      t.integer  "namespace_id"
    end
148

149 150
    add_index "projects", ["namespace_id"], name: "index_projects_on_namespace_id", using: :btree
    add_index "projects", ["owner_id"], name: "index_projects_on_owner_id", using: :btree
151

152 153 154 155 156 157
    create_table "protected_branches", force: true do |t|
      t.integer  "project_id", null: false
      t.string   "name",       null: false
      t.datetime "created_at"
      t.datetime "updated_at"
    end
158

159 160 161 162 163 164 165 166 167 168
    create_table "services", force: true do |t|
      t.string   "type"
      t.string   "title"
      t.string   "token"
      t.integer  "project_id",                  null: false
      t.datetime "created_at"
      t.datetime "updated_at"
      t.boolean  "active",      default: false, null: false
      t.string   "project_url"
    end
169

170
    add_index "services", ["project_id"], name: "index_services_on_project_id", using: :btree
171

172 173 174 175 176 177 178 179 180 181
    create_table "snippets", force: true do |t|
      t.string   "title"
      t.text     "content"
      t.integer  "author_id",  null: false
      t.integer  "project_id", null: false
      t.datetime "created_at"
      t.datetime "updated_at"
      t.string   "file_name"
      t.datetime "expires_at"
    end
182

183 184 185
    add_index "snippets", ["created_at"], name: "index_snippets_on_created_at", using: :btree
    add_index "snippets", ["expires_at"], name: "index_snippets_on_expires_at", using: :btree
    add_index "snippets", ["project_id"], name: "index_snippets_on_project_id", using: :btree
186

187 188 189 190 191 192 193 194 195
    create_table "taggings", force: true do |t|
      t.integer  "tag_id"
      t.integer  "taggable_id"
      t.string   "taggable_type"
      t.integer  "tagger_id"
      t.string   "tagger_type"
      t.string   "context"
      t.datetime "created_at"
    end
196

197 198
    add_index "taggings", ["tag_id"], name: "index_taggings_on_tag_id", using: :btree
    add_index "taggings", ["taggable_id", "taggable_type", "context"], name: "index_taggings_on_taggable_id_and_taggable_type_and_context", using: :btree
199

200 201 202
    create_table "tags", force: true do |t|
      t.string "name"
    end
203

204 205 206 207 208 209 210
    create_table "user_team_project_relationships", force: true do |t|
      t.integer  "project_id"
      t.integer  "user_team_id"
      t.integer  "greatest_access"
      t.datetime "created_at"
      t.datetime "updated_at"
    end
211

212 213 214 215 216 217 218 219
    create_table "user_team_user_relationships", force: true do |t|
      t.integer  "user_id"
      t.integer  "user_team_id"
      t.boolean  "group_admin"
      t.integer  "permission"
      t.datetime "created_at"
      t.datetime "updated_at"
    end
220

221 222 223 224 225 226 227
    create_table "user_teams", force: true do |t|
      t.string   "name"
      t.string   "path"
      t.integer  "owner_id"
      t.datetime "created_at"
      t.datetime "updated_at"
    end
228

229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258
    create_table "users", force: true do |t|
      t.string   "email",                  default: "",    null: false
      t.string   "encrypted_password",     default: "",    null: false
      t.string   "reset_password_token"
      t.datetime "reset_password_sent_at"
      t.datetime "remember_created_at"
      t.integer  "sign_in_count",          default: 0
      t.datetime "current_sign_in_at"
      t.datetime "last_sign_in_at"
      t.string   "current_sign_in_ip"
      t.string   "last_sign_in_ip"
      t.datetime "created_at"
      t.datetime "updated_at"
      t.string   "name"
      t.boolean  "admin",                  default: false, null: false
      t.integer  "projects_limit",         default: 10
      t.string   "skype",                  default: "",    null: false
      t.string   "linkedin",               default: "",    null: false
      t.string   "twitter",                default: "",    null: false
      t.string   "authentication_token"
      t.boolean  "dark_scheme",            default: false, null: false
      t.integer  "theme_id",               default: 1,     null: false
      t.string   "bio"
      t.boolean  "blocked",                default: false, null: false
      t.integer  "failed_attempts",        default: 0
      t.datetime "locked_at"
      t.string   "extern_uid"
      t.string   "provider"
      t.string   "username"
    end
259

260 261 262 263 264 265 266
    add_index "users", ["admin"], name: "index_users_on_admin", using: :btree
    add_index "users", ["blocked"], name: "index_users_on_blocked", using: :btree
    add_index "users", ["email"], name: "index_users_on_email", unique: true, using: :btree
    add_index "users", ["extern_uid", "provider"], name: "index_users_on_extern_uid_and_provider", unique: true, using: :btree
    add_index "users", ["name"], name: "index_users_on_name", using: :btree
    add_index "users", ["reset_password_token"], name: "index_users_on_reset_password_token", unique: true, using: :btree
    add_index "users", ["username"], name: "index_users_on_username", using: :btree
267

268 269 270 271 272 273 274
    create_table "users_projects", force: true do |t|
      t.integer  "user_id",                    null: false
      t.integer  "project_id",                 null: false
      t.datetime "created_at"
      t.datetime "updated_at"
      t.integer  "project_access", default: 0, null: false
    end
275

276 277 278
    add_index "users_projects", ["project_access"], name: "index_users_projects_on_project_access", using: :btree
    add_index "users_projects", ["project_id"], name: "index_users_projects_on_project_id", using: :btree
    add_index "users_projects", ["user_id"], name: "index_users_projects_on_user_id", using: :btree
279

280 281 282 283 284 285 286 287
    create_table "web_hooks", force: true do |t|
      t.string   "url"
      t.integer  "project_id"
      t.datetime "created_at"
      t.datetime "updated_at"
      t.string   "type",       default: "ProjectHook"
      t.integer  "service_id"
    end
288

289 290 291 292 293 294 295 296 297
    create_table "wikis", force: true do |t|
      t.string   "title"
      t.text     "content"
      t.integer  "project_id"
      t.datetime "created_at"
      t.datetime "updated_at"
      t.string   "slug"
      t.integer  "user_id"
    end
298

299 300
    add_index "wikis", ["project_id"], name: "index_wikis_on_project_id", using: :btree
    add_index "wikis", ["slug"], name: "index_wikis_on_slug", using: :btree
301

302 303 304 305 306 307
  end

  def down
    raise "Can not revert initial migration"
  end
end