[Mydatabasepilot-cvs] MyDatabasePilot/Query alterTable.cfm,1.17,1.18

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

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

Modified Files:
	alterTable.cfm 
Log Message:
Functionality Added:
[ 757937 ] Added Single Column Primary Key to AlterTable Query 
in "ADD COLUMN" format 

Index: alterTable.cfm
===================================================================
RCS file: /cvsroot/mydatabasepilot/MyDatabasePilot/Query/alterTable.cfm,v
retrieving revision 1.17
retrieving revision 1.18
diff -C2 -d -r1.17 -r1.18
*** alterTable.cfm	18 Jun 2003 15:11:29 -0000	1.17
--- alterTable.cfm	20 Jun 2003 15:17:51 -0000	1.18
***************
*** 187,192 ****
  							<cfset htmlSQL = "#htmlSQL# <span class=""KeyWord"">AUTO_INCREMENT</span>" />
  						</cfif>
! 						
! <!--- ToDo: 			[PRIMARY KEY] [reference_definition] --->
  
  						<!---||| Location of new Field : [FIRST | AFTER column_name ] |||--->
--- 187,197 ----
  							<cfset htmlSQL = "#htmlSQL# <span class=""KeyWord"">AUTO_INCREMENT</span>" />
  						</cfif>
! 						<!--- Add Single Column PRIMARY KEY to Output Strings if Specified --->
! 						<cfif ATTRIBUTES.alterSpec[i].key IS "Primary">
! 							<cfset rawSQL = "#rawSQL# PRIMARY KEY" />
! 							<cfset htmlSQL = "#htmlSQL# <span class=""KeyWord"">PRIMARY KEY</span>" />
! 						</cfif>
! 
! <!--- ToDo: 			[reference_definition] --->
  
  						<!---||| Location of new Field : [FIRST | AFTER column_name ] |||--->