Hello Sebastian,
Thank you for the advice.
I had considered such a schema (as it is more akin to proper XML), but ultimately I decided against it on the grounds that the plug-in supports the export of database, table, view, trigger, function, and procedure schemas. The problem is that between all of those there are simply too many options to manually account for.
Therefore, I chose a hybrid schema that can be seen here: http://www.moonlapse.org/?p=472
I'm still open to suggestions, though. The above schema is merely what I am currently using.
-Derek Schaefer
On Mon, Jul 6, 2009 at 1:46 AM, Sebastian Mendellists@sebastianmendel.de wrote:
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/%22%3E pma:structure pma:db_name pma:tbl_name_1CREATE 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
Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel