-- phpMyAdmin SQL Dump
-- version 5.1.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1:3306
-- Generation Time: Jun 05, 2023 at 05:59 PM
-- Server version: 5.7.36
-- PHP Version: 7.4.26

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: `new_app`
--

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

--
-- Table structure for table `op_customers`
--

DROP TABLE IF EXISTS `op_customers`;
CREATE TABLE IF NOT EXISTS `op_customers` (
  `customerid` int(11) NOT NULL AUTO_INCREMENT,
  `customer` varchar(65) NOT NULL,
  `address` longtext NOT NULL,
  `phone` varchar(23) DEFAULT NULL,
  `fax` varchar(23) DEFAULT NULL,
  `email` varchar(65) DEFAULT NULL,
  `taxable` varchar(1) DEFAULT NULL,
  `notes` longtext,
  `datetime` datetime NOT NULL,
  `contact_person` varchar(45) DEFAULT NULL,
  `nic` varchar(45) NOT NULL,
  `occupation` varchar(45) DEFAULT NULL,
  `mobile` varchar(23) DEFAULT NULL,
  PRIMARY KEY (`customerid`)
) ENGINE=InnoDB AUTO_INCREMENT=154 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `op_customers`
--

INSERT INTO `op_customers` (`customerid`, `customer`, `address`, `phone`, `fax`, `email`, `taxable`, `notes`, `datetime`, `contact_person`, `nic`, `occupation`, `mobile`) VALUES
(1, 'Gerard Roussel', 'Bois Pignolet', '2495824', '7654321', 'r.jonathancedric@gmail.com', 'N', 'XXX', '2023-04-16 13:38:00', 'Cedric', 'R2206894620016', 'Associate Programmer', '58270035'),
(2, 'SMITA RAMLUGUN', 'ROYAL ROAD, MORCELLEMENT SAINT ANDRE, POSTAL CODE 20903', '57895664', '', '', 'N', '', '2020-08-21 08:08:36', '', 'P141088060144B', '', '45214526'),
(3, 'Ranjeev BOODNAH', 'Royal Road, Roche Terre, Grand Gaube Postal Code 32002', '1234', '', '', 'N', '', '2020-08-24 07:29:21', '', 'B180770100169G', '', '12345678'),
(4, 'BHOOMY NATURAL THERAPY MASSAGE CENTRE LTD', 'Francois Mitterand Street, Centre de Flacq, Postal Code 80205', '12345123', '', '', 'N', '', '2020-08-24 11:22:13', '', '12341233664', '', '12543125'),
(5, 'OK SANG BENOIT JONATHAN SHIAN FONG TSAND', '11 Saint Martin Street, Roche Bois, PORT LOUIS Postal Code 11703', '1234123', '', '', 'N', '', '2020-08-26 05:56:01', '', 'T0312892800139', '', '12341234'),
(6, 'Mrs PAMELA MURUGAN', 'Temple Lane, Solitude, TRIOLET, Postal Code 21507', '9999999', '', '', 'N', '1026', '2020-08-26 07:24:49', '', 'M2910732501460', '', '9999999'),
(7, 'Mr. Kisnah CUNTHEN', 'Royal Road, St Julien Village, Postal Code 41901', '99999999', '', '', 'N', '1027', '2020-08-26 07:45:15', '', 'C261155140003G', 'Taxi Owner', '99999999999'),
(8, 'Mr. Devendranath RAMSAHA', 'Rishi Dayanand Lane, Mare La Chaux, Postal Code 41101', '99999999', '', '', 'N', '1028', '2020-08-26 08:09:28', '', 'R241159131198D', 'Civil Servant', '999999'),
(9, 'Mr. Manoj SEEPAUL', 'Morc Purgass, Tagore Road, Fond du Sac, Postal Code 20602', '9999999', '', '', 'N', '1029', '2020-08-26 11:48:10', '', 'S3006794617615', 'self employed', '999999'),
(10, 'Miss Marie Samanta Anabelle TUYAU', 'Royal Road, Grand Bay, Postal Code 30506', '99999', '', '', 'N', '1030', '2020-08-26 11:58:35', '', 'T170687461732F', 'self employed', '999999'),
(11, 'Miss Reena MEETOO', 'Rishi Dayanand Lane, Mare La Chaux Postal Code 41102', '99999', '', '', 'N', '', '2020-08-26 12:18:09', '', 'M2707934609603', 'Civil Servant', '59183027'),
(12, 'Mr. Soodesh Kumar MOOTEE', 'Royal Road, Clemencia, Postal Code 40702', '999999999', '', '', 'N', '', '2020-08-27 09:28:38', '', 'M170169150046A', 'Accountant -IBL', '59403553'),
(13, 'ALIMENTARY PASTES COMPANY LIMITED', 'Cocoterie Street, Port Louis, Postal Code 11703', '99999999', '', '', 'N', '', '2020-08-27 09:48:52', '', 'xxxxxxxxxxxxxxxxxxxxx', 'Company', '99999999'),
(14, 'Mr. Arjoon ISSUREE', 'Royal Road, Amaury, Postal Code 31401', '9999999', '', '', 'N', '', '2020-08-27 10:32:36', '', '12607621104712', 'Taxi Driver', '999999'),
(15, 'Mr. Sunildut HAUMEER', 'La Source, Quatre Bornes, Postal Code 7427', '999999', '', '', 'N', '', '2020-08-31 08:13:11', '', 'H220260430584G', '', '9999999'),
(16, 'MR LUCKKANA BHAGWANDUTH', 'VIJAYE LUXMI ROAD POUDRE D\'OR HAMLET POSTAL CODE 31006', '1234567', '', '', 'N', '', '2020-08-31 09:44:15', 'MR LUCKKANA BHAGWANDUTH', 'L2805591201176', '', '1234567'),
(17, 'Mr. Ritesh SWAMBER', 'Latapie, Brisee Verdiere, Postal Code 42409', '999999999', '', '', 'N', '', '2020-08-31 09:45:21', '', 'XXXXXXXXXXXXXXX', '', '59133919'),
(18, 'Mr. Pawan Kumar BHOKOREE', 'Savanne Road, Nouvelle France, Postal Code 51312', '9999999', '', '', 'N', '', '2020-08-31 10:24:00', '', 'B0203911901886', '', '57924535'),
(19, 'Mr. Soodess Kumar RAMTOHUL', 'Block A3, Cactus Lane, Vallee Des Pretes, Postal Code 11818', '59151054', '', '', 'N', '', '2020-08-31 10:40:21', '', 'R0210713819333', 'Taxi Driver', '58134617'),
(20, 'Mrs. Asha DINOWA', 'School Lane, Petite Julie, Postal Code 21605', '1111111', '', '', 'N', '', '2020-08-31 10:57:28', '', 'XXXXXXXXXXXXXX', 'Police Officer', '1111111'),
(21, 'Mr. Ravindra NIRSIMLOO', 'Nehru Road, LEsperance, Quartier Militaire, Postal Code 80301', '9999999', '', '', 'N', '', '2020-08-31 12:11:17', '', 'N281275320019E', 'Civil Servant', '52515515'),
(25, 'Mr. Navin GOPAUL', 'Kalimata Road, Lallmatie, Postal Code 42601', '1111111', '', '', 'N', '', '2020-09-04 11:39:31', '', 'G0105914616445', 'IT Professional - MRA', '57888239'),
(26, 'Mr.  Ravindra NIRSIMLOO', 'Nehru Road, L\'Esperance, Quartier Militaire', '999999', '', '', 'N', '', '2020-09-04 12:09:45', '', 'N281275320019E', 'Police Officer', '52515515'),
(27, 'Mr. Sarrvam Rao Atmaram RAMDOO', 'Maisonette Road, Riviere des Anguilles, Postal Code 60605', '9999999', '', '', 'N', '', '2020-09-04 12:19:32', '', 'R15099026197E', 'Accountant', '58382468'),
(28, 'Mr. Vishal MEEHEELAUL', 'Royal Road, Amaury, Postal Code 31401', '9999999', '', '', 'N', '', '2020-09-04 12:31:25', '', 'M1001731100456', 'Police Officer', '58027467'),
(29, 'Mr. Sanjivee APPALSAWMY', 'Ave. Lotus, L\'Esperance, Piton, Postal Code 31902', '999999', '', '', 'N', '', '2020-09-05 09:06:18', '', 'A2401951200269', 'Civil Servant', '57087666'),
(30, 'Mr. Lutchmiduth HALKAREE', 'Royal Road, Nouvelle France, Postal Code 51309', '9999999', '', '', 'N', '', '2020-09-05 09:11:55', '', 'H020759230229E', 'Civil Servant- Accountant', '57736224'),
(31, 'Miss. Reelana SUNASSEE', 'C5, Rue des Trochetia, Tyack, Riv. des Anguilles Postal Code 61801', 'x', '', 'reelanasunassee@gmail.com', 'N', '', '2020-09-05 09:27:02', '', 'S2704912600922', 'HR Manager -Private Sector', '58052912'),
(32, 'Mr. Hurry Ram LUCHMIAH', 'Bambous Street, Upper Vale, Postal Code 31301', '9999999', '', '', 'N', '', '2020-09-05 09:35:28', '', 'L2401781000217', 'Civil Servant', '57622315'),
(33, 'Mr. Divesh Sharma LUBRUN', 'Mare aux Goyaves Street, Camp de Masque, Postal Code 40402', '9999999', '', '', 'N', '', '2020-09-05 09:49:43', '', 'XXXXXXXXXXXXXXX', 'Planter', '57610394'),
(34, 'Mr. Aneerood BHUGOWAN', 'Coastal Road, Pointe aux Canonniers, Postal Code 30510', '9999999', '', '', 'N', '', '2020-09-05 09:58:40', '', 'B140855100137B', 'self employed', '57508220'),
(35, 'Mr. Sunilut RAMJUTTON', 'Royal Road, Plaine des Roches, Postal Code 31902', '9999999', '', '', 'N', '', '2020-09-07 05:45:19', '', 'R120861110424C', 'Taxi Owner', '57779409'),
(36, 'Mr.Mohammad Fadil JEEWON', 'Cachmere Ave, Calebasses, Postal Code 20201', '999999', '', '', 'N', '', '2020-09-07 06:03:38', '', 'J030688020101B', 'Police Officer', '57637952'),
(37, 'Mr. Kiran Kumar BOYJOO', 'Rampersad Lane, Poudre D\'OrHamlet, Postal Code 31006', '99999', '', '', 'N', '', '2020-09-07 06:21:26', '', 'B231281460036D', 'Police Officer', '57663397'),
(38, 'Mr. Mahendre Kumar REEKOYE', 'Royal Road, Riche Terre, Postal Code 21731', '999999', '', '', 'N', '', '2020-09-07 06:34:34', '', 'R220378030057E', 'Taxi Owner', '57849547'),
(39, 'Miss Shamneez MOHAMUDBUCUS', 'Hospital Road, Centre de Flacq, Postal Code 40606', '99999', '', '', 'N', '', '2020-09-07 06:40:00', '', 'M0508914630288', 'Civil Servant', '58199786'),
(40, 'Mr. Denis Claude Francois SULLIVAN', 'Avenue Pivert, GOODLANDS, pPostal Code 30412', '999999', '', '', 'N', '', '2020-09-07 06:47:46', '', 'S041076461524F', 'Education Officer', '57177707'),
(41, 'Mrs. Simita RAMLUGUN', 'Royal Road, Morcellement St. Andre, Postal Code 20903', '999999', '', '', 'N', '', '2020-09-07 07:02:41', '', 'P141088060144B', 'Civil Servant', '9999999'),
(42, 'Mr. Anil SOOMARROO', 'Duccray Road, Notre Dames, Postal Code 22008', '99999', '', '', 'N', '', '2020-09-07 07:24:54', '', 'S200889462738D', 'self employed- Lorry owner', '58980123'),
(43, 'Mr. Sachidanand SAMO BURTHIA', 'Royal Road, Poudre D\'Or Village, Postal Code 30905', '999999', '', '', 'N', '', '2020-09-07 07:33:24', '', 'S1210631105957', 'Hardware Shop Owner/ Aluminium workshop', '57703639'),
(44, 'Mrs. Anishta ITTOO', 'Royal Road, Camp Fouquereaux, PHOENIX, Postal Code 73607', '9999999', '', '', 'N', '', '2020-09-07 07:53:21', '', 'C1602893008427', 'Civil Servant', '57924535'),
(45, 'Mr. Udhishteer Singh JATOO', 'Royal Road, Khoyratty, PAMPLEMOUSSES, Postal Code 20202', '9999999', '', '', 'N', '', '2020-09-07 07:57:23', '', 'J1308970201628', 'Private Sector Employee', '57784562'),
(46, 'Mr. Deviraj PILLY POTHIAH', 'Lot B57, Royal Road, Morc. Beau Champ, Bel Air Riviere Seche, Postal Code 40101', '9999', '', '', 'N', '', '2020-09-07 08:21:11', '', 'P151186463332C', 'Hotel Sector/ Primary School Teacher', '54798568'),
(47, 'Mrs. SuheilaBibi GOOLAMALLY EMAMBOCUS', 'Junction Road, Notre Dame, Postal Code 22008', '999999', '', '', 'N', '', '2020-09-07 08:33:09', '', 'G110495030106F', 'General Retailer', '58562622'),
(48, 'SPKR TRANSPORT LTD', 'Ilot, PAMPLEMOUSSES, Postal Code 20506', '54986596', '', '', 'N', '', '2020-09-07 08:46:53', 'Mr. Kaushik', 'XXXXXXXX', 'Transport of containers', '59415544'),
(49, 'Mr. Roshan GOPYNAUTH', 'Royal Road, Poste de Flacq', '999999', '', '', 'N', '', '2020-09-07 09:08:28', '', 'R1205871301380', 'General Retailer', '59358149'),
(50, 'Mr. Antoine Jean Mario DRACK', '31 Cite Briquette, Abercombie, St Croix', 'xxxxxxx', '', '', 'N', '', '2020-09-07 10:53:50', '', 'XXXXXXXXXXXXXX', 'Taxi Owner', '57552476'),
(51, 'Mrs. Bindya GOOROOCHARUN', 'EDC Road, Pavillion, Camp Malhereux', '999999', '', '', 'N', '', '2020-09-07 11:12:27', '', 'R01018510005F', 'General Retailer', '57155806'),
(52, 'Mr. Kalyannath JAGMOHUNSINGH', 'No.1 Pont St Louis, Pailles', '99999', '', '', 'N', '', '2020-09-07 11:58:14', '', 'J2305743815869', 'Taxi Owner', '59498687'),
(53, 'Mr. Parvin SOONEERAM', 'Woodhoo Lane, TRIOLET', '99999', '', '', 'N', '', '2020-09-08 07:10:43', '', 'XXXXXXXXXXX', 'Planter', '57892050'),
(54, 'MR. KALYANNATH JUGMOHUNSINGH', 'No. 1 Pont St Louis, Impasse Seeyen Pailles Postal Code 11211', '99999', '', '', 'N', '', '2020-09-12 06:25:19', '', 'J2305743815869', 'Taxi Owner', '59498687'),
(55, 'Mrs. Premawtee BURHOO', 'Royal Road, Ilot, D\'Epinay, Pamplemousses', '2433167', '', '', 'N', '', '2020-09-25 05:23:38', '', 'J080358140190F', 'School Head Teacher', '57351959'),
(56, 'Mr. Frank Thierry Regis QUIBLIER', 'VillaOnella, 25 Ipasse Merville, Perebere, Grand Baie', 'x', '', '', 'N', '', '2020-09-25 05:30:55', '', 'Q1971FRA379388', 'Sales Manager', '57324996'),
(57, 'Mrs. Sourekha DALOO', 'Madhoo Lane, ARSENAL', '2482424', '', '', 'N', '', '2020-09-25 05:32:36', '', 'x', 'Vegetable Planter', '57760241'),
(58, 'Mr. Bye Ibrahim Adil ALLADEE', 'Royal Road, Providence, Quartier Militaire', '525428821', '', '', 'N', '', '2020-09-25 05:35:53', '', 'A2901791600300', 'Hardware shop', '52529753'),
(59, 'Mrs. Devanayagee VALAYTEN-CAREMBEN', 'Caremben Lane, Mon Loisir, Amitie', '4126078', '', '', 'N', '', '2020-09-25 05:37:56', '', 'X', 'Sweets shop', '59259890'),
(60, 'EVERNEST REALTY LTD', '27 Church Street, Pointe Aux Piments', '2613283', '', '', 'N', '', '2020-09-25 05:44:03', 'Miss. Anusha SEEWOODUTH', 'x', 'Real State Agency', '57335508'),
(61, 'Mr. Utamkumarsingh WOOZAGEER', 'Marday Lane, Vacoas', '59149149', '', '', 'N', '', '2020-09-25 05:46:26', '', 'W1401843001824', 'Bakery Owner', '59159156'),
(62, 'Mr. Miow Fan LAM PING FONG', 'Chemin Vingt Pieds, Opposite Pepiniere, Grand Baie', 'x', '', '', 'N', '', '2020-09-25 06:40:05', '', 'X', 'self employed', 'x'),
(63, 'Mr. Sookdeo GUJADHUR', '22 Leclezio St, PORT LOUIS Postal Code 11402 ', '9999', '', '', 'N', '', '2020-10-09 10:08:35', '', 'G2208483203051', 'Pensioner', '59815555'),
(64, 'Mr. Surujlall SOODAGUR', 'Temple Road, Riviere du Rempart', 'xx', '', '', 'N', '', '2020-10-12 10:49:38', '', 'S240275110093B', '', '57847341'),
(65, 'Mr. Kalutay', 'Pere Glorieux, Grand Gaube', '9999', '', '', 'N', '', '2020-10-12 11:04:28', '', 'xxxxx', 'Hotelry', '57865350'),
(66, 'Miss. Sandhya CAUNHYE', 'La Tapie Road, Bon Acceuil', '4181718', '', '', 'N', '', '2020-10-12 11:35:19', '', 'XXX', 'Accounting Specialist', '58617928'),
(67, 'Mr. Nandeo RAMDANI', 'Royal Road, Terre Rouge.', 'xxx', '', '', 'N', '', '2020-10-12 11:52:13', '', 'XX', 'Staff Rogers Capital', '57594830'),
(68, 'Mr. Prithiraj GUNGAH', '111 Railway , Bois Pignolet, Terre RougeSt ', 'xx', '', '', 'N', '', '2020-10-12 12:08:49', '', 'xxx', 'Taxi Owner', '57755441'),
(69, 'Mr. Veenayraye KOOPLA', 'Bramsthan Street, L\'Amitie, Postal Code 30101', '1', '', '', 'N', '', '2020-11-07 09:56:30', '', 'K2612701200237', 'Civil Servant', '1'),
(70, 'Mr. Cheetratan TOKHAI', 'Sewaksingh Road, Gokhoola, Postal Code 31503', 'xx', '', '', 'N', '', '2020-11-10 12:20:33', '', 'T120879070033G', 'Manager- Winners', '52511840'),
(71, 'Mr. Somduth RAMSAHA', 'Coolen Road, Grand Bay, Postal Code 30510', 'xx', '', '', 'N', '', '2020-11-16 09:25:14', '', 'R030270100057B', 'Self employed', '58343885'),
(72, 'Miss Sasmita Devi BEEHARRY', 'Geetanjali Street, Trois Boutiques, Triolet, Postal Code 21509', 'xx', '', '', 'N', '', '2020-11-16 09:27:58', '', 'B0905924617603', 'Primary School Treacher', '57577561'),
(73, 'Mr. Desire Bruno ROSICOURT', 'NHDC Appt L-03, Notre Dame', 'xx', '', '', 'N', '', '2020-11-16 09:29:34', '', 'XXX', 'Self Employed', '57718105'),
(74, 'Mr. Roshan SOOKRAL', '87 Paul Taureau Street, Ste Croix, PORT LOUIS, Postal Code 11705', '52587128', '', '', 'N', '', '2020-11-16 09:32:51', '', 'S2810713821309', 'Taxi Owner', '57685488'),
(75, 'Mr. Anishkar AUBEELUCK', 'Mahatma Ganhi Road, Quatre Cocos', 'xx', '', '', 'N', '', '2020-11-17 06:13:03', '', 'A081096130734D', 'Corporate Officer', '59210476'),
(76, 'Mrs. Gayetree CHOORAMUN', 'Diagonal Road, L\'Esperance Postal Code 30301', 'xx', '', '', 'N', '', '2020-11-17 06:19:12', '', 'J141063120172C', 'Civil Servant', '59230684'),
(77, 'Mr. Dasruth DHAWKA', 'no. 18 Morcellement Laurette, Mahebourg, Postal Code 50812', '6314567', '', '', 'N', '', '2020-11-17 07:11:21', '', 'D1606632001407', 'Officer- M Telecom', '57747444'),
(78, 'Mrs. Asha JEEAVOO', 'Royal Road, Creve Coeur', 'xx', '', '', 'N', '', '2020-11-17 07:14:52', '', 'G210490050034C', 'Prison Officer', '59294585'),
(79, 'Mrs. Bibi Rabiah DURBAREE', 'Hassen Hussein Lane, Latapie, Bon Acceuil, Postal Code 42409', 'xx', '', '', 'N', '', '2020-11-18 11:45:22', '', 'D130495140168F', 'self employed', '57166272'),
(80, 'Mr. Supramanien SUPANEE', 'Shanti Niketan Street, Amaury, Belle Vue Maurel, Postal Code 1840', 'xx', '', '', 'N', '', '2020-11-19 11:12:10', '', 'XX', 'Primary School Head Teacher', '57589907'),
(81, 'Miss Bibi Firyaal BOOLAKY', 'Royal Road, Terre Rouge, Postal Code 21416', '2496924', '', '', 'N', '', '2020-11-23 05:43:36', '', 'B050489280142D', 'General Retailer', '59229400'),
(82, 'Mrs. Reema GREEDHARRY', 'Shivala Road, Quatre Soeurs, Postal code 52703', 'xx', '', '', 'N', '', '2020-11-24 09:06:24', '', 'L200491461841E', 'Employee Wwinners', '58063264'),
(83, 'Mrs. Saeeda Beebee NUJURAULLY', '12 La Gaite Street, Port Louis', '59216916', '', 'rostomsaeeda@gmail.com', 'N', '', '2020-11-24 09:23:27', '', 'R2012630100890', 'self employed', '59297467'),
(84, 'Mr. Rakesh BEEHARRY', 'Savanne Road, Nouvelle France, Postal Code 51312', 'xx', '', '', 'N', '', '2020-11-25 06:51:49', '', 'B2309792907274', 'Employee Food Canners', '59137027'),
(85, 'Mr. Rishi Roshan OREE', '18 Ave Pere Laval, Ste Croix', '58012250', '', '', 'N', '', '2020-11-25 12:12:15', '', 'O0906863818511', 'Taxi Owner', '59446122'),
(86, 'Mr. Sailesh GOORAH ', 'XX', 'XX', '', '', 'N', '', '2020-12-03 06:54:05', '', 'XX', '', '58385989'),
(87, 'Mrs. Jhenita RAMDOHIN- RUGHOO', 'Forbach Road, Poudre D\'Or Hamlet, Postal Code 31001', 'XX', '', '', 'N', '', '2020-12-03 07:17:32', '', 'R0602844602753', 'Accounting Specialist - Accenture', '59159493'),
(88, 'MEGA PRO LTD', 'Royal Road, Valetta', 'xx', '', '', 'N', '', '2020-12-03 07:23:14', 'Mr. Dhunnoo - 57613330', 'XX', 'Company dealing in Industrial bio chemicals', '57613330'),
(89, 'Mr. Munideo SAHAI', 'Grand Baie', 'xx', '', '', 'N', '', '2020-12-03 07:32:23', '', 'XX', 'Taxi Owner', '57893435'),
(90, 'Mrs. Sharika Devi HEERAH', 'Gandhi Road, Petit Raffray.', 'xx', '', '', 'N', '', '2020-12-03 07:38:20', '', 'XX', 'Teacher', '58258477'),
(91, 'Mr. Veeraj MOHUN', 'Victoria Road, Trou D\'Eau Douce Postal Code 42213 ', 'xx', '', '', 'N', '', '2020-12-03 11:32:35', '', 'M1011763900566', 'Health Inspector', '57604120'),
(92, 'Mr Williams EMPEIGNE', 'Royal Road, Poudre D\'Or Village, Postal Code 309025', 'xx', '', '', 'N', '', '2020-12-12 08:55:33', '', 'E0902981200280', 'Account technician', '59360845'),
(93, 'Mrs. Priya GOOLZAR SEEBALUCK', 'Royal Road, Congomah, Postal Code 20303', 'xx', '', '', 'N', '', '2020-12-12 08:57:48', '', 'g2409871400637', 'Education Officer', '57592418'),
(94, 'Mr. Mohammad Ali NUCKCHADY', '70 Cite Vuillemin, Beau Bassin, Postal Code 71503', 'xx', '', '', 'N', '', '2020-12-12 09:39:18', '', 'N310194380125A', 'Sports Trainer', '57818687'),
(95, 'Mrs. Bibi Meenah JEEWON', 'Corbeille Road, Mount Pamplemousses', 'xx', '', '', 'N', '', '2020-12-12 09:42:59', '', 'D141147310621A', '', '52588864'),
(96, 'Mr. Supanee SUPRAMANIEN', 'SSR Road, Amaury,Postal Code 31401', 'xx', '', '', 'N', '', '2020-12-14 09:54:48', '', 'S010359080206A', 'head teacher', '57589907'),
(97, 'Mr. Mohammad Nooruddeen NABEEBOCUS', 'Cnr Ave des Lataniers & Ave des Palmiers, Vallee des Pretres', 'xx', '', '', 'N', '', '2020-12-16 08:20:03', '', 'N1112913800534', 'Employee Neetoo Industries', 'xxxx'),
(99, 'Mr. Rakesh SOWAMBER', 'Mont Mascal, Petit Raffrat Postal Code 30704', 'xx', '', '', 'N', '647GZ15', '2020-12-19 06:13:33', '', 'S200276080093G', 'Planter', '52522334'),
(100, 'Mr Moozaqqir PEERBOCUS', 'School Lane, Morcellement St Andre ', '59189890', '', '', 'N', '', '2020-12-21 09:46:55', '', 'P2802920600182', 'Nursing Officer', '59683735, 57602529'),
(101, 'Mr. Rajmohun NOYAN', 'Petit Raffray', '2612834', '', '', 'N', '', '2020-12-21 09:59:19', '', 'N021055040155F', 'Pensioner', '54937190'),
(102, 'Mrs. Nayteedevi JANGI', '47 Ave des Pinsons, Morcellement Sodnac, Postal Code 72256', 'xx', '', '', 'N', '', '2020-12-21 10:14:05', '', 'B0107853823100', '', '57882528'),
(103, 'Mr. Rajcoomar LUTCHMUN ROY', 'Birla Road, Cottage Postal Code 30202', 'xx', '', '', 'N', '', '2021-02-15 07:44:00', '', 'L110367120011A', 'self employed', '59604250'),
(104, 'Miss Anjali Leysha GOPY', 'AVE vALASOIS, vACOAS, pOSTAL cODE 73449', 'XX', '', '', 'N', '', '2021-02-15 08:12:33', '', 'G2912981300860', 'Accountant', '52506322'),
(105, 'Mr. Rajen BHURUTH', 'Royal Road, Amaury, Postal Code 31401', 'xx', '', '', 'N', '', '2021-02-15 09:01:52', '', 'B230664110437B', 'Self Employed', '58270387'),
(106, 'Miss Logeswari Modelly THANDRAYEN', 'Temple Road 1, Amaury, Postal Code 31401', 'xx', '', '', 'N', '', '2021-02-16 07:50:32', '', 'T2009971103563', 'Education Officer', '57956839'),
(107, 'Mr. Soobidanund LODENAUTH', '16 Bois Cherie Lane, Dubreuil, Postal Code 81501', 'xx', '', '', 'N', '', '2021-02-16 08:18:26', '', 'L270574190196A', 'Taxi Owner', '59756838'),
(108, 'Mrs Roobinah GANGADURDOSS', 'No. 40 Ave Vierge Marie, Pamplemousses, Postal Code 21008', 'xx', '', '', 'N', '', '2021-02-17 11:35:07', '', 'G2511890201164', 'Police Officer', '57524468'),
(109, 'Mr. Lutchminarain YERKIAH', 'Royal Road, Amitie, Riviere du Rempart', 'xx', '', '', 'N', '', '2021-02-17 11:54:09', '', 'Y290357110345B', 'Customs Officer', '57624417'),
(110, 'Mr. Satyam GUTTY', 'Royal Road, Pointe Aux Piments', 'xx', '', '', 'N', '', '2021-02-19 08:18:37', '', 'G0905520402171', 'Taxi Owner', '57662520'),
(111, 'Miss Thiroshnee GUJADHUR', '55 Morc. Industrie, Creve Coeur', 'xx', '', '', 'N', '', '2021-02-19 08:35:59', '', 'XX', '', 'xx'),
(112, 'Mr. Mahmud Nazin ROZUN', 'Joomun Road, Riviere Du Rempart', '4126191', '', '', 'N', '', '2021-02-19 08:37:07', '', 'R170857382848', 'Civil Servant', '57861457'),
(113, 'Mrs Rajwantee DALLIAH', 'Dalliah Lane, Plianes des Roches', '57711169', '', '', 'N', '', '2021-02-19 08:41:01', '', 'XX', 'Civil Servant', '57582186'),
(114, 'Mr. Krishna MOONIEN', 'Laborde Road, Bois Rouge, Pamplemousses, Postal Code 21002', 'xx', '', '', 'N', '', '2021-02-19 08:46:02', '', 'M1602734602702', 'Welder -Terra', '57774795'),
(115, 'Mrs Ootradevi KOOSUL', 'Camp Raquette, Grand Baie', '2633844', '', '', 'N', '', '2021-02-19 09:36:36', '', 'R2010834600999', 'General Retailer', '57830535/58270387'),
(116, 'AZUR CAR RENTAL LTD', 'Royal Road, D\'EPINAY Postal Code 20503', 'xx', '', '', 'N', '', '2021-02-19 09:43:34', 'Mr. Ajay Oogur', 'XXX', 'CAR RENTAL COMPANY', 'xxxx'),
(117, 'AVENUE CAR RENTAL LTD', 'Royal Road, D\'Epinay, Postal Code 20503', 'xx', '', '', 'N', '', '2021-02-19 09:44:48', 'Mr. Ajay Oogur', 'XXX', 'CAR RENTAL COMPANY', 'xx'),
(118, 'Mr. Sanjaysingh CHUTTARSINGH', 'Social Welface Centre Road, Goodlands, Postal Code 30415', 'xx', '', '', 'N', '', '2021-02-19 09:51:18', '', 'C280468080238F', 'self employed', 'xx'),
(119, 'Mr. Deoraj CHUDOORY', 'Osman Road, Notre Dame', 'xx', '', '', 'N', '', '2021-02-19 10:12:46', '', 'XX', 'Civil Servant', '59292966'),
(120, 'Miss Beebee Suhailah MOHUNGUR', 'SSR Street, Riviere du Rempart', '4125315', '', '', 'N', '', '2021-02-19 10:26:14', '', 'XX', '', '57646767'),
(121, 'Dr. Aljaa BAHORUN', 'Level 6, Nextracom Tower, Ebene', 'xx', '', '', 'N', '', '2021-02-19 10:35:52', 'Mr. Ravin', 'XXXXX', 'Egyptian Ambassador', '57902274'),
(122, 'MONT MASCAL VERGIE GREEN CO LTD', 'SSR Road, Petit Raffray', 'xx', '', '', 'N', '', '2021-02-19 10:36:44', '', 'XXXX', '', '58615577'),
(123, 'Mr. Yogendra GOPAUL', 'Royal Road, Lalmatie', 'xx', '', '', 'N', '', '2021-02-24 11:07:29', '', 'XX', '', '57917431'),
(124, 'Mrs Saraswatee RAGOOMUNDUN', 'Tagore Road,Grand Gaube, Postal Code 30602', 'xx', '', '', 'N', '', '2021-03-05 11:06:52', '', 'S2401741300898', 'Civil Servant', '57841668'),
(125, 'Hoolash Bakers Supermarket & Co Ltd', 'Royal Road, Creve Coeur', 'xx', '', '', 'N', '', '2021-03-06 07:24:08', '', 'xx', '', '57517899'),
(126, 'Miss Yashna GOPAUL  ', 'PELGRIN ROAD SEBASTOPOL POSTAL CODE 42106  ', 'xx', '', '', 'N', '', '2021-03-09 06:52:26', '', ' G2411964501065 ', 'IT Professional', '52594342'),
(127, 'Mr. Jewin Singh PRAYAG', 'Sentosa Road, Goodlands', 'xx', '', '', 'N', '', '2021-03-09 07:29:52', '', 'P12451', 'Taxi Owner', '57792776'),
(128, 'Mr Ajay GHOORAH', 'Sir S Ramgoolam Rd, Morc St Andre, Postal Code 20902', 'xx', '', '', 'N', '', '2021-03-23 11:26:50', '', 'G010881440199D', 'Operator CHC', '57857624'),
(129, 'Mr. Randhir RAWA', 'Lot No. 37, Morc Les Graviers, Cottage, Postal Code 30202', 'xx', '', '', 'N', '', '2021-04-02 10:01:42', '', 'R1008784617577', 'Painter', '57542227'),
(130, 'Mr Deokumar RAMDASS', 'Ripailles Road, Creve Coeur, Postal Code 20403', 'xx', '', '', 'N', '', '2021-04-15 09:01:21', '', 'R090970050222A', 'Taxi Owner', '57299720'),
(131, 'Mr. Dharamraj MUCKOON', 'John Kennedy St, Grand Gaube', 'xx', '', '', 'N', '', '2021-04-20 06:21:55', '', 'M1708580901189', 'Taxi Owner', '57186686'),
(132, 'Mr. Ah-Piang Denis Jean Desire VERLOPPE', 'Lot 58, Morc Medine, Approach Road, Canot, Albion', 'xx', '', '', 'N', '', '2021-04-23 11:12:53', '', 'V1806933800588', 'Mechanic', '52595822'),
(133, 'Mr. Nurvish GOVIND', 'No. 7 Domaine Ilot, Ilot, Pamplemousses, Postal Code 20506', 'xx', '', '', 'N', '', '2021-04-28 06:54:57', '', 'G1201914100054', 'Bank Officer - MCB', '59098910'),
(134, 'Mr. Mahmad Idris SUFRAZ', 'Dhanilall Road, Calebasses', 'xx', '', '', 'N', '', '2021-04-28 06:57:42', '', 'S190257380698C', 'Civil Servant', '57813598'),
(135, 'Miss Karishma BUNDHUN', 'Ramdour Road, Bon Acceuil.', 'xx', '', '', 'N', '', '2021-04-28 07:02:24', '', 'B270683140091D', 'Education Officer', '57720392'),
(136, 'Miss Raksha GOPAUL', 'Pellegrin Road, Sebastopol', 'xx', '', '', 'N', '', '2021-04-28 07:08:18', '', 'G0602953801478', 'Officer, Mutal Aid', '58080197'),
(137, 'Mrs. Ashna APPANAH-LINGIAH', 'La Clemence, Riviere du Rempart', 'xx', '', '', 'N', '', '2021-04-28 07:11:16', '', 'XXXX', 'Private sector employee', '52562442'),
(138, 'Mrs Madhvi Seewoosungkur', 'Seneck Road, Plaine des Roches, Postal Code 31904', 'xx', '', '', 'N', '', '2021-04-29 06:02:09', '', 'P2005834607751', 'Civil Servant', '57878656'),
(139, 'Mr. Kashir Uddhin UNUTH', '138 Route Hugnin, Rose Hill', 'xx', '', '', 'N', '', '2021-05-03 06:43:09', '', 'XX', 'Bakery Owner', '57844648'),
(140, 'Miss Laura SEEWOOGOOLAM', 'Viile Noire, Mahebourg', 'xx', '', '', 'N', '', '2021-05-03 06:54:14', '', 'XX', '', '57935292'),
(141, 'Mr. Reetesh BALGOBIN', 'Shivala Road, Calebasses, Pamplemousses, Postal Code 20203', 'xx', '', '', 'N', '', '2021-05-03 07:56:54', '', 'B010789020068G', 'IT Professional', '57552338'),
(142, 'Mr. Atish BHOLAH', 'Morcellement Petit Village, Goodlands, Postal Code 30411', 'xx', '', '', 'N', '', '2021-05-03 08:05:21', '', 'B030282300268D', 'Inspector - ICAC', '57577272'),
(143, 'Mr. Ghanshyam JUKHOOP', 'Belle Mare', 'xx', '', '', 'N', '', '2021-05-04 14:11:19', '', 'XX', 'Taxi Owner', '52515990'),
(144, 'Mr. Chandrassen GAUNGOO', 'Aston Villa, Trois Bras, Petit Raffray, Postal Code 30711', 'xx', '', '', 'N', '', '2021-05-05 10:35:37', '', 'G1208650802601', 'self employed', '57741359'),
(145, 'Mr. Vishwanath NOYAN', 'Baitka Road, Trois Bras, Petit Raffray', 'xx', '', '', 'N', '', '2021-05-06 13:26:02', '', 'XX', 'Civil Servant', '58032499'),
(146, 'ashvin', '1', '1', '', '', 'N', '', '2021-06-25 07:39:42', '', '000', '', '548'),
(147, 'Ashivin', 'Plaine de papayes', '48595625', '', '', 'N', '', '2021-07-08 10:33:13', '48595625', 'R1202256555454', 'General Retailer', '48595625'),
(148, 'Samita Nagen', 'Port-Louis', '2110120', NULL, NULL, 'N', NULL, '2023-03-24 00:02:00', 'Samita Nagen', 'XX', 'Self Employed', '58270035'),
(151, 'Peeyush Roussel', 'Port-Louis', '2404711', '1234567', 'test@live.com', 'N', '123test', '2023-03-23 21:31:22', 'Devianee', 'R160120', 'Student', '58270035'),
(152, 'Didier Roussel', 'Pointe aux Sable', '2347180', NULL, 'didier@roussel.mu', 'N', 'TEST', '2023-03-23 21:31:22', 'Carine', 'S1404925414', 'Telephonist', '58547456'),
(153, 'Cedric Roussel', 'Sainte-Croix', '2404711', '1234567', 'cedric@live.com', 'Y', 'Test Note', '2023-03-23 21:31:22', 'Cedric', 'R220362252536', 'IT Administrator', '58270035');

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

--
-- Table structure for table `op_prodtransfer`
--

DROP TABLE IF EXISTS `op_prodtransfer`;
CREATE TABLE IF NOT EXISTS `op_prodtransfer` (
  `transferid` int(11) NOT NULL AUTO_INCREMENT,
  `productid` int(11) NOT NULL,
  `from_store` varchar(45) NOT NULL,
  `to_store` varchar(45) NOT NULL,
  `qty` int(11) NOT NULL,
  `remarks` longtext,
  `dt_tranfer` datetime NOT NULL,
  PRIMARY KEY (`transferid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `op_products`
--

DROP TABLE IF EXISTS `op_products`;
CREATE TABLE IF NOT EXISTS `op_products` (
  `productid` int(11) NOT NULL AUTO_INCREMENT,
  `product` varchar(45) NOT NULL,
  `bp` decimal(9,2) NOT NULL,
  `sp` decimal(9,2) NOT NULL,
  `qty` int(11) NOT NULL,
  `uom` varchar(45) DEFAULT NULL,
  `supplierid` int(11) DEFAULT NULL,
  `dt_added` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`productid`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `op_products`
--

INSERT INTO `op_products` (`productid`, `product`, `bp`, `sp`, `qty`, `uom`, `supplierid`, `dt_added`) VALUES
(1, 'Sorbet Sega Colada', '0.00', '35.00', 100, 'UNIT', 1, '2023-04-23 21:03:11');

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

--
-- Table structure for table `op_productsbystores`
--

DROP TABLE IF EXISTS `op_productsbystores`;
CREATE TABLE IF NOT EXISTS `op_productsbystores` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `store` varchar(45) NOT NULL,
  `productid` varchar(45) NOT NULL,
  `qty` int(11) NOT NULL,
  `dt_added` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `dt_updated` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `op_productsbystores`
--

INSERT INTO `op_productsbystores` (`id`, `store`, `productid`, `qty`, `dt_added`, `dt_updated`) VALUES
(1, 'TEST', '25', 80, '2023-04-24 18:30:59', '2023-04-24 18:31:19');

--
-- Triggers `op_productsbystores`
--
DROP TRIGGER IF EXISTS `np_productsbystores_BEFORE_UPDATE`;
DELIMITER $$
CREATE TRIGGER `np_productsbystores_BEFORE_UPDATE` BEFORE UPDATE ON `op_productsbystores` FOR EACH ROW BEGIN
SET NEW.dt_updated = CURRENT_TIMESTAMP;
END
$$
DELIMITER ;

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

--
-- Table structure for table `op_stores`
--

DROP TABLE IF EXISTS `op_stores`;
CREATE TABLE IF NOT EXISTS `op_stores` (
  `store` varchar(45) NOT NULL,
  `notes` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`store`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `op_stores`
--

INSERT INTO `op_stores` (`store`, `notes`) VALUES
('FACTORY', 'Primary Location of Products'),
('HAPPY-WORLD', 'Sales Location: Happy World House Port Louis'),
('TERRE-ROUGE', 'Sales Location: Terre Rouge near Florida Pharmacy');

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

--
-- Table structure for table `op_suppliers`
--

DROP TABLE IF EXISTS `op_suppliers`;
CREATE TABLE IF NOT EXISTS `op_suppliers` (
  `supplierid` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`supplierid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
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 */;
