text: --
  -- (C) Copyright 2015 Martin E. Nordberg III
  -- Apache 2.0 License
  --
  
  ----------------------------------------------------------------
  -- Simple genealogy graph model for metamodel loading testing --
  ----------------------------------------------------------------
  
  -- Package "test1"
  INSERT INTO GRESTLER_DOCUMENTED_ELEMENT
              ( ID )
       VALUES ( 'e4c4a700-a294-11e4-b20d-08002751500b' );
  INSERT INTO GRESTLER_PACKAGED_ELEMENT
              ( ID, PARENT_PACKAGE_ID, NAME )
       VALUES ( 'e4c4a700-a294-11e4-b20d-08002751500b', '00000000-7a26-11e4-a545-08002741a702', 'test1' );
  INSERT INTO GRESTLER_PACKAGE
              ( ID )
       VALUES ( 'e4c4a700-a294-11e4-b20d-08002751500b' );
  
  
  -- Attribute type "Person Name"
  INSERT INTO GRESTLER_DOCUMENTED_ELEMENT
              ( ID )
       VALUES ( 'e4c4a704-a294-11e4-b20d-08002751500b' );
  INSERT INTO GRESTLER_PACKAGED_ELEMENT
              ( ID, PARENT_PACKAGE_ID, NAME )
       VALUES ( 'e4c4a704-a294-11e4-b20d-08002751500b', 'e4c4a700-a294-11e4-b20d-08002751500b', 'Person Name' );
  INSERT INTO GRESTLER_ATTRIBUTE_TYPE
              ( ID )
       VALUES ( 'e4c4a704-a294-11e4-b20d-08002751500b' );
  INSERT INTO GRESTLER_STRING_ATTRIBUTE_TYPE
              ( ID, MAX_LENGTH, REGEX_PATTERN )
       VALUES ( 'e4c4a704-a294-11e4-b20d-08002751500b', 40, NULL );
  
  -- Attribute type "Birth Date"
  INSERT INTO GRESTLER_DOCUMENTED_ELEMENT
              ( ID )
       VALUES ( 'e4c4a707-a294-11e4-b20d-08002751500b' );
  INSERT INTO GRESTLER_PACKAGED_ELEMENT
              ( ID, PARENT_PACKAGE_ID, NAME )
       VALUES ( 'e4c4a707-a294-11e4-b20d-08002751500b', 'e4c4a700-a294-11e4-b20d-08002751500b', 'Birth Date' );
  INSERT INTO GRESTLER_ATTRIBUTE_TYPE
              ( ID )
       VALUES ( 'e4c4a707-a294-11e4-b20d-08002751500b' );
  INSERT INTO GRESTLER_DATETIME_ATTRIBUTE_TYPE
              ( ID, MIN_VALUE, MAX_VALUE )
       VALUES ( 'e4c4a707-a294-11e4-b20d-08002751500b',
                PARSEDATETIME('01-01-1600 00:00', 'dd-MM-yyyy hh:mm'),
                PARSEDATETIME('12-31-2015 00:00', 'dd-MM-yyyy hh:mm')  );
  
  -- Attribute type "Calls Weekly"
  INSERT INTO GRESTLER_DOCUMENTED_ELEMENT
              ( ID )
       VALUES ( 'e4c4a708-a294-11e4-b20d-08002751500b' );
  INSERT INTO GRESTLER_PACKAGED_ELEMENT
              ( ID, PARENT_PACKAGE_ID, NAME )
       VALUES ( 'e4c4a708-a294-11e4-b20d-08002751500b', 'e4c4a700-a294-11e4-b20d-08002751500b', 'Calls Weekly' );
  INSERT INTO GRESTLER_ATTRIBUTE_TYPE
              ( ID )
       VALUES ( 'e4c4a708-a294-11e4-b20d-08002751500b' );
  INSERT INTO GRESTLER_BOOLEAN_ATTRIBUTE_TYPE
              ( ID )
       VALUES ( 'e4c4a708-a294-11e4-b20d-08002751500b' );
  
  -- Attribute type "Net Assets"
  INSERT INTO GRESTLER_DOCUMENTED_ELEMENT
              ( ID )
       VALUES ( 'e4c4a70A-a294-11e4-b20d-08002751500b' );
  INSERT INTO GRESTLER_PACKAGED_ELEMENT
              ( ID, PARENT_PACKAGE_ID, NAME )
       VALUES ( 'e4c4a70A-a294-11e4-b20d-08002751500b', 'e4c4a700-a294-11e4-b20d-08002751500b', 'Asset Value Dollars' );
  INSERT INTO GRESTLER_ATTRIBUTE_TYPE
              ( ID )
       VALUES ( 'e4c4a70A-a294-11e4-b20d-08002751500b' );
  INSERT INTO GRESTLER_FLOAT64_ATTRIBUTE_TYPE
              ( ID, MIN_VALUE, MAX_VALUE )
       VALUES ( 'e4c4a70A-a294-11e4-b20d-08002751500b', 0.0, 1E10 );
  
  -- Attribute type "Address Count"
  INSERT INTO GRESTLER_DOCUMENTED_ELEMENT
              ( ID )
       VALUES ( 'e4c4a70C-a294-11e4-b20d-08002751500b' );
  INSERT INTO GRESTLER_PACKAGED_ELEMENT
              ( ID, PARENT_PACKAGE_ID, NAME )
       VALUES ( 'e4c4a70C-a294-11e4-b20d-08002751500b', 'e4c4a700-a294-11e4-b20d-08002751500b', 'Address Count' );
  INSERT INTO GRESTLER_ATTRIBUTE_TYPE
              ( ID )
       VALUES ( 'e4c4a70C-a294-11e4-b20d-08002751500b' );
  INSERT INTO GRESTLER_INTEGER32_ATTRIBUTE_TYPE
              ( ID, MIN_VALUE, MAX_VALUE )
       VALUES ( 'e4c4a70C-a294-11e4-b20d-08002751500b', 1, 10000 );
  
  -- Attribute type "UUID"
  INSERT INTO GRESTLER_DOCUMENTED_ELEMENT
              ( ID )
       VALUES ( 'e4c4a70E-a294-11e4-b20d-08002751500b' );
  INSERT INTO GRESTLER_PACKAGED_ELEMENT
              ( ID, PARENT_PACKAGE_ID, NAME )
       VALUES ( 'e4c4a70E-a294-11e4-b20d-08002751500b', 'e4c4a700-a294-11e4-b20d-08002751500b', 'UUID' );
  INSERT INTO GRESTLER_ATTRIBUTE_TYPE
              ( ID )
       VALUES ( 'e4c4a70E-a294-11e4-b20d-08002751500b' );
  INSERT INTO GRESTLER_UUID_ATTRIBUTE_TYPE
              ( ID )
       VALUES ( 'e4c4a70E-a294-11e4-b20d-08002751500b' );
  
  
  -- Vertex type "Person"
  INSERT INTO GRESTLER_DOCUMENTED_ELEMENT
              ( ID )
       VALUES ( 'e4c4a701-a294-11e4-b20d-08002751500b' );
  INSERT INTO GRESTLER_PACKAGED_ELEMENT
              ( ID, PARENT_PACKAGE_ID, NAME )
       VALUES ( 'e4c4a701-a294-11e4-b20d-08002751500b', 'e4c4a700-a294-11e4-b20d-08002751500b', 'Person' );
  INSERT INTO GRESTLER_VERTEX_TYPE
              ( ID, SUPER_TYPE_ID, IS_ABSTRACT )
       VALUES ( 'e4c4a701-a294-11e4-b20d-08002751500b', '00000010-7a26-11e4-a545-08002741a702', FALSE );
  
  INSERT INTO GRESTLER_DOCUMENTED_ELEMENT
              ( ID )
       VALUES ( 'e4c4a705-a294-11e4-b20d-08002751500b' );
  INSERT INTO GRESTLER_VERTEX_ATTRIBUTE_DECL
              ( ID, PARENT_VERTEX_TYPE_ID, NAME, ATTRIBUTE_TYPE_ID, IS_REQUIRED, IS_DEFAULT_LABEL )
       VALUES ( 'e4c4a705-a294-11e4-b20d-08002751500b', 'e4c4a701-a294-11e4-b20d-08002751500b',
                'Given Name', 'e4c4a704-a294-11e4-b20d-08002751500b', FALSE, TRUE );
  
  INSERT INTO GRESTLER_DOCUMENTED_ELEMENT
              ( ID )
       VALUES ( 'e4c4a706-a294-11e4-b20d-08002751500b' );
  INSERT INTO GRESTLER_VERTEX_ATTRIBUTE_DECL
              ( ID, PARENT_VERTEX_TYPE_ID, NAME, ATTRIBUTE_TYPE_ID, IS_REQUIRED, IS_DEFAULT_LABEL )
       VALUES ( 'e4c4a706-a294-11e4-b20d-08002751500b', 'e4c4a701-a294-11e4-b20d-08002751500b',
                'Surname', 'e4c4a704-a294-11e4-b20d-08002751500b', TRUE, FALSE );
  
  INSERT INTO GRESTLER_DOCUMENTED_ELEMENT
              ( ID )
       VALUES ( 'e4c4a70B-a294-11e4-b20d-08002751500b' );
  INSERT INTO GRESTLER_VERTEX_ATTRIBUTE_DECL
              ( ID, PARENT_VERTEX_TYPE_ID, NAME, ATTRIBUTE_TYPE_ID, IS_REQUIRED, IS_DEFAULT_LABEL )
       VALUES ( 'e4c4a70B-a294-11e4-b20d-08002751500b', 'e4c4a701-a294-11e4-b20d-08002751500b',
                'Current Assets', 'e4c4a70A-a294-11e4-b20d-08002751500b', FALSE, FALSE );
  
  INSERT INTO GRESTLER_DOCUMENTED_ELEMENT
              ( ID )
       VALUES ( 'e4c4a70D-a294-11e4-b20d-08002751500b' );
  INSERT INTO GRESTLER_VERTEX_ATTRIBUTE_DECL
              ( ID, PARENT_VERTEX_TYPE_ID, NAME, ATTRIBUTE_TYPE_ID, IS_REQUIRED, IS_DEFAULT_LABEL )
       VALUES ( 'e4c4a70D-a294-11e4-b20d-08002751500b', 'e4c4a701-a294-11e4-b20d-08002751500b',
                'Lifetime Address Count', 'e4c4a70C-a294-11e4-b20d-08002751500b', FALSE, FALSE );
  
  INSERT INTO GRESTLER_DOCUMENTED_ELEMENT
              ( ID )
       VALUES ( 'e4c4a70F-a294-11e4-b20d-08002751500b' );
  INSERT INTO GRESTLER_VERTEX_ATTRIBUTE_DECL
              ( ID, PARENT_VERTEX_TYPE_ID, NAME, ATTRIBUTE_TYPE_ID, IS_REQUIRED, IS_DEFAULT_LABEL )
       VALUES ( 'e4c4a70F-a294-11e4-b20d-08002751500b', 'e4c4a701-a294-11e4-b20d-08002751500b',
                'Person ID', 'e4c4a70E-a294-11e4-b20d-08002751500b', TRUE, FALSE );
  
  
  -- Edge Type "Has Father"
  INSERT INTO GRESTLER_DOCUMENTED_ELEMENT
              ( ID )
       VALUES ( 'e4c4a702-a294-11e4-b20d-08002751500b' );
  INSERT INTO GRESTLER_PACKAGED_ELEMENT
              ( ID, PARENT_PACKAGE_ID, NAME )
       VALUES ( 'e4c4a702-a294-11e4-b20d-08002751500b', 'e4c4a700-a294-11e4-b20d-08002751500b', 'Has Father' );
  INSERT INTO GRESTLER_EDGE_TYPE
              ( ID, SUPER_TYPE_ID, IS_ABSTRACT )
       VALUES ( 'e4c4a702-a294-11e4-b20d-08002751500b', '00000020-7a26-11e4-a545-08002741a702', FALSE );
  INSERT INTO GRESTLER_DIRECTED_EDGE_TYPE
              ( ID, TAIL_VERTEX_TYPE_ID, HEAD_VERTEX_TYPE_ID )
       VALUES ( 'e4c4a702-a294-11e4-b20d-08002751500b',
                'e4c4a701-a294-11e4-b20d-08002751500b', 'e4c4a701-a294-11e4-b20d-08002751500b' );
  
  
  -- Edge Type "Has Mother"
  INSERT INTO GRESTLER_DOCUMENTED_ELEMENT
              ( ID )
       VALUES ( 'e4c4a703-a294-11e4-b20d-08002751500b' );
  INSERT INTO GRESTLER_PACKAGED_ELEMENT
              ( ID, PARENT_PACKAGE_ID, NAME )
       VALUES ( 'e4c4a703-a294-11e4-b20d-08002751500b', 'e4c4a700-a294-11e4-b20d-08002751500b', 'Has Mother' );
  INSERT INTO GRESTLER_EDGE_TYPE
              ( ID, SUPER_TYPE_ID, IS_ABSTRACT )
       VALUES ( 'e4c4a703-a294-11e4-b20d-08002751500b', '00000020-7a26-11e4-a545-08002741a702', FALSE );
  INSERT INTO GRESTLER_DIRECTED_EDGE_TYPE
              ( ID, TAIL_VERTEX_TYPE_ID, HEAD_VERTEX_TYPE_ID )
       VALUES ( 'e4c4a703-a294-11e4-b20d-08002751500b',
                'e4c4a701-a294-11e4-b20d-08002751500b', 'e4c4a701-a294-11e4-b20d-08002751500b' );
  
  INSERT INTO GRESTLER_DOCUMENTED_ELEMENT
              ( ID )
       VALUES ( 'e4c4a709-a294-11e4-b20d-08002751500b' );
  INSERT INTO GRESTLER_EDGE_ATTRIBUTE_DECL
              ( ID, PARENT_EDGE_TYPE_ID, NAME, ATTRIBUTE_TYPE_ID, IS_REQUIRED )
       VALUES ( 'e4c4a709-a294-11e4-b20d-08002751500b', 'e4c4a703-a294-11e4-b20d-08002751500b',
                'Calls Weekly', 'e4c4a708-a294-11e4-b20d-08002751500b', FALSE );
  