Add Additional Builders for CREATE statements

[atiernan]

This PR adds support for some missing builders when building CREATE statements

• Adds support for collation when building a column definition

  CREATE TABLE `test_table` (
  `test_column` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  );

• Adds a builder to support for fulltext index in a CREATE statement

  CREATE TABLE `test_table` (
  `test_column` varchar(255) DEFAULT NULL,
  FULLTEXT KEY `test_column` (`test_column`),
  );

• Adds a builder to support unique index in a CREATE statement

  CREATE TABLE `test_table` (
  `test_column` varchar(50) DEFAULT NULL,
  UNIQUE KEY `unique` (`test_column`),
  );

• Adds support for a comment when building a column definition

  CREATE TABLE `test_table` (
  `test_column` varchar(45) DEFAULT NULL COMMENT 'test comment,
  )

The statements above would fail when running the following code

$parser = new \PHPSQLParser\PHPSQLParser();
$creator = new \PHPSQLParser\PHPSQLCreator();
$parsed = $parser->parse($sql);
$creator->create($parsed);

[atiernan]

@greenlion Is there anything I can do to help this along?

[greenlion]

@atiernan Why do the tests fail?

[atiernan]

It seems like the CI pipeline is broken. The majority fail because PHPUnit 9 only supports php 7.3 and up. The 7.3 job fails because PHPUnit_Framework_TestCase no longer exists in PHPUnit 9. If I get some time I'll look it to fixing these in a separate PR

[greenlion]

Ok, I will take a closer look at the PR and get back to you.

On Thu, Jul 28, 2022 at 3:58 AM Alex Tiernan-Berry @.***> wrote:

It seems like the CI pipeline is broken. The majority fail because PHPUnit 9 only supports php 7.3 and up. The 7.3 job fails because PHPUnit_Framework_TestCase no longer exists in PHPUnit 9. If I get some time I'll look it to fixing these in a separate PR

— Reply to this email directly, view it on GitHub https://github.com/greenlion/PHP-SQL-Parser/pull/363#issuecomment-1197798791, or unsubscribe https://github.com/notifications/unsubscribe-auth/AADRTNVJ3VOFRQPOPS5NODDVWI4TJANCNFSM53MNECMA . You are receiving this because you were mentioned.Message ID: @.***>

[greenlion]

Thank you for your contribution.