-
-
Save rnagle/8844808ec324ac1eefca to your computer and use it in GitHub Desktop.
DROP TABLE IF EXISTS wp_users; | |
CREATE TABLE wp_users ( | |
ID bigint(20) unsigned NOT NULL auto_increment, | |
user_login varchar(60) NOT NULL default '', | |
user_pass varchar(64) NOT NULL default '', | |
user_nicename varchar(50) NOT NULL default '', | |
user_email varchar(100) NOT NULL default '', | |
user_url varchar(100) NOT NULL default '', | |
user_registered datetime NOT NULL default '0000-00-00 00:00:00', | |
user_activation_key varchar(60) NOT NULL default '', | |
user_status int(11) NOT NULL default '0', | |
display_name varchar(250) NOT NULL default '', | |
spam tinyint(2) NOT NULL default '0', | |
deleted tinyint(2) NOT NULL default '0', | |
PRIMARY KEY (ID), | |
KEY user_login_key (user_login), | |
KEY user_nicename (user_nicename) | |
) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; | |
DROP TABLE IF EXISTS wp_usermeta; | |
CREATE TABLE wp_usermeta ( | |
umeta_id bigint(20) unsigned NOT NULL auto_increment, | |
user_id bigint(20) unsigned NOT NULL default '0', | |
meta_key varchar(255) default NULL, | |
meta_value longtext, | |
PRIMARY KEY (umeta_id), | |
KEY user_id (user_id), | |
KEY meta_key (meta_key) | |
) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; | |
DROP TABLE IF EXISTS wp_terms; | |
CREATE TABLE wp_terms ( | |
term_id bigint(20) unsigned NOT NULL auto_increment, | |
name varchar(200) NOT NULL default '', | |
slug varchar(200) NOT NULL default '', | |
term_group bigint(10) NOT NULL default 0, | |
PRIMARY KEY (term_id), | |
KEY slug (slug), | |
KEY name (name) | |
) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; | |
DROP TABLE IF EXISTS wp_term_taxonomy; | |
CREATE TABLE wp_term_taxonomy ( | |
term_taxonomy_id bigint(20) unsigned NOT NULL auto_increment, | |
term_id bigint(20) unsigned NOT NULL default 0, | |
taxonomy varchar(32) NOT NULL default '', | |
description longtext NOT NULL, | |
parent bigint(20) unsigned NOT NULL default 0, | |
count bigint(20) NOT NULL default 0, | |
PRIMARY KEY (term_taxonomy_id), | |
UNIQUE KEY term_id_taxonomy (term_id,taxonomy), | |
KEY taxonomy (taxonomy) | |
) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; | |
DROP TABLE IF EXISTS wp_term_relationships; | |
CREATE TABLE wp_term_relationships ( | |
object_id bigint(20) unsigned NOT NULL default 0, | |
term_taxonomy_id bigint(20) unsigned NOT NULL default 0, | |
term_order int(11) NOT NULL default 0, | |
PRIMARY KEY (object_id,term_taxonomy_id), | |
KEY term_taxonomy_id (term_taxonomy_id) | |
) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; | |
DROP TABLE IF EXISTS wp_commentmeta; | |
CREATE TABLE wp_commentmeta ( | |
meta_id bigint(20) unsigned NOT NULL auto_increment, | |
comment_id bigint(20) unsigned NOT NULL default '0', | |
meta_key varchar(255) default NULL, | |
meta_value longtext, | |
PRIMARY KEY (meta_id), | |
KEY comment_id (comment_id), | |
KEY meta_key (meta_key) | |
) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; | |
DROP TABLE IF EXISTS wp_comments; | |
CREATE TABLE wp_comments ( | |
comment_ID bigint(20) unsigned NOT NULL auto_increment, | |
comment_post_ID bigint(20) unsigned NOT NULL default '0', | |
comment_author tinytext NOT NULL, | |
comment_author_email varchar(100) NOT NULL default '', | |
comment_author_url varchar(200) NOT NULL default '', | |
comment_author_IP varchar(100) NOT NULL default '', | |
comment_date datetime NOT NULL default '0000-00-00 00:00:00', | |
comment_date_gmt datetime NOT NULL default '0000-00-00 00:00:00', | |
comment_content text NOT NULL, | |
comment_karma int(11) NOT NULL default '0', | |
comment_approved varchar(20) NOT NULL default '1', | |
comment_agent varchar(255) NOT NULL default '', | |
comment_type varchar(20) NOT NULL default '', | |
comment_parent bigint(20) unsigned NOT NULL default '0', | |
user_id bigint(20) unsigned NOT NULL default '0', | |
PRIMARY KEY (comment_ID), | |
KEY comment_post_ID (comment_post_ID), | |
KEY comment_approved_date_gmt (comment_approved,comment_date_gmt), | |
KEY comment_date_gmt (comment_date_gmt), | |
KEY comment_parent (comment_parent), | |
KEY comment_author_email (comment_author_email(10)) | |
) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; | |
DROP TABLE IF EXISTS wp_links; | |
CREATE TABLE wp_links ( | |
link_id bigint(20) unsigned NOT NULL auto_increment, | |
link_url varchar(255) NOT NULL default '', | |
link_name varchar(255) NOT NULL default '', | |
link_image varchar(255) NOT NULL default '', | |
link_target varchar(25) NOT NULL default '', | |
link_description varchar(255) NOT NULL default '', | |
link_visible varchar(20) NOT NULL default 'Y', | |
link_owner bigint(20) unsigned NOT NULL default '1', | |
link_rating int(11) NOT NULL default '0', | |
link_updated datetime NOT NULL default '0000-00-00 00:00:00', | |
link_rel varchar(255) NOT NULL default '', | |
link_notes mediumtext NOT NULL, | |
link_rss varchar(255) NOT NULL default '', | |
PRIMARY KEY (link_id), | |
KEY link_visible (link_visible) | |
) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; | |
DROP TABLE IF EXISTS wp_options; | |
CREATE TABLE wp_options ( | |
option_id bigint(20) unsigned NOT NULL auto_increment, | |
option_name varchar(64) NOT NULL default '', | |
option_value longtext NOT NULL, | |
autoload varchar(20) NOT NULL default 'yes', | |
PRIMARY KEY (option_id), | |
UNIQUE KEY option_name (option_name) | |
) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; | |
DROP TABLE IF EXISTS wp_postmeta; | |
CREATE TABLE wp_postmeta ( | |
meta_id bigint(20) unsigned NOT NULL auto_increment, | |
post_id bigint(20) unsigned NOT NULL default '0', | |
meta_key varchar(255) default NULL, | |
meta_value longtext, | |
PRIMARY KEY (meta_id), | |
KEY post_id (post_id), | |
KEY meta_key (meta_key) | |
) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; | |
DROP TABLE IF EXISTS wp_posts; | |
CREATE TABLE wp_posts ( | |
ID bigint(20) unsigned NOT NULL auto_increment, | |
post_author bigint(20) unsigned NOT NULL default '0', | |
post_date datetime NOT NULL default '0000-00-00 00:00:00', | |
post_date_gmt datetime NOT NULL default '0000-00-00 00:00:00', | |
post_content longtext NOT NULL, | |
post_title text NOT NULL, | |
post_excerpt text NOT NULL, | |
post_status varchar(20) NOT NULL default 'publish', | |
comment_status varchar(20) NOT NULL default 'open', | |
ping_status varchar(20) NOT NULL default 'open', | |
post_password varchar(20) NOT NULL default '', | |
post_name varchar(200) NOT NULL default '', | |
to_ping text NOT NULL, | |
pinged text NOT NULL, | |
post_modified datetime NOT NULL default '0000-00-00 00:00:00', | |
post_modified_gmt datetime NOT NULL default '0000-00-00 00:00:00', | |
post_content_filtered longtext NOT NULL, | |
post_parent bigint(20) unsigned NOT NULL default '0', | |
guid varchar(255) NOT NULL default '', | |
menu_order int(11) NOT NULL default '0', | |
post_type varchar(20) NOT NULL default 'post', | |
post_mime_type varchar(100) NOT NULL default '', | |
comment_count bigint(20) NOT NULL default '0', | |
PRIMARY KEY (ID), | |
KEY post_name (post_name), | |
KEY type_status_date (post_type,post_status,post_date,ID), | |
KEY post_parent (post_parent), | |
KEY post_author (post_author) | |
) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; | |
DROP TABLE IF EXISTS wp_blogs; | |
CREATE TABLE wp_blogs ( | |
blog_id bigint(20) NOT NULL auto_increment, | |
site_id bigint(20) NOT NULL default '0', | |
domain varchar(200) NOT NULL default '', | |
path varchar(100) NOT NULL default '', | |
registered datetime NOT NULL default '0000-00-00 00:00:00', | |
last_updated datetime NOT NULL default '0000-00-00 00:00:00', | |
public tinyint(2) NOT NULL default '1', | |
archived tinyint(2) NOT NULL default '0', | |
mature tinyint(2) NOT NULL default '0', | |
spam tinyint(2) NOT NULL default '0', | |
deleted tinyint(2) NOT NULL default '0', | |
lang_id int(11) NOT NULL default '0', | |
PRIMARY KEY (blog_id), | |
KEY domain (domain(50),path(5)), | |
KEY lang_id (lang_id) | |
) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; | |
DROP TABLE IF EXISTS wp_blog_versions; | |
CREATE TABLE wp_blog_versions ( | |
blog_id bigint(20) NOT NULL default '0', | |
db_version varchar(20) NOT NULL default '', | |
last_updated datetime NOT NULL default '0000-00-00 00:00:00', | |
PRIMARY KEY (blog_id), | |
KEY db_version (db_version) | |
) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; | |
DROP TABLE IF EXISTS wp_registration_log; | |
CREATE TABLE wp_registration_log ( | |
ID bigint(20) NOT NULL auto_increment, | |
email varchar(255) NOT NULL default '', | |
IP varchar(30) NOT NULL default '', | |
blog_id bigint(20) NOT NULL default '0', | |
date_registered datetime NOT NULL default '0000-00-00 00:00:00', | |
PRIMARY KEY (ID), | |
KEY IP (IP) | |
) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; | |
DROP TABLE IF EXISTS wp_site; | |
CREATE TABLE wp_site ( | |
id bigint(20) NOT NULL auto_increment, | |
domain varchar(200) NOT NULL default '', | |
path varchar(100) NOT NULL default '', | |
PRIMARY KEY (id), | |
KEY domain (domain,path) | |
) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; | |
DROP TABLE IF EXISTS wp_sitemeta; | |
CREATE TABLE wp_sitemeta ( | |
meta_id bigint(20) NOT NULL auto_increment, | |
site_id bigint(20) NOT NULL default '0', | |
meta_key varchar(255) default NULL, | |
meta_value longtext, | |
PRIMARY KEY (meta_id), | |
KEY meta_key (meta_key), | |
KEY site_id (site_id) | |
) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; | |
DROP TABLE IF EXISTS wp_signups; | |
CREATE TABLE wp_signups ( | |
signup_id bigint(20) NOT NULL auto_increment, | |
domain varchar(200) NOT NULL default '', | |
path varchar(100) NOT NULL default '', | |
title longtext NOT NULL, | |
user_login varchar(60) NOT NULL default '', | |
user_email varchar(100) NOT NULL default '', | |
registered datetime NOT NULL default '0000-00-00 00:00:00', | |
activated datetime NOT NULL default '0000-00-00 00:00:00', | |
active tinyint(1) NOT NULL default '0', | |
activation_key varchar(50) NOT NULL default '', | |
meta longtext, | |
PRIMARY KEY (signup_id), | |
KEY activation_key (activation_key), | |
KEY user_email (user_email), | |
KEY user_login_email (user_login,user_email), | |
KEY domain_path (domain,path) | |
) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; |
Will
Thank you so much for creating these. I was missing wp_comments table for some reason, so I was able to snip the relevant SQL to recreate that. Life saver.
If you get an error such as "Invalid default value for 'user_registered'" or any other DateTime column, your MySql server is set to strict mode, so won't allow '0000-00-00 00:00:00' .
One workaround is to replace each default value with '1970-01-01 00:00:01' .
thank you, man! thats helps me to recreate wp_options
Thank you. you must correct in the wp_posts table post_password varchar (20) to post_password varchar (255), because woocommerce do not work, greetings.
If you get an error such as "Invalid default value for 'user_registered'" or any other DateTime column, your MySql server is set to strict mode, so won't allow '0000-00-00 00:00:00' .
One workaround is to replace each default value with '1970-01-01 00:00:01' .
or above the table add this
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";
Okay, Very helpful one...
I noticed however the Comment approve column on the wp_comment table has an auto value of 1, How's that? especially for a site that needs admin moderation of comments before they can be displayed.?
Or am I missing something please.
Thank you so much for this. Can you please write the code for termmeta too?
Very helpful, thank you so much!
wont this remove my data?