BEGIN TRANSACTION; CREATE TABLE IF NOT EXISTS "clients" ( "id" INTEGER, "name" TEXT, "second" TEXT, "local" INTEGER DEFAULT 0, PRIMARY KEY("id") ); INSERT INTO "clients" ("id","name","second","local") VALUES (2,'titi','alber',0); INSERT INTO "clients" ("id","name","second","local") VALUES (4,'tutut','Loulou',0); INSERT INTO "clients" ("id","name","second","local") VALUES (5,'machins','louis',0); INSERT INTO "clients" ("id","name","second","local") VALUES (6,'machin','tartenpion',0); INSERT INTO "clients" ("id","name","second","local") VALUES (7,'truc','bidule',0); COMMIT;