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 ] |||--->
|
