ALTER TABLE `dns_cache` CHANGE `ip` `ip` BIGINT UNSIGNED NULL DEFAULT NULL;
ALTER TABLE `dns_cache` CHANGE `id` `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `User_auth` CHANGE `ip_int` `ip_int` BIGINT(10) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `User_auth` CHANGE `user_id` `user_id` BIGINT UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `dhcp_log` CHANGE `ip_int` `ip_int` BIGINT UNSIGNED NOT NULL;
ALTER TABLE `dhcp_log` CHANGE `id` `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `dhcp_log` CHANGE `auth_id` `auth_id` BIGINT UNSIGNED NOT NULL;
ALTER TABLE `connections` CHANGE `id` `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, CHANGE `device_id` `device_id` BIGINT UNSIGNED NOT NULL, CHANGE `port_id` `port_id` BIGINT UNSIGNED NOT NULL, CHANGE `auth_id` `auth_id` BIGINT UNSIGNED NOT NULL;
ALTER TABLE `device_ports` CHANGE `id` `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, CHANGE `auth_id` `auth_id` BIGINT UNSIGNED NULL DEFAULT NULL;
ALTER TABLE `mac_history` CHANGE `id` `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, CHANGE `device_id` `device_id` BIGINT UNSIGNED NULL DEFAULT NULL, CHANGE `port_id` `port_id` BIGINT UNSIGNED NULL DEFAULT NULL, CHANGE `auth_id` `auth_id` BIGINT UNSIGNED NULL DEFAULT NULL;
ALTER TABLE `remote_syslog` CHANGE `id` `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, CHANGE `device_id` `device_id` BIGINT UNSIGNED NOT NULL;
ALTER TABLE `syslog` CHANGE `id` `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, CHANGE `auth_id` `auth_id` BIGINT UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `Traffic_detail` CHANGE `auth_id` `auth_id` BIGINT UNSIGNED NULL DEFAULT NULL, CHANGE `src_ip` `src_ip` BIGINT UNSIGNED NOT NULL, CHANGE `dst_ip` `dst_ip` BIGINT UNSIGNED NOT NULL;
ALTER TABLE `Unknown_mac` CHANGE `id` `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `Unknown_mac` CHANGE `port_id` `port_id` BIGINT UNSIGNED NULL DEFAULT NULL;
ALTER TABLE `User_list` CHANGE `id` `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `User_stats` CHANGE `id` `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, CHANGE `router_id` `router_id` BIGINT UNSIGNED NULL DEFAULT '0', CHANGE `auth_id` `auth_id` BIGINT UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `User_stats_full` CHANGE `id` `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, CHANGE `router_id` `router_id` BIGINT UNSIGNED NULL DEFAULT '0', CHANGE `auth_id` `auth_id` BIGINT UNSIGNED NOT NULL DEFAULT '0';
