CREATE database abook1;
USE abook1;

CREATE TABLE addresses1
(
	firstname VARCHAR(20),
	lastname VARCHAR(40),
	email VARCHAR(40)
);

INSERT INTO addresses1 VALUES ('Hans', 'Meier', 'meier@somewhere.com');
INSERT INTO addresses1 VALUES ('Peter', 'Mueller', 'mueller@somewhere.com');
INSERT INTO addresses1 VALUES ('Stefan', 'Huber', 'huber@somewhere.com');


GRANT ALL ON abook1.* TO markus@localhost IDENTIFIED by 'eagle';

CREATE database abook2;
USE abook2;

CREATE TABLE addresses2
(
	name VARCHAR(20),
	street VARCHAR(40),
	city VARCHAR(40),
	zipcode VARCHAR(10),
	country VARCHAR(30)
);

INSERT INTO addresses2 VALUES ('John Miller', 'treestreet 1', 'Big-City', '11111', 'USA');
INSERT INTO addresses2 VALUES ('Robert Smith', 'birdstreet 2', 'Small-City', '22222', 'New Zealand');
INSERT INTO addresses2 VALUES ('Jim Johnson', 'mammalstreet 3', 'Medium-Citry', '33333', 'Australia');

GRANT ALL ON abook2.* TO markus@localhost IDENTIFIED by 'eagle';
