Homec4science
Diffusion invenio-infoscience (maint-2.0) Browse

R3600/invenio/legacy/miscutil/sql/tabbibclean.sql
cbef1d133555maint-2.0

Last Change
Raw File

tabbibclean.sql
View Options

TRUNCATE bibrec;
TRUNCATE bib00x;
TRUNCATE bib01x;
TRUNCATE bib02x;
TRUNCATE bib03x;
TRUNCATE bib04x;
TRUNCATE bib05x;
TRUNCATE bib06x;
TRUNCATE bib07x;
TRUNCATE bib08x;
TRUNCATE bib09x;
TRUNCATE bib10x;
TRUNCATE bib11x;
TRUNCATE bib12x;
TRUNCATE bib13x;
TRUNCATE bib14x;
TRUNCATE bib15x;
TRUNCATE bib16x;
TRUNCATE bib17x;
TRUNCATE bib18x;
TRUNCATE bib19x;
TRUNCATE bib20x;
TRUNCATE bib21x;
TRUNCATE bib22x;
TRUNCATE bib23x;
TRUNCATE bib24x;
TRUNCATE bib25x;
TRUNCATE bib26x;
TRUNCATE bib27x;
TRUNCATE bib28x;
TRUNCATE bib29x;
TRUNCATE bib30x;
TRUNCATE bib31x;
TRUNCATE bib32x;
TRUNCATE bib33x;
TRUNCATE bib34x;
TRUNCATE bib35x;
TRUNCATE bib36x;
TRUNCATE bib37x;
TRUNCATE bib38x;
TRUNCATE bib39x;
TRUNCATE bib40x;
TRUNCATE bib41x;
TRUNCATE bib42x;
TRUNCATE bib43x;
TRUNCATE bib44x;
TRUNCATE bib45x;
TRUNCATE bib46x;
TRUNCATE bib47x;
TRUNCATE bib48x;
TRUNCATE bib49x;
TRUNCATE bib50x;
TRUNCATE bib51x;
TRUNCATE bib52x;
TRUNCATE bib53x;
TRUNCATE bib54x;
TRUNCATE bib55x;
TRUNCATE bib56x;
TRUNCATE bib57x;
TRUNCATE bib58x;
TRUNCATE bib59x;
TRUNCATE bib60x;
TRUNCATE bib61x;
TRUNCATE bib62x;
TRUNCATE bib63x;
TRUNCATE bib64x;
TRUNCATE bib65x;
TRUNCATE bib66x;
TRUNCATE bib67x;
TRUNCATE bib68x;
TRUNCATE bib69x;
TRUNCATE bib70x;
TRUNCATE bib71x;
TRUNCATE bib72x;
TRUNCATE bib73x;
TRUNCATE bib74x;
TRUNCATE bib75x;
TRUNCATE bib76x;
TRUNCATE bib77x;
TRUNCATE bib78x;
TRUNCATE bib79x;
TRUNCATE bib80x;
TRUNCATE bib81x;
TRUNCATE bib82x;
TRUNCATE bib83x;
TRUNCATE bib84x;
TRUNCATE bib85x;
TRUNCATE bib86x;
TRUNCATE bib87x;
TRUNCATE bib88x;
TRUNCATE bib89x;
TRUNCATE bib90x;
TRUNCATE bib91x;
TRUNCATE bib92x;
TRUNCATE bib93x;
TRUNCATE bib94x;
TRUNCATE bib95x;
TRUNCATE bib96x;
TRUNCATE bib97x;
TRUNCATE bib98x;
TRUNCATE bib99x;
TRUNCATE bibrec_bib00x;
TRUNCATE bibrec_bib01x;
TRUNCATE bibrec_bib02x;
TRUNCATE bibrec_bib03x;
TRUNCATE bibrec_bib04x;
TRUNCATE bibrec_bib05x;
TRUNCATE bibrec_bib06x;
TRUNCATE bibrec_bib07x;
TRUNCATE bibrec_bib08x;
TRUNCATE bibrec_bib09x;
TRUNCATE bibrec_bib10x;
TRUNCATE bibrec_bib11x;
TRUNCATE bibrec_bib12x;
TRUNCATE bibrec_bib13x;
TRUNCATE bibrec_bib14x;
TRUNCATE bibrec_bib15x;
TRUNCATE bibrec_bib16x;
TRUNCATE bibrec_bib17x;
TRUNCATE bibrec_bib18x;
TRUNCATE bibrec_bib19x;
TRUNCATE bibrec_bib20x;
TRUNCATE bibrec_bib21x;
TRUNCATE bibrec_bib22x;
TRUNCATE bibrec_bib23x;
TRUNCATE bibrec_bib24x;
TRUNCATE bibrec_bib25x;
TRUNCATE bibrec_bib26x;
TRUNCATE bibrec_bib27x;
TRUNCATE bibrec_bib28x;
TRUNCATE bibrec_bib29x;
TRUNCATE bibrec_bib30x;
TRUNCATE bibrec_bib31x;
TRUNCATE bibrec_bib32x;
TRUNCATE bibrec_bib33x;
TRUNCATE bibrec_bib34x;
TRUNCATE bibrec_bib35x;
TRUNCATE bibrec_bib36x;
TRUNCATE bibrec_bib37x;
TRUNCATE bibrec_bib38x;
TRUNCATE bibrec_bib39x;
TRUNCATE bibrec_bib40x;
TRUNCATE bibrec_bib41x;
TRUNCATE bibrec_bib42x;
TRUNCATE bibrec_bib43x;
TRUNCATE bibrec_bib44x;
TRUNCATE bibrec_bib45x;
TRUNCATE bibrec_bib46x;
TRUNCATE bibrec_bib47x;
TRUNCATE bibrec_bib48x;
TRUNCATE bibrec_bib49x;
TRUNCATE bibrec_bib50x;
TRUNCATE bibrec_bib51x;
TRUNCATE bibrec_bib52x;
TRUNCATE bibrec_bib53x;
TRUNCATE bibrec_bib54x;
TRUNCATE bibrec_bib55x;
TRUNCATE bibrec_bib56x;
TRUNCATE bibrec_bib57x;
TRUNCATE bibrec_bib58x;
TRUNCATE bibrec_bib59x;
TRUNCATE bibrec_bib60x;
TRUNCATE bibrec_bib61x;
TRUNCATE bibrec_bib62x;
TRUNCATE bibrec_bib63x;
TRUNCATE bibrec_bib64x;
TRUNCATE bibrec_bib65x;
TRUNCATE bibrec_bib66x;
TRUNCATE bibrec_bib67x;
TRUNCATE bibrec_bib68x;
TRUNCATE bibrec_bib69x;
TRUNCATE bibrec_bib70x;
TRUNCATE bibrec_bib71x;
TRUNCATE bibrec_bib72x;
TRUNCATE bibrec_bib73x;
TRUNCATE bibrec_bib74x;
TRUNCATE bibrec_bib75x;
TRUNCATE bibrec_bib76x;
TRUNCATE bibrec_bib77x;
TRUNCATE bibrec_bib78x;
TRUNCATE bibrec_bib79x;
TRUNCATE bibrec_bib80x;
TRUNCATE bibrec_bib81x;
TRUNCATE bibrec_bib82x;
TRUNCATE bibrec_bib83x;
TRUNCATE bibrec_bib84x;
TRUNCATE bibrec_bib85x;
TRUNCATE bibrec_bib86x;
TRUNCATE bibrec_bib87x;
TRUNCATE bibrec_bib88x;
TRUNCATE bibrec_bib89x;
TRUNCATE bibrec_bib90x;
TRUNCATE bibrec_bib91x;
TRUNCATE bibrec_bib92x;
TRUNCATE bibrec_bib93x;
TRUNCATE bibrec_bib94x;
TRUNCATE bibrec_bib95x;
TRUNCATE bibrec_bib96x;
TRUNCATE bibrec_bib97x;
TRUNCATE bibrec_bib98x;
TRUNCATE bibrec_bib99x;
TRUNCATE bibfmt;
TRUNCATE idxWORD01F;
TRUNCATE idxWORD02F;
TRUNCATE idxWORD03F;
TRUNCATE idxWORD04F;
TRUNCATE idxWORD05F;
TRUNCATE idxWORD06F;
TRUNCATE idxWORD07F;
TRUNCATE idxWORD08F;
TRUNCATE idxWORD09F;
TRUNCATE idxWORD10F;
TRUNCATE idxWORD11F;
TRUNCATE idxWORD12F;
TRUNCATE idxWORD13F;
TRUNCATE idxWORD14F;
TRUNCATE idxWORD15F;
TRUNCATE idxWORD16F;
TRUNCATE idxWORD17F;
TRUNCATE idxWORD18F;
TRUNCATE idxWORD19F;
TRUNCATE idxWORD20F;
TRUNCATE idxWORD21F;
TRUNCATE idxWORD22F;
TRUNCATE idxWORD23F;
TRUNCATE idxWORD01R;
TRUNCATE idxWORD02R;
TRUNCATE idxWORD03R;
TRUNCATE idxWORD04R;
TRUNCATE idxWORD05R;
TRUNCATE idxWORD06R;
TRUNCATE idxWORD07R;
TRUNCATE idxWORD08R;
TRUNCATE idxWORD09R;
TRUNCATE idxWORD10R;
TRUNCATE idxWORD11R;
TRUNCATE idxWORD12R;
TRUNCATE idxWORD13R;
TRUNCATE idxWORD14R;
TRUNCATE idxWORD15R;
TRUNCATE idxWORD16R;
TRUNCATE idxWORD17R;
TRUNCATE idxWORD18R;
TRUNCATE idxWORD19R;
TRUNCATE idxWORD20R;
TRUNCATE idxWORD21R;
TRUNCATE idxWORD22R;
TRUNCATE idxWORD23R;
TRUNCATE idxPAIR01F;
TRUNCATE idxPAIR02F;
TRUNCATE idxPAIR03F;
TRUNCATE idxPAIR04F;
TRUNCATE idxPAIR05F;
TRUNCATE idxPAIR06F;
TRUNCATE idxPAIR07F;
TRUNCATE idxPAIR08F;
TRUNCATE idxPAIR09F;
TRUNCATE idxPAIR10F;
TRUNCATE idxPAIR11F;
TRUNCATE idxPAIR12F;
TRUNCATE idxPAIR13F;
TRUNCATE idxPAIR14F;
TRUNCATE idxPAIR15F;
TRUNCATE idxPAIR16F;
TRUNCATE idxPAIR17F;
TRUNCATE idxPAIR18F;
TRUNCATE idxPAIR19F;
TRUNCATE idxPAIR20F;
TRUNCATE idxPAIR21F;
TRUNCATE idxPAIR22F;
TRUNCATE idxPAIR23F;
TRUNCATE idxPAIR01R;
TRUNCATE idxPAIR02R;
TRUNCATE idxPAIR03R;
TRUNCATE idxPAIR04R;
TRUNCATE idxPAIR05R;
TRUNCATE idxPAIR06R;
TRUNCATE idxPAIR07R;
TRUNCATE idxPAIR08R;
TRUNCATE idxPAIR09R;
TRUNCATE idxPAIR10R;
TRUNCATE idxPAIR11R;
TRUNCATE idxPAIR12R;
TRUNCATE idxPAIR13R;
TRUNCATE idxPAIR14R;
TRUNCATE idxPAIR15R;
TRUNCATE idxPAIR16R;
TRUNCATE idxPAIR17R;
TRUNCATE idxPAIR18R;
TRUNCATE idxPAIR19R;
TRUNCATE idxPAIR20R;
TRUNCATE idxPAIR21R;
TRUNCATE idxPAIR22R;
TRUNCATE idxPAIR23R;
TRUNCATE idxPHRASE01F;
TRUNCATE idxPHRASE02F;
TRUNCATE idxPHRASE03F;
TRUNCATE idxPHRASE04F;
TRUNCATE idxPHRASE05F;
TRUNCATE idxPHRASE06F;
TRUNCATE idxPHRASE07F;
TRUNCATE idxPHRASE08F;
TRUNCATE idxPHRASE09F;
TRUNCATE idxPHRASE10F;
TRUNCATE idxPHRASE11F;
TRUNCATE idxPHRASE12F;
TRUNCATE idxPHRASE13F;
TRUNCATE idxPHRASE14F;
TRUNCATE idxPHRASE15F;
TRUNCATE idxPHRASE16F;
TRUNCATE idxPHRASE17F;
TRUNCATE idxPHRASE18F;
TRUNCATE idxPHRASE19F;
TRUNCATE idxPHRASE20F;
TRUNCATE idxPHRASE21F;
TRUNCATE idxPHRASE22F;
TRUNCATE idxPHRASE23F;
TRUNCATE idxPHRASE01R;
TRUNCATE idxPHRASE02R;
TRUNCATE idxPHRASE03R;
TRUNCATE idxPHRASE04R;
TRUNCATE idxPHRASE05R;
TRUNCATE idxPHRASE06R;
TRUNCATE idxPHRASE07R;
TRUNCATE idxPHRASE08R;
TRUNCATE idxPHRASE09R;
TRUNCATE idxPHRASE10R;
TRUNCATE idxPHRASE11R;
TRUNCATE idxPHRASE12R;
TRUNCATE idxPHRASE13R;
TRUNCATE idxPHRASE14R;
TRUNCATE idxPHRASE15R;
TRUNCATE idxPHRASE16R;
TRUNCATE idxPHRASE17R;
TRUNCATE idxPHRASE18R;
TRUNCATE idxPHRASE19R;
TRUNCATE idxPHRASE20R;
TRUNCATE idxPHRASE21R;
TRUNCATE idxPHRASE22R;
TRUNCATE idxPHRASE23R;
TRUNCATE rnkMETHODDATA;
TRUNCATE rnkCITATIONDATAEXT;
TRUNCATE rnkAUTHORDATA;
TRUNCATE rnkRECORDSCACHE;
TRUNCATE rnkEXTENDEDAUTHORS;
TRUNCATE rnkSELFCITES;
TRUNCATE rnkDOWNLOADS;
TRUNCATE rnkPAGEVIEWS;
TRUNCATE rnkWORD01F;
TRUNCATE rnkWORD01R;
TRUNCATE bibdoc;
TRUNCATE bibrec_bibdoc;
TRUNCATE bibdoc_bibdoc;
TRUNCATE bibdocmoreinfo;
TRUNCATE bibdocfsinfo;
TRUNCATE sbmAPPROVAL;
TRUNCATE sbmSUBMISSIONS;
TRUNCATE sbmPUBLICATION;
TRUNCATE sbmPUBLICATIONCOMM;
TRUNCATE sbmPUBLICATIONDATA;
TRUNCATE hstRECORD;
TRUNCATE hstDOCUMENT;
TRUNCATE bibHOLDINGPEN;
TRUNCATE hstEXCEPTION;
TRUNCATE aidPERSONIDDATA;
TRUNCATE aidRESULTS;
TRUNCATE aidCACHE;
TRUNCATE aidPERSONIDPAPERS;
TRUNCATE aidUSERINPUTLOG;
TRUNCATE aidDENSEINDEX;
TRUNCATE aidINVERTEDLISTS;
TRUNCATE lnkENTRY;
TRUNCATE lnkENTRYURLTITLE;
TRUNCATE lnkENTRYLOG;
TRUNCATE lnkLOG;
TRUNCATE lnkADMINURL;
TRUNCATE lnkADMINURLLOG;
TRUNCATE wapCACHE;
TRUNCATE goto;
TRUNCATE bibcheck_rules;
c4science · Help