From 5e52e1c1689cb2d7ead5a12de1cd3ffd9741e1da Mon Sep 17 00:00:00 2001 From: Steve Sutton Date: Mon, 6 Jul 2015 13:07:35 -0400 Subject: [PATCH] Updates to Grunt file and the test.sql file for users --- Gruntfile.coffee | 18 +++++++++--------- test/test.sql | 26 ++++++++++++++++++++------ 2 files changed, 29 insertions(+), 15 deletions(-) diff --git a/Gruntfile.coffee b/Gruntfile.coffee index 856d142..ce4e07d 100644 --- a/Gruntfile.coffee +++ b/Gruntfile.coffee @@ -1,7 +1,7 @@ module.exports = (grunt) -> - dbName = 'c2aps37' - dbUser = 'c2aps39' - dbPassword = 'B2fabc1181ed08e6' + dbName = 'c2aps52' + dbUser = 'c2aps56' + dbPassword = '19fecd6087a04e6a' grunt.initConfig pkg: grunt.file.readJSON "package.json" @@ -9,9 +9,9 @@ module.exports = (grunt) -> options: connection: host: "localhost" - user: "c2aps39" - password: "B2fabc1181ed08e6" - database: "c2aps37" + user: 'c2aps56' + password: '19fecd6087a04e6a' + database: 'c2aps52' multipleStatements: true updatePrefix: src: ['test/test.sql'] @@ -20,10 +20,10 @@ module.exports = (grunt) -> backup4mysql: options: - user: "c2aps39" - password: "B2fabc1181ed08e6" host: "localhost" - database: "c2aps37" + user: 'c2aps56' + password: '19fecd6087a04e6a' + database: 'c2aps52' backup: dir: "mysql-backup-dir" recovery: diff --git a/test/test.sql b/test/test.sql index 343f597..7b8bc72 100644 --- a/test/test.sql +++ b/test/test.sql @@ -11,12 +11,14 @@ RENAME table `wp_usermeta` TO `glm_usermeta`; RENAME table `wp_users` TO `glm_users`; INSERT INTO `glm_users` (`user_login`, `user_pass`, `user_nicename`, `user_email`, `user_url`, `user_registered`, `user_activation_key`, `user_status`, `display_name`) VALUES -('cscott', '$P$BJMie6Dwyp.RD6V6lGgh88TuJ/r625.', 'cscott', 'cscott@gaslightmedia.com', '', '2014-10-15 18:44:55', '', 0, 'cscott'), -('steve', '$P$BiMOzSw8hM5a/K/1pMj961nQvejfAZ1', 'steve', 'steve@gaslightmedia.com', '', '2014-10-15 18:44:55', '', 0, 'steve'), -('laury', '$P$BUQqo9GDEdRxgPGN3xHgxTAmhZmYUO1', 'laury', 'laury@gaslightmedia.com', '', '2014-10-15 18:44:55', '', 0, 'laury'), -('jodie', '$P$BzO0XuOIXx8b8x6ztWSKejkiK5lhvd/', 'jodie', 'jodie@gaslightmedia.com', '', '2014-10-15 18:44:55', '', 0, 'jodie'), -('candace', '$P$BAlC7cLEMtoBHes6Dd9RNEib5SOuWe.', 'candace', 'billing@gaslightmedia.com', '', '2014-10-15 18:44:55', '', 0, 'jodie'), -('anthony', '$P$BubULLBz9zOc1k7sQ6gQHkjCI40pOU1', 'anthony', 'anthony@gaslightmedia.com', '', '2014-10-15 18:44:55', '', 0, 'anthony'); +('cscott', '$P$BJMie6Dwyp.RD6V6lGgh88TuJ/r625.', 'cscott', 'cscott@gaslightmedia.com', '', NOW(), '', 0, 'cscott'), +('steve', '$P$BiMOzSw8hM5a/K/1pMj961nQvejfAZ1', 'steve', 'steve@gaslightmedia.com', '', NOW(), '', 0, 'steve'), +('laury', '$P$BUQqo9GDEdRxgPGN3xHgxTAmhZmYUO1', 'laury', 'laury@gaslightmedia.com', '', NOW(), '', 0, 'laury'), +('jodie', '$P$BzO0XuOIXx8b8x6ztWSKejkiK5lhvd/', 'jodie', 'jodie@gaslightmedia.com', '', NOW(), '', 0, 'jodie'), +('candace', '$P$BAlC7cLEMtoBHes6Dd9RNEib5SOuWe.', 'candace', 'billing@gaslightmedia.com', '', NOW(), '', 0, 'jodie'), +('anthony', '$P$BubULLBz9zOc1k7sQ6gQHkjCI40pOU1', 'anthony', 'anthony@gaslightmedia.com', '', NOW(), '', 0, 'anthony'), +('ianw', '$P$BVzlvcx8soNObjbgYr6pOpdQfw8oy0/', 'ianw', 'ian@gaslightmedia.com', '', NOW(), '', 0, 'ianw'), +('collins', '$P$BtB2gYe2c1PUAgCOwSWsUimqVSyuFs.', 'collins', 'collins@gaslightmedia.com', '', NOW(), '', 0, 'collins'); 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'; @@ -46,6 +48,18 @@ INSERT INTO `glm_usermeta` (`umeta_id`,`user_id`,`meta_key`,`meta_value`) VALUES (NULL, (SELECT `ID` FROM `glm_users` WHERE `user_login` = 'anthony'), 'glm_capabilities', 'a:1:{s:13:"administrator";b:1;}'), (NULL, (SELECT `ID` FROM `glm_users` WHERE `user_login` = 'anthony'), 'glm_user_level', '10'); +INSERT INTO `glm_usermeta` (`umeta_id`,`user_id`,`meta_key`,`meta_value`) VALUES +(NULL, (SELECT `ID` FROM `glm_users` WHERE `user_login` = 'candace'), 'glm_capabilities', 'a:1:{s:13:"administrator";b:1;}'), +(NULL, (SELECT `ID` FROM `glm_users` WHERE `user_login` = 'candace'), 'glm_user_level', '10'); + +INSERT INTO `glm_usermeta` (`umeta_id`,`user_id`,`meta_key`,`meta_value`) VALUES +(NULL, (SELECT `ID` FROM `glm_users` WHERE `user_login` = 'ianw'), 'glm_capabilities', 'a:1:{s:13:"administrator";b:1;}'), +(NULL, (SELECT `ID` FROM `glm_users` WHERE `user_login` = 'ianw'), 'glm_user_level', '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'); + 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