[Mydatabasepilot-cvs] MyDatabasePilot/Query alterTable.cfm,1.3,1.4

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

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

Modified Files:
	alterTable.cfm 
Log Message:
Functionality Added:
[ 753698 ] Query/AlterTable.cfm
-Added Column Type
-Started Type Options

Index: alterTable.cfm
===================================================================
RCS file: /cvsroot/mydatabasepilot/MyDatabasePilot/Query/alterTable.cfm,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -d -r1.3 -r1.4
*** alterTable.cfm	13 Jun 2003 02:39:06 -0000	1.3
--- alterTable.cfm	13 Jun 2003 15:10:12 -0000	1.4
***************
*** 74,96 ****
  						<cfset rawSQL = "#rawSQL# #ATTRIBUTES.alterSpec[i].colType#">
  						<cfset htmlSQL = "#htmlSQL# <span class=""KeyWord"">#ATTRIBUTES.alterSpec[i].colType#</span>">
  					</cfif>
  				</cfcase>
  				<!--- ToDo Cases: --->
! 				<!--- ADD INDEX --->
! 				<!--- ADD PRIMARY KEY --->
! 				<!--- ADD UNIQUE --->
! 				<!--- ADD FULLTEXT --->
! 				<!--- ADD FOREIGN KEY --->
! 				<!--- ALTER COLUMN --->
! 				<!--- CHANGE COLUMN --->
! 				<!--- MODIFY COLUMN --->
! 				<!--- DROP COLUMN --->
! 				<!--- DROP PRIMARY KEY --->
! 				<!--- DROP INDEX --->
! 				<!--- DISABLE KEYS --->
! 				<!--- ENABLE KEYS --->
! 				<!--- RENAME TO --->
! 				<!--- ORDER BY --->
! 				<!--- table_options --->
  			</cfswitch>
  		</cfloop>
--- 74,135 ----
  						<cfset rawSQL = "#rawSQL# #ATTRIBUTES.alterSpec[i].colType#">
  						<cfset htmlSQL = "#htmlSQL# <span class=""KeyWord"">#ATTRIBUTES.alterSpec[i].colType#</span>">
+ 						<!--- Type Options --->
+ 						<cfswitch expression="#ATTRIBUTES.alterSpec[i].colType#">
+ 							<cfcase value="VARCHAR,CHAR"></cfcase>
+ 							<cfcase value="TINYBLOB,BLOB,MEDIUMBLOB,LONGBLOB,TINYTEXT,TEXT,MEDIUMTEXT,LONGTEXT"></cfcase>
+ 							<cfcase value="ENUM,SET"></cfcase>
+ 							<cfcase value="TINYINT,SMALLINT,MEDIUMINT,INT,BIGINT"></cfcase>
+ 							<cfcase value="FLOAT,DOUBLE,DECIMAL"></cfcase>
+ 							<cfcase value="DATE,TIME,DATETIME,YEAR,TIMESTAMP"></cfcase>
+ 							
+ 								<!---
+ 								  TINYINT[(length)] [UNSIGNED] [ZEROFILL]
+ 								  or    SMALLINT[(length)] [UNSIGNED] [ZEROFILL]
+ 								  or    MEDIUMINT[(length)] [UNSIGNED] [ZEROFILL]
+ 								  or    INT[(length)] [UNSIGNED] [ZEROFILL]
+ 								  or    INTEGER[(length)] [UNSIGNED] [ZEROFILL]
+ 								  or    BIGINT[(length)] [UNSIGNED] [ZEROFILL]
+ 								  or    REAL[(length,decimals)] [UNSIGNED] [ZEROFILL]
+ 								  or    DOUBLE[(length,decimals)] [UNSIGNED] [ZEROFILL]
+ 								  or    FLOAT[(length,decimals)] [UNSIGNED] [ZEROFILL]
+ 								  or    DECIMAL(length,decimals) [UNSIGNED] [ZEROFILL]
+ 								  or    NUMERIC(length,decimals) [UNSIGNED] [ZEROFILL]
+ 								  or    CHAR(length) [BINARY]
+ 								  or    VARCHAR(length) [BINARY]
+ 								  or    DATE
+ 								  or    TIME
+ 								  or    TIMESTAMP
+ 								  or    DATETIME
+ 								  or    TINYBLOB
+ 								  or    BLOB
+ 								  or    MEDIUMBLOB
+ 								  or    LONGBLOB
+ 								  or    TINYTEXT
+ 								  or    TEXT
+ 								  or    MEDIUMTEXT
+ 								  or    LONGTEXT
+ 								  or    ENUM(value1,value2,value3,...)
+ 								  or    SET(value1,value2,value3,...)
+ 							--->
+ 						</cfswitch>
  					</cfif>
  				</cfcase>
  				<!--- ToDo Cases: --->
! 				<cfcase value="ADD INDEX"></cfcase>
! 				<cfcase value="ADD PRIMARY KEY"></cfcase>
! 				<cfcase value="ADD UNIQUE"></cfcase>
! 				<cfcase value="ADD FULLTEXT"></cfcase>
! 				<cfcase value="ADD FOREIGN KEY"></cfcase>
! 				<cfcase value="ALTER COLUMN"></cfcase>
! 				<cfcase value="CHANGE COLUMN"></cfcase>
! 				<cfcase value="MODIFY COLUMN"></cfcase>
! 				<cfcase value="DROP COLUMN"></cfcase>
! 				<cfcase value="DROP PRIMARY KEY"></cfcase>
! 				<cfcase value="DROP INDEX"></cfcase>
! 				<cfcase value="DISABLE KEYS"></cfcase>
! 				<cfcase value="ENABLE KEYS"></cfcase>
! 				<cfcase value="RENAME TO"></cfcase>
! 				<cfcase value="ORDER BY"></cfcase>
! 				<cfcase value="table_options"></cfcase>
  			</cfswitch>
  		</cfloop>