D7net
Home
Console
Upload
information
Create File
Create Folder
About
Tools
:
/
home2
/
technoi4
/
public_html
/
Filename :
himalayancapital_capital.sql
back
Copy
-- phpMyAdmin SQL Dump -- version 5.1.1 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: May 16, 2023 at 01:48 PM -- Server version: 10.4.22-MariaDB -- PHP Version: 7.4.27 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `himalayancapital_capital` -- -- -------------------------------------------------------- -- -- Table structure for table `brand` -- CREATE TABLE `brand` ( `id` int(11) NOT NULL, `brand_name` varchar(255) NOT NULL, `cid` varchar(255) NOT NULL, `brand_desc` text NOT NULL, `image` varchar(255) NOT NULL, `created_on` timestamp NOT NULL DEFAULT current_timestamp(), `is_deleted` tinyint(1) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `brand` -- INSERT INTO `brand` (`id`, `brand_name`, `cid`, `brand_desc`, `image`, `created_on`, `is_deleted`) VALUES (1, 'Polymelt Germany', '1', '<p>HIiiiiiiiiiii</p>', 'SAN95728000000-300x400.jpg', '2023-05-16 08:33:09', 0), (2, 'Polymelt Germany', '2', '<p>Hiiiiiiiiiiiii</p>', 'SAN58933000000-300x400.jpg', '2023-05-16 08:33:27', 0), (3, 'Polymelt Germany', '3', '<p>Hiiiiiiiiiiiii</p>', 'SAN1725700T000-300x400.jpg', '2023-05-16 08:33:45', 0), (4, 'PoloKAL NG, Austria', '4', '<p>Hiiiiiiiiiiiiiiii</p>', 'SAN9072100T000-300x400.jpg', '2023-05-16 08:34:06', 0); -- -------------------------------------------------------- -- -- Table structure for table `categary` -- CREATE TABLE `categary` ( `id` int(11) NOT NULL, `categary_title` varchar(255) NOT NULL, `desc` text NOT NULL, `image` varchar(255) NOT NULL, `createdon` timestamp NOT NULL DEFAULT current_timestamp(), `is_deleted` tinyint(1) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `categary` -- INSERT INTO `categary` (`id`, `categary_title`, `desc`, `image`, `createdon`, `is_deleted`) VALUES (1, 'PPR Pipe System for Hot & Potable Water', '<p>Yes, I am interested in receiving newsletters which have information of recent products and offers .</p>', 'SAN95725000000-300x400.jpg', '2023-05-16 07:43:15', 0), (2, 'UV Resistant Piping System', '<p>Hiiiiiiiiiiii</p>', 'SAN58997000000-300x400.jpg', '2023-05-16 07:43:40', 0), (3, 'Mechanical PPR Pipe System for HVAC', '<p>Hiiiiiiiiiiiiiii</p>', 'SAN58933000000-300x400.jpg', '2023-05-16 07:44:12', 0), (4, 'Sound Insulated Pipe & Fittings', '<p>Hiiiiiiiiiiiiiii</p>', 'SAN9072100T000-300x400.jpg', '2023-05-16 07:44:48', 0); -- -------------------------------------------------------- -- -- Table structure for table `image` -- CREATE TABLE `image` ( `id` int(11) NOT NULL, `first_name` varchar(255) NOT NULL, `last_name` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `user_name` varchar(255) NOT NULL, `mobile` varchar(255) NOT NULL, `image` varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -------------------------------------------------------- -- -- Table structure for table `media` -- CREATE TABLE `media` ( `id` bigint(20) UNSIGNED NOT NULL, `media_name` varchar(255) NOT NULL, `media_desc` varchar(160) NOT NULL, `image` varchar(255) NOT NULL, `created_on` timestamp NOT NULL DEFAULT current_timestamp(), `is_deleted` tinyint(1) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `media` -- INSERT INTO `media` (`id`, `media_name`, `media_desc`, `image`, `created_on`, `is_deleted`) VALUES (1, 'Hello', '<p>Hhueeeeeeeeee</p>', 'Screenshot 2023-05-15 143405.png', '2023-05-15 09:19:31', 0); -- -------------------------------------------------------- -- -- Table structure for table `pdf_image` -- CREATE TABLE `pdf_image` ( `id` int(11) NOT NULL, `pid` int(11) NOT NULL, `image` varchar(255) NOT NULL, `created_on` timestamp NOT NULL DEFAULT current_timestamp(), `is_deleted` tinyint(1) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `pdf_image` -- INSERT INTO `pdf_image` (`id`, `pid`, `image`, `created_on`, `is_deleted`) VALUES (2, 1, 'SEO Proposal.pdf', '2023-05-16 10:35:23', 0), (3, 1, 'PUC.pdf', '2023-05-16 10:35:23', 0); -- -------------------------------------------------------- -- -- Table structure for table `product` -- CREATE TABLE `product` ( `pid` int(11) NOT NULL, `cid` int(11) NOT NULL, `bid` int(11) NOT NULL, `product_name` varchar(255) NOT NULL, `product_desc` text NOT NULL, `image` varchar(255) NOT NULL, `created_on` timestamp NOT NULL DEFAULT current_timestamp(), `is_deleted` tinyint(1) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `product` -- INSERT INTO `product` (`pid`, `cid`, `bid`, `product_name`, `product_desc`, `image`, `created_on`, `is_deleted`) VALUES (1, 1, 1, 'Screwdriver Bit', '<p>Yes, I am interested in receiving newsletters which have information of recent products and offers . </p>', 'SAN90804000000-300x400.jpg', '2023-05-16 09:19:23', 0); -- -------------------------------------------------------- -- -- Table structure for table `product_image` -- CREATE TABLE `product_image` ( `id` int(11) NOT NULL, `pid` int(11) NOT NULL, `image` varchar(255) NOT NULL, `created_on` timestamp NOT NULL DEFAULT current_timestamp(), `is_deleted` tinyint(1) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `product_image` -- INSERT INTO `product_image` (`id`, `pid`, `image`, `created_on`, `is_deleted`) VALUES (1, 1, '1.jpg', '2023-05-16 10:24:01', 0), (2, 1, '2.jpg', '2023-05-16 10:24:01', 0), (3, 1, '3.jpg', '2023-05-16 10:24:01', 0), (4, 1, '4.jpg', '2023-05-16 10:24:01', 0); -- -------------------------------------------------------- -- -- Table structure for table `service` -- CREATE TABLE `service` ( `id` bigint(20) UNSIGNED NOT NULL, `service_name` varchar(255) NOT NULL, `service_desc` varchar(160) NOT NULL, `image` varchar(255) NOT NULL, `created_on` timestamp NOT NULL DEFAULT current_timestamp(), `is_deleted` tinyint(1) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `service` -- INSERT INTO `service` (`id`, `service_name`, `service_desc`, `image`, `created_on`, `is_deleted`) VALUES (3, 'Service_1', 'You have ideas, goals, and dreams. We have a culturally diverse, forward thinking team looking for talent like. Lorem ipsum dolor suscipit.', 'service1.jpg', '2023-05-11 03:47:40', 0), (4, 'Service_2', 'You have ideas, goals, and dreams. We have a culturally diverse, forward thinking team looking for talent like. Lorem ipsum dolor suscipit.', '', '2023-05-11 03:47:40', 0), (5, 'Service_3', 'You have ideas, goals, and dreams. We have a culturally diverse, forward thinking team looking for talent like. Lorem ipsum dolor suscipit.', 'service1.jpg', '2023-05-11 03:47:40', 0), (6, 'Service_4', 'You have ideas, goals, and dreams. We have a culturally diverse, forward thinking team looking for talent like. Lorem ipsum dolor suscipit.', '', '2023-05-11 03:47:40', 0), (7, 'Service_5', 'You have ideas, goals, and dreams. We have a culturally diverse, forward thinking team looking for talent like. Lorem ipsum dolor suscipit.', 'service1.jpg', '2023-05-11 03:47:40', 0), (8, 'Service_6', 'You have ideas, goals, and dreams. We have a culturally diverse, forward thinking team looking for talent like. Lorem ipsum dolor suscipit.', '', '2023-05-11 03:47:40', 0), (9, 'Service_7', 'You have ideas, goals, and dreams. We have a culturally diverse, forward thinking team looking for talent like. Lorem ipsum dolor suscipit.', 'service1.jpg', '2023-05-11 03:47:40', 0), (10, 'Service_8', 'You have ideas, goals, and dreams. We have a culturally diverse, forward thinking team looking for talent like. Lorem ipsum dolor suscipit.', '', '2023-05-11 03:47:40', 0), (11, 'Service_9', 'You have ideas, goals, and dreams. We have a culturally diverse, forward thinking team looking for talent like. Lorem ipsum dolor suscipit.', 'service1.jpg', '2023-05-11 03:47:40', 0), (18, 'Service_10', 'You have ideas, goals, and dreams. We have a culturally diverse, forward thinking team looking for talent like. Lorem ipsum dolor suscipit.', '', '2023-05-11 04:41:42', 0), (19, 'Service_11', 'You have ideas, goals, and dreams. We have a culturally diverse, forward thinking team looking for talent like. Lorem ipsum dolor suscipit.', 'service1.jpg', '2023-05-11 08:28:42', 0), (20, 'Service_12', 'You have ideas, goals, and dreams. We have a culturally diverse, forward thinking team looking for talent like. Lorem ipsum dolor suscipit.', '', '2023-05-11 08:28:59', 0); -- -------------------------------------------------------- -- -- Table structure for table `testimonials` -- CREATE TABLE `testimonials` ( `id` int(11) NOT NULL, `cilentname` varchar(255) NOT NULL, `designation` varchar(255) NOT NULL, `message` text NOT NULL, `image` varchar(255) NOT NULL, `created_on` timestamp NOT NULL DEFAULT current_timestamp(), `is_deleted` tinyint(1) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `testimonials` -- INSERT INTO `testimonials` (`id`, `cilentname`, `designation`, `message`, `image`, `created_on`, `is_deleted`) VALUES (4, 'Gabriel Denis', 'Chairman, OKT', 'Question ran over her cheek When she reached the first hills of the Italic Mountains, she had a last view back on the skyline of her hometown Bookmarksgrove, the headline of Alphabet Village and the subline of her own road.', '', '2023-05-12 02:06:18', 0), (5, 'Weldon Cash', 'CFO, First Choice', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor inci done idunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitoa tion ullamco laboris nisi aliquip consequat.', 'testimonial2.png', '2023-05-12 02:09:14', 0), (6, 'Minter Puchan', 'Director, AKT', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor inci done idunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitoa tion ullamco laborisnisi ut commodo consequat.', '', '2023-05-12 02:10:20', 0); -- -------------------------------------------------------- -- -- Table structure for table `user` -- CREATE TABLE `user` ( `u_id` int(11) NOT NULL, `first_name` varchar(255) NOT NULL, `last_name` varchar(255) NOT NULL, `country` varchar(255) NOT NULL, `mobile_no` varchar(255) NOT NULL, `address` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `email_verification_link` varchar(255) NOT NULL, `email_verified_at` datetime DEFAULT NULL, `password` varchar(255) DEFAULT NULL, `reset_link_token` varchar(255) DEFAULT NULL, `exp_date` datetime DEFAULT NULL, `image` varchar(255) DEFAULT NULL, `profile_image` varchar(255) DEFAULT NULL, `user_type` int(11) NOT NULL COMMENT 'admin-0,user-1', `status` tinyint(1) DEFAULT NULL COMMENT 'active-1,inactive-2' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `user` -- INSERT INTO `user` (`u_id`, `first_name`, `last_name`, `country`, `mobile_no`, `address`, `email`, `email_verification_link`, `email_verified_at`, `password`, `reset_link_token`, `exp_date`, `image`, `profile_image`, `user_type`, `status`) VALUES (1, 'Admin', 'Admin', 'United Kingdom', '+44 7361625706', 'Kemp House 160 City Road London - United Kingdom EC1V 2NX', 'admin@admin.com', '', NULL, '@dmin@123', NULL, NULL, NULL, 'himalayan_broking.jpg', 0, 1); -- -- Indexes for dumped tables -- -- -- Indexes for table `brand` -- ALTER TABLE `brand` ADD PRIMARY KEY (`id`); -- -- Indexes for table `categary` -- ALTER TABLE `categary` ADD PRIMARY KEY (`id`); -- -- Indexes for table `image` -- ALTER TABLE `image` ADD PRIMARY KEY (`id`); -- -- Indexes for table `media` -- ALTER TABLE `media` ADD PRIMARY KEY (`id`); -- -- Indexes for table `pdf_image` -- ALTER TABLE `pdf_image` ADD PRIMARY KEY (`id`); -- -- Indexes for table `product` -- ALTER TABLE `product` ADD PRIMARY KEY (`pid`); -- -- Indexes for table `product_image` -- ALTER TABLE `product_image` ADD PRIMARY KEY (`id`); -- -- Indexes for table `service` -- ALTER TABLE `service` ADD UNIQUE KEY `id` (`id`); -- -- Indexes for table `testimonials` -- ALTER TABLE `testimonials` ADD PRIMARY KEY (`id`); -- -- Indexes for table `user` -- ALTER TABLE `user` ADD PRIMARY KEY (`u_id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `brand` -- ALTER TABLE `brand` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `categary` -- ALTER TABLE `categary` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `image` -- ALTER TABLE `image` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `media` -- ALTER TABLE `media` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `pdf_image` -- ALTER TABLE `pdf_image` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `product` -- ALTER TABLE `product` MODIFY `pid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `product_image` -- ALTER TABLE `product_image` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `service` -- ALTER TABLE `service` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21; -- -- AUTO_INCREMENT for table `testimonials` -- ALTER TABLE `testimonials` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; -- -- AUTO_INCREMENT for table `user` -- ALTER TABLE `user` MODIFY `u_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9; COMMIT; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;