diff options
Diffstat (limited to 'db')
| -rw-r--r-- | db/migrate/20130528184641_add_system_to_notes.rb | 16 | ||||
| -rw-r--r-- | db/schema.rb | 1 |
2 files changed, 17 insertions, 0 deletions
diff --git a/db/migrate/20130528184641_add_system_to_notes.rb b/db/migrate/20130528184641_add_system_to_notes.rb new file mode 100644 index 00000000000..1b22a4934f9 --- /dev/null +++ b/db/migrate/20130528184641_add_system_to_notes.rb @@ -0,0 +1,16 @@ +class AddSystemToNotes < ActiveRecord::Migration + class Note < ActiveRecord::Base + end + + def up + add_column :notes, :system, :boolean, default: false, null: false + + Note.reset_column_information + Note.update_all(system: false) + Note.where("note like '_status changed to%'").update_all(system: true) + end + + def down + remove_column :notes, :system + end +end diff --git a/db/schema.rb b/db/schema.rb index 429551a2bf4..5020230d831 100644 --- a/db/schema.rb +++ b/db/schema.rb @@ -152,6 +152,7 @@ ActiveRecord::Schema.define(:version => 20130821090531) do t.string "commit_id" t.integer "noteable_id" t.text "st_diff" + t.boolean "system", :default => false, :null => false end add_index "notes", ["author_id"], :name => "index_notes_on_author_id" |