100 lines
5.0 KiB
SQL
100 lines
5.0 KiB
SQL
-- +goose Up
|
|
|
|
INSERT IGNORE INTO b2b_language
|
|
(id, created_at, updated_at, deleted_at, name, iso_code, lang_code, date_format, date_format_short, rtl, is_default, active, flag)
|
|
VALUES
|
|
(1, '2022-09-16 17:10:02.837', '2026-03-02 21:24:36.779730', NULL, 'Polski', 'pl', 'pl', '__-__-____', '__-__', 0, 0, 1, '🇵🇱'),
|
|
(2, '2022-09-16 17:10:02.852', '2026-03-02 21:24:36.779730', NULL, 'English', 'en', 'en', '__-__-____', '__-__', 0, 1, 1, '🇬🇧'),
|
|
(3, '2022-09-16 17:10:02.852', '2026-03-02 21:24:36.779730', NULL, 'Deutsch', 'de', 'de', '__-__-____', '__-__', 0, 0, 1, '🇩🇪');
|
|
|
|
INSERT INTO `b2b_roles` (`name`, `id`) VALUES ('user','1');
|
|
INSERT INTO `b2b_roles` (`name`, `id`) VALUES ('admin','2');
|
|
INSERT INTO `b2b_roles` (`name`, `id`) VALUES ('super_admin','3');
|
|
INSERT INTO `b2b_roles` (`name`, `id`) VALUES ('unlogged','4');
|
|
|
|
|
|
-- insert sample admin user admin@ma-al.com/Maal12345678
|
|
INSERT IGNORE INTO b2b_customers (id, email, password, first_name, last_name, role_id, provider, provider_id, avatar_url, is_active, email_verified, email_verification_token, email_verification_expires, password_reset_token, password_reset_expires, last_password_reset_request, last_login_at, lang_id, country_id, created_at, updated_at, deleted_at)
|
|
VALUES
|
|
(1, 'admin@ma-al.com', '$2a$10$Owy9DjrS0l3Fz4XoOvh5pulgmOMqdwXmb7hYE9BovnSuWS2plGr82', 'Super', 'Admin', 2, 'local', '', '', 1, 1, NULL, NULL, '', NULL, NULL, NULL, 1, 1, '2026-03-02 16:55:10.252740', '2026-03-02 16:55:10.252740', NULL);
|
|
ALTER TABLE b2b_customers AUTO_INCREMENT = 1;
|
|
|
|
INSERT INTO `b2b_currencies` (`ps_id_currency`, `is_default`, `is_active`) VALUES
|
|
('1','1','1'),
|
|
('2','0','1');
|
|
|
|
INSERT IGNORE INTO b2b_countries
|
|
(id, flag, ps_id_country, b2b_id_currency)
|
|
VALUES
|
|
(1, '🇵🇱', 14, 1),
|
|
(2, '🇬🇧', 17, 2),
|
|
(3, '🇨🇿', 16, 2),
|
|
(4, '🇩🇪', 1, 2);
|
|
|
|
INSERT INTO `b2b_permissions` (`id`, `name`) VALUES ('1', 'user.read.any');
|
|
INSERT INTO `b2b_permissions` (`id`, `name`) VALUES ('2', 'user.write.any');
|
|
INSERT INTO `b2b_permissions` (`id`, `name`) VALUES ('3', 'user.delete.any');
|
|
INSERT INTO `b2b_permissions` (`id`, `name`) VALUES ('4', 'currency.write');
|
|
INSERT INTO `b2b_permissions` (`id`, `name`) VALUES ('5', 'specific_price.manage');
|
|
INSERT INTO `b2b_permissions` (`id`, `name`) VALUES ('6', 'webdav.create_token');
|
|
INSERT INTO `b2b_permissions` (`id`, `name`) VALUES ('7', 'product_translation.save');
|
|
INSERT INTO `b2b_permissions` (`id`, `name`) VALUES ('8', 'product_translation.translate');
|
|
INSERT INTO `b2b_permissions` (`id`, `name`) VALUES ('9', 'search.create_index');
|
|
INSERT INTO `b2b_permissions` (`id`, `name`) VALUES ('10', 'orders.view_all');
|
|
INSERT INTO `b2b_permissions` (`id`, `name`) VALUES ('11', 'orders.modify_all');
|
|
INSERT INTO `b2b_permissions` (`id`, `name`) VALUES ('12', 'teleport');
|
|
|
|
INSERT INTO `b2b_role_permissions` (`role_id`, `permission_id`) VALUES ('2', '1');
|
|
INSERT INTO `b2b_role_permissions` (`role_id`, `permission_id`) VALUES ('2', '2');
|
|
INSERT INTO `b2b_role_permissions` (`role_id`, `permission_id`) VALUES ('2', '3');
|
|
INSERT INTO `b2b_role_permissions` (`role_id`, `permission_id`) VALUES ('2', '4');
|
|
INSERT INTO `b2b_role_permissions` (`role_id`, `permission_id`) VALUES ('2', '5');
|
|
INSERT INTO `b2b_role_permissions` (`role_id`, `permission_id`) VALUES ('2', '6');
|
|
INSERT INTO `b2b_role_permissions` (`role_id`, `permission_id`) VALUES ('2', '7');
|
|
INSERT INTO `b2b_role_permissions` (`role_id`, `permission_id`) VALUES ('2', '8');
|
|
INSERT INTO `b2b_role_permissions` (`role_id`, `permission_id`) VALUES ('2', '9');
|
|
INSERT INTO `b2b_role_permissions` (`role_id`, `permission_id`) VALUES ('2', '10');
|
|
INSERT INTO `b2b_role_permissions` (`role_id`, `permission_id`) VALUES ('2', '11');
|
|
INSERT INTO `b2b_role_permissions` (`role_id`, `permission_id`) VALUES ('2', '12');
|
|
INSERT INTO `b2b_role_permissions` (`role_id`, `permission_id`) VALUES ('3', '1');
|
|
INSERT INTO `b2b_role_permissions` (`role_id`, `permission_id`) VALUES ('3', '2');
|
|
INSERT INTO `b2b_role_permissions` (`role_id`, `permission_id`) VALUES ('3', '3');
|
|
INSERT INTO `b2b_role_permissions` (`role_id`, `permission_id`) VALUES ('3', '4');
|
|
INSERT INTO `b2b_role_permissions` (`role_id`, `permission_id`) VALUES ('3', '5');
|
|
INSERT INTO `b2b_role_permissions` (`role_id`, `permission_id`) VALUES ('3', '6');
|
|
INSERT INTO `b2b_role_permissions` (`role_id`, `permission_id`) VALUES ('3', '7');
|
|
INSERT INTO `b2b_role_permissions` (`role_id`, `permission_id`) VALUES ('3', '8');
|
|
INSERT INTO `b2b_role_permissions` (`role_id`, `permission_id`) VALUES ('3', '9');
|
|
INSERT INTO `b2b_role_permissions` (`role_id`, `permission_id`) VALUES ('3', '10');
|
|
INSERT INTO `b2b_role_permissions` (`role_id`, `permission_id`) VALUES ('3', '11');
|
|
INSERT INTO `b2b_role_permissions` (`role_id`, `permission_id`) VALUES ('3', '12');
|
|
|
|
INSERT INTO `b2b_route_roles` (`route_id`, `role_id`) VALUES
|
|
(1, '1'),
|
|
(1, '2'),
|
|
(1, '3'),
|
|
(2, '1'),
|
|
(2, '2'),
|
|
(2, '3'),
|
|
(2, '4'),
|
|
(3, '1'),
|
|
(3, '2'),
|
|
(3, '3'),
|
|
(3, '4'),
|
|
(4, '1'),
|
|
(4, '2'),
|
|
(4, '3'),
|
|
(4, '4'),
|
|
(5, '1'),
|
|
(5, '2'),
|
|
(5, '3'),
|
|
(5, '4'),
|
|
(6, '1'),
|
|
(6, '2'),
|
|
(6, '3'),
|
|
(6, '4'),
|
|
(7, '1'),
|
|
(7, '2'),
|
|
(7, '3'),
|
|
(7, '4');
|
|
-- +goose Down |