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

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

CREATE TABLE `scripts` (
  `id` int(11) NOT NULL,
  `alias` varchar(100) NOT NULL,
  `path` varchar(255) NOT NULL,
  `filename` varchar(100) NOT NULL,
  `state` varchar(50) NOT NULL COMMENT 'enabled | disabled',
  `name` varchar(100) NOT NULL,
  `description` text NOT NULL,
  `added_by` int(11) NOT NULL COMMENT 'user_id',
  `created_by` varchar(255) NOT NULL COMMENT 'Author of script',
  `update_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `create_at` timestamp NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
