-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `connoisseur`
--

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

--
-- Table structure for table `account`
--

CREATE TABLE IF NOT EXISTS `account` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `name` tinytext,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `account`
--

INSERT INTO `account` (`id`, `created`, `updated`, `name`) VALUES
(1, '2021-05-18 14:55:16', '2021-05-18 14:55:16', 'rena brown enterprise'),
(3, '2021-05-19 08:16:03', '2021-05-19 08:16:03', 'rons enterprise');

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

--
-- Table structure for table `link`
--

CREATE TABLE IF NOT EXISTS `link` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `account` int(11) DEFAULT NULL,
  `user` int(11) DEFAULT NULL,
  `product` json DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `link`
--

INSERT INTO `link` (`id`, `created`, `updated`, `account`, `user`, `product`) VALUES
(1, '2021-05-18 16:21:45', '2021-05-18 16:21:45', 1, 59, NULL),
(2, '2021-05-19 08:16:30', '2021-05-19 08:16:30', 3, 81, NULL);

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

--
-- Table structure for table `product`
--

CREATE TABLE IF NOT EXISTS `product` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `name` tinytext,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `product`
--

INSERT INTO `product` (`id`, `created`, `updated`, `name`) VALUES
(1, '2021-05-18 15:01:11', '2021-05-18 15:01:11', 'Amnesia Lemon Haze'),
(2, '2021-05-19 08:17:11', '2021-05-19 08:17:11', 'popsicle'),
(3, '2021-05-19 08:17:36', '2021-05-19 08:17:36', 'pre-roll');

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

--
-- Table structure for table `transaction`
--

CREATE TABLE IF NOT EXISTS `transaction` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `account` int(11) NOT NULL,
  `user` int(11) NOT NULL,
  `product` int(11) NOT NULL,
  `quantity` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `transaction`
--

INSERT INTO `transaction` (`id`, `created`, `updated`, `account`, `user`, `product`, `quantity`) VALUES
(1, '2021-05-18 15:02:38', '2021-05-18 15:03:34', 1, 59, 1, 5);

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

--
-- Table structure for table `user`
--

CREATE TABLE IF NOT EXISTS `user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `name` tinytext,
  `request` tinytext,
  `email` tinytext,
  `notify_by` tinytext,
  `tel` varchar(10) DEFAULT NULL,
  `sms_gateway` tinytext,
  `type` tinytext,
  `pass` tinytext,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=82 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `user`
--

INSERT INTO `user` (`id`, `created`, `updated`, `name`, `request`, `email`, `notify_by`, `tel`, `sms_gateway`, `type`, `pass`) VALUES
(59, '2021-05-16 16:56:21', '2021-05-19 08:14:53', '', 'generate_pass', 'rena@brown.com', 'tel', '9182031234', 'vtext.com', 'reseller', '$2y$10$RfPqpBdAnYaP8avmxzS9Zuu1ffCvhLvxz9LXLY4oOovLc1sa3PI0e'),
(81, '2021-05-19 08:15:05', '2021-05-19 08:15:05', NULL, 'generate_pass', 'ron@kohn.com', 'tel', '2036717413', 'vtext.com', 'reseller', '$2y$10$hB7nZWx/S.wG6zRDT.a4juY1EmewCDmzpGbe.wWS1l1ist803gnMi');
COMMIT;

