· 9 years ago · Oct 03, 2016, 10:58 PM
1CREATE TABLE IF NOT EXISTS wp_domain_mapping (
2 id BIGINT NOT NULL AUTO_INCREMENT,
3 blog_id BIGINT NOT NULL,
4 domain VARCHAR(255) NOT NULL,
5 active TINYINT DEFAULT 1,
6 PRIMARY KEY (id),
7 KEY blog_id (blog_id, domain, active)
8) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci