17 lines
366 B
JavaScript
17 lines
366 B
JavaScript
async function createIPTable(knex) {
|
|
const hasTable = await knex.schema.hasTable("ips");
|
|
if (!hasTable) {
|
|
await knex.schema.createTable("ips", table => {
|
|
table.increments("id").primary();
|
|
table
|
|
.string("ip")
|
|
.unique()
|
|
.notNullable();
|
|
table.timestamps(false, true);
|
|
});
|
|
}
|
|
}
|
|
|
|
module.exports = {
|
|
createIPTable
|
|
} |