USE Prokat_car;
SET CHARACTER SET cp1251;
DELETE FROM Car;
INSERT INTO Car VALUES (1, 'Toyota', 'Corona', 'sedan', 1993);
INSERT INTO Car VALUES (2, 'Toyota', 'Corolla', 'sedan', 2004);
INSERT INTO Car VALUES (3, 'Mercedes-Benz', 'ML320', 'suv', 2000);
INSERT INTO Car VALUES (4, 'Nissan', 'Laurel', 'sedan', 1997);
INSERT INTO Car VALUES (5, 'Mazda', 'Familia S', 'wagon', 2002);
DELETE FROM Client;
INSERT INTO Client VALUES (1, 'Lavrinov I.', '10Amurskaya-10', 416318, 1);
INSERT INTO Client VALUES (2, 'Petrin S.', 'Tupoleva-154', 131228, 5);
INSERT INTO Client VALUES (3, 'Alekseenko A.', 'Naberegnaya-9', 666666, 2);
INSERT INTO Client VALUES (4, 'Pisyaev Vasya', 'Tovstuho-69', 9379992, 1);
INSERT INTO Client VALUES (5, 'Norris Chuck', '120 South LA Street', 6291200, 15);
DELETE FROM Discount;
INSERT INTO Discount VALUES (1, 1, 0);
INSERT INTO Discount VALUES (2, 3, 2);
INSERT INTO Discount VALUES (3, 5, 5);
INSERT INTO Discount VALUES (4, 7, 8);
INSERT INTO Discount VALUES (5, 10, 15);
DELETE FROM Forfeit;
INSERT INTO Forfeit VALUES (1, 'No', 0);
INSERT INTO Forfeit VALUES (2, 'Prosrochka', 1000);
INSERT INTO Forfeit VALUES (3, 'Polomka', 3000);
DELETE FROM Deal;
INSERT INTO Deal VALUES (1, 1, 4, 1, 1 , '2011-01-15', '2011-02-15', 20000.00);
INSERT INTO Deal VALUES (2, 2, 2, 3, 1, '2011-06-01', '2011-08-01', 50000.00);
INSERT INTO Deal VALUES (3, 3, 1, 1, 1, '2011-06-04', '0000-00-00', 100000.00);
INSERT INTO Deal VALUES (4, 4, 5, 4, 1, '2011-05-01', '2011-05-03', 3500.00);
INSERT INTO Deal VALUES (5, 5, 3, 5, 1, '2010-01-01', '2010-12-31', 800000.00);

SELECT * FROM Car;
SELECT * FROM Client;
SELECT * FROM Discount;
SELECT * FROM Forfeit;
SELECT * FROM Deal;