diff options
Diffstat (limited to 'db/migrate')
19 files changed, 182 insertions, 0 deletions
diff --git a/db/migrate/20110913200833_devise_create_users.rb b/db/migrate/20110913200833_devise_create_users.rb new file mode 100644 index 00000000000..3083e742459 --- /dev/null +++ b/db/migrate/20110913200833_devise_create_users.rb @@ -0,0 +1,28 @@ +class DeviseCreateUsers < ActiveRecord::Migration + def self.up + create_table(:users) do |t| + t.database_authenticatable :null => false + t.recoverable + t.rememberable + t.trackable + + # t.encryptable + # t.confirmable + # t.lockable :lock_strategy => :failed_attempts, :unlock_strategy => :both + # t.token_authenticatable + + + t.timestamps + end + + add_index :users, :email, :unique => true + add_index :users, :reset_password_token, :unique => true + # add_index :users, :confirmation_token, :unique => true + # add_index :users, :unlock_token, :unique => true + # add_index :users, :authentication_token, :unique => true + end + + def self.down + drop_table :users + end +end diff --git a/db/migrate/20110913204141_create_projects.rb b/db/migrate/20110913204141_create_projects.rb new file mode 100644 index 00000000000..45b76f95563 --- /dev/null +++ b/db/migrate/20110913204141_create_projects.rb @@ -0,0 +1,11 @@ +class CreateProjects < ActiveRecord::Migration + def change + create_table :projects do |t| + t.string :name + t.string :path + t.text :description + + t.timestamps + end + end +end diff --git a/db/migrate/20110914221600_create_users_projects.rb b/db/migrate/20110914221600_create_users_projects.rb new file mode 100644 index 00000000000..a89798ae86f --- /dev/null +++ b/db/migrate/20110914221600_create_users_projects.rb @@ -0,0 +1,13 @@ +class CreateUsersProjects < ActiveRecord::Migration + def change + create_table :users_projects do |t| + t.integer :user_id, :null => false + t.integer :project_id, :null => false + t.boolean :read, :default => false + t.boolean :write, :default => false + t.boolean :admin, :default => false + + t.timestamps + end + end +end diff --git a/db/migrate/20110915205627_add_private_flag_to_project.rb b/db/migrate/20110915205627_add_private_flag_to_project.rb new file mode 100644 index 00000000000..73c0b9df834 --- /dev/null +++ b/db/migrate/20110915205627_add_private_flag_to_project.rb @@ -0,0 +1,5 @@ +class AddPrivateFlagToProject < ActiveRecord::Migration + def change + add_column :projects, :private_flag, :boolean, :default => true, :null => false + end +end diff --git a/db/migrate/20110915213352_create_keys.rb b/db/migrate/20110915213352_create_keys.rb new file mode 100644 index 00000000000..d4615b4babf --- /dev/null +++ b/db/migrate/20110915213352_create_keys.rb @@ -0,0 +1,9 @@ +class CreateKeys < ActiveRecord::Migration + def change + create_table :keys do |t| + t.integer :user_id, :null => false + t.text :project_id, :null => false + t.timestamps + end + end +end diff --git a/db/migrate/20110916123731_add_name_to_user.rb b/db/migrate/20110916123731_add_name_to_user.rb new file mode 100644 index 00000000000..74142b05cb5 --- /dev/null +++ b/db/migrate/20110916123731_add_name_to_user.rb @@ -0,0 +1,5 @@ +class AddNameToUser < ActiveRecord::Migration + def change + add_column :users, :name, :string + end +end diff --git a/db/migrate/20110916162511_add_key_title_to_key.rb b/db/migrate/20110916162511_add_key_title_to_key.rb new file mode 100644 index 00000000000..b2eaa51cccf --- /dev/null +++ b/db/migrate/20110916162511_add_key_title_to_key.rb @@ -0,0 +1,7 @@ +class AddKeyTitleToKey < ActiveRecord::Migration + def change + add_column :keys, :key, :text + add_column :keys, :title, :string + remove_column :keys, :project_id + end +end diff --git a/db/migrate/20110917212932_add_identifier_to_key.rb b/db/migrate/20110917212932_add_identifier_to_key.rb new file mode 100644 index 00000000000..e572793952a --- /dev/null +++ b/db/migrate/20110917212932_add_identifier_to_key.rb @@ -0,0 +1,5 @@ +class AddIdentifierToKey < ActiveRecord::Migration + def change + add_column :keys, :identifier, :string + end +end diff --git a/db/migrate/20110921192501_create_issues.rb b/db/migrate/20110921192501_create_issues.rb new file mode 100644 index 00000000000..63b42ad998e --- /dev/null +++ b/db/migrate/20110921192501_create_issues.rb @@ -0,0 +1,13 @@ +class CreateIssues < ActiveRecord::Migration + def change + create_table :issues do |t| + t.string :title + t.text :content + t.integer :assignee_id + t.integer :author_id + t.integer :project_id + + t.timestamps + end + end +end diff --git a/db/migrate/20110922110156_add_code_to_project.rb b/db/migrate/20110922110156_add_code_to_project.rb new file mode 100644 index 00000000000..f54a02bd70a --- /dev/null +++ b/db/migrate/20110922110156_add_code_to_project.rb @@ -0,0 +1,5 @@ +class AddCodeToProject < ActiveRecord::Migration + def change + add_column :projects, :code, :string + end +end diff --git a/db/migrate/20110923211333_add_status_to_issue.rb b/db/migrate/20110923211333_add_status_to_issue.rb new file mode 100644 index 00000000000..c53bf46ef72 --- /dev/null +++ b/db/migrate/20110923211333_add_status_to_issue.rb @@ -0,0 +1,5 @@ +class AddStatusToIssue < ActiveRecord::Migration + def change + add_column :issues, :closed, :boolean, :default => false, :null => false + end +end diff --git a/db/migrate/20110924214549_create_rails_admin_histories_table.rb b/db/migrate/20110924214549_create_rails_admin_histories_table.rb new file mode 100644 index 00000000000..3c743aa2874 --- /dev/null +++ b/db/migrate/20110924214549_create_rails_admin_histories_table.rb @@ -0,0 +1,18 @@ +class CreateRailsAdminHistoriesTable < ActiveRecord::Migration + def self.up + create_table :rails_admin_histories do |t| + t.text :message # title, name, or object_id + t.string :username + t.integer :item + t.string :table + t.integer :month, :limit => 2 + t.integer :year, :limit => 5 + t.timestamps + end + add_index(:rails_admin_histories, [:item, :table, :month, :year], :name => 'index_rails_admin_histories' ) + end + + def self.down + drop_table :rails_admin_histories + end +end diff --git a/db/migrate/20110924215658_add_admin_field_to_user.rb b/db/migrate/20110924215658_add_admin_field_to_user.rb new file mode 100644 index 00000000000..321587e6957 --- /dev/null +++ b/db/migrate/20110924215658_add_admin_field_to_user.rb @@ -0,0 +1,5 @@ +class AddAdminFieldToUser < ActiveRecord::Migration + def change + add_column :users, :admin, :boolean, :default => false, :null => false + end +end diff --git a/db/migrate/20110926082616_remove_admin.rb b/db/migrate/20110926082616_remove_admin.rb new file mode 100644 index 00000000000..aac9ff7888c --- /dev/null +++ b/db/migrate/20110926082616_remove_admin.rb @@ -0,0 +1,9 @@ +class RemoveAdmin < ActiveRecord::Migration + def up + drop_table :rails_admin_histories + end + + def down + raise "No rollback" + end +end diff --git a/db/migrate/20110927130352_create_notes.rb b/db/migrate/20110927130352_create_notes.rb new file mode 100644 index 00000000000..72a0e817617 --- /dev/null +++ b/db/migrate/20110927130352_create_notes.rb @@ -0,0 +1,12 @@ +class CreateNotes < ActiveRecord::Migration + def change + create_table :notes do |t| + t.string :note + t.integer :noteable_id + t.string :noteable_type + t.integer :author_id + + t.timestamps + end + end +end diff --git a/db/migrate/20110928140106_add_project_id_for_note.rb b/db/migrate/20110928140106_add_project_id_for_note.rb new file mode 100644 index 00000000000..3e641089799 --- /dev/null +++ b/db/migrate/20110928140106_add_project_id_for_note.rb @@ -0,0 +1,9 @@ +class AddProjectIdForNote < ActiveRecord::Migration + def up + add_column :notes, :project_id, :integer + end + + def down + remove_column :notes, :project_id, :integer + end +end diff --git a/db/migrate/20110928142747_change_noteable_id_for_note.rb b/db/migrate/20110928142747_change_noteable_id_for_note.rb new file mode 100644 index 00000000000..dc9d1f0171a --- /dev/null +++ b/db/migrate/20110928142747_change_noteable_id_for_note.rb @@ -0,0 +1,9 @@ +class ChangeNoteableIdForNote < ActiveRecord::Migration + def up + change_column :notes, :noteable_id, :string + end + + def down + change_column :notes, :noteable_id, :integer + end +end diff --git a/db/migrate/20110928161328_add_attachment_to_note.rb b/db/migrate/20110928161328_add_attachment_to_note.rb new file mode 100644 index 00000000000..37d9cf10258 --- /dev/null +++ b/db/migrate/20110928161328_add_attachment_to_note.rb @@ -0,0 +1,5 @@ +class AddAttachmentToNote < ActiveRecord::Migration + def change + add_column :notes, :attachment, :string + end +end diff --git a/db/migrate/20111005193700_add_allow_repo_creation_for_user.rb b/db/migrate/20111005193700_add_allow_repo_creation_for_user.rb new file mode 100644 index 00000000000..82bd94b8089 --- /dev/null +++ b/db/migrate/20111005193700_add_allow_repo_creation_for_user.rb @@ -0,0 +1,9 @@ +class AddAllowRepoCreationForUser < ActiveRecord::Migration + def up + add_column :users, :allowed_create_repo, :boolean, :default => true, :null => false + end + + def down + remove_column :users, :allowed_create_repo + end +end |