· 9 years ago · Aug 07, 2017, 05:28 AM
1-- Dungeons and Dragons Database
2-- This file is for creating and populating data into tables
3
4
5-- The is delete table if there are tables with the same name in the current database
6-- Will display error if table with the same name does not exist, can be ignored
7
8drop table if exists player;
9drop table if exists party_character;
10drop table if exists encounters;
11drop table if exists participates_in;
12drop table if exists enemy_character;
13drop table if exists dungeon;
14
15-- creating the Table called player (contains player contact info)
16create table player(
17 email varchar(30) NOT NULL primary key,
18 name varchar(30),
19 phone_number varchar(10),
20 address varchar(30)
21 );
22
23-- inserting data into the table player
24insert into player values ('gbooth@hotmail.com', 'Gehana', '6133880163', '123 Prince of Wales');
25insert into player values ('ebill@gmail.com', 'Eric', '6134569384', '335 Ban Road');
26insert into player values ('maria_rawr@hotmail.com', 'Maria', '6132240009', '335 Ban Road');
27insert into player values ('comm_josh@rogers.com', 'Josh', '6134697312', '65 Woodroffe Ave');
28insert into player values ('chi_mai@gmail.com', 'ChiMai', '6138880256', '72 Bayshore Road');
29insert into player values ('matt@warhammer.com', 'Matt', '6134159015', '123 Prince of Wales');
30insert into player values ('daveh@hotmail.com', 'Dave', '6135571111', '632 Fry Road');
31insert into player values ('eva_wings@gmail.com', 'Eva', '6134445643', '75 Highland Ave');
32
33-- creating the Table called party_character (contains party character stats)
34create table party_character(
35 email varchar(30) NOT NULL,
36 characteristics varchar(50) NOT NULL,
37 name varchar(30) NOT NULL,
38 gender varchar(1),
39 skills varchar(50),
40 plevel integer,
41 pclass varchar(15),
42 health integer,
43 alginment varchar(30),
44 exp integer,
45 primary key (email, characteristics, name),
46 foreign key (email) references player (email)
47 );
48
49-- inserting data into the table party_character
50insert into party_character values ('gbooth@hotmail.com', 'STR 11/INT 18/WIS 18/DEX 20/CON 11/CHA 13', 'Vi Sovari', 'F', 'OpenLock +20/Hide +20/Move Silently
51
52+18', 10, 'Rogue', 45, 'Neutral Good', 25000);
53insert into party_character values ('ebill@gmail.com', 'STR 11/INT 20/WIS 20/DEX 13/CON 11/CHA 13', 'Vaarsuvius', '?', 'Listen +15/Knowledge Arcana
54
55+20/Spellcraft +20', 10, 'Wizard', 35, 'Lawful Good', 24000);
56insert into party_character values ('maria_rawr@hotmail.com', 'STR 20/INT 8/WIS 14/DEX 16/CON 20/CHA 10', 'Gorushk', 'F', 'Tumble +20/Climb +20/Intimidate
57
5818', 10, 'Barbarian', 100, 'Chaotic Good', 24500);
59insert into party_character values ('comm_josh@rogers.com', 'STR 11/INT 18/WIS 18/DEX 20/CON 11/CHA 20', 'Julie Bluehilt', 'F', 'Fly +10/Bluff +20/Search
60
6118', 10, 'Sorceress', 35, 'Neutral Good', 22409);
62insert into party_character values ('chi_mai@gmail.co', 'STR 18/INT 15/WIS 15/DEX 20/CON 14/CHA 13', 'Aragon', 'M', 'Track +20/Ride +20/Knowledge Nature 18',
63
6410, 'Ranger', 60, 'Lawful Good', 25000);
65insert into party_character values ('matt@warhammer.com', 'STR 18/INT 11/WIS 18/DEX 16/CON 15/CHA 11', 'Jacki Li', 'M', 'Tumble +20/Balance +20/Rope 18', 10,
66
67'Drunken Monk', 75, 'Neutral Good', 24999);
68insert into party_character values ('daveh@hotmail.com', 'STR 18/INT 15/WIS 18/DEX 11/CON 16/CHA 13', 'Sir Awesome', 'M', 'Ride +20/Sense Motive
69
70+15/Knowledge Local 12', 10, 'Paladin', 78, 'Lawful Good', 23000);
71insert into party_character values ('eva_wings@gmail.com', 'STR 11/INT 18/WIS 18/DEX 15/CON 11/CHA 15', 'Skye', 'F', 'Craft +20/KnowledgeSpellcraft
72
73+20/KnowldgeNature 18', 10, 'Druid', 55, 'Neutral Good', 21000);
74
75--creating the Table called dungeon
76create table dungeon (
77 name varchar(30) NOT NULL primary key,
78 percent_complete integer
79 );
80
81--inserting data into the table dungeon
82insert into dungeon values('Bandit Caves', 100);
83insert into dungeon values('Evil Castle', 50);
84insert into dungeon values('Old Kirith', 0);
85insert into dungeon values('Mindflare Lair', 0);
86insert into dungeon values('Dragon Cave', 0);
87
88-- creating the Table called enemy_character
89create table enemy_character (
90 enemyID integer NOT NULL,
91 characteristics varchar(50) NOT NULL,
92 location varchar(30),
93 elevel integer,
94 eclass varchar(15),
95 health integer,
96 alignment varchar(30),
97 dname varchar(30),
98 primary key (enemyID, characteristics),
99 foreign key (dname) references dungeon (dname)
100 );
101
102--inserting data into the table enemy_character
103insert into enemy_character values(1, 'STR 18/INT 11/WIS 11/DEX 20/CON 14/CHA 13', 'Room1', 7, 'Warrior', 50, 'Chaotic Evil', 'Bandit Caves');
104insert into enemy_character values(2, 'STR 18/INT 11/WIS 11/DEX 20/CON 14/CHA 13', 'Room1', 7, 'Warrior', 50, 'Chaotic Evil', 'Bandit Caves');
105insert into enemy_character values(3, 'STR 18/INT 11/WIS 11/DEX 20/CON 14/CHA 13', 'Room2', 7, 'Warrior', 50, 'Chaotic Evil', 'Bandit Caves');
106insert into enemy_character values(4, 'STR 18/INT 11/WIS 11/DEX 20/CON 14/CHA 13', 'Room2', 7, 'Warrior', 50, 'Chaotic Evil', 'Bandit Caves');
107insert into enemy_character values(5, 'STR 18/INT 11/WIS 11/DEX 20/CON 14/CHA 13', 'Room2', 7, 'Warrior', 50, 'Chaotic Evil', 'Bandit Caves');
108insert into enemy_character values(6, 'STR 18/INT 11/WIS 11/DEX 20/CON 14/CHA 13', 'Room2', 7, 'Warrior', 50, 'Chaotic Evil', 'Bandit Caves');
109insert into enemy_character values(7, 'STR 18/INT 11/WIS 11/DEX 20/CON 14/CHA 13', 'Room2', 7, 'Warrior', 50, 'Chaotic Evil', 'Bandit Caves');
110insert into enemy_character values(8, 'STR 18/INT 11/WIS 11/DEX 20/CON 14/CHA 13', 'Room2', 7, 'Warrior', 50, 'Chaotic Evil', 'Bandit Caves');
111insert into enemy_character values(9, 'STR 14/INT 18/WIS 18/DEX 14/CON 11/CHA 13', 'Room3', 10, 'Wizard', 40, 'Chaotic Evil', 'Bandit Caves');
112insert into enemy_character values(10, 'STR 20/INT 11/WIS 11/DEX 15/CON 16/CHA 13', 'Courtyard', 8, 'Warrior', 80, 'Chaotic Evil', 'Evil Castle');
113insert into enemy_character values(11, 'STR 20/INT 11/WIS 11/DEX 15/CON 16/CHA 13', 'Courtyard', 8, 'Warrior', 80, 'Chaotic Evil', 'Evil Castle');
114insert into enemy_character values(12, 'STR 20/INT 11/WIS 11/DEX 15/CON 16/CHA 13', 'Courtyard', 8, 'Warrior', 80, 'Chaotic Evil', 'Evil Castle');
115insert into enemy_character values(13, 'STR 20/INT 11/WIS 11/DEX 15/CON 16/CHA 13', 'Courtyard', 8, 'Warrior', 80, 'Chaotic Evil', 'Evil Castle');
116insert into enemy_character values(14, 'STR 20/INT 11/WIS 11/DEX 15/CON 16/CHA 13', 'Courtyard', 8, 'Warrior', 80, 'Chaotic Evil', 'Evil Castle');
117insert into enemy_character values(15, 'STR 18/INT 18/WIS 15/DEX 20/CON 16/CHA 13', 'Wooded Grove', 10, 'Ranger', 100, 'Chaotic Evil', null);
118insert into enemy_character values(16, 'STR 18/INT 18/WIS 15/DEX 20/CON 16/CHA 13', 'Wooded Grove', 10, 'Ranger', 100, 'Chaotic Evil', null);
119insert into enemy_character values(17, 'STR 18/INT 18/WIS 15/DEX 20/CON 16/CHA 13', 'Wooded Grove', 10, 'Ranger', 100, 'Chaotic Evil', null);
120insert into enemy_character values(18, 'STR 18/INT 18/WIS 15/DEX 20/CON 16/CHA 13', 'Wooded Grove', 10, 'Ranger', 100, 'Chaotic Evil', null);
121insert into enemy_character values(19, 'STR 18/INT 18/WIS 15/DEX 20/CON 16/CHA 13', 'Wooded Grove', 10, 'Ranger', 100, 'Chaotic Evil', null);
122insert into enemy_character values(20, 'STR 18/INT 18/WIS 15/DEX 20/CON 16/CHA 13', 'Wooded Grove', 10, 'Ranger', 100, 'Chaotic Evil', null);
123
124-- creating the Table called encounters (N:N relationship, party characters encountering enemy characters)
125create table encounters (
126 email varchar(30) NOT NULL,
127 pcharacteristics varchar(50) NOT NULL,
128 pname varchar(30) NOT NULL,
129 enemyID integer NOT NULL,
130 echaracteristics varchar(50) NOT NULL,
131 primary key (email, pcharacteristics, pname, enemyID, echaracteristics),
132 foreign key (email) references party_character (email),
133 foreign key (pcharacteristics) references party_character (characteristics),
134 foreign key (pname) references party_character (name),
135 foreign key (enemyID) references enemy_character (enemyID),
136 foreign key (echaracteristics) references enemy_character(characteristics)
137 );
138
139-- inserting data into the tables encounters
140-- Gehana
141insert into encounters values('gbooth@hotmail.com', 'STR 11/INT 18/WIS 18/DEX 20/CON 11/CHA 13', 'Vi Sovari', 1, 'STR 18/INT 11/WIS 11/DEX 20/CON 14/CHA
142
14313');
144insert into encounters values('gbooth@hotmail.com', 'STR 11/INT 18/WIS 18/DEX 20/CON 11/CHA 13', 'Vi Sovari', 2, 'STR 18/INT 11/WIS 11/DEX 20/CON 14/CHA
145
14613');
147insert into encounters values('gbooth@hotmail.com', 'STR 11/INT 18/WIS 18/DEX 20/CON 11/CHA 13', 'Vi Sovari', 3, 'STR 18/INT 11/WIS 11/DEX 20/CON 14/CHA
148
14913');
150insert into encounters values('gbooth@hotmail.com', 'STR 11/INT 18/WIS 18/DEX 20/CON 11/CHA 13', 'Vi Sovari', 4, 'STR 18/INT 11/WIS 11/DEX 20/CON 14/CHA
151
15213');
153insert into encounters values('gbooth@hotmail.com', 'STR 11/INT 18/WIS 18/DEX 20/CON 11/CHA 13', 'Vi Sovari', 5, 'STR 18/INT 11/WIS 11/DEX 20/CON 14/CHA
154
15513');
156insert into encounters values('gbooth@hotmail.com', 'STR 11/INT 18/WIS 18/DEX 20/CON 11/CHA 13', 'Vi Sovari', 6, 'STR 18/INT 11/WIS 11/DEX 20/CON 14/CHA
157
15813');
159insert into encounters values('gbooth@hotmail.com', 'STR 11/INT 18/WIS 18/DEX 20/CON 11/CHA 13', 'Vi Sovari', 7, 'STR 18/INT 11/WIS 11/DEX 20/CON 14/CHA
160
16113');
162insert into encounters values('gbooth@hotmail.com', 'STR 11/INT 18/WIS 18/DEX 20/CON 11/CHA 13', 'Vi Sovari', 8, 'STR 18/INT 11/WIS 11/DEX 20/CON 14/CHA
163
16413');
165insert into encounters values('gbooth@hotmail.com', 'STR 11/INT 18/WIS 18/DEX 20/CON 11/CHA 13', 'Vi Sovari', 9, 'STR 14/INT 18/WIS 18/DEX 14/CON 11/CHA
166
16713');
168--Eric
169insert into encounters values('ebill@gmail.com', 'STR 11/INT 20/WIS 20/DEX 13/CON 11/CHA 13', 'Vaarsuvius', 1, 'STR 18/INT 11/WIS 11/DEX 20/CON 14/CHA 13');
170insert into encounters values('ebill@gmail.com', 'STR 11/INT 20/WIS 20/DEX 13/CON 11/CHA 13', 'Vaarsuvius', 2, 'STR 18/INT 11/WIS 11/DEX 20/CON 14/CHA 13');
171insert into encounters values('ebill@gmail.com', 'STR 11/INT 20/WIS 20/DEX 13/CON 11/CHA 13', 'Vaarsuvius', 3, 'STR 18/INT 11/WIS 11/DEX 20/CON 14/CHA 13');
172insert into encounters values('ebill@gmail.com', 'STR 11/INT 20/WIS 20/DEX 13/CON 11/CHA 13', 'Vaarsuvius', 4, 'STR 18/INT 11/WIS 11/DEX 20/CON 14/CHA 13');
173insert into encounters values('ebill@gmail.com', 'STR 11/INT 20/WIS 20/DEX 13/CON 11/CHA 13', 'Vaarsuvius', 5, 'STR 18/INT 11/WIS 11/DEX 20/CON 14/CHA 13');
174insert into encounters values('ebill@gmail.com', 'STR 11/INT 20/WIS 20/DEX 13/CON 11/CHA 13', 'Vaarsuvius', 6, 'STR 18/INT 11/WIS 11/DEX 20/CON 14/CHA 13');
175insert into encounters values('ebill@gmail.com', 'STR 11/INT 20/WIS 20/DEX 13/CON 11/CHA 13', 'Vaarsuvius', 7, 'STR 18/INT 11/WIS 11/DEX 20/CON 14/CHA 13');
176insert into encounters values('ebill@gmail.com', 'STR 11/INT 20/WIS 20/DEX 13/CON 11/CHA 13', 'Vaarsuvius', 8, 'STR 18/INT 11/WIS 11/DEX 20/CON 14/CHA 13');
177insert into encounters values('ebill@gmail.com', 'STR 11/INT 20/WIS 20/DEX 13/CON 11/CHA 13', 'Vaarsuvius', 9, 'STR 14/INT 18/WIS 18/DEX 14/CON 11/CHA 13');
178-- Maria
179insert into encounters values('maria_rawr@hotmail.com', 'STR 20/INT 8/WIS 14/DEX 16/CON 20/CHA 10', 'Gorushk', 1, 'STR 18/INT 11/WIS 11/DEX 20/CON 14/CHA
180
18113');
182insert into encounters values('maria_rawr@hotmail.com', 'STR 20/INT 8/WIS 14/DEX 16/CON 20/CHA 10', 'Gorushk', 2, 'STR 18/INT 11/WIS 11/DEX 20/CON 14/CHA
183
18413');
185insert into encounters values('maria_rawr@hotmail.com', 'STR 20/INT 8/WIS 14/DEX 16/CON 20/CHA 10', 'Gorushk', 3, 'STR 18/INT 11/WIS 11/DEX 20/CON 14/CHA
186
18713');
188insert into encounters values('maria_rawr@hotmail.com', 'STR 20/INT 8/WIS 14/DEX 16/CON 20/CHA 10', 'Gorushk', 4, 'STR 18/INT 11/WIS 11/DEX 20/CON 14/CHA
189
19013');
191insert into encounters values('maria_rawr@hotmail.com', 'STR 20/INT 8/WIS 14/DEX 16/CON 20/CHA 10', 'Gorushk', 5, 'STR 18/INT 11/WIS 11/DEX 20/CON 14/CHA
192
19313');
194insert into encounters values('maria_rawr@hotmail.com', 'STR 20/INT 8/WIS 14/DEX 16/CON 20/CHA 10', 'Gorushk', 6, 'STR 18/INT 11/WIS 11/DEX 20/CON 14/CHA
195
19613');
197insert into encounters values('maria_rawr@hotmail.com', 'STR 20/INT 8/WIS 14/DEX 16/CON 20/CHA 10', 'Gorushk', 7, 'STR 18/INT 11/WIS 11/DEX 20/CON 14/CHA
198
19913');
200insert into encounters values('maria_rawr@hotmail.com', 'STR 20/INT 8/WIS 14/DEX 16/CON 20/CHA 10', 'Gorushk', 8, 'STR 18/INT 11/WIS 11/DEX 20/CON 14/CHA
201
20213');
203insert into encounters values('maria_rawr@hotmail.com', 'STR 20/INT 8/WIS 14/DEX 16/CON 20/CHA 10', 'Gorushk', 9, 'STR 14/INT 18/WIS 18/DEX 14/CON 11/CHA
204
20513');
206-- Josh
207insert into encounters values('comm_josh@rogers.com', 'STR 11/INT 18/WIS 18/DEX 20/CON 11/CHA 20', 'Julie Bluehilt', 1, 'STR 18/INT 11/WIS 11/DEX 20/CON
208
20914/CHA 13');
210insert into encounters values('comm_josh@rogers.com', 'STR 11/INT 18/WIS 18/DEX 20/CON 11/CHA 20', 'Julie Bluehilt', 2, 'STR 18/INT 11/WIS 11/DEX 20/CON
211
21214/CHA 13');
213insert into encounters values('comm_josh@rogers.com', 'STR 11/INT 18/WIS 18/DEX 20/CON 11/CHA 20', 'Julie Bluehilt', 3, 'STR 18/INT 11/WIS 11/DEX 20/CON
214
21514/CHA 13');
216insert into encounters values('comm_josh@rogers.com', 'STR 11/INT 18/WIS 18/DEX 20/CON 11/CHA 20', 'Julie Bluehilt', 4, 'STR 18/INT 11/WIS 11/DEX 20/CON
217
21814/CHA 13');
219insert into encounters values('comm_josh@rogers.com', 'STR 11/INT 18/WIS 18/DEX 20/CON 11/CHA 20', 'Julie Bluehilt', 5, 'STR 18/INT 11/WIS 11/DEX 20/CON
220
22114/CHA 13');
222insert into encounters values('comm_josh@rogers.com', 'STR 11/INT 18/WIS 18/DEX 20/CON 11/CHA 20', 'Julie Bluehilt', 6, 'STR 18/INT 11/WIS 11/DEX 20/CON
223
22414/CHA 13');
225insert into encounters values('comm_josh@rogers.com', 'STR 11/INT 18/WIS 18/DEX 20/CON 11/CHA 20', 'Julie Bluehilt', 7, 'STR 18/INT 11/WIS 11/DEX 20/CON
226
22714/CHA 13');
228insert into encounters values('comm_josh@rogers.com', 'STR 11/INT 18/WIS 18/DEX 20/CON 11/CHA 20', 'Julie Bluehilt', 8, 'STR 18/INT 11/WIS 11/DEX 20/CON
229
23014/CHA 13');
231insert into encounters values('comm_josh@rogers.com', 'STR 11/INT 18/WIS 18/DEX 20/CON 11/CHA 20', 'Julie Bluehilt', 9, 'STR 14/INT 18/WIS 18/DEX 14/CON
232
23311/CHA 13');
234-- Chi Mai
235insert into encounters values('chi_mai@gmail.co', 'STR 18/INT 15/WIS 15/DEX 20/CON 14/CHA 13', 'Aragon', 1, 'STR 18/INT 11/WIS 11/DEX 20/CON 14/CHA 13');
236insert into encounters values('chi_mai@gmail.co', 'STR 18/INT 15/WIS 15/DEX 20/CON 14/CHA 13', 'Aragon', 2, 'STR 18/INT 11/WIS 11/DEX 20/CON 14/CHA 13');
237insert into encounters values('chi_mai@gmail.co', 'STR 18/INT 15/WIS 15/DEX 20/CON 14/CHA 13', 'Aragon', 3, 'STR 18/INT 11/WIS 11/DEX 20/CON 14/CHA 13');
238insert into encounters values('chi_mai@gmail.co', 'STR 18/INT 15/WIS 15/DEX 20/CON 14/CHA 13', 'Aragon', 4, 'STR 18/INT 11/WIS 11/DEX 20/CON 14/CHA 13');
239insert into encounters values('chi_mai@gmail.co', 'STR 18/INT 15/WIS 15/DEX 20/CON 14/CHA 13', 'Aragon', 5, 'STR 18/INT 11/WIS 11/DEX 20/CON 14/CHA 13');
240insert into encounters values('chi_mai@gmail.co', 'STR 18/INT 15/WIS 15/DEX 20/CON 14/CHA 13', 'Aragon', 6, 'STR 18/INT 11/WIS 11/DEX 20/CON 14/CHA 13');
241insert into encounters values('chi_mai@gmail.co', 'STR 18/INT 15/WIS 15/DEX 20/CON 14/CHA 13', 'Aragon', 7, 'STR 18/INT 11/WIS 11/DEX 20/CON 14/CHA 13');
242insert into encounters values('chi_mai@gmail.co', 'STR 18/INT 15/WIS 15/DEX 20/CON 14/CHA 13', 'Aragon', 8, 'STR 18/INT 11/WIS 11/DEX 20/CON 14/CHA 13');
243insert into encounters values('chi_mai@gmail.co', 'STR 18/INT 15/WIS 15/DEX 20/CON 14/CHA 13', 'Aragon', 9, 'STR 14/INT 18/WIS 18/DEX 14/CON 11/CHA 13');
244-- Matt
245insert into encounters values('matt@warhammer.com', 'STR 18/INT 11/WIS 18/DEX 16/CON 15/CHA 11', 'Jacki Li', 1, 'STR 18/INT 11/WIS 11/DEX 20/CON 14/CHA 13');
246insert into encounters values('matt@warhammer.com', 'STR 18/INT 11/WIS 18/DEX 16/CON 15/CHA 11', 'Jacki Li', 2, 'STR 18/INT 11/WIS 11/DEX 20/CON 14/CHA 13');
247insert into encounters values('matt@warhammer.com', 'STR 18/INT 11/WIS 18/DEX 16/CON 15/CHA 11', 'Jacki Li', 3, 'STR 18/INT 11/WIS 11/DEX 20/CON 14/CHA 13');
248insert into encounters values('matt@warhammer.com', 'STR 18/INT 11/WIS 18/DEX 16/CON 15/CHA 11', 'Jacki Li', 4, 'STR 18/INT 11/WIS 11/DEX 20/CON 14/CHA 13');
249insert into encounters values('matt@warhammer.com', 'STR 18/INT 11/WIS 18/DEX 16/CON 15/CHA 11', 'Jacki Li', 5, 'STR 18/INT 11/WIS 11/DEX 20/CON 14/CHA 13');
250insert into encounters values('matt@warhammer.com', 'STR 18/INT 11/WIS 18/DEX 16/CON 15/CHA 11', 'Jacki Li', 6, 'STR 18/INT 11/WIS 11/DEX 20/CON 14/CHA 13');
251insert into encounters values('matt@warhammer.com', 'STR 18/INT 11/WIS 18/DEX 16/CON 15/CHA 11', 'Jacki Li', 7, 'STR 18/INT 11/WIS 11/DEX 20/CON 14/CHA 13');
252insert into encounters values('matt@warhammer.com', 'STR 18/INT 11/WIS 18/DEX 16/CON 15/CHA 11', 'Jacki Li', 8, 'STR 18/INT 11/WIS 11/DEX 20/CON 14/CHA 13');
253insert into encounters values('matt@warhammer.com', 'STR 18/INT 11/WIS 18/DEX 16/CON 15/CHA 11', 'Jacki Li', 9, 'STR 14/INT 18/WIS 18/DEX 14/CON 11/CHA 13');
254-- Dave
255insert into encounters values('daveh@hotmail.com', 'STR 18/INT 15/WIS 18/DEX 11/CON 16/CHA 13', 'Sir Awesome', 1, 'STR 18/INT 11/WIS 11/DEX 20/CON 14/CHA
256
25713');
258insert into encounters values('daveh@hotmail.com', 'STR 18/INT 15/WIS 18/DEX 11/CON 16/CHA 13', 'Sir Awesome', 2, 'STR 18/INT 11/WIS 11/DEX 20/CON 14/CHA
259
26013');
261insert into encounters values('daveh@hotmail.com', 'STR 18/INT 15/WIS 18/DEX 11/CON 16/CHA 13', 'Sir Awesome', 3, 'STR 18/INT 11/WIS 11/DEX 20/CON 14/CHA
262
26313');
264insert into encounters values('daveh@hotmail.com', 'STR 18/INT 15/WIS 18/DEX 11/CON 16/CHA 13', 'Sir Awesome', 4, 'STR 18/INT 11/WIS 11/DEX 20/CON 14/CHA
265
26613');
267insert into encounters values('daveh@hotmail.com', 'STR 18/INT 15/WIS 18/DEX 11/CON 16/CHA 13', 'Sir Awesome', 5, 'STR 18/INT 11/WIS 11/DEX 20/CON 14/CHA
268
26913');
270insert into encounters values('daveh@hotmail.com', 'STR 18/INT 15/WIS 18/DEX 11/CON 16/CHA 13', 'Sir Awesome', 6, 'STR 18/INT 11/WIS 11/DEX 20/CON 14/CHA
271
27213');
273insert into encounters values('daveh@hotmail.com', 'STR 18/INT 15/WIS 18/DEX 11/CON 16/CHA 13', 'Sir Awesome', 7, 'STR 18/INT 11/WIS 11/DEX 20/CON 14/CHA
274
27513');
276insert into encounters values('daveh@hotmail.com', 'STR 18/INT 15/WIS 18/DEX 11/CON 16/CHA 13', 'Sir Awesome', 8, 'STR 18/INT 11/WIS 11/DEX 20/CON 14/CHA
277
27813');
279insert into encounters values('daveh@hotmail.com', 'STR 18/INT 15/WIS 18/DEX 11/CON 16/CHA 13', 'Sir Awesome', 9, 'STR 14/INT 18/WIS 18/DEX 14/CON 11/CHA
280
28113');
282-- Eva
283insert into encounters values('eva_wings@gmail.com', 'STR 11/INT 18/WIS 18/DEX 15/CON 11/CHA 15', 'Skye', 1, 'STR 18/INT 11/WIS 11/DEX 20/CON 14/CHA 13');
284insert into encounters values('eva_wings@gmail.com', 'STR 11/INT 18/WIS 18/DEX 15/CON 11/CHA 15', 'Skye', 2, 'STR 18/INT 11/WIS 11/DEX 20/CON 14/CHA 13');
285insert into encounters values('eva_wings@gmail.com', 'STR 11/INT 18/WIS 18/DEX 15/CON 11/CHA 15', 'Skye', 3, 'STR 18/INT 11/WIS 11/DEX 20/CON 14/CHA 13');
286insert into encounters values('eva_wings@gmail.com', 'STR 11/INT 18/WIS 18/DEX 15/CON 11/CHA 15', 'Skye', 4, 'STR 18/INT 11/WIS 11/DEX 20/CON 14/CHA 13');
287insert into encounters values('eva_wings@gmail.com', 'STR 11/INT 18/WIS 18/DEX 15/CON 11/CHA 15', 'Skye', 5, 'STR 18/INT 11/WIS 11/DEX 20/CON 14/CHA 13');
288insert into encounters values('eva_wings@gmail.com', 'STR 11/INT 18/WIS 18/DEX 15/CON 11/CHA 15', 'Skye', 6, 'STR 18/INT 11/WIS 11/DEX 20/CON 14/CHA 13');
289insert into encounters values('eva_wings@gmail.com', 'STR 11/INT 18/WIS 18/DEX 15/CON 11/CHA 15', 'Skye', 7, 'STR 18/INT 11/WIS 11/DEX 20/CON 14/CHA 13');
290insert into encounters values('eva_wings@gmail.com', 'STR 11/INT 18/WIS 18/DEX 15/CON 11/CHA 15', 'Skye', 8, 'STR 18/INT 11/WIS 11/DEX 20/CON 14/CHA 13');
291insert into encounters values('eva_wings@gmail.com', 'STR 11/INT 18/WIS 18/DEX 15/CON 11/CHA 15', 'Skye', 9, 'STR 14/INT 18/WIS 18/DEX 14/CON 11/CHA 13');
292
293-- creating the table called participates_in (N:N relationship, party characters participating in dungeons)
294create table participates_in (
295 email varchar(30) NOT NULL,
296 characteristics varchar(50) NOT NULL,
297 cname varchar(30) NOT NULL,
298 dname varchar(30) NOT NULL,
299 primary key (email, characteristics, cname, dname),
300 foreign key (email) references party_character (email),
301 foreign key (characteristics) references party_character (characteristics),
302 foreign key (cname) references party_character (name),
303 foreign key (dname) references dungeon (name)
304 );
305
306-- inserting into table participates_in
307insert into participates_in('gbooth@hotmail.com', 'STR 11/INT 18/WIS 18/DEX 20/CON 11/CHA 13', 'Vi Sovari', 'Bandit Caves');
308insert into participates_in('gbooth@hotmail.com', 'STR 11/INT 18/WIS 18/DEX 20/CON 11/CHA 13', 'Vi Sovari', 'Evil Castle');