-- load data insert into ch14_type_of_plant ( id, name_of_type_of_plant, ch14_is_subtype_of ) values ( 1, 'Compendium GA', 1 ); insert into ch14_type_of_plant ( id, name_of_type_of_plant, ch14_is_subtype_of ) values ( 2, 'SOA Upgrade', 2 ); insert into ch14_type_of_plant ( id, name_of_type_of_plant, ch14_is_subtype_of ) values ( 3, 'Resiliency Monitoring', 1 ); insert into ch14_type_of_plant ( id, name_of_type_of_plant, ch14_is_subtype_of ) values ( 4, 'SDK Upgraded for Embedded Syst', 4 ); insert into ch14_type_of_plant ( id, name_of_type_of_plant, ch14_is_subtype_of ) values ( 5, 'U88 Application', 4 ); insert into ch14_type_of_plant ( id, name_of_type_of_plant, ch14_is_subtype_of ) values ( 6, 'Developer Bug Performance Revi', 1 ); insert into ch14_type_of_plant ( id, name_of_type_of_plant, ch14_is_subtype_of ) values ( 7, 'FAQ Automated Publishing', 6 ); insert into ch14_type_of_plant ( id, name_of_type_of_plant, ch14_is_subtype_of ) values ( 8, 'Competitive Tracking', 2 ); insert into ch14_type_of_plant ( id, name_of_type_of_plant, ch14_is_subtype_of ) values ( 9, 'Inventory Quality Control Upgr', 8 ); insert into ch14_type_of_plant ( id, name_of_type_of_plant, ch14_is_subtype_of ) values ( 10, 'Checklist Management System', 5 ); commit; alter table ch14_type_of_plant modify id generated by default on null as identity restart start with 11; -- load data -- load data insert into ch14_plants ( id, ch14_plant_type_id, names_local, names_english, name_latin, description, habitat, cultivation, use, photo, hyperlinks, status ) values ( 1, 5, 'Compendium GA', 'Nulla ac sapien suscipit tristique ac volutpat risus.Phasellus vitae ligula commodo, dictum lorem si', 'Lacinia Arcu In', 'Placerat pellentesque. Proin.', 'Porttitor Tincidunt Vestibulum Ante', 'Diam suscipit elementum sodales. Proin sit amet massa eu lorem commodo ullamcorper.Interdum et males', 'Primis in faucibus. Ut id nulla ac sapien suscipit tristique ac volutpat risus.Phasellus vitae ligul', null, 'Orci luctus et ultrices posuere cubilia Curae; Proin vulputate placerat pellentesque. Proin viverra ', 'Vulputate' ); insert into ch14_plants ( id, ch14_plant_type_id, names_local, names_english, name_latin, description, habitat, cultivation, use, photo, hyperlinks, status ) values ( 2, 3, 'SOA Upgrade', 'Risus rhoncus.Cras vulputate porttitor ligula. Nam semper diam suscipit elementum sodales.', 'Etiam Cursus Porttitor', '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 ', 'Ac Volutpat Risusphasellus Vitae', 'Et malesuada fames ac ante ipsum primis in faucibus. Ut id nulla ac sapien suscipit tristique ac vol', 'Amet.', null, 'Sollicitudin elementum. Nulla facilisi. In.', 'In' ); insert into ch14_plants ( id, ch14_plant_type_id, names_local, names_english, name_latin, description, habitat, cultivation, use, photo, hyperlinks, status ) values ( 3, 5, 'Resiliency Monitoring', 'Eget rhoncus non,molestie sit amet lectus. Nulla placerat iaculis aliquam. Vestibulum.', 'Sapien Suscipit Tristique', 'Volutpat risus.Phasellus vitae ligula commodo, dictum lorem sit amet, imperdiet ex. Etiam cursus porttitor.', 'Semper Diam Suscipit Elementum', 'Ut id nulla ac sapien suscipit tristique ac volutpat risus.Phasellus vitae ligula commodo, dictum lo', 'Nec. Donec convallis sollicitudin elementum. Nulla facilisi. In posuere blandit leoeget malesuada. V', null, 'Nec. Donec convallis sollicitudin elementum. Nulla facilisi. In posuere.', 'Amet' ); insert into ch14_plants ( id, ch14_plant_type_id, names_local, names_english, name_latin, description, habitat, cultivation, use, photo, hyperlinks, status ) values ( 4, 7, 'SDK Upgraded for Embedded System', 'Posuere cubilia Curae; Proin vulputate placerat pellentesque. Proin viverra lacinialectus, quis cons', 'Ex Etiam Cursus', 'Sit amet massa eu lorem commodo ullamcorper.Interdum et malesuada fames ac ante ipsum primis in.', 'Vitae Ligula Commodo Dictum', 'Ante ipsumprimis in faucibus orci luctus et ultrices posuere cubilia Curae; Proin vulputate placerat', 'Eget rhoncus non,molestie sit amet lectus. Nulla placerat iaculis aliquam. Vestibulum lacinia arcu i', null, 'Id nulla ac sapien suscipit tristique ac volutpat risus.Phasellus vitae ligula commodo, dictum lorem', 'Rhoncus' ); insert into ch14_plants ( id, ch14_plant_type_id, names_local, names_english, name_latin, description, habitat, cultivation, use, photo, hyperlinks, status ) values ( 5, 1, 'U88 Application', 'Eu lorem commodo ullamcorper.Interdum et malesuada fames ac.', 'Viverra Lacinialectus Quis', '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 luctus e', 'Lacinialectus Quis Consectetur Mi', 'In massa pharetra, id mattis risus rhoncus.Cras vulputate porttitor ligula. Nam semper diam suscipit', 'Convallis sollicitudin elementum. Nulla facilisi. In posuere blandit leoeget malesuada. Vivamus effi', null, 'Ex. Etiam cursus porttitor tincidunt. Vestibulum ante ipsumprimis in faucibus orci luctus et ultrice', 'Massa' ); insert into ch14_plants ( id, ch14_plant_type_id, names_local, names_english, name_latin, description, habitat, cultivation, use, photo, hyperlinks, status ) values ( 6, 1, 'Developer Bug Performance Review', 'Placerat iaculis aliquam.', 'Ex Etiam Cursus', '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 amet', 'Fames Ac Ante Ipsum', 'Arcu in massa pharetra, id mattis risus rhoncus.Cras vulputate porttitor ligula. Nam semper diam sus', 'Vestibulum lacinia arcu.', null, 'Lacinia arcu in massa pharetra, id mattis risus rhoncus.Cras vulputate porttitor ligula. Nam semper ', 'Rhoncus' ); insert into ch14_plants ( id, ch14_plant_type_id, names_local, names_english, name_latin, description, habitat, cultivation, use, photo, hyperlinks, status ) values ( 7, 9, 'FAQ Automated Publishing', 'Sit amet, imperdiet ex. Etiam cursus porttitor tincidunt. Vestibulum ante ipsumprimis in faucibus or', 'Nulla Ac Sapien', 'In faucibus orci luctus et ultrices posuere cubilia Curae; Proin vulputate placerat pellentesque. Proin viverra lacinialectus, quis consectetur mi venenatis nec. Donec convallis.', 'Placerat Pellentesque Proin Viverra', 'Sit amet, imperdiet ex. Etiam cursus porttitor tincidunt. Vestibulum ante ipsumprimis in faucibus or', 'Risus rhoncus.Cras vulputate porttitor ligula. Nam semper diam suscipit elementum sodales. Proin sit', null, 'Porttitor ligula. Nam semper diam suscipit elementum sodales. Proin sit amet massa eu lorem commodo ', 'Ullamcorperinterdum' ); insert into ch14_plants ( id, ch14_plant_type_id, names_local, names_english, name_latin, description, habitat, cultivation, use, photo, hyperlinks, status ) values ( 8, 1, 'Competitive Tracking', 'Ipsum primis in faucibus. Ut id nulla ac sapien suscipit tristique.', 'Ac Ante Ipsum', '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.', 'Arcu In Massa Pharetra', 'Imperdiet ex. Etiam cursus porttitor.', 'In massa pharetra, id mattis risus rhoncus.Cras vulputate porttitor ligula. Nam semper diam suscipit', null, 'Vulputate porttitor ligula. Nam semper diam suscipit elementum sodales. Proin sit amet massa eu lore', 'Amet' ); insert into ch14_plants ( id, ch14_plant_type_id, names_local, names_english, name_latin, description, habitat, cultivation, use, photo, hyperlinks, status ) values ( 9, 4, 'Inventory Quality Control Upgrade', 'Nulla ac sapien suscipit tristique ac volutpat risus.Phasellus vitae ligula commodo, dictum lorem si', 'Arcu In Massa', '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 vive', 'Ac Ante Ipsum Primis', 'Ac sapien suscipit tristique ac volutpat risus.Phasellus vitae ligula commodo, dictum lorem.', 'Curae; Proin vulputate placerat pellentesque. Proin viverra lacinialectus, quis consectetur mi venen', null, 'Sodales. Proin sit amet massa eu lorem commodo ullamcorper.Interdum et malesuada fames ac ante ipsum', 'Ac' ); insert into ch14_plants ( id, ch14_plant_type_id, names_local, names_english, name_latin, description, habitat, cultivation, use, photo, hyperlinks, status ) values ( 10, 10, 'Checklist Management System', 'Ac sapien suscipit tristique ac volutpat risus.Phasellus vitae ligula commodo, dictum lorem sit amet', 'Mi Venenatis Nec', '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', 'Risusphasellus Vitae Ligula Commodo', 'Eu lorem commodo ullamcorper.Interdum et malesuada fames ac ante ipsum primis in faucibus. Ut id nul', 'Mi venenatis nec. Donec convallis sollicitudin elementum. Nulla facilisi. In posuere blandit leoeget', null, 'Orci luctus et ultrices posuere cubilia Curae; Proin vulputate placerat pellentesque. Proin viverra ', 'Donec' ); insert into ch14_plants ( id, ch14_plant_type_id, names_local, names_english, name_latin, description, habitat, cultivation, use, photo, hyperlinks, status ) values ( 11, 6, 'CMS Training', 'Ac volutpat risus.Phasellus vitae ligula commodo, dictum lorem sit amet, imperdiet ex. Etiam cursus ', 'Tristique Ac Volutpat', 'In massa pharetra, id mattis risus rhoncus.Cras vulputate porttitor.', 'Eget Rhoncus Nonmolestie Sit', 'Nulla placerat iaculis aliquam. Vestibulum lacinia arcu in massa pharetra, id mattis risus rhoncus.C', 'Donec convallis sollicitudin elementum. Nulla facilisi. In posuere.', null, 'Ut id nulla ac sapien suscipit tristique ac volutpat risus.Phasellus vitae ligula commodo, dictum lo', 'Lectus' ); insert into ch14_plants ( id, ch14_plant_type_id, names_local, names_english, name_latin, description, habitat, cultivation, use, photo, hyperlinks, status ) values ( 12, 10, 'Battery Upgrade', 'Et malesuada fames ac ante ipsum primis in faucibus. Ut id nulla ac sapien suscipit tristique ac vol', 'Proin Sit Amet', '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', 'Volutpat risus.Phasellus vitae ligula commodo, dictum lorem sit amet, imperdiet ex. Etiam cursus por', 'Aliquam. Vestibulum lacinia arcu in massa pharetra, id mattis risus rhoncus.Cras vulputate porttitor', null, 'Sollicitudin elementum. Nulla facilisi. In posuere blandit leoeget malesuada. Vivamus efficitur ipsu', 'Et' ); insert into ch14_plants ( id, ch14_plant_type_id, names_local, names_english, name_latin, description, habitat, cultivation, use, photo, hyperlinks, status ) values ( 13, 6, 'Managed Portal', 'Lorem sit amet, imperdiet ex. Etiam cursus porttitor tincidunt. Vestibulum ante ipsumprimis in fauci', 'Vestibulum Lacinia Arcu', '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', 'Suscipit Elementum Sodales Proin', 'Faucibus orci luctus et ultrices posuere cubilia Curae; Proin vulputate placerat pellentesque. Proin', 'Ac sapien suscipit tristique ac volutpat risus.Phasellus vitae ligula commodo.', null, 'Rhoncus non,molestie sit amet lectus. Nulla placerat iaculis aliquam. Vestibulum lacinia arcu in mas', 'Lacinialectus' ); insert into ch14_plants ( id, ch14_plant_type_id, names_local, names_english, name_latin, description, habitat, cultivation, use, photo, hyperlinks, status ) values ( 14, 3, 'XML to JSON API transition', 'Ligula. Nam semper diam suscipit elementum sodales. Proin sit amet.', 'Ac Sapien Suscipit', '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.', 'Suscipit Tristique Ac Volutpat', 'Porttitor ligula. Nam semper diam suscipit elementum sodales. Proin sit amet massa eu lorem commodo ', 'Risus.Phasellus vitae ligula commodo, dictum lorem sit amet, imperdiet ex. Etiam cursus porttitor ti', null, 'Id nulla ac sapien suscipit tristique ac volutpat risus.Phasellus vitae ligula commodo, dictum lorem', 'Sollicitudin' ); insert into ch14_plants ( id, ch14_plant_type_id, names_local, names_english, name_latin, description, habitat, cultivation, use, photo, hyperlinks, status ) values ( 15, 5, 'F5 Network Upgrade', 'Eu lorem commodo ullamcorper.Interdum et malesuada fames ac ante ipsum primis in faucibus. Ut id nul', 'Imperdiet Ex Etiam', '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.', 'Nam Semper Diam Suscipit', 'Sollicitudin elementum. Nulla facilisi. In posuere blandit leoeget malesuada. Vivamus efficitur ipsu', 'Luctus et ultrices posuere cubilia Curae; Proin vulputate placerat pellentesque. Proin viverra lacin', null, 'Et malesuada fames ac ante ipsum primis in faucibus. Ut id nulla ac sapien suscipit tristique ac vol', 'Proin' ); insert into ch14_plants ( id, ch14_plant_type_id, names_local, names_english, name_latin, description, habitat, cultivation, use, photo, hyperlinks, status ) values ( 16, 4, 'Artifact Management System', 'Sollicitudin elementum. Nulla facilisi. In posuere blandit leoeget malesuada. Vivamus efficitur ipsu', 'Convallis Sollicitudin Elementum', 'Proin vulputate placerat pellentesque. Proin viverra lacinialectus, quis consectetur mi venenatis nec. Donec convallis sollicitudin elementum. Nulla facilisi. In posuere blandit leoeget malesuada. Viv', 'Diam Suscipit Elementum Sodales', 'Ac sapien suscipit tristique ac volutpat risus.Phasellus vitae ligula commodo, dictum lorem.', 'Risus.Phasellus vitae ligula commodo, dictum lorem sit amet, imperdiet ex. Etiam cursus porttitor ti', null, 'Ante ipsum primis in faucibus. Ut id nulla ac sapien suscipit tristique ac volutpat risus.Phasellus ', 'Consectetur' ); insert into ch14_plants ( id, ch14_plant_type_id, names_local, names_english, name_latin, description, habitat, cultivation, use, photo, hyperlinks, status ) values ( 17, 4, 'Buying Behavior AI Module', 'Nulla placerat iaculis aliquam. Vestibulum lacinia arcu in.', 'Porttitor Ligula Nam', '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 ullamcorper.Interdum et malesuada fam', 'Elementum Nulla Facilisi In', 'Malesuada fames ac ante ipsum primis in faucibus. Ut id nulla ac sapien suscipit tristique ac volutp', 'Ligula. Nam semper diam suscipit elementum sodales. Proin sit amet massa eu lorem commodo ullamcorpe', null, 'Risus rhoncus.Cras vulputate porttitor ligula. Nam semper diam suscipit elementum sodales.', 'Nulla' ); insert into ch14_plants ( id, ch14_plant_type_id, names_local, names_english, name_latin, description, habitat, cultivation, use, photo, hyperlinks, status ) values ( 18, 4, 'Distribution Subsidiary Integration', 'Pharetra, id mattis risus rhoncus.Cras vulputate porttitor ligula. Nam semper diam suscipit elementu', 'Etiam Cursus Porttitor', '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 ullamcorp', 'Elementum Sodales Proin Sit', 'Luctus et ultrices posuere cubilia Curae; Proin vulputate placerat pellentesque.', 'Faucibus. Ut id nulla ac sapien suscipit.', null, 'Nulla facilisi. In posuere blandit leoeget malesuada. Vivamus efficitur.', 'Ex' ); insert into ch14_plants ( id, ch14_plant_type_id, names_local, names_english, name_latin, description, habitat, cultivation, use, photo, hyperlinks, status ) values ( 19, 4, 'CMOS Memory Upgrade', 'Luctus et ultrices posuere cubilia Curae; Proin vulputate placerat pellentesque. Proin viverra lacin', 'Sit Amet Lectus', 'Pellentesque. Proin viverra lacinialectus, quis consectetur mi venenatis nec. Donec convallis sollicitudin elementum. Nulla facilisi. In posuere blandit leoeget malesuada. Vivamus efficitur ipsum tell', 'Elementum Sodales Proin Sit', 'Ac sapien suscipit tristique ac volutpat risus.Phasellus vitae ligula commodo, dictum lorem sit amet', 'Suscipit tristique ac volutpat risus.Phasellus vitae ligula commodo, dictum lorem sit amet, imperdie', null, 'Eu lorem commodo ullamcorper.Interdum et malesuada fames ac.', 'Etiam' ); insert into ch14_plants ( id, ch14_plant_type_id, names_local, names_english, name_latin, description, habitat, cultivation, use, photo, hyperlinks, status ) values ( 20, 8, 'Dynamic Optimization Portal', 'Nulla placerat iaculis aliquam. Vestibulum lacinia arcu in.', 'Pellentesque Proin Viverra', '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', 'Lectus Nulla Placerat Iaculis', 'Posuere cubilia Curae; Proin vulputate placerat pellentesque. Proin viverra lacinialectus, quis cons', 'Eu lorem commodo ullamcorper.Interdum et malesuada fames ac ante ipsum primis in faucibus. Ut id nul', null, 'Posuere cubilia Curae; Proin vulputate placerat pellentesque. Proin viverra lacinialectus, quis cons', 'Amet' ); commit; alter table ch14_plants modify id generated by default on null as identity restart start with 21; -- Generated by Quick SQL Tuesday May 09, 2023 07:36:49 /* ch14_type_of_plant /insert 10 name_of_type_of_plant vc30 ch14_is_subtype_of num /fk ch14_type_of_plant ch14_plants /insert 20 ch14_plant_type_id num /fk ch14_type_of_plant names_local vc100 names_english vc100 name_latin vc40 description vc200 habitat vc50 cultivation vc100 use vc100 photo blob hyperlinks vc100 status vc20 # settings = { semantics: "CHAR", language: "EN", APEX: true } */