V1_0__db-init.sql (275B)
1 CREATE TABLE IF NOT EXISTS book ( 2 id VARCHAR(36) primary key NOT NULL, 3 title VARCHAR(200) NOT NULL, 4 author VARCHAR(500) NOT NULL, 5 isbn VARCHAR(100) UNIQUE NOT NULL, 6 category VARCHAR(100) NOT NULL, 7 series VARCHAR(200), 8 series_number DECIMAL(2,1) 9 )