| | | |
Offset 197, 15 lines modified | Offset 197, 15 lines modified |
197 | CREATE·TABLE·IndexFilterTable·(FilterAttributeId·INTEGER,·IndexId·INTEGER); | 197 | CREATE·TABLE·IndexFilterTable·(FilterAttributeId·INTEGER,·IndexId·INTEGER); |
198 | CREATE·TABLE·ContentsFilterTable·(FilterAttributeId·INTEGER,·ContentsId·INTEGER·); | 198 | CREATE·TABLE·ContentsFilterTable·(FilterAttributeId·INTEGER,·ContentsId·INTEGER·); |
199 | CREATE·TABLE·FileAttributeSetTable·(NamespaceId·INTEGER,·FilterAttributeSetId·INTEGER,·FilterAttributeId·INTEGER); | 199 | CREATE·TABLE·FileAttributeSetTable·(NamespaceId·INTEGER,·FilterAttributeSetId·INTEGER,·FilterAttributeId·INTEGER); |
200 | INSERT·INTO·FileAttributeSetTable·VALUES(1,1,1); | 200 | INSERT·INTO·FileAttributeSetTable·VALUES(1,1,1); |
201 | CREATE·TABLE·OptimizedFilterTable·(NamespaceId·INTEGER,·FilterAttributeId·INTEGER); | 201 | CREATE·TABLE·OptimizedFilterTable·(NamespaceId·INTEGER,·FilterAttributeId·INTEGER); |
202 | INSERT·INTO·OptimizedFilterTable·VALUES(1,1); | 202 | INSERT·INTO·OptimizedFilterTable·VALUES(1,1); |
203 | CREATE·TABLE·TimeStampTable·(NamespaceId·INTEGER,·FolderId·INTEGER,·FilePath·TEXT,·Size·INTEGER,·TimeStamp·TEXT); | 203 | CREATE·TABLE·TimeStampTable·(NamespaceId·INTEGER,·FolderId·INTEGER,·FilePath·TEXT,·Size·INTEGER,·TimeStamp·TEXT); |
204 | INSERT·INTO·TimeStampTable·VALUES(1,1,'Mapper·0.9.4·Manual.qch',1556480,'2021-01-10T22:50:08'); | 204 | INSERT·INTO·TimeStampTable·VALUES(1,1,'Mapper·0.9.4·Manual.qch',1556480,'2021-01-12T00:50:08'); |
205 | CREATE·TABLE·VersionTable·(NamespaceId·INTEGER,·Version·TEXT); | 205 | CREATE·TABLE·VersionTable·(NamespaceId·INTEGER,·Version·TEXT); |
206 | INSERT·INTO·VersionTable·VALUES(1,NULL); | 206 | INSERT·INTO·VersionTable·VALUES(1,NULL); |
207 | CREATE·TABLE·Filter·(FilterId·INTEGER·PRIMARY·KEY,·Name·TEXT); | 207 | CREATE·TABLE·Filter·(FilterId·INTEGER·PRIMARY·KEY,·Name·TEXT); |
208 | CREATE·TABLE·ComponentTable·(ComponentId·INTEGER·PRIMARY·KEY,·Name·TEXT); | 208 | CREATE·TABLE·ComponentTable·(ComponentId·INTEGER·PRIMARY·KEY,·Name·TEXT); |
209 | INSERT·INTO·ComponentTable·VALUES(1,'manual'); | 209 | INSERT·INTO·ComponentTable·VALUES(1,'manual'); |
210 | CREATE·TABLE·ComponentMapping·(ComponentId·INTEGER,·NamespaceId·INTEGER); | 210 | CREATE·TABLE·ComponentMapping·(ComponentId·INTEGER,·NamespaceId·INTEGER); |
211 | INSERT·INTO·ComponentMapping·VALUES(1,1); | 211 | INSERT·INTO·ComponentMapping·VALUES(1,1); |