| Server IP : 142.132.252.48 / Your IP : 216.73.216.255 Web Server : LiteSpeed System : Linux panel555.harmondns.net 4.18.0-553.22.1.lve.1.el8.x86_64 #1 SMP Tue Oct 8 15:52:54 UTC 2024 x86_64 User : nmgsjour ( 1446) PHP Version : 7.4.33 Disable Function : mail, show_source, system, shell_exec, passthru, exec MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : OFF | Pkexec : OFF Directory : /home/nmgsjour/.trash/ |
Upload File : |
-- phpMyAdmin SQL Dump -- version 5.0.2 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: Dec 14, 2023 at 05:00 AM -- Server version: 10.4.13-MariaDB -- PHP Version: 7.4.8 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: `store` -- -- -------------------------------------------------------- -- -- Table structure for table `branches` -- CREATE TABLE `branches` ( `id` int(11) NOT NULL, `companyid` int(10) NOT NULL, `branch` varchar(100) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `branches` -- INSERT INTO `branches` (`id`, `companyid`, `branch`) VALUES (1, 2, 'Lagos Island'), (2, 2, 'NTA road, Port Harcourt'), (3, 0, 'Mile 4 Port Harcourt'), (4, 7, 'Benin city'), (5, 2, 'Ogbogoro Lanes'), (6, 2, 'Ahoada East'); -- -------------------------------------------------------- -- -- Table structure for table `companies` -- CREATE TABLE `companies` ( `id` int(11) NOT NULL, `owernerid` int(100) NOT NULL, `owner_email` varchar(70) NOT NULL, `company_name` varchar(100) NOT NULL, `company_link` varchar(30) NOT NULL, `company_logo` varchar(150) NOT NULL, `company_overview` varchar(200) NOT NULL, `company_address` varchar(200) NOT NULL, `company_phone` varchar(30) NOT NULL, `company_email` varchar(30) NOT NULL, `company_service` varchar(30) NOT NULL, `subscription_expiration` varchar(30) NOT NULL, `created_at` datetime NOT NULL DEFAULT current_timestamp(), `currency` varchar(20) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `companies` -- INSERT INTO `companies` (`id`, `owernerid`, `owner_email`, `company_name`, `company_link`, `company_logo`, `company_overview`, `company_address`, `company_phone`, `company_email`, `company_service`, `subscription_expiration`, `created_at`, `currency`) VALUES (1, 0, 'jsmith@sample.com', 'Oma Taste', 'myglboa', '', 'Vkhodz Tech', 'no idea', '0234432323', 'mnkwasi@gmail.com', 'products', '', '2023-11-05 11:09:04', ''), (2, 0, 'globalvane2@gmail.com', 'Global Ventures Group', 'now', 'logos/php950F.tmp', 'we specialize in teh creation of all kinds of products in this world.', '21 mainland avenue', '+234588989877', 'mw652167@gmail.com123', 'both', '', '2023-11-05 11:24:09', 'NGN'), (3, 0, 'micheal@yahoo.com', 'M & a Group', 'mandagroup', 'logos/php627D.tmp', 'We produce all kinds of tyres, for vehicles, wheelbarrows, and other kinds of tyre related produces.', 'Web Technologies', '09074054088', 'anthonydivine2616@gmail.com', 'both', '', '2023-11-14 21:18:52', ''), (6, 0, 'user1@store.comhjkh', 'Vkhodz Techhjgkjh', 'Vkhodz Tech', 'logos/php9944.tmp', 'Vkhodz Tech', '21 mainland avenue', '0845688', 'mw652167@gmail.com123', 'both', '', '2023-11-14 22:55:13', ''), (7, 0, 'user1@store.comkjk', 'Vkhodz Tech', 'vktech', 'logos/phpC5C8.tmp', 'Vkhodz Tech', '21 mainland avenue', '3323232', 'Ben@mad.com', 'both', '', '2023-11-14 23:06:20', ''); -- -------------------------------------------------------- -- -- Table structure for table `logs` -- CREATE TABLE `logs` ( `id` int(11) NOT NULL, `companyid` int(20) NOT NULL, `branchid` int(20) NOT NULL, `actionby` varchar(50) NOT NULL, `usertype` varchar(29) NOT NULL, `actions` varchar(200) NOT NULL, `actiontype` varchar(70) NOT NULL, `datecreated` datetime NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `logs` -- INSERT INTO `logs` (`id`, `companyid`, `branchid`, `actionby`, `usertype`, `actions`, `actiontype`, `datecreated`) VALUES (1, 2, 1, 'user4@store.com', '', 'Purchase of 2 qty(s) of Italian shoes, payment by Crypto', 'Product Purchase', '2023-11-16 17:26:47'), (2, 2, 1, 'user4@store.com', '', 'Purchase of 1 qty(s) of Italian shoes, payment by Bank Transfer; Sold by: user2@store.comm', 'Product Purchase', '2023-11-16 17:29:33'), (3, 2, 1, 'user4@store.com', '', 'Service of 3 qty(s) of dry cleaning and general home sanitation, payment by Crypto; Service rendered by: solomon grace', 'Service Rendered', '2023-11-16 17:34:06'), (4, 2, 1, 'user4@store.com', '', 'Purchase of 1 qty(s) of Italian shoes, payment by Bank Transfer; Sold by: user2@store.comm', 'Product Purchase', '2023-11-18 14:22:57'), (5, 2, 1, 'user4@store.com', '', 'Purchase of 1 qty(s) of Italian shoes, payment by Bank Transfer; Sold by: user2@store.comm', 'Product Purchase', '2023-11-29 11:27:20'), (6, 2, 1, 'user4@store.com', '', 'Service of 3 qty(s) of dry cleaning and general home sanitation, payment by Cash at hand; Service rendered by: solomon grace', 'Service Rendered', '2023-11-29 11:28:23'); -- -------------------------------------------------------- -- -- Table structure for table `paymentmodes` -- CREATE TABLE `paymentmodes` ( `id` int(11) NOT NULL, `companyid` int(40) NOT NULL, `branchid` int(20) NOT NULL, `paymentmode` varchar(50) NOT NULL, `logo` varchar(140) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `paymentmodes` -- INSERT INTO `paymentmodes` (`id`, `companyid`, `branchid`, `paymentmode`, `logo`) VALUES (1, 2, 1, 'Bank Transfer', 'paymentmodes/phpDC80.tmp'), (2, 2, 1, 'Crypto', 'paymentmodes/php731.tmp'), (3, 2, 3, 'Cash at hand', 'paymentmodes/php356E.tmp'); -- -------------------------------------------------------- -- -- Table structure for table `products` -- CREATE TABLE `products` ( `id` int(11) NOT NULL, `productname` varchar(50) NOT NULL, `dateadded` datetime NOT NULL DEFAULT current_timestamp(), `quantity` int(10) NOT NULL, `sellingprice` varchar(20) NOT NULL, `costprice` varchar(20) NOT NULL, `updatedat` varchar(20) NOT NULL, `companyid` int(20) NOT NULL, `category` varchar(50) NOT NULL, `brand` varchar(40) NOT NULL, `tags` varchar(200) NOT NULL, `about` varchar(200) NOT NULL, `coverphoto` varchar(100) NOT NULL, `galleryimage1` varchar(100) NOT NULL, `galleryimage2` varchar(100) NOT NULL, `manufacturer` varchar(100) NOT NULL, `manbrand` varchar(50) NOT NULL, `price` varchar(20) NOT NULL, `discount` int(10) NOT NULL, `status` varchar(30) NOT NULL, `comm_type` varchar(30) NOT NULL, `comm_amount` varchar(10) NOT NULL, `comm_min` varchar(10) NOT NULL, `comm_max` varchar(10) NOT NULL, `branchid` int(20) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `products` -- INSERT INTO `products` (`id`, `productname`, `dateadded`, `quantity`, `sellingprice`, `costprice`, `updatedat`, `companyid`, `category`, `brand`, `tags`, `about`, `coverphoto`, `galleryimage1`, `galleryimage2`, `manufacturer`, `manbrand`, `price`, `discount`, `status`, `comm_type`, `comm_amount`, `comm_min`, `comm_max`, `branchid`) VALUES (5, 'Kerosine', '2023-11-11 02:36:32', 0, '300', '200', '', 2, 'Gadgets', 'railors brand', 'home use, appliance, usage', 'useful at hom', 'products/Kerosine-PXSKER5.jpg', '', '', 'kero', 'kero', '300', 1, 'Published', '', '5', '', '', 0), (9, 'profile followerssss', '2023-11-11 03:25:59', 1, '10000', '5000', '', 2, 'Appliances', 'lois vuiton', 'fashio, adsaili, adfiali', 'dsasd', 'products/php66D4.tmp', '', '', 'manuf1', 'manu brand', '10000', 0, 'Published', 'fixed', '3', '', '', 0), (10, 'Mama Gold Rice', '2023-11-15 06:37:27', 12, '200', '100', '', 2, 'Electronics', 'MAMA GOLD', 'Food, rice', 'good and rising rice, good for the family.', 'products/phpCA92.tmp', '', '', 'mamgold', 'mamagold', '200', 1, 'Published', '', '2', '', '', 0), (11, 'Italian shoes', '2023-11-16 06:04:00', 0, '13111', '5000', '', 2, 'Clothings', 'lois vuiton', 'fashion, clothing, wears', 'Perfect for traditional classy men', 'products/php8E53.tmp', '', '', 'lois vuiton', 'loid brand', '13111', 1, 'Published', '', '10', '', '', 1); -- -------------------------------------------------------- -- -- Table structure for table `rservices` -- CREATE TABLE `rservices` ( `id` int(11) NOT NULL, `serviceid` int(10) NOT NULL, `qty` int(10) NOT NULL, `amount` varchar(20) NOT NULL, `famount` varchar(20) NOT NULL, `datecreated` datetime NOT NULL DEFAULT current_timestamp(), `renby` varchar(100) NOT NULL, `mop` varchar(50) NOT NULL, `refby` varchar(100) NOT NULL, `recby` varchar(100) NOT NULL, `companyid` int(20) NOT NULL, `discount` varchar(20) NOT NULL, `branchid` int(20) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `rservices` -- INSERT INTO `rservices` (`id`, `serviceid`, `qty`, `amount`, `famount`, `datecreated`, `renby`, `mop`, `refby`, `recby`, `companyid`, `discount`, `branchid`) VALUES (1, 4, 1, 'NGN 300', '', '2023-11-13 10:38:57', 'solomon grace', 'Bank Transfer', '', 'user4@store.com', 2, '10%', 0), (2, 4, 1, '333', 'NGN 300', '2023-11-13 10:46:13', 'solomon grace', 'Bank Transfer', '', 'user4@store.com', 2, '10%', 0), (3, 4, 2, '333', '300', '2023-11-13 10:49:02', 'solomon grace', 'Bank Transfer', '', 'user4@store.com', 2, '10%', 0), (4, 4, 5, '333', '300', '2023-11-14 16:02:38', 'solomon grace', 'Bank Transfer', '', 'user4@store.com', 2, '10%', 0), (5, 5, 30, '10,000', '9,800', '2023-11-16 17:11:26', 'solomon grace', 'Bank Transfer', '', 'user4@store.com', 2, '2%', 0), (6, 5, 3, '10,000', '9,800', '2023-11-16 17:34:06', 'solomon grace', 'Crypto', '', 'user4@store.com', 2, '2%', 0), (7, 5, 3, '10,000', '9,800', '2023-11-29 11:28:23', 'solomon grace', 'Cash at hand', '', 'user4@store.com', 2, '2%', 0); -- -------------------------------------------------------- -- -- Table structure for table `sales` -- CREATE TABLE `sales` ( `id` int(11) NOT NULL, `productid` int(20) NOT NULL, `discount` varchar(10) NOT NULL, `amount` varchar(30) NOT NULL, `modeofpayment` varchar(100) NOT NULL, `quantity` int(10) NOT NULL, `buyer` varchar(100) NOT NULL, `buyerid` int(10) NOT NULL, `buyref` varchar(100) NOT NULL, `datecreated` datetime NOT NULL DEFAULT current_timestamp(), `soldby` varchar(100) NOT NULL, `recordedby` varchar(100) NOT NULL, `unitprofit` varchar(20) NOT NULL, `salesprofit` varchar(20) NOT NULL, `companyid` int(10) NOT NULL, `branchid` int(20) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `sales` -- INSERT INTO `sales` (`id`, `productid`, `discount`, `amount`, `modeofpayment`, `quantity`, `buyer`, `buyerid`, `buyref`, `datecreated`, `soldby`, `recordedby`, `unitprofit`, `salesprofit`, `companyid`, `branchid`) VALUES (1, 9, '0%', 'NGN 10,000', '', 1, 'anthonydivine266@gmail.com', 0, '', '2023-11-12 06:59:03', 'user1@store.com', 'user1@store.com', '5000', '5000', 2, 0), (2, 9, '0%', 'NGN 10,000', '', 1, 'user2@store.comm', 0, '', '2023-11-12 08:01:48', 'user1@store.com', 'user1@store.com', '5000', '5000', 2, 0), (3, 5, '1%', 'NGN 300', '', 1, 'user2@store.comm', 0, 'user2@store.comm', '2023-11-12 08:06:55', 'user1@store.com', 'user1@store.com', '100', '100', 2, 0), (4, 9, '0%', 'NGN 10,000', '', 3, 'buyer1@mail.com', 0, 'buyer1ref@mail.com', '2023-11-14 16:35:17', 'user1@store.com', 'user1@store.com', '5000', '15000', 2, 0), (5, 11, '1%', 'NGN 13,111', '', 2, 'anthonydivine266@gmail.com', 0, 'anthonydivine266@gmail.com1', '2023-11-16 17:07:20', '', 'user4@store.com', '8111', '16222', 2, 1), (6, 11, '1%', 'NGN 13,111', 'Bank Transfer', 3, 'buy@mail.com', 0, 'buye22@mail.com', '2023-11-16 17:08:47', '', 'user4@store.com', '8111', '24333', 2, 1), (7, 11, '1%', 'NGN 13,111', 'Crypto', 2, 'buyer1@mail.com', 0, 'buye22@mail.com', '2023-11-16 17:10:04', 'user2@store.comm', 'user4@store.com', '8111', '16222', 2, 1), (8, 11, '1%', 'NGN 13,111', 'Crypto', 2, 'anthonydivine266@gmail.com', 0, 'anthonydivine266@gmail.coma', '2023-11-16 17:26:46', 'user2@store.comm', 'user4@store.com', '8111', '16222', 2, 1), (9, 11, '1%', 'NGN 13,111', 'Bank Transfer', 1, 'anthonydivine266@gmail.com', 0, 'anthonydivine266@gmail.com', '2023-11-16 17:29:33', 'user2@store.comm', 'user4@store.com', '8111', '8111', 2, 1), (10, 11, '1%', 'NGN 13,111', 'Bank Transfer', 1, 'anthonydivine266@gmail.com', 0, 'anthonydivine266@gmail.com', '2023-11-18 14:22:56', 'user2@store.comm', 'user4@store.com', '8111', '8111', 2, 1), (11, 11, '1%', 'NGN 13,111', 'Bank Transfer', 1, 'nbuyer2@mail.com', 0, 'nbuyer3@mail.com', '2023-11-29 11:27:18', 'user2@store.comm', 'user4@store.com', '8111', '8111', 2, 1); -- -------------------------------------------------------- -- -- Table structure for table `services` -- CREATE TABLE `services` ( `id` int(11) NOT NULL, `servicename` varchar(50) NOT NULL, `dateadded` datetime NOT NULL DEFAULT current_timestamp(), `updatedat` varchar(20) NOT NULL, `companyid` int(20) NOT NULL, `branchid` int(20) NOT NULL, `about` varchar(200) NOT NULL, `coverphoto` varchar(100) NOT NULL, `galleryimage1` varchar(100) NOT NULL, `galleryimage2` varchar(100) NOT NULL, `price` varchar(20) NOT NULL, `discount` int(10) NOT NULL, `status` varchar(30) NOT NULL, `comm_type` varchar(30) NOT NULL, `comm_amount` varchar(10) NOT NULL, `comm_min` varchar(10) NOT NULL, `comm_max` varchar(10) NOT NULL, `pricetype` varchar(20) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `services` -- INSERT INTO `services` (`id`, `servicename`, `dateadded`, `updatedat`, `companyid`, `branchid`, `about`, `coverphoto`, `galleryimage1`, `galleryimage2`, `price`, `discount`, `status`, `comm_type`, `comm_amount`, `comm_min`, `comm_max`, `pricetype`) VALUES (4, 'Electronics Repairs and maintenance', '2023-11-11 06:16:07', '', 2, 0, 'we repair and maintain different kinds of electronics', 'services/php2C28.tmp', '', '', '333', 10, '', '', '', '', '', 'Range'), (5, 'dry cleaning and general home sanitation', '2023-11-16 14:42:51', '', 2, 1, 'Special home cleaning service at your door step.', 'services/php91E8.tmp', '', '', '10000', 2, '', '', '', '', '', ''); -- -------------------------------------------------------- -- -- Table structure for table `system` -- CREATE TABLE `system` ( `id` int(11) NOT NULL, `system_name` varchar(60) NOT NULL, `system_email` varchar(40) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `id` int(11) NOT NULL, `fullname` varchar(60) NOT NULL, `email` varchar(80) NOT NULL, `account_status` varchar(20) NOT NULL, `created_at` datetime NOT NULL DEFAULT current_timestamp(), `account_type` varchar(20) NOT NULL, `addproduct` int(1) NOT NULL, `delproduct` int(1) NOT NULL, `password` varchar(80) NOT NULL, `company_id` int(40) NOT NULL, `balance` varchar(30) NOT NULL, `refby` varchar(50) NOT NULL, `refid` int(20) NOT NULL, `branchid` int(20) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `users` -- INSERT INTO `users` (`id`, `fullname`, `email`, `account_status`, `created_at`, `account_type`, `addproduct`, `delproduct`, `password`, `company_id`, `balance`, `refby`, `refid`, `branchid`) VALUES (1, '', 'jsmith@sample.com', 'active', '2023-11-05 11:09:05', 'goods', 0, 0, '$2y$10$7r1yL/JQn3Qy.090S2kzpuqv2Opg13xNPExOCPwhzGehQsW9r2Pua', 1, '', '', 0, 0), (2, '', 'globalvane2@gmail.com', 'active', '2023-11-05 11:24:09', 'both', 0, 0, '$2y$10$z88.9tyyAqWKon7PZc3kG.ZVeYjerSUF46U5eojMqgSHEEwjOa06G', 2, '', 'userzyaa@ref.com', 0, 0), (4, 'Peters tony', 'globalvane2@gmail.com322', 'active', '2023-11-07 13:53:52', 'Customer', 0, 0, '$2y$10$LyFTbv8oCPczfhUITMCJCuvFCnA.Nvi.uQlO10Hn4ceHC6pDs5dSW', 2, '', '', 0, 0), (5, 'Simeon Peters', 'globalvane2@gmail.com32254', 'active', '2023-11-07 14:00:24', 'Customer', 0, 0, '$2y$10$Ye3d9u8UVeIjUiNG5ulXEO9z9a7GSrLgLT1HrUKsoQmA4Ym.FkFCm', 2, '', 'usedzyd@ref.com', 0, 0), (6, 'Benjamin Sandei', 'manager@store.com', 'active', '2023-11-08 12:59:05', 'Manager', 0, 0, '$2y$10$BlbNNJ2mrVK6Padg1W223ek9O6CQL8.PldTIh0YPfp5ZyckMOSsF6', 2, '', '', 0, 1), (8, 'solomon grace', 'user2@store.comm', 'active', '2023-11-11 06:00:02', 'Staff', 0, 0, '$2y$10$hknqPweNaM2nqM7Yb0wO7uq9F0Nfb/XaGEwb76SXnNtPb1jP0i0LO', 2, '0', 'userxyz@mailx.com', 0, 1), (9, 'benedict andrew', 'cashier@store.com', 'active', '2023-11-12 07:08:21', 'Cashier', 0, 0, '$2y$10$paidax82wcwySevc7FC3cuUIo1KHtr6REG5wgq8Ewq4sE2EihfMJK', 2, '', '', 0, 1), (10, 'Fred Adam', 'director@store.com', 'active', '2023-11-14 21:21:16', 'Superadmin', 0, 0, '$2y$10$2CFDeBX9lZJYJLUwsAma8uF0p.uAK3E8XKsJHC3ZzviYtWuBpSy5a', 2, '', '', 0, 1), (11, '', 'user1@store.comhjkh', 'active', '2023-11-14 22:55:13', 'both', 0, 0, '$2y$10$d4FzqNbp2FzVOgfE2ATaJ.r5SX2BDDKaTMFSbgg0/p9hHriEevUum', 2, '', '', 0, 0), (12, '', 'user1@store.comkjk', 'active', '2023-11-14 23:06:20', 'both', 0, 0, '$2y$10$z4dvHO8n/SVuck9RORWmROjKyEwzGbmEf4UXiVdxdnxx1JYuF7gAK', 7, '', '', 0, 0), (13, 'Caleb Maryan', 'user6@store.com', 'active', '2023-11-15 06:23:23', 'Customer', 0, 0, '$2y$10$8bu5xtZIpM7AVRCLsaXQeuPGkYZkCqdzAZljJIUzXeJxJktfc3eZy', 2, '', '', 0, 2), (14, 'Kaleb jane', 'user8@store.com', 'active', '2023-11-16 05:42:00', 'Staff', 0, 0, '$2y$10$PnQynHcVaXgb90x85GpM6eNt6XP2LNubZiY/JFgKEVeVWaKe06Mg.', 2, '0', '', 0, 6), (15, 'Caleb Anderson', 'us1@store.com', 'active', '2023-11-29 11:10:28', 'customer', 0, 0, '$2y$10$YBpfGIsbhG93P/fTGap3J.9VzINo2Syo2MWT2oQYgpPGlOyw1ftt2', 2, '0', '', 0, 2); -- -------------------------------------------------------- -- -- Table structure for table `withdrawals` -- CREATE TABLE `withdrawals` ( `id` int(11) NOT NULL, `user` varchar(40) NOT NULL, `userid` int(20) NOT NULL, `usertype` varchar(40) NOT NULL, `companyid` int(10) NOT NULL, `branchid` int(10) NOT NULL, `amount` varchar(20) NOT NULL, `status` varchar(15) NOT NULL, `method` varchar(30) NOT NULL, `details` varchar(100) NOT NULL, `datecreated` datetime NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Indexes for dumped tables -- -- -- Indexes for table `branches` -- ALTER TABLE `branches` ADD PRIMARY KEY (`id`); -- -- Indexes for table `companies` -- ALTER TABLE `companies` ADD PRIMARY KEY (`id`); -- -- Indexes for table `logs` -- ALTER TABLE `logs` ADD PRIMARY KEY (`id`); -- -- Indexes for table `paymentmodes` -- ALTER TABLE `paymentmodes` ADD PRIMARY KEY (`id`); -- -- Indexes for table `products` -- ALTER TABLE `products` ADD PRIMARY KEY (`id`); -- -- Indexes for table `rservices` -- ALTER TABLE `rservices` ADD PRIMARY KEY (`id`); -- -- Indexes for table `sales` -- ALTER TABLE `sales` ADD PRIMARY KEY (`id`); -- -- Indexes for table `services` -- ALTER TABLE `services` ADD PRIMARY KEY (`id`); -- -- Indexes for table `system` -- ALTER TABLE `system` ADD PRIMARY KEY (`id`); -- -- Indexes for table `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`); -- -- Indexes for table `withdrawals` -- ALTER TABLE `withdrawals` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `branches` -- ALTER TABLE `branches` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; -- -- AUTO_INCREMENT for table `companies` -- ALTER TABLE `companies` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8; -- -- AUTO_INCREMENT for table `logs` -- ALTER TABLE `logs` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; -- -- AUTO_INCREMENT for table `paymentmodes` -- ALTER TABLE `paymentmodes` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `products` -- ALTER TABLE `products` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12; -- -- AUTO_INCREMENT for table `rservices` -- ALTER TABLE `rservices` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8; -- -- AUTO_INCREMENT for table `sales` -- ALTER TABLE `sales` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12; -- -- AUTO_INCREMENT for table `services` -- ALTER TABLE `services` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `system` -- ALTER TABLE `system` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `users` -- ALTER TABLE `users` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16; -- -- AUTO_INCREMENT for table `withdrawals` -- ALTER TABLE `withdrawals` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; 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 */;