create database epood_Rosman;
use epood_Rosman;
create table kliendiAuto (
id INT PRIMARY KEY,
first_name VARCHAR(50),
last_name VARCHAR(50),
email VARCHAR(50),
car_make VARCHAR(50),
car_model VARCHAR(50),
car_year int,
car_price DECIMAL(10,2)
);
create table remonditoo (
remont_id INT PRIMARY KEY,
description VARCHAR(50),
partner VARCHAR(50),
price DECIMAL(6,2),
material VARCHAR(50),
kliendiID INT, -- foreign key
FOREIGN KEY (kliendiID) REFERENCES kliendiAuto(id)
);
Random data
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (1, 'Minnie', 'Colqueran', 'mcolqueran0@lulu.com', 'Buick', 'Coachbuilder', 1990, 425.9);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (2, 'Perkin', 'Danev', 'pdanev1@so-net.ne.jp', 'Dodge', 'Charger', 2008, 26.69);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (3, 'Bari', 'Bonfield', 'bbonfield2@google.com.au', 'Volkswagen', 'Fox', 1993, 160.2);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (4, 'Dulce', 'Dirkin', 'ddirkin3@virginia.edu', 'Pontiac', 'Grand Prix', 1978, 88.83);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (5, 'Fan', 'Dyett', 'fdyett4@bizjournals.com', 'Toyota', 'T100', 1994, 142.27);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (6, 'Jessamyn', 'Gerrit', 'jgerrit5@youtu.be', 'Ford', 'Taurus', 1996, 47.61);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (7, 'Shauna', 'Cherry Holme', 'scherryholme6@stanford.edu', 'Mazda', 'MX-5', 1999, 475.31);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (8, 'Alfreda', 'Duigan', 'aduigan7@loc.gov', 'Jeep', 'Liberty', 2007, 31.59);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (9, 'Ben', 'Bracknall', 'bbracknall8@bizjournals.com', 'Mercedes-Benz', 'SL-Class', 2011, 101.28);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (10, 'Ferne', 'Sapena', 'fsapena9@chicagotribune.com', 'Ferrari', '599 GTB Fiorano', 2007, 133.17);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (11, 'Deloria', 'Masey', 'dmaseya@gizmodo.com', 'GMC', 'Envoy XL', 2004, 462.76);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (12, 'Rachele', 'Dassindale', 'rdassindaleb@networksolutions.com', 'Mercedes-Benz', 'CL-Class', 2002, 305.99);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (13, 'Maggee', 'Stonestreet', 'mstonestreetc@webs.com', 'Mazda', 'MX-5', 1993, 990.72);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (14, 'Matthieu', 'O''Monahan', 'momonahand@instagram.com', 'Nissan', 'Pathfinder', 2000, 338.69);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (15, 'Sheffield', 'McAuley', 'smcauleye@delicious.com', 'Honda', 'Civic', 2007, 198.31);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (16, 'Danny', 'Brooking', 'dbrookingf@redcross.org', 'Toyota', 'Sequoia', 2009, 776.58);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (17, 'Alanson', 'Heersema', 'aheersemag@chronoengine.com', 'Chevrolet', 'Cavalier', 2001, 377.75);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (18, 'Arda', 'Burgum', 'aburgumh@theglobeandmail.com', 'Chevrolet', 'Volt', 2012, 159.58);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (19, 'Spencer', 'Lilburne', 'slilburnei@latimes.com', 'Scion', 'tC', 2012, 733.1);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (20, 'Dino', 'Gamett', 'dgamettj@springer.com', 'Audi', '5000S', 1984, 638.48);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (21, 'Christian', 'Minet', 'cminetk@scientificamerican.com', 'Dodge', 'Intrepid', 1993, 551.49);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (22, 'Anders', 'Kynnd', 'akynndl@gnu.org', 'Suzuki', 'Aerio', 2003, 279.01);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (23, 'Caril', 'Templman', 'ctemplmanm@homestead.com', 'BMW', 'M5', 2000, 978.03);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (24, 'Henrie', 'Fisbburne', 'hfisbburnen@shop-pro.jp', 'Volkswagen', 'Passat', 2006, 690.69);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (25, 'Christen', 'Dolley', 'cdolleyo@dmoz.org', 'GMC', 'Safari', 2000, 645.81);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (26, 'Maurie', 'D''Avaux', 'mdavauxp@homestead.com', 'Dodge', 'D250', 1992, 973.77);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (27, 'Henrieta', 'Gleadhell', 'hgleadhellq@icq.com', 'Volkswagen', 'CC', 2013, 335.75);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (28, 'Mikey', 'Rival', 'mrivalr@soup.io', 'BMW', '3 Series', 1992, 172.35);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (29, 'Tabby', 'Johannes', 'tjohanness@bbc.co.uk', 'Ford', 'Escape', 2004, 602.84);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (30, 'Othilia', 'Trencher', 'otrenchert@newyorker.com', 'Chevrolet', 'Monte Carlo', 2003, 629.3);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (31, 'Fayth', 'Sonier', 'fsonieru@nih.gov', 'GMC', 'Yukon XL 1500', 2009, 934.27);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (32, 'Leslie', 'Coppock.', 'lcoppockv@acquirethisname.com', 'Mercedes-Benz', 'SLR McLaren', 2009, 201.04);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (33, 'Siobhan', 'Gyppes', 'sgyppesw@trellian.com', 'Lincoln', 'Navigator', 2004, 799.98);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (34, 'Mateo', 'Alven', 'malvenx@soup.io', 'Nissan', 'Frontier', 2003, 178.02);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (35, 'Kristoffer', 'Kencott', 'kkencotty@loc.gov', 'Cadillac', 'Escalade ESV', 2003, 369.28);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (36, 'Teressa', 'Branche', 'tbranchez@1und1.de', 'GMC', 'Savana 1500', 1998, 688.83);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (37, 'Marcelle', 'Clarey', 'mclarey10@amazon.co.uk', 'Mercury', 'Cougar', 1967, 803.6);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (38, 'Viviene', 'Soall', 'vsoall11@diigo.com', 'Lamborghini', 'Diablo', 1995, 418.11);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (39, 'Dell', 'Lutzmann', 'dlutzmann12@hibu.com', 'Ford', 'Escort', 1986, 940.98);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (40, 'Benetta', 'Hadfield', 'bhadfield13@plala.or.jp', 'Volkswagen', 'GLI', 2009, 266.55);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (41, 'Rebbecca', 'Jirka', 'rjirka14@hostgator.com', 'Volkswagen', 'Jetta', 1988, 556.65);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (42, 'Bent', 'Jatczak', 'bjatczak15@cpanel.net', 'Chevrolet', 'Avalanche 1500', 2002, 806.09);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (43, 'Nydia', 'Ioannidis', 'nioannidis16@miitbeian.gov.cn', 'GMC', 'Acadia', 2009, 243.54);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (44, 'Evyn', 'Kemmish', 'ekemmish17@ted.com', 'Hyundai', 'Genesis Coupe', 2013, 851.94);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (45, 'Whitaker', 'Quarry', 'wquarry18@yolasite.com', 'Mitsubishi', 'GTO', 1990, 482.87);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (46, 'Fairfax', 'Whitchurch', 'fwhitchurch19@comcast.net', 'Volvo', 'V70', 2008, 80.9);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (47, 'Gordie', 'Feron', 'gferon1a@weebly.com', 'Ford', 'E-Series', 2009, 463.74);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (48, 'Wynn', 'Fruser', 'wfruser1b@typepad.com', 'Jeep', 'Grand Cherokee', 1993, 861.24);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (49, 'Wanids', 'Dooley', 'wdooley1c@columbia.edu', 'Mercury', 'Mariner', 2009, 604.06);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (50, 'Roxi', 'Stonuary', 'rstonuary1d@a8.net', 'Mercedes-Benz', 'C-Class', 1999, 838.09);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (51, 'Maura', 'Sneller', 'msneller1e@hhs.gov', 'Isuzu', 'Rodeo Sport', 2002, 888.9);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (52, 'Merrie', 'Pizzie', 'mpizzie1f@independent.co.uk', 'Pontiac', 'Firebird', 1991, 592.96);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (53, 'Melinde', 'Kilfeather', 'mkilfeather1g@nationalgeographic.com', 'Ford', 'Torino', 1970, 586.08);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (54, 'Ignatius', 'Gabrieli', 'igabrieli1h@merriam-webster.com', 'Ford', 'F350', 2008, 194.75);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (55, 'Haily', 'Zecchii', 'hzecchii1i@dropbox.com', 'Mercedes-Benz', 'C-Class', 2003, 17.09);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (56, 'Atlante', 'Ratazzi', 'aratazzi1j@imageshack.us', 'Volkswagen', 'Passat', 1985, 376.71);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (57, 'Jozef', 'Hayhow', 'jhayhow1k@prlog.org', 'Mitsubishi', 'Galant', 2011, 634.15);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (58, 'Reagen', 'Rentalll', 'rrentalll1l@ted.com', 'Ford', 'E350', 2012, 21.26);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (59, 'Rex', 'Packer', 'rpacker1m@exblog.jp', 'Cadillac', 'Fleetwood', 1954, 371.65);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (60, 'Kristian', 'Evill', 'kevill1n@bloglines.com', 'Lexus', 'ES', 1995, 652.43);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (61, 'Hulda', 'Cockcroft', 'hcockcroft1o@chron.com', 'Volkswagen', 'Fox', 1991, 697.72);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (62, 'Cirstoforo', 'Garnsey', 'cgarnsey1p@youtube.com', 'Ford', 'Mustang', 2011, 611.32);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (63, 'Paco', 'Bogays', 'pbogays1q@hexun.com', 'Toyota', 'Supra', 1997, 27.04);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (64, 'Adora', 'Grzegorczyk', 'agrzegorczyk1r@wikispaces.com', 'Mitsubishi', 'L300', 1989, 805.6);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (65, 'Paton', 'Pele', 'ppele1s@ebay.co.uk', 'Buick', 'LeSabre', 1992, 195.47);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (66, 'Andi', 'Heare', 'aheare1t@hibu.com', 'Mercedes-Benz', 'M-Class', 2009, 188.41);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (67, 'Tracie', 'Burborough', 'tburborough1u@ed.gov', 'Toyota', 'RAV4', 1997, 127.3);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (68, 'Ertha', 'Clague', 'eclague1v@tuttocitta.it', 'Volvo', 'C70', 2002, 860.25);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (69, 'Issy', 'Chiplen', 'ichiplen1w@slate.com', 'Nissan', 'Pathfinder', 1996, 525.19);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (70, 'Rad', 'Maughan', 'rmaughan1x@washingtonpost.com', 'Pontiac', 'Grand Prix', 1964, 241.22);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (71, 'Maura', 'Drage', 'mdrage1y@yelp.com', 'Volkswagen', 'Eurovan', 2003, 158.78);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (72, 'Joye', 'Dronsfield', 'jdronsfield1z@twitter.com', 'Lexus', 'RX', 2010, 98.97);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (73, 'Mame', 'Woodley', 'mwoodley20@sourceforge.net', 'Ford', 'Thunderbird', 2004, 339.88);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (74, 'Pryce', 'Tremontana', 'ptremontana21@stanford.edu', 'Mitsubishi', 'Mighty Max Macro', 1993, 833.03);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (75, 'Zsa zsa', 'Bruyett', 'zbruyett22@hc360.com', 'Mazda', 'B-Series', 2004, 822.56);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (76, 'Erik', 'McCrorie', 'emccrorie23@naver.com', 'Ferrari', '612 Scaglietti', 2007, 559.26);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (77, 'Wilden', 'Mulmuray', 'wmulmuray24@dagondesign.com', 'Mazda', 'CX-9', 2012, 19.55);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (78, 'Chase', 'Conelly', 'cconelly25@cyberchimps.com', 'Infiniti', 'G', 2004, 804.7);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (79, 'Humfrey', 'Nattrass', 'hnattrass26@furl.net', 'Ford', 'Taurus', 2002, 365.14);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (80, 'Robers', 'Duchasteau', 'rduchasteau27@weibo.com', 'Toyota', 'Prius', 2004, 105.66);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (81, 'Juliet', 'Tadlow', 'jtadlow28@infoseek.co.jp', 'GMC', 'Savana', 2007, 906.24);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (82, 'Adriena', 'Vevers', 'avevers29@yellowbook.com', 'Mitsubishi', 'Lancer', 2005, 267.53);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (83, 'Clotilda', 'Frays', 'cfrays2a@hc360.com', 'Mercury', 'Sable', 1991, 888.65);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (84, 'Ugo', 'Brahms', 'ubrahms2b@theatlantic.com', 'Acura', 'ZDX', 2011, 145.27);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (85, 'Bondon', 'Crosi', 'bcrosi2c@seattletimes.com', 'Lincoln', 'Continental', 1991, 533.48);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (86, 'Dinnie', 'Coldicott', 'dcoldicott2d@youtube.com', 'Kia', 'Rondo', 2008, 627.82);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (87, 'Nisse', 'Foat', 'nfoat2e@apache.org', 'Volkswagen', 'Golf III', 1995, 807.7);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (88, 'Tobias', 'Coule', 'tcoule2f@yellowbook.com', 'Acura', 'Vigor', 1994, 969.7);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (89, 'Sheffy', 'Jordin', 'sjordin2g@chronoengine.com', 'Chrysler', 'New Yorker', 1995, 996.35);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (90, 'Chucho', 'Anan', 'canan2h@senate.gov', 'Ford', 'Escort', 1999, 97.51);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (91, 'Amalia', 'MacCosto', 'amaccosto2i@virginia.edu', 'Mitsubishi', 'Truck', 1996, 977.03);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (92, 'Jemie', 'Heephy', 'jheephy2j@youtube.com', 'Ford', 'Aspire', 1997, 513.85);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (93, 'Claudina', 'Diprose', 'cdiprose2k@bizjournals.com', 'Honda', 'Civic', 1990, 603.3);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (94, 'Dalton', 'Cotty', 'dcotty2l@jimdo.com', 'Mitsubishi', 'Lancer', 2009, 894.28);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (95, 'Arte', 'Lachaize', 'alachaize2m@uol.com.br', 'Audi', '90', 1988, 936.28);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (96, 'Reese', 'Lamberteschi', 'rlamberteschi2n@cnbc.com', 'Pontiac', 'G8', 2008, 637.3);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (97, 'Welch', 'Fink', 'wfink2o@upenn.edu', 'Volkswagen', 'Cabriolet', 1997, 580.63);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (98, 'Giffard', 'Atyeo', 'gatyeo2p@oaic.gov.au', 'Acura', 'TL', 2002, 755.61);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (99, 'Leandra', 'Blackall', 'lblackall2q@deliciousdays.com', 'Lincoln', 'Town Car', 2010, 870.42);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (100, 'Amaleta', 'Haggarth', 'ahaggarth2r@wp.com', 'Infiniti', 'M', 2011, 932.06);
--Lisa vähemalt 3 kliendi andmed, millest üks oled sina.
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (101, 'Martin', 'Rosman', 'soopka@gmail.com', 'Tesla', 'Model 5', 2023, 1234.04);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (102, 'Kaja', 'Kallas', 'premier@eesti.ee', 'Chrysler', 'New Yorker', 2015, 920.12);
insert into kliendiAuto (id, first_name, last_name, email, car_make, car_model, car_year, car_price) values (103, 'Sufjan', 'Stevens', 'sufjan@wp.com', 'Mercedes-Benz', 'C-Class', 2003, 420.00);
Direktor
Tee kasutaja nimega direktor, kes saab luua trigereid (vähemalt 2) ning jälgida nende töö (direktor näeb tabeli logi, aga ei saa logi tabelisse midagi lisada ning kustutada. Muud tabelid direktor ei näe).
Настройка прав
Проверка на возможность просмотра и добавления в таблицы remonditoo и kliendiAuto
Попытка добавление записи в таблицу logi
Создание триггеров
Создание тригера на добавление нового ремонта
Create table logi(id int identity(1,1) PRIMARY KEY,date DATETIME,action varchar(100),data text,remontID int,username varchar(100));
Создание тригера на обновление информации о ремонте
Создание процедур
Удаление данных из таблицы remonditoo по ID
Создадим переменную remontID типа INT. Будем удалять те записи из таблицы remonditoo, ID которых будет соответствовать значению remontID.
Процедура UPDATE для таблицы kliendiAuto
Сделаем процедуру, при помощи которой можно будет обновлять данные в таблице kliendiAuto. Нам потребуются три переменных — klientID типа INT, а так же uuseesnimi и uusperenimi типа VARCHAR и ограничением в 50 символов в соответствии с параметрами таблицы. Так же пропишем в процедуре Select * from kliendiAuto чтобы видеть результат сразу после выполнения.
