Server IP : 23.254.227.96 / Your IP : 216.73.216.7 Web Server : Apache/2.4.62 (Unix) OpenSSL/1.1.1k System : Linux hwsrv-1277026.hostwindsdns.com 4.18.0-477.13.1.el8_8.x86_64 #1 SMP Tue May 30 14:53:41 EDT 2023 x86_64 User : viralblo ( 1001) PHP Version : 8.1.31 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : ON Directory : /usr/local/cwpsrv/var/services/pma_01-03-2025.bak/templates/table/relation/ |
Upload File : |
<form method="post" action="tbl_relation.php"> <?= PMA\libraries\URL::getHiddenInputs($db, $table); ?> <!-- InnoDB --> <?php if (PMA\libraries\Util::isForeignKeySupported($tbl_storage_engine)): ?> <fieldset> <legend><?= __('Foreign key constraints'); ?></legend> <table id="foreign_keys" class="relationalTable"> <tr> <th><?= __('Actions'); ?></th> <th><?= __('Constraint properties'); ?></th> <?php if (strtoupper($tbl_storage_engine) == 'INNODB'): ?> <th><?= __('Column') , PMA\libraries\Util::showHint(__( 'Creating a foreign key over a non-indexed column would automatically create' . ' an index on it. Alternatively, you can define an index below, before creating' . ' the foreign key.' )) ?> </th> <?php else: ?> <th><?= __('Column') , PMA\libraries\Util::showHint(__( 'Only columns with index will be displayed. You can define an' . ' index below.' )) ?> </th> <?php endif; ?> <th colspan="3"> <?= __('Foreign key constraint'); ?> (<?= $tbl_storage_engine; ?>) </th> </tr> <tr> <th></th> <th></th> <th></th> <th><?= __('Database'); ?></th> <th><?= __('Table'); ?></th> <th><?= __('Column'); ?></th> </tr> <?php $i = 0; ?> <?php if (! empty($existrel_foreign)): ?> <?php foreach ($existrel_foreign as $key => $one_key): ?> <?= PMA\libraries\Template::get('table/relation/foreign_key_row')->render( array( 'one_key' => $one_key, 'columns' => $columns, 'i' => $i++, 'options_array' => $options_array, 'tbl_storage_engine' => $tbl_storage_engine, 'db' => $db ) ); ?> <?php endforeach; ?> <?php endif; ?> <?= PMA\libraries\Template::get('table/relation/foreign_key_row')->render( array( 'one_key' => array(), 'columns' => $columns, 'i' => $i++, 'options_array' => $options_array, 'tbl_storage_engine' => $tbl_storage_engine, 'db' => $db ) ); ?> <tr> <th colspan="6"> <a class="formelement clearfloat add_foreign_key" href=""> <?= __('+ Add constraint'); ?> </td> </tr> </table> </fieldset> <?php endif; ?> <?php if ($cfgRelation['relwork']): ?> <?php if (PMA\libraries\Util::isForeignKeySupported($tbl_storage_engine)): ?> <br/> <?= PMA\libraries\Util::getDivForSliderEffect('ir_div', __('Internal relationships')) ?> <?php endif; ?> <?php $save_row = array_values($columns); $saved_row_cnt = count($save_row);?> <fieldset> <legend><?= __('Internal relationships') , PMA\libraries\Util::showDocu('config', 'cfg_Servers_relation'); ?></legend> <table id="internal_relations" class="relationalTable"> <tr> <th><?= __('Column'); ?></th> <th><?= __('Internal relation'); ?> <?php if (PMA\libraries\Util::isForeignKeySupported($tbl_storage_engine)): ?> <?= PMA\libraries\Util::showHint(__( 'An internal relation is not necessary when a corresponding' . ' FOREIGN KEY relation exists.')); ?> <?php endif; ?> </th> <?php for ($i = 0; $i < $saved_row_cnt; $i++): ?> <?= PMA\libraries\Template::get('table/relation/internal_relational_row')->render( array( 'save_row' => $save_row, 'i' => $i, 'existrel' => $existrel, 'db' => $db ) ); ?> <?php endfor; ?> </table> </fieldset> <?php if (PMA\libraries\Util::isForeignKeySupported($tbl_storage_engine)): ?> </div> <?php endif; ?> <?php endif; ?> <?php if ($cfgRelation['displaywork']): ?> <?php $save_row = array_values($columns);?> <?php $disp = PMA_getDisplayField($db, $table); ?> <fieldset> <label><?= __('Choose column to display:'); ?></label> <select name="display_field"> <option value="">---</option> <?php foreach ($save_row as $row): ?> <option value="<?= htmlspecialchars($row['Field']); ?>" <?php if (isset($disp) && $row['Field'] == $disp): ?> selected="selected" <?php endif; ?>> <?= htmlspecialchars($row['Field']); ?> </option> <?php endforeach; ?> </select> </fieldset> <?php endif; ?> <fieldset class="tblFooters"> <input type="button" class="preview_sql" value="<?= __('Preview SQL'); ?>" /> <input type="submit" value="<?= __('Save'); ?>" /> </fieldset> </form>