/* Å×ÀÌºí »ý¼º */
CREATE TABLE "BOOK_LOG" (
  "BOOK_SEQ"        INTEGER NOT NULL,
  "BOOK_TITLE"      VARCHAR(50) NOT NULL,
  "BOOK_AUTHOR"     VARCHAR(30) NOT NULL,
  "BOOK_PUBLISHER"  VARCHAR(30),
  "BOOK_PHONE"      VARCHAR(20),
  "BOOK_WEBSITE"    VARChAR(100),
  "BOOK_COMMENT"    VARCHAR(1000),
  "BOOK_THUMB"      BLOB SUB_TYPE 0 SEGMENT SIZE 80,
  "BOOK_IMAGE"      BLOB SUB_TYPE 0 SEGMENT SIZE 80,
  CONSTRAINT "BOOK_SEQ_PK" PRIMARY KEY ("BOOK_SEQ")
);
 
/* BOOK_SEQ ÀÚµ¿Áõ°¡ */
CREATE GENERATOR "BOOK_SEQ_GEN";
CREATE TRIGGER "SET_BOOK_SEQ" FOR "BOOK_LOG"
ACTIVE BEFORE INSERT POSITION 0 AS
BEGIN
    new.BOOK_SEQ = gen_id(BOOK_SEQ_GEN, 1);
END;