I ran tg-admin sql sql and here is what I get:

Using database URI postgres://postgres:[EMAIL PROTECTED]/fooball
CREATE TABLE player (
    id SERIAL PRIMARY KEY,
    name VARCHAR(40) NOT NULL UNIQUE,
    birthdate DATE NOT NULL,
    team_id INT, CONSTRAINT team_id_exists FOREIGN KEY (team_id)
REFERENCES team
 (id) ,
    points INT
);
;;

CREATE TABLE team (
    id SERIAL PRIMARY KEY,
    city VARCHAR(20) NOT NULL,
    nickname VARCHAR(20) NOT NULL UNIQUE
);
;;

I have tried the soClasses and I still had no success. Thanks for ideas.


--~--~---------~--~----~------------~-------~--~----~
 You received this message because you are subscribed to the Google Groups 
"TurboGears" 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/turbogears?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to