#NEWLINE# def sql_indexes_for_field( self , model , f , style ) : #NEWLINE# #INDENT# 'Return any spatial index creation SQL for the field.' #NEWLINE# from django.contrib.gis.db.models.fields import GeometryField #NEWLINE# output = super ( PostGISCreation , self ) . sql_indexes_for_field ( model , f , style ) #NEWLINE# if isinstance ( f , GeometryField ) : #NEWLINE# #INDENT# gqn = self . connection . ops . geo_quote_name #NEWLINE# qn = self . connection . ops . quote_name #NEWLINE# db_table = model . _meta . db_table #NEWLINE# if f . geography : #NEWLINE# #INDENT# pass #NEWLINE# #UNINDENT# else : #NEWLINE# #INDENT# output . append ( ( ( ( ( ( ( ( ( ( ( ( ( style . SQL_KEYWORD ( 'SELECT ' ) + style . SQL_TABLE ( 'AddGeometryColumn' ) ) + '(' ) + style . SQL_TABLE ( gqn ( db_table ) ) ) + ', ' ) + style . SQL_FIELD ( gqn ( f . column ) ) ) + ', ' ) + style . SQL_FIELD ( str ( f . srid ) ) ) + ', ' ) + style . SQL_COLTYPE ( gqn ( f . geom_type ) ) ) + ', ' ) + style . SQL_KEYWORD ( str ( f . dim ) ) ) + ');' ) ) #NEWLINE# if ( not f . null ) : #NEWLINE# #INDENT# output . append ( ( ( ( ( ( style . SQL_KEYWORD ( 'ALTER TABLE ' ) + style . SQL_TABLE ( qn ( db_table ) ) ) + style . SQL_KEYWORD ( ' ALTER ' ) ) + style . SQL_FIELD ( qn ( f . column ) ) ) + style . SQL_KEYWORD ( ' SET NOT NULL' ) ) + ';' ) ) #NEWLINE# #UNINDENT# #UNINDENT# if f . spatial_index : #NEWLINE# #INDENT# if f . geography : #NEWLINE# #INDENT# index_opts = '' #NEWLINE# #UNINDENT# else : #NEWLINE# #INDENT# index_opts = ( ' ' + style . SQL_KEYWORD ( self . geom_index_opts ) ) #NEWLINE# #UNINDENT# output . append ( ( ( ( ( ( ( ( ( ( style . SQL_KEYWORD ( 'CREATE INDEX ' ) + style . SQL_TABLE ( qn ( ( '%s_%s_id' % ( db_table , f . column ) ) ) ) ) + style . SQL_KEYWORD ( ' ON ' ) ) + style . SQL_TABLE ( qn ( db_table ) ) ) + style . SQL_KEYWORD ( ' USING ' ) ) + style . SQL_COLTYPE ( self . geom_index_type ) ) + ' ( ' ) + style . SQL_FIELD ( qn ( f . column ) ) ) + index_opts ) + ' );' ) ) #NEWLINE# #UNINDENT# #UNINDENT# return output