Differences

This shows you the differences between two versions of the page.

--- v6:axmls:axmls_index [2020/09/22 15:27] – created - external edit 127.0.0.1
+++ v6:axmls:axmls_index [2026/08/31 12:15] (current) – [Introduction] mnewnham
@@ Line 22: / Line 22: @@
 ------------------------------
+===== Feature Added In V6 =====
+==== Comments ====
+The XML Schema now supports the **comment** attribute, on table, index and column. If not supported by the DBMS, the tag is silently ignored. The comment is written into the database using the appropriate methodology
+<code xml>
+<?xml version="1.0"?>
+<schema version="0.3">
+    <table name="xml_schema_test">
+        <opt platform="mysql">ENGINE=INNODB</opt>
+        <comment>XML Schema Test Table</comment>
+        <field name="id" type="I">
+            <descr>A unique ID assigned to each record.</descr>
+            <KEY/>
+            <AUTOINCREMENT/>
+        </field>
+        <field name="nvarchar_field" type="C2" size="120"><NOTNULL/></field>
+        <field name="integer_field" type="I4">
+            <default value="999"/>
+        </field>
+        <index name="idx_0">
+            <comment>Index comment for index idx_0</comment>
+            <col>integer_field</col>
+            <UNIQUE/>
+        </index>
+        <index name="idx_1">
+            <comment>Index comment for index idx_1</comment>
+            <col>nvarchar_field</col>
+            <UNIQUE/>
+        </index>
+    </table>
+</schema>
+</code>
 <WRAP right box 200px>