PHP-MySQLi-Database-Class
PHP-MySQLi-Database-Class copied to clipboard
Request: create, alter and drop table
Until now I always use $db->rawQuery() for create, alter and drop table. It would be perfect if this is available build in. May be something like this
$db->column('id', 'int(11)', 'unsigned NOT NULL AUTO_INCREMENT')
->column('status', "enum('yes','no')", "NOT NULL DEFAULT 'no'")
->column('created', 'datetime', "NOT NULL DEFAULT '0000-00-00 00:00:00'")
->keyPrimary('id')
->key('key_name', array('status', 'created'))
->tableCreate('user')
+1
+1