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

START TRANSACTION;



--
-- Database: `anes`
--

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

--
-- Table structure for table `accounts`
--

CREATE TABLE `accounts` (
  `ACC_ID` int(11) NOT NULL,
  `FIRST_NAME` varchar(255) NOT NULL,
  `SECOND_NAME` varchar(255) NOT NULL,
  `USER_EMAIL` varchar(255) NOT NULL,
  `BASE_CURRENCY_ID` int(11) NOT NULL,
  `COUNTRY_ID` int(11) NOT NULL,
  `PHONE_NO` varchar(255) NOT NULL,
  `USER_ADDRESS` varchar(1000) NOT NULL,
  `BUSSINESS_NAME` varchar(300) NOT NULL,
  `USER_PASSWORD` varchar(255) NOT NULL,
  `NIN_NO` varchar(255) NOT NULL,
  `ID_FRONT_PIC` varchar(300) NOT NULL,
  `ID_BACK_PIC` varchar(300) NOT NULL,
  `PROFILE_PICTURE` varchar(255) NOT NULL,
  `COVER_PHOTO` varchar(255) NOT NULL,
  `REG_DATE` date NOT NULL,
  `USER_IP` varchar(255) NOT NULL,
  `ACC_TYPE_ID` int(11) NOT NULL,
  `IS_TERMINATED` tinyint(1) NOT NULL,
  `IS_VERIFIED` tinyint(1) NOT NULL,
  `IS_EMAIL_VALIDATED` tinyint(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `accounts`
--

INSERT INTO `accounts` (`ACC_ID`, `FIRST_NAME`, `SECOND_NAME`, `USER_EMAIL`, `BASE_CURRENCY_ID`, `COUNTRY_ID`, `PHONE_NO`, `USER_ADDRESS`, `BUSSINESS_NAME`, `USER_PASSWORD`, `NIN_NO`, `ID_FRONT_PIC`, `ID_BACK_PIC`, `PROFILE_PICTURE`, `COVER_PHOTO`, `REG_DATE`, `USER_IP`, `ACC_TYPE_ID`, `IS_TERMINATED`, `IS_VERIFIED`, `IS_EMAIL_VALIDATED`) VALUES
(9, 'trader', 'amtrader', 'trader@agricnewsexpo.com', 1, 1, '0779697569', 'Kampala uganda, Matugga', 'Tom & sons', 'ef797c8118f02dfb649607dd5d3f8c7623048c9c063d532cc95c5ed7a898a64f', '', 'font2_b59ffbc43136827b43007b926f68fb13.png', 'back3_ea5b66d105bdfb093acb994bab9d1d2b.png', 'default_profile.jpg', 'default_cover.png', '2020-07-16', '::1', 2, 0, 0, 0),
(12, 'Kent', 'janner', 'admin1@agricnewsexpo.com', 1, 2, '0756743152', 'Wakiso, Matugga', 'Kent farm', 'ef797c8118f02dfb649607dd5d3f8c7623048c9c063d532cc95c5ed7a898a64f', '', 'font2_b59ffbc43136827b43007b926f68fb13.png', 'back3_ea5b66d105bdfb093acb994bab9d1d2b.png', 'default_profile.jpg', 'default_cover.png', '2020-11-02', '::1', 3, 0, 0, 0),
(13, 'henry', 'jimmy', 'kigezifarm@gmail.com', 1, 1, '0756743675', 'Kigezi, jinja', 'Kigezi farm', 'ef797c8118f02dfb649607dd5d3f8c7623048c9c063d532cc95c5ed7a898a64f', 'CM5655556567LL', 'font2_b59ffbc43136827b43007b926f68fb13.png', 'back3_ea5b66d105bdfb093acb994bab9d1d2b.png', 'default_profile.jpg', 'default_cover.png', '2020-11-02', '::1', 1, 0, 1, 0),
(14, 'Musa', 'Body', 'musabody@gmail.com', 1, 1, '0756764567', 'kawempe, kampala', 'Musa Body Machinery', 'ef797c8118f02dfb649607dd5d3f8c7623048c9c063d532cc95c5ed7a898a64f', 'CM5655556567LL', 'IMG_20180222_021034_8f159ea16ad0f36be77714fc8ab1dcae.jpg', 'IMG_20180222_023257-back_767ffbe785f4389dd895e72b222081fa.jpg', 'default_profile.jpg', 'default_cover.png', '2021-07-15', '::1', 1, 0, 1, 0),
(16, 'walulya', 'francis', 'example@gmail.com', 1, 1, '0756745656', 'kawempe, kampala', 'example2@gmail.com', 'ef797c8118f02dfb649607dd5d3f8c7623048c9c063d532cc95c5ed7a898a64f', '', '', '', 'default_profile.jpg', 'default_cover.png', '2021-08-06', '::1', 1, 0, 0, 0);

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

--
-- Table structure for table `account_types`
--

CREATE TABLE `account_types` (
  `ACC_TYPE_ID` int(11) NOT NULL,
  `ACC_TYPE_NAME` varchar(255) NOT NULL,
  `USE_ACC` tinyint(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `account_types`
--

INSERT INTO `account_types` (`ACC_TYPE_ID`, `ACC_TYPE_NAME`, `USE_ACC`) VALUES
(1, 'exhibitor', 1),
(2, 'buyer', 1),
(3, 'admin', 1);

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

--
-- Table structure for table `adminstrator`
--

CREATE TABLE `adminstrator` (
  `ADMIN_ID` int(11) NOT NULL,
  `FIRST_NAME` varchar(255) NOT NULL,
  `SECOND_NAME` varchar(255) NOT NULL,
  `USER_NAME` varchar(255) NOT NULL,
  `ADMIN_EMAIL` varchar(255) NOT NULL,
  `ADMIN_PASSWORD` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `adminstrator`
--

INSERT INTO `adminstrator` (`ADMIN_ID`, `FIRST_NAME`, `SECOND_NAME`, `USER_NAME`, `ADMIN_EMAIL`, `ADMIN_PASSWORD`) VALUES
(1, 'Otim', 'Denis', 'admin1', 'admin1@agricnewsexpo.com', 'ef797c8118f02dfb649607dd5d3f8c7623048c9c063d532cc95c5ed7a898a64f');

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

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

CREATE TABLE `category` (
  `cat_id` int(11) NOT NULL,
  `cat_icon_image` varchar(300) NOT NULL,
  `en_cat_name` varchar(255) NOT NULL,
  `lug_cat_name` varchar(255) NOT NULL,
  `kis_cat_name` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

INSERT INTO `category` (`cat_id`, `cat_icon_image`, `en_cat_name`, `lug_cat_name`, `kis_cat_name`) VALUES
(1, 'fa-envira', 'Vegetables', 'Vegetables', 'Vegetables'),
(2, 'fa-money', 'Cash Crops', 'Cash Crops', 'Cash Crops'),
(3, ' fa-bomb', 'Fruits', 'Ebibala', 'Fruits'),
(4, 'fa-coffee', 'Food crops', 'Food crops', 'Food crops'),
(5, ' fa-rebel', 'Poultry', 'Poultry', 'Poultry'),
(6, ' fa-qq', 'LiveStock', 'Ebisolo', 'LiveStock'),
(7, 'fa-wrench', 'Farm equipments', 'Farm equipments', 'Farm equipments'),
(8, 'fa-organic', 'Fertilizers', 'Fertilizers', 'Fertilizers'),
(9, '', 'Farm machinery', 'Farm machinery', 'Farm machinery');

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

--
-- Table structure for table `languages`
--

CREATE TABLE `languages` (
  `lang_id` int(11) NOT NULL,
  `lang_iso_code` varchar(255) NOT NULL,
  `lang_name` varchar(255) NOT NULL,
  `use_lang` tinyint(1) NOT NULL,
  `isDefault` tinyint(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `languages`
--

INSERT INTO `languages` (`lang_id`, `lang_iso_code`, `lang_name`, `use_lang`, `isDefault`) VALUES
(1, 'en', 'English', 1, 1),
(2, 'lug', 'Luganda', 1, 0),
(3, 'sw', 'Kiswahili', 1, 0);

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

--
-- Table structure for table `language_config`
--

CREATE TABLE `language_config` (
  `config_id` int(11) NOT NULL,
  `acc_id` int(11) NOT NULL,
  `user_ip` varchar(255) NOT NULL,
  `lang_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `messages`
--

CREATE TABLE `messages` (
  `msgid` int(11) NOT NULL,
  `order_id` int(11) NOT NULL,
  `user1` int(20) NOT NULL,
  `user2` int(20) NOT NULL,
  `message` varchar(5000) NOT NULL,
  `msg_datetime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `msg_read` tinyint(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `messages`
--

INSERT INTO `messages` (`msgid`, `order_id`, `user1`, `user2`, `message`, `msg_datetime`, `msg_read`) VALUES
(10, 11, 9, 1, 'hi\n', '2020-11-06 13:53:51', 0),
(11, 11, 1, 9, 'Hello, customer how are you', '2020-11-06 13:54:11', 0),
(12, 11, 9, 1, 'am alright', '2020-11-06 13:54:31', 0),
(13, 11, 1, 9, 'So how may i help you', '2020-11-06 13:54:50', 0),
(14, 11, 9, 1, 'i need 10 bags of water melon ASAP!\n', '2020-11-06 13:59:38', 0),
(15, 11, 1, 9, 'okay, we have all your order sir', '2020-11-06 14:00:19', 0),
(16, 11, 9, 1, 'can it be delivered in ntugamo', '2020-11-06 14:00:52', 0),
(17, 11, 1, 9, 'off course, in 2 hours we will be there, you can pay chash on delivery', '2020-11-06 14:01:37', 0),
(18, 2, 1, 9, 'good morning', '2020-11-06 17:44:30', 0),
(19, 11, 9, 1, 'okay', '2020-11-06 22:35:12', 0),
(20, 2, 9, 1, 'good morning', '2020-11-06 22:36:04', 0),
(21, 2, 9, 1, 'how are  you sir', '2020-11-06 22:36:17', 0),
(22, 2, 1, 9, 'am alright', '2020-11-06 22:51:16', 0),
(23, 2, 9, 1, 'okay', '2020-11-07 01:33:24', 0),
(24, 2, 1, 9, 'hi\n', '2020-11-07 01:33:59', 0),
(25, 14, 9, 1, 'hi\n', '2020-11-10 15:45:52', 0),
(26, 14, 1, 9, 'hey', '2020-11-10 15:46:02', 0),
(27, 14, 9, 1, 'BJBVCOKJNKVKPHKGF', '2021-06-14 14:54:32', 0),
(28, 14, 9, 1, 'BJBVCOKJNKVKPHKGF<div><br></div>', '2021-06-14 14:54:32', 0),
(29, 14, 9, 1, 'VUXZKJFCSFIDS', '2021-06-14 14:54:36', 0),
(30, 14, 9, 1, 'FG9FDGR0', '2021-06-14 14:54:40', 0),
(31, 14, 9, 1, 'GF87FHGGF', '2021-06-14 14:54:43', 0),
(32, 14, 9, 1, 'G8HFDIUGIF', '2021-06-14 14:54:46', 0),
(33, 14, 9, 1, 'GNFKJNGKF', '2021-06-14 14:54:48', 0),
(34, 17, 9, 1, '\n', '2021-06-14 14:57:03', 0),
(35, 17, 9, 1, 'HI', '2021-06-14 14:57:14', 0);

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

--
-- Table structure for table `orders`
--

CREATE TABLE `orders` (
  `order_id` int(11) NOT NULL,
  `farmer_id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `stock_units_required` int(255) NOT NULL,
  `order_description` varchar(500) NOT NULL,
  `trader_id` int(11) NOT NULL,
  `seen` tinyint(1) NOT NULL,
  `order_date_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `confirmed` tinyint(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `orders`
--

INSERT INTO `orders` (`order_id`, `farmer_id`, `product_id`, `stock_units_required`, `order_description`, `trader_id`, `seen`, `order_date_time`, `confirmed`) VALUES
(2, 1, 3, 10, 'I need 10 of yor product', 9, 1, '2020-11-02 23:19:25', 1),
(11, 1, 4, 10, 'good wat', 9, 0, '2020-11-05 12:38:27', 1),
(14, 1, 3, 12, 'hjdgejdgjewhdkjwk', 9, 0, '2020-11-10 15:43:50', 1),
(17, 1, 4, 100, 'i need 100 pieces water melon', 9, 0, '2020-11-10 23:59:27', 1);

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

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

CREATE TABLE `products` (
  `product_id` int(11) NOT NULL,
  `product_no` varchar(255) NOT NULL,
  `ACC_ID` int(11) NOT NULL,
  `en_product_name` varchar(3000) NOT NULL,
  `lug_product_name` varchar(3000) NOT NULL,
  `sw_product_name` varchar(3000) NOT NULL,
  `cat_id` int(11) NOT NULL,
  `sold_in_units_id` int(11) NOT NULL,
  `stock_units` int(100) NOT NULL,
  `price_per_unit` int(255) NOT NULL,
  `min_unit_order` int(255) NOT NULL,
  `currency_id` int(11) NOT NULL,
  `en_product_description` varchar(5000) NOT NULL,
  `lug_product_description` varchar(5000) NOT NULL,
  `sw_product_description` varchar(5000) NOT NULL,
  `product_thumbnail` varchar(3000) NOT NULL,
  `creation_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `last_modification_date` datetime NOT NULL,
  `show_product` tinyint(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

INSERT INTO `products` (`product_id`, `product_no`, `ACC_ID`, `en_product_name`, `lug_product_name`, `sw_product_name`, `cat_id`, `sold_in_units_id`, `stock_units`, `price_per_unit`, `min_unit_order`, `currency_id`, `en_product_description`, `lug_product_description`, `sw_product_description`, `product_thumbnail`, `creation_date`, `last_modification_date`, `show_product`) VALUES
(3, 'PR-707176', 14, 'tomatoes', '', '', 1, 1, 100, 200000, 1, 1, 'Fruity fresh tomatoes', '', '', 'tomatoes_helios4eos_gettyimages-edit_346d0ada432ead07f4aa89322f2ae339_1b81b825438e12ca862e80a44c89c7e8.jpeg', '2020-11-01 07:37:05', '2020-11-01 07:37:05', 1),
(4, 'PR-949922', 14, 'Watermelon', '', '', 3, 3, 500, 10000, 10, 1, 'Good looking pineapples', '', '', 'FD002329-56a6d3133df78cf772906f1d_cff1f27823cccd5e3e42ba96b21d5a30_9e3b89df1b993e2d8cd32b84aa9a5c4e.jpg', '2020-11-01 07:44:43', '2020-11-01 07:44:43', 1),
(5, 'PR-261715', 14, 'Passion fruits', '', '', 3, 3, 100, 300000, 10, 1, 'Fresh passion fruits', '', '', 'passion_fruit_2_20597490683e8c86ae067aa17bf2b69b_a72c6651780a156d4f79b3975508d09a.jpg', '2020-11-01 07:48:21', '2020-11-01 07:48:21', 1),
(6, 'PR-9330', 14, 'Irish potatoes', '', '', 4, 1, 400, 400000, 5, 1, 'productivity irish potatoes', '', '', 'potato-farming-in-Kenya-768x759_361be1c64b13a5ff73bc316379bf46e9_627a9aade78f031d921139c71e450168.jpg', '2020-11-01 07:54:56', '2020-11-01 07:54:56', 1),
(7, 'PR-620414', 14, 'Sweet potatoes', '', '', 4, 1, 5000, 150000, 100, 1, 'good looking maize', '', '', 'Sweet-potatoes-GettyImages-592411298-58bc9a215f9b58af5cc1ae4f_76b8fdc1f385c13f19b14f51791e2e94.jpg', '2020-11-01 08:10:27', '2020-11-01 08:10:27', 1),
(8, 'PR-697974', 14, 'Pineapple', '', '', 3, 1, 100, 200000, 10, 1, 'This is good', '', '', 'pineapple_53f52d26980bae606c37ce213ce34764.jpg', '2020-11-01 08:49:43', '2020-11-01 08:49:43', 1),
(9, 'PR-934734', 14, 'jersey cattle', '', '', 6, 3, 200, 2000000, 1, 1, 'good cows in good condition', '', '', 'cattle_f981f6b85d2fe7049cfc097a9d9622b8.jpg', '2020-11-01 09:17:43', '2020-11-01 09:17:43', 1),
(10, 'PR-239489', 14, 'Arabic coffee', '', '', 2, 1, 1000, 800000, 5, 1, 'Quality araboic coffee with good seeds', '', '', 'coffee_drying_kenya_9270d2b541d8757adfd4229e84027666.jpg', '2020-11-01 10:49:16', '2020-11-01 10:49:16', 1),
(11, 'PR-82395', 14, 'Maize', '', '', 4, 1, 80, 600000, 2, 1, 'This is good maize', '', '', 'maize_28265f1c2b4edc3d68163ef658452d05.jpg', '2020-11-01 11:35:29', '2020-11-01 11:35:29', 1),
(12, 'PR-106968', 14, 'Solar irrigation pump', '', '', 7, 3, 100, 2000000, 2, 1, 'Solar irrigation pump for your crops', '', '', 'Solarpump-1_73cafc0ee23187ff99c0984449c13b59.jpg', '2021-07-14 22:40:46', '2021-07-14 22:40:46', 1),
(13, 'PR-251777', 14, 'Tracktor water pump', '', '', 7, 3, 300, 5000000, 1, 1, 'its a good machine', '', '', 'Tractor-water-pumps_3fc5695fcc0e4ab38544e0d5153c94ab.jpg', '2021-07-15 01:13:17', '2021-07-15 01:13:17', 1),
(14, 'PR-961355', 14, 'Maize haller', '', '', 7, 3, 200, 1500000, 2, 1, 'Maize haller ', '', '', 'Maize-haller_629e46e39596b4e1f05740f7ed1cc281.png', '2021-07-15 09:20:48', '2021-07-15 09:20:48', 1),
(15, 'PR-195646', 14, 'Shaft cutter', '', '', 1, 3, 25, 3000000, 1, 1, 'Animal feeds  shaft cutter', '', '', 'shaf-cutter2_62c949565ba8f06653d32cecf71fb8a0.png', '2021-07-15 09:29:53', '2021-07-15 09:29:53', 1),
(16, 'PR-794231', 14, 'Ground nuts miller', '', '', 9, 3, 25, 1200000, 1, 1, 'Ground nuts grinder ', '', '', 'ground-nauts-miller_c94faadc18588c1838c178b55b4dfe4d.png', '2021-07-15 09:50:36', '2021-07-15 09:50:36', 1);

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

--
-- Table structure for table `product_details`
--

CREATE TABLE `product_details` (
  `product_detail_id` int(11) NOT NULL,
  `product_no` varchar(255) NOT NULL,
  `en_product_details` mediumtext NOT NULL,
  `lug_product_details` mediumtext NOT NULL,
  `sw_product_details` mediumtext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `product_details`
--

INSERT INTO `product_details` (`product_detail_id`, `product_no`, `en_product_details`, `lug_product_details`, `sw_product_details`) VALUES
(1, 'PR-61989', 'casssav cassava', '', ''),
(2, 'PR-201200', 'Each piece is l00kg sack', '', ''),
(3, 'PR-707176', '1 box is worthy UGX.200000', '', ''),
(4, 'PR-949922', 'This is a good pineapple', '', ''),
(5, 'PR-261715', 'Good passion fruits', '', ''),
(6, 'PR-9330', 'good irish potatoes', '', ''),
(7, 'PR-620414', 'this is nice', '', ''),
(8, 'PR-697974', 'this is the good', '', ''),
(9, 'PR-934734', 'good cows is is very good', '', ''),
(10, 'PR-239489', '1 Tone is 100kg', '', ''),
(11, 'PR-82395', 'It is a maize', '', ''),
(12, 'PR-106968', 'Litres: 200 litrers pre minute; HP: 20hp', '', ''),
(13, 'PR-251777', 'good condtion', '', ''),
(14, 'PR-961355', '2 house power; 240 v', '', ''),
(15, 'PR-195646', '100 hp; Desiel engine; ', '', ''),
(16, 'PR-794231', 'farm machinery', '', '');

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

--
-- Table structure for table `product_images`
--

CREATE TABLE `product_images` (
  `image_id` int(11) NOT NULL,
  `product_no` varchar(255) NOT NULL,
  `image_name` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `product_images`
--

INSERT INTO `product_images` (`image_id`, `product_no`, `image_name`) VALUES
(1, 'PR-61989', '2-1Q022163545F2_270c2e02dc4b92ad90d399983e57d814.jpg'),
(2, 'PR-201200', 'eggplant_c58087202266aa0217d12ede19544410.jpg'),
(3, 'PR-707176', 'tomatoes_helios4eos_gettyimages-edit_346d0ada432ead07f4aa89322f2ae339_1b81b825438e12ca862e80a44c89c7e8.jpeg'),
(4, 'PR-949922', 'FD002329-56a6d3133df78cf772906f1d_cff1f27823cccd5e3e42ba96b21d5a30_9e3b89df1b993e2d8cd32b84aa9a5c4e.jpg'),
(5, 'PR-261715', 'passion_fruit_2_20597490683e8c86ae067aa17bf2b69b_a72c6651780a156d4f79b3975508d09a.jpg'),
(6, 'PR-9330', 'potato-farming-in-Kenya-768x759_361be1c64b13a5ff73bc316379bf46e9_627a9aade78f031d921139c71e450168.jpg'),
(7, 'PR-620414', 'Sweet-potatoes-GettyImages-592411298-58bc9a215f9b58af5cc1ae4f_76b8fdc1f385c13f19b14f51791e2e94.jpg'),
(8, 'PR-697974', 'pineapple_53f52d26980bae606c37ce213ce34764.jpg'),
(9, 'PR-934734', 'cattle_f981f6b85d2fe7049cfc097a9d9622b8.jpg'),
(10, 'PR-239489', 'coffee_drying_kenya_9270d2b541d8757adfd4229e84027666.jpg'),
(11, 'PR-239489', 'Kona-King-Coffee-Farm_680a10b46444b34d55412c92fe35e032.jpg'),
(12, 'PR-82395', 'maize_28265f1c2b4edc3d68163ef658452d05.jpg'),
(13, 'PR-106968', 'Solarpump-1_73cafc0ee23187ff99c0984449c13b59.jpg'),
(14, 'PR-251777', 'Tractor-water-pumps_3fc5695fcc0e4ab38544e0d5153c94ab.jpg'),
(15, 'PR-961355', 'Maize-haller_629e46e39596b4e1f05740f7ed1cc281.png'),
(16, 'PR-195646', 'shaf-cutter2_62c949565ba8f06653d32cecf71fb8a0.png'),
(17, 'PR-794231', 'ground-nauts-miller_c94faadc18588c1838c178b55b4dfe4d.png');

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

--
-- Table structure for table `product_units`
--

CREATE TABLE `product_units` (
  `unit_id` int(11) NOT NULL,
  `en_unit_name` varchar(255) NOT NULL,
  `lug_unit_name` varchar(255) NOT NULL,
  `sw_unit_name` varchar(255) NOT NULL,
  `unit_symbol` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `product_units`
--

INSERT INTO `product_units` (`unit_id`, `en_unit_name`, `lug_unit_name`, `sw_unit_name`, `unit_symbol`) VALUES
(1, 'Tone(s)', 'Tani', 'Tone(s)', 'Tone'),
(2, 'Kilogram(s)', 'Kilo', 'Kilogram(s)', 'kg'),
(3, 'piece(s)', 'piece(s)', 'piece(s)', 'piece');

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

--
-- Table structure for table `sliderads`
--

CREATE TABLE `sliderads` (
  `AD_ID` int(11) NOT NULL,
  `BIG_HEADING` varchar(500) NOT NULL,
  `AD_BODY_TEXT` varchar(3000) NOT NULL,
  `AD_IMAGE` varchar(500) NOT NULL,
  `BTN_LINK` varchar(600) NOT NULL,
  `POST_DATE` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sliderads`
--

INSERT INTO `sliderads` (`AD_ID`, `BIG_HEADING`, `AD_BODY_TEXT`, `AD_IMAGE`, `BTN_LINK`, `POST_DATE`) VALUES
(2, 'Exhibit Your Agriculture Products &amp; Equipmentd For Free', 'Join the market of thousands of exhibitors &amp; buyers around the country', 'banner-02.jpg', 'register.php', '2021-08-09 09:20:42'),
(3, 'Cheap Solar Pumps Are Now Affordable', 'Agric engineering companies have decided to cut prices of solar pumps to enable farmers enjoy profits in there agriculture produce', 'Solarpump-1_73cafc0ee23187ff99c0984449c13b59_5a4ccc9167b3ce8866d8631cd3d62d75.jpg', '', '2021-08-09 09:20:42');

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

--
-- Table structure for table `supported_countries`
--

CREATE TABLE `supported_countries` (
  `country_id` int(11) NOT NULL,
  `country_name` varchar(255) NOT NULL,
  `country_iso_code` varchar(255) NOT NULL,
  `used_currency_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `supported_countries`
--

INSERT INTO `supported_countries` (`country_id`, `country_name`, `country_iso_code`, `used_currency_id`) VALUES
(1, 'Uganda', 'UG', 1);

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

--
-- Table structure for table `supported_currency`
--

CREATE TABLE `supported_currency` (
  `currency_id` int(11) NOT NULL,
  `currency_iso_code` varchar(255) NOT NULL,
  `currency_symbol` varchar(255) NOT NULL,
  `inUse` tinyint(1) NOT NULL,
  `prefixed` tinyint(1) NOT NULL,
  `indented` tinyint(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `supported_currency`
--

INSERT INTO `supported_currency` (`currency_id`, `currency_iso_code`, `currency_symbol`, `inUse`, `prefixed`, `indented`) VALUES
(1, 'UGX', 'Ush', 1, 0, 1);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `accounts`
--
ALTER TABLE `accounts`
  ADD PRIMARY KEY (`ACC_ID`);

--
-- Indexes for table `account_types`
--
ALTER TABLE `account_types`
  ADD PRIMARY KEY (`ACC_TYPE_ID`);

--
-- Indexes for table `adminstrator`
--
ALTER TABLE `adminstrator`
  ADD PRIMARY KEY (`ADMIN_ID`);

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

--
-- Indexes for table `languages`
--
ALTER TABLE `languages`
  ADD PRIMARY KEY (`lang_id`);

--
-- Indexes for table `language_config`
--
ALTER TABLE `language_config`
  ADD PRIMARY KEY (`config_id`);

--
-- Indexes for table `messages`
--
ALTER TABLE `messages`
  ADD PRIMARY KEY (`msgid`);

--
-- Indexes for table `orders`
--
ALTER TABLE `orders`
  ADD PRIMARY KEY (`order_id`);

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

--
-- Indexes for table `product_details`
--
ALTER TABLE `product_details`
  ADD PRIMARY KEY (`product_detail_id`);

--
-- Indexes for table `product_images`
--
ALTER TABLE `product_images`
  ADD PRIMARY KEY (`image_id`);

--
-- Indexes for table `product_units`
--
ALTER TABLE `product_units`
  ADD PRIMARY KEY (`unit_id`);

--
-- Indexes for table `sliderads`
--
ALTER TABLE `sliderads`
  ADD PRIMARY KEY (`AD_ID`);

--
-- Indexes for table `supported_countries`
--
ALTER TABLE `supported_countries`
  ADD PRIMARY KEY (`country_id`);

--
-- Indexes for table `supported_currency`
--
ALTER TABLE `supported_currency`
  ADD PRIMARY KEY (`currency_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `accounts`
--
ALTER TABLE `accounts`
  MODIFY `ACC_ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

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

--
-- AUTO_INCREMENT for table `adminstrator`
--
ALTER TABLE `adminstrator`
  MODIFY `ADMIN_ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `category`
--
ALTER TABLE `category`
  MODIFY `cat_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

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

--
-- AUTO_INCREMENT for table `language_config`
--
ALTER TABLE `language_config`
  MODIFY `config_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `messages`
--
ALTER TABLE `messages`
  MODIFY `msgid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=36;

--
-- AUTO_INCREMENT for table `orders`
--
ALTER TABLE `orders`
  MODIFY `order_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;

--
-- AUTO_INCREMENT for table `products`
--
ALTER TABLE `products`
  MODIFY `product_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

--
-- AUTO_INCREMENT for table `product_details`
--
ALTER TABLE `product_details`
  MODIFY `product_detail_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

--
-- AUTO_INCREMENT for table `product_images`
--
ALTER TABLE `product_images`
  MODIFY `image_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;

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

--
-- AUTO_INCREMENT for table `sliderads`
--
ALTER TABLE `sliderads`
  MODIFY `AD_ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `supported_countries`
--
ALTER TABLE `supported_countries`
  MODIFY `country_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `supported_currency`
--
ALTER TABLE `supported_currency`
  MODIFY `currency_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
COMMIT;

