zimbardo/sql/strix.sql

BEGIN TRANSACTION;
CREATE TABLE users (
        id integer primary key autoincrement,
        ime text,
        prezime text,
        email text
);
INSERT INTO "users" VALUES(NULL,'Anonymous','Coward','nobody@example.com');
INSERT INTO "users" VALUES(NULL,'Example','User','example@exaxmple.com');
INSERT INTO "users" VALUES(NULL,'Dobrica','Pavlinusic','dpavlin@rot13.org');
COMMIT;
1	BEGIN TRANSACTION;
2	CREATE TABLE users (
3	id integer primary key autoincrement,
4	ime text,
5	prezime text,
6	email text
7	);
8	INSERT INTO "users" VALUES(NULL,'Anonymous','Coward','nobody@example.com');
9	INSERT INTO "users" VALUES(NULL,'Example','User','example@exaxmple.com');
10	INSERT INTO "users" VALUES(NULL,'Dobrica','Pavlinusic','dpavlin@rot13.org');
11	COMMIT;