Skip to content

Instantly share code, notes, and snippets.

View pm990320's full-sized avatar
🚀

Patrick Menlove pm990320

🚀
  • London, UK
View GitHub Profile
@pm990320
pm990320 / change_wp_table_prefix.sql
Last active February 3, 2020 19:33
Example code for changing the $table_prefix in wordpress after the database is created. This snippet will generate SQL commands that can then be run to migrate to the new prefix.
-- TODO: change the following values to match your environment. The old prefix will likely be "wp_" if using the defaults.
USE `wp-test`;
SET @database = "wp-test";
SET @old_prefix = "wp_" COLLATE utf8mb4_unicode_520_ci;
SET @new_prefix = "test_" COLLATE utf8mb4_unicode_520_ci;
SELECT
CONCAT(
"RENAME TABLE ",
TABLE_NAME,
@pm990320
pm990320 / keybase.md
Created April 22, 2018 13:53
Keybase proof

Keybase proof

I hereby claim:

  • I am pm990320 on github.
  • I am pa3km (https://keybase.io/pa3km) on keybase.
  • I have a public key ASCqPd5q-6_iOvPx06SP3qW6M5LWA0jzp2xIjqhKUTo76go

To claim this, I am signing this object:

PROMPT='
%{$fg[green]%}patrick %{$fg_bold[cyan]%}%~%{$FG[006]%}%B$(git_prompt_info) %{$reset_color%}
❯ '
# Customize git_prompt_info
ZSH_THEME_GIT_PROMPT_PREFIX="%{$FG[006]%}:%{$FG[009]%}"
ZSH_THEME_GIT_PROMPT_SUFFIX="%{$reset_color%}"
ZSH_THEME_GIT_PROMPT_DIRTY=" %{$FG[011]%}(●)%{$reset_color%}"
ZSH_THEME_GIT_PROMPT_CLEAN=" %{$FG[010]%}(●)%{$reset_color%}"