-- load data insert into ch18_user ( id, user_type, firstname, lastname, address, email, phone, date_of_birth, intests, user_status, username, user_passwd ) values ( 1, 'MEMBER', 'Compendium GA', 'Ligula Commodo Dictum', '147 Los Mochis Blvd', 'gricelda.luebbers@aaab.com', 'Lorem', sysdate - 45, 'Vestibulum ante ipsumprimis in faucibus orci luctus et ultrices posuere cubilia Curae; Proin vulputate placerat pellentesque. Proin viverra lacinialectus, quis consectetur mi venenatis nec. Donec convallis.', 'ACTIVE', 'Compendium GA', 'Nec Donec Convallis Sollicitudin' ); insert into ch18_user ( id, user_type, firstname, lastname, address, email, phone, date_of_birth, intests, user_status, username, user_passwd ) values ( 2, 'ADMINISTRATOR', 'SOA Upgrade', 'Lorem Commodo Ullamcorperinter', '210 Aniches Street', 'dean.bollich@aaac.com', 'Suscipit', sysdate - 12, 'Lacinialectus, quis consectetur mi venenatis nec. Donec convallis sollicitudin.', 'SUSPENDED', 'SOA Upgrade', 'Massa Pharetra Id Mattis' ); insert into ch18_user ( id, user_type, firstname, lastname, address, email, phone, date_of_birth, intests, user_status, username, user_passwd ) values ( 3, 'MEMBER', 'Resiliency Monitoring', 'Ex Etiam Cursus', '635 Koeking Ave', 'milo.manoni@aaad.com', 'Commodo', sysdate - 79, 'Ligula commodo, dictum lorem sit amet, imperdiet ex. Etiam.', 'INACTIVE', 'Resiliency Monitoring', 'Placerat Iaculis Aliquam Vestibulum' ); insert into ch18_user ( id, user_type, firstname, lastname, address, email, phone, date_of_birth, intests, user_status, username, user_passwd ) values ( 4, 'ADMINISTRATOR', 'SDK Upgraded for Embedded Syst', 'Lacinialectus Quis Consectetur', '92 Wallsburg Blvd', 'laurice.karl@aaae.com', 'Suscipit', sysdate - 57, 'Vulputate placerat pellentesque. Proin viverra lacinialectus, quis consectetur mi venenatis nec. Donec convallis sollicitudin elementum. Nulla facilisi. In posuere blandit leoeget malesuada. Vivamus efficitur ipsum tellus, quis posuere mi maximus vitae. Qu', 'ACTIVE', 'SDK Upgraded for Embedded System', 'Eu Lorem Commodo Ullamcorperinterdum' ); insert into ch18_user ( id, user_type, firstname, lastname, address, email, phone, date_of_birth, intests, user_status, username, user_passwd ) values ( 5, 'MEMBER', 'U88 Application', 'Vitae Ligula Commodo', '477 Koeking Street', 'august.rupel@aaaf.com', 'Venenatis', sysdate - 10, 'Eu lorem commodo ullamcorper.Interdum et malesuada fames ac.', 'SUSPENDED', 'U88 Application', 'Rhoncuscras Vulputate Porttitor Ligula' ); insert into ch18_user ( id, user_type, firstname, lastname, address, email, phone, date_of_birth, intests, user_status, username, user_passwd ) values ( 6, 'ADMINISTRATOR', 'Developer Bug Performance Revi', 'Vestibulum Ante Ipsumprimis', '682 Monserrat Ave', 'salome.guisti@aaag.com', 'Diam', sysdate - 82, 'Curae; Proin vulputate placerat pellentesque. Proin viverra lacinialectus, quis consectetur mi venenatis nec. Donec convallis.', 'INACTIVE', 'Developer Bug Performance Review', 'Rhoncuscras Vulputate Porttitor Ligula' ); insert into ch18_user ( id, user_type, firstname, lastname, address, email, phone, date_of_birth, intests, user_status, username, user_passwd ) values ( 7, 'MEMBER', 'FAQ Automated Publishing', 'Commodo Ullamcorperinterdum Et', '102 Lake Norman of Catawba Blvd', 'lovie.ritacco@aaah.com', 'Vulputate', sysdate - 24, 'Risus rhoncus.Cras vulputate porttitor.', 'ACTIVE', 'FAQ Automated Publishing', 'Vitae Ligula Commodo Dictum' ); insert into ch18_user ( id, user_type, firstname, lastname, address, email, phone, date_of_birth, intests, user_status, username, user_passwd ) values ( 8, 'ADMINISTRATOR', 'Competitive Tracking', 'Amet Imperdiet Ex', '836 Riverside Place', 'chaya.greczkowski@aaai.com', 'Venenatis', sysdate - 32, 'Risus.Phasellus vitae ligula commodo, dictum lorem sit amet, imperdiet ex. Etiam cursus porttitor tincidunt. Vestibulum ante ipsumprimis in faucibus orci luctus et ultrices posuere cubilia Curae; Proin vulputate placerat pellentesque. Proin viverra lacinia', 'SUSPENDED', 'Competitive Tracking', 'Amet Massa Eu Lorem' ); insert into ch18_user ( id, user_type, firstname, lastname, address, email, phone, date_of_birth, intests, user_status, username, user_passwd ) values ( 9, 'MEMBER', 'Inventory Quality Control Upgr', 'Placerat Pellentesque Proin', '170 Chalcov Blvd', 'twila.coolbeth@aaaj.com', 'Tristique', sysdate - 25, 'Quis consectetur mi venenatis nec. Donec convallis sollicitudin elementum. Nulla facilisi. In posuere blandit leoeget malesuada. Vivamus.', 'INACTIVE', 'Inventory Quality Control Upgrade', 'Rhoncus Nonmolestie Sit Amet' ); insert into ch18_user ( id, user_type, firstname, lastname, address, email, phone, date_of_birth, intests, user_status, username, user_passwd ) values ( 10, 'ADMINISTRATOR', 'Checklist Management System', 'Luctus Et Ultrices', '877 Ammon Place', 'carlotta.achenbach@aaak.com', 'Et', sysdate - 23, 'Vestibulum eget rhoncus non,molestie sit amet lectus. Nulla placerat iaculis aliquam. Vestibulum lacinia arcu in massa pharetra, id mattis risus rhoncus.Cras vulputate porttitor ligula. Nam semper diam suscipit elementum sodales. Proin sit amet massa eu lo', 'ACTIVE', 'Checklist Management System', 'In Faucibus Orci Luctus' ); commit; alter table ch18_user modify id generated by default on null as identity restart start with 11; -- load data -- load data insert into ch18_type_of_plant ( id, name_of_type_of_plant, ch18_is_subtype_of ) values ( 1, 'Compendium GA', 1 ); insert into ch18_type_of_plant ( id, name_of_type_of_plant, ch18_is_subtype_of ) values ( 2, 'SOA Upgrade', 2 ); insert into ch18_type_of_plant ( id, name_of_type_of_plant, ch18_is_subtype_of ) values ( 3, 'Resiliency Monitoring', 3 ); insert into ch18_type_of_plant ( id, name_of_type_of_plant, ch18_is_subtype_of ) values ( 4, 'SDK Upgraded for Embedded Syst', 3 ); insert into ch18_type_of_plant ( id, name_of_type_of_plant, ch18_is_subtype_of ) values ( 5, 'U88 Application', 3 ); insert into ch18_type_of_plant ( id, name_of_type_of_plant, ch18_is_subtype_of ) values ( 6, 'Developer Bug Performance Revi', 4 ); insert into ch18_type_of_plant ( id, name_of_type_of_plant, ch18_is_subtype_of ) values ( 7, 'FAQ Automated Publishing', 1 ); insert into ch18_type_of_plant ( id, name_of_type_of_plant, ch18_is_subtype_of ) values ( 8, 'Competitive Tracking', 4 ); insert into ch18_type_of_plant ( id, name_of_type_of_plant, ch18_is_subtype_of ) values ( 9, 'Inventory Quality Control Upgr', 6 ); insert into ch18_type_of_plant ( id, name_of_type_of_plant, ch18_is_subtype_of ) values ( 10, 'Checklist Management System', 2 ); commit; alter table ch18_type_of_plant modify id generated by default on null as identity restart start with 11; -- load data insert into ch18_plants ( id, ch18_plant_type_id, names_local, names_english, name_latin, description, habitat, cultivation, use, photo, hyperlinks, status ) values ( 1, 8, 'Compendium GA', 'Semper diam suscipit elementum sodales. Proin sit amet massa eu lorem commodo ullamcorper.Interdum e', 'Massa Eu Lorem', 'Ullamcorper.Interdum et malesuada fames ac ante ipsum primis in faucibus. Ut id nulla ac sapien suscipit tristique.', 'Ipsumprimis In Faucibus Orci', 'Risus.Phasellus vitae ligula commodo, dictum lorem sit amet, imperdiet ex. Etiam cursus porttitor ti', 'Malesuada fames ac ante ipsum primis in faucibus. Ut id nulla ac sapien suscipit tristique ac volutp', null, 'Porttitor ligula. Nam semper diam suscipit elementum sodales. Proin sit amet massa eu lorem commodo ', 'Posuere' ); insert into ch18_plants ( id, ch18_plant_type_id, names_local, names_english, name_latin, description, habitat, cultivation, use, photo, hyperlinks, status ) values ( 2, 5, 'SOA Upgrade', 'Ipsum primis in faucibus. Ut id nulla ac sapien suscipit tristique.', 'Elit Vestibulum Eget', 'Suscipit tristique ac volutpat risus.Phasellus vitae ligula commodo, dictum lorem sit amet, imperdiet ex. Etiam cursus porttitor tincidunt. Vestibulum ante ipsumprimis in faucibus orci luctus et ultri', 'Ante Ipsumprimis In Faucibus', 'Sodales. Proin sit amet massa eu lorem commodo ullamcorper.Interdum et malesuada fames ac ante ipsum', 'Et malesuada fames ac ante ipsum primis in faucibus. Ut id nulla ac sapien suscipit tristique ac vol', null, 'Ac sapien suscipit tristique ac volutpat risus.Phasellus vitae ligula commodo, dictum lorem sit amet', 'Faucibus' ); insert into ch18_plants ( id, ch18_plant_type_id, names_local, names_english, name_latin, description, habitat, cultivation, use, photo, hyperlinks, status ) values ( 3, 7, 'Resiliency Monitoring', 'Sodales. Proin sit amet massa eu lorem commodo ullamcorper.Interdum et malesuada fames ac ante ipsum', 'Massa Eu Lorem', 'Elit, vestibulum eget rhoncus non,molestie sit amet lectus. Nulla placerat iaculis aliquam. Vestibulum lacinia arcu in massa pharetra, id mattis risus rhoncus.Cras vulputate porttitor ligula. Nam semp', 'Id Mattis Risus Rhoncuscras', 'Eu lorem commodo ullamcorper.Interdum et malesuada fames ac ante ipsum primis in faucibus. Ut id nul', 'Lacinia arcu in massa pharetra, id mattis risus rhoncus.Cras vulputate porttitor ligula. Nam semper ', null, 'Nulla placerat iaculis aliquam. Vestibulum lacinia arcu in massa pharetra, id mattis risus rhoncus.C', 'Suscipit' ); insert into ch18_plants ( id, ch18_plant_type_id, names_local, names_english, name_latin, description, habitat, cultivation, use, photo, hyperlinks, status ) values ( 4, 8, 'SDK Upgraded for Embedded System', 'Ligula commodo, dictum lorem sit amet, imperdiet ex. Etiam cursus.', 'Proin Sit Amet', 'Curae; Proin vulputate placerat pellentesque. Proin viverra lacinialectus, quis consectetur mi venenatis nec. Donec convallis sollicitudin elementum. Nulla facilisi. In posuere blandit leoeget malesua', 'Massa Pharetra Id Mattis', 'Consectetur mi venenatis nec. Donec convallis sollicitudin elementum. Nulla facilisi. In posuere bla', 'Vestibulum lacinia arcu.', null, 'Sit amet lectus. Nulla placerat iaculis aliquam. Vestibulum lacinia arcu in massa pharetra, id matti', 'Massa' ); insert into ch18_plants ( id, ch18_plant_type_id, names_local, names_english, name_latin, description, habitat, cultivation, use, photo, hyperlinks, status ) values ( 5, 7, 'U88 Application', 'Massa eu lorem commodo ullamcorper.Interdum et malesuada fames ac ante ipsum primis in faucibus. Ut ', 'Volutpat Risusphasellus Vitae', 'Sodales. Proin sit amet massa eu lorem commodo ullamcorper.Interdum et malesuada fames ac ante ipsum primis in faucibus. Ut id nulla ac sapien suscipit tristique ac volutpat risus.Phasellus vitae ligu', 'Suscipit Elementum Sodales Proin', 'Commodo ullamcorper.Interdum et malesuada fames ac ante ipsum.', 'Ligula. Nam semper diam suscipit elementum sodales. Proin sit amet massa eu lorem commodo ullamcorpe', null, 'Placerat iaculis aliquam.', 'Nec' ); insert into ch18_plants ( id, ch18_plant_type_id, names_local, names_english, name_latin, description, habitat, cultivation, use, photo, hyperlinks, status ) values ( 6, 6, 'Developer Bug Performance Review', 'Tincidunt. Vestibulum ante ipsumprimis in faucibus orci luctus et ultrices posuere cubilia Curae; Pr', 'Luctus Et Ultrices', 'Amet lectus. Nulla placerat iaculis aliquam. Vestibulum lacinia arcu in massa pharetra, id mattis risus rhoncus.Cras vulputate porttitor ligula. Nam semper diam suscipit elementum sodales. Proin sit a', 'Iaculis Aliquam Vestibulum Lacinia', 'Volutpat risus.Phasellus vitae ligula commodo, dictum lorem sit amet, imperdiet ex. Etiam cursus por', 'Cubilia Curae; Proin vulputate.', null, 'Orci luctus et ultrices posuere cubilia Curae; Proin vulputate placerat pellentesque. Proin viverra ', 'Sodales' ); insert into ch18_plants ( id, ch18_plant_type_id, names_local, names_english, name_latin, description, habitat, cultivation, use, photo, hyperlinks, status ) values ( 7, 7, 'FAQ Automated Publishing', 'Eu lorem commodo ullamcorper.Interdum et malesuada fames ac.', 'Ultrices Posuere Cubilia', 'Eget rhoncus non,molestie sit amet lectus. Nulla placerat iaculis aliquam. Vestibulum lacinia arcu in massa pharetra, id mattis risus rhoncus.Cras vulputate porttitor ligula. Nam semper diam suscipit ', 'Sollicitudin Elementum Nulla Facilisi', 'Curae; Proin vulputate placerat pellentesque. Proin viverra lacinialectus, quis consectetur mi venen', 'Eu lorem commodo ullamcorper.Interdum et malesuada fames ac ante ipsum primis in faucibus. Ut id nul', null, 'Nec. Donec convallis sollicitudin elementum. Nulla facilisi. In posuere blandit leoeget malesuada. V', 'Massa' ); insert into ch18_plants ( id, ch18_plant_type_id, names_local, names_english, name_latin, description, habitat, cultivation, use, photo, hyperlinks, status ) values ( 8, 7, 'Competitive Tracking', 'Etiam cursus porttitor tincidunt. Vestibulum ante ipsumprimis in faucibus orci luctus et ultrices po', 'Proin Viverra Lacinialectus', 'Malesuada fames ac ante ipsum primis in faucibus. Ut id nulla ac sapien suscipit tristique ac volutpat risus.Phasellus vitae ligula commodo, dictum lorem sit amet, imperdiet ex. Etiam cursus porttitor', 'Diam Suscipit Elementum Sodales', 'Vestibulum eget rhoncus non,molestie sit amet lectus. Nulla placerat iaculis aliquam. Vestibulum lac', 'Faucibus. Ut id nulla ac sapien suscipit.', null, 'Massa eu lorem commodo ullamcorper.Interdum et malesuada fames ac ante.', 'Nulla' ); insert into ch18_plants ( id, ch18_plant_type_id, names_local, names_english, name_latin, description, habitat, cultivation, use, photo, hyperlinks, status ) values ( 9, 8, 'Inventory Quality Control Upgrade', 'Porttitor ligula. Nam semper diam suscipit elementum sodales. Proin sit amet massa eu lorem.', 'Semper Diam Suscipit', 'Semper diam suscipit elementum sodales. Proin sit amet massa eu lorem commodo ullamcorper.Interdum et malesuada fames ac ante ipsum primis in faucibus.', 'Commodo Ullamcorperinterdum Et Malesuada', 'Proin sit amet massa eu lorem commodo ullamcorper.Interdum et malesuada fames ac ante ipsum primis i', 'Imperdiet ex. Etiam cursus porttitor tincidunt. Vestibulum ante ipsumprimis in.', null, 'Amet massa eu lorem commodo ullamcorper.Interdum et malesuada fames ac ante ipsum.', 'Vestibulum' ); insert into ch18_plants ( id, ch18_plant_type_id, names_local, names_english, name_latin, description, habitat, cultivation, use, photo, hyperlinks, status ) values ( 10, 6, 'Checklist Management System', 'Vulputate placerat pellentesque. Proin viverra lacinialectus, quis consectetur mi venenatis nec. Don', 'Vitae Ligula Commodo', 'Iaculis aliquam. Vestibulum lacinia arcu in massa pharetra, id mattis risus rhoncus.Cras vulputate porttitor ligula. Nam semper diam suscipit elementum sodales. Proin sit amet massa eu lorem commodo u', 'Et Ultrices Posuere Cubilia', 'Ut id nulla ac sapien suscipit tristique ac volutpat risus.Phasellus vitae ligula commodo, dictum lo', 'Tincidunt. Vestibulum ante ipsumprimis in faucibus orci luctus et ultrices posuere cubilia Curae; Pr', null, 'Ligula commodo, dictum lorem sit amet, imperdiet.', 'Fames' ); insert into ch18_plants ( id, ch18_plant_type_id, names_local, names_english, name_latin, description, habitat, cultivation, use, photo, hyperlinks, status ) values ( 11, 9, 'CMS Training', 'Vulputate placerat pellentesque. Proin viverra lacinialectus, quis consectetur mi venenatis nec. Don', 'In Massa Pharetra', 'Proin sit amet massa eu lorem commodo ullamcorper.Interdum et malesuada fames ac ante ipsum primis in faucibus. Ut id nulla ac sapien suscipit tristique ac volutpat risus.Phasellus vitae ligula commod', 'Rhoncuscras Vulputate Porttitor Ligula', 'Eu lorem commodo ullamcorper.Interdum et malesuada fames ac ante ipsum primis in faucibus. Ut id nul', 'Volutpat risus.Phasellus vitae ligula commodo, dictum lorem sit amet, imperdiet ex. Etiam cursus por', null, 'Ipsumprimis in faucibus orci luctus et ultrices posuere cubilia Curae; Proin vulputate placerat pell', 'Elit' ); insert into ch18_plants ( id, ch18_plant_type_id, names_local, names_english, name_latin, description, habitat, cultivation, use, photo, hyperlinks, status ) values ( 12, 10, 'Battery Upgrade', 'Et ultrices posuere cubilia Curae; Proin vulputate placerat pellentesque. Proin viverra lacinialectu', 'Tincidunt Vestibulum Ante', 'Mattis risus rhoncus.Cras vulputate porttitor ligula. Nam semper diam suscipit elementum sodales. Proin sit amet massa eu lorem commodo ullamcorper.Interdum et malesuada fames ac ante ipsum primis in ', 'Curae; Proin Vulputate Placerat', 'Orci luctus et ultrices posuere cubilia Curae; Proin vulputate placerat pellentesque. Proin viverra ', 'Ipsum primis in faucibus. Ut id nulla ac sapien suscipit tristique ac volutpat risus.Phasellus vitae', null, 'Lacinia arcu in massa pharetra, id mattis risus rhoncus.Cras vulputate porttitor ligula. Nam semper ', 'Sodales' ); insert into ch18_plants ( id, ch18_plant_type_id, names_local, names_english, name_latin, description, habitat, cultivation, use, photo, hyperlinks, status ) values ( 13, 8, 'Managed Portal', 'Quis consectetur mi venenatis nec. Donec convallis sollicitudin elementum. Nulla facilisi. In posuer', 'Faucibus Orci Luctus', 'Vulputate placerat pellentesque. Proin viverra lacinialectus, quis consectetur mi venenatis nec. Donec convallis sollicitudin elementum. Nulla facilisi. In posuere blandit leoeget malesuada. Vivamus e', 'Ut Id Nulla Ac', 'Non,molestie sit amet lectus. Nulla placerat iaculis aliquam. Vestibulum lacinia arcu in massa phare', 'Rhoncus non,molestie sit amet lectus. Nulla placerat iaculis aliquam. Vestibulum lacinia arcu in mas', null, 'Sodales. Proin sit amet massa eu lorem commodo ullamcorper.Interdum et malesuada fames ac ante ipsum', 'Nonmolestie' ); insert into ch18_plants ( id, ch18_plant_type_id, names_local, names_english, name_latin, description, habitat, cultivation, use, photo, hyperlinks, status ) values ( 14, 9, 'XML to JSON API transition', 'Consectetur mi venenatis nec. Donec convallis sollicitudin elementum. Nulla facilisi. In posuere bla', 'Nulla Placerat Iaculis', 'Placerat pellentesque. Proin viverra lacinialectus, quis consectetur mi venenatis nec. Donec convallis sollicitudin elementum. Nulla facilisi. In posuere blandit leoeget malesuada. Vivamus efficitur i', 'Aliquam Vestibulum Lacinia Arcu', 'Et ultrices posuere cubilia Curae; Proin vulputate placerat pellentesque. Proin viverra lacinialectu', 'Vulputate porttitor ligula. Nam semper diam suscipit elementum sodales. Proin sit amet massa eu lore', null, 'Vestibulum lacinia arcu in massa pharetra, id mattis risus rhoncus.Cras vulputate porttitor ligula. ', 'Ac' ); insert into ch18_plants ( id, ch18_plant_type_id, names_local, names_english, name_latin, description, habitat, cultivation, use, photo, hyperlinks, status ) values ( 15, 10, 'F5 Network Upgrade', 'Orci luctus et ultrices posuere cubilia Curae; Proin vulputate placerat pellentesque. Proin viverra ', 'Orci Luctus Et', 'Primis in faucibus. Ut id nulla ac sapien suscipit tristique ac volutpat risus.Phasellus vitae ligula commodo, dictum lorem sit amet, imperdiet ex. Etiam cursus porttitor tincidunt. Vestibulum ante ip', 'Posuere Cubilia Curae; Proin', 'Posuere cubilia Curae; Proin vulputate placerat pellentesque. Proin viverra lacinialectus, quis cons', 'Dictum lorem sit amet, imperdiet ex. Etiam cursus porttitor tincidunt. Vestibulum ante ipsumprimis i', null, 'In faucibus. Ut id nulla ac sapien suscipit tristique ac volutpat risus.Phasellus vitae ligula commo', 'Et' ); insert into ch18_plants ( id, ch18_plant_type_id, names_local, names_english, name_latin, description, habitat, cultivation, use, photo, hyperlinks, status ) values ( 16, 8, 'Artifact Management System', 'Elementum. Nulla facilisi. In posuere blandit leoeget malesuada. Vivamus efficitur ipsum tellus, qui', 'Vestibulum Lacinia Arcu', 'Amet lectus. Nulla placerat iaculis aliquam. Vestibulum lacinia arcu in massa pharetra, id mattis risus rhoncus.Cras vulputate porttitor ligula. Nam semper diam suscipit elementum sodales. Proin sit a', 'Consectetur Mi Venenatis Nec', 'Cursus porttitor tincidunt. Vestibulum ante ipsumprimis in faucibus orci luctus et ultrices posuere ', 'Diam suscipit elementum sodales. Proin sit amet massa eu lorem commodo ullamcorper.Interdum et males', null, 'Arcu in massa pharetra, id mattis risus rhoncus.Cras vulputate porttitor ligula. Nam semper diam sus', 'Semper' ); insert into ch18_plants ( id, ch18_plant_type_id, names_local, names_english, name_latin, description, habitat, cultivation, use, photo, hyperlinks, status ) values ( 17, 2, 'Buying Behavior AI Module', 'Ut id nulla ac sapien suscipit tristique.', 'Nonmolestie Sit Amet', 'Amet lectus. Nulla placerat iaculis aliquam. Vestibulum lacinia arcu in massa pharetra, id mattis risus rhoncus.Cras vulputate porttitor ligula. Nam semper diam suscipit elementum sodales. Proin sit a', 'Massa Pharetra Id Mattis', 'Ac sapien suscipit tristique ac volutpat risus.Phasellus vitae ligula commodo, dictum lorem.', 'Sit amet, imperdiet ex. Etiam cursus porttitor tincidunt. Vestibulum ante ipsumprimis in.', null, 'Tincidunt. Vestibulum ante ipsumprimis in faucibus orci luctus et ultrices posuere cubilia Curae; Pr', 'Lacinia' ); insert into ch18_plants ( id, ch18_plant_type_id, names_local, names_english, name_latin, description, habitat, cultivation, use, photo, hyperlinks, status ) values ( 18, 1, 'Distribution Subsidiary Integration', 'Sodales. Proin sit amet massa eu lorem commodo ullamcorper.Interdum et malesuada fames ac ante ipsum', 'Placerat Pellentesque Proin', 'Elementum. Nulla facilisi. In posuere blandit leoeget malesuada. Vivamus efficitur ipsum tellus, quis posuere mi maximus vitae. Quisque tortor odio, feugiat eget sagittisvel, pretium ut metus. Duis et', 'Orci Luctus Et Ultrices', 'In faucibus. Ut id nulla ac sapien suscipit tristique ac volutpat risus.Phasellus vitae ligula commo', 'Id nulla ac sapien suscipit tristique ac volutpat risus.Phasellus vitae ligula commodo, dictum lorem', null, 'Massa eu lorem commodo ullamcorper.Interdum et malesuada fames ac ante ipsum primis in faucibus. Ut ', 'Rhoncus' ); insert into ch18_plants ( id, ch18_plant_type_id, names_local, names_english, name_latin, description, habitat, cultivation, use, photo, hyperlinks, status ) values ( 19, 3, 'CMOS Memory Upgrade', 'Malesuada fames ac ante ipsum primis in faucibus. Ut id nulla ac sapien suscipit tristique ac volutp', 'Elit Vestibulum Eget', 'Ut id nulla ac sapien suscipit tristique ac volutpat risus.Phasellus vitae ligula commodo, dictum lorem sit amet, imperdiet ex. Etiam cursus porttitor tincidunt. Vestibulum ante ipsumprimis in faucibu', 'Consectetur Mi Venenatis Nec', 'Ante ipsumprimis in faucibus orci luctus et ultrices posuere cubilia Curae; Proin vulputate placerat', 'In faucibus. Ut id nulla ac sapien suscipit tristique ac volutpat risus.Phasellus vitae ligula commo', null, 'Proin vulputate placerat pellentesque. Proin viverra lacinialectus, quis consectetur mi venenatis ne', 'Ipsumprimis' ); insert into ch18_plants ( id, ch18_plant_type_id, names_local, names_english, name_latin, description, habitat, cultivation, use, photo, hyperlinks, status ) values ( 20, 6, 'Dynamic Optimization Portal', 'Elementum. Nulla facilisi. In posuere blandit leoeget malesuada. Vivamus efficitur ipsum tellus, qui', 'Curae; Proin Vulputate', 'Diam suscipit elementum sodales. Proin sit amet massa eu lorem commodo ullamcorper.Interdum et malesuada fames ac ante.', 'Lorem Commodo Ullamcorperinterdum Et', 'Proin viverra lacinialectus, quis consectetur mi venenatis nec. Donec convallis sollicitudin element', 'Amet lectus. Nulla placerat iaculis aliquam. Vestibulum lacinia arcu in massa pharetra, id mattis ri', null, 'Vestibulum ante ipsumprimis in faucibus orci luctus et ultrices posuere cubilia Curae; Proin vulputa', 'Sapien' ); commit; alter table ch18_plants modify id generated by default on null as identity restart start with 21; -- load data insert into ch18_offer ( id, ch18_offer_plant_id, ch18_offer_user_id, bid_or_ask, quantity, location, bidder, comments, offer_date, valid_to ) values ( 1, 5, 3, 'Eget rhoncus non,molestie sit amet lectus. Nulla placerat iaculis aliquam. Vestibulum lacinia arcu i', 56, 'Tanquecitos', 'Nonmolestie Sit Amet Lectus', 'Ante ipsumprimis in faucibus orci luctus et ultrices posuere cubilia Curae; Proin vulputate placerat pellentesque. Proin viverra lacinialectus, quis consectetur mi venenatis nec. Donec convallis solli', sysdate - 4, 'Lorem sit amet, imperdiet ex. Etiam cursus porttitor tincidunt. Vestibulum ante ipsumprimis in fauci' ); insert into ch18_offer ( id, ch18_offer_plant_id, ch18_offer_user_id, bid_or_ask, quantity, location, bidder, comments, offer_date, valid_to ) values ( 2, 14, 3, 'Faucibus orci luctus et ultrices posuere cubilia Curae; Proin vulputate placerat pellentesque. Proin', 79, 'Sugarloaf', 'Malesuada Fames Ac Ante', 'Risus rhoncus.Cras vulputate porttitor ligula. Nam semper diam suscipit elementum sodales. Proin sit amet massa eu lorem commodo ullamcorper.Interdum et malesuada fames ac ante ipsum primis in faucibu', sysdate - 28, 'Porttitor ligula. Nam semper diam suscipit elementum sodales. Proin sit amet massa eu lorem commodo ' ); insert into ch18_offer ( id, ch18_offer_plant_id, ch18_offer_user_id, bid_or_ask, quantity, location, bidder, comments, offer_date, valid_to ) values ( 3, 17, 8, 'Sit amet lectus. Nulla placerat iaculis aliquam. Vestibulum lacinia arcu in massa pharetra, id.', 95, 'Dale City', 'Malesuada Fames Ac Ante', 'Ex. Etiam cursus porttitor tincidunt. Vestibulum ante ipsumprimis in faucibus orci luctus et ultrices posuere cubilia Curae; Proin vulputate placerat pellentesque. Proin.', sysdate - 6, 'Volutpat.' ); insert into ch18_offer ( id, ch18_offer_plant_id, ch18_offer_user_id, bid_or_ask, quantity, location, bidder, comments, offer_date, valid_to ) values ( 4, 13, 8, 'Pharetra, id mattis risus rhoncus.Cras vulputate porttitor ligula. Nam semper diam suscipit elementu', 68, 'Grosvenor', 'Proin Vulputate Placerat Pellentesque', 'Placerat iaculis aliquam. Vestibulum lacinia arcu in massa pharetra, id mattis risus rhoncus.Cras vulputate porttitor ligula. Nam semper diam suscipit elementum sodales. Proin sit amet massa eu lorem ', sysdate - 73, 'Placerat iaculis aliquam. Vestibulum lacinia arcu in.' ); insert into ch18_offer ( id, ch18_offer_plant_id, ch18_offer_user_id, bid_or_ask, quantity, location, bidder, comments, offer_date, valid_to ) values ( 5, 3, 6, 'Risus rhoncus.Cras vulputate porttitor ligula. Nam semper diam suscipit elementum sodales. Proin sit', 49, 'Riverside', 'Id Mattis Risus Rhoncuscras', 'Iaculis aliquam. Vestibulum lacinia arcu in massa pharetra, id mattis risus rhoncus.Cras vulputate porttitor ligula. Nam semper diam suscipit elementum sodales. Proin sit amet massa eu lorem commodo u', sysdate - 1, 'Aliquam. Vestibulum lacinia arcu in massa pharetra, id mattis risus rhoncus.Cras vulputate porttitor' ); insert into ch18_offer ( id, ch18_offer_plant_id, ch18_offer_user_id, bid_or_ask, quantity, location, bidder, comments, offer_date, valid_to ) values ( 6, 9, 1, 'Proin viverra lacinialectus, quis consectetur mi venenatis nec. Donec convallis sollicitudin element', 31, 'Ridgeley', 'Ultrices Posuere Cubilia Curae;', 'Id nulla ac sapien suscipit tristique ac volutpat risus.Phasellus vitae ligula commodo, dictum lorem sit amet, imperdiet ex. Etiam cursus porttitor tincidunt. Vestibulum ante.', sysdate - 97, 'Ex. Etiam cursus porttitor tincidunt. Vestibulum ante ipsumprimis in faucibus orci luctus et ultrice' ); insert into ch18_offer ( id, ch18_offer_plant_id, ch18_offer_user_id, bid_or_ask, quantity, location, bidder, comments, offer_date, valid_to ) values ( 7, 2, 2, 'Tincidunt. Vestibulum ante ipsumprimis in faucibus orci luctus et ultrices posuere cubilia Curae; Pr', 89, 'Ashley Heights', 'Faucibus Ut Id Nulla', 'Vulputate porttitor ligula. Nam semper diam suscipit elementum sodales. Proin sit amet massa eu lorem.', sysdate - 75, 'Amet lectus. Nulla placerat iaculis aliquam. Vestibulum lacinia arcu in massa pharetra, id mattis ri' ); insert into ch18_offer ( id, ch18_offer_plant_id, ch18_offer_user_id, bid_or_ask, quantity, location, bidder, comments, offer_date, valid_to ) values ( 8, 14, 1, 'Risus.Phasellus vitae ligula commodo, dictum lorem sit amet, imperdiet ex. Etiam cursus porttitor ti', 46, 'Monfort Heights', 'Nulla Facilisi In Posuere', 'Ut id nulla ac sapien suscipit tristique ac volutpat risus.Phasellus vitae ligula commodo, dictum lorem sit amet, imperdiet ex. Etiam cursus porttitor tincidunt. Vestibulum ante ipsumprimis in faucibu', sysdate - 47, 'Tristique ac volutpat risus.Phasellus vitae ligula commodo, dictum lorem sit amet, imperdiet ex. Eti' ); insert into ch18_offer ( id, ch18_offer_plant_id, ch18_offer_user_id, bid_or_ask, quantity, location, bidder, comments, offer_date, valid_to ) values ( 9, 16, 2, 'Ut id nulla ac sapien suscipit tristique ac volutpat risus.Phasellus vitae ligula commodo, dictum lo', 8, 'Point Marion', 'Vestibulum Eget Rhoncus Nonmolestie', 'Viverra lacinialectus, quis consectetur mi venenatis nec. Donec convallis sollicitudin elementum. Nulla facilisi. In posuere blandit leoeget malesuada. Vivamus efficitur ipsum tellus, quis posuere mi ', sysdate - 79, 'Porttitor tincidunt. Vestibulum ante ipsumprimis in faucibus orci luctus et ultrices posuere cubilia' ); insert into ch18_offer ( id, ch18_offer_plant_id, ch18_offer_user_id, bid_or_ask, quantity, location, bidder, comments, offer_date, valid_to ) values ( 10, 3, 7, 'Ac sapien suscipit tristique ac volutpat risus.Phasellus vitae ligula commodo.', 80, 'Eldon', 'Luctus Et Ultrices Posuere', 'Eu lorem commodo ullamcorper.Interdum et malesuada fames ac ante ipsum primis in faucibus. Ut id nulla ac sapien suscipit tristique ac volutpat risus.Phasellus vitae ligula commodo, dictum lorem sit a', sysdate - 37, 'Cubilia Curae; Proin vulputate.' ); insert into ch18_offer ( id, ch18_offer_plant_id, ch18_offer_user_id, bid_or_ask, quantity, location, bidder, comments, offer_date, valid_to ) values ( 11, 16, 6, 'Fames ac ante ipsum primis in faucibus. Ut id nulla ac sapien suscipit tristique ac volutpat risus.P', 72, 'Greendale', 'Tristique Ac Volutpat Risusphasellus', 'Placerat iaculis aliquam. Vestibulum lacinia arcu in massa pharetra, id mattis risus rhoncus.Cras vulputate porttitor ligula. Nam semper diam suscipit elementum sodales. Proin sit amet massa eu lorem ', sysdate - 59, 'Volutpat risus.Phasellus vitae ligula commodo, dictum lorem sit amet, imperdiet ex. Etiam cursus por' ); insert into ch18_offer ( id, ch18_offer_plant_id, ch18_offer_user_id, bid_or_ask, quantity, location, bidder, comments, offer_date, valid_to ) values ( 12, 9, 6, 'Proin vulputate placerat pellentesque. Proin viverra lacinialectus, quis consectetur mi venenatis ne', 80, 'Ammon', 'Posuere Cubilia Curae; Proin', 'Sit amet massa eu lorem commodo ullamcorper.Interdum et malesuada fames ac ante ipsum primis in faucibus. Ut id nulla ac sapien suscipit tristique ac volutpat risus.Phasellus vitae ligula commodo, dic', sysdate - 58, 'Dictum lorem sit amet, imperdiet ex. Etiam cursus porttitor tincidunt. Vestibulum ante ipsumprimis i' ); insert into ch18_offer ( id, ch18_offer_plant_id, ch18_offer_user_id, bid_or_ask, quantity, location, bidder, comments, offer_date, valid_to ) values ( 13, 3, 5, 'Elementum. Nulla facilisi. In posuere blandit leoeget malesuada. Vivamus efficitur ipsum tellus, qui', 5, 'Wallsburg', 'Commodo Ullamcorperinterdum Et Malesuada', 'Amet, imperdiet ex. Etiam cursus porttitor tincidunt. Vestibulum ante ipsumprimis.', sysdate - 49, 'Tincidunt. Vestibulum ante ipsumprimis in faucibus orci luctus et ultrices posuere cubilia.' ); insert into ch18_offer ( id, ch18_offer_plant_id, ch18_offer_user_id, bid_or_ask, quantity, location, bidder, comments, offer_date, valid_to ) values ( 14, 1, 7, 'Luctus et ultrices posuere cubilia Curae; Proin vulputate placerat pellentesque. Proin viverra lacin', 67, 'De Pue', 'Cursus Porttitor Tincidunt Vestibulum', 'Suscipit elementum sodales. Proin sit amet massa eu lorem commodo ullamcorper.Interdum et malesuada fames ac ante ipsum primis in faucibus. Ut id nulla ac sapien suscipit tristique ac volutpat risus.P', sysdate - 43, 'Nulla placerat iaculis aliquam. Vestibulum lacinia arcu in.' ); insert into ch18_offer ( id, ch18_offer_plant_id, ch18_offer_user_id, bid_or_ask, quantity, location, bidder, comments, offer_date, valid_to ) values ( 15, 14, 8, 'Massa eu lorem commodo ullamcorper.Interdum et malesuada fames ac ante ipsum primis in faucibus. Ut ', 27, 'Prompton', 'Eget Rhoncus Nonmolestie Sit', 'Faucibus orci luctus et ultrices posuere cubilia Curae; Proin vulputate placerat pellentesque. Proin viverra lacinialectus, quis consectetur mi venenatis nec. Donec convallis sollicitudin elementum. N', sysdate - 72, 'Luctus et ultrices posuere cubilia Curae; Proin vulputate placerat pellentesque. Proin viverra lacin' ); insert into ch18_offer ( id, ch18_offer_plant_id, ch18_offer_user_id, bid_or_ask, quantity, location, bidder, comments, offer_date, valid_to ) values ( 16, 10, 8, 'Vulputate placerat pellentesque. Proin viverra lacinialectus, quis consectetur mi venenatis nec. Don', 35, 'New Rockford', 'Massa Pharetra Id Mattis', 'Pharetra, id mattis risus rhoncus.Cras.', sysdate - 86, 'Malesuada fames ac ante ipsum primis in faucibus. Ut id nulla ac sapien suscipit tristique ac volutp' ); insert into ch18_offer ( id, ch18_offer_plant_id, ch18_offer_user_id, bid_or_ask, quantity, location, bidder, comments, offer_date, valid_to ) values ( 17, 13, 9, 'Et malesuada fames ac ante ipsum primis in faucibus. Ut id.', 18, 'Tygh Valley', 'Volutpat Risusphasellus Vitae Ligula', 'Vitae ligula commodo, dictum lorem sit.', sysdate - 24, 'Consectetur mi venenatis nec. Donec convallis sollicitudin elementum. Nulla facilisi. In posuere bla' ); insert into ch18_offer ( id, ch18_offer_plant_id, ch18_offer_user_id, bid_or_ask, quantity, location, bidder, comments, offer_date, valid_to ) values ( 18, 5, 6, 'Non,molestie sit amet lectus. Nulla placerat iaculis aliquam. Vestibulum lacinia arcu in massa phare', 82, 'Lookout', 'Viverra Lacinialectus Quis Consectetur', 'Cubilia Curae; Proin vulputate placerat pellentesque. Proin viverra lacinialectus, quis consectetur mi venenatis nec. Donec convallis sollicitudin elementum. Nulla facilisi. In posuere blandit leoeget', sysdate - 21, 'Nec. Donec convallis sollicitudin elementum. Nulla facilisi. In posuere blandit leoeget malesuada. V' ); insert into ch18_offer ( id, ch18_offer_plant_id, ch18_offer_user_id, bid_or_ask, quantity, location, bidder, comments, offer_date, valid_to ) values ( 19, 18, 1, 'Donec convallis sollicitudin elementum. Nulla facilisi. In posuere.', 33, 'Hermiston', 'Lectus Nulla Placerat Iaculis', 'Semper diam suscipit elementum sodales. Proin sit amet massa eu lorem commodo ullamcorper.Interdum et malesuada fames ac ante ipsum primis in faucibus. Ut id nulla ac sapien suscipit tristique ac volu', sysdate - 61, 'Donec convallis sollicitudin elementum.' ); insert into ch18_offer ( id, ch18_offer_plant_id, ch18_offer_user_id, bid_or_ask, quantity, location, bidder, comments, offer_date, valid_to ) values ( 20, 15, 3, 'Primis in faucibus. Ut id nulla ac sapien suscipit tristique ac volutpat risus.Phasellus vitae ligul', 6, 'Mendota Heights', 'Eget Rhoncus Nonmolestie Sit', 'Porttitor tincidunt. Vestibulum ante ipsumprimis in faucibus orci luctus et ultrices posuere cubilia Curae; Proin vulputate placerat pellentesque. Proin viverra lacinialectus, quis consectetur mi vene', sysdate - 64, 'Nulla ac sapien suscipit tristique ac volutpat risus.Phasellus vitae ligula commodo, dictum lorem si' ); commit; alter table ch18_offer modify id generated by default on null as identity restart start with 21; -- load data insert into ch18_message ( id, ch18_message_user_id1, ch18_message_user_id2, ch18_message_offer_id, visibility, message_date, content, status ) values ( 1, 10, 7, 4, 'Risus rhoncus.Cras vulputate porttitor ligula. Nam semper diam suscipit elementum sodales. Proin sit', sysdate - 70, 'Venenatis nec. Donec convallis sollicitudin.', 'Nec Donec Convallis Sollicitudin' ); insert into ch18_message ( id, ch18_message_user_id1, ch18_message_user_id2, ch18_message_offer_id, visibility, message_date, content, status ) values ( 2, 7, 6, 15, 'Massa eu lorem commodo ullamcorper.Interdum et malesuada fames ac ante ipsum primis in faucibus. Ut ', sysdate - 20, 'Malesuada fames ac ante ipsum primis in faucibus. Ut id nulla ac sapien suscipit tristique ac volutpat risus.Phasellus vitae ligula commodo, dictum lorem sit amet, imperdiet ex. Etiam cursus porttitor', 'Et Malesuada Fames Ac' ); insert into ch18_message ( id, ch18_message_user_id1, ch18_message_user_id2, ch18_message_offer_id, visibility, message_date, content, status ) values ( 3, 3, 4, 13, 'Tristique ac volutpat risus.Phasellus vitae ligula commodo, dictum lorem sit amet, imperdiet ex. Eti', sysdate - 79, 'Ac sapien suscipit tristique ac volutpat risus.Phasellus vitae ligula commodo.', 'Lorem Sit Amet Imperdiet' ); insert into ch18_message ( id, ch18_message_user_id1, ch18_message_user_id2, ch18_message_offer_id, visibility, message_date, content, status ) values ( 4, 2, 6, 11, 'Sit amet lectus. Nulla placerat iaculis aliquam. Vestibulum lacinia arcu in massa pharetra, id matti', sysdate - 88, 'Faucibus. Ut id nulla ac sapien suscipit tristique ac volutpat risus.Phasellus vitae ligula commodo, dictum lorem sit amet, imperdiet ex. Etiam cursus porttitor tincidunt. Vestibulum ante ipsumprimis ', 'Sit Amet Lectus Nulla' ); insert into ch18_message ( id, ch18_message_user_id1, ch18_message_user_id2, ch18_message_offer_id, visibility, message_date, content, status ) values ( 5, 3, 1, 2, 'Vestibulum lacinia arcu in massa pharetra, id mattis risus rhoncus.Cras vulputate porttitor ligula. ', sysdate - 15, 'Nulla facilisi. In posuere blandit leoeget malesuada. Vivamus efficitur.', 'Vulputate Placerat Pellentesque Proin' ); insert into ch18_message ( id, ch18_message_user_id1, ch18_message_user_id2, ch18_message_offer_id, visibility, message_date, content, status ) values ( 6, 9, 5, 20, 'Etiam cursus porttitor tincidunt. Vestibulum ante ipsumprimis in faucibus orci luctus et ultrices po', sysdate - 80, 'Nulla facilisi. In posuere blandit leoeget malesuada. Vivamus efficitur.', 'Dictum Lorem Sit Amet' ); insert into ch18_message ( id, ch18_message_user_id1, ch18_message_user_id2, ch18_message_offer_id, visibility, message_date, content, status ) values ( 7, 10, 1, 19, 'Vestibulum lacinia arcu in massa pharetra, id mattis risus rhoncus.Cras vulputate porttitor ligula. ', sysdate - 46, 'Malesuada fames ac ante ipsum primis in faucibus. Ut id nulla ac sapien.', 'Ante Ipsum Primis In' ); insert into ch18_message ( id, ch18_message_user_id1, ch18_message_user_id2, ch18_message_offer_id, visibility, message_date, content, status ) values ( 8, 1, 10, 4, 'In faucibus.', sysdate - 96, 'Lacinialectus, quis consectetur mi venenatis nec. Donec convallis sollicitudin elementum. Nulla facilisi. In posuere blandit leoeget malesuada. Vivamus efficitur ipsum tellus, quis posuere.', 'Lacinia Arcu In Massa' ); insert into ch18_message ( id, ch18_message_user_id1, ch18_message_user_id2, ch18_message_offer_id, visibility, message_date, content, status ) values ( 9, 3, 7, 12, 'Mi venenatis nec. Donec convallis sollicitudin elementum. Nulla facilisi. In posuere blandit leoeget', sysdate - 18, 'Tincidunt. Vestibulum ante ipsumprimis in faucibus orci luctus et ultrices posuere cubilia Curae; Proin vulputate placerat pellentesque. Proin viverra lacinialectus, quis consectetur mi venenatis nec.', 'Venenatis Nec Donec Convallis' ); insert into ch18_message ( id, ch18_message_user_id1, ch18_message_user_id2, ch18_message_offer_id, visibility, message_date, content, status ) values ( 10, 10, 7, 9, 'Volutpat risus.Phasellus vitae ligula commodo, dictum lorem sit amet, imperdiet ex. Etiam cursus por', sysdate - 87, 'Tincidunt. Vestibulum ante ipsumprimis in faucibus orci luctus et ultrices posuere cubilia Curae; Proin vulputate placerat pellentesque. Proin viverra lacinialectus, quis consectetur mi venenatis nec.', 'Mattis Risus Rhoncuscras Vulputate' ); insert into ch18_message ( id, ch18_message_user_id1, ch18_message_user_id2, ch18_message_offer_id, visibility, message_date, content, status ) values ( 11, 7, 8, 3, 'Volutpat risus.Phasellus vitae ligula commodo, dictum lorem sit amet, imperdiet ex. Etiam cursus por', sysdate - 14, 'Ante ipsumprimis in faucibus orci luctus et ultrices posuere cubilia Curae; Proin vulputate placerat pellentesque. Proin viverra lacinialectus, quis consectetur mi venenatis nec. Donec convallis solli', 'In Faucibus Orci Luctus' ); insert into ch18_message ( id, ch18_message_user_id1, ch18_message_user_id2, ch18_message_offer_id, visibility, message_date, content, status ) values ( 12, 6, 7, 11, 'Sit amet lectus. Nulla placerat iaculis aliquam. Vestibulum lacinia arcu in massa pharetra, id matti', sysdate - 99, 'Sit amet, imperdiet ex. Etiam cursus porttitor tincidunt. Vestibulum ante ipsumprimis in.', 'Ultrices Posuere Cubilia Curae;' ); insert into ch18_message ( id, ch18_message_user_id1, ch18_message_user_id2, ch18_message_offer_id, visibility, message_date, content, status ) values ( 13, 8, 9, 10, 'Rhoncus non,molestie sit amet lectus. Nulla placerat iaculis aliquam. Vestibulum lacinia arcu in mas', sysdate - 83, 'Faucibus orci luctus et ultrices posuere cubilia Curae; Proin vulputate placerat pellentesque. Proin viverra lacinialectus.', 'Placerat Pellentesque Proin Viverra' ); insert into ch18_message ( id, ch18_message_user_id1, ch18_message_user_id2, ch18_message_offer_id, visibility, message_date, content, status ) values ( 14, 3, 4, 18, 'Amet massa eu lorem commodo ullamcorper.Interdum et malesuada fames ac ante ipsum.', sysdate - 47, 'Fames ac ante ipsum primis in faucibus. Ut id nulla ac sapien suscipit tristique ac volutpat risus.Phasellus vitae ligula commodo, dictum lorem sit amet, imperdiet ex. Etiam cursus porttitor tincidunt', 'Pellentesque Proin Viverra Lacinialectus' ); insert into ch18_message ( id, ch18_message_user_id1, ch18_message_user_id2, ch18_message_offer_id, visibility, message_date, content, status ) values ( 15, 3, 9, 20, 'Porttitor tincidunt. Vestibulum ante ipsumprimis in faucibus orci luctus et ultrices posuere cubilia', sysdate - 35, 'Non,molestie sit amet lectus. Nulla placerat iaculis aliquam. Vestibulum lacinia arcu in massa pharetra.', 'Vestibulum Eget Rhoncus Nonmolestie' ); insert into ch18_message ( id, ch18_message_user_id1, ch18_message_user_id2, ch18_message_offer_id, visibility, message_date, content, status ) values ( 16, 7, 10, 5, 'In massa pharetra, id mattis risus rhoncus.Cras vulputate porttitor ligula. Nam semper diam suscipit', sysdate - 77, 'Nulla ac sapien suscipit tristique ac volutpat risus.Phasellus vitae ligula commodo, dictum lorem sit amet, imperdiet ex. Etiam cursus porttitor tincidunt. Vestibulum ante ipsumprimis in faucibus orci', 'Massa Pharetra Id Mattis' ); insert into ch18_message ( id, ch18_message_user_id1, ch18_message_user_id2, ch18_message_offer_id, visibility, message_date, content, status ) values ( 17, 6, 5, 16, 'Arcu in massa pharetra, id mattis risus rhoncus.Cras vulputate porttitor.', sysdate - 1, 'Sodales. Proin sit amet massa eu lorem commodo ullamcorper.Interdum et malesuada fames ac ante ipsum primis in faucibus. Ut.', 'Risusphasellus Vitae Ligula Commodo' ); insert into ch18_message ( id, ch18_message_user_id1, ch18_message_user_id2, ch18_message_offer_id, visibility, message_date, content, status ) values ( 18, 3, 2, 2, 'Ut id nulla ac sapien suscipit tristique.', sysdate - 94, 'Vulputate placerat pellentesque. Proin viverra lacinialectus, quis consectetur mi venenatis nec.', 'Porttitor Tincidunt Vestibulum Ante' ); insert into ch18_message ( id, ch18_message_user_id1, ch18_message_user_id2, ch18_message_offer_id, visibility, message_date, content, status ) values ( 19, 10, 3, 4, 'Volutpat risus.Phasellus vitae ligula commodo, dictum lorem sit amet, imperdiet ex. Etiam cursus por', sysdate - 86, 'Rhoncus non,molestie.', 'Et Ultrices Posuere Cubilia' ); insert into ch18_message ( id, ch18_message_user_id1, ch18_message_user_id2, ch18_message_offer_id, visibility, message_date, content, status ) values ( 20, 5, 4, 7, 'Ligula commodo, dictum lorem sit amet, imperdiet ex. Etiam cursus.', sysdate - 92, 'Vestibulum eget rhoncus non,molestie sit amet lectus. Nulla placerat iaculis aliquam. Vestibulum lacinia arcu in massa pharetra, id mattis risus rhoncus.Cras vulputate porttitor ligula. Nam semper dia', 'Nulla Ac Sapien Suscipit' ); commit; alter table ch18_message modify id generated by default on null as identity restart start with 21;