PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE student (id INTEGER PRIMARY KEY AUTOINCREMENT,
name TEXT NOT NULL);
INSERT INTO student VALUES(1,'vreni');
INSERT INTO student VALUES(2,'hans');
INSERT INTO student VALUES(3,'ueli');
INSERT INTO student VALUES(4,'margarethe');
CREATE TABLE freifach (id INTEGER PRIMARY KEY AUTOINCREMENT,
name TEXT UNIQUE NOT NULL);
INSERT INTO freifach VALUES(1,'python');
INSERT INTO freifach VALUES(2,'javascript');
INSERT INTO freifach VALUES(3,'sql');
CREATE TABLE wahl (id INTEGER PRIMARY KEY AUTOINCREMENT,
freifachid INTEGER NOT NULL,
studentid INTEGER NOT NULL,
FOREIGN KEY(freifachid) REFERENCES freifach(id),
FOREIGN KEY(studentid) REFERENCES student(id));
INSERT INTO wahl VALUES(1,1,1);
INSERT INTO wahl VALUES(2,1,3);
INSERT INTO wahl VALUES(3,2,3);
INSERT INTO wahl VALUES(4,1,4);
INSERT INTO wahl VALUES(5,2,4);
INSERT INTO wahl VALUES(6,3,4);
DELETE FROM sqlite_sequence;
INSERT INTO sqlite_sequence VALUES('student',4);
INSERT INTO sqlite_sequence VALUES('freifach',3);
INSERT INTO sqlite_sequence VALUES('wahl',6);
COMMIT;