blob: 1ca519563fc7eea8659226b8006fbb0a3b27ae9d (
plain)
1
2
3
4
5
6
7
8
9
|
const sqlite3 = require('sqlite3').verbose();
const db = new sqlite3.Database('./app.db');
db.serialize(() => {
db.run(`CREATE TABLE IF NOT EXISTS users (
id INTEGER PRIMARY KEY, username TEXT UNIQUE, password TEXT)`);
db.run(`CREATE TABLE IF NOT EXISTS items (
id INTEGER PRIMARY KEY, user_id INTEGER, title TEXT, content TEXT)`);
});
module.exports = db;
|
