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} ]] |
189 |
local column |
local column |
190 |
local autoincrement |
local autoincrement |
191 |
local primary |
local primary |
192 |
|
local current_primary |
193 |
|
|
194 |
table="${TABLE_DEFINITION[0]}" |
table="${TABLE_DEFINITION[0]}" |
195 |
count="${#TABLE_DEFINITION[*]}" |
count="${#TABLE_DEFINITION[*]}" |
210 |
*auto_increment*) opts="${opts//auto_increment}"; autoincrement="${column} ${opts}" ;; |
*auto_increment*) opts="${opts//auto_increment}"; autoincrement="${column} ${opts}" ;; |
211 |
esac |
esac |
212 |
|
|
213 |
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}'" |
214 |
done |
done |
215 |
|
|
216 |
if [[ -n ${primary} ]] |
if [[ -n ${primary} ]] |
217 |
then |
then |
218 |
mysqldo "ALTER TABLE ${MCORE_SQL_DB}.${table} ADD PRIMARY KEY (${primary});" || die "adding primary key to table '${table}'" |
# only run this if the primary key is not already the same column |
219 |
|
i=( $(mysqldo 'SHOW COLUMNS FROM ${MCORE_SQL_DB}.${table} WHERE `Key`="PRI"') ) |
220 |
|
current_primary="${i[0]}" |
221 |
|
if [[ ${current_primary} != ${primary} ]] |
222 |
|
then |
223 |
|
mysqldo "ALTER TABLE ${MCORE_SQL_DB}.${table} ADD PRIMARY KEY (${primary});" || die "adding primary key to table '${table}'" |
224 |
|
fi |
225 |
fi |
fi |
226 |
if [[ -n ${autoincrement} ]] |
if [[ -n ${autoincrement} ]] |
227 |
then |
then |