limoncello-php-dist / passport

     *

     * @throws DBALException

     */

    protected function createClientsScopesTable(Connection $connection, DatabaseSchemaInterface $schema): void

    {

        $manager = $connection->getSchemaManager();

        $table = new Table($schema->getClientsScopesTable());

        $table->addColumn($schema->getClientsScopesIdentityColumn(), Type::INTEGER)

            ->setNotnull(true)->setAutoincrement(true)->setUnsigned(true);

        $table->addColumn($schema->getClientsScopesClientIdentityColumn(), Type::STRING)->setNotnull(true);

        $table->addColumn($schema->getClientsScopesScopeIdentityColumn(), Type::STRING)->setNotnull(true);

        $table->setPrimaryKey([$schema->getClientsScopesIdentityColumn()]);

        $table->addUniqueIndex([

            $schema->getClientsScopesClientIdentityColumn(),

            $schema->getClientsScopesScopeIdentityColumn()

        ]);

        $table->addForeignKeyConstraint(

            $schema->getClientsTable(),

            [$schema->getClientsScopesClientIdentityColumn()],

            [$schema->getClientsIdentityColumn()],

            $this->getOnDeleteCascadeConstraint()

        );

        $table->addForeignKeyConstraint(

            $schema->getScopesTable(),

            [$schema->getClientsScopesScopeIdentityColumn()],

            [$schema->getScopesIdentityColumn()],

            $this->getOnDeleteCascadeConstraint()

        );

        $manager->dropAndCreateTable($table);

    }

    /**

     * @param Connection              $connection

     *

     * @throws DBALException

     */

    protected function createTokensScopesTable(Connection $connection, DatabaseSchemaInterface $schema): void

    {

        $manager = $connection->getSchemaManager();

        $table = new Table($schema->getTokensScopesTable());

        $table->addColumn($schema->getTokensScopesIdentityColumn(), Type::INTEGER)

            ->setNotnull(true)->setAutoincrement(true)->setUnsigned(true);

        $table->addColumn($schema->getTokensScopesTokenIdentityColumn(), Type::INTEGER)->setNotnull(true)

            ->setUnsigned(true);

        $table->addColumn($schema->getTokensScopesScopeIdentityColumn(), Type::STRING)->setNotnull(true);

        $table->setPrimaryKey([$schema->getTokensScopesIdentityColumn()]);

        $table->addUniqueIndex([

            $schema->getTokensScopesTokenIdentityColumn(),

            $schema->getTokensScopesScopeIdentityColumn()

        ]);

        $table->addForeignKeyConstraint(

            $schema->getTokensTable(),

            [$schema->getTokensScopesTokenIdentityColumn()],

            [$schema->getTokensIdentityColumn()],

            $this->getOnDeleteCascadeConstraint()

        );

        $table->addForeignKeyConstraint(

            $schema->getScopesTable(),

            [$schema->getTokensScopesScopeIdentityColumn()],

            [$schema->getScopesIdentityColumn()],

            $this->getOnDeleteCascadeConstraint()

        );

        $manager->dropAndCreateTable($table);

    }

    /**

     * @return array