17 lines
372 B
SQL
17 lines
372 B
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
|
|
); |