-- http://www.phpmyadmin.net
--




--
-- Database: `sunvert`
--

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

--
-- Table structure for table `auth_assignment`
--

CREATE TABLE `auth_assignment` (
  `item_name` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
  `user_id` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `auth_assignment`
--

INSERT INTO `auth_assignment` (`item_name`, `user_id`, `created_at`) VALUES
('Super Admin', '1', 1571818136);

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

--
-- Table structure for table `auth_item`
--

CREATE TABLE `auth_item` (
  `name` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
  `type` smallint(6) NOT NULL,
  `description` text COLLATE utf8_unicode_ci,
  `rule_name` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  `data` blob,
  `created_at` int(11) DEFAULT NULL,
  `updated_at` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `auth_item`
--

INSERT INTO `auth_item` (`name`, `type`, `description`, `rule_name`, `data`, `created_at`, `updated_at`) VALUES
('/*', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/admin/*', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/admin/assignment/*', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/admin/assignment/assign', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/admin/assignment/index', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/admin/assignment/revoke', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/admin/assignment/view', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/admin/default/*', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/admin/default/index', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/admin/menu/*', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/admin/menu/create', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/admin/menu/delete', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/admin/menu/index', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/admin/menu/update', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/admin/menu/view', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/admin/permission/*', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/admin/permission/assign', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/admin/permission/create', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/admin/permission/delete', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/admin/permission/index', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/admin/permission/remove', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/admin/permission/update', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/admin/permission/view', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/admin/role/*', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/admin/role/assign', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/admin/role/create', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/admin/role/delete', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/admin/role/index', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/admin/role/remove', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/admin/role/update', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/admin/role/view', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/admin/route/*', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/admin/route/assign', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/admin/route/create', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/admin/route/index', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/admin/route/refresh', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/admin/route/remove', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/admin/rule/*', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/admin/rule/create', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/admin/rule/delete', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/admin/rule/index', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/admin/rule/update', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/admin/rule/view', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/admin/user/*', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/admin/user/activate', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/admin/user/change-password', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/admin/user/delete', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/admin/user/index', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/admin/user/login', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/admin/user/logout', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/admin/user/request-password-reset', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/admin/user/reset-password', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/admin/user/signup', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/admin/user/view', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/banner/*', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/banner/create', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/banner/delete', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/banner/index', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/banner/update', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/banner/view', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/categories/*', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/categories/create', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/categories/delete', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/categories/index', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/categories/update', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/categories/view', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/cms/*', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/cms/create', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/cms/delete', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/cms/index', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/cms/update', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/cms/view', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/dashboard/*', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/dashboard/index', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/dashboard/single-data', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/debug/*', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/debug/default/*', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/debug/default/db-explain', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/debug/default/download-mail', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/debug/default/index', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/debug/default/toolbar', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/debug/default/view', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/debug/user/*', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/debug/user/reset-identity', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/debug/user/set-identity', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/feedback/*', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/feedback/create', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/feedback/delete', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/feedback/index', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/feedback/update', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/feedback/view', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/gii/*', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/gii/default/*', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/gii/default/action', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/gii/default/diff', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/gii/default/index', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/gii/default/preview', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/gii/default/view', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/gridview/*', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/gridview/export/*', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/gridview/export/download', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/news/*', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/news/create', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/news/delete', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/news/index', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/news/update', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/news/view', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/products/*', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/products/create', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/products/delete', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/products/index', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/products/update', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/products/view', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/site/*', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/site/about', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/site/captcha', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/site/changelanguage', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/site/contact', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/site/contact-request', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/site/error', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/site/index', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/site/login', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/site/logout', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/site/products', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/site/test-mail', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/suppliers/*', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/suppliers/create', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/suppliers/delete', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/suppliers/index', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/suppliers/update', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/suppliers/view', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/testimonial/*', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/testimonial/create', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/testimonial/delete', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/testimonial/index', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/testimonial/update', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/testimonial/view', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/uploads/*', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/uploads/common', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/uploads/filedelete', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/uploads/mom-upload', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/uploads/products-upload', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/users/*', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/users/create', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/users/delete', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/users/index', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/users/update', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('/users/view', 2, NULL, NULL, NULL, 1571818038, 1571818038),
('Super Admin', 1, NULL, NULL, NULL, 1571818123, 1571818123);

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

--
-- Table structure for table `auth_item_child`
--

CREATE TABLE `auth_item_child` (
  `parent` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
  `child` varchar(64) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `auth_item_child`
--

INSERT INTO `auth_item_child` (`parent`, `child`) VALUES
('Super Admin', '/*'),
('Super Admin', '/admin/*'),
('Super Admin', '/admin/assignment/*'),
('Super Admin', '/admin/assignment/assign'),
('Super Admin', '/admin/assignment/index'),
('Super Admin', '/admin/assignment/revoke'),
('Super Admin', '/admin/assignment/view'),
('Super Admin', '/admin/default/*'),
('Super Admin', '/admin/default/index'),
('Super Admin', '/admin/menu/*'),
('Super Admin', '/admin/menu/create'),
('Super Admin', '/admin/menu/delete'),
('Super Admin', '/admin/menu/index'),
('Super Admin', '/admin/menu/update'),
('Super Admin', '/admin/menu/view'),
('Super Admin', '/admin/permission/*'),
('Super Admin', '/admin/permission/assign'),
('Super Admin', '/admin/permission/create'),
('Super Admin', '/admin/permission/delete'),
('Super Admin', '/admin/permission/index'),
('Super Admin', '/admin/permission/remove'),
('Super Admin', '/admin/permission/update'),
('Super Admin', '/admin/permission/view'),
('Super Admin', '/admin/role/*'),
('Super Admin', '/admin/role/assign'),
('Super Admin', '/admin/role/create'),
('Super Admin', '/admin/role/delete'),
('Super Admin', '/admin/role/index'),
('Super Admin', '/admin/role/remove'),
('Super Admin', '/admin/role/update'),
('Super Admin', '/admin/role/view'),
('Super Admin', '/admin/route/*'),
('Super Admin', '/admin/route/assign'),
('Super Admin', '/admin/route/create'),
('Super Admin', '/admin/route/index'),
('Super Admin', '/admin/route/refresh'),
('Super Admin', '/admin/route/remove'),
('Super Admin', '/admin/rule/*'),
('Super Admin', '/admin/rule/create'),
('Super Admin', '/admin/rule/delete'),
('Super Admin', '/admin/rule/index'),
('Super Admin', '/admin/rule/update'),
('Super Admin', '/admin/rule/view'),
('Super Admin', '/admin/user/*'),
('Super Admin', '/admin/user/activate'),
('Super Admin', '/admin/user/change-password'),
('Super Admin', '/admin/user/delete'),
('Super Admin', '/admin/user/index'),
('Super Admin', '/admin/user/login'),
('Super Admin', '/admin/user/logout'),
('Super Admin', '/admin/user/request-password-reset'),
('Super Admin', '/admin/user/reset-password'),
('Super Admin', '/admin/user/signup'),
('Super Admin', '/admin/user/view'),
('Super Admin', '/banner/*'),
('Super Admin', '/banner/create'),
('Super Admin', '/banner/delete'),
('Super Admin', '/banner/index'),
('Super Admin', '/banner/update'),
('Super Admin', '/banner/view'),
('Super Admin', '/categories/*'),
('Super Admin', '/categories/create'),
('Super Admin', '/categories/delete'),
('Super Admin', '/categories/index'),
('Super Admin', '/categories/update'),
('Super Admin', '/categories/view'),
('Super Admin', '/cms/*'),
('Super Admin', '/cms/create'),
('Super Admin', '/cms/delete'),
('Super Admin', '/cms/index'),
('Super Admin', '/cms/update'),
('Super Admin', '/cms/view'),
('Super Admin', '/dashboard/*'),
('Super Admin', '/dashboard/index'),
('Super Admin', '/dashboard/single-data'),
('Super Admin', '/debug/*'),
('Super Admin', '/debug/default/*'),
('Super Admin', '/debug/default/db-explain'),
('Super Admin', '/debug/default/download-mail'),
('Super Admin', '/debug/default/index'),
('Super Admin', '/debug/default/toolbar'),
('Super Admin', '/debug/default/view'),
('Super Admin', '/debug/user/*'),
('Super Admin', '/debug/user/reset-identity'),
('Super Admin', '/debug/user/set-identity'),
('Super Admin', '/feedback/*'),
('Super Admin', '/feedback/create'),
('Super Admin', '/feedback/delete'),
('Super Admin', '/feedback/index'),
('Super Admin', '/feedback/update'),
('Super Admin', '/feedback/view'),
('Super Admin', '/gii/*'),
('Super Admin', '/gii/default/*'),
('Super Admin', '/gii/default/action'),
('Super Admin', '/gii/default/diff'),
('Super Admin', '/gii/default/index'),
('Super Admin', '/gii/default/preview'),
('Super Admin', '/gii/default/view'),
('Super Admin', '/gridview/*'),
('Super Admin', '/gridview/export/*'),
('Super Admin', '/gridview/export/download'),
('Super Admin', '/news/*'),
('Super Admin', '/news/create'),
('Super Admin', '/news/delete'),
('Super Admin', '/news/index'),
('Super Admin', '/news/update'),
('Super Admin', '/news/view'),
('Super Admin', '/products/*'),
('Super Admin', '/products/create'),
('Super Admin', '/products/delete'),
('Super Admin', '/products/index'),
('Super Admin', '/products/update'),
('Super Admin', '/products/view'),
('Super Admin', '/site/*'),
('Super Admin', '/site/about'),
('Super Admin', '/site/captcha'),
('Super Admin', '/site/changelanguage'),
('Super Admin', '/site/contact'),
('Super Admin', '/site/contact-request'),
('Super Admin', '/site/error'),
('Super Admin', '/site/index'),
('Super Admin', '/site/login'),
('Super Admin', '/site/logout'),
('Super Admin', '/site/products'),
('Super Admin', '/site/test-mail'),
('Super Admin', '/suppliers/*'),
('Super Admin', '/suppliers/create'),
('Super Admin', '/suppliers/delete'),
('Super Admin', '/suppliers/index'),
('Super Admin', '/suppliers/update'),
('Super Admin', '/suppliers/view'),
('Super Admin', '/testimonial/*'),
('Super Admin', '/testimonial/create'),
('Super Admin', '/testimonial/delete'),
('Super Admin', '/testimonial/index'),
('Super Admin', '/testimonial/update'),
('Super Admin', '/testimonial/view'),
('Super Admin', '/uploads/*'),
('Super Admin', '/uploads/common'),
('Super Admin', '/uploads/filedelete'),
('Super Admin', '/uploads/mom-upload'),
('Super Admin', '/uploads/products-upload'),
('Super Admin', '/users/*'),
('Super Admin', '/users/create'),
('Super Admin', '/users/delete'),
('Super Admin', '/users/index'),
('Super Admin', '/users/update'),
('Super Admin', '/users/view');

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

--
-- Table structure for table `auth_rule`
--

CREATE TABLE `auth_rule` (
  `name` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
  `data` blob,
  `created_at` int(11) DEFAULT NULL,
  `updated_at` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `banner`
--

CREATE TABLE `banner` (
  `banner_id` int(255) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `description` text,
  `image` varchar(255) DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `is_published` int(1) DEFAULT '1',
  `is_delete` int(1) DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `banner`
--

INSERT INTO `banner` (`banner_id`, `title`, `description`, `image`, `url`, `is_published`, `is_delete`) VALUES
(4, 'Go Green Use Solar, Invert Solar with Sunvert', '', '15718188615db00d6d2aea30.33572008.jpg', '', 1, 0),
(5, 'Go Green Use Solar, Invert Solar with Sunvert', '', '15718188745db00d7a2e94c6.76911922.jpg', '', 1, 0),
(6, 'Go Green Use Solar, Invert Solar with Sunvert', '', '15718188875db00d87ec7344.32178042.jpg', '', 1, 0),
(7, 'Go Green Use Solar, Invert Solar with Sunvert', '', '15718188985db00d92b91003.24038635.jpg', '', 1, 0);

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

--
-- Table structure for table `migration`
--

CREATE TABLE `migration` (
  `version` varchar(180) NOT NULL,
  `apply_time` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `migration`
--

INSERT INTO `migration` (`version`, `apply_time`) VALUES
('m000000_000000_base', 1571817335),
('m140506_102106_rbac_init', 1571817341),
('m170907_052038_rbac_add_index_on_auth_assignment_user_id', 1571817341);

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

--
-- Table structure for table `partners`
--

CREATE TABLE `partners` (
  `partner_id` int(255) NOT NULL,
  `image` varchar(255) DEFAULT NULL,
  `link` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `partners`
--

INSERT INTO `partners` (`partner_id`, `image`, `link`) VALUES
(2, '15718334535db0466dbe6f50.86765996.png', ''),
(3, '15718334785db046867d33b2.32241629.png', ''),
(5, '15718335145db046aaef2ca2.08369122.png', ''),
(6, '15718335265db046b6b305f3.34216241.png', ''),
(7, '15718335445db046c8583263.82181848.png', ''),
(8, '15718335605db046d8c59062.33526952.png', ''),
(9, '15718335725db046e4bff440.98304562.png', ''),
(10, '15718335895db046f57e6b37.82111016.png', ''),
(11, '15718335995db046ff677139.27979885.png', ''),
(12, '15718336105db0470a56f770.08635768.png', ''),
(13, '15718336215db04715f07335.16389789.png', ''),
(14, '15718336465db0472ea01737.77208301.png', ''),
(15, '15718336615db0473d7931c7.63100086.png', '');

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

--
-- Table structure for table `products`
--

CREATE TABLE `products` (
  `product_id` int(255) NOT NULL,
  `product_type_id` int(255) NOT NULL,
  `brand_id` int(255) DEFAULT NULL,
  `product_model` varchar(255) DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `price` double DEFAULT '0',
  `gst` double DEFAULT '0',
  `image` varchar(255) DEFAULT 'product-default.png',
  `description` text,
  `is_deleted` int(1) NOT NULL DEFAULT '0',
  `created_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `products`
--

INSERT INTO `products` (`product_id`, `product_type_id`, `brand_id`, `product_model`, `name`, `price`, `gst`, `image`, `description`, `is_deleted`, `created_at`) VALUES
(1, 1, NULL, NULL, 'SOLAR PANEL OVERVIEW', NULL, NULL, '15718360945db050bed05054.94167153.jpg', '<p>Over the past few years, the price of solar panels has reduced considerably, with panels now priced anywhere between one hundred dollars up to five hundred dollars. Price is determined by the brand of the panel, the output of the panel (measured by Watts), physical size, material quality, and brand and warranty period.</p>\r\n<p>All panels installed by Sunvert energy have had undergone stringent testing at our factory and are on the Clean Energy Council (CEC) approved product list.&nbsp; We only use Tier One and Tier Two branded panels and our range includes Hanwha, Q Cells, Jinko, and Seraphim.</p>\r\n<p>There are two different types of panels that we offer &ndash; Mono-crystalline and Poly-crystalline &ndash; which we believe offer value, performance, and quality.</p>', 0, '2019-10-23 13:09:46'),
(2, 1, NULL, NULL, 'SOLAR PANEL TIRES', NULL, NULL, '15718923875db12ca315deb2.28511459.png', '<p style="text-align: left;">It is essential yet complicated to understand the terms &lsquo;Tier 1&rsquo; and &lsquo;Tier 2&rsquo; solar panels. A number of solar power salespeople are quick to drop these names but have little understanding of what they actually mean and more importantly, what it means to their customers. For a better understanding of the said terms, we need to dive a little deep into the history of it all. A few years ago, Germany was quick to pick up on solar technology and contemplated the future in this source of alternative power. In order to capture the majority of the European market, a number of German companies commenced their productions of solar energy panels. Just like any regular company, a solar company too needs finances and has to ensure a bank that they are worth investing into. This can be a challenge when the technology is relatively new and the knowledge of the same is limited or scarce amongst the financial institutions. To solve this, major banking and financial institutions of Germany came up with a set of benchmarks for the solar panel manufacturers. The said benchmarks were set at a very high standard of quality; nevertheless, the solar panel manufacturing companies met them in order to obtain the much-needed finances to run their business. The German banks referred to these successful companies as having &lsquo;bankability.&rsquo; The scaling of the benchmarks set by the German banks was on three levels. &lsquo;Tier 1&rsquo;, &lsquo;Tier 2&rsquo;, and &lsquo;Tier 3&rsquo;, wherein &lsquo;Tier 1&rsquo; was the highest level and was the only level that was able to be recognized by the German banks as laudable for any form of financial investment. Once the tier system was in place the benchmark system became a very helpful instrument for providing assurance to the consumer that the products they were buying were at a distinct level of quality. Here are the differences between the Tier 1 manufacture and the lower levels -Tier 1 manufactures of solar panels have to meet the following requirements:</p>\r\n<p style="text-align: left;">The manufacturing process is subject to very strict and regular audits The rigorous testing of the panels is done on recognized German manufactured equipment The manufacturer must be vertically integrated (i.e. they are involved in more than one value chain)&nbsp; There must be a demonstration of a large amount of leading-edge research and development. The company has been involved in at least 3 major projects of over 1.5 megawatts</p>\r\n<p style="text-align: left;">The production capacity of the manufacturer must be over 1 GigaWatt of power per year. The viewpoint following such soaring benchmarks is that the elevated volumes in production will affect intolerances in manufacturing eminence being very rigid and therefore giving the customer the reassurance of knowing they are buying the best solar panels in the world today. A Tier 2 manufacture is a much smaller company. The 3 main characteristics that define a Tier 2 manufacturer are:</p>\r\n<p style="text-align: left;">They invest in little if any research and development. The company relies on larger manufacturers to advance solar power technology.</p>\r\n<p style="text-align: left;">The only part of their manufacturing plant is robotic. Tier 1 manufacturers are almost completely robotic to ensure very high levels of consistency in quality. Tier 2 level manufacturers do not have this capability in their production.</p>\r\n<p style="text-align: left;">They have a track record of production of only 2 to 5 years. Tier 1 manufacturers are far more established.</p>\r\n<p style="text-align: left;">A Tier 3 is even smaller than the Tier 2 and has the following 4 main characteristics that define them:</p>\r\n<p style="text-align: left;">They have no research or development ability.</p>\r\n<p style="text-align: left;">They assemble the panels and have no ability to manufacture the silicon cells.</p>\r\n<p style="text-align: left;">Human production lines are utilized as they do not have any advanced robotics within their plant.</p>\r\n<p style="text-align: left;">The company has been in operation between 1 to 2 years.</p>\r\n<p style="text-align: left;">A word of advice, many companies claim they use Tier 1 panels but fail to state which manufacturer made them. It is always important to know who made the panels and they should be labelled with the name of the manufacturer.</p>\r\n<p style="text-align: left;">When you talk to Solar light energy we are proud to state the brand of panels we install because we only use Tier 1 quality for our customers. It is this commitment to quality that has made Solar light energy the number one installer in Australia.</p>', 0, '2019-10-23 13:11:29'),
(3, 2, NULL, NULL, 'OVERIVIEW', NULL, NULL, '', '<p>Solar light energy has established relationships with some of the world&rsquo;s best inverter manufacturers, meaning that you can get the benefits of the latest technology.</p>\r\n<p>Like our solar panels, all inverters that are installed by Solar light energy have undergone stringent in-house testing to ensure that they are suitable for Australian conditions. We only use inverters that are included on the Clean Energy Council (CEC) approved list. True Value Solar carries highly reputable branded inverters such as the award-winning Bosch inverter, premium brands such as SMA and ABB as well as GoodWe and Solax.</p>', 0, '2019-10-23 13:12:19'),
(4, 2, NULL, NULL, ' ABB', NULL, NULL, '15718364115db051fb4fd5e2.87721941.png', '<p>ABB solar inverters utilize over 40 years of experience and advances made in inverter and power converter technology that have contributed to ABB becoming one of the world leaders in frequency converters. In Australia, the history of ABB goes back to the late nineteenth century. Today, ABB has over 1,500 employees throughout operations in Sydney, Brisbane, Perth, Darwin, and Melbourne.</p>\r\n<p>Italian-made inverter<br />WiFi capabilities for monitoring solutions<br />Available in larger commercial sizes as well</p>', 0, '2019-10-23 13:13:50'),
(5, 2, NULL, NULL, 'BOSCH', NULL, NULL, '15718364485db05220bee553.12223781.png', '<p>Robert Bosch (Australia) Pty. Ltd is a regional subsidiary and part of the global Bosch Group. Bosch has had a presence in Australia since 1907, opening its first wholly owned subsidiary in 1954. BOSCH inverters are 100% engineered and manufactured in Germany and have recently won a Red Dot Design Award.</p>\r\n<p>Premium German inverter<br />Highly-efficient solar inverters<br />Maintenance-free cooling concept</p>', 0, '2019-10-23 13:14:28'),
(6, 2, NULL, NULL, 'FRONIUS', NULL, NULL, '15718364875db052473ff4f6.38630284.png', '<p>Robert Bosch (Australia) Pty. Ltd is a regional subsidiary and part of the global Bosch Group. Bosch has had a presence in Australia since 1907, opening its first wholly owned subsidiary in 1954. BOSCH inverters are 100% engineered and manufactured in Germany and have recently won a Red Dot Design Award.</p>\r\n<p>Premium German inverter<br />Highly-efficient solar inverters<br />Maintenance-free cooling concept</p>', 0, '2019-10-23 13:15:07'),
(7, 2, NULL, NULL, 'GOODWE', NULL, NULL, '15718365395db0527bb192d7.00985753.png', '<p>GOODWE</p>\r\n<p>Goodwe (Jiansu) Power Supply Technology Co. Ltd, is based in Suzhou, located in south eastern Jiangsu Province of East China however, all the industrial design is derived from German standards. Goodwe has been listed as one of the &ldquo;Top 10 Chinese Solar inverters&rdquo; by Shine magazine and have also been awarded a Double A rating in the strict Photon Test, ranking Top 2 among the residential models.</p>\r\n<p>Multiple awards</p>\r\n<p>Top manufacturer in China<br /><br /></p>', 0, '2019-10-23 13:16:00'),
(8, 2, NULL, NULL, ' SMA', NULL, NULL, '15718365855db052a9939665.30560976.png', '<p>Since 1981 SMA has been paving the way in solar inverter technology. SMA has over 5,000 employees in 21 countries and has its Australian headquarters in Sydney.</p>\r\n<p>In 2015 SMA was voted most preferred inverter brand by the IHS</p>\r\n<p>&nbsp;</p>\r\n<p>Premium German inverter<br />30gW of SMA power installed globally</p>', 0, '2019-10-23 13:16:36'),
(9, 2, NULL, NULL, 'SOLAX', NULL, NULL, '15718366135db052c5c9cf72.88190728.png', '<p>SolaX is an international brand, selling its products to over 20 countries worldwide. As a world leader in the development, production, and sale of high-quality inverters, SolaX is a company lead by innovation. SolaX is also a proud affiliate of Zheijang University, home to China&rsquo;s only national key silicon material laboratories, allowing SolaX to test and manufacture products at the highest global standards.</p>\r\n<p>Monitoring options available via Wi-Fi<br />Top ranking inverter in China</p>', 0, '2019-10-23 13:17:06'),
(10, 3, NULL, NULL, 'OVERIVIEW', NULL, NULL, '15718366475db052e7dad652.99853117.png', '<p>The Enphase system is based on 1.2kWh units which can be coupled together to create the solar storage system that is tailored to meet your lifestyle. The 1.2kW blocks allow you to start with just one battery and then add more later.</p>\r\n<p>The Enphase Storage System is:<br /><br />Simple<br />Modular<br />Safe<br /><br />The features are:<br />1.2kWh energy capacity, 270 VA<br />Weight: 25 kg<br />Depth of discharge:&gt; 95%<br />96% round trip efficiency for the battery cells<br />LFP* chemistry: Safety cerfified by TUV Rheinland<br />Warranty: &nbsp;10 years or 7,300 cycles<br />*Actual cycle depends on rate and dept of charge, and battery temperature//* Lithium Ferrous Phosphate// ** 1 cycle=1 full charge and 1 full discharge</p>', 0, '2019-10-23 13:17:40'),
(11, 4, NULL, NULL, 'OVERIVIEW', NULL, NULL, '15718366845db0530cd7dac1.85412937.png', '<p>Sunvert energy is proud to introduce Europe&rsquo;s leading energy storage system, sonnenBatterie.</p>\r\n<p>SonnenBatterie isn&rsquo;t just a battery; it&rsquo;s a fully integrated, high-tech storage system that has the capacity to automatically adjust our customers&rsquo; households energy usage.</p>\r\n<p>&nbsp;</p>\r\n<p>Fully compatible with the Bosch inverter, sonnenBatterie is the next step in the solar revolution, allowing you to store the power you generate rather than feed it back into the grid and also use the energy you generate anytime day or night. SonnenBatterie lets you gain independence from energy price increases and supply your home with clean, green energy derived straight from the solar panels on your roof.</p>\r\n<p>With a lifespan of over 10,000 cycles, the sonnenBatterie will ensure your family will be supplied with energy you have generated for years to come.</p>', 0, '2019-10-23 13:18:14'),
(12, 5, NULL, NULL, 'OVERIVIEW', NULL, NULL, '15718367305db0533aa1f320.34994924.png', '<p>Redback is an Australian company building high-tech infrastructure for the Australian market. They are committed to finding innovative methods to reduce our dependence on fossil fuels.</p>\r\n<p>The heart and brains of the system is Redback&rsquo;s 4.6kW inverter which mounts to their 2 x 2.4kWh Pylontech batteries. This unit provides peace of mind by producing a steady power supply in times of power failure from the grid. Redback&rsquo;s system is highly urbane, allowing the homeowner to configure and monitor their current energy output from their Smartphone. The homeowner is empowered through Redback&rsquo;s app to decide how much energy is stored, used or sold back to the grid.</p>\r\n<p>&nbsp;</p>\r\n<p>The Pylontech batteries have received great reviews, easily out-performing most of the current solar batteries on the market. For example, on a cost per kWh basis, the Pylontech is simply the best value for money against the major batteries available.</p>\r\n<p>Power is generated by the Tier 1 panels. These panels are a high-performance panel that is world-class, and is an ideal choice to be matched to the Redback system.</p>\r\n<p>If you need a complete solar power system with battery backup, talk to one of our solar specialists at Sunvert energy about becoming even more self-reliant for your power.</p>', 0, '2019-10-23 13:18:52'),
(13, 6, NULL, NULL, 'BOSH HOT WATER HEAT PUMP', NULL, NULL, '15718367515db0534f467972.28736630.png', '<h2 class="my-4"><span style="font-size: 14px;">The Bosch Compress 3000 air-to-water heat pump represents the very pinnacle of energy-efficient water heating innovation.</span></h2>\r\n<div class="row">\r\n<div class="col-md-8">\r\n<p>The heat pump is essentially a refrigerator in reverse. A refrigerator creates and distributes cool air while expelling the waste heat into the atmosphere.</p>\r\n<p>A heat pump works in the opposite manner, by creating and distributing heat into the stored water and expelling cooled air into the atmosphere around it.</p>\r\n<p>Using 65% less energy than conventional electric storage hot water systems, the Compress 3000 is a highly efficient device that transfers excess solar energy into thermal energy in the form of hot water.</p>\r\n</div>\r\n</div>\r\n<div class="row">\r\n<div class="col-md-8">\r\n<p>As the heat pump only requires 0.6 kW of input compared to a conventional system that requires 3.6 kW, the energy requirements can be more than covered by a domestic solar system. So the money you&rsquo;ll save on energy bills makes the Compress 3000 a great long-term investment.</p>\r\n<p>Features &amp; benefits:<br />Highly efficient heat pump &ndash; reduces energy consumption by up to 65%*<br />Eligible for generous government rebates<br />270L storage tank<br />Built-in smart controller with timer function and compatibility with PV Solar energy generation systems<br />Noise reduction mode<br />Designed for easy and low-cost install and servicing<br />The heat pump operates from -7&ordm;C to 40&ordm;C, delivering energy efficient hot water even in colder climates<br />We paid a visit to the lovely Sylvia whose Hot Water System stopped working.<br />She was in a panic without Hot Water. It was great to assist her with this dilemma.</p>\r\n<br />\r\n<p>Note: Heat pumps use the ambient temperature in surrounding air to heat water in the tank. This means as the air temperature around the tank decreases, the time taken to heat the full tank increases. Customers in colder climates and frost prone areas should consider this when deciding which type of Bosch system is best for their circumstances. *When compared to conventional electric storage system.</p>\r\n</div>\r\n</div>', 0, '2019-10-23 13:19:32'),
(14, 6, NULL, NULL, ' FAQ', NULL, NULL, '', '<ul>\r\n<li><strong>What is a hot water heat pump?</strong></li>\r\n</ul>\r\n<p>A heat pump hot water system is a type of solar hot water system but without panels needed on the roof. The unit utilises a refrigerant to absorb heat from the air and transfer this heat to create hot water. A heat pump works in a similar way to a refrigerator but in reverse.<br /><br /></p>\r\n<ul>\r\n<li><strong>Why choose a heat pump over a solar panel hot water system?</strong></li>\r\n</ul>\r\n<p>The running costs for a heat pump can be around the same or in some instances less than a solar panel system. A hot water heat pump is cheaper to install as there is no need to put the panels on the roof. If your roof is not facing the correct way or is obstructed by a tree, then a heat pump is the best option. Heat pumps work well in conjunction to PV systems as they don&rsquo;t compete for roof space, draw low amounts of energy (Max 700W) that would usually be fed back to the grid.</p>\r\n<p>&nbsp;</p>\r\n<ul>\r\n<li><strong>What is the warranty on the hot water heat pumps?</strong></li>\r\n</ul>\r\n<p>5 Years on the Tank. (Part only) 2 Years on the Parts and Labour.</p>\r\n<p>&nbsp;</p>\r\n<ul>\r\n<li><strong>Will the hot water heat pump provide me with enough hot water?</strong></li>\r\n</ul>\r\n<p>The unit is suitable for 3-4 people living in the house. The Bosch hot water heat pump can deliver 335 litres of 40&rsquo;c of shower temperature water on one single draw when the appliance is set to 56oC.</p>\r\n<p>&nbsp;</p>\r\n<ul>\r\n<li><strong>How noisy is the hot water heat pump?</strong></li>\r\n</ul>\r\n<p>The hot water heat pump sound that is heard is from the compressor and the fan which is 43dB as measured from 2meters away. Plus, the unit has a noise reduction mode to assist if needed.</p>\r\n<p>&nbsp;</p>\r\n<ul>\r\n<li><strong>Will the hot water heat pump work with solar PV systems?</strong></li>\r\n</ul>\r\n<p>Yes, the heat pump has been designed to work in conjunction with PV solar systems. The heat pump can be programmed to run during the hours of the day when PV generated energy is available, using the excess energy.</p>\r\n<p>The heat pump can also be set up to have a direct communication link to compatible inverters that are designed to work with &lsquo;smart grid ready&rsquo; appliances. The heat pump can receive a communication signal from the inverter or energy management system telling the appliance that excess energy is available. If the water held inside the heat pump requires further heating, the heat pump will then run until the appliance is fully heated.</p>\r\n<p>&nbsp;</p>\r\n<ul>\r\n<li><strong>How much of a household&rsquo;s energy is used for water heating?</strong></li>\r\n</ul>\r\n<p>In Australia, on average around 40%of a household&rsquo;s energy is used on heating hot water. Installing a Bosch heat pump with a PV system will allow the owner to reduce their energy use considerably, and give a good increase on self-consumption of PV generated energy.</p>\r\n<p>&nbsp;</p>\r\n<ul>\r\n<li><strong>How much power does the heat pump draw?</strong></li>\r\n</ul>\r\n<p>Under normal operation the heat pump will draw up to 600W (2.6 amps) and 2.25kW (9.8 amps) when the back-up element is activated. The back-up element is only activated in very cold ambient air temperatures (usually only below an ambient temperature od 0oC).</p>\r\n<p>&nbsp;</p>\r\n<ul>\r\n<li><strong>Can the hot water heat pump be installed indoors?</strong></li>\r\n</ul>\r\n<p>Yes, as long as the Shed/Carport is 22.5m3 clear space with airflow from outside.</p>\r\n<p>&nbsp;</p>\r\n<ul>\r\n<li><strong>If the air temperature is 0oC will the heat pump still produce hot water?</strong></li>\r\n</ul>\r\n<p>Yes, the heat pump has an element in the unit 1.6kw element, the heat pump operates from -7oC to 40oC delivering energy efficient hot water.</p>\r\n<p>Eligible for the government rebates STCs (small scale technology certificates) and VEECs (Victorian Energy Efficiency Target Certificates)?</p>\r\n<p>Yes, they could get STCs for any new installation.<br />STCs<br />Zone 1 &ndash; 23 STCs<br />Zone 2 &ndash; 23 STCs<br />Zone 3 &ndash; 27 STCs<br />Zone 4 &ndash; 29 STCs<br />Zone 5 &ndash; 27 STCs<br />VEECs<br />Metro &ndash; 41 VEECs<br />Regional &ndash; 44 VEECs<br />If replacing an electric storage water heater in VIC they are eligible for both STCs and VEECs.</p>\r\n<p>How efficient is the heat pump compared to a standard electric unit?</p>\r\n<p>The Bosch hot water heat pump reduces energy use by up to 65% compared to a conventional electric storage hot water heat pump, in Zone 3.</p>\r\n<p>&nbsp;</p>\r\n<ul>\r\n<li><strong>Can the hot water heat pup be transported lying down on its side?</strong></li>\r\n</ul>\r\n<p>Yes, the unit can be transported lying down on its side but before turning it on it needs to be sitting up right for at least 30mins.</p>\r\n<p>&nbsp;</p>\r\n<ul>\r\n<li><strong>What is the weight of the hot water heat pump?</strong></li>\r\n</ul>\r\n<p>The weight of the unit empty is 130kg.</p>\r\n<p>What is the height and width of the unit?</p>\r\n<p>Height &ndash; 1840mm<br />Width &ndash; 670mm</p>\r\n<p>&nbsp;</p>\r\n<ul>\r\n<li><strong>What is the refrigeration used in the compressor?</strong></li>\r\n</ul>\r\n<p>R134a</p>\r\n<p>&nbsp;</p>\r\n<ul>\r\n<li><strong>Where is the Bosch heat pump unit made?</strong></li>\r\n</ul>\r\n<p>The heat pump is engineered and manufactured in Europe out of Bosch&rsquo;s hot water factory in Portugal.</p>', 0, '2019-10-23 13:20:14'),
(15, 7, NULL, NULL, 'OVERIVIEW', NULL, NULL, '15718368335db053a18d9de0.79131029.png', '<p>Monitor the health of your system and track energy consumption</p>\r\n<p>The carbonTRACK system empowers you to take control of their electricity and start optimizing the energy you generate. This is achieved with the use of carbonTRACK&rsquo;s ability to let you know key aspects of your solar power system.</p>\r\n<p>The diagram in figure I represents the Solar Bell Curve. As you can see most energy/power demand occurs at the start of the day when people are having breakfast, getting ready for work and at the end of the day when dinner is made, lights and heaters are turned on. In contrast, the majority of solar power generation happens around the middle of the day, as seen in the bell curve below. Using carbonTRACK will help you identify your energy usage patterns throughout the day, giving you the insights you need to reduce energy waste, change your behavior or set your devices to run at more opportune times &ndash; such as when the sun is shining.</p>\r\n<p>For example the chart in figure 2 shows you your solar generation (line in yellow), while the blue line represents your home&rsquo;s electricity consumption. You will notice that the solar generation is at it&rsquo;s peak at 12pm, here your dishwasher could be programmed, start your washing during this time and do vacuuming. Also at 2.30pm, you may want to turn on the heater to cooler to change the temperature of you home to ensure it is perfect for the nigh time.</p>\r\n<p>Figure 3 shows another example of the online portal is a more detailed view of electricity flows for the same day as in the image above &ndash; you can see when solar is being self-consumed (purple line) vs when it is being exported to the grid (green line). (Screenshot from the carbonTRACK portal)</p>', 0, '2019-10-23 13:20:41');

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

--
-- Table structure for table `product_type`
--

CREATE TABLE `product_type` (
  `product_type_id` int(255) NOT NULL,
  `name` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `product_type`
--

INSERT INTO `product_type` (`product_type_id`, `name`) VALUES
(1, 'SOLAR PV PANEL'),
(2, 'SOLAR INVERTERS'),
(3, 'ENPHASE BATTERY STORGE'),
(4, 'SONNENBATTERING BATTERY STORGE'),
(5, 'REDBACK BATTERY STORGE'),
(6, 'BOSH HOT WATER HEAT PUMP'),
(7, 'SMART SOLAR MONITORING');

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

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `user_id` int(255) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `profile_pic` varchar(255) DEFAULT NULL,
  `username` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `is_deleted` int(1) DEFAULT '0',
  `created_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`user_id`, `name`, `email`, `profile_pic`, `username`, `password`, `is_deleted`, `created_at`) VALUES
(1, 'Himanshu', 'admin@sunvertenergy.com.au', NULL, 'admin', '$2y$13$SwPRW8Xo/FN1KP5uPH28gO3r2MAy3mRoPgsjn.BvljEXjf6WYUwje', 0, '2019-10-23 02:05:05');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `auth_assignment`
--
ALTER TABLE `auth_assignment`
  ADD PRIMARY KEY (`item_name`,`user_id`),
  ADD KEY `auth_assignment_user_id_idx` (`user_id`);

--
-- Indexes for table `auth_item`
--
ALTER TABLE `auth_item`
  ADD PRIMARY KEY (`name`),
  ADD KEY `rule_name` (`rule_name`),
  ADD KEY `idx-auth_item-type` (`type`);

--
-- Indexes for table `auth_item_child`
--
ALTER TABLE `auth_item_child`
  ADD PRIMARY KEY (`parent`,`child`),
  ADD KEY `child` (`child`);

--
-- Indexes for table `auth_rule`
--
ALTER TABLE `auth_rule`
  ADD PRIMARY KEY (`name`);

--
-- Indexes for table `banner`
--
ALTER TABLE `banner`
  ADD PRIMARY KEY (`banner_id`);

--
-- Indexes for table `migration`
--
ALTER TABLE `migration`
  ADD PRIMARY KEY (`version`);

--
-- Indexes for table `partners`
--
ALTER TABLE `partners`
  ADD PRIMARY KEY (`partner_id`);

--
-- Indexes for table `products`
--
ALTER TABLE `products`
  ADD PRIMARY KEY (`product_id`);

--
-- Indexes for table `product_type`
--
ALTER TABLE `product_type`
  ADD PRIMARY KEY (`product_type_id`);

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`user_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `banner`
--
ALTER TABLE `banner`
  MODIFY `banner_id` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
--
-- AUTO_INCREMENT for table `partners`
--
ALTER TABLE `partners`
  MODIFY `partner_id` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;
--
-- AUTO_INCREMENT for table `products`
--
ALTER TABLE `products`
  MODIFY `product_id` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;
--
-- AUTO_INCREMENT for table `product_type`
--
ALTER TABLE `product_type`
  MODIFY `product_type_id` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `user_id` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- Constraints for dumped tables
--

--
-- Constraints for table `auth_assignment`
--
ALTER TABLE `auth_assignment`
  ADD CONSTRAINT `auth_assignment_ibfk_1` FOREIGN KEY (`item_name`) REFERENCES `auth_item` (`name`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `auth_item`
--
ALTER TABLE `auth_item`
  ADD CONSTRAINT `auth_item_ibfk_1` FOREIGN KEY (`rule_name`) REFERENCES `auth_rule` (`name`) ON DELETE SET NULL ON UPDATE CASCADE;

--
-- Constraints for table `auth_item_child`
--
ALTER TABLE `auth_item_child`
  ADD CONSTRAINT `auth_item_child_ibfk_1` FOREIGN KEY (`parent`) REFERENCES `auth_item` (`name`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `auth_item_child_ibfk_2` FOREIGN KEY (`child`) REFERENCES `auth_item` (`name`) ON DELETE CASCADE ON UPDATE CASCADE;

