| | | |
Offset 1, 16 lines modified | Offset 1, 16 lines modified |
1 | PRAGMA·foreign_keys=OFF; | 1 | PRAGMA·foreign_keys=OFF; |
2 | BEGIN·TRANSACTION; | 2 | BEGIN·TRANSACTION; |
3 | CREATE·TABLE·NamespaceTable·(Id·INTEGER·PRIMARY·KEY,·Name·TEXT,·FilePath·TEXT·); | 3 | CREATE·TABLE·NamespaceTable·(Id·INTEGER·PRIMARY·KEY,·Name·TEXT,·FilePath·TEXT·); |
4 | INSERT·INTO·NamespaceTable·VALUES(1,'org.qterm','qterm.qch'); | 4 | INSERT·INTO·NamespaceTable·VALUES(1,'org.qterm','qterm.qch'); |
5 | CREATE·TABLE·FolderTable·(Id·INTEGER·PRIMARY·KEY,·NamespaceId·INTEGER,·Name·TEXT·); | 5 | CREATE·TABLE·FolderTable·(Id·INTEGER·PRIMARY·KEY,·NamespaceId·INTEGER,·Name·TEXT·); |
6 | INSERT·INTO·FolderTable·VALUES(1,1,'doc'); | 6 | INSERT·INTO·FolderTable·VALUES(1,1,'doc'); |
7 | CREATE·TABLE·FilterAttributeTable·(Id·INTEGER·PRIMARY·KEY,·Name·TEXT·); | 7 | CREATE·TABLE·FilterAttributeTable·(Id·INTEGER·PRIMARY·KEY,·Name·TEXT·); |
8 | INSERT·INTO·FilterAttributeTable·VALUES(1,'0.7.4'); | |
9 | INSERT·INTO·FilterAttributeTable·VALUES(2,'QTerm'); | 8 | INSERT·INTO·FilterAttributeTable·VALUES(1,'QTerm'); |
| 9 | INSERT·INTO·FilterAttributeTable·VALUES(2,'0.7.4'); |
10 | CREATE·TABLE·FilterNameTable·(Id·INTEGER·PRIMARY·KEY,·Name·TEXT·); | 10 | CREATE·TABLE·FilterNameTable·(Id·INTEGER·PRIMARY·KEY,·Name·TEXT·); |
11 | CREATE·TABLE·FilterTable·(NameId·INTEGER,·FilterAttributeId·INTEGER·); | 11 | CREATE·TABLE·FilterTable·(NameId·INTEGER,·FilterAttributeId·INTEGER·); |
12 | CREATE·TABLE·SettingsTable·(Key·TEXT·PRIMARY·KEY,·Value·BLOB·); | 12 | CREATE·TABLE·SettingsTable·(Key·TEXT·PRIMARY·KEY,·Value·BLOB·); |
13 | INSERT·INTO·SettingsTable·VALUES('LastRegisterTime','2020-09-23T09:26:42.000'); | 13 | INSERT·INTO·SettingsTable·VALUES('LastRegisterTime','2020-09-23T09:26:42.000'); |
14 | INSERT·INTO·SettingsTable·VALUES('WindowTitle','QTerm·Help'); | 14 | INSERT·INTO·SettingsTable·VALUES('WindowTitle','QTerm·Help'); |
15 | INSERT·INTO·SettingsTable·VALUES('LastShownPages','qthelp://org.qterm/doc/index.html'); | 15 | INSERT·INTO·SettingsTable·VALUES('LastShownPages','qthelp://org.qterm/doc/index.html'); |
16 | INSERT·INTO·SettingsTable·VALUES('EnableFilterFunctionality',1); | 16 | INSERT·INTO·SettingsTable·VALUES('EnableFilterFunctionality',1); |
Offset 36, 16 lines modified | Offset 36, 16 lines modified |
36 | CREATE·TABLE·FileFilterTable·(FilterAttributeId·INTEGER,·FileId·INTEGER); | 36 | CREATE·TABLE·FileFilterTable·(FilterAttributeId·INTEGER,·FileId·INTEGER); |
37 | CREATE·TABLE·IndexFilterTable·(FilterAttributeId·INTEGER,·IndexId·INTEGER); | 37 | CREATE·TABLE·IndexFilterTable·(FilterAttributeId·INTEGER,·IndexId·INTEGER); |
38 | CREATE·TABLE·ContentsFilterTable·(FilterAttributeId·INTEGER,·ContentsId·INTEGER·); | 38 | CREATE·TABLE·ContentsFilterTable·(FilterAttributeId·INTEGER,·ContentsId·INTEGER·); |
39 | CREATE·TABLE·FileAttributeSetTable·(NamespaceId·INTEGER,·FilterAttributeSetId·INTEGER,·FilterAttributeId·INTEGER); | 39 | CREATE·TABLE·FileAttributeSetTable·(NamespaceId·INTEGER,·FilterAttributeSetId·INTEGER,·FilterAttributeId·INTEGER); |
40 | INSERT·INTO·FileAttributeSetTable·VALUES(1,1,1); | 40 | INSERT·INTO·FileAttributeSetTable·VALUES(1,1,1); |
41 | INSERT·INTO·FileAttributeSetTable·VALUES(1,1,2); | 41 | INSERT·INTO·FileAttributeSetTable·VALUES(1,1,2); |
42 | CREATE·TABLE·OptimizedFilterTable·(NamespaceId·INTEGER,·FilterAttributeId·INTEGER); | 42 | CREATE·TABLE·OptimizedFilterTable·(NamespaceId·INTEGER,·FilterAttributeId·INTEGER); |
43 | INSERT·INTO·OptimizedFilterTable·VALUES(1,2); | |
44 | INSERT·INTO·OptimizedFilterTable·VALUES(1,1); | 43 | INSERT·INTO·OptimizedFilterTable·VALUES(1,1); |
| 44 | INSERT·INTO·OptimizedFilterTable·VALUES(1,2); |
45 | CREATE·TABLE·TimeStampTable·(NamespaceId·INTEGER,·FolderId·INTEGER,·FilePath·TEXT,·Size·INTEGER,·TimeStamp·TEXT); | 45 | CREATE·TABLE·TimeStampTable·(NamespaceId·INTEGER,·FolderId·INTEGER,·FilePath·TEXT,·Size·INTEGER,·TimeStamp·TEXT); |
46 | INSERT·INTO·TimeStampTable·VALUES(1,1,'qterm.qch',94208,'2020-09-23T09:26:42'); | 46 | INSERT·INTO·TimeStampTable·VALUES(1,1,'qterm.qch',94208,'2020-09-23T09:26:42'); |
47 | CREATE·TABLE·VersionTable·(NamespaceId·INTEGER,·Version·TEXT); | 47 | CREATE·TABLE·VersionTable·(NamespaceId·INTEGER,·Version·TEXT); |
48 | INSERT·INTO·VersionTable·VALUES(1,NULL); | 48 | INSERT·INTO·VersionTable·VALUES(1,NULL); |
49 | CREATE·TABLE·Filter·(FilterId·INTEGER·PRIMARY·KEY,·Name·TEXT); | 49 | CREATE·TABLE·Filter·(FilterId·INTEGER·PRIMARY·KEY,·Name·TEXT); |
50 | CREATE·TABLE·ComponentTable·(ComponentId·INTEGER·PRIMARY·KEY,·Name·TEXT); | 50 | CREATE·TABLE·ComponentTable·(ComponentId·INTEGER·PRIMARY·KEY,·Name·TEXT); |
51 | INSERT·INTO·ComponentTable·VALUES(1,'doc'); | 51 | INSERT·INTO·ComponentTable·VALUES(1,'doc'); |