[Mydatabasepilot-cvs] MyDatabasePilot/dbProcessBody AddField.cfm,1.6,1.7
Status: Alpha
Brought to you by:
nanoface
From: <nan...@us...> - 2003-06-11 03:05:08
|
Update of /cvsroot/mydatabasepilot/MyDatabasePilot/dbProcessBody In directory sc8-pr-cvs1:/tmp/cvs-serv22513/dbProcessBody Modified Files: AddField.cfm Log Message: Internal Structure Changed: [ 752338 ] Moved Set Default Values from : dbProcessBody/AddField.cfm to : dbProcessInit/AddField.cfm Index: AddField.cfm =================================================================== RCS file: /cvsroot/mydatabasepilot/MyDatabasePilot/dbProcessBody/AddField.cfm,v retrieving revision 1.6 retrieving revision 1.7 diff -C2 -d -r1.6 -r1.7 *** AddField.cfm 5 Jun 2003 04:20:54 -0000 1.6 --- AddField.cfm 11 Jun 2003 03:05:04 -0000 1.7 *************** *** 1,525 **** ! <!---******************************************************************************************* ! * Copyright: MyDatabase Pilot is distributed under the terms of the GNU GPL license * ! * Template: dbProcessBody/AddField.cfm * ! * Purpose: Displays the Body Content for the AddField Database Process * ! * Requiremets: -fieldList Query must be run on same page prior to including this template * ! * -URL.table (table name) must have been passed from calling template * ! ********************************************************************************************---> ! ! <!---||| Set Default Values |||---> ! <cfparam name="FORM.numberOfFields" default="1" /> [...1018 lines suppressed...] ! </fieldset> ! ! <!---||| Submit Request |||---> ! <fieldset class="Fancy"> ! <legend class="Fancy">Run Alter Table Query</legend> ! <!---***Insert a query box of the SQL that is about to be executed***---> ! <input name="ExecuteAlterTable" type="submit" value="Add Fields as Defined Above"> ! </fieldset> ! </cfform> ! </cflock> ! ! ! ! <h3>Quick Reference Notes</h3> ! <ul> ! <li>Note that if you specify ZEROFILL for a column, MySQL will automatically add the UNSIGNED attribute to the column.</li> ! <li>BLOB and TEXT field types can not have default values.</li> ! <li>A DEFAULT value has to be a constant, it cannot be a function or an expression.</li> ! <li>When putting an index on a BLOB or TEXT column, you MUST always specify the length of the index.</li> </ul> |