-- MySQL dump 10.12
--
-- Host: localhost Database: sms_corpus
-- ------------------------------------------------------
-- Server version 6.0.0-alpha-community-nt-debug
/*!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 `new_sms_download_zh`
--
DROP TABLE IF EXISTS `new_sms_download_zh`;
CREATE TABLE `new_sms_download_zh` (
`sender` varchar(200) NOT NULL DEFAULT 'unknown',
`receiver` varchar(200) DEFAULT 'unknown',
`send_time` varchar(50) DEFAULT 'unknown',
`collect_time` varchar(50) NOT NULL DEFAULT 'unknown',
`collect_method` varchar(200) DEFAULT 'unknown' COMMENT 'SMS Export, SMS Upload, Web-based Transcription',
`content` text NOT NULL,
`native` varchar(10) DEFAULT 'unknown' COMMENT 'Native speaker',
`country` varchar(50) DEFAULT 'unknown' COMMENT 'Where is the donator from',
`age` varchar(20) DEFAULT 'unknown',
`input_method` varchar(50) DEFAULT 'unknown',
`experience` varchar(50) DEFAULT 'unknown' COMMENT 'Years of using sms',
`frequency` varchar(50) DEFAULT 'unknown' COMMENT '# of SMS sent daily',
`phone_model` varchar(100) DEFAULT 'unknown',
`collector` varchar(50) DEFAULT 'unknown',
`gender` varchar(10) DEFAULT 'unkown',
`smartphone` varchar(10) DEFAULT 'unkown',
`lang` varchar(10) NOT NULL DEFAULT 'zh',
`city` varchar(45) DEFAULT 'unknown',
`id` int(10) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `new_sms_download_zh`
--
LOCK TABLES `new_sms_download_zh` WRITE;
/*!40000 ALTER TABLE `new_sms_download_zh` DISABLE KEYS */;
INSERT INTO `new_sms_download_zh` VALUES ('06bb204a4e5da882f6d1d28340cd62ec','unknown','unknown','2010/11','Web-based Transcription','老師,媽咪話想買盒月餅比你,你要傳統定冰皮?','yes','unknown','unknown','Bihua','5 to 10 years','Less than 1 SMS daily','Sony Ericsson','Tao Chen','unknown','unknown','zh','unknown',1),('06bb204a4e5da882f6d1d28340cd62ec','unknown','unknown','2010/11','Web-based Transcription','你幾時返黎教我填份表?我過幾日就要走喇!','yes','unknown','unknown','Bihua','5 to 10 years','Less than 1 SMS daily','Sony Ericsson','Tao Chen','unknown','unknown','zh','unknown',2),('86d1672e124b86e55b5bd5e535991406','unknown','unknown','2010/11','Web-based Transcription','今晚肥不肥家吃饭 如果要 提前半小时跟我缩一下','yes','unknown','unknown','Pinyin','2 to 3 years','2 to 5 SMS daily','Apple iPhone','Tao Chen','unknown','unknown','zh','unknown',3),('86d1672e124b86e55b5bd5e535991406','unknown','unknown','2010/11','Web-based Transcription','周六要通宵打麻将 带点吃的喝的来','yes','unknown','unknown','Pinyin','2 to 3 years','2 to 5 SMS daily','Apple iPhone','Tao Chen','unknown','unknown','zh','unknown',4),('5f2f98baf1b726ecff98f55845ad0285','unknown','unknown','2010/11','Web-based Transcription','我正在休息。明天有考试','no','unknown','unknown','Other','Less than 1 year','2 to 5 SMS daily','Nokia','Tao Chen','unknown','unknown','zh','unknown',5),('5f2f98baf1b726ecff98f55845ad0285','unknown','unknown','2010/11','Web-based Transcription','你在干嘛啦？','no','unknown','unknown','Other','Less than 1 year','2 to 5 SMS daily','Nokia','Tao Chen','unknown','unknown','zh','unknown',6),('52e631aaaf3957f1c5a433a48e4564db','unknown','unknown','2010/11','Web-based Transcription','哭死了，你看我的中金黄金。。。只想骂一句，交锤子个罚款。。。','yes','unknown','unknown','Pinyin','5 to 10 years','5 to 10 SMS daily','HTC','Tao Chen','unknown','unknown','zh','unknown',7),('52e631aaaf3957f1c5a433a48e4564db','unknown','unknown','2010/11','Web-based Transcription','那你回来问问其他同学，就业办已经添加了，进去看看','yes','unknown','unknown','Pinyin','5 to 10 years','5 to 10 SMS daily','HTC','Tao Chen','unknown','unknown','zh','unknown',8),('9771ec180b1e688f836739a155fc0754','unknown','unknown','2010/11','Web-based Transcription','亲爱的，我还在加班，你自己先吃吧，爱你','yes','unknown','unknown','Pinyin','5 to 10 years','More than 10 SMS daily','Nokia','Tao Chen','unknown','unknown','zh','unknown',9),('9771ec180b1e688f836739a155fc0754','unknown','unknown','2010/11','Web-based Transcription','老公，加油！回来的时候路上小心哦，等你','yes','unknown','unknown','Pinyin','5 to 10 years','More than 10 SMS daily','Nokia','Tao Chen','unknown','unknown','zh','unknown',10),('44c87f3c44c35ca05731157bd01b877b','unknown','unknown','2010/11','Web-based Transcription','北鼻早安，又是一個禮拜的開始，愛你','yes','unknown','unknown','Other','5 to 10 years','1 to 2 SMS daily','Sony Ericsson','Tao Chen','unknown','unknown','zh','unknown',11),('44c87f3c44c35ca05731157bd01b877b','unknown','unknown','2010/11','Web-based Transcription','安琪哈比明天回來你早點回家讀點書準備考試媽咪上','yes','unknown','unknown','Other','5 to 10 years','1 to 2 SMS daily','Sony Ericsson','Tao Chen','unknown','unknown','zh','unknown',12),('5375816dfa056630c2e60686f2b5e603','unknown','unknown','2010/11','Web-based Transcription','老婆，你到机场没有？我准备九点出发去国际机场接机。','yes','unknown','26-30','Pinyin','5 to 10 years','5 to 10 SMS daily','Blackberry','Tao Chen','unknown','unknown','zh','unknown',13),('5375816dfa056630c2e60686f2b5e603','unknown','unknown','2010/11','Web-based Transcription','我已经到机场了，她的飞机还有一个多小时到。','yes','unknown','26-30','Pinyin','5 to 10 years','5 to 10 SMS daily','Blackberry','Tao Chen','unknown','unknown','zh','unknown',14),('2524569ce324037bf623a0209f6e5534','unknown','unknown','2010/11','Web-based Transcription','张，今晚6点看球，老地方见','yes','unknown','unknown','Pinyin','Less than 1 year','Less than 1 SMS daily','Nokia','Tao Chen','unknown','unknown','zh','unknown',15),('2524569ce324037bf623a0209f6e5534','unknown','unknown','2010/11','Web-based Transcription','猛然觉得，Inception的主题，中文一个词早就说尽了─浮生若梦','yes','unknown','unknown','Pinyin','Less than 1 year','Less than 1 SMS daily','Nokia','Tao Chen','unknown','unknown','zh','unknown',16),('6bb1126b6d1ef21cec19cc05b6c2e32a','unknown','unknown','2010/11','Web-based Transcription','国庆节回家吗？要不咱一块坐火车，我到你学校找你？','yes','unknown','unknown','Pinyin','3 to 5 years','Less than 1 SMS daily','Nokia','Tao Chen','unknown','unknown','zh','unknown',17),('6bb1126b6d1ef21cec19cc05b6c2e32a','unknown','unknown','2010/11','Web-based Transcription','那天咱一块吃饭时坐你旁边的那个女生有男朋友吗？','yes','unknown','unknown','Pinyin','3 to 5 years','Less than 1 SMS daily','Nokia','Tao Chen','unknown','unknown','zh','unknown',18),('45fbb22d25b270319423dedf95d66a41','unknown','unknown','2010/11','Web-based Transcription','我们今天晚上不然切去披萨嘛，我好饿哦~~:(','yes','unknown','unknown','Pinyin','5 to 10 years','More than 10 SMS daily','Nokia','Tao Chen','unknown','unknown','zh','unknown',19),('45fbb22d25b270319423dedf95d66a41','unknown','unknown','2010/11','Web-based Transcription','啊~~~你在干什么呀? 我刚下班，累得要死，腿要断了','yes','unknown','unknown','Pinyin','5 to 10 years','More than 10 SMS daily','Nokia','Tao Chen','unknown','unknown','zh','unknown',20),('d6a47961
