50);
CREATE TABLE games (
id int(11) NOT NULL AUTO_INCREMENT,
name TEXT,
PRIMARY KEY (id)
);
INSERT INTO games (id, name) VALUES (1, 'Bubble Recycler');
INSERT INTO games (id, name) VALUES (2, 'Computer Repair King');
INSERT INTO games (id, name) VALUES (3, 'Super Dunkball II: The Return');
INSERT INTO games (id, name) VALUES (4, 'Sudden Deceleration: No Time to Think');
CREATE TABLE wins (
id int(11) NOT NULL AUTO_INCREMENT,
player_id int(11) NOT NULL,
game_id int(11) NOT NULL,
quantity int(11) NOT NULL,
PRIMARY KEY (id)
);
INSERT INTO wins (player_id, game_id, quantity) VALUES (1, 1, 3);
INSERT INTO wins (player_id, game_id, quantity) VALUES (1, 3, 8);
INSERT INTO wins (player_id, game_id, quantity) VALUES (1, 2, 3);
INSERT INTO wins (player_id, game_id, quantity) VALUES (1, 4, 9);
CHAPTER 2 n CALCULATING STATISTICS WITH ACTIVE RECORD 23
INSERT INTO wins (player_id, game_id, quantity) VALUES (2, 1, 8);
INSERT INTO wins (player_id, game_id, quantity) VALUES (2, 3, 10);
INSERT INTO wins (player_id, game_id, quantity) VALUES (2, 2, 7);
INSERT INTO wins (player_id, game_id, quantity) VALUES (2, 4, 5);
INSERT INTO wins (player_id, game_id, quantity) VALUES (3, 1, 8);
INSERT INTO wins (player_id, game_id, quantity) VALUES (3, 3, 4);
INSERT INTO wins (player_id, game_id, quantity) VALUES (3, 2, 20);
INSERT INTO wins (player_id, game_id, quantity) VALUES (3, 4, 8);
INSERT INTO wins (player_id, game_id, quantity) VALUES (4, 1, 8);
INSERT INTO wins (player_id, game_id, quantity) VALUES (4, 3, 9);
INSERT INTO wins (player_id, game_id, quantity) VALUES (4, 2, 8);
INSERT INTO wins (player_id, game_id, quantity) VALUES (4, 4, 3);
INSERT INTO wins (player_id, game_id, quantity) VALUES (5, 1, 7);
INSERT INTO wins (player_id, game_id, quantity) VALUES (5, 3, 1);
INSERT INTO wins (player_id, game_id, quantity) VALUES (5, 2, 9);
INSERT INTO wins (player_id, game_id, quantity) VALUES (5, 4, 4);
INSERT INTO wins (player_id, game_id, quantity) VALUES (6, 1, 2);
INSERT INTO wins (player_id, game_id, quantity) VALUES (6, 3, 12);
INSERT INTO wins (player_id, game_id, quantity) VALUES (6, 2, 8);
INSERT INTO wins (player_id, game_id, quantity) VALUES (6, 4, 9);
INSERT INTO wins (player_id, game_id, quantity) VALUES (7, 1, 2);
INSERT INTO wins (player_id, game_id, quantity) VALUES (7, 3, 1);
INSERT INTO wins (player_id, game_id, quantity) VALUES (7, 2, 4);
INSERT INTO wins (player_id, game_id, quantity) VALUES (7, 4, 9);
Save this file as player_schema_3.
Pages:
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62