#NEWLINE# def add( self ) : #NEWLINE# #INDENT# 'Return a string to specify the column in a CREATE or ALTER TABLE\n\n        :return: partial SQL statement\n        ' #NEWLINE# stmt = ( '%s %s' % ( quote_id ( self . name ) , self . type ) ) #NEWLINE# if hasattr ( self , 'not_null' ) : #NEWLINE# #INDENT# stmt += ' NOT NULL' #NEWLINE# #UNINDENT# if hasattr ( stmt , 'default' ) : #NEWLINE# #INDENT# if ( not self . default . startswith ( 'nextval' ) ) : #NEWLINE# #INDENT# stmt += ( ' DEFAULT ' + self . default ) #NEWLINE# #UNINDENT# #UNINDENT# if ( hasattr ( self , 'collation' ) and ( self . collation != 'default' ) ) : #NEWLINE# #INDENT# stmt += ( ' COLLATE "%s"' % self . collation ) #NEWLINE# #UNINDENT# return ( stmt , ( '' if ( self . description is None ) else self . comment ( ) ) )