development.sql

----fltincome
insert into fltincome (fltdate,fltyearmonth,fltyear,fltmonth,fltweek,fltday,freq,carrier,carriername,carriernameunion,flttype,fltno,segment,segmentarea,segmenttype,segmentname,line,lineround,lineroundname,linearea,linetype,linename,sfcode,sfcityname,sfcompany,sfairport,sfcitytype,arrcode,arrcityname,arrcompany,arrairport,arrcitytype,pno,pmodel,dpttime,charterflag,shareflag,overtimeflag,moneyflag,company,fltnum,num,legnum,seat,seatseg,seatleg,booking,bookingadd,groupnum,eticketbooking,eticketbookingper,boarding,boardingadd,kegongli,kegongliadd,loadfactorseg,loadfactorleg,averageprice,kegongliincome,fullseat,fullprice,fullpricey,income,incomeper,incomeindex,zuogongliseg,zuogonglileg,zuogongliper,zuogongliincomeseg,zuogongliincomeleg,firstboarding,firstboardingadd,firstseat,firstincome,firstseatleg,businessboarding,businessboardingadd,businessseat,businessincome,businessseatleg,hvpboarding,hvpboardingadd,hvpseat,hvpincome,hvpseatleg,economyboarding,economyboardingadd,economyseat,economyincome,economyseatleg,insurance,oil)  
values('2013/5/7 0:00:00','201305','2013','05','19','7','2','3U','川航','川航','联程','3U8721','KMG-CKG','中国','国内','昆明-重庆','KMG-CKG-YIH','KMG-CKG-YIH','昆明-重庆-宜昌','中国','国内','昆明-重庆-宜昌','KMG','昆明','KMG','KMG','国内','CKG','重庆','CKG','CKG','国内','','320','655','0','0','0','0','','1','1','1','108','163','163','95','143','10','95','1','95','143','61655','92807','0.582822085889571','0.877300613496933','245.510526315789','0.378290487389506','118570','67450','67450','23323.5','53920.8','0.201533742331288','105787','105787','95763','0.220476050932534','0.220476050932534','0','0','0','0','8','0','0','0','0','0','0','0','0','0','0','95','143','103','23323.5','155','0','5985');

----