[Mydatabasepilot-cvs] MyDatabasePilot/Query alterTable.cfm,1.8,1.9

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

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

Modified Files:
	alterTable.cfm 
Log Message:
Internal Structure Changed:
Rearanged CFSWITCH

Index: alterTable.cfm
===================================================================
RCS file: /cvsroot/mydatabasepilot/MyDatabasePilot/Query/alterTable.cfm,v
retrieving revision 1.8
retrieving revision 1.9
diff -C2 -d -r1.8 -r1.9
*** alterTable.cfm	16 Jun 2003 14:35:44 -0000	1.8
--- alterTable.cfm	16 Jun 2003 15:10:16 -0000	1.9
***************
*** 91,110 ****
  								</cfif>
  							</cfcase>
- 							<cfcase value="TINYBLOB,BLOB,MEDIUMBLOB,LONGBLOB,TINYTEXT,TEXT,MEDIUMTEXT,LONGTEXT">
- 								<!---
- 										TINYBLOB
- 										BLOB
- 										MEDIUMBLOB
- 										LONGBLOB
- 										TINYTEXT
- 										TEXT
- 										MEDIUMTEXT
- 										LONGTEXT
- 								--->
- 							</cfcase>
  							<cfcase value="ENUM,SET">
! 								<!---
  									ENUM(value1,value2,value3,...)
! 									SET(value1,value2,value3,...)</cfcase>
  								--->
  							</cfcase>
--- 91,98 ----
  								</cfif>
  							</cfcase>
  							<cfcase value="ENUM,SET">
! <!--- TODO:
  									ENUM(value1,value2,value3,...)
! 									SET(value1,value2,value3,...)
  								--->
  							</cfcase>
***************
*** 115,125 ****
  									<cfset htmlSQL = "#htmlSQL#(<span class=""Number"">#ATTRIBUTES.alterSpec[i].length#</span>)">
  								</cfif>
! 								<!---
! 										TINYINT[(length)] [UNSIGNED] [ZEROFILL]
! 								  		SMALLINT[(length)] [UNSIGNED] [ZEROFILL]
! 								  		MEDIUMINT[(length)] [UNSIGNED] [ZEROFILL]
! 								  		INT[(length)] [UNSIGNED] [ZEROFILL]
! 								  		INTEGER[(length)] [UNSIGNED] [ZEROFILL]
! 								  		BIGINT[(length)] [UNSIGNED] [ZEROFILL]
  								--->
  							</cfcase>
--- 103,108 ----
  									<cfset htmlSQL = "#htmlSQL#(<span class=""Number"">#ATTRIBUTES.alterSpec[i].length#</span>)">
  								</cfif>
! <!--- TODO:
! 										[UNSIGNED] [ZEROFILL]
  								--->
  							</cfcase>
***************
*** 130,137 ****
  									<cfset htmlSQL = "#htmlSQL#(<span class=""Number"">#ATTRIBUTES.alterSpec[i].length#</span>,<span class=""Number"">#ATTRIBUTES.alterSpec[i].numberOfDecimals#</span>)">
  								</cfif>
! 								<!--- 
! 										REAL[(length,decimals)] [UNSIGNED] [ZEROFILL]
! 										DOUBLE[(length,decimals)] [UNSIGNED] [ZEROFILL]
! 										FLOAT[(length,decimals)] [UNSIGNED] [ZEROFILL]
  								--->
  							</cfcase>
--- 113,118 ----
  									<cfset htmlSQL = "#htmlSQL#(<span class=""Number"">#ATTRIBUTES.alterSpec[i].length#</span>,<span class=""Number"">#ATTRIBUTES.alterSpec[i].numberOfDecimals#</span>)">
  								</cfif>
! <!--- TODO:
! 										[UNSIGNED] [ZEROFILL]
  								--->
  							</cfcase>
***************
*** 152,168 ****
  								</cfif>
  
! 								<!---
! 										DECIMAL(length,decimals) [UNSIGNED] [ZEROFILL]
! 										NUMERIC(length,decimals) [UNSIGNED] [ZEROFILL]
! 								--->
! 							</cfcase>
! 							<cfcase value="DATE,TIME,DATETIME,YEAR,TIMESTAMP">
! 								<!---
! 										DATE
! 										TIME
! 										TIMESTAMP
! 										DATETIME
  								--->
  							</cfcase>
  						</cfswitch>
  					</cfif>
--- 133,141 ----
  								</cfif>
  
! <!--- TODO:
! 										[UNSIGNED] [ZEROFILL]
  								--->
  							</cfcase>
+ 							<!--- NO Specific Options (Only Generic like Is NULL) for TINYBLOB,BLOB,MEDIUMBLOB,LONGBLOB,TINYTEXT,TEXT,MEDIUMTEXT,LONGTEXT,DATE,TIME,DATETIME,YEAR,TIMESTAMP--->
  						</cfswitch>
  					</cfif>