--- a/components/python/alembic/alembic-PYVER.p5m	Tue Apr 07 15:49:29 2015 -0700
+++ b/components/python/alembic/alembic-PYVER.p5m	Tue Apr 07 13:31:20 2015 -0700
@@ -18,6 +18,8 @@
 #
 # CDDL HEADER END
 #
+
+#
 # Copyright (c) 2013, 2015, Oracle and/or its affiliates. All rights reserved.
 #
 
@@ -29,21 +31,31 @@
 set name=com.oracle.info.description value="the Python alembic module"
 set name=com.oracle.info.tpno value=$(TPNO)
 set name=info.classification \
-    value=org.opensolaris.category.2008:Development/Python
+    value=org.opensolaris.category.2008:Development/Python \
+    value=org.opensolaris.category.2008:System/Databases
 set name=info.source-url value=$(COMPONENT_ARCHIVE_URL)
 set name=info.upstream value="Mike Bayer <[email protected]>"
 set name=info.upstream-url value=$(COMPONENT_PROJECT_URL)
 set name=org.opensolaris.arc-caseid value=PSARC/2013/254
 set name=org.opensolaris.consolidation value=$(CONSOLIDATION)
+#
+link path=usr/bin/alembic target=alembic-$(PYVER) mediator=python \
+    mediator-version=$(PYVER)
+file path=usr/bin/alembic-$(PYVER)
 file path=usr/lib/python$(PYVER)/vendor-packages/alembic-$(COMPONENT_VERSION)-py$(PYVER).egg-info/PKG-INFO
 file path=usr/lib/python$(PYVER)/vendor-packages/alembic-$(COMPONENT_VERSION)-py$(PYVER).egg-info/SOURCES.txt
 file path=usr/lib/python$(PYVER)/vendor-packages/alembic-$(COMPONENT_VERSION)-py$(PYVER).egg-info/dependency_links.txt
 file path=usr/lib/python$(PYVER)/vendor-packages/alembic-$(COMPONENT_VERSION)-py$(PYVER).egg-info/entry_points.txt
 file path=usr/lib/python$(PYVER)/vendor-packages/alembic-$(COMPONENT_VERSION)-py$(PYVER).egg-info/not-zip-safe
+file path=usr/lib/python$(PYVER)/vendor-packages/alembic-$(COMPONENT_VERSION)-py$(PYVER).egg-info/pbr.json
 file path=usr/lib/python$(PYVER)/vendor-packages/alembic-$(COMPONENT_VERSION)-py$(PYVER).egg-info/requires.txt
 file path=usr/lib/python$(PYVER)/vendor-packages/alembic-$(COMPONENT_VERSION)-py$(PYVER).egg-info/top_level.txt
 file path=usr/lib/python$(PYVER)/vendor-packages/alembic/__init__.py
-file path=usr/lib/python$(PYVER)/vendor-packages/alembic/autogenerate.py
+file path=usr/lib/python$(PYVER)/vendor-packages/alembic/autogenerate/__init__.py
+file path=usr/lib/python$(PYVER)/vendor-packages/alembic/autogenerate/api.py
+file path=usr/lib/python$(PYVER)/vendor-packages/alembic/autogenerate/compare.py
+file path=usr/lib/python$(PYVER)/vendor-packages/alembic/autogenerate/render.py
+file path=usr/lib/python$(PYVER)/vendor-packages/alembic/batch.py
 file path=usr/lib/python$(PYVER)/vendor-packages/alembic/command.py
 file path=usr/lib/python$(PYVER)/vendor-packages/alembic/compat.py
 file path=usr/lib/python$(PYVER)/vendor-packages/alembic/config.py
@@ -60,6 +72,7 @@
 file path=usr/lib/python$(PYVER)/vendor-packages/alembic/migration.py
 file path=usr/lib/python$(PYVER)/vendor-packages/alembic/op.py
 file path=usr/lib/python$(PYVER)/vendor-packages/alembic/operations.py
+file path=usr/lib/python$(PYVER)/vendor-packages/alembic/revision.py
 file path=usr/lib/python$(PYVER)/vendor-packages/alembic/script.py
 file path=usr/lib/python$(PYVER)/vendor-packages/alembic/templates/generic/README
 file path=usr/lib/python$(PYVER)/vendor-packages/alembic/templates/generic/alembic.ini.mako
@@ -74,19 +87,22 @@
 file path=usr/lib/python$(PYVER)/vendor-packages/alembic/templates/pylons/env.py
 file path=usr/lib/python$(PYVER)/vendor-packages/alembic/templates/pylons/script.py.mako
 file path=usr/lib/python$(PYVER)/vendor-packages/alembic/util.py
+#
 license alembic.license license=MIT
 
 # force the rename with an optional dependency on the old name
 depend type=optional \
     fmri=library/python-2/alembic-$(PYV)@0.6.0,5.11-0.175.3.0.0.16.0
 
-# force a dependency on the Python runtime
-depend type=require fmri=__TBD pkg.debug.depend.file=python$(PYVER) \
-    pkg.debug.depend.path=usr/bin
-
 # force a dependency on the alembic package
 depend type=require \
     fmri=library/python/alembic@$(IPS_COMPONENT_VERSION),$(BUILD_VERSION)
 
+# force a dependency on argparse; pkgdepend work is needed to flush this out.
+depend type=require fmri=library/python/argparse-$(PYV)
+
 # force a dependency on mako; pkgdepend work is needed to flush this out.
 depend type=require fmri=library/python/mako-$(PYV)
+
+# force a dependency on sqlalchemy; pkgdepend work is needed to flush this out.
+depend type=require fmri=library/python/sqlalchemy-$(PYV)