-
Notifications
You must be signed in to change notification settings - Fork 0
/
fake_data_holdrequest.sql
21 lines (14 loc) · 1.28 KB
/
fake_data_holdrequest.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
INSERT INTO HoldRequest VALUES(hid_counter.nextVal, 4001, 'ROWLING HPPhilosopher', '2015-10-10');
INSERT INTO HoldRequest VALUES(hid_counter.nextVal, 4003, 'ROWLING HPPhilosopher', '2015-11-11');
INSERT INTO HoldRequest VALUES(hid_counter.nextVal, 4004, 'ROWLING HPPhilosopher', '2015-12-12');
INSERT INTO HoldRequest VALUES(hid_counter.nextVal, 4002, 'ROWLING HPChamber', '2013-10-10');
INSERT INTO HoldRequest VALUES(hid_counter.nextVal, 4002, 'ROWLING HPChamber', '2014-10-10');
INSERT INTO HoldRequest VALUES(hid_counter.nextVal, 4001, 'ROWLING HPPrisoner', '2017-10-10');
INSERT INTO HoldRequest VALUES(hid_counter.nextVal, 4004, 'ROWLING HPGoblet', '2018-10-10');
INSERT INTO HoldRequest VALUES(hid_counter.nextVal, 4005, 'ROWLING HPOrder', '2019-10-10');
INSERT INTO HoldRequest VALUES(hid_counter.nextVal, 4003, 'ROWLING HPHalf', '2013-3-15');
INSERT INTO HoldRequest VALUES(hid_counter.nextVal, 4003, 'ROWLING HPHalf', '2013-4-20');
INSERT INTO HoldRequest VALUES(hid_counter.nextVal, 4002, 'ROWLING HPDeathly', '2011-2-2');
INSERT INTO HoldRequest VALUES(hid_counter.nextVal, 4002, 'ROWLING HPDeathly', '2011-5-5');
INSERT INTO HoldRequest VALUES(hid_counter.nextVal, 4003, 'STEWART Calculus', '2020-10-10');
INSERT INTO HoldRequest VALUES(hid_counter.nextVal, 4001, 'BIBLE', '2020-10-10');