CREATE MEMORY TABLE TIMERS(TIMERID VARCHAR(80) NOT NULL,TARGETID VARCHAR(80) NOT NULL,INITIALDATE TIMESTAMP NOT NULL,TIMERINTERVAL BIGINT,INSTANCEPK VARBINARY,INFO VARBINARY,CONSTRAINT TIMERS_PK PRIMARY KEY(TIMERID,TARGETID)) | |
CREATE MEMORY TABLE JMS_USERS(USERID VARCHAR(32) NOT NULL PRIMARY KEY,PASSWD VARCHAR(32) NOT NULL,CLIENTID VARCHAR(128)) | |
CREATE MEMORY TABLE JMS_ROLES(ROLEID VARCHAR(32) NOT NULL,USERID VARCHAR(32) NOT NULL,CONSTRAINT SYS_PK_JMS_ROLES PRIMARY KEY(USERID,ROLEID)) | |
CREATE MEMORY TABLE JMS_SUBSCRIPTIONS(CLIENTID VARCHAR(128) NOT NULL,SUBNAME VARCHAR(128) NOT NULL,TOPIC VARCHAR(255) NOT NULL,SELECTOR VARCHAR(255),CONSTRAINT SYS_PK_JMS_SUBSCRIPTIONS PRIMARY KEY(CLIENTID,SUBNAME)) | |
CREATE CACHED TABLE JMS_MESSAGES(MESSAGEID INTEGER NOT NULL,DESTINATION VARCHAR(255) NOT NULL,TXID INTEGER,TXOP CHAR(1),MESSAGEBLOB OBJECT,CONSTRAINT SYS_PK_JMS_MESSAGES PRIMARY KEY(MESSAGEID,DESTINATION)) | |
CREATE INDEX JMS_MESSAGES_TXOP_TXID ON JMS_MESSAGES(TXOP,TXID) | |
CREATE INDEX JMS_MESSAGES_DESTINATION ON JMS_MESSAGES(DESTINATION) | |
CREATE CACHED TABLE JMS_TRANSACTIONS(TXID INTEGER NOT NULL PRIMARY KEY) | |
CREATE MEMORY TABLE PUBLISHER(PUBLISHER_ID INTEGER NOT NULL,NAME VARCHAR(40),CONSTRAINT PK_PUBLISHER PRIMARY KEY(PUBLISHER_ID),CONSTRAINT UNQ_NAME UNIQUE(NAME)) | |
CREATE MEMORY TABLE PERSON(PERSON_ID INTEGER NOT NULL,EMAIL VARCHAR(60),PASSWD VARCHAR(20),FIRST_NAME VARCHAR(30),LAST_NAME VARCHAR(30),LOCKED_OUT BOOLEAN NOT NULL,ADMIN BOOLEAN NOT NULL,LAST_ACCESS TIMESTAMP,CONSTRAINT PK_PERSON PRIMARY KEY(PERSON_ID),CONSTRAINT UNQ_EMAIL UNIQUE(EMAIL)) | |
CREATE MEMORY TABLE BOOK(BOOK_ID INTEGER NOT NULL,DESCRIPTION VARCHAR(2000),PUBLISHER_ID INTEGER,HOLDER_ID INTEGER,ISBN VARCHAR(20),OWNER_ID INTEGER,TITLE VARCHAR(100),AUTHOR VARCHAR(100),HIDDEN BOOLEAN NOT NULL,LENDABLE BOOLEAN NOT NULL,DATE_ADDED TIMESTAMP,CONSTRAINT PK_BOOK PRIMARY KEY(BOOK_ID),CONSTRAINT HOLDER_FK FOREIGN KEY(HOLDER_ID) REFERENCES PERSON(PERSON_ID),CONSTRAINT OWNER_FK FOREIGN KEY(OWNER_ID) REFERENCES PERSON(PERSON_ID),CONSTRAINT PUBLISHER_FK FOREIGN KEY(PUBLISHER_ID) REFERENCES PUBLISHER(PUBLISHER_ID)) | |
CREATE MEMORY TABLE PROP(NAME VARCHAR(32) NOT NULL,PROP_VALUE INTEGER NOT NULL,CONSTRAINT PROP_PK PRIMARY KEY(NAME)) | |
CREATE MEMORY TABLE HILOSEQUENCES(SEQUENCENAME VARCHAR(50) NOT NULL,HIGHVALUES INTEGER NOT NULL,CONSTRAINT HILO_PK PRIMARY KEY(SEQUENCENAME)) | |
CREATE USER SA PASSWORD "" ADMIN | |
SET WRITE_DELAY 20 | |
INSERT INTO JMS_USERS VALUES('dynsub','dynsub',NULL) | |
INSERT INTO JMS_USERS VALUES('guest','guest',NULL) | |
INSERT INTO JMS_USERS VALUES('j2ee','j2ee',NULL) | |
INSERT INTO JMS_USERS VALUES('john','needle','DurableSubscriberExample') | |
INSERT INTO JMS_USERS VALUES('nobody','nobody',NULL) | |
INSERT INTO JMS_ROLES VALUES('durpublisher','dynsub') | |
INSERT INTO JMS_ROLES VALUES('publisher','dynsub') | |
INSERT INTO JMS_ROLES VALUES('guest','guest') | |
INSERT INTO JMS_ROLES VALUES('j2ee','guest') | |
INSERT INTO JMS_ROLES VALUES('john','guest') | |
INSERT INTO JMS_ROLES VALUES('durpublisher','john') | |
INSERT INTO JMS_ROLES VALUES('publisher','john') | |
INSERT INTO JMS_ROLES VALUES('subscriber','john') | |
INSERT INTO JMS_ROLES VALUES('noacc','nobody') | |
INSERT INTO PUBLISHER VALUES(5000,'O''Reilly') | |
INSERT INTO PUBLISHER VALUES(5050,'Apress') | |
INSERT INTO PUBLISHER VALUES(5052,'Addison-Wesley') | |
INSERT INTO PUBLISHER VALUES(5056,'Pragmatic Bookshelf') | |
INSERT INTO PUBLISHER VALUES(5059,'Manning') | |
INSERT INTO PUBLISHER VALUES(5062,'SAMS') | |
INSERT INTO PUBLISHER VALUES(5068,'Charles Scribner''s Sons') | |
INSERT INTO PUBLISHER VALUES(5070,'Tor Books') | |
INSERT INTO PUBLISHER VALUES(5072,'BasicBooks') | |
INSERT INTO PUBLISHER VALUES(5074,'Grove Press') | |
INSERT INTO PUBLISHER VALUES(5076,'Farrar Straus Giroux') | |
INSERT INTO PUBLISHER VALUES(5078,'Bantam New Age Books') | |
INSERT INTO PUBLISHER VALUES(5080,'Harper & Row') | |
INSERT INTO PUBLISHER VALUES(5082,'Doubleday') | |
INSERT INTO PUBLISHER VALUES(5084,'Houghton Mifflin Company') | |
INSERT INTO PUBLISHER VALUES(5086,'Doubleday Science Fiction') | |
INSERT INTO PUBLISHER VALUES(5100,'Vintage Books') | |
INSERT INTO PERSON VALUES(1000,'ringbearer@bagend.shire','secret','Frodo','Baggins',FALSE,TRUE,'2005-09-27 17:21:25.0') | |
INSERT INTO PERSON VALUES(1001,'squeue@bug.org','secret','Suzy','Queue',FALSE,FALSE,'2005-09-27 18:37:45.688') | |
INSERT INTO PERSON VALUES(1002,'dilbert@bigco.com','secret','Dilbert','CubeDweller',FALSE,FALSE,'2005-09-27 17:37:34.896') | |
INSERT INTO BOOK VALUES(5001,'Very quick and light introduction to installing and deploying into JBoss.',5000,1002,'0-596-10007-8',1002,'JBoss A Developer''s Notebook','Norman Richards, Sam Griffith, Jr.',FALSE,TRUE,'2005-09-27 16:53:00.44') | |
INSERT INTO BOOK VALUES(5051,NULL,5050,1002,'1-59059-511-4',1002,'Pro Hibernate 3','Dave Minter, Jeff Linwood',FALSE,TRUE,'2005-09-27 17:38:10.738') | |
INSERT INTO BOOK VALUES(5053,'Dated but still handy reference.',5052,1002,'0-201-74095-8',1002,'Essential XML Quick Reference','Skonnard and Gudgin',FALSE,TRUE,'2005-09-27 17:39:03.604') | |
INSERT INTO BOOK VALUES(5054,'Well thumbed, well worn, used constantly.',5000,1002,'1-56592-494-0',1002,'Dynamic HTML: The Definitive Reference','Danny Googman',FALSE,FALSE,'2005-09-27 17:40:07.025') | |
INSERT INTO BOOK VALUES(5055,NULL,5000,1002,'1-56592-433-9',1002,'TCL/TK In A Nutshell','Paul Raines and Jeff Tranter',FALSE,TRUE,'2005-09-27 17:40:46.191') | |
INSERT INTO BOOK VALUES(5057,'2nd edition of "The Pick-axe", covers Ruby 1.8. This is the book I had to replace after spilling Nyquill all over it.',5056,1002,'074514055',1002,'Programming Ruby','Dave Thomas',FALSE,TRUE,'2005-09-27 17:41:59.026') | |
INSERT INTO BOOK VALUES(5058,'Hard cover, heavy duty, indispensible',5052,1002,'0-201-63361-2',1002,'Design Patterns: Elements of Reusable Object-Oriented Software','Gamma, Helm, Johnson, Vlissides',FALSE,TRUE,'2005-09-27 17:43:19.151') | |
INSERT INTO BOOK VALUES(5060,NULL,5059,1002,'1-932394-35-4',1002,'Spring In Action','Craig Walls, Ryan Breidenbach',FALSE,TRUE,'2005-09-27 17:44:01.442') | |
INSERT INTO BOOK VALUES(5061,'Getting more use now, what with all the AJAX buzz.',5000,1002,'1-56592-392-8',1002,'JavaScript The Definitive Guide','David Flannagan',FALSE,TRUE,'2005-09-27 17:44:54.458') | |
INSERT INTO BOOK VALUES(5063,'More of a cookbook, less of a language guide than "The Pickaxe"',5062,1002,'0-672-32083-5',1002,'The Ruby Way','Hal Fulton',FALSE,TRUE,'2005-09-27 17:46:19.781') | |
INSERT INTO BOOK VALUES(5064,NULL,5059,1002,'1-932394-28-1',1002,'Lucene in Action','Erik Hatcher, Otis Gospodnetic',FALSE,TRUE,'2005-09-27 17:46:58.366') | |
INSERT INTO BOOK VALUES(5065,NULL,5052,1002,'0-321-20068-3',1002,'Enterprise Integration Patterns','Gregor Hohpe, Bobby Woolf',FALSE,TRUE,'2005-09-27 17:47:37.943') | |
INSERT INTO BOOK VALUES(5066,NULL,5059,1002,'1-930110-58-8',1002,'Java Development with Ant','Erik Hatcher, Steve Loughram',FALSE,TRUE,'2005-09-27 17:48:06.194') | |
INSERT INTO BOOK VALUES(5067,NULL,5000,1002,'0-596-00525-3',1002,'Cascading Style Sheets The Definitive Guide','Eric A. Meyer',FALSE,TRUE,'2005-09-27 17:48:41.615') | |
INSERT INTO BOOK VALUES(5069,NULL,5068,1001,'0-684-14103-5',1001,'Designs in Metal','Paul Bridge, Austin Crossland',FALSE,TRUE,'2005-09-27 17:51:38.77') | |
INSERT INTO BOOK VALUES(5071,'Combines "Ender''s Game" with "Speaker for the Dead"',5070,1001,NULL,1001,'Ender''s War','Orson Scott Card',FALSE,TRUE,'2005-09-27 17:52:38.856') | |
INSERT INTO BOOK VALUES(5073,NULL,5072,1001,'0-465-04566-9',1001,'Metamagical Themas: Questing for the Essence of Mind and Pattern','Douglas R. Hofstadter',FALSE,TRUE,'2005-09-27 17:53:25.303') | |
INSERT INTO BOOK VALUES(5075,NULL,5074,1001,'0-8021-3507-2',1001,'Stripper Lessons','John O''Brien',FALSE,TRUE,'2005-09-27 17:53:59.091') | |
INSERT INTO BOOK VALUES(5077,NULL,5076,1001,'0-374-28645-0',1001,'War Fever','J. G. Ballard',FALSE,TRUE,'2005-09-27 17:54:53.479') | |
INSERT INTO BOOK VALUES(5079,NULL,5078,1001,'0-533-34668-7',1001,'"Surely You''re Joking, Mr. Feynman" Adventures of a Curious Character','Richard P. Feynman',FALSE,TRUE,'2005-09-27 17:55:47.047') | |
INSERT INTO BOOK VALUES(5081,NULL,5080,1001,NULL,1001,'An Alien Heat','Michael Moorcock',FALSE,TRUE,'2005-09-27 17:57:05.059') | |
INSERT INTO BOOK VALUES(5083,NULL,5082,1001,NULL,1001,'The Stone That Never Came Down','John Brunner',FALSE,TRUE,'2005-09-27 17:58:05.285') | |
INSERT INTO BOOK VALUES(5085,NULL,5084,1001,NULL,1001,'Best American Short Stories 1995','Smiley, Kenison',FALSE,TRUE,'2005-09-27 17:59:01.917') | |
INSERT INTO BOOK VALUES(5087,NULL,5086,1001,'0-385-19134-0',1001,'Universe 14','Terry Carr',FALSE,TRUE,'2005-09-27 17:59:59.64') | |
INSERT INTO BOOK VALUES(5101,NULL,5100,1001,'0-394-75682-7',1001,'Godel, Escher, Bach: An Eternal Golden Braid','Douglas R. Hofstadter',FALSE,TRUE,'2005-09-27 18:06:16.331') | |
INSERT INTO PROP VALUES('next-key',5150) | |
INSERT INTO HILOSEQUENCES VALUES('general',0) |