Knex migrate alter table

PHOTO EMBED

Wed Aug 25 2021 07:36:51 GMT+0000 (Coordinated Universal Time)

Saved by @ExplodeMilk #typescript #knex

export async function up(knex: Knex) {
    if(await knex.schema.hasTable('teachers')){
        await knex.schema.alterTable('teachers',(table)=>{
            table.renameColumn("name","teacher_name");
            table.decimal("level",3).alter();
        });  
    }
};

export async function down(knex: Knex) {
    if(await knex.schema.hasTable("teachers")){
        await knex.schema.alterTable('teachers',(table)=>{
            table.renameColumn("teacher_name","name");
            table.string("level").alter();
        });
    }
};
content_copyCOPY