Welcome Guest, Not a member yet? Register   Sign In
How to create more than 1 table in Migration?
#1

I followed the guideline here: 

Database Manipulation and Database Forge
https://codeigniter4.github.io/CodeIgnit...forge.html

I managed to run the migration, and successfully created 1 table with necessary fields.
All files are duly placed inside app/Database/Migrations.

So my questions right now are;
1. How to create more than 1 table? (in just 1 Migration file)
2. What is really up() and down() for? (is it a must? can I write a custom method instead?) 

Thank you.


#codeigniter4
#forge
#migration
Reply
#2

(This post was last modified: 01-09-2021, 09:36 PM by InsiteFX.)

You just continue on like you did the first one repeating for all the tables you need

(up)
Add fields
Add Keys
Create table

Add fields
Add Keys
Create table

(down)
List of tables

Like so.
What did you Try? What did you Get? What did you Expect?

Joined CodeIgniter Community 2009.  ( Skype: insitfx )
Reply
#3

Yes, migrations can do multiple DB modifications (add tables, drop tables, add indexes, etc).

It is not considered bad form. Migration is a collection of steps necessary to upgrade/downgrade your database to the next/previous format, respectively

Schema::create('users', function($table)
{
$table->increments('id');
});

Schema::create('rights', function($table)
{
$table->increments('id');
});
Reply




Theme © iAndrew 2016 - Forum software by © MyBB