#23 Request for Multiple Table Options (XMLSchema 03).

[TheMightyDude]

Hello John

I am one of the Main Developers to Blacknova Traders and i was wondering is
there any chance in ADODB supporting multiple Table options example shown
below:

<?xml version="1.0"?>
<schema version="0.3">
<table name="tablename">
<!-- <opt>Table Option</opt> -->
<opt name="engine">InnoDB</opt>
<opt name="comment">This is an example Table</opt>
<field name="field1" type="I4"><key/><autoincrement/></field>
<field name="field_desc" type="C" size="30"></field>
<field name="field2" type="I4"><notnull/><default value="0"/></field>
<index name="field1"><col>field1</col></index>
<index name="field2"><col>field2</col></index>
</table>
</schema>

I am trying to set the Engine Type and also add a Comment to the Table and
for me to do this at the moment I have to use the following line:
<table name="tablename">
<opt>ENGINE="InnoDB", COMMENT="This is an example Table"</opt>
...

Or am I missing somthing?

Thanks in advance
Paul Kirby

[TheMightyDude]

Patch to add multi Options

[TheMightyDude]

There is most prob a better way to do this but this works for me :)

I have attached a patch that enables you have multi table options layed out like the following:

<?xml version="1.0"?>
<schema version="0.3">
<table name="test_table">
<opt name="engine">InnoDB</opt>
<opt name="comment">This is an example Test Table</opt>
...
</table>
</schema>

It also allows you to use the original way of doing it shown below:
<?xml version="1.0"?>
<schema version="0.3">
<table name="test_table">
<opt>ENGINE="InnoDB" COMMENT="This is an example Test Table"</opt>
...
</table>
</schema>

[TheMightyDude]

Oh, forgot to mention this is for version adodb508a.