MailManager/sql/v2_1 addSubTab.zsql,NONE,1.1 listSubTabs.zsql,NONE,1.1

[Graeme M. <ma...@us...>]

Update of /cvsroot/mailmanager/MailManager/sql/v2_1
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv14817/sql/v2_1

Added Files:
	addSubTab.zsql listSubTabs.zsql 
Log Message:
Subtabs are now taken from the database.  The brucie bonus is that we can
factor out the repetition of the fill-slot for the subtabs back into master.zpt.
I've not populated the database with the current setup yet, but since this
changes *all* the PTs, I figured I'd commit now to reduce conflicts.


--- NEW FILE: addSubTab.zsql ---
<dtml-comment>
title:Add a new main tab
connection_id: mailmanager_db
max_rows:0
arguments:sqv_name sqv_nav_tab_id sqv_tooltip sqv_url
</dtml-comment>
INSERT INTO <dtml-var schema>mm_nav_subtabs (name, nav_tab_id, tooltip, url)
VALUES (<dtml-sqlvar sqv_name type="nb">,
        <dtml-sqlvar sqv_nav_tab_id type="nb">,
        <dtml-sqlvar sqv_tooltip type="nb" optional>,
        <dtml-sqlvar sqv_url type="nb">)
        
--- NEW FILE: listSubTabs.zsql ---
<dtml-comment>
title:List navigation tabs
connection_id: mailmanager_db
max_rows:0
arguments: sqv_tab
</dtml-comment>
SELECT * FROM <dtml-var schema>mm_nav_subtabs
WHERE nav_tab_id=<dtml-sqlvar sqv_tab type="nb">