Newer
Older
smart-home-server / database_dump / smart-home-server_table_user_sessions.sql

-- --------------------------------------------------------

--
-- Структура таблицы `user_sessions`
--

CREATE TABLE `user_sessions` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `token` varchar(100) NOT NULL,
  `state` varchar(50) NOT NULL DEFAULT 'active' COMMENT 'active | outdated | killed',
  `is_eternal` tinyint(1) NOT NULL DEFAULT 0,
  `last_activity` timestamp NOT NULL DEFAULT current_timestamp(),
  `create_at` timestamp NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;