js+创建access表

npm install sqlite3

const sqlite3 = require('sqlite3').verbose();

// 打开数据库（如果不存在，则创建）
let db = new sqlite3.Database(':memory:', (err) => {
  if (err) {
    return console.error(err.message);
  }
  console.log('Connected to the in-memory SQlite database.');
});

// 创建access表的SQL语句
const createTableSQL = `
CREATE TABLE IF NOT EXISTS access (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  username TEXT NOT NULL,
  password TEXT NOT NULL,
  email TEXT UNIQUE NOT NULL,
  created_at DATETIME DEFAULT CURRENT_TIMESTAMP
);
`;

// 执行创建表的SQL语句
db.run(createTableSQL, function(err) {
  if (err) {
    return console.error(err.message);
  }
  console.log(`Table 'access' created successfully with rowid ${this.lastID}`);
});

// 关闭数据库连接
db.close((err) => {
  if (err) {
    return console.error(err.message);
  }
  console.log('Close the database connection.');
});