API tools faq
paste
Advertisement
sunilaleti

Untitled

sunilaleti
Apr 19th, 2022
1,438
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 8.33 KB | None | 0 0
raw download clone embed print report
  1. CREATE DATABASE CARRENTAL;
  2. ​
  3. USE CARRENTAL;
  4. ​
  5. CREATE TABLE CUSTOMER(
  6. CustID int AUTO_INCREMENT PRIMARY KEY,
  7. Name varchar(50),
  8. Phone varchar(15)
  9. );
  10. ​
  11. CREATE TABLE RATE(
  12. Type ENUM("1","2","3","4","5","6") NOT NULL,
  13. Category ENUM("0","1") NOT NULL,
  14. Weekly double NOT NULL,
  15. Daily double NOT NULL
  16. );
  17. ​
  18. CREATE TABLE VEHICLE(
  19. VehicleID varchar(50) PRIMARY KEY,
  20. Description varchar(100),
  21. Year YEAR,
  22. Type ENUM("1","2","3","4","5","6") NOT NULL ,
  23. Category ENUM("0","1") NOT NULL
  24. );
  25. ​
  26. CREATE TABLE RENTAL(
  27. CustID int not null,
  28. VehicleID varchar(25) not null,
  29. StartDate DATE not null,
  30. OrderDate DATE not null,
  31. RentalType int,
  32. Qty int not null,
  33. ReturnDate DATE,
  34. TotalAmount DOUBLE,
  35. PaymentDate DATE
  36. );
  37. ​
  38. INSERT INTO CUSTOMER
  39.   (`Name`, `Phone`)
  40. VALUES
  41.   ('A. Parks', '(214) 555-0127'),
  42.   ('S. Patel', '(849) 811-6298'),
  43.   ('A. Hernandez', '(355) 572-5385'),
  44.   ('G. Carver', '(753) 763-8656'),
  45.   ('Sh. Byers', '(912) 925-5332'),
  46.   ('L. Lutz', '(931) 966-1775'),
  47.   ('L. Bernal', '(884) 727-0591'),
  48.   ('I. Whyte', '(811) 979-7345'),
  49.   ('L. Lott', '(954) 706-2219'),
  50.   ('G. Clarkson', '(309) 625-1838'),
  51.   ('Sh. Dunlap', '(604) 581-6642'),
  52.   ('H. Gallegos', '(961) 265-8638'),
  53.   ('L. Perkins', '(317) 996-3104'),
  54.   ('M. Beach', '(481) 422-0282'),
  55.   ('C. Pearce', '(599) 881-5189'),
  56.   ('A. Hess', '(516) 570-6411'),
  57.   ('M. Lee', '(369) 898-6162'),
  58.   ('R. Booker', '(730) 784-6303'),
  59.   ('A. Crowther', '(325) 783-4081'),
  60.   ('H. Mahoney', '(212) 262-8829'),
  61.   ('J. Brown', '(644) 756-0110'),
  62.   ('H. Stokes', '(931) 969-7317'),
  63.   ('J. Reeves', '(940) 981-5113'),
  64.   ('A. Mcghee', '(838) 610-5802'),
  65.   ('L. Mullen', '(798) 331-7777'),
  66.   ('R. Armstrong', '(325) 783-4081'),
  67.   ('J. Greenaway', '(212) 262-8829'),
  68.   ('K. Kaiser Acosta', '(228) 576-1557'),
  69.   ('D. Kirkpatrick', '(773) 696-8009'),
  70.   ('A. Odonnell', '(439) 536-8929'),
  71.   ('K. Kay', '(368) 336-5403');
  72. ​
  73. ​
  74. ​
  75. INSERT INTO RATE
  76.   (`Type`, `Category`, `Weekly`, `Daily`)
  77. VALUES
  78.   ('1', '0', '480', '80'),
  79.   ('1', '1', '600', '100'),
  80.   ('2', '0', '530', '90'),
  81.   ('2', '1', '660', '110'),
  82.   ('3', '0', '600', '100'),
  83.   ('3', '1', '710', '120'),
  84.   ('4', '0', '685', '115'),
  85.   ('4', '1', '800', '135'),
  86.   ('5', '0', '780', '130'),
  87.   ('6', '0', '685', '115');
  88.  
  89.  
  90. ​
  91. INSERT INTO RENTAL
  92.   (`CustID`, `VehicleID`, `StartDate`, `OrderDate`, `RentalType`, `Qty`, `ReturnDate`, `TotalAmount`, `PaymentDate`)
  93. VALUES
  94.   ('203', 'JM3KE4DY4F0441471', '2019-09-09', '2019-05-22', '1', '4', '2019-09-13', '460', '2019-09-09'),
  95.   ('210', '19VDE1F3XEE414842', '2019-11-01', '2019-10-28', '7', '2', '2019-11-15', '1200', NULL),
  96.   ('210', 'JTHFF2C26F135BX45', '2019-05-01', '2019-04-15', '7', '1', '2019-05-08', '600', '2019-05-08'),
  97.   ('210', 'JTHFF2C26F135BX45', '2019-11-01', '2019-10-28', '7', '2', '2019-11-15', '1200', NULL),
  98.   ('210', 'WAUTFAFH0E0010613', '2019-11-01', '2019-10-28', '7', '2', '2019-11-15', '1200', NULL),
  99.   ('210', 'WBA3A9G51ENN73366', '2019-11-01', '2019-10-28', '7', '2', '2019-11-15', '1200', NULL),
  100.   ('210', 'WBA3B9C59EP458859', '2019-11-01', '2019-10-28', '7', '2', '2019-11-15', '1200', NULL),
  101.   ('210', 'WDCGG0EB0EG188709', '2019-11-01', '2019-10-28', '7', '2', '2019-11-15', '1200', NULL),
  102.   ('212', '19VDE1F3XEE414842', '2019-06-10', '2019-04-15', '7', '3', '2019-07-01', '1800', '2019-06-10'),
  103.   ('216', '1N6BF0KM0EN101134', '2019-08-02', '2019-03-15', '7', '4', '2019-08-30', '2740', '2019-08-02'),
  104.   ('216', '1N6BF0KM0EN101134', '2019-08-30', '2019-03-15', '1', '2', '2019-09-01', '230', '2019-08-02'),
  105.   ('221', '19VDE1F3XEE414842', '2019-07-01', '2019-06-12', '7', '1', '2019-07-08', '600', '2019-07-01'),
  106.   ('221', '19VDE1F3XEE414842', '2019-07-09', '2019-06-12', '1', '2', '2019-07-11', '200', '2019-07-01'),
  107.   ('221', '19VDE1F3XEE414842', '2020-01-01', '2019-12-15', '7', '4', '2020-01-29', '2400', NULL),
  108.   ('221', 'JTHFF2C26F135BX45', '2020-01-01', '2019-12-15', '7', '4', '2020-01-29', '2400', NULL),
  109.   ('221', 'WAUTFAFH0E0010613', '2019-07-01', '2019-06-12', '7', '1', '2019-07-08', '600', '2019-07-01'),
  110.   ('221', 'WAUTFAFH0E0010613', '2019-07-09', '2019-06-12', '1', '2', '2019-07-11', '200', '2019-07-01'),
  111.   ('221', 'WAUTFAFH0E0010613', '2020-01-01', '2019-12-15', '7', '4', '2020-01-29', '2400', NULL),
  112.   ('221', 'WBA3A9G51ENN73366', '2020-01-01', '2019-12-15', '7', '4', '2020-01-29', '2400', NULL),
  113.   ('221', 'WBA3B9C59EP458859', '2020-01-01', '2019-12-15', '7', '4', '2020-01-29', '2400', NULL),
  114.   ('221', 'WDCGG0EB0EG188709', '2020-01-01', '2019-12-15', '7', '4', '2020-01-29', '2400', NULL),
  115.   ('229', '19VDE1F3XEE414842', '2019-05-06', '2019-04-12', '1', '4', '2019-05-10', '400', '2019-05-06'),
  116.   ('229', 'WAUTFAFH0E0010613', '2019-05-06', '2019-04-12', '1', '4', '2019-05-10', '400', '2019-05-06');
  117. ​
  118. ​
  119. ​
  120. INSERT INTO VEHICLE
  121.   (`VehicleID`, `Description`, `Year`, `Type`, `Category`)
  122. VALUES
  123.   ('19VDE1F3XEE414842', 'Acura ILX', '2014', '1', '1'),
  124.   ('1FDEE3FL6EDA29122', 'Ford E 350', '2014', '6', '0'),
  125.   ('1FDRF3B61FEA87469', 'Ford Super Duty Pickup', '2015', '5', '0'),
  126.   ('1FTNF1CF2EKE54305', 'Ford F Series Pickup', '2014', '5', '0'),
  127.   ('1G1JD5SB3E4240835', 'Chevrolet Optra', '2014', '1', '0'),
  128.   ('1GB3KZCG1EF117132', 'Chevrolet Silverado', '2014', '5', '0'),
  129.   ('1HGCR2E3XEA305302', 'Honda Accord', '2014', '2', '0'),
  130.   ('1N4AB7AP2EN855026', 'Nissan Sentra', '2014', '1', '0'),
  131.   ('1N6BA0EJ9EN516565', 'Nissan Titan', '2014', '5', '0'),
  132.   ('1N6BF0KM0EN101134', 'Nissan NV', '2014', '6', '0'),
  133.   ('1VWCH7A3XEC037969', 'Volkswagen Passat', '2014', '2', '1'),
  134.   ('2HGFB2F94FH501940', 'Honda Civic', '2015', '1', '0'),
  135.   ('2T3DFREV0FW317743', 'Toyota RAV4', '2015', '4', '0'),
  136.   ('3MZBM1L74EM109736', 'Mazda 3', '2014', '1', '0'),
  137.   ('3N1CE2CP0FL409472', 'Nissan Versa Note', '2015', '1', '0'),
  138.   ('3N1CN7APXEK444458', 'Nissan Versa', '2014', '1', '0'),
  139.   ('3VW2A7AU1FM012211', 'Volkswagen Golf', '2015', '1', '0'),
  140.   ('4S4BRCFC1E3203823', 'Subaru Outback', '2014', '4', '0'),
  141.   ('4S4BSBF39F3261064', 'Subaru Outback', '2015', '4', '0'),
  142.   ('4S4BSELC0F3325370', 'Subaru Outback', '2015', '4', '0'),
  143.   ('5J6RM4H90FL028629', 'Honda CR-V', '2015', '4', '0'),
  144.   ('5N1AL0MM8EL549388', 'Infiniti JX35', '2014', '4', '1'),
  145.   ('5NPDH4AE2FH565275', 'Hyundai Elantra', '2015', '1', '0'),
  146.   ('5TDBKRFH4ES26D590', 'Toyota Highlander', '2014', '4', '0'),
  147.   ('5XYKT4A75FG610224', 'Kia Sorento', '2015', '4', '0'),
  148.   ('5XYKU4A7XFG622415', 'Kia Sorento', '2015', '4', '0'),
  149.   ('5XYKUDA77EG449709', 'Kia Sorento', '2014', '4', '0'),
  150.   ('JF1GPAA61F8314971', 'Subaru Impreza', '2015', '1', '0'),
  151.   ('JH4KC1F50EC800004', 'Acura RLX', '2014', '3', '1'),
  152.   ('JH4KC1F56EC000095', 'Acura RLX', '2014', '3', '1'),
  153.   ('JM1BM1V35E1210570', 'Mazda 3', '2014', '1', '0'),
  154.   ('JM3KE4DY4F0441471', 'Mazda CX5', '2015', '4', '0'),
  155.   ('JM3TB3DV0E0015742', 'Mazda CX9', '2014', '4', '0'),
  156.   ('JN8AS5MV0FW760408', 'Nissan Rogue Select', '2015', '4', '0'),
  157.   ('JTEZUEJR7E5081641', 'Toyota 4Runner', '2014', '4', '0'),
  158.   ('JTHBW1GG1F120DU53', 'Lexus ES 300h', '2015', '2', '1'),
  159.   ('JTHCE1BL3F151DE04', 'Lexus GS 350', '2015', '2', '1'),
  160.   ('JTHDL5EF9F5007221', 'Lexus LS 460', '2015', '3', '1'),
  161.   ('JTHFF2C26F135BX45', 'Lexus IS 250C', '2015', '1', '1'),
  162.   ('JTJHY7AX2F120EA11', 'Lexus LX 570', '2015', '4', '1'),
  163.   ('JTJJM7FX2E152CD75', 'Lexus GX460', '2014', '4', '1'),
  164.   ('JTMBFREV1FJ019885', 'Toyota RAV4', '2015', '4', '0'),
  165.   ('KM8SN4HF0FU107203', 'Hyundai Santa Fe', '2015', '4', '0'),
  166.   ('KMHJT3AF1FU028211', 'Hyundai Tucson', '2015', '4', '0'),
  167.   ('KMHTC6AD8EU998631', 'Hyundai Veloster', '2014', '1', '0'),
  168.   ('KNAFZ4A86E5195865', 'KIA Sportage', '2014', '4', '0'),
  169.   ('KNAFZ4A86E5195895', 'KIA Forte', '2014', '1', '0'),
  170.   ('KNAGN4AD2F5084324', 'Kia Optima Hybrid', '2015', '2', '0'),
  171.   ('KNALN4D75E5A57351', 'Kia Cadenza', '2014', '3', '0'),
  172.   ('KNALU4D42F6025717', 'Kia K900', '2015', '3', '0'),
  173.   ('KNDPCCA65F7791085', 'KIA Sportage', '2015', '4', '0'),
  174.   ('WA1LGAFE8ED001506', 'Audi Q7', '2014', '4', '1'),
  175.   ('WAU32AFD8FN005740', 'Audi A8', '2015', '3', '1'),
  176.   ('WAUTFAFH0E0010613', 'Audi A5', '2014', '1', '1'),
  177.   ('WBA3A9G51ENN73366', 'BMW 3 Series', '2014', '1', '1'),
  178.   ('WBA3B9C59EP458859', 'BMW 3 Series', '2014', '1', '1'),
  179.   ('WBAVL1C57EVR93286', 'BMW X1', '2014', '4', '1'),
  180.   ('WDCGG0EB0EG188709', 'Mercedes_Benz GLK', '2014', '1', '1'),
  181.   ('YV440MDD6F2617077', 'Volvo XC60', '2015', '4', '1'),
  182.   ('YV4940NB5F1191453', 'Volvo XC70', '2015', '4', '1');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!