CREATE TABLE C__SCHEMA_VERSION(VERSION INTEGER);
INSERT INTO  C__SCHEMA_VERSION  (VERSION ) values (2);
CREATE TABLE C__INDEX(TABLE_NAME LONGTEXT,COLUMN_NAME LONGTEXT,INDEX_NAME LONGTEXT);
CREATE TABLE C__IS_A(SUPERCLASS LONGTEXT,SUBCLASS LONGTEXT);
CREATE INDEX C__IS_A_SUPERCLASS_INDEX on C__IS_A(SUPERCLASS(191));
INSERT INTO C__INDEX(TABLE_NAME,INDEX_NAME,COLUMN_NAME)VALUES('C__IS_A','C__IS_A_SUPERCLASS_INDEX','SUPERCLASS(191)');
CREATE TABLE C__HAS_A(OWNER_TABLE INTEGER,OWNER_ID BIGINT,RELATION_NAME INTEGER,PROPERTY_TABLE INTEGER,PROPERTY_ID BIGINT,PROPERTY_CLASS INTEGER);
CREATE INDEX C__HAS_A_OWNER_INDEX on C__HAS_A(OWNER_TABLE,OWNER_ID);
INSERT INTO C__INDEX(TABLE_NAME,INDEX_NAME,COLUMN_NAME)VALUES('C__HAS_A','C__HAS_A_OWNER_INDEX','OWNER_TABLE');
INSERT INTO C__INDEX(TABLE_NAME,INDEX_NAME,COLUMN_NAME)VALUES('C__HAS_A','C__HAS_A_OWNER_INDEX','OWNER_ID');
CREATE INDEX C__HAS_A_PROPERTY_INDEX on C__HAS_A(PROPERTY_TABLE,PROPERTY_ID);
INSERT INTO C__INDEX(TABLE_NAME,INDEX_NAME,COLUMN_NAME)VALUES('C__HAS_A','C__HAS_A_PROPERTY_INDEX','PROPERTY_TABLE');
INSERT INTO C__INDEX(TABLE_NAME,INDEX_NAME,COLUMN_NAME)VALUES('C__HAS_A','C__HAS_A_PROPERTY_INDEX','PROPERTY_ID');
CREATE TABLE C__ARRAY(C__ID BIGINT PRIMARY KEY,COMPONENT_TABLE INTEGER,COMPONENT_TYPE INTEGER);
CREATE INDEX C__ARRAY_INDEX on C__ARRAY(C__ID);
INSERT INTO C__INDEX(TABLE_NAME,INDEX_NAME,COLUMN_NAME)VALUES('C__ARRAY','C__ARRAY_INDEX','C__ID');
CREATE TABLE C__ARRAY_MEMBER_C__ARRAY(C__ID BIGINT AUTO_INCREMENT PRIMARY KEY, C__POSITION INT, COMPONENT_TYPE INTEGER, C__VALUE BIGINT,C__ARRAY_MEMBER_ID BIGINT, FOREIGN KEY(C__ARRAY_MEMBER_ID) REFERENCES C__ARRAY(C__ID));
CREATE TABLE C__TYPE_TABLE(OWNER_TABLE LONGTEXT,COLUMN_NAME LONGTEXT,COLUMN_CLASS LONGTEXT,COLUMN_SIZE BIGINT);
CREATE TABLE C__TABLE_NAME(CLASS LONGTEXT,TABLENAME LONGTEXT);
CREATE TABLE C__TABLE_NAME_MAP (C__ID BIGINT AUTO_INCREMENT PRIMARY KEY, NAME LONGTEXT);
CREATE TABLE C__CLASS_NAME_MAP (C__ID BIGINT AUTO_INCREMENT PRIMARY KEY, NAME LONGTEXT);
CREATE TABLE C__COLUMN_NAME_MAP (C__ID BIGINT AUTO_INCREMENT PRIMARY KEY, NAME LONGTEXT);
SELECT * from C__IS_A;
SELECT VERSION FROM C__SCHEMA_VERSION;
SELECT NAME,C__ID FROM C__TABLE_NAME_MAP;
SELECT NAME,C__ID FROM C__CLASS_NAME_MAP;
SELECT NAME,C__ID FROM C__COLUMN_NAME_MAP;
SELECT DISTINCT(SUBCLASS) FROM C__IS_A;
SELECT DISTINCT(SUPERCLASS) FROM C__IS_A;
SELECT VERSION FROM C__SCHEMA_VERSION;
SELECT NAME,C__ID FROM C__TABLE_NAME_MAP;
SELECT NAME,C__ID FROM C__CLASS_NAME_MAP;
SELECT NAME,C__ID FROM C__COLUMN_NAME_MAP;
SELECT NAME,C__ID FROM C__TABLE_NAME_MAP;
INSERT INTO C__TABLE_NAME_MAP (NAME) VALUES (null);
SELECT NAME,C__ID FROM C__TABLE_NAME_MAP;
SELECT NAME,C__ID FROM C__CLASS_NAME_MAP;
INSERT INTO C__CLASS_NAME_MAP (NAME) VALUES (null);
SELECT NAME,C__ID FROM C__CLASS_NAME_MAP;
CREATE TABLE JAVA_LANG_OBJECT (C__ID BIGINT AUTO_INCREMENT PRIMARY KEY, C__REALCLASS INTEGER);
INSERT INTO C__TABLE_NAME (TABLENAME ,CLASS) VALUES ('JAVA_LANG_OBJECT','java.lang.Object');
INSERT INTO JAVA_LANG_OBJECT (C__REALCLASS)VALUES(1);
SELECT LAST_INSERT_ID();
SELECT NAME,C__ID FROM C__TABLE_NAME_MAP;
INSERT INTO C__TABLE_NAME_MAP (NAME) VALUES (null);
SELECT NAME,C__ID FROM C__TABLE_NAME_MAP;
INSERT INTO C__TYPE_TABLE (OWNER_TABLE ,COLUMN_NAME ,COLUMN_CLASS, COLUMN_SIZE) VALUES ('ORG_CONSERVE_OBJECTS_AUTHOR','BOOKS','java.util.HashSet',null);
INSERT INTO C__TYPE_TABLE (OWNER_TABLE ,COLUMN_NAME ,COLUMN_CLASS, COLUMN_SIZE) VALUES ('ORG_CONSERVE_OBJECTS_AUTHOR','FIRSTNAME','java.lang.String',256);
INSERT INTO C__TYPE_TABLE (OWNER_TABLE ,COLUMN_NAME ,COLUMN_CLASS, COLUMN_SIZE) VALUES ('ORG_CONSERVE_OBJECTS_AUTHOR','LASTNAME','java.lang.String',256);
INSERT INTO C__TYPE_TABLE (OWNER_TABLE ,COLUMN_NAME ,COLUMN_CLASS, COLUMN_SIZE) VALUES ('ORG_CONSERVE_OBJECTS_AUTHOR','BIRTHYEAR','java.lang.Integer',null);
CREATE TABLE ORG_CONSERVE_OBJECTS_AUTHOR (C__ID BIGINT PRIMARY KEY, C__REALCLASS INTEGER, BOOKS BIGINT, FIRSTNAME LONGTEXT, LASTNAME LONGTEXT, BIRTHYEAR INTEGER);
SELECT * FROM C__IS_A WHERE SUBCLASS = 'org.conserve.objects.Author' AND SUPERCLASS = 'java.lang.Object';
INSERT INTO C__IS_A (SUBCLASS,SUPERCLASS) values ('org.conserve.objects.Author','java.lang.Object');
CREATE TABLE JAVA_UTIL_HASHSET (C__ID BIGINT PRIMARY KEY, C__REALCLASS INTEGER);
SELECT * FROM C__IS_A WHERE SUBCLASS = 'java.util.HashSet' AND SUPERCLASS = 'java.util.AbstractSet';
INSERT INTO C__IS_A (SUBCLASS,SUPERCLASS) values ('java.util.HashSet','java.util.AbstractSet');
SELECT * FROM C__IS_A WHERE SUBCLASS = 'java.util.AbstractSet' AND SUPERCLASS = 'java.util.AbstractCollection';
INSERT INTO C__IS_A (SUBCLASS,SUPERCLASS) values ('java.util.AbstractSet','java.util.AbstractCollection');
SELECT * FROM C__IS_A WHERE SUBCLASS = 'java.util.AbstractCollection' AND SUPERCLASS = 'java.lang.Object';
INSERT INTO C__IS_A (SUBCLASS,SUPERCLASS) values ('java.util.AbstractCollection','java.lang.Object');
SELECT * FROM C__IS_A WHERE SUBCLASS = 'java.util.AbstractCollection' AND SUPERCLASS = 'java.util.Collection';
INSERT INTO C__IS_A (SUBCLASS,SUPERCLASS) values ('java.util.AbstractCollection','java.util.Collection');
SELECT * FROM C__IS_A WHERE SUBCLASS = 'java.util.Collection' AND SUPERCLASS = 'java.lang.Iterable';
INSERT INTO C__IS_A (SUBCLASS,SUPERCLASS) values ('java.util.Collection','java.lang.Iterable');
SELECT * FROM C__IS_A WHERE SUBCLASS = 'java.util.AbstractSet' AND SUPERCLASS = 'java.util.Set';
INSERT INTO C__IS_A (SUBCLASS,SUPERCLASS) values ('java.util.AbstractSet','java.util.Set');
SELECT * FROM C__IS_A WHERE SUBCLASS = 'java.util.Set' AND SUPERCLASS = 'java.util.Collection';
INSERT INTO C__IS_A (SUBCLASS,SUPERCLASS) values ('java.util.Set','java.util.Collection');
SELECT * FROM C__IS_A WHERE SUBCLASS = 'java.util.Collection' AND SUPERCLASS = 'java.lang.Iterable';
SELECT * FROM C__IS_A WHERE SUBCLASS = 'java.util.HashSet' AND SUPERCLASS = 'java.util.Set';
INSERT INTO C__IS_A (SUBCLASS,SUPERCLASS) values ('java.util.HashSet','java.util.Set');
SELECT * FROM C__IS_A WHERE SUBCLASS = 'java.util.Set' AND SUPERCLASS = 'java.util.Collection';
SELECT * FROM C__IS_A WHERE SUBCLASS = 'java.util.Collection' AND SUPERCLASS = 'java.lang.Iterable';
SELECT * FROM C__IS_A WHERE SUBCLASS = 'java.util.HashSet' AND SUPERCLASS = 'java.lang.Cloneable';
INSERT INTO C__IS_A (SUBCLASS,SUPERCLASS) values ('java.util.HashSet','java.lang.Cloneable');
SELECT * FROM C__IS_A WHERE SUBCLASS = 'java.util.HashSet' AND SUPERCLASS = 'java.io.Serializable';
INSERT INTO C__IS_A (SUBCLASS,SUPERCLASS) values ('java.util.HashSet','java.io.Serializable');
INSERT INTO C__TABLE_NAME (TABLENAME ,CLASS) VALUES ('JAVA_UTIL_HASHSET','java.util.HashSet');
CREATE TABLE JAVA_UTIL_ABSTRACTSET (C__ID BIGINT PRIMARY KEY, C__REALCLASS INTEGER);
SELECT * FROM C__IS_A WHERE SUBCLASS = 'java.util.AbstractSet' AND SUPERCLASS = 'java.util.AbstractCollection';
SELECT * FROM C__IS_A WHERE SUBCLASS = 'java.util.AbstractCollection' AND SUPERCLASS = 'java.lang.Object';
SELECT * FROM C__IS_A WHERE SUBCLASS = 'java.util.AbstractCollection' AND SUPERCLASS = 'java.util.Collection';
SELECT * FROM C__IS_A WHERE SUBCLASS = 'java.util.Collection' AND SUPERCLASS = 'java.lang.Iterable';
SELECT * FROM C__IS_A WHERE SUBCLASS = 'java.util.AbstractSet' AND SUPERCLASS = 'java.util.Set';
SELECT * FROM C__IS_A WHERE SUBCLASS = 'java.util.Set' AND SUPERCLASS = 'java.util.Collection';
SELECT * FROM C__IS_A WHERE SUBCLASS = 'java.util.Collection' AND SUPERCLASS = 'java.lang.Iterable';
INSERT INTO C__TABLE_NAME (TABLENAME ,CLASS) VALUES ('JAVA_UTIL_ABSTRACTSET','java.util.AbstractSet');
CREATE TABLE JAVA_UTIL_ABSTRACTCOLLECTION (C__ID BIGINT PRIMARY KEY, C__REALCLASS INTEGER);
SELECT * FROM C__IS_A WHERE SUBCLASS = 'java.util.AbstractCollection' AND SUPERCLASS = 'java.lang.Object';
SELECT * FROM C__IS_A WHERE SUBCLASS = 'java.util.AbstractCollection' AND SUPERCLASS = 'java.util.Collection';
SELECT * FROM C__IS_A WHERE SUBCLASS = 'java.util.Collection' AND SUPERCLASS = 'java.lang.Iterable';
INSERT INTO C__TABLE_NAME (TABLENAME ,CLASS) VALUES ('JAVA_UTIL_ABSTRACTCOLLECTION','java.util.AbstractCollection');
INSERT INTO C__TYPE_TABLE (OWNER_TABLE ,COLUMN_NAME ,COLUMN_CLASS, COLUMN_SIZE) VALUES ('JAVA_UTIL_COLLECTION','EMPTY_','boolean',null);
INSERT INTO C__TYPE_TABLE (OWNER_TABLE ,COLUMN_NAME ,COLUMN_CLASS, COLUMN_SIZE) VALUES ('JAVA_UTIL_COLLECTION','C__COLLECTION_CONTENTS','java.lang.Object[]',null);
CREATE TABLE JAVA_UTIL_COLLECTION (C__ID BIGINT PRIMARY KEY, C__REALCLASS INTEGER, EMPTY_ BOOLEAN, C__COLLECTION_CONTENTS BIGINT);
SELECT * FROM C__IS_A WHERE SUBCLASS = 'java.util.Collection' AND SUPERCLASS = 'java.lang.Iterable';
CREATE TABLE C__ARRAY_MEMBER_JAVA_LANG_OBJECT (C__ID BIGINT AUTO_INCREMENT PRIMARY KEY, C__ARRAY_MEMBER_ID BIGINT, C__POSITION INTEGER, COMPONENT_TYPE INTEGER, C__VALUE BIGINT);
INSERT INTO C__TABLE_NAME (TABLENAME ,CLASS) VALUES ('C__ARRAY_MEMBER_JAVA_LANG_OBJECT','java.lang.Object[]');
CREATE TABLE JAVA_LANG_CLONEABLE (C__ID BIGINT PRIMARY KEY, C__REALCLASS INTEGER);
INSERT INTO C__TABLE_NAME (TABLENAME ,CLASS) VALUES ('JAVA_LANG_CLONEABLE','java.lang.Cloneable');
CREATE TABLE JAVA_IO_SERIALIZABLE (C__ID BIGINT PRIMARY KEY, C__REALCLASS INTEGER);
INSERT INTO C__TABLE_NAME (TABLENAME ,CLASS) VALUES ('JAVA_IO_SERIALIZABLE','java.io.Serializable');
INSERT INTO C__TABLE_NAME (TABLENAME ,CLASS) VALUES ('JAVA_UTIL_COLLECTION','java.util.Collection');
CREATE TABLE JAVA_LANG_ITERABLE (C__ID BIGINT PRIMARY KEY, C__REALCLASS INTEGER);
INSERT INTO C__TABLE_NAME (TABLENAME ,CLASS) VALUES ('JAVA_LANG_ITERABLE','java.lang.Iterable');
CREATE TABLE JAVA_UTIL_SET (C__ID BIGINT PRIMARY KEY, C__REALCLASS INTEGER);
SELECT * FROM C__IS_A WHERE SUBCLASS = 'java.util.Set' AND SUPERCLASS = 'java.util.Collection';
SELECT * FROM C__IS_A WHERE SUBCLASS = 'java.util.Collection' AND SUPERCLASS = 'java.lang.Iterable';
INSERT INTO C__TABLE_NAME (TABLENAME ,CLASS) VALUES ('JAVA_UTIL_SET','java.util.Set');
INSERT INTO C__TABLE_NAME (TABLENAME ,CLASS) VALUES ('ORG_CONSERVE_OBJECTS_AUTHOR','org.conserve.objects.Author');
SELECT NAME,C__ID FROM C__TABLE_NAME_MAP;
INSERT INTO C__TABLE_NAME_MAP (NAME) VALUES (null);
SELECT NAME,C__ID FROM C__TABLE_NAME_MAP;
SELECT NAME,C__ID FROM C__CLASS_NAME_MAP;
INSERT INTO C__CLASS_NAME_MAP (NAME) VALUES (null);
SELECT NAME,C__ID FROM C__CLASS_NAME_MAP;
SELECT NAME,C__ID FROM C__CLASS_NAME_MAP;
INSERT INTO C__CLASS_NAME_MAP (NAME) VALUES (null);
SELECT NAME,C__ID FROM C__CLASS_NAME_MAP;
INSERT INTO JAVA_LANG_OBJECT (C__REALCLASS)VALUES(3);
SELECT LAST_INSERT_ID();
INSERT INTO JAVA_UTIL_HASHSET (C__ID)VALUES(2);
INSERT INTO JAVA_LANG_CLONEABLE (C__REALCLASS, C__ID)VALUES(2, 2);
SELECT NAME,C__ID FROM C__TABLE_NAME_MAP;
INSERT INTO C__TABLE_NAME_MAP (NAME) VALUES (null);
SELECT NAME,C__ID FROM C__TABLE_NAME_MAP;
INSERT INTO JAVA_IO_SERIALIZABLE (C__REALCLASS, C__ID)VALUES(2, 2);
SELECT NAME,C__ID FROM C__TABLE_NAME_MAP;
INSERT INTO C__TABLE_NAME_MAP (NAME) VALUES (null);
SELECT NAME,C__ID FROM C__TABLE_NAME_MAP;
INSERT INTO JAVA_UTIL_ABSTRACTSET (C__REALCLASS, C__ID)VALUES(2, 2);
SELECT NAME,C__ID FROM C__TABLE_NAME_MAP;
INSERT INTO C__TABLE_NAME_MAP (NAME) VALUES (null);
SELECT NAME,C__ID FROM C__TABLE_NAME_MAP;
SELECT NAME,C__ID FROM C__CLASS_NAME_MAP;
INSERT INTO C__CLASS_NAME_MAP (NAME) VALUES (null);
SELECT NAME,C__ID FROM C__CLASS_NAME_MAP;
INSERT INTO JAVA_UTIL_SET (C__REALCLASS, C__ID)VALUES(4, 2);
SELECT NAME,C__ID FROM C__TABLE_NAME_MAP;
INSERT INTO C__TABLE_NAME_MAP (NAME) VALUES (null);
SELECT NAME,C__ID FROM C__TABLE_NAME_MAP;
SELECT NAME,C__ID FROM C__CLASS_NAME_MAP;
INSERT INTO C__CLASS_NAME_MAP (NAME) VALUES (null);
SELECT NAME,C__ID FROM C__CLASS_NAME_MAP;
SELECT NAME,C__ID FROM C__TABLE_NAME_MAP;
INSERT INTO C__TABLE_NAME_MAP (NAME) VALUES (null);
SELECT NAME,C__ID FROM C__TABLE_NAME_MAP;
SELECT NAME,C__ID FROM C__CLASS_NAME_MAP;
INSERT INTO C__CLASS_NAME_MAP (NAME) VALUES (null);
SELECT NAME,C__ID FROM C__CLASS_NAME_MAP;
SELECT NAME,C__ID FROM C__CLASS_NAME_MAP;
INSERT INTO C__CLASS_NAME_MAP (NAME) VALUES (null);
SELECT NAME,C__ID FROM C__CLASS_NAME_MAP;
INSERT INTO JAVA_LANG_OBJECT (C__REALCLASS)VALUES(7);
SELECT LAST_INSERT_ID();
INSERT INTO C__ARRAY (COMPONENT_TABLE,COMPONENT_TYPE,C__ID)VALUES(2,6,3);
SELECT NAME,C__ID FROM C__CLASS_NAME_MAP;
INSERT INTO C__CLASS_NAME_MAP (NAME) VALUES (null);
SELECT NAME,C__ID FROM C__CLASS_NAME_MAP;
SELECT NAME,C__ID FROM C__TABLE_NAME_MAP;
INSERT INTO C__TABLE_NAME_MAP (NAME) VALUES (null);
SELECT NAME,C__ID FROM C__TABLE_NAME_MAP;
INSERT INTO JAVA_LANG_OBJECT (C__REALCLASS)VALUES(8);
SELECT LAST_INSERT_ID();
INSERT INTO C__TYPE_TABLE (OWNER_TABLE ,COLUMN_NAME ,COLUMN_CLASS, COLUMN_SIZE) VALUES ('ORG_CONSERVE_OBJECTS_BOOK','TITLE','java.lang.String',1024);
INSERT INTO C__TYPE_TABLE (OWNER_TABLE ,COLUMN_NAME ,COLUMN_CLASS, COLUMN_SIZE) VALUES ('ORG_CONSERVE_OBJECTS_BOOK','AUTHORS','java.util.Set',null);
INSERT INTO C__TYPE_TABLE (OWNER_TABLE ,COLUMN_NAME ,COLUMN_CLASS, COLUMN_SIZE) VALUES ('ORG_CONSERVE_OBJECTS_BOOK','PUBLISHEDYEAR','java.lang.Integer',null);
INSERT INTO C__TYPE_TABLE (OWNER_TABLE ,COLUMN_NAME ,COLUMN_CLASS, COLUMN_SIZE) VALUES ('ORG_CONSERVE_OBJECTS_BOOK','KEYWORDS','java.util.HashSet',null);
CREATE TABLE ORG_CONSERVE_OBJECTS_BOOK (C__ID BIGINT PRIMARY KEY, C__REALCLASS INTEGER, TITLE LONGTEXT, AUTHORS BIGINT, PUBLISHEDYEAR INTEGER, KEYWORDS BIGINT);
SELECT * FROM C__IS_A WHERE SUBCLASS = 'org.conserve.objects.Book' AND SUPERCLASS = 'java.lang.Object';
INSERT INTO C__IS_A (SUBCLASS,SUPERCLASS) values ('org.conserve.objects.Book','java.lang.Object');
INSERT INTO C__TABLE_NAME (TABLENAME ,CLASS) VALUES ('ORG_CONSERVE_OBJECTS_BOOK','org.conserve.objects.Book');
INSERT INTO JAVA_LANG_OBJECT (C__REALCLASS)VALUES(3);
SELECT LAST_INSERT_ID();
INSERT INTO JAVA_UTIL_HASHSET (C__ID)VALUES(5);
INSERT INTO JAVA_LANG_CLONEABLE (C__REALCLASS, C__ID)VALUES(2, 5);
INSERT INTO JAVA_IO_SERIALIZABLE (C__REALCLASS, C__ID)VALUES(2, 5);
INSERT INTO JAVA_UTIL_ABSTRACTSET (C__REALCLASS, C__ID)VALUES(2, 5);
INSERT INTO JAVA_UTIL_SET (C__REALCLASS, C__ID)VALUES(4, 5);
INSERT INTO JAVA_LANG_OBJECT (C__REALCLASS)VALUES(7);
SELECT LAST_INSERT_ID();
INSERT INTO C__ARRAY (COMPONENT_TABLE,COMPONENT_TYPE,C__ID)VALUES(2,6,6);
INSERT INTO C__ARRAY_MEMBER_JAVA_LANG_OBJECT(C__ARRAY_MEMBER_ID,C__POSITION,C__VALUE,COMPONENT_TYPE)values(6,0,null,1);
SELECT LAST_INSERT_ID();
SELECT NAME,C__ID FROM C__TABLE_NAME_MAP;
INSERT INTO C__TABLE_NAME_MAP (NAME) VALUES (null);
SELECT NAME,C__ID FROM C__TABLE_NAME_MAP;
INSERT INTO C__HAS_A (OWNER_TABLE,OWNER_ID,PROPERTY_TABLE,PROPERTY_ID,PROPERTY_CLASS,RELATION_NAME) values (8,6,10,1,1,null);
INSERT INTO JAVA_LANG_CLONEABLE (C__REALCLASS, C__ID)VALUES(7, 6);
INSERT INTO JAVA_IO_SERIALIZABLE (C__REALCLASS, C__ID)VALUES(7, 6);
INSERT INTO JAVA_UTIL_COLLECTION (EMPTY_, C__COLLECTION_CONTENTS, C__REALCLASS, C__ID)VALUES(0, 6, 5, 5);
SELECT NAME,C__ID FROM C__TABLE_NAME_MAP;
INSERT INTO C__TABLE_NAME_MAP (NAME) VALUES (null);
SELECT NAME,C__ID FROM C__TABLE_NAME_MAP;
SELECT NAME,C__ID FROM C__COLUMN_NAME_MAP;
INSERT INTO C__COLUMN_NAME_MAP (NAME) VALUES (null);
SELECT NAME,C__ID FROM C__COLUMN_NAME_MAP;
INSERT INTO C__HAS_A (OWNER_TABLE,OWNER_ID,PROPERTY_TABLE,PROPERTY_ID,PROPERTY_CLASS,RELATION_NAME) values (11,5,8,6,null,1);
SELECT NAME,C__ID FROM C__CLASS_NAME_MAP;
INSERT INTO C__CLASS_NAME_MAP (NAME) VALUES (null);
SELECT NAME,C__ID FROM C__CLASS_NAME_MAP;
INSERT INTO JAVA_LANG_ITERABLE (C__REALCLASS, C__ID)VALUES(9, 5);
SELECT NAME,C__ID FROM C__TABLE_NAME_MAP;
INSERT INTO C__TABLE_NAME_MAP (NAME) VALUES (null);
SELECT NAME,C__ID FROM C__TABLE_NAME_MAP;
INSERT INTO JAVA_UTIL_ABSTRACTCOLLECTION (C__REALCLASS, C__ID)VALUES(4, 5);
SELECT NAME,C__ID FROM C__TABLE_NAME_MAP;
INSERT INTO C__TABLE_NAME_MAP (NAME) VALUES (null);
SELECT NAME,C__ID FROM C__TABLE_NAME_MAP;
INSERT INTO JAVA_LANG_OBJECT (C__REALCLASS)VALUES(3);
SELECT LAST_INSERT_ID();
INSERT INTO JAVA_UTIL_HASHSET (C__ID)VALUES(7);
INSERT INTO JAVA_LANG_CLONEABLE (C__REALCLASS, C__ID)VALUES(2, 7);
INSERT INTO JAVA_IO_SERIALIZABLE (C__REALCLASS, C__ID)VALUES(2, 7);
INSERT INTO JAVA_UTIL_ABSTRACTSET (C__REALCLASS, C__ID)VALUES(2, 7);
INSERT INTO JAVA_UTIL_SET (C__REALCLASS, C__ID)VALUES(4, 7);
INSERT INTO JAVA_LANG_OBJECT (C__REALCLASS)VALUES(7);
SELECT LAST_INSERT_ID();
INSERT INTO C__ARRAY (COMPONENT_TABLE,COMPONENT_TYPE,C__ID)VALUES(2,6,8);
SELECT NAME,C__ID FROM C__CLASS_NAME_MAP;
INSERT INTO C__CLASS_NAME_MAP (NAME) VALUES (null);
SELECT NAME,C__ID FROM C__CLASS_NAME_MAP;
SELECT NAME,C__ID FROM C__TABLE_NAME_MAP;
INSERT INTO C__TABLE_NAME_MAP (NAME) VALUES (null);
SELECT NAME,C__ID FROM C__TABLE_NAME_MAP;
INSERT INTO JAVA_LANG_OBJECT (C__REALCLASS)VALUES(10);
SELECT LAST_INSERT_ID();
INSERT INTO C__TYPE_TABLE (OWNER_TABLE ,COLUMN_NAME ,COLUMN_CLASS, COLUMN_SIZE) VALUES ('JAVA_LANG_STRING','C__VALUE','java.lang.String',null);
CREATE TABLE JAVA_LANG_STRING (C__ID BIGINT PRIMARY KEY, C__REALCLASS INTEGER, C__VALUE LONGTEXT);
INSERT INTO JAVA_LANG_STRING (C__VALUE, C__ID)VALUES('London', 9);
INSERT INTO JAVA_IO_SERIALIZABLE (C__REALCLASS, C__ID)VALUES(10, 9);
CREATE TABLE JAVA_LANG_COMPARABLE (C__ID BIGINT PRIMARY KEY, C__REALCLASS INTEGER);
INSERT INTO C__TABLE_NAME (TABLENAME ,CLASS) VALUES ('JAVA_LANG_COMPARABLE','java.lang.Comparable');
INSERT INTO JAVA_LANG_COMPARABLE (C__REALCLASS, C__ID)VALUES(10, 9);
SELECT NAME,C__ID FROM C__TABLE_NAME_MAP;
INSERT INTO C__TABLE_NAME_MAP (NAME) VALUES (null);
SELECT NAME,C__ID FROM C__TABLE_NAME_MAP;
CREATE TABLE JAVA_LANG_CHARSEQUENCE (C__ID BIGINT PRIMARY KEY, C__REALCLASS INTEGER);
INSERT INTO C__TABLE_NAME (TABLENAME ,CLASS) VALUES ('JAVA_LANG_CHARSEQUENCE','java.lang.CharSequence');
INSERT INTO JAVA_LANG_CHARSEQUENCE (C__REALCLASS, C__ID)VALUES(10, 9);
SELECT NAME,C__ID FROM C__TABLE_NAME_MAP;
INSERT INTO C__TABLE_NAME_MAP (NAME) VALUES (null);
SELECT NAME,C__ID FROM C__TABLE_NAME_MAP;
INSERT INTO C__ARRAY_MEMBER_JAVA_LANG_OBJECT(C__ARRAY_MEMBER_ID,C__POSITION,C__VALUE,COMPONENT_TYPE)values(8,0,9,10);
SELECT LAST_INSERT_ID();
INSERT INTO C__HAS_A (OWNER_TABLE,OWNER_ID,PROPERTY_TABLE,PROPERTY_ID,PROPERTY_CLASS,RELATION_NAME) values (10,2,2,9,10,null);
INSERT INTO C__HAS_A (OWNER_TABLE,OWNER_ID,PROPERTY_TABLE,PROPERTY_ID,PROPERTY_CLASS,RELATION_NAME) values (8,8,10,2,10,null);
INSERT INTO JAVA_LANG_OBJECT (C__REALCLASS)VALUES(10);
SELECT LAST_INSERT_ID();
INSERT INTO JAVA_LANG_STRING (C__VALUE, C__ID)VALUES('revolution', 10);
INSERT INTO JAVA_IO_SERIALIZABLE (C__REALCLASS, C__ID)VALUES(10, 10);
INSERT INTO JAVA_LANG_COMPARABLE (C__REALCLASS, C__ID)VALUES(10, 10);
INSERT INTO JAVA_LANG_CHARSEQUENCE (C__REALCLASS, C__ID)VALUES(10, 10);
INSERT INTO C__ARRAY_MEMBER_JAVA_LANG_OBJECT(C__ARRAY_MEMBER_ID,C__POSITION,C__VALUE,COMPONENT_TYPE)values(8,1,10,10);
SELECT LAST_INSERT_ID();
INSERT INTO C__HAS_A (OWNER_TABLE,OWNER_ID,PROPERTY_TABLE,PROPERTY_ID,PROPERTY_CLASS,RELATION_NAME) values (10,3,2,10,10,null);
INSERT INTO C__HAS_A (OWNER_TABLE,OWNER_ID,PROPERTY_TABLE,PROPERTY_ID,PROPERTY_CLASS,RELATION_NAME) values (8,8,10,3,10,null);
INSERT INTO JAVA_LANG_OBJECT (C__REALCLASS)VALUES(10);
SELECT LAST_INSERT_ID();
INSERT INTO JAVA_LANG_STRING (C__VALUE, C__ID)VALUES('Paris', 11);
INSERT INTO JAVA_IO_SERIALIZABLE (C__REALCLASS, C__ID)VALUES(10, 11);
INSERT INTO JAVA_LANG_COMPARABLE (C__REALCLASS, C__ID)VALUES(10, 11);
INSERT INTO JAVA_LANG_CHARSEQUENCE (C__REALCLASS, C__ID)VALUES(10, 11);
INSERT INTO C__ARRAY_MEMBER_JAVA_LANG_OBJECT(C__ARRAY_MEMBER_ID,C__POSITION,C__VALUE,COMPONENT_TYPE)values(8,2,11,10);
SELECT LAST_INSERT_ID();
INSERT INTO C__HAS_A (OWNER_TABLE,OWNER_ID,PROPERTY_TABLE,PROPERTY_ID,PROPERTY_CLASS,RELATION_NAME) values (10,4,2,11,10,null);
INSERT INTO C__HAS_A (OWNER_TABLE,OWNER_ID,PROPERTY_TABLE,PROPERTY_ID,PROPERTY_CLASS,RELATION_NAME) values (8,8,10,4,10,null);
INSERT INTO JAVA_LANG_CLONEABLE (C__REALCLASS, C__ID)VALUES(7, 8);
INSERT INTO JAVA_IO_SERIALIZABLE (C__REALCLASS, C__ID)VALUES(7, 8);
INSERT INTO JAVA_UTIL_COLLECTION (EMPTY_, C__COLLECTION_CONTENTS, C__REALCLASS, C__ID)VALUES(0, 8, 5, 7);
INSERT INTO C__HAS_A (OWNER_TABLE,OWNER_ID,PROPERTY_TABLE,PROPERTY_ID,PROPERTY_CLASS,RELATION_NAME) values (11,7,8,8,null,1);
INSERT INTO JAVA_LANG_ITERABLE (C__REALCLASS, C__ID)VALUES(9, 7);
INSERT INTO JAVA_UTIL_ABSTRACTCOLLECTION (C__REALCLASS, C__ID)VALUES(4, 7);
INSERT INTO ORG_CONSERVE_OBJECTS_BOOK (TITLE, AUTHORS, PUBLISHEDYEAR, KEYWORDS, C__ID)VALUES('A Tale of Two Cities', 5, 1859, 7, 4);
SELECT NAME,C__ID FROM C__COLUMN_NAME_MAP;
INSERT INTO C__COLUMN_NAME_MAP (NAME) VALUES (null);
SELECT NAME,C__ID FROM C__COLUMN_NAME_MAP;
INSERT INTO C__HAS_A (OWNER_TABLE,OWNER_ID,PROPERTY_TABLE,PROPERTY_ID,PROPERTY_CLASS,RELATION_NAME) values (9,4,3,5,2,2);
SELECT NAME,C__ID FROM C__COLUMN_NAME_MAP;
INSERT INTO C__COLUMN_NAME_MAP (NAME) VALUES (null);
SELECT NAME,C__ID FROM C__COLUMN_NAME_MAP;
INSERT INTO C__HAS_A (OWNER_TABLE,OWNER_ID,PROPERTY_TABLE,PROPERTY_ID,PROPERTY_CLASS,RELATION_NAME) values (9,4,3,7,2,3);
INSERT INTO C__ARRAY_MEMBER_JAVA_LANG_OBJECT(C__ARRAY_MEMBER_ID,C__POSITION,C__VALUE,COMPONENT_TYPE)values(3,0,4,8);
SELECT LAST_INSERT_ID();
INSERT INTO C__HAS_A (OWNER_TABLE,OWNER_ID,PROPERTY_TABLE,PROPERTY_ID,PROPERTY_CLASS,RELATION_NAME) values (10,5,2,4,8,null);
INSERT INTO C__HAS_A (OWNER_TABLE,OWNER_ID,PROPERTY_TABLE,PROPERTY_ID,PROPERTY_CLASS,RELATION_NAME) values (8,3,10,5,8,null);
INSERT INTO JAVA_LANG_OBJECT (C__REALCLASS)VALUES(8);
SELECT LAST_INSERT_ID();
INSERT INTO JAVA_LANG_OBJECT (C__REALCLASS)VALUES(3);
SELECT LAST_INSERT_ID();
INSERT INTO JAVA_UTIL_HASHSET (C__ID)VALUES(13);
INSERT INTO JAVA_LANG_CLONEABLE (C__REALCLASS, C__ID)VALUES(2, 13);
INSERT INTO JAVA_IO_SERIALIZABLE (C__REALCLASS, C__ID)VALUES(2, 13);
INSERT INTO JAVA_UTIL_ABSTRACTSET (C__REALCLASS, C__ID)VALUES(2, 13);
INSERT INTO JAVA_UTIL_SET (C__REALCLASS, C__ID)VALUES(4, 13);
INSERT INTO JAVA_LANG_OBJECT (C__REALCLASS)VALUES(7);
SELECT LAST_INSERT_ID();
INSERT INTO C__ARRAY (COMPONENT_TABLE,COMPONENT_TYPE,C__ID)VALUES(2,6,14);
INSERT INTO C__ARRAY_MEMBER_JAVA_LANG_OBJECT(C__ARRAY_MEMBER_ID,C__POSITION,C__VALUE,COMPONENT_TYPE)values(14,0,null,1);
SELECT LAST_INSERT_ID();
INSERT INTO C__HAS_A (OWNER_TABLE,OWNER_ID,PROPERTY_TABLE,PROPERTY_ID,PROPERTY_CLASS,RELATION_NAME) values (8,14,10,6,1,null);
INSERT INTO JAVA_LANG_CLONEABLE (C__REALCLASS, C__ID)VALUES(7, 14);
INSERT INTO JAVA_IO_SERIALIZABLE (C__REALCLASS, C__ID)VALUES(7, 14);
INSERT INTO JAVA_UTIL_COLLECTION (EMPTY_, C__COLLECTION_CONTENTS, C__REALCLASS, C__ID)VALUES(0, 14, 5, 13);
INSERT INTO C__HAS_A (OWNER_TABLE,OWNER_ID,PROPERTY_TABLE,PROPERTY_ID,PROPERTY_CLASS,RELATION_NAME) values (11,13,8,14,null,1);
INSERT INTO JAVA_LANG_ITERABLE (C__REALCLASS, C__ID)VALUES(9, 13);
INSERT INTO JAVA_UTIL_ABSTRACTCOLLECTION (C__REALCLASS, C__ID)VALUES(4, 13);
INSERT INTO JAVA_LANG_OBJECT (C__REALCLASS)VALUES(3);
SELECT LAST_INSERT_ID();
INSERT INTO JAVA_UTIL_HASHSET (C__ID)VALUES(15);
INSERT INTO JAVA_LANG_CLONEABLE (C__REALCLASS, C__ID)VALUES(2, 15);
INSERT INTO JAVA_IO_SERIALIZABLE (C__REALCLASS, C__ID)VALUES(2, 15);
INSERT INTO JAVA_UTIL_ABSTRACTSET (C__REALCLASS, C__ID)VALUES(2, 15);
INSERT INTO JAVA_UTIL_SET (C__REALCLASS, C__ID)VALUES(4, 15);
INSERT INTO JAVA_LANG_OBJECT (C__REALCLASS)VALUES(7);
SELECT LAST_INSERT_ID();
INSERT INTO C__ARRAY (COMPONENT_TABLE,COMPONENT_TYPE,C__ID)VALUES(2,6,16);
INSERT INTO C__ARRAY_MEMBER_JAVA_LANG_OBJECT(C__ARRAY_MEMBER_ID,C__POSITION,C__VALUE,COMPONENT_TYPE)values(16,0,9,10);
SELECT LAST_INSERT_ID();
INSERT INTO C__HAS_A (OWNER_TABLE,OWNER_ID,PROPERTY_TABLE,PROPERTY_ID,PROPERTY_CLASS,RELATION_NAME) values (10,7,2,9,10,null);
INSERT INTO C__HAS_A (OWNER_TABLE,OWNER_ID,PROPERTY_TABLE,PROPERTY_ID,PROPERTY_CLASS,RELATION_NAME) values (8,16,10,7,10,null);
INSERT INTO JAVA_LANG_OBJECT (C__REALCLASS)VALUES(10);
SELECT LAST_INSERT_ID();
INSERT INTO JAVA_LANG_STRING (C__VALUE, C__ID)VALUES('crime', 17);
INSERT INTO JAVA_IO_SERIALIZABLE (C__REALCLASS, C__ID)VALUES(10, 17);
INSERT INTO JAVA_LANG_COMPARABLE (C__REALCLASS, C__ID)VALUES(10, 17);
INSERT INTO JAVA_LANG_CHARSEQUENCE (C__REALCLASS, C__ID)VALUES(10, 17);
INSERT INTO C__ARRAY_MEMBER_JAVA_LANG_OBJECT(C__ARRAY_MEMBER_ID,C__POSITION,C__VALUE,COMPONENT_TYPE)values(16,1,17,10);
SELECT LAST_INSERT_ID();
INSERT INTO C__HAS_A (OWNER_TABLE,OWNER_ID,PROPERTY_TABLE,PROPERTY_ID,PROPERTY_CLASS,RELATION_NAME) values (10,8,2,17,10,null);
INSERT INTO C__HAS_A (OWNER_TABLE,OWNER_ID,PROPERTY_TABLE,PROPERTY_ID,PROPERTY_CLASS,RELATION_NAME) values (8,16,10,8,10,null);
INSERT INTO JAVA_LANG_CLONEABLE (C__REALCLASS, C__ID)VALUES(7, 16);
INSERT INTO JAVA_IO_SERIALIZABLE (C__REALCLASS, C__ID)VALUES(7, 16);
INSERT INTO JAVA_UTIL_COLLECTION (EMPTY_, C__COLLECTION_CONTENTS, C__REALCLASS, C__ID)VALUES(0, 16, 5, 15);
INSERT INTO C__HAS_A (OWNER_TABLE,OWNER_ID,PROPERTY_TABLE,PROPERTY_ID,PROPERTY_CLASS,RELATION_NAME) values (11,15,8,16,null,1);
INSERT INTO JAVA_LANG_ITERABLE (C__REALCLASS, C__ID)VALUES(9, 15);
INSERT INTO JAVA_UTIL_ABSTRACTCOLLECTION (C__REALCLASS, C__ID)VALUES(4, 15);
INSERT INTO ORG_CONSERVE_OBJECTS_BOOK (TITLE, AUTHORS, PUBLISHEDYEAR, KEYWORDS, C__ID)VALUES('Oliver Twist', 13, 1838, 15, 12);
INSERT INTO C__HAS_A (OWNER_TABLE,OWNER_ID,PROPERTY_TABLE,PROPERTY_ID,PROPERTY_CLASS,RELATION_NAME) values (9,12,3,13,2,2);
INSERT INTO C__HAS_A (OWNER_TABLE,OWNER_ID,PROPERTY_TABLE,PROPERTY_ID,PROPERTY_CLASS,RELATION_NAME) values (9,12,3,15,2,3);
INSERT INTO C__ARRAY_MEMBER_JAVA_LANG_OBJECT(C__ARRAY_MEMBER_ID,C__POSITION,C__VALUE,COMPONENT_TYPE)values(3,1,12,8);
SELECT LAST_INSERT_ID();
INSERT INTO C__HAS_A (OWNER_TABLE,OWNER_ID,PROPERTY_TABLE,PROPERTY_ID,PROPERTY_CLASS,RELATION_NAME) values (10,9,2,12,8,null);
INSERT INTO C__HAS_A (OWNER_TABLE,OWNER_ID,PROPERTY_TABLE,PROPERTY_ID,PROPERTY_CLASS,RELATION_NAME) values (8,3,10,9,8,null);
INSERT INTO JAVA_LANG_CLONEABLE (C__REALCLASS, C__ID)VALUES(7, 3);
INSERT INTO JAVA_IO_SERIALIZABLE (C__REALCLASS, C__ID)VALUES(7, 3);
INSERT INTO JAVA_UTIL_COLLECTION (EMPTY_, C__COLLECTION_CONTENTS, C__REALCLASS, C__ID)VALUES(0, 3, 5, 2);
INSERT INTO C__HAS_A (OWNER_TABLE,OWNER_ID,PROPERTY_TABLE,PROPERTY_ID,PROPERTY_CLASS,RELATION_NAME) values (11,2,8,3,null,1);
INSERT INTO JAVA_LANG_ITERABLE (C__REALCLASS, C__ID)VALUES(9, 2);
INSERT INTO JAVA_UTIL_ABSTRACTCOLLECTION (C__REALCLASS, C__ID)VALUES(4, 2);
INSERT INTO ORG_CONSERVE_OBJECTS_AUTHOR (BOOKS, FIRSTNAME, LASTNAME, BIRTHYEAR, C__ID)VALUES(2, 'Charles', 'Dickens', 1812, 1);
SELECT NAME,C__ID FROM C__COLUMN_NAME_MAP;
INSERT INTO C__COLUMN_NAME_MAP (NAME) VALUES (null);
SELECT NAME,C__ID FROM C__COLUMN_NAME_MAP;
INSERT INTO C__HAS_A (OWNER_TABLE,OWNER_ID,PROPERTY_TABLE,PROPERTY_ID,PROPERTY_CLASS,RELATION_NAME) values (1,1,3,2,2,4);
INSERT INTO C__HAS_A (PROPERTY_TABLE,PROPERTY_ID,PROPERTY_CLASS) values (1,1,1);
UPDATE C__ARRAY_MEMBER_JAVA_LANG_OBJECT SET C__VALUE = 1 WHERE C__ID = 1;
SELECT NAME,C__ID FROM C__COLUMN_NAME_MAP;
INSERT INTO C__COLUMN_NAME_MAP (NAME) VALUES (null);
SELECT NAME,C__ID FROM C__COLUMN_NAME_MAP;
INSERT INTO C__HAS_A (OWNER_TABLE,OWNER_ID,PROPERTY_TABLE,PROPERTY_ID,PROPERTY_CLASS,RELATION_NAME) values (10,1,2,1,1,5);
UPDATE C__ARRAY_MEMBER_JAVA_LANG_OBJECT SET C__VALUE = 1 WHERE C__ID = 6;
INSERT INTO C__HAS_A (OWNER_TABLE,OWNER_ID,PROPERTY_TABLE,PROPERTY_ID,PROPERTY_CLASS,RELATION_NAME) values (10,6,2,1,1,5);
INSERT INTO JAVA_LANG_OBJECT (C__REALCLASS)VALUES(1);
SELECT LAST_INSERT_ID();
INSERT INTO JAVA_LANG_OBJECT (C__REALCLASS)VALUES(3);
SELECT LAST_INSERT_ID();
INSERT INTO JAVA_UTIL_HASHSET (C__ID)VALUES(19);
INSERT INTO JAVA_LANG_CLONEABLE (C__REALCLASS, C__ID)VALUES(2, 19);
INSERT INTO JAVA_IO_SERIALIZABLE (C__REALCLASS, C__ID)VALUES(2, 19);
INSERT INTO JAVA_UTIL_ABSTRACTSET (C__REALCLASS, C__ID)VALUES(2, 19);
INSERT INTO JAVA_UTIL_SET (C__REALCLASS, C__ID)VALUES(4, 19);
INSERT INTO JAVA_LANG_OBJECT (C__REALCLASS)VALUES(7);
SELECT LAST_INSERT_ID();
INSERT INTO C__ARRAY (COMPONENT_TABLE,COMPONENT_TYPE,C__ID)VALUES(2,6,20);
INSERT INTO JAVA_LANG_OBJECT (C__REALCLASS)VALUES(8);
SELECT LAST_INSERT_ID();
INSERT INTO JAVA_LANG_OBJECT (C__REALCLASS)VALUES(3);
SELECT LAST_INSERT_ID();
INSERT INTO JAVA_UTIL_HASHSET (C__ID)VALUES(22);
INSERT INTO JAVA_LANG_CLONEABLE (C__REALCLASS, C__ID)VALUES(2, 22);
INSERT INTO JAVA_IO_SERIALIZABLE (C__REALCLASS, C__ID)VALUES(2, 22);
INSERT INTO JAVA_UTIL_ABSTRACTSET (C__REALCLASS, C__ID)VALUES(2, 22);
INSERT INTO JAVA_UTIL_SET (C__REALCLASS, C__ID)VALUES(4, 22);
INSERT INTO JAVA_LANG_OBJECT (C__REALCLASS)VALUES(7);
SELECT LAST_INSERT_ID();
INSERT INTO C__ARRAY (COMPONENT_TABLE,COMPONENT_TYPE,C__ID)VALUES(2,6,23);
INSERT INTO C__ARRAY_MEMBER_JAVA_LANG_OBJECT(C__ARRAY_MEMBER_ID,C__POSITION,C__VALUE,COMPONENT_TYPE)values(23,0,null,1);
SELECT LAST_INSERT_ID();
INSERT INTO C__HAS_A (OWNER_TABLE,OWNER_ID,PROPERTY_TABLE,PROPERTY_ID,PROPERTY_CLASS,RELATION_NAME) values (8,23,10,10,1,null);
INSERT INTO JAVA_LANG_CLONEABLE (C__REALCLASS, C__ID)VALUES(7, 23);
INSERT INTO JAVA_IO_SERIALIZABLE (C__REALCLASS, C__ID)VALUES(7, 23);
INSERT INTO JAVA_UTIL_COLLECTION (EMPTY_, C__COLLECTION_CONTENTS, C__REALCLASS, C__ID)VALUES(0, 23, 5, 22);
INSERT INTO C__HAS_A (OWNER_TABLE,OWNER_ID,PROPERTY_TABLE,PROPERTY_ID,PROPERTY_CLASS,RELATION_NAME) values (11,22,8,23,null,1);
INSERT INTO JAVA_LANG_ITERABLE (C__REALCLASS, C__ID)VALUES(9, 22);
INSERT INTO JAVA_UTIL_ABSTRACTCOLLECTION (C__REALCLASS, C__ID)VALUES(4, 22);
INSERT INTO JAVA_LANG_OBJECT (C__REALCLASS)VALUES(3);
SELECT LAST_INSERT_ID();
INSERT INTO JAVA_UTIL_HASHSET (C__ID)VALUES(24);
INSERT INTO JAVA_LANG_CLONEABLE (C__REALCLASS, C__ID)VALUES(2, 24);
INSERT INTO JAVA_IO_SERIALIZABLE (C__REALCLASS, C__ID)VALUES(2, 24);
INSERT INTO JAVA_UTIL_ABSTRACTSET (C__REALCLASS, C__ID)VALUES(2, 24);
INSERT INTO JAVA_UTIL_SET (C__REALCLASS, C__ID)VALUES(4, 24);
INSERT INTO JAVA_LANG_OBJECT (C__REALCLASS)VALUES(7);
SELECT LAST_INSERT_ID();
INSERT INTO C__ARRAY (COMPONENT_TABLE,COMPONENT_TYPE,C__ID)VALUES(2,6,25);
INSERT INTO JAVA_LANG_OBJECT (C__REALCLASS)VALUES(10);
SELECT LAST_INSERT_ID();
INSERT INTO JAVA_LANG_STRING (C__VALUE, C__ID)VALUES('science fiction', 26);
INSERT INTO JAVA_IO_SERIALIZABLE (C__REALCLASS, C__ID)VALUES(10, 26);
INSERT INTO JAVA_LANG_COMPARABLE (C__REALCLASS, C__ID)VALUES(10, 26);
INSERT INTO JAVA_LANG_CHARSEQUENCE (C__REALCLASS, C__ID)VALUES(10, 26);
INSERT INTO C__ARRAY_MEMBER_JAVA_LANG_OBJECT(C__ARRAY_MEMBER_ID,C__POSITION,C__VALUE,COMPONENT_TYPE)values(25,0,26,10);
SELECT LAST_INSERT_ID();
INSERT INTO C__HAS_A (OWNER_TABLE,OWNER_ID,PROPERTY_TABLE,PROPERTY_ID,PROPERTY_CLASS,RELATION_NAME) values (10,11,2,26,10,null);
INSERT INTO C__HAS_A (OWNER_TABLE,OWNER_ID,PROPERTY_TABLE,PROPERTY_ID,PROPERTY_CLASS,RELATION_NAME) values (8,25,10,11,10,null);
INSERT INTO JAVA_LANG_OBJECT (C__REALCLASS)VALUES(10);
SELECT LAST_INSERT_ID();
INSERT INTO JAVA_LANG_STRING (C__VALUE, C__ID)VALUES('psychohistory', 27);
INSERT INTO JAVA_IO_SERIALIZABLE (C__REALCLASS, C__ID)VALUES(10, 27);
INSERT INTO JAVA_LANG_COMPARABLE (C__REALCLASS, C__ID)VALUES(10, 27);
INSERT INTO JAVA_LANG_CHARSEQUENCE (C__REALCLASS, C__ID)VALUES(10, 27);
INSERT INTO C__ARRAY_MEMBER_JAVA_LANG_OBJECT(C__ARRAY_MEMBER_ID,C__POSITION,C__VALUE,COMPONENT_TYPE)values(25,1,27,10);
SELECT LAST_INSERT_ID();
INSERT INTO C__HAS_A (OWNER_TABLE,OWNER_ID,PROPERTY_TABLE,PROPERTY_ID,PROPERTY_CLASS,RELATION_NAME) values (10,12,2,27,10,null);
INSERT INTO C__HAS_A (OWNER_TABLE,OWNER_ID,PROPERTY_TABLE,PROPERTY_ID,PROPERTY_CLASS,RELATION_NAME) values (8,25,10,12,10,null);
INSERT INTO JAVA_LANG_CLONEABLE (C__REALCLASS, C__ID)VALUES(7, 25);
INSERT INTO JAVA_IO_SERIALIZABLE (C__REALCLASS, C__ID)VALUES(7, 25);
INSERT INTO JAVA_UTIL_COLLECTION (EMPTY_, C__COLLECTION_CONTENTS, C__REALCLASS, C__ID)VALUES(0, 25, 5, 24);
INSERT INTO C__HAS_A (OWNER_TABLE,OWNER_ID,PROPERTY_TABLE,PROPERTY_ID,PROPERTY_CLASS,RELATION_NAME) values (11,24,8,25,null,1);
INSERT INTO JAVA_LANG_ITERABLE (C__REALCLASS, C__ID)VALUES(9, 24);
INSERT INTO JAVA_UTIL_ABSTRACTCOLLECTION (C__REALCLASS, C__ID)VALUES(4, 24);
INSERT INTO ORG_CONSERVE_OBJECTS_BOOK (TITLE, AUTHORS, PUBLISHEDYEAR, KEYWORDS, C__ID)VALUES('Foundation', 22, 1951, 24, 21);
INSERT INTO C__HAS_A (OWNER_TABLE,OWNER_ID,PROPERTY_TABLE,PROPERTY_ID,PROPERTY_CLASS,RELATION_NAME) values (9,21,3,22,2,2);
INSERT INTO C__HAS_A (OWNER_TABLE,OWNER_ID,PROPERTY_TABLE,PROPERTY_ID,PROPERTY_CLASS,RELATION_NAME) values (9,21,3,24,2,3);
INSERT INTO C__ARRAY_MEMBER_JAVA_LANG_OBJECT(C__ARRAY_MEMBER_ID,C__POSITION,C__VALUE,COMPONENT_TYPE)values(20,0,21,8);
SELECT LAST_INSERT_ID();
INSERT INTO C__HAS_A (OWNER_TABLE,OWNER_ID,PROPERTY_TABLE,PROPERTY_ID,PROPERTY_CLASS,RELATION_NAME) values (10,13,2,21,8,null);
INSERT INTO C__HAS_A (OWNER_TABLE,OWNER_ID,PROPERTY_TABLE,PROPERTY_ID,PROPERTY_CLASS,RELATION_NAME) values (8,20,10,13,8,null);
INSERT INTO JAVA_LANG_OBJECT (C__REALCLASS)VALUES(8);
SELECT LAST_INSERT_ID();
INSERT INTO JAVA_LANG_OBJECT (C__REALCLASS)VALUES(3);
SELECT LAST_INSERT_ID();
INSERT INTO JAVA_UTIL_HASHSET (C__ID)VALUES(29);
INSERT INTO JAVA_LANG_CLONEABLE (C__REALCLASS, C__ID)VALUES(2, 29);
INSERT INTO JAVA_IO_SERIALIZABLE (C__REALCLASS, C__ID)VALUES(2, 29);
INSERT INTO JAVA_UTIL_ABSTRACTSET (C__REALCLASS, C__ID)VALUES(2, 29);
INSERT INTO JAVA_UTIL_SET (C__REALCLASS, C__ID)VALUES(4, 29);
INSERT INTO JAVA_LANG_OBJECT (C__REALCLASS)VALUES(7);
SELECT LAST_INSERT_ID();
INSERT INTO C__ARRAY (COMPONENT_TABLE,COMPONENT_TYPE,C__ID)VALUES(2,6,30);
INSERT INTO C__ARRAY_MEMBER_JAVA_LANG_OBJECT(C__ARRAY_MEMBER_ID,C__POSITION,C__VALUE,COMPONENT_TYPE)values(30,0,null,1);
SELECT LAST_INSERT_ID();
INSERT INTO C__HAS_A (OWNER_TABLE,OWNER_ID,PROPERTY_TABLE,PROPERTY_ID,PROPERTY_CLASS,RELATION_NAME) values (8,30,10,14,1,null);
INSERT INTO JAVA_LANG_CLONEABLE (C__REALCLASS, C__ID)VALUES(7, 30);
INSERT INTO JAVA_IO_SERIALIZABLE (C__REALCLASS, C__ID)VALUES(7, 30);
INSERT INTO JAVA_UTIL_COLLECTION (EMPTY_, C__COLLECTION_CONTENTS, C__REALCLASS, C__ID)VALUES(0, 30, 5, 29);
INSERT INTO C__HAS_A (OWNER_TABLE,OWNER_ID,PROPERTY_TABLE,PROPERTY_ID,PROPERTY_CLASS,RELATION_NAME) values (11,29,8,30,null,1);
INSERT INTO JAVA_LANG_ITERABLE (C__REALCLASS, C__ID)VALUES(9, 29);
INSERT INTO JAVA_UTIL_ABSTRACTCOLLECTION (C__REALCLASS, C__ID)VALUES(4, 29);
INSERT INTO JAVA_LANG_OBJECT (C__REALCLASS)VALUES(3);
SELECT LAST_INSERT_ID();
INSERT INTO JAVA_UTIL_HASHSET (C__ID)VALUES(31);
INSERT INTO JAVA_LANG_CLONEABLE (C__REALCLASS, C__ID)VALUES(2, 31);
INSERT INTO JAVA_IO_SERIALIZABLE (C__REALCLASS, C__ID)VALUES(2, 31);
INSERT INTO JAVA_UTIL_ABSTRACTSET (C__REALCLASS, C__ID)VALUES(2, 31);
INSERT INTO JAVA_UTIL_SET (C__REALCLASS, C__ID)VALUES(4, 31);
INSERT INTO JAVA_LANG_OBJECT (C__REALCLASS)VALUES(7);
SELECT LAST_INSERT_ID();
INSERT INTO C__ARRAY (COMPONENT_TABLE,COMPONENT_TYPE,C__ID)VALUES(2,6,32);
INSERT INTO JAVA_LANG_OBJECT (C__REALCLASS)VALUES(10);
SELECT LAST_INSERT_ID();
INSERT INTO JAVA_LANG_STRING (C__VALUE, C__ID)VALUES('robot', 33);
INSERT INTO JAVA_IO_SERIALIZABLE (C__REALCLASS, C__ID)VALUES(10, 33);
INSERT INTO JAVA_LANG_COMPARABLE (C__REALCLASS, C__ID)VALUES(10, 33);
INSERT INTO JAVA_LANG_CHARSEQUENCE (C__REALCLASS, C__ID)VALUES(10, 33);
INSERT INTO C__ARRAY_MEMBER_JAVA_LANG_OBJECT(C__ARRAY_MEMBER_ID,C__POSITION,C__VALUE,COMPONENT_TYPE)values(32,0,33,10);
SELECT LAST_INSERT_ID();
INSERT INTO C__HAS_A (OWNER_TABLE,OWNER_ID,PROPERTY_TABLE,PROPERTY_ID,PROPERTY_CLASS,RELATION_NAME) values (10,15,2,33,10,null);
INSERT INTO C__HAS_A (OWNER_TABLE,OWNER_ID,PROPERTY_TABLE,PROPERTY_ID,PROPERTY_CLASS,RELATION_NAME) values (8,32,10,15,10,null);
INSERT INTO C__ARRAY_MEMBER_JAVA_LANG_OBJECT(C__ARRAY_MEMBER_ID,C__POSITION,C__VALUE,COMPONENT_TYPE)values(32,1,26,10);
SELECT LAST_INSERT_ID();
INSERT INTO C__HAS_A (OWNER_TABLE,OWNER_ID,PROPERTY_TABLE,PROPERTY_ID,PROPERTY_CLASS,RELATION_NAME) values (10,16,2,26,10,null);
INSERT INTO C__HAS_A (OWNER_TABLE,OWNER_ID,PROPERTY_TABLE,PROPERTY_ID,PROPERTY_CLASS,RELATION_NAME) values (8,32,10,16,10,null);
SELECT COUNT(*) FROM JAVA_LANG_STRING WHERE C__ID = 17;
UPDATE JAVA_LANG_STRING SET C__VALUE = 'crime'  WHERE C__ID = 17;
INSERT INTO C__ARRAY_MEMBER_JAVA_LANG_OBJECT(C__ARRAY_MEMBER_ID,C__POSITION,C__VALUE,COMPONENT_TYPE)values(32,2,17,10);
SELECT LAST_INSERT_ID();
INSERT INTO C__HAS_A (OWNER_TABLE,OWNER_ID,PROPERTY_TABLE,PROPERTY_ID,PROPERTY_CLASS,RELATION_NAME) values (10,17,2,17,10,null);
INSERT INTO C__HAS_A (OWNER_TABLE,OWNER_ID,PROPERTY_TABLE,PROPERTY_ID,PROPERTY_CLASS,RELATION_NAME) values (8,32,10,17,10,null);
INSERT INTO JAVA_LANG_CLONEABLE (C__REALCLASS, C__ID)VALUES(7, 32);
INSERT INTO JAVA_IO_SERIALIZABLE (C__REALCLASS, C__ID)VALUES(7, 32);
INSERT INTO JAVA_UTIL_COLLECTION (EMPTY_, C__COLLECTION_CONTENTS, C__REALCLASS, C__ID)VALUES(0, 32, 5, 31);
INSERT INTO C__HAS_A (OWNER_TABLE,OWNER_ID,PROPERTY_TABLE,PROPERTY_ID,PROPERTY_CLASS,RELATION_NAME) values (11,31,8,32,null,1);
INSERT INTO JAVA_LANG_ITERABLE (C__REALCLASS, C__ID)VALUES(9, 31);
INSERT INTO JAVA_UTIL_ABSTRACTCOLLECTION (C__REALCLASS, C__ID)VALUES(4, 31);
INSERT INTO ORG_CONSERVE_OBJECTS_BOOK (TITLE, AUTHORS, PUBLISHEDYEAR, KEYWORDS, C__ID)VALUES('The Caves of Steel', 29, 1954, 31, 28);
INSERT INTO C__HAS_A (OWNER_TABLE,OWNER_ID,PROPERTY_TABLE,PROPERTY_ID,PROPERTY_CLASS,RELATION_NAME) values (9,28,3,29,2,2);
INSERT INTO C__HAS_A (OWNER_TABLE,OWNER_ID,PROPERTY_TABLE,PROPERTY_ID,PROPERTY_CLASS,RELATION_NAME) values (9,28,3,31,2,3);
INSERT INTO C__ARRAY_MEMBER_JAVA_LANG_OBJECT(C__ARRAY_MEMBER_ID,C__POSITION,C__VALUE,COMPONENT_TYPE)values(20,1,28,8);
SELECT LAST_INSERT_ID();
INSERT INTO C__HAS_A (OWNER_TABLE,OWNER_ID,PROPERTY_TABLE,PROPERTY_ID,PROPERTY_CLASS,RELATION_NAME) values (10,18,2,28,8,null);
INSERT INTO C__HAS_A (OWNER_TABLE,OWNER_ID,PROPERTY_TABLE,PROPERTY_ID,PROPERTY_CLASS,RELATION_NAME) values (8,20,10,18,8,null);
INSERT INTO JAVA_LANG_CLONEABLE (C__REALCLASS, C__ID)VALUES(7, 20);
INSERT INTO JAVA_IO_SERIALIZABLE (C__REALCLASS, C__ID)VALUES(7, 20);
INSERT INTO JAVA_UTIL_COLLECTION (EMPTY_, C__COLLECTION_CONTENTS, C__REALCLASS, C__ID)VALUES(0, 20, 5, 19);
INSERT INTO C__HAS_A (OWNER_TABLE,OWNER_ID,PROPERTY_TABLE,PROPERTY_ID,PROPERTY_CLASS,RELATION_NAME) values (11,19,8,20,null,1);
INSERT INTO JAVA_LANG_ITERABLE (C__REALCLASS, C__ID)VALUES(9, 19);
INSERT INTO JAVA_UTIL_ABSTRACTCOLLECTION (C__REALCLASS, C__ID)VALUES(4, 19);
INSERT INTO ORG_CONSERVE_OBJECTS_AUTHOR (BOOKS, FIRSTNAME, LASTNAME, BIRTHYEAR, C__ID)VALUES(19, 'Isaac', 'Asimov', 1920, 18);
INSERT INTO C__HAS_A (OWNER_TABLE,OWNER_ID,PROPERTY_TABLE,PROPERTY_ID,PROPERTY_CLASS,RELATION_NAME) values (1,18,3,19,2,4);
INSERT INTO C__HAS_A (PROPERTY_TABLE,PROPERTY_ID,PROPERTY_CLASS) values (1,18,1);
UPDATE C__ARRAY_MEMBER_JAVA_LANG_OBJECT SET C__VALUE = 18 WHERE C__ID = 10;
INSERT INTO C__HAS_A (OWNER_TABLE,OWNER_ID,PROPERTY_TABLE,PROPERTY_ID,PROPERTY_CLASS,RELATION_NAME) values (10,10,2,18,1,5);
UPDATE C__ARRAY_MEMBER_JAVA_LANG_OBJECT SET C__VALUE = 18 WHERE C__ID = 14;
INSERT INTO C__HAS_A (OWNER_TABLE,OWNER_ID,PROPERTY_TABLE,PROPERTY_ID,PROPERTY_CLASS,RELATION_NAME) values (10,14,2,18,1,5);
INSERT INTO JAVA_LANG_OBJECT (C__REALCLASS)VALUES(1);
SELECT LAST_INSERT_ID();
INSERT INTO JAVA_LANG_OBJECT (C__REALCLASS)VALUES(3);
SELECT LAST_INSERT_ID();
INSERT INTO JAVA_UTIL_HASHSET (C__ID)VALUES(35);
INSERT INTO JAVA_LANG_CLONEABLE (C__REALCLASS, C__ID)VALUES(2, 35);
INSERT INTO JAVA_IO_SERIALIZABLE (C__REALCLASS, C__ID)VALUES(2, 35);
INSERT INTO JAVA_UTIL_ABSTRACTSET (C__REALCLASS, C__ID)VALUES(2, 35);
INSERT INTO JAVA_UTIL_SET (C__REALCLASS, C__ID)VALUES(4, 35);
INSERT INTO JAVA_LANG_OBJECT (C__REALCLASS)VALUES(7);
SELECT LAST_INSERT_ID();
INSERT INTO C__ARRAY (COMPONENT_TABLE,COMPONENT_TYPE,C__ID)VALUES(2,6,36);
INSERT INTO JAVA_LANG_OBJECT (C__REALCLASS)VALUES(8);
SELECT LAST_INSERT_ID();
INSERT INTO JAVA_LANG_OBJECT (C__REALCLASS)VALUES(3);
SELECT LAST_INSERT_ID();
INSERT INTO JAVA_UTIL_HASHSET (C__ID)VALUES(38);
INSERT INTO JAVA_LANG_CLONEABLE (C__REALCLASS, C__ID)VALUES(2, 38);
INSERT INTO JAVA_IO_SERIALIZABLE (C__REALCLASS, C__ID)VALUES(2, 38);
INSERT INTO JAVA_UTIL_ABSTRACTSET (C__REALCLASS, C__ID)VALUES(2, 38);
INSERT INTO JAVA_UTIL_SET (C__REALCLASS, C__ID)VALUES(4, 38);
INSERT INTO JAVA_LANG_OBJECT (C__REALCLASS)VALUES(7);
SELECT LAST_INSERT_ID();
INSERT INTO C__ARRAY (COMPONENT_TABLE,COMPONENT_TYPE,C__ID)VALUES(2,6,39);
INSERT INTO C__ARRAY_MEMBER_JAVA_LANG_OBJECT(C__ARRAY_MEMBER_ID,C__POSITION,C__VALUE,COMPONENT_TYPE)values(39,0,null,1);
SELECT LAST_INSERT_ID();
INSERT INTO C__HAS_A (OWNER_TABLE,OWNER_ID,PROPERTY_TABLE,PROPERTY_ID,PROPERTY_CLASS,RELATION_NAME) values (8,39,10,19,1,null);
INSERT INTO JAVA_LANG_CLONEABLE (C__REALCLASS, C__ID)VALUES(7, 39);
INSERT INTO JAVA_IO_SERIALIZABLE (C__REALCLASS, C__ID)VALUES(7, 39);
INSERT INTO JAVA_UTIL_COLLECTION (EMPTY_, C__COLLECTION_CONTENTS, C__REALCLASS, C__ID)VALUES(0, 39, 5, 38);
INSERT INTO C__HAS_A (OWNER_TABLE,OWNER_ID,PROPERTY_TABLE,PROPERTY_ID,PROPERTY_CLASS,RELATION_NAME) values (11,38,8,39,null,1);
INSERT INTO JAVA_LANG_ITERABLE (C__REALCLASS, C__ID)VALUES(9, 38);
INSERT INTO JAVA_UTIL_ABSTRACTCOLLECTION (C__REALCLASS, C__ID)VALUES(4, 38);
INSERT INTO JAVA_LANG_OBJECT (C__REALCLASS)VALUES(3);
SELECT LAST_INSERT_ID();
INSERT INTO JAVA_UTIL_HASHSET (C__ID)VALUES(40);
INSERT INTO JAVA_LANG_CLONEABLE (C__REALCLASS, C__ID)VALUES(2, 40);
INSERT INTO JAVA_IO_SERIALIZABLE (C__REALCLASS, C__ID)VALUES(2, 40);
INSERT INTO JAVA_UTIL_ABSTRACTSET (C__REALCLASS, C__ID)VALUES(2, 40);
INSERT INTO JAVA_UTIL_SET (C__REALCLASS, C__ID)VALUES(4, 40);
INSERT INTO JAVA_LANG_OBJECT (C__REALCLASS)VALUES(7);
SELECT LAST_INSERT_ID();
INSERT INTO C__ARRAY (COMPONENT_TABLE,COMPONENT_TYPE,C__ID)VALUES(2,6,41);
INSERT INTO JAVA_LANG_OBJECT (C__REALCLASS)VALUES(10);
SELECT LAST_INSERT_ID();
INSERT INTO JAVA_LANG_STRING (C__VALUE, C__ID)VALUES('cave', 42);
INSERT INTO JAVA_IO_SERIALIZABLE (C__REALCLASS, C__ID)VALUES(10, 42);
INSERT INTO JAVA_LANG_COMPARABLE (C__REALCLASS, C__ID)VALUES(10, 42);
INSERT INTO JAVA_LANG_CHARSEQUENCE (C__REALCLASS, C__ID)VALUES(10, 42);
INSERT INTO C__ARRAY_MEMBER_JAVA_LANG_OBJECT(C__ARRAY_MEMBER_ID,C__POSITION,C__VALUE,COMPONENT_TYPE)values(41,0,42,10);
SELECT LAST_INSERT_ID();
INSERT INTO C__HAS_A (OWNER_TABLE,OWNER_ID,PROPERTY_TABLE,PROPERTY_ID,PROPERTY_CLASS,RELATION_NAME) values (10,20,2,42,10,null);
INSERT INTO C__HAS_A (OWNER_TABLE,OWNER_ID,PROPERTY_TABLE,PROPERTY_ID,PROPERTY_CLASS,RELATION_NAME) values (8,41,10,20,10,null);
SELECT COUNT(*) FROM JAVA_LANG_STRING WHERE C__ID = 26;
UPDATE JAVA_LANG_STRING SET C__VALUE = 'science fiction'  WHERE C__ID = 26;
INSERT INTO C__ARRAY_MEMBER_JAVA_LANG_OBJECT(C__ARRAY_MEMBER_ID,C__POSITION,C__VALUE,COMPONENT_TYPE)values(41,1,26,10);
SELECT LAST_INSERT_ID();
INSERT INTO C__HAS_A (OWNER_TABLE,OWNER_ID,PROPERTY_TABLE,PROPERTY_ID,PROPERTY_CLASS,RELATION_NAME) values (10,21,2,26,10,null);
INSERT INTO C__HAS_A (OWNER_TABLE,OWNER_ID,PROPERTY_TABLE,PROPERTY_ID,PROPERTY_CLASS,RELATION_NAME) values (8,41,10,21,10,null);
INSERT INTO JAVA_LANG_CLONEABLE (C__REALCLASS, C__ID)VALUES(7, 41);
INSERT INTO JAVA_IO_SERIALIZABLE (C__REALCLASS, C__ID)VALUES(7, 41);
INSERT INTO JAVA_UTIL_COLLECTION (EMPTY_, C__COLLECTION_CONTENTS, C__REALCLASS, C__ID)VALUES(0, 41, 5, 40);
INSERT INTO C__HAS_A (OWNER_TABLE,OWNER_ID,PROPERTY_TABLE,PROPERTY_ID,PROPERTY_CLASS,RELATION_NAME) values (11,40,8,41,null,1);
INSERT INTO JAVA_LANG_ITERABLE (C__REALCLASS, C__ID)VALUES(9, 40);
INSERT INTO JAVA_UTIL_ABSTRACTCOLLECTION (C__REALCLASS, C__ID)VALUES(4, 40);
INSERT INTO ORG_CONSERVE_OBJECTS_BOOK (TITLE, AUTHORS, PUBLISHEDYEAR, KEYWORDS, C__ID)VALUES('A Journey to the Center of the Earth', 38, 1864, 40, 37);
INSERT INTO C__HAS_A (OWNER_TABLE,OWNER_ID,PROPERTY_TABLE,PROPERTY_ID,PROPERTY_CLASS,RELATION_NAME) values (9,37,3,38,2,2);
INSERT INTO C__HAS_A (OWNER_TABLE,OWNER_ID,PROPERTY_TABLE,PROPERTY_ID,PROPERTY_CLASS,RELATION_NAME) values (9,37,3,40,2,3);
INSERT INTO C__ARRAY_MEMBER_JAVA_LANG_OBJECT(C__ARRAY_MEMBER_ID,C__POSITION,C__VALUE,COMPONENT_TYPE)values(36,0,37,8);
SELECT LAST_INSERT_ID();
INSERT INTO C__HAS_A (OWNER_TABLE,OWNER_ID,PROPERTY_TABLE,PROPERTY_ID,PROPERTY_CLASS,RELATION_NAME) values (10,22,2,37,8,null);
INSERT INTO C__HAS_A (OWNER_TABLE,OWNER_ID,PROPERTY_TABLE,PROPERTY_ID,PROPERTY_CLASS,RELATION_NAME) values (8,36,10,22,8,null);
INSERT INTO JAVA_LANG_OBJECT (C__REALCLASS)VALUES(8);
SELECT LAST_INSERT_ID();
INSERT INTO JAVA_LANG_OBJECT (C__REALCLASS)VALUES(3);
SELECT LAST_INSERT_ID();
INSERT INTO JAVA_UTIL_HASHSET (C__ID)VALUES(44);
INSERT INTO JAVA_LANG_CLONEABLE (C__REALCLASS, C__ID)VALUES(2, 44);
INSERT INTO JAVA_IO_SERIALIZABLE (C__REALCLASS, C__ID)VALUES(2, 44);
INSERT INTO JAVA_UTIL_ABSTRACTSET (C__REALCLASS, C__ID)VALUES(2, 44);
INSERT INTO JAVA_UTIL_SET (C__REALCLASS, C__ID)VALUES(4, 44);
INSERT INTO JAVA_LANG_OBJECT (C__REALCLASS)VALUES(7);
SELECT LAST_INSERT_ID();
INSERT INTO C__ARRAY (COMPONENT_TABLE,COMPONENT_TYPE,C__ID)VALUES(2,6,45);
INSERT INTO C__ARRAY_MEMBER_JAVA_LANG_OBJECT(C__ARRAY_MEMBER_ID,C__POSITION,C__VALUE,COMPONENT_TYPE)values(45,0,null,1);
SELECT LAST_INSERT_ID();
INSERT INTO C__HAS_A (OWNER_TABLE,OWNER_ID,PROPERTY_TABLE,PROPERTY_ID,PROPERTY_CLASS,RELATION_NAME) values (8,45,10,23,1,null);
INSERT INTO JAVA_LANG_CLONEABLE (C__REALCLASS, C__ID)VALUES(7, 45);
INSERT INTO JAVA_IO_SERIALIZABLE (C__REALCLASS, C__ID)VALUES(7, 45);
INSERT INTO JAVA_UTIL_COLLECTION (EMPTY_, C__COLLECTION_CONTENTS, C__REALCLASS, C__ID)VALUES(0, 45, 5, 44);
INSERT INTO C__HAS_A (OWNER_TABLE,OWNER_ID,PROPERTY_TABLE,PROPERTY_ID,PROPERTY_CLASS,RELATION_NAME) values (11,44,8,45,null,1);
INSERT INTO JAVA_LANG_ITERABLE (C__REALCLASS, C__ID)VALUES(9, 44);
INSERT INTO JAVA_UTIL_ABSTRACTCOLLECTION (C__REALCLASS, C__ID)VALUES(4, 44);
INSERT INTO JAVA_LANG_OBJECT (C__REALCLASS)VALUES(3);
SELECT LAST_INSERT_ID();
INSERT INTO JAVA_UTIL_HASHSET (C__ID)VALUES(46);
INSERT INTO JAVA_LANG_CLONEABLE (C__REALCLASS, C__ID)VALUES(2, 46);
INSERT INTO JAVA_IO_SERIALIZABLE (C__REALCLASS, C__ID)VALUES(2, 46);
INSERT INTO JAVA_UTIL_ABSTRACTSET (C__REALCLASS, C__ID)VALUES(2, 46);
INSERT INTO JAVA_UTIL_SET (C__REALCLASS, C__ID)VALUES(4, 46);
INSERT INTO JAVA_LANG_OBJECT (C__REALCLASS)VALUES(7);
SELECT LAST_INSERT_ID();
INSERT INTO C__ARRAY (COMPONENT_TABLE,COMPONENT_TYPE,C__ID)VALUES(2,6,47);
INSERT INTO C__ARRAY_MEMBER_JAVA_LANG_OBJECT(C__ARRAY_MEMBER_ID,C__POSITION,C__VALUE,COMPONENT_TYPE)values(47,0,26,10);
SELECT LAST_INSERT_ID();
INSERT INTO C__HAS_A (OWNER_TABLE,OWNER_ID,PROPERTY_TABLE,PROPERTY_ID,PROPERTY_CLASS,RELATION_NAME) values (10,24,2,26,10,null);
INSERT INTO C__HAS_A (OWNER_TABLE,OWNER_ID,PROPERTY_TABLE,PROPERTY_ID,PROPERTY_CLASS,RELATION_NAME) values (8,47,10,24,10,null);
INSERT INTO JAVA_LANG_OBJECT (C__REALCLASS)VALUES(10);
SELECT LAST_INSERT_ID();
INSERT INTO JAVA_LANG_STRING (C__VALUE, C__ID)VALUES('submarine', 48);
INSERT INTO JAVA_IO_SERIALIZABLE (C__REALCLASS, C__ID)VALUES(10, 48);
INSERT INTO JAVA_LANG_COMPARABLE (C__REALCLASS, C__ID)VALUES(10, 48);
INSERT INTO JAVA_LANG_CHARSEQUENCE (C__REALCLASS, C__ID)VALUES(10, 48);
INSERT INTO C__ARRAY_MEMBER_JAVA_LANG_OBJECT(C__ARRAY_MEMBER_ID,C__POSITION,C__VALUE,COMPONENT_TYPE)values(47,1,48,10);
SELECT LAST_INSERT_ID();
INSERT INTO C__HAS_A (OWNER_TABLE,OWNER_ID,PROPERTY_TABLE,PROPERTY_ID,PROPERTY_CLASS,RELATION_NAME) values (10,25,2,48,10,null);
INSERT INTO C__HAS_A (OWNER_TABLE,OWNER_ID,PROPERTY_TABLE,PROPERTY_ID,PROPERTY_CLASS,RELATION_NAME) values (8,47,10,25,10,null);
INSERT INTO JAVA_LANG_OBJECT (C__REALCLASS)VALUES(10);
SELECT LAST_INSERT_ID();
INSERT INTO JAVA_LANG_STRING (C__VALUE, C__ID)VALUES('ocean', 49);
INSERT INTO JAVA_IO_SERIALIZABLE (C__REALCLASS, C__ID)VALUES(10, 49);
INSERT INTO JAVA_LANG_COMPARABLE (C__REALCLASS, C__ID)VALUES(10, 49);
INSERT INTO JAVA_LANG_CHARSEQUENCE (C__REALCLASS, C__ID)VALUES(10, 49);
INSERT INTO C__ARRAY_MEMBER_JAVA_LANG_OBJECT(C__ARRAY_MEMBER_ID,C__POSITION,C__VALUE,COMPONENT_TYPE)values(47,2,49,10);
SELECT LAST_INSERT_ID();
INSERT INTO C__HAS_A (OWNER_TABLE,OWNER_ID,PROPERTY_TABLE,PROPERTY_ID,PROPERTY_CLASS,RELATION_NAME) values (10,26,2,49,10,null);
INSERT INTO C__HAS_A (OWNER_TABLE,OWNER_ID,PROPERTY_TABLE,PROPERTY_ID,PROPERTY_CLASS,RELATION_NAME) values (8,47,10,26,10,null);
INSERT INTO JAVA_LANG_CLONEABLE (C__REALCLASS, C__ID)VALUES(7, 47);
INSERT INTO JAVA_IO_SERIALIZABLE (C__REALCLASS, C__ID)VALUES(7, 47);
INSERT INTO JAVA_UTIL_COLLECTION (EMPTY_, C__COLLECTION_CONTENTS, C__REALCLASS, C__ID)VALUES(0, 47, 5, 46);
INSERT INTO C__HAS_A (OWNER_TABLE,OWNER_ID,PROPERTY_TABLE,PROPERTY_ID,PROPERTY_CLASS,RELATION_NAME) values (11,46,8,47,null,1);
INSERT INTO JAVA_LANG_ITERABLE (C__REALCLASS, C__ID)VALUES(9, 46);
INSERT INTO JAVA_UTIL_ABSTRACTCOLLECTION (C__REALCLASS, C__ID)VALUES(4, 46);
INSERT INTO ORG_CONSERVE_OBJECTS_BOOK (TITLE, AUTHORS, PUBLISHEDYEAR, KEYWORDS, C__ID)VALUES('Twenty Thousand Leagues under the Sea', 44, 1869, 46, 43);
INSERT INTO C__HAS_A (OWNER_TABLE,OWNER_ID,PROPERTY_TABLE,PROPERTY_ID,PROPERTY_CLASS,RELATION_NAME) values (9,43,3,44,2,2);
INSERT INTO C__HAS_A (OWNER_TABLE,OWNER_ID,PROPERTY_TABLE,PROPERTY_ID,PROPERTY_CLASS,RELATION_NAME) values (9,43,3,46,2,3);
INSERT INTO C__ARRAY_MEMBER_JAVA_LANG_OBJECT(C__ARRAY_MEMBER_ID,C__POSITION,C__VALUE,COMPONENT_TYPE)values(36,1,43,8);
SELECT LAST_INSERT_ID();
INSERT INTO C__HAS_A (OWNER_TABLE,OWNER_ID,PROPERTY_TABLE,PROPERTY_ID,PROPERTY_CLASS,RELATION_NAME) values (10,27,2,43,8,null);
INSERT INTO C__HAS_A (OWNER_TABLE,OWNER_ID,PROPERTY_TABLE,PROPERTY_ID,PROPERTY_CLASS,RELATION_NAME) values (8,36,10,27,8,null);
INSERT INTO JAVA_LANG_CLONEABLE (C__REALCLASS, C__ID)VALUES(7, 36);
INSERT INTO JAVA_IO_SERIALIZABLE (C__REALCLASS, C__ID)VALUES(7, 36);
INSERT INTO JAVA_UTIL_COLLECTION (EMPTY_, C__COLLECTION_CONTENTS, C__REALCLASS, C__ID)VALUES(0, 36, 5, 35);
INSERT INTO C__HAS_A (OWNER_TABLE,OWNER_ID,PROPERTY_TABLE,PROPERTY_ID,PROPERTY_CLASS,RELATION_NAME) values (11,35,8,36,null,1);
INSERT INTO JAVA_LANG_ITERABLE (C__REALCLASS, C__ID)VALUES(9, 35);
INSERT INTO JAVA_UTIL_ABSTRACTCOLLECTION (C__REALCLASS, C__ID)VALUES(4, 35);
INSERT INTO ORG_CONSERVE_OBJECTS_AUTHOR (BOOKS, FIRSTNAME, LASTNAME, BIRTHYEAR, C__ID)VALUES(35, 'Jules', 'Verne', 1828, 34);
INSERT INTO C__HAS_A (OWNER_TABLE,OWNER_ID,PROPERTY_TABLE,PROPERTY_ID,PROPERTY_CLASS,RELATION_NAME) values (1,34,3,35,2,4);
INSERT INTO C__HAS_A (PROPERTY_TABLE,PROPERTY_ID,PROPERTY_CLASS) values (1,34,1);
UPDATE C__ARRAY_MEMBER_JAVA_LANG_OBJECT SET C__VALUE = 34 WHERE C__ID = 19;
INSERT INTO C__HAS_A (OWNER_TABLE,OWNER_ID,PROPERTY_TABLE,PROPERTY_ID,PROPERTY_CLASS,RELATION_NAME) values (10,19,2,34,1,5);
UPDATE C__ARRAY_MEMBER_JAVA_LANG_OBJECT SET C__VALUE = 34 WHERE C__ID = 23;
INSERT INTO C__HAS_A (OWNER_TABLE,OWNER_ID,PROPERTY_TABLE,PROPERTY_ID,PROPERTY_CLASS,RELATION_NAME) values (10,23,2,34,1,5);
SELECT VERSION FROM C__SCHEMA_VERSION;
SELECT NAME,C__ID FROM C__TABLE_NAME_MAP;
SELECT NAME,C__ID FROM C__CLASS_NAME_MAP;
SELECT NAME,C__ID FROM C__COLUMN_NAME_MAP;
SELECT DISTINCT(A.C__ID),A.C__REALCLASS,A.TITLE,A.AUTHORS,A.PUBLISHEDYEAR,A.KEYWORDS FROM ORG_CONSERVE_OBJECTS_BOOK AS A , JAVA_LANG_OBJECT AS B , JAVA_UTIL_SET AS I , JAVA_UTIL_HASHSET AS C , JAVA_UTIL_ABSTRACTSET AS D , JAVA_UTIL_ABSTRACTCOLLECTION AS E , JAVA_LANG_OBJECT AS F , JAVA_UTIL_COLLECTION AS G , C__ARRAY AS L , C__ARRAY_MEMBER_JAVA_LANG_OBJECT AS P , JAVA_LANG_OBJECT AS R , ORG_CONSERVE_OBJECTS_AUTHOR AS Q , JAVA_UTIL_HASHSET AS S , JAVA_UTIL_ABSTRACTSET AS T , JAVA_UTIL_ABSTRACTCOLLECTION AS U , JAVA_LANG_OBJECT AS V , JAVA_UTIL_SET AS Y , JAVA_UTIL_COLLECTION AS W , C__ARRAY AS BB , C__ARRAY_MEMBER_JAVA_LANG_OBJECT AS FB , JAVA_LANG_OBJECT AS HB , ORG_CONSERVE_OBJECTS_BOOK AS GB , JAVA_UTIL_SET AS OB , JAVA_UTIL_HASHSET AS IB , JAVA_UTIL_ABSTRACTSET AS JB , JAVA_UTIL_ABSTRACTCOLLECTION AS KB , JAVA_LANG_OBJECT AS LB , JAVA_UTIL_COLLECTION AS MB , C__ARRAY AS RB , C__ARRAY_MEMBER_JAVA_LANG_OBJECT AS VB , JAVA_UTIL_HASHSET AS WB , JAVA_UTIL_ABSTRACTSET AS XB , JAVA_UTIL_ABSTRACTCOLLECTION AS YB , JAVA_LANG_OBJECT AS ZB , JAVA_UTIL_SET AS CC , JAVA_UTIL_COLLECTION AS AC , C__ARRAY AS FC , C__ARRAY_MEMBER_JAVA_LANG_OBJECT AS JC , JAVA_LANG_OBJECT AS LC , JAVA_LANG_STRING AS KC WHERE A.C__ID = B.C__ID AND C.C__ID = D.C__ID AND D.C__ID = E.C__ID AND E.C__ID = F.C__ID AND D.C__ID = I.C__ID AND I.C__ID = G.C__ID AND Q.C__ID = R.C__ID AND S.C__ID = T.C__ID AND T.C__ID = U.C__ID AND U.C__ID = V.C__ID AND T.C__ID = Y.C__ID AND Y.C__ID = W.C__ID AND GB.C__ID = HB.C__ID AND IB.C__ID = JB.C__ID AND JB.C__ID = KB.C__ID AND KB.C__ID = LB.C__ID AND JB.C__ID = OB.C__ID AND OB.C__ID = MB.C__ID AND WB.C__ID = XB.C__ID AND XB.C__ID = YB.C__ID AND YB.C__ID = ZB.C__ID AND XB.C__ID = CC.C__ID AND CC.C__ID = AC.C__ID AND KC.C__ID = LC.C__ID AND A.AUTHORS = I.C__ID AND G.EMPTY_ = 0 AND G.C__COLLECTION_CONTENTS = L.C__ID AND L.C__ID = P.C__ARRAY_MEMBER_ID AND P.C__VALUE  = R.C__ID AND Q.BOOKS = S.C__ID AND W.EMPTY_ = 0 AND W.C__COLLECTION_CONTENTS = BB.C__ID AND BB.C__ID = FB.C__ARRAY_MEMBER_ID AND FB.C__VALUE  = HB.C__ID AND GB.AUTHORS = OB.C__ID AND MB.EMPTY_ = 0 AND MB.C__COLLECTION_CONTENTS = RB.C__ID AND GB.KEYWORDS = WB.C__ID AND AC.EMPTY_ = 0 AND AC.C__COLLECTION_CONTENTS = FC.C__ID AND FC.C__ID = JC.C__ARRAY_MEMBER_ID AND JC.C__VALUE  = LC.C__ID AND KC.C__VALUE = 'crime';
