Hi,
I'm having the same problem with r6980. As an example I used the same
model as richbodo:
models.py:
class Account(models.Model):
name = models.CharField(max_length=200)
class Box(models.Model):
account = models.ForeignKey(Account)
mac = models.CharField(max_length=50)
choice = models.CharField(max_length=200)
class Domain(models.Model):
box = models.ForeignKey(Box)
name = models.CharField(max_length=255)
settings.py:
DATABASE_ENGINE = 'mysql' # 'postgresql_psycopg2',
'postgresql', 'mysql', 'sqlite3' or 'oracle'.
Here is the sql output:
[EMAIL PROTECTED] ~/testj $ python manage.py sqlall ok
BEGIN;
CREATE TABLE `ok_box` (
`id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
`account_id` integer NOT NULL,
`mac` varchar(50) NOT NULL,
`choice` varchar(200) NOT NULL
)
;
CREATE TABLE `ok_account` (
`id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
`name` varchar(200) NOT NULL
)
;
ALTER TABLE `ok_box` ADD CONSTRAINT account_id_refs_id_1d01b08f
FOREIGN KEY (`account_id`) REFERENCES `ok_account` (`id`);
CREATE TABLE `ok_domain` (
`id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
`box_id` integer NOT NULL,
`name` varchar(255) NOT NULL
)
;
-- The following references should be added but depend on non-existent
tables:
-- ALTER TABLE `ok_domain` ADD CONSTRAINT box_id_refs_id_292b9829
FOREIGN KEY (`box_id`) REFERENCES `ok_box` (`id`);
CREATE INDEX `ok_box_account_id` ON `ok_box` (`account_id`);
CREATE INDEX `ok_domain_box_id` ON `ok_domain` (`box_id`);
COMMIT;
Is this the correct behavior?
Thanks for now!
-nick
On 2 dec 2007, 15:56, Malcolm Tredinnick <[EMAIL PROTECTED]>
wrote:
> On Fri, 2007-11-30 at 17:42 -0800, Matt wrote:
> > Was this ever fixed? I'm still experiencing similar behavior in r6783.
> > Thanks!
>
> What are you doing to repeat the problem? Please provide a very short
> example that demonstrates the issue (and see r6650).
>
> Malcolm
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Django 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/django-users?hl=en
-~----------~----~----~----~------~----~------~--~---
