| Server IP : 108.170.25.35 / Your IP : 3.140.198.3 Web Server : Apache/2 System : Linux gains.winzonesoftech.com 4.18.0-513.24.1.el8_9.x86_64 #1 SMP Mon Apr 8 11:23:13 EDT 2024 x86_64 User : sbags ( 1569) PHP Version : 8.1.28 Disable Function : exec,system,passthru,shell_exec,proc_close,proc_open,dl,popen,show_source,posix_kill,posix_mkfifo,posix_getpwuid,posix_setpgid,posix_setsid,posix_setuid,posix_setgid,posix_seteuid,posix_setegid,posix_uname MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /home/sbags/domains/sbagsandgifts.com/public_html/database/ |
Upload File : |
-- phpMyAdmin SQL Dump -- version 5.2.0 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: Jan 10, 2023 at 06:25 PM -- Server version: 10.4.25-MariaDB -- PHP Version: 8.1.10 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: `sbags` -- -- -------------------------------------------------------- -- -- Table structure for table `newarrivals` -- CREATE TABLE `newarrivals` ( `id` int(219) NOT NULL, `image` varchar(500) NOT NULL, `title` varchar(420) NOT NULL, `cid` varchar(366) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `newarrivals` -- INSERT INTO `newarrivals` (`id`, `image`, `title`, `cid`) VALUES (1, 'img/ladieshadbags.png', 'Hand Bags', '1'), (2, 'img/wallclock3.png', 'Wall Clock', '2'), (3, 'img/blackrexinebag.png', 'Rexine Bag', '3'), (4, 'img/brownrexine.png', 'Rexine Bag', '3'), (5, 'img/greenrexine.png', 'Rexine Bag', '3'), (6, 'img/redrexinebag.png', 'Rexine Bag', '3'), (7, 'img/wallets.png', 'Wallets', '4'), (8, 'img/exampad3.png', 'Exam Pad', '5'), (9, 'img/pen.png', 'Pen', '6'), (10, 'img/travelbag33.png', 'Travel Bag', '7'), (11, 'img/customizedgifts.png', 'Customizes Gifts', '8'), (12, 'img/exampad2.png', ' Memo Pad ', '9'), (13, 'img/exampad3.png', ' Memo Pad ', '9'), (16, 'img/rexinebag4.png', 'Jute Bag', '10'); -- -------------------------------------------------------- -- -- Table structure for table `newarrivalscategory` -- CREATE TABLE `newarrivalscategory` ( `id` int(219) NOT NULL, `image` varchar(500) NOT NULL, `category` varchar(356) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `newarrivalscategory` -- INSERT INTO `newarrivalscategory` (`id`, `image`, `category`) VALUES (1, 'img/handbagsforgirls.png', 'Hand Bags'), (2, 'img/wallclock3.png', 'Wall Clock'), (7, 'img/travelbag.png', 'Travel Bags'), (8, 'img/customizedgifts.png', 'Customized Gifts'), (9, 'img/exampad3.png', ' Memo Pad '), (10, 'img/rexinebag4.png', 'Jute Bag'); -- -------------------------------------------------------- -- -- Table structure for table `products` -- CREATE TABLE `products` ( `id` int(219) NOT NULL, `image` varchar(500) NOT NULL, `title` varchar(375) NOT NULL, `cid` varchar(366) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `products` -- INSERT INTO `products` (`id`, `image`, `title`, `cid`) VALUES (1, 'img/handbag.png', 'Hand Bags', '1'), (2, 'img/handbagsforgirls.png', 'Hand Bags', '1'), (3, 'img/redrexine.png', 'Rexine Bag', '9'), (4, 'img/rexinebag2.png', 'Rexine Bag', '9'), (5, 'img/rexinebag3.png', 'Rexine Bag', '9'), (6, 'img/rexinebag4.png', 'Rexine Bag', '9'), (8, 'img/flowerrexine.png', 'Rexine Bag', '9'), (9, 'img/travelbag.png', 'Travel Bag', '10'), (10, 'img/wallclock.png', 'Wall Clock', '2'), (11, 'img/wallclock3.png', 'Wall Clock', '2'), (13, 'img/whiterexine.png', ' Rexine Bag', '9'), (15, 'img/exampad.png', 'Exam Pad', '5'), (16, 'img/exampad2.png', 'Exam Pad', '5'), (17, 'img/exampad3.png', 'Exam Pad', '5'), (18, 'img/wallet.png', 'Wallets', '6'), (19, 'img/wallets.png', 'Wallets', '6'), (21, 'img/calendargifts.png', 'Calendar Gifts', '7'), (22, 'img/leatherkeychain2.png', 'Leather Keychain', '8'), (23, 'img/metalkeychain.png', 'Metal Keychain', '8'), (25, 'img/blackrexinebag.png', 'Rexine Bag', '12'), (27, 'img/redraxinebag.png', 'Rexine Bag', '12'), (29, 'img/redrexinebag.png', 'Rexine Bag', '12'), (30, 'img/rexinebag2.png', 'Rexine Bag', '12'), (31, 'img/rexinebag3.png', 'Rexine Bag', '12'), (34, 'img/whiterexine.png', 'Rexine Bag', '12'), (35, 'img/exampad2.png', 'Memo Pad', '13'), (36, 'img/exampad3.png', 'Memo Pad', '13'); -- -------------------------------------------------------- -- -- Table structure for table `productscategory` -- CREATE TABLE `productscategory` ( `id` int(219) NOT NULL, `image` varchar(500) NOT NULL, `category` varchar(354) NOT NULL, `title` varchar(366) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `productscategory` -- INSERT INTO `productscategory` (`id`, `image`, `category`, `title`) VALUES (1, 'img/handbag.png', 'Hand Bags', ''), (2, 'img/wallclockprimg.png', 'Wall Clock', ''), (6, 'img/wallets.png', 'Wallets', ''), (7, 'img/calendargifts.png', 'Calendar Gifts', ''), (8, 'img/keychains.png', 'Keychains', ''), (10, 'img/travelbag.png', 'Travel Bag', ''), (12, 'img/redraxinebag.png', 'Rexine Bag', ''), (13, 'img/exampad.png', 'Memo Pad ', ''); -- -------------------------------------------------------- -- -- Table structure for table `user` -- CREATE TABLE `user` ( `id` int(219) NOT NULL, `username` varchar(378) NOT NULL, `password` varchar(499) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `user` -- INSERT INTO `user` (`id`, `username`, `password`) VALUES (1, 'admin', '21232f297a57a5a743894a0e4a801fc3'); -- -- Indexes for dumped tables -- -- -- Indexes for table `newarrivals` -- ALTER TABLE `newarrivals` ADD PRIMARY KEY (`id`); -- -- Indexes for table `newarrivalscategory` -- ALTER TABLE `newarrivalscategory` ADD PRIMARY KEY (`id`); -- -- Indexes for table `products` -- ALTER TABLE `products` ADD PRIMARY KEY (`id`); -- -- Indexes for table `productscategory` -- ALTER TABLE `productscategory` ADD PRIMARY KEY (`id`); -- -- Indexes for table `user` -- ALTER TABLE `user` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `newarrivals` -- ALTER TABLE `newarrivals` MODIFY `id` int(219) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17; -- -- AUTO_INCREMENT for table `newarrivalscategory` -- ALTER TABLE `newarrivalscategory` MODIFY `id` int(219) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11; -- -- AUTO_INCREMENT for table `products` -- ALTER TABLE `products` MODIFY `id` int(219) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=37; -- -- AUTO_INCREMENT for table `productscategory` -- ALTER TABLE `productscategory` MODIFY `id` int(219) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14; -- -- AUTO_INCREMENT for table `user` -- ALTER TABLE `user` MODIFY `id` int(219) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; 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 */;