db_table_create_sql

db_table_create_sql() - 获得数据表的序列化结构

说明

db_table_create_sql($schema)

参数

示例

$id = array('type' => 'id', 'default' => 12, 'increment' => 'AUTO_INCREMENT');
$sex = array('type' => 'sex', 'default' => 1);
$age = array('type' => 'age', 'default' => 0);
$index = array('fields' => array('id'), 'type' => 'primary');

echo db_table_create_sql(array('tablename' => 'zefeng', 'fields' => array($id, $sex, $age), 'indexes' => array($index), 'engine' => 'InnoDB', 'charset' => 'utf8'));

//CREATE TABLE IF NOT EXISTS `zefeng` ( `` id unsigned NOT NULL DEFAULT '12' AUTO_INCREMENT, `` sex unsigned NOT NULL DEFAULT '1', `` age unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;