278 |
create_database() |
create_database() |
279 |
{ |
{ |
280 |
create_database_schema |
create_database_schema |
281 |
|
|
282 |
|
# update database version |
283 |
|
mysqldo "INSERT INTO ${MCORE_SQL_DB}.meta(version) VALUES ('${MCORE_SQL_DB_VERSION}') ON DUPLICATE KEY UPDATE version='${MCORE_SQL_DB_VERSION}';" || die "updating version" |
284 |
} |
} |
285 |
|
|
286 |
update_database() |
update_database() |
299 |
# run every update_to_database_version_X script which exist up to version MCORE_SQL_DB_VERSION |
# run every update_to_database_version_X script which exist up to version MCORE_SQL_DB_VERSION |
300 |
for i in $(seq $((${current_sql_db_version}+1)) ${MCORE_SQL_DB_VERSION}) |
for i in $(seq $((${current_sql_db_version}+1)) ${MCORE_SQL_DB_VERSION}) |
301 |
do |
do |
302 |
if [[ -n $(typeset -f update_to_database_version_${i}) ]] |
if [[ -n $(typeset -f update_to_database_schema_version_${i}) ]] |
303 |
then |
then |
304 |
echo "Running update_to_database_schema_version_${i}()" |
echo "Running update_to_database_schema_version_${i}()" |
305 |
update_to_database_schema_version_${i} |
update_to_database_schema_version_${i} || die |
306 |
fi |
fi |
307 |
done |
done |
308 |
|
|
309 |
|
# update database version |
310 |
|
mysqldo "INSERT INTO ${MCORE_SQL_DB}.meta(version) VALUES ('${MCORE_SQL_DB_VERSION}') ON DUPLICATE KEY UPDATE version='${MCORE_SQL_DB_VERSION}';" || die "updating version" |
311 |
} |
} |
312 |
|
|
313 |
fill_database() |
fill_database() |