Hi Ken. Nice to hear from you. We seem to be on similar lists.
I am able to generate the create indexes statements for regular indexes
(django-admin.py sqlindexes myapp). They just don't appear in the
install (django-admin.py install myapp). Get everything but the
indexes. I am using sqlite3 with this.
An example model:
class Triple(meta.Model):
"""
"""
subject = meta.IntegerField(db_index=True)
predicate = meta.IntegerField(db_index=True)
object = meta.IntegerField()
objtype = meta.IntegerField()
class META:
db_table = "triples"
unique_together = (('subject',
'predicate'),('object','objtype'),
('subject', 'object', 'objtype'),('predicate', 'object',
'objtype'),)
I dont get index create statements on install for any tables. Unique
together gives me this:
CREATE TABLE triples (
id integer NOT NULL PRIMARY KEY,
subject integer NOT NULL,
predicate integer NOT NULL,
object integer NOT NULL,
objtype integer NOT NULL,
UNIQUE (subject, predicate),
UNIQUE (object, objtype),
UNIQUE (subject, object, objtype),
UNIQUE (predicate, object, objtype)
This is not indexes - but this is putting constraint on the data
instead.
Maybe I should file a bug report and I should do this after in a
regular statements after install :(
