text: 
  DROP TABLE IF EXISTS Association CASCADE;
  CREATE TABLE Association (
  --Identifiable Attributes
    id				VARCHAR(256) NOT NULL PRIMARY KEY,
    home                      VARCHAR(256),
  --RegistryObject Attributes
    lid				VARCHAR(256) NOT NULL,
    objectType		VARCHAR(256) CHECK (objectType = 'urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:Association'),
    status			VARCHAR(256) NOT NULL,
  
  --VersionInfo flattened
    versionName		VARCHAR(16),
    comment_		VARCHAR(256),
  
  --Association attributes
    associationType	VARCHAR(256) NOT NULL,
    sourceObject		VARCHAR(256) NOT NULL,
    targetObject  	VARCHAR(256) NOT NULL
  );
  ALTER TABLE Association OWNER TO openxds;
  
  DROP TABLE IF EXISTS AuditableEvent CASCADE;
  CREATE TABLE AuditableEvent (
  --Identifiable Attributes
    id				VARCHAR(256) NOT NULL PRIMARY KEY,
    home                      VARCHAR(256),
  --RegistryObject Attributes
    lid				VARCHAR(256) NOT NULL,
    objectType		VARCHAR(256) CHECK (objectType = 'urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:AuditableEvent'),
    status			VARCHAR(256) NOT NULL,
  
  --VersionInfo flattened
    versionName		VARCHAR(16),
    comment_		VARCHAR(256),
  
  --AuditableEvent attributes
    requestId             VARCHAR(256) NOT NULL,
    eventType			VARCHAR(256) NOT NULL,
    timeStamp_        VARCHAR(30) NOT NULL,
    user_				VARCHAR(256) NOT NULL
  );
  ALTER TABLE AuditableEvent OWNER TO openxds;
  
  DROP TABLE IF EXISTS AffectedObject CASCADE;
  CREATE TABLE AffectedObject (
  
  --Each row is a relationship between a RegistryObject and an AuditableEvent
  --Enables many-to-many relationship between effected RegistryObjects and AuditableEvents
    id                            VARCHAR(256) NOT NULL,
    home                      VARCHAR(256),
    eventId                   VARCHAR(256) NOT NULL,
  
    PRIMARY KEY (id, eventId)
  );
  ALTER TABLE AffectedObject OWNER TO openxds;
  
  DROP TABLE IF EXISTS repository CASCADE;
  CREATE TABLE repository
  (
    documentuniqueid character varying(255) NOT NULL PRIMARY KEY,
    mimetype character varying(255) NOT NULL,
    documentsize INT NOT NULL,
    hash character varying(255) NOT NULL,
    "content" bytea 
  );
  ALTER TABLE repository OWNER TO openxds;
  
  DROP TABLE IF EXISTS personidentifier CASCADE;
  CREATE TABLE personidentifier
  (
    registrypatientid character varying(255) NOT NULL PRIMARY KEY,
    assigningauthority character varying(255) NOT NULL,
    patientid character varying(255) NOT NULL, 
    deleted varchar(1),
    merged varchar(1),
    survivingpatientid character varying(255)  
  );
  ALTER TABLE personidentifier OWNER TO openxds;
  
  DROP TABLE IF EXISTS Classification CASCADE;
  CREATE TABLE Classification (
  --Identifiable Attributes
    id				VARCHAR(256) NOT NULL PRIMARY KEY,
    home                      VARCHAR(256),
  --RegistryObject Attributes
    lid				VARCHAR(256) NOT NULL,
    objectType		VARCHAR(256) CHECK (objectType = 'urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:Classification'),
    status			VARCHAR(256) NOT NULL,
  
  --VersionInfo flattened
    versionName		VARCHAR(16),
    comment_		VARCHAR(256),
  
  --Classfication attributes.
    classificationNode		VARCHAR(256),
    classificationScheme		VARCHAR(256),
    classifiedObject		VARCHAR(256) NOT NULL,
    nodeRepresentation		VARCHAR(256)
  );
  ALTER TABLE Classification OWNER TO openxds;
  
  DROP TABLE IF EXISTS ClassificationNode CASCADE;
  CREATE TABLE ClassificationNode (
  --Identifiable Attributes
    id				VARCHAR(256) NOT NULL PRIMARY KEY,
    home                      VARCHAR(256),
  --RegistryObject Attributes
    lid				VARCHAR(256) NOT NULL,
    objectType		VARCHAR(256) CHECK (objectType = 'urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode'),
    status			VARCHAR(256) NOT NULL,
  
  --VersionInfo flattened
    versionName		VARCHAR(16),
    comment_		VARCHAR(256),
  
  --ClassficationNode attributes
    code					VARCHAR(256),
    parent				VARCHAR(256),
    path					VARCHAR(1024)
  );
  ALTER TABLE ClassificationNode OWNER TO openxds;
  
  DROP TABLE IF EXISTS ClassScheme CASCADE;
  CREATE TABLE ClassScheme (
  --Identifiable Attributes
    id				VARCHAR(256) NOT NULL PRIMARY KEY,
    home                      VARCHAR(256),
  --RegistryObject Attributes
    lid				VARCHAR(256) NOT NULL,
    objectType		VARCHAR(256) CHECK (objectType = 'urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationScheme'),
    status			VARCHAR(256) NOT NULL,
  
  --VersionInfo flattened
    versionName		VARCHAR(16),
    comment_		VARCHAR(256),
  
  --ClassificationScheme attributes
    isInternal		VARCHAR(1) NOT NULL,
    nodeType		VARCHAR(256) NOT NULL
  );
  ALTER TABLE ClassScheme OWNER TO openxds;
  
  DROP TABLE IF EXISTS ExternalIdentifier CASCADE;
  CREATE TABLE ExternalIdentifier (
  --Identifiable Attributes
    id				VARCHAR(256) NOT NULL PRIMARY KEY,
    home                      VARCHAR(256),
  --RegistryObject Attributes
    lid				VARCHAR(256) NOT NULL,
    objectType		VARCHAR(256) CHECK (objectType = 'urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ExternalIdentifier'),
    status			VARCHAR(256) NOT NULL,
  
  --VersionInfo flattened
    versionName		VARCHAR(16),
    comment_		VARCHAR(256),
  
  --ExternalIdentifier attributes
    registryObject	VARCHAR(256) NOT NULL,
    identificationScheme		VARCHAR(256) NOT NULL,
    value				VARCHAR(256) NOT NULL
  );
  ALTER TABLE ExternalIdentifier OWNER TO openxds;
  
  DROP TABLE IF EXISTS ExternalLink CASCADE;
  CREATE TABLE ExternalLink (
    id				VARCHAR(256) NOT NULL PRIMARY KEY,
    home                      VARCHAR(256),
  --RegistryObject Attributes
    lid				VARCHAR(256) NOT NULL,
    objectType		VARCHAR(256),
    status			VARCHAR(256) NOT NULL,
  
  --VersionInfo flattened
    versionName		VARCHAR(16),
    comment_		VARCHAR(256),
  
  --ExternalLink attributes
    externalURI		VARCHAR(256) NOT NULL
  );
  ALTER TABLE ExternalLink OWNER TO openxds;
  
  DROP TABLE IF EXISTS ExtrinsicObject CASCADE;
  CREATE TABLE ExtrinsicObject (
    id				VARCHAR(256) NOT NULL PRIMARY KEY,
    home                      VARCHAR(256),
  --RegistryObject Attributes
    lid				VARCHAR(256) NOT NULL,
    objectType		VARCHAR(256),
    status			VARCHAR(256) NOT NULL,
  
  --VersionInfo flattened
    versionName		VARCHAR(16),
    comment_		VARCHAR(256),
  
  --ExtrinsicObject attributes
    isOpaque			VARCHAR(1) NOT NULL,
    mimeType			VARCHAR(256),
  
  --contentVersionInfo flattened
    contentVersionName		VARCHAR(16),
    contentVersionComment	VARCHAR(256)
  
  );
  ALTER TABLE ExtrinsicObject OWNER TO openxds;
  
  DROP TABLE IF EXISTS Federation CASCADE;
  CREATE TABLE Federation (
    id				VARCHAR(256) NOT NULL PRIMARY KEY,
    home                      VARCHAR(256),
  --RegistryObject Attributes
    lid				VARCHAR(256) NOT NULL,
    objectType		VARCHAR(256) CHECK (objectType = 'urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:Federation'),
    status			VARCHAR(256) NOT NULL,
  
  --VersionInfo flattened
    versionName		VARCHAR(16),
    comment_		VARCHAR(256),
  
  --Federation attributes: currently none defined
  --xsd:duration stored in string form since no corresponding SQL type. Is 32 long enough?
    replicationSyncLatency    VARCHAR(32)
  );
  ALTER TABLE Federation OWNER TO openxds;
  
  DROP TABLE IF EXISTS Name_ CASCADE;
  CREATE TABLE Name_ (
  --LocalizedString attributes flattened for Name
    charset			VARCHAR(32),
    lang				VARCHAR(32) NOT NULL,
    value				VARCHAR(1024) NOT NULL,
  --The RegistryObject id for the parent RegistryObject for which this is a Name
    parent			VARCHAR(256) NOT NULL,
    PRIMARY KEY (parent, lang)
  );
  ALTER TABLE Name_ OWNER TO openxds;
  
  DROP TABLE IF EXISTS Description CASCADE;
  CREATE TABLE Description (
  --LocalizedString attributes flattened for Description
    charset			VARCHAR(32),
    lang				VARCHAR(32) NOT NULL,
    value				VARCHAR(1024) NOT NULL,
  --The RegistryObject id for the parent RegistryObject for which this is a Name
    parent			VARCHAR(256) NOT NULL,
    PRIMARY KEY (parent, lang)
  );
  ALTER TABLE Description OWNER TO openxds;
  
  DROP TABLE IF EXISTS UsageDescription CASCADE;
  CREATE TABLE UsageDescription (
  --LocalizedString attributes flattened for UsageDescription
    charset			VARCHAR(32),
    lang				VARCHAR(32) NOT NULL,
    value				VARCHAR(1024) NOT NULL,
  --The RegistryObject id for the parent RegistryObject for which this is a Name
    parent			VARCHAR(256) NOT NULL,
    PRIMARY KEY (parent, lang)
  );
  ALTER TABLE UsageDescription OWNER TO openxds;
  
  DROP TABLE IF EXISTS ObjectRef CASCADE;
  CREATE TABLE ObjectRef (
  --Stores remote ObjectRefs only
  --Identifiable Attributes
    id				VARCHAR(256) NOT NULL PRIMARY KEY,
    home                          VARCHAR(256)
  );
  ALTER TABLE ObjectRef OWNER TO openxds;
  
  DROP TABLE IF EXISTS Organization CASCADE;
  CREATE TABLE Organization (
    id				VARCHAR(256) NOT NULL PRIMARY KEY,
    home                      VARCHAR(256),
  --RegistryObject Attributes
    lid				VARCHAR(256) NOT NULL,
    objectType		VARCHAR(256) CHECK (objectType = 'urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:Organization'),
    status			VARCHAR(256) NOT NULL,
  
  --VersionInfo flattened
    versionName		VARCHAR(16),
    comment_		VARCHAR(256),
  
  --Organization attributes
  --Organization.address attribute is in PostalAddress table
    parent			VARCHAR(256),
  --primary contact for Organization, points to a User.
    primaryContact	VARCHAR(256)
  --Organization.telephoneNumbers attribute is in TelephoneNumber table
  );
  ALTER TABLE Organization OWNER TO openxds;
  
  DROP TABLE IF EXISTS RegistryPackage CASCADE;
  CREATE TABLE RegistryPackage (
    id				VARCHAR(256) NOT NULL PRIMARY KEY,
    home                      VARCHAR(256),
  --RegistryObject Attributes
    lid				VARCHAR(256) NOT NULL,
    objectType		VARCHAR(256) CHECK (objectType = 'urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:RegistryPackage'),
    status			VARCHAR(256) NOT NULL,
  
  --VersionInfo flattened
    versionName		VARCHAR(16),
    comment_		VARCHAR(256)
  
  --RegistryPackage attributes: currently none defined
  );
  ALTER TABLE RegistryPackage OWNER TO openxds;
  
  DROP TABLE IF EXISTS PostalAddress CASCADE;
  CREATE TABLE PostalAddress (
    city				VARCHAR(64),
    country			VARCHAR(64),
    postalCode		VARCHAR(64),
    state				VARCHAR(64),
    street			VARCHAR(64),
    streetNumber		VARCHAR(32),
  --The parent object that this is an address for
    parent			VARCHAR(256) NOT NULL
  );
  ALTER TABLE PostalAddress OWNER TO openxds;
  
  DROP TABLE IF EXISTS EmailAddress CASCADE;
  CREATE TABLE EmailAddress (
    address			VARCHAR(64) NOT NULL,
    type				VARCHAR(256),
  --The parent object that this is an email address for
    parent			VARCHAR(256) NOT NULL
  );
  ALTER TABLE EmailAddress OWNER TO openxds;
  
  DROP TABLE IF EXISTS Registry CASCADE;
  CREATE TABLE Registry (
    id				VARCHAR(256) NOT NULL PRIMARY KEY,
    home                      VARCHAR(256),
  --RegistryObject Attributes
    lid				VARCHAR(256) NOT NULL,
    objectType		VARCHAR(256) CHECK (objectType = 'urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:Registry'),
    status		VARCHAR(256) NOT NULL,
  
  --VersionInfo flattened
    versionName		VARCHAR(16),
    comment_		VARCHAR(256),
  
  --Registry attributes
  --xsd:duration stored in string form since no corresponding SQL type. Is 32 long enough?
    catalogingSyncLatency    VARCHAR(32) DEFAULT 'P1D',
    conformanceProfile      VARCHAR(16),
    operator  VARCHAR(256) NOT NULL,
  
  --xsd:duration stored in string form since no corresponding SQL type. Is 32 long enough?
    replicationSyncLatency    VARCHAR(32) DEFAULT 'P1D',
    specificationVersion    VARCHAR(8) NOT NULL
  );
  ALTER TABLE Registry OWNER TO openxds;
  
  DROP TABLE IF EXISTS Service CASCADE;
  CREATE TABLE Service (
    id			VARCHAR(256) NOT NULL PRIMARY KEY,
    home                  VARCHAR(256),
  --RegistryObject Attributes
    lid				VARCHAR(256) NOT NULL,
    objectType		VARCHAR(256) CHECK (objectType = 'urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:Service'),
    status			VARCHAR(256) NOT NULL,
  
  --VersionInfo flattened
    versionName		VARCHAR(16),
    comment_		VARCHAR(256)
  
  --Service attributes: currently none defined
  );
  ALTER TABLE Service OWNER TO openxds;
  
  DROP TABLE IF EXISTS ServiceBinding CASCADE;
  CREATE TABLE ServiceBinding (
    id			VARCHAR(256) NOT NULL PRIMARY KEY,
    home                  VARCHAR(256),
  --RegistryObject Attributes
    lid				VARCHAR(256) NOT NULL,
    objectType		VARCHAR(256) CHECK (objectType = 'urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ServiceBinding'),
    status			VARCHAR(256) NOT NULL,
  
  --VersionInfo flattened
    versionName		VARCHAR(16),
    comment_		VARCHAR(256),
  
  --ServiceBinding attributes
    service			VARCHAR(256) NOT NULL,
    accessURI			VARCHAR(256),
    targetBinding		VARCHAR(256)
  );
  ALTER TABLE ServiceBinding OWNER TO openxds;
  
  DROP TABLE IF EXISTS Slot CASCADE;
  CREATE TABLE Slot (
  --Multiple rows of Slot make up a single Slot
    sequenceId		INT NOT NULL,
    name_				VARCHAR(256) NOT NULL,
    slotType			VARCHAR(256),
    value				VARCHAR(256),
  --The parent RegistryObject that this is a Slot for
    parent			VARCHAR(256) NOT NULL,
    PRIMARY KEY (parent, name_, sequenceId)
  );
  ALTER TABLE Slot OWNER TO openxds;
  
  DROP TABLE IF EXISTS SpecificationLink CASCADE;
  CREATE TABLE SpecificationLink (
    id			VARCHAR(256) NOT NULL PRIMARY KEY,
    home                  VARCHAR(256),
  --RegistryObject Attributes
    lid				VARCHAR(256) NOT NULL,
    objectType		VARCHAR(256) CHECK (objectType = 'urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:SpecificationLink'),
    status			VARCHAR(256) NOT NULL,
  
  --VersionInfo flattened
    versionName		VARCHAR(16),
    comment_		VARCHAR(256),
  
  --SpecificationLink attributes
    serviceBinding	VARCHAR(256) NOT NULL,
    specificationObject VARCHAR(256) NOT NULL
  );
  ALTER TABLE SpecificationLink OWNER TO openxds;
  
  DROP TABLE IF EXISTS Subscription CASCADE;
  CREATE TABLE Subscription (
    id			VARCHAR(256) NOT NULL PRIMARY KEY,
    home                  VARCHAR(256),
  --RegistryObject Attributes
    lid				VARCHAR(256) NOT NULL,
    objectType		VARCHAR(256) CHECK (objectType = 'urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:Subscription'),
    status			VARCHAR(256) NOT NULL,
  
  --VersionInfo flattened
    versionName		VARCHAR(16),
    comment_		VARCHAR(256),
  
  --Subscription attributes
    selector              VARCHAR(256) NOT NULL,
    endTime               VARCHAR(30),
  
  --xsd:duration stored in string form since no corresponding SQL type. Is 32 long enough?
    notificationInterval  VARCHAR(32) DEFAULT 'P1D',
    startTime             VARCHAR(30)
  );
  ALTER TABLE Subscription OWNER TO openxds;
  
  DROP TABLE IF EXISTS NotifyAction CASCADE;
  CREATE TABLE NotifyAction (
    notificationOption       VARCHAR(256) NOT NULL,
  
  --Either a ref to a Service, a String representing an email address in form: mailto:user@server,
  --or a String representing an http URLin form: http://url
    endPoint                    VARCHAR(256) NOT NULL,
  
  --Parent Subscription reference
    parent			VARCHAR(256) NOT NULL
  );
  ALTER TABLE NotifyAction OWNER TO openxds;
  
  DROP TABLE IF EXISTS Notification CASCADE;
  CREATE TABLE Notification (
    id				VARCHAR(256) NOT NULL PRIMARY KEY,
    home                      VARCHAR(256),
  --RegistryObject Attributes
    lid				VARCHAR(256) NOT NULL,
    objectType		VARCHAR(256) CHECK (objectType = 'urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:Notification'),
    status		VARCHAR(256) NOT NULL,
  
  --VersionInfo flattened
    versionName		VARCHAR(16),
    comment_		VARCHAR(256),
  
  --Notification attributes
    subscription        VARCHAR(256) NOT NULL
  );
  ALTER TABLE Notification OWNER TO openxds;
  
  DROP TABLE IF EXISTS NotificationObject CASCADE;
  CREATE TABLE NotificationObject (
  
  --Each row is a relationship between a RegistryObject and a Notification
  --Enables a Notification to have multiple RegistryObjects
    notificationId             VARCHAR(256) NOT NULL,
    registryObjectId           VARCHAR(256) NOT NULL,
  
    PRIMARY KEY (notificationId, registryObjectId)
  );
  ALTER TABLE NotificationObject OWNER TO openxds;
  
  DROP TABLE IF EXISTS AdhocQuery CASCADE;
  CREATE TABLE AdhocQuery (
    id			VARCHAR(256) NOT NULL PRIMARY KEY,
    home                  VARCHAR(256),
  --RegistryObject Attributes
    lid				VARCHAR(256) NOT NULL,
    objectType		VARCHAR(256) CHECK (objectType = 'urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:AdhocQuery'),
    status			VARCHAR(256) NOT NULL,
  
  --VersionInfo flattened
    versionName		VARCHAR(16),
    comment_		VARCHAR(256),
  
  --AdhocQuery attributes. Flattend QueryExpression attributes
    queryLanguage		VARCHAR(256) NOT NULL,
    query			VARCHAR(4096) NOT NULL
  );
  ALTER TABLE AdhocQuery OWNER TO openxds;
  
  DROP TABLE IF EXISTS UsageParameter CASCADE;
  CREATE TABLE UsageParameter (
    value				VARCHAR(1024) NOT NULL,
  --The parent SpecificationLink that this is a usage parameter for
    parent			VARCHAR(256) NOT NULL
  );
  ALTER TABLE UsageParameter OWNER TO openxds;
  
  DROP TABLE IF EXISTS TelephoneNumber CASCADE;
  CREATE TABLE TelephoneNumber (
    areaCode			VARCHAR(8),
    countryCode		VARCHAR(8),
    extension			VARCHAR(8),
    -- we use "number_" instead of number, which is reserved in Oracle
    number_			VARCHAR(16),
    phoneType			VARCHAR(256),
    parent			VARCHAR(256) NOT NULL
  );
  ALTER TABLE TelephoneNumber OWNER TO openxds;
  
  DROP TABLE IF EXISTS User_ CASCADE;
  CREATE TABLE User_ (
    id			VARCHAR(256) NOT NULL PRIMARY KEY,
    home                  VARCHAR(256),
  --RegistryObject Attributes
    lid				VARCHAR(256) NOT NULL,
    objectType		VARCHAR(256) CHECK (objectType = 'urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:Person:User'),
    status			VARCHAR(256) NOT NULL,
  
  --VersionInfo flattened
    versionName		VARCHAR(16),
    comment_		VARCHAR(256),
  
  --User attributes
  --address is in PostalAddress table
  --email is in EMailAddress table
  --personName flattened
    personName_firstName	VARCHAR(64),
    personName_middleName	VARCHAR(64),
    personName_lastName	VARCHAR(64)
  --telephoneNumbers is in TelephoneNumber table
  );
  ALTER TABLE User_ OWNER TO openxds;
  
  DROP TABLE IF EXISTS Person CASCADE;
  CREATE TABLE Person (
    id			VARCHAR(256) NOT NULL PRIMARY KEY,
    home                  VARCHAR(256),
  --RegistryObject Attributes
    lid				VARCHAR(256) NOT NULL,
    objectType		VARCHAR(256) CHECK (objectType = 'urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:Person'),
    status			VARCHAR(256) NOT NULL,
  
  --VersionInfo flattened
    versionName		VARCHAR(16),
    comment_		VARCHAR(256),
  
  --User attributes
  --address is in PostalAddress table
  --email is in EMailAddress table
  --personName flattened
    personName_firstName	VARCHAR(64),
    personName_middleName	VARCHAR(64),
    personName_lastName	VARCHAR(64)
  --telephoneNumbers is in TelephoneNumber table
  );
  ALTER TABLE Person OWNER TO openxds;
  
  DROP TABLE IF EXISTS RepositoryItem CASCADE;
  CREATE TABLE RepositoryItem
  (
    lid character varying(256) NOT NULL,
    versionname character varying(16) NOT NULL,
    "content" bytea, 
    PRIMARY KEY(lid, versionname)
  );
  ALTER TABLE RepositoryItem OWNER TO openxds;
  
  DROP VIEW IF EXISTS Identifiable CASCADE;
  CREATE VIEW Identifiable (
  --Identifiable Attributes
    id,
    home
  ) AS
   SELECT
  --Identifiable Attributes
    id,
    home
   FROM AdhocQuery
   UNION ALL
   SELECT
  --Identifiable Attributes
    id,
    home
   FROM Association
   UNION ALL
   SELECT
  --Identifiable Attributes
    id,
    home
   FROM AuditableEvent
   UNION ALL
   SELECT
  --Identifiable Attributes
    id,
    home
   FROM Classification
   UNION ALL
   SELECT
  --Identifiable Attributes
    id,
    home
   FROM ClassificationNode
   UNION ALL
   SELECT
  --Identifiable Attributes
    id,
    home
   FROM ClassScheme
   UNION ALL
   SELECT
  --Identifiable Attributes
    id,
    home
   FROM ExternalIdentifier
   UNION ALL
   SELECT
  --Identifiable Attributes
    id,
    home
   FROM ExternalLink
   UNION ALL
   SELECT
  --Identifiable Attributes
    id,
    home
   FROM ExtrinsicObject
   UNION ALL
   SELECT
  --Identifiable Attributes
    id,
    home
   FROM Federation
   UNION ALL
   SELECT
  --Identifiable Attributes
    id,
    home
   FROM Organization
   UNION ALL
   SELECT
  --Identifiable Attributes
    id,
    home
   FROM Registry
   UNION ALL
   SELECT
  --Identifiable Attributes
    id,
    home
   FROM RegistryPackage
   UNION ALL
   SELECT
  --Identifiable Attributes
    id,
    home
   FROM Service
   UNION ALL
   SELECT
  --Identifiable Attributes
    id,
    home
   FROM ServiceBinding
   UNION ALL
   SELECT
  --Identifiable Attributes
    id,
    home
   FROM SpecificationLink
   UNION ALL
   SELECT
  --Identifiable Attributes
    id,
    home
   FROM Subscription
   UNION ALL
   SELECT
  --Identifiable Attributes
    id,
    home
   FROM User_
   UNION ALL
   SELECT
  --Identifiable Attributes
    id,
    home
   FROM Person
   UNION ALL
   SELECT
  --Identifiable Attributes
    id,
    home
   FROM ObjectRef
  ;
  ALTER TABLE Identifiable OWNER TO openxds;
  
  DROP VIEW IF EXISTS RegistryObject CASCADE;
  CREATE VIEW RegistryObject (
  --Identifiable Attributes
    id,
    home,
  --RegistryObject Attributes
    lid,
    objectType,
    status,
  --VersionInfo flattened
    versionName,
    comment_
  ) AS
   SELECT
  --Identifiable Attributes
    id,
    home,
  --RegistryObject Attributes
    lid,
    objectType,
    status,
  --VersionInfo flattened
    versionName,
    comment_
   FROM AdhocQuery
   UNION ALL
   SELECT
  --Identifiable Attributes
    id,
    home,
  --RegistryObject Attributes
    lid,
    objectType,
    status,
  --VersionInfo flattened
    versionName,
    comment_
   FROM Association
   UNION ALL
   SELECT
  --Identifiable Attributes
    id,
    home,
  --RegistryObject Attributes
    lid,
    objectType,
    status,
  --VersionInfo flattened
    versionName,
    comment_
   FROM AuditableEvent
   UNION ALL
   SELECT
  --Identifiable Attributes
    id,
    home,
  --RegistryObject Attributes
    lid,
    objectType,
    status,
  --VersionInfo flattened
    versionName,
    comment_
   FROM Classification
   UNION ALL
   SELECT
  --Identifiable Attributes
    id,
    home,
  --RegistryObject Attributes
    lid,
    objectType,
    status,
  --VersionInfo flattened
    versionName,
    comment_
   FROM ClassificationNode
   UNION ALL
   SELECT
  --Identifiable Attributes
    id,
    home,
  --RegistryObject Attributes
    lid,
    objectType,
    status,
  --VersionInfo flattened
    versionName,
    comment_
   FROM ClassScheme
   UNION ALL
   SELECT
  --Identifiable Attributes
    id,
    home,
  --RegistryObject Attributes
    lid,
    objectType,
    status,
  --VersionInfo flattened
    versionName,
    comment_
   FROM ExternalIdentifier
   UNION ALL
   SELECT
  --Identifiable Attributes
    id,
    home,
  --RegistryObject Attributes
    lid,
    objectType,
    status,
  --VersionInfo flattened
    versionName,
    comment_
   FROM ExternalLink
   UNION ALL
   SELECT
  --Identifiable Attributes
    id,
    home,
  --RegistryObject Attributes
    lid,
    objectType,
    status,
  --VersionInfo flattened
    versionName,
    comment_
   FROM ExtrinsicObject
   UNION ALL
   SELECT
  --Identifiable Attributes
    id,
    home,
  --RegistryObject Attributes
    lid,
    objectType,
    status,
  --VersionInfo flattened
    versionName,
    comment_
   FROM Federation
   UNION ALL
   SELECT
  --Identifiable Attributes
    id,
    home,
  --RegistryObject Attributes
    lid,
    objectType,
    status,
  --VersionInfo flattened
    versionName,
    comment_
   FROM Organization
   UNION ALL
   SELECT
  --Identifiable Attributes
    id,
    home,
  --RegistryObject Attributes
    lid,
    objectType,
    status,
  --VersionInfo flattened
    versionName,
    comment_
   FROM Registry
   UNION ALL
   SELECT
  --Identifiable Attributes
    id,
    home,
  --RegistryObject Attributes
    lid,
    objectType,
    status,
  --VersionInfo flattened
    versionName,
    comment_
   FROM RegistryPackage
   UNION ALL
   SELECT
  --Identifiable Attributes
    id,
    home,
  --RegistryObject Attributes
    lid,
    objectType,
    status,
  --VersionInfo flattened
    versionName,
    comment_
   FROM Service
   UNION ALL
   SELECT
  --Identifiable Attributes
    id,
    home,
  --RegistryObject Attributes
    lid,
    objectType,
    status,
  --VersionInfo flattened
    versionName,
    comment_
   FROM ServiceBinding
   UNION ALL
   SELECT
  --Identifiable Attributes
    id,
    home,
  --RegistryObject Attributes
    lid,
    objectType,
    status,
  --VersionInfo flattened
    versionName,
    comment_
   FROM SpecificationLink
   UNION ALL
   SELECT
  --Identifiable Attributes
    id,
    home,
  --RegistryObject Attributes
    lid,
    objectType,
    status,
  --VersionInfo flattened
    versionName,
    comment_
   FROM Subscription
   UNION ALL
   SELECT
  --Identifiable Attributes
    id,
    home,
  --RegistryObject Attributes
    lid,
    objectType,
    status,
  --VersionInfo flattened
    versionName,
    comment_
   FROM User_
   UNION ALL
   SELECT
  --Identifiable Attributes
    id,
    home,
  --RegistryObject Attributes
    lid,
    objectType,
    status,
  --VersionInfo flattened
    versionName,
    comment_
   FROM Person
  ;
  ALTER TABLE RegistryObject OWNER TO openxds;
  
  
  --All index definitions are non-normative
  
  ---
  -- FOR ORACLE, YOU MUST COMMMENT ALL THE FOLLOWING LINES BECAUSE ORACLE DOES
  -- NOT ALLOW CREATE INDEX ON PRIMARY KEYS
  --
  
  --lid index
  DROP INDEX IF EXISTS lid_AdhQuery_idx;
  DROP INDEX IF EXISTS lid_Assoc_idx;
  DROP INDEX IF EXISTS lid_AUEVENT_idx;
  DROP INDEX IF EXISTS lid_Class_idx;
  DROP INDEX IF EXISTS lid_Node_idx;
  DROP INDEX IF EXISTS lid_SCHEME_idx;
  DROP INDEX IF EXISTS lid_EID_idx;
  DROP INDEX IF EXISTS lid_ExLink_idx;
  DROP INDEX IF EXISTS lid_EXTOBJ_idx;
  DROP INDEX IF EXISTS lid_FED_idx;
  DROP INDEX IF EXISTS lid_ORG_idx;
  DROP INDEX IF EXISTS lid_Registry_idx;
  DROP INDEX IF EXISTS lid_PKG_idx;
  DROP INDEX IF EXISTS lid_Service_idx;
  DROP INDEX IF EXISTS lid_BIND_idx;
  DROP INDEX IF EXISTS lid_SLnk_idx;
  DROP INDEX IF EXISTS lid_SUBS_idx;
  DROP INDEX IF EXISTS lid_User_idx;
  DROP INDEX IF EXISTS lid_Person_idx;
  
  CREATE INDEX lid_AdhQuery_idx ON AdhocQuery(lid);
  CREATE INDEX lid_Assoc_idx ON Association(lid);
  CREATE INDEX lid_AUEVENT_idx ON AuditableEvent(lid);
  CREATE INDEX lid_Class_idx ON Classification(lid);
  CREATE INDEX lid_Node_idx ON ClassificationNode(lid);
  CREATE INDEX lid_SCHEME_idx ON ClassScheme(lid);
  CREATE INDEX lid_EID_idx ON ExternalIdentifier(lid);
  CREATE INDEX lid_ExLink_idx ON ExternalLink(lid);
  CREATE INDEX lid_EXTOBJ_idx ON ExtrinsicObject(lid);
  CREATE INDEX lid_FED_idx ON Federation(lid);
  CREATE INDEX lid_ORG_idx ON Organization(lid);
  CREATE INDEX lid_Registry_idx ON Registry(lid);
  CREATE INDEX lid_PKG_idx ON RegistryPackage(lid);
  CREATE INDEX lid_Service_idx ON Service(lid);
  CREATE INDEX lid_BIND_idx ON ServiceBinding(lid);
  CREATE INDEX lid_SLnk_idx ON SpecificationLink(lid);
  CREATE INDEX lid_SUBS_idx ON Subscription(lid);
  CREATE INDEX lid_User_idx ON User_(lid);
  CREATE INDEX lid_Person_idx ON Person(lid);
  
  --id index
  DROP INDEX IF EXISTS id_AdhQuery_idx;
  DROP INDEX IF EXISTS id_Assoc_idx;
  DROP INDEX IF EXISTS id_AUEVENT_idx;
  DROP INDEX IF EXISTS id_Class_idx;
  DROP INDEX IF EXISTS id_Node_idx;
  DROP INDEX IF EXISTS id_SCHEME_idx;
  DROP INDEX IF EXISTS id_EID_idx;
  DROP INDEX IF EXISTS id_ExLink_idx;
  DROP INDEX IF EXISTS id_EXTOBJ_idx;
  DROP INDEX IF EXISTS id_FED_idx;
  DROP INDEX IF EXISTS id_ObjectRef_idx;
  DROP INDEX IF EXISTS id_ORG_idx;
  DROP INDEX IF EXISTS id_Registry_idx;
  DROP INDEX IF EXISTS id_PKG_idx;
  DROP INDEX IF EXISTS id_Service_idx;
  DROP INDEX IF EXISTS id_BIND_idx;
  DROP INDEX IF EXISTS id_SLnk_idx;
  DROP INDEX IF EXISTS id_SUBS_idx;
  DROP INDEX IF EXISTS id_User_idx;
  DROP INDEX IF EXISTS id_Person_idx;
  
  CREATE INDEX id_AdhQuery_idx ON AdhocQuery(id);
  CREATE INDEX id_Assoc_idx ON Association(id);
  CREATE INDEX id_AUEVENT_idx ON AuditableEvent(id);
  CREATE INDEX id_Class_idx ON Classification(id);
  CREATE INDEX id_Node_idx ON ClassificationNode(id);
  CREATE INDEX id_SCHEME_idx ON ClassScheme(id);
  CREATE INDEX id_EID_idx ON ExternalIdentifier(id);
  CREATE INDEX id_ExLink_idx ON ExternalLink(id);
  CREATE INDEX id_EXTOBJ_idx ON ExtrinsicObject(id);
  CREATE INDEX id_FED_idx ON Federation(id);
  CREATE INDEX id_ObjectRef_idx ON ObjectRef(id);
  CREATE INDEX id_ORG_idx ON Organization(id);
  CREATE INDEX id_Registry_idx ON Registry(id);
  CREATE INDEX id_PKG_idx ON RegistryPackage(id);
  CREATE INDEX id_Service_idx ON Service(id);
  CREATE INDEX id_BIND_idx ON ServiceBinding(id);
  CREATE INDEX id_SLnk_idx ON SpecificationLink(id);
  CREATE INDEX id_SUBS_idx ON Subscription(id);
  CREATE INDEX id_User_idx ON User_(id);
  CREATE INDEX id_Person_idx ON Person(id);
  
  
  --home index
  DROP INDEX IF EXISTS home_AdhQuery_idx;
  DROP INDEX IF EXISTS home_Assoc_idx;
  DROP INDEX IF EXISTS home_AUEVENT_idx;
  DROP INDEX IF EXISTS home_Class_idx;
  DROP INDEX IF EXISTS home_Node_idx;
  DROP INDEX IF EXISTS home_SCHEME_idx;
  DROP INDEX IF EXISTS home_EID_idx;
  DROP INDEX IF EXISTS home_ExLink_idx;
  DROP INDEX IF EXISTS home_EXTOBJ_idx;
  DROP INDEX IF EXISTS home_FED_idx;
  DROP INDEX IF EXISTS home_ORG_idx;
  DROP INDEX IF EXISTS home_Registry_idx;
  DROP INDEX IF EXISTS home_PKG_idx;
  DROP INDEX IF EXISTS home_Service_idx;
  DROP INDEX IF EXISTS home_BIND_idx;
  DROP INDEX IF EXISTS home_SLnk_idx;
  DROP INDEX IF EXISTS home_SUBS_idx;
  DROP INDEX IF EXISTS home_User_idx;
  DROP INDEX IF EXISTS home_Person_idx;
  
  CREATE INDEX home_AdhQuery_idx ON AdhocQuery(home);
  CREATE INDEX home_Assoc_idx ON Association(home);
  CREATE INDEX home_AUEVENT_idx ON AuditableEvent(home);
  CREATE INDEX home_Class_idx ON Classification(home);
  CREATE INDEX home_Node_idx ON ClassificationNode(home);
  CREATE INDEX home_SCHEME_idx ON ClassScheme(home);
  CREATE INDEX home_EID_idx ON ExternalIdentifier(home);
  CREATE INDEX home_ExLink_idx ON ExternalLink(home);
  CREATE INDEX home_EXTOBJ_idx ON ExtrinsicObject(home);
  CREATE INDEX home_FED_idx ON Federation(home);
  CREATE INDEX home_ORG_idx ON Organization(home);
  CREATE INDEX home_Registry_idx ON Registry(home);
  CREATE INDEX home_PKG_idx ON RegistryPackage(home);
  CREATE INDEX home_Service_idx ON Service(home);
  CREATE INDEX home_BIND_idx ON ServiceBinding(home);
  CREATE INDEX home_SLnk_idx ON SpecificationLink(home);
  CREATE INDEX home_SUBS_idx ON Subscription(home);
  CREATE INDEX home_User_idx ON User_(home);
  CREATE INDEX home_Person_idx ON Person(home);
  
  DROP INDEX IF EXISTS id_evId_AFOBJ_idx;
  CREATE INDEX id_evId_AFOBJ_idx ON AffectedObject(id, eventId);
  
  --
  -- Following indexes should be OK to use in all databases
  --
  
  --index on AffectedObject
  DROP INDEX IF EXISTS id_AFOBJ_idx;
  DROP INDEX IF EXISTS evid_AFOBJ_idx;
  CREATE INDEX id_AFOBJ_idx ON AffectedObject(id);
  CREATE INDEX evid_AFOBJ_idx ON AffectedObject(eventid);
  
  
  --index on AuditableEvent
  CREATE INDEX lid_AUEVENT_evtTyp ON AuditableEvent(eventType);
  
  --name index
  DROP INDEX IF EXISTS value_Name_idx;
  DROP INDEX IF EXISTS lngval_Name_idx;
  CREATE INDEX value_Name_idx ON Name_(value);
  CREATE INDEX lngval_Name_idx ON Name_(lang, value);
  
  --description index
  DROP INDEX IF EXISTS value_Desc_idx;
  DROP INDEX IF EXISTS lngval_Desc_idx;
  CREATE INDEX value_Desc_idx ON Description(value);
  CREATE INDEX lngval_Desc_idx ON Description(lang, value);
  
  --UsageDesc index
  DROP INDEX IF EXISTS value_UsgDes_idx;
  DROP INDEX IF EXISTS lngval_UsgDes_idx;
  CREATE INDEX value_UsgDes_idx ON UsageDescription(value);
  CREATE INDEX lngval_UsgDes_idx ON UsageDescription(lang, value);
  
  
  --Indexes on Assoc
  DROP INDEX IF EXISTS src_Ass_idx;
  DROP INDEX IF EXISTS tgt_Ass_idx;
  DROP INDEX IF EXISTS type_Ass_idx;
  CREATE INDEX src_Ass_idx ON Association(sourceObject);
  CREATE INDEX tgt_Ass_idx ON Association(targetObject);
  CREATE INDEX type_Ass_idx ON Association(associationType);
  
  
  --Indexes on Class
  DROP INDEX IF EXISTS clsObj_Class_idx;
  DROP INDEX IF EXISTS node_Class_idx;
  CREATE INDEX clsObj_Class_idx ON Classification(classifiedObject);
  CREATE INDEX node_Class_idx ON Classification(classificationNode);
  
  
  --Indexes on ClassNode
  DROP INDEX IF EXISTS parent_Node_idx;
  DROP INDEX IF EXISTS code_Node_idx;
  DROP INDEX IF EXISTS path_Node_idx;
  CREATE INDEX parent_Node_idx ON ClassificationNode(parent);
  CREATE INDEX code_Node_idx ON ClassificationNode(code);
  CREATE INDEX path_Node_idx ON ClassificationNode(path);
  
  --Indexes on ExIdentifier
  DROP INDEX IF EXISTS ro_EID_idx;
  CREATE INDEX ro_EID_idx ON ExternalIdentifier(registryObject);
  
  
  --Indexes on ExLink
  DROP INDEX IF EXISTS uri_ExLink_idx;
  CREATE INDEX uri_ExLink_idx ON ExternalLink(externalURI);
  
  
  --Indexes on ExtrinsicObject
  
  --Indexes on Organization
  DROP INDEX IF EXISTS parent_ORG_idx;
  CREATE INDEX parent_ORG_idx ON Organization(parent);
  
  
  --Indexes on PostalAddress
  DROP INDEX IF EXISTS parent_PstlAdr_idx;
  DROP INDEX IF EXISTS city_PstlAdr_idx;
  DROP INDEX IF EXISTS cntry_PstlAdr_idx;
  DROP INDEX IF EXISTS pCode_PstlAdr_idx;
  CREATE INDEX parent_PstlAdr_idx ON PostalAddress(parent);
  CREATE INDEX city_PstlAdr_idx ON PostalAddress(city);
  CREATE INDEX cntry_PstlAdr_idx ON PostalAddress(country);
  CREATE INDEX pCode_PstlAdr_idx ON PostalAddress(postalCode);
  
  --Indexes on EmailAddress
  DROP INDEX IF EXISTS parent_EmlAdr_idx;
  CREATE INDEX parent_EmlAdr_idx ON EmailAddress(parent);
  
  
  --Indexes on ServiceBinding
  DROP INDEX IF EXISTS service_BIND_idx;
  CREATE INDEX service_BIND_idx ON ServiceBinding(service);
  
  
  --Indexes on Slot
  DROP INDEX IF EXISTS parent_Slot_idx;
  DROP INDEX IF EXISTS name_Slot_idx;
  CREATE INDEX parent_Slot_idx ON Slot(parent);
  CREATE INDEX name_Slot_idx ON Slot(name_);
  
  --Indexes on SpecLink
  DROP INDEX IF EXISTS binding_SLnk_idx;
  DROP INDEX IF EXISTS spec_SLnk_idx;
  CREATE INDEX binding_SLnk_idx ON SpecificationLink(serviceBinding);
  CREATE INDEX spec_SLnk_idx ON SpecificationLink(specificationObject);
  
  
  --Indexes on TelephoneNumber
  
  DROP INDEX IF EXISTS parent_Phone_idx;
  CREATE INDEX parent_Phone_idx ON TelephoneNumber(parent);
  
  
  --Indexes on User
  DROP INDEX IF EXISTS lastNm_User_idx;
  CREATE INDEX lastNm_User_idx ON User_(personName_lastName);
  
  
  --Indexes on Person
  DROP INDEX IF EXISTS lastNm_Person_idx;
  CREATE INDEX lastNm_Person_idx ON Person(personName_lastName);
  
  --Grant Privilages
  GRANT  DELETE, INSERT, SELECT, UPDATE ON  Association TO openxds; 
  GRANT  DELETE, INSERT, SELECT, UPDATE ON  AuditableEvent TO openxds;
  GRANT  DELETE, INSERT, SELECT, UPDATE ON  AffectedObject TO openxds; 
  GRANT  DELETE, INSERT, SELECT, UPDATE ON  Classification TO openxds; 
  GRANT  DELETE, INSERT, SELECT, UPDATE ON  ClassificationNode TO openxds; 
  GRANT  DELETE, INSERT, SELECT, UPDATE ON  ClassScheme TO openxds; 
  GRANT  DELETE, INSERT, SELECT, UPDATE ON  Description TO openxds; 
  GRANT  DELETE, INSERT, SELECT, UPDATE ON  ExternalIdentifier TO openxds; 
  GRANT  DELETE, INSERT, SELECT, UPDATE ON  ExternalLink TO openxds; 
  GRANT  DELETE, INSERT, SELECT, UPDATE ON  ExtrinsicObject TO openxds; 
  GRANT  DELETE, INSERT, SELECT, UPDATE ON  Federation TO openxds; 
  GRANT  DELETE, INSERT, SELECT, UPDATE ON  Name_ TO openxds; 
  GRANT  DELETE, INSERT, SELECT, UPDATE ON  UsageDescription TO openxds; 
  GRANT  DELETE, INSERT, SELECT, UPDATE ON  ObjectRef TO openxds; 
  GRANT  DELETE, INSERT, SELECT, UPDATE ON  Organization TO openxds; 
  GRANT  DELETE, INSERT, SELECT, UPDATE ON  RegistryPackage TO openxds; 
  GRANT  DELETE, INSERT, SELECT, UPDATE ON  PostalAddress TO openxds; 
  GRANT  DELETE, INSERT, SELECT, UPDATE ON  EmailAddress TO openxds; 
  GRANT  DELETE, INSERT, SELECT, UPDATE ON  Registry TO openxds; 
  GRANT  DELETE, INSERT, SELECT, UPDATE ON  Service TO openxds; 
  GRANT  DELETE, INSERT, SELECT, UPDATE ON  ServiceBinding TO openxds; 
  GRANT  DELETE, INSERT, SELECT, UPDATE ON  Slot TO openxds; 
  GRANT  DELETE, INSERT, SELECT, UPDATE ON  SpecificationLink TO openxds; 
  GRANT  DELETE, INSERT, SELECT, UPDATE ON  Subscription TO openxds; 
  GRANT  DELETE, INSERT, SELECT, UPDATE ON  NotifyAction TO openxds; 
  GRANT  DELETE, INSERT, SELECT, UPDATE ON  Notification TO openxds; 
  GRANT  DELETE, INSERT, SELECT, UPDATE ON  NotificationObject TO openxds; 
  GRANT  DELETE, INSERT, SELECT, UPDATE ON  AdhocQuery TO openxds; 
  GRANT  DELETE, INSERT, SELECT, UPDATE ON  UsageParameter TO openxds; 
  GRANT  DELETE, INSERT, SELECT, UPDATE ON  TelephoneNumber TO openxds; 
  GRANT  DELETE, INSERT, SELECT, UPDATE ON  User_ TO openxds; 
  GRANT  DELETE, INSERT, SELECT, UPDATE ON  Person TO openxds; 
  GRANT  DELETE, INSERT, SELECT, UPDATE ON  repository TO openxds; 
  GRANT  DELETE, INSERT, SELECT, UPDATE ON  personidentifier TO openxds;
  GRANT  DELETE, INSERT, SELECT, UPDATE ON  RepositoryItem TO openxds;
  
  
  --Insert factory defined Users
  
  --RegistryOperator
  INSERT INTO User_ VALUES('urn:freebxml:registry:predefinedusers:registryoperator', null, 'urn:freebxml:registry:predefinedUser:RegistryOperator', 'urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:Person:User', 'urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted', '1.0', null,  'Registry', null, 'Operator');
  INSERT INTO PostalAddress VALUES('Burlington', 'USA', '01803', 'MA', 'Network Dr.', '1', 'urn:freebxml:registry:predefinedusers:registryoperator');
  INSERT INTO TelephoneNumber VALUES('781', '01', '', '442-0703', 'OfficePhone', 'urn:freebxml:registry:predefinedusers:registryoperator');
  INSERT INTO EmailAddress VALUES('registryOperator@ebxmlrr.com', 'OfficeEmail', 'urn:freebxml:registry:predefinedusers:registryoperator');
  -- We make the owner of the User object to be the user itself.
  INSERT INTO AuditableEvent VALUES('urn:freebxml:registry:predefinedEvent:createRegistryOperator', null, 'urn:freebxml:registry:predefinedEvent:createRegistryOperator', 'urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:AuditableEvent', 'urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted', '1.0', null,  '//TODO', 'urn:oasis:names:tc:ebxml-regrep:EventType:Created', '2003-12-10 10:53:24', 'urn:freebxml:registry:predefinedusers:registryoperator');
  INSERT INTO AffectedObject VALUES('urn:freebxml:registry:predefinedusers:registryoperator', null, 'urn:freebxml:registry:predefinedEvent:createRegistryOperator');
  
  --RegistryGuest
  INSERT INTO User_ VALUES('urn:freebxml:registry:predefinedusers:registryguest', null, 'urn:freebxml:registry:predefinedusers:registryguest', 'urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:Person:User', 'urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted',   '1.0', null,  'Registry', null, 'Guest');
  INSERT INTO PostalAddress VALUES('Burlington', 'USA', '01803', 'MA', 'Network Dr.', '1', 'urn:freebxml:registry:predefinedusers:registryguest');
  INSERT INTO TelephoneNumber VALUES('781', '01', '', '442-0703', 'OfficePhone', 'urn:freebxml:registry:predefinedusers:registryguest');
  INSERT INTO EmailAddress VALUES('registryGuest@ebxmlrr.com', 'OfficeEmail', 'urn:freebxml:registry:predefinedusers:registryguest');
  -- We make the owner of the User object to be the user itself.
  INSERT INTO AuditableEvent VALUES('urn:freebxml:registry:predefinedEvent:createRegistryGuest', null, 'urn:freebxml:registry:predefinedEvent:createRegistryGuest', 'urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:AuditableEvent', 'urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted', '1.0', null,  '//TODO', 'urn:oasis:names:tc:ebxml-regrep:EventType:Created', '2003-12-10 10:53:24', 'urn:freebxml:registry:predefinedusers:registryguest');
  INSERT INTO AffectedObject VALUES('urn:freebxml:registry:predefinedusers:registryguest', null, 'urn:freebxml:registry:predefinedEvent:createRegistryGuest');
  
  --Test user Farrukh
  INSERT INTO User_ VALUES('urn:freebxml:registry:predefinedusers:farrukh', null, 'urn:freebxml:registry:predefinedusers:farrukh', 'urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:Person:User', 'urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted',  '1.0', null,  'Farrukh', 'Salahudin', 'Najmi');
  INSERT INTO PostalAddress VALUES('Burlington', 'USA', '01803', 'MA', 'Network Dr.', '1', 'urn:freebxml:registry:predefinedusers:farrukh');
  INSERT INTO TelephoneNumber VALUES('781', '01', '', '442-0703', 'OfficePhone', 'urn:freebxml:registry:predefinedusers:farrukh');
  INSERT INTO EmailAddress VALUES('farrukh.najmi@sun.com', 'OfficeEmail', 'urn:freebxml:registry:predefinedusers:farrukh');
  -- We make the owner of the User object to be the user itself.
  INSERT INTO AuditableEvent VALUES('urn:freebxml:registry:predefinedEvent:createFarrukh', null, 'urn:freebxml:registry:predefinedEvent:createFarrukh', 'urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:AuditableEvent', 'urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted', '1.0', null,  '//TODO', 'urn:oasis:names:tc:ebxml-regrep:EventType:Created', '2003-12-10 10:53:24', 'urn:freebxml:registry:predefinedusers:farrukh');
  INSERT INTO AffectedObject VALUES('urn:freebxml:registry:predefinedusers:farrukh', null, 'urn:freebxml:registry:predefinedEvent:createFarrukh');
  
  --Test user Nikola
  INSERT INTO User_ VALUES('urn:freebxml:registry:predefinedusers:nikola', null, 'urn:freebxml:registry:predefinedusers:nikola', 'urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:Person:User', 'urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted',  '1.0', null,  'Nikola', null, 'Stojanovic');
  INSERT INTO PostalAddress VALUES('Ithaca', 'France', null, 'NY', 'Terazije', '19', 'urn:freebxml:registry:predefinedusers:nikola');
  INSERT INTO TelephoneNumber VALUES('11', '381', '', '222-2222', 'OfficePhone', 'urn:freebxml:registry:predefinedusers:nikola');
  INSERT INTO TelephoneNumber VALUES('11', '381', '', '444-4444', 'HomePhone', 'urn:freebxml:registry:predefinedusers:nikola');
  INSERT INTO EmailAddress VALUES('nhomest1@twcny.rr.com', 'OfficeEmail', 'urn:freebxml:registry:predefinedusers:nikola');
  -- We make the owner of the User object to be the user itself.
  INSERT INTO AuditableEvent VALUES('urn:freebxml:registry:predefinedEvent:createNikola', null, 'urn:freebxml:registry:predefinedEvent:createNikola', 'urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:AuditableEvent', 'urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted', '1.0', null,  '//TODO', 'urn:oasis:names:tc:ebxml-regrep:EventType:Created', '2003-12-10 10:53:24', 'urn:freebxml:registry:predefinedusers:nikola');
  INSERT INTO AffectedObject VALUES('urn:freebxml:registry:predefinedusers:nikola', null, 'urn:freebxml:registry:predefinedEvent:createNikola');
  
  --Insert IHE defined clssifications
  
  --XDSSubmissionSet
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:uuid:a54d6aa5-d40d-43f9-88c5-b4633d873bdd', NULL, 'urn:uuid:a54d6aa5-d40d-43f9-88c5-b4633d873bdd', 'urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode', 'urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted', '1.1', NULL, 'XDSSubmissionSet', NULL, NULL);
  INSERT INTO CLASSSCHEME VALUES ('urn:uuid:a7058bb9-b4e4-4307-ba5b-e3f0ab85e12d', NULL, 'urn:uuid:a7058bb9-b4e4-4307-ba5b-e3f0ab85e12d', 'urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationScheme', 'urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted', '1.1', 'XDSSubmissionSet.author', 'F', 'urn:oasis:names:tc:ebxml-regrep:NodeType:UniqueCode');
  INSERT INTO CLASSSCHEME VALUES ('urn:uuid:aa543740-bdda-424e-8c96-df4873be8500', NULL, 'urn:uuid:aa543740-bdda-424e-8c96-df4873be8500', 'urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationScheme', 'urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted', '1.1', 'XDSSubmissionSet.contentTypeCode', 'F', 'urn:oasis:names:tc:ebxml-regrep:NodeType:UniqueCode');
  INSERT INTO CLASSSCHEME VALUES ('urn:uuid:6b5aea1a-874d-4603-a4bc-96a0a7b38446', NULL, 'urn:uuid:6b5aea1a-874d-4603-a4bc-96a0a7b38446', 'urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationScheme', 'urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted', '1.1', 'XDSSubmissionSet.patientId', 'F', 'urn:oasis:names:tc:ebxml-regrep:NodeType:UniqueCode');
  INSERT INTO CLASSSCHEME VALUES ('urn:uuid:554ac39e-e3fe-47fe-b233-965d2a147832', NULL, 'urn:uuid:554ac39e-e3fe-47fe-b233-965d2a147832', 'urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationScheme', 'urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted', '1.1', 'XDSSubmissionSet.sourceId', 'F', 'urn:oasis:names:tc:ebxml-regrep:NodeType:UniqueCode');
  INSERT INTO CLASSSCHEME VALUES ('urn:uuid:96fdda7c-d067-4183-912e-bf5ee74998a8', NULL, 'urn:uuid:96fdda7c-d067-4183-912e-bf5ee74998a8', 'urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationScheme', 'urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted', '1.1', 'XDSSubmissionSet.uniqueId', 'F', 'urn:oasis:names:tc:ebxml-regrep:NodeType:UniqueCode');
  
  --XDSDocumentEntry, now with ODD!
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:uuid:7edca82f-054d-47f2-a032-9b2a5b5186c1', NULL, 'urn:uuid:7edca82f-054d-47f2-a032-9b2a5b5186c1', 'urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode', 'urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted', '1.1', NULL, 'XDSDocumentEntry', NULL, NULL);
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:uuid:34268e47-fdf5-41a6-ba33-82133c465248', NULL, 'urn:uuid:34268e47-fdf5-41a6-ba33-82133c465248', 'urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode', 'urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted', '1.1', NULL, 'XDSDocumentEntry', NULL, NULL);
  INSERT INTO CLASSSCHEME VALUES ('urn:uuid:93606bcf-9494-43ec-9b4e-a7748d1a838d', NULL, 'urn:uuid:93606bcf-9494-43ec-9b4e-a7748d1a838d', 'urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationScheme', 'urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted', '1.1', 'XDSDocumentEntry.author', 'F', 'urn:oasis:names:tc:ebxml-regrep:NodeType:UniqueCode');
  INSERT INTO CLASSSCHEME VALUES ('urn:uuid:41a5887f-8865-4c09-adf7-e362475b143a', NULL, 'urn:uuid:41a5887f-8865-4c09-adf7-e362475b143a', 'urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationScheme', 'urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted', '1.1', 'XDSDocumentEntry.classCode', 'F', 'urn:oasis:names:tc:ebxml-regrep:NodeType:UniqueCode');
  INSERT INTO CLASSSCHEME VALUES ('urn:uuid:f4f85eac-e6cb-4883-b524-f2705394840f', NULL, 'urn:uuid:f4f85eac-e6cb-4883-b524-f2705394840f', 'urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationScheme', 'urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted', '1.1', 'XDSDocumentEntry.confidentialityCode', 'F', 'urn:oasis:names:tc:ebxml-regrep:NodeType:UniqueCode');
  INSERT INTO CLASSSCHEME VALUES ('urn:uuid:2c6b8cb7-8b2a-4051-b291-b1ae6a575ef4', NULL, 'urn:uuid:2c6b8cb7-8b2a-4051-b291-b1ae6a575ef4', 'urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationScheme', 'urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted', '1.1', 'XDSDocumentEntry.eventCodeList', 'F', 'urn:oasis:names:tc:ebxml-regrep:NodeType:UniqueCode');
  INSERT INTO CLASSSCHEME VALUES ('urn:uuid:a09d5840-386c-46f2-b5ad-9c3699a4309d', NULL, 'urn:uuid:a09d5840-386c-46f2-b5ad-9c3699a4309d', 'urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationScheme', 'urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted', '1.1', 'XDSDocumentEntry.formatCode', 'F', 'urn:oasis:names:tc:ebxml-regrep:NodeType:UniqueCode');
  INSERT INTO CLASSSCHEME VALUES ('urn:uuid:f33fb8ac-18af-42cc-ae0e-ed0b0bdb91e1', NULL, 'urn:uuid:f33fb8ac-18af-42cc-ae0e-ed0b0bdb91e1', 'urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationScheme', 'urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted', '1.1', 'XDSDocumentEntry.healthCareFacilityTypeCode', 'F', 'urn:oasis:names:tc:ebxml-regrep:NodeType:UniqueCode');
  INSERT INTO CLASSSCHEME VALUES ('urn:uuid:58a6f841-87b3-4a3e-92fd-a8ffeff98427', NULL, 'urn:uuid:58a6f841-87b3-4a3e-92fd-a8ffeff98427', 'urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationScheme', 'urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted', '1.1', 'XDSDocumentEntry.patientId', 'F', 'urn:oasis:names:tc:ebxml-regrep:NodeType:UniqueCode');
  INSERT INTO CLASSSCHEME VALUES ('urn:uuid:cccf5598-8b07-4b77-a05e-ae952c785ead', NULL, 'urn:uuid:cccf5598-8b07-4b77-a05e-ae952c785ead', 'urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationScheme', 'urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted', '1.1', 'XDSDocumentEntry.practiceSettingCode', 'F', 'urn:oasis:names:tc:ebxml-regrep:NodeType:UniqueCode');
  INSERT INTO CLASSSCHEME VALUES ('urn:uuid:f0306f51-975f-434e-a61c-c59651d33983', NULL, 'urn:uuid:f0306f51-975f-434e-a61c-c59651d33983', 'urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationScheme', 'urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted', '1.1', 'XDSDocumentEntry.typeCode', 'F', 'urn:oasis:names:tc:ebxml-regrep:NodeType:UniqueCode');
  INSERT INTO CLASSSCHEME VALUES ('urn:uuid:2e82c1f6-a085-4c72-9da3-8640a32e42ab', NULL, 'urn:uuid:2e82c1f6-a085-4c72-9da3-8640a32e42ab', 'urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationScheme', 'urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted', '1.1', 'XDSDocumentEntry.uniqueId', 'F', 'urn:oasis:names:tc:ebxml-regrep:NodeType:UniqueCode');
  
  --XDSFolder
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:uuid:d9d542f3-6cc4-48b6-8870-ea235fbc94c2', NULL, 'urn:uuid:d9d542f3-6cc4-48b6-8870-ea235fbc94c2', 'urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode', 'urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted', '1.1', NULL, 'XDSFolder', NULL, NULL);
  INSERT INTO CLASSSCHEME VALUES ('urn:uuid:1ba97051-7806-41a8-a48b-8fce7af683c5', NULL, 'urn:uuid:1ba97051-7806-41a8-a48b-8fce7af683c5', 'urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationScheme', 'urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted', '1.1', 'XDSFolder.codeList', 'F', 'urn:oasis:names:tc:ebxml-regrep:NodeType:UniqueCode');
  INSERT INTO CLASSSCHEME VALUES ('urn:uuid:f64ffdf0-4b97-4e06-b79f-a52b38ec2f8a', NULL, 'urn:uuid:f64ffdf0-4b97-4e06-b79f-a52b38ec2f8a', 'urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationScheme', 'urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted', '1.1', 'XDSFolder.patientId', 'F', 'urn:oasis:names:tc:ebxml-regrep:NodeType:UniqueCode');
  INSERT INTO CLASSSCHEME VALUES ('urn:uuid:75df8f67-9973-4fbe-a900-df66cefecc5a', NULL, 'urn:uuid:75df8f67-9973-4fbe-a900-df66cefecc5a', 'urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationScheme', 'urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted', '1.1', 'XDSFolder.uniqueId', 'F', 'urn:oasis:names:tc:ebxml-regrep:NodeType:UniqueCode');
  
  --Document Relationships
  INSERT INTO CLASSSCHEME VALUES ('urn:oasis:names:tc:ebxml-regrep:classificationScheme:AssociationType',NULL,'urn:oasis:names:tc:ebxml-regrep:classificationScheme:AssociationType','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationScheme','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1','AssociationType','F','urn:oasis:names:tc:ebxml-regrep:NodeType:UniqueCode');
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:oasis:names:tc:ebxml-regrep:AssociationType:HasMember', NULL, 'urn:oasis:names:tc:ebxml-regrep:AssociationType:HasMember', 'urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode', 'urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted', '1.1', NULL, 'HasMember', 'urn:oasis:names:tc:ebxml-regrep:classificationScheme:AssociationType', '/urn:oasis:names:tc:ebxml-regrep:classificationScheme:AssociationType/HasMember');
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:ihe:iti:2007:AssociationType:APND', NULL, 'urn:ihe:iti:2007:AssociationType:APND', 'urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode', 'urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted', '1.1', NULL, 'APND', 'urn:oasis:names:tc:ebxml-regrep:classificationScheme:AssociationType', '/urn:oasis:names:tc:ebxml-regrep:classificationScheme:AssociationType/APND');
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:ihe:iti:2007:AssociationType:RPLC', NULL, 'urn:ihe:iti:2007:AssociationType:RPLC', 'urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode', 'urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted', '1.1', NULL, 'RPLC', 'urn:oasis:names:tc:ebxml-regrep:classificationScheme:AssociationType', '/urn:oasis:names:tc:ebxml-regrep:classificationScheme:AssociationType/RPLC');
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:ihe:iti:2007:AssociationType:XFRM', NULL, 'urn:ihe:iti:2007:AssociationType:XFRM', 'urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode', 'urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted', '1.1', NULL, 'XFRM', 'urn:oasis:names:tc:ebxml-regrep:classificationScheme:AssociationType', '/urn:oasis:names:tc:ebxml-regrep:classificationScheme:AssociationType/XFRM');
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:ihe:iti:2007:AssociationType:XFRM_RPLC', NULL, 'urn:ihe:iti:2007:AssociationType:XFRM_RPLC', 'urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode', 'urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted', '1.1', NULL, 'XFRM_RPLC', 'urn:oasis:names:tc:ebxml-regrep:classificationScheme:AssociationType', '/urn:oasis:names:tc:ebxml-regrep:classificationScheme:AssociationType/XFRM_RPLC');
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:ihe:iti:2007:AssociationType:signs', NULL, 'urn:ihe:iti:2007:AssociationType:signs', 'urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode', 'urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted', '1.1', NULL, 'signs', 'urn:oasis:names:tc:ebxml-regrep:classificationScheme:AssociationType', '/urn:oasis:names:tc:ebxml-regrep:classificationScheme:AssociationType/signs');
  
  --Others
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:uuid:10aa1a4b-715a-4120-bfd0-9760414112c8', NULL, 'urn:uuid:10aa1a4b-715a-4120-bfd0-9760414112c8', 'urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode', 'urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted', '1.1', NULL, 'XDSDocumentEntryStub', NULL, NULL);
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:uuid:abd807a3-4432-4053-87b4-fd82c643d1f3', NULL, 'urn:uuid:abd807a3-4432-4053-87b4-fd82c643d1f3', 'urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode', 'urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted', '1.1', NULL, 'Association Documentation', NULL, NULL);
  
  --Insert Factory defined classifications
  --StatusTypes
  INSERT INTO CLASSSCHEME VALUES ('urn:oasis:names:tc:ebxml-regrep:classificationScheme:StatusType',NULL,'urn:oasis:names:tc:ebxml-regrep:classificationScheme:StatusType','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationScheme','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1','StatusType','T','urn:oasis:names:tc:ebxml-regrep:NodeType:UniqueCode');
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:oasis:names:tc:ebxml-regrep:StatusType:Approved',NULL,'urn:oasis:names:tc:ebxml-regrep:StatusType:Approved','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1',NULL,'Approved','urn:oasis:names:tc:ebxml-regrep:classificationScheme:StatusType','/urn:oasis:names:tc:ebxml-regrep:classificationScheme:StatusType/Approved');
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted',NULL,'urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1',NULL,'Approved','urn:oasis:names:tc:ebxml-regrep:classificationScheme:StatusType','/urn:oasis:names:tc:ebxml-regrep:classificationScheme:StatusType/Submitted');
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:oasis:names:tc:ebxml-regrep:StatusType:Deprecated',NULL,'urn:oasis:names:tc:ebxml-regrep:StatusType:Deprecated','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1',NULL,'Approved','urn:oasis:names:tc:ebxml-regrep:classificationScheme:StatusType','/urn:oasis:names:tc:ebxml-regrep:classificationScheme:StatusType/Deprecated');
  
  --DataTypes
  INSERT INTO CLASSSCHEME VALUES ('urn:oasis:names:tc:ebxml-regrep:classificationScheme:DataType',NULL,'urn:oasis:names:tc:ebxml-regrep:classificationScheme:DataType','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationScheme','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1','DataType','T','urn:oasis:names:tc:ebxml-regrep:NodeType:UniqueCode');
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:oasis:names:tc:ebxml-regrep:DataType:Boolean',NULL,'urn:oasis:names:tc:ebxml-regrep:DataType:Boolean','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1',NULL,'Boolean','urn:oasis:names:tc:ebxml-regrep:classificationScheme:DataType','/urn:oasis:names:tc:ebxml-regrep:classificationScheme:DataType/Boolean');
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:oasis:names:tc:ebxml-regrep:DataType:Date',NULL,'urn:oasis:names:tc:ebxml-regrep:DataType:Date','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1',NULL,'Date','urn:oasis:names:tc:ebxml-regrep:classificationScheme:DataType','/urn:oasis:names:tc:ebxml-regrep:classificationScheme:DataType/Date');
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:oasis:names:tc:ebxml-regrep:DataType:DateTime',NULL,'urn:oasis:names:tc:ebxml-regrep:DataType:DateTime','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1',NULL,'DateTime','urn:oasis:names:tc:ebxml-regrep:classificationScheme:DataType','/urn:oasis:names:tc:ebxml-regrep:classificationScheme:DataType/DateTime');
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:oasis:names:tc:ebxml-regrep:DataType:Double',NULL,'urn:oasis:names:tc:ebxml-regrep:DataType:Double','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1',NULL,'Double','urn:oasis:names:tc:ebxml-regrep:classificationScheme:DataType','/urn:oasis:names:tc:ebxml-regrep:classificationScheme:DataType/Double');
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:oasis:names:tc:ebxml-regrep:DataType:Duration',NULL,'urn:oasis:names:tc:ebxml-regrep:DataType:Duration','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1',NULL,'Duration','urn:oasis:names:tc:ebxml-regrep:classificationScheme:DataType','/urn:oasis:names:tc:ebxml-regrep:classificationScheme:DataType/Duration');
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:oasis:names:tc:ebxml-regrep:DataType:Float',NULL,'urn:oasis:names:tc:ebxml-regrep:DataType:Float','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1',NULL,'Float','urn:oasis:names:tc:ebxml-regrep:classificationScheme:DataType','/urn:oasis:names:tc:ebxml-regrep:classificationScheme:DataType/Float');
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:oasis:names:tc:ebxml-regrep:DataType:Integer',NULL,'urn:oasis:names:tc:ebxml-regrep:DataType:Integer','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1',NULL,'Integer','urn:oasis:names:tc:ebxml-regrep:classificationScheme:DataType','/urn:oasis:names:tc:ebxml-regrep:classificationScheme:DataType/Integer');
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:oasis:names:tc:ebxml-regrep:DataType:ObjectRef',NULL,'urn:oasis:names:tc:ebxml-regrep:DataType:ObjectRef','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1',NULL,'ObjectRef','urn:oasis:names:tc:ebxml-regrep:classificationScheme:DataType','/urn:oasis:names:tc:ebxml-regrep:classificationScheme:DataType/ObjectRef');
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:oasis:names:tc:ebxml-regrep:DataType:String',NULL,'urn:oasis:names:tc:ebxml-regrep:DataType:String','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1',NULL,'String','urn:oasis:names:tc:ebxml-regrep:classificationScheme:DataType','/urn:oasis:names:tc:ebxml-regrep:classificationScheme:DataType/String');
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:oasis:names:tc:ebxml-regrep:DataType:Time',NULL,'urn:oasis:names:tc:ebxml-regrep:DataType:Time','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1',NULL,'Time','urn:oasis:names:tc:ebxml-regrep:classificationScheme:DataType','/urn:oasis:names:tc:ebxml-regrep:classificationScheme:DataType/Time');
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:oasis:names:tc:ebxml-regrep:DataType:URI',NULL,'urn:oasis:names:tc:ebxml-regrep:DataType:URI','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1',NULL,'URI','urn:oasis:names:tc:ebxml-regrep:classificationScheme:DataType','/urn:oasis:names:tc:ebxml-regrep:classificationScheme:DataType/URI');
  
  --EventType
  INSERT INTO CLASSSCHEME VALUES ('urn:oasis:names:tc:ebxml-regrep:classificationScheme:EventType',NULL,'urn:oasis:names:tc:ebxml-regrep:classificationScheme:EventType','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationScheme','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1','EventType','T','urn:oasis:names:tc:ebxml-regrep:NodeType:UniqueCode');
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:oasis:names:tc:ebxml-regrep:EventType:Approved',NULL,'urn:oasis:names:tc:ebxml-regrep:EventType:Approved','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1',NULL,'Approved','urn:oasis:names:tc:ebxml-regrep:classificationScheme:EventType','/urn:oasis:names:tc:ebxml-regrep:classificationScheme:EventType/Approved');
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:oasis:names:tc:ebxml-regrep:EventType:Created',NULL,'urn:oasis:names:tc:ebxml-regrep:EventType:Created','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1',NULL,'Created','urn:oasis:names:tc:ebxml-regrep:classificationScheme:EventType','/urn:oasis:names:tc:ebxml-regrep:classificationScheme:EventType/Created');
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:oasis:names:tc:ebxml-regrep:EventType:Deleted',NULL,'urn:oasis:names:tc:ebxml-regrep:EventType:Deleted','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1',NULL,'Deleted','urn:oasis:names:tc:ebxml-regrep:classificationScheme:EventType','/urn:oasis:names:tc:ebxml-regrep:classificationScheme:EventType/Deleted');
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:oasis:names:tc:ebxml-regrep:EventType:Deprecated',NULL,'urn:oasis:names:tc:ebxml-regrep:EventType:Deprecated','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1',NULL,'Deprecated','urn:oasis:names:tc:ebxml-regrep:classificationScheme:EventType','/urn:oasis:names:tc:ebxml-regrep:classificationScheme:EventType/Deprecated');
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:oasis:names:tc:ebxml-regrep:EventType:Downloaded',NULL,'urn:oasis:names:tc:ebxml-regrep:EventType:Downloaded','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1',NULL,'Downloaded','urn:oasis:names:tc:ebxml-regrep:classificationScheme:EventType','/urn:oasis:names:tc:ebxml-regrep:classificationScheme:EventType/Downloaded');
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:oasis:names:tc:ebxml-regrep:EventType:Relocated',NULL,'urn:oasis:names:tc:ebxml-regrep:EventType:Relocated','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1',NULL,'Relocated','urn:oasis:names:tc:ebxml-regrep:classificationScheme:EventType','/urn:oasis:names:tc:ebxml-regrep:classificationScheme:EventType/Relocated');
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:oasis:names:tc:ebxml-regrep:EventType:Undeprecated',NULL,'urn:oasis:names:tc:ebxml-regrep:EventType:Undeprecated','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1',NULL,'Undeprecated','urn:oasis:names:tc:ebxml-regrep:classificationScheme:EventType','/urn:oasis:names:tc:ebxml-regrep:classificationScheme:EventType/Undeprecated');
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:oasis:names:tc:ebxml-regrep:EventType:Updated',NULL,'urn:oasis:names:tc:ebxml-regrep:EventType:Updated','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1',NULL,'Updated','urn:oasis:names:tc:ebxml-regrep:classificationScheme:EventType','/urn:oasis:names:tc:ebxml-regrep:classificationScheme:EventType/Updated');
  
  --EmailTypes
  INSERT INTO CLASSSCHEME VALUES ('urn:oasis:names:tc:ebxml-regrep:classificationScheme:EmailType',NULL,'urn:oasis:names:tc:ebxml-regrep:classificationScheme:EmailType','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationScheme','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1','EmailType','T','urn:oasis:names:tc:ebxml-regrep:NodeType:UniqueCode');
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:oasis:names:tc:ebxml-regrep:EmailType:HomeEmail',NULL,'urn:oasis:names:tc:ebxml-regrep:EmailType:HomeEmail','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1',NULL,'HomeEmail','urn:oasis:names:tc:ebxml-regrep:classificationScheme:EmailType','/urn:oasis:names:tc:ebxml-regrep:classificationScheme:EmailType/HomeEmail');
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:oasis:names:tc:ebxml-regrep:EmailType:OfficeEmail',NULL,'urn:oasis:names:tc:ebxml-regrep:EmailType:OfficeEmail','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1',NULL,'OfficeEmail','urn:oasis:names:tc:ebxml-regrep:classificationScheme:EmailType','/urn:oasis:names:tc:ebxml-regrep:classificationScheme:EmailType/OfficeEmail');
  
  --NodeTypes
  INSERT INTO CLASSSCHEME VALUES ('urn:oasis:names:tc:ebxml-regrep:classificationScheme:NodeType',NULL,'urn:oasis:names:tc:ebxml-regrep:classificationScheme:NodeType','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationScheme','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1','NodeType','T','urn:oasis:names:tc:ebxml-regrep:NodeType:UniqueCode');
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:oasis:names:tc:ebxml-regrep:NodeType:EmbeddedPath',NULL,'urn:oasis:names:tc:ebxml-regrep:NodeType:EmbeddedPath','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1',NULL,'EmbeddedPath','urn:oasis:names:tc:ebxml-regrep:classificationScheme:NodeType','/urn:oasis:names:tc:ebxml-regrep:classificationScheme:NodeType/EmbeddedPath');
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:oasis:names:tc:ebxml-regrep:NodeType:NonUniqueCode',NULL,'urn:oasis:names:tc:ebxml-regrep:NodeType:NonUniqueCode','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1',NULL,'NonUniqueCode','urn:oasis:names:tc:ebxml-regrep:classificationScheme:NodeType','/urn:oasis:names:tc:ebxml-regrep:classificationScheme:NodeType/NonUniqueCode');
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:oasis:names:tc:ebxml-regrep:NodeType:UniqueCode',NULL,'urn:oasis:names:tc:ebxml-regrep:NodeType:UniqueCode','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1',NULL,'UniqueCode','urn:oasis:names:tc:ebxml-regrep:classificationScheme:NodeType','/urn:oasis:names:tc:ebxml-regrep:classificationScheme:NodeType/UniqueCode');
  
  --NotificationOptionType
  INSERT INTO CLASSSCHEME VALUES ('urn:oasis:names:tc:ebxml-regrep:classificationScheme:NotificationOptionType',NULL,'urn:oasis:names:tc:ebxml-regrep:classificationScheme:NotificationOptionType','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationScheme','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1','NotificationOptionType','T','urn:oasis:names:tc:ebxml-regrep:NodeType:UniqueCode');
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:oasis:names:tc:ebxml-regrep:NotificationOptionType:ObjectRefs',NULL,'urn:oasis:names:tc:ebxml-regrep:NotificationOptionType:ObjectRefs','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1',NULL,'ObjectRefs','urn:oasis:names:tc:ebxml-regrep:classificationScheme:NotificationOptionType','/urn:oasis:names:tc:ebxml-regrep:classificationScheme:NotificationOptionType/ObjectRefs');
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:oasis:names:tc:ebxml-regrep:NotificationOptionType:Objects',NULL,'urn:oasis:names:tc:ebxml-regrep:NotificationOptionType:Objects','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1',NULL,'Objects','urn:oasis:names:tc:ebxml-regrep:classificationScheme:NotificationOptionType','/urn:oasis:names:tc:ebxml-regrep:classificationScheme:NotificationOptionType/Objects');
  
  --PhoneType
  INSERT INTO CLASSSCHEME VALUES ('urn:oasis:names:tc:ebxml-regrep:classificationScheme:PhoneType',NULL,'urn:oasis:names:tc:ebxml-regrep:classificationScheme:PhoneType','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationScheme','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1','PhoneType','T','urn:oasis:names:tc:ebxml-regrep:NodeType:UniqueCode');
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:oasis:names:tc:ebxml-regrep:PhoneType:Beeper',NULL,'urn:oasis:names:tc:ebxml-regrep:PhoneType:Beeper','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1',NULL,'Beeper','urn:oasis:names:tc:ebxml-regrep:classificationScheme:PhoneType','/urn:oasis:names:tc:ebxml-regrep:classificationScheme:PhoneType/Beeper');
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:oasis:names:tc:ebxml-regrep:PhoneType:FAX',NULL,'urn:oasis:names:tc:ebxml-regrep:PhoneType:FAX','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1',NULL,'FAX','urn:oasis:names:tc:ebxml-regrep:classificationScheme:PhoneType','/urn:oasis:names:tc:ebxml-regrep:classificationScheme:PhoneType/FAX');
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:oasis:names:tc:ebxml-regrep:PhoneType:HomePhone',NULL,'urn:oasis:names:tc:ebxml-regrep:PhoneType:HomePhone','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1',NULL,'HomePhone','urn:oasis:names:tc:ebxml-regrep:classificationScheme:PhoneType','/urn:oasis:names:tc:ebxml-regrep:classificationScheme:PhoneType/HomePhone');
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:oasis:names:tc:ebxml-regrep:PhoneType:MobilePhone',NULL,'urn:oasis:names:tc:ebxml-regrep:PhoneType:MobilePhone','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1',NULL,'MobilePhone','urn:oasis:names:tc:ebxml-regrep:classificationScheme:PhoneType','/urn:oasis:names:tc:ebxml-regrep:classificationScheme:PhoneType/MobilePhone');
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:oasis:names:tc:ebxml-regrep:PhoneType:OfficePhone',NULL,'urn:oasis:names:tc:ebxml-regrep:PhoneType:OfficePhone','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1',NULL,'OfficePhone','urn:oasis:names:tc:ebxml-regrep:classificationScheme:PhoneType','/urn:oasis:names:tc:ebxml-regrep:classificationScheme:PhoneType/OfficePhone');
  
  --QueryLanguage
  INSERT INTO CLASSSCHEME VALUES ('urn:oasis:names:tc:ebxml-regrep:classificationScheme:QueryLanguage',NULL,'urn:oasis:names:tc:ebxml-regrep:classificationScheme:QueryLanguage','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationScheme','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1','QueryLanguage','T','urn:oasis:names:tc:ebxml-regrep:NodeType:UniqueCode');
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:oasis:names:tc:ebxml-regrep:QueryLanguage:ebRSFilterQuery',NULL,'urn:oasis:names:tc:ebxml-regrep:QueryLanguage:ebRSFilterQuery','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1',NULL,'ebRSFilterQuery','urn:oasis:names:tc:ebxml-regrep:classificationScheme:QueryLanguage','/urn:oasis:names:tc:ebxml-regrep:classificationScheme:QueryLanguage/ebRSFilterQuery');
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:oasis:names:tc:ebxml-regrep:QueryLanguage:SQL-92',NULL,'urn:oasis:names:tc:ebxml-regrep:QueryLanguage:SQL-92','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1',NULL,'SQL-92','urn:oasis:names:tc:ebxml-regrep:classificationScheme:QueryLanguage','/urn:oasis:names:tc:ebxml-regrep:classificationScheme:QueryLanguage/SQL-92');
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:oasis:names:tc:ebxml-regrep:QueryLanguage:XPath',NULL,'urn:oasis:names:tc:ebxml-regrep:QueryLanguage:XPath','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1',NULL,'XPath','urn:oasis:names:tc:ebxml-regrep:classificationScheme:QueryLanguage','/urn:oasis:names:tc:ebxml-regrep:classificationScheme:QueryLanguage/XPath');
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:oasis:names:tc:ebxml-regrep:QueryLanguage:XQuery',NULL,'urn:oasis:names:tc:ebxml-regrep:QueryLanguage:XQuery','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1',NULL,'XQuery','urn:oasis:names:tc:ebxml-regrep:classificationScheme:QueryLanguage','/urn:oasis:names:tc:ebxml-regrep:classificationScheme:QueryLanguage/XQuery');
  
  --SubjectRole
  INSERT INTO CLASSSCHEME VALUES ('urn:oasis:names:tc:ebxml-regrep:classificationScheme:SubjectRole',NULL,'urn:oasis:names:tc:ebxml-regrep:classificationScheme:SubjectRole','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationScheme','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1','SubjectRole','T','urn:oasis:names:tc:ebxml-regrep:NodeType:UniqueCode');
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:oasis:names:tc:ebxml-regrep:SubjectRole:ContentOwner',NULL,'urn:oasis:names:tc:ebxml-regrep:SubjectRole:ContentOwner','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1',NULL,'ContentOwner','urn:oasis:names:tc:ebxml-regrep:classificationScheme:SubjectRole','/urn:oasis:names:tc:ebxml-regrep:classificationScheme:SubjectRole/ContentOwner');
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:oasis:names:tc:ebxml-regrep:SubjectRole:Intermediary',NULL,'urn:oasis:names:tc:ebxml-regrep:SubjectRole:Intermediary','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1',NULL,'Intermediary','urn:oasis:names:tc:ebxml-regrep:classificationScheme:SubjectRole','/urn:oasis:names:tc:ebxml-regrep:classificationScheme:SubjectRole/Intermediary');
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:oasis:names:tc:ebxml-regrep:SubjectRole:RegistryAdministrator',NULL,'urn:oasis:names:tc:ebxml-regrep:SubjectRole:RegistryAdministrator','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1',NULL,'RegistryAdministrator','urn:oasis:names:tc:ebxml-regrep:classificationScheme:SubjectRole','/urn:oasis:names:tc:ebxml-regrep:classificationScheme:SubjectRole/RegistryAdministrator');
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:oasis:names:tc:ebxml-regrep:SubjectRole:RegistryGuest',NULL,'urn:oasis:names:tc:ebxml-regrep:SubjectRole:RegistryGuest','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1',NULL,'RegistryGuest','urn:oasis:names:tc:ebxml-regrep:classificationScheme:SubjectRole','/urn:oasis:names:tc:ebxml-regrep:classificationScheme:SubjectRole/RegistryGuest');
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:freebxml:registry:demoDB:SubjectRole:ProjectMember',NULL,'urn:freebxml:registry:demoDB:SubjectRole:ProjectMember','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1',NULL,'ProjectMember','urn:oasis:names:tc:ebxml-regrep:classificationScheme:SubjectRole','/urn:oasis:names:tc:ebxml-regrep:classificationScheme:SubjectRole/ProjectMember');
  --ProtocolType
  INSERT INTO CLASSSCHEME VALUES ('urn:oasis:names:tc:ebxml-regrep:profile:ws:classificationScheme:ProtocolType',NULL,'urn:oasis:names:tc:ebxml-regrep:profile:ws:classificationScheme:ProtocolType','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationScheme','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1','ProtocolType','T','urn:oasis:names:tc:ebxml-regrep:NodeType:UniqueCode');
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:oasis:names:tc:ebxml-regrep:profile:ws:ProtocolType:AS2',NULL,'urn:oasis:names:tc:ebxml-regrep:profile:ws:ProtocolType:AS2','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1',NULL,'AS2','urn:oasis:names:tc:ebxml-regrep:profile:ws:classificationScheme:ProtocolType','/urn:oasis:names:tc:ebxml-regrep:profile:ws:classificationScheme:ProtocolType/AS2');
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:oasis:names:tc:ebxml-regrep:profile:ws:ProtocolType:Atom',NULL,'urn:oasis:names:tc:ebxml-regrep:profile:ws:ProtocolType:Atom','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1',NULL,'Atom','urn:oasis:names:tc:ebxml-regrep:profile:ws:classificationScheme:ProtocolType','/urn:oasis:names:tc:ebxml-regrep:profile:ws:classificationScheme:ProtocolType/Atom');
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:oasis:names:tc:ebxml-regrep:profile:ws:ProtocolType:SOAP',NULL,'urn:oasis:names:tc:ebxml-regrep:profile:ws:ProtocolType:SOAP','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1',NULL,'SOAP','urn:oasis:names:tc:ebxml-regrep:profile:ws:classificationScheme:ProtocolType','/urn:oasis:names:tc:ebxml-regrep:profile:ws:classificationScheme:ProtocolType/SOAP');
  
  --SOAPStyleType
  INSERT INTO CLASSSCHEME VALUES ('urn:oasis:names:tc:ebxml-regrep:profile:ws:classificationScheme:SOAPStyleType',NULL,'urn:oasis:names:tc:ebxml-regrep:profile:ws:classificationScheme:SOAPStyleType','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationScheme','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1','SOAPStyleType','T','urn:oasis:names:tc:ebxml-regrep:NodeType:UniqueCode');
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:oasis:names:tc:ebxml-regrep:profile:ws:SOAPStyleType:Document',NULL,'urn:oasis:names:tc:ebxml-regrep:profile:ws:SOAPStyleType:Document','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1',NULL,'Document','urn:oasis:names:tc:ebxml-regrep:profile:ws:classificationScheme:SOAPStyleType','/urn:oasis:names:tc:ebxml-regrep:profile:ws:classificationScheme:SOAPStyleType/Document');
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:oasis:names:tc:ebxml-regrep:profile:ws:SOAPStyleType:RPC',NULL,'urn:oasis:names:tc:ebxml-regrep:profile:ws:SOAPStyleType:RPC','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1',NULL,'RPC','urn:oasis:names:tc:ebxml-regrep:profile:ws:classificationScheme:SOAPStyleType','/urn:oasis:names:tc:ebxml-regrep:profile:ws:classificationScheme:SOAPStyleType/RPC');
  
  --StabilityType
  INSERT INTO CLASSSCHEME VALUES ('urn:oasis:names:tc:ebxml-regrep:classificationScheme:StabilityType',NULL,'urn:oasis:names:tc:ebxml-regrep:classificationScheme:StabilityType','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationScheme','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1','StabilityType','T','urn:oasis:names:tc:ebxml-regrep:NodeType:UniqueCode');
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:oasis:names:tc:ebxml-regrep:StabilityType:Dynamic',NULL,'urn:oasis:names:tc:ebxml-regrep:StabilityType:Dynamic','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1',NULL,'Dynamic','urn:oasis:names:tc:ebxml-regrep:classificationScheme:StabilityType','/urn:oasis:names:tc:ebxml-regrep:classificationScheme:StabilityType/Dynamic');
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:oasis:names:tc:ebxml-regrep:StabilityType:DynamicCompatible',NULL,'urn:oasis:names:tc:ebxml-regrep:StabilityType:DynamicCompatible','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1',NULL,'DynamicCompatible','urn:oasis:names:tc:ebxml-regrep:classificationScheme:StabilityType','/urn:oasis:names:tc:ebxml-regrep:classificationScheme:StabilityType/DynamicCompatible');
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:oasis:names:tc:ebxml-regrep:StabilityType:Static',NULL,'urn:oasis:names:tc:ebxml-regrep:StabilityType:Static','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1',NULL,'Static','urn:oasis:names:tc:ebxml-regrep:classificationScheme:StabilityType','/urn:oasis:names:tc:ebxml-regrep:classificationScheme:StabilityType/Static');
  
  --DeletionScopeType
  INSERT INTO CLASSSCHEME VALUES ('urn:oasis:names:tc:ebxml-regrep:classificationScheme:DeletionScopeType',NULL,'urn:oasis:names:tc:ebxml-regrep:classificationScheme:DeletionScopeType','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationScheme','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1','DeletionScopeType','T','urn:oasis:names:tc:ebxml-regrep:NodeType:UniqueCode');
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:oasis:names:tc:ebxml-regrep:DeletionScopeType:DeleteAll',NULL,'urn:oasis:names:tc:ebxml-regrep:DeletionScopeType:DeleteAll','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1',NULL,'DeleteAll','urn:oasis:names:tc:ebxml-regrep:classificationScheme:DeletionScopeType','/urn:oasis:names:tc:ebxml-regrep:classificationScheme:DeletionScopeType/DeleteAll');
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:oasis:names:tc:ebxml-regrep:DeletionScopeType:DeleteRepositoryItemOnly',NULL,'urn:oasis:names:tc:ebxml-regrep:DeletionScopeType:DeleteRepositoryItemOnly','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1',NULL,'DeleteRepositoryItemOnly','urn:oasis:names:tc:ebxml-regrep:classificationScheme:DeletionScopeType','/urn:oasis:names:tc:ebxml-regrep:classificationScheme:DeletionScopeType/DeleteRepositoryItemOnly');
  
  --ErrorHandlingModel
  INSERT INTO CLASSSCHEME VALUES ('urn:oasis:names:tc:ebxml-regrep:classificationScheme:ErrorHandlingModel',NULL,'urn:oasis:names:tc:ebxml-regrep:classificationScheme:ErrorHandlingModel','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationScheme','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1','ErrorHandlingModel','T','urn:oasis:names:tc:ebxml-regrep:NodeType:UniqueCode');
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:oasis:names:tc:ebxml-regrep:ErrorHandlingModel:FailOnError',NULL,'urn:oasis:names:tc:ebxml-regrep:ErrorHandlingModel:FailOnError','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1',NULL,'FailOnError','urn:oasis:names:tc:ebxml-regrep:classificationScheme:ErrorHandlingModel','/urn:oasis:names:tc:ebxml-regrep:classificationScheme:ErrorHandlingModel/FailOnError');
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:oasis:names:tc:ebxml-regrep:ErrorHandlingModel:LogErrorAndContinue',NULL,'urn:oasis:names:tc:ebxml-regrep:ErrorHandlingModel:LogErrorAndContinue','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1',NULL,'LogErrorAndContinue','urn:oasis:names:tc:ebxml-regrep:classificationScheme:ErrorHandlingModel','/urn:oasis:names:tc:ebxml-regrep:classificationScheme:ErrorHandlingModel/LogErrorAndContinue');
  
  --ErrorSeverityType
  INSERT INTO CLASSSCHEME VALUES ('urn:oasis:names:tc:ebxml-regrep:classificationScheme:ErrorSeverityType',NULL,'urn:oasis:names:tc:ebxml-regrep:classificationScheme:ErrorSeverityType','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationScheme','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1','ErrorSeverityType','T','urn:oasis:names:tc:ebxml-regrep:NodeType:UniqueCode');
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:oasis:names:tc:ebxml-regrep:ErrorSeverityType:Error',NULL,'urn:oasis:names:tc:ebxml-regrep:ErrorSeverityType:Error','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1',NULL,'Error','urn:oasis:names:tc:ebxml-regrep:classificationScheme:ErrorSeverityType','/urn:oasis:names:tc:ebxml-regrep:classificationScheme:ErrorSeverityType/Error');
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:oasis:names:tc:ebxml-regrep:ErrorSeverityType:Warning',NULL,'urn:oasis:names:tc:ebxml-regrep:ErrorSeverityType:Warning','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1',NULL,'Warning','urn:oasis:names:tc:ebxml-regrep:classificationScheme:ErrorSeverityType','/urn:oasis:names:tc:ebxml-regrep:classificationScheme:ErrorSeverityType/Warning');
  
  --ObjectType
  INSERT INTO CLASSSCHEME VALUES ('urn:oasis:names:tc:ebxml-regrep:classificationScheme:ObjectType',NULL,'urn:oasis:names:tc:ebxml-regrep:classificationScheme:ObjectType','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationScheme','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1','ObjectType','T','urn:oasis:names:tc:ebxml-regrep:NodeType:UniqueCode');
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject',NULL,'urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1',NULL,'RegistryObject','urn:oasis:names:tc:ebxml-regrep:classificationScheme:ObjectType','/urn:oasis:names:tc:ebxml-regrep:classificationScheme:ObjectType/RegistryObject');
  
  --ResponseStatusType
  INSERT INTO CLASSSCHEME VALUES ('urn:oasis:names:tc:ebxml-regrep:classificationScheme:ResponseStatusType',NULL,'urn:oasis:names:tc:ebxml-regrep:classificationScheme:ResponseStatusType','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationScheme','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1','ResponseStatusType','T','urn:oasis:names:tc:ebxml-regrep:NodeType:UniqueCode');
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:oasis:names:tc:ebxml-regrep:ResponseStatusType:Failure',NULL,'urn:oasis:names:tc:ebxml-regrep:ResponseStatusType:Failure','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1',NULL,'Failure','urn:oasis:names:tc:ebxml-regrep:classificationScheme:ResponseStatusType','/urn:oasis:names:tc:ebxml-regrep:classificationScheme:ResponseStatusType/Failure');
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:oasis:names:tc:ebxml-regrep:ResponseStatusType:Success',NULL,'urn:oasis:names:tc:ebxml-regrep:ResponseStatusType:Success','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1',NULL,'Success','urn:oasis:names:tc:ebxml-regrep:classificationScheme:ResponseStatusType','/urn:oasis:names:tc:ebxml-regrep:classificationScheme:ResponseStatusType/Success');
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:oasis:names:tc:ebxml-regrep:ResponseStatusType:Unavailable',NULL,'urn:oasis:names:tc:ebxml-regrep:ResponseStatusType:Unavailable','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1',NULL,'Unavailable','urn:oasis:names:tc:ebxml-regrep:classificationScheme:ResponseStatusType','/urn:oasis:names:tc:ebxml-regrep:classificationScheme:ResponseStatusType/Unavailable');
  
  --other
  INSERT INTO CLASSIFICATION VALUES ('urn:oasis:names:tc:ebxml-regrep:classification:RegistryAdministrator',NULL,'urn:oasis:names:tc:ebxml-regrep:classification:RegistryAdministrator','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:Classification','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1',NULL,'urn:oasis:names:tc:ebxml-regrep:SubjectRole:RegistryAdministrator',NULL,'urn:freebxml:registry:predefinedusers:registryoperator',NULL);
  
  --RegistryObject
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:AdhocQuery',NULL,'urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:AdhocQuery','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1',NULL,'AdhocQuery','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject','/urn:oasis:names:tc:ebxml-regrep:classificationScheme:ObjectType/RegistryObject/AdhocQuery');
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:Association',NULL,'urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:Association','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1',NULL,'Association','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject','/urn:oasis:names:tc:ebxml-regrep:classificationScheme:ObjectType/RegistryObject/Association');
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:AuditableEvent',NULL,'urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:AuditableEvent','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1',NULL,'AuditableEvent','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject','/urn:oasis:names:tc:ebxml-regrep:classificationScheme:ObjectType/RegistryObject/AuditableEvent');
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:Classification',NULL,'urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:Classification','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1',NULL,'Classification','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject','/urn:oasis:names:tc:ebxml-regrep:classificationScheme:ObjectType/RegistryObject/Classification');
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode',NULL,'urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1',NULL,'ClassificationNode','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject','/urn:oasis:names:tc:ebxml-regrep:classificationScheme:ObjectType/RegistryObject/ClassificationNode');
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationScheme',NULL,'urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationScheme','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1',NULL,'ClassificationScheme','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject','/urn:oasis:names:tc:ebxml-regrep:classificationScheme:ObjectType/RegistryObject/ClassificationScheme');
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ExternalIdentifier',NULL,'urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ExternalIdentifier','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1',NULL,'ExternalIdentifier','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject','/urn:oasis:names:tc:ebxml-regrep:classificationScheme:ObjectType/RegistryObject/ExternalIdentifier');
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ExternalLink',NULL,'urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ExternalLink','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1',NULL,'ExternalLink','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject','/urn:oasis:names:tc:ebxml-regrep:classificationScheme:ObjectType/RegistryObject/ExternalLink');
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ExtrinsicObject',NULL,'urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ExtrinsicObject','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1',NULL,'ExtrinsicObject','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject','/urn:oasis:names:tc:ebxml-regrep:classificationScheme:ObjectType/RegistryObject/ExtrinsicObject');
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ExtrinsicObject:image',NULL,'urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ExtrinsicObject:image','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1',NULL,'image','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ExtrinsicObject','/urn:oasis:names:tc:ebxml-regrep:classificationScheme:ObjectType/RegistryObject/ExtrinsicObject/image');
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ExtrinsicObject:image:gif',NULL,'urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ExtrinsicObject:image:gif','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1',NULL,'gif','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ExtrinsicObject:image','/urn:oasis:names:tc:ebxml-regrep:classificationScheme:ObjectType/RegistryObject/ExtrinsicObject/image/gif');
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ExtrinsicObject:image:jpeg',NULL,'urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ExtrinsicObject:image:jpeg','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1',NULL,'jpeg','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ExtrinsicObject:image','/urn:oasis:names:tc:ebxml-regrep:classificationScheme:ObjectType/RegistryObject/ExtrinsicObject/image/jpeg');
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ExtrinsicObject:WSDL',NULL,'urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ExtrinsicObject:WSDL','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1',NULL,'WSDL','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ExtrinsicObject','/urn:oasis:names:tc:ebxml-regrep:classificationScheme:ObjectType/RegistryObject/ExtrinsicObject/WSDL');
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ExtrinsicObject:WSDL:Binding',NULL,'urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ExtrinsicObject:WSDL:Binding','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1',NULL,'Binding','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ExtrinsicObject:WSDL','/urn:oasis:names:tc:ebxml-regrep:classificationScheme:ObjectType/RegistryObject/ExtrinsicObject/WSDL/Binding');
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ExtrinsicObject:WSDL:Port',NULL,'urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ExtrinsicObject:WSDL:Port','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1',NULL,'Port','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ExtrinsicObject:WSDL','/urn:oasis:names:tc:ebxml-regrep:classificationScheme:ObjectType/RegistryObject/ExtrinsicObject/WSDL/Port');
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ExtrinsicObject:WSDL:PortType',NULL,'urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ExtrinsicObject:WSDL:PortType','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1',NULL,'PortType','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ExtrinsicObject:WSDL','/urn:oasis:names:tc:ebxml-regrep:classificationScheme:ObjectType/RegistryObject/ExtrinsicObject/WSDL/PortType');
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ExtrinsicObject:WSDL:Service',NULL,'urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ExtrinsicObject:WSDL:Service','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1',NULL,'Service','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ExtrinsicObject:WSDL','/urn:oasis:names:tc:ebxml-regrep:classificationScheme:ObjectType/RegistryObject/ExtrinsicObject/WSDL/Service');
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ExtrinsicObject:XACML',NULL,'urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ExtrinsicObject:XACML','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1',NULL,'XACML','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ExtrinsicObject','/urn:oasis:names:tc:ebxml-regrep:classificationScheme:ObjectType/RegistryObject/ExtrinsicObject/XACML');
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ExtrinsicObject:XACML:Policy',NULL,'urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ExtrinsicObject:XACML:Policy','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1',NULL,'Policy','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ExtrinsicObject:XACML','/urn:oasis:names:tc:ebxml-regrep:classificationScheme:ObjectType/RegistryObject/ExtrinsicObject/XACML/Policy');
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ExtrinsicObject:XACML:PolicySet',NULL,'urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ExtrinsicObject:XACML:PolicySet','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1',NULL,'PolicySet','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ExtrinsicObject:XACML','/urn:oasis:names:tc:ebxml-regrep:classificationScheme:ObjectType/RegistryObject/ExtrinsicObject/XACML/PolicySet');
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ExtrinsicObject:XHTML',NULL,'urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ExtrinsicObject:XHTML','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1',NULL,'XHTML','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ExtrinsicObject','/urn:oasis:names:tc:ebxml-regrep:classificationScheme:ObjectType/RegistryObject/ExtrinsicObject/XHTML');
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ExtrinsicObject:XHTML:XForm',NULL,'urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ExtrinsicObject:XHTML:XForm','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1',NULL,'XForm','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ExtrinsicObject:XHTML','/urn:oasis:names:tc:ebxml-regrep:classificationScheme:ObjectType/RegistryObject/ExtrinsicObject/XHTML/XForm');
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ExtrinsicObject:XML',NULL,'urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ExtrinsicObject:XML','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1',NULL,'XML','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ExtrinsicObject','/urn:oasis:names:tc:ebxml-regrep:classificationScheme:ObjectType/RegistryObject/ExtrinsicObject/XML');
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ExtrinsicObject:XML:Schematron',NULL,'urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ExtrinsicObject:XML:Schematron','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1',NULL,'Schematron','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ExtrinsicObject','/urn:oasis:names:tc:ebxml-regrep:classificationScheme:ObjectType/RegistryObject/ExtrinsicObject/Schematron');
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ExtrinsicObject:XMLSchema',NULL,'urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ExtrinsicObject:XMLSchema','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1',NULL,'XMLSchema','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ExtrinsicObject','/urn:oasis:names:tc:ebxml-regrep:classificationScheme:ObjectType/RegistryObject/ExtrinsicObject/XMLSchema');
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ExtrinsicObject:XSLT',NULL,'urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ExtrinsicObject:XSLT','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1',NULL,'XSLT','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ExtrinsicObject','/urn:oasis:names:tc:ebxml-regrep:classificationScheme:ObjectType/RegistryObject/ExtrinsicObject/XSLT');
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:Federation',NULL,'urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:Federation','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1',NULL,'Federation','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject','/urn:oasis:names:tc:ebxml-regrep:classificationScheme:ObjectType/RegistryObject/Federation');
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:Notification',NULL,'urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:Notification','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1',NULL,'Notification','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject','/urn:oasis:names:tc:ebxml-regrep:classificationScheme:ObjectType/RegistryObject/Notification');
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:Organization',NULL,'urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:Organization','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1',NULL,'Organization','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject','/urn:oasis:names:tc:ebxml-regrep:classificationScheme:ObjectType/RegistryObject/Organization');
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:Person',NULL,'urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:Person','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1',NULL,'Person','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject','/urn:oasis:names:tc:ebxml-regrep:classificationScheme:ObjectType/RegistryObject/Person');
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:Person:User',NULL,'urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:Person:User','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1',NULL,'User','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:Person','/urn:oasis:names:tc:ebxml-regrep:classificationScheme:ObjectType/RegistryObject/Person/User');
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:Registry',NULL,'urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:Registry','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1',NULL,'Registry','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject','/urn:oasis:names:tc:ebxml-regrep:classificationScheme:ObjectType/RegistryObject/Registry');
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:RegistryPackage',NULL,'urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:RegistryPackage','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1',NULL,'RegistryPackage','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject','/urn:oasis:names:tc:ebxml-regrep:classificationScheme:ObjectType/RegistryObject/RegistryPackage');
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:Service',NULL,'urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:Service','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1',NULL,'Service','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject','/urn:oasis:names:tc:ebxml-regrep:classificationScheme:ObjectType/RegistryObject/Service');
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ServiceBinding',NULL,'urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ServiceBinding','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1',NULL,'ServiceBinding','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject','/urn:oasis:names:tc:ebxml-regrep:classificationScheme:ObjectType/RegistryObject/ServiceBinding');
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:SpecificationLink',NULL,'urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:SpecificationLink','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1',NULL,'SpecificationLink','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject','/urn:oasis:names:tc:ebxml-regrep:classificationScheme:ObjectType/RegistryObject/SpecificationLink');
  INSERT INTO CLASSIFICATIONNODE VALUES ('urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:Subscription',NULL,'urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:Subscription','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:ClassificationNode','urn:oasis:names:tc:ebxml-regrep:StatusType:Submitted','1.1',NULL,'Subscription','urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject','/urn:oasis:names:tc:ebxml-regrep:classificationScheme:ObjectType/RegistryObject/Subscription');
  
  