Sākums Izpētīt Palīdzība
Pierakstīties
rajven
/
Eye
spogulis no https://github.com/rajven/Eye
1
0
Atdalīts 0
Faili Problēmas 0 Vikivietne
Koks: 2.5.2
Atzari Tagi
Eye
/
scripts
/
updates
/
2-4-8
/
int2bigint.sql

int2bigint.sql 2.3 KB
Patstāvīgā saite Vēsture Neapstrādāts

123456789101112131415161718 
  1. ALTER TABLE `dns_cache` CHANGE `ip` `ip` BIGINT UNSIGNED NULL DEFAULT NULL;
    2. 

  2. ALTER TABLE `dns_cache` CHANGE `id` `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT;
    3. 

  3. ALTER TABLE `User_auth` CHANGE `ip_int` `ip_int` BIGINT(10) UNSIGNED NOT NULL DEFAULT '0';
    4. 

  4. ALTER TABLE `User_auth` CHANGE `user_id` `user_id` BIGINT UNSIGNED NOT NULL DEFAULT '0';
    5. 

  5. ALTER TABLE `dhcp_log` CHANGE `ip_int` `ip_int` BIGINT UNSIGNED NOT NULL;
    6. 

  6. ALTER TABLE `dhcp_log` CHANGE `id` `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT;
    7. 

  7. ALTER TABLE `dhcp_log` CHANGE `auth_id` `auth_id` BIGINT UNSIGNED NOT NULL;
    8. 

  8. 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;
    9. 

  9. ALTER TABLE `device_ports` CHANGE `id` `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, CHANGE `auth_id` `auth_id` BIGINT UNSIGNED NULL DEFAULT NULL;
    10. 

  10. 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;
    11. 

  11. ALTER TABLE `remote_syslog` CHANGE `id` `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, CHANGE `device_id` `device_id` BIGINT UNSIGNED NOT NULL;
    12. 

  12. ALTER TABLE `syslog` CHANGE `id` `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, CHANGE `auth_id` `auth_id` BIGINT UNSIGNED NOT NULL DEFAULT '0';
    13. 

  13. 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;
    14. 

  14. ALTER TABLE `Unknown_mac` CHANGE `id` `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT;
    15. 

  15. ALTER TABLE `Unknown_mac` CHANGE `port_id` `port_id` BIGINT UNSIGNED NULL DEFAULT NULL;
    16. 

  16. ALTER TABLE `User_list` CHANGE `id` `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT;
    17. 

  17. 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';
    18. 

  18. 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';
    19.