"Fossies" - the Fresh Open Source Software Archive

Member "webmysql-2.7/cgi-bin/webmysql-2.7/templates/createtablefields.html" (12 Feb 2008, 3486 Bytes) of package /linux/www/old/webmysql-2.7.tar.gz:

    1         <!--menu-->
    2         <p>Table creation for <b><!--tables--></b></p>
    3         <table>
    4             <tr>
    5                 <td valign="top">Current table layout:</td>
    6                 <td>
    7                     <table class="inputtable">
    8                         <tr><th>Field</th><th>Type</th><th>Null</th><th>Key</th><th>Default</th><th>Extra</th></tr>
    9                         <!--currentfields-->
   10                     </table>
   11                 </td>
   12             </tr>
   13             <tr><td colspan="2">&nbsp;</td></tr>
   14             <tr>
   15                 <td valign="top">Add a new field:</td>
   16                 <td>
   17                     <form action="<!--self-->" method="POST">
   18                         <input type="hidden" name="key" value="<!--key-->">
   19                         <input type="hidden" name="action" value="createtableaddfield">
   20                         <table class="inputtable">
   21                             <tr><th>Name</th><td><input type="text" name="fname"></td></tr>
   22                             <tr>
   23                                 <th>Type</th>
   24                                 <td>
   25                                     <select name="ftype">
   26                                         <option value="TINYINT">Tiny integer</option>
   27                                         <option value="SMALLINT">Small integer</option>
   28                                         <option value="MEDIUMINT">Medium integer</option>
   29                                         <option value="INT">Integer</option>
   30                                         <option value="BIGINT">Big integer</option>
   31                                         <option value="FLOAT">Floating point</option>
   32                                         <option value="DOUBLE">Double-precision floating point</option>
   33                                         <option value="DECIMAL">Decimal number</option>
   34                                         <option value="DATE">Date</option>
   35                                         <option value="DATETIME">Date and time</option>
   36                                         <option value="TIMESTAMP">Timestamp</option>
   37                                         <option value="TIME">Time</option>
   38                                         <option value="YEAR">Year</option>
   39                                         <option value="CHAR">Char</option>
   40                                         <option value="VARCHAR">Varchar</option>
   41                                         <option value="TINYBLOB">Tiny blob</option>
   42                                         <option value="BLOB">Blob</option>
   43                                         <option value="MEDIUMBLOB">Medium blob</option>
   44                                         <option value="LONGBLOB">Long blob</option>
   45                                         <option value="TINYTEXT">Tiny text</option>
   46                                         <option value="TEXT">Text</option>
   47                                         <option value="MEDIUMTEXT">Medium text</option>
   48                                         <option value="LONGTEXT">Long text</option>
   49                                         <option value="ENUM">Enum</option>
   50                                         <option value="SET">Set</option>
   51                                     </select>
   52                                 </td>
   53                             </tr>
   54                             <tr><th>Size</th><td><input type="text" name="fsize"></td></tr>
   55                             <tr><th>Null</th><td><input type="checkbox" name="fnull"></td></tr>
   56                             <tr><td colspan="2" align="center"><input type="submit" value="Add field"></td></tr>
   57                         </table>
   58                     </form>
   59                 </td>
   60             </tr>
   61             <tr><td colspan="2">&nbsp;</td></tr>
   62             <tr>
   63                 <td valign="top">Remove a field:</td>
   64                 <td>
   65                     <form action="<!--self-->" method="POST">
   66                         <input type="hidden" name="key" value="<!--key-->">
   67                         <input type="hidden" name="action" value="createtableremovefield">
   68                         <table class="inputtable">
   69                             <tr>
   70                                 <th>Name</th>
   71                                 <td>
   72                                     <select name="fname">
   73                                         <!--removefields-->
   74                                     </select>
   75                                 </td>
   76                             </tr>
   77                             <tr><td colspan="2" align="center"><input type="submit" value="Remove field"></td></tr>
   78                         </table>
   79                     </form>
   80                 </td>
   81             </tr>
   82             <tr><td colspan="2">&nbsp;</td></tr>
   83             <tr>
   84                 <td>Create this table now using the current layout:</td>
   85                 <td>
   86                     <form action="<!--self-->" method="POST">
   87                         <input type="hidden" name="key" value="<!--key-->">
   88                         <input type="hidden" name="action" value="createtablenow">
   89                         <table class="inputtable">
   90                             <tr><td><input type="submit" value="Create table"></td></tr>
   91                         </table>
   92                     </form>
   93                 </td>
   94             </tr>
   95         </table>