Ticket #1011 (closed defect: fixed)
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
Note: See
TracTickets for help on using
tickets.