· 8 years ago · Sep 29, 2017, 01:08 PM
1-- MySQL dump 10.13 Distrib 5.5.16, for Win32 (x86)
2--
3-- Host: 127.0.0.1 Database: teletrandb
4-- ------------------------------------------------------
5-- Server version 5.5.52
6
7/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10/*!40101 SET NAMES utf8 */;
11/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12/*!40103 SET TIME_ZONE='+00:00' */;
13/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17
18--
19-- Table structure for table `client_testimonial`
20--
21
22DROP TABLE IF EXISTS `client_testimonial`;
23/*!40101 SET @saved_cs_client = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `client_testimonial` (
26 `testimonialID` int(11) NOT NULL AUTO_INCREMENT,
27 `message` text NOT NULL,
28 `datecreated` int(11) NOT NULL DEFAULT '0',
29 `status` int(11) NOT NULL DEFAULT '0',
30 `userID` int(11) NOT NULL DEFAULT '0',
31 PRIMARY KEY (`testimonialID`)
32) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
33/*!40101 SET character_set_client = @saved_cs_client */;
34
35--
36-- Dumping data for table `client_testimonial`
37--
38
39LOCK TABLES `client_testimonial` WRITE;
40/*!40000 ALTER TABLE `client_testimonial` DISABLE KEYS */;
41INSERT 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);
42/*!40000 ALTER TABLE `client_testimonial` ENABLE KEYS */;
43UNLOCK TABLES;
44
45--
46-- Table structure for table `news`
47--
48
49DROP TABLE IF EXISTS `news`;
50/*!40101 SET @saved_cs_client = @@character_set_client */;
51/*!40101 SET character_set_client = utf8 */;
52CREATE TABLE `news` (
53 `newsID` int(11) NOT NULL AUTO_INCREMENT,
54 `newstitle` varchar(50) NOT NULL DEFAULT '',
55 `newsdesc` text NOT NULL,
56 `datecreated` int(11) NOT NULL DEFAULT '0',
57 `status` int(11) NOT NULL DEFAULT '0',
58 `isarchive` int(2) NOT NULL DEFAULT '0',
59 PRIMARY KEY (`newsID`)
60) ENGINE=MyISAM AUTO_INCREMENT=18 DEFAULT CHARSET=latin1;
61/*!40101 SET character_set_client = @saved_cs_client */;
62
63--
64-- Dumping data for table `news`
65--
66
67LOCK TABLES `news` WRITE;
68/*!40000 ALTER TABLE `news` DISABLE KEYS */;
69INSERT 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);
70/*!40000 ALTER TABLE `news` ENABLE KEYS */;
71UNLOCK TABLES;
72
73--
74-- Table structure for table `priority`
75--
76
77DROP TABLE IF EXISTS `priority`;
78/*!40101 SET @saved_cs_client = @@character_set_client */;
79/*!40101 SET character_set_client = utf8 */;
80CREATE TABLE `priority` (
81 `priorityId` int(2) NOT NULL DEFAULT '0',
82 `priority` varchar(10) NOT NULL DEFAULT ''
83) ENGINE=MyISAM DEFAULT CHARSET=latin1;
84/*!40101 SET character_set_client = @saved_cs_client */;
85
86--
87-- Dumping data for table `priority`
88--
89
90LOCK TABLES `priority` WRITE;
91/*!40000 ALTER TABLE `priority` DISABLE KEYS */;
92INSERT INTO `priority` VALUES (1,'normal'),(2,'high');
93/*!40000 ALTER TABLE `priority` ENABLE KEYS */;
94UNLOCK TABLES;
95
96--
97-- Table structure for table `status`
98--
99
100DROP TABLE IF EXISTS `status`;
101/*!40101 SET @saved_cs_client = @@character_set_client */;
102/*!40101 SET character_set_client = utf8 */;
103CREATE TABLE `status` (
104 `statusID` int(11) NOT NULL AUTO_INCREMENT,
105 `status` varchar(50) NOT NULL DEFAULT '',
106 PRIMARY KEY (`statusID`)
107) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
108/*!40101 SET character_set_client = @saved_cs_client */;
109
110--
111-- Dumping data for table `status`
112--
113
114LOCK TABLES `status` WRITE;
115/*!40000 ALTER TABLE `status` DISABLE KEYS */;
116INSERT INTO `status` VALUES (1,'draft'),(2,'published'),(3,'unpublished');
117/*!40000 ALTER TABLE `status` ENABLE KEYS */;
118UNLOCK TABLES;
119
120--
121-- Table structure for table `testimonial_status`
122--
123
124DROP TABLE IF EXISTS `testimonial_status`;
125/*!40101 SET @saved_cs_client = @@character_set_client */;
126/*!40101 SET character_set_client = utf8 */;
127CREATE TABLE `testimonial_status` (
128 `statusID` int(11) NOT NULL AUTO_INCREMENT,
129 `status` varchar(50) NOT NULL DEFAULT 'unpublished',
130 PRIMARY KEY (`statusID`,`status`)
131) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
132/*!40101 SET character_set_client = @saved_cs_client */;
133
134--
135-- Dumping data for table `testimonial_status`
136--
137
138LOCK TABLES `testimonial_status` WRITE;
139/*!40000 ALTER TABLE `testimonial_status` DISABLE KEYS */;
140INSERT INTO `testimonial_status` VALUES (1,'unpublished'),(2,'published');
141/*!40000 ALTER TABLE `testimonial_status` ENABLE KEYS */;
142UNLOCK TABLES;
143
144--
145-- Table structure for table `transcribedocs`
146--
147
148DROP TABLE IF EXISTS `transcribedocs`;
149/*!40101 SET @saved_cs_client = @@character_set_client */;
150/*!40101 SET character_set_client = utf8 */;
151CREATE TABLE `transcribedocs` (
152 `docID` int(11) NOT NULL AUTO_INCREMENT,
153 `uploadID` int(11) NOT NULL DEFAULT '0',
154 `docfilename` varchar(50) NOT NULL DEFAULT '',
155 PRIMARY KEY (`docID`)
156) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;
157/*!40101 SET character_set_client = @saved_cs_client */;
158
159--
160-- Dumping data for table `transcribedocs`
161--
162
163LOCK TABLES `transcribedocs` WRITE;
164/*!40000 ALTER TABLE `transcribedocs` DISABLE KEYS */;
165/*!40000 ALTER TABLE `transcribedocs` ENABLE KEYS */;
166UNLOCK TABLES;
167
168--
169-- Table structure for table `uploads`
170--
171
172DROP TABLE IF EXISTS `uploads`;
173/*!40101 SET @saved_cs_client = @@character_set_client */;
174/*!40101 SET character_set_client = utf8 */;
175CREATE TABLE `uploads` (
176 `uploadID` int(11) NOT NULL AUTO_INCREMENT,
177 `userID` int(11) NOT NULL DEFAULT '0',
178 `uploadname` varchar(50) NOT NULL DEFAULT '',
179 `uploaddesc` varchar(255) NOT NULL DEFAULT '',
180 `uploadfilename` varchar(255) NOT NULL DEFAULT '',
181 `uploaddate` int(11) NOT NULL DEFAULT '0',
182 `priority` int(2) NOT NULL DEFAULT '0',
183 PRIMARY KEY (`uploadID`)
184) ENGINE=MyISAM AUTO_INCREMENT=25 DEFAULT CHARSET=latin1;
185/*!40101 SET character_set_client = @saved_cs_client */;
186
187--
188-- Dumping data for table `uploads`
189--
190
191LOCK TABLES `uploads` WRITE;
192/*!40000 ALTER TABLE `uploads` DISABLE KEYS */;
193/*!40000 ALTER TABLE `uploads` ENABLE KEYS */;
194UNLOCK TABLES;
195
196--
197-- Table structure for table `useraccount`
198--
199
200DROP TABLE IF EXISTS `useraccount`;
201/*!40101 SET @saved_cs_client = @@character_set_client */;
202/*!40101 SET character_set_client = utf8 */;
203CREATE TABLE `useraccount` (
204 `userID` int(11) NOT NULL AUTO_INCREMENT,
205 `usertypeID` int(11) NOT NULL DEFAULT '0',
206 `username` varchar(100) NOT NULL DEFAULT '',
207 `password` varchar(255) NOT NULL DEFAULT '',
208 `fullname` varchar(100) NOT NULL DEFAULT '',
209 `gender` varchar(50) NOT NULL DEFAULT '',
210 `company` varchar(100) NOT NULL DEFAULT '',
211 `position` varchar(100) NOT NULL DEFAULT '',
212 `activationcode` varchar(100) NOT NULL DEFAULT '',
213 `status` varchar(50) NOT NULL DEFAULT 'unactivated',
214 `address` varchar(50) NOT NULL DEFAULT '',
215 `country` varchar(100) NOT NULL DEFAULT '',
216 `birthdate` int(11) NOT NULL DEFAULT '0',
217 `contactno` varchar(50) NOT NULL DEFAULT '',
218 `registerdate` int(11) NOT NULL DEFAULT '0',
219 `lastvisitdate` int(11) NOT NULL DEFAULT '0',
220 `email` varchar(100) NOT NULL DEFAULT '',
221 `affiliation` varchar(200) NOT NULL DEFAULT '',
222 PRIMARY KEY (`userID`),
223 UNIQUE KEY `username` (`username`)
224) ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=latin1;
225/*!40101 SET character_set_client = @saved_cs_client */;
226
227--
228-- Dumping data for table `useraccount`
229--
230
231LOCK TABLES `useraccount` WRITE;
232/*!40000 ALTER TABLE `useraccount` DISABLE KEYS */;
233INSERT 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');
234/*!40000 ALTER TABLE `useraccount` ENABLE KEYS */;
235UNLOCK TABLES;
236
237--
238-- Table structure for table `usertypes`
239--
240
241DROP TABLE IF EXISTS `usertypes`;
242/*!40101 SET @saved_cs_client = @@character_set_client */;
243/*!40101 SET character_set_client = utf8 */;
244CREATE TABLE `usertypes` (
245 `usertypeID` int(11) NOT NULL AUTO_INCREMENT,
246 `usertype_name` varchar(50) NOT NULL DEFAULT '',
247 `usertype_desc` varchar(50) NOT NULL DEFAULT '',
248 PRIMARY KEY (`usertypeID`)
249) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
250/*!40101 SET character_set_client = @saved_cs_client */;
251
252--
253-- Dumping data for table `usertypes`
254--
255
256LOCK TABLES `usertypes` WRITE;
257/*!40000 ALTER TABLE `usertypes` DISABLE KEYS */;
258INSERT INTO `usertypes` VALUES (1,'admin',''),(2,'client',''),(3,'mt','');
259/*!40000 ALTER TABLE `usertypes` ENABLE KEYS */;
260UNLOCK TABLES;
261/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
262
263/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
264/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
265/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
266/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
267/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
268/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
269/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
270
271-- Dump completed on 2017-09-26 22:36:21