26 lines
586 B
JavaScript
26 lines
586 B
JavaScript
async function createHostTable(knex) {
|
|
const hasTable = await knex.schema.hasTable("hosts");
|
|
if (!hasTable) {
|
|
await knex.schema.createTable("hosts", table => {
|
|
table.increments("id").primary();
|
|
table
|
|
.string("address")
|
|
.unique()
|
|
.notNullable();
|
|
table
|
|
.boolean("banned")
|
|
.notNullable()
|
|
.defaultTo(false);
|
|
table
|
|
.integer("banned_by_id")
|
|
.unsigned()
|
|
.references("id")
|
|
.inTable("users");
|
|
table.timestamps(false, true);
|
|
});
|
|
}
|
|
}
|
|
|
|
module.exports = {
|
|
createHostTable
|
|
} |