PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE user (id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT UNIQUE NOT NULL);
INSERT INTO user VALUES(1,'vreni');
INSERT INTO user VALUES(2,'hans');
INSERT INTO user VALUES(3,'ueli');
INSERT INTO user VALUES(4,'margarethe');
CREATE TABLE score (id INTEGER PRIMARY KEY AUTOINCREMENT, 
  userid INT NOT NULL, 
  zeit TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, 
  score INT, 
  FOREIGN KEY(userid) REFERENCES USER(id));
INSERT INTO score VALUES(1,1,'2024-04-30 05:41:37',120);
INSERT INTO score VALUES(2,3,'2024-04-30 05:41:47',104);
INSERT INTO score VALUES(3,4,'2024-04-30 05:41:53',84);
INSERT INTO score VALUES(4,2,'2024-04-30 05:42:00',120);
INSERT INTO score VALUES(5,4,'2024-04-30 05:42:39',144);
INSERT INTO score VALUES(6,2,'2024-04-30 05:42:50',110);
DELETE FROM sqlite_sequence;
INSERT INTO sqlite_sequence VALUES('user',4);
INSERT INTO sqlite_sequence VALUES('score',6);
COMMIT;