test.sql

use teamcom_shard_01;

DROP TABLE IF EXISTS contacts_test;

CREATE TABLE contacts_test (
  name VARCHAR(255),
  email VARCHAR(255) NOT NULL,
  public TINYINT(1), -- Values are either NULL, or True
  workspace_id INT(11) unsigned NOT NULL,
  creator INT(11) unsigned NOT NULL
  , UNIQUE KEY `only_one_public` (workspace_id, public, email)
  , UNIQUE KEY `creator_and_email` (workspace_id, creator, email)
);

EXPLAIN EXTENDED SELECT *
                   FROM contacts_test
		  WHERE workspace_id = 1234
		    AND (creator = 1234 or public = 1)
		     \G;

show keys from contacts;