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

Parent Directory | Revision Log | Patch

	revision 8501 by niro, Fri Feb 5 14:31:53 2016 UTC	revision 8503 by niro, Fri Feb 5 14:34:11 2016 UTC
#	Line 216  sql_modify_column()	Line 216  sql_modify_column()
216	if [[ -n ${primary} ]]	if [[ -n ${primary} ]]
217	then	then
218	# only run this if the primary key is not already the same column	# only run this if the primary key is not already the same column
219	i=( $(mysqldo 'SHOW COLUMNS FROM ${MCORE_SQL_DB}.${table} WHERE `Key`="PRI"') )	i=( $(mysqldo 'SHOW COLUMNS FROM '${MCORE_SQL_DB}.${table}' WHERE `Key`="PRI"') )
220	current_primary="${i[0]}"	current_primary="${i[0]}"
221	if [[ ${current_primary} != ${primary} ]]	if [[ ${current_primary} != ${primary} ]]
222	then	then
#	Line 299  update_database()	Line 299  update_database()
299
300	if [[ ${current_sql_db_schema_version} = ${MCORE_SQL_DB_SCHEMA_VERSION} ]]	if [[ ${current_sql_db_schema_version} = ${MCORE_SQL_DB_SCHEMA_VERSION} ]]
301	then	then
302	echo "Database is already up to date"	echo "Database schema is already up to date"
303	return 0	return 0
304	fi	fi
305

---

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

Legend: Removed from v.8501   changed lines   Added in v.8503