Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Syntax error or access violation: 1305 SAVEPOINT DOCTRINE2_SAVEPOINT_2 does not exist #58

Closed
whyte624 opened this issue May 11, 2018 · 18 comments

Comments

@whyte624
Copy link

Do you have any idea, what could cause this problem?

Uncaught PHP Exception Doctrine\DBAL\Driver\PDOException: "SQLSTATE[42000]: Syntax error or access violation: 1305 SAVEPOINT DOCTRINE2_SAVEPOINT_2 does not exist"

Without your bundle there is no such problem. I'm using latest version.
Doctrine ORM v2.6.1

@dmaicher
Copy link
Owner

Unfortunately I will not be able to help without any more information 😉

  • can I see a full stack trace of the exception?
  • which queries are run exactly during that test case?

@soullivaneuh
Copy link
Contributor

can I see a full stack trace of the exception?

Here you go:

PHPUnit 6.5.8 by Sebastian Bergmann and contributors.

E

Time: 14.23 seconds, Memory: 36.00MB

There was 1 error:

1) Tests\AppBundle\Command\CreditCardExpirationCheckCommandTest::testCardWithNotificationNeeded
Doctrine\DBAL\Driver\PDOException: SQLSTATE[42000]: Syntax error or access violation: 1305 SAVEPOINT DOCTRINE2_SAVEPOINT_2 does not exist

/code/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:62
/code/vendor/dama/doctrine-test-bundle/src/DAMA/DoctrineTestBundle/Doctrine/DBAL/StaticConnection.php:59
/code/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1449
/code/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1385
/code/vendor/doctrine/orm/lib/Doctrine/ORM/EntityManager.php:242
/code/var/cache/test/Container1vrsjvd/EntityManager_9a5be93.php:62
/code/vendor/doctrine/data-fixtures/lib/Doctrine/Common/DataFixtures/Executor/ORMExecutor.php:73
/code/vendor/liip/functional-test-bundle/src/Services/DatabaseTools/ORMDatabaseTool.php:141
/code/vendor/liip/functional-test-bundle/src/Services/DatabaseTools/ORMDatabaseTool.php:80
/code/vendor/liip/functional-test-bundle/src/Services/DatabaseTools/AbstractDatabaseTool.php:135
/code/vendor/liip/functional-test-bundle/src/Test/WebTestCase.php:281
/code/tests/AppBundle/Controller/WebTestCase.php:35
/code/tests/AppBundle/Command/CreditCardExpirationCheckCommandTest.php:29

Caused by
PDOException: SQLSTATE[42000]: Syntax error or access violation: 1305 SAVEPOINT DOCTRINE2_SAVEPOINT_2 does not exist

/code/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:60
/code/vendor/dama/doctrine-test-bundle/src/DAMA/DoctrineTestBundle/Doctrine/DBAL/StaticConnection.php:59
/code/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1449
/code/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1385
/code/vendor/doctrine/orm/lib/Doctrine/ORM/EntityManager.php:242
/code/var/cache/test/Container1vrsjvd/EntityManager_9a5be93.php:62
/code/vendor/doctrine/data-fixtures/lib/Doctrine/Common/DataFixtures/Executor/ORMExecutor.php:73
/code/vendor/liip/functional-test-bundle/src/Services/DatabaseTools/ORMDatabaseTool.php:141
/code/vendor/liip/functional-test-bundle/src/Services/DatabaseTools/ORMDatabaseTool.php:80
/code/vendor/liip/functional-test-bundle/src/Services/DatabaseTools/AbstractDatabaseTool.php:135
/code/vendor/liip/functional-test-bundle/src/Test/WebTestCase.php:281
/code/tests/AppBundle/Controller/WebTestCase.php:35
/code/tests/AppBundle/Command/CreditCardExpirationCheckCommandTest.php:29

I don't know for the queries, but I have this error since some packages upgrade:

diff --git a/composer.json b/composer.json
index d838f035b..470b1cc56 100644
--- a/composer.json
+++ b/composer.json
@@ -68,7 +68,7 @@
         "guzzlehttp/guzzle": "^6.0",
         "hackzilla/password-generator": "^1.4",
         "hackzilla/password-generator-bundle": "^2.0",
-        "hautelook/alice-bundle": "^1.0",
+        "hautelook/alice-bundle": "^2.0",
         "incenteev/composer-parameter-handler": "^2.0",
         "influxdb/influxdb-php": "^1.14",
         "inlinestyle/inlinestyle": "^1.2",
@@ -87,7 +87,7 @@
         "misd/phone-number-bundle": "^1.2",
         "monolog/monolog": "^1.23",
         "mtdowling/cron-expression": "^1.1",
-        "nelmio/alice": "^2.0",
+        "nelmio/alice": "^3.3",
         "nelmio/api-doc-bundle": "^3.0",
         "nexylan/cloudflare": "dev-master",
         "nexylan/cloudflare-host-gw": "^0.1",
@@ -162,8 +162,7 @@
         "dama/doctrine-test-bundle": "^5.0",
         "doctrine/doctrine-fixtures-bundle": "^2.4",
         "jolicode/gif-exception-bundle": "^1.4",
-        "knplabs/friendly-contexts": "^0.8",
-        "liip/functional-test-bundle": "^1.9",
+        "liip/functional-test-bundle": "^2.0",
         "lookyman/phpstan-symfony": "^0.4.1",
         "phpdocumentor/reflection-docblock": "^3.2.3",
         "phpstan/phpstan-doctrine": "^0.9.1",
diff --git a/composer.lock b/composer.lock
index eb94d50b7..1a935f6b5 100644
--- a/composer.lock
+++ b/composer.lock
@@ -1,10 +1,10 @@
 {
     "_readme": [
         "This file locks the dependencies of your project to a known state",
-        "Read more about it at https://getcomposer.org/doc/01-basic-usage.md#composer-lock-the-lock-file",
+        "Read more about it at https://getcomposer.org/doc/01-basic-usage.md#installing-dependencies",
         "This file is @generated automatically"
     ],
-    "content-hash": "10217f8c826558d605efaf889a1a43de",
+    "content-hash": "a72aa816fbf0441b0efd2c3ad52fc7db",
     "packages": [
         {
             "name": "a2lix/translation-form-bundle",
@@ -2870,44 +2870,36 @@
         },
         {
             "name": "hautelook/alice-bundle",
-            "version": "v1.4.1",
+            "version": "v2.0.0",
             "source": {
                 "type": "git",
                 "url": "https://github.com/hautelook/AliceBundle.git",
-                "reference": "058925945bccbc8776725fec9e8557aca9666d9c"
+                "reference": "b167479bec0662b4dcae1f44813b99ec7311db02"
             },
             "dist": {
                 "type": "zip",
-                "url": "https://api.github.com/repos/hautelook/AliceBundle/zipball/058925945bccbc8776725fec9e8557aca9666d9c",
-                "reference": "058925945bccbc8776725fec9e8557aca9666d9c",
+                "url": "https://api.github.com/repos/hautelook/AliceBundle/zipball/b167479bec0662b4dcae1f44813b99ec7311db02",
+                "reference": "b167479bec0662b4dcae1f44813b99ec7311db02",
                 "shasum": ""
             },
             "require": {
-                "nelmio/alice": "^2.1 < 2.2.0 || ^2.2.1",
-                "php": "^5.6||^7.0",
-                "symfony/finder": "^2.7||^3.0"
+                "nelmio/alice": "^3.1",
+                "php": "^7.1",
+                "psr/log": "^1.0",
+                "symfony/finder": "^3.3 || ^4.0",
+                "theofidry/alice-data-fixtures": "^1.0-rc1"
             },
             "require-dev": {
-                "doctrine/data-fixtures": "1.0.1",
-                "doctrine/doctrine-bundle": "^1.6.4",
-                "doctrine/doctrine-fixtures-bundle": "^2.2",
-                "doctrine/mongodb-odm": "^1.0",
-                "doctrine/mongodb-odm-bundle": "^3.0",
-                "doctrine/orm": "^2.4",
-                "phpunit/phpunit": "^5.6",
-                "sllh/php-cs-fixer-styleci-bridge": "^1.0",
-                "symfony/console": "^2.3||~3.0",
-                "symfony/framework-bundle": "^2.3||^3.0",
-                "symfony/phpunit-bridge": "^3.1",
-                "symfony/validator": "^2.3|^3.0",
-                "symfony/yaml": "^2.3||^3.0"
+                "doctrine/common": "^2.7.2",
+                "doctrine/data-fixtures": "^1.2",
+                "doctrine/doctrine-bundle": "^1.6.8",
+                "doctrine/orm": "^2.5.6",
+                "phpspec/prophecy": "^1.7",
+                "phpunit/phpunit": "^6.0",
+                "symfony/phpunit-bridge": "^3.3",
+                "symfony/symfony": "^3.3.10 || ^4.0"
             },
             "suggest": {
-                "doctrine/data-fixtures": "To use Doctrine fixtures loader",
-                "doctrine/doctrine-bundle": "To use Doctrine with Symfony",
-                "doctrine/mongodb-odm": "To use Doctrine MongoDB",
-                "doctrine/mongodb-odm-bundle": "To use Doctrine MongoDB with Symfony",
-                "doctrine/orm": "To use Doctrine ORM",
                 "theofidry/alice-bundle-extension": "Behat extension for HautelookAliceBundle"
             },
             "type": "symfony-bundle",
@@ -2915,6 +2907,7 @@
                 "branch-alias": {
                     "dev-master": "2.x-dev"
                 },
+                "bin-dir": "bin",
                 "sort-packages": true
             },
             "autoload": {
@@ -2937,7 +2930,7 @@
                     "homepage": "https://github.com/theofidry"
                 }
             ],
-            "description": "Symfony2 Bundle to manage fixtures with Alice and Faker.",
+            "description": "Symfony bundle to manage fixtures with Alice and Faker.",
             "keywords": [
                 "Fixture",
                 "alice",
@@ -2945,7 +2938,7 @@
                 "orm",
                 "symfony"
             ],
-            "time": "2016-11-04T08:48:00+00:00"
+            "time": "2017-12-17T18:24:52+00:00"
         },
         {
             "name": "incenteev/composer-parameter-handler",
@@ -4356,6 +4349,51 @@
             ],
             "time": "2017-01-23T04:29:33+00:00"
         },
+        {
+            "name": "myclabs/deep-copy",
+            "version": "1.7.0",
+            "source": {
+                "type": "git",
+                "url": "https://github.com/myclabs/DeepCopy.git",
+                "reference": "3b8a3a99ba1f6a3952ac2747d989303cbd6b7a3e"
+            },
+            "dist": {
+                "type": "zip",
+                "url": "https://api.github.com/repos/myclabs/DeepCopy/zipball/3b8a3a99ba1f6a3952ac2747d989303cbd6b7a3e",
+                "reference": "3b8a3a99ba1f6a3952ac2747d989303cbd6b7a3e",
+                "shasum": ""
+            },
+            "require": {
+                "php": "^5.6 || ^7.0"
+            },
+            "require-dev": {
+                "doctrine/collections": "^1.0",
+                "doctrine/common": "^2.6",
+                "phpunit/phpunit": "^4.1"
+            },
+            "type": "library",
+            "autoload": {
+                "psr-4": {
+                    "DeepCopy\\": "src/DeepCopy/"
+                },
+                "files": [
+                    "src/DeepCopy/deep_copy.php"
+                ]
+            },
+            "notification-url": "https://packagist.org/downloads/",
+            "license": [
+                "MIT"
+            ],
+            "description": "Create deep copies (clones) of your objects",
+            "keywords": [
+                "clone",
+                "copy",
+                "duplicate",
+                "object",
+                "object graph"
+            ],
+            "time": "2017-10-19T19:58:43+00:00"
+        },
         {
             "name": "namshi/jose",
             "version": "7.2.3",
@@ -4421,34 +4459,54 @@
         },
         {
             "name": "nelmio/alice",
-            "version": "v2.3.5",
+            "version": "v3.3.0",
             "source": {
                 "type": "git",
                 "url": "https://github.com/nelmio/alice.git",
-                "reference": "d780fdff10854d93010b4a027fab92b747b42586"
+                "reference": "ddcc459081434ac3a7a2bef2c8a78db49ba11e79"
             },
             "dist": {
                 "type": "zip",
-                "url": "https://api.github.com/repos/nelmio/alice/zipball/d780fdff10854d93010b4a027fab92b747b42586",
-                "reference": "d780fdff10854d93010b4a027fab92b747b42586",
+                "url": "https://api.github.com/repos/nelmio/alice/zipball/ddcc459081434ac3a7a2bef2c8a78db49ba11e79",
+                "reference": "ddcc459081434ac3a7a2bef2c8a78db49ba11e79",
                 "shasum": ""
             },
             "require": {
-                "fzaninotto/faker": "^1.5",
-                "php": "^5.6||^7.0",
-                "symfony/yaml": "^2.0||^3.0"
+                "fzaninotto/faker": "^1.6",
+                "myclabs/deep-copy": "^1.5.2",
+                "php": "^7.1",
+                "symfony/property-access": "^2.8 || ^3.4 || ^4.0",
+                "symfony/yaml": "^2.8 || ^3.4 || ^4.0"
+            },
+            "conflict": {
+                "symfony/framework-bundle": "<3.4"
             },
             "require-dev": {
-                "doctrine/common": "^2.3",
-                "phpspec/prophecy": "^1.5.0",
-                "phpunit/phpunit": "^5.6||^6.0",
-                "symfony/phpunit-bridge": "^3.0",
-                "symfony/property-access": "^2.2||^3.0"
+                "bamarni/composer-bin-plugin": "^1.1.0",
+                "php-mock/php-mock": "^2.0",
+                "phpspec/prophecy": "^1.6",
+                "phpunit/phpunit": "^7.0",
+                "symfony/phpunit-bridge": "^3.4.5 || ^4.0.5",
+                "symfony/var-dumper": "^3.4 || ^4.0"
+            },
+            "suggest": {
+                "theofidry/alice-data-fixtures": "Wrapper for Alice to provide a persistence layer."
             },
             "type": "library",
+            "extra": {
+                "bamarni-bin": {
+                    "bin-links": false
+                },
+                "branch-alias": {
+                    "dev-master": "3.1.0-dev"
+                }
+            },
             "autoload": {
+                "files": [
+                    "src/deep_clone.php"
+                ],
                 "psr-4": {
-                    "Nelmio\\Alice\\": "src/Nelmio/Alice"
+                    "Nelmio\\Alice\\": "src"
                 }
             },
             "notification-url": "https://packagist.org/downloads/",
@@ -4465,7 +4523,7 @@
                     "email": "[email protected]"
                 },
                 {
-                    "name": "Théo FIDRY",
+                    "name": "Théo Fidry",
                     "email": "[email protected]"
                 }
             ],
@@ -4473,10 +4531,10 @@
             "keywords": [
                 "Fixture",
                 "data",
-                "orm",
+                "faker",
                 "test"
             ],
-            "time": "2018-04-07T09:33:52+00:00"
+            "time": "2018-04-07T09:07:10+00:00"
         },
         {
             "name": "nelmio/api-doc-bundle",
@@ -8411,7 +8469,7 @@
         },
         {
             "name": "symfony/class-loader",
-            "version": "v3.4.8",
+            "version": "v3.4.9",
             "source": {
                 "type": "git",
                 "url": "https://github.com/symfony/class-loader.git",
@@ -9133,25 +9191,25 @@
         },
         {
             "name": "symfony/finder",
-            "version": "v3.4.8",
+            "version": "v4.0.9",
             "source": {
                 "type": "git",
                 "url": "https://github.com/symfony/finder.git",
-                "reference": "bd14efe8b1fabc4de82bf50dce62f05f9a102433"
+                "reference": "ca27c02b7a3fef4828c998c2ff9ba7aae1641c49"
             },
             "dist": {
                 "type": "zip",
-                "url": "https://api.github.com/repos/symfony/finder/zipball/bd14efe8b1fabc4de82bf50dce62f05f9a102433",
-                "reference": "bd14efe8b1fabc4de82bf50dce62f05f9a102433",
+                "url": "https://api.github.com/repos/symfony/finder/zipball/ca27c02b7a3fef4828c998c2ff9ba7aae1641c49",
+                "reference": "ca27c02b7a3fef4828c998c2ff9ba7aae1641c49",
                 "shasum": ""
             },
             "require": {
-                "php": "^5.5.9|>=7.0.8"
+                "php": "^7.1.3"
             },
             "type": "library",
             "extra": {
                 "branch-alias": {
-                    "dev-master": "3.4-dev"
+                    "dev-master": "4.0-dev"
                 }
             },
             "autoload": {
@@ -9178,7 +9236,7 @@
             ],
             "description": "Symfony Finder Component",
             "homepage": "https://symfony.com",
-            "time": "2018-04-04T05:07:11+00:00"
+            "time": "2018-04-04T05:10:37+00:00"
         },
         {
             "name": "symfony/flex",
@@ -11329,6 +11387,79 @@
             "homepage": "https://symfony.com",
             "time": "2018-04-03T05:14:20+00:00"
         },
+        {
+            "name": "theofidry/alice-data-fixtures",
+            "version": "v1.0.1",
+            "source": {
+                "type": "git",
+                "url": "https://github.com/theofidry/AliceDataFixtures.git",
+                "reference": "5752bbf979a012bb804c00641478d4d3f879e51d"
+            },
+            "dist": {
+                "type": "zip",
+                "url": "https://api.github.com/repos/theofidry/AliceDataFixtures/zipball/5752bbf979a012bb804c00641478d4d3f879e51d",
+                "reference": "5752bbf979a012bb804c00641478d4d3f879e51d",
+                "shasum": ""
+            },
+            "require": {
+                "nelmio/alice": "^3.1",
+                "php": "^7.1",
+                "psr/log": "^1.0"
+            },
+            "require-dev": {
+                "bamarni/composer-bin-plugin": "^1.1",
+                "phpspec/prophecy": "^1.7",
+                "phpunit/phpunit": "^6.0",
+                "symfony/phpunit-bridge": "^3.3.2 || ^4.0"
+            },
+            "suggest": {
+                "alcaeus/mongo-php-adapter": "To use Doctrine with the MongoDB flavour",
+                "doctrine/data-fixtures": "To use Doctrine",
+                "doctrine/dbal": "To use Doctrine with the PHPCR flavour",
+                "doctrine/mongodb": "To use Doctrine with the MongoDB flavour",
+                "doctrine/mongodb-odm": "To use Doctrine with the MongoDB flavour",
+                "doctrine/orm": "To use Doctrine ORM",
+                "doctrine/phpcr-odm": "To use Doctrine with the PHPCR flavour",
+                "illuminate/database": "To use Eloquent",
+                "jackalope/jackalope-doctrine-dbal": "To use Doctrine with the PHPCR flavour",
+                "ocramius/proxy-manager": "To avoid database connection on kernel boot"
+            },
+            "type": "library",
+            "extra": {
+                "bamarni-bin": {
+                    "bin-links": false
+                },
+                "branch-alias": {
+                    "dev-master": "1.x-dev"
+                }
+            },
+            "autoload": {
+                "psr-4": {
+                    "Fidry\\AliceDataFixtures\\": "src"
+                }
+            },
+            "notification-url": "https://packagist.org/downloads/",
+            "license": [
+                "MIT"
+            ],
+            "authors": [
+                {
+                    "name": "Théo FIDRY",
+                    "email": "[email protected]",
+                    "homepage": "https://github.com/theofidry"
+                }
+            ],
+            "description": "Nelmio alice extension to persist the loaded fixtures.",
+            "keywords": [
+                "Fixture",
+                "alice",
+                "data",
+                "faker",
+                "orm",
+                "tests"
+            ],
+            "time": "2017-12-21T21:36:53+00:00"
+        },
         {
             "name": "tilleuls/ovh-bundle",
             "version": "v1.0.1",
@@ -12343,26 +12474,29 @@
         },
         {
             "name": "doctrine/data-fixtures",
-            "version": "v1.3.0",
+            "version": "v1.3.1",
             "source": {
                 "type": "git",
                 "url": "https://github.com/doctrine/data-fixtures.git",
-                "reference": "7b76ccc8e648c4502aad7f61347326c8a072bd3b"
+                "reference": "3a1e2c3c600e615a2dffe56d4ca0875cc5233e0a"
             },
             "dist": {
                 "type": "zip",
-                "url": "https://api.github.com/repos/doctrine/data-fixtures/zipball/7b76ccc8e648c4502aad7f61347326c8a072bd3b",
-                "reference": "7b76ccc8e648c4502aad7f61347326c8a072bd3b",
+                "url": "https://api.github.com/repos/doctrine/data-fixtures/zipball/3a1e2c3c600e615a2dffe56d4ca0875cc5233e0a",
+                "reference": "3a1e2c3c600e615a2dffe56d4ca0875cc5233e0a",
                 "shasum": ""
             },
             "require": {
                 "doctrine/common": "~2.2",
                 "php": "^7.1"
             },
+            "conflict": {
+                "doctrine/phpcr-odm": "<1.3.0"
+            },
             "require-dev": {
                 "doctrine/dbal": "^2.5.4",
                 "doctrine/orm": "^2.5.4",
-                "phpunit/phpunit": "^6.3"
+                "phpunit/phpunit": "^7.0"
             },
             "suggest": {
                 "alcaeus/mongo-php-adapter": "For using MongoDB ODM with PHP 7",
@@ -12396,7 +12530,7 @@
             "keywords": [
                 "database"
             ],
-            "time": "2017-11-27T18:48:06+00:00"
+            "time": "2018-03-20T09:06:36+00:00"
         },
         {
             "name": "doctrine/doctrine-fixtures-bundle",
@@ -12455,99 +12589,6 @@
             ],
             "time": "2017-10-30T19:26:42+00:00"
         },
-        {
-            "name": "guzzle/guzzle",
-            "version": "v3.8.1",
-            "source": {
-                "type": "git",
-                "url": "https://github.com/guzzle/guzzle.git",
-                "reference": "4de0618a01b34aa1c8c33a3f13f396dcd3882eba"
-            },
-            "dist": {
-                "type": "zip",
-                "url": "https://api.github.com/repos/guzzle/guzzle/zipball/4de0618a01b34aa1c8c33a3f13f396dcd3882eba",
-                "reference": "4de0618a01b34aa1c8c33a3f13f396dcd3882eba",
-                "shasum": ""
-            },
-            "require": {
-                "ext-curl": "*",
-                "php": ">=5.3.3",
-                "symfony/event-dispatcher": ">=2.1"
-            },
-            "replace": {
-                "guzzle/batch": "self.version",
-                "guzzle/cache": "self.version",
-                "guzzle/common": "self.version",
-                "guzzle/http": "self.version",
-                "guzzle/inflection": "self.version",
-                "guzzle/iterator": "self.version",
-                "guzzle/log": "self.version",
-                "guzzle/parser": "self.version",
-                "guzzle/plugin": "self.version",
-                "guzzle/plugin-async": "self.version",
-                "guzzle/plugin-backoff": "self.version",
-                "guzzle/plugin-cache": "self.version",
-                "guzzle/plugin-cookie": "self.version",
-                "guzzle/plugin-curlauth": "self.version",
-                "guzzle/plugin-error-response": "self.version",
-                "guzzle/plugin-history": "self.version",
-                "guzzle/plugin-log": "self.version",
-                "guzzle/plugin-md5": "self.version",
-                "guzzle/plugin-mock": "self.version",
-                "guzzle/plugin-oauth": "self.version",
-                "guzzle/service": "self.version",
-                "guzzle/stream": "self.version"
-            },
-            "require-dev": {
-                "doctrine/cache": "*",
-                "monolog/monolog": "1.*",
-                "phpunit/phpunit": "3.7.*",
-                "psr/log": "1.0.*",
-                "symfony/class-loader": "*",
-                "zendframework/zend-cache": "<2.3",
-                "zendframework/zend-log": "<2.3"
-            },
-            "type": "library",
-            "extra": {
-                "branch-alias": {
-                    "dev-master": "3.8-dev"
-                }
-            },
-            "autoload": {
-                "psr-0": {
-                    "Guzzle": "src/",
-                    "Guzzle\\Tests": "tests/"
-                }
-            },
-            "notification-url": "https://packagist.org/downloads/",
-            "license": [
-                "MIT"
-            ],
-            "authors": [
-                {
-                    "name": "Michael Dowling",
-                    "email": "[email protected]",
-                    "homepage": "https://github.com/mtdowling"
-                },
-                {
-                    "name": "Guzzle Community",
-                    "homepage": "https://github.com/guzzle/guzzle/contributors"
-                }
-            ],
-            "description": "Guzzle is a PHP HTTP client library and framework for building RESTful web service clients",
-            "homepage": "http://guzzlephp.org/",
-            "keywords": [
-                "client",
-                "curl",
-                "framework",
-                "http",
-                "http client",
-                "rest",
-                "web service"
-            ],
-            "abandoned": "guzzlehttp/guzzle",
-            "time": "2014-01-28T22:29:15+00:00"
-        },
         {
             "name": "instaclick/php-webdriver",
             "version": "1.4.5",
@@ -12665,99 +12706,38 @@
             ],
             "time": "2017-12-24T10:57:33+00:00"
         },
-        {
-            "name": "knplabs/friendly-contexts",
-            "version": "0.8.2",
-            "source": {
-                "type": "git",
-                "url": "https://github.com/KnpLabs/FriendlyContexts.git",
-                "reference": "ed6f1d890ea02cf56be503d3a8843be20f4683f6"
-            },
-            "dist": {
-                "type": "zip",
-                "url": "https://api.github.com/repos/KnpLabs/FriendlyContexts/zipball/ed6f1d890ea02cf56be503d3a8843be20f4683f6",
-                "reference": "ed6f1d890ea02cf56be503d3a8843be20f4683f6",
-                "shasum": ""
-            },
-            "require": {
-                "behat/behat": "~3.0",
-                "behat/mink-extension": "~2.0",
-                "doctrine/data-fixtures": "~1.0",
-                "doctrine/inflector": "~1.0",
-                "fzaninotto/faker": "~1.4",
-                "guzzle/guzzle": "~3.7",
-                "nelmio/alice": "~2.0",
-                "php": ">=5.4.0",
-                "symfony/property-access": "~2.3|~3.0"
-            },
-            "require-dev": {
-                "doctrine/orm": "~2.5",
-                "knplabs/phpspec-welldone-extension": "dev-master",
-                "phpspec/phpspec": "~2.4|~3.0"
-            },
-            "type": "library",
-            "autoload": {
-                "psr-0": {
-                    "Knp\\FriendlyContexts": "src/"
-                }
-            },
-            "notification-url": "https://packagist.org/downloads/",
-            "license": [
-                "MIT"
-            ],
-            "authors": [
-                {
-                    "name": "Knplabs",
-                    "homepage": "http://knplabs.com"
-                },
-                {
-                    "name": "PedroTroller",
-                    "homepage": "https://github.com/PedroTroller"
-                }
-            ],
-            "description": "Some BEHAT contexts",
-            "time": "2017-04-19T20:40:11+00:00"
-        },
         {
             "name": "liip/functional-test-bundle",
-            "version": "1.9.5",
+            "version": "2.0.0-alpha4",
             "source": {
                 "type": "git",
                 "url": "https://github.com/liip/LiipFunctionalTestBundle.git",
-                "reference": "4cf646747fa32710621b4f22922b3790767df847"
+                "reference": "321db8392c1ec151959d166208e6df3b22461b43"
             },
             "dist": {
                 "type": "zip",
-                "url": "https://api.github.com/repos/liip/LiipFunctionalTestBundle/zipball/4cf646747fa32710621b4f22922b3790767df847",
-                "reference": "4cf646747fa32710621b4f22922b3790767df847",
+                "url": "https://api.github.com/repos/liip/LiipFunctionalTestBundle/zipball/321db8392c1ec151959d166208e6df3b22461b43",
+                "reference": "321db8392c1ec151959d166208e6df3b22461b43",
                 "shasum": ""
             },
             "require": {
-                "doctrine/common": "~2.0",
-                "php": "^5.6|^7.0",
-                "symfony/browser-kit": "^2.7|^3.0",
-                "symfony/framework-bundle": "^2.7|^3.0"
-            },
-            "conflict": {
-                "phpunit/phpunit": ">=7"
+                "doctrine/common": "^2.0",
+                "php": "^7.1",
+                "symfony/browser-kit": "^3.4 || ^4.0",
+                "symfony/framework-bundle": "^3.4 || ^4.0"
             },
             "require-dev": {
-                "brianium/paratest": "~0.12.0|~0.13.2",
-                "doctrine/data-fixtures": "1.2.2",
-                "doctrine/doctrine-fixtures-bundle": "~2.3",
-                "doctrine/orm": "~2.5",
-                "doctrine/phpcr-bundle": "~1.3",
-                "doctrine/phpcr-odm": "~1.3",
-                "hautelook/alice-bundle": "~0.2|~1.2",
-                "jackalope/jackalope-doctrine-dbal": "1.1.*|1.2.*",
-                "nelmio/alice": "~1.7|~2.0",
-                "phpunit/phpunit": "^4.8.35|^5.7|^6.1",
-                "symfony/assetic-bundle": "^2.7|^3.0",
-                "symfony/console": "^2.7|^3.0",
-                "symfony/monolog-bundle": "^2.7|^3.0",
-                "symfony/phpunit-bridge": "^2.7|^3.0",
-                "symfony/symfony": "^2.7.1|^3.3",
-                "twig/twig": "~1.12|~2.0"
+                "doctrine/data-fixtures": "^1.3",
+                "doctrine/doctrine-bundle": "^1.8",
+                "doctrine/doctrine-fixtures-bundle": "^3.0",
+                "doctrine/orm": "^2.5",
+                "jackalope/jackalope-doctrine-dbal": "^1.3",
+                "phpunit/phpunit": "^6.1|^7.0",
+                "symfony/monolog-bundle": "^3.1",
+                "symfony/phpunit-bridge": "^3.4 || ^4.0",
+                "symfony/symfony": "^3.4 || ^4.0",
+                "theofidry/alice-data-fixtures": "^1.0.1",
+                "twig/twig": "^2.0"
             },
             "suggest": {
                 "brianium/paratest": "Required when using paratest to parallelize tests",
@@ -12765,17 +12745,18 @@
                 "doctrine/doctrine-fixtures-bundle": "Required when using the fixture loading functionality",
                 "doctrine/orm": "Required when using the fixture loading functionality with an ORM and SQLite",
                 "hautelook/alice-bundle": "Required when using loadFixtureFiles functionality with custom providers",
-                "nelmio/alice": "Required when using loadFixtureFiles functionality"
+                "nelmio/alice": "Required when using loadFixtureFiles functionality",
+                "symfony/framework-bundle": "To use assertStatusCode and assertValidationErrors ~2.5"
             },
             "type": "symfony-bundle",
             "extra": {
                 "branch-alias": {
-                    "dev-master": "1.x-dev"
+                    "dev-master": "2.x-dev"
                 }
             },
             "autoload": {
                 "psr-4": {
-                    "Liip\\FunctionalTestBundle\\": ""
+                    "Liip\\FunctionalTestBundle\\": "src/"
                 }
             },
             "notification-url": "https://packagist.org/downloads/",
@@ -12796,7 +12777,7 @@
             "keywords": [
                 "Symfony2"
             ],
-            "time": "2018-03-25T15:56:30+00:00"
+            "time": "2018-03-06T22:11:23+00:00"
         },
         {
             "name": "lookyman/phpstan-symfony",
@@ -12848,51 +12829,6 @@
             ],
             "time": "2018-01-18T10:20:29+00:00"
         },
-        {
-            "name": "myclabs/deep-copy",
-            "version": "1.7.0",
-            "source": {
-                "type": "git",
-                "url": "https://github.com/myclabs/DeepCopy.git",
-                "reference": "3b8a3a99ba1f6a3952ac2747d989303cbd6b7a3e"
-            },
-            "dist": {
-                "type": "zip",
-                "url": "https://api.github.com/repos/myclabs/DeepCopy/zipball/3b8a3a99ba1f6a3952ac2747d989303cbd6b7a3e",
-                "reference": "3b8a3a99ba1f6a3952ac2747d989303cbd6b7a3e",
-                "shasum": ""
-            },
-            "require": {
-                "php": "^5.6 || ^7.0"
-            },
-            "require-dev": {
-                "doctrine/collections": "^1.0",
-                "doctrine/common": "^2.6",
-                "phpunit/phpunit": "^4.1"
-            },
-            "type": "library",
-            "autoload": {
-                "psr-4": {
-                    "DeepCopy\\": "src/DeepCopy/"
-                },
-                "files": [
-                    "src/DeepCopy/deep_copy.php"
-                ]
-            },
-            "notification-url": "https://packagist.org/downloads/",
-            "license": [
-                "MIT"
-            ],
-            "description": "Create deep copies (clones) of your objects",
-            "keywords": [
-                "clone",
-                "copy",
-                "duplicate",
-                "object",
-                "object graph"
-            ],
-            "time": "2017-10-19T19:58:43+00:00"
-        },
         {
             "name": "phar-io/manifest",
             "version": "1.0.1",

I'm still investigating. But do you have any clue of how this error may happen?

@soullivaneuh
Copy link
Contributor

@dmaicher Maybe do you also have a simple way to list all the doctrine queries done on PHPUnit before the crash?

@soullivaneuh
Copy link
Contributor

Here is a more condensed composer changes between my working master branch and the broken one:

Package operations: 1 install, 6 updates, 2 removals
  - Removing guzzle/guzzle (v3.8.1)
  - Removing knplabs/friendly-contexts (0.8.2)
  - Updating nelmio/alice (v2.3.5 => v3.3.0): Loading from cache
  - Installing theofidry/alice-data-fixtures (v1.0.1): Loading from cache
  - Updating symfony/finder (v3.4.8 => v4.0.9): Loading from cache
  - Updating hautelook/alice-bundle (v1.4.1 => v2.0.0): Loading from cache
  - Updating symfony/class-loader (v3.4.8 => v3.4.9): Loading from cache
  - Updating doctrine/data-fixtures (v1.3.0 => v1.3.1): Loading from cache
  - Updating liip/functional-test-bundle (1.9.5 => 2.0.0-alpha4): Loading from cache

@dmaicher
Copy link
Owner

Thanks! I will try to have a look on the weekend and see if I can reproduce it somehow on this test project https://github.com/dmaicher/doctrine-test-bundle-demo where I also use doctrine data fixtures

@soullivaneuh
Copy link
Contributor

Thanks @dmaicher. I'm pretty sure it's related to the data fixtures but I can't find where is the issue for now.

@soullivaneuh
Copy link
Contributor

soullivaneuh commented May 18, 2018

@dmaicher I found this documentation: https://github.com/theofidry/AliceDataFixtures#phpunit

And I tried with this configuration to be sure there is no TRUNCATE TABLE anywhere (in any case, the purge mode is delete by default, not truncate):

fidry_alice_data_fixtures:
    default_purge_mode: no_purge

But it changed nothing.

@theofidry if you have a bit of time for us, could you please confirm the way to go? Did you already run onto this kind of issue?

@soullivaneuh
Copy link
Contributor

I manage to get the executed queries until the crash:

180518 15:17:22	    1 Connect	[email protected] on site_test
		    2 Connect	[email protected] on site_test
180518 15:17:23	    2 Quit	
		    1 Quit	
180518 15:17:28	    3 Connect	[email protected] on site_test
		    4 Connect	[email protected] on site_test
		    4 Query	START TRANSACTION
		    5 Connect	[email protected] on site_pdns_test
		    6 Connect	[email protected] on site_pdns_test
		    6 Query	START TRANSACTION
		    5 Quit	
		    3 Quit	
		    4 Query	SET FOREIGN_KEY_CHECKS=0
		    7 Connect	[email protected] on 
		    7 Query	SHOW DATABASES
		    7 Quit	
		    4 Query	SHOW FULL TABLES WHERE Table_type = 'BASE TABLE'
		    4 Query	SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'site_test' AND TABLE_NAME = 'access_token'
		    4 Query	SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'access_token' */ WHERE k.table_name = 'access_token' AND k.table_schema = 'site_test' /*!50116 AND c.constraint_schema = 'site_test' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
		    4 Query	SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'access_token' AND TABLE_SCHEMA = 'site_test'
		    4 Query	SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'site_test' AND TABLE_NAME = 'accounting'
		    4 Query	SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'accounting' */ WHERE k.table_name = 'accounting' AND k.table_schema = 'site_test' /*!50116 AND c.constraint_schema = 'site_test' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
		    4 Query	SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'accounting' AND TABLE_SCHEMA = 'site_test'
		    4 Query	SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'site_test' AND TABLE_NAME = 'accounting_accountant'
		    4 Query	SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'accounting_accountant' */ WHERE k.table_name = 'accounting_accountant' AND k.table_schema = 'site_test' /*!50116 AND c.constraint_schema = 'site_test' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
		    4 Query	SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'accounting_accountant' AND TABLE_SCHEMA = 'site_test'
		    4 Query	SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'site_test' AND TABLE_NAME = 'accounting_translation'
		    4 Query	SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'accounting_translation' */ WHERE k.table_name = 'accounting_translation' AND k.table_schema = 'site_test' /*!50116 AND c.constraint_schema = 'site_test' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
		    4 Query	SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'accounting_translation' AND TABLE_SCHEMA = 'site_test'
		    4 Query	SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'site_test' AND TABLE_NAME = 'alert'
		    4 Query	SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'alert' */ WHERE k.table_name = 'alert' AND k.table_schema = 'site_test' /*!50116 AND c.constraint_schema = 'site_test' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
		    4 Query	SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'alert' AND TABLE_SCHEMA = 'site_test'
		    4 Query	SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'site_test' AND TABLE_NAME = 'api_key'
		    4 Query	SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'api_key' */ WHERE k.table_name = 'api_key' AND k.table_schema = 'site_test' /*!50116 AND c.constraint_schema = 'site_test' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
		    4 Query	SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'api_key' AND TABLE_SCHEMA = 'site_test'
		    4 Query	SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'site_test' AND TABLE_NAME = 'auth_code'
		    4 Query	SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'auth_code' */ WHERE k.table_name = 'auth_code' AND k.table_schema = 'site_test' /*!50116 AND c.constraint_schema = 'site_test' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
		    4 Query	SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'auth_code' AND TABLE_SCHEMA = 'site_test'
		    4 Query	SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'site_test' AND TABLE_NAME = 'backup_model'
		    4 Query	SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'backup_model' */ WHERE k.table_name = 'backup_model' AND k.table_schema = 'site_test' /*!50116 AND c.constraint_schema = 'site_test' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
		    4 Query	SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'backup_model' AND TABLE_SCHEMA = 'site_test'
		    4 Query	SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'site_test' AND TABLE_NAME = 'bank_account'
		    4 Query	SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'bank_account' */ WHERE k.table_name = 'bank_account' AND k.table_schema = 'site_test' /*!50116 AND c.constraint_schema = 'site_test' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
		    4 Query	SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'bank_account' AND TABLE_SCHEMA = 'site_test'
		    4 Query	SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'site_test' AND TABLE_NAME = 'billing_note'
		    4 Query	SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'billing_note' */ WHERE k.table_name = 'billing_note' AND k.table_schema = 'site_test' /*!50116 AND c.constraint_schema = 'site_test' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
		    4 Query	SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'billing_note' AND TABLE_SCHEMA = 'site_test'
		    4 Query	SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'site_test' AND TABLE_NAME = 'changelog'
		    4 Query	SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'changelog' */ WHERE k.table_name = 'changelog' AND k.table_schema = 'site_test' /*!50116 AND c.constraint_schema = 'site_test' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
		    4 Query	SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'changelog' AND TABLE_SCHEMA = 'site_test'
		    4 Query	SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'site_test' AND TABLE_NAME = 'cloudflare_zone'
		    4 Query	SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'cloudflare_zone' */ WHERE k.table_name = 'cloudflare_zone' AND k.table_schema = 'site_test' /*!50116 AND c.constraint_schema = 'site_test' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
		    4 Query	SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'cloudflare_zone' AND TABLE_SCHEMA = 'site_test'
		    4 Query	SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'site_test' AND TABLE_NAME = 'country'
		    4 Query	SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'country' */ WHERE k.table_name = 'country' AND k.table_schema = 'site_test' /*!50116 AND c.constraint_schema = 'site_test' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
		    4 Query	SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'country' AND TABLE_SCHEMA = 'site_test'
		    4 Query	SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'site_test' AND TABLE_NAME = 'credit_card'
		    4 Query	SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'credit_card' */ WHERE k.table_name = 'credit_card' AND k.table_schema = 'site_test' /*!50116 AND c.constraint_schema = 'site_test' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
		    4 Query	SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'credit_card' AND TABLE_SCHEMA = 'site_test'
		    4 Query	SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'site_test' AND TABLE_NAME = 'credit_note'
		    4 Query	SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'credit_note' */ WHERE k.table_name = 'credit_note' AND k.table_schema = 'site_test' /*!50116 AND c.constraint_schema = 'site_test' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
		    4 Query	SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'credit_note' AND TABLE_SCHEMA = 'site_test'
		    4 Query	SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'site_test' AND TABLE_NAME = 'credit_note_item'
		    4 Query	SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'credit_note_item' */ WHERE k.table_name = 'credit_note_item' AND k.table_schema = 'site_test' /*!50116 AND c.constraint_schema = 'site_test' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
		    4 Query	SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'credit_note_item' AND TABLE_SCHEMA = 'site_test'
		    4 Query	SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'site_test' AND TABLE_NAME = 'cron'
		    4 Query	SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'cron' */ WHERE k.table_name = 'cron' AND k.table_schema = 'site_test' /*!50116 AND c.constraint_schema = 'site_test' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
		    4 Query	SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'cron' AND TABLE_SCHEMA = 'site_test'
		    4 Query	SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'site_test' AND TABLE_NAME = 'domain_name'
		    4 Query	SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'domain_name' */ WHERE k.table_name = 'domain_name' AND k.table_schema = 'site_test' /*!50116 AND c.constraint_schema = 'site_test' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
		    4 Query	SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'domain_name' AND TABLE_SCHEMA = 'site_test'
		    4 Query	SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'site_test' AND TABLE_NAME = 'email'
		    4 Query	SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'email' */ WHERE k.table_name = 'email' AND k.table_schema = 'site_test' /*!50116 AND c.constraint_schema = 'site_test' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
		    4 Query	SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'email' AND TABLE_SCHEMA = 'site_test'
		    4 Query	SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'site_test' AND TABLE_NAME = 'expense'
		    4 Query	SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'expense' */ WHERE k.table_name = 'expense' AND k.table_schema = 'site_test' /*!50116 AND c.constraint_schema = 'site_test' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
		    4 Query	SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'expense' AND TABLE_SCHEMA = 'site_test'
		    4 Query	SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'site_test' AND TABLE_NAME = 'expense_category'
		    4 Query	SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'expense_category' */ WHERE k.table_name = 'expense_category' AND k.table_schema = 'site_test' /*!50116 AND c.constraint_schema = 'site_test' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
		    4 Query	SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'expense_category' AND TABLE_SCHEMA = 'site_test'
		    4 Query	SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'site_test' AND TABLE_NAME = 'favorite'
		    4 Query	SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'favorite' */ WHERE k.table_name = 'favorite' AND k.table_schema = 'site_test' /*!50116 AND c.constraint_schema = 'site_test' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
		    4 Query	SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'favorite' AND TABLE_SCHEMA = 'site_test'
		    4 Query	SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'site_test' AND TABLE_NAME = 'fos_group'
		    4 Query	SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'fos_group' */ WHERE k.table_name = 'fos_group' AND k.table_schema = 'site_test' /*!50116 AND c.constraint_schema = 'site_test' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
		    4 Query	SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'fos_group' AND TABLE_SCHEMA = 'site_test'
		    4 Query	SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'site_test' AND TABLE_NAME = 'fos_user_login_action'
		    4 Query	SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'fos_user_login_action' */ WHERE k.table_name = 'fos_user_login_action' AND k.table_schema = 'site_test' /*!50116 AND c.constraint_schema = 'site_test' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
		    4 Query	SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'fos_user_login_action' AND TABLE_SCHEMA = 'site_test'
		    4 Query	SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'site_test' AND TABLE_NAME = 'ftp_account'
		    4 Query	SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'ftp_account' */ WHERE k.table_name = 'ftp_account' AND k.table_schema = 'site_test' /*!50116 AND c.constraint_schema = 'site_test' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
		    4 Query	SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'ftp_account' AND TABLE_SCHEMA = 'site_test'
		    4 Query	SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'site_test' AND TABLE_NAME = 'graylog_type'
		    4 Query	SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'graylog_type' */ WHERE k.table_name = 'graylog_type' AND k.table_schema = 'site_test' /*!50116 AND c.constraint_schema = 'site_test' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
		    4 Query	SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'graylog_type' AND TABLE_SCHEMA = 'site_test'
		    4 Query	SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'site_test' AND TABLE_NAME = 'hosting'
		    4 Query	SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'hosting' */ WHERE k.table_name = 'hosting' AND k.table_schema = 'site_test' /*!50116 AND c.constraint_schema = 'site_test' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
		    4 Query	SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'hosting' AND TABLE_SCHEMA = 'site_test'
		    4 Query	SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'site_test' AND TABLE_NAME = 'hosting_alias'
		    4 Query	SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'hosting_alias' */ WHERE k.table_name = 'hosting_alias' AND k.table_schema = 'site_test' /*!50116 AND c.constraint_schema = 'site_test' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
		    4 Query	SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'hosting_alias' AND TABLE_SCHEMA = 'site_test'
		    4 Query	SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'site_test' AND TABLE_NAME = 'hosting_sshkey'
		    4 Query	SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'hosting_sshkey' */ WHERE k.table_name = 'hosting_sshkey' AND k.table_schema = 'site_test' /*!50116 AND c.constraint_schema = 'site_test' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
		    4 Query	SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'hosting_sshkey' AND TABLE_SCHEMA = 'site_test'
		    4 Query	SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'site_test' AND TABLE_NAME = 'hosting_ssl_certificate'
		    4 Query	SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'hosting_ssl_certificate' */ WHERE k.table_name = 'hosting_ssl_certificate' AND k.table_schema = 'site_test' /*!50116 AND c.constraint_schema = 'site_test' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
		    4 Query	SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'hosting_ssl_certificate' AND TABLE_SCHEMA = 'site_test'
		    4 Query	SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'site_test' AND TABLE_NAME = 'incident'
		    4 Query	SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'incident' */ WHERE k.table_name = 'incident' AND k.table_schema = 'site_test' /*!50116 AND c.constraint_schema = 'site_test' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
		    4 Query	SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'incident' AND TABLE_SCHEMA = 'site_test'
		    4 Query	SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'site_test' AND TABLE_NAME = 'incident_comment'
		    4 Query	SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'incident_comment' */ WHERE k.table_name = 'incident_comment' AND k.table_schema = 'site_test' /*!50116 AND c.constraint_schema = 'site_test' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
		    4 Query	SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'incident_comment' AND TABLE_SCHEMA = 'site_test'
		    4 Query	SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'site_test' AND TABLE_NAME = 'influx_measurement_definition'
		    4 Query	SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'influx_measurement_definition' */ WHERE k.table_name = 'influx_measurement_definition' AND k.table_schema = 'site_test' /*!50116 AND c.constraint_schema = 'site_test' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
		    4 Query	SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'influx_measurement_definition' AND TABLE_SCHEMA = 'site_test'
		    4 Query	SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'site_test' AND TABLE_NAME = 'invoice'
		    4 Query	SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'invoice' */ WHERE k.table_name = 'invoice' AND k.table_schema = 'site_test' /*!50116 AND c.constraint_schema = 'site_test' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
		    4 Query	SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'invoice' AND TABLE_SCHEMA = 'site_test'
		    4 Query	SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'site_test' AND TABLE_NAME = 'invoice_item'
		    4 Query	SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'invoice_item' */ WHERE k.table_name = 'invoice_item' AND k.table_schema = 'site_test' /*!50116 AND c.constraint_schema = 'site_test' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
		    4 Query	SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'invoice_item' AND TABLE_SCHEMA = 'site_test'
		    4 Query	SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'site_test' AND TABLE_NAME = 'ip_group'
		    4 Query	SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'ip_group' */ WHERE k.table_name = 'ip_group' AND k.table_schema = 'site_test' /*!50116 AND c.constraint_schema = 'site_test' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
		    4 Query	SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'ip_group' AND TABLE_SCHEMA = 'site_test'
		    4 Query	SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'site_test' AND TABLE_NAME = 'ip_v4'
		    4 Query	SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'ip_v4' */ WHERE k.table_name = 'ip_v4' AND k.table_schema = 'site_test' /*!50116 AND c.constraint_schema = 'site_test' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
		    4 Query	SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'ip_v4' AND TABLE_SCHEMA = 'site_test'
		    4 Query	SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'site_test' AND TABLE_NAME = 'ip_v4_audit'
		    4 Query	SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'ip_v4_audit' */ WHERE k.table_name = 'ip_v4_audit' AND k.table_schema = 'site_test' /*!50116 AND c.constraint_schema = 'site_test' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
		    4 Query	SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'ip_v4_audit' AND TABLE_SCHEMA = 'site_test'
		    4 Query	SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'site_test' AND TABLE_NAME = 'ip_v6'
		    4 Query	SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'ip_v6' */ WHERE k.table_name = 'ip_v6' AND k.table_schema = 'site_test' /*!50116 AND c.constraint_schema = 'site_test' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
		    4 Query	SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'ip_v6' AND TABLE_SCHEMA = 'site_test'
		    4 Query	SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'site_test' AND TABLE_NAME = 'ip_v6_range'
		    4 Query	SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'ip_v6_range' */ WHERE k.table_name = 'ip_v6_range' AND k.table_schema = 'site_test' /*!50116 AND c.constraint_schema = 'site_test' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
		    4 Query	SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'ip_v6_range' AND TABLE_SCHEMA = 'site_test'
		    4 Query	SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'site_test' AND TABLE_NAME = 'mailalias'
		    4 Query	SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'mailalias' */ WHERE k.table_name = 'mailalias' AND k.table_schema = 'site_test' /*!50116 AND c.constraint_schema = 'site_test' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
		    4 Query	SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'mailalias' AND TABLE_SCHEMA = 'site_test'
		    4 Query	SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'site_test' AND TABLE_NAME = 'mailalias_destination'
		    4 Query	SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'mailalias_destination' */ WHERE k.table_name = 'mailalias_destination' AND k.table_schema = 'site_test' /*!50116 AND c.constraint_schema = 'site_test' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
		    4 Query	SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'mailalias_destination' AND TABLE_SCHEMA = 'site_test'
		    4 Query	SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'site_test' AND TABLE_NAME = 'mailbox'
		    4 Query	SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'mailbox' */ WHERE k.table_name = 'mailbox' AND k.table_schema = 'site_test' /*!50116 AND c.constraint_schema = 'site_test' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
		    4 Query	SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'mailbox' AND TABLE_SCHEMA = 'site_test'
		    4 Query	SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'site_test' AND TABLE_NAME = 'maintenance'
		    4 Query	SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'maintenance' */ WHERE k.table_name = 'maintenance' AND k.table_schema = 'site_test' /*!50116 AND c.constraint_schema = 'site_test' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
		    4 Query	SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'maintenance' AND TABLE_SCHEMA = 'site_test'
		    4 Query	SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'site_test' AND TABLE_NAME = 'maintenance_server'
		    4 Query	SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'maintenance_server' */ WHERE k.table_name = 'maintenance_server' AND k.table_schema = 'site_test' /*!50116 AND c.constraint_schema = 'site_test' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
		    4 Query	SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'maintenance_server' AND TABLE_SCHEMA = 'site_test'
		    4 Query	SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'site_test' AND TABLE_NAME = 'nagios_event'
		    4 Query	SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'nagios_event' */ WHERE k.table_name = 'nagios_event' AND k.table_schema = 'site_test' /*!50116 AND c.constraint_schema = 'site_test' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
		    4 Query	SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'nagios_event' AND TABLE_SCHEMA = 'site_test'
		    4 Query	SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'site_test' AND TABLE_NAME = 'news'
		    4 Query	SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'news' */ WHERE k.table_name = 'news' AND k.table_schema = 'site_test' /*!50116 AND c.constraint_schema = 'site_test' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
		    4 Query	SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'news' AND TABLE_SCHEMA = 'site_test'
		    4 Query	SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'site_test' AND TABLE_NAME = 'notification'
		    4 Query	SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'notification' */ WHERE k.table_name = 'notification' AND k.table_schema = 'site_test' /*!50116 AND c.constraint_schema = 'site_test' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
		    4 Query	SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'notification' AND TABLE_SCHEMA = 'site_test'
		    4 Query	SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'site_test' AND TABLE_NAME = 'oauth_client'
		    4 Query	SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'oauth_client' */ WHERE k.table_name = 'oauth_client' AND k.table_schema = 'site_test' /*!50116 AND c.constraint_schema = 'site_test' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
		    4 Query	SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'oauth_client' AND TABLE_SCHEMA = 'site_test'
		    4 Query	SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'site_test' AND TABLE_NAME = 'operation'
		    4 Query	SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'operation' */ WHERE k.table_name = 'operation' AND k.table_schema = 'site_test' /*!50116 AND c.constraint_schema = 'site_test' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
		    4 Query	SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'operation' AND TABLE_SCHEMA = 'site_test'
		    4 Query	SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'site_test' AND TABLE_NAME = 'organization'
		    4 Query	SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'organization' */ WHERE k.table_name = 'organization' AND k.table_schema = 'site_test' /*!50116 AND c.constraint_schema = 'site_test' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
		    4 Query	SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'organization' AND TABLE_SCHEMA = 'site_test'
		    4 Query	SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'site_test' AND TABLE_NAME = 'organization_member'
		    4 Query	SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'organization_member' */ WHERE k.table_name = 'organization_member' AND k.table_schema = 'site_test' /*!50116 AND c.constraint_schema = 'site_test' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
		    4 Query	SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'organization_member' AND TABLE_SCHEMA = 'site_test'
		    4 Query	SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'site_test' AND TABLE_NAME = 'os'
		    4 Query	SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'os' */ WHERE k.table_name = 'os' AND k.table_schema = 'site_test' /*!50116 AND c.constraint_schema = 'site_test' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
		    4 Query	SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'os' AND TABLE_SCHEMA = 'site_test'
		    4 Query	SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'site_test' AND TABLE_NAME = 'package'
		    4 Query	SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'package' */ WHERE k.table_name = 'package' AND k.table_schema = 'site_test' /*!50116 AND c.constraint_schema = 'site_test' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
		    4 Query	SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'package' AND TABLE_SCHEMA = 'site_test'
		    4 Query	SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'site_test' AND TABLE_NAME = 'package_model'
		    4 Query	SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'package_model' */ WHERE k.table_name = 'package_model' AND k.table_schema = 'site_test' /*!50116 AND c.constraint_schema = 'site_test' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
		    4 Query	SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'package_model' AND TABLE_SCHEMA = 'site_test'
		    4 Query	SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'site_test' AND TABLE_NAME = 'payment'
		    4 Query	SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'payment' */ WHERE k.table_name = 'payment' AND k.table_schema = 'site_test' /*!50116 AND c.constraint_schema = 'site_test' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
		    4 Query	SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'payment' AND TABLE_SCHEMA = 'site_test'
		    4 Query	SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'site_test' AND TABLE_NAME = 'product'
		    4 Query	SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'product' */ WHERE k.table_name = 'product' AND k.table_schema = 'site_test' /*!50116 AND c.constraint_schema = 'site_test' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
		    4 Query	SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'product' AND TABLE_SCHEMA = 'site_test'
		    4 Query	SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'site_test' AND TABLE_NAME = 'product_category'
		    4 Query	SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'product_category' */ WHERE k.table_name = 'product_category' AND k.table_schema = 'site_test' /*!50116 AND c.constraint_schema = 'site_test' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
		    4 Query	SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'product_category' AND TABLE_SCHEMA = 'site_test'
		    4 Query	SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'site_test' AND TABLE_NAME = 'product_category_feature'
		    4 Query	SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'product_category_feature' */ WHERE k.table_name = 'product_category_feature' AND k.table_schema = 'site_test' /*!50116 AND c.constraint_schema = 'site_test' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
		    4 Query	SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'product_category_feature' AND TABLE_SCHEMA = 'site_test'
		    4 Query	SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'site_test' AND TABLE_NAME = 'product_category_feature_value'
		    4 Query	SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'product_category_feature_value' */ WHERE k.table_name = 'product_category_feature_value' AND k.table_schema = 'site_test' /*!50116 AND c.constraint_schema = 'site_test' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
		    4 Query	SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'product_category_feature_value' AND TABLE_SCHEMA = 'site_test'
		    4 Query	SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'site_test' AND TABLE_NAME = 'product_category_features'
		    4 Query	SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'product_category_features' */ WHERE k.table_name = 'product_category_features' AND k.table_schema = 'site_test' /*!50116 AND c.constraint_schema = 'site_test' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
		    4 Query	SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'product_category_features' AND TABLE_SCHEMA = 'site_test'
		    4 Query	SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'site_test' AND TABLE_NAME = 'product_feature_value'
		    4 Query	SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'product_feature_value' */ WHERE k.table_name = 'product_feature_value' AND k.table_schema = 'site_test' /*!50116 AND c.constraint_schema = 'site_test' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
		    4 Query	SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'product_feature_value' AND TABLE_SCHEMA = 'site_test'
		    4 Query	SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'site_test' AND TABLE_NAME = 'puppet_class'
		    4 Query	SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'puppet_class' */ WHERE k.table_name = 'puppet_class' AND k.table_schema = 'site_test' /*!50116 AND c.constraint_schema = 'site_test' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
		    4 Query	SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'puppet_class' AND TABLE_SCHEMA = 'site_test'
		    4 Query	SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'site_test' AND TABLE_NAME = 'puppet_classes_packages'
		    4 Query	SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'puppet_classes_packages' */ WHERE k.table_name = 'puppet_classes_packages' AND k.table_schema = 'site_test' /*!50116 AND c.constraint_schema = 'site_test' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
		    4 Query	SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'puppet_classes_packages' AND TABLE_SCHEMA = 'site_test'
		    4 Query	SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'site_test' AND TABLE_NAME = 'puppet_flag'
		    4 Query	SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'puppet_flag' */ WHERE k.table_name = 'puppet_flag' AND k.table_schema = 'site_test' /*!50116 AND c.constraint_schema = 'site_test' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
		    4 Query	SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'puppet_flag' AND TABLE_SCHEMA = 'site_test'
		    4 Query	SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'site_test' AND TABLE_NAME = 'puppet_flag_group'
		    4 Query	SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'puppet_flag_group' */ WHERE k.table_name = 'puppet_flag_group' AND k.table_schema = 'site_test' /*!50116 AND c.constraint_schema = 'site_test' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
		    4 Query	SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'puppet_flag_group' AND TABLE_SCHEMA = 'site_test'
		    4 Query	SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'site_test' AND TABLE_NAME = 'puppet_package'
		    4 Query	SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'puppet_package' */ WHERE k.table_name = 'puppet_package' AND k.table_schema = 'site_test' /*!50116 AND c.constraint_schema = 'site_test' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
		    4 Query	SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'puppet_package' AND TABLE_SCHEMA = 'site_test'
		    4 Query	SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'site_test' AND TABLE_NAME = 'puppet_package_available_flags'
		    4 Query	SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'puppet_package_available_flags' */ WHERE k.table_name = 'puppet_package_available_flags' AND k.table_schema = 'site_test' /*!50116 AND c.constraint_schema = 'site_test' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
		    4 Query	SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'puppet_package_available_flags' AND TABLE_SCHEMA = 'site_test'
		    4 Query	SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'site_test' AND TABLE_NAME = 'puppet_package_default_disabled_flags'
		    4 Query	SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'puppet_package_default_disabled_flags' */ WHERE k.table_name = 'puppet_package_default_disabled_flags' AND k.table_schema = 'site_test' /*!50116 AND c.constraint_schema = 'site_test' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
		    4 Query	SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'puppet_package_default_disabled_flags' AND TABLE_SCHEMA = 'site_test'
		    4 Query	SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'site_test' AND TABLE_NAME = 'puppet_package_default_enabled_flags'
		    4 Query	SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'puppet_package_default_enabled_flags' */ WHERE k.table_name = 'puppet_package_default_enabled_flags' AND k.table_schema = 'site_test' /*!50116 AND c.constraint_schema = 'site_test' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
		    4 Query	SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'puppet_package_default_enabled_flags' AND TABLE_SCHEMA = 'site_test'
		    4 Query	SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'site_test' AND TABLE_NAME = 'puppet_template'
		    4 Query	SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'puppet_template' */ WHERE k.table_name = 'puppet_template' AND k.table_schema = 'site_test' /*!50116 AND c.constraint_schema = 'site_test' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
		    4 Query	SELECT TABLE_NAME AS `Table`, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, SEQ_IN_INDEX AS Seq_in_index, COLUMN_NAME AS Column_Name, COLLATION AS Collation, CARDINALITY AS Cardinality, SUB_PART AS Sub_Part, PACKED AS Packed, NULLABLE AS `Null`, INDEX_TYPE AS Index_Type, COMMENT AS Comment FROM information_schema.STATISTICS WHERE TABLE_NAME = 'puppet_template' AND TABLE_SCHEMA = 'site_test'
		    4 Query	DROP TABLE access_token
		    4 Query	DROP TABLE accounting
		    4 Query	DROP TABLE accounting_accountant
		    4 Query	DROP TABLE accounting_translation
		    4 Query	DROP TABLE alert
		    4 Query	DROP TABLE api_key
		    4 Query	DROP TABLE auth_code
		    4 Query	DROP TABLE backup_model
		    4 Query	DROP TABLE bank_account
		    4 Query	DROP TABLE billing_note
		    4 Query	DROP TABLE changelog
		    4 Query	DROP TABLE cloudflare_zone
		    4 Query	DROP TABLE country
		    4 Query	DROP TABLE credit_card
		    4 Query	DROP TABLE credit_note
		    4 Query	DROP TABLE credit_note_item
		    4 Query	DROP TABLE cron
		    4 Query	DROP TABLE domain_name
		    4 Query	DROP TABLE email
		    4 Query	DROP TABLE expense
		    4 Query	DROP TABLE expense_category
		    4 Query	DROP TABLE favorite
		    4 Query	DROP TABLE fos_group
		    4 Query	DROP TABLE fos_user_login_action
		    4 Query	DROP TABLE ftp_account
		    4 Query	DROP TABLE graylog_type
		    4 Query	DROP TABLE hosting
		    4 Query	DROP TABLE hosting_alias
		    4 Query	DROP TABLE hosting_sshkey
		    4 Query	DROP TABLE hosting_ssl_certificate
		    4 Query	DROP TABLE incident
		    4 Query	DROP TABLE incident_comment
		    4 Query	DROP TABLE influx_measurement_definition
		    4 Query	DROP TABLE invoice
		    4 Query	DROP TABLE invoice_item
		    4 Query	DROP TABLE ip_group
		    4 Query	DROP TABLE ip_v4
		    4 Query	DROP TABLE ip_v4_audit
		    4 Query	DROP TABLE ip_v6
		    4 Query	DROP TABLE ip_v6_range
		    4 Query	DROP TABLE mailalias
		    4 Query	DROP TABLE mailalias_destination
		    4 Query	DROP TABLE mailbox
		    4 Query	DROP TABLE maintenance
		    4 Query	DROP TABLE maintenance_server
		    4 Query	DROP TABLE nagios_event
		    4 Query	DROP TABLE news
		    4 Query	DROP TABLE notification
		    4 Query	DROP TABLE oauth_client
		    4 Query	DROP TABLE operation
		    4 Query	DROP TABLE organization
		    4 Query	DROP TABLE organization_member
		    4 Query	DROP TABLE os
		    4 Query	DROP TABLE package
		    4 Query	DROP TABLE package_model
		    4 Query	DROP TABLE payment
		    4 Query	DROP TABLE product
		    4 Query	DROP TABLE product_category
		    4 Query	DROP TABLE product_category_feature
		    4 Query	DROP TABLE product_category_feature_value
		    4 Query	DROP TABLE product_category_features
180518 15:17:29	    4 Query	DROP TABLE product_feature_value
		    4 Query	DROP TABLE puppet_class
		    4 Query	DROP TABLE puppet_classes_packages
		    4 Query	DROP TABLE puppet_flag
		    4 Query	DROP TABLE puppet_flag_group
		    4 Query	DROP TABLE puppet_package
		    4 Query	DROP TABLE puppet_package_available_flags
		    4 Query	DROP TABLE puppet_package_default_disabled_flags
		    4 Query	DROP TABLE puppet_package_default_enabled_flags
		    4 Query	DROP TABLE puppet_template
		    4 Query	CREATE TABLE access_token (id BIGINT AUTO_INCREMENT NOT NULL, client_id INT NOT NULL, user_id INT DEFAULT NULL, token VARCHAR(255) NOT NULL, expires_at INT DEFAULT NULL, scope VARCHAR(255) DEFAULT NULL, UNIQUE INDEX UNIQ_B6A2DD685F37A13B (token), INDEX IDX_B6A2DD6819EB6921 (client_id), INDEX IDX_B6A2DD68A76ED395 (user_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
		    4 Query	CREATE TABLE accounting (id INT AUTO_INCREMENT NOT NULL, tax_rule_id INT NOT NULL, country_id INT NOT NULL, name VARCHAR(64) NOT NULL, iban VARCHAR(34) NOT NULL, bic VARCHAR(11) NOT NULL, invoice_ref_prefix VARCHAR(8) NOT NULL, UNIQUE INDEX UNIQ_6DC501E55E237E06 (name), UNIQUE INDEX UNIQ_6DC501E51F749EE9 (invoice_ref_prefix), UNIQUE INDEX UNIQ_6DC501E53506A35B (tax_rule_id), INDEX IDX_6DC501E5F92F3E70 (country_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
		    4 Query	CREATE TABLE accounting_accountant (accounting_id INT NOT NULL, accountant_id INT NOT NULL, INDEX IDX_843D764D3B7DD068 (accounting_id), INDEX IDX_843D764D9582AA74 (accountant_id), PRIMARY KEY(accounting_id, accountant_id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
		    4 Query	CREATE TABLE accounting_translation (id INT AUTO_INCREMENT NOT NULL, translatable_id INT DEFAULT NULL, invoice_legal_notice LONGTEXT DEFAULT NULL, invoice_footer LONGTEXT DEFAULT NULL, invoice_vat_local_notice LONGTEXT DEFAULT NULL, invoice_vat_intraco_notice LONGTEXT DEFAULT NULL, invoice_vat_intraco_nif_notice LONGTEXT DEFAULT NULL, invoice_vat_other_notice LONGTEXT DEFAULT NULL, locale VARCHAR(255) NOT NULL, INDEX IDX_C8D6FFBF2C2AC5D3 (translatable_id), UNIQUE INDEX accounting_translation_unique_translation (translatable_id, locale), PRIMARY KEY(id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
		    4 Query	CREATE TABLE alert (id INT AUTO_INCREMENT NOT NULL, title VARCHAR(50) NOT NULL, level SMALLINT NOT NULL, content LONGTEXT NOT NULL, begin_at DATETIME NOT NULL, end_at DATETIME DEFAULT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
		    4 Query	CREATE TABLE api_key (id INT AUTO_INCREMENT NOT NULL, user_id INT NOT NULL, name VARCHAR(32) NOT NULL, new_encoder TINYINT(1) NOT NULL, token VARCHAR(255) NOT NULL, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, INDEX IDX_C912ED9DA76ED395 (user_id), INDEX api_key_token_idx (token), PRIMARY KEY(id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
		    4 Query	CREATE TABLE auth_code (id BIGINT AUTO_INCREMENT NOT NULL, client_id INT NOT NULL, user_id INT DEFAULT NULL, token VARCHAR(255) NOT NULL, redirect_uri LONGTEXT NOT NULL, expires_at INT DEFAULT NULL, scope VARCHAR(255) DEFAULT NULL, UNIQUE INDEX UNIQ_5933D02C5F37A13B (token), INDEX IDX_5933D02C19EB6921 (client_id), INDEX IDX_5933D02CA76ED395 (user_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
		    4 Query	CREATE TABLE backup_model (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(100) NOT NULL, code VARCHAR(25) NOT NULL, UNIQUE INDEX UNIQ_2EB7AD335E237E06 (name), UNIQUE INDEX UNIQ_2EB7AD3377153098 (code), PRIMARY KEY(id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
		    4 Query	CREATE TABLE bank_account (id INT AUTO_INCREMENT NOT NULL, account_owner VARCHAR(64) NOT NULL, account_owner_address VARCHAR(128) NOT NULL, account_owner_zip VARCHAR(32) NOT NULL, account_owner_city VARCHAR(64) NOT NULL, account_owner_country VARCHAR(64) NOT NULL, iban VARCHAR(255) NOT NULL, bic VARCHAR(255) NOT NULL, bank_name VARCHAR(64) NOT NULL, bank_address VARCHAR(128) NOT NULL, bank_zip VARCHAR(32) NOT NULL, bank_city VARCHAR(64) NOT NULL, bank_country VARCHAR(64) NOT NULL, mandate_ref VARCHAR(35) NOT NULL, mandate_signed TINYINT(1) NOT NULL, mandate_signed_date DATE DEFAULT NULL, mandate_path VARCHAR(255) DEFAULT NULL, first_debit TINYINT(1) NOT NULL, activated TINYINT(1) NOT NULL, created_at DATE DEFAULT NULL, UNIQUE INDEX UNIQ_53A23E0AFAD56E62 (iban), UNIQUE INDEX UNIQ_53A23E0A9A02F914 (mandate_ref), PRIMARY KEY(id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
		    4 Query	CREATE TABLE billing_note (id INT AUTO_INCREMENT NOT NULL, author_id INT DEFAULT NULL, customer_id INT NOT NULL, created_at DATETIME DEFAULT NULL, content LONGTEXT NOT NULL, INDEX IDX_B0CFC4D3F675F31B (author_id), INDEX IDX_B0CFC4D39395C3F3 (customer_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
		    4 Query	CREATE TABLE changelog (id INT AUTO_INCREMENT NOT NULL, news_id INT NOT NULL, content VARCHAR(200) NOT NULL, private TINYINT(1) NOT NULL, INDEX IDX_C8422601B5A459A0 (news_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
		    4 Query	CREATE TABLE cloudflare_zone (id VARCHAR(32) NOT NULL, owner_id INT DEFAULT NULL, name VARCHAR(255) NOT NULL, hosted_cnames LONGTEXT DEFAULT NULL COMMENT '(DC2Type:json_array)', forward_tos LONGTEXT DEFAULT NULL COMMENT '(DC2Type:json_array)', settings LONGTEXT NOT NULL COMMENT '(DC2Type:json_array)', UNIQUE INDEX UNIQ_351290045E237E06 (name), INDEX IDX_351290047E3C61F9 (owner_id), INDEX cloudflare_zone_name_idx (name), PRIMARY KEY(id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
		    4 Query	CREATE TABLE country (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(64) NOT NULL, code VARCHAR(2) NOT NULL, intraco TINYINT(1) NOT NULL, UNIQUE INDEX UNIQ_5373C9665E237E06 (name), UNIQUE INDEX UNIQ_5373C96677153098 (code), PRIMARY KEY(id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
		    4 Query	CREATE TABLE credit_card (id INT AUTO_INCREMENT NOT NULL, ref VARCHAR(19) NOT NULL, subscriber_ref VARCHAR(250) NOT NULL, owner_name VARCHAR(100) NOT NULL, first_digits VARCHAR(4) NOT NULL, last_digits VARCHAR(4) NOT NULL, validity_date_month VARCHAR(2) NOT NULL, validity_date_year VARCHAR(2) NOT NULL, expiration_notified TINYINT(1) NOT NULL, UNIQUE INDEX credit_card_ref_subscriber_ref_id_idx (ref, subscriber_ref), PRIMARY KEY(id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
		    4 Query	CREATE TABLE credit_note (ref VARCHAR(16) NOT NULL, accounting_id INT NOT NULL, customer_id INT NOT NULL, type VARCHAR(32) NOT NULL, date DATE NOT NULL, vat DOUBLE PRECISION NOT NULL, refunded TINYINT(1) NOT NULL, canceled TINYINT(1) NOT NULL, used TINYINT(1) NOT NULL, notes LONGTEXT DEFAULT NULL, recipient_name VARCHAR(255) DEFAULT NULL, recipient_address LONGTEXT DEFAULT NULL, recipient_country_id INT NOT NULL, recipient_company VARCHAR(255) DEFAULT NULL, recipient_siret VARCHAR(32) DEFAULT NULL, recipient_nif VARCHAR(32) DEFAULT NULL, INDEX IDX_C87F45293B7DD068 (accounting_id), INDEX IDX_C87F45299395C3F3 (customer_id), PRIMARY KEY(ref)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
180518 15:17:30	    4 Query	CREATE TABLE credit_note_item (id INT AUTO_INCREMENT NOT NULL, credit_note_id VARCHAR(16) NOT NULL, description LONGTEXT NOT NULL, amount DOUBLE PRECISION NOT NULL, INDEX IDX_7EABC2541C696F7A (credit_note_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
		    4 Query	CREATE TABLE cron (id INT AUTO_INCREMENT NOT NULL, hosting_id INT NOT NULL, status SMALLINT NOT NULL, activated TINYINT(1) NOT NULL, minute VARCHAR(200) NOT NULL, hour VARCHAR(200) NOT NULL, day VARCHAR(200) NOT NULL, month VARCHAR(200) NOT NULL, weekday VARCHAR(200) NOT NULL, command LONGTEXT NOT NULL, comment VARCHAR(140) DEFAULT NULL, added_at DATETIME DEFAULT NULL, INDEX IDX_17CD00F8AE9044EA (hosting_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
		    4 Query	CREATE TABLE domain_name (id INT AUTO_INCREMENT NOT NULL, purchase_id INT DEFAULT NULL, expire_ticket_id INT DEFAULT NULL, fqdn VARCHAR(83) NOT NULL, registrar VARCHAR(64) NOT NULL, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, registry_creation_date DATETIME DEFAULT NULL, registry_update_date DATETIME DEFAULT NULL, expiration_date DATETIME DEFAULT NULL, auto_renew TINYINT(1) NOT NULL, authinfo VARCHAR(40) DEFAULT NULL, domain_status VARCHAR(60) DEFAULT NULL, status SMALLINT NOT NULL, owner_contact VARCHAR(64) NOT NULL, administrator_contact VARCHAR(64) NOT NULL, billing_contact VARCHAR(64) NOT NULL, technician_contact VARCHAR(64) NOT NULL, registrar_info LONGTEXT NOT NULL COMMENT '(DC2Type:array)', UNIQUE INDEX UNIQ_F3FF5361C1A19758 (fqdn), UNIQUE INDEX UNIQ_F3FF5361558FBEB9 (purchase_id), UNIQUE INDEX UNIQ_F3FF5361329BC5B4 (expire_ticket_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
		    4 Query	CREATE TABLE email (id INT AUTO_INCREMENT NOT NULL, user_id INT NOT NULL, email VARCHAR(255) NOT NULL, email_canonical VARCHAR(255) NOT NULL, confirmation_token VARCHAR(255) DEFAULT NULL, UNIQUE INDEX UNIQ_E7927C74E7927C74 (email), INDEX IDX_E7927C74A76ED395 (user_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
		    4 Query	CREATE TABLE expense (id INT AUTO_INCREMENT NOT NULL, category_id INT DEFAULT NULL, slug VARCHAR(64) NOT NULL, title VARCHAR(64) NOT NULL, description LONGTEXT DEFAULT NULL, amount DOUBLE PRECISION NOT NULL, spent_at DATE NOT NULL, path VARCHAR(255) DEFAULT NULL, UNIQUE INDEX UNIQ_2D3A8DA6989D9B62 (slug), INDEX IDX_2D3A8DA612469DE2 (category_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
		    4 Query	CREATE TABLE expense_category (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(64) NOT NULL, UNIQUE INDEX UNIQ_C02DDB385E237E06 (name), PRIMARY KEY(id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
		    4 Query	CREATE TABLE favorite (id INT AUTO_INCREMENT NOT NULL, user_id INT NOT NULL, uri VARCHAR(255) NOT NULL, title VARCHAR(64) NOT NULL, INDEX IDX_68C58ED9A76ED395 (user_id), UNIQUE INDEX favorite_uri_user_id_unique_idx (uri, user_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
		    4 Query	CREATE TABLE ftp_account (id INT AUTO_INCREMENT NOT NULL, hosting_id INT NOT NULL, status SMALLINT NOT NULL, login VARCHAR(32) NOT NULL, password VARCHAR(64) NOT NULL, subpath VARCHAR(255) DEFAULT NULL, readonly TINYINT(1) NOT NULL, INDEX IDX_B0BB6310AE9044EA (hosting_id), UNIQUE INDEX ftp_account_login_hosting_id_idx (login, hosting_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
		    4 Query	CREATE TABLE graylog_type (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(32) NOT NULL, fields LONGTEXT DEFAULT NULL COMMENT '(DC2Type:simple_array)', UNIQUE INDEX UNIQ_1BE6D42F5E237E06 (name), PRIMARY KEY(id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
		    4 Query	CREATE TABLE fos_group (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(180) NOT NULL, roles LONGTEXT NOT NULL COMMENT '(DC2Type:array)', UNIQUE INDEX UNIQ_4B019DDB5E237E06 (name), PRIMARY KEY(id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
		    4 Query	CREATE TABLE hosting (id INT AUTO_INCREMENT NOT NULL, server_id INT NOT NULL, slug VARCHAR(64) NOT NULL, name VARCHAR(64) NOT NULL, name_canonical VARCHAR(255) NOT NULL, ftp_login VARCHAR(50) NOT NULL, ftp_password VARCHAR(50) NOT NULL, mysql_login VARCHAR(16) NOT NULL, mysql_password VARCHAR(32) NOT NULL, path VARCHAR(256) NOT NULL, subpath VARCHAR(256) NOT NULL, cron_mailto VARCHAR(256) DEFAULT NULL, added_at DATETIME NOT NULL, status SMALLINT NOT NULL, ssh_keys_reload_needed TINYINT(1) NOT NULL, UNIQUE INDEX UNIQ_E9168FDA989D9B62 (slug), INDEX IDX_E9168FDA1844E6B7 (server_id), UNIQUE INDEX hosting_name_canonical_server_unique_idx (name_canonical, server_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
		    4 Query	CREATE TABLE hosting_sshkey (hosting_id INT NOT NULL, key_id INT NOT NULL, INDEX IDX_54F49891AE9044EA (hosting_id), INDEX IDX_54F49891D145533 (key_id), PRIMARY KEY(hosting_id, key_id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
		    4 Query	CREATE TABLE hosting_alias (id INT AUTO_INCREMENT NOT NULL, hosting_id INT NOT NULL, subdomain_id INT DEFAULT NULL, status SMALLINT NOT NULL, name VARCHAR(255) NOT NULL, name_canonical VARCHAR(255) NOT NULL, added_at DATETIME DEFAULT NULL, INDEX IDX_38067C6EAE9044EA (hosting_id), INDEX IDX_38067C6E8530A5DC (subdomain_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
		    4 Query	CREATE TABLE hosting_ssl_certificate (id INT AUTO_INCREMENT NOT NULL, hosting_id INT NOT NULL, subdomain_id INT DEFAULT NULL, certificate_id INT NOT NULL, status SMALLINT NOT NULL, new_filename_format TINYINT(1) NOT NULL, INDEX IDX_76FE21DFAE9044EA (hosting_id), INDEX IDX_76FE21DF8530A5DC (subdomain_id), INDEX IDX_76FE21DF99223FFD (certificate_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
		    4 Query	CREATE TABLE incident (id INT AUTO_INCREMENT NOT NULL, server_id INT NOT NULL, assigned_id INT DEFAULT NULL, title VARCHAR(100) NOT NULL, state INT NOT NULL, created_at DATETIME NOT NULL, considered_at DATETIME DEFAULT NULL, resolved_at DATETIME DEFAULT NULL, closed_at DATETIME DEFAULT NULL, INDEX IDX_3D03A11A1844E6B7 (server_id), INDEX IDX_3D03A11AE1501A05 (assigned_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
		    4 Query	CREATE TABLE incident_comment (id INT AUTO_INCREMENT NOT NULL, incident_id INT NOT NULL, author_id INT NOT NULL, content LONGTEXT NOT NULL, added_at DATETIME NOT NULL, customer_visible TINYINT(1) NOT NULL, INDEX IDX_33BE48B159E53FB9 (incident_id), INDEX IDX_33BE48B1F675F31B (author_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
		    4 Query	CREATE TABLE influx_measurement_definition (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(128) NOT NULL, fields LONGTEXT DEFAULT NULL COMMENT '(DC2Type:simple_array)', derivative_fields LONGTEXT DEFAULT NULL COMMENT '(DC2Type:simple_array)', tags LONGTEXT DEFAULT NULL COMMENT '(DC2Type:simple_array)', min INT DEFAULT NULL, max INT DEFAULT NULL, point_precision INT DEFAULT NULL, icon VARCHAR(64) DEFAULT NULL, UNIQUE INDEX UNIQ_BD5952F05E237E06 (name), PRIMARY KEY(id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
		    4 Query	CREATE TABLE invoice (ref VARCHAR(14) NOT NULL, customer_id INT NOT NULL, accounting_id INT NOT NULL, version INT DEFAULT 1 NOT NULL, vat DOUBLE PRECISION NOT NULL, notes LONGTEXT DEFAULT NULL, is_valid TINYINT(1) NOT NULL, paid TINYINT(1) NOT NULL, canceled TINYINT(1) NOT NULL, period_begin DATE NOT NULL, period_end DATE NOT NULL, due_date DATE NOT NULL, due_date_prevented TINYINT(1) NOT NULL, created_at DATETIME NOT NULL, payment_method VARCHAR(32) DEFAULT NULL, recipient_name VARCHAR(255) DEFAULT NULL, recipient_address LONGTEXT DEFAULT NULL, recipient_country_id INT NOT NULL, recipient_company VARCHAR(255) DEFAULT NULL, recipient_siret VARCHAR(32) DEFAULT NULL, recipient_nif VARCHAR(32) DEFAULT NULL, INDEX IDX_906517449395C3F3 (customer_id), INDEX IDX_906517443B7DD068 (accounting_id), INDEX invoice_ref_idx (ref), INDEX invoice_created_at_idx (created_at), INDEX invoice_paid_idx (paid), INDEX invoice_is_valid_idx (is_valid), INDEX invoice_canceled_idx (canceled), INDEX invoice_payment_method_idx (payment_method), PRIMARY KEY(ref)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
		    4 Query	CREATE TABLE invoice_item (id INT AUTO_INCREMENT NOT NULL, invoice_id VARCHAR(14) NOT NULL, name VARCHAR(255) NOT NULL, ref_product VARCHAR(16) DEFAULT NULL, description LONGTEXT DEFAULT NULL, price DOUBLE PRECISION NOT NULL, quantity INT NOT NULL, INDEX IDX_1DDE477B2989F1FD (invoice_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
		    4 Query	CREATE TABLE ip_group (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(100) NOT NULL, code VARCHAR(20) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
		    4 Query	CREATE TABLE ip_v4 (id INT AUTO_INCREMENT NOT NULL, group_id INT DEFAULT NULL, server_id INT DEFAULT NULL, ip VARCHAR(15) NOT NULL, network VARCHAR(10) NOT NULL, system_ip TINYINT(1) NOT NULL, pingable TINYINT(1) NOT NULL, ping_tested_at DATETIME DEFAULT NULL, alias VARCHAR(32) DEFAULT NULL, added_at DATETIME NOT NULL, modified_at DATETIME NOT NULL, UNIQUE INDEX UNIQ_60E01F5A5E3B32D (ip), INDEX IDX_60E01F5FE54D947 (group_id), INDEX IDX_60E01F51844E6B7 (server_id), INDEX ip_v4_network_idx (network), PRIMARY KEY(id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
		    4 Query	CREATE TABLE ip_v4_audit (id INT NOT NULL, rev INT NOT NULL, group_id INT DEFAULT NULL, server_id INT DEFAULT NULL, ip VARCHAR(15) DEFAULT NULL, network VARCHAR(10) DEFAULT NULL, system_ip TINYINT(1) DEFAULT NULL, pingable TINYINT(1) DEFAULT NULL, ping_tested_at DATETIME DEFAULT NULL, alias VARCHAR(32) DEFAULT NULL, added_at DATETIME DEFAULT NULL, modified_at DATETIME DEFAULT NULL, revtype VARCHAR(4) NOT NULL, INDEX rev_f7b2f5716404d2c89d7f9cd5c27b27da_idx (rev), PRIMARY KEY(id, rev)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
		    4 Query	CREATE TABLE ip_v6 (id INT AUTO_INCREMENT NOT NULL, range_id INT NOT NULL, ip VARCHAR(45) NOT NULL, alias VARCHAR(32) DEFAULT NULL, UNIQUE INDEX UNIQ_E80060D9A5E3B32D (ip), INDEX IDX_E80060D92A82D0B1 (range_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
		    4 Query	CREATE TABLE ip_v6_range (id INT AUTO_INCREMENT NOT NULL, group_id INT DEFAULT NULL, server_id INT DEFAULT NULL, base_ip VARCHAR(255) NOT NULL, subnet INT NOT NULL, UNIQUE INDEX UNIQ_124D0D6773BD0B3C (base_ip), INDEX IDX_124D0D67FE54D947 (group_id), UNIQUE INDEX UNIQ_124D0D671844E6B7 (server_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
		    4 Query	CREATE TABLE fos_user_login_action (id INT AUTO_INCREMENT NOT NULL, user_id INT NOT NULL, ip VARCHAR(64) NOT NULL, reverse VARCHAR(255) DEFAULT NULL, connected_at DATETIME NOT NULL, INDEX IDX_C7C9A160A76ED395 (user_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
		    4 Query	CREATE TABLE mailalias (id INT AUTO_INCREMENT NOT NULL, hosting_id INT NOT NULL, subdomain_id INT DEFAULT NULL, name VARCHAR(64) NOT NULL, status SMALLINT NOT NULL, added_at DATETIME NOT NULL, INDEX IDX_113288E6AE9044EA (hosting_id), INDEX IDX_113288E68530A5DC (subdomain_id), UNIQUE INDEX mailalias_name_hosting_id_idx (name, hosting_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
		    4 Query	CREATE TABLE mailalias_destination (id INT AUTO_INCREMENT NOT NULL, mailalias_id INT NOT NULL, name VARCHAR(100) NOT NULL, name_canonical VARCHAR(255) NOT NULL, INDEX IDX_DD4CFAB1F0A32AF0 (mailalias_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
		    4 Query	CREATE TABLE mailbox (id INT AUTO_INCREMENT NOT NULL, hosting_id INT NOT NULL, subdomain_id INT DEFAULT NULL, slug VARCHAR(64) NOT NULL, name VARCHAR(64) NOT NULL, password VARCHAR(32) NOT NULL, status SMALLINT NOT NULL, added_at DATETIME NOT NULL, UNIQUE INDEX UNIQ_A69FE20B989D9B62 (slug), INDEX IDX_A69FE20BAE9044EA (hosting_id), INDEX IDX_A69FE20B8530A5DC (subdomain_id), UNIQUE INDEX mailbox_name_hosting_id_idx (name, hosting_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
		    4 Query	CREATE TABLE maintenance (id INT AUTO_INCREMENT NOT NULL, title VARCHAR(100) NOT NULL, description LONGTEXT NOT NULL, global TINYINT(1) NOT NULL, begin_at DATETIME NOT NULL, end_at DATETIME NOT NULL, closed_at DATETIME DEFAULT NULL, report LONGTEXT DEFAULT NULL, remindered_at DATETIME DEFAULT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
		    4 Query	CREATE TABLE maintenance_server (maintenance_id INT NOT NULL, server_id INT NOT NULL, INDEX IDX_7090E3FFF6C202BC (maintenance_id), INDEX IDX_7090E3FF1844E6B7 (server_id), PRIMARY KEY(maintenance_id, server_id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
		    4 Query	CREATE TABLE nagios_event (id INT AUTO_INCREMENT NOT NULL, incident_id INT NOT NULL, service VARCHAR(255) DEFAULT NULL, type VARCHAR(255) NOT NULL, notified_at DATETIME NOT NULL, information LONGTEXT DEFAULT NULL, ip VARCHAR(255) NOT NULL, INDEX IDX_3C08274E59E53FB9 (incident_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
		    4 Query	CREATE TABLE news (id INT AUTO_INCREMENT NOT NULL, title VARCHAR(50) DEFAULT NULL, public_content LONGTEXT DEFAULT NULL, private_content LONGTEXT DEFAULT NULL, publish_date DATE DEFAULT NULL, popup_duration INT NOT NULL, created_at DATETIME NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
		    4 Query	CREATE TABLE notification (id INT AUTO_INCREMENT NOT NULL, user_id INT NOT NULL, created_at DATETIME NOT NULL, checked TINYINT(1) NOT NULL, subject_class VARCHAR(255) NOT NULL, subject_id VARCHAR(255) NOT NULL, subject_action VARCHAR(255) NOT NULL, INDEX IDX_BF5476CAA76ED395 (user_id), INDEX notification_created_at_idx (created_at), PRIMARY KEY(id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
		    4 Query	CREATE TABLE oauth_client (id INT AUTO_INCREMENT NOT NULL, random_id VARCHAR(255) NOT NULL, redirect_uris LONGTEXT NOT NULL COMMENT '(DC2Type:array)', secret VARCHAR(255) NOT NULL, allowed_grant_types LONGTEXT NOT NULL COMMENT '(DC2Type:array)', PRIMARY KEY(id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
		    4 Query	CREATE TABLE operation (id INT AUTO_INCREMENT NOT NULL, author_id INT NOT NULL, server_id INT DEFAULT NULL, hosting_id INT DEFAULT NULL, subdomain_id INT DEFAULT NULL, alias_id INT DEFAULT NULL, hosting_ssl_certificate_id INT DEFAULT NULL, database_id INT DEFAULT NULL, mailbox_id INT DEFAULT NULL, mailalias_id INT DEFAULT NULL, cron_id INT DEFAULT NULL, ftp_account_id INT DEFAULT NULL, service_ip_id INT DEFAULT NULL, action VARCHAR(16) NOT NULL, additional_data LONGTEXT DEFAULT NULL COMMENT '(DC2Type:json_array)', status SMALLINT NOT NULL, result LONGTEXT DEFAULT NULL, added_at DATETIME NOT NULL, executed_at DATETIME DEFAULT NULL, type VARCHAR(255) NOT NULL, INDEX IDX_1981A66DF675F31B (author_id), INDEX IDX_1981A66D1844E6B7 (server_id), INDEX IDX_1981A66DAE9044EA (hosting_id), INDEX IDX_1981A66D8530A5DC (subdomain_id), INDEX IDX_1981A66D5E564AE2 (alias_id), INDEX IDX_1981A66D360E7DB3 (hosting_ssl_certificate_id), INDEX IDX_1981A66DF0AA09DB (database_id), INDEX IDX_1981A66D66EC35CC (mailbox_id), INDEX IDX_1981A66DF0A32AF0 (mailalias_id), INDEX IDX_1981A66D38435942 (cron_id), INDEX IDX_1981A66D68043490 (ftp_account_id), INDEX IDX_1981A66D94DB378 (service_ip_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
		    4 Query	CREATE TABLE organization (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(40) NOT NULL, slug VARCHAR(50) NOT NULL, vip TINYINT(1) NOT NULL, notes LONGTEXT DEFAULT NULL, UNIQUE INDEX UNIQ_C1EE637C5E237E06 (name), UNIQUE INDEX UNIQ_C1EE637C989D9B62 (slug), PRIMARY KEY(id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
		    4 Query	CREATE TABLE organization_member (id INT AUTO_INCREMENT NOT NULL, organization_id INT NOT NULL, user_id INT NOT NULL, access_level SMALLINT NOT NULL, INDEX IDX_756A2A8D32C8A3DE (organization_id), INDEX IDX_756A2A8DA76ED395 (user_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
		    4 Query	CREATE TABLE os (id INT AUTO_INCREMENT NOT NULL, slug VARCHAR(64) NOT NULL, name VARCHAR(64) NOT NULL, UNIQUE INDEX os_name_idx (name), PRIMARY KEY(id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
		    4 Query	CREATE TABLE package (id INT AUTO_INCREMENT NOT NULL, server_id INT NOT NULL, package_model_id INT NOT NULL, version VARCHAR(32) NOT NULL, checked_at DATETIME DEFAULT NULL, INDEX IDX_DE6867951844E6B7 (server_id), INDEX IDX_DE6867959DF42389 (package_model_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
		    4 Query	CREATE TABLE package_model (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(64) NOT NULL, UNIQUE INDEX UNIQ_4291753E5E237E06 (name), PRIMARY KEY(id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
		    4 Query	CREATE TABLE payment (id INT AUTO_INCREMENT NOT NULL, credit_note_id VARCHAR(16) DEFAULT NULL, invoice_id VARCHAR(14) NOT NULL, date DATE NOT NULL, transaction_id VARCHAR(255) DEFAULT NULL, amount DOUBLE PRECISION NOT NULL, mail_sent TINYINT(1) NOT NULL, method VARCHAR(32) NOT NULL, INDEX IDX_6D28840D1C696F7A (credit_note_id), INDEX IDX_6D28840D2989F1FD (invoice_id), INDEX payment_method_idx (method), PRIMARY KEY(id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
		    4 Query	CREATE TABLE product (id INT AUTO_INCREMENT NOT NULL, category_id INT NOT NULL, name VARCHAR(64) NOT NULL, ref VARCHAR(16) DEFAULT NULL, price DOUBLE PRECISION NOT NULL, is_recurrent TINYINT(1) NOT NULL, INDEX IDX_D34A04AD12469DE2 (category_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
		    4 Query	CREATE TABLE product_category (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(64) NOT NULL, deliver_code VARCHAR(64) DEFAULT NULL, slug VARCHAR(64) DEFAULT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
		    4 Query	CREATE TABLE product_category_features (product_category_id INT NOT NULL, feature_id INT NOT NULL, INDEX IDX_BC3F6A3BBE6903FD (product_category_id), INDEX IDX_BC3F6A3B60E4B879 (feature_id), PRIMARY KEY(product_category_id, feature_id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
		    4 Query	CREATE TABLE product_category_feature (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(64) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
		    4 Query	CREATE TABLE product_category_feature_value (id INT AUTO_INCREMENT NOT NULL, feature_id INT NOT NULL, name VARCHAR(64) NOT NULL, INDEX IDX_8834409060E4B879 (feature_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
		    4 Query	CREATE TABLE product_feature_value (id INT AUTO_INCREMENT NOT NULL, value_id INT DEFAULT NULL, feature_id INT NOT NULL, product_id INT NOT NULL, value_text VARCHAR(64) DEFAULT NULL, value_bool TINYINT(1) DEFAULT NULL, INDEX IDX_EC44ECFF920BBA2 (value_id), INDEX IDX_EC44ECF60E4B879 (feature_id), INDEX IDX_EC44ECF4584665A (product_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
		    4 Query	CREATE TABLE puppet_class (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(64) NOT NULL, description LONGTEXT DEFAULT NULL, base TINYINT(1) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
180518 15:17:31	    4 Query	CREATE TABLE puppet_classes_packages (class_id INT NOT NULL, package_id INT NOT NULL, INDEX IDX_15F56CA7EA000B10 (class_id), INDEX IDX_15F56CA7F44CABFF (package_id), PRIMARY KEY(class_id, package_id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
		    4 Query	CREATE TABLE puppet_flag (id INT AUTO_INCREMENT NOT NULL, group_id INT NOT NULL, name VARCHAR(32) NOT NULL COLLATE utf8_bin, INDEX IDX_DAF8BF8FFE54D947 (group_id), UNIQUE INDEX puppet_flag_name_group_id_unique_idx (name, group_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
		    4 Query	CREATE TABLE puppet_flag_group (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(32) NOT NULL, UNIQUE INDEX UNIQ_59451F3F5E237E06 (name), PRIMARY KEY(id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
		    4 Query	CREATE TABLE puppet_package (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(64) NOT NULL, available_versions LONGTEXT DEFAULT NULL COMMENT '(DC2Type:json_array)', default_version VARCHAR(32) DEFAULT NULL, UNIQUE INDEX UNIQ_13E4D27E5E237E06 (name), PRIMARY KEY(id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
		    4 Query	CREATE TABLE puppet_package_available_flags (puppet_package_id INT NOT NULL, puppet_flag_id INT NOT NULL, INDEX IDX_D5060A7F2C470185 (puppet_package_id), INDEX IDX_D5060A7F5C13510E (puppet_flag_id), PRIMARY KEY(puppet_package_id, puppet_flag_id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
		    4 Query	CREATE TABLE puppet_package_default_enabled_flags (puppet_package_id INT NOT NULL, puppet_flag_id INT NOT NULL, INDEX IDX_671C8E032C470185 (puppet_package_id), INDEX IDX_671C8E035C13510E (puppet_flag_id), PRIMARY KEY(puppet_package_id, puppet_flag_id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
		    4 Query	CREATE TABLE puppet_package_default_disabled_flags (puppet_package_id INT NOT NULL, puppet_flag_id INT NOT NULL, INDEX IDX_7EF53A532C470185 (puppet_package_id), INDEX IDX_7EF53A535C13510E (puppet_flag_id), PRIMARY KEY(puppet_package_id, puppet_flag_id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
		    4 Query	CREATE TABLE puppet_template (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(64) NOT NULL, UNIQUE INDEX UNIQ_A075A8C65E237E06 (name), PRIMARY KEY(id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
		    4 Query	CREATE TABLE puppet_template_classes (template_id INT NOT NULL, class_id INT NOT NULL, INDEX IDX_95E04FE55DA0FB8 (template_id), INDEX IDX_95E04FE5EA000B10 (class_id), PRIMARY KEY(template_id, class_id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
		    4 Query	CREATE TABLE purchase (id INT AUTO_INCREMENT NOT NULL, customer_id INT NOT NULL, product_id INT NOT NULL, accounting_id INT NOT NULL, version INT DEFAULT 1 NOT NULL, name VARCHAR(64) DEFAULT NULL, price DOUBLE PRECISION NOT NULL, quantity INT NOT NULL, confirmed TINYINT(1) NOT NULL, next_invoice_date DATE NOT NULL, last_invoice_date DATE DEFAULT NULL, cancellation_date DATE DEFAULT NULL, created_at DATETIME NOT NULL, INDEX IDX_6117D13B9395C3F3 (customer_id), INDEX IDX_6117D13B4584665A (product_id), INDEX IDX_6117D13B3B7DD068 (accounting_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
		    4 Query	CREATE TABLE purchase_invoice (purchase_id INT NOT NULL, invoice_ref VARCHAR(14) NOT NULL, INDEX IDX_8BBFDD3D558FBEB9 (purchase_id), INDEX IDX_8BBFDD3DBC9E5160 (invoice_ref), PRIMARY KEY(purchase_id, invoice_ref)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
		    4 Query	CREATE TABLE purchase_audit (id INT NOT NULL, rev INT NOT NULL, customer_id INT DEFAULT NULL, product_id INT DEFAULT NULL, accounting_id INT DEFAULT NULL, version INT DEFAULT 1, name VARCHAR(64) DEFAULT NULL, price DOUBLE PRECISION DEFAULT NULL, quantity INT DEFAULT NULL, confirmed TINYINT(1) DEFAULT NULL, next_invoice_date DATE DEFAULT NULL, last_invoice_date DATE DEFAULT NULL, cancellation_date DATE DEFAULT NULL, created_at DATETIME DEFAULT NULL, revtype VARCHAR(4) NOT NULL, INDEX rev_763f3d741084af24d19539623fc788c0_idx (rev), PRIMARY KEY(id, rev)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
		    4 Query	CREATE TABLE refresh_token (id BIGINT AUTO_INCREMENT NOT NULL, client_id INT NOT NULL, user_id INT DEFAULT NULL, token VARCHAR(255) NOT NULL, expires_at INT DEFAULT NULL, scope VARCHAR(255) DEFAULT NULL, UNIQUE INDEX UNIQ_C74F21955F37A13B (token), INDEX IDX_C74F219519EB6921 (client_id), INDEX IDX_C74F2195A76ED395 (user_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
		    4 Query	CREATE TABLE server (id INT AUTO_INCREMENT NOT NULL, os_id INT DEFAULT NULL, purchase_id INT DEFAULT NULL, backup_model_id INT DEFAULT NULL, version INT DEFAULT 1 NOT NULL, slug VARCHAR(64) NOT NULL, name VARCHAR(64) NOT NULL, alias VARCHAR(64) DEFAULT NULL, notes LONGTEXT DEFAULT NULL, hosted_domain VARCHAR(64) DEFAULT NULL, mac VARCHAR(17) DEFAULT NULL, ssh_user VARCHAR(64) NOT NULL, ssh_port INT NOT NULL, impi_address VARCHAR(15) DEFAULT NULL, impi_login VARCHAR(32) DEFAULT NULL, impi_password VARCHAR(32) DEFAULT NULL, mysql_host VARCHAR(255) NOT NULL, mysql_root VARCHAR(64) DEFAULT NULL, web_server VARCHAR(255) NOT NULL, web_server_listen VARCHAR(64) NOT NULL, web_server_port SMALLINT UNSIGNED NOT NULL, web_server_ssl_listen VARCHAR(64) NOT NULL, web_server_ssl_port SMALLINT UNSIGNED NOT NULL, fpm_mode VARCHAR(16) NOT NULL, fpm_listen VARCHAR(64) NOT NULL, fpm_port SMALLINT UNSIGNED NOT NULL, mysql_server TINYINT(1) NOT NULL, suphp TINYINT(1) NOT NULL, fastcgi TINYINT(1) NOT NULL, external_mysql TINYINT(1) NOT NULL, nadmin_compliant TINYINT(1) NOT NULL, email_compliant TINYINT(1) NOT NULL, status SMALLINT NOT NULL, available TINYINT(1) NOT NULL, environment VARCHAR(50) NOT NULL, added_at DATETIME NOT NULL, modified_at DATETIME NOT NULL, UNIQUE INDEX UNIQ_5A6DD5F6989D9B62 (slug), INDEX IDX_5A6DD5F63DCA04D1 (os_id), UNIQUE INDEX UNIQ_5A6DD5F6558FBEB9 (purchase_id), INDEX IDX_5A6DD5F6EC07A5C (backup_model_id), INDEX server_name_idx (name), PRIMARY KEY(id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
		    4 Query	CREATE TABLE server_owner (server_id INT NOT NULL, owner_id INT NOT NULL, INDEX IDX_6FE184751844E6B7 (server_id), INDEX IDX_6FE184757E3C61F9 (owner_id), PRIMARY KEY(server_id, owner_id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
		    4 Query	CREATE TABLE server_organization (server_id INT NOT NULL, organization_id INT NOT NULL, INDEX IDX_D0A708D91844E6B7 (server_id), INDEX IDX_D0A708D932C8A3DE (organization_id), PRIMARY KEY(server_id, organization_id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
		    4 Query	CREATE TABLE server_puppet_templates (server_id INT NOT NULL, puppet_template_id INT NOT NULL, INDEX IDX_1C95C46E1844E6B7 (server_id), INDEX IDX_1C95C46EB5D29C30 (puppet_template_id), PRIMARY KEY(server_id, puppet_template_id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
		    4 Query	CREATE TABLE server_puppet_classes (server_id INT NOT NULL, puppet_class_id INT NOT NULL, INDEX IDX_C6712A1B1844E6B7 (server_id), INDEX IDX_C6712A1BDD15BC55 (puppet_class_id), PRIMARY KEY(server_id, puppet_class_id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
		    4 Query	CREATE TABLE server_audit (id INT NOT NULL, rev INT NOT NULL, os_id INT DEFAULT NULL, purchase_id INT DEFAULT NULL, backup_model_id INT DEFAULT NULL, version INT DEFAULT 1, slug VARCHAR(64) DEFAULT NULL, name VARCHAR(64) DEFAULT NULL, alias VARCHAR(64) DEFAULT NULL, notes LONGTEXT DEFAULT NULL, hosted_domain VARCHAR(64) DEFAULT NULL, mac VARCHAR(17) DEFAULT NULL, ssh_user VARCHAR(64) DEFAULT NULL, ssh_port INT DEFAULT NULL, impi_address VARCHAR(15) DEFAULT NULL, impi_login VARCHAR(32) DEFAULT NULL, impi_password VARCHAR(32) DEFAULT NULL, mysql_host VARCHAR(255) DEFAULT NULL, mysql_root VARCHAR(64) DEFAULT NULL, web_server VARCHAR(255) DEFAULT NULL, web_server_listen VARCHAR(64) DEFAULT NULL, web_server_port SMALLINT UNSIGNED DEFAULT NULL, web_server_ssl_listen VARCHAR(64) DEFAULT NULL, web_server_ssl_port SMALLINT UNSIGNED DEFAULT NULL, fpm_mode VARCHAR(16) DEFAULT NULL, fpm_listen VARCHAR(64) DEFAULT NULL, fpm_port SMALLINT UNSIGNED DEFAULT NULL, mysql_server TINYINT(1) DEFAULT NULL, suphp TINYINT(1) DEFAULT NULL, fastcgi TINYINT(1) DEFAULT NULL, external_mysql TINYINT(1) DEFAULT NULL, nadmin_compliant TINYINT(1) DEFAULT NULL, email_compliant TINYINT(1) DEFAULT NULL, status SMALLINT DEFAULT NULL, available TINYINT(1) DEFAULT NULL, environment VARCHAR(50) DEFAULT NULL, added_at DATETIME DEFAULT NULL, modified_at DATETIME DEFAULT NULL, revtype VARCHAR(4) NOT NULL, INDEX rev_6e8bc1b8d49bea944537ac1bb4d9e320_idx (rev), PRIMARY KEY(id, rev)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
		    4 Query	CREATE TABLE server_puppet_package (server_id INT NOT NULL, puppet_package_id INT NOT NULL, default_version VARCHAR(32) DEFAULT NULL, INDEX IDX_1AF4334B1844E6B7 (server_id), INDEX IDX_1AF4334B2C470185 (puppet_package_id), UNIQUE INDEX server_puppet_package_server_puppet_package_idx (server_id, puppet_package_id), PRIMARY KEY(server_id, puppet_package_id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
		    4 Query	CREATE TABLE server_puppet_package_must_use_flags (server_id INT NOT NULL, puppet_package_id INT NOT NULL, puppet_flag_id INT NOT NULL, INDEX IDX_4A244E471844E6B72C470185 (server_id, puppet_package_id), INDEX IDX_4A244E475C13510E (puppet_flag_id), PRIMARY KEY(server_id, puppet_package_id, puppet_flag_id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
		    4 Query	CREATE TABLE server_puppet_package_not_use_flags (server_id INT NOT NULL, puppet_package_id INT NOT NULL, puppet_flag_id INT NOT NULL, INDEX IDX_C669A4781844E6B72C470185 (server_id, puppet_package_id), INDEX IDX_C669A4785C13510E (puppet_flag_id), PRIMARY KEY(server_id, puppet_package_id, puppet_flag_id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
		    4 Query	CREATE TABLE server_service (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(60) NOT NULL, code VARCHAR(30) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
		    4 Query	CREATE TABLE server_service_puppet_class (server_service_id INT NOT NULL, puppet_class_id INT NOT NULL, INDEX IDX_41FA90A43F933941 (server_service_id), INDEX IDX_41FA90A4DD15BC55 (puppet_class_id), PRIMARY KEY(server_service_id, puppet_class_id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
		    4 Query	CREATE TABLE service_ip (id INT AUTO_INCREMENT NOT NULL, server_id INT NOT NULL, status SMALLINT NOT NULL, description VARCHAR(20) DEFAULT NULL, ip VARCHAR(15) NOT NULL, netmask VARCHAR(20) NOT NULL, INDEX IDX_F7867D9B1844E6B7 (server_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
		    4 Query	CREATE TABLE service_ips_services (service_ip_id INT NOT NULL, server_service_id INT NOT NULL, INDEX IDX_492539DC94DB378 (service_ip_id), INDEX IDX_492539DC3F933941 (server_service_id), PRIMARY KEY(service_ip_id, server_service_id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
		    4 Query	CREATE TABLE sql_database (id INT AUTO_INCREMENT NOT NULL, hosting_id INT NOT NULL, name VARCHAR(64) NOT NULL, status SMALLINT NOT NULL, added_at DATETIME NOT NULL, INDEX IDX_DDECAB46AE9044EA (hosting_id), UNIQUE INDEX sql_database_name_hosting_id_idx (name, hosting_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
		    4 Query	CREATE TABLE ssh_key (id INT AUTO_INCREMENT NOT NULL, user_id INT NOT NULL, created_at DATETIME NOT NULL, title VARCHAR(50) NOT NULL, content LONGTEXT NOT NULL, fingerprint VARCHAR(255) NOT NULL, bytes INT NOT NULL, type VARCHAR(16) NOT NULL, INDEX IDX_82A73B64A76ED395 (user_id), UNIQUE INDEX ssh_key_user_id_fingerprint_unique_idx (user_id, fingerprint), PRIMARY KEY(id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
		    4 Query	CREATE TABLE ssl_certificate (id INT AUTO_INCREMENT NOT NULL, vendor_id INT NOT NULL, user_id INT NOT NULL, expire_ticket_id INT DEFAULT NULL, domain VARCHAR(200) NOT NULL, subdomains LONGTEXT DEFAULT NULL COMMENT '(DC2Type:simple_array)', wildcard TINYINT(1) NOT NULL, verified TINYINT(1) NOT NULL, dns_challenges LONGTEXT DEFAULT NULL COMMENT '(DC2Type:json_array)', http_challenges LONGTEXT DEFAULT NULL COMMENT '(DC2Type:json_array)', challenges_updated_at DATETIME DEFAULT NULL, valid_from DATE DEFAULT NULL, valid_to DATE DEFAULT NULL, privkey LONGTEXT DEFAULT NULL, pubkey LONGTEXT DEFAULT NULL, csr LONGTEXT DEFAULT NULL, cert LONGTEXT DEFAULT NULL, chain LONGTEXT DEFAULT NULL, created_at DATETIME NOT NULL, verified_at DATETIME DEFAULT NULL, last_error VARCHAR(255) DEFAULT NULL, INDEX IDX_C641E8D2F603EE73 (vendor_id), INDEX IDX_C641E8D2A76ED395 (user_id), UNIQUE INDEX UNIQ_C641E8D2329BC5B4 (expire_ticket_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
		    4 Query	CREATE TABLE ssl_certificate_vendor (id INT AUTO_INCREMENT NOT NULL, simple_product_id INT DEFAULT NULL, wildcard_product_id INT DEFAULT NULL, code VARCHAR(32) NOT NULL, name VARCHAR(32) NOT NULL, automated TINYINT(1) NOT NULL, UNIQUE INDEX UNIQ_FCEF9FD577153098 (code), UNIQUE INDEX UNIQ_FCEF9FD55E237E06 (name), INDEX IDX_FCEF9FD527543CCA (simple_product_id), INDEX IDX_FCEF9FD52983543 (wildcard_product_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
		    4 Query	CREATE TABLE subdomain (id INT AUTO_INCREMENT NOT NULL, hosting_id INT NOT NULL, name VARCHAR(64) NOT NULL, name_canonical VARCHAR(255) NOT NULL, status SMALLINT NOT NULL, added_at DATETIME NOT NULL, subpath VARCHAR(256) NOT NULL, cdn TINYINT(1) NOT NULL, INDEX IDX_C1D5962EAE9044EA (hosting_id), UNIQUE INDEX subdomain_name_hosting_id_idx (name, hosting_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
		    4 Query	CREATE TABLE tax_rule (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(64) NOT NULL, INDEX tax_rule_name_idx (name), PRIMARY KEY(id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
		    4 Query	CREATE TABLE tax_value (id INT AUTO_INCREMENT NOT NULL, tax_rule_id INT NOT NULL, value DOUBLE PRECISION NOT NULL, begins_at DATE NOT NULL, INDEX IDX_AE0DAD153506A35B (tax_rule_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
		    4 Query	CREATE TABLE ticket (id INT AUTO_INCREMENT NOT NULL, category_id INT DEFAULT NULL, author_id INT NOT NULL, assigned_id INT DEFAULT NULL, organization_id INT DEFAULT NULL, server_id INT DEFAULT NULL, title VARCHAR(128) NOT NULL, level SMALLINT NOT NULL, added_at DATETIME NOT NULL, updated_at DATETIME DEFAULT NULL, assigned_at DATETIME DEFAULT NULL, closed_at DATETIME DEFAULT NULL, priority SMALLINT NOT NULL, state SMALLINT NOT NULL, awaiting_answer_reminded TINYINT(1) NOT NULL, feedback_score SMALLINT DEFAULT NULL, feedback_comment LONGTEXT DEFAULT NULL, feedback_done_at DATETIME DEFAULT NULL, awaiting_feedback_reminded TINYINT(1) NOT NULL, INDEX IDX_97A0ADA312469DE2 (category_id), INDEX IDX_97A0ADA3F675F31B (author_id), INDEX IDX_97A0ADA3E1501A05 (assigned_id), INDEX IDX_97A0ADA332C8A3DE (organization_id), INDEX IDX_97A0ADA31844E6B7 (server_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
		    4 Query	CREATE TABLE tickets_tags (ticket_id INT NOT NULL, tag_id INT NOT NULL, INDEX IDX_6AC742FB700047D2 (ticket_id), INDEX IDX_6AC742FBBAD26311 (tag_id), PRIMARY KEY(ticket_id, tag_id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
		    4 Query	CREATE TABLE ticket_audit (id INT NOT NULL, rev INT NOT NULL, category_id INT DEFAULT NULL, author_id INT DEFAULT NULL, assigned_id INT DEFAULT NULL, organization_id INT DEFAULT NULL, server_id INT DEFAULT NULL, title VARCHAR(128) DEFAULT NULL, level SMALLINT DEFAULT NULL, added_at DATETIME DEFAULT NULL, updated_at DATETIME DEFAULT NULL, assigned_at DATETIME DEFAULT NULL, closed_at DATETIME DEFAULT NULL, priority SMALLINT DEFAULT NULL, state SMALLINT DEFAULT NULL, awaiting_answer_reminded TINYINT(1) DEFAULT NULL, feedback_score SMALLINT DEFAULT NULL, feedback_comment LONGTEXT DEFAULT NULL, feedback_done_at DATETIME DEFAULT NULL, awaiting_feedback_reminded TINYINT(1) DEFAULT NULL, revtype VARCHAR(4) NOT NULL, INDEX rev_b56ca44a6643a590d2c9cdb6b0b2e6f8_idx (rev), PRIMARY KEY(id, rev)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
		    4 Query	CREATE TABLE ticket_category (id INT AUTO_INCREMENT NOT NULL, code VARCHAR(32) NOT NULL, name VARCHAR(64) NOT NULL, level INT NOT NULL, recipient_email VARCHAR(255) DEFAULT NULL, UNIQUE INDEX UNIQ_8325E54077153098 (code), PRIMARY KEY(id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
		    4 Query	CREATE TABLE ticket_file (id INT AUTO_INCREMENT NOT NULL, author_id INT NOT NULL, ticket_id INT NOT NULL, name VARCHAR(255) NOT NULL, path VARCHAR(255) NOT NULL, INDEX IDX_BE442328F675F31B (author_id), INDEX IDX_BE442328700047D2 (ticket_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
		    4 Query	CREATE TABLE ticket_message (id INT AUTO_INCREMENT NOT NULL, author_id INT NOT NULL, ticket_id INT NOT NULL, content LONGTEXT NOT NULL, added_at DATETIME NOT NULL, INDEX IDX_BA71692DF675F31B (author_id), INDEX IDX_BA71692D700047D2 (ticket_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
		    4 Query	CREATE TABLE ticket_note (id INT AUTO_INCREMENT NOT NULL, ticket_id INT NOT NULL, author_id INT NOT NULL, content LONGTEXT NOT NULL, created_at DATETIME NOT NULL, INDEX IDX_FD66EF2C700047D2 (ticket_id), INDEX IDX_FD66EF2CF675F31B (author_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
		    4 Query	CREATE TABLE ticket_tag (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(20) NOT NULL, UNIQUE INDEX UNIQ_F06CAF5E237E06 (name), PRIMARY KEY(id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
		    4 Query	CREATE TABLE fos_user (id INT AUTO_INCREMENT NOT NULL, country_id INT NOT NULL, bank_account_id INT DEFAULT NULL, credit_card_id INT DEFAULT NULL, username VARCHAR(180) NOT NULL, username_canonical VARCHAR(180) NOT NULL, email VARCHAR(180) NOT NULL, email_canonical VARCHAR(180) NOT NULL, enabled TINYINT(1) NOT NULL, salt VARCHAR(255) DEFAULT NULL, password VARCHAR(255) NOT NULL, last_login DATETIME DEFAULT NULL, confirmation_token VARCHAR(180) DEFAULT NULL, password_requested_at DATETIME DEFAULT NULL, roles LONGTEXT NOT NULL COMMENT '(DC2Type:array)', firstname VARCHAR(64) DEFAULT NULL, lastname VARCHAR(64) DEFAULT NULL, notes LONGTEXT DEFAULT NULL, locale VARCHAR(5) NOT NULL, support_level SMALLINT DEFAULT NULL, default_password TINYINT(1) NOT NULL, last_activity DATETIME DEFAULT NULL, email_invoice VARCHAR(255) DEFAULT NULL, company VARCHAR(64) DEFAULT NULL, position VARCHAR(64) DEFAULT NULL, street1 VARCHAR(64) DEFAULT NULL, street2 VARCHAR(64) DEFAULT NULL, postal_code VARCHAR(32) DEFAULT NULL, city VARCHAR(64) DEFAULT NULL, phonenumber VARCHAR(64) DEFAULT NULL, skype VARCHAR(128) DEFAULT NULL, siret VARCHAR(32) DEFAULT NULL, nif VARCHAR(32) DEFAULT NULL, default_payment_method VARCHAR(32) NOT NULL, automatic_payment_method VARCHAR(10) NOT NULL, payment_frequency INT NOT NULL, invoice_unlock TINYINT(1) NOT NULL, invoice_recoverable TINYINT(1) NOT NULL, invoice_due_date_gap INT NOT NULL, billing_reminder_prevent TINYINT(1) NOT NULL, billing_reminder_level INT NOT NULL, billing_r1_date DATE DEFAULT NULL, billing_r2_date DATE DEFAULT NULL, billing_r3_date DATE DEFAULT NULL, mail_on_login TINYINT(1) NOT NULL, mail_on_service_block TINYINT(1) NOT NULL, disconnect_on_ip_change TINYINT(1) NOT NULL, UNIQUE INDEX UNIQ_957A647992FC23A8 (username_canonical), UNIQUE INDEX UNIQ_957A6479A0D96FBF (email_canonical), UNIQUE INDEX UNIQ_957A6479C05FB297 (confirmation_token), INDEX IDX_957A6479F92F3E70 (country_id), UNIQUE INDEX UNIQ_957A647912CB990C (bank_account_id), UNIQUE INDEX UNIQ_957A64797048FD0F (credit_card_id), INDEX fos_user_default_payment_method_idx (default_payment_method), PRIMARY KEY(id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
		    4 Query	CREATE TABLE fos_user_user_group (user_id INT NOT NULL, group_id INT NOT NULL, INDEX IDX_B3C77447A76ED395 (user_id), INDEX IDX_B3C77447FE54D947 (group_id), PRIMARY KEY(user_id, group_id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
		    4 Query	CREATE TABLE fos_user_audit (id INT NOT NULL, rev INT NOT NULL, country_id INT DEFAULT NULL, bank_account_id INT DEFAULT NULL, credit_card_id INT DEFAULT NULL, username VARCHAR(180) DEFAULT NULL, username_canonical VARCHAR(180) DEFAULT NULL, email VARCHAR(180) DEFAULT NULL, email_canonical VARCHAR(180) DEFAULT NULL, enabled TINYINT(1) DEFAULT NULL, salt VARCHAR(255) DEFAULT NULL, password VARCHAR(255) DEFAULT NULL, last_login DATETIME DEFAULT NULL, confirmation_token VARCHAR(180) DEFAULT NULL, password_requested_at DATETIME DEFAULT NULL, roles LONGTEXT DEFAULT NULL COMMENT '(DC2Type:array)', firstname VARCHAR(64) DEFAULT NULL, lastname VARCHAR(64) DEFAULT NULL, notes LONGTEXT DEFAULT NULL, locale VARCHAR(5) DEFAULT NULL, support_level SMALLINT DEFAULT NULL, default_password TINYINT(1) DEFAULT NULL, last_activity DATETIME DEFAULT NULL, email_invoice VARCHAR(255) DEFAULT NULL, company VARCHAR(64) DEFAULT NULL, position VARCHAR(64) DEFAULT NULL, street1 VARCHAR(64) DEFAULT NULL, street2 VARCHAR(64) DEFAULT NULL, postal_code VARCHAR(32) DEFAULT NULL, city VARCHAR(64) DEFAULT NULL, phonenumber VARCHAR(64) DEFAULT NULL, skype VARCHAR(128) DEFAULT NULL, siret VARCHAR(32) DEFAULT NULL, nif VARCHAR(32) DEFAULT NULL, default_payment_method VARCHAR(32) DEFAULT NULL, automatic_payment_method VARCHAR(10) DEFAULT NULL, payment_frequency INT DEFAULT NULL, invoice_unlock TINYINT(1) DEFAULT NULL, invoice_recoverable TINYINT(1) DEFAULT NULL, invoice_due_date_gap INT DEFAULT NULL, billing_reminder_prevent TINYINT(1) DEFAULT NULL, billing_reminder_level INT DEFAULT NULL, billing_r1_date DATE DEFAULT NULL, billing_r2_date DATE DEFAULT NULL, billing_r3_date DATE DEFAULT NULL, mail_on_login TINYINT(1) DEFAULT NULL, mail_on_service_block TINYINT(1) DEFAULT NULL, disconnect_on_ip_change TINYINT(1) DEFAULT NULL, revtype VARCHAR(4) NOT NULL, INDEX rev_d9870eead047c03f7e6da36008648432_idx (rev), PRIMARY KEY(id, rev)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
		    4 Query	CREATE TABLE user_browser (browser_id VARCHAR(64) NOT NULL, user_id INT NOT NULL, used_at DATETIME NOT NULL, ip VARCHAR(64) DEFAULT NULL, reverse VARCHAR(255) DEFAULT NULL, name VARCHAR(64) DEFAULT NULL, verification_code VARCHAR(6) DEFAULT NULL, verification_asked_at DATETIME DEFAULT NULL, browser_details LONGTEXT NOT NULL COMMENT '(DC2Type:array)', INDEX IDX_821E1130A76ED395 (user_id), PRIMARY KEY(user_id, browser_id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
		    4 Query	CREATE TABLE valid_tld (name VARCHAR(64) NOT NULL, name_canonical VARCHAR(255) NOT NULL, favorite TINYINT(1) NOT NULL, UNIQUE INDEX UNIQ_35AFF9C8D322CED6 (name_canonical), PRIMARY KEY(name)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
		    4 Query	CREATE TABLE ext_log_entries (id INT AUTO_INCREMENT NOT NULL, action VARCHAR(8) NOT NULL, logged_at DATETIME NOT NULL, object_id VARCHAR(64) DEFAULT NULL, object_class VARCHAR(255) NOT NULL, version INT NOT NULL, data LONGTEXT DEFAULT NULL COMMENT '(DC2Type:array)', username VARCHAR(255) DEFAULT NULL, INDEX log_class_lookup_idx (object_class), INDEX log_date_lookup_idx (logged_at), INDEX log_user_lookup_idx (username), INDEX log_version_lookup_idx (object_id, object_class, version), PRIMARY KEY(id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
		    4 Query	CREATE TABLE revisions (id INT AUTO_INCREMENT NOT NULL, timestamp DATETIME NOT NULL, username VARCHAR(255) DEFAULT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB
		    4 Query	ALTER TABLE access_token ADD CONSTRAINT FK_B6A2DD6819EB6921 FOREIGN KEY (client_id) REFERENCES oauth_client (id)
		    4 Query	ALTER TABLE access_token ADD CONSTRAINT FK_B6A2DD68A76ED395 FOREIGN KEY (user_id) REFERENCES fos_user (id)
		    4 Query	ALTER TABLE accounting ADD CONSTRAINT FK_6DC501E53506A35B FOREIGN KEY (tax_rule_id) REFERENCES tax_rule (id)
		    4 Query	ALTER TABLE accounting ADD CONSTRAINT FK_6DC501E5F92F3E70 FOREIGN KEY (country_id) REFERENCES country (id)
		    4 Query	ALTER TABLE accounting_accountant ADD CONSTRAINT FK_843D764D3B7DD068 FOREIGN KEY (accounting_id) REFERENCES accounting (id)
		    4 Query	ALTER TABLE accounting_accountant ADD CONSTRAINT FK_843D764D9582AA74 FOREIGN KEY (accountant_id) REFERENCES fos_user (id)
		    4 Query	ALTER TABLE accounting_translation ADD CONSTRAINT FK_C8D6FFBF2C2AC5D3 FOREIGN KEY (translatable_id) REFERENCES accounting (id) ON DELETE CASCADE
		    4 Query	ALTER TABLE api_key ADD CONSTRAINT FK_C912ED9DA76ED395 FOREIGN KEY (user_id) REFERENCES fos_user (id)
		    4 Query	ALTER TABLE auth_code ADD CONSTRAINT FK_5933D02C19EB6921 FOREIGN KEY (client_id) REFERENCES oauth_client (id)
		    4 Query	ALTER TABLE auth_code ADD CONSTRAINT FK_5933D02CA76ED395 FOREIGN KEY (user_id) REFERENCES fos_user (id)
		    4 Query	ALTER TABLE billing_note ADD CONSTRAINT FK_B0CFC4D3F675F31B FOREIGN KEY (author_id) REFERENCES fos_user (id)
		    4 Query	ALTER TABLE billing_note ADD CONSTRAINT FK_B0CFC4D39395C3F3 FOREIGN KEY (customer_id) REFERENCES fos_user (id)
		    4 Query	ALTER TABLE changelog ADD CONSTRAINT FK_C8422601B5A459A0 FOREIGN KEY (news_id) REFERENCES news (id)
		    4 Query	ALTER TABLE cloudflare_zone ADD CONSTRAINT FK_351290047E3C61F9 FOREIGN KEY (owner_id) REFERENCES fos_user (id)
		    4 Query	ALTER TABLE credit_note ADD CONSTRAINT FK_C87F45293B7DD068 FOREIGN KEY (accounting_id) REFERENCES accounting (id)
		    4 Query	ALTER TABLE credit_note ADD CONSTRAINT FK_C87F45299395C3F3 FOREIGN KEY (customer_id) REFERENCES fos_user (id)
		    4 Query	ALTER TABLE credit_note_item ADD CONSTRAINT FK_7EABC2541C696F7A FOREIGN KEY (credit_note_id) REFERENCES credit_note (ref) ON DELETE CASCADE
		    4 Query	ALTER TABLE cron ADD CONSTRAINT FK_17CD00F8AE9044EA FOREIGN KEY (hosting_id) REFERENCES hosting (id) ON DELETE CASCADE
		    4 Query	ALTER TABLE domain_name ADD CONSTRAINT FK_F3FF5361558FBEB9 FOREIGN KEY (purchase_id) REFERENCES purchase (id)
		    4 Query	ALTER TABLE domain_name ADD CONSTRAINT FK_F3FF5361329BC5B4 FOREIGN KEY (expire_ticket_id) REFERENCES ticket (id)
		    4 Query	ALTER TABLE email ADD CONSTRAINT FK_E7927C74A76ED395 FOREIGN KEY (user_id) REFERENCES fos_user (id)
		    4 Query	ALTER TABLE expense ADD CONSTRAINT FK_2D3A8DA612469DE2 FOREIGN KEY (category_id) REFERENCES expense_category (id)
180518 15:17:32	    4 Query	ALTER TABLE favorite ADD CONSTRAINT FK_68C58ED9A76ED395 FOREIGN KEY (user_id) REFERENCES fos_user (id)
		    4 Query	ALTER TABLE ftp_account ADD CONSTRAINT FK_B0BB6310AE9044EA FOREIGN KEY (hosting_id) REFERENCES hosting (id) ON DELETE CASCADE
		    4 Query	ALTER TABLE hosting ADD CONSTRAINT FK_E9168FDA1844E6B7 FOREIGN KEY (server_id) REFERENCES server (id)
		    4 Query	ALTER TABLE hosting_sshkey ADD CONSTRAINT FK_54F49891AE9044EA FOREIGN KEY (hosting_id) REFERENCES hosting (id)
		    4 Query	ALTER TABLE hosting_sshkey ADD CONSTRAINT FK_54F49891D145533 FOREIGN KEY (key_id) REFERENCES ssh_key (id)
		    4 Query	ALTER TABLE hosting_alias ADD CONSTRAINT FK_38067C6EAE9044EA FOREIGN KEY (hosting_id) REFERENCES hosting (id) ON DELETE CASCADE
		    4 Query	ALTER TABLE hosting_alias ADD CONSTRAINT FK_38067C6E8530A5DC FOREIGN KEY (subdomain_id) REFERENCES subdomain (id) ON DELETE CASCADE
		    4 Query	ALTER TABLE hosting_ssl_certificate ADD CONSTRAINT FK_76FE21DFAE9044EA FOREIGN KEY (hosting_id) REFERENCES hosting (id) ON DELETE CASCADE
		    4 Query	ALTER TABLE hosting_ssl_certificate ADD CONSTRAINT FK_76FE21DF8530A5DC FOREIGN KEY (subdomain_id) REFERENCES subdomain (id) ON DELETE CASCADE
		    4 Query	ALTER TABLE hosting_ssl_certificate ADD CONSTRAINT FK_76FE21DF99223FFD FOREIGN KEY (certificate_id) REFERENCES ssl_certificate (id)
		    4 Query	ALTER TABLE incident ADD CONSTRAINT FK_3D03A11A1844E6B7 FOREIGN KEY (server_id) REFERENCES server (id) ON DELETE CASCADE
		    4 Query	ALTER TABLE incident ADD CONSTRAINT FK_3D03A11AE1501A05 FOREIGN KEY (assigned_id) REFERENCES fos_user (id)
		    4 Query	ALTER TABLE incident_comment ADD CONSTRAINT FK_33BE48B159E53FB9 FOREIGN KEY (incident_id) REFERENCES incident (id) ON DELETE CASCADE
		    4 Query	ALTER TABLE incident_comment ADD CONSTRAINT FK_33BE48B1F675F31B FOREIGN KEY (author_id) REFERENCES fos_user (id)
		    4 Query	ALTER TABLE invoice ADD CONSTRAINT FK_906517449395C3F3 FOREIGN KEY (customer_id) REFERENCES fos_user (id)
		    4 Query	ALTER TABLE invoice ADD CONSTRAINT FK_906517443B7DD068 FOREIGN KEY (accounting_id) REFERENCES accounting (id)
		    4 Query	ALTER TABLE invoice_item ADD CONSTRAINT FK_1DDE477B2989F1FD FOREIGN KEY (invoice_id) REFERENCES invoice (ref) ON DELETE CASCADE
		    4 Query	ALTER TABLE ip_v4 ADD CONSTRAINT FK_60E01F5FE54D947 FOREIGN KEY (group_id) REFERENCES ip_group (id)
		    4 Query	ALTER TABLE ip_v4 ADD CONSTRAINT FK_60E01F51844E6B7 FOREIGN KEY (server_id) REFERENCES server (id) ON DELETE SET NULL
		    4 Query	ALTER TABLE ip_v6 ADD CONSTRAINT FK_E80060D92A82D0B1 FOREIGN KEY (range_id) REFERENCES ip_v6_range (id) ON DELETE CASCADE
		    4 Query	ALTER TABLE ip_v6_range ADD CONSTRAINT FK_124D0D67FE54D947 FOREIGN KEY (group_id) REFERENCES ip_group (id)
		    4 Query	ALTER TABLE ip_v6_range ADD CONSTRAINT FK_124D0D671844E6B7 FOREIGN KEY (server_id) REFERENCES server (id)
		    4 Query	ALTER TABLE fos_user_login_action ADD CONSTRAINT FK_C7C9A160A76ED395 FOREIGN KEY (user_id) REFERENCES fos_user (id)
		    4 Query	ALTER TABLE mailalias ADD CONSTRAINT FK_113288E6AE9044EA FOREIGN KEY (hosting_id) REFERENCES hosting (id) ON DELETE CASCADE
		    4 Query	ALTER TABLE mailalias ADD CONSTRAINT FK_113288E68530A5DC FOREIGN KEY (subdomain_id) REFERENCES subdomain (id) ON DELETE CASCADE
		    4 Query	ALTER TABLE mailalias_destination ADD CONSTRAINT FK_DD4CFAB1F0A32AF0 FOREIGN KEY (mailalias_id) REFERENCES mailalias (id) ON DELETE CASCADE
		    4 Query	ALTER TABLE mailbox ADD CONSTRAINT FK_A69FE20BAE9044EA FOREIGN KEY (hosting_id) REFERENCES hosting (id) ON DELETE CASCADE
		    4 Query	ALTER TABLE mailbox ADD CONSTRAINT FK_A69FE20B8530A5DC FOREIGN KEY (subdomain_id) REFERENCES subdomain (id) ON DELETE CASCADE
		    4 Query	ALTER TABLE maintenance_server ADD CONSTRAINT FK_7090E3FFF6C202BC FOREIGN KEY (maintenance_id) REFERENCES maintenance (id)
		    4 Query	ALTER TABLE maintenance_server ADD CONSTRAINT FK_7090E3FF1844E6B7 FOREIGN KEY (server_id) REFERENCES server (id) ON DELETE CASCADE
		    4 Query	ALTER TABLE nagios_event ADD CONSTRAINT FK_3C08274E59E53FB9 FOREIGN KEY (incident_id) REFERENCES incident (id) ON DELETE CASCADE
		    4 Query	ALTER TABLE notification ADD CONSTRAINT FK_BF5476CAA76ED395 FOREIGN KEY (user_id) REFERENCES fos_user (id)
		    4 Query	ALTER TABLE operation ADD CONSTRAINT FK_1981A66DF675F31B FOREIGN KEY (author_id) REFERENCES fos_user (id)
		    4 Query	ALTER TABLE operation ADD CONSTRAINT FK_1981A66D1844E6B7 FOREIGN KEY (server_id) REFERENCES server (id) ON DELETE CASCADE
		    4 Query	ALTER TABLE operation ADD CONSTRAINT FK_1981A66DAE9044EA FOREIGN KEY (hosting_id) REFERENCES hosting (id) ON DELETE SET NULL
		    4 Query	ALTER TABLE operation ADD CONSTRAINT FK_1981A66D8530A5DC FOREIGN KEY (subdomain_id) REFERENCES subdomain (id) ON DELETE SET NULL
		    4 Query	ALTER TABLE operation ADD CONSTRAINT FK_1981A66D5E564AE2 FOREIGN KEY (alias_id) REFERENCES hosting_alias (id) ON DELETE SET NULL
		    4 Query	ALTER TABLE operation ADD CONSTRAINT FK_1981A66D360E7DB3 FOREIGN KEY (hosting_ssl_certificate_id) REFERENCES hosting_ssl_certificate (id) ON DELETE SET NULL
		    4 Query	ALTER TABLE operation ADD CONSTRAINT FK_1981A66DF0AA09DB FOREIGN KEY (database_id) REFERENCES sql_database (id) ON DELETE SET NULL
		    4 Query	ALTER TABLE operation ADD CONSTRAINT FK_1981A66D66EC35CC FOREIGN KEY (mailbox_id) REFERENCES mailbox (id) ON DELETE SET NULL
		    4 Query	ALTER TABLE operation ADD CONSTRAINT FK_1981A66DF0A32AF0 FOREIGN KEY (mailalias_id) REFERENCES mailalias (id) ON DELETE SET NULL
		    4 Query	ALTER TABLE operation ADD CONSTRAINT FK_1981A66D38435942 FOREIGN KEY (cron_id) REFERENCES cron (id) ON DELETE SET NULL
		    4 Query	ALTER TABLE operation ADD CONSTRAINT FK_1981A66D68043490 FOREIGN KEY (ftp_account_id) REFERENCES ftp_account (id) ON DELETE SET NULL
		    4 Query	ALTER TABLE operation ADD CONSTRAINT FK_1981A66D94DB378 FOREIGN KEY (service_ip_id) REFERENCES service_ip (id) ON DELETE SET NULL
		    4 Query	ALTER TABLE organization_member ADD CONSTRAINT FK_756A2A8D32C8A3DE FOREIGN KEY (organization_id) REFERENCES organization (id)
		    4 Query	ALTER TABLE organization_member ADD CONSTRAINT FK_756A2A8DA76ED395 FOREIGN KEY (user_id) REFERENCES fos_user (id)
		    4 Query	ALTER TABLE package ADD CONSTRAINT FK_DE6867951844E6B7 FOREIGN KEY (server_id) REFERENCES server (id) ON DELETE CASCADE
		    4 Query	ALTER TABLE package ADD CONSTRAINT FK_DE6867959DF42389 FOREIGN KEY (package_model_id) REFERENCES package_model (id) ON DELETE CASCADE
		    4 Query	ALTER TABLE payment ADD CONSTRAINT FK_6D28840D1C696F7A FOREIGN KEY (credit_note_id) REFERENCES credit_note (ref)
		    4 Query	ALTER TABLE payment ADD CONSTRAINT FK_6D28840D2989F1FD FOREIGN KEY (invoice_id) REFERENCES invoice (ref)
		    4 Query	ALTER TABLE product ADD CONSTRAINT FK_D34A04AD12469DE2 FOREIGN KEY (category_id) REFERENCES product_category (id)
		    4 Query	ALTER TABLE product_category_features ADD CONSTRAINT FK_BC3F6A3BBE6903FD FOREIGN KEY (product_category_id) REFERENCES product_category (id)
		    4 Query	ALTER TABLE product_category_features ADD CONSTRAINT FK_BC3F6A3B60E4B879 FOREIGN KEY (feature_id) REFERENCES product_category_feature (id)
		    4 Query	ALTER TABLE product_category_feature_value ADD CONSTRAINT FK_8834409060E4B879 FOREIGN KEY (feature_id) REFERENCES product_category_feature (id)
		    4 Query	ALTER TABLE product_feature_value ADD CONSTRAINT FK_EC44ECFF920BBA2 FOREIGN KEY (value_id) REFERENCES product_category_feature_value (id)
		    4 Query	ALTER TABLE product_feature_value ADD CONSTRAINT FK_EC44ECF60E4B879 FOREIGN KEY (feature_id) REFERENCES product_category_feature (id)
		    4 Query	ALTER TABLE product_feature_value ADD CONSTRAINT FK_EC44ECF4584665A FOREIGN KEY (product_id) REFERENCES product (id)
		    4 Query	ALTER TABLE puppet_classes_packages ADD CONSTRAINT FK_15F56CA7EA000B10 FOREIGN KEY (class_id) REFERENCES puppet_class (id)
		    4 Query	ALTER TABLE puppet_classes_packages ADD CONSTRAINT FK_15F56CA7F44CABFF FOREIGN KEY (package_id) REFERENCES puppet_package (id)
		    4 Query	ALTER TABLE puppet_flag ADD CONSTRAINT FK_DAF8BF8FFE54D947 FOREIGN KEY (group_id) REFERENCES puppet_flag_group (id) ON DELETE CASCADE
		    4 Query	ALTER TABLE puppet_package_available_flags ADD CONSTRAINT FK_D5060A7F2C470185 FOREIGN KEY (puppet_package_id) REFERENCES puppet_package (id)
		    4 Query	ALTER TABLE puppet_package_available_flags ADD CONSTRAINT FK_D5060A7F5C13510E FOREIGN KEY (puppet_flag_id) REFERENCES puppet_flag (id) ON DELETE CASCADE
		    4 Query	ALTER TABLE puppet_package_default_enabled_flags ADD CONSTRAINT FK_671C8E032C470185 FOREIGN KEY (puppet_package_id) REFERENCES puppet_package (id)
		    4 Query	ALTER TABLE puppet_package_default_enabled_flags ADD CONSTRAINT FK_671C8E035C13510E FOREIGN KEY (puppet_flag_id) REFERENCES puppet_flag (id) ON DELETE CASCADE
		    4 Query	ALTER TABLE puppet_package_default_disabled_flags ADD CONSTRAINT FK_7EF53A532C470185 FOREIGN KEY (puppet_package_id) REFERENCES puppet_package (id)
		    4 Query	ALTER TABLE puppet_package_default_disabled_flags ADD CONSTRAINT FK_7EF53A535C13510E FOREIGN KEY (puppet_flag_id) REFERENCES puppet_flag (id) ON DELETE CASCADE
		    4 Query	ALTER TABLE puppet_template_classes ADD CONSTRAINT FK_95E04FE55DA0FB8 FOREIGN KEY (template_id) REFERENCES puppet_template (id)
		    4 Query	ALTER TABLE puppet_template_classes ADD CONSTRAINT FK_95E04FE5EA000B10 FOREIGN KEY (class_id) REFERENCES puppet_class (id)
		    4 Query	ALTER TABLE purchase ADD CONSTRAINT FK_6117D13B9395C3F3 FOREIGN KEY (customer_id) REFERENCES fos_user (id)
		    4 Query	ALTER TABLE purchase ADD CONSTRAINT FK_6117D13B4584665A FOREIGN KEY (product_id) REFERENCES product (id)
		    4 Query	ALTER TABLE purchase ADD CONSTRAINT FK_6117D13B3B7DD068 FOREIGN KEY (accounting_id) REFERENCES accounting (id)
		    4 Query	ALTER TABLE purchase_invoice ADD CONSTRAINT FK_8BBFDD3D558FBEB9 FOREIGN KEY (purchase_id) REFERENCES purchase (id) ON DELETE CASCADE
		    4 Query	ALTER TABLE purchase_invoice ADD CONSTRAINT FK_8BBFDD3DBC9E5160 FOREIGN KEY (invoice_ref) REFERENCES invoice (ref)
		    4 Query	ALTER TABLE refresh_token ADD CONSTRAINT FK_C74F219519EB6921 FOREIGN KEY (client_id) REFERENCES oauth_client (id)
		    4 Query	ALTER TABLE refresh_token ADD CONSTRAINT FK_C74F2195A76ED395 FOREIGN KEY (user_id) REFERENCES fos_user (id)
		    4 Query	ALTER TABLE server ADD CONSTRAINT FK_5A6DD5F63DCA04D1 FOREIGN KEY (os_id) REFERENCES os (id)
		    4 Query	ALTER TABLE server ADD CONSTRAINT FK_5A6DD5F6558FBEB9 FOREIGN KEY (purchase_id) REFERENCES purchase (id) ON DELETE SET NULL
		    4 Query	ALTER TABLE server ADD CONSTRAINT FK_5A6DD5F6EC07A5C FOREIGN KEY (backup_model_id) REFERENCES backup_model (id)
		    4 Query	ALTER TABLE server_owner ADD CONSTRAINT FK_6FE184751844E6B7 FOREIGN KEY (server_id) REFERENCES server (id)
		    4 Query	ALTER TABLE server_owner ADD CONSTRAINT FK_6FE184757E3C61F9 FOREIGN KEY (owner_id) REFERENCES fos_user (id)
		    4 Query	ALTER TABLE server_organization ADD CONSTRAINT FK_D0A708D91844E6B7 FOREIGN KEY (server_id) REFERENCES server (id)
		    4 Query	ALTER TABLE server_organization ADD CONSTRAINT FK_D0A708D932C8A3DE FOREIGN KEY (organization_id) REFERENCES organization (id)
		    4 Query	ALTER TABLE server_puppet_templates ADD CONSTRAINT FK_1C95C46E1844E6B7 FOREIGN KEY (server_id) REFERENCES server (id)
		    4 Query	ALTER TABLE server_puppet_templates ADD CONSTRAINT FK_1C95C46EB5D29C30 FOREIGN KEY (puppet_template_id) REFERENCES puppet_template (id)
		    4 Query	ALTER TABLE server_puppet_classes ADD CONSTRAINT FK_C6712A1B1844E6B7 FOREIGN KEY (server_id) REFERENCES server (id)
		    4 Query	ALTER TABLE server_puppet_classes ADD CONSTRAINT FK_C6712A1BDD15BC55 FOREIGN KEY (puppet_class_id) REFERENCES puppet_class (id)
		    4 Query	ALTER TABLE server_puppet_package ADD CONSTRAINT FK_1AF4334B1844E6B7 FOREIGN KEY (server_id) REFERENCES server (id) ON DELETE CASCADE
		    4 Query	ALTER TABLE server_puppet_package ADD CONSTRAINT FK_1AF4334B2C470185 FOREIGN KEY (puppet_package_id) REFERENCES puppet_package (id)
		    4 Query	ALTER TABLE server_puppet_package_must_use_flags ADD CONSTRAINT FK_4A244E471844E6B72C470185 FOREIGN KEY (server_id, puppet_package_id) REFERENCES server_puppet_package (server_id, puppet_package_id)
		    4 Query	ALTER TABLE server_puppet_package_must_use_flags ADD CONSTRAINT FK_4A244E475C13510E FOREIGN KEY (puppet_flag_id) REFERENCES puppet_flag (id) ON DELETE CASCADE
		    4 Query	ALTER TABLE server_puppet_package_not_use_flags ADD CONSTRAINT FK_C669A4781844E6B72C470185 FOREIGN KEY (server_id, puppet_package_id) REFERENCES server_puppet_package (server_id, puppet_package_id)
		    4 Query	ALTER TABLE server_puppet_package_not_use_flags ADD CONSTRAINT FK_C669A4785C13510E FOREIGN KEY (puppet_flag_id) REFERENCES puppet_flag (id) ON DELETE CASCADE
		    4 Query	ALTER TABLE server_service_puppet_class ADD CONSTRAINT FK_41FA90A43F933941 FOREIGN KEY (server_service_id) REFERENCES server_service (id)
		    4 Query	ALTER TABLE server_service_puppet_class ADD CONSTRAINT FK_41FA90A4DD15BC55 FOREIGN KEY (puppet_class_id) REFERENCES puppet_class (id)
		    4 Query	ALTER TABLE service_ip ADD CONSTRAINT FK_F7867D9B1844E6B7 FOREIGN KEY (server_id) REFERENCES server (id)
		    4 Query	ALTER TABLE service_ips_services ADD CONSTRAINT FK_492539DC94DB378 FOREIGN KEY (service_ip_id) REFERENCES service_ip (id)
		    4 Query	ALTER TABLE service_ips_services ADD CONSTRAINT FK_492539DC3F933941 FOREIGN KEY (server_service_id) REFERENCES server_service (id)
		    4 Query	ALTER TABLE sql_database ADD CONSTRAINT FK_DDECAB46AE9044EA FOREIGN KEY (hosting_id) REFERENCES hosting (id) ON DELETE CASCADE
		    4 Query	ALTER TABLE ssh_key ADD CONSTRAINT FK_82A73B64A76ED395 FOREIGN KEY (user_id) REFERENCES fos_user (id)
		    4 Query	ALTER TABLE ssl_certificate ADD CONSTRAINT FK_C641E8D2F603EE73 FOREIGN KEY (vendor_id) REFERENCES ssl_certificate_vendor (id)
		    4 Query	ALTER TABLE ssl_certificate ADD CONSTRAINT FK_C641E8D2A76ED395 FOREIGN KEY (user_id) REFERENCES fos_user (id)
		    4 Query	ALTER TABLE ssl_certificate ADD CONSTRAINT FK_C641E8D2329BC5B4 FOREIGN KEY (expire_ticket_id) REFERENCES ticket (id)
		    4 Query	ALTER TABLE ssl_certificate_vendor ADD CONSTRAINT FK_FCEF9FD527543CCA FOREIGN KEY (simple_product_id) REFERENCES product (id)
		    4 Query	ALTER TABLE ssl_certificate_vendor ADD CONSTRAINT FK_FCEF9FD52983543 FOREIGN KEY (wildcard_product_id) REFERENCES product (id)
		    4 Query	ALTER TABLE subdomain ADD CONSTRAINT FK_C1D5962EAE9044EA FOREIGN KEY (hosting_id) REFERENCES hosting (id) ON DELETE CASCADE
		    4 Query	ALTER TABLE tax_value ADD CONSTRAINT FK_AE0DAD153506A35B FOREIGN KEY (tax_rule_id) REFERENCES tax_rule (id)
		    4 Query	ALTER TABLE ticket ADD CONSTRAINT FK_97A0ADA312469DE2 FOREIGN KEY (category_id) REFERENCES ticket_category (id) ON DELETE SET NULL
		    4 Query	ALTER TABLE ticket ADD CONSTRAINT FK_97A0ADA3F675F31B FOREIGN KEY (author_id) REFERENCES fos_user (id)
		    4 Query	ALTER TABLE ticket ADD CONSTRAINT FK_97A0ADA3E1501A05 FOREIGN KEY (assigned_id) REFERENCES fos_user (id)
		    4 Query	ALTER TABLE ticket ADD CONSTRAINT FK_97A0ADA332C8A3DE FOREIGN KEY (organization_id) REFERENCES organization (id) ON DELETE SET NULL
		    4 Query	ALTER TABLE ticket ADD CONSTRAINT FK_97A0ADA31844E6B7 FOREIGN KEY (server_id) REFERENCES server (id) ON DELETE SET NULL
		    4 Query	ALTER TABLE tickets_tags ADD CONSTRAINT FK_6AC742FB700047D2 FOREIGN KEY (ticket_id) REFERENCES ticket (id)
		    4 Query	ALTER TABLE tickets_tags ADD CONSTRAINT FK_6AC742FBBAD26311 FOREIGN KEY (tag_id) REFERENCES ticket_tag (id)
		    4 Query	ALTER TABLE ticket_file ADD CONSTRAINT FK_BE442328F675F31B FOREIGN KEY (author_id) REFERENCES fos_user (id)
		    4 Query	ALTER TABLE ticket_file ADD CONSTRAINT FK_BE442328700047D2 FOREIGN KEY (ticket_id) REFERENCES ticket (id)
		    4 Query	ALTER TABLE ticket_message ADD CONSTRAINT FK_BA71692DF675F31B FOREIGN KEY (author_id) REFERENCES fos_user (id)
		    4 Query	ALTER TABLE ticket_message ADD CONSTRAINT FK_BA71692D700047D2 FOREIGN KEY (ticket_id) REFERENCES ticket (id)
		    4 Query	ALTER TABLE ticket_note ADD CONSTRAINT FK_FD66EF2C700047D2 FOREIGN KEY (ticket_id) REFERENCES ticket (id)
		    4 Query	ALTER TABLE ticket_note ADD CONSTRAINT FK_FD66EF2CF675F31B FOREIGN KEY (author_id) REFERENCES fos_user (id)
		    4 Query	ALTER TABLE fos_user ADD CONSTRAINT FK_957A6479F92F3E70 FOREIGN KEY (country_id) REFERENCES country (id)
		    4 Query	ALTER TABLE fos_user ADD CONSTRAINT FK_957A647912CB990C FOREIGN KEY (bank_account_id) REFERENCES bank_account (id) ON DELETE SET NULL
		    4 Query	ALTER TABLE fos_user ADD CONSTRAINT FK_957A64797048FD0F FOREIGN KEY (credit_card_id) REFERENCES credit_card (id) ON DELETE SET NULL
		    4 Query	ALTER TABLE fos_user_user_group ADD CONSTRAINT FK_B3C77447A76ED395 FOREIGN KEY (user_id) REFERENCES fos_user (id)
		    4 Query	ALTER TABLE fos_user_user_group ADD CONSTRAINT FK_B3C77447FE54D947 FOREIGN KEY (group_id) REFERENCES fos_group (id)
		    4 Query	ALTER TABLE user_browser ADD CONSTRAINT FK_821E1130A76ED395 FOREIGN KEY (user_id) REFERENCES fos_user (id)
		    4 Query	DELETE FROM product_category_features
		    4 Query	DELETE FROM fos_user_user_group
		    4 Query	DELETE FROM accounting_accountant
		    4 Query	DELETE FROM purchase_invoice
		    4 Query	DELETE FROM puppet_package_available_flags
		    4 Query	DELETE FROM puppet_package_default_enabled_flags
		    4 Query	DELETE FROM puppet_package_default_disabled_flags
		    4 Query	DELETE FROM puppet_classes_packages
		    4 Query	DELETE FROM puppet_template_classes
		    4 Query	DELETE FROM server_service_puppet_class
		    4 Query	DELETE FROM server_owner
		    4 Query	DELETE FROM server_organization
		    4 Query	DELETE FROM server_puppet_templates
		    4 Query	DELETE FROM server_puppet_classes
		    4 Query	DELETE FROM maintenance_server
		    4 Query	DELETE FROM server_puppet_package_must_use_flags
		    4 Query	DELETE FROM server_puppet_package_not_use_flags
		    4 Query	DELETE FROM service_ips_services
		    4 Query	DELETE FROM hosting_sshkey
		    4 Query	DELETE FROM tickets_tags
		    4 Query	DELETE FROM domain_name
		    4 Query	DELETE FROM operation
		    4 Query	DELETE FROM hosting_ssl_certificate
		    4 Query	DELETE FROM ssl_certificate
		    4 Query	DELETE FROM ticket_message
		    4 Query	DELETE FROM ticket_note
		    4 Query	DELETE FROM ticket_file
		    4 Query	DELETE FROM ticket
		    4 Query	DELETE FROM incident_comment
		    4 Query	DELETE FROM nagios_event
		    4 Query	DELETE FROM incident
		    4 Query	DELETE FROM cron
		    4 Query	DELETE FROM ftp_account
		    4 Query	DELETE FROM hosting_alias
		    4 Query	DELETE FROM mailalias_destination
		    4 Query	DELETE FROM mailalias
		    4 Query	DELETE FROM mailbox
		    4 Query	DELETE FROM sql_database
		    4 Query	DELETE FROM subdomain
		    4 Query	DELETE FROM hosting
		    4 Query	DELETE FROM service_ip
		    4 Query	DELETE FROM server_puppet_package
		    4 Query	DELETE FROM ip_v4
		    4 Query	DELETE FROM package
		    4 Query	DELETE FROM maintenance
		    4 Query	DELETE FROM ip_v6
		    4 Query	DELETE FROM ip_v6_range
		    4 Query	DELETE FROM server
		    4 Query	DELETE FROM server_service
		    4 Query	DELETE FROM puppet_template
		    4 Query	DELETE FROM puppet_class
		    4 Query	DELETE FROM puppet_package
		    4 Query	DELETE FROM puppet_flag
		    4 Query	DELETE FROM organization_member
		    4 Query	DELETE FROM api_key
		    4 Query	DELETE FROM payment
		    4 Query	DELETE FROM purchase
		    4 Query	DELETE FROM invoice_item
		    4 Query	DELETE FROM invoice
		    4 Query	DELETE FROM user_browser
		    4 Query	DELETE FROM cloudflare_zone
		    4 Query	DELETE FROM email
		    4 Query	DELETE FROM notification
		    4 Query	DELETE FROM refresh_token
		    4 Query	DELETE FROM credit_note_item
		    4 Query	DELETE FROM credit_note
		    4 Query	DELETE FROM accounting_translation
		    4 Query	DELETE FROM accounting
		    4 Query	DELETE FROM auth_code
		    4 Query	DELETE FROM fos_user_login_action
		    4 Query	DELETE FROM ssh_key
		    4 Query	DELETE FROM billing_note
		    4 Query	DELETE FROM access_token
		    4 Query	DELETE FROM favorite
		    4 Query	DELETE FROM fos_user
		    4 Query	DELETE FROM fos_group
		    4 Query	DELETE FROM country
		    4 Query	DELETE FROM bank_account
		    4 Query	DELETE FROM credit_card
		    4 Query	DELETE FROM ticket_category
		    4 Query	DELETE FROM ticket_tag
		    4 Query	DELETE FROM organization
		    4 Query	DELETE FROM backup_model
		    4 Query	DELETE FROM os
		    4 Query	DELETE FROM ssl_certificate_vendor
		    4 Query	DELETE FROM influx_measurement_definition
		    4 Query	DELETE FROM product_feature_value
		    4 Query	DELETE FROM product
		    4 Query	DELETE FROM puppet_flag_group
		    4 Query	DELETE FROM product_category
		    4 Query	DELETE FROM product_category_feature_value
		    4 Query	DELETE FROM product_category_feature
		    4 Query	DELETE FROM expense
		    4 Query	DELETE FROM expense_category
		    4 Query	DELETE FROM ip_group
		    4 Query	DELETE FROM oauth_client
		    4 Query	DELETE FROM package_model
		    4 Query	DELETE FROM tax_value
		    4 Query	DELETE FROM tax_rule
		    4 Query	DELETE FROM graylog_type
		    4 Query	DELETE FROM changelog
		    4 Query	DELETE FROM news
		    4 Query	DELETE FROM valid_tld
		    4 Query	DELETE FROM alert
		    4 Query	DELETE FROM ext_log_entries
		    4 Query	SAVEPOINT DOCTRINE2_SAVEPOINT_2
		    4 Query	RELEASE SAVEPOINT DOCTRINE2_SAVEPOINT_2
		    4 Query	ROLLBACK TO SAVEPOINT DOCTRINE2_SAVEPOINT_2
		    4 Query	ROLLBACK
		    6 Query	ROLLBACK
		    6 Quit	
		    4 Quit	

Hope it will help you a bit @dmaicher

@soullivaneuh
Copy link
Contributor

@dmaicher Please see also: liip/LiipFunctionalTestBundle#423

@Jean85
Copy link
Contributor

Jean85 commented May 18, 2018

I do have the same issue, but I do not use the fixture backup functionality of the Liip bundle... Is it possible that the issue stems from the fact that we are using always the same static connection for everything, and this creates issues with the savepoints, which gets the same names?

@dmaicher
Copy link
Owner

So I can reproduce this issue using the following test:

https://github.com/dmaicher/doctrine-test-bundle-demo/compare/failing-test?expand=1#diff-e6d49a4a6218eade307d2e99883975ddR62

Results in

1) App\Tests\CounterTest::testTruncateTableDuringTest
Doctrine\DBAL\Driver\PDOException: SQLSTATE[42000]: Syntax error or access violation: 1305 SAVEPOINT DOCTRINE2_SAVEPOINT_2 does not exist

/var/www/doctrine-test-bundle-demo/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:62
/var/www/doctrine-test-bundle-demo/vendor/dama/doctrine-test-bundle/src/DAMA/DoctrineTestBundle/Doctrine/DBAL/StaticConnection.php:59
/var/www/doctrine-test-bundle-demo/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1449
/var/www/doctrine-test-bundle-demo/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1385
/var/www/doctrine-test-bundle-demo/vendor/doctrine/orm/lib/Doctrine/ORM/EntityManager.php:261
/var/www/doctrine-test-bundle-demo/tests/CounterTest.php:67

So basically any query run inside a user-land code transaction that causes implicit transaction commits (like ALTER table etc) is a problem for doctrine on roll-back 😢

I don't think I can fix this really. I can just recommend avoiding such queries during a test case. What do you think?

@Jean85
Copy link
Contributor

Jean85 commented May 23, 2018

Thanks @dmaicher for your debug. In my case though, I don't think I'm doing an ALTER ora a TRUNCATE... I'll try to log the queries to understand what is the trigger of this bug for me.

@soullivaneuh
Copy link
Contributor

I don't think I can fix this really. I can just recommend avoiding such queries during a test case. What do you think?

I think you are right, there is pretty much nothing you can do except helping. Thanks for the input. 👍

@theofidry
Copy link

Maybe a clearer exception message or a doc entry for the issue could be nice though :)

@Jean85
Copy link
Contributor

Jean85 commented May 24, 2018

Unfortunately the exception comes from DBAL, so we cannot intercept it. Something in the docs could be done, yeah!

@dmaicher
Copy link
Owner

dmaicher commented Jun 1, 2018

I added some info to the readme here #59

Please have a look 😉

@c0nst4nt
Copy link

Still actual even in 2022 :P The dirty "hack" that I use, is just to create another transaction, every time, when you do commit. Like that:
StaticDriver::commit(); StaticDriver::beginTransaction();
In this way, everything will work smooth.

@Ctucker9233
Copy link

@c0nst4nt I'm in need of this. Where did you put that little snippet?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

7 participants