Diff of /alx-src/branches/alx-web-070/scripts/sql-schema/mcore-sql-schema.sh

Parent Directory | Revision Log | Patch

	revision 8499 by niro, Fri Feb 5 14:03:20 2016 UTC	revision 8500 by niro, Fri Feb 5 14:11:39 2016 UTC
#	Line 160  sql_add_column()	Line 160  sql_add_column()
160	*auto_increment*) opts="${opts//auto_increment}"; autoincrement="${column} ${opts}" ;;	*auto_increment*) opts="${opts//auto_increment}"; autoincrement="${column} ${opts}" ;;
161	esac	esac
162
163	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} AFTER ${after_column};" || die "add column '${table}'"
164	done	done
165
166	if [[ -n ${primary} ]]	if [[ -n ${primary} ]]
#	Line 209  sql_modify_column()	Line 209  sql_modify_column()
209	*auto_increment*) opts="${opts//auto_increment}"; autoincrement="${column} ${opts}" ;;	*auto_increment*) opts="${opts//auto_increment}"; autoincrement="${column} ${opts}" ;;
210	esac	esac
211
212	mysqldo "ALTER TABLE ${MCORE_SQL_DB}.${table} MODIFY ${column} ${opts});" || die "modify table '${table}'"	mysqldo "ALTER TABLE ${MCORE_SQL_DB}.${table} MODIFY ${column} ${opts};" || die "modify table '${table}'"
213	done	done
214
215	if [[ -n ${primary} ]]	if [[ -n ${primary} ]]

---

Colored Diff Long Colored Diff Full Colored Diff Unidiff Context Diff Side by Side

Legend: Removed from v.8499   changed lines   Added in v.8500