edgarsm

Untitled

Jan 20th, 2021
739
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. FROM this
  2. CREATE TABLE `devices` (
  3.   `id` varchar(20) NOT NULL DEFAULT '',
  4.   `tech` varchar(10) NOT NULL DEFAULT '',
  5.   `dial` varchar(50) NOT NULL DEFAULT '',
  6.   `devicetype` varchar(5) NOT NULL DEFAULT '',
  7.   `user` varchar(50) DEFAULT NULL,
  8.   `description` varchar(50) DEFAULT NULL,
  9.   `emergency_cid` varchar(100) DEFAULT NULL,
  10.   KEY `id` (`id`),
  11.   KEY `tech` (`tech`)
  12. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  13.  
  14.  
  15. TO this
  16. CREATE TABLE `devices` (
  17.   `id` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  18.   `tech` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  19.   `dial` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  20.   `devicetype` varchar(5) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  21.   `user` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  22.   `description` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  23.   `emergency_cid` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  24.   `hint_override` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  25.   KEY `id` (`id`),
  26.   KEY `tech` (`tech`)
  27. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
RAW Paste Data