/* SQLyog Trial v11.22 (64 bit) MySQL - 5.5.24-log : Database - org ********************************************************************* */ /*!40101 SET NAMES utf8 */; /*!40101 SET SQL_MODE=''*/; /*!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 */; CREATE DATABASE /*!32312 IF NOT EXISTS*/`org` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci */; USE `org`; /*Table structure for table `employee` */ DROP TABLE IF EXISTS `employee`; CREATE TABLE `employee` ( `iddEmployee` int(11) NOT NULL AUTO_INCREMENT, `booEmployeeActive` varchar(1) COLLATE utf8_unicode_ci DEFAULT NULL, `booSystemAdmin` varchar(1) COLLATE utf8_unicode_ci DEFAULT NULL, `booTerminate` varchar(1) COLLATE utf8_unicode_ci DEFAULT NULL, `dteCreated` int(11) DEFAULT NULL, `dteTerminate` int(11) DEFAULT NULL, `dteWorkStart` int(11) DEFAULT NULL, `iddAccount` int(11) DEFAULT NULL, `iddApprover` int(11) DEFAULT NULL, `numGrade` int(11) DEFAULT NULL, `txtCountry` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `txtDepartment` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `txtEmployeeType` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `txtFirstName` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `txtLastName` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `txtLocale` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `txtPassword` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `txtTheme` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `txtWorkEmail` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`iddEmployee`), KEY `iddEmployee` (`iddEmployee`), KEY `iddEmployee_2` (`iddEmployee`) ) ENGINE=InnoDB AUTO_INCREMENT=164 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*Data for the table `employee` */ insert into `employee`(`iddEmployee`,`booEmployeeActive`,`booSystemAdmin`,`booTerminate`,`dteCreated`,`dteTerminate`,`dteWorkStart`,`iddAccount`,`iddApprover`,`numGrade`,`txtCountry`,`txtDepartment`,`txtEmployeeType`,`txtFirstName`,`txtLastName`,`txtLocale`,`txtPassword`,`txtTheme`,`txtWorkEmail`) values (11,'Y','Y','N',1368006202,0,978278400,2,11,3,'Hong Kong','Information Technology','Administrator','David','Chan','en_US','123456789','Original','dkywu@i-cable.com'),(12,'Y','N','N',1368104935,0,1009814400,2,11,2,'Hong Kong','Information Technology','Staff','Dominic ','Chan','en_US','123456789','Modern_Christmas','dominicchan@hong-kong-1.com'),(13,'Y','N','N',1368161680,0,1041350400,2,11,2,'Singapore','Information Technology','Staff','Frankie','Chan','en_US','123456789','Mustang','frankiechan@hong-kong-1.com'),(14,'Y','N','N',1368163091,0,1072886400,2,11,2,'Taiwan','Information Technology','Staff','Judy','Chan','en_US','123456789','Original','judychan@hong-kong-1.com'),(15,'Y','N','N',1368163699,0,1104508800,2,12,1,'Hong Kong','Information Technology','Staff','Eddery','Chan','en_US','123456789','Original','edderychan@hong-kong-1.com'),(16,'Y','N','N',1368188652,0,1136044800,2,12,1,'Hong Kong','Information Technology','Staff','Ken','Chan','en_US','123456789','Original','kenchan@hong-kong-1.com'),(17,'Y','N','N',1368190547,0,1167580800,2,13,1,'Singapore','Information Technology','Staff','Tommy','Chan','en_US','123456789','Original','tommychan@hong-kong-1.com'),(18,'Y','N','N',1368190689,0,1199116800,2,13,1,'Singapore','Information Technology','Staff','Happy','Chan','en_US','123456789','Original','happychan@hong-kong-1.com'),(19,'Y','N','N',1368190797,0,1230739200,2,14,1,'Taiwan','Information Technology','Staff','Teresa','Chan','en_US','123456789','Original','teresachan@hong-kong-1.com'),(20,'Y','N','N',1368190884,0,1262275200,2,14,1,'Taiwan','Information Technology','Staff','Raymond','Chan','en_US','123456789','Original','raymondchan@hong-kong-1.com'),(21,'Y','N','N',1374131787,0,983376000,2,11,3,'Singapore','Finance','Staff','Dennis','Tam','en_US','123456789','Original','dennistam@hong-kong-1.com'),(22,'Y','N','N',1374132881,0,983376000,2,11,1,'Singapore','Finance','Staff','Sharon','Lee','en_US','123456789','Original','sharonlee@hong-kong-1.com'),(23,'Y','N','N',1374133000,0,983376000,2,11,1,'Singapore','Finance','Staff','Shalynn','Tan','en_US','123456789','Original','shalynntan@hong-kong-1.com'),(24,'Y','N','N',1374133089,0,983376000,2,11,1,'Singapore','Finance','Staff','Gerald','Tan','en_US','123456789','Original','geraldtan@hong-kong-1.com'),(25,'Y','N','N',1374133121,0,983376000,2,11,1,'Singapore','Finance','Staff','Connie','Wong','en_US','123456789','Original','conniewong@hong-kong-1.com'),(26,'Y','N','N',1374133159,0,983376000,2,11,1,'Singapore','Finance','Staff','Elvin','Tan','en_US','123456789','Original','elvintan@hong-kong-1.com'),(27,'Y','N','N',1374133192,0,983376000,2,11,1,'Hong Kong','Finance','Staff','Candy','Tseng','en_US','123456789','Original','candytseng@hong-kong-1.com'),(28,'Y','N','N',1374133223,0,983376000,2,11,1,'Singapore','Finance','Staff','Eric','Koh','en_US','123456789','Original','erickoh@hong-kong-1.com'),(29,'Y','N','N',1374133258,0,983376000,2,11,1,'Singapore','Finance','Staff','Swee Mei','Lim','en_US','123456789','Original','sweemeilim@hong-kong-1.com'),(30,'Y','N','N',1374133303,0,983376000,2,11,1,'Singapore','Finance','Staff','Pei','Zhuo','en_US','123456789','Original','peizhuo@hong-kong-1.com'),(31,'Y','N','N',1374133339,0,983376000,2,11,1,'Singapore','Finance','Staff','Germaine','Goh','en_US','123456789','Original','germainegoh@hong-kong-1.com'),(32,'Y','N','N',1374133402,0,983376000,2,11,1,'Singapore','Finance','Staff','Celine','Teo','en_US','123456789','Original','celineteo@hong-kong-1.com'),(33,'Y','N','N',1374133435,0,983376000,2,11,1,'Singapore','Finance','Staff','Andrew','Chua','en_US','123456789','Original','andrewchua@hong-kong-1.com'),(34,'Y','N','N',1374133468,0,983376000,2,11,1,'Singapore','Finance','Staff','Michelle','Yee','en_US','123456789','Original','michelleyee@hong-kong-1.com'),(35,'Y','N','N',1374133528,0,983376000,2,11,1,'Taiwan','Finance','Staff','Rajesh','Mundra','en_US','123456789','Original','rajeshmundra@hong-kong-1.com'),(36,'Y','N','N',1374133559,0,983376000,2,11,1,'Hong Kong','Finance','Staff','Christine','Hu','en_US','123456789','Original','christinehu@hong-kong-1.com'),(37,'Y','N','N',1374134647,0,983376000,2,11,3,'Hong Kong','Marketing Chinese','Staff','Winnie','Chik','en_US','123456789','Original','winniechik@hong-kong-1.com'),(38,'Y','N','N',1374134682,0,983376000,2,11,1,'Taiwan','Marketing Chinese','Staff','Sheila','Yen','en_US','123456789','Original','sheilayen@hong-kong-1.com'),(39,'Y','N','N',1374134722,0,983376000,2,11,1,'Taiwan','Marketing Chinese','Staff','Melody','Yao','en_US','123456789','Original','melodyyao@hong-kong-1.com'),(40,'Y','N','N',1374134754,0,983376000,2,11,1,'Taiwan','Marketing Chinese','Staff','Ivy','Wu','en_US','123456789','Original','ivywu@hong-kong-1.com'),(41,'Y','N','N',1374134783,0,983376000,2,11,1,'Hong Kong','Marketing Chinese','Staff','Christine','Lau','en_US','123456789','Original','christinelau@hong-kong-1.com'),(42,'Y','N','N',1374134813,0,983376000,2,11,1,'Hong Kong','Marketing Chinese','Staff','Jessie','Cheung','en_US','123456789','Original','jessiecheung@hong-kong-1.com'),(43,'Y','N','N',1374134849,0,983376000,2,11,1,'Hong Kong','Marketing Chinese','Staff','Ronald','Sum','en_US','123456789','Original','ronaldsum@hong-kong-1.com'),(44,'Y','N','N',1374134875,0,983376000,2,11,1,'Hong Kong','Marketing Chinese','Staff','Mirror','Fung','en_US','123456789','Original','mirrorfung@hong-kong-1.com'),(45,'Y','N','N',1374134921,0,983376000,2,11,1,'Hong Kong','Marketing Chinese','Staff','Renaie','Ng','en_US','123456789','Original','renaieng@hong-kong-1.com'),(46,'Y','N','N',1374134968,0,983376000,2,11,1,'Hong Kong','Marketing Chinese','Staff','Sam','Hui','en_US','123456789','Original','samhui@hong-kong-1.com'),(47,'Y','N','N',1374135014,0,983376000,2,11,1,'Hong Kong','Marketing Chinese','Staff','Candy','Chan','en_US','123456789','Original','candychan@hong-kong-1.com'),(48,'Y','N','N',1374135048,0,983376000,2,11,1,'Hong Kong','Marketing Chinese','Staff','Kenneth','So','en_US','123456789','Original','kennethso@hong-kong-1.com'),(49,'Y','N','N',1374141640,0,983376000,2,11,3,'Singapore','Advertising','Staff','Gwen','Loong','en_US','123456789','Original','gwenloong@hong-kong-1.com'),(50,'Y','N','N',1374141672,0,983376000,2,11,1,'Singapore','Advertising','Staff','Christina','Chia','en_US','123456789','Original','christinachia@hong-kong-1.com'),(51,'Y','N','N',1374141713,0,983376000,2,11,1,'Hong Kong','Advertising','Staff','Jessica','Tam','en_US','123456789','Original','jessicatam@hong-kong-1.com'),(52,'Y','N','N',1374141744,0,983376000,2,11,1,'Hong Kong','Advertising','Staff','Karen','Chan','en_US','123456789','Original','karenchan@hong-kong-1.com'),(53,'Y','N','N',1374141777,0,983376000,2,11,1,'Singapore','Advertising','Staff','Roslina','Majid','en_US','123456789','Original','roslinamajid@hong-kong-1.com'),(54,'Y','N','N',1374141807,0,983376000,2,11,1,'Singapore','Advertising','Staff','Alfredo','Fernandez','en_US','123456789','Original','alfredofernandez@hong-kong-1.com'),(55,'Y','N','N',1374141838,0,983376000,2,11,1,'Singapore','Advertising','Staff','Irene','Chua','en_US','123456789','Original','irenechua@hong-kong-1.com'),(56,'Y','N','N',1374141867,0,983376000,2,11,1,'Singapore','Advertising','Staff','Majdiah','Maarof','en_US','123456789','Original','majdiahmaarof@hong-kong-1.com'),(57,'Y','N','N',1374141896,0,983376000,2,11,1,'Singapore','Advertising','Staff','Stephanie','Tok','en_US','123456789','Original','stephanietok@hong-kong-1.com'),(58,'Y','N','N',1374141925,0,983376000,2,11,1,'Hong Kong','Advertising','Staff','Jo Jo','Li','en_US','123456789','Original','jojoli@hong-kong-1.com'),(59,'Y','N','N',1374141953,0,983376000,2,11,1,'Hong Kong','Advertising','Staff','Spenser','Yip','en_US','123456789','Original','spenseryip@hong-kong-1.com'),(60,'Y','N','N',1374141984,0,983376000,2,11,1,'Singapore','Advertising','Staff','Gloria','Leung','en_US','123456789','Original','glorialeung@hong-kong-1.com'),(61,'Y','N','N',1374142011,0,983376000,2,11,1,'Hong Kong','Advertising','Staff','Rita','Tseng','en_US','123456789','Original','ritatseng@hong-kong-1.com'),(62,'Y','N','N',1374142043,0,983376000,2,11,1,'Taiwan','Advertising','Staff','Andrew','Tsao','en_US','123456789','Original','andrewtsao@hong-kong-1.com'),(63,'Y','N','N',1374142074,0,983376000,2,11,1,'Taiwan','Advertising','Staff','Hsuan','Wang','en_US','123456789','Original','hsuanwang@hong-kong-1.com'),(64,'Y','N','N',1374219312,0,983376000,2,11,2,'Hong Kong','Production','Staff','Wilson','Wan','en_US','123456789','Original','wilsonwan@hong-kong-1.com'),(65,'Y','N','N',1374219343,0,983376000,2,11,1,'Hong Kong','Production','Staff','Julia','Ng','en_US','123456789','Original','juliang@hong-kong-1.com'),(66,'Y','N','N',1374219375,0,983376000,2,11,1,'Singapore','Production','Staff','Ling Ling','Lim','en_US','123456789','Original','linglinglim@hong-kong-1.com'),(67,'Y','N','N',1374219405,0,983376000,2,11,1,'India','Production','Staff','Sandeep','Padoshi','en_US','123456789','Original','sandeeppadoshi@hong-kong-1.com'),(68,'Y','N','N',1374219435,0,983376000,2,11,1,'India','Production','Staff','Vinod','Desai','en_US','123456789','Original','vinoddesai@hong-kong-1.com'),(69,'Y','N','N',1374219470,0,983376000,2,11,1,'India','Production','Staff','Tarun','Bansai','en_US','123456789','Original','tarunbansai@hong-kong-1.com'),(70,'Y','N','N',1374219502,0,983376000,2,11,1,'India','Production','Staff','Chandan','Thakur','en_US','123456789','Original','chandanthakur@hong-kong-1.com'),(71,'Y','N','N',1374219535,0,983376000,2,11,1,'India','Production','Staff','Majid','Shaikh','en_US','123456789','Original','majidshaikh@hong-kong-1.com'),(72,'Y','N','N',1374219563,0,983376000,2,11,1,'Singapore','Production','Staff','Nju','Huat','en_US','123456789','Original','njuhuat@hong-kong-1.com'),(73,'Y','N','N',1374219594,0,983376000,2,11,1,'Singapore','Production','Staff','Elliot','Tham','en_US','123456789','Original','elliottham@hong-kong-1.com'),(74,'Y','N','N',1374219641,0,983376000,2,11,1,'Singapore','Production','Staff','William','Sim','en_US','123456789','Original','williamsim@hong-kong-1.com'),(75,'Y','N','N',1374219678,0,983376000,2,11,1,'Singapore','Production','Staff','Frederick','Lee','en_US','123456789','Original','fredericklee@hong-kong-1.com'),(76,'Y','N','N',1374219708,0,983376000,2,11,1,'India','Production','Staff','Cathy','Joy','en_US','123456789','Original','cathyjoy@hong-kong-1.com'),(77,'Y','N','N',1374219736,0,983376000,2,11,1,'India','Production','Staff','Sunil','Balan','en_US','123456789','Original','sunilbalan@hong-kong-1.com'),(78,'Y','N','N',1374221396,0,983376000,2,11,1,'Thailand','Advertising','Staff','Somnuk','Sukthipkongka','en_US','123456789','Original','somnuksukthipkongka@hong-kong-1.com'),(79,'Y','N','N',1374221484,0,983376000,2,11,1,'Japan','Advertising','Staff','Kaji','Kageyama','en_US','123456789','Original','kajikageyama@hong-kong-1.com'),(80,'Y','N','N',1374221512,0,983376000,2,11,1,'Japan','Advertising','Staff','Hiroshi','Kaneko','en_US','123456789','Original','hiroshikaneko@hong-kong-1.com'),(81,'Y','N','N',1374221540,0,983376000,2,11,1,'Japan','Advertising','Staff','Kumiko','Tanaka','en_US','123456789','Original','kumikotanaka@hong-kong-1.com'),(82,'Y','N','N',1374221576,0,983376000,2,11,1,'Japan','Advertising','Staff','Manami','Takeda','en_US','123456789','Original','manamitakeda@hong-kong-1.com'),(83,'Y','N','N',1374221603,0,983376000,2,11,1,'Japan','Advertising','Staff','Junko','Hosokawa','en_US','123456789','Original','junkohosokawa@hong-kong-1.com'),(84,'Y','N','N',1374221631,0,983376000,2,11,1,'Japan','Advertising','Staff','Mieko','Tezuka','en_US','123456789','Original','miekotezuka@hong-kong-1.com'),(85,'Y','N','N',1374221674,0,983376000,2,11,1,'Singapore','Creative','Staff','Benjamin','Soh','en_US','123456789','Original','benjaminsoh@hong-kong-1.com'),(86,'Y','N','N',1374221703,0,983376000,2,11,1,'Singapore','Creative','Staff','Mohamad','Rosle','en_US','123456789','Original','mohamadrosle@hong-kong-1.com'),(87,'Y','N','N',1374221731,0,983376000,2,11,1,'Thailand','Creative','Staff','Sirote','Santipattanachai','en_US','123456789','Original','sirotesantipattanachai@hong-kong-1.com'),(88,'Y','N','N',1374221761,0,983376000,2,11,1,'Singapore','Creative','Staff','Ashraf','Aris','en_US','123456789','Original','ashrafaris@hong-kong-1.com'),(89,'Y','N','N',1374221790,0,983376000,2,11,1,'Singapore','Creative','Staff','Gasthoori','Manickam','en_US','123456789','Original','gasthoorimanickam@hong-kong-1.com'),(90,'Y','N','N',1374221818,0,983376000,2,11,1,'Singapore','Creative','Staff','Rufus','Lim','en_US','123456789','Original','rufuslim@hong-kong-1.com'),(91,'Y','N','N',1374221846,0,983376000,2,11,1,'Singapore','Creative','Staff','Nur','Azmin','en_US','123456789','Original','nurazmin@hong-kong-1.com'),(92,'Y','N','N',1374221881,0,983376000,2,11,2,'Singapore','Creative','Staff','Mastika','Ya\'caob','en_US','123456789','Original','mastikayacaob@hong-kong-1.com'),(93,'Y','N','N',1374221910,0,983376000,2,11,1,'Singapore','Creative','Staff','Tanty','Idrus','en_US','123456789','Original','tantyidrus@hong-kong-1.com'),(94,'Y','N','N',1374221939,0,983376000,2,11,1,'Singapore','Creative','Staff','Haryana','Jaafar','en_US','123456789','Original','haryanajaafar@hong-kong-1.com'),(95,'Y','N','N',1374221969,0,983376000,2,11,1,'Singapore','Creative','Staff','Christine','Chng','en_US','123456789','Original','christinechng@hong-kong-1.com'),(96,'Y','N','N',1374222044,0,983376000,2,11,2,'Singapore','Customer Services','Staff','Ser Ing','Ting','en_US','123456789','Original','seringting@hong-kong-1.com'),(97,'Y','N','N',1374222073,0,983376000,2,11,1,'Singapore','Customer Services','Staff','Jennifer','Yew','en_US','123456789','Original','jenniferyew@hong-kong-1.com'),(98,'Y','N','N',1374222101,0,983376000,2,11,1,'Singapore','Customer Services','Staff','Heather','Chng','en_US','123456789','Original','heatherchng@hong-kong-1.com'),(99,'Y','N','N',1374222133,0,983376000,2,11,1,'Singapore','Customer Services','Staff','Lay Hui','Tan','en_US','123456789','Original','layhuitan@hong-kong-1.com'),(100,'Y','N','N',1374222165,0,983376000,2,11,1,'Singapore','Customer Services','Staff','Bee Hon','Lee','en_US','123456789','Original','beehonlee@hong-kong-1.com'),(101,'Y','N','N',1374222194,0,983376000,2,11,1,'Singapore','Customer Services','Staff','Jesling','Toh','en_US','123456789','Original','jeslingtoh@hong-kong-1.com'),(102,'Y','N','N',1374222222,0,983376000,2,11,1,'Singapore','Customer Services','Staff','Syamsul','Hassan','en_US','123456789','Original','syamsulhassan@hong-kong-1.com'),(103,'Y','N','N',1374222252,0,983376000,2,11,1,'Thailand','Customer Services','Staff','Sutisa','Ungumporn','en_US','123456789','Original','sutisaungumporn@hong-kong-1.com'),(104,'Y','N','N',1374222283,0,983376000,2,11,1,'Singapore','Customer Services','Staff','Choot Hiong','Loh','en_US','123456789','Original','choothiongloh@hong-kong-1.com'),(105,'Y','N','N',1374222312,0,983376000,2,11,1,'Singapore','Customer Services','Staff','Rachel','Ang','en_US','123456789','Original','rachelang@hong-kong-1.com'),(106,'Y','N','N',1374222340,0,983376000,2,11,1,'Singapore','Customer Services','Staff','Yvonne','Lai','en_US','123456789','Original','yvonnelai@hong-kong-1.com'),(107,'Y','N','N',1374222368,0,983376000,2,11,1,'Singapore','Customer Services','Staff','Lily','Chia','en_US','123456789','Original','lilychia@hong-kong-1.com'),(108,'Y','N','N',1374223751,0,983376000,2,11,1,'Hong Kong','Database Marketing','Staff','Cecilia','Fung','en_US','123456789','Original','ceciliafung@hong-kong-1.com'),(109,'Y','N','N',1374223779,0,983376000,2,11,1,'Hong Kong','Database Marketing','Staff','Helen','Yip','en_US','123456789','Original','helenyip@hong-kong-1.com'),(110,'Y','N','N',1374223811,0,983376000,2,11,3,'Taiwan','Editorial Chinese','Staff','Raycine','Chang','en_US','123456789','Original','raycinechang@hong-kong-1.com'),(111,'Y','N','N',1374223839,0,983376000,2,11,1,'Hong Kong','Editorial Chinese','Staff','Raymond','Tai','en_US','123456789','Original','raymondtai@hong-kong-1.com'),(112,'Y','N','N',1374223867,0,983376000,2,11,1,'Hong Kong','Editorial Chinese','Staff','Jennette','Lau','en_US','123456789','Original','jennettelau@hong-kong-1.com'),(113,'Y','N','N',1374223895,0,983376000,2,11,1,'Hong Kong','Editorial Chinese','Staff','Cecilia','Wang','en_US','123456789','Original','ceciliawang@hong-kong-1.com'),(114,'Y','N','N',1374223923,0,983376000,2,11,3,'Singapore','Editorial English','Staff','Dora','Cheok','en_US','123456789','Original','doracheok@hong-kong-1.com'),(115,'Y','N','N',1374223951,0,983376000,2,11,1,'Singapore','Editorial English','Staff','Sifi','Rohani','en_US','123456789','Original','sifirohani@hong-kong-1.com'),(116,'Y','N','N',1374223977,0,983376000,2,11,1,'Singapore','Editorial English','Staff','Debbie','Lau','en_US','123456789','Original','debbielau@hong-kong-1.com'),(117,'Y','N','N',1374224004,0,983376000,2,11,1,'Singapore','Editorial English','Staff','Shawn','Pang','en_US','123456789','Original','shawnpang@hong-kong-1.com'),(118,'Y','N','N',1374224031,0,983376000,2,11,1,'Singapore','Editorial English','Staff','Joyce','Sim','en_US','123456789','Original','joycesim@hong-kong-1.com'),(119,'Y','N','N',1374224060,0,983376000,2,11,1,'Singapore','Editorial English','Staff','David','Ross','en_US','123456789','Original','davidross@hong-kong-1.com'),(120,'Y','N','N',1374224094,0,983376000,2,11,1,'Singapore','Editorial English','Staff','Nurul','Aini','en_US','123456789','Original','nurulaini@hong-kong-1.com'),(121,'Y','N','N',1374224132,0,983376000,2,11,3,'Thailand','Editorial Thai','Staff','Kaidsuda','Suriyayos','en_US','123456789','Original','kaidsudasuriyayos@hong-kong-1.com'),(122,'Y','N','N',1374224162,0,983376000,2,11,1,'Thailand','Editorial Thai','Staff','Jittima','Sirikajorn','en_US','123456789','Original','jittimasirikajorn@hong-kong-1.com'),(123,'Y','N','N',1374224193,0,983376000,2,11,1,'Thailand','Editorial Thai','Staff','Pakapak','Pukkalanun','en_US','123456789','Original','pakapakpukkalanun@hong-kong-1.com'),(124,'Y','N','N',1374225200,0,983376000,2,11,2,'Hong Kong','Human Resources','Staff','Doreen','Chan','en_US','123456789','Original','doreenchan@hong-kong-1.com'),(125,'Y','N','N',1374225232,0,983376000,2,11,1,'Singapore','Information Technology','Staff','Yew Jin','Ong','en_US','123456789','Original','yewjinong@hong-kong-1.com'),(126,'Y','N','N',1374225261,0,983376000,2,11,1,'Singapore','Information Technology','Staff','Robert','Huynh','en_US','123456789','Original','roberthuynh@hong-kong-1.com'),(127,'Y','N','N',1374225290,0,983376000,2,11,3,'Singapore','MD Office','Staff','Andrea','Martin','en_US','123456789','Original','andreamartin@hong-kong-1.com'),(128,'Y','N','N',1374225323,0,983376000,2,11,1,'Singapore','MD Office','Staff','Anna','Tiau','en_US','123456789','Original','annatiau@hong-kong-1.com'),(129,'Y','N','N',1374229505,0,983376000,2,11,3,'Singapore','Marketing English','Staff','Eric','Lanoe','en_US','123456789','Original','ericlanoe@hong-kong-1.com'),(130,'Y','N','N',1374229534,0,983376000,2,11,1,'Singapore','Marketing English','Staff','Sharon','Low','en_US','123456789','Original','sharonlow@hong-kong-1.com'),(131,'Y','N','N',1374229563,0,983376000,2,11,1,'Singapore','Marketing English','Staff','Jenny','Lee','en_US','123456789','Original','jennylee@hong-kong-1.com'),(132,'Y','N','N',1374229595,0,983376000,2,11,1,'Singapore','Marketing English','Staff','Fern','Wong','en_US','123456789','Original','fernwong@hong-kong-1.com'),(133,'Y','N','N',1374229624,0,983376000,2,11,1,'Singapore','Marketing English','Staff','Eunice','Soo','en_US','123456789','Original','eunicesoo@hong-kong-1.com'),(134,'Y','N','N',1374229655,0,983376000,2,11,1,'Singapore','Marketing English','Staff','Diane','Curry','en_US','123456789','Original','dianecurry@hong-kong-1.com'),(135,'Y','N','N',1374229696,0,983376000,2,11,1,'Singapore','Marketing English','Staff','Denise','Ho','en_US','123456789','Original','deniseho@hong-kong-1.com'),(136,'Y','N','N',1374229735,0,983376000,2,11,1,'Singapore','Marketing English','Staff','Mei Yen','Cheong','en_US','123456789','Original','meiyencheong@hong-kong-1.com'),(137,'Y','N','N',1374229768,0,983376000,2,11,1,'Singapore','Marketing English','Staff','Sophie','Spoor','en_US','123456789','Original','sophiespoor@hong-kong-1.com'),(138,'Y','N','N',1374229796,0,983376000,2,11,1,'Singapore','Marketing English','Staff','Lisa','Low','en_US','123456789','Original','lisalow@hong-kong-1.com'),(139,'Y','N','N',1374230239,0,983376000,2,11,1,'Singapore','Marketing English','Staff','Akansha','Gupta','en_US','123456789','Original','akanshagupta@hong-kong-1.com'),(140,'Y','N','N',1374230497,0,983376000,2,11,1,'Singapore','Marketing English','Staff','Gracinia','Lim','en_US','123456789','Original','gracinialim@hong-kong-1.com'),(141,'Y','N','N',1374230525,0,983376000,2,11,1,'Singapore','Marketing English','Staff','Vincent','Ho','en_US','123456789','Original','vincentho@hong-kong-1.com'),(142,'Y','N','N',1374230555,0,983376000,2,11,1,'Singapore','Marketing English','Staff','Jasmine','Ong','en_US','123456789','Original','jasmineong@hong-kong-1.com'),(143,'Y','N','N',1374230587,0,983376000,2,11,1,'Singapore','Marketing English','Staff','Sandra','Bralsford','en_US','123456789','Original','sandrabralsford@hong-kong-1.com'),(144,'Y','N','N',1374230618,0,983376000,2,11,1,'Singapore','Marketing English','Staff','Edmund','Ng','en_US','123456789','Original','edmundng@hong-kong-1.com'),(145,'Y','N','N',1374230646,0,983376000,2,11,1,'Singapore','Marketing English','Staff','Kumal','Ozarde','en_US','123456789','Original','kumalozarde@hong-kong-1.com'),(146,'Y','N','N',1374230959,0,983376000,2,11,2,'Hong Kong','Database Marketing','Staff','Pini','Wan','en_US','123456789','Original','piniwan@hong-kong-1.com'),(147,'Y','N','N',1374230988,0,983376000,2,11,1,'Thailand','Marketing English','Staff','Thankia','Jearanaiphaisan','en_US','123456789','Original','thankiajearanaiphaisan@hong-kong-1.com'),(148,'Y','N','N',1374231026,0,983376000,2,11,1,'Thailand','Marketing English','Staff','Anchalee','Limcharoenrat','en_US','123456789','Original','anchaleelimcharoenrat@hong-kong-1.com'),(149,'Y','N','N',1374231054,0,983376000,2,11,1,'Thailand','Marketing English','Staff','Sunee','Thanalertkul','en_US','123456789','Original','suneethanalertkul@hong-kong-1.com'),(150,'Y','N','N',1374231081,0,983376000,2,11,1,'Thailand','Marketing English','Staff','Chuleeporn','Wiriyawongchai','en_US','123456789','Original','chuleepornwiriyawongchai@hong-kong-1.com'),(151,'Y','N','N',1374231110,0,983376000,2,11,1,'Thailand','Marketing English','Staff','Mevita','Wongwichianchai','en_US','123456789','Original','mevitawongwichianchai@hong-kong-1.com'),(152,'Y','N','N',1374231139,0,983376000,2,11,1,'Thailand','Marketing English','Staff','Uthaiwan','Wisutthakul','en_US','123456789','Original','uthaiwanwisutthakul@hong-kong-1.com'),(153,'Y','N','N',1374231170,0,983376000,2,11,1,'Thailand','Marketing English','Staff','Chatchawan','Virojsakseri','en_US','123456789','Original','chatchawanvirojsakseri@hong-kong-1.com'),(154,'Y','N','N',1374231203,0,983376000,2,11,1,'Thailand','Marketing English','Staff','Mingmanee','Kanchanajiva','en_US','123456789','Original','mingmaneekanchanajiva@hong-kong-1.com'),(155,'Y','N','N',1374231362,0,983376000,2,11,1,'India','Marketing English','Staff','Priya','Gandhi','en_US','123456789','Original','priyagandhi@hong-kong-1.com'),(156,'Y','N','N',1374231391,0,983376000,2,11,1,'India','Marketing English','Staff','Peter','Banerjee','en_US','123456789','Original','peterbanerjee@hong-kong-1.com'),(157,'Y','N','N',1374810873,0,983376000,2,11,3,'Hong Kong','Marketing Chinese','Staff','Gregory','Yim','en_US','123456789','Original','gregoryyim@hong-kong-1.com'),(158,'Y','Y','N',1376555380,0,978278400,3,158,0,'Hong Kong','Information Technology','Administrator','David','Lee','en_US','123456789','Mustang','dkywu1@netvigator.com'),(159,'Y','N','N',1376563066,0,980956800,3,158,0,'Hong Kong','Information Technology','Staff','鄧','冠珠','en_US','123456789','London_Underground','dominiclee@hong-kong-1.com'),(160,'Y','N','N',1376563239,0,983376000,3,158,0,'Hong Kong','Information Technology','Staff','Frankie','Lee','en_US','123456789','Original','frankielee@hong-kong-1.com'),(161,'Y','N','N',1376563574,0,986054400,3,158,0,'Hong Kong','Information Technology','Staff','Judy','Lee','en_US','123456789','Original','judylee@hong-kong-1.com'),(162,'Y','N','N',1376824891,0,988646400,3,159,0,'Hong Kong','Information Technology','Staff','Eddery','Lee','en_US','123456789','Original','edderylee@hong-kong-1.com'),(163,'Y','N','N',1376912482,0,991324800,3,159,0,'Hong Kong','Information Technology','Staff','Ken','Lee','en_US','123456789','Original','kenlee@hong-kong-1.com'); /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;