//add submaterial table
            db.execSQL("create table " + (jobName + JobMetaData.SubmaterialTableMetaData.TABLE_NAME_SUFFIX)
                       + " (_id integer primary key autoincrement,"
                       + JobMetaData.SubmaterialTableMetaData.GUID + " text not null,"
                       + JobMetaData.SubmaterialTableMetaData.SECTION + " text not null,"
                       + JobMetaData.SubmaterialTableMetaData.MEMBER + " text not null,"
                       + JobMetaData.SubmaterialTableMetaData.MINORMARK + " text not null,"
                       + JobMetaData.SubmaterialTableMetaData.TYPE + " text not null,"
                       + JobMetaData.SubmaterialTableMetaData.LENGTH + " real not null,"
                       + JobMetaData.SubmaterialTableMetaData.WIDTH + " real not null,"
                       + JobMetaData.SubmaterialTableMetaData.THICKNESS + " real not null,"
                       + JobMetaData.SubmaterialTableMetaData.FINISH + " text not null,"
                       + JobMetaData.SubmaterialTableMetaData.GRADE + " text not null,"
                       + JobMetaData.SubmaterialTableMetaData.PLATE_DIAMETER + " real not null,"
                       + JobMetaData.SubmaterialTableMetaData.DESCRIPTION_IMPERIAL + " text not null,"
                       + JobMetaData.SubmaterialTableMetaData.DESCRIPTION_METRIC + " text not null,"
                       + JobMetaData.SubmaterialTableMetaData.MAIN + " integer not null,"
                       + JobMetaData.SubmaterialTableMetaData.USE  + " text not null,"
                       + JobMetaData.SubmaterialTableMetaData.WEIGHT + " real not null);");