-- MySQL dump 10.13  Distrib 5.5.16, for Win32 (x86)
--
-- Host: 127.0.0.1    Database: teletrandb
-- ------------------------------------------------------
-- Server version	5.5.52

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

DROP TABLE IF EXISTS `client_testimonial`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `client_testimonial` (
  `testimonialID` int(11) NOT NULL AUTO_INCREMENT,
  `message` text NOT NULL,
  `datecreated` int(11) NOT NULL DEFAULT '0',
  `status` int(11) NOT NULL DEFAULT '0',
  `userID` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`testimonialID`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `client_testimonial`
--

LOCK TABLES `client_testimonial` WRITE;
/*!40000 ALTER TABLE `client_testimonial` DISABLE KEYS */;
INSERT INTO `client_testimonial` VALUES (4,'Telemerge Transcription has provided dictation and transcription services nationally for our group physicians and field consultants for five years and have been excellent business partners. The work product, turnaround time and customer service is excellent and they are always on the lookout for ways to improve their efficiency and to introduce new technology to customers when appropriate and well tested. I am familiar with other groups and companies who also use their services and are quite pleased. I highly recommend Telemerge.',1172306163,2,1);
/*!40000 ALTER TABLE `client_testimonial` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `news`
--

DROP TABLE IF EXISTS `news`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `news` (
  `newsID` int(11) NOT NULL AUTO_INCREMENT,
  `newstitle` varchar(50) NOT NULL DEFAULT '',
  `newsdesc` text NOT NULL,
  `datecreated` int(11) NOT NULL DEFAULT '0',
  `status` int(11) NOT NULL DEFAULT '0',
  `isarchive` int(2) NOT NULL DEFAULT '0',
  PRIMARY KEY (`newsID`)
) ENGINE=MyISAM AUTO_INCREMENT=18 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `news`
--

LOCK TABLES `news` WRITE;
/*!40000 ALTER TABLE `news` DISABLE KEYS */;
INSERT INTO `news` VALUES (1,'Far far away, behind the word mountains','Far far away, behind the word mountains, far from the countries Vokalia and Consonantia, there live the blind texts. Separated they live in Bookmarksgrove right at the coast of the Semantics, a large language ocean. A small river named Duden flows by their place and supplies it with the necessary regelialia. It is a paradisematic country, in which roasted parts of sentences fly into your mouth. ',1175326542,2,0),(2,'Lorem ipsum dolor','Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Donec quam felis, ultricies nec, pellentesque eu, pretium quis, sem. Nulla consequat massa quis enim. Donec pede justo, fringilla vel, aliquet nec, vulputate eget, arcu. In enim justo, rhoncus ut.',1175326542,2,0),(3,'the quick brown fox','The quick, brown fox jumps over a lazy dog. DJs flock by when MTV ax quiz prog. Junk MTV quiz graced by fox whelps. Bawds jog, flick quartz, vex nymphs. Waltz, bad nymph, for quick jigs vex! Fox nymphs grab quick-jived waltz. Brick quiz whangs jumpy veldt fox. ',1175326542,2,0);
/*!40000 ALTER TABLE `news` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `priority`
--

DROP TABLE IF EXISTS `priority`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `priority` (
  `priorityId` int(2) NOT NULL DEFAULT '0',
  `priority` varchar(10) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `priority`
--

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

--
-- Table structure for table `status`
--

DROP TABLE IF EXISTS `status`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `status` (
  `statusID` int(11) NOT NULL AUTO_INCREMENT,
  `status` varchar(50) NOT NULL DEFAULT '',
  PRIMARY KEY (`statusID`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `status`
--

LOCK TABLES `status` WRITE;
/*!40000 ALTER TABLE `status` DISABLE KEYS */;
INSERT INTO `status` VALUES (1,'draft'),(2,'published'),(3,'unpublished');
/*!40000 ALTER TABLE `status` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `testimonial_status`
--

DROP TABLE IF EXISTS `testimonial_status`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `testimonial_status` (
  `statusID` int(11) NOT NULL AUTO_INCREMENT,
  `status` varchar(50) NOT NULL DEFAULT 'unpublished',
  PRIMARY KEY (`statusID`,`status`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `testimonial_status`
--

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

--
-- Table structure for table `transcribedocs`
--

DROP TABLE IF EXISTS `transcribedocs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `transcribedocs` (
  `docID` int(11) NOT NULL AUTO_INCREMENT,
  `uploadID` int(11) NOT NULL DEFAULT '0',
  `docfilename` varchar(50) NOT NULL DEFAULT '',
  PRIMARY KEY (`docID`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `transcribedocs`
--

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

--
-- Table structure for table `uploads`
--

DROP TABLE IF EXISTS `uploads`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `uploads` (
  `uploadID` int(11) NOT NULL AUTO_INCREMENT,
  `userID` int(11) NOT NULL DEFAULT '0',
  `uploadname` varchar(50) NOT NULL DEFAULT '',
  `uploaddesc` varchar(255) NOT NULL DEFAULT '',
  `uploadfilename` varchar(255) NOT NULL DEFAULT '',
  `uploaddate` int(11) NOT NULL DEFAULT '0',
  `priority` int(2) NOT NULL DEFAULT '0',
  PRIMARY KEY (`uploadID`)
) ENGINE=MyISAM AUTO_INCREMENT=25 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `uploads`
--

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

--
-- Table structure for table `useraccount`
--

DROP TABLE IF EXISTS `useraccount`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `useraccount` (
  `userID` int(11) NOT NULL AUTO_INCREMENT,
  `usertypeID` int(11) NOT NULL DEFAULT '0',
  `username` varchar(100) NOT NULL DEFAULT '',
  `password` varchar(255) NOT NULL DEFAULT '',
  `fullname` varchar(100) NOT NULL DEFAULT '',
  `gender` varchar(50) NOT NULL DEFAULT '',
  `company` varchar(100) NOT NULL DEFAULT '',
  `position` varchar(100) NOT NULL DEFAULT '',
  `activationcode` varchar(100) NOT NULL DEFAULT '',
  `status` varchar(50) NOT NULL DEFAULT 'unactivated',
  `address` varchar(50) NOT NULL DEFAULT '',
  `country` varchar(100) NOT NULL DEFAULT '',
  `birthdate` int(11) NOT NULL DEFAULT '0',
  `contactno` varchar(50) NOT NULL DEFAULT '',
  `registerdate` int(11) NOT NULL DEFAULT '0',
  `lastvisitdate` int(11) NOT NULL DEFAULT '0',
  `email` varchar(100) NOT NULL DEFAULT '',
  `affiliation` varchar(200) NOT NULL DEFAULT '',
  PRIMARY KEY (`userID`),
  UNIQUE KEY `username` (`username`)
) ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `useraccount`
--

LOCK TABLES `useraccount` WRITE;
/*!40000 ALTER TABLE `useraccount` DISABLE KEYS */;
INSERT INTO `useraccount` VALUES (1,1,'admin','admin$147','John Donaire','Male','MedCare Offshore','Consultants','','accepted','df ddsf','',0,'11232343',0,0,'kemper108@yahoo.com',''),(14,2,'dodie','dodie','dodie dodie','Male','','hacker','5b6d952030f0060ce612722bde54f357','accepted','ds df ds f','Bosnia and Herzegovina',436338000,'12234',1175410177,1175410330,'arman.ortega@yahoo.com','4thheaven'),(15,3,'mt','mt$123','mt','Male','','janitor','25df5455e03bc86c75068abcee5b48ea','accepted','cebu','Philippines',436428000,'2544741',1175413669,1175413988,'brainwired@gmail.com','4thheaven'),(16,2,'doctora','doctora','doctora yu','Female','','typist','9446105389c4023ccbd2e0a39bcdafcb','accepted','df dsf dsfd f','Philippines',436338000,'2544902',1175605023,1175605187,'arman.ortega@yahoo.com','boom'),(17,2,'rondaniel','rondaniel','ron daniel','Male','','doctor','9d0477a6327ecf9be49f10a2c8989716','accepted','cebu','Philippines',436338000,'2544020',1177748222,1177748663,'arman.ortega@yahoo.com','hippa'),(18,2,'superman','superman','superman','Female','','dancer','84d961568a65073a3bcf0eb216b2a576','accepted','cebu','Philippines',404888400,'123456',1180015798,1180015941,'arman.ortega@yahoo.com','dsfdsf'),(19,3,'mtman','kilong','Michael E. Arnaez','Male','','medical transcriptionist','af074f59ec5bb36d57bb2a7223c92ca7','accepted','J. kabajar street guadalupe, Cebu City','Philippines',412840800,'09194995507',1181480867,0,'www.michaelarnaez@hotmail.com','pacific global'),(20,2,'aldin','151210','aldin diaz','Male','','medical doctor','baea7b6502f3740ffd388d8c9ea094ad','accepted','rwerwerw','United States',410162400,'14124214',1182688169,1182688721,'aldin_cy@yahoo.com','philam');
/*!40000 ALTER TABLE `useraccount` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `usertypes`
--

DROP TABLE IF EXISTS `usertypes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `usertypes` (
  `usertypeID` int(11) NOT NULL AUTO_INCREMENT,
  `usertype_name` varchar(50) NOT NULL DEFAULT '',
  `usertype_desc` varchar(50) NOT NULL DEFAULT '',
  PRIMARY KEY (`usertypeID`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `usertypes`
--

LOCK TABLES `usertypes` WRITE;
/*!40000 ALTER TABLE `usertypes` DISABLE KEYS */;
INSERT INTO `usertypes` VALUES (1,'admin',''),(2,'client',''),(3,'mt','');
/*!40000 ALTER TABLE `usertypes` 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 2017-09-26 22:36:21