This is my first attempt:
config/doctrine/schema.yml:
---------------------------
User:
actAs:
Sluggable:
unique: true
fields: [first_name, last_name]
columns:
first_name: string(25)
last_name: string(25)
UserNewsWidget:
columns:
user_id: integer(4)
type: integer(4)
relations:
Member:
class: User
local: user_id
foreign: id
type: many
foreignType: one
UserNewsWidgetRss:
inheritance:
extends: UserNewsWidget
type: column_aggregation
keyField: type
keyValue: 2
columns:
url: varchar(255)
UserNewsWidgetLocal:
inheritance:
extends: UserNewsWidget
type: column_aggregation
keyField: type
keyValue: 3
relations:
Articles:
class: UserNewsWidgetArticle
local: id
foreign: widget_id
type: many
foreignType: one
onDelete: CASCADE
UserNewsWidgetArticle:
columns:
widget_id: integer(4)
title: string(255)
date: date
venue: string(255)
address: string(255)
content: clob
relations:
Widget:
class: UserNewsWidgetLocal
local: widget_id
foreign: id
onDelete: CASCADE
onUpdate: CASCADE
$ ./symfony doctrine:build --all
--------------------------------
SQLSTATE[HY000]: General error: 1005 Can't create table './sf_test/
#sql-28f3_1a.frm' (errno: 150).
Failing Query: "ALTER TABLE user_news_widget_article ADD CONSTRAINT
user_news_widget_article_widget_id_user_news_widget_id FOREIGN KEY
(widget_id) REFERENCES user_news_widget(id) ON UPDATE CASCADE ON
DELETE CASCADE".
Failing Query: ALTER TABLE user_news_widget_article ADD CONSTRAINT
user_news_widget_article_widget_id_user_news_widget_id FOREIGN KEY
(widget_id) REFERENCES user_news_widget(id) ON UPDATE CASCADE ON
DELETE CASCADE
Doh ! >_<'
--
You received this message because you are subscribed to the Google Groups
"symfony users" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/symfony-users?hl=en.
