UPDATE METRIC_DEFINITION set xml='<metrics xmlns="http://www.cenqua.com/crucible/metrics-1">\n
    <comment>\n
    <!-- version 1 -->\n
        <field name="classification">\n
            <label>Classification</label>\n
            <type><integer/></type>\n
            <select>\n
                <option value="1">Missing</option>\n
                <option value="2">Extra (superfluous)</option>\n
                <option value="3">Ambiguous</option>\n
                <option value="4">Inconsistent</option>\n
                <option value="5" selected="true">Improvement desirable</option>\n
                <option value="6">Not conforming to standards</option>\n
                <option value="7">Risk-prone</option>\n
                <option value="8">Factually incorrect</option>\n
                <option value="9">Not implementable</option>\n
                <option value="10">Editorial</option>\n
            </select>\n
        </field>\n
        <field name="rank">\n
            <label>Ranking</label>\n
            <type><boolean/></type>\n
            <select>\n
                <option value="true">Major</option>\n
                <option value="false" selected="true">Minor</option>\n
            </select>\n
        </field>\n
    </comment>\n
</metrics>'\n
 where METRIC_ID=1;\n
UPDATE METRIC_DEFINITION set xml='<metrics xmlns="http://www.cenqua.com/crucible/metrics-1">\n
    <comment>\n
        <field name="classification">\n
            <label>Classification</label>\n
            <type><integer/></type>\n
            <select>\n
                <option value="1">Missing</option>\n
                <option value="2">Extra (superfluous)</option>\n
                <option value="3">Ambiguous</option>\n
                <option value="4">Inconsistent</option>\n
                <option value="5" selected="true">Improvement desirable</option>\n
                <option value="6">Not conforming to standards</option>\n
                <option value="7">Risk-prone</option>\n
                <option value="8">Factually incorrect</option>\n
                <option value="9">Not implementable</option>\n
                <option value="10">Editorial</option>\n
            </select>\n
        </field>\n
        <field name="rank">\n
            <label>Ranking</label>\n
            <type><boolean/></type>\n
            <select>\n
                <option value="true">Major</option>\n
                <option value="false" selected="true">Minor</option>\n
            </select>\n
        </field>\n
    </comment>\n
</metrics>'\n
 where METRIC_ID=2;\n
INSERT INTO METRIC_DEFINITION VALUES(3,'<metrics xmlns="http://www.cenqua.com/crucible/metrics-1">\n
    <comment>\n
        <field name="classification">\n
            <label>Classification</label>\n
            <type><integer/></type>\n
            <select>\n
                <option value="1">Missing</option>\n
                <option value="2">Extra (superfluous)</option>\n
                <option value="3">Ambiguous</option>\n
                <option value="4">Inconsistent</option>\n
                <option value="5" selected="true">Improvement desirable</option>\n
                <option value="6">Not conforming to standards</option>\n
                <option value="7">Risk-prone</option>\n
                <option value="8">Factually incorrect</option>\n
                <option value="9">Not implementable</option>\n
                <option value="10">Editorial</option>\n
            </select>\n
        </field>\n
        <field name="rank">\n
            <label>Ranking</label>\n
            <type><integer/></type>\n
            <select>\n
                <option value="1">Major</option>\n
                <option value="0" selected="true">Minor</option>\n
            </select>\n
        </field>\n
    </comment>\n
</metrics>')\n
UPDATE CRUVERSION SET version = 15 WHERE version_id = 1;