Reading Log

schema.js 2 lines

Files · 8

emits.js20 lines
index.jsx274 lines
listens.js8 lines
manifest.json274 lines
schema.js2 lines
schema.sql16 lines
store.js26 lines
style.css85 lines

12// Kept byte-for-byte equivalent to schema.sql; bundled without a runtime fetch.
export default "CREATE TABLE books (\n  book_id INTEGER PRIMARY KEY,\n  title TEXT NOT NULL,\n  author TEXT NOT NULL,\n  isbn TEXT NOT NULL DEFAULT '',\n  isbn13 TEXT NOT NULL DEFAULT '',\n  my_rating INTEGER NOT NULL DEFAULT 0 CHECK (my_rating BETWEEN 0 AND 5),\n  average_rating REAL NOT NULL DEFAULT 0 CHECK (average_rating BETWEEN 0 AND 5),\n  number_of_pages INTEGER CHECK (number_of_pages >= 0),\n  date_read TEXT NOT NULL DEFAULT '',\n  date_added TEXT NOT NULL DEFAULT '',\n  bookshelves TEXT NOT NULL DEFAULT '',\n  exclusive_shelf TEXT NOT NULL DEFAULT 'to-read' CHECK (exclusive_shelf IN ('to-read', 'currently-reading', 'read')),\n  my_review TEXT NOT NULL DEFAULT '',\n  read_count INTEGER NOT NULL DEFAULT 0 CHECK (read_count >= 0)\n);\n";