# ./symfony doctrine:build --all --no-confirmation

SQLSTATE[HY000]: General error: 1005 Can't create table 'notetolife.#sql-2ba_a0' (errno: 150). Failing Query: "ALTER TABLE sf_guard_forgot_password ADD CONSTRAINT sf_guard_forgot_password_user_id_sf_guard_user_id FOREIGN KEY (user_id) REFERENCES sf_guard_user(id) ON DELETE CASCADE". Failing Query: ALTER TABLE sf_guard_forgot_password ADD CONSTRAINT sf_guard_forgot_password_user_id_sf_guard_user_id FOREIGN KEY (user_id) REFERENCES sf_guard_user(id) ON DELETE CASCADE


#./config/doctrine/schema.yml
NoteCategory:
  columns:
    name: { type: string(100), notnull: true, unique: true }
    slug: { type: string(100), notnull: true, unique: true }

sfGuardUserProfile:
  columns:
    user_id:     { type: integer(4), notnull: true }
    email:       { type: string(255), email: true }
    karma:       { type: integer, notnull: true, default: 1 }
  relations:
    sfGuardUser:
      local: user_id
      foreign: id
      type: one
      foreignType: one
      onDelete: cascade
      foreignAlias: Profile

Vote:
  columns:
    name: { type: string(255), notnull: true }
    note_id: { type: integer, notnull: true }
  relations:
    Note: { local: note_id, foreign: id, foreignAlias: Votes }

Note:
  actAs: { Timestampable: ~ }
  columns:
    category_id:  { type: integer, notnull: true }
    user_id:      { type: integer(4), notnull: true }
    note:         { type: string(<?php echo sfConfig::get('length_of_note') ?>), notnull: true }
    slug:         { type: string(<?php echo sfConfig::get('length_of_note') ?>), notnull: true }
    score:        { type: integer, notnull: true, default: 1 }
    created_at:   ~
  relations:
    NoteCategory: { onDelete: CASCADE, local: category_id, foreign: id, foreignAlias: Notes }
    sfGuardUser: { onDelete: CASCADE, local: user_id, foreign: id, foreignAlias: UsersNotes }