Repository navigation
How to create table with ON CONFLICT strategy? #1264
Description
I'm totally new of your tool.
I've an 1-year old sqlite db with this following create statement
CREATE TABLE Links (Title TEXT, Data TEXT, Magnet TEXT, Found NUMERIC DEFAULT 0, primary key (Magnet) ON CONFLICT REPLACE)
As you can see, I've an ON CONFLICT strategy here.
I'm not able to create a new table with the same strategy using your tool.
Reacted by Firebird
Activity
justinclift commentedon Dec 10, 2017
Hmmm, you'll probably need to manually execute the CREATE statement in the
Execute SQLtab, as we haven't yet added support for that in the table creation dialog.Sorry there's not a better answer yet. 😉
MKleusberg commentedon Dec 15, 2017
I'll reopen the issue because it's definitely something we should implement at some point 😄 And if the issue is still open we have a nice reminder to do so.