From f6b48d6facfd5c2e46b0341bd4c7683269d8a1f6 Mon Sep 17 00:00:00 2001 From: Steve Sutton Date: Wed, 7 Oct 2015 15:03:52 -0400 Subject: [PATCH] update sql for users --- test/test.sql | 7 ++++++- 1 file changed, 6 insertions(+), 1 deletion(-) diff --git a/test/test.sql b/test/test.sql index 539969e..3a5153d 100644 --- a/test/test.sql +++ b/test/test.sql @@ -18,7 +18,8 @@ INSERT INTO `glm_users` (`user_login`, `user_pass`, `user_nicename`, `user_email ('candace', '$P$BAlC7cLEMtoBHes6Dd9RNEib5SOuWe.', 'candace', 'billing@gaslightmedia.com', '', NOW(), '', 0, 'jodie'), ('anthony', '$P$BubULLBz9zOc1k7sQ6gQHkjCI40pOU1', 'anthony', 'anthony@gaslightmedia.com', '', NOW(), '', 0, 'anthony'), ('ianw', '$P$BkBgZf2R8hSjXD0SfKxdYfgChefI5X.', 'ianw', 'ian@gaslightmedia.com', '', NOW(), '', 0, 'ianw'), -('collins', '$P$BtB2gYe2c1PUAgCOwSWsUimqVSyuFs.', 'collins', 'collins@gaslightmedia.com', '', NOW(), '', 0, 'collins'); +('collins', '$P$BtB2gYe2c1PUAgCOwSWsUimqVSyuFs.', 'collins', 'collins@gaslightmedia.com', '', NOW(), '', 0, 'collins') +('anthonyt', '$P$B/zbmiq88UcZV12WWYeAkR0D34i5cW/', 'anthonyt', 'talarico@gaslightmedia.com', '', NOW(), '', 0, 'anthonyt'.); UPDATE `glm_options` SET `option_name` = 'glm_user_roles' WHERE `option_name` = 'wp_user_roles'; UPDATE `glm_usermeta` SET `meta_key` = 'glm_capabilities' WHERE `meta_key` = 'wp_capabilities'; @@ -60,6 +61,10 @@ INSERT INTO `glm_usermeta` (`umeta_id`,`user_id`,`meta_key`,`meta_value`) VALUES (NULL, (SELECT `ID` FROM `glm_users` WHERE `user_login` = 'collins'), 'glm_capabilities', 'a:1:{s:6:"editor";b:1;}'), (NULL, (SELECT `ID` FROM `glm_users` WHERE `user_login` = 'collins'), 'glm_user_level', '7'); +INSERT INTO `glm_usermeta` (`umeta_id`,`user_id`,`meta_key`,`meta_value`) VALUES +(NULL, (SELECT `ID` FROM `glm_users` WHERE `user_login` = 'anthonyt'), 'glm_capabilities', 'a:1:{s:13:"administrator";b:1;}'), +(NULL, (SELECT `ID` FROM `glm_users` WHERE `user_login` = 'anthonyt'), 'glm_user_level', '10'); + UPDATE `glm_options` SET `option_value` ='America/Detroit' WHERE `option_name` = 'timezone_string'; UPDATE `glm_options` SET `option_value` ='0' WHERE `option_name` = 'start_of_week'; -- 2.17.1