You are browsing a version that is no longer maintained.

Doctrine SQL comments

In some occasions DBAL generates DC2Type SQL comments in columns of the databases schemas that is maintained by Doctrine. These comments have a functional purpose in DBAL.

DC2 is a shorthand for Doctrine 2, as opposed to Doctrine 1, an ancestor that relied on the active record pattern.

These comments are here to help with reverse engineering. Inside the DBAL, the schema manager can leverage them to resolve ambiguities when it comes to determining the correct DBAL type for a given column.

For instance: You are following a Database First approach, and want to use GUIDs in your application while using a platform that does not have a native type for this mapping. By commenting columns that hold GUIDs with (DC2Type:guid), you can let the DBAL know it is supposed to use Doctrine\DBAL\Types\GuidType when dealing with that column. When using reverse engineering tools, this can be used to generate accurate information. For instance, if you use Doctrine ORM, there is a reverse engineering example to show how to generate a proper mapping.

A table with such a column may have a declaration that looks as follows:

1 CREATE TABLE "movies" (
     uuid CHAR(36) NOT NULL, --(DC2Type:guid)
     title varchar(255) NOT NULL
     …,
     PRIMARY KEY(uuid)
)
2
3
4
5
6

1	CREATE TABLE "movies" ( uuid CHAR(36) NOT NULL, --(DC2Type:guid) title varchar(255) NOT NULL …, PRIMARY KEY(uuid) )
2
3
4
5
6

Maintained

Unmaintained

Doctrine SQL comments