column_default.phtml
1.88 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
<?php
// here we put 'NONE' as the default value of drop-down; otherwise
// users would have problems if they forget to enter the default
// value (example, for an INT)
$default_options = array(
'NONE' => _pgettext('for default', 'None'),
'USER_DEFINED' => __('As defined:'),
'NULL' => 'NULL',
'CURRENT_TIMESTAMP' => 'CURRENT_TIMESTAMP',
);
// for a TIMESTAMP, do not show the string "CURRENT_TIMESTAMP" as a default
// value
$defaultValue = '';
if (isset($columnMeta['DefaultValue'])) {
$defaultValue = $columnMeta['DefaultValue'];
}
if ($type_upper == 'BIT') {
$defaultValue = PMA_Util::convertBitDefaultValue($columnMeta['DefaultValue']);
} elseif ($type_upper == 'BINARY' || $type_upper == 'VARBINARY') {
$defaultValue = bin2hex($columnMeta['DefaultValue']);
}
?>
<select name="field_default_type[<?php echo $columnNumber; ?>]"
id="field_<?php echo $columnNumber; ?>_<?php echo($ci - $ci_offset); ?>"
class="default_type">
<?php foreach ($default_options as $key => $value): ?>
<option value="<?php echo $key; ?>"
<?php if (isset($columnMeta['DefaultType']) && $columnMeta['DefaultType'] == $key): ?>
selected="selected"
<?php endif; ?>>
<?php echo $value; ?>
</option>
<?php endforeach; ?>
</select>
<br />
<?php if ($GLOBALS['cfg']['CharEditing'] == 'textarea'): ?>
<textarea name="field_default_value[<?php echo $columnNumber; ?>]"
cols="15"
class="textfield
default_value">
<?php echo htmlspecialchars($defaultValue); ?>
</textarea>
<?php else: ?>
<input type="text"
name="field_default_value[<?php echo $columnNumber; ?>]"
size="12"
value="<?php echo htmlspecialchars($defaultValue); ?>"
class="textfield default_value" />
<?php endif; ?>