home *** CD-ROM | disk | FTP | other *** search
/ Internet Magazine 2003 Spring / INTERNET101.ISO / pc / software / windows / building / basenow / setup.exe / dbtemplate.dat < prev    next >
Encoding:
Text File  |  2002-03-20  |  19.4 KB  |  471 lines
  1. <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"><html>
  2.  
  3. <head><TITLE>{DBName} Properties</TITLE>
  4. <meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
  5. <SCRIPT LANGUAGE="JavaScript">
  6. <!--
  7.  
  8. NS4 = (document.layers) ? 1 : 0;
  9. IE4 = (document.all) ? 1 : 0;
  10. ver4 = (NS4 || IE4) ? 1 : 0;
  11.  
  12. if (ver4) {
  13.     with (document) {
  14.         write("<STYLE TYPE='text/css'>");
  15.         if (NS4) {
  16.             write(".parent {position:absolute; visibility:visible}");
  17.             write(".child {position:absolute; visibility:visible}");
  18.             write(".regular {position:absolute; visibility:visible}")
  19.         }
  20.         else {
  21.             write(".child {display:none}")
  22.         }
  23.         write("</STYLE>");
  24.     }
  25. }
  26.  
  27. isExpanded = false;
  28.  
  29. function getIndex(el) {
  30.     ind = null;
  31.     for (i=0; i<document.layers.length; i++) {
  32.         whichEl = document.layers[i];
  33.         if (whichEl.id == el) {
  34.             ind = i;
  35.             break;
  36.         }
  37.     }
  38.     return ind;
  39. }
  40.  
  41. function arrange() {
  42.     nextY = document.layers[firstInd].pageY + document.layers[firstInd].document.height;
  43.     for (i=firstInd+1; i<document.layers.length; i++) {
  44.         whichEl = document.layers[i];
  45.         if (whichEl.visibility != "hide") {
  46.             whichEl.pageY = nextY;
  47.             nextY += whichEl.document.height;
  48.         }
  49.     }
  50. }
  51.  
  52. function initIt(){
  53.     if (!ver4) return;
  54.     if (NS4) {
  55.         for (i=0; i<document.layers.length; i++) {
  56.             whichEl = document.layers[i];
  57.             if (whichEl.id.indexOf("Child") != -1) whichEl.visibility = "hide";
  58.         }
  59.         arrange();
  60.     }
  61.     else {
  62.         divColl = document.all.tags("DIV");
  63.         for (i=0; i<divColl.length; i++) {
  64.             whichEl = divColl(i);
  65.             if (whichEl.className == "child") whichEl.style.display = "none";
  66.         }
  67.     }
  68. }
  69.  
  70. function expandIt(el) {
  71.     if (!ver4) return;
  72.     if (IE4) {
  73.         whichEl = eval(el + "Child");
  74.         whichIm = event.srcElement;
  75.         if (whichEl.style.display == "none") {
  76.             whichEl.style.display = "block";
  77.             whichIm.src = "../Icons/triUp.gif";        
  78.         }
  79.         else {
  80.             whichEl.style.display = "none";
  81.             whichIm.src = "../Icons/triDown.gif";
  82.         }
  83.     }
  84.     else {
  85.         whichEl = eval("document." + el + "Child");
  86.         whichIm = eval("document." + el + "Parent.document.images['imEx']");
  87.         if (whichEl.visibility == "hide") {
  88.             whichEl.visibility = "show";
  89.             whichIm.src = "../Icons/triUp.gif";
  90.         }
  91.         else {
  92.             whichEl.visibility = "hide";
  93.             whichIm.src = "../Icons/triDown.gif";
  94.         }
  95.         arrange();
  96.     }
  97. }
  98.  
  99. function expandAll() {
  100.     if (!ver4) return;
  101.     newSrc = (isExpanded) ? "../Icons/triDown.gif" : "triUp.gif";
  102.  
  103.     if (NS4) {
  104.         document.images["imEx"].src = newSrc;
  105.         for (i=firstInd; i<document.layers.length; i++) {
  106.             whichEl = document.layers[i];
  107.             if (whichEl.id.indexOf("Parent") != -1) {
  108.                 whichEl.document.images["imEx"].src = newSrc;
  109.             }
  110.             if (whichEl.id.indexOf("Child") != -1) {
  111.                 whichEl.visibility = (isExpanded) ? "hide" : "show";
  112.             }
  113.         }
  114.  
  115.         arrange();
  116.         if (isExpanded) scrollTo(0,document.layers[firstInd].pageY);
  117.     }
  118.     else {
  119.         divColl = document.all.tags("DIV");
  120.         for (i=0; i<divColl.length; i++) {
  121.             if (divColl(i).className == "child") {
  122.                 divColl(i).style.display = (isExpanded) ? "none" : "block";
  123.             }
  124.         }
  125.         imColl = document.images.item("imEx");
  126.         for (i=0; i<imColl.length; i++) {
  127.             imColl(i).src = newSrc;
  128.         }
  129.     }
  130.     
  131.     isExpanded = !isExpanded;
  132. }
  133.  
  134. onload = initIt;
  135.  
  136. //-->
  137. </SCRIPT>
  138.  
  139. </head>
  140. <BODY>
  141.  
  142.  
  143.  
  144.  
  145.   <center>
  146.  
  147.  
  148.  
  149.  <TABLE ID="Table1" BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH="90%" NOFINSIDE="~!   ~!" >
  150.                                     <COLGROUP>
  151.                                     <COL WIDTH="23%">
  152.                                     <COL WIDTH="17%">
  153.                                     <COL WIDTH="58%">
  154.                                     </COLGROUP>
  155.                                     <TR>
  156.                                         <TD ROWSPAN=5 WIDTH="100%" HEIGHT=1 nowrap>
  157.                                             <P>
  158.                                                 <SPAN STYLE="font-family: Tahoma,Verdana,Arial,Helvetica,sans-serif; font-size: small;">
  159.                                                 <!-- [BEGIN Picture23] -->
  160.  
  161. <!-- [END PRE-Picture23] -->
  162.                                                 <IMG ID="Picture23" HEIGHT=45 WIDTH=27 SRC="../Icons/db_l.gif" VSPACE=0 HSPACE=0 ALIGN="MIDDLE" BORDER=0 NOFINSIDE="~!   ~!" >
  163.                                                 <!-- [BEGIN POST-Picture23] -->
  164.  
  165. <!-- [END Picture23] -->   
  166.                                                 </SPAN>
  167.                                                 <B>
  168.                                                 <SPAN STYLE="font-family: Tahoma,Verdana,Arial,Helvetica,sans-serif; font-size: x-small;">
  169.                                                 {DBName}   
  170.                                                 </SPAN>
  171.                                                 </B>
  172.                                             </P>
  173.                                         </TD>
  174.                                         <TD WIDTH="17%" nowrap>
  175.                                             <P>
  176.                                                 <SPAN STYLE="font-family: Verdana,Tahoma,Arial,Helvetica,sans-serif; font-size: xx-small;">
  177.                                                 Owner:
  178.                                                 </SPAN>
  179.                                             </P>
  180.                                         </TD>
  181.                                         <TD WIDTH="58%">
  182.                                             <P>
  183.                                                 <SPAN STYLE="font-family: Verdana,Tahoma,Arial,Helvetica,sans-serif; font-size: xx-small;">
  184.                                                  {DBOwner}
  185.                                                 </SPAN>
  186.                                             </P>
  187.                                         </TD>
  188.                                     </TR>
  189.                                     <TR>
  190.                                         <TD WIDTH="17%" HEIGHT=5 nowrap>
  191.                                             <P>
  192.                                                 <SPAN STYLE="font-family: Verdana,Tahoma,Arial,Helvetica,sans-serif; font-size: xx-small;">
  193.                                                 Character set:
  194.                                                 </SPAN>
  195.                                             </P>
  196.                                         </TD>
  197.                                         <TD WIDTH="58%">
  198.                                             <P>
  199.                                                 <SPAN STYLE="font-family: Verdana,Tahoma,Arial,Helvetica,sans-serif; font-size: xx-small;">
  200.                                                  {DBCharSet}
  201.                                                 </SPAN>
  202.                                             </P>
  203.                                         </TD>
  204.                                     </TR>
  205.                                     <TR>
  206.                                         <TD WIDTH="17%" HEIGHT=-3 nowrap>
  207.                                             <P>
  208.                                                 <SPAN STYLE="font-family: Verdana,Tahoma,Arial,Helvetica,sans-serif; font-size: xx-small;">
  209.                                                 Number of tables
  210.                                                 </SPAN>
  211.                                             </P>
  212.                                         </TD>
  213.                                         <TD WIDTH="58%">
  214.                                             <P>
  215.                                                 <SPAN STYLE="font-family: Verdana,Tahoma,Arial,Helvetica,sans-serif; font-size: xx-small;">
  216.                                                  {DBTablesCount}
  217.                                                 </SPAN>
  218.                                             </P>
  219.                                         </TD>
  220.                                     </TR>
  221.                                     <TR>
  222.                                         <TD WIDTH="17%" HEIGHT=-7 nowrap>
  223.                                             <P>
  224.                                                 <SPAN STYLE="font-family: Verdana,Tahoma,Arial,Helvetica,sans-serif; font-size: xx-small;">
  225.                                                 Number of views:
  226.                                                 </SPAN>
  227.                                             </P>
  228.                                         </TD>
  229.                                         <TD WIDTH="58%">
  230.                                             <P>
  231.                                                 <SPAN STYLE="font-family: Verdana,Tahoma,Arial,Helvetica,sans-serif; font-size: xx-small;">
  232.                                                  {DBViewsCount}
  233.                                                 </SPAN>
  234.                                             </P>
  235.                                         </TD>
  236.                                     </TR>
  237.                                     <TR>
  238.                                         <TD WIDTH="17%" HEIGHT=-5 nowrap>
  239.                                             <P>
  240.                                                 <SPAN STYLE="font-family: Verdana,Tahoma,Arial,Helvetica,sans-serif; font-size: xx-small;">
  241.                                                 Number of users:
  242.                                                 </SPAN>
  243.                                             </P>
  244.                                         </TD>
  245.                                         <TD WIDTH="58%">
  246.                                             <P>
  247.                                                 <SPAN STYLE="font-family: Verdana,Tahoma,Arial,Helvetica,sans-serif; font-size: xx-small;">
  248.                                                  {DBUsersCount}
  249.                                                 </SPAN>
  250.                                             </P>
  251.                                         </TD>
  252.                                     </TR>
  253.                                 </TABLE>
  254.  
  255.                 
  256.   </center>
  257.  
  258.  
  259.                 
  260.                 <p align="center"><font face="Verdana" size="1">Click on a table 
  261.                 name to see column properties.</font></p>
  262.                 
  263.  
  264.  
  265.                   <center>
  266.                 <TABLE ID="Table1" BORDER=0 CELLSPACING=2 CELLPADDING=0 WIDTH="90%" height="1">
  267.  
  268.                     <tr>
  269.                         <TD HEIGHT=1 width="40%" nowrap>
  270.                             <P><B><font face="Tahoma" size="2">Tables</font></B></P>
  271.                         </TD>
  272.                         <TD height="1" width="20%" nowrap>
  273.                             <P><B><font face="Tahoma" size="2">Rows</font></B></P>
  274.                         </TD>
  275.                         <TD WIDTH=20% height="1" nowrap>
  276.                             <P><B><font face="Tahoma" size="2">Created</font></B></P>
  277.                         </TD>
  278.                         <TD WIDTH=20% height="1" nowrap>
  279.                             <P><B><font face="Tahoma" size="2">Modified</font></B></P>
  280.                         </TD>
  281.                     </tr>
  282.  
  283.                     
  284.                 </TABLE>
  285.  
  286.                   </center>
  287.                 
  288.                 
  289.  
  290. <! {Tables} >
  291.  
  292.  
  293.  
  294.  
  295.                 
  296.                   <center>
  297.  
  298.  
  299.                 <TABLE ID="Table1" BORDER=0 CELLSPACING=2 CELLPADDING=0 WIDTH="90%" height="1">
  300.                     
  301.                     <TR>                                       
  302.                         <TD height="1" width="40%" bgcolor="#E4E4E4" nowrap>
  303.                             <font face="Tahoma" size="1">
  304.                             <DIV ID="{DIVID}" CLASS=parent> 
  305.                             <IMG ID="Picture5" height=16 width=16 SRC="../Icons/tbl.gif" HSPACE=0 ALIGN="top" BORDER=0 > <b> 
  306.                             </b><A HREF="#" onClick="expandIt('{ExpandID}'); return false">{TableName}</A></font></DIV>                                
  307.                         </TD>
  308.                         <TD height="1" width="20%" bgcolor="#E4E4E4" nowrap>
  309.                             <P><font face="Tahoma" size="1"> {TableRows}</font></P>
  310.                         </TD>                      
  311.                         <TD WIDTH=20% height="1" bgcolor="#E4E4E4" nowrap>
  312.                             <P><font face="Tahoma" size="1"> {TableCreated}</font></P>
  313.                         </TD>    
  314.                         <TD WIDTH=20% height="1" bgcolor="#E4E4E4" nowrap>
  315.                             <P><font face="Tahoma" size="1"> {TableModified}</font></P>
  316.                         </TD>
  317.                     </TR>
  318.                    
  319.                     
  320.                 </TABLE>
  321.                   </center>
  322.                 
  323.                 
  324.  
  325.   <center>
  326.   
  327.   
  328.   
  329.   
  330.  
  331.   <p></p>
  332.   
  333.   
  334.   
  335.   
  336.  
  337.   </center>
  338.  
  339. <DIV ID="{ExpandID}Child" CLASS=child>                
  340.  
  341.                   <center>
  342.                 <TABLE ID="Table1" BORDER=0 CELLSPACING=2 CELLPADDING=0 WIDTH="60%">
  343.                 
  344.                     <TR>
  345.                         <TD WIDTH=33% height="8" bgcolor="#FFFFEC" nowrap>
  346.                             <P><B><font face="Tahoma" size="1">Columns</font></B></P>
  347.                         </TD>
  348.                         <TD WIDTH=33% height="8" bgcolor="#FFFFEC" nowrap>
  349.                             <P><B><font face="Tahoma" size="1">Lenght</font></B></P>
  350.                         </TD>
  351.                         <TD WIDTH=33% height="8" bgcolor="#FFFFEC" nowrap>
  352.                             <P><B><font face="Tahoma" size="1">Data Type</font></B></P>
  353.                         </TD>
  354.                     </TR>       
  355.  
  356. <! {Columns} >             
  357.  
  358.        
  359.                                  
  360.                     <TR>
  361.                         <TD VALIGN=bottom WIDTH=33% height="8" nowrap>
  362.                             <P><font face="Arial" size="1">
  363.                             <IMG ID="Picture3" height=16 width=16 SRC="../Icons/clmn.gif" HSPACE=0 ALIGN="middle" BORDER=0 > {ColumnName}</font>
  364.                             </P>
  365.                         </TD>
  366.                         <TD WIDTH=33% height="8" nowrap>
  367.                             <P><font face="Arial" size="1"> {ColumnLenght}</font></P>
  368.                         </TD>
  369.                         <TD WIDTH=33% height="8" nowrap>
  370.                             <P><font face="Arial" size="1"> {ColumnType}</font></P>
  371.                         </TD>
  372.                     </TR>                       
  373. <! {/Columns} >
  374.                     
  375.                 </TABLE>   
  376. </DIV>                           
  377.                   </center>
  378.  
  379.  
  380. </DIV>                
  381. <! {/Tables} >                
  382.                 
  383.   <center>
  384.                 <TABLE ID="Table3" BORDER=0 CELLSPACING=3 CELLPADDING=0 WIDTH="90%">
  385.                     <TR>
  386.                         <TD width=50% nowrap>
  387.                             <P><B><font face="Tahoma" size="2">Views</font></B></P>
  388.                         </TD>
  389.                         <TD width=50% nowrap>
  390.                             <P><B><font face="Tahoma" size="2">Command</font></B></P>
  391.                         </TD>
  392.                     </TR><! {Views} >                                        
  393.                     <TR>
  394.                         <TD width=50% bgcolor="#E4E4E4" nowrap>
  395.                             <P><font face="Tahoma" size="1"> <IMG ID="Picture12" height=16 width=16 SRC="../Icons/views.gif" HSPACE=0 ALIGN="middle" BORDER=0 >  
  396.                             {ViewName}</font>
  397.                             </P>
  398.                         </TD>
  399.                         <TD width=50% bgcolor="#E4E4E4">
  400.                             <P><font face="Tahoma" size="1"> {ViewCommand}</font></P>
  401.                         </TD>
  402.                     </TR><! {/Views} >                                        
  403.                 </TABLE>
  404.   </center>
  405.  
  406. <p> </p>
  407.  
  408.   <center>
  409.                 <TABLE ID="Table5" BORDER=0 CELLSPACING=3 CELLPADDING=0 WIDTH="90%">
  410.                     <TR>
  411.                         <TD width=50% nowrap>
  412.                             <P><B><font face="Tahoma" size="2">Users</font></B></P>
  413.                         </TD>
  414.                         <TD width=50% nowrap>
  415.                             <P><B><font face="Tahoma" size="2">Groups</font></B></P>
  416.                         </TD>
  417.                     </TR><! {Users} >                    
  418.                     <TR>
  419.                         <TD width=50% bgcolor="#E4E4E4" nowrap>
  420.                             <P><font face="Tahoma" size="1"> <IMG ID="Picture20" height=16 width=16 SRC="../Icons/user.gif" HSPACE=0 ALIGN="middle" BORDER=0 >  
  421.                             {UserName}</font>
  422.                             </P>
  423.                         </TD>
  424.                         <TD width=50% bgcolor="#E4E4E4" nowrap>
  425.                             <P><font face="Tahoma" size="1">
  426.                             <IMG ID="Picture21" height=16 width=16 SRC="../Icons/group.gif" HSPACE=0 ALIGN="middle" BORDER=0 >  
  427.                             {UserGroups}</font>
  428.                             </P>
  429.                         </TD>
  430.                     </TR><! {/Users} >                    
  431.                 </TABLE>
  432.   </center>
  433.  
  434. <p> </p>
  435. <HR ID="HRRule1" width="70%" SIZE=0 noshade color="#C0C0C0">
  436.  
  437.   <center>
  438.                 <TABLE ID="Table4" BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=273>
  439.                     <TR VALIGN=bottom>
  440.                         <TD WIDTH=60 HEIGHT=16>
  441.                             <P STYLE="TEXT-ALIGN: justify"><font face="Tahoma" size="1">
  442.                             <IMG ID="Picture15" height=16 width=16 SRC="../Icons/tbl.gif" HSPACE=0 ALIGN="top"
  443.                                  BORDER=0 > Tables</font></P>
  444.                         </TD>
  445.                         <TD WIDTH=56>
  446.                             <P STYLE="TEXT-ALIGN: justify"><font face="Tahoma" size="1">
  447.                             <IMG ID="Picture14" height=16 width=16 SRC="../Icons/views.gif" HSPACE=0 ALIGN="top"
  448.                                  BORDER=0 > Views</font></P>
  449.                         </TD>
  450.                         <TD WIDTH=65>
  451.                             <P STYLE="TEXT-ALIGN: justify"><font face="Tahoma" size="1">
  452.                             <IMG ID="Picture16" height=16 width=16 SRC="../Icons/clmn.gif" HSPACE=0 ALIGN="top"
  453.                                  BORDER=0 > Columns</font></P>
  454.                         </TD>
  455.                         <TD WIDTH=92>
  456.                             <P STYLE="TEXT-ALIGN: justify"><font face="Tahoma" size="1">
  457.                             <IMG ID="Picture17" height=16 width=16 SRC="../Icons/indkey.gif" HSPACE=0 ALIGN="top"
  458.                                  BORDER=0 
  459.      > Indexes/Keys</font></P>
  460.                         </TD>
  461.                     </TR>
  462.                 </TABLE>
  463.                 
  464.   </center>
  465.  
  466. <p STYLE="text-align: justify"> </p>
  467. <p STYLE="text-align: justify"> </p>
  468. </BODY>
  469.  
  470.  
  471. </html>