CREATE TABLE author
(
	  id   INTEGER     PRIMARY KEY
	, name LONGVARCHAR NOT NULL
	, kana LONGVARCHAR NOT NULL
)

ALTER TABLE author ADD sex LONGVARCHAR

ALTER TABLE author ALTER COLUMN sex SET NOT NULL

CREATE TABLE book
(
	  id        INTEGER   PRIMARY KEY
	, author_id INTEGER   NOT NULL
	, title   LONGVARCHAR NOT NULL
)

