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 8497 by niro, Fri Feb 5 13:48:23 2016 UTC revision 8498 by niro, Fri Feb 5 13:57:48 2016 UTC
    # Line 279  create_database() Line 279  create_database()
    279  {  {
    280   create_database_schema   create_database_schema
    281    
    282   # update database version   # update database schema version
    283   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"   mysqldo "INSERT INTO ${MCORE_SQL_DB}.meta_schema(version) VALUES ('${MCORE_SQL_DB_SCHEMA_VERSION}') ON DUPLICATE KEY UPDATE version='${MCORE_SQL_DB_SCHEMA_VERSION}';" || die "updating schema version"
    284  }  }
    285    
    286  update_database()  update_database()
    # Line 288  update_database() Line 288  update_database()
    288   local current_sql_db_schema_version   local current_sql_db_schema_version
    289   local i   local i
    290    
    291   current_sql_db_schema_version=$(mysqldo "SELECT MAX(schema_version) from meta;")   current_sql_db_schema_version=$(mysqldo "SELECT MAX(version) from meta_schema;")
    292    
    293   if [[ ${current_sql_db_schema_version} = ${MCORE_SQL_DB_SCHEMA_VERSION} ]]   if [[ ${current_sql_db_schema_version} = ${MCORE_SQL_DB_SCHEMA_VERSION} ]]
    294   then   then
    # Line 306  update_database() Line 306  update_database()
    306   fi   fi
    307   done   done
    308    
    309   # update database version   # update database schema version
    310   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"   mysqldo "INSERT INTO ${MCORE_SQL_DB}.meta_schema(version) VALUES ('${MCORE_SQL_DB_SCHEMA_VERSION}') ON DUPLICATE KEY UPDATE version='${MCORE_SQL_DB_SCHEMA_VERSION}';" || die "updating schema version"
    311  }  }
    312    
    313  fill_database()  fill_database()
    314  {  {
    315     local current_sql_db_values_version
    316     local i
    317    
    318     current_sql_db_values_version=$(mysqldo "SELECT MAX(version) from meta_values;")
    319    
    320     if [[ ${current_sql_db_values_version} = ${MCORE_SQL_DB_VALUES_VERSION} ]]
    321     then
    322     echo "Database values are already up to date"
    323     return 0
    324     fi
    325    
    326   create_database_values   create_database_values
    327     # update database values version
    328     mysqldo "INSERT INTO ${MCORE_SQL_DB}.meta_values(version) VALUES ('${MCORE_SQL_DB_VALUES_VERSION}') ON DUPLICATE KEY UPDATE version='${MCORE_SQL_DB_VALUES_VERSION}';" || die "updating values version"
    329     fi
    330  }  }
    331    
    332  case $1 in  case $1 in
    Legend:
    Removed from v.8497  
    changed lines
      Added in v.8498