16 lines
329 B
JavaScript
16 lines
329 B
JavaScript
import Database from "better-sqlite3";
|
|
|
|
const InitDB = () => {
|
|
const db = new Database("./db/users.db", null);
|
|
const createTable = `CREATE TABLE IF NOT EXISTS users (
|
|
id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
|
|
nick TEXT,
|
|
city TEXT,
|
|
createdAt TEXT
|
|
)`;
|
|
|
|
db.exec(createTable);
|
|
};
|
|
|
|
export default InitDB;
|