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} ]] |
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} ]] |