1. Anton Golov
  2. Database Assignment

Commits

Anton Golov  committed bd04abe

Fixed dbvul

  • Participants
  • Parent commits e8fc35d
  • Branches default

Comments (0)

Files changed (1)

File dbvul.txt

View file
  • Ignore whitespace
+INSERT INTO Member (MemName, Address) VALUES ("Anton", "Hilversum");
+INSERT INTO Member (MemName, Address) VALUES ("Bert", "Den Haag");
+INSERT INTO Member (MemName, Address) VALUES ("Casper", "Paaseiland");
+INSERT INTO Member (MemName, Address) VALUES ("Danny", "Utrecht");
+INSERT INTO Member (MemName, Address) VALUES ("Ewout", "Amsterdam");
+INSERT INTO Member (MemName, Address) VALUES ("Frank", "Diemen");
+INSERT INTO Member (MemName, Address) VALUES ("Gandhi", "India");
+INSERT INTO Member (MemName, Address) VALUES ("Harry", "Bussum");
+INSERT INTO Member (MemName, Address) VALUES ("Iman", "");
+INSERT INTO MemEmail (Email, MemId) Values ("a@a.com", 1);
+INSERT INTO MemEmail (Email, MemId) Values ("b@b.com", 2);
+INSERT INTO MemEmail (Email, MemId) Values ("c@c.com", 3);
+INSERT INTO MemEmail (Email, MemId) Values ("d@d.com", 4);
+INSERT INTO MemEmail (Email, MemId) Values ("e@e.com", 5);
+INSERT INTO MemEmail (Email, MemId) Values ("f@f.com", 6);
+INSERT INTO MemEmail (Email, MemId) Values ("g@g.com", 7);
+INSERT INTO MemEmail (Email, MemId) Values ("h@h.com", 8);
+INSERT INTO MemEmail (Email, MemId) Values ("i@i.com", 9);
+INSERT INTO MemPhone (Phone, MemId) Values ("0622222222", 2);
+INSERT INTO MemPhone (Phone, MemId) Values ("0633333333", 3);
+INSERT INTO MemPhone (Phone, MemId) Values ("0644444444", 4);
+INSERT INTO MemPhone (Phone, MemId) Values ("0655555555", 5);
+INSERT INTO MemPhone (Phone, MemId)  Values ("0666666666", 6);
+INSERT INTO MemPhone (Phone, MemId)  Values ("0677777777", 7);
+INSERT INTO MemPhone (Phone, MemId)  Values ("0688888888", 8);
+INSERT INTO MemPhone (Phone, MemId)  Values ("0699999999", 9);
+INSERT INTO Player (MemId)  Values (1);
+INSERT INTO Player (MemId)  Values (2);
+INSERT INTO Player (MemId)  Values (3);
+INSERT INTO Player (MemId)  Values (4);
+INSERT INTO Player (MemId)  Values (5);
+INSERT INTO Player (MemId)  Values (6);
+INSERT INTO Player (MemId)  Values (7);
+INSERT INTO Player (MemId)  Values (8);
+INSERT INTO Player (MemId)  Values (9);
+INSERT INTO DungeonMaster (MemId) VALUES (8);
+INSERT INTO Campaign (Title, BeginDate, EndDate, DmId)  VALUES ("The Beginning of the End", 23-03-2012, 27-03-2012, 1);
+INSERT INTO Campaign (Title, BeginDate, EndDate, DmId)  VALUES ("What comes from the shadows", 29-03-2012, 02-04-2012, 1);
+INSERT INTO Campaign (Title, BeginDate, EndDate, DmId)  VALUES ("Once, but never again", 05-04-2012, NULL, 1);
+INSERT INTO Sitting (Location, Date) VALUES ("Skype", 23-03-2012);
+INSERT INTO Sitting (Location, Date) VALUES ("Utrecht", 25-03-2012);
+INSERT INTO Sitting (Location, Date) VALUES ("Hilversum", 27-03-2012);
+INSERT INTO Sitting (Location, Date) VALUES ("Skype", 29-03-2012);
+INSERT INTO Sitting (Location, Date) VALUES ("India", 02-04-2012);
+INSERT INTO Sitting (Location, Date) VALUES ("Leiden", 05-04-2012);
+INSERT INTO Sitting (Location, Date) VALUES ("Skype", 08-07-2012);
+INSERT INTO Race (RaceName, RaceDescription) VALUES ("Dragonborn", NULL);
+INSERT INTO Race (RaceName, RaceDescription) VALUES ("Dwarf", "Clearly superiour in every way.");
+INSERT INTO Race (RaceName, RaceDescription) VALUES ("Elf", NULL);
+INSERT INTO Race (RaceName, RaceDescription) VALUES ("Eladrin", NULL);
+INSERT INTO Race (RaceName, RaceDescription) VALUES ("Halfelf", NULL);
+INSERT INTO Race (RaceName, RaceDescription) VALUES ("Halfling", NULL);
+INSERT INTO Race (RaceName, RaceDescription) VALUES ("Human", NULL);
+INSERT INTO Race (RaceName, RaceDescription) VALUES ("Tiefling", NULL);
+INSERT INTO Character (CharName, RaceId) VALUES ("Grumpf", 1);
+INSERT INTO Character (CharName, RaceId) VALUES ("Silverleaf", 3);
+INSERT INTO Character (CharName, RaceId) VALUES ("Knibbler", 6);
+INSERT INTO Character (CharName, RaceId) VALUES ("John", 7);
+INSERT INTO Character (CharName, RaceId) VALUES ("Grace", 8);
+