Hi.
thanks for your responses.
I changed my Database... I modified the column names to xxxxx_ID
but still have the same Issue :
my new schema.yml is :
propel:
_attributes:
package: lib.model
defaultIdMethod: native
alternative:
_attributes: { phpName: Alternative }
ALTERNATIVE_ID: { type: DECIMAL, size: '8', scale: '0',
primaryKey: true, required: true }
DESCRIPTION: { type: VARCHAR, size: '1024', required: false }
MUSTBECHECKED: { type: DECIMAL, size: '8', scale: '0', required:
false }
conserne:
_attributes: { phpName: Conserne }
GROUP_ID: { type: DECIMAL, size: '8', scale: '0', primaryKey:
true, required: true }
QUIZZ_ID: { type: DECIMAL, size: '8', scale: '0', primaryKey:
true, required: true }
_indexes: { FK_CONSERNE2: [QUIZZ_ID] }
item:
_attributes: { phpName: Item }
ITEM_ID: { type: DECIMAL, size: '8', scale: '0', primaryKey: true,
required: true }
TYPEITEM_ID: { type: DECIMAL, size: '8', scale: '0', required:
true }
DESCRIPTION: { type: VARCHAR, size: '1024', required: false }
SCRORE: { type: DECIMAL, size: '8', scale: '0', required: false }
_indexes: { FK_BELONTI: [TYPEITEM_ID] }
itemtype:
_attributes: { phpName: Itemtype }
TYPEITEM_ID: { type: DECIMAL, size: '8', scale: '0', primaryKey:
true, required: true }
DESCRIPTION: { type: VARCHAR, size: '1024', required: false }
pass:
_attributes: { phpName: Pass }
USER_ID: { type: DECIMAL, size: '8', scale: '0', primaryKey: true,
required: true }
QUIZZ_ID: { type: DECIMAL, size: '8', scale: '0', primaryKey:
true, required: true }
TRIAL_ID: { type: DECIMAL, size: '8', scale: '0', primaryKey:
true, required: true }
EXAMDATE: { type: TIMESTAMP, required: false }
RESULT: { type: DECIMAL, size: '8', scale: '0', required: false }
SCORE: { type: DECIMAL, size: '8', scale: '0', required: false }
_indexes: { FK_PASS2: [QUIZZ_ID] }
quizz:
_attributes: { phpName: Quizz }
QUIZZ_ID: { type: DECIMAL, size: '8', scale: '0', primaryKey:
true, required: true }
USER_ID: { type: DECIMAL, size: '8', scale: '0', required: true }
TITLE: { type: VARCHAR, size: '1024', required: false }
CREATIONDATE: { type: TIMESTAMP, required: false }
STARTDATE: { type: TIMESTAMP, required: false }
ENABLED: { type: DECIMAL, size: '8', scale: '0', required: false }
NBQUESTION: { type: DECIMAL, size: '8', scale: '0', required:
false }
TOTALSCORE: { type: DECIMAL, size: '8', scale: '0', required:
false }
DURATION: { type: DECIMAL, size: '8', scale: '0', required:
false }
NBTRIAL: { type: DECIMAL, size: '8', scale: '0', required: false }
_indexes: { FK_PREPARE: [USER_ID] }
response:
_attributes: { phpName: Response }
USER_ID: { type: DECIMAL, size: '8', scale: '0', primaryKey: true,
required: true }
QUIZZ_ID: { type: DECIMAL, size: '8', scale: '0', primaryKey:
true, required: true }
ALTERNATIVE_ID: { type: DECIMAL, size: '8', scale: '0',
primaryKey: true, required: true }
ITEM_ID: { type: DECIMAL, size: '8', scale: '0', primaryKey: true,
required: true }
TRIAL_ID: { type: DECIMAL, size: '8', scale: '0', primaryKey:
true, required: true }
SELECTED: { type: DECIMAL, size: '8', scale: '0', required:
false }
RESULT: { type: DECIMAL, size: '8', scale: '0', required: false }
SCORE: { type: DECIMAL, size: '8', scale: '0', required: false }
_indexes: { FK_RESPONSE2: [QUIZZ_ID], FK_RESPONSE3:
[ALTERNATIVE_ID], FK_RESPONSE4: [ITEM_ID] }
team:
_attributes: { phpName: Team }
GROUP_ID: { type: DECIMAL, size: '8', scale: '0', primaryKey:
true, required: true }
DESCRIPTION: { type: VARCHAR, size: '1024', required: false }
useraccount:
_attributes: { phpName: Useraccount }
USER_ID: { type: DECIMAL, size: '8', scale: '0', primaryKey: true,
required: true }
GROUP_ID: { type: DECIMAL, size: '8', scale: '0', required: true }
NAME: { type: VARCHAR, size: '1024', required: false }
LASTNAME: { type: VARCHAR, size: '1024', required: false }
EMAIL: { type: VARCHAR, size: '1024', required: false }
PASSWORD: { type: VARCHAR, size: '1024', required: false }
LEVEL: { type: DECIMAL, size: '8', scale: '0', required: false }
_indexes: { FK_BELONGUG: [GROUP_ID] }
**********************************************************
Thanks for your help.
On 21 juil, 19:53, Farrukh Abbas <[email protected]> wrote:
> Hi
> I'm new with 1.2 myself ... and have not really made a new project in 1.2
> yet ... so far only been upgrading my existing projects from 1.0
>
> Never the less you could try and put the following parameters in the
> attribute definition
>
> { type: INTEGER, required: true, default: '', foreignTable: user,
> foreignReference: user_id, onDelete: RESTRICT, onUpdate: RESTRICT }
>
> or could simply specify the foreign keys as user_id: ~ (but i assume you
> have a good reason not going this way)
>
>
>
>
>
> On Tue, Jul 21, 2009 at 3:35 PM, leader <[email protected]> wrote:
>
> > Hi,
> > I'm a newhire in symfony,
> > I created an admin module for my Team Model (team : group)
> > and I created an admin module for Useraccount model.
>
> > when I clic on new in Useraccount admin module I have e form to enter
> > information, but for TeamID : i have a TextBox field... so i have to
> > enter manually the id ... normally it should print a comboBox field to
> > choose the TEam id ...
> > in the scheama I have This :
> > .
> > .
> > .
>
> > team:
> > _attributes: { phpName: Team }
> > IDGROUP: { type: DECIMAL, size: '8', scale: '0', primaryKey: true,
> > required: true }
> > DESCRIPTION: { type: VARCHAR, size: '1024', required: false }
>
> > useraccount:
> > _attributes: { phpName: Useraccount }
> > IDUSER: { type: DECIMAL, size: '8', scale: '0', primaryKey: true,
> > required: true }
> > IDGROUP: { type: DECIMAL, size: '8', scale: '0', required: true }
> > NAME: { type: VARCHAR, size: '1024', required: false }
> > LASTNAME: { type: VARCHAR, size: '1024', required: false }
> > EMAIL: { type: VARCHAR, size: '1024', required: false }
> > PASSWORD: { type: VARCHAR, size: '1024', required: false }
> > LEVEL: { type: DECIMAL, size: '8', scale: '0', required: false }
> > _indexes: { FK_BELONGUG: [IDGROUP] }
> > ..............
>
> --
> kind regards
> Farrukh K. Muhammad
> skype id - mobileweaver
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
