API tools faq
paste
Advertisement
drxe22

SQL Database

drxe22
Jan 11th, 2018
1,720
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 41.32 KB | None | 0 0
raw download clone embed print report
  1. USE master
  2.  
  3. --Delete database if it exists--
  4.  
  5. IF EXISTS(SELECT * FROM sys.DATABASES WHERE name='BikeRentalSystem')
  6. DROP DATABASE BikeRentalSystem
  7. GO
  8. CREATE DATABASE BikeRentalSystem
  9. GO
  10.  
  11. USE BikeRentalSystem
  12.  
  13.  
  14. --Delete tables if they exist--
  15.  
  16. IF EXISTS(SELECT * FROM sysobjects WHERE id = object_id('CreditDebitTrans'))
  17. DROP TABLE CreditDebitTrans
  18. GO
  19.  
  20. IF EXISTS(SELECT * FROM sysobjects WHERE id = object_id('Ride'))
  21. DROP TABLE Ride
  22. GO
  23.  
  24. IF EXISTS(SELECT * FROM sysobjects WHERE id = object_id('BikeReservation'))
  25. DROP TABLE BikeReservation
  26. GO
  27.  
  28. IF EXISTS(SELECT * FROM sysobjects WHERE id = object_id('Fault'))
  29. DROP TABLE Fault
  30. GO
  31.  
  32. IF EXISTS(SELECT * FROM sysobjects WHERE id = object_id('Comment'))
  33. DROP TABLE Comment
  34. GO
  35.  
  36. IF EXISTS(SELECT * FROM sysobjects WHERE id = object_id('Feedback'))
  37. DROP TABLE Feedback
  38. GO
  39.  
  40. IF EXISTS(SELECT * FROM sysobjects WHERE id = object_id('Member'))
  41. DROP TABLE Member
  42. GO
  43.  
  44. IF EXISTS(SELECT * FROM sysobjects WHERE id = object_id('Bike'))
  45. DROP TABLE Bike
  46. GO
  47.  
  48. IF EXISTS(SELECT * FROM sysobjects WHERE id = object_id('BikeStop'))
  49. DROP TABLE BikeStop
  50. GO
  51.  
  52. IF EXISTS(SELECT * FROM sysobjects WHERE id = object_id('Promotion'))
  53. DROP TABLE Promotion
  54. GO
  55.  
  56. IF EXISTS(SELECT * FROM sysobjects WHERE id = object_id('FaultType'))
  57. DROP TABLE FaultType
  58. GO
  59.  
  60. IF EXISTS(SELECT * FROM sysobjects WHERE id = object_id('MaintItem'))
  61. DROP TABLE MaintItem
  62. GO
  63.  
  64. IF EXISTS(SELECT * FROM sysobjects WHERE id = object_id('MaintType'))
  65. DROP TABLE MaintType
  66. GO
  67.  
  68. IF EXISTS(SELECT * FROM sysobjects WHERE id = object_id('Repair'))
  69. DROP TABLE Repair
  70. GO
  71.  
  72. IF EXISTS(SELECT * FROM sysobjects WHERE id = object_id('Maintenance'))
  73. DROP TABLE Maintenance
  74. GO
  75.  
  76. IF EXISTS(SELECT * FROM sysobjects WHERE id = object_id('CreditCard'))
  77. DROP TABLE CreditCard
  78. GO
  79.  
  80.  
  81. --Creating tables--
  82.  
  83.  
  84. CREATE TABLE Member
  85. (
  86.     MemberID        CHAR(6)     NOT NULL,
  87.     Name            VARCHAR(30) NOT NULL,
  88.     Email           VARCHAR(40) NULL,
  89.     Phone           CHAR(8)     NOT NULL,
  90.     RewardPts       SMALLINT    NOT NULL    DEFAULT(0),
  91.     Deposit         money       NOT NULL    DEFAULT(50),
  92.     CreditBalance   money       NOT NULL    DEFAULT(0),
  93.     DateJoin        DATE        NOT NULL    DEFAULT(GETDATE()),
  94.    
  95.     CONSTRAINT Pk_Member PRIMARY KEY(MemberID),
  96.     CONSTRAINT Chk_Phone CHECK(Phone LIKE '[6,8,9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]'),
  97.     CONSTRAINT Chk_Email CHECK(Email LIKE '[0-9A-Za-z]%@[A-Za-z]%.com' OR Email LIKE '[0-9A-Za-z]%@[A-Za-z]%.com.sg')
  98. )
  99.  
  100.  
  101. CREATE TABLE BikeStop
  102. (
  103.     BikeStopID      CHAR(2)         NOT NULL,
  104.     StopLat         DECIMAL(7,6)    NOT NULL,
  105.     StopLong        DECIMAL(9,6)    NOT NULL,
  106.     StopRadius      SMALLINT        NOT NULL,
  107.  
  108.     CONSTRAINT Pk_BikeStop PRIMARY KEY(BikeStopID),
  109.     CONSTRAINT Chk_StopRadius CHECK(StopRadius BETWEEN 5 AND 25)
  110. )
  111.  
  112. CREATE TABLE Bike
  113. (
  114.     BikeID              CHAR(4)     NOT NULL,
  115.     Rate                SMALLINT    NOT NULL,
  116.     STATUS              VARCHAR(2)  NOT NULL    CHECK(STATUS IN  ('W', 'NR', 'R')),
  117.     LastServicedDate    datetime    NULL,
  118.     BikeStopID          CHAR(2)     NOT NULL,
  119.  
  120.     CONSTRAINT Pk_Bike PRIMARY KEY(BikeID),
  121.     CONSTRAINT Fk_Bike_BikeStopID FOREIGN KEY (BikeStopID) REFERENCES BikeStop(BikeStopID)
  122. )
  123.  
  124.  
  125. CREATE TABLE BikeReservation
  126. (
  127.     ReservationID       CHAR(4)     NOT NULL,
  128.     MemberID            CHAR(6)     NOT NULL,
  129.     BikeID              CHAR(4)     NOT NULL,
  130.     ResStatus           CHAR(1)     NOT NULL,
  131.     DateTimeRes     datetime        NOT NULL    DEFAULT(GETDATE()),
  132.     DateTimeReservedFor datetime    NOT NULL,
  133.  
  134.     CONSTRAINT Pk_ReservationID PRIMARY KEY(ReservationID),
  135.     CONSTRAINT Fk_BikeReservation_MemberID FOREIGN KEY(MemberID) REFERENCES Member(MemberID),
  136.     CONSTRAINT Fk_BikeReservation_BikeID FOREIGN KEY(BikeID) REFERENCES Bike(BikeID),
  137.     CONSTRAINT Chk_ResStatus CHECK(ResStatus IN ('O', 'F')),
  138.     CONSTRAINT Chk_DateTimeReservedFor CHECK(DateTimeReservedFor >=   DateTimeRes)
  139.    
  140. )
  141.  
  142. CREATE TABLE Promotion
  143. (
  144.     PromoCode   VARCHAR(10)     NOT NULL,
  145.     PromoDesc   VARCHAR(50)     NULL,
  146.     PromoRate   DECIMAL(3,2)    NOT NULL,
  147.     StartDate   DATE            NOT NULL,
  148.     EndDate     DATE            NOT NULL,
  149.  
  150.     CONSTRAINT Pk_Promotion PRIMARY KEY(PromoCode),
  151.     CONSTRAINT Chk_StartDate CHECK(StartDate <= GETDATE()),
  152.     CONSTRAINT Chk_EndDate CHECK(EndDate >= StartDate)
  153. )
  154.  
  155. CREATE TABLE Ride
  156. (
  157.     RideID          CHAR(6)         NOT NULL,
  158.     DateTimeStart   datetime        NOT NULL,
  159.     DateTimeEnd     datetime        NULL,
  160.     Duration AS DATEDIFF (MINUTE, DateTimeStart, DateTimeEnd),
  161.     RidePts         INT             NOT NULL    DEFAULT(0),
  162.     Distance        DECIMAL(5,3)    NULL,
  163.     PtsRedeemed     INT             NOT NULL    DEFAULT(0),
  164.     Cost            smallmoney      NULL,
  165.     MemberID        CHAR(6)         NULL,
  166.     BikeID          CHAR(4)         NULL,
  167.     BikeStopID      CHAR(2)         NULL,
  168.     PromoCode       VARCHAR(10)     NULL,
  169.  
  170.     CONSTRAINT Pk_Ride PRIMARY KEY(RideID),
  171.     CONSTRAINT Fk_Ride_MemberID FOREIGN KEY(MemberID) REFERENCES Member(MemberID),
  172.     CONSTRAINT Fk_Ride_BikeID FOREIGN KEY(BikeID) REFERENCES Bike(BikeID),
  173.     CONSTRAINT Fk_Ride_BikeStopID FOREIGN KEY(BikeStopID) REFERENCES BikeStop(BikeStopID),
  174.     CONSTRAINT Fk_Ride_PromoCode FOREIGN KEY(PromoCode) REFERENCES Promotion(PromoCode),
  175.     CONSTRAINT Chk_DateTimeEnd CHECK(DateTimeEnd > DateTimeStart),
  176.     CONSTRAINT Chk_PtsRedeemed CHECK(PtsRedeemed % 50 = 0)
  177. )
  178.  
  179. CREATE TABLE Feedback
  180. (
  181.     FBID        CHAR(5)     NOT NULL,
  182.     FBDateTime  datetime    NOT NULL    DEFAULT(GETDATE()),
  183.     MemberID    CHAR(6)     NOT NULL,
  184.  
  185.     CONSTRAINT Pk_Feedback PRIMARY KEY(FBID),
  186.     CONSTRAINT Fk_Feedback_MemberID FOREIGN KEY(MemberID) REFERENCES Member(MemberID)
  187. )
  188.  
  189.  
  190. CREATE TABLE FaultType
  191. (
  192.     FaultCode   CHAR(4)         NOT NULL,
  193.     FaultDesc   VARCHAR(500)    NOT NULL,
  194.  
  195.     CONSTRAINT Pk_FaultType PRIMARY KEY(FaultCode),
  196. )
  197.  
  198. CREATE TABLE Maintenance
  199. (
  200.     MaintID     CHAR(5) NOT NULL,
  201.     MaintDate   DATE    NOT NULL,
  202.     BikeID      CHAR(4) NOT NULL,
  203.  
  204.     CONSTRAINT Pk_Maintenance PRIMARY KEY(MaintID),
  205.     CONSTRAINT Chk_MaintDate CHECK(MaintDate <= GETDATE()),
  206.     CONSTRAINT Fk_Maintenance_BikeID FOREIGN KEY(BikeID) REFERENCES Bike(BikeID)
  207. )
  208.  
  209.  
  210. CREATE TABLE Repair
  211. (
  212.     MaintID     CHAR(5) NOT NULL,
  213.     MaintDate   DATE    NOT NULL,
  214.     BikeID      CHAR(4) NOT NULL,
  215.  
  216.     CONSTRAINT Pk_Repair PRIMARY KEY(MaintID),
  217.     CONSTRAINT Fk_Repair_MaintID FOREIGN KEY(MaintID) REFERENCES Maintenance(MaintID),
  218.     CONSTRAINT Chk_Repair_MaintDate CHECK(MaintDate <= GETDATE()),
  219.     CONSTRAINT Fk_Repair_BikeID FOREIGN KEY(BikeID) REFERENCES Bike(BikeID)
  220. )
  221.  
  222. CREATE TABLE MaintType
  223. (
  224.     TypeCode        CHAR(5)         NOT NULL,
  225.     TypeDesc        VARCHAR(50)     NOT NULL,
  226.  
  227.     CONSTRAINT Pk_MaintType PRIMARY KEY (TypeCode)
  228. )
  229.  
  230. CREATE TABLE MaintItem
  231. (
  232.     SNo         CHAR(2)         NOT NULL,
  233.     MaintID     CHAR(5)         NOT NULL,
  234.     MaintDesc   VARCHAR(100)    NOT NULL,
  235.     TypeCode    CHAR(5)         NULL,
  236.  
  237.     CONSTRAINT Pk_MaintItem PRIMARY KEY (SNo, MaintID),
  238.     CONSTRAINT Fk_MaintItem_MaintID FOREIGN KEY (MaintID) REFERENCES Maintenance (MaintID) ON DELETE CASCADE,
  239.     CONSTRAINT Fk_MaintItem_TypeCode FOREIGN KEY (TypeCode) REFERENCES MaintType (TypeCode)
  240. )
  241.  
  242. CREATE TABLE Fault
  243. (
  244.     FBID            CHAR(5)         NOT NULL,
  245.     FBDateTime      datetime        NOT NULL,
  246.     FaultCat        VARCHAR(15)     NOT NULL,
  247.     MemberID        CHAR(6)         NOT NULL,
  248.     FaultCode       CHAR(4)         NULL,
  249.     BikeID          CHAR(4)         NOT NULL,
  250.     MaintID         CHAR(5)         NOT NULL,
  251.        
  252.     CONSTRAINT Pk_Fault PRIMARY KEY (FBID),
  253.     CONSTRAINT FK_Fault_FBID FOREIGN KEY(FBID) REFERENCES Feedback(FBID),
  254.     CONSTRAINT Fk_Fault_MemberID FOREIGN KEY (MemberID) REFERENCES Member (MemberID),
  255.     CONSTRAINT Fk_Fault_FaultCode FOREIGN KEY(FaultCode) REFERENCES FaultType(FaultCode),
  256.     CONSTRAINT Fk_Fault_BikeID FOREIGN KEY(BikeID) REFERENCES Bike(BikeID),
  257.     CONSTRAINT Fk_Fault_MaintID FOREIGN KEY(MaintID) REFERENCES Maintenance(MaintID),
  258.     CONSTRAINT Chk_Fault_FaultCat CHECK(FaultCat IN ('Tire', 'Pedal', 'Seat', 'Basket', 'Lock', 'Frame', 'Others'))
  259. )
  260.  
  261. CREATE TABLE Comment
  262. (
  263.     FBID        CHAR(5)         NOT NULL,
  264.     FBDateTime  datetime        NOT NULL,
  265.     FBMessage   VARCHAR(1000)   NULL,
  266.     MemberID    CHAR(6)         NOT NULL,
  267.  
  268.     CONSTRAINT Pk_Comment PRIMARY KEY(FBID),
  269.     CONSTRAINT Fk_Comment_FBID FOREIGN KEY(FBID) REFERENCES Feedback(FBID),
  270.     CONSTRAINT Fk_Comment_MemberID FOREIGN KEY (MemberID) REFERENCES Member(MemberID),
  271.     CONSTRAINT Chk_FBDateTime CHECK(FBDateTime <= GETDATE())
  272. )
  273.  
  274. CREATE TABLE CreditCard
  275. (
  276.     CardNo      CHAR(6)         NOT NULL,
  277.     CardType    VARCHAR(30)     NOT NULL,
  278.     ExpiryDate  DATE            NOT NULL,
  279.     CVV         CHAR(3)         NOT NULL,
  280.     MemberID    CHAR(6)         NOT NULL,
  281.  
  282.     CONSTRAINT Pk_CreditCard PRIMARY KEY(CardNo),
  283.     CONSTRAINT Chk_ExpiryDate CHECK(ExpiryDate >= GETDATE()),
  284.     CONSTRAINT Fk_MemberID FOREIGN KEY (MemberID) REFERENCES Member(MemberID),
  285. )
  286.  
  287. CREATE TABLE CreditDebitTrans
  288. (
  289.     TransID         CHAR(6)         NOT NULL,
  290.     TransAmt        smallmoney      NOT NULL,
  291.     TransType       VARCHAR(6)      NOT NULL,
  292.     TransDateTime   datetime        NOT NULL DEFAULT(GETDATE()),
  293.     CardNo          CHAR(6)         NOT NULL,
  294.     RideID          CHAR(6)         NOT NULL,
  295.  
  296.     CONSTRAINT Pk_CreditDebitTrans PRIMARY KEY(TransID),
  297.     CONSTRAINT Fk_CreditDebitTrans_CardNo FOREIGN KEY(CardNo) REFERENCES CreditCard(CardNo),
  298.     CONSTRAINT Fk_CreditDebitTrans_RideID FOREIGN KEY(RideID) REFERENCES Ride(RideID),
  299.     CONSTRAINT Chk_TransType CHECK(TransType IN ('Credit','Debit'))
  300. )
  301.  
  302.  
  303.  
  304.  
  305. --Inserting values--
  306.  
  307. INSERT INTO BikeStop(BikeStopID, StopLat, StopLong, StopRadius) VALUES ('AA',1.335512, 103.962087, 25)
  308. INSERT INTO BikeStop(BikeStopID, StopLat, StopLong, StopRadius) VALUES ('AB',1.340790, 103.950886, 20)
  309. INSERT INTO BikeStop(BikeStopID, StopLat, StopLong, StopRadius) VALUES ('AC',1.345273, 103.939234, 15)
  310. INSERT INTO BikeStop(BikeStopID, StopLat, StopLong, StopRadius) VALUES ('AD',1.334727, 103.764290, 10)
  311. INSERT INTO BikeStop(BikeStopID, StopLat, StopLong, StopRadius) VALUES ('AE',1.359096, 103.893723, 5)
  312. INSERT INTO BikeStop(BikeStopID, StopLat, StopLong, StopRadius) VALUES ('AF',1.366304, 103.947624, 25)
  313. INSERT INTO BikeStop(BikeStopID, StopLat, StopLong, StopRadius) VALUES ('AG',1.446274, 103.823685, 10)
  314. INSERT INTO BikeStop(BikeStopID, StopLat, StopLong, StopRadius) VALUES ('AH',1.394791, 103.906769, 15)
  315. INSERT INTO BikeStop(BikeStopID, StopLat, StopLong, StopRadius) VALUES ('AI',1.312760, 103.767380, 25)
  316. INSERT INTO BikeStop(BikeStopID, StopLat, StopLong, StopRadius) VALUES ('AJ',1.327176, 103.688416, 25)
  317. INSERT INTO BikeStop(BikeStopID, StopLat, StopLong, StopRadius) VALUES ('AK',1.444214, 103.788666, 20)
  318. INSERT INTO BikeStop(BikeStopID, StopLat, StopLong, StopRadius) VALUES ('AL',1.392389, 103.904709, 10)
  319. INSERT INTO BikeStop(BikeStopID, StopLat, StopLong, StopRadius) VALUES ('AM',1.381405, 103.890633, 5)
  320. INSERT INTO BikeStop(BikeStopID, StopLat, StopLong, StopRadius) VALUES ('AN',1.377630, 103.879646, 5)
  321. INSERT INTO BikeStop(BikeStopID, StopLat, StopLong, StopRadius) VALUES ('AO',1.328892, 103.744720, 25)
  322.  
  323. INSERT INTO Bike VALUES ('1AAA', 0.5, 'W', '2016-10-10', 'AA')
  324. INSERT INTO Bike VALUES ('2BBB', 0.5, 'W', '2009-02-02', 'AB')
  325. INSERT INTO Bike VALUES ('3CCC', 0.5, 'W', '2010-03-03', 'AA')
  326. INSERT INTO Bike VALUES ('4DDD', 0.5, 'R', '2010-04-04', 'AC')
  327. INSERT INTO Bike VALUES ('5EEE', 0.5, 'W', '2011-05-05', 'AD')
  328. INSERT INTO Bike VALUES ('6FFF', 0.5, 'W', '2015-06-06', 'AE')
  329. INSERT INTO Bike VALUES ('7GGG', 0.5, 'NR', '2017-03-23','AB')
  330. INSERT INTO Bike VALUES ('8HHH', 0.5, 'W', '2012-03-03', 'AA')
  331. INSERT INTO Bike VALUES ('9III', 0.5, 'W', '2014-08-08', 'AG')
  332. INSERT INTO Bike VALUES ('JJJ1', 0.5, 'W', '2013-10-20', 'AH')
  333. INSERT INTO Bike VALUES ('KKK2', 0.5, 'W', '2013-07-12', 'AI')
  334. INSERT INTO Bike VALUES ('LLL3', 0.5, 'NR', '2014-11-21', 'AJ')
  335. INSERT INTO Bike VALUES ('MMM4', 0.5, 'W', '2010-03-15', 'AH')
  336. INSERT INTO Bike VALUES ('NNN5', 0.5, 'W', '2018-01-02', 'AA')
  337. INSERT INTO Bike VALUES ('OOO6', 0.5, 'W', '2018-01-10', 'AO')
  338.  
  339. INSERT INTO Member (MemberID, Name, Email, Phone, RewardPts, Deposit, CreditBalance, DateJoin) VALUES ('11111B','John Bruce', 'jhonbruce@gmail.com.sg', '90000001', 6, 100, 200, '2017-08-01')
  340. INSERT INTO Member VALUES ('22222C','Tom Harrison', 'tomharrison@gmail.com', '90000002', 15, 60, 50, '2017-01-03')
  341. INSERT INTO Member (MemberID, Name, Email, Phone, Deposit, CreditBalance, DateJoin) VALUES ('33333D','Zachary Tan', 'zacharytan@gmail.com', '90000003', 80, 200, '2016-12-01')
  342. INSERT INTO Member (MemberID, Name, Email, Phone, RewardPts, CreditBalance, DateJoin) VALUES ('44444E','Tammy Lee', 'tammylee@hotmail.com.sg', '90000004', 24, 200, '2016-05-01')
  343. INSERT INTO Member VALUES ('55555F','Monica Cheng', 'monicacheng@gmail.com', '90000005', 29, 140, 350, '2015-10-15')
  344. INSERT INTO Member VALUES ('66666G','Javier Tang', 'javiertang@gmail.com', '90000006', 33, 120, 400, '2015-06-01')
  345. INSERT INTO Member (MemberID, Name, Email, Phone, RewardPts) VALUES ('77777H','Shaun Jacob', 'shaunjacob@hotmail.com.sg', '90000007', 6)
  346. INSERT INTO Member VALUES ('88888I','William Johnson', 'willianjohnson@gmail.com', '90000008', 42, 150, 25, '2014-09-09')
  347. INSERT INTO Member (MemberID, Name, Email, Phone, RewardPts, Deposit, DateJoin) VALUES ('99999J','James Bruce', 'jamesbruce@gmail.com.sg', '90000009', 45, 170, '2013-06-09')
  348. INSERT INTO Member (MemberID, Name, Email, Phone, Deposit, DateJoin) VALUES ('AAAAA1','Wayne', 'xxxwayne999@gmail.com', '80000000', 200, '2012-07-22')
  349. INSERT INTO Member (MemberID, Name, Email, Phone, RewardPts) VALUES ('BBBBB2','Jennifer Pang', 'jenniferpang@gmail.com', '80000001', 6)
  350. INSERT INTO Member (MemberID, Name, Email, Phone, RewardPts, DateJoin) VALUES ('CCCCC3','Ethan Bradberry', 'ethanbradberry@hotmail.com.sg', '80000002', 55, '2011-11-11')
  351. INSERT INTO Member VALUES ('DDDDD4','Daniel Lim', 'daniellim@gmail.com', '80000003', 69, 170, 46, '2010-10-10')
  352. INSERT INTO Member (MemberID, Name, Email, Phone, CreditBalance, DateJoin) VALUES ('EEEEE5','Lucas Paul', 'lucaspaul@gmail.com.sg', '80000004', 100, '2009-09-09')
  353. INSERT INTO Member VALUES ('FFFFF6', 'Jack Lee', 'jacklee99@hotmail.com.sg', '80000005', 15, 55, 31, '2008-08-08')
  354. INSERT INTO Member VALUES ('GGGGG7', 'Mary Tan', 'marytan@yahoo.com.sg', '80000006', 12, 60, 12, '2017-10-18')
  355. INSERT INTO Member VALUES ('HHHHH8', 'Tom Everson', 'tomeve@yahoo.com', '80000007', 16, 56, 15, '2017-08-28')
  356. INSERT INTO Member VALUES ('IIIII9', 'Claudia Koh', 'claudia13@yahoo.com.sg', '80000008', 21, 53, 35, '2008-09-17')
  357. INSERT INTO Member (MemberID, Name, Email, Phone, RewardPts, Deposit, DateJoin) VALUES ('JJJJJ1', 'Nicholas Paris', 'parisnicalo@yahoo.com', '80000009', 34, 55, '2016-02-25')
  358. INSERT INTO Member (MemberID, Name, Email, Phone, RewardPts, CreditBalance, DateJoin) VALUES ('KKKKK2', 'Jackson Yi', 'yi08@yahoo.com', '80000010', 56, 2, '2016-03-26')
  359.  
  360. INSERT INTO BikeReservation VALUES ('0001','55555F', '4DDD', 'F', '2011-04-04 04:04:04', '2011-04-04 04:34:04')
  361. INSERT INTO BikeReservation VALUES ('0002','44444E', '5EEE', 'F', '2011-05-05 05:05:05', '2011-05-05 05:15:05')
  362. INSERT INTO BikeReservation VALUES ('0003','77777H', '3CCC', 'F', '2010-03-03 03:03:03', '2010-03-03 03:23:03')
  363. INSERT INTO BikeReservation VALUES ('0004','88888I', '9III', 'O', '2018-01-11 09:09:09', '2018-01-16 17:10:09')
  364. INSERT INTO BikeReservation VALUES ('0005','CCCCC3', 'LLL3', 'O', '2018-01-10 11:11:11', '2018-01-16 11:15:20')
  365. INSERT INTO BikeReservation VALUES ('0006','FFFFF6', '1AAA', 'F', '2008-01-01 01:01:01', '2008-01-01 01:11:01')
  366. INSERT INTO BikeReservation VALUES ('0007','AAAAA1', 'NNN5', 'F', '2017-02-03 13:13:13', '2017-02-03 13:23:13')
  367. INSERT INTO BikeReservation VALUES ('0008','EEEEE5', 'KKK2', 'F', '2014-11-11 10:10:10', '2014-11-11 10:20:10')
  368. INSERT INTO BikeReservation VALUES ('0009','DDDDD4', 'OOO6', 'F', '2017-03-04 14:14:14', '2017-03-04 14:54:14')
  369. INSERT INTO BikeReservation VALUES ('0010','55555F', '6FFF', 'O', '2018-01-10 06:06:06', '2018-01-16 18:16:06')
  370. INSERT INTO BikeReservation VALUES ('0011','99999J', 'JJJ1', 'F', '2014-10-10 09:09:10', '2014-10-10 09:09:20')
  371. INSERT INTO BikeReservation VALUES ('0012','66666G', '7GGG', 'F', '2013-07-07 07:07:07', '2013-07-07 07:27:07')
  372. INSERT INTO BikeReservation VALUES ('0013','77777H', '8HHH', 'F', '2013-08-08 08:08:08', '2013-08-08 08:28:08')
  373. INSERT INTO BikeReservation VALUES ('0014','BBBBB2', 'MMM4', 'F', '2017-01-02 12:12:12', '2017-01-02 12:15:12')
  374. INSERT INTO BikeReservation VALUES ('0015','11111B', '2BBB', 'F', '2009-02-02 02:02:02', '2009-02-02 02:12:02')
  375. INSERT INTO BikeReservation VALUES ('0016','55555F', '6FFF', 'F', '2017-12-25 16:06:05', '2018-01-10 20:18:27')
  376. INSERT INTO BikeReservation VALUES ('0017','55555F', 'KKK2', 'O', '2018-01-10 19:34:56', '2018-01-15 18:16:06')
  377. INSERT INTO BikeReservation VALUES ('0018','77777H', 'NNN5', 'O', '2018-01-13 10:05:05', '2018-01-16 15:22:46')
  378. INSERT INTO BikeReservation VALUES ('0019','77777H', 'OOO6', 'F', '2017-12-20 09:35:23', '2017-12-25 12:20:36')
  379. INSERT INTO BikeReservation VALUES ('0020','88888I', '4DDD', 'F', '2017-12-29 20:34:21', '2018-01-04 13:29:50')
  380. INSERT INTO BikeReservation VALUES ('0021','CCCCC3', '8HHH', 'O', '2018-01-14 21:09:35', '2018-01-15 10:12:27')
  381.  
  382. INSERT INTO BikeReservation VALUES ('0022','22222C', '5EEE', 'F', '2016-09-20 00:30:00', '2016-09-26 01:00:00')
  383. INSERT INTO BikeReservation VALUES ('0023','88888I', 'MMM4', 'O', '2016-09-22 11:30:00', '2016-09-22 12:00:00')
  384. INSERT INTO BikeReservation VALUES ('0024','CCCCC3', 'NNN5', 'F', '2016-09-24 22:50:00', '2016-09-24 23:00:00')
  385. INSERT INTO BikeReservation VALUES ('0025','11111B', '5EEE', 'F', '2016-09-26 04:30:00', '2016-09-26 04:50:00')
  386.  
  387.  
  388. INSERT INTO Promotion VALUES ('Promo01', 'Get 5% off of total price of the ride', 0.05, '2008-01-01', '2008-03-04')
  389. INSERT INTO Promotion VALUES ('Promo02', 'Get 25% off of total price of the ride', 0.25, '2008-04-11', '2008-06-19')
  390. INSERT INTO Promotion VALUES ('Promo03', 'Get 30% off of total price of the ride', 0.30, '2008-08-01', '2018-12-09')
  391. INSERT INTO Promotion VALUES ('Promo04', 'Get 20% off of total price of the ride', 0.20, '2009-02-13', '2009-04-01')
  392. INSERT INTO Promotion VALUES ('Promo05', 'Get 10% off of total price of the ride', 0.10, '2009-06-01', '2009-08-20')
  393. INSERT INTO Promotion VALUES ('Promo06', 'Get 30% off of total price of the ride', 0.30, '2010-01-01', '2010-02-01')
  394. INSERT INTO Promotion VALUES ('Promo07', 'Get 60% off of total price of the ride', 0.60, '2010-02-28', '2010-06-30')
  395. INSERT INTO Promotion VALUES ('Promo08', 'Get 80% off of total price of the ride', 0.80, '2011-08-21', '2011-09-01')
  396. INSERT INTO Promotion VALUES ('Promo09', 'Get 90% off of total price of the ride', 0.90, '2011-08-10', '2011-12-14')
  397. INSERT INTO Promotion VALUES ('Promo10', 'Get 10% off of total price of the ride', 0.10, '2011-10-15', '2011-12-16')
  398. INSERT INTO Promotion VALUES ('Promo11', 'Get 15% off of total price of the ride', 0.15, '2012-06-23', '2012-12-31')
  399. INSERT INTO Promotion VALUES ('Promo12', 'Get 33% off of total price of the ride', 0.33, '2013-02-11', '2013-04-01')
  400. INSERT INTO Promotion VALUES ('Promo13', 'Get 25% off of total price of the ride', 0.25, '2014-01-05', '2014-08-07')
  401. INSERT INTO Promotion VALUES ('Promo14', 'Get 55% off of total price of the ride', 0.55, '2015-11-03', '2016-03-18')
  402. INSERT INTO Promotion VALUES ('Promo15', 'Get 75% off of total price of the ride', 0.75, '2017-06-20', '2018-01-02')
  403.  
  404. INSERT INTO Ride VALUES('1AAAAA', '2008-01-01 01:11:01', '2008-01-01 01:31:01', 20, 5.00, 0, 0.50, 'FFFFF6', '1AAA', 'AA', 'Promo01')
  405. INSERT INTO Ride VALUES('1BBBBB', '2008-02-29 13:01:01', '2008-02-29 13:31:01', 30, 6.50, 0, 0.50, '88888I', '2BBB', 'AC', 'Promo01')
  406. INSERT INTO Ride VALUES('1CCCCC', '2018-01-01 13:30:00', '2018-01-01 14:10:00', 40, 7.00, 0, 0.50, 'IIIII9', '3CCC', 'AD', 'Promo15')
  407. INSERT INTO Ride VALUES('1DDDDD', '2017-12-26 14:10:00', '2017-12-26 14:20:00', 50, 8.50, 50, 0.50, '33333D', '4DDD', 'AB', 'Promo07')
  408. INSERT INTO Ride VALUES('1EEEEE', '2011-09-10 16:35:00', '2011-09-10 17:30:00', 55, 9.00, 50, 0.50, '44444E', '1AAA', 'AG', 'Promo08')
  409. INSERT INTO Ride VALUES('1FFFFF', '2011-04-04 04:34:04', '2011-04-04 05:34:04', 60, 10.00, 50, 0.50, '55555F', '5EEE', 'AH', 'Promo10')
  410. INSERT INTO Ride VALUES('1GGGGG', '2017-12-28 08:28:08', '2017-12-28 08:43:08', 15, 4.50, 0, 0.50, 'GGGGG7', '7GGG', 'AD', NULL)
  411. INSERT INTO Ride VALUES('1HHHHH', '2011-07-07 09:00:00', '2011-07-07 09:10:00', 10, 4.00, 0, 0.50, '77777H', '9III', 'AK', 'Promo08')
  412. INSERT INTO Ride VALUES('1IIIII', '2012-06-06 01:16:06', '2012-06-06 06:46:06', 30, 6.35, 0, 0.50, '88888I', 'LLL3', 'AM', 'Promo11')
  413. INSERT INTO Ride VALUES('1JJJJJ', '2011-08-21 09:09:20', '2011-08-30 09:49:46', 40, 7.10, 0, 0.50, '44444E', 'JJJ1', 'AO', 'Promo08')
  414. INSERT INTO Ride VALUES('1KKKKK', '2013-01-01 01:01:01', '2013-01-01 02:01:01', 60, 10.10, 50, 0.50, 'AAAAA1', 'OOO6', 'AN', 'Promo09')
  415. INSERT INTO Ride VALUES('1LLLLL', '2014-01-01 01:11:23', '2014-01-01 01:51:01', 50, 9.45, 50, 0.50, 'BBBBB2', 'NNN5', 'AM', 'Promo13')
  416. INSERT INTO Ride VALUES('1MMMMM', '2017-12-17 02:34:00', '2017-12-17 03:01:01', 120, 21.10, 100, 1.40, 'HHHHH8', '8HHH', 'AD', NULL)
  417. INSERT INTO Ride VALUES('1NNNNN', '2008-03-03 14:54:14', '2008-03-03 15:19:14', 25, 6.00, 0, 0.50, 'FFFFF6', 'OOO6', 'AB', 'Promo01')
  418. INSERT INTO Ride VALUES('1OOOOO', '2018-01-10 10:20:10', '2018-01-10 10:30:10', 10, 4.25, 0, 0.50, 'EEEEE5', 'KKK2', 'AB', NULL)
  419. INSERT INTO Ride VALUES('1PPPPP', '2008-01-01 12:21:32', '2008-02-20 13:00:05', 60, 10.10, 50, 0.50, '88888I', 'OOO6', 'AN', 'Promo01')
  420. INSERT INTO Ride VALUES('1QQQQQ', '2014-01-01 15:45:45', '2014-01-01 16:05:23', 50, 9.45, 50, 0.50, 'GGGGG7', 'NNN5', 'AM', 'Promo13')
  421. INSERT INTO Ride VALUES('1RRRRR', '2011-07-29 13:30:00', '2011-08-21 14:30:00', 60, 18.00, 50, 0.50, 'JJJJJ1', '4DDD', 'AO', 'Promo08')
  422. INSERT INTO Ride VALUES('1SSSSS', '2017-05-05 15:00:00', '2018-01-01 16:00:00', 60, 15.00, 50, 0.50, 'KKKKK2', 'LLL3', 'AM', NULL)
  423. INSERT INTO Ride VALUES('1WWWWW', '2016-09-20 01:00:00', '2016-09-20 01:30:00', 30, 7.00, 0, 0.50, '22222C', '5EEE', 'AM', NULL)
  424. INSERT INTO Ride VALUES('1XXXXX', '2016-09-22 12:00:00', '2016-09-22 12:10:00', 10, 2.00, 0, 0.50, '88888I', 'MMM4', 'AJ', NULL)
  425. INSERT INTO Ride VALUES('1YYYYY', '2016-09-24 22:50:00', '2016-09-25 00:00:00', 70, 16.00, 50, 0.70, 'CCCCC3', 'NNN5', 'AD', NULL)
  426. INSERT INTO Ride VALUES('1ZZZZZ', '2016-09-26 04:50:00', '2016-09-26 05:20:00', 30, 7.00, 0, 0.50, '11111B', '5EEE', 'AA', NULL)
  427. INSERT INTO Ride VALUES('1TTTTT', '2017-06-06 16:10:00', '2017-06-06 17:00:00', 50, 10.50, 50, 0.50, '33333D', '5EEE', 'AE', 'Promo15')
  428. INSERT INTO Ride VALUES('1UUUUU', '2017-07-07 15:00:00', '2017-07-07 16:00:00', 60, 15.50, 50, 0.50, 'BBBBB2', '3CCC', 'AD', 'Promo15')
  429.  
  430.  
  431. INSERT INTO Feedback VALUES ('00001', '2017-03-04 00:14:14', 'FFFFF6')
  432. INSERT INTO Feedback VALUES ('00002', '2010-01-07 12:59:12', '22222C')
  433. INSERT INTO Feedback VALUES ('00003', '2016-12-14 02:49:45', '11111B')
  434. INSERT INTO Feedback VALUES ('00004', '2014-02-24 18:17:10', '33333D')
  435. INSERT INTO Feedback VALUES ('00005', '2015-02-15 19:37:20', 'FFFFF6')
  436. INSERT INTO Feedback VALUES ('00006', '2013-11-25 20:18:30', 'AAAAA1')
  437. INSERT INTO Feedback VALUES ('00007', '2017-05-05 11:58:40', '44444E')
  438. INSERT INTO Feedback VALUES ('00008', '2012-07-03 22:28:50', '66666G')
  439. INSERT INTO Feedback VALUES ('00009', '2012-04-30 19:54:12', '77777H')
  440. INSERT INTO Feedback VALUES ('00010', '2011-03-29 10:34:14', 'FFFFF6')
  441. INSERT INTO Feedback VALUES ('00011', '2017-11-19 03:45:17', '55555F')
  442. INSERT INTO Feedback VALUES ('00012', '2016-05-01 04:12:56', '55555F')
  443. INSERT INTO Feedback VALUES ('00013', '2011-01-03 11:27:45', '11111B')
  444. INSERT INTO Feedback VALUES ('00014', '2015-01-14 07:17:34', 'EEEEE5')
  445. INSERT INTO Feedback VALUES ('00015', '2012-04-02 09:09:21', 'BBBBB2')
  446. INSERT INTO Feedback VALUES ('10001', '2017-02-10 01:02:35', 'HHHHH8')
  447. INSERT INTO Feedback VALUES ('20002', '2017-05-13 03:09:23', 'CCCCC3')
  448. INSERT INTO Feedback VALUES ('30003', '2016-03-26 23:02:13', 'GGGGG7')
  449. INSERT INTO Feedback VALUES ('40004', '2016-07-17 12:24:45', '66666G')
  450. INSERT INTO Feedback VALUES ('50005', '2015-07-06 07:12:07', 'AAAAA1')
  451. INSERT INTO Feedback VALUES ('60006', '2015-10-09 06:23:46', 'HHHHH8')
  452. INSERT INTO Feedback VALUES ('70007', '2014-01-19 03:59:00', 'CCCCC3')
  453. INSERT INTO Feedback VALUES ('80008', '2014-04-03 14:34:25', '99999J')
  454. INSERT INTO Feedback VALUES ('90009', '2013-02-20 16:45:50', 'JJJJJ1')
  455. INSERT INTO Feedback VALUES ('11011', '2013-07-21 20:34:01', 'HHHHH8')
  456. INSERT INTO Feedback VALUES ('22022', '2012-08-26 18:09:23', 'BBBBB2')
  457. INSERT INTO Feedback VALUES ('33033', '2012-02-14 06:45:50', 'IIIII9')
  458. INSERT INTO Feedback VALUES ('44044', '2011-03-18 04:34:10', 'HHHHH8')
  459. INSERT INTO Feedback VALUES ('55055', '2011-06-22 16:23:57', 'IIIII9')
  460. INSERT INTO Feedback VALUES ('66066', '2010-04-22 18:34:49', 'CCCCC3')
  461.  
  462. INSERT INTO Feedback VALUES ('77077', '2017-01-01 01:31:01', 'FFFFF6')
  463. INSERT INTO Feedback VALUES ('88088', '2017-09-01 17:30:00', '44444E')
  464. INSERT INTO Feedback VALUES ('99099', '2016-06-06 03:46:06', '88888I')
  465. INSERT INTO Feedback VALUES ('11111', '2016-02-02 02:22:31', 'KKKKK2')
  466. INSERT INTO Feedback VALUES ('22122', '2016-03-03 15:21:01', 'AAAAA1')
  467. INSERT INTO Feedback VALUES ('33133', '2016-04-04 14:00:00', 'DDDDD4')
  468. INSERT INTO Feedback VALUES ('44144', '2015-01-04 14:00:00', 'BBBBB2')
  469. INSERT INTO Feedback VALUES ('55155', '2015-01-04 14:00:00', 'GGGGG7')
  470.  
  471. INSERT INTO Comment(FBID, FBDateTime, FBMessage, MemberID) VALUES('00001', '2017-03-04 00:14:14', 'Message01', 'FFFFF6')
  472. INSERT INTO Comment(FBID, FBDateTime, FBMessage, MemberID) VALUES('00002', '2010-01-07 12:59:12', 'Message02', '22222C')
  473. INSERT INTO Comment(FBID, FBDateTime, FBMessage, MemberID) VALUES('00003', '2016-12-14 02:49:45', 'Message03', '11111B')
  474. INSERT INTO Comment(FBID, FBDateTime, FBMessage, MemberID) VALUES('00004', '2014-02-24 18:17:10', 'Message04', '33333D')
  475. INSERT INTO Comment(FBID, FBDateTime, FBMessage, MemberID) VALUES('00005', '2015-02-15 19:37:20', 'Message05', 'FFFFF6')
  476. INSERT INTO Comment(FBID, FBDateTime, FBMessage, MemberID) VALUES('00006', '2013-11-25 20:18:30', 'Message06', 'AAAAA1')
  477. INSERT INTO Comment(FBID, FBDateTime, FBMessage, MemberID) VALUES('00007', '2017-08-05 11:58:40', 'Message07', '44444E')
  478. INSERT INTO Comment(FBID, FBDateTime, FBMessage, MemberID) VALUES('00008', '2012-07-03 22:28:50', 'Message08', '66666G')
  479. INSERT INTO Comment(FBID, FBDateTime, FBMessage, MemberID) VALUES('00009', '2012-04-30 19:54:12', 'Message09', '77777H')
  480. INSERT INTO Comment(FBID, FBDateTime, FBMessage, MemberID) VALUES('00010', '2011-03-29 10:34:14', 'Message10', 'FFFFF6')
  481. INSERT INTO Comment(FBID, FBDateTime, FBMessage, MemberID) VALUES('00011', '2017-11-19 03:45:17', 'Message11', '55555F')
  482. INSERT INTO Comment(FBID, FBDateTime, FBMessage, MemberID) VALUES('00012', '2016-12-01 04:12:56', 'Message12', '55555F')
  483. INSERT INTO Comment(FBID, FBDateTime, FBMessage, MemberID) VALUES('00013', '2011-01-03 11:27:45', 'Message13', '11111B')
  484. INSERT INTO Comment(FBID, FBDateTime, FBMessage, MemberID) VALUES('00014', '2015-01-14 07:17:34', 'Message14', 'EEEEE5')
  485. INSERT INTO Comment(FBID, FBDateTime, FBMessage, MemberID) VALUES('00015', '2012-04-02 09:09:21', 'Message15', 'BBBBB2')
  486.  
  487. INSERT INTO FaultType VALUES('TI-1','Tires are punctured')
  488. INSERT INTO FaultType VALUES('TI-2','Tires are worn out')
  489. INSERT INTO FaultType VALUES('TI-3','Tires misshaped')
  490. INSERT INTO FaultType VALUES('BA-1','A part of the basket is broken off')
  491. INSERT INTO FaultType VALUES('BA-2','Basket has been misshaped by force')
  492. INSERT INTO FaultType VALUES('BA-3','Basket is almost / already detached from the rest of the bike' )
  493. INSERT INTO FaultType VALUES('SE-1','Seat covering is torn off (or a portion of it)')
  494. INSERT INTO FaultType VALUES('SE-2','Seat is physically damaged')
  495. INSERT INTO FaultType VALUES('LO-1','Lock is broken, completely insecure')
  496. INSERT INTO FaultType VALUES('LO-2','Lock does not work')
  497. INSERT INTO FaultType VALUES('PE-1','Pedal(s) is / are loose')
  498. INSERT INTO FaultType VALUES('PE-2','Pedal(s) is / are missing')
  499. INSERT INTO FaultType VALUES('FR-1','Frame is dented in')
  500. INSERT INTO FaultType VALUES('FR-2','Paint on frame has been scraped off')
  501. INSERT INTO FaultType VALUES('OO-1','Bicycle is unlocked')
  502.  
  503. INSERT INTO FaultType VALUES('OO-2','Tire is busted')
  504. INSERT INTO FaultType VALUES('TP-1','Lock broken')
  505. INSERT INTO FaultType VALUES('TP-2','Basket loose')
  506. INSERT INTO FaultType VALUES('PO-1','Frame dented')
  507. INSERT INTO FaultType VALUES('PO-2','Seat filthy')
  508. INSERT INTO FaultType VALUES('TA-1','Pedal noisy')
  509. INSERT INTO FaultType VALUES('AS-1','Frame is dented')
  510. INSERT INTO FaultType VALUES('AS-2','Tire is flat')
  511.  
  512. INSERT INTO Maintenance(MaintID, MaintDate, BikeID) VALUES ('A0001', '2008-01-01', '1AAA')
  513. INSERT INTO Maintenance(MaintID, MaintDate, BikeID) VALUES ('A0002', '2009-02-02', '2BBB')
  514. INSERT INTO Maintenance(MaintID, MaintDate, BikeID) VALUES ('A0003', '2010-03-03', '3CCC')
  515. INSERT INTO Maintenance(MaintID, MaintDate, BikeID) VALUES ('A0004', '2010-04-04', '4DDD')
  516. INSERT INTO Maintenance(MaintID, MaintDate, BikeID) VALUES ('A0005', '2011-05-05', '5EEE')
  517. INSERT INTO Maintenance(MaintID, MaintDate, BikeID) VALUES ('A0006', '2012-06-06', 'JJJ1')
  518. INSERT INTO Maintenance(MaintID, MaintDate, BikeID) VALUES ('A0007', '2013-07-07', '1AAA')
  519. INSERT INTO Maintenance(MaintID, MaintDate, BikeID) VALUES ('A0008', '2014-08-08', '9III')
  520. INSERT INTO Maintenance(MaintID, MaintDate, BikeID) VALUES ('A0009', '2015-09-09', 'KKK2')
  521. INSERT INTO Maintenance(MaintID, MaintDate, BikeID) VALUES ('A0010', '2016-10-10', '1AAA')
  522. INSERT INTO Maintenance(MaintID, MaintDate, BikeID) VALUES ('A0011', '2017-11-11', 'OOO6')
  523. INSERT INTO Maintenance(MaintID, MaintDate, BikeID) VALUES ('A0012', '2010-12-12', 'KKK2')
  524. INSERT INTO Maintenance(MaintID, MaintDate, BikeID) VALUES ('A0013', '2008-01-01', 'NNN5')
  525. INSERT INTO Maintenance(MaintID, MaintDate, BikeID) VALUES ('A0014', '2011-02-02', 'MMM4')
  526. INSERT INTO Maintenance(MaintID, MaintDate, BikeID) VALUES ('A0015', '2012-03-03', '8HHH')
  527. INSERT INTO Maintenance(MaintID, MaintDate, BikeID) VALUES ('A0016', '2013-07-30', '6FFF')
  528. INSERT INTO Maintenance(MaintID, MaintDate, BikeID) VALUES ('A0017', '2011-05-25', '3CCC')
  529. INSERT INTO Maintenance(MaintID, MaintDate, BikeID) VALUES ('A0018', '2017-01-02', '1AAA')
  530. INSERT INTO Maintenance(MaintID, MaintDate, BikeID) VALUES ('A0019', '2017-09-02', '1AAA')
  531. INSERT INTO Maintenance(MaintID, MaintDate, BikeID) VALUES ('A0020', '2016-06-07', 'LLL3')
  532. INSERT INTO Maintenance(MaintID, MaintDate, BikeID) VALUES ('A0021', '2016-02-03', 'LLL3')
  533. INSERT INTO Maintenance(MaintID, MaintDate, BikeID) VALUES ('A0022', '2016-03-04', 'OOO6')
  534. INSERT INTO Maintenance(MaintID, MaintDate, BikeID) VALUES ('A0023', '2016-04-05', 'OOO6')
  535. INSERT INTO Maintenance(MaintID, MaintDate, BikeID) VALUES ('A0024', '2015-01-06', 'NNN5')
  536. INSERT INTO Maintenance(MaintID, MaintDate, BikeID) VALUES ('A0025', '2015-01-05', 'NNN5')
  537.  
  538. INSERT INTO Repair(MaintID, MaintDate, BikeID) VALUES ('A0001', '2008-01-01', '1AAA')
  539. INSERT INTO Repair(MaintID, MaintDate, BikeID) VALUES ('A0002', '2009-02-02', '2BBB')
  540. INSERT INTO Repair(MaintID, MaintDate, BikeID) VALUES ('A0003', '2010-03-03', '3CCC')
  541. INSERT INTO Repair(MaintID, MaintDate, BikeID) VALUES ('A0004', '2010-04-04', '4DDD')
  542. INSERT INTO Repair(MaintID, MaintDate, BikeID) VALUES ('A0005', '2011-05-05', '5EEE')
  543. INSERT INTO Repair(MaintID, MaintDate, BikeID) VALUES ('A0006', '2012-06-06', '6FFF')
  544. INSERT INTO Repair(MaintID, MaintDate, BikeID) VALUES ('A0007', '2013-07-07', '7GGG')
  545. INSERT INTO Repair(MaintID, MaintDate, BikeID) VALUES ('A0008', '2014-08-08', '8HHH')
  546. INSERT INTO Repair(MaintID, MaintDate, BikeID) VALUES ('A0009', '2015-09-09', '9III')
  547. INSERT INTO Repair(MaintID, MaintDate, BikeID) VALUES ('A0010', '2016-10-10', 'JJJ1')
  548. INSERT INTO Repair(MaintID, MaintDate, BikeID) VALUES ('A0011', '2017-11-11', 'KKK2')
  549. INSERT INTO Repair(MaintID, MaintDate, BikeID) VALUES ('A0012', '2010-12-12', 'LLL3')
  550. INSERT INTO Repair(MaintID, MaintDate, BikeID) VALUES ('A0013', '2008-01-01', 'MMM4')
  551. INSERT INTO Repair(MaintID, MaintDate, BikeID) VALUES ('A0014', '2011-02-02', 'NNN5')
  552. INSERT INTO Repair(MaintID, MaintDate, BikeID) VALUES ('A0015', '2012-03-03', 'OOO6')
  553. INSERT INTO Repair(MaintID, MaintDate, BikeID) VALUES ('A0018', '2017-01-02', '1AAA')
  554. INSERT INTO Repair(MaintID, MaintDate, BikeID) VALUES ('A0019', '2017-09-02', '1AAA')
  555. INSERT INTO Repair(MaintID, MaintDate, BikeID) VALUES ('A0020', '2016-06-07', 'LLL3')
  556. INSERT INTO Repair(MaintID, MaintDate, BikeID) VALUES ('A0021', '2016-02-03', 'LLL3')
  557. INSERT INTO Repair(MaintID, MaintDate, BikeID) VALUES ('A0022', '2016-03-04', 'OOO6')
  558. INSERT INTO Repair(MaintID, MaintDate, BikeID) VALUES ('A0023', '2016-04-05', 'OOO6')
  559. INSERT INTO Repair(MaintID, MaintDate, BikeID) VALUES ('A0024', '2015-01-06', 'NNN5')
  560. INSERT INTO Repair(MaintID, MaintDate, BikeID) VALUES ('A0025', '2015-01-05', 'NNN5')
  561.  
  562. INSERT INTO Fault VALUES('10001','2017-02-10 01:02:35','tire', 'HHHHH8','TI-1','OOO6', 'A0015')
  563. INSERT INTO Fault VALUES('20002','2017-05-13 03:09:23','basket', 'CCCCC3','BA-1','NNN5', 'A0014')
  564. INSERT INTO Fault VALUES('30003','2016-03-26 23:02:13', 'lock', 'GGGGG7','TI-2','MMM4', 'A0013')
  565. INSERT INTO Fault VALUES('40004','2016-07-17 12:24:45', 'others', '66666G','SE-1','LLL3', 'A0012')
  566. INSERT INTO Fault VALUES('50005','2015-07-06 07:12:07', 'pedal', 'AAAAA1','LO-1','KKK2', 'A0011')
  567. INSERT INTO Fault VALUES('60006','2015-10-09 06:23:46', 'frame', 'HHHHH8','LO-2','JJJ1', 'A0010')
  568. INSERT INTO Fault VALUES('70007','2014-01-19 03:59:00', 'basket', 'CCCCC3','BA-2','9III', 'A0009')
  569. INSERT INTO Fault VALUES('80008','2014-04-03 14:34:25', 'tire', '99999J','PE-1','8HHH', 'A0008')
  570. INSERT INTO Fault VALUES('90009','2013-02-20 16:45:50', 'frame', 'JJJJJ1','OO-1','7GGG', 'A0007')
  571. INSERT INTO Fault VALUES('11011','2013-07-21 20:34:01', 'basket', 'HHHHH8','SE-2','6FFF', 'A0006')
  572. INSERT INTO Fault VALUES('22022','2012-08-26 18:09:23', 'pedal', 'BBBBB2','TI-3','5EEE', 'A0005')
  573. INSERT INTO Fault VALUES('33033','2012-02-14 06:45:50', 'tire', 'IIIII9','FR-2','4DDD', 'A0004')
  574. INSERT INTO Fault VALUES('44044','2011-03-18 04:34:10', 'others', 'HHHHH8','PE-2','3CCC', 'A0003')
  575. INSERT INTO Fault VALUES('55055','2011-06-22 16:23:57', 'lock', 'IIIII9','BA-3','2BBB', 'A0002')
  576. INSERT INTO Fault VALUES('66066','2010-04-22 18:34:49', 'basket', 'CCCCC3','FR-1','1AAA', 'A0001')
  577. INSERT INTO Fault VALUES('77077','2017-01-01 01:31:01', 'tire', 'FFFFF6', 'OO-2', '1AAA', 'A0018')
  578. INSERT INTO Fault VALUES('88088','2017-09-01 17:30:00', 'lock', '44444E', 'TP-1', '1AAA', 'A0019')
  579. INSERT INTO Fault VALUES('99099','2016-06-06 03:46:06', 'basket', '88888I', 'TP-2', 'LLL3', 'A0020')
  580. INSERT INTO Fault VALUES('11111','2016-02-02 02:22:31', 'frame', 'KKKKK2', 'PO-1', 'LLL3', 'A0021')
  581. INSERT INTO Fault VALUES('22122','2016-03-03 15:21:01', 'others', 'AAAAA1', 'PO-2', 'OOO6', 'A0022')
  582. INSERT INTO Fault VALUES('33133','2016-04-04 14:00:00', 'pedal', 'DDDDD4', 'TA-1', 'OOO6', 'A0023')
  583. INSERT INTO Fault VALUES('44144','2015-01-04 14:00:00', 'frame', 'BBBBB2', 'AS-1', 'NNN5', 'A0024')
  584. INSERT INTO Fault VALUES('55155','2015-01-04 14:00:00', 'tire', 'GGGGG7', 'AS-2', 'NNN5', 'A0025')
  585.  
  586. INSERT INTO MaintType(TypeCode, TypeDesc) VALUES ('AAA01', 'TDesc01')
  587. INSERT INTO MaintType(TypeCode, TypeDesc) VALUES ('AAA02', 'TDesc02')
  588. INSERT INTO MaintType(TypeCode, TypeDesc) VALUES ('AAA03', 'TDesc03')
  589. INSERT INTO MaintType(TypeCode, TypeDesc) VALUES ('AAA04', 'TDesc04')
  590. INSERT INTO MaintType(TypeCode, TypeDesc) VALUES ('AAA05', 'TDesc05')
  591. INSERT INTO MaintType(TypeCode, TypeDesc) VALUES ('AAA06', 'TDesc06')
  592. INSERT INTO MaintType(TypeCode, TypeDesc) VALUES ('AAA07', 'TDesc07')
  593. INSERT INTO MaintType(TypeCode, TypeDesc) VALUES ('AAA08', 'TDesc08')
  594. INSERT INTO MaintType(TypeCode, TypeDesc) VALUES ('AAA09', 'TDesc09')
  595. INSERT INTO MaintType(TypeCode, TypeDesc) VALUES ('AAA10', 'TDesc10')
  596. INSERT INTO MaintType(TypeCode, TypeDesc) VALUES ('AAA11', 'TDesc11')
  597. INSERT INTO MaintType(TypeCode, TypeDesc) VALUES ('AAA12', 'TDesc12')
  598. INSERT INTO MaintType(TypeCode, TypeDesc) VALUES ('AAA13', 'TDesc13')
  599. INSERT INTO MaintType(TypeCode, TypeDesc) VALUES ('AAA14', 'TDesc14')
  600. INSERT INTO MaintType(TypeCode, TypeDesc) VALUES ('AAA15', 'TDesc15')
  601.  
  602. INSERT INTO MaintType(TypeCode, TypeDesc) VALUES ('AAA16', 'TDesc16')
  603. INSERT INTO MaintType(TypeCode, TypeDesc) VALUES ('AAA17', 'TDesc17')
  604. INSERT INTO MaintType(TypeCode, TypeDesc) VALUES ('AAA18', 'TDesc18')
  605. INSERT INTO MaintType(TypeCode, TypeDesc) VALUES ('AAA19', 'TDesc19')
  606. INSERT INTO MaintType(TypeCode, TypeDesc) VALUES ('AAA20', 'TDesc20')
  607. INSERT INTO MaintType(TypeCode, TypeDesc) VALUES ('AAA21', 'TDesc21')
  608. INSERT INTO MaintType(TypeCode, TypeDesc) VALUES ('AAA22', 'TDesc22')
  609. INSERT INTO MaintType(TypeCode, TypeDesc) VALUES ('AAA23', 'TDesc23')
  610.  
  611. INSERT INTO MaintItem(SNo, MaintID, MaintDesc, TypeCode) VALUES ('01',  'A0015', 'Mdesc01', 'AAA15')
  612. INSERT INTO MaintItem(SNo, MaintID, MaintDesc, TypeCode) VALUES ('02',  'A0014', 'Mdesc04', 'AAA14')
  613. INSERT INTO MaintItem(SNo, MaintID, MaintDesc, TypeCode) VALUES ('03',  'A0013', 'Mdesc05', 'AAA13')
  614. INSERT INTO MaintItem(SNo, MaintID, MaintDesc, TypeCode) VALUES ('04',  'A0012', 'Mdesc06', 'AAA12')
  615. INSERT INTO MaintItem(SNo, MaintID, MaintDesc, TypeCode) VALUES ('05',  'A0011', 'Mdesc07', 'AAA11')
  616. INSERT INTO MaintItem(SNo, MaintID, MaintDesc, TypeCode) VALUES ('06',  'A0010', 'Mdesc02', 'AAA10')
  617. INSERT INTO MaintItem(SNo, MaintID, MaintDesc, TypeCode) VALUES ('07',  'A0009', 'Mdesc03', 'AAA09')
  618. INSERT INTO MaintItem(SNo, MaintID, MaintDesc, TypeCode) VALUES ('08',  'A0008', 'Mdesc02', 'AAA08')
  619. INSERT INTO MaintItem(SNo, MaintID, MaintDesc, TypeCode) VALUES ('09',  'A0007', 'Mdesc01', 'AAA07')
  620. INSERT INTO MaintItem(SNo, MaintID, MaintDesc, TypeCode) VALUES ('10',  'A0006', 'Mdesc05', 'AAA06')
  621. INSERT INTO MaintItem(SNo, MaintID, MaintDesc, TypeCode) VALUES ('11',  'A0005', 'Mdesc08', 'AAA05')
  622. INSERT INTO MaintItem(SNo, MaintID, MaintDesc, TypeCode) VALUES ('12',  'A0004', 'Mdesc10', 'AAA04')
  623. INSERT INTO MaintItem(SNo, MaintID, MaintDesc, TypeCode) VALUES ('13',  'A0003', 'Mdesc06', 'AAA03')
  624. INSERT INTO MaintItem(SNo, MaintID, MaintDesc, TypeCode) VALUES ('14',  'A0002', 'Mdesc04', 'AAA02')
  625. INSERT INTO MaintItem(SNo, MaintID, MaintDesc, TypeCode) VALUES ('15',  'A0001', 'Mdesc07', 'AAA01')
  626.  
  627. INSERT INTO CreditCard VALUES('Card01', 'Visa', '2019-01-01', '000', 'FFFFF6')
  628. INSERT INTO CreditCard VALUES('Card02', 'Master', '2020-01-01', '001', '66666G')
  629. INSERT INTO CreditCard VALUES('Card03', 'Diners', '2021-01-01', '002', 'FFFFF6')
  630. INSERT INTO CreditCard VALUES('Card04', 'Master', '2021-01-01', '003', 'BBBBB2')
  631. INSERT INTO CreditCard VALUES('Card05', 'Express', '2022-01-01', '004', '22222C')
  632. INSERT INTO CreditCard VALUES('Card06', 'Chase', '2022-01-01', '005', '77777H')
  633. INSERT INTO CreditCard VALUES('Card07', 'Visa', '2022-01-01', '006', 'EEEEE5')
  634. INSERT INTO CreditCard VALUES('Card08', 'Visa', '2022-01-01', '007', '11111B')
  635. INSERT INTO CreditCard VALUES('Card09', 'Diners', '2022-01-01', '008', '55555F')
  636. INSERT INTO CreditCard VALUES('Card10', 'Express', '2022-01-01', '009', '11111B')
  637. INSERT INTO CreditCard VALUES('Card11', 'Visa', '2022-01-01', '010', '55555F')
  638. INSERT INTO CreditCard VALUES('Card12', 'Visa', '2022-01-01', '011', '44444E')
  639. INSERT INTO CreditCard VALUES('Card13', 'Visa', '2019-01-01', '012', 'FFFFF6')
  640. INSERT INTO CreditCard VALUES('Card14', 'Master', '2019-01-01', '013', '33333D')
  641. INSERT INTO CreditCard VALUES('Card15', 'Chase', '2019-01-01', '014', 'AAAAA1')
  642. INSERT INTO CreditCard VALUES('Card16', 'Master', '2020-04-04', '015', 'JJJJJ1')
  643. INSERT INTO CreditCard VALUES('Card17', 'Visa', '2021-05-05', '016', 'KKKKK2')
  644. INSERT INTO CreditCard VALUES('Card18', 'Express', '2020-09-09', '017', '88888I')
  645. INSERT INTO CreditCard VALUES('Card19', 'Chase', '2020-10-10', '018', 'CCCCC3')
  646.  
  647.  
  648. INSERT INTO CreditDebitTrans VALUES ('A00001', '1.50', 'Debit', '2018-01-01 01:31:01', 'card01', '1AAAAA')
  649. INSERT INTO CreditDebitTrans VALUES ('A00002', '1.00', 'Credit', '2017-11-04 13:31:01', 'card11', '1BBBBB')
  650. INSERT INTO CreditDebitTrans VALUES ('A00003', '0.50', 'Debit', '2009-04-05 14:10:00', 'card03', '1CCCCC')
  651. INSERT INTO CreditDebitTrans VALUES ('A00004', '2.00', 'Credit', '2017-10-06 14:10:00', 'card01', '1DDDDD')
  652. INSERT INTO CreditDebitTrans VALUES ('A00005', '1.50', 'Debit', '2017-09-01 17:30:00', 'card05', '1EEEEE')
  653. INSERT INTO CreditDebitTrans VALUES ('A00006', '1.00', 'Credit', '2011-04-04 05:34:04', 'card10', '1FFFFF')
  654. INSERT INTO CreditDebitTrans VALUES ('A00007', '1.50', 'Debit', '2013-08-08 08:43:08', 'card01', '1GGGGG')
  655. INSERT INTO CreditDebitTrans VALUES ('A00008', '2.00', 'Credit', '2011-07-07 09:10:00', 'card05', '1HHHHH')
  656. INSERT INTO CreditDebitTrans VALUES ('A00009', '1.00', 'Debit', '2012-06-06 01:46:06', 'card06', '1IIIII')
  657. INSERT INTO CreditDebitTrans VALUES ('A00010', '0.50', 'Credit', '2012-10-10 09:49:46', 'card07', '1JJJJJ')
  658. INSERT INTO CreditDebitTrans VALUES ('A00011', '0.50', 'Debit', '2013-01-01 02:01:01', 'card08', '1KKKKK')
  659. INSERT INTO CreditDebitTrans VALUES ('A00012', '0.50', 'Credit', '2013-01-01 02:01:01', 'card09', '1LLLLL')
  660. INSERT INTO CreditDebitTrans VALUES ('A00013', '2.50', 'Debit', '2017-09-01 03:01:01', 'card05', '1MMMMM')
  661. INSERT INTO CreditDebitTrans VALUES ('A00014', '1.50', 'Credit', '2017-11-04 15:19:14', 'card03', '1NNNNN')
  662. INSERT INTO CreditDebitTrans VALUES ('A00015', '0.50', 'Debit', '2014-11-11 10:30:10', 'card13', '1OOOOO')
  663. INSERT INTO CreditDebitTrans VALUES ('A00016', '1.50', 'Debit', '2018-01-10 02:01:01', 'card03', '1PPPPP')
  664. INSERT INTO CreditDebitTrans VALUES ('A00017', '2.50', 'Credit', '2014-01-01 01:51:01', 'card07', '1QQQQQ')
  665. INSERT INTO CreditDebitTrans VALUES ('A00018', '0.50', 'Credit', '2017-02-02 13:30:00', 'Card16', '1RRRRR')
  666. INSERT INTO CreditDebitTrans VALUES ('A00019', '0.50', 'Debit', '2017-12-05 15:00:00', 'Card17', '1SSSSS')
  667. INSERT INTO CreditDebitTrans VALUES ('A00023', '0.50', 'Debit', '2016-09-20 01:30:00', 'Card05', '1WWWWW')
  668. INSERT INTO CreditDebitTrans VALUES ('A00024', '0.50', 'Credit', '2016-09-22 12:10:00', 'Card18', '1XXXXX')
  669. INSERT INTO CreditDebitTrans VALUES ('A00025', '0.70', 'Credit', '2016-09-25 00:00:00', 'Card19', '1YYYYY')
  670. INSERT INTO CreditDebitTrans VALUES ('A00026', '0.50', 'Debit', '2016-09-26 05:20:00', 'Card10', '1ZZZZZ')
  671. INSERT INTO CreditDebitTrans VALUES ('A00020', '0.50', 'Credit', '2017-06-06 16:10:00', 'Card14', '1TTTTT')
  672. INSERT INTO CreditDebitTrans VALUES ('A00021', '0.50', 'Credit', '2017-07-07 15:00:00', 'Card04', '1UUUUU')
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!