m |
m |
||
| Line 6: | Line 6: | ||
On the screen that opens you'll be asked to enter the fields' names and the corresponding properties. The properties are as follows: | On the screen that opens you'll be asked to enter the fields' names and the corresponding properties. The properties are as follows: | ||
| − | |||
* '''Type''' | * '''Type''' | ||
This field allows you to pick the type of the data stored in the corresponding field. See more about the possible choices [http://dev.mysql.com/doc/refman/5.0/en/data-types.html here]. | This field allows you to pick the type of the data stored in the corresponding field. See more about the possible choices [http://dev.mysql.com/doc/refman/5.0/en/data-types.html here]. | ||
| − | |||
* '''Length/Values''' | * '''Length/Values''' | ||
The length of the database table field should be entered here. In case the field type is "enum" or "set", enter the values using the following format: 'a','b','c', etc. | The length of the database table field should be entered here. In case the field type is "enum" or "set", enter the values using the following format: 'a','b','c', etc. | ||
| − | |||
* '''Collation''' | * '''Collation''' | ||
| Line 36: | Line 33: | ||
'''''ON UPDATE CURRENT_TIMESTAMP''''' - the current timestamp is the default | '''''ON UPDATE CURRENT_TIMESTAMP''''' - the current timestamp is the default | ||
value for the data type field, and is automatically updated; | value for the data type field, and is automatically updated; | ||
| − | |||
* '''Null''' | * '''Null''' | ||
This allows you to define whether the field value can be NULL. More information about the NULL value can be found [http://dev.mysql.com/doc/refman/5.0/en/problems-with-null.html here]. | This allows you to define whether the field value can be NULL. More information about the NULL value can be found [http://dev.mysql.com/doc/refman/5.0/en/problems-with-null.html here]. | ||
| − | |||
* '''Default''' | * '''Default''' | ||
Here you can set the default value for the field. | Here you can set the default value for the field. | ||
| − | |||
* '''Extra''' | * '''Extra''' | ||
| Line 53: | Line 47: | ||
The radio buttons specify an Index for the particular field and the Index type. | The radio buttons specify an Index for the particular field and the Index type. | ||
| − | |||
* '''Comments''' | * '''Comments''' | ||
.jpg)
