mirror of
https://github.com/flibusta-apps/book_library_server.git
synced 2026-03-02 22:55:21 +01:00
Bulat Kurbanov
c60aa8685b
Enable sqlx "migrate" feature and add SQL migrations to create the database schema: pg_trgm extension, sources, genres, authors, sequences, books, junction tables, annotations, and supporting indexes
6 lines
133 B
SQL
6 lines
133 B
SQL
-- Create sources table
|
|
CREATE TABLE IF NOT EXISTS sources (
|
|
id SMALLSERIAL PRIMARY KEY,
|
|
name VARCHAR(32) NOT NULL UNIQUE
|
|
);
|