1 # SQLite doesn't actually support most of these types, but it "does the right

     2 # thing" given more verbose field definitions, so leave them as is so that

     3 # schema inspection is more useful.

     4 DATA_TYPES = {

     5     'AutoField':                    'integer',

     6     'BooleanField':                 'bool',

     7     'CharField':                    'varchar(%(max_length)s)',

     8     'CommaSeparatedIntegerField':   'varchar(%(max_length)s)',

     9     'DateField':                    'date',

    10     'DateTimeField':                'datetime',

    11     'DecimalField':                 'decimal',

    12     'FileField':                    'varchar(%(max_length)s)',

    13     'FilePathField':                'varchar(%(max_length)s)',

    14     'FloatField':                   'real',

    15     'ImageField':                   'varchar(%(max_length)s)',

    16     'IntegerField':                 'integer',

    17     'IPAddressField':               'char(15)',

    18     'NullBooleanField':             'bool',

    19     'OneToOneField':                'integer',

    20     'PhoneNumberField':             'varchar(20)',

    21     'PositiveIntegerField':         'integer unsigned',

    22     'PositiveSmallIntegerField':    'smallint unsigned',

    23     'SlugField':                    'varchar(%(max_length)s)',

    24     'SmallIntegerField':            'smallint',

    25     'TextField':                    'text',

    26     'TimeField':                    'time',

    27     'USStateField':                 'varchar(2)',

    28 }