Magellan Linux

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

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 8496 by niro, Fri Feb 5 13:45:13 2016 UTC revision 8497 by niro, Fri Feb 5 13:48:23 2016 UTC
# Line 285  create_database() Line 285  create_database()
285    
286  update_database()  update_database()
287  {  {
288   local current_sql_db_version   local current_sql_db_schema_version
289   local i   local i
290    
291   current_sql_db_version=$(mysqldo "SELECT MAX(version) from meta;")   current_sql_db_schema_version=$(mysqldo "SELECT MAX(schema_version) from meta;")
292    
293   if [[ ${current_sql_db_version} = ${MCORE_SQL_DB_SCHEMA_VERSION} ]]   if [[ ${current_sql_db_schema_version} = ${MCORE_SQL_DB_SCHEMA_VERSION} ]]
294   then   then
295   echo "Database is already up to date"   echo "Database is already up to date"
296   return 0   return 0
297   fi   fi
298    
299   # run every update_to_database_version_X script which exist up to version MCORE_SQL_DB_SCHEMA_VERSION   # run every update_to_database_version_X script which exist up to version MCORE_SQL_DB_SCHEMA_VERSION
300   for i in $(seq $((${current_sql_db_version}+1)) ${MCORE_SQL_DB_SCHEMA_VERSION})   for i in $(seq $((${current_sql_db_schema_version}+1)) ${MCORE_SQL_DB_SCHEMA_VERSION})
301   do   do
302   if [[ -n $(typeset -f update_to_database_schema_version_${i}) ]]   if [[ -n $(typeset -f update_to_database_schema_version_${i}) ]]
303   then   then

Legend:
Removed from v.8496  
changed lines
  Added in v.8497