I've got an app called page I've been working on. Pages can contain
text, graphics, or media and each have their own table which refer back
to page (ForeignKey). When I set up this model, only page_media has
the inlined SQL for the foreign key ("REFERENCES"), where as the others
do it with an ALTER TABLE syntax. This seems odd to me that almost the
identicle table definition is output differently. Should I be
concerned? Should each table have similar SQL?
Thanks,
Rob
My models.py:
from django.db import models
class Template(models.Model):
name = models.CharField(maxlength=64, db_index=True,
unique=True)
def __str__(self):
return self.name
class Admin:
list_display = ('name')
class Page(models.Model):
name = models.CharField(maxlength=64, db_index=True,
unique=True)
template = models.ForeignKey(Template)
def __str__(self):
return self.name
class Admin:
list_display = ('name', 'template')
class Text(models.Model):
page = models.ForeignKey(Page, db_index=True,
edit_inline=models.STACKED)
position = models.CharField(maxlength=16, core=True)
content = models.TextField(core=True)
class Meta:
ordering = ['position']
class Graphic(models.Model):
page = models.ForeignKey(Page, db_index=True,
edit_inline=models.STACKED)
position = models.CharField(maxlength=16, core=True)
filename = models.CharField(maxlength=128, core=True)
class Meta:
ordering = ['position']
class Media(models.Model):
page = models.ForeignKey(Page, db_index=True,
edit_inline=models.STACKED)
position = models.CharField(maxlength=16, core=True)
filename = models.CharField(maxlength=128, core=True)
class Meta:
ordering = ['position']
The output of "./manage.py sql page":
BEGIN;
CREATE TABLE `page_text` (
`id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
`page_id` integer NOT NULL,
`position` varchar(16) NOT NULL,
`content` longtext NOT NULL
);
CREATE TABLE `page_graphic` (
`id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
`page_id` integer NOT NULL,
`position` varchar(16) NOT NULL,
`filename` varchar(128) NOT NULL
);
CREATE TABLE `page_page` (
`id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
`name` varchar(64) NOT NULL UNIQUE,
`template_id` integer NOT NULL
);
ALTER TABLE `page_text` ADD CONSTRAINT page_id_refs_id_7038ecc2 FOREIGN
KEY (`page_id`) REFERENCES `page_page` (`id`);
ALTER TABLE `page_graphic` ADD CONSTRAINT page_id_refs_id_5fad2eb2
FOREIGN KEY (`page_id`) REFERENCES `page_page` (`id`);
CREATE TABLE `page_template` (
`id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
`name` varchar(64) NOT NULL UNIQUE
);
ALTER TABLE `page_page` ADD CONSTRAINT template_id_refs_id_768003f7
FOREIGN KEY (`template_id`) REFERENCES `page_template` (`id`);
CREATE TABLE `page_media` (
`id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
`page_id` integer NOT NULL REFERENCES `page_page` (`id`),
`position` varchar(16) NOT NULL,
`filename` varchar(128) NOT NULL
);
COMMIT;
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to django-users@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/django-users
-~--~~~~--~~--~--~---
