1 files changed, 27 insertions, 0 deletions
diff --git a/setup/exportdb.php b/setup/exportdb.php
new file mode 100644
index 0000000..fd714a3
--- /dev/null
+++ b/setup/exportdb.php
@@ -0,0 +1,27 @@
+<?php
+ 
+error_reporting(E_ALL);
+
+die('Enable me by commenting this out by editing '.basename(__FILE__).' at line '.__LINE__);
+
+require_once '../vendor/adodb/adodb-php/adodb.inc.php';
+require_once '../vendor/adodb/adodb-php/adodb-xmlschema03.inc.php';
+
+$conf = @parse_ini_file('../flyspray.conf.php', true) or die('Cannot open config file.');
+
+/* Start by creating a normal ADODB connection. */
+$db = ADONewConnection($conf['database']['dbtype']);
+$db->Connect( $conf['database']['dbhost'], $conf['database']['dbuser'],
+              $conf['database']['dbpass'], $conf['database']['dbname']) or die('Cannot connect to DB.');
+$db->debug= true;
+
+/* Use the database connection to create a new adoSchema object. */
+$schema = new adoSchema($db);
+
+$withdata=false;
+$stripprefix=true;
+$data = $schema->ExtractSchema( $withdata, '  ', $conf['database']['dbprefix'], $stripprefix);
+
+file_put_contents('flyspray-schema.xml', $data);
+
+?>