insert into DataSet (wid, name, loaddate) values(1, 'NCBI Taxonomy', now()); update SpecialWidTable set PreviousWid = 1; insert into Taxon (wid, DataSetWid) values(1029, 1); insert into DBID (OtherWid, XID) values(1029, 3489); insert into Taxon (wid, DataSetWid) values(1025, 1); insert into DBID (OtherWid, XID) values(1025, 12081); insert into Taxon (wid, DataSetWid) values(1023, 1); insert into DBID (OtherWid, XID) values(1023, 9823); insert into Taxon (wid, DataSetWid) values(1012, 1); insert into DBID (OtherWid, XID) values(1012, 32630); insert into Taxon (wid, DataSetWid) values(1005, 1); insert into DBID (OtherWid, XID) values(1005, 844); insert into Taxon (wid, DataSetWid) values(1014, 1); insert into DBID (OtherWid, XID) values(1014, 4102); insert into Taxon (wid, DataSetWid) values(1010, 1); insert into DBID (OtherWid, XID) values(1010, 9606); insert into Taxon (wid, DataSetWid) values(1028, 1); insert into DBID (OtherWid, XID) values(1028, 11706); insert into Taxon (wid, DataSetWid) values(1013, 1); insert into DBID (OtherWid, XID) values(1013, 2303); insert into Taxon (wid, DataSetWid) values(1031, 1); insert into DBID (OtherWid, XID) values(1031, 8355); insert into Taxon (wid, DataSetWid) values(1016, 1); insert into DBID (OtherWid, XID) values(1016, 9913); insert into Taxon (wid, DataSetWid) values(1007, 1); insert into DBID (OtherWid, XID) values(1007, 6239); insert into Taxon (wid, DataSetWid) values(1030, 1); insert into DBID (OtherWid, XID) values(1030, 10678); insert into Taxon (wid, DataSetWid) values(1019, 1); insert into DBID (OtherWid, XID) values(1019, 272951); insert into Taxon (wid, DataSetWid) values(1020, 1); insert into DBID (OtherWid, XID) values(1020, 9031); insert into Taxon (wid, DataSetWid) values(1015, 1); insert into DBID (OtherWid, XID) values(1015, 10070); insert into Taxon (wid, DataSetWid) values(1004, 1); insert into DBID (OtherWid, XID) values(1004, 11676); insert into Taxon (wid, DataSetWid) values(1001, 1); insert into DBID (OtherWid, XID) values(1001, 1422); insert into Taxon (wid, DataSetWid) values(1009, 1); insert into DBID (OtherWid, XID) values(1009, 2238); insert into Taxon (wid, DataSetWid) values(1022, 1); insert into DBID (OtherWid, XID) values(1022, 210); insert into Taxon (wid, DataSetWid) values(1008, 1); insert into DBID (OtherWid, XID) values(1008, 4932); insert into Taxon (wid, DataSetWid) values(1018, 1); insert into DBID (OtherWid, XID) values(1018, 6421); insert into Taxon (wid, DataSetWid) values(1002, 1); insert into DBID (OtherWid, XID) values(1002, 274); insert into Taxon (wid, DataSetWid) values(1000, 1); insert into DBID (OtherWid, XID) values(1000, 562); insert into Taxon (wid, DataSetWid) values(1017, 1); insert into DBID (OtherWid, XID) values(1017, 13249); insert into Taxon (wid, DataSetWid) values(1027, 1); insert into DBID (OtherWid, XID) values(1027, 1895); insert into Taxon (wid, DataSetWid) values(1011, 1); insert into DBID (OtherWid, XID) values(1011, 10090); insert into Taxon (wid, DataSetWid) values(1024, 1); insert into DBID (OtherWid, XID) values(1024, 9796); insert into Taxon (wid, DataSetWid) values(1021, 1); insert into DBID (OtherWid, XID) values(1021, 4896); insert into Taxon (wid, DataSetWid) values(1026, 1); insert into DBID (OtherWid, XID) values(1026, 12126); insert into Taxon (wid, DataSetWid) values(1006, 1); insert into DBID (OtherWid, XID) values(1006, 1063); insert into Taxon (wid, DataSetWid) values(1003, 1); insert into DBID (OtherWid, XID) values(1003, 10658); update WidTable set PreviousWid = 1031; commit;