[Mydatabasepilot-cvs] MyDatabasePilot/Query alterTable.cfm,1.10,1.11

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

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

Modified Files:
	alterTable.cfm 
Log Message:
Functionality Added:
[ 755417 ] Added NULL | NOT NULL

Index: alterTable.cfm
===================================================================
RCS file: /cvsroot/mydatabasepilot/MyDatabasePilot/Query/alterTable.cfm,v
retrieving revision 1.10
retrieving revision 1.11
diff -C2 -d -r1.10 -r1.11
*** alterTable.cfm	16 Jun 2003 15:51:59 -0000	1.10
--- alterTable.cfm	16 Jun 2003 16:18:13 -0000	1.11
***************
*** 159,162 ****
--- 159,173 ----
  							<!--- 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>
+ 							<cfset rawSQL = "#rawSQL# NOT NULL">
+ 							<cfset htmlSQL = "#htmlSQL# <span class=""KeyWord"">NOT NULL</span>">
+ 						<cfelse>
+ 							<cfset rawSQL = "#rawSQL# NULL">
+ 							<cfset htmlSQL = "#htmlSQL# <span class=""KeyWord"">NULL</span>">
+ 						</cfif>
+ 							
+ <!--- ToDo: 			[DEFAULT default_value] [AUTO_INCREMENT] [PRIMARY KEY] [reference_definition] --->
+ <!--- ToDo:				[FIRST | AFTER column_name ]--->
  					</cfif>
  				</cfcase>