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