Advertisement
Guest User

Untitled

a guest
Apr 17th, 2018
53
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.70 KB | None | 0 0
  1. --
  2. -- Структура таблицы `users_online`
  3. --
  4.  
  5. CREATE TABLE `users_online` (
  6.   `name` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL,
  7.   `last_entrance` datetime DEFAULT NULL,
  8.   `server_1` int(11) DEFAULT '0',
  9.   `server_2` int(11) DEFAULT '0',
  10.   `server_3` int(11) DEFAULT '0'
  11. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  12.  
  13. --
  14. -- Дамп данных таблицы `users_online`
  15. --
  16.  
  17. INSERT INTO `users_online` (`name`, `last_entrance`, `server_1`, `server_2`, `server_3`) VALUES
  18. ('DraXXX', '2018-04-15 23:40:10', 22553, 22553, 22553);
  19.  
  20. --
  21. -- Индексы таблицы `users_online`
  22. --
  23. ALTER TABLE `users_online`
  24.   ADD PRIMARY KEY (`name`);
  25. COMMIT;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement