SQLite format 3 @ .K� � � /��j � M � -�k��N��a�l�w Y)#sindexpkgsupplementssupplementsCREATE INDEX pkgsupplements on supplements (pkgKey)U'!oindexpkgrecommendsrecommends CREATE INDEX pkgrecommends on recommends (pkgKey)M#gindexpkgenhancesenhancesCREATE INDEX pkgenhances on enhances (pkgKey)M#gindexpkgsuggestssuggestsCREATE INDEX pkgsuggests on suggests (pkgKey)Q%kindexpkgobsoletesobsoletesCREATE INDEX pkgobsoletes on obsoletes (pkgKey)Q%kindexpkgconflictsconflicts CREATE INDEX pkgconflicts on conflicts (pkgKey)M%eindexprovidesnameprovides tCREATE INDEX providesname ON provides (name)M#gindexpkgprovidesprovides LCREATE INDEX pkgprovides on provides (pkgKey)M%eindexrequiresnamerequires CREATE INDEX requiresname ON requires (name)M#gindexpkgrequiresrequires�CREATE INDEX pkgrequires on requires (pkgKey)A[indexpkgfilesfilesSCREATE INDEX pkgfiles ON files (pkgKey)AYindexfilenamesfilesCCREATE INDEX filenames ON files (name)HaindexpackageIdpackages�CREATE INDEX packageId ON packages (pkgId)K #cindexpackagenamepackages�CREATE INDEX packagename ON packages (name)�)�#triggerremovalspackagesCREATE TRIGGER removals AFTER DELETE ON packages BEGIN DELETE FROM files WHERE pkgKey = old.pkgKey; DELETE FROM requires WHERE pkgKey = old.pkgKey; DELETE FROM provides WHERE pkgKey = old.pkgKey; DELETE FROM conflicts WHERE pkgKey = old.pkgKey; DELETE FROM obsoletes WHERE pkgKey = old.pkgKey; DELETE FROM suggests WHERE pkgKey = old.pkgKey; DELETE FROM enhances WHERE pkgKey = old.pkgKey; DELETE FROM recommends WHERE pkgKey = old.pkgKey; DELETE FROM supplements WHERE pkgKey = old.pkgKey; END�##�mtablesupplementssupplementsCREATE TABLE supplements ( name TEXT, flags TEXT, epoch TEXT, version TEXT, release TEXT, pkgKey INTEGER )� !!�ktablerecommendsrecommendsCREATE TABLE recommends ( name TEXT, flags TEXT, epoch TEXT, version TEXT, release TEXT, pkgKey INTEGER )� �gtableenhancesenhances CREATE TABLE enhances ( name TEXT, flags TEXT, epoch TEXT, version TEXT, release TEXT, pkgKey INTEGER )� �gtablesuggestssuggests CREATE TABLE suggests ( name TEXT, flags TEXT, epoch TEXT, version TEXT, release TEXT, pkgKey INTEGER )� �itableobsoletesobsoletesCREATE TABLE obsoletes ( name TEXT, flags TEXT, epoch TEXT, version TEXT, release TEXT, pkgKey INTEGER )� �itableconflictsconflictsCREATE TABLE conflicts ( name TEXT, flags TEXT, epoch TEXT, version TEXT, release TEXT, pkgKey INTEGER )� �gtableprovidesprovidesCREATE TABLE provides ( name TEXT, flags TEXT, epoch TEXT, version TEXT, release TEXT, pkgKey INTEGER )�%�tablerequiresrequiresCREATE TABLE requires ( name TEXT, flags TEXT, epoch TEXT, version TEXT, release TEXT, pkgKey INTEGER , pre BOOLEAN DEFAULT FALSE)T�tablefilesfilesCREATE TABLE files ( name TEXT, type TEXT, pkgKey INTEGER)�%�tablepackagespackagesCREATE TABLE packages ( pkgKey INTEGER PRIMARY KEY, pkgId TEXT, name TEXT, arch TEXT, version TEXT, epoch TEXT, release TEXT, summary TEXT, description TEXT, url TEXT, time_file INTEGER, time_build INTEGER, rpm_license TEXT, rpm_vendor TEXT, rpm_group TEXT, rpm_buildhost TEXT, rpm_sourcerpm TEXT, rpm_header_start INTEGER, rpm_header_end INTEGER, rpm_packager TEXT, size_package INTEGER, size_installed INTEGER, size_archive INTEGER, location_href TEXT, location_base TEXT, checksum_type TEXT)Q{tabledb_infodb_infoCREATE TABLE db_info (dbversion INTEGER, checksum TEXT) � � E� f983766559b048aeaf8389fffa232d8ced84ecfb8e84330d941ba464c3af2a20 � �� ��@ 7\ ����������������������}wqke_YSMGA;5/)#����������������������{uoic]WQKE?93-'! � � � � � � � � � � � � � � � � � � � � � y s m g a [ U O I C = 7 1 + % ���������������������}wqke_YSMGA;5/)#����������������������{uoic]WQKE?93-'! � � � � � � � � � � � � � � � � � � � ~ w p i b [ T M F ? 8 1 * # � � � � � � � � � � � � � � � � � � { t m f _ X Q J C < 5 . ' ������������������xqjc\ ��� ���8 ���h ��� ���9 ���i ��� ���? ���j ��� ���E ���q ��� ���F ���r ��� ���M ���y ���# ���N ���z ��&