[Mydatabasepilot-cvs] MyDatabasePilot/Query alterTable.cfm,1.27,1.28

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

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

Modified Files:
	alterTable.cfm 
Log Message:
Functionality Added:
[ 773696 ] Added "ADD FULLTEXT" AlterSpec

Index: alterTable.cfm
===================================================================
RCS file: /cvsroot/mydatabasepilot/MyDatabasePilot/Query/alterTable.cfm,v
retrieving revision 1.27
retrieving revision 1.28
diff -C2 -d -r1.27 -r1.28
*** alterTable.cfm	18 Jul 2003 14:46:31 -0000	1.27
--- alterTable.cfm	18 Jul 2003 14:53:25 -0000	1.28
***************
*** 272,276 ****
  				<cfcase value="ADD INDEX">
  					<cfscript>
! 						// Add "ADD UNIQUE" Keywords to Output Strings
  						rawSQL = "#rawSQL# ADD INDEX";
  						htmlSQL = "#htmlSQL#<br /><span class=""KeyWord"">ADD INDEX</span>";
--- 272,276 ----
  				<cfcase value="ADD INDEX">
  					<cfscript>
! 						// Add "ADD INDEX" Keywords to Output Strings
  						rawSQL = "#rawSQL# ADD INDEX";
  						htmlSQL = "#htmlSQL#<br /><span class=""KeyWord"">ADD INDEX</span>";
***************
*** 359,364 ****
  					</cfscript>
  				</cfcase>
  				<!--- "ADD FULLTEXT" Alter Specification --->
! <!--- ToDo --->	<cfcase value="ADD FULLTEXT"></cfcase>
  				<!--- "ADD FOREIGN KEY" Alter Specification --->
  <!--- ToDo --->	<cfcase value="ADD FOREIGN KEY"></cfcase>
--- 359,406 ----
  					</cfscript>
  				</cfcase>
+ 				
  				<!--- "ADD FULLTEXT" Alter Specification --->
! 				<cfcase value="ADD FULLTEXT">
! 					<cfscript>
! 						// Add "ADD FULLTEXT" Keywords to Output Strings
! 						rawSQL = "#rawSQL# ADD FULLTEXT";
! 						htmlSQL = "#htmlSQL#<br /><span class=""KeyWord"">ADD FULLTEXT</span>";
! 
! 						// Add indexName to Output Strings
! 						rawSQL = "#rawSQL# #ATTRIBUTES.alterSpec[i].indexName#";
! 						htmlSQL = "#htmlSQL# <span class=""String"">#ATTRIBUTES.alterSpec[i].indexName#</span>";
! 						
! 						//-----------------------------------------
! 						// Add Index Column Names to Output Strings
! 						//-----------------------------------------
! 
! 						// Add Opening Bracked to Output Strings
! 						rawSQL = "#rawSQL# (";
! 						htmlSQL = "#htmlSQL# (";
! 					
! 						// Add Index Column Names to Output Strings
! 						for(j=1; j EQ arrayLen(ATTRIBUTES.alterSpec[i].index_col_names); j=j+1){
! 							// If this is a multi column index and is not the first Index Column Name, then add a comma to the last Index Column Name
! 							if(j GT 1){
! 								rawSQL = "#rawSQL#,";
! 								htmlSQL = "#htmlSQL#,";
! 							}
! 							
! 							// Add Index Column Name to Output Strings
! 							if(ATTRIBUTES.alterSpec[i].index_col_names[j] IS ""){
! 								rawSQL = "#rawSQL#NameNotSpecified";
! 								htmlSQL = "#htmlSQL#<span class=""Missing"">NameNotSpecified</span>";
! 							}
! 							else{
! 								rawSQL = "#rawSQL##ATTRIBUTES.alterSpec[i].index_col_names[j]#";
! 								htmlSQL = "#htmlSQL#<span class=""String"">#ATTRIBUTES.alterSpec[i].index_col_names[j]#</span>";
! 							}
! 						}
! 						
! 						// Add Closing Bracked to Output Strings
! 						rawSQL = "#rawSQL#)";
! 						htmlSQL = "#htmlSQL#)";
! 					</cfscript>
! 				</cfcase>
  				<!--- "ADD FOREIGN KEY" Alter Specification --->
  <!--- ToDo --->	<cfcase value="ADD FOREIGN KEY"></cfcase>