16 lines
373 B
TypeScript
16 lines
373 B
TypeScript
import * as Knex from "knex";
|
|
|
|
export async function createIPTable(knex: 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);
|
|
});
|
|
}
|
|
}
|