| 1 | // Add deleted column to users in order to soft delete users
|
| 2 | exports.up = async function(knex, Promise) {
|
| 3 | await knex.schema.alterTable("users", table => {
|
| 4 | table
|
| 5 | .boolean("deleted")
|
| 6 | .notNullable()
|
| 7 | .defaultTo(false);
|
| 8 | });
|
| 9 | };
|
| 10 |
|
| 11 | exports.down = async function(knex, Promise) {
|
| 12 | const { client } = knex.client.config;
|
| 13 |
|
| 14 | // TODO: find a solution to drop column in sqlite without foreign key violations
|
| 15 | if (client !== "sqlite3") {
|
| 16 | await knex.schema.alterTable("users", table => {
|
| 17 | table.dropColumn("deleted");
|
| 18 | });
|
| 19 | }
|
| 20 | };
|