python/lib/django-0.96/django/db/backends/postgresql/creation.py

   1 # This dictionary maps Field objects to their associated PostgreSQL column
   2 # types, as strings. Column-type strings can contain format strings; they'll
   3 # be interpolated against the values of Field.__dict__ before being output.
   4 # If a column type is set to None, it won't be included in the output.
   5 DATA_TYPES = {
   6     'AutoField':         'serial',
   7     'BooleanField':      'boolean',
   8     'CharField':         'varchar(%(maxlength)s)',
   9     'CommaSeparatedIntegerField': 'varchar(%(maxlength)s)',
  10     'DateField':         'date',
  11     'DateTimeField':     'timestamp with time zone',
  12     'FileField':         'varchar(100)',
  13     'FilePathField':     'varchar(100)',
  14     'FloatField':        'numeric(%(max_digits)s, %(decimal_places)s)',
  15     'ImageField':        'varchar(100)',
  16     'IntegerField':      'integer',
  17     'IPAddressField':    'inet',
  18     'ManyToManyField':   None,
  19     'NullBooleanField':  'boolean',
  20     'OneToOneField':     'integer',
  21     'PhoneNumberField':  'varchar(20)',
  22     'PositiveIntegerField': 'integer CHECK ("%(column)s" >= 0)',
  23     'PositiveSmallIntegerField': 'smallint CHECK ("%(column)s" >= 0)',
  24     'SlugField':         'varchar(%(maxlength)s)',
  25     'SmallIntegerField': 'smallint',
  26     'TextField':         'text',
  27     'TimeField':         'time',
  28     'USStateField':      'varchar(2)',
  29 }