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

START TRANSACTION;



--
-- Database: `cresta`
--

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

--
-- Table structure for table `aboutus`
--

CREATE TABLE `aboutus` (
  `id` int(250) NOT NULL,
  `title` varchar(250) NOT NULL,
  `aboutm` mediumtext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `aboutus`
--

INSERT INTO `aboutus` (`id`, `title`, `aboutm`) VALUES
(1, 'About us', '                                \r\n                                <p>                                \r\n                                </p><p>                                \r\n                                </p><p>                                \r\n                                </p><p>                                \r\n                                </p><p>                                \r\n                                </p><p>                                \r\n                                </p><p>                                \r\n                                </p><p>                                \r\n                                </p><p>                                \r\n                                </p><p class=\"MsoNormal\">Welcome to the PSF Trade Cluster E-Directory, your gateway to business opportunities, trade facilitation, and market expansion.</p><p class=\"MsoNormal\">As part of the Private Sector Federation (PSF) Trade Cluster, this platform is designed to connect businesses, enhance visibility, and provide valuable trade insights. Whether you are a trader, exporter, importer, manufacturer, or service provider, our e-directory is your ultimate resource for networking, market intelligence, and business growth.</p>\r\n                            <p></p>\r\n                            <p></p>\r\n                            <p></p>\r\n                            <p></p>\r\n                            <p></p>\r\n                            <p></p>\r\n                            <p></p>\r\n                            <p></p>\r\n                            <p></p>\r\n                            ');

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

--
-- Table structure for table `branch`
--

CREATE TABLE `branch` (
  `branch_id` int(11) NOT NULL,
  `branch_name` varchar(50) NOT NULL,
  `branch_address` varchar(100) NOT NULL,
  `branch_contact` varchar(50) NOT NULL,
  `skin` varchar(15) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `branch`
--

INSERT INTO `branch` (`branch_id`, `branch_name`, `branch_address`, `branch_contact`, `skin`) VALUES
(1, 'Data Manager', 'Nyamirambo', '0787381418', 'red'),
(2, 'superadmin', 'Nyamirambo', '0787381418', 'purple'),
(3, 'Stock Manager', 'Nyamirambo', '', 'black');

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

--
-- Table structure for table `businessdirectory`
--

CREATE TABLE `businessdirectory` (
  `id` int(250) NOT NULL,
  `businessname` varchar(250) NOT NULL,
  `ownerbusiness` varchar(250) NOT NULL,
  `businessphone` varchar(250) NOT NULL,
  `businessemail` varchar(250) NOT NULL,
  `businessaddress` varchar(250) NOT NULL,
  `businesstype` varchar(250) NOT NULL,
  `businessector` varchar(250) NOT NULL,
  `businesslogo` varchar(250) NOT NULL,
  `businesspaymentproof` varchar(250) NOT NULL,
  `registeredstatus` varchar(50) NOT NULL DEFAULT 'Not Approved'
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `businessdirectory`
--

INSERT INTO `businessdirectory` (`id`, `businessname`, `ownerbusiness`, `businessphone`, `businessemail`, `businessaddress`, `businesstype`, `businessector`, `businesslogo`, `businesspaymentproof`, `registeredstatus`) VALUES
(3, 'PSF RWANDA', 'PSF RWANDA', '0788216963', 'info@psfrwanda.xyz', 'remera', 'IMPORTERS', 'G4620 - Wholesale of agricultural raw materials and live animals', 'uploads/image003 (1).png', 'uploads/deccc.PNG', 'Approved');

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

--
-- Table structure for table `category`
--

CREATE TABLE `category` (
  `id` int(250) NOT NULL,
  `category_name` varchar(250) NOT NULL,
  `done` varchar(250) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `category`
--

INSERT INTO `category` (`id`, `category_name`, `done`) VALUES
(7, 'Green Coffee Beans', ''),
(8, 'Roasted Coffee', '');

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

--
-- Table structure for table `chat_message`
--

CREATE TABLE `chat_message` (
  `chat_message_id` int(11) NOT NULL,
  `to_user_id` int(11) NOT NULL,
  `from_user_id` int(11) NOT NULL,
  `chat_message` text NOT NULL,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  `status` int(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `chat_message`
--

INSERT INTO `chat_message` (`chat_message_id`, `to_user_id`, `from_user_id`, `chat_message`, `timestamp`, `status`) VALUES
(1, 2, 1, 'heloo\n', '2021-03-04 12:12:49', 0),
(2, 2, 1, 'heloo\n', '2021-03-04 12:12:50', 0),
(3, 2, 1, 'vp\n', '2021-03-04 12:12:59', 0);

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

--
-- Table structure for table `clients`
--

CREATE TABLE `clients` (
  `id` int(250) NOT NULL,
  `cname` varchar(250) NOT NULL,
  `clogo` varchar(250) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `clients`
--

INSERT INTO `clients` (`id`, `cname`, `clogo`) VALUES
(1, '2DLINKWORLD', 'logd.png'),
(2, 'Test', 'lm.png');

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

--
-- Table structure for table `contactm`
--

CREATE TABLE `contactm` (
  `id` int(250) NOT NULL,
  `fname` varchar(250) NOT NULL,
  `emailc` varchar(250) NOT NULL,
  `subjectm` varchar(250) NOT NULL,
  `messagec` varchar(1550) NOT NULL,
  `done` varchar(250) NOT NULL,
  `donedate` date NOT NULL,
  `datedone` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `customer`
--

CREATE TABLE `customer` (
  `id` int(250) NOT NULL,
  `fullname` varchar(250) NOT NULL,
  `phone` varchar(250) NOT NULL,
  `email` varchar(250) NOT NULL,
  `tin_number` varchar(250) NOT NULL,
  `nid` varchar(250) NOT NULL,
  `done` varchar(250) NOT NULL,
  `date_done` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `customer`
--

INSERT INTO `customer` (`id`, `fullname`, `phone`, `email`, `tin_number`, `nid`, `done`, `date_done`) VALUES
(3, 'Rutembesa Shema Elvis', '0787381418', 'rutembesaelvis@gmail.com', '334455221144', '11223344', 'fullname', '2019-12-05 02:00:29'),
(4, 'Rutembesa Elvis', '0781459147', 'rutembesaelvis2@gmail.com', '55656', '555555', 'niwemahoro nicole', '2020-08-03 11:15:18'),
(5, '', '', '', '', '', 'Rutembesa Elvis Shema', '2021-02-18 19:24:23');

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

--
-- Table structure for table `donate`
--

CREATE TABLE `donate` (
  `id` int(250) NOT NULL,
  `photo` varchar(250) NOT NULL,
  `title` varchar(250) NOT NULL,
  `service` varchar(12250) NOT NULL,
  `statime` varchar(250) NOT NULL,
  `endtime` varchar(250) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `donate`
--

INSERT INTO `donate` (`id`, `photo`, `title`, `service`, `statime`, `endtime`) VALUES
(5, 'Painting-and-decorating.jpg', 'Test one 1', 'Test one please', '', '');

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

--
-- Table structure for table `exrequest`
--

CREATE TABLE `exrequest` (
  `id` int(250) NOT NULL,
  `ipaddresse` varchar(250) NOT NULL,
  `cteam` varchar(250) NOT NULL,
  `dservices` varchar(250) NOT NULL,
  `npeople` varchar(250) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `exrequest`
--

INSERT INTO `exrequest` (`id`, `ipaddresse`, `cteam`, `dservices`, `npeople`) VALUES
(1, '127.0.0.1', 'Architector', 'Drawing', '18');

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

--
-- Table structure for table `history_log`
--

CREATE TABLE `history_log` (
  `log_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `action` varchar(100) NOT NULL,
  `date` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `history_log`
--

INSERT INTO `history_log` (`log_id`, `user_id`, `action`, `date`) VALUES
(1, 0, 'has logged in the system at ', '0000-00-00 00:00:00'),
(2, 0, 'has logged out the system at ', '2020-10-29 16:37:54'),
(3, 0, 'has logged in the system at ', '0000-00-00 00:00:00'),
(4, 0, 'has logged in the system at ', '0000-00-00 00:00:00'),
(5, 0, 'has logged out the system at ', '2021-01-16 11:40:12'),
(6, 0, 'has logged in the system at ', '0000-00-00 00:00:00'),
(7, 0, 'has logged in the system at ', '0000-00-00 00:00:00'),
(8, 0, 'has logged in the system at ', '0000-00-00 00:00:00'),
(9, 0, 'has logged out the system at ', '2021-01-21 07:10:20'),
(10, 0, 'has logged in the system at ', '0000-00-00 00:00:00'),
(11, 0, 'has logged out the system at ', '2021-02-19 00:47:33'),
(12, 0, 'has logged in the system at ', '0000-00-00 00:00:00'),
(13, 0, 'has logged out the system at ', '2021-02-19 03:58:06'),
(14, 0, 'has logged in the system at ', '0000-00-00 00:00:00'),
(15, 0, 'has logged out the system at ', '2021-02-19 17:53:21'),
(16, 0, 'has logged in the system at ', '0000-00-00 00:00:00'),
(17, 0, 'has logged in the system at ', '0000-00-00 00:00:00'),
(18, 0, 'has logged out the system at ', '2021-02-19 18:32:44'),
(19, 0, 'has logged in the system at ', '0000-00-00 00:00:00'),
(20, 0, 'has logged in the system at ', '0000-00-00 00:00:00'),
(21, 0, 'has logged in the system at ', '0000-00-00 00:00:00'),
(22, 0, 'has logged in the system at ', '0000-00-00 00:00:00'),
(23, 0, 'has logged in the system at ', '0000-00-00 00:00:00'),
(24, 0, 'has logged in the system at ', '0000-00-00 00:00:00'),
(25, 0, 'has logged in the system at ', '0000-00-00 00:00:00'),
(26, 0, 'has logged out the system at ', '2021-03-07 23:49:04'),
(27, 0, 'has logged in the system at ', '0000-00-00 00:00:00'),
(28, 0, 'has logged in the system at ', '0000-00-00 00:00:00'),
(29, 0, 'has logged out the system at ', '2021-03-10 18:23:37'),
(30, 0, 'has logged in the system at ', '0000-00-00 00:00:00'),
(31, 0, 'has logged in the system at ', '0000-00-00 00:00:00'),
(32, 0, 'has logged in the system at ', '0000-00-00 00:00:00'),
(33, 0, 'has logged in the system at ', '0000-00-00 00:00:00'),
(34, 0, 'has logged in the system at ', '0000-00-00 00:00:00'),
(35, 0, 'has logged out the system at ', '2021-04-05 20:03:09'),
(36, 0, 'has logged out the system at ', '2021-04-10 23:17:33'),
(37, 0, 'has logged out the system at ', '2021-04-15 03:45:18'),
(38, 0, 'has logged out the system at ', '2021-05-08 23:17:08'),
(39, 0, 'has logged out the system at ', '2021-06-14 20:35:37'),
(40, 0, 'has logged out the system at ', '2021-06-14 22:04:27'),
(41, 0, 'has logged out the system at ', '2021-06-17 16:33:39'),
(42, 0, 'has logged out the system at ', '2021-06-17 16:43:21'),
(43, 0, 'has logged out the system at ', '2021-06-22 14:31:26'),
(44, 0, 'has logged out the system at ', '2021-06-22 15:23:36'),
(45, 0, 'has logged out the system at ', '2021-09-14 14:10:39'),
(46, 0, 'has logged out the system at ', '2021-10-13 19:17:36'),
(47, 0, 'has logged out the system at ', '2022-02-07 18:22:10'),
(48, 0, 'has logged out the system at ', '2025-04-14 23:22:36'),
(49, 0, 'has logged out the system at ', '2025-04-14 23:44:28');

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

--
-- Table structure for table `hslide`
--

CREATE TABLE `hslide` (
  `id` int(250) NOT NULL,
  `photo` varchar(250) NOT NULL,
  `title` varchar(250) NOT NULL,
  `service` varchar(12250) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `hslide`
--

INSERT INTO `hslide` (`id`, `photo`, `title`, `service`) VALUES
(13, 'rd.jpg', '', '');

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

--
-- Table structure for table `icart`
--

CREATE TABLE `icart` (
  `id` int(250) NOT NULL,
  `ipadd` varchar(250) NOT NULL,
  `item_id` varchar(250) NOT NULL,
  `price` varchar(250) NOT NULL,
  `qty` varchar(250) NOT NULL,
  `total` varchar(250) NOT NULL,
  `datedone` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `icart`
--

INSERT INTO `icart` (`id`, `ipadd`, `item_id`, `price`, `qty`, `total`, `datedone`) VALUES
(8, '127.0.0.1', '1', '18000', '4', '72000', '2021-03-17'),
(9, '2c0f:fe30:247b:0:c02a:4fda:6b48:2b23', '1', '18000', '2', '36000', '2021-03-18'),
(10, '197.157.135.151', '1', '18000', '2', '36000', '2021-03-18'),
(11, '127.0.0.1', '2', '20000', '2', '40000', '2021-04-08');

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

--
-- Table structure for table `icauses`
--

CREATE TABLE `icauses` (
  `id` int(250) NOT NULL,
  `photo` varchar(250) NOT NULL,
  `title` varchar(250) NOT NULL,
  `service` varchar(250) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `icauses`
--

INSERT INTO `icauses` (`id`, `photo`, `title`, `service`) VALUES
(2, 'project-1.jpg', 'Design Service', 'incredible opportunity to purchase this elegant, bright, and spacious duplex-up penthouse.'),
(6, 'project-single-1.jpg', 'House Painting', 'incredible opportunity to purchase this elegant, bright, and spacious duplex-up penthouse.'),
(7, 'smart_home.jpg', 'Smart Home', '2D Linkworld is here to protect your money and to make you proud of your living style. Smart home is the one of incredible living style in this Era because everyone needs to be and looks smart. So we are here as a solution.');

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

--
-- Table structure for table `invoice`
--

CREATE TABLE `invoice` (
  `id` int(250) NOT NULL,
  `order_id` varchar(250) NOT NULL,
  `datedone` date NOT NULL,
  `doneby` varchar(250) NOT NULL,
  `donedate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `status` varchar(250) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `invoice`
--

INSERT INTO `invoice` (`id`, `order_id`, `datedone`, `doneby`, `donedate`, `status`) VALUES
(1, 'invoice', '2019-10-02', 'Admin ', '2019-10-01 23:36:48', 'pending'),
(2, 'invoice1', '2019-10-03', 'Rutembesa Elvis', '2019-10-03 13:34:46', 'ordered'),
(3, 'invoice2', '2019-10-03', 'Rutembesa Elvis', '2019-10-03 13:34:46', 'pending'),
(4, 'invoice3', '2019-10-07', 'Rutembesa Elvis', '2019-10-07 14:04:44', 'ordered'),
(5, 'invoice4', '2019-10-07', 'Rutembesa Elvis', '2019-10-07 14:04:44', 'pending'),
(6, 'invoice5', '2019-10-10', 'Rutembesa Elvis', '2019-10-10 00:21:03', 'pending'),
(7, 'invoice6', '2019-10-10', 'Rutembesa Elvis', '2019-10-10 09:39:13', 'pending'),
(8, 'invoice7', '2019-10-11', 'Rutembesa Elvis', '2019-10-11 00:27:31', 'pending'),
(9, 'invoice8', '2019-10-13', 'fullname', '2019-10-13 12:16:00', 'ordered'),
(10, 'invoice9', '2019-10-13', 'fullname', '2019-10-13 12:16:00', 'pending'),
(11, 'invoice10', '2019-10-13', 'fullname', '2019-10-13 21:42:47', 'pending'),
(12, 'invoice11', '2019-10-14', 'fullname', '2019-10-14 03:49:51', 'ordered'),
(13, 'invoice12', '2019-10-14', 'fullname', '2019-10-14 04:59:09', 'ordered'),
(14, 'invoice13', '2019-10-14', 'fullname', '2019-10-14 05:08:26', 'ordered'),
(15, 'invoice14', '2019-10-14', 'fullname', '2019-10-14 05:08:35', 'ordered'),
(16, 'invoice15', '2019-10-14', 'fullname', '2019-10-14 05:09:03', 'ordered'),
(17, 'invoice16', '2019-10-14', 'fullname', '2019-10-14 05:09:11', 'ordered'),
(18, 'invoice17', '2019-10-14', 'fullname', '2019-10-14 05:10:09', 'ordered'),
(19, 'invoice18', '2019-10-14', 'fullname', '2019-10-14 05:10:35', 'ordered'),
(20, 'invoice19', '2019-10-14', 'fullname', '2019-10-14 05:11:41', 'ordered'),
(21, 'invoice20', '2019-10-14', 'fullname', '2019-10-14 05:13:54', 'ordered'),
(22, 'invoice21', '2019-10-14', 'fullname', '2019-10-14 05:14:35', 'ordered'),
(23, 'invoice22', '2019-10-14', 'fullname', '2019-10-14 05:20:06', 'ordered'),
(24, 'invoice23', '2019-10-14', 'fullname', '2019-10-14 05:22:38', 'ordered'),
(25, 'invoice24', '2019-10-14', 'fullname', '2019-10-14 05:27:47', 'ordered'),
(26, 'invoice25', '2019-10-14', 'fullname', '2019-10-14 05:27:47', 'pending'),
(27, 'invoice26', '2019-10-23', 'fullname', '2019-10-23 20:53:57', 'ordered'),
(28, 'invoice27', '2019-10-23', 'fullname', '2019-10-23 20:57:02', 'ordered'),
(29, 'invoice28', '2019-10-23', 'fullname', '2019-10-23 21:02:50', 'ordered'),
(30, 'invoice29', '2019-10-23', 'fullname', '2019-10-23 21:03:24', 'ordered'),
(31, 'invoice30', '2019-10-23', 'fullname', '2019-10-23 21:04:07', 'ordered'),
(32, 'invoice31', '2019-10-23', 'fullname', '2019-10-23 21:05:25', 'ordered'),
(33, 'invoice32', '2019-10-23', 'fullname', '2019-10-23 21:05:39', 'ordered'),
(34, 'invoice33', '2019-10-23', 'fullname', '2019-10-23 21:06:44', 'ordered'),
(35, 'invoice34', '2019-10-23', 'fullname', '2019-10-23 21:08:13', 'ordered'),
(36, 'invoice35', '2019-10-23', 'fullname', '2019-10-23 21:08:13', 'pending'),
(37, 'invoice36', '2019-10-24', 'fullname', '2019-10-24 14:01:49', 'ordered'),
(38, 'invoice37', '2019-10-24', 'fullname', '2019-10-24 14:08:40', 'ordered'),
(39, 'invoice38', '2019-10-24', 'fullname', '2019-10-24 14:08:40', 'pending'),
(40, 'invoice39', '2019-10-24', 'fullname', '2019-10-24 16:48:56', 'pending'),
(41, 'invoice40', '2019-10-28', 'fullname', '2019-10-28 11:15:12', 'ordered'),
(42, 'invoice41', '2019-10-28', 'fullname', '2019-10-28 11:57:45', 'ordered'),
(43, 'invoice42', '2019-10-28', 'fullname', '2019-10-28 12:24:39', 'unpaid'),
(44, 'invoice43', '2019-10-28', 'fullname', '2019-10-28 21:22:29', 'ordered'),
(45, 'invoice44', '2019-10-28', 'fullname', '2019-10-28 21:03:29', 'unpaid'),
(46, 'invoice45', '2019-10-28', 'fullname', '2019-10-28 21:10:36', 'unpaid'),
(47, 'invoice46', '2019-10-28', 'fullname', '2019-10-28 21:15:23', 'ordered'),
(48, 'invoice47', '2019-10-28', 'fullname', '2019-10-28 21:11:46', 'pending'),
(49, 'invoice48', '2019-10-28', 'fullname', '2019-10-28 21:22:38', 'ordered'),
(50, 'invoice49', '2019-10-28', 'fullname', '2019-10-28 21:22:15', 'pending'),
(51, 'invoice50', '2019-10-28', 'fullname', '2019-10-28 21:22:29', 'pending'),
(52, 'invoice51', '2019-10-28', 'fullname', '2019-10-28 21:22:38', 'pending'),
(53, 'invoice52', '2019-10-28', 'fullname', '2019-10-28 21:49:17', 'unpaid'),
(54, 'invoice53', '2019-10-28', 'fullname', '2019-12-05 10:02:45', 'ordered'),
(55, 'invoice54', '2019-10-28', 'fullname', '2019-10-28 21:50:04', 'ordered'),
(56, 'invoice55', '2019-10-28', 'fullname', '2019-10-28 21:50:04', 'pending'),
(57, 'invoice56', '2019-12-05', 'fullname', '2019-12-05 04:10:08', 'pending'),
(58, 'invoice57', '2019-12-05', 'fullname', '2019-12-05 10:02:45', 'pending'),
(59, 'invoice58', '2019-12-06', 'fullname', '2019-12-06 08:13:43', 'pending'),
(60, 'invoice59', '2019-12-07', 'fullname', '2019-12-07 02:30:58', 'ordered'),
(61, 'invoice60', '2019-12-07', 'fullname', '2019-12-07 02:30:58', 'pending'),
(62, 'invoice61', '2019-12-07', 'fullname', '2019-12-07 14:11:54', 'ordered'),
(63, 'invoice62', '2019-12-07', 'fullname', '2019-12-07 14:14:02', 'ordered'),
(64, 'invoice63', '2019-12-07', 'fullname', '2019-12-07 14:16:13', 'ordered'),
(65, 'invoice64', '2019-12-07', 'fullname', '2019-12-07 14:19:15', 'ordered'),
(66, 'invoice65', '2019-12-07', 'fullname', '2019-12-07 14:19:57', 'ordered'),
(67, 'invoice66', '2019-12-07', 'fullname', '2019-12-07 20:40:00', 'ordered'),
(68, 'invoice67', '2019-12-07', 'fullname', '2019-12-07 20:40:25', 'ordered'),
(69, 'invoice68', '2019-12-07', 'fullname', '2019-12-07 20:54:10', 'ordered'),
(70, 'invoice69', '2019-12-07', 'fullname', '2019-12-07 20:54:10', 'pending'),
(71, 'invoice70', '2019-12-08', 'fullname', '2019-12-08 14:51:48', 'ordered'),
(72, 'invoice71', '2019-12-08', 'fullname', '2019-12-08 14:51:49', 'pending'),
(73, 'invoice72', '2019-12-08', 'fullname', '2019-12-08 16:04:35', 'pending'),
(74, 'invoice73', '2019-12-11', 'fullname', '2019-12-11 11:44:06', 'ordered'),
(75, 'invoice74', '2019-12-11', 'fullname', '2019-12-11 11:44:48', 'ordered'),
(76, 'invoice75', '2019-12-11', 'fullname', '2019-12-11 11:44:49', 'pending'),
(77, 'invoice76', '2019-12-12', 'fullname', '2019-12-12 08:19:00', 'pending'),
(78, 'invoice77', '2019-12-12', 'fullname', '2019-12-12 08:19:33', 'pending'),
(79, 'invoice78', '2019-12-12', 'fullname', '2019-12-12 15:29:41', 'pending'),
(80, 'invoice79', '2019-12-12', 'fullname', '2019-12-12 15:36:28', 'pending'),
(81, 'invoice80', '2019-12-12', 'fullname', '2019-12-12 15:58:23', 'pending'),
(82, 'invoice81', '2019-12-12', 'fullname', '2019-12-12 16:08:43', 'pending'),
(83, 'invoice82', '2019-12-12', 'fullname', '2020-02-11 22:12:12', 'ordered'),
(84, 'invoice83', '2019-12-12', 'fullname', '2019-12-12 18:46:16', 'ordered'),
(85, 'invoice84', '2019-12-12', 'fullname', '2019-12-12 18:46:17', 'pending'),
(86, 'invoice85', '2019-12-16', 'fullname', '2019-12-16 15:13:09', 'ordered'),
(87, 'invoice86', '2019-12-16', 'fullname', '2019-12-16 15:13:09', 'pending'),
(88, 'invoice87', '2019-12-17', 'fullname', '2019-12-17 00:13:08', 'ordered'),
(89, 'invoice88', '2019-12-17', 'fullname', '2019-12-17 00:13:08', 'pending'),
(90, 'invoice89', '2019-12-19', 'fullname', '2019-12-19 00:29:24', 'pending'),
(91, 'invoice90', '2019-12-19', 'fullname', '2019-12-19 01:03:54', 'inventory'),
(92, 'invoice91', '2019-12-19', 'fullname', '2019-12-19 01:03:54', 'pending'),
(93, 'invoice92', '2019-12-19', 'fullname', '2019-12-19 07:40:30', 'pending'),
(94, 'invoice93', '2019-12-19', 'fullname', '2019-12-19 08:47:06', 'unpaid'),
(95, 'invoice94', '2019-12-19', 'fullname', '2019-12-19 08:47:06', 'pending'),
(96, 'invoice95', '2019-12-19', 'fullname', '2019-12-19 09:33:52', 'pending'),
(97, 'invoice96', '2019-12-19', 'fullname', '2019-12-19 09:36:37', 'pending'),
(98, 'invoice97', '2019-12-19', 'fullname', '2019-12-19 09:39:38', 'pending'),
(99, 'invoice98', '2019-12-19', 'fullname', '2019-12-19 09:44:04', 'pending'),
(100, 'invoice99', '2019-12-19', 'fullname', '2019-12-19 09:46:35', 'pending'),
(101, 'invoice100', '2019-12-19', 'fullname', '2019-12-19 10:01:36', 'pending'),
(102, 'invoice101', '2019-12-20', 'fullname', '2019-12-20 08:21:17', 'pending'),
(103, 'Ref_Number102', '2019-12-20', 'fullname', '2019-12-20 08:39:10', 'pending'),
(104, 'Ref_Number103', '2019-12-20', 'fullname', '2019-12-20 09:16:39', 'pending'),
(105, 'Ref_Number104', '2019-12-20', 'fullname', '2019-12-20 09:17:02', 'pending'),
(106, 'Ref_Number105', '2019-12-20', 'fullname', '2019-12-20 09:17:28', 'ordered'),
(107, 'Ref_Number106', '2019-12-20', 'fullname', '2019-12-20 09:17:30', 'ordered'),
(108, 'Ref_Number107', '2019-12-20', 'fullname', '2019-12-20 09:17:31', 'ordered'),
(109, 'Ref_Number108', '2019-12-20', 'fullname', '2019-12-20 09:17:46', 'ordered'),
(110, 'Ref_Number109', '2019-12-20', 'fullname', '2019-12-20 09:17:52', 'ordered'),
(111, 'Ref_Number110', '2019-12-20', 'fullname', '2019-12-20 09:17:57', 'ordered'),
(112, 'Ref_Number111', '2019-12-20', 'fullname', '2019-12-20 11:13:01', 'ordered'),
(113, 'invoice112', '2019-12-20', 'fullname', '2019-12-20 11:13:01', 'pending'),
(114, 'Ref_Number113', '2019-12-20', 'fullname', '2019-12-20 13:34:40', 'ordered'),
(115, 'Ref_Number114', '2019-12-20', 'fullname', '2019-12-20 13:34:48', 'ordered'),
(116, 'Ref_Number115', '2019-12-20', 'fullname', '2019-12-20 13:34:57', 'ordered'),
(117, 'Ref_Number116', '2019-12-20', 'fullname', '2019-12-20 13:35:13', 'ordered'),
(118, 'Ref_Number117', '2019-12-20', 'fullname', '2019-12-20 13:39:59', 'ordered'),
(119, 'Ref_Number118', '2019-12-20', 'fullname', '2019-12-20 13:46:00', 'ordered'),
(120, 'Ref_Number119', '2019-12-20', 'fullname', '2019-12-20 13:48:32', 'ordered'),
(121, 'Ref_Number120', '2019-12-20', 'fullname', '2019-12-20 13:51:52', 'ordered'),
(122, 'Ref_Number121', '2019-12-20', 'fullname', '2019-12-20 13:51:56', 'ordered'),
(123, 'Ref_Number122', '2019-12-20', 'fullname', '2019-12-20 13:51:58', 'ordered'),
(124, 'Ref_Number123', '2019-12-20', 'fullname', '2019-12-20 13:52:13', 'ordered'),
(125, 'Ref_Number124', '2019-12-20', 'fullname', '2019-12-20 13:52:39', 'ordered'),
(126, 'Ref_Number125', '2019-12-20', 'fullname', '2019-12-20 13:53:44', 'ordered'),
(127, 'Ref_Number126', '2019-12-20', 'fullname', '2019-12-20 13:57:35', 'ordered'),
(128, 'Ref_Number127', '2019-12-20', 'fullname', '2019-12-20 13:57:36', 'pending'),
(129, 'Ref_Number128', '2019-12-20', 'fullname', '2019-12-20 15:15:02', 'pending'),
(130, 'Ref_Number129', '2020-01-31', 'fullname', '2020-01-31 11:12:32', 'pending'),
(131, 'invoice130', '2020-02-11', 'fullname', '2020-02-11 22:03:05', 'ordered'),
(132, 'invoice131', '2020-02-12', 'fullname', '2020-02-11 22:03:05', 'pending'),
(133, 'invoice132', '2020-02-12', 'fullname', '2020-02-11 22:12:12', 'pending'),
(134, 'invoice133', '2017-01-11', 'fullname', '2017-01-12 07:27:14', 'pending'),
(135, 'Ref_Number134', '2020-02-26', 'fullname', '2020-02-26 20:56:08', 'pending'),
(136, 'invoice135', '2020-02-26', 'fullname', '2020-02-26 21:28:53', 'pending'),
(137, 'invoice136', '2020-02-27', 'fullname', '2020-02-27 07:03:26', 'pending'),
(138, 'Ref_Number137', '2020-02-27', 'fullname', '2020-02-27 09:10:00', 'pending'),
(139, 'Ref_Number138', '2020-03-06', 'fullname', '2020-03-06 19:26:32', 'ordered'),
(140, 'Ref_Number139', '2020-03-06', 'fullname', '2020-03-06 19:26:32', 'pending'),
(141, 'invoice140', '2020-03-09', 'fullname', '2020-03-09 20:04:08', 'pending'),
(142, 'Ref_Number141', '2020-04-01', 'fullname', '2020-04-01 15:56:40', 'pending'),
(143, 'invoice142', '2020-04-01', 'fullname', '2020-04-01 16:46:06', 'ordered'),
(144, 'invoice143', '2020-04-01', 'fullname', '2020-04-01 16:48:07', 'ordered'),
(145, 'invoice144', '2020-04-01', 'fullname', '2020-04-01 16:50:11', 'ordered'),
(146, 'invoice145', '2020-04-01', 'fullname', '2020-04-01 16:50:11', 'pending'),
(147, 'invoice146', '2020-04-01', 'fullname', '2020-04-01 17:01:33', 'pending'),
(148, 'Ref_Number147', '2020-04-05', 'fullname', '2020-04-05 19:30:39', 'pending'),
(149, 'Ref_Number148', '2020-04-05', 'fullname', '2020-04-05 19:49:31', 'ordered'),
(150, 'Ref_Number149', '2020-04-05', 'fullname', '2020-04-05 19:49:31', 'pending'),
(151, 'Ref_Number150', '2020-04-05', 'fullname', '2020-04-05 20:17:24', 'pending'),
(152, 'Ref_Number151', '2020-04-05', 'fullname', '2020-04-05 20:25:29', 'ordered'),
(153, 'Ref_Number152', '2020-04-05', 'fullname', '2020-04-05 20:25:29', 'pending'),
(154, 'Ref_Number153', '2020-04-05', 'fullname', '2020-04-05 21:11:34', 'ordered'),
(155, 'Ref_Number154', '2020-04-05', 'fullname', '2020-04-05 21:11:34', 'pending'),
(156, 'Ref_Number155', '2020-04-05', 'fullname', '2020-04-05 21:42:06', 'ordered'),
(157, 'Ref_Number156', '2020-04-05', 'fullname', '2020-04-05 21:45:03', 'ordered'),
(158, 'Ref_Number157', '2020-04-05', 'fullname', '2020-04-05 21:45:03', 'pending'),
(159, 'Ref_Number158', '2020-04-05', 'fullname', '2020-04-05 22:04:36', 'pending'),
(160, 'Ref_Number159', '2020-04-05', 'fullname', '2020-04-05 22:06:01', 'pending'),
(161, 'invoice160', '2020-04-05', 'fullname', '2020-04-05 22:29:18', 'ordered'),
(162, 'invoice161', '2020-04-05', 'fullname', '2020-04-05 22:38:38', 'ordered'),
(163, 'invoice162', '2020-04-05', 'fullname', '2020-04-05 22:38:38', 'pending'),
(164, 'invoice163', '2021-02-18', 'Rutembesa Elvis Shema', '2021-02-18 20:26:39', 'ordered'),
(165, 'invoice164', '2021-02-18', 'Rutembesa Elvis Shema', '2021-02-18 20:26:39', 'pending'),
(166, 'invoice165', '2021-02-18', 'Rutembesa Elvis Shema', '2021-02-18 20:44:02', 'ordered'),
(167, 'invoice166', '2021-02-18', 'Rutembesa Elvis Shema', '2021-02-18 20:43:38', 'pending'),
(168, 'invoice167', '2021-02-18', 'Rutembesa Elvis Shema', '2021-02-18 20:44:02', 'pending');

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

--
-- Table structure for table `iphoto`
--

CREATE TABLE `iphoto` (
  `id` int(250) NOT NULL,
  `item_id` varchar(250) NOT NULL,
  `photos` varchar(250) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `iphoto`
--

INSERT INTO `iphoto` (`id`, `item_id`, `photos`) VALUES
(2, '3', 'Bourbon.webp'),
(3, '4', 'Mbirizi.jpg'),
(4, '5', 'Espresso Roast Arabica.jpg'),
(5, '7', 'Light Roast Bourbon Arabica.webp'),
(6, '8', 'Export of high-quality, washed Arabica beans..jpg'),
(7, '9', 'Sasa.png'),
(8, '10', 'roasting-coffee-roasterandroaster.jpeg'),
(9, '11', 'vALUE-CHAIN-ENG-1024x672.jpg'),
(10, '12', 'Carefully roasted in Rwanda for international export.jpg'),
(11, '13', '2.jpg'),
(12, '14', 'whole-bean-vs-ground-coffee.jpeg');

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

--
-- Table structure for table `items`
--

CREATE TABLE `items` (
  `id` int(250) NOT NULL,
  `barcode` varchar(250) NOT NULL,
  `photo` varchar(250) NOT NULL,
  `item_name` varchar(250) NOT NULL,
  `quantity` varchar(250) NOT NULL,
  `price` varchar(250) NOT NULL,
  `cost` varchar(250) NOT NULL,
  `total` varchar(250) NOT NULL,
  `unit` varchar(250) NOT NULL,
  `taxes` varchar(250) NOT NULL,
  `stock` varchar(250) NOT NULL,
  `description` varchar(550) NOT NULL,
  `supplier` varchar(250) NOT NULL,
  `done` varchar(250) NOT NULL,
  `date_done` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `category` varchar(250) NOT NULL,
  `measure` varchar(250) DEFAULT NULL,
  `item_size` varchar(250) NOT NULL,
  `publish` varchar(250) NOT NULL,
  `icolour` varchar(250) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `items`
--

INSERT INTO `items` (`id`, `barcode`, `photo`, `item_name`, `quantity`, `price`, `cost`, `total`, `unit`, `taxes`, `stock`, `description`, `supplier`, `done`, `date_done`, `category`, `measure`, `item_size`, `publish`, `icolour`) VALUES
(8, '', '', 'Export of high-quality, washed Arabica beans.', '', '', '', '', '', '', '', '', '', '', '2025-09-23 12:30:20', 'Green Coffee Beans', NULL, '', '', ''),
(9, '', '', 'Distinct flavor notes: floral, citrus, bright acidity, and silky body.', '', '', '', '', '', '', '', '', '', '', '2025-09-23 12:31:50', 'Green Coffee Beans', NULL, '', '', ''),
(10, '', '', 'Available in bulk shipments tailored to roaster requirements', '', '', '', '', '', '', '', '', '', '', '2025-09-23 12:34:44', 'Green Coffee Beans', NULL, '', '', ''),
(11, '', '', 'Traceability from farm to export.', '', '', '', '', '', '', '', '', '', '', '2025-09-23 12:42:12', 'Green Coffee Beans', NULL, '', '', ''),
(12, '', '', 'Carefully roasted in Rwanda for international export', '', '', '', '', '', '', '', '', '', '', '2025-09-23 12:46:08', 'Roasted Coffee', NULL, '', '', ''),
(13, '', '', 'Specialty grade with unique profiles catering to European, UK, and US markets', '', '', '', '', '', '', '', '', '', '', '2025-09-23 12:50:23', 'Roasted Coffee', NULL, '', '', ''),
(14, '', '', 'Whole beans & ground options for cafes, gourmet shops, and retailers.', '', '', '', '', '', '', '', '', '', '', '2025-09-23 12:53:31', 'Roasted Coffee', NULL, '', '', '');

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

--
-- Table structure for table `login_details`
--

CREATE TABLE `login_details` (
  `login_details_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `last_activity` timestamp NOT NULL DEFAULT current_timestamp(),
  `is_type` enum('no','yes') NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `login_details`
--

INSERT INTO `login_details` (`login_details_id`, `user_id`, `last_activity`, `is_type`) VALUES
(1, 1, '2021-03-04 12:07:43', 'no'),
(2, 1, '2021-03-04 15:39:31', 'no'),
(3, 2, '2021-03-04 14:45:55', 'no'),
(4, 1, '2021-03-04 19:54:04', 'no'),
(5, 1, '2021-03-18 12:18:25', 'no');

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

--
-- Table structure for table `measurement`
--

CREATE TABLE `measurement` (
  `id` int(250) NOT NULL,
  `measure` varchar(250) NOT NULL,
  `done` varchar(250) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `measurement`
--

INSERT INTO `measurement` (`id`, `measure`, `done`) VALUES
(11, 'pc', '');

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

--
-- Table structure for table `order_status`
--

CREATE TABLE `order_status` (
  `id` int(250) NOT NULL,
  `order_id` varchar(250) NOT NULL,
  `barcode` varchar(250) NOT NULL,
  `item` varchar(250) NOT NULL,
  `qty` varchar(250) NOT NULL,
  `exp` varchar(250) NOT NULL,
  `cost` varchar(250) NOT NULL,
  `total` varchar(250) NOT NULL,
  `pay_type` varchar(250) NOT NULL,
  `paid` varchar(250) NOT NULL,
  `sdc` varchar(250) NOT NULL,
  `stock_status` varchar(250) NOT NULL,
  `sale_status` varchar(250) NOT NULL,
  `done` varchar(250) NOT NULL,
  `customer` varchar(250) NOT NULL,
  `date_done` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `done_date` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `order_status`
--

INSERT INTO `order_status` (`id`, `order_id`, `barcode`, `item`, `qty`, `exp`, `cost`, `total`, `pay_type`, `paid`, `sdc`, `stock_status`, `sale_status`, `done`, `customer`, `date_done`, `done_date`) VALUES
(1, 'invoice163', '20526265', 'Test', '10', '', '300000', '3000000', '', '', '', 'in', 'ordered', 'Rutembesa Elvis Shema', 'super', '2021-02-18 20:26:39', '2021-02-18'),
(2, 'invoice164', '20526265', 'Test', '1', '', '300000', '300000', '', '', '', 'inve', 'pending', 'Rutembesa Elvis Shema', '', '2021-02-18 20:33:00', '2021-02-18'),
(3, 'invoice165', '20526265', 'Test', '1', '', '300000', '300000', '', '', '', 'out', 'ordered', 'Rutembesa Elvis Shema', 'Rutembesa Shema Elvis', '2021-02-18 20:44:02', '2021-02-18'),
(4, 'invoice168', '20526265', 'Test', '1', '', '300000', '300000', '', '', '', 'out', 'pending', 'Rutembesa Elvis Shema', '', '2021-02-19 12:58:11', '2021-02-19');

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

--
-- Table structure for table `orequest`
--

CREATE TABLE `orequest` (
  `id` int(250) NOT NULL,
  `ipaddresse` varchar(250) NOT NULL,
  `requestd` mediumtext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `paintt`
--

CREATE TABLE `paintt` (
  `id` int(250) NOT NULL,
  `brandd` varchar(250) NOT NULL,
  `colourr` varchar(250) NOT NULL,
  `size` varchar(250) NOT NULL,
  `price` varchar(250) NOT NULL,
  `ipaddresse` varchar(250) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `payment`
--

CREATE TABLE `payment` (
  `id` int(250) NOT NULL,
  `insurance` varchar(250) NOT NULL,
  `insu_pay` varchar(250) NOT NULL,
  `invoice` varchar(250) NOT NULL,
  `paid` varchar(250) NOT NULL,
  `pay_type` varchar(250) NOT NULL,
  `status` varchar(250) NOT NULL,
  `datedone` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `done` varchar(250) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `payment`
--

INSERT INTO `payment` (`id`, `insurance`, `insu_pay`, `invoice`, `paid`, `pay_type`, `status`, `datedone`, `done`) VALUES
(14, '', '', 'invoice74', '500', 'credit card', 'ordered', '2019-12-11 11:44:48', 'fullname'),
(15, '', '', 'invoice75', '500', 'credit card', 'pending', '2019-12-11 12:53:14', 'fullname'),
(16, '', '', 'invoice82', '4000', 'cash', 'ordered', '2019-12-12 17:45:22', 'fullname'),
(17, '', '', 'invoice82', '4000', 'credit card', 'ordered', '2019-12-12 17:45:22', 'fullname'),
(18, '', '', 'invoice82', '3000', 'cash', 'ordered', '2019-12-12 17:45:22', 'fullname'),
(19, '', '', 'invoice82', '500o', 'cash', 'pending', '2019-12-12 18:40:00', 'fullname'),
(20, '', '', 'invoice83', '1500', 'mobile money', 'ordered', '2019-12-12 18:46:16', 'fullname'),
(21, '', '', 'invoice83', '1000', 'cash', 'ordered', '2019-12-12 18:46:16', 'fullname'),
(22, '', '', 'invoice89', '20000', 'credit card', 'ordered', '2019-12-19 00:29:24', 'fullname'),
(23, 'RSSB', '8925', '1575', '', '', 'ordered', '2020-02-11 21:36:18', 'fullname'),
(24, 'RSSB', '8925', 'invoice130', '1575', 'mobile money', 'ordered', '2020-02-11 21:50:42', 'fullname'),
(25, 'RSSB', '8925', 'invoice130', '1575', '', 'ordered', '2020-02-11 21:53:31', 'fullname'),
(26, 'RSSB', '8925', 'invoice130', '1575', '', 'ordered', '2020-02-11 22:03:04', 'fullname'),
(27, 'RSSB', '4250', 'invoice82', '750', 'mobile money', 'ordered', '2020-02-11 22:12:12', 'fullname'),
(28, 'MMI', '60', 'invoice133', '40', 'mobile money', 'ordered', '2017-01-12 07:27:14', 'fullname'),
(29, 'UAP', '500', 'invoice144', '1000', 'cash', 'ordered', '2020-04-01 16:50:11', 'fullname'),
(30, 'UAP', '1700', 'invoice146', '1700', '', 'ordered', '2020-04-01 17:01:33', 'fullname'),
(31, 'UAP', '6000', 'invoice160', '60000', 'cash', 'ordered', '2020-04-05 22:29:17', 'fullname'),
(32, 'UAP', '6000', 'invoice160', '60000', 'cash', 'ordered', '2020-04-05 22:29:18', 'fullname'),
(33, 'UAP', '3500', 'invoice161', '3500', '', 'ordered', '2020-04-05 22:38:38', 'fullname');

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

--
-- Table structure for table `photo`
--

CREATE TABLE `photo` (
  `id` int(250) NOT NULL,
  `photos` varchar(250) NOT NULL,
  `datetime` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `photo`
--

INSERT INTO `photo` (`id`, `photos`, `datetime`) VALUES
(3, 'IMG-20201008-WA0048.jpg', '2021-10-05 11:16:18'),
(4, 'WhatsApp Image 2022-10-24 at 3.42.53 AM.jpeg', '2022-10-24 10:58:19'),
(5, 'WhatsApp Image 2022-10-24 at 3.42.02 AM.jpeg', '2022-10-24 10:58:41'),
(7, 'WhatsApp Image 2022-10-24 at 3.41.32 AM.jpeg', '2022-10-24 10:59:25'),
(8, 'WhatsApp Image 2022-10-24 at 3.32.38 AM.jpeg', '2022-10-24 10:59:43'),
(9, 'WhatsApp Image 2022-10-24 at 3.42.28 AM.jpeg', '2022-10-24 11:00:04'),
(10, 'WhatsApp Image 2022-10-24 at 3.39.57 AM.jpeg', '2022-10-24 11:07:15');

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

--
-- Table structure for table `pmethod`
--

CREATE TABLE `pmethod` (
  `id` int(250) NOT NULL,
  `method` varchar(250) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `pmethod`
--

INSERT INTO `pmethod` (`id`, `method`) VALUES
(4, 'cash'),
(6, 'mobile money');

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

--
-- Table structure for table `projects`
--

CREATE TABLE `projects` (
  `id` int(250) NOT NULL,
  `photo` varchar(250) NOT NULL,
  `title` varchar(250) NOT NULL,
  `service` varchar(250) NOT NULL,
  `datetime` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `projects`
--

INSERT INTO `projects` (`id`, `photo`, `title`, `service`, `datetime`) VALUES
(1, '9.jpg', 'Shelter and Clothing', 'Even a $5 donation can help provide shelter and clothing to those in need. Please join us in offering warmth and safety to those affected by the war.', '2024-06-23 20:41:29'),
(3, '10.webp', 'Ensure Pure Drinking Water', 'Even a $5 donation can help ensure access to pure drinking water for those in need. Please join us in providing this essential resource to those affected by the war.', '2024-06-22 16:40:15'),
(8, '12.jpg', 'Ensure Medical Treatment', 'Even a $5 donation can help ensure access to vital medical treatment for those in need. Please join us in providing life-saving care to those affected by the war.', '2024-06-22 17:07:21'),
(79, 'Screenshot (7).png', 'Help Radjabu to fight cancer', 'After genocide happened in Rwanda, since then some families disapeared , some children become orphans at young ages, radjabu does not his family, or any relative in his family, later on , after a bad live of street, he started facing the problem of c', '2024-10-12 13:29:00'),
(80, 'Rwandan-refugee-camp-Zaire-CDC.jpg', 'help our people in refugee camps in goma', 'aider nos populations dans les camps de réfugiés de Goma à rentrer chez elles en toute sécurité', '2025-01-29 19:56:59'),
(81, 'AP22319671080104.jpg', 'Dufatanye Kurwanya ihohoterwa rikorerwa abanyamurenge', 'Abavandimwe bacu b’Abanyamurenge bari mu kaga! Mu Burasirazuba bwa Repubulika Iharanira Demokarasi ya Congo, baricwa, baratwikirwa, barasahurwa, kandi isi irebera. Dufatanye kuzamura ijwi ryabo, tubere ijwi abatagifite ubushobozi bwo kwivugira. Bur', '2025-04-14 15:40:02');

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

--
-- Table structure for table `purchase`
--

CREATE TABLE `purchase` (
  `id` int(250) NOT NULL,
  `order_id` varchar(250) NOT NULL,
  `barcode` varchar(250) NOT NULL,
  `item` varchar(250) NOT NULL,
  `qty` varchar(250) NOT NULL,
  `cost` varchar(250) NOT NULL,
  `sdc` varchar(250) NOT NULL,
  `total` varchar(250) NOT NULL,
  `pay_type` varchar(250) NOT NULL,
  `paid` varchar(250) NOT NULL,
  `stock_status` varchar(250) NOT NULL,
  `sale_status` varchar(250) NOT NULL,
  `done` varchar(250) NOT NULL,
  `customer` varchar(250) NOT NULL,
  `date_done` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `done_date` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `purchase`
--

INSERT INTO `purchase` (`id`, `order_id`, `barcode`, `item`, `qty`, `cost`, `sdc`, `total`, `pay_type`, `paid`, `stock_status`, `sale_status`, `done`, `customer`, `date_done`, `done_date`) VALUES
(5, 'Ref_Number119', '54366', 'Energry', '1', '4000', '', '4000', '', '', 'out', 'ordered', 'fullname', '', '2019-12-20 13:48:31', '2019-12-20'),
(6, 'Ref_Number120', '54366', 'Energry', '1', '4000', '', '4000', '', '', 'out', 'ordered', 'fullname', '', '2019-12-20 13:51:52', '2019-12-20'),
(7, 'Ref_Number125', '123654789', 'Energry', '1', '400', '', '400', '', '', 'out', 'ordered', 'fullname', '', '2019-12-20 13:53:44', '2019-12-20'),
(8, 'Ref_Number126', '123654789', 'Energry', '1', '400', '', '400', '', '', 'out', 'ordered', 'fullname', '', '2019-12-20 13:57:35', '2019-12-20'),
(9, 'Ref_Number127', '54366', 'Energry', '1', '4000', '', '4000', '', '', 'out', 'pending', 'fullname', 'super', '2019-12-20 15:14:24', '2019-12-20'),
(10, 'invoice129', '54366', 'Energry', '4', '4000', '', '16000', '', '', 'out', 'ordered', 'fullname', 'Sun', '2020-01-31 11:12:32', '2020-01-31'),
(14, 'invoice134', '', 'PARACETAMOL SP 100ML', '12', '600', '', '7200', '', '', 'out', 'ordered', 'fullname', 'Sun', '2020-02-27 09:23:51', '2020-02-26'),
(15, 'invoice137', '', 'PARACETAMOL SP 100ML', '12', '600', '', '7200', '', '', 'out', 'ordered', 'fullname', '', '2020-02-27 09:23:51', '2020-02-27'),
(16, 'invoice138', '', 'ABACOFF SP 100ML', '1', '700', '', '700', '', '', 'out', 'ordered', 'fullname', '', '2020-03-06 19:26:32', '2020-03-05'),
(17, 'invoice138', '', 'PARACETAMOL INJECTABLE 120MG', '1', '1', '', '1', '', '', 'out', 'ordered', 'fullname', '', '2020-03-06 19:26:32', '2020-03-06'),
(18, 'invoice138', '', 'PAIDOTERIN SP 100ML', '3', '4000', '', '12000', '', '', 'out', 'ordered', 'fullname', '', '2020-03-06 19:26:32', '2020-03-06'),
(19, 'invoice138', '', 'AUGMENTIN NOURISSON SP 30ML', '1', '3500', '', '3500', '', '', 'out', 'ordered', 'fullname', '', '2020-03-06 19:26:32', '2020-03-06'),
(20, 'invoice138', '', 'BRUFEN SP 100ML', '1', '5600', '', '5600', '', '', 'out', 'ordered', 'fullname', '', '2020-03-06 19:26:32', '2020-03-06'),
(24, 'invoice141', '', 'PARACETAMOL SP 60ML', '5', '500', '', '2500', '', '', 'out', 'ordered', 'fullname', '', '2020-04-01 15:56:40', '2020-04-01'),
(25, 'invoice141', '', 'PAIDOTERIN SP 100ML', '4', '4000', '', '16000', '', '', 'out', 'ordered', 'fullname', '', '2020-04-01 15:56:40', '2020-04-01'),
(26, 'invoice141', '', 'POLYGYNAX 12 OVULE', '2', '590', '', '1180', '', '', 'out', 'ordered', 'fullname', '', '2020-04-01 15:56:40', '2020-04-01'),
(27, 'invoice147', '', 'PAIDOTERIN SP 100ML', '4', '4000', '', '16000', '', '', 'out', 'ordered', 'fullname', '', '2020-04-05 19:30:39', '2020-04-05'),
(28, 'invoice147', '', 'CADISTIN SP 100ML', '5', '1000', '', '5000', '', '', 'out', 'ordered', 'fullname', '', '2020-04-05 19:30:39', '2020-04-05'),
(29, 'invoice147', '', 'FLUDITEC SP 2% ENF 125ML', '2', '2800', '', '5600', '', '', 'out', 'ordered', 'fullname', '', '2020-04-05 19:30:39', '2020-04-05'),
(30, 'invoice148', '', 'PAIDOTERIN SP 100ML', '1', '4000', '', '4000', '', '', 'out', 'ordered', 'fullname', 'Rutembesa Elvis', '2020-04-05 19:42:52', '2020-04-05'),
(31, 'Ref_Number148', '', 'AUGMENTIN ENFANT SP 60ML', '4', '6000', 'SXW66', '24000', '', '', 'out', 'ordered', 'fullname', '', '2020-04-05 21:53:23', '2020-04-05'),
(32, 'Ref_Number148', '', 'TERPONE SP 180ML AD', '2', '1', '', '2', '', '', 'out', 'ordered', 'fullname', '', '2020-04-05 19:49:31', '2020-04-05'),
(33, 'invoice150', '', 'ACINET SP 100ML', '4', '3000', '', '12000', '', '', 'out', 'ordered', 'fullname', 'Nyirangarama', '2020-04-05 20:17:24', '2020-04-05'),
(34, 'invoice151', '', 'ACYCLOVIR(UNIVIR) TAB 200MG 30', '1', '1', '', '1', '', '', 'out', 'ordered', 'fullname', '', '2020-04-05 20:23:58', '2020-04-05'),
(35, 'Ref_Number151', '', 'PAIDOTERIN SP 100ML', '5', '4000', '', '20000', '', '', 'out', 'ordered', 'fullname', '', '2020-04-05 20:25:29', '2020-04-05'),
(36, 'Ref_Number151', '', 'AUGMENTIN ENFANT SP 60ML', '4', '6000', 'SXW66', '24000', '', '', 'out', 'ordered', 'fullname', '', '2020-04-05 21:53:23', '2020-04-05'),
(37, 'Ref_Number151', '', 'POSITON 30GR CREME 1 TUBE FAES', '2', '500', '', '1000', '', '', 'out', 'ordered', 'fullname', '', '2020-04-05 20:47:12', '2020-04-05'),
(38, 'Ref_Number153', '', 'CANDID MOUTHPAINT 15ML(CANDI08)', '3', '2300', '', '6900', '', '', 'out', 'ordered', 'fullname', '', '2020-04-05 21:11:34', '2020-04-05'),
(39, 'Ref_Number153', '', 'PAIDOTERIN SP 100ML', '2', '4000', '', '8000', '', '', 'out', 'ordered', 'fullname', '', '2020-04-05 21:11:34', '2020-04-05'),
(40, 'Ref_Number153', '', 'SEKROL SP 15MG 100ML ENFANT', '2', '600', 'xd087', '1200', '', '', 'out', 'ordered', 'fullname', '', '2020-04-05 21:24:28', '2020-04-05'),
(41, 'invoice155', '', 'PAIDOTERIN SP 100ML', '1', '4000', '', '4000', '', '', 'out', 'ordered', 'fullname', '', '2020-04-05 21:42:06', '2020-04-05'),
(42, 'invoice155', '', 'PARACETAMOL SP 100ML', '1', '600', '', '600', '', '', 'out', 'ordered', 'fullname', '', '2020-04-05 21:42:06', '2020-04-05'),
(45, 'Ref_Number156', '', 'AUGMENTIN ENFANT SP 60ML', '4', '6000', 'SXW66', '24000', '', '', 'out', 'ordered', 'fullname', '', '2020-04-05 21:53:23', '2020-04-05'),
(46, 'invoice163', '20526265', 'Test', '22', '300000', '', '6600000', '', '', 'out', 'ordered', 'Rutembesa Elvis Shema', 'mutuzo', '2021-02-18 20:22:53', '2021-02-18'),
(47, 'invoice163', '20526265', 'Test', '1', '300000', '', '300000', '', '', 'out', 'pending', 'Rutembesa Elvis Shema', '', '2021-02-18 20:23:14', '2021-02-18');

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

--
-- Table structure for table `rclienti`
--

CREATE TABLE `rclienti` (
  `id` int(250) NOT NULL,
  `ipaddresse` varchar(250) NOT NULL,
  `fullname` varchar(250) NOT NULL,
  `phone` varchar(250) NOT NULL,
  `remail` varchar(250) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `rclienti`
--

INSERT INTO `rclienti` (`id`, `ipaddresse`, `fullname`, `phone`, `remail`) VALUES
(1, '127.0.0.1', 'Rutembesa Elvis', '0788232323', 'rutembesaelvis@gmail.com');

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

--
-- Table structure for table `readmore`
--

CREATE TABLE `readmore` (
  `id` int(250) NOT NULL,
  `tid` int(250) NOT NULL,
  `photo` varchar(250) NOT NULL,
  `tname` varchar(250) NOT NULL,
  `ndefi` mediumtext NOT NULL,
  `ndescr` mediumtext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `readmore`
--

INSERT INTO `readmore` (`id`, `tid`, `photo`, `tname`, `ndefi`, `ndescr`) VALUES
(2, 12, '92448810_111845733818124_5018556807909312896_n.jpg', 'bbbbbb', 'readmorereadmorereadmorereadmorereadmorereadmorereadmore', 'photophotophotophotophoto1\r\nphotophotophotophoto3\r\nphotophotophoto4');

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

--
-- Table structure for table `services`
--

CREATE TABLE `services` (
  `id` int(250) NOT NULL,
  `photo` varchar(250) NOT NULL,
  `title` varchar(250) NOT NULL,
  `service` varchar(12250) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `services`
--

INSERT INTO `services` (`id`, `photo`, `title`, `service`) VALUES
(1, 'service-temp1.jpg', 'Business Networking and Market Linkages', 'We foster strategic connections between businesses, helping members identify new partners, expand into untapped markets, and strengthen value chains. Through our networking initiatives, we create platforms for collaboration, innovation, and long-term growth in both local and international markets.'),
(2, 'service-temp1.jpg', 'Trade Policy Advocacy for Business Environment Improvement', 'We represent the voice of the private sector in shaping trade and economic policies. By engaging with government and stakeholders, we advocate for reforms that promote a more conducive business environment—reducing barriers, streamlining regulations, and supporting fair, sustainable trade practices.'),
(3, 'service-temp1.jpg', 'Capacity Building for Business Development', 'Our tailored training programs, mentorship initiatives, and technical assistance empower businesses with the skills and knowledge needed to thrive. We focus on entrepreneurship, digital transformation, export readiness, and operational efficiency to support sustainable business development.'),
(4, 'service-temp1.jpg', 'Business Membership Support and Services', 'We offer a range of support services to our members including advisory, compliance guidance, and access to exclusive tools and resources. Our goal is to ensure that businesses receive continuous value through representation, visibility, and facilitation services within the PSF ecosystem.'),
(5, 'service-temp1.jpg', 'Trade Events Organization and Promotion', 'We organize and promote high-impact trade events such as expos, B2B forums, and trade missions. These events serve as vibrant platforms for showcasing products, attracting investment, sharing market intelligence, and forging valuable business relationships across borders.');

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

--
-- Table structure for table `setting`
--

CREATE TABLE `setting` (
  `id` int(250) NOT NULL,
  `company` varchar(250) NOT NULL,
  `taxes` varchar(250) NOT NULL,
  `logo` varchar(250) NOT NULL,
  `location` varchar(250) NOT NULL,
  `phone` varchar(250) NOT NULL,
  `tin` varchar(250) NOT NULL,
  `cemail` varchar(250) NOT NULL,
  `done` varchar(250) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `setting`
--

INSERT INTO `setting` (`id`, `company`, `taxes`, `logo`, `location`, `phone`, `tin`, `cemail`, `done`) VALUES
(1, 'CRESTA COFFE', '18%', '', '8 KN 4 AVE, Kigali-Rwanda', '+250 788 327 895', '000000000', 'Info@crestacoffe.com', 'Rutembesa Elvis Shema');

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

--
-- Table structure for table `stock`
--

CREATE TABLE `stock` (
  `id` int(250) NOT NULL,
  `stock_name` varchar(250) NOT NULL,
  `done` varchar(250) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `stock`
--

INSERT INTO `stock` (`id`, `stock_name`, `done`) VALUES
(1, 'STOCK PRENCIPAL', '');

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

--
-- Table structure for table `supplier`
--

CREATE TABLE `supplier` (
  `id` int(250) NOT NULL,
  `name` varchar(250) NOT NULL,
  `tin` varchar(250) NOT NULL,
  `phone` varchar(250) NOT NULL,
  `email` varchar(250) NOT NULL,
  `location` varchar(250) NOT NULL,
  `done` varchar(250) NOT NULL,
  `date_done` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `supplier`
--

INSERT INTO `supplier` (`id`, `name`, `tin`, `phone`, `email`, `location`, `done`, `date_done`) VALUES
(3, 'Nyirangarama', '11223344556', '0787381418', 'rutembesaelvis2@gmail.com', 'Musanzee', 'fullname', '2019-10-14 02:41:10'),
(4, 'Kababa', '1088885212', '07888888888', 'kaba@gmail.com', 'gisimeti', 'fullname', '2019-12-12 15:32:39'),
(8, 'Rutembesa Elvis', '11223344556', '0787381418', 'rutembesaelvis2@gmail.com', 'Nyamirambo', 'fullname', '2019-12-19 22:37:42'),
(12, 'super', '100000000', '0788888888', 'dfg@gmail.com', 'kicukiro', 'fullname', '2019-12-20 15:14:09'),
(13, 'Sun', '1010', '078883819', 'sun@gmail.com', 'Kigali', 'fullname', '2020-01-31 11:12:05');

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

--
-- Table structure for table `valuemission`
--

CREATE TABLE `valuemission` (
  `id` int(250) NOT NULL,
  `namet` varchar(250) NOT NULL,
  `textc` varchar(1550) NOT NULL,
  `done` varchar(250) NOT NULL,
  `donedate` date NOT NULL,
  `datedone` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `valuemission`
--

INSERT INTO `valuemission` (`id`, `namet`, `textc`, `done`, `donedate`, `datedone`) VALUES
(1, 'Professional conduct Customer focus Accountability Integrity', 'Our Values', 'Professional conduct Customer focus Accountability Integrity', '2020-09-04', '2020-09-04 16:51:52'),
(2, 'Our mission is to simplify complex operations through synergized digital transformation towards customizable software solutions to minimize expenses.', 'Our Mission', 'Our mission is to simplify complex operations through synergized digital transformation towards customizable software solutions to minimize expenses.', '2020-09-04', '2020-09-04 16:53:03'),
(3, 'Our vision is to drive the technology evolution towards a next level in Rwanda and overseas.', 'Our VISION', 'Our vision is to drive the technology evolution towards a next level in Rwanda and overseas.', '2020-09-04', '2020-09-04 16:53:34');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `aboutus`
--
ALTER TABLE `aboutus`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `branch`
--
ALTER TABLE `branch`
  ADD PRIMARY KEY (`branch_id`);

--
-- Indexes for table `businessdirectory`
--
ALTER TABLE `businessdirectory`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `category`
--
ALTER TABLE `category`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `chat_message`
--
ALTER TABLE `chat_message`
  ADD PRIMARY KEY (`chat_message_id`);

--
-- Indexes for table `clients`
--
ALTER TABLE `clients`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `contactm`
--
ALTER TABLE `contactm`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `customer`
--
ALTER TABLE `customer`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `donate`
--
ALTER TABLE `donate`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `exrequest`
--
ALTER TABLE `exrequest`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `history_log`
--
ALTER TABLE `history_log`
  ADD PRIMARY KEY (`log_id`);

--
-- Indexes for table `hslide`
--
ALTER TABLE `hslide`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `icart`
--
ALTER TABLE `icart`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `icauses`
--
ALTER TABLE `icauses`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `invoice`
--
ALTER TABLE `invoice`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `iphoto`
--
ALTER TABLE `iphoto`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `items`
--
ALTER TABLE `items`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `login_details`
--
ALTER TABLE `login_details`
  ADD PRIMARY KEY (`login_details_id`);

--
-- Indexes for table `measurement`
--
ALTER TABLE `measurement`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `order_status`
--
ALTER TABLE `order_status`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `orequest`
--
ALTER TABLE `orequest`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `paintt`
--
ALTER TABLE `paintt`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `payment`
--
ALTER TABLE `payment`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `photo`
--
ALTER TABLE `photo`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `pmethod`
--
ALTER TABLE `pmethod`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `projects`
--
ALTER TABLE `projects`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `purchase`
--
ALTER TABLE `purchase`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `rclienti`
--
ALTER TABLE `rclienti`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `readmore`
--
ALTER TABLE `readmore`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `services`
--
ALTER TABLE `services`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `setting`
--
ALTER TABLE `setting`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `stock`
--
ALTER TABLE `stock`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `supplier`
--
ALTER TABLE `supplier`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `valuemission`
--
ALTER TABLE `valuemission`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `aboutus`
--
ALTER TABLE `aboutus`
  MODIFY `id` int(250) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `branch`
--
ALTER TABLE `branch`
  MODIFY `branch_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `businessdirectory`
--
ALTER TABLE `businessdirectory`
  MODIFY `id` int(250) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `category`
--
ALTER TABLE `category`
  MODIFY `id` int(250) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `chat_message`
--
ALTER TABLE `chat_message`
  MODIFY `chat_message_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `clients`
--
ALTER TABLE `clients`
  MODIFY `id` int(250) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `contactm`
--
ALTER TABLE `contactm`
  MODIFY `id` int(250) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `customer`
--
ALTER TABLE `customer`
  MODIFY `id` int(250) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `donate`
--
ALTER TABLE `donate`
  MODIFY `id` int(250) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `exrequest`
--
ALTER TABLE `exrequest`
  MODIFY `id` int(250) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `history_log`
--
ALTER TABLE `history_log`
  MODIFY `log_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=50;

--
-- AUTO_INCREMENT for table `hslide`
--
ALTER TABLE `hslide`
  MODIFY `id` int(250) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `icart`
--
ALTER TABLE `icart`
  MODIFY `id` int(250) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `icauses`
--
ALTER TABLE `icauses`
  MODIFY `id` int(250) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `invoice`
--
ALTER TABLE `invoice`
  MODIFY `id` int(250) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=169;

--
-- AUTO_INCREMENT for table `iphoto`
--
ALTER TABLE `iphoto`
  MODIFY `id` int(250) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `items`
--
ALTER TABLE `items`
  MODIFY `id` int(250) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

--
-- AUTO_INCREMENT for table `login_details`
--
ALTER TABLE `login_details`
  MODIFY `login_details_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `measurement`
--
ALTER TABLE `measurement`
  MODIFY `id` int(250) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `order_status`
--
ALTER TABLE `order_status`
  MODIFY `id` int(250) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `orequest`
--
ALTER TABLE `orequest`
  MODIFY `id` int(250) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `paintt`
--
ALTER TABLE `paintt`
  MODIFY `id` int(250) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `payment`
--
ALTER TABLE `payment`
  MODIFY `id` int(250) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=34;

--
-- AUTO_INCREMENT for table `photo`
--
ALTER TABLE `photo`
  MODIFY `id` int(250) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `pmethod`
--
ALTER TABLE `pmethod`
  MODIFY `id` int(250) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `projects`
--
ALTER TABLE `projects`
  MODIFY `id` int(250) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=82;

--
-- AUTO_INCREMENT for table `purchase`
--
ALTER TABLE `purchase`
  MODIFY `id` int(250) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=48;

--
-- AUTO_INCREMENT for table `rclienti`
--
ALTER TABLE `rclienti`
  MODIFY `id` int(250) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `readmore`
--
ALTER TABLE `readmore`
  MODIFY `id` int(250) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `services`
--
ALTER TABLE `services`
  MODIFY `id` int(250) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `setting`
--
ALTER TABLE `setting`
  MODIFY `id` int(250) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `stock`
--
ALTER TABLE `stock`
  MODIFY `id` int(250) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `supplier`
--
ALTER TABLE `supplier`
  MODIFY `id` int(250) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `valuemission`
--
ALTER TABLE `valuemission`
  MODIFY `id` int(250) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
COMMIT;

