1
# This dictionary maps Field objects to their associated MySQL 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.
6
'AutoField': 'integer AUTO_INCREMENT',
7
'BooleanField': 'bool',
8
'CharField': 'varchar(%(maxlength)s)',
9
'CommaSeparatedIntegerField': 'varchar(%(maxlength)s)',
11
'DateTimeField': 'datetime',
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': 'char(15)',
18
'ManyToManyField': None,
19
'NullBooleanField': 'bool',
20
'OneToOneField': 'integer',
21
'PhoneNumberField': 'varchar(20)',
22
'PositiveIntegerField': 'integer UNSIGNED',
23
'PositiveSmallIntegerField': 'smallint UNSIGNED',
24
'SlugField': 'varchar(%(maxlength)s)',
25
'SmallIntegerField': 'smallint',
26
'TextField': 'longtext',
28
'USStateField': 'varchar(2)',