--- alx-src/branches/alx-web-070/scripts/sql-schema/mcore-sql-schema.sh	2016/02/05 15:16:07	8505
+++ alx-src/branches/alx-web-070/scripts/sql-schema/mcore-sql-schema.sh	2016/02/08 08:52:47	8509
@@ -125,10 +125,13 @@
 
 # TABLE_DEFINITION=(
 #		"table_name"
-#			"column1_name after_column column1_argvs"
-#			"column2_name after_column column2_argvs"
-#			"columnN_name after_column columnN_argvs"
+#			"column1_name column1_argvs"
+#			"column2_name column2_argvs"
+#			"columnN_name columnN_argvs"
+#
+# eg.    "description varchar(255) DEFAULT NULL AFTER value"
 #	)
+#
 sql_add_column()
 {
 	local table
@@ -150,8 +153,7 @@
 	do
 		line=( ${TABLE_DEFINITION[${i}]} )
 		column="${line[0]}"
-		after="${line[1]}"
-		opts="${line[*]:2}"
+		opts="${line[*]:1}"
 
 		case ${opts} in
 			*"PRIMARY KEY"*) opts="${opts//PRIMARY KEY}"; primary="${column}" ;;
@@ -163,7 +165,7 @@
 			*auto_increment*) opts="${opts//auto_increment}"; autoincrement="${column} ${opts}" ;;
 		esac
 
-		mysqldo "ALTER TABLE ${MCORE_SQL_DB}.${table} ADD ${column} ${opts} AFTER ${after_column};" || die "add column '${table}'"
+		mysqldo "ALTER TABLE ${MCORE_SQL_DB}.${table} ADD ${column} ${opts};" || die "add column '${table}'"
 	done
 
 	# delete an existing auto_increment first