[Mydatabasepilot-cvs] MyDatabasePilot/Query alterTable.cfm,1.25,1.26

[<nan...@us...>]

Update of /cvsroot/mydatabasepilot/MyDatabasePilot/Query
In directory sc8-pr-cvs1:/tmp/cvs-serv22428/Query

Modified Files:
	alterTable.cfm 
Log Message:
Functionality Added:
[ 773682 ] Added indexName to Unique Indexes

Index: alterTable.cfm
===================================================================
RCS file: /cvsroot/mydatabasepilot/MyDatabasePilot/Query/alterTable.cfm,v
retrieving revision 1.25
retrieving revision 1.26
diff -C2 -d -r1.25 -r1.26
*** alterTable.cfm	30 Jun 2003 21:09:12 -0000	1.25
--- alterTable.cfm	18 Jul 2003 14:33:32 -0000	1.26
***************
*** 268,276 ****
  				</cfscript>
  				</cfcase>
- <!--- ToDo Cases: --->
  				<!--- "ADD INDEX" Alter Specification --->
! 				<cfcase value="ADD INDEX"></cfcase>
  				<!--- "ADD PRIMARY KEY" Alter Specification --->
! 				<cfcase value="ADD PRIMARY KEY"></cfcase>
  				<!--- "ADD UNIQUE" Alter Specification --->
  				<cfcase value="ADD UNIQUE">
--- 268,275 ----
  				</cfscript>
  				</cfcase>
  				<!--- "ADD INDEX" Alter Specification --->
! <!--- ToDo --->	<cfcase value="ADD INDEX"></cfcase>
  				<!--- "ADD PRIMARY KEY" Alter Specification --->
! <!--- ToDo --->	<cfcase value="ADD PRIMARY KEY"></cfcase>
  				<!--- "ADD UNIQUE" Alter Specification --->
  				<cfcase value="ADD UNIQUE">
***************
*** 280,284 ****
  						htmlSQL = "#htmlSQL#<br /><span class=""KeyWord"">ADD UNIQUE</span>";
  
! // ToDo					[index_name]
  						
  						//-----------------------------------------
--- 279,285 ----
  						htmlSQL = "#htmlSQL#<br /><span class=""KeyWord"">ADD UNIQUE</span>";
  
! 						// Add indexName to Output Strings
! 						rawSQL = "#rawSQL# #ATTRIBUTES.alterSpec[i].indexName#";
! 						htmlSQL = "#htmlSQL# <span class=""String"">#ATTRIBUTES.alterSpec[i].indexName#</span>";
  						
  						//-----------------------------------------
***************
*** 315,343 ****
  				</cfcase>
  				<!--- "ADD FULLTEXT" Alter Specification --->
! 				<cfcase value="ADD FULLTEXT"></cfcase>
  				<!--- "ADD FOREIGN KEY" Alter Specification --->
! 				<cfcase value="ADD FOREIGN KEY"></cfcase>
  				<!--- "ALTER COLUMN" Alter Specification --->
! 				<cfcase value="ALTER COLUMN"></cfcase>
  				<!--- "CHANGE COLUMN" Alter Specification --->
! 				<cfcase value="CHANGE COLUMN"></cfcase>
  				<!--- "MODIFY COLUMN" Alter Specification --->
! 				<cfcase value="MODIFY COLUMN"></cfcase>
  				<!--- "DROP COLUMN" Alter Specification --->
! 				<cfcase value="DROP COLUMN"></cfcase>
  				<!--- "DROP PRIMARY KEY" Alter Specification --->
! 				<cfcase value="DROP PRIMARY KEY"></cfcase>
  				<!--- "DROP INDEX" Alter Specification --->
! 				<cfcase value="DROP INDEX"></cfcase>
  				<!--- "DISABLE KEYS" Alter Specification --->
! 				<cfcase value="DISABLE KEYS"></cfcase>
  				<!--- "ENABLE KEYS" Alter Specification --->
! 				<cfcase value="ENABLE KEYS"></cfcase>
  				<!--- "RENAME TO" Alter Specification --->
! 				<cfcase value="RENAME TO"></cfcase>
  				<!--- "ORDER BY" Alter Specification --->
! 				<cfcase value="ORDER BY"></cfcase>
  				<!--- "table_options" Alter Specification --->
! 				<cfcase value="table_options"></cfcase>
  			</cfswitch>
  		</cfloop>
--- 316,344 ----
  				</cfcase>
  				<!--- "ADD FULLTEXT" Alter Specification --->
! <!--- ToDo --->	<cfcase value="ADD FULLTEXT"></cfcase>
  				<!--- "ADD FOREIGN KEY" Alter Specification --->
! <!--- ToDo --->	<cfcase value="ADD FOREIGN KEY"></cfcase>
  				<!--- "ALTER COLUMN" Alter Specification --->
! <!--- ToDo --->	<cfcase value="ALTER COLUMN"></cfcase>
  				<!--- "CHANGE COLUMN" Alter Specification --->
! <!--- ToDo --->	<cfcase value="CHANGE COLUMN"></cfcase>
  				<!--- "MODIFY COLUMN" Alter Specification --->
! <!--- ToDo --->	<cfcase value="MODIFY COLUMN"></cfcase>
  				<!--- "DROP COLUMN" Alter Specification --->
! <!--- ToDo --->	<cfcase value="DROP COLUMN"></cfcase>
  				<!--- "DROP PRIMARY KEY" Alter Specification --->
! <!--- ToDo --->	<cfcase value="DROP PRIMARY KEY"></cfcase>
  				<!--- "DROP INDEX" Alter Specification --->
! <!--- ToDo --->	<cfcase value="DROP INDEX"></cfcase>
  				<!--- "DISABLE KEYS" Alter Specification --->
! <!--- ToDo --->	<cfcase value="DISABLE KEYS"></cfcase>
  				<!--- "ENABLE KEYS" Alter Specification --->
! <!--- ToDo --->	<cfcase value="ENABLE KEYS"></cfcase>
  				<!--- "RENAME TO" Alter Specification --->
! <!--- ToDo --->	<cfcase value="RENAME TO"></cfcase>
  				<!--- "ORDER BY" Alter Specification --->
! <!--- ToDo --->	<cfcase value="ORDER BY"></cfcase>
  				<!--- "table_options" Alter Specification --->
! <!--- ToDo --->	<cfcase value="table_options"></cfcase>
  			</cfswitch>
  		</cfloop>