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

Parent Directory | Revision Log | Patch

	revision 8493 by niro, Fri Feb 5 13:18:40 2016 UTC	revision 8495 by niro, Fri Feb 5 13:30:51 2016 UTC
#	Line 278  sql_set_value()	Line 278  sql_set_value()
278	create_database()	create_database()
279	{	{
280	create_database_schema	create_database_schema
281
282		# update database version
283		mysqldo "INSERT INTO ${MCORE_SQL_DB}.meta(version) VALUES ('${MCORE_SQL_DB_VERSION}') ON DUPLICATE KEY UPDATE version='${MCORE_SQL_DB_VERSION}';" || die "updating version"
284	}	}
285
286	update_database()	update_database()
#	Line 296  update_database()	Line 299  update_database()
299	# run every update_to_database_version_X script which exist up to version MCORE_SQL_DB_VERSION	# run every update_to_database_version_X script which exist up to version MCORE_SQL_DB_VERSION
300	for i in $(seq $((${current_sql_db_version}+1)) ${MCORE_SQL_DB_VERSION})	for i in $(seq $((${current_sql_db_version}+1)) ${MCORE_SQL_DB_VERSION})
301	do	do
302	if [[ -n $(typeset -f update_to_database_version_${i}) ]]	if [[ -n $(typeset -f update_to_database_schema_version_${i}) ]]
303	then	then
304	echo "Running update_to_database_schema_version_${i}()"	echo "Running update_to_database_schema_version_${i}()"
305	update_to_database_schema_version_${i}	update_to_database_schema_version_${i} || die
306	fi	fi
307	done	done
308
309		# update database version
310		mysqldo "INSERT INTO ${MCORE_SQL_DB}.meta(version) VALUES ('${MCORE_SQL_DB_VERSION}') ON DUPLICATE KEY UPDATE version='${MCORE_SQL_DB_VERSION}';" || die "updating version"
311	}	}
312
313	fill_database()	fill_database()

---

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

Legend: Removed from v.8493   changed lines   Added in v.8495