fuel/core — pull request #659 by crynobone (2011-11-10 05:38:18+00:00)
Title: Add AFTER and FIRST option for ALTER TABLE

This changeset allow to specific use of `FIRST` and `AFTER` in `ALTER TABLE`.

# DBUtil example

```
\DBUtil::add_fields('users_meta', array(
'website_personal' => array('constraint' => 255, 'type' => 'varchar', 'default' => '', 'after' => 'availability_id'),
'website_company' => array('constraint' => 255, 'type' => 'varchar', 'default' => '', 'after' => 'website_personal'),
'profile_status' => array('constraint' => 3, 'type' => 'tinyint', 'default' => 0, 'after' => 'website_company'),
));
```
will output the following SQL

```
ALTER TABLE `users_meta`
ADD `website_personal` varchar(255) DEFAULT '' AFTER `availability_id`,
ADD `website_company` varchar(255) DEFAULT '' AFTER `website_personal`,
ADD `profile_status` tinyint(3) DEFAULT '0' AFTER `profile_status
```

Signed-off-by: crynobone