From eb9d793ca218f61169997f2efcd838c831b614ac Mon Sep 17 00:00:00 2001 From: Anton Date: Sun, 4 Sep 2016 00:55:58 +0400 Subject: fixed settings table creation query, make values unique --- pica-client/main.cpp | 6 ++++-- 1 file changed, 4 insertions(+), 2 deletions(-) (limited to 'pica-client') diff --git a/pica-client/main.cpp b/pica-client/main.cpp index 018374b..99a19f2 100644 --- a/pica-client/main.cpp +++ b/pica-client/main.cpp @@ -138,7 +138,8 @@ static bool create_database() query.exec("create table settings \ ( \ name varchar(255) not null, \ - value varchar(255) not null \ + value varchar(255) not null, \ + constraint pk primary key (name) on conflict replace \ );" ); @@ -378,7 +379,8 @@ static bool update_database() query.exec("create table settings \ ( \ name varchar(255) not null, \ - value varchar(255) not null \ + value varchar(255) not null, \ + constraint pk primary key (name) on conflict replace \ );" ); -- cgit v1.2.1