[Phpmyadmin-devel] Suggestions for Import/Export Changes

[Sebastian Mendel]

Hi,

On 01.07.2009 10:32, Michal Čihař wrote:
>> Second, I would like to propose a new XML export format to better
>> support my new import features. This new format will present the
>> option to export the SQL creation code for each of the exported tables
>> in the manner outlined below:
>>
>> <?xml version="1.0" encoding="utf-8" ?>
>> <!--
>> -
>> - phpMyAdmin XML Dump
>> - ... etc. etc. etc.
>> -->
>>
>> <pma_xml_export version="1.0"
>> xmlns:pma="http://www.phpmyadmin.net/some_doc_url/">
>>      <pma:structure>
>>          <pma:db_name>
>>              <pma:tbl_name_1>CREATE TABLE `tbl_name_1`...</pma:tbl_name_1>
>
> Please make it proper XML then and do not (re)introduce variable tag
> names.
>
> <pma:structure>
>    <pma:db name="databaze">
>       <pma:table name="tabulka">CREATE...</pma:table>
>       ...
>       <pma:view name="pohled">CREATE...</pma:view>
>       <pma:trigger name="procedura">...</pma:trigger>
>    </pma:db>
> </pma:structure>


will something like the following be too difficult? or inadequate for 
the purpose of the export?

<pma:structure>
   <pma:db name="databaze">
      <pma:table name="tabulka" engine="MyISAM">
        <pma:field name="myfield" type="int(11)" .../>
        <pma:index name="myindex" type="BTREE" ...>
          <pma:field name="myfield" length="255"/>
        </pma:index>
      </pma:table>
      ...
      <pma:view name="pohled">CREATE...</pma:view>
      <pma:trigger name="procedura">...</pma:trigger>
   </pma:db>
</pma:structure>

-- 
Sebastian Mendel