166 lines
16 KiB
HTML
166 lines
16 KiB
HTML
<div id="add_col_div" class="topmargin">
|
|
<a href="#">
|
|
<span>-</span>Add new column
|
|
</a>
|
|
<form id="add_new" class="new_central_col"
|
|
method="post" action="index.php?route=/database/central-columns&lang=en">
|
|
<input type="hidden" name="db" value="test_db"><input type="hidden" name="lang" value="en"><input type="hidden" name="token" value="token">
|
|
<input type="hidden" name="add_new_column" value="add_new_column">
|
|
<div class="table-responsive">
|
|
<table class="table w-auto">
|
|
<thead>
|
|
<tr>
|
|
<th></th>
|
|
<th class="" title="" data-column="name">
|
|
Name
|
|
<div class="sorticon"></div>
|
|
</th>
|
|
<th class="" title="" data-column="type">
|
|
Type
|
|
<div class="sorticon"></div>
|
|
</th>
|
|
<th class="" title="" data-column="length">
|
|
Length/Value
|
|
<div class="sorticon"></div>
|
|
</th>
|
|
<th class="" title="" data-column="default">
|
|
Default
|
|
<div class="sorticon"></div>
|
|
</th>
|
|
<th class="" title="" data-column="collation">
|
|
Collation
|
|
<div class="sorticon"></div>
|
|
</th>
|
|
<th class="" title="" data-column="attribute">
|
|
Attribute
|
|
<div class="sorticon"></div>
|
|
</th>
|
|
<th class="" title="" data-column="isnull">
|
|
Null
|
|
<div class="sorticon"></div>
|
|
</th>
|
|
<th class="" title="" data-column="extra">
|
|
A_I
|
|
<div class="sorticon"></div>
|
|
</th>
|
|
<th></th>
|
|
</tr>
|
|
</thead>
|
|
<tbody>
|
|
<tr>
|
|
<td></td>
|
|
<td name="col_name" class="text-nowrap">
|
|
|
|
<input id="field_0_0"
|
|
type="text"
|
|
name="field_name[0]"
|
|
maxlength="64"
|
|
class="textfield form-control"
|
|
title="Column"
|
|
size="10"
|
|
value="">
|
|
|
|
</td>
|
|
<td name="col_type" class="text-nowrap">
|
|
<select class="column_type" name="field_type[0]" id="field_0_1">
|
|
<option data-length-restricted="0" title="A 4-byte integer, signed range is -2,147,483,648 to 2,147,483,647, unsigned range is 0 to 4,294,967,295">INT</option><option data-length-restricted="0" title="A variable-length (0-65,535) string, the effective maximum length is subject to the maximum row size">VARCHAR</option><option data-length-restricted="0" title="A TEXT column with a maximum length of 65,535 (2^16 - 1) characters, stored with a two-byte prefix indicating the length of the value in bytes">TEXT</option><option data-length-restricted="0" title="A date, supported range is 1000-01-01 to 9999-12-31">DATE</option><optgroup label="Numeric"><option data-length-restricted="0" title="A 1-byte integer, signed range is -128 to 127, unsigned range is 0 to 255">TINYINT</option><option data-length-restricted="0" title="A 2-byte integer, signed range is -32,768 to 32,767, unsigned range is 0 to 65,535">SMALLINT</option><option data-length-restricted="0" title="A 3-byte integer, signed range is -8,388,608 to 8,388,607, unsigned range is 0 to 16,777,215">MEDIUMINT</option><option data-length-restricted="0" title="A 4-byte integer, signed range is -2,147,483,648 to 2,147,483,647, unsigned range is 0 to 4,294,967,295">INT</option><option data-length-restricted="0" title="An 8-byte integer, signed range is -9,223,372,036,854,775,808 to 9,223,372,036,854,775,807, unsigned range is 0 to 18,446,744,073,709,551,615">BIGINT</option><option disabled>-</option><option data-length-restricted="0" title="A fixed-point number (M, D) - the maximum number of digits (M) is 65 (default 10), the maximum number of decimals (D) is 30 (default 0)">DECIMAL</option><option data-length-restricted="0" title="A small floating-point number, allowable values are -3.402823466E+38 to -1.175494351E-38, 0, and 1.175494351E-38 to 3.402823466E+38">FLOAT</option><option data-length-restricted="0" title="A double-precision floating-point number, allowable values are -1.7976931348623157E+308 to -2.2250738585072014E-308, 0, and 2.2250738585072014E-308 to 1.7976931348623157E+308">DOUBLE</option><option data-length-restricted="0" title="Synonym for DOUBLE (exception: in REAL_AS_FLOAT SQL mode it is a synonym for FLOAT)">REAL</option><option disabled>-</option><option data-length-restricted="0" title="A bit-field type (M), storing M of bits per value (default is 1, maximum is 64)">BIT</option><option data-length-restricted="0" title="A synonym for TINYINT(1), a value of zero is considered false, nonzero values are considered true">BOOLEAN</option><option data-length-restricted="0" title="An alias for BIGINT UNSIGNED NOT NULL AUTO_INCREMENT UNIQUE">SERIAL</option></optgroup><optgroup label="Date and time"><option data-length-restricted="0" title="A date, supported range is 1000-01-01 to 9999-12-31">DATE</option><option data-length-restricted="0" title="A date and time combination, supported range is 1000-01-01 00:00:00 to 9999-12-31 23:59:59">DATETIME</option><option data-length-restricted="0" title="A timestamp, range is 1970-01-01 00:00:01 UTC to 2038-01-19 03:14:07 UTC on 32-bit platforms (MariaDB 11.3 and earlier), and up to 2106-02-07 06:28:15 UTC on 64-bit platforms (MariaDB 11.5 and later), stored as the number of seconds since the epoch (1970-01-01 00:00:00 UTC)">TIMESTAMP</option><option data-length-restricted="0" title="A time, range is -838:59:59 to 838:59:59">TIME</option><option data-length-restricted="0" title="A year in four-digit (4, default) or two-digit (2) format, the allowable values are 70 (1970) to 69 (2069) or 1901 to 2155 and 0000">YEAR</option></optgroup><optgroup label="String"><option data-length-restricted="0" title="A fixed-length (0-255, default 1) string that is always right-padded with spaces to the specified length when stored">CHAR</option><option data-length-restricted="0" title="A variable-length (0-65,535) string, the effective maximum length is subject to the maximum row size">VARCHAR</option><option disabled>-</option><option data-length-restricted="0" title="A TEXT column with a maximum length of 255 (2^8 - 1) characters, stored with a one-byte prefix indicating the length of the value in bytes">TINYTEXT</option><option data-length-restricted="0" title="A TEXT column with a maximum length of 65,535 (2^16 - 1) characters, stored with a two-byte prefix indicating the length of the value in bytes">TEXT</option><option data-length-restricted="0" title="A TEXT column with a maximum length of 16,777,215 (2^24 - 1) characters, stored with a three-byte prefix indicating the length of the value in bytes">MEDIUMTEXT</option><option data-length-restricted="0" title="A TEXT column with a maximum length of 4,294,967,295 or 4GiB (2^32 - 1) characters, stored with a four-byte prefix indicating the length of the value in bytes">LONGTEXT</option><option disabled>-</option><option data-length-restricted="0" title="Similar to the CHAR type, but stores binary byte strings rather than non-binary character strings">BINARY</option><option data-length-restricted="0" title="Similar to the VARCHAR type, but stores binary byte strings rather than non-binary character strings">VARBINARY</option><option disabled>-</option><option data-length-restricted="0" title="A BLOB column with a maximum length of 255 (2^8 - 1) bytes, stored with a one-byte prefix indicating the length of the value">TINYBLOB</option><option data-length-restricted="0" title="A BLOB column with a maximum length of 65,535 (2^16 - 1) bytes, stored with a two-byte prefix indicating the length of the value">BLOB</option><option data-length-restricted="0" title="A BLOB column with a maximum length of 16,777,215 (2^24 - 1) bytes, stored with a three-byte prefix indicating the length of the value">MEDIUMBLOB</option><option data-length-restricted="0" title="A BLOB column with a maximum length of 4,294,967,295 or 4GiB (2^32 - 1) bytes, stored with a four-byte prefix indicating the length of the value">LONGBLOB</option><option disabled>-</option><option data-length-restricted="0" title="An enumeration, chosen from the list of up to 65,535 values or the special '' error value">ENUM</option><option data-length-restricted="0" title="A single value chosen from a set of up to 64 members">SET</option></optgroup><optgroup label="Spatial"><option data-length-restricted="0" title="A type that can store a geometry of any type">GEOMETRY</option><option data-length-restricted="0" title="A point in 2-dimensional space">POINT</option><option data-length-restricted="0" title="A curve with linear interpolation between points">LINESTRING</option><option data-length-restricted="0" title="A polygon">POLYGON</option><option data-length-restricted="0" title="A collection of points">MULTIPOINT</option><option data-length-restricted="0" title="A collection of curves with linear interpolation between points">MULTILINESTRING</option><option data-length-restricted="0" title="A collection of polygons">MULTIPOLYGON</option><option data-length-restricted="0" title="A collection of geometry objects of any type">GEOMETRYCOLLECTION</option></optgroup><optgroup label="JSON"><option data-length-restricted="0" title="Stores and enables efficient access to data in JSON (JavaScript Object Notation) documents">JSON</option></optgroup>
|
|
</select>
|
|
</td>
|
|
<td class="text-nowrap" name="col_length">
|
|
<input id="field_0_2" type="text" name="field_length[0]" size="8" value="" class="textfield">
|
|
<p class="enum_notice" id="enum_notice_0_2">
|
|
<a href="#" class="open_enum_editor">Edit ENUM/SET values</a>
|
|
</p>
|
|
</td>
|
|
<td class="text-nowrap" name="col_default">
|
|
<select name="field_default_type[0]" id="field_0_3" class="default_type">
|
|
<option value="NONE">None</option>
|
|
<option value="USER_DEFINED">As defined:</option>
|
|
<option value="NULL">NULL</option>
|
|
<option value="CURRENT_TIMESTAMP">CURRENT_TIMESTAMP</option>
|
|
</select>
|
|
<input type="text" name="field_default_value[0]" size="12" value="" class="textfield default_value">
|
|
</td>
|
|
<td name="collation" class="text-nowrap">
|
|
<select lang="en" dir="ltr" name="field_collation[0]" id="field_0_4">
|
|
<option value=""></option>
|
|
<optgroup label="armscii8" title="armscii8_general_ci">
|
|
<option value="armscii8_general_ci" title="Armenian, case-insensitive">armscii8_general_ci</option>
|
|
</optgroup>
|
|
<optgroup label="latin1" title="cp1252 West European">
|
|
<option value="latin1_swedish_ci" title="Swedish, case-insensitive">latin1_swedish_ci</option>
|
|
</optgroup>
|
|
<optgroup label="utf8" title="UTF-8 Unicode">
|
|
<option value="utf8_bin" title="Unicode, binary">utf8_bin</option>
|
|
<option value="utf8_general_ci" title="Unicode, case-insensitive">utf8_general_ci</option>
|
|
</optgroup>
|
|
<optgroup label="utf8mb4" title="utf8mb4_0900_ai_ci">
|
|
<option value="utf8mb4_general_ci" title="Unicode (UCA 4.0.0), case-insensitive">utf8mb4_general_ci</option>
|
|
</optgroup>
|
|
</select>
|
|
</td>
|
|
<td class="text-nowrap" name="col_attribute">
|
|
<select name="field_attribute[0]"
|
|
id="field_0_5" class="form-select">
|
|
<option value="" selected>
|
|
|
|
</option>
|
|
<option value="BINARY">
|
|
BINARY
|
|
</option>
|
|
<option value="UNSIGNED">
|
|
UNSIGNED
|
|
</option>
|
|
<option value="UNSIGNED ZEROFILL">
|
|
UNSIGNED ZEROFILL
|
|
</option>
|
|
<option value="on update CURRENT_TIMESTAMP">
|
|
on update CURRENT_TIMESTAMP
|
|
</option>
|
|
</select>
|
|
</td>
|
|
<td class="text-nowrap" name="col_isNull">
|
|
<input name="field_null[0]" id="field_0_6" type="checkbox" value="YES" class="allow_null">
|
|
</td>
|
|
<td class="text-nowrap" name="col_extra">
|
|
<input name="col_extra[0]" id="field_0_7" type="checkbox" value="auto_increment">
|
|
</td>
|
|
<td>
|
|
<input id="add_column_save" class="btn btn-primary" type="submit" value="Save">
|
|
</td>
|
|
</tr>
|
|
</tbody>
|
|
</table>
|
|
</div>
|
|
</form>
|
|
</div>
|
|
<div class="alert alert-info" role="alert">
|
|
The central list of columns for the current database is empty
|
|
</div>
|
|
|
|
<table class="table table-borderless table-sm w-auto d-inline-block">
|
|
<tr>
|
|
<td class="navigation_separator largescreenonly"></td>
|
|
<td class="central_columns_navigation">
|
|
<span class="text-nowrap"><img src="themes/dot.gif" title="Add column" alt="Add column" class="icon ic_centralColumns_add"> Add column</span>
|
|
<form id="add_column" action="index.php?route=/database/central-columns&lang=en" method="post">
|
|
<input type="hidden" name="db" value="test_db"><input type="hidden" name="lang" value="en"><input type="hidden" name="token" value="token">
|
|
<input type="hidden" name="add_column" value="add">
|
|
<input type="hidden" name="pos" value="0">
|
|
<input type="hidden" name="total_rows" value="0">
|
|
<select name="table-select" id="table-select">
|
|
<option value="" disabled selected>
|
|
Select a table
|
|
</option>
|
|
<option value="test_table">test_table</option>
|
|
</select>
|
|
<select name="column-select" id="column-select">
|
|
<option value="" selected>Select a column.</option>
|
|
</select>
|
|
<input class="btn btn-primary" type="submit" value="Add">
|
|
</form>
|
|
</td>
|
|
<td class="navigation_separator largescreenonly"></td>
|
|
</tr>
|
|
</table>
|
