public static void createPropertiesTable ( ASpatialDb database ) throws Exception { StringBuilder sb = new StringBuilder ( ) ; sb . append ( "CREATE TABLE " ) ; sb . append ( PROPERTIESTABLE ) ; sb . append ( " (" ) ; sb . append ( ID ) ; sb . append ( " INTEGER PRIMARY KEY AUTOINCREMENT, " ) ; sb . append ( NAME ) . append ( " TEXT, " ) ; sb . append ( SIZE ) . append ( " REAL, " ) ; sb . append ( FILLCOLOR ) . append ( " TEXT, " ) ; sb . append ( STROKECOLOR ) . append ( " TEXT, " ) ; sb . append ( FILLALPHA ) . append ( " REAL, " ) ; sb . append ( STROKEALPHA ) . append ( " REAL, " ) ; sb . append ( SHAPE ) . append ( " TEXT, " ) ; sb . append ( WIDTH ) . append ( " REAL, " ) ; sb . append ( LABELSIZE ) . append ( " REAL, " ) ; sb . append ( LABELFIELD ) . append ( " TEXT, " ) ; sb . append ( LABELVISIBLE ) . append ( " INTEGER, " ) ; sb . append ( ENABLED ) . append ( " INTEGER, " ) ; sb . append ( ORDER ) . append ( " INTEGER," ) ; sb . append ( DASH ) . append ( " TEXT," ) ; sb . append ( MINZOOM ) . append ( " INTEGER," ) ; sb . append ( MAXZOOM ) . append ( " INTEGER," ) ; sb . append ( DECIMATION ) . append ( " REAL," ) ; sb . append ( THEME ) . append ( " TEXT" ) ; sb . append ( " );" ) ; String query = sb . toString ( ) ; database . executeInsertUpdateDeleteSql ( query ) ; }
Create the properties table .