   ADD PRIMARY KEY (`place_id`);
 
 --
--- Indexes for table `social_network`
---
-ALTER TABLE `social_network`
+-- Indexes for table `social_networks`
+--
+ALTER TABLE `social_networks`
+  ADD KEY `company_id` (`company_id`),
+  ADD KEY `social_network_id` (`social_network_id`);
+
+--
+-- Indexes for table `social_networks_list`
+--
+ALTER TABLE `social_networks_list`
   ADD PRIMARY KEY (`id`);
 
 --
--- Indexes for table `telephone_number`
---
-ALTER TABLE `telephone_number`
+-- Indexes for table `subcategories_list`
+--
+ALTER TABLE `subcategories_list`
+  ADD PRIMARY KEY (`id`);
+
+--
+-- Indexes for table `telephone_numbers`
+--
+ALTER TABLE `telephone_numbers`
   ADD KEY `company_id` (`company_id`);
 
 --


CREATE TABLE `pictures` (
  `event_id` int(10) UNSIGNED NOT NULL,
  `picture` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--

--
-- Indexes for table `categories`
--
ALTER TABLE `categories`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `name` (`category_id`),
  ADD KEY `subcategory_id` (`subcategory_id`);

--
-- Indexes for table `categories_list`
--
ALTER TABLE `categories_list`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `categories_subcategories`
--
ALTER TABLE `categories_subcategories`
  ADD KEY `subcategory_id` (`subcategory_id`),
  ADD KEY `category_idx` (`category_id`);

--
-- Indexes for table `companies`
--
ALTER TABLE `companies`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `login` (`login`),
  ADD KEY `place_id` (`place_id`);
