SQLite format 3 @ � .K�
! �
�
/��j
�
M � -�k��R�f�q"�|! Y)#sindexpkgsupplementssupplements �CREATE INDEX pkgsupplements on supplements (pkgKey)U'!oindexpkgrecommendsrecommends �CREATE INDEX pkgrecommends on recommends (pkgKey)M#gindexpkgenhancesenhances �CREATE INDEX pkgenhances on enhances (pkgKey)M#gindexpkgsuggestssuggests �CREATE INDEX pkgsuggests on suggests (pkgKey)Q%kindexpkgobsoletesobsoletes �CREATE INDEX pkgobsoletes on obsoletes (pkgKey)Q%kindexpkgconflictsconflicts �CREATE INDEX pkgconflicts on conflicts (pkgKey)M%eindexprovidesnameprovides �CREATE INDEX providesname ON provides (name)M#gindexpkgprovidesprovides �CREATE INDEX pkgprovides on provides (pkgKey)M%eindexrequiresnamerequires �CREATE INDEX requiresname ON requires (name)L#gindexpkgrequiresrequires}CREATE INDEX pkgrequires on requires (pkgKey)@[indexpkgfilesfileszCREATE INDEX pkgfiles ON files (pkgKey)@YindexfilenamesfilestCREATE INDEX filenames ON files (name)GaindexpackageIdpackagespCREATE INDEX packageId ON packages (pkgId)J
#cindexpackagenamepackagesoCREATE 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�
ad13968b45e9a123fefff21b2bfdbf4d531806270e34bd7fd770a5668e575204 � m������������������������� eu ^p Wk Rf Pa MZ KT CO =G 8? 36 0- -( )% '"