Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE `my_table` (
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `ref_a_id` int(10) unsigned NOT NULL,
- `ref_b_id` int(10) unsigned NOT NULL,
- `is_active` tinyint(1) DEFAULT '1',
- PRIMARY KEY (`id`),
- UNIQUE KEY `index_my_table_on_ref_a_ref_b_is_active` (`ref_a_id`, `ref_b_id`, `is_active`)
- ) ENGINE=InnoDB AUTO_INCREMENT=2818259 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement