user
41 lines
2.7 KiB
SQL
41 lines
2.7 KiB
SQL
-- Insert users with different roles
|
|
|
|
-- Cashiers (role_id = 1), password: cashier (cashier1 & cashier2), cashier_alt (cashier3)
|
|
INSERT INTO users (username, password_hash, salt, role_id) VALUES
|
|
('cashier1', '43f4fded07f17b903867b8293ad429b0c826e5d2c8ac5a66ed58cf3cc511ee60', 'random_salt_1', 1);
|
|
INSERT INTO users (username, password_hash, salt, role_id) VALUES
|
|
('cashier2', '2a2aebce4cc19cfd384377617e3008d42caeb0172970b64e8d39778995950cfc', 'random_salt_2', 1);
|
|
INSERT INTO users (username, password_hash, salt, role_id) VALUES
|
|
('cashier3', 'a474eac28b808053cf8fddd7d53412d710c1adeb218c0bd7b91add5760b16885', 'random_salt_3', 1);
|
|
|
|
-- Sales Managers (role_id = 2), password: sales_manager1, sales_manager2
|
|
INSERT INTO users (username, password_hash, salt, role_id) VALUES
|
|
('sales_manager1', '3ac5657c3cc5b44e291aed9f3dcf4881af3c6c53b49b31ef5ab0e35ef04d32dc', 'random_salt_4', 2);
|
|
INSERT INTO users (username, password_hash, salt, role_id) VALUES
|
|
('sales_manager2', '40ad3df805e5173265f65206b1a9fa1c04b7f2ebbd30d5c4bc8ae496c01e89c3', 'random_salt_5', 2);
|
|
|
|
-- Data Editors (role_id = 3), password: data_editor1, data_editor2
|
|
INSERT INTO users (username, password_hash, salt, role_id) VALUES
|
|
('data_editor1', '53a6ad3f69d1ba0f16fab96a295340a70aa6dd4524a06a9e281b458ec1bffdeb', 'random_salt_6', 3);
|
|
INSERT INTO users (username, password_hash, salt, role_id) VALUES
|
|
('data_editor2', '074423b2b32d87ea875905962f10cabe0623b75532323f7a6d1f29ff51a556e0', 'random_salt_7', 3);
|
|
|
|
-- Repertoire Managers (role_id = 4), password: repertoire_manager1, repertoire_manager2
|
|
INSERT INTO users (username, password_hash, salt, role_id) VALUES
|
|
('repertoire_manager1', 'd57d697fe8df03559cbd7cb6c15d29fc6584556ba92291400db64a788a788bd5', 'random_salt_8', 4);
|
|
INSERT INTO users (username, password_hash, salt, role_id) VALUES
|
|
('repertoire_manager2', '74a0a0bceb65454779c8acb2705df36a905355e10b96fa0360a023aaddbac2cf', 'random_salt_9', 4);
|
|
|
|
-- Data Administrators (role_id = 5), password: data_admin1, data_admin2
|
|
INSERT INTO users (username, password_hash, salt, role_id) VALUES
|
|
('data_admin1', '1b755d9430baa5f6db977e3ed87fc9d2d0b6e89e35c0f04529ec7484ca57ab54', 'random_salt_10', 5);
|
|
INSERT INTO users (username, password_hash, salt, role_id) VALUES
|
|
('data_admin2', '465a2368e915fc5bbc8f1ff56fec3bb5fda92088cb64285b4419507012677bf3', 'random_salt_11', 5);
|
|
|
|
-- Super Administrators (role_id = 6), password: super_admin1, super_admin2
|
|
INSERT INTO users (username, password_hash, salt, role_id) VALUES
|
|
('super_admin1', 'b687b754afbbb073178a2b50f10dad03d0ff54019b771b1853c5ee3bfc6d93d2', 'random_salt_12', 6);
|
|
INSERT INTO users (username, password_hash, salt, role_id) VALUES
|
|
('super_admin2', 'cad48cc6068cfc8f164e16422f1c92e4cd52fa446d1ac2fa2a678406fa60c6b6', 'random_salt_13', 6);
|
|
|