Database-migration Questions

I am trying to create a new table where 2 foreign key will be set public function up() {

I am trying to run a new migration between two of my tables however when i run php artisan migrate it's showing:

I have this commands php artisan db:seed --class=graphstableseeder that i need to run in my part of my code

I have updated one of my room entities to include a foreign key. i must now include this change in my data migration but unsure on the sql

Loopback has easy way to deal with database migrations, which differs from the method that uses, for example, knex.js. in the

In my previous project i used this syntax for migration to mongodb: my_migration.js // 'use strict'; import slug from 'slugify';

Can anyone know how to create table in laravel without created_at and updated_at column in table using a migration. i try this following code but

I want to write a laravel migration auto increment id as a primary key. i want to start this id with a another value rather than 1. how can i do

Good morning, i'm trying to do the data models for a workshop workers app. the problem comes with the guides and images data models. each guide

I am trying to set up tests in laravel, but i want to run different migrations from those that usually run. the migrations that i run to

How can implement tables based on year in laravel, like orders2020, orders2019, orders2018 etc. and how to

The below migration is running successfully with no errors but it's not inserting any data do table. why it can be? can some one tell me what is

I'm using laravel and working on migrations. i am looking for records of the implementation of migrations. how does laravel find out how far the

I was trying to upgrade my database version and in last version the table had a unique index created upon migration room gave me the following

I am using laravel 6. i want to create a joined table named meeting_user that should connect the tables meetings and

I want to store html in the database as blob data type when i try to migrate getting errors schema::create('projects', function

In basic laravel application, in user class i added: use softdeletes; application is no longer working

I would like to get my inputted command argument(s) in a database migration file. is this possible without having to fetch the $_server global and

Is there any library or tool to perform database migrations in python without sqlalchemy? i am using a postgresql database and the queries are raw

I am currently working on a coursework for developing a cms with laravel. i did some changes to my pages as i wanted to give them an "position"

I want to display the pointage, and salary table data from controllersalarie, but it gives me this error pointage

I have a homestead setup in users/[username]/homestead and setup a vagrant to run several websites and this is working fine.

I have an app where users belong to a team. here is my test: /** @test */ public function it_has_many_users() { $team =

I am making a migration using room database. i am getting this error: java.lang.illegalstateexception: migration didn't properly

This is my students migration and i want to have foreign key in it named subject_id: public function

The problem when running migration, the last table end up with the error in the title. my database is a local mysql.

I get manufacturer name has no value even tho it references id column in manufacturer table which is already created in database and sits in the

2019_04_23_164151_create_contacts_table.php migration file <?php use illuminate\support\facades\schema; use

I'm still new as a developer and i'm trying to change user table, were i add a new column "user_type" from the previous table. my

I am using postgres + sequelize const db = //db connection stuffs.... db.authenticate().then((err) => { if (err) {

So i am busy with making this migration and afther a ton of research, he still gives me the following error message:

I have table category which have parent of type of itself. schema::create('categories', function (blueprint $table) {

I have a mysql database with a table called user_level_attempt. that table has a enum type column with

I'm trying to write a migration in sequelize and want to remove the defaultvalue constraint. what is the proper syntax? i've tried both of the

I want to add another new enum column in the table, but not able to migrate, as it says column already exists.

I am trying to migrate my newly created migrations. the problem is that the batch of migrations waiting to migrate is in the order in which i

My superior told me i could create a seeder-like trait which i can then use inside a migration. when the

I have the following sql statement which is working directly in sql console, but i need to make it on a laravel migration.

I'm developing a website which, as of current, both has a production and a test database. the production database is hosted externally while the

I am trying to take input from user as table name, field list with their type (integer or text) and save that in on table and then create a table

I have my migration files, which creates the initial schema for the database, and, i have my seed files, which populates the initial schema, with

Hi i am not very good with database design so i would like to know if it's possible to create a table with two foreign key from the same

I wonder if there is a way that i can access the blueprint in migration file and return it in a external file. example, i have the following users

I have several tables that i have created through migration. then, what happens if i change the table structure directly from phpmyadmin without

I have a customer with a typo3 website that is hosted on a webserver with very restricting policies when it comes to database users. i

I'm trying to make core ui - laravel work on my localhost

I refactored a project and wanted to try out postgresql instead of mysql. i now want to migrate the table contents of some tables. the

I'm trying create a model inherit following this tutorial:

i want to update privacy of a post my controller public function

migration file public function up() { schema::create('posts', function (blueprint

Just picked up a project that is using flyway to rebuild the database. can't really change the tool without picking a fight with all other devs in

Colleagues! i have flyway files which have been already used in my project and i need to delete several of these files. ex: i have files with

In migration table: schema::create('passws', function (blueprint $table) { $table->increments('id');

I have table "invoice_relations" which is morph table. so in migration i wrote : $table->morphs('invoice_relations'); but it gives

I'm trying to create foreign keys in laravel however when i migrate my table using "artisan" i am thrown the following error and i do not know

I was trying to migrate in laravel with foreign key that points to the auto incremented id of debiturs table:

Tl;dr. solution: thanks to jonas. the problem was that

I am using laravel 5.6 and has a multi-auth funcitonality and it works fine. i have user and admin tables in my db. how can i set a default value

I have created an application that uses a microsoft access database, which i am having some issues with and so want to migrate to microsoft sql

I have a laravel application which has the database set up using migrations. we have decided to move to phalcon for a number of reasons, and due

I was trying to create a migration in laravel using the code here. but unfortunately it pops out an error like given here. i saw some answers

We have lots of records in a table and we need to update all values of a column before we deploy some code. so we plan to update the table in

I have to remove a unique constraint from an email column using laravel migrations. here is my code: class alteremailtousers

So we've recently setup sharding and we're migrating some of the data from several clients across several smaller databases into a bigger, sharded

I have a mongodb database, used by nodejs via mongoose, and it involves nested/embedded documents like the following: "people" : [

There is a mysql request to create a table: create table if not exists `tb_edited_message` ( `id` bigint unsigned auto_increment

I'm trying to migrate my firestore database to a new location, since google added a new canadian region after we created our database in

We have a database which has 511 tables and 'sql server migration assistance for mysql' is showing only 31 tables. i am using version-6.0.0. it is

I'm in the progress of migrating data from an old system. i have some boolean columns, which can be true, false or

I'm creating a laravel application that lets users make a blog post. the post model looks like this: <?php namespace

I'm new to laravel and i'm trying to create tables using schema façade. i create the migration file with command php

Hopefully, i can explain this well. i have a laravel application that has been in production for a minute. so, i have a bunch of migration

I ran php artisan migrate, with empty value for prefix in the database config file. later i added a value for prefix in the

Let't assume, i have a simple room database: @database(entities = {user.class}, version = 1) abstract class appdatabase extends

I'm trying to change the max length of one of my columns in table reserves in one migration. the code looks like this:

I have a django app with a postgres backend hosted on heroku. i'm now migrating it to azure. on azure, the django application code and postgres

I need to rename two tables in one atomic operation so that user will never be able to see the database in its intermediate state. i'm

I have a mysql database object that stores concerts that a user plans to attend on a certain date. since each concert entry needs to be associated

Say i have a model that represents a product from my company. each product a product number (ex. 5928523), as well as a boolean representing

I'm working on a site with the latest version of laravel, and we have recently changed the mysql db location from a remote host to a local host.

I currently have two tables symbols and prices. i am currently creating a migration for prices and adding a

I've got a couple of migrations for tables within my app. the tables are: people skills media notes

I have a system made with laravel. as we know, we can make database migrations in laravel using php artisan. so bacially, you

I have just started working with laravel 5.2.. this is a simple migration file but when i run the php artisan migrate command i get the error

I'm trying to execute an octobercms migration through jenkins with a docker command, but i have the next error in jenkins console:

I am trying to create a simple database migration. but when i run the following command in the root directory of my project: php artisan migrate:make --create=users create_users_tab