How to change migration executing order?
I have two migrations.
1. Respectively a view
public function up()
{
DB::statement("CREATE OR REPLACE VIEW myView AS
SELECT * FROM mytable;
");
}
2. And a table alter for adding anew column
public function up()
{
Schema::table('mytable', function (Blueprint $table) {
$table->enum('type', ['bulk', 'online']);
});
}
As you see,
that view uses * to select all columns.
But after php artisan migrate, the type column * (after the view is created)* does not exists in the view.
Any idea how can I handle that?
How can I change/specify the order of migrations order?
Or
how can I re-execute that view migration again when that column was created?
php laravel migration
edited Jan 1 at 7:29
Umar Abdullah
948418
asked Jan 1 at 7:02
Martin AJMartin AJ
2,1321029
add a comment |
I have two migrations.
1. Respectively a view
public function up()
{
DB::statement("CREATE OR REPLACE VIEW myView AS
SELECT * FROM mytable;
");
}
2. And a table alter for adding anew column
public function up()
{
Schema::table('mytable', function (Blueprint $table) {
$table->enum('type', ['bulk', 'online']);
});
}
As you see,
that view uses * to select all columns.
But after php artisan migrate, the type column * (after the view is created)* does not exists in the view.
Any idea how can I handle that?
How can I change/specify the order of migrations order?
Or
how can I re-execute that view migration again when that column was created?
php laravel migration
edited Jan 1 at 7:29
Umar Abdullah
948418
asked Jan 1 at 7:02
Martin AJMartin AJ
2,1321029
The order of executing migrations depends on creating file datetime. If you didn't deploy your view migration then you can simply update its datetime to be after table alter migration datetime. If you deployed your code then you should change the datetime in filename and also you should delete view's migration row from migrations table on your live server.
– train_fox
Jan 1 at 7:57
add a comment |
I have two migrations.
1. Respectively a view
public function up()
{
DB::statement("CREATE OR REPLACE VIEW myView AS
SELECT * FROM mytable;
");
}
2. And a table alter for adding anew column
public function up()
{
Schema::table('mytable', function (Blueprint $table) {
$table->enum('type', ['bulk', 'online']);
});
}
As you see,
that view uses * to select all columns.
But after php artisan migrate, the type column * (after the view is created)* does not exists in the view.
Any idea how can I handle that?
How can I change/specify the order of migrations order?
Or
how can I re-execute that view migration again when that column was created?
php laravel migration
edited Jan 1 at 7:29
Umar Abdullah
948418
asked Jan 1 at 7:02
Martin AJMartin AJ
2,1321029
I have two migrations.
1. Respectively a view
public function up()
{
DB::statement("CREATE OR REPLACE VIEW myView AS
SELECT * FROM mytable;
");
}
2. And a table alter for adding anew column
public function up()
{
Schema::table('mytable', function (Blueprint $table) {
$table->enum('type', ['bulk', 'online']);
});
}
As you see,
that view uses * to select all columns.
But after php artisan migrate, the type column * (after the view is created)* does not exists in the view.
Any idea how can I handle that?
How can I change/specify the order of migrations order?
Or
how can I re-execute that view migration again when that column was created?
php laravel migration
php laravel migration
edited Jan 1 at 7:29
Umar Abdullah
948418
asked Jan 1 at 7:02
Martin AJMartin AJ
2,1321029
edited Jan 1 at 7:29
Umar Abdullah
948418
asked Jan 1 at 7:02
Martin AJMartin AJ
2,1321029
edited Jan 1 at 7:29
Umar Abdullah
948418
edited Jan 1 at 7:29
Umar Abdullah
948418
edited Jan 1 at 7:29
Umar Abdullah
948418
948418
asked Jan 1 at 7:02
Martin AJMartin AJ
2,1321029
asked Jan 1 at 7:02
Martin AJMartin AJ
2,1321029
asked Jan 1 at 7:02
Martin AJMartin AJ
2,1321029
2,1321029
The order of executing migrations depends on creating file datetime. If you didn't deploy your view migration then you can simply update its datetime to be after table alter migration datetime. If you deployed your code then you should change the datetime in filename and also you should delete view's migration row from migrations table on your live server.
– train_fox
Jan 1 at 7:57
add a comment |
The order of executing migrations depends on creating file datetime. If you didn't deploy your view migration then you can simply update its datetime to be after table alter migration datetime. If you deployed your code then you should change the datetime in filename and also you should delete view's migration row from migrations table on your live server.
– train_fox
Jan 1 at 7:57
The order of executing migrations depends on creating file datetime. If you didn't deploy your view migration then you can simply update its datetime to be after table alter migration datetime. If you deployed your code then you should change the datetime in filename and also you should delete view's migration row from migrations table on your live server.
– train_fox
Jan 1 at 7:57
The order of executing migrations depends on creating file datetime. If you didn't deploy your view migration then you can simply update its datetime to be after table alter migration datetime. If you deployed your code then you should change the datetime in filename and also you should delete view's migration row from migrations table on your live server.
– train_fox
Jan 1 at 7:57
add a comment |
0
active
oldest
votes
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%2f53993634%2fhow-to-change-migration-executing-order%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
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%2f53993634%2fhow-to-change-migration-executing-order%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
The order of executing migrations depends on creating file datetime. If you didn't deploy your view migration then you can simply update its datetime to be after table alter migration datetime. If you deployed your code then you should change the datetime in filename and also you should delete view's migration row from migrations table on your live server.
– train_fox
Jan 1 at 7:57