Diff of /alx-src/branches/alx-web-070/scripts/sql-schema/mcore-sql-schema.sh
Parent Directory | Revision Log | Patch
revision 9464 by niro, Mon Feb 8 13:33:18 2016 UTC | revision 9465 by niro, Thu Apr 6 12:57:54 2017 UTC | |
---|---|---|
# | Line 392 fill_database() | Line 392 fill_database() |
392 | 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" |
393 | } | } |
394 | ||
395 | usage() | |
396 | { | |
397 | echo "Usage: $0 [command]" | |
398 | echo "Commands:" | |
399 | echo " create - creates a new mcore database, the database 'mcore' must exist" | |
400 | echo " update - updates the current database to the newest patchlevel" | |
401 | } | |
402 | ||
403 | case $1 in | case $1 in |
404 | create) | create) |
405 | create_database | create_database |
# | Line 402 case $1 in | Line 410 case $1 in |
410 | update_database | update_database |
411 | fill_database | fill_database |
412 | ;; | ;; |
413 | ||
414 | *) usage ;; | |
415 | esac | esac |
|