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

Parent Directory | Revision Log | Patch

	revision 8500 by niro, Fri Feb 5 14:11:39 2016 UTC	revision 8503 by niro, Fri Feb 5 14:34:11 2016 UTC
#	Line 189  sql_modify_column()	Line 189  sql_modify_column()
189	local column	local column
190	local autoincrement	local autoincrement
191	local primary	local primary
192		local current_primary
193
194	table="${TABLE_DEFINITION[0]}"	table="${TABLE_DEFINITION[0]}"
195	count="${#TABLE_DEFINITION[*]}"	count="${#TABLE_DEFINITION[*]}"
#	Line 214  sql_modify_column()	Line 215  sql_modify_column()
215
216	if [[ -n ${primary} ]]	if [[ -n ${primary} ]]
217	then	then
218	mysqldo "ALTER TABLE ${MCORE_SQL_DB}.${table} ADD PRIMARY KEY (${primary});" || die "adding primary key to table '${table}'"	# 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"') )
220		current_primary="${i[0]}"
221		if [[ ${current_primary} != ${primary} ]]
222		then
223		mysqldo "ALTER TABLE ${MCORE_SQL_DB}.${table} ADD PRIMARY KEY (${primary});" || die "adding primary key to table '${table}'"
224		fi
225	fi	fi
226	if [[ -n ${autoincrement} ]]	if [[ -n ${autoincrement} ]]
227	then	then
#	Line 292  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.8500   changed lines   Added in v.8503