trunk/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	dpavlin	44	BEGIN TRANSACTION;
2			CREATE TABLE users (
3	dpavlin	76	id integer primary key autoincrement,
4	dpavlin	44	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;