This file contains SQL statements that will add the username and MD5 hash values of the passwords and salt into a table. It assumes that the name of your table is 'passwords' and the names of the columns are 'username' 'password_hash' and 'salt'. If you want use other names use global find and replace in your favorite editor to change the SQL statements below. You can execute the SQL statements in DBVisualizer. Once you have set up DBVisualizer to connect to your database you can copy and paste the statements into the SQL Commander editor. When you execute the statements DBVisualizer will complain that you can not execute them as separate statements. It will allow you to execute them as one statement. It does execute them all but only shows the result of the last statement. If you have postgreSql installed on you computer you can use the psql command line client to run the statements. Place the statements in a file, I assume the file is called passwords.sql. Then run the psql client using: psql -h bismarck.sdsu.edu -U yourDBUsername Once you have logged on you execute the statements in the file using the command: \i passwords.sql INSERT INTO passwords (username, password_hash, salt) VALUES ('1000', '486A77E13D495F98B9B4B7C34F5907A0', '665C1F5AAB1951F0553C8FC5A6B78C3194ACC02C22E29488C24F14D0BEAAAB4C8EE4E2AC98971C53335FDB3FA43'); INSERT INTO passwords (username, password_hash, salt) VALUES ('1004', 'FF6F5FE07470C12168C639EAE65253AB', '138640FD785433711C48DD321A86165D2A4F4772088DBA9432EC242CA188A07BCD200ABE15544138335FDB3FA44'); INSERT INTO passwords (username, password_hash, salt) VALUES ('1006', '71CBA9B79569DA7EC4C560FEE83E44B5', '4DD4F253D7BFAD221E2E1FA0DA4D294643AEBE4C277668320905AAA9685D9CAEA7DB8B4095B81160335FDB3FA44'); INSERT INTO passwords (username, password_hash, salt) VALUES ('1008', '54987794D778F5F77E0995529D04ACC9', '6F25ACE4CA7B3C87E47D2F05D47D21D125F4D5C89363F7F438A767C34BC8A4C68FBA89573AF36C9F335FDB3FA44'); INSERT INTO passwords (username, password_hash, salt) VALUES ('1010', 'B1633AF421FC8025262DD8E846ADAF64', '2CD0562C24F7C726A7974A923AA4BD7D2270BE252279713E806A2F9EB087DE03B4948D748ED10F7A335FDB3FA44'); INSERT INTO passwords (username, password_hash, salt) VALUES ('1012', 'A654C1A79BE25D61B172B17130A60782', '4166A1015F7C42DDD97058E2FFAE0507408747679EA35A95E2780D2C6832690540EC51B7BC628D73335FDB3FA44'); INSERT INTO passwords (username, password_hash, salt) VALUES ('1014', '2BC70790FDECE0078E30B198F0D34572', 'E3A9417ED8369396265750496D8002FB0F32C4976E405970F0DBA9A67453C02F5896FECD809E8521335FDB3FA45'); INSERT INTO passwords (username, password_hash, salt) VALUES ('1016', '15B9CCDD3A3D0CA1C2C70321C0133D6D', 'DF7CE0AFD5444249450D051A8492218C054215F67B7B0D54D1866A5D869C7DFDAACC29C3AF827226335FDB3FA45'); INSERT INTO passwords (username, password_hash, salt) VALUES ('1018', 'ACC60A3EF4C41EB605722C20C3FFE7C7', 'C8C927BD23D5A23E240A333906E67B9CE8DDB3D19EA5CC76EF2BEEDF62F389290F1823BE09A81F335FDB3FA45'); INSERT INTO passwords (username, password_hash, salt) VALUES ('1020', '06E7B64A03BCFC151B23483E6851E87F', 'DB09399CDE0A622C4857F538D9FCC040003C83D0275AFDD105981EED2A47C81C526B446E63AC3830335FDB3FA45'); INSERT INTO passwords (username, password_hash, salt) VALUES ('1022', 'CC7FBEE39AC05B603DE98314E6FCF64E', 'DB5F53A7FC90681AF31C67D1DACFD4352E6D716F423A7C2F79F0799C56DA14585FF557C68E2B4AF8335FDB3FA45'); INSERT INTO passwords (username, password_hash, salt) VALUES ('1024', '60B8E4055A18D2E463A9339628724785', '99B2B473775194BFA8E9A50E1B8F6BB807A677523E6BBF8BC07E74F067A588439A3C74F715DE4C5335FDB3FA46'); INSERT INTO passwords (username, password_hash, salt) VALUES ('1026', 'BF1CF4DBD0E3B2D64391FD1D7E413BBE', 'F04A00590B538ED0A3B613631E3FDFA4F6F67EB325F96537B1E303785BB7CDC006E8173742B4745A335FDB3FA46'); INSERT INTO passwords (username, password_hash, salt) VALUES ('1028', '86CAC45554A6D2F0157B25BF7230BF41', '6E88879D6DF89156EFAE74FF3235B347A7CE405A9046154E25FC92F1D8E5D3E6BF99E411A1D8E37E335FDB3FA46'); INSERT INTO passwords (username, password_hash, salt) VALUES ('1030', '69661109278774A345753DB99E2BAE6C', '3B94727D48A8215E5572054948FA143963575195D87A332DB3DA2D8DFB44E5EE5CA4C4B650A64D57335FDB3FA46'); INSERT INTO passwords (username, password_hash, salt) VALUES ('1032', 'F0DDAD19896E12313C79D9FCFA3027E7', 'C8730FBEDB46A428355FE0E11EF6CF71E68DFC4BC12FE52916E30915906964E256D96FCB77104807335FDB3FA47'); INSERT INTO passwords (username, password_hash, salt) VALUES ('1034', '36CDDA8598D0DDE5589018F686EFCBBB', '6D7611F72A10D6D6FB5A1DB6F5C918A7AE9967719B37E818CFF20533FC81C24016254CFE6EE948F2335FDB3FA47'); INSERT INTO passwords (username, password_hash, salt) VALUES ('1036', '7BE5EDA921385E49360F70E74610A327', '5224592BBAC35D24F3AD3703EDB1C461F289E9F15B88BF4063B7B001E74BFE9317BDD24BFCB83125335FDB3FA47'); INSERT INTO passwords (username, password_hash, salt) VALUES ('1038', 'DD2122EF36DE2C37117E80C247EB8AD4', '370B9FB387688B8A9BE616757F700800598F5BB37C51EFFA0475AC142520B4AB5AAF82D1749AC952335FDB3FA47'); INSERT INTO passwords (username, password_hash, salt) VALUES ('1040', '122D00F9C721665D498C71D10928BD47', '734723F5741B789EA35CB04BA74AC6FCC2C1C76F34F9255966E22D5E312CAC8FDDA8550A07F8D4CA335FDB3FA47'); INSERT INTO passwords (username, password_hash, salt) VALUES ('1042', '160D87F8B462A47CC2C8A1E6F6F052A3', 'E6A1665C41D0A5AE632C80E0AA39BF069F277B6482231E42F9FC8DF6A8B477ECC8991620444198C3335FDB3FA48'); INSERT INTO passwords (username, password_hash, salt) VALUES ('1044', 'CD1AAFA2E9F6DA2C088060223022EE28', 'BA600FEDA62C8CF5B25B40B3134AABB42C2E4E70CE96C0EC85A11D558296D507D3514B6561A742D9335FDB3FA48'); INSERT INTO passwords (username, password_hash, salt) VALUES ('1046', '3E73DE99CB22B79F97221F0834FA5FEA', '9EC2F7F37F6FC2C948079316C7E068B8F706A8E5DFA6BE9E13DA9EE12BE171DD35D04A27F8795015335FDB3FA48'); INSERT INTO passwords (username, password_hash, salt) VALUES ('1048', 'E13110A0A72AB455093758D60DA7013D', '58F20DF7E892791B6CFA8D41DA9309D6E3837F436A9F24DF0EE66FDF1438A807A7458B265F723AB8335FDB3FA48'); INSERT INTO passwords (username, password_hash, salt) VALUES ('1050', '7BA9BC3516FB738FF55CD098A8E881BE', 'CCEC4E225F71B72B2265BBA9CBF1046574B5251A84A499DD73E155BDA3C0B69D2E595A83F802936335FDB3FA49'); INSERT INTO passwords (username, password_hash, salt) VALUES ('1052', 'E7EC92EE49A6ACED9ABC71BD3239B02F', '6704031A3EA278DAFBD12EEA5F5EC4AB70B0974A9BA895227DE69B04349DE5C724C2FB1E9DFC0C8A335FDB3FA49'); INSERT INTO passwords (username, password_hash, salt) VALUES ('1054', 'E962E7411D9DBA7F8226C011809ABEF5', 'B6CFD071F89017E76B394C9ADF8C4B060DCC48D60365401D7FCF59A85B048B2F1FD123ABEB38DF93335FDB3FA49'); INSERT INTO passwords (username, password_hash, salt) VALUES ('1056', '735E400791D17803B1D2FA56A14B98D9', '9C52D0F1D236ED2D1907549475C2D1AD9E910864B6A245DFF63A0D67F89CB62C538ECCEAFFB16634335FDB3FA49'); INSERT INTO passwords (username, password_hash, salt) VALUES ('1058', '08AD44DF500A651D1FD3BE513ED99B1A', '6C1B4B5A414C04EF57F8F671C5B64A2371AB2BDAF55FCDE52779A0E9D78872010DDC143E26DD1A9335FDB3FA49'); INSERT INTO passwords (username, password_hash, salt) VALUES ('1060', '55166112C769E873C17E79175991AAC8', '1022C40BC1360E0B3A5EE7A80FADADE5D867A27129176FB271139B0854BE90D141EA221530A46942335FDB3FA4A'); INSERT INTO passwords (username, password_hash, salt) VALUES ('1062', '8C5396B51C8BE0AEEB7EE21D135E6E40', 'DB594853284D468AEBAF9ED0F180B20C77E412FBE4B699C0E3EF72471106A18C66A3042CDF8A4310335FDB3FA4A'); INSERT INTO passwords (username, password_hash, salt) VALUES ('1064', 'FD3B306AD3AC20D3A10451F4947D7FA7', 'BA953063DF4E890AE6AB19B3B481432B65156A8DBEF58B965E39A153AE25D5C6C78B8A926E8A6F55335FDB3FA4A'); INSERT INTO passwords (username, password_hash, salt) VALUES ('1066', 'E5B751CD47B17858C2598C5711FA55C3', '6B360FD1C8D9B42994E882DBC847110A6D42545082D4FE5BF2FABF6F009D7C001C8F52521EBA6DA8335FDB3FA4A'); INSERT INTO passwords (username, password_hash, salt) VALUES ('1068', '975B9FEEEA49BF020F3A30CC9378B94E', '864A0F177FF465173DD4A1F418920CC9DBCB3205225F35EFB0539705CD0926B85204CC47CB1766DC335FDB3FA4A'); INSERT INTO passwords (username, password_hash, salt) VALUES ('1070', 'F7D7A8D36B0EA35360ACF4C3000B0B54', '341B677EF4606D5B4A79394D54C0BC6C9E0EA3A3D8B4BBEF08B0D101A98B4EF3D7A7082A9103BB6A335FDB3FA4B'); INSERT INTO passwords (username, password_hash, salt) VALUES ('1072', '5546774FA3D8BB77393EA9D68479223E', 'AA5D23DC421182AA8DB61E94111488BE502FEE850DFFF3385CFA4DC3BFA77129D9DEF62742D7FB9F335FDB3FA4B'); INSERT INTO passwords (username, password_hash, salt) VALUES ('1074', '8BF1AFDF6AC728B1E56EDCB49E07A2AA', '33E0D3CB17799FF5832A402126CE3D1CC21156390491139768A18284EDA780BC9EDE93C3DBF3C8B2335FDB3FA4B'); INSERT INTO passwords (username, password_hash, salt) VALUES ('1076', '31C386D4B3D4AA75EACB01F17FC8BCC0', '772F6176D3F27F969DDE49506A90237FD9A8832F4CD8A545FA1DFBD5069D63B80CDC501247F3675D335FDB3FA4B'); INSERT INTO passwords (username, password_hash, salt) VALUES ('1078', 'B52B11B280A701A1A5B7480A65772BE5', '7895DB54321B0D432CE46F70D1A271B5C272EFF2990366EB8DE411F5628F68A842F54731B24011D0335FDB3FA4B'); INSERT INTO passwords (username, password_hash, salt) VALUES ('1080', '8A036D78527109AA24C4F0C5303E2ED5', '85C082361E930E95AC232E92787A867FD31F739832A5B3536E6FDF1EBDC754F5710D4DB1A0C8A8335FDB3FA4C'); INSERT INTO passwords (username, password_hash, salt) VALUES ('1082', 'A7FD9A4A581487179B37E174BCF41A15', 'B2BCC4064F45EB7396B71E51B6F10C070F16BED644FAC4BC105038381118CAC57188AA20FCA7A824335FDB3FA4C'); INSERT INTO passwords (username, password_hash, salt) VALUES ('1084', '976984CAAC72A6223BF109A75EF78670', 'AE44317F834A749C9721B821EFA89BDCBF9BC3DBD1C0D97D38147E22E19B8B619A84956F94779305335FDB3FA4C'); INSERT INTO passwords (username, password_hash, salt) VALUES ('1086', '76D22DA33A501C28AFF2FEBAA9AA18A2', 'C50AC4601DCD1EBE984F73FB9089089D989765E845BC4C2496E1763375A1F4D0AE656AC8A962F246335FDB3FA4C'); INSERT INTO passwords (username, password_hash, salt) VALUES ('1088', '31F93CDF537EF95502553C804A756FAD', '9A46A1A1F6FAB6BBF6E47B42924DE3EC899CFDB79642B9CF929534388561D1F4A6D092E574B2AFA0335FDB3FA4C'); INSERT INTO passwords (username, password_hash, salt) VALUES ('1090', 'A177BEB6DF959BA8D74368102CDED498', '6C60DE39E4814A5AF14CCB7A9DACC00D8BCE71BD8EDA928A9524643FD88242E7F63A56FEAB71657B335FDB3FA4D'); INSERT INTO passwords (username, password_hash, salt) VALUES ('1092', '04F0269A4930D3AC6365704463B0F564', '76FE55BCBC4C4A0B4DC5615662299484428605E130E28AD0E5037D0EB832D56B9E4F1B8D7DA7A98335FDB3FA4D'); INSERT INTO passwords (username, password_hash, salt) VALUES ('1094', 'ABCE4167682827700F7166369B3903A9', 'DF69AB404ECA149F134558BD12BBFCF8458EF02E48B18CC23009A2739AD9F0BDB67DFBFDA9C1F9CB335FDB3FA4D'); INSERT INTO passwords (username, password_hash, salt) VALUES ('1096', '6BC7F3AC301A6547C3A8CAACFC0DA3FD', '14BA4834BA297FFD2E197A9F8BD5D90D0BC27BF4F3AF33BDFB6C020BC7287ECFE3FE0EBC54246F57335FDB3FA4D'); INSERT INTO passwords (username, password_hash, salt) VALUES ('1098', 'ABD3F1FC6268A0345973ACDE9D6F9958', '583CA382CF3F34B7D847402D42E20402BFFDF9C499BF2DBF6A7695AD6AB4173E276A20B31A103590335FDB3FA4D'); INSERT INTO passwords (username, password_hash, salt) VALUES ('1100', '443435CA8E7B8ECE84C44DFC9CC5B982', '2FE98B0383C9B373A44C75CE1568FE8195F9F0A59CCF533DFF56516F132797E42AEECF19DAF1F857335FDB3FA4E'); INSERT INTO passwords (username, password_hash, salt) VALUES ('1102', '085CAB6CCD04F6FD516ABA9A62CC5BA4', 'D048F56A2649C4D75C176C580A1F294B51508CD97D2C0BEBE934E0A236048CB2234857A6B655ECDC335FDB3FA4E'); INSERT INTO passwords (username, password_hash, salt) VALUES ('1104', '7964C36C1D4191AC377AB57419998BC8', '2FC0BC6A0BAC9A41AD83126EF4E127C9D13DD2D313319EC41F024CA6E4958C63DC32FF7CB0CD11EB335FDB3FA4E'); INSERT INTO passwords (username, password_hash, salt) VALUES ('1106', '55A30F19F305868073CF0DA1F3CCEF0A', '9590AF62275DE97219105BBF8DF72E82C3CD8B8A10B0F768400ABB50943D45D702EB165523C53586335FDB3FA4E'); INSERT INTO passwords (username, password_hash, salt) VALUES ('1108', 'A5410B743E885ECE15A0D360C9F23442', '6054B4AF0EEB05FD2ED1D5621103838772D3DB6DF25172AE61149EA09B5478572153C1041CCD080E335FDB3FA4E'); INSERT INTO passwords (username, password_hash, salt) VALUES ('1110', '4CA00634C0D6686436FAE97F5ECDCACE', '5C4FF87C2000A1780462BC957B86CDF38600F8723A3DFBE5EC49692B5277B64E42B55F66B79B29AB335FDB3FA4F'); INSERT INTO passwords (username, password_hash, salt) VALUES ('1112', 'F1605A88A8CAB550C370434E50256545', '6C24879CF69E7EC6F6DB88C5583A05E0215EF5F4F388D2D8C1AE46D59975A964CB5F70CE4A129339335FDB3FA4F'); INSERT INTO passwords (username, password_hash, salt) VALUES ('1114', 'B172C150A8B748E0CFC72DE96F65F654', 'CB41C701442EEA0D9009E7EEA4A1FB22A704DB3490513B5CC8C66F7649F8B7F3357FFDC38AE62815335FDB3FA4F'); INSERT INTO passwords (username, password_hash, salt) VALUES ('1116', '294A9E9C2A0B9C864D48536DEA0786BB', '79CE17005E74988A9F2F58EE9E5EA68E7862F7E7F37DFB9287C2A0E9D5B83DC2350D33524D3A89B8335FDB3FA4F'); INSERT INTO passwords (username, password_hash, salt) VALUES ('1118', 'A951891421B157AD7DDE3A031070BB87', '550E7E16F61D9698E097712513B237A19FDA0CBB69D04C05F171EB1184CC86DA0842230069459CBC335FDB3FA50'); INSERT INTO passwords (username, password_hash, salt) VALUES ('1120', 'C4F7A1F2BCB642796EF66184D2DB3A26', 'F1616C5465A9E4EE830196F88D7229B641FFD70409AFB8BAD176E09E7D0B4C9D0CFD52E9DB05351F335FDB3FA50'); INSERT INTO passwords (username, password_hash, salt) VALUES ('1122', 'DBA84F0136E3618932259F8D0F1196FD', 'A87582344BB2E84C8F7873A0DBC39A3A5E6C3E09C72D6074CCB885DB09F06D294DFA37A8B16ED8E4335FDB3FA50'); INSERT INTO passwords (username, password_hash, salt) VALUES ('1124', 'B20A984076464B402AAED0C5B03A0884', 'B31DEEDC7A69B1C46F8159B83D11AB97B50D0CF55D35695C06485F1329A6CD7260C2B4037359BCD0335FDB3FA50'); INSERT INTO passwords (username, password_hash, salt) VALUES ('1126', '704BBC22BE72FAB1A0D7C5E30B2985F2', '14FA141D1507608DCA001FE3C1D4791CC081037B1E956D258BD83F0DF99197876EA8D842A8B4569F335FDB3FA50'); INSERT INTO passwords (username, password_hash, salt) VALUES ('1128', 'F32C3665EFBD348B7CC25273A014C7BB', 'BC5CFA21223F032CF798A3E21D731FC6B978627A28F800F579E59FBF71F3B0295D5F86A133ADF160335FDB3FA51'); INSERT INTO passwords (username, password_hash, salt) VALUES ('1130', 'CC1620D79BA75067D2A67A00791B6C26', 'BE9B46349ADA930A59D01498DBB484BBB6777A4C575EFA4E62E514528CA9EED1BA7EA44912DA73E4335FDB3FA51'); INSERT INTO passwords (username, password_hash, salt) VALUES ('1132', '1DFDB5782D6911BEB3EA68940FBA8AC6', '8985C416F426353B16228F9B0F0DF9A5812448D98E1946DC07DD97AE4580538CF3CC064DC23B28CA335FDB3FA51'); INSERT INTO passwords (username, password_hash, salt) VALUES ('1134', 'AA7BC8DD5108E828374E550BE8827ACF', '70AF6B0D9B8E047AE71368E3D08D9460C5FD8A00B9051F07632A8389941A549BCED09B6E3DDC28E1335FDB3FA51'); INSERT INTO passwords (username, password_hash, salt) VALUES ('1136', '660E7347C0553E2CC2AF5F0332DA7889', 'EC91839E18369589EF60B1CC2BF8E0132D0AA59A97C7BE8E14823F16740F0993628A4E9DE319FC6B335FDB3FA52'); INSERT INTO passwords (username, password_hash, salt) VALUES ('1138', '7CEC91E9EF3CE93C9FCE4F542A97DC6B', 'BCEC5E70E9144F48D6370747ADD09E186D4CAC04E85E266423CA6C37C9BD5ACF9064CC25C63B0576335FDB3FA52'); INSERT INTO passwords (username, password_hash, salt) VALUES ('1140', 'A9508F74B2346C4411EC6BDB2A413273', '2483CF2E51B1CDC2FA7197B9BD37C0DC432D5FAAB35D898A8D2A9BAED3AF080D07DCB73EBAEE0F8335FDB3FA52'); INSERT INTO passwords (username, password_hash, salt) VALUES ('1142', '87A402F670E54512A8D1DAE8961E242A', '1BD5378BD3A618D8E26CE219F3E7C6A09FA6C07DC259F089B606B9155A03674929C90DD59EB596CF335FDB3FA52'); INSERT INTO passwords (username, password_hash, salt) VALUES ('1144', 'F9A13FDB62DB032E61DD7E7E32CDA71D', '8F1CD4DD36E420F06EF464A63250A2A8110C0900CF27BEC611A5EA7FFC502D3364BCB06428E12C14335FDB3FA52'); INSERT INTO passwords (username, password_hash, salt) VALUES ('1146', 'C7081C511BEEA451C441C22C5B43E2E6', '49F42D34E53D7D9B30A4B9874939CC82BDD750985815ED219BB62A377131C7B571AA34C0A31E16FE335FDB3FA53'); INSERT INTO passwords (username, password_hash, salt) VALUES ('1148', 'D281117F2A14C4BA3437FF5594C26191', '9B8C439F821D65AA05BD4036C1F50D48BC405DC555C2F42CCC396E2D862E61E29327AB2050B506BB335FDB3FA53');