Prev | Current Page 49 | Next

David Berube

"Practical Reporting with Ruby and Rails"

Player Schema Mark III (player_schema_3.sql)
CREATE DATABASE players_3;
USE players_3;
CREATE TABLE players (
id int(11) NOT NULL AUTO_INCREMENT,
name TEXT,
drink TEXT,
salary DECIMAL(9,2),
CHAPTER 2 n CALCULATING STATISTICS WITH ACTIVE RECORD 22
PRIMARY KEY (id)
);
INSERT INTO players (id, name, drink, salary) VALUES
(1, "Matthew 'm_giff' Gifford", "Moxie", 89000.00);
INSERT INTO players (id, name, drink, salary) VALUES
(2, "Matthew 'Iron Helix' Bouley", "Moxie", 75000.00);
INSERT INTO players (id, name, drink, salary) VALUES
(3, "Luke 'Cable Boy' Bouley", "Moxie", 75000.50);
INSERT INTO players (id, name, drink, salary) VALUES
(4, "Andrew 'steven-tyler-xavier' Thomas", 'Fresca', 75000.50);
INSERT INTO players (id, name, drink, salary) VALUES
(5, "John 'dwy_dwy' Dwyer", 'Fresca', 76000.75);
INSERT INTO players (id, name, drink, salary) VALUES
(6, "Ryan 'the_dominator' Peacan", 'Fresca', 75000.50);
INSERT INTO players (id, name, drink, salary) VALUES
(7, "Michael 'Shaun Wiki' Southwick", 'Fresca', 75000.


Pages:
37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61