isbn-sort/isbn_sort/schema.sql

DROP TABLE IF EXISTS book;
DROP TABLE IF EXISTS user;

CREATE TABLE book (
    isbn INT PRIMARY KEY,
    title TEXT,
    author TEXT,
    status_ INT DEFAULT 0, -- 0: A lire, 1: Commence, 2: Lu
    owner_ TEXT DEFAULT '',
    category TEXT DEFAULT ''
);

CREATE TABLE user (
	id INTEGER PRIMARY KEY AUTOINCREMENT,
	username TEXT UNIQUE NOT NULL,
	password TEXT NOT NULL
);