Patstat october 2013 mysql upload scripts

October 2013 patstat ediction contains a lot of changes and new tables (especially from persons' side)
Here you can download the mysql scripts I made for uploading the files from DVDs data.

remember to customize them for your own upload idrectory / target library
also note I did not upload TLS 203, 222 and 223 but scripts should work fine

Here below a comparison with expected records and october 2012 version
(odd: TLS209 has decreased, probably due to introduction of TLS224?)

table	date of files	declared	patstat Y-1	imported	delta imp	delta y-1
TLS201_APPLN	201310	76594275	73177050	76594275	0	4.67%
TLS202_APPLN_TITLE	201310	57335762	54184267	57335737	25	5.82%
TLS203_APPLN_ABSTR	201310	33870394	31187723	0	33,870,394	8.60%
TLS204_APPLN_PRIOR	201310	33615459	32125776	33,615,459	0	4.64%
TLS205_TECH_REL	201310	2138085	2131770	2,138,085	0	0.30%
TLS206_PERSON	201310	44730405	41478412	44,730,372	33	7.84%
TLS207_PERS_APPLN	201310	163534542	152682496	163,534,542	0	7.11%
TLS208_DOC_STD_NMS	201310	19409591	18766111	19,409,591	0	3.43%
TLS209_APPLN_IPC	201310	176153334	177915634	176,153,334	0	-0.99%
TLS210_APPLN_N_CLS	201310	21884148	21844519	21,884,148	0	0.18%
TLS211_PAT_PUBLN	201310	85733781	82561787	85,733,781	0	3.84%
TLS212_CITATION	201310	142247157	125658281	142,247,157	0	13.20%
TLS214_NPL_PUBLN	201310	22095090	19128778	22,095,084	6	15.51%
TLS215_CITN_CATEG	201310	22390889	20850431	22,390,891	-2	7.39%
TLS216_APPLN_CONTN	201310	2272520	2104686	2,272,520	0	7.97%
TLS218_DOCDB_FAM	201310	67766434	64571193	67,766,434	0	4.95%
TLS219_INPADOC_FAM	201310	74865923	73177050	74,865,923	0	2.31%
TLS221_INPADOC_PRS	201310	135555494	111194984			21.91%
TLS222_APPLN_JP_CLASS	201310	294109156	285734975		294,109,156	2.93%
TLS223_APPLN_DOCUS	201310	36668997	33590420		36,668,997	9.17%
tls224_appln_cpc	201310	137478291	not existing	137,478,291	0
tls226_person_orig	201310	47699382	not existing	47,699,382	0
tls227_pers_publn	201310	193982180	not existing	193,982,180	0