From 4c44c02cbc0d024ac15480ed6a3db4bde371546f Mon Sep 17 00:00:00 2001 From: laury Date: Tue, 10 Jan 2017 13:53:28 -0500 Subject: [PATCH] Added usermeta to avoid every user needing saving on site creation Added rich_editing, glm_user-setting, and nickname. These values being unset would require a user to submit their user (or someone to submit all users on account creation) in order to function. --- test/test.sql | 44 ++++++++++++++++++++++++++++++++++++-------- 1 file changed, 36 insertions(+), 8 deletions(-) diff --git a/test/test.sql b/test/test.sql index 113a687..b90a015 100644 --- a/test/test.sql +++ b/test/test.sql @@ -27,46 +27,74 @@ UPDATE `glm_usermeta` SET `meta_key` = 'glm_user_level' WHERE `meta_key` = 'wp_u INSERT INTO `glm_usermeta` (`umeta_id`,`user_id`,`meta_key`,`meta_value`) VALUES (NULL, (SELECT `ID` FROM `glm_users` WHERE `user_login` = 'cscott'), 'glm_capabilities', 'a:1:{s:13:"administrator";b:1;}'), +(NULL, (SELECT `ID` FROM `glm_users` WHERE `user_login` = 'cscott'), 'rich_editing', 'true'), +(NULL, (SELECT `ID` FROM `glm_users` WHERE `user_login` = 'cscott'), 'nickname', 'cscott'), +(NULL, (SELECT `ID` FROM `glm_users` WHERE `user_login` = 'cscott'), 'glm_user-settings', 'editor=tinymce'), +(NULL, (SELECT `ID` FROM `glm_users` WHERE `user_login` = 'cscott'), 'show_admin_bar_front', 'false'), (NULL, (SELECT `ID` FROM `glm_users` WHERE `user_login` = 'cscott'), '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` = 'steve'), 'glm_capabilities', 'a:1:{s:13:"administrator";b:1;}'), +(NULL, (SELECT `ID` FROM `glm_users` WHERE `user_login` = 'steve'), 'rich_editing', 'true'), +(NULL, (SELECT `ID` FROM `glm_users` WHERE `user_login` = 'steve'), 'nickname', 'steve'), +(NULL, (SELECT `ID` FROM `glm_users` WHERE `user_login` = 'steve'), 'glm_user-settings', 'editor=tinymce'), +(NULL, (SELECT `ID` FROM `glm_users` WHERE `user_login` = 'steve'), 'show_admin_bar_front', 'false'), (NULL, (SELECT `ID` FROM `glm_users` WHERE `user_login` = 'steve'), '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` = 'laury'), 'glm_capabilities', 'a:1:{s:13:"administrator";b:1;}'), +(NULL, (SELECT `ID` FROM `glm_users` WHERE `user_login` = 'laury'), 'rich_editing', 'true'), +(NULL, (SELECT `ID` FROM `glm_users` WHERE `user_login` = 'laury'), 'nickname', 'laury'), +(NULL, (SELECT `ID` FROM `glm_users` WHERE `user_login` = 'laury'), 'glm_user-settings', 'editor=tinymce'), +(NULL, (SELECT `ID` FROM `glm_users` WHERE `user_login` = 'laury'), 'show_admin_bar_front', 'false'), (NULL, (SELECT `ID` FROM `glm_users` WHERE `user_login` = 'laury'), '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` = 'jodie'), 'glm_capabilities', 'a:1:{s:13:"administrator";b:1;}'), +(NULL, (SELECT `ID` FROM `glm_users` WHERE `user_login` = 'jodie'), 'rich_editing', 'true'), +(NULL, (SELECT `ID` FROM `glm_users` WHERE `user_login` = 'jodie'), 'nickname', 'jodie'), +(NULL, (SELECT `ID` FROM `glm_users` WHERE `user_login` = 'jodie'), 'glm_user-settings', 'editor=tinymce'), +(NULL, (SELECT `ID` FROM `glm_users` WHERE `user_login` = 'jodie'), 'show_admin_bar_front', 'false'), (NULL, (SELECT `ID` FROM `glm_users` WHERE `user_login` = 'jodie'), '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` = 'anthony'), 'glm_capabilities', 'a:1:{s:13:"administrator";b:1;}'), +(NULL, (SELECT `ID` FROM `glm_users` WHERE `user_login` = 'anthony'), 'rich_editing', 'true'), +(NULL, (SELECT `ID` FROM `glm_users` WHERE `user_login` = 'anthony'), 'nickname', 'anthony'), +(NULL, (SELECT `ID` FROM `glm_users` WHERE `user_login` = 'anthony'), 'glm_user-settings', 'editor=tinymce'), +(NULL, (SELECT `ID` FROM `glm_users` WHERE `user_login` = 'anthony'), 'show_admin_bar_front', 'false'), (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'), 'rich_editing', 'true'), +(NULL, (SELECT `ID` FROM `glm_users` WHERE `user_login` = 'ianw'), 'nickname', 'ianw'), +(NULL, (SELECT `ID` FROM `glm_users` WHERE `user_login` = 'ianw'), 'glm_user-settings', 'editor=tinymce'), +(NULL, (SELECT `ID` FROM `glm_users` WHERE `user_login` = 'ianw'), 'show_admin_bar_front', 'false'), (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'), 'rich_editing', 'true'), +(NULL, (SELECT `ID` FROM `glm_users` WHERE `user_login` = 'collins'), 'nickname', 'collins'), +(NULL, (SELECT `ID` FROM `glm_users` WHERE `user_login` = 'collins'), 'glm_user-settings', 'editor=tinymce'), +(NULL, (SELECT `ID` FROM `glm_users` WHERE `user_login` = 'collins'), 'show_admin_bar_front', 'false'), (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'), 'rich_editing', 'true'), +(NULL, (SELECT `ID` FROM `glm_users` WHERE `user_login` = 'anthonyt'), 'nickname', 'anthonyt'), +(NULL, (SELECT `ID` FROM `glm_users` WHERE `user_login` = 'anthonyt'), 'glm_user-settings', 'editor=tinymce'), +(NULL, (SELECT `ID` FROM `glm_users` WHERE `user_login` = 'anthonyt'), 'show_admin_bar_front', 'false'), (NULL, (SELECT `ID` FROM `glm_users` WHERE `user_login` = 'anthonyt'), '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` = 'charis'), 'glm_capabilities', 'a:1:{s:13:"administrator";b:1;}'), +(NULL, (SELECT `ID` FROM `glm_users` WHERE `user_login` = 'charis'), 'rich_editing', 'true'), +(NULL, (SELECT `ID` FROM `glm_users` WHERE `user_login` = 'charis'), 'nickname', 'charis'), +(NULL, (SELECT `ID` FROM `glm_users` WHERE `user_login` = 'charis'), 'glm_user-settings', 'editor=tinymce'), +(NULL, (SELECT `ID` FROM `glm_users` WHERE `user_login` = 'charis'), 'show_admin_bar_front', 'false'), (NULL, (SELECT `ID` FROM `glm_users` WHERE `user_login` = 'charis'), 'glm_user_level', '10'); -- 2.17.1