Mam w config/schema.yml taki fragment:
Kod
SfGuardUserProfile:
connection: doctrine
tableName: sf_guard_user_profile
columns:
user_id:
type: integer
fixed: false
unsigned: false
primary: false
notnull: true
autoincrement: false
email_new:
type: string(255)
fixed: false
unsigned: false
primary: false
notnull: false
autoincrement: false
firstname:
type: string(255)
fixed: false
unsigned: false
primary: false
notnull: false
autoincrement: false
lastname:
type: string(255)
fixed: false
unsigned: false
primary: false
notnull: false
autoincrement: false
validate_at:
type: timestamp(25)
fixed: false
unsigned: false
primary: false
notnull: false
autoincrement: false
validate:
type: string(33)
fixed: false
unsigned: false
primary: false
notnull: false
autoincrement: false
id:
type: integer(4)
fixed: false
unsigned: false
primary: true
autoincrement: true
fax:
type: string(255)
fixed: false
unsigned: false
primary: false
notnull: false
autoincrement: false
tel:
type: string(255)
fixed: false
unsigned: false
primary: false
notnull: false
autoincrement: false
mobile:
type: string(255)
fixed: false
unsigned: false
primary: false
notnull: false
autoincrement: false
country_id:
type: integer(4)
fixed: false
unsigned: false
primary: false
notnull: false
autoincrement: false
region_id:
type: integer(4)
fixed: false
unsigned: false
primary: false
notnull: false
autoincrement: false
status:
type: string(255)
fixed: false
unsigned: false
primary: false
notnull: false
autoincrement: false
city:
type: string(255)
fixed: false
unsigned: false
primary: false
notnull: false
autoincrement: false
ip_address:
type: integer(4)
fixed: false
unsigned: false
primary: false
notnull: false
autoincrement: false
created_at:
type: timestamp(25)
fixed: false
unsigned: false
primary: false
notnull: true
autoincrement: false
updated_at:
type: timestamp(25)
fixed: false
unsigned: false
primary: false
notnull: true
autoincrement: false
connection: doctrine
tableName: sf_guard_user_profile
columns:
user_id:
type: integer
fixed: false
unsigned: false
primary: false
notnull: true
autoincrement: false
email_new:
type: string(255)
fixed: false
unsigned: false
primary: false
notnull: false
autoincrement: false
firstname:
type: string(255)
fixed: false
unsigned: false
primary: false
notnull: false
autoincrement: false
lastname:
type: string(255)
fixed: false
unsigned: false
primary: false
notnull: false
autoincrement: false
validate_at:
type: timestamp(25)
fixed: false
unsigned: false
primary: false
notnull: false
autoincrement: false
validate:
type: string(33)
fixed: false
unsigned: false
primary: false
notnull: false
autoincrement: false
id:
type: integer(4)
fixed: false
unsigned: false
primary: true
autoincrement: true
fax:
type: string(255)
fixed: false
unsigned: false
primary: false
notnull: false
autoincrement: false
tel:
type: string(255)
fixed: false
unsigned: false
primary: false
notnull: false
autoincrement: false
mobile:
type: string(255)
fixed: false
unsigned: false
primary: false
notnull: false
autoincrement: false
country_id:
type: integer(4)
fixed: false
unsigned: false
primary: false
notnull: false
autoincrement: false
region_id:
type: integer(4)
fixed: false
unsigned: false
primary: false
notnull: false
autoincrement: false
status:
type: string(255)
fixed: false
unsigned: false
primary: false
notnull: false
autoincrement: false
city:
type: string(255)
fixed: false
unsigned: false
primary: false
notnull: false
autoincrement: false
ip_address:
type: integer(4)
fixed: false
unsigned: false
primary: false
notnull: false
autoincrement: false
created_at:
type: timestamp(25)
fixed: false
unsigned: false
primary: false
notnull: true
autoincrement: false
updated_at:
type: timestamp(25)
fixed: false
unsigned: false
primary: false
notnull: true
autoincrement: false
Relacje pomijam.
SfGuardUserProfile jest rozbudowany o kilka dodatkowych kolumn. Gdy buduję plik schema.sql, to jest on poprawny. Zawiera wszystkie te kolumny.
Kiedy jednak robię build --all, lub osobno build-model i insert-sql, to ani modele, ani baza danych nie zawiera dodatkowych kolumn typu region_id, fax, tel, mobile.
Czemu tak się dzieje?
W dokumentacji czytam, że build-model generuje modele na podstawie config/schema.yml. Kiedy w rzeczywistości SfGuardUserProfile jest zupełnie inne, nie wspominając już o tym, że w modelach mam klasę, której tabeli już dawno nie ma, ale jednak "skądś" się tworzy.
Przed niemalże każdą operacją robię "php symfony cc" żeby nie było, że o cache'u zapominam