1 2alter table PAGES add column TYPE TEXT; 3alter table PAGES add column LANG TEXT; 4alter table PAGES add column WORD_COUNT INTEGER; 5alter table PAGES add column IS_LOW_QUALITY INTEGER; 6alter table PAGES add column DATE_START TEXT; 7alter table PAGES add column DATE_END TEXT; 8alter table PAGES add column COUNTRY TEXT; 9 10create index if not exists WORD_COUNT ON PAGES (WORD_COUNT); 11create index if not exists LANG ON PAGES (LANG); 12create index if not exists IS_LOW_QUALITY ON PAGES (IS_LOW_QUALITY); 13create index if not exists TYPE ON PAGES (TYPE); 14create index if not exists DATE_START ON PAGES (DATE_START DESC); 15create index if not exists DATE_END ON PAGES (DATE_END DESC); 16 17 18 19 20 21 22