personalweb

archived
git clone git://git.wimdupont.com/personalweb.git
Log | Files | Refs | LICENSE

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 )