edgarsm

Untitled

Jan 20th, 2021
862
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

Adblocker detected! Please consider disabling it...

We've detected AdBlock Plus or some other adblocking software preventing Pastebin.com from fully loading.

We don't have any obnoxious sound, or popup ads, we actively block these annoying types of ads!

Please add Pastebin.com to your ad blocker whitelist or disable your adblocking software.

×