# $Id$

# Not quite sure about the Boolean and Float fields.
# Not sure what to use for Boolean, since there seems to be a 'BOOLEAN' type, 
# but it isn't 'documented' anywhere. For Float, we have DOUBLE, DECIMAL and NUMERIC
# to choose from :+/, too many.
DATA_TYPES = {
	'AutoField':                    'integer GENERATED ALWAYS AS IDENTITY',
	'BooleanField':                 'smallint',
	'CharField':                    'varchar(%(maxlength)s)',
	'CommaSeparatedIntegerField':   'varchar(%(maxlength)s)',
	'DateField':                    'date',
	'DateTimeField':                'timestamp',
	'FileField':                    'varchar(100)',
	'FilePathField':                'varchar(100)',
	'FloatField':                   'decimal(%(max_digits)s, %(decimal_places)s)',
	'ImageField':                   'varchar(100)',
	'IntegerField':                 'integer',
	'IPAddressField':               'char(15)',
	'ManyToManyField':              None,
	'NullBooleanField':             'smallint',
	'OneToOneField':                'integer',
	'PhoneNumberField':             'varchar(20)',
	'PositiveIntegerField':         'integer',
	'PositiveSmallIntegerField':    'smallint',
	'SlugField':                    'varchar(%(maxlength)s)',
	'SmallIntegerField':            'int',
	'TextField':                    'long varchar',
	'TimeField':                    'time',
	'USStateField':                 'varchar(2)',
}