スã‚ーマã?«ã‚ˆã‚Šæƒ…å ±ã‚’è«–ç?†çš„ã?«ä¸€ã?¤ã?®é›†å?ˆã?«åˆ†é¡žã?™ã‚‹ã?“ã?¨ã€?ã?Šã‚ˆã?³ã€?一æ„?ã?ªå??å‰?空間をæ??ä¾›ã?™ã‚‹äº‹ã?Œã?§ã??ã?¾ã?™ã€‚
CREATE SCHEMA { [ スã‚ーマå?? AUTHORIZATION ユーザå?? ] | [ スã‚ーマå?? ] | [ AUTHORIZATION ユーザå?? ] }
CREATE SCHEMA æ–‡ã?«ã‚ˆã‚Šã‚¹ã‚ーマを作æˆ?ã?™ã‚‹ã?“ã?¨ã?Œã?§ã??ã?¾ã?™ã€‚スã‚ーマå??ã?¯128æ–‡å—ã‚’è¶…ã?ˆã?¦ã?¯ã?ªã‚Šã?¾ã?›ã‚“。スã‚ーマå??ã?¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã?®å†…ã?§ä¸€æ„?ã?§ç„¡ã?‘れã?°ã?ªã‚Šã?¾ã?›ã‚“。
AUTHORIZATION user-nameを指定ã?§ã??ã?¾ã?™ã€‚ derby.database.sqlAuthorization属性ã?«ã?¤ã?„ã?¦ã?®ã‚ˆã‚Šè©³ç´°ã?ªæƒ…å ±ã?¯ã€?Derbyã?®ãƒ?ューニングをå?‚ç…§ã?—ã?¦ã??ã? ã?•ã?„。
CREATE SCHEMA FLIGHTS AUTHORIZATION anita
CREATE SCHEMA EMP
CREATE SCHEMA AUTHORIZATION takumi
CREATE TABLE FLIGHTS.AVAILABILITY (FLIGHT_ID CHAR(6) NOT NULL, SEGMENT_NUMBER INT NOT NULL, FLIGHT_DATE DATE NOT NULL, ECONOMY_SEATS_TAKEN INT, BUSINESS_SEATS_TAKEN INT, FIRSTCLASS_SEATS_TAKEN INT, CONSTRAINT FLT_AVAIL_PK PRIMARY KEY (FLIGHT_ID, SEGMENT_NUMBER, FLIGHT_DATE))
CREATE TABLE EMP.AVAILABILITY (HOTEL_ID INT NOT NULL, BOOKING_DATE DATE NOT NULL, ROOMS_TAKEN INT, CONSTRAINT HOTELAVAIL_PK PRIMARY KEY (HOTEL_ID, BOOKING_DATE))