Anton Golov avatar Anton Golov committed 4cadb42

Merged.

Comments (0)

Files changed (1)

 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 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 ("h@h.com", 7);
 
-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 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 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 DungeonMaster (MemId) VALUES (7);
 INSERT INTO DungeonMaster (MemId) VALUES (4);
 
 INSERT INTO Campaign (Title, BeginDate, EndDate, DmId)  VALUES ("The Beginning of the End", 23-03-2012, 27-03-2012, 1);
 
 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 ("Tiefling", NULL);
 
 INSERT INTO Character (CharName, RaceId) VALUES ("Grumpf", 1);
+INSERT INTO Character (CharName, RaceId) VALUES ("Krugmar", 2);
+INSERT INTO Character (CharName, RaceId) VALUES ("Silverleaf", 3);
+INSERT INTO Character (CharName, RaceId) VALUES ("Knibbler", 5);
+INSERT INTO Character (CharName, RaceId) VALUES ("John", 6);
+INSERT INTO Character (CharName, RaceId) VALUES ("Grace", 7);
+
+INSERT INTO Character (CharName, RaceId) VALUES ("Grumpf", 1);
+INSERT INTO Character (CharName, RaceId) VALUES ("Kilroy", 2);
 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);
 
+INSERT INTO CharSkill (CharId, Skill) VALUES (1, "Acrobatics");
+INSERT INTO CharSkill (CharId, Skill) VALUES (1, "Dungeoneering");
+INSERT INTO CharSkill (CharId, Skill) VALUES (1, "Intimidate");
+INSERT INTO CharSkill (CharId, Skill) VALUES (2, "History");
+INSERT INTO CharSkill (CharId, Skill) VALUES (4, "Heal");
+INSERT INTO CharSkill (CharId, Skill) VALUES (4, "Bluff");
+INSERT INTO CharSkill (CharId, Skill) VALUES (4, "Stealth");
+INSERT INTO CharSkill (CharId, Skill) VALUES (4, "Thievery");
+INSERT INTO CharSkill (CharId, Skill) VALUES (5, "Streetwise");
+INSERT INTO CharSkill (CharId, Skill) VALUES (5, "Insight");
+INSERT INTO CharSkill (CharId, Skill) VALUES (5, "Endurance");
+
+INSERT INTO Class (ClassName, ClassDescription) VALUES ("Cleric", NULL);
+INSERT INTO Class (ClassName, ClassDescription) VALUES ("Fighter", NULL);
+INSERT INTO Class (ClassName, ClassDescription) VALUES ("Paladin", NULL);
+INSERT INTO Class (ClassName, ClassDescription) VALUES ("Ranger", NULL);
+INSERT INTO Class (ClassName, ClassDescription) VALUES ("Rogue", NULL);
+INSERT INTO Class (ClassName, ClassDescription) VALUES ("Warlock", NULL);
+INSERT INTO Class (ClassName, ClassDescription) VALUES ("Wizard", NULL);
+
+INSERT INTO Item (Cost, ItemName, Damage) VALUES (1, "Cloth Armor", NULL);
+INSERT INTO Item (Cost, ItemName, Damage) VALUES (25, "Leather Armor", NULL);
+INSERT INTO Item (Cost, ItemName, Damage) VALUES (30, "Hide Armor", NULL);
+INSERT INTO Item (Cost, ItemName, Damage) VALUES (40, "Chainmail", NULL);
+INSERT INTO Item (Cost, ItemName, Damage) VALUES (50, "Plate Armor", NULL);
+INSERT INTO Item (Cost, ItemName, Damage) VALUES (5, "Light Shield", NULL);
+INSERT INTO Item (Cost, ItemName, Damage) VALUES (1, "Club", "1d6");
+INSERT INTO Item (Cost, ItemName, Damage) VALUES (1, "Spear", "1d8");
+INSERT INTO Item (Cost, ItemName, Damage) VALUES (1, "Morningstar", "1d10");
+INSERT INTO Item (Cost, ItemName, Damage) VALUES (1, "Battleaxe", "1d10");
+INSERT INTO Item (Cost, ItemName, Damage) VALUES (1, "Falchion", "2d4");
+INSERT INTO Item (Cost, ItemName, Damage) VALUES (1, "Rapier", "1d8");
+
+INSERT INTO Power(PowName, PowDescription, Effect) VALUES ("Reaping Strike", "You punctuate your scything attacks with wicked jabs and small cutting blows that slip through your enemy's defenses.", "1[W] + Strength modifier damage.");
+INSERT INTO Power(PowName, PowDescription, Effect) VALUES ("Tide of Iron", "After each mighty swing, you bring your shield to bear and use it to push the enemy back..", "1[W] + Strength modifier damage, and push the taget 1 square.");
+INSERT INTO Power(PowName, PowDescription, Effect) VALUES ("Entangling Smite", "Strands of energy erupt from your weapon as it strikes true, wrapping around your foe and rooting it to the ground", "2[W] + Charisma modifier damage. Target is immobilized for 1 turn.");
+INSERT INTO Power(PowName, PowDescription, Effect) VALUES ("Thundertusk Boar Strike", "You attack twice, causing your foes to stagger backward.", "1[W] + Strength modifier damage, attack twice. Push taget 1 square with each attack.");
+
+INSERT INTO Controls (PlayId, CharId) VALUES (2, 1);
+INSERT INTO Controls (PlayId, CharId) VALUES (4, 2);
+INSERT INTO Controls (PlayId, CharId) VALUES (5, 3);
+INSERT INTO Controls (PlayId, CharId) VALUES (6, 4);
+INSERT INTO Controls (PlayId, CharId) VALUES (9, 5);
+
+INSERT INTO Runs (DmId, CampId) VALUES (7, 1);
+INSERT INTO Runs (DmId, CampId) VALUES (7, 2);
+INSERT INTO Runs (DmId, CampId) VALUES (4, 3);
+
 INSERT INTO PresentAt (MemId, SitId) VALUES (3, 1);
 INSERT INTO PresentAt (MemId, SitId) VALUES (2, 1);
 INSERT INTO PresentAt (MemId, SitId) VALUES (4, 1);
 INSERT INTO PresentAt (MemId, SitId) VALUES (8, 3);
 INSERT INTO PresentAt (MemId, SitId) VALUES (9, 3);
 INSERT INTO PresentAt (MemId, SitId) VALUES (2, 3);
+INSERT INTO PresentAt (MemId, SitId) VALUES (7, 3);
 INSERT INTO PresentAt (MemId, SitId) VALUES (3, 4);
 INSERT INTO PresentAt (MemId, SitId) VALUES (7, 4);
 INSERT INTO PresentAt (MemId, SitId) VALUES (2, 4);
 INSERT INTO ParticipatesIn (PlayId, CampId) VALUES (2, 1);
 INSERT INTO ParticipatesIn (PlayId, CampId) VALUES (4, 1);
 INSERT INTO ParticipatesIn (PlayId, CampId) VALUES (6, 1);
-INSERT INTO ParticipatesIn (PlayId, CampId) VALUES (7, 1);
-INSERT INTO ParticipatesIn (PlayId, CampId) VALUES (8, 1);
 INSERT INTO ParticipatesIn (PlayId, CampId) VALUES (1, 2);
 INSERT INTO ParticipatesIn (PlayId, CampId) VALUES (2, 2);
 INSERT INTO ParticipatesIn (PlayId, CampId) VALUES (3, 2);
-INSERT INTO ParticipatesIn (PlayId, CampId) VALUES (7, 2);
-INSERT INTO ParticipatesIn (PlayId, CampId) VALUES (8, 2);
-INSERT INTO ParticipatesIn (PlayId, CampId) VALUES (9, 3);
-INSERT INTO ParticipatesIn (PlayId, CampId) VALUES (8, 3);
 INSERT INTO ParticipatesIn (PlayId, CampId) VALUES (3, 3);
+INSERT INTO ParticipatesIn (PlayId, CampId) VALUES (2, 3);
+INSERT INTO ParticipatesIn (PlayId, CampId) VALUES (5, 3);
+INSERT INTO ParticipatesIn (PlayId, CampId) VALUES (7, 3);
 
 INSERT INTO IsOfClass (CharId, ClassId, Level) VALUES (1, 3, 5);
 INSERT INTO IsOfClass (CharId, ClassId, Level) VALUES (1, 4, 3);
Tip: Filter by directory path e.g. /media app.js to search for public/media/app.js.
Tip: Use camelCasing e.g. ProjME to search for ProjectModifiedEvent.java.
Tip: Filter by extension type e.g. /repo .js to search for all .js files in the /repo directory.
Tip: Separate your search with spaces e.g. /ssh pom.xml to search for src/ssh/pom.xml.
Tip: Use ↑ and ↓ arrow keys to navigate and return to view the file.
Tip: You can also navigate files with Ctrl+j (next) and Ctrl+k (previous) and view the file with Ctrl+o.
Tip: You can also navigate files with Alt+j (next) and Alt+k (previous) and view the file with Alt+o.