13 lines
861 B
SQL
13 lines
861 B
SQL
INSERT INTO users(userid, email, password)
|
|
VALUES
|
|
('123456', 'someguy@someplace.com', 'pbkdf2:sha256:260000$F4lu8Z6tY1f5Zzjg$2c2a94b0077f88a7a771af302ed48594c6fddeaeaeb689f7afb1f5d4cb3f439f'),
|
|
('123457', 'otherguy@otherplace.com', 'pbkdf2:sha256:260000$8AqOuHzo0h7r7CAH$7800e7378720902d6ab996adb337e7ae2c68e64f49e73e3c88cefb1ea7615bd3');
|
|
|
|
INSERT INTO dsw(csa, date, wa, driver, totalod, nextod, delstops, delpkgs, pustops, pupkgs, van, miles, ils, dna, allstatus)
|
|
VALUES
|
|
('123456', '2021-09-10', 'ABC01', 'John Doe', '12:00', '05:00', '123', '234', '10', '100', '123456', '50', '99%', '', '2');
|
|
|
|
INSERT INTO totals(entity, date, prepkgs, prestops, prepustops, delstops, delpkgs, pustops, pupkgs, ils, dna, allstatus, sig, eve, appt)
|
|
VALUES
|
|
('contract', '2021-09-10', '500', '100', '1', '125', '499', '2', '100', '99%', '1', '5', '1', '1', '1');
|