-- -- Indexes for dumped tables -- -- -- Indexes for table `auth_rules` -- ALTER TABLE `auth_rules` ADD PRIMARY KEY (`id`); -- -- Indexes for table `building` -- ALTER TABLE `building` ADD PRIMARY KEY (`id`); -- -- Indexes for table `config` -- ALTER TABLE `config` ADD PRIMARY KEY (`id`), ADD KEY `option` (`option_id`); -- -- Indexes for table `config_options` -- ALTER TABLE `config_options` ADD PRIMARY KEY (`id`); -- -- Indexes for table `connections` -- ALTER TABLE `connections` ADD PRIMARY KEY (`id`), ADD KEY `auth_id` (`auth_id`), ADD KEY `device_id` (`device_id`,`port_id`); -- -- Indexes for table `Customers` -- ALTER TABLE `Customers` ADD PRIMARY KEY (`id`); -- -- Indexes for table `devices` -- ALTER TABLE `devices` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `id` (`id`), ADD KEY `ip` (`ip`), ADD KEY `device_type` (`device_type`); -- -- Indexes for table `device_l3_interfaces` -- ALTER TABLE `device_l3_interfaces` ADD PRIMARY KEY (`id`); -- -- Indexes for table `device_models` -- ALTER TABLE `device_models` ADD PRIMARY KEY (`id`); -- -- Indexes for table `device_ports` -- ALTER TABLE `device_ports` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `id` (`id`), ADD KEY `device_id` (`device_id`), ADD KEY `port` (`port`), ADD KEY `target_port_id` (`target_port_id`); -- -- Indexes for table `device_types` -- ALTER TABLE `device_types` ADD PRIMARY KEY (`id`); -- -- Indexes for table `dhcp_log` -- ALTER TABLE `dhcp_log` ADD PRIMARY KEY (`id`), ADD KEY `timestamp` (`timestamp`), ADD KEY `ip1` (`ip`), ADD KEY `timestamp_2` (`timestamp`,`action`); -- -- Indexes for table `dns_cache` -- ALTER TABLE `dns_cache` ADD PRIMARY KEY (`id`), ADD KEY `dns` (`dns`,`ip`), ADD KEY `timestamp` (`timestamp`); -- -- Indexes for table `Filter_list` -- ALTER TABLE `Filter_list` ADD PRIMARY KEY (`id`), ADD KEY `Name` (`name`); -- -- Indexes for table `Group_filters` -- ALTER TABLE `Group_filters` ADD PRIMARY KEY (`id`), ADD KEY `GroupId` (`group_id`,`filter_id`); -- -- Indexes for table `Group_list` -- ALTER TABLE `Group_list` ADD PRIMARY KEY (`id`); -- -- Indexes for table `mac_history` -- ALTER TABLE `mac_history` ADD PRIMARY KEY (`id`), ADD KEY `mac` (`mac`,`timestamp`) USING BTREE, ADD KEY `ip` (`ip`,`timestamp`) USING BTREE, ADD KEY `timestamp` (`timestamp`,`mac`), ADD KEY `timestamp_2` (`timestamp`,`ip`); -- -- Indexes for table `mac_vendors` -- ALTER TABLE `mac_vendors` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `oui` (`oui`); -- -- Indexes for table `OU` -- ALTER TABLE `OU` ADD PRIMARY KEY (`id`); -- -- Indexes for table `Queue_list` -- ALTER TABLE `Queue_list` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `id` (`id`); -- -- Indexes for table `remote_syslog` -- ALTER TABLE `remote_syslog` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `id` (`id`), ADD KEY `device_id` (`device_id`), ADD KEY `date` (`date`,`device_id`,`ip`); ALTER TABLE `remote_syslog` ADD FULLTEXT KEY `message` (`message`); ALTER TABLE `remote_syslog` ADD FULLTEXT KEY `message_2` (`message`); -- -- Indexes for table `subnets` -- ALTER TABLE `subnets` ADD PRIMARY KEY (`id`), ADD KEY `ip_int_start` (`ip_int_start`,`ip_int_stop`), ADD KEY `dhcp` (`dhcp`,`office`,`hotspot`,`static`); -- -- Indexes for table `syslog` -- ALTER TABLE `syslog` ADD PRIMARY KEY (`id`), ADD KEY `auth_idx` (`auth_id`), ADD KEY `timestamp` (`timestamp`,`auth_id`,`customer`,`level`), ADD KEY `timestamp_2` (`timestamp`,`level`,`customer`); ALTER TABLE `syslog` ADD FULLTEXT KEY `message` (`message`); ALTER TABLE `syslog` ADD FULLTEXT KEY `message_2` (`message`); ALTER TABLE `syslog` ADD FULLTEXT KEY `customer` (`customer`); -- -- Indexes for table `Traffic_detail` -- ALTER TABLE `Traffic_detail` ADD PRIMARY KEY (`id`), ADD KEY `src` (`auth_id`,`timestamp`,`router_id`,`src_ip`), ADD KEY `dst` (`auth_id`,`timestamp`,`router_id`,`dst_ip`); -- -- Indexes for table `Unknown_mac` -- ALTER TABLE `Unknown_mac` ADD PRIMARY KEY (`id`), ADD KEY `mac` (`mac`,`timestamp`), ADD KEY `timestamp` (`timestamp`,`device_id`,`port_id`,`mac`); -- -- Indexes for table `User_auth` -- ALTER TABLE `User_auth` ADD PRIMARY KEY (`id`), ADD KEY `auth_index` (`id`,`user_id`,`ip_int`,`mac`,`ip`,`deleted`), ADD KEY `deleted` (`deleted`); -- -- Indexes for table `User_auth_alias` -- ALTER TABLE `User_auth_alias` ADD PRIMARY KEY (`id`), ADD KEY `auth_id` (`auth_id`); -- -- Indexes for table `User_list` -- ALTER TABLE `User_list` ADD PRIMARY KEY (`id`), ADD KEY `users` (`id`,`ou_id`,`enabled`,`blocked`,`deleted`); -- -- Indexes for table `User_stats` -- ALTER TABLE `User_stats` ADD PRIMARY KEY (`id`), ADD KEY `timestamp` (`timestamp`,`auth_id`,`router_id`); -- -- Indexes for table `User_stats_full` -- ALTER TABLE `User_stats_full` ADD PRIMARY KEY (`id`), ADD KEY `timestamp` (`timestamp`,`auth_id`,`router_id`); -- -- Indexes for table `variables` -- ALTER TABLE `variables` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `name` (`name`), ADD KEY `clear_time` (`clear_time`,`created`); -- -- Indexes for table `vendors` -- ALTER TABLE `vendors` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `auth_rules` -- ALTER TABLE `auth_rules` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `building` -- ALTER TABLE `building` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `config` -- ALTER TABLE `config` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `config_options` -- ALTER TABLE `config_options` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=63; -- -- AUTO_INCREMENT for table `connections` -- ALTER TABLE `connections` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `Customers` -- ALTER TABLE `Customers` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `devices` -- ALTER TABLE `devices` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `device_l3_interfaces` -- ALTER TABLE `device_l3_interfaces` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `device_models` -- ALTER TABLE `device_models` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10000; -- -- AUTO_INCREMENT for table `device_ports` -- ALTER TABLE `device_ports` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `device_types` -- ALTER TABLE `device_types` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `dhcp_log` -- ALTER TABLE `dhcp_log` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `dns_cache` -- ALTER TABLE `dns_cache` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `Filter_list` -- ALTER TABLE `Filter_list` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=107; -- -- AUTO_INCREMENT for table `Group_filters` -- ALTER TABLE `Group_filters` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=235; -- -- AUTO_INCREMENT for table `Group_list` -- ALTER TABLE `Group_list` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `mac_history` -- ALTER TABLE `mac_history` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `mac_vendors` -- ALTER TABLE `mac_vendors` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=38949; -- -- AUTO_INCREMENT for table `OU` -- ALTER TABLE `OU` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `Queue_list` -- ALTER TABLE `Queue_list` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `remote_syslog` -- ALTER TABLE `remote_syslog` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `subnets` -- ALTER TABLE `subnets` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `syslog` -- ALTER TABLE `syslog` MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `Traffic_detail` -- ALTER TABLE `Traffic_detail` MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `Unknown_mac` -- ALTER TABLE `Unknown_mac` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `User_auth` -- ALTER TABLE `User_auth` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `User_auth_alias` -- ALTER TABLE `User_auth_alias` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `User_list` -- ALTER TABLE `User_list` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `User_stats` -- ALTER TABLE `User_stats` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `User_stats_full` -- ALTER TABLE `User_stats_full` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `variables` -- ALTER TABLE `variables` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `vendors` -- ALTER TABLE `vendors` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10000;