 CREATE TABLE `ftp` (
   `id` int(11) NOT NULL,
   `domain_id` int(11) NOT NULL,
-  `host` int(100) NOT NULL,
-  `login` varchar(50) NOT NULL,
+  `hostname` varchar(150) NOT NULL,
+  `username` varchar(50) NOT NULL,
   `password` varchar(100) NOT NULL,
   `status` tinyint(1) NOT NULL,
-  `created_at` int(11) DEFAULT NULL,
-  `updated_at` int(11) DEFAULT NULL
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+  `created_at` timestamp NULL DEFAULT NULL,
+  `updated_at` timestamp NULL DEFAULT NULL
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+--
+-- Дамп данных таблицы `ftp`
+--
+
+INSERT INTO `ftp` (`id`, `domain_id`, `hostname`, `username`, `password`, `status`, `created_at`, `updated_at`) VALUES
+(1, 1, '91.200.60.68', 'almetcentr_ftp', 'Y1u3W5x8', 1, '2017-10-30 07:07:38', '2017-10-30 07:07:38'),
+(2, 1, '91.200.60.68', 'almetcentr_ftp_seo', 'F1a3R5x8', 1, '2017-10-31 10:07:38', '2017-10-31 10:07:38'),
+(3, 3, '91.200.60.69', 'infocorpus_ftp', '7J7c9A7v', 1, '2017-11-01 10:07:38', '2017-11-01 10:07:38');
+
+-- --------------------------------------------------------
+
+--
+-- Структура таблицы `hosting`
+--
+
+CREATE TABLE `hosting` (
+  `id` int(11) NOT NULL,
+  `domain_id` int(11) NOT NULL,
+  `url` varchar(50) DEFAULT NULL,
+  `username` varchar(50) DEFAULT NULL,
+  `password` varchar(50) DEFAULT NULL,
+  `status` tinyint(1) NOT NULL DEFAULT '1',
+  `created_at` timestamp NULL DEFAULT NULL,
+  `updated_at` timestamp NULL DEFAULT NULL
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+--
+-- Дамп данных таблицы `hosting`
+--
+
+INSERT INTO `hosting` (`id`, `domain_id`, `url`, `username`, `password`, `status`, `created_at`, `updated_at`) VALUES
+(1, 3, '91.200.60.68:3000', 'root', 'GJoy4ewrieurf', 1, '2017-11-02 08:06:00', '2017-11-02 08:06:00');
 
 -- --------------------------------------------------------
 

--

--
-- Индексы таблицы `domains`
--
ALTER TABLE `domains`

CREATE TABLE `mysql` (
  `id` int(11) NOT NULL,
  `domain_id` int(11) NOT NULL,
  `phpmyadmin` varchar(50) DEFAULT NULL,
  `hostname` varchar(50) NOT NULL,
  `database_name` varchar(50) DEFAULT NULL,
  `username` varchar(50) NOT NULL,
  `password` varchar(50) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Дамп данных таблицы `mysql`
--

INSERT INTO `mysql` (`id`, `domain_id`, `phpmyadmin`, `hostname`, `database_name`, `username`, `password`, `status`, `created_at`, `updated_at`) VALUES
(1, 1, 'http://91.200.60.69/phpmyadmin/', '91.200.60.69', 'test_db', 'test_db', 'I4c9R4z5', 1, '2017-11-01 14:46:18', '2017-11-01 14:46:18'),
(2, 3, 'http://91.200.60.69/phpmyadmin/', '91.200.60.69', 'infocorpus_db', 'infocorpus_db', '8L8p6I4v', 1, '2017-11-01 14:46:18', '2017-11-01 14:46:18');

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

