SQLite format 3 @
.zq
/j
M -kNalw 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%eindexprovidesnameprovidesCREATE INDEX providesname ON provides (name)M#gindexpkgprovidesprovidesCREATE INDEX pkgprovides on provides (pkgKey)M%eindexrequiresnamerequires5CREATE INDEX requiresname ON requires (name)M#gindexpkgrequiresrequires
CREATE INDEX pkgrequires on requires (pkgKey)A[indexpkgfilesfiles
MCREATE INDEX pkgfiles ON files (pkgKey)AYindexfilenamesfilesCREATE INDEX filenames ON files (name)HaindexpackageIdpackageszCREATE INDEX packageId ON packages (pkgId)K
#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)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
8655e2c2fa002c8ace6f7018a998880d22fc14f87016744c46f5c3d49048a7cf < ;2 t =}wqke_YSMGA;5/)#{uoic]WQKE?93-'!
y
s
m
g
a
[
U
O
I
C
=
7
1
+
%
}wqke_YSMGA;5/)#{uoic]WQKE?93-'!
|
u
n
g
`
Y
R
K
D
=
6
/
(
!
y r k d ] V O H A : 3 , % }vohaZSLE>70)"
zsle^WPIB;4-&
~wpib[TMF?81*# {t 9 5D v N z $ O z * V *
X . Y 4 ^
6 e : e @ j D q F r M ߁y ݁$ ہO { ׁ&