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[*]}" |
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 |
299 |
|
|
300 |
if [[ ${current_sql_db_schema_version} = ${MCORE_SQL_DB_SCHEMA_VERSION} ]] |
if [[ ${current_sql_db_schema_version} = ${MCORE_SQL_DB_SCHEMA_VERSION} ]] |
301 |
then |
then |
302 |
echo "Database is already up to date" |
echo "Database schema is already up to date" |
303 |
return 0 |
return 0 |
304 |
fi |
fi |
305 |
|
|