ENdUCvKP

1use teamcom_shard_01;
2
3DROP TABLE IF EXISTS contacts_test;
4
5CREATE TABLE contacts_test (
6  name VARCHAR(255),
7  email VARCHAR(255) NOT NULL,
8  public TINYINT(1), -- Values are either NULL, or True
9  workspace_id INT(11) unsigned NOT NULL,
10  creator INT(11) unsigned NOT NULL
11  , UNIQUE KEY `only_one_public` (workspace_id, public, email)
12  , UNIQUE KEY `creator_and_email` (workspace_id, creator, email)
13);
14
15EXPLAIN EXTENDED SELECT *
16                   FROM contacts_test
17		  WHERE workspace_id = 1234
18		    AND (creator = 1234 or public = 1)
19		     \G;
20
21show keys from contacts;