protected function getCreateTable()
{
return ['example1' => [null, ['columns' => [new Column('column1', ['type' => Column::TYPE_VARCHAR, 'size' => 10]), new Column('column2', ['type' => Column::TYPE_INTEGER, 'size' => 18, 'unsigned' => true, 'notNull' => false])]], file_get_contents(PATH_FIXTURES . 'postgresql/example1.sql')], 'example2' => [null, ['columns' => [new Column('column2', ['type' => Column::TYPE_INTEGER, 'size' => 18, 'unsigned' => true, 'notNull' => false]), new Column('column3', ['type' => Column::TYPE_DECIMAL, 'size' => 10, 'scale' => 2, 'unsigned' => false, 'notNull' => true]), new Column('column1', ['type' => Column::TYPE_VARCHAR, 'size' => 10])], 'indexes' => [new Index('PRIMARY', ['column3'])]], file_get_contents(PATH_FIXTURES . 'postgresql/example2.sql')], 'example3' => [null, ['columns' => [new Column('column2', ['type' => Column::TYPE_INTEGER, 'size' => 18, 'unsigned' => true, 'notNull' => false]), new Column('column3', ['type' => Column::TYPE_DECIMAL, 'size' => 10, 'scale' => 2, 'unsigned' => false, 'notNull' => true]), new Column('column1', ['type' => Column::TYPE_VARCHAR, 'size' => 10])], 'indexes' => [new Index('PRIMARY', ['column3'])], 'references' => [new Reference('fk3', ['referencedTable' => 'ref_table', 'columns' => ['column1'], 'referencedColumns' => ['column2'], 'onDelete' => 'CASCADE'])]], file_get_contents(PATH_FIXTURES . 'postgresql/example3.sql')], 'example4' => [null, ['columns' => [new Column('column9', ['type' => Column::TYPE_VARCHAR, 'size' => 10, 'default' => 'column9']), new Column('column10', ['type' => Column::TYPE_INTEGER, 'size' => 18, 'unsigned' => true, 'notNull' => false, 'default' => 10])]], file_get_contents(PATH_FIXTURES . 'postgresql/example4.sql')], 'example5' => [null, ['columns' => [new Column('column11', ['type' => 'BIGINT', 'typeReference' => Column::TYPE_INTEGER, 'size' => 20, 'unsigned' => true, 'notNull' => false]), new Column('column12', ['type' => 'ENUM', 'typeValues' => ['A', 'B', 'C'], 'notNull' => true, 'default' => 'A', 'after' => 'column11']), new Column('column13', ['type' => Column::TYPE_TIMESTAMP, 'notNull' => true, 'default' => 'CURRENT_TIMESTAMP'])]], file_get_contents(PATH_FIXTURES . 'postgresql/example5.sql')]];
}