BEGIN;

DROP TABLE Salaries;

CREATE TABLE Salaries 
  (id SERIAL UNIQUE NOT NULL,
   name TEXT UNIQUE NOT NULL,
   salary INTEGER NOT NULL);

INSERT INTO Salaries (name, salary) VALUES ('John', 3000);
INSERT INTO Salaries (name, salary) VALUES ('Sandy', 2000);
INSERT INTO Salaries (name, salary) VALUES ('Patty', 2200);
INSERT INTO Salaries (name, salary) VALUES ('Robert', 7000);
INSERT INTO Salaries (name, salary) VALUES ('Lou', 2600);
INSERT INTO Salaries (name, salary) VALUES ('Jack', 3400);
INSERT INTO Salaries (name, salary) VALUES ('Peter', 3400);
INSERT INTO Salaries (name, salary) VALUES ('Chris', 2900);
INSERT INTO Salaries (name, salary) VALUES ('Bob', 2800);
INSERT INTO Salaries (name, salary) VALUES ('Sandra', 2500);
INSERT INTO Salaries (name, salary) VALUES ('Chuck', 3800);
INSERT INTO Salaries (name, salary) VALUES ('Bill', 2900);
INSERT INTO Salaries (name, salary) VALUES ('Alfonso', 2300);
INSERT INTO Salaries (name, salary) VALUES ('Mike', 2700);
INSERT INTO Salaries (name, salary) VALUES ('Patt', 9600);
INSERT INTO Salaries (name, salary) VALUES ('Steve', 4000);
INSERT INTO Salaries (name, salary) VALUES ('Rose', 2300);
INSERT INTO Salaries (name, salary) VALUES ('Patrick', 2100);

COMMIT;
