primary key not working. Adds duplicate values.

[carper7]

I have the following code but it is not working:

alasql("create INDEXEDDB DATABASE if not exists localdb_db");
alasql("ATTACH INDEXEDDB DATABASE localdb_db; \ CREATE TABLE if not exists localdb_db.db_Settings(**setting varchar(50) Primary Key**, `value` varchar(300), storeInSession varchar(1) DEFAULT 'N')", function(res) {
             console.log(res + " :indexedDB");	
 });
		 
alasql("ATTACH INDEXEDDB DATABASE localdb_db; \ INSERT INTO localdb_db.db_Settings (setting,`value` ) values(?,?)", ["domain", "http"], function(res) {
             console.log(res);	
 });
         
alasql("ATTACH INDEXEDDB DATABASE localdb_db; \ INSERT INTO localkics_db.db_Settings (setting, `value` ) values(?,?)", ["domain", "https"], function(res) {
             //console.log(res);	
 });
		 
alasql("ATTACH INDEXEDDB DATABASE localdb_db; \ SELECT * FROM localdb_db.db_Settings", [], function(res) {
             console.log(res);
         });

It does not create the primary key [setting] therefore it allows me to insert duplicates. For some reason it is automatically creating its own key. I even tried by using string instead of varchar.

'#' |Key | Value
0 | 1 | {setting: “domain”, value: ”http”}
1 | 2 | {setting: “domain”, value: ”https”}

Could you please advise me what to do here?

Thank You.

[carper7]

Ok. I kind of made it work; but now the issue is I can't see the store nor the data.

alasql("create INDEXEDDB DATABASE if not exists localdb_db");
alasql("ATTACH INDEXEDDB DATABASE localdb_db; CREATE TABLE db_Settings(setting varchar(50) Primary Key, `value` 
 varchar(300), storeInSession varchar(1) DEFAULT 'N');");
		 
 alasql("ATTACH INDEXEDDB DATABASE localdb_db; INSERT INTO db_Settings (setting,`value` ) values(?,?),(?,?);", ["domain", "http","domain", "https"], function(res) {
             console.log(res);	
 });

Also I noticed that for this to work, I have to pass all the values in on e single insert so it would check for the constrains.

[gimnathperera]

Hi @mathiasrw can you assign this to me ?