#
# TABLE STRUCTURE FOR: email
#

DROP TABLE IF EXISTS `email`;

CREATE TABLE `email` (
  `id` int(11) NOT NULL,
  `protocol` varchar(50) NOT NULL,
  `host` varchar(50) NOT NULL,
  `email` varchar(50) NOT NULL,
  `password` varchar(50) NOT NULL,
  `port` varchar(50) NOT NULL,
  `name` varchar(50) NOT NULL,
  `send_payment` int(11) NOT NULL,
  `send_verify` int(11) NOT NULL,
  `forgot_password` int(11) NOT NULL,
  `text_create` text NOT NULL,
  `text_pay` text NOT NULL,
  `text_verify` text NOT NULL,
  `text_forgot` text NOT NULL,
  `create_invoice` int(11) NOT NULL,
  `crypto` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

INSERT INTO `email` (`id`, `protocol`, `host`, `email`, `password`, `port`, `name`, `send_payment`, `send_verify`, `forgot_password`, `text_create`, `text_pay`, `text_verify`, `text_forgot`, `create_invoice`, `crypto`) VALUES (1, 'smtp', 'mail.1112-project.com', 'no-reply@1112-project.com', 'email1112.project', '587', '1112-Project', 0, 0, 0, '', '', '', '', 0, '');