-- MySQL dump 10.10
--
-- Host: localhost    Database: carrentalsystem
-- ------------------------------------------------------
-- Server version	5.0.17-nt

/*!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 */;

--
-- Current Database: `carrentalsystem`
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `carrentalsystem` /*!40100 DEFAULT CHARACTER SET utf8 */;

USE `carrentalsystem`;

--
-- Table structure for table `admin`
--

DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin` (
  `USER_NAME` varchar(60) NOT NULL,
  `NAME` varchar(30) NOT NULL,
  `ID` varchar(30) NOT NULL,
  `ADMIN_ID` varchar(30) NOT NULL,
  PRIMARY KEY  (`USER_NAME`),
  CONSTRAINT `fk_1` FOREIGN KEY (`USER_NAME`) REFERENCES `login` (`USER_NAME`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `admin`
--


/*!40000 ALTER TABLE `admin` DISABLE KEYS */;
LOCK TABLES `admin` WRITE;
INSERT INTO `admin` VALUES ('abedinnh','谢文轩','513101198408222899','978'),('ahenricw','柏忠林','452231198807048839','993'),('baizhonglin','苏采灵','440000199307302728','3'),('bbonett3','陈贺祥','320501200604146815','964'),('bcuffina','潘亦菲','533523199208177358','971'),('bflecknoe0','钱淼','520330198606133055','961'),('bhamptonr','施觅绿','342923201309018546','988'),('bianyuchen','余雅晗','152200201501122273','4'),('binianer','谢冬青','152822200607164363','1'),('cbilbie11','卜紫雪','610327197612105164','998'),('cblanpeinn','喻醉珊','452200199512032063','984'),('cfrayno','费瑞辰','612728197212127057','985'),('changweiyang','花淑华','230601201710266130','5'),('cvaune','赵子璇','210504197806079058','975'),('douanbai','鲁淳美','440105198504111851','6'),('erackstraw2','孔飞枫','41018319861215166X','963'),('esegoef','毕念儿','350603200806218569','976'),('fengleshuang','郝汝鑫','140425199211063214','7'),('fumenghan','褚晨涛','440801199411165073','8'),('gexiafu','凤乐霜','360202199707271688','9'),('gharradineq','元雅涵','450304198101114296','987'),('gpettko13','邹醉竹','220721198110044301','1000'),('gsyne5','廉从蕾','530424200812111682','966'),('haoruxin','葛夏芙','35062319720726082X','10'),('idennettg','唐紫轩','62052519880831179X','977'),('ijarmynv','唐紫轩','331021199307189814','992'),('jdauncey10','郎夜柔','51012319760515200X','997'),('jkienleu','鲁淳美','330122199707275472','991'),('ljedrzejewskyi','张晓蝶','231005199908300545','979'),('lmoffet12','平痴海','420281197303269920','999'),('mdowreyp','伍友岚','341100201506117069','986'),('nmushawey','范语芙','340823201210129505','995'),('oberardtt','曹溶溶','652323199609182233','990'),('ohaggithz','安晶滢','410326201206300410','996'),('olefley9','许杨','320100197103289399','970'),('pblakden6','彭若云','520203200609122840','967'),('rdach1','郑妙翠','500300201404204305','962'),('schessumm','王凡柔','370404200709176685','983'),('sgringleyc','李夫子','210323197105144097','973'),('sineson8','任苒溪','610423199611156479','969'),('skintishl','吴曼云','220881200705240506','982'),('smongin4','柳秋柏','370685201205146160','965'),('spears7','彭涵涵','410404197209220078','968'),('spoored','戚淑慧','340204201509232695','974'),('srubkeb','黄乐巧','53310320160604596X','972'),('tbeneixk','谢冬青','342502197904031064','981'),('tsturgeons','陈贺祥','421022201709215593','989'),('vdearx','许杨','420526197611285019','994'),('wshorrockj','蒋笑天','642223199812198866','980'),('yuzuiping','萧念萱','542331201304272603','2');
UNLOCK TABLES;
/*!40000 ALTER TABLE `admin` ENABLE KEYS */;

--
-- Table structure for table `hirer_of_vehicle`
--

DROP TABLE IF EXISTS `hirer_of_vehicle`;
CREATE TABLE `hirer_of_vehicle` (
  `USER_NAME` varchar(60) NOT NULL,
  `NAME` varchar(30) NOT NULL,
  `SEX` int(11) NOT NULL,
  `ID` varchar(30) NOT NULL,
  `CREDIT` int(11) NOT NULL,
  `FREQUENCY` int(11) NOT NULL,
  `EMAIL` varchar(60) NOT NULL default '',
  `TEL` varchar(30) NOT NULL,
  PRIMARY KEY  (`USER_NAME`),
  CONSTRAINT `fk_2` FOREIGN KEY (`USER_NAME`) REFERENCES `login` (`USER_NAME`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `hirer_of_vehicle`
--


/*!40000 ALTER TABLE `hirer_of_vehicle` DISABLE KEYS */;
LOCK TABLES `hirer_of_vehicle` WRITE;
INSERT INTO `hirer_of_vehicle` VALUES ('aalmack37','谢文轩',1,'330900199208051517',60,6,'aalmack37@meetup.com','17147905627'),('aconlon25','郝宛桃',0,'431129198009050844',100,0,'aconlon25@state.tx.us','13714579418'),('akenright3b','苗芷巧',1,'342900200612254024',100,0,'akenright3b@bizjournals.com','13731657319'),('apendell38','伍雨泽',1,'22068119870503789X',100,0,'apendell38@bing.com','18716918549'),('aprinn','穆静露',1,'230921201004116460',100,0,'aprinne14@bing.com','13858964789'),('aredmain2g','黄乐巧',1,'410711199512279805',100,0,'aredmain2g@google.ca','17046700047'),('awickins18','魏欣慧',0,'220122199710059775',100,0,'awickins18@netvibes.com','17055911865'),('bdallas34','葛林',1,'210505197204255495',100,0,'bdallas34@a8.net','13702949116'),('bhandling1e','韩益帆',0,'440983199701230494',100,0,'bhandling1e@columbia.edu','13156852608'),('bmacy2x','元雅涵',1,'430503201211168258',100,0,'bmacy2x@statcounter.com','18740304953'),('bstorms2r','秦谷天',1,'32098119890605766X',100,0,'bstorms2r@ezinearticles.com','17079911803'),('bwimms1x','周半香',0,'130929199010270226',100,0,'bwimms1x@wired.com','13753025557'),('cbeamand29','苏采灵',1,'441801197011094626',100,0,'cbeamand29@friendfeed.com','13293139185'),('cbootes2z','陶建政',1,'513721200305045496',100,0,'cbootes2z@usa.gov','13806780036'),('ccolbron1v','花淑华',0,'142300197005315433',100,0,'ccolbron1v@icio.us','13884352236'),('ccornell1g','傅晓庆',0,'330401198710230654',100,0,'giey1f@google.cn','18702372459'),('cdesimoni1i','毕念儿',0,'410621200704083623',100,0,'cdesimoni1i@dion.ne.jp','13798723087'),('chedges2p','廉昕蕊',1,'210905197008099191',100,0,'chedges2p@merriam-webster.com','13889744002'),('cmaghull39','窦欣汝',1,'37050219960420929X',100,0,'cmaghull39@vimeo.com','18736829159'),('cmorrill16','尤春齐',0,'513221199103153234',100,0,'cmorrill16@freewebs.com','13766997601'),('cstonbridge3a','潘亦菲',1,'34042119791214049X',100,0,'cstonbridge3a@icq.com','13237800129'),('cwalentynowicz2n','陈贺祥',1,'622723201608243539',100,0,'cwalen@studiopress.com','13740747161'),('dbarrott33','章慧嘉',1,'371302198704218834',100,0,'dbarrott33@kickstarter.com','13246371972'),('dcallister2w','范语芙',1,'42090020160315872X',100,0,'dcallister2w@cam.ac.uk','13141977922'),('dflacke27','柳嘉怡',0,'130684198205125612',100,0,'dflacke27@zdnet.com','13266827831'),('dmyles1b','郝汝鑫',0,'211004200105281913',100,0,'dmyles1b@pcworld.com','13095025064'),('edudbridge2e','萧念萱',1,'632222197508116929',100,0,'edudbridge2e@examiner.com','17148205191'),('eflew2u','喻欣源',1,'210304198410310210',100,0,'eflew2u@ezinearticles.com','13367492743'),('erumsey1k','罗晨璐',0,'654200199501253716',100,0,'erumsey1k@360.cn','13766865155'),('eschrir1z','任碧松',0,'320800197810128605',100,0,'eschrir1z@stumbleupon.com','18995957731'),('evandrill2o','岑丹冬',1,'360322199306024425',100,0,'evandrill2o@wufoo.com','17093849667'),('fdamrel22','苗润丽',0,'230606197303261490',100,0,'fdamrel22@hc360.com','13003816776'),('fdayborne1r','卜清妍',0,'412800201401294138',100,0,'fdayborne1r@seesaa.net','13856456923'),('fgiotto2f','柏忠林',1,'532727201703203096',100,0,'fgiotto2f@nbcnews.com','17061781051'),('fmebs1a','何文昊',0,'510812199507294176',100,0,'fmebs1a@ca.gov','17005821350'),('fstentiford35','皮天蓝',1,'530181197505222266',100,0,'fstentiford35@g.co','17168241419'),('fstiebler20','昌绿薇',0,'410922197404017008',100,0,'fstiebler20@people.com.cn','13164404494'),('gbarenskie2c','费痴松',1,'15260219820604564X',100,0,'gbarenskie2c@parallels.com','18941201471'),('gcaustick19','余醉萍',0,'511028199807217226',100,0,'gcaustick19@webster.com','17154480276'),('ggrossier2y','韦涵芹',1,'533523197202042322',100,0,'ggrossier2y@meetup.com','13757657529'),('gingrey1f','伍雨泽',0,'130731199103039737',100,0,'gingrey1f@google.cn','18709833229'),('gtaggerty2m','陈凝桃',1,'23052319960629242X',100,0,'gtaggerty2m@miitbeian.gov.cn','13718124866'),('hmytton2l','邬淑君',1,'520181199104075952',100,0,'hmytton2l@pbs.org','18726864273'),('jgiller1p','卞映露',0,'33020419920516170X',100,0,'jgiller1p@google.com.br','13155707286'),('jkonneke32','郝宛桃',1,'210106199104190624',100,0,'jkonneke32@wired.com','18787371517'),('jlongford1q','贺静蝶',0,'44190119891114756X',100,0,'jlongford1q@hugedomains.com','17748101748'),('jtebbett1h','沈寄香',0,'372300198001291769',100,0,'jtebbett1h@ft.com','13703192666'),('jwebermann1t','卜紫雪',0,'42011219990703252X',100,0,'jwebermann1t@patch.com','13792768226'),('kbrunet1j','萧念萱',0,'420300199909116888',100,0,'kbrunet1j@eventbrite.com','18976820256'),('kcamois2t','孙国栋',1,'420800199008307115',100,0,'kcamois2t@google.co.uk','13330901271'),('kdudeney2v','尤春齐',1,'341022199701124697',100,0,'kdudeney2v@altervista.org','13707084994'),('khambly30','吴曼云',1,'433125197702178880',100,0,'khambly30@google.co.jp','13257248858'),('kreims2k','姜美欣',1,'612525200008239232',100,0,'kreims2k@zimbio.com','18916744148'),('lheighway2s','许杨',1,'23010719820615331X',100,0,'lheighway2s@ocn.ne.jp','13537964890'),('lmayston36','凤翔',1,'452130199301262654',100,0,'lmayston36@slate.com','13506022806'),('lstrephan1d','孟嘉乐',0,'140123198303095818',100,0,'lstrephan1d@tamu.edu','13180820119'),('mcasarini1m','廉从蕾',0,'500113199604099221',100,0,'mcasarini1m@engadget.com','18749481772'),('mdanahar2d','钱念春',1,'533524198609254563',100,0,'mdanahar2d@goo.ne.jp','18913494451'),('mpopplewell26','周瑞堂',0,'652824200902076658',100,0,'mpopplewell26@examiner.com','13144365059'),('msheals2h','章若雁',1,'441284199102083022',100,0,'msheals2h@uol.com.br','13289714165'),('msqueers21','袁诗彤',0,'510400199207135985',100,0,'msqueers21@ftc.gov','18966573792'),('mstaniford2j','韩益帆',1,'610627198002225557',100,0,'mstaniford2j@issuu.com','13567957086'),('mstern2a','李含香',1,'370303200108288786',100,0,'mstern2a@sina.com.cn','13138579372'),('mwaistall1l','廉昕蕊',0,'450326197608274591',100,0,'mwaistall1l@issuu.com','18968588757'),('nrizzolo1o','秦谷天',0,'340702200804019109',100,0,'nrizzolo1o@friendfeed.com','13835769258'),('penghanhan','鲁淳美',1,'230200198611225496',60,0,'qishuhui_nvt@aol.com','13771965501'),('rlewry1w','许友天',0,'421083198408227185',100,0,'rlewry1w@google.ca','17001437474'),('rmensler1s','元雅涵',0,'33072620170424787X',100,0,'rmensler1s@indiegogo.com','17068465609'),('rspennock1y','毕运昊',0,'510623197306151776',100,0,'rspennock1y@cam.ac.uk','13051545054'),('sbrightling17','孟嘉乐',0,'36253120081118343X',100,0,'sbrightling17@istockphoto.com','13067916695'),('shimilv','李含香',1,'500241201111117058',100,0,'youchunqi_guqo@163.net','13821199734'),('sucailing','李夫子',1,'513424197304072749',100,0,'xueyinger_fh@0355.net','13899783364'),('sucailing2','吴曼云',1,'130902200810263783',100,0,'miaozhiqiao_lxtxw@aol.com','18783399582'),('sunguodong','谢文轩',1,'510108197305123609',100,0,'haowantao_kkr@yahoo.com','17003073670'),('tbarrable1u','葛林',0,'142630200511033817',100,0,'tbarrable1u@google.pl','17197475266'),('tczadla28','雷雁雪',1,'410303200804246945',100,0,'tczadla28@newsvine.com','18948676459'),('tklessmann1n','范语芙',0,'230604201404205881',100,0,'tklessmann1n@feedburner.com','17157359068'),('tkorlat2b','俞夜阳',1,'210401200808186068',100,0,'tkorlat2b@unc.edu','17164968917'),('trosenblatt2q','于安旋',1,'623022200406123522',100,0,'trosenblatt2q@etsy.com','13137999398'),('uiacofo24','邹文杰',0,'532730199101042756',100,0,'uiacofo24@cafepress.com','13514313928'),('vcosely1c','华欣欣',0,'522225199811144415',100,0,'vcosely1c@fda.gov','18746874364'),('vrizzardini23','彭若云',0,'370400199111257623',100,0,'vrizzardini23@tripadvisor.com','13506471808'),('vugolini2i','安晶滢',1,'140431201704128351',100,0,'vugolini2i@accuweather.com','13703894216'),('weizehui','章若雁',1,'320829197001128392',100,0,'lerongshan_ffuk@qq.com','17733081088'),('wumanyun','施觅绿',1,'533324199303254556',100,0,'mujiahao_de@163.com','17183096043'),('wushujun','蒋易轩',1,'411303198802055468',100,0,'shiqiaohe_ezji@yeah.com','18982532202'),('wushujun2','苗润丽',1,'610404197310098334',100,0,'yinchenxi_zuj@263.net','17146037857'),('xiewenxuan','柏水琴',1,'142232199601193158',100,0,'langyuchen_smew@aol.com','17783014776'),('xsobieski15','毕运昊',0,'441825200610161953',100,0,'xsobieski15@bizjournals.com','17742736747'),('yangjingyang','孔熙涵',0,'421127200907086545',100,0,'mengchusong_tssrt@qq.com','13792733925'),('yfarfull31','郝汝鑫',1,'370104197705219093',100,0,'yfarfull31@apache.org','17783922563'),('yinchiliu','穆静露',0,'130981200008118138',100,0,'lifuzi_ykc@163.com','13548886333'),('yunxiaonan','杨靖阳',0,'430381201710034754',100,0,'fangjingying_iennb@yahoo.com','13225521299'),('yuyahan','褚紫岚',0,'370100197509277610',100,0,'tangzixuan_rnkxd@163.net','13897180021'),('zhangruoyan','孙国栋',0,'445101200503052609',100,0,'renbisong_zij@yahoo.com','18729366965'),('zhangxiaodie','潘亦菲',0,'362321201601057970',100,0,'kangtianhao_o@ask.com','18762957799'),('zhechentao','邬淑君',0,'130921200102136379',100,0,'wuyuze_yjnpm@aol.com','13808439179'),('zhengmiaocui','尹痴柳',0,'632122198105189620',100,0,'shiqiaohe_qnww@aol.com','13200416765'),('zhezilan','彭涵涵',0,'52011319910326865X',100,0,'buqingyan_wkpp@qq.com','17002398610'),('zhushishan','卞语晨',0,'230421198704102551',59,0,'haoruxin_pyjoj@163.com','17713203139');
UNLOCK TABLES;
/*!40000 ALTER TABLE `hirer_of_vehicle` ENABLE KEYS */;

--
-- Table structure for table `login`
--

DROP TABLE IF EXISTS `login`;
CREATE TABLE `login` (
  `USER_NAME` varchar(60) NOT NULL,
  `PASSWORD` varchar(60) NOT NULL default '',
  `LAST_TIME` datetime default NULL,
  `TIMES` int(11) NOT NULL,
  `STATE` int(11) NOT NULL,
  `REGISTER_TIME` datetime NOT NULL,
  `USER_TYPE` int(11) NOT NULL,
  PRIMARY KEY  (`USER_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `login`
--


/*!40000 ALTER TABLE `login` DISABLE KEYS */;
LOCK TABLES `login` WRITE;
INSERT INTO `login` VALUES ('aalmack37','aaaa','2021-10-06 09:38:15',43,0,'2021-09-15 21:17:29',1),('abedinnh','5b2ea4edb4012d54ed39abd0bd623020','2021-09-29 20:25:42',13,0,'2021-09-25 06:09:03',0),('aconlon25','feddae785e167ec6db85339e6e061a1a','2021-09-16 20:16:35',1,0,'2021-09-15 21:17:29',1),('adanilishinbn','81e45d4669a98d19402fb5bfd3f254c0','2021-09-29 15:44:54',2,1,'2021-09-22 20:35:55',2),('adymockcm','1d92a363bf9975f4f6b14fbef3ee8be4','2021-09-23 20:35:00',1,0,'2021-09-22 20:35:55',2),('agilhouleybb','79241e2ce49e3e70adb380fafe8a79ab','2021-09-23 20:35:00',1,0,'2021-09-22 20:35:55',2),('ahenricw','84320faadeb889529209c944f0139709','2021-09-25 12:08:03',1,0,'2021-09-25 06:09:03',0),('akenright3b','3b9e1e65ff24cd82930bc465a12d2627','2021-09-16 20:16:35',1,0,'2021-09-15 21:17:29',1),('apendell38','184003850086273d881dc221905d898b','2021-09-16 20:16:35',1,0,'2021-09-15 21:17:29',1),('aprinn','738f8daa4d7e6b61708d4fc039ca8305','2021-09-16 20:16:35',1,0,'2021-09-15 21:17:29',1),('aredmain2g','cb073f9b5219bb389bfd3bbb9defa87b','2021-09-16 20:16:35',1,0,'2021-09-15 21:17:29',1),('astonerau','feddae785e167ec6db85339e6e061a1a','2021-09-23 20:35:00',1,0,'2021-09-22 20:35:55',2),('awickins18','10d44afa49b0a1baa0418ccb782ee123','2021-09-16 20:16:35',1,0,'2021-09-15 21:17:29',1),('babramovitzch','a267a5ed6d5187da1fcaa520e3e07ec4','2021-09-23 20:35:00',1,0,'2021-09-22 20:35:55',2),('baizhonglin','7f45ecd81bda9719457c706819f82546','2021-09-13 22:25:41',1,0,'2021-09-12 22:25:56',0),('bbonett3','bae73859db010f9645ac6c8a4f71502e','2021-09-17 20:07:46',1,0,'2021-09-17 12:09:47',0),('bcuffina','925629b1a54bdbc39359c707868e922b','2021-09-17 20:07:46',1,0,'2021-09-17 12:09:47',0),('bdallas34','738f8daa4d7e6b61708d4fc039ca8305','2021-09-16 20:16:35',1,0,'2021-09-15 21:17:29',1),('bdelaceycf','108e26d68b3a8896e9a8754b68a945c0','2021-09-23 20:35:00',1,0,'2021-09-22 20:35:55',2),('bflecknoe0','e381cd4f2160a44d2a503cd8e187d943','2021-09-25 12:08:03',1,0,'2021-09-25 06:09:03',0),('bhamptonr','3a4adeb972cac9caf68e2c22d32ef3e5','2021-09-25 12:08:03',1,0,'2021-09-25 06:09:03',0),('bhandling1e','8035cc17f4d84beff596614bccd34259','2021-09-16 20:16:35',1,0,'2021-09-15 21:17:29',1),('bhazeldinebu','c34805026a315456ec49eb661d3c36ca','2021-09-23 20:35:00',1,0,'2021-09-22 20:35:55',2),('bianyuchen','2e935275ef5b98d690c22729adc59c64','2021-09-13 22:25:41',1,0,'2021-09-12 22:25:56',0),('binianer','f3d866e70213583e290d607cd2cb67c0','2021-09-26 15:45:19',3,0,'2021-09-12 22:25:56',0),('bmacy2x','12889c2db0b7f018270671c9935b4952','2021-09-16 20:16:35',1,0,'2021-09-15 21:17:29',1),('bmillwaterba','7f6e0400c6d3ef8fea2d542b4f4a32ca','2021-09-23 20:35:00',1,0,'2021-09-22 20:35:55',2),('bsinclairecj','a3096bcf04af06c43bf1988cb956ccd7','2021-09-23 20:35:00',1,0,'2021-09-22 20:35:55',2),('bspurdensaw','c6936083c347431170a9fe95e89538f0','2021-09-23 20:35:00',1,0,'2021-09-22 20:35:55',2),('bstorms2r','dcf9f45b12db99f48b2bbf5588f084db','2021-09-16 20:16:35',1,0,'2021-09-15 21:17:29',1),('bwimms1x','36effd5eef5d293d628536a96ac0fa97','2021-09-16 20:16:35',1,0,'2021-09-15 21:17:29',1),('cbeamand29','f600af0accd7755d919acf771045ad37','2021-09-16 20:16:35',1,0,'2021-09-15 21:17:29',1),('cbilbie11','636b684af755fb70cff9fc22e7e89252','2021-09-25 12:08:03',1,0,'2021-09-25 06:09:03',0),('cblanpeinn','6ac22cc7801a819a949e51b46eb92714','2021-09-25 12:08:03',1,0,'2021-09-25 06:09:03',0),('cbootes2z','a511603742850492c5e905dd079a9aad','2021-09-16 20:16:35',1,0,'2021-09-15 21:17:29',1),('ccolbron1v','2775efdf288ad9883117f0191c057923','2021-09-16 20:16:35',1,0,'2021-09-15 21:17:29',1),('ccornell1g','7959a4c997d9fb0dab3bf77ddedf7b52','2021-09-16 20:16:35',1,0,'2021-09-15 21:17:29',1),('cdesimoni1i','2e935275ef5b98d690c22729adc59c64','2021-09-16 20:16:35',1,0,'2021-09-15 21:17:29',1),('cfrancelloat','bb3602e1b24b562456fe0ed7937fb93a','2021-09-23 20:35:00',1,0,'2021-09-22 20:35:55',2),('cfrayno','54abd32633bf2a9cc3ed0b87c123e1a3','2021-09-25 12:08:03',1,0,'2021-09-25 06:09:03',0),('changweiyang','c764f79980cfa0dc62bd640a4fc3b8fc','2021-09-13 22:25:41',1,0,'2021-09-12 22:25:56',0),('chedges2p','e016b19cfe1b883ca780f0c064f786f0','2021-09-16 20:16:35',1,0,'2021-09-15 21:17:29',1),('cmaghull39','a8c0fd0fdc603bca382f363bd15294b4','2021-09-16 20:16:35',1,0,'2021-09-15 21:17:29',1),('cmorrill16','580a96da820326cc0baafdd81aa5d4a8','2021-09-16 20:16:35',1,0,'2021-09-15 21:17:29',1),('cstonbridge3a','36effd5eef5d293d628536a96ac0fa97','2021-09-16 20:16:35',1,0,'2021-09-15 21:17:29',1),('cvaune','5d11ff935b0848ff0d6068dcb9334c7f','2021-09-25 12:08:03',1,0,'2021-09-25 06:09:03',0),('cwalentynowicz2n','d9c58e75ee9abf40ab0429542fa5a322','2021-09-16 20:16:35',1,0,'2021-09-15 21:17:29',1),('dalmakay','9c5c56bc4bb35114c48f2a386b3e4c99','2021-09-23 20:35:00',1,0,'2021-09-22 20:35:55',2),('dbarrott33','cb073f9b5219bb389bfd3bbb9defa87b','2021-09-16 20:16:35',1,0,'2021-09-15 21:17:29',1),('dcallister2w','7ffac099a6c12c0bcccc473d961a08f7','2021-09-16 20:16:35',1,0,'2021-09-15 21:17:29',1),('dflacke27','f60aeab0a14fcd4de18df2b33dc26631','2021-09-16 20:16:35',1,0,'2021-09-15 21:17:29',1),('dgarlickb2','31c24c008beb23c04fe6737ebbf109e7','2021-09-23 20:35:00',1,0,'2021-09-22 20:35:55',2),('dgrenvilleb4','4e4238115575b9f9f38faf38bfaf3b28','2021-09-23 20:35:00',1,0,'2021-09-22 20:35:55',2),('dmyles1b','4bb697d8981fd0c2c979781a3cc36132','2021-09-16 20:16:35',1,0,'2021-09-15 21:17:29',1),('dnewlandsc7','bb3602e1b24b562456fe0ed7937fb93a','2021-09-23 20:35:00',1,0,'2021-09-22 20:35:55',2),('douanbai','12889c2db0b7f018270671c9935b4952','2021-09-13 22:25:41',1,0,'2021-09-12 22:25:56',0),('dpugheaz','2434f0a01297009fd084066b79684514','2021-09-23 20:35:00',1,0,'2021-09-22 20:35:55',2),('edudbridge2e','c764f79980cfa0dc62bd640a4fc3b8fc','2021-09-16 20:16:35',1,0,'2021-09-15 21:17:29',1),('eflew2u','8035cc17f4d84beff596614bccd34259','2021-09-16 20:16:35',1,0,'2021-09-15 21:17:29',1),('ekerrichbv','331c0226ce71a97026d8ab0f20f92a8b','2021-09-23 20:35:00',1,0,'2021-09-22 20:35:55',2),('emorlingb7','43d40a5b5805e5c5530fe8b51132ff54','2021-09-23 20:35:00',1,0,'2021-09-22 20:35:55',2),('epeasbycc','a5251bc3dd3ffd1cc904fedbf42f7fb0','2021-09-23 20:35:00',1,0,'2021-09-22 20:35:55',2),('erackstraw2','ccbdc4d3b43a6792d83bf5113071dc6a','2021-09-17 20:07:46',1,0,'2021-09-17 12:09:47',0),('erawstornecq','dff8992652bfae6a2dbf72327c4d2be2','2021-09-23 20:35:00',1,0,'2021-09-22 20:35:55',2),('erumsey1k','54abd32633bf2a9cc3ed0b87c123e1a3','2021-09-16 20:16:35',1,0,'2021-09-15 21:17:29',1),('eschrir1z','925629b1a54bdbc39359c707868e922b','2021-09-16 20:16:35',1,0,'2021-09-15 21:17:29',1),('esegoef','f3d866e70213583e290d607cd2cb67c0','2021-09-25 12:08:03',1,0,'2021-09-25 06:09:03',0),('evandrill2o','dcf9f45b12db99f48b2bbf5588f084db','2021-09-16 20:16:35',1,0,'2021-09-15 21:17:29',1),('fchristonbl','dcf9f45b12db99f48b2bbf5588f084db','2021-09-23 20:35:00',1,0,'2021-09-22 20:35:55',2),('fdamrel22','c55071c2f5f6a4f804f4541eb4468632','2021-09-16 20:16:35',1,0,'2021-09-15 21:17:29',1),('fdayborne1r','2a3b4e1ae71bab713fadc6d752cb9b33','2021-09-16 20:16:35',1,0,'2021-09-15 21:17:29',1),('fengleshuang','b29ae399c23ae186f9a4a16bf098c149','2021-09-13 22:25:41',1,0,'2021-09-12 22:25:56',0),('fgiotto2f','54abd32633bf2a9cc3ed0b87c123e1a3','2021-09-16 20:16:35',1,0,'2021-09-15 21:17:29',1),('fmebs1a','4cd84e281e409879656c1b444373e40e','2021-09-16 20:16:35',1,0,'2021-09-15 21:17:29',1),('fpiscopob5','8d7a861f797fd54759db2c9a0c17cd3c','2021-09-23 20:35:00',1,0,'2021-09-22 20:35:55',2),('fstentiford35','a3096bcf04af06c43bf1988cb956ccd7','2021-09-16 20:16:35',1,0,'2021-09-15 21:17:29',1),('fstiebler20','7998cc78af5e0c3795f80b63d96dae59','2021-09-16 20:16:35',1,0,'2021-09-15 21:17:29',1),('fumenghan','331c0226ce71a97026d8ab0f20f92a8b','2021-09-13 22:25:41',1,0,'2021-09-12 22:25:56',0),('gbarenskie2c','a3096bcf04af06c43bf1988cb956ccd7','2021-09-16 20:16:35',1,0,'2021-09-15 21:17:29',1),('gcaustick19','3a4adeb972cac9caf68e2c22d32ef3e5','2021-09-16 20:16:35',1,0,'2021-09-15 21:17:29',1),('gcodronbc','b45c52ccd2cdaf36e0cd1f2d6b848073','2021-09-23 20:35:00',1,0,'2021-09-22 20:35:55',2),('gcossemao','31c24c008beb23c04fe6737ebbf109e7','2021-09-23 20:35:00',1,0,'2021-09-22 20:35:55',2),('gexiafu','9fc458d5a8edcdbd48d365a792af51f0','2021-09-13 22:25:41',1,0,'2021-09-12 22:25:56',0),('ggrossier2y','f60aeab0a14fcd4de18df2b33dc26631','2021-09-16 20:16:35',1,0,'2021-09-15 21:17:29',1),('gharradineq','580a96da820326cc0baafdd81aa5d4a8','2021-09-25 12:08:03',1,0,'2021-09-25 06:09:03',0),('gingrey1f','93d793258047f1b94b58f6009871fc6b','2021-09-16 20:16:35',1,0,'2021-09-15 21:17:29',1),('glaubx','3dbc5e81738af4932f9be56d6c15a5a7','2021-09-23 20:35:00',1,0,'2021-09-22 20:35:55',2),('glefridgec4','8035cc17f4d84beff596614bccd34259','2021-09-23 20:35:00',1,0,'2021-09-22 20:35:55',2),('gmccriebw','5d11ff935b0848ff0d6068dcb9334c7f','2021-09-23 20:35:00',1,0,'2021-09-22 20:35:55',2),('gpettko13','8b52680a2138c4ca6fad86cd40959efc','2021-09-25 12:08:03',1,0,'2021-09-25 06:09:03',0),('gsyne5','80159ce9a961ef8b344abdffc97249cb','2021-09-17 20:07:46',1,0,'2021-09-17 12:09:47',0),('gtaggerty2m','eec3fac079b97eacc1701a47f4c144d4','2021-09-16 20:16:35',1,0,'2021-09-15 21:17:29',1),('haoruxin','17f030eb9b277e14c2230652f6a1e0a8','2021-09-13 22:25:41',1,0,'2021-09-12 22:25:56',0),('hejingdie','299c8f8e6e1820e138962f6314c8f069','2021-09-29 18:16:10',15,0,'2021-09-12 22:30:09',2),('hmytton2l','8c2017f24e73b23ddc5e7aff0e386b97','2021-09-16 20:16:35',1,0,'2021-09-15 21:17:29',1),('hsichc8','3f8f8da10e1f35b1fada90c58a8c74c0','2021-09-23 20:35:00',1,0,'2021-09-22 20:35:55',2),('huashuhua','7764aca363de76d30794b35edd681e44','2021-09-13 22:29:34',1,0,'2021-09-12 22:30:09',2),('huaxinxin','a3096bcf04af06c43bf1988cb956ccd7','2021-09-13 22:29:34',1,0,'2021-09-12 22:30:09',2),('huayuanchun','3f20d7bb184c33967afc1f9fded3771d','2021-10-06 10:03:47',4,1,'2021-09-12 22:30:09',2),('idennettg','d6ac6ffab33d7b2a836ad6c397d683d7','2021-09-25 12:08:03',1,0,'2021-09-25 06:09:03',0),('ijarmynv','d6ac6ffab33d7b2a836ad6c397d683d7','2021-09-25 12:08:03',1,0,'2021-09-25 06:09:03',0),('jbrothwoodbf','f14a46973228285f191b47575b6574b6','2021-09-23 20:35:00',1,0,'2021-09-22 20:35:55',2),('jdauncey10','f2b0b7fd0cf783398b596db620a9bb97','2021-09-25 12:08:03',1,0,'2021-09-25 06:09:03',0),('jdrejercb','2a3b4e1ae71bab713fadc6d752cb9b33','2021-09-23 20:35:00',1,0,'2021-09-22 20:35:55',2),('jgiller1p','89739feb01b0d008e913ce2dfeba2382','2021-09-16 20:16:35',1,0,'2021-09-15 21:17:29',1),('jiangyixuan','d19cf6d833d339054c1235bbf49f8e9e','2021-09-13 22:29:34',1,0,'2021-09-12 22:30:09',2),('jkienleu','7e06614ae28c08c18160a2c3bc51af89','2021-09-25 12:08:03',1,0,'2021-09-25 06:09:03',0),('jkonneke32','184003850086273d881dc221905d898b','2021-09-16 20:16:35',1,0,'2021-09-15 21:17:29',1),('jlongford1q','5e1dd075c212886f4c8bb8db9d120590','2021-09-16 20:16:35',1,0,'2021-09-15 21:17:29',1),('jstraceyc0','e381cd4f2160a44d2a503cd8e187d943','2021-09-23 20:35:00',1,0,'2021-09-22 20:35:55',2),('jtebbett1h','40620594477183dc907c7e92bfa8dd97','2021-09-16 20:16:35',1,0,'2021-09-15 21:17:29',1),('jwebermann1t','e88ad137598eb2c873c7f72fd1243e07','2021-09-16 20:16:35',1,0,'2021-09-15 21:17:29',1),('kantoniottiian','55b08765928d14bd22cf69129835fabd','2021-09-23 20:35:00',1,0,'2021-09-22 20:35:55',2),('kashwellbe','4b6a9ec9eceb2287d6b7cecaf0fff252','2021-09-23 20:35:00',1,0,'2021-09-22 20:35:55',2),('kbrunet1j','4bb697d8981fd0c2c979781a3cc36132','2021-09-16 20:16:35',1,0,'2021-09-15 21:17:29',1),('kcamois2t','a8c0fd0fdc603bca382f363bd15294b4','2021-09-16 20:16:35',1,0,'2021-09-15 21:17:29',1),('kdudeney2v','f60aeab0a14fcd4de18df2b33dc26631','2021-09-16 20:16:35',1,0,'2021-09-15 21:17:29',1),('khambly30','cca12298936803de78c0bec8257f759c','2021-09-16 20:16:35',1,0,'2021-09-15 21:17:29',1),('khornigcl','fa7a964d663efd3cb1e2eeb1ed7e1f34','2021-09-23 20:35:00',1,0,'2021-09-22 20:35:55',2),('kjuleffc3','ccbdc4d3b43a6792d83bf5113071dc6a','2021-09-23 20:35:00',1,0,'2021-09-22 20:35:55',2),('kmckennanal','c34805026a315456ec49eb661d3c36ca','2021-09-23 20:35:00',1,0,'2021-09-22 20:35:55',2),('kongxihan','e0f119d6b7a55e21da58cc648438191d','2021-09-13 22:29:34',1,0,'2021-09-12 22:30:09',2),('kongxihan2','04676ac1e20ee2a4b5de5fd582ecd006','2021-09-13 22:29:34',1,0,'2021-09-12 22:30:09',2),('kreims2k','51bfe8ed88a382ae074965b1e7ccd47b','2021-09-16 20:16:35',1,0,'2021-09-15 21:17:29',1),('kspinozzibr','bbcd3d96a8624c37737695141449cace','2021-09-23 20:35:00',1,0,'2021-09-22 20:35:55',2),('ldibdencr','4fd9eecb3b4f82946e39564764036e1c','2021-09-23 20:35:00',1,0,'2021-09-22 20:35:55',2),('leiyanxue','79241e2ce49e3e70adb380fafe8a79ab','2021-09-13 22:29:34',1,0,'2021-09-12 22:30:09',2),('lfossickb6','683fec7b6551a22e9abd54767c0b4f10','2021-09-23 20:35:00',1,0,'2021-09-22 20:35:55',2),('lheighway2s','84320faadeb889529209c944f0139709','2021-09-16 20:16:35',1,0,'2021-09-15 21:17:29',1),('lifuzi','ce27b804107c397e5b0a112d1be079c5','2021-09-13 22:29:34',1,0,'2021-09-12 22:30:09',2),('lihanxiang','2aff188c988355c41215451a23db056b','2021-09-13 22:29:34',1,0,'2021-09-12 22:30:09',2),('liujiayi','56665307e0c2609f0236dc2faf821710','2021-09-13 22:29:34',1,0,'2021-09-12 22:30:09',2),('ljedrzejewskyi','41f7be8f8b61864d0277d91c2419dd29','2021-09-25 12:08:03',1,0,'2021-09-25 06:09:03',0),('llemarchantce','6e683874369a695acc7196711970820e','2021-09-23 20:35:00',1,0,'2021-09-22 20:35:55',2),('lmayston36','e25a62499fece7d606a157528cd8eda8','2021-09-16 20:16:35',1,0,'2021-09-15 21:17:29',1),('lmoffet12','6c8bd96777d752ab05a63e4c75f217d4','2021-09-25 12:08:03',1,0,'2021-09-25 06:09:03',0),('lstrephan1d','d6ac6ffab33d7b2a836ad6c397d683d7','2021-09-16 20:16:35',1,0,'2021-09-15 21:17:29',1),('luchunmei','c2e181e1e5501375e01716958e99334c','2021-09-13 22:29:34',1,0,'2021-09-12 22:30:09',2),('luchunmei2','e482810b1c0a52e45b87c37c582c5274','2021-09-13 22:29:34',1,0,'2021-09-12 22:30:09',2),('luxiangman','f52c1d191ab88d153d7fc817deae50f2','2021-09-13 22:29:34',1,0,'2021-09-12 22:30:09',2),('lwakelambo','55b08765928d14bd22cf69129835fabd','2021-09-23 20:35:00',1,0,'2021-09-22 20:35:55',2),('mcasarini1m','84320faadeb889529209c944f0139709','2021-09-16 20:16:35',1,0,'2021-09-15 21:17:29',1),('mcodringtonc5','70e349766142c6ade5fecdbc2904bd7a','2021-09-23 20:35:00',1,0,'2021-09-22 20:35:55',2),('mcosgreavebq','d6ac6ffab33d7b2a836ad6c397d683d7','2021-09-23 20:35:00',1,0,'2021-09-22 20:35:55',2),('mdanahar2d','e08e7e214d93ab2522b41f53cc567d57','2021-09-16 20:16:35',1,0,'2021-09-15 21:17:29',1),('mdowreyp','8035cc17f4d84beff596614bccd34259','2021-09-25 12:08:03',1,0,'2021-09-25 06:09:03',0),('mengjiale','0e225dc00b5731fe65922c2651ff6b03','2021-09-13 22:29:34',1,0,'2021-09-12 22:30:09',2),('mgaddiebz','f8185b547fd5e1347ba692264cc6206f','2021-09-23 20:35:00',1,0,'2021-09-22 20:35:55',2),('miaorunli','184003850086273d881dc221905d898b','2021-09-13 22:29:34',1,0,'2021-09-12 22:30:09',2),('miaorunli2','bb3602e1b24b562456fe0ed7937fb93a','2021-09-13 22:29:34',1,0,'2021-09-12 22:30:09',2),('mmariabj','e016b19cfe1b883ca780f0c064f786f0','2021-09-23 20:35:00',1,0,'2021-09-22 20:35:55',2),('moverillc6','cb073f9b5219bb389bfd3bbb9defa87b','2021-09-23 20:35:00',1,0,'2021-09-22 20:35:55',2),('mpashenco','e482810b1c0a52e45b87c37c582c5274','2021-09-23 20:35:00',1,0,'2021-09-22 20:35:55',2),('mpersickear','d1d3e187ec76906a4ea4a94d763fdc34','2021-09-23 20:35:00',1,0,'2021-09-22 20:35:55',2),('mpopplewell26','ac68e716fa8881647c45c7de524ac129','2021-09-16 20:16:35',1,0,'2021-09-15 21:17:29',1),('msalvatib8','14afba93bfcfc049fe9aff39d3cd62fa','2021-09-23 20:35:00',1,0,'2021-09-22 20:35:55',2),('msheals2h','d3c9dcdfb6b898ebd63314059f3f35e5','2021-09-16 20:16:35',1,0,'2021-09-15 21:17:29',1),('msqueers21','8f7c651c4949723bdaa6f3cb9cec8b51','2021-09-16 20:16:35',1,0,'2021-09-15 21:17:29',1),('mstaniford2j','5d11ff935b0848ff0d6068dcb9334c7f','2021-09-16 20:16:35',1,0,'2021-09-15 21:17:29',1),('mstern2a','f8185b547fd5e1347ba692264cc6206f','2021-09-16 20:16:35',1,0,'2021-09-15 21:17:29',1),('mthurlbeckbs','776046cae7bd453c6bedc5e0088f3110','2021-09-23 20:35:00',1,0,'2021-09-22 20:35:55',2),('mujinglu','d6ac6ffab33d7b2a836ad6c397d683d7','2021-09-13 22:29:34',1,0,'2021-09-12 22:30:09',2),('mwaistall1l','8f96939f20868e4058e9b192eb31f177','2021-09-16 20:16:35',1,0,'2021-09-15 21:17:29',1),('ncromwellap','89739feb01b0d008e913ce2dfeba2382','2021-09-23 20:35:00',1,0,'2021-09-22 20:35:55',2),('nmushawey','a3c85f34807489a053e632c72a16ef42','2021-09-25 12:08:03',1,0,'2021-09-25 06:09:03',0),('nrizzolo1o','12889c2db0b7f018270671c9935b4952','2021-09-16 20:16:35',1,0,'2021-09-15 21:17:29',1),('obeardsellc1','8b52680a2138c4ca6fad86cd40959efc','2021-09-23 20:35:00',1,0,'2021-09-22 20:35:55',2),('oberardtt','489c46e1747c3cc825bc36f7b807ef84','2021-09-25 12:08:03',1,0,'2021-09-25 06:09:03',0),('ohaggithz','cb073f9b5219bb389bfd3bbb9defa87b','2021-09-25 12:08:03',1,0,'2021-09-25 06:09:03',0),('olefley9','dff8992652bfae6a2dbf72327c4d2be2','2021-09-17 20:07:46',1,0,'2021-09-17 12:09:47',0),('omccraineaq','59a4204f7b8b560d87e7a0fc9bf8a023','2021-09-23 20:35:00',1,0,'2021-09-22 20:35:55',2),('panqiuyan','b00e64a9bdf7f28833b8ea42c1732d01','2021-09-13 22:29:34',1,0,'2021-09-12 22:30:09',2),('panyifei','299c8f8e6e1820e138962f6314c8f069','2021-09-13 22:29:34',1,0,'2021-09-12 22:30:09',2),('pblakden6','2891c5d029fe5d5bb585c3e644c0a235','2021-09-17 20:07:46',1,0,'2021-09-17 12:09:47',0),('penghanhan','43d40a5b5805e5c5530fe8b51132ff54','2021-09-13 22:27:28',1,0,'2021-09-12 22:28:08',1),('ppietrowskibh','aa5c7d0c52b6588681b9354d50284ae4','2021-09-23 20:35:00',1,0,'2021-09-22 20:35:55',2),('qtesimonam','8f7c651c4949723bdaa6f3cb9cec8b51','2021-09-23 20:35:00',1,0,'2021-09-22 20:35:55',2),('rblundellcs','a80c09992ca5d9d22e3afe4c17efdb38','2021-09-23 20:35:00',1,0,'2021-09-22 20:35:55',2),('rchoulesax','81e45d4669a98d19402fb5bfd3f254c0','2021-09-23 20:35:00',1,0,'2021-09-22 20:35:55',2),('rdach1','a5251bc3dd3ffd1cc904fedbf42f7fb0','2021-09-17 20:07:46',1,0,'2021-09-17 12:09:47',0),('rgavozzib3','43e19977c2774bffb10a1e9d10ccd102','2021-09-23 20:35:00',1,0,'2021-09-22 20:35:55',2),('rivanilovb9','12889c2db0b7f018270671c9935b4952','2021-09-23 20:35:00',1,0,'2021-09-22 20:35:55',2),('rjoanicb0','6c8bd96777d752ab05a63e4c75f217d4','2021-09-23 20:35:00',1,0,'2021-09-22 20:35:55',2),('rklewicp','624b081626fedfc33f00219f7faccdf6','2021-09-23 20:35:00',1,0,'2021-09-22 20:35:55',2),('rlewry1w','cb073f9b5219bb389bfd3bbb9defa87b','2021-09-16 20:16:35',1,0,'2021-09-15 21:17:29',1),('rmatchittc9','c34805026a315456ec49eb661d3c36ca','2021-09-23 20:35:00',1,0,'2021-09-22 20:35:55',2),('rmensler1s','3dbc5e81738af4932f9be56d6c15a5a7','2021-09-16 20:16:35',1,0,'2021-09-15 21:17:29',1),('rspennock1y','d6ac6ffab33d7b2a836ad6c397d683d7','2021-09-16 20:16:35',1,0,'2021-09-15 21:17:29',1),('sbrightling17','6ac22cc7801a819a949e51b46eb92714','2021-09-16 20:16:35',1,0,'2021-09-15 21:17:29',1),('schessumm','70342688de9683ddb45fbf605e3baf96','2021-09-25 12:08:03',1,0,'2021-09-25 06:09:03',0),('sdivellbi','1d92a363bf9975f4f6b14fbef3ee8be4','2021-09-23 20:35:00',1,0,'2021-09-22 20:35:55',2),('seppsonby','8851bcdaf283c5d5eff88b357cb7b1a6','2021-09-23 20:35:00',1,0,'2021-09-22 20:35:55',2),('sfoynesas','3b9e1e65ff24cd82930bc465a12d2627','2021-09-23 20:35:00',1,0,'2021-09-22 20:35:55',2),('sgringleyc','184003850086273d881dc221905d898b','2021-09-25 12:08:03',1,0,'2021-09-25 06:09:03',0),('shimilv','e0f119d6b7a55e21da58cc648438191d','2021-09-13 22:27:28',1,0,'2021-09-12 22:28:08',1),('sineson8','505c0b2a9e7b197645aceb9bfbb2c69e','2021-09-17 20:07:46',1,0,'2021-09-17 12:09:47',0),('skintishl','306141cb3e8bd58a135823b6cdb330a9','2021-09-25 12:08:03',1,0,'2021-09-25 06:09:03',0),('slouyscg','c03766afb055baa755b5153bd0080811','2021-09-23 20:35:00',1,0,'2021-09-22 20:35:55',2),('smongin4','ff6fb5f032c5878cea5ae9385a11c3c7','2021-09-17 20:07:46',1,0,'2021-09-17 12:09:47',0),('smurgatroydbm','184003850086273d881dc221905d898b','2021-09-23 20:35:00',1,0,'2021-09-22 20:35:55',2),('spears7','a65e32a59aba899818567ee76c70f9af','2021-09-17 20:07:46',1,0,'2021-09-17 12:09:47',0),('spiffcn','505c0b2a9e7b197645aceb9bfbb2c69e','2021-09-23 20:35:00',1,0,'2021-09-22 20:35:55',2),('spoored','d19cf6d833d339054c1235bbf49f8e9e','2021-09-25 12:08:03',1,0,'2021-09-25 06:09:03',0),('srubkeb','760129e97607ccd31746b433853ce8bc','2021-09-25 12:08:03',1,0,'2021-09-25 06:09:03',0),('stynnancd','d2988ee45a1f7150d66baa88340af81d','2021-09-23 20:35:00',1,0,'2021-09-22 20:35:55',2),('sucailing','5039aee930689a7ffc8fb72e32b41391','2021-09-13 22:27:28',1,0,'2021-09-12 22:28:08',1),('sucailing2','f52c1d191ab88d153d7fc817deae50f2','2021-09-13 22:27:28',1,0,'2021-09-12 22:28:08',1),('sunguodong','205d05f4356d60e63e3a9939a19777ca','2021-09-13 22:27:28',1,0,'2021-09-12 22:28:08',1),('tbarrable1u','e88ad137598eb2c873c7f72fd1243e07','2021-09-16 20:16:35',1,0,'2021-09-15 21:17:29',1),('tbeneixk','a637002283c3627ed3552345e1173f5a','2021-09-25 12:08:03',1,0,'2021-09-25 06:09:03',0),('tbrumfittca','31c24c008beb23c04fe6737ebbf109e7','2021-09-23 20:35:00',1,0,'2021-09-22 20:35:55',2),('tczadla28','f70d44463018aa6a594c988943b390b1','2021-09-16 20:16:35',1,0,'2021-09-15 21:17:29',1),('tdamantbd','84320faadeb889529209c944f0139709','2021-09-23 20:35:00',1,0,'2021-09-22 20:35:55',2),('tfannonc2','81e45d4669a98d19402fb5bfd3f254c0','2021-09-23 20:35:00',1,0,'2021-09-22 20:35:55',2),('tklessmann1n','d4a321d09a1eca7487c5ca6da76746f1','2021-09-16 20:16:35',1,0,'2021-09-15 21:17:29',1),('tkorlat2b','eb50d1acc4523a41ac051084373a07b4','2021-09-16 20:16:35',1,0,'2021-09-15 21:17:29',1),('tmcnameeb1','c2c85f0ef0938d904699e55dadd1a0b8','2021-09-23 20:35:00',1,0,'2021-09-22 20:35:55',2),('trosenblatt2q','6628da9e371a51f61f073d08cf1765fe','2021-09-16 20:16:35',1,0,'2021-09-15 21:17:29',1),('tsturgeons','bae73859db010f9645ac6c8a4f71502e','2021-09-25 12:08:03',1,0,'2021-09-25 06:09:03',0),('tyettsbk','43d40a5b5805e5c5530fe8b51132ff54','2021-09-23 20:35:00',1,0,'2021-09-22 20:35:55',2),('ubarrasbg','ee255a87f8dfca55f17436339072ae95','2021-09-23 20:35:00',1,0,'2021-09-22 20:35:55',2),('uiacofo24','a637002283c3627ed3552345e1173f5a','2021-09-16 20:16:35',1,0,'2021-09-15 21:17:29',1),('vcosely1c','4cd84e281e409879656c1b444373e40e','2021-09-16 20:16:35',1,0,'2021-09-15 21:17:29',1),('vdearx','dff8992652bfae6a2dbf72327c4d2be2','2021-09-25 12:08:03',1,0,'2021-09-25 06:09:03',0),('vdipietroci','7998cc78af5e0c3795f80b63d96dae59','2021-09-23 20:35:00',1,0,'2021-09-22 20:35:55',2),('vdjurisicbt','6c8bd96777d752ab05a63e4c75f217d4','2021-09-23 20:35:00',1,0,'2021-09-22 20:35:55',2),('vmathivonck','d2f5f55fff1c0178bce9b54f8e4e8ef7','2021-09-23 20:35:00',1,0,'2021-09-22 20:35:55',2),('vpointinav','33f7db1b5f02f7a1147a54cfe0a097e9','2021-09-23 20:35:00',1,0,'2021-09-22 20:35:55',2),('vrizzardini23','f3d866e70213583e290d607cd2cb67c0','2021-09-16 20:16:35',1,0,'2021-09-15 21:17:29',1),('vugolini2i','d81377f0469131ce01b7d39524329345','2021-09-16 20:16:35',1,0,'2021-09-15 21:17:29',1),('weizehui','760129e97607ccd31746b433853ce8bc','2021-09-13 22:27:28',1,0,'2021-09-12 22:28:08',1),('wshorrockj','acd399d8aa81efd21efb7a225cca1efa','2021-09-25 12:08:03',1,0,'2021-09-25 06:09:03',0),('wumanyun','4cd84e281e409879656c1b444373e40e','2021-09-13 22:27:28',1,0,'2021-09-12 22:28:08',1),('wushujun','6c8bd96777d752ab05a63e4c75f217d4','2021-09-13 22:27:28',1,0,'2021-09-12 22:28:08',1),('wushujun2','fd72dc221162c40acc94088000317ac1','2021-09-13 22:27:28',1,0,'2021-09-12 22:28:08',1),('wwakesbp','89739feb01b0d008e913ce2dfeba2382','2021-09-23 20:35:00',1,0,'2021-09-22 20:35:55',2),('xiewenxuan','b45c52ccd2cdaf36e0cd1f2d6b848073','2021-09-13 22:27:28',1,0,'2021-09-12 22:28:08',1),('xsobieski15','cca12298936803de78c0bec8257f759c','2021-09-16 20:16:35',1,0,'2021-09-15 21:17:29',1),('yangjingyang','306141cb3e8bd58a135823b6cdb330a9','2021-09-13 22:27:28',1,0,'2021-09-12 22:28:08',1),('yfarfull31','4bb697d8981fd0c2c979781a3cc36132','2021-09-16 20:16:35',1,0,'2021-09-15 21:17:29',1),('yinchiliu','8c2017f24e73b23ddc5e7aff0e386b97','2021-09-13 22:27:28',1,0,'2021-09-12 22:28:08',1),('yunxiaonan','caa8bd5dbdf621b9a57a3b2a3ecfbea6','2021-09-13 22:27:28',1,0,'2021-09-12 22:28:08',1),('yuyahan','59a4204f7b8b560d87e7a0fc9bf8a023','2021-09-13 22:27:28',1,0,'2021-09-12 22:28:08',1),('yuzuiping','0ff2b59c0e20952fa483b6bc4fefb309','2021-09-13 22:25:41',1,0,'2021-09-12 22:25:56',0),('zhangruoyan','c5f928d7e0ddf9dce1937813290d0588','2021-09-13 22:27:28',1,0,'2021-09-12 22:28:08',1),('zhangxiaodie','79241e2ce49e3e70adb380fafe8a79ab','2021-09-13 22:27:28',1,0,'2021-09-12 22:28:08',1),('zhechentao','41f7be8f8b61864d0277d91c2419dd29','2021-09-13 22:27:28',1,0,'2021-09-12 22:28:08',1),('zhengmiaocui','108e26d68b3a8896e9a8754b68a945c0','2021-09-13 22:27:28',1,0,'2021-09-12 22:28:08',1),('zhezilan','e016b19cfe1b883ca780f0c064f786f0','2021-09-13 22:27:28',1,0,'2021-09-12 22:28:08',1),('zhushishan','5b2ea4edb4012d54ed39abd0bd623020','2021-09-13 22:27:28',1,0,'2021-09-12 22:28:08',1);
UNLOCK TABLES;
/*!40000 ALTER TABLE `login` ENABLE KEYS */;

--
-- Table structure for table `message`
--

DROP TABLE IF EXISTS `message`;
CREATE TABLE `message` (
  `MESSAGE_ID` int(11) NOT NULL auto_increment,
  `SEND_NAME` varchar(60) NOT NULL,
  `RECEIVE_NAME` varchar(60) NOT NULL,
  `DETAIL` varchar(255) NOT NULL,
  `SEND_TIME` datetime NOT NULL,
  `STATUS` int(11) NOT NULL,
  PRIMARY KEY  (`MESSAGE_ID`),
  KEY `fk_5` (`SEND_NAME`),
  KEY `fk_5_2` (`RECEIVE_NAME`),
  CONSTRAINT `fk_5` FOREIGN KEY (`SEND_NAME`) REFERENCES `login` (`USER_NAME`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `fk_5_2` FOREIGN KEY (`RECEIVE_NAME`) REFERENCES `login` (`USER_NAME`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `message`
--


/*!40000 ALTER TABLE `message` DISABLE KEYS */;
LOCK TABLES `message` WRITE;
INSERT INTO `message` VALUES (1,'binianer','yuzuiping','开发UABUIHODIHVLIAHSLIF发耐萨里奥回复你哦急哦麻烦ven浪费那钱·1法海配合哦IQ·节操i解放后打篮球时哦好的我i啊hi哦啊皇帝瓯海区哦i后害怕foi啊红披风和气魄嗨皮哦后viahi哦粉红色起哦','2021-09-19 20:33:39',1),(2,'yuzuiping','binianer','反倒是咖啡馆WIUGFOEH情感；·和次哦暗黑风哦IQhoi；和我到碗里的行情布林布林·','2021-09-19 20:34:03',1),(3,'binianer','baizhonglin','而父亲的分红i为HOIDH·1FSOIDHFOIQLEWIODHOIA你视力恢复','2021-09-19 20:34:36',1),(4,'baizhonglin','binianer','案发时覅去ghi哦','2021-09-19 20:34:57',1),(5,'binianer','yuzuiping','11111','2021-09-19 20:34:36',0),(6,'binianer','yuzuiping','风情地方·1','2021-09-19 22:17:32',0),(7,'penghanhan','bianyuchen','撒旦的发大财','2021-09-25 16:20:02',0),(8,'penghanhan','bianyuchen','达到擦封测阿尔法测啊','2021-09-25 16:20:22',0),(9,'binianer','yuzuiping','擦粉擦耳','2021-09-25 20:24:06',0),(10,'binianer','yuzuiping','擦粉擦耳','2021-09-25 20:24:18',0),(11,'binianer','yuzuiping','擦粉擦耳','2021-09-25 20:24:58',0),(12,'binianer','yuzuiping','擦粉擦耳','2021-09-25 20:25:07',0),(13,'penghanhan','bianyuchen','擦拭从发达','2021-09-25 21:05:14',0),(14,'hejingdie','binianer','达到挖的擦外','2021-09-25 23:00:27',1),(15,'hejingdie','binianer','安抚侧翻擦','2021-09-25 23:00:46',1),(16,'hejingdie','binianer','达到哇对策啊','2021-09-26 11:23:55',0),(17,'hejingdie','binianer','打我发出去啊出去','2021-09-26 11:24:15',0),(18,'hejingdie','binianer','111111111','2021-09-26 11:24:30',0),(19,'hejingdie','yuzuiping','挖坟侧切','2021-09-26 11:28:41',0),(20,'penghanhan','binianer','大我的钱','2021-09-26 11:41:12',0),(21,'aalmack37','abedinnh','过v而无法前往','2021-09-29 09:59:08',1),(22,'abedinnh','abedinnh','','2021-09-29 15:29:53',0),(23,'aalmack37','abedinnh','分为废弃物','2021-09-29 18:21:13',1),(24,'aalmack37','abedinnh','v的深V方式vs','2021-09-29 20:08:37',0),(25,'aalmack37','abedinnh','低洼地区','2021-09-29 20:09:04',1),(26,'huayuanchun','aalmack37','肤色乏味的无服务','2021-09-29 20:13:43',1),(27,'aalmack37','huayuanchun','而地方玩玩','2021-10-06 09:38:33',0),(28,'aalmack37','abedinnh','东西啊伤心啊','2021-10-06 09:39:11',0);
UNLOCK TABLES;
/*!40000 ALTER TABLE `message` ENABLE KEYS */;

--
-- Table structure for table `orders`
--

DROP TABLE IF EXISTS `orders`;
CREATE TABLE `orders` (
  `ORDER_ID` int(11) NOT NULL auto_increment,
  `OWNER_NAME` varchar(30) NOT NULL,
  `HIRER_NAME` varchar(30) NOT NULL,
  `START_TIME` datetime default NULL,
  `END_TIME` datetime default NULL,
  `VEHICLE_TYPE` varchar(60) NOT NULL,
  `STATUS` int(11) NOT NULL,
  `AMOUNT` double default NULL,
  `VEHICLE_ID` varchar(30) NOT NULL,
  `VEHICLE_BRAND` varchar(255) NOT NULL,
  PRIMARY KEY  (`ORDER_ID`),
  KEY `fk_4_1` (`OWNER_NAME`),
  KEY `fk_4_2` (`HIRER_NAME`),
  CONSTRAINT `fk_4_1` FOREIGN KEY (`OWNER_NAME`) REFERENCES `login` (`USER_NAME`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `fk_4_2` FOREIGN KEY (`HIRER_NAME`) REFERENCES `login` (`USER_NAME`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `orders`
--


/*!40000 ALTER TABLE `orders` DISABLE KEYS */;
LOCK TABLES `orders` WRITE;
INSERT INTO `orders` VALUES (10,'hejingdie','aalmack37',NULL,NULL,'捷达',3,NULL,'京A·0085B','大众'),(11,'hejingdie','aalmack37','2021-09-28 15:20:28','2021-09-29 15:23:40','捷达',3,240,'京A·0085B','大众'),(12,'hejingdie','aalmack37',NULL,NULL,'捷达',3,NULL,'京A·0085B','大众'),(13,'hejingdie','aalmack37','2021-09-29 17:20:34','2021-09-29 17:25:40','捷达',3,0,'京A·0085B','大众'),(14,'huayuanchun','aalmack37',NULL,NULL,'卡罗拉',3,NULL,'京A·0431B','丰田'),(15,'huayuanchun','aalmack37','2021-09-28 20:13:20','2021-09-29 20:17:50','卡罗拉',3,960,'京A·0431B','丰田'),(16,'huayuanchun','aalmack37',NULL,NULL,'卡罗拉',3,NULL,'京A·0431B','丰田'),(17,'huayuanchun','aalmack37','2021-10-06 10:03:54',NULL,'卡罗拉',1,NULL,'京A·0431B','丰田');
UNLOCK TABLES;
/*!40000 ALTER TABLE `orders` ENABLE KEYS */;

--
-- Table structure for table `owner_of_vehicle`
--

DROP TABLE IF EXISTS `owner_of_vehicle`;
CREATE TABLE `owner_of_vehicle` (
  `USER_NAME` varchar(60) NOT NULL,
  `NAME` varchar(30) NOT NULL,
  `SEX` int(11) NOT NULL,
  `ID` varchar(30) NOT NULL,
  `CREDIT` int(11) NOT NULL,
  `FREQUENCY` int(11) NOT NULL,
  `TEL` varchar(30) NOT NULL,
  `EMAIL` varchar(60) NOT NULL default '',
  `INCOME` double NOT NULL,
  PRIMARY KEY  (`USER_NAME`),
  CONSTRAINT `fk_3` FOREIGN KEY (`USER_NAME`) REFERENCES `login` (`USER_NAME`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `owner_of_vehicle`
--


/*!40000 ALTER TABLE `owner_of_vehicle` DISABLE KEYS */;
LOCK TABLES `owner_of_vehicle` WRITE;
INSERT INTO `owner_of_vehicle` VALUES ('adanilishinbn','唐语竹',0,'522528199004027082',50,0,'17756300014','spapaminas8a@google.com.br',0),('adymockcm','魏映卉',1,'340304199208059986',100,0,'18717137523','kdruery99@xing.com',500),('agilhouleybb','鲍平柏',0,'230901197208180523',100,0,'13740759773','twhisson7y@soup.io',0),('aprinn','柏水琴',1,'370830198412046921',100,0,'13562072272','oamberger78@tmall.com',500),('astonerau','赵子璇',0,'130731199810224739',100,0,'18709875886','sholyland7h@apache.org',1200),('babramovitzch','邹文杰',1,'452626198711046354',100,0,'18936131750','smadill94@archive.org',500),('bdelaceycf','卜紫雪',1,'330921199607225109',100,0,'18962565506','plivingstone92@cafepress.com',500),('bhazeldinebu','孙国栋',1,'230715198901059416',100,0,'17004258835','dlowne8h@intel.com',500),('bmillwaterba','郝宛桃',0,'410108198304012289',100,0,'17127206221','fbisiker7x@phoca.cz',0),('bsinclairecj','费痴松',1,'33090320000511376X',100,0,'13123247872','ktowler96@meetup.com',500),('bspurdensaw','王凡柔',0,'142424200906262886',100,0,'17122129860','kgriss7j@g.co',1200),('cfrancelloat','倪忆柏',0,'540126198511052541',100,0,'18974798691','jeicke7g@e-recht24.de',1200),('dalmakay','周半香',0,'370802198712201828',100,0,'13528122325','dbeaglehole7l@rediff.com',1200),('dgarlickb2','罗寄云',0,'211402198804262745',100,0,'13719248098','snorthin7p@google.com.hk',0),('dgrenvilleb4','殷如萍',0,'152631200506297963',100,0,'13017196992','tgibb7r@squarespace.com',0),('dnewlandsc7','汤灵莲',1,'640102198311305324',100,0,'17036275631','pbrinicombe8u@imdb.com',500),('dpugheaz','蒋易轩',0,'230701199805133918',100,0,'18757342999','dgouldstraw7m@spotify.com',0),('ekerrichbv','魏映卉',1,'370682201112276549',100,0,'13554275067','dgarrioch8i@rediff.com',500),('emorlingb7','朱瑾春',0,'210681199408275675',100,0,'13875456962','acollingridge7u@dailymotion.com',0),('epeasbycc','许友天',1,'513902200407057502',100,0,'17112032255','sbeidebeke8z@storify.com',500),('erawstornecq','孙若凡',1,'362334200001164905',100,0,'13502750525','ndunbobbin9d@nih.gov',500),('fchristonbl','严冰枫',0,'331081198902097836',50,0,'17786980636','miowarch88@ehow.com',0),('fpiscopob5','曹溶溶',0,'222404201501239994',100,0,'13264124034','ashoreson7s@hud.gov',0),('gcodronbc','顾新凡',0,'211404200305270380',100,0,'17160830419','tsertin7z@shareasale.com',0),('gcossemao','鲍子辰',0,'520323199510301692',90,0,'13366952714','hwhyley7b@angelfire.com',1200),('glaubx','常润莎',1,'440983198207097574',100,0,'18970230299','sdutteridge8k@wikispaces.com',500),('glefridgec4','平晨涵',1,'450102198111196295',100,0,'17055542079','ckleinplac8r@columbia.edu',500),('gmccriebw','魏欣慧',1,'410501197604224737',100,0,'17060204403','zgauche8j@wordpress.com',500),('hejingdie','华欣欣',1,'370829197711109670',59,5,'13771701654','binianer_bgi@live.com',0),('hsichc8','皮天蓝',1,'320706199407240244',100,0,'17128732570','natherley8v@istockphoto.com',500),('huashuhua','窦安白',1,'654000197005203381',100,0,'13392232896','yuzuiping_cywfv@0355.net',0),('huaxinxin','贺静蝶',1,'350300200001167041',60,0,'13532845493','douanbai_cwzen@msn.com',0),('huayuanchun','花元春',1,'370687200009274569',100,1,'18954603561','yangyiran_wg@163.net',0),('jbrothwoodbf','尹萌萌',0,'620100197006235576',50,0,'17130280792','misakov82@epa.gov',0),('jdrejercb','酆佳毅',1,'532500201506231150',100,0,'17088237314','srayner8y@japanpost.jp',500),('jiangyixuan','柏忠林',1,'340201198608214552',100,0,'17197352519','liujiayi_mb@163.com',0),('jstraceyc0','穆静露',1,'371081201606274780',100,0,'13321942844','rbalducci8n@over-blog.com',500),('kantoniottiian','穆佳昊',0,'420500197904272816',90,0,'17720829437','jswinney7a@symantec.com',1200),('kashwellbe','罗寄云',0,'330201199103152707',50,0,'13115763311','jflaunders81@geocities.com',0),('khornigcl','皮天蓝',1,'321183200809105180',100,0,'13755323807','ngaine98@nps.gov',500),('kjuleffc3','郑敏',1,'511322199812070239',100,0,'18772102845','hbohlin8q@blog.com',500),('kongxihan','韦泽惠',1,'320483200010209099',100,0,'18943645822','zhushishan_l@3721.net',0),('kongxihan2','郑妙翠',1,'532701197011099109',100,0,'13399657330','gexiafu_yjp@aol.com',0),('kspinozzibr','元雅涵',1,'210105200811183596',100,0,'13564141575','lfache8e@dyndns.org',0),('ldibdencr','鲁香曼',1,'542100201211277506',100,0,'18719025099','cogorman9e@twitter.com',500),('leiyanxue','安凡真',1,'452231200108282028',100,0,'13370306616','lexixia_zdf@yeah.com',0),('lfossickb6','葛林',0,'152222198303209814',100,0,'13101135094','mrigglesford7t@networksolutions.com',0),('lifuzi','柳嘉怡',1,'450325201206072332',100,0,'17151905438','yunxiaonan_svnbo@aol.com',0),('lihanxiang','雷雁雪',1,'513434197706130924',100,0,'13392644899','shenyichen_h@263.net',0),('liujiayi','苗润丽',0,'230712197312294772',100,0,'17718351296','weihanqin_zwin@163.net',0),('llemarchantce','沈益辰',1,'513432199402126914',100,0,'18726325040','acashen91@sun.com',500),('luchunmei','苏采灵',0,'654224200605307981',100,0,'13854318049','youchunqi_jr@msn.com',0),('luchunmei2','鲁香曼',0,'513825200007192907',100,0,'13203772464','tengxiaoyu_gikb@qq.com',0),('luxiangman','孟嘉乐',0,'520328201202232818',100,0,'13110203568','langyuchen_jbbdb@aol.com',0),('lwakelambo','赵子璇',0,'44010720000104467X',50,0,'13848817344','rsecret8b@mit.edu',0),('mcodringtonc5','韩幼烟',1,'41032419841227720X',100,0,'13748295100','cgrzeskowski8s@reference.com',500),('mcosgreavebq','魏映卉',1,'120113199101168204',100,0,'13217205207','ldineen8d@sourceforge.net',0),('mengjiale','张晓蝶',0,'22020020110602678X',100,0,'13851654604','cendandong_xcwe@263.net',0),('mgaddiebz','王尚',1,'440900197001246196',100,0,'13715012435','asimonelli8m@vkontakte.ru',500),('miaorunli','傅梦菡',0,'220623197202270907',55,0,'13186026932','huangleqiao_lhpiq@ask.com',0),('miaorunli2','孔熙涵',0,'522428197801072930',100,0,'17020917929','shijiayu_rn@qq.com',0),('mmariabj','章若雁',0,'640103199108242007',50,0,'17797713866','msweatland86@furl.net',0),('moverillc6','时巧荷',1,'452428200012280688',100,0,'18965590724','atidman8t@vistaprint.com',500),('mpashenco','任碧松',1,'542129198102039582',100,0,'13569939123','cogden9b@canalblog.com',500),('mpersickear','戚淑慧',0,'130281200510230995',90,0,'13787019002','aoppie7e@phoca.cz',1200),('msalvatib8','奚冰洁',0,'130425198312118214',100,0,'13070541079','slainton7v@ebay.com',0),('mthurlbeckbs','柳嘉怡',1,'230224201407229831',100,0,'17159130500','lfreckelton8f@patch.com',0),('mujinglu','昌伟洋',0,'131100198405100053',100,0,'17047683248','pingchihai_fjd@263.net',0),('ncromwellap','李夫子',0,'622125200706168750',90,0,'18902759527','cdobie7c@bizjournals.com',1200),('obeardsellc1','邬芷松',1,'371328199708194161',100,0,'13330936869','hquant8o@omniture.com',500),('omccraineaq','贺静蝶',0,'45010319941024354X',90,0,'13500963347','tiverson7d@lulu.com',1200),('panqiuyan','云小南',0,'532823198208245307',100,0,'13377489360','zouwenjie_sdyr@yeah.com',0),('panyifei','潘秋雁',0,'362523201612295249',41,0,'18703650381','wumanyun_oq@msn.com',0),('ppietrowskibh','戚靖萍',0,'45033020161229648X',50,0,'18731350784','clankham84@ftc.gov',0),('qtesimonam','王尚',0,'441781201008170531',90,0,'17066066663','ovandrill79@europa.eu',1200),('rblundellcs','殷晨茜',1,'331022199005186518',100,0,'13800572729','cwolfart9f@bandcamp.com',500),('rchoulesax','黄天赫',0,'140425201209195357',100,0,'13234440120','abullar7k@accuweather.com',1200),('rgavozzib3','韩幼烟',0,'210604201606044242',100,0,'17180855925','psaldler7q@cafepress.com',0),('rivanilovb9','云小南',0,'110102201204218285',100,0,'13556562926','crzehorz7w@sbwire.com',0),('rjoanicb0','王尚',0,'371001198711167796',100,0,'13507915973','nscadding7n@blogspot.com',0),('rklewicp','郑敏',1,'130706198508163356',100,0,'17109258637','zmaypes9c@weather.com',500),('rmatchittc9','陈贺祥',1,'542332197305127878',100,0,'18715458472','hdrioli8w@smh.com.au',500),('sdivellbi','凤翔',0,'220722197605047215',50,0,'13022702975','pbenz85@reverbnation.com',0),('seppsonby','和向文',1,'360729198008139840',100,0,'13741373878','jbilsland8l@hao123.com',500),('sfoynesas','朱瑾春',0,'500113201212099193',100,0,'13849819307','ppiecha7f@meetup.com',1200),('slouyscg','史曼绿',1,'320411198304129981',100,0,'17771638215','gedghinn93@who.int',500),('smurgatroydbm','费瑞辰',0,'542227199502170851',50,0,'17019306193','jrignall89@livejournal.com',0),('spiffcn','柳嘉怡',1,'371322198607293598',100,0,'18959726372','twinfred9a@hibu.com',500),('stynnancd','孙若凡',1,'513437197309285083',100,0,'17044450323','menever90@unesco.org',500),('tbrumfittca','冯国贤',1,'110104199805011979',100,0,'13125227632','yheigold8x@squidoo.com',500),('tdamantbd','孔熙涵',0,'350502200512080873',50,0,'13722334345','rmoogan80@illinois.edu',0),('tfannonc2','云小南',1,'431127199702159989',100,0,'13704042773','cmaclaverty8p@slate.com',500),('tmcnameeb1','喻醉珊',0,'450105197301048802',100,0,'17768737801','wfoxwell7o@odnoklassniki.ru',0),('tyettsbk','黄天赫',0,'513825199007157313',50,0,'18995065895','cfree87@is.gd',0),('ubarrasbg','卞语晨',0,'460005198104136492',50,0,'18714910212','akincey83@g.co',0),('vdipietroci','昌伟洋',1,'513433198101111059',100,0,'13055629421','lrapps95@chicagotribune.com',500),('vdjurisicbt','卫涵菱',1,'511502198202202709',100,0,'18961862783','bbitterton8g@huffingtonpost.com',0),('vmathivonck','孙国栋',1,'130426198908250837',100,0,'18979187103','ksyres97@wsj.com',500),('vpointinav','郑妙翠',0,'210682199307182927',100,0,'17111472735','mrushman7i@cargocollective.com',1200),('wwakesbp','柳秋柏',1,'420984201003314685',50,0,'17080016890','ddarnbrough8c@devhub.com',0);
UNLOCK TABLES;
/*!40000 ALTER TABLE `owner_of_vehicle` ENABLE KEYS */;

--
-- Table structure for table `vehicle`
--

DROP TABLE IF EXISTS `vehicle`;
CREATE TABLE `vehicle` (
  `VEHICLE_ID` varchar(30) NOT NULL default '',
  `VEHICLE_TYPE` varchar(60) NOT NULL,
  `OWNER_ID` varchar(60) NOT NULL,
  `DURATION` int(11) NOT NULL,
  `STATUS` int(11) NOT NULL,
  `RENTAL_PRICE` double NOT NULL,
  `DEADLINE` datetime default NULL,
  `LOCATION` varchar(255) NOT NULL,
  `VEHICLE_BRAND` varchar(255) NOT NULL,
  PRIMARY KEY  (`VEHICLE_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `vehicle`
--


/*!40000 ALTER TABLE `vehicle` DISABLE KEYS */;
LOCK TABLES `vehicle` WRITE;
INSERT INTO `vehicle` VALUES ('京A·0085B','捷达','hejingdie',27,2,10,'2021-11-30 23:22:58','云南省西双版纳傣族自治州勐腊县','大众'),('京A·012E2','GLK级','huashuhua',3,2,77,'2021-11-30 23:22:58','四川省攀枝花市东区','奔驰'),('京A·01660','捷达','huaxinxin',3,2,15,'2021-11-30 23:22:58','福建省漳州市东山县','大众'),('京A·0431B','卡罗拉','huayuanchun',27,1,40,'2021-11-30 23:22:58','山东省济南市平阴县','丰田'),('京A·06426','GL8','jiangyixuan',3,0,32,'2021-11-30 23:22:58','河北省保定市雄县','别克'),('京A·07B75','福克斯','kongxihan',2,0,40,'2021-11-30 23:22:58','湖南省益阳市资阳区','福特'),('京A·08CB6','C系','kongxihan2',2,0,60,'2021-11-30 23:22:58','山西省临汾地区蒲县','奔驰'),('京A·08EC2','凯美瑞','leiyanxue',2,0,26,'2021-11-30 23:22:58','甘肃省甘南藏族自治州碌曲县','丰田'),('京A·0A428','G级','lifuzi',2,0,508,'2021-11-30 23:22:58','河北省邯郸市永年县','奔驰'),('京A·0B9D2','赛欧','lihanxiang',2,0,75,'2021-11-30 23:22:58','河北省沧州市','雪佛兰'),('京A·0BCB8','普拉多','liujiayi',6,0,51,'2021-11-30 23:22:58','重庆市潼南县','丰田'),('京A·0C433','Q3','luchunmei',6,0,45,'2021-11-30 23:22:58','辽宁省丹东市振兴区','奥迪'),('京A·0D2DB','野马','luchunmei2',6,0,88,'2021-11-30 23:22:58','吉林省四平市市辖区','福特'),('京A·0D578','C系','luxiangman',6,0,56,'2021-11-30 23:22:58','贵州省贵阳市白云区','奔驰'),('京A·0D8B3','汉兰达','mengjiale',6,0,39,'2021-11-30 23:22:58','江西省萍乡市上栗县','丰田'),('京A·0DDBF','昂科拉','miaorunli',6,0,30,'2021-11-30 23:22:58','广东省湛江市麻章区','别克'),('京A·0EC49','C系','miaorunli2',24,0,61,'2021-11-30 23:22:58','广东省阳江市阳东县','奔驰'),('京A·0EEE3','GLK级','mujinglu',24,0,78,'2021-11-30 23:22:58','湖北省黄石市','奔驰'),('京A·0F700','CC','panqiuyan',24,2,16,'2021-11-30 23:22:58','四川省成都市锦江区','大众'),('京A·11C0C','迈锐宝','panyifei',24,0,17,'2021-11-30 23:22:58','新疆维吾尔族自治区巴音郭楞蒙古自治州','雪佛兰'),('冀C·97E14','2系','kmckennanal',0,0,108,'2021-10-14 20:42:04','陕西省西安市蓝田县','宝马'),('冀C·993C2','威驰','qtesimonam',20,2,96,'2021-10-10 20:41:47','山西省临汾地区大宁县','丰田'),('冀C·99A39','A3','kantoniottiian',20,2,32,'2021-10-10 20:41:47','江苏省常州市金坛市','奥迪'),('冀C·9DE6D','君越','gcossemao',20,2,103,'2021-10-10 20:41:47','内蒙古自治区兴安盟突泉县','别克'),('冀C·9E9A6','高尔夫嘉旅','ncromwellap',20,2,96,'2021-10-10 20:41:47','安徽省滁州市全椒县','大众'),('冀C·9FD46','高尔夫嘉旅','omccraineaq',20,0,32,'2021-10-10 20:41:47','山西省临汾地区侯马市','大众'),('冀C·9FDC7','捷达','mpersickear',20,0,103,'2021-10-10 20:41:47','湖南省郴州市汝城县','大众'),('冀C·9FDD9','唯雅诺','sfoynesas',20,0,96,'2021-10-10 20:41:47','黑龙江省黑河市孙吴县','奔驰'),('冀C·A172F','朗逸','cfrancelloat',20,0,32,'2021-10-10 20:41:47','内蒙古自治区呼伦贝尔盟扎兰屯市','大众'),('冀C·A17E8','朗逸','astonerau',20,0,62,'2021-10-10 20:41:47','贵州省贵阳市清镇市','大众'),('冀C·A3BBD','X1','vpointinav',20,0,45,'2021-10-10 20:41:47','河北省保定市阜平县','宝马'),('冀C·AD570','威驰','bspurdensaw',20,0,79,'2021-10-10 20:41:47','山西省晋城市阳城县','丰田'),('冀C·AE40E','X1','rchoulesax',20,0,66,'2021-10-10 20:41:47','新疆维吾尔族自治区阿克苏地区新和县','宝马'),('冀C·AF29D','威霆','dalmakay',20,0,108,'2021-10-10 20:41:47','辽宁省营口市大石桥市','奔驰'),('冀C·B0178','Panamera','dpugheaz',20,0,108,'2021-10-10 20:41:47','上海市县','保时捷'),('冀C·B0784','凯越','rjoanicb0',20,0,108,'2021-10-10 20:41:47','河北省保定市安新县','别克'),('冀C·B1C7C','迈锐宝','tmcnameeb1',20,0,108,'2021-10-10 20:41:47','吉林省吉林市磐石市','雪佛兰'),('冀C·B1DE2','帕萨特','dgarlickb2',20,0,108,'2021-10-10 20:41:47','云南省昭通地区水富县','大众'),('冀C·B42C9','CC','rgavozzib3',20,0,108,'2021-10-10 20:41:47','河北省承德市平泉县','大众'),('冀C·B43E0','2系','dgrenvilleb4',20,0,108,'2021-10-10 20:41:47','山东省淄博市淄川区','宝马'),('冀C·B45BD','凯越','fpiscopob5',20,0,108,'2021-10-10 20:41:47','贵州省六盘水市','别克'),('冀C·B4D98','C系','lfossickb6',20,0,108,'2021-10-10 20:41:47','福建省福州市福清市','奔驰'),('冀C·B5E64','凯越','emorlingb7',20,0,108,'2021-10-10 20:41:47','浙江省嘉兴市桐乡市','别克'),('冀C·B6205','CC','msalvatib8',20,0,108,'2021-10-10 20:41:47','河南省三门峡市湖滨区','大众'),('冀C·B9A9B','C系','rivanilovb9',10,0,108,'2021-10-10 20:41:47','云南省怒江傈僳族自治州贡山独龙族怒族自治县','奔驰'),('冀C·BA744','威霆','bmillwaterba',10,0,108,'2021-10-10 20:41:47','四川省宜宾市长宁县','奔驰'),('冀C·BB1F2','RAV4荣放','agilhouleybb',10,0,108,'2021-10-10 20:41:47','黑龙江省七台河市','丰田'),('冀C·BDFD7','昂科拉','gcodronbc',10,0,108,'2021-10-10 20:41:47','四川省南充市南部县','别克'),('冀C·BE561','凯越','tdamantbd',10,0,108,'2021-10-10 20:41:47','海南省三亚市白沙黎族自治县','别克'),('冀C·BEE9A','唯雅诺','kashwellbe',10,0,108,'2021-10-10 20:41:47','云南省保山地区昌宁县','奔驰'),('冀C·BFA1D','唯雅诺','jbrothwoodbf',10,0,108,'2021-10-10 20:41:47','甘肃省平凉地区','奔驰'),('冀C·C31D3','X1','ubarrasbg',10,0,108,'2021-10-14 20:42:04','湖南省永州市市辖区','宝马'),('冀C·C395A','卡罗拉','ppietrowskibh',10,0,108,'2021-10-14 20:42:04','云南省大理白族自治州漾濞彝族自治县','丰田'),('冀C·C3F24','皇冠','sdivellbi',10,0,108,'2021-10-14 20:42:04','青海省果洛藏族自治州玛沁县','丰田'),('冀C·C400A','RAV4荣放','mmariabj',10,0,108,'2021-10-14 20:42:04','黑龙江省哈尔滨市','丰田'),('冀C·C9193','A3','tyettsbk',10,0,108,'2021-10-14 20:42:04','西藏自治区那曲地区那曲县','奥迪'),('冀C·CA817','GLK级','fchristonbl',10,0,108,'2021-10-14 20:42:04','湖北省宜昌市西陵区','奔驰'),('冀C·CA9B6','GL8','smurgatroydbm',10,0,108,'2021-10-14 20:42:04','吉林省四平市','别克'),('冀C·CAEB6','A3','adanilishinbn',10,0,108,'2021-10-14 20:42:04','四川省宜宾市','奥迪'),('冀C·CB70A','卡罗拉','lwakelambo',10,0,108,'2021-10-14 20:42:04','江苏省扬州市宝应县','丰田'),('冀C·CB86C','乐风RV','wwakesbp',10,0,108,'2021-10-14 20:42:04','湖北省荆州市松滋市','雪佛兰'),('冀C·CC957','高尔夫嘉旅','mcosgreavebq',10,0,108,'2021-10-14 20:42:04','山西省忻州地区静乐县','大众'),('冀C·D00B0','福克斯','kspinozzibr',10,0,108,'2021-10-14 20:42:04','云南省红河哈尼族彝族自治州河口瑶族自治县','福特'),('冀C·D0ADC','Panamera','mthurlbeckbs',10,0,108,'2021-10-14 20:42:04','内蒙古自治区呼和浩特市玉泉区','保时捷'),('冀C·D1DA3','昂科威','vdjurisicbt',0,0,108,'2021-10-14 20:42:04','山东省菏泽地区菏泽市','别克'),('冀C·D228F','Panamera','bhazeldinebu',0,0,108,'2021-10-14 20:42:04','广东省肇庆市封开县','保时捷'),('冀C·D2747','昂科拉','ekerrichbv',0,0,108,'2021-10-14 20:42:04','山西省临汾地区洪洞县','别克'),('冀C·D368E','花冠','gmccriebw',0,0,108,'2021-10-14 20:42:04','海南省三亚市儋州市','丰田'),('冀C·D42B7','迈锐宝','glaubx',0,0,108,'2021-10-14 20:42:04','河北省邢台市任县','雪佛兰'),('冀C·D46BC','汉兰达','seppsonby',0,0,108,'2021-10-14 20:42:04','甘肃省定西地区通渭县','丰田'),('冀C·D7487','威驰','mgaddiebz',0,0,108,'2021-10-14 20:42:04','四川省南充市仪陇县','丰田'),('冀C·D85D3','凯越','jstraceyc0',0,0,108,'2021-10-14 20:42:04','云南省曲靖市市辖区','别克'),('冀C·D963C','捷达','obeardsellc1',0,0,108,'2021-10-14 20:42:04','广西壮族自治区南宁市邕宁县','大众'),('冀C·D9E5D','A6L','tfannonc2',0,0,108,'2021-10-14 20:42:04','福建省三明市宁化县','奥迪'),('冀C·DA588','A6L','kjuleffc3',0,0,108,'2021-10-14 20:42:04','江西省吉安地区吉安市','奥迪'),('冀C·DADFE','凯美瑞','glefridgec4',0,0,108,'2021-10-14 20:42:04','安徽省芜湖市新芜区','丰田'),('冀C·DD372','普拉多','mcodringtonc5',0,0,108,'2021-10-14 20:42:04','广东省深圳市宝安区','丰田'),('冀C·DF4C9','威霆','moverillc6',0,0,108,'2021-10-14 20:42:04','四川省南充市嘉陵区','奔驰'),('冀C·E1567','君越','dnewlandsc7',0,0,108,'2021-10-14 20:42:04','福建省南平市顺昌县','别克'),('冀C·E40A5','福克斯','hsichc8',0,0,108,'2021-10-14 20:42:04','河北省张家口市宣化区','福特'),('冀C·E42E3','唯雅诺','rmatchittc9',0,0,108,'2021-10-14 20:42:04','黑龙江省哈尔滨市阿城市','奔驰'),('冀C·E88E8','君越','tbrumfittca',0,0,108,'2021-10-14 20:42:04','山西省忻州地区方山县','别克'),('冀C·EBC1B','唯雅诺','jdrejercb',0,0,108,'2021-10-14 20:42:04','河北省邯郸市广平县','奔驰'),('冀C·EC788','1系','epeasbycc',0,0,108,'2021-10-14 20:42:04','吉林省长春市榆树市','宝马'),('冀C·ED2E0','G级','stynnancd',0,0,108,'2021-10-14 20:42:04','宁夏回族自治区吴忠市市辖区','奔驰'),('冀C·EE8B5','CC','llemarchantce',0,0,108,'2021-10-14 20:42:04','天津市北辰区','大众'),('冀C·F159E','皇冠','bdelaceycf',0,0,108,'2021-10-14 20:42:04','广东省阳江市阳春市','丰田'),('冀C·F1712','1系','slouyscg',0,0,108,'2021-10-14 20:42:04','山东省济南市市中区','宝马'),('冀C·F1899','朗逸','babramovitzch',0,0,108,'2021-10-14 20:42:04','河北省承德市双滦区','大众'),('冀C·F2634','X1','vdipietroci',0,0,108,'2021-10-14 20:42:04','吉林省长春市农安县','宝马'),('冀C·F2703','野马','bsinclairecj',0,0,108,'2021-10-14 20:42:04','辽宁省沈阳市辽中县','福特'),('冀C·F34C8','昂科威','vmathivonck',0,0,108,'2021-10-14 20:42:04','重庆市长寿县','别克'),('冀C·F4217','X1','khornigcl',0,0,108,'2021-10-14 20:42:04','江苏省徐州市泉山区','宝马'),('冀C·F479A','野马','adymockcm',0,0,108,'2021-10-14 20:42:04','内蒙古自治区伊克昭盟伊金霍洛旗','福特'),('冀C·F60EE','凯越','spiffcn',0,0,108,'2021-10-14 20:42:04','贵州省铜仁地区铜仁市','别克'),('冀C·F9299','C级','mpashenco',0,0,108,'2021-10-14 20:42:04','四川省成都市崇州市','奔驰'),('冀C·FA4E6','猛禽','rklewicp',0,0,108,'2021-10-14 20:42:04','甘肃省甘南藏族自治州卓尼县','福特'),('冀C·FA54B','凯美瑞','erawstornecq',0,0,108,'2021-10-14 20:42:04','吉林省松原市市辖区','丰田'),('冀C·FAC6C','凯越','ldibdencr',0,0,108,'2021-10-14 20:42:04','江苏省徐州市泉山区','别克'),('冀C·FB4EC','C级','rblundellcs',0,0,108,'2021-10-14 20:42:04','湖北省武汉市蔡甸区','奔驰'),('豫A·99999','野马','hejingdie',0,0,108.57,'2021-10-10 11:15:00','河南省南阳市镇平县','福特'),('豫R·0085B','捷达','huayuanchun',0,0,100,'2021-10-10 20:15:00','河南南阳','大众');
UNLOCK TABLES;
/*!40000 ALTER TABLE `vehicle` 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 */;