search

dmaicher / doctrine-test-bundle

Symfony bundle to isolate your app's doctrine database tests and improve the test performance
MIT License
1.08k stars 61 forks source link

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

Closed whyte624 closed 6 years ago

whyte624 commented 6 years ago

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 commented 6 years ago

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

soullivaneuh commented 6 years ago

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": "shelburt02@gmail.com"
                 },
                 {
-                    "name": "Théo FIDRY",
+                    "name": "Théo Fidry",
                     "email": "theo.fidry@gmail.com"
                 }
             ],
@@ -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": "theo.fidry@gmail.com",
+                    "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": "mtdowling@gmail.com",
-                    "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 commented 6 years ago

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

soullivaneuh commented 6 years ago

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 commented 6 years ago

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 commented 6 years ago

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 commented 6 years ago

@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 commented 6 years ago

I manage to get the executed queries until the crash:

180518 15:17:22     1 Connect   root@172.18.0.17 on site_test
            2 Connect   root@172.18.0.17 on site_test
180518 15:17:23     2 Quit  
            1 Quit  
180518 15:17:28     3 Connect   root@172.18.0.17 on site_test
            4 Connect   root@172.18.0.17 on site_test
            4 Query START TRANSACTION
            5 Connect   root@172.18.0.17 on site_pdns_test
            6 Connect   root@172.18.0.17 on site_pdns_test
            6 Query START TRANSACTION
            5 Quit  
            3 Quit  
            4 Query SET FOREIGN_KEY_CHECKS=0
            7 Connect   root@172.18.0.17 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 commented 6 years ago

@dmaicher Please see also: https://github.com/liip/LiipFunctionalTestBundle/issues/423

Jean85 commented 6 years ago

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 commented 6 years ago

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 :cry:

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 commented 6 years ago

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 commented 6 years ago

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. :+1:

theofidry commented 6 years ago

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

Jean85 commented 6 years ago

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

dmaicher commented 6 years ago

I added some info to the readme here https://github.com/dmaicher/doctrine-test-bundle/pull/59

Please have a look :wink:

c0nst4nt commented 2 years ago

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 commented 1 year ago

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