users.sql

/*

 Navicat Premium Dump SQL



 Source Server         : api_keys

 Source Server Type    : SQLite

 Source Server Version : 3045000 (3.45.0)

 Source Schema         : main



 Target Server Type    : SQLite

 Target Server Version : 3045000 (3.45.0)

 File Encoding         : 65001



 Date: 03/11/2024 20:45:36

*/

PRAGMA foreign_keys = false;

-- ----------------------------
-- Table structure for users
-- ----------------------------
DROP TABLE IF EXISTS "users";
CREATE TABLE "users" (
  "id" INTEGER PRIMARY KEY AUTOINCREMENT,
  "username" TEXT NOT NULL,
  "password" TEXT NOT NULL,
  "email" TEXT NOT NULL,
  "nikename" TEXT,
  "api_key" TEXT,
  "config" TEXT,
  "created_at" DATETIME DEFAULT CURRENT_TIMESTAMP,
  "updated_at" DATETIME DEFAULT CURRENT_TIMESTAMP,
  UNIQUE ("username" ASC),
  UNIQUE ("email" ASC)
);

-- ----------------------------
-- Auto increment value for users
-- ----------------------------
UPDATE "sqlite_sequence" SET seq = 5 WHERE name = 'users';

PRAGMA foreign_keys = true;