Skip to content

Error duplicate columns while Auto-generate migration Postgres #438

Closed
@whdigger

Description

@whdigger

Not right create columns in file scripts/Phalcon/Mvc/Model/Migration.php

Generating File:

            'references' => array(
                new Reference('fk_user_id', array(
                    'referencedSchema' => 'cbv',
                    'referencedTable' => 'user_user',
                    'columns' => array('user_id','user_id','user_id','user_id','user_id','user_id','user_id','user_id','user_id','user_id','user_id','user_id','user_id','user_id','user_id','user_id','user_id','user_id','user_id','user_id','user_id','user_id','user_id','user_id','user_id','user_id','user_id','user_id','user_id','user_id','user_id','user_id','user_id','user_id','user_id','user_id','user_id','user_id','user_id','user_id','user_id','user_id','user_id','user_id','user_id','user_id','user_id','user_id','user_id'),
                    'referencedColumns' => array('id','id','id','id','id','id','id','id','id','id','id','id','id','id','id','id','id','id','id','id','id','id','id','id','id','id','id','id','id','id','id','id','id','id','id','id','id','id','id','id','id','id','id','id','id','id','id','id','id')
                )),
                new Reference('fk_img_group_id', array(
                    'referencedSchema' => 'cbv',
                    'referencedTable' => 'img_group',
                    'columns' => array('img_group_id','img_group_id','img_group_id','img_group_id','img_group_id','img_group_id','img_group_id','img_group_id','img_group_id'),
                    'referencedColumns' => array('id','id','id','id','id','id','id','id','id')
                ))
            ),

Sql File

CREATE TABLE travel_report
(
  id           SERIAL                      NOT NULL PRIMARY KEY,
  travel_id    INTEGER,
  date_create  TIMESTAMP WITHOUT TIME ZONE NOT NULL DEFAULT now(),
  date_change  TIMESTAMP WITHOUT TIME ZONE NOT NULL,
  user_id      INTEGER,
  img_group_id INTEGER,
  CONSTRAINT fk_user_id FOREIGN KEY (user_id) REFERENCES "user_user" (id) ON UPDATE NO ACTION ON DELETE CASCADE,
  CONSTRAINT fk_img_group_id FOREIGN KEY (img_group_id) REFERENCES "img_group" (id) ON UPDATE NO ACTION ON DELETE CASCADE
);

Metadata

Metadata

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions