[Mydatabasepilot-cvs] MyDatabasePilot/Query alterTable.cfm,1.12,1.13

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

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

Modified Files:
	alterTable.cfm 
Log Message:
Functionality Added:
[ 755523 ] Added AUTO_INCREMENT to Integer Types

Index: alterTable.cfm
===================================================================
RCS file: /cvsroot/mydatabasepilot/MyDatabasePilot/Query/alterTable.cfm,v
retrieving revision 1.12
retrieving revision 1.13
diff -C2 -d -r1.12 -r1.13
*** alterTable.cfm	16 Jun 2003 17:50:41 -0000	1.12
--- alterTable.cfm	16 Jun 2003 20:36:45 -0000	1.13
***************
*** 72,75 ****
--- 72,79 ----
  						<cfset htmlSQL = "#htmlSQL# <span class=""Missing"">DataTypeNotSpecified_#i#</span>">
  					<cfelse>
+ 						<!--- Initialize Integer and Numeric Type to FALSE --->
+ 						<cfset isIntegerCol = FALSE />
+ 						<cfset isNumericCol = FALSE />
+ 						<!--- Add Column Type to Output Strings --->
  						<cfset rawSQL = "#rawSQL# #ATTRIBUTES.alterSpec[i].colType#">
  						<cfset htmlSQL = "#htmlSQL# <span class=""KeyWord"">#ATTRIBUTES.alterSpec[i].colType#</span>">
***************
*** 98,101 ****
--- 102,108 ----
  							</cfcase>
  							<cfcase value="TINYINT,SMALLINT,MEDIUMINT,INT,INTEGER,BIGINT">
+ 								<!--- Set Integer and Numeric Type to TRUE --->
+ 								<cfset isIntegerCol = TRUE />
+ 								<cfset isNumericCol = TRUE />
  								<!--- Add Length to Output Strings if Specified --->
  								<cfif ATTRIBUTES.alterSpec[i].length IS NOT "">
***************
*** 103,118 ****
  									<cfset htmlSQL = "#htmlSQL#(<span class=""Number"">#ATTRIBUTES.alterSpec[i].length#</span>)">
  								</cfif>
- 								<!--- Add Unsigned to Output Strings if Specified --->
- 								<cfif ATTRIBUTES.alterSpec[i].unsigned>
- 									<cfset rawSQL = "#rawSQL# UNSIGNED">
- 									<cfset htmlSQL = "#htmlSQL# <span class=""KeyWord"">UNSIGNED</span>">
- 								</cfif>
- 								<!--- Add Zerofill to Output Strings if Specified --->
- 								<cfif ATTRIBUTES.alterSpec[i].zerofill>
- 									<cfset rawSQL = "#rawSQL# ZEROFILL">
- 									<cfset htmlSQL = "#htmlSQL# <span class=""KeyWord"">ZEROFILL</span>">
- 								</cfif>
  							</cfcase>
  							<cfcase value="REAL,FLOAT,DOUBLE">
  								<!--- Add Length and Decimals to Output Strings if Specified --->
  								<cfif ATTRIBUTES.alterSpec[i].length IS NOT "">
--- 110,117 ----
  									<cfset htmlSQL = "#htmlSQL#(<span class=""Number"">#ATTRIBUTES.alterSpec[i].length#</span>)">
  								</cfif>
  							</cfcase>
  							<cfcase value="REAL,FLOAT,DOUBLE">
+ 								<!--- Set Numeric Type to TRUE --->
+ 								<cfset isNumericCol = TRUE />
  								<!--- Add Length and Decimals to Output Strings if Specified --->
  								<cfif ATTRIBUTES.alterSpec[i].length IS NOT "">
***************
*** 120,135 ****
  									<cfset htmlSQL = "#htmlSQL#(<span class=""Number"">#ATTRIBUTES.alterSpec[i].length#</span>,<span class=""Number"">#ATTRIBUTES.alterSpec[i].numberOfDecimals#</span>)">
  								</cfif>
- 								<!--- Add Unsigned to Output Strings if Specified --->
- 								<cfif ATTRIBUTES.alterSpec[i].unsigned>
- 									<cfset rawSQL = "#rawSQL# UNSIGNED">
- 									<cfset htmlSQL = "#htmlSQL# <span class=""KeyWord"">UNSIGNED</span>">
- 								</cfif>
- 								<!--- Add Zerofill to Output Strings if Specified --->
- 								<cfif ATTRIBUTES.alterSpec[i].zerofill>
- 									<cfset rawSQL = "#rawSQL# ZEROFILL">
- 									<cfset htmlSQL = "#htmlSQL# <span class=""KeyWord"">ZEROFILL</span>">
- 								</cfif>
  							</cfcase>
  							<cfcase value="DECIMAL,NUMERIC">
  								<!--- Add Length to Output Strings --->
  								<cfif ATTRIBUTES.alterSpec[i].length IS "" AND ATTRIBUTES.alterSpec[i].numberOfDecimals IS "">
--- 119,126 ----
  									<cfset htmlSQL = "#htmlSQL#(<span class=""Number"">#ATTRIBUTES.alterSpec[i].length#</span>,<span class=""Number"">#ATTRIBUTES.alterSpec[i].numberOfDecimals#</span>)">
  								</cfif>
  							</cfcase>
  							<cfcase value="DECIMAL,NUMERIC">
+ 								<!--- Set Numeric Type to TRUE --->
+ 								<cfset isNumericCol = TRUE />
  								<!--- Add Length to Output Strings --->
  								<cfif ATTRIBUTES.alterSpec[i].length IS "" AND ATTRIBUTES.alterSpec[i].numberOfDecimals IS "">
***************
*** 146,162 ****
  									<cfset htmlSQL = "#htmlSQL#(<span class=""Number"">#ATTRIBUTES.alterSpec[i].length#</span>,<span class=""Number"">#ATTRIBUTES.alterSpec[i].numberOfDecimals#</span>)">
  								</cfif>
- 								<!--- Add Unsigned to Output Strings if Specified --->
- 								<cfif ATTRIBUTES.alterSpec[i].unsigned>
- 									<cfset rawSQL = "#rawSQL# UNSIGNED">
- 									<cfset htmlSQL = "#htmlSQL# <span class=""KeyWord"">UNSIGNED</span>">
- 								</cfif>
- 								<!--- Add Zerofill to Output Strings if Specified --->
- 								<cfif ATTRIBUTES.alterSpec[i].zerofill>
- 									<cfset rawSQL = "#rawSQL# ZEROFILL">
- 									<cfset htmlSQL = "#htmlSQL# <span class=""KeyWord"">ZEROFILL</span>">
- 								</cfif>
  							</cfcase>
  							<!--- NO Specific Options (Only Generic like Is NULL) for TINYBLOB,BLOB,MEDIUMBLOB,LONGBLOB,TINYTEXT,TEXT,MEDIUMTEXT,LONGTEXT,DATE,TIME,DATETIME,YEAR,TIMESTAMP--->
  						</cfswitch>
  						<!--- Add NULL | NOT NULL to Output Strings --->
  						<cfif ATTRIBUTES.alterSpec[i].notNull>
--- 137,153 ----
  									<cfset htmlSQL = "#htmlSQL#(<span class=""Number"">#ATTRIBUTES.alterSpec[i].length#</span>,<span class=""Number"">#ATTRIBUTES.alterSpec[i].numberOfDecimals#</span>)">
  								</cfif>
  							</cfcase>
  							<!--- NO Specific Options (Only Generic like Is NULL) for TINYBLOB,BLOB,MEDIUMBLOB,LONGBLOB,TINYTEXT,TEXT,MEDIUMTEXT,LONGTEXT,DATE,TIME,DATETIME,YEAR,TIMESTAMP--->
  						</cfswitch>
+ 						<!--- Add Unsigned to Output Strings if Specified and is Numeric Column --->
+ 						<cfif ATTRIBUTES.alterSpec[i].unsigned AND isNumericCol>
+ 							<cfset rawSQL = "#rawSQL# UNSIGNED">
+ 							<cfset htmlSQL = "#htmlSQL# <span class=""KeyWord"">UNSIGNED</span>">
+ 						</cfif>
+ 						<!--- Add Zerofill to Output Strings if Specified and is Numeric Column --->
+ 						<cfif ATTRIBUTES.alterSpec[i].zerofill AND isNumericCol>
+ 							<cfset rawSQL = "#rawSQL# ZEROFILL">
+ 							<cfset htmlSQL = "#htmlSQL# <span class=""KeyWord"">ZEROFILL</span>">
+ 						</cfif>
  						<!--- Add NULL | NOT NULL to Output Strings --->
  						<cfif ATTRIBUTES.alterSpec[i].notNull>
***************
*** 167,177 ****
  							<cfset htmlSQL = "#htmlSQL# <span class=""KeyWord"">NULL</span>">
  						</cfif>
! 						<!--- Add DEFAULT to Output Strings --->
  						<cfif ATTRIBUTES.alterSpec[i].defaultValue IS NOT "">
  							<cfset rawSQL = "#rawSQL# DEFAULT #ATTRIBUTES.alterSpec[i].defaultValue#">
  							<cfset htmlSQL = "#htmlSQL# <span class=""KeyWord"">DEFAULT</span> <span class=""String"">#ATTRIBUTES.alterSpec[i].defaultValue#</span>">
  						</cfif>
  						
! <!--- ToDo: 			[AUTO_INCREMENT] [PRIMARY KEY] [reference_definition] --->
  <!--- ToDo:				[FIRST | AFTER column_name ]--->
  					</cfif>
--- 158,173 ----
  							<cfset htmlSQL = "#htmlSQL# <span class=""KeyWord"">NULL</span>">
  						</cfif>
! 						<!--- Add DEFAULT to Output Strings if Specified --->
  						<cfif ATTRIBUTES.alterSpec[i].defaultValue IS NOT "">
  							<cfset rawSQL = "#rawSQL# DEFAULT #ATTRIBUTES.alterSpec[i].defaultValue#">
  							<cfset htmlSQL = "#htmlSQL# <span class=""KeyWord"">DEFAULT</span> <span class=""String"">#ATTRIBUTES.alterSpec[i].defaultValue#</span>">
  						</cfif>
+ 						<!--- Add AUTO_INCREMENT to Output Strings if Specified and is Integer Column --->
+ 						<cfif ATTRIBUTES.alterSpec[i].autoIncrement AND isIntegerCol>
+ 							<cfset rawSQL = "#rawSQL# AUTO_INCREMENT">
+ 							<cfset htmlSQL = "#htmlSQL# <span class=""KeyWord"">AUTO_INCREMENT</span>">
+ 						</cfif>
  						
! <!--- ToDo: 			[PRIMARY KEY] [reference_definition] --->
  <!--- ToDo:				[FIRST | AFTER column_name ]--->
  					</cfif>