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 (4,'tutu','Loulou',2); INSERT INTO "clients" ("id","name","second","local") VALUES (5,'machins','louis',6); INSERT INTO "clients" ("id","name","second","local") VALUES (6,'machin','tartenpion',6); INSERT INTO "clients" ("id","name","second","local") VALUES (13,'encore','toujooures',4); INSERT INTO "clients" ("id","name","second","local") VALUES (14,'toto','riri',6); COMMIT;