18.10.2018, 20:48
Code:
"`AttachPosx_0` FLOAT(11) NOT NULL", "`AttachPosx_1` FLOAT(11) NOT NULL", "`AttachPosx_2` FLOAT(11) NOT NULL", "`AttachPosx_3` FLOAT(11) NOT NULL", "`AttachPosx_4` FLOAT(11) NOT NULL", "`AttachPosy_0` FLOAT(11) NOT NULL", "`AttachPosy_1` FLOAT(11) NOT NULL", "`AttachPosy_2` FLOAT(11) NOT NULL", "`AttachPosy_3` FLOAT(11) NOT NULL", "`AttachPosy_4` FLOAT(11) NOT NULL", "`AttachPosz_0` FLOAT(11) NOT NULL", "`AttachPosz_1` FLOAT(11) NOT NULL", "`AttachPosz_2` FLOAT(11) NOT NULL", "`AttachPosz_3` FLOAT(11) NOT NULL", "`AttachPosz_4` FLOAT(11) NOT NULL", "`AttachAngx_0` FLOAT(11) NOT NULL", "`AttachAngx_1` FLOAT(11) NOT NULL", "`AttachAngx_2` FLOAT(11) NOT NULL", "`AttachAngx_3` FLOAT(11) NOT NULL", "`AttachAngx_4` FLOAT(11) NOT NULL", "`AttachAngy_0` FLOAT(11) NOT NULL", "`AttachAngy_1` FLOAT(11) NOT NULL", "`AttachAngy_2` FLOAT(11) NOT NULL", "`AttachAngy_3` FLOAT(11) NOT NULL", "`AttachAngy_4` FLOAT(11) NOT NULL", "`AttachAngz_0` FLOAT(11) NOT NULL", "`AttachAngz_1` FLOAT(11) NOT NULL", "`AttachAngz_2` FLOAT(11) NOT NULL", "`AttachAngz_3` FLOAT(11) NOT NULL", "`AttachAngz_4` FLOAT(11) NOT NULL", "`AttachEscx_0` FLOAT(11) NOT NULL", "`AttachEscx_1` FLOAT(11) NOT NULL", "`AttachEscx_2` FLOAT(11) NOT NULL", "`AttachEscx_3` FLOAT(11) NOT NULL", "`AttachEscx_4` FLOAT(11) NOT NULL", "`AttachEscy_0` FLOAT(11) NOT NULL", "`AttachEscy_1` FLOAT(11) NOT NULL", "`AttachEscy_2` FLOAT(11) NOT NULL", "`AttachEscy_3` FLOAT(11) NOT NULL", "`AttachEscy_4` FLOAT(11) NOT NULL", "`AttachEscz_0` FLOAT(11) NOT NULL", "`AttachEscz_1` FLOAT(11) NOT NULL", "`AttachEscz_2` FLOAT(11) NOT NULL", "`AttachEscz_3` FLOAT(11) NOT NULL", "`AttachEscz_4` FLOAT(11) NOT NULL"
@OP: No need to do all this derby smashing queries when creating an account. Just set default values and insert only the most important ones. Such as account ID, password and email.
Also set your userID to AUTO_INCREMENT and PRIMARY.