Welcome Guest, Not a member yet? Register   Sign In
Adding foreign key to existing table using Migrations
#6
Wink 
(This post was last modified: 12-30-2020, 09:38 PM by dennysw.)

PHP Code:
<?php namespace App\Database\Migrations;

use 
CodeIgniter\Database\Migration;

class 
AddIduserProduk extends Migration
{
    public function 
up()
    {
        
$fields = [
            
'id_user' => [
                
'type'      => 'INT',
                
'constraint'=> 11,
                
'unsigned'  => TRUE,
                
'after'         => 'id_kategori',
                
'null'            => TRUE
            
],
            
'CONSTRAINT produk_ibfk_1 FOREIGN KEY(`id_user`) REFERENCES `users`(`id_user`)'
        
];
        
$this->forge->addColumn('product_table'$fields);
    }

    
//--------------------------------------------------------------------

    
public function down()
    {
        
$this->forge->dropForeignKey('produk','produk_ibfk_1');
        
$this->forge->dropColumn('product_table''id_user');
    }


Its work for me in file app/Database/Migrations/2020-12-31-034310_add_iduser_produk.php
Reply


Messages In This Thread
RE: Adding foreign key to existing table using Migrations - by dennysw - 12-30-2020, 09:31 PM



Theme © iAndrew 2016 - Forum software by © MyBB