demo_data.sql 1.75 KB
Newer Older
Johan Cwiklinski's avatar
Johan Cwiklinski committed
1
UPDATE glpi_configs SET value = 'https://demo.glpi-project.org' WHERE name = 'url_base';
Johan Cwiklinski's avatar
Johan Cwiklinski committed
2
UPDATE glpi_configs SET value = 'Pick an account, choose a language and try GLPI!
Johan Cwiklinski's avatar
Johan Cwiklinski committed
3 4 5 6 7

Following accounts are available:

- Administrator (login admin, password admin),
- Standard user (login normal, password normal),
Johan Cwiklinski's avatar
Johan Cwiklinski committed
8 9 10 11 12
- Self-service helpdesk user (login post-only, password postonly)'
   WHERE name = 'text_login';
UPDATE glpi_configs SET value = 1 WHERE name = 'use_public_faq';
UPDATE glpi_configs SET value = 1 WHERE name = 'translate_dropdowns';
UPDATE glpi_configs SET value = 1 WHERE name = 'translate_kb';
Johan Cwiklinski's avatar
Johan Cwiklinski committed
13 14 15 16 17 18 19 20 21 22 23 24
-- all profile rights
UPDATE glpi_profilerights SET rights = 0 WHERE name = 'password_update';
-- admin profile rights
UPDATE glpi_profilerights SET rights = 2049 WHERE profiles_id = 3 AND name = 'user';
UPDATE glpi_profilerights SET rights = 1 WHERE profiles_id = 3 AND name = 'typedoc';
UPDATE glpi_profilerights SET rights = 23 WHERE profiles_id = 3 AND name = 'slm';
UPDATE glpi_profilerights SET rights = 261151 WHERE profiles_id = 3 AND name = 'ticket';
UPDATE glpi_profilerights SET rights = 23 WHERE profiles_id = 3 AND name = 'ticketrecurrent';
UPDATE glpi_profilerights SET rights = 23 WHERE profiles_id = 3 AND name = 'tickettemplate';
UPDATE glpi_profilerights SET rights = 23 WHERE profiles_id = 3 AND name = 'reminder_public';
UPDATE glpi_profilerights SET rights = 23 WHERE profiles_id = 3 AND name = 'rssfeed_public';
UPDATE glpi_profilerights SET rights = 23 WHERE profiles_id = 3 AND name = 'bookmark_public';
Johan Cwiklinski's avatar
Johan Cwiklinski committed
25
INSERT INTO glpi_users (name, password, authtype, language) VALUES ('admin', '$2y$10$ERFSQRmAVBzX9xNDtkV82.AixFN3ds6WKWQOwwUBcG2.7.U4c2hCa', 1, 'en_GB');
Johan Cwiklinski's avatar
Johan Cwiklinski committed
26
INSERT INTO glpi_profiles_users (users_id, profiles_id)
Johan Cwiklinski's avatar
Johan Cwiklinski committed
27
   SELECT id, 3 from glpi_users WHERE name = 'admin';