SQLite format 3@ .K * / j M -kRhv(*X)#sindexpkgsupplementssupplementsCREATE INDEX pkgsupplements on supplements (pkgKey)T'!oindexpkgrecommendsrecommendsCREATE INDEX pkgrecommends on recommends (pkgKey)L#gindexpkgenhancesenhancesCREATE INDEX pkgenhances on enhances (pkgKey)L#gindexpkgsuggestssuggestsCREATE INDEX pkgsuggests on suggests (pkgKey)P%kindexpkgobsoletesobsoletesCREATE INDEX pkgobsoletes on obsoletes (pkgKey)P%kindexpkgconflictsconflictsCREATE INDEX pkgconflicts on conflicts (pkgKey)L%eindexprovidesnameprovidesCREATE INDEX providesname ON provides (name)L#gindexpkgprovidesprovidesCREATE INDEX pkgprovides on provides (pkgKey)L%eindexrequiresnamerequiresCREATE INDEX requiresname ON requires (name)L#gindexpkgrequiresrequiresCREATE INDEX pkgrequires on requires (pkgKey)@[indexpkgfilesfilesCREATE INDEX pkgfiles ON files (pkgKey)@YindexfilenamesfilesCREATE INDEX filenames ON files (name)GaindexpackageIdpackagesCREATE INDEX packageId ON packages (pkgId)J #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 ##mtablesupplementssupplements CREATE TABLE supplements ( name TEXT, flags TEXT, epoch TEXT, version TEXT, release TEXT, pkgKey INTEGER ) !!ktablerecommendsrecommends CREATE 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)TtablefilesfilesCREATE 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 1cb61ea996355add02b1426ed4c1780ea75ce0c04c5d1107c025c3fbd7d8bcae