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