CREATE DATABASE  IF NOT EXISTS `doccat_db` /*!40100 DEFAULT CHARACTER SET utf8 */;
USE `doccat_db`;
-- MySQL dump 10.13  Distrib 5.5.16, for Win32 (x86)
--
-- Host: localhost    Database: doccat_db
-- ------------------------------------------------------
-- Server version	5.5.18

/*!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 `transaction`
--

DROP TABLE IF EXISTS `transaction`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `transaction` (
  `transid` int(11) NOT NULL AUTO_INCREMENT,
  `userid` int(11) DEFAULT NULL,
  `folderid` int(11) DEFAULT NULL,
  `date_checkout` timestamp NULL DEFAULT NULL,
  `date_checkin` timestamp NULL DEFAULT NULL,
  `is_checkout` int(11) DEFAULT NULL,
  `is_checkin` int(11) DEFAULT NULL,
  PRIMARY KEY (`transid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `transaction`
--

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

--
-- Table structure for table `users`
--

DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users` (
  `userid` int(11) NOT NULL AUTO_INCREMENT,
  `sapid` varchar(15) DEFAULT NULL,
  `firstname` varchar(100) DEFAULT NULL,
  `lastname` varchar(100) DEFAULT NULL,
  `password` varchar(200) DEFAULT NULL,
  `department` varchar(50) DEFAULT NULL,
  `division` varchar(50) DEFAULT NULL,
  `date_added` timestamp NULL DEFAULT NULL,
  `level` int(11) DEFAULT '1',
  PRIMARY KEY (`userid`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `users`
--

LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES (1,'00056463','Xin','Lee','5f4dcc3b5aa765d61d8327deb882cf99','IW - GSC','GHO',NULL,0),(3,'00046397','Myra','Abdul Mutalib','10d09d6902814c47c7e8bf44893e1b14','GCAD','ENERGY AND UTILITIE','2012-01-03 23:05:52',0),(9,'12345','Normal','User','827ccb0eea8a706c4c34a16891f84e7b','GCAD','GROUP HEAD OFFICE','2012-01-04 00:19:06',1);
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ci_sessions`
--

DROP TABLE IF EXISTS `ci_sessions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ci_sessions` (
  `session_id` varchar(40) NOT NULL DEFAULT '0',
  `ip_address` varchar(16) NOT NULL DEFAULT '0',
  `user_agent` varchar(120) NOT NULL,
  `last_activity` int(10) unsigned NOT NULL DEFAULT '0',
  `user_data` text,
  PRIMARY KEY (`session_id`),
  KEY `last_activity_idx` (`last_activity`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ci_sessions`
--

LOCK TABLES `ci_sessions` WRITE;
/*!40000 ALTER TABLE `ci_sessions` DISABLE KEYS */;
INSERT INTO `ci_sessions` VALUES ('2ed19b850d9b6d539ab453a99971bca3','165.21.21.38','Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.1; Trident/4.0; .NET CLR 2.0.50727; .NET CLR 3.0.4506.2152; .NET CLR 3.5',1325658741,'a:2:{s:9:\"user_data\";s:0:\"\";s:18:\"flash:new:loginsrc\";b:0;}'),('4349628df1d6a8fc1a55788f53d8be1c','66.249.71.145','Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)',1325659540,'a:2:{s:9:\"user_data\";s:0:\"\";s:18:\"flash:new:loginsrc\";b:0;}'),('534579ac4837a063d477e4b9d5299d48','58.27.24.5','Mozilla/5.0 (Windows NT 6.0) AppleWebKit/535.7 (KHTML, like Gecko) Chrome/16.0.912.63 Safari/535.7',1325660635,'a:2:{s:9:\"user_data\";s:0:\"\";s:18:\"flash:new:loginsrc\";b:0;}'),('86c899cd44f633101207cf05f16fb91f','110.137.117.37','Mozilla/5.0 (Windows NT 6.1; WOW64; rv:8.0) Gecko/20100101 Firefox/8.0',1325660672,'a:2:{s:9:\"user_data\";s:0:\"\";s:18:\"flash:new:loginsrc\";b:0;}'),('9de10107bbfb2133e4ddeeb6ceaf0f24','66.249.66.242','Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)',1325659539,''),('aa4f82a25138ac6c95aa74d150089874','172.17.41.204','Mozilla/5.0 (Windows NT 5.1) AppleWebKit/535.7 (KHTML, like Gecko) Chrome/16.0.912.63 Safari/535.7',1325665163,'a:2:{s:9:\"user_data\";s:0:\"\";s:18:\"flash:new:loginsrc\";b:0;}');
/*!40000 ALTER TABLE `ci_sessions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `folder`
--

DROP TABLE IF EXISTS `folder`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `folder` (
  `folderid` int(11) NOT NULL AUTO_INCREMENT,
  `longid` varchar(100) DEFAULT NULL,
  `reportno` varchar(30) DEFAULT NULL,
  `company` int(11) DEFAULT NULL,
  `topic` varchar(200) DEFAULT NULL,
  `totalcount` int(11) DEFAULT NULL,
  `thiscount` int(11) DEFAULT NULL,
  `auditdate` timestamp NULL DEFAULT NULL,
  `pic` varchar(100) DEFAULT NULL,
  `date_added` timestamp NULL DEFAULT NULL,
  `last_updated` timestamp NULL DEFAULT NULL,
  `active` int(11) DEFAULT NULL,
  `available` int(11) DEFAULT '1',
  PRIMARY KEY (`folderid`)
) ENGINE=InnoDB AUTO_INCREMENT=51 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `folder`
--

LOCK TABLES `folder` WRITE;
/*!40000 ALTER TABLE `folder` DISABLE KEYS */;
INSERT INTO `folder` VALUES (4,NULL,'EN 35/2008-09',131,'Operations Review',2,2,'2009-05-03 16:00:00','Lai Bang Kee','2011-12-20 07:36:43','2011-12-20 07:36:43',1,1),(5,NULL,'EN 35/2008-09',131,'Operations Review',2,1,'2009-05-03 16:00:00','Lai Bang Kee','2011-12-20 07:36:43','2011-12-20 07:36:43',1,1),(6,NULL,'ES 29-2009/10',108,'Post Acquisition Review',1,1,'2010-03-30 16:00:00','Rashidan bin Ramly','2011-12-20 07:44:57','2011-12-20 07:44:57',1,1),(7,NULL,'EN 28/2008-09',122,'Contract Management',1,1,'2009-03-05 16:00:00','Lai Bang Kee','2011-12-20 07:47:41','2011-12-20 07:47:41',1,1),(8,NULL,'ES 3/2008-09',119,'Engineering and Design',1,1,'2008-07-13 16:00:00','Lai Bang Kee','2011-12-20 07:48:52','2011-12-20 07:48:52',1,1),(9,NULL,'EN 5/2008-2009',120,'Post Acquisition Review',1,1,'2008-07-27 16:00:00','Lai Bang Kee','2011-12-20 07:53:50','2011-12-20 07:53:50',1,1),(10,NULL,'EN 34/2008-09',104,'Related Party Transaction',1,1,'2009-04-12 16:00:00','Lai Bang Kee','2011-12-20 08:04:21','2011-12-20 08:04:21',1,1),(11,NULL,'EN 7/2008-09',119,'Subcontracting and Tendering',2,1,'2008-08-10 16:00:00','Lai Bang Kee','2011-12-20 08:09:37','2011-12-20 08:09:37',1,1),(12,NULL,'EN 7/2008-09',119,'Subcontracting and Tendering',2,2,'2008-08-10 16:00:00','Lai Bang Kee','2011-12-20 08:09:37','2011-12-20 08:09:37',1,1),(13,NULL,'EN 40/2008-09',119,'Project Management, Maersk Oil Qatar 16',2,1,'2009-05-12 16:00:00','Lai Bang Kee','2011-12-20 08:11:53','2011-12-20 08:11:53',1,1),(14,NULL,'EN 40/2008-09',119,'Project Management, Maersk Oil Qatar 16',2,2,'2009-05-12 16:00:00','Lai Bang Kee','2011-12-20 08:11:53','2011-12-20 08:11:53',1,1),(15,NULL,'UD 5/2008-09',111,'Post Acquisition Matters and Project Management',2,2,'2009-03-19 16:00:00','Lai Bang Kee','2011-12-20 08:13:26','2011-12-20 08:13:26',1,1),(16,NULL,'UD 5/2008-09',111,'Post Acquisition Matters and Project Management',2,1,'2009-03-19 16:00:00','Lai Bang Kee','2011-12-20 08:13:26','2011-12-20 08:13:26',1,1),(17,NULL,'EN 36/2008-09',104,'Risk Management',1,1,'2009-05-05 16:00:00','Lai Bang Kee','2011-12-20 08:19:32','2011-12-20 08:19:32',1,1),(18,NULL,'UD 7/2008-09',126,'Risk Management',1,1,'2009-04-05 16:00:00','Lai Bang Kee','2011-12-20 08:20:29','2011-12-20 08:20:29',1,1),(19,NULL,'EN 38/2008-09',129,'Plant Operations and Maintenance',1,1,'2009-05-26 16:00:00','Lai Bang Kee','2011-12-20 19:15:44','2011-12-20 19:15:44',1,1),(20,NULL,'EN 10/2008-09',132,'Operations Review',2,1,'2008-09-02 16:00:00','Lai Bang Kee','2011-12-20 19:16:48','2011-12-20 19:16:48',1,1),(21,NULL,'EN 10/2008-09',132,'Operations Review',2,2,'2008-09-02 16:00:00','Lai Bang Kee','2011-12-20 19:16:48','2011-12-20 19:16:48',1,1),(22,NULL,'EN 19/2008-09',104,'Tax Review',2,1,'2008-09-21 16:00:00','Lai Bang Kee','2011-12-20 19:19:30','2011-12-20 19:19:30',1,1),(23,NULL,'EN 19/2008-09',104,'Tax Review',2,2,'2008-09-21 16:00:00','Lai Bang Kee','2011-12-20 19:19:30','2011-12-20 19:19:30',1,1),(24,NULL,'EN 20/2008-09',105,'Special Review on Allegations of Unethical Practices',1,1,'2009-01-18 16:00:00','Lai Bang Kee','2011-12-20 19:26:11','2011-12-20 19:26:11',1,1),(25,NULL,'EN 15/2007-08',116,'Review of SAP Application Controls',1,1,'2007-12-09 16:00:00','Lai Bang Kee','2011-12-20 19:29:53','2011-12-20 19:29:53',1,1),(26,NULL,'EN 30/2008-09',130,'SAP Application Controls',1,1,'2009-03-15 16:00:00','Lai Bang Kee','2011-12-20 19:31:30','2011-12-20 19:31:31',1,1),(27,NULL,'EN 33/2009-10',119,'Review of Project Management ONGC B-193 5 Wellhead Platforms',1,1,'2010-04-05 16:00:00','Tay Soon Yik','2011-12-20 19:33:25','2011-12-20 19:33:25',1,1),(28,NULL,'EN 37/2009-10',104,'Review of Risk Management',1,1,'2010-05-09 16:00:00','Rashidan bin Ramly','2011-12-20 19:34:41','2011-12-20 19:34:41',1,1),(29,NULL,'EN 18/2009-10',119,'Project Management, Kumang, Tangga Barat Cluster and Kinabalu Jacket',1,1,'2009-11-15 16:00:00','Tay Soon Yik','2011-12-20 19:35:51','2011-12-20 19:35:51',1,1),(30,NULL,'EN 14/2009-10',149,'Water Operations Review',1,1,'2009-10-11 16:00:00','Tay Soon Yik','2011-12-20 19:37:07','2011-12-20 19:37:07',1,1),(31,NULL,'EN 02/2009-10',114,'Procurement and Inventory Management',1,1,'2009-07-26 16:00:00','Rashidan bin Ramly','2011-12-20 19:44:11','2011-12-20 19:44:11',1,1),(32,NULL,'EN 27/2009-10',119,'Material Management',1,1,'2009-11-15 16:00:00','Tay Soon Yik','2011-12-20 19:45:11','2011-12-20 19:45:11',1,1),(33,NULL,'EN 22/2008-09',119,'Time Management',1,1,'2009-01-11 16:00:00','Lai Bang Kee','2011-12-20 19:50:55','2011-12-20 19:50:55',1,1),(34,NULL,'EN 24/2008-09',131,'Project Management and Factory Operations',1,1,'2009-03-08 16:00:00','Tay Soon Yik','2011-12-20 19:51:59','2011-12-20 19:51:59',1,1),(35,NULL,'EN 18/2008-09',105,'SAP Application Controls',1,1,'2009-11-18 16:00:00','Chin Wai Ming','2011-12-20 19:53:40','2011-12-20 19:53:40',1,1),(36,NULL,'EN 15/2008-09',119,'Quality Assurance/Quality Control',1,1,'2008-11-03 16:00:00','Lai Bang Kee','2011-12-20 19:54:46','2011-12-20 19:54:46',1,1),(37,NULL,'EN 26/2008-09',120,'Operations Review',1,1,'2009-02-02 16:00:00','Lai Bang Kee','2011-12-20 19:55:56','2011-12-20 19:55:56',1,1),(38,NULL,'EN 33/2008-09',114,'Plant Operations and Maintenance',1,1,'2009-02-22 16:00:00','Tay Soon Yik','2011-12-20 22:16:02','2011-12-20 22:16:02',1,1),(39,NULL,'EN 54/2010-2011',104,'Related Party Transactions',1,1,'2011-06-12 16:00:00','Vivian Li','2011-12-20 22:43:40','2011-12-20 22:43:40',1,1),(40,NULL,'EN 25/2008-09',119,'Procurement of Project Materials',3,2,'2009-03-12 16:00:00','Chin Wai Ming','2011-12-20 22:45:11','2011-12-20 22:45:11',1,1),(41,NULL,'EN 25/2008-09',119,'Procurement of Project Materials',3,1,'2009-03-12 16:00:00','Chin Wai Ming','2011-12-20 22:45:11','2011-12-20 22:45:11',1,1),(42,NULL,'EN 25/2008-09',119,'Procurement of Project Materials',3,3,'2009-03-12 16:00:00','Chin Wai Ming','2011-12-20 22:45:11','2011-12-20 22:45:11',1,1),(43,NULL,'EN 21/2008-09',105,'Review of Project Management',1,1,'2009-01-11 16:00:00','Lai Bang Kee','2011-12-20 22:46:37','2011-12-20 22:46:37',1,1),(44,NULL,'EN 11/2008-09',119,'Proposals and Bids',1,1,'2008-08-10 16:00:00','Tay Soon Yik','2011-12-20 22:47:46','2011-12-20 22:47:46',1,1),(45,NULL,'EN 48/2010-11',132,'Finance Functions and Operations Review',3,1,'2011-04-23 16:00:00','Seethivenaigan Nadarajam','2012-01-03 01:15:04','2012-01-03 01:15:04',1,1),(46,NULL,'EN 48/2010-11',132,'Finance Functions and Operations Review',3,2,'2011-04-23 16:00:00','Seethivenaigan Nadarajam','2012-01-03 01:15:04','2012-01-03 01:15:04',1,1),(47,NULL,'EN 48/2010-11',132,'Finance Functions and Operations Review',3,3,'2011-04-23 16:00:00','Seethivenaigan Nadarajam','2012-01-03 01:15:04','2012-01-03 01:15:04',1,1),(48,NULL,'ES 29/2005-06',115,'Customer Support Services',1,1,'2006-04-23 16:00:00','Anas Sulaiman','2012-01-03 23:16:48','2012-01-03 23:16:48',1,1),(49,NULL,'ES 27/2005-06',115,'Johor Baru Branch Review',1,1,'2006-03-30 16:00:00','Anas Sulaiman','2012-01-03 23:17:42','2012-01-03 23:17:42',1,1),(50,NULL,'ES 23/2005-06',115,'Factory Production',1,1,'2006-02-20 16:00:00','Anas Sulaiman','2012-01-03 23:18:31','2012-01-03 23:18:31',1,1);
/*!40000 ALTER TABLE `folder` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `companylist`
--

DROP TABLE IF EXISTS `companylist`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `companylist` (
  `companyid` int(11) NOT NULL AUTO_INCREMENT,
  `companyname` varchar(200) DEFAULT NULL,
  `division` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`companyid`)
) ENGINE=InnoDB AUTO_INCREMENT=155 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `companylist`
--

LOCK TABLES `companylist` WRITE;
/*!40000 ALTER TABLE `companylist` DISABLE KEYS */;
INSERT INTO `companylist` VALUES (104,'Sime Darby Energy Sdn Bhd','ENU'),(105,'Mecomb Malaysia Sdn Bhd','ENU'),(106,'Sime Darby Offshore Engineering Sdn Bhd','ENU'),(107,'Sime Survelliance Sdn Bhd','ENU'),(108,'Sime Darby Drilling Services Sdn Bhd','ENU'),(109,'Sime Darby Water Resources Sdn Bhd','ENU'),(110,'Sime Darby Water Resources (Selangor) Sdn Bhd','ENU'),(111,'Sime Darby Water Resources (Perak) Sdn Bhd','ENU'),(112,'Malaysian Oriental Holdings Berhad','ENU'),(113,'Sime Engineering Sdn Bhd','ENU'),(114,'Port Dickson Power Berhad','ENU'),(115,'Chubb Malaysia Sendirian Berhad','ENU'),(116,'Sime-SIRIM Technologies Sdn Bhd','ENU'),(117,'Mustang Sime Darby Sdn Bhd','ENU'),(118,'JanaUrus PDP Sdn Bhd','ENU'),(119,'Sime Darby Engineering Sdn Bhd','ENU'),(120,'Sime Darby T & I Sdn Bhd','ENU'),(121,'Balui Hydro Sdn Bhd','ENU'),(122,'Malaysia-China Hydro Sdn Bhd','ENU'),(123,'Sime Darby Power Sdn Bhd','ENU'),(124,'Pesida Equipment Sdn Bhd','ENU'),(125,'Sime Darby Marine Sdn Bhd','ENU'),(126,'Sime Darby Utilities Sdn Bhd','ENU'),(127,'Sime Darby Energy Pty Ltd','ENU'),(128,'Sime Darby Power Co Ltd','ENU'),(129,'Sime Darby LCP Power Co Ltd','ENU'),(130,'Sime Darby O&M (Thailand) Co Ltd','ENU'),(131,'Mecomb Singapore Limited','ENU'),(132,'Mecomb Thailand Limited','ENU'),(133,'Chubb Singapore Private Limited','ENU'),(134,'Chubb Guarding Services Singapore Pte Ltd','ENU'),(135,'Guardfire (Malaysia) Sdn Bhd','ENU'),(136,'Sime Darby Almana W.L.L','ENU'),(137,'Sime Darby Marine (Hong Kong) Private Limited','ENU'),(138,'Halani Sime Darby Marine (FZC)','ENU'),(139,'Halani Sime Offshore (L) Inc','ENU'),(140,'Sime Darby Marine Puteri Offshore I (L) Inc','ENU'),(141,'Sime Darby Marine Puteri Offshore II (L) Inc','ENU'),(142,'Sime Darby Marine Puteri Offshore III (L) Inc','ENU'),(143,'Sime Darby Overseas (HK) Limited','ENU'),(144,'Jining Sime Darby Port Co Ltd','ENU'),(145,'Jining Sime Darby Longgong Port Co Ltd','ENU'),(146,'Jining Sime Darby Guozhuang Port Co Ltd','ENU'),(147,'Jining Sime Darby Taiping Port Co Ltd','ENU'),(148,'Zibo Sime Darby Chemicals Co Ltd','ENU'),(149,'Weifang Sime Darby Water Co Ltd','ENU'),(150,'Weifang Sime Darby Port Co Ltd','ENU'),(151,'Weifang Sime Darby Tugboat Services Co Ltd','ENU'),(152,'Weifang Sime Darby Shipyard Co Ltd','ENU'),(153,'Weifang Sime Darby Dredging Project Co Ltd','ENU'),(154,'Weifang Binhai Haiwei Dredging Project Co Ltd','ENU');
/*!40000 ALTER TABLE `companylist` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `location`
--

DROP TABLE IF EXISTS `location`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `location` (
  `locationid` int(11) NOT NULL AUTO_INCREMENT,
  `folderid` int(11) DEFAULT NULL,
  `country` varchar(100) DEFAULT NULL,
  `state` varchar(100) DEFAULT NULL,
  `suburb` varchar(100) DEFAULT NULL,
  `building` varchar(100) DEFAULT NULL,
  `level` varchar(3) DEFAULT NULL,
  `department` varchar(100) DEFAULT NULL,
  `shelve` varchar(100) DEFAULT NULL,
  `row` int(11) DEFAULT NULL,
  `col` int(11) DEFAULT NULL,
  `is_current` int(11) DEFAULT NULL,
  `last_moved` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`locationid`)
) ENGINE=InnoDB AUTO_INCREMENT=51 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `location`
--

LOCK TABLES `location` WRITE;
/*!40000 ALTER TABLE `location` DISABLE KEYS */;
INSERT INTO `location` VALUES (4,4,'MALAYSIA','Selangor','USJ7','Kompleks Sime Darby','3','GCAD','1',1,1,1,'2011-12-20 07:36:43'),(5,5,'MALAYSIA','Selangor','USJ7','Kompleks Sime Darby','3','GCAD','1',1,1,1,'2011-12-20 07:36:43'),(6,6,'MALAYSIA','Selangor','USJ7','Kompleks Sime Darby','3','GCAD','1',1,1,1,'2011-12-20 07:44:57'),(7,7,'MALAYSIA','Selangor','USJ7','Kompleks Sime Darby','3','GCAD','1',1,1,1,'2011-12-20 07:47:41'),(8,8,'MALAYSIA','Selangor','USJ7','Kompleks Sime Darby','3','GCAD','1',1,1,1,'2011-12-20 07:48:52'),(9,9,'MALAYSIA','Selangor','USJ7','Kompleks Sime Darby','3','GCAD','1',1,1,1,'2011-12-20 07:53:50'),(10,10,'MALAYSIA','Selangor','USJ7','Kompleks Sime Darby','3','GCAD','1',1,1,1,'2011-12-20 08:04:21'),(11,11,'MALAYSIA','Selangor','USJ7','Kompleks Sime Darby','3','GCAD','1',1,2,1,'2011-12-20 08:09:37'),(12,12,'MALAYSIA','Selangor','USJ7','Kompleks Sime Darby','3','GCAD','1',1,2,1,'2011-12-20 08:09:37'),(13,13,'MALAYSIA','Selangor','USJ7','Kompleks Sime Darby','3','GCAD','1',1,2,1,'2011-12-20 08:11:53'),(14,14,'MALAYSIA','Selangor','USJ7','Kompleks Sime Darby','3','GCAD','1',1,2,1,'2011-12-20 08:11:53'),(15,15,'MALAYSIA','Selangor','USJ7','Kompleks Sime Darby','3','GCAD','1',1,2,1,'2011-12-20 08:13:26'),(16,16,'MALAYSIA','Selangor','USJ7','Kompleks Sime Darby','3','GCAD','1',1,2,1,'2011-12-20 08:13:26'),(17,17,'MALAYSIA','Selangor','USJ7','Kompleks Sime Darby','3','GCAD','1',1,2,1,'2011-12-20 08:19:32'),(18,18,'MALAYSIA','Selangor','USJ7','Kompleks Sime Darby','3','GCAD','1',1,2,1,'2011-12-20 08:20:29'),(19,19,'MALAYSIA','Selangor','USJ7','Kompleks Sime Darby','3','GCAD','1',1,3,1,'2011-12-20 19:15:44'),(20,20,'MALAYSIA','Selangor','USJ7','Kompleks Sime Darby','3','GCAD','1',1,3,1,'2011-12-20 19:16:48'),(21,21,'MALAYSIA','Selangor','USJ7','Kompleks Sime Darby','3','GCAD','1',1,3,1,'2011-12-20 19:16:48'),(22,22,'MALAYSIA','Selangor','USJ7','Kompleks Sime Darby','3','GCAD','1',1,3,1,'2011-12-20 19:19:30'),(23,23,'MALAYSIA','Selangor','USJ7','Kompleks Sime Darby','3','GCAD','1',1,3,1,'2011-12-20 19:19:30'),(24,24,'MALAYSIA','Selangor','USJ7','Kompleks Sime Darby','3','GCAD','1',1,3,1,'2011-12-20 19:26:11'),(25,25,'MALAYSIA','Selangor','USJ7','Kompleks Sime Darby','3','GCAD','1',2,1,1,'2011-12-20 19:29:53'),(26,26,'MALAYSIA','Selangor','USJ7','Kompleks Sime Darby','3','GCAD','1',2,1,1,'2011-12-20 19:31:31'),(27,27,'MALAYSIA','Selangor','USJ7','Kompleks Sime Darby','3','GCAD','1',2,1,1,'2011-12-20 19:33:25'),(28,28,'MALAYSIA','Selangor','USJ7','Kompleks Sime Darby','3','GCAD','1',2,1,1,'2011-12-20 19:34:41'),(29,29,'MALAYSIA','Selangor','USJ7','Kompleks Sime Darby','3','GCAD','1',2,1,1,'2011-12-20 19:35:51'),(30,30,'MALAYSIA','Selangor','USJ7','Kompleks Sime Darby','3','GCAD','1',2,1,1,'2011-12-20 19:37:07'),(31,31,'MALAYSIA','Selangor','USJ7','Kompleks Sime Darby','3','GCAD','1',2,1,1,'2011-12-20 19:44:11'),(32,32,'MALAYSIA','Selangor','USJ7','Kompleks Sime Darby','3','GCAD','1',2,1,1,'2011-12-20 19:45:11'),(33,33,'MALAYSIA','Selangor','USJ7','Kompleks Sime Darby','3','GCAD','1',2,2,1,'2011-12-20 19:50:55'),(34,34,'MALAYSIA','Selangor','USJ7','Kompleks Sime Darby','3','GCAD','1',2,2,1,'2011-12-20 19:51:59'),(35,35,'MALAYSIA','Selangor','USJ7','Kompleks Sime Darby','3','GCAD','1',2,2,1,'2011-12-20 19:53:40'),(36,36,'MALAYSIA','Selangor','USJ7','Kompleks Sime Darby','3','GCAD','1',2,2,1,'2011-12-20 19:54:46'),(37,37,'MALAYSIA','Selangor','USJ7','Kompleks Sime Darby','3','GCAD','1',2,2,1,'2011-12-20 19:55:56'),(38,38,'MALAYSIA','Selangor','USJ7','Kompleks Sime Darby','3','GCAD','1',2,2,1,'2011-12-20 22:16:02'),(39,39,'MALAYSIA','Selangor','USJ7','Kompleks Sime Darby','3','GCAD','1',2,3,1,'2011-12-20 22:43:40'),(40,40,'MALAYSIA','Selangor','USJ7','Kompleks Sime Darby','3','GCAD','1',2,3,1,'2011-12-20 22:45:11'),(41,41,'MALAYSIA','Selangor','USJ7','Kompleks Sime Darby','3','GCAD','1',2,3,1,'2011-12-20 22:45:11'),(42,42,'MALAYSIA','Selangor','USJ7','Kompleks Sime Darby','3','GCAD','1',2,3,1,'2011-12-20 22:45:11'),(43,43,'MALAYSIA','Selangor','USJ7','Kompleks Sime Darby','3','GCAD','1',2,3,1,'2011-12-20 22:46:37'),(44,44,'MALAYSIA','Selangor','USJ7','Kompleks Sime Darby','3','GCAD','1',2,3,1,'2011-12-20 22:47:46'),(45,45,'MALAYSIA','Selangor','USJ7','Kompleks Sime Darby','3','GCAD','1',3,1,1,'2012-01-03 01:15:04'),(46,46,'MALAYSIA','Selangor','USJ7','Kompleks Sime Darby','3','GCAD','1',3,1,1,'2012-01-03 01:15:04'),(47,47,'MALAYSIA','Selangor','USJ7','Kompleks Sime Darby','3','GCAD','1',3,1,1,'2012-01-03 01:15:04'),(48,48,'MALAYSIA','Selangor','USJ7','Kompleks Sime Darby','3','GCAD','1',3,1,1,'2012-01-03 23:16:48'),(49,49,'MALAYSIA','Selangor','USJ7','Kompleks Sime Darby','3','GCAD','1',3,1,1,'2012-01-03 23:17:42'),(50,50,'MALAYSIA','Selangor','USJ7','Kompleks Sime Darby','3','GCAD','1',3,1,1,'2012-01-03 23:18:31');
/*!40000 ALTER TABLE `location` ENABLE KEYS */;
UNLOCK TABLES;
/*!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 2012-01-04 16:23:11