$body->line("Index creation on table : <b>" . $req->get('table') . "</b><br>");
$form = new Form();
$form->setAction('controller.php');
$form->setJs(' onsubmit="return PSA.indexcol();" ');
$form->build();
// TODO: check if table name already exists
$name = new Input();
$name->setName('idxname');
$name->setSize(50);
$name->setMaxlength(128);
$name->setId('idxname');
$body->line('Name : ' . $name->dump() . ' ' . $cmd->dump() . '<br>');
for ($i = 0; $i < sizeof($fields); ++$i) {
$select = new Select();
$select->setName('col' . $i);
$select->setSize(1);
$select->add('', '-');
for ($j = 0; $j < sizeof($fields); ++$j) {
$select->add($fields[$j], $fields[$j]);
}
$body->line('index on : ' . $select->dump() . '<br>');
}
$submit->build();
$tblname = new Input();
$tblname->setName('tblname');
$tblname->setSize(128);
$tblname->setValue($req->get('table'));
$tblname->setType('hidden');
$tblname->build();
unset($form);
$body->line('</div>');
$th = new Th();
$th->add('name');
$th->add('type');
$th->add('primary');
$th->add('size');
$th->add('null');
$th->add('default');
$th->build();
$colname = new Input();
$colname->setName('colname');
$colname->setSize(25);
$colname->setMaxlength(128);
$colname->setId('colname');
$coltype = new Select();
$coltype->setName('coltype');
$coltype->setSize(1);
$coltype->setId('coltype');
$coltype->add('VARCHAR', 'VARCHAR');
$coltype->add('INTEGER', 'INTEGER');
$coltype->add('FLOAT', 'FLOAT');
$coltype->add('TEXT', 'TEXT');
$coltype->add('DATETIME', 'DATETIME');
$colprime = new Input();
$colprime->setName('colprime');
$colprime->setType('checkbox');
$colprime->setId('colprime');
$colprime->setJs(' onclick="PSA.checkprimary();" ');
$colsize = new Input();
$colsize->setName('colsize');
$colsize->setSize(7);
$colsize->setMaxlength(7);
