| | | |
Offset 4, 15 lines modified | Offset 4, 15 lines modified |
4 | INSERT·INTO·NamespaceTable·VALUES(1,'hackenberger.qtikz','qtikz.qch'); | 4 | INSERT·INTO·NamespaceTable·VALUES(1,'hackenberger.qtikz','qtikz.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 | CREATE·TABLE·FilterNameTable·(Id·INTEGER·PRIMARY·KEY,·Name·TEXT·); | 8 | CREATE·TABLE·FilterNameTable·(Id·INTEGER·PRIMARY·KEY,·Name·TEXT·); |
9 | CREATE·TABLE·FilterTable·(NameId·INTEGER,·FilterAttributeId·INTEGER·); | 9 | CREATE·TABLE·FilterTable·(NameId·INTEGER,·FilterAttributeId·INTEGER·); |
10 | CREATE·TABLE·SettingsTable·(Key·TEXT·PRIMARY·KEY,·Value·BLOB·); | 10 | CREATE·TABLE·SettingsTable·(Key·TEXT·PRIMARY·KEY,·Value·BLOB·); |
11 | INSERT·INTO·SettingsTable·VALUES('LastRegisterTime','2020-12-19T15:42:00.000'); | 11 | INSERT·INTO·SettingsTable·VALUES('LastRegisterTime','2020-12-20T17:42:00.000'); |
12 | INSERT·INTO·SettingsTable·VALUES('WindowTitle','QtikZ·Help'); | 12 | INSERT·INTO·SettingsTable·VALUES('WindowTitle','QtikZ·Help'); |
13 | INSERT·INTO·SettingsTable·VALUES('defaultHomepage','qthelp://hackenberger.qtikz/doc/index.html'); | 13 | INSERT·INTO·SettingsTable·VALUES('defaultHomepage','qthelp://hackenberger.qtikz/doc/index.html'); |
14 | INSERT·INTO·SettingsTable·VALUES('LastShownPages','qthelp://hackenberger.qtikz/doc/index.html'); | 14 | INSERT·INTO·SettingsTable·VALUES('LastShownPages','qthelp://hackenberger.qtikz/doc/index.html'); |
15 | INSERT·INTO·SettingsTable·VALUES('CacheDirectory','Florian_Hackenberger/QtikZ'); | 15 | INSERT·INTO·SettingsTable·VALUES('CacheDirectory','Florian_Hackenberger/QtikZ'); |
16 | INSERT·INTO·SettingsTable·VALUES('CacheDirRelativeToCollection',0); | 16 | INSERT·INTO·SettingsTable·VALUES('CacheDirRelativeToCollection',0); |
17 | INSERT·INTO·SettingsTable·VALUES('EnableFilterFunctionality',0); | 17 | INSERT·INTO·SettingsTable·VALUES('EnableFilterFunctionality',0); |
18 | INSERT·INTO·SettingsTable·VALUES('HideFilterFunctionality',1); | 18 | INSERT·INTO·SettingsTable·VALUES('HideFilterFunctionality',1); |
Offset 38, 15 lines modified | Offset 38, 15 lines modified |
38 | INSERT·INTO·ContentsTable·VALUES(1,1,X'00000000000000140069006e006400650078002e00680074006d006c0000000a005100740069006b005a'); | 38 | INSERT·INTO·ContentsTable·VALUES(1,1,X'00000000000000140069006e006400650078002e00680074006d006c0000000a005100740069006b005a'); |
39 | CREATE·TABLE·FileFilterTable·(FilterAttributeId·INTEGER,·FileId·INTEGER); | 39 | CREATE·TABLE·FileFilterTable·(FilterAttributeId·INTEGER,·FileId·INTEGER); |
40 | CREATE·TABLE·IndexFilterTable·(FilterAttributeId·INTEGER,·IndexId·INTEGER); | 40 | CREATE·TABLE·IndexFilterTable·(FilterAttributeId·INTEGER,·IndexId·INTEGER); |
41 | CREATE·TABLE·ContentsFilterTable·(FilterAttributeId·INTEGER,·ContentsId·INTEGER·); | 41 | CREATE·TABLE·ContentsFilterTable·(FilterAttributeId·INTEGER,·ContentsId·INTEGER·); |
42 | CREATE·TABLE·FileAttributeSetTable·(NamespaceId·INTEGER,·FilterAttributeSetId·INTEGER,·FilterAttributeId·INTEGER); | 42 | CREATE·TABLE·FileAttributeSetTable·(NamespaceId·INTEGER,·FilterAttributeSetId·INTEGER,·FilterAttributeId·INTEGER); |
43 | CREATE·TABLE·OptimizedFilterTable·(NamespaceId·INTEGER,·FilterAttributeId·INTEGER); | 43 | CREATE·TABLE·OptimizedFilterTable·(NamespaceId·INTEGER,·FilterAttributeId·INTEGER); |
44 | CREATE·TABLE·TimeStampTable·(NamespaceId·INTEGER,·FolderId·INTEGER,·FilePath·TEXT,·Size·INTEGER,·TimeStamp·TEXT); | 44 | CREATE·TABLE·TimeStampTable·(NamespaceId·INTEGER,·FolderId·INTEGER,·FilePath·TEXT,·Size·INTEGER,·TimeStamp·TEXT); |
45 | INSERT·INTO·TimeStampTable·VALUES(1,1,'qtikz.qch',450560,'2020-12-19T15:42:00'); | 45 | INSERT·INTO·TimeStampTable·VALUES(1,1,'qtikz.qch',450560,'2020-12-20T17:42:00'); |
46 | CREATE·TABLE·VersionTable·(NamespaceId·INTEGER,·Version·TEXT); | 46 | CREATE·TABLE·VersionTable·(NamespaceId·INTEGER,·Version·TEXT); |
47 | INSERT·INTO·VersionTable·VALUES(1,NULL); | 47 | INSERT·INTO·VersionTable·VALUES(1,NULL); |
48 | CREATE·TABLE·Filter·(FilterId·INTEGER·PRIMARY·KEY,·Name·TEXT); | 48 | CREATE·TABLE·Filter·(FilterId·INTEGER·PRIMARY·KEY,·Name·TEXT); |
49 | CREATE·TABLE·ComponentTable·(ComponentId·INTEGER·PRIMARY·KEY,·Name·TEXT); | 49 | CREATE·TABLE·ComponentTable·(ComponentId·INTEGER·PRIMARY·KEY,·Name·TEXT); |
50 | INSERT·INTO·ComponentTable·VALUES(1,'doc'); | 50 | INSERT·INTO·ComponentTable·VALUES(1,'doc'); |
51 | CREATE·TABLE·ComponentMapping·(ComponentId·INTEGER,·NamespaceId·INTEGER); | 51 | CREATE·TABLE·ComponentMapping·(ComponentId·INTEGER,·NamespaceId·INTEGER); |
52 | INSERT·INTO·ComponentMapping·VALUES(1,1); | 52 | INSERT·INTO·ComponentMapping·VALUES(1,1); |