--- alx-src/branches/alx-web-070/scripts/sql-schema/mcore-sql-schema.sh	2016/02/05 12:31:10	8490
+++ alx-src/branches/alx-web-070/scripts/sql-schema/mcore-sql-schema.sh	2016/02/05 13:18:40	8493
@@ -90,9 +90,9 @@
 
 	for ((i=1; i<count; i++))
 	do
-		line="${TABLE_DEFINITION[${i}]}"
-		column="${line%% *}"
-		opts="${line/${column} /}"
+		line=( ${TABLE_DEFINITION[${i}]} )
+		column="${line[0]}"
+		opts="${line[*]:1}"
 
 		case ${opts} in
 			*"PRIMARY KEY"*) opts="${opts//PRIMARY KEY}"; primary="${column}" ;;
@@ -115,6 +115,105 @@
 
 	if [[ -n ${primary} ]]
 	then
+		mysqldo "ALTER TABLE ${MCORE_SQL_DB}.${table} ADD PRIMARY KEY (${primary});" || die "adding primary key to table '${table}'"
+	fi
+	if [[ -n ${autoincrement} ]]
+	then
+		mysqldo "ALTER TABLE ${MCORE_SQL_DB}.${table} MODIFY ${autoincrement} AUTO_INCREMENT;" || die "adding auto_increment to table '${table}'"
+	fi
+}
+
+# TABLE_DEFINITION=(
+#		"table_name"
+#			"column1_name after_column column1_argvs"
+#			"column2_name after_column column2_argvs"
+#			"columnN_name after_column columnN_argvs"
+#	)
+sql_add_column()
+{
+	local table
+	local count
+	local i
+	local line
+	local opts
+	local column
+	local autoincrement
+	local primary
+
+	table="${TABLE_DEFINITION[0]}"
+	count="${#TABLE_DEFINITION[*]}"
+
+	for ((i=1; i<count; i++))
+	do
+		line=( ${TABLE_DEFINITION[${i}]} )
+		column="${line[0]}"
+		after="${line[1]}"
+		opts="${line[*]:2}"
+
+		case ${opts} in
+			*"PRIMARY KEY"*) opts="${opts//PRIMARY KEY}"; primary="${column}" ;;
+			*"primary key"*) opts="${opts//primary key}"; primary="${column}" ;;
+		esac
+
+		case ${opts} in
+			*AUTO_INCREMENT*) opts="${opts//AUTO_INCREMENT}"; autoincrement="${column} ${opts}" ;;
+			*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}'"
+	done
+
+	if [[ -n ${primary} ]]
+	then
+		mysqldo "ALTER TABLE ${MCORE_SQL_DB}.${table} ADD PRIMARY KEY (${primary});" || die "adding primary key to table '${table}'"
+	fi
+	if [[ -n ${autoincrement} ]]
+	then
+		mysqldo "ALTER TABLE ${MCORE_SQL_DB}.${table} MODIFY ${autoincrement} AUTO_INCREMENT;" || die "adding auto_increment to table '${table}'"
+	fi
+}
+
+# TABLE_DEFINITION=(
+#		"table_name"
+#			"column1_name column1_argvs"
+#			"column2_name column2_argvs"
+#			"columnN_name columnN_argvs"
+#	)
+sql_modify_column()
+{
+	local table
+	local count
+	local i
+	local line
+	local opts
+	local column
+	local autoincrement
+	local primary
+
+	table="${TABLE_DEFINITION[0]}"
+	count="${#TABLE_DEFINITION[*]}"
+
+	for ((i=1; i<count; i++))
+	do
+		line=( ${TABLE_DEFINITION[${i}]} )
+		column="${line[0]}"
+		opts="${line[*]:1}"
+
+		case ${opts} in
+			*"PRIMARY KEY"*) opts="${opts//PRIMARY KEY}"; primary="${column}" ;;
+			*"primary key"*) opts="${opts//primary key}"; primary="${column}" ;;
+		esac
+
+		case ${opts} in
+			*AUTO_INCREMENT*) opts="${opts//AUTO_INCREMENT}"; autoincrement="${column} ${opts}" ;;
+			*auto_increment*) opts="${opts//auto_increment}"; autoincrement="${column} ${opts}" ;;
+		esac
+
+		mysqldo "ALTER TABLE ${MCORE_SQL_DB}.${table} MODIFY ${column} ${opts});" || die "modify table '${table}'"
+	done
+
+	if [[ -n ${primary} ]]
+	then
 		mysqldo "ALTER TABLE ${MCORE_SQL_DB}.${table} ADD PRIMARY KEY (${primary});" || die "adding primary key to table '${table}'"
 	fi
 	if [[ -n ${autoincrement} ]]