CREATE USER 'sa' PASSWORD '' ADMIN; CREATE TABLE ps_object (ps_oid BIGINT PRIMARY KEY, ps_class VARCHAR(32), ps_table VARCHAR(32), ps_flags INTEGER, ps_cotime TIMESTAMP, ps_lstime TIMESTAMP); CREATE TABLE ps_class (jname VARCHAR(32) PRIMARY KEY, name VARCHAR(32), make VARCHAR(32)); CREATE TABLE ps_field (jcname VARCHAR(32), jname VARCHAR(32), name VARCHAR(32), modifier INTEGER, distal_jcname VARCHAR(32), distal_jname VARCHAR(32)); INSERT INTO ps_class VALUES ('rmrs.persist.test.Person', 'person', NULL); INSERT INTO ps_field VALUES ('rmrs.persist.test.Person', 'name', 'pname', 1, NULL, NULL); INSERT INTO ps_field VALUES ('rmrs.persist.test.Person', 'address', 'paddress', 1, NULL, NULL); INSERT INTO ps_field VALUES ('rmrs.persist.test.Person', 'birth_dttm', 'pdob', 1, NULL, NULL); INSERT INTO ps_class VALUES ('rmrs.persist.test.Patient', 'patient', 'newInstance'); INSERT INTO ps_field VALUES ('rmrs.persist.test.Patient', 'mrn', 'patmrn', 1, NULL, NULL); INSERT INTO ps_field VALUES ('rmrs.persist.test.Patient', 'doctor', 'pdoctor', 26, NULL, NULL); INSERT INTO ps_field VALUES ('rmrs.persist.test.Patient', 'observations', 'subject', 1578, 'rmrs.persist.test.Observation', 'patient'); INSERT INTO ps_class VALUES ('rmrs.persist.test.Observation', 'observation', NULL); INSERT INTO ps_field VALUES ('rmrs.persist.test.Observation', 'patient', 'subject', 26, NULL, NULL); INSERT INTO ps_field VALUES ('rmrs.persist.test.Observation', 'name', 'name', 1, NULL, NULL); INSERT INTO ps_field VALUES ('rmrs.persist.test.Observation', 'value', 'value', 6, NULL, NULL); INSERT INTO ps_field VALUES ('rmrs.persist.test.Observation', 'unit', 'unit', 1, NULL, NULL); INSERT INTO ps_field VALUES ('rmrs.persist.test.Observation', 'time', 'dttm', 1, NULL, NULL); INSERT INTO ps_class VALUES ('rmrs.persist.test.Interval', 'interval', NULL); INSERT INTO ps_field VALUES ('rmrs.persist.test.Interval', 'low', '_low', 1, NULL, NULL); INSERT INTO ps_field VALUES ('rmrs.persist.test.Interval', 'high', '_high', 1, NULL, NULL); CREATE TABLE person (ps_oid BIGINT PRIMARY KEY, pname VARCHAR(32), paddress VARCHAR(32), pdob TIMESTAMP); CREATE TABLE patient (ps_oid BIGINT PRIMARY KEY, patmrn VARCHAR(32), pdoctor BIGINT); CREATE TABLE observation (ps_oid BIGINT PRIMARY KEY, subject BIGINT, name VARCHAR(32), value_low REAL, value_high REAL, unit VARCHAR(16), dttm TIMESTAMP); SET AUTOCOMMIT FALSE INSERT INTO PS_OBJECT VALUES(1,'rmrs.persist.test.Person','person',19,NULL,'1999-12-03 23:48:31.94') SET AUTOCOMMIT FALSE INSERT INTO PERSON VALUES(1,'Dr. Smith','Indianapolis','1957-11-15 00:00:00.0') SET AUTOCOMMIT FALSE INSERT INTO PS_OBJECT VALUES(2,'rmrs.persist.test.Patient','patient',19,NULL,'1999-12-03 23:48:32.11') SET AUTOCOMMIT FALSE INSERT INTO PATIENT VALUES(2,'123-45-6789',1) SET AUTOCOMMIT FALSE INSERT INTO PERSON VALUES(2,'Hans Meier','Berlin','1966-03-19 00:00:00.0') SET AUTOCOMMIT FALSE INSERT INTO PS_OBJECT VALUES(3,'rmrs.persist.test.Patient','patient',19,NULL,'1999-12-03 23:48:32.16') SET AUTOCOMMIT FALSE INSERT INTO PATIENT VALUES(3,'987-65-4321',NULL) SET AUTOCOMMIT FALSE INSERT INTO PERSON VALUES(3,'Peter Mueller','Sondheim','1969-05-10 00:00:00.0') SET AUTOCOMMIT FALSE INSERT INTO PS_OBJECT VALUES(4,'rmrs.persist.test.Observation','observation',19,NULL,'1999-12-03 23:48:32.22') SET AUTOCOMMIT FALSE INSERT INTO OBSERVATION VALUES(4,2,'Na',135.0,138.0,'mmol/L','1999-12-03 23:48:31.94') SET AUTOCOMMIT FALSE INSERT INTO PS_OBJECT VALUES(5,'rmrs.persist.test.Observation','observation',19,NULL,'1999-12-03 23:48:32.27') SET AUTOCOMMIT FALSE INSERT INTO OBSERVATION VALUES(5,2,'K',3.8,4.0,'mmol/L','1999-12-03 23:48:31.94') SET AUTOCOMMIT FALSE INSERT INTO PS_OBJECT VALUES(6,'rmrs.persist.test.Observation','observation',19,NULL,'1999-12-03 23:48:32.27') SET AUTOCOMMIT FALSE INSERT INTO OBSERVATION VALUES(6,2,'Cl',95.4,97.0,'mmol/L','1999-12-03 23:48:31.94') SET AUTOCOMMIT FALSE DELETE FROM PS_OBJECT WHERE PS_OID=2 INSERT INTO PS_OBJECT VALUES(2,'rmrs.persist.test.Patient','patient',18,NULL,'1999-12-03 23:48:32.38') SET AUTOCOMMIT FALSE DELETE FROM PS_OBJECT WHERE PS_OID=4 INSERT INTO PS_OBJECT VALUES(4,'rmrs.persist.test.Observation','observation',18,NULL,'1999-12-03 23:48:32.44') SET AUTOCOMMIT FALSE DELETE FROM OBSERVATION WHERE PS_OID=4 INSERT INTO OBSERVATION VALUES(4,2,'Na',135.0,138.0,'mmol/L','1999-12-03 23:48:31.94') SET AUTOCOMMIT FALSE DELETE FROM PS_OBJECT WHERE PS_OID=5 INSERT INTO PS_OBJECT VALUES(5,'rmrs.persist.test.Observation','observation',18,NULL,'1999-12-03 23:48:32.49') SET AUTOCOMMIT FALSE DELETE FROM OBSERVATION WHERE PS_OID=5 INSERT INTO OBSERVATION VALUES(5,2,'K',3.8,4.0,'mmol/L','1999-12-03 23:48:31.94') SET AUTOCOMMIT FALSE DELETE FROM PS_OBJECT WHERE PS_OID=6 INSERT INTO PS_OBJECT VALUES(6,'rmrs.persist.test.Observation','observation',18,NULL,'1999-12-03 23:48:32.49') SET AUTOCOMMIT FALSE DELETE FROM OBSERVATION WHERE PS_OID=6 INSERT INTO OBSERVATION VALUES(6,2,'Cl',95.4,97.0,'mmol/L','1999-12-03 23:48:31.94') SET AUTOCOMMIT FALSE DELETE FROM PATIENT WHERE PS_OID=2 INSERT INTO PATIENT VALUES(2,'123-45-6789',1) SET AUTOCOMMIT FALSE DELETE FROM PERSON WHERE PS_OID=2 INSERT INTO PERSON VALUES(2,'Hans Meier','Berlin','1966-03-19 00:00:00.0') SET AUTOCOMMIT FALSE INSERT INTO PS_OBJECT VALUES(7,'rmrs.persist.test.Person','person',19,NULL,'1999-12-05 01:04:45.04') SET AUTOCOMMIT FALSE INSERT INTO PERSON VALUES(7,'Dr. Smith','Indianapolis','1957-11-15 00:00:00.0') SET AUTOCOMMIT FALSE INSERT INTO PS_OBJECT VALUES(8,'rmrs.persist.test.Patient','patient',19,NULL,'1999-12-05 01:04:45.37') SET AUTOCOMMIT FALSE INSERT INTO PATIENT VALUES(8,'123-45-6789',7) SET AUTOCOMMIT FALSE INSERT INTO PERSON VALUES(8,'Hans Meier','Berlin','1966-03-19 00:00:00.0') SET AUTOCOMMIT FALSE INSERT INTO PS_OBJECT VALUES(9,'rmrs.persist.test.Patient','patient',19,NULL,'1999-12-05 01:04:45.42') SET AUTOCOMMIT FALSE INSERT INTO PATIENT VALUES(9,'987-65-4321',NULL) SET AUTOCOMMIT FALSE INSERT INTO PERSON VALUES(9,'Peter Mueller','Sondheim','1969-05-10 00:00:00.0') SET AUTOCOMMIT FALSE INSERT INTO PS_OBJECT VALUES(10,'rmrs.persist.test.Observation','observation',19,NULL,'1999-12-05 01:04:45.53') SET AUTOCOMMIT FALSE INSERT INTO OBSERVATION VALUES(10,8,'Na',135.0,138.0,'mmol/L','1999-12-05 01:04:44.98') SET AUTOCOMMIT FALSE INSERT INTO PS_OBJECT VALUES(11,'rmrs.persist.test.Observation','observation',19,NULL,'1999-12-05 01:04:45.59') SET AUTOCOMMIT FALSE INSERT INTO OBSERVATION VALUES(11,8,'K',3.8,4.0,'mmol/L','1999-12-05 01:04:44.98') SET AUTOCOMMIT FALSE INSERT INTO PS_OBJECT VALUES(12,'rmrs.persist.test.Observation','observation',19,NULL,'1999-12-05 01:04:45.64') SET AUTOCOMMIT FALSE INSERT INTO OBSERVATION VALUES(12,8,'Cl',95.4,97.0,'mmol/L','1999-12-05 01:04:44.98') SET AUTOCOMMIT FALSE DELETE FROM PS_OBJECT WHERE PS_OID=8 INSERT INTO PS_OBJECT VALUES(8,'rmrs.persist.test.Patient','patient',18,NULL,'1999-12-05 01:04:45.64') SET AUTOCOMMIT FALSE DELETE FROM PS_OBJECT WHERE PS_OID=10 INSERT INTO PS_OBJECT VALUES(10,'rmrs.persist.test.Observation','observation',18,NULL,'1999-12-05 01:04:45.7') SET AUTOCOMMIT FALSE DELETE FROM OBSERVATION WHERE PS_OID=10 INSERT INTO OBSERVATION VALUES(10,8,'Na',135.0,138.0,'mmol/L','1999-12-05 01:04:44.98') SET AUTOCOMMIT FALSE DELETE FROM PS_OBJECT WHERE PS_OID=11 INSERT INTO PS_OBJECT VALUES(11,'rmrs.persist.test.Observation','observation',18,NULL,'1999-12-05 01:04:45.75') SET AUTOCOMMIT FALSE DELETE FROM OBSERVATION WHERE PS_OID=11 INSERT INTO OBSERVATION VALUES(11,8,'K',3.8,4.0,'mmol/L','1999-12-05 01:04:44.98') SET AUTOCOMMIT FALSE DELETE FROM PS_OBJECT WHERE PS_OID=12 INSERT INTO PS_OBJECT VALUES(12,'rmrs.persist.test.Observation','observation',18,NULL,'1999-12-05 01:04:45.75') SET AUTOCOMMIT FALSE DELETE FROM OBSERVATION WHERE PS_OID=12 INSERT INTO OBSERVATION VALUES(12,8,'Cl',95.4,97.0,'mmol/L','1999-12-05 01:04:44.98') SET AUTOCOMMIT FALSE DELETE FROM PATIENT WHERE PS_OID=8 INSERT INTO PATIENT VALUES(8,'123-45-6789',7) SET AUTOCOMMIT FALSE DELETE FROM PERSON WHERE PS_OID=8 INSERT INTO PERSON VALUES(8,'Hans Meier','Berlin','1966-03-19 00:00:00.0') SET AUTOCOMMIT FALSE SET AUTOCOMMIT FALSE SET AUTOCOMMIT FALSE SET AUTOCOMMIT FALSE SET AUTOCOMMIT FALSE SET AUTOCOMMIT FALSE SET AUTOCOMMIT FALSE SET AUTOCOMMIT FALSE SET AUTOCOMMIT FALSE SET AUTOCOMMIT FALSE