Move comment field after unique field in db forge
diff --git a/system/database/DB_forge.php b/system/database/DB_forge.php
index 6dc2a45..0317489 100644
--- a/system/database/DB_forge.php
+++ b/system/database/DB_forge.php
@@ -814,8 +814,8 @@
}
$this->_attr_auto_increment($attributes, $field);
- $this->_attr_comment($attributes, $field);
$this->_attr_unique($attributes, $field);
+ $this->_attr_comment($attributes, $field);
if (isset($attributes['TYPE']) && ! empty($attributes['CONSTRAINT']))
{
@@ -858,8 +858,8 @@
.$field['default']
.$field['null']
.$field['auto_increment']
- .$field['comment']
- .$field['unique'];
+ .$field['unique']
+ .$field['comment'];
}
// --------------------------------------------------------------------
diff --git a/system/database/drivers/mysql/mysql_forge.php b/system/database/drivers/mysql/mysql_forge.php
index 7053fa1..ee89e1d 100644
--- a/system/database/drivers/mysql/mysql_forge.php
+++ b/system/database/drivers/mysql/mysql_forge.php
@@ -192,8 +192,8 @@
.$field['null']
.$field['default']
.$field['auto_increment']
- .$field['comment']
.$field['unique']
+ .$field['comment']
.$extra_clause;
}
diff --git a/system/database/drivers/mysqli/mysqli_forge.php b/system/database/drivers/mysqli/mysqli_forge.php
index c92d222..e37bd1b 100644
--- a/system/database/drivers/mysqli/mysqli_forge.php
+++ b/system/database/drivers/mysqli/mysqli_forge.php
@@ -194,8 +194,8 @@
.$field['null']
.$field['default']
.$field['auto_increment']
- .$field['comment']
.$field['unique']
+ .$field['comment']
.$extra_clause;
}
diff --git a/system/database/drivers/pdo/subdrivers/pdo_mysql_forge.php b/system/database/drivers/pdo/subdrivers/pdo_mysql_forge.php
index 85b6ebe..2152dea 100644
--- a/system/database/drivers/pdo/subdrivers/pdo_mysql_forge.php
+++ b/system/database/drivers/pdo/subdrivers/pdo_mysql_forge.php
@@ -206,8 +206,8 @@
.$field['null']
.$field['default']
.$field['auto_increment']
- .$field['comment']
.$field['unique']
+ .$field['comment']
.$extra_clause;
}