SQLite format 3

@  


.K�
*�
�
/��j
�
M	�	-�k��R�h�v(��*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)G
aindexpackageIdpackagesCREATE 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 )�
!!
�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

�
1cb61ea996355add02b1426ed4c1780ea75ce0c04c5d1107c025c3fbd7d8bcae