CREATE SCHEMA PUBLIC AUTHORIZATION DBA
CREATE MEMORY TABLE PUBLISHER(NAME VARCHAR(255) NOT NULL PRIMARY KEY,REVENUE FLOAT)
CREATE MEMORY TABLE MAGAZINE(ISBN VARCHAR(8) NOT NULL,ISSUE INTEGER NOT NULL,NAME VARCHAR(255),PRICE FLOAT NOT NULL,PUBLISHER_NAME VARCHAR(255),PRIMARY KEY(ISBN,ISSUE),CONSTRAINT SYS_FK_1 FOREIGN KEY(PUBLISHER_NAME) REFERENCES PUBLISHER(NAME))
CREATE MEMORY TABLE ARTICLE(AUTHOR_NAME VARCHAR(128),TITLE VARCHAR(255) NOT NULL PRIMARY KEY)
CREATE MEMORY TABLE MAGAZINE_ARTICLES(ARTICLE_TITLE VARCHAR(255),MAGAZINE_ISBN VARCHAR(8),MAGAZINE_ISSUE INTEGER,CONSTRAINT SYS_FK_2 FOREIGN KEY(ARTICLE_TITLE) REFERENCES ARTICLE(TITLE),CONSTRAINT SYS_FK_3 FOREIGN KEY(MAGAZINE_ISBN,MAGAZINE_ISSUE) REFERENCES MAGAZINE(ISBN,ISSUE))
CREATE MEMORY TABLE JDO_SCHEMA_METADATAX(CLASSNAMEX VARCHAR(255))
CREATE USER SA PASSWORD ""
GRANT DBA TO SA
SET WRITE_DELAY 20
SET SCHEMA PUBLIC
INSERT INTO PUBLISHER VALUES('Adventure',1.897489E7)
INSERT INTO PUBLISHER VALUES('Brandon-Hall',200000.0E0)
INSERT INTO PUBLISHER VALUES('Reuters',9.038736E7)
INSERT INTO MAGAZINE VALUES('120-204C',1093,'Newsweek',4.989999771118164E0,'Adventure')
INSERT INTO MAGAZINE VALUES('534-194G',651,'People',3.990000009536743E0,'Adventure')
INSERT INTO MAGAZINE VALUES('783-139B',102,'Java Pro',5.75E0,'Brandon-Hall')
INSERT INTO MAGAZINE VALUES('831-508B',237,'Nature',8.989999771118164E0,'Reuters')
INSERT INTO MAGAZINE VALUES('896-501B',152,'Science',7.489999771118164E0,'Reuters')
INSERT INTO MAGAZINE VALUES('983-332Y',942,'Vogue',3.990000009536743E0,'Adventure')
INSERT INTO ARTICLE VALUES('Robert Gross','Bush vs. Hussein')
INSERT INTO ARTICLE VALUES('Sarah Fleury','Echos from the Big Bang')
INSERT INTO ARTICLE VALUES('Stephanie Lang','Fall''s Fashion')
INSERT INTO ARTICLE VALUES('Stephanie Lang','Girl Power')
INSERT INTO ARTICLE VALUES('Craig Russell','JDO for Transparent Persistence')
INSERT INTO ARTICLE VALUES('Stephanie Lang','Light Up Those Lips')
INSERT INTO ARTICLE VALUES('NASA','Next Generation Telescope')
INSERT INTO ARTICLE VALUES('Jordan Gestapalo','Romance in the 21st Century')
INSERT INTO ARTICLE VALUES('Marc Eaton','Session Bean Facade')
INSERT INTO MAGAZINE_ARTICLES VALUES('JDO for Transparent Persistence','783-139B',102)
INSERT INTO MAGAZINE_ARTICLES VALUES('Session Bean Facade','783-139B',102)
INSERT INTO MAGAZINE_ARTICLES VALUES('Girl Power','534-194G',651)
INSERT INTO MAGAZINE_ARTICLES VALUES('Girl Power','983-332Y',942)
INSERT INTO MAGAZINE_ARTICLES VALUES('Romance in the 21st Century','534-194G',651)
INSERT INTO MAGAZINE_ARTICLES VALUES('Fall''s Fashion','983-332Y',942)
INSERT INTO MAGAZINE_ARTICLES VALUES('Light Up Those Lips','983-332Y',942)
INSERT INTO MAGAZINE_ARTICLES VALUES('Bush vs. Hussein','120-204C',1093)
INSERT INTO MAGAZINE_ARTICLES VALUES('Echos from the Big Bang','896-501B',152)
INSERT INTO MAGAZINE_ARTICLES VALUES('Echos from the Big Bang','831-508B',237)
INSERT INTO MAGAZINE_ARTICLES VALUES('Next Generation Telescope','831-508B',237)