I'm trying to create a table here in my app, but something is not quite right, when I run the app I get the following error message:
"could not prepare statement (1 table clientes has no column named clientes_id)"
What am I missing here?
tx.executeSql("CREATE TABLE IF NOT EXISTS clientes (" +
"_criado Text, "+
"_modificado Text, "+
"_status Text, " +
"id_rm Integer, "+
"clientes_id Integer PRIMARY KEY AUTOINCREMENT, " +
"credencial_id Integer, " +
"informacao_adicional, "+
"nome, "+
"tipo, "+
"CONSTRAINT unique_clientes_id UNIQUE ('clientes_id'))");
tx.executeSql('CREATE INDEX IF NOT EXISTS "clientes.index_clientes_id" ON "clientes"("clientes_id");');
tx.executeSql( 'INSERT INTO clientes( clientes_id ) VALUES ( "1" )');