hi everyone,
short summary says all about my problems, here is the case;
--
DROP TABLE IF EXISTS LANGUAGE;
CREATE TABLE LANGUAGE (
LANGUAGE_ID INT NOT NULL PRIMARY
KEY AUTO_INCREMENT
, LANGUAGE_TITLE CHAR(100) NOT NULL
) TYPE = INNODB;
DROP TABLE IF EXISTS QUESTION_ACTION;
CREATE TABLE QUESTION_ACTION (
QUESTION_ID INT NOT NULL PRIMARY
KEY AUTO_INCREMENT
, LANGUAGE_ID INT NOT NULL
, ACTION_ID INT NOT NULL
, MULTI_CHOICE CHAR(1) NOT NULL
, SORTNR SMALLINT NOT NULL
, SHOW_TYPE CHAR(10) NOT NULL
, QUESTION TEXT NOT NULL
, FOREIGN KEY (LANGUAGE_ID) REFERENCES
LANGUAGE(LANGUAGE_ID)
, FOREIGN KEY (ACTION_ID) REFERENCES
ACTION(ACTION_ID)
) TYPE = INNODB;
Ok this is not the whole sql there are many more tables, but the
principle is the same everywhere.
So when i put python manage.py inspectdb > models.py, it successfully
finish it but the result is
# This is an auto-generated Django model module.
# You'll have to do the following manually to clean this up:
# * Rearrange models' order
# * Make sure each model has one field with primary_key=True
# Feel free to rename the models, but don't rename db_table values or
field names.
#
# Also note: You'll have to insert the output of 'django-admin.py
sqlcustom [appname]'
# into your database.
from django.db import models
---
did i do something wrong or it's the Django thing?
oh, and yeah all tables are in the same schema...
Thanks in advance,
Alen
--~--~---------~--~----~------------~-------~--~----~
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?hl=en
-~----------~----~----~----~------~----~------~--~---
