1 2alter table PAGES add column DATE_MODIFIED TEXT; 3alter table PAGES add column DATE_CREATED TEXT; 4alter table PAGES add column DATE_PUBLISHED TEXT; 5alter table PAGES add column PATH TEXT; 6alter table PAGES add column NAME TEXT; 7alter table PAGES add column TITLE TEXT; 8alter table PAGES add column H1 TEXT; 9 10create index if not exists PAGES_DATE_MODIFED ON PAGES (DATE_MODIFIED DESC); 11create index if not exists PAGES_DATE_CREATED ON PAGES (DATE_CREATED DESC); 12create index if not exists PAGES_DATE_PUBLISHED ON PAGES (DATE_CREATED DESC); 13create index if not exists PAGES_PATH ON PAGES (PATH ASC); 14create index if not exists PAGES_NAME ON PAGES (NAME ASC); 15 16 17 18 19 20