-- MySQL dump 10.13  Distrib 5.6.16, for Win32 (x86)
--
-- Host: localhost    Database: spslitem_tekun_admindb
-- ------------------------------------------------------
-- Server version	5.6.16

/*!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 utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `_ref_business_type`
--

DROP TABLE IF EXISTS `_ref_business_type`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `_ref_business_type` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `industryID` int(11) NOT NULL,
  `name` varchar(128) NOT NULL,
  `createdBy` int(11) NOT NULL,
  `createdTS` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updatedBy` int(11) NOT NULL,
  `updatedTS` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `_ref_business_type`
--

LOCK TABLES `_ref_business_type` WRITE;
/*!40000 ALTER TABLE `_ref_business_type` DISABLE KEYS */;
INSERT INTO `_ref_business_type` VALUES (1,1,'General',1,'2014-05-05 17:32:56',0,'0000-00-00 00:00:00'),(2,2,'Retail And Trading',1,'2014-05-05 17:32:56',0,'0000-00-00 00:00:00'),(3,3,'Services',1,'2014-05-05 17:32:56',0,'2015-11-25 03:44:03'),(4,1,'Agriculture',1,'2014-05-05 17:32:56',0,'2015-11-25 03:44:17'),(5,1,'Manufacturing',1,'2014-05-05 17:32:56',0,'2015-11-25 03:44:21'),(6,2,'Others',0,'2016-10-17 02:27:34',0,'0000-00-00 00:00:00'),(7,3,'Others',0,'2016-10-17 02:27:34',0,'0000-00-00 00:00:00');
/*!40000 ALTER TABLE `_ref_business_type` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `_ref_chart_of_acct`
--

DROP TABLE IF EXISTS `_ref_chart_of_acct`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `_ref_chart_of_acct` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `businessTypeID` int(11) NOT NULL,
  `acctGroupID` int(11) NOT NULL,
  `acctCode` char(9) NOT NULL,
  `parentID` int(11) NOT NULL,
  `acctName` varchar(128) NOT NULL,
  `acctDescription` varchar(128) NOT NULL,
  `defaultID` int(11) DEFAULT NULL COMMENT 'id default acct for general setup',
  `createdBy` int(11) NOT NULL,
  `createdTS` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updatedBy` int(11) NOT NULL,
  `updatedTS` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=58 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `_ref_chart_of_acct`
--

LOCK TABLES `_ref_chart_of_acct` WRITE;
/*!40000 ALTER TABLE `_ref_chart_of_acct` DISABLE KEYS */;
INSERT INTO `_ref_chart_of_acct` VALUES (1,1,1,'100000000',0,'Advancement/(Drawing)	','',NULL,0,'2015-11-24 03:01:30',0,'0000-00-00 00:00:00'),(2,1,1,'120000000',0,'Retained Profit/(Loss) B/F ','',NULL,0,'2015-11-24 03:01:30',0,'2015-11-24 22:10:56'),(3,1,1,'130000000',0,'Current Retained Profit/(Loss)  ','',NULL,0,'2015-11-24 03:01:30',0,'2015-11-24 22:12:39'),(4,1,2,'200000000',0,'Fixed Asset	','',NULL,0,'2015-11-24 03:01:30',0,'2015-11-24 22:04:16'),(5,1,2,'200000100',103,'Furniture & Fixtures	','',NULL,0,'2015-11-24 03:01:30',0,'2015-11-24 22:06:29'),(6,1,2,'200000200',103,'Office Equipment	','',NULL,0,'2015-11-24 03:01:30',0,'2015-11-24 22:06:29'),(7,1,2,'200000300',103,'Computer & Software	','',NULL,0,'2015-11-24 03:01:30',0,'2015-11-24 22:06:29'),(8,1,2,'200000400',103,'Motor Vehicle	','',NULL,0,'2015-11-24 03:01:30',0,'2015-11-24 22:06:29'),(9,1,2,'200000500',103,'Machinery & Engine	','',NULL,0,'2015-11-24 03:01:30',0,'2015-11-24 22:06:29'),(10,1,2,'200000600',103,'Renovation	','',NULL,0,'2015-11-24 03:01:30',0,'2015-11-24 22:06:29'),(11,1,2,'200000700',103,'Store Equipment	','',NULL,0,'2015-11-24 03:01:30',0,'2015-11-24 22:06:29'),(12,1,2,'200000800',103,'Asset 8	','',NULL,0,'2015-11-24 03:01:30',0,'2015-11-24 22:06:29'),(13,1,2,'200000900',103,'Asset 9	','',NULL,0,'2015-11-24 03:01:30',0,'2015-11-24 22:06:29'),(14,1,2,'200001000',103,'Other Asset	','',NULL,0,'2015-11-24 03:01:30',0,'2015-11-24 22:06:29'),(15,1,3,'220000000',0,'Bank & Cash Balance	','',NULL,0,'2015-11-24 03:01:30',0,'2015-11-24 22:07:53'),(16,1,3,'220000100',114,'Bank1 	','',NULL,0,'2015-11-24 03:01:30',0,'0000-00-00 00:00:00'),(17,1,3,'220000200',114,'Bank2	','',NULL,0,'2015-11-24 03:01:30',0,'0000-00-00 00:00:00'),(18,1,3,'220000300',114,'Bank3	','',NULL,0,'2015-11-24 03:01:30',0,'0000-00-00 00:00:00'),(19,1,3,'220000400',114,'Petty Cash 1	','',NULL,0,'2015-11-24 03:01:30',0,'0000-00-00 00:00:00'),(20,1,3,'220000500',114,'Petty Cash 2	','',NULL,0,'2015-11-24 03:01:30',0,'0000-00-00 00:00:00'),(21,1,4,'370000000',0,'Borrowing	','',NULL,0,'2015-11-24 03:01:30',0,'0000-00-00 00:00:00'),(22,1,4,'370000100',120,'Loan 1	','',NULL,0,'2015-11-24 03:01:30',0,'0000-00-00 00:00:00'),(23,1,4,'370000200',120,'Loan 2	','',NULL,0,'2015-11-24 03:01:30',0,'0000-00-00 00:00:00'),(24,1,4,'370000300',120,'Loan 3	','',NULL,0,'2015-11-24 03:01:30',0,'0000-00-00 00:00:00'),(25,1,4,'370000400',120,'Loan 4	','',NULL,0,'2015-11-24 03:01:30',0,'0000-00-00 00:00:00'),(26,1,4,'370000500',120,'Loan 5	','',NULL,0,'2015-11-24 03:01:30',0,'0000-00-00 00:00:00'),(27,1,7,'400000000',0,'Sales	','',NULL,0,'2015-11-24 03:01:30',0,'0000-00-00 00:00:00'),(28,1,8,'500000000',0,'Cost of Goods Sold	','',NULL,0,'2015-11-24 03:01:30',0,'0000-00-00 00:00:00'),(29,1,35,'700000000',0,'Others Income 	','',NULL,0,'2015-11-24 03:01:30',0,'0000-00-00 00:00:00'),(30,1,10,'810000100',0,'Accounting & Legal	','',NULL,0,'2015-11-24 03:01:30',0,'0000-00-00 00:00:00'),(31,1,10,'810000200',0,'Advertising & Marketing	','',NULL,0,'2015-11-24 03:01:30',0,'0000-00-00 00:00:00'),(32,1,10,'810000300',0,'Commissions	','',NULL,0,'2015-11-24 03:01:30',0,'0000-00-00 00:00:00'),(33,1,10,'810000400',0,'Depreciation Expense	','',NULL,0,'2015-11-24 03:01:30',0,'0000-00-00 00:00:00'),(34,1,10,'810000500',0,'Electricity & water	','',NULL,0,'2015-11-24 03:01:30',0,'0000-00-00 00:00:00'),(35,1,10,'810000600',0,'GST- Non Claimable	','',NULL,0,'2015-11-24 03:01:30',0,'0000-00-00 00:00:00'),(36,1,10,'810000700',0,'Insurance Premium	','',NULL,0,'2015-11-24 03:01:30',0,'0000-00-00 00:00:00'),(37,1,10,'810000800',0,'Late Payment Charges	','',NULL,0,'2015-11-24 03:01:30',0,'0000-00-00 00:00:00'),(38,1,10,'810000900',0,'Medical fee	','',NULL,0,'2015-11-24 03:01:30',0,'0000-00-00 00:00:00'),(39,1,10,'810001000',0,'Miscellaneous Expenses	','',NULL,0,'2015-11-24 03:01:30',0,'0000-00-00 00:00:00'),(40,1,10,'810001100',0,'Motor Vehicle Repair & maintenance	','',NULL,0,'2015-11-24 03:01:30',0,'0000-00-00 00:00:00'),(41,1,10,'810001200',0,'Office expenses	','',NULL,0,'2015-11-24 03:01:30',0,'0000-00-00 00:00:00'),(42,1,10,'810001300',0,'Petrol,Parking & Toll	','',NULL,0,'2015-11-24 03:01:30',0,'0000-00-00 00:00:00'),(43,1,10,'810001400',0,'Postage & Courier	','',NULL,0,'2015-11-24 03:01:30',0,'0000-00-00 00:00:00'),(44,1,10,'810001500',0,'Quit Rent & Assessment	','',NULL,0,'2015-11-24 03:01:30',0,'0000-00-00 00:00:00'),(45,1,10,'810001600',0,'Registration Fee	','',NULL,0,'2015-11-24 03:01:30',0,'0000-00-00 00:00:00'),(46,1,10,'810001700',0,'Rental of Equipment	','',NULL,0,'2015-11-24 03:01:30',0,'0000-00-00 00:00:00'),(47,1,10,'810001800',0,'Rental of office	','',NULL,0,'2015-11-24 03:01:30',0,'0000-00-00 00:00:00'),(48,1,10,'810001900',0,'Rental of store	','',NULL,0,'2015-11-24 03:01:30',0,'0000-00-00 00:00:00'),(49,1,10,'810002000',0,'Seminar & Training	','',NULL,0,'2015-11-24 03:01:30',0,'0000-00-00 00:00:00'),(50,1,10,'810002100',0,'Store expenses	','',NULL,0,'2015-11-24 03:01:30',0,'0000-00-00 00:00:00'),(51,1,10,'810002200',0,'Telephone	','',NULL,0,'2015-11-24 03:01:30',0,'0000-00-00 00:00:00'),(52,1,10,'810002300',0,'Travel, Meals & Entertainment	','',NULL,0,'2015-11-24 03:01:30',0,'0000-00-00 00:00:00'),(53,1,10,'810002400',0,'Salary & wages	','',NULL,0,'2015-11-24 03:01:30',0,'0000-00-00 00:00:00'),(54,1,10,'810002500',0,'EPF & Socso	','',NULL,0,'2015-11-24 03:01:30',0,'0000-00-00 00:00:00'),(55,1,10,'850010000',0,'Bank Charges	','',NULL,0,'2015-11-24 03:01:30',0,'0000-00-00 00:00:00'),(56,1,10,'850020000',0,'Interest on loan	','',NULL,0,'2015-11-24 03:01:30',0,'0000-00-00 00:00:00'),(57,1,10,'860000000',0,'Income Tax Expense	','',NULL,0,'2015-11-24 03:01:30',0,'0000-00-00 00:00:00');
/*!40000 ALTER TABLE `_ref_chart_of_acct` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `_ref_country`
--

DROP TABLE IF EXISTS `_ref_country`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `_ref_country` (
  `fldid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `fldcountry` varchar(45) DEFAULT NULL,
  `fldcontinent` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`fldid`)
) ENGINE=InnoDB AUTO_INCREMENT=895 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `_ref_country`
--

LOCK TABLES `_ref_country` WRITE;
/*!40000 ALTER TABLE `_ref_country` DISABLE KEYS */;
INSERT INTO `_ref_country` VALUES (4,'AFGHANISTAN','AS'),(8,'ALBANIA','EU'),(10,'ANTARCTICA','AN'),(12,'ALGERIA','AF'),(16,'AMERICAN SAMOA','OC'),(20,'ANDORRA','EU'),(24,'ANGOLA','AF'),(28,'ANTIGUA AND BARBUDA','NA'),(31,'AZERBAIJAN','AS'),(32,'ARGENTINA','SA'),(36,'AUSTRALIA','OC'),(40,'AUSTRIA','EU'),(44,'BAHAMAS','NA'),(48,'BAHRAIN','AS'),(50,'BANGLADESH','AS'),(51,'ARMENIA','AS'),(52,'BARBADOS','NA'),(56,'BELGIUM','EU'),(60,'BERMUDA','NA'),(64,'BHUTAN','AS'),(68,'BOLIVIA','SA'),(70,'BOSNIA AND HERZEGOVINA','EU'),(72,'BOTSWANA','AF'),(74,'BOUVET ISLAND','AN'),(76,'BRAZIL','SA'),(84,'BELIZE','NA'),(86,'BRITISH INDIAN OCEAN TERRITORY','AS'),(90,'SOLOMON ISLANDS','OC'),(92,'BRITISH VIRGIN ISLANDS','NA'),(96,'BRUNEI','AS'),(100,'BULGARIA','EU'),(104,'MYANMAR','AS'),(108,'BURUNDI','AF'),(112,'BELARUS','EU'),(116,'CAMBODIA','AS'),(120,'CAMEROON','AF'),(124,'CANADA','NA'),(132,'CAPE VERDE','AF'),(136,'CAYMAN ISLANDS','NA'),(140,'CENTRAL AFRICAN REPUBLIC','AF'),(144,'SRI LANKA','AS'),(148,'CHAD','AF'),(152,'CHILE','SA'),(156,'CHINA','AS'),(158,'TAIWAN','AS'),(162,'CHRISTMAS ISLAND','AS'),(166,'COCOS ISLANDS','AS'),(170,'COLOMBIA','SA'),(174,'COMOROS','AF'),(175,'MAYOTTE','AF'),(178,'REPUBLIC OF THE CONGO','AF'),(180,'DEMOCRATIC REPUBLIC OF THE CONGO','AF'),(184,'COOK ISLANDS','OC'),(188,'COSTA RICA','NA'),(191,'CROATIA','EU'),(192,'CUBA','NA'),(196,'CYPRUS','EU'),(203,'CZECH REPUBLIC','EU'),(204,'BENIN','AF'),(208,'DENMARK','EU'),(212,'DOMINICA','NA'),(214,'DOMINICAN REPUBLIC','NA'),(218,'ECUADOR','SA'),(222,'EL SALVADOR','NA'),(226,'EQUATORIAL GUINEA','AF'),(231,'ETHIOPIA','AF'),(232,'ERITREA','AF'),(233,'ESTONIA','EU'),(234,'FAROE ISLANDS','EU'),(238,'FALKLAND ISLANDS','SA'),(239,'SOUTH GEORGIA AND THE SOUTH SANDWICH ISLANDS','AN'),(242,'FIJI','OC'),(246,'FINLAND','EU'),(248,'ALAND ISLANDS','EU'),(250,'FRANCE','EU'),(254,'FRENCH GUIANA','SA'),(258,'FRENCH POLYNESIA','OC'),(260,'FRENCH SOUTHERN TERRITORIES','AN'),(262,'DJIBOUTI','AF'),(266,'GABON','AF'),(268,'GEORGIA','AS'),(270,'GAMBIA','AF'),(275,'PALESTINIAN TERRITORY','AS'),(276,'GERMANY','EU'),(288,'GHANA','AF'),(292,'GIBRALTAR','EU'),(296,'KIRIBATI','OC'),(300,'GREECE','EU'),(304,'GREENLAND','NA'),(308,'GRENADA','NA'),(312,'GUADELOUPE','NA'),(316,'GUAM','OC'),(320,'GUATEMALA','NA'),(324,'GUINEA','AF'),(328,'GUYANA','SA'),(332,'HAITI','NA'),(334,'HEARD ISLAND AND MCDONALD ISLANDS','AN'),(336,'VATICAN','EU'),(340,'HONDURAS','NA'),(344,'HONG KONG','AS'),(348,'HUNGARY','EU'),(352,'ICELAND','EU'),(356,'INDIA','AS'),(360,'INDONESIA','AS'),(364,'IRAN','AS'),(368,'IRAQ','AS'),(372,'IRELAND','EU'),(376,'ISRAEL','AS'),(380,'ITALY','EU'),(384,'IVORY COAST','AF'),(388,'JAMAICA','NA'),(392,'JAPAN','AS'),(398,'KAZAKHSTAN','AS'),(400,'JORDAN','AS'),(404,'KENYA','AF'),(408,'NORTH KOREA','AS'),(410,'SOUTH KOREA','AS'),(414,'KUWAIT','AS'),(417,'KYRGYZSTAN','AS'),(418,'LAOS','AS'),(422,'LEBANON','AS'),(426,'LESOTHO','AF'),(428,'LATVIA','EU'),(430,'LIBERIA','AF'),(434,'LIBYA','AF'),(438,'LIECHTENSTEIN','EU'),(440,'LITHUANIA','EU'),(442,'LUXEMBOURG','EU'),(446,'MACAO','AS'),(450,'MADAGASCAR','AF'),(454,'MALAWI','AF'),(458,'MALAYSIA','AS'),(462,'MALDIVES','AS'),(466,'MALI','AF'),(470,'MALTA','EU'),(474,'MARTINIQUE','NA'),(478,'MAURITANIA','AF'),(480,'MAURITIUS','AF'),(484,'MEXICO','NA'),(492,'MONACO','EU'),(496,'MONGOLIA','AS'),(498,'MOLDOVA','EU'),(499,'MONTENEGRO','EU'),(500,'MONTSERRAT','NA'),(504,'MOROCCO','AF'),(508,'MOZAMBIQUE','AF'),(512,'OMAN','AS'),(516,'NAMIBIA','AF'),(520,'NAURU','OC'),(524,'NEPAL','AS'),(528,'NETHERLANDS','EU'),(530,'NETHERLANDS ANTILLES','NA'),(533,'ARUBA','NA'),(540,'NEW CALEDONIA','OC'),(548,'VANUATU','OC'),(554,'NEW ZEALAND','OC'),(558,'NICARAGUA','NA'),(562,'NIGER','AF'),(566,'NIGERIA','AF'),(570,'NIUE','OC'),(574,'NORFOLK ISLAND','OC'),(578,'NORWAY','EU'),(580,'NORTHERN MARIANA ISLANDS','OC'),(581,'UNITED STATES MINOR OUTLYING ISLANDS','OC'),(583,'MICRONESIA','OC'),(584,'MARSHALL ISLANDS','OC'),(585,'PALAU','OC'),(586,'PAKISTAN','AS'),(591,'PANAMA','NA'),(598,'PAPUA NEW GUINEA','OC'),(600,'PARAGUAY','SA'),(604,'PERU','SA'),(608,'PHILIPPINES','AS'),(612,'PITCAIRN','OC'),(616,'POLAND','EU'),(620,'PORTUGAL','EU'),(624,'GUINEA-BISSAU','AF'),(626,'EAST TIMOR','OC'),(630,'PUERTO RICO','NA'),(634,'QATAR','AS'),(638,'REUNION','AF'),(642,'ROMANIA','EU'),(643,'RUSSIA','EU'),(646,'RWANDA','AF'),(652,'SAINT BARTHÉLEMY','NA'),(654,'SAINT HELENA','AF'),(659,'SAINT KITTS AND NEVIS','NA'),(660,'ANGUILLA','NA'),(662,'SAINT LUCIA','NA'),(663,'SAINT MARTIN','NA'),(666,'SAINT PIERRE AND MIQUELON','NA'),(670,'SAINT VINCENT AND THE GRENADINES','NA'),(674,'SAN MARINO','EU'),(678,'SAO TOME AND PRINCIPE','AF'),(682,'SAUDI ARABIA','AS'),(686,'SENEGAL','AF'),(688,'SERBIA','EU'),(690,'SEYCHELLES','AF'),(694,'SIERRA LEONE','AF'),(702,'SINGAPORE','AS'),(703,'SLOVAKIA','EU'),(704,'VIETNAM','AS'),(705,'SLOVENIA','EU'),(706,'SOMALIA','AF'),(710,'SOUTH AFRICA','AF'),(716,'ZIMBABWE','AF'),(724,'SPAIN','EU'),(732,'WESTERN SAHARA','AF'),(736,'SUDAN','AF'),(740,'SURINAME','SA'),(744,'SVALBARD AND JAN MAYEN','EU'),(748,'SWAZILAND','AF'),(752,'SWEDEN','EU'),(756,'SWITZERLAND','EU'),(760,'SYRIA','AS'),(762,'TAJIKISTAN','AS'),(764,'THAILAND','AS'),(768,'TOGO','AF'),(772,'TOKELAU','OC'),(776,'TONGA','OC'),(780,'TRINIDAD AND TOBAGO','NA'),(784,'UNITED ARAB EMIRATES','AS'),(788,'TUNISIA','AF'),(792,'TURKEY','AS'),(795,'TURKMENISTAN','AS'),(796,'TURKS AND CAICOS ISLANDS','NA'),(798,'TUVALU','OC'),(800,'UGANDA','AF'),(804,'UKRAINE','EU'),(807,'MACEDONIA','EU'),(818,'EGYPT','AF'),(826,'UNITED KINGDOM','EU'),(831,'GUERNSEY','EU'),(832,'JERSEY','EU'),(833,'ISLE OF MAN','EU'),(834,'TANZANIA','AF'),(840,'UNITED STATES','NA'),(850,'U.S. VIRGIN ISLANDS','NA'),(854,'BURKINA FASO','AF'),(855,'KOSOVO','EU'),(858,'URUGUAY','SA'),(860,'UZBEKISTAN','AS'),(862,'VENEZUELA','SA'),(876,'WALLIS AND FUTUNA','OC'),(882,'SAMOA','OC'),(887,'YEMEN','AS'),(891,'SERBIA AND MONTENEGRO','EU'),(894,'ZAMBIA','AF');
/*!40000 ALTER TABLE `_ref_country` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `_ref_industry`
--

DROP TABLE IF EXISTS `_ref_industry`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `_ref_industry` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(128) NOT NULL,
  `createdBy` int(11) NOT NULL,
  `createdTS` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updatedBy` int(11) NOT NULL,
  `updatedTS` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `_ref_industry`
--

LOCK TABLES `_ref_industry` WRITE;
/*!40000 ALTER TABLE `_ref_industry` DISABLE KEYS */;
INSERT INTO `_ref_industry` VALUES (1,'General',1,'2014-05-05 09:06:56',0,'2014-05-05 09:32:24'),(2,'Retail',1,'2014-05-05 09:06:56',0,'2014-05-05 09:32:44'),(3,'Services',1,'2014-05-05 09:08:14',0,'2014-05-05 09:32:44'),(4,'Others',1,'2014-05-05 09:08:14',0,'2014-05-05 09:32:44');
/*!40000 ALTER TABLE `_ref_industry` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `_ref_state`
--

DROP TABLE IF EXISTS `_ref_state`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `_ref_state` (
  `fldid` int(10) NOT NULL AUTO_INCREMENT,
  `fldregion_id` int(10) unsigned DEFAULT NULL,
  `fldname` varchar(45) DEFAULT NULL,
  `shortName` varchar(4) NOT NULL,
  PRIMARY KEY (`fldid`),
  KEY `subregion_region_id` (`fldregion_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1937 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `_ref_state`
--

LOCK TABLES `_ref_state` WRITE;
/*!40000 ALTER TABLE `_ref_state` DISABLE KEYS */;
INSERT INTO `_ref_state` VALUES (1921,458,'JOHOR','JHR'),(1922,458,'KEDAH','KDH'),(1923,458,'KELANTAN','KTN'),(1924,458,'MELAKA','MLK'),(1925,458,'NEGERI SEMBILAN','NSN'),(1926,458,'PAHANG','PHG'),(1927,458,'PERAK','PRK'),(1928,458,'PERLIS','PLS'),(1929,458,'PULAU PINANG','PNG'),(1930,458,'SARAWAK','SWK'),(1931,458,'SELANGOR','SGR'),(1932,458,'TERENGGANU','TRG'),(1933,458,'KUALA LUMPUR','KUL'),(1934,458,'LABUAN','LBN'),(1935,458,'SABAH','SBH'),(1936,458,'PUTRAJAYA','PJY');
/*!40000 ALTER TABLE `_ref_state` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `_ref_web`
--

DROP TABLE IF EXISTS `_ref_web`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `_ref_web` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `webPageName` varchar(64) NOT NULL,
  `namaSyarikat` varchar(32) NOT NULL,
  `mukaDepan` longtext,
  `menu1` varchar(32) NOT NULL,
  `menu2` varchar(32) NOT NULL,
  `menu3` varchar(32) NOT NULL,
  `menu4` varchar(32) NOT NULL,
  `menu5` varchar(32) NOT NULL,
  `menu1Link` varchar(64) NOT NULL,
  `menu2Link` varchar(64) NOT NULL,
  `menu3Link` varchar(64) NOT NULL,
  `menu4Link` varchar(64) NOT NULL,
  `menu5Link` varchar(64) NOT NULL,
  `selamatDatang` varchar(32) NOT NULL,
  `moto` varchar(128) NOT NULL,
  `linkLabel` varchar(32) NOT NULL,
  `link` varchar(64) NOT NULL,
  `createdBy` int(11) NOT NULL,
  `updatedBy` int(11) NOT NULL,
  `updatedTS` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `mengapaTajuk` varchar(32) NOT NULL,
  `mengapaKeterangan` text NOT NULL,
  `mengapa1` varchar(32) NOT NULL,
  `mengapa12` text NOT NULL,
  `mengapa2` varchar(32) NOT NULL,
  `mengapa22` text NOT NULL,
  `mengapa3` varchar(32) NOT NULL,
  `mengapa32` text NOT NULL,
  `mengapa4` varchar(32) NOT NULL,
  `mengapa42` text NOT NULL,
  `mengapa5` varchar(32) NOT NULL,
  `mengapa52` text NOT NULL,
  `mengapa6` varchar(32) NOT NULL,
  `mengapa62` text NOT NULL,
  `portfolio` varchar(32) NOT NULL,
  `portfolioSub` varchar(128) NOT NULL,
  `portfolio1` varchar(32) NOT NULL,
  `portfolioSub1` varchar(128) NOT NULL,
  `portfolio2` varchar(32) NOT NULL,
  `portfolioSub2` varchar(128) NOT NULL,
  `portfolio3` varchar(32) NOT NULL,
  `portfolioSub3` varchar(128) NOT NULL,
  `portfolio4` varchar(32) NOT NULL,
  `portfolioSub4` varchar(128) NOT NULL,
  `portfolio5` varchar(32) NOT NULL,
  `portfolioSub5` varchar(128) NOT NULL,
  `portfolio6` varchar(32) NOT NULL,
  `portfolioSub6` varchar(128) NOT NULL,
  `portfolioImage1` longtext,
  `portfolioImage2` longtext,
  `portfolioImage3` longtext,
  `portfolioImage4` longtext,
  `portfolioImage5` longtext,
  `portfolioImage6` longtext,
  `portfolioText1` text NOT NULL,
  `portfolioText2` text NOT NULL,
  `portfolioText3` text NOT NULL,
  `portfolioText4` text NOT NULL,
  `portfolioText5` text NOT NULL,
  `portfolioText6` text NOT NULL,
  `about` varchar(32) NOT NULL,
  `aboutSub` varchar(128) NOT NULL,
  `aboutText` text NOT NULL,
  `about1` varchar(32) NOT NULL,
  `aboutSub1` varchar(128) NOT NULL,
  `aboutText1` text NOT NULL,
  `about2` varchar(32) NOT NULL,
  `aboutSub2` varchar(128) NOT NULL,
  `aboutText2` text NOT NULL,
  `about3` varchar(32) NOT NULL,
  `aboutSub3` varchar(128) NOT NULL,
  `aboutText3` text NOT NULL,
  `about4` varchar(32) NOT NULL,
  `aboutSub4` varchar(128) NOT NULL,
  `aboutText4` text NOT NULL,
  `aboutImage1` longtext,
  `aboutImage2` longtext,
  `aboutImage3` longtext,
  `aboutImage4` longtext,
  `aboutBulat` varchar(32) NOT NULL,
  `team` varchar(32) NOT NULL,
  `teamSub` varchar(128) NOT NULL,
  `teamFb` varchar(64) NOT NULL,
  `team1` varchar(32) NOT NULL,
  `teamSub1` varchar(128) NOT NULL,
  `teamFb1` varchar(64) NOT NULL,
  `team2` varchar(32) NOT NULL,
  `teamSub2` varchar(128) NOT NULL,
  `teamFb2` varchar(64) NOT NULL,
  `team3` varchar(32) NOT NULL,
  `teamSub3` varchar(128) NOT NULL,
  `teamFb3` varchar(64) NOT NULL,
  `teamTw1` varchar(64) NOT NULL,
  `teamTw2` varchar(64) NOT NULL,
  `teamTw3` varchar(64) NOT NULL,
  `teamLn1` varchar(64) NOT NULL,
  `teamLn2` varchar(64) NOT NULL,
  `teamLn3` varchar(64) NOT NULL,
  `teamImage1` longtext,
  `teamImage2` longtext,
  `teamImage3` longtext,
  `teamBawah` varchar(128) NOT NULL,
  `clientImage1` longtext,
  `clientImage2` longtext,
  `clientImage3` longtext,
  `clientImage4` longtext,
  `clientLink1` varchar(128) NOT NULL,
  `clientLink2` varchar(128) NOT NULL,
  `clientLink3` varchar(128) NOT NULL,
  `clientLink4` varchar(128) NOT NULL,
  `hubungiKami` text NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `_ref_web`
--

LOCK TABLES `_ref_web` WRITE;
/*!40000 ALTER TABLE `_ref_web` DISABLE KEYS */;
INSERT INTO `_ref_web` VALUES (1,'akmaluddin@salihin.com.my','SPS Lite','','Mengapa SPS Lite ?','Ciri-ciri','Testimoni','Langgan SPS Lite','Hubungi Kami','#services','#portfolio','#about-section','#team-section','#contact','Selamat Datang ke SPS Lite','Memudahkan Perniagaan Anda','Free Trial / Login','http://demo.spslite.my/login',0,0,'2016-07-20 03:36:48','Mengapa SPS Lite?','Mengapa SPS Lite','Responsif','Responsive dengan semua device termasuk tablet dan smartphone','Dwibahasa','Dalam Bahasa Malaysia dan Inggeris','Mesra Pengguna','','Untung dan Rugi','Laporan Untung dan Rugi semudah ABC','Kewangan','Laporan Kewangan semudah ABC','Pengkomputeran Awam','Membawa anda ke era Digital','Perkhidmatan Kami','Contoh-contoh Skrin dan Laporan','Jualan','Rekod Jualan','Perbelanjaan','Rekod Perbelanjaan','Umum','Ketetapan Umum','Laporan','Contoh-contoh laporan','Tetapan','Ketetapan setup Pentadbir','Pautan','Pautan Tambahan','','','','','','','','','','','','','testimoni','','','','','','','','','','','','','','','','','','','','Team Kami','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','Untuk melanggan SPS Lite, hubungi kami di talian +03-6185 9970 atau emel ke info@salihinpremier.com.');
/*!40000 ALTER TABLE `_ref_web` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `company`
--

DROP TABLE IF EXISTS `company`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `company` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `companyName` varchar(128) NOT NULL,
  `webPageName` varchar(128) NOT NULL,
  `companyNo` varchar(16) NOT NULL,
  `incorporateDate` date NOT NULL,
  `businessTypeID` int(11) NOT NULL,
  `line1` varchar(128) NOT NULL,
  `line2` varchar(128) NOT NULL,
  `line3` varchar(128) NOT NULL,
  `city` varchar(128) NOT NULL,
  `companyPostCode` varchar(8) NOT NULL,
  `companyStateID` int(11) NOT NULL,
  `phoneNo` varchar(16) NOT NULL,
  `faxNo` varchar(16) NOT NULL,
  `email` varchar(64) NOT NULL,
  `website` varchar(32) NOT NULL,
  `uploadLogo` varchar(64) NOT NULL,
  `currencyID` int(11) NOT NULL,
  `languageID` int(11) NOT NULL,
  `countryID` int(11) NOT NULL,
  `muslimShareholder` double NOT NULL,
  `gstRegisteredNo` varchar(16) NOT NULL,
  `gstRegisteredDate` date DEFAULT NULL,
  `gstSubmissionBuffer` int(16) NOT NULL,
  `taxablePeriod` smallint(6) NOT NULL,
  `masterMSIC` int(12) NOT NULL,
  `dateFormat` int(16) NOT NULL DEFAULT '1',
  `createdBy` int(11) NOT NULL,
  `createdTS` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updatedBy` int(11) NOT NULL,
  `updatedTS` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
  `is_delete` smallint(6) NOT NULL,
  `keyCode` varchar(128) NOT NULL,
  `userID` int(11) NOT NULL,
  `parlimenID` int(11) NOT NULL,
  `businessIndustryID` int(11) NOT NULL,
  `database` varchar(64) NOT NULL,
  `server` varchar(64) NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=74 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `company`
--

LOCK TABLES `company` WRITE;
/*!40000 ALTER TABLE `company` DISABLE KEYS */;
INSERT INTO `company` VALUES (1,'Demo Demo Demo Sdn Bhd','demo1','12345','2015-01-01',8,'demo demo demo demo','off jalan line 3','main road jalan 3,','Bt Caves','68100',1922,'603-6185997012','603-61857788','puterakatak29@gmail.com','http://www.salihin.com.my','1.JPG',1,0,458,100,'','1970-01-01',6,0,0,1,0,'2014-04-24 04:32:22',0,'2016-09-26 04:40:47',0,'vp8XYptujJYHpiFC+S7qvcaAnh2Lan6qYEbZPXSfcDE',1,5,2,'spslitem_tekun1db','../tekun1/'),(2,'fad and akmal sdn bhd','2','12345','2016-01-01',5,'','','','','',0,'','0','','0','',1,0,0,0,'0','0000-00-00',0,0,0,1,0,'2014-04-24 04:54:31',0,'2016-09-26 04:40:47',1,'vp8XYptujJYHpiFC+S7qvcaAnh2Lan6qYEbZPXSfcDE',2,0,0,'spslitem_tekun1db','../tekun1/'),(3,'Aizat Sdn Bhd','3','12345','2016-01-01',9,'234,Jalan Batu','Geliga Zamrud','','Batu Caves','68100',1931,'603-55414545','603-55415454','aizatsdn@yahoo.com','0','',1,0,458,100,'0','1970-01-01',0,0,0,1,0,'2014-04-24 06:51:10',0,'2016-10-27 02:15:54',0,'vp8XYptujJYHpiFC+S7qvcaAnh2Lan6qYEbZPXSfcDE',12,99,2,'spslitem_tekun1db','../tekun1/'),(12,'kedai-e.net','akmal','','2016-01-01',2,'no 16 jalan 9/12','taman 13','bandar 14','btcaves','123',1928,'123','123','farhana@salihin.com.my','','12.JPG',1,0,458,0,'',NULL,0,0,0,1,0,'2016-06-09 07:58:03',0,'2016-09-26 05:00:54',0,'',11,4,2,'spslitem_tekun1db','../tekun1/'),(13,'Aizat Demo Sdn Bhd','aizat','','2016-08-10',12,'No 1 jln 177','2/9','sri gombak','Bt Caves','68100',1931,'01222665578','01234','hihi@yahoo.com','','13.JPG',1,0,458,0,'',NULL,0,0,0,1,0,'2016-06-13 04:00:16',0,'2016-09-26 04:40:47',0,'',10,99,3,'spslitem_tekun1db','../tekun1/'),(14,'Hijrah Demo','HijrahPomade','','2015-01-01',13,'No, 5432','','Gombak','Gombak','45555',1931,'361855444','+60361855444','amin@supplier02.com','','',1,0,458,0,'',NULL,0,0,0,1,0,'2016-06-28 06:49:40',0,'2016-09-26 04:40:47',1,'',13,110,3,'spslitem_tekun1db','../tekun1/'),(15,'farhana testing','15','','2016-09-21',3,'555, Jalan Samudera Utara 1','Taman Samudera','','Batu Caves','68100',1931,'603 - 61859970','603 - 61842524','farhana@salihin.com.my','','',1,0,458,0,'',NULL,0,0,0,1,0,'2016-06-30 01:39:17',0,'2016-09-26 04:40:47',0,'',15,0,2,'spslitem_tekun1db','../tekun1/'),(16,'FadTesting','16','','0000-00-00',0,'No 1','No 1','No 1','Bt Caves','19800',1922,'01234','01234','melur@gmail.com','','',1,0,458,0,'',NULL,0,0,0,1,0,'2016-07-01 04:19:57',0,'2016-09-26 04:40:47',1,'',16,0,0,'spslitem_tekun1db','../tekun1/'),(17,'testingdemo','17','','0000-00-00',0,'','','','','',0,'','','','','',1,0,0,0,'',NULL,0,0,0,1,0,'2016-07-01 04:22:48',0,'2016-09-26 04:40:47',1,'',17,0,0,'spslitem_tekun1db','../tekun1/'),(18,'fanatestingpadamdelete','18','','0000-00-00',0,'','','','','',0,'','','','','',1,0,0,0,'',NULL,0,0,0,1,0,'2016-08-05 12:02:02',0,'2016-09-26 04:40:47',1,'',18,0,0,'spslitem_tekun1db','../tekun1/'),(19,'company fana testing','19','','0000-00-00',0,'','','','','',0,'','','','','',1,0,0,0,'',NULL,0,0,0,1,0,'2016-08-05 12:04:11',0,'2016-11-16 02:58:38',1,'',19,0,0,'spslitem_tekun1db','../tekun1/'),(20,'fanatestingpadamdelete','20','','1970-01-01',3,'','','','','',0,'','','','','',1,0,0,0,'',NULL,0,0,0,1,0,'2016-08-05 12:23:27',0,'2016-09-26 04:40:47',1,'',20,0,2,'spslitem_tekun1db','../tekun1/'),(21,'Pokemon Go Sdn. Bhd.','21','','2016-01-01',11,'LOT 5555','','BATU CAVES','BATU CAVES','53100',1931,'01190902134','','','','21.JPG',1,0,458,0,'',NULL,0,0,0,1,0,'2016-08-10 03:08:33',0,'2016-09-26 04:40:47',1,'',21,99,3,'spslitem_tekun1db','../tekun1/'),(22,'Ahfat77','22','','0000-00-00',0,'fad','fad','fad','Bt Caves','68100',1921,'012345','012345','fad@gmail.com','','',1,0,458,0,'',NULL,0,0,0,1,0,'2016-08-11 03:12:19',0,'2016-09-26 04:40:47',1,'',0,141,0,'spslitem_tekun1db','../tekun1/'),(23,'Pikachu Sdn Bhd','hijrah.comsali','','2016-01-01',7,'LOT 5555','taman samudra','BATU CAVES','BATU CAVES','53100',1931,'','','','','',1,0,458,0,'',NULL,0,0,0,1,0,'2016-08-11 08:32:14',0,'2016-09-26 04:40:47',1,'',0,99,2,'spslitem_tekun1db','../tekun1/'),(24,'Panasonic ','24','','2016-01-01',18,'No 12','Jalan 34','Kawasan Industri Panasonic','Bandar Panasonic','43500',1931,'0132897186','','superabu92@gmail.com','','24.JPG',1,0,458,0,'',NULL,0,0,0,1,0,'2016-08-16 03:18:32',0,'2016-09-26 04:40:47',0,'',0,93,3,'spslitem_tekun1db','../tekun1/'),(25,'kedai cermin mata','25','','2016-08-16',8,'no 54','jalan cermin','kawasan industri cermin','bandar mata','85000',1930,'','','','','25.JPG',1,0,458,0,'',NULL,0,0,0,1,0,'2016-08-16 03:19:28',0,'2016-09-26 04:40:47',1,'',0,192,2,'spslitem_tekun1db','../tekun1/'),(26,'HAS APPAREL SDN BHD','26','','2016-08-18',8,'No. 800, Jalan Kelana Jaya','','Kelana Jaya','Kelana Jaya','68500',1922,'0125556633','+60361855444','has@gmail.com','','',1,0,458,0,'',NULL,0,0,0,1,0,'2016-08-19 09:02:01',0,'2016-09-26 04:40:47',0,'',0,5,2,'spslitem_tekun1db','../tekun1/'),(32,'Habbatussauda','','','0000-00-00',0,'123','123','123','Bt Caves','68100',1932,'01234567','012234567','hihi@yahoo.com','','',1,0,458,0,'',NULL,0,0,0,1,0,'2016-09-05 12:53:33',0,'2016-09-26 04:40:47',1,'',0,116,0,'spslitem_tekun1db','../tekun1/'),(33,'RAHMAT MAZNAH SDN BHD','','','0000-00-00',0,'No. 48, Lorong Kerayong 5A','Taman Seri Kerayong','Klang','Klang','42200',1931,'0129020146','0129020146','hijrahrahmat@gmail.com','','',1,0,458,0,'',NULL,0,0,0,1,0,'2016-09-26 03:47:16',0,'2016-09-26 04:41:46',1,'',0,110,0,'spslitem_tekun1db','../tekun1/'),(34,'RAHMAT MAZNAH 1 SDN BHD','','','0000-00-00',0,'No. 48, Lorong Kerayong 5A','Taman Seri Kerayong','','Klang','42200',1931,'0172434817','-','-','','',1,0,458,0,'',NULL,0,0,0,1,0,'2016-09-26 03:48:13',0,'2016-11-17 05:17:45',1,'',0,110,0,'spslitem_tekun1db','../tekun1/'),(35,'RAHMAT MAZNAH 2 SDN BHD','','','0000-00-00',0,'No. 48, Lorong Kerayong 5A','Taman Seri Kerayong','','Klang','42200',1931,'0129020146','-','-','','',1,0,458,0,'',NULL,0,0,0,1,0,'2016-09-26 04:07:13',0,'2016-11-17 05:17:52',1,'',0,110,0,'spslitem_tekun1db','../tekun1/'),(36,'RAHMAT MAZNAH 3 SDN BHD','','','0000-00-00',0,'No. 48, Lorong Kerayong 5A','Taman Seri Kerayong','Klang','Klang','42200',1931,'0129020146','0129020146','hijrahrahmat@gmail.com','','',1,0,458,0,'',NULL,0,0,0,1,0,'2016-09-26 04:25:54',0,'2016-11-17 05:17:58',1,'',0,110,0,'spslitem_tekun1db','../tekun1/'),(37,'RAHMAT MAZNAH 4 SDN BHD','','','0000-00-00',0,'No. 48, Lorong Kerayong 5A','Taman Seri Kerayong','','Klang','42200',1931,'0129020146','','','','',1,0,458,0,'',NULL,0,0,0,1,0,'2016-09-26 04:40:17',0,'2016-11-17 05:18:03',1,'',0,110,0,'spslitem_tekun1db','../tekun1/'),(38,'RAHMAT MAZNAH 5 SDN BHD','','','0000-00-00',0,'No. 48, Lorong Kerayong 5A','Taman Seri Kerayong','','Klang','42200',1931,'0129020146','','','','',1,0,458,0,'',NULL,0,0,0,1,0,'2016-09-26 04:41:10',0,'2016-11-17 05:18:10',1,'',0,110,0,'spslitem_tekun1db','../tekun1/'),(39,'RAHMAT MAZNAH SDN BHD','mrsb','','2016-01-01',3,'No. 48, Lorong Kerayong 5A','Taman Seri Kerayong','Klang','Klang','42200',1931,'129020146','0129020146','','','',1,0,458,0,'',NULL,0,0,0,1,0,'2016-09-26 04:42:32',0,'2016-09-27 07:31:21',1,'',0,110,2,'spslitem_tekun1db','../tekun1/'),(40,'RESTORAN MAKANAN','Halalhub','','2016-01-01',9,'No. 48, Lorong Kerayong 5A','Taman Seri Kerayong','','Klang','42200',1931,'0129020146','0129020146','','','',1,0,458,0,'',NULL,0,0,0,1,0,'2016-09-28 07:35:53',0,'2016-11-22 02:36:22',0,'',0,110,2,'spslitem_tekun1db','../tekun1/'),(41,'haihai sdn bhd','','','0000-00-00',0,'fad','fad','fad','fad','12345',1922,'123','123','haihai@yahoo.com','','',1,0,458,0,'',NULL,0,0,0,1,0,'2016-10-06 01:02:58',0,'0000-00-00 00:00:00',0,'',0,5,0,'spslitem_tekun1db','../tekun1/'),(73,'eminem sdn bhd','','','2016-12-06',2,'','','','','',0,'','','','','',0,0,0,0,'',NULL,0,0,0,1,0,'2016-10-18 00:55:38',0,'2016-12-06 04:28:27',0,'',0,0,2,'spslitem_tekun1db','../tekun1/');
/*!40000 ALTER TABLE `company` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `dun`
--

DROP TABLE IF EXISTS `dun`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `dun` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `stateID` int(11) NOT NULL,
  `parlimenID` int(11) NOT NULL,
  `dunCode` int(11) NOT NULL,
  `dun` varchar(32) NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `dun`
--

LOCK TABLES `dun` WRITE;
/*!40000 ALTER TABLE `dun` DISABLE KEYS */;
/*!40000 ALTER TABLE `dun` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `forget_password`
--

DROP TABLE IF EXISTS `forget_password`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `forget_password` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `security_key` varchar(32) NOT NULL,
  `userID` int(11) NOT NULL,
  `updateAble` int(11) NOT NULL DEFAULT '1',
  `create_dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `forget_password`
--

LOCK TABLES `forget_password` WRITE;
/*!40000 ALTER TABLE `forget_password` DISABLE KEYS */;
/*!40000 ALTER TABLE `forget_password` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `parlimen`
--

DROP TABLE IF EXISTS `parlimen`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `parlimen` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `parlimenCode` varchar(4) NOT NULL,
  `stateID` int(11) NOT NULL,
  `parlimen` varchar(32) NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=224 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `parlimen`
--

LOCK TABLES `parlimen` WRITE;
/*!40000 ALTER TABLE `parlimen` DISABLE KEYS */;
INSERT INTO `parlimen` VALUES (2,'P001',1928,'PADANG BESAR	'),(3,'P002',1928,'KANGAR	'),(4,'P003',1928,'ARAU	'),(5,'P004',1922,'LANGKAWI	'),(6,'P005',1922,'JERLUN	'),(7,'P006',1922,'KUBANG PASU	'),(8,'P007',1922,'PADANG TERAP	'),(9,'P008',1922,'POKOK SENA	'),(10,'P009',1922,'ALOR STAR	'),(11,'P010',1922,'KUALA KEDAH	'),(12,'P011',1922,'PENDANG	'),(13,'P012',1922,'JERAI	'),(14,'P013',1922,'SIK	'),(15,'P014',1922,'MERBOK	'),(16,'P015',1922,'SUNGAI PETANI	'),(17,'P016',1922,'BALING	'),(18,'P017',1922,'PADANG SERAI	'),(19,'P018',1922,'KULIM/BANDAR BAHARU	'),(20,'P019',1923,'TUMPAT	'),(21,'P020',1923,'PENGKALAN CHEPA	'),(22,'P021',1923,'KOTA BHARU	'),(23,'P022',1923,'PASIR MAS	'),(24,'P023',1923,'RANTAU PANJANG	'),(25,'P024',1923,'KUBANG KERIAN	'),(26,'P025',1923,'BACHOK	'),(27,'P026',1923,'KETEREH	'),(28,'P027',1923,'TANAH MERAH	'),(29,'P028',1923,'PASIR PUTEH	'),(30,'P029',1923,'MACHANG	'),(31,'P030',1923,'JELI	'),(32,'P031',1923,'KUALA KRAI	'),(33,'P032',1923,'GUA MUSANG	'),(34,'P033',1932,'BESUT	'),(35,'P034',1932,'SETIU	'),(36,'P035',1932,'KUALA NERUS	'),(37,'P036',1932,'KUALA TERENGGANU	'),(38,'P037',1932,'MARANG	'),(39,'P038',1932,'HULU TERENGGANU	'),(40,'P039',1932,'DUNGUN	'),(41,'P040',1932,'KEMAMAN	'),(42,'P041',1929,'KEPALA BATAS	'),(43,'P042',1929,'TASEK GELUGOR	'),(44,'P043',1929,'BAGAN	'),(45,'P044',1929,'PERMATANG PAUH	'),(46,'P045',1929,'BUKIT MERTAJAM	'),(47,'P046',1929,'BATU KAWAN	'),(48,'P047',1929,'NIBONG TEBAL	'),(49,'P048',1929,'BUKIT BENDERA	'),(50,'P049',1929,'TANJONG	'),(51,'P050',1929,'JELUTONG	'),(52,'P051',1929,'BUKIT GELUGOR	'),(53,'P052',1929,'BAYAN BARU	'),(54,'P053',1929,'BALIK PULAU	'),(55,'P054',1927,'GERIK	'),(56,'P055',1927,'LENGGONG	'),(57,'P056',1927,'LARUT	'),(58,'P057',1927,'PARIT BUNTAR	'),(59,'P058',1927,'BAGAN SERAI	'),(60,'P059',1927,'BUKIT GANTANG	'),(61,'P060',1927,'TAIPING	'),(62,'P061',1927,'PADANG RENGAS	'),(63,'P062',1927,'SUNGAI SIPUT	'),(64,'P063',1927,'TAMBUN	'),(65,'P064',1927,'IPOH TIMOR	'),(66,'P065',1927,'IPOH BARAT	'),(67,'P066',1927,'BATU GAJAH	'),(68,'P067',1927,'KUALA KANGSAR	'),(69,'P068',1927,'BERUAS	'),(70,'P069',1927,'PARIT	'),(71,'P070',1927,'KAMPAR	'),(72,'P071',1927,'GOPENG	'),(73,'P072',1927,'TAPAH	'),(74,'P073',1927,'PASIR SALAK	'),(75,'P074',1927,'LUMUT	'),(76,'P075',1927,'BAGAN DATOK	'),(77,'P076',1927,'TELOK INTAN	'),(78,'P077',1927,'TANJONG MALIM	'),(79,'P078',1926,'CAMERON HIGHLANDS	'),(80,'P079',1926,'LIPIS	'),(81,'P080',1926,'RAUB	'),(82,'P081',1926,'JERANTUT	'),(83,'P082',1926,'INDERA MAHKOTA	'),(84,'P083',1926,'KUANTAN	'),(85,'P084',1926,'PAYA BESAR	'),(86,'P085',1926,'PEKAN	'),(87,'P086',1926,'MARAN	'),(88,'P087',1926,'KUALA KRAU	'),(89,'P088',1926,'TEMERLOH	'),(90,'P089',1926,'BENTONG	'),(91,'P090',1926,'BERA	'),(92,'P091',1926,'ROMPIN	'),(93,'P092',1931,'SABAK BERNAM	'),(94,'P093',1931,'SUNGAI BESAR	'),(95,'P094',1931,'HULU SELANGOR	'),(96,'P095',1931,'TANJONG KARANG	'),(97,'P096',1931,'KUALA SELANGOR	'),(98,'P097',1931,'SELAYANG	'),(99,'P098',1931,'GOMBAK	'),(100,'P099',1931,'AMPANG	'),(101,'P100',1931,'PANDAN	'),(102,'P101',1931,'HULU LANGAT	'),(103,'P102',1931,'SERDANG	'),(104,'P103',1931,'PUCHONG	'),(105,'P104',1931,'KELANA JAYA	'),(106,'P105',1931,'PETALING JAYA SELATAN	'),(107,'P106',1931,'PETALING JAYA UTARA	'),(108,'P107',1931,'SUBANG	'),(109,'P108',1931,'SHAH ALAM	'),(110,'P109',1931,'KAPAR	'),(111,'P110',1931,'KLANG	'),(112,'P111',1931,'KOTA RAJA	'),(113,'P112',1931,'KUALA LANGAT	'),(114,'P113',1931,'SEPANG	'),(115,'P114',1931,'KEPONG   	'),(116,'P115',1933,'BATU	'),(117,'P116',1933,'WANGSA MAJU	'),(118,'P117',1933,'SEGAMBUT   	'),(119,'P118',1933,'SETIAWANGSA 	'),(120,'P119',1933,'TITIWANGSA	'),(121,'P120',1933,'BUKIT BINTANG 	'),(122,'P121',1933,'LEMBAH PANTAI 	'),(123,'P122',1933,'SEPUTEH	'),(124,'P123',1933,'CHERAS   	'),(125,'P124',1933,'BANDAR TUN RAZAK	'),(126,'P125',1936,'PUTRAJAYA	'),(127,'P126',1925,'JELEBU	'),(128,'P127',1925,'JEMPOL	'),(129,'P128',1925,'SEREMBAN	'),(130,'P129',1925,'KUALA PILAH	'),(131,'P130',1925,'RASAH	'),(132,'P131',1925,'REMBAU	'),(133,'P132',1925,'TELOK KEMANG	'),(134,'P133',1925,'TAMPIN	'),(135,'P134',1924,'MASJID TANAH	'),(136,'P135',1924,'ALOR GAJAH	'),(137,'P136',1924,'TANGGA BATU	'),(138,'P137',1924,'BUKIT KATIL	'),(139,'P138',1924,'KOTA MELAKA	'),(140,'P139',1924,'JASIN	'),(141,'P140',1921,'SEGAMAT	'),(142,'P141',1921,'SEKIJANG	'),(143,'P142',1921,'LABIS	'),(144,'P143',1921,'PAGOH	'),(145,'P144',1921,'LEDANG	'),(146,'P145',1921,'BAKRI	'),(147,'P146',1921,'MUAR	'),(148,'P147',1921,'PARIT SULONG	'),(149,'P148',1921,'AYER HITAM	'),(150,'P149',1921,'SRI GADING	'),(151,'P150',1921,'BATU PAHAT	'),(152,'P151',1921,'SIMPANG RENGGAM	'),(153,'P152',1921,'KLUANG	'),(154,'P153',1921,'SEMBRONG	'),(155,'P154',1921,'MERSING	'),(156,'P155',1921,'TENGGARA	'),(157,'P156',1921,'KOTA TINGGI	'),(158,'P157',1921,'PENGERANG	'),(159,'P158',1921,'TEBRAU	'),(160,'P159',1921,'PASIR GUDANG	'),(161,'P160',1921,'JOHOR BAHRU	'),(162,'P161',1921,'PULAI	'),(163,'P162',1921,'GELANG PATAH	'),(164,'P163',1921,'KULAI	'),(165,'P164',1921,'PONTIAN	'),(166,'P165',1921,'TANJONG PIAI	'),(167,'P166',1934,'LABUAN	'),(168,'P167',1935,'KUDAT	'),(169,'P168',1935,'KOTA MARUDU	'),(170,'P169',1935,'KOTA BELUD	'),(171,'P170',1935,'TUARAN	'),(172,'P171',1935,'SEPANGGAR	'),(173,'P172',1935,'KOTA KINABALU	'),(174,'P173',1935,'PUTATAN	'),(175,'P174',1935,'PENAMPANG	'),(176,'P175',1935,'PAPAR	'),(177,'P176',1935,'KIMANIS	'),(178,'P177',1935,'BEAUFORT	'),(179,'P178',1935,'SIPITANG	'),(180,'P179',1935,'RANAU	'),(181,'P180',1935,'KENINGAU	'),(182,'P181',1935,'TENOM	'),(183,'P182',1935,'PENSIANGAN	'),(184,'P183',1935,'BELURAN	'),(185,'P184',1935,'LIBARAN	'),(186,'P185',1935,'BATU SAPI	'),(187,'P186',1935,'SANDAKAN	'),(188,'P187',1935,'KINABATANGAN	'),(189,'P188',1935,'SILAM	'),(190,'P189',1935,'SEMPORNA	'),(191,'P190',1935,'TAWAU	'),(192,'P191',1930,'KALABAKAN	'),(193,'P192',1930,'MAS GADING	'),(194,'P193',1930,'SANTUBONG	'),(195,'P194',1930,'PETRA JAYA	'),(196,'P195',1930,'BANDAR KUCHING	'),(197,'P196',1930,'STAMPIN	'),(198,'P197',1930,'KOTA SAMARAHAN	'),(199,'P198',1930,'MAMBONG	'),(200,'P199',1930,'SERIAN	'),(201,'P200',1930,'BATANG SADONG	'),(202,'P201',1930,'BATANG LUPAR	'),(203,'P202',1930,'SRI AMAN	'),(204,'P203',1930,'LUBOK ANTU	'),(205,'P204',1930,'BETONG	'),(206,'P205',1930,'SARATOK	'),(207,'P206',1930,'TANJONG MANIS	'),(208,'P207',1930,'IGAN	'),(209,'P208',1930,'SARIKEI	'),(210,'P209',1930,'JULAU	'),(211,'P210',1930,'KANOWIT	'),(212,'P211',1930,'LANANG	'),(213,'P212',1930,'SIBU	'),(214,'P213',1930,'MUKAH	'),(215,'P214',1930,'SELANGAU	'),(216,'P215',1930,'KAPIT	'),(217,'P216',1930,'HULU RAJANG	'),(218,'P217',1930,'BINTULU	'),(219,'P218',1930,'SIBUTI	'),(220,'P219',1930,'MIRI	'),(221,'P220',1930,'BARAM	'),(222,'P221',1930,'LIMBANG	'),(223,'P222',1930,'LAWAS	');
/*!40000 ALTER TABLE `parlimen` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `payment_receive`
--

DROP TABLE IF EXISTS `payment_receive`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `payment_receive` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `userID` int(11) NOT NULL,
  `dateReceive` date NOT NULL,
  `period` int(11) NOT NULL,
  `totalAmount` int(11) NOT NULL,
  `nextExpiracy` date NOT NULL,
  `createdBy` int(11) NOT NULL,
  `createdTS` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updatedBy` int(11) NOT NULL,
  `updatedTS` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `is_delete` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=68 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `payment_receive`
--

LOCK TABLES `payment_receive` WRITE;
/*!40000 ALTER TABLE `payment_receive` DISABLE KEYS */;
INSERT INTO `payment_receive` VALUES (1,1,'2016-04-01',12,2000,'2017-03-31',1,'2016-10-24 02:29:01',0,'0000-00-00 00:00:00',1),(2,11,'2016-04-01',12,200,'2017-03-31',2,'2016-10-25 07:32:42',0,'0000-00-00 00:00:00',0),(10,2,'2016-06-09',12,240,'2017-06-08',2,'2016-10-24 02:34:25',0,'0000-00-00 00:00:00',1),(11,10,'2016-06-09',12,240,'2017-06-08',10,'2016-06-10 01:00:02',0,'0000-00-00 00:00:00',0),(12,12,'2016-04-01',24,480,'2018-03-31',11,'2016-10-24 02:34:49',0,'0000-00-00 00:00:00',1),(13,13,'2016-04-01',24,480,'2018-03-31',12,'2016-11-09 01:10:00',0,'0000-00-00 00:00:00',0),(15,15,'2016-06-10',12,240,'2017-06-09',0,'2016-06-10 05:04:07',0,'0000-00-00 00:00:00',0),(16,16,'2016-06-27',12,240,'2017-06-26',0,'2016-06-27 03:37:40',0,'0000-00-00 00:00:00',0),(17,17,'2016-06-28',12,240,'2017-06-27',0,'2016-06-28 06:50:33',0,'0000-00-00 00:00:00',0),(18,18,'2014-06-30',12,240,'2015-06-29',0,'2016-07-11 01:50:22',0,'0000-00-00 00:00:00',0),(23,11,'2016-05-01',1,20,'2016-05-30',11,'2016-07-01 07:33:34',0,'0000-00-00 00:00:00',0),(25,18,'2016-07-11',12,240,'2017-07-10',18,'2016-07-11 04:51:56',2,'0000-00-00 00:00:00',0),(26,10,'2017-06-09',1,20,'2017-07-08',10,'2016-07-13 01:58:24',0,'2016-07-13 01:58:24',0),(27,10,'2017-07-09',12,240,'2018-07-08',10,'2016-07-13 01:58:37',0,'2016-07-13 01:58:37',0),(28,10,'2018-07-09',24,480,'2020-07-08',10,'2016-07-13 02:04:42',0,'2016-07-13 02:04:42',0),(29,19,'2016-07-14',12,240,'2017-07-13',0,'2016-07-14 04:34:02',0,'2016-07-14 04:34:02',0),(30,20,'2016-07-29',0,0,'1970-01-01',0,'2016-07-29 07:51:22',0,'2016-07-29 07:51:22',0),(31,21,'2016-07-29',0,0,'1970-01-01',0,'2016-07-29 07:51:58',0,'2016-07-29 07:51:58',0),(32,22,'2016-07-29',0,0,'1970-01-01',0,'2016-07-29 07:55:06',0,'2016-07-29 07:55:06',0),(33,23,'2016-08-03',0,0,'1970-01-01',0,'2016-08-03 01:28:00',0,'2016-08-03 01:28:00',0),(34,24,'2016-08-08',12,240,'2017-08-07',0,'2016-08-08 02:19:36',0,'2016-08-08 02:19:36',0),(35,25,'2016-08-10',0,0,'1970-01-01',0,'2016-08-10 03:10:29',0,'2016-08-10 03:10:29',0),(36,25,'2016-08-10',12,240,'2017-08-09',25,'2016-08-10 03:14:42',0,'2016-08-10 03:14:42',0),(37,26,'2016-08-10',12,240,'2017-08-09',0,'2016-08-10 09:47:39',0,'2016-08-10 09:47:39',0),(38,27,'2016-08-10',12,240,'2017-08-09',0,'2016-08-10 09:48:46',0,'2016-08-10 09:48:46',0),(39,28,'2016-08-11',12,240,'2017-08-10',0,'2016-08-11 02:42:08',0,'2016-08-11 02:42:08',0),(40,29,'2016-08-11',12,240,'2017-08-10',0,'2016-08-11 03:13:28',0,'2016-08-11 03:13:28',0),(41,29,'2017-08-11',12,240,'2018-08-10',29,'2016-08-11 04:35:08',0,'2016-08-11 04:35:08',0),(42,30,'2016-08-11',12,240,'2017-08-10',0,'2016-08-11 04:43:41',0,'2016-08-11 04:43:41',0),(43,31,'2016-08-16',12,240,'2017-08-15',0,'2016-08-16 03:20:25',0,'2016-08-16 03:20:25',0),(44,32,'2016-08-16',12,240,'2017-08-15',0,'2016-08-16 03:21:15',0,'2016-08-16 03:21:15',0),(45,33,'2016-06-01',1,20,'2016-07-30',0,'2016-08-19 09:03:45',0,'2016-08-19 09:03:45',0),(46,33,'2016-08-19',1,20,'2016-09-18',33,'2016-08-19 09:05:19',0,'2016-08-19 09:05:19',0),(47,34,'2016-09-05',1,20,'2016-10-04',0,'2016-09-05 02:15:15',0,'2016-09-05 02:15:15',0),(48,36,'2016-09-21',0,0,'1970-01-01',0,'2016-09-21 07:02:07',0,'2016-09-21 07:02:07',0),(49,37,'2016-11-16',12,240,'2016-12-05',0,'2016-11-16 07:20:38',0,'2016-10-06 06:14:41',0),(66,71,'2016-10-18',9,180,'2016-09-17',0,'2016-10-18 00:55:40',0,'2016-10-18 00:55:40',0),(67,71,'2016-11-09',12,120,'2017-11-08',71,'2016-12-01 01:08:46',0,'2016-11-09 02:55:25',0);
/*!40000 ALTER TABLE `payment_receive` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `payment_receive_backup`
--

DROP TABLE IF EXISTS `payment_receive_backup`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `payment_receive_backup` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `userID` int(11) NOT NULL,
  `dateReceive` date NOT NULL,
  `period` int(11) NOT NULL,
  `totalAmount` int(11) NOT NULL,
  `nextExpiracy` date NOT NULL,
  `createdBy` int(11) NOT NULL,
  `createdTS` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updatedBy` int(11) NOT NULL,
  `updatedTS` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `is_delete` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `payment_receive_backup`
--

LOCK TABLES `payment_receive_backup` WRITE;
/*!40000 ALTER TABLE `payment_receive_backup` DISABLE KEYS */;
INSERT INTO `payment_receive_backup` VALUES (1,1,'2016-04-01',12,2000,'2017-03-31',1,'2016-05-04 18:16:42',0,'0000-00-00 00:00:00',0),(2,11,'2016-04-01',12,200,'2017-03-31',2,'2016-06-09 16:42:49',0,'0000-00-00 00:00:00',0),(10,2,'2016-06-09',12,240,'2017-06-08',2,'2016-06-09 00:16:03',0,'0000-00-00 00:00:00',0),(11,10,'2016-06-09',12,240,'2017-06-08',10,'2016-06-09 17:00:02',0,'0000-00-00 00:00:00',0),(12,12,'2016-04-01',24,480,'2018-03-31',11,'2016-06-09 18:23:43',0,'0000-00-00 00:00:00',0),(13,13,'2016-04-01',24,480,'2018-03-31',12,'2016-06-09 18:24:08',0,'0000-00-00 00:00:00',0),(15,15,'2016-06-10',12,240,'2017-06-09',0,'2016-06-09 21:04:07',0,'0000-00-00 00:00:00',0),(16,16,'2016-06-27',12,240,'2017-06-26',0,'2016-06-26 19:37:40',0,'0000-00-00 00:00:00',0),(17,17,'2016-06-28',12,240,'2017-06-27',0,'2016-06-27 22:50:33',0,'0000-00-00 00:00:00',0),(18,18,'2014-06-30',12,240,'2015-06-29',0,'2016-07-10 17:50:22',0,'0000-00-00 00:00:00',0),(23,11,'2016-05-01',1,20,'2016-05-30',11,'2016-06-30 23:33:34',0,'0000-00-00 00:00:00',0),(25,18,'2016-07-11',12,240,'2017-07-10',18,'2016-07-10 18:03:56',0,'0000-00-00 00:00:00',0);
/*!40000 ALTER TABLE `payment_receive_backup` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `server`
--

DROP TABLE IF EXISTS `server`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `server` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `server` varchar(64) CHARACTER SET latin1 NOT NULL,
  `database` varchar(32) CHARACTER SET latin1 NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `server`
--

LOCK TABLES `server` WRITE;
/*!40000 ALTER TABLE `server` DISABLE KEYS */;
INSERT INTO `server` VALUES (1,'tekun1','tekun1db');
/*!40000 ALTER TABLE `server` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tbl_usermaster`
--

DROP TABLE IF EXISTS `tbl_usermaster`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_usermaster` (
  `fldid` int(11) NOT NULL AUTO_INCREMENT,
  `userid` varchar(50) CHARACTER SET utf8 NOT NULL DEFAULT '0',
  `password` varchar(32) CHARACTER SET utf8 DEFAULT '0',
  `username` varchar(150) CHARACTER SET utf8 DEFAULT NULL,
  `position` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `email` varchar(100) CHARACTER SET utf8 DEFAULT NULL,
  `homepage` varchar(100) CHARACTER SET utf8 DEFAULT NULL,
  `phone_off` varchar(30) CHARACTER SET utf8 DEFAULT NULL,
  `phone_ext` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
  `phone_mobile` varchar(100) CHARACTER SET utf8 DEFAULT NULL,
  `department` varchar(18) CHARACTER SET utf8 DEFAULT NULL,
  `section` varchar(18) CHARACTER SET utf8 DEFAULT NULL,
  `role` varchar(150) CHARACTER SET utf8 DEFAULT NULL,
  `status` smallint(1) DEFAULT NULL,
  `birthday` date DEFAULT NULL,
  `imageFile` varchar(254) CHARACTER SET utf8 NOT NULL,
  `online` int(5) NOT NULL,
  `last_seen` datetime NOT NULL ON UPDATE CURRENT_TIMESTAMP,
  `access_comp` varchar(255) CHARACTER SET utf8 NOT NULL,
  `last_seen_ip` varchar(30) CHARACTER SET utf8 NOT NULL,
  `create_dt` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `create_user` varchar(150) CHARACTER SET utf8 DEFAULT NULL,
  `modified_dt` date DEFAULT NULL,
  `modified_user` varchar(150) CHARACTER SET utf8 DEFAULT NULL,
  `is_delete` smallint(6) DEFAULT '0',
  `language` varchar(10) CHARACTER SET utf8 NOT NULL,
  PRIMARY KEY (`fldid`)
) ENGINE=InnoDB AUTO_INCREMENT=72 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tbl_usermaster`
--

LOCK TABLES `tbl_usermaster` WRITE;
/*!40000 ALTER TABLE `tbl_usermaster` DISABLE KEYS */;
INSERT INTO `tbl_usermaster` VALUES (1,'tekun@gmail.com','827ccb0eea8a706c4c34a16891f84e7b','tekun@gmail.com',NULL,'tekun@gmail.com',NULL,NULL,NULL,'017442699822','0','0','User',NULL,NULL,'',0,'2016-11-18 16:59:01','8103','192.168.1.211','2014-01-24 07:55:05','2','2016-04-14','tekun@admin.com',0,'en'),(2,'fad@admin.com','827ccb0eea8a706c4c34a16891f84e7b','fad@admin.com',NULL,'fad@admin.com',NULL,NULL,NULL,'0123456789','IT',NULL,'User',NULL,NULL,'1.png',0,'2016-11-18 16:58:59','6990','192.168.1.198','2016-05-05 01:32:26','2',NULL,NULL,0,'en'),(10,'aizat@gmail.com','827ccb0eea8a706c4c34a16891f84e7b','aizat@gmail.com',NULL,'aizat@gmail.com',NULL,NULL,NULL,'03-55109090','0','0','User',NULL,NULL,'1.png',0,'2016-12-08 12:07:55','1848','115.164.82.12','2016-06-09 06:33:47','2','2016-09-01','0',0,'en'),(11,'akmaluddin@salihin.com.my','827ccb0eea8a706c4c34a16891f84e7b','akmaluddin@salihin.com.my',NULL,'akmaluddin@salihin.com.my',NULL,NULL,NULL,'0123456',NULL,NULL,'User',NULL,NULL,'1.png',0,'2016-12-09 12:12:23','7677','192.168.1.192','2016-06-09 07:59:15','2',NULL,NULL,0,'en'),(12,'salikeen@salihin.com.my','827ccb0eea8a706c4c34a16891f84e7b','salikeen@salihin.com.my',NULL,'salikeen@salihin.com.my',NULL,NULL,NULL,'',NULL,NULL,'User',NULL,NULL,'1.png',0,'2016-11-18 16:58:53','5603','192.168.1.254','2016-06-10 01:26:45','2',NULL,NULL,0,'en'),(13,'azri@gmail.com','827ccb0eea8a706c4c34a16891f84e7b','azri@gmail.com',NULL,'azri@gmail.com',NULL,NULL,NULL,'0123',NULL,NULL,'User',NULL,NULL,'1.png',0,'2016-11-18 16:58:51','5464','192.168.1.192','2016-06-10 01:28:57','2',NULL,NULL,0,'en'),(15,'syed@gmail.com','827ccb0eea8a706c4c34a16891f84e7b','syed@gmail.com',NULL,'syed@gmail.com',NULL,NULL,NULL,'1234',NULL,NULL,'User',NULL,NULL,'',0,'2016-11-18 16:58:49','8650','192.168.1.211','2016-06-10 05:04:07','2',NULL,NULL,0,'en'),(16,'salikeen@gmail.com','827ccb0eea8a706c4c34a16891f84e7b','salikeen@gmail.com',NULL,'salikeen@gmail.com',NULL,NULL,NULL,'12345',NULL,NULL,'User',NULL,NULL,'',0,'2016-11-18 16:58:47','6860','192.168.1.198','2016-06-27 03:37:40','2',NULL,NULL,0,'en'),(17,'hijrah@gmail.com','827ccb0eea8a706c4c34a16891f84e7b','hijrah@gmail.com',NULL,'hijrah@gmail.com',NULL,NULL,NULL,'dsdd',NULL,NULL,'User',NULL,NULL,'',0,'2016-11-18 16:58:45','9419','192.168.1.201','2016-06-28 06:50:32','2',NULL,NULL,1,'en'),(18,'farhana@salihin.com.my','827ccb0eea8a706c4c34a16891f84e7b','farhana@salihin.com.my',NULL,'farhana@salihin.com.my',NULL,NULL,NULL,'603-61881818',NULL,NULL,'User',NULL,NULL,'',0,'0000-00-00 00:00:00','1357','192.168.1.203','2016-06-30 02:34:46','2',NULL,NULL,0,'en'),(19,'fanatesting@gmail.com','827ccb0eea8a706c4c34a16891f84e7b','fanatesting@gmail.com',NULL,'fanatesting@gmail.com',NULL,NULL,NULL,'0361859970',NULL,NULL,'User',NULL,NULL,'',0,'2016-11-18 16:59:05','','','2016-07-14 04:34:02','2',NULL,NULL,1,'en'),(20,'fana@gmail.com','96e79218965eb72c92a549dd5a330112','fana@gmail.com',NULL,'fana@gmail.com',NULL,NULL,NULL,'',NULL,NULL,'User',NULL,NULL,'',0,'2016-11-18 16:59:06','','','2016-07-29 07:51:22','2',NULL,NULL,1,'en'),(21,'fana610@gmail.com','96e79218965eb72c92a549dd5a330112','fana610@gmail.com',NULL,'fana610@gmail.com',NULL,NULL,NULL,'',NULL,NULL,'User',NULL,NULL,'',0,'2016-11-18 16:59:08','','','2016-07-29 07:51:58','2',NULL,NULL,1,'en'),(26,'ekinsas@yahoo.com','827ccb0eea8a706c4c34a16891f84e7b','ekinsas@yahoo.com',NULL,'ekinsas@yahoo.com',NULL,NULL,NULL,'0164407096',NULL,NULL,'User',NULL,NULL,'',0,'2016-11-18 16:59:10','436','192.168.1.136','2016-08-10 09:47:39','2',NULL,NULL,0,'en'),(27,'ali@abu.com','827ccb0eea8a706c4c34a16891f84e7b','ali@abu.com',NULL,'ali@abu.com',NULL,NULL,NULL,'0164407096',NULL,NULL,'User',NULL,NULL,'',0,'2016-11-18 16:59:15','5666','192.168.1.254','2016-08-10 09:48:46','2',NULL,NULL,0,'en'),(28,'hijrahrahmat@gmail.com','827ccb0eea8a706c4c34a16891f84e7b','hijrahrahmat@gmail.com',NULL,'hijrahrahmat@gmail.com',NULL,NULL,NULL,'123456',NULL,NULL,'User',NULL,NULL,'',0,'2016-12-09 09:39:06','6421','192.168.1.192','2016-08-11 02:42:08','2',NULL,NULL,0,'en'),(29,'fad@gmail.com','bebdef0ad75d6e9bc87af1ed1e313a96','fad@gmail.com',NULL,'fad@gmail.com',NULL,NULL,NULL,'012345',NULL,NULL,'User',NULL,NULL,'',0,'2016-11-18 16:59:20','7972','192.168.1.198','2016-08-11 03:13:28','2',NULL,NULL,1,'en'),(31,'superabu92@gmail.com','827ccb0eea8a706c4c34a16891f84e7b','superabu92@gmail.com',NULL,'superabu92@gmail.com',NULL,NULL,NULL,'0132897186','0','0','User',NULL,NULL,'31-1471512489-abuyo.JPG',0,'2016-11-18 16:59:30','6930','192.168.1.204','2016-08-16 03:20:25','2','2016-08-18','0',0,'en'),(32,'farouqtakwan@gmail.com','827ccb0eea8a706c4c34a16891f84e7b','farouq zakwan',NULL,'farouq zakwan',NULL,NULL,NULL,'','0','0','User',NULL,NULL,'32-1471512496-Turban.jpg',0,'2016-11-18 16:59:32','8693','192.168.1.220','2016-08-16 03:21:14','2','2016-08-23','0',0,'en'),(33,'has@gmail.com','827ccb0eea8a706c4c34a16891f84e7b','has@gmail.com',NULL,'has@gmail.com',NULL,NULL,NULL,'',NULL,NULL,'User',NULL,NULL,'',0,'2016-11-18 16:59:35','1321','192.168.1.198','2016-08-19 09:03:44','2',NULL,NULL,0,'en'),(34,'hihi@yahoo.com','827ccb0eea8a706c4c34a16891f84e7b','hihi@yahoo.com',NULL,'hihi@yahoo.com',NULL,NULL,NULL,'123',NULL,NULL,'User',NULL,NULL,'',0,'2016-11-18 16:59:37','','','2016-09-05 02:15:15','2',NULL,NULL,1,'en'),(37,'fadhirulhilmi@gmail.com','827ccb0eea8a706c4c34a16891f84e7b','fadhirulhilmi@gmail.com',NULL,'fadhirulhilmi@gmail.com',NULL,NULL,NULL,'123',NULL,NULL,'User',NULL,NULL,'',0,'2016-11-18 16:59:39','','','2016-10-06 06:14:41','2',NULL,NULL,0,'en'),(42,'garfield@gmail.com','827ccb0eea8a706c4c34a16891f84e7b','garfield@gmail.com',NULL,'garfield@gmail.com',NULL,NULL,NULL,'123',NULL,NULL,NULL,NULL,NULL,'',0,'2016-11-18 16:59:41','','','2016-10-10 07:23:01',NULL,NULL,NULL,0,'en'),(71,'eminem@gmail.com','827ccb0eea8a706c4c34a16891f84e7b','eminem@gmail.com',NULL,'eminem@gmail.com',NULL,NULL,NULL,'123',NULL,NULL,NULL,NULL,NULL,'',0,'2016-12-07 09:41:06','4364','192.168.1.198','2016-10-18 00:55:38',NULL,NULL,NULL,0,'en');
/*!40000 ALTER TABLE `tbl_usermaster` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `user`
--

DROP TABLE IF EXISTS `user`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `groupID` int(11) NOT NULL,
  `email` varchar(128) NOT NULL,
  `password` varchar(32) NOT NULL,
  `create_dt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `is_delete` smallint(6) NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `user`
--

LOCK TABLES `user` WRITE;
/*!40000 ALTER TABLE `user` DISABLE KEYS */;
INSERT INTO `user` VALUES (1,1,'phoe_nix29@yahoo.com','827ccb0eea8a706c4c34a16891f84e7b','2016-05-16 07:16:59',0),(2,2,'puterakatak29@gmail.com','827ccb0eea8a706c4c34a16891f84e7b','2016-05-17 06:41:13',0),(3,2,'akmal@salihin.com.my','827ccb0eea8a706c4c34a16891f84e7b','2016-05-19 03:00:51',0),(4,1,'farhana@salihin.com.my','827ccb0eea8a706c4c34a16891f84e7b','2016-05-26 04:30:59',1),(5,2,'farhana@salihin.com.my','4297f44b13955235245b2497399d7a93','2016-05-26 04:31:16',1),(6,1,'firdaus@salihin.com.my','827ccb0eea8a706c4c34a16891f84e7b','2016-05-26 07:00:21',0),(8,1,'fanatesting@gmail.com','4297f44b13955235245b2497399d7a93','2016-06-30 02:58:20',0),(10,1,'superadmin@gmail.com','d0970714757783e6cf17b26fb8e2298f','2016-07-20 03:32:23',0),(11,1,'fana610@gmail.com','827ccb0eea8a706c4c34a16891f84e7b','2016-08-05 13:09:48',0);
/*!40000 ALTER TABLE `user` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `user_group`
--

DROP TABLE IF EXISTS `user_group`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user_group` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `groupName` varchar(128) NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `user_group`
--

LOCK TABLES `user_group` WRITE;
/*!40000 ALTER TABLE `user_group` DISABLE KEYS */;
INSERT INTO `user_group` VALUES (1,'Tekun'),(2,'Salihin');
/*!40000 ALTER TABLE `user_group` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `user_module_access`
--

DROP TABLE IF EXISTS `user_module_access`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user_module_access` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `companyID` int(11) DEFAULT NULL,
  `userID` int(11) NOT NULL,
  `moduleID` int(11) NOT NULL,
  `transaction` smallint(2) NOT NULL DEFAULT '0',
  `reports` smallint(2) NOT NULL DEFAULT '0',
  `setup` smallint(2) NOT NULL DEFAULT '0',
  `accessRight` int(11) NOT NULL,
  `createdBy` int(11) NOT NULL,
  `createdTS` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updatedBy` int(11) NOT NULL,
  `updatedTS` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=64 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `user_module_access`
--

LOCK TABLES `user_module_access` WRITE;
/*!40000 ALTER TABLE `user_module_access` DISABLE KEYS */;
INSERT INTO `user_module_access` VALUES (1,1,1,0,0,0,0,0,2,'2016-05-31 09:08:21',0,'2016-06-13 09:36:29'),(2,2,2,0,0,0,0,0,2,'2016-05-31 09:09:55',0,'2016-07-14 04:17:19'),(6,3,12,0,0,0,0,0,2,'2016-06-09 06:36:27',0,'2016-08-10 08:51:13'),(7,12,11,0,0,0,0,0,2,'2016-06-09 07:59:15',0,'2016-08-10 08:51:21'),(8,13,10,0,0,0,0,0,2,'2016-06-10 01:26:46',0,'2016-08-10 08:51:28'),(9,14,13,0,0,0,0,0,2,'2016-06-10 01:28:57',0,'2016-08-10 08:51:34'),(11,15,15,0,0,0,0,0,2,'2016-06-10 05:04:07',0,'2016-08-10 08:51:39'),(12,16,16,0,0,0,0,0,2,'2016-06-27 03:37:40',0,'2016-08-10 08:51:45'),(13,17,17,0,0,0,0,0,2,'2016-06-28 06:50:33',0,'2016-08-10 08:51:51'),(14,20,18,0,0,0,0,0,2,'2016-06-30 02:34:46',0,'2016-08-24 08:30:27'),(15,19,19,0,0,0,0,0,2,'2016-07-14 04:34:02',0,'2016-08-10 08:52:01'),(16,20,20,0,0,0,0,0,2,'2016-07-29 07:51:22',0,'2016-08-10 08:52:05'),(17,21,21,0,0,0,0,0,2,'2016-07-29 07:51:58',0,'2016-08-10 08:52:09'),(22,1,26,0,0,0,0,0,2,'2016-08-10 09:47:39',0,'2016-08-10 09:47:39'),(23,1,27,0,0,0,0,0,2,'2016-08-10 09:48:46',0,'2016-08-10 09:48:46'),(24,40,28,0,0,0,0,0,2,'2016-08-11 02:42:08',0,'2016-09-28 07:36:15'),(25,22,29,0,0,0,0,0,2,'2016-08-11 03:13:28',0,'2016-08-11 03:13:28'),(26,22,30,0,0,0,0,0,2,'2016-08-11 04:43:41',0,'2016-08-11 04:43:41'),(27,24,31,0,0,0,0,0,2,'2016-08-16 03:20:25',0,'2016-08-16 03:20:25'),(28,25,32,0,0,0,0,0,2,'2016-08-16 03:21:15',0,'2016-08-16 03:21:15'),(29,26,33,0,0,0,0,0,2,'2016-08-19 09:03:45',0,'2016-08-19 09:03:45'),(30,27,34,0,0,0,0,0,2,'2016-09-05 02:15:15',0,'2016-09-05 02:15:15'),(63,73,71,0,0,0,0,0,0,'2016-10-18 00:55:38',0,'2016-10-18 00:55:38');
/*!40000 ALTER TABLE `user_module_access` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Temporary table structure for view `view_companystatus`
--

DROP TABLE IF EXISTS `view_companystatus`;
/*!50001 DROP VIEW IF EXISTS `view_companystatus`*/;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE TABLE `view_companystatus` (
  `companyid` tinyint NOT NULL,
  `companyname` tinyint NOT NULL,
  `companyno` tinyint NOT NULL,
  `companystateid` tinyint NOT NULL,
  `parlimenid` tinyint NOT NULL,
  `username` tinyint NOT NULL,
  `lastpayment` tinyint NOT NULL,
  `expirydate` tinyint NOT NULL,
  `last_seen` tinyint NOT NULL,
  `status` tinyint NOT NULL
) ENGINE=MyISAM */;
SET character_set_client = @saved_cs_client;

--
-- Temporary table structure for view `view_expences_monthly`
--

DROP TABLE IF EXISTS `view_expences_monthly`;
/*!50001 DROP VIEW IF EXISTS `view_expences_monthly`*/;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE TABLE `view_expences_monthly` (
  `yymm` tinyint NOT NULL,
  `formno` tinyint NOT NULL,
  `yy` tinyint NOT NULL,
  `mm` tinyint NOT NULL,
  `amountPaid` tinyint NOT NULL
) ENGINE=MyISAM */;
SET character_set_client = @saved_cs_client;

--
-- Temporary table structure for view `view_next_server_allocation`
--

DROP TABLE IF EXISTS `view_next_server_allocation`;
/*!50001 DROP VIEW IF EXISTS `view_next_server_allocation`*/;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE TABLE `view_next_server_allocation` (
  `server` tinyint NOT NULL,
  `database` tinyint NOT NULL,
  `no_of_user` tinyint NOT NULL
) ENGINE=MyISAM */;
SET character_set_client = @saved_cs_client;

--
-- Temporary table structure for view `view_sales_by_state`
--

DROP TABLE IF EXISTS `view_sales_by_state`;
/*!50001 DROP VIEW IF EXISTS `view_sales_by_state`*/;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE TABLE `view_sales_by_state` (
  `countryID` tinyint NOT NULL,
  `fldcountry` tinyint NOT NULL,
  `StateID` tinyint NOT NULL,
  `fldname` tinyint NOT NULL,
  `Year` tinyint NOT NULL,
  `January` tinyint NOT NULL,
  `February` tinyint NOT NULL,
  `March` tinyint NOT NULL,
  `April` tinyint NOT NULL,
  `May` tinyint NOT NULL,
  `June` tinyint NOT NULL,
  `July` tinyint NOT NULL,
  `August` tinyint NOT NULL,
  `September` tinyint NOT NULL,
  `October` tinyint NOT NULL,
  `November` tinyint NOT NULL,
  `December` tinyint NOT NULL,
  `Amount` tinyint NOT NULL,
  `Average` tinyint NOT NULL,
  `Total` tinyint NOT NULL
) ENGINE=MyISAM */;
SET character_set_client = @saved_cs_client;

--
-- Temporary table structure for view `view_sales_monthly`
--

DROP TABLE IF EXISTS `view_sales_monthly`;
/*!50001 DROP VIEW IF EXISTS `view_sales_monthly`*/;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE TABLE `view_sales_monthly` (
  `yymm` tinyint NOT NULL,
  `yy` tinyint NOT NULL,
  `mm` tinyint NOT NULL,
  `totalreceived` tinyint NOT NULL
) ENGINE=MyISAM */;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `web`
--

DROP TABLE IF EXISTS `web`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `web` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `companyID` int(11) NOT NULL,
  `webPageName` varchar(64) NOT NULL,
  `namaSyarikat` varchar(32) NOT NULL,
  `mukaDepan` longtext,
  `menu1` varchar(32) NOT NULL,
  `menu2` varchar(32) NOT NULL,
  `menu3` varchar(32) NOT NULL,
  `menu4` varchar(32) NOT NULL,
  `menu5` varchar(32) NOT NULL,
  `menu1Link` varchar(64) NOT NULL,
  `menu2Link` varchar(64) NOT NULL,
  `menu3Link` varchar(64) NOT NULL,
  `menu4Link` varchar(64) NOT NULL,
  `menu5Link` varchar(64) NOT NULL,
  `selamatDatang` varchar(32) NOT NULL,
  `moto` varchar(128) NOT NULL,
  `linkLabel` varchar(32) NOT NULL,
  `link` varchar(64) NOT NULL,
  `createdBy` int(11) NOT NULL,
  `updatedBy` int(11) NOT NULL,
  `updatedTS` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `mengapaTajuk` varchar(32) NOT NULL,
  `mengapaKeterangan` text NOT NULL,
  `mengapa1` varchar(32) NOT NULL,
  `mengapa12` text NOT NULL,
  `mengapa2` varchar(32) NOT NULL,
  `mengapa22` text NOT NULL,
  `mengapa3` varchar(32) NOT NULL,
  `mengapa32` text NOT NULL,
  `mengapa4` varchar(32) NOT NULL,
  `mengapa42` text NOT NULL,
  `mengapa5` varchar(32) NOT NULL,
  `mengapa52` text NOT NULL,
  `mengapa6` varchar(32) NOT NULL,
  `mengapa62` text NOT NULL,
  `portfolio` varchar(32) NOT NULL,
  `portfolioSub` varchar(128) NOT NULL,
  `portfolio1` varchar(32) NOT NULL,
  `portfolioSub1` varchar(128) NOT NULL,
  `portfolio2` varchar(32) NOT NULL,
  `portfolioSub2` varchar(128) NOT NULL,
  `portfolio3` varchar(32) NOT NULL,
  `portfolioSub3` varchar(128) NOT NULL,
  `portfolio4` varchar(32) NOT NULL,
  `portfolioSub4` varchar(128) NOT NULL,
  `portfolio5` varchar(32) NOT NULL,
  `portfolioSub5` varchar(128) NOT NULL,
  `portfolio6` varchar(32) NOT NULL,
  `portfolioSub6` varchar(128) NOT NULL,
  `portfolioImage1` longtext,
  `portfolioImage2` longtext,
  `portfolioImage3` longtext,
  `portfolioImage4` longtext,
  `portfolioImage5` longtext,
  `portfolioImage6` longtext,
  `portfolioText1` text NOT NULL,
  `portfolioText2` text NOT NULL,
  `portfolioText3` text NOT NULL,
  `portfolioText4` text NOT NULL,
  `portfolioText5` text NOT NULL,
  `portfolioText6` text NOT NULL,
  `about` varchar(32) NOT NULL,
  `aboutSub` varchar(128) NOT NULL,
  `aboutText` text NOT NULL,
  `about1` varchar(32) NOT NULL,
  `aboutSub1` varchar(128) NOT NULL,
  `aboutText1` text NOT NULL,
  `about2` varchar(32) NOT NULL,
  `aboutSub2` varchar(128) NOT NULL,
  `aboutText2` text NOT NULL,
  `about3` varchar(32) NOT NULL,
  `aboutSub3` varchar(128) NOT NULL,
  `aboutText3` text NOT NULL,
  `about4` varchar(32) NOT NULL,
  `aboutSub4` varchar(128) NOT NULL,
  `aboutText4` text NOT NULL,
  `aboutImage1` longtext,
  `aboutImage2` longtext,
  `aboutImage3` longtext,
  `aboutImage4` longtext,
  `aboutBulat` varchar(32) NOT NULL,
  `team` varchar(32) NOT NULL,
  `teamSub` varchar(128) NOT NULL,
  `teamFb` varchar(64) NOT NULL,
  `team1` varchar(32) NOT NULL,
  `teamSub1` varchar(128) NOT NULL,
  `teamFb1` varchar(64) NOT NULL,
  `team2` varchar(32) NOT NULL,
  `teamSub2` varchar(128) NOT NULL,
  `teamFb2` varchar(64) NOT NULL,
  `team3` varchar(32) NOT NULL,
  `teamSub3` varchar(128) NOT NULL,
  `teamFb3` varchar(64) NOT NULL,
  `teamTw1` varchar(64) NOT NULL,
  `teamTw2` varchar(64) NOT NULL,
  `teamTw3` varchar(64) NOT NULL,
  `teamLn1` varchar(64) NOT NULL,
  `teamLn2` varchar(64) NOT NULL,
  `teamLn3` varchar(64) NOT NULL,
  `teamImage1` longtext,
  `teamImage2` longtext,
  `teamImage3` longtext,
  `teamBawah` varchar(128) NOT NULL,
  `clientImage1` longtext,
  `clientImage2` longtext,
  `clientImage3` longtext,
  `clientImage4` longtext,
  `clientLink1` varchar(128) NOT NULL,
  `clientLink2` varchar(128) NOT NULL,
  `clientLink3` varchar(128) NOT NULL,
  `clientLink4` varchar(128) NOT NULL,
  `hubungiKami` text NOT NULL,
  PRIMARY KEY (`ID`),
  KEY `companyid` (`companyID`)
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `web`
--

LOCK TABLES `web` WRITE;
/*!40000 ALTER TABLE `web` DISABLE KEYS */;
INSERT INTO `web` VALUES (1,0,'1','','','Mengapa SPS Lite ?','Ciri-ciri','Testimoni','Langgan SPS Lite','Hubungi Kami','#services','#portfolio','#about-section','#team-section','#contact','Selamat Datang ke SPS Lite','Memudahkan Perniagaan Anda','Free Trial / Login','http://demo.spslite.my/login',0,0,'2016-07-20 03:36:48','Mengapa SPS Lite?','Mengapa SPS Lite','Responsif','Responsive dengan semua device termasuk tablet dan smartphone','Dwibahasa','Dalam Bahasa Malaysia dan Inggeris','Mesra Pengguna','','Untung dan Rugi','Laporan Untung dan Rugi semudah ABC','Kewangan','Laporan Kewangan semudah ABC','Pengkomputeran Awam','Membawa anda ke era Digital','Perkhidmatan Kami','Contoh-contoh Skrin dan Laporan','Jualan','Rekod Jualan','Perbelanjaan','Rekod Perbelanjaan','Umum','Ketetapan Umum','Laporan','Contoh-contoh laporan','Tetapan','Ketetapan setup Pentadbir','Pautan','Pautan Tambahan','','','','','','','','','','','','','testimoni','','','','','','','','','','','','','','','','','','','','Team Kami','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','Untuk melanggan SPS Lite, hubungi kami di talian +03-6185 9970 atau emel ke info@salihinpremier.com.'),(2,0,'11','kedai-e','','Mengapa SPS Lite ?','Ciri-ciri','Testimoni','Langgan SPS Lite','Hubungi Kami','#services','#portfolio','#about-section','#team-section','#contact','Selamat Datang ke SPS Lite','Memudahkan Perniagaan Anda','Free Trial / Login','http://demo.spslite.my/login',0,0,'2016-07-20 03:36:48','Mengapa SPS Lite?','Mengapa SPS Lite','Responsif','Responsive dengan semua device termasuk tablet dan smartphone','Dwibahasa','Dalam Bahasa Malaysia dan Inggeris','Mesra Pengguna','','Untung dan Rugi','Laporan Untung dan Rugi semudah ABC','Kewangan','Laporan Kewangan semudah ABC','Pengkomputeran Awam','Membawa anda ke era Digital','Perkhidmatan Kami','Contoh-contoh Skrin dan Laporan','Jualan','Rekod Jualan','Perbelanjaan','Rekod Perbelanjaan','Umum','Ketetapan Umum','Laporan','Contoh-contoh laporan','Tetapan','Ketetapan setup Pentadbir','Pautan','Pautan Tambahan','','','','','','','','','','','','','testimoni','','','','','','','','','','','','','','','','','','','','Team Kami','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','Untuk melanggan SPS Lite, hubungi kami di talian +03-6185 9970 atau emel ke info@salihinpremier.com.'),(3,0,'salikeen@salihin.com.my','SPS Lite','','Mengapa SPS Lite ?','Ciri-ciri','Testimoni','Langgan SPS Lite','Hubungi Kami','#services','#portfolio','#about-section','#team-section','#contact','Selamat Datang ke SPS Lite','Memudahkan Perniagaan Anda','Free Trial / Login','http://demo.spslite.my/login',0,0,'2016-07-20 03:36:48','Mengapa SPS Lite?','Mengapa SPS Lite','Responsif','Responsive dengan semua device termasuk tablet dan smartphone','Dwibahasa','Dalam Bahasa Malaysia dan Inggeris','Mesra Pengguna','','Untung dan Rugi','Laporan Untung dan Rugi semudah ABC','Kewangan','Laporan Kewangan semudah ABC','Pengkomputeran Awam','Membawa anda ke era Digital','Perkhidmatan Kami','Contoh-contoh Skrin dan Laporan','Jualan','Rekod Jualan','Perbelanjaan','Rekod Perbelanjaan','Umum','Ketetapan Umum','Laporan','Contoh-contoh laporan','Tetapan','Ketetapan setup Pentadbir','Pautan','Pautan Tambahan','','','','','','','','','','','','','testimoni','','','','','','','','','','','','','','','','','','','','Team Kami','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','Untuk melanggan SPS Lite, hubungi kami di talian +03-6185 9970 atau emel ke info@salihinpremier.com.'),(4,0,'32','kedai cermin mata','','Servis kami','Ciri-ciri','Testimoni','Langgan SPS Lite','Hubungi Kami','#services','#portfolio','#about-section','#team-section','#contact','Selamat Datang ke SPS Lite','Memudahkan Perniagaan Anda','Free Trial / Login','http://demo.spslite.my/login',0,0,'2016-07-20 03:36:48','Perkhidmatan Servis Kedai Cermin','Apa yang kami buat','Tukar Cermin','Tukar cermin kurang dari 5 minit.fuhh cepat','Tukar Bingkai','Bingkai kami paling lawa di Malaysia','Cepat','kami buat kerja cepat bro','Untung tak Rugi','tak rugi beli dengan kami','Mahal','Memang cermin kami mahal.','Mereka bentuk bingkai','Kami reka bentuk bingakai kami sendiri','Perkhidmatan Kami','Contoh-contoh Skrin dan Laporan','Jualan','Rekod Jualan','design kami','design kami lawa','Umum','Ketetapan Umum','Laporan','Contoh-contoh laporan','Tetapan','Ketetapan setup Pentadbir','Pautan','Pautan Tambahan','','','','','','','','jom tengok design kami yang awesome','','','','','testimoni','','','','','','','','','','','','','','','','','','','','Team Kami','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','Untuk melanggan SPS Lite, hubungi kami di talian +03-6185 9970 atau emel ke info@salihinpremier.com.'),(5,0,'31','SPS Lite','','Mengapa SPS Lite ?','Ciri-ciri','Testimoni','Langgan SPS Lite','Hubungi Kami','#services','#portfolio','#about-section','#team-section','#contact','Selamat Datang ke SPS Lite 2 abu','Memudahkan Perniagaan Anda','Free Trial / Login','http://demo.spslite.my/login',0,0,'2016-07-20 03:36:48','Mengapa SPS Lite?','Mengapa SPS Lite','Responsif','Responsive dengan semua device termasuk tablet dan smartphone','Dwibahasa','Dalam Bahasa Malaysia dan Inggeris','Mesra Pengguna','','Untung dan Rugi','Laporan Untung dan Rugi semudah ABC','Kewangan','Laporan Kewangan semudah ABC','Pengkomputeran Awam','Membawa anda ke era Digital','Perkhidmatan Kami','Contoh-contoh Skrin dan Laporan','Jualan','Rekod Jualan','Perbelanjaan','Rekod Perbelanjaan','Umum','Ketetapan Umum','Laporan','Contoh-contoh laporan','Tetapan','Ketetapan setup Pentadbir','Pautan','Pautan Tambahan','','','','','','','','','','','','','testimoni','','','','','','','','','','','','','','','','','','','','Team Kami','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','Untuk melanggan SPS Lite, hubungi kami di talian +03-6185 9970 atau emel ke info@salihinpremier.com.'),(6,0,'','SPS Lite','','Mengapa SPS Lite ?','Ciri-ciri','Testimoni','Langgan SPS Lite','Hubungi Kami','#services','#portfolio','#about-section','#team-section','#contact','Selamat Datang ke SPS Lite','Memudahkan Perniagaan Anda','Free Trial / Login','http://demo.spslite.my/login',0,0,'2016-07-20 03:36:48','Mengapa SPS Lite?','Mengapa SPS Lite','Responsif','Responsive dengan semua device termasuk tablet dan smartphone','Dwibahasa','Dalam Bahasa Malaysia dan Inggeris','Mesra Pengguna','','Untung dan Rugi','Laporan Untung dan Rugi semudah ABC','Kewangan','Laporan Kewangan semudah ABC','Pengkomputeran Awam','Membawa anda ke era Digital','Perkhidmatan Kami','Contoh-contoh Skrin dan Laporan','Jualan','Rekod Jualan','Perbelanjaan','Rekod Perbelanjaan','Umum','Ketetapan Umum','Laporan','Contoh-contoh laporan','Tetapan','Ketetapan setup Pentadbir','Pautan','Pautan Tambahan','','','','','','','','','','','','','testimoni','','','','','','','','','','','','','','','','','','','','Team Kami','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','Untuk melanggan SPS Lite, hubungi kami di talian +03-6185 9970 atau emel ke info@salihinpremier.com.'),(7,0,'13','SPS Lite',NULL,'Mengapa SPS Lite ?','Ciri-ciri','Testimoni','Langgan SPS Lite','Hubungi Kami','#services','#portfolio','#about-section','#team-section','#contact','Selamat Datang ke SPS Lite','Memudahkan Perniagaan Anda','fb','http://www.salihin.com.my',0,0,'2016-07-20 03:36:48','Mengapa SPS Lite?','Mengapa SPS Lite','Responsif','Responsive dengan semua device termasuk tablet dan smartphone','Dwibahasa','Dalam Bahasa Malaysia dan Inggeris','Mesra Pengguna','','Untung dan Rugi','Laporan Untung dan Rugi semudah ABC','Kewangan','Laporan Kewangan semudah ABC','Pengkomputeran Awam','Membawa anda ke era Digital','Perkhidmatan Kami','Contoh-contoh Skrin dan Laporan','Jualan','Rekod Jualan','Perbelanjaan','Rekod Perbelanjaan','Umum','Ketetapan Umum','Laporan','Contoh-contoh laporan','Tetapan','Ketetapan setup Pentadbir','Pautan','Pautan Tambahan','','','','','','','','','','','','','testimoni','','','','','','','','','','','','','','',' ','','','','','Team Kami','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','Untuk melanggan SPS Lite, hubungi kami di talian +03-6185 9970 atau emel ke info@salihinpremier.com.'),(8,0,'18','SPSLite','','Mengapa SPS Lite ?','Ciri-ciri','Testimoni','Langgan SPS Lite','Hubungi Kami','#services','#portfolio','#about-section','#team-section','#contact','Selamat Datang ke SPS Lite','Memudahkan Perniagaan Anda','Free Trial / Login','http://demo.spslite.my/login',0,0,'2016-07-20 03:36:48','Mengapa SPS Lite?','Mengapa SPS Lite','Responsif','Responsive dengan semua device termasuk tablet dan smartphone','Dwibahasa','Dalam Bahasa Malaysia dan Inggeris','Mesra Pengguna','','Untung dan Rugi','Laporan Untung dan Rugi semudah ABC','Kewangan','Laporan Kewangan semudah ABC','Pengkomputeran Awam','Membawa anda ke era Digital','Perkhidmatan Kami','Contoh-contoh Skrin dan Laporan','Jualan','Rekod Jualan','Perbelanjaan','Rekod Perbelanjaan','Umum','Ketetapan Umum','Laporan','Contoh-contoh laporan','Tetapan','Ketetapan setup Pentadbir','Pautan','Pautan Tambahan','','','','','','','','','','','','','testimoni','','','','','','','','','','','','','','','','','','','','Team Kami','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','Untuk melanggan SPS Lite, hubungi kami di talian +03-6185 9970 atau emel ke info@salihinpremier.com.'),(9,0,'10','SPS Lite','','Mengapa SPS Lite ?','Ciri-ciri','Testimoni','Langgan SPS Lite','Hubungi Kami','#services','#portfolio','#about-section','#team-section','#contact','Selamat Datang ke SPS Lite','Memudahkan Perniagaan Anda','Free Trial / Login','http://demo.spslite.my/login',0,0,'2016-07-20 03:36:48','Mengapa SPS Lite?','Mengapa SPS Lite','Responsif','Responsive dengan semua device termasuk tablet dan smartphone','Dwibahasa','Dalam Bahasa Malaysia dan Inggeris','Mesra Pengguna','','Untung dan Rugi','Laporan Untung dan Rugi semudah ABC','Kewangan','Laporan Kewangan semudah ABC','Pengkomputeran Awam','Membawa anda ke era Digital','Perkhidmatan Kami','Contoh-contoh Skrin dan Laporan','Jualan','Rekod Jualan','Perbelanjaan','Rekod Perbelanjaan','Umum','Ketetapan Umum','Laporan','Contoh-contoh laporan','Tetapan','Ketetapan setup Pentadbir','Pautan','Pautan Tambahan','','','','','','','','','','','','','testimoni','','','','','','','','','','','','','','','','','','','','Team Kami','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','Untuk melanggan SPS Lite, hubungi kami di talian +03-6185 9970 atau emel ke info@salihinpremier.com.'),(10,0,'28','SPS Lite','','Mengapa SPS Lite ?','Ciri-ciri','Testimoni','Langgan SPS Lite','Hubungi Kami','#services','#portfolio','#about-section','#team-section','#contact','Selamat Datang ke SPS Lite','Memudahkan Perniagaan Anda','Free Trial / Login','http://demo.spslite.my/login',0,0,'2016-07-20 03:36:48','Mengapa SPS Lite?','Mengapa SPS Lite','Responsif','Responsive dengan semua device termasuk tablet dan smartphone','Dwibahasa','Dalam Bahasa Malaysia dan Inggeris','Mesra Pengguna','','Untung dan Rugi','Laporan Untung dan Rugi semudah ABC','Kewangan','Laporan Kewangan semudah ABC','Pengkomputeran Awam','Membawa anda ke era Digital','Perkhidmatan Kami','Contoh-contoh Skrin dan Laporan','Jualan','Rekod Jualan','Perbelanjaan','Rekod Perbelanjaan','Umum','Ketetapan Umum','Laporan','Contoh-contoh laporan','Tetapan','Ketetapan setup Pentadbir','Pautan','Pautan Tambahan','','','','','','','','','','','','','testimoni','','','','','','','','','','','','','','','','','','','','Team Kami','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','Untuk melanggan SPS Lite, hubungi kami di talian +03-6185 9970 atau emel ke info@salihinpremier.com.'),(11,0,'','SPS Lite','','Mengapa SPS Lite ?','Ciri-ciri','Testimoni','Langgan SPS Lite','Hubungi Kami','#services','#portfolio','#about-section','#team-section','#contact','Selamat Datang ke SPS Lite','Memudahkan Perniagaan Anda','Free Trial / Login','http://demo.spslite.my/login',0,0,'2016-07-20 03:36:48','Mengapa SPS Lite?','Mengapa SPS Lite','Responsif','Responsive dengan semua device termasuk tablet dan smartphone','Dwibahasa','Dalam Bahasa Malaysia dan Inggeris','Mesra Pengguna','','Untung dan Rugi','Laporan Untung dan Rugi semudah ABC','Kewangan','Laporan Kewangan semudah ABC','Pengkomputeran Awam','Membawa anda ke era Digital','Perkhidmatan Kami','Contoh-contoh Skrin dan Laporan','Jualan','Rekod Jualan','Perbelanjaan','Rekod Perbelanjaan','Umum','Ketetapan Umum','Laporan','Contoh-contoh laporan','Tetapan','Ketetapan setup Pentadbir','Pautan','Pautan Tambahan','','','','','','','','','','','','','testimoni','','','','','','','','','','','','','','','','','','','','Team Kami','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','Untuk melanggan SPS Lite, hubungi kami di talian +03-6185 9970 atau emel ke info@salihinpremier.com.'),(12,0,'','SPS Lite','','Mengapa SPS Lite ?','Ciri-ciri','Testimoni','Langgan SPS Lite','Hubungi Kami','#services','#portfolio','#about-section','#team-section','#contact','Selamat Datang ke SPS Lite','Memudahkan Perniagaan Anda','Free Trial / Login','http://demo.spslite.my/login',0,0,'2016-07-20 03:36:48','Mengapa SPS Lite?','Mengapa SPS Lite','Responsif','Responsive dengan semua device termasuk tablet dan smartphone','Dwibahasa','Dalam Bahasa Malaysia dan Inggeris','Mesra Pengguna','','Untung dan Rugi','Laporan Untung dan Rugi semudah ABC','Kewangan','Laporan Kewangan semudah ABC','Pengkomputeran Awam','Membawa anda ke era Digital','Perkhidmatan Kami','Contoh-contoh Skrin dan Laporan','Jualan','Rekod Jualan','Perbelanjaan','Rekod Perbelanjaan','Umum','Ketetapan Umum','Laporan','Contoh-contoh laporan','Tetapan','Ketetapan setup Pentadbir','Pautan','Pautan Tambahan','','','','','','','','','','','','','testimoni','','','','','','','','','','','','','','','','','','','','Team Kami','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','Untuk melanggan SPS Lite, hubungi kami di talian +03-6185 9970 atau emel ke info@salihinpremier.com.'),(13,0,'','SPS Lite','','Mengapa SPS Lite ?','Ciri-ciri','Testimoni','Langgan SPS Lite','Hubungi Kami','#services','#portfolio','#about-section','#team-section','#contact','Selamat Datang ke SPS Lite','Memudahkan Perniagaan Anda','Free Trial / Login','http://demo.spslite.my/login',0,0,'2016-07-20 03:36:48','Mengapa SPS Lite?','Mengapa SPS Lite','Responsif','Responsive dengan semua device termasuk tablet dan smartphone','Dwibahasa','Dalam Bahasa Malaysia dan Inggeris','Mesra Pengguna','','Untung dan Rugi','Laporan Untung dan Rugi semudah ABC','Kewangan','Laporan Kewangan semudah ABC','Pengkomputeran Awam','Membawa anda ke era Digital','Perkhidmatan Kami','Contoh-contoh Skrin dan Laporan','Jualan','Rekod Jualan','Perbelanjaan','Rekod Perbelanjaan','Umum','Ketetapan Umum','Laporan','Contoh-contoh laporan','Tetapan','Ketetapan setup Pentadbir','Pautan','Pautan Tambahan','','','','','','','','','','','','','testimoni','','','','','','','','','','','','','','','','','','','','Team Kami','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','Untuk melanggan SPS Lite, hubungi kami di talian +03-6185 9970 atau emel ke info@salihinpremier.com.'),(14,0,'','SPS Lite','','Mengapa SPS Lite ?','Ciri-ciri','Testimoni','Langgan SPS Lite','Hubungi Kami','#services','#portfolio','#about-section','#team-section','#contact','Selamat Datang ke SPS Lite','Memudahkan Perniagaan Anda','Free Trial / Login','http://demo.spslite.my/login',0,0,'2016-07-20 03:36:48','Mengapa SPS Lite?','Mengapa SPS Lite','Responsif','Responsive dengan semua device termasuk tablet dan smartphone','Dwibahasa','Dalam Bahasa Malaysia dan Inggeris','Mesra Pengguna','','Untung dan Rugi','Laporan Untung dan Rugi semudah ABC','Kewangan','Laporan Kewangan semudah ABC','Pengkomputeran Awam','Membawa anda ke era Digital','Perkhidmatan Kami','Contoh-contoh Skrin dan Laporan','Jualan','Rekod Jualan','Perbelanjaan','Rekod Perbelanjaan','Umum','Ketetapan Umum','Laporan','Contoh-contoh laporan','Tetapan','Ketetapan setup Pentadbir','Pautan','Pautan Tambahan','','','','','','','','','','','','','testimoni','','','','','','','','','','','','','','','','','','','','Team Kami','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','Untuk melanggan SPS Lite, hubungi kami di talian +03-6185 9970 atau emel ke info@salihinpremier.com.'),(15,0,'','SPS Lite','','Mengapa SPS Lite ?','Ciri-ciri','Testimoni','Langgan SPS Lite','Hubungi Kami','#services','#portfolio','#about-section','#team-section','#contact','Selamat Datang ke SPS Lite','Memudahkan Perniagaan Anda','Free Trial / Login','http://demo.spslite.my/login',0,0,'2016-07-20 03:36:48','Mengapa SPS Lite?','Mengapa SPS Lite','Responsif','Responsive dengan semua device termasuk tablet dan smartphone','Dwibahasa','Dalam Bahasa Malaysia dan Inggeris','Mesra Pengguna','','Untung dan Rugi','Laporan Untung dan Rugi semudah ABC','Kewangan','Laporan Kewangan semudah ABC','Pengkomputeran Awam','Membawa anda ke era Digital','Perkhidmatan Kami','Contoh-contoh Skrin dan Laporan','Jualan','Rekod Jualan','Perbelanjaan','Rekod Perbelanjaan','Umum','Ketetapan Umum','Laporan','Contoh-contoh laporan','Tetapan','Ketetapan setup Pentadbir','Pautan','Pautan Tambahan','','','','','','','','','','','','','testimoni','','','','','','','','','','','','','','','','','','','','Team Kami','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','Untuk melanggan SPS Lite, hubungi kami di talian +03-6185 9970 atau emel ke info@salihinpremier.com.'),(16,0,'12','SPS Lite','','Mengapa SPS Lite ?','Ciri-ciri','Testimoni','Langgan SPS Lite','Hubungi Kami','#services','#portfolio','#about-section','#team-section','#contact','Selamat Datang ke SPS Lite','Memudahkan Perniagaan kecil Anda Menjadi BESAR','Free Trial / Login','http://demo.spslite.my/login',0,0,'2016-07-20 03:36:48','Mengapa SPS Lite?','Mengapa SPS Lite','Responsif','Responsive dengan semua device termasuk tablet dan smartphone','Dwibahasa','Dalam Bahasa Malaysia dan Inggeris','Mesra Pengguna','','Untung dan Rugi','Laporan Untung dan Rugi semudah ABC','Kewangan','Laporan Kewangan semudah ABC','Pengkomputeran Awam','Membawa anda ke era Digital','Perkhidmatan Kami','Contoh-contoh Skrin dan Laporan','Jualan','Rekod Jualan','Perbelanjaan','Rekod Perbelanjaan','Umum','Ketetapan Umum','Laporan','Contoh-contoh laporan','Tetapan','Ketetapan setup Pentadbir','Pautan','Pautan Tambahan','','','','','','','','','','','','','Testimoni','Testimoni pengguna bijak produk kami','','','','','','','','','','','','','','','','','','Jom Daftar','Team Kami','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','Untuk melanggan SPS Lite, hubungi kami di talian +03-6185 9970 atau emel ke info@salihinpremier.com.'),(17,0,'hijrah.comsali','SPS Lite','','Mengapa SPS Lite ?','Ciri-ciri','Testimoni','Langgan SPS Lite','Hubungi Kami','#services','#portfolio','#about-section','#team-section','#contact','Selamat Datang ke SPS Lite','Memudahkan Perniagaan Anda','Free Trial / Login','http://demo.spslite.my/login',0,0,'2016-07-20 03:36:48','Mengapa SPS Lite?','Mengapa SPS Lite','Responsif','Responsive dengan semua device termasuk tablet dan smartphone','Dwibahasa','Dalam Bahasa Malaysia dan Inggeris','Mesra Pengguna','','Untung dan Rugi','Laporan Untung dan Rugi semudah ABC','Kewangan','Laporan Kewangan semudah ABC','Pengkomputeran Awam','Membawa anda ke era Digital','Perkhidmatan Kami','Contoh-contoh Skrin dan Laporan','Jualan','Rekod Jualan','Perbelanjaan','Rekod Perbelanjaan','Umum','Ketetapan Umum','Laporan','Contoh-contoh laporan','Tetapan','Ketetapan setup Pentadbir','Pautan','Pautan Tambahan','','','','','','','','','','','','','testimoni','','','','','','','','','','','','','','','','','','','','Team Kami','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','Untuk melanggan SPS Lite, hubungi kami di talian +03-6185 9970 atau emel ke info@salihinpremier.com.'),(18,0,'','SPS Lite','','Mengapa SPS Lite ?','Ciri-ciri','Testimoni','Langgan SPS Lite','Hubungi Kami','#services','#portfolio','#about-section','#team-section','#contact','Selamat Datang ke SPS Lite','Memudahkan Perniagaan Anda','Free Trial / Login','http://demo.spslite.my/login',0,0,'2016-07-20 03:36:48','Mengapa SPS Lite?','Mengapa SPS Lite','Responsif','Responsive dengan semua device termasuk tablet dan smartphone','Dwibahasa','Dalam Bahasa Malaysia dan Inggeris','Mesra Pengguna','','Untung dan Rugi','Laporan Untung dan Rugi semudah ABC','Kewangan','Laporan Kewangan semudah ABC','Pengkomputeran Awam','Membawa anda ke era Digital','Perkhidmatan Kami','Contoh-contoh Skrin dan Laporan','Jualan','Rekod Jualan','Perbelanjaan','Rekod Perbelanjaan','Umum','Ketetapan Umum','Laporan','Contoh-contoh laporan','Tetapan','Ketetapan setup Pentadbir','Pautan','Pautan Tambahan','','','','','','','','','','','','','testimoni','','','','','','','','','','','','','','','','','','','','Team Kami','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','Untuk melanggan SPS Lite, hubungi kami di talian +03-6185 9970 atau emel ke info@salihinpremier.com.'),(19,0,'','SPS Lite','','Mengapa SPS Lite ?','Ciri-ciri','Testimoni','Langgan SPS Lite','Hubungi Kami','#services','#portfolio','#about-section','#team-section','#contact','Selamat Datang ke SPS Lite','Memudahkan Perniagaan Anda','Free Trial / Login','http://demo.spslite.my/login',0,0,'2016-07-20 03:36:48','Mengapa SPS Lite?','Mengapa SPS Lite','Responsif','Responsive dengan semua device termasuk tablet dan smartphone','Dwibahasa','Dalam Bahasa Malaysia dan Inggeris','Mesra Pengguna','','Untung dan Rugi','Laporan Untung dan Rugi semudah ABC','Kewangan','Laporan Kewangan semudah ABC','Pengkomputeran Awam','Membawa anda ke era Digital','Perkhidmatan Kami','Contoh-contoh Skrin dan Laporan','Jualan','Rekod Jualan','Perbelanjaan','Rekod Perbelanjaan','Umum','Ketetapan Umum','Laporan','Contoh-contoh laporan','Tetapan','Ketetapan setup Pentadbir','Pautan','Pautan Tambahan','','','','','','','','','','','','','testimoni','','','','','','','','','','','','','','','','','','','','Team Kami','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','Untuk melanggan SPS Lite, hubungi kami di talian +03-6185 9970 atau emel ke info@salihinpremier.com.'),(20,0,'','SPS Lite','','Mengapa SPS Lite ?','Ciri-ciri','Testimoni','Langgan SPS Lite','Hubungi Kami','#services','#portfolio','#about-section','#team-section','#contact','Selamat Datang ke SPS Lite','Memudahkan Perniagaan Anda','Free Trial / Login','http://demo.spslite.my/login',0,0,'2016-07-20 03:36:48','Mengapa SPS Lite?','Mengapa SPS Lite','Responsif','Responsive dengan semua device termasuk tablet dan smartphone','Dwibahasa','Dalam Bahasa Malaysia dan Inggeris','Mesra Pengguna','','Untung dan Rugi','Laporan Untung dan Rugi semudah ABC','Kewangan','Laporan Kewangan semudah ABC','Pengkomputeran Awam','Membawa anda ke era Digital','Perkhidmatan Kami','Contoh-contoh Skrin dan Laporan','Jualan','Rekod Jualan','Perbelanjaan','Rekod Perbelanjaan','Umum','Ketetapan Umum','Laporan','Contoh-contoh laporan','Tetapan','Ketetapan setup Pentadbir','Pautan','Pautan Tambahan','','','','','','','','','','','','','testimoni','','','','','','','','','','','','','','','','','','','','Team Kami','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','Untuk melanggan SPS Lite, hubungi kami di talian +03-6185 9970 atau emel ke info@salihinpremier.com.'),(21,0,'','SPS Lite','','Mengapa SPS Lite ?','Ciri-ciri','Testimoni','Langgan SPS Lite','Hubungi Kami','#services','#portfolio','#about-section','#team-section','#contact','Selamat Datang ke SPS Lite','Memudahkan Perniagaan Anda','Free Trial / Login','http://demo.spslite.my/login',0,0,'2016-07-20 03:36:48','Mengapa SPS Lite?','Mengapa SPS Lite','Responsif','Responsive dengan semua device termasuk tablet dan smartphone','Dwibahasa','Dalam Bahasa Malaysia dan Inggeris','Mesra Pengguna','','Untung dan Rugi','Laporan Untung dan Rugi semudah ABC','Kewangan','Laporan Kewangan semudah ABC','Pengkomputeran Awam','Membawa anda ke era Digital','Perkhidmatan Kami','Contoh-contoh Skrin dan Laporan','Jualan','Rekod Jualan','Perbelanjaan','Rekod Perbelanjaan','Umum','Ketetapan Umum','Laporan','Contoh-contoh laporan','Tetapan','Ketetapan setup Pentadbir','Pautan','Pautan Tambahan','','','','','','','','','','','','','testimoni','','','','','','','','','','','','','','','','','','','','Team Kami','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','Untuk melanggan SPS Lite, hubungi kami di talian +03-6185 9970 atau emel ke info@salihinpremier.com.'),(22,0,'','SPS Lite','','Mengapa SPS Lite ?','Ciri-ciri','Testimoni','Langgan SPS Lite','Hubungi Kami','#services','#portfolio','#about-section','#team-section','#contact','Selamat Datang ke SPS Lite','Memudahkan Perniagaan Anda','Free Trial / Login','http://demo.spslite.my/login',0,0,'2016-07-20 03:36:48','Mengapa SPS Lite?','Mengapa SPS Lite','Responsif','Responsive dengan semua device termasuk tablet dan smartphone','Dwibahasa','Dalam Bahasa Malaysia dan Inggeris','Mesra Pengguna','','Untung dan Rugi','Laporan Untung dan Rugi semudah ABC','Kewangan','Laporan Kewangan semudah ABC','Pengkomputeran Awam','Membawa anda ke era Digital','Perkhidmatan Kami','Contoh-contoh Skrin dan Laporan','Jualan','Rekod Jualan','Perbelanjaan','Rekod Perbelanjaan','Umum','Ketetapan Umum','Laporan','Contoh-contoh laporan','Tetapan','Ketetapan setup Pentadbir','Pautan','Pautan Tambahan','','','','','','','','','','','','','testimoni','','','','','','','','','','','','','','','','','','','','Team Kami','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','Untuk melanggan SPS Lite, hubungi kami di talian +03-6185 9970 atau emel ke info@salihinpremier.com.'),(23,0,'','SPS Lite','','Mengapa SPS Lite ?','Ciri-ciri','Testimoni','Langgan SPS Lite','Hubungi Kami','#services','#portfolio','#about-section','#team-section','#contact','Selamat Datang ke SPS Lite','Memudahkan Perniagaan Anda','Free Trial / Login','http://demo.spslite.my/login',0,0,'2016-07-20 03:36:48','Mengapa SPS Lite?','Mengapa SPS Lite','Responsif','Responsive dengan semua device termasuk tablet dan smartphone','Dwibahasa','Dalam Bahasa Malaysia dan Inggeris','Mesra Pengguna','','Untung dan Rugi','Laporan Untung dan Rugi semudah ABC','Kewangan','Laporan Kewangan semudah ABC','Pengkomputeran Awam','Membawa anda ke era Digital','Perkhidmatan Kami','Contoh-contoh Skrin dan Laporan','Jualan','Rekod Jualan','Perbelanjaan','Rekod Perbelanjaan','Umum','Ketetapan Umum','Laporan','Contoh-contoh laporan','Tetapan','Ketetapan setup Pentadbir','Pautan','Pautan Tambahan','','','','','','','','','','','','','testimoni','','','','','','','','','','','','','','','','','','','','Team Kami','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','Untuk melanggan SPS Lite, hubungi kami di talian +03-6185 9970 atau emel ke info@salihinpremier.com.'),(24,0,'','SPS Lite','','Mengapa SPS Lite ?','Ciri-ciri','Testimoni','Langgan SPS Lite','Hubungi Kami','#services','#portfolio','#about-section','#team-section','#contact','Selamat Datang ke SPS Lite','Memudahkan Perniagaan Anda','Free Trial / Login','http://demo.spslite.my/login',0,0,'2016-07-20 03:36:48','Mengapa SPS Lite?','Mengapa SPS Lite','Responsif','Responsive dengan semua device termasuk tablet dan smartphone','Dwibahasa','Dalam Bahasa Malaysia dan Inggeris','Mesra Pengguna','','Untung dan Rugi','Laporan Untung dan Rugi semudah ABC','Kewangan','Laporan Kewangan semudah ABC','Pengkomputeran Awam','Membawa anda ke era Digital','Perkhidmatan Kami','Contoh-contoh Skrin dan Laporan','Jualan','Rekod Jualan','Perbelanjaan','Rekod Perbelanjaan','Umum','Ketetapan Umum','Laporan','Contoh-contoh laporan','Tetapan','Ketetapan setup Pentadbir','Pautan','Pautan Tambahan','','','','','','','','','','','','','testimoni','','','','','','','','','','','','','','','','','','','','Team Kami','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','Untuk melanggan SPS Lite, hubungi kami di talian +03-6185 9970 atau emel ke info@salihinpremier.com.'),(25,0,'','SPS Lite','','Mengapa SPS Lite ?','Ciri-ciri','Testimoni','Langgan SPS Lite','Hubungi Kami','#services','#portfolio','#about-section','#team-section','#contact','Selamat Datang ke SPS Lite','Memudahkan Perniagaan Anda','Free Trial / Login','http://demo.spslite.my/login',0,0,'2016-07-20 03:36:48','Mengapa SPS Lite?','Mengapa SPS Lite','Responsif','Responsive dengan semua device termasuk tablet dan smartphone','Dwibahasa','Dalam Bahasa Malaysia dan Inggeris','Mesra Pengguna','','Untung dan Rugi','Laporan Untung dan Rugi semudah ABC','Kewangan','Laporan Kewangan semudah ABC','Pengkomputeran Awam','Membawa anda ke era Digital','Perkhidmatan Kami','Contoh-contoh Skrin dan Laporan','Jualan','Rekod Jualan','Perbelanjaan','Rekod Perbelanjaan','Umum','Ketetapan Umum','Laporan','Contoh-contoh laporan','Tetapan','Ketetapan setup Pentadbir','Pautan','Pautan Tambahan','','','','','','','','','','','','','testimoni','','','','','','','','','','','','','','','','','','','','Team Kami','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','Untuk melanggan SPS Lite, hubungi kami di talian +03-6185 9970 atau emel ke info@salihinpremier.com.'),(26,0,'demo','SPS Lite','','Mengapa SPS Lite ?','Ciri-ciri','Testimoni','Langgan SPS Lite','Hubungi Kami Sekarang!','#services','#portfolio','#about-section','#team-section','#contact','Selamat Datang ke syarikat saya','Memudahkan Perniagaan Anda','Free Trial / Login','http://demo.spslite.my/login',0,0,'2016-07-20 03:36:48','Mengapa SPS Lite?','Mengapa SPS Lite','Responsif','Responsive dengan semua device termasuk tablet dan smartphone','Dwibahasa','Dalam Bahasa Malaysia dan Inggeris','Mesra Pengguna','','Untung dan Rugi','Laporan Untung dan Rugi semudah ABC','Kewangan','Laporan Kewangan semudah ABC','Pengkomputeran Awam','Membawa anda ke era Digital','Perkhidmatan Kami','Contoh-contoh Skrin dan Laporan','Jualan','Rekod Jualan','Perbelanjaan','Rekod Perbelanjaan','Umum','Ketetapan Umum','Laporan','Contoh-contoh laporan','Tetapan','Ketetapan setup Pentadbir','Pautan','Pautan Tambahan','','','','','','','','','','','','','testimoni','','','','','','','','','','','','','','','','','','','','Team Kami','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','Untuk melanggan SPS Lite, hubungi kami di talian +03-6185 9970 atau emel ke info@salihinpremier.com.'),(27,0,'','SPS Lite','','Mengapa SPS Lite ?','Ciri-ciri','Testimoni','Langgan SPS Lite','Hubungi Kami','#services','#portfolio','#about-section','#team-section','#contact','Selamat Datang ke SPS Lite','Memudahkan Perniagaan Anda','Free Trial / Login','http://demo.spslite.my/login',0,0,'2016-07-20 03:36:48','Mengapa SPS Lite?','Mengapa SPS Lite','Responsif','Responsive dengan semua device termasuk tablet dan smartphone','Dwibahasa','Dalam Bahasa Malaysia dan Inggeris','Mesra Pengguna','','Untung dan Rugi','Laporan Untung dan Rugi semudah ABC','Kewangan','Laporan Kewangan semudah ABC','Pengkomputeran Awam','Membawa anda ke era Digital','Perkhidmatan Kami','Contoh-contoh Skrin dan Laporan','Jualan','Rekod Jualan','Perbelanjaan','Rekod Perbelanjaan','Umum','Ketetapan Umum','Laporan','Contoh-contoh laporan','Tetapan','Ketetapan setup Pentadbir','Pautan','Pautan Tambahan','','','','','','','','','','','','','testimoni','','','','','','','','','','','','','','','','','','','','Team Kami','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','Untuk melanggan SPS Lite, hubungi kami di talian +03-6185 9970 atau emel ke info@salihinpremier.com.'),(28,0,'','SPS Lite','','Mengapa SPS Lite ?','Ciri-ciri','Testimoni','Langgan SPS Lite','Hubungi Kami','#services','#portfolio','#about-section','#team-section','#contact','Selamat Datang ke SPS Lite','Memudahkan Perniagaan Anda','Free Trial / Login','http://demo.spslite.my/login',0,0,'2016-07-20 03:36:48','Mengapa SPS Lite?','Mengapa SPS Lite','Responsif','Responsive dengan semua device termasuk tablet dan smartphone','Dwibahasa','Dalam Bahasa Malaysia dan Inggeris','Mesra Pengguna','','Untung dan Rugi','Laporan Untung dan Rugi semudah ABC','Kewangan','Laporan Kewangan semudah ABC','Pengkomputeran Awam','Membawa anda ke era Digital','Perkhidmatan Kami','Contoh-contoh Skrin dan Laporan','Jualan','Rekod Jualan','Perbelanjaan','Rekod Perbelanjaan','Umum','Ketetapan Umum','Laporan','Contoh-contoh laporan','Tetapan','Ketetapan setup Pentadbir','Pautan','Pautan Tambahan','','','','','','','','','','','','','testimoni','','','','','','','','','','','','','','','','','','','','Team Kami','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','Untuk melanggan SPS Lite, hubungi kami di talian +03-6185 9970 atau emel ke info@salihinpremier.com.'),(29,0,'20','SPS Lite','','Mengapa SPS Lite ?','Ciri-ciri','Testimoni','Langgan SPS Lite','Hubungi Kami','#services','#portfolio','#about-section','#team-section','#contact','Selamat Datang ke SPS Lite','Memudahkan Perniagaan Anda','Free Trial / Login','http://demo.spslite.my/login',0,0,'2016-07-20 03:36:48','Mengapa SPS Lite?','Mengapa SPS Lite','Responsif','Responsive dengan semua device termasuk tablet dan smartphone','Dwibahasa','Dalam Bahasa Malaysia dan Inggeris','Mesra Pengguna','','Untung dan Rugi','Laporan Untung dan Rugi semudah ABC','Kewangan','Laporan Kewangan semudah ABC','Pengkomputeran Awam','Membawa anda ke era Digital','Perkhidmatan Kami','Contoh-contoh Skrin dan Laporan','Jualan','Rekod Jualan','Perbelanjaan','Rekod Perbelanjaan','Umum','Ketetapan Umum','Laporan','Contoh-contoh laporan','Tetapan','Ketetapan setup Pentadbir','Pautan','Pautan Tambahan','','','','','','','','','','','','','testimoni','','','','','','','','','','','','','','','','','','','','Team Kami','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','Untuk melanggan SPS Lite, hubungi kami di talian +03-6185 9970 atau emel ke info@salihinpremier.com.'),(30,0,'aizat','SPS Lite','','Mengapa SPS Lite ?','Ciri-ciri','Testimoni','Langgan SPS Lite','Hubungi Kami','#services','#portfolio','#about-section','#team-section','#contact','Selamat Datang ke SPS Lite','Memudahkan Perniagaan Anda','Free Trial / Login','http://demo.spslite.my/login',0,0,'2016-07-20 03:36:48','Mengapa SPS Lite?','Mengapa SPS Lite','Responsif','Responsive dengan semua device termasuk tablet dan smartphone','Dwibahasa','Dalam Bahasa Malaysia dan Inggeris','Mesra Pengguna','','Untung dan Rugi','Laporan Untung dan Rugi semudah ABC','Kewangan','Laporan Kewangan semudah ABC','Pengkomputeran Awam','Membawa anda ke era Digital','Perkhidmatan Kami','Contoh-contoh Skrin dan Laporan','Jualan','Rekod Jualan','Perbelanjaan','Rekod Perbelanjaan','Umum','Ketetapan Umum','Laporan','Contoh-contoh laporan','Tetapan','Ketetapan setup Pentadbir','Pautan','Pautan Tambahan','','','','','','','','','','','','','testimoni','','','','','','','','','','','','','','','','','','','','Team Kami','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','Untuk melanggan SPS Lite, hubungi kami di talian +03-6185 9970 atau emel ke info@salihinpremier.com.');
/*!40000 ALTER TABLE `web` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Final view structure for view `view_companystatus`
--

/*!50001 DROP TABLE IF EXISTS `view_companystatus`*/;
/*!50001 DROP VIEW IF EXISTS `view_companystatus`*/;
/*!50001 SET @saved_cs_client          = @@character_set_client */;
/*!50001 SET @saved_cs_results         = @@character_set_results */;
/*!50001 SET @saved_col_connection     = @@collation_connection */;
/*!50001 SET character_set_client      = utf8mb4 */;
/*!50001 SET character_set_results     = utf8mb4 */;
/*!50001 SET collation_connection      = utf8mb4_general_ci */;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `view_companystatus` AS select `a`.`ID` AS `companyid`,`a`.`companyName` AS `companyname`,`a`.`companyNo` AS `companyno`,`a`.`companyStateID` AS `companystateid`,`a`.`parlimenID` AS `parlimenid`,`c`.`username` AS `username`,(select max(`payment_receive`.`dateReceive`) from `payment_receive` where (`payment_receive`.`userID` = `b`.`userID`)) AS `lastpayment`,(select max(`payment_receive`.`nextExpiracy`) from `payment_receive` where (`payment_receive`.`userID` = `b`.`userID`)) AS `expirydate`,`c`.`last_seen` AS `last_seen`,if(((`c`.`last_seen` <= (now() - interval 1 month)) or isnull(`c`.`last_seen`) or (`c`.`last_seen` = '0000-00-00 00:00:00')),'inactive','active') AS `status` from ((`company` `a` left join `user_module_access` `b` on((`b`.`companyID` = `a`.`ID`))) left join `tbl_usermaster` `c` on((`c`.`fldid` = `b`.`userID`))) group by `a`.`ID` */;
/*!50001 SET character_set_client      = @saved_cs_client */;
/*!50001 SET character_set_results     = @saved_cs_results */;
/*!50001 SET collation_connection      = @saved_col_connection */;

--
-- Final view structure for view `view_expences_monthly`
--

/*!50001 DROP TABLE IF EXISTS `view_expences_monthly`*/;
/*!50001 DROP VIEW IF EXISTS `view_expences_monthly`*/;
/*!50001 SET @saved_cs_client          = @@character_set_client */;
/*!50001 SET @saved_cs_results         = @@character_set_results */;
/*!50001 SET @saved_col_connection     = @@collation_connection */;
/*!50001 SET character_set_client      = utf8mb4 */;
/*!50001 SET character_set_results     = utf8mb4 */;
/*!50001 SET collation_connection      = utf8mb4_general_ci */;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `view_expences_monthly` AS select date_format(`spslitem_tekun1db`.`comp_payment_others`.`paymentDate`,'%Y%m') AS `yymm`,`spslitem_tekun1db`.`comp_payment_others`.`formNo` AS `formno`,year(`spslitem_tekun1db`.`comp_payment_others`.`paymentDate`) AS `yy`,month(`spslitem_tekun1db`.`comp_payment_others`.`paymentDate`) AS `mm`,sum(`spslitem_tekun1db`.`comp_payment_others`.`amountPaid`) AS `amountPaid` from `spslitem_tekun1db`.`comp_payment_others` group by `spslitem_tekun1db`.`comp_payment_others`.`formNo`,year(`spslitem_tekun1db`.`comp_payment_others`.`paymentDate`),month(`spslitem_tekun1db`.`comp_payment_others`.`paymentDate`) */;
/*!50001 SET character_set_client      = @saved_cs_client */;
/*!50001 SET character_set_results     = @saved_cs_results */;
/*!50001 SET collation_connection      = @saved_col_connection */;

--
-- Final view structure for view `view_next_server_allocation`
--

/*!50001 DROP TABLE IF EXISTS `view_next_server_allocation`*/;
/*!50001 DROP VIEW IF EXISTS `view_next_server_allocation`*/;
/*!50001 SET @saved_cs_client          = @@character_set_client */;
/*!50001 SET @saved_cs_results         = @@character_set_results */;
/*!50001 SET @saved_col_connection     = @@collation_connection */;
/*!50001 SET character_set_client      = utf8mb4 */;
/*!50001 SET character_set_results     = utf8mb4 */;
/*!50001 SET collation_connection      = utf8mb4_general_ci */;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `view_next_server_allocation` AS select `company`.`server` AS `server`,`company`.`database` AS `database`,count(`company`.`ID`) AS `no_of_user` from `company` group by `company`.`server`,`company`.`database` order by count(`company`.`ID`) limit 1 */;
/*!50001 SET character_set_client      = @saved_cs_client */;
/*!50001 SET character_set_results     = @saved_cs_results */;
/*!50001 SET collation_connection      = @saved_col_connection */;

--
-- Final view structure for view `view_sales_by_state`
--

/*!50001 DROP TABLE IF EXISTS `view_sales_by_state`*/;
/*!50001 DROP VIEW IF EXISTS `view_sales_by_state`*/;
/*!50001 SET @saved_cs_client          = @@character_set_client */;
/*!50001 SET @saved_cs_results         = @@character_set_results */;
/*!50001 SET @saved_col_connection     = @@collation_connection */;
/*!50001 SET character_set_client      = utf8mb4 */;
/*!50001 SET character_set_results     = utf8mb4 */;
/*!50001 SET collation_connection      = utf8mb4_general_ci */;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `view_sales_by_state` AS select distinct `b`.`countryID` AS `countryID`,`c`.`fldcountry` AS `fldcountry`,`d`.`fldid` AS `StateID`,`d`.`fldname` AS `fldname`,year(`a`.`receivePaymentDate`) AS `Year`,cast(sum(if((month(`a`.`receivePaymentDate`) = 1),`a`.`totalReceived`,0)) as decimal(15,2)) AS `January`,cast(sum(if((month(`a`.`receivePaymentDate`) = 2),`a`.`totalReceived`,0)) as decimal(15,2)) AS `February`,cast(sum(if((month(`a`.`receivePaymentDate`) = 3),`a`.`totalReceived`,0)) as decimal(15,2)) AS `March`,cast(sum(if((month(`a`.`receivePaymentDate`) = 4),`a`.`totalReceived`,0)) as decimal(15,2)) AS `April`,cast(sum(if((month(`a`.`receivePaymentDate`) = 5),`a`.`totalReceived`,0)) as decimal(15,2)) AS `May`,cast(sum(if((month(`a`.`receivePaymentDate`) = 6),`a`.`totalReceived`,0)) as decimal(15,2)) AS `June`,cast(sum(if((month(`a`.`receivePaymentDate`) = 7),`a`.`totalReceived`,0)) as decimal(15,2)) AS `July`,cast(sum(if((month(`a`.`receivePaymentDate`) = 8),`a`.`totalReceived`,0)) as decimal(15,2)) AS `August`,cast(sum(if((month(`a`.`receivePaymentDate`) = 9),`a`.`totalReceived`,0)) as decimal(15,2)) AS `September`,cast(sum(if((month(`a`.`receivePaymentDate`) = 10),`a`.`totalReceived`,0)) as decimal(15,2)) AS `October`,cast(sum(if((month(`a`.`receivePaymentDate`) = 11),`a`.`totalReceived`,0)) as decimal(15,2)) AS `November`,cast(sum(if((month(`a`.`receivePaymentDate`) = 12),`a`.`totalReceived`,0)) as decimal(15,2)) AS `December`,cast(sum(`a`.`totalReceived`) as decimal(15,2)) AS `Amount`,cast(avg(`a`.`totalReceived`) as decimal(15,2)) AS `Average`,count(`a`.`ID`) AS `Total` from (((`spslitem_tekun1db`.`comp_receive_payment_others` `a` join `spslitem_tekun_admindb`.`company` `b`) join `spslitem_tekun_admindb`.`_ref_country` `c`) join `spslitem_tekun_admindb`.`_ref_state` `d`) where ((`a`.`companyID` = `b`.`ID`) and (`b`.`countryID` = `c`.`fldid`) and (`b`.`companyStateID` = `d`.`fldid`) and (`a`.`is_delete` = 0)) group by `b`.`companyStateID`,year(`a`.`receivePaymentDate`) */;
/*!50001 SET character_set_client      = @saved_cs_client */;
/*!50001 SET character_set_results     = @saved_cs_results */;
/*!50001 SET collation_connection      = @saved_col_connection */;

--
-- Final view structure for view `view_sales_monthly`
--

/*!50001 DROP TABLE IF EXISTS `view_sales_monthly`*/;
/*!50001 DROP VIEW IF EXISTS `view_sales_monthly`*/;
/*!50001 SET @saved_cs_client          = @@character_set_client */;
/*!50001 SET @saved_cs_results         = @@character_set_results */;
/*!50001 SET @saved_col_connection     = @@collation_connection */;
/*!50001 SET character_set_client      = utf8mb4 */;
/*!50001 SET character_set_results     = utf8mb4 */;
/*!50001 SET collation_connection      = utf8mb4_general_ci */;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `view_sales_monthly` AS select date_format(`spslitem_tekun1db`.`comp_receive_payment_others`.`receivePaymentDate`,'%Y%m') AS `yymm`,year(`spslitem_tekun1db`.`comp_receive_payment_others`.`receivePaymentDate`) AS `yy`,month(`spslitem_tekun1db`.`comp_receive_payment_others`.`receivePaymentDate`) AS `mm`,sum(`spslitem_tekun1db`.`comp_receive_payment_others`.`totalReceived`) AS `totalreceived` from `spslitem_tekun1db`.`comp_receive_payment_others` where (`spslitem_tekun1db`.`comp_receive_payment_others`.`is_delete` = 0) group by `spslitem_tekun1db`.`comp_receive_payment_others`.`companyID`,year(`spslitem_tekun1db`.`comp_receive_payment_others`.`receivePaymentDate`),month(`spslitem_tekun1db`.`comp_receive_payment_others`.`receivePaymentDate`) */;
/*!50001 SET character_set_client      = @saved_cs_client */;
/*!50001 SET character_set_results     = @saved_cs_results */;
/*!50001 SET collation_connection      = @saved_col_connection */;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!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 */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2016-12-09 12:21:13
