refactor Table

[mystagogy]

DROP TABLE IF EXISTS MEMBER; DROP TABLE IF EXISTS PROD; DROP TABLE IF EXISTS PAYMENT;

CREATE TABLE MEMBER ( uId VARCHAR(30) NOT NULL, uPw VARCHAR(30) NOT NULL, uEmail VARCHAR(50) NOT NULL, uPhoneNumber VARCHAR(50), PRIMARY KEY (uId) );

Insert into Member values ('a','a1234','a@gmail.com','010-0000-0000'); Insert into Member values ('b','b1234','a@gmail.com','010-0000-0000'); Insert into Member values ('c','c1234','a@gmail.com','010-0000-0000'); SELECT * FROM MEMBER;

DROP TABLE PROD;

CREATE TABLE PROD( uId VARCHAR(30) NOT NULL, oId VARCHAR(30) NOT NULL, ORDER_DATE VARCHAR(255), PROD_MANUF VARCHAR(30), PROD_INFO VARCHAR(255), PROD_COST VARCHAR(30), PROD_CNT INT, PROD_SELLER VARCHAR(30), PROD_SELLNUM VARCHAR(30), PROD_STATUS INT, PROD_REVIEW INT, PRIMARY KEY (oId) );

INSERT INTO PROD VALUES ('a', 1, '2010-02-15', 'American Samoa', 'A Epic Drama of a Feminist And a Mad Scientist who must Battle a Teacher in The Canadian Rockies', '17800', 2 ,'SMITH', '010-3333-5568', 1, 1); INSERT INTO PROD VALUES ('a', 2, '2011-03-16', 'Angola', 'A Astounding Epistle of a Database Administrator And a Explorer who must Find a Car in Ancient China', '58900', 4, 'JOHNSON', '010-7223-5589', 2, 1); INSERT INTO PROD VALUES ('a', 3, '2012-04-17', 'Anguilla', 'A Astounding Reflection of a Lumberjack And a Car who must Sink a Lumberjack in A Baloon Factory', '22200', 6, 'WILLIAMS', '283-0338-4290', 0, 1); INSERT INTO PROD VALUES ('b', 4, '2013-05-18', 'Argentina', 'A Fanciful Documentary of a Frisbee And a Lumberjack who must Chase a Monkey in A Shark Tank', '17800', 34, 'JONES', '386-3528-6649', 2, 1); INSERT INTO PROD VALUES ('b', 5, '2014-06-19', 'Armenia', 'A Fast-Paced Documentary of a Pastry Chef And a Dentist who must Pursue a Forensic Psychologist in The Gulf of Mexico', '58900', 12, 'BROWN', '484-7719-0408', 3, 1); INSERT INTO PROD VALUES ('b', 6, '2015-07-20', 'Australia', 'A Intrepid Panorama of a Robot And a Boy who must Escape a Sumo Wrestler in Ancient China', '222000', 9, 'DAVIS', '708-1400-3527', 1, 0); INSERT INTO PROD VALUES ('b', 7, '2016-08-21', 'Austria', 'A Touching Saga of a Hunter And a Butler who must Discover a Butler in A Jet Boat', '17800', 120, 'MILLER', '106-5564-8674', 2, 1); INSERT INTO PROD VALUES ('b', 8, '2017-09-22', 'Azerbaijan', 'A Epic Tale of a Moose And a Girl who must Confront a Monkey in Ancient India', '58900', 3, 'WILSON', '804-5262-6434', 0, 1); INSERT INTO PROD VALUES ('c', 9, '2018-10-23', 'Bahrain', 'A Thoughtful Panorama of a Database Administrator And a Mad Scientist who must Outgun a Mad Scientist in A Jet Boat', '22200', 77, 'MOORE', '765-7122-0373', 2, 1); INSERT INTO PROD VALUES ('c', 10, '2019-11-24', 'Bangladesh', 'A Action-Packed Tale of a Man And a Lumberjack who must Reach a Feminist in Ancient China', '', 8, 'TAYLOR', '652-8228-5970', 1, 1);

SELECT * FROM PROD;

drop table payment; CREATE TABLE Payment( oId varchar(30) NOT NULL PRIMARY KEY, payment_type varchar(20) NOT NULL, ORDER_DATE VARCHAR(255) NOT NULL, PROD_COST VARCHAR(30) NOT NULL, get_npoint varchar(20), use_npoint varchar(20) ); INSERT INTO Payment values (1, 'Card', '2010-02-15', '17800', '178', '0'); INSERT INTO Payment values (2, 'Account', '2011-03-16', '58900', '589', '1234'); INSERT INTO Payment values (3, 'Card', '2012-04-17', '22200', '222', NULL); INSERT INTO Payment values (4, 'Card', '2013-05-18', '17800', '178', '0'); INSERT INTO Payment values (5, 'Card', '2014-06-19', '58900', '589', '1234'); INSERT INTO Payment values (6, 'Account', '2015-07-20', '22200', '222', NULL); INSERT INTO Payment values (7, 'Card', '2016-08-21', '17800', '178', '0'); INSERT INTO Payment values (8, 'Account', '2017-09-22', '58900', '589', '1234'); INSERT INTO Payment values (9, 'Account', '2018-10-23', '22200', '222', NULL); INSERT INTO Payment values (10, 'Account', '2019-11-24', '22200', '222', NULL);

[crossbell8368]

INSERT INTO Payment ('oId','payment_type','ORDER_DATE','PROD_COST','get_npoint','use_npoint') VALUES ('1','Account','2022-10-30','65592','1254','1432'), ('2','Card','2023-7-8','22737','3348','2493'), ('3','Account','2020-7-4','44704','709','9904'), ('4','Account','2022-9-25','69682','458','8946'), ('5','Cash','2019-12-15','30384','8439','6069'), ('6','Card','2022-2-25','41371','1499','4797'), ('7','Card','2017-12-19','92596','2468','5369'), ('8','Cash','2023-7-15','61240','9555','8557'), ('9','Account','2022-1-9','96693','3488','7903'), ('10','Card','2023-4-19','92980','8112','7473'); INSERT INTO Payment ('oId','payment_type','ORDER_DATE','PROD_COST','get_npoint','use_npoint') VALUES ('11','Cash','2019-11-3','11304','1918','2633'), ('12','Account','2020-3-17','25584','2389','5289'), ('13','Account','2019-11-9','36973','3873','6769'), ('14','Cash','2019-9-8','97968','6070','467'), ('15','Account','2022-8-24','49743','5865','1747'), ('16','Card','2023-9-10','60343','6017','1929'), ('17','Card','2019-11-22','74103','844','4561'), ('18','Cash','2022-2-17','79527','542','2218'), ('19','Card','2018-6-3','80520','7003','2801'), ('20','Card','2018-11-2','48883','6558','6855'); INSERT INTO Payment ('oId','payment_type','ORDER_DATE','PROD_COST','get_npoint','use_npoint') VALUES ('21','Account','2022-11-14','34092','6233','960'), ('22','Cash','2019-9-6','17812','9077','1533'), ('23','Account','2019-8-7','17003','809','6847'), ('24','Card','2022-1-11','31687','3070','4248'), ('25','Card','2017-11-21','17734','4214','9265'), ('26','Cash','2017-10-14','51820','3957','1568'), ('27','Account','2021-1-22','71486','6334','699'), ('28','Account','2020-9-10','97509','2026','657'), ('29','Card','2019-3-19','90956','2302','6872'), ('30','Cash','2019-1-5','39729','278','5734'); INSERT INTO Payment ('oId','payment_type','ORDER_DATE','PROD_COST','get_npoint','use_npoint') VALUES ('31','Cash','2018-4-28','53144','4119','894'), ('32','Cash','2021-5-1','27419','959','2581'), ('33','Card','2020-9-21','48888','25','1650'), ('34','Account','2023-1-1','77230','9942','7910'), ('35','Cash','2023-5-13','27919','4870','6979'), ('36','Cash','2020-4-8','68463','534','783'), ('37','Cash','2022-7-7','18036','7485','1309'), ('38','Card','2019-9-18','43246','7885','7969'), ('39','Card','2023-5-5','89917','5750','3278'), ('40','Account','2023-5-30','89422','9219','9704'); INSERT INTO Payment ('oId','payment_type','ORDER_DATE','PROD_COST','get_npoint','use_npoint') VALUES ('41','Card','2023-4-20','13823','1427','1995'), ('42','Card','2019-1-18','91578','6744','575'), ('43','Card','2022-11-22','38196','5411','2436'), ('44','Cash','2019-5-3','85820','6981','9489'), ('45','Cash','2020-8-11','70763','685','4974'), ('46','Cash','2021-9-21','48667','8949','1592'), ('47','Account','2020-9-18','74993','4612','5296'), ('48','Account','2019-9-27','79650','1215','9513'), ('49','Cash','2019-5-17','71711','6345','9750'), ('50','Card','2022-1-30','94681','4400','7727'); INSERT INTO Payment ('oId','payment_type','ORDER_DATE','PROD_COST','get_npoint','use_npoint') VALUES ('51','Card','2023-9-10','10247','9827','3200'), ('52','Account','2019-2-26','41266','3507','4612'), ('53','Account','2021-3-26','84191','9776','1752'), ('54','Account','2018-7-19','13211','7047','7192'), ('55','Account','2021-7-9','21017','2884','4964'), ('56','Cash','2021-12-12','37700','1974','979'), ('57','Cash','2023-7-21','13152','5788','653'), ('58','Cash','2021-7-31','18346','6858','2571'), ('59','Card','2022-5-21','13076','2859','4329'), ('60','Account','2017-12-19','91011','7336','9760'); INSERT INTO Payment ('oId','payment_type','ORDER_DATE','PROD_COST','get_npoint','use_npoint') VALUES ('61','Cash','2019-10-2','56793','4156','9576'), ('62','Cash','2021-11-2','11035','6462','6840'), ('63','Card','2022-8-12','74898','2969','6293'), ('64','Cash','2018-8-11','11732','5615','1495'), ('65','Card','2020-11-21','47625','4107','6419'), ('66','Card','2020-12-9','60383','9013','9129'), ('67','Card','2019-2-6','69116','7879','8790'), ('68','Cash','2020-11-20','33698','4385','1399'), ('69','Card','2018-6-28','76900','3668','1441'), ('70','Cash','2018-1-21','17146','685','7679'); INSERT INTO Payment ('oId','payment_type','ORDER_DATE','PROD_COST','get_npoint','use_npoint') VALUES ('71','Account','2020-12-24','57557','9338','1603'), ('72','Cash','2020-4-25','75221','6700','3099'), ('73','Card','2018-8-26','93184','9892','8916'), ('74','Cash','2023-4-7','80972','2875','577'), ('75','Cash','2021-8-31','76630','928','4937'), ('76','Card','2023-3-20','83003','3909','6234'), ('77','Account','2018-1-10','97402','9264','9311'), ('78','Cash','2021-7-14','46078','4946','719'), ('79','Account','2020-4-5','74112','5838','3112'), ('80','Cash','2019-10-8','83857','1333','6798'); INSERT INTO Payment ('oId','payment_type','ORDER_DATE','PROD_COST','get_npoint','use_npoint') VALUES ('81','Account','2018-8-16','46497','6635','3484'), ('82','Account','2023-1-1','91817','3970','1545'), ('83','Cash','2018-11-4','65018','4362','6880'), ('84','Account','2022-2-11','39843','5270','4499'), ('85','Card','2023-5-3','63127','5503','4668'), ('86','Account','2018-6-22','52325','3176','3425'), ('87','Account','2021-12-21','56839','7412','3508'), ('88','Account','2018-11-22','54566','3760','2796'), ('89','Account','2017-10-12','65332','9882','7819'), ('90','Cash','2022-9-16','53261','9719','4679'); INSERT INTO Payment ('oId','payment_type','ORDER_DATE','PROD_COST','get_npoint','use_npoint') VALUES ('91','Cash','2020-10-28','98759','2052','9674'), ('92','Cash','2018-3-5','18712','8442','5942'), ('93','Card','2021-1-15','24041','6374','1876'), ('94','Cash','2021-10-5','59855','9879','4482'), ('95','Account','2021-9-16','15058','355','1834'), ('96','Cash','2022-7-24','19352','486','1374'), ('97','Account','2019-10-13','99923','8150','2779'), ('98','Cash','2022-6-9','19078','1568','6336'), ('99','Cash','2018-7-2','88859','5377','8395'), ('100','Account','2022-9-16','15139','887','6639');

[crossbell8368]

INSERT INTO PROD (uId,oId,ORDER_DATE,PROD_MANUF,PROD_INFO,PROD_COST,PROD_CNT,PROD_SELLER,PROD_SELLNUM,PROD_STATUS,PROD_REVIEW) VALUES ("Arthur",1,"2018-6-18","Ultrices A LLC","Vivamus nisi. Mauris nulla. Integer",99860,"elementum, dui quis","Perry","010-5374-7743",5,1), ("Sonia",2,"2018-8-16","Nostra Per Institute","pede blandit congue. In scelerisque",48413,"sit","Claire","010-4440-2299",4,0), ("Valentine",3,"2017-6-5","Malesuada Fames Ac Institute","non quam. Pellentesque habitant morbi",86042,"mollis vitae, posuere at, velit. Cras lorem lorem, luctus","Otto","010-0566-8944",5,1), ("Solomon",4,"2021-9-15","Ipsum Limited","vehicula. Pellentesque tincidunt tempus risus. Donec egestas. Duis ac arcu.",52731,"et magnis dis parturient montes, nascetur","Cody","010-7412-0624",4,0), ("Dylan",5,"2016-7-3","Non LLP","in, tempus eu, ligula. Aenean euismod mauris eu elit.",53959,"arcu vel quam","Cora","010-3956-5188",2,0), ("Arthur",6,"2020-2-8","Dui Fusce Aliquam Inc.","est. Mauris eu turpis. Nulla aliquet. Proin",13450,"dictum cursus. Nunc mauris elit, dictum eu, eleifend nec, malesuada","Cade","010-1623-8012",5,0), ("Sonia",7,"2019-3-9","Sit Amet PC","nisl. Maecenas malesuada fringilla est. Mauris eu turpis. Nulla aliquet.",88276,"quis arcu vel quam dignissim pharetra.","Eleanor","010-3752-2911",3,0), ("Arthur",8,"2020-6-28","Fusce Mollis Ltd","arcu ac orci. Ut semper pretium neque.",62622,"ipsum porta elit, a feugiat tellus lorem","Brianna","010-5769-4124",3,1), ("Solomon",9,"2023-5-30","Nibh Enim LLC","ut, pharetra sed, hendrerit a, arcu. Sed",67513,"Donec fringilla. Donec","Mikayla","010-8620-0936",4,0), ("Sonia",10,"2017-3-19","Ante Blandit Incorporated","et, magna. Praesent interdum ligula eu enim.",74413,"at pretium aliquet, metus","Lane","010-8838-1370",3,0); INSERT INTO PROD (uId,oId,ORDER_DATE,PROD_MANUF,PROD_INFO,PROD_COST,PROD_CNT,PROD_SELLER,PROD_SELLNUM,PROD_STATUS,PROD_REVIEW) VALUES ("Sonia",11,"2017-7-3","Libero Proin LLP","vel turpis. Aliquam adipiscing lobortis",50554,"purus mauris a nunc. In at pede. Cras vulputate","Hiroko","010-4898-5975",3,1), ("Arthur",12,"2022-4-16","Augue Ac Institute","orci. Phasellus dapibus quam quis diam.",69654,"malesuada ut,","Amanda","010-0878-5457",1,1), ("Dylan",13,"2021-10-18","Facilisis Limited","a, scelerisque sed, sapien. Nunc pulvinar arcu et pede. Nunc",30558,"in lobortis tellus justo sit amet nulla.","Britanni","010-4222-4531",6,1), ("Dylan",14,"2020-12-2","Nunc Ut Industries","Sed congue, elit sed consequat",67450,"facilisis facilisis, magna tellus faucibus","Ila","010-9888-0258",4,1), ("Arthur",15,"2019-9-17","Risus Duis Foundation","ac metus vitae velit egestas lacinia. Sed congue, elit",41912,"id, erat. Etiam vestibulum","Rhea","010-2119-6649",1,1), ("Dylan",16,"2018-3-18","Ligula Tortor LLC","massa lobortis ultrices. Vivamus rhoncus. Donec est.",33799,"metus. Aliquam erat volutpat.","Hedley","010-7184-5053",5,0), ("Solomon",17,"2017-4-30","Ultrices Posuere Limited","sapien imperdiet ornare. In faucibus. Morbi vehicula. Pellentesque tincidunt tempus",19468,"auctor ullamcorper, nisl arcu iaculis enim,","Shana","010-7406-5351",6,1), ("Dylan",18,"2023-2-11","Lorem Ipsum Dolor Foundation","dictum placerat, augue. Sed molestie. Sed id risus quis",75031,"aliquet, metus urna convallis erat, eget tincidunt dui augue","Destiny","010-4671-9557",3,1), ("Arthur",19,"2022-6-30","Risus Donec Egestas PC","enim. Curabitur massa. Vestibulum accumsan neque et nunc.",80769,"a, facilisis non, bibendum","Baxter","010-6746-9627",1,0), ("Solomon",20,"2017-11-1","Suspendisse LLC","lectus convallis est, vitae sodales nisi",42114,"semper et, lacinia vitae, sodales at,","Maxwell","010-9067-2661",5,1); INSERT INTO PROD (uId,oId,ORDER_DATE,PROD_MANUF,PROD_INFO,PROD_COST,PROD_CNT,PROD_SELLER,PROD_SELLNUM,PROD_STATUS,PROD_REVIEW) VALUES ("Dylan",21,"2020-11-14","Nibh Vulputate Limited","Aliquam vulputate ullamcorper magna. Sed eu",19130,"ac mattis semper, dui lectus rutrum","Danielle","010-4347-6776",4,1), ("Arthur",22,"2017-2-22","Praesent Eu Incorporated","sodales. Mauris blandit enim consequat purus. Maecenas libero",69537,"faucibus orci luctus et ultrices posuere cubilia","Akeem","010-6227-7971",1,0), ("Arthur",23,"2022-7-5","A Felis Associates","ac facilisis facilisis, magna tellus faucibus leo, in lobortis tellus",40001,"augue porttitor interdum.","Myra","010-6837-3120",4,1), ("Sonia",24,"2022-11-14","Donec Incorporated","Aenean eget magna. Suspendisse tristique neque venenatis lacus.",97140,"ornare tortor at risus. Nunc ac sem ut dolor","Chase","010-7551-1438",5,0), ("Arthur",25,"2017-7-8","Cursus Luctus Ipsum Ltd","natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.",40360,"hendrerit","Murphy","010-4217-8399",4,0), ("Dylan",26,"2017-3-23","Vulputate Eu Associates","aliquet, metus urna convallis erat, eget tincidunt",33972,"quam vel sapien imperdiet ornare.","Jacob","010-7524-1163",3,1), ("Valentine",27,"2021-8-3","Accumsan Neque Foundation","Nulla semper tellus id nunc interdum feugiat. Sed",61751,"dui, in sodales elit erat vitae risus. Duis a mi","Kennan","010-4057-0157",4,1), ("Valentine",28,"2022-6-19","Nibh Vulputate Corporation","magna. Suspendisse tristique neque venenatis lacus. Etiam",39741,"Nulla facilisi.","Mariko","010-6953-7439",5,0), ("Solomon",29,"2019-1-4","Ornare Fusce Mollis Industries","est, vitae sodales nisi magna sed dui.",63204,"arcu vel quam dignissim pharetra. Nam ac nulla.","Ella","010-0666-6081",6,1), ("Valentine",30,"2021-6-8","Eget Odio Industries","Nullam vitae diam. Proin dolor. Nulla",28361,"arcu. Sed et libero.","Laurel","010-6888-2404",1,0); INSERT INTO PROD (uId,oId,ORDER_DATE,PROD_MANUF,PROD_INFO,PROD_COST,PROD_CNT,PROD_SELLER,PROD_SELLNUM,PROD_STATUS,PROD_REVIEW) VALUES ("Valentine",31,"2019-8-4","Ipsum Curabitur Corporation","justo nec ante. Maecenas mi felis, adipiscing",49890,"sed pede. Cum sociis natoque penatibus","Francis","010-6406-7762",4,0), ("Solomon",32,"2018-3-9","Nam Consequat Dolor Corporation","luctus ut, pellentesque eget, dictum placerat, augue. Sed",40090,"sodales elit erat vitae risus.","Selma","010-3565-8502",5,0), ("Dylan",33,"2022-9-28","Arcu Et Limited","aliquam eros turpis non enim. Mauris quis",80326,"Fusce diam nunc, ullamcorper eu, euismod ac, fermentum vel, mauris.","Abbot","010-7375-5148",2,0), ("Arthur",34,"2022-12-12","Justo Nec Ante Industries","in consequat enim diam vel arcu.",64550,"sit amet metus. Aliquam erat volutpat.","Talon","010-7383-2726",3,1), ("Solomon",35,"2022-12-24","Fusce Mi Limited","sem semper erat, in consectetuer ipsum nunc id",90477,"pellentesque massa lobortis ultrices. Vivamus rhoncus. Donec est. Nunc","Georgia","010-7467-7783",2,0), ("Sonia",36,"2017-5-22","Amet Ltd","eget odio. Aliquam vulputate ullamcorper magna. Sed",15688,"augue scelerisque mollis. Phasellus libero mauris, aliquam","Debra","010-2895-7624",2,1), ("Valentine",37,"2021-11-21","Aliquam Adipiscing Lobortis Limited","non, luctus sit amet, faucibus",15660,"quam dignissim pharetra. Nam ac nulla. In tincidunt congue","Cedric","010-5561-1107",3,0), ("Solomon",38,"2021-10-7","Sollicitudin Institute","libero lacus, varius et, euismod et, commodo",79401,"pretium et,","Keane","010-8876-7539",3,0), ("Solomon",39,"2022-12-13","Accumsan PC","mauris sapien, cursus in, hendrerit consectetuer, cursus et,",64591,"dolor quam, elementum at, egestas a, scelerisque sed,","Lance","010-5355-5158",4,0), ("Dylan",40,"2017-3-16","Magna A Neque Foundation","felis. Donec tempor, est ac mattis semper,",21830,"sed dui. Fusce aliquam, enim nec","Madeson","010-8667-3124",2,1); INSERT INTO PROD (uId,oId,ORDER_DATE,PROD_MANUF,PROD_INFO,PROD_COST,PROD_CNT,PROD_SELLER,PROD_SELLNUM,PROD_STATUS,PROD_REVIEW) VALUES ("Dylan",41,"2022-8-26","Ut Pharetra Associates","tempor bibendum. Donec felis orci, adipiscing non,",98781,"augue scelerisque","William","010-8962-4207",5,0), ("Sonia",42,"2019-10-20","Erat In Consectetuer Foundation","mauris erat eget ipsum. Suspendisse",69789,"tincidunt. Donec vitae erat vel pede blandit congue.","Cally","010-6248-3590",5,1), ("Dylan",43,"2020-3-24","Vivamus Molestie Company","Fusce aliquam, enim nec tempus scelerisque,",45440,"Nunc sollicitudin commodo ipsum. Suspendisse non leo. Vivamus nibh dolor,","Eugenia","010-0256-3157",2,1), ("Sonia",44,"2018-7-18","Imperdiet Ullamcorper Inc.","In faucibus. Morbi vehicula. Pellentesque tincidunt tempus risus.",48438,"diam luctus lobortis. Class","Kelly","010-7468-4453",5,0), ("Sonia",45,"2018-4-3","Rutrum Urna Corp.","euismod urna. Nullam lobortis quam a felis ullamcorper",80235,"nunc. In","Kyle","010-2825-4413",1,1), ("Solomon",46,"2016-9-7","Semper Associates","orci lobortis augue scelerisque mollis. Phasellus libero mauris,",44255,"id, mollis nec, cursus","Joseph","010-8947-9254",2,0), ("Solomon",47,"2022-7-17","Vestibulum Mauris PC","ut nisi a odio semper cursus. Integer",96651,"Donec nibh. Quisque nonummy ipsum non arcu. Vivamus sit amet","Willow","010-4359-4483",5,1), ("Solomon",48,"2022-1-14","Vivamus Nisi Institute","bibendum sed, est. Nunc laoreet lectus quis massa.",32712,"fermentum metus. Aenean sed pede nec","Quynn","010-3116-2827",3,0), ("Dylan",49,"2018-7-5","Tellus Sem Mollis Corporation","lacus pede sagittis augue, eu tempor erat neque non",42246,"nisi magna","Neville","010-4954-0476",5,0), ("Solomon",50,"2021-1-26","Adipiscing Institute","nunc interdum feugiat. Sed nec metus",45225,"ac urna. Ut tincidunt vehicula risus. Nulla eget metus","Sonia","010-3747-8699",1,0); INSERT INTO PROD (uId,oId,ORDER_DATE,PROD_MANUF,PROD_INFO,PROD_COST,PROD_CNT,PROD_SELLER,PROD_SELLNUM,PROD_STATUS,PROD_REVIEW) VALUES ("Solomon",51,"2019-9-20","Phasellus At Augue LLC","porttitor interdum. Sed auctor odio a",89523,"eget metus eu erat semper rutrum. Fusce dolor quam,","Ivor","010-1076-3387",3,1), ("Dylan",52,"2016-8-23","Erat In Institute","imperdiet non, vestibulum nec, euismod in, dolor. Fusce feugiat. Lorem",62482,"Proin ultrices. Duis volutpat nunc sit amet metus. Aliquam","Kylie","010-4675-9150",4,0), ("Dylan",53,"2018-8-24","Non Vestibulum Institute","Phasellus dolor elit, pellentesque a, facilisis",59893,"Cras pellentesque. Sed dictum.","Alvin","010-7061-8767",1,0), ("Valentine",54,"2019-9-21","Id Sapien Limited","senectus et netus et malesuada fames ac turpis egestas.",72324,"sagittis semper. Nam","Carla","010-4617-6750",6,1), ("Arthur",55,"2017-4-26","Pharetra Sed Hendrerit Ltd","mollis vitae, posuere at, velit. Cras lorem lorem, luctus",35819,"sem molestie sodales. Mauris blandit enim consequat purus.","Zenia","010-2363-6534",1,0), ("Valentine",56,"2021-8-18","Maecenas Ornare Institute","pellentesque eget, dictum placerat, augue. Sed molestie. Sed id",87083,"luctus lobortis. Class aptent taciti sociosqu ad litora","Joel","010-1942-8886",5,1), ("Sonia",57,"2020-5-9","Urna Nunc Company","et nunc. Quisque ornare tortor at",81799,"amet, consectetuer adipiscing elit. Aliquam auctor,","Tatyana","010-9732-2558",6,0), ("Solomon",58,"2016-12-31","Sollicitudin Commodo Incorporated","per inceptos hymenaeos. Mauris ut quam",70722,"ornare, lectus","Lydia","010-0796-2151",1,1), ("Sonia",59,"2019-10-18","Donec Tempus Consulting","Sed eget lacus. Mauris non dui nec",36309,"risus. In mi pede, nonummy ut, molestie in, tempus eu,","Fitzgerald","010-6874-8577",2,0), ("Solomon",60,"2021-9-13","Dui Nec Corporation","laoreet posuere, enim nisl elementum purus, accumsan interdum",55427,"vitae purus gravida sagittis. Duis gravida. Praesent eu nulla","Orson","010-9484-7306",4,1); INSERT INTO PROD (uId,oId,ORDER_DATE,PROD_MANUF,PROD_INFO,PROD_COST,PROD_CNT,PROD_SELLER,PROD_SELLNUM,PROD_STATUS,PROD_REVIEW) VALUES ("Dylan",61,"2017-12-30","Feugiat Institute","Vivamus euismod urna. Nullam lobortis quam a felis",96764,"natoque penatibus","Reese","010-1924-1079",6,1), ("Arthur",62,"2017-8-27","Nulla Eu Neque PC","mauris, aliquam eu, accumsan sed, facilisis vitae, orci.",48712,"justo sit amet nulla. Donec non justo.","Diana","010-6332-3928",3,1), ("Valentine",63,"2021-5-29","Proin Incorporated","ligula. Aenean gravida nunc sed pede.",14667,"diam luctus lobortis. Class","Jarrod","010-5462-9895",1,0), ("Arthur",64,"2020-5-17","Diam Eu Company","arcu. Curabitur ut odio vel est tempor bibendum. Donec felis",55240,"Donec feugiat metus sit","Maite","010-5892-2632",4,0), ("Valentine",65,"2022-9-8","Per Inceptos Hymenaeos Corporation","eu dui. Cum sociis natoque penatibus",86073,"Mauris quis turpis vitae purus gravida","Cody","010-4627-8509",2,1), ("Solomon",66,"2022-1-12","Mi Enim Condimentum PC","Duis mi enim, condimentum eget, volutpat ornare, facilisis",20509,"bibendum fermentum metus.","Nathan","010-8612-9284",6,1), ("Valentine",67,"2017-3-9","Et Institute","Aliquam nec enim. Nunc ut erat. Sed",28815,"ante bibendum ullamcorper. Duis","Stacey","010-7852-7256",3,0), ("Arthur",68,"2020-7-26","Ornare In Associates","penatibus et magnis dis parturient montes, nascetur ridiculus mus. Proin",39747,"eu, odio. Phasellus","Zelda","010-1441-0712",4,1), ("Solomon",69,"2016-12-24","Eu Turpis Inc.","hendrerit id, ante. Nunc mauris sapien,",44113,"ultricies adipiscing, enim mi","Mark","010-3169-7934",4,1), ("Dylan",70,"2022-9-5","Tempus Scelerisque Limited","lorem ut aliquam iaculis, lacus pede sagittis augue, eu tempor",18785,"quam quis diam. Pellentesque habitant morbi tristique","Heidi","010-4371-9461",2,0); INSERT INTO PROD (uId,oId,ORDER_DATE,PROD_MANUF,PROD_INFO,PROD_COST,PROD_CNT,PROD_SELLER,PROD_SELLNUM,PROD_STATUS,PROD_REVIEW) VALUES ("Sonia",71,"2020-5-16","Nisi LLC","vitae velit egestas lacinia. Sed congue, elit",27761,"amet, dapibus id,","Knox","010-5521-6005",2,1), ("Dylan",72,"2017-8-6","Aliquet Molestie Consulting","tincidunt congue turpis. In condimentum. Donec at arcu.",48550,"Suspendisse","Brenden","010-2583-2884",3,0), ("Valentine",73,"2023-1-1","Dapibus Corp.","commodo tincidunt nibh. Phasellus nulla.",17461,"velit. Aliquam nisl. Nulla eu neque","Alexa","010-2160-0544",1,0), ("Dylan",74,"2021-6-1","Vitae Inc.","Vivamus euismod urna. Nullam lobortis quam a",47992,"sapien molestie orci tincidunt adipiscing. Mauris molestie pharetra","Elizabeth","010-7054-7067",2,1), ("Dylan",75,"2022-9-8","Orci Consectetuer Corporation","Proin vel arcu eu odio tristique pharetra. Quisque ac libero",86367,"ipsum primis","Acton","010-2724-5394",4,1), ("Arthur",76,"2019-4-4","Massa Integer Institute","vulputate eu, odio. Phasellus at augue id",62881,"pede. Suspendisse dui. Fusce","Sydnee","010-4877-1762",5,0), ("Solomon",77,"2017-1-21","Rutrum Consulting","Integer eu lacus. Quisque imperdiet, erat nonummy",21863,"sit amet orci.","Irma","010-1412-4699",3,0), ("Dylan",78,"2023-4-10","Enim Sed Company","consectetuer, cursus et, magna. Praesent interdum ligula eu enim.",63507,"nunc est, mollis non, cursus non, egestas a, dui.","Carlos","010-3706-3643",3,0), ("Solomon",79,"2018-10-10","Odio A Purus Inc.","Aenean massa. Integer vitae nibh. Donec est mauris,",44171,"Aliquam ultrices iaculis odio. Nam interdum enim non","Roanna","010-3005-6563",2,0), ("Dylan",80,"2022-11-11","Velit PC","convallis est, vitae sodales nisi magna sed dui.",18992,"Suspendisse eleifend. Cras sed leo. Cras vehicula","Akeem","010-8056-1154",1,0); INSERT INTO PROD (uId,oId,ORDER_DATE,PROD_MANUF,PROD_INFO,PROD_COST,PROD_CNT,PROD_SELLER,PROD_SELLNUM,PROD_STATUS,PROD_REVIEW) VALUES ("Valentine",81,"2019-1-15","Sit Amet Industries","Nulla tincidunt, neque vitae semper egestas,",97119,"gravida. Praesent eu nulla at sem","Lawrence","010-6711-0831",5,0), ("Solomon",82,"2021-3-4","Aliquam Auctor Velit Limited","faucibus lectus, a sollicitudin orci sem eget massa.",56356,"Aliquam gravida mauris ut","Driscoll","010-5440-5531",3,1), ("Solomon",83,"2020-5-4","Amet Risus Corporation","lectus. Cum sociis natoque penatibus et magnis dis",19816,"diam. Pellentesque habitant morbi","August","010-6225-3026",4,0), ("Arthur",84,"2022-3-21","Et Ultrices Ltd","a tortor. Nunc commodo auctor velit. Aliquam nisl. Nulla",51361,"dui. Cum","Oren","010-6825-3454",1,0), ("Solomon",85,"2022-1-25","Integer Tincidunt Company","erat semper rutrum. Fusce dolor quam, elementum",98447,"consequat dolor","Breanna","010-8720-9631",1,1), ("Valentine",86,"2020-3-23","Senectus Industries","Etiam gravida molestie arcu. Sed eu nibh vulputate mauris sagittis",37906,"gravida molestie arcu. Sed","Nichole","010-7564-5492",5,1), ("Sonia",87,"2018-9-30","Eu Odio Tristique Foundation","orci lacus vestibulum lorem, sit amet ultricies sem magna nec",45216,"faucibus leo, in lobortis","Kiayada","010-0887-7812",2,1), ("Sonia",88,"2022-11-8","Penatibus Associates","Phasellus fermentum convallis ligula. Donec luctus",47889,"non, vestibulum nec, euismod","Dominic","010-6525-3236",3,0), ("Arthur",89,"2018-7-5","Cum Sociis Natoque Corp.","ornare tortor at risus. Nunc ac sem ut dolor dapibus",76997,"non, egestas a, dui. Cras pellentesque. Sed dictum.","Rylee","010-7432-8546",2,0), ("Dylan",90,"2023-9-1","Et Incorporated","Maecenas malesuada fringilla est. Mauris eu",56904,"metus facilisis lorem tristique aliquet. Phasellus fermentum convallis ligula.","Brennan","010-5876-4644",3,1); INSERT INTO PROD (uId,oId,ORDER_DATE,PROD_MANUF,PROD_INFO,PROD_COST,PROD_CNT,PROD_SELLER,PROD_SELLNUM,PROD_STATUS,PROD_REVIEW) VALUES ("Solomon",91,"2017-6-13","Nonummy Ac Foundation","mauris a nunc. In at pede.",54876,"euismod in, dolor.","Reed","010-1824-9461",2,0), ("Solomon",92,"2022-4-12","Dolor Tempus Corp.","rutrum, justo. Praesent luctus. Curabitur egestas nunc sed libero. Proin",87205,"libero mauris, aliquam","Vera","010-6938-1542",2,1), ("Solomon",93,"2021-10-16","Integer LLC","tellus justo sit amet nulla.",31121,"eget tincidunt dui augue eu","Victor","010-4157-7243",6,1), ("Sonia",94,"2022-5-2","Malesuada Augue Ut Foundation","nibh. Aliquam ornare, libero at auctor ullamcorper, nisl arcu",79984,"metus.","Keegan","010-9263-1457",4,1), ("Solomon",95,"2022-6-13","Integer Mollis Corporation","enim. Nunc ut erat. Sed nunc est,",83983,"mattis velit justo nec ante.","Dante","010-7638-1711",4,0), ("Arthur",96,"2020-7-21","Scelerisque Institute","erat volutpat. Nulla dignissim. Maecenas ornare",93826,"amet, consectetuer adipiscing elit. Aliquam auctor,","Alan","010-4938-1651",3,0), ("Arthur",97,"2022-1-7","Sociis Natoque Foundation","Proin velit. Sed malesuada augue ut",61564,"ultrices,","Amos","010-1343-2716",4,0), ("Valentine",98,"2021-6-11","Sed Facilisis Vitae Ltd","Nulla aliquet. Proin velit. Sed malesuada augue ut lacus.",39173,"Curabitur dictum. Phasellus in felis. Nulla tempor augue","Cullen","010-2113-5112",4,1), ("Arthur",99,"2017-5-2","Eu Consulting","euismod in, dolor. Fusce feugiat. Lorem ipsum dolor sit",40454,"Nulla eu","Lionel","010-8715-2778",4,1), ("Sonia",100,"2019-11-7","Faucibus Ut Foundation","lacus. Nulla tincidunt, neque vitae semper egestas, urna justo",25126,"enim consequat purus. Maecenas libero","Darryl","010-3218-6797",2,0);