Magellan Linux

  • Back to homepage
    • /[alx-svn]/alx-src/branches/alx-web-070/scripts/sql-schema/mcore-sql-schema.sh

    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 8495 by niro, Fri Feb 5 13:30:51 2016 UTC revision 8496 by niro, Fri Feb 5 13:45:13 2016 UTC
    # Line 280  create_database() Line 280  create_database()
    280   create_database_schema   create_database_schema
    281    
    282   # update database version   # 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"   mysqldo "INSERT INTO ${MCORE_SQL_DB}.meta(version) VALUES ('${MCORE_SQL_DB_SCHEMA_VERSION}') ON DUPLICATE KEY UPDATE version='${MCORE_SQL_DB_SCHEMA_VERSION}';" || die "updating version"
    284  }  }
    285    
    286  update_database()  update_database()
    # Line 290  update_database() Line 290  update_database()
    290    
    291   current_sql_db_version=$(mysqldo "SELECT MAX(version) from meta;")   current_sql_db_version=$(mysqldo "SELECT MAX(version) from meta;")
    292    
    293   if [[ ${current_sql_db_version} = ${MCORE_SQL_DB_VERSION} ]]   if [[ ${current_sql_db_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_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_VERSION})   for i in $(seq $((${current_sql_db_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
    # Line 307  update_database() Line 307  update_database()
    307   done   done
    308    
    309   # update database version   # 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"   mysqldo "INSERT INTO ${MCORE_SQL_DB}.meta(version) VALUES ('${MCORE_SQL_DB_SCHEMA_VERSION}') ON DUPLICATE KEY UPDATE version='${MCORE_SQL_DB_SCHEMA_VERSION}';" || die "updating version"
    311  }  }
    312    
    313  fill_database()  fill_database()
    Legend:
    Removed from v.8495  
    changed lines
      Added in v.8496