diff options
| author | Jacob Kaplan-Moss <jacob@jacobian.org> | 2006-11-04 20:39:19 +0000 |
|---|---|---|
| committer | Jacob Kaplan-Moss <jacob@jacobian.org> | 2006-11-04 20:39:19 +0000 |
| commit | 5da24765c99b5492c2d8709ae817c64947b28444 (patch) | |
| tree | 331fb9dce148e2d8bf66e1081a67f1639eb1776c | |
| parent | c7b4311864dfa91e03306afb7d8c2f31536b161e (diff) | |
[boulder-oracle-sprint] fixed oracle creation types to be more sane (thanks, Mitch Smith)
git-svn-id: http://code.djangoproject.com/svn/django/branches/boulder-oracle-sprint@3974 bcc190cf-cafb-0310-a4f2-bffc1f526a37
| -rw-r--r-- | django/db/backends/oracle/creation.py | 26 |
1 files changed, 13 insertions, 13 deletions
diff --git a/django/db/backends/oracle/creation.py b/django/db/backends/oracle/creation.py index 0b0c1702ec..75cc6852d9 100644 --- a/django/db/backends/oracle/creation.py +++ b/django/db/backends/oracle/creation.py @@ -1,26 +1,26 @@ DATA_TYPES = { - 'AutoField': 'number(38)', - 'BooleanField': 'number(1)', + 'AutoField': 'number(11)', + 'BooleanField': 'number(1) CHECK (%(column)s IN (0,1))', 'CharField': 'varchar2(%(maxlength)s)', 'CommaSeparatedIntegerField': 'varchar2(%(maxlength)s)', 'DateField': 'date', - 'DateTimeField': 'date', + 'DateTimeField': 'timestamp with time zone', 'FileField': 'varchar2(100)', 'FilePathField': 'varchar2(100)', 'FloatField': 'number(%(max_digits)s, %(decimal_places)s)', 'ImageField': 'varchar2(100)', - 'IntegerField': 'integer', + 'IntegerField': 'number(11)', 'IPAddressField': 'char(15)', 'ManyToManyField': None, - 'NullBooleanField': 'integer', - 'OneToOneField': 'integer', - 'PhoneNumberField': 'varchar(20)', - 'PositiveIntegerField': 'integer', - 'PositiveSmallIntegerField': 'smallint', - 'SlugField': 'varchar(50)', - 'SmallIntegerField': 'smallint', + 'NullBooleanField': 'number(1) CHECK ((%(column)s IN (0,1)) OR (%(column)s IS NULL))', + 'OneToOneField': 'number(11)', + 'PhoneNumberField': 'varchar2(20)', + 'PositiveIntegerField': 'number(11) CHECK (%(column)s >= 0)', + 'PositiveSmallIntegerField': 'number(11) CHECK (%(column)s >= 0)', + 'SlugField': 'varchar2(50)', + 'SmallIntegerField': 'number(11)', 'TextField': 'clob', 'TimeField': 'timestamp', - 'URLField': 'varchar(200)', - 'USStateField': 'varchar(2)', + 'URLField': 'varchar2(200)', + 'USStateField': 'char(2)', } |