-- MySQL dump 10.10
--
-- Host: localhost    Database: ltdb
-- ------------------------------------------------------
-- Server version	5.0.22

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

DROP TABLE IF EXISTS `lt_config`;
CREATE TABLE `lt_config` (
  `lturl` varchar(50) default NULL,
  `ltpp` varchar(50) default NULL,
  `f_name` varchar(50) NOT NULL,
  `l_name` varchar(50) NOT NULL,
  `email` varchar(50) NOT NULL,
  `password` varchar(50) NOT NULL,
  `cid` int(10) unsigned default '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `lt_config`
--


/*!40000 ALTER TABLE `lt_config` DISABLE KEYS */;
LOCK TABLES `lt_config` WRITE;
INSERT INTO `lt_config` VALUES ('http://www.lingotip.net/lti','payments@lingotip.com','e','s','eitan-s@lingotip.com','11',5555);
UNLOCK TABLES;
/*!40000 ALTER TABLE `lt_config` ENABLE KEYS */;

--
-- Table structure for table `lt_dispute`
--

DROP TABLE IF EXISTS `lt_dispute`;
CREATE TABLE `lt_dispute` (
  `txn` int(10) unsigned default NULL,
  `entrydate` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `mode` varchar(10) default NULL,
  `note` text,
  `stat` varchar(10) default 'pending'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `lt_dispute`
--


/*!40000 ALTER TABLE `lt_dispute` DISABLE KEYS */;
LOCK TABLES `lt_dispute` WRITE;
INSERT INTO `lt_dispute` VALUES (78,'2012-06-20 12:26:53','altenate','perfect bla bla','denied'),(5359,'2012-08-15 07:35:10','altenate','perfect1','denied');
UNLOCK TABLES;
/*!40000 ALTER TABLE `lt_dispute` ENABLE KEYS */;

--
-- Table structure for table `lt_estimate`
--

DROP TABLE IF EXISTS `lt_estimate`;
CREATE TABLE `lt_estimate` (
  `price` float(6,2) default NULL,
  `subtotal` varchar(100) default NULL,
  `paid` varchar(20) default NULL,
  `word_count` varchar(20) default NULL,
  `level_id` tinyint(2) default NULL,
  `source` longblob,
  `src_name` varchar(20) default NULL,
  `trg_names` varchar(100) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `lt_estimate`
--


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

--
-- Table structure for table `lt_notes`
--

DROP TABLE IF EXISTS `lt_notes`;
CREATE TABLE `lt_notes` (
  `txn` int(10) unsigned default NULL,
  `entrydate` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `note` text,
  `stat` varchar(10) default 'new',
  `incoming` varchar(2) default '0',
  `is_dispute` varchar(2) default '0',
  `tid` int(10) unsigned default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `lt_notes`
--


/*!40000 ALTER TABLE `lt_notes` DISABLE KEYS */;
LOCK TABLES `lt_notes` WRITE;
INSERT INTO `lt_notes` VALUES (78,'2012-06-20 11:57:51','Translator accepted translation.','new','1','0',135),(78,'2012-06-20 11:59:45','Please pay attention to ...','new','0','0',135),(78,'2012-06-20 12:00:28','No problem','new','1','0',135),(78,'2012-06-20 12:07:19','check CompanyID ----','new','1','0',135),(78,'2012-06-20 12:12:23','CompanyID2 ----','new','1','0',135),(78,'2012-06-20 12:19:15','company-id3 --12345678--','new','1','0',135),(82,'2012-06-21 08:22:33','Translator accepted translation.','new','1','0',135),(82,'2012-06-21 08:23:05','bla bla','new','0','0',135),(82,'2012-06-21 08:23:52','no problem bla bla','new','1','0',135),(143,'2012-08-15 06:45:43','Translator accepted translation.','new','1','0',135),(143,'2012-08-15 06:47:01','question for translator','new','0','0',135),(143,'2012-08-15 06:56:00','answer for customer','new','1','0',135),(5359,'2012-08-15 07:10:08','Translator accepted translation.','new','1','0',135),(5359,'2012-08-15 07:32:13','msg 1','new','0','0',135),(5359,'2012-08-15 07:32:48','reply 1','new','1','0',135);
UNLOCK TABLES;
/*!40000 ALTER TABLE `lt_notes` ENABLE KEYS */;

--
-- Table structure for table `lt_requests`
--

DROP TABLE IF EXISTS `lt_requests`;
CREATE TABLE `lt_requests` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `price` float(6,2) default NULL,
  `paid` varchar(10) default 'no',
  `word_count` varchar(20) default NULL,
  `entrydate` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `note` text,
  `label` text,
  `src_name` varchar(20) default NULL,
  `trg_names` varchar(100) default NULL,
  `txns` varchar(100) default NULL,
  `level_id` tinyint(2) default NULL,
  `source` longblob,
  `pending` timestamp NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `lt_requests`
--


/*!40000 ALTER TABLE `lt_requests` DISABLE KEYS */;
LOCK TABLES `lt_requests` WRITE;
INSERT INTO `lt_requests` VALUES (697,1.00,'yes','5','2012-06-20 11:31:59','','','English','German','78',2,'asdf asdf asdf asdf asdf','2012-06-20 16:23:43'),(698,1.00,'yes','2','2012-06-20 12:41:17','','','English','French','79',2,'2nd job','2012-06-20 16:22:37'),(699,1.00,'no','4','2012-06-20 16:25:02','','','English','Spanish','80',4,'this is a test','0000-00-00 00:00:00'),(702,2.00,'yes','2','2012-06-21 08:17:18','','','English','Arabic,French','81,82',2,'test cid 4477','2012-06-21 08:17:57'),(763,1.00,'no','4','2012-08-14 12:57:30','','','English','French','143',2,'this is a test','0000-00-00 00:00:00'),(667,1.00,'no','4','2012-08-15 07:05:20','','','English','Dutch','5359',2,'testing semi production - zion','0000-00-00 00:00:00'),(668,1.00,'no','4','2012-08-15 08:06:45','','','English','German','5360',2,'test production jr lti','0000-00-00 00:00:00'),(711,1.00,'no','1','2012-11-15 13:46:54','','','English','Arabic','5454',2,'fjfgjhgfjhg','0000-00-00 00:00:00'),(917,2.00,'no','4','2014-10-28 19:27:56','','','English','French,German','299,300',3,'this is a test','0000-00-00 00:00:00'),(918,2.00,'no','2','2014-10-28 19:36:03','','','English','Italian,Spanish','301,302',4,'another test','0000-00-00 00:00:00'),(919,1.00,'no','5','2014-10-28 19:39:32','','','English','Russian','303',2,'sadf asdf asdf adsf asdf','0000-00-00 00:00:00');
UNLOCK TABLES;
/*!40000 ALTER TABLE `lt_requests` ENABLE KEYS */;

--
-- Table structure for table `lt_txn`
--

DROP TABLE IF EXISTS `lt_txn`;
CREATE TABLE `lt_txn` (
  `txn` int(10) unsigned default NULL,
  `code` varchar(10) default '0',
  `status` varchar(20) default 'pending',
  `price` float(6,2) default NULL,
  `paid` varchar(10) default 'no',
  `trg_name` varchar(20) default NULL,
  `target` longblob,
  `dispute` tinyint(2) default '0',
  `feedback` tinyint(2) default '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `lt_txn`
--


/*!40000 ALTER TABLE `lt_txn` DISABLE KEYS */;
LOCK TABLES `lt_txn` WRITE;
INSERT INTO `lt_txn` VALUES (76,'2A45S','pending',1.00,'no','Arabic',NULL,0,0),(77,'H7PRM','pending',1.00,'no','German',NULL,0,0),(78,'E59RQ','done',1.00,'no','German','',0,1),(79,'0JVS8','pending',1.00,'no','French',NULL,0,0),(80,'3CXJO','pending',1.00,'no','Spanish',NULL,0,0),(81,'LDEBX','pending',1.00,'no','Arabic',NULL,0,0),(82,'LDEBX','accept',1.00,'no','French',NULL,0,0),(143,'M3KFG','done',1.00,'no','French','french: this is a test ',0,1),(5359,'RK36Q','done',1.00,'no','Dutch','dutch: testing semi production - zion ',0,1),(5360,'LY6U2','pending',1.00,'no','German',NULL,0,0),(5454,'QOD86','pending',1.00,'no','Arabic',NULL,0,0),(299,'7LM1D','pending',1.00,'no','French',NULL,0,0),(300,'7LM1D','pending',1.00,'no','German',NULL,0,0),(301,'Q4X3C','pending',1.00,'no','Italian',NULL,0,0),(302,'Q4X3C','pending',1.00,'no','Spanish',NULL,0,0),(303,'R1CB2','pending',1.00,'no','Russian',NULL,0,0);
UNLOCK TABLES;
/*!40000 ALTER TABLE `lt_txn` ENABLE KEYS */;
/*!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 */;