In this task we implemented the first part of a system that verifies the following access control rule. An item can be added to an order only by a user who created the order. If you skipped the Prologue section of specification Laboratory 4 then it is recommended to read it now. Implement SQL script solution1.sql that performs the following actions. (1) First, the script creates a relational table to store information about a new order key and a name of user who created a new order. (2) Next, the script creates a database trigger, that automatically inserts into a relational table created in the previous step, a key of a new order and a name of a user who created the order. If an order is deleted then the trigger must automatically delete information about an order key and a user who earlier created the order. A type of a trigger is up to you. (3) Next, the script comprehensively tests the trigger. A test must include listing of the contents of a table with order keys and user names, insertion of an order, listing of the contents of the table again, deletion of an order, and listing of the contents of the table again.
set echo on set feedback on set linesize 100 set pagesize 1000 spool dbcreate /* ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ */ /* The relational tables of TPC HR benchmark database */ /* ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ */ CREATE TABLE REGION( R_REGIONKEYNUMBER(12)NOT NULL, R_NAMECHAR(25)NOT NULL, R_COMMENTVARCHAR(152)NOT NULL, CONSTRAINT REGION_PKEY PRIMARY KEY(R_REGIONKEY), CONSTRAINT REGION_CHECK1 CHECK(R_REGIONKEY >= 0) ); CREATE TABLE NATION( N_NATIONKEYNUMBER(12)NOT NULL, N_NAMECHAR(25)NOT NULL, N_REGIONKEYNUMBER(12)NOT NULL, N_COMMENTVARCHAR(152)NOT NULL, CONSTRAINT NATION_PKEY PRIMARY KEY (N_NATIONKEY), CONSTRAINT NATION_FKEY1 FOREIGN KEY (N_REGIONKEY) REFERENCES REGION(R_REGIONKEY), CONSTRAINT NATION_CHECK1 CHECK(N_NATIONKEY >= 0) ); CREATE TABLE PART( P_PARTKEY NUMBER(12) NOT NULL, P_NAMEVARCHAR(55)NOT NULL, P_MFGRVARCHAR(25)NOT NULL, P_BRANDCHAR(10)NOT NULL, P_TYPEVARCHAR(25)NOT NULL, P_SIZENUMBER(12)NOT NULL, P_CONTAINER CHAR(10)NOT NULL, P_RETAILPRICENUMBER(12,2)NOT NULL, P_COMMENTVARCHAR(23)NOT NULL, CONSTRAINT PART_PEKEY PRIMARY KEY (P_PARTKEY), CONSTRAINT PART_CHECK1 CHECK(P_PARTKEY >= 0), CONSTRAINT PART_CHECK2 CHECK(P_SIZE >= 0), CONSTRAINT PART_CHECK3 CHECK(P_RETAILPRICE >= 0) ); CREATE TABLE SUPPLIER( S_SUPPKEY NUMBER(12)NOT NULL, S_NAMECHAR(25)NOT NULL, S_ADDRESSVARCHAR(40)NOT NULL, S_NATIONKEYNUMBER(12)NOT NULL, S_PHONE CHAR(15)NOT NULL, S_ACCTBALNUMBER(12,2)NOT NULL, S_COMMENTVARCHAR(101)NOT NULL, CONSTRAINT SUPPLIER_PKEY PRIMARY KEY (S_SUPPKEY), CONSTRAINT SUPPLIER_FKEY1 FOREIGN kEY (S_NATIONKEY) REFERENCES NATION(N_NATIONKEY), CONSTRAINT SUPPLIER_CHECK1 CHECK(S_SUPPKEY >= 0) ); CREATE TABLE PARTSUPP( PS_PARTKEY NUMBER(12)NOT NULL, PS_SUPPKEYNUMBER(12)NOT NULL, PS_AVAILQTYNUMBER(12)NOT NULL, PS_SUPPLYCOSTNUMBER(12,2)NOT NULL, PS_COMMENTVARCHAR(199)NOT NULL, CONSTRAINT PARTSUPP_PKEY PRIMARY KEY (PS_PARTKEY, PS_SUPPKEY), CONSTRAINT PARTSUPP_FKEY1 FOREIGN KEY (PS_PARTKEY) REFERENCES PART(P_PARTKEY), CONSTRAINT PARTSUPP_FKEY2 FOREIGN kEY (PS_SUPPKEY) REFERENCES SUPPLIER(S_SUPPKEY), CONSTRAINT PARTSUPP_CHECK1 CHECK(PS_PARTKEY >= 0), CONSTRAINT PARTSUPP_CHECK2 CHECK(PS_AVAILQTY >= 0), CONSTRAINT PARTSUPP_CHECK3 CHECK(PS_SUPPLYCOST >= 0) ); CREATE TABLE CUSTOMER( C_CUSTKEYNUMBER(12)NOT NULL, C_NAME VARCHAR(25)NOT NULL, C_ADDRESSVARCHAR(40)NOT NULL, C_NATIONKEYNUMBER(12)NOT NULL, C_PHONECHAR(15)NOT NULL, C_ACCTBALNUMBER(12,2)NOT NULL, C_MKTSEGMENTCHAR(10)NOT NULL, C_COMMENTVARCHAR(117)NOT NULL, CONSTRAINT CUSTOMER_PKEY PRIMARY KEY(C_CUSTKEY), CONSTRAINT CUSTOMER_FKEY1 FOREIGN kEY (C_NATIONKEY) REFERENCES NATION(N_NATIONKEY), CONSTRAINT CUSTOMER_CHECK1 CHECK(C_CUSTKEY >= 0) ); CREATE TABLE ORDERS( O_ORDERKEYNUMBER(12)NOT NULL, O_CUSTKEYNUMBER(12)NOT NULL, O_ORDERSTATUSCHAR(1)NOT NULL, O_TOTALPRICENUMBER(12,2)NOT NULL, O_ORDERDATEDATENOT NULL, O_ORDERPRIORITY CHAR(15)NOT NULL, O_CLERKCHAR(15)NOT NULL, O_SHIPPRIORITYNUMBER(12)NOT NULL, O_COMMENTVARCHAR(79)NOT NULL, CONSTRAINT ORDERS_PKEY PRIMARY KEY (O_ORDERKEY), CONSTRAINT ORDERS_FKEY1 FOREIGN kEY (O_CUSTKEY) REFERENCES CUSTOMER(C_CUSTKEY), CONSTRAINT ORDER_CHECK1 CHECK( O_TOTALPRICE >= 0) ); CREATE TABLE LINEITEM( L_ORDERKEY NUMBER(12)NOT NULL, L_PARTKEYNUMBER(12)NOT NULL, L_SUPPKEYNUMBER(12)NOT NULL, L_LINENUMBERNUMBER(12)NOT NULL, L_QUANTITYNUMBER(12,2)NOT NULL, L_EXTENDEDPRICE NUMBER(12,2)NOT NULL, L_DISCOUNTNUMBER(12,2)NOT NULL, L_TAXNUMBER(12,2)NOT NULL, L_RETURNFLAGCHAR(1)NOT NULL, L_LINESTATUSCHAR(1)NOT NULL, L_SHIPDATEDATENOT NULL, L_COMMITDATEDATENOT NULL, L_RECEIPTDATEDATENOT NULL, L_SHIPINSTRUCTCHAR(25)NOT NULL, L_SHIPMODECHAR(10)NOT NULL, L_COMMENTVARCHAR(44)NOT NULL, CONSTRAINT LINEITEM_PKEY PRIMARY KEY (L_ORDERKEY, L_LINENUMBER), CONSTRAINT LINEITEM_FKEY1 FOREIGN kEY (L_ORDERKEY) REFERENCES ORDERS(O_ORDERKEY), CONSTRAINT LINEITEM_FKEY2 FOREIGN KEY (L_PARTKEY) REFERENCES PART(P_PARTKEY), CONSTRAINT LINEITEM_FKEY3 FOREIGN KEY (L_PARTKEY,L_SUPPKEY) REFERENCES PARTSUPP(PS_PARTKEY, PS_SUPPKEY), CONSTRAINT LINEITEM_FKEY4 FOREIGN kEY (L_SUPPKEY) REFERENCES SUPPLIER(S_SUPPKEY), CONSTRAINT LINEITEM_CHECK1 CHECK (L_QUANTITY >= 0), CONSTRAINT LINEITEM_CHECK2 CHECK (L_EXTENDEDPRICE >= 0), CONSTRAINT LINEITEM_CHECK3 CHECK (L_TAX >= 0), CONSTRAINT LINEITEM_CHECK4 CHECK (L_DISCOUNT BETWEEN 0.00 AND 1.00) ); /* ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ */ /* Multitable constraints */ /*1.L_SHIPDATE <= l_receiptdate="" */="" *="" 2.o_orderdate=""><= l_shipdate="" */="" *="" 3.o_orderdate=""><= l_commitdate */ /* ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ */ /* ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ */ /* end of script */ /* ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ */ spool off spool dbload set echo on set feedback on set linesize 100 set pagesize 1000 insert into region values(0,'africa','special tiresias about the furiously even dolphins are furi'); insert into region values(1,'north america','even, ironic theodolites according to the bold platelets wa'); insert into region values(2,'asia','silent, bold requests sleep slyly across the quickly sly dependencies. furiously silent instructions alongside'); insert into region values(3,'australia','special, bold deposits haggle foxes. platelet'); insert into region values(4,'europe','furiously unusual packages use carefully above the unusual, exp'); insert into region values(5,'south america','carefully final platelets haggle even, bold accounts. final theodolites at the foxes nag quickly about the fluf'); insert into region values(6,'middle east','unusual accounts cajole slyly '); insert into region values(7,'oceania','pending deposits detect carefully. carefully final idea'); insert into region values(8,'south america','carefully pending dependencies haggle carefully among the quickly ironic deposits. packages cajole. ironic a'); insert into region values(9,'central america','fluffily unusual foxes grow even, bold instructions. always regular courts haggle. evenly unusual account'); insert into nation values(0,'algeria',0,'final accounts wake quickly. special reques'); insert into nation values(1,'sudan',0,'idly final instructions cajole stealthily. regular instructions wake carefully blithely express accounts. fluffi'); insert into nation values(2,'australia',2,'always pending pinto beans sleep sil'); insert into nation values(3,'brazil',2,'foxes among the bold requests'); insert into nation values(4,'canada',2,'pending accounts haggle furiously. furiously bold accounts detect. platelets at the packages haggle caref'); insert into nation values(5,'china',3,'fluffily ruthless requests integrate fluffily. pending ideas wake blithely acco'); insert into nation values(6,'egypt',6,'even requests detect near the pendin'); insert into nation values(7,'ethiopia',2,'blithely ironic foxes grow. quickly pending accounts are b'); insert into nation values(8,'france',5,'ironic packages should have to are slyly around the special, ironic accounts. iron'); insert into nation values(9,'germany',5,'unusual excuses are quickly requests. slyly ironic accounts haggle carefully above the pendin'); insert into nation values(10,'india',4,'blithely even accounts about the furiously regular foxes nag slyly final accounts. quickly final fo'); insert into nation values(11,'indonesia',4,'express, pending deposits boost quick'); insert into nation values(12,'iran',6,'blithely final packages cajole quickly even dependencies? blithely regular deposits haggle express, ironic re'); insert into nation values(13,'iraq',6,'blithe, express deposits boost carefully busy accounts. furiously pending depos'); insert into nation values(14,'india',7,'ironic requests boost. quickly pending pinto beans cajole slyly slyly even deposits. ironic packages '); insert into nation values(15,'japan',5,'ideas according to the fluffily final pinto beans sleep furiously'); insert into nation values(16,'jordan',7,'ironic courts wake fluffily even, bold deposi'); insert into nation values(17,'kenya',3,'final, final accounts sleep slyly across the requests. '); insert into nation values(18,'malawi',4,'bold accounts are. slyly ironic escapades haggle acc'); insert into nation values(19,'morocco',4,'deposits boost against the brave id'); insert into nation values(20,'mozambique',4,'fluffily final accounts wake slyly-- fi'); insert into nation values(21,'peru',5,'doggedly ironic requests haggle furiously ironic, ironic packages. furiously final courts wake fur'); insert into nation values(22,'poland',6,'slowly pending patterns x-ray quickly. ironic, even accounts haggle furiously. even, final deposits mold bl'); insert into nation values(23,'china',7,'fluffily regular pinto beans breach according to the ironic dolph'); insert into nation values(24,'romania',8,'blithely regular deposits serve furiously blithely regular warthogs! slyly fi'); insert into nation values(25,'saudi arabia',9,'instructions haggle carefully carefully ironic pinto beans. slyly sly requests'); insert into nation values(26,'vietnam',7,'express deposits haggle final frays? even deposits boost'); insert into nation values(27,'russia',8,'deposits cajole fluffily. dogged accounts nag. regular deposits do snooze! express deposits cajole ironic deposits'); insert into nation values(28,'rwnda',9,'quickly even asymptotes are about the quickly even foxes. thin instructions us'); insert into nation values(29,'united kingdom',9,'special accounts wake carefully carefull'); insert into customer values(1,'customer#000000001','j5jsirbm9pscy0o1m',18,'28-989-741-2988',711.56,'building','regular, regular platelets are fluffily according to the even attainments. blithely iron' ); insert into customer values(2,'customer#000000002','487lw1dovn6q4dmvymkwwle9okf3qg',16,'26-768-687-3665',121.65,'automobile','furiously special deposits solve slyly. furiously even foxes wake alongside of the furiously ironic ideas. pending' ); insert into customer values(3,'customer#000000003','fkrgn8ny4pke',1,'11-719-748-3364',7498.12,'automobile','special packages wake. slyly reg' ); insert into customer values(4,'customer#000000004','4u58h fqkye',5,'15-128-190-5944',2866.83,'machinery','slyly final accounts sublate carefully. slyly ironic asymptotes nod across the quickly regular pack' ); insert into customer values(5,'customer#000000005','hwbtxkobf qsw4krik5u 2b1au7h',4,'14-750-942-6364',794.47,'household','blithely final instructions haggle; stealthy sauternes nod; carefully regu' ); insert into customer values(6,'customer#000000006',' g1s,pzdenuebw3o,2 pxu0f9n2g64rjrt5e',24,'34-114-968-4951',7638.57,'automobile','special deposits wake along the ironic foxes. slyly regular deposits are furiously about the blith' ); insert into customer values(7,'customer#000000007','8okmvlq1dk6mbu6wg9 w4plgq n7mq',22,'32-190-982-9759',9561.95,'automobile','theodolites kindle carefully carefully regular deposits. regular depe' ); insert into customer values(8,'customer#000000002','xstf4,ncwdvawne6tegvwfmrchlxak',13,'23-768-687-3665',121.65,'automobile','furiously special deposits solve slyly. furiously even foxes wake alongside of the furiously ironic ideas. pending'); insert into customer values(9,'customer#000000003','mg9kdtd2wbhm',1,'11-719-748-3364',7498.12,'automobile','special packages wake. slyly reg'); insert into customer values(10,'customer#000000004','xxvsjslagtn',4,'14-128-190-5944',2866.83,'machinery','slyly final accounts sublate carefully. slyly ironic asymptotes nod across the quickly regular pack'); insert into customer values(11,'customer#000000005','kvpyuhcplrb84wgaigv6sypzq7tj',3,'13-750-942-6364',794.47,'household','blithely final instructions haggle; stealthy sauternes nod; carefully regu'); insert into customer values(12,'customer#000000006','skzz0csnmd7mp4xd0yrbvx,lreykuwah yvn',20,'30-114-968-4951',7638.57,'automobile','special deposits wake along the ironic foxes. slyly regular deposits are furiously about the blith'); insert into customer values(13,'customer#000000007','tcge5gazngvepxu5krrvxbfkasdtea',18,'28-190-982-9759',9561.95,'automobile','theodolites kindle carefully carefully regular deposits. regular depe'); insert into customer values(14,'customer#000000008','i0b10bb0aymmc, 0prrybcp1ygj8xcbpmwhl5',17,'27-147-574-9335',6819.74,'building','ironic deposits are quickly after the gifts. regular dependencies hinder slyly after the quickly ex'); insert into customer values(15,'customer#000000009','xkiaftjuscuxfelenqefumtrjs',8,'18-338-906-3675',8324.07,'furniture','deposits affix fluffily. blithely final ideas are furiously dolphins. i'); insert into customer values(16,'customer#000000010','6lreav6kr6plvcgl2arl q3rqzlzct1 v2',5,'15-741-346-9870',2753.54,'household','bold, final frays sleep carefully special ideas. carefully final asymptotes sleep furiously against the even i'); insert into orders values(1,2,'o',125093.31,to_date('1996-01-02','yyyy-mm-dd'),'5-low','clerk#000000951',0,'blithely final dolphins solve-- blithely blithe packages nag blith' ); insert into orders values(2,4,'o',36149.40,to_date('1996-12-01','yyyy-mm-dd'),'1-urgent','clerk#000000880',0,'quickly regular depend'); insert into orders values(3,7,'f',150408.27,to_date('1993-10-14','yyyy-mm-dd'),'5-low','clerk#000000955',0,'deposits alongside of the dependencies are slowly about '); insert into orders values(4,7,'o',28442.34,to_date('1995-10-11','yyyy-mm-dd'),'5-low','clerk#000000124',0,'final requests detect slyly across the blithely bold pinto beans. eve'); insert into orders values(5,4,'f',80273.44,to_date('1994-07-30','yyyy-mm-dd'),'5-low','clerk#000000925',0,'even deposits cajole furiously. quickly spe'); insert into orders values(6,4,'f',31800.50,to_date('1992-02-21','yyyy-mm-dd'),'4-not specified','clerk#000000058',0,'ironically bold asymptotes sleep blithely beyond the regular, clos'); insert into orders values(7,2,'o',151486.24,to_date('1996-01-10','yyyy-mm-dd'),'2-high','clerk#000000470',0,'ironic, regular deposits are. ironic foxes sl'); insert into orders values(32,7,'o',105035.28,to_date('1995-07-16','yyyy-mm-dd'),'2-high','clerk#000000616',0,'slyly final foxes are slyly. packag'); insert into orders values(33,4,'f',94379.93,to_date('1993-10-27','yyyy-mm-dd'),'3-medium','clerk#000000409',0,'packages maintain about the deposits; foxes hang after '); insert into orders values(34,4,'o',37670.39,to_date('1998-07-21','yyyy-mm-dd'),'3-medium','clerk#000000223',0,'quickly express asymptotes use. carefully final packages sleep f'); insert into orders values(35,7,'o',136133.28,to_date('1995-10-23','yyyy-mm-dd'),'4-not specified','clerk#000000259',0,'fluffily regular pinto beans '); insert into orders values(36,7,'o',34627.32,to_date('1995-11-03','yyyy-mm-dd'),'1-urgent','clerk#000000358',0,'carefully ironic accounts nag'); insert into orders values(37,5,'f',107844.52,to_date('1992-06-03','yyyy-mm-dd'),'3-medium','clerk#000000456',0,'express requests ar'); insert into orders values(38,7,'o',39164.08,to_date('1996-08-21','yyyy-mm-dd'),'4-not specified','clerk#000000604',0,'slyly quick pinto beans detect flu'); insert into orders values(39,4,'o',205834.99,to_date('1996-09-20','yyyy-mm-dd'),'3-medium','clerk#000000659',0,'furiously unusual pinto beans above the furiously ironic asymptot'); insert into orders values(64,2,'f',18415.84,to_date('1994-07-16','yyyy-mm-dd'),'3-medium','clerk#000000661',0,'final deposits nag. blithely special deposits a'); insert into orders values(65,1,'p',62762.63,to_date('1995-03-18','yyyy-mm-dd'),'1-urgent','clerk#000000632',0,'furiously even platelets boost ironic theodolites. even '); insert into orders values(66,7,'f',68615.59,to_date('1994-01-20','yyyy-mm-dd'),'5-low','clerk#000000743',0,'ironic requests l_commitdate="" */="" *="" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~="" */="" *="" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~="" */="" *="" end="" of="" script="" */="" *="" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~="" */="" spool="" off="" spool="" dbload="" set="" echo="" on="" set="" feedback="" on="" set="" linesize="" 100="" set="" pagesize="" 1000="" insert="" into="" region="" values(0,'africa','special="" tiresias="" about="" the="" furiously="" even="" dolphins="" are="" furi');="" insert="" into="" region="" values(1,'north="" america','even,="" ironic="" theodolites="" according="" to="" the="" bold="" platelets="" wa');="" insert="" into="" region="" values(2,'asia','silent,="" bold="" requests="" sleep="" slyly="" across="" the="" quickly="" sly="" dependencies.="" furiously="" silent="" instructions="" alongside');="" insert="" into="" region="" values(3,'australia','special,="" bold="" deposits="" haggle="" foxes.="" platelet');="" insert="" into="" region="" values(4,'europe','furiously="" unusual="" packages="" use="" carefully="" above="" the="" unusual,="" exp');="" insert="" into="" region="" values(5,'south="" america','carefully="" final="" platelets="" haggle="" even,="" bold="" accounts.="" final="" theodolites="" at="" the="" foxes="" nag="" quickly="" about="" the="" fluf');="" insert="" into="" region="" values(6,'middle="" east','unusual="" accounts="" cajole="" slyly="" ');="" insert="" into="" region="" values(7,'oceania','pending="" deposits="" detect="" carefully.="" carefully="" final="" idea');="" insert="" into="" region="" values(8,'south="" america','carefully="" pending="" dependencies="" haggle="" carefully="" among="" the="" quickly="" ironic="" deposits.="" packages="" cajole.="" ironic="" a');="" insert="" into="" region="" values(9,'central="" america','fluffily="" unusual="" foxes="" grow="" even,="" bold="" instructions.="" always="" regular="" courts="" haggle.="" evenly="" unusual="" account');="" insert="" into="" nation="" values(0,'algeria',0,'final="" accounts="" wake="" quickly.="" special="" reques');="" insert="" into="" nation="" values(1,'sudan',0,'idly="" final="" instructions="" cajole="" stealthily.="" regular="" instructions="" wake="" carefully="" blithely="" express="" accounts.="" fluffi');="" insert="" into="" nation="" values(2,'australia',2,'always="" pending="" pinto="" beans="" sleep="" sil');="" insert="" into="" nation="" values(3,'brazil',2,'foxes="" among="" the="" bold="" requests');="" insert="" into="" nation="" values(4,'canada',2,'pending="" accounts="" haggle="" furiously.="" furiously="" bold="" accounts="" detect.="" platelets="" at="" the="" packages="" haggle="" caref');="" insert="" into="" nation="" values(5,'china',3,'fluffily="" ruthless="" requests="" integrate="" fluffily.="" pending="" ideas="" wake="" blithely="" acco');="" insert="" into="" nation="" values(6,'egypt',6,'even="" requests="" detect="" near="" the="" pendin');="" insert="" into="" nation="" values(7,'ethiopia',2,'blithely="" ironic="" foxes="" grow.="" quickly="" pending="" accounts="" are="" b');="" insert="" into="" nation="" values(8,'france',5,'ironic="" packages="" should="" have="" to="" are="" slyly="" around="" the="" special,="" ironic="" accounts.="" iron');="" insert="" into="" nation="" values(9,'germany',5,'unusual="" excuses="" are="" quickly="" requests.="" slyly="" ironic="" accounts="" haggle="" carefully="" above="" the="" pendin');="" insert="" into="" nation="" values(10,'india',4,'blithely="" even="" accounts="" about="" the="" furiously="" regular="" foxes="" nag="" slyly="" final="" accounts.="" quickly="" final="" fo');="" insert="" into="" nation="" values(11,'indonesia',4,'express,="" pending="" deposits="" boost="" quick');="" insert="" into="" nation="" values(12,'iran',6,'blithely="" final="" packages="" cajole="" quickly="" even="" dependencies?="" blithely="" regular="" deposits="" haggle="" express,="" ironic="" re');="" insert="" into="" nation="" values(13,'iraq',6,'blithe,="" express="" deposits="" boost="" carefully="" busy="" accounts.="" furiously="" pending="" depos');="" insert="" into="" nation="" values(14,'india',7,'ironic="" requests="" boost.="" quickly="" pending="" pinto="" beans="" cajole="" slyly="" slyly="" even="" deposits.="" ironic="" packages="" ');="" insert="" into="" nation="" values(15,'japan',5,'ideas="" according="" to="" the="" fluffily="" final="" pinto="" beans="" sleep="" furiously');="" insert="" into="" nation="" values(16,'jordan',7,'ironic="" courts="" wake="" fluffily="" even,="" bold="" deposi');="" insert="" into="" nation="" values(17,'kenya',3,'final,="" final="" accounts="" sleep="" slyly="" across="" the="" requests.="" ');="" insert="" into="" nation="" values(18,'malawi',4,'bold="" accounts="" are.="" slyly="" ironic="" escapades="" haggle="" acc');="" insert="" into="" nation="" values(19,'morocco',4,'deposits="" boost="" against="" the="" brave="" id');="" insert="" into="" nation="" values(20,'mozambique',4,'fluffily="" final="" accounts="" wake="" slyly--="" fi');="" insert="" into="" nation="" values(21,'peru',5,'doggedly="" ironic="" requests="" haggle="" furiously="" ironic,="" ironic="" packages.="" furiously="" final="" courts="" wake="" fur');="" insert="" into="" nation="" values(22,'poland',6,'slowly="" pending="" patterns="" x-ray="" quickly.="" ironic,="" even="" accounts="" haggle="" furiously.="" even,="" final="" deposits="" mold="" bl');="" insert="" into="" nation="" values(23,'china',7,'fluffily="" regular="" pinto="" beans="" breach="" according="" to="" the="" ironic="" dolph');="" insert="" into="" nation="" values(24,'romania',8,'blithely="" regular="" deposits="" serve="" furiously="" blithely="" regular="" warthogs!="" slyly="" fi');="" insert="" into="" nation="" values(25,'saudi="" arabia',9,'instructions="" haggle="" carefully="" carefully="" ironic="" pinto="" beans.="" slyly="" sly="" requests');="" insert="" into="" nation="" values(26,'vietnam',7,'express="" deposits="" haggle="" final="" frays?="" even="" deposits="" boost');="" insert="" into="" nation="" values(27,'russia',8,'deposits="" cajole="" fluffily.="" dogged="" accounts="" nag.="" regular="" deposits="" do="" snooze!="" express="" deposits="" cajole="" ironic="" deposits');="" insert="" into="" nation="" values(28,'rwnda',9,'quickly="" even="" asymptotes="" are="" about="" the="" quickly="" even="" foxes.="" thin="" instructions="" us');="" insert="" into="" nation="" values(29,'united="" kingdom',9,'special="" accounts="" wake="" carefully="" carefull');="" insert="" into="" customer="" values(1,'customer#000000001','j5jsirbm9pscy0o1m',18,'28-989-741-2988',711.56,'building','regular,="" regular="" platelets="" are="" fluffily="" according="" to="" the="" even="" attainments.="" blithely="" iron'="" );="" insert="" into="" customer="" values(2,'customer#000000002','487lw1dovn6q4dmvymkwwle9okf3qg',16,'26-768-687-3665',121.65,'automobile','furiously="" special="" deposits="" solve="" slyly.="" furiously="" even="" foxes="" wake="" alongside="" of="" the="" furiously="" ironic="" ideas.="" pending'="" );="" insert="" into="" customer="" values(3,'customer#000000003','fkrgn8ny4pke',1,'11-719-748-3364',7498.12,'automobile','special="" packages="" wake.="" slyly="" reg'="" );="" insert="" into="" customer="" values(4,'customer#000000004','4u58h="" fqkye',5,'15-128-190-5944',2866.83,'machinery','slyly="" final="" accounts="" sublate="" carefully.="" slyly="" ironic="" asymptotes="" nod="" across="" the="" quickly="" regular="" pack'="" );="" insert="" into="" customer="" values(5,'customer#000000005','hwbtxkobf="" qsw4krik5u="" 2b1au7h',4,'14-750-942-6364',794.47,'household','blithely="" final="" instructions="" haggle;="" stealthy="" sauternes="" nod;="" carefully="" regu'="" );="" insert="" into="" customer="" values(6,'customer#000000006','="" g1s,pzdenuebw3o,2="" pxu0f9n2g64rjrt5e',24,'34-114-968-4951',7638.57,'automobile','special="" deposits="" wake="" along="" the="" ironic="" foxes.="" slyly="" regular="" deposits="" are="" furiously="" about="" the="" blith'="" );="" insert="" into="" customer="" values(7,'customer#000000007','8okmvlq1dk6mbu6wg9="" w4plgq="" n7mq',22,'32-190-982-9759',9561.95,'automobile','theodolites="" kindle="" carefully="" carefully="" regular="" deposits.="" regular="" depe'="" );="" insert="" into="" customer="" values(8,'customer#000000002','xstf4,ncwdvawne6tegvwfmrchlxak',13,'23-768-687-3665',121.65,'automobile','furiously="" special="" deposits="" solve="" slyly.="" furiously="" even="" foxes="" wake="" alongside="" of="" the="" furiously="" ironic="" ideas.="" pending');="" insert="" into="" customer="" values(9,'customer#000000003','mg9kdtd2wbhm',1,'11-719-748-3364',7498.12,'automobile','special="" packages="" wake.="" slyly="" reg');="" insert="" into="" customer="" values(10,'customer#000000004','xxvsjslagtn',4,'14-128-190-5944',2866.83,'machinery','slyly="" final="" accounts="" sublate="" carefully.="" slyly="" ironic="" asymptotes="" nod="" across="" the="" quickly="" regular="" pack');="" insert="" into="" customer="" values(11,'customer#000000005','kvpyuhcplrb84wgaigv6sypzq7tj',3,'13-750-942-6364',794.47,'household','blithely="" final="" instructions="" haggle;="" stealthy="" sauternes="" nod;="" carefully="" regu');="" insert="" into="" customer="" values(12,'customer#000000006','skzz0csnmd7mp4xd0yrbvx,lreykuwah="" yvn',20,'30-114-968-4951',7638.57,'automobile','special="" deposits="" wake="" along="" the="" ironic="" foxes.="" slyly="" regular="" deposits="" are="" furiously="" about="" the="" blith');="" insert="" into="" customer="" values(13,'customer#000000007','tcge5gazngvepxu5krrvxbfkasdtea',18,'28-190-982-9759',9561.95,'automobile','theodolites="" kindle="" carefully="" carefully="" regular="" deposits.="" regular="" depe');="" insert="" into="" customer="" values(14,'customer#000000008','i0b10bb0aymmc,="" 0prrybcp1ygj8xcbpmwhl5',17,'27-147-574-9335',6819.74,'building','ironic="" deposits="" are="" quickly="" after="" the="" gifts.="" regular="" dependencies="" hinder="" slyly="" after="" the="" quickly="" ex');="" insert="" into="" customer="" values(15,'customer#000000009','xkiaftjuscuxfelenqefumtrjs',8,'18-338-906-3675',8324.07,'furniture','deposits="" affix="" fluffily.="" blithely="" final="" ideas="" are="" furiously="" dolphins.="" i');="" insert="" into="" customer="" values(16,'customer#000000010','6lreav6kr6plvcgl2arl="" q3rqzlzct1="" v2',5,'15-741-346-9870',2753.54,'household','bold,="" final="" frays="" sleep="" carefully="" special="" ideas.="" carefully="" final="" asymptotes="" sleep="" furiously="" against="" the="" even="" i');="" insert="" into="" orders="" values(1,2,'o',125093.31,to_date('1996-01-02','yyyy-mm-dd'),'5-low','clerk#000000951',0,'blithely="" final="" dolphins="" solve--="" blithely="" blithe="" packages="" nag="" blith'="" );="" insert="" into="" orders="" values(2,4,'o',36149.40,to_date('1996-12-01','yyyy-mm-dd'),'1-urgent','clerk#000000880',0,'quickly="" regular="" depend');="" insert="" into="" orders="" values(3,7,'f',150408.27,to_date('1993-10-14','yyyy-mm-dd'),'5-low','clerk#000000955',0,'deposits="" alongside="" of="" the="" dependencies="" are="" slowly="" about="" ');="" insert="" into="" orders="" values(4,7,'o',28442.34,to_date('1995-10-11','yyyy-mm-dd'),'5-low','clerk#000000124',0,'final="" requests="" detect="" slyly="" across="" the="" blithely="" bold="" pinto="" beans.="" eve');="" insert="" into="" orders="" values(5,4,'f',80273.44,to_date('1994-07-30','yyyy-mm-dd'),'5-low','clerk#000000925',0,'even="" deposits="" cajole="" furiously.="" quickly="" spe');="" insert="" into="" orders="" values(6,4,'f',31800.50,to_date('1992-02-21','yyyy-mm-dd'),'4-not="" specified','clerk#000000058',0,'ironically="" bold="" asymptotes="" sleep="" blithely="" beyond="" the="" regular,="" clos');="" insert="" into="" orders="" values(7,2,'o',151486.24,to_date('1996-01-10','yyyy-mm-dd'),'2-high','clerk#000000470',0,'ironic,="" regular="" deposits="" are.="" ironic="" foxes="" sl');="" insert="" into="" orders="" values(32,7,'o',105035.28,to_date('1995-07-16','yyyy-mm-dd'),'2-high','clerk#000000616',0,'slyly="" final="" foxes="" are="" slyly.="" packag');="" insert="" into="" orders="" values(33,4,'f',94379.93,to_date('1993-10-27','yyyy-mm-dd'),'3-medium','clerk#000000409',0,'packages="" maintain="" about="" the="" deposits;="" foxes="" hang="" after="" ');="" insert="" into="" orders="" values(34,4,'o',37670.39,to_date('1998-07-21','yyyy-mm-dd'),'3-medium','clerk#000000223',0,'quickly="" express="" asymptotes="" use.="" carefully="" final="" packages="" sleep="" f');="" insert="" into="" orders="" values(35,7,'o',136133.28,to_date('1995-10-23','yyyy-mm-dd'),'4-not="" specified','clerk#000000259',0,'fluffily="" regular="" pinto="" beans="" ');="" insert="" into="" orders="" values(36,7,'o',34627.32,to_date('1995-11-03','yyyy-mm-dd'),'1-urgent','clerk#000000358',0,'carefully="" ironic="" accounts="" nag');="" insert="" into="" orders="" values(37,5,'f',107844.52,to_date('1992-06-03','yyyy-mm-dd'),'3-medium','clerk#000000456',0,'express="" requests="" ar');="" insert="" into="" orders="" values(38,7,'o',39164.08,to_date('1996-08-21','yyyy-mm-dd'),'4-not="" specified','clerk#000000604',0,'slyly="" quick="" pinto="" beans="" detect="" flu');="" insert="" into="" orders="" values(39,4,'o',205834.99,to_date('1996-09-20','yyyy-mm-dd'),'3-medium','clerk#000000659',0,'furiously="" unusual="" pinto="" beans="" above="" the="" furiously="" ironic="" asymptot');="" insert="" into="" orders="" values(64,2,'f',18415.84,to_date('1994-07-16','yyyy-mm-dd'),'3-medium','clerk#000000661',0,'final="" deposits="" nag.="" blithely="" special="" deposits="" a');="" insert="" into="" orders="" values(65,1,'p',62762.63,to_date('1995-03-18','yyyy-mm-dd'),'1-urgent','clerk#000000632',0,'furiously="" even="" platelets="" boost="" ironic="" theodolites.="" even="" ');="" insert="" into="" orders="" values(66,7,'f',68615.59,to_date('1994-01-20','yyyy-mm-dd'),'5-low','clerk#000000743',0,'ironic="">