<tr class="table_interface_container_tr_top_menu_admin_area">
<td>
<table class="table_interface_container_table_top_submenu_admin_area">
<tr>
<td ><a class="bottom_menu_active" href="
data.php?function=show_tables_views&tablename=dadabik_groups"> Tables and Views </a></td>
<td ><a class="bottom_menu" href="
data.php?function=show_relationships&tablename=dadabik_groups"> Relationships </a></td>
<td ><a class="bottom_menu" href="
data.php?function=show_settings&tablename=dadabik_groups"> Settings </a></td>
<td style="width:100%"></td>
</tr>
</table>
</td>
</tr>
<tr>
<td class="table_interface_container_td_content">
<table class="table_interface_container_table_content"><tr>
<td class="td_content" valign="top">
<div id="top_messages"></div>
<span id="confirmation_message_container">
</span>
<a name="top"></a>
<h1>Data</h1>
<p>In this section you create your data structures (<a href="
#tables">tables</a> and <a href="
#views">views</a>). We store data into <strong>tables</strong>: for example you can have a <b>products</b> table, representing all your products or a <b>customers</b> table, representing all your customers. Each table has one or more fields, e.g. for a <strong>customers</strong> table you could have <strong>id, firstname, lastname, email, phone</strong>.<br><br>A <strong>view</strong>, instead, is a sort of "virtual" table that you can create, in SQL, starting from a "real" table. If you are a beginner, don't worry, you probably don't need <strong>views</strong>.
<!--<p>Search Tables/Views by name: <input type="text" name="tablename_to_search"> <input class="button_admin" type="button" value ="SEARCH" onclick="alert('Search will be available in a future release.')"></p>-->
<a name="tables"></a>
<h2>TABLES</h2>
<form method="POST" action="
data.php?function=create_table&tablename=dadabik_groups">Create a new table with name: <input type="text" name="tablename_to_create"> <input class="button_admin" type="submit" value ="CREATE"></form>
<a name="anchor_new_table_to_test"></a><div id="container_new_table_to_test"><h2>new_table_to_test</h2><form id="drop_table_form_0"><input type="hidden" name="tablename_to_drop" value="new_table_to_test"><input type="hidden" name="table_type_to_drop" value="table"><input class="button_admin" type="submit" value="DELETE TABLE"> <!--<input class="button_admin" type="button" value="CLONE TABLE" onclick="alert('Table cloning will be available in a future release.')">--> <a class="button button_admin" href="
internal_table_manager.php?tablename=new_table_to_test&reset_preview=1" target="_blank" title="Open in a new tab the form configurator for the table new_table_to_test">FORM CONFIGURATOR </a></form><form id="alter_table_form_0"><input type="hidden" name="tablename_to_alter" value="new_table_to_test"><p><div style="width:156px;display:inline-block" ><b>Field name</b></div> <div style="width:156px;display:inline-block"><b>Field type <a href="javascript:show_admin_help('Field type', 'You are using simple data types (see settings).<br><br>If you are an advanced user, maybe you wan to know the correspondance between these data types and the mysql data types:<br><ul>
<li>Integer number: integer
<li>Decimal number: decimal(12,2)
<li>Float number: float
<li>Short text: varchar(255)
<li>Long text: text
<li>Date: date
<li>Date and time: datetime
<li>Time: time
</ul>');"><img alt="Help" title="Help" border="0" src="
images/help.png" /></a></b></div> <div style="width:100px;display:inline-block"><b>Nullable <a href="javascript:show_admin_help('Nullable', 'Choose <i>Yes</i> if you allow the <i>NULL</i> value for this field. If a field is required, you should choose <i>No</i>.');"><img alt="Help" title="Help" border="0" src="
images/help.png" /></a></b></div><div style="width:150px;display:inline-block" ><b>PK index <a href="javascript:show_admin_help('PK index', 'If the field is a primary key, choose <i>Primary Key</i>.<br>You can have only one primary key in your table and must be <i>nullable</i>: no.<br><br>If you change the PK of a table, DaDaBIK automatically changes the unique field in the pages section.');"><img alt="Help" title="Help" border="0" src="
images/help.png" /></a></b></div><div style="width:180px;display:inline-block" ><b>Extra <a href="javascript:show_admin_help('Extra', 'Only for Primary Key fields you can set AUTO_INCREMENT if you want to automatically get a numeric value (1, 2, 3, ...) for this field when you insert a new record.');"><img alt="Help" title="Help" border="0" src="
images/help.png" /></a></b></div><div style="width:150px;display:inline-block"><b>Linked table <a href="javascript:show_admin_help('Linked table (lookup)', 'If this is a lookup field (a field taking the options from another table, e.g. in a table <i>customers</i> you could have a drop down menu field <i>country</i> and you could take the available options from the <i>countries</i> table), in this coulumn you see the corresponding linked table, otherwise you see <i>No</i>.<br><br>To define a field as <i>lookup</i>, from the form configurator you should set a compatible field type (e.g. <i>select_single</i>) and then set <i>Lookup table name</i>, <i>Lookup table linked fields</i> and the other required parameters.');"><img alt="Help" title="Help" border="0" src="
images/help.png" /></a></b></div></p><div id="container_new_table_to_test_0" data-fieldname="id" data-tablename="new_table_to_test"><p><input type="text" style="width:150px" name="name_field_0" value="id"> <select style="width:150px" name="type_field_0"><option value=""></option><option value="int"