Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Save wienczny/89cd21dbaa43e2507792 to your computer and use it in GitHub Desktop.
Save wienczny/89cd21dbaa43e2507792 to your computer and use it in GitHub Desktop.
INSERT INTO api_user (firstname, lastname, email, username, api_key, created, modified, lognum, reload_acl_flag, is_active) VALUES('Service', 'User', '[email protected]', 'service', 'dec335babdf3963c310cdee3a03af112:7BgJbicGhvmLwETmUCCaqAV7185NHNPZ', STR_TO_DATE('2015-03-06 23:25:57','%Y-%m-%d %H:%i:%s'), STR_TO_DATE('2014-12-11 23:05:20','%Y-%m-%d %H:%i:%s'), 843, 0, 1); -- password is serviceservice
INSERT INTO api_role (parent_id, tree_level, sort_order, role_type, user_id, role_name) SELECT 1 as parent_id, 1 as tree_level, 0 as sort_order, 'U' as role_type, user_id, 'Service' as role_name from api_user WHERE username = 'service';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment