SET NAMES SJIS_0208;

CREATE DATABASE "booklist.gdb";

CREATE TABLE COMPANIES
(
	company_code	CHAR(3)			NOT NULL,
	company_name	VARCHAR(60)		CHARACTER SET SJIS_0208 NOT NULL,

	PRIMARY KEY(company_code)

);

CREATE TABLE books
(
	book_code	CHAR(4)			NOT NULL,
	book_name	VARCHAR(60)		CHARACTER SET SJIS_0208 NOT NULL,
	company_code	CHAR(3),
	price		INTEGER,

	PRIMARY KEY( book_code ),
	FOREIGN KEY( company_code )	REFERENCES COMPANIES( company_code )

);

COMMIT;

QUIT;