This really is my schema.yml.
Products:
columns:
title: { type:string(35) }
img_path: { type: string(100) }
is_activated: { type: boolean, notnull: true, default: 0 }
price: { type: integer, notnull: true }
Auctions:
columns:
pid: { type: bigint }
last_bider: { type: bigint }
starts_at: { type: timestamp, notnull: true }
ends_at: { type: timestamp, notnull: true }
relations:
Products:
local: pid
foreign: id
User:
local: last_bider
foreign: id
User:
columns:
username: { type: string(20) }
In fittings.yml
Products:
my_pendant:
title: 1 Gram Gold Rose Pendant
img_path: test/pendant.jpg
is_activated: 1
price: 25
User:
username1:
username: denis
Auctions:
pendant_auc:
pid: my_pendant
last_bider: username1
starts_at: 2011-26-06
ends_at: 2011-28-06
I keep getting constraint breach: Cannot add or update child row on 'pid' and 'id' - relation between Auctions and Items when attempting to place the fixture in to the database.
I am using doctrine... and that i can't understand why this really is happening.