DeveloperWiki:Provides Database

From ArchWiki
Revision as of 17:27, 23 May 2008 by Pierre (Talk | contribs) (added provides table)

Jump to: navigation, search
+------------------------+----------------------------------+----------------------------+
| provides               | metainfo                         | package                    |
+------------------------+----------------------------------+----------------------------+
| NULL                   | a2ps-lprng                       | a2ps                       |
| NULL                   | amarok-engine                    | amarok-engine-xine         |
| NULL                   | antigrain                        | agg                        |
| NULL                   | audacious-player                 | audacious                  |
| NULL                   | awk                              | gawk                       |
| NULL                   | bmp-libvisual                    | libvisual-bmp              |
| NULL                   | cdrtools                         | cdrkit                     |
| NULL                   | cheetah                          | python-cheetah             |
| NULL                   | claws                            | claws-mail                 |
| NULL                   | control-center                   | gnome-control-center       |
| NULL                   | courier-imap-ldap                | courier-authlib            |
| NULL                   | courier-imap-mysql               | courier-authlib            |
| NULL                   | courier-imap-pgsql               | courier-authlib            |
| NULL                   | cron                             | dcron                      |
| NULL                   | cvsup                            | csup                       |
| NULL                   | democracy                        | miro                       |
| NULL                   | digest-hmac                      | perl-digest-hmac           |
| NULL                   | digest-nilsimsa                  | perl-digest-nilsimsa       |
| NULL                   | digest-sha1                      | perl-digest-sha1           |
| NULL                   | dns-server                       | bind                       |
| NULL                   | egenix-mx-base                   | python-egenix-mx-base      |
| NULL                   | elementtree                      | python-elementtree         |
| NULL                   | fbi                              | fbida                      |
| NULL                   | fftw3                            | fftw                       |
| NULL                   | font-util                        | xorg-font-utils            |
| NULL                   | gaim                             | pidgin                     |
| NULL                   | gcc-objc=4.3.0                   | gcc-libs                   |
| NULL                   | gdata_py                         | python-gdata               |
| NULL                   | gecko-sdk                        | xulrunner                  |
| NULL                   | geoip-python                     | python-geoip               |
| NULL                   | ghostscript-lprng                | ghostscript                |
| NULL                   | git-core                         | git                        |
| NULL                   | glchess                          | gnome-games                |
| NULL                   | glut                             | freeglut                   |
| NULL                   | gnash                            | gnash-common               |
| NULL                   | gnome-sudoku                     | gnome-games                |
| NULL                   | gnome-vfs-samba                  | gnome-vfs                  |
| NULL                   | gnomemeeting                     | ekiga                      |
| NULL                   | gst-plugins-bad=0.10.7           | gstreamer0.10-bad-plugins  |
| NULL                   | gst-plugins-base=0.10.19         | gstreamer0.10-base-plugins |
| NULL                   | gst-plugins-good=0.10.8          | gstreamer0.10-good-plugins |
| NULL                   | gst-plugins-ugly=0.10.7          | gstreamer0.10-ugly-plugins |
| NULL                   | gstreamer0.10-a52dec=0.10.7      | gstreamer0.10-ugly-plugins |
| NULL                   | gstreamer0.10-aalib=0.10.8       | gstreamer0.10-good-plugins |
| NULL                   | gstreamer0.10-alsa=0.10.19       | gstreamer0.10-base-plugins |
| NULL                   | gstreamer0.10-alsaspdif=0.10.7   | gstreamer0.10-bad-plugins  |
| NULL                   | gstreamer0.10-annodex=0.10.8     | gstreamer0.10-good-plugins |
| NULL                   | gstreamer0.10-bz2=0.10.7         | gstreamer0.10-bad-plugins  |
| NULL                   | gstreamer0.10-cairo=0.10.8       | gstreamer0.10-good-plugins |
| NULL                   | gstreamer0.10-cdaudio=0.10.7     | gstreamer0.10-bad-plugins  |
| NULL                   | gstreamer0.10-cdio=0.10.8        | gstreamer0.10-good-plugins |
| NULL                   | gstreamer0.10-cdparanoia=0.10.19 | gstreamer0.10-base-plugins |
| NULL                   | gstreamer0.10-dts=0.10.7         | gstreamer0.10-bad-plugins  |
| NULL                   | gstreamer0.10-dv1394=0.10.8      | gstreamer0.10-good-plugins |
| NULL                   | gstreamer0.10-dv=0.10.8          | gstreamer0.10-good-plugins |
| NULL                   | gstreamer0.10-dvdread=0.10.7     | gstreamer0.10-ugly-plugins |
| NULL                   | gstreamer0.10-esd=0.10.8         | gstreamer0.10-good-plugins |
| NULL                   | gstreamer0.10-faac=0.10.7        | gstreamer0.10-bad-plugins  |
| NULL                   | gstreamer0.10-faad=0.10.7        | gstreamer0.10-bad-plugins  |
| NULL                   | gstreamer0.10-flac=0.10.8        | gstreamer0.10-good-plugins |
| NULL                   | gstreamer0.10-gconf=0.10.8       | gstreamer0.10-good-plugins |
| NULL                   | gstreamer0.10-gdkpixbuf=0.10.8   | gstreamer0.10-good-plugins |
| NULL                   | gstreamer0.10-gnomevfs=0.10.19   | gstreamer0.10-base-plugins |
| NULL                   | gstreamer0.10-hal=0.10.8         | gstreamer0.10-good-plugins |
| NULL                   | gstreamer0.10-jack=0.10.7        | gstreamer0.10-bad-plugins  |
| NULL                   | gstreamer0.10-jpeg=0.10.8        | gstreamer0.10-good-plugins |
| NULL                   | gstreamer0.10-ladspa=0.10.7      | gstreamer0.10-bad-plugins  |
| NULL                   | gstreamer0.10-lame=0.10.7        | gstreamer0.10-ugly-plugins |
| NULL                   | gstreamer0.10-libcaca=0.10.8     | gstreamer0.10-good-plugins |
| NULL                   | gstreamer0.10-libpng=0.10.8      | gstreamer0.10-good-plugins |
| NULL                   | gstreamer0.10-libvisual=0.10.19  | gstreamer0.10-base-plugins |
| NULL                   | gstreamer0.10-mad=0.10.7         | gstreamer0.10-ugly-plugins |
| NULL                   | gstreamer0.10-metadata=0.10.7    | gstreamer0.10-bad-plugins  |
| NULL                   | gstreamer0.10-mms=0.10.7         | gstreamer0.10-bad-plugins  |
| NULL                   | gstreamer0.10-mpeg2dec=0.10.7    | gstreamer0.10-ugly-plugins |
| NULL                   | gstreamer0.10-mpeg2enc=0.10.7    | gstreamer0.10-bad-plugins  |
| NULL                   | gstreamer0.10-musepack=0.10.7    | gstreamer0.10-bad-plugins  |
| NULL                   | gstreamer0.10-musicbrainz=0.10.7 | gstreamer0.10-bad-plugins  |
| NULL                   | gstreamer0.10-neon=0.10.7        | gstreamer0.10-bad-plugins  |
| NULL                   | gstreamer0.10-ogg=0.10.19        | gstreamer0.10-base-plugins |
| NULL                   | gstreamer0.10-pango=0.10.19      | gstreamer0.10-base-plugins |
| NULL                   | gstreamer0.10-sdl=0.10.7         | gstreamer0.10-bad-plugins  |
| NULL                   | gstreamer0.10-shout2=0.10.8      | gstreamer0.10-good-plugins |
| NULL                   | gstreamer0.10-sidplay=0.10.7     | gstreamer0.10-ugly-plugins |
| NULL                   | gstreamer0.10-sndfile=0.10.7     | gstreamer0.10-bad-plugins  |
| NULL                   | gstreamer0.10-soup=0.10.8        | gstreamer0.10-good-plugins |
| NULL                   | gstreamer0.10-speex=0.10.8       | gstreamer0.10-good-plugins |
| NULL                   | gstreamer0.10-taglib=0.10.8      | gstreamer0.10-good-plugins |
| NULL                   | gstreamer0.10-theora=0.10.19     | gstreamer0.10-base-plugins |
| NULL                   | gstreamer0.10-vorbis=0.10.19     | gstreamer0.10-base-plugins |
| NULL                   | gstreamer0.10-wavpack=0.10.8     | gstreamer0.10-good-plugins |
| NULL                   | gstreamer0.10-x264=0.10.7        | gstreamer0.10-bad-plugins  |
| NULL                   | gstreamer0.10-xvid=0.10.7        | gstreamer0.10-bad-plugins  |
| NULL                   | gtksourceview-sharp              | gtksourceview-sharp-2.0    |
| NULL                   | gvim-devel                       | gvim                       |
| NULL                   | howl                             | avahi                      |
| NULL                   | html-parser                      | perl-html-parser           |
| NULL                   | html-tagset                      | perl-html-tagset           |
| NULL                   | imap-server                      | imap                       |
| NULL                   | imap-server                      | courier-mta                |
| NULL                   | imap-server                      | dovecot                    |
| NULL                   | imap-server                      | bincimap                   |
| NULL                   | imap-server                      | courier-imap               |
| NULL                   | io-socket-ssl                    | perl-io-socket-ssl         |
| NULL                   | j2re                             | jre                        |
| NULL                   | j2sdk                            | jdk                        |
| NULL                   | jam                              | ftjam                      |
| NULL                   | java-environment                 | jdk                        |
| NULL                   | java-environment                 | java-gcj-compat            |
| NULL                   | java-runtime                     | jre                        |
| NULL                   | java-runtime                     | java-gcj-compat            |
| NULL                   | libdts                           | libdca                     |
| NULL                   | libgl-dri                        | libgl                      |
| NULL                   | libwww-perl                      | perl-libwww                |
| NULL                   | linux32                          | util-linux-ng              |
| NULL                   | logger                           | sysklogd                   |
| NULL                   | logger                           | metalog                    |
| NULL                   | logger                           | syslog-ng                  |
| NULL                   | madwifi-ng                       | madwifi-mm                 |
| NULL                   | madwifi-ng-utils                 | madwifi-utils              |
| NULL                   | mdnsresponder                    | avahi                      |
| NULL                   | mktemp                           | coreutils                  |
| NULL                   | mozilla-firefox                  | firefox                    |
| NULL                   | mozilla-thunderbird              | thunderbird                |
| NULL                   | mpg321                           | mpg123                     |
| NULL                   | net-dns                          | perl-net-dns               |
| NULL                   | net-ssleay                       | perl-net-ssleay            |
| NULL                   | netcat                           | gnu-netcat                 |
| NULL                   | opera                            | opera-devel                |
| NULL                   | pcsx                             | pcsx-df                    |
| NULL                   | perl-archive-extract             | perl                       |
| NULL                   | perl-cpanplus                    | perl                       |
| NULL                   | perl-digest-sha                  | perl                       |
| NULL                   | perl-extutils-parsexs            | perl                       |
| NULL                   | perl-file-fetch                  | perl                       |
| NULL                   | perl-ipc-cmd                     | perl                       |
| NULL                   | perl-locale-maketext-simple      | perl                       |
| NULL                   | perl-log-message                 | perl                       |
| NULL                   | perl-log-message-simple          | perl                       |
| NULL                   | perl-module-corelist             | perl                       |
| NULL                   | perl-module-load                 | perl                       |
| NULL                   | perl-module-load-conditional     | perl                       |
| NULL                   | perl-module-loaded               | perl                       |
| NULL                   | perl-module-pluggable            | perl                       |
| NULL                   | perl-object-accessor             | perl                       |
| NULL                   | perl-params-check                | perl                       |
| NULL                   | perl-term-ui                     | perl                       |
| NULL                   | perl-time-piece                  | perl                       |
| NULL                   | perltk                           | perl-tk                    |
| NULL                   | pine                             | alpine                     |
| NULL                   | pop3-server                      | courier-mta                |
| NULL                   | pop3-server                      | dovecot                    |
| NULL                   | pop3-server                      | courier-imap               |
| NULL                   | pop3-server                      | imap                       |
| NULL                   | psutils-lprng                    | psutils                    |
| NULL                   | pygame                           | python-pygame              |
| NULL                   | pyopengl                         | python-opengl              |
| NULL                   | pyqt4                            | pyqt                       |
| NULL                   | pyspi                            | python-pyspi               |
| NULL                   | python-ctypes                    | python                     |
| NULL                   | python-pyopengl                  | python-opengl              |
| NULL                   | qscintilla2                      | qscintilla                 |
| NULL                   | qt4-doc                          | qt-doc                     |
| NULL                   | qt4=4.3.3                        | qt                         |
| NULL                   | quanta                           | kdewebdev                  |
| NULL                   | rosegarden-4                     | rosegarden                 |
| NULL                   | scrollkeeper                     | rarian                     |
| NULL                   | seom                             | seom-svn                   |
| NULL                   | sh                               | bash                       |
| NULL                   | slocate                          | mlocate                    |
| NULL                   | smplayer-qt4                     | smplayer                   |
| NULL                   | smtp-forwarder                   | msmtp                      |
| NULL                   | smtp-server                      | courier-mta                |
| NULL                   | smtp-server                      | postfix                    |
| NULL                   | smtp-server                      | exim                       |
| NULL                   | svn                              | subversion                 |
| NULL                   | thai-ttf                         | ttf-thai                   |
| NULL                   | timedate                         | perl-timedate              |
| NULL                   | ucd-snmp                         | net-snmp                   |
| NULL                   | uri                              | perl-uri                   |
| NULL                   | util-linux                       | util-linux-ng              |
| NULL                   | wxgtk-gtk1                       | wxgtk-2.6                  |
| NULL                   | x-server                         | xorg-server                |
| NULL                   | xfce4-cpu-freq-plugin            | xfce4-cpufreq-plugin       |
| NULL                   | xfsacl                           | acl                        |
| NULL                   | xfsattr                          | attr                       |
| NULL                   | xfsdmapi                         | dmapi                      |
| NULL                   | xkbdata                          | xkeyboard-config           |
| NULL                   | zd1211                           | zd1211-firmware            |
| abcm2ps                |                                  | abcm2ps-devel              |
| courier-imap           |                                  | courier-mta                |
| courier-maildrop       |                                  | courier-mta                |
| fvwm                   | =2.5.26                          | fvwm-devel                 |
| gimp                   | =2.5.0                           | gimp-devel                 |
| gqview                 |                                  | gqview-devel               |
| libgl                  |                                  | catalyst-utils             |
| libgl                  |                                  | nvidia-96xx-utils          |
| libgl                  |                                  | nvidia-utils               |
| libgl                  |                                  | nvidia-71xx-utils          |
| mplayer                |                                  | mplayer-svn                |
| notification-daemon    |                                  | notification-daemon-xfce   |
| openoffice-base        |                                  | openoffice-base-devel      |
| opera                  |                                  | opera-devel                |
| perl-archive-tar       |                                  | perl                       |
| perl-compress-raw-zlib |                                  | perl                       |
| perl-compress-zlib     |                                  | perl                       |
| perl-extutils-cbuilder |                                  | perl                       |
| perl-io-compress-base  |                                  | perl                       |
| perl-io-compress-zlib  |                                  | perl                       |
| perl-io-zlib           |                                  | perl                       |
| perl-module-build      |                                  | perl                       |
| perl-pod-escapes       |                                  | perl                       |
| perl-pod-simple        |                                  | perl                       |
| perl-version           |                                  | perl                       |
| perl-yaml-syck         |                                  | slimserver                 |
| totem                  | =2.22.0                          | totem-xine                 |
| ttf-freebanglafont     |                                  | ttf-indic-otf              |
| twinkle                |                                  | twinkle-kdefree            |
| vips                   |                                  | vips-devel                 |
+------------------------+----------------------------------+----------------------------+

This information was created by the following sql statement (repos: 1=core; 2=extra; 3=unstable)

select distinct b.name as provides, provides.comment as metainfo, a.name as package from packages a join provides on a.id=provides.package left join packages b on b.id=provides.provides where a.repository in (1, 2, 3) order by b.name, provides.comment;