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 8498 by niro, Fri Feb 5 13:57:48 2016 UTC revision 8500 by niro, Fri Feb 5 14:11:39 2016 UTC
    # Line 160  sql_add_column() Line 160  sql_add_column()
    160   *auto_increment*) opts="${opts//auto_increment}"; autoincrement="${column} ${opts}" ;;   *auto_increment*) opts="${opts//auto_increment}"; autoincrement="${column} ${opts}" ;;
    161   esac   esac
    162    
    163   mysqldo "ALTER TABLE ${MCORE_SQL_DB}.${table} ADD ${column} ${opts}) AFTER ${after_column};" || die "add column '${table}'"   mysqldo "ALTER TABLE ${MCORE_SQL_DB}.${table} ADD ${column} ${opts} AFTER ${after_column};" || die "add column '${table}'"
    164   done   done
    165    
    166   if [[ -n ${primary} ]]   if [[ -n ${primary} ]]
    # Line 209  sql_modify_column() Line 209  sql_modify_column()
    209   *auto_increment*) opts="${opts//auto_increment}"; autoincrement="${column} ${opts}" ;;   *auto_increment*) opts="${opts//auto_increment}"; autoincrement="${column} ${opts}" ;;
    210   esac   esac
    211    
    212   mysqldo "ALTER TABLE ${MCORE_SQL_DB}.${table} MODIFY ${column} ${opts});" || die "modify table '${table}'"   mysqldo "ALTER TABLE ${MCORE_SQL_DB}.${table} MODIFY ${column} ${opts};" || die "modify table '${table}'"
    213   done   done
    214    
    215   if [[ -n ${primary} ]]   if [[ -n ${primary} ]]
    # Line 326  fill_database() Line 326  fill_database()
    326   create_database_values   create_database_values
    327   # update database values version   # 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"   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"
      fi  
    329  }  }
    330    
    331  case $1 in  case $1 in
    Legend:
    Removed from v.8498  
    changed lines
      Added in v.8500