diff --git a/modules/miscutil/sql/tabbibclean.sql b/modules/miscutil/sql/tabbibclean.sql index 31d9afe30..7ec58e0d1 100644 --- a/modules/miscutil/sql/tabbibclean.sql +++ b/modules/miscutil/sql/tabbibclean.sql @@ -1,245 +1,248 @@ 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 idxWORD01R; TRUNCATE idxWORD02R; TRUNCATE idxWORD03R; TRUNCATE idxWORD04R; TRUNCATE idxWORD05R; TRUNCATE idxWORD06R; TRUNCATE idxWORD07R; TRUNCATE idxWORD08R; TRUNCATE idxWORD09R; TRUNCATE idxWORD10R; TRUNCATE idxPHRASE01F; TRUNCATE idxPHRASE02F; TRUNCATE idxPHRASE03F; TRUNCATE idxPHRASE04F; TRUNCATE idxPHRASE05F; TRUNCATE idxPHRASE06F; TRUNCATE idxPHRASE07F; TRUNCATE idxPHRASE08F; TRUNCATE idxPHRASE09F; TRUNCATE idxPHRASE10F; TRUNCATE idxPHRASE01R; TRUNCATE idxPHRASE02R; TRUNCATE idxPHRASE03R; TRUNCATE idxPHRASE04R; TRUNCATE idxPHRASE05R; TRUNCATE idxPHRASE06R; TRUNCATE idxPHRASE07R; TRUNCATE idxPHRASE08R; TRUNCATE idxPHRASE09R; TRUNCATE idxPHRASE10R; TRUNCATE rnkMETHODDATA; TRUNCATE rnkWORD01F; -TRUNCATE rnkWORD01R; \ No newline at end of file +TRUNCATE rnkWORD01R; +TRUNCATE bibdoc; +TRUNCATE bibrec_bibdoc; +TRUNCATE bibdoc_bibdoc; \ No newline at end of file