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