Ticket #1011 (closed defect: fixed)

Opened 8 months ago

Last modified 8 months ago

Exporting SQL creates indexes first as tables

Reported by: adrive Owned by: jwage
Priority: minor Milestone: 0.11.0
Component: Import/Export Version: 0.11.0
Keywords: Cc:
Has Test: Status:
Has Patch:

Description

I am using latest sfDoctrine (1.0-sf1.1) and pgsql as doctrine driver (Maybe this issue is also with another drivers).

When I run symfony doctrine:build-sql it created the sql file with indexes DDL before DDL of tables.

example schema.yml

stNode:
  columns:
    type: string(10)
    slug: string(70)
    title: string(100)
  indexes:
    type_slug_idx:
      fields:
        - slug
        - type
      type: unique

And created data/sql/schema.sql after invoking doctrine:build-sql task:

CREATE UNIQUE INDEX type_slug_idx ON st_node (slug, type);
CREATE TABLE st_node (id BIGSERIAL, type VARCHAR(10), slug VARCHAR(70), title VARCHAR(100), PRIMARY KEY(id));

Change History

Changed 8 months ago by jwage

  • milestone changed from 0.11.2 to 0.11.0

Changed 8 months ago by jwage

  • status changed from new to closed
  • resolution set to fixed

(In [4352]) fixes #1011

Note: See TracTickets for help on using tickets.