7vXFvDEq

1DROP TABLE IF EXISTS `companies`;
2SET @saved_cs_client     = @@character_set_client;
3SET character_set_client = utf8;
4CREATE TABLE `companies` (
5  `id` int(11) NOT NULL AUTO_INCREMENT,
6  `sid` varchar(255) DEFAULT NULL,
7  .... attributes ....
8  PRIMARY KEY (`id`),
9  KEY `index_companies_true` (`phone`),
10  KEY `index_companies_user_id` (`user_id`),
11  KEY `index_companies_official_id` (`official_id`),
12  KEY `index_companies_dm_id` (`dm_id`),
13  KEY `index_companies_legacy_id` (`legacy_id`),
14  KEY `index_companies_fax` (`fax`),
15  KEY `index_companies_mamut_id` (`mamut_id`),
16  KEY `index_companies_updated_at` (`updated_at`),
17  KEY `index_companies_cellphone` (`cellphone`),
18  KEY `index_companies_sid` (`sid`) USING BTREE
19) ENGINE=InnoDB AUTO_INCREMENT=791758 DEFAULT CHARSET=utf8;
20SET character_set_client = @saved_cs_client;