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);
    }
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.

@param database the db to use.
@throws Exception