Hello
I want to build a schema for a website and i have a problem with
insert the sql.
I have doctrine 1.0 and sfGuardUser 1.0 installed.
This is the schema that i wrote so far and have problems with :
Category:
tableName: category
columns:
id:
primary: true
autoincrement: true
type: integer
size: 10
name:
unique: true
type: string
size: 50
notnull: true
created_at:
type: timestamp
relations:
songs:
class: Song
foreignAlias: categorys
refClass: SongCategory
local: category_id
foreign: song_id
Song:
tableName: song
columns:
id:
notnull: true
primary: true
autoincrement: true
type: integer
size: 10
name: id
name:
name: name
type: string
size: 100
notnull: true
content:
name: content
type: string
size: 2000
created_at:
name: created_at
type: timestamp
user_id:
type: integer
size: 10
relations:
sfGuardUser:
foreignAlias: Songs
local: user_id
Comment:
tableName: comment
columns:
song_id:
type: integer
size: 10
content:
name: content
type: string
size: 2000
user_id:
type: integer
size: 10
created_at:
name: created_at
type: timestamp
relations:
sfGuardUser:
foreignAlias: comments
local: user_id
song:
class: Song
local: song_id
SongCategory:
columns:
song_id:
type: integer
size: 10
category_id:
type: integer
size: 10
relations:
song:
class: Song
local: song_id
category:
class: Category
local: category_id
The sfGuardUser is the default model class from sfGuardDoctrinePlugin.
The problem that i have comes from SONG and COMMENT tables, where i
use the reference to sfGuardUser.
Please tell me what i'm doing wrong, and also, if you have to share
some working examples of writing schema files for doctrine 1.0.
Thank you
Valentin Ceaprazaru
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
