|
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 } |