Update of /cvsroot/mydatabasepilot/MyDatabasePilot/dbProcessBody
In directory sc8-pr-cvs1:/tmp/cvs-serv17452
Modified Files:
ShowTables.cfm
Log Message:
Cosmetic Change: [ 720507] Drop Table, Alter Table Place holders
Index: ShowTables.cfm
===================================================================
RCS file: /cvsroot/mydatabasepilot/MyDatabasePilot/dbProcessBody/ShowTables.cfm,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** ShowTables.cfm 12 Apr 2003 04:19:24 -0000 1.2
--- ShowTables.cfm 13 Apr 2003 03:41:28 -0000 1.3
***************
*** 12,20 ****
<!---||| Show Tables in Current Database |||--->
<table width="100%" border="1" cellspacing="0" cellpadding="2">
- <tr><th colspan="3">Tables in Database:</th></tr>
<tr>
<th>Table Name</th>
! <th>Runs a SHOW FIELDS Query</th>
! <th>Runs Select Queries</th>
</tr>
<!--- Initiate a Read Only lock to ensure the integrity of session variables --->
--- 12,18 ----
<!---||| Show Tables in Current Database |||--->
<table width="100%" border="1" cellspacing="0" cellpadding="2">
<tr>
<th>Table Name</th>
! <th colspan="4">Commands</th>
</tr>
<!--- Initiate a Read Only lock to ensure the integrity of session variables --->
***************
*** 30,41 ****
<!--- Show Table Name --->
<td>#Evaluate("tableList.TABLES_IN_#dbGeneralInfo.dbInUse#")#</td>
! <!--- Link to Table Fields and Properties --->
<td><a href="#currentPath#?#session.URLToken#&dbProcess=ShowFields&table=#URLEncodedFormat(Evaluate("TABLES_IN_#dbGeneralInfo.dbInUse#"))#">View Structure</a></td>
! <!--- Link to Select Fields and Records --->
<td><a href="#currentPath#?#session.URLToken#&dbProcess=SelectRecords&table=#URLEncodedFormat(Evaluate("TABLES_IN_#dbGeneralInfo.dbInUse#"))#">View Records</a></td>
</tr>
</cfoutput>
</cflock>
<!--- Link to create a new table --->
! <tr><td colspan="3"><cflock timeout=20 throwontimeout="no" type="readonly" scope="session"><cfoutput><a href="#currentPath#?#session.URLToken#&dbProcess=CreateTable_Step1">Create New Table</a></cfoutput></cflock></td></tr>
! </table>
\ No newline at end of file
--- 28,45 ----
<!--- Show Table Name --->
<td>#Evaluate("tableList.TABLES_IN_#dbGeneralInfo.dbInUse#")#</td>
! <!--- Link to Show Table Fields and Properties --->
<td><a href="#currentPath#?#session.URLToken#&dbProcess=ShowFields&table=#URLEncodedFormat(Evaluate("TABLES_IN_#dbGeneralInfo.dbInUse#"))#">View Structure</a></td>
! <!--- Link to Show Records --->
<td><a href="#currentPath#?#session.URLToken#&dbProcess=SelectRecords&table=#URLEncodedFormat(Evaluate("TABLES_IN_#dbGeneralInfo.dbInUse#"))#">View Records</a></td>
+ <!--- Link to Alter Table--->
+ <td>Alter Table</td>
+ <!--- Link to Drop Table --->
+ <td>Drop Table</td>
</tr>
</cfoutput>
</cflock>
+ </table>
+
+ <!---||| Add New Table |||--->
<!--- Link to create a new table --->
! <cflock timeout=20 throwontimeout="no" type="readonly" scope="session"><cfoutput><a href="#currentPath#?#session.URLToken#&dbProcess=CreateTable_Step1">Create New Table</a></cfoutput></cflock>
\ No newline at end of file
|