Rails - Add default value after rake db:migrate
I added new migration that add a new column to a table. I ran the command 'rake db:migrate' Then I realize that I forgot to add a default value. How can I add default value after the rake db:migrate? (I'm storing the server on heroku service)
ruby-on-rails postgresql ruby-on-rails-4
edited Nov 28 '18 at 10:24
Cœur
19k9113155
asked Jul 9 '16 at 15:15
R.BarR.Bar
1259
add a comment |
I added new migration that add a new column to a table. I ran the command 'rake db:migrate' Then I realize that I forgot to add a default value. How can I add default value after the rake db:migrate? (I'm storing the server on heroku service)
ruby-on-rails postgresql ruby-on-rails-4
edited Nov 28 '18 at 10:24
Cœur
19k9113155
asked Jul 9 '16 at 15:15
R.BarR.Bar
1259
add a comment |
I added new migration that add a new column to a table. I ran the command 'rake db:migrate' Then I realize that I forgot to add a default value. How can I add default value after the rake db:migrate? (I'm storing the server on heroku service)
ruby-on-rails postgresql ruby-on-rails-4
edited Nov 28 '18 at 10:24
Cœur
19k9113155
asked Jul 9 '16 at 15:15
R.BarR.Bar
1259
I added new migration that add a new column to a table. I ran the command 'rake db:migrate' Then I realize that I forgot to add a default value. How can I add default value after the rake db:migrate? (I'm storing the server on heroku service)
ruby-on-rails postgresql ruby-on-rails-4
ruby-on-rails postgresql ruby-on-rails-4
edited Nov 28 '18 at 10:24
Cœur
19k9113155
asked Jul 9 '16 at 15:15
R.BarR.Bar
1259
edited Nov 28 '18 at 10:24
Cœur
19k9113155
asked Jul 9 '16 at 15:15
R.BarR.Bar
1259
edited Nov 28 '18 at 10:24
Cœur
19k9113155
edited Nov 28 '18 at 10:24
Cœur
19k9113155
edited Nov 28 '18 at 10:24
Cœur
19k9113155
19k9113155
asked Jul 9 '16 at 15:15
R.BarR.Bar
1259
asked Jul 9 '16 at 15:15
R.BarR.Bar
1259
asked Jul 9 '16 at 15:15
R.BarR.Bar
1259
1259
add a comment |
add a comment |
2 Answers
2
active
oldest
votes
You can run rake db:rollback, then adjust your migration with default value, commit and push to heroku, and then run db:migrate again.
Another option is to create a new migration and use change_column_default:
change_column_default :table_name, :column_name, "Default value"
add a comment |
Create another migration
change_column :users, :admin, :boolean, :default => false
Same question as Add a default value to a column through a migration
edited May 23 '17 at 11:44
Community♦
11
answered Jul 9 '16 at 15:19
Steve WilhelmSteve Wilhelm
5,20212436
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f38283246%2frails-add-default-value-after-rake-dbmigrate%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
You can run rake db:rollback, then adjust your migration with default value, commit and push to heroku, and then run db:migrate again.
Another option is to create a new migration and use change_column_default:
change_column_default :table_name, :column_name, "Default value"
add a comment |
You can run rake db:rollback, then adjust your migration with default value, commit and push to heroku, and then run db:migrate again.
Another option is to create a new migration and use change_column_default:
change_column_default :table_name, :column_name, "Default value"
add a comment |
You can run rake db:rollback, then adjust your migration with default value, commit and push to heroku, and then run db:migrate again.
Another option is to create a new migration and use change_column_default:
change_column_default :table_name, :column_name, "Default value"
You can run rake db:rollback, then adjust your migration with default value, commit and push to heroku, and then run db:migrate again.
Another option is to create a new migration and use change_column_default:
change_column_default :table_name, :column_name, "Default value"
answered Jul 9 '16 at 15:23
user4776684
add a comment |
add a comment |
Create another migration
change_column :users, :admin, :boolean, :default => false
Same question as Add a default value to a column through a migration
edited May 23 '17 at 11:44
Community♦
11
answered Jul 9 '16 at 15:19
Steve WilhelmSteve Wilhelm
5,20212436
add a comment |
Create another migration
change_column :users, :admin, :boolean, :default => false
Same question as Add a default value to a column through a migration
edited May 23 '17 at 11:44
Community♦
11
answered Jul 9 '16 at 15:19
Steve WilhelmSteve Wilhelm
5,20212436
add a comment |
Create another migration
change_column :users, :admin, :boolean, :default => false
Same question as Add a default value to a column through a migration
edited May 23 '17 at 11:44
Community♦
11
answered Jul 9 '16 at 15:19
Steve WilhelmSteve Wilhelm
5,20212436
Create another migration
change_column :users, :admin, :boolean, :default => false
Same question as Add a default value to a column through a migration
edited May 23 '17 at 11:44
Community♦
11
answered Jul 9 '16 at 15:19
Steve WilhelmSteve Wilhelm
5,20212436
edited May 23 '17 at 11:44
Community♦
11
edited May 23 '17 at 11:44
Community♦
11
edited May 23 '17 at 11:44
Community♦
11
11
answered Jul 9 '16 at 15:19
Steve WilhelmSteve Wilhelm
5,20212436
answered Jul 9 '16 at 15:19
Steve WilhelmSteve Wilhelm
5,20212436
answered Jul 9 '16 at 15:19
Steve WilhelmSteve Wilhelm
5,20212436
5,20212436
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f38283246%2frails-add-default-value-after-rake-dbmigrate%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
