diff options
| -rw-r--r-- | pica-client/main.cpp | 6 |
1 files changed, 4 insertions, 2 deletions
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 \ );" ); |